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);
}
}
