public static function getInstance()
 {
     if (!is_object(self::$_instance)) {
         self::$_instance = new Admin_Model_StoreCategory();
     }
     return self::$_instance;
 }
 public function dashboardAction()
 {
     $adminModel = Admin_Model_Users::getInstance();
     $result = $adminModel->getAdminDetails();
     // showing image
     if ($result) {
         $this->view->admindetails = $result;
     }
     $userModel = Admin_Model_Users::getInstance();
     $result = $userModel->getUserdetails();
     if ($result) {
         $this->view->userdetails = count($result);
     }
     $usertransactionModel = Admin_Model_UserTransactions::getInstance();
     $result1 = $usertransactionModel->getAllUsertransaction();
     if ($result1) {
         $this->view->usertransaction = count($result1);
     }
     $ordersModel = Admin_Model_Orders::getInstance();
     $result2 = $ordersModel->getAllHotelOrder();
     if ($result2) {
         $this->view->orderdetails = count($result2);
     }
     $ordersModel1 = Admin_Model_Orders::getInstance();
     $result21 = $ordersModel->getAllStoreOrder();
     if ($result21) {
         $this->view->storeorderdetails = count($result21);
     }
     $productsModel = Admin_Model_Products::getInstance();
     $result3 = $productsModel->getProductsdetails();
     if ($result3) {
         $this->view->productsdetails = count($result3);
     }
     $productsModel1 = Admin_Model_Products::getInstance();
     $result31 = $productsModel1->getAllStoreProductdetails();
     if ($result31) {
         $this->view->productsdetails = count($result31);
     }
     $agentsModel = Admin_Model_Agents::getInstance();
     $result4 = $agentsModel->getAgentsDetails();
     if ($result4) {
         $this->view->agentsdetails = count($result4);
     }
     $storeDetailsModel = Admin_Model_StoreDetails::getInstance();
     $result5 = $storeDetailsModel->getAllStore();
     if ($result5) {
         $this->view->storedetails = count($result5);
     }
     $hotelDetailsModel = Admin_Model_HotelDetails::getInstance();
     $result6 = $hotelDetailsModel->getAllHotels();
     if ($result6) {
         $this->view->hoteldetails = count($result6);
     }
     $agenttransactionModel = Admin_Model_AgentTransactions::getInstance();
     $result7 = $agenttransactionModel->getAllAgenttransaction();
     if ($result7) {
         $this->view->agenttransaction = count($result7);
     }
     $producttransactionModel = Admin_Model_ProductTransactions::getInstance();
     $result8 = $producttransactionModel->getAllProducttransaction();
     if ($result8) {
         $this->view->producttransaction = count($result8);
     }
     $storeCategoryDetailsModel = Admin_Model_StoreCategory::getInstance();
     $result9 = $storeCategoryDetailsModel->selectAllCategorys();
     if ($result9) {
         $this->view->storecategorydetails = count($result9);
     }
     $DeliveryGuysModel = Admin_Model_DeliveryGuys::getInstance();
     $result10 = $DeliveryGuysModel->getAllDeliveryGuys();
     if ($result10) {
         $this->view->DeliveryGuys = count($result10);
     }
     $NotificationModel = Admin_Model_Notification::getInstance();
     $result11 = $NotificationModel->getNotificationDetail();
     if ($result11) {
         $this->view->Notification = count($result11);
     }
     $ReviewsModel = Admin_Model_Reviews::getInstance();
     $result12 = $ReviewsModel->getAllHotelReviews();
     if ($result12) {
         $this->view->HotelReviews = count($result12);
     }
     $ReviewModel = Admin_Model_Reviews::getInstance();
     $result13 = $ReviewModel->getAllStoreReviews();
     if ($result13) {
         $this->view->StoreReviews = count($result13);
     }
     $locationsModel1 = Admin_Model_Location::getInstance();
     $result14 = $locationsModel1->getCountrys();
     if ($result14) {
         $this->view->CountryDetails = count($result14);
     }
     $locationsModel2 = Admin_Model_Location::getInstance();
     $result15 = $locationsModel2->getStates();
     if ($result15) {
         $this->view->StateDetails = count($result15);
     }
     $locationsModel3 = Admin_Model_Location::getInstance();
     $result16 = $locationsModel3->getCitys();
     if ($result16) {
         $this->view->CityDetails = count($result16);
     }
     $locationsModel4 = Admin_Model_Location::getInstance();
     $result17 = $locationsModel4->getLocations();
     if ($result17) {
         $this->view->LocationDetails = count($result17);
     }
     $cuisinesModel = Admin_Model_FamousCuisines::getInstance();
     $result18 = $cuisinesModel->getCuisines();
     if ($result18) {
         $this->view->CuisineDetails = count($result18);
     }
     $categoryModel = Admin_Model_MenuCategory::getInstance();
     $result19 = $categoryModel->selectAllCategorys();
     if ($result19) {
         $this->view->CategoryDetails = count($result19);
     }
     $objModelCoupons = Admin_Model_Coupons::getInstance();
     $allCoupons = $objModelCoupons->getCoupons();
     if ($allCoupons) {
         $this->view->allcoupons = count($allCoupons);
     }
     $objModelCouponUsers = Admin_Model_CouponUsers::getInstance();
     $couponsLog = $objModelCouponUsers->getCouponsLog();
     if ($couponsLog) {
         $this->view->couponsLog = count($couponsLog);
     }
 }
 public function viewStoreDetailsAction()
 {
     $adminModel = Admin_Model_Users::getInstance();
     $result = $adminModel->getAdminDetails();
     // showing image
     if ($result) {
         $this->view->admindetails = $result;
     }
     $storeDetailsModel = Admin_Model_StoreDetails::getInstance();
     $storecategoryModel = Admin_Model_StoreCategory::getInstance();
     $store_id = $this->getRequest()->getParam('storeId');
     $dt['store_id'] = $store_id;
     $result = $storeDetailsModel->getStoreDetailsByID($store_id);
     $categoryID = json_decode($result['category_id'], true);
     $i = 0;
     foreach ($categoryID as $categoryname) {
         $categoryname = $storecategoryModel->getCategoryById($categoryname);
         $categorynames[$i] = $categoryname['cat_name'];
         $i++;
     }
     if ($result) {
         $this->view->allstoredetails = $result;
         $this->view->allStoreCategorynames = $categorynames;
     } else {
         echo 'controller error occured';
     }
 }
 public function editStoreCategoryAction()
 {
     $this->_helper->layout()->disableLayout();
     $this->_helper->viewRenderer->setNoRender(true);
     $categoryModel = Admin_Model_StoreCategory::getInstance();
     if ($this->getRequest()->isPost()) {
         $data['cat_name'] = $this->getRequest()->getPost('category');
         $data['cat_desc'] = $this->getRequest()->getPost('catdesc');
         $category_id = $this->getRequest()->getPost('category_id');
         $categoryname = $this->getRequest()->getPost('categorybtn');
         if ($category_id) {
             $result = $categoryModel->updateCategory($data, $category_id);
             if ($categoryname == 'category') {
                 if ($result) {
                     $this->redirect('/admin/store-category-details');
                 } else {
                     $this->redirect('/admin/store-category-details');
                 }
             }
         }
     }
 }