$stock_available = $stock_database - $stock_on_and_bookedmanually;
$stock_on_total = $stock_database + $stock_on_and_bookedbyrealorder;
$matexp = $row['material_expenses'];
$matexp_tot = $stock_on_total * $matexp;
if ($row['bin_code'] != '') {
$total_bins++;
} else {
$total_bins_unknown++;
}
$total_qty_stock += $stock_available;
$total_qty_booked_m += $stock_on_and_bookedmanually;
$total_qty_booked_r += $stock_on_and_bookedbyrealorder;
$total_qty_total += $stock_on_total;
$total_matexp_tot += $matexp_tot;
$st = array();
$st['bin'] = $class_bins->getCleanBinCode($row['bin_code']);
$st['cat'] = $row['categories_name'];
$st['ean'] = $row['products_ean'];
$st['idl'] = $row['products_id'] . ($row['length'] > 0 ? ' (' . textLength($row['length'], false) . ')' : '');
$st['mxs'] = displayCurrency('EUR', $matexp);
$st['mxt'] = displayCurrency('EUR', $matexp_tot);
$st['qty'] = number_format($stock_available);
$st['bok 1'] = number_format($stock_on_and_bookedmanually);
$st['bok 2'] = number_format($stock_on_and_bookedbyrealorder);
$st['tot'] = number_format($stock_on_total);
$st['act'] = ' ';
$stocks_table[] = $st;
}
$total_products = count($products);
$total_articles = count($articles);
$title = 'Stock List of ' . $segment['name'];
$total_clear = tep_db_num_rows($dbq);
$clean_lists = '<fieldset id="clearance-lists" style="background:#fff;padding:20px 30px 30px 30px; width:600px;" class="ui-corner-all">';
$clean_lists .= '<legend style="font-size:16px;font-weight:bold;">Results of "' . ($clearance_period == 30 ? 'Monthly' : ($clearance_period == 60 ? 'Monthly' : ($clearance_period == 90 ? 'Trimonthly' : 'Weekly'))) . ' Sold = 0" Clearance (' . $total_clear . ' articles)</legend>';
$clean_lists .= '<h2 class="blue">Please do clearance on box and confirm actual stock below !</h2>';
$clean_lists .= '<div style="margin:10px 0 10px 0;float:left;">';
$table = array();
$clean_picklists = array();
$clean_picklists['d'] = 'Box Location';
$clean_picklists['a'] = 'Product Info';
$clean_picklists['s'] = 'Stock';
$clean_picklists['q'] = 'Actual';
$table[] = $clean_picklists;
$total_qty_clear = 0;
while ($row = tep_db_fetch_array($dbq)) {
$ean = $class_ean->getEAN($row['products_id'], $row['articles_id']);
$clean_picklists['d'] = '<a href="?open=bin-info&id=' . $row['bins_id'] . '&hidemenu=true" class="view_webpage" title="View Box">' . $class_bins->getCleanBinCode($row['code']) . '</a>';
$pimg = webImage($row['products_image'], '80', '80', $label_text, 'img-border');
$main_image = webImageSource($row['products_image'], '500');
if ($main_image != '') {
$pimg = '<a href="' . $main_image . '" class="view_image" title="' . $label_text . '">' . $pimg . '</a>';
}
$clean_picklists['a'] = $pimg . '<br/>' . '<a title="View Product Detail" href="?open=product-detail&products_id=' . $row['products_id'] . '" target="_blank">' . $row['products_id'] . ' / ' . $row['products_model'] . '</a>';
$clean_picklists['s'] = $row['stock'];
$clean_picklists['q'] = '<input type="hidden" value="' . $row['bins_id'] . '" class="hidden-bins-id" />';
$clean_picklists['q'] .= '<input type="hidden" class="qty-stock" value="' . $row['stock'] . '" />';
$clean_picklists['q'] .= '<input id="qty-actual-' . $ean . '" class="qty-actual" type="text" maxlength="3" onfocus="$(this).select();" style="width:50px;text-align:center;" value="' . $row['stock'] . '" />';
$total_qty_clear += $row['stock'];
$table[] = $clean_picklists;
}
$clean_lists .= tep_draw_table('spo', $table);
$clean_lists .= '<input id="btn-clear-confirm" type="button" value="Confirm" style="margin-top:10px;" class="button"/>';
$firstorder = true;
foreach ($clean_picklists as $bin_code => $data) {
if ($ypos >= 260 || $order_counter >= $order_counter_max) {
$pdf->AddPage();
$ypos = $margin;
$order_counter = 0;
} else {
if (!$firstorder) {
$pdf->SetDrawColor(200, 200, 200);
$pdf->Line($margin - 5, $ypos - 5, 210 - $margin, $ypos - 5);
}
}
$order_counter++;
$pdf->setXY($margin, $ypos);
$pdf->setFont('Arial', 'B', '14');
$pdf->cell($counter_size, 5, $class_bin->getCleanBinCode($data['code']), 0, 0, 'C');
if ($data['products_ean'] != '') {
$pdf->EANBarcode($data['products_ean'], $barcode_start, $ypos, $barcode_width);
}
$pdf->setFont('Arial', 'B', '12');
//$pdf->cell($barcode_start+20, 40, $data['products_ean'], 0, 0, 'C');
$pdf->setXY($cellstart, $ypos);
$pdf->setFont('Arial', 'B', '10');
$pdf->Cell($cell1size, $cell_height, 'PRODUCT ID');
$pdf->Cell($cell1size, $cell_height, 'ARTICLE ID');
$pdf->Cell($counter_size + 10, $cell_height, 'QTY');
$pdf->Cell($counter_size, $cell_height, 'QTY ACTUAL', 0, 1);
$pdf->setFont('Arial', '', '10');
$pdf->setX($cellstart);
$pdf->Cell($cell1size, $cell_height + 10, $data['products_id']);
$pdf->Cell($cell1size, $cell_height + 10, $data['articles_id']);
$fgl['pri'] = 'Lengths';
$fgl['pri2'] = 'Stock<br />Available';
$fgl['info'] = 'Bins';
$fgl['info2'] = 'Selling Last<br />30 Days';
$fglist[] = $fgl;
foreach ($products as $pid => $p) {
$info = "<div><strong>{$pid} / {$p['products_model']}</strong></div>";
$info .= "<div>{$p['products_name']}</div>";
$idhid = '<input type="hidden" name="products_id" value="' . $pid . '" />';
$p_length = array();
$p_stocks = array();
$p_bins = array();
foreach ($articles[$pid] as $aid => $a) {
$length = $a['length'] > 0 ? textLength($a['length']) : '<span class="notice">None</span>';
$stocks = $a['stock'] > 0 ? $a['stock'] : '<span class="notice">0</span>';
$bins = $a['bin_code'] != '' ? $class_bin->getCleanBinCode($a['bin_code']) : '<span class="notice">-</span>';
if ($aid == 0 && $a['length'] > 0) {
$length = '<span class="bold">' . $length . ' [def]</span>';
$stocks = '<span class="bold">' . $stocks . '</span>';
$bins = '<span class="bold">' . $bins . '</span>';
}
$p_length[] = $length;
$p_stocks[] = $stocks;
$p_bins[] = '<a href="?open=bin-info&id=' . $a['bins_id'] . '&hidemenu=true" class="view_webpage">' . $bins . '</a>';
}
$fgl = array();
$fgl['img'] = webImageWithDetailLinkStars($p['products_image'], IMAGE_SIZE_THUMBNAIL_1, IMAGE_SIZE_THUMBNAIL_1, "Product {$pid}", "", "", IMAGE_SIZE_BIG_1, IMAGE_SIZE_BIG_1, $p['stars'], '3', '', '', $p['products_brand_id']);
$fgl['name'] = $idhid . $info;
$fgl['pri'] = implode('<br />', $p_length);
$fgl['pri2'] = implode('<br />', $p_stocks);
$fgl['info'] = implode('<br />', $p_bins);
