function fetch_list_to_be_purchase() { $CI =& get_instance(); $purchaser_id = -1; if (isset($id) && isset($key)) { $purchaser_id = $id; } $CI->load->model('mixture_model'); $CI->load->model('purchase_model'); $purchase_list = $CI->purchase_model->fetch_purchase_list($purchaser_id); $url = site_url('purchase/purchase_list/view_list'); $head = array(lang('sku'), lang('image_url'), lang('market_model'), lang('chinese_name'), lang('7-days_sales_amounts'), lang('30-days_sales_amounts'), lang('60-days_sales_amounts'), lang('dueout'), lang('stock_count'), lang('storage_warning'), lang('in_transit'), lang('purchasing_suggested'), lang('purchasing_actually'), lang('purchaser'), lang('price') . ' / ' . lang('provider') . anchor($url, lang('add_more'), array('style' => 'float:right;'))); $data = array(); $index = 0; foreach ($purchase_list as $purchase) { if ($index < 5) { $data[] = array(get_status_image($purchase['sku']) . anchor(site_url('pi/product/add_edit', array($purchase['id'])), block_center($purchase['sku']), array('target' => '_blank')), block_center(block_image($purchase['image_url'], array(40, 40))), block_center($purchase['market_model']), block_center($purchase['name_cn']), block_center($purchase['7_days_sale_amount'] ? $purchase['7_days_sale_amount'] : 0), block_center($purchase['30_days_sale_amount'] ? $purchase['30_days_sale_amount'] : 0), block_center($purchase['60_days_sale_amount'] ? $purchase['60_days_sale_amount'] : 0), block_center('<strong>' . $purchase['dueout_count'] . '</strong>'), block_center('<strong>' . $purchase['stock_count'] . '</strong>'), block_center($purchase['min_stock_number']), block_center($purchase['on_way_count']), block_center($purchase['purchase_suggestion']), '', block_center($purchase['purchaser']), $purchase['providers']); } $index++; } return array($head, $data); }
<?php $head = array(lang('sort_num'), array('text' => lang('sku'), 'sort_key' => 'sku', 'id' => 'purchase_list'), lang('image_url'), array('text' => lang('market_model'), 'sort_key' => 'market_model'), array('text' => lang('chinese_name'), 'sort_key' => 'name_cn'), array('text' => lang('7-days_sales_amounts'), 'sort_key' => 'sale_in_7_days'), array('text' => lang('30-days_sales_amounts'), 'sort_key' => 'sale_in_30_days'), array('text' => lang('60-days_sales_amounts'), 'sort_key' => 'sale_in_60_days'), array('text' => lang('dueout'), 'sort_key' => 'dueout_count'), array('text' => lang('stock_count'), 'sort_key' => 'stock_count'), array('text' => lang('storage_warning'), 'sort_key' => 'min_stock_number'), array('text' => lang('in_transit'), 'sort_key' => 'on_way_count')); $data = array(); $index = 0; foreach ($purchase_list as $purchase) { $data[] = array($index + 1, block_center(get_status_image($purchase['sku']) . $purchase['sku']), block_center(block_image($purchase['image_url'], array(40, 40))), block_center($purchase['market_model']), block_center($purchase['name_cn']), block_center($purchase['sale_in_7_days'] ? $purchase['sale_in_7_days'] : 0), block_center($purchase['sale_in_30_days'] ? $purchase['sale_in_30_days'] : 0), block_center($purchase['sale_in_60_days'] ? $purchase['sale_in_60_days'] : 0), block_center('<strong>' . $purchase['dueout_count'] . '</strong>'), block_center('<strong>' . $purchase['stock_count'] . '</strong>'), block_center($purchase['min_stock_number']), block_center($purchase['on_way_count'])); $index++; } $filters = array(NULL, array('type' => 'input', 'field' => 'sku'), NULL, array('type' => 'input', 'field' => 'market_model'), array('type' => 'input', 'field' => 'name_cn'), array('type' => 'input', 'field' => 'sale_in_7_days'), array('type' => 'input', 'field' => 'sale_in_30_days'), array('type' => 'input', 'field' => 'sale_in_60_days'), array('type' => 'input', 'field' => 'dueout_count'), array('type' => 'input', 'field' => 'stock_count')); $config = array('filters' => $filters); $title = lang('wait_for_qt_check_product'); echo block_header($title); echo $this->block->generate_pagination('purchase_list'); echo form_open(); echo $this->block->generate_reset_search($config); echo $this->block->generate_table($head, $data, $filters, 'shipping_subarea_group'); echo form_close(); echo $this->block->generate_pagination('purchase_list');
$min_stock_number_html .= $purchase['au_min_stock_number'] == '' ? '' : '<font color=blue>' . $purchase['au_min_stock_number'] . '</font>' . ' (AU) <br/>'; $purchase_suggestion_html .= $purchase['au_purchase_suggestion'] <= 0 ? '' : '<font color=blue>' . $purchase['au_purchase_suggestion'] . '</font>' . ' (AU) <br/>'; } if ($code->stock_code == 'YB') { $dueout_count_html .= $purchase['yb_dueout_count'] == '' ? '' : '<font color=blue>' . $purchase['yb_dueout_count'] . '</font>' . ' (YB) <br/>'; $stock_count_html .= $purchase['yb_stock_count'] == '' ? '' : '<font color=blue>' . $purchase['yb_stock_count'] . '</font>' . ' (YB) <br/>'; $on_way_count_html .= $purchase['yb_on_way_count'] == '' ? '' : '<font color=blue>' . $purchase['yb_on_way_count'] . '</font>' . ' (YB) <br/>'; $min_stock_number_html .= $purchase['yb_min_stock_number'] == '' ? '' : '<font color=blue>' . $purchase['yb_min_stock_number'] . '</font>' . ' (YB) <br/>'; $purchase_suggestion_html .= $purchase['yb_purchase_suggestion'] <= 0 ? '' : '<font color=blue>' . $purchase['yb_purchase_suggestion'] . '</font>' . ' (AU) <br/>'; } } } else { $dueout_count_html .= $purchase['dueout_count'] == '' ? '' : '<font color=blue>' . $purchase['dueout_count'] . '</font>' . '<br/>'; $stock_count_html .= $purchase['stock_count'] == '' ? '' : '<font color=blue>' . $purchase['stock_count'] . '</font>' . '<br/>'; $on_way_count_html .= $purchase['on_way_count'] == '' ? '' : '<font color=blue>' . $purchase['on_way_count'] . '</font>' . '<br/>'; $min_stock_number_html .= $purchase['min_stock_number'] == '' ? '' : '<font color=blue>' . $purchase['min_stock_number'] . '</font>' . '<br/>'; $purchase_suggestion_html .= $purchase['purchase_suggestion'] <= 0 ? '' : '<font color=blue>' . $purchase['purchase_suggestion'] . '</font>' . '<br/>'; // $purchase_suggestion = $purchase['purchase_suggestion'] <= 0 ? 0 : $purchase['purchase_suggestion']; } $data[] = array(form_checkbox($select_data), block_center(block_image($purchase['image_url'], array(40, 40))), get_status_image($purchase['sku']) . anchor(site_url('pi/product/add_edit', array($purchase['id'])), block_center($purchase['sku']), array('target' => '_blank')), block_center($purchase['market_model']), block_center($purchase['name_cn']), block_center($purchase['7_days_sale_amount'] ? $purchase['7_days_sale_amount'] : 0), block_center($purchase['30_days_sale_amount'] ? $purchase['30_days_sale_amount'] : 0), block_center($purchase['60_days_sale_amount'] ? $purchase['60_days_sale_amount'] : 0), block_center('<strong>' . "{$dueout_count_html}" . '</strong>'), block_center('<strong>' . $stock_count_html . '</strong>'), block_center($min_stock_number_html), block_center($on_way_count_html), block_center($purchase_suggestion_html), '', block_center($purchase['purchaser']), $purchase['providers']); $index++; } $batch_purchase = site_url('purchase/order/batch_purchase_sku'); echo form_open($batch_purchase); echo block_js_sortable_table($head, $data, array(NULL, 'default', NULL, 'default', 'default', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer', NULL, 'default'), "width: 100%;border-collapse: collapse;"); echo form_hidden('item_count', $index); $print_label = '<span style="float:right;">'; $print_label .= form_submit('batch_purchase', lang('batch_purchase')); $print_label .= '</span>'; echo block_check_all() . $print_label; echo form_close();
$select_purchaser = form_dropdown('select_purchaser', $options, $purchaser_id, $js); } ?> <table width="100%" border="0" align="center"> <tr> <td><?php echo lang('deadline_of_order_confirmation'); ?> : <?php echo $fetch_dueout_update_time; ?> </td> <td style="float: right;"><?php echo $select_purchaser; ?> </td> </tr> </table> <?php $head = array(lang('sort_num'), lang('sku'), lang('image_url'), lang('market_model'), lang('chinese_name'), lang('7-days_sales_amounts'), lang('30-days_sales_amounts'), lang('60-days_sales_amounts'), lang('dueout'), lang('stock_count'), lang('storage_warning'), lang('in_transit'), lang('purchasing_suggested'), lang('purchasing_actually'), lang('purchaser'), lang('price') . ' / ' . lang('provider')); $data = array(); $index = 0; foreach ($purchase_list as $purchase) { $data[] = array($index + 1, get_status_image($purchase['sku']) . anchor(site_url('pi/product/add_edit', array($purchase['id'])), block_center($purchase['sku']), array('target' => '_blank')), block_center(block_image($purchase['image_url'], array(40, 40))), block_center($purchase['market_model']), block_center($purchase['name_cn']), block_center($purchase['7_days_sale_amount'] ? $purchase['7_days_sale_amount'] : 0), block_center($purchase['30_days_sale_amount'] ? $purchase['30_days_sale_amount'] : 0), block_center($purchase['60_days_sale_amount'] ? $purchase['60_days_sale_amount'] : 0), block_center('<strong>' . $purchase['dueout_count'] . '</strong>'), block_center('<strong>' . $purchase['stock_count'] . '</strong>'), block_center($purchase['min_stock_number']), block_center($purchase['on_way_count']), block_center($purchase['purchase_suggestion']), '', block_center($purchase['purchaser']), $purchase['providers']); $index++; } $batch_purchase = site_url('purchase/order/batch_purchase_sku'); echo form_open($batch_purchase); echo block_js_sortable_table($head, $data, array(NULL, 'default', NULL, 'default', 'default', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer', 'integer', NULL, 'default'), "width: 100%;border-collapse: collapse;"); echo form_close();