execute(
"SELECT COUNT(rif.ri_id)
FROM refman ref, riferimento rif
WHERE rif.ri_id = ref.ri_id AND ref.rm_cancella = 0 AND rif.ri_id = any (
SELECT rif_eti.ri_id
FROM rif_eti
WHERE rif_eti.et_id = " . $label . ")"
);
$result = $_SESSION['db']->execute(
"SELECT rif.ri_id, ri_titolopub, ri_au1, ri_anno, rm_stato, ri_titolopart, rm_datarichie, rm_dataeva, rm_notebibute, rm_noteutebib, rm_cancella
FROM refman ref, riferimento rif
WHERE rif.ri_id = ref.ri_id AND ref.rm_cancella = 0 AND rif.ri_id = any (
SELECT rif_eti.ri_id
FROM rif_eti
WHERE rif_eti.et_id = " . $label . ")
ORDER BY " . $order . " " . $qualif . "
LIMIT " . $start . ", " . $passo
);
}
else {
$result_count = $_SESSION['db']->execute(
"SELECT COUNT(ri_id)
FROM refman
WHERE ut_id = " . $idute . " AND rm_cancella = 0"
);
$result = $_SESSION['db']->execute(
"SELECT rif.ri_id, ri_titolopub, ri_au1, ri_anno, rm_stato, ri_titolopart, rm_datarichie, rm_dataeva, rm_notebibute, rm_noteutebib, rm_cancella
FROM refman ref, riferimento rif
WHERE ref.ut_id = " . $idute . " AND ref.rm_cancella = 0 AND ref.ri_id = rif.ri_id
ORDER BY " . $order . " " . $qualif . "
LIMIT " . $start . ", " . $passo
);
}
$arr = $_SESSION['db']->fetch($result_count, 2);
$max = $arr[0];
$cols = $_SESSION['db']->numcols($result);
for ($j = 0; $j < $cols; $j++) {
$flds[$j] = $_SESSION['db']->fieldname($result, $j);
}
$ret.=Bibliografia::navigation_bar($idute, $label, $start, $passo, $max);
$ret.=" \n";
$ret.="
\n";
$ret.="
\n";
$ret.="
\n";
$ret.="
\n";
$ret.="
\n";
$ret.=" \n";
$ret.=" \n";
$ret.=" | \n";
for ($j = 1; $j < 5; $j++) {
if ($flds[$j] == $order) {
if ($qualif == "asc")
$ret.=" ![](\"images/mynilde/empty1.gif\") " . getConstVar($flds[$j]) . " | \n";
else
$ret.=" " . getConstVar($flds[$j]) . " | \n";
} else
$ret.=" " . getConstVar($flds[$j]) . " | \n";
}
$ret.=" " . getConstVar("DD_INFOS") . " | \n";
$rowspan = 1 + $passo;
if ($_SESSION['db']->numrows($result) == 0)
$dd_link = "";
else
$ret.="
\n";
$i = 0;
$query = "SELECT et_nome
FROM etichetta
WHERE et_id = any (
SELECT et_id
FROM rif_eti
WHERE ri_id = ?)";
$bibliografiaSTMT = $_SESSION['db']->prepareSTMT($query);
if (!$bibliografiaSTMT) {
echo 'Errore: creazione preparestatement per bibliografia';
die;
}
if ($_SESSION['db']->numrows($result) == 0)
$ret.="| " . getConstVar("NOREFERENCES") . " | |
";
else
while ($row = $_SESSION['db']->fetch($result)) {
$itemcl = "item1";
if ($i % 2 != 0)
$itemcl = "item2";
$riid = $row[$flds[0]];
$ret.="\n";
$idrif[$i] = $row["ri_id"];
$ret.=Form::getCheckBox("idrif[]", $idrif[$i], "", null, "| ", " | \n");
$ret.="\n";
$ret.=" " . $row["ri_titolopub"] . " " . $row["ri_titolopart"] . " \n";
$bibliografiaSTMT->bind_param('i', $idrif[$i]);
$bibliografiaSTMT->execute();
$bibliografiaSTMT->bind_result($et_nome);
$first = TRUE;
$ret.="\n";
while ($bibliografiaSTMT->fetch()) {
if (!$first)
$ret.=" | ";
else
$first = FALSE;
$ret.="" . $et_nome . "\n";
}
$ret.=" \n";
$ret.=" | \n";
$ret.="" . $row["ri_au1"] . " | \n";
$ret.="" . $row["ri_anno"] . " | \n";
$ret.="" . fieldrender::render("rm_stato", $row["rm_stato"]) . " | \n";
$ret.=" \n";
$ret.=" \n";
if ($row["rm_stato"] == getConstVar("Rif_NonRichiesto")) {
if (isset($_SESSION['app_stato']) && !in_array($_SESSION['app_stato'], getConstVar('UTENTE_ACL_DD_DENY')))
$ret.= "
" . getConstVar("SUBMIT") . "
";
else
$ret.=getConstVar('AVVISO_UTENTE_DISABILITATO_FUNZIONE_DD');
}
elseif ($row["rm_stato"] == getConstVar("Rif_RichiestaAperta")) {
$ret.=FieldRender::render("rm_datarichie", $row["rm_datarichie"]);
$ret.=FieldRender::render("rm_noteutebib", $row["rm_noteutebib"]);
} elseif ($row["rm_stato"] == getConstVar("Rif_BiblioChiedeConferma")) {
$ret.=FieldRender::render("rm_datarichie", $row["rm_datarichie"]);
$ret.=FieldRender::render("rm_noteutebib", $row["rm_noteutebib"]);
$ret.=" Attenzione! Richiesta accettazione costo ";
} elseif ($row["rm_stato"] == getConstVar("Rif_RichiestaChiusa_Eva")) {
$ret.=" " . getConstVar("DOC_RECEIVED_ON") . ": " . print_datetime($row["rm_dataeva"], "date") . " \n";
$ret.=FieldRender::render("rm_notebibute", $row["rm_notebibute"]);
} elseif ($row["rm_stato"] == getConstVar("Rif_RichiestaChiusa_Ineva")) {
$ret.=" " . getConstVar("DOC_NOT_DELIVERED") . ": " . print_datetime($row["rm_dataeva"], "date") . " \n";
$ret.=FieldRender::render("rm_notebibute", $row["rm_notebibute"]);
}
$ret.=" | \n";
$ret.="
\n";
$i++;
}
$bibliografiaSTMT->close();
$ret.="
\n";
$ret.=Bibliografia::navigation_bar_bottom($start, $passo, $max);
return $ret;
}
public static function reference_list_tool($idute) {
$ret = "";
$ret.=" \n";
return $ret;
}
private static function navigation_bar($idute, $label, $start, $passo, $max) {
$ret = "";
$ret.=" \n";
$ret.=Bibliografia::label_filter($idute, $label, $passo);
$ret.=Bibliografia::nav_control($start, $passo, $max);
$ret.="
\n";
return $ret;
}
private static function navigation_bar_bottom($start, $passo, $max) {
$ret = "";
$ret.=" \n";
$ret.=Bibliografia::nav_control($start, $passo, $max);
$ret.="
\n";
return $ret;
}
private static function label_filter($idute, $label, $passo) {
$ret = "";
$action = "onchange=\"javascript:update_references_by_label('action_bibliografia.php?op=aggiorna&start=0')\"";
// Ottiene l'elenco delle etichette per l'utente
$eti_arr = db_elenco("et_id", "ut_id=$idute");
//DIADOSIS TEAM Added translation for all requests
$tutti = array("0" => getConstVar("ALL_REQ"));
$eti_vis = $tutti;
if ($eti_arr != null)
$eti_vis+=$eti_arr;
$ret.=" \n";
$ret.="
\n";
$ret.="
\n";
$ret.=" " . getConstVar("DISPLAY_FILTER") . " \n";
$ret.=Form::getSelect("label", FALSE, $eti_vis, $label, null, " style='display:none;' class=\"form-control\" $action", " ", "\n");
$ret.=Bibliografia::range_select($passo);
$ret.=" " . getConstVar("AT_A_TIME") . " \n";
$ret.="
\n";
$url = "javascript:update_references('action_bibliografia.php?op=aggiorna";
$prev = "";
$last = "";
$first = "";
$next = "";
$intervall = "";
if ($max == 0) {
} else {
if ($start + $passo < $max) {
$pos = $start + $passo;
$intervall = ($start + 1) . "
- $pos
" . getConstVar("OF") . " $max\n";
$next = $url . "&start=" . $pos . "')";
if ($max % $passo == 0)
$last = $max - $passo;
else
$last = $max - ($max % $passo);
$last = $url . "&start=" . $last . "')";
$ret.="
![\">>\"](\"\")
\n";
$ret.="
\n";
$ret.="
\n";
$ret.=" $intervall\n";
$ret.="
\n";
}
else {
$intervall = ($start + 1) . " - $max " . getConstVar("OF") . " $max\n";
$ret.="
\n";
$ret.=" $intervall\n";
$ret.="
\n";
}
if ($start > 0) {
$first = $url . "&start=0')";
$pre = $start - $passo;
$prev = $url . "&start=" . $pre . "')";
$ret.="
\n";
$ret.="
\n";
}
}
$ret.="
" . $row["ri_au1"] . " " . $row["ri_au2"] . ",
Article: " . $row["ri_titolopart"] . ",
Journal: " . $row["ri_titolopub"] . ",
Vol " . $row["ri_vol"] . " (" . $row["ri_fasc"] . ") pp " . $row["ri_pagini"] . "-" . $row["ri_pagini"] .
(!is_null($row["ri_doi"]) ? "
DOI: " . $row["ri_doi"] : "") .
(!is_null($row["ri_pmid"]) ? "
PubMed ID: " . $row["ri_pmid"] : "") .
"
\n";
}
}
public static function label_manager($idute) {
$ret = "";
$ret.=" \n";
$ret.="
\n";
$ret.="
\n";
$ret.=Bibliografia::label_select($idute);
$ret.="
\n";
$ret.="
" . getConstVar("LABELS_CREATED") . " $eticount " . getConstVar("LABELS")
. " / " . getConstVar("MAX_USER_LABELS") . ".
";
if ($eticount < getConstVar("MAX_USER_LABELS")) {
$et = new Etichetta();
$ret.=$et->nuovo();
}
$ret.="
";
if ($eticount == 0)
$ret.="
| " . getConstVar("NOETI") . ". |
";
else {
foreach ($myeti as $label_id => $label_name) {
$ret.= "
|
";
$ret.=Etichetta::render($label_id, $label_name);
$ret.= " |
";
}
}
$ret.="
";
return $ret;
}
public static function history_dd($idute) {
$result = $_SESSION['db']->execute(
"SELECT ri_titolopub, ri_titolopart, ri_au1, ri_anno, rm_datarichie, rm_dataeva
FROM refman ref, riferimento rif
WHERE ref.ut_id = " . $idute . " AND rm_stato != " . getConstVar("Rif_NonRichiesto") . " AND rm_stato != " . getConstVar("Rif_RichiestaAperta") . " AND ref.ri_id = rif.ri_id
ORDER BY rm_datarichie DESC"
);
echo "\n";
$cols = $_SESSION['db']->numcols($result);
for ($j = 0; $j < $cols; $j++) {
$flds[$j] = $_SESSION['db']->fieldname($result, $j);
}
echo "\n";
for ($j = 0; $j < 5; $j++)
echo "| - " . $flds[$j] . " - | \n";
echo "
\n";
$i = 0;
while ($row = $_SESSION['db']->fetch($result)) {
if ($i % 2 == 0)
$c = "item1";
else
$c = "item2";
echo "\n";
for ($j = 0; $j < 5; $j++)
echo "| " . $row[$flds[$j]] . " | \n";
echo "
\n";
$i++;
}
echo "
" . "\n";
}
public static function reference_summary($idute) {
$ref_count = $_SESSION['db']->execute(
"SELECT count( rm_id ) AS num , rm_stato
FROM `refman`
WHERE ut_id=" . $idute . "
GROUP BY rm_stato
ORDER BY rm_stato"
);
$num_status[getConstVar("Rif_NonRichiesto")] = 0;
$num_status[getConstVar("Rif_RichiestaAperta")] = 0;
$num_status[getConstVar("Rif_BiblioChiedeConferma")] = 0;
$num_status[getConstVar("Rif_RichiestaChiusa_Eva")] = 0;
$num_status[getConstVar("Rif_RichiestaChiusa_Ineva")] = 0;
if ($_SESSION['db']->numrows($ref_count) != 0) {
while ($row = $_SESSION['db']->fetch($ref_count)) {
$num_status[$row["rm_stato"]] = $row["num"];
}
}
$num_status[getConstVar("Rif_Tutti_Req")] = $num_status[getConstVar("Rif_RichiestaAperta")] + $num_status[getConstVar("Rif_BiblioChiedeConferma")] + $num_status[getConstVar("Rif_RichiestaChiusa_Eva")] + $num_status[getConstVar("Rif_RichiestaChiusa_Ineva")];
$num_status[getConstVar("Rif_Tutti")] = $num_status[getConstVar("Rif_Tutti_Req")] + $num_status[getConstVar("Rif_NonRichiesto")];
return $num_status;
}
}
?>
![](\"images/mynilde/corn18_b-r.gif\")