private function initPratica()
{
$db = $this->db1;
if ($this->pratica && is_numeric($this->pratica)) {
//INFORMAZIONI SULLA PRATICA
$sql = "SELECT numero,tipo,resp_proc,resp_it,resp_ia,date_part('year',data_presentazione) as anno,data_presentazione,data_prot FROM pe.avvioproc WHERE pratica=?";
$r = $db->fetchAssoc($sql, array($this->pratica));
$this->info = $r;
if ($this->info['tipo'] < 10000 || in_array($this->info['tipo'], array(14000, 15000))) {
$this->tipopratica = 'pratica';
} elseif ($this->info['tipo'] < 13000) {
$this->tipopratica = 'dia';
} else {
$this->tipopratica = 'ambientale';
}
$numero = appUtils::normalizeNumero($this->info['numero']);
$tmp = explode('-', $numero);
if (count($tmp) == 2 && preg_match("|([A-z0-9]+)|", $tmp[0])) {
$tmp[0] = preg_match("|^[89]|", $tmp[0]) ? "19" . $tmp[0] : $tmp[0];
$numero = implode('-', $tmp);
}
$anno = $r['anno'] ? $r['anno'] : $tmp[0];
//Struttura delle directory
$arrDir = array(DATA_DIR, 'praticaweb', 'documenti', $anno);
$this->annodir = implode(DIRECTORY_SEPARATOR, $arrDir) . DIRECTORY_SEPARATOR;
$arrDir[] = $numero;
$this->documenti = implode(DIRECTORY_SEPARATOR, $arrDir) . DIRECTORY_SEPARATOR;
$arrDir[] = "allegati";
$this->allegati = implode(DIRECTORY_SEPARATOR, $arrDir) . DIRECTORY_SEPARATOR;
$arrDir[] = "tmb";
$this->allegati_tmb = implode(DIRECTORY_SEPARATOR, $arrDir) . DIRECTORY_SEPARATOR;
$this->url_documenti = "/documenti/{$anno}/{$numero}/";
$this->url_allegati = "/documenti/{$anno}/{$numero}/allegati/";
$this->smb_documenti = SMB_PATH . "{$anno}/{$numero}/";
$this->createStructure();
//INFO PRATICA PREC E SUCC
$sql = "SELECT max(pratica) as pratica FROM pe.avvioproc WHERE pratica < ?";
$this->prev = $db->fetchColumn($sql, array($this->pratica));
$sql = "SELECT min(pratica) as pratica FROM pe.avvioproc WHERE pratica > ?";
$this->next = $db->fetchColumn($sql, array($this->pratica));
}
//ESTRAGGO INFORMAZIONI SUL DIRIGENTE
$sql = "SELECT userid as dirigente FROM admin.users WHERE attivato=1 and '13' = ANY(string_to_array(coalesce(gruppi,''),','));";
$dirig = $db->fetchColumn($sql);
$this->info['dirigente'] = $dirig;
//ESTRAGGO INFORMAZIONI SUL RESPONSABILE DEL SERVIZIO
$sql = "SELECT userid as rds FROM admin.users WHERE attivato=1 and '15' = ANY(string_to_array(coalesce(gruppi,''),','));";
$rds = $db->fetchColumn($sql);
$this->info['rds'] = $rds;
//INFO UTENTE (ID-GRUPPI-NOME)
$this->userid = $_SESSION['USER_ID'];
$this->usergroups = $_SESSION['GROUPS'];
$sql = "SELECT username FROM admin.users WHERE userid=?";
$this->user = $db->fetchColumn($sql, array($this->userid));
}
