Facturation > Historique"; require "head.php"; $bg_color = $bg_1; $parpage = 50; // nb elements par page dans la liste $size_f = 18; // Taille fleche if (!logged_in()) die(); if (isset($_POST['message'])) $message = $_POST['message']; // NUMERO DE PAGE EN COURS // if ($_POST['numpage_m']) $numpage=intval($_POST['numpage']-1); else if ($_POST['numpage_p']) $numpage=intval($_POST['numpage']+1); else if ($_POST['numpage_s']) $numpage=intval($_POST['numpage_s']); else $numpage=1; // ORDRE DE TRI // //if (isset($_POST['sens'])) if ($_POST['sens']=='za') $ordre = "designation desc,id_invoice asc"; else if ($_POST['sens']=='az') $ordre = "designation asc, id_invoice asc"; else if ($_POST['sens']=='date_up') $ordre = "invoice_date desc, designation asc"; else if ($_POST['sens']=='date_down') $ordre = "invoice_date asc, designation asc"; else if ($_POST['sens']=='fact_down') $ordre = "id_invoice asc"; else if ($_POST['sens']=='fact_up') $ordre = "id_invoice desc"; else $ordre = "id_invoice asc"; // ON ETABLIT LES CRITERES DE RECHERCHE $req="select count(id_invoice) from invoices"; // RECHERCHE if (isset($_POST['registrar']) && $_POST['registrar']!="") { $req.=",registrar"; $recherche_reg = " invoices.id_registrar=registrar.id_registrar and upper(concat(registrar.designation,' ',registrar.nom,' ',registrar.prenom)) like '%".strtoupper_fr($_POST['registrar'])."%'"; } if (isset($_POST['status'])&& in_array($_POST['status'],array(0,1))) { $status = $_POST['status']; $recherche_status = " status=".$status; } else $status = 2; if (isset($recherche_reg) && isset($recherche_status)) $recherche = $recherche_reg." and".$recherche_status; else if(isset($recherche_reg)) $recherche = $recherche_reg; else if (isset($recherche_status)) $recherche = $recherche_status; // ON COMPTE LE NB DE RESULTATS POUR SAVOIR LE NB DE PAGES // if (isset($recherche)) $req.=" where".$recherche; $data = pg_fetch_array(r_exec('local',$req,false)); $total = $data[0]; $nb_pages = (int)($total/$parpage)+1; if ($total/$parpage == (int)($total/$parpage)) // POUR EVITER D'AVOIR UNE DERNIER PAGE VIDE $nb_pages--; // $start=($parpage*$numpage)-$parpage; // SI LA RECHERCHE A ETE MODIFIEE ET QUE LE NB DE RESULTATS CHANGE if ($total < $start) { $start = 0; $numpage = 1; } //recherche des factures // $req = "select invoices.id_registrar,designation,invoice_number,amount,invoice_date,status from invoices,registrar where invoices.id_registrar=registrar.id_registrar"; if (isset($recherche)) $req.=" and ".$recherche; $req.= " order by ".$ordre." offset ".$start." limit ".$parpage; $res = r_exec('local',$req,false); $nb = 0; while ($data = pg_fetch_array($res)) { $tab[$nb]['id'] = $data['id_registrar']; $tab[$nb]['name'] = $data['designation']; $tab[$nb]['number'] = $data['invoice_number']; $tab[$nb]['amount'] = $data['amount']; $tab[$nb]['date'] = $data['invoice_date']; $tab[$nb]['status'] = $data['status']; $nb++; } $sous_titre = $total. " factures trouvées"; // AFFICHAGE TITRE ET MESSAGE // titre($titre); if (isset($message)) info($message); // AFFICHAGE TABLEAU DU HAUT AVEC CHOIX CRITERES // echo "\n

"; ?>

Critères de recherche

Bureau d'enregistrement :	'>	onclick="tri.submit()"> En attente onclick="tri.submit()"> Payées onclick="tri.submit()"> Toutes

-------- -------- 0) { ?>

'> 1) echo ""; if ($nb_pages >1) { echo "Page "; echo ""; echo " / ".$nb_pages; } if ($numpage < $nb_pages) echo ">';tri.submit();\">"; ?> '>
Bureau d'enregistrement	Num facture	Montant	Payée	Date
					".$tab[$j]['name']."	".$tab[$j]['number']."	".$tab[$j]['amount']." €"; echo "	".date_format(date_create($tab[$j]['date']),'d/m/Y'); } echo "

"; } require "footer.php"; ?>