Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function getDashboardTicketDays(){
- $business = Business::where('user_id',Auth::user()->user_id)->first(); # CHECK, IT WAS 'ID' CHANGED TO 'USER_ID'
- $today = \Carbon\Carbon::now()->format('m/d/Y');
- $monthAgo=\Carbon\Carbon::now()->subMonth(1)->format('m/d/Y');
- //$bookingsFromMonthAgo=Booking::where('user_id',Auth::user()->user_id)->where('start_date','like','%'.$monthAgo.'%')->where('status',2)->whereNull('deleted_at')->get();
- $bookingsAgo=Booking::where('user_id',Auth::user()->user_id)->where('status',2)->whereNull('deleted_at')->get();
- /*
- * SALES
- */
- $sales=0;
- $sales_mon=0;
- $sales_tues=0;
- $sales_wed=0;
- $sales_thu=0;
- $sales_fri=0;
- $sales_satu=0;
- $sales_sun=0;
- //for($x=0;$x<=30;$x++){
- //$date = \Carbon\Carbon::now()->subDay($x)->toDateString();
- //$salesFromMonthAgo=Ticket::where('user_id',Auth::user()->user_id)->where('type',2)->where('finalized_at','like','%'.$date.'%')->whereNull('deleted_at')->get();
- //return Ticket::where('user_id',Auth::user()->user_id)->where('type',2)->whereNull('deleted_at')->count();
- //$salesAgo=Sale::where('user_id',Auth::user()->user_id)->whereNull('deleted_at')->get();
- $salesAgo=Sale::where('user_id',Auth::user()->user_id)->whereNull('deleted_at')->get();
- foreach($salesAgo as $sale){
- //$carbon_date= Carbon::parse(explode('-',str_replace(' ','',$sale->created_at))[0]) ;
- $carbon_date= Carbon::parse($sale->created_at) ;
- switch($carbon_date->format('l')){
- case 'Monday':
- $sales_mon+=1;
- break;
- case 'Tuesday':
- $sales_tues+=1;
- break;
- case 'Wednesday':
- $sales_wed+=1;
- break;
- case 'Thursday':
- $sales_thu+=1;
- break;
- case 'Friday':
- $sales_fri+=1;
- break;
- case 'Saturday':
- $sales_satu+=1;
- break;
- case 'Sunday':
- $sales_sun+=1;
- break;
- }
- //return $carbon_start_date->format('l');
- }
- //}
- /*
- * END SALES
- */
- /*$salesFromMonthAgo=Sale::where('user_id',Auth::user()->user_id)
- ->where('created_at','like','%'.$monthAgo.'%')
- ->whereNull('deleted_at')
- ->count();*/
- $mon=0;
- $tues=0;
- $wed=0;
- $thu=0;
- $fri=0;
- $satu=0;
- $sun=0;
- foreach($bookingsAgo as $booking){
- //$carbon_start_date= Carbon::parse(explode('-',str_replace(' ','',$booking->start_date))[0]) ;
- $carbon_start_date= Carbon::parse($booking->start_date) ;
- switch($carbon_start_date->format('l')){
- case 'Monday':
- $mon+=1;
- break;
- case 'Tuesday':
- $tues+=1;
- break;
- case 'Wednesday':
- $wed+=1;
- break;
- case 'Thursday':
- $thu+=1;
- break;
- case 'Friday':
- $fri+=1;
- break;
- case 'Saturday':
- $satu+=1;
- break;
- case 'Sunday':
- $sun+=1;
- break;
- }
- //return $carbon_start_date->format('l');
- }
- $services=[$mon,$tues,$wed,$thu,$fri,$satu,$sun];
- $products=[$sales_mon,$sales_tues,$sales_wed,$sales_thu,$sales_fri,$sales_satu,$sales_sun];
- $dataBooking=['services'=>$services,'products'=>$products];
- return $dataBooking;
- //return $monthAgo;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement