/**
* 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'));
}
/**
* Show the application dashboard to the user.
*
*/
public function index()
{
$timezone = 1;
$order = J2storeOrder::all();
$total = floatval(J2storeOrder::isValid()->sum('order_total'));
$orderInfo = J2storeOrderInfo::join('u16w2_j2store_orders', function ($q) {
$q->on('u16w2_j2store_orderinfo.order_id', '=', 'u16w2_j2store_orders.order_id');
})->orderBy('created_date', 'desc')->get();
return view('home', compact('orderInfo', 'order', 'total', 'timezone'));
}
/**
* Show the application dashboard to the user.
*
*/
public function index()
{
$timestamp = time() + date("Z");
$timezone = 1;
// dd(date('d/m/Y H:i:s',$timestamp+3600*($timezone+date("I"))));
$order = J2storeOrder::all();
$total = floatval(J2storeOrder::isValid()->sum('order_total'));
$orderInfo = J2storeOrderInfo::all();
return view('home', compact('orderInfo', 'order', 'total', 'timezone'));
}
