WebController.php

<?php

namespace App\Http\Controllers;

use App\Http\Page;
use App\Map\PcbOrderInvoiceMap;
use App\Map\PcbOrderMap;
use App\Map\PcbOrderShippingMap;
use App\Map\PcbPurchaseMap;
use App\Model\Bom\BomItemMatchModel;
use App\Model\Bom\BomItemModel;
use App\Model\Bom\BomModel;
use App\Model\Bom\BomOrderModel;
use App\Model\PaymentDaysModel;
use App\Model\Pcb\PcbOrderModel;
use App\Model\Pcb\PcbPublicModel;
use App\Model\Pcb\PcbPurchaseModel;
use Illuminate\Http\Request;

use App\Http\Requests;
use App\Http\Controllers\Controller;
use App\Http\Controllers\PermController;
use DB;
use App\Model\UserMainModel;
use App\Model\UserInfoModel;
use App\Model\UserCompanyModel;
use App\Model\OrderModel;
use App\Model\OrderServiceModel;
use App\Model\OrderServiceItemsModel;
use App\Model\OrderServiceLogModel;
use App\Model\OrderExtendModel;
use App\Model\PayLogModel;
use App\Model\OrderInvoiceModel;

class WebController extends Controller
{
    // 页面用户、菜单信息
    public function getPageInfo(Request $request)
    {
        $uri = '/' . $request->path();

        $username = $request->user->email;
        $useremail= $request->user->email;

        // 菜单
        $menuconfig = DB::table('config')->where('config_title', '订单系统')->first();
        $menus = [];
        if ($menuconfig && !($menus = json_decode($menuconfig->config_data)))
            $menus = [];

        $perm = new PermController();

        // 用户角色
        $role = $perm->getUserRole($request);

        // 获取权限菜单
        if ($role != 1) {
            $menus = $perm->getPermMenu($menus, $request->user->userId);   
        }

        $userPerms = $perm->getUserAllPerms($request->user->userId, $role); // 用户权限

        $data = [
            'header'    => $request->user->header,
            'uri'       => $uri,
            'username'  => $username,
            'useremail' => $useremail,
            'menus'     => $menus,
            'userPerms' => $userPerms,
        ];

        return $data;
    }

    public function info(Request $request,$id=''){
        $data=$this->getPageInfo($request);
        $data['id']=$id;
        return $this->$id($request, $data, $id);
    }

    private function PaymentDaysList($request,$data,$id){
        $data['title']='账期申请列表';
        $data['Status']=[1=>'待审核',2=>'审核通过',3=>'审核不通过'];
        return view('PaymentDays',$data);
    }

