DOMANDA = htmlentities(htmlspecialchars($record->DOMANDA));
$record->OGGETTO = utf8_decode($record->OGGETTO);
exit(json_encode($record));
}
function listFaq() {
global $LoggedAccount, $CATEGORIE_FAQ;
$response = array();
$draw = $_POST['draw'];
$row = 0; //$_POST['start'];
$rowperpage = 10000000; //$_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();
if ($columnName == "CATEGORIA") {
$columnName = "ID_CATEGORIA";
}
## Search
$searchQuery = " AND PUBBLICATA = 1 AND CANCELLATO = 0 "; //
$searchArray = array();
if ($searchValue != '') {
$searchQuery .= " AND ( REGEXP_LIKE(OGGETTO,:OGGETTO,'i')) ";
$searchArray['OGGETTO'] = $searchValue;
}
$res = Faq::LoadDataTable($searchQuery, $searchArray, $columnName, $columnSortOrder, $row, $rowperpage, false);
foreach ($res['empRecords'] as $row) {
$data[] = array(
"ID" => $row['ID'],
"DATA_INSERIMENTO" => Date::dateOracleTimeStamp($row['DATA_INSERIMENTO'], 'd-m-Y'),
"OGGETTO" => $row['OGGETTO'],
"FAQ" => $row['DOMANDA'],
"CATEGORIA" => "" . $CATEGORIE_FAQ[$row['ID_CATEGORIA']] . ""
// "CATEGORIA" => "".$CATEGORIE_FAQ[$row['ID_CATEGORIA']].""
//"OP" => $btn
);
}
## Response
$response = array(
"draw" => intval($draw),
"iTotalRecords" => $res['iTotalRecords'],
"iTotalDisplayRecords" => $res['iTotalDisplayRecords'],
"aaData" => $data
);
exit(json_encode($response));
}
function saveFaq() {
global $con, $LoggedAccount;
$response = Utils::initDefaultResponse();
$isOpen = Utils::PeriodoFaq(1);
if ($isOpen) {
$filteredInput = Utils::requestDati($_POST);
if (!empty($LoggedAccount->CODICE_FISCALE)) {
// if ($_REQUEST['ID'] > 0) {
// $faq = new FaqUtenti($_REQUEST['ID']);
// } else {
// $faq = new FaqUtenti();
// }
$faq = new FaqUtenti();
// $faq->NOME = Utils::get_filter_string('NOME');
// $faq->COGNOME = Utils::get_filter_string('COGNOME');
$faq->BANDO = $filteredInput['BANDO'];
$faq->DOMANDA = $filteredInput['DOMANDA'];//htmlentities(htmlspecialchars());
// $faq->EMAIL = ($_REQUEST['EMAIL'] != "" ? $_REQUEST['EMAIL'] : $LoggedAccount->SPID_EMAIL );
// $faq->DATA_INSERIMENTO = date("d-m-Y");
$faq->ACCOUNT = $LoggedAccount->CODICE_FISCALE;
$faq->ID_CATEGORIA = $filteredInput['ID_CATEGORIA'];
$response = $faq->Save();
}
}
exit(json_encode($response));
}