public function actionAdmin() { $this->rememberPage(); $model = new Region('search'); $model->setRememberScenario('region_remember'); $this->render('admin', array_merge(array('model' => $model), $this->params)); }
public function get() { $uid = (int) $_REQUEST['uid']; if ($uid == 0) { $uid = $this->user->id; } $user = new User(); $user->get($uid); $userData = $user->getRaw(); //region data $region = new Region(); $regionData = $region->getRaw($userData['region']); $userData['region'] = array('id' => $regionData['id'], 'name' => $regionData['name']); //counrry data $country = new Country(); $countryData = $country->getRaw($userData['country']); $userData['country'] = array('id' => $countryData['id'], 'name' => $countryData['name']); // myself if ($uid == $this->user->id) { $currencyQuantity = $user->getCurrency($userData['currency']); $userData['currencyName'] = $userData['currency']; $userData['currency'] = $currencyQuantity; } else { unset($userData['gold']); unset($userData['currency']); } unset($userData['password']); return $userData; }
public function searchDestination($mro) { try { //echo 'LMwebSoapClient searchDestination'; $result = $this->sc->searchDestinations(array('mro' => $mro->getParamsAsArray()))->return; } catch (Exception $ex) { echo $ex->getMessage(); return null; } if ($result->destinations->info == "NOHIT") { Template::errorTemplate("Keine Treffer gefunden"); return null; } $regionList = array(); if (is_array($result->destinations->regionList)) { foreach ($result->destinations->regionList as $value) { $region = new Region(); $region->setParamsByArray($value); array_push($regionList, $region); } } else { $region = new Region(); $region->setParamsByArray($result->destinations->regionList); array_push($regionList, $region); } return $regionList; }
function encoder_redirect_success(Region $new_region) { $new_region_name = $new_region->getRegionName(); $dir = "VIEW/html/Encoder/Add_Place/Add_Place_Region_inc.php?success=1&Region_Name={$new_region_name}"; $url = BASE_URL . $dir; header("Location:{$url}"); //redirect the encoder to the regions add place exit; }
public function actionCheckParent() { $id = $_POST['val']; $region = new Region(); $model = $region->getRegionListByParentId($id); if (!empty($model)) { $this->renderPartial('checkParent', array()); } else { echo "null"; } }
public function create() { $region = new Region(); if ($this->input->post("name")) { $region->populate($this->input->post()); if ($region->save()) { Notification::set(Regions::SUCCESS, "The region has been added"); redirect("/regions/"); } } $this->data["region"] = $region; $this->load->view("regions/create.tpl", $this->data); }
/** * @param Region $region * @return bool * this function will add the region to the data base * takes region parameter */ function Add_Region(Region $region) { $Region_Name = $region->getRegionName(); $Region_Name_Amharic = $region->getRegionNameAmharic(); //add the region to the region database $query = "INSERT INTO region (Name,Name_Amharic) VALUES('{$Region_Name}','{$Region_Name_Amharic}')"; $result = mysqli_query($this->getDbc(), $query); if ($result) { return TRUE; } else { return FALSE; } }
/** @test **/ public function testLinkingMode() { $region = new Region(); $this->assertEquals("current", $region->LinkingMode()); $region->ID = 1; $this->assertEquals("link", $region->LinkingMode()); for ($i = 2; $i <= 4; $i++) { $region->ID = $i; $this->assertEquals("link", $region->LinkingMode()); } //$r1 = new RegionsPage_Controller(); //$r1->setRequest()->param('ID') = '2'; //var_dump($r1->getRequest()->param('ID')); }
public function getAllPaginated($start = 0, $pageSize = 20, $filter = "") { $theQuery = sprintf("SELECT `sights`.`id`,\n\t\t\t`sights`.`name`,\n\t\t\t`sights`.`description`,\n\t\t `sights`.`subcat_id`,\n\t\t\t`sights`.`validated`,\n\t\t\t`sights`.`address`,\n\t\t `sights_categories`.`id` as cat_id,\n\t\t `sights_categories`.`name` as cat_name,\n `localities`.`name` as loc_name,\n `localities`.`region_id` as region_id,\n `localities`.`latitudine` as latitude,\n `localities`.`longitudine`as longitude\n\t\t \tFROM `sights`\n\t\t LEFT JOIN `sights_categories`\n\t\t \tON `sights`.`cat_id` = `sights_categories`.`id`\n LEFT JOIN `localities`\n ON `sights`.`locality_id` = `localities`.`id`\n %s\n LIMIT %d, %d", $filter, $start, $pageSize); $query = $this->db->query($theQuery); $rez = []; $sCat = new SightCategory(); $reg = new Region(); foreach ($query->result_array() as $row) { $row["subcat_name"] = $sCat->getCategNameById($row["subcat_id"]); $row["region"] = $reg->getNameById($row["region_id"]); $rez[] = $row; } return $rez; }
public function __construct($sponsor_id = 0) { parent::__construct('sponsor', $sponsor_id); if ($sponsor_id) { $region = new Region($this->region_id(), $this->region_type()); $office = new Office($this->office_id()); $this->sponsor_id = $sponsor_id; $this->office = $this->title(); $this->full_name = $this->name_first() . ' ' . $this->name_last(); $this->img_name = $this->image(); $this->public_image = $this->get_image_src(); $this->image = $this->get_image_src(); $this->region = $region->city_name(); } }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { // $rules = array("regionId" => "required", "regionName" => "required"); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::to('/region/create')->withErrors($validator); } // $region = new Region(); $region->regionID = Input::get('regionId'); $region->regionName = Input::get('regionName'); $region->save(); return Redirect::to('/region'); }
public function editAction($dealerId = NULL) { $this->view->setVar("title", "Редагування дилера"); $user = $this->session->get("user"); $methodistBrands = \BrandsMethodists::find("user_id=" . $user->id)->toArray(); $methodistActivities = \ActivitiesMethodists::find("user_id=" . $user->id)->toArray(); $dealer = $dealerId ? \Dealers::findFirst($dealerId) : new \Dealers(); if ($dealerId and !$dealer->id) { // не найден такой диллер $this->view->pick("dealer/not-found"); return; } $city = $dealer->City; $this->view->regionId = $city ? $city->Region->id : NULL; $dealerBrands = $dealer->id ? $dealer->DealersBrands->toArray() : array(); $dealerActivities = $dealer->id ? \DealersActivities::find("dealer_id=" . $dealer->id)->toArray() : array(); $this->view->dealers = \Dealers::find(array('order' => 'title')); $this->view->regions = \Region::find(); $this->view->regionFirst = $this->view->regions[0]; $this->view->cities = \City::find(); $this->view->staffListGroup = \StafflistGroup::find(); $this->view->brands = BrandsService::getForChosenEntity(\Brands::find()->toArray(), $methodistBrands, $dealerBrands); $this->view->activities = ActivitiesService::getForChosenEntity(\Activities::find()->toArray(), $methodistActivities, $dealerActivities); $this->view->dealerStatuses = \DealerStatuses::find(); $controllers = \Users::query()->rightJoin("UserGroups")->where("UserGroups.group_id = 3")->execute(); $this->view->controllers = $controllers; $this->view->dealerControllers = $dealer->DealersControllers; $this->view->dealer = $dealer; $this->view->saved = $this->request->get("saved"); }
public function getMyprofile() { $id = Auth::user()->id; $alumni_id = null; $sql = "SELECT * FROM alumni WHERE account_id = ?"; $prof = DB::select($sql, array($id)); if ($prof != null) { $alumni_id = $prof[0]->id; } $sql2 = "SELECT * FROM degree WHERE alumni_id = ?"; $deg = DB::select($sql2, array($alumni_id)); $sql3 = "SELECT * FROM work_experience WHERE alumni_id = ?"; $wrk_exp = DB::select($sql3, array($alumni_id)); $sql4 = "SELECT * FROM certificate WHERE alumni_id = ?"; $certificate = DB::select($sql4, array($alumni_id)); // $sql5 = "SELECT * FROM alumni_tracer WHERE alumni_id = ?"; $sql5 = "SELECT at.*, sq.question, sc.choice\n\t\t\t\tFROM alumni_tracer AS at\n\t\t\t\tINNER JOIN survey_questions AS sq\n\t\t\t\tON sq.id = at.question_id\n\t\t\t\tINNER JOIN survey_choices AS sc\n\t\t\t\tON sc.id = at.choice_id\n\t\t\t\tWHERE at.alumni_id = ?\n\t\t\t\tORDER BY at.question_id"; $a_tracer = DB::select($sql5, array($alumni_id)); $dept = Department::all(); $region = Region::all(); $province = Province::all(); $occupation = Occupation::all(); $company = Company::all(); $deg_title = DegreeTitle::all(); $school = School::all(); $jobs = Job::all(); $field = Field::all(); $questions = DB::select("SELECT * FROM survey_questions"); $civil_status = DB::select("SELECT * FROM civil_status"); return View::make('user.profile')->with('company', $company)->with('field', $field)->with('occupation', $occupation)->with('work_exp', $wrk_exp)->with('degree', $deg)->with('a_tracer', $a_tracer)->with('certificate', $certificate)->with('school', $school)->with('deg_title', $deg_title)->with('profile', $prof)->with('dept', $dept)->with('region', $region)->with('province', $province)->with('civil_status', $civil_status)->with('questions', $questions)->with('jobs', $jobs); }
protected function fieldRegion($jsAction = "") { $output = ""; $allRegions = Region::getAllRows(); echo "HERE"; $output .= "<select name=\"" . static::regionIdFieldName . "\" {$jsAction}>\n"; /* The following logic will determine the selected option */ /* Chose a do...while() in order to avoid code duplication for the 'selected' option logic */ $regionId = static::anyRegionCode; $regionName = "Any region"; $firstRow = true; do { if (!$firstRow) { $regionId = Region::getRegionId($row); $regionName = Region::getRegionName($row); } else { $firstRow = false; } if ($this->searchedRegionId == $regionId) { $selected = "selected"; } else { $selected = ""; } /* here is the actual option output */ $output .= " <option {$selected} value =\"{$regionId}\">{$regionName}</option>\n"; } while (($row = $allRegions->fetch_row()) != NULL); $output .= "</select>\n"; return $output; }
public function updateCMSFields(FieldList $fields) { $fields->insertBefore(new Tab('MembershipDetails', 'Membership Details'), 'Main'); //move first and ;astname $fields->addFieldToTab('Root.MembershipDetails', $fields->dataFieldByName('FirstName')); $fields->addFieldToTab('Root.MembershipDetails', $fields->dataFieldByName('Surname')); $fields->addFieldToTab('Root.MembershipDetails', $fields->dataFieldByName('Email')); $fields->addFieldToTab('Root.MembershipDetails', $region = DropdownField::create('RegionID', 'Region', Region::get()->map('ID', 'Title'))); $region->setEmptyString(' '); $fields->addFieldToTab('Root.MembershipDetails', DropdownField::create('MembershipStatus', 'Membership Status', $this->owner->dbObject('MembershipStatus')->enumValues())); $fields->addFieldToTab('Root.MembershipDetails', $expiry = DateField::create('ExpiryDate')); $fields->addFieldToTab('Root.MembershipDetails', DropdownField::create('Discount', 'Discount', $this->owner->dbObject('Discount')->enumValues())); $fields->addFieldToTab('Root.MembershipDetails', $discountExpiry = DateField::create('DiscountExpiryDate')); $fields->addFieldToTab('Root.MembershipDetails', $joined = DateField::create('JoinedDate')); $fields->addFieldToTab('Root.MembershipDetails', TextareaField::create('NotesForMember')); if ($this->owner->MembershipStatus !== "Not applied") { $fields->addFieldToTab('Root.MembershipDetails', TextField::create('MemberNumber')); } $fields->addFieldToTab('Root.MembershipDetails', TextField::create('HomePhone')); $fields->addFieldToTab('Root.MembershipDetails', TextField::create('WorkPhone')); $fields->addFieldToTab('Root.MembershipDetails', TextField::create('MobilePhone')); $fields->addFieldToTab('Root.MembershipDetails', TextareaField::create('Address')); $fields->addFieldToTab('Root.MembershipDetails', TextField::create('Occupation')); $fields->addFieldToTab('Root.MembershipDetails', TextField::create('BirthDate')); $expiry->setConfig('showcalendar', true); $expiry->setConfig('showdropdown', true); $expiry->setConfig('dateformat', 'dd-MM-YYYY'); $discountExpiry->setConfig('showcalendar', true); $discountExpiry->setConfig('showdropdown', true); $discountExpiry->setConfig('dateformat', 'dd-MM-YYYY'); $joined->setConfig('showcalendar', true); $joined->setConfig('showdropdown', true); $joined->setConfig('dateformat', 'dd-MM-YYYY'); }
protected function prepareMailData() { $product = Tree::find($this->getPreparedItem('id_catalog')); $city = City::find($this->getPreparedItem('id_city')); if ($city) { $region = Region::find($city->id_region); } //$occupation = Occupation::find($this->getPreparedItem('id_occupation')); $this->setMessageSubject('Заявка на услугу: ' . $product->title_ru); $this->appendMessageBody("<html><body>"); $this->appendMessageBody("<p><b>Заявка на услугу:</b> " . $product->title_ru . "</p>"); $this->appendMessageBody("<p><b>Фамилия:</b> " . $this->getPreparedItem('last_name') . "</p>"); $this->appendMessageBody("<p><b>Имя:</b> " . $this->getPreparedItem('first_name') . "</p>"); $this->appendMessageBody("<p><b>Отчество:</b> " . $this->getPreparedItem('patronymic_name') . "</p>"); //$this->appendMessageBody("<p><b>Занятость:</b> ". $occupation->title_ru ."</p>"); $this->appendMessageBody("<p><b>Email:</b> " . $this->getPreparedItem('email') . "</p>"); $this->appendMessageBody("<p><b>Контактный телефон:</b> " . $this->getPreparedItem('phone_number') . "</p>"); if (isset($region) && $region) { $this->appendMessageBody("<p><b>Область:</b> " . $region->title_ru . "</p>"); } $this->appendMessageBody("<p><b>Город:</b> " . $city->title_ru . "</p>"); $this->appendMessageBody("<p><b>Клиент банка:</b> " . ($this->getPreparedItem('is_bank_client') ? 'Да' : 'Нет') . "</p>"); if ($this->getPreparedItem('partner_code')) { $this->appendMessageBody("<p><b>Код партнера:</b> " . $this->getPreparedItem('partner_code') . "</p>"); } $this->appendMessageBody("<html><body>"); }
public static function newInstance() { if( !self::$instance instanceof self ) { self::$instance = new self; } return self::$instance; }
public function create() { $paises = Pais::all(); $estados = Region::all(); $categorias = CategoriasNegocio::lists('nombre', 'id'); return View::make('negocios.create')->with('paises', $paises)->with('estados', $estados)->with('categorias', $categorias); }
/** * List region by country code * * @url GET /country/$code/region */ public function getRegionbyCountry($code) { if ($code) { return Region::newInstance()->findByCountry($code); } return array(); }
public function getNonCurrentRegions() { if (null === $this->_nonCurrentRegions) { $this->_nonCurrentRegions = Region::model()->findAll('id != :regionId', array(':regionId' => $this->currentRegion->id)); } return $this->_nonCurrentRegions; }
public function utcToLocal($datetime) { $region = Region::model()->findByPk(Yii::app()->session['region']); $timeZoneName = $region->time_zone; $timezone = new DateTimeZone($timeZoneName); $offset = $timezone->getOffset(new DateTime()); return strtotime($datetime) + $offset; }
public function show(SS_HTTPRequest $request) { $region = Region::get()->byID($request->param('ID')); if (!$region) { return $this->httpError(404, 'That region could not be found'); } return array('Region' => $region, 'Title' => $region->Title); }
/** * @return Region */ public function getRegion() { //lazy load the region if ($this->_region === null) { $this->_region = Region::finder()->findByPk($this->RegionID); } return $this->_region; }
public function loadRegion($id) { $model = Region::model()->findByPk($id); if (null === $model) { throw new CHttpException(404, Yii::t('app', 'The requested page does not exist.')); } return $model; }
/** * Show the form for creating a new resource. * * @return Response */ public function create() { // $newId = Supplier::generateId(); $areas = Area::all(); $regions = Region::all(); return View::make('supplier.new', ['id' => $newId, 'areas' => $areas, 'regions' => $regions]); }
/** * Show the form for creating a new resource. * * @return Response */ public function create() { // $newId = Warehouse::generateId(); $areas = Area::all(); $regions = Region::all(); return View::make('warehouse.new', ['id' => $newId, 'areas' => $areas, 'regions' => $regions]); }
function FieldHolder() { $regions = Region::shipping_regions(); $jsonRegions = json_encode($regions); Requirements::javascript(THIRDPARTY_DIR . '/jquery/jquery.js'); Requirements::javascriptTemplate('swipestripe/javascript/RegionField.js', array("regions" => $jsonRegions, 'defaultValue' => $this->Value())); return parent::FieldHolder(); }
public function getCMSFields() { $fields = FieldList::create(TabSet::create('Root')); $fields->addFieldsToTab('Root.Main', array(TextField::create('Title'), TextareaField::create('Description'), CurrencyField::create('PricePerNight', 'Price (per night)'), DropdownField::create('Bedrooms')->setSource(ArrayLib::valuekey(range(1, 10))), DropdownField::create('Bathrooms')->setSource(ArrayLib::valuekey(range(1, 10))), DropdownField::create('RegionID', 'Region')->setSource(Region::get()->map('ID', 'Title'))->setEmptyString('-- Select a region --'), CheckboxField::create('FeaturedOnHomepage', 'Feature on homepage'))); $fields->addFieldToTab('Root.Photos', $upload = UploadField::create('PrimaryPhoto', 'Primary photo')); $upload->getValidator()->setAllowedExtensions(array('png', 'jpeg', 'jpg', 'gif')); $upload->setFolderName('property-photos'); return $fields; }
public function processRegion($patientquery, $visitquery, $value, $title = "") { if ($value != "all") { $title .= " From " . Region::find($value)->region . " Region "; $patientquery->whereIn('id', PatientReport::where('region', $value)->get()->lists('patient_id') + array('0')); $visitquery->whereIn('id', PatientInfo::where('region', $value)->get()->lists('visit_id') + array('0')); } return array($patientquery, $visitquery, $title); }
public function region(SS_HTTPRequest $r) { $region = Region::get()->byID($r->param('ID')); if (!$region) { return $this->httpError(404, 'That region was not found'); } $this->articleList = $this->articleList->filter(array('RegionID' => $region->ID)); return array('SelectedRegion' => $region); }