<?php

require_once "IDataClass.php";
/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */

/**
 * Description of FixFile
 *
 * @author Anselmo
 */
class FixFile extends DataClass {
    const TABLE_NAME = "DOMANDA_FILE_DEF";
    
    
    public $ID = 0; // Primary key
    public $CODICE_FISCALE_LEGALE = null;
    public $CODICE_FISCALE_IMPRESA = null;
    public $DOMANDA_JSON = null;
    public $STATO = 0;
    public $FILEPATH = null;
    public $HASH_FILE = null;
    public $DATA_INSERIMENTO = null;
    public $DATA_MODIFICA = null;
    public $DATA_COMPLETAMENTO = null;
    public $ID_SEDEOPERATIVA = null;
    public $SPID_MOBILE_PHONE = "";
    public $SPID_TIPO_DOCUMENTO = "";
    public $SPID_NUMERO_DOCUMENTO = "";
    public $SPID_ENTE_RILASCIO = "";
    public $SPID_DATA_RILASCIO = "";
    public $SPID_DATA_SCADENZA = "";
    public $INFO_PEC = "";
    public $RECAPITO_TELEFONICO = ""; //IMPRESA
    public $DATA_APERTURA_SEDE_LEGALE = "";
    public $IBAN = null;
    public $ISTITUTO_DI_CREDITO = "";
    public $FILIALE_DI = "";
    public $CONTRIBUTO_DICHIARATO = ""; // CONTRIBUTO CALCOLATO 
    public $INFO_ADDETTI = "";
    public $ADDETTI_DICHIARATI = 0; // Ultimo bilancio disponibile (2019)
    public $DENOMINAZIONE_IMPRESA = "";
    public $DATA_SPORTELLO = "";
    public $SEDEOPERATIVA_COMUNE = "";
    public $SEDEOPERATIVA_PROVINCIA = "";
    public $DECRETO = "";
    public $FILEPATH_DECRETO = "";
    public $DATA_DECRETO = "";
    public $DATA_INIZIO_ATTIVITA = ""; // Sede per la quale è richiesto il contributo
    public $VOLUME_AFFARI_DICHIARATO_2018 = ""; // BIlancio 2018
    public $VOLUME_AFFARI_DICHIARATO = ""; // Ultimo bilancio disponibile (2019)
    public $REGIME_FISCALE = 0;
    public $COLLEGATA = 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);
                $it[0]['DOMANDA_JSON'] = stream_get_contents($it[0]['DOMANDA_JSON']);
                Utils::FillObjectFromRow($this, $it[0]);
            } catch (Exception $exc) {
                $exc->getMessage();
            }
        }
       
    }
    
    public function LoadAll() {
        global $con;
        $where = "";
        //$order = " ORDER BY ID";
        
        $sql = "SELECT ID, CODICE_FISCALE_IMPRESA FROM " . self::TABLE_NAME. " ORDER BY ID";
        if ($where != "")
            $sql .= " WHERE $where $order";
        $query = $con->prepare($sql);
        
        try {
            $query->execute();
            $it = $query->fetchAll(PDO::FETCH_ASSOC);
        } catch (Exception $exc) {
            $it['esito'] = -999;
            $it['descrizioneErrore'] = $exc->getMessage();
        }

        return $it;
    }
    
    public function verificaDeroga($codice_fiscale = "") {
        global $con;
        $return = array();
        $verify = $con->prepare("SELECT ID FROM " . self::TABLE_NAME . " WHERE CODICE_FISCALE_LEGALE=:cod ");
        $verify->bindParam(":cod", $codice_fiscale);        
        try {
            $verify->execute();
            $itVerify = $verify->fetch(PDO::FETCH_ASSOC);
            if (intval($itVerify['ID']) > 0) {
                $return['ID'] = $itVerify['ID'];
                $return['esito'] = 1;
            } else {
                $return['esito'] = -999;
                $return['descrizioneErrore'] = 'Record non trovato';
            }
        } catch (Exception $exc) {
            $return['esito'] = -999;
            $return['descrizioneErrore'] = $exc->getMessage();
        }
        return $return;
    }
    
    public function selectIdFromCodiceF($codice_fiscale = "", $cod_fis_impresa = "") {
        global $con;
        $return = array();
        $verify = $con->prepare("SELECT ID FROM " . self::TABLE_NAME . " WHERE CODICE_FISCALE_LEGALE=:cod AND CODICE_FISCALE_IMPRESA=:cod_fis_impresa ");
        $verify->bindParam(":cod", $codice_fiscale);
        $verify->bindParam(":cod_fis_impresa", $cod_fis_impresa);
        try {
            $verify->execute();
            $itVerify = $verify->fetch(PDO::FETCH_ASSOC);
            if (intval($itVerify['ID']) > 0) {
                $return['ID'] = $itVerify['ID'];
                $return['esito'] = 1;
            } else {
                $return['esito'] = -999;
            }
        } catch (Exception $exc) {
            $return['esito'] = -999;
            $return['descrizioneErrore'] = $exc->getMessage();
        }
        return $return;
    }
    
    
    
    /**
     * Restituisce la sede operativa scelta per la presentazione della domanda
     * @param type $arraySediOperative
     * @return type
     */
    public function GetImpresaOperativa($arraySediOperative = array()) {
        $return = array();
        if (count($arraySediOperative) > 0) {
            $return = $arraySediOperative[$this->ID_SEDEOPERATIVA];
        }
        return $return;
    }
    
    
    public function UploadFix() {
        global $con;
            $res = array();
       
            $sql = "UPDATE " . self::TABLE_NAME . " SET FILEPATH = '".$this->FILEPATH."', HASH_FILE = '".$this->HASH_FILE."' WHERE ID = " . $this->ID;
            $query = $con->prepare($sql);

            try {
                $query->execute();
                $res['esito'] = 1;
            } catch (Exception $exc) {
                $res['esito'] = -999;
                echo $exc->getMessage();
                $res['erroreDescrizione'] = $exc->getMessage();
            }
       

        return $res;
    }
    
    public function Save() {
        global $con;
        $vars = get_object_vars($this);
        
        $sql = Utils::prepareQuery(self::TABLE_NAME, $vars);
        //echo $sql;exit();
        $queryabi = $con->prepare($sql);
        //Utils::print_array($LoggedAccount);exit();
        foreach ($vars as $k => $v) {
            if ($k == "ID" && $v == 0)
                continue;
            $queryabi->bindValue(":" . $k, $v);
        }
        try {
            $it = parent::_Save($queryabi);
        } catch (Exception $exc) {
            $it['descrizioneErrore'] = $exc->getMessage();
        }
//        $it['sql']=$sql;
        return $it;
    }
}