$ratiolineinvoice = $fields['dtotal_ttc'] / $fields['ftotal_ttc'];
//print ' ('.round($ratiolineinvoice*100,2).'%)';
}
print '</td>';
}
// Payment
$ratiopaymentinvoice = 1;
if ($modetax == 0) {
if (isset($fields['payment_amount']) && $fields['ftotal_ttc']) {
$ratiopaymentinvoice = $fields['payment_amount'] / $fields['ftotal_ttc'];
}
print '<td class="nowrap" align="right">';
//print $fields['totalht']."-".$fields['payment_amount']."-".$fields['ftotal_ttc'];
if ($fields['payment_amount'] && $fields['ftotal_ttc']) {
$payment_static->id = $fields['payment_id'];
print $payment_static->getNomUrl(2);
}
if ($type == 0) {
print $langs->trans("NotUsedForGoods");
} else {
print $fields['payment_amount'];
if (isset($fields['payment_amount'])) {
print ' (' . round($ratiopaymentinvoice * 100, 2) . '%)';
}
}
print '</td>';
}
// Total collected
print '<td class="nowrap" align="right">';
$temp_ht = $fields['totalht'];
if ($type == 1) {
// Description
print '<td>';
// Show generic description
if (preg_match('/^\\((.*)\\)$/i', $objp->label, $reg)) {
// Generic description because between (). We show it after translating.
print $langs->trans($reg[1]);
} else {
print dol_trunc($objp->label, 60);
}
// Add links after description
$links = $object->get_url($objp->rowid);
foreach ($links as $key => $val) {
if ($links[$key]['type'] == 'payment') {
$paymentstatic->id = $links[$key]['url_id'];
$paymentstatic->ref = $links[$key]['url_id'];
print ' ' . $paymentstatic->getNomUrl(2);
} elseif ($links[$key]['type'] == 'payment_supplier') {
$paymentsupplierstatic->id = $links[$key]['url_id'];
$paymentsupplierstatic->ref = $links[$key]['url_id'];
print ' ' . $paymentsupplierstatic->getNomUrl(2);
} elseif ($links[$key]['type'] == 'payment_sc') {
print '<a href="' . DOL_URL_ROOT . '/compta/payment_sc/card.php?id=' . $links[$key]['url_id'] . '">';
print ' ' . img_object($langs->trans('ShowPayment'), 'payment') . ' ';
//print $langs->trans("SocialContributionPayment");
print '</a>';
} elseif ($links[$key]['type'] == 'payment_vat') {
$paymentvatstatic->id = $links[$key]['url_id'];
$paymentvatstatic->ref = $links[$key]['url_id'];
print ' ' . $paymentvatstatic->getNomUrl(2);
} elseif ($links[$key]['type'] == 'payment_salary') {
$paymentsalstatic->id = $links[$key]['url_id'];
print '<input type="image" class="liste_titre" name="button_removefilter" src="' . img_picto($langs->trans("Search"), 'searchclear.png', '', '', 1) . '" value="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '" title="' . dol_escape_htmltag($langs->trans("RemoveFilter")) . '">';
print '</td>';
if (!empty($conf->global->BILL_ADD_PAYMENT_VALIDATION)) {
print '<td align="right">';
print '</td>';
}
print "</tr>\n";
$var = true;
while ($i < min($num, $limit)) {
$objp = $db->fetch_object($resql);
$var = !$var;
print "<tr " . $bc[$var] . ">";
print '<td>';
$paymentstatic->id = $objp->rowid;
$paymentstatic->ref = $objp->ref;
print $paymentstatic->getNomUrl(1);
print '</td>';
print '<td align="center">' . dol_print_date($db->jdate($objp->dp), 'day') . '</td>';
// Company
print '<td>';
if ($objp->socid) {
$companystatic->id = $objp->socid;
$companystatic->name = $objp->name;
print $companystatic->getNomUrl(1, '', 24);
} else {
print ' ';
}
print '</td>';
print '<td>' . $langs->trans("PaymentTypeShort" . $objp->paiement_code) . '</td><td>' . $objp->num_paiement . '</td>';
print '<td>';
if ($objp->bid) {
$tabpay[$obj->rowid]["type_payment"] = $obj->fk_type;
$tabpay[$obj->rowid]["ref"] = $obj->label;
$tabpay[$obj->rowid]["fk_bank"] = $obj->rowid;
if (preg_match('/^\\((.*)\\)$/i', $obj->label, $reg)) {
$tabpay[$obj->rowid]["lib"] = $langs->trans($reg[1]);
} else {
$tabpay[$obj->rowid]["lib"] = dol_trunc($obj->label, 60);
}
$links = $object->get_url($obj->rowid);
// get_url may return -1 which is not traversable
if (is_array($links)) {
foreach ($links as $key => $val) {
$tabtype[$obj->rowid] = $links[$key]['type'];
if ($links[$key]['type'] == 'payment') {
$paymentstatic->id = $links[$key]['url_id'];
$tabpay[$obj->rowid]["lib"] .= ' ' . $paymentstatic->getNomUrl(2);
} else {
if ($links[$key]['type'] == 'payment_supplier') {
$paymentsupplierstatic->id = $links[$key]['url_id'];
$paymentsupplierstatic->ref = $links[$key]['url_id'];
$tabpay[$obj->rowid]["lib"] .= ' ' . $paymentsupplierstatic->getNomUrl(2);
} else {
if ($links[$key]['type'] == 'company') {
$societestatic->id = $links[$key]['url_id'];
$societestatic->name = $links[$key]['label'];
$tabpay[$obj->rowid]["soclib"] = $societestatic->getNomUrl(1, '', 30);
$tabtp[$obj->rowid][$compta_soc] += $obj->amount;
} else {
if ($links[$key]['type'] == 'user') {
$userstatic->id = $links[$key]['url_id'];
$userstatic->name = $links[$key]['label'];
$sql .= " LEFT JOIN " . MAIN_DB_PREFIX . "user as u ON p.fk_user_creat = u.rowid";
$sql .= " WHERE pf.fk_paiement = p.rowid";
$sql .= " AND p.entity = " . $conf->entity;
$sql .= " AND pf.fk_facture = " . $fac->id;
$sql .= " ORDER BY p.datep ASC";
$resqlp = $db->query($sql);
if ($resqlp) {
$nump = $db->num_rows($resqlp);
$j = 0;
while ($j < $nump) {
$objp = $db->fetch_object($resqlp);
$paymentstatic = new Paiement($db);
$paymentstatic->id = $objp->rowid;
$userstatic->id = $objp->userid;
$userstatic->login = $objp->login;
$TData[] = array('date' => $db->jdate($objp->dp), 'link' => $langs->trans("Payment") . ' ' . $paymentstatic->getNomUrl(1), 'status' => '', 'amount' => -$objp->amount, 'author' => $userstatic->getLoginUrl(1));
$TDataSort[] = $db->jdate($objp->dp);
$j++;
}
$db->free($resqlp);
} else {
dol_print_error($db);
}
}
} else {
dol_print_error($db);
}
if (empty($TData)) {
print '<tr ' . $bc[false] . '><td colspan="7">' . $langs->trans("NoInvoice") . '</td></tr>';
} else {
// Sort array by date
