function show_list_liv($id_bibli)
{
global $msg, $charset;
global $search_form_actes, $livlist_form;
global $nb_per_page_acq;
global $class_path;
global $user_input, $statut, $page, $nbr_lignes, $tri_param, $limit_param, $last_param;
global $tab_bib;
//Creation selecteur etablissement
$sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
foreach ($tab_bib[0] as $k => $v) {
$sel_bibli .= "<option value='" . $v . "' ";
if ($v == $id_bibli) {
$sel_bibli .= "selected='selected' ";
}
$sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
}
$sel_bibli .= "</select>";
$search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
//Creation selecteur statut
$sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
$list_statut = actes::getStatelist(TYP_ACT_LIV);
foreach ($list_statut as $k => $v) {
$sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
}
$sel_statut .= "</select>";
$search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
//Affichage form de recherche
$titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_liv'], ENT_QUOTES, $charset);
$action = "./acquisition.php?categ=ach&sub=livr&action=list&user_input=";
$search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
$search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
$search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
print $search_form_actes;
if (!$statut) {
$statut = getSessionLivState();
//Recuperation du statut courant
} else {
setSessionLivState($statut);
}
print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = " . $statut . ";document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
//Prise en compte du formulaire de recherche
// nombre de références par pages
if ($nb_per_page_acq != "") {
$nb_per_page = $nb_per_page_acq;
} else {
$nb_per_page = 10;
}
// traitement de la saisie utilisateur
require_once $class_path . "/analyse_query.class.php";
// on récupére le nombre de lignes qui vont bien
if (!$nbr_lignes) {
if (!$user_input) {
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_LIV, $statut);
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
if ($aq->error) {
error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
exit;
}
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_LIV, $statut, $aq, $user_input);
}
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
}
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
$url_base = "{$PHP_SELF}?categ=ach&sub=livr&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}";
// on lance la vraie requête
if (!$user_input) {
$res = entites::listActes($id_bibli, TYP_ACT_LIV, $statut, $debut, $nb_per_page);
} else {
$res = entites::listActes($id_bibli, TYP_ACT_LIV, $statut, $debut, $nb_per_page, $aq, $user_input);
}
//Affichage liste des livraisons
$liv_list = "";
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_object($res);
$fourn = new entites($row->num_fournisseur);
$id_cde = liens_actes::getParent($row->id_acte);
$cde = new actes($id_cde);
$st = $row->statut & ~STA_ACT_ARC;
switch ($st) {
case STA_ACT_REC:
$st_liv = htmlentities($msg['acquisition_liv_rec'], ENT_QUOTES, $charset);
break;
default:
$st_liv = '';
}
if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
$st_liv = '<s>' . $st_liv . '</s>';
}
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
$dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=livr&action=modif&id_bibli=" . $id_bibli . "&id_liv=" . $row->id_acte . "' \" ";
$liv_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $cde->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($fourn->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_liv}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"openPopUp('./pdf.php?pdfdoc=livr&id_liv=" . $row->id_acte . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</td>\n\t\t\t\t\t\t</tr>";
}
if (!$last_param) {
$nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page);
} else {
$nav_bar = "";
}
$livlist_form = str_replace('<!-- liv_list -->', $liv_list, $livlist_form);
$livlist_form = str_replace('<!-- nav_bar -->', $nav_bar, $livlist_form);
print $livlist_form;
} else {
// la requête n'a produit aucun résultat
error_message($msg['acquisition_liv_rech'], str_replace('!!liv_cle!!', stripslashes($user_input), $msg['acquisition_liv_rech_error']), 0, './categ=ach&sub=livr&action=list&id_bibli=' . $id_bibli);
}
}
function show_list_fac($id_bibli)
{
global $msg, $charset;
global $search_form_actes, $faclist_form, $faclist_bt_chk, $faclist_script;
global $faclist_bt_pay;
global $nb_per_page_acq, $nb_per_page;
global $class_path;
global $user_input, $statut, $page, $nbr_lignes, $tri_param, $limit_param, $last_param, $sortBy;
global $tab_bib;
//gestion du tri
if (!isset($sortBy)) {
if (trim($_SESSION["acquisition_fac_sort"])) {
$sortBy = $_SESSION["acquisition_fac_sort"];
} else {
$sortBy = "";
}
} else {
$_SESSION["acquisition_fac_sort"] = $sortBy;
}
//Creation selecteur etablissement
$sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
foreach ($tab_bib[0] as $k => $v) {
$sel_bibli .= "<option value='" . $v . "' ";
if ($v == $id_bibli) {
$sel_bibli .= "selected='selected' ";
}
$sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
}
$sel_bibli .= "</select>";
$search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
//Creation selecteur statut
$sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
$list_statut = actes::getStatelist(TYP_ACT_FAC);
foreach ($list_statut as $k => $v) {
$sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
}
$sel_statut .= "</select>";
$search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
//Affichage form de recherche
$titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_fac'], ENT_QUOTES, $charset);
$action = "./acquisition.php?categ=ach&sub=fact&action=list&user_input=";
$search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
$search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
$search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
$search_form_actes = str_replace('!!sortBy!!', $sortBy, $search_form_actes);
print $search_form_actes;
if (!$statut) {
$statut = getSessionFacState();
//Recuperation du statut courant
} else {
setSessionFacState($statut);
}
print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = " . $statut . ";document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
//Prise en compte du formulaire de recherche
// nombre de références par pages
if (!isset($nb_per_page)) {
if ($nb_per_page_acq != "") {
$nb_per_page = $nb_per_page_acq;
} else {
$nb_per_page = 10;
}
}
// traitement de la saisie utilisateur
require_once $class_path . "/analyse_query.class.php";
// on récupére le nombre de lignes qui vont bien
if (!$nbr_lignes) {
if (!$user_input) {
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_FAC, $statut);
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
if ($aq->error) {
error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
exit;
}
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_FAC, $statut, $aq, $user_input);
}
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
}
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
$url_base = "{$PHP_SELF}?categ=ach&sub=fact&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}&sortBy={$sortBy}";
// on lance la vraie requête
if (!$user_input) {
$res = entites::listActes($id_bibli, TYP_ACT_FAC, $statut, $debut, $nb_per_page, 0, '', $sortBy);
} else {
$res = entites::listActes($id_bibli, TYP_ACT_FAC, $statut, $debut, $nb_per_page, $aq, $user_input, $sortBy);
}
//Affichage liste des factures
$fac_list = "";
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_object($res);
$st = $row->statut & ~STA_ACT_ARC;
switch ($st) {
case STA_ACT_REC:
$st_fac = htmlentities($msg['acquisition_fac_rec'], ENT_QUOTES, $charset);
break;
case STA_ACT_PAY:
$st_fac = htmlentities($msg['acquisition_fac_pay'], ENT_QUOTES, $charset);
break;
default:
$st_fac = '';
}
if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
$st_fac = '<s>' . $st_fac . '</s>';
}
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
$dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=fact&action=modif&id_bibli=" . $id_bibli . "&id_fac=" . $row->id_acte . "' \" ";
$fac_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->num_acte_parent . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($row->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_fac}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"openPopUp('./pdf.php?pdfdoc=fact&id_fac=" . $row->id_acte . "' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>\n\t\t\t\t\t\t</td>";
if ($statut == STA_ACT_REC) {
$fac_list .= "<td><input type='checkbox' name='chk[]' id='chk[" . $row->id_acte . "]' value='" . $row->id_acte . "'/></td>";
}
$fac_list .= "</tr>";
}
if (!$last_param) {
$nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true);
} else {
$nav_bar = "";
}
$fieldList = array("1" => "numero", "2" => "num_acte_parent", "3" => "raison_sociale", "4" => "date_acte");
foreach ($fieldList as $k => $field) {
if ($sortBy == $field) {
$faclist_form = str_replace('!!sortBy_' . $k . '_1!!', "-" . $field, $faclist_form);
$faclist_form = str_replace('!!sortBy_' . $k . '_2!!', " ▴", $faclist_form);
} elseif ($sortBy == "-" . $field) {
$faclist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $faclist_form);
$faclist_form = str_replace('!!sortBy_' . $k . '_2!!', " ▾", $faclist_form);
} else {
$faclist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $faclist_form);
$faclist_form = str_replace('!!sortBy_' . $k . '_2!!', "", $faclist_form);
}
}
$faclist_form = str_replace('<!-- fac_list -->', $fac_list, $faclist_form);
$faclist_form = str_replace('<!-- nav_bar -->', $nav_bar, $faclist_form);
$bt_list = '';
$bt_sup = '';
if ($statut == STA_ACT_REC) {
//colonne chk
$faclist_form = str_replace("<!-- chk_th -->", "<th class='act_cell_chkbox'> </th>", $faclist_form);
//Bouton Sélectionner
$faclist_form = str_replace('<!-- bt_chk -->', $faclist_bt_chk, $faclist_form);
//JavaScript
$faclist_form = str_replace('<!-- script -->', $faclist_script, $faclist_form);
//bouton payer
$bt_list = $faclist_bt_pay;
}
$faclist_form = str_replace('<!-- bt_list -->', $bt_list, $faclist_form);
$faclist_form = str_replace('<!-- bt_sup -->', $bt_sup, $faclist_form);
print $faclist_form;
} else {
// la requête n'a produit aucun résultat
error_message($msg['acquisition_fac_rech'], str_replace('!!fac_cle!!', stripslashes($user_input), $msg['acquisition_fac_rech_error']), 0, './categ=ach&sub=fact&action=list&id_bibli=' . $id_bibli);
}
}
function show_list_dev($id_bibli)
{
global $msg, $charset;
global $search_form_actes, $devlist_form, $devlist_bt_chk, $devlist_script;
global $devlist_bt_arc, $devlist_bt_delete, $devlist_bt_rec;
global $nb_per_page_acq;
global $class_path;
global $user_input, $statut, $page, $nbr_lignes, $last_param;
global $tab_bib;
global $acquisition_pdfdev_by_mail;
$bib = new entites($id_bibli);
$bib_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_bibli, 1));
//Creation selecteur etablissement
$sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
foreach ($tab_bib[0] as $k => $v) {
$sel_bibli .= "<option value='" . $v . "' ";
if ($v == $id_bibli) {
$sel_bibli .= "selected='selected' ";
}
$sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
}
$sel_bibli .= "</select>";
$search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
//Creation selecteur statut
$sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
$list_statut = actes::getStatelist(TYP_ACT_DEV);
foreach ($list_statut as $k => $v) {
$sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
}
$sel_statut .= "</select>";
$search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
//Affichage form de recherche
$titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_dev'], ENT_QUOTES, $charset);
$action = "./acquisition.php?categ=ach&sub=devi&action=list&user_input=";
$bouton_add = "<input class='bouton' type='button' value='" . $msg['acquisition_ajout_dev'] . "' onClick=\"document.location='./acquisition.php?categ=ach&sub=devi&action=modif&id_bibli=" . $id_bibli . "&id_dev=0';\" />";
$search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
$search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
$search_form_actes = str_replace('<!-- bouton_add -->', $bouton_add, $search_form_actes);
$search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
print $search_form_actes;
if (!$statut) {
$statut = getSessionDevState();
//Recuperation du statut courant
} else {
setSessionDevState($statut);
}
print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = '" . $statut . "';document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
//Prise en compte du formulaire de recherche
// nombre de références par pages
if ($nb_per_page_acq != "") {
$nb_per_page = $nb_per_page_acq;
} else {
$nb_per_page = 10;
}
// traitement de la saisie utilisateur
require_once $class_path . "/analyse_query.class.php";
// on récupére le nombre de lignes qui vont bien
if (!$nbr_lignes) {
if (!$user_input) {
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_DEV, $statut);
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
if ($aq->error) {
error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
exit;
}
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_DEV, $statut, $aq, $user_input);
}
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
}
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
$url_base = "{$PHP_SELF}?categ=ach&sub=devi&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}";
// on lance la requete
if (!$user_input) {
$res = entites::listActes($id_bibli, TYP_ACT_DEV, $statut, $debut, $nb_per_page);
} else {
$res = entites::listActes($id_bibli, TYP_ACT_DEV, $statut, $debut, $nb_per_page, $aq, $user_input);
}
//Affichage liste des devis
$dev_list = "";
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_object($res);
$fourn = new entites($row->num_fournisseur);
$st = $row->statut & ~STA_ACT_ARC;
switch ($st) {
case STA_ACT_ENC:
$st_dev = htmlentities($msg['acquisition_dev_enc'], ENT_QUOTES, $charset);
break;
case STA_ACT_REC:
$st_dev = htmlentities($msg['acquisition_dev_rec'], ENT_QUOTES, $charset);
break;
default:
$st_dev = htmlentities($msg['acquisition_dev_enc'], ENT_QUOTES, $charset);
}
if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
$st_dev = '<s>' . $st_dev . '</s>';
}
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
$dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=devi&action=modif&id_bibli=" . $id_bibli . "&id_dev=" . $row->id_acte . "' \" ";
$dev_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($fourn->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_dev}</i></td>\n\t\t\t\t\t\t<td>\n\t\t\t\t\t\t\t<a href=# onclick=\"document.location='./acquisition.php?categ=ach&sub=devi&action=print&id_bibli=" . $id_bibli . "&id_dev=" . $row->id_acte . "&page=" . $page . "&by_mail=0'\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities(addslashes($msg['imprimer']), ENT_QUOTES, $charset) . "' title='" . htmlentities(addslashes($msg['imprimer']), ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>";
if (($row->statut & ~STA_ACT_ARC) == STA_ACT_ENC && $acquisition_pdfdev_by_mail && strpos($bib_coord->email, '@')) {
$dev_list .= "\t\t\t\n\t\t\t\t\t\t\t<a href=# onclick=\"document.location='./acquisition.php?categ=ach&sub=devi&action=print&id_bibli=" . $id_bibli . "&id_dev=" . $row->id_acte . "&page=" . $page . "&by_mail=1'\" >\n\t\t\t\t\t\t\t\t<img src='./images/mail.png' border='0' align='center' alt='" . htmlentities($msg['58'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['58'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>";
}
$dev_list .= "\t</td>";
if ($statut != STA_ACT_ALL) {
$dev_list .= "<td><input type='checkbox' name='chk[]' id='chk[" . $row->id_acte . "]' value='" . $row->id_acte . "'/></td>";
}
$dev_list .= "</tr>";
}
if (!$last_param) {
$nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page);
} else {
$nav_bar = "";
}
$devlist_form = str_replace('<!-- dev_list -->', $dev_list, $devlist_form);
$devlist_form = str_replace('<!-- nav_bar -->', $nav_bar, $devlist_form);
$bt_list = '';
$bt_sup = '';
if ($statut != STA_ACT_ALL) {
//colonne chk
$devlist_form = str_replace("<!-- chk_th -->", "<th class='act_cell_chkbox'> </th>", $devlist_form);
//Bouton Sélectionner
$devlist_form = str_replace('<!-- bt_chk -->', $devlist_bt_chk, $devlist_form);
//JavaScript
$devlist_form = str_replace('<!-- script -->', $devlist_script, $devlist_form);
//Bouton recevoir + archiver
if ($statut == STA_ACT_ENC) {
$bt_list = $devlist_bt_rec . ' ' . $devlist_bt_arc;
}
//Bouton archiver
if ($statut == STA_ACT_REC) {
$bt_list = $devlist_bt_arc;
}
//Bouton supprimer
$bt_sup = $devlist_bt_delete;
}
$devlist_form = str_replace('<!-- bt_list -->', $bt_list, $devlist_form);
$devlist_form = str_replace('<!-- bt_sup -->', $bt_sup, $devlist_form);
print $devlist_form;
} else {
// la requête n'a produit aucun résultat
error_message($msg['acquisition_dev_rech'], str_replace('!!dev_cle!!', stripslashes($user_input), $msg['acquisition_dev_rech_error']), 0, './categ=ach&sub=devi&action=list&id_bibli=' . $id_bibli);
}
}
function show_list_cde($id_bibli)
{
global $msg, $charset;
global $search_form_actes, $cdelist_form, $cdelist_bt_chk, $cdelist_script;
global $cdelist_bt_valid, $cdelist_bt_delete, $cdelist_bt_sold, $cdelist_bt_arc;
global $nb_per_page_acq, $nb_per_page;
global $class_path;
global $user_input, $statut, $page, $nbr_lignes, $last_param, $sortBy;
global $tab_bib;
global $acquisition_pdfcde_by_mail;
if (!isset($sortBy)) {
if (trim($_SESSION["acquisition_cde_sort"])) {
$sortBy = $_SESSION["acquisition_cde_sort"];
} else {
$sortBy = "";
}
} else {
$_SESSION["acquisition_cde_sort"] = $sortBy;
}
$bib = new entites($id_bibli);
$bib_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_bibli, 1));
//Creation selecteur etablissement
$sel_bibli = "<select class='saisie-50em' id='id_bibli' name='id_bibli' onchange=\"submit();\" >";
foreach ($tab_bib[0] as $k => $v) {
$sel_bibli .= "<option value='" . $v . "' ";
if ($v == $id_bibli) {
$sel_bibli .= "selected='selected' ";
}
$sel_bibli .= ">" . htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset) . "</option>";
}
$sel_bibli .= "</select>";
$search_form_actes = str_replace('<!-- sel_bibli -->', $sel_bibli, $search_form_actes);
//Creation selecteur statut
$sel_statut = "<select class='saisie-25em' id='statut' name='statut' onchange=\"submit();\" >";
$list_statut = actes::getStatelist(TYP_ACT_CDE);
foreach ($list_statut as $k => $v) {
$sel_statut .= "<option value='" . $k . "'>" . htmlentities($v, ENT_QUOTES, $charset) . "</option>";
}
$sel_statut .= "</select>";
$search_form_actes = str_replace('<!-- sel_statut -->', $sel_statut, $search_form_actes);
//Affichage form de recherche
$titre = htmlentities($msg['recherche'] . ' : ' . $msg['acquisition_ach_cde'], ENT_QUOTES, $charset);
$action = "./acquisition.php?categ=ach&sub=cmde&action=list&user_input=";
$bouton_add = "<input class='bouton' type='button' value='" . $msg['acquisition_ajout_cde'] . "' onclick=\"document.location='./acquisition.php?categ=ach&sub=cmde&action=modif&id_bibli=" . $id_bibli . "&id_cde=0';\" />";
$search_form_actes = str_replace('!!form_title!!', $titre, $search_form_actes);
$search_form_actes = str_replace('!!action!!', $action, $search_form_actes);
$search_form_actes = str_replace('<!-- bouton_add -->', $bouton_add, $search_form_actes);
$search_form_actes = str_replace('!!user_input!!', $user_input, $search_form_actes);
$search_form_actes = str_replace('!!sortBy!!', $sortBy, $search_form_actes);
print $search_form_actes;
if (!$statut) {
$statut = getSessionCdeState();
//Recuperation du statut courant
} else {
setSessionCdeState($statut);
}
print "<script type='text/javascript' >document.forms['search'].elements['statut'].value = '" . $statut . "';document.forms['search'].elements['user_input'].focus();\n\tdocument.forms['search'].elements['user_input'].select();</script>";
//Prise en compte du formulaire de recherche
// nombre de références par pages
if (!isset($nb_per_page)) {
if ($nb_per_page_acq != "") {
$nb_per_page = $nb_per_page_acq;
} else {
$nb_per_page = 10;
}
}
// traitement de la saisie utilisateur
require_once $class_path . "/analyse_query.class.php";
// comptage
if (!$nbr_lignes) {
if (!$user_input) {
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_CDE, $statut);
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
if ($aq->error) {
error_message($msg["searcher_syntax_error"], sprintf($msg["searcher_syntax_error_desc"], $aq->current_car, $aq->input_html, $aq->error_message));
exit;
}
$nbr_lignes = entites::getNbActes($id_bibli, TYP_ACT_CDE, $statut, $aq, $user_input);
}
} else {
$aq = new analyse_query(stripslashes($user_input), 0, 0, 0, 0);
}
if (!$page) {
$page = 1;
}
$debut = ($page - 1) * $nb_per_page;
if ($nbr_lignes) {
$url_base = "{$PHP_SELF}?categ=ach&sub=cmde&action=list&id_bibli={$id_bibli}&user_input=" . rawurlencode(stripslashes($user_input)) . "&statut={$statut}&sortBy={$sortBy}";
// liste
if (!$user_input) {
$res = entites::listActes($id_bibli, TYP_ACT_CDE, $statut, $debut, $nb_per_page, 0, '', $sortBy);
} else {
$res = entites::listActes($id_bibli, TYP_ACT_CDE, $statut, $debut, $nb_per_page, $aq, $user_input, $sortBy);
}
//Affichage liste des commandes
$cde_list = "";
$nbr = pmb_mysql_num_rows($res);
$parity = 1;
for ($i = 0; $i < $nbr; $i++) {
$row = pmb_mysql_fetch_object($res);
//TODO A modifier si une seule date de livraison par acte
$dateech = $row->date_ech_calc;
if ($dateech != '00000000') {
$dateech = formatdate($dateech);
} else {
$dateech = '';
}
$st = $row->statut & ~(STA_ACT_FAC | STA_ACT_PAY | STA_ACT_ARC);
switch ($st) {
case STA_ACT_AVA:
$st_cde = htmlentities($msg['acquisition_cde_aval'], ENT_QUOTES, $charset);
break;
case STA_ACT_ENC:
$st_cde = htmlentities($msg['acquisition_cde_enc'], ENT_QUOTES, $charset);
break;
case STA_ACT_REC:
$st_cde = htmlentities($msg['acquisition_cde_liv'], ENT_QUOTES, $charset);
break;
default:
$st_cde = htmlentities($msg['acquisition_cde_enc'], ENT_QUOTES, $charset);
}
if (($row->statut & STA_ACT_PAY) == STA_ACT_PAY) {
$st_fac = htmlentities($msg['acquisition_act_pay'], ENT_QUOTES, $charset);
} elseif (($row->statut & STA_ACT_FAC) == STA_ACT_FAC) {
$st_fac = htmlentities($msg['acquisition_act_fac'], ENT_QUOTES, $charset);
} else {
$st_fac = '';
}
if ($st_fac) {
$st_cde .= ' / ' . $st_fac;
}
if (($row->statut & STA_ACT_ARC) == STA_ACT_ARC) {
$st_cde = '<s>' . $st_cde . '</s>';
}
if ($parity % 2) {
$pair_impair = "even";
} else {
$pair_impair = "odd";
}
$parity += 1;
$tr_javascript = "onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='" . $pair_impair . "'\" ";
$dn_javascript = "onmousedown=\"document.location='./acquisition.php?categ=ach&sub=cmde&action=modif&id_bibli=" . $id_bibli . "&id_cde=" . $row->id_acte . "' \" ";
$cde_list .= "<tr class='" . $pair_impair . "' " . $tr_javascript . " style='cursor: pointer' >\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $row->numero . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . htmlentities($row->raison_sociale, ENT_QUOTES, $charset) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . formatdate($row->date_acte) . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>" . $dateech . "</i></td>\n\t\t\t\t\t\t<td " . $dn_javascript . " ><i>{$st_cde}</i></td>\n\t\t\t\t\t\t<td >\n\t\t\t\t\t\t\t<a href=# onclick=\"document.location='./acquisition.php?categ=ach&sub=cmde&action=print&id_bibli=" . $id_bibli . "&id_cde=" . $row->id_acte . "&page=" . $page . "&by_mail=0'\" >\n\t\t\t\t\t\t\t\t<img src='./images/print.gif' border='0' align='center' alt='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['imprimer'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>";
if (($row->statut & ~STA_ACT_ARC) == STA_ACT_ENC && $acquisition_pdfcde_by_mail && strpos($bib_coord->email, '@')) {
$cde_list .= "\t\t\t\n\t\t\t\t\t\t\t<a href=# onclick=\"document.location='./acquisition.php?categ=ach&sub=cmde&action=print&id_bibli=" . $id_bibli . "&id_cde=" . $row->id_acte . "&page=" . $page . "&by_mail=1'\" >\n\t\t\t\t\t\t\t\t<img src='./images/mail.png' border='0' align='center' alt='" . htmlentities($msg['58'], ENT_QUOTES, $charset) . "' title='" . htmlentities($msg['58'], ENT_QUOTES, $charset) . "' />\n\t\t\t\t\t\t\t</a>";
}
$cde_list .= "</td>";
if ($statut != STA_ACT_ALL && $statut != STA_ACT_ARC) {
$cde_list .= "<td><input type='checkbox' name='chk[]' id='chk[" . $row->id_acte . "]' value='" . $row->id_acte . "'/></td>";
}
$cde_list .= "</tr>";
}
if (!$last_param) {
$nav_bar = aff_pagination($url_base, $nbr_lignes, $nb_per_page, $page, 10, true, true);
} else {
$nav_bar = "";
}
$fieldList = array("1" => "numero", "2" => "raison_sociale", "3" => "date_acte", "4" => "date_ech_calc");
foreach ($fieldList as $k => $field) {
if ($sortBy == $field) {
$cdelist_form = str_replace('!!sortBy_' . $k . '_1!!', "-" . $field, $cdelist_form);
$cdelist_form = str_replace('!!sortBy_' . $k . '_2!!', " ▴", $cdelist_form);
} elseif ($sortBy == "-" . $field) {
$cdelist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $cdelist_form);
$cdelist_form = str_replace('!!sortBy_' . $k . '_2!!', " ▾", $cdelist_form);
} else {
$cdelist_form = str_replace('!!sortBy_' . $k . '_1!!', $field, $cdelist_form);
$cdelist_form = str_replace('!!sortBy_' . $k . '_2!!', "", $cdelist_form);
}
}
$cdelist_form = str_replace('<!-- cde_list -->', $cde_list, $cdelist_form);
$cdelist_form = str_replace('<!-- nav_bar -->', $nav_bar, $cdelist_form);
if ($statut != STA_ACT_ALL && $statut != STA_ACT_ARC) {
//colonne chk
$cdelist_form = str_replace("<!-- chk_th -->", "<th class='act_cell_chkbox'> </th>", $cdelist_form);
//Bouton Sélectionner
$cdelist_form = str_replace('<!-- bt_chk -->', $cdelist_bt_chk, $cdelist_form);
//JavaScript
$cdelist_form = str_replace('<!-- script -->', $cdelist_script, $cdelist_form);
}
$bt_list = '';
$bt_sup = '';
switch ($statut) {
case STA_ACT_AVA:
$bt_list = $cdelist_bt_valid;
$bt_sup = $cdelist_bt_delete;
break;
case STA_ACT_ENC:
$bt_list = $cdelist_bt_sold;
break;
case STA_ACT_REC:
$bt_list = $cdelist_bt_arc;
break;
default:
break;
}
$cdelist_form = str_replace('<!-- bt_list -->', $bt_list, $cdelist_form);
$cdelist_form = str_replace('<!-- bt_sup -->', $bt_sup, $cdelist_form);
print $cdelist_form;
} else {
// la requête n'a produit aucun résultat
error_message($msg['acquisition_cde_rech'], str_replace('!!cde_cle!!', stripslashes($user_input), $msg['acquisition_cde_rech_error']), 0, './categ=ach&sub=cmde&action=list&id_bibli=' . $id_bibli);
}
}