    private function AuthPaymentDays($request,$data,$id){
        $data['title']='审核账期申请';
        $data['Status']=[1=>'待审核',2=>'审核通过',3=>'审核不通过'];
        $data['paths'] = [["title" => '账期管理', "href" => '#'], ["title" => '申请列表', "href" => '/web/PaymentDaysList'], ["title" => '审核账期申请', "href" => '#']];
        $Model=new PaymentDaysModel();
        $data['info']=$Model->AuthPaymentDays();
        return view('PaymentDays',$data);
    }
    //pcb 订单列表
    private function PcbOrderList($request,$data,$id){
        $data['title']='PCB交易列表';
        $data['order_type'] = PcbOrderMap::$order_type;
        $data['status'] = PcbOrderMap::$status;
        $data['shipping'] = objectToArray(DB::connection("order")->table("lie_shipping")->get());
        //分页
        $response = (new PcbOrderModel())->getList();
        $page = new Page($response[3], 10);
        $page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%');
        $show = $page->show();
        $data['list'] = $response[2];
        $data['page'] = $show;

        return view("Pcb",$data);
    }
    //pcb详情
    private function PcbOrderDetail($request,$data,$id){
        $data['title']='PCB订单详情';
        $data['paths'] = [["title" => 'PCB管理', "href" => '#'], ["title" => 'PCB订单列表', "href" => '/web/PcbOrderList'], ["title" => 'PCB订单详情', "href" => '#']];
        $order_id = $request->input("order_id");
        $con = DB::connection('pcb');
        //订单基本信息
        $orderBase = $con->table('order')->where(['order_id' => $order_id])->first();
        if (!$orderBase){
            return [0,'不存在此订单'];
        }
        //采购信息
        $purchase = $con->table('purchase')->where(['order_id' => $order_id])->first();
        //订单收货人信息
        $orderAddress = $con->table('order_address')->where(['order_id' => $order_id])->first();
        //订单费用明细
        $orderAuditDetail = $con->table('order_audit_detail')->where(['order_id' => $order_id])->first();
        //采购审核意见备注
        $orderAuditReason2 = $con->table('order_audit_reason')->where(['order_id' => $order_id,'type'=>2,'status'=>1])->orderBy("id","desc")->first();
        $orderAuditReason1 = $con->table('order_audit_reason')->where(['order_id' => $order_id,'type'=>1,'status'=>1])->orderBy("id","desc")->first();

        //订单详细信息
        $orderInfo = $con->table('order_info')->where(['order_id' => $order_id])->first();
        //订单发票信息
        $orderInvoice = $con->table('order_invoice')->where(['order_id' => $order_id])->first();
        //物流信息
        $shipping = $con->table('shipping')->where(['relevance_id' => $order_id,'shipping_type'=>1])->first();
        //查询操作日志
        $actionLog = $con->table("action_log")->where(["type"=>1,'oid'=>$order_id])->orderBy("id","desc")->get();

        $orderBase =  objectToArray($orderBase);
        $orderBase['tiaojia'] = "";
        //拼接采购信息
        if ($purchase){
            $purchase= objectToArray($purchase);
            if($purchase['purchase_amount'] == 0){
                $orderBase['tiaojia'] = "";
            }else{
                if ( $purchase['purchase_amount'] > 0  &&  $purchase['purchase_amount'] != $purchase['order_amount']){
                    $orderBase['tiaojia'] = "是";
                }else{
                    $orderBase['tiaojia'] = "否";
                }
            }
            $purchase['shipping_time'] = $purchase['shipping_time'] > 0 ? date('Y-m-d H:i:s',$purchase['shipping_time']) : "";
            $purchase['finish_time'] = $purchase['finish_time'] > 0 ? date('Y-m-d H:i:s',$purchase['finish_time']) : "";
            $purchase['purchase_amount'] = $purchase['purchase_amount'] > 0 ? $purchase['purchase_amount'] : "";
        }
        //拼接基本信息
        $PcbPublicModel = new PcbPublicModel();
        $orderBase['order_pay_type'] = $PcbPublicModel->getPay($order_id);
        $orderBase['order_type'] = PcbOrderMap::$order_type[$orderBase['order_type']];
        $orderBase['status_name'] = PcbOrderMap::$status[$orderBase['status']];
        $orderBase['create_time'] = $orderBase['create_time'] > 0 ? date('Y-m-d H:i:s',$orderBase['create_time']) : "";
        $orderBase['finish_time'] = $orderBase['finish_time'] > 0 ? date('Y-m-d H:i:s',$orderBase['finish_time']) : "";
        $orderBase['pay_time'] = $orderBase['pay_time'] > 0 ? date('Y-m-d H:i:s',$orderBase['pay_time']) : "";
        $userCompany = DB::connection('order')->table("lie_user_company")->where("user_id",$orderBase['user_id'])->first();
        $orderBase['company_name'] = $userCompany ? $userCompany->com_name : "" ;
        //拼接收货信息
        $RegionController = new RegionController();
        if ($orderAddress){
            $orderAddress =  objectToArray($orderAddress);
            $orderAddress['province'] = $RegionController->getRegionName($orderAddress['province']);
            $orderAddress['city'] = $RegionController->getRegionName($orderAddress['city']);
            $orderAddress['district'] = $RegionController->getRegionName($orderAddress['district']);
        }
        //拼接发票信息
        if ($orderInvoice){
            $orderInvoice =  objectToArray($orderInvoice);
            $orderInvoice['province'] = $RegionController->getRegionName($orderInvoice['consignee_province']);
            $orderInvoice['city'] = $RegionController->getRegionName($orderInvoice['consignee_city']);
            $orderInvoice['district'] = $RegionController->getRegionName($orderInvoice['consignee_district']);
            $orderInvoice['inv_type'] = PcbOrderInvoiceMap::$inv_type[$orderInvoice['inv_type']];
            $orderInvoice['invoice_status'] = PcbOrderInvoiceMap::$invoice_status[$orderInvoice['invoice_status']];
        }
        //拼接订单详细信息
        $orderInfo = objectToArray($orderInfo);
        $orderInfo['teshu'] = "是否有半孔工艺:".($orderInfo['sp_half_hole'] == 1 ? "是":"否")." 是否要金手指:".($orderInfo['sp_goldfingers'] == 1 ? "是":"否").$orderInfo['sp_goldfingers_bevelling'].$orderInfo['sp_UL_marking']; //特殊工艺

        $data['orderBase'] = $orderBase;
        $data['purchase'] = $purchase;
        $data['orderAddress'] = $orderAddress;
        $data['orderAuditDetail'] = objectToArray($orderAuditDetail);
        $data['orderAuditReason1'] = objectToArray($orderAuditReason1);
        $data['orderAuditReason2'] = objectToArray($orderAuditReason2);
        $data['orderInfo'] = objectToArray($orderInfo);
        $data['orderInvoice'] = $orderInvoice;
        $data['shipping'] = objectToArray($shipping);
        $data['actionLog'] = objectToArray($actionLog);

        return view("Pcb",$data);
    }
    //pcb 采购列表
    private function PcbPurchaseList($request,$data,$id){
        $data['title']='PCB交易列表';
        $data['order_type'] = PcbOrderMap::$order_type;
        $data['status'] = PcbPurchaseMap::$status;
        //分页
        $response = (new PcbPurchaseModel())->getList();
        $page = new Page($response[3], 10);
        $page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%');
        $show = $page->show();
        $data['list'] = $response[2];
        $data['page'] = $show;

        return view("Pcb",$data);
    }
    //pcb详情
    private function PcbPurchaseDetail($request,$data,$id){
        $data['title']='PCB采购详情';
        $data['paths'] = [["title" => 'PCB管理', "href" => '#'], ["title" => 'PCB采购列表', "href" => '/web/PcbPurchaseList'], ["title" => 'PCB采购详情', "href" => '#']];

        $purchase_id = $request->input("purchase_id");
        $order_id = $request->input("order_id");

        $con = DB::connection('pcb');
        //订单基本信息
        $orderBase = $con->table('order')->where(['order_id' => $order_id])->first();
        if (!$orderBase){
            return [0,'不存在此采购单'];
        }
        //采购信息
        $purchase = $con->table('purchase')->where(['order_id' => $order_id])->first();
        //采购费用明细
        $purchaseAuditDetail = $con->table('purchase_audit_detail')->where(['purchase_id' => $purchase_id])->first();
        //订单详细信息
        $orderInfo = $con->table('order_info')->where(['order_id' => $order_id])->first();
        //订单发票信息
        $orderInvoice = $con->table('order_invoice')->where(['order_id' => $order_id])->first();
        //物流信息
        $shipping = $con->table('shipping')->where(['relevance_id' => $purchase_id,'shipping_type'=>3])->first();
        //供应商审核结果
        $orderAuditReason2 = $con->table('order_audit_reason')->where(['order_id' => $order_id,'type'=>2,'status'=>1])->orderBy("id","desc")->first();
        //查询操作日志
        $actionLog = $con->table("action_log")->where(["type"=>1,'oid'=>$order_id])->orderBy("id","desc")->get();

        //拼接基本信息
        $orderBase =  objectToArray($orderBase);
        $orderBase['order_type'] = PcbOrderMap::$order_type[$orderBase['order_type']];
        $orderBase['create_time'] = $orderBase['create_time'] > 0 ? date('Y-m-d H:i:s',$orderBase['create_time']) : "";
        $orderBase['finish_time'] = $orderBase['finish_time'] > 0 ? date('Y-m-d H:i:s',$orderBase['finish_time']) : "";
        $orderBase['pay_time'] = $orderBase['pay_time'] > 0 ? date('Y-m-d H:i:s',$orderBase['pay_time']) : "";
        $userCompany = DB::connection('order')->table("lie_user_company")->where("user_id",$orderBase['user_id'])->first();
        $orderBase['company_name'] = $userCompany ? $userCompany->com_name : "" ;

        //拼接采购信息
        if ($purchase){
            $purchase =  objectToArray($purchase);
            $purchase['shipping_time'] = $purchase['shipping_time'] > 0 ? date('Y-m-d H:i:s',$purchase['shipping_time']) : "";
            $purchase['purchase_amount'] = $purchase['purchase_amount'] > 0 ? $purchase['purchase_amount'] : "";
            $purchase['pay_time'] = $purchase['pay_time'] > 0 ? date('Y-m-d H:i:s',$purchase['pay_time']): "";
            $purchase['order_pay_type'] = PcbOrderMap::$order_pay_type[$purchase['order_pay_type']];
            $purchase['status_name'] = @PcbPurchaseMap::$status[$purchase['status']];
            if($purchase['purchase_amount'] == 0){
                $orderBase['tiaojia'] = "";
            }else{
                if ( $purchase['purchase_amount'] > 0  &&  $purchase['purchase_amount'] != $purchase['order_amount']){
                    $orderBase['tiaojia'] = "是";
                }else{
                    $orderBase['tiaojia'] = "否";
                }
            }
        }
        //拼接订单详细信息
        $orderInfo = objectToArray($orderInfo);
        $orderInfo['teshu'] = "是否有半孔工艺:".($orderInfo['sp_half_hole'] == 1 ? "是":"否")." 是否要金手指:".($orderInfo['sp_goldfingers'] == 1 ? "是":"否").$orderInfo['sp_goldfingers_bevelling'].$orderInfo['sp_UL_marking']; //特殊工艺

        $data['orderBase'] = $orderBase;
        $data['purchase'] = $purchase;
        $data['liexinInfo'] = config("params.liexin_info");
        $data['purchaseAuditDetail'] = objectToArray($purchaseAuditDetail);
        $data['orderAuditReason2'] = objectToArray($orderAuditReason2);
        $data['orderInfo'] = objectToArray($orderInfo);
        $data['orderInvoice'] = $orderInvoice;
        $data['shipping'] = objectToArray($shipping);
        $data['actionLog'] = objectToArray($actionLog);

        return view("Pcb",$data);
    }

