public function get($zip = null, $ken_furi = null, $city_furi = null, $town_furi = null) { $addr = new Models\Address(); /** @var \Illuminate\Database\Query\Builder $q */ $q = $addr->newQuery(); $decoded_zip = Models\Address::processZip($zip); $q->orWhere('zip', '=', $decoded_zip); foreach (['ken_furi', 'city_furi', 'town_furi'] as $col) { Models\Address::filterQueryFuri(${$col}, $q, $col); } /** @var \Illuminate\Database\Eloquent\Collection|static[] $results */ $columns = ['ken_id', 'zip', 'ken_name', 'ken_furi', 'city_name', 'city_furi', 'town_name', 'town_furi', 'kyoto_street', 'block_name', 'office_name', 'office_address']; $results = $q->take(10)->get($columns); // NULLのフィールドを省略 $resultsArray = array_map(function ($result) use($columns) { foreach ($columns as $col) { if (array_key_exists($col, $result) && ($result[$col] === 'NULL' || trim(mb_convert_kana($result[$col], 's')) === '')) { unset($result[$col]); } } return $result; }, $results->toArray()); $date = date('Y/m/d H:i:s'); return $results->count() > 0 ? response()->json(['error' => 'success', 'date' => $date, 'count' => $results->count(), 'results' => $resultsArray]) : response()->json(['error' => 'error', 'date' => $date, 'count' => 0]); }
/** * Creates a new Person model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Person(); $address = new Address(); if ($model->load(Yii::$app->request->post()) && $address->load(Yii::$app->request->post()) && $model->save()) { // if (Yii::$app->request->isAjax) // return $this->renderAjax('view', [ // 'model' => $model, // ]); Yii::$app->getSession()->addFlash('success', "Запись \"{$model->fullName}\" успешно добавлена."); return $this->redirect(Url::previous() != Yii::$app->homeUrl ? Url::previous() : ['view', 'id' => $model->id]); } else { if (Yii::$app->request->referrer != Yii::$app->request->absoluteUrl) { Url::remember(Yii::$app->request->referrer ? Yii::$app->request->referrer : null); } // if (Yii::$app->request->isAjax) // return $this->renderAjax('_form', [ // 'model' => $model, // 'address' => $address, // ]); if (!Yii::$app->request->isPost) { $model->load(Yii::$app->request->get()); } return $this->render('create', ['model' => $model, 'address' => $address]); } }
public function testShouldUpdateCurrentLocation() { $currentLocation = null; $latitude = -23.48033; $longitude = -46.63459; $city = new City(); $city->setName("São Paulo"); $city->setState("SP"); $address = new Address(); $address->setCity($city); $address->setStreet("Rua Funchal"); $address->setDistrict("Vila Olímpia"); $api = $this->getMock("ApontadorApi", array("revgeocode")); $api->expects($this->once())->method("revgeocode")->with($latitude, $longitude)->will($this->returnValue($address)); $locationController = new LocationController(); $locationController->setApi($api); $locationController->disableSession(); $locationController->update($latitude, $longitude); $current = $locationController->current(); $currentLocation = new Location($current['location']); $this->assertNotNull($currentLocation); $this->assertSame("SP", $currentLocation->getAddress()->getCity()->getState()); $this->assertSame("São Paulo", $currentLocation->getAddress()->getCity()->getName()); $this->assertSame("Vila Olímpia", $currentLocation->getAddress()->getDistrict()); $this->assertSame("Rua Funchal", $currentLocation->getAddress()->getStreet()); $this->assertSame($latitude, $currentLocation->getPoint()->getLat()); $this->assertSame($longitude, $currentLocation->getPoint()->getLng()); }
public function store(Request $request) { $address_data = $this->collectAddressFormData($request); $address = new Address(); $address_model = $address->create($address_data); return $address_model; }
/** * @covers \App\Services\Factories\AddressFactory::modify() */ public function testModify() { $address = new Address(array('street_1' => 'Foo_street_1', 'street_2' => 'Foo_street_2', 'number' => 15, 'box' => 'Foo_box', 'district' => 'Foo_district', 'postal_code' => 'Foo_postal_code', 'city' => 'Foo_city', 'country' => 'us', 'latitude' => 'Foo_latitude', 'longitude' => 'Foo_longitude')); $address->save(); $input = array('street_1' => 'Bar_street_1', 'street_2' => 'Bar_street_2', 'number' => 17, 'box' => 'Bar_box', 'district' => 'Bar_district', 'postal_code' => 'Bar_postal_code', 'city' => 'Bar_city', 'country' => 'be', 'latitude' => 'Bar_latitude', 'longitude' => 'Bar_longitude'); $this->addressFactory->modify($address, $input); $addressRepository = App::make('\\App\\Repositories\\Eloquent\\EloquentAddressRepository'); $this->assertEquals(1, $addressRepository->all()->count()); $this->assertEquals('Bar_street_1', $addressRepository->all()->first()->street_1); }
public function notify(Request $request) { \Log::debug('payment_notify', ['request' => $request]); $input = XML::parse($request->getContent()); if ($input['return_code'] == 'SUCCESS') { $order = Order::where('wx_out_trade_no', $input['out_trade_no'])->firstOrFail(); $address_id = $order->address_id; # 当前订单收货地址id if ($order->isPaid()) { return 'FAIL'; } $order->update(['wx_transaction_id' => $input['transaction_id'], 'cash_payment' => floatval($input['total_fee']) / 100.0]); $order->paid(); /* 发送消息提醒 */ $default_address = Address::where(['id' => $address_id])->first(); $phone = $default_address->phone; $msg = '尊敬的顾客您好!您的订单已经收到,易康商城将尽快为您安排发货,如有任何问题可以拨打客服电话400-1199-802进行咨询,感谢您的惠顾!'; \MessageSender::sendMessage($phone, $msg); // if ($phone = env('ORDER_ADMIN_PHONE')) { // \Log::error($phone); // \MessageSender::sendMessage($phone, $order->toOrderMessageString()); // } $result = \Wechat::paymentNotify(); return $result; } return 'FAIL'; }
/** * Edit a customer. * * @param string $id * * @return Response */ public function edit($id) { $customer = User::find($id); $addresses = Address::where('customer_id', '=', $customer->id)->get(); $orders = Order::where('customer_id', '=', $customer->id)->get(); return view('admin/customers/edit', ['customer' => $customer, 'addresses' => $addresses, 'orders' => $orders]); }
private function createAddress() { $address = new Address(); $address->region = ""; $address->city = ""; $address->district = ""; $address->street = ""; $address->home = ""; $address->housing = ""; $address->building = ""; $address->metro = ""; $address->latitude = 0; $address->longitude = 0; $address->save(); return $address->id; }
/** * Creates a new DocRegistration model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new DocRegistration(); $address = new Address(); if ($model->load(Yii::$app->request->post()) && $address->load(Yii::$app->request->post()) && $model->save()) { Yii::$app->getSession()->addFlash('success', "Регистрация \"{$model->fullNum}\" успешно добавлена."); return $this->redirect(Url::previous() != Yii::$app->homeUrl ? Url::previous() : ['view', 'id' => $model->id]); } else { if (Yii::$app->request->referrer != Yii::$app->request->absoluteUrl) { Url::remember(Yii::$app->request->referrer ? Yii::$app->request->referrer : null); } if (!Yii::$app->request->isPost) { $model->setAttributes(Yii::$app->request->get()); } return $this->render('create', ['model' => $model, 'address' => $address]); } }
public function run() { DB::table('addresses')->delete(); $collection = [['company_id' => 5, 'country_id' => 1, 'type' => 'business', 'address1' => '5350 Poplar Ave Suite 150', 'address2' => '', 'city' => 'Memphis', 'state' => 'TN', 'postal_code' => '38119'], ['company_id' => 2, 'country_id' => 1, 'type' => 'business', 'address1' => '6750 Poplar Ave Suite 500', 'address2' => '', 'city' => 'Memphis', 'state' => 'TN', 'postal_code' => '38138']]; foreach ($collection as $record) { Address::create($record); } }
/** * Delete an Address. * * @param string $id * * @return Redirect */ public function destroy(Request $request, $id) { // delete $address = Address::find($id); $address->delete(); // redirect $request->session()->flash('success', trans('address.address') . ' ' . trans('crud.deleted')); return back(); }
public function actionAddress($id = null) { if ($id) { $model = Address::findOne($id); if ($model === null) { throw new NotFoundHttpException('model does not exist.'); } } else { $model = new Address(); } if ($model->load(Yii::$app->request->post())) { $model->user_id = Yii::$app->user->id; if ($model->save()) { return $this->redirect(['cart/checkout']); } } return $this->render('address', ['model' => $model]); }
public function add_address() { $address = new Address(); //dd(Session::get("userId")); $address->user_id = Session::get('user')->id; $address->firstname = Input::get('cname'); $address->lastname = Input::get('lname'); $address->phone = Input::get('phone'); $address->address1 = Input::get('address1'); $address->address2 = Input::get('address2'); $address->address3 = Input::get('address3'); $address->pincode = Input::get('pincode'); $address->city = Input::get('city'); $address->country = Input::get('country'); $address->save(); $addid = $address->id; // dd($addid); return redirect()->back(); }
public function update($id) { // save updated $record = $this->records->find($id); if (!$record) { Address::create(Input::all()); return $this->respond($record); } $record->fill(Input::all())->save(); return $this->respond($record); }
public function searchResult() { $searchWord = Input::get('search', ''); $maxCount = (int) Input::get('max_count', 100); $addr = new Models\Address(); /** @var \Illuminate\Database\Query\Builder $q */ $q = $addr->newQuery(); $decoded_searchWord = Models\Address::processZip($searchWord); $q->orWhere('zip', '=', $decoded_searchWord); foreach (['ken_furi', 'city_furi', 'town_furi'] as $col) { Models\Address::filterQueryFuri($searchWord, $q, $col); } foreach (['ken_name', 'city_name', 'town_name', 'kyoto_street', 'block_name'] as $col) { Models\Address::filterQueryKanji($searchWord, $q, $col); } /** @var \Illuminate\Database\Eloquent\Collection|static[] $results */ $results = $q->take($maxCount)->get(['ken_id', 'zip', 'ken_name', 'ken_furi', 'city_name', 'city_furi', 'town_name', 'town_furi', 'kyoto_street', 'block_name', 'office_name', 'office_address']); $resultCount = count($results); return view('index', ['results' => $results, 'count' => $resultCount, 'searchWord' => $searchWord, 'maxCount' => $maxCount]); }
public function update($id, Request $request) { $address = Address::find($id); $rules = $address->getValidatorRules(); $validator = $this->validate($request, $rules); if ($validator) { return response()->json($validator, '404'); } $input = $request->all(); $address->update($input); $address->save(); return $address; }
public function saveRelatedDir($txt, $id_field, $name_field, $classDir) { $id = $this->owner->{$id_field}; $model = $id ? Address::findOne($id) : new $classDir(); if ($model->load(\Yii::$app->request->post())) { if (!$model->save()) { $this->addError($id_field, 'Не удалось сохранить новое значение'); return false; } $this->owner->{$id_field} = $model->id; return true; } }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Address::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['id' => $this->id, 'region_id' => $this->region_id, 'city_id' => $this->city_id, 'rec_status_id' => $this->rec_status_id, 'user_id' => $this->user_id, 'dc' => $this->dc]); $query->andFilterWhere(['like', 'street', $this->street])->andFilterWhere(['like', 'house', $this->house])->andFilterWhere(['like', 'room', $this->room])->andFilterWhere(['like', 'note', $this->note]); return $dataProvider; }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Address::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->andFilterWhere(['address_id' => $this->address_id, 'user_fk' => $this->user_fk, 'country_fk' => $this->country_fk, 'city_fk' => $this->city_fk, 'last_update' => $this->last_update]); $query->andFilterWhere(['like', 'email', $this->email])->andFilterWhere(['like', 'phone', $this->phone])->andFilterWhere(['like', 'address', $this->address]); return $dataProvider; }
/** * Creates new user in database and fire an event for * sneding activation mail * @param RegistrationRequest $request * @return Response */ public function postRegister(RegistrationRequest $request) { $input = $request->except('repeat_password'); if ($input['country_id'] != 840) { $input['state_id'] = null; } $input['code'] = str_random(30); $input['password'] = Hash::make($request['password']); $address = Address::create($input); $input['address_id'] = $address->id; $user = User::create($input); Event::fire(new UserIsRegistered($user)); return redirect(route('StoreUserLoginGet'))->with('flag', 'activationSent'); }
/** * Display my addresses * * @return Response */ public function addresses($user_id = null) { $result = \App\Models\Address::ownerid($user_id)->ownertype('App\\Models\\Customer'); $count = $result->count(); if (Input::has('skip')) { $skip = Input::get('skip'); $result = $result->skip($skip); } if (Input::has('take')) { $take = Input::get('take'); $result = $result->take($take); } $result = $result->get()->toArray(); return new JSend('success', (array) ['count' => $count, 'data' => $result]); }
public function search($input) { $query = Address::query(); $columns = Schema::getColumnListing('addresses'); $attributes = array(); foreach ($columns as $attribute) { if (isset($input[$attribute]) and !empty($input[$attribute])) { $query->where($attribute, $input[$attribute]); $attributes[$attribute] = $input[$attribute]; } else { $attributes[$attribute] = null; } } return [$query->get(), $attributes]; }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $validator = Validator::make(Request::all(), ['name' => 'required']); if ($validator->fails()) { return redirect()->back()->withErrors($validator->errors()); } else { try { $person = new Person(); $person->name = Input::get('name'); $person->last_name = Input::get('last_name'); $person->document = Input::get('document') == '' ? null : Input::get('document'); $person->identity = Input::get('identity') == '' ? null : Input::get('identity'); $person->email = Input::get('email') == '' ? null : Input::get('email'); $person->birthdate = Input::get('birthdate'); $person->nationality = Input::get('nationality'); $person->gender = Input::get('gender'); $person->phone = Input::get('phone'); $person->phone_cel = Input::get('phone_cel'); $person->name = Input::get('name'); $person->name = Input::get('name'); $person->save(); $member = new Member(); $member->father = Input::get('father'); $member->mother = Input::get('mother'); $member->marital_status_id = Input::get('marital_status_id'); $member->date_baptism = Input::get('date_baptism'); $member->occupacion = Input::get('occupacion'); $member->function_id = Input::get('function_id'); $member->literacy_id = Input::get('literacy_id'); $member->person_id = $person->id; $member->save(); $address = new Address(); $address->address = Input::get('address'); $address->number = Input::get('number'); $address->complement = Input::get('complement'); $address->zip_code = Input::get('zip_code'); $address->reference = Input::get('reference'); $address->country = Input::get('country'); $address->state = Input::get('state'); $address->city = Input::get('city'); $address->person_id = $person->id; $address->save(); return redirect('members'); } catch (\Illuminate\Database\QueryException $e) { print_r($e->errorInfo); } } }
public function actionGetCard($cid) { $company = Company::find()->where(['id' => $cid])->asArray()->one(); $address = Address::find()->where(['id' => $company['address_id']])->asArray()->one(); $shedule = Shedule::find()->where(['company_id' => $cid])->asArray()->all(); $brand = Company::find()->where(['id' => $cid])->one()->brand; $service = Company::find()->where(['id' => $cid])->one()->service; $srv = ArrayHelper::getColumn($service, 'category_id'); $category = Category::find()->where(['id' => $srv])->asArray()->indexBy('id')->all(); $srv = ArrayHelper::map($service, 'id', 'name', 'category_id'); $spoffer = SpecialOffer::find()->where(['company_id' => $cid])->asArray()->one(); $file = Files::find()->where(['id' => $spoffer['file_id']])->asArray()->one(); Yii::$app->response->format = Response::FORMAT_JSON; $response = ['company' => $company, 'address' => $address, 'shedule' => $shedule, 'brand' => $brand, 'category' => $category, 'service' => $srv, 'spoffer' => $spoffer, 'file' => $file]; return $response; }
public function createOrder(Request $request) { // get the basket $basket = $request->session()->get('basket'); // save order $order = new Order(); $order->shop_id = $request->session()->get('shop'); $order->customer_id = Auth::user()->id; $order->shipping_id = $request->shipping_id; $order->billing_id = $request->billing_id; $order->total = $basket['subtotal']; $basket['shipping'] = Address::find($request->shipping_id)->toArray(); $basket['billing'] = Address::find($request->billing_id)->toArray(); $order->basket = $basket; $order->save(); return $order; }
/** * Proccess payment * * @param Request $request * @return Response */ public function pay(Request $request) { $user = Auth::user(); if ($request->session()->has('addressId')) { $address = Address::find($request->session()->get('addressId')); $request->session()->forget('addressId'); } else { $address = $user->address; } // array for order data $orderData = []; $orderData['full_price'] = Cart::totalWithShipping(); $orderData['user_id'] = $user->id; $orderData['address_id'] = $address->id; if ($request->has('stripeToken')) { \Stripe\Stripe::setApiKey(env('STRIPE_TEST_SECRET_KEY')); $orderData['stripeToken'] = $request->get('stripeToken'); $orderData['payment_method_id'] = 1; try { $charge = \Stripe\Charge::create(array("amount" => $orderData['full_price'] * 100, "currency" => "usd", "source" => $orderData['stripeToken'], "description" => "Test charge; user e-mail: " . $user->email)); } catch (\Stripe\Error\Card $e) { $request->session()->flash('status', 'Card declined, please fill your card and try again later.'); return redirect('/'); } } else { $orderData['payment_method_id'] = 2; } $cartProducts = \Cart::associate('Product', 'App\\Models')->content(); $products = new Collection(); foreach ($cartProducts as $item) { $products->push(['product' => \App\Models\Product::find($item->id), 'quantity' => $item->qty]); } // Get the order weight $orderData['weight'] = 0; foreach ($products as $product) { $orderData['weight'] += $product['product']->weight * $product['quantity']; } $order = Order::create($orderData); foreach ($products as $product) { OrderProduct::create(['order_id' => $order->id, 'product_id' => $product['product']->id, 'quantity' => $product['quantity'], 'price' => (double) $product['product']->price * $product['quantity']]); } Event::fire(new OrderWasPlaced($order)); Cart::destroy(); $request->session()->flash('status', 'Order recieved.'); return redirect('/'); }
/** * Creates data provider instance with search query applied * * @param array $params * * @return ActiveDataProvider */ public function search($params) { $query = Address::find(); $dataProvider = new ActiveDataProvider(['query' => $query]); $this->load($params); if (!$this->validate()) { // uncomment the following line if you do not want to return any records when validation fails // $query->where('0=1'); return $dataProvider; } $query->joinWith(['country', 'province', 'customer']); //$query->joinWith('country'); //$query->joinWith('province'); //$query->joinWith('customer'); $query->andFilterWhere(['address_id' => $this->address_id, 'address_category' => $this->address_category, 'flag_active' => $this->flag_active, 'date_added' => $this->date_added, 'date_update' => $this->date_update]); $query->andFilterWhere(['like', 'country_name', $this->country_id])->andFilterWhere(['like', 'province_name', $this->province_id])->andFilterWhere(['like', 'first_name', $this->customer_id])->andFilterWhere(['like', 'address_1', $this->address_1])->andFilterWhere(['like', 'address_2', $this->address_2])->andFilterWhere(['like', 'postcode', $this->postcode])->andFilterWhere(['like', 'city', $this->city])->andFilterWhere(['like', 'phone_1', $this->phone_1])->andFilterWhere(['like', 'phone_2', $this->phone_2])->andFilterWhere(['like', 'other', $this->other]); return $dataProvider; }
public function secure() { $user = User::find(Session::get('user')->id); $user->firstname = Input::get('cname'); $user->lastname = Input::get('lname'); $user->phone = Input::get('phone'); if ($user->Update()) { $address = Address::find($user->addresses()->first()->id); $address->user_id = $user->id; $address->firstname = Input::get('cname'); $address->lastname = Input::get('lname'); $address->address1 = Input::get('address1'); $address->address2 = Input::get('address2'); $address->address3 = Input::get('address3'); $address->pincode = Input::get('pincode'); $address->city = Input::get('city'); $address->country = Input::get('country'); $address->Update(); // return view('frontend.pages.checkout-details', compact('address')); } return redirect()->route('checkout_info'); }
public function testFilterKanji() { $kanji = '新宿'; $trueColumns = ['city_name', 'town_name']; $falseColumns = ['ken_name']; foreach ($trueColumns as $trueColumn) { /** @var \Illuminate\Database\Query\Builder $q */ $addr = new \App\Models\Address(); $q = $addr->newQuery(); \App\Models\Address::filterQueryFuri($kanji, $q, $trueColumn); $result = $q->get(['id']); self::assertTrue(count($result) > 0); } foreach ($falseColumns as $falseColumn) { /** @var \Illuminate\Database\Query\Builder $q */ $addr = new \App\Models\Address(); $q = $addr->newQuery(); \App\Models\Address::filterQueryFuri($kanji, $q, $falseColumn); $result = $q->get(['id']); self::assertTrue(count($result) === 0); } }
/** * 依据前台post消息创建订单 * * @param Request $request * @return \Response */ public function generateConfig(Request $request) { $validator = \Validator::make($request->all(), ['address_id' => 'required|exists:addresses,id', 'cart' => 'required']); if ($validator->fails()) { return response()->json($validator->errors()->getMessages()); } $customer = \Helper::getCustomer(); $items = $request->input('cart'); $sale = $request->input('sale', null); if ($sale != null && !$this->checkSaleCredential($customer, $sale)) { return response()->json(['success' => false, 'error_message' => '你不具有参加特卖资格!']); } $order = new Order(); $address = Address::findOrFail($request->input('address_id')); $order->initWithCustomerAndAddress($customer, $address, $sale); $order->save(); $order->addCommodities($items); $order->calculate(); $order->save(); $result = \Wechat::generatePaymentConfig($order, $customer); return response()->json(['success' => true, 'data' => ['result' => $result, 'order_id' => $order->id]]); }