public function getWorkCategories($option = null) { $obj = new Application_Model_Category(); $entries = $obj->fetchAll(); $arrContinent = array(); if (!is_null($option)) { $arrContinent[''] = $option; } foreach ($entries as $entry) { $arrContinent[$entry->getId()] = $entry->getName(); } return $arrContinent; }
public function dih_search_get_catid_byname($value, $searchtype) { if ($searchtype == "PartialLang") { $key = "left(soundex( name ),4)"; $value = "left(soundex( '{$value}' ),4)"; $conditionoperator = " = "; } if ($searchtype == "Partial") { $key = "name"; $value = "'%{$value}%'"; $conditionoperator = " like "; } if ($searchtype == "Exact") { $key = "name"; $value = "'{$value}'"; $conditionoperator = " = "; } $Category = new Application_Model_Category(); //echo "$key $conditionoperator $value"; $catObj = $Category->fetchAll("{$key} {$conditionoperator} {$value}"); //$query = "SELECT catid FROM #__sobi2_categories WHERE $key $conditionoperator $value"; /* if(!empty($catObj)){ } */ //echo "<pre>";print_r($catObj);exit; return $catObj; }
public function categoryDetailAction() { //$this->_helper->viewRenderer->setNoRender(true); $params = $this->getRequest()->getParams(); $category = $params['category']; $this->view->title = $category; $categoryM = new Application_Model_Category(); $this->view->cats = $categoryM->fetchAll("type='{$category}' AND status='published'", "name ASC"); }
public function indexAction() { // $this->_helper->layout->disableLayout(); $this->view->topMenuFlag = true; /*$fields = array ('optimize'=> true, 'commit'=> true, 'clean'=> true); // $curl_request = curl_init('http://pbodev.info:8983/solr/mbartists/dataimport?command=fullimport'); // $curl_request = curl_init('http://pbodev.info:8983/solr/dataimport?command=fullimport'); $curl_request = curl_init('http://pbodev.info:8983/solr/select?qt=/dataimport&command=fullimpor&clean=true&commit=true&optimize=true'); curl_setopt($curl_request, CURLOPT_HEADER, 0); curl_setopt($curl_request, CURLOPT_RETURNTRANSFER, 1); // curl_setopt($curl_request, CURLOPT_POSTFIELDS, $fields); $curl_response = curl_exec($curl_request); curl_close($curl_request); prexit($curl_response);*/ $catid = $this->_getParam('category'); $insuranceid = $this->_getParam('insurance', ''); $planid = $this->_getParam('plan', ''); $reasonid = $this->_getParam('reason'); $sobi2SearchText = addslashes(trim($this->_getParam('searchText'))); $search1 = trim($this->_getParam('search1')); $state = trim($this->_getParam('st')); $start_date = $this->_getParam('start_date'); $isAjax = $this->_getParam('isAjax', 0); $reasons = array(); $linkArray = array(); $this->view->catid = $catid; $this->view->insuranceid = $insuranceid; $this->view->planid = $planid; $this->view->reasonid = $reasonid; $this->view->searchText = stripslashes(stripslashes($sobi2SearchText)); $this->view->search1 = stripslashes(stripslashes($search1)); $this->view->start_date = $start_date; $this->view->isReasontoVisit = 1; // fetch category $Category = new Application_Model_Category(); $categories = $Category->fetchAll("status=1", "name ASC"); $this->view->categories = $categories; // fetch insurance companies if ($catid == 7) { $plan_type = 'd'; } else { $plan_type = 'g'; } $Plan = new Application_Model_InsurancePlan(); $plans = $Plan->fetchAll("plan_type='{$plan_type}' AND status=1"); $planArray = array(); foreach ($plans as $p) { $planArray[] = $p->getInsuranceCompanyId(); } $planArray = array_unique($planArray); $planStr = implode(',', $planArray); $Insurance = new Application_Model_InsuranceCompany(); if ($insuranceid) { $planStr = $planStr . "," . $insuranceid; // when some come from insurance company-plan sitemap directly $this->view->insuranceCompany = $Insurance->fetchRow("status=1 AND id ='{$insuranceid}'"); } $insurances = $Insurance->fetchAll("status=1 AND id IN ({$planStr})", "company ASC"); $this->view->insurances = $insurances; // fetch insurance plans $insuranceplans = array(); if ($insuranceid > 0) { $insuranceplans = $Plan->fetchAll("insurance_company_id='{$insuranceid}' AND status=1"); $linkArray['insurance'] = $insuranceid; } $this->view->insuranceplans = $insuranceplans; //$this->view->insuranceCompany = $insuranceCompany; if ($planid > 0) { $linkArray['plan'] = $planid; } if ($reasonid > 0) { $linkArray['reason'] = $reasonid; } if ($search1 != '') { $linkArray['search1'] = $search1; } if ($state != '') { $linkArray['st'] = $state; } if ($sobi2SearchText != '') { $linkArray['searchText'] = $sobi2SearchText; } $isBronze = 0; // 0 - paid doctor, 1 - bronze doctors // fetch reason for visits if ($catid > 0) { $linkArray['category'] = $catid; $Reason = new Application_Model_ReasonForVisit(); $reasons = $Reason->fetchAll("category_id='{$catid}' AND status=1", "reason ASC"); } $this->view->reasons = $reasons; // ############################################### Search Results ###################################### $this->view->page = $page = $this->_getParam('page', 1); // $Search = new Base_SearchLucene(); $settings = new Admin_Model_GlobalSettings(); $limit = $settings->settingValue('pagination_size'); $searchResults = $this->searchDIH('paid', $limit); if (isset($searchResults['other']) && count($searchResults['other']) > 0) { $this->view->otherStates = $searchResults['other']; } // prexit($searchResults); if (isset($searchResults['total']) && $searchResults['total'] < 1) { // search for bronze doctors $isBronze = 1; $searchResults = $this->searchDIH('free', $limit); } $this->view->total = $searchResults['total']; $this->view->allResultArray = $searchResults['allResultArray']; $Paginator = new Base_Paginator(); $this->view->paginator = $paginator = $Paginator->solrPaginator($searchResults['allResultArray'], $searchResults['total'], $page, $limit); $this->view->isBronze = $isBronze; // prexit($paginator); // $this->view->sortPosition = $this->_sortPosition; // ############################################ Search Results ########################################## $ip = $_SERVER['REMOTE_ADDR']; $this->view->linkArray = $linkArray; #-----------------------------------Start set title and description as per search result--------------------------- # $title = ""; $desc = ""; $sobi2Search = ""; if ($catid != '') { $catObj = $Category->find($catid); if (!empty($catObj)) { $sobi2Search = $catObj->getName(); } } $search1 = trim(str_replace(",", " ", $this->_getParam('search1'))); $insurance_name = ""; $dentistCategory = array('Dentist', 'Endodontist', 'Periodontist', 'Prosthodontist', 'Oral and Maxillofacial Surgeon', 'Orthodontist'); if ($insuranceid > 0) { $insuranceObj = $Insurance->fetchRow("id='{$insuranceid}'"); $insurance_name = $insuranceObj->getCompany(); } if ($insuranceid > 0 && (isset($sobi2Search) && in_array($sobi2Search, $dentistCategory))) { $title = "{$insurance_name}, {$insurance_name} Dentist, {$insurance_name} Dental , {$insurance_name} Dental Insurance Plan"; $desc = "{$insurance_name} Dental Insurance Plan: For {$insurance_name}, {$insurance_name} Dentist, {$insurance_name} Dental & Dentist's that Accept {$insurance_name} Visit Doctors Improving Healthcare"; } else { //if (isset ( $sobi2Search ) && $sobi2Search != "all") { // Speciality serach if (isset($sobi2Search) && $sobi2Search != "") { // Speciality serach if ($search1 != "") { $title = "{$sobi2Search} {$search1}, {$sobi2Search} {$search1}"; $desc = "{$sobi2Search} {$search1}: Find the best Dentist in {$search1} with patients reviews. Choose a top rated {$sobi2Search} {$search1} for your needs. Schedule an appointment now!"; } else { $title = "{$sobi2Search} San Francisco, New York, Los Angeles(LA), San Diego, CA"; $desc = "Find the best {$sobi2Search} in San Francisco, Los Angeles(LA), San Diego with patients reviews, Make an instant appointment Now!"; } } else { // City, zipcode address serch $title = "{$search1} Dentist, Doctor, Dermatologist, Plastic/Cosmetic Surgeon"; if (is_numeric($search1)) { //############# Is zipcode $desc = "Choose from hundreds of local {$search1} Top Doctors & Dentists, Dermatologists, Plastic Surgeons, Cosmetic Surgeons & Cosmetic Dentist at Doctors Improving Healthcare."; } else { $desc = "{$search1} Dentist: Choose from hundreds of Top {$search1} Doctors & {$search1} Dentists, Dermatologists, Plastic Surgeons, Cosmetic Surgeons & Cosmetic Dentist at Doctors Improving Healthcare."; } } } $returnArray = array(); if ($isAjax) { $this->_helper->layout->disableLayout(); // $returnArray['middel_content'] = $this->view->render('search/middle_content.phtml'); echo $this->view->render('search/middle_content.phtml'); // echo Zend_Json::encode($returnArray); exit; } /* -----------------------------------End set title and description as per search result--------------------------- */ }
/** * @Created By : Mahipal Singh Adhikari * @Created On : 10-Feb-2011 * Description : Display advice home page with CMS content and available categories */ public function homeAction() { //get advice CMS page detail content $identifire = "advice"; $pageM = new Application_Model_Page(); $pageM = $pageM->getStaticContent($identifire); if (false !== $pageM) { $this->view->title = $pageM->getTitle(); $this->view->content = $pageM->getContent(); //$this->view->headTitle()->setSeparator(' - '); } //get Advice categories $categoryM = new Application_Model_Category(); $where = "type='advice' AND status='published'"; $order = "weight ASC"; $categoryRes = $categoryM->fetchAll($where, $order); $this->view->total = count($categoryRes); $this->view->categories = $categoryRes; }