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]]);
}
