public static function getHtmlByOutlet($addressId) { $address = Address::find($addressId); if (!empty($address)) { return Address::where('city_id', $address->city_id)->lists('address', 'id'); } return null; }
/** * Show a list of all the users formatted for Datatables. * * @return Datatables JSON */ public function getData() { $Model = $this->modelName; $models = $Model::select($this->dataTableColumns); $actions = ['<a href="{{{ URL::to(\'iframe\') }}}" data-action="edit" data-type="' . $this->name . '" data-id="{{ $id }}" data-url="{{{ URL::to(\'' . $this->name . '/\' . $id . \'/edit\' ) }}}" class="iframe btn btn-xs btn-default">{{{ Lang::get(\'button.edit\') }}}</a>', '<a href="{{{ URL::to(\'' . $this->name . '/\' . $id . \'/delete\' ) }}}" class="modal-popup btn btn-xs btn-danger">{{{ Lang::get(\'button.delete\') }}}</a>']; return Datatables::of($models)->add_column('country', function ($row) { return Address::find($row->address_id)->country->name; })->add_column('actions', implode(' ', $actions))->remove_column('id')->remove_column('address_id')->make(); }
public function test_getById() { //$this->faker->addProvider(new Faker\Provider\Internet($this->faker)); //$p=$this->faker->password; return; $customer = $this->service->getById(1); $this->assertNotNull($customer); $customer->load('defaultAddress.country', 'defaultAddress.zone', 'addresses.country', 'addresses.zone'); $sql = $customer->addresses()->toSql(); $sql = $customer->defaultAddress()->toSql(); $this->assertEquals(1, $customer->addresses->count()); $this->assertNotNull($customer->defaultAddress); $address = Address::find($customer->defaultAddress->id); $sql = $address->customer()->toSql(); $this->assertNotNull($address->customer); }
public function postConfigSave() { if (Payment::VeryPayment() == false) { return View::make('clinic.payment.renews-payment'); } $data = array("name" => Input::get("name"), "insurance" => Input::get("insurance"), "lang" => Input::get("lang"), "picture" => Input::file("picture"), "phone" => Input::get("phone")); $rules = array("name" => 'required|min:1|max:255', "insurance" => 'required|min:1|max:255', "lang" => 'required|min:1|max:10', "picture" => 'mimes:jpeg,gif,png', "phone" => 'required|numeric|min:1'); $messages = array('required' => 'El campo :attribute es obligatorio.', 'min' => 'El campo :attribute no puede tener menos de :min carácteres.', 'email' => 'El campo :attribute debe ser un email válido.', 'max' => 'El campo :attribute no puede tener más de :max carácteres.', 'numeric' => 'El campo :attribute debe contener solo numeros', 'mimes' => 'El formato de la imagen :attribute debe ser jpg, git, png'); $validation = Validator::make(Input::all(), $rules, $messages); //si la validación falla redirigimos al formulario de registro con los errores //y con los campos que nos habia llenado el usuario if ($validation->fails()) { return Redirect::to('/clinic/config-data/')->withErrors($validation)->withInput(); } else { $id = Input::get("id"); $clinic = Clinic::find($id); $clinic->name = Input::get("name"); $clinic->phone = Input::get("phone"); $clinic->insurances = Input::get("insurance"); if (Input::file('picture') != NULL) { //agrega imagen de logo $file_logo = Input::file('picture'); $ext = Input::file('picture')->getClientOriginalExtension(); $nameIMG = date('YmdHis'); $logo = $nameIMG . '.' . $ext; $logo = 'assets/clinic/images/logo/logo_' . $logo; $file_logo->move("assets/clinic/images/logo/", $logo); $clinic->picture = $logo; } $clinic->save(); $adress = Address::find($clinic->address_id); $adress->my_address = Input::get("address"); $adress->save(); $lang = Option::where('name', $clinic->id . '-clinic-lang')->first(); if ($lang) { $lang->key = Input::get("lang"); $lang->save(); } else { $langadd = new Option(); $langadd->key = Input::get("lang"); $langadd->name = $clinic->id . '-clinic-lang'; $langadd->save(); } return Redirect::back(); } }
/** * Display a listing of people * * @return Response */ public function index() { $person = Person::create(array('name' => 'Sharad')); $inputAddress = array(array('name' => 'Thamel'), array('name' => 'Thahity')); $addressIds = array(); foreach ($inputAddress as $id => $addressData) { $address = Address::find($id) ?: new Address(); $address->fill($addressData); $address->save(); $addressIds[] = $address->id; } $changes = $person->addresses()->sync($addressIds); // Delete the unused addresses /*foreach ($changes['detached'] as $detachedAddressId) { $address = Address::find($detachedAddressId); if (!empty($address)) $address->delete(); } */ }
function client_print_for_approval() { $qualifying_circulation_id = $this->params['named']['qualifying_circulation_id']; $printing_centers = $this->Session->read('Auth.PrintingCenter'); $printing_center_ids = Set::extract('/id', $printing_centers); App::import('Model', 'QualifyingCirculation'); $QualifyingCirculation = new QualifyingCirculation(); $options = array('conditions' => array('QualifyingCirculation.id' => $qualifying_circulation_id, 'QualifyingCirculation.printing_center_id' => $printing_center_ids)); $qualifyingCirculation = $QualifyingCirculation->find('first', $options); App::import('Model', 'Address'); $objAddress = new Address(); $options = array('conditions' => array('Address.id' => $qualifyingCirculation['DuplicateCopy']['0']['address_id'])); $addr = $objAddress->find('first', $options); $qualifyingCirculation['DuplicateCopy'][0]['Address'] = $addr['Address']; $qualifyingCirculation['DuplicateCopy'][0]['City'] = $addr['City']; $qualifyingCirculation['DuplicateCopy'][0]['State'] = $addr['State']; $qualifyingCirculation['DuplicateCopy'][0]['Zone'] = $addr['Zone']; $qualifyingCirculation['DuplicateCopy'][0]['Country'] = $addr['Country']; // Printing Center Details App::import('Model', 'PrintingCenter'); $objPrintingCenter = new PrintingCenter(); $optionsPrintingCenter = array('contain' => array('Address', 'Membership', 'PrintedAt', 'Membership.Publication', 'Membership.Edition'), 'conditions' => array('PrintingCenter.id' => $qualifyingCirculation['PrintingCenter']['id'])); $printingCenter = $objPrintingCenter->find('first', $optionsPrintingCenter); unset($qualifyingCirculation['PrintingCenter']['PrintingCenter']); unset($qualifyingCirculation['PrintingCenter']['QualifyingCirculation']); unset($qualifyingCirculation['PrintingCenter']['CreatedBy']); unset($qualifyingCirculation['PrintingCenter']['ModifiedBy']); unset($qualifyingCirculation['PrintingCenter']['Membership']['User']); unset($qualifyingCirculation['PrintingCenter']['Membership']['Address']); unset($qualifyingCirculation['PrintingCenter']['Membership']['Proposer1Representative']); unset($qualifyingCirculation['PrintingCenter']['Membership']['Proposer2Representative']); unset($qualifyingCirculation['PrintingCenter']['Membership']['CreatedBy']); unset($qualifyingCirculation['PrintingCenter']['Membership']['ModifiedBy']); unset($qualifyingCirculation['PrintingCenter']['Membership']['MembershipPayment']); unset($qualifyingCirculation['PrintingCenter']['Membership']['PrintingCenter']); unset($qualifyingCirculation['PrintingCenter']['Membership']['Representative']); // HoldingCompany.Address App::import('Model', 'HoldingCompany'); $objHoldingCompany = new HoldingCompany(); $optionsHoldingCompany = array('contain' => array('Address'), 'conditions' => array('HoldingCompany.id' => $printingCenter['Membership']['HoldingCompany'][0]['id'])); $holdingCompany = $objHoldingCompany->find('first', $optionsHoldingCompany); // PrintingCenterAuditorBranch App::import('Model', 'PrintingCenterAuditorBranch'); $objPrintingCenterAuditorBranch = new PrintingCenterAuditorBranch(); $optionsPrintingCenterAuditorBranch = array('contain' => array('AuditorBranch', 'AuditorBranch.AuditorFirm'), 'conditions' => array('PrintingCenterAuditorBranch.printing_center_id' => $printingCenter['PrintingCenter']['id'], 'PrintingCenterAuditorBranch.regular_period_id' => $qualifyingCirculation['QualifyingCirculation']['regular_period_id'])); $printingCenterAuditorBranch = $objPrintingCenterAuditorBranch->find('first', $optionsPrintingCenterAuditorBranch); $options = array('conditions' => array('Address.id' => $printingCenterAuditorBranch['AuditorBranch']['Address']['id']), 'contain' => array('Country', 'Zone', 'State', 'District', 'City')); $addr = $objAddress->find('first', $options); $printingCenterAuditorBranch['AuditorBranch']['Address'] = $addr['Address']; $printingCenterAuditorBranch['AuditorBranch']['Address']['Country'] = $addr['Country']; $printingCenterAuditorBranch['AuditorBranch']['Address']['Zone'] = $addr['Zone']; $printingCenterAuditorBranch['AuditorBranch']['Address']['State'] = $addr['State']; $printingCenterAuditorBranch['AuditorBranch']['Address']['District'] = $addr['District']; $printingCenterAuditorBranch['AuditorBranch']['Address']['City'] = $addr['City']; App::import('Model', 'SaleType'); App::import('Model', 'TradeTerm'); $SaleType = new SaleType(); $TradeTerm = new TradeTerm(); $saleTypes = $SaleType->find('list'); $subscriptionTypes = $TradeTerm->SubscriptionType->find('list'); App::import('Model', 'City'); $objCities = new City(); $cities = $objCities->find('all', array('conditions' => array('City.id' => Set::extract('/city_id', $qualifyingCirculation['WhiteForm'])))); $this->set(compact('saleTypes', 'subscriptionTypes', 'qualifyingCirculation', 'cities', 'printingCenter', 'holdingCompany', 'printingCenterAuditorBranch')); }
/** * Show the form for editing the specified country. * * @param int $id * @return Response */ public function editAddress($id) { $address = Address::find($id); if (!empty($address)) { $countries = array('' => '') + Country::lists('country', 'id'); $cities = array('' => '') + City::lists('city', 'id'); // Title $title = Lang::get('site/addresses/title.address_update'); // mode $mode = 'edit'; return View::make('site/addresses/create_edit', compact('title', 'mode', 'countries', 'cities', 'address')); } else { return Redirect::to('site/addresses')->with('error', Lang::get('site/addresses/messages.does_not_exist')); } }
public function listAddresses($ref_id, $ref_type) { App::uses("Address", "Model"); $address = new Address(); return $address->find("all", array('conditions' => array('id !=' => $current_item_id))); }
/** * Show the form for editing the specified address. * * @param int $id * @return Response */ public function edit($id) { $address = Address::find($id); return View::make('addresses.edit', compact('address')); }
public function getEdit($id) { $item = Item::find($id); $document = Item::find($id)->document(); $type = $item->document->os_type; switch ($type) { case 'movables' || 'value_movables': $variable = Item::find($id)->variable(); return View::make('items.edit', array('item' => $item, 'document' => $document, 'variable' => $variable)); break; case 'car': $variable = Item::find($id)->variable(); $car = Car::find($id)->car(); return View::make('items.edit', array('item' => $item, 'document' => $document, 'variable' => $variable, 'car' => $car)); break; case 'buildings': $variable = Item::find($id)->variable(); $building = Item::find($id)->building(); $address = Address::find($id)->address(); return View::make('items.edit', array('item' => $item, 'document' => $document, 'building' => $building, 'variable' => $variable, 'address' => $address)); break; case 'parcels': $parcel = Item::find($id)->parcel(); $address = Address::find($id)->address(); return View::make('items.edit', array('item' => $item, 'document' => $document, 'parcel' => $parcel, 'address' => $address)); break; } }
function _setQualifyingCirculation($printing_center_id, $regularPeriodId) { App::import('Model', 'QualifyingCirculation'); $QualifyingCirculation = new QualifyingCirculation(); $options = array('conditions' => array('QualifyingCirculation.printing_center_id' => $printing_center_id, 'QualifyingCirculation.regular_period_id' => $regularPeriodId)); $qualifyingCirculation = $QualifyingCirculation->find('first', $options); App::import('Model', 'Address'); $objAddress = new Address(); if (!empty($qualifyingCirculation['DuplicateCopy'])) { $options = array('conditions' => array('Address.id' => $qualifyingCirculation['DuplicateCopy']['0']['address_id'])); $addr = $objAddress->find('first', $options); $qualifyingCirculation['DuplicateCopy'][0]['Address'] = $addr['Address']; $qualifyingCirculation['DuplicateCopy'][0]['City'] = $addr['City']; $qualifyingCirculation['DuplicateCopy'][0]['District'] = $addr['District']; $qualifyingCirculation['DuplicateCopy'][0]['State'] = $addr['State']; $qualifyingCirculation['DuplicateCopy'][0]['Zone'] = $addr['Zone']; $qualifyingCirculation['DuplicateCopy'][0]['Country'] = $addr['Country']; } return $qualifyingCirculation; }
/** * Set value of a flag. Unsets all other addresses for that user. * Called by using Addresses::setFlagname($address) * * @param mixed $objectOrId primary address id or object instance */ private function setFlag($address) { if (!is_object($address)) { $address = Address::find($address); } if ($userId = $address->user_id) { Address::where('user_id', '=', self::userId())->update(array('is_billing' => false)); $address->{'is_billing'} = true; $address->save(); } }
$editAddress->complement = $complement; $editAddress->neighborhood = $neighborhood; $editAddress->city = $city; $editAddress->state = $state; if ($editAddress->save()) { $data['msg'] = 'Address saved successfully!'; $data['id'] = $editAddress->id; } else { $data['msg'] = 'An error occurred while saving the address!'; } $contactList->response()->header('Content-Type', 'application/json'); echo json_encode($data); }); // Delete address $contactList->delete("/addresses/:id", function ($id) use($contactList) { $address = Address::find($id); $countAddress = Address::where('contactId', '=', $address->contactId)->count(); if ($countAddress > 1) { if ($address->delete()) { $data['msg'] = 'Address deleted successfully!'; } else { $data['msg'] = 'An error occurred while deleting the address!'; } } else { $data['msg'] = 'The contact should have at least one address!'; } $contactList->response()->header('Content-Type', 'application/json'); echo json_encode($data); }); // Check email address $contactList->post("/checkemail", function () use($contactList) {
/** * Store a newly created job in storage. * * @return Response */ public function postStore() { $data = Input::all(); if ($data["job_category_id"] == "none" || intval($data["job_category_id"]) <= 0) { $data["job_category_id"] = ""; } //if($data["job_sub_category_id"]=="none"||intval($data["job_sub_category_id"])<=0) // $data["job_sub_category_id"]=null; $newAddressRequiredIf = "address_id,==,0"; $rules = array('job_title' => 'required|min:5|max:150', 'job_description' => 'required|min:10', 'start_date' => 'required|date', 'address_id' => 'required', 'favorites' => 'requiredIfAttribute:private,==,1', 'latitude' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'address1' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'city' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'state' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'zipcode' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'company_or_label' => 'requiredIfAttribute:' . $newAddressRequiredIf, 'compensation' => 'required', 'job_category_id' => 'required'); $validator = Validator::make($data, $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->withInput(); } $data["start_date"] = date("Y-m-d", strtotime($data["start_date"])); $user = Sentry::getUser(); $employer = Employer::find($user->getId()); $data["user_id"] = $user->id; $data['job_status_id'] = $employer->subscription != null && $employer->subscription->activeSubscription() ? JobStatus::$OPEN : JobStatus::$DRAFT; if ($data["address_id"] <= 0) { $data["is_primary"] = false; $data["address_type_id"] = AddressType::$OTHER; $address = Address::Create($data); $data["address_id"] = $address->id; } else { $address = Address::find($data["address_id"]); $data['company_or_label'] = $address->company_or_label; $data['address1'] = $address->address1; $data['address2'] = $address->address2; $data['state'] = $address->state; $data['city'] = $address->city; $data['zipcode'] = $address->zipcode; $data['latitude'] = $address->latitude; $data['longitude'] = $address->longitude; /* $data=array_merge($data,$address); if(trim($address['company_or_label'])=='') $data['company_or_label']='';*/ } //var_dump($data); $data['job_description'] = strip_tags($data['job_description']); if ($data['private']) { if ($data['job_status_id'] != JobStatus::$DRAFT) { $data['job_status_id'] = JobStatus::$PRIVATE; } } $job = Job::create($data); if ($data['private']) { foreach ($data['favorites'] as $fav) { JobFavorite::create(array('user_id' => $fav, 'job_id' => $job->id)); if ($data['job_status_id'] != JobStatus::$DRAFT) { $user = User::find($fav); $this->NotifyFavorite($user, $job); } } } if (isset($data['job_certification'])) { foreach ($data['job_certification'] as $cert) { JobCertification::create(array('job_id' => $job->id, 'certification_id' => $cert)); } } /*$studentAddresses=Address::join('users_groups','users_groups.user_id','=','addresses.user_id') ->join('user_notifications','user_notifications.user_id','=','addresses.user_id') ->where('user_notifications.notification_type','=',NotificationType::$EDUEMAIL) ->where('users_groups.group_id','=',Group::$STUDENT) ->select('addresses.user_id',Address::distanceSelectStatement($data['latitude'],$data['longitude'],'distance','addresses')) ->groupBy('student_job_preferences.user_id') ->having("distance","<=",50) ->get(); $studentProfiles=StudentProfile::join('student_job_preferences', 'student_job_preferences.user_id','=','student_profile.user_id') ->where('student_job_preferences.job_category_id','=',$data["job_category_id"]) ->whereIn('student_job_preferences.user_id',$studentAddresses->lists('user_id')) ->groupBy('student_job_preferences.user_id') ->get(); $studentProfiles->load('user'); var_dump($studentProfiles); */ if ($data['job_status_id'] == JobStatus::$OPEN) { //return Redirect::action("JobsController@anyShow", array("id"=>$job->id)); return Redirect::action("JobsController@anyEmployerOpen"); } else { return Redirect::action("EmployerController@anySubscription"); } }