dolibarr  18.0.0-alpha
html.formmargin.class.php
Go to the documentation of this file.
1 <?php
2 /* Copyright (c) 2015-2019 Laurent Destailleur <eldy@users.sourceforge.net>
3  *
4  * This program is free software; you can redistribute it and/or modify
5  * it under the terms of the GNU General Public License as published by
6  * the Free Software Foundation; either version 3 of the License, or
7  * (at your option) any later version.
8  *
9  * This program is distributed in the hope that it will be useful,
10  * but WITHOUT ANY WARRANTY; without even the implied warranty of
11  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12  * GNU General Public License for more details.
13  *
14  * You should have received a copy of the GNU General Public License
15  * along with this program. If not, see <https://www.gnu.org/licenses/>.
16  */
17 
30 {
34  public $db;
35 
39  public $error = '';
40 
41 
47  public function __construct($db)
48  {
49  $this->db = $db;
50  }
51 
52 
53 
62  public function getMarginInfosArray($object, $force_price = false)
63  {
64  global $conf, $db;
65 
66  // Default returned array
67  $marginInfos = array(
68  'pa_products' => 0,
69  'pv_products' => 0,
70  'margin_on_products' => 0,
71  'margin_rate_products' => '',
72  'mark_rate_products' => '',
73  'pa_services' => 0,
74  'pv_services' => 0,
75  'margin_on_services' => 0,
76  'margin_rate_services' => '',
77  'mark_rate_services' => '',
78  'pa_total' => 0,
79  'pv_total' => 0,
80  'total_margin' => 0,
81  'total_margin_rate' => '',
82  'total_mark_rate' => ''
83  );
84 
85  foreach ($object->lines as $line) {
86  if (empty($line->pa_ht) && isset($line->fk_fournprice) && !$force_price) {
87  require_once DOL_DOCUMENT_ROOT.'/fourn/class/fournisseur.product.class.php';
88  $product = new ProductFournisseur($this->db);
89  if ($product->fetch_product_fournisseur_price($line->fk_fournprice)) {
90  $line->pa_ht = $product->fourn_unitprice * (1 - $product->fourn_remise_percent / 100);
91  }
92  }
93 
94  // If buy price is not defined (null), we will use the sell price. If defined to 0 (it means it was forced to 0 during insert, for example for a free to get product), we must still use 0.
95  //if ((!isset($line->pa_ht) || $line->pa_ht == 0) && $line->subprice > 0 && (isset($conf->global->ForceBuyingPriceIfNull) && $conf->global->ForceBuyingPriceIfNull > 0)) {
96  if ((!isset($line->pa_ht)) && $line->subprice > 0 && (isset($conf->global->ForceBuyingPriceIfNull) && $conf->global->ForceBuyingPriceIfNull > 0)) {
97  $line->pa_ht = $line->subprice * (1 - ($line->remise_percent / 100));
98  }
99 
100  $pv = $line->total_ht;
101  $pa_ht = (($pv < 0 || ($pv == 0 && in_array($object->element, array('facture', 'facture_fourn')) && $object->type == $object::TYPE_CREDIT_NOTE)) ? -$line->pa_ht : $line->pa_ht); // We choosed to have line->pa_ht always positive in database, so we guess the correct sign
102  if (getDolGlobalInt('INVOICE_USE_SITUATION') == 1) { // Special case for old situation mode
103  if (($object->element == 'facture' && $object->type == $object::TYPE_SITUATION)
104  || ($object->element == 'facture' && $object->type == $object::TYPE_CREDIT_NOTE && getDolGlobalInt('INVOICE_USE_SITUATION_CREDIT_NOTE') && $object->situation_counter > 0)) {
105  // We need a compensation relative to $line->situation_percent
106  $pa = $line->qty * $pa_ht * ($line->situation_percent / 100);
107  } else {
108  $pa = $line->qty * $pa_ht;
109  }
110  } else {
111  $pa = $line->qty * $pa_ht;
112  }
113 
114  // calcul des marges
115  if (isset($line->fk_remise_except) && isset($conf->global->MARGIN_METHODE_FOR_DISCOUNT)) { // remise
116  if (getDolGlobalString('MARGIN_METHODE_FOR_DISCOUNT') == '1') { // remise globale considérée comme produit
117  $marginInfos['pa_products'] += $pa;
118  $marginInfos['pv_products'] += $pv;
119  $marginInfos['pa_total'] += $pa;
120  $marginInfos['pv_total'] += $pv;
121  // if credit note, margin = -1 * (abs(selling_price) - buying_price)
122  //if ($pv < 0)
123  //{
124  // $marginInfos['margin_on_products'] += -1 * (abs($pv) - $pa);
125  //}
126  //else
127  $marginInfos['margin_on_products'] += $pv - $pa;
128  } elseif (getDolGlobalString('MARGIN_METHODE_FOR_DISCOUNT') == '2') { // remise globale considérée comme service
129  $marginInfos['pa_services'] += $pa;
130  $marginInfos['pv_services'] += $pv;
131  $marginInfos['pa_total'] += $pa;
132  $marginInfos['pv_total'] += $pv;
133  // if credit note, margin = -1 * (abs(selling_price) - buying_price)
134  //if ($pv < 0)
135  // $marginInfos['margin_on_services'] += -1 * (abs($pv) - $pa);
136  //else
137  $marginInfos['margin_on_services'] += $pv - $pa;
138  } elseif (getDolGlobalString('MARGIN_METHODE_FOR_DISCOUNT') == '3') { // remise globale prise en compte uniqt sur total
139  $marginInfos['pa_total'] += $pa;
140  $marginInfos['pv_total'] += $pv;
141  }
142  } else {
143  $type = $line->product_type ? $line->product_type : $line->fk_product_type;
144  if ($type == 0) { // product
145  $marginInfos['pa_products'] += $pa;
146  $marginInfos['pv_products'] += $pv;
147  $marginInfos['pa_total'] += $pa;
148  $marginInfos['pv_total'] += $pv;
149  // if credit note, margin = -1 * (abs(selling_price) - buying_price)
150  //if ($pv < 0)
151  //{
152  // $marginInfos['margin_on_products'] += -1 * (abs($pv) - $pa);
153  //}
154  //else
155  //{
156  $marginInfos['margin_on_products'] += $pv - $pa;
157  //}
158  } elseif ($type == 1) { // service
159  $marginInfos['pa_services'] += $pa;
160  $marginInfos['pv_services'] += $pv;
161  $marginInfos['pa_total'] += $pa;
162  $marginInfos['pv_total'] += $pv;
163  // if credit note, margin = -1 * (abs(selling_price) - buying_price)
164  //if ($pv < 0)
165  // $marginInfos['margin_on_services'] += -1 * (abs($pv) - $pa);
166  //else
167  $marginInfos['margin_on_services'] += $pv - $pa;
168  }
169  }
170  }
171  if ($marginInfos['pa_products'] > 0) {
172  $marginInfos['margin_rate_products'] = 100 * $marginInfos['margin_on_products'] / $marginInfos['pa_products'];
173  }
174  if ($marginInfos['pv_products'] > 0) {
175  $marginInfos['mark_rate_products'] = 100 * $marginInfos['margin_on_products'] / $marginInfos['pv_products'];
176  }
177 
178  if ($marginInfos['pa_services'] > 0) {
179  $marginInfos['margin_rate_services'] = 100 * $marginInfos['margin_on_services'] / $marginInfos['pa_services'];
180  }
181  if ($marginInfos['pv_services'] > 0) {
182  $marginInfos['mark_rate_services'] = 100 * $marginInfos['margin_on_services'] / $marginInfos['pv_services'];
183  }
184 
185  // if credit note, margin = -1 * (abs(selling_price) - buying_price)
186  //if ($marginInfos['pv_total'] < 0)
187  // $marginInfos['total_margin'] = -1 * (abs($marginInfos['pv_total']) - $marginInfos['pa_total']);
188  //else
189  $marginInfos['total_margin'] = $marginInfos['pv_total'] - $marginInfos['pa_total'];
190  if ($marginInfos['pa_total'] > 0) {
191  $marginInfos['total_margin_rate'] = 100 * $marginInfos['total_margin'] / $marginInfos['pa_total'];
192  }
193  if ($marginInfos['pv_total'] > 0) {
194  $marginInfos['total_mark_rate'] = 100 * $marginInfos['total_margin'] / $marginInfos['pv_total'];
195  }
196 
197  return $marginInfos;
198  }
199 
207  public function displayMarginInfos($object, $force_price = false)
208  {
209  global $langs, $conf, $user, $hookmanager;
210 
211  if (!empty($user->socid)) {
212  return;
213  }
214 
215  if (empty($user->rights->margins->liretous)) {
216  return;
217  }
218 
219  $marginInfo = $this->getMarginInfosArray($object, $force_price);
220 
221  $parameters=array('marginInfo' => &$marginInfo);
222  $reshook = $hookmanager->executeHooks('displayMarginInfos', $parameters, $object, $action);
223  if ($reshook < 0) {
224  setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
225  } elseif (empty($reshook)) {
226  if (!empty($conf->global->MARGIN_ADD_SHOWHIDE_BUTTON)) {
227  print $langs->trans('ShowMarginInfos') . ' ';
228  $hidemargininfos = preg_replace('/[^a-zA-Z0-9_\-]/', '', $_COOKIE['DOLUSER_MARGININFO_HIDE_SHOW']); // Clean cookie
229  print '<span id="showMarginInfos" class="linkobject valignmiddle ' . (!empty($hidemargininfos) ? '' : 'hideobject') . '">' . img_picto($langs->trans("Disabled"), 'switch_off') . '</span>';
230  print '<span id="hideMarginInfos" class="linkobject valignmiddle ' . (!empty($hidemargininfos) ? 'hideobject' : '') . '">' . img_picto($langs->trans("Enabled"), 'switch_on') . '</span>';
231 
232  print '<script nonce="'.getNonce().'">$(document).ready(function() {';
233  print '$("span#showMarginInfos").click(function() { console.log("click on showMargininfos"); date = new Date(); date.setTime(date.getTime()+(30*86400000)); document.cookie = "DOLUSER_MARGININFO_HIDE_SHOW=0; expires=" + date.toGMTString() + "; path=/ "; $(".margintable").show(); $("span#showMarginInfos").addClass("hideobject"); $("span#hideMarginInfos").removeClass("hideobject"); });';
234  print '$("span#hideMarginInfos").click(function() { console.log("click on hideMarginInfos"); date = new Date(); date.setTime(date.getTime()+(30*86400000)); document.cookie = "DOLUSER_MARGININFO_HIDE_SHOW=1; expires=" + date.toGMTString() + "; path=/ "; $(".margintable").hide(); $("span#hideMarginInfos").addClass("hideobject"); $("span#showMarginInfos").removeClass("hideobject"); });';
235  if (!empty($hidemargininfos)) {
236  print 'console.log("hide the margin info"); $("#margintable").hide();';
237  }
238  print '});</script>';
239  }
240 
241  print '<!-- displayMarginInfos() - Show margin table -->' . "\n";
242  print '<div class="div-table-responsive-no-min">';
243 
244  print '<table class="noborder margintable centpercent" id="margintable">';
245  print '<tr class="liste_titre">';
246  print '<td class="liste_titre">' . $langs->trans('Margins') . '</td>';
247  print '<td class="liste_titre right">' . $langs->trans('SellingPrice') . '</td>';
248  if ($conf->global->MARGIN_TYPE == "1") {
249  print '<td class="liste_titre right">' . $langs->trans('BuyingPrice') . '</td>';
250  } else {
251  print '<td class="liste_titre right">' . $langs->trans('CostPrice') . '</td>';
252  }
253  print '<td class="liste_titre right">' . $langs->trans('Margin') . '</td>';
254  if (!empty($conf->global->DISPLAY_MARGIN_RATES)) {
255  print '<td class="liste_titre right">' . $langs->trans('MarginRate') . '</td>';
256  }
257  if (!empty($conf->global->DISPLAY_MARK_RATES)) {
258  print '<td class="liste_titre right">' . $langs->trans('MarkRate') . '</td>';
259  }
260  print '</tr>';
261 
262  if (isModEnabled("product")) {
263  //if ($marginInfo['margin_on_products'] != 0 && $marginInfo['margin_on_services'] != 0) {
264  print '<tr class="oddeven">';
265  print '<td>' . $langs->trans('MarginOnProducts') . '</td>';
266  print '<td class="right">' . price($marginInfo['pv_products']) . '</td>';
267  print '<td class="right">' . price($marginInfo['pa_products']) . '</td>';
268  print '<td class="right">' . price($marginInfo['margin_on_products']) . '</td>';
269  if (!empty($conf->global->DISPLAY_MARGIN_RATES)) {
270  print '<td class="right">' . (($marginInfo['margin_rate_products'] == '') ? '' : price($marginInfo['margin_rate_products'], null, null, null, null, 2) . '%') . '</td>';
271  }
272  if (!empty($conf->global->DISPLAY_MARK_RATES)) {
273  print '<td class="right">' . (($marginInfo['mark_rate_products'] == '') ? '' : price($marginInfo['mark_rate_products'], null, null, null, null, 2) . '%') . '</td>';
274  }
275  print '</tr>';
276  }
277 
278  if (isModEnabled("service")) {
279  print '<tr class="oddeven">';
280  print '<td>' . $langs->trans('MarginOnServices') . '</td>';
281  print '<td class="right">' . price($marginInfo['pv_services']) . '</td>';
282  print '<td class="right">' . price($marginInfo['pa_services']) . '</td>';
283  print '<td class="right">' . price($marginInfo['margin_on_services']) . '</td>';
284  if (!empty($conf->global->DISPLAY_MARGIN_RATES)) {
285  print '<td class="right">' . (($marginInfo['margin_rate_services'] == '') ? '' : price($marginInfo['margin_rate_services'], null, null, null, null, 2) . '%') . '</td>';
286  }
287  if (!empty($conf->global->DISPLAY_MARK_RATES)) {
288  print '<td class="right">' . (($marginInfo['mark_rate_services'] == '') ? '' : price($marginInfo['mark_rate_services'], null, null, null, null, 2) . '%') . '</td>';
289  }
290  print '</tr>';
291  }
292 
293  if (isModEnabled("product") && isModEnabled("service")) {
294  print '<tr class="liste_total">';
295  print '<td>' . $langs->trans('TotalMargin') . '</td>';
296  print '<td class="right">' . price($marginInfo['pv_total']) . '</td>';
297  print '<td class="right">' . price($marginInfo['pa_total']) . '</td>';
298  print '<td class="right">' . price($marginInfo['total_margin']) . '</td>';
299  if (!empty($conf->global->DISPLAY_MARGIN_RATES)) {
300  print '<td class="right">' . (($marginInfo['total_margin_rate'] == '') ? '' : price($marginInfo['total_margin_rate'], null, null, null, null, 2) . '%') . '</td>';
301  }
302  if (!empty($conf->global->DISPLAY_MARK_RATES)) {
303  print '<td class="right">' . (($marginInfo['total_mark_rate'] == '') ? '' : price($marginInfo['total_mark_rate'], null, null, null, null, 2) . '%') . '</td>';
304  }
305  print '</tr>';
306  }
307  print $hookmanager->resPrint;
308  print '</table>';
309  print '</div>';
310  } elseif ($reshook > 0) {
311  print $hookmanager->resPrint;
312  }
313  }
314 }
db
$conf db
API class for accounts.
Definition: inc.php:41
ProductFournisseur
Class to manage predefined suppliers products.
Definition: fournisseur.product.class.php:40
FormMargin
Classe permettant la generation de composants html autre Only common components are here.
Definition: html.formmargin.class.php:29
img_picto
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=false, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2)
Show picto whatever it's its name (generic function)
Definition: functions.lib.php:4061
FormMargin\displayMarginInfos
displayMarginInfos($object, $force_price=false)
Show the array with all margin infos.
Definition: html.formmargin.class.php:207
isModEnabled
isModEnabled($module)
Is Dolibarr module enabled.
Definition: functions.lib.php:166
getDolGlobalString
getDolGlobalString($key, $default='')
Return dolibarr global constant string value.
Definition: functions.lib.php:101
FormMargin\__construct
__construct($db)
Constructor.
Definition: html.formmargin.class.php:47
FormMargin\getMarginInfosArray
getMarginInfosArray($object, $force_price=false)
get array with margin information from lines of object TODO Move this in common class.
Definition: html.formmargin.class.php:62
price
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.
Definition: functions.lib.php:5750
setEventMessages
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='')
Set event messages in dol_events session object.
Definition: functions.lib.php:8552
getDolGlobalInt
getDolGlobalInt($key, $default=0)
Return dolibarr global constant int value.
Definition: functions.lib.php:115