Code Coverage |
||||||||||
Classes and Traits |
Functions and Methods |
Lines |
||||||||
| Total | |
0.00% |
0 / 1 |
|
0.00% |
0 / 12 |
CRAP | |
0.00% |
0 / 50 |
| CommodityController | |
0.00% |
0 / 1 |
|
0.00% |
0 / 12 |
812.00 | |
0.00% |
0 / 50 |
| index | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 3 |
|||
| create | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 2 |
|||
| store | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 6 |
|||
| validatorCreate | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 2 |
|||
| 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 |
6.00 | |
0.00% |
0 / 2 |
|||
| update | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 6 |
|||
| destroy | |
0.00% |
0 / 1 |
6.00 | |
0.00% |
0 / 4 |
|||
| import | |
0.00% |
0 / 1 |
2.00 | |
0.00% |
0 / 1 |
|||
| importExcel | |
0.00% |
0 / 1 |
72.00 | |
0.00% |
0 / 15 |
|||
| apiGetCommodityByBarcode | |
0.00% |
0 / 1 |
20.00 | |
0.00% |
0 / 6 |
|||
| <?php | |
| namespace App\Http\Controllers; | |
| use App\Commodity; | |
| use App\Imports\CommodityImport; | |
| use Exception; | |
| use Illuminate\Http\Request; | |
| use Illuminate\Http\Response; | |
| use Illuminate\Support\Facades\Auth; | |
| use Illuminate\Support\Facades\Gate; | |
| use Illuminate\Support\Facades\Validator; | |
| use Maatwebsite\Excel\Facades\Excel; | |
| class CommodityController extends Controller | |
| { | |
| /** | |
| * Display a listing of the resource. | |
| * | |
| * @return Response | |
| */ | |
| public function index() | |
| { | |
| if(!Gate::allows('商品信息-查询')){ return redirect(url('/')); } | |
| $commodities=Commodity::orderBy('id','desc')->paginate(50); | |
| return view('maintenance.commodity.index',['commodities'=>$commodities]); | |
| } | |
| /** | |
| * Show the form for creating a new resource. | |
| * | |
| * @return Response | |
| */ | |
| public function create() | |
| { | |
| if(!Gate::allows('商品信息-录入')){ return redirect(url('/')); } | |
| return view('maintenance.commodity.create'); | |
| } | |
| /** | |
| * 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(); | |
| $commodity=new Commodity($request->all()); | |
| $commodity->save(); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return redirect('maintenance/commodity/create')->with('successTip',"成功录入商品信息：“{$request->input('name')}”"); | |
| } | |
| protected function validatorCreate(array $data) | |
| { | |
| return Validator::make($data, [ | |
| 'name' => ['required', 'string', 'max:50'], | |
| 'barcode' => ['required', 'string', 'max:50', 'unique:commodities'], | |
| ]); | |
| } | |
| protected function validatorUpdate(array $data) | |
| { | |
| return Validator::make($data, [ | |
| 'name' => ['required', 'string', 'max:50'], | |
| 'barcode' => ['required', 'string', 'max:50'], | |
| ]); | |
| } | |
| /** | |
| * Display the specified resource. | |
| * | |
| * @param Commodity $commodity | |
| * @return Response | |
| */ | |
| public function show(Commodity $commodity) | |
| { | |
| // | |
| } | |
| /** | |
| * Show the form for editing the specified resource. | |
| * | |
| * @param Commodity $commodity | |
| * @return Response | |
| */ | |
| public function edit(Commodity $commodity) | |
| { | |
| if(!Gate::allows('商品信息-编辑')){ return redirect(url('/')); } | |
| return view('maintenance.commodity.edit',['commodity'=>$commodity]); | |
| } | |
| /** | |
| * Update the specified resource in storage. | |
| * | |
| * @param Request $request | |
| * @param Commodity $commodity | |
| * @return Response | |
| */ | |
| public function update(Request $request, Commodity $commodity) | |
| { | |
| if(!Gate::allows('商品信息-编辑')){ return redirect(url('/')); } | |
| $this->validatorUpdate($request->all())->validate(); | |
| $commodity->fill($request->all()); | |
| $commodity->update(); | |
| $this->log(__METHOD__,__FUNCTION__,json_encode($request->toArray()),Auth::user()['id']); | |
| return redirect('maintenance/commodity/')->with('successTip',"成功修改商品信息：“{$commodity['name']}”！"); | |
| } | |
| /** | |
| * Remove the specified resource from storage. | |
| * | |
| * @param Commodity $commodity | |
| * @return array|Response | |
| * @throws Exception | |
| */ | |
| public function destroy(Commodity $commodity) | |
| { | |
| if(!Gate::allows('商品信息-删除')){ return redirect(url('/')); } | |
| $this->log(__METHOD__,__FUNCTION__,$commodity->toJson(),Auth::user()['id']); | |
| $re=$commodity->delete(); | |
| return ['success'=>$re]; | |
| } | |
| public function import() | |
| { | |
| return view('maintenance.commodity.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 CommodityImport($isOverride), $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();} | |
| if(strstr(strtolower($e->getMessage()),'sku')){return '<h1 class="text-danger">请在第一行将 商品编码 字段名改成“SKU”，不支持中文字段名，并且必须有该列</h1>'.$e->getMessage();} | |
| if(strstr(strtolower($e->getMessage()),'name')){return '<h1 class="text-danger">请在第一行将 商品名称 字段名改成“name”，不支持中文字段名，并且必须有该列</h1>'.$e->getMessage();} | |
| if(strstr(strtolower($e->getMessage()),'barcode')){return '<h1 class="text-danger">请在第一行将 商品条码 字段名改成“barcode”，不支持中文字段名，并且必须有该列</h1>'.$e->getMessage();} | |
| if(strstr(strtolower($e->getMessage()),'owner')){return '<h1 class="text-danger">请在第一行将 货主 字段名改成“owner”，不支持中文字段名，并且必须有该列</h1>'.$e->getMessage();} | |
| return '<h1 class="text-danger">失败</h1>'.$e->getMessage(); | |
| } | |
| } | |
| public function apiGetCommodityByBarcode(Request $request) | |
| { | |
| $barcode=$request->input('barcode'); | |
| $name = ''; | |
| if($barcode){ | |
| $commodity=Commodity::where('barcode',$barcode)->first(); | |
| if($commodity&&$commodity['name']) $name=$commodity['name']; | |
| } | |
| return ['success'=>'true','name'=>$name]; | |
| } | |
| } |