Ejemplos de contrat_prepare_head en PHP

Ejemplo n.º 1

Archivo: bilan_contrat.php Proyecto: abbenbouchta/immobilier

// Class
dol_include_once("/immobilier/class/contrat.class.php");
dol_include_once('/immobilier/lib/immobilier.lib.php');
// Langs
$langs->load("immobilier@immobilier");
$id = GETPOST('id', 'int');
$mesg = '';
$limit = $conf->liste_limit;
/*
* loyer et paiement par contrat
*
*/
llxheader('', $langs->trans("bilancontrat"), '');
$contrat = new Contrat($db);
$result = $contrat->fetch($id);
$head = contrat_prepare_head($contrat);
dol_fiche_head($head, 'info', $langs->trans("Imoinfo"), 0, 'agreement');
$sql = "(SELECT l.periode_du as date , l.montant_tot as debit, 0 as credit , l.nom as des";
$sql .= " FROM " . MAIN_DB_PREFIX . "immo_loyer as l";
$sql .= " WHERE l.contrat_id =" . $id;
$sql .= ")";
$sql .= "UNION (SELECT p.date_paiement as date, 0 as debit , p.montant as credit, p.commentaire as des";
$sql .= " FROM " . MAIN_DB_PREFIX . "immo_paie as p";
$sql .= " WHERE p.contrat_id =" . $id;
$sql .= ")";
$sql .= "ORDER BY date";
$result = $db->query($sql);
if ($result) {
    $num_lignes = $db->num_rows($result);
    $i = 0;
    print '<table class="border" width="100%">';

Ejemplo n.º 2

Archivo: bilan_local.php Proyecto: abbenbouchta/immobilier

// Class
dol_include_once("/immobilier/class/local.class.php");
dol_include_once('/immobilier/lib/immobilier.lib.php');
// Langs
$langs->load("immobilier@immobilier");
$id = GETPOST('id', 'int');
$mesg = '';
$limit = $conf->liste_limit;
/*
* loyer et paiement par local
*
*/
llxheader('', $langs->trans("bilanlocal"), '');
$local = new Local($db);
$result = $local->fetch($id);
$head = contrat_prepare_head($local);
dol_fiche_head($head, 'info', $langs->trans("Imoinfo"), 0, 'propertie');
$sql = "(SELECT l.periode_du as date , l.montant_tot as debit, 0 as credit , l.nom as des";
$sql .= " FROM " . MAIN_DB_PREFIX . "immo_loyer as l";
$sql .= " WHERE l.local_id =" . $id;
$sql .= ")";
$sql .= "UNION (SELECT p.date_paiement as date, 0 as debit , p.montant as credit, p.commentaire as des";
$sql .= " FROM " . MAIN_DB_PREFIX . "immo_paie as p";
$sql .= " WHERE p.local_id =" . $id;
$sql .= ")";
$sql .= "ORDER BY date";
$result = $db->query($sql);
if ($result) {
    $num_lignes = $db->num_rows($result);
    $i = 0;
    print '<table class="border" width="100%">';