print '<td style="min-width: 20px" class="nobordernopadding nowrap">';
if ($objp->fk_statut == 1 && $db->jdate($objp->dfv) < $now - $conf->propal->cloture->warning_delay) {
print img_warning($langs->trans("Late"));
}
if (!empty($objp->note_private)) {
print ' <span class="note">';
print '<a href="' . DOL_URL_ROOT . '/comm/propal/note.php?id=' . $objp->propalid . '">' . img_picto($langs->trans("ViewPrivateNote"), 'object_generic') . '</a>';
print '</span>';
}
print '</td>';
// Ref
print '<td width="16" align="right" class="nobordernopadding hideonsmartphone">';
$filename = dol_sanitizeFileName($objp->ref);
$filedir = $conf->propal->dir_output . '/' . dol_sanitizeFileName($objp->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $objp->propalid;
print $formfile->getDocumentsLink($objectstatic->element, $filename, $filedir);
print '</td></tr></table>';
print "</td>\n";
// Customer ref
print '<td class="nocellnopadd nowrap">';
print $objp->ref_client;
print '</td>';
$url = DOL_URL_ROOT . '/comm/card.php?socid=' . $objp->rowid;
// Company
$companystatic->id = $objp->rowid;
$companystatic->name = $objp->name;
$companystatic->client = $objp->client;
$companystatic->code_client = $objp->code_client;
print '<td>';
print $companystatic->getNomUrl(1, 'customer');
print '</td>';
print "<tr " . $bc[$var] . ">";
print '<td width="20%" class="nowrap">';
$supplier_proposalstatic->id = $obj->rowid;
$supplier_proposalstatic->ref = $obj->ref;
print '<table class="nobordernopadding"><tr class="nocellnopadd">';
print '<td width="96" class="nobordernopadding nowrap">';
print $supplier_proposalstatic->getNomUrl(1);
print '</td>';
print '<td width="16" class="nobordernopadding nowrap">';
print ' ';
print '</td>';
print '<td width="16" align="right" class="nobordernopadding">';
$filename = dol_sanitizeFileName($obj->ref);
$filedir = $conf->supplier_proposal->dir_output . '/' . dol_sanitizeFileName($obj->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $obj->rowid;
print $formfile->getDocumentsLink($supplier_proposalstatic->element, $filename, $filedir);
print '</td></tr></table>';
print '</td>';
$companystatic->id = $obj->socid;
$companystatic->name = $obj->socname;
$companystatic->client = $obj->client;
$companystatic->canvas = $obj->canvas;
print '<td>' . $companystatic->getNomUrl(1, 'customer') . '</td>';
print '<td>' . dol_print_date($db->jdate($obj->datec), 'day') . '</td>';
print '<td align="right">' . $supplier_proposalstatic->LibStatut($obj->fk_statut, 5) . '</td>';
print '</tr>';
$i++;
}
}
print "</table><br>";
} else {
$propalstatic->id = $obj->propalid;
$propalstatic->ref = $obj->ref;
print '<table class="nobordernopadding"><tr class="nocellnopadd">';
print '<td class="nobordernopadding nowrap">';
print $propalstatic->getNomUrl(1);
print '</td>';
print '<td width="18" class="nobordernopadding nowrap">';
if ($db->jdate($obj->dfv) < $now - $conf->propal->cloture->warning_delay) {
print img_warning($langs->trans("Late"));
}
print '</td>';
print '<td width="16" align="center" class="nobordernopadding">';
$filename = dol_sanitizeFileName($obj->ref);
$filedir = $conf->propal->dir_output . '/' . dol_sanitizeFileName($obj->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $obj->propalid;
print $formfile->getDocumentsLink($propalstatic->element, $filename, $filedir);
print '</td></tr></table>';
print "</td>";
print '<td align="left"><a href="fiche.php?socid=' . $obj->rowid . '">' . img_object($langs->trans("ShowCompany"), "company") . ' ' . dol_trunc($obj->nom, 44) . '</a></td>' . "\n";
print '<td align="right">';
print dol_print_date($db->jdate($obj->dp), 'day') . '</td>' . "\n";
print '<td align="right">' . price($obj->total_ttc) . '</td>';
print '<td align="center" width="14">' . $propalstatic->LibStatut($obj->fk_statut, 3) . '</td>' . "\n";
print '</tr>' . "\n";
$i++;
$total += $obj->total_ttc;
}
if ($num > $nbofloop) {
print '<tr class="liste_total"><td colspan="5">' . $langs->trans("XMoreLines", $num - $nbofloop) . "</td></tr>";
} else {
if ($total > 0) {
print "<tr " . $bc[$var] . ">";
print '<td width="20%" class="nowrap">';
$commandestatic->id = $obj->rowid;
$commandestatic->ref = $obj->ref;
print '<table class="nobordernopadding"><tr class="nocellnopadd">';
print '<td width="96" class="nobordernopadding nowrap">';
print $commandestatic->getNomUrl(1);
print '</td>';
print '<td width="16" class="nobordernopadding nowrap">';
print ' ';
print '</td>';
print '<td width="16" align="right" class="nobordernopadding hideonsmartphone">';
$filename = dol_sanitizeFileName($obj->ref);
$filedir = $conf->commande->dir_output . '/' . dol_sanitizeFileName($obj->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $obj->rowid;
print $formfile->getDocumentsLink($commandestatic->element, $filename, $filedir);
print '</td></tr></table>';
print '</td>';
print '<td><a href="' . DOL_URL_ROOT . '/fourn/card.php?socid=' . $obj->socid . '">' . img_object($langs->trans("ShowCompany"), "company") . ' ' . $obj->name . '</a></td>';
print '<td>' . dol_print_date($db->jdate($obj->tms), 'day') . '</td>';
print '<td align="right">' . $commandestatic->LibStatut($obj->fk_statut, 5) . '</td>';
print '</tr>';
$i++;
}
}
print "</table><br>";
} else {
dol_print_error($db);
}
/*
* Orders to process
$paiement = $facturestatic->getSommePaiement();
print '<table class="nobordernopadding"><tr class="nocellnopadd">';
print '<td class="nobordernopadding nowrap">';
print $facturestatic->getNomUrl(1, '', 200, 0, $notetoshow);
print $objp->increment;
print '</td>';
print '<td style="min-width: 20px" class="nobordernopadding nowrap">';
if (!empty($objp->note_private)) {
print ' <span class="note">';
print '<a href="' . DOL_URL_ROOT . '/compta/facture/note.php?id=' . $objp->facid . '">' . img_picto($langs->trans("ViewPrivateNote"), 'object_generic') . '</a>';
print '</span>';
}
$filename = dol_sanitizeFileName($objp->facnumber);
$filedir = $conf->facture->dir_output . '/' . dol_sanitizeFileName($objp->facnumber);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $objp->facid;
print $formfile->getDocumentsLink($facturestatic->element, $filename, $filedir);
print '</td>';
print '</tr>';
print '</table>';
print "</td>\n";
// Customer ref
print '<td class="nowrap">';
print $objp->ref_client;
print '</td>';
// Date
print '<td align="center" class="nowrap">';
print dol_print_date($db->jdate($objp->df), 'day');
print '</td>';
// Date limit
print '<td align="center" class="nowrap">' . dol_print_date($datelimit, 'day');
if ($datelimit < $now - $conf->facture->client->warning_delay && !$objp->paye && $objp->fk_statut == 1 && !$paiement) {
// Warning late icon
print '<td class="nobordernopadding nowrap">';
if ($generic_commande->hasDelay()) {
print img_picto($langs->trans("Late"), "warning");
}
if (!empty($objp->note_private)) {
print ' <span class="note">';
print '<a href="' . DOL_URL_ROOT . '/commande/note.php?id=' . $objp->rowid . '">' . img_picto($langs->trans("ViewPrivateNote"), 'object_generic') . '</a>';
print '</span>';
}
print '</td>';
print '<td width="16" align="right" class="nobordernopadding hideonsmartphone">';
$filename = dol_sanitizeFileName($objp->ref);
$filedir = $conf->commande->dir_output . '/' . dol_sanitizeFileName($objp->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $objp->rowid;
print $formfile->getDocumentsLink($generic_commande->element, $filename, $filedir);
print '</td>';
print '</tr></table>';
print '</td>';
// Ref customer
print '<td>' . $objp->ref_client . '</td>';
// Company
$companystatic->id = $objp->socid;
$companystatic->code_client = $objp->code_client;
$companystatic->name = $objp->name;
$companystatic->client = $objp->client;
print '<td>';
print $companystatic->getNomUrl(1, 'customer');
// If module invoices enabled and user with invoice creation permissions
if (!empty($conf->facture->enabled) && !empty($conf->global->ORDER_BILLING_ALL_CUSTOMER)) {
if ($user->rights->facture->creer) {
print "<tr " . $bc[$var] . ">";
print '<td width="20%" class="nowrap">';
$askpricesupplierstatic->id = $obj->rowid;
$askpricesupplierstatic->ref = $obj->ref;
print '<table class="nobordernopadding"><tr class="nocellnopadd">';
print '<td width="96" class="nobordernopadding nowrap">';
print $askpricesupplierstatic->getNomUrl(1);
print '</td>';
print '<td width="16" class="nobordernopadding nowrap">';
print ' ';
print '</td>';
print '<td width="16" align="right" class="nobordernopadding">';
$filename = dol_sanitizeFileName($obj->ref);
$filedir = $conf->askpricesupplier->dir_output . '/' . dol_sanitizeFileName($obj->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $obj->rowid;
print $formfile->getDocumentsLink($askpricesupplierstatic->element, $filename, $filedir);
print '</td></tr></table>';
print '</td>';
$companystatic->id = $obj->socid;
$companystatic->name = $obj->socname;
$companystatic->client = $obj->client;
$companystatic->canvas = $obj->canvas;
print '<td>' . $companystatic->getNomUrl(1, 'customer') . '</td>';
print '<td>' . dol_print_date($db->jdate($obj->datec), 'day') . '</td>';
print '<td align="right">' . $askpricesupplierstatic->LibStatut($obj->fk_statut, 5) . '</td>';
print '</tr>';
$i++;
}
}
print "</table><br>";
} else {
$element_doc = $element->element;
$filename=dol_sanitizeFileName($element->ref);
$filedir=$conf->{$element_doc}->dir_output . '/' . dol_sanitizeFileName($element->ref);
if($element_doc === 'order_supplier') {
$element_doc='commande_fournisseur';
$filedir = $conf->fournisseur->commande->dir_output.'/'.dol_sanitizeFileName($element->ref);
}
else if($element_doc === 'invoice_supplier') {
$element_doc='facture_fournisseur';
$filename = get_exdir($element->id,2,0,0,$this,'product').dol_sanitizeFileName($element->ref);
$filedir = $conf->fournisseur->facture->dir_output.'/'.get_exdir($element->id,2,0,0,null,'invoice_supplier').dol_sanitizeFileName($element->ref);
}
print $formfile->getDocumentsLink($element_doc, $filename, $filedir);
}
print "</td>\n";
// Date
if ($tablename == 'commande_fournisseur' || $tablename == 'supplier_order') $date=$element->date_commande;
elseif ($tablename == 'projet_task') $date=''; // We show no date. Showing date of beginning of task make user think it is date of time consumed
else
{
$date=$element->date;
if (empty($date)) $date=$element->datep;
if (empty($date)) $date=$element->date_contrat;
if (empty($date)) $date=$element->datev; //Fiche inter
}
print '<td align="center">'.dol_print_date($date,'day').'</td>';
print '<td width="110" class="nobordernopadding nowrap">';
$facturestatic->ref = $obj->facnumber;
$facturestatic->id = $obj->rowid;
$facturestatic->type = $obj->type;
print $facturestatic->getNomUrl(1, '');
print '</td>';
print '<td width="20" class="nobordernopadding nowrap">';
if ($db->jdate($obj->datelimite) < $now - $conf->facture->client->warning_delay) {
print img_warning($langs->trans("Late"));
}
print '</td>';
print '<td width="16" align="right" class="nobordernopadding hideonsmartphone">';
$filename = dol_sanitizeFileName($obj->facnumber);
$filedir = $conf->facture->dir_output . '/' . dol_sanitizeFileName($obj->facnumber);
$urlsource = $_SERVER['PHP_SELF'] . '?facid=' . $obj->rowid;
print $formfile->getDocumentsLink($facturestatic->element, $filename, $filedir);
print '</td></tr></table>';
print '</td>';
print '<td align="left">';
$societestatic->id = $obj->socid;
$societestatic->nom = $obj->nom;
$societestatic->client = 1;
print $societestatic->getNomUrl(1, 'customer', 44);
print '</a></td>';
if (!empty($conf->global->MAIN_SHOW_HT_ON_SUMMARY)) {
print '<td align="right">' . price($obj->total) . '</td>';
}
print '<td align="right">' . price($obj->total_ttc) . '</td>';
print '<td align="right">' . price($obj->am) . '</td>';
print '<td>' . $facstatic->LibStatut($obj->paye, $obj->fk_statut, 3, $obj->am) . '</td>';
print '</tr>';
print "<tr " . $bc[$var] . ">";
print '<td width="20%" class="nowrap">';
$fichinterstatic->id = $obj->rowid;
$fichinterstatic->ref = $obj->ref;
print '<table class="nobordernopadding"><tr class="nocellnopadd">';
print '<td width="96" class="nobordernopadding nowrap">';
print $fichinterstatic->getNomUrl(1);
print '</td>';
print '<td width="16" class="nobordernopadding nowrap">';
print ' ';
print '</td>';
print '<td width="16" align="right" class="nobordernopadding hideonsmartphone">';
$filename = dol_sanitizeFileName($obj->ref);
$filedir = $conf->commande->dir_output . '/' . dol_sanitizeFileName($obj->ref);
$urlsource = $_SERVER['PHP_SELF'] . '?id=' . $obj->rowid;
print $formfile->getDocumentsLink($fichinterstatic->element, $filename, $filedir);
print '</td></tr></table>';
print '</td>';
print '<td><a href="' . DOL_URL_ROOT . '/comm/card.php?socid=' . $obj->socid . '">' . img_object($langs->trans("ShowCompany"), "company") . ' ' . $obj->name . '</a></td>';
print '<td>' . dol_print_date($db->jdate($obj->datem), 'day') . '</td>';
print '<td align="right">' . $fichinterstatic->LibStatut($obj->fk_statut, 5) . '</td>';
print '</tr>';
$i++;
}
}
print "</table><br>";
} else {
dol_print_error($db);
}
/*
* Orders to process
$total = 0;
$total_ttc = 0;
while ($i < min($num, $limit)) {
$obj = $db->fetch_object($resql);
$facturestatic->date_echeance = $db->jdate($obj->date_echeance);
$facturestatic->statut = $obj->fk_statut;
$var = !$var;
print "<tr " . $bc[$var] . ">";
print '<td class="nowrap">';
$facturestatic->id = $obj->facid;
$facturestatic->ref = $obj->ref;
$facturestatic->ref_supplier = $obj->ref_supplier;
print $facturestatic->getNomUrl(1);
$filename = dol_sanitizeFileName($obj->ref);
$filedir = $conf->fournisseur->facture->dir_output . '/' . get_exdir($obj->facid, 2, 0, 0, $facturestatic, 'invoice_supplier') . dol_sanitizeFileName($obj->ref);
print $formfile->getDocumentsLink('facture_fournisseur', $filename, $filedir);
print "</td>\n";
// Ref supplier
if (empty($conf->global->SUPPLIER_INVOICE_HIDE_REF_SUPPLIER)) {
print '<td class="nowrap">' . $obj->ref_supplier . "</td>";
}
print '<td align="center" class="nowrap">' . dol_print_date($db->jdate($obj->datef), 'day') . '</td>';
print '<td align="center" class="nowrap">' . dol_print_date($db->jdate($obj->date_echeance), 'day');
if ($facturestatic->hasDelay()) {
print img_picto($langs->trans("Late"), "warning");
}
print '</td>';
print '<td>' . dol_trunc($obj->libelle, 36) . '</td>';
print '<td>';
$supplierstatic->id = $obj->socid;
$supplierstatic->name = $obj->name;
