/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index(Request $request)
{
if (Gate::denies('customer.read')) {
return view(config('app.template') . '.error.403');
}
$type = $request->get('type') ? $request->get('type') : 'registered';
if ($type == 'registered') {
$customers = Customer::leftJoin(DB::raw("\n (SELECT orders.`id`, orders.`customer_id`, SUM(order_details.`harga_jual` * (order_details.`qty` - ifnull(order_detail_returns.qty, 0)))\n AS total_penjualan FROM orders INNER JOIN order_details ON orders.`id` = order_details.`order_id`\n LEFT JOIN order_detail_returns on order_details.id = order_detail_returns.order_detail_id\n WHERE orders.`state` = 'Closed' GROUP BY orders.`id`)AS temp_orders\n "), 'customers.id', '=', 'temp_orders.customer_id')->whereNotNull('customers.nama')->select(['customers.*', DB::raw('count(temp_orders.id) as jumlah_kunjungan'), DB::raw('sum(temp_orders.total_penjualan)as total')])->groupBy('customers.id')->paginate(2);
$data = ['customers' => $customers];
return view(config('app.template') . '.customer.table', $data);
} elseif ($type == 'unregistered') {
$customers = Customer::whereNull('nama')->get();
$data = ['customers' => $customers];
return view(config('app.template') . '.customer.table-empty', $data);
} else {
abort(404);
}
}
public function table()
{
$operations = ['<li>{!!link_to_route("customers.edit", "edit", ["customerId" => $id], ["class" => "glyphicon glyphicon-pencil"])!!}</li>', '<li>{!!link_to_route("customers.remove", "remove", ["customerId" => $id], ["class" => "glyphicon glyphicon-remove"])!!}</li>'];
$customers = Customer::leftJoin('customer_group', 'customer.group_id', '=', 'customer_group.id')->select(['customer.id', 'customer.firstname', 'customer.lastname', 'customer.phone', 'customer_group.groupname']);
return \Datatables::of($customers)->add_column('operations', '<ul class="operations">' . implode($operations) . '</ul>')->add_column('show', '{{route("customers.show", ["customerId" => $id])}}')->remove_column('id')->make(true);
}
public function customerInfo(Request $request)
{
$customer = Customer::leftJoin('users', 'users.userable_id', '=', 'customer.id')->select('customer.id', 'username', 'email', 'banned', 'name', 'address', 'phone')->findOrFail($request->id);
return $customer;
}
