seafood/app/Http/Controllers/Admin/FxOrderContr...

<?php
/**
 * Created by Sublime.
 * User: hao
 * Date: 19/08/30
 * Time: 上午11:20
 */
namespace App\Http\Controllers\Admin;

use App\Http\Controllers\Controller;
use App\Log;
use App\Order;
use App\FxOrder;
use App\Oplog;
use App\RedisModel;
use App\Goods;
use App\GoodsSkus;
use App\FxOrderGoodsSkus;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

use PHPExcel_Reader_Excel2007;
use PHPExcel_Reader_Excel5;
use PHPExcel;
use PHPExcel_Writer_Excel2007;
use YPSMS;

class FxOrderController extends Controller
{
	public function orderindex(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;

        $self_role = session('role_name');
        if($self_role == '超级管理员' || $self_role == '团队主管' || $self_role == '管理员' || $self_role == '售后管理员' || $self_role == '分销管理员'){
            $admin_id = $request->input('admin_id');
            $search_admin = 1;
        }else{
            $admin_id = session('admin_id');
            $search_admin = 0;
        }

        $team_id = $request->input('team_id');
        #只能看自己团队的
        if($self_role != '超级管理员' && $self_role != '售后管理员'){
            $self_id = session('admin_id');
            $team_id = DB::table('admin')->where('id', $self_id)->pluck('team_id');        
        }

        //假如有团队筛选，检索销售队员
        $sale_ids = null;
        if($team_id>0){
            $sale_ids = DB::table('admin')->where('team_id', $team_id)->lists('id');
        }
        
        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = trim($request->input('receiverName'));
        $receiverMobile = trim($request->input('receiverMobile'));
        $status = $request->input('status');
        $id = (int)$request->input('id');
        $warehouse = (int)$request->input('warehouse');
        if($status === null){
            $status = -1;
        }
        if($etime){
            $etime = $etime. ' 23:59:59';
        }

        $count = FxOrder::where(function($query) use($admin_id, $stime, $etime, $receiverName, $receiverMobile, $self_role, $sale_ids, $status, $id, $warehouse){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($self_role == '管理员' || $self_role == '分销管理员') $query->where('status','>',0);
            if(!empty($sale_ids)) $query->whereIn('admin_id', $sale_ids);
            if(($status>=0)) $query->where('status', $status);
            if(($id>0)) $query->where('id', $id);
            if(($warehouse>0)) $query->where('warehouse', $warehouse);
        })->where('is_del',0)->count();
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = FxOrder::where(function($query) use($admin_id, $stime, $etime, $receiverName, $receiverMobile, $self_role, $sale_ids, $status, $id, $warehouse){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($self_role == '管理员' || $self_role == '分销管理员') $query->where('status','>',0);
            if(!empty($sale_ids)) $query->whereIn('admin_id', $sale_ids);
            if(($status>=0)) $query->where('status', $status);
            if(($id>0)) $query->where('id', $id);
            if(($warehouse>0)) $query->where('warehouse', $warehouse);
        })->where('is_del',0)->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);
        
        $status_arr = array(
            0 => '已录入',
            1 => '待审核',
            2 => '已审核',
            3 => '已发货',
            4 => '已退款'
        );

        foreach($result as $k=>&$v){
            
            //获取商品信息
            $v['goods'] = '';
            $goods = DB::table('fx_order_goods_skus')->where('order_id', $v['id'])->where('is_del', 0)->get();
            if(!empty($goods)){
                foreach($goods as $item){
                    $goods_name = Goods::where('id', $item->goods_id)->pluck('name');
                    $goods_sku_info = GoodsSkus::select('propsName', 'is_weigh')->where('id', $item->sku_id)->first();
                    if(!empty($goods_sku_info)){
                        $props_name = $goods_sku_info->propsName;
                        $is_weigh = $goods_sku_info->is_weigh;
                        $weigh_note = $is_weigh==1 ? '重量(斤)':'数量';
                    }else{
                        $props_name = '';
                        $weigh_note = '数量';
                    }
                    
                    $v['goods'][] = $goods_name.'('.$props_name.')&nbsp; '.$weigh_note.':'.$item->num.'';
                }
            }
            
            #加粉时间
            $fanTime = DB::table('fx_customers')->select('fanTime')->where('phone', $v['receiverMobile'])->first();
            $v['fanTime'] = isset($fanTime->fanTime) ? $fanTime->fanTime : '';
            $v['receiverMobile'] = substr($v['receiverMobile'], 0, 3).'****'.substr($v['receiverMobile'], 7);

            #获取状态机
            if( ($self_role == '销售' || $self_role == '分销销售') && !in_array($v['status'], [0]) ){
                $v['enable_status'] = [];
            }else{
                $v['enable_status'] = $this->getEnableStatus($v['status']);
            }

            $v['status_name'] = $status_arr[$v['status']];    
            if($v['refund_type'] == 1){
                $v['refund_type'] = '微信支付';
            }elseif($v['refund_type'] == 2){
                $v['refund_type'] = '付款码支付';
            }elseif($v['refund_type'] == 3){
                $v['refund_type'] = '个体户支付';
            }else{
                $v['refund_type'] = '';
            }  

            if($v['payment_type'] == 1){
                $v['payment_type'] = '微信支付';
            }elseif($v['payment_type'] == 2){
                $v['payment_type'] = '付款码支付';
            }elseif($v['payment_type'] == 3){
                $v['payment_type'] = '个体户支付';
            }elseif($v['payment_type'] == 4){
                $v['payment_type'] = '充值卡支付';
            }else{
                $v['payment_type'] = '';
            }  
        }

        $yestoday = date('Y-m-d', strtotime('-1 day'));
        //获取超时未发订单
        $order_overtime = FxOrder::where('is_del',0)->whereIn('status', [2,3])->where('delivery_date', '<', $yestoday)->where('logistics_id', '=', '')->where(function($query) use($team_id, $self_role){
            if($self_role == '分销管理员') $query->where('team_id', $team_id);
        })->lists('id');
       
        $overtime = [];
        if(!empty($order_overtime)){
            $overtime['list'] = json_decode(json_encode($order_overtime), true);
            $overtime['count'] = count($order_overtime);           
        }
      
