baoshi-was/app/Http/Controllers/InventoryAccountController.php

<?php

namespace App\Http\Controllers;

use App\Exports\Export;
use App\InventoryAccount;
use App\InventoryAccountMission;
use App\Owner;
use App\Services\InventoryAccountService;
use Illuminate\Http\Request;
use Illuminate\Support\Facades\Gate;
use Maatwebsite\Excel\Facades\Excel;

class InventoryAccountController extends Controller
{
    public function __construct()
    {
        app()->singleton('inventoryService',InventoryAccountService::class);
    }

    //创建盘点任务
    public function createStockInventoryMission(Request $request){
        if(!Gate::allows("库存管理-盘点")){ return redirect(url('/'));  }
//        $date_start=$request->input('formData.date_start');
//        $date_end=$request->input('formData.date_end');
//        $ownerId=$request->input('formData.owner_id')[0];
        $date_start=$request->input('date_start');
        $date_end=$request->input('date_end');
        $ownerId=$request->input('owner_id');
        $inventoryAccount=app('inventoryService')->createMission($date_start,$date_end,$ownerId);
        $inventoryAccount=InventoryAccount::with('owner')->find($inventoryAccount->id);
        if (is_null($inventoryAccount)) return ['success'=>false,'data'=>'参数错误!'];
        return ['success'=>true,'data'=>$inventoryAccount];
    }
    //删除盘点任务
    public function deleteStockInventoryMission($id){
        if(!Gate::allows('库存管理-盘点')){return['success'=>0,'status'=>'没有权限'];}
        if(is_null($id)){return ['success'=>false,'data'=>'传入id为空'];}
        $inventoryAccount=InventoryAccount::where('id',$id)->delete();
        return ['success'=>true,'data'=>$inventoryAccount];
    }



    //盘点-任务页面
    public function mission(Request $request){
        if(!Gate::allows("库存管理-盘点")){ return redirect(url('/'));  }
        $paginateParams = $request->input();
        $queryParam=$request->all();
        $inventoryAccounts=app('inventoryService')->paginate($queryParam);
        $owners=Owner::select('id','name')->get();
        return view('inventory.stockInventory.mission',compact('owners','inventoryAccounts','paginateParams'));
    }
    //进入盘点中或复盘页面
    public function enterStockInventory($id){
        if (!Gate::allows('库存管理-盘点')){return redirect(url('/')); }
        if (!$id) return ['success'=>false,'data'=>'参数错误!'];
        $inventoryAccount=InventoryAccount::with('owner')->find($id);
        $inventoryAccountMissions=InventoryAccountMission::with(['commodity'=>function($query){
           return $query->with(['barcodes']);
        }])->where('inventory_account_id',$id)->orderBy('difference_amount','desc')->get();
        return view('inventory.stockInventory.inventoryMission',compact('inventoryAccount','inventoryAccountMissions'));
    }



    //依据盘点任务id进行 --盘点
    public function stockInventory(Request $request){
        if (!Gate::allows('库存管理-盘点')){return redirect(url('/')); }
        $location=$request->input('location');
        $barcode=$request->input('barcode');
        $inventoryId=$request->input('inventoryId');
        $count=$request->input('count');
        if (is_null($count)) return ['success'=>false,'data'=>'盘点数不能为空!'];
        $inventoryAccountMission=app('inventoryService')->stockInventory($location,$barcode,$count,$inventoryId);
        if (!$inventoryAccountMission)return ['success'=>false,'data'=>'参数错误!'];
        $inventoryAccount=app('inventoryService')->updateInventory($inventoryId);
        return ['success'=>true,'inventoryMission'=>$inventoryAccountMission,'inventory'=>$inventoryAccount];
    }
    //根据该库存和产品条码查询该条盘点记录
    public function searchStockInventoryRecord(Request $request){
        if (!Gate::allows('库存管理-盘点')){return redirect(url('/')); }
        $location=$request->input('location');
        $barcode=$request->input('barcode');
        $inventoryId=$request->input('inventoryId');
        $inventoryAccountMission=app('inventoryService')->searchStockInventoryRecord($location,$barcode,$inventoryId);
        if (!$inventoryAccountMission)return ['success'=>false,'data'=>'参数错误!'];
        return ['success'=>true,'data'=>$inventoryAccountMission];
    }

    //盘点任务导出
    public function stockInventoryExport(Request $request){
        if (!Gate::allows('库存管理-盘点')){return redirect(url('/')); }
        ini_set('max_execution_time',3500);
        ini_set('memory_limit','3526M');
        if ($request->checkAllSign){
            $request->offsetUnset('checkAllSign');
            $queryParam=$request->all();
            $inventoryAccounts=app('inventoryService')->get($queryParam);
        }else{
            $queryParam=$request->all();
            $inventoryAccounts=app('inventoryService')->some($queryParam);
        }
        $row=[[
            'id'=>'盘点编号',
            'created_at'=>'创建时间',
            'owner_id'=>'货主',
            'type'=>'任务类型',
            'start_at'=>'起始时间',
            'end_at'=>'结束时间',
            'total'=>'记录数',
            'processed'=>'已盘数',
            'surplus'=>'剩余数',
            'difference'=>'复盘差异',
            'returned'=>'复盘归位',
        ]];
        $list=[];
        for ($i=0; $i<count($inventoryAccounts);$i++){
            $inventoryAccount=$inventoryAccounts[$i];
            $w=[
                'id'=>isset($inventoryAccount->id)?$inventoryAccount->id:'',
                'created_at'=>isset($inventoryAccount->created_at)?$inventoryAccount->created_at:'',
                'owner_id'=>isset($inventoryAccount->owner->name)?$inventoryAccount->owner->name:'',
                'type'=>isset($inventoryAccount->type)?$inventoryAccount->type:'',
                'start_at'=>isset($inventoryAccount->start_at)?$inventoryAccount->start_at:'',
                'end_at'=>isset($inventoryAccount->end_at)?$inventoryAccount->end_at:'',
                'total'=>isset($inventoryAccount->total)?$inventoryAccount->total:'',
                'processed'=>isset($inventoryAccount->processed)?$inventoryAccount->processed:'',
                'surplus'=>isset($inventoryAccount->surplus)?$inventoryAccount->surplus:'',
                'difference'=>isset($inventoryAccount->difference)?$inventoryAccount->difference:'',
                'returned'=>isset($inventoryAccount->returned)?$inventoryAccount->returned:'',
            ];
            $list[$i]=$w;
        }
        return Excel::download(new Export($row,$list),date('YmdHis', time()).'-盘点任务记录单.xlsx');
    }
}