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 = '';
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 = '';
$fnPubblica = '';
$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));
}