public function dashboard()
 {
     $objModelUser = User::getInstance();
     $whereAllUsers = array('rawQuery' => 'role=1');
     $allUsers = $objModelUser->getAllUsersWhere($whereAllUsers);
     $countAllUsers = 0;
     $countAllActiveUsers = 0;
     foreach ($allUsers as $all) {
         ++$countAllUsers;
         if ($all->status == 1) {
             ++$countAllActiveUsers;
         }
     }
     $objModelOrder = Order::getInstance();
     $whereAllOrders = array('rawQuery' => 'status=0 or 1 or 2 or 3 or 4 or 5 or 6');
     $allOrders = $objModelOrder->getAllOrdersWhere($whereAllOrders);
     $countAllOrder = 0;
     $countTodaysOrders = 0;
     $countPendingOrders = 0;
     $countFailedOrders = 0;
     $countCancelledOrders = 0;
     $countRefundedOrders = 0;
     foreach ($allOrders as $all) {
         ++$countAllOrder;
         if ($all->added_time >= time() + 19800 - 24 * 3600) {
             ++$countTodaysOrders;
         }
         if ($all->status == 0) {
             ++$countPendingOrders;
         } elseif ($all->status == 4) {
             ++$countFailedOrders;
         } elseif ($all->status == 5) {
             ++$countRefundedOrders;
         } elseif ($all->status == 6) {
             ++$countCancelledOrders;
         }
     }
     return view('Admin::admin.dashboard', ['count_all' => $countAllUsers, 'count_active' => $countAllActiveUsers, 'total_orders' => $countAllOrder, 'pending_orders' => $countPendingOrders, 'failed_orders' => $countFailedOrders, 'refunded_orders' => $countRefundedOrders, 'cancelled_orders' => $countCancelledOrders, 'todays_orders' => $countTodaysOrders]);
 }
 public function viewOrderList(Request $request)
 {
     if ($request->isMethod('post')) {
         $orderId = $request->input('id');
         $objModelOrder = Order::getInstance();
         $where = array('rawQuery' => 'order_id = ?', 'bindParams' => [$orderId]);
         $selectedColumns = ['users.*', 'orders.*', 'plans.plan_name'];
         $orderDetails = $objModelOrder->getUsersInfoFromOrdersByUserId($where, $selectedColumns);
         if ($orderDetails) {
             foreach ($orderDetails as $od) {
                 $convertedStartTime = $this->convertUT($od->start_time);
                 $convertedEndTime = $this->convertUT($od->end_time);
                 $convertedAddedTime = $this->convertUT($od->added_time);
                 $convertedUpdatedTime = $this->convertUT($od->updated_time);
             }
             echo json_encode(array('status' => '200', 'message' => 'reached till here', 'data' => $orderDetails, 'startTime' => $convertedStartTime, 'endTime' => $convertedEndTime, 'addedTime' => $convertedAddedTime, 'updatedTime' => $convertedUpdatedTime));
         } else {
             echo json_encode(array('status' => '400', 'message' => 'Failed. Plesae try again.'));
         }
     }
 }