public function editForm(Request $request, $id){ $customer = Customer::findOrFail($id); if($customer){ $data = [ 'customer' => $customer, 'subnav' => $this->default_sub_nav ]; return view('customers.edit', $data); } return redirect('/customers')->flash('error', 'Customer not found'); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $project = Project::find($id); if (!$project) { return response()->json('Le projet n\'existe pas.', 404); } $validator = Validator::make($request->all(), ['status' => 'in:draft,accepted,pending,refused,command,billing', 'quotation_price' => 'integer', 'quotation_date' => 'date', 'customer_id' => 'integer']); if ($validator->fails()) { return response()->json($validator->errors()->all(), 400); } if ($request->input('customer_id')) { try { $customer = Customer::findOrFail($request->input('customer_id')); } catch (Exception $e) { return response()->json('Le client n\'existe pas.', 404); } } $project->update($request->all()); return $project; }
/** * Update the specified resource in storage. * * @param int $id * * @return Response */ public function update($id, Request $request) { $this->validate($request, ['CUSTNAME' => 'required']); $customer = Customer::findOrFail($id); $customer->update($request->all()); Session::flash('flash_message', 'Customer updated!'); return redirect('customers'); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { // $customer = Customer::findOrFail($id)->delete(); // redirect Session::flash('message', 'Successfully deleted the customer!'); return redirect('admin/customers'); }
public function lowerList(Request $request) { $customer_id = $request->input('customer_id'); $customer = Customer::findOrFail($customer_id); // $lower_list = Customer::with(['yikangQuestionnaire', 'orders'])->where('referrer_id', $customer->id); // $lower_list = \DB::table('customers') // ->leftJoin('yikang_questionnaires', 'customers.id', '=', 'yikang_questionnaires.customer_id') // ->leftJoin('orders', 'customers.id', '=', 'orders.customer_id') // ->where('customers.referrer_id', $customer->id) // ->select('customers.*', 'orders.*'); $lower_list = \DB::select(\DB::raw(' SELECT tmp1.*, tmp2.* FROM ( SELECT lowers.*, yikang_questionnaires.id as questionnaire_id, yikang_questionnaires.q1, yikang_questionnaires.q1b, yikang_questionnaires.q2, yikang_questionnaires.q2b, yikang_questionnaires.q3, yikang_questionnaires.q3a, yikang_questionnaires.q3b, yikang_questionnaires.q3c, yikang_questionnaires.q3d, yikang_questionnaires.q3d2, yikang_questionnaires.q3e, yikang_questionnaires.q4 FROM (SELECT * FROM customers WHERE referrer_id = ' . $customer->id . ') lowers LEFT JOIN yikang_questionnaires ON lowers.id = yikang_questionnaires.customer_id ) tmp1 LEFT JOIN ( SELECT customer_id, sum(cash_payment) as lower_cash_payment_sum, sum(beans_payment) as lower_beans_payment_sum FROM orders WHERE customer_id IN (SELECT id FROM customers WHERE referrer_id = ' . $customer->id . ') GROUP BY customer_id ) tmp2 ON tmp1.id = tmp2.customer_id ')); return response()->json(['success' => true, 'data' => ['lower_list' => $lower_list]]); }