    // 订单客服池
    public function kefu($request, $data, $id)
    {
        $data['title'] = '客服池';
        return view('web', $data);
    }

    // 自营样片领取列表
    public function selfSampleList($request, $data, $id)
    {
        $data['title'] = '邀约领取样片';
        return view('web', $data);
    }

    // 自营样片领取和邀约记录
    public function selfSampleLog($request, $data, $id)
    {
        $user_id = $request->input('user_id', 0);

        if (!$user_id) return redirect('/web/selfSampleList');

        $data['title']   = '领取和邀约记录';
        $data['paths']   = [["title" => '样片管理', "href" => '#'], ["title" => '邀约领取样片', "href" => '/web/selfSampleList'], ["title" => '领取和邀约记录', "href" => '#']]; 
        $data['user_id'] = $user_id;

        $UserMainModel = new UserMainModel;
        $UserInfoModel = new UserInfoModel;
        $UserCompanyModel = new UserCompanyModel;

        $data['user_info']    = $UserMainModel->find($user_id);
        $data['work_card']    = $UserInfoModel->where('user_id', $user_id)->value('work_card');
        $data['company_info'] = $UserCompanyModel->getCompanyInfo($user_id);

        return view('web', $data);
    }

    // 国产替代样片领取列表
    public function domesticSampleList($request, $data, $id)
    {
        $data['title'] = '国产替代样片';
        return view('web', $data);
    }

