birichie = isset($_SESSION['bib_app']) ? $_SESSION['bib_app'] : null; $this->ref = $_SESSION['db']->fetch_fields("refman"); if ($id != null) { $result = $_SESSION['db']->execute("SELECT * FROM refman WHERE ri_id=$id"); if ($result && $_SESSION['db']->numrows($result) == 1) { $dati = $_SESSION['db']->fetch($result); foreach ($this->ref as $key => $v) { $this->ref[$key]->value = $dati[$key]; public function __get($fieldname) { if (isset($this->ref[$fieldname])) return $this->ref[$fieldname]->value; elseif (isset($this->rif[$fieldname])) return $this->rif[$fieldname]->value; } public function __set($fieldname, $value) { $this->ref[$fieldname]->value = $value; } public function __isset($fieldname) { return isset($this->ref[$fieldname]); } public function __unset($fieldname) { unset($this->ref[$fieldname]); } public function aggiornaObject($post) { if (isset($post["ri_titolopub"])) parent::aggiornaObject($post); return TRUE; } public function visualizza($input1 = null, $input2 = null) { $form = new FieldsForm("form_riferimento", "javascript:editRiferimento('action_refman.php')"); $form->addHidden("ri_id", $this->ref["ri_id"]->value); $form->addHidden("op", "edit"); $form->addHidden("viewmode", "1"); $form->addHTML("
"); if ($this->ref["rm_stato"]->value != getConstVar("Rif_RichiestaAperta") && $this->ref["rm_stato"]->value != getConstVar("Rif_BiblioChiedeConferma")) { } $form->addHTML("
"); $form->addHTML($this->visualizza_riferimento()); $form->addHTML("
" . getConstVar("REFERENCE_PERSONAL_DATA") . "
"); $form->addHTML($this->visualizza_note()); $form->addHTML($this->visualizza_holding()); $form->addHTML("
"); $form->addHTML($this->visualizza_dati_dd()); $form->close(); return $form->restituisci(); } public function visualizza_riferimento() { $rif = "
"; $rif.=parent::visualizza_intestazione(); $rif.=$this->visualizza_etichette(); $rif.=parent::visualizza(); $rif.="
"; return $rif; } public function visualizza_etichette() { $result_eti = $_SESSION['db']->execute( "SELECT et_nome FROM etichetta WHERE et_id = any ( SELECT et_id FROM rif_eti WHERE ri_id = " . $this->ref["ri_id"]->value . ")" ); $numeti = $_SESSION['db']->numrows($result_eti); $lista_etichette = null; if ($numeti > 0) while ($eti = $_SESSION['db']->fetch($result_eti)) $lista_etichette[] = $eti["et_nome"]; $etichette = "
\n"; $first = TRUE; if (sizeof($lista_etichette) > 0) { for ($i = 0; $i < sizeof($lista_etichette); $i++) { if (!$first) $etichette.= " | "; else $first = FALSE; $etichette.= "" . $lista_etichette[$i] . "\n"; } } $etichette.= "
\n"; return $etichette; } function visualizza_note() { $note = "
"; $note.="
" . getConstVar("REFERENCE_SECTION_NOTES") . "
"; $note.=FieldRender::renderField($this->ref["rm_note"]); $note.="
"; return $note; } function visualizza_holding() { $stampa = false; $holding = "
" . getConstVar("REFERENCE_SECTION_HOLDING") . "
"; foreach ($this->reference_holding as $key => $v) { $var = $this->reference_holding[$key]; $renderedvar = FieldRender::renderField($var); if ($renderedvar != "") { $stampa = true; $holding.=$renderedvar; } } if (!$stampa) { $holding.="
" . getConstVar("NO_HOLDING") . "
"; } $holding.="
"; return $holding; } function visualizza_dati_dd() { $dd = "
\n
\n \n" . FieldRender::renderField($this->ref["rm_stato"]) . "" . getConstVar("REFERENCE_SECTION_DD") . "\n
\n "; $dd.="
\n"; if ($this->ref["rm_stato"]->value != getConstVar("Rif_NonRichiesto")) { $querydd = "SELECT dd_stato_borr, dd_costofuorinilde, dd_stato_accetta FROM docdel WHERE (ri_id = " . $this->ref["ri_id"]->value . ") AND (dd_stato_borr < " . getConstVar("BORR_CONS") . ")"; $resultdd = $_SESSION['db']->execute($querydd); $docdel = $_SESSION['db']->fetch($resultdd); $dd.=FieldRender::renderField($this->ref["rm_datarichie"]); if ($this->ref["rm_stato"]->value != getConstVar("Rif_NonRichiesto")) { $dd.=" - "; $dd.=FieldRender::renderField($this->ref["rm_countbib"]) . "
"; } $dd.=FieldRender::renderField($this->ref["rm_noteutebib"]); switch ($this->ref["rm_polcosti"]->value) { case getConstVar("POL_NON_ACCETTA") : break; case getConstVar("POL_ACCETTA") : break; case getConstVar("POL_INFORMA") : if ($docdel["dd_stato_accetta"] != NULL) { switch ($docdel["dd_stato_accetta"]) { case getConstVar("STATO_ACC_NORISP") : $dd.="
"; break; case getConstVar("STATO_ACC_ACCETTA") : break; case getConstVar("STATO_ACC_RIFIUTA") : break; } } } } if ($this->ref["rm_stato"]->value == getConstVar("Rif_RichiestaChiusa_Eva")) { $dd.="
" . getConstVar("DOC_RECEIVED_ON") . ": " . print_datetime($this->ref["rm_dataeva"]->value, "date") . "
\n"; $dd.=FieldRender::renderField($this->ref["rm_notebibute"]); // DIADOSIS TEAM Add buttons to sent request if (isset($_SESSION['app_stato']) && !in_array($_SESSION['app_stato'], getConstVar('UTENTE_ACL_DD_DENY'))) { if (is_null($this->ri_doi)) $dd .= "ri_pmid . "\"/>"; else $dd .= "ri_doi . "\"/>"; $dd.=" " . getConstVar("SUBMIT") . " "; } else $dd.= "
" . getConstVar('AVVISO_UTENTE_DISABILITATO_FUNZIONE_DD') . "
"; } elseif ($this->ref["rm_stato"]->value == getConstVar("Rif_RichiestaChiusa_Ineva")) { $dd.="
" . getConstVar("DATA_INEVASO") . ": " . print_datetime($this->ref["rm_dataeva"]->value, "date") . "
\n"; $dd.=FieldRender::renderField($this->ref["rm_notebibute"]); // DIADOSIS TEAM Add buttons to NOT sent request if (isset($_SESSION['app_stato']) && !in_array($_SESSION['app_stato'], getConstVar('UTENTE_ACL_DD_DENY'))) { if (is_null($this->ri_doi)) $dd .= "ri_pmid . "\"/>"; else $dd .= "ri_doi . "\"/>"; $dd.=" " . getConstVar("SUBMIT") . " "; } else $dd.= "
" . getConstVar('AVVISO_UTENTE_DISABILITATO_FUNZIONE_DD') . "
"; } elseif ($this->ref["rm_stato"]->value == getConstVar("Rif_NonRichiesto")) { // DIADOSIS TEAM If not requested yet if (isset($_SESSION['app_stato']) && !in_array($_SESSION['app_stato'], getConstVar('UTENTE_ACL_DD_DENY'))) { $dd.=" ref["ri_id"]->value . ")\" title=\"" . getConstVar("SUBMIT") . "\" style=\"margin-right: 8px;\"> " . getConstVar("SUBMIT") . " "; //DIADOSIS TEAM Add edit button for reference here from line 151 $dd.= " " . getConstVar("EDIT") . ""; } else $dd.= "
" . getConstVar('AVVISO_UTENTE_DISABILITATO_FUNZIONE_DD') . "
"; } $dd.="
"; $dd.="
"; return $dd; } function nuovo() { $this->form(true, true); } function nuovo_openurl($tipo) { parent::parse_openurl($tipo); $this->form(true, true); } /** * DIADOSIS TEAM */ function nuovo_doi($tipo) { parent::parse_doi_api($tipo); $this->form(true, true); } function modifica($req = false) { $this->form(false, $req); } private function form($new = false, $req = false) { $controllo = array(); $form = new FieldsForm("form_riferimento", "javascript:editRiferimento('action_refman.php')"); if (!$new) { $form->addHidden("op", "update", null, "\n"); $form->addHidden("ri_id", $this->ref["ri_id"]->value, null, "\n"); } else { $form->addHidden("op", "save", null, "\n"); $form->addHidden("rif_type", $this->rif["ri_tipomateriale"]->value, null, "\n"); $form->addHidden("idute", $this->ref["ut_id"]->value, null, "\n"); } $form->addHidden("viewmode", "0"); $form->addHTML("
"); $controllo_rif = parent::addFormFields($form, $new, $controllo); $controllo = array_merge($controllo, $controllo_rif); $form->addHTML("
" . getConstVar("REFERENCE_PERSONAL_DATA") . "
"); $this->modifica_note($form, $controllo); $this->modifica_holding($form, $controllo); $form->addHTML("
"); $form->addHTML("
"); $form->addHTML("
"); $form->addHTML(getConstVar("REQUIRED_FIELDS")); $form->addHTML("
"); if ($new) { if (isset($_SESSION['app_stato']) && !in_array($_SESSION['app_stato'], getConstVar('UTENTE_ACL_DD_DENY'))) { $form->addHTML("
"); $this->modifica_dati_dd($form, $new, $req, $controllo); $form->addHTML("
" . getConstVar("INSERT_REQUEST") . " \"\"
"); } $form->addHTML("
\"\" " . getConstVar("INSERT") . " \"\"

"); } else if (!$req) { $form->addHTML("
"); // DIADOSIS TEAM Added if for submitting saved or send again already sent requests if ($this->ref["rm_stato"]->value == getConstVar("Rif_NonRichiesto")) { if (is_null($this->ri_doi)) $form->addHidden("doi_sent", $this->ri_pmid); else $form->addHidden("doi_sent", $this->ri_doi); $form->addHTML("
ref["ri_id"]->value . ", 100)\" title=\"\"> " . getConstVar("INSERT_REQUEST") . " \"\"
"); } else { if (is_null($this->ri_doi)) $form->addHidden("doi_sent", $this->ri_pmid); else $form->addHidden("doi_sent", $this->ri_doi); $form->addHTML("
" . getConstVar("INSERT_REQUEST") . " \"\"
"); } $form->addHTML("
" . getConstVar("SAVE") . "
"); } else if (isset($_SESSION['app_stato']) && !in_array($_SESSION['app_stato'], getConstVar('UTENTE_ACL_DD_DENY'))) { $form->addHTML("
"); $this->modifica_dati_dd($form, $new, $req, $controllo); $form->addHTML("
" . getConstVar("SAVE_REQUEST") . "

"); } $form->addHTML("
"); $form->addHTML(""); $code = urlencode(serialize($controllo)); $form->addHidden("controllo", $code); $form->close(); $form->stampa(); } private function modifica_note($form, &$controllo) { $form->addHTML("
" . getConstVar("REFERENCE_SECTION_NOTES") . "
"); $controllo_note = $form->addField($this->ref["rm_note"]); $controllo = array_merge($controllo, $controllo_note); $form->addHTML("
"); } private function modifica_holding($form, &$controllo) { $form->addHTML("
" . getConstVar("REFERENCE_SECTION_HOLDING") . "
"); $form->addHidden("rm_file_old", $this->ref["rm_file"]->value, null, "\n"); foreach ($this->reference_holding as $key => $v) { $controllo_holding = $form->addField($this->reference_holding[$key]); $controllo = array_merge($controllo, $controllo_holding); if ($this->reference_holding[$key]->fieldname == "rm_file" && $this->ref["rm_file"]->value != "") $form->addButton("rm_file_edit_btn", getConstVar("EDIT"), "onclick=\"edit_file('rm_file')\""); } $form->addHTML("
"); } private function modifica_dati_dd($form, $new, $req, &$controllo) { if ($req || $new) { foreach ($this->reference_dd as $key => $v) if (($this->reference_dd[$key]->fieldname != "rm_datarichie" && $this->reference_dd[$key]->fieldname != "rm_dataeva" && $this->reference_dd[$key]->fieldname != "rm_polcosti")) { $controllo_dati_dd = $form->addField($this->reference_dd[$key]); $controllo = array_merge($controllo, $controllo_dati_dd); } $querycostofisso = "SELECT bi_costo_ute_dd, bi_costo_ute_ill FROM biblio WHERE bi_id = " . $this->birichie; $resultcostofisso = $_SESSION['db']->execute($querycostofisso); $costofisso = $_SESSION['db']->fetch_single($resultcostofisso); if ($costofisso != 0) { $form->addHTML("
"); $form->addHTML(getConstVar('costoutenti') . " " . $costofisso . " €"); $form->addHTML("
"); } $form->addHTML("
"); $form->addFieldSelect($this->ref["rm_polcosti"], false, arrayPolcosti(), 1); $form->addHTML("
"); } } function inserisci($post, $req = FALSE) { $idrif = parent::inserisci($post); if ($idrif) { $this->ref["ri_id"]->value = $idrif; if (isset($post["rm_file_old"])) $post["rm_file"] = $post["rm_file_old"]; $dbfields = new ParserField($post); $attributi = "ri_id,ut_id,rm_datains"; $valori = $idrif . "," . $post["idute"] . "," . 'NOW()'; $campi = array($this->ref["rm_note"]); $campi = array_merge($campi, $this->reference_holding); if ($req) $campi = array_merge($campi, $this->reference_dd); for ($i = 0; $i < sizeof($campi); $i++) { $field = $campi[$i]; $key = isset($field->fieldname) ? $field->fieldname : null; if ($key != "rm_datarichie" && $key != "rm_dataeva") { $attributi.="," . $key; $valori.="," . $dbfields->parse($this->ref[$key]); } } if ($attributi != "") { if ($req) { $data = date("Y-m-d H:i:s"); if ($this->birichie > 0) { $query_countbib = " SELECT MAX(rm_countbib) FROM docdel WHERE bi_idrichie = " . $this->birichie; $res_countbib = $_SESSION['db']->execute($query_countbib); $countbib = $_SESSION['db']->fetch_single($res_countbib); if (isset($countbib)) $countbib++; else $countbib = 1; $query_docdel = "INSERT into docdel(bi_idrichie,ri_id,ut_id,rm_countbib,rm_datarichie) VALUES($this->birichie,$idrif," . $post["idute"] . ",$countbib,'$data')"; $res_docdel = $_SESSION['db']->execute($query_docdel); $_SESSION['lastdd_id'] = $_SESSION['db']->last_id(); if ($res_docdel != NULL) { $attributi.=", rm_datarichie, rm_stato, rm_countbib"; $valori.=",'$data'," . getConstVar("Rif_RichiestaAperta") . "," . $countbib; } } } if ((!$req) || ($req && $res_docdel != NULL)) { $query_refman = "INSERT into refman ($attributi) VALUES (" . strip_tags($valori) . ")"; $res_refman = $_SESSION['db']->execute($query_refman); } } } return $idrif; } public function aggiorna($post, $req = null) { $upd_ok = parent::aggiorna($post); if ($upd_ok) { $coppie = ""; if (isset($post["rm_file_old"]) && (!isset($post["rm_file"]) || $post["rm_file"] == "")) $post["rm_file"] = $post["rm_file_old"]; $dbfields = new ParserField($post); $campi = array($this->ref["rm_note"]); $campi = array_merge($campi, $this->reference_holding); if ($req) $campi = array_merge($campi, $this->reference_dd); for ($i = 0; $i < sizeof($campi); $i++) { $field = $campi[$i]; $key = isset($field->fieldname) ? $field->fieldname : null; if ($key != "rm_datarichie" && $key != "rm_dataeva") { if ($coppie != "") $coppie.=","; $coppie.=$key . "=" . $dbfields->parse($this->ref[$key]); } } if ($coppie != "") { if ($req) { $data = date("Y-m-d H:i:s"); if ($this->birichie > 0) { $query2 = " SELECT MAX(rm_countbib) FROM docdel WHERE bi_idrichie = " . $this->birichie; $res2 = $_SESSION['db']->execute($query2); $countbib = $_SESSION['db']->fetch_single($res2); if (isset($countbib)) $countbib++; else $countbib = 1; $query3 = "INSERT into docdel(bi_idrichie,ri_id,ut_id,rm_countbib,rm_datarichie) VALUES(" . $this->birichie . "," . $this->ref["ri_id"]->value . "," . $this->ref["ut_id"]->value . ",$countbib,'$data')"; $res3 = $_SESSION['db']->execute($query3); $_SESSION['lastdd_id'] = $_SESSION['db']->last_id(); if ($res3 != NULL) $coppie.=",rm_datarichie='" . $data . "',rm_stato=" . getConstVar("Rif_RichiestaAperta") . ",rm_countbib=" . $countbib; } } if ((!$req) || ($req && $res3 != NULL)) { $query4 = "UPDATE refman SET $coppie WHERE ri_id=" . $this->ref["ri_id"]->value; $res4 = $_SESSION['db']->execute($query4); return $res4; } } return TRUE; } else return FALSE; } function elimina() { if ($this->ref["rm_stato"]->value != getConstVar("Rif_RichiestaAperta") && $this->ref["rm_stato"]->value != getConstVar("Rif_BiblioChiedeConferma")) { if ($this->ref["rm_stato"]->value == getConstVar("Rif_NonRichiesto")) { $del_ok = parent::elimina(); if ($del_ok) { unset($this->rif); return $del_ok; } } else { $this->ref["rm_stato"]->value = getConstVar("Rif_Eliminato"); $query_1 = "UPDATE refman SET rm_cancella=1 WHERE ri_id=" . $this->ref["ri_id"]->value; $result_1 = $_SESSION['db']->execute($query_1); $query_2 = "DELETE FROM rif_eti WHERE ri_id = " . $this->ref["ri_id"]->value; $result_2 = $_SESSION['db']->execute($query_2); unset($this->rif); return TRUE; } } return FALSE; } function rispostaFN($risp) { if ($risp == "accetta") $query_dd = "UPDATE docdel SET dd_stato_borr=" . getConstVar("BORR_UTE_ACCETTA_FN") . ", dd_stato_accetta=" . getConstVar("STATO_ACC_ACCETTA") . " WHERE ri_id=" . $this->ref["ri_id"]->value . " AND dd_stato_accetta=" . getConstVar("STATO_ACC_NORISP"); elseif ($risp == "rifiuta") $query_dd = "UPDATE docdel SET dd_stato_borr=" . getConstVar("BORR_UTE_RIFIUTA_FN") . ", dd_stato_accetta=" . getConstVar("STATO_ACC_RIFIUTA") . " WHERE ri_id=" . $this->ref["ri_id"]->value . " AND dd_stato_accetta=" . getConstVar("STATO_ACC_NORISP"); $result_dd = $_SESSION['db']->execute($query_dd); if ($result_dd) { $query_rm = "UPDATE refman SET rm_stato=" . getConstVar("Rif_RichiestaAperta") . " WHERE ri_id=" . $this->ref["ri_id"]->value; $result_rm = $_SESSION['db']->execute($query_rm); return true; } else return false; } public function controlla_campi($post) { return parent::controlla_campi($post); } public function controlla_campi_richiesta($post) { return parent::controlla_campi_richiesta($post); } private function DDbuttons() { $s = ""; return $s; } } ?>