        #销售筛选
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where(function($query) use($team_id){
            if($team_id>0) $query->where('team_id', $team_id);
        })->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);
        return view('fxorder/orderlist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,
            'admin_id'          =>$admin_id,
            'team_id'           =>$team_id,
            'stime'             =>$stime,
            'etime'             =>$etime,
            'adminlist'         =>$adminList,
            'search_admin'      =>$search_admin,
            'self_role'         =>$self_role,
            'receiverName'         =>$receiverName,
            'receiverMobile'       =>$receiverMobile,
            'status'            =>$status,
            'id'            =>$id,
            'last_url'      => 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'],
            'overtime'      => $overtime,
            'warehouse'      => $warehouse,
            'thisTime'      => date('Y-m-d H:i:s'),
            ]);
    }

    /**
     * 仓库管理员订单列表
     */
    public function warehouse(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;
        $admin_id = $request->input('admin_id');
        $search_admin = 1;

        $self_role = session('role_name');
        if($self_role == 'A仓库管理员'){
            $warehouse = 1;
        }elseif($self_role == 'B仓库管理员'){
            $warehouse = 2;
        }elseif($self_role == 'C仓管理员'){
            $warehouse = 3;
        }else{
            $warehouse = 0;
        }
        
        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $delivery_type = (int)$request->input('delivery_type'); //发货状态 0到发货时间（未填物流信息） 2到发货时间全部 
        $receiverName = trim($request->input('receiverName'));
        $receiverMobile = trim($request->input('receiverMobile'));
        $id = (int)$request->input('id');

        //仓库管理员只能看到 918之后的数据
        $_start = '2019-09-18';
        //仓库管理员只能看到已审核订单  
        $today_date = date('Y-m-d');
        $count = FxOrder::where(function($query) use($admin_id, $stime, $etime, $today_date, $delivery_type, $receiverName, $receiverMobile, $_start, $id){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($delivery_type==0) $query->where('logistics_id', '=', '');
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($id>0) $query->where('id', $id);
            $query->where('createTime', '>=', $_start);
        })->where('is_del',0)->where('warehouse', $warehouse)->where('status', '>', 1)->where('delivery_date', '<=', $today_date)->count();

        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = FxOrder::where(function($query) use($admin_id, $stime, $etime, $today_date, $delivery_type, $receiverName, $receiverMobile, $_start, $id){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);            
            if($delivery_type==0) $query->where('logistics_id', '=', '');
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            $query->where('createTime', '>=', $_start);
            if($id>0) $query->where('id', $id);
        })->where('is_del',0)->where('warehouse', $warehouse)->where('status', '>', 1)->where('delivery_date', '<=', $today_date)->orderBy('verify_time', 'asc')->offset($offset)->limit($pageSize)->get();

        $result = json_decode(json_encode($result),true);

        $status_arr = array(
            0 => '已录入',
            1 => '待审核',
            2 => '已审核',
            3 => '已发货',
            4 => '已退款',
        );
        foreach($result as $k=>&$v){
            
            //获取商品信息
            $v['goods'] = '';
            $goods = DB::table('fx_order_goods_skus')->where('order_id', $v['id'])->where('is_del', 0)->get();
            if(!empty($goods)){
                foreach($goods as $item){
                    $goods_name = Goods::where('id', $item->goods_id)->pluck('name');
                    $props_name = GoodsSkus::where('id', $item->sku_id)->pluck('propsName');
                    $v['goods'][] = $goods_name.'('.$props_name.')&nbsp; 数量/重量:'.$item->num.'';
                }
            }

            $v['status_name'] = $status_arr[$v['status']];            
        }

        $yestoday = date('Y-m-d', strtotime('-1 day'));
        //获取超时未发订单
        $order_overtime = FxOrder::where('is_del',0)->where('warehouse', $warehouse)->where('status', '>', 1)->where('delivery_date', '<', $yestoday)->where('createTime', '>=', $_start)->where('logistics_id', '=', '')->lists('id');
       
        $overtime = [];
        if(!empty($order_overtime)){
            $overtime['list'] = json_decode(json_encode($order_overtime), true);
            $overtime['count'] = count($order_overtime);           
        }
                
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);
        return view('fxorder/warehouselist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,
            'admin_id'          =>$admin_id,
            'stime'             =>$stime,
            'etime'             =>$etime,
            'delivery_type'     =>$delivery_type,
            'adminlist'         =>$adminList,
            'receiverName'         =>$receiverName,
            'receiverMobile'       =>$receiverMobile,
            'id'       =>$id,
            'today'    =>$today_date,
            'yestoday'    => $yestoday,
            'overtime'    => $overtime,
            ]);
    }

    /**
     * 预售订单列表
     */
    public function predictOrder(Request $request){
        $page = (int)$request->input('page');
        $pageSize = 20;
        if($page<=0){
            $page = 1;
        }

        $offset = ($page-1) * $pageSize;
        $self_role = session('role_name');
        if($self_role == '超级管理员' || $self_role == '团队主管' || $self_role == '管理员' || $self_role == '售后管理员'){
            $admin_id = $request->input('admin_id');
            $search_admin = 1;
        }else{
            $admin_id = session('admin_id');
            $search_admin = 0;
        }

        $team_id = $request->input('team_id');
        #只能看自己团队的
        if($self_role != '超级管理员' &&  $self_role != '售后管理员'){
            $self_id = session('admin_id');
            $team_id = DB::table('admin')->where('id', $self_id)->pluck('team_id');        
        }

        //假如有团队筛选，检索销售队员
        $sale_ids = null;
        if($team_id>0){
            $sale_ids = DB::table('admin')->where('team_id', $team_id)->lists('id');
        }
        
        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = trim($request->input('receiverName'));
        $receiverMobile = trim($request->input('receiverMobile'));
        $status = $request->input('status');
        $if_all = (int)$request->input('if_all');
        if($status === null){
            $status = -1;
        }

        //预售逻辑 -> 预发货时间大于下单时间
        $today = date('Y-m-d');
        //DB::connection()->enableQueryLog();
        $count = FxOrder::where(function($query) use($admin_id, $stime, $etime, $receiverName, $receiverMobile, $self_role, $sale_ids, $status, $if_all, $today){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($self_role == '管理员') $query->where('status','>',0);
            if(!empty($sale_ids)) $query->whereIn('admin_id', $sale_ids);
            if(($status>=0)) $query->where('status', $status);
            if(!$if_all) $query->where('delivery_date','>=',$today);
        })->where('is_del',0)->whereRaw('delivery_date>createTime')->count();
        //print_r(DB::getQueryLog());exit;
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = FxOrder::where(function($query) use($admin_id, $stime, $etime, $receiverName, $receiverMobile, $self_role, $sale_ids, $status, $if_all, $today){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($self_role == '管理员') $query->where('status','>',0);
            if(!empty($sale_ids)) $query->whereIn('admin_id', $sale_ids);
            if(($status>=0)) $query->where('status', $status);
            if(!$if_all) $query->where('delivery_date','>=',$today);
        })->where('is_del',0)->whereRaw('delivery_date>createTime')->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);
        
        $status_arr = array(
            0 => '已录入',
            1 => '待审核',
            2 => '已审核',
            3 => '已发货',
            4 => '已退款'
        );
        foreach($result as $k=>&$v){
            //获取商品信息
            $v['goods'] = '';
            $goods = DB::table('fx_order_goods_skus')->where('order_id', $v['id'])->where('is_del', 0)->get();
            if(!empty($goods)){
                foreach($goods as $item){
                    $goods_name = Goods::where('id', $item->goods_id)->pluck('name');
                    $props_name = GoodsSkus::where('id', $item->sku_id)->pluck('propsName');
                    $v['goods'][] = $goods_name.'('.$props_name.')&nbsp;  数量/重量:'.$item->num.'';
                }
            }
            #加粉时间
            $fanTime = DB::table('fx_customers')->select('fanTime')->where('phone', $v['receiverMobile'])->first();
            $v['fanTime'] = isset($fanTime->fanTime) ? $fanTime->fanTime : '';
            $v['receiverMobile'] = substr($v['receiverMobile'], 0, 3).'****'.substr($v['receiverMobile'], 7);

            #获取状态机
            if( ($self_role == '销售' || $self_role == '分销销售') && !in_array($v['status'], [0]) ){
                $v['enable_status'] = [];
            }else{
                $v['enable_status'] = $this->getEnableStatus($v['status']);
            }

            $v['status_name'] = $status_arr[$v['status']];            
        }
        
        #销售筛选
        //$saler_ids = DB::table('admin_role')->where('role_name', '销售')->lists('user_id');
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where(function($query) use($team_id){
            if($team_id>0) $query->where('team_id', $team_id);
        })->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);
        return view('fxorder/predictorderlist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,
            'admin_id'          =>$admin_id,
            'team_id'           =>$team_id,
            'stime'             =>$stime,
            'etime'             =>$etime,
            'adminlist'         =>$adminList,
            'search_admin'      =>$search_admin,
            'self_role'         =>$self_role,
            'receiverName'         =>$receiverName,
            'receiverMobile'       =>$receiverMobile,
            'status'            =>$status,
            'if_all'            =>$if_all,
            'last_url'      => 'http://'.$_SERVER['HTTP_HOST'].$_SERVER['REQUEST_URI'],
            ]);
    }

    /**
     * 添加订单
     * @return \Illuminate\View\View
     */
    public function ordercreate(Request $request)
    {
        $catelist =  DB::table('goods_category')->select(DB::raw('distinct goods_category_name'))->lists('goods_category_name');
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $teamList = DB::table('teams')->select('id', 'name')->where('type', 1)->get();
        $teamList = json_decode(json_encode($teamList), true);
        $adminList = json_decode(json_encode($adminList), true);
        $self_role = session('role_name');
        $createTime = date('Y-m-d H:i:s');

        return view('fxorder/ordercreate', ['categorylist' => $catelist, 'adminlist'=>$adminList, 'teamlist'=>$teamList, 'self_role'=>$self_role, 'createTime'=>$createTime, 'last_url' => $_SERVER['HTTP_REFERER']]);
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderstore(Request $request)
    {       
        $this->validate($request, [
            'customerName'           => 'required|between:1,6', 
            'receiverName'           => 'required|between:1,6', 
            'receiverMobile'           => 'required|regex:/^1[3456789]\d{9}$/',  
            'fanTime'           => 'required|date', 
            'receiverState'           => 'required|between:1,5', 
            'receiverCity'           => 'required|between:1,10', 
            'receiverAddress'           => 'required', 
            'delivery_date'           => 'required|date', 
            //'createTime'           => 'required|date', 
            'receivedAmount'           => 'required|numeric|min:1', 
            //'goods_note'           => 'required|min:1',  
            'warehouse'           => 'required|integer|min:1',  
            //'skus'                => 'required'
        ], [                  
            'customerName.required'           => '买家姓名不能为空',                   
            'customerName.between'           => '买家姓名不能超过6个字符',                   
            'receiverName.required'           => '收货人不能为空', 
            'receiverName.between'           => '收货人不能超过6个字符',                  
            'receiverMobile.required'           => '收货人手机号不能为空',                   
            'receiverMobile.regex'           => '收货人手机号格式有误',                   
            'fanTime.required'           => '加粉时间不能为空',              
            'receiverState.required'           => '省不能为空',   
            'receiverState.between'           => '省填写有误',   
            'receiverCity.required'           => '市不能为空',   
            'receiverCity.between'           => '市填写有误',   
            'receiverAddress.required'           => '详细地址不能为空',             
            'delivery_date.required'           => '预发货时间不能为空',   
            //'createTime.required'           => '下单时间不能为空',   
            'receivedAmount.required'           => '付款金额不能为空',                   
            'receivedAmount.numeric'           => '付款金额必须为数字',                   
            'goods_note.required'           => '商品信息不能为空',                   
            'warehouse.required'           => '仓库必须选择',                   
            'warehouse.min'           => '仓库必须选择',                   
        ]);

        //redis防重复数据
        $phone = $request->input('receiverMobile');
        
        $redisKey = 'seafood.fxorder_phone_add.'.$phone;
        $res = RedisModel::setnx($redisKey, 1);
        if( $res == 0 ){
            $msg = '操作过于频繁，请一分钟后继续操作';
            return redirect('/admin/fxorder/index')->with('info', $msg);
        }
        $res = RedisModel::expire( $redisKey, 60 );
        
        $skus = $request->input('skus');
        $warehouse = (int)$request->input('warehouse');
        if($warehouse == 3 && empty($skus)){
            $msg = 'C仓必须添加卖家云商品';
            return redirect('/admin/fxorder/index')->with('info', $msg);
        }
    
        //数据库-新增数据
        $order = array();
        $order['eshopCode'] = config('constants.ESHOP_CODE'); //默认
        $order['outerCode'] = FxOrder::createOuterCode();//随机生成
        $order['status'] = (int)$request->input('status');                                   
        $order['customerName'] = trim($request->input('customerName')); //买家名称
        $order['shippingType'] = '卖家包邮';
        $order['expressCompanyCode'] = '10084';
        $order['expressCompanyName'] = '顺丰快递';
        $order['receiverName'] = trim($request->input('receiverName')); //收件人
        $order['receiverMobile'] = trim($request->input('receiverMobile')); //收件人手机
        $order['receiverPhone'] = trim($request->input('receiverMobile')); //收件人手机
        $order['receiverState'] = trim($request->input('receiverState')); //省份
        $order['receiverCity'] = trim($request->input('receiverCity')); //市
        #省市格式处理
        $order['receiverState'] = str_replace(['省', '市'], '', $order['receiverState']);
        $order['receiverCity'] = str_replace('市', '', $order['receiverCity']);

        $order['receiverDistrict'] = trim($request->input('receiverDistrict')); //区
        $order['receiverStreet'] = trim($request->input('receiverStreet')); //街道
        $order['receiverAddress'] = trim($request->input('receiverAddress')); //详细地址
        $order['buyerPostageFee'] = 0; //买家邮费
        $order['discountFee'] = 0; //订单优惠
        $order['adjustFee'] = 0; //订单调价
        $order['serviceFee'] = 0; //服务费
        $order['paymentMethod'] = '在线付款';
        $order['paymentType'] = '网银';
        $order['paymentAccount'] = '18322225555'; // 付款账号，暂时默认写死
        $order['paymentTime'] = date('Y-m-d H:i:s'); // 付款时间
        $order['receivedAmount'] = trim($request->input('receivedAmount')); //付款金额        
        $order['buyerMemo'] = trim($request->input('buyerMemo', '')); // 买家备注
        $order['sellerMemo'] = trim($request->input('sellerMemo', '')); // 卖家备注
        $order['createTime'] = date('Y-m-d H:i:s'); // 订单创建时间
        $order['modifyTime'] = date('Y-m-d H:i:s'); // 订单修改时间
        $order['should_amount'] = $request->input('should_amount');
        if(!$order['should_amount']) $order['should_amount'] = null;

        //商品信息
        $skus = $request->input('skus');
        $gnum = $request->input('gnum');
        if(!empty($skus)){
            foreach($skus as $k=>$sku_id){
                $sku_info = GoodsSkus::where('id', $sku_id)->first();
                $goods_info = Goods::where('id', $sku_info->goodsCode)->first();
                $params = array();
                $params['outerCode'] = $order['outerCode']+$k+1; //外部平台中子订单编码
                $params['outerParentCode'] = $order['outerCode']; //外部平台中订单编码
                $params['goodsCode'] = $sku_info->goodsCode;// strstr($goods->code,'-',true); 
                $params['skuCode'] = $sku_id; 
                #商品名称
                $params['goodsName'] = $goods_info->name;
                $params['propertiesName'] = $sku_info->propsName;
                //$params['goodsName'] = '海钓黄翅鱼';//$goods->code; 
                $params['price'] = $sku_info->price;
                
                $params['quantity'] = $gnum[$k];
                $params['discountFee'] = 0;
                $params['adjustFee'] = 0;
                $params['refundStatus'] = '正常';
                $order['skuList'][] = $params;
            }
        }

        //卖家云添加订单 ->改为审核通过再同步卖家云
        //$mj_add = Order::mjOrderAdd($order);

        //本系统订单额外参数
        $order['goods_note'] = trim($request->input('goods_note'));
        if($request->input('cost')) $order['cost'] = trim($request->input('cost'));  //成本
        $order['logistics_id'] = trim($request->input('logistics_id')); //物流单号
        $order['is_refund'] = (int)$request->input('is_refund'); //是否退过单
        if($request->input('refund_price')) $order['refund_price'] = trim($request->input('refund_price')); //应该退补差价
        //$order['is_fugou'] = (int)$request->input('is_fugou'); //是否复购
        $order['warehouse'] = (int)$request->input('warehouse'); //仓库
        $order['delivery_date'] = !empty($request->input('delivery_date')) ? $request->input('delivery_date') : date('Y-m-d'); //发货日期
        $order['order_status'] = (int)$request->input('order_status');
        $order['payment_type'] = (int)$request->input('payment_type'); //支付方式
       
        //充值卡验证余额
        if($order['payment_type'] == 4){
            $deposit_phone = $order['receiverMobile'];//$request->input('deposit_phone'); //暂且只能使用自己充值卡
            $customerInfo = CustomerInfo::where('phone', $deposit_phone)->first();
            $balance = isset($customerInfo->balance) ? $customerInfo->balance : 0;
            if($balance < $order['receivedAmount']){
                //余额不足
                return redirect('/admin/fxorder/index')->with('info', '充值卡余额不足');
            }
        }
        DB::beginTransaction();
        try{      

            #更新客户表
            $customer = array();
            $customers['name'] = $order['receiverName'];
            $customers['receiverState'] = $order['receiverState'];
            $customers['receiverCity'] = $order['receiverCity'];
            $customers['receiverDistrict'] = $order['receiverDistrict'];
            $customers['receiverStreet'] = $order['receiverStreet'];
            $customers['receiverAddress'] = $order['receiverAddress'];

            $if_e = DB::table('fx_customers')->select('id')->where('phone', $order['receiverMobile'])->first();
            if(isset($if_e->id)){               
                $customers['is_fugou'] = 1;
                $order['is_fugou'] = 1;
                $up_c = DB::table('fx_customers')->where('id', $if_e->id)->update($customers);
            }else{
                $customers['phone'] = $order['receiverMobile'];                
                $customers['is_fugou'] = 0;
                $customers['fanTime'] = $request->input('fanTime');
                $customers['admin_id'] = session('admin_id');
                $in_c = DB::table('fx_customers')->insert($customers);
            }

            if(!empty($skus)){
                $order_goods = $order['skuList'];
                unset($order['skuList']);
            }
           
            //$order['orderCode'] = $mj_add['order']['code']; 
            $admin_id = (int)$request->input('admin_id');   
            if($admin_id>0){
                $admin_info = DB::table('admin')->select('realname', 'team_id')->where('id', $admin_id)->first();
                $order['admin_id'] = $admin_id;
                $order['admin_name'] = $admin_info->realname;
                $order['team_id'] = $admin_info->team_id;
            }else{
                $order['admin_id'] = session('admin_id');
                $order['admin_name'] = session('real_name');
                $order['team_id'] = session('team_id');
            }
            //新加is_able 9.4之前粉丝不参与销售复购统计
            $fanTime = $request->input('fanTime');
            if($fanTime < '2019-09-04'){
                $order['is_able'] = 0;
            }
            $res = DB::table('fx_order')->insertGetId($order);
            if($res){
                if(!empty($skus)){
                    //订单商品插入
                    $order_skus = array();
                    foreach($order_goods as $k=>$sku){
                        $order_skus[$k]['sku_id'] = $sku['skuCode'];
                        $order_skus[$k]['order_id'] = $res;
                        $order_skus[$k]['goods_id'] = $sku['goodsCode'];
                        $order_skus[$k]['num'] = $sku['quantity'];
                        $order_skus[$k]['price'] = $sku['price'];
                    }
                    $order_skus_insert = DB::table('fx_order_goods_skus')->insert($order_skus);
                }

                #新加逻辑，若付款方式为充值卡/消费记录
                if($order['payment_type'] == 4){
                    $consum = new CustomerConsum();
                    $consum->phone = $deposit_phone;
                    $consum->order_id = $res;
                    $consum->money = $order['receivedAmount'];
                    $consum->save();
                    //更新余额                   
                    $customerInfo->balance = $customerInfo->balance - $order['receivedAmount'];
                    $customerInfo->save();
                }
                #记录操作日志
                $self_id = session('admin_id');
                $self_name = session('real_name');
                if($order['status'] == 0){
                    $status_text = '仅录入';
                }else{
                    $status_text = '录入并提审';
                }
                $context = "录入订单：".$status_text;
                $type = 0; //订单录入
                $tables = 'fx_order';
                $data_id = $res;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);

                #如果提交审核，发短信
                //if( $order['status'] == 1 ) $this->sendRemind($self_id, $res, 1);
            }
            
            DB::commit();
        }catch (Exception $e){
            DB::rollback();
        }   

        return redirect('/admin/fxorder/index')->with('info', '添加成功'); 
        
    }

    /**
     * 分组管理-编辑分组界面
     * @param $id
     * @return \Illuminate\View\View
     */
    public function orderedit($id,Request $request)
    {
        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = $request->input('receiverName');
        $receiverMobile = $request->input('receiverMobile');
        $admin_id = (int)$request->input('admin_id');
        $page = (int)$request->input('page');
        $last_url = $request->input('last_url');

        $self_role = session('role_name');
        //$catelist =  DB::table('goods_category')->select(DB::raw('distinct goods_category_name'))->lists('goods_category_name');
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $teamList = DB::table('teams')->select('id', 'name')->where('type', 1)->get();
        $teamList = json_decode(json_encode($teamList), true);
        $adminList = json_decode(json_encode($adminList), true);
        $order = FxOrder::findOrFail($id);
        $order = json_decode(json_encode($order), true);
        // 临时处理，只能用自己充值卡
        $order['deposit_phone'] = $order['receiverMobile'];
        $order['receiverMobile'] = substr($order['receiverMobile'], 0, 3).'****'.substr($order['receiverMobile'], 7);
        $order['goods'] = '';
        $order_skus = DB::table('fx_order_goods_skus')->where('is_del', 0)->where('order_id', $id)->lists('num','sku_id');

        $skus = array_keys($order_skus);
        if(!empty($skus)){
            $goods = Goods::select('gs.id as sku_id', 'goods.id as goods_id', 'goods.name', 'gs.propsName as props_name', 'gs.price', 'gs.is_weigh', 'gs.is_white', 'gs.quantity')->leftJoin('goods_skus as gs', 'gs.goodsCode', '=', 'goods.id')->whereIn('gs.id', $skus)->orderBy('goods.id', 'desc')->get();
            $goods = json_decode(json_encode($goods),true);
            foreach($goods as $k=>&$v){
                $v['num'] = $order_skus[$v['sku_id']];
                //计算实际库存 -还未到卖家云的量
                $v['quantity'] = GoodsSkus::actualQuantity($v['sku_id']);
                $v['quantity'] = $v['quantity'] + $v['num'];
                $v['quantity_str'] = $v['quantity'];
                if($v['is_white'] == 1){
                    $v['quantity_str'] = '虚拟库存';
                }
            }
            $order['goods'] = $goods;
        }

        $deposit_phone = '';
        if($order['payment_type'] == 4){
            $consum = CustomerConsum::select('phone')->where('order_id', $id)->first();
            $deposit_phone = isset($consum->phone) ? $consum->phone : '';
        }
        return view('fxorder/orderedit', [       
            'order' => $order,
            //'categorylist' => $catelist,
            'adminlist'=>$adminList,
            'teamlist'=>$teamList,
            'self_role'=>$self_role,
            'str_query'=> 'page='.$page.'&admin_id='.$admin_id.'&stime='.$stime.'&etime='.$etime.'&receiverName='.$receiverName.'&receiverMobile='.$receiverMobile,
            'last_url' => $last_url,
            'deposit_phone' => $deposit_phone,
        ]);

    }

    /**
     * 分组管理-进行编辑操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderupdate(Request $request)
    {    
        $this->validate($request, [
            'id'           => 'required',
            'customerName'           => 'required|between:1,6', 
            'receiverName'           => 'required|between:1,6', 
            'receiverMobile'           => 'required|regex:/^1[3456789][\d\*]{9}$/',   
            'receiverState'           => 'required|between:1,5', 
            'receiverCity'           => 'required|between:1,10', 
            'receiverAddress'           => 'required', 
            'delivery_date'           => 'required|date', 
            //'createTime'           => 'required|date', 
            'receivedAmount'           => 'required|numeric|min:1', 
            //'goods_note'           => 'required|min:1',  
            'warehouse'           => 'required|integer|min:1',    
        ], [                  
            'customerName.required'           => '买家姓名不能为空',                   
            'customerName.between'           => '买家姓名不能超过6个字符',                   
            'receiverName.required'           => '收货人不能为空', 
            'receiverName.between'           => '收货人不能超过6个字符',                  
            'receiverMobile.required'           => '收货人手机号不能为空',                   
            'receiverMobile.regex'           => '收货人手机号格式有误',                                 
            'receiverState.required'           => '省不能为空',   
            'receiverState.between'           => '省填写有误',   
            'receiverCity.required'           => '市不能为空',   
            'receiverCity.between'           => '市填写有误',   
            'receiverAddress.required'           => '详细地址不能为空',             
            'delivery_date.required'           => '预发货时间不能为空',   
            //'createTime.required'           => '下单时间不能为空',   
            'receivedAmount.required'           => '付款金额不能为空',                   
            'receivedAmount.numeric'           => '付款金额必须为数字',                   
            'goods_note.required'           => '商品信息不能为空',                   
            'warehouse.required'           => '仓库必须选择',                   
            'warehouse.min'           => '仓库必须选择',                   
        ]);

        $str_query = trim($request->input('str_query'));
        $last_url = trim($request->input('last_url'));
       
        $phone = trim($request->input('receiverMobile'));
        //更新数据
        $order = array();
        $order['customerName'] = trim($request->input('customerName')); //买家名称
        $order['receiverName'] = trim($request->input('receiverName')); //收件人
        if(preg_match('/^1\d{10}$/', $phone)) $order['receiverMobile'] = $phone; //收件人手机
        $order['receiverState'] = trim($request->input('receiverState')); //省份
        $order['receiverCity'] = trim($request->input('receiverCity')); //市
        
        $order['receiverState'] = str_replace(['省', '市'], '', $order['receiverState']);
        $order['receiverCity'] = str_replace('市', '', $order['receiverCity']);

        //$order['receiverDistrict'] = trim($request->input('receiverDistrict')); //区
        //$order['receiverStreet'] = trim($request->input('receiverStreet')); //街道
        $order['receiverAddress'] = trim($request->input('receiverAddress')); //详细地址
        $order['receivedAmount'] = trim($request->input('receivedAmount')); //付款金额        
        $order['buyerMemo'] = trim($request->input('buyerMemo', '')); // 买家备注
        $order['sellerMemo'] = trim($request->input('sellerMemo', '')); // 卖家备注
        $order['goods_note'] = trim($request->input('goods_note'));
        if($request->input('cost')) $order['cost'] = trim($request->input('cost'));  //成本
        $order['logistics_id'] = trim($request->input('logistics_id')); //物流单号
        $order['is_refund'] = (int)$request->input('is_refund'); //是否退过单
        if($request->input('refund_price')) $order['refund_price'] = trim($request->input('refund_price')); //应该退补差价
        //$order['is_fugou'] = (int)$request->input('is_fugou'); //是否复购
        $order['warehouse'] = (int)$request->input('warehouse'); //仓库
        $order['delivery_date'] = !empty($request->input('delivery_date')) ? $request->input('delivery_date') : date('Y-m-d'); //发货日期
        //if(!empty($request->input('createTime'))) $order['createTime'] = $request->input('createTime'); // 订单创建时间
        $order['order_status'] = (int)$request->input('order_status');
        $order['payment_type'] = (int)$request->input('payment_type'); //支付方式

        //$order['status'] = (int)$request->input('status');
        $order['should_amount'] = $request->input('should_amount');
        if(!$order['should_amount']) $order['should_amount'] = null;

        $admin_id = (int)$request->input('admin_id');
        if($admin_id>0){
            $admin_info = DB::table('admin')->select('realname', 'team_id')->where('id', $admin_id)->first();
            $order['admin_id'] = $admin_id;
            $order['admin_name'] = $admin_info->realname;
            $order['team_id'] = $admin_info->team_id;
        }

        $id = (int)$request->input('id');
        //获取订单原信息
        $old_order = DB::table('fx_order')->where('id', $id)->first();

        // ++++++充值卡验证余额逻辑 +++++++ //
        if($order['payment_type'] == 4){
            $deposit_phone = $request->input('deposit_phone');
            if($old_order->payment_type != 4){                            
                $customerInfo = CustomerInfo::where('phone', $deposit_phone)->first();
                $balance = $customerInfo->balance;
                if($balance < $order['receivedAmount']){
                    //余额不足
                    return redirect('/admin/fxorder/index')->with('info', '充值卡余额不足');
                }               
            }elseif($old_order->receivedAmount != $order['receivedAmount']){              
                $customerInfo = CustomerInfo::where('phone', $deposit_phone)->first();
                $balance = $customerInfo->balance;
                if( $balance < $order['receivedAmount']-$old_order->receivedAmount ){
                    //余额不足
                    return redirect('/admin/fxorder/index')->with('info', '充值卡余额不足');
                }
            }
        }

        $today_date = date('Y-m-d');
        //是否同步卖家
        $mjFlag = 0;
        //是否取消卖家
        $delFlag = 0;
        if($order['warehouse'] == 3 && $old_order->status >= 2 ){
            if($old_order->orderCode>0){
                $mjFlag = 2; //订单已存在卖家云，更新同步到卖家云
                //判断是否到预发货时间
                if($order['delivery_date']>$today_date){
                    //未到发货时间，取消卖家云订单
                    $delFlag = 1;
                }
            } 
            if( $old_order->warehouse != 3 && $order['delivery_date']<=$today_date){
                //订单其他仓变c仓同步到卖家云
                $mjFlag = 1;
            }
            //获取订单在卖家云信息
            $mjOrder = $this->getMjOrder($id, $old_order->outerCode);
        
            $orderSkus = [];
            $orderSkus['eshopCode'] = $old_order->eshopCode;
            $orderSkus['outerCode'] = $old_order->outerCode;
            $orderSkus['status'] = $old_order->status;
            $orderSkus['customerName'] = $order['customerName'];
            $orderSkus['shippingType'] = $old_order->shippingType;
            $orderSkus['expressCompanyCode'] = $old_order->expressCompanyCode;
            $orderSkus['expressCompanyName'] = $old_order->expressCompanyName;
            $orderSkus['receiverName'] = $order['receiverName'];
            $orderSkus['receiverMobile'] = isset($order['receiverMobile']) ? $order['receiverMobile'] : $old_order->receiverMobile;
            $orderSkus['receiverPhone'] = $orderSkus['receiverMobile'];
            $orderSkus['receiverState'] = $order['receiverState'];
            $orderSkus['receiverCity'] = $order['receiverCity'];
            $orderSkus['receiverDistrict'] = $old_order->receiverDistrict;
            $orderSkus['receiverStreet'] = $old_order->receiverStreet;
            $orderSkus['receiverAddress'] = $order['receiverAddress'];
            $orderSkus['buyerPostageFee'] = $old_order->buyerPostageFee;
            $orderSkus['discountFee'] = $old_order->discountFee;
            $orderSkus['adjustFee'] = $old_order->adjustFee;
            $orderSkus['serviceFee'] = $old_order->serviceFee;
            $orderSkus['paymentMethod'] = $old_order->paymentMethod;
            $orderSkus['paymentType'] = $old_order->paymentType;
            $orderSkus['paymentAccount'] = $old_order->paymentAccount;
            $orderSkus['paymentTime'] = $old_order->paymentTime;
            $orderSkus['receivedAmount'] = $order['receivedAmount'];
            $orderSkus['buyerMemo'] = $order['buyerMemo'];
            $orderSkus['sellerMemo'] = $order['sellerMemo'];
            $orderSkus['createTime'] = $old_order->createTime;
            $orderSkus['modifyTime'] = $old_order->modifyTime;
            
        }
        
        if($order['warehouse'] != 3 && $old_order->status >= 2 && $old_order->warehouse == 3){
            //同步卖家云
            $delFlag = 1;
        }
        DB::beginTransaction();
        try{
            $res = DB::table('fx_order')->where('id', $id)->update($order); 
            //商品信息
            $skus = $request->input('skus');
            $gnum = $request->input('gnum');
            if(empty($skus)) $skus = [];
            //先删除
            $del_re = DB::table('fx_order_goods_skus')->where('order_id', $id)->whereNotIn('sku_id', $skus)->update(['is_del'=>1]);
            if(!empty($skus)){            
                //再同步
                foreach($skus as $k=>$sku_id){
                    $sku_info = GoodsSkus::select('goodsCode', 'price', 'propsName','is_weigh')->where('id', $sku_id)->first();
                    $sync_re = FxOrderGoodsSkus::updateOrCreate(['order_id'=>$id, 'sku_id'=>$sku_id, 'goods_id'=>$sku_info->goodsCode], ['num'=>$gnum[$k], 'is_del'=>0, 'price'=>$sku_info->price]);
                    if( $mjFlag == 1 && empty($mjOrder) ){
                        $goods_info = Goods::where('id', $sku_info->goodsCode)->first();
                        $params = array();
                        $params['outerCode'] = $old_order->outerCode+$k+1; //外部平台中子订单编码
                        $params['outerParentCode'] = $old_order->outerCode; //外部平台中订单编码
                        $params['goodsCode'] = $sku_info->goodsCode;// strstr($goods->code,'-',true); 
                        $params['skuCode'] = $sku_id; 
                        #商品名称
                        $params['goodsName'] = $goods_info->name;
                        $params['propertiesName'] = $sku_info->is_weigh==1 ? $sku_info->propsName.'【按半斤称重】' : $sku_info->propsName;
                        $params['price'] = $sku_info->is_weigh==1 ? round($sku_info->price/2,2) : $sku_info->price;
                        $params['quantity'] = (int)($sku_info->is_weigh==1 ? $gnum[$k]*2 : $gnum[$k]);
                        $params['discountFee'] = 0;
                        $params['adjustFee'] = 0;
                        $params['refundStatus'] = '正常';
                        $orderSkus['skuList'][] = $params;
                        
                    }
                }

            }
            

            if($res){
                if($mjFlag == 1){    
                    //其他仓变C仓           
                    if(empty($mjOrder)){
                        $mj_in = $this->syncOrderToMj($id, $orderSkus);
                        if( $mj_in == false ){
                            throw new Exception("订单同步到卖家云失败");
                        }
                    }elseif($mjOrder['status'] == '已取消'){
                        //变更状态
                        $up = array();
                        $up['code'] = $old_order->orderCode;
                        $up['eshopCode'] = $old_order->eshopCode;
                        $up['outerCode'] = $old_order->outerCode;
                        $up['status'] = $old_order->status;
                        $mj_up = $this->updateOrderToMj($id, $up);
                        if( $mj_up == false ){
                            throw new Exception("订单同步到卖家云失败");
                        }
                    }
                }elseif($mjFlag == 2){
                    //C仓  卖家云订单更新
                    $orderSkus['code'] = $old_order->orderCode;
                    $mj_up = $this->updateOrderToMj($id, $orderSkus);
                    if( $mj_up == false ){
                        throw new Exception("订单更新同步到卖家云失败");
                    }
                }

                if($delFlag == 1){
                    //判断是否在卖家云存在
                    $mjOrder = $this->getMjOrder($id, $old_order->outerCode);
                    if(!empty($mjOrder)){
                        $del = array();
                        $del['eshopCode'] = $old_order->eshopCode;
                        $del['outerCode'] = $old_order->outerCode;
                        $del['code'] = $old_order->orderCode;
                        $mj_del = Order::mjOrderDel($del);
                        if( $mj_del == false ){
                            throw new Exception("订单同步到卖家云失败");
                        }
                    }
                }
               
                #新加逻辑，若付款方式为充值卡/消费记录
                if($order['payment_type'] == 4 ){
                    if($old_order->payment_type != 4 ){
                        $consum = new CustomerConsum();
                        $consum->phone = $deposit_phone;
                        $consum->order_id = $id;
                        $consum->money = $order['receivedAmount'];
                        $consum->save();
                        //更新余额                   
                        $customerInfo->balance = $customerInfo->balance - $order['receivedAmount'];
                        $customerInfo->save();
                    }elseif($old_order->receivedAmount != $order['receivedAmount']){
                        $consum = CustomerConsum::where('order_id', $id)->first();                       
                        $consum->money = $order['receivedAmount'];
                        $consum->save();
                        //更新余额
                        $add_amount = $order['receivedAmount'] - $old_order->receivedAmount; //新增消费额，有可能为负数
                        $customerInfo->balance = $customerInfo->balance - $add_amount;
                        $customerInfo->save();
                    }
                }

                #记录操作日志
                $self_id = session('admin_id');
                $self_name = session('real_name');            
                $context = "修改订单";
                $type = 0; 
                $tables = 'fx_order';
                $data_id = $id;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            }  

            DB::commit();
        }catch (Exception $e){
            DB::rollback();
            Log::errorLog($request,['error'=>$e->getMessage()],"order/update",0,'');
            return redirect('/admin/fxorder/index?'.$str_query)->with('info', $e->getMessage()); 
        }     

        if(!empty($last_url)){
            header('Location:'.$last_url);exit;
        }
        return redirect('/admin/fxorder/index?'.$str_query)->with('info', '更新成功');         
    }

    /**
     * 分组管理-进行删除操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderdelete($id)
    {
        $order = FxOrder::find($id);
        $order->is_del = 1;
        DB::beginTransaction();
        try{
            if ($order ->save()){
                //假如删除订单在卖家云，同步为取消状态
                if($order->orderCode>0 && $order->warehouse==3){
                    $del = array();
                    $del['eshopCode'] = $order->eshopCode;
                    $del['outerCode'] = $order->outerCode;
                    $del['code'] = $order->orderCode;
                    $mj_del = Order::mjOrderDel($del);
                    if( $mj_del == false ){
                        throw new Exception("订单同步到卖家云失败");
                    }
                }

                //假如删除订单为充值卡订单，返还余额
                if($order->payment_type == 4){
                    //查询消费记录/卡号
                    $consum = CustomerConsum::where('order_id', $id)->where('is_del', 0)->first();
                    //消费记录设为删除
                    CustomerConsum::where('order_id', $id)->update(['is_del'=>1]);
                    //余额返还
                    $cust = CustomerInfo::select('balance')->where('phone', $consum->phone)->first();
                    $balance = $cust->balance + $order->receivedAmount;
                    CustomerInfo::where('phone', $consum->phone)->update(['balance'=>$balance]);
                }

                #更新order_goods_skus状态
                $mj_status = array();
                $mj_status['mj_status'] = 2;
                FxOrderGoodsSkus::where('order_id', $id)->where('is_del', 0)->update($mj_status);

                #记录操作日志
                $self_id = session('admin_id');
                $self_name = session('real_name');            
                $context = "删除订单";
                $type = 0; 
                $tables = 'fx_order';
                $data_id = $id;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            }

            DB::commit();
        }catch (Exception $e){
            Log::errorLog('',['error'=>$e->getMessage()],"order/orderdelete",0,['id'=>$id]);
            DB::rollback();
        }
        exit('<script>window.location.replace(document.referrer)</script>');
        //return redirect('/admin/fxorder/index')->with('info', '删除成功');
    }

    /**
     * 设为退款状态操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function set_refund(Request $request)
    {
        $id = (int)$request->input('refund_id');
        $aftersale_fee = trim($request->input('refund_money'));
        $aftersale_reason = trim($request->input('refund_reason'));
        $aftersale_time = $request->input('refund_time');

        if(empty($aftersale_fee) || empty($aftersale_time)){
            exit('<script>alert("必须填写退款金额和时间");history.back()</script>');
        }
        $order = FxOrder::find($id);
        $order->status = 4;
        $order->aftersale_fee = $aftersale_fee;
        $order->aftersale_reason = $aftersale_reason;
        $order->aftersale_time = $aftersale_time;

        DB::beginTransaction();
        try{
            if ($order ->save()){
                //假如删除订单在卖家云，同步为取消状态
                if($order->orderCode>0 && $order->warehouse==3){
                    $del = array();
                    $del['eshopCode'] = $order->eshopCode;
                    $del['outerCode'] = $order->outerCode;
                    $del['code'] = $order->orderCode;
                    $mj_del = Order::mjOrderDel($del);
                    if( $mj_del == false ){
                        throw new Exception("订单同步到卖家云失败");
                    }
                }

                #更新order_goods_skus状态,退回库存
                $mj_status = array();
                $mj_status['mj_status'] = 2;
                FxOrderGoodsSkus::where('order_id', $id)->where('is_del', 0)->update($mj_status);

                #记录操作日志
                $self_id = session('admin_id');
                $self_name = session('real_name');            
                $context = "订单设为退款";
                $type = 0; 
                $tables = 'fx_order';
                $data_id = $id;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);
            }

            DB::commit();
        }catch (Exception $e){
            Log::errorLog('',['error'=>$e->getMessage()],"order/set_refund",0,['id'=>$id]);
            DB::rollback();
        }
        exit('<script>window.location.replace(document.referrer)</script>');
        //return redirect('/admin/fxorder/index')->with('info', '删除成功');
    }

    public function setrefund($id){
        $order = FxOrder::find($id);
        $order->order_status = 2;
        if ($order ->save()){
            exit('0');
        }
        exit('1');
    }

    public function setverify($id, Request $request){
        $order = FxOrder::find($id);
        $old_status = $order->status;
        $order->status = (int)$request->input('status');
        if($order->status == 0){
            $refuse_reason = trim($request->input('refuse_reason'));
            if(!empty($refuse_reason)){
                $order->refuse_reason = $refuse_reason;
            }
        }
        if($order->status == 2 || $order->status == 0){
            $order->verify_time = date('Y-m-d H:i:s'); //审核时间
        }

        //获取可变更状态
        $enableStatus = $this->getEnableStatus($old_status);
        if( !empty($enableStatus) ){
            $statusArr = array_column($enableStatus, 'status');
            if( !in_array($order->status, $statusArr) ){
                return redirect('/admin/fxorder/index')->with('info', '异常操作');
            }
        }else{
            return redirect('/admin/fxorder/index');
        }

        DB::beginTransaction();
        try{
            $res = $order ->save(); 
            if($res){
                #记录操作日志
                $status_arr = array(
                    0 => '已录入',
                    1 => '待审核',
                    2 => '已审核',
                    3 => '已发货',
                    4 => '已退款'
                );
                $self_id = session('admin_id');
                $self_name = session('real_name');
                $context = "订单状态变更：【".$status_arr[$old_status]."】变更为【". $status_arr[$order->status]."】({$old_status}->{$order->status})";
                $type = 1; //状态变更
                $tables = 'fx_order';
                $data_id = $id;
                Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);

                #发提醒短信
                //$this->sendRemind($self_id, $id, $order->status);

                $today_date = date('Y-m-d');
                #如果审核通过，c仓, 并且到预发货时间，同步卖家云
                if($order->status == 2 && $order->warehouse == 3 && $order->delivery_date <= $today_date){
                    $syncMj = $this->syncOrderToMj($id);
                    if( $syncMj == false ){
                        throw new Exception("订单同步到卖家云失败");
                    }

                    #同步到卖家云，更新order_goods_skus状态
                    $mj_status = array();
                    $mj_status['mj_status'] = 1;
                    FxOrderGoodsSkus::where('order_id', $id)->where('is_del', 0)->update($mj_status);
                }
            }

            DB::commit();
        }catch (Exception $e){
            Log::errorLog($request,['error'=>$e->getMessage()],"order/setverify",0,['id'=>$id]);
            DB::rollback();
        } 

        exit('<script>window.location.replace(document.referrer)</script>');

        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = $request->input('receiverName');
        $receiverMobile = $request->input('receiverMobile');
        $admin_id = (int)$request->input('admin_id');
        $page = (int)$request->input('page');  
        $str_query = 'page='.$page.'&admin_id='.$admin_id.'&stime='.$stime.'&etime='.$etime.'&receiverName='.$receiverName.'&receiverMobile='.$receiverMobile;
        return redirect('/admin/fxorder/index?'.$str_query)->with('info', '操作成功');
    }

    public function setverifymore(Request $request){
        $ids = $request->get('id');

        foreach($ids as $id){
            $order = FxOrder::find($id);
            $order->status = 1;
            $order ->save();
        }
        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = $request->input('receiverName');
        $receiverMobile = $request->input('receiverMobile');
        $admin_id = (int)$request->input('admin_id');
        $page = (int)$request->input('page');
        $str_query = 'page='.$page.'&admin_id='.$admin_id.'&stime='.$stime.'&etime='.$etime.'&receiverName='.$receiverName.'&receiverMobile='.$receiverMobile;
        return redirect('/admin/fxorder/index?'.$str_query)->with('info', '操作成功');
        
    }

    /**
     * 分组管理-分组展示
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderup($id)
    {
        //数据库-修改status字段值
        $order = FxOrder::find($id);
        $order ->status = 1;
        if ($order ->update()){
            return redirect('/admin/fxorder/index')->with('info', '启用成功');
        }
    }

    /**
     * 分组管理-取消展示
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderdown($id)
    {
        //数据库-修改status字段值
        $order = FxOrder::find($id);
        $order ->status = 0;
        if ($order ->update()){
            return redirect('/admin/fxorder/index')->with('info', '禁用成功');
        }
    } 
   
    /**
     * 分类取商品
     */
    public function categoods($category){
        $goods_ids = DB::table('goods_category')->where('goods_category_name', $category)->lists('goods_id');
        $goods = DB::table('goods_sku_list')->select('id', 'price', 'props_name', 'goods_id')->whereIn('goods_id', $goods_ids)->orderBy('goods_id', 'asc')->get();

        foreach($goods as $item){
            $gname = DB::table('goods_category')->select('goods_name')->where('goods_id', $item->goods_id)->first();
            $item->goods_name = $gname->goods_name;
        }

        $goods = json_decode(json_encode($goods), true);
        return json_encode($goods);
    }

    /**
     * 操作员列表
     */
    public function teamAdmins($team_id){   
        //$saler_ids = DB::table('admin_role')->where('role_name', '销售')->lists('user_id');
        $res = DB::table('admin')->select('id', 'realname', 'username')->where('team_id', $team_id)->where('id','>', 1)->get();
        $res = json_decode(json_encode($res),true);
        return json_encode($res);
    }

    /**
     * 客户地址信息
     */
    public function getCustomer(Request $request){
        $phone = $request->input('phone');
        if(!preg_match('/^1\d{10}$/')){
            return 0;
        }
        $res = DB::table('fx_customers')->where('phone', $phone)->first();
        if(isset($res->id)){
            $result = json_decode(json_encode($res),true);
            return json_encode($result);
        }
    }

    public function order_export(Request $request){
        
        $self_role = session('role_name');
        if($self_role == '超级管理员' || $self_role == '团队主管' || $self_role == '管理员' || $self_role == 'A仓库管理员' || $self_role == 'B仓库管理员' || $self_role == '售后管理员' || $self_role == '分销管理员'){
            $admin_id = $request->input('admin_id');
        }else{
            $admin_id = session('admin_id');
        }

        $is_saler = 0;
        if($self_role == '销售' || $self_role == '分销销售'){
            $is_saler = 1;
        }

        if($self_role == 'A仓库管理员'){
            $warehouse = 1;
        }elseif($self_role == 'B仓库管理员'){
            $warehouse = 2;
        }else{
            $warehouse = 0;
        }

        $team_id = $request->input('team_id');
        #只能看自己团队的
        if($self_role != '超级管理员' && $self_role != '售后管理员'){
            $self_id = session('admin_id');
            $team_id = DB::table('admin')->where('id', $self_id)->pluck('team_id');        
        }

        //假如有团队筛选，检索销售队员
        $sale_ids = null;
        if($team_id>0){
            $sale_ids = DB::table('admin')->where('team_id', $team_id)->lists('id');
        }

        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = $request->input('receiverName');
        $receiverMobile = $request->input('receiverMobile');
        $status = $request->input('status');
        $id = (int)$request->input('id');
        $warehouse = (int)$request->input('warehouse');
        if($status === null){
            $status = -1;
        }
        if($etime){
            $etime = $etime. ' 23:59:59';
        }

        $result = FxOrder::where(function($query) use($admin_id, $stime, $etime, $receiverName, $receiverMobile, $self_role, $sale_ids, $status, $id, $warehouse){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($self_role == '管理员' || $self_role == '分销管理员') $query->where('status','>',0);
            if(!empty($sale_ids)) $query->whereIn('admin_id', $sale_ids);
            if(($status>=0)) $query->where('status', $status);
            if(($id>0)) $query->where('id', $id);
            if(($warehouse>0)) $query->where('warehouse', $warehouse);
        })->where('is_del',0)->orderBy('id', 'desc')->get();
        $result = json_decode(json_encode($result),true);

        $status_arr = array(
            0 => '已录入',
            1 => '待审核',
            2 => '已审核',
            3 => '已发货',
            4 => '已退款'
        );
        $payArr = [1=>'微信支付', 2=>'付款码支付', 3=>'个体户支付', 4=>'充值卡支付']; 
        foreach($result as $k=>&$v){
            #加粉时间
            $fanTime = DB::table('fx_customers')->select('fanTime')->where('phone', $v['receiverMobile'])->first();
            $v['fanTime'] = isset($fanTime->fanTime) ? $fanTime->fanTime : '';
            $v['receiverMobile'] = substr($v['receiverMobile'], 0, 3).'****'.substr($v['receiverMobile'], 7);
            $v['status_name'] = $status_arr[$v['status']];   
            $v['address'] = $v['receiverState'].$v['receiverCity'].$v['receiverDistrict'].$v['receiverStreet'].$v['receiverAddress'];   
            $v['warehouse'] = $v['warehouse'] == 1? 'A仓库':'B仓库';      
            $v['is_fugou'] = $v['is_fugou'] == 1? '是':'否';      
            $v['is_refund'] = $v['is_refund'] == 1? '是':'否'; 
            $v['payment_type'] = $payArr[$v['payment_type']];    
        }

        if($is_saler == 0){
            $indexKey = ['id','receiverName','receiverMobile','address','goods_note','delivery_date', 'logistics_id', 'cost','freight_cost','warehouse','receivedAmount', 'payment_type', 'createTime','fanTime','is_fugou','is_refund','refund_price','refund_note','admin_name','status_name','verify_time','buyerMemo','sellerMemo','send_note','aftersale_fee', 'aftersale_reason', 'aftersale_time'];
            $title = ['订单编号', '收货人', '收货人手机号', '收货地址', '商品信息', '预发货时间', '物流单号', '货品成本', '运费成本', '发货仓库', '付款金额', '支付方式', '下单时间', '加粉时间', '是否复购', '是否退补单', '应该退补差价', '退补备注', '所属销售', '订单状态', '审核时间', '买家备注', '卖家备注', '发货备注', '售后费用', '售后原因', '售后时间'];
        }else{
            $indexKey = ['id','receiverName','receiverMobile','address','goods_note','delivery_date', 'logistics_id', 'warehouse','receivedAmount','payment_type','createTime','fanTime','is_fugou','is_refund','refund_price','refund_note','admin_name','status_name','verify_time','buyerMemo','sellerMemo','send_note','aftersale_fee', 'aftersale_reason'];
            $title = ['订单编号', '收货人', '收货人手机号', '收货地址', '商品信息', '预发货时间', '物流单号', '发货仓库', '付款金额', '付款方式', '下单时间', '加粉时间', '是否复购', '是否退补单', '应该退补差价', '退补备注', '所属销售', '订单状态', '审核时间', '买家备注', '卖家备注', '发货备注', '售后费用', '售后原因'];
        }
        $filename = 'dingdan_'.date('Y-m-d_H').'.xlsx';
        return $this->export_excel($result, $filename, $indexKey, $title);     
    }

    public function editLogisticsId(Request $request){
        $id = (int)$request->input('id');
        $logistics_id = $request->input('logistics_id');
        $send_time = $request->input('send_time');
        $cost = $request->input('cost');
        $freight_cost = $request->input('freight_cost');
        $send_note = $request->input('send_note');
        $refund_note = $request->input('refund_note');
        $buyerMemo = $request->input('buyerMemo');
        $sellerMemo = $request->input('sellerMemo');
        $aftersale_fee = $request->input('aftersale_fee');
        $aftersale_reason = $request->input('aftersale_reason');
        $aftersale_time = $request->input('aftersale_time');
        $refund_time = $request->input('refund_time');
        $refund_price = $request->input('refund_price');
        $refund_type = $request->input('refund_type');

        $order = FxOrder::where('id', $id)->first();
        $data = array();
        if(isset($logistics_id)){
            $data['logistics_id'] = $logistics_id;
            if($logistics_id && !$order->send_time){
                //填物流单号默认发货，记录发货时间 //更新的时候不变动
                $data['send_time'] = date('Y-m-d');
            }
        }
        if(isset($send_time)) $data['send_time'] = trim($send_time);
        if(isset($cost)){
            if(empty($cost)) $cost = null; 
            $data['cost'] = $cost;
        }
        if(isset($freight_cost)){
            if(empty($freight_cost)) $freight_cost = null; 
            $data['freight_cost'] = $freight_cost;
        }
        if(isset($buyerMemo)) $data['buyerMemo'] = trim($buyerMemo);
        if(isset($sellerMemo)) $data['sellerMemo'] = trim($sellerMemo);
        if(isset($send_note)) $data['send_note'] = trim($send_note);
        if(isset($refund_note)) $data['refund_note'] = trim($refund_note);
        if(isset($aftersale_fee)) $data['aftersale_fee'] = trim($aftersale_fee);
        if(isset($aftersale_reason)) $data['aftersale_reason'] = trim($aftersale_reason);
        if(isset($aftersale_time)) $data['aftersale_time'] = trim($aftersale_time);
        if(isset($refund_time)) $data['refund_time'] = trim($refund_time);
        if(isset($refund_price)){
            if(empty($refund_price)){
                $refund_price = null; 
                $data['is_refund'] = 0;
            }else{
                $data['is_refund'] = 1;
                if(!$order->refund_type) $data['refund_type'] = 1;
            }
            $data['refund_price'] = $refund_price;
        }
        if(isset($refund_type)){
            if(empty($refund_type)){
                $refund_type = null;                
            }
            $data['refund_type'] = (int)$refund_type;
        }
        if($id>0 && !empty($data)){
            $res = FxOrder::where('id', $id)->update($data);
        }

        return 1;
    }

    public function warehouse_export(Request $request){
        
        $self_role = session('role_name');        
        $admin_id = $request->input('admin_id');        

        if($self_role == 'A仓库管理员'){
            $warehouse = 1;
        }elseif($self_role == 'B仓库管理员'){
            $warehouse = 2;
        }else{
            $warehouse = 0;
        }

        $stime = $request->input('stime');
        $etime = $request->input('etime');
        $receiverName = $request->input('receiverName');
        $receiverMobile = $request->input('receiverMobile');
        $delivery_type = (int)$request->input('delivery_type'); //发货状态 0到发货时间（未填物流信息） 2全部
        $id = (int)$request->input('id');

        $_start = '2019-09-18';// 只看18号之后数据
        $today_date = date('Y-m-d');
        $result = FxOrder::where(function($query) use($admin_id, $stime, $etime, $warehouse, $receiverMobile, $receiverName, $today_date, $delivery_type, $_start, $id){
            if($admin_id) $query->where('admin_id',  $admin_id);
            if($warehouse) $query->where('warehouse',  $warehouse);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
            if($receiverName) $query->where('receiverName', 'like', $receiverName . '%');
            if($receiverMobile) $query->where('receiverMobile', $receiverMobile);
            if($id>0) $query->where('id', $id);
            if($delivery_type==0) $query->where('logistics_id', '=', '');
            $query->where('createTime', '>=', $_start);
        })->where('is_del',0)->where('status', '>', 1)->where('delivery_date', '<=', $today_date)->orderBy('id', 'desc')->get();

        $result = json_decode(json_encode($result),true);
        foreach ($result as $k => &$v)
        {
            $v['address'] = $v['receiverState'].$v['receiverCity'].$v['receiverDistrict'].$v['receiverStreet'].$v['receiverAddress'];                
        }

        $indexKey = ['id','goods_note','receiverName','receiverMobile','address','createTime','sellerMemo','buyerMemo','cost','logistics_id','freight_cost','send_note'];
        $title = ['订单编号', '商品信息', '收货人', '收货人手机号', '收货地址', '下单时间', '卖家备注', '买家备注', '供应商成本', '顺丰单号', '运费成本', '发货备注'];
        $filename = 'dingdan_'.date('Y-m-d_H').'.xlsx';
        return $this->export_excel($result, $filename, $indexKey, $title);
 
    }

    /**
     * excel导入订单信息
     * @param Request $request
     */
    public function importGoodsExcel(Request $request) {
        $excelFile = $request->file('orderFile');
        //实例化Excel读取类
        $objReader = new PHPExcel_Reader_Excel2007();

        if(!$objReader->canRead($excelFile)){
            $objReader = new PHPExcel_Reader_Excel5();
            if(!$objReader->canRead($excelFile)){
                echo "\n".'无法识别的Excel文件！';
                return false;
            }
        }
        $objPHPExcel=$objReader->load($excelFile);
        $worksheet=$objPHPExcel->getSheet(0);//获取第一个工作表
        $highestRow=$worksheet->getHighestRow();//取得总行数
        $highestColumn=$worksheet->getHighestColumn(); //取得总列数

        $lines = $highestRow - 1;
        if ($lines <= 0) {
            //'Excel表格中没有数据';
            return false;
        }

        $errorArr=[];
        $okStr = '';
        for ($row = 2; $row <= $highestRow; ++$row) {
            $params  = array();
            $order_id = (int)$worksheet->getCellByColumnAndRow(0, $row)->getValue(); 
            $cost = trim($worksheet->getCellByColumnAndRow(8, $row)->getValue());
            $logistics_id = trim($worksheet->getCellByColumnAndRow(9, $row)->getValue());
            $freight_cost = trim($worksheet->getCellByColumnAndRow(10, $row)->getValue());
            $send_note = trim($worksheet->getCellByColumnAndRow(11, $row)->getValue());

            if($cost>0){
                $params['cost'] = $cost;
            }else{
                $params['cost'] = null;
            }
            if($logistics_id){
                $params['logistics_id'] = $logistics_id;
            }else{
                $params['logistics_id'] = '';
            }
            if($send_note){
                $params['send_note'] = $send_note;
            }else{
                $params['send_note'] = '';
            }
            if($freight_cost>0){
                $params['freight_cost'] = $freight_cost;
            }else{
                $params['freight_cost'] = null;
            }

            $result = FxOrder::where('id', $order_id)->update($params);

            if (!$result) {
                $errorArr[] = $order_id;
            }else{
                $okStr .= $order_id.',';
            }
        }
        if (count($errorArr)) {
            $desc = '共'.($highestRow-1).'个订单, 其中'.count($errorArr).'个订单录入失败';
        }else {
            $desc = '订单导入成功';
        }

        #记录操作日志
        $self_id = session('admin_id');
        $self_name = session('real_name');            
        $context = "仓管excel导入订单成本等信息 ".$desc;
        $type = 0; 
        $tables = 'fx_order';
        $data_id = $okStr;
        Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);

        return redirect('admin/fxorder/warehouse')->with('info',$desc);
        

    }

    /**
     * excel导入订单运费信息
     * @param Request $request
     */
    public function importDeliveryExcel(Request $request) {
        $excelFile = $request->file('orderFile');
        //实例化Excel读取类
        $objReader = new PHPExcel_Reader_Excel2007();

        if(!$objReader->canRead($excelFile)){
            $objReader = new PHPExcel_Reader_Excel5();
            if(!$objReader->canRead($excelFile)){
                return redirect('admin/fxorder/warehouse')->with('info','无法识别的Excel文件！');
            }
        }
        $objPHPExcel=$objReader->load($excelFile);
        $worksheet=$objPHPExcel->getSheet(0);//获取第一个工作表
        $highestRow=$worksheet->getHighestRow();//取得总行数
        $highestColumn=$worksheet->getHighestColumn(); //取得总列数

        $lines = $highestRow - 1;
        if ($lines <= 0) {
            //'Excel表格中没有数据';
            return false;
        }

        $errorArr=[];
        $okStr = '';
        for ($row = 2; $row <= $highestRow; ++$row) {
            $logistics_id = trim($worksheet->getCellByColumnAndRow(1, $row)->getValue()); 
            $freight_cost = trim($worksheet->getCellByColumnAndRow(13, $row)->getValue());
           //var_dump($logistics_id,$freight_cost);exit;
            if($freight_cost>0){
                $params['freight_cost'] = $freight_cost;
                $result = FxOrder::where('logistics_id', $logistics_id)->update($params);
                if (!$result) {
                    $errorArr[] = $logistics_id;
                }else{
                    $okStr .= $logistics_id.',';
                }
            }
            
        }
        if (count($errorArr)) {
            $desc = '共'.($highestRow-1).'个物流单, 其中'.($highestRow-1-count($errorArr)).'个物流单导入成功';
        }else {
            $desc = '订单导入成功';
        }

        #记录操作日志
        $self_id = session('admin_id');
        $self_name = session('real_name');            
        $context = "excel导入订单物流成本 ".$desc;
        $type = 0; 
        $tables = 'fx_order';
        $data_id = $okStr;
        Oplog::addLog($self_id, $self_name, $context, $type, $tables, $data_id);

        return redirect('admin/fxorder/warehouse')->with('info',$desc);
        

    }

    /**
     * 导出excel
     * @param $data
     * @param string 
     */
    public function export_excel($data, $filename = '未命名.xlsx', $indexKey, $title) {

        if( !is_array($indexKey)) return false;            
        $header_arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z','AA','AB','AC','AD','AE');  
        //初始化PHPExcel()  
        $objPHPExcel = new PHPExcel();            
        $objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);    
            
        //接下来就是写数据到表格里面去  
        $objActSheet = $objPHPExcel->getActiveSheet();  
        foreach($title as $k=>$item){
            $objActSheet->setCellValue($header_arr[$k].'1',$item);
        }
        $startRow = 2;  
        foreach ($data as $row) {  
            foreach ($indexKey as $key => $value){  
                //这里是设置单元格的内容  
                $objActSheet->setCellValue($header_arr[$key].$startRow,$row[$value]);  
            }  
            $startRow++;  
        } 

        header("Pragma: public");  
        header("Expires: 0");  
        header("Cache-Control:must-revalidate, post-check=0, pre-check=0");  
        header("Content-Type:application/force-download");  
        header("Content-Type:application/vnd.ms-execl");  
        header("Content-Type:application/octet-stream");  
        header("Content-Type:application/download");;  
        header('Content-Disposition:attachment;filename='.$filename.'');  
        header("Content-Transfer-Encoding:binary");  
        $objWriter->save('php://output');  
        exit();
    }

    /**
     * 根据手机号获取默认地址信息
     *
     */
    public function getAddress(Request $request){
        $phone = $request->input('phone');
        if(!preg_match('/^1\d{10}$/', $phone)){
            exit('0');
        }

        $result = DB::table('fx_customers')->select('receiverState', 'receiverCity', 'receiverDistrict', 'receiverStreet', 'receiverAddress', 'fanTime')->where('phone', $phone)->first();
        if(empty($result)) exit('0');

        $result = json_decode(json_encode($result), true);
        exit( json_encode($result) );
    }

    /**
     * 订单状态机制，获取可变更状态
     * @param status：0已录入 1提交审核 2已审核 3已发货 4已退款
     */
    public function getEnableStatus($status){
        $status_arr = [
            0 => ['status'=>0, 'name'=>'已录入'],
            1 => ['status'=>1, 'name'=>'提交审核'],
            2 => ['status'=>2, 'name'=>'审核通过'],
            3 => ['status'=>3, 'name'=>'设为发货'],
            4 => ['status'=>4, 'name'=>'设为退款']
        ];
        $status = (int)$status;
        $result = array();
        switch ($status) {
            case '0':
                $result[] = $status_arr[1];
                break;
            case '1':
                $result[] = $status_arr[2];
                $result[] = $status_arr[0];
                break;
            case '2':
                $result[] = $status_arr[3];
                break;
            default:               
                break;
        }
        return $result;
    }

    /**
     * 根据订单状态发短信提醒
     */
    public function sendRemind($user_id, $id, $status){
        if($status == 0 || $status == 3){
            //被驳回,获取销售手机号
            $saler_id = DB::table('fx_order')->where('id', $id)->pluck('admin_id');
            $phone = DB::table('admin')->where('id, $saler_id')->pluck('phone');
            $type = $status == 0 ? 5 : 3;
        }elseif($status == 1){
            //待审核,获取团队管理员手机号
            $admin_ids = DB::table('admin_role')->where('role_name','管理员')->lists('user_id');
            $team_id = DB::table('admin')->where('id', $user_id)->pluck('team_id');
            $admin_info = DB::table('admin')->where('team_id', $team_id)->whereIn('id', $admin_ids)->first();
            $phone = $admin_info->phone;
            $type = 1;
        }elseif($status == 2){
            //审核通过，通知仓管发货
            $warehouse = DB::table('fx_order')->where('id', $id)->pluck('warehouse');
            if($warehouse == 1){
                $warehouse_admin = DB::table('admin_role')->select('user_id')->where('role_name','A仓库管理员')->orderBy('id', 'desc')->first();
                $admin_info = DB::table('admin')->where('id', $warehouse_admin->user_id)->first();
                $phone = $admin_info->phone;
                $type = 2;
            }
        }

        if(!$phone){
            return false;
        }
        $res = YPSMS::sendMsg($phone,$type,$id);
        return $res;
    }

    /**
     * 订单同步到卖家云
     */
    public function syncOrderToMj($id, $order = []){
        if( empty($order) ){ 
            $order = FxOrder::select('eshopCode','outerCode','status','customerName','shippingType','expressCompanyCode','expressCompanyName','receiverName','receiverMobile','receiverPhone','receiverState','receiverCity','receiverDistrict','receiverStreet','receiverAddress','buyerPostageFee','discountFee','adjustFee','serviceFee','paymentMethod','paymentType','paymentAccount','paymentTime','receivedAmount','buyerMemo','sellerMemo','createTime','modifyTime')->where('id', $id)->first();

            $order = json_decode(json_encode($order), true);
            $skus = DB::table('fx_order_goods_skus')->where('is_del', 0)->where('order_id', $id)->get();
            $skus = json_decode(json_encode($skus), true);
            foreach($skus as $k=>$v){
                $sku_info = GoodsSkus::where('id', $v['sku_id'])->first();
                $goods_info = Goods::where('id', $v['goods_id'])->first();
                $params = array();
                $params['outerCode'] = $order['outerCode']+$k+1; //外部平台中子订单编码
                $params['outerParentCode'] = $order['outerCode']; //外部平台中订单编码
                $params['goodsCode'] = $sku_info->goodsCode;// 
                $params['skuCode'] = $v['sku_id']; 
                #商品名称
                $params['goodsName'] = $goods_info->name;
                $params['propertiesName'] = $sku_info->is_weigh==1 ? $sku_info->propsName.'【按半斤称重】' : $sku_info->propsName;
                //$params['goodsName'] = '海钓黄翅鱼';//$goods->code; 
                $params['price'] = $sku_info->is_weigh==1 ? round($v['price']/2,2) : $v['price'];
                $params['quantity'] = (int)($sku_info->is_weigh==1 ? $v['num']*2 : $v['num']);
                $params['discountFee'] = 0;
                $params['adjustFee'] = 0;
                $params['refundStatus'] = '正常';
                $order['skuList'][] = $params;
            }
        }
        //卖家云添加订单 ->改为审核通过再同步卖家云
        $mj_add = Order::mjOrderAdd($order);
        //同步卖家云订单数据到本系统
        if( isset($mj_add['order']['code']) ){
            $mjorder = array();
            $mjorder['orderCode'] = $mj_add['order']['code'];
            FxOrder::where('id', $id)->update($mjorder);
        }

        return $mj_add;
    }

    /**
     * 订单同步到卖家云
     */
    public function updateOrderToMj($id, $order = []){
        if( empty($order) ){
            $order = FxOrder::select('orderCode as code','eshopCode','outerCode','status','customerName','shippingType','expressCompanyCode','expressCompanyName','receiverName','receiverMobile','receiverPhone','receiverState','receiverCity','receiverDistrict','receiverStreet','receiverAddress','buyerPostageFee','discountFee','adjustFee','serviceFee','paymentMethod','paymentType','paymentAccount','paymentTime','receivedAmount','buyerMemo','sellerMemo','createTime','modifyTime')->where('id', $id)->first();

            $order = json_decode(json_encode($order), true);
        }

        //卖家云添加订单 ->改为审核通过再同步卖家云
        $mj_add = Order::mjOrderUpdate($order);

        return $mj_add;
    }

    /**
     * 获取订单信息，可用来判断订单是否存在，同步订单状态
     */
    public function getMjOrder($id, $outerCode=''){
        $order = array();
        $order['eshopCode'] = config('constants.ESHOP_CODE');
        if(!$outerCode){
            $outerCode = FxOrder::where('id', $id)->pluck('outerCode');
        }
        $order['outerCode'] = $outerCode;
        $mjOrder = Order::mjOrderGet($order);
        if(!isset($mjOrder['order']['code'])){
            return false;
        }
        return $mjOrder['order'];
    }

}