    // 团购列表
    public function groupList($request, $data, $id)
    {
        $data['title'] = '团购列表';
        return view('web', $data);
    }

    // 品牌黑名单
    public function brandBlackList($request, $data, $id)
    {
        $data['title'] = '黑名单列表';
        return view('web', $data);
    }

    // bom列表
    public function BomList($request, $data, $id)
    {
        $data['title'] = 'BOM单列表';

        return view('web', $data);
    }

    // bom列表
    public function BomView($request, $data, $id)
    {
        $data['title'] = 'BOM单详情';
        $data["bom_id"] = $request->input("bom_id",0);
        $bomInfo = BomModel::where(["bom_id"=>intval($data["bom_id"])])->first();
        $bomInfo->add_order_amount = BomOrderModel::where(["bom_id"=>$bomInfo->bom_id])->sum("add_order_amount");
        $bomInfo->matchingOrderAmount = BomItemMatchModel::getBomitemMatchingAmount($bomInfo->bom_id);
        $bomInfo->bomItemsCount = BomItemModel::getBomItemsCount($data["bom_id"]);
        $bomInfo->getBomitemMatchingSucCount = BomItemMatchModel::getBomitemMatchingSucCount($bomInfo->bom_id);
        $data["bomInfo"] = $bomInfo;
        return view('web', $data);
    }

