BandoCaroVoliBackoffice/webservice/faq.php

<?php

switch ($_REQUEST['action']) {
    case 'load':
        load();
        break;
    case "listDataTable":
        listDataTable();
        break;
    case "save":
        save();
        break;
    case "delete":
        delete();
        break;
    case "riattiva":
        riattiva();
        break;
    case "pubblica":
        pubblica();
        break;
    case "sospendi":
        sospendi();
        break;
}
exit();

function load() {
    $id = Utils::getFromReq("id", 0);
    $record = new Faq($id);
    //$record->OGGETTO = $record->OGGETTO;    
    //$record->DOMANDA = htmlentities($record->DOMANDA);
    //Utils::print_array($record);
    exit(json_encode($record));
}

function listDataTable() {
    global $CATEGORIE_FAQ;
    $draw = $_POST['draw'];
    $row = $_POST['start'];
    $rowperpage = $_POST['length']; // Rows display per page
    $columnIndex = $_POST['order'][0]['column']; // Column index
    $columnName = $_POST['columns'][$columnIndex]['data']; // Column name
    $columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
    $searchValue = $_POST['search']['value']; // Search value
    $data = array();
    $searchArray = array();
    $searchQuery = " AND CANCELLATO = 0 ";
    ## Search     
    if ($searchValue != '') {
        $searchQuery = " AND ( lower(OGGETTO) LIKE :oggetto ) ";
        $searchArray = array(
            'oggetto' => "%$searchValue%",
        );
    }
    $res = Faq::LoadDataTable($searchQuery, $searchArray, $columnName, $columnSortOrder, $row, $rowperpage);
    foreach ($res['empRecords'] as $row) {
        $onclick = 'onclick="siparsFramework.takeCharge(\'' . $row['ID'] . '\',\'faq\', \'load\' )"';
        $fnAddMod = '<a  href="#editFaq" ' . $onclick . ' data-toggle="modal" data-target="#editFaq" class="btn btn-primary "><i class="fas fa-quidditch"></i></a>';
        if ($row['CANCELLATO'] == 0) {
            $onclickDisable = 'onclick="siparsFramework.takeDelete(\'' . $row['ID'] . '\',\'faq\', \'delete\', \'#lista_Faq\' )"';
            $colorBtnDisable = 'btn-success';
            $iconBtnDisable = 'fa-trash';
        } else {
            $onclickDisable = 'onclick="siparsFramework.takeChargeConfirm(\'' . $row['ID'] . '\',\'faq\', \'riattiva\', \'#lista_Faq\' )"';
            $colorBtnDisable = 'btn-danger';
            $iconBtnDisable = "fa-trash";
        }
        if ($row['PUBBLICATA'] == 0) {
            $onclickPubblica = 'onclick="siparsFramework.takeChargeConfirm(\'' . $row['ID'] . '\',\'faq\', \'pubblica\', \'#lista_Faq\' )"';
            $colorBtnPubblica = 'btn-danger';
            $iconBtnPubblica = 'fa-dove';
        } else {
            $onclickPubblica = 'onclick="siparsFramework.takeChargeConfirm(\'' . $row['ID'] . '\',\'faq\', \'sospendi\', \'#lista_Faq\' )"';
            $colorBtnPubblica = 'btn-success';
            $iconBtnPubblica = "fa-dove";
        }
        $fnDisable = '<a href="#" ' . $onclickDisable . ' class="btn ' . $colorBtnDisable . ' waves-effect waves-light "><i class="fas ' . $iconBtnDisable . '"></i></a>';
        $fnPubblica = '<a href="#" ' . $onclickPubblica . ' class="btn ' . $colorBtnPubblica . ' waves-effect waves-light "><i class="fas ' . $iconBtnPubblica . '"></i></a>';
        $data[] = array(
            "ID" => $row['ID'],
            "OGGETTO" => html_entity_decode($row['OGGETTO']),
            "DOMANDA" => html_entity_decode($row['DOMANDA']),
            "CATEGORIA" => $CATEGORIE_FAQ[$row['ID_CATEGORIA']],
            "DATA" => Date::dateOracleTimeStamp($row['DATA_INSERIMENTO'], 'd-m-Y H:i'),
            "PUBBLICATA" => $fnPubblica,
            "CANCELLATO" => $fnDisable,
            "MODIFICA" => $fnAddMod
        );
    }
    ## Response
    $response = array(
        "draw" => intval($draw),
        "iTotalRecords" => $res['iTotalRecords'],
        "iTotalDisplayRecords" => $res['iTotalDisplayRecords'],
        "aaData" => $data
    );

    exit(json_encode($response));
}

function save() {
    $response = Utils::initDefaultResponse();
    if (intval($_POST['ID']) > 0) {
        $rec = new Faq($_POST['ID']);
    } else {
        $rec = new Faq();
        $rec->DATA_INSERIMENTO = Date(FORMAT_TIMESTAMP_ORACLE);
    }
    $rec->OGGETTO = $_POST['OGGETTO'];
    $rec->ID_CATEGORIA = $_POST['ID_CATEGORIA'];        
    $rec->DOMANDA = $_POST['DOMANDA'];//htmlentities(htmlspecialchars($_POST['DOMANDA']));
    $response = $rec->Save();
    exit(json_encode($response));
}

function delete() {
    $id = Utils::getFromReq("id", 0);
    $record = new Faq($id);
    $return = $record->LogicalDelete();

    exit(json_encode($return));
}

function pubblica() {
    $id = Utils::getFromReq("id", 0);
    $record = new Faq($id);
    $return = $record->Pubblica(1);
    exit(json_encode($return));
}

function sospendi() {
    $id = Utils::getFromReq("id", 0);
    $record = new Faq($id);
    $return = $record->Pubblica(0);
    exit(json_encode($return));
}