27 require
'../../main.inc.php';
28 require_once DOL_DOCUMENT_ROOT.
'/core/lib/product.lib.php';
29 require_once DOL_DOCUMENT_ROOT.
'/bom/class/bom.class.php';
30 require_once DOL_DOCUMENT_ROOT.
'/product/class/product.class.php';
33 $langs->loadLangs(array(
'mrp',
'products',
'companies'));
39 $fieldvalue = (!empty($id) ? $id : (!empty($ref) ? $ref :
''));
40 $fieldtype = (!empty($ref) ?
'ref' :
'rowid');
42 $socid = $user->socid;
46 $hookmanager->initHooks(array(
'productstatsbom'));
52 $limit =
GETPOST(
'limit',
'int') ?
GETPOST(
'limit',
'int') : $conf->liste_limit;
53 $sortfield =
GETPOST(
'sortfield',
'aZ09comma');
54 $sortorder =
GETPOST(
'sortorder',
'aZ09comma');
56 if (empty($page) || $page == -1) {
59 $offset = $limit * $page;
60 $pageprev = $page - 1;
61 $pagenext = $page + 1;
66 $sortfield =
"b.date_valid";
69 $result =
restrictedArea($user,
'produit|service', $fieldvalue,
'product&product',
'',
'', $fieldtype);
78 if ($id > 0 || !empty($ref)) {
80 $result = $product->fetch($id, $ref);
84 $parameters = array(
'id'=>$id);
85 $reshook = $hookmanager->executeHooks(
'doActions', $parameters, $product, $action);
90 llxHeader(
"",
"", $langs->trans(
"CardProduct".$product->type));
94 $titre = $langs->trans(
"CardProduct".$product->type);
98 $reshook = $hookmanager->executeHooks(
'formObjectOptions', $parameters, $product, $action);
99 print $hookmanager->resPrint;
104 $linkback =
'<a href="'.DOL_URL_ROOT.
'/product/list.php?restore_lastsearch_values=1">'.$langs->trans(
"BackToList").
'</a>';
107 if ($user->socid && !in_array(
'product', explode(
',', $conf->global->MAIN_MODULES_FOR_EXTERNAL))) {
113 print
'<div class="fichecenter">';
115 print
'<div class="underbanner clearboth"></div>';
116 print
'<table class="border tableforfield" width="100%">';
123 print
'<div style="clear:both"></div>';
130 $total_qty_toconsume = 0;
131 $total_qty_toproduce = 0;
132 $product_cache=array();
133 $bom_data_result = array();
136 $sql =
"SELECT b.rowid as rowid, b.ref, b.status, b.date_valid, b.fk_product,";
137 $sql .=
" b.qty as qty_toproduce";
138 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bom_bom as b";
140 $sql .=
" b.entity IN (".getEntity(
'bom').
")";
141 $sql .=
" AND b.fk_product = ".((int) $product->id);
142 $sql .= $db->order($sortfield, $sortorder);
145 $totalofrecords =
'';
146 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
147 $result = $db->query($sql);
149 $totalofrecords = $db->num_rows($result);
150 while ($objp = $db->fetch_object($result)) {
151 $total_qty_toproduce += $objp->qty_toproduce;
157 $sql .= $db->plimit($limit + 1, $offset);
159 $result = $db->query($sql);
161 $bomtmp =
new BOM($db);
162 $num = $db->num_rows($result);
165 while ($i < min($num, $limit)) {
166 $objp = $db->fetch_object($result);
167 $bomtmp->id = $objp->rowid;
168 $bomtmp->ref = $objp->ref;
170 if (!empty($objp->fk_product)) {
171 if (!array_key_exists($product->id, $product_cache)) {
172 $resultFetch = $product->fetch($objp->fk_product);
173 if ($resultFetch < 0) {
176 $product_cache[$product->id] = $product;
180 $bomtmp->fk_product = $objp->fk_product;
181 $bom_data_result[$objp->rowid][
'link'] = $bomtmp->getNomUrl(1,
'production');
182 $bom_data_result[$objp->rowid][
'product'] = (array_key_exists($objp->fk_product, $product_cache)? $product_cache[$objp->fk_product]->getNomUrl(1):
'');
183 $bom_data_result[$objp->rowid][
'qty_toproduce'] += ($objp->qty_toproduce > 0 ? $objp->qty_toproduce : 0);
184 $bom_data_result[$objp->rowid][
'qty_toconsume'] = 0;
185 $bom_data_result[$objp->rowid][
'date_valid'] =
dol_print_date($db->jdate($objp->date_valid),
'dayhour');
186 $bom_data_result[$objp->rowid][
'status'] = $bomtmp->LibStatut($objp->status, 5);
196 $sql =
"SELECT b.rowid as rowid, b.ref, b.status, b.date_valid, b.fk_product,";
197 $sql .=
" SUM(bl.qty) as qty_toconsume";
198 $sql .=
" FROM ".MAIN_DB_PREFIX.
"bom_bom as b";
199 $sql .=
" INNER JOIN ".MAIN_DB_PREFIX.
"bom_bomline as bl ON bl.fk_bom=b.rowid";
200 $sql .=
" WHERE b.entity IN (".getEntity(
'bom').
")";
201 $sql .=
" AND bl.fk_product = ".((int) $product->id);
202 $sql .=
" GROUP BY b.rowid, b.ref, b.status, b.date_valid, b.fk_product";
203 $sql .= $db->order($sortfield, $sortorder);
206 $totalofrecords =
'';
207 if (empty($conf->global->MAIN_DISABLE_FULL_SCANLIST)) {
208 $result = $db->query($sql);
210 $totalofrecords = $db->num_rows($result);
211 while ($objp = $db->fetch_object($result)) {
212 $total_qty_toconsume += $objp->qty_toconsume;
218 $sql .= $db->plimit($limit + 1, $offset);
220 $result = $db->query($sql);
222 $bomtmp =
new BOM($db);
223 $num = $db->num_rows($result);
226 while ($i < min($num, $limit)) {
227 $objp = $db->fetch_object($result);
228 $bomtmp->id = $objp->rowid;
229 $bomtmp->ref = $objp->ref;
231 if (!empty($objp->fk_product)) {
232 if (!array_key_exists($product->id, $product_cache)) {
233 $resultFetch = $product->fetch($objp->fk_product);
234 if ($resultFetch < 0) {
237 $product_cache[$product->id] = $product;
241 $bomtmp->fk_product = $objp->fk_product;
243 if (!array_key_exists($objp->rowid, $bom_data_result)) {
244 $bom_data_result[$objp->rowid][
'link'] = $bomtmp->getNomUrl(1,
'production');
245 $bom_data_result[$objp->rowid][
'product'] = (array_key_exists($objp->fk_product, $product_cache)? $product_cache[$objp->fk_product]->getNomUrl(1):
'');
246 $bom_data_result[$objp->rowid][
'qty_toproduce'] = 0;
247 $bom_data_result[$objp->rowid][
'qty_toconsume'] += ($objp->qty_toconsume > 0 ? $objp->qty_toconsume : 0);
248 $bom_data_result[$objp->rowid][
'date_valid'] =
dol_print_date($db->jdate($objp->date_valid),
'dayhour');
249 $bom_data_result[$objp->rowid][
'status'] = $bomtmp->LibStatut($objp->status, 5);
251 $bom_data_result[$objp->rowid][
'qty_toconsume'] += ($objp->qty_toconsume > 0 ? $objp->qty_toconsume : 0);
261 $option .=
'&id='.$product->id;
263 if ($limit > 0 && $limit != $conf->liste_limit) {
264 $option .=
'&limit='.urlencode($limit);
266 if (!empty($search_month)) {
267 $option .=
'&search_month='.urlencode($search_month);
269 if (!empty($search_year)) {
270 $option .=
'&search_year='.urlencode($search_year);
273 print
'<form method="post" action="'.$_SERVER[
'PHP_SELF'].
'?id='.$product->id.
'" name="search_form">'.
"\n";
274 print
'<input type="hidden" name="token" value="'.newToken().
'">';
275 if (!empty($sortfield)) {
276 print
'<input type="hidden" name="sortfield" value="'.$sortfield.
'"/>';
278 if (!empty($sortorder)) {
279 print
'<input type="hidden" name="sortorder" value="'.$sortorder.
'"/>';
282 print_barre_liste($langs->trans(
"BOMs"), $page, $_SERVER[
"PHP_SELF"], $option, $sortfield, $sortorder,
'', count($bom_data_result), count($bom_data_result),
'', 0,
'',
'', $limit, 0, 0, 1);
285 $option .=
'&page='.urlencode($page);
288 print
'<div class="div-table-responsive">';
289 print
'<table class="tagtable liste listwithfilterbefore centpercent">';
291 print
'<tr class="liste_titre">';
292 print_liste_field_titre(
"Ref", $_SERVER[
"PHP_SELF"],
"b.rowid",
"",
"&id=".$product->id,
'', $sortfield, $sortorder);
293 print_liste_field_titre(
"Product", $_SERVER[
"PHP_SELF"],
"b.fk_product",
"",
"&id=".$product->id,
'', $sortfield, $sortorder);
294 print_liste_field_titre(
"Date", $_SERVER[
"PHP_SELF"],
"b.date_valid",
"",
"&id=".$product->id,
'align="center"', $sortfield, $sortorder);
295 print_liste_field_titre(
"RowMaterial", $_SERVER[
"PHP_SELF"],
"",
"",
"&id=".$product->id,
'', $sortfield, $sortorder,
'center ');
296 print_liste_field_titre(
"Finished", $_SERVER[
"PHP_SELF"],
"",
"",
"&id=".$product->id,
'', $sortfield, $sortorder,
'center ');
297 print_liste_field_titre(
"Status", $_SERVER[
"PHP_SELF"],
"b.status",
"",
"&id=".$product->id,
'', $sortfield, $sortorder,
'right ');
300 if (!empty($bom_data_result)) {
301 foreach ($bom_data_result as $data) {
302 print
'<tr class="oddeven">';
307 print $data[
'product'];
309 print
"<td align=\"center\">";
310 print $data[
'date_valid'].
"</td>";
311 print
'<td class="center">'.$data[
'qty_toconsume'].
'</td>';
312 print
'<td class="center">'.$data[
'qty_toproduce'].
'</td>';
313 print
'<td class="right">'.$data[
'status'].
'</td>';