$preview .= '<div style="margin-left:100px;">'; $preview .= '<div style="margin-bottom:5px;">'; $preview .= $element->detail['supplier']; $preview .= ' / 1 ' . $stock['qty_type'] . ' = ' . displayCurrency('EUR', $element->detail['price']); //$preview .= ' <span class="smallText notice">('.$stock['pieces_per_qty_type'].' qty = 1 '.$stock['qty_type'].')</span>'; $preview .= '</div>'; $found = '1'; $epo_status_0 = new elements_preorder($eid, '0'); $epo_status_1 = new elements_preorder($eid, '1'); $qty_to_qtytype_raw = $qty / $stock['pieces_per_qty_type']; $qty_to_qtytype = ceil($qty_to_qtytype_raw); $r = $element->displaySafetyDT($stock['stock'], $element->suppliers[$suppliers_id]['resourcing_day']); $l = '<span class="' . ($element->calcRefillQuantity($stock['stock'], $current_orders, 1) > 0 ? 'green">ON' : 'red">OFF') . '<span>'; $e = displayCurrency('EUR', $qty * $element->detail['price']); $p3 = $qty * $element->detail['weight'] . 'gr'; $preview .= '<div>DIOH is ' . $element->displayDIOH($stock['stock']) . '</div>'; $preview .= $element->displayStockInfoTable(null, 'width:200px;margin:20px 0;'); $preview .= '</div>'; //before we only show text if existing suggest/request exist, now we always show it //if ($current_suggest>0 || $current_request>0) { $preview .= '<div class="red bold" style="margin-top:10px;">'; //$existing = ''; //if ($current_suggest>0) $existing .= 'Suggested'; //if ($current_request>0) { // if ($current_suggest>0) $existing .= ' and '; // $existing .= 'Requested'; //} //$preview .= $existing.' qty found for this Element. Proceeding with manual request will remove existing '.$existing.' qty.'; $preview .= 'Proceeding with manual request will remove existing suggestions of this element.'; $preview .= '</div>'; //}
$stock_text = $stock - floor($stock) == 0 ? $stock : number_format($stock, 1, ',', ''); $stock_text .= ' ' . $stock_data['qty_type']; $stock_text = '<a href="?open=elements-stock-update&id=' . $id . '&hidemenu=true" class="view_webpage" title="Update Stock">' . $stock_text . '</a>'; if ($stock_data['pieces_per_qty_type'] > 1 && $stock_data['stock'] > 0) { $piece_qty_type = $stock_data['qty_type'] == 'meter' ? ' cm' : ' pieces'; $stock_text .= '<br /><span class="notice">(' . $stock_data['stock'] . $piece_qty_type . ')</span>'; } } $stock_price = $stock_data['stock'] * $detail->detail['price']; $img = webImage($detail->image, '80', '80', $id); $name = $detail->detail['name']; $info = $detail->detail['supplier']; $pri = displayCurrency('EUR', $detail->detail['price']); $info2 = $stock_text; $ws = $detail->log['weekly_sold']; $dioh_text = $detail->displayDIOH($stock_data['stock']); $pri3 = '<span title="Sold ' . $detail->log['sold_monthly_1'] . $piece_qty_type . ' in the last 30 days">' . $dioh_text . '</span>'; $pri2 = displayCurrency('EUR', $stock_price); $act = '<input type="button" name="del" value="Delete" />'; $row = '<tr id="id-' . $id . '" class="' . $row_class . '">'; foreach ($header as $td => $h) { if ($td == 'id') { $content = '<a href="?open=element&id=' . $id . '&hidemenu=true" class="view_webpage" title="Manage Element Detail">' . $id . '</a>'; } elseif ($td == 'img') { $imgsrc = webImageSource($detail->image); $content = $imgsrc == '' ? $img : '<a href="' . webImageSource($detail->image) . '" class="view_image" title="Element Image ' . $id . '">' . $img . '</a>'; } elseif ($td == 'info') { if ($info == '') { $info = 'UNSET'; } $content = '<a href="?open=elements-suppliers&id=' . $id . '&hidemenu=true" class="view_webpage" title="Manage Supplier Data">' . $info . '</a>';
// echo $q; $dbq = tep_db_query($q); $elements = array(); $elements_counter = 0; $total_value = 0; $total_missing = 0; while ($r = tep_db_fetch_array($dbq)) { $include = false; $elid = $r['elements_id']; $current_stock = $r['stock_actual']; $qty_ordered = elements_order::openOrdersQuantity($elid); $qty_requested = elements_preorder::openOrdersQuantity($elid); $e = new element($elid); $dioh = $e->getDIOH($current_stock); $dioh2 = $e->getDIOH($current_stock + $qty_ordered); $dioh_text = $e->displayDIOH($current_stock); $dioh2_text = $e->displayDIOH($current_stock + $qty_ordered); $target_stock = $e->getDIOHstockTarget(); $orders_in_sourcing = elements_preorder::totalNeededForSourcingTab($elid); $missing = $target_stock + $orders_in_sourcing - ($current_stock + $qty_ordered); if ($missing < 0) { $missing = 0; } $refill = $e->calcRefillQuantity($current_stock, $qty_ordered, 1); if (!$need_php_filtered) { $include = true; } else { switch ($filter_refill) { case 'ON': if ($refill > 0) { $include = true;