/**
* Display a listing of the resource.
*
* @param StatRequest $request
* @return Response
*/
public function index(StatRequest $request)
{
//////////////////* DAY *////////////////////
if (is_null($request->day)) {
$day = date('Y-m-d');
$dDay = date('d/m/Y');
} else {
$day = $request->day;
$dDay = (new \DateTime($request->day))->format('d/m/Y');
}
$dTotal = J2storeOrder::isValid()->whereBetween('created_date', [$day . ' 00:00:01', $day . ' 23:59:59'])->get();
$dPaypal = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$day . ' 00:00:01', $day . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_paypal')->get()->sum('order_total'));
$dCash = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$day . ' 00:00:01', $day . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_cash')->get()->sum('order_total'));
$dMoneyorder = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$day . ' 00:00:01', $day . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_moneyorder')->get()->sum('order_total'));
$dAbort = J2storeOrder::isAbort()->whereBetween('created_date', [$day . ' 00:00:01', $day . ' 23:59:59'])->having('order_state_id', '=', '5')->get();
$dNul = J2storeOrder::isAbort()->whereBetween('created_date', [$day . ' 00:00:01', $day . ' 23:59:59'])->having('order_state_id', '=', '3')->get();
//////////////////* WEEK *////////////////////
if ($request->week) {
$week = $request->week;
$dayStart = $request->dayStart;
$dayStop = $request->dayStop;
} else {
$week = date('d/m', strtotime('last Monday')) . '-' . date('d/m/Y', strtotime('next Sunday'));
$dayStart = date('Y-m-d', strtotime('last Monday'));
$dayStop = date('Y-m-d', strtotime('next Sunday'));
}
$wTotal = J2storeOrder::isValid()->whereBetween('created_date', [$dayStart . ' 00:00:01', $dayStop . ' 23:59:59'])->get();
$wPaypal = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$dayStart . ' 00:00:01', $dayStop . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_paypal')->get()->sum('order_total'));
$wCash = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$dayStart . ' 00:00:01', $dayStop . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_cash')->get()->sum('order_total'));
$wMoneyorder = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$dayStart . ' 00:00:01', $dayStop . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_moneyorder')->get()->sum('order_total'));
$wAbort = J2storeOrder::isAbort()->whereBetween('created_date', [$dayStart . ' 00:00:01', $dayStop . ' 23:59:59'])->having('order_state_id', '=', '5')->get();
$wNul = J2storeOrder::isAbort()->whereBetween('created_date', [$dayStart . ' 00:00:01', $dayStop . ' 23:59:59'])->having('order_state_id', '=', '3')->get();
//////////////////* MOIS *////////////////////
if ($request->month) {
$month = $request->month;
$year = $request->year;
} else {
$month = date('m');
$year = date('Y');
}
$mTotal = J2storeOrder::isValid()->whereBetween('created_date', [$year . '-' . $month . '-' . '01' . ' 00:00:01', $year . '-' . $month . '-' . '31' . ' 23:59:59'])->get();
$mPaypal = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$year . '-' . $month . '-' . '01' . ' 00:00:01', $year . '-' . $month . '-' . '31' . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_paypal')->get()->sum('order_total'));
$mCash = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$year . '-' . $month . '-' . '01' . ' 00:00:01', $year . '-' . $month . '-' . '31' . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_cash')->get()->sum('order_total'));
$mMoneyorder = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$year . '-' . $month . '-' . '01' . ' 00:00:01', $year . '-' . $month . '-' . '31' . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_moneyorder')->get()->sum('order_total'));
$mAbort = J2storeOrder::isAbort()->whereBetween('created_date', [$year . '-' . $month . '-' . '01' . ' 00:00:01', $year . '-' . $month . '-' . '31' . ' 23:59:59'])->having('order_state_id', '=', '5')->get();
$mNul = J2storeOrder::isAbort()->whereBetween('created_date', [$year . '-' . $month . '-' . '01' . ' 00:00:01', $year . '-' . $month . '-' . '31' . ' 23:59:59'])->having('order_state_id', '=', '3')->get();
//////////////////* YEAR *////////////////////
if ($request->yYear) {
$yYear = $request->yYear;
} else {
$yYear = date('Y');
}
$yTotal = J2storeOrder::isValid()->whereBetween('created_date', [$yYear . '-01-' . '01' . ' 00:00:01', $yYear . '-12-' . '31' . ' 23:59:59'])->get();
$yPaypal = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$yYear . '-01-' . '01' . ' 00:00:01', $yYear . '-12-' . '31' . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_paypal')->get()->sum('order_total'));
$yCash = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$yYear . '-01-' . '01' . ' 00:00:01', $yYear . '-12-' . '31' . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_cash')->get()->sum('order_total'));
$yMoneyorder = floatval(J2storeOrder::isValid()->whereBetween('created_date', [$yYear . '-01-' . '01' . ' 00:00:01', $yYear . '-12-' . '31' . ' 23:59:59'])->having('orderpayment_type', '=', 'payment_moneyorder')->get()->sum('order_total'));
$yAbort = J2storeOrder::isAbort()->whereBetween('created_date', [$yYear . '-01-' . '01' . ' 00:00:01', $yYear . '-12-' . '31' . ' 23:59:59'])->having('order_state_id', '=', '5')->get();
$yNul = J2storeOrder::isAbort()->whereBetween('created_date', [$yYear . '-01-' . '01' . ' 00:00:01', $yYear . '-12-' . '31' . ' 23:59:59'])->having('order_state_id', '=', '3')->get();
return view('pages.statistiques.index', compact('dTotal', 'dPaypal', 'dCash', 'dMoneyorder', 'dAbort', 'dNul', 'dDay', 'week', 'wTotal', 'wPaypal', 'wCash', 'wMoneyorder', 'wAbort', 'wNul', 'mTotal', 'mPaypal', 'mCash', 'mMoneyorder', 'mAbort', 'mNul', 'yYear', 'yTotal', 'yPaypal', 'yCash', 'yMoneyorder', 'yAbort', 'yNul'));
}
/**
* @param Request $request
* @return \Illuminate\Http\RedirectResponse
*/
public function update(Request $request)
{
if (isset($request)) {
$order = J2storeOrder::find($request->order_id);
$order->order_state = $request->order_state;
if ($request->order_state === 'stay') {
$order->order_state_id = 1;
} else {
if ($request->order_state === 'confirm') {
$order->order_state_id = 2;
} else {
if ($request->order_state === 'stop') {
$order->order_state_id = 3;
}
}
}
$order->save();
}
// return view()->action('HomeController@index');
return redirect()->back();
}
public function contact()
{
$tri = J2storeOrder::first()->contact->order_state;
return $this->hasOne('tri');
}
/**
* @return \Illuminate\View\View
*/
public function waitCom()
{
$order = J2storeOrder::all()->where('order_state_id', 1);
$orderInfo = J2storeOrderInfo::all();
return view('pages.commandes.index', compact('orderInfo', 'order'));
}