seafood/app/Http/Controllers/Admin/OrderControl...

<?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\Logs;
use App\Order;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\DB;

class OrderController 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 == '团队主管'){
            $admin_id = $request->input('admin_id');
            $search_admin = 1;
        }else{
            $admin_id = session('admin_id');
            $search_admin = 0;
        }
        
        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $count = Order::where(function($query) use($admin_id, $stime, $etime){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
        })->where('is_del',0)->count();
        if ($count > 1) {
            // 总页数
            $pages = ceil($count/$pageSize);
        }else{
            // 总页数
            $pages = 1;
        }

        $result = Order::where(function($query) use($admin_id, $stime, $etime){
            if($admin_id) $query->where('admin_id', $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
        })->where('is_del',0)->orderBy('id', 'desc')->offset($offset)->limit($pageSize)->get();
        $result = json_decode(json_encode($result),true);
        
        foreach($result as $k=>&$v){
            /*
            //获取商品信息
            $v['goods'] = '';
            $goods = DB::table('order_goods')->where('outerParentCode', $v['outerCode'])->get();
            foreach($goods as $item){
                $v['goods'][] = $item->goodsName.'&nbsp; 单价:￥'.$item->price.'&nbsp; 件数:'.$item->quantity.'';
            }
            */

            $v['receiverMobile'] = substr($v['receiverMobile'], 0, 3).'****'.substr($v['receiverMobile'], 7);
        }
        
        $adminList = DB::table('admin')->select('id', 'realname', 'username')->where('id','>', 1)->get();
        $adminList = json_decode(json_encode($adminList), true);
        return view('order/orderlist', ['result' =>$result,
            'page'              =>$page,
            'count'             =>$count,
            'pages'             =>$pages,
            'admin_id'          =>$admin_id,
            'stime'             =>$stime,
            'etime'             =>$etime,
            'adminlist'         =>$adminList,
            'search_admin'         =>$search_admin,
            ]);
    }

    /**
     * 添加订单
     * @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')->get();
        $teamList = json_decode(json_encode($teamList), true);
        $adminList = json_decode(json_encode($adminList), true);

        return view('order/ordercreate', ['categorylist' => $catelist, 'adminlist'=>$adminList, 'teamlist'=>$teamList]);
    }
    /**
     * 分组管理-进行添加操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderstore(Request $request)
    {       
        $this->validate($request, [
            'receiverName'           => 'required', 
            'receiverMobile'           => 'required',  
            'receivedAmount'           => 'required', 
            'goods_note'           => 'required',  
        ], [                  
            'receiverName.required'           => '收货人不能为空',                   
            'receiverMobile.required'           => '收货人手机号不能为空',                   
            'receivedAmount.required'           => '付款金额不能为空',                   
            'goods_note.required'           => '商品信息不能为空',                   
        ]);
        //数据库-新增数据
        $order = array();
        $order['eshopCode'] = '99|34881'; //默认
        $order['outerCode'] = Order::createOuterCode();//随机生成
        $order['status'] = '已审核待发货';
        $order['customerName'] = $request->input('customerName'); //买家名称
        $order['shippingType'] = '卖家包邮';
        $order['expressCompanyCode'] = '10084';
        $order['expressCompanyName'] = '顺丰快递';
        $order['receiverName'] = $request->input('receiverName'); //收件人
        $order['receiverMobile'] = $request->input('receiverMobile'); //收件人手机
        $order['receiverPhone'] = $request->input('receiverMobile'); //收件人手机
        $order['receiverState'] = $request->input('receiverState'); //省份
        $order['receiverCity'] = $request->input('receiverCity'); //市
        $order['receiverDistrict'] = $request->input('receiverDistrict'); //区
        $order['receiverStreet'] = $request->input('receiverStreet'); //街道
        $order['receiverAddress'] = $request->input('receiverAddress'); //详细地址
        $order['buyerPostageFee'] = 0; //买家邮费
        $order['discountFee'] = 0; //订单优惠
        $order['adjustFee'] = 0; //订单调价
        $order['serviceFee'] = 0; //服务费
        $order['paymentMethod'] = '在线付款';
        $order['paymentType'] = '网银';
        $order['paymentAccount'] = '18322223333'; // 付款账号，暂时默认写死
        $order['paymentTime'] = date('Y-m-d H:i:s'); // 付款时间
        $order['receivedAmount'] = $request->input('receivedAmount'); //付款金额        
        $order['buyerMemo'] = $request->input('buyerMemo', ''); // 买家备注
        $order['sellerMemo'] = $request->input('sellerMemo', ''); // 卖家备注
        $order['createTime'] = date('Y-m-d H:i:s'); // 订单创建时间
        $order['modifyTime'] = date('Y-m-d H:i:s'); // 订单修改时间

        $order['goods_note'] = $request->input('goods_note');
        if($request->input('cost')) $order['cost'] = $request->input('cost');  //成本
        $order['logistics_id'] = $request->input('logistics_id'); //物流单号
        $order['is_refund'] = (int)$request->input('is_refund'); //是否退过单
        $order['is_fugou'] = (int)$request->input('is_fugou'); //是否复购

        //商品信息
        /*
        $g_info = trim($request->input('g_info'),';');
        //var_dump($g_info);
        $g_info = explode(';' , $g_info);
        $goods_info = array();
        foreach($g_info as $k=>$info){
            $info = explode(':', $info);
            $goods_info[$k]['id'] = $info[0];
            $goods_info[$k]['num'] = $info[1];
        }
        foreach($goods_info as $k=>$v){
            $goods = DB::table('goods_sku_list')->where('id', $v['id'])->first();
            $params = array();
            $params['outerCode'] = $order['outerCode']+$k+1; //外部平台中子订单编码
            $params['outerParentCode'] = $order['outerCode']; //外部平台中订单编码
            $params['goodsCode'] = $goods->code;// strstr($goods->code,'-',true); 
            $params['skuCode'] = $goods->code; 
            #商品名称
            $params['goodsName'] = DB::table('goods_category')->where('goods_id', $goods->goods_id)->pluck('goods_name');
            //$params['goodsName'] = '海钓黄翅鱼';//$goods->code; 
            $params['price'] = $goods->price;
            $params['quantity'] = $v['num'];
            $params['discountFee'] = 0;
            $params['adjustFee'] = 0;
            $params['refundStatus'] = '正常';
            $order['skuList'][] = $params;
        }
        */

        //卖家云添加订单
        //$mj_add = Order::mjOrderAdd($order);

        if(true){
            #更新客户表
            $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('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('customers')->where('id', $if_e->id)->update($customers);
            }else{
                $customers['phone'] = $order['receiverMobile'];
                $customers['fanTime'] = $request->input('fanTime');
                $customers['is_fugou'] = $order['is_fugou'];
                $in_c = DB::table('customers')->insert($customers);
            }

            //$order_goods = $order['skuList'];
            //unset($order['skuList']);
            //DB::table('order_goods')->insert($order_goods);
            //$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');
            }
            DB::table('order')->insert($order);
            
            return redirect('/admin/order/index')->with('info', '添加成功'); 
        }

    }

    /**
     * 分组管理-编辑分组界面
     * @param $id
     * @return \Illuminate\View\View
     */
    public function orderedit($id,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')->get();
        $teamList = json_decode(json_encode($teamList), true);
        $adminList = json_decode(json_encode($adminList), true);
        $order = Order::findOrFail($id);
        $order = json_decode(json_encode($order), true);
        $order['receiverMobile'] = substr($order['receiverMobile'], 0, 3).'****'.substr($order['receiverMobile'], 7);
        return view('order/orderedit', [       
            'order' => $order,
            //'categorylist' => $catelist,
            'adminlist'=>$adminList,
            'teamlist'=>$teamList
        ]);

    }

    /**
     * 分组管理-进行编辑操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderupdate(Request $request)
    {            
        $this->validate($request, [
            'id'           => 'required', 
            'receiverName'           => 'required', 
            'receiverMobile'           => 'required',  
            'receivedAmount'           => 'required', 
            'goods_note'           => 'required',  
        ], [
            'id.required'           => 'id不能为空',                   
            'receiverName.required'           => '收货人不能为空',                   
            'receiverMobile.required'           => '收货人手机号不能为空',                   
            'receivedAmount.required'           => '付款金额不能为空',                   
            'goods_note.required'           => '商品信息不能为空',                   
        ]);
       
        $phone = $request->input('receiverMobile');
        //更新数据
        $order = array();
        $order['customerName'] = $request->input('customerName'); //买家名称
        $order['receiverName'] = $request->input('receiverName'); //收件人
        if(preg_match('/^1\d{10}$/', $phone)) $order['receiverMobile'] = $phone; //收件人手机
        $order['receiverState'] = $request->input('receiverState'); //省份
        $order['receiverCity'] = $request->input('receiverCity'); //市
        $order['receiverDistrict'] = $request->input('receiverDistrict'); //区
        $order['receiverStreet'] = $request->input('receiverStreet'); //街道
        $order['receiverAddress'] = $request->input('receiverAddress'); //详细地址
        $order['receivedAmount'] = $request->input('receivedAmount'); //付款金额        
        $order['buyerMemo'] = $request->input('buyerMemo', ''); // 买家备注
        $order['sellerMemo'] = $request->input('sellerMemo', ''); // 卖家备注
        $order['goods_note'] = $request->input('goods_note');
        if($request->input('cost')) $order['cost'] = $request->input('cost');  //成本
        $order['logistics_id'] = $request->input('logistics_id'); //物流单号
        $order['is_refund'] = (int)$request->input('is_refund'); //是否退过单
        $order['is_fugou'] = (int)$request->input('is_fugou'); //是否复购

        $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');
        $res = DB::table('order')->where('id', $id)->update($order);        
        return redirect('/admin/order/index')->with('info', '更新成功');         
    }

    /**
     * 分组管理-进行删除操作
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderdelete($id)
    {
        $order = Order::find($id);
        $order->is_del = 1;
        if ($order ->save()){
            return redirect('/admin/order/index')->with('info', '删除成功');
        }
    }



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

    /**
     * 分组管理-取消展示
     * @param Request $request
     * @return \Illuminate\Http\RedirectResponse
     */
    public function orderdown($id)
    {
        //数据库-修改status字段值
        $order = Order::find($id);
        $order ->status = 0;
        if ($order ->update()){
            return redirect('/admin/order/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){   
        $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('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 == '团队主管'){
            $admin_id = $request->input('admin_id');
        }else{
            $admin_id = session('admin_id');
        }
        $stime = $request->input('stime');
        $etime = $request->input('etime');

        $result = Order::where(function($query) use($admin_id, $stime, $etime){
            if($admin_id) $query->where('admin_id',  $admin_id);
            if($stime) $query->where('createTime', '>=', $stime);
            if($etime) $query->where('createTime', '<=', $etime);
        })->where('is_del',0)->orderBy('id', 'desc')->get();
        $result = json_decode(json_encode($result),true);


        $filename="订单数据.xls";
        header("Content-type:application/vnd.ms-excel");
        Header("Accept-Ranges:bytes");
        Header("Content-Disposition:attachment;filename=".$filename); //$filename导出的文件名
        header("Pragma: no-cache");
        header("Expires: 0");

    $data_str = '<html xmlns:o="urn:schemas-microsoft-com:office:office"
            xmlns:x="urn:schemas-microsoft-com:office:excel"
            xmlns="http://www.w3.org/TR/REC-html40">
            <head>
            <meta http-equiv="expires" content="Mon, 06 Jan 1999 00:00:01 GMT">
            <meta http-equiv=Content-Type content="text/html; charset=gb2312">
            <!--[if gte mso 9]><xml>
            <x:ExcelWorkbook>
            <x:ExcelWorksheets>
            <x:ExcelWorksheet>
            <x:Name></x:Name>
            <x:WorksheetOptions>
            <x:DisplayGridlines/>
            </x:WorksheetOptions>
            </x:ExcelWorksheet>
            </x:ExcelWorksheets>
            </x:ExcelWorkbook>
            </xml><![endif]-->
            </head>';

    $data_str .= "
            <table>
            <tr>
                <th>".iconv("UTF-8", "GB2312//IGNORE","销售微信号")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","销售团队")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","销售")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","订单时间")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","加粉时间")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","是否复购")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","订单金额")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","订单商品")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","是否退补单")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","配送地址")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","配送姓名")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","配送电话")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","供应商成本")."</th>
                <th>".iconv("UTF-8", "GB2312//IGNORE","顺丰单号")."</th>                

            </tr>";
            foreach ($result as $k => $v)
            {
                #销售
                $admin = DB::table('admin')->where('id', $v['admin_id'])->first();
                $v['wx_id'] = isset($admin->wx_id) ? $admin->wx_id : '';
                #team
                $team = DB::table('teams')->where('id', $v['team_id'])->first();
                $v['team_name'] = isset($team->name) ? $team->name : '';
                #加粉时间
                $customr = DB::table('customers')->where('phone', $v['receiverMobile'])->first();
                $v['fanTime'] = isset($customr->fanTime) ? $customr->fanTime : '';

                $v['receiverMobile'] = substr($v['receiverMobile'], 0, 3).'****'.substr($v['receiverMobile'], 7);

                $fugou = $v['is_fugou']==1? '是' : '否';
                $is_refund = $v['is_refund']==1? '是' : '否';
                $address = $v['receiverState'].$v['receiverCity'].$v['receiverDistrict'].$v['receiverAddress'];
                $data_str .= "<tr>";
                $data_str .= "<td>".$v['wx_id']."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["team_name"])."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["admin_name"])."</td>";
                $data_str .= "<td>".$v['createTime']."</td>";
                $data_str .= "<td>".$v['fanTime']."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $fugou)."</td>";
                $data_str .= "<td>".$v['receivedAmount']."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["goods_note"])."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $is_refund)."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $address)."</td>";
                $data_str .= "<td>".iconv("UTF-8", "GB2312//IGNORE", $v["receiverName"])."</td>";
                $data_str .= "<td>".$v['receiverMobile']."</td>";
                $data_str .= "<td>".$v['cost']."</td>";
                $data_str .= "<td style='vnd.ms-excel.numberformat:@'>".$v["logistics_id"]."</td>";
                $data_str .= "</tr>";
            }

        $data_str .= "</table>";
        echo $data_str;
        exit;       
    }


}