} else { $fs_footer = $pos_footer[1]; } //--------------------------------------------------------------------------------------------------------------------- $taille_doc = array($largeur_page, $hauteur_page); $w = $largeur_page - $marge_gauche - $marge_droite; $ourPDF = new $fpdf($orient_page, 'mm', $taille_doc); $ourPDF->Open(); $ourPDF->SetMargins($marge_gauche, $marge_haut, $marge_droite); //On récupère les infos de la facture $fac = new actes($id_fac); $lignes = actes::getLignes($id_fac); $bibli = new entites($fac->num_entite); $coord_fac = new coordonnees($fac->num_contact_fact); $fou = new entites($fac->num_fournisseur); $coord_fou = entites::get_coordonnees($fac->num_fournisseur, '1'); $coord_fou = mysql_fetch_object($coord_fou); $id_cde = liens_actes::getParent($id_fac); $cde = new actes($id_cde); $ourPDF->addPage(); $ourPDF->setFont($pmb_pdf_font); //Affichage date $date = formatdate(today()); $ourPDF->setFontSize($fs_date); $ourPDF->SetXY($x_date, $y_date); $ourPDF->Cell($l_date, $h_date, $date, 0, 0, 'L', 0); //Affichage raison sociale $raison = $bibli->raison_sociale; $ourPDF->setFontSize($fs_raison); $ourPDF->SetXY($x_raison, $y_raison); $ourPDF->Cell($l_raison, $h_raison, $raison, 0, 0, 'L', 0);
function print_dev($id_bibli = 0, $id_dev = 0, $by_mail = FALSE) { global $dbh, $charset, $base_path, $acquisition_pdfdev_print; global $acquisition_pdfdev_obj_mail, $acquisition_pdfdev_text_mail; global $acquisition_pdfdev_by_mail, $PMBuseremailbcc; if (!($id_bibli && $id_dev)) { return; } $bib = new entites($id_bibli); $bib_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_bibli, 1)); $dev = new actes($id_dev); $id_fou = $dev->num_fournisseur; $fou = new entites($id_fou); $fou_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_fou, 1)); $no_mail = FALSE; if ($by_mail == FALSE || !($acquisition_pdfdev_by_mail && strpos($bib_coord->email, '@') && strpos($fou_coord->email, '@'))) { $no_mail = TRUE; } else { $dest_name = ''; if ($fou_coord->libelle) { $dest_name = $fou_coord->libelle; } else { $dest_name = $fou->raison_sociale; } if ($fou_coord->contact) { $dest_name .= " " . $fou_coord->contact; } $dest_mail = $fou_coord->email; $obj_mail = $acquisition_pdfdev_obj_mail; $text_mail = $acquisition_pdfdev_text_mail; $bib_name = $bib_coord->raison_sociale; $bib_mail = $bib_coord->email; $lettre = lettreDevis_factory::make(); $lettre->doLettre($id_bibli, $id_dev); $piece_jointe = array(); $piece_jointe[0]['contenu'] = $lettre->getLettre('S'); $piece_jointe[0]['nomfichier'] = $lettre->getFileName(); // mailpmb($to_nom="", $to_mail, $obj="", $corps="", $from_name="", $from_mail, $headers, $copie_CC="", $copie_BCC="", $faire_nl2br=0, $pieces_jointes=array()) $res_envoi = mailpmb($dest_name, $dest_mail, $obj_mail, $text_mail, $bib_name, $bib_mail, "Content-Type: text/plain; charset=\"{$charset}\"", '', $PMBuseremailbcc, 1, $piece_jointe); if (!$res_envoi) { $no_mail = TRUE; } } if ($no_mail) { print "\t\n\t\t\t<form name='print_dev' action='pdf.php?pdfdoc=devi' target='lettre' method='post'>\t\t\n\t\t\t\t<input type='hidden' name='id_bibli' value='" . $id_bibli . "'/>\n\t\t\t\t<input type='hidden' name='id_dev' value='" . $id_dev . "'/>\n\t\t\t\t<script type='text/javascript'>\n\t\t\t\t\topenPopUp('','lettre', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\n\t\t\t\t\tdocument.print_dev.submit();\n\t\t\t\t</script>\n\t\t\t</form>"; } }
function show_coord_form($id = 0) { global $msg; global $charset; global $coord_form, $coord_form_biblio, $coord_form_suite; global $ptab, $script; $ptab[1] = $ptab[1] . $ptab[10] . $ptab[11]; $ptab[1] = str_replace('!!adresse!!', htmlentities($msg[acquisition_adr_fac], ENT_QUOTES, $charset), $ptab[1]); $coord_form = str_replace('!!id!!', $id, $coord_form); $ptab[3] = str_replace('!!id!!', $id, $ptab[3]); if (!$id) { $coord_form = str_replace('!!form_title!!', htmlentities($msg[acquisition_ajout_biblio], ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!raison_suppr!!', '', $coord_form); $coord_form = str_replace('!!raison!!', '', $coord_form); $coord_form = str_replace('!!contact!!', $ptab[1], $coord_form); $coord_form = str_replace('!!max_coord!!', '2', $coord_form); $coord_form = str_replace('!!id1!!', '0', $coord_form); $coord_form = str_replace('!!lib_1!!', '', $coord_form); $coord_form = str_replace('!!cta_1!!', '', $coord_form); $coord_form = str_replace('!!ad1_1!!', '', $coord_form); $coord_form = str_replace('!!ad2_1!!', '', $coord_form); $coord_form = str_replace('!!cpo_1!!', '', $coord_form); $coord_form = str_replace('!!vil_1!!', '', $coord_form); $coord_form = str_replace('!!eta_1!!', '', $coord_form); $coord_form = str_replace('!!pay_1!!', '', $coord_form); $coord_form = str_replace('!!te1_1!!', '', $coord_form); $coord_form = str_replace('!!te2_1!!', '', $coord_form); $coord_form = str_replace('!!fax_1!!', '', $coord_form); $coord_form = str_replace('!!ema_1!!', '', $coord_form); $coord_form = str_replace('!!com_1!!', '', $coord_form); $coord_form = str_replace('!!id2!!', '0', $coord_form); $coord_form = str_replace('!!lib_2!!', '', $coord_form); $coord_form = str_replace('!!cta_2!!', '', $coord_form); $coord_form = str_replace('!!ad1_2!!', '', $coord_form); $coord_form = str_replace('!!ad2_2!!', '', $coord_form); $coord_form = str_replace('!!cpo_2!!', '', $coord_form); $coord_form = str_replace('!!vil_2!!', '', $coord_form); $coord_form = str_replace('!!eta_2!!', '', $coord_form); $coord_form = str_replace('!!pay_2!!', '', $coord_form); $coord_form = str_replace('!!te1_2!!', '', $coord_form); $coord_form = str_replace('!!te2_2!!', '', $coord_form); $coord_form = str_replace('!!fax_2!!', '', $coord_form); $coord_form = str_replace('!!ema_2!!', '', $coord_form); $coord_form = str_replace('!!com_2!!', '', $coord_form); $coord_form = str_replace('!!commentaires!!', '', $coord_form); $coord_form = str_replace('!!siret!!', '', $coord_form); $coord_form = str_replace('!!rcs!!', '', $coord_form); $coord_form = str_replace('!!naf!!', '', $coord_form); $coord_form = str_replace('!!tva!!', '', $coord_form); $coord_form = str_replace('!!site_web!!', '', $coord_form); $coord_form = str_replace('!!logo!!', '', $coord_form); autorisations(); } else { $biblio = new entites($id); $coord_form = str_replace('!!form_title!!', htmlentities($msg[acquisition_modif_biblio], ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!raison!!', htmlentities($biblio->raison_sociale, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!contact!!', $ptab[1], $coord_form); $row = mysql_fetch_object(entites::get_coordonnees($biblio->id_entite, '1')); $coord_form = str_replace('!!id1!!', $row->id_contact, $coord_form); $coord_form = str_replace('!!lib_1!!', htmlentities($row->libelle, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!cta_1!!', htmlentities($row->contact, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ad1_1!!', htmlentities($row->adr1, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ad2_1!!', htmlentities($row->adr2, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!cpo_1!!', htmlentities($row->cp, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!vil_1!!', htmlentities($row->ville, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!eta_1!!', htmlentities($row->etat, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!pay_1!!', htmlentities($row->pays, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!te1_1!!', htmlentities($row->tel1, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!te2_1!!', htmlentities($row->tel2, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!fax_1!!', htmlentities($row->fax, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ema_1!!', htmlentities($row->email, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!com_1!!', htmlentities($row->commentaires, ENT_QUOTES, $charset), $coord_form); $row = mysql_fetch_object(entites::get_coordonnees($biblio->id_entite, '2')); $coord_form = str_replace('!!id2!!', $row->id_contact, $coord_form); $coord_form = str_replace('!!lib_2!!', htmlentities($row->libelle, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!cta_2!!', htmlentities($row->contact, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ad1_2!!', htmlentities($row->adr1, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ad2_2!!', htmlentities($row->adr2, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!cpo_2!!', htmlentities($row->cp, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!vil_2!!', htmlentities($row->ville, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!eta_2!!', htmlentities($row->etat, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!pay_2!!', htmlentities($row->pays, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!te1_2!!', htmlentities($row->tel1, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!te2_2!!', htmlentities($row->tel2, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!fax_2!!', htmlentities($row->fax, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ema_2!!', htmlentities($row->email, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!com_2!!', htmlentities($row->commentaires, ENT_QUOTES, $charset), $coord_form); $liste_coord = entites::get_coordonnees($biblio->id_entite, '0'); $coord_form = str_replace('!!max_coord!!', mysql_num_rows($liste_coord) + 2, $coord_form); $i = 3; while ($row = mysql_fetch_object($liste_coord)) { $coord_form = str_replace('<!--coord_repetables-->', $ptab[2] . '<!--coord_repetables-->', $coord_form); $coord_form = str_replace('!!no_X!!', $i, $coord_form); $i++; $coord_form = str_replace('!!idX!!', $row->id_contact, $coord_form); $coord_form = str_replace('!!lib_X!!', htmlentities($row->libelle, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!cta_X!!', htmlentities($row->contact, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ad1_X!!', htmlentities($row->adr1, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ad2_X!!', htmlentities($row->adr2, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!cpo_X!!', htmlentities($row->cp, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!vil_X!!', htmlentities($row->ville, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!eta_X!!', htmlentities($row->etat, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!pay_X!!', htmlentities($row->pays, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!te1_X!!', htmlentities($row->tel1, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!te2_X!!', htmlentities($row->tel2, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!fax_X!!', htmlentities($row->fax, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!ema_X!!', htmlentities($row->email, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!com_X!!', htmlentities($row->commentaires, ENT_QUOTES, $charset), $coord_form); } $coord_form = str_replace('!!commentaires!!', htmlentities($biblio->commentaires, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!siret!!', htmlentities($biblio->siret, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!rcs!!', htmlentities($biblio->rcs, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!naf!!', htmlentities($biblio->naf, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!tva!!', htmlentities($biblio->tva, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!site_web!!', htmlentities($biblio->site_web, ENT_QUOTES, $charset), $coord_form); $coord_form = str_replace('!!logo!!', htmlentities($biblio->logo, ENT_QUOTES, $charset), $coord_form); autorisations($biblio->autorisations); $coord_form = str_replace('<!-- bouton_sup -->', $ptab[3], $coord_form); $coord_form = str_replace('!!raison_suppr!!', addslashes($biblio->raison_sociale), $coord_form); } print confirmation_delete("./admin.php?categ=acquisition&sub=entite&action=del&id="); print $script; print $coord_form; }
function show_results($dbh, $nbr_lignes = 0, $page = 0) { global $nb_per_page; global $base_url; global $caller; global $charset; global $msg; global $id_bibli; // on récupére le nombre de lignes qui vont bien $nbr_lignes = entites::count_coordonnees($id_bibli); if (!$page) { $page = 1; } $debut = ($page - 1) * $nb_per_page; if ($nbr_lignes) { // on lance la vraie requête $res = entites::get_coordonnees($id_bibli, '-1', $debut, $nb_per_page); while ($row = mysql_fetch_object($res)) { $adresse = ''; $adresse1 = ''; if ($row->libelle != '') { $adresse = htmlentities(addslashes($row->libelle), ENT_QUOTES, $charset) . "\\n"; $adresse1 = htmlentities($row->libelle, ENT_QUOTES, $charset); } if ($row->contact != '') { $adresse .= htmlentities(addslashes($row->contact), ENT_QUOTES, $charset) . "\\n"; } $adresse1 .= ' ('; if ($row->adr1 != '') { $adresse .= htmlentities(addslashes($row->adr1), ENT_QUOTES, $charset) . "\\n"; $adresse1 .= htmlentities($row->adr1, ENT_QUOTES, $charset) . ' '; } if ($row->adr2 != '') { $adresse .= htmlentities(addslashes($row->adr2), ENT_QUOTES, $charset) . "\\n"; $adresse1 .= htmlentities($row->adr2, ENT_QUOTES, $charset) . ' '; } if ($row->cp != '') { $adresse .= htmlentities(addslashes($row->cp), ENT_QUOTES, $charset) . ' '; $adresse1 .= htmlentities($row->cp, ENT_QUOTES, $charset) . ' '; } if ($row->ville != '') { $adresse .= htmlentities(addslashes($row->ville), ENT_QUOTES, $charset); $adresse1 .= htmlentities($row->ville, ENT_QUOTES, $charset); } $adresse1 .= ')'; print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_contact}', '{$adresse}' )\">{$adresse1}</a>"); print "<br />"; } mysql_free_result($res); // constitution des liens $nbepages = ceil($nbr_lignes / $nb_per_page); $suivante = $page + 1; $precedente = $page - 1; // affichage du lien précédent si nécessaire print '<hr /><div align=center>'; if ($precedente > 0) { print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>"; } for ($i = 1; $i <= $nbepages; $i++) { if ($i == $page) { print "<b>{$i}/{$nbepages}</b>"; } } if ($suivante <= $nbepages) { print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&no_display={$no_display}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>"; } } print '</div>'; }
function show_coord_form($id_bibli, $id_fou = 0) { global $msg; global $charset; global $coord_form2; global $ptab, $script; global $pmb_gestion_devise; $bibli = new entites($id_bibli); $ptab[1] = $ptab[1] . $ptab[11]; $ptab[1] = str_replace('!!adresse!!', htmlentities($msg[acquisition_adr_fou], ENT_QUOTES, $charset), $ptab[1]); $coord_form2 = str_replace('!!id!!', $id_fou, $coord_form2); $coord_form2 = str_replace('!!id_bibli!!', $id_bibli, $coord_form2); $coord_form2 = str_replace('!!lib_bibli!!', htmlentities($bibli->raison_sociale, ENT_QUOTES, $charset), $coord_form2); $ptab[3] = str_replace('!!id!!', $id_fou, $ptab[3]); if (!$id_fou) { $coord_form2 = str_replace('!!form_title!!', htmlentities($msg[acquisition_ajout_fourn], ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!raison_suppr!!', '', $coord_form2); $coord_form2 = str_replace('!!raison!!', '', $coord_form2); $coord_form2 = str_replace('!!num_cp!!', '', $coord_form2); $coord_form2 = str_replace('!!contact!!', $ptab[1], $coord_form2); $coord_form2 = str_replace('!!max_coord!!', '1', $coord_form2); $coord_form2 = str_replace('!!lib_1!!', '', $coord_form2); $coord_form2 = str_replace('!!id1!!', '0', $coord_form2); $coord_form2 = str_replace('!!cta_1!!', '', $coord_form2); $coord_form2 = str_replace('!!ad1_1!!', '', $coord_form2); $coord_form2 = str_replace('!!ad2_1!!', '', $coord_form2); $coord_form2 = str_replace('!!cpo_1!!', '', $coord_form2); $coord_form2 = str_replace('!!vil_1!!', '', $coord_form2); $coord_form2 = str_replace('!!eta_1!!', '', $coord_form2); $coord_form2 = str_replace('!!pay_1!!', '', $coord_form2); $coord_form2 = str_replace('!!te1_1!!', '', $coord_form2); $coord_form2 = str_replace('!!te2_1!!', '', $coord_form2); $coord_form2 = str_replace('!!fax_1!!', '', $coord_form2); $coord_form2 = str_replace('!!ema_1!!', '', $coord_form2); $coord_form2 = str_replace('!!com_1!!', '', $coord_form2); $coord_form2 = str_replace('!!commentaires!!', '', $coord_form2); $coord_form2 = str_replace('!!siret!!', '', $coord_form2); $coord_form2 = str_replace('!!rcs!!', '', $coord_form2); $coord_form2 = str_replace('!!naf!!', '', $coord_form2); $coord_form2 = str_replace('!!tva!!', '', $coord_form2); $coord_form2 = str_replace('!!site_web!!', '', $coord_form2); } else { $fourn = new entites($id_fou); $coord_form2 = str_replace('!!form_title!!', htmlentities($msg[acquisition_modif_fourn], ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!raison!!', htmlentities($fourn->raison_sociale, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!num_cp!!', htmlentities($fourn->num_cp_client, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!contact!!', $ptab[1], $coord_form2); $row = pmb_mysql_fetch_object(entites::get_coordonnees($fourn->id_entite, '1')); $coord_form2 = str_replace('!!id1!!', $row->id_contact, $coord_form2); $coord_form2 = str_replace('!!lib_1!!', htmlentities($row->libelle, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!cta_1!!', htmlentities($row->contact, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!ad1_1!!', htmlentities($row->adr1, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!ad2_1!!', htmlentities($row->adr2, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!cpo_1!!', htmlentities($row->cp, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!vil_1!!', htmlentities($row->ville, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!eta_1!!', htmlentities($row->etat, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!pay_1!!', htmlentities($row->pays, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!te1_1!!', htmlentities($row->tel1, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!te2_1!!', htmlentities($row->tel2, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!fax_1!!', htmlentities($row->fax, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!ema_1!!', htmlentities($row->email, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!com_1!!', htmlentities($row->commentaires, ENT_QUOTES, $charset), $coord_form2); $liste_coord = entites::get_coordonnees($fourn->id_entite, '0'); $coord_form2 = str_replace('!!max_coord!!', pmb_mysql_num_rows($liste_coord) + 1, $coord_form2); $i = 2; while ($row = pmb_mysql_fetch_object($liste_coord)) { $coord_form2 = str_replace('<!--coord_repetables-->', $ptab[2] . '<!--coord_repetables-->', $coord_form2); $coord_form2 = str_replace('!!no_X!!', $i, $coord_form2); $i++; $coord_form2 = str_replace('!!idX!!', $row->id_contact, $coord_form2); $coord_form2 = str_replace('!!lib_X!!', htmlentities($row->libelle, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!cta_X!!', htmlentities($row->contact, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!ad1_X!!', htmlentities($row->adr1, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!ad2_X!!', htmlentities($row->adr2, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!cpo_X!!', htmlentities($row->cp, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!vil_X!!', htmlentities($row->ville, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!eta_X!!', htmlentities($row->etat, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!pay_X!!', htmlentities($row->pays, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!te1_X!!', htmlentities($row->tel1, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!te2_X!!', htmlentities($row->tel2, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!fax_X!!', htmlentities($row->fax, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!ema_X!!', htmlentities($row->email, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!com_X!!', htmlentities($row->commentaires, ENT_QUOTES, $charset), $coord_form2); } $coord_form2 = str_replace('!!commentaires!!', htmlentities($fourn->commentaires, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!siret!!', htmlentities($fourn->siret, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!rcs!!', htmlentities($fourn->rcs, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!naf!!', htmlentities($fourn->naf, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!tva!!', htmlentities($fourn->tva, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('!!site_web!!', htmlentities($fourn->site_web, ENT_QUOTES, $charset), $coord_form2); $coord_form2 = str_replace('<!-- bouton_sup -->', $ptab[3], $coord_form2); $coord_form2 = str_replace('!!raison_suppr!!', addslashes($fourn->raison_sociale), $coord_form2); } print confirmation_delete("./acquisition.php?categ=ach&sub=fourn&action=del&id_bibli={$id_bibli}&id="); print $script; print $coord_form2; }
// +-------------------------------------------------+ // © 2002-2004 PMB Services / www.sigb.net pmb@sigb.net et contributeurs (voir www.sigb.net) // +-------------------------------------------------+ // $Id: liste_relances.inc.php,v 1.7 2015-04-03 11:16:26 jpermanne Exp $ if (stristr($_SERVER['REQUEST_URI'], ".inc.php")) { die("no access"); } // popup d'impression PDF pour liste des relances de receptions // reçoit : tab_no_mail require_once "{$class_path}/entites.class.php"; require_once "{$class_path}/receptions_relances.class.php"; $tab_fou = unserialize(rawurldecode($tab_no_mail)); if (count($tab_fou) && $id_bibli) { switch ($acquisition_pdfrel_pdfrtf) { case '1': $lettre = new lettreRelance_RTF(); break; default: $lettre = new lettreRelance_PDF(); break; } foreach ($tab_fou as $id_fou => $tab_act) { $bib = new entites($id_bibli); $bib_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_bibli, 1)); $fou = new entites($id_fou); $fou_coord = pmb_mysql_fetch_object(entites::get_coordonnees($id_fou, 1)); $lettre->doLettre($bib, $bib_coord, $fou, $fou_coord, $tab_act); } $lettre->getLettre(); }
function show_results($dbh, $user_input, $nbr_lignes = 0, $page = 0, $id = 0) { global $nb_per_page; global $base_url; global $caller; global $charset; global $msg; global $id_bibli; //comptage if ($user_input == "") { $nbr_lignes = entites::getNbFournisseurs($id_bibli); } else { $aq = new analyse_query(stripslashes($user_input)); 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::getNbFournisseurs($id_bibli, $aq); } if (!$page) { $page = 1; } $debut = ($page - 1) * $nb_per_page; if ($nbr_lignes) { //liste if ($user_input == "") { $res = entites::list_fournisseurs($id_bibli, $debut, $nb_per_page); } else { $res = entites::list_fournisseurs($id_bibli, $debut, $nb_per_page, $aq); } while ($row = mysql_fetch_object($res)) { $entry = $row->raison_sociale; $adresse = ''; if ($caller != 'form_abonnement') { $coord = entites::get_coordonnees($row->id_entite, '1'); if (mysql_num_rows($coord) != 0) { $coord = mysql_fetch_object($coord); if ($coord->libelle != '') { $adresse = htmlentities(addslashes($coord->libelle), ENT_QUOTES, $charset) . "\\n"; } if ($coord->contact != '') { $adresse .= htmlentities(addslashes($coord->contact), ENT_QUOTES, $charset) . "\\n"; } if ($coord->adr1 != '') { $adresse .= htmlentities(addslashes($coord->adr1), ENT_QUOTES, $charset) . "\\n"; } if ($coord->adr2 != '') { $adresse .= htmlentities(addslashes($coord->adr2), ENT_QUOTES, $charset) . "\\n"; } if ($coord->cp != '') { $adresse .= htmlentities(addslashes($coord->cp), ENT_QUOTES, $charset) . ' '; } if ($coord->ville != '') { $adresse .= htmlentities(addslashes($coord->ville), ENT_QUOTES, $charset); } } } print pmb_bidi("\n\t\t\t<a href='#' onclick=\"set_parent('{$caller}', '{$row->id_entite}', '" . htmlentities(addslashes($entry), ENT_QUOTES, $charset) . "', '{$adresse}' )\">{$entry}</a>"); print "<br />"; } mysql_free_result($res); // constitution des liens $nbepages = ceil($nbr_lignes / $nb_per_page); $suivante = $page + 1; $precedente = $page - 1; // affichage du lien précédent si nécessaire print '<hr /><div align=center>'; if ($precedente > 0) { print "<a href='{$base_url}&page={$precedente}&nbr_lignes={$nbr_lignes}&user_input=" . rawurlencode(stripslashes($user_input)) . "&no_display={$no_display}'><img src='./images/left.gif' border='0' title='{$msg['48']}' alt='[{$msg['48']}]' hspace='3' align='middle' /></a>"; } for ($i = 1; $i <= $nbepages; $i++) { if ($i == $page) { print "<b>{$i}/{$nbepages}</b>"; } } if ($suivante <= $nbepages) { print "<a href='{$base_url}&page={$suivante}&nbr_lignes={$nbr_lignes}&user_input=" . rawurlencode(stripslashes($user_input)) . "&no_display={$no_display}'><img src='./images/right.gif' border='0' title='{$msg['49']}' alt='[{$msg['49']}]' hspace='3' align='middle' /></a>"; } } print '</div>'; }
$array_selector[$typ . ',' . $lib_rem . ',' . $lib_tva] = htmlentities($lib_typ, ENT_QUOTES, $charset); } $origine = "ARRAY"; break; case 'fournisseurs': // $param1 : id_bibli $array_selector = array(); require_once $class_path . '/entites.class.php'; $requete = "select raison_sociale, id_entite from entites where type_entite='0' "; $requete .= "and num_bibli='" . $param1 . "' "; $requete .= "and raison_sociale like '" . addslashes($start) . "%' order by 1"; $res = pmb_mysql_query($requete, $dbh); while ($row = pmb_mysql_fetch_object($res)) { $adresse = ""; $idAdresse = 0; $coord = entites::get_coordonnees($row->id_entite, '1'); if (pmb_mysql_num_rows($coord) != 0) { $coord = pmb_mysql_fetch_object($coord); $idAdresse = $coord->id_contact; if ($coord->libelle != '') { $adresse = htmlentities($coord->libelle, ENT_QUOTES, $charset) . "\n"; } if ($coord->contact != '') { $adresse .= htmlentities($coord->contact, ENT_QUOTES, $charset) . "\n"; } if ($coord->adr1 != '') { $adresse .= htmlentities($coord->adr1, ENT_QUOTES, $charset) . "\n"; } if ($coord->adr2 != '') { $adresse .= htmlentities($coord->adr2, ENT_QUOTES, $charset) . "\n"; }
function doLettre($id_bibli, $id_dev) { global $msg, $pmb_pdf_font; //On récupère les infos du devis $dev = new actes($id_dev); $lignes = actes::getLignes($id_dev); $bib = new entites($dev->num_entite); $coord_liv = new coordonnees($dev->num_contact_livr); $coord_fac = new coordonnees($dev->num_contact_fact); $fou = new entites($dev->num_fournisseur); $coord_fou = entites::get_coordonnees($dev->num_fournisseur, '1'); $coord_fou = mysql_fetch_object($coord_fou); $this->PDF->AddPage(); $this->PDF->setFont($pmb_pdf_font); $this->PDF->npage = 1; //Affichage logo if ($bib->logo != '') { $this->PDF->Image($bib->logo, $this->x_logo, $this->y_logo, $this->l_logo, $this->h_logo); } //Affichage raison sociale $raison = $bib->raison_sociale; $this->PDF->setFontSize($this->fs_raison); $this->PDF->SetXY($this->x_raison, $this->y_raison); $this->PDF->MultiCell($this->l_raison, $this->h_raison, $raison, 0, 'L', 0); //Affichage date $ville $ville_end = stripos($coord_fac->ville, "cedex"); if ($ville_end !== false) { $ville = trim(substr($coord_fac->ville, 0, $ville_end)); } else { $ville = $coord_fac->ville; } $date = $ville . $this->sep_ville_date . format_date($dev->date_acte); $this->PDF->setFontSize($this->fs_date); $this->PDF->SetXY($this->x_date, $this->y_date); $this->PDF->Cell($this->l_date, $this->h_date, $date, 0, 0, 'L', 0); //Affichage coordonnees fournisseur //si pas de raison sociale définie, on reprend le libellé //si il y a une raison sociale, pas besoin if ($fou->raison_sociale != '') { $adr_fou = $fou->raison_sociale . "\n"; } else { $adr_fou = $coord_fou->libelle . "\n"; } if ($coord_fou->adr1 != '') { $adr_fou .= $coord_fou->adr1 . "\n"; } if ($coord_fou->adr2 != '') { $adr_fou .= $coord_fou->adr2 . "\n"; } if ($coord_fou->cp != '') { $adr_fou .= $coord_fou->cp . " "; } if ($coord_fou->ville != '') { $adr_fou .= $coord_fou->ville . "\n\n"; } if ($coord_fou->contact != '') { $adr_fou .= $coord_fou->contact; } $this->PDF->setFontSize($this->fs_adr_fou); $this->PDF->SetXY($this->x_adr_fou, $this->y_adr_fou); $this->PDF->MultiCell($this->l_adr_fou, $this->h_adr_fou, $adr_fou, 0, 'L', 0); //Affichage adresse facturation $adr_fac = $this->text_adr_fac . "\n"; if ($coord_fac->libelle != '') { $adr_fac .= $coord_fac->libelle . "\n"; } if ($coord_fac->adr1 != '') { $adr_fac .= $coord_fac->adr1 . "\n"; } if ($coord_fac->adr2 != '') { $adr_fac .= $coord_fac->adr2 . "\n"; } if ($coord_fac->cp != '') { $adr_fac .= $coord_fac->cp . " "; } if ($coord_fac->ville != '') { $adr_fac .= $coord_fac->ville . "\n"; } if ($coord_fac->tel1 != '') { $adr_fac .= $this->text_adr_fac_tel . " " . $coord_fac->tel1 . "\n"; } if ($coord_fac->tel2 != '') { $adr_fac .= $this->text_adr_fac_tel2 . " " . $coord_fac->tel2 . "\n"; } if ($coord_fac->fax != '') { $adr_fac .= $this->text_adr_fac_fax . " " . $coord_fac->fax . "\n"; } if ($coord_fac->email != '') { $adr_fac .= $this->text_adr_fac_email . " " . $coord_fac->email . "\n"; } $this->PDF->setFontSize($this->fs_adr_fac); $this->PDF->SetXY($this->x_adr_fac, $this->y_adr_fac); $this->PDF->MultiCell($this->l_adr_fac, $this->h_adr_fac, $adr_fac, 1, 'L', 0); //Affichage adresse livraison $adr_liv = ''; if ($coord_liv->libelle != '') { $adr_liv .= $coord_liv->libelle . "\n"; } if ($coord_liv->adr1 != '') { $adr_liv .= $coord_liv->adr1 . "\n"; } if ($coord_liv->adr2 != '') { $adr_liv .= $coord_liv->adr2 . "\n"; } if ($coord_liv->cp != '') { $adr_liv .= $coord_liv->cp . " "; } if ($coord_liv->ville != '') { $adr_liv .= $coord_liv->ville . "\n"; } if ($coord_liv->tel1 != '') { $adr_liv .= $this->text_adr_liv_tel . " " . $coord_liv->tel1 . "\n"; } if ($coord_liv->tel2 != '') { $adr_liv .= $this->text_adr_liv_tel2 . " " . $coord_liv->tel2 . "\n"; } if ($adr_liv != '') { $adr_liv = $this->text_adr_liv . "\n" . $adr_liv; $this->PDF->setFontSize($this->fs_adr_liv); $this->PDF->SetXY($this->x_adr_liv, $this->y_adr_liv); $this->PDF->MultiCell($this->l_adr_liv, $this->h_adr_liv, $adr_liv, 1, 'L', 0); } //Affichage tiret pliage $this->PDF->Line(0, 105, 3, 105); //Affichage numero devis $numero = $this->text_num . $dev->numero; $this->PDF->SetFontSize($this->fs_num); $this->PDF->Cell($this->l_num, $this->h_num, $numero, 0, 0, 'L', 0); $this->PDF->Ln(); //Affichage texte before + commentaires if ($dev->commentaires_i != '') { if ($this->text_before != '') { $this->text_before .= "\n\n"; } $this->text_before .= $dev->commentaires_i; } if ($this->text_before != '') { $this->PDF->SetFontSize($this->fs); $this->PDF->MultiCell($this->w, $this->h_tab, $this->text_before, 0, 'J', 0); $this->PDF->Ln(); } //Affichage lignes devis $this->PDF->SetAutoPageBreak(false); $this->PDF->AliasNbPages(); $this->PDF->SetFontSize($this->fs_tab); $this->PDF->SetFillColor(230); $this->y = $this->PDF->GetY(); $this->PDF->SetXY($this->x_tab, $this->y); $this->x_code = $this->x_tab; $this->w_code = round($this->w * 20 / 100); $this->x_lib = $this->x_code + $this->w_code; $this->w_lib = round($this->w * 60 / 100); $this->x_qte = $this->x_lib + $this->w_lib; $this->w_qte = round($this->w * 10 / 100); $this->doEntete(); while ($row = mysql_fetch_object($lignes)) { $typ = new types_produits($row->num_type); $col1 = $typ->libelle . "\n" . $row->code; $this->h = $this->h_tab * max($this->PDF->NbLines($this->w_code, $col1), $this->PDF->NbLines($this->w_lib, $row->libelle), $this->PDF->NbLines($this->w_qte, $row->nb)); $this->s = $this->y + $this->h; if ($this->s > $this->hauteur_page - $this->marge_bas) { $this->PDF->AddPage(); $this->PDF->SetXY($this->x_tab, $this->y_tab); $this->y = $this->PDF->GetY(); $this->doEntete(); } $this->PDF->SetXY($this->x_code, $this->y); $this->PDF->Rect($this->x_code, $this->y, $this->w_code, $this->h); $this->PDF->MultiCell($this->w_code, $this->h_tab, $col1, 0, 'L'); $this->PDF->SetXY($this->x_lib, $this->y); $this->PDF->Rect($this->x_lib, $this->y, $this->w_lib, $this->h); $this->PDF->MultiCell($this->w_lib, $this->h_tab, $row->libelle, 0, 'L'); $this->PDF->SetXY($this->x_qte, $this->y); $this->PDF->Rect($this->x_qte, $this->y, $this->w_qte, $this->h); $this->PDF->MultiCell($this->w_qte, $this->h_tab, $row->nb, 0, 'L'); $this->y = $this->y + $this->h; } $this->PDF->SetAutoPageBreak(true, $this->marge_bas); $this->PDF->SetX($this->marge_gauche); $this->PDF->SetY($this->y); $this->PDF->SetFontSize($this->fs); $this->PDF->Ln(); //Affichage texte after if ($this->text_after != '') { $this->PDF->MultiCell($this->w, $this->h_tab, $this->text_after, 0, 'J', 0); $this->PDF->Ln(); } //Affichage signature $this->PDF->Ln(); $this->PDF->SetFontSize($this->fs_sign); $this->PDF->SetX($this->x_sign); $this->PDF->MultiCell($this->l_sign, $this->h_sign, $this->text_sign, 0, 'L', 0); }
function doLettre($id_bibli, $id_cde) { global $msg, $acquisition_gestion_tva; //On récupère les infos de la commande $cde = new actes($id_cde); $lignes = actes::getLignes($id_cde); $bib = new entites($cde->num_entite); $coord_liv = new coordonnees($cde->num_contact_livr); $coord_fac = new coordonnees($cde->num_contact_fact); $fou = new entites($cde->num_fournisseur); $coord_fou = entites::get_coordonnees($cde->num_fournisseur, '1'); $coord_fou = pmb_mysql_fetch_object($coord_fou); $this->PDF->AddPage(); $this->PDF->npage = 1; //Affichage logo if ($bib->logo != '') { $this->PDF->Image($bib->logo, $this->x_logo, $this->y_logo, $this->l_logo, $this->h_logo); } //Affichage raison sociale $raison = $bib->raison_sociale; $this->PDF->setFontSize($this->fs_raison); $this->PDF->SetXY($this->x_raison, $this->y_raison); $this->PDF->MultiCell($this->l_raison, $this->h_raison, $raison, 0, 'L', 0); //Affichage date $ville $ville_end = stripos($coord_fac->ville, "cedex"); if ($ville_end !== false) { $ville = trim(substr($coord_fac->ville, 0, $ville_end)); } else { $ville = $coord_fac->ville; } if ($cde->date_valid != '0000-00-00') { $date = $ville . $this->sep_ville_date . format_date($cde->date_valid); } else { $date = $ville . $this->sep_ville_date . format_date($cde->date_acte); } $this->PDF->setFontSize($this->fs_date); $this->PDF->SetXY($this->x_date, $this->y_date); $this->PDF->Cell($this->l_date, $this->h_date, $date, 0, 0, 'L', 0); //Affichage coordonnees fournisseur //si pas de raison sociale définie, on reprend le libellé //si il y a une raison sociale, pas besoin if ($fou->raison_sociale != '') { $adr_fou = $fou->raison_sociale . "\n"; } else { $adr_fou = $coord_fou->libelle . "\n"; } if ($coord_fou->adr1 != '') { $adr_fou .= $coord_fou->adr1 . "\n"; } if ($coord_fou->adr2 != '') { $adr_fou .= $coord_fou->adr2 . "\n"; } if ($coord_fou->cp != '') { $adr_fou .= $coord_fou->cp . " "; } if ($coord_fou->ville != '') { $adr_fou .= $coord_fou->ville . "\n\n"; } if ($coord_fou->contact != '') { $adr_fou .= $coord_fou->contact; } $this->PDF->setFontSize($this->fs_adr_fou); $this->PDF->SetXY($this->x_adr_fou, $this->y_adr_fou); $this->PDF->MultiCell($this->l_adr_fou, $this->h_adr_fou, $adr_fou, 0, 'L', 0); //Affichage adresse facturation $adr_fac = $this->text_adr_fac . "\n"; if ($coord_fac->libelle != '') { $adr_fac .= $coord_fac->libelle . "\n"; } if ($coord_fac->adr1 != '') { $adr_fac .= $coord_fac->adr1 . "\n"; } if ($coord_fac->adr2 != '') { $adr_fac .= $coord_fac->adr2 . "\n"; } if ($coord_fac->cp != '') { $adr_fac .= $coord_fac->cp . " "; } if ($coord_fac->ville != '') { $adr_fac .= $coord_fac->ville . "\n"; } if ($coord_fac->tel1 != '') { $adr_fac .= $this->text_adr_fac_tel . " " . $coord_fac->tel1 . "\n"; } if ($coord_fac->tel2 != '') { $adr_fac .= $this->text_adr_fac_tel2 . " " . $coord_fac->tel2 . "\n"; } if ($coord_fac->fax != '') { $adr_fac .= $this->text_adr_fac_fax . " " . $coord_fac->fax . "\n"; } if ($coord_fac->email != '') { $adr_fac .= $this->text_adr_fac_email . " " . $coord_fac->email . "\n"; } if ($bib->tva) { $adr_fac .= $msg["acquisition_tva"] . ": " . $bib->tva . "\n"; } $this->PDF->setFontSize($this->fs_adr_fac); $this->PDF->SetXY($this->x_adr_fac, $this->y_adr_fac); $this->PDF->MultiCell($this->l_adr_fac, $this->h_adr_fac, $adr_fac, 1, 'L', 0); //Affichage adresse livraison $adr_liv = ''; if ($coord_liv->libelle != '') { $adr_liv .= $coord_liv->libelle . "\n"; } if ($coord_liv->adr1 != '') { $adr_liv .= $coord_liv->adr1 . "\n"; } if ($coord_liv->adr2 != '') { $adr_liv .= $coord_liv->adr2 . "\n"; } if ($coord_liv->cp != '') { $adr_liv .= $coord_liv->cp . " "; } if ($coord_liv->ville != '') { $adr_liv .= $coord_liv->ville . "\n"; } if ($coord_liv->tel1 != '') { $adr_liv .= $this->text_adr_liv_tel . " " . $coord_liv->tel1 . "\n"; } if ($coord_liv->tel2 != '') { $adr_liv .= $this->text_adr_liv_tel2 . " " . $coord_liv->tel2 . "\n"; } if ($coord_liv->email != '') { $adr_liv .= $this->text_adr_liv_email . " " . $coord_liv->email . "\n"; } if ($adr_liv != '') { $adr_liv = $this->text_adr_liv . "\n" . $adr_liv; $this->PDF->setFontSize($this->fs_adr_liv); $this->PDF->SetXY($this->x_adr_liv, $this->y_adr_liv); $this->PDF->MultiCell($this->l_adr_liv, $this->h_adr_liv, $adr_liv, 1, 'L', 0); } //Affichage tiret pliage $this->PDF->Line(0, 105, 3, 105); $this->y = $this->PDF->GetY(); $this->PDF->Ln(); $this->PDF->Ln(); //Affichage numero client $numero_cli = $this->text_num_cli . " " . $fou->num_cp_client; $this->PDF->SetFontSize($this->fs_num); $this->PDF->SetXY($this->x_num, $this->y_num); $this->PDF->Cell($this->l_num_cli, $this->h_num, $numero_cli, 0, 0, 'L', 0); $this->PDF->Ln(); //Affichage numero commande $numero = $this->text_num . $cde->numero; $this->PDF->SetFontSize($this->fs_num); $this->PDF->Cell($this->l_num, $this->h_num, $numero, 0, 0, 'L', 0); $this->PDF->Ln(); //Affichage reference if ($cde->reference != '') { $ref = $this->text_ref . $cde->reference; $this->PDF->SetFontSize($this->fs); $this->PDF->Cell($this->w, $this->h_tab, $ref, 0, 0, 'L', 0); $this->PDF->Ln(); $this->PDF->Ln(); } //Affichage texte before + commentaires if ($cde->commentaires_i != '') { if ($this->text_before != '') { $this->text_before .= "\n\n"; } $this->text_before .= $cde->commentaires_i; } if ($this->text_before != '') { $this->PDF->SetFontSize($this->fs); $this->PDF->MultiCell($this->w, $this->h_tab, $this->text_before, 0, 'J', 0); } //Affichage lignes commandes $this->PDF->SetAutoPageBreak(false); $this->PDF->AliasNbPages(); $this->PDF->SetFontSize($this->fs_tab); $this->PDF->SetFillColor(230); $this->y = $this->PDF->GetY(); $this->PDF->SetXY($this->x_tab, $this->y); $tab_mnt = array(); $i = 0; while ($row = pmb_mysql_fetch_object($lignes)) { $typ = new types_produits($row->num_type); $col1 = $typ->libelle; if ($row->code) { $col1 .= "\n" . $row->code; } $col2 = $row->libelle; $col3 = $row->nb; $col4 = number_format(round($row->prix, 2), 2, '.', '') . " " . $cde->devise; if ($acquisition_gestion_tva) { $col4 .= "\n" . number_format(round($row->tva, 2), 2, '.', '') . " %"; } $col4 .= "\n" . number_format(round($row->remise, 2), 2, '.', '') . " %"; $col5 = ''; if ($row->date_ech != '0000-00-00') { $col5 = formatdate($row->date_ech); } if ($row->num_rubrique) { $rub = new rubriques($row->num_rubrique); if ($rub->num_cp_compta) { $col5 .= "\n\n" . $rub->num_cp_compta; } } //Est ce qu'on dépasse ? $this->h = $this->h_tab * max($this->PDF->NbLines($this->w_col1, $col1), $this->PDF->NbLines($this->w_col2, $col2), $this->PDF->NbLines($this->w_col3, $col3), $this->PDF->NbLines($this->w_col4, $col4), $this->PDF->NbLines($this->w_col5, $col5)); $this->s = $this->y + $this->h; if (!$this->p_header) { $this->s = $this->s + $this->h_header; } //Si oui, chgt page if ($this->s > $this->hauteur_page - $this->marge_bas - $this->fs_footer) { $this->PDF->AddPage(); $this->y = $this->y_tab; $this->p_header = false; } if (!$this->p_header) { $this->doEntete(); $this->y += $this->h_header; } $this->p_header = true; $this->PDF->SetXY($this->x_col1, $this->y); $this->PDF->Rect($this->x_col1, $this->y, $this->w_col1, $this->h); $this->PDF->MultiCell($this->w_col1, $this->h_tab, $col1, 0, 'L'); $this->PDF->SetXY($this->x_col2, $this->y); $this->PDF->Rect($this->x_col2, $this->y, $this->w_col2, $this->h); $this->PDF->MultiCell($this->w_col2, $this->h_tab, $col2, 0, 'L'); $this->PDF->SetXY($this->x_col3, $this->y); $this->PDF->Rect($this->x_col3, $this->y, $this->w_col3, $this->h); $this->PDF->MultiCell($this->w_col3, $this->h_tab, $col3, 0, 'R'); $this->PDF->SetXY($this->x_col4, $this->y); $this->PDF->Rect($this->x_col4, $this->y, $this->w_col4, $this->h); $this->PDF->MultiCell($this->w_col4, $this->h_tab, $col4, 0, 'R'); $this->PDF->SetXY($this->x_col5, $this->y); $this->PDF->Rect($this->x_col5, $this->y, $this->w_col5, $this->h); $this->PDF->MultiCell($this->w_col5, $this->h_tab, $col5, 0, 'R'); $this->y += $this->h; $tab_mnt[$i]['q'] = $row->nb; $tab_mnt[$i]['p'] = $row->prix; $tab_mnt[$i]['r'] = $row->remise; $tab_mnt[$i]['t'] = $row->tva; $i++; } $this->PDF->SetAutoPageBreak(true, $this->marge_bas); $this->PDF->SetX($this->marge_gauche); $this->PDF->SetY($this->y); $this->PDF->SetFontSize($this->fs); $this->PDF->Ln(); //affichage des montants ht, ttc, tva $tab_tot = calc($tab_mnt, 2); $this->y = $this->PDF->GetY(); if ($acquisition_gestion_tva) { $this->h = $this->h_tot * 3; } else { $this->h = $this->h_tot; } $this->s = $this->y + $this->h; if ($this->s > $this->hauteur_page - $this->marge_bas) { $this->PDF->AddPage(); $this->PDF->SetXY($this->x_tot, $this->marge_haut); $this->y = $this->PDF->GetY(); } if ($acquisition_gestion_tva) { $this->PDF->Cell($this->l_tot, $this->h_tot, $msg['acquisition_total_ht'], 1, 0, 'L', 0); $this->PDF->Cell($this->l_tot, $this->h_tot, number_format($tab_tot['ht'], 2, '.', '') . " " . $cde->devise, 1, 1, 'R', 0); $this->PDF->Cell($this->l_tot, $this->h_tot, $msg['acquisition_tva'], 1, 0, 'L', 0); $this->PDF->Cell($this->l_tot, $this->h_tot, number_format($tab_tot['tva'], 2, '.', '') . " " . $cde->devise, 1, 1, 'R', 0); } $this->PDF->Cell($this->l_tot, $this->h_tot, $msg['acquisition_total_ttc'], 1, 0, 'L', 0); $this->PDF->Cell($this->l_tot, $this->h_tot, number_format($tab_tot['ttc'], 2, '.', '') . " " . $cde->devise, 1, 1, 'R', 0); $this->PDF->Ln(); //Affichage conditions de paiement $text_paiement = $msg['acquisition_mode_pai']; if ($fou->num_paiement) { $pai = new paiements($fou->num_paiement); $text_paiement .= "{$pai->libelle}"; $this->PDF->MultiCell($this->w, $this->h_tab, $text_paiement, 0, 'L', 0); $this->PDF->Ln(); } //Affichage texte after if ($this->text_after != '') { $this->PDF->MultiCell($this->w, $this->h_tab, $this->text_after, 0, 'J', 0); $this->PDF->Ln(); } //Affichage signature $this->PDF->Ln(); $this->PDF->SetFontSize($this->fs_sign); $this->PDF->SetX($this->x_sign); $this->PDF->MultiCell($this->l_sign, $this->h_sign, $this->text_sign, 0, 'L', 0); }
function generate_RTF() { global $base_path, $charset, $msg, $biblio_logo; global $biblio_name, $biblio_logo, $biblio_adr1, $biblio_adr2, $biblio_cp, $biblio_town, $biblio_state, $biblio_country, $biblio_phone, $biblio_email, $biblio_website; global $madame_monsieur; //Format des fonts $fontHead = new Font(12, 'Arial', '#0E298A'); $fontHead->setBold(); $fontSmall = new Font(1); $fontComment = new Font(10, 'Arial'); $fontComment->setItalic(); $fontChapter = new Font(10, 'Arial'); $fontSubChapter = new Font(10, 'Arial'); $fontSubChapter->setUnderline(); //Format des paragraphes $parPmb = new ParFormat(); $parPmb->setIndentRight(12.5); $parPmb->setBackColor('#0E298A'); $parPmb->setSpaceAfter(8); $parHead = new ParFormat(); $parHead->setSpaceBefore(5); $parChapter = new ParFormat(); $parChapter->setSpaceBefore(2); $parChapter->setSpaceAfter(1); $parComment = new ParFormat(); $parComment->setIndentLeft(1); $parComment->setIndentRight(0.5); $parContenu = new ParFormat('justify'); $parContenu->setIndentLeft(1); $parSubChapter = new ParFormat(); $parSubChapter->setIndentLeft(0.5); $parInfo = new ParFormat(); $parInfo->setIndentLeft(0, 5); $parInfo->setSpaceAfter(1.5); $parInfoBib = new ParFormat(); $parInfoBib->setIndentLeft(0); $parInfoBib->setSpaceAfter(1.5); //Document $rtf = new Rtf(); $rtf->setMargins(1, 1, 1, 1); foreach ($this->liste_rel as $id_fournisseur => $info_fournisseur) { $rtf->setMargins(1, 1, 1, 1); $sect =& $rtf->addSection(); $table =& $sect->addTable(); $table->addRows(1, 2); $table->addColumnsList(array(15, 4)); //$table->addImageToCell(1,1,$base_path."/images/".$biblio_logo,new ParFormat('center'),0,0); // Info biblio $cell =& $table->getCell(1, 1); $cell->writeText($this->to_utf8($biblio_name), new Font(14, 'Arial', '#0E298A'), new ParFormat('left')); if ($biblio_adr1) { $cell->writeText($this->to_utf8($biblio_adr1), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($biblio_adr2) { $cell->writeText($this->to_utf8($biblio_adr2), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($biblio_cp || $biblio_town) { $cell->writeText($this->to_utf8($biblio_cp . " " . $biblio_town), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($biblio_phone) { $cell->writeText($this->to_utf8($biblio_phone), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($biblio_email) { $cell->writeText($this->to_utf8($biblio_email), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } // Info date de génération $cell =& $table->getCell(1, 2); if ($biblio_email) { $cell->writeText($this->to_utf8("\n" . $msg['fpdf_edite'] . " " . formatdate(date("Y-m-d", time())), ENT_QUOTES, $charset), new Font(12, 'Arial', '#0E298A'), new ParFormat('right')); } if ($id_fournisseur) { $fou = new entites($id_fournisseur); $coord_fou = entites::get_coordonnees($id_fournisseur, 1); $coord_fou = pmb_mysql_fetch_object($coord_fou); if ($fou->raison_sociale != '') { $libelle = $fou->raison_sociale; } else { $libelle = $coord_fou->libelle; } $table =& $sect->addTable(); $table->addRows(2, 2); $table->addColumnsList(array(9, 10)); $cell =& $table->getCell(1, 2); $cell->writeText($this->to_utf8($libelle), new Font(14, 'Arial', '#0E298A'), new ParFormat('left')); if ($coord_fou->adr1) { $cell->writeText($this->to_utf8($coord_fou->adr1), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($coord_fou->adr2) { $cell->writeText($this->to_utf8($coord_fou->adr2), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($coord_fou->cp) { $cell->writeText($this->to_utf8($coord_fou->cp), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($coord_fou->ville) { $cell->writeText($this->to_utf8($coord_fou->ville), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } if ($coord_fou->contact != '') { $cell =& $table->getCell(2, 2); $cell->writeText($this->to_utf8($msg['acquisition_act_formule'] . " " . $coord_fou->contact), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); } } $sect->writeText($this->to_utf8($msg["abts_gestion_retard_lettre_monsieur"] . "<br />"), new Font(12, 'Arial', '#0E298A'), new ParFormat('left')); foreach ($info_fournisseur as $num_notice => $info_notice) { //print $num_notice; print_r($info_notice) ;exit; $perio = new serial_display($num_notice); $sect->writeText($this->to_utf8($perio->notice->tit1), $fontHead, $parHead); $sect->emptyParagraph($fontSmall, $parPmb); foreach ($info_notice as $abt_num => $info_abt) { //$sect->writeText($this->to_utf8($doc), new Font(10,'Arial'), $parInfo); foreach ($info_abt as $rel_id => $rel_info) { $date = "<u>" . $rel_info["rel_libelle_numero"] . "</u> : " . formatdate($rel_info["rel_date_parution"]); $sect->writeText($this->to_utf8($date), new Font(10, 'Arial'), $parInfo); $sect->writeText($this->to_utf8($rel_info["rel_comment_gestion"]), new Font(10, 'Arial'), $parSubChapter); } } } $sect->insertPageBreak(); } $rtf->sendRtf("rapport"); }
function do_relances() { global $dbh, $charset; global $id_bibli, $chk, $id_lig; global $acquisition_pdfrel_obj_mail, $acquisition_pdfrel_text_mail; global $acquisition_pdfrel_by_mail, $PMBuseremailbcc; //recuperation des lignes a relancer $tab_lig = array(); foreach ($chk as $v) { if ($id_lig[$v]) { $tab_lig[] = $id_lig[$v]; } } $tab_fou = array(); $q = lignes_actes::getLines($tab_lig, true); if ($q) { $r = mysql_query($q, $dbh); if (mysql_num_rows($r)) { while ($row = mysql_fetch_object($r)) { if (!array_key_exists($row->num_fournisseur, $tab_fou)) { $tab_fou[$row->num_fournisseur] = array(); } if (!array_key_exists($row->id_acte, $tab_fou[$row->num_fournisseur])) { $tab_fou[$row->num_fournisseur][$row->id_acte] = array(); } $tab_fou[$row->num_fournisseur][$row->id_acte][] = $row->id_ligne; } } } $bib = new entites($id_bibli); $bib_coord = mysql_fetch_object(entites::get_coordonnees($id_bibli, 1)); $tab_no_mail = array(); if (!($acquisition_pdfrel_by_mail && strpos($bib_coord->email, '@'))) { $tab_no_mail = $tab_fou; } else { if (count($tab_fou)) { foreach ($tab_fou as $id_fou => $tab_act) { $fou = new entites($id_fou); $fou_coord = mysql_fetch_object(entites::get_coordonnees($id_fou, 1)); //Si on peut relancer par mail if (strpos($fou_coord->email, '@')) { $dest_name = ''; if ($fou_coord->libelle) { $dest_name = $fou_coord->libelle; } else { $dest_name = $fou->raison_sociale; } if ($fou_coord->contact) { $dest_name .= " " . $fou_coord->contact; } $dest_mail = $fou_coord->email; $obj_mail = $acquisition_pdfrel_obj_mail; $text_mail = $acquisition_pdfrel_text_mail; $bib_name = $bib_coord->raison_sociale; $bib_mail = $bib_coord->email; $lettre = new lettreRelance_PDF(); $lettre->doLettre($bib, $bib_coord, $fou, $fou_coord, $tab_act); $piece_jointe = array(); $piece_jointe[0]['contenu'] = $lettre->getLettre('S'); $piece_jointe[0]['nomfichier'] = $lettre->getFileName(); // mailpmb($to_nom="", $to_mail, $obj="", $corps="", $from_name="", $from_mail, $headers, $copie_CC="", $copie_BCC="", $faire_nl2br=0, $pieces_jointes=array()) $res_envoi = mailpmb($dest_name, $dest_mail, $obj_mail, $text_mail, $bib_name, $bib_mail, "Content-Type: text/plain; charset=\"{$charset}\"", '', $PMBuseremailbcc, 1, $piece_jointe); if (!$res_envoi) { $tab_no_mail[$id_fou] = $tab_act; } } else { $tab_no_mail[$id_fou] = $tab_act; } } } } if (count($tab_no_mail)) { print "\t\n\t\t<form name='print_liste_relances' action='pdf.php?pdfdoc=listrecept' target='lettre' method='post'>\t\t\n\t\t\t<input type='hidden' name='id_bibli' value='" . $id_bibli . "'/>\n\t\t\t<input type='hidden' name='tab_no_mail' value='" . rawurlencode(serialize($tab_no_mail)) . "'/>\n\t\t\t<script type='text/javascript'>\n\t\t\t\topenPopUp('','lettre', 600, 500, -2, -2, 'toolbar=no, dependent=yes, resizable=yes');\n\t\t\t\tdocument.print_liste_relances.submit();\n\t\t\t</script>\n\t\t</form>"; } lignes_actes::setRelances($tab_lig); }