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');
示例#3
0
                $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();