public function init() { $nameProject = new Zend_Form_Element_Text('nameProject'); $nameProject->setLabel('nom Projet')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $dateBegin = new Zend_Form_Element_Text('dateBegin'); $dateBegin->setLabel('à partir de :')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $dateEnd = new Zend_Form_Element_Text('dateEnd'); $dateEnd->setLabel('jusqu\'à le :')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $budget = new Zend_Form_Element_Text('budget'); $budget->setLabel('Budget :')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $localisation = new Zend_Form_Element_Select('localisation'); $localisation->setLabel('Localisation :')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $cityModel = new City(); $selectReferenceForCity = $cityModel->select()->setIntegrityCheck(false)->from('city'); $localisation->addMultiOption(0, '-'); foreach ($cityModel->fetchAll($selectReferenceForCity) as $row) { $localisation->addMultiOption($row->city_id, $row->city_description); } $domaine = new Zend_Form_Element_Select('domaine'); $domaine->setLabel('Domaine :')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $reference = new ReferenceValue(); $selectReferenceForDomain = $reference->select()->setIntegrityCheck(false)->from('reference_values')->where('reference_values.reference_Id=5'); $domaine->addMultiOption(0, '-'); foreach ($reference->fetchAll($selectReferenceForDomain) as $row) { $domaine->addMultiOption($row->value_id, $row->name); } $statut = new Zend_Form_Element_Select('statut'); $statut->setLabel('statut :')->setRequired(false)->addFilter('StripTags')->addFilter('StringTrim')->addValidator('NotEmpty'); $statut->addMultiOptions(array('1' => 'encours', '2' => 'valide', '3' => 'suspendu')); $submit = new Zend_Form_Element_Submit('submit'); $submit->setOptions(array('label' => $this->t('Filter'), 'required' => true)); $this->setCancelLink(false); $this->addElements(array($nameProject, $dateBegin, $dateEnd, $budget, $localisation, $domaine, $statut, $submit)); }
public function run() { DB::statement("TRUNCATE TABLE addresses"); $cityId = City::select('id')->where('city', 'Da Nang')->first()->id; $address = array('306 - đường 2/9, Hai Chau', '225 Nguyễn Chí Thanh, Hai Chau', '123 Nguyen Van Linh, Hai Chau', '328 Hoang Dieu, Hai Chau', '423 Nguyen Huu Tho, Hai Chau'); foreach ($address as $add) { $address = new Address(); $address->city_id = $cityId; $address->address = $add; $address->created_at = new DateTime(); $address->updated_at = new DateTime(); $address->save(); } }
/** * Show a list of all the cities formatted for Datatables. * * @return Datatables JSON */ public function getCities() { $cities = City::select(array('id', 'city', 'created_at', 'updated_at'))->orderBy('country_id'); return Datatables::of($cities)->add_column('actions', '<a href="{{{ URL::to(\'admin/cities/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-default">{{{ Lang::get(\'button.edit\') }}}</a> <a href="{{{ URL::to(\'admin/cities/\' . $id . \'/delete\' ) }}}" class="iframe btn btn-xs btn-danger">{{{ Lang::get(\'button.delete\') }}}</a> ')->remove_column('id')->make(); }
function getCities() { $result = ['' => 'Select City']; $cities = City::select('id', 'name', 'status')->where('status', 1)->get(); foreach ($cities as $c) { $result[$c['id']] = $c['name']; } return $result; }
public static function listFilters() { $filters_data['all'] = array(array('name' => 'Вид', 'list' => Type::select('id', 'name')->get()->toArray()), array('name' => 'Финансиране', 'list' => Financing::select('id', 'name')->get()->toArray()), array('name' => 'Специалности', 'list' => Specialty::select('id', 'name')->get()->toArray())); if (Input::has('district') == false && Input::has('municipality') == false && Input::has('city') == false) { $filters_data['all'][] = array('name' => 'Област', 'list' => District::select('id', 'name')->get()->toArray()); } if (Input::has('district') == true && Input::has('municipality') == false && Input::has('city') == false) { $district = Input::get('district'); if (is_array(Input::get('district'))) { $district = end($district); } $filters_data['all'][] = array('name' => 'Община', 'previous' => 'Област', 'list' => Municipality::select('id', 'name')->where('district_id', '=', $district)->get()->toArray()); $filters_data['previous_location'] = URL::route('schools.index', Input::except('district', 'municipality', 'city')); } if (Input::has('district') == true && Input::has('municipality') == true || Input::has('municipality') == true || Input::has('city') == true) { $municipality = Input::get('municipality'); if (is_array(Input::get('municipality'))) { $municipality = end($municipality); } $filters_data['all'][] = array('name' => 'Град/село', 'previous' => 'Община', 'list' => City::select('id', 'name')->where('municipality_id', '=', $municipality)->get()->toArray()); $filters_data['previous_location'] = URL::route('schools.index', Input::except('municipality', 'city')); } $input_filter = array_filter(Input::only('city', 'district', 'financing', 'municipality', 'specialty', 'type')); if (!empty($input_filter)) { $filters_data['clean_all_filters'] = URL::route('schools.index', array_filter(Input::only('search'))); } return $filters_data; }
/** * Display the specified resource. * * @param int $id * @return Response */ public function show($id) { $cities = City::select('id', 'name as text')->find($id)->toArray(); return Response::json($cities); }