public function init()
{
$this->states = States::model()->findAll('country_id=:country_id', array(':country_id' => 1));
$this->districts = Districts::model()->findAll();
$this->functionalAreas_models = FunctionalAreas::model()->findAll();
$this->latest_posts = Post::model()->findAll(array('order' => 'id DESC', 'limit' => 5));
$this->latest_resumes = User::model()->findAllByAttributes(array('showOnSearch' => 'Y'), array('order' => 'id DESC', 'limit' => 5));
}
public function addStudent()
{
$city = ["" => "select"] + City::get_city_array();
$states = ["" => "select"] + States::state_list();
$this->layout->tab_id = 1;
$this->layout->sidebar = View::make('admin.sidebar', ["page_id" => 1, "sub_id" => 0]);
$this->layout->main = View::make('admin.students.addStudent', ["city" => $city, "states" => $states]);
}
public function initialize()
{
$state = States::getInstance();
$currentState = $state->Get(get_called_class());
if (!is_array($currentState)) {
$state->Set(get_called_class(), $this->default_state);
}
$this->state = $state;
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
//Empty the states table
DB::table(\Config::get('states.table_name'))->delete();
//Get all of the states
$states = States::getList();
foreach ($states as $stateId => $state) {
DB::table(\Config::get('states.table_name'))->insert(array('id' => $stateId, 'iso_3166_2' => $state['iso_3166_2'], 'name' => $state['name']));
}
}
$form = $this->beginWidget('bootstrap.widgets.TbActiveForm', array('id' => 'court-form', 'enableAjaxValidation' => false));
?>
<p class="help-block">Fields with <span class="required">*</span> are required.</p>
<?php
echo $form->errorSummary($model);
?>
<div style="float:left;width:200px;" >
<?php
echo $form->labelEx($model, 'state_id');
?>
<?php
echo $form->dropDownList($model, 'state_id', CHtml::listData(States::model()->findAllByPk(array(19, 7, 32), array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/dynamicdistrict2'), 'update' => '#Court_district_id'), 'empty' => 'Select State'), array('span' => 5));
?>
</div>
<div style="width:200px;" >
<?php
echo $form->labelEx($model, 'district_id');
?>
<?php
echo $form->dropDownList($model, 'district_id', CHtml::listData(District::model()->findAllByAttributes(array('states_id' => $model->state_id), array('order' => 'name ASC')), 'id', 'name'), array('span' => 13));
?>
</div>
<?php
echo $form->dropDownListControlGroup($model, 'type', array('District court' => 'District court', 'Taluka court' => 'Taluka court'), array('span' => 5));
?>
public function actionMy_account()
{
if (!Yii::app()->user->isGuest) {
if (Yii::app()->user->role == 'contractor') {
$contractor_id = Yii::app()->user->getId();
$this->pageTitle = 'Handyman.com - My Account';
$param['city'] = Cities::model()->findAll(array('order' => 'Name ASC'));
$param['state'] = States::model()->findAll(array('order' => 'Name ASC'));
$param['page'] = "account";
$param['cmodel'] = Contractors::model()->findByPk($contractor_id);
$param['projects'] = Projecttypes::model()->findAll(array('order' => 'Name ASC'));
$param['logo'] = $this->getContractorProfilePic($contractor_id);
$this->render('my-account', $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));
}
}
}
}
}
}
echo $form->textField($model, 'suburb', array('placeholder' => 'City/Suburb', 'class' => ''));
?>
<?php
echo $form->error($model, 'suburb');
?>
<?php
echo CHtml::dropDownList('country', "", array("" => "- Choose your country -", "AU" => "Australia", "NZ" => "New Zealand"), array('class' => 'selcountry', 'onchange' => 'getstateval(this)'));
?>
<?php
echo $form->error($model, 'country');
?>
<div class="" id="AuState" style="display:none;">
<?php
echo CHtml::dropDownList('region1', "", CHtml::listData(States::model()->findAll(), 'shortname', 'name'), array('class' => 'selcountry'));
?>
</div>
<div class="" id="NZRegion" style="display:none;">
<?php
echo $form->textField($model, 'region', array('placeholder' => 'State', 'class' => ''));
?>
<?php
echo $form->error($model, 'region');
?>
</div>
<?php
echo $form->textField($model, 'postcode', array('placeholder' => 'Postcode', 'class' => ''));
?>
public function getFields()
{
return array_merge(self::getBaseFields(), array('social_facebook' => array('type' => 'link', 'label' => 'Facebook', 'default' => 'ReadingPartners.org'), 'social_twitter' => array('type' => 'link', 'label' => 'Twitter', 'default' => 'readingpartners'), 'contact_street' => array('type' => 'text', 'label' => 'Street', 'default' => ''), 'contact_city' => array('type' => 'text', 'label' => 'City', 'default' => ''), 'contact_state' => array('type' => 'select', 'label' => 'State', 'options' => States::getAll(), 'default' => ''), 'contact_zip' => array('type' => 'text', 'label' => 'Zip', 'default' => ''), 'contact_email' => array('type' => 'email', 'label' => 'Email', 'default' => ''), 'contact_phone' => array('type' => 'text', 'label' => 'Phone', 'default' => ''), 'analytics_key' => array('type' => 'text', 'label' => 'Google Analytics ID', 'default' => ''), 'analytics_tag_manager_key' => array('type' => 'text', 'label' => 'Google Tag Manager ID', 'default' => '')));
}
public function editMember($member_id)
{
$member = Member::find($member_id);
$cities = ["" => "select"] + City::get_city_array();
$centers = ["" => "select"] + Center::get_center_array();
$member_types = ["" => "select"] + Member::member_types();
$states = States::state_list();
return html_entity_decode(View::make('admin.manage.members.add', ["member" => $member, "centers" => $centers, "cities" => $cities, "states" => $states, 'member_types' => $member_types]));
}
<?php
echo $form->dropDownList($model, 'country', $list, array('class' => 'form-control', 'empty' => 'Select Country', 'style' => 'text-transform: capitalize'));
?>
<?php
echo $form->error($model, 'country');
?>
</div>
</div>
<div class="form-group">
<?php
echo $form->labelEx($model, 'state', array('class' => 'col-sm-offset-2 col-sm-2'));
?>
<div class="col-sm-4">
<?php
$list = CHtml::listData(States::model()->findAll(array('order' => 'state')), 'id', 'state');
?>
<?php
echo $form->dropDownList($model, 'state', $list, array('class' => 'form-control', 'empty' => 'Select State', 'style' => 'text-transform: capitalize', 'ajax' => array('type' => 'POST', 'url' => CController::createUrl('districts', array('form' => 'Employer')), 'update' => '#Employer_district')));
?>
<?php
echo $form->error($model, 'state');
?>
</div>
</div>
<div class="form-group">
<?php
echo $form->labelEx($model, 'district', array('class' => 'col-sm-offset-2 col-sm-2'));
?>
<div class="col-sm-4">
public function actionMy_account()
{
if (!Yii::app()->user->isGuest) {
if (Yii::app()->user->role == 'contractor') {
$contractor_id = Yii::app()->user->getId();
$this->pageTitle = 'Handyman.com - My Account';
$param['city'] = Cities::model()->findAll(array('order' => 'Name ASC'));
$param['state'] = States::model()->findAll(array('order' => 'Name ASC'));
$param['page'] = "account";
$param['cmodel'] = Contractors::model()->findByPk($contractor_id);
//$param['csocials'] = ContractorSocials::model()->findbyAttributes(array('contractor_id' => $contractor_id));
$socials = Socials::model()->findAll(array('order' => 'social ASC'));
$user_socials = array();
foreach ($socials as $k => $v) {
$value = ContractorSocials::model()->findbyAttributes(array('contractor_id' => $contractor_id, 'social_id' => $v->social_id));
if (count($value) > 0) {
$user_socials[$v->social_id] = $value->value;
} else {
$user_socials[$v->social_id] = "";
}
}
$param['socials'] = $socials;
$param['user_socials'] = $user_socials;
$param['clicense'] = ContractorLicense::model()->findbyAttributes(array('contractor_id' => $contractor_id));
$param['cbond'] = ContractorBond::model()->findbyAttributes(array('contractor_id' => $contractor_id));
$param['projects'] = Projecttypes::model()->findAll(array('order' => 'Name ASC'));
$param['logo'] = $this->getContractorProfilePic($contractor_id);
$this->render('my-account', $param);
} else {
$this->redirect(Yii::app()->homeUrl);
}
} else {
$this->redirect(Yii::app()->homeUrl);
}
}
/**
* 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 States the loaded model
* @throws CHttpException
*/
public function loadModel($id)
{
$model = States::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
* Render state as label
*
* @param string $key
* @return array|null
*/
public function renderData($key)
{
$value = $this->_getData($key);
switch ($key) {
case 'state':
$states = $this->states->toOptionArray();
return $states[$value];
}
return parent::renderData($key);
}
public function actionStates()
{
$states = array();
if (!empty($_POST['cnt_id'])) {
$criteria = new CDbCriteria();
$criteria->order = "st_name ASC";
$criteria->condition = "st_cnt_id=:st_cnt_id";
$criteria->params = array(':st_cnt_id' => $_POST['cnt_id']);
$statesData = States::model()->findAll($criteria);
$states = CHtml::listData($statesData, 'st_id', 'st_name');
}
$this->renderPartial('_states', array('states' => $states));
}
<label>Police Staion</label>
<?php
echo $form->dropDownList($model, 'police_stations_id', CHtml::listData(PoliceStations::model()->findAll(array('order' => 'id ASC')), 'id', 'name'), array('span' => 5, 'empty' => '--Select Police Station--', 'style' => 'display:;'));
?>
</span>
<?php
echo $form->dropDownListControlGroup($model, 'role', array('Court Staff' => 'Court Staff', 'Judicial Officer' => 'Judicial Officer', 'Police Official' => 'Police Official'), array('span' => 5));
?>
<div id="select_state" style="display:none;">
<label>Select State</label>
<?php
echo $form->dropDownList($model, 'state_id', CHtml::listData(States::model()->findAll(array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/dynamicdistrict3'), 'update' => '#User_district_id', 'data' => array('role' => 'js:document.getElementById("User_role").value', 'state' => 'js:this.value')), 'empty' => 'Select State'), array('span' => 5));
?>
</div>
<div id="select_district" style=";display:none;" >
<label>Select District</label>
<?php
//echo $form->dropDownList($model,'district_id',CHtml::listData(District::model()->findAllByAttributes(array('states_id'=>$model->state_id),array('order' => 'name ASC')), 'id', 'name'),array('empty'=>'---Select State first---','span'=>5));
?>
<?php
echo $form->dropDownList($model, 'district_id', CHtml::listData(District::model()->findAllByAttributes(array('states_id' => $model->state_id), array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/masters'), 'update' => '#User_master_id', 'data' => array('role' => 'js:document.getElementById("User_role").value', 'district' => 'js:this.value')), 'empty' => 'Select District'), array('span' => 5));
?>
</div>
<?php
echo $form->dropDownListControlGroup($model, 'master_id', array(), array('empty' => '---Select Role first---', 'span' => 5));
public static function state_list()
{
return States::lists('name', 'id');
}
<?php
echo $form->dropDownListControlGroup($model, 'zone_id', CHtml::listData(Zone::model()->findAll(array('order' => 'id ASC')), 'id', 'zone'), array('span' => 5));
?>
<?php
echo $form->textFieldControlGroup($model, 'police_station_id', array('span' => 5));
?>
<div id="select_district" >
<label>Select District</label>
<?php
//echo $form->dropDownList($model,'district_id',CHtml::listData(District::model()->findAllByAttributes(array('states_id'=>$model->state_id),array('order' => 'name ASC')), 'id', 'name'),array('empty'=>'---Select State first---','span'=>5));
?>
<?php
echo $form->dropDownList($model, 'state_id', CHtml::listData(States::model()->findAllByPk(array(19, 7, 32)), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('placeOfPosting/courts'), 'update' => '#PlaceOfOffence_court_id', 'data' => array('state_id' => 'js:this.value')), 'empty' => 'Select District'), array('span' => 5));
?>
</div>
<?php
echo $form->dropDownListControlGroup($model, 'court_id', CHtml::listData(Court::model()->findAll(array('order' => 'id ASC')), 'id', 'name'), array('span' => 5));
?>
<div class="form-actions">
<?php
echo TbHtml::submitButton($model->isNewRecord ? 'Create' : 'Save', array('color' => TbHtml::BUTTON_COLOR_PRIMARY, 'size' => TbHtml::BUTTON_SIZE_LARGE));
?>
</div>
<?php
$this->endWidget();
/**
* render state dropdown list.
*/
public static function render($selected)
{
return States::createDropDownList($selected);
}
<?php
echo $form->textFieldControlGroup($model, 'judge_code', array('span' => 5, 'maxlength' => 45));
?>
<?php
echo $form->dropDownListControlGroup($model, 'designation_id', CHtml::listData(JudgeDesignation::model()->findAll(array('order' => 'id ASC')), 'id', 'designation'), array('span' => 5));
?>
<?php
echo $form->dropDownListControlGroup($model, 'state_id', CHtml::listData(States::model()->findAllByPk(array(19, 7, 32), array('order' => 'name ASC')), 'id', 'name'), array('ajax' => array('type' => 'POST', 'url' => CController::createUrl('states/dynamicdistrict3'), 'update' => '#Judge_district_id'), 'empty' => 'Select State'), array('span' => 8));
?>
<?php
echo $form->dropDownListControlGroup($model, 'district_id', CHtml::listData(States::model()->findAll(array('order' => 'name ASC')), 'id', 'name'), array('empty' => '--Select state first--', 'span' => 5));
?>
<?php
echo $form->dropDownListControlGroup($model, 'gender', array('Male' => 'Male', 'Female' => 'Female'), array('empty' => '--Select--', 'span' => 5));
?>
<div class="form-actions">
<?php
echo TbHtml::submitButton($model->isNewRecord ? 'Create' : 'Save', array('color' => TbHtml::BUTTON_COLOR_PRIMARY, 'size' => TbHtml::BUTTON_SIZE_LARGE));
?>
</div>
<?php
$this->endWidget();
?>
public function getStateByName($state_id)
{
$name = "";
$details = States::model()->findByAttributes(array('StateId' => $state_id));
if (count($details) > 0) {
$name = $details->Name;
}
return $name;
}
public function actionPrivacy()
{
$this->pageTitle = 'Handyman.com - Privacy Policy';
$this->cities = Cities::model()->findAll(array('order' => 'RAND()', 'limit' => 10));
$param['projects'] = Projecttypes::model()->findAll(array('order' => 'Name ASC'));
$param['city'] = Cities::model()->findAll(array('order' => 'Name ASC'));
$param['state'] = States::model()->findAll(array('order' => 'Name ASC'));
$this->render('privacy', $param);
}
function __construct()
{
$this->fileContentsArray = file($_SERVER['DOCUMENT_ROOT'] . '/states/states.txt');
foreach ($this->fileContentsArray as $stateRow) {
$tempArr = explode(", ", rtrim($stateRow));
$this->statesArray[array_shift($tempArr)] = $tempArr;
}
}
function listStates()
{
$this->printResultArray(array_keys($this->statesArray));
}
function searchEntities($firstLetter, $useColumn)
{
$this->searchBirdString = $firstLetter;
$statesValues = array_values($this->statesArray);
$birdsArray = array_column($statesValues, $useColumn);
$filteredArray = array_filter($birdsArray, function ($bird) {
return strcasecmp($this->searchBirdString, substr($bird, 0, 1)) === 0;
});
$this->printResultArray(array_unique($filteredArray));
}
private function printResultArray($resultArray)
{
print implode(",<br/>", $resultArray) . "<br/>";
}
}
$states = new States();
$states->listStates();
$states->searchEntities('a', States::SEARCH_FOR_CAPITALS);
$states->searchEntities('b', States::SEARCH_FOR_BIRDS);
