3932cd5853
# Qual: Update SQL query variables for situation mode in margin reports In the situation mode, the SQL queries for agentMargins, customerMargins, productMargins, and productMargins tab were updated to use new variable names ($sql_delta_pct and $sql_delta_ht) instead of the old ones ($delta_pct and $delta_ht). This allows correct analysis by SqlInjection
524 lines
21 KiB
PHP
524 lines
21 KiB
PHP
<?php
|
|
/* Copyright (C) 2012-2013 Christophe Battarel <christophe.battarel@altairis.fr>
|
|
* Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
|
|
* Copyright (C) 2025-2026 MDW <mdeweerd@users.noreply.github.com>
|
|
*
|
|
* This program is free software; you can redistribute it and/or modify
|
|
* it under the terms of the GNU General Public License as published by
|
|
* the Free Software Foundation; either version 3 of the License, or
|
|
* (at your option) any later version.
|
|
*
|
|
* This program is distributed in the hope that it will be useful,
|
|
* but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
* GNU General Public License for more details.
|
|
*
|
|
* You should have received a copy of the GNU General Public License
|
|
* along with this program. If not, see <https://www.gnu.org/licenses/>.
|
|
*/
|
|
|
|
/**
|
|
* \file htdocs/margin/tabs/productMargins.php
|
|
* \ingroup product margins
|
|
* \brief Page for Product Margins on Customer Invoices
|
|
*/
|
|
|
|
// Load Dolibarr environment
|
|
require '../../main.inc.php';
|
|
require_once DOL_DOCUMENT_ROOT.'/core/lib/product.lib.php';
|
|
require_once DOL_DOCUMENT_ROOT.'/compta/facture/class/facture.class.php';
|
|
require_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
|
|
|
|
/**
|
|
* @var Conf $conf
|
|
* @var DoliDB $db
|
|
* @var HookManager $hookmanager
|
|
* @var Translate $langs
|
|
* @var User $user
|
|
*/
|
|
|
|
$langs->loadLangs(array("companies", "bills", "products", "margins"));
|
|
|
|
$id = GETPOSTINT('id');
|
|
$ref = GETPOST('ref', 'alpha');
|
|
$action = GETPOST('action', 'aZ09');
|
|
$confirm = GETPOST('confirm', 'alpha');
|
|
|
|
// Security check
|
|
$fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref : ''));
|
|
$fieldtype = (!empty($ref) ? 'ref' : 'rowid');
|
|
if (!empty($user->socid)) {
|
|
$socid = $user->socid;
|
|
}
|
|
|
|
$object = new Product($db);
|
|
|
|
$limit = GETPOSTINT('limit') ? GETPOSTINT('limit') : $conf->liste_limit;
|
|
$sortfield = GETPOST('sortfield', 'aZ09comma');
|
|
$sortorder = GETPOST('sortorder', 'aZ09comma');
|
|
$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
|
|
if (empty($page) || $page < 0 || GETPOST('button_search', 'alpha') || GETPOST('button_removefilter', 'alpha')) {
|
|
// If $page is not defined, or '' or -1 or if we click on clear filters
|
|
$page = 0;
|
|
}
|
|
$offset = $limit * $page;
|
|
$pageprev = $page - 1;
|
|
$pagenext = $page + 1;
|
|
if (!$sortorder) {
|
|
$sortorder = "DESC";
|
|
}
|
|
if (!$sortfield) {
|
|
$sortfield = "f.datef";
|
|
}
|
|
|
|
$hookmanager->initHooks(array('tabproductmarginlist'));
|
|
|
|
$result = restrictedArea($user, 'produit|service', $fieldvalue, 'product&product', '', '', $fieldtype);
|
|
|
|
if (!$user->hasRight('margins', 'liretous')) {
|
|
accessforbidden();
|
|
}
|
|
|
|
$search_invoice_date_start = '';
|
|
$search_invoice_date_end = '';
|
|
if (GETPOSTINT('search_invoice_date_start_month')) {
|
|
$search_invoice_date_start = dol_mktime(0, 0, 0, GETPOSTINT('search_invoice_date_start_month'), GETPOSTINT('search_invoice_date_start_day'), GETPOSTINT('search_invoice_date_start_year'));
|
|
}
|
|
if (GETPOSTINT('search_invoice_date_end_month')) {
|
|
$search_invoice_date_end = dol_mktime(23, 59, 59, GETPOSTINT('search_invoice_date_end_month'), GETPOSTINT('search_invoice_date_end_day'), GETPOSTINT('search_invoice_date_end_year'));
|
|
}
|
|
|
|
// Purge search criteria
|
|
if (GETPOST('button_removefilter_x', 'alpha') || GETPOST('button_removefilter.x', 'alpha') || GETPOST('button_removefilter', 'alpha')) { // All tests are required to be compatible with all browsers
|
|
$search_invoice_date_start = '';
|
|
$search_invoice_date_end = '';
|
|
}
|
|
|
|
// set default dates from fiscal year
|
|
if (empty($search_invoice_date_start) && empty($search_invoice_date_end) && !GETPOSTISSET('restore_lastsearch_values')) {
|
|
$query = "SELECT date_start, date_end";
|
|
$query .= " FROM ".MAIN_DB_PREFIX."accounting_fiscalyear";
|
|
$query .= " WHERE date_start < '".$db->idate(dol_now())."' and date_end > '".$db->idate(dol_now())."' limit 1";
|
|
$res = $db->query($query);
|
|
|
|
if ($res && $db->num_rows($res) > 0) {
|
|
$fiscalYear = $db->fetch_object($res);
|
|
$search_invoice_date_start = strtotime($fiscalYear->date_start);
|
|
$search_invoice_date_end = strtotime($fiscalYear->date_end);
|
|
} else {
|
|
$month_start = getDolGlobalInt('SOCIETE_FISCAL_MONTH_START', 1);
|
|
$year_start = (int) dol_print_date(dol_now(), '%Y');
|
|
if (dol_print_date(dol_now(), '%m') < $month_start) {
|
|
$year_start--; // If current month is lower that starting fiscal month, we start last year
|
|
}
|
|
$year_end = $year_start + 1;
|
|
$month_end = $month_start - 1;
|
|
if ($month_end < 1) {
|
|
$month_end = 12;
|
|
$year_end--;
|
|
}
|
|
$search_invoice_date_start = dol_mktime(0, 0, 0, $month_start, 1, $year_start);
|
|
$search_invoice_date_end = dol_get_last_day($year_end, $month_end);
|
|
}
|
|
}
|
|
|
|
|
|
/*
|
|
* View
|
|
*/
|
|
|
|
$invoicestatic = new Facture($db);
|
|
|
|
$form = new Form($db);
|
|
$totalMargin = 0;
|
|
$marginRate = '';
|
|
$markRate = '';
|
|
if ($id > 0 || !empty($ref)) {
|
|
$result = $object->fetch($id, $ref);
|
|
|
|
$title = $langs->trans('ProductServiceCard');
|
|
$help_url = '';
|
|
$shortlabel = dol_trunc($object->label, 16);
|
|
if (GETPOST("type") == '0' || ($object->type == Product::TYPE_PRODUCT)) {
|
|
$title = $langs->trans('Product')." ".$shortlabel." - ".$langs->trans('Card');
|
|
$help_url = 'EN:Module_Products|FR:Module_Produits|ES:Módulo_Productos';
|
|
}
|
|
if (GETPOST("type") == '1' || ($object->type == Product::TYPE_SERVICE)) {
|
|
$title = $langs->trans('Service')." ".$shortlabel." - ".$langs->trans('Card');
|
|
$help_url = 'EN:Module_Services_En|FR:Module_Services|ES:Módulo_Servicios';
|
|
}
|
|
|
|
llxHeader('', $title, $help_url, '', 0, 0, '', '', '', 'mod-margin page-tabs_productmargins');
|
|
|
|
$param = "&id=".$object->id;
|
|
if ($limit > 0 && $limit != $conf->liste_limit) {
|
|
$param .= '&limit='.((int) $limit);
|
|
}
|
|
if ($search_invoice_date_start) {
|
|
$param .= '&search_invoice_date_start_day='.dol_print_date($search_invoice_date_start, '%d').'&search_invoice_date_start_month='.dol_print_date($search_invoice_date_start, '%m').'&search_invoice_date_start_year='.dol_print_date($search_invoice_date_start, '%Y');
|
|
}
|
|
if ($search_invoice_date_end) {
|
|
$param .= '&search_invoice_date_end_day='.dol_print_date($search_invoice_date_end, '%d').'&search_invoice_date_end_month='.dol_print_date($search_invoice_date_end, '%m').'&search_invoice_date_end_year='.dol_print_date($search_invoice_date_end, '%Y');
|
|
}
|
|
|
|
// View mode
|
|
if ($result > 0) {
|
|
$head = product_prepare_head($object);
|
|
$titre = $langs->trans("CardProduct".$object->type);
|
|
$picto = ($object->type == Product::TYPE_SERVICE ? 'service' : 'product');
|
|
print dol_get_fiche_head($head, 'margin', $titre, -1, $picto);
|
|
|
|
$linkback = '<a href="'.DOL_URL_ROOT.'/product/list.php?restore_lastsearch_values=1">'.$langs->trans("BackToList").'</a>';
|
|
$object->next_prev_filter = "(te.fk_product_type:=:".((int) $object->type).")";
|
|
|
|
dol_banner_tab($object, 'ref', $linkback, ($user->socid ? 0 : 1), 'ref');
|
|
|
|
|
|
print '<div class="fichecenter">';
|
|
|
|
print '<div class="underbanner clearboth"></div>';
|
|
print '<table class="border tableforfield centpercent">';
|
|
|
|
// Total Margin
|
|
print '<tr><td class="titlefield">'.$langs->trans("TotalMargin").'</td><td>';
|
|
print '<span id="totalMargin" class="amount"></span>'; // set by jquery (see below)
|
|
print '</td></tr>';
|
|
|
|
// Margin Rate
|
|
if (getDolGlobalString('DISPLAY_MARGIN_RATES')) {
|
|
print '<tr><td>'.$langs->trans("MarginRate").'</td><td>';
|
|
print '<span id="marginRate"></span>'; // set by jquery (see below)
|
|
print '</td></tr>';
|
|
}
|
|
|
|
// Mark Rate
|
|
if (getDolGlobalString('DISPLAY_MARK_RATES')) {
|
|
print '<tr><td>'.$langs->trans("MarkRate").'</td><td>';
|
|
print '<span id="markRate"></span>'; // set by jquery (see below)
|
|
print '</td></tr>';
|
|
}
|
|
|
|
print "</table>";
|
|
|
|
print '</div>';
|
|
print '<div class="clearboth"></div>';
|
|
|
|
print dol_get_fiche_end();
|
|
|
|
|
|
if ($user->hasRight("facture", "read")) {
|
|
$sql = "SELECT s.nom as name, s.rowid as socid, s.code_client,";
|
|
$sql .= " f.rowid as facid, f.ref, f.total_ht,";
|
|
$sql .= " f.datef, f.paye, f.fk_statut as statut, f.type,";
|
|
if (!$user->hasRight('societe', 'client', 'voir')) {
|
|
$sql .= " sc.fk_soc, sc.fk_user,";
|
|
}
|
|
// Special case for old situation mode: total_ht is stored cumulatively, use delta percent to avoid cumulating margins
|
|
if (getDolGlobalInt('INVOICE_USE_SITUATION') == 1) {
|
|
$sql_delta_pct = 'CASE WHEN f.type = '.Facture::TYPE_SITUATION.' AND d.situation_percent > 0 THEN (d.situation_percent - COALESCE(prev_d.situation_percent, 0)) ELSE d.situation_percent END';
|
|
$sql_delta_ht = 'CASE WHEN f.type = '.Facture::TYPE_SITUATION.' AND d.situation_percent > 0 THEN d.total_ht * ((d.situation_percent - COALESCE(prev_d.situation_percent, 0)) / d.situation_percent) ELSE d.total_ht END';
|
|
$sql .= " sum($sql_delta_ht) as selling_price,"; // may be negative or positive
|
|
$sql .= " ".$db->ifsql('f.type = 2', '-1', '1')." * sum(d.qty) as qty,"; // not always positive in case of Credit note
|
|
$sql .= " ".$db->ifsql('f.type = 2', '-1', '1')." * sum(d.qty * d.buy_price_ht * ($sql_delta_pct / 100)) as buying_price,"; // not always positive in case of Credit note
|
|
$sql .= " ".$db->ifsql('f.type = 2', '-1', '1')." * sum(abs($sql_delta_ht) - (d.buy_price_ht * d.qty * ($sql_delta_pct / 100))) as marge"; // not always positive in case of Credit note
|
|
} else {
|
|
$sql .= " sum(d.total_ht) as selling_price,"; // may be negative or positive
|
|
$sql .= " ".$db->ifsql('f.type = 2', '-1', '1')." * sum(d.qty) as qty,"; // not always positive in case of Credit note
|
|
$sql .= " ".$db->ifsql('f.type = 2', '-1', '1')." * sum(d.qty * d.buy_price_ht * (d.situation_percent / 100)) as buying_price,"; // not always positive in case of Credit note
|
|
$sql .= " ".$db->ifsql('f.type = 2', '-1', '1')." * sum(abs(d.total_ht) - (d.buy_price_ht * d.qty * (d.situation_percent / 100))) as marge"; // not always positive in case of Credit note
|
|
}
|
|
$sql .= " FROM ".MAIN_DB_PREFIX."societe as s";
|
|
$sql .= ", ".MAIN_DB_PREFIX."facture as f";
|
|
$sql .= ", ".MAIN_DB_PREFIX."facturedet as d";
|
|
if (getDolGlobalInt('INVOICE_USE_SITUATION') == 1) {
|
|
$sql .= " LEFT JOIN ".MAIN_DB_PREFIX."facturedet AS prev_d ON prev_d.rowid = d.fk_prev_id";
|
|
}
|
|
if (!$user->hasRight('societe', 'client', 'voir')) {
|
|
$sql .= ", ".MAIN_DB_PREFIX."societe_commerciaux as sc";
|
|
}
|
|
$sql .= " WHERE f.fk_soc = s.rowid";
|
|
$sql .= " AND f.fk_statut > 0";
|
|
$sql .= " AND f.entity IN (".getEntity('invoice').")";
|
|
$sql .= " AND d.fk_facture = f.rowid";
|
|
$sql .= " AND d.fk_product = ".((int) $object->id);
|
|
if (!$user->hasRight('societe', 'client', 'voir')) {
|
|
$sql .= " AND s.rowid = sc.fk_soc AND sc.fk_user = ".((int) $user->id);
|
|
}
|
|
if (!empty($socid)) {
|
|
$sql .= " AND f.fk_soc = ".((int) $socid);
|
|
}
|
|
$sql .= " AND d.buy_price_ht IS NOT NULL";
|
|
// We should not use this here. Option ForceBuyingPriceIfNull should have effect only when inserting data. Once data is recorded, it must be used as it is for report.
|
|
// We keep it with value ForceBuyingPriceIfNull = 2 for retroactive effect but results are unpredictable.
|
|
if (getDolGlobalInt('ForceBuyingPriceIfNull') == 2) {
|
|
$sql .= " AND d.buy_price_ht <> 0";
|
|
}
|
|
if (!empty($search_invoice_date_start)) {
|
|
$sql .= " AND f.datef >= '".$db->idate($search_invoice_date_start)."'";
|
|
}
|
|
if (!empty($search_invoice_date_end)) {
|
|
$sql .= " AND f.datef <= '".$db->idate($search_invoice_date_end)."'";
|
|
}
|
|
$sql .= " GROUP BY s.nom, s.rowid, s.code_client, f.rowid, f.ref, f.total_ht, f.datef, f.paye, f.fk_statut, f.type";
|
|
if (!$user->hasRight('societe', 'client', 'voir')) {
|
|
$sql .= ", sc.fk_soc, sc.fk_user";
|
|
}
|
|
|
|
// TODO: calculate total to display then restore pagination
|
|
|
|
$sql .= $db->order($sortfield, $sortorder);
|
|
if ($limit) {
|
|
$sql .= $db->plimit($limit + 1, $offset);
|
|
}
|
|
dol_syslog('margin:tabs:productMargins.php', LOG_DEBUG);
|
|
$result = $db->query($sql);
|
|
if ($result) {
|
|
$num = $db->num_rows($result);
|
|
|
|
print '<form method="post" action="'.$_SERVER ['PHP_SELF'].'?id='.$id.'" name="search_form">'."\n";
|
|
print '<input type="hidden" name="token" value="'.newToken().'">';
|
|
if (!empty($sortfield)) {
|
|
print '<input type="hidden" name="sortfield" value="'.$sortfield.'"/>';
|
|
}
|
|
if (!empty($sortorder)) {
|
|
print '<input type="hidden" name="sortorder" value="'.$sortorder.'"/>';
|
|
}
|
|
|
|
print_barre_liste($langs->trans("MarginDetails"), $page, $_SERVER["PHP_SELF"], $param, $sortfield, $sortorder, '', $num, '', '');
|
|
|
|
$moreforfilter = '';
|
|
|
|
$parameters = array();
|
|
$reshook = $hookmanager->executeHooks('printFieldPreListTitle', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
|
|
if (empty($reshook)) {
|
|
$moreforfilter .= $hookmanager->resPrint;
|
|
} else {
|
|
$moreforfilter = $hookmanager->resPrint;
|
|
}
|
|
|
|
if (!empty($moreforfilter)) {
|
|
print '<div class="liste_titre liste_titre_bydiv centpercent">';
|
|
print $moreforfilter;
|
|
print '</div>';
|
|
}
|
|
|
|
$selectedfields = '';
|
|
|
|
$i = 0;
|
|
|
|
print '<div class="div-table-responsive">';
|
|
print '<table class="noborder centpercent">';
|
|
|
|
// Fields title search
|
|
// --------------------------------------------------------------------
|
|
print '<tr class="liste_titre liste_titre_filter">';
|
|
// Action column
|
|
if ($conf->main_checkbox_left_column) {
|
|
print '<th class="liste_titre center maxwidthsearch">';
|
|
$searchpicto = $form->showFilterButtons('left');
|
|
print $searchpicto;
|
|
print '</th>';
|
|
}
|
|
|
|
// invoice ref
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// company name
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// customer code
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// invoice date
|
|
print '<th class="liste_titre center">';
|
|
print '<div class="nowrapfordate">';
|
|
print $form->selectDate($search_invoice_date_start ?: -1, 'search_invoice_date_start_', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('From'));
|
|
print '</div>';
|
|
print '<div class="nowrapfordate">';
|
|
print $form->selectDate($search_invoice_date_end ?: -1, 'search_invoice_date_end_', 0, 0, 1, '', 1, 0, 0, '', '', '', '', 1, '', $langs->trans('to'));
|
|
print '</div>';
|
|
print '</th>';
|
|
|
|
// selling price
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// buying price
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// qty
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// margin
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// margin rate
|
|
if (getDolGlobalString('DISPLAY_MARGIN_RATES')) {
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
}
|
|
|
|
// mark rate
|
|
if (getDolGlobalString('DISPLAY_MARK_RATES')) {
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
}
|
|
|
|
// status
|
|
print '<th class="liste_titre">';
|
|
print '</th>';
|
|
|
|
// Action column
|
|
if (!$conf->main_checkbox_left_column) {
|
|
print '<th class="liste_titre center maxwidthsearch">';
|
|
$searchpicto = $form->showFilterButtons();
|
|
print $searchpicto;
|
|
print '</th>';
|
|
}
|
|
|
|
print '</tr>'."\n";
|
|
|
|
print '<tr class="liste_titre">';
|
|
// Action column
|
|
if ($conf->main_checkbox_left_column) {
|
|
print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', $param, '', $sortfield, $sortorder, 'maxwidthsearch center ');
|
|
}
|
|
print_liste_field_titre("Invoice", $_SERVER["PHP_SELF"], "f.ref", "", $param, '', $sortfield, $sortorder);
|
|
print_liste_field_titre("Company", $_SERVER["PHP_SELF"], "s.nom", "", $param, '', $sortfield, $sortorder);
|
|
print_liste_field_titre("CustomerCode", $_SERVER["PHP_SELF"], "s.code_client", "", $param, '', $sortfield, $sortorder);
|
|
print_liste_field_titre("DateInvoice", $_SERVER["PHP_SELF"], "f.datef", "", $param, '', $sortfield, $sortorder, 'center ');
|
|
print_liste_field_titre("SellingPrice", $_SERVER["PHP_SELF"], "selling_price", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
print_liste_field_titre("BuyingPrice", $_SERVER["PHP_SELF"], "buying_price", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
print_liste_field_titre("Qty", $_SERVER["PHP_SELF"], "qty", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
print_liste_field_titre("Margin", $_SERVER["PHP_SELF"], "marge", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
if (getDolGlobalString('DISPLAY_MARGIN_RATES')) {
|
|
print_liste_field_titre("MarginRate", $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
}
|
|
if (getDolGlobalString('DISPLAY_MARK_RATES')) {
|
|
print_liste_field_titre("MarkRate", $_SERVER["PHP_SELF"], "", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
}
|
|
print_liste_field_titre("Status", $_SERVER["PHP_SELF"], "f.paye,f.fk_statut", "", $param, '', $sortfield, $sortorder, 'right ');
|
|
// Action column
|
|
if (!$conf->main_checkbox_left_column) {
|
|
print_liste_field_titre($selectedfields, $_SERVER["PHP_SELF"], "", '', $param, '', $sortfield, $sortorder, 'maxwidthsearch center ');
|
|
}
|
|
print "</tr>\n";
|
|
|
|
$cumul_achat = 0;
|
|
$cumul_vente = 0;
|
|
$cumul_qty = 0;
|
|
|
|
if ($num > 0) {
|
|
$imaxinloop = ($limit ? min($num, $limit) : $num);
|
|
while ($i < $imaxinloop) {
|
|
$objp = $db->fetch_object($result);
|
|
|
|
$marginRate = ($objp->buying_price != 0) ? (100 * $objp->marge / $objp->buying_price) : '';
|
|
$markRate = ($objp->selling_price != 0) ? (100 * $objp->marge / $objp->selling_price) : '';
|
|
|
|
print '<tr class="oddeven">';
|
|
// Action column
|
|
if ($conf->main_checkbox_left_column) {
|
|
print '<td class="nowrap center">';
|
|
print '</td>';
|
|
}
|
|
|
|
print '<td>';
|
|
$invoicestatic->id = $objp->facid;
|
|
$invoicestatic->ref = $objp->ref;
|
|
print $invoicestatic->getNomUrl(1);
|
|
print "</td>\n";
|
|
print '<td><a href="'.DOL_URL_ROOT.'/comm/card.php?socid='.$objp->socid.'">'.img_object($langs->trans("ShowCompany"), "company").' '.dol_trunc($objp->name, 44).'</a></td>';
|
|
print "<td>".$objp->code_client."</td>\n";
|
|
print '<td class="center">';
|
|
print dol_print_date($db->jdate($objp->datef), 'day')."</td>";
|
|
print '<td class="right amount">'.price(price2num($objp->selling_price, 'MT'))."</td>\n";
|
|
print '<td class="right amount">'.price(price2num($objp->buying_price, 'MT'))."</td>\n";
|
|
print '<td class="right">'.price(price2num($objp->qty, 'MT'))."</td>\n";
|
|
print '<td class="right amount">'.price(price2num($objp->marge, 'MT'))."</td>\n";
|
|
if (getDolGlobalString('DISPLAY_MARGIN_RATES')) {
|
|
print "<td class=\"right\">".(($marginRate === '') ? 'n/a' : price(price2num($marginRate, 'MT'))."%")."</td>\n";
|
|
}
|
|
if (getDolGlobalString('DISPLAY_MARK_RATES')) {
|
|
print "<td class=\"right\">".(($markRate === '') ? 'n/a' : price(price2num($markRate, 'MT'))."%")."</td>\n";
|
|
}
|
|
print '<td class="right">'.$invoicestatic->LibStatut($objp->paye, $objp->statut, 5).'</td>';
|
|
|
|
// Action column
|
|
if (!$conf->main_checkbox_left_column) {
|
|
print '<td class="nowrap center">';
|
|
print '</td>';
|
|
}
|
|
print "</tr>\n";
|
|
$i++;
|
|
$cumul_achat += $objp->buying_price;
|
|
$cumul_vente += $objp->selling_price;
|
|
$cumul_qty += $objp->qty;
|
|
}
|
|
}
|
|
|
|
// affichage totaux marges
|
|
|
|
$totalMargin = $cumul_vente - $cumul_achat;
|
|
if ($totalMargin < 0) {
|
|
$marginRate = ($cumul_achat != 0) ? -1 * (100 * $totalMargin / $cumul_achat) : '';
|
|
$markRate = ($cumul_vente != 0) ? -1 * (100 * $totalMargin / $cumul_vente) : '';
|
|
} else {
|
|
$marginRate = ($cumul_achat != 0) ? (100 * $totalMargin / $cumul_achat) : '';
|
|
$markRate = ($cumul_vente != 0) ? (100 * $totalMargin / $cumul_vente) : '';
|
|
}
|
|
print '<tr class="liste_total">';
|
|
$colspan = 4;
|
|
if ($conf->main_checkbox_left_column) {
|
|
$colspan++; // add action column
|
|
}
|
|
print '<td colspan="'.$colspan.'">'.$langs->trans('TotalMargin')."</td>";
|
|
print '<td class="right amount">'.price(price2num($cumul_vente, 'MT'))."</td>\n";
|
|
print '<td class="right amount">'.price(price2num($cumul_achat, 'MT'))."</td>\n";
|
|
print '<td class="right">'.price(price2num($cumul_qty, 'MT'))."</td>\n";
|
|
print '<td class="right amount">'.price(price2num($totalMargin, 'MT'))."</td>\n";
|
|
if (getDolGlobalString('DISPLAY_MARGIN_RATES')) {
|
|
print '<td class="right">'.(($marginRate === '') ? 'n/a' : price(price2num($marginRate, 'MT'))."%")."</td>\n";
|
|
}
|
|
if (getDolGlobalString('DISPLAY_MARK_RATES')) {
|
|
print '<td class="right">'.(($markRate === '') ? 'n/a' : price(price2num($markRate, 'MT'))."%")."</td>\n";
|
|
}
|
|
print '<td class="right"> </td>';
|
|
if (!$conf->main_checkbox_left_column) {
|
|
// add action column
|
|
print '<td class="center">';
|
|
print '</td>';
|
|
}
|
|
print "</tr>\n";
|
|
print "</table>";
|
|
print '</div>';
|
|
print '</form>';
|
|
} else {
|
|
dol_print_error($db);
|
|
}
|
|
$db->free($result);
|
|
}
|
|
}
|
|
} else {
|
|
dol_print_error();
|
|
}
|
|
|
|
print '
|
|
<script type="text/javascript">
|
|
$(document).ready(function() {
|
|
$("#totalMargin").html("'. price(price2num($totalMargin, 'MT'), 1, $langs, 1, -1, -1, getDolCurrency()).'");
|
|
$("#marginRate").html("'.(($marginRate === '') ? 'n/a' : price(price2num($marginRate, 'MT'))."%").'");
|
|
$("#markRate").html("'.(($markRate === '') ? 'n/a' : price(price2num($markRate, 'MT'))."%").'");
|
|
});
|
|
</script>
|
|
';
|
|
|
|
// End of page
|
|
llxFooter();
|
|
$db->close();
|