38require
'../main.inc.php';
39require_once DOL_DOCUMENT_ROOT.
'/core/class/html.formfile.class.php';
40require_once DOL_DOCUMENT_ROOT.
'/compta/facture/class/facture.class.php';
41require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.facture.class.php';
42require_once DOL_DOCUMENT_ROOT.
'/commande/class/commande.class.php';
43require_once DOL_DOCUMENT_ROOT.
'/fourn/class/fournisseur.commande.class.php';
44require_once DOL_DOCUMENT_ROOT.
'/compta/sociales/class/chargesociales.class.php';
45require_once DOL_DOCUMENT_ROOT.
'/core/class/dolgraph.class.php';
46require_once DOL_DOCUMENT_ROOT.
'/core/lib/invoice.lib.php';
54$langs->loadLangs(array(
'compta',
'bills'));
55if (isModEnabled(
'order')) {
56 $langs->load(
"orders");
60$action =
GETPOST(
'action',
'aZ09');
65if ($user->socid > 0) {
67 $socid = $user->socid;
72$maxDraftCount = !
getDolGlobalString(
'MAIN_MAXLIST_OVERLOAD') ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD;
73$maxLatestEditCount = 5;
74$maxOpenCount = !
getDolGlobalString(
'MAIN_MAXLIST_OVERLOAD') ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD;
77$hookmanager->initHooks(array(
'invoiceindex'));
80$maxofloop = (!
getDolGlobalString(
'MAIN_MAXLIST_OVERLOAD') ? 500 : $conf->global->MAIN_MAXLIST_OVERLOAD);
98$thirdpartystatic =
new Societe($db);
100llxHeader(
"", $langs->trans(
"InvoicesArea"));
105print
'<div class="fichecenter">';
107print
'<div class="twocolumns">';
109print
'<div class="firstcolumn fichehalfleft boxhalfleft" id="boxhalfleft">';
112if (isModEnabled(
'invoice')) {
117if (isModEnabled(
'fournisseur') || isModEnabled(
'supplier_invoice')) {
122if (isModEnabled(
'invoice')) {
127if (isModEnabled(
'fournisseur') || isModEnabled(
'supplier_invoice')) {
133print
'</div><div class="secondcolumn fichehalfright boxhalfright" id="boxhalfright">';
137if (isModEnabled(
'invoice') && $user->hasRight(
'facture',
'lire')) {
138 $langs->load(
"boxes");
139 $tmpinvoice =
new Facture($db);
141 $sql =
"SELECT f.rowid, f.ref, f.fk_statut as status, f.type, f.total_ht, f.total_tva, f.total_ttc, f.paye, f.tms";
142 $sql .=
", f.date_lim_reglement as datelimite";
143 $sql .=
", s.nom as name";
144 $sql .=
", s.rowid as socid";
145 $sql .=
", s.code_client, s.code_compta, s.email";
146 $sql .=
", cc.rowid as country_id, cc.code as country_code";
147 $sql .=
", (SELECT SUM(pf.amount) FROM ".$db->prefix().
"paiement_facture as pf WHERE pf.fk_facture = f.rowid) as am";
148 $sql .=
" FROM ".MAIN_DB_PREFIX.
"facture as f";
149 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"societe as s ON s.rowid = f.fk_soc";
150 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as cc ON cc.rowid = s.fk_pays";
151 $sql .=
" WHERE f.entity IN (".getEntity(
'invoice').
")";
153 $sql .=
" AND f.fk_soc = ".((int) $socid);
156 if (!$user->hasRight(
'societe',
'client',
'voir')) {
157 $sql .=
" AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = f.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
160 $parameters = array();
161 $reshook = $hookmanager->executeHooks(
'printFieldListWhereCustomerLastModified', $parameters);
162 $sql .= $hookmanager->resPrint;
164 $sql .=
" ORDER BY f.tms DESC";
165 $sql .= $db->plimit($max, 0);
167 $resql = $db->query($sql);
169 $num = $db->num_rows($resql);
173 print
'<div class="div-table-responsive-no-min">';
174 print
'<table class="noborder centpercent">';
176 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"BoxTitleLastCustomerBills", $max);
177 print
'<a href="'.DOL_URL_ROOT.
'/compta/facture/list.php?sortfield=f.tms&sortorder=desc"><span class="badge marginleftonly">...</span></a>';
180 print
'<th class="right">'.$langs->trans(
"AmountHT").
'</th>';
182 print
'<th class="right">'.$langs->trans(
"AmountTTC").
'</th>';
183 print
'<th class="right">'.$langs->trans(
"DateModificationShort").
'</th>';
184 print
'<th width="16"> </th>';
187 $total_ttc = $totalam = $total_ht = 0;
188 while ($i < $num && $i < $conf->liste_limit) {
189 $obj = $db->fetch_object($resql);
194 $total_ht += $obj->total_ht;
195 $total_ttc += $obj->total_ttc;
199 $tmpinvoice->ref = $obj->ref;
200 $tmpinvoice->id = $obj->rowid;
201 $tmpinvoice->total_ht = $obj->total_ht;
202 $tmpinvoice->total_tva = $obj->total_tva;
203 $tmpinvoice->total_ttc = $obj->total_ttc;
204 $tmpinvoice->statut = $obj->status;
205 $tmpinvoice->status = $obj->status;
206 $tmpinvoice->paye = $obj->paye;
207 $tmpinvoice->date_lim_reglement = $db->jdate($obj->datelimite);
208 $tmpinvoice->type = $obj->type;
210 $thirdpartystatic->id = $obj->socid;
211 $thirdpartystatic->name = $obj->name;
212 $thirdpartystatic->email = $obj->email;
213 $thirdpartystatic->country_id = $obj->country_id;
214 $thirdpartystatic->country_code = $obj->country_code;
215 $thirdpartystatic->email = $obj->email;
216 $thirdpartystatic->client = 1;
217 $thirdpartystatic->code_client = $obj->code_client;
219 $thirdpartystatic->code_compta_client = $obj->code_compta;
222 $totalallpayments = $tmpinvoice->getSommePaiement(0);
223 $totalallpayments += $tmpinvoice->getSumCreditNotesUsed(0);
224 $totalallpayments += $tmpinvoice->getSumDepositsUsed(0);
225 print
'<tr class="oddeven">';
226 print
'<td class="nowrap">';
228 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
230 print
'<td class="nobordernopadding nowraponall">';
231 print $tmpinvoice->getNomUrl(1,
'');
233 if ($tmpinvoice->hasDelay()) {
234 print
'<td width="20" class="nobordernopadding nowrap">';
238 print
'<td width="16" class="nobordernopadding hideonsmartphone right">';
241 $urlsource = $_SERVER[
'PHP_SELF'].
'?facid='.$obj->rowid;
242 print $formfile->getDocumentsLink($tmpinvoice->element, $filename, $filedir);
243 print
'</td></tr></table>';
247 print
'<td class="tdoverflowmax150">';
248 print $thirdpartystatic->getNomUrl(1,
'customer', 44);
251 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ht).
'</span></td>';
253 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
'</span></td>';
255 print
'<td class="right" title="'.dol_escape_htmltag($langs->trans(
"DateModificationShort").
' : '.
dol_print_date($db->jdate($obj->tms),
'dayhour',
'tzuserrel')).
'">'.
dol_print_date($db->jdate($obj->tms),
'day',
'tzuserrel').
'</td>';
257 print
'<td>'.$tmpinvoice->getLibStatut(3, $totalallpayments).
'</td>';
261 $total_ttc += $obj->total_ttc;
262 $total_ht += $obj->total_ht;
263 $totalam += $obj->am;
269 print
'<tr class="oddeven">';
270 print
'<td class="nowrap" colspan="5">';
271 print
'<span class="opacitymedium">'.$langs->trans(
"More").
'... ('.$othernb.
')</span>';
280 print
'<tr class="oddeven"><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoInvoice").
'</span></td></tr>';
282 print
'</table></div><br>';
291if ((isModEnabled(
'fournisseur') && !
getDolGlobalString(
'MAIN_USE_NEW_SUPPLIERMOD') && $user->hasRight(
"fournisseur",
"facture",
"lire")) || (isModEnabled(
'supplier_invoice') && $user->hasRight(
"supplier_invoice",
"lire"))) {
292 $langs->load(
"boxes");
295 $sql =
"SELECT ff.rowid, ff.ref, ff.fk_statut as status, ff.type, ff.libelle, ff.total_ht, ff.total_tva, ff.total_ttc, ff.tms, ff.paye, ff.ref_supplier";
296 $sql .=
", s.nom as name";
297 $sql .=
", s.rowid as socid";
298 $sql .=
", s.code_fournisseur, s.code_compta_fournisseur, s.email";
299 $sql .=
", (SELECT SUM(pf.amount) FROM ".$db->prefix().
"paiementfourn_facturefourn as pf WHERE pf.fk_facturefourn = ff.rowid) as am";
300 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s, ".MAIN_DB_PREFIX.
"facture_fourn as ff";
301 $sql .=
" WHERE s.rowid = ff.fk_soc";
302 $sql .=
" AND ff.entity IN (".getEntity(
'facture_fourn').
")";
304 $sql .=
" AND ff.fk_soc = ".((int) $socid);
307 if (!$user->hasRight(
'societe',
'client',
'voir')) {
308 $sql .=
" AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = ff.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
311 $parameters = array();
312 $reshook = $hookmanager->executeHooks(
'printFieldListWhereSupplierLastModified', $parameters);
313 $sql .= $hookmanager->resPrint;
315 $sql .=
" ORDER BY ff.tms DESC";
316 $sql .= $db->plimit($max, 0);
318 $resql = $db->query($sql);
320 $num = $db->num_rows($resql);
322 print
'<div class="div-table-responsive-no-min">';
323 print
'<table class="noborder centpercent">';
324 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"BoxTitleLastSupplierBills", $max);
325 print
'<a href="'.DOL_URL_ROOT.
'/fourn/facture/list.php?sortfield=f.tms&sortorder=desc"><span class="badge marginleftonly">...</span></a>';
328 print
'<th class="right">'.$langs->trans(
"AmountHT").
'</th>';
330 print
'<th class="right">'.$langs->trans(
"AmountTTC").
'</th>';
331 print
'<th class="right">'.$langs->trans(
"DateModificationShort").
'</th>';
332 print
'<th width="16"> </th>';
336 $total_ht = $total_ttc = $totalam = 0;
340 $obj = $db->fetch_object($resql);
345 $total_ht += $obj->total_ht;
346 $total_ttc += $obj->total_ttc;
350 $facstatic->ref = $obj->ref;
351 $facstatic->id = $obj->rowid;
352 $facstatic->total_ht = $obj->total_ht;
353 $facstatic->total_tva = $obj->total_tva;
354 $facstatic->total_ttc = $obj->total_ttc;
355 $facstatic->statut = $obj->status;
356 $facstatic->status = $obj->status;
357 $facstatic->paye = $obj->paye;
358 $facstatic->paid = $obj->paye;
359 $facstatic->type = $obj->type;
360 $facstatic->ref_supplier = $obj->ref_supplier;
362 $thirdpartystatic->id = $obj->socid;
363 $thirdpartystatic->name = $obj->name;
364 $thirdpartystatic->email = $obj->email;
365 $thirdpartystatic->country_id = 0;
366 $thirdpartystatic->country_code =
'';
367 $thirdpartystatic->client = 0;
368 $thirdpartystatic->fournisseur = 1;
369 $thirdpartystatic->code_client =
'';
370 $thirdpartystatic->code_fournisseur = $obj->code_fournisseur;
371 $thirdpartystatic->code_compta_client =
'';
372 $thirdpartystatic->code_compta_fournisseur = $obj->code_compta_fournisseur;
374 print
'<tr class="oddeven nowraponall tdoverflowmax100"><td>';
375 print $facstatic->getNomUrl(1,
'');
377 print
'<td class="nowrap tdoverflowmax100">';
378 print $thirdpartystatic->getNomUrl(1,
'supplier');
381 print
'<td class="right"><span class="amount">'.price($obj->total_ht).
'</span></td>';
383 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
'</span></td>';
384 print
'<td class="right" title="'.dol_escape_htmltag($langs->trans(
"DateModificationShort").
' : '.
dol_print_date($db->jdate($obj->tms),
'dayhour',
'tzuserrel')).
'">'.
dol_print_date($db->jdate($obj->tms),
'day',
'tzuserrel').
'</td>';
385 $alreadypaid = $facstatic->getSommePaiement();
386 $alreadypaid += $facstatic->getSumCreditNotesUsed();
387 $alreadypaid += $facstatic->getSumDepositsUsed();
388 print
'<td>'.$facstatic->getLibStatut(3, $alreadypaid).
'</td>';
390 $total_ht += $obj->total_ht;
391 $total_ttc += $obj->total_ttc;
392 $totalam += $obj->am;
397 print
'<tr class="oddeven">';
398 print
'<td class="nowrap" colspan="5">';
399 print
'<span class="opacitymedium">'.$langs->trans(
"More").
'... ('.$othernb.
')</span>';
408 print
'<tr class="oddeven"><td colspan="'.$colspan.
'"><span class="opacitymedium">'.$langs->trans(
"NoInvoice").
'</span></td></tr>';
410 print
'</table></div><br>';
419if (isModEnabled(
'don') && $user->hasRight(
'don',
'lire')) {
420 include_once DOL_DOCUMENT_ROOT.
'/don/class/don.class.php';
422 $langs->load(
"boxes");
423 $donationstatic =
new Don($db);
425 $sql =
"SELECT d.rowid, d.lastname, d.firstname, d.societe, d.datedon as date, d.tms as dm, d.amount, d.fk_statut as status";
426 $sql .=
" FROM ".MAIN_DB_PREFIX.
"don as d";
427 $sql .=
" WHERE d.entity IN (".getEntity(
'donation').
")";
429 $parameters = array();
430 $reshook = $hookmanager->executeHooks(
'printFieldListWhereLastDonations', $parameters);
431 $sql .= $hookmanager->resPrint;
433 $sql .= $db->order(
"d.tms",
"DESC");
434 $sql .= $db->plimit($max, 0);
436 $result = $db->query($sql);
438 $num = $db->num_rows($result);
443 print
'<div class="div-table-responsive-no-min">';
444 print
'<table class="noborder centpercent">';
445 print
'<tr class="liste_titre">';
446 print
'<th colspan="2">'.$langs->trans(
"BoxTitleLastModifiedDonations", $max);
447 print
'<a href="'.DOL_URL_ROOT.
'/don/list.php?sortfield=f.tms&sortorder=desc"><span class="badge marginleftonly">...</span></a>';
449 print
'<th class="right">'.$langs->trans(
"AmountTTC").
'</th>';
450 print
'<th class="right">'.$langs->trans(
"DateModificationShort").
'</th>';
451 print
'<th width="16"> </th>';
455 $total_ttc = $totalam = $total_ht = 0;
457 while ($i < $num && $i < $max) {
458 $obj = $db->fetch_object($result);
463 $total_ht += $obj->total_ht;
464 $total_ttc += $obj->total_ttc;
468 $donationstatic->id = $obj->rowid;
469 $donationstatic->ref = $obj->rowid;
470 $donationstatic->lastname = $obj->lastname;
471 $donationstatic->firstname = $obj->firstname;
472 $donationstatic->date = $db->jdate($obj->date);
473 $donationstatic->statut = $obj->status;
474 $donationstatic->status = $obj->status;
476 $label = $donationstatic->getFullName($langs);
478 $label .= ($label ?
' - ' :
'').$obj->societe;
481 print
'<tr class="oddeven tdoverflowmax100">';
482 print
'<td>'.$donationstatic->getNomUrl(1).
'</td>';
483 print
'<td>'.$label.
'</td>';
484 print
'<td class="nowrap right"><span class="amount">'.price($obj->amount).
'</span></td>';
485 print
'<td class="right" title="'.dol_escape_htmltag($langs->trans(
"DateModificationShort").
' : '.
dol_print_date($db->jdate($obj->dm),
'dayhour',
'tzuserrel')).
'">'.
dol_print_date($db->jdate($obj->dm),
'day',
'tzuserrel').
'</td>';
486 print
'<td>'.$donationstatic->getLibStatut(3).
'</td>';
493 print
'<tr class="oddeven">';
494 print
'<td class="nowrap" colspan="5">';
495 print
'<span class="opacitymedium">'.$langs->trans(
"More").
'... ('.$othernb.
')</span>';
500 print
'<tr class="oddeven"><td colspan="5"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
502 print
'</table></div><br>';
511if (isModEnabled(
'tax') && $user->hasRight(
'tax',
'charges',
'lire')) {
515 $sql =
"SELECT c.rowid, c.amount, c.date_ech, c.paye,";
516 $sql .=
" cc.libelle as label,";
517 $sql .=
" SUM(pc.amount) as sumpaid";
518 $sql .=
" FROM (".MAIN_DB_PREFIX.
"c_chargesociales as cc, ".MAIN_DB_PREFIX.
"chargesociales as c)";
519 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"paiementcharge as pc ON pc.fk_charge = c.rowid";
520 $sql .=
" WHERE c.fk_type = cc.id";
521 $sql .=
" AND c.entity IN (".getEntity(
'tax').
')';
522 $sql .=
" AND c.paye = 0";
524 $parameters = array();
525 $reshook = $hookmanager->executeHooks(
'printFieldListWhereSocialContributions', $parameters);
526 $sql .= $hookmanager->resPrint;
528 $sql .=
" GROUP BY c.rowid, c.amount, c.date_ech, c.paye, cc.libelle";
530 $resql = $db->query($sql);
532 $num = $db->num_rows($resql);
534 print
'<div class="div-table-responsive-no-min">';
535 print
'<table class="noborder centpercent">';
536 print
'<tr class="liste_titre">';
537 print
'<th>'.$langs->trans(
"ContributionsToPay").($num ?
'<a href="'.DOL_URL_ROOT.
'/compta/sociales/list.php?status=0"><span class="badge marginleftonly">'.$num.
'</span></a>' :
'').
'</th>';
538 print
'<th align="center">'.$langs->trans(
"DateDue").
'</th>';
539 print
'<th class="right">'.$langs->trans(
"AmountTTC").
'</th>';
540 print
'<th class="right">'.$langs->trans(
"Paid").
'</th>';
541 print
'<th align="center" width="16"> </th>';
550 $obj = $db->fetch_object($resql);
554 $tot_ttc += $obj->amount;
555 $tot_paid += $obj->sumpaid;
560 $chargestatic->id = $obj->rowid;
561 $chargestatic->ref = $obj->rowid;
562 $chargestatic->label = $obj->label;
563 $chargestatic->paye = $obj->paye;
564 $chargestatic->status = $obj->paye;
566 print
'<tr class="oddeven">';
567 print
'<td class="nowraponall">'.$chargestatic->getNomUrl(1).
'</td>';
568 print
'<td class="center">'.dol_print_date($db->jdate($obj->date_ech),
'day').
'</td>';
569 print
'<td class="nowrap right"><span class="amount">'.price($obj->amount).
'</span></td>';
570 print
'<td class="nowrap right"><span class="amount">'.price($obj->sumpaid).
'</span></td>';
571 print
'<td class="center">'.$chargestatic->getLibStatut(3).
'</td>';
574 $tot_ttc += $obj->amount;
579 print
'<tr class="oddeven">';
580 print
'<td class="nowrap" colspan="5">';
581 print
'<span class="opacitymedium">'.$langs->trans(
"More").
'... ('.$othernb.
')</span>';
586 print
'<tr class="liste_total"><td class="left" colspan="2">'.$langs->trans(
"Total").
'</td>';
587 print
'<td class="nowrap right">'.price($tot_ttc).
'</td>';
588 print
'<td class="nowrap right">'.price($tot_paid).
'</td>';
589 print
'<td class="right"> </td>';
592 print
'<tr class="oddeven"><td colspan="5"><span class="opacitymedium">'.$langs->trans(
"None").
'</span></td></tr>';
594 print
"</table></div><br>";
605if (isModEnabled(
'invoice') && isModEnabled(
'order') && $user->hasRight(
"commande",
"lire") && !
getDolGlobalString(
'WORKFLOW_DISABLE_CREATE_INVOICE_FROM_ORDER')) {
606 $commandestatic =
new Commande($db);
607 $langs->load(
"orders");
609 $sql =
"SELECT sum(f.total_ht) as tot_fht, sum(f.total_ttc) as tot_fttc";
610 $sql .=
", s.nom as name, s.email";
611 $sql .=
", s.rowid as socid";
612 $sql .=
", s.code_client, s.code_compta";
613 $sql .=
", c.rowid, c.ref, c.facture, c.fk_statut as status, c.total_ht, c.total_tva, c.total_ttc,";
614 $sql .=
" cc.rowid as country_id, cc.code as country_code";
615 $sql .=
" FROM ".MAIN_DB_PREFIX.
"societe as s LEFT JOIN ".MAIN_DB_PREFIX.
"c_country as cc ON cc.rowid = s.fk_pays";
616 $sql .=
", ".MAIN_DB_PREFIX.
"commande as c";
617 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"element_element as el ON el.fk_source = c.rowid AND el.sourcetype = 'commande'";
618 $sql .=
" LEFT JOIN ".MAIN_DB_PREFIX.
"facture AS f ON el.fk_target = f.rowid AND el.targettype = 'facture'";
619 $sql .=
" WHERE c.fk_soc = s.rowid";
620 $sql .=
" AND c.entity IN (".getEntity(
'commande').
")";
622 $sql .=
" AND c.fk_soc = ".((int) $socid);
625 $sql .=
" AND c.facture = 0";
627 if (!$user->hasRight(
'societe',
'client',
'voir')) {
628 $sql .=
" AND EXISTS (SELECT sc.fk_soc FROM ".MAIN_DB_PREFIX.
"societe_commerciaux as sc WHERE sc.fk_soc = c.fk_soc AND sc.fk_user = ".((int) $user->id).
")";
632 $parameters = array();
633 $reshook = $hookmanager->executeHooks(
'printFieldListWhereCustomerOrderToBill', $parameters);
634 $sql .= $hookmanager->resPrint;
636 $sql .=
" GROUP BY s.nom, s.email, s.rowid, s.code_client, s.code_compta, c.rowid, c.ref, c.facture, c.fk_statut, c.total_ht, c.total_tva, c.total_ttc, cc.rowid, cc.code";
638 $resql = $db->query($sql);
640 $num = $db->num_rows($resql);
646 print
'<div class="div-table-responsive-no-min">';
647 print
'<table class="noborder centpercent">';
649 print
'<tr class="liste_titre">';
650 print
'<th colspan="2">';
651 print $langs->trans(
"OrdersDeliveredToBill");
652 print
'<a href="'.DOL_URL_ROOT.
'/commande/list.php?search_status='.
Commande::STATUS_CLOSED.
'&search_billed=0">';
653 print
'<span class="badge marginleftonly">'.$num.
'</span>';
658 print
'<th class="right">'.$langs->trans(
"AmountHT").
'</th>';
660 print
'<th class="right">'.$langs->trans(
"AmountTTC").
'</th>';
661 print
'<th class="right">'.$langs->trans(
"ToBill").
'</th>';
662 print
'<th align="center" width="16"> </th>';
665 $tot_ht = $tot_ttc = $tot_tobill = 0;
666 $societestatic =
new Societe($db);
668 $obj = $db->fetch_object($resql);
673 $total_ht += $obj->total_ht;
674 $total_ttc += $obj->total_ttc;
678 $societestatic->id = $obj->socid;
679 $societestatic->name = $obj->name;
680 $societestatic->email = $obj->email;
681 $societestatic->country_id = $obj->country_id;
682 $societestatic->country_code = $obj->country_code;
683 $societestatic->client = 1;
684 $societestatic->code_client = $obj->code_client;
686 $societestatic->code_compta_client = $obj->code_compta;
689 $commandestatic->id = $obj->rowid;
690 $commandestatic->ref = $obj->ref;
691 $commandestatic->statut = $obj->status;
692 $commandestatic->billed = $obj->facture;
694 print
'<tr class="oddeven">';
695 print
'<td class="nowrap">';
697 print
'<table class="nobordernopadding"><tr class="nocellnopadd">';
698 print
'<td class="nobordernopadding nowrap">';
699 print $commandestatic->getNomUrl(1);
701 print
'<td width="20" class="nobordernopadding nowrap">';
704 print
'<td width="16" class="nobordernopadding hideonsmartphone right">';
707 $urlsource = $_SERVER[
'PHP_SELF'].
'?id='.$obj->rowid;
708 print $formfile->getDocumentsLink($commandestatic->element, $filename, $filedir);
709 print
'</td></tr></table>';
713 print
'<td class="nowrap tdoverflowmax100">';
714 print $societestatic->getNomUrl(1,
'customer');
717 print
'<td class="right"><span class="amount">'.price($obj->total_ht).
'</span></td>';
719 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc).
'</span></td>';
720 print
'<td class="nowrap right"><span class="amount">'.price($obj->total_ttc - $obj->tot_fttc).
'</span></td>';
721 print
'<td>'.$commandestatic->getLibStatut(3).
'</td>';
723 $tot_ht += $obj->total_ht;
724 $tot_ttc += $obj->total_ttc;
726 $tot_tobill += ($obj->total_ttc - $obj->tot_fttc);
731 print
'<tr class="oddeven">';
732 print
'<td class="nowrap" colspan="5">';
733 print
'<span class="opacitymedium">'.$langs->trans(
"More").
'... ('.$othernb.
')</span>';
738 print
'<tr class="liste_total"><td colspan="2">'.$langs->trans(
"Total").
' <span style="font-weight: normal">('.$langs->trans(
"RemainderToBill").
': '.
price($tot_tobill).
')</span> </td>';
740 print
'<td class="right">'.price($tot_ht).
'</td>';
742 print
'<td class="nowrap right">'.price($tot_ttc).
'</td>';
743 print
'<td class="nowrap right">'.price($tot_tobill).
'</td>';
744 print
'<td> </td>';
746 print
'</table></div><br>';
758 print
'<div class="div-table-responsive-no-min">';
759 print
'<table class="noborder centpercent">';
760 print
'<tr class="liste_titre"><th colspan="2">'.$langs->trans(
"TasksToDo").
'</th>';
763 $resql = $db->query($sql);
765 $num_rows = $db->num_rows($resql);
766 while ($i < $num_rows) {
767 $obj = $db->fetch_object($resql);
769 print
'<tr class="oddeven"><td>'.dol_print_date($db->jdate($obj->da),
"day").
'</td>';
770 print
'<td><a href="action/card.php">'.$obj->label.
'</a></td></tr>';
775 print
"</table></div><br>";
779print
'</div></div></div>';
781$parameters = array(
'user' => $user);
782$reshook = $hookmanager->executeHooks(
'dashboardAccountancy', $parameters, $object);
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader()
Empty header.
Class for managing the social charges.
Class to manage customers orders.
const STATUS_CLOSED
Closed (Sent, billed or not)
Class to manage donations.
Class to manage suppliers invoices.
Class to manage invoices.
Class to manage third parties objects (customers, suppliers, prospects...)
load_fiche_titre($title, $morehtmlright='', $picto='generic', $pictoisfullpath=0, $id='', $morecssontable='', $morehtmlcenter='')
Load a title with picto.
img_warning($titlealt='default', $moreatt='', $morecss='pictowarning')
Show warning logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
price($amount, $form=0, $outlangs='', $trunc=1, $rounding=-1, $forcerounding=-1, $currency_code='')
Function to format a value into an amount for visual output Function used into PDF and HTML pages.
dol_now($mode='auto')
Return date for now.
getDolGlobalInt($key, $default=0)
Return a Dolibarr global constant int value.
dol_print_date($time, $format='', $tzoutput='auto', $outputlangs=null, $encodetooutput=false)
Output date in a string format according to outputlangs (or langs if not defined).
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_sanitizeFileName($str, $newstr='_', $unaccent=1)
Clean a string to use it as a file name.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
getNumberInvoicesPieChart($mode)
Return an HTML table that contains a pie chart of the number of customers or supplier invoices.
getCustomerInvoiceDraftTable($maxCount=500, $socid=0)
Return a HTML table that contains a list with customer invoice drafts.
getDraftSupplierTable($maxCount=500, $socid=0)
Return a HTML table that contains a list with customer invoice drafts.