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