select(['id','name','created_at'])->orderByDesc('id')->paginate($request['paginate'] ?? 50); return view('maintenance.facilitator.index',compact('facilitators')); } // 服务商对账单 public function statementIndex(Request $request,DischargeTaskFilters $filters) { // 权限 *** $providerStatements = DischargeTask::query()->with('dischargeProvider') ->select(['id','discharge_provider_id','expenditure_amount','expenditure_unit','expenditure_unit_price','expenditure_total_cost','expenditure_remark','created_at']) ->filter($filters)->orderByDesc('id')->paginate($request['paginate'] ?? 50); $providers = DischargeProvider::query()->get(); return view('transport.discharge.provider.index',compact('providerStatements','providers')); } public function create() { // } public function store(Request $request) { // } public function storeApi(Request $request) { // 权限 *** $dischargeProvider = DischargeProvider::query()->create($request->all()); $this->success($dischargeProvider); } public function show(DischargeProvider $dischargeProvider) { // } public function edit(DischargeProvider $dischargeProvider) { // } public function update(Request $request, DischargeProvider $dischargeProvider) { // } public function updateApi(Request $request) { // 权限 *** $dischargeProvider = DischargeProvider::query()->where('id',$request['id'])->update($request->only(['name'])); if($dischargeProvider)$this->success(DischargeProvider::query()->find($request['id'])); $this->error('更新失败'); } public function destroy(DischargeProvider $dischargeProvider) { // } public function destroyApi(Request $request) { $count = $dischargeProvider = DischargeProvider::query()->where('id',$request['id'])->delete(); if($count>0)$this->success('删除成功'); $this->error('删除失败'); } // 对账单导出 public function exportStatement(Request $request,DischargeTaskFilters $filters) { // 权限 *** $dischargeTasks = DischargeTask::query()->with('dischargeProvider') ->select(['id','discharge_provider_id','expenditure_amount','expenditure_unit','expenditure_unit_price','expenditure_total_cost','expenditure_remark','created_at']) ->filter($filters)->orderByDesc('id')->get(); $row = ['日期','服务商','数量','单位','单价','总金额合计']; $json = app('DischargeTaskService')->getStatementsJson($dischargeTasks); return app(ExportService::class)->json($row,$json,"卸货结算报表"); } }