| // | Your Name | // +----------------------------------------------------------------------+ // // $Id:$ /** * lionfish 商城系统 * * ========================================================================== * @link http://www.liofis.com/ * @copyright Copyright (c) 2015 liofis.com. * @license http://www.liofis.com/license.html License * ========================================================================== * * @author fish * */ namespace Seller\Controller; class DeliveryController extends CommonController { protected function _initialize() { parent::_initialize(); } public function index() { $gpc = I('request.'); $pindex = max(1, intval($gpc['page'])); $psize = 20; $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['time']['start']) ? strtotime($gpc['time']['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['time']['end']) ? strtotime($gpc['time']['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); $this->searchtime = $searchtime; $this->starttime = $starttime; $this->endtime = $endtime; $condition = ""; if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and d.create_time > {$starttime} and d.create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and d.express_time > {$starttime} and d.express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and d.head_get_time > {$starttime} and d.head_get_time < {$endtime} "; } } if (!empty($gpc['keyword'])) { $gpc['keyword'] = trim($gpc['keyword']); $condition.= ' and (d.head_name like "%' . $gpc['keyword'] . '%" or d.head_mobile like "%' . $gpc['keyword'] . '%" or d.line_name like "%' . $gpc['keyword'] . '%" or d.clerk_name like "%' . $gpc['keyword'] . '%" or d.clerk_mobile like "%' . $gpc['keyword'] . '%" or h.community_name like "%' . $gpc['keyword'] . '%" )'; } if (isset($gpc['export']) && $gpc['export'] > 0) { @set_time_limit(0); $excel_title = ""; $search_tiaoj = ""; if (!empty($searchtime)) { if ($searchtime == 'create_time') { $excel_title.= "创建清单时间:" . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); $search_tiaoj.= "清单时间： " . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); } if ($searchtime == 'express_time') { $excel_title.= "配送时间:" . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); $search_tiaoj.= "配送时间： " . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); } if ($searchtime == 'head_get_time') { $excel_title.= "送达时间:" . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); $search_tiaoj.= "送达时间： " . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); } } $excel_title = ""; if (!empty($gpc['keyword'])) { $excel_title.= $gpc['keyword']; $search_tiaoj.= "关键词： " . $gpc['keyword']; } $list = M()->query('SELECT d.*,h.community_name FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist as d , " . C('DB_PREFIX') . "lionfish_community_head as h WHERE d.head_id = h.id " . $condition . ' order by d.id desc '); //导出商品总单 if ($gpc['export'] == 1) { $is_export_deliverygoods_category = D('Home/Front')->get_config_by_name('is_export_deliverygoods_category'); $is_export_deliverygoods_supply = D('Home/Front')->get_config_by_name('is_export_deliverygoods_supply'); $columns = array( array( 'title' => '商品名称', 'field' => 'goods_name', 'width' => 24 ) , array( 'title' => '商品规格', 'field' => 'sku_name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 12 ) , array( 'title' => '金额', 'field' => 'total_price', 'width' => 12 ) , ); if( isset($is_export_deliverygoods_category) && $is_export_deliverygoods_category == 1 ) { $columns[] = array( 'title' => '所属分类', 'field' => 'category_name', 'width' => 24 ); } if( isset($is_export_deliverygoods_supply) && $is_export_deliverygoods_supply == 1 ) { $columns[] = array( 'title' => '所属供应商', 'field' => 'supply_name', 'width' => 24 ); } $list_id_arr = array(); foreach ($list as $val) { $list_id_arr[] = $val['id']; } $need_goods_list = array(); if (!empty($list_id_arr)) { $goods_list = M('lionfish_comshop_deliverylist_goods')->where("list_id in ( " . implode(',', $list_id_arr) . " )")->select(); foreach ($goods_list as $val) { if (empty($need_goods_list) || !in_array($val['goods_id'] . '_' . $val['rela_goodsoption_valueid'], array_keys($need_goods_list))) { //goods_id rela_goodsoption_valueid $price = 0; if (!empty($val['rela_goodsoption_valueid'])) { $price_value = M('lionfish_comshop_order_goods')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->find(); $price = $price_value['price']; } else { $price_value = M('lionfish_comshop_goods')->field('price')->where(array( 'id' => $val['goods_id'] ))->find(); $price = $price_value['price']; } $gd_info = M('lionfish_comshop_good_common')->field('supply_id')->where( array('goods_id' => $val['goods_id'] ) )->find(); $supply_name = '平台'; if( $gd_info['supply_id'] > 0 ) { $supply_info = M('lionfish_comshop_supply')->field('shopname,type')->where( array('id' => $gd_info['supply_id'] ) )->find(); if( !empty($supply_info) ) { if( $supply_info['type'] == 1 ) { $supply_name = $supply_info['shopname'].'(独立供应商)'; }else{ $supply_name = $supply_info['shopname'].'(平台供应商)'; } } } $category_name = ""; $cate_list = M('lionfish_comshop_goods_to_category')->where( array('goods_id' => $val['goods_id'] ) )->select(); $cate_arr = array(); if( !empty($cate_list) ) { foreach( $cate_list as $c_val ) { $ct_info = M('lionfish_comshop_goods_category')->field('name')->where( array('id' => $c_val['cate_id'] ) )->find(); if( !empty($ct_info) ) { $cate_arr[] = $ct_info['name']; } } $category_name = implode('、', $cate_arr); } //supply_name $val['goods_id'] $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = array( 'quantity' => $val['goods_count'], 'price' => $price, 'total_price' => ($val['goods_count'] * $price) , 'sku_name' => $val['sku_str'], 'supply_name' => $supply_name, 'category_name' => $category_name, 'goods_name' => $val['goods_name'] ); } else { $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity']+= $val['goods_count']; $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['total_price'] = $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity'] * $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['price']; } } } $last_index_sort = array_column($need_goods_list, 'goods_name'); array_multisort($last_index_sort, SORT_ASC, $need_goods_list); $lists_info = array( 'line1' => '商品拣货单', 'line2' => '检索条件: ' . $search_tiaoj, ); D('Seller/Excel')->export_delivery_goodslist($need_goods_list, array( 'list_info' => $lists_info, 'title' => '商品拣货单', 'columns' => $columns )); } //导出团长总单 if ($gpc['export'] == 2) { //导出配送总单 $columns = array( array( 'title' => '序号', 'field' => 'sn', 'width' => 12 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 20 ) , array( 'title' => '商品名称', 'field' => 'goods_name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '商品规格', 'field' => 'sku_name', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 12 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 12 ) , ); //----------------- 这里要合并开始 downexcel--------------------- $tuanz_data_list = array(); $exportlist = array(); $list_id_arr = array(); foreach ($list as $val) { $list_id = $val['id']; $list_data = M('lionfish_comshop_deliverylist_goods')->where(array( 'list_id' => $list_id ))->order('id desc')->select(); $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); if ($val['clerk_id'] > 0) { $clerk_name = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $val['clerk_id'] ))->find(); $list_info['clerk_info'] = $clerk_name['name']; } if (!isset($exportlist[$list_info['head_id']])) { $exportlist[$list_info['head_id']] = array( 'list_info' => $list_info, 'data' => array() ); } $i = 1; foreach ($list_data as $val) { $tmp_exval = array(); $tmp_exval['num_no'] = $i; $tmp_exval['name'] = $val['goods_name']; $tmp_exval['quantity'] = $val['goods_count']; $tmp_exval['sku_str'] = $val['sku_str']; $gd_info = M('lionfish_comshop_goods')->field('codes')->where(array( 'id' => $val['goods_id'] ))->find(); $tmp_exval['goods_goodssn'] = $gd_info['codes']; $info = M('lionfish_comshop_order_goods')->field('price')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->order('order_goods_id desc')->find(); $tmp_exval['price'] = $info['price']; $tmp_exval['total_price'] = round($info['price'] * $val['goods_count'], 2); //goods_id rela_goodsoption_valueid if (isset($exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']])) { $tmp_exp = $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]; $tmp_exval['quantity']+= $tmp_exp['quantity']; $tmp_exval['total_price'] = round($info['price'] * $tmp_exval['quantity'], 2); $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } else { $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } //$exportlist[] = $tmp_exval; $i++; } } foreach ($exportlist as $key => $val) { $s_data = $val['data']; $last_index_sort = array_column($s_data, 'name'); array_multisort($last_index_sort, SORT_ASC, $s_data); $val['data'] = $s_data; $exportlist[$key] = $val; } $columns = array( array( 'title' => '序号', 'field' => 'num_no', 'width' => 12 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 20 ) , array( 'title' => '商品名称', 'field' => 'name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '规格', 'field' => 'sku_str', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 24 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 24 ) , ); //$params['list_info'] $lists_info = array( 'line1' => $list_info['head_name'], //团老大 'line2' => '团长：' . $list_info['head_name'] . ' 提货地址：' . $list_info['head_address'] . ' 联系电话：' . $list_info['head_mobile'], //团长：团老大啦 提货地址：湖南大剧院 联系电话：13000000000 'line3' => '配送单：' . $list_info['list_sn'] . ' 时间：' . date('Y-m-d H:i:s', $list_info['create_time']) , 'line4' => '配送路线：' . $list_info['line_name'] . ' 配送员：' . $list_info['clerk_name'], ); D('Seller/Excel')->export_delivery_list_pi($exportlist, array( 'list_info' => $lists_info, 'title' => '商品拣货单', 'columns' => $columns )); //-------------------这里要合并结束---------------------- } //导出团长总单 样式2 if ($gpc['export'] == 3) { //导出配送总单 $columns = array( array( 'title' => '序号', 'field' => 'sn', 'width' => 12 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 20 ) , array( 'title' => '商品名称', 'field' => 'goods_name', 'width' => 24 ) , array( 'title' => '商品规格', 'field' => 'sku_name', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 12 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 12 ) , array( 'title' => '订购数', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '团长', 'field' => 'head_name', 'width' => 12 ) , array( 'title' => '小区名称', 'field' => 'community_name', 'width' => 12, ) , array( 'title' => '合计数量', 'field' => 'total_quantity', 'width' => 12 ) , ); //----------------- 这里要合并开始 downexcel--------------------- $tuanz_data_list = array(); $exportlist = array(); $list_id_arr = array(); foreach ($list as $val) { $list_id = $val['id']; $list_data = M('lionfish_comshop_deliverylist_goods')->where(array( 'list_id' => $list_id ))->order('id desc')->select(); $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); if ($val['clerk_id'] > 0) { $clerk_name = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $val['clerk_id'] ))->find(); $list_info['clerk_info'] = $clerk_name['name']; } if (!isset($exportlist[$list_info['head_id']])) { $exportlist[$list_info['head_id']] = array( 'list_info' => $list_info, 'data' => array() ); } $i = 1; foreach ($list_data as $val) { $tmp_exval = array(); $tmp_exval['num_no'] = $i; $tmp_exval['name'] = $val['goods_name']; $tmp_exval['quantity'] = $val['goods_count']; $tmp_exval['sku_str'] = $val['sku_str']; $gd_info = M('lionfish_comshop_goods')->field('codes')->where(array( 'id' => $val['goods_id'] ))->find(); $tmp_exval['goods_goodssn'] = $gd_info['codes']; $info = M('lionfish_comshop_order_goods')->field('price')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->order('order_goods_id desc')->find(); $tmp_exval['price'] = $info['price']; $tmp_exval['total_price'] = round($info['price'] * $val['goods_count'], 2); //goods_id rela_goodsoption_valueid if (isset($exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']])) { $tmp_exp = $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]; $tmp_exval['quantity']+= $tmp_exp['quantity']; $tmp_exval['total_price'] = round($info['price'] * $tmp_exval['quantity'], 2); $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } else { $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } //$exportlist[] = $tmp_exval; $i++; } } $new_need_goods_list = array(); foreach ($exportlist as $val) { $head_name = $val['list_info']['head_name']; $head_id = $val['list_info']['head_id']; foreach ($val['data'] as $gid_skuid => $goods_info) { if (empty($new_need_goods_list) || !isset($new_need_goods_list[$gid_skuid])) { //新签 $new_need_goods_list[$gid_skuid] = array(); $new_need_goods_list[$gid_skuid]['goods_name'] = $goods_info['name']; $new_need_goods_list[$gid_skuid]['sku_str'] = $goods_info['sku_str']; $new_need_goods_list[$gid_skuid]['goods_goodssn'] = $goods_info['goods_goodssn']; $new_need_goods_list[$gid_skuid]['goods_count'] = $goods_info['quantity']; $new_need_goods_list[$gid_skuid]['head_goods_list'] = array(); $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id] = array( 'price' => $goods_info['price'], 'total_price' => $goods_info['total_price'], 'buy_quantity' => $goods_info['quantity'], 'head_name' => $head_name, 'total_quatity' => $goods_info['quantity'] ); } else if (isset($new_need_goods_list[$gid_skuid])) { //续签 $new_need_goods_list[$gid_skuid]['goods_count']+= $goods_info['quantity']; if (isset($new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id])) { $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['price'] = $goods_info['price']; $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['total_price']+= $goods_info['total_price']; $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['buy_quantity']+= $goods_info['buy_quantity']; $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['total_quatity']+= $goods_info['total_quatity']; } else { $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id] = array( 'price' => $goods_info['price'], 'total_price' => $goods_info['total_price'], 'buy_quantity' => $goods_info['quantity'], 'head_name' => $head_name, 'total_quatity' => $goods_info['quantity'] ); } } } } $lists_info = array( 'line1' => $list_info['head_name'], //团老大 'line2' => '团长：' . $list_info['head_name'] . ' 提货地址：' . $list_info['head_address'] . ' 联系电话：' . $list_info['head_mobile'], //团长：团老大啦 提货地址：湖南大剧院 联系电话：13000000000 'line3' => '配送单：' . $list_info['list_sn'] . ' 时间：' . date('Y-m-d H:i:s', $list_info['create_time']) , 'line4' => '配送路线：' . $list_info['line_name'] . ' 配送员：' . $list_info['clerk_name'], ); D('Seller/Excel')->export_delivery_list_pinew($new_need_goods_list, array( 'list_info' => $lists_info, 'title' => '商品拣货单', 'columns' => $columns )); //-------------------这里要合并结束---------------------- } //导出配货单 if ($gpc['export'] == 4) { } //var_x( $list );die(); //load_model_class('excel')->export_delivery_list($exportlist, array('list_info' => $lists_info,'title' => '清单数据', 'columns' => $columns)); //die(); } //TODO,..... $list = M()->query('SELECT d.*,h.community_name FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist as d , " . C('DB_PREFIX') . "lionfish_community_head as h WHERE d.head_id = h.id " . $condition . ' order by d.id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); if (!empty($list)) { foreach ($list as $key => $val) { //$head_info = M('lionfish_community_head')->where( array('id' => $val['head_id'] ) )->find(); //$val['community_name'] = $head_info['community_name']; $order_count = M('lionfish_comshop_deliverylist_order')->where(array( 'list_id' => $val['id'] ))->count(); $val['order_count'] = $order_count; $list[$key] = $val; } } $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist as d , " . C('DB_PREFIX') . "lionfish_community_head as h " . ' WHERE d.head_id = h.id ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $this->gpc = $gpc; $this->list = $list; $this->total = $total; $this->pager = $pager; $this->display('Delivery/delivery'); } public function delivery() { $gpc = I('request.'); $pindex = max(1, intval($gpc['page'])); $psize = 20; $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['time']['start']) ? strtotime($gpc['time']['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['time']['end']) ? strtotime($gpc['time']['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); $this->searchtime = $searchtime; $this->starttime = $starttime; $this->endtime = $endtime; $condition = ""; if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and d.create_time > {$starttime} and d.create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and d.express_time > {$starttime} and d.express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and d.head_get_time > {$starttime} and d.head_get_time < {$endtime} "; } } if (!empty($gpc['keyword'])) { $gpc['keyword'] = trim($gpc['keyword']); $condition.= ' and (d.head_name like "%' . $gpc['keyword'] . '%" or d.head_mobile like "%' . $gpc['keyword'] . '%" or d.line_name like "%' . $gpc['keyword'] . '%" or d.clerk_name like "%' . $gpc['keyword'] . '%" or d.clerk_mobile like "%' . $gpc['keyword'] . '%" or h.community_name like "%' . $gpc['keyword'] . '%" )'; } if (isset($gpc['export']) && $gpc['export'] > 0) { @set_time_limit(0); $excel_title = ""; $search_tiaoj = ""; if (!empty($searchtime)) { if ($searchtime == 'create_time') { $excel_title.= "创建清单时间:" . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); $search_tiaoj.= "清单时间： " . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); } if ($searchtime == 'express_time') { $excel_title.= "配送时间:" . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); $search_tiaoj.= "配送时间： " . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); } if ($searchtime == 'head_get_time') { $excel_title.= "送达时间:" . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); $search_tiaoj.= "送达时间： " . date('Y-m-d H:i:s', $starttime) . ' ' . date('Y-m-d H:i:s', $endtime); } } $excel_title = ""; if (!empty($gpc['keyword'])) { $excel_title.= $gpc['keyword']; $search_tiaoj.= "关键词： " . $gpc['keyword']; } $list = M()->query('SELECT d.*,h.community_name FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist as d , " . C('DB_PREFIX') . "lionfish_community_head as h WHERE d.head_id = h.id " . $condition . ' order by d.id desc '); //导出商品总单 if ($gpc['export'] == 1) { $is_export_deliverygoods_category = D('Home/Front')->get_config_by_name('is_export_deliverygoods_category'); $is_export_deliverygoods_supply = D('Home/Front')->get_config_by_name('is_export_deliverygoods_supply'); $columns = array( array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 24 ) , array( 'title' => '商品名称', 'field' => 'goods_name', 'width' => 24 ) , array( 'title' => '商品规格', 'field' => 'sku_name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 12 ) , array( 'title' => '金额', 'field' => 'total_price', 'width' => 12 ) , ); if( isset($is_export_deliverygoods_category) && $is_export_deliverygoods_category == 1 ) { $columns[] = array( 'title' => '所属分类', 'field' => 'category_name', 'width' => 24 ); } if( isset($is_export_deliverygoods_supply) && $is_export_deliverygoods_supply == 1 ) { $columns[] = array( 'title' => '所属供应商', 'field' => 'supply_name', 'width' => 24 ); } $list_id_arr = array(); foreach ($list as $val) { $list_id_arr[] = $val['id']; } $need_goods_list = array(); if (!empty($list_id_arr)) { $goods_list = M('lionfish_comshop_deliverylist_goods')->where("list_id in ( " . implode(',', $list_id_arr) . " )")->select(); foreach ($goods_list as $val) { if (empty($need_goods_list) || !in_array($val['goods_id'] . '_' . $val['rela_goodsoption_valueid'], array_keys($need_goods_list))) { //goods_id rela_goodsoption_valueid $price = 0; $codes = ''; if (!empty($val['rela_goodsoption_valueid'])) { $price_value = M('lionfish_comshop_order_goods')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->find(); $price = $price_value['price']; $goodssn = M('lionfish_comshop_goods_option_item_value')->where(array( 'option_item_ids' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->find(); $codes = "\t".$goodssn['goodssn']."\t"; } else { $price_value = M('lionfish_comshop_goods')->field('price,codes')->where(array( 'id' => $val['goods_id'] ))->find(); $price = $price_value['price']; $codes = "\t".$price_value['codes']."\t"; } $gd_info = M('lionfish_comshop_good_common')->field('supply_id')->where( array('goods_id' => $val['goods_id'] ) )->find(); $supply_name = '平台'; if( $gd_info['supply_id'] > 0 ) { $supply_info = M('lionfish_comshop_supply')->field('shopname,type')->where( array('id' => $gd_info['supply_id'] ) )->find(); if( !empty($supply_info) ) { if( $supply_info['type'] == 1 ) { $supply_name = $supply_info['shopname'].'(独立供应商)'; }else{ $supply_name = $supply_info['shopname'].'(平台供应商)'; } } } $category_name = ""; $cate_list = M('lionfish_comshop_goods_to_category')->where( array('goods_id' => $val['goods_id'] ) )->select(); $cate_arr = array(); if( !empty($cate_list) ) { foreach( $cate_list as $c_val ) { $ct_info = M('lionfish_comshop_goods_category')->field('name')->where( array('id' => $c_val['cate_id'] ) )->find(); if( !empty($ct_info) ) { $cate_arr[] = $ct_info['name']; } } $category_name = implode('、', $cate_arr); } //supply_name $val['goods_id'] $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = array( 'quantity' => $val['goods_count'], 'price' => $price, 'goods_goodssn' => $codes, 'total_price' => ($val['goods_count'] * $price) , 'sku_name' => $val['sku_str'], 'supply_name' => $supply_name, 'category_name' => $category_name, 'goods_name' => $val['goods_name'] ); } else { $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity']+= $val['goods_count']; $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['total_price'] = $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity'] * $need_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['price']; } } } $last_index_sort = array_column($need_goods_list, 'goods_name'); array_multisort($last_index_sort, SORT_ASC, $need_goods_list); $lists_info = array( 'line1' => '商品拣货单', 'line2' => '检索条件: ' . $search_tiaoj, ); D('Seller/Excel')->export_delivery_goodslist($need_goods_list, array( 'list_info' => $lists_info, 'title' => '商品拣货单', 'columns' => $columns )); } //导出团长总单 if ($gpc['export'] == 2) { //导出配送总单 $columns = array( array( 'title' => '序号', 'field' => 'sn', 'width' => 12 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 20 ) , array( 'title' => '商品名称', 'field' => 'goods_name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '商品规格', 'field' => 'sku_name', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 12 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 12 ) , ); //----------------- 这里要合并开始 downexcel--------------------- $tuanz_data_list = array(); $exportlist = array(); $list_id_arr = array(); foreach ($list as $val) { $list_id = $val['id']; $list_data = M('lionfish_comshop_deliverylist_goods')->where(array( 'list_id' => $list_id ))->order('id desc')->select(); $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); if ($val['clerk_id'] > 0) { $clerk_name = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $val['clerk_id'] ))->find(); $list_info['clerk_info'] = $clerk_name['name']; } $list_info['search_tiaoj'] = $search_tiaoj; if (!isset($exportlist[$list_info['head_id']])) { $exportlist[$list_info['head_id']] = array( 'list_info' => $list_info, 'data' => array() ); } $i = 1; foreach ($list_data as $val) { $tmp_exval = array(); $tmp_exval['num_no'] = $i; $tmp_exval['name'] = $val['goods_name']; $tmp_exval['quantity'] = $val['goods_count']; $tmp_exval['sku_str'] = $val['sku_str']; $codes = ''; if (!empty($val['rela_goodsoption_valueid'])) { $goodssn = M('lionfish_comshop_goods_option_item_value')->where(array( 'option_item_ids' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->find(); $codes = "\t".$goodssn['goodssn']."\t"; } else { $price_value = M('lionfish_comshop_goods')->field('price,codes')->where(array( 'id' => $val['goods_id'] ))->find(); $codes = "\t".$price_value['codes']."\t"; } $tmp_exval['goods_goodssn'] = $codes; $info = M('lionfish_comshop_order_goods')->field('price')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->order('order_goods_id desc')->find(); $tmp_exval['price'] = $info['price']; $tmp_exval['total_price'] = round($info['price'] * $val['goods_count'], 2); //goods_id rela_goodsoption_valueid if (isset($exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']])) { $tmp_exp = $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]; $tmp_exval['quantity']+= $tmp_exp['quantity']; $tmp_exval['total_price'] = round($info['price'] * $tmp_exval['quantity'], 2); $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } else { $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } //$exportlist[] = $tmp_exval; $i++; } } foreach ($exportlist as $key => $val) { $s_data = $val['data']; $last_index_sort = array_column($s_data, 'name'); array_multisort($last_index_sort, SORT_ASC, $s_data); $i = 1; foreach( $s_data as $kk => $vv ) { $vv['num_no'] = $i; $i++; $s_data[$kk] = $vv; } $val['data'] = $s_data; $exportlist[$key] = $val; } $columns = array( array( 'title' => '序号', 'field' => 'num_no', 'width' => 12 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 20 ) , array( 'title' => '商品名称', 'field' => 'name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '规格', 'field' => 'sku_str', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 24 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 24 ) , ); //$params['list_info'] $lists_info = array( 'line1' => $list_info['head_name'], //团老大 'line2' => '团长：' . $list_info['head_name'] . ' 提货地址：' . $list_info['head_address'] . ' 联系电话：' . $list_info['head_mobile'], //团长：团老大啦 提货地址：湖南大剧院 联系电话：13000000000 'line3' => '配送单：' . $list_info['list_sn'] . ' 时间：' . date('Y-m-d H:i:s', $list_info['create_time']) , 'line4' => '配送路线：' . $list_info['line_name'] . ' 配送员：' . $list_info['clerk_name'], ); D('Seller/Excel')->export_delivery_list_pi($exportlist, array( 'list_info' => $lists_info, 'title' => '商品拣货单', 'columns' => $columns )); //-------------------这里要合并结束---------------------- } //导出团长总单 样式2 if ($gpc['export'] == 3) { //导出配送总单 $columns = array( array( 'title' => '序号', 'field' => 'sn', 'width' => 12 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 20 ) , array( 'title' => '商品名称', 'field' => 'goods_name', 'width' => 24 ) , array( 'title' => '商品规格', 'field' => 'sku_name', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 12 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 12 ) , array( 'title' => '订购数', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '团长', 'field' => 'head_name', 'width' => 12 ) , array( 'title' => '小区名称', 'field' => 'community_name', 'width' => 12 ) , array( 'title' => '合计数量', 'field' => 'total_quantity', 'width' => 12 ) , ); //----------------- 这里要合并开始 downexcel--------------------- $tuanz_data_list = array(); $exportlist = array(); $list_id_arr = array(); foreach ($list as $val) { $list_id = $val['id']; $community_name = $val['community_name']; $list_data = M('lionfish_comshop_deliverylist_goods')->where(array( 'list_id' => $list_id ))->order('id desc')->select(); $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); if ($val['clerk_id'] > 0) { $clerk_name = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $val['clerk_id'] ))->find(); $list_info['clerk_info'] = $clerk_name['name']; } if (!isset($exportlist[$list_info['head_id']])) { $exportlist[$list_info['head_id']] = array( 'list_info' => $list_info, 'data' => array() ); } $i = 1; foreach ($list_data as $val) { $tmp_exval = array(); $tmp_exval['num_no'] = $i; $tmp_exval['name'] = $val['goods_name']; $tmp_exval['quantity'] = $val['goods_count']; $tmp_exval['sku_str'] = $val['sku_str']; $tmp_exval['community_name'] = $community_name; // $codes = ''; if (!empty($val['rela_goodsoption_valueid'])) { $goodssn = M('lionfish_comshop_goods_option_item_value')->where(array( 'option_item_ids' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->find(); $codes = "\t".$goodssn['goodssn']."\t"; } else { $price_value = M('lionfish_comshop_goods')->field('price,codes')->where(array( 'id' => $val['goods_id'] ))->find(); $codes = "\t".$price_value['codes']."\t"; } $tmp_exval['goods_goodssn'] = $codes; $info = M('lionfish_comshop_order_goods')->field('price')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->order('order_goods_id desc')->find(); $tmp_exval['price'] = $info['price']; $tmp_exval['total_price'] = round($info['price'] * $val['goods_count'], 2); //goods_id rela_goodsoption_valueid if (isset($exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']])) { $tmp_exp = $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]; $tmp_exval['quantity']+= $tmp_exp['quantity']; $tmp_exval['total_price'] = round($info['price'] * $tmp_exval['quantity'], 2); $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } else { $exportlist[$list_info['head_id']]['data'][$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $tmp_exval; } //$exportlist[] = $tmp_exval; $i++; } } $new_need_goods_list = array(); foreach ($exportlist as $val) { $head_name = $val['list_info']['head_name']; $head_id = $val['list_info']['head_id']; foreach ($val['data'] as $gid_skuid => $goods_info) { if (empty($new_need_goods_list) || !isset($new_need_goods_list[$gid_skuid])) { //新签 $new_need_goods_list[$gid_skuid] = array(); $new_need_goods_list[$gid_skuid]['goods_name'] = $goods_info['name']; $new_need_goods_list[$gid_skuid]['sku_str'] = $goods_info['sku_str']; $new_need_goods_list[$gid_skuid]['goods_goodssn'] = $goods_info['goods_goodssn']; $new_need_goods_list[$gid_skuid]['goods_count'] = $goods_info['quantity']; $new_need_goods_list[$gid_skuid]['head_goods_list'] = array(); $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id] = array( 'price' => $goods_info['price'], 'total_price' => $goods_info['total_price'], 'buy_quantity' => $goods_info['quantity'], 'head_name' => $head_name, 'community_name' => $goods_info['community_name'], 'total_quatity' => $goods_info['quantity'] ); } else if (isset($new_need_goods_list[$gid_skuid])) { //续签 $new_need_goods_list[$gid_skuid]['goods_count']+= $goods_info['quantity']; if (isset($new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id])) { $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['price'] = $goods_info['price']; $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['total_price']+= $goods_info['total_price']; $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['buy_quantity']+= $goods_info['buy_quantity']; $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id]['total_quatity']+= $goods_info['total_quatity']; } else { $new_need_goods_list[$gid_skuid]['head_goods_list'][$head_id] = array( 'price' => $goods_info['price'], 'total_price' => $goods_info['total_price'], 'buy_quantity' => $goods_info['quantity'], 'head_name' => $head_name, 'community_name' => $goods_info['community_name'], 'total_quatity' => $goods_info['quantity'] ); } } } } // var_dump( $new_need_goods_list ); // die(); $lists_info = array( 'line1' => $list_info['head_name'], //团老大 'line2' => '团长：' . $list_info['head_name'] . ' 提货地址：' . $list_info['head_address'] . ' 联系电话：' . $list_info['head_mobile'], //团长：团老大啦 提货地址：湖南大剧院 联系电话：13000000000 'line3' => '配送单：' . $list_info['list_sn'] . ' 时间：' . date('Y-m-d H:i:s', $list_info['create_time']) , 'line4' => '配送路线：' . $list_info['line_name'] . ' 配送员：' . $list_info['clerk_name'], ); D('Seller/Excel')->export_delivery_list_pinew($new_need_goods_list, array( 'list_info' => $lists_info, 'title' => '商品拣货单', 'columns' => $columns )); //-------------------这里要合并结束---------------------- } //导出配货单 if ($gpc['export'] == 4) { } //var_x( $list );die(); //load_model_class('excel')->export_delivery_list($exportlist, array('list_info' => $lists_info,'title' => '清单数据', 'columns' => $columns)); //die(); } //TODO,..... $list = M()->query('SELECT d.*,h.community_name FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist as d , " . C('DB_PREFIX') . "lionfish_community_head as h WHERE d.head_id = h.id " . $condition . ' order by d.id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); if (!empty($list)) { foreach ($list as $key => $val) { //$head_info = M('lionfish_community_head')->where( array('id' => $val['head_id'] ) )->find(); //$val['community_name'] = $head_info['community_name']; $order_count = M('lionfish_comshop_deliverylist_order')->where(array( 'list_id' => $val['id'] ))->count(); $val['order_count'] = $order_count; $list[$key] = $val; } } $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist as d , " . C('DB_PREFIX') . "lionfish_community_head as h " . ' WHERE d.head_id = h.id ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $this->gpc = $gpc; $this->list = $list; $this->total = $total; $this->pager = $pager; $this->display(); } public function downorderexcel() { $gpc = I('request.'); $list_id = $gpc['list_id']; $paras = array(); $sqlcondition = ""; $condition = " 1 "; $order_ids_arr = M('lionfish_comshop_deliverylist_order')->where(array( 'list_id' => $list_id ))->select(); $order_ids = array(); foreach ($order_ids_arr as $vv) { $order_ids[] = $vv['order_id']; } if (empty($order_ids)) { die('无订单数据'); } $condition.= " and o.order_id in (" . implode(',', $order_ids) . ") "; $sql = 'SELECT count(o.order_id) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_order as o ' . ' where ' . $condition; $total_arr = M()->query($sql); $total = $total_arr[0]['count']; $order_status_arr = D('Seller/Order')->get_order_status_name(); @set_time_limit(0); $columns = array( array( 'title' => '订单编号', 'field' => 'order_num_alias', 'width' => 24 ) , array( 'title' => '昵称', 'field' => 'name', 'width' => 12 ) , //array('title' => '会员姓名', 'field' => 'mrealname', 'width' => 12), array( 'title' => 'openid', 'field' => 'openid', 'width' => 24 ) , array( 'title' => '会员手机号', 'field' => 'telephone', 'width' => 12 ) , array( 'title' => '收货姓名(或自提人)', 'field' => 'shipping_name', 'width' => 12 ) , array( 'title' => '联系电话', 'field' => 'shipping_tel', 'width' => 12 ) , array( 'title' => '收货地址', 'field' => 'address_province', 'width' => 12 ) , array( 'title' => '完整收货地址', 'field' => 'address_province_city_area', 'width' => 12 ) , array( 'title' => '商品名称', 'field' => 'goods_title', 'width' => 24 ) , array( 'title' => '商品分类', 'field' => 'goods_category', 'width' => 24 ) , //array('title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 12), array( 'title' => '商品规格', 'field' => 'goods_optiontitle', 'width' => 12 ) , array( 'title' => '商品数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '商品单价', 'field' => 'goods_price1', 'width' => 12 ) , array( 'title' => '商品价格', 'field' => 'goods_rprice2', 'width' => 12 ) , array( 'title' => '退款商品数量', 'field' => 'has_refund_quantity', 'width' => 12 ) , array( 'title' => '退款金额', 'field' => 'has_refund_money', 'width' => 12 ) , //array('title' => '商品单价(折扣后)', 'field' => 'goods_price2', 'width' => 12), //array('title' => '商品价格(折扣前)', 'field' => 'goods_rprice1', 'width' => 12), array( 'title' => '支付方式', 'field' => 'paytype', 'width' => 12 ) , array( 'title' => '配送方式', 'field' => 'delivery', 'width' => 12 ) , //array('title' => '自提门店', 'field' => 'pickname', 'width' => 24), //array('title' => '商品小计', 'field' => 'goodsprice', 'width' => 12), array( 'title' => '运费', 'field' => 'dispatchprice', 'width' => 12 ) , //array('title' => '积分抵扣', 'field' => 'deductprice', 'width' => 12), //array('title' => '余额抵扣', 'field' => 'deductcredit2', 'width' => 12), //array('title' => '满额立减', 'field' => 'deductenough', 'width' => 12), //array('title' => '优惠券优惠', 'field' => 'couponprice', 'width' => 12), array( 'title' => '订单改价', 'field' => 'changeprice', 'width' => 12 ) , array( 'title' => '运费改价', 'field' => 'changedispatchprice', 'width' => 12 ) , array( 'title' => '应收款', 'field' => 'price', 'width' => 12 ) , array( 'title' => '状态', 'field' => 'status', 'width' => 12 ) , array( 'title' => '下单时间', 'field' => 'createtime', 'width' => 24 ) , array( 'title' => '付款时间', 'field' => 'paytime', 'width' => 24 ) , array( 'title' => '发货时间', 'field' => 'sendtime', 'width' => 24 ) , array( 'title' => '完成时间', 'field' => 'finishtime', 'width' => 24 ) , array( 'title' => '快递公司', 'field' => 'expresscom', 'width' => 24 ) , array( 'title' => '快递单号', 'field' => 'expresssn', 'width' => 24 ) , array( 'title' => '小区名称', 'field' => 'community_name', 'width' => 12 ) , array( 'title' => '团长姓名', 'field' => 'head_name', 'width' => 12 ) , array( 'title' => '团长电话', 'field' => 'head_mobile', 'width' => 12 ) , array( 'title' => '团长完整地址', 'field' => 'fullAddress', 'width' => 24 ) , array( 'title' => '提货详细地址', 'field' => 'address_address', 'width' => 12 ) , array( 'title' => '团长配送送货详细地址', 'field' => 'tuan_send_address', 'width' => 22 ) , array( 'title' => '订单备注', 'field' => 'remark', 'width' => 36 ) , array( 'title' => '卖家订单备注', 'field' => 'remarksaler', 'width' => 36 ) , array('title' => '团长佣金', 'field' => 'head_money', 'width' => 12), array('title' => '优惠券优惠', 'field' => 'voucher_credit', 'width' => 12 ), //array('title' => '核销员', 'field' => 'salerinfo', 'width' => 24), //array('title' => '核销门店', 'field' => 'storeinfo', 'width' => 36), //array('title' => '订单自定义信息', 'field' => 'order_diyformdata', 'width' => 36), //array('title' => '商品自定义信息', 'field' => 'goods_diyformdata', 'width' => 36) array( 'title' => '省', 'field' => 'full_province', 'width' => 12 ) , array( 'title' => '市', 'field' => 'full_city', 'width' => 12 ) , array( 'title' => '区', 'field' => 'full_country', 'width' => 12 ) , ); $modify_explode_json = D('Home/Front')->get_config_by_name('modify_export_fields'); if (!empty($modify_explode_json)) { $modify_explode_arr = json_decode($modify_explode_json, true); $need_columns = array(); foreach ($columns as $key => $val) { if (in_array($val['field'], array_keys($modify_explode_arr))) { $val['is_check'] = 1; $val['sort'] = $modify_explode_arr[$val['field']]; $need_columns[$key] = $val; }else if(in_array($val['field'], array('full_province','full_city','full_country'))){ if(in_array('fullProvince', array_keys($modify_explode_arr))){ $val['is_check'] = 1; if($val['field'] == 'full_province'){ $val['sort'] = $modify_explode_arr["fullProvince"] + 0.2 ; }else if($val['field'] == 'full_city'){ $val['sort'] = $modify_explode_arr["fullProvince"] + 0.1 ; }else{ $val['sort'] = $modify_explode_arr["fullProvince"]; } $need_columns[$key] = $val; }else{ $val['is_check'] = 0; $val['sort'] = 0; } }else { $val['is_check'] = 0; $val['sort'] = 0; } $columns[$key] = $val; } $last_index_sort = array_column($need_columns, 'sort'); array_multisort($last_index_sort, SORT_DESC, $need_columns); $columns = $need_columns; } $exportlist = array(); if (!(empty($total))) { //searchfield goodstitle $sqlcondition.= ' left join ' . C('DB_PREFIX') . 'lionfish_comshop_order_goods ogc on ogc.order_id = o.order_id '; $sql = 'SELECT o.*,ogc.name as goods_title,ogc.goods_id,ogc.order_goods_id ,ogc.quantity as ogc_quantity,ogc.voucher_credit as g_voucher_credit ,ogc.price,ogc.has_refund_quantity,ogc.has_refund_money, ogc.total as goods_total FROM ' . C('DB_PREFIX') . 'lionfish_comshop_order as o ' . $sqlcondition . ' where ' . $condition . ' ORDER BY o.head_id asc,ogc.goods_id desc, o.`order_id` DESC '; $list = M()->query($sql); $look_member_arr = array(); $area_arr = array(); foreach ($list as $val) { if (empty($look_member_arr) || !isset($look_member_arr[$val['member_id']])) { $member_info = M('lionfish_comshop_member')->where(array( 'member_id' => $val['member_id'] ))->find(); $look_member_arr[$val['member_id']] = $member_info; } $category_name = ""; $cate_list = M('lionfish_comshop_goods_to_category')->where( array('goods_id' => $val['goods_id'] ) )->select(); $cate_arr = array(); if( !empty($cate_list) ) { foreach( $cate_list as $c_val ) { $ct_info = M('lionfish_comshop_goods_category')->field('name')->where( array('id' => $c_val['cate_id'] ) )->find(); if( !empty($ct_info) ) { $cate_arr[] = $ct_info['name']; } } $category_name = implode('、', $cate_arr); } $tmp_exval = array(); $tmp_exval['order_num_alias'] = $val['order_num_alias'] . "\t"; $tmp_exval['goods_category'] = $category_name; $tmp_exval['head_money'] = 0; $head_commiss_order = M('lionfish_community_head_commiss_order')->where( array('order_id' => $val['order_id'],'order_goods_id' => $val['order_goods_id']) )->find(); if( !empty($head_commiss_order) ) { $tmp_exval['head_money'] = $head_commiss_order['money']; } $tmp_exval['name'] = $look_member_arr[$val['member_id']]['username']; //from_type if ($val['from_type'] == 'wepro') { $tmp_exval['openid'] = $look_member_arr[$val['member_id']]['we_openid']; } else { $tmp_exval['openid'] = $look_member_arr[$val['member_id']]['openid']; } $tmp_exval['telephone'] = $look_member_arr[$val['member_id']]['telephone']; $tmp_exval['shipping_name'] = $val['shipping_name']; $tmp_exval['shipping_tel'] = $val['shipping_tel']; $tmp_exval['has_refund_quantity'] = $val['has_refund_quantity']; $tmp_exval['has_refund_money'] = $val['has_refund_money']; //area_arr if (empty($area_arr) || !isset($area_arr[$val['shipping_province_id']])) { $area_arr[$val['shipping_province_id']] = D('Home/Front')->get_area_info($val['shipping_province_id']); } if (empty($area_arr) || !isset($area_arr[$val['shipping_city_id']])) { $area_arr[$val['shipping_city_id']] = D('Home/Front')->get_area_info($val['shipping_city_id']); } if (empty($area_arr) || !isset($area_arr[$val['shipping_country_id']])) { $area_arr[$val['shipping_country_id']] = D('Home/Front')->get_area_info($val['shipping_country_id']); } $province_info = $area_arr[$val['shipping_province_id']]; $city_info = $area_arr[$val['shipping_city_id']]; $area_info = $area_arr[$val['shipping_country_id']]; $tmp_exval['address_province_city_area'] = $province_info['name'] . $city_info['name'] . $area_info['name'] . $val['shipping_address']; $tmp_exval['tuan_send_address'] = $val['tuan_send_address']; $tmp_exval['address_province'] = $province_info['name']; $tmp_exval['address_city'] = $city_info['name']; $tmp_exval['address_area'] = $area_info['name']; $tmp_exval['address_address'] = $val['shipping_address']; $tmp_exval['goods_title'] = $val['goods_title']; $goods_optiontitle = D('Seller/Order')->get_order_option_sku($val['order_id'], $val['order_goods_id']); $tmp_exval['goods_optiontitle'] = $goods_optiontitle; $tmp_exval['quantity'] = $val['ogc_quantity']; $tmp_exval['goods_price1'] = $val['price']; $tmp_exval['goods_rprice2'] = $val['goods_total']; $paytype = $val['payment_code']; //省市区 $tmp_exval['full_province'] = $province_info['name']; $tmp_exval['full_city'] = $city_info['name']; $tmp_exval['full_country'] = $area_info['name']; switch ($paytype) { case 'admin': $paytype = '后台支付'; break; case 'yuer': $paytype = '余额支付'; break; case 'weixin': $paytype = '微信支付'; break; default: $paytype = '未支付'; } $community_info = D('Home/Front')->get_community_byid($val['head_id']); $tmp_exval['community_name'] = $community_info['communityName']; $tmp_exval['fullAddress'] = $community_info['fullAddress']; $tmp_exval['head_name'] = $community_info['disUserName']; $tmp_exval['head_mobile'] = $community_info['head_mobile']; $tmp_exval['voucher_credit'] = $val['g_voucher_credit']; $tmp_exval['paytype'] = $paytype; if ($val['delivery'] == 'express') { $tmp_exval['delivery'] = '快递'; } else if ($val['delivery'] == 'pickup') { $tmp_exval['delivery'] = '自提'; } else if ($val['delivery'] == 'tuanz_send') { $tmp_exval['delivery'] = '团长配送'; } $tmp_exval['dispatchprice'] = $val['shipping_fare']; $tmp_exval['changeprice'] = $val['changedtotal']; $tmp_exval['changedispatchprice'] = $val['changedshipping_fare']; $tmp_exval['price'] = $val['total']; $tmp_exval['status'] = $order_status_arr[$val['order_status_id']]; $tmp_exval['createtime'] = date('Y-m-d H:i:s', $val['date_added']); $tmp_exval['paytime'] = date('Y-m-d H:i:s', $val['pay_time']); $tmp_exval['sendtime'] = date('Y-m-d H:i:s', $val['express_time']); $tmp_exval['finishtime'] = date('Y-m-d H:i:s', $val['finishtime']); $tmp_exval['expresscom'] = $val['dispatchname']; $tmp_exval['expresssn'] = $val['shipping_no']; $tmp_exval['remark'] = $val['comment']; $tmp_exval['remarksaler'] = $val['remarksaler']; if($val['has_refund_quantity'] < $val['ogc_quantity']){ $exportlist[] = $tmp_exval; } } } D('Seller/Excel')->export($exportlist, array( 'title' => '配送清单-订单数据', 'columns' => $columns )); } public function deldeliverylist() { $line_id = I('request.id'); if (empty($line_id)) { $line_id = (is_array(I('request.ids')) ? implode(',', I('request.ids')) : 0); } /*M('lionfish_comshop_deliveryline_headrelative')->where(array( 'line_id' => $line_id ))->delete(); M('lionfish_comshop_deliveryline')->where(array( 'id' => $line_id ))->delete(); M('lionfish_comshop_deliveryclerk')->where( array('line_id' => $line_id) )->save( array('line_id' => 0) ); */ M('lionfish_comshop_deliveryline_headrelative')->where(' line_id in ('.$line_id.') ')->delete(); M('lionfish_comshop_deliveryline')->where(' id in ('.$line_id.') ')->delete(); M('lionfish_comshop_deliveryclerk')->where( ' line_id in ('.$line_id.') ' )->save( array('line_id' => 0) ); show_json(1, array( 'url' => $_SERVER['HTTP_REFERER'] )); } public function onekey_tosendallorder() { $_GPC = I('request.'); $cache_key = md5(time() . mt_rand(1, 999)); $quene_order_list = array(); //全部群发数组 $orderlist = M('lionfish_comshop_order')->field('order_id')->where("order_status_id=1 and (delivery ='pickup' or delivery='tuanz_send')")->order('order_id desc')->select(); foreach ($orderlist as $val) { $quene_order_list[] = $val['order_id']; } S('_sendallorderquene_' . $cache_key, $quene_order_list); $this->_GPC = $_GPC; $this->cache_key = $cache_key; $this->display(); } public function onekey_opreceive() { $_GPC = I('request.'); $cache_key = md5(time() . mt_rand(1, 999)); $quene_order_list = array(); //全部群发数组 $orderlist = M('lionfish_comshop_order')->field('order_id')->where('order_status_id=4')->order('order_id desc')->select(); foreach ($orderlist as $val) { $quene_order_list[] = $val['order_id']; } S('_opreceivequene_' . $cache_key, $quene_order_list); $this->cache_key = $cache_key; $this->_GPC = $_GPC; $this->display(); } public function onekey_opsend_tuanz_over() { $_GPC = I('request.'); $cache_key = md5(time() . mt_rand(1, 999)); $quene_order_list = array(); //全部群发数组 $orderlist = M('lionfish_comshop_order')->field('order_id')->where(" order_status_id=14 and (delivery ='pickup' or delivery='tuanz_send') ")->order('order_id desc')->select(); foreach ($orderlist as $val) { $quene_order_list[] = $val['order_id']; } S('_tuanzoverquene_' . $cache_key, $quene_order_list); $this->cache_key = $cache_key; $this->_GPC = $_GPC; $this->display(); } public function do_opreceive_quene() { $_GPC = I('request.'); $cache_key = $_GPC['cache_key']; $quene_order_list = S('_opreceivequene_' . $cache_key); $order_id = array_shift($quene_order_list); S('_opreceivequene_' . $cache_key, $quene_order_list); $order_info = M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->find(); if ($order_info['order_status_id'] == 4) { D('Home/Order')->receive_order($order_id); M('lionfish_comshop_order_history')->where(array( 'order_id' => $order_id, 'order_status_id' => 6 ))->save(array( 'comment' => '后台操作一键，确认收货' )); } if (empty($quene_order_list)) { echo json_encode(array( 'code' => 2 )); die(); } //清单编号 echo json_encode(array( 'code' => 0, 'msg' => '订单编号：' . $order_info['order_num_alias'] . " 处理成功，还剩余" . count($quene_order_list) . "个订单未处理" )); die(); } public function do_tuanzover_quene() { $_GPC = I('request.'); $cache_key = $_GPC['cache_key']; $quene_order_list = S('_tuanzoverquene_' . $cache_key); $order_id = array_shift($quene_order_list); S('_tuanzoverquene_' . $cache_key, $quene_order_list); $order_info = M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->find(); if ($order_info['order_status_id'] == 14) { D('Seller/Order')->do_tuanz_over($order_id); $history_data = array(); $history_data['order_id'] = $order_id; $history_data['order_status_id'] = 4; $history_data['notify'] = 0; $history_data['comment'] = '后台一键操作，批量操作发货到团长'; $history_data['date_added'] = time(); M('lionfish_comshop_order_history')->add($history_data); D('Home/Frontorder')->send_order_operate($order_id); } if (empty($quene_order_list)) { echo json_encode(array( 'code' => 2 )); die(); } //清单编号 echo json_encode(array( 'code' => 0, 'msg' => '订单编号：' . $order_info['order_num_alias'] . " 处理成功，还剩余" . count($quene_order_list) . "个订单未处理" )); die(); } /** 批量处理配送队列 * */ public function do_sendallorder_quene() { $_GPC = I('request.'); $cache_key = $_GPC['cache_key']; $quene_order_list = S('_sendallorderquene_' . $cache_key); $order_id = array_shift($quene_order_list); S('_sendallorderquene_' . $cache_key, $quene_order_list); $order_info = M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->find(); if ($order_info['order_status_id'] == 1) { if($order_info['delivery'] != 'localtown_delivery'){ D('Seller/Order')->do_send_tuanz($order_id); D('Seller/Operatelog')->addOperateLog('detailed_list','批量处理配送--订单编号'.$order_info['order_num_alias']); } } if (empty($quene_order_list)) { echo json_encode(array( 'code' => 2 )); die(); } //清单编号 echo json_encode(array( 'code' => 0, 'msg' => '订单编号：' . $order_info['order_num_alias'] . " 处理成功，还剩余" . count($quene_order_list) . "个订单未处理" )); die(); } public function config() { $_GPC = I('request.'); //goods_stock_notice $columns = array( array( 'title' => '订单编号', 'field' => 'order_num_alias', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '会员昵称', 'field' => 'name', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '会员手机号', 'field' => 'telephone', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '会员备注', 'field' => 'member_content', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '收货姓名(或自提人)', 'field' => 'shipping_name', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '联系电话', 'field' => 'shipping_tel', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '收货地址', 'field' => 'address_province_city_area', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '提货详细地址', 'field' => 'address_address', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品名称', 'field' => 'goods_title', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品分类', 'field' => 'goods_category', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品价格', 'field' => 'goods_rprice2', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品数量', 'field' => 'quantity', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '支付方式', 'field' => 'paytype', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '配送方式', 'field' => 'delivery', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '团长配送送货详细地址', 'field' => 'tuan_send_address', 'width' => 22, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品规格', 'field' => 'goods_optiontitle', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品单价', 'field' => 'goods_price1', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '收货时间', 'field' => 'receive_time', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '快递单号', 'field' => 'expresssn', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '下单时间', 'field' => 'createtime', 'width' => 24, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '小区名称', 'field' => 'community_name', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '团长姓名', 'field' => 'head_name', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '团长电话', 'field' => 'head_mobile', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '退款商品数量', 'field' => 'has_refund_quantity', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '退款金额', 'field' => 'has_refund_money', 'width' => 12, 'sort' => 0, 'is_check' => 1 ) , array( 'title' => '商品编码', 'field' => 'goods_goodssn', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => 'openid', 'field' => 'openid', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '运费', 'field' => 'dispatchprice', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '积分抵扣', 'field' => 'score_for_money', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '满额立减', 'field' => 'fullreduction_money', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '优惠券优惠', 'field' => 'voucher_credit', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '应收款(该笔订单总款)', 'field' => 'price', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '状态', 'field' => 'status', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '团长佣金', 'field' => 'head_money', 'width' => 12, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '付款时间', 'field' => 'paytime', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '发货时间', 'field' => 'sendtime', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '完成时间', 'field' => 'finishtime', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '快递公司', 'field' => 'expresscom', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '完整地址', 'field' => 'fullAddress', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '订单备注', 'field' => 'remark', 'width' => 36, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '卖家订单备注', 'field' => 'remarksaler', 'width' => 36, 'sort' => 0, 'is_check' => 0 ) , array( 'title' => '省市区', 'field' => 'fullProvince', 'width' => 24, 'sort' => 0, 'is_check' => 0 ) , ); if (IS_POST) { $data = ((is_array($_GPC['parameter']) ? $_GPC['parameter'] : array())); $data['is_delivery_add'] = isset($data['is_delivery_add']) ? 1 : 0; $data['is_export_deliverygoods_category'] = isset($data['is_export_deliverygoods_category']) ? 1 : 0; $data['is_export_deliverygoods_supply'] = isset($data['is_export_deliverygoods_supply']) ? 1 : 0; $modify_explode_arr = $_GPC['modify_explode_arr']; if (!empty($modify_explode_arr)) { $ziduan_arr = $modify_explode_arr; $length = count($ziduan_arr); $save_columns = array(); $columns_keys = array(); foreach ($columns as $val) { $columns_keys[$val['field']] = array( 'title' => $val['title'], 'width' => $val['width'] ); } $columns = array(); foreach ($ziduan_arr as $fields) { $columns[] = array( 'title' => $columns_keys[$fields]['title'], 'field' => $fields, 'width' => $columns_keys[$fields]['width'] ); $save_columns[$fields] = $length; $length--; } D('Seller/Config')->update(array( 'modify_export_fields' => json_encode($save_columns) )); } D('Seller/Config')->update($data); show_json(1, array( 'url' => $_SERVER['HTTP_REFERER'] )); } $data = D('Seller/Config')->get_all_config(); $modify_explode_json = D('Home/Front')->get_config_by_name('modify_export_fields'); if (!empty($modify_explode_json)) { $modify_explode_arr = json_decode($modify_explode_json, true); foreach ($columns as $key => $val) { if (in_array($val['field'], array_keys($modify_explode_arr))) { $val['is_check'] = 1; $val['sort'] = $modify_explode_arr[$val['field']]; } else { $val['is_check'] = 0; $val['sort'] = 0; } $columns[$key] = $val; } $last_index_sort = array_column($columns, 'sort'); array_multisort($last_index_sort, SORT_DESC, $columns); } $this->columns = $columns; $this->data = $data; include $this->display(); } public function downexcel() { $gpc = I('request.'); $list_id = $gpc['list_id']; $condition = " and list_id={$list_id} "; $list = M()->query('SELECT * FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist_goods WHERE 1 " . $condition . ' order by id desc '); $exportlist = array(); $i = 1; foreach ($list as $val) { $tmp_exval = array(); $tmp_exval['num_no'] = $i; $tmp_exval['name'] = $val['goods_name']; $tmp_exval['quantity'] = $val['goods_count']; $tmp_exval['sku_str'] = $val['sku_str']; $order_id_list = M()->query('SELECT order_id FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist_order WHERE list_id =".$list_id.' order by id desc '); $order_id1 = array_column($order_id_list, 'order_id'); $order_id= implode(",",$order_id1); $info = M('lionfish_comshop_order_goods')->field('price')->where(array( 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'], 'goods_id' => $val['goods_id'] ))->where("order_id in ({$order_id}) ")->order('order_goods_id desc')->find(); $tmp_exval['price'] = $info['price']; $tmp_exval['total_price'] = round($info['price'] * $val['goods_count'], 2); //goods_id rela_goodsoption_valueid $exportlist[] = $tmp_exval; $i++; } $columns = array( array( 'title' => '序号', 'field' => 'num_no', 'width' => 12 ) , array( 'title' => '商品名称', 'field' => 'name', 'width' => 24 ) , array( 'title' => '数量', 'field' => 'quantity', 'width' => 12 ) , array( 'title' => '规格', 'field' => 'sku_str', 'width' => 24 ) , array( 'title' => '单价', 'field' => 'price', 'width' => 24 ) , array( 'title' => '总价', 'field' => 'total_price', 'width' => 24 ) , ); $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); //$params['list_info'] $lists_info = array( 'line1' => $list_info['head_name'], //团老大 'line2' => '团长：' . $list_info['head_name'] . ' 提货地址：' . $list_info['head_address'] . ' 联系电话：' . $list_info['head_mobile'], //团长：团老大啦 提货地址：湖南大剧院 联系电话：13000000000 'line3' => '配送单：' . $list_info['list_sn'] . ' 时间：' . date('Y-m-d H:i:s', $list_info['create_time']) , 'line4' => '配送路线：' . $list_info['line_name'] . ' 配送员：' . $list_info['clerk_name'], ); D('Seller/Excel')->export_delivery_list($exportlist, array( 'list_info' => $lists_info, 'title' => '清单数据', 'columns' => $columns )); die(); } public function list_goodslist() { $gpc = I('request.'); $list_id = $gpc['list_id']; $pindex = max(1, intval($gpc['page'])); $psize = 20; $condition = " and list_id={$list_id} "; if (!empty($gpc['keyword'])) { $gpc['keyword'] = trim($gpc['keyword']); $condition.= ' and (name like "%' . $gpc['keyword'] . '%" )'; } $list = M()->query('SELECT * FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliverylist_goods WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_deliverylist_goods WHERE 1 ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); $this->list = $list; $this->list_id = $list_id; $this->list_info = $list_info; $this->pager = $pager; $this->display(); } public function sub_song() { $_GPC = I('request.'); $list_id = $_GPC['id']; $this->do_sub_song($list_id); show_json(1, array( 'msg' => '配送清单成功', 'url' => $_SERVER['HTTP_REFERER'] )); } /** 将订单状态为配送中 * */ private function do_sub_song($list_id) { $list_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->find(); if (!empty($list_info)) { D('Seller/Operatelog')->addOperateLog('detailed_list','配送单配送--编号'.$list_info['list_sn']); //变更线路状态。变更订单状态为配送中 $order_relates = M('lionfish_comshop_deliverylist_order')->where(array( 'list_id' => $list_id ))->select(); if (!empty($order_relates)) { foreach ($order_relates as $order_val) { $order_status_id_info = M('lionfish_comshop_order')->field('order_status_id')->where(array( 'order_id' => $order_val['order_id'] ))->find(); $order_status_id = $order_status_id_info['order_status_id']; //待发货才行 if ($order_status_id == 1) { $data = array(); $data['express_time'] = time(); $data['order_status_id'] = 14; M('lionfish_comshop_order')->where(array( 'order_id' => $order_val['order_id'] ))->save($data); $history_data = array(); $history_data['order_id'] = $order_val['order_id']; $history_data['order_status_id'] = 14; $history_data['notify'] = 0; $history_data['comment'] = '订单配送中，后台配送单管理页面发货'; $history_data['date_added'] = time(); M('lionfish_comshop_order_history')->add($history_data); } } } M('lionfish_comshop_deliverylist')->where(array( 'id' => $list_id ))->save(array( 'state' => 1, 'express_time' => time() )); } } public function onekey_tosend() { $_GPC = I('request.'); $ids_arr = $_GPC['ids_arr']; $sec = $_GPC['sec']; $cache_key = md5(time() . count($ids_arr) . $sec); $quene_order_list = array(); if ($sec == 1) { D('Seller/Operatelog')->addOperateLog('detailed_list','配送单配送--批量配送操作'); //限定配送数组 S('deliveryquene_' . $cache_key, $ids_arr); // lionfish_comshop_deliverylist } else { D('Seller/Operatelog')->addOperateLog('detailed_list','配送单配送--一键配送操作'); //全部群发数组 $deliverylist = M('lionfish_comshop_deliverylist')->field('id')->where(array( 'state' => 0 ))->select(); foreach ($deliverylist as $val) { $quene_order_list[] = $val['id']; } S('deliveryquene_' . $cache_key, $quene_order_list); } $this->cache_key = $cache_key; $this->display(); } public function onekey_tosendover() { $_GPC = I('request.'); $ids_arr = $_GPC['ids_arr']; $sec = $_GPC['sec']; $cache_key = md5(time() . count($ids_arr) . $sec); $quene_order_list = array(); if ($sec == 1) { D('Seller/Operatelog')->addOperateLog('detailed_list','配送单配送--批量送达操作'); //限定配送数组 S('deliveryqueneing_' . $cache_key, $ids_arr); // lionfish_comshop_deliverylist } else { D('Seller/Operatelog')->addOperateLog('detailed_list','配送单配送--一键送达操作'); //全部群发数组 $deliverylist = M('lionfish_comshop_deliverylist')->field('id')->where(array( 'state' => 1 ))->select(); foreach ($deliverylist as $val) { $quene_order_list[] = $val['id']; } S('deliveryqueneing_' . $cache_key, $quene_order_list); } $this->cache_key = $cache_key; $this->display(); } /** 批量处理队列 * */ public function do_deliverying_quene() { $_GPC = I('request.'); $cache_key = $_GPC['cache_key']; $quene_order_list = S('deliveryqueneing_' . $cache_key); $delivery_id = array_shift($quene_order_list); S('deliveryqueneing_' . $cache_key, $quene_order_list); $delivery_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $delivery_id ))->find(); if ($delivery_info['state'] == 1) { M('lionfish_comshop_deliverylist')->where(array( 'id' => $delivery_id ))->save(array( 'state' => 2, 'head_get_time' => time() )); //对订单操作，可以去提货了 $order_ids_all = M('lionfish_comshop_deliverylist_order')->where(array( 'list_id' => $delivery_id ))->select(); if (!empty($order_ids_all)) { foreach ($order_ids_all as $order_val) { $order_status_info = M('lionfish_comshop_order')->where(array( 'order_id' => $order_val['order_id'] ))->find(); $order_status_id = $order_status_info['order_status_id']; //配送中才能 if ($order_status_id == 14) { $history_data = array(); $history_data['order_id'] = $order_val['order_id']; $history_data['order_status_id'] = 4; $history_data['notify'] = 0; $history_data['comment'] = '后台一键团长签收配送清单'; $history_data['date_added'] = time(); M('lionfish_comshop_order_history')->add($history_data); //send_order_operate D('Home/Frontorder')->send_order_operate($order_val['order_id']); } } } } if (empty($quene_order_list)) { echo json_encode(array( 'code' => 2 )); die(); } //清单编号 echo json_encode(array( 'code' => 0, 'msg' => '清单编号：' . $delivery_info['list_sn'] . " 处理成功，还剩余" . count($quene_order_list) . "个清单未处理" )); die(); } /** 批量处理配送队列 * */ public function do_delivery_quene() { $_GPC = I('request.'); $cache_key = $_GPC['cache_key']; $quene_order_list = S('deliveryquene_' . $cache_key); $delivery_id = array_shift($quene_order_list); S('deliveryquene_' . $cache_key, $quene_order_list); $delivery_info = M('lionfish_comshop_deliverylist')->where(array( 'id' => $delivery_id ))->find(); if ($delivery_info['state'] == 0) { if ($delivery_info['state'] == 0) { $this->do_sub_song($delivery_id); } } if (empty($quene_order_list)) { echo json_encode(array( 'code' => 2 )); die(); } //清单编号 echo json_encode(array( 'code' => 0, 'msg' => '清单编号：' . $delivery_info['list_sn'] . " 处理成功，还剩余" . count($quene_order_list) . "个清单未处理" )); die(); } public function delivery_clerk() { $_GPC = I('request.'); $pindex = max(1, intval($_GPC['page'])); $psize = 20; if (!empty($_GPC['keyword'])) { $_GPC['keyword'] = trim($_GPC['keyword']); $condition.= ' and (name like "%' . $_GPC['keyword'] . '%" )'; } $list = M()->query('SELECT * FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliveryclerk WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_deliveryclerk WHERE 1 ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $this->gpc = $_GPC; $this->list = $list; $this->pager = $pager; $this->display(); } public function clerk() { $_GPC = I('request.'); $pindex = max(1, intval($_GPC['page'])); $psize = 20; if (!empty($_GPC['keyword'])) { $_GPC['keyword'] = trim($_GPC['keyword']); $condition.= ' and (name like "%' . $_GPC['keyword'] . '%" )'; } $list = M()->query('SELECT * FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliveryclerk WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_deliveryclerk WHERE 1 ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $this->gpc = $_GPC; $this->list = $list; $this->pager = $pager; $this->display('Delivery/delivery_clerk'); } public function head_ordergoods_detail() { $_GPC = I('request.'); $head_id = $_GPC['head_id']; $is_delivery_add = D('Home/Front')->get_config_by_name('is_delivery_add'); $is_delivery_add = isset($is_delivery_add) && $is_delivery_add == 1 ? 1 : 0; $searchtime = isset($_GPC['searchtime']) ? $_GPC['searchtime'] : ''; $starttime = isset($_GPC['starttime']) ? $_GPC['starttime'] : date('Y-m-d' . ' 00:00:00'); $endtime = isset($_GPC['endtime']) ? $_GPC['endtime'] : date('Y-m-d' . ' 23:59:59'); $order_condition = " "; if (!empty($searchtime)) { $order_condition.= " and pay_time >={$starttime} and pay_time<= {$endtime} "; } if ($is_delivery_add == 1) { $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_refund_state=0 and is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and delivery != 'localtown_delivery' and order_status_id =1 )"; } else { $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_refund_state=0 and is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and delivery != 'express' and delivery != 'localtown_delivery' and order_status_id =1 )"; } $goods_list = M()->query($goods_count_sql); $show_goods_list = array(); foreach ($goods_list as $val) { $val['quantity'] = $val['quantity'] - $val['has_refund_quantity']; if (empty($show_goods_list) || !in_array($val['goods_id'] . '_' . $val['rela_goodsoption_valueid'], array_keys($show_goods_list))) { $sku_name = ''; $sku_arr = array(); $order_option_info = M()->query("select value from " . C('DB_PREFIX') . "lionfish_comshop_order_option where order_id=" . $val['order_id'] . " and order_goods_id=" . $val['order_goods_id']); foreach ($order_option_info as $option) { $sku_arr[] = $option['value']; } if (empty($sku_arr)) { $sku_name = ''; } else { $sku_name = implode(',', $sku_arr); } $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = array( 'name' => $val['name'], 'sku_name' => $sku_name, 'quantity' => $val['quantity'], 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'] ); } else { $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity']+= $val['quantity']; } } $this->head_id = $head_id; $this->gpc = $_GPC; $this->starttime = $starttime; $this->endtime = $endtime; $this->show_goods_list = $show_goods_list; $this->display(); } /** 根据团长生成所有未生成的配送清单 * */ private function do_su_delivery_list($head_id) { $head_info = M('lionfish_community_head')->where(array( 'id' => $head_id ))->find(); $province = D('Home/Front')->get_area_info($head_info['province_id']); $city = D('Home/Front')->get_area_info($head_info['city_id']); $area = D('Home/Front')->get_area_info($head_info['area_id']); $country = D('Home/Front')->get_area_info($head_info['country_id']); $full_name = $province['name'] . $city['name'] . $area['name'] . $country['name'] . $head_info['address']; $order_condition = " "; if (!empty($searchtime)) { //$order_condition .= " and pay_time >={$starttime} and pay_time<= {$endtime} "; } $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where 1 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and delivery != 'express' and delivery != 'localtown_delivery' and order_status_id =1 )"; $goods_list = M()->query($goods_count_sql); $show_goods_list = array(); $goods_count = 0; $order_id_list = array(); foreach ($goods_list as $val) { if (empty($order_id_list) || !in_array($val['order_id'], $order_id_list)) { $order_id_list[] = $val['order_id']; } if (empty($show_goods_list) || !in_array($val['goods_id'] . '_' . $val['rela_goodsoption_valueid'], array_keys($show_goods_list))) { $sku_name = ''; $sku_arr = array(); $order_option_info = M()->query("select value from " . C('DB_PREFIX') . "lionfish_comshop_order_option where order_id=" . $val['order_id'] . " and order_goods_id=" . $val['order_goods_id']); foreach ($order_option_info as $option) { $sku_arr[] = $option['value']; } if (empty($sku_arr)) { $sku_name = ''; } else { $sku_name = implode(',', $sku_arr); } $goods_count+= $val['quantity']; $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = array( 'goods_id' => $val['goods_id'], 'name' => $val['name'], 'goods_images' => $val['goods_images'], 'sku_name' => $sku_name, 'quantity' => $val['quantity'], 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'] ); } else { $goods_count+= $val['quantity']; $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity']+= $val['quantity']; } } //ims_ $line_relate_head = M('lionfish_comshop_deliveryline_headrelative')->field('line_id')->where(array( 'head_id' => $head_id ))->find(); $line_id = 0; $line_name = ''; $clerk_id = 0; if (!empty($line_relate_head)) { $line_id = $line_relate_head['line_id']; $line_info = M('lionfish_comshop_deliveryline')->field('name,clerk_id')->where(array( 'id' => $line_id ))->find(); $line_name = $line_info['name']; $clerk_id = $line_info['clerk_id']; //line_name } $clerk_name = ''; $clerk_mobile = ''; if ($clerk_id > 0) { $clerk_info = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $clerk_id ))->find(); $clerk_name = $clerk_info['name']; $clerk_mobile = $clerk_info['mobile']; } $lionfish_comshop_deliverylist_data = array(); $lionfish_comshop_deliverylist_data['list_sn'] = build_order_no($head_id); $lionfish_comshop_deliverylist_data['head_id'] = $head_id; $lionfish_comshop_deliverylist_data['head_name'] = $head_info['head_name']; $lionfish_comshop_deliverylist_data['head_mobile'] = $head_info['head_mobile']; $lionfish_comshop_deliverylist_data['head_address'] = $full_name; $lionfish_comshop_deliverylist_data['line_id'] = $line_id; $lionfish_comshop_deliverylist_data['line_name'] = $line_name; $lionfish_comshop_deliverylist_data['clerk_id'] = $clerk_id; $lionfish_comshop_deliverylist_data['clerk_name'] = $clerk_name; $lionfish_comshop_deliverylist_data['clerk_mobile'] = $clerk_mobile; $lionfish_comshop_deliverylist_data['state'] = 0; $lionfish_comshop_deliverylist_data['goods_count'] = $goods_count; $lionfish_comshop_deliverylist_data['express_time'] = 0; $lionfish_comshop_deliverylist_data['create_time'] = time(); $lionfish_comshop_deliverylist_data['addtime'] = time(); $list_id = M('lionfish_comshop_deliverylist')->add($lionfish_comshop_deliverylist_data); foreach ($show_goods_list as $goods_val) { //ims_ lionfish_comshop_deliverylist_goods $lionfish_comshop_deliverylist_goods_data = array(); $lionfish_comshop_deliverylist_goods_data['list_id'] = $list_id; $lionfish_comshop_deliverylist_goods_data['goods_id'] = $goods_val['goods_id']; $lionfish_comshop_deliverylist_goods_data['goods_name'] = $goods_val['name']; $lionfish_comshop_deliverylist_goods_data['rela_goodsoption_valueid'] = $goods_val['rela_goodsoption_valueid']; $lionfish_comshop_deliverylist_goods_data['sku_str'] = $goods_val['sku_name']; $lionfish_comshop_deliverylist_goods_data['goods_image'] = $goods_val['goods_images']; $lionfish_comshop_deliverylist_goods_data['goods_count'] = $goods_val['quantity']; $lionfish_comshop_deliverylist_goods_data['addtime'] = time(); M('lionfish_comshop_deliverylist_goods')->add($lionfish_comshop_deliverylist_goods_data); } foreach ($order_id_list as $order_id) { //ims_ lionfish_comshop_deliverylist_order $lionfish_comshop_deliverylist_order_data = array(); $lionfish_comshop_deliverylist_order_data['list_id'] = $list_id; $lionfish_comshop_deliverylist_order_data['order_id'] = $order_id; $lionfish_comshop_deliverylist_order_data['addtime'] = time(); M('lionfish_comshop_deliverylist_order')->add($lionfish_comshop_deliverylist_order_data); M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->save(array( 'is_delivery_flag' => 1 )); } } public function sub_delivery_list() { $_GPC = I('request.'); $is_delivery_add = D('Home/Front')->get_config_by_name('is_delivery_add'); $is_delivery_add = isset($is_delivery_add) && $is_delivery_add == 1 ? 1 : 0; //TODO....... $head_id = $_GPC['head_id']; $searchtime = isset($_GPC['searchtime']) ? $_GPC['searchtime'] : ''; $starttime = isset($_GPC['starttime']) ? $_GPC['starttime'] : ''; $endtime = isset($_GPC['endtime']) ? $_GPC['endtime'] : ''; if (empty($head_id)) { $head_id = (is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0); } $head_arr = explode(',', $head_id); foreach ($head_arr as $head_id) { if (empty($head_id)) { continue; } $head_info = M('lionfish_community_head')->where(array( 'id' => $head_id ))->find(); $province = D('Home/Front')->get_area_info($head_info['province_id']); $city = D('Home/Front')->get_area_info($head_info['city_id']); $area = D('Home/Front')->get_area_info($head_info['area_id']); $country = D('Home/Front')->get_area_info($head_info['country_id']); $full_name = $province['name'] . $city['name'] . $area['name'] . $country['name'] . $head_info['address']; $order_condition = " "; if (!empty($searchtime)) { if ($searchtime == 'create') { $order_condition.= " and date_added >={$starttime} and date_added<= {$endtime} "; } else if ($searchtime == 'pay') { $order_condition.= " and pay_time >={$starttime} and pay_time<= {$endtime} "; } } if ($is_delivery_add == 1) { $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where is_refund_state=0 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_refund_state=0 and is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and delivery != 'localtown_delivery' and order_status_id =1 )"; } else { $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where is_refund_state=0 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_refund_state=0 and is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and delivery != 'express' and delivery != 'localtown_delivery' and order_status_id =1 )"; } $goods_list = M()->query($goods_count_sql); $show_goods_list = array(); $goods_count = 0; $order_id_list = array(); foreach ($goods_list as $val) { $val['quantity'] = $val['quantity'] - $val['has_refund_quantity']; if (empty($order_id_list) || !in_array($val['order_id'], $order_id_list)) { $order_id_list[] = $val['order_id']; } if (empty($show_goods_list) || !in_array($val['goods_id'] . '_' . $val['rela_goodsoption_valueid'], array_keys($show_goods_list))) { $sku_name = ''; $sku_arr = array(); $order_option_info = M()->query("select value from " . C('DB_PREFIX') . "lionfish_comshop_order_option where order_id=" . $val['order_id'] . " and order_goods_id=" . $val['order_goods_id']); foreach ($order_option_info as $option) { $sku_arr[] = $option['value']; } if (empty($sku_arr)) { $sku_name = ''; } else { $sku_name = implode(',', $sku_arr); } $goods_count+= $val['quantity']; $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = array( 'goods_id' => $val['goods_id'], 'name' => $val['name'], 'goods_images' => $val['goods_images'], 'sku_name' => $sku_name, 'quantity' => $val['quantity'], 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'] ); } else { $goods_count+= $val['quantity']; $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity']+= $val['quantity']; } } //ims_ $line_relate_head = M('lionfish_comshop_deliveryline_headrelative')->field('line_id')->where(array( 'head_id' => $head_id ))->find(); $line_id = 0; $line_name = ''; $clerk_id = 0; if (!empty($line_relate_head)) { $line_id = $line_relate_head['line_id']; $line_info = M('lionfish_comshop_deliveryline')->field('name,clerk_id')->where(array( 'id' => $line_id ))->find(); $line_name = $line_info['name']; $clerk_id = $line_info['clerk_id']; //line_name } $clerk_name = ''; $clerk_mobile = ''; if ($clerk_id > 0) { $clerk_info = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $clerk_id ))->find(); $clerk_name = $clerk_info['name']; $clerk_mobile = $clerk_info['mobile']; } $lionfish_comshop_deliverylist_data = array(); $lionfish_comshop_deliverylist_data['list_sn'] = build_order_no($head_id); $lionfish_comshop_deliverylist_data['head_id'] = $head_id; $lionfish_comshop_deliverylist_data['head_name'] = $head_info['head_name']; $lionfish_comshop_deliverylist_data['head_mobile'] = $head_info['head_mobile']; $lionfish_comshop_deliverylist_data['head_address'] = $full_name; $lionfish_comshop_deliverylist_data['line_id'] = $line_id; $lionfish_comshop_deliverylist_data['line_name'] = $line_name; $lionfish_comshop_deliverylist_data['clerk_id'] = $clerk_id; $lionfish_comshop_deliverylist_data['clerk_name'] = $clerk_name; $lionfish_comshop_deliverylist_data['clerk_mobile'] = $clerk_mobile; $lionfish_comshop_deliverylist_data['state'] = 0; $lionfish_comshop_deliverylist_data['goods_count'] = $goods_count; $lionfish_comshop_deliverylist_data['express_time'] = 0; $lionfish_comshop_deliverylist_data['create_time'] = time(); $lionfish_comshop_deliverylist_data['addtime'] = time(); $list_id = M('lionfish_comshop_deliverylist')->add($lionfish_comshop_deliverylist_data); foreach ($show_goods_list as $goods_val) { //ims_ lionfish_comshop_deliverylist_goods $lionfish_comshop_deliverylist_goods_data = array(); $lionfish_comshop_deliverylist_goods_data['list_id'] = $list_id; $lionfish_comshop_deliverylist_goods_data['goods_id'] = $goods_val['goods_id']; $lionfish_comshop_deliverylist_goods_data['goods_name'] = $goods_val['name']; $lionfish_comshop_deliverylist_goods_data['rela_goodsoption_valueid'] = $goods_val['rela_goodsoption_valueid']; $lionfish_comshop_deliverylist_goods_data['sku_str'] = $goods_val['sku_name']; $lionfish_comshop_deliverylist_goods_data['goods_image'] = $goods_val['goods_images']; $lionfish_comshop_deliverylist_goods_data['goods_count'] = $goods_val['quantity']; $lionfish_comshop_deliverylist_goods_data['addtime'] = time(); M('lionfish_comshop_deliverylist_goods')->add($lionfish_comshop_deliverylist_goods_data); } foreach ($order_id_list as $order_id) { //ims_ lionfish_comshop_deliverylist_order $lionfish_comshop_deliverylist_order_data = array(); $lionfish_comshop_deliverylist_order_data['list_id'] = $list_id; $lionfish_comshop_deliverylist_order_data['order_id'] = $order_id; $lionfish_comshop_deliverylist_order_data['addtime'] = time(); M('lionfish_comshop_deliverylist_order')->add($lionfish_comshop_deliverylist_order_data); M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->save(array( 'is_delivery_flag' => 1 )); } //line_id clerk_id lionfish_comshop_deliverylist_order //ims_ lionfish_comshop_order } show_json(1, array( 'msg' => '生成清单成功', 'url' => $_SERVER['HTTP_REFERER'] )); } /** 一键生成所有清单 * */ public function auto_get_delivery_list() { $this->display(); } public function do_quenu_deliverylist() { @set_time_limit(0); //快递zhege is_delivery_add $is_delivery_add = D('Home/Front')->get_config_by_name('is_delivery_add'); $is_delivery_add = isset($is_delivery_add) && $is_delivery_add == 1 ? 1 : 0; if($is_delivery_add == 1) { $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'localtown_delivery' "; }else{ $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'express' and delivery != 'localtown_delivery' "; } $list = M()->query('SELECT head_id FROM ' . C('DB_PREFIX') . "lionfish_comshop_order WHERE 1 " . $condition . ' group by head_id order by head_id desc limit 0,10'); if (!empty($list)) { foreach ($list as $hd_vv) { $head_id = $hd_vv['head_id']; if (empty($head_id)) { continue; } $head_info = M('lionfish_community_head')->where(array( 'id' => $head_id ))->find(); $province = D('Home/Front')->get_area_info($head_info['province_id']); $city = D('Home/Front')->get_area_info($head_info['city_id']); $area = D('Home/Front')->get_area_info($head_info['area_id']); $country = D('Home/Front')->get_area_info($head_info['country_id']); $full_name = $province['name'] . $city['name'] . $area['name'] . $country['name'] . $head_info['address']; $order_condition = " "; if($is_delivery_add == 1) { $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where 1 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and order_status_id =1 and delivery != 'localtown_delivery' )"; }else{ $goods_count_sql = "SELECT * FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where 1 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 and head_id={$head_id} {$order_condition} and delivery != 'express' and delivery != 'localtown_delivery' and order_status_id =1 )"; } $goods_list = M()->query($goods_count_sql); if( empty($goods_list) ) { \Think\Log::write('生成配送单，无商品既然生成了:'.$head_id.'__'.$order_condition,'WARN'); } $show_goods_list = array(); $goods_count = 0; $order_id_list = array(); if( empty($goods_list) ) { continue; } foreach ($goods_list as $val) { if (empty($order_id_list) || !in_array($val['order_id'], $order_id_list)) { $order_id_list[] = $val['order_id']; } if (empty($show_goods_list) || !in_array($val['goods_id'] . '_' . $val['rela_goodsoption_valueid'], array_keys($show_goods_list))) { $sku_name = ''; $sku_arr = array(); $order_option_info = M()->query("select value from " . C('DB_PREFIX') . "lionfish_comshop_order_option where order_id=" . $val['order_id'] . " and order_goods_id=" . $val['order_goods_id']); foreach ($order_option_info as $option) { $sku_arr[] = $option['value']; } if (empty($sku_arr)) { $sku_name = ''; } else { $sku_name = implode(',', $sku_arr); } $goods_count+= $val['quantity']; $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = array( 'goods_id' => $val['goods_id'], 'name' => $val['name'], 'goods_images' => $val['goods_images'], 'sku_name' => $sku_name, 'quantity' => $val['quantity'], 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'] ); } else { $goods_count+= $val['quantity']; $show_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]['quantity']+= $val['quantity']; } } //ims_ $line_relate_head = M('lionfish_comshop_deliveryline_headrelative')->field('line_id')->where(array( 'head_id' => $head_id ))->find(); $line_id = 0; $line_name = ''; $clerk_id = 0; if (!empty($line_relate_head)) { $line_id = $line_relate_head['line_id']; $line_info = M('lionfish_comshop_deliveryline')->field('name,clerk_id')->where(array( 'id' => $line_id ))->find(); $line_name = $line_info['name']; $clerk_id = $line_info['clerk_id']; //line_name } $clerk_name = ''; $clerk_mobile = ''; if ($clerk_id > 0) { $clerk_info = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $clerk_id ))->find(); $clerk_name = $clerk_info['name']; $clerk_mobile = $clerk_info['mobile']; } if( empty($show_goods_list) ) { continue; } $lionfish_comshop_deliverylist_data = array(); $lionfish_comshop_deliverylist_data['list_sn'] = build_order_no($head_id); $lionfish_comshop_deliverylist_data['head_id'] = $head_id; $lionfish_comshop_deliverylist_data['head_name'] = $head_info['head_name']; $lionfish_comshop_deliverylist_data['head_mobile'] = $head_info['head_mobile']; $lionfish_comshop_deliverylist_data['head_address'] = $full_name; $lionfish_comshop_deliverylist_data['line_id'] = $line_id; $lionfish_comshop_deliverylist_data['line_name'] = $line_name; $lionfish_comshop_deliverylist_data['clerk_id'] = $clerk_id; $lionfish_comshop_deliverylist_data['clerk_name'] = $clerk_name; $lionfish_comshop_deliverylist_data['clerk_mobile'] = $clerk_mobile; $lionfish_comshop_deliverylist_data['state'] = 0; $lionfish_comshop_deliverylist_data['goods_count'] = $goods_count; $lionfish_comshop_deliverylist_data['express_time'] = 0; $lionfish_comshop_deliverylist_data['create_time'] = time(); $lionfish_comshop_deliverylist_data['addtime'] = time(); $list_id = M('lionfish_comshop_deliverylist')->add($lionfish_comshop_deliverylist_data); foreach ($show_goods_list as $goods_val) { //ims_ lionfish_comshop_deliverylist_goods $lionfish_comshop_deliverylist_goods_data = array(); $lionfish_comshop_deliverylist_goods_data['list_id'] = $list_id; $lionfish_comshop_deliverylist_goods_data['goods_id'] = $goods_val['goods_id']; $lionfish_comshop_deliverylist_goods_data['goods_name'] = $goods_val['name']; $lionfish_comshop_deliverylist_goods_data['rela_goodsoption_valueid'] = $goods_val['rela_goodsoption_valueid']; $lionfish_comshop_deliverylist_goods_data['sku_str'] = $goods_val['sku_name']; $lionfish_comshop_deliverylist_goods_data['goods_image'] = $goods_val['goods_images']; $lionfish_comshop_deliverylist_goods_data['goods_count'] = $goods_val['quantity']; $lionfish_comshop_deliverylist_goods_data['addtime'] = time(); M('lionfish_comshop_deliverylist_goods')->add($lionfish_comshop_deliverylist_goods_data); } foreach ($order_id_list as $order_id) { //ims_ lionfish_comshop_deliverylist_order $lionfish_comshop_deliverylist_order_data = array(); $lionfish_comshop_deliverylist_order_data['list_id'] = $list_id; $lionfish_comshop_deliverylist_order_data['order_id'] = $order_id; $lionfish_comshop_deliverylist_order_data['addtime'] = time(); M('lionfish_comshop_deliverylist_order')->add($lionfish_comshop_deliverylist_order_data); M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->save(array( 'is_delivery_flag' => 1 )); } } if($is_delivery_add == 1) { $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'localtown_delivery' "; }else{ $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'express' and delivery != 'localtown_delivery' "; } $total_arr = M()->query('SELECT order_id, head_id FROM ' . C('DB_PREFIX') . 'lionfish_comshop_order WHERE 1 ' . $condition . ' group by head_id order by head_id desc '); $total = count($total_arr); if ($total > 0) { echo json_encode(array( 'code' => 0, 'msg' => '还剩' . $total . '个未生成' )); die(); } else { echo json_encode(array( 'code' => 2 )); die(); } //echo json_encode( array('code' => 2) ); //die(); } else { echo json_encode(array( 'code' => 2 )); die(); } } public function get_list() { $_GPC = I('request.'); $searchtime = isset($_GPC['searchtime']) ? $_GPC['searchtime'] : ''; $starttime = isset($_GPC['time']['start']) ? strtotime($_GPC['time']['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($_GPC['time']['end']) ? strtotime($_GPC['time']['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); $keyword = isset($_GPC['keyword']) ? addslashes($_GPC['keyword']) : ''; $line_id = isset($_GPC['line_id']) ? intval($_GPC['line_id']) : 0; $is_delivery_add = D('Home/Front')->get_config_by_name('is_delivery_add'); $is_delivery_add = isset($is_delivery_add) && $is_delivery_add == 1 ? 1 : 0; if ($is_delivery_add == 1) { $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'localtown_delivery' "; } else { $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'express' and delivery != 'localtown_delivery' "; } $this->searchtime = $searchtime; $this->starttime = $starttime; $this->endtime = $endtime; $keyword2 = stripslashes($keyword); $this->keyword = $keyword2; $this->line_id = $line_id; $timewhere = ""; if (!empty($searchtime)) { if ($searchtime == 'create') { $condition.= " and date_added >={$starttime} and date_added<= {$endtime} "; $timewhere.= " and date_added >={$starttime} and date_added<= {$endtime} "; } else if ($searchtime == 'pay') { $condition.= " and pay_time >={$starttime} and pay_time<= {$endtime} "; $timewhere.= " and pay_time >={$starttime} and pay_time<= {$endtime} "; } } if (!empty($keyword)) { $key_heads = M('lionfish_community_head')->field('id')->where("community_name like '%" . $keyword . "%' ")->select(); if (!empty($key_heads)) { $head_ids = array(); foreach ($key_heads as $vv) { $head_ids[] = $vv['id']; } $head_ids_str = implode(',', $head_ids); $condition.= " and head_id in({$head_ids_str}) "; } else { $condition.= " and 0 "; } } if ($line_id > 0) { $relate_heads = M('lionfish_comshop_deliveryline_headrelative')->where(array( 'line_id' => $line_id ))->select(); if (!empty($relate_heads)) { $head_ids = array(); foreach ($relate_heads as $vv) { $head_ids[] = $vv['head_id']; } $head_ids_str = implode(',', $head_ids); $condition.= " and head_id in({$head_ids_str}) "; } else { $condition.= " and 0 "; } } $pindex = max(1, intval($_GPC['page'])); $psize = 20; $list = M()->query('SELECT order_id, head_id FROM ' . C('DB_PREFIX') . "lionfish_comshop_order WHERE 1 " . $condition . ' and head_id > 0 group by head_id order by head_id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); $total_arr = M()->query('SELECT order_id, head_id FROM ' . C('DB_PREFIX') . 'lionfish_comshop_order WHERE 1 ' . $condition . ' and head_id > 0 group by head_id order by head_id desc '); $total = count($total_arr); foreach ($list as $key => $val) { //店铺名称 配送路线 商品总数 操作 $head_info = M('lionfish_community_head')->field('community_name')->where(array( 'id' => $val['head_id'] ))->find(); $line_id_info = M('lionfish_comshop_deliveryline_headrelative')->field('line_id')->where(array( 'head_id' => $val['head_id'] ))->find(); $line_info = array(); if (!empty($line_id_info)) { //line_id $line_info = M('lionfish_comshop_deliveryline')->where(array( 'id' => $line_id_info['line_id'] ))->find(); } if ($is_delivery_add == 1) { $goods_count_sql = "SELECT sum(quantity-has_refund_quantity) as total_quantity FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where is_refund_state=0 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 {$timewhere} and head_id=" . $val['head_id'] . " and delivery != 'localtown_delivery' and order_status_id =1 )"; } else { $goods_count_sql = "SELECT sum(quantity-has_refund_quantity) as total_quantity FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where is_refund_state=0 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 {$timewhere} and head_id=" . $val['head_id'] . " and delivery != 'express' and delivery != 'localtown_delivery' and order_status_id =1 )"; } $goods_count_arr = M()->query($goods_count_sql); $goods_count = $goods_count_arr[0]['total_quantity']; $val['community_name'] = $head_info['community_name']; $val['line_name'] = $line_info['name']; $val['goods_count'] = $goods_count; $list[$key] = $val; } $pager = pagination2($total, $pindex, $psize); $line_list = M('lionfish_comshop_deliveryline')->select(); $this->list = $list; $this->line_list = $line_list; $this->pager = $pager; $this->gpc = $_GPC; $this->display('Delivery/get_delivery_list'); } public function get_delivery_list() { $_GPC = I('request.'); $searchtime = isset($_GPC['searchtime']) ? $_GPC['searchtime'] : ''; $starttime = isset($_GPC['time']['start']) ? strtotime($_GPC['time']['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($_GPC['time']['end']) ? strtotime($_GPC['time']['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); $keyword = isset($_GPC['keyword']) ? addslashes($_GPC['keyword']) : ''; $line_id = isset($_GPC['line_id']) ? intval($_GPC['line_id']) : 0; $is_delivery_add = D('Home/Front')->get_config_by_name('is_delivery_add'); $is_delivery_add = isset($is_delivery_add) && $is_delivery_add == 1 ? 1 : 0; if ($is_delivery_add == 1) { $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'localtown_delivery' "; } else { $condition = " and is_delivery_flag = 0 and order_status_id =1 and delivery != 'express' and delivery != 'localtown_delivery' "; } $this->searchtime = $searchtime; $this->starttime = $starttime; $this->endtime = $endtime; $keyword2 = stripslashes($keyword); $this->keyword = $keyword2; $this->line_id = $line_id; $timewhere = ""; if (!empty($searchtime)) { if ($searchtime == 'create') { $condition.= " and date_added >={$starttime} and date_added<= {$endtime} "; $timewhere.= " and date_added >={$starttime} and date_added<= {$endtime} "; } else if ($searchtime == 'pay') { $condition.= " and pay_time >={$starttime} and pay_time<= {$endtime} "; $timewhere.= " and pay_time >={$starttime} and pay_time<= {$endtime} "; } } if (!empty($keyword)) { $key_heads = M('lionfish_community_head')->field('id')->where("community_name like '%" . $keyword . "%' ")->select(); if (!empty($key_heads)) { $head_ids = array(); foreach ($key_heads as $vv) { $head_ids[] = $vv['id']; } $head_ids_str = implode(',', $head_ids); $condition.= " and head_id in({$head_ids_str}) "; } else { $condition.= " and 0 "; } } if ($line_id > 0) { $relate_heads = M('lionfish_comshop_deliveryline_headrelative')->where(array( 'line_id' => $line_id ))->select(); if (!empty($relate_heads)) { $head_ids = array(); foreach ($relate_heads as $vv) { $head_ids[] = $vv['head_id']; } $head_ids_str = implode(',', $head_ids); $condition.= " and head_id in({$head_ids_str}) "; } else { $condition.= " and 0 "; } } $pindex = max(1, intval($_GPC['page'])); $psize = 20; $list = M()->query('SELECT order_id, head_id FROM ' . C('DB_PREFIX') . "lionfish_comshop_order WHERE 1 " . $condition . ' and head_id > 0 group by head_id order by head_id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); $total_arr = M()->query('SELECT order_id, head_id FROM ' . C('DB_PREFIX') . 'lionfish_comshop_order WHERE 1 ' . $condition . ' and head_id > 0 group by head_id order by head_id desc '); $total = count($total_arr); foreach ($list as $key => $val) { //店铺名称 配送路线 商品总数 操作 $head_info = M('lionfish_community_head')->field('community_name')->where(array( 'id' => $val['head_id'] ))->find(); $line_id_info = M('lionfish_comshop_deliveryline_headrelative')->field('line_id')->where(array( 'head_id' => $val['head_id'] ))->find(); $line_info = array(); if (!empty($line_id_info)) { //line_id $line_info = M('lionfish_comshop_deliveryline')->where(array( 'id' => $line_id_info['line_id'] ))->find(); } if ($is_delivery_add == 1) { $goods_count_sql = "SELECT sum(quantity-has_refund_quantity) as total_quantity FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where is_refund_state=0 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 {$timewhere} and head_id=" . $val['head_id'] . " and order_status_id =1 and delivery != 'localtown_delivery' )"; } else { $goods_count_sql = "SELECT sum(quantity-has_refund_quantity) as total_quantity FROM " . C('DB_PREFIX') . "lionfish_comshop_order_goods where is_refund_state=0 and order_id in (SELECT order_id from " . C('DB_PREFIX') . "lionfish_comshop_order where is_delivery_flag = 0 {$timewhere} and head_id=" . $val['head_id'] . " and delivery != 'express' and delivery != 'localtown_delivery' and order_status_id =1 )"; } $goods_count_arr = M()->query($goods_count_sql); $goods_count = $goods_count_arr[0]['total_quantity']; $val['community_name'] = $head_info['community_name']; $val['line_name'] = $line_info['name']; $val['goods_count'] = $goods_count; $list[$key] = $val; } $pager = pagination2($total, $pindex, $psize); $line_list = M('lionfish_comshop_deliveryline')->select(); $this->list = $list; $this->line_list = $line_list; $this->pager = $pager; $this->gpc = $_GPC; $this->display(); } public function line() { $_GPC = I('request.'); $pindex = max(1, intval($_GPC['page'])); $psize = 20; if (!empty($_GPC['keyword'])) { $condition.= ' and (name like "%' . $_GPC['keyword'] . '%" )'; } $list = M()->query('SELECT * FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliveryline WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); foreach ($list as $key => $val) { //clerk_id if ($val['clerk_id'] > 0) { $clerk_name = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $val['clerk_id'] ))->find(); $val['clerk_info'] = $clerk_name; } // lionfish_comshop_deliveryline_headrelative $head_relative = M()->query("select * from " . C('DB_PREFIX') . "lionfish_comshop_deliveryline_headrelative where 1 and line_id=" . $val['id'] . " order by id asc "); $val['line_to_str'] = ''; if (!empty($head_relative)) { $head_id_arr = array(); foreach ($head_relative as $vv) { $head_id_arr[] = $vv['head_id']; } $head_list = M()->query("select community_name from " . C('DB_PREFIX') . "lionfish_community_head where 1 and id in (" . implode(',', $head_id_arr) . ")"); $line_to_arr = array(); foreach ($head_list as $hd_val) { $line_to_arr[] = $hd_val['community_name']; } $val['line_to_str'] = implode('->', $line_to_arr); } //line_to_str $list[$key] = $val; } $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_deliveryline WHERE 1 ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $this->gpc = $_GPC; $this->list = $list; $this->pager = $pager; $this->display('Delivery/delivery_line'); } public function delivery_line() { $_GPC = I('request.'); $pindex = max(1, intval($_GPC['page'])); $psize = 20; if (!empty($_GPC['keyword'])) { $condition.= ' and (name like "%' . $_GPC['keyword'] . '%" )'; } $list = M()->query('SELECT * FROM ' . C('DB_PREFIX') . "lionfish_comshop_deliveryline WHERE 1 " . $condition . ' order by id desc limit ' . (($pindex - 1) * $psize) . ',' . $psize); foreach ($list as $key => $val) { //clerk_id if ($val['clerk_id'] > 0) { $clerk_name = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $val['clerk_id'] ))->find(); $val['clerk_info'] = $clerk_name; } // lionfish_comshop_deliveryline_headrelative $head_relative = M()->query("select * from " . C('DB_PREFIX') . "lionfish_comshop_deliveryline_headrelative where 1 and line_id=" . $val['id'] . " order by id asc "); $val['line_to_str'] = ''; if (!empty($head_relative)) { $head_id_arr = array(); foreach ($head_relative as $vv) { $head_id_arr[] = $vv['head_id']; } $head_list = M()->query("select community_name from " . C('DB_PREFIX') . "lionfish_community_head where 1 and id in (" . implode(',', $head_id_arr) . ")"); $line_to_arr = array(); foreach ($head_list as $hd_val) { $line_to_arr[] = $hd_val['community_name']; } $val['line_to_str'] = implode('->', $line_to_arr); } //line_to_str $list[$key] = $val; } $total_arr = M()->query('SELECT count(1) as count FROM ' . C('DB_PREFIX') . 'lionfish_comshop_deliveryline WHERE 1 ' . $condition); $total = $total_arr[0]['count']; $pager = pagination2($total, $pindex, $psize); $this->gpc = $_GPC; $this->list = $list; $this->pager = $pager; $this->display(); } public function delivery_allprint_order() { $condition = " state=0 "; $gpc = I('request.'); $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['start']) ? strtotime($gpc['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['end']) ? strtotime($gpc['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); $type = isset($gpc['type']) ? $gpc['type'] : 1; if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and create_time > {$starttime} and create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and express_time > {$starttime} and express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and head_get_time > {$starttime} and head_get_time < {$endtime} "; } } $count = M('lionfish_comshop_deliverylist')->where($condition)->count(); $this->searchtime = $gpc['searchtime']; $this->starttime = $gpc['start']; $this->endtime = $gpc['end']; $this->count = $count; $this->type = $type; if ($type == 2) { $this->display('Delivery/delivery_allprint_order_2'); } else if ($type == 1) { $this->display(); } } public function delivery_allprint_order_do() { @set_time_limit(0); $page = I('get.page', 1); $type = I('get.type', 1); $offset = ($page - 1) * 10; $condition = " state=0 "; $gpc = I('request.'); $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['starttime']) ? strtotime($gpc['starttime']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['endtime']) ? strtotime($gpc['endtime']) : strtotime(date('Y-m-d' . ' 23:59:59')); if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and create_time > {$starttime} and create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and express_time > {$starttime} and express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and head_get_time > {$starttime} and head_get_time < {$endtime} "; } } $list = M('lionfish_comshop_deliverylist')->where($condition)->order('clerk_id desc,head_id desc')->limit($offset, 10)->select(); if (empty($list)) { echo json_encode(array( 'code' => 1 )); die(); } if (!empty($list)) { $need_data = array(); $tuanz_info = array(); $order_goods_list = array(); $order_list_arr = array(); $need_user_head_delivery_list_all = array(); $head_count_arr = array(); foreach ($list as $delivery_info) { //if( empty($tuanz_info) ) //{ $tuanz_info = $delivery_info; //} $order_list = M('lionfish_comshop_deliverylist_order')->where(array( 'list_id' => $delivery_info['id'] ))->order('id asc')->select(); $need_order_list = array(); if (!empty($order_list)) { foreach ($order_list as $kkk => $vvv) { $order_id = $vvv['order_id']; $order_info = M('lionfish_comshop_order')->where(array( 'order_id' => $order_id ))->find(); $order_goods = M('lionfish_comshop_order_goods')->where(array( 'order_id' => $order_id ))->order('order_goods_id asc')->select(); //username shipping_name shipping_tel $mb_info = M('lionfish_comshop_member')->field('username')->where(array( 'member_id' => $order_info['member_id'] ))->find(); $order_info['username'] = $mb_info['username']; $goods_list = array(); $order_all_total = 0; foreach ($order_goods as $og_infos) { $sku_name = ''; $sku_arr = array(); $goods_price = $og_infos['price']; if (!empty($og_infos['rela_goodsoption_valueid'])) { $order_option_info = M()->query("select value from " . C('DB_PREFIX') . "lionfish_comshop_order_option where order_id=" . $og_infos['order_id'] . " and order_goods_id=" . $og_infos['order_goods_id']); foreach ($order_option_info as $option) { $sku_arr[] = $option['value']; } if (empty($sku_arr)) { $sku_name = ''; } else { $sku_name = implode(',', $sku_arr); } $goods_option_item = M('lionfish_comshop_goods_option_item_value')->field('marketprice')->where(array( 'option_item_ids' => $og_infos['rela_goodsoption_valueid']))->find(); if(!empty($goods_option_item)){ $goods_price = $goods_option_item['marketprice']; } }else{ $goods_info = M('lionfish_comshop_goods')->field('price')->where(array( 'id' => $og_infos['goods_id']))->find(); if(!empty($goods_info)){ $goods_price = $goods_info['price']; } } $tmp = array(); $tmp['name'] = $og_infos['name']; $tmp['rela_goodsoption_valueid'] = $og_infos['rela_goodsoption_valueid']; $tmp['goods_id'] = $og_infos['goods_id']; $tmp['quantity'] = $og_infos['quantity']-$og_infos['has_refund_quantity']; $tmp['sku_name'] = $sku_name; $tmp['price'] = $og_infos['price']; //$tmp['total'] = sprintf('%.2f', $og_infos['price'] * $og_infos['quantity']); $tmp['total'] = sprintf('%.2f', $goods_price * $og_infos['quantity']); if($og_infos['has_refund_quantity'] < $og_infos['quantity']){ $goods_list[] = $tmp; $order_all_total = $order_all_total + $goods_price * ($og_infos['quantity']-$og_infos['has_refund_quantity']); } } $order_info['deliverylist_addtime'] = $delivery_info['addtime']; // 清单create 时间 $order_info['head_name'] = $delivery_info['head_name']; $order_info['head_address'] = $delivery_info['head_address']; $order_info['order_goods'] = $goods_list; $order_info['order_all_total'] = round($order_all_total,2); $order_info['wait_pay_money'] = 0; if( $order_info['payment_code'] == 'cashon_delivery' ) { $wait_pay_moeny = D('Home/OrderV2')->getOrderTotalMoney( $order_info ); //货到付款 $order_info['wait_pay_money'] = $wait_pay_moeny; } $need_order_list[] = $order_info; } } $last_index_sort = array_column($need_order_list, 'username'); array_multisort($last_index_sort, SORT_DESC, $need_order_list); //member_id_goods_id_delivery if (!empty($need_order_list)) { $need_user_head_delivery_list = array(); foreach ($need_order_list as $key => $val) { foreach ($val['order_goods'] as $goods) { $sv_key = $val['member_id'] .'_'.$val['shipping_name']. '_' . $val['delivery']; if (empty($head_count_arr) || !isset($head_count_arr[$val['head_id']])) { $head_count_arr[$val['head_id']] = $goods['quantity']; } else { $head_count_arr[$val['head_id']]+= $goods['quantity']; } if (empty($need_user_head_delivery_list) || !isset($need_user_head_delivery_list[$sv_key])) { $head_info = M('lionfish_community_head')->field('community_name')->where(array( 'id' => $val['head_id'] ))->find(); $hd_info = array(); $hd_info['head_name'] = $head_info['community_name']; $hd_info['goods_name'] = $goods['name']; $hd_info['sku_name'] = $goods['sku_name']; $hd_info['quantity'] = $goods['quantity']; $hd_info['shipping_name'] = $val['shipping_name']; $hd_info['shipping_tel'] = $val['shipping_tel']; $hd_info['price'] = $goods['price']; $hd_info['total'] = $goods['total']; $goods_key = $goods['goods_id'] . $goods['rela_goodsoption_valueid'] . '_' . $val['delivery']; $us_info = array(); $us_info['community_name'] = $head_info['community_name']; $us_info['shipping_name'] = $val['shipping_name']; $us_info['shipping_tel'] = $val['shipping_tel']; $us_info['tuan_send_address'] = $val['tuan_send_address']; $us_info['shipping_address'] = $val['shipping_address']; $us_info['delivery'] = $val['delivery']; $us_info['head_id'] = $val['head_id']; $delivery_name = '自提'; //shipping_address if ($val['delivery'] == 'tuanz_send') { $delivery_name = '配送'; // 'express', 'pickup', 'tuanz_send' } else if ($val['delivery'] == 'express') { $delivery_name = '快递'; $province_info = D('Home/Front')->get_area_info($val['shipping_province_id']); $city_info = D('Home/Front')->get_area_info($val['shipping_city_id']); $area_info = D('Home/Front')->get_area_info($val['shipping_country_id']); $us_info['shipping_address'] = $province_info['name'] . $city_info['name'] . $area_info['name'] . $val['shipping_address']; } $us_info['delivery_name'] = $delivery_name; $need_user_head_delivery_list[$sv_key]['goods_arr'][$goods_key] = $hd_info; // 清单创建时间 $us_info['deliverylist_addtime'] = $val['deliverylist_addtime']; // 团长信息 $us_info['head_name'] = $val['head_name']; $us_info['head_mobile'] =$tuanz_info['head_mobile']; $us_info['head_address'] = $val['head_address']; $us_info['wait_pay_money'] = $val['wait_pay_money']; $need_user_head_delivery_list[$sv_key]['user_info'] = $us_info; } else { $goods_key = $goods['goods_id'] . $goods['rela_goodsoption_valueid'] . '_' . $val['delivery']; if (isset($need_user_head_delivery_list[$sv_key]['goods_arr'][$goods_key])) { $need_user_head_delivery_list[$sv_key]['goods_arr'][$goods_key]['quantity']+= $goods['quantity']; } else { $head_info = M('lionfish_community_head')->field('community_name')->where(array( 'id' => $val['head_id'] ))->find(); $hd_info = array(); $hd_info['head_name'] = $head_info['community_name']; $hd_info['goods_name'] = $goods['name']; $hd_info['sku_name'] = $goods['sku_name']; $hd_info['quantity'] = $goods['quantity']; $hd_info['shipping_name'] = $val['shipping_name']; $hd_info['shipping_tel'] = $val['shipping_tel']; $hd_info['price'] = $goods['price']; $hd_info['total'] = $goods['total']; $need_user_head_delivery_list[$sv_key]['goods_arr'][$goods_key] = $hd_info; } } } } $need_user_head_delivery_list_all[] = $need_user_head_delivery_list; } //获取货到付款订单信息 begin $delivery_order_list = M('lionfish_comshop_deliverylist_order')->where( "list_id=".$delivery_info['id'] )->select(); $wait_pay_moeny_list = []; if( !empty($delivery_order_list) ) { foreach( $delivery_order_list as $delivery_order ) { $order_id = $delivery_order['order_id']; $order_info = M('lionfish_comshop_order')->where("order_id={$order_id}" )->find(); if( $order_info['payment_code'] == 'cashon_delivery' ) { //货到付款 $wait_pay_moeny = D('Home/OrderV2')->getOrderTotalMoney( $order_info ); $username = $order_info['shipping_name']; $mobile = $order_info['shipping_tel']; $wait_pay_moeny_list[] = [ 'order_id' => $order_id ,'username' => $username, 'moble' => $mobile , 'wait_pay_money' => $wait_pay_moeny ]; } } } //获取货到付款订单信息 end $need_data[] = array( 'head_info' => $tuanz_info, 'wait_pay_moeny_list' => $wait_pay_moeny_list, 'need_order_list' => $need_order_list ); } } $this->need_user_head_delivery_list = $need_user_head_delivery_list_all; $this->head_count_arr = $head_count_arr; $this->need_data = $need_data; $this->shoname = D('Home/Front')->get_config_by_name('shoname'); $this->page = $page; if ($type == 2) { $html = $this->fetch('Delivery/delivery_allprint_order_dofetch_2'); } else { $html = $this->fetch('Delivery/delivery_allprint_order_dofetch'); } echo json_encode(array( 'code' => 0, 'html' => $html )); die(); //$this->display(); } public function delivery_allprint() { $gpc = I('request.'); $condition = " state=0 "; $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['start']) ? strtotime($gpc['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['end']) ? strtotime($gpc['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and create_time > {$starttime} and create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and express_time > {$starttime} and express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and head_get_time > {$starttime} and head_get_time < {$endtime} "; } } $count = M('lionfish_comshop_deliverylist')->where($condition)->count(); $this->searchtime = $gpc['searchtime']; $this->starttime = $gpc['start']; $this->endtime = $gpc['end']; $this->count = $count; $this->display(); } public function delivery_allprint_do() { @set_time_limit(0); $page = I('get.page', 1); $offset = ($page - 1) * 10; $condition = " state=0 "; $gpc = I('request.'); $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['starttime']) ? strtotime($gpc['starttime']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['endtime']) ? strtotime($gpc['endtime']) : strtotime(date('Y-m-d' . ' 23:59:59')); if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and create_time > {$starttime} and create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and express_time > {$starttime} and express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and head_get_time > {$starttime} and head_get_time < {$endtime} "; } } $list = M('lionfish_comshop_deliverylist')->where($condition)->order('clerk_id desc,head_id desc')->limit($offset, 10)->select(); if (empty($list)) { echo json_encode(array( 'code' => 1 )); die(); } if (!empty($list)) { $need_data = array(); $tuanz_info = array(); foreach ($list as $delivery_info) { $order_goods_list = array(); //line_name //$delivery_info['line_name'] = $line_info['name']; //$delivery_info['clerk_name'] = $deliveryclerk_info['name']; //$delivery_info['clerk_mobile'] = $deliveryclerk_info['mobile']; $tuanz_info = $delivery_info; //id $goods_list = M('lionfish_comshop_deliverylist_goods')->where(array( 'list_id' => $delivery_info['id'] ))->select(); if (!empty($goods_list)) { foreach ($goods_list as $val) { $tmp_gd = M('lionfish_comshop_goods')->field('index_sort')->where(array( 'id' => $val['goods_id'] ))->find(); $val['index_sort'] = $tmp_gd['index_sort']; $og_info = M('lionfish_comshop_order_goods')->where(array( 'goods_id' => $val['goods_id'], 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'] ))->order('order_goods_id desc ')->find(); if (!empty($og_info)) { $val['price'] = $og_info['price']; } else { $val['price'] = 0; } $val['total'] = sprintf('%.2f', $val['price'] * $val['goods_count']); if (isset($order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']])) { $old_val = $order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]; $old_val['total']+= $val['total']; $old_val['goods_count']+= $val['goods_count']; $order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $old_val; } else { $order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $val; } //goods_id } } //获取货到付款订单信息 begin $delivery_order_list = M('lionfish_comshop_deliverylist_order')->where( "list_id=".$delivery_info['id'] )->select(); $wait_pay_moeny_list = []; if( !empty($delivery_order_list) ) { foreach( $delivery_order_list as $delivery_order ) { $order_id = $delivery_order['order_id']; $order_info = M('lionfish_comshop_order')->where("order_id={$order_id}" )->find(); if( $order_info['payment_code'] == 'cashon_delivery' ) { //货到付款 $wait_pay_moeny = D('Home/OrderV2')->getOrderTotalMoney( $order_info ); $username = $order_info['shipping_name']; $mobile = $order_info['shipping_tel']; $wait_pay_moeny_list[] = [ 'order_id' => $order_id ,'username' => $username, 'moble' => $mobile , 'wait_pay_money' => $wait_pay_moeny ]; } } } //获取货到付款订单信息 end //对数组进行排序 $last_index_sort = array_column($order_goods_list, 'goods_name'); array_multisort($last_index_sort, SORT_ASC, $order_goods_list); $need_data[] = array( 'head_info' => $tuanz_info, 'wait_pay_moeny_list' => $wait_pay_moeny_list, 'order_goods_list' => $order_goods_list ); } } $this->clerk_name = $clerk_name; $this->need_data = $need_data; $this->shoname = D('Home/Front')->get_config_by_name('shoname'); $html = $this->fetch('Delivery/delivery_allprint_dofetch'); echo json_encode(array( 'code' => 0, 'html' => $html )); die(); } public function clerk_allprint() { $gpc = I('request.'); $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['start']) ? strtotime($gpc['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['end']) ? strtotime($gpc['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); $this->searchtime = $gpc['searchtime']; $this->starttime = $gpc['start']; $this->endtime = $gpc['end']; $count = M('lionfish_comshop_deliveryclerk')->count(); $this->count = $count; $this->shoname = D('Home/Front')->get_config_by_name('shoname'); $this->display(); } public function clerk_allprint_do() { @set_time_limit(0); $page = I('get.page', 1); $offset = ($page - 1); $clerk_info_list = M('lionfish_comshop_deliveryclerk')->order('id asc ')->limit($offset, 1)->select(); if (empty($clerk_info_list)) { echo json_encode(array( 'code' => 1 )); die(); } $condition = " state=0 "; $gpc = I('request.'); $searchtime = isset($gpc['searchtime']) ? $gpc['searchtime'] : ''; $starttime = isset($gpc['start']) ? strtotime($gpc['start']) : strtotime(date('Y-m-d' . ' 00:00:00')); $endtime = isset($gpc['end']) ? strtotime($gpc['end']) : strtotime(date('Y-m-d' . ' 23:59:59')); if (!empty($searchtime)) { if ($searchtime == 'create_time') { $condition.= " and create_time > {$starttime} and create_time < {$endtime} "; } if ($searchtime == 'express_time') { $condition.= " and express_time > {$starttime} and express_time < {$endtime} "; } if ($searchtime == 'head_get_time') { $condition.= " and head_get_time > {$starttime} and head_get_time < {$endtime} "; } } $need_data = array(); //分两步，1第一步将改配送员-》线路-》多个社区下的配送单都给生成了。 foreach ($clerk_info_list as $val) { $id = $val['id']; $deliveryclerk_info = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $id ))->find(); //查找对应线路 $line_info = M('lionfish_comshop_deliveryline')->where(array( 'clerk_id' => $id ))->find(); if (empty($line_info)) { continue; } //根据线路找团长 $head_lists = M('lionfish_comshop_deliveryline_headrelative')->where(array( 'line_id' => $line_info['id'] ))->select(); if (empty($head_lists)) { continue; } $order_goods_list = array(); //开始获取配送单信息了 foreach ($head_lists as $head_val) { $head_id = $head_val['head_id']; //$this->do_su_delivery_list($head_id); state name condition $new_condition = $condition . ' and head_id = ' . $head_id; $delivery_info_list = M('lionfish_comshop_deliverylist')->where($new_condition)->select(); if (!empty($delivery_info_list)) { $tuanz_info = array(); foreach ($delivery_info_list as $delivery_info) { if (empty($tuanz_info)) { //line_name $delivery_info['line_name'] = $line_info['name']; $delivery_info['clerk_name'] = $deliveryclerk_info['name']; $delivery_info['clerk_mobile'] = $deliveryclerk_info['mobile']; $tuanz_info = $delivery_info; } //id $goods_list = M('lionfish_comshop_deliverylist_goods')->where(array( 'list_id' => $delivery_info['id'] ))->select(); if (!empty($goods_list)) { foreach ($goods_list as $val) { $tmp_gd = M('lionfish_comshop_goods')->field('index_sort')->where(array( 'id' => $val['goods_id'] ))->find(); $val['index_sort'] = $tmp_gd['index_sort']; $og_info = M('lionfish_comshop_order_goods')->where(array( 'goods_id' => $val['goods_id'], 'rela_goodsoption_valueid' => $val['rela_goodsoption_valueid'] ))->find(); if (!empty($og_info)) { $val['price'] = $og_info['price']; } else { $val['price'] = 0; } $val['total'] = sprintf('%.2f', $val['price'] * $val['goods_count']); if (isset($order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']])) { $old_val = $order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']]; $old_val['total']+= $val['total']; $old_val['goods_count']+= $val['goods_count']; $order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $old_val; } else { $order_goods_list[$val['goods_id'] . '_' . $val['rela_goodsoption_valueid']] = $val; } //goods_id } } } } } if (!empty($order_goods_list)) { //对数组进行排序 $last_index_sort = array_column($order_goods_list, 'index_sort'); array_multisort($last_index_sort, SORT_DESC, $order_goods_list); $need_data[] = array( 'head_info' => $tuanz_info, 'order_goods_list' => $order_goods_list ); } /****/ } $this->need_data = $need_data; $this->shoname = D('Home/Front')->get_config_by_name('shoname'); $html = $this->fetch('Delivery/delivery_allprint_fetch'); echo json_encode(array( 'code' => 0, 'html' => $html )); die(); //$this->display(); } public function adddelivery_clerk() { $_GPC = I('request.'); $id = intval($_GPC['id']); if (!empty($id)) { $item = M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $id ))->find(); } if (IS_POST) { $data = $_GPC['data']; D('Seller/Delivery')->adddelivery_clerk($data); show_json(1, array( 'url' => U('Delivery/delivery_clerk') )); } $this->id = $id; $this->item = $item; $this->display(); } public function queryclerk() { $_GPC = I('request.'); $kwd = trim($_GPC['keyword']); $is_ajax = isset($_GPC['is_ajax']) ? intval($_GPC['is_ajax']) : 0; $condition = ' and line_id<= 0 '; if (!empty($kwd)) { $condition.= ' AND ( `name` LIKE "%' . $kwd . '%" or `mobile` LIKE "%' . $kwd . '%" )'; } $ds = M()->query('SELECT * FROM ' . C('DB_PREFIX') . 'lionfish_comshop_deliveryclerk WHERE 1 ' . $condition . ' order by id asc'); foreach ($ds as & $value) { $value['nickname'] = htmlspecialchars($value['name'], ENT_QUOTES); $value['avatar'] = tomedia($value['logo']); if ($is_ajax == 1) { $ret_html.= ''; $ret_html.= ' ' . $value['nickname'] . ''; $ret_html.= ' ' . $value['mobile'] . ''; $ret_html.= ' 选择'; $ret_html.= ''; } } unset($value); if ($is_ajax == 1) { echo json_encode(array( 'code' => 0, 'html' => $ret_html )); die(); } $this->ds = $ds; $this->display(); } public function adddeliverylist() { $_GPC = I('request.'); $id = intval($_GPC['id']); if (!empty($id)) { $item = M('lionfish_comshop_deliveryline')->where(array( 'id' => $id ))->find(); //clerk_id $saler = M('lionfish_comshop_deliveryclerk')->field('id,name as nickname, logo as avatar')->where(array( 'id' => $item['clerk_id'] ))->find(); $headlist = array(); $head_relative = M('lionfish_comshop_deliveryline_headrelative')->where(array( 'line_id' => $item['id'] ))->order('id asc')->select(); if (!empty($head_relative)) { $head_id_arr = array(); foreach ($head_relative as $vv) { $head_id_arr[] = $vv['head_id']; } $headlist = M('lionfish_community_head')->field('id,community_name')->where(array( 'id' => array( 'in', $head_id_arr ) ))->select(); } $this->item = $item; $this->saler = $saler; $this->headlist = $headlist; } if (IS_POST) { $data = $_GPC['data']; $clerk_id = $_GPC['clerk_id']; $head_id = $_GPC['head_id']; if(empty($clerk_id)){ show_json(0, array('message' => '司机不能为空！','url' => $_SERVER['HTTP_REFERER'])); } $data['clerk_id'] = $clerk_id; $data['head_id'] = $head_id; D('Seller/Delivery')->adddeliverylist($data); show_json(1, array( 'url' => $_SERVER['HTTP_REFERER'] )); } $this->display(); } public function deldelivery_clerk() { $_GPC = I('request.'); $id = intval($_GPC['id']); if (empty($id)) { $id = (is_array($_GPC['ids']) ? implode(',', $_GPC['ids']) : 0); } $items = M('lionfish_comshop_deliveryclerk')->where("id in ({$id}) ")->select(); if (empty($item)) { $item = array(); } foreach ($items as $item) { M('lionfish_comshop_deliveryclerk')->where(array( 'id' => $item['id'] ))->delete(); } show_json(1, array( 'url' => $_SERVER['HTTP_REFERER'] )); } } ?>