public function actionIndex() { $this->pageTitle = 'Handyman - Login'; $this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10)); $param['projects'] = Projecttypes::model()->findAll(array('order' => 'Name ASC')); $this->render('login', $param); }
public function actionConsignup_step5() { $this->pageTitle = 'Handyman.com - Sign up step 1'; $this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10)); $param['projects'] = Projecttypes::model()->findAll(array('order' => 'Name ASC')); $this->render('consignup-step5', $param); }
public function actionCitiesByCountry() { $list = Cities::model()->findAll("countries_id=?", array($_POST["Users"]["countries_id"])); foreach ($list as $data) { echo "<option value=\"{$data->id}\">{$data->name}</option>"; } }
/** * Returns the data model based on the primary key given in the GET variable. * If the data model is not found, an HTTP exception will be raised. * @param integer $id the ID of the model to be loaded * @return Cities the loaded model * @throws CHttpException */ public function loadModel($id) { $model = Cities::model()->findByPk($id); if ($model === null) { throw new CHttpException(404, 'The requested page does not exist.'); } return $model; }
public function getselectcities($post) { $return = $htmlParams = array(); $state_id = $post['state_id']; $criteria = new CDbCriteria(); $criteria->condition = "StateId = '{$state_id}'"; $htmlParams['cities'] = Cities::model()->findAll($criteria); $return['html'] = $this->renderPartial('cities', $htmlParams, true); $this->renderJSONcities($return, true); }
public function actionProfile() { $this->pageTitle = 'Handyman.com - User Profile'; $this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10)); $param['projects'] = Projecttypes::model()->findAll(array('order' => 'Name ASC')); $criteria = new CDbCriteria(); $criteria->condition = "IsTop = '1'"; $param['top'] = Projecttypes::model()->findAll($criteria); $this->render('profile', $param); }
public function actionSitemap() { header('Content-Type: application/xml'); $cities = Cities::model()->findAll(array('order' => 'Name ASC')); $projects = Projecttypes::model()->findAll(array('order' => 'Name ASC')); $contractors = Contractors::model()->findAll(array('order' => 'Name ASC')); $this->renderPartial('sitemapxml', array('cities' => $cities, 'projects' => $projects, 'contractors' => $contractors)); }
$gMap->panControl = false; $gMap->zoomControl = true; $gMap->zoomControlOptions = array('style' => 'google.maps.ZoomControlStyle.SMALL'); $gMap->styles = 1; $gMap->setWidth(100, '%'); $gMap->setHeight(390); $mapTypeControlOptions = array(); // $gMap->mapTypeControlOptions= $mapTypeControlOptions; $gMap->setCenter(58.0201, 55.954); $icon = new EGMapMarkerImage("/img/map-icon.png"); $icon->setSize(28, 28); $icon->setAnchor(14, 14); $icon->setOrigin(0, 0); // Create GMapInfoWindows //$info_window_a = new EGMapInfoWindow('<div>Москва</div>'); $cities = Cities::model()->findAll(); if ($cities) { foreach ($cities as $city) { $info_box = new EGMapInfoBox('<div class="infoBox"><div class="infoBoxInner"><span>' . $city->city . '</span></div></div>'); // set the properties $info_box->pixelOffset = new EGMapSize('-55', '15'); $info_box->maxWidth = 0; $info_box->boxStyle = array('width' => '"186px"', 'height' => '"107px"'); $info_box->closeBoxUrl = '""'; //$info_box->closeBoxMargin = '"10px 2px 2px 2px"'; $info_box->infoBoxClearance = new EGMapSize(1, 1); $info_box->enableEventPropagation = '"floatPane"'; // Create marker if ($city->lat && $city->lng) { $marker = new EGMapMarker($city->lat, $city->lng, array('title' => $city->city, 'icon' => $icon)); //$marker->addHtmlInfoWindow($info_window_a);
public function getMenuCities($defaultCountry = 1) { $cities = Cities::model()->findAll("status=? AND countries_id=?", array(1, $defaultCountry)); return CHtml::listData($cities, "id", "name"); }
public function actionHome_owner() { if (!Yii::app()->user->isGuest) { if (Yii::app()->user->role == 'homeowner') { $this->pageTitle = 'Handyman.com - Home owner Dashboard'; $this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10)); $user_id = Yii::app()->user->id; $criteria = new CDbCriteria(); $criteria->condition = "homeowner_id = '{$user_id}'"; $count = Projects::model()->count($criteria); $pages = new CPagination($count); // results per page $pages->pageSize = 2; $pages->applyLimit($criteria); $param['projects'] = Projects::model()->findAll($criteria); $param['test'] = 'homeOwner'; $param['pages'] = $pages; $this->render('home-owner', $param); } else { $this->redirect(Yii::app()->homeUrl); } } else { $this->redirect(Yii::app()->homeUrl); } }
public function actionFind() { $location = Yii::app()->Ini->getlocationbyip(Yii::app()->Ini->rip('ip')); $projects = Projecttypes::model()->findAll(array('order' => 'Name ASC')); $criteria = new CDbCriteria(); $criteria->order = "question_id DESC"; $criteria->limit = 5; $questions = Questions::model()->findAll($criteria); $states = States::model()->findAll(array('order' => 'Name ASC')); $city = Yii::app()->Ini->v('city'); $project = Yii::app()->Ini->v('project'); $zipcode = Yii::app()->Ini->v('zipcode'); $match = Yii::app()->Ini->v('match'); $homeowner_projects = $this->getHomeOwnerProjects(); $pie = new SimplePie(); $pie->set_feed_url('http://media.handyman.com/feed/'); $pie->init(); $pie->handle_content_type(); if ($city) { $details = Cities::model()->findByAttributes(array('RewriteUrl' => $city . "/")); if (count($details) > 0) { $city_name = $details->Name; } else { $city_name = ""; } $criteria = new CDbCriteria(); $criteria->condition = "City like '%{$city_name}%'"; $count = Contractors::model()->count($criteria); $pages = new CPagination($count); // results per page $pages->pageSize = 5; $pages->applyLimit($criteria); $models = Contractors::model()->findAll($criteria); $this->render('find_result', array('models' => $models, 'pages' => $pages, 'projects' => $projects, 'records' => $count, 'city_name' => $city_name, 'location' => $city_name . ",USA", 'questions' => $questions, 'homeowner_projects' => $homeowner_projects, 'feed' => $pie)); } else { if ($project && $zipcode) { $details = Projecttypes::model()->findByAttributes(array('ProjectTypeId' => $project)); if (count($details) > 0) { $oid = $details->OID; $city_name = $details->Name; $home_advisor = Yii::app()->Ini->searchhomeadvisor($zipcode, $oid); //$home_advisor = Yii::app()->Ini->searchhomeadvisor('11741','12005'); if ($home_advisor == false) { $home_advisor_results = false; } else { $home_advisor_results = $home_advisor['serviceProvider']; } } $criteria = new CDbCriteria(); $criteria->condition = "ProjectTypeId='" . $project . "' AND Zip='" . $zipcode . "'"; $count = Contractors::model()->count($criteria); $pages = new CPagination($count); // results per page $pages->pageSize = 5; $pages->applyLimit($criteria); $models = Contractors::model()->findAll($criteria); $this->render('match-result', array('pages' => $pages, 'result' => $models, 'home_advisors' => $home_advisor_results, 'projects' => $projects, 'states' => $states, 'location' => $location, 'city_name' => $city_name . ' In Zipcode ' . $zipcode, 'questions' => $questions, 'feed' => $pie)); } else { if ($project) { $details = Projecttypes::model()->findByAttributes(array('ProjectTypeId' => $project)); if (count($details) > 0) { $city_name = $details->Name; } $criteria = new CDbCriteria(); $criteria->condition = "ProjectTypeId=" . $project; $count = Contractors::model()->count($criteria); $pages = new CPagination($count); // results per page $pages->pageSize = 5; $pages->applyLimit($criteria); $models = Contractors::model()->findAll($criteria); $this->render('find_result', array('models' => $models, 'pages' => $pages, 'projects' => $projects, 'records' => $count, 'city_name' => $city_name, 'location' => $location, 'questions' => $questions, 'homeowner_projects' => $homeowner_projects, 'feed' => $pie)); } else { if ($zipcode) { $criteria = new CDbCriteria(); $criteria->condition = "Zip='{$zipcode}'"; $count = Contractors::model()->count($criteria); $pages = new CPagination($count); // results per page $pages->pageSize = 5; $pages->applyLimit($criteria); $models = Contractors::model()->findAll($criteria); $this->render('find_result', array('models' => $models, 'pages' => $pages, 'projects' => $projects, 'records' => $count, 'city_name' => $zipcode, 'questions' => $questions, 'homeowner_projects' => $homeowner_projects, 'feed' => $pie)); } else { if ($match) { $proj = Projects::model()->findByPk($match); if (count($proj) > 0) { $proj_zipcode = $proj->zipcode; $project_type_id = $proj->project_type_id; $criteria = new CDbCriteria(); $criteria->condition = "ProjectTypeId='" . $project_type_id . "' AND Zip = '" . $proj_zipcode . "'"; $count = Contractors::model()->count($criteria); $pages = new CPagination($count); $result = Contractors::model()->findAll($criteria); $projecttypes = ProjectTypes::model()->findByPK($project_type_id); $proj_oid = $projecttypes->OID; //$proj_zipcode = '11741'; //$proj_oid = '12070'; $home_advisor = Yii::app()->Ini->searchhomeadvisor($proj_zipcode, $proj_oid); if ($home_advisor == false) { $home_advisor_results = false; } else { $home_advisor_results = $home_advisor['serviceProvider']; } $this->render('match-result', array('pages' => $pages, 'result' => $result, 'home_advisors' => $home_advisor_results, 'projects' => $projects, 'states' => $states, 'location' => $location, 'city_name' => $this->getProjectTypeName($project_type_id) . ' In Zipcode ' . $proj_zipcode, 'questions' => $questions, 'feed' => $pie)); } else { $this->render('find_form', array('projects' => $projects, 'states' => $states, 'location' => $location, 'questions' => $questions)); } } else { $this->render('find_form', array('projects' => $projects, 'states' => $states, 'location' => $location, 'questions' => $questions, 'feed' => $pie)); } } } } } }
public function getCitiesByName($city_id) { $name = ""; $details = Cities::model()->findByAttributes(array('StateId' => $state_id)); if (count($details) > 0) { $name = $details->Name; } return $name; }
public function getCities($order = 'Name ASC', $limit = null) { if ($limit) { return Cities::model()->findAll(array('order' => $order, 'limit' => $limit)); } else { return Cities::model()->findAll(array('order' => $order)); } }
public static function getCity() { $cities = Cities::model()->findAll(); foreach ($cities as $city) { $array[$city->id] = $city->city_name; } return $array; }
public function actionHome_owner() { if (!Yii::app()->user->isGuest) { if (Yii::app()->user->role == 'homeowner') { $this->pageTitle = 'Handyman.com - Home owner Dashboard'; $limit = 2; $cnt = 0; $start = 0; $this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10)); $user_id = Yii::app()->user->id; $criteria = new CDbCriteria(); $criteria->condition = "homeowner_id = '{$user_id}' LIMIT {$start},{$limit}"; $proj = Projects::model()->findAll($criteria); $criteria2 = new CDbCriteria(); $criteria2->condition = "homeowner_id = '{$user_id}'"; $proj2 = Projects::model()->findAll($criteria2); $param['projects'] = $proj; $param['page'] = "homeOwner"; $param['total_cnt'] = count($proj2); $param['display_per_page'] = $limit; $param['curr_page'] = 1; $param['display_pages'] = '2'; $this->render('home-owner', $param); } else { $this->redirect(Yii::app()->homeUrl); } } else { $this->redirect(Yii::app()->homeUrl); } }