public function verify_saler_input_user() { $id = $this->input->post('id'); $type = $this->input->post('type'); $value = trim($this->input->post('value')); $saler_input_user = $this->sale_order_model->fetch_saler_input_user($id); try { switch ($type) { case 'saler_id': if ($this->sale_order_model->check_exists('user_saler_input_user_map', array('saler_id' => $value)) && $value != $saler_input_user->saler_id) { echo $this->create_json(0, lang('saler_exists'), fetch_user_name_by_id($saler_input_user->saler_id)); return; } break; } $this->sale_order_model->update_saler_input_user($id, $type, $value); if ($type == 'in_operation') { $value = $value == 1 ? lang('yes') : lang('no'); } else { $value = fetch_user_name_by_id($value); } echo $this->create_json(1, lang('ok'), $value); } catch (Exception $e) { $this->ajax_failed(); echo lang('error_msg'); } }
public function product_stock_count() { $this->load->library('excel'); $result = $this->accounting_cost_model->fetch_all_products(); $head = array('SKU', '中文名称', '商品分类', '市场型号', '货舱号', '货架号', '库存数量', '样品价', '采购员', '更新时间', '上次盘点时间'); $data = array(); foreach ($result as $row) { $data[] = array($row->sku, $row->p_name_cn, $row->c_name_cn, $row->market_model, $row->stock_code, $row->shelf_code, $row->stock_count, $row->price, $row->purchaser_id > 0 ? fetch_user_name_by_id($row->purchaser_id) : " ", $row->updated_date, $row->stock_check_date); } $this->excel->array_to_excel($data, $head, '_' . date('Y-m-d')); }
public function verigy_exchange_power_management() { $id = $this->input->post('id'); $type = $this->input->post('type'); $value = trim($this->input->post('value'), ','); $value = no_space($value); $currency_code = $this->order_model->fetch_power_management_by_id($id); if ($type == 'superintendent_id' && $this->order_model->check_exists('order_power_management_map', array('superintendent_id' => $value)) && $value != $currency_code->superintendent_id) { echo $this->create_json(0, lang('superintendent_id_exists')); return; } try { $this->order_model->update_exchange_power_management($id, $type, $value); if ($type == 'superintendent_id') { $value = fetch_user_name_by_id($value); } echo $this->create_json(1, lang('ok'), $value); } catch (Exception $e) { $this->ajax_failed(); echo lang('error_msg'); } }
public function work_rewards_error_edit($id = null) { if ($id) { $work_id_arr = $this->work_rewards_model->fetch_worker_by_id($id); $worker = array(); foreach ($work_id_arr as $work_id) { $worker[] = fetch_user_name_by_id($work_id['worker_id']); } $worker_id = implode(',', $worker); $work_rewards_error = $this->work_rewards_model->fetch_work_rewards_by_id($id); } else { $worker_id = null; $work_rewards_error = null; } $parent_catalog = $this->document_catalog_model->fetch_all_department_catalog_for_make_tree(); $parent_catalog = $this->_make_tree($parent_catalog); $data = array('department' => $parent_catalog, 'id' => $id, 'work_rewards_error' => $work_rewards_error, 'worker_id' => $worker_id); $this->template->write_view('content', 'myinfo/work_rewards_edit', $data); $this->template->render(); }
$options = block_button($config); $config = array('name' => 'reject_' . $apply_id, 'id' => 'reject_' . $apply_id, 'value' => lang('reject_it'), 'type' => 'button', 'style' => 'margin: 10px;', 'onclick' => "verify_apply_instock(this, '{$verify_url}', {$apply_id}, -1, {$last_index});"); $options .= block_button($config); $user_name = fetch_user_name_by_id($product->user_id); $shelf_code_str = $product->shelf_code; $shelf_code_div_id = 'shelf_code_' . $apply_id; if (!empty($product->new_shelf_code)) { $shelf_code_str .= ' -> ' . block_div($shelf_code_div_id, $product->new_shelf_code); echo block_editor($shelf_code_div_id, 'name_form', $update_instock_url, "{id: {$apply_id}, type: 'shelf_code'}"); } else { $shelf_code_str = block_div($shelf_code_div_id, $product->shelf_code); echo block_editor($shelf_code_div_id, 'name_form', $update_instock_url, "{id: {$apply_id}, type: 'old_shelf_code', sku: '{$product->sku}'}"); } $item = array($this->block->generate_select_checkbox($apply_id), get_status_image($product->sku) . $product->sku, $shelf_code_str, $this->block->generate_image($product->image_url), $product->name_cn . '<br/>' . $product->name_en, $product->u_name, $product->stock_count); if (isset($product->order_sku_id)) { $apply_user = fetch_user_name_by_id($product->user_id); $item[] = $apply_user; } else { $item[] = ''; } $change_count_div_id = 'change_count_' . $apply_id; $item[] = block_div($change_count_div_id, $product->change_count); echo block_editor($change_count_div_id, 'name_form', $update_instock_url, "{id: {$apply_id}, type: 'change_count'}"); $item[] = $product->updated_time; $item[] = $options; $data[] = $item; } $options = array(); $options[''] = lang('all'); foreach ($purchase_users as $purchase_user) { $options[$purchase_user->u_id] = $purchase_user->u_name;
<?php $head = array(array('text' => lang('resource_category'), 'sort_key' => 'seo_resource_category.name', 'id' => 'resource_integral'), array('text' => lang('resources'), 'sort_key' => 'url'), array('text' => lang('integral'), 'sort_key' => 'integral'), array('text' => lang('creator'), 'sort_key' => 'owner_id'), array('text' => lang('created_date'), 'sort_key' => 'update_date'), lang('options')); $data = array(); $code_url = site_url('seo/resource_edit/verify_resource'); foreach ($resources as $resource) { $drop_button = $this->block->generate_drop_icon('seo/resource/drop_resource_review', "{id: {$resource->resource_id}}", TRUE); $edit_button = $this->block->generate_edit_link(site_url('seo/resource/add_edit', array($resource->resource_id))); $url = $drop_button . $edit_button; $data[] = array($resource->category_name, $resource->url, $resource->integral, fetch_user_name_by_id($resource->owner_id), $resource->update_date, $url); } $filters = array(array('type' => 'input', 'field' => 'seo_resource_category.name'), array('type' => 'input', 'field' => 'url'), array('type' => 'input', 'field' => 'integral'), NULL, array('type' => 'input', 'field' => 'update_date')); $title = lang('resource_pending'); echo block_header($title); echo form_open(); echo $this->block->generate_pagination('resource_integral'); $config = array('filters' => $filters); echo $this->block->generate_reset_search($config); echo $this->block->generate_table($head, $data, $filters, 'resource_integral'); echo $this->block->generate_pagination('resource_integral'); echo form_close(); ?>
<?php $url = site_url('seo/service_company/add'); $add_button = $this->block->generate_add_icon($url); $head = array(lang('service_company'), lang('website'), lang('description'), lang('created_date'), lang('creator'), lang('options') . $add_button); $data = array(); $code_url = site_url('seo/service_company/verify'); foreach ($service_companys as $service_company) { $drop_button = $this->block->generate_drop_icon('seo/service_company/drop', "{id: {$service_company->id}}", TRUE); $data[] = array($this->block->generate_div("name_{$service_company->id}", isset($service_company) ? $service_company->name : '[edit]'), $this->block->generate_div("website_{$service_company->id}", isset($service_company) ? $service_company->website : '[edit]'), $this->block->generate_div("description_{$service_company->id}", isset($service_company) ? $service_company->description : '[edit]'), $service_company->created_date, fetch_user_name_by_id($service_company->creator_id), $drop_button); echo $this->block->generate_editor("name_{$service_company->id}", 'service_company_form', $code_url, "{id: {$service_company->id}, type: 'name'}"); echo $this->block->generate_editor("website_{$service_company->id}", 'service_company_form', $code_url, "{id: {$service_company->id}, type: 'website'}"); echo $this->block->generate_editor("description_{$service_company->id}", 'service_company_form', $code_url, "{id: {$service_company->id}, type: 'description'}"); } $title = lang('service_company_manage'); echo block_header($title); echo form_open(); echo $this->block->generate_table($head, $data); echo form_close();
public function fetch_statistics($begin_time = NULL, $end_time = NULL, $priority = 1, $purchaser_id = NULL) { $sql = <<<SQL (UNIX_TIMESTAMP(ship_confirm_date) - UNIX_TIMESTAMP(check_date)) as delay_times, sku_str, qty_str, item_no, sys_remark, purchaser_id_str SQL; $this->db->select($sql); $this->db->from('order_list_completed'); $this->db->where('ship_confirm_date >=', $begin_time); $this->db->where('ship_confirm_date <=', $end_time); $this->db->where('check_date !=', ''); $query = $this->db->get(); $result = $query->result(); $this->db->select($sql); $this->db->from('order_list'); $this->db->where('ship_confirm_date >=', $begin_time); $this->db->where('ship_confirm_date <=', $end_time); $this->db->where('check_date !=', ''); $query = $this->db->get(); $result = array_merge($result, $query->result()); $current_user_id = get_current_user_id(); $statistics = array(); $purchaser_skus = array(); $item_nos = array(); $user_name_map = array(); foreach ($result as $row) { $skus = explode(',', $row->sku_str); $qties = explode(',', $row->qty_str); $purchaser_ids = explode(',', $row->purchaser_id_str); $i = 0; $not_put = array(); foreach ($skus as $sku) { if (empty($purchaser_ids[$i])) { continue; } $tmp_purchaser_id = $purchaser_ids[$i]; if ($priority > 1) { if ($purchaser_id > 0 && $tmp_purchaser_id != $purchaser_id) { continue; } } else { if ($current_user_id != $tmp_purchaser_id) { continue; } } if (!isset($statistics[$tmp_purchaser_id])) { $statistics[$tmp_purchaser_id] = array(); } $readable = secs_to_readable($row->delay_times); $days = $readable['days']; // count once even if there are more products for one purchaser if (!isset($not_put[$tmp_purchaser_id])) { if ($days > 15) { $days = 15; } if (!isset($statistics[$tmp_purchaser_id]['delay_times'])) { $statistics[$tmp_purchaser_id]['delay_times'] = array(); } if (!isset($statistics[$tmp_purchaser_id]['delay_times'][$days])) { $statistics[$tmp_purchaser_id]['delay_times'][$days] = 0; } $statistics[$tmp_purchaser_id]['delay_times'][$days]++; $not_put[$tmp_purchaser_id] = TRUE; if ($days > 2) { if (isset($user_name_map[$tmp_purchaser_id])) { $user_name = $user_name_map[$tmp_purchaser_id]; } else { $user_name = fetch_user_name_by_id($tmp_purchaser_id); $user_name_map[$tmp_purchaser_id] = $user_name; } $item_nos[] = array($user_name, $days, $row->item_no, $row->sku_str, $row->sys_remark); } } if (!isset($statistics[$tmp_purchaser_id]['skus'])) { $statistics[$tmp_purchaser_id]['skus'] = $qties[$i]; } else { $statistics[$tmp_purchaser_id]['skus'] += $qties[$i]; } $i++; } } $key = 'purchase_statistics_item_nos'; if ($purchaser_id) { $key = 'purchase_statistics_item_nos_' . $purchaser_id; } else { if ($priority == 1) { $key = 'purchase_statistics_item_nos_' . $current_user_id; } } $this->cache->file->save($key, $item_nos, 60 * 60 * 24 * 30); // 30 days return $statistics; }
} $total_price += $price; $data[] = array(fetch_user_name_by_id($group->u_id), $sku, $product['order'][$sku], $qty, $price); if (!isset($orders[$group->u_id])) { $orders[$group->u_id] = $product['order'][$sku]; } else { $orders[$group->u_id] += $product['order'][$sku]; } if (!isset($qties[$group->u_id])) { $qties[$group->u_id] = $qty; } else { $qties[$group->u_id] += $qty; } $index++; } $data[] = array(fetch_user_name_by_id($group->u_id) . '(' . lang('statistics') . ')', lang('develop_product_count') . ': ' . $index, lang('total_order_count') . ': ' . $orders[$group->u_id], lang('sale_total_product_count') . ': ' . $qties[$group->u_id], lang('total_sale_amount') . ': ' . $total_price); } if ($priority > 1 || $CI->is_super_user()) { if ('developer' == $role) { echo block_header(lang('develop_department_statistics')); } else { echo block_header(lang('purchase_department_statistics')); } } else { echo block_header(lang('personal_development_statistical')); } echo '<br/>'; echo form_open(site_url('purchase/statistics/department_development_statistics', array('role' => $role))); echo lang('develop_time') . ': ' . lang('from') . ' ' . block_time_picker('begin_time', $begin_time) . ' '; echo lang('to') . ' ' . block_time_picker('end_time', $end_time) . '<br/><br/>'; echo lang('sale_time') . ': ' . lang('from') . ' ' . block_time_picker('sale_begin_time', $sale_begin_time) . ' ';
<?php $head = array(array('text' => lang('type'), 'sort_key' => 'type', 'id' => 'seo_integral'), array('text' => lang('catalog'), 'sort_key' => 'content_id'), array('text' => lang('username'), 'sort_key' => 'user.id'), array('text' => lang('integral'), 'sort_key' => 'integral'), array('text' => lang('verifyer'), 'sort_key' => 'reviewer_id'), array('text' => lang('verify_date'), 'sort_key' => 'created_date')); $data = array(); foreach ($integrals as $integral) { $category = $this->seo_model->fetch_content_info($integral->content_id, $integral->type, $integral->user_id); $data[] = array(lang($integral->type), isset($category->type_name) ? $category->type_name : '', $integral->u_name, $integral->integral, fetch_user_name_by_id($integral->reviewer_id), $integral->created_date); } $options = array('' => lang('all'), 'content' => lang('content'), 'resource' => lang('resource'), 'release' => lang('release')); $users = $this->user_model->fetch_users_by_system_code('seo'); $priority = $this->user_model->fetch_user_priority_by_system_code('seo'); $user_options = array(); $user_options[''] = lang('all'); foreach ($users as $user) { $user_options[$user->u_id] = $user->u_name; } $filters = array(array('type' => 'dropdown', 'field' => 'type', 'options' => $options, 'method' => '='), NULl); $CI =& get_instance(); if ($priority > 1 || $CI->is_super_user()) { $filters[] = array('type' => 'dropdown', 'field' => 'user.id', 'options' => $user_options, 'method' => '='); } else { $filters[] = NULL; } $filters[] = array('type' => 'input', 'field' => 'integral'); $filters[] = NULL; $filters[] = array('type' => 'date', 'field' => 'created_date', 'method' => 'from_to'); if ($CI->is_super_user() || $priority > 1) { $title = lang('integral'); } else { $user_id = get_current_user_id(); $total_integral = fetch_user_all_integrals($user_id);
if ('-2' == $resource->status) { $status = lang('closed'); } else { if ('-1' == $resource->status) { $status = lang('validate_failure'); } else { if ('0' == $resource->status) { $status = lang('wait_to_validate'); } else { $status = lang('validate'); } } } } $item = array(anchor(site_url('seo/content_edit/add_edit', array('id' => $resource->content_id)), $resource->title), anchor(site_url('seo/resource/add_edit', array('id' => $resource->resource_id)), $resource->url), $resource->con_type, $resource->res_category); $item[] = fetch_user_name_by_id($resource->owner_id); // $item[] = $resource->validate_url; $edit_button = $this->block->generate_edit_link(site_url('seo/release/update_validate_url', array($resource->id))); $validate_limit = string_limiter($resource->validate_url, 0, 20); $item[] = "<a href='{$resource->validate_url}' title='{$resource->validate_url}' target='_blank'>" . $validate_limit . "</a>" . $edit_button; $item[] = $resource->created_date; $item[] = $resource->remark; $item[] = $status; if ($priority > 1 && ($resource->status == '-1' || $resource->status == '0') || $CI->is_super_user() && ($resource->status == '-1' || $resource->status == '0') || $priority > 1 && 'personal' == $tag && ($resource->status == '-1' || $resource->status == '0')) { $url_successful = site_url('seo/release/released_validate', array('successful')); $config_successful = array('name' => 'submit', 'value' => lang('handwork_validate_successful'), 'type' => 'button', 'style' => 'margin:10px', 'onclick' => "handwork_validate(this, '{$url_successful}', {$resource->id}, 0, false);"); $url_failure = site_url('seo/release/released_validate', array('failure')); $config_failure = array('name' => 'submit', 'value' => lang('handwork_validate_failure'), 'type' => 'button', 'style' => 'margin:10px', 'onclick' => "handwork_validate(this, '{$url_failure}', {$resource->id}, 0, true);"); // echo '<h2>'.block_button($config).'</h2>'; $item[] = block_button($config_successful) . br() . block_button($config_failure); } else {
public function down_order_excel($id) { //$this->load->library('PHPExcel'); //$this->load->library('PHPExcel/IOFactory'); require_once APPPATH . 'libraries/PHPExcel' . EXT; require_once APPPATH . 'libraries/PHPExcel/IOFactory' . EXT; require_once APPPATH . 'libraries/PHPExcel/Worksheet/Drawing' . EXT; $CI =& get_instance(); $order = $this->order_model->get_order($id); //var_dump($order);die(); if ($order) { $print_date = date('Y.m.d'); $user = fetch_user_name_by_id(fetch_user_id_by_login_name($order->input_user)); $country_cn_name = get_country_name_cn($order->country); $objPHPExcel = new PHPExcel(); $objPHPExcel->createSheet(); //创建sheet $objPHPExcel->setActiveSheetIndex(0); $objActSheet = $objPHPExcel->getActiveSheet(); $objPHPExcel->getProperties()->setCreator("mallerp")->setLastModifiedBy("mallerp")->setTitle("Ebay ShipOrder List")->setSubject("Ebay ShipOrder List")->setDescription("Mansea, Mallerp, zhaosenlin, 278203374, 7410992")->setKeywords("Mansea, Mallerp, zhaosenlin, 278203374, 7410992")->setCategory("mallerp"); $objActSheet->getColumnDimension('E')->setWidth(20); $objActSheet->getColumnDimension('A')->setWidth(0); /*excel表头*/ $objPHPExcel->getActiveSheet()->setCellValue('A1', ''); $objPHPExcel->getActiveSheet()->setCellValue('A2', ''); $objPHPExcel->getActiveSheet()->setCellValue('A3', ''); $objPHPExcel->getActiveSheet()->setCellValue('A4', ''); $objActSheet->getStyle('B1:B4')->getFont()->setSize(12); $objActSheet->getStyle('B1:B4')->getFont()->setBold(true); $objActSheet->getStyle('D1:D4')->getFont()->setBold(true); $objActSheet->getStyle('F1:F4')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->mergeCells('H1:M4'); $objPHPExcel->getActiveSheet()->setCellValue('B1', '业务员'); $objPHPExcel->getActiveSheet()->setCellValue('C1', $user); $objPHPExcel->getActiveSheet()->setCellValue('D1', 'ERP订单号'); $objPHPExcel->getActiveSheet()->setCellValue('E1', $order->item_no); $objPHPExcel->getActiveSheet()->setCellValue('F1', '日期'); $objPHPExcel->getActiveSheet()->setCellValue('G1', $print_date); $objPHPExcel->getActiveSheet()->setCellValue('H1', '备注:' . $order->note); $objPHPExcel->getActiveSheet()->setCellValue('B2', '客户名称'); $objPHPExcel->getActiveSheet()->setCellValue('C2', $order->name); $objPHPExcel->getActiveSheet()->setCellValue('D2', '国家'); $objPHPExcel->getActiveSheet()->setCellValue('E2', $country_cn_name); $objPHPExcel->getActiveSheet()->setCellValue('F2', '运输方式'); $objPHPExcel->getActiveSheet()->setCellValue('G2', $order->is_register); $objPHPExcel->getActiveSheet()->setCellValue('B3', '订单总额$'); $objPHPExcel->getActiveSheet()->setCellValue('C3', $order->gross); $objPHPExcel->getActiveSheet()->setCellValue('D3', '运费$'); $objPHPExcel->getActiveSheet()->setCellValue('E3', $order->shippingamt); $objPHPExcel->getActiveSheet()->setCellValue('F3', '付款方式'); $objPHPExcel->getActiveSheet()->setCellValue('G3', $order->payment_type); $objPHPExcel->getActiveSheet()->setCellValue('B4', '订单总额¥'); $objPHPExcel->getActiveSheet()->setCellValue('C4', $order->gross * $order->ex_rate); $objPHPExcel->getActiveSheet()->setCellValue('D4', '运费¥'); $objPHPExcel->getActiveSheet()->setCellValue('E4', $order->shippingamt * $order->ex_rate); $objPHPExcel->getActiveSheet()->setCellValue('F4', '实际运费'); $objPHPExcel->getActiveSheet()->setCellValue('G4', ''); $objPHPExcel->getActiveSheet()->setCellValue('H4', '交易号'); $objPHPExcel->getActiveSheet()->setCellValue('I4', $order->transaction_id); //$objPHPExcel->getActiveSheet()->mergeCells("F5":"G5":"H5"); $objActSheet->getStyle('B5:M5')->getFont()->setSize(12); $objActSheet->getStyle('B5:M5')->getFont()->setBold(true); $objPHPExcel->getActiveSheet()->mergeCells('F5:H5'); $objPHPExcel->getActiveSheet()->setCellValue('B5', '货架号'); $objPHPExcel->getActiveSheet()->setCellValue('C5', 'SKU'); $objPHPExcel->getActiveSheet()->setCellValue('D5', '数量'); $objPHPExcel->getActiveSheet()->setCellValue('E5', '图片'); $objPHPExcel->getActiveSheet()->setCellValue('F5', '中文名称'); $objPHPExcel->getActiveSheet()->setCellValue('I5', '单价$'); $objPHPExcel->getActiveSheet()->setCellValue('J5', '单价¥'); $objPHPExcel->getActiveSheet()->setCellValue('K5', '总价¥'); $objPHPExcel->getActiveSheet()->setCellValue('L5', '成本¥'); $objPHPExcel->getActiveSheet()->setCellValue('M5', '利润¥'); $skus = explode(',', $order->sku_str); $qties = explode(',', $order->qty_str); $item_prices = explode(',', $order->item_price_str); $i = 5; foreach ($skus as $key => $sku) { $i++; $sql1 = 'name_cn,shelf_code,sale_price,image_url,price'; $myproduct = $CI->product_model->fetch_product_by_sku($sku, $sql1); $image = ""; if ($myproduct->image_url != '' && $myproduct->image_url != NULL && $myproduct->image_url != 'none') { if (strpos($myproduct->image_url, 'http://') !== false) { $image = "/var/www/html/mallerp/static/images/404-error.png"; } else { $image = '/var/www/html/mallerp' . $myproduct->image_url; } } else { $image = "/var/www/html/mallerp/static/images/404-error.png"; } //die($image); $objActSheet->getRowDimension($i)->setRowHeight(100); $objActSheet->getStyle('B' . $i . ':M' . $i)->getFont()->setSize(12); $objPHPExcel->getActiveSheet()->mergeCells('F' . $i . ':H' . $i); $objPHPExcel->getActiveSheet()->setCellValue('B' . $i, $myproduct->shelf_code); $objPHPExcel->getActiveSheet()->setCellValue('C' . $i, $sku); $objPHPExcel->getActiveSheet()->setCellValue('D' . $i, $qties[$key]); $objDrawing = new PHPExcel_Worksheet_Drawing(); $objDrawing->setName('avatar'); $objDrawing->setDescription('avatar'); $objDrawing->setPath($image); $objDrawing->setHeight(100); $objDrawing->setWidth(100); $objDrawing->setCoordinates('E' . $i); $objDrawing->setWorksheet($objPHPExcel->getActiveSheet()); //$objPHPExcel->getActiveSheet()->setCellValue('E'.$i, '图片'); $objPHPExcel->getActiveSheet()->setCellValue('F' . $i, $myproduct->name_cn); $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, isset($item_prices[$key]) ? $item_prices[$key] : 0); $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, isset($item_prices[$key]) ? $item_prices[$key] : 0 * $order->ex_rate); $objPHPExcel->getActiveSheet()->setCellValue('K' . $i, isset($item_prices[$key]) ? $item_prices[$key] : 0 * $order->ex_rate * $qties[$key]); $objPHPExcel->getActiveSheet()->setCellValue('L' . $i, ''); $objPHPExcel->getActiveSheet()->setCellValue('M' . $i, ''); } } $filename = date("Y-m-d_H_i_s") . '.xls'; ob_end_clean(); header('Content-Type: application/vnd.ms-excel'); header('Content-Disposition: attachment;filename=' . $filename); header('Cache-Control: max-age=0'); $objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); $objWriter->save('php://output'); }
<?php $url = site_url('admin/crontab/crontab_add_row'); $add_button = $this->block->generate_add_icon($url); $head = array(lang('on'), lang('job'), lang('description'), lang('creator'), lang('created_date'), lang('options') . $add_button); $data = array(); $crontab_url = site_url('admin/crontab/verify_crontab'); foreach ($crontabresult as $show_result) { $drop_button = $this->block->generate_drop_icon('admin/crontab/crontab_delete', "{id: {$show_result->id}}", TRUE); $data[] = array($this->block->generate_div("on_{$show_result->id}", empty($show_result->on) ? '[edit]' : $show_result->on), $this->block->generate_div("job_{$show_result->id}", empty($show_result->job) ? '[edit]' : $show_result->job), $this->block->generate_div("description_{$show_result->id}", empty($show_result->description) ? '[edit]' : $show_result->description), fetch_user_name_by_id($show_result->creator), $show_result->created_date, $drop_button); echo $this->block->generate_editor("on_{$show_result->id}", 'crontab_view_form', $crontab_url, "{id: {$show_result->id} ,type: 'on'}"); echo $this->block->generate_editor("job_{$show_result->id}", 'crontab_view_form', $crontab_url, "{id: {$show_result->id} ,type: 'job'}"); echo block_editor("description_{$show_result->id}", 'crontab_view_form', $crontab_url, "{id: {$show_result->id} ,type: 'description'}"); } $title = lang('admin_crontab'); echo block_header($title); echo $this->block->generate_table($head, $data); $activate_crontab_url = site_url('admin/crontab/activate_crontab'); $view_crontab_url = site_url('admin/crontab/view_crontab_list'); $config = array('name' => 'activate_crontab', 'id' => 'activate_crontab', 'value' => lang('activate_crontab_again'), 'type' => 'button', 'onclick' => "helper.ajax('{$activate_crontab_url}', {}, 1);"); $activate_crontab = '<div style="float: right; ">'; echo br(); $activate_crontab .= block_button($config); $attributes = "onclick=\"helper.update_content('{$view_crontab_url}', {}, 'crontab_list_div'); return false;\""; $activate_crontab .= ' ' . anchor(current_url(), lang('view_crontab_list'), $attributes); $activate_crontab .= '</div>'; echo $activate_crontab; echo '<div style="clear:both;"></div>'; echo '<div id="crontab_list_div" style="display:none;"></div>';
<?php $head = array(lang('purchaser'), lang('sale_amount'), lang('stock_summation_count'), lang('ito_monthly')); $data = array(); foreach ($statistics as $row) { $ito = empty($row->stock_amount) ? price($row->sale_amount / 1, 4) : price($row->sale_amount / $row->stock_amount, 4); $ito = $ito * 100 . '%'; $data[] = array(fetch_user_name_by_id($row->purchaser_id), $row->sale_amount, $row->stock_amount, $ito); } echo block_header(lang('department_month_ito_statistics')); $start_year = 2004; $end_year = date('Y'); $years = array(); for ($i = $start_year; $i <= $end_year; $i++) { $years[$i] = $i; } $months = array(); for ($i = 1; $i <= 12; $i++) { $months[$i] = $i; } echo form_open(current_url()); echo br(); echo form_label(lang('year')) . ': ' . form_dropdown('year', $years, $year); echo repeater(' ', 3); echo form_label(lang('month')) . ': ' . form_dropdown('month', $months, $month); echo repeater(' ', 3); $config = array('name' => 'submit', 'value' => lang('submit'), 'type' => 'submit'); echo block_button($config); echo form_close(); $sortable = array('default', 'integer', 'integer', 'float'); echo block_js_sortable_table($head, $data, $sortable);
$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; if ($priority > 1 || $CI->is_super_user()) { $row[] = fetch_user_name_by_id($order->saler_id); } $data[] = $row; } $users = $this->user_model->fetch_users_by_system_code('sale'); $user_options = array(); $user_options[''] = lang('all'); foreach ($users as $user) { $user_options[$user->u_id] = $user->u_name; } echo block_header(lang('view_order')); $filters = array(null, array('type' => 'input', 'field' => 'item_no|name|shipping_address|buyer_id'), array('type' => 'input', 'field' => 'item_title_str|item_id_str|sku_str|is_register'), array('type' => 'input', 'field' => 'gross|transaction_id|descript|track_number'), array('type' => 'input', 'field' => 'ship_confirm_date|ship_weight|ship_confirm_user'), $this->block->generate_search_dropdown('order_status', 'order_status'), array('type' => 'date', 'field' => 'input_date', 'method' => 'from_to')); if ($priority > 1 || $CI->is_super_user()) { $filters[] = array('type' => 'dropdown', 'field' => 'user_saler_input_user_map.saler_id', 'options' => $user_options, 'method' => '='); } $config = array('filters' => $filters);
<?php $head = array(array('text' => lang('content_catalog'), 'sort_key' => 'seo_content_catalog.name', 'id' => 'content_integral'), array('text' => lang('title'), 'sort_key' => 'title'), array('text' => lang('integral'), 'sort_key' => 'integral'), array('text' => lang('creator'), 'sort_key' => 'owner_id'), array('text' => lang('created_date'), 'sort_key' => 'update_date'), lang('options')); $data = array(); $code_url = site_url('seo/content_edit/verify_content'); foreach ($contents as $content) { $drop_button = $this->block->generate_drop_icon('seo/content_edit/drop_content_review', "{id: {$content->content_id}}", TRUE); $edit_button = $this->block->generate_edit_link(site_url('seo/content_edit/add_edit', array($content->content_id))); $url = $drop_button . $edit_button; $data[] = array($content->catalog_name, $content->title, $content->integral, fetch_user_name_by_id($content->owner_id), $content->update_date, $url); } $filters = array(array('type' => 'input', 'field' => 'seo_content_catalog.name'), array('type' => 'input', 'field' => 'title'), array('type' => 'input', 'field' => 'integral'), NULL, array('type' => 'input', 'field' => 'update_date')); $title = lang('content_pending'); echo block_header($title); echo form_open(); echo $this->block->generate_pagination('content_integral'); $config = array('filters' => $filters); echo $this->block->generate_reset_search($config); echo $this->block->generate_table($head, $data, $filters, 'content_integral'); echo $this->block->generate_pagination('content_integral'); echo form_close();
$data = array(); $saler_url = site_url('sale/sale_order/verify_saler_input_user'); foreach ($salers as $saler) { $drop_button = $this->block->generate_drop_icon('sale/sale_order/drop_saler_input_user', "{id: {$saler->saler_id}}", TRUE); $more_button = block_more_icon('sale/sale_order/saler_add_input_user', "{saler_id: {$saler->saler_id}}"); $input_user_url = site_url('sale/sale_order/verify_input_user'); $input_users = $this->sale_order_model->saler_fetch_input_users($saler->saler_id); $input_users_str = ''; foreach ($input_users as $inputuser) { if ('void' == $inputuser->paypal_email) { $input_user = '******'; } else { $input_user = $inputuser->paypal_email; } $input_users_str .= $this->block->generate_div("input_user_{$inputuser->id}", $input_user) . '<br>'; echo $this->block->generate_editor("input_user_{$inputuser->id}", 'sale_order_form', $input_user_url, "{id: {$inputuser->id}, type: 'paypal_email'}", "{$input_user_collection}"); } $input_users_str .= $more_button; $data[] = array($this->block->generate_div("saler_{$saler->saler_id}", isset($saler) && $saler->saler_id != '0' ? fetch_user_name_by_id($saler->saler_id) : '[edit]'), $input_users_str, block_div("saler_in_operation_{$saler->saler_id}", $saler->in_operation == 1 ? $yes : $no), $drop_button); echo $this->block->generate_editor("saler_{$saler->saler_id}", 'sale_order_form', $saler_url, "{id: {$saler->saler_id}, type: 'saler_id'}", "{$collection}"); echo $this->block->generate_editor("saler_in_operation_{$saler->saler_id}", 'sale_order_form', $saler_url, "{id: {$saler->saler_id}, type: 'in_operation'}", $in_operation_collection); } $title = lang('sale_setting'); echo block_header($title); echo form_open(); echo $this->block->generate_table($head, $data); echo form_close(); echo block_notice_div(lang('note') . ": " . lang('sale_input_user_notice')); ?>
$CI =& get_instance(); $head = array(array('text' => lang('content'), 'sort_key' => 'content_item', 'id' => 'work_rewards'), array('text' => lang('department'), 'sort_key' => 'department'), array('text' => lang('processing_result'), 'sort_key' => 'result'), array('text' => lang('work_rewards_error_person'), 'sort_key' => 'worker_id'), array('text' => lang('order_number'), 'sort_key' => 'order_no'), array('text' => lang('author'), 'sort_key' => 'author'), array('text' => lang('document_catalog'), 'sort_key' => 'type'), array('text' => lang('processing_status'), 'sort_key' => 'status'), array('text' => lang('custom_date'), 'sort_key' => 'created_time'), lang('options')); $data = array(); $priority = $this->user_model->fetch_user_priority_by_system_code('executive'); $dept = array(); $dept[''] = lang('all'); foreach ($department_arr as $department) { $dept[$department->department] = str_replace('制度', '', $this->work_rewards_model->get_dept_name_by_id($department->department)); } foreach ($work_rewards_errors as $work_rewards_error) { $drop_button = $this->block->generate_drop_icon('myinfo/myaccount/drop_work_rewards_error', "{id: {$work_rewards_error->id}}", TRUE); $id = $work_rewards_error->id; $work_id_arr = $this->work_rewards_model->fetch_worker_by_id($id); $worker = array(); foreach ($work_id_arr as $work_id) { $worker[] = fetch_user_name_by_id($work_id['worker_id']); } $worker_id = implode(',', $worker); $edit_button = $this->block->generate_edit_link(site_url('myinfo/myaccount/work_rewards_error_edit', array($work_rewards_error->id)), FALSE); $department = $this->document_catalog_model->fetch_name_by_dept_id($work_rewards_error->department); if ($CI->is_super_user() or $priority > 1) { $drop_button .= $edit_button; } else { $drop_button = $edit_button; } $data[] = array(trim_right(substr($work_rewards_error->content_item, 0, 100)), $department, $work_rewards_error->result, $worker_id, $work_rewards_error->order_no, $work_rewards_error->author, lang($work_rewards_error->type), lang($work_rewards_error->status), $work_rewards_error->created_time, $drop_button); } $filters = array(array('type' => 'input', 'field' => 'content_item'), array('type' => 'dropdown', 'field' => 'department', 'options' => $dept), array('type' => 'input', 'field' => 'result'), array('type' => 'input', 'field' => 'name'), array('type' => 'input', 'field' => 'order_no'), array('type' => 'input', 'field' => 'author')); $type = array('' => lang('please_select'), 'reward' => lang('reward'), 'pulish' => lang('pulish')); $filters[] = array('type' => 'dropdown', 'field' => 'type', 'options' => $type, 'method' => '='); $status = array('' => lang('please_select'), 'wait_for_proccess' => lang('wait_for_proccess'), 'completed' => lang('completed'));
<?php $CI =& get_instance(); $head = array(lang('purchaser'), lang('sku'), lang('market_model'), lang('sale_product_count'), lang('sale_amount')); $data = array(); $current_user_id = get_current_user_id(); if (isset($statistics[$current_user_id])) { $sale_statistics = $statistics[$current_user_id]; } else { $sale_statistics = array(); } foreach ($statistics as $purchaser_id => $sale_statistics) { $sku_count = 0; $total_qty = 0; $total_price = 0; $purchaser_name = fetch_user_name_by_id($purchaser_id); foreach ($sale_statistics as $sku => $qty) { if (isset($sku_prices[$sku])) { $price = $sku_prices[$sku] * $qty; } else { $price = $CI->product_model->fetch_cost_by_sku($sku) * $qty; } $total_price += $price; $market_model = get_product_market_model($sku); $data[] = array($purchaser_name, $sku, $market_model, $qty, $price); $sku_count++; $total_qty += $qty; } $data[] = array($purchaser_name . '(' . lang('statistics') . ')', lang('sku_count') . ': ' . $sku_count, NULL, lang('sale_product_count') . ': ' . $total_qty, lang('total_sale_amount') . ': ' . $total_price); } echo block_header(lang('department_purchase_sale_statistics'));
public function fetch_purchase_list($purchaser_filter = -1, $qt = FALSE) { $user_id = get_current_user_id(); if ($qt) { $show_purchaser_filter = TRUE; //$where = "((stock_count + on_way_count) < dueout_count + min_stock_number) AND (min_stock_number > 0 OR (dueout_count > 0))"; $where = "((stock_count) < min_stock_number) AND (min_stock_number > 0 )"; } else { $show_purchaser_filter = $this->show_purchaser_filter(); //$where = "((stock_count) < dueout_count + min_stock_number) AND (min_stock_number > 0 OR (dueout_count > 0)) OR ((uk_stock_count) < uk_dueout_count + uk_min_stock_number) AND (uk_min_stock_number > 0 OR (uk_dueout_count > 0)) OR ((de_stock_count) < de_dueout_count + de_min_stock_number) AND (de_min_stock_number > 0 OR (de_dueout_count > 0)) OR ((au_stock_count) < au_dueout_count + au_min_stock_number) AND (au_min_stock_number > 0 OR (au_dueout_count > 0))"; $where = "((stock_count) < min_stock_number) AND (min_stock_number > 0) OR ((uk_stock_count) < uk_min_stock_number) AND (uk_min_stock_number > 0 ) OR ((de_stock_count) < de_min_stock_number) AND (de_min_stock_number > 0 ) OR ((au_stock_count) < au_min_stock_number) AND (au_min_stock_number > 0 ) OR ((yb_stock_count) < yb_min_stock_number) AND (yb_min_stock_number > 0 )"; } $sql = <<<SQL SELECT id, market_model, stock_count, min_stock_number, image_url, dueout_count, stock_count, min_stock_number, on_way_count, \tau_on_way_count, de_on_way_count, uk_on_way_count, \tyb_on_way_count, (min_stock_number -(stock_count + on_way_count)) as purchase_suggestion, (uk_min_stock_number -(uk_stock_count + uk_on_way_count)) as uk_purchase_suggestion, (de_min_stock_number -(de_stock_count + de_on_way_count)) as de_purchase_suggestion, (au_min_stock_number -(au_stock_count + au_on_way_count)) as au_purchase_suggestion, \t(yb_min_stock_number -(yb_stock_count + yb_on_way_count)) as yb_purchase_suggestion, purchaser_id, au_dueout_count, de_dueout_count, uk_dueout_count, \tyb_dueout_count, au_stock_count, de_stock_count, uk_stock_count, \tyb_stock_count, au_min_stock_number, de_min_stock_number, \tyb_min_stock_number, uk_min_stock_number FROM product_basic WHERE {$where} SQL; $query = $this->db->query($sql); $result = $query->result_array(); if (!isset($this->CI->product_model)) { $this->CI->load->model('product_model'); } if (!isset($this->CI->product_catalog_model)) { $this->CI->load->model('product_catalog_model'); } if (!isset($this->CI->stock_model)) { $this->CI->load->model('stock_model'); } $colors = array('black', 'blue', 'green'); foreach ($result as $key => $row) { $purchaser_id = 0; $basic = $this->CI->product_model->fetch_product_basic($row['id']); if (isset($row['purchaser_id'])) { $purchaser_id = $row['purchaser_id']; } if ($purchaser_id <= 0) { $purchaser_id = $this->CI->product_catalog_model->fetch_purchaser_id($basic->catalog_id); } if ($purchaser_filter == -1) { if (!$show_purchaser_filter) { if ($purchaser_id != $user_id) { unset($result[$key]); continue; } } } else { if (!$show_purchaser_filter) { unset($result[$key]); continue; } if ($purchaser_filter != $purchaser_id) { unset($result[$key]); continue; } } $result[$key]['purchaser'] = fetch_user_name_by_id($purchaser_id); $result[$key]['sku'] = $basic->sku; $result[$key]['name_cn'] = $basic->name_cn; $providers = $this->product_model->fetch_product_providers($row['id'], 3); $provider_str = ''; $i = 0; foreach ($providers as $provider) { $price_url = site_url('purchase/provider/provider_sku_manage', array($provider->m_provider_id)); $provider_url = site_url('purchase/provider/edit', array($provider->m_provider_id)); $object = $this->fetch_provider($provider->m_provider_id); $name = isset($object->name) ? $object->name : ''; $contact_person = isset($object->contact_person) ? $object->contact_person : ''; $phone = isset($object->phone) ? $object->phone : ''; $mobile = isset($object->mobile) ? $object->mobile : ''; $provider_str .= <<<STR <a href='{$price_url}' target='_blank'> <span style='color: {$colors[$i]};'> {$provider->m_price1to9}|{$provider->m_price10to99}|{$provider->m_price100to999} </span> </a> / <a href='{$provider_url}' target='_blank'> <span style='color: {$colors[$i]};'> {$name} {$contact_person} {$phone} {$mobile} </span> </a> <br/> STR; $i++; } $provider_str = trim($provider_str, '<br/>'); $result[$key]['providers'] = $provider_str; $result[$key]['7_days_sale_amount'] = $basic->sale_in_7_days; $result[$key]['30_days_sale_amount'] = $basic->sale_in_30_days; $result[$key]['60_days_sale_amount'] = $basic->sale_in_60_days; } uasort($result, array($this, 'sort_by_purchaser')); return $result; }