<?php
require_once ROOT . "/lib/classes/IDataClass.php";
/**
 * Description of Faq
 *
 * @author Anselmo
 */
class Faq extends DataClass {

    const TABLE_NAME = "FAQ";
    const SEQ_NAME = "FAQ_ID_SEQ";

    public $ID = 0; // Primary key    
    public $ID_UID_FIEBASE_ADMIN = 0;
    public $OGGETTO = "";
    public $DOMANDA = "";
    public $PUBBLICATA = 0;
    public $CANCELLATO = 0;
    public $DATA_INSERIMENTO = 'SYSTIMESTAMP';
    public $ID_CATEGORIA = 0;

    public function __construct($src = null) {
        global $con;
        if ($src == null){
            return;
        }
        if (is_array($src)) {
            if (isset($src['ID']) && $src['ID'] > 0) {
                $this->_loadAndFillObject($src['ID'], self::TABLE_NAME, $src);
            } else {
                $this->_loadByRow($src, $stripSlashes);
            }
        } elseif (intval($src)) {

            $sql = "SELECT * FROM " . self::TABLE_NAME . " WHERE ID = :id";
            $query = $con->prepare($sql);
            $query->bindParam(":id", $src);
            try {
                $query->execute();
                $it = $query->fetchAll(PDO::FETCH_ASSOC);
                Utils::FillObjectFromRow($this, $it[0]);
            } catch (Exception $exc) {
                $exc->getMessage();
            }
        }
    }

    /**
     * Restituisce il totale i
     *
     * @param bool $filter Se specificato, filtra i comune in funzione dei parametri specificati in esso specificato
     * @return int
     */
    public static function Count($filter = null) {
        return parent::_count(self::TABLE_NAME, $filter);
    }

    public static function LoadDataTable($searchQuery = "", $searchArray = array(), $columnName = array(), $columnSortOrder = array(), $start = 0, $offset = 0, $totCount = false) {
        return parent::_loadDataTable(self::TABLE_NAME, $searchQuery, $searchArray, $columnName, $columnSortOrder, $start, $offset, $totCount);
    }

    public function Save() {
        global $con, $LoggedAccount;
        $this->ID_UID_FIEBASE_ADMIN = $LoggedAccount->ID;
        $vars = get_object_vars($this);
        $sql = Utils::prepareQuery(self::TABLE_NAME, $vars);
        $queryabi = $con->prepare($sql);        
        foreach ($vars as $k => $v) {
            if ($k == "ID" && $v == 0) {                
                continue;
            }
            $queryabi->bindValue(":" . $k, $v);
        }

        try {
            $it = parent::_Save($queryabi);
        } catch (Exception $exc) {
            $it['erroreDescrizione'] = $exc->getMessage();
        }
        return $it;
    }
    
    public function SaveOCI() {
        global $conOCI, $LoggedAccount;
        $this->ID_UID_FIEBASE_ADMIN = $LoggedAccount->ID;
        $vars = get_object_vars($this);
        $sql = Utils::prepareQuery(self::TABLE_NAME, $vars);
        $statement = $conOCI->db_getStatement($sql);
        $ins = false;
        foreach ($vars as $k => $v) {
            if ($k == "ID" && $v == 0) {
                $ins = true;
                continue;
            }
            if ($k == "DATA_INSERIENTO" && $ins) {
                oci_bind_by_name($statement, ":" . $k, date('d-m-Y'));
            } else {
                oci_bind_by_name($statement, ":" . $k, $v);
            }
        }
        try {
            $it = $conOCI->db_execute($statement);
            $conOCI->db_free_statement($statement);
            $conOCI->db_close();
        } catch (Exception $exc) {
            $it['erroreDescrizione'] = $exc->getMessage();
            $conOCI->db_free_statement($statement);
            $conOCI->db_close();
        }
        return $it;
    }

    public function Delete() {
        return parent::_Delete(self::TABLE_NAME, "ID = " . $this->ID);
    }

    /**
     * Load List Faq with PDO connection
     */
    public function Load($id_categoria = 0, $cancellato = 0) {
        global $con;
        $where = "PUBBLICATA = 1 ";
        $order = " ORDER BY ID";
        if (intval($cancellato) >= 0){
            $where .= ($where == "" ? "" : " AND ") . "CANCELLATO = :cancellato";
        }
        if (intval($id_categoria) >= 0){
            $where .= ($where == "" ? "" : " AND ") . "ID_CATEGORIA = :id_categoria";
        }

        $sql = "SELECT * FROM " . self::TABLE_NAME;
        if ($where != ""){
            $sql .= " WHERE $where $order";
        }

        $query = $con->prepare($sql);
        if (intval($cancellato) >= 0){
            $query->bindParam(":CANCELLATO", intval($cancellato));
        }
        if (intval($id_categoria) >= 0){
            $query->bindParam(":ID_CATEGORIA", intval($id_categoria));
        }
        try {
            $query->execute();
            $res = $query->fetchAll(PDO::FETCH_ASSOC);
        } catch (Exception $exc) {
            $res['esito'] = -999;
            $res['erroreDescrizione'] = $exc->getMessage();
        }
        return $res;
    }

