1 if ($nb_bib == '1') { show_list_fac($tab_bib[0][0]); exit; } $def_bibli=entites::getSessionBibliId(); if (in_array($def_bibli, $tab_bib[0])) { show_list_fac($def_bibli); exit; } $aff = "
"; $aff.= "

".htmlentities($msg['acquisition_menu_chx_ent'], ENT_QUOTES, $charset)."

"; $aff.= ""; $parity=1; foreach($tab_bib[0] as $k=>$v) { if ($parity % 2) { $pair_impair = "even"; } else { $pair_impair = "odd"; } $parity += 1; $tr_javascript=" onmouseover=\"this.className='surbrillance'\" onmouseout=\"this.className='".$pair_impair."'\" onmousedown=\"document.forms['list_biblio_form'].setAttribute('action','./acquisition.php?categ=ach&sub=fact&action=list&id_bibli=".$v."');document.forms['list_biblio_form'].submit(); \" "; $aff.= ""; } $aff.= "
".htmlentities($tab_bib[1][$k], ENT_QUOTES, $charset)."
"; print $aff; } //Affiche la liste des factures pour un etablissement 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 =""; $search_form_actes=str_replace('', $sel_bibli,$search_form_actes); //Creation selecteur statut $sel_statut = ""; $search_form_actes=str_replace('', $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 ""; //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 = ''.$st_fac.''; 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.= " ".$row->numero." ".$row->num_acte_parent." ".htmlentities($row->raison_sociale, ENT_QUOTES, $charset)." ".formatdate($row->date_acte)." $st_fac id_acte."' ,'print_PDF', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\" > ".htmlentities($msg[ "; if($statut==STA_ACT_REC) { $fac_list.= ""; } $fac_list.= ""; } 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,$faclist_form); $faclist_form = str_replace('',$nav_bar,$faclist_form); $bt_list=''; $bt_sup=''; if($statut==STA_ACT_REC) { //colonne chk $faclist_form=str_replace("", " ",$faclist_form); //Bouton Sélectionner $faclist_form=str_replace('', $faclist_bt_chk,$faclist_form); //JavaScript $faclist_form=str_replace('', $faclist_script,$faclist_form); //bouton payer $bt_list=$faclist_bt_pay; } $faclist_form = str_replace('',$bt_list,$faclist_form); $faclist_form = str_replace('',$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); } } //Affiche le formulaire de création de facture depuis une commande function show_from_cde($id_bibli, $id_cde) { global $msg; global $lang, $charset; global $fact_modif_form, $frame_show_from_cde, $form_search, $bt_enr; $form = $fact_modif_form; $titre = htmlentities($msg['acquisition_fac_cre'], ENT_QUOTES, $charset); $date_cre = formatdate(today()); $cde = new actes($id_cde); $num_cde = htmlentities($cde->numero, ENT_QUOTES, $charset); $id_fou = $cde->num_fournisseur; $fou = new entites($id_fou); $lib_fou = htmlentities($fou->raison_sociale, ENT_QUOTES, $charset); $bibli = new entites($id_bibli); $exer = new exercices($cde->num_exercice); $numero = ''; $comment = ''; $ref = ''; $form = str_replace('', $frame_show_from_cde, $form); $form = str_replace('', $bt_enr, $form); $form = str_replace('', $form_search, $form); $form = str_replace('!!form_title!!', $titre, $form); $form = str_replace('!!id_bibli!!', $id_bibli, $form); $form = str_replace('!!lib_bibli!!', htmlentities($bibli->raison_sociale, ENT_QUOTES, $charset), $form); $form = str_replace('!!id_exer!!', $exer->id_exercice, $form); $form = str_replace('!!lib_exer!!', htmlentities($exer->libelle, ENT_QUOTES, $charset), $form); $form = str_replace('!!id_cde!!', $id_cde, $form); $lien_cde = "".$num_cde.""; $form = str_replace('!!num_cde!!', $lien_cde, $form); $form = str_replace('!!date_cre!!', $date_cre, $form); $form = str_replace('!!id_fac!!', 0, $form); $form = str_replace('!!numero!!', $numero, $form); $form = str_replace('!!date_pay!!', '', $form); $form = str_replace('!!num_pay!!', '', $form); if($cde->date_paiement != '0000-00-00') $form = str_replace('!!date_pay_cde!!', formatdate($cde->date_paiement), $form); else $form = str_replace('!!date_pay_cde!!', '', $form); if (!$cde->num_paiement) $form = str_replace('!!num_pay_cde!!', '', $form); else $form = str_replace('!!num_pay_cde!!', htmlentities($cde->num_paiement,ENT_QUOTES, $charset), $form); $form = str_replace('!!id_fou!!', $id_fou, $form); $form = str_replace('!!lib_fou!!', $lib_fou, $form); $form = str_replace('!!comment!!', $comment, $form); $form = str_replace('!!ref!!', $ref, $form); $form = str_replace('!!devise!!', htmlentities($cde->devise, ENT_QUOTES, $charset), $form); print $form; } //Affiche le formulaire de modification de facture function show_form_fac($id_bibli, $id_fac) { global $msg; global $lang, $charset; global $fact_modif_form, $frame_show, $bt_sup, $bt_enr, $bt_pay, $form_search; global $pmb_type_audit, $bt_audit; $form = $fact_modif_form; $titre = htmlentities($msg['acquisition_fac_mod'], ENT_QUOTES, $charset); $factu = new actes($id_fac); $id_fou = $factu->num_fournisseur; $date_cre = $factu->date_acte; $numero = htmlentities($factu->numero, ENT_QUOTES, $charset); $comment = htmlentities($factu->commentaires, ENT_QUOTES, $charset); $ref = htmlentities($factu->reference, ENT_QUOTES, $charset); $id_cde = liens_actes::getParent($id_fac); $cde = new actes($id_cde); $num_cde = htmlentities($cde->numero, ENT_QUOTES, $charset); $fou = new entites($id_fou); $lib_fou = htmlentities($fou->raison_sociale, ENT_QUOTES, $charset); $bibli = new entites($id_bibli); $exer = new exercices($factu->num_exercice); $form = str_replace('', $frame_show, $form); if( (($factu->statut & STA_ACT_PAY) == STA_ACT_PAY) || (($factu->statut & STA_ACT_ARC) == STA_ACT_ARC) ) { //La facture est payée ou archivée, donc non modifiable } else { $form = str_replace('', $bt_pay, $form); $form = str_replace('', $bt_sup, $form); $form = str_replace('', $bt_enr, $form); $form = str_replace('', $form_search, $form); } $form = str_replace('!!form_title!!', $titre, $form); $form = str_replace('!!id_bibli!!', $id_bibli, $form); $form = str_replace('!!lib_bibli!!', htmlentities($bibli->raison_sociale, ENT_QUOTES, $charset), $form); $form = str_replace('!!id_exer!!', $exer->id_exercice, $form); $form = str_replace('!!lib_exer!!', htmlentities($exer->libelle, ENT_QUOTES, $charset), $form); $form = str_replace('!!id_cde!!', $id_cde, $form); $lien_cde = "".$num_cde.""; $form = str_replace('!!num_cde!!', $lien_cde, $form); $form = str_replace('!!date_cre!!', formatdate($date_cre), $form); $form = str_replace('!!id_fac!!', $id_fac, $form); $form = str_replace('!!numero!!', $numero, $form); if($factu->date_paiement != '0000-00-00') $form = str_replace('!!date_pay!!', formatdate($factu->date_paiement), $form); else $form = str_replace('!!date_pay!!', '', $form); if (!$factu->num_paiement) $form = str_replace('!!num_pay!!', '', $form); else $form = str_replace('!!num_pay!!', htmlentities($factu->num_paiement,ENT_QUOTES, $charset), $form); if($cde->date_paiement != '0000-00-00') $form = str_replace('!!date_pay_cde!!', formatdate($cde->date_paiement), $form); else $form = str_replace('!!date_pay_cde!!', '', $form); if (!$cde->num_paiement) $form = str_replace('!!num_pay_cde!!', '', $form); else $form = str_replace('!!num_pay_cde!!', htmlentities($cde->num_paiement, ENT_QUOTES, $charset) , $form); $form = str_replace('!!id_fou!!', $id_fou, $form); $form = str_replace('!!lib_fou!!', $lib_fou, $form); $form = str_replace('!!comment!!', $comment, $form); $form = str_replace('!!ref!!', $ref, $form); $form = str_replace('!!devise!!', htmlentities($factu->devise, ENT_QUOTES, $charset), $form ); if ($id_fac && $pmb_type_audit) { $form = str_replace('', $bt_audit, $form); } print $form; } //Supprime la facture function sup_fac($id_fac, $id_cde) { $cde = new actes($id_cde); $cde->statut = ($cde->statut & (~STA_ACT_FAC)); //Statut commande = facturé->non facturé $cde->statut = ($cde->statut & (~STA_ACT_PAY)); //Statut commande = payé->non payé $cde->update_statut(); actes::delete($id_fac); liens_actes::delete($id_fac); } function pay_fac_list() { global $chk; if(is_array($chk)) { foreach ($chk as $id_fac) { $fac=new actes($id_fac); if($fac->type_acte==TYP_ACT_FAC && $fac->statut=STA_ACT_REC) { $fac->statut=STA_ACT_PAY; $fac->update_statut(); //La commande correspondante est-elle entierement payee $id_cde = liens_actes::getParent($id_fac); $tab_pay = liens_actes::getChilds($id_cde, TYP_ACT_FAC); $paye= true; while (($row_pay = pmb_mysql_fetch_object($tab_pay))) { if(($row_pay->statut & STA_ACT_PAY) != STA_ACT_PAY){ $paye = false; break; } } if ($paye) { $cde=new actes($id_cde); $cde->statut = ($cde->statut | STA_ACT_PAY); $cde->update_statut(); } } } } } //Traitement des actions print "

".htmlentities($msg['acquisition_ach_ges'],ENT_QUOTES, $charset)." : ".htmlentities($msg['acquisition_ach_fac'],ENT_QUOTES, $charset)."

"; switch($action) { case 'list': entites::setSessionBibliId($id_bibli); show_list_fac($id_bibli); break; case 'from_cde' : show_from_cde($id_bibli, $id_cde); break; case 'modif': show_form_fac($id_bibli, $id_fac); break; case 'delete' : sup_fac($id_fac, $id_cde); show_list_fac($id_bibli); break; case 'list_pay': pay_fac_list(); show_list_fac($id_bibli); break; default: show_list_biblio(); break; } ?>