    // bom报表
    public function BomReport($request, $data, $id)
    {
        $data['title'] = 'BOM报表';

        return view('web', $data);
    }

    //bom源文件管理
    public function BomUploadFile($request, $data, $id)
    {
        $data['title'] = 'bom源文件管理';

        return view('web', $data);
    }

    // 售后单列表
    public function orderServiceList($request, $data, $id)
    {
        $data['title'] = '售后单列表';

        $perm = new PermController; 
        $data['sale_list'] = $perm->getUserByDepartmentId(Config('perm_args.sales_department_id')); // 获取所有的销售
        // $data['role']      = $perm->getUserRole($request);

        return view('web', $data);
    }

    // 售后单详情
    public function orderServiceDetails($request, $data, $id)
    {
        $service_id = $request->input('id', 0);

        if (!$service_id) return redirect('/web/orderServiceList');

        $data['title'] = '售后单详情';
        
        $OrderModel             = new OrderModel;
        $OrderServiceModel      = new OrderServiceModel;
        $OrderServiceItemsModel = new OrderServiceItemsModel;
        $OrderServiceLogModel   = new OrderServiceLogModel;
 
        $order_service = $OrderServiceModel->find($service_id);
        $data['service_amount'] = $OrderServiceItemsModel->getServiceAmount($service_id); // 售后金额
        
        $currency = $OrderModel->where('order_id', $order_service['order_id'])->value('currency');
        $data['currency_sign'] = $currency == 1 ? '￥' : '$';

        // 用户账号
        $UserMainModel = new UserMainModel;
        $user = $UserMainModel->getUserAccount($order_service->user_id);
        $order_service->user_account = $user->mobile ? $user->mobile : $user->email;

        // ERP单号
        $OrderExtendModel = new OrderExtendModel;
        $order_service->erp_sn = $OrderExtendModel->where('order_id', $order_service->order_id)->value('erp_sn');

        $data['order_service']     = $order_service;
        $data['order_service_log'] = $OrderServiceLogModel->where('service_id', $service_id)->orderBy('id', 'desc')->get();

        // 获取收款信息
        $PayLogModel = new PayLogModel;
        $data['pay_log'] = $PayLogModel->where('order_id', $order_service->order_id)->orderBy('pay_log_id', 'desc')->get();

        // 订单发票信息
        $OrderInvoiceModel = new OrderInvoiceModel;
        $data['order_invoice'] = $OrderInvoiceModel->where('order_id', $order_service->order_id)->first();

        return view('web', $data);
    }


}