public function searchTypeDataSet() { $searchType = $_GET['search_type']; $json = array(); switch ($searchType) { case "1": $rt = new MasterRestaurantTypeModel(); $arr = $rt->getWhere("name!=''"); foreach ($arr as $restoType) { $b['value'] = $restoType->id_restaurant_type; $b['text'] = $restoType->name; $json[] = $b; } break; case "2": $r = new MasterCategoryModel(); $arr = $r->getWhere("name!=''"); foreach ($arr as $tag) { $b['value'] = $tag->id_category; $b['text'] = $tag->name; $json[] = $b; } break; case "3": $r = new CuisineModel(); $arrRC = $r->getWhere("name_cuisine!=''"); foreach ($arrRC as $cuisine) { $b['value'] = $cuisine->id_cuisine; $b['text'] = $cuisine->name_cuisine; $json[] = $b; } break; // case "5": { // $r = new MasterDishTagModel(); // $arr = $r->getWhere("name!=''"); // foreach ($arr as $tag) { // $b['value'] = $tag->id_tag; // $b['text'] = $tag->name; // $json[] = $b; // } // break; // } // case "5": { // $r = new MasterDishTagModel(); // $arr = $r->getWhere("name!=''"); // foreach ($arr as $tag) { // $b['value'] = $tag->id_tag; // $b['text'] = $tag->name; // $json[] = $b; // } // break; // } case "7": $rt = new MasterRestaurantModel(); $arr = $rt->getWhere("name!=''"); foreach ($arr as $resto) { $b['value'] = $resto->id_restaurant; $b['text'] = $resto->name; $json[] = $b; } break; default: $b['value'] = 8888; $b['text'] = "Not Available"; $json[] = $b; break; } echo json_encode($json); die; }
private function searchTypeDataSet($searchType, $identifier) { switch ($searchType) { // case "0": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } case "1": $rt = new MasterRestaurantTypeModel(); $arr = $rt->getWhere("name!=''"); $arrRestoType = array(); foreach ($arr as $restoType) { $arrRestoType[$restoType->id_restaurant_type] = $restoType->name; } return new Leap\View\InputSelect($arrRestoType, "search_term{$identifier}", "search_term", $this->search_term); case "2": $r = new MasterCategoryModel(); $arr = $r->getWhere("name!=''"); $arrRestoTag = array(); foreach ($arr as $tag) { $arrRestoTag[$tag->id_category] = $tag->name; } return new Leap\View\InputSelect($arrRestoTag, "search_term{$identifier}", "search_term", $this->search_term); case "3": $r = new CuisineModel(); $arrRC = $r->getWhere("name_cuisine!=''"); $arrRestoCuisine = array(); foreach ($arrRC as $cuisine) { $arrRestoCuisine[$cuisine->id_cuisine] = $cuisine->name_cuisine; } return new Leap\View\InputSelect($arrRestoCuisine, "search_term{$identifier}", "search_term", $this->search_term); // case "4": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } // case "5": { // $r = new MasterDishTagModel(); // $arr = $r->getWhere("name!=''"); // $arrDishTag = array(); // foreach ($arr as $tag) { // $arrDishTag[$tag->id_tag] = $tag->name; // } // return new Leap\View\InputSelect($arrDishTag, "search_term$identifier", "search_term", $this->search_term); // // } // case "6": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } // case "4": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } // case "5": { // $r = new MasterDishTagModel(); // $arr = $r->getWhere("name!=''"); // $arrDishTag = array(); // foreach ($arr as $tag) { // $arrDishTag[$tag->id_tag] = $tag->name; // } // return new Leap\View\InputSelect($arrDishTag, "search_term$identifier", "search_term", $this->search_term); // // } // case "6": { // return new Leap\View\InputText("text", "search_term", "search_term", $this->search_term); // } case "7": $rt = new MasterRestaurantModel(); $arr = $rt->getWhere("name!=''"); $arrResto = array(); foreach ($arr as $resto) { $arrResto[$resto->id_restaurant] = $resto->name; } return new Leap\View\InputSelect($arrResto, "search_term{$identifier}", "search_term", $this->search_term); case "8888": return new Leap\View\InputSelect(array("8888" => "Not Available"), "search_term{$identifier}", "search_term", $this->search_term); default: return new Leap\View\InputSelect(array("8888" => "Not Available"), "search_term{$identifier}", "search_term", $this->search_term); } }
public static function isRestoTypeByIDAvailable($id_restaurant_type) { $objRestoType = new MasterRestaurantTypeModel(); $arrRestoType = $objRestoType->getWhere("id_restaurant_type='{$id_restaurant_type}'"); return count($arrRestoType); }