dolibarr 22.0.5
inventory.php
Go to the documentation of this file.
1<?php
2/* Copyright (C) 2019 Laurent Destailleur <eldy@users.sourceforge.net>
3 * Copyright (C) 2024 Frédéric France <frederic.france@free.fr>
4 * Copyright (C) 2025 MDW <mdeweerd@users.noreply.github.com>
5 *
6 * This program is free software; you can redistribute it and/or modify
7 * it under the terms of the GNU General Public License as published by
8 * the Free Software Foundation; either version 3 of the License, or
9 * (at your option) any later version.
10 *
11 * This program is distributed in the hope that it will be useful,
12 * but WITHOUT ANY WARRANTY; without even the implied warranty of
13 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 * GNU General Public License for more details.
15 *
16 * You should have received a copy of the GNU General Public License
17 * along with this program. If not, see <https://www.gnu.org/licenses/>.
18 */
19
26// Load Dolibarr environment
27require '../../main.inc.php';
28include_once DOL_DOCUMENT_ROOT.'/core/class/html.formcompany.class.php';
29include_once DOL_DOCUMENT_ROOT.'/product/class/html.formproduct.class.php';
30include_once DOL_DOCUMENT_ROOT.'/product/class/product.class.php';
31include_once DOL_DOCUMENT_ROOT.'/product/inventory/class/inventory.class.php';
32include_once DOL_DOCUMENT_ROOT.'/product/inventory/lib/inventory.lib.php';
33include_once DOL_DOCUMENT_ROOT.'/product/stock/class/mouvementstock.class.php';
34include_once DOL_DOCUMENT_ROOT.'/product/stock/class/productlot.class.php';
35
44// Load translation files required by the page
45$langs->loadLangs(array("stocks", "other", "productbatch"));
46
47// Get parameters
48$id = GETPOSTINT('id');
49$ref = GETPOST('ref', 'alpha');
50$action = GETPOST('action', 'aZ09');
51$confirm = GETPOST('confirm', 'alpha');
52$cancel = GETPOST('cancel');
53$contextpage = GETPOST('contextpage', 'aZ') ? GETPOST('contextpage', 'aZ') : 'inventorycard'; // To manage different context of search
54$backtopage = GETPOST('backtopage', 'alpha');
55$listoffset = GETPOST('listoffset', 'alpha');
56$sortfield = GETPOST('sortfield', 'aZ09comma');
57$sortorder = GETPOST('sortorder', 'aZ09comma');
58$limit = GETPOSTINT('limit') > 0 ? GETPOSTINT('limit') : $conf->liste_limit;
59$page = GETPOSTISSET('pageplusone') ? (GETPOSTINT('pageplusone') - 1) : GETPOSTINT("page");
60if (empty($page) || $page == -1) {
61 $page = 0;
62}
63$offset = $limit * $page;
64$pageprev = $page - 1;
65$pagenext = $page + 1;
66
67$fk_warehouse = GETPOSTINT('fk_warehouse');
68$fk_product = GETPOSTINT('fk_product');
69$lineid = GETPOSTINT('lineid');
70$batch = GETPOST('batch', 'alphanohtml');
71$totalExpectedValuation = 0;
72$totalRealValuation = 0;
73$hookmanager->initHooks(array('inventorycard')); // Note that conf->hooks_modules contains array
74if (!getDolGlobalString('MAIN_USE_ADVANCED_PERMS')) {
75 $result = restrictedArea($user, 'stock', $id, 'inventory&stock');
76} else {
77 $result = restrictedArea($user, 'stock', $id, 'inventory&stock', 'inventory_advance');
78}
79
80// Initialize a technical objects
81$object = new Inventory($db);
82$extrafields = new ExtraFields($db);
83$diroutputmassaction = $conf->stock->dir_output.'/temp/massgeneration/'.$user->id;
84
85// Default sort order (if not yet defined by previous GETPOST)
86if (!$sortfield) {
87 $sortfield = "e.ref";
88}
89if (!$sortorder) {
90 $sortorder = "ASC";
91}
92
93// Fetch optionals attributes and labels
94$extrafields->fetch_name_optionals_label($object->table_element);
95
96$search_array_options = $extrafields->getOptionalsFromPost($object->table_element, '', 'search_');
97
98// Initialize array of search criteria
99$search_all = GETPOST("search_all", 'alpha');
100$search = array();
101foreach ($object->fields as $key => $val) {
102 if (GETPOST('search_'.$key, 'alpha')) {
103 $search[$key] = GETPOST('search_'.$key, 'alpha');
104 }
105}
106
107if (empty($action) && empty($id) && empty($ref)) {
108 $action = 'view';
109}
110
111// Load object
112include DOL_DOCUMENT_ROOT.'/core/actions_fetchobject.inc.php'; // Must be 'include', not 'include_once'.
113
114// Security check - Protection if external user
115//if ($user->socid > 0) accessforbidden();
116//if ($user->socid > 0) $socid = $user->socid;
117//$result = restrictedArea($user, 'mymodule', $id);
118
119//Parameters Page
120$paramwithsearch = '&sortfield=' . urlencode($sortfield);
121$paramwithsearch .= '&sortorder=' . urlencode($sortorder);
122if ($limit > 0 && $limit != $conf->liste_limit) {
123 $paramwithsearch .= '&limit='.((int) $limit);
124}
125
126// Sort by warehouse/product or product/warehouse, in the SQL requests only: the form sends back $sortfield and $sortorder,
127// so adding the secondary sort to them would add it again at each submit.
128$sortfieldforsql = $sortfield . ',' . ($sortfield == 'e.ref' ? 'p.ref' : 'e.ref') . ',id.batch,id.rowid';
129$sortorderforsql = $sortorder . ',' . $sortorder.",ASC,ASC";
130
131if (!getDolGlobalString('MAIN_USE_ADVANCED_PERMS')) {
132 $permissiontoadd = $user->hasRight('stock', 'creer');
133 $permissiontodelete = $user->hasRight('stock', 'supprimer');
134 $permissiontoupdatestock = $user->hasRight('stock', 'mouvement', 'creer');
135} else {
136 $permissiontoadd = $user->hasRight('stock', 'inventory_advance', 'write');
137 $permissiontodelete = $user->hasRight('stock', 'inventory_advance', 'write');
138 $permissiontoupdatestock = $user->hasRight('stock', 'inventory_advance', 'write');
139}
140
141$now = dol_now();
142
143
144
145/*
146 * Actions
147 */
148
149if ($cancel) {
150 $action = '';
151}
152
153
154$parameters = array();
155$reshook = $hookmanager->executeHooks('doActions', $parameters, $object, $action); // Note that $action and $object may have been modified by some hooks
156if ($reshook < 0) {
157 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
158}
159
160if (empty($reshook)) {
161 $error = 0;
162
163 if ($action == 'cancel_record' && $confirm == 'yes' && $permissiontoupdatestock && $object->status == $object::STATUS_VALIDATED) {
164 $object->setCanceled($user);
165 }
166
167 // Close inventory by recording the stock movements
168 if ($action == 'update' && $confirm == 'yes' && $permissiontoupdatestock && $object->status == $object::STATUS_VALIDATED) {
169 $stockmovment = new MouvementStock($db);
170 $stockmovment->setOrigin($object->element, $object->id);
171
172 $cacheOfProducts = array();
173
174 $db->begin();
175
176 $sql = 'SELECT id.rowid, id.datec as date_creation, id.tms as date_modification, id.fk_inventory, id.fk_warehouse,';
177 $sql .= ' id.fk_product, id.batch, id.qty_stock, id.qty_view, id.qty_regulated, id.pmp_real';
178 $sql .= ' FROM '.MAIN_DB_PREFIX.'inventorydet as id';
179 $sql .= ' WHERE id.fk_inventory = '.((int) $object->id);
180 $sql .= ' ORDER BY id.rowid';
181
182 $resql = $db->query($sql);
183 if ($resql) {
184 $num = $db->num_rows($resql);
185 $i = 0;
186 $totalarray = array();
187 $option = '';
188
189 while ($i < $num) {
190 $line = $db->fetch_object($resql);
191
192 $qty_stock = $line->qty_stock;
193 $qty_view = $line->qty_view; // The quantity viewed by inventorier, the qty we target
194
195
196 // Load real stock we have now.
197 if (isset($cacheOfProducts[$line->fk_product])) {
198 $product_static = $cacheOfProducts[$line->fk_product];
199 } else {
200 $product_static = new Product($db);
201 $result = $product_static->fetch($line->fk_product, '', '', '', 1, 1, 1);
202
203 //$option = 'nobatch';
204 $option .= ',novirtual';
205 $product_static->load_stock($option); // Load stock_reel + stock_warehouse.
206
207 $cacheOfProducts[$product_static->id] = $product_static;
208 }
209
210 // Get the real quantity in stock now, but before the stock move for inventory.
211 $realqtynow = $product_static->stock_warehouse[$line->fk_warehouse]->real;
212 if (isModEnabled('productbatch') && $product_static->hasbatch()) {
213 // Search the lot without case sensitivity, like the database (and the stock movement) does,
214 // otherwise a lot typed with another case is seen as empty and the full counted qty is added.
215 $realqtynow = 0;
216 if (!empty($product_static->stock_warehouse[$line->fk_warehouse]->detail_batch)) {
217 foreach ($product_static->stock_warehouse[$line->fk_warehouse]->detail_batch as $tmpbatchnumber => $tmpdetailbatch) {
218 if (dol_strtolower((string) $tmpbatchnumber) == dol_strtolower((string) $line->batch)) {
219 $realqtynow = $tmpdetailbatch->qty;
220 break;
221 }
222 }
223 }
224 }
225
226 if (!is_null($qty_view)) {
227 $stock_movement_qty = price2num($qty_view - $realqtynow, 'MS');
228 //print "Process inventory line ".$line->rowid." product=".$product_static->id." realqty=".$realqtynow." qty_stock=".$qty_stock." qty_view=".$qty_view." warehouse=".$line->fk_warehouse." qty to move=".$stock_movement_qty."<br>\n";
229
230 if ($stock_movement_qty != 0) {
231 if ($stock_movement_qty < 0) {
232 $movement_type = 1;
233 } else {
234 $movement_type = 0;
235 }
236
237 $datemovement = '';
238 //$inventorycode = 'INV'.$object->id;
239 $inventorycode = 'INV-'.$object->ref;
240 $price = 0;
241 if (!empty($line->pmp_real) && getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
242 $price = $line->pmp_real;
243 }
244
245 $idstockmove = $stockmovment->_create($user, $line->fk_product, $line->fk_warehouse, (float) $stock_movement_qty, $movement_type, $price, $langs->trans('LabelOfInventoryMovemement', $object->ref), $inventorycode, $datemovement, '', '', $line->batch);
246 if ($idstockmove < 0) {
247 $error++;
248 setEventMessages($stockmovment->error, $stockmovment->errors, 'errors');
249 break;
250 }
251
252 // Update line with id of stock movement (and the start quantity if it has changed this last recording)
253 $sqlupdate = "UPDATE ".MAIN_DB_PREFIX."inventorydet";
254 $sqlupdate .= " SET fk_movement = ".((int) $idstockmove);
255 if ($qty_stock != $realqtynow) {
256 $sqlupdate .= ", qty_stock = ".((float) $realqtynow);
257 }
258 $sqlupdate .= " WHERE rowid = ".((int) $line->rowid);
259 $resqlupdate = $db->query($sqlupdate);
260 if (! $resqlupdate) {
261 $error++;
262 setEventMessages($db->lasterror(), null, 'errors');
263 break;
264 }
265 }
266
267 if (!empty($line->pmp_real) && getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
268 $sqlpmp = 'UPDATE '.MAIN_DB_PREFIX.'product SET pmp = '.((float) $line->pmp_real).' WHERE rowid = '.((int) $line->fk_product);
269 $resqlpmp = $db->query($sqlpmp);
270 if (! $resqlpmp) {
271 $error++;
272 setEventMessages($db->lasterror(), null, 'errors');
273 break;
274 }
275 if (getDolGlobalString('MAIN_PRODUCT_PERENTITY_SHARED')) {
276 $sqlpmp = 'UPDATE '.MAIN_DB_PREFIX.'product_perentity SET pmp = '.((float) $line->pmp_real).' WHERE fk_product = '.((int) $line->fk_product).' AND entity='.$conf->entity;
277 $resqlpmp = $db->query($sqlpmp);
278 if (! $resqlpmp) {
279 $error++;
280 setEventMessages($db->lasterror(), null, 'errors');
281 break;
282 }
283 }
284 }
285 }
286 $i++;
287 }
288
289 if (!$error) {
290 $object->setRecorded($user);
291 }
292 } else {
293 setEventMessages($db->lasterror, null, 'errors');
294 $error++;
295 }
296
297 if (! $error) {
298 $db->commit();
299 } else {
300 $db->rollback();
301 }
302 $action = '';
303 }
304
305 // Save quantity found during inventory (when we click on Save button on inventory page)
306 if ($action == 'updateinventorylines' && $permissiontoupdatestock) {
307 $sql = 'SELECT id.rowid, id.datec as date_creation, id.tms as date_modification, id.fk_inventory, id.fk_warehouse,';
308 $sql .= ' id.fk_product, id.batch, id.qty_stock, id.qty_view, id.qty_regulated';
309 $sql .= ' FROM '.MAIN_DB_PREFIX.'inventorydet as id';
310 $sql .= ' LEFT JOIN ' . $db->prefix() . 'product as p ON id.fk_product = p.rowid';
311 $sql .= ' LEFT JOIN ' . $db->prefix() . 'entrepot as e ON id.fk_warehouse = e.rowid';
312 $sql .= ' WHERE id.fk_inventory = '.((int) $object->id);
313 $sql .= $db->order($sortfieldforsql, $sortorderforsql);
314 $sql .= $db->plimit($limit, $offset);
315
316 $db->begin();
317
318 $resql = $db->query($sql);
319 if ($resql) {
320 $num = $db->num_rows($resql);
321 $i = 0;
322 $totalarray = array();
323 $inventoryline = new InventoryLine($db);
324
325 while ($i < $num) {
326 $line = $db->fetch_object($resql);
327 $lineid = $line->rowid;
328
329 $result = 0;
330 $resultupdate = 0;
331
332 if (GETPOST("id_".$lineid, 'alpha') != '') { // If a value was set ('0' or something else)
333 $qtytoupdate = (float) price2num(GETPOST("id_".$lineid, 'alpha'), 'MS');
334 $result = $inventoryline->fetch($lineid);
335 if ($qtytoupdate < 0) {
336 $result = -1;
337 setEventMessages($langs->trans("FieldCannotBeNegative", $langs->transnoentitiesnoconv("RealQty")), null, 'errors');
338 }
339 if ($result > 0) {
340 $inventoryline->qty_stock = (float) price2num(GETPOST('stock_qty_'.$lineid, 'alpha'), 'MS'); // The new value that was set in as hidden field
341 $inventoryline->qty_view = $qtytoupdate; // The new value we want
342 $inventoryline->pmp_real = price2num(GETPOST('realpmp_'.$lineid, 'alpha'), 'MS');
343 $inventoryline->pmp_expected = price2num(GETPOST('expectedpmp_'.$lineid, 'alpha'), 'MS');
344 $resultupdate = $inventoryline->update($user);
345 }
346 } elseif (GETPOSTISSET('id_' . $lineid)) {
347 // Delete record
348 $result = $inventoryline->fetch($lineid);
349 if ($result > 0) {
350 $inventoryline->qty_view = null; // The new value we want
351 $inventoryline->pmp_real = price2num(GETPOST('realpmp_'.$lineid, 'alpha'), 'MS');
352 $inventoryline->pmp_expected = price2num(GETPOST('expectedpmp_'.$lineid, 'alpha'), 'MS');
353 $resultupdate = $inventoryline->update($user);
354 }
355 }
356
357 if ($result < 0 || $resultupdate < 0) {
358 $error++;
359 }
360
361 $i++;
362 }
363 }
364
365 // Update line with id of stock movement (and the start quantity if it has changed this last recording)
366 if (! $error) {
367 $sqlupdate = "UPDATE ".MAIN_DB_PREFIX."inventory";
368 $sqlupdate .= " SET fk_user_modif = ".((int) $user->id);
369 $sqlupdate .= " WHERE rowid = ".((int) $object->id);
370 $resqlupdate = $db->query($sqlupdate);
371 if (! $resqlupdate) {
372 $error++;
373 setEventMessages($db->lasterror(), null, 'errors');
374 }
375 }
376
377 if (!$error) {
378 $db->commit();
379 } else {
380 $db->rollback();
381 }
382 }
383
384 $backurlforlist = DOL_URL_ROOT.'/product/inventory/list.php';
385 $backtopage = DOL_URL_ROOT.'/product/inventory/inventory.php?id='.$object->id.'&page='.$page.$paramwithsearch;
386
387 // Action 'update' of this page is the recording of the inventory (done above or refused), never the
388 // generic update of the object: it would overwrite the fields of the inventory with empty values.
389 if ($action == 'update') { // Test on permission not required here
390 $action = '';
391 }
392
393 // Actions cancel, add, update, delete or clone
394 include DOL_DOCUMENT_ROOT.'/core/actions_addupdatedelete.inc.php';
395
396 // Actions when linking object each other
397 include DOL_DOCUMENT_ROOT.'/core/actions_dellink.inc.php';
398
399 // Actions when printing a doc from card
400 include DOL_DOCUMENT_ROOT.'/core/actions_printing.inc.php';
401
402 // Actions to send emails
403 /*$triggersendname = 'MYOBJECT_SENTBYMAIL';
404 $autocopy='MAIN_MAIL_AUTOCOPY_MYOBJECT_TO';
405 $trackid='stockinv'.$object->id;
406 include DOL_DOCUMENT_ROOT.'/core/actions_sendmails.inc.php';*/
407
408 if (GETPOST('addline', 'alpha')) {
409 $qty = (GETPOST('qtytoadd') != '' ? ((float) price2num(GETPOST('qtytoadd'), 'MS')) : null);
410 if ($fk_warehouse <= 0) {
411 $error++;
412 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Warehouse")), null, 'errors');
413 }
414 if ($fk_product <= 0) {
415 $error++;
416 setEventMessages($langs->trans("ErrorFieldRequired", $langs->transnoentitiesnoconv("Product")), null, 'errors');
417 }
418 if (price2num(GETPOST('qtytoadd'), 'MS') < 0) {
419 $error++;
420 setEventMessages($langs->trans("FieldCannotBeNegative", $langs->transnoentitiesnoconv("RealQty")), null, 'errors');
421 }
422 if (!$error && isModEnabled('productbatch')) {
423 $tmpproduct = new Product($db);
424 $result = $tmpproduct->fetch($fk_product);
425
426 if (empty($error) && $tmpproduct->status_batch > 0 && empty($batch)) {
427 $error++;
428 $langs->load("errors");
429 setEventMessages($langs->trans("ErrorProductNeedBatchNumber", $tmpproduct->ref), null, 'errors');
430 }
431 if (empty($error) && $tmpproduct->status_batch == 2 && !empty($batch) && $qty > 1) {
432 $error++;
433 $langs->load("errors");
434 setEventMessages($langs->trans("TooManyQtyForSerialNumber", $tmpproduct->ref, $batch), null, 'errors');
435 }
436 if (empty($error) && empty($tmpproduct->status_batch) && !empty($batch)) {
437 $error++;
438 $langs->load("errors");
439 setEventMessages($langs->trans("ErrorProductDoesNotNeedBatchNumber", $tmpproduct->ref), null, 'errors');
440 }
441 }
442 if (!$error) {
443 $tmp = new InventoryLine($db);
444 $tmp->fk_inventory = $object->id;
445 $tmp->fk_warehouse = $fk_warehouse;
446 $tmp->fk_product = $fk_product;
447 $tmp->batch = $batch;
448 $tmp->datec = $now;
449 $tmp->qty_view = $qty;
450
451 $result = $tmp->create($user);
452 if ($result < 0) {
453 if ($db->lasterrno() == 'DB_ERROR_RECORD_ALREADY_EXISTS') {
454 $langs->load("errors");
455 setEventMessages($langs->trans("ErrorRecordAlreadyExists"), null, 'errors');
456 } else {
457 dol_print_error($db, $tmp->error, $tmp->errors);
458 }
459 } else {
460 // Clear var
461 $_POST['batch'] = ''; // TODO Replace this with a var
462 $_POST['qtytoadd'] = '';
463 }
464 }
465 }
466}
467
468
469
470/*
471 * View
472 */
473
474$form = new Form($db);
475$formproduct = new FormProduct($db);
476
477$help_url = '';
478
479llxHeader('', $langs->trans('Inventory'), $help_url, '', 0, 0, '', '', '', 'mod-product page-inventory_inventory');
480
481// Part to show record
482if ($object->id <= 0) {
483 dol_print_error(null, 'Bad value for object id');
484 exit;
485}
486
487$param = '';
488if ($limit > 0 && $limit != $conf->liste_limit) {
489 $param .= '&limit=' . ((int) $limit);
490}
491
492
493$res = $object->fetch_optionals();
494
495$head = inventoryPrepareHead($object);
496print dol_get_fiche_head($head, 'inventory', $langs->trans("Inventory"), -1, 'stock');
497
498$formconfirm = '';
499
500// Confirmation to delete
501if ($action == 'delete') {
502 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id, $langs->trans('DeleteInventory'), $langs->trans('ConfirmDeleteOrder'), 'confirm_delete', '', 0, 1);
503}
504// Confirmation to delete line
505if ($action == 'deleteline') {
506 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id.'&lineid='.$lineid.'&page='.$page.$paramwithsearch, $langs->trans('DeleteLine'), $langs->trans('ConfirmDeleteLine'), 'confirm_deleteline', '', 0, 1);
507}
508
509// Clone confirmation
510if ($action == 'clone') {
511 // Create an array for form
512 $formquestion = array();
513 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id, $langs->trans('ToClone'), $langs->trans('ConfirmCloneMyObject', $object->ref), 'confirm_clone', $formquestion, 'yes', 1);
514}
515
516// Confirmation to close
517if ($action == 'record') {
518 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id.'&page='.$page.$paramwithsearch, $langs->trans('Close'), $langs->trans('ConfirmFinish'), 'update', '', 0, 1);
519 $action = 'view';
520}
521
522// Confirmation to close
523if ($action == 'confirm_cancel') {
524 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id, $langs->trans('Cancel'), $langs->trans('ConfirmCancel'), 'cancel_record', '', 0, 1);
525 $action = 'view';
526}
527
528if ($action == 'validate') {
529 $form = new Form($db);
530 $formquestion = '';
531 if (getDolGlobalInt('INVENTORY_INCLUDE_SUB_WAREHOUSE') && !empty($object->fk_warehouse)) {
532 $formquestion = array(
533 array('type' => 'checkbox', 'name' => 'include_sub_warehouse', 'label' => $langs->trans("IncludeSubWarehouse"), 'value' => 1, 'size' => '10'),
534 );
535 $formconfirm = $form->formconfirm($_SERVER["PHP_SELF"].'?id='.$object->id, $langs->trans('ValidateInventory'), $langs->trans('IncludeSubWarehouseExplanation'), 'confirm_validate', $formquestion, '', 1);
536 }
537}
538
539// Call Hook formConfirm
540$parameters = array('formConfirm' => $formconfirm, 'lineid' => $lineid);
541$reshook = $hookmanager->executeHooks('formConfirm', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
542if (empty($reshook)) {
543 $formconfirm .= $hookmanager->resPrint;
544} elseif ($reshook > 0) {
545 $formconfirm = $hookmanager->resPrint;
546}
547
548// Print form confirm
549print $formconfirm;
550
551
552// Object card
553// ------------------------------------------------------------
554$linkback = '<a href="'.DOL_URL_ROOT.'/product/inventory/list.php">'.$langs->trans("BackToList").'</a>';
555
556$morehtmlref = '<div class="refidno">';
557/*
558// Ref bis
559$morehtmlref.=$form->editfieldkey("RefBis", 'ref_client', $object->ref_client, $object, $user->rights->inventory->creer, 'string', '', 0, 1);
560$morehtmlref.=$form->editfieldval("RefBis", 'ref_client', $object->ref_client, $object, $user->rights->inventory->creer, 'string', '', null, null, '', 1);
561// Thirdparty
562$morehtmlref.='<br>'.$langs->trans('ThirdParty') . ' : ' . $soc->getNomUrl(1);
563// Project
564if (isModEnabled('project'))
565{
566 $langs->load("projects");
567 $morehtmlref.='<br>'.$langs->trans('Project') . ' ';
568 if ($user->rights->inventory->creer)
569 {
570 if ($action != 'classify')
571 {
572 $morehtmlref.='<a class="editfielda" href="' . $_SERVER['PHP_SELF'] . '?action=classify&token='.newToken().'&id=' . $object->id . '">' . img_edit($langs->transnoentitiesnoconv('SetProject')) . '</a> : ';
573 if ($action == 'classify') {
574 //$morehtmlref.=$form->form_project($_SERVER['PHP_SELF'] . '?id=' . $object->id, $object->socid, $object->fk_project, 'projectid', 0, 0, 1, 1);
575 $morehtmlref.='<form method="post" action="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'">';
576 $morehtmlref.='<input type="hidden" name="action" value="classin">';
577 $morehtmlref.='<input type="hidden" name="token" value="'.newToken().'">';
578 $morehtmlref.=$formproject->select_projects($object->socid, $object->fk_project, 'projectid', $maxlength, 0, 1, 0, 1, 0, 0, '', 1);
579 $morehtmlref.='<input type="submit" class="button valignmiddle" value="'.$langs->trans("Modify").'">';
580 $morehtmlref.='</form>';
581 } else {
582 $morehtmlref.=$form->form_project($_SERVER['PHP_SELF'] . '?id=' . $object->id, $object->socid, $object->fk_project, 'none', 0, 0, 0, 1);
583 }
584 }
585 } else {
586 if (!empty($object->fk_project)) {
587 $proj = new Project($db);
588 $proj->fetch($object->fk_project);
589 $morehtmlref.=$proj->getNomUrl();
590 } else {
591 $morehtmlref.='';
592 }
593 }
594}
595*/
596$morehtmlref .= '</div>';
597
598
599dol_banner_tab($object, 'ref', $linkback, 1, 'ref', 'ref', $morehtmlref);
600
601
602print '<div class="fichecenter">';
603print '<div class="fichehalfleft">';
604print '<div class="underbanner clearboth"></div>';
605print '<table class="border centpercent tableforfield">'."\n";
606
607// Common attributes
608include DOL_DOCUMENT_ROOT.'/core/tpl/commonfields_view.tpl.php';
609
610// Other attributes. Fields from hook formObjectOptions and Extrafields.
611include DOL_DOCUMENT_ROOT.'/core/tpl/extrafields_view.tpl.php';
612
613//print '<tr><td class="titlefield fieldname_invcode">'.$langs->trans("InventoryCode").'</td><td>INV'.$object->id.'</td></tr>';
614
615print '</table>';
616print '</div>';
617print '</div>';
618
619print '<div class="clearboth"></div>';
620
621print dol_get_fiche_end();
622
623print '<form id="formrecord" name="formrecord" method="POST" action="'.$_SERVER["PHP_SELF"].'?page='.$page.'&id='.$object->id.'">';
624print '<input type="hidden" name="token" value="'.newToken().'">';
625print '<input type="hidden" name="action" value="updateinventorylines">';
626print '<input type="hidden" name="id" value="'.$object->id.'">';
627print '<input type="hidden" name="sortfield" value="' . $sortfield . '">';
628print '<input type="hidden" name="sortorder" value="' . $sortorder . '">';
629// Keep the same limit as the displayed page, otherwise the save reads a different page slice
630// (plimit($limit, $offset)) than the one shown and quantities of the extra rows are lost (#35207).
631print '<input type="hidden" name="limit" value="' . ((int) $limit) . '">';
632if ($backtopage) {
633 print '<input type="hidden" name="backtopage" value="'.$backtopage.'">';
634}
635
636
637// Buttons for actions
638if ($action != 'record') {
639 print '<div class="tabsAction">'."\n";
640 $parameters = array();
641 $reshook = $hookmanager->executeHooks('addMoreActionsButtons', $parameters, $object, $action); // Note that $action and $object may have been modified by hook
642 if ($reshook < 0) {
643 setEventMessages($hookmanager->error, $hookmanager->errors, 'errors');
644 }
645
646 if (empty($reshook)) {
647 if ($object->status == Inventory::STATUS_DRAFT) {
648 if ($permissiontoupdatestock) {
649 if (getDolGlobalInt('INVENTORY_INCLUDE_SUB_WAREHOUSE') && !empty($object->fk_warehouse)) {
650 print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=validate&token='.newToken().'">'.$langs->trans("Validate").' ('.$langs->trans("Start").')</a>';
651 } else {
652 print '<a class="butAction" href="'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&action=confirm_validate&confirm=yes&token='.newToken().'">'.$langs->trans("Validate").' ('.$langs->trans("Start").')</a>';
653 }
654 } else {
655 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("NotEnoughPermissions")).'">'.$langs->trans('Validate').' ('.$langs->trans("Start").')</a>'."\n";
656 }
657 }
658
659 // Save
660 if ($object->status == $object::STATUS_VALIDATED) {
661 if ($permissiontoupdatestock) {
662 print '<a class="butAction classfortooltip" id="idbuttonmakemovementandclose" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=record&page='.$page.$paramwithsearch.'&token='.newToken().'" title="'.dol_escape_htmltag($langs->trans("MakeMovementsAndClose")).'">'.$langs->trans("MakeMovementsAndClose").'</a>'."\n";
663 } else {
664 print '<a class="butActionRefused classfortooltip" href="#" title="'.dol_escape_htmltag($langs->trans("NotEnoughPermissions")).'">'.$langs->trans('MakeMovementsAndClose').'</a>'."\n";
665 }
666
667 if ($permissiontoupdatestock) {
668 print '<a class="butActionDelete" href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=confirm_cancel&page='.$page.$paramwithsearch.'&token='.newToken().'">'.$langs->trans("Cancel").'</a>'."\n";
669 }
670 }
671 }
672 print '</div>'."\n";
673
674 if ($object->status != Inventory::STATUS_DRAFT && $object->status != Inventory::STATUS_VALIDATED) {
675 print '<br><br>';
676 }
677}
678
679
680
681if ($object->status == Inventory::STATUS_VALIDATED) {
682 print '<center>';
683 if (!empty($conf->use_javascript_ajax)) {
684 if ($permissiontoupdatestock) {
685 // Link to launch scan tool
686 if (isModEnabled('barcode') || isModEnabled('productbatch')) {
687 print '<a href="'.$_SERVER["PHP_SELF"].'?id='.$object->id.'&action=updatebyscaning&token='.currentToken().'" class="marginrightonly paddingright marginleftonly paddingleft">'.img_picto('', 'barcode', 'class="paddingrightonly"').$langs->trans("UpdateByScaning").'</a>';
688 }
689
690 // Link to autofill
691 print '<a id="fillwithexpected" class="marginrightonly paddingright marginleftonly paddingleft" href="#">'.img_picto('', 'autofill', 'class="paddingrightonly"').$langs->trans('AutofillWithExpected').'</a>';
692 print '<script>';
693 print '$( document ).ready(function() {';
694 print ' $("#fillwithexpected").on("click",function fillWithExpected(){
695 $(".expectedqty").each(function(){
696 var object = $(this)[0];
697 var objecttofill = $("#"+object.id+"_input")[0];
698 objecttofill.value = object.innerText;
699 jQuery(".realqty").trigger("change");
700 })
701 console.log("Values filled (after click on fillwithexpected)");
702 /* disablebuttonmakemovementandclose(); */
703 return false;
704 });';
705 print '});';
706 print '</script>';
707
708 // Link to reset qty
709 print '<a href="#" id="clearqty" class="marginrightonly paddingright marginleftonly paddingleft">'.img_picto('', 'eraser', 'class="paddingrightonly"').$langs->trans("ClearQtys").'</a>';
710 } else {
711 print '<a class="classfortooltip marginrightonly paddingright marginleftonly paddingleft" href="#" title="'.dol_escape_htmltag($langs->trans("NotEnoughPermissions")).'">'.$langs->trans("Save").'</a>'."\n";
712 }
713 }
714 print '<br>';
715 print '<br>';
716 print '</center>';
717}
718
719
720// Popup for mass barcode scanning
721if ($action == 'updatebyscaning') {
722 if ($permissiontoupdatestock) {
723 // Output the javascript to manage the scanner tool.
724 print '<script>';
725
726 print '
727 var duplicatedbatchcode = [];
728 var errortab1 = [];
729 var errortab2 = [];
730 var errortab3 = [];
731 var errortab4 = [];
732
733 function barcodescannerjs(){
734 console.log("We catch inputs in scanner box");
735 jQuery("#scantoolmessage").text();
736
737 var selectaddorreplace = $("select[name=selectaddorreplace]").val();
738 var barcodemode = $("input[name=barcodemode]:checked").val();
739 var barcodeproductqty = $("input[name=barcodeproductqty]").val();
740 var textarea = $("textarea[name=barcodelist]").val();
741 var textarray = textarea.split(/[\s,;]+/);
742 var tabproduct = [];
743 duplicatedbatchcode = [];
744 errortab1 = [];
745 errortab2 = [];
746 errortab3 = [];
747 errortab4 = [];
748
749 textarray = textarray.filter(function(value){
750 return value != "";
751 });
752 if(textarray.some((element) => element != "")){
753 $(".expectedqty").each(function(){
754 id = this.id;
755 console.log("Analyze the line "+id+" in inventory, barcodemode="+barcodemode);
756 warehouse = $("#"+id+"_warehouse").attr(\'data-ref\');
757 //console.log(warehouse);
758 productbarcode = $("#"+id+"_product").attr(\'data-barcode\');
759 //console.log(productbarcode);
760 productbatchcode = $("#"+id+"_batch").attr(\'data-batch\');
761 //console.log(productbatchcode);
762
763 if (barcodemode != "barcodeforproduct") {
764 tabproduct.forEach(product=>{
765 console.log("product.Batch="+product.Batch+" productbatchcode="+productbatchcode);
766 if(product.Batch != "" && product.Batch == productbatchcode){
767 console.log("duplicate batch code found for batch code "+productbatchcode);
768 duplicatedbatchcode.push(productbatchcode);
769 }
770 })
771 }
772 productinput = $("#"+id+"_input").val();
773 if(productinput == ""){
774 productinput = 0
775 }
776 tabproduct.push({\'Id\':id,\'Warehouse\':warehouse,\'Barcode\':productbarcode,\'Batch\':productbatchcode,\'Qty\':productinput,\'fetched\':false});
777 });
778
779 console.log("Loop on each record entered in the textarea");
780 textarray.forEach(function(element,index){
781 console.log("Process record element="+element+" id="+id);
782 var verify_batch = false;
783 var verify_barcode = false;
784 switch(barcodemode){
785 case "barcodeforautodetect":
786 verify_barcode = barcodeserialforproduct(tabproduct,index,element,barcodeproductqty,selectaddorreplace,"barcode",true);
787 verify_batch = barcodeserialforproduct(tabproduct,index,element,barcodeproductqty,selectaddorreplace,"lotserial",true);
788 break;
789 case "barcodeforproduct":
790 verify_barcode = barcodeserialforproduct(tabproduct,index,element,barcodeproductqty,selectaddorreplace,"barcode");
791 break;
792 case "barcodeforlotserial":
793 verify_batch = barcodeserialforproduct(tabproduct,index,element,barcodeproductqty,selectaddorreplace,"lotserial");
794 break;
795 default:
796 alert(\''.dol_escape_js($langs->trans("ErrorWrongBarcodemode")).' "\'+barcodemode+\'"\');
797 throw \''.dol_escape_js($langs->trans('ErrorWrongBarcodemode')).' "\'+barcodemode+\'"\';
798 }
799
800 if (verify_batch == false && verify_barcode == false) { /* If the 2 flags are false, not found error */
801 errortab2.push(element);
802 } else if (verify_batch == true && verify_barcode == true) { /* If the 2 flags are true, error: we don t know which one to take */
803 errortab3.push(element);
804 } else if (verify_batch == true) {
805 console.log("element="+element);
806 console.log(duplicatedbatchcode);
807 if (duplicatedbatchcode.includes(element)) {
808 errortab1.push(element);
809 }
810 }
811 });
812
813 if (Object.keys(errortab1).length < 1 && Object.keys(errortab2).length < 1 && Object.keys(errortab3).length < 1) {
814 tabproduct.forEach(product => {
815 if(product.Qty!=0){
816 console.log("We change #"+product.Id+"_input to match input in scanner box");
817 if(product.hasOwnProperty("reelqty")){
818 $.ajax({ url: \''.DOL_URL_ROOT.'/product/inventory/ajax/searchfrombarcode.php\',
819 data: { "token":"'.newToken().'", "action":"addnewlineproduct", "fk_entrepot":product.Warehouse, "batch":product.Batch, "fk_inventory":'.dol_escape_js((string) $object->id).', "fk_product":product.fk_product, "reelqty":product.reelqty},
820 type: \'POST\',
821 async: false,
822 success: function(response) {
823 if (typeof response == "object") {
824 console.log("response is already type object, no need to parse it");
825 } else {
826 console.log("response is type "+(typeof response));
827 response = JSON.parse(response);
828 }
829 if(response.status == "success"){
830 console.log(response.message);
831 $("<input type=\'text\' value=\'"+product.Qty+"\' />")
832 .attr("id", "id_"+response.id_line+"_input")
833 .attr("name", "id_"+response.id_line)
834 .appendTo("#formrecord");
835 }else{
836 console.error(response.message);
837 }
838 },
839 error : function(output) {
840 console.error("Error on line creation function");
841 },
842 });
843 } else {
844 $("#"+product.Id+"_input").val(product.Qty);
845 }
846 }
847 });
848 jQuery("#scantoolmessage").text("'.dol_escape_js($langs->transnoentities("QtyWasAddedToTheScannedBarcode")).'\n");
849 /* document.forms["formrecord"].submit(); */
850 } else {
851 let stringerror = "";
852 if (Object.keys(errortab1).length > 0) {
853 stringerror += "<br>'.dol_escape_js($langs->transnoentities('ErrorSameBatchNumber')).': ";
854 errortab1.forEach(element => {
855 stringerror += (element + ", ")
856 });
857 stringerror = stringerror.slice(0, -2); /* Remove last ", " */
858 }
859 if (Object.keys(errortab2).length > 0) {
860 stringerror += "<br>'.dol_escape_js($langs->transnoentities('ErrorCantFindCodeInInventory')).': ";
861 errortab2.forEach(element => {
862 stringerror += (element + ", ")
863 });
864 stringerror = stringerror.slice(0, -2); /* Remove last ", " */
865 }
866 if (Object.keys(errortab3).length > 0) {
867 stringerror += "<br>'.dol_escape_js($langs->transnoentities('ErrorCodeScannedIsBothProductAndSerial')).': ";
868 errortab3.forEach(element => {
869 stringerror += (element + ", ")
870 });
871 stringerror = stringerror.slice(0, -2); /* Remove last ", " */
872 }
873 if (Object.keys(errortab4).length > 0) {
874 stringerror += "<br>'.dol_escape_js($langs->transnoentities('ErrorBarcodeNotFoundForProductWarehouse')).': ";
875 errortab4.forEach(element => {
876 stringerror += (element + ", ")
877 });
878 stringerror = stringerror.slice(0, -2); /* Remove last ", " */
879 }
880
881 jQuery("#scantoolmessage").html(\''.dol_escape_js($langs->transnoentities("ErrorOnElementsInventory")).'\' + stringerror);
882 //alert("'.dol_escape_js($langs->trans("ErrorOnElementsInventory")).' :\n" + stringerror);
883 }
884 }
885
886 }
887
888 /* This methode is called by parent barcodescannerjs() */
889 function barcodeserialforproduct(tabproduct,index,element,barcodeproductqty,selectaddorreplace,mode,autodetect=false){
890 BarcodeIsInProduct=0;
891 newproductrow=0
892 result=false;
893 tabproduct.forEach(product => {
894 $.ajax({ url: \''.DOL_URL_ROOT.'/product/inventory/ajax/searchfrombarcode.php\',
895 data: { "token":"'.newToken().'", "action":"existbarcode", '.(!empty($object->fk_warehouse) ? '"fk_entrepot":'.$object->fk_warehouse.', ' : '').(!empty($object->fk_product) ? '"fk_product":'.$object->fk_product.', ' : '').'"barcode":element, "product":product, "mode":mode},
896 type: \'POST\',
897 async: false,
898 success: function(response) {
899 if (typeof response == "object") {
900 console.log("response is already type object, no need to parse it");
901 } else {
902 console.log("response is type "+(typeof response));
903 response = JSON.parse(response);
904 }
905 if (response.status == "success"){
906 console.log(response.message);
907 if(!newproductrow){
908 newproductrow = response.object;
909 }
910 }else{
911 if (mode!="lotserial" && autodetect==false && !errortab4.includes(element)){
912 errortab4.push(element);
913 console.error(response.message);
914 }
915 }
916 },
917 error : function(output) {
918 console.error("Error on barcodeserialforproduct function");
919 },
920 });
921 console.log("Product "+(index+=1)+": "+element);
922 if(mode == "barcode"){
923 testonproduct = product.Barcode
924 }else if (mode == "lotserial"){
925 testonproduct = product.Batch
926 }
927 if(testonproduct == element){
928 if(selectaddorreplace == "add"){
929 productqty = parseInt(product.Qty,10);
930 product.Qty = productqty + parseInt(barcodeproductqty,10);
931 }else if(selectaddorreplace == "replace"){
932 if(product.fetched == false){
933 product.Qty = barcodeproductqty
934 product.fetched=true
935 }else{
936 productqty = parseInt(product.Qty,10);
937 product.Qty = productqty + parseInt(barcodeproductqty,10);
938 }
939 }
940 BarcodeIsInProduct+=1;
941 }
942 })
943 if(BarcodeIsInProduct==0 && newproductrow!=0){
944 tabproduct.push({\'Id\':tabproduct.length-1,\'Warehouse\':newproductrow.fk_warehouse,\'Barcode\':mode=="barcode"?element:null,\'Batch\':mode=="lotserial"?element:null,\'Qty\':barcodeproductqty,\'fetched\':true,\'reelqty\':newproductrow.reelqty,\'fk_product\':newproductrow.fk_product,\'mode\':mode});
945 result = true;
946 }
947 if(BarcodeIsInProduct > 0){
948 result = true;
949 }
950 return result;
951 }
952 ';
953 print '</script>';
954 }
955 include DOL_DOCUMENT_ROOT.'/core/class/html.formother.class.php';
956 $formother = new FormOther($db);
957 print $formother->getHTMLScannerForm("barcodescannerjs", 'all');
958}
959
960//Call method to undo changes in real qty
961print '<script>';
962print 'jQuery(document).ready(function() {
963 $("#clearqty").on("click", function() {
964 console.log("Clear all values");
965 /* disablebuttonmakemovementandclose(); */
966 jQuery(".realqty").val("");
967 jQuery(".realqty").trigger("change");
968 return false; /* disable submit */
969 });
970 $(".undochangesqty").on("click", function undochangesqty() {
971 console.log("Clear value of inventory line");
972 id = this.id;
973 id = id.split("_")[1];
974 tmpvalue = $("#id_"+id+"_input_tmp").val()
975 $("#id_"+id+"_input")[0].value = tmpvalue;
976 /* disablebuttonmakemovementandclose(); */
977 return false; /* disable submit */
978 });
979});';
980print '</script>';
981
982print '<div class="fichecenter">';
983//print '<div class="fichehalfleft">';
984print '<div class="clearboth"></div>';
985
986//print load_fiche_titre($langs->trans('Consumption'), '', '');
987
988print '<div class="div-table-responsive-no-min">';
989print '<table id="tablelines" class="noborder noshadow centpercent">';
990
991print '<tr class="liste_titre">';
992print getTitleFieldOfList($langs->trans("Warehouse"), 0, $_SERVER['PHP_SELF'], 'e.ref', '', 'id=' . $object->id . '&page=' . $page . $param, '', $sortfield, $sortorder, '', 0, '') . "\n";
993print getTitleFieldOfList($langs->trans("Product"), 0, $_SERVER['PHP_SELF'], 'p.ref', '', 'id=' . $object->id . '&page=' . $page . $param, '', $sortfield, $sortorder, '', 0, '') . "\n";
994if (isModEnabled('productbatch')) {
995 print '<td>';
996 print $langs->trans("Batch");
997 print '</td>';
998}
999if ($object->status == $object::STATUS_DRAFT || $object->status == $object::STATUS_VALIDATED) {
1000 // Expected quantity = If inventory is open: Quantity currently in stock (may change if stock movement are done during the inventory)
1001 print '<td class="right">'.$form->textwithpicto($langs->trans("ExpectedQty"), $langs->trans("QtyCurrentlyKnownInStock")).'</td>';
1002} else {
1003 // Expected quantity = If inventory is closed: Quantity we had in stock when we start the inventory.
1004 print '<td class="right">'.$form->textwithpicto($langs->trans("ExpectedQty"), $langs->trans("QtyInStockWhenInventoryWasValidated")).'</td>';
1005}
1006if (getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
1007 print '<td class="right">'.$langs->trans('PMPExpected').'</td>';
1008 print '<td class="right">'.$langs->trans('ExpectedValuation').'</td>';
1009 print '<td class="right">'.$form->textwithpicto($langs->trans("RealQty"), $langs->trans("InventoryRealQtyHelp")).'</td>';
1010 print '<td class="right">'.$langs->trans('PMPReal').'</td>';
1011 print '<td class="right">'.$langs->trans('RealValuation').'</td>';
1012} else {
1013 print '<td class="right">';
1014 print $form->textwithpicto($langs->trans("RealQty"), $langs->trans("InventoryRealQtyHelp"));
1015 print '</td>';
1016}
1017if ($object->status == $object::STATUS_DRAFT || $object->status == $object::STATUS_VALIDATED) {
1018 // Actions or link to stock movement
1019 print '<td class="center">';
1020 print '</td>';
1021} else {
1022 // Actions or link to stock movement
1023 print '<td class="right">';
1024 //print $langs->trans("StockMovement");
1025 print '</td>';
1026}
1027print '</tr>';
1028
1029// Line to add a new line in inventory
1030if ($object->status == $object::STATUS_DRAFT || $object->status == $object::STATUS_VALIDATED) {
1031 print '<tr>';
1032 print '<td>';
1033 print $formproduct->selectWarehouses((GETPOSTISSET('fk_warehouse') ? GETPOSTINT('fk_warehouse') : $object->fk_warehouse), 'fk_warehouse', 'warehouseopen', 1, 0, 0, '', 0, 0, array(), 'maxwidth300');
1034 print '</td>';
1035 print '<td>';
1036 if (getDolGlobalString('STOCK_SUPPORTS_SERVICES')) {
1037 $filtertype = '';
1038 } else {
1039 $filtertype = 0;
1040 }
1041 print $form->select_produits((GETPOSTISSET('fk_product') ? GETPOSTINT('fk_product') : $object->fk_product), 'fk_product', $filtertype, 0, 0, -1, 2, '', 0, array(), 0, '1', 0, 'maxwidth300');
1042 print '</td>';
1043 if (isModEnabled('productbatch')) {
1044 print '<td>';
1045 print '<input type="text" name="batch" class="maxwidth100" value="'.(GETPOSTISSET('batch') ? GETPOST('batch') : '').'">';
1046 print '</td>';
1047 }
1048 print '<td class="right"></td>';
1049 if (getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
1050 print '<td class="right">';
1051 print '</td>';
1052 print '<td class="right">';
1053 print '</td>';
1054 print '<td class="right">';
1055 print '<input type="text" name="qtytoadd" class="maxwidth75" value="">';
1056 print '</td>';
1057 print '<td class="right">';
1058 print '</td>';
1059 print '<td class="right">';
1060 print '</td>';
1061 } else {
1062 print '<td class="right">';
1063 print '<input type="text" name="qtytoadd" class="maxwidth75" value="">';
1064 print '</td>';
1065 }
1066 // Actions
1067 print '<td class="center">';
1068 if ($permissiontoupdatestock) {
1069 print '<input type="submit" class="button paddingright" name="addline" value="'.$langs->trans("Add").'">';
1070 } else {
1071 print '<input type="submit" class="button paddingright" disabled="disabled" title="'.dol_escape_htmltag($langs->trans("NotEnoughPermissions")).'" name="addline" value="'.$langs->trans("Add").'">';
1072 }
1073 print '</td>';
1074 print '</tr>';
1075}
1076
1077// Request to show lines of inventory (prefilled after start/validate step)
1078$sql = 'SELECT id.rowid, id.datec as date_creation, id.tms as date_modification, id.fk_inventory, id.fk_warehouse,';
1079$sql .= ' id.fk_product, id.batch, id.qty_stock, id.qty_view, id.qty_regulated, id.fk_movement, id.pmp_real, id.pmp_expected';
1080$sql .= ' FROM ' . $db->prefix() . 'inventorydet as id';
1081$sql .= ' LEFT JOIN ' . $db->prefix() . 'product as p ON id.fk_product = p.rowid';
1082$sql .= ' LEFT JOIN ' . $db->prefix() . 'entrepot as e ON id.fk_warehouse = e.rowid';
1083$sql .= ' WHERE id.fk_inventory = ' . ((int) $object->id);
1084$sql .= $db->order($sortfieldforsql, $sortorderforsql);
1085$sql .= $db->plimit($limit, $offset);
1086
1087$cacheOfProducts = array();
1088$cacheOfWarehouses = array();
1089
1090//$sql = '';
1091$resql = $db->query($sql);
1092if ($resql) {
1093 $num = $db->num_rows($resql);
1094
1095 if (!empty($limit != 0) || $num > $limit || $page) {
1096 print_fleche_navigation($page, $_SERVER["PHP_SELF"], '&id='.$object->id.$paramwithsearch, ($num >= $limit ? 1 : 0), '<li class="pagination"><span>' . $langs->trans("Page") . ' ' . ($page + 1) . '</span></li>', '', $limit);
1097 }
1098
1099 $i = 0;
1100 $hasinput = false;
1101 $totalarray = array();
1102 while ($i < $num) {
1103 $obj = $db->fetch_object($resql);
1104
1105 if (isset($cacheOfWarehouses[$obj->fk_warehouse])) {
1106 $warehouse_static = $cacheOfWarehouses[$obj->fk_warehouse];
1107 } else {
1108 $warehouse_static = new Entrepot($db);
1109 $warehouse_static->fetch($obj->fk_warehouse);
1110
1111 $cacheOfWarehouses[$warehouse_static->id] = $warehouse_static;
1112 }
1113
1114 // Load real stock we have now
1115 $option = '';
1116 if (isset($cacheOfProducts[$obj->fk_product])) {
1117 $product_static = $cacheOfProducts[$obj->fk_product];
1118 } else {
1119 $product_static = new Product($db);
1120 $result = $product_static->fetch($obj->fk_product, '', '', '', 1, 1, 1);
1121
1122 //$option = 'nobatch';
1123 $option .= ',novirtual';
1124 $product_static->load_stock($option); // Load stock_reel + stock_warehouse.
1125
1126 $cacheOfProducts[$product_static->id] = $product_static;
1127 }
1128
1129 print '<tr class="oddeven">';
1130 print '<td id="id_'.$obj->rowid.'_warehouse" data-ref="'.dol_escape_htmltag($warehouse_static->ref).'">';
1131 print $warehouse_static->getNomUrl(1);
1132 print '</td>';
1133 print '<td id="id_'.$obj->rowid.'_product" data-ref="'.dol_escape_htmltag($product_static->ref).'" data-barcode="'.dol_escape_htmltag($product_static->barcode).'">';
1134 print $product_static->getNomUrl(1).' - '.$product_static->label;
1135 print '</td>';
1136
1137 if (isModEnabled('productbatch')) {
1138 print '<td id="id_'.$obj->rowid.'_batch" data-batch="'.dol_escape_htmltag($obj->batch).'">';
1139 $batch_static = new Productlot($db);
1140 // @phan-suppress-next-line PhanPluginSuspiciousParamPosition
1141 $res = $batch_static->fetch(0, $product_static->id, $obj->batch);
1142 if ($res) {
1143 print $batch_static->getNomUrl(1);
1144 } else {
1145 print dol_escape_htmltag($obj->batch);
1146 }
1147 print '</td>';
1148 }
1149
1150 // Expected quantity = If inventory is open: Quantity currently in stock (may change if stock movement are done during the inventory)
1151 // Expected quantity = If inventory is closed: Quantity we had in stock when we start the inventory.
1152 print '<td class="right expectedqty" id="id_'.$obj->rowid.'" title="Stock viewed at last update: '.$obj->qty_stock.'">';
1153 $valuetoshow = $obj->qty_stock;
1154 // For inventory not yet close, we overwrite with the real value in stock now
1155 if ($object->status == $object::STATUS_DRAFT || $object->status == $object::STATUS_VALIDATED) {
1156 if (isModEnabled('productbatch') && $product_static->hasbatch()) {
1157 $valuetoshow = $product_static->stock_warehouse[$obj->fk_warehouse]->detail_batch[$obj->batch]->qty ?? 0;
1158 } else {
1159 $valuetoshow = !empty($product_static->stock_warehouse[$obj->fk_warehouse]->real) ? $product_static->stock_warehouse[$obj->fk_warehouse]->real : 0;
1160 }
1161 }
1162 print price2num($valuetoshow, 'MS');
1163 print '<input type="hidden" name="stock_qty_'.$obj->rowid.'" value="'.$valuetoshow.'">';
1164 print '</td>';
1165
1166 // Real quantity
1167 if ($object->status == $object::STATUS_DRAFT || $object->status == $object::STATUS_VALIDATED) {
1168 $qty_view = GETPOST("id_".$obj->rowid) && price2num(GETPOST("id_".$obj->rowid), 'MS') >= 0 ? GETPOST("id_".$obj->rowid) : $obj->qty_view;
1169
1170 //if (!$hasinput && $qty_view !== null && $obj->qty_stock != $qty_view) {
1171 if ($qty_view != '') {
1172 $hasinput = true;
1173 }
1174
1175 if (getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
1176 //PMP Expected
1177 if (!empty($obj->pmp_expected)) {
1178 $pmp_expected = $obj->pmp_expected;
1179 } else {
1180 $pmp_expected = $product_static->pmp;
1181 }
1182 $pmp_valuation = $pmp_expected * $valuetoshow;
1183 print '<td class="right">';
1184 print is_null($pmp_expected) ? '' : price($pmp_expected);
1185 print '<input type="hidden" name="expectedpmp_'.$obj->rowid.'" value="'.$pmp_expected.'"/>';
1186 print '</td>';
1187 print '<td class="right">';
1188 print price($pmp_valuation);
1189 print '</td>';
1190
1191 print '<td class="right">';
1192 print '<a id="undochangesqty_'.$obj->rowid.'" href="#" class="undochangesqty reposition marginrightonly" title="'.dol_escape_htmltag($langs->trans("Clear")).'">';
1193 print img_picto('', 'eraser', 'class="opacitymedium"');
1194 print '</a>';
1195 print '<input type="text" class="maxwidth50 right realqty" name="id_'.$obj->rowid.'" id="id_'.$obj->rowid.'_input" value="'.$qty_view.'">';
1196 print '</td>';
1197
1198 //PMP Real
1199 print '<td class="right">';
1200 if (!empty($obj->pmp_real) || (string) $obj->pmp_real === '0') {
1201 $pmp_real = $obj->pmp_real;
1202 } else {
1203 $pmp_real = $product_static->pmp;
1204 }
1205 $pmp_valuation_real = $pmp_real * $qty_view;
1206 print '<input type="text" class="maxwidth75 right realpmp'.$obj->fk_product.'" name="realpmp_'.$obj->rowid.'" id="id_'.$obj->rowid.'_input_pmp" value="'.(is_null($pmp_real) ? '' : price2num($pmp_real)).'">';
1207 print '</td>';
1208 print '<td class="right">';
1209 print '<input type="text" class="maxwidth75 right realvaluation'.$obj->fk_product.'" name="realvaluation_'.$obj->rowid.'" id="id_'.$obj->rowid.'_input_real_valuation" value="'.$pmp_valuation_real.'">';
1210 print '</td>';
1211
1212 $totalExpectedValuation += $pmp_valuation;
1213 $totalRealValuation += $pmp_valuation_real;
1214 } else {
1215 print '<td class="right">';
1216 print '<a id="undochangesqty_'.$obj->rowid.'" href="#" class="undochangesqty reposition marginrightonly" title="'.dol_escape_htmltag($langs->trans("Clear")).'">';
1217 print img_picto('', 'eraser', 'class="opacitymedium"');
1218 print '</a>';
1219 print '<input type="text" class="maxwidth50 right realqty" name="id_'.$obj->rowid.'" id="id_'.$obj->rowid.'_input" value="'.$qty_view.'">';
1220 print '</td>';
1221 }
1222
1223 // Picto delete line
1224 print '<td class="right">';
1225 if ($permissiontoupdatestock) {
1226 print '<a class="reposition" href="'.DOL_URL_ROOT.'/product/inventory/inventory.php?id='.$object->id.'&lineid='.$obj->rowid.'&action=deleteline&page='.$page.$paramwithsearch.'&token='.newToken().'">'.img_delete().'</a>';
1227 }
1228 $qty_tmp = price2num(GETPOST("id_".$obj->rowid."_input_tmp"), 'MS') >= 0 ? GETPOST("id_".$obj->rowid."_input_tmp") : $qty_view;
1229 print '<input type="hidden" class="maxwidth50 right realqty" name="id_'.$obj->rowid.'_input_tmp" id="id_'.$obj->rowid.'_input_tmp" value="'.$qty_tmp.'">';
1230 print '</td>';
1231 } else {
1232 if (getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
1233 // PMP Expected
1234 if (!empty($obj->pmp_expected)) {
1235 $pmp_expected = $obj->pmp_expected;
1236 } else {
1237 $pmp_expected = $product_static->pmp;
1238 }
1239 $pmp_valuation = $pmp_expected * $valuetoshow;
1240 print '<td class="right">';
1241 print is_null($pmp_expected) ? '' : price($pmp_expected);
1242 print '</td>';
1243 print '<td class="right">';
1244 print price($pmp_valuation);
1245 print '</td>';
1246
1247 print '<td class="right nowraponall">';
1248 print $obj->qty_view; // qty found
1249 print '</td>';
1250
1251 // PMP Real
1252 print '<td class="right">';
1253 if (!empty($obj->pmp_real)) {
1254 $pmp_real = $obj->pmp_real;
1255 } else {
1256 $pmp_real = $product_static->pmp;
1257 }
1258 $pmp_valuation_real = $pmp_real * $obj->qty_view;
1259 print is_null($pmp_real) ? '' : price($pmp_real);
1260 print '</td>';
1261 print '<td class="right">';
1262 print price($pmp_valuation_real);
1263 print '</td>';
1264 print '<td class="nowraponall right">';
1265
1266 $totalExpectedValuation += $pmp_valuation;
1267 $totalRealValuation += $pmp_valuation_real;
1268 } else {
1269 print '<td class="right nowraponall">';
1270 print $obj->qty_view; // qty found
1271 print '</td>';
1272 }
1273 print '<td>';
1274 if ($obj->fk_movement > 0) {
1275 $stockmovment = new MouvementStock($db);
1276 $stockmovment->fetch($obj->fk_movement);
1277 print $stockmovment->getNomUrl(1, 'movements');
1278 }
1279 print '</td>';
1280 }
1281 print '</tr>';
1282
1283 $i++;
1284 }
1285} else {
1286 dol_print_error($db);
1287}
1288if (getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
1289 print '<tr class="liste_total">';
1290 print '<td colspan="4">'.$langs->trans("Total").'</td>';
1291 print '<td class="right" colspan="2">'.price($totalExpectedValuation).'</td>';
1292 print '<td class="right" id="totalRealValuation" colspan="3">'.price($totalRealValuation).'</td>';
1293 print '<td></td>';
1294 print '</tr>';
1295}
1296print '</table>';
1297
1298print '</div>';
1299
1300if ($object->status == $object::STATUS_VALIDATED) {
1301 print '<center><input id="submitrecord" type="submit" class="button button-save" name="save" value="'.$langs->trans("Save").'"></center>';
1302}
1303
1304print '</div>';
1305
1306
1307// Call method to disable the button if no qty entered yet for inventory
1308/*
1309if ($object->status != $object::STATUS_VALIDATED || !$hasinput) {
1310 print '<script type="text/javascript">
1311 jQuery(document).ready(function() {
1312 console.log("Call disablebuttonmakemovementandclose because status = '.((int) $object->status).' or $hasinput = '.((int) $hasinput).'");
1313 disablebuttonmakemovementandclose();
1314 });
1315 </script>';
1316}
1317*/
1318
1319print '</form>';
1320
1321print '<script type="text/javascript">
1322 $(document).ready(function() {
1323
1324 $(".paginationnext:last").click(function(e){
1325 var form = $("#formrecord");
1326 var actionURL = "'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&page='.($page).$paramwithsearch.'";
1327 $.ajax({
1328 url: actionURL,
1329 data: form.serialize(),
1330 cache: false,
1331 success: function(result){
1332 window.location.href = "'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&page='.($page + 1).$paramwithsearch.'";
1333 }});
1334 return false;
1335 });
1336
1337
1338 $(".paginationprevious:last").click(function(e){
1339 var form = $("#formrecord");
1340 var actionURL = "'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&page='.($page).$paramwithsearch.'";
1341 $.ajax({
1342 url: actionURL,
1343 data: form.serialize(),
1344 cache: false,
1345 success: function(result){
1346 window.location.href = "'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&page='.($page - 1).$paramwithsearch.'";
1347 }});
1348 return false;
1349 });
1350
1351 $("#idbuttonmakemovementandclose").click(function(e){
1352 var form = $("#formrecord");
1353 var actionURL = "'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&page='.($page).$paramwithsearch.'";
1354 $.ajax({
1355 url: actionURL,
1356 type: "POST",
1357 data: form.serialize(),
1358 cache: false,
1359 success: function(result){
1360 window.location.href = "'.$_SERVER['PHP_SELF'].'?id='.$object->id.'&page='.($page).$paramwithsearch.'&action=record";
1361 }});
1362 return false;
1363 });
1364 });
1365</script>';
1366
1367
1368if (getDolGlobalString('INVENTORY_MANAGE_REAL_PMP')) {
1369 ?>
1370<script type="text/javascript">
1371$('.realqty').on('change', function () {
1372 let realqty = $(this).closest('tr').find('.realqty').val();
1373 let inputPmp = $(this).closest('tr').find('input[class*=realpmp]');
1374 let realpmp = $(inputPmp).val();
1375 if (!isNaN(realqty) && !isNaN(realpmp)) {
1376 let realval = realqty * realpmp;
1377 $(this).closest('tr').find('input[name^=realvaluation]').val(realval.toFixed(2));
1378 }
1379 updateTotalValuation();
1380});
1381
1382$('input[class*=realpmp]').on('change', function () {
1383 let inputQtyReal = $(this).closest('tr').find('.realqty');
1384 let realqty = $(inputQtyReal).val();
1385 let inputPmp = $(this).closest('tr').find('input[class*=realpmp]');
1386 console.log(inputPmp);
1387 let realPmpClassname = $(inputPmp).attr('class').match(/[\w-]*realpmp[\w-]*/g)[0];
1388 let realpmp = $(inputPmp).val();
1389 if (!isNaN(realpmp)) {
1390 $('.'+realPmpClassname).val(realpmp); //For batch case if pmp is changed we change it everywhere it's same product and calc back everything
1391
1392 if (!isNaN(realqty)) {
1393 let realval = realqty * realpmp;
1394 $(this).closest('tr').find('input[name^=realvaluation]').val(realval.toFixed(2));
1395 }
1396 $('.realqty').trigger('change');
1397 updateTotalValuation();
1398 }
1399});
1400
1401$('input[name^=realvaluation]').on('change', function () {
1402 let inputQtyReal = $(this).closest('tr').find('.realqty');
1403 let realqty = $(inputQtyReal).val();
1404 let inputPmp = $(this).closest('tr').find('input[class*=realpmp]');
1405 let inputRealValuation = $(this).closest('tr').find('input[name^=realvaluation]');
1406 let realPmpClassname = $(inputPmp).attr('class').match(/[\w-]*realpmp[\w-]*/g)[0];
1407 let realvaluation = $(inputRealValuation).val();
1408 if (!isNaN(realvaluation) && !isNaN(realqty) && realvaluation !== '' && realqty !== '' && realqty !== 0) {
1409 let realpmp = realvaluation / realqty
1410 $('.'+realPmpClassname).val(realpmp); //For batch case if pmp is changed we change it everywhere it's same product and calc back everything
1411 $('.realqty').trigger('change');
1412 updateTotalValuation();
1413 }
1414});
1415
1416function updateTotalValuation() {
1417 let total = 0;
1418 $('input[name^=realvaluation]').each(function( index ) {
1419 let val = $(this).val();
1420 if(!isNaN(val)) total += parseFloat($(this).val());
1421 });
1422 let currencyFractionDigits = new Intl.NumberFormat('fr-FR', {
1423 style: 'currency',
1424 currency: 'EUR',
1425 }).resolvedOptions().maximumFractionDigits;
1426 $('#totalRealValuation').html(total.toLocaleString('fr-FR', {
1427 maximumFractionDigits: currencyFractionDigits
1428 }));
1429}
1430
1431
1432</script>
1433 <?php
1434}
1435
1436// End of page
1437llxFooter();
1438$db->close();
$id
Support class for third parties, contacts, members, users or resources.
Definition account.php:48
if( $user->socid > 0) if(! $user->hasRight('accounting', 'chartofaccount')) $object
Definition card.php:67
$totalarray
Definition export.php:1206
llxFooter($comment='', $zone='private', $disabledoutputofmessages=0)
Empty footer.
Definition wrapper.php:91
if(!defined('NOREQUIRESOC')) if(!defined( 'NOREQUIRETRAN')) if(!defined('NOTOKENRENEWAL')) if(!defined( 'NOREQUIREMENU')) if(!defined('NOREQUIREHTML')) if(!defined( 'NOREQUIREAJAX')) llxHeader($head='', $title='', $help_url='', $target='', $disablejs=0, $disablehead=0, $arrayofjs='', $arrayofcss='', $morequerystring='', $morecssonbody='', $replacemainareaby='', $disablenofollow=0, $disablenoindex=0)
Empty header.
Definition wrapper.php:73
Class to manage warehouses.
Class to manage standard extra fields.
Class to manage generation of HTML components Only common components must be here.
Class permettant la generation de composants html autre Only common components are here.
Class with static methods for building HTML components related to products Only components common to ...
Class for Inventory.
Class InventoryLine.
Class to manage stock movements.
Class to manage products or services.
Class with list of lots and properties.
setEventMessages($mesg, $mesgs, $style='mesgs', $messagekey='', $noduplicate=0, $attop=0)
Set event messages in dol_events session object.
dol_strtolower($string, $encoding="UTF-8")
Convert a string to lower.
img_picto($titlealt, $picto, $moreatt='', $pictoisfullpath=0, $srconly=0, $notitle=0, $alt='', $morecss='', $marginleftonlyshort=2, $allowothertags=array())
Show picto whatever it's its name (generic function)
img_delete($titlealt='default', $other='class="pictodelete"', $morecss='')
Show delete logo.
GETPOSTINT($paramname, $method=0)
Return the value of a $_GET or $_POST supervariable, converted into integer.
dol_get_fiche_head($links=array(), $active='', $title='', $notab=0, $picto='', $pictoisfullpath=0, $morehtmlright='', $morecss='', $limittoshow=0, $moretabssuffix='', $dragdropfile=0, $morecssdiv='')
Show tabs of a record.
price2num($amount, $rounding='', $option=0)
Function that return a number with universal decimal format (decimal separator is '.
currentToken()
Return the value of token currently saved into session with name 'token'.
dol_get_fiche_end($notab=0)
Return tab footer of a card.
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_escape_js($stringtoescape, $mode=0, $noescapebackslashn=0)
Returns text escaped for inclusion into javascript code.
newToken()
Return the value of token currently saved into session with name 'newtoken'.
getTitleFieldOfList($name, $thead=0, $file="", $field="", $begin="", $moreparam="", $moreattrib="", $sortfield="", $sortorder="", $prefix="", $disablesortlink=0, $tooltip='', $forcenowrapcolumntitle=0)
Get title line of an array.
GETPOST($paramname, $check='alphanohtml', $method=0, $filter=null, $options=null, $noreplace=0)
Return value of a param into GET or POST supervariable.
dol_print_error($db=null, $error='', $errors=null)
Displays error message system with all the information to facilitate the diagnosis and the escalation...
print_fleche_navigation($page, $file, $options='', $nextpage=0, $betweenarrows='', $afterarrows='', $limit=-1, $totalnboflines=0, $selectlimitsuffix='', $beforearrows='', $hidenavigation=0)
Function to show navigation arrows into lists.
getDolGlobalString($key, $default='')
Return a Dolibarr global constant string value.
dol_escape_htmltag($stringtoescape, $keepb=0, $keepn=0, $noescapetags='', $escapeonlyhtmltags=0, $cleanalsojavascript=0)
Returns text escaped for inclusion in HTML alt or title or value tags, or into values of HTML input f...
inventoryPrepareHead(&$inventory, $title='Inventory', $get='')
Define head array for tabs of inventory tools setup pages.
global $conf
The following vars must be defined: $type2label $form $conf, $lang, The following vars may also be de...
Definition member.php:79
if(preg_match('/(crypted|dolcrypt):/i', $dolibarr_main_db_pass)||!empty($dolibarr_main_db_encrypted_pass)) $conf db type
Definition repair.php:158
restrictedArea(User $user, $features, $object=0, $tableandshare='', $feature2='', $dbt_keyfield='fk_soc', $dbt_select='rowid', $isdraft=0, $mode=0)
Check permissions of a user to show a page and an object.