    /**
     * Load List Faq with OCI connection
     */
    public function LoadOCI($id_categoria = 0, $cancellato = 0) {
        global $conOCI;
        $rows = array();
        $where = "PUBBLICATA = 1 ";
        $order = " ORDER BY ID";
        $id_categoria = intval($id_categoria);
        $cancellato = intval($cancellato);
        if ($cancellato >= 0) {
            $where .= ($where == "" ? "" : " AND ") . "CANCELLATO = :CANCELLATO";
        }
        if ($id_categoria >= 0) {
            $where .= ($where == "" ? "" : " AND ") . "ID_CATEGORIA = :ID_CATEGORIA";
        }
        $sql = "SELECT * FROM " . self::TABLE_NAME;
        if ($where != "") {
            $sql .= " WHERE $where $order";
        }
        try {
            $statement = $conOCI->db_getStatement($sql);
            if ($cancellato >= 0) {
                oci_bind_by_name($statement, ":CANCELLATO", $cancellato);
            }
            if ($id_categoria > 0) {
                oci_bind_by_name($statement, ":ID_CATEGORIA", $id_categoria);
            }
            $rows = $conOCI->db_fetch_assoc($statement);
            $conOCI->db_free_statement($statement);
            $conOCI->db_close();
        } catch (Exception $exc) {
            $rows['esito'] = -999;
            $rows['erroreDescrizione'] = $exc->getMessage();
            $conOCI->db_free_statement($statement);
            $conOCI->db_close();
        }
        return $rows;
    }

    /**
     * Elimina l'oggetto corrente dal database e restituisce TRUE se ha successo
     *
     * @return bool Risultato booleano dell'operazione
     */
    public function LogicalDelete() {
        return parent::_LogicalDelete(self::TABLE_NAME, "ID = " . $this->ID);
    }

    /**
     * Funzione per la visualizzazione dei logs
     * @param type $record
     * @param type $campo
     */
    public function Parse(&$record, $campo = "") {
        
        array_push($record, array("Campo" => $campo, "Valore" => $this->$campo));
        
    }

}

class FaqUtenti extends DataClass {

    const TABLE_NAME = "FAQ_UTENTI";
    const SEQ_NAME = "FAQ_UTENTI_ID_SEQ";
    const SP_ = "SPFAQUTENTISAVE";

    public $ID = 0; // Primary key    
    public $ACCOUNT = '';
    public $DOMANDA = "";
    public $DATA_INSERIMENTO = null;
    public $NOME = '';
    public $COGNOME = '';
    public $EMAIL = '';
    public $STATO = 0;
    public $ID_CATEGORIA = 0;

    public function __construct($src = null) {
        global $con;
        if ($src == null){
            return;
        }
        if (is_array($src)) {
            if (isset($src['ID']) && $src['ID'] > 0) {
                $this->_loadAndFillObject($src['ID'], self::TABLE_NAME, $src);
            } else {
                $this->_loadByRow($src, $stripSlashes);
            }
        } elseif (intval($src)) {

            $sql = "SELECT * FROM " . self::TABLE_NAME . " WHERE ID = :id";
            $query = $con->prepare($sql);
            $query->bindParam(":id", $src);
            try {
                $query->execute();
                $it = $query->fetchAll(PDO::FETCH_ASSOC);
                Utils::FillObjectFromRow($this, $it[0]);
            } catch (Exception $exc) {
                $exc->getMessage();
            }
        }
    }
    
    public static function LoadByIDOCI($id = 0){
        global $conOCI;
        $faq = new FaqUtenti();
        try {
            $sql = "SELECT * FROM " . self::TABLE_NAME . " WHERE ID = :id ";
            $statement = $conOCI->db_getStatement($sql);
            oci_bind_by_name($statement, ":id", $id);
            $row = $conOCI->db_fetch_array($statement);
            if (intval($row['ID']) > 0) {
                Utils::FillObjectFromRow($faq, $row);
            }
            $conOCI->db_free_statement($statement);
            $conOCI->db_close();
        } catch (Exception $exc) {
            $conOCI->db_free_statement($statement);
            $conOCI->db_close();
        }
    }

    /**
     * Restituisce il totale i
     *
     * @param bool $filter Se specificato, filtra i comune in funzione dei parametri specificati in esso specificato
     * @return int
     */
    public static function Count($filter = null) {
        return parent::_count(self::TABLE_NAME, $filter);
    }

    public static function LoadDataTable($searchQuery = "", $searchArray = array(), $columnName = array(), $columnSortOrder = array(), $start = 0, $offset = 0) {

        return parent::_loadDataTable(self::TABLE_NAME, $searchQuery, $searchArray, $columnName, $columnSortOrder, $start, $offset);
    }

    public function Save() {
        global $con;
        $vars = get_object_vars($this);
        unset($vars['DATA_INSERIMENTO']);
        $sql = Utils::prepareQuery(self::TABLE_NAME, $vars);

        $query = $con->prepare($sql);
        foreach ($vars as $k => $v) {
            if ($k == "ID" && $v == 0) {
                continue;
            }
            $query->bindValue(":" . $k, $v);
        }

        try {
            $it = parent::_Save($query);
        } catch (Exception $exc) {
            $it['erroreDescrizione'] = $exc->getMessage();
        }
        return $it;

    }

    public function Delete() {
        return parent::_Delete(self::TABLE_NAME, "ID = " . $this->id);
    }

    /**
     * Elimina l'oggetto corrente dal database e restituisce TRUE se ha successo
     *
     * @return bool Risultato booleano dell'operazione
     */
    public function LogicalDelete() {
        return parent::_LogicalDelete(self::TABLE_NAME, "ID = " . $this->id);
    }

    /**
     * Funzione per la visualizzazione dei logs
     * @param type $record
     * @param type $campo
     */
    public function Parse(&$record, $campo = "") {        
         array_push($record, array("Campo" => $campo, "Valore" => $this->$campo));
        
    }

}