37 require_once DOL_DOCUMENT_ROOT.
'/workstation/class/workstation.class.php';
40 if (empty($object) || !is_object($object)) {
41 print
"Error, template page can't be called as URL";
46 if (empty($filtertype)) $filtertype = 0;
49 global $forceall, $senderissupplier, $inputalsopricewithtax, $outputalsopricetotalwithtax, $langs;
51 if (empty($dateSelector)) {
54 if (empty($forceall)) {
57 if (empty($senderissupplier)) {
58 $senderissupplier = 0;
60 if (empty($inputalsopricewithtax)) {
61 $inputalsopricewithtax = 0;
63 if (empty($outputalsopricetotalwithtax)) {
64 $outputalsopricetotalwithtax = 0;
68 if ($filtertype == 1) $domData =
' data-element="'.$line->element.
'service"';
69 else $domData =
' data-element="'.$line->element.
'"';
71 $domData .=
' data-id="'.$line->id.
'"';
72 $domData .=
' data-qty="'.$line->qty.
'"';
73 $domData .=
' data-product_type="'.$line->product_type.
'"';
76 $objectline =
new BOMLine($object->db);
79 print
"<!-- BEGIN PHP TEMPLATE objectline_view.tpl.php -->\n";
80 print
'<tr id="row-'.$line->id.
'" class="drag drop oddeven" '.$domData.
' >';
81 if (!empty($conf->global->MAIN_VIEW_LINE_NUMBER)) {
82 print
'<td class="linecolnum center">'.($i + 1).
'</td>';
85 print
'<td class="linecoldescription minwidth300imp">';
86 print
'<div id="line_'.$line->id.
'"></div>';
88 $tmpproduct =
new Product($object->db);
89 $tmpproduct->fetch($line->fk_product);
90 $tmpbom =
new BOM($object->db);
91 $res = $tmpbom->fetch($line->fk_bom_child);
92 if ($tmpbom->id > 0) {
93 print $tmpproduct->getNomUrl(1);
94 print
' '.$langs->trans(
"or").
' ';
95 print $tmpbom->getNomUrl(1);
96 print
' <a class="collapse_bom" id="collapse-'.$line->id.
'" href="#">';
97 print (empty($conf->global->BOM_SHOW_ALL_BOM_BY_DEFAULT) ?
img_picto(
'',
'folder') :
img_picto(
'',
'folder-open'));
100 print $tmpproduct->getNomUrl(1);
101 print
' - '.$tmpproduct->label;
105 if (!empty($extrafields)) {
106 $temps = $line->showOptionals($extrafields,
'view', array(),
'',
'', 1,
'line');
107 if (!empty($temps)) {
108 print
'<div style="padding-top: 10px" id="extrafield_lines_area_'.$line->id.
'" name="extrafield_lines_area_'.$line->id.
'">';
116 print
'<td class="linecolqty nowrap right">';
118 echo
price($line->qty, 0,
'', 0, 0);
121 if ($filtertype != 1) {
123 print
'<td class="linecoluseunit nowrap left">';
124 $label = $tmpproduct->getLabelOfUnit(
'long');
126 print $langs->trans($label);
131 print
'<td class="linecolqtyfrozen nowrap right">';
133 echo $line->qty_frozen ?
yn($line->qty_frozen) :
'';
135 print
'<td class="linecoldisablestockchange nowrap right">';
137 echo $line->disable_stock_change ?
yn($line->disable_stock_change) :
'';
140 print
'<td class="linecolefficiency nowrap right">';
142 echo $line->efficiency;
146 print
'<td class="linecolunit nowrap right">';
149 if (!empty($line->fk_unit)) {
150 require_once DOL_DOCUMENT_ROOT.
'/core/class/cunits.class.php';
152 $unit->fetch($line->fk_unit);
153 print (isset($unit->label) ?
" ".$langs->trans(ucwords($unit->label)).
" " :
'');
161 $res = $workstation->fetch($tmpproduct->fk_default_workstation);
163 print
'<td class="linecolunit nowrap right">';
165 if ($res > 0) echo $workstation->getNomUrl();
170 $tmpbom->calculateCosts();
171 print
'<td id="costline_'.$line->id.
'" class="linecolcost nowrap right">';
173 if (!empty($line->fk_bom_child)) {
174 echo
'<span class="amount">'.price($tmpbom->total_cost * $line->qty).
'</span>';
176 echo
'<span class="amount">'.price($line->total_cost).
'</span>';
180 if ($this->status == 0 && ($object_rights->write) && $action !=
'selectlines') {
181 print
'<td class="linecoledit center">';
183 if (($line->info_bits & 2) == 2 || !empty($disableedit)) {
185 print
'<a class="editfielda reposition" href="'.$_SERVER[
"PHP_SELF"].
'?id='.$this->
id.
'&action=editline&token='.
newToken().
'&lineid='.$line->id.
'">'.
img_edit().
'</a>';
189 print
'<td class="linecoldelete center">';
191 if (($line->fk_prev_id ==
null) && empty($disableremove)) {
193 print
'<a class="reposition" href="'.$_SERVER[
"PHP_SELF"].
'?id='.$this->
id.
'&action=deleteline&token='.
newToken().
'&lineid='.$line->id.
'">';
199 if ($num > 1 && $conf->browser->layout !=
'phone' && empty($disablemove)) {
200 print
'<td class="linecolmove tdlineupdown center">';
203 print
'<a class="lineupdown" href="'.$_SERVER[
"PHP_SELF"].
'?id='.$this->
id.
'&action=up&token='.
newToken().
'&rowid='.$line->id.
'">';
204 echo
img_up(
'default', 0,
'imgupforline');
208 print
'<a class="lineupdown" href="'.$_SERVER[
"PHP_SELF"].
'?id='.$this->
id.
'&action=down&token='.
newToken().
'&rowid='.$line->id.
'">';
209 echo
img_down(
'default', 0,
'imgdownforline');
214 print
'<td '.(($conf->browser->layout !=
'phone' && empty($disablemove)) ?
' class="linecolmove tdlineupdown center"' :
' class="linecolmove center"').
'></td>';
218 print
'<td colspan="3"></td>';
219 $coldisplay = $coldisplay + 3;
222 if ($action ==
'selectlines') {
223 print
'<td class="linecolcheck center">';
224 print
'<input type="checkbox" class="linecheckbox" name="line_checkbox['.($i + 1).
']" value="'.$line->id.
'" >';
232 $sql =
'SELECT rowid, fk_bom_child, fk_product, qty FROM '.MAIN_DB_PREFIX.
'bom_bomline AS bl';
233 $sql.=
' WHERE fk_bom ='. (int) $tmpbom->id;
234 $resql = $object->db->query(
$sql);
238 while ($obj = $object->db->fetch_object($resql)) {
239 $sub_bom_product =
new Product($object->db);
240 $sub_bom_product->fetch($obj->fk_product);
242 $sub_bom =
new BOM($object->db);
243 if (!empty($obj->fk_bom_child)) {
244 $sub_bom->fetch($obj->fk_bom_child);
247 $sub_bom_line =
new BOMLine($object->db);
248 $sub_bom_line->fetch($obj->rowid);
251 if (empty($conf->global->BOM_SHOW_ALL_BOM_BY_DEFAULT)) {
252 print
'<tr style="display:none" class="sub_bom_lines" parentid="'.$line->id.
'">';
254 print
'<tr class="sub_bom_lines" parentid="'.$line->id.
'">';
258 print
'<td style="padding-left: 5%" id="sub_bom_product_'.$sub_bom_line->id.
'">';
259 if (!empty($obj->fk_bom_child)) {
260 print $sub_bom_product->getNomUrl(1);
261 print
' '.$langs->trans(
'or').
' ';
262 print $sub_bom->getNomUrl(1);
264 print $sub_bom_product->getNomUrl(1);
269 $label = $sub_bom_product->getLabelOfUnit(
'long');
270 if ($sub_bom_line->qty_frozen > 0) {
271 print
'<td class="linecolqty nowrap right" id="sub_bom_qty_'.$sub_bom_line->id.
'">'.
price($sub_bom_line->qty, 0,
'', 0, 0).
'</td>';
272 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
273 print
'<td class="linecoluseunit nowrap left">';
274 if ($label !==
'') print $langs->trans($label);
277 print
'<td class="linecolqtyfrozen nowrap right" id="sub_bom_qty_frozen_'.$sub_bom_line->id.
'">'.$langs->trans(
'Yes').
'</td>';
279 print
'<td class="linecolqty nowrap right" id="sub_bom_qty_'.$sub_bom_line->id.
'">'.
price($sub_bom_line->qty * $line->qty, 0,
'', 0, 0).
'</td>';
280 if (!empty($conf->global->PRODUCT_USE_UNITS)) {
281 print
'<td class="linecoluseunit nowrap left">';
282 if ($label !==
'') print $langs->trans($label);
286 print
'<td class="linecolqtyfrozen nowrap right" id="sub_bom_qty_frozen_'.$sub_bom_line->id.
'"> </td>';
290 if ($sub_bom_line->disable_stock_change > 0) {
291 print
'<td class="linecoldisablestockchange nowrap right" id="sub_bom_stock_change_'.$sub_bom_line->id.
'">'.$sub_bom_line->disable_stock_change.
'</td>';
293 print
'<td class="linecoldisablestockchange nowrap right" id="sub_bom_stock_change_'.$sub_bom_line->id.
'"> </td>';
297 print
'<td class="linecolefficiency nowrap right" id="sub_bom_efficiency_'.$sub_bom_line->id.
'">'.$sub_bom_line->efficiency.
'</td>';
300 if (!empty($sub_bom->id)) {
301 $sub_bom->calculateCosts();
302 print
'<td class="linecolcost nowrap right" id="sub_bom_cost_'.$sub_bom_line->id.
'"><span class="amount">'.
price(
price2num($sub_bom->total_cost * $sub_bom_line->qty * $line->qty,
'MT')).
'</span></td>';
303 $total_cost+= $sub_bom->total_cost * $sub_bom_line->qty * $line->qty;
309 $res = $workstation->fetch($sub_bom_product->fk_default_workstation);
310 if ($res > 0) $sub_bom_line->total_cost =
price2num($qty * ($workstation->thm_operator_estimated + $workstation->thm_machine_estimated),
'MT');
312 print
'<td class="linecolcost nowrap right" id="sub_bom_cost_'.$sub_bom_line->id.
'"><span class="amount">'.
price(
price2num($sub_bom_line->total_cost,
'MT')).
'</span></td>';
313 $this->total_cost += $line->total_cost;
314 } elseif ($sub_bom_product->cost_price > 0) {
315 print
'<td class="linecolcost nowrap right" id="sub_bom_cost_'.$sub_bom_line->id.
'"><span class="amount">'.
price(
price2num($sub_bom_product->cost_price * $sub_bom_line->qty * $line->qty,
'MT')).
'</span></td>';
316 $total_cost+= $sub_bom_product->cost_price * $sub_bom_line->qty * $line->qty;
317 } elseif ($sub_bom_product->pmp > 0) {
318 print
'<td class="linecolcost nowrap right" id="sub_bom_cost_'.$sub_bom_line->id.
'"><span class="amount">'.
price(
price2num($sub_bom_product->pmp * $sub_bom_line->qty * $line->qty,
'MT')).
'</span></td>';
319 $total_cost.= $sub_bom_product->pmp * $sub_bom_line->qty * $line->qty;
321 $sql_supplier_price =
'SELECT MIN(price) AS min_price, quantity AS qty FROM '.MAIN_DB_PREFIX.
'product_fournisseur_price';
322 $sql_supplier_price.=
' WHERE fk_product = '. (int) $sub_bom_product->id;
323 $resql_supplier_price = $object->db->query($sql_supplier_price);
324 if ($resql_supplier_price) {
325 $obj = $object->db->fetch_object($resql_supplier_price);
326 $line_cost = $obj->min_price/$obj->qty * $sub_bom_line->qty * $line->qty;
328 print
'<td class="linecolcost nowrap right" id="sub_bom_cost_'.$sub_bom_line->id.
'"><span class="amount">'.
price2num($line_cost,
'MT').
'</span></td>';
329 $total_cost+= $line_cost;
340 print
"<!-- END PHP TEMPLATE objectline_view.tpl.php -->\n";