function approved_resending_orders()
{
$CI =& get_instance();
$CI->load->model('order_model');
$login_name = get_current_login_name();
$type = array('not_received_approved_resending', 'received_approved_resending');
$orders = $CI->order_model->fetch_default_orders($login_name, $type);
$url = site_url('order/regular_order/view_order');
$head = array(lang('item_information'), lang('product_information'), lang('gathering_transaction_remark'), lang('shipping_info'), lang('order_status'), lang('import_date') . anchor($url, lang('add_more'), array('style' => 'float:right;')));
$data = array();
$ebay_url = 'http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=';
$statuses = fetch_statuses('order_status');
$purchasers = array();
foreach ($orders as $order) {
$row = array();
$gross = empty($order->gross) ? $order->net : $order->gross;
$rmb = price($CI->order_model->calc_currency($order->currency, $gross));
$lang_name = lang('name_en');
$lang_address = lang('address_en');
$lang_town_city = lang('town_city_en');
$lang_state_province = lang('state_province_en');
$lang_countries = lang('country_en');
$lang_zip_code = lang('postal_code_en');
$name = $order->name . (empty($order->buyer_id) ? '' : "({$order->buyer_id})");
$phone = '';
if (!empty($order->contact_phone_number)) {
$phone = lang('phone') . ':';
$phone .= $order->contact_phone_number;
}
$item_info = <<<ITEM
<div style='padding: 10px;'>
{$order->item_no}<br/>
{$lang_name} : {$name} <br/>
{$lang_address} : {$order->address_line_1} {$order->address_line_2}<br/>
{$lang_town_city} :{$order->town_city}<br/>
{$lang_state_province} : {$order->state_province}<br/>
{$lang_countries} ：{$order->country}<br/>
{$lang_zip_code} : {$order->zip_code}<br/>
{$phone}
</div>
ITEM;
$row[] = $item_info;
$item_ids = explode(',', $order->item_id_str);
$skus = explode(',', $order->sku_str);
$qties = explode(',', $order->qty_str);
$count = count($skus);
$item_sku_html = '';
$product_name = '';
$item_sku_html .= "<div id='item_div_{$order->id}'>";
for ($i = 0; $i < $count; $i++) {
$item_id = element($i, $item_ids);
if (strlen($item_id) == 12) {
$link = '<a target="_blank" href="' . $ebay_url . $item_id . '">' . $item_id . '</a>';
} else {
$link = $item_id;
}
$item_sku_html .= '<div style="margin-top: 5px;">';
if ($item_id) {
$item_sku_html .= "Item ID: {$link}<br/>";
}
$purchaser_name = '';
if (isset($purchasers[$skus[$i]])) {
$purchaser_name = $purchasers[$skus[$i]];
} else {
$purchaser_name = get_purchaser_name_by_sku($skus[$i]);
$purchasers[$skus[$i]] = $purchaser_name;
}
$item_sku_html .= ' SKU: ' . (isset($skus[$i]) ? $skus[$i] . ' * ' . element($i, $qties) . ' (' . get_product_name($skus[$i]) . ')' : '') . ' ' . $purchaser_name . '<br/>';
$item_sku_html .= '</div>';
}
$item_sku_html .= '</div>';
$shipping_type = lang('shipping_way') . ': ';
$shipping_type .= $order->is_register;
$item_title_str = str_replace(',', '<br/>', $order->item_title_str);
$product_info = <<<PRODUCT
<div style='padding: 10px;'>
{$item_title_str}<br/>
{$item_sku_html}
</div>
PRODUCT;
$status_name = $CI->order_model->fetch_status_name('order_status', $order->order_status);
$order_status_arr = array('not_received_apply_for_partial_refund', 'not_received_apply_for_full_refund', 'received_apply_for_partial_refund', 'received_apply_for_full_refund', 'not_received_apply_for_resending', 'received_apply_for_resending');
if (isset($power) && $power >= 2 && in_array($status_name, $order_status_arr)) {
$anchor = anchor(site_url('order/special_order/view_return_order', array($order->item_no, 'auditing')), lang('pending') . '>>');
}
$make_pi_html = '';
if (true) {
$anchor = anchor(site_url('order/special_order/view_return_order', array($order->item_no)), lang('make_pi') . '>>');
$make_pi_html = form_label($anchor);
$make_pi_html .= '<br/>';
}
$status_nrar = $CI->order_model->fetch_status_id('order_status', 'not_received_approved_resending');
$status_rar = $CI->order_model->fetch_status_id('order_status', 'received_approved_resending');
if ($order->order_status == $status_nrar || $order->order_status == $status_rar) {
$anchor = anchor(site_url('order/special_order/again', array($order->item_no)), lang('again') . '>>');
}
$row[] = $product_info;
$lang_remark = lang('remark');
$other_info = <<<OTHER
{$order->currency}: {$gross}, RMB : {$rmb}<br/><br/>
{$order->transaction_id} <br/><br/>
{$order->track_number}
OTHER;
$row[] = $other_info;
$lang_confirm_date = lang('ship_confirm_date');
$lang_weight = lang('weight') . '(g)';
$lang_confirm_user = lang('ship_confirm_user');
$lang_ship_remark = lang('ship_remark');
$lang_receive_date = lang('receive_date');
$lang_sys_remark = lang('sys_remark');
$ship_info = <<<SHIP
{$lang_confirm_date} : {$order->ship_confirm_date} <br/>
{$lang_weight} : {$order->ship_weight} <br/>
{$lang_confirm_user} : {$order->ship_confirm_user} <br/>
{$lang_ship_remark} : {$order->ship_remark} <br/> | {$order->descript} <br/>
{$lang_receive_date} : {$order->order_receive_date} <br/>
<abbr title="{$order->sys_remark}">{$lang_sys_remark}</abbr>
SHIP;
$row[] = $ship_info;
$row[] = lang(element($order->order_status, $statuses)) . '<br/><br/>';
$row[] = $order->input_date;
$data[] = $row;
}
// echo 'hello'; die();
return array($head, $data);
}
$product_name = '';
$item_sku_html .= "<div id='item_div_{$order->id}'>";
for ($i = 0; $i < $count; $i++) {
$item_id = element($i, $item_ids);
$link = $item_id;
$item_sku_html .= '<div style="margin-top: 5px;">';
$title = element($i, $item_title);
$item_sku_html .= $title . '<br/>';
if ($item_id) {
$item_sku_html .= "Item ID: {$link}<br/>";
}
$purchaser_name = '';
if (isset($purchasers[$skus[$i]])) {
$purchaser_name = $purchasers[$skus[$i]];
} else {
$purchaser_name = get_purchaser_name_by_sku($skus[$i]);
$purchasers[$skus[$i]] = $purchaser_name;
}
$cost = get_cost_by_sku($skus[$i]);
if ($cost == 0) {
$cost = '';
}
$item_sku_html .= ' SKU: ' . (isset($skus[$i]) ? $skus[$i] . ' * ' . element($i, $qties) . ' (' . get_product_name($skus[$i]) . ')' : '') . ' ' . $purchaser_name . '<br>';
$item_sku_html .= '</div>';
}
$item_sku_html .= '</div>';
$shipping_type = lang('shipping_way') . ': ';
$shipping_type .= $order->is_register;
$product_info = <<<PRODUCT
<div style='padding: 10px;'>
{$item_sku_html}
public function download_order_info()
{
$head = array(lang('item_number'), lang('ship_remark'), lang('customer_remark'), lang('is_register'), lang('track_number'), lang('total_weight'), lang('shipping_cost'), lang('total_cost'), lang('total_profit_rate'), lang('product_information'), lang('ship_confirm_date'), lang('receipt'), lang('transaction_number'), lang('input_user'), lang('cost_date'));
if (!$this->input->is_post()) {
return;
}
$order_ids_str = trim($this->input->post('order_ids_str'), ',');
if (empty($order_ids_str)) {
$content = lang('select_one_download');
echo "<script >alert('{$content}'); history.back();</script>";
return;
}
$order_ids = array();
foreach (explode(',', $order_ids_str) as $id) {
$order_ids[] = $id;
}
$orders = $this->accounting_cost_model->fetch_costs_by_cost_user_to_array($order_ids);
$show_data = array();
foreach ($orders as $order) {
$receipt = $order->currency . ' : ' . $order->net && $order->net != 0 ? $order->net : $order->gross;
$item_ids = explode(',', $order->item_id_str);
$skus = explode(',', $order->sku_str);
$qties = explode(',', $order->qty_str);
$item_title = explode(',', $order->item_title_str);
$product_cost_string = explode(',', $order->product_cost);
$count = count($skus);
$product_information = '';
$product_name = '';
$total_product_cost = 0;
for ($i = 0; $i < $count; $i++) {
$item_id = element($i, $item_ids);
$title = element($i, $item_title);
$product_information .= $title . ' ';
if ($item_id) {
$product_information .= "Item ID: {$item_id} ";
}
$purchaser_name = '';
if (isset($purchasers[$skus[$i]])) {
$purchaser_name = $purchasers[$skus[$i]];
} else {
$purchaser_name = get_purchaser_name_by_sku($skus[$i]);
$purchasers[$skus[$i]] = $purchaser_name;
}
$product_cost = get_cost_by_sku($skus[$i]);
if ($product_cost == 0) {
$product_cost = '';
}
$price_html = $product_cost;
if (element($i, $product_cost_string)) {
$cost = $product_cost_string[$i];
} else {
$cost = $product_cost;
}
// if(isset ($action) && $action =='cost_view_list')
// {
$price_html = $cost;
// }
$total_product_cost += $cost * element($i, $qties);
$product_information .= ' SKU: ' . (isset($skus[$i]) ? $skus[$i] . ' * ' . element($i, $qties) . ' (' . get_product_name($skus[$i]) . ')' : '') . ' ' . $purchaser_name . ' ' . lang('cost_price') . ' : ' . $price_html;
}
$default = isset($product_cost_string[$count]) ? $product_cost_string[$count] : '0.65';
$product_information .= ' ' . lang('other_cost_price') . ' : ' . $default;
$top = $order->product_cost_all == 0 ? $total_product_cost : $order->product_cost_all;
$product_information .= ' ' . lang('total_cost') . ' : ' . $top;
$show_data[] = array('item_number' => $order->item_no, 'ship_remark' => $order->ship_remark, 'customer_remark' => $order->descript, 'is_register' => $order->is_register, 'track_number' => $order->track_number, 'total_weight' => $order->ship_weight, 'shipping_cost' => $order->shipping_cost, 'total_cost' => $top, 'total_profit_rate' => $order->profit_rate, 'product_information' => $product_information, 'ship_confirm_date' => $order->ship_confirm_date, 'receipt' => $receipt . "({$order->currency})", 'transaction_number' => $order->transaction_id, 'input_user' => $order->input_user, 'cost_date' => $order->cost_date);
}
$this->excel->array_to_excel($show_data, $head, 'Order_info_' . date('Y-m-d'));
}
