// 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%">';
// 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%">';