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) { // 权限 *** $facilitatorStatements = DischargeTask::query()->with('facilitator') ->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); $facilitators = Facilitator::query()->get(); return view('transport.discharge.facilitator.index', compact('facilitatorStatements', 'facilitators')); } public function create() { // } public function store(Request $request) { // } public function storeApi(Request $request) { // 权限 *** $facilitator = Facilitator::query()->create($request->all()); $this->success($facilitator); } public function show(Facilitator $facilitator) { // } public function edit(Facilitator $facilitator) { // } public function update(Request $request, Facilitator $facilitator) { // } public function updateApi(Request $request) { // 权限 *** $facilitator = Facilitator::query()->where('id', $request['id'])->update($request->only(['name'])); if ($facilitator) $this->success(Facilitator::query()->find($request['id'])); $this->error('更新失败'); } public function destroy(Facilitator $facilitator) { // } public function destroyApi(Request $request) { $count = Facilitator::query()->where('id', $request['id'])->delete(); if ($count > 0) $this->success('删除成功'); $this->error('删除失败'); } // 对账单导出 public function exportStatement(Request $request, DischargeTaskFilters $filters) { // 权限 *** $dischargeTasks = DischargeTask::query()->with('facilitator') ->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, "卸货结算报表"); } }