Advertisement
Guest User

Untitled

a guest
Nov 21st, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.14 KB | None | 0 0
  1. public function getDashboardTicketDays(){
  2. $business = Business::where('user_id',Auth::user()->user_id)->first(); # CHECK, IT WAS 'ID' CHANGED TO 'USER_ID'
  3. $today = \Carbon\Carbon::now()->format('m/d/Y');
  4.  
  5. $monthAgo=\Carbon\Carbon::now()->subMonth(1)->format('m/d/Y');
  6. //$bookingsFromMonthAgo=Booking::where('user_id',Auth::user()->user_id)->where('start_date','like','%'.$monthAgo.'%')->where('status',2)->whereNull('deleted_at')->get();
  7. $bookingsAgo=Booking::where('user_id',Auth::user()->user_id)->where('status',2)->whereNull('deleted_at')->get();
  8. /*
  9. * SALES
  10. */
  11. $sales=0;
  12. $sales_mon=0;
  13. $sales_tues=0;
  14. $sales_wed=0;
  15. $sales_thu=0;
  16. $sales_fri=0;
  17. $sales_satu=0;
  18. $sales_sun=0;
  19.  
  20. //for($x=0;$x<=30;$x++){
  21. //$date = \Carbon\Carbon::now()->subDay($x)->toDateString();
  22. //$salesFromMonthAgo=Ticket::where('user_id',Auth::user()->user_id)->where('type',2)->where('finalized_at','like','%'.$date.'%')->whereNull('deleted_at')->get();
  23. //return Ticket::where('user_id',Auth::user()->user_id)->where('type',2)->whereNull('deleted_at')->count();
  24. //$salesAgo=Sale::where('user_id',Auth::user()->user_id)->whereNull('deleted_at')->get();
  25. $salesAgo=Sale::where('user_id',Auth::user()->user_id)->whereNull('deleted_at')->get();
  26. foreach($salesAgo as $sale){
  27. //$carbon_date= Carbon::parse(explode('-',str_replace(' ','',$sale->created_at))[0]) ;
  28. $carbon_date= Carbon::parse($sale->created_at) ;
  29. switch($carbon_date->format('l')){
  30. case 'Monday':
  31. $sales_mon+=1;
  32. break;
  33. case 'Tuesday':
  34. $sales_tues+=1;
  35. break;
  36. case 'Wednesday':
  37. $sales_wed+=1;
  38. break;
  39. case 'Thursday':
  40. $sales_thu+=1;
  41. break;
  42. case 'Friday':
  43. $sales_fri+=1;
  44. break;
  45. case 'Saturday':
  46. $sales_satu+=1;
  47. break;
  48. case 'Sunday':
  49. $sales_sun+=1;
  50. break;
  51. }
  52. //return $carbon_start_date->format('l');
  53. }
  54. //}
  55. /*
  56. * END SALES
  57. */
  58.  
  59. /*$salesFromMonthAgo=Sale::where('user_id',Auth::user()->user_id)
  60. ->where('created_at','like','%'.$monthAgo.'%')
  61. ->whereNull('deleted_at')
  62. ->count();*/
  63. $mon=0;
  64. $tues=0;
  65. $wed=0;
  66. $thu=0;
  67. $fri=0;
  68. $satu=0;
  69. $sun=0;
  70. foreach($bookingsAgo as $booking){
  71. //$carbon_start_date= Carbon::parse(explode('-',str_replace(' ','',$booking->start_date))[0]) ;
  72. $carbon_start_date= Carbon::parse($booking->start_date) ;
  73. switch($carbon_start_date->format('l')){
  74. case 'Monday':
  75. $mon+=1;
  76. break;
  77. case 'Tuesday':
  78. $tues+=1;
  79. break;
  80. case 'Wednesday':
  81. $wed+=1;
  82. break;
  83. case 'Thursday':
  84. $thu+=1;
  85. break;
  86. case 'Friday':
  87. $fri+=1;
  88. break;
  89. case 'Saturday':
  90. $satu+=1;
  91. break;
  92. case 'Sunday':
  93. $sun+=1;
  94. break;
  95. }
  96. //return $carbon_start_date->format('l');
  97. }
  98. $services=[$mon,$tues,$wed,$thu,$fri,$satu,$sun];
  99. $products=[$sales_mon,$sales_tues,$sales_wed,$sales_thu,$sales_fri,$sales_satu,$sales_sun];
  100. $dataBooking=['services'=>$services,'products'=>$products];
  101.  
  102. return $dataBooking;
  103. //return $monthAgo;
  104. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement