Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 20 |
CRAP | |
0.00% |
0 / 206 |
| RejectedController | |
0.00% |
0 / 1 |
|
0.00% |
0 / 20 |
4556.00 | |
0.00% |
0 / 206 |
| index | |
0.00% |
0 / 1 |
12.00 | |
0.00% |
0 / 13 |
|||
| recycle | |
0.00% |
0 / 1 |
12.00 | |
0.00% |
0 / 10 |
|||
| apiRecoverSelected | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 6 |
|||
| packFilterParams | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 17 |
|||
| buildFilteredQuery | |
0.00% |
0 / 1 |
506.00 | |
0.00% |
0 / 61 |
|||
| create | |
0.00% |
0 / 1 |
20.00 | |
0.00% |
0 / 9 |
|||
| store | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 6 |
|||
| ajaxCheck | |
0.00% |
0 / 1 |
12.00 | |
0.00% |
0 / 9 |
|||
| ajaxCheckAll | |
0.00% |
0 / 1 |
30.00 | |
0.00% |
0 / 15 |
|||
| ajaxFinishAll | |
0.00% |
0 / 1 |
12.00 | |
0.00% |
0 / 10 |
|||
| validatorCreate | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 4 |
|||
| validatorUpdate | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 2 |
|||
| show | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 1 |
|||
| edit | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 1 |
|||
| update | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 6 |
|||
| destroy | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 1 |
|||
| exportExcel | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 9 |
|||
| exportExcelOnFilterParams | |
0.00% |
0 / 1 |
20.00 | |
0.00% |
0 / 14 |
|||
| import | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 1 |
|||
| importExcel | |
0.00% |
0 / 1 |
20.00 | |
0.00% |
0 / 11 |
|||
| <?php | |
| namespace App\Http\Controllers; | |
| use App\Exports\RejectedExport; | |
| use App\Imports\CommodityImport; | |
| use App\Imports\RejectedImport; | |
| use App\Logistic; | |
| use App\Owner; | |
| use App\QualityLabel; | |
| use App\Rejected; | |
| use App\RejectedBill; | |
| use App\RejectedBillItem; | |
| use Carbon\Carbon; | |
| use Exception; | |
| use Illuminate\Contracts\View\Factory; | |
| use Illuminate\Http\RedirectResponse; | |
| use Illuminate\Http\Request; | |
| use Illuminate\Http\Response; | |
| use Illuminate\Support\Facades\Auth; | |
| use Illuminate\Support\Facades\Gate; | |
| use Illuminate\Support\Facades\Session; | |
| use Illuminate\Support\Facades\Validator; | |
| use Illuminate\View\View; | |
| use Maatwebsite\Excel\Facades\Excel; | |
| use function foo\func; | |
| class RejectedController extends Controller | |
| { | |
| /** | |
| * Display a listing of the resource. | |
| * | |
| * @return Factory|View|RedirectResponse | |
| */ | |
| public function index(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-查询')){ return redirect(url('/')); } | |
| $user=Auth::user(); | |
| $paginate = $request->input('paginate')??50; | |
| $paginateParams = $this->packFilterParams($request); | |
| $page =$paginateParams['page'] ?? $request->input('page') ?? 1; | |
| $paginateParams['paginate']=$paginate; | |
| $rejectedQuery=$this->buildFilteredQuery($paginateParams)->orderBy('id','desc')->whereIn('id_owner', | |
| $user?$user->getPermittingOwnerIdsAttribute():[]); | |
| $rejectedBills=$rejectedQuery->paginate($paginate, ['*'], 'page', $page); | |
| $owners = Owner::filterAuthorities()->get(); | |
| $qualityLabels = QualityLabel::all(); | |
| return view('rejected.index',compact('rejectedBills','owners', | |
| 'paginateParams','qualityLabels')); | |
| } | |
| public function recycle(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-删除')){ return redirect(url('/')); } | |
| $user=Auth::user(); | |
| $paginate = $request->input('paginate')??50; | |
| $paginateParams = $this->packFilterParams($request); | |
| $paginateParams['paginate']=$paginate; | |
| $rejectedQuery=$this->buildFilteredQuery($paginateParams)->orderBy('id','desc')->whereIn('id_owner', | |
| $user?$user->getPermittingOwnerIdsAttribute():[])->withTrashed()->whereNotNull('deleted_at'); | |
| $total = $rejectedQuery->count(); | |
| $rejectedBills=$rejectedQuery->paginate($paginate); | |
| return view('rejected.recycle',compact('rejectedBills','total','paginateParams')); | |
| } | |
| public function apiRecoverSelected(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-删除')){ return ['success'=>'false','fail_info'=>"没有权限"]; } | |
| $ids=$request->input('ids')??''; | |
| $rejecteds=RejectedBill::withTrashed()->whereIn('id',$ids)->get(); | |
| $rejecteds->each(function(RejectedBill $rejected){ | |
| $rejected->restore(); | |
| }); | |
| return ['success'=>'true','rejecteds'=>$rejecteds]; | |
| } | |
| private function packFilterParams(Request $request){ | |
| $paginateParams=[ | |
| 'page'=> $request->input('page'), | |
| 'created_at_start'=> $request->input('created_at_start'), | |
| 'created_at_end'=> $request->input('created_at_end'), | |
| 'owner_id'=> $request->input('owner_id'), | |
| 'id_quality_label'=> $request->input('id_quality_label'), | |
| 'is_checked'=> $request->input('is_checked'), | |
| 'is_loaded'=> $request->input('is_loaded'), | |
| 'mobile_sender'=> $request->input('mobile_sender'), | |
| 'checked_numbers'=> $request->input('checked_numbers'), | |
| 'order_number'=> $request->input('order_number'), | |
| 'barcode_goods'=> $request->input('barcode_goods'), | |
| 'logistic_number_return'=> $request->input('logistic_number_return'), | |
| ]; | |
| if(Session::get('rejected.index.isFromEditPage')){ | |
| $paginateParams=json_decode(Session::get('rejected.index.filterParams'),true); | |
| Session::forget('rejected.index.isFromEditPage'); | |
| Session::forget('rejected.index.filterParams'); | |
| } | |
| return $paginateParams; | |
| } | |
| private function buildFilteredQuery(Array $params){ | |
| $created_at_start = $params['created_at_start']; | |
| $created_at_end = $params['created_at_end']; | |
| $owner_id = $params['owner_id']; | |
| $id_quality_label = $params['id_quality_label']; | |
| $is_checked = $params['is_checked']; | |
| $is_loaded = $params['is_loaded']; | |
| $mobile_sender = $params['mobile_sender']; | |
| $checked_numbers = $params['checked_numbers']; | |
| $order_number = $params['order_number']; | |
| $barcode_goods = $params['barcode_goods']; | |
| $logistic_number_return = $params['logistic_number_return']; | |
| $rejectedBillsQuery=RejectedBill::with(['owner','logistic','items',]); | |
| if($created_at_start&&!$created_at_end){ | |
| $created_at_end = $created_at_start; | |
| } | |
| if(!$created_at_start&&$created_at_end){ | |
| $created_at_start = $created_at_end; | |
| } | |
| if($created_at_end){ | |
| $created_at_end.=' 23:59:59'; | |
| } | |
| if($created_at_start&&$created_at_end){ | |
| if($created_at_start==$created_at_end){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('created_at','like',$created_at_start.'%'); | |
| }else | |
| $rejectedBillsQuery=$rejectedBillsQuery->whereBetween('created_at',[$created_at_start,$created_at_end]); | |
| } | |
| if($owner_id){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('id_owner',$owner_id); | |
| } | |
| if($id_quality_label!=''){ | |
| if($id_quality_label==1){ | |
| $rejectedBillsQuery->whereDoesntHave('items',function ($query){ | |
| $query->where('id_quality_label',2); | |
| }); | |
| }else{ | |
| $rejectedBillsQuery->whereHas('items',function ($query){ | |
| $query->where('id_quality_label',2); | |
| }); | |
| } | |
| } | |
| if($is_checked!=''){ | |
| $orderSign = false; | |
| if($is_checked){ | |
| $orderSign = true; | |
| } | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('is_checked', $orderSign); | |
| } | |
| if($is_loaded!=''){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('is_loaded', $is_loaded); | |
| } | |
| if($mobile_sender!=''){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('mobile_sender', trim($mobile_sender)); | |
| } | |
| if($checked_numbers!=''){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('checked_numbers','like', trim($checked_numbers).'%'); | |
| } | |
| if($barcode_goods!=''){ | |
| $rejectedBillsQuery->whereHas('items',function ($query)use($barcode_goods){ | |
| $query->where('barcode_goods','like',trim($barcode_goods).'%'); | |
| }); | |
| } | |
| if($order_number){ | |
| $today = Carbon::now()->subDays(15); | |
| $rejectedBillsQueryTem=clone $rejectedBillsQuery; | |
| $rejectedBillsQueryTem=$rejectedBillsQueryTem->where('created_at','>',$today->format('Y-m-d')); | |
| $rejectedBillsQueryTem=$rejectedBillsQueryTem->where('order_number','like','%'.$order_number.'%'); | |
| if($rejectedBillsQueryTem->count()==0){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('order_number','like','%'.$order_number.'%'); | |
| }else{ | |
| $rejectedBillsQuery=$rejectedBillsQueryTem; | |
| } | |
| } | |
| if($logistic_number_return){ | |
| $today = Carbon::now()->subDays(15); | |
| $rejectedBillsQueryTem=clone $rejectedBillsQuery; | |
| $rejectedBillsQueryTem=$rejectedBillsQueryTem->where('created_at','>',$today->format('Y-m-d')); | |
| $rejectedBillsQueryTem=$rejectedBillsQueryTem->where('logistic_number_return','like','%'.$logistic_number_return.'%'); | |
| if($rejectedBillsQueryTem->count()==0){ | |
| $rejectedBillsQuery=$rejectedBillsQuery->where('logistic_number_return','like','%'.$logistic_number_return.'%'); | |
| }else{ | |
| $rejectedBillsQuery=$rejectedBillsQueryTem; | |
| } | |
| } | |
| return $rejectedBillsQuery; | |
| } | |
| /** | |
| * Show the form for creating a new resource. | |
| * | |
| * @return Response | |
| */ | |
| public function create() | |
| { | |
| if(!Gate::allows('退货管理-录入')){ return redirect(url('/'));} | |
| $user=Auth::user(); | |
| $owners=Owner::all()->whereIn('id', | |
| $user?$user->getPermittingOwnerIdsAttribute():[])->sortBy('name'); | |
| $logistics=Logistic::all()->sortBy('name'); | |
| $qualityLabels=QualityLabel::all()->sortBy('name'); | |
| $rejectedBills = RejectedBill::query()->orderByDesc('id')->whereIn('id_owner', | |
| $user?$user->getPermittingOwnerIdsAttribute():[])->limit(20)->get(); | |
| return view('rejected.create',compact('owners','logistics','qualityLabels','rejectedBills')); | |
| } | |
| /** | |
| * Store a newly created resource in storage. | |
| * | |
| * @param Request $request | |
| * @return Response | |
| */ | |
| public function store(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-录入')){ return redirect(url('/')); } | |
| $this->validatorCreate($request->all())->validate(); | |
| $rejected=new Rejected($request->all()); | |
| $rejected->save(); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return redirect('rejected/create')->with('successTip',"成功录入退货信息（退单：{$request->input('logistic_number_return')}）"); | |
| } | |
| public function ajaxCheck(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-审核')){ return ['success'=>'false','fail_info'=>"没有权限"]; } | |
| $rejected=RejectedBill::find($request->input('id')??''); | |
| $rejected['is_checked']=true; | |
| $rejected->makeCheckedNumbers(); | |
| $re=$rejected->update(); | |
| if ($re){ | |
| return ['success'=>'true','checked_numbers'=>$rejected['checked_numbers']]; | |
| } | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return ['success'=>'false','fail_info'=>'数据更新失败']; | |
| } | |
| public function ajaxCheckAll(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-审核')){ return ['success'=>'false','fail_info'=>"没有权限"]; } | |
| $ids=$request->input('ids')??''; | |
| $rejecteds=RejectedBill::whereIn('id',$ids)->get(); | |
| $checkNumbersArr=[]; | |
| $rejecteds->each(function($rejected)use(&$checkNumbersArr){ | |
| if($rejected['is_checked'])return true; | |
| $rejected['is_checked']=true; | |
| if(isset($checkNumbersArr[$rejected->owner->id])){ | |
| $rejected['checked_numbers']=$checkNumbersArr[$rejected->owner->id]; | |
| }else{ | |
| $checkNumbersArr[$rejected->owner->id]=$rejected->makeCheckedNumbers(); | |
| } | |
| $re=$rejected->update(); | |
| if (!$re){ | |
| return ['success'=>'false','fail_info'=>"数据 {$rejected['id']} 更新失败"]; | |
| } | |
| }); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return ['success'=>'true','rejecteds'=>$rejecteds]; | |
| } | |
| public function ajaxFinishAll(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-编辑')){return ['success'=>'false','fail_info'=>"没有权限"]; } | |
| $ids=$request->input('ids')??''; | |
| $rejecteds=RejectedBill::whereIn('id',$ids)->get(); | |
| $rejecteds->each(function($rejected){ | |
| $rejected['is_finished']=true; | |
| $re=$rejected->update(); | |
| if (!$re){ | |
| return ['success'=>'false','fail_info'=>"数据 {$rejected['id']} 更新失败"]; | |
| } | |
| }); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return ['success'=>'true']; | |
| } | |
| protected function validatorCreate(array $data) | |
| { | |
| return Validator::make($data, [ | |
| 'id_owner' => ['required', 'numeric', 'exists:owners,id'], | |
| 'order_number' => ['nullable', 'string','max:60'], | |
| 'sender' => ['nullable', 'max:50'], | |
| 'mobile_sender' => ['nullable', 'max:20'], | |
| 'logistic_number' => ['nullable', 'max:60'], | |
| 'logistic_number_return' => ['required','string', 'max:60'], | |
| 'id_logistic_return' => ['required', 'numeric', 'exists:logistics,id'], | |
| 'fee_collected' => ['nullable','numeric'], | |
| 'is_loaded' => ['required','boolean'], | |
| 'barcode_goods' => ['nullable','string', 'max:60'], | |
| 'name_goods' => ['nullable','string', 'max:50'], | |
| 'amount' => ['required','numeric'], | |
| 'id_quality_label' => ['required', 'numeric', 'exists:quality_labels,id'], | |
| 'batch_number' => ['nullable', 'string', 'max:60'], | |
| 'validity_at' => ['nullable', 'date'], | |
| 'remark' => ['nullable', 'string', 'max:60'], | |
| ],[],[ | |
| ]); | |
| } | |
| protected function validatorUpdate(array $data) | |
| { | |
| return Validator::make($data, [ | |
| // 'name' => ['required', 'string', 'max:50'], | |
| ]); | |
| } | |
| /** | |
| * Display the specified resource. | |
| * | |
| * @param Rejected $rejected | |
| * @return void | |
| */ | |
| public function show(Rejected $rejected) | |
| { | |
| // | |
| } | |
| /** | |
| * Show the form for editing the specified resource. | |
| * | |
| * @param Rejected $rejected | |
| * @return Response | |
| */ | |
| public function edit(RejectedBill $rejectedBill) | |
| { | |
| } | |
| /** | |
| * Update the specified resource in storage. | |
| * | |
| * @param Request $request | |
| * @param Rejected $rejected | |
| * @return Response | |
| */ | |
| public function update(Request $request, Rejected $rejected) | |
| { | |
| if(!Gate::allows('退货管理-编辑')){ return redirect(url('/')); } | |
| $this->validatorUpdate($request->all())->validate(); | |
| $rejected->fill($request->all()); | |
| $rejected->update(); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return redirect('rejected/')->with('successTip',"成功修改退货信息“{$rejected['name']}”！"); | |
| } | |
| /** | |
| * Remove the specified resource from storage. | |
| * | |
| * @param Rejected $rejected | |
| * @return array|Response | |
| * @throws Exception | |
| */ | |
| public function destroy(Rejected $rejected) | |
| { | |
| // if(!Gate::allows('退货管理-删除')){ return redirect(url('/'));} | |
| // $this->log(__METHOD__,__FUNCTION__,$rejectedBill->toJson(),Auth::user()['id']); | |
| // $items=$rejectedBill->items(); | |
| // $items->delete(); | |
| // $this->log(__METHOD__,__FUNCTION__,$items->toJson(),Auth::user()['id']); | |
| // $re=$rejectedBill->delete(); | |
| // return ['success'=>$re]; | |
| } | |
| public function exportExcel(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-查询')){ return '没有权限'; } | |
| ini_set('max_execution_time',2100); | |
| ini_set('memory_limit','512M'); | |
| $ids=$request->input('ids')??''; | |
| $ids=json_decode($ids,true); | |
| $export=new RejectedExport(); | |
| $export->setIds($ids); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return Excel::download($export,'退货表'.Carbon::now().'.xlsx'); | |
| } | |
| public function exportExcelOnFilterParams(Request $request) | |
| { | |
| if(!Gate::allows('退货管理-查询')){ return '没有权限'; } | |
| ini_set('max_execution_time',2100); | |
| ini_set('memory_limit','512M'); | |
| $filterParams=json_decode($request->input('filterParams'),true); | |
| $user=Auth::user(); | |
| $rejectedBills=$this->buildFilteredQuery($filterParams)->orderBy('id','desc')->whereIn('id_owner', | |
| $user?$user->getPermittingOwnerIdsAttribute():[]); | |
| if($rejectedBills->count()>RejectedExport::$max){ | |
| $rejectedBills->where('is_finished',false); | |
| } | |
| $rejectedBills->get(); | |
| $export=new RejectedExport(); | |
| $export->setRejectedBills($rejectedBills); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return Excel::download($export,'退货表'.Carbon::now().'.xlsx'); | |
| } | |
| public function import(Request $request) | |
| { | |
| return view('rejected.import'); | |
| } | |
| public function importExcel(Request $request) | |
| { | |
| $isOverride = $request->input('isOverride'); | |
| try{ | |
| ini_set('max_execution_time',2100); | |
| ini_set('memory_limit','512M'); | |
| $extension=$request->file()['file']->getClientOriginalExtension(); | |
| $extension[0] = strtoupper($extension[0]); | |
| Excel::import(new RejectedImport(), $request->file()['file']->path(),null,$extension); | |
| return '<h1 class="text-success">导入成功</h1>'; | |
| }catch (Exception $e){ | |
| if(strstr($e->getMessage(),'No ReaderType')){return '<h1 class="text-danger">没有上传写权限，请修改php.ini 对应的upload_tmp_dir 目录或其权限</h1>'.$e->getMessage();} | |
| if(strstr($e->getMessage(),'SQLSTATE')){return '<h1 class="text-danger">数据库插入错误，数据不支持，可能有重复或异常字符</h1>'.$e->getMessage();} | |
| return '<h1 class="text-danger">失败</h1>'.$e->getMessage(); | |
| } | |
| } | |
| } |