/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { // if ($request->edit != 0) { return $this->update($request, $request->edit); } $validator = \Validator::make($request->all(), ['email' => 'required|unique:Customers,email', 'firstname' => 'required']); if ($validator->fails()) { return response()->json(array('status' => 500, 'monolog' => array('title' => 'errors', 'message' => implode($validator->errors()->all(), '<br>')))); } DB::beginTransaction(); $customer = new Customer(); $customer->username = $request->email; $customer->email = $request->email; $customer->password = Hash::make($request->password); $customer->firstname = $request->firstname; $customer->lastname = $request->lastname; $customer->address = $request->address; $customer->phone = $request->phone; $customer->city = ucwords($request->city); $customer->province = $request->province; $customer->country = $request->country; $customer->zipcode = $request->zipcode; $customer->facebook = $request->facebook; $customer->twitter = $request->twitter; // $customer->image_profile = $request->image_profile; $customer->newsletter = $request->newsletter; $customer->active = $request->active; $customer->save(); DB::commit(); return response()->json(array('status' => 200, 'monolog' => array('title' => 'post success', 'message' => 'Post has been received'))); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $validator = Validator::make($request->all(), ['order_id' => 'required|integer|min:1', 'vorname' => 'required|max:255', 'nachname' => 'required|max:255', 'strasse' => 'required|max:255', 'PLZ' => 'required|min:4|max:5', 'stadt' => 'required|max:255']); if ($validator->fails()) { // Return JSON response with 422 HTTP status code return $validator->errors()->all(); } $values = $request->all(); $values = array_map('trim', $values); //remove leading and trailing whitespaces on all values $values['group'] = Auth::user()->group; // Check whether the order exists and is actually owned by the given group $order = Order::where('id', $values['order_id'])->where('group', $values['group'])->firstOrFail(); unset($values['order_id']); // Validation successfull, let's check if we already have a customer with the same namespace $customer = Customer::where('vorname', $values['vorname'])->where('nachname', $values['nachname'])->where('strasse', $values['strasse'])->where('PLZ', $values['PLZ'])->where('stadt', $values['stadt'])->where('group', $values['group'])->first(); Log::Info(print_r($customer, true)); // if this is a new customer, we create it first if (is_null($customer)) { //|| $customer->isEmpty() $customer = new Customer($values); $customer->save(); } $existing_associations = $order->customer()->lists('id'); // check if the relation between order and customer is already established if (!in_array($customer->id, array_values($existing_associations->toArray()))) { // link the customer to the order $order->customer()->attach($customer->id); } // Return customer object return $customer; }
/** * Run the database seeds. * * @return void */ public function run() { $employee_ids = Employee::all()->lists('id')->toArray(); $order_states = OrderState::lists('id')->toArray(); $products = Product::all(); $municipalities = Municipality::all(); factory(App\Customer::class, 50)->create()->each(function ($customer) use($employee_ids, $products, $municipalities, $order_states) { shuffle($employee_ids); shuffle($order_states); $customer->user()->save(factory(User::class, 'customer')->create()); $customer->city_id = $municipalities->shuffle()->first()->id; $customer->save(); $customer->products()->attach($products->shuffle()->first(), ['vote' => rand(1, 5), 'created_at' => Carbon::now(), 'updated_at' => Carbon::now()]); $customer->orders()->save(factory(App\Order::class)->create(['acquired_by' => $employee_ids[0], 'state_id' => $order_states[0]])); }); $user = new User(); $user->name = 'Vid'; $user->surname = 'Mahovic'; $user->email = '*****@*****.**'; $user->password = '******'; $user->verified = true; $user->save(); $customer = new Customer(); $customer->street = 'Celovška 21'; $customer->city_id = $municipalities->shuffle()->first()->id; $customer->phone = '+38640850993'; $customer->save(); $customer->user()->save($user); }
public function saveCustomer(Request $request) { if ($request->customer_id != "") { $customer = Customer::find($request->customer_id); $customer->name = $request->name; $customer->phone = $request->phone; $customer->address = $request->address; User::where('userable_id', '=', $request->customer_id)->update(['email' => $request->email, 'banned' => $request->banned]); $check = $customer->save(); if ($check) { return "EDIT_SUCCEED"; } else { return "Có lỗi xảy ra. Vui lòng thử lại sau!"; } } else { $customer = new Customer(); $customer->name = $request->name; $customer->phone = $request->phone; $customer->address = $request->address; $check = $customer->save(); if ($check) { $data = array('msg' => 'ADD_SUCCEED', 'customer_id' => $customer->id); return $data; } else { return "Có lỗi xảy ra. Vui lòng thử lại sau!"; } } }
/** * Store a newly created resource in storage. * * @return Response */ public function store(CustomerRequest $request) { // store $customers = new Customer(); $customers->name = Input::get('name'); $customers->email = Input::get('email'); $customers->phone_number = Input::get('phone_number'); $customers->address = Input::get('address'); $customers->city = Input::get('city'); $customers->state = Input::get('state'); $customers->zip = Input::get('zip'); $customers->company_name = Input::get('company_name'); $customers->account = Input::get('account'); $customers->save(); // process avatar $image = $request->file('avatar'); if (!empty($image)) { $avatarName = 'cus' . $customers->id . '.' . $request->file('avatar')->getClientOriginalExtension(); $request->file('avatar')->move(base_path() . '/public/images/customers/', $avatarName); $img = Image::make(base_path() . '/public/images/customers/' . $avatarName); $img->resize(100, null, function ($constraint) { $constraint->aspectRatio(); }); $img->save(); $customerAvatar = Customer::find($customers->id); $customerAvatar->avatar = $avatarName; $customerAvatar->save(); } Session::flash('message', 'You have successfully added customer'); return Redirect::to('customers'); }
public function doCreate(CreateCustomerRequest $request) { $customer = new Customer(); $customer->name = $request->name; $customer->email = $request->email; $customer->class = $request->class; $customer->description = $request->description; $customer->description_name = $request->description_name; $customer->specialty = $request->specialty; $customer->mobile = $request->mobile; $customer->clinic_tel = $request->clinic_tel; $customer->address = $request->address; $customer->address_description = $request->address_description; $customer->am_working = $request->am_working; $customer->mr_id = $request->mr; $customer->time_of_visit = $request->time_of_visit; $customer->comment = $request->comment; $customer->active = $request->active; try { $customer->save(); return redirect()->back()->with('message', 'Customer has been added successfully !'); // print_r($customer); } catch (ParseException $ex) { echo 'Failed to create new customer , with error message: ' . $ex->getMessage(); } }
public function create(Request $request) { $deviceId = $request->input('device_id'); $customer = Customer::where('device_id', $deviceId)->first(); if (isset($customer)) { return json_encode(array('message' => 'existing', 'customer' => $customer)); } else { $phone = $request->input('phone'); $customer = Customer::where('phone', $phone)->first(); if (!isset($customer)) { $customer = new Customer(); $customer->name = $request->input('name'); $customer->phone = $request->input('phone'); $customer->device_id = $request->input('device_id'); $customer->password = ''; //$request->input('password'); $customer->photo = 'default'; $customer->status = 'active'; $customer->created_at = date('Y-m-d h:i:s'); $customer->updated_at = date('Y-m-d h:i:s'); $customer->save(); return json_encode(array('message' => 'done', 'customer' => $customer)); } else { return json_encode(array('message' => 'duplicate')); } } }
private function generateCustomerSeed($email, $password, $firstname, $surname, $dob) { $user = ['email' => $email, 'password' => bcrypt($password), 'role' => '1']; $user = User::create($user); $customer = new Customer(); $customer->user_id = $user->id; $customer->firstname = $firstname; $customer->surname = $surname; $customer->dob = $dob; $customer->save(); }
public function saveCustomer(Request $request) { $this->validate($request, ['address' => 'required|max:200', 'number_card' => 'required|numeric|digits:16']); $c = new Customer(); $c->user_id = Auth::user()->id; $c->address = $request->address; $c->number_card = $request->number_card; $c->number_command = 0; $c->save(); return redirect('commande')->with(['message' => 'Votre inscription est complete', 'alert' => 'success']); }
public function save(Request $request) { if (!Customer::whereCustomer_id($request->customer_id)->first()) { $customer = new Customer(); $customer->fill($request->all()); $customer->save(); return redirect("/customer/" . $customer->id . "/show"); } else { return redirect("/customer/create")->with("status", Alert::get("danger", "Kund " . $request->customer_id . " existerar, försök igen.")); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $this->validate($request, ['customer_name' => 'required|max:255', 'group_list_selected' => 'required']); $customer = new Customer(['name' => $request->customer_name]); $customer->save(); // Add the new group - customer association foreach ($request->group_list_selected as $g_selected) { $customer->groups()->attach($g_selected); } return redirect('/customers'); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $customer = new Customer(); $customer->first_name = $request->input('first_name'); $customer->last_name = $request->input('last_name'); $customer->email = $request->input('email'); $customer->phone = $request->input('phone'); $customer->facebook_url = $request->input('facebook_url'); $customer->notes = $request->input('notes'); $customer->save(); return response()->json(['newId' => $customer->id]); }
/** * Store a newly created resource in storage. * * @param \App\Http\Requests\CreateCustomerValidation|\Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(CreateCustomerValidation $request) { $input = $request->all(); $customer = new Customer(); $customer->fill($input); if ($customer->save()) { $this->setMessage('Customer was successfully created!'); } else { $this->setMessage('Oops... Customer was not created. Please try again', 'error'); } return redirect('/customers'); }
/** * Run the database seeds. * * @return void */ public function run() { $user = new User(); $user->name = 'mugekural'; $user->surname = str_random(10); $user->email = $user->name . '@gmail.com'; $user->is_active = true; $user->password = bcrypt('12345'); $user->type = 'App\\Supplier'; $user->save(); $supplier = new Supplier(); $supplier->phone = '023123'; $supplier->id = $user->id; $supplier->save(); $user2 = new User(); $user2->name = str_random(10); $user2->surname = str_random(10); $user2->email = $user2->name . '@gmail.com'; $user2->is_active = true; $user2->type = 'App\\Customer'; $user2->save(); $customer = new Customer(); $customer->phone = "053247557437"; $customer->id = $user2->id; $customer->save(); $instagram = new InstagramAccount(); $instagram->instagram_id = "1231231"; $instagram->access_token = "asdaddads"; $instagram->username = "******"; $instagram->full_name = "omer faruk"; $instagram->bio = "fdsfasfdsf"; $instagram->website = "string"; $instagram->profile_picture = ""; $supplier->instagramAccount()->save($instagram); $product = new Product(); $product->supplier_id = $supplier->id; $product->id = "235"; $product->is_active = true; $product->title = "kitap"; $product->description = "martı"; $product->price = "340"; $product->save(); $instagram2 = new InstagramAccount(); $instagram2->instagram_id = "700797"; $instagram2->access_token = "fjfjjfjfjf"; $instagram2->username = "******"; $instagram2->full_name = "muge kural"; $instagram2->bio = "comp stud"; $instagram2->website = "some string"; $instagram2->profile_picture = ""; $customer->instagramAccount()->save($instagram2); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $customer = new Customer(); $customer->username = $request->name; $customer->email = $request->email; $customer->password = Hash::make($request->password); if ($customer->save()) { \Session::flash('message', 'Utilisateur bien sauvegardé en BDD.'); } else { \Session::flash('message', 'Probleme lors de l\'acces à la BDD. Merci de réessayer.'); } return view('customers.create'); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $customer = new Customer(); $customer->name = $request->name; $customer->birthday = $request->birthday; $customer->identity_card_number = $request->identity_card_number; $customer->company = $request->company; $customer->phone_number = $request->phone_number; $customer->email = $request->email; $customer->description = $request->description; $customer->address = $request->address; $customer->save(); return redirect("admin/customer"); }
public function register($data) { Customer::where('email', $data['email'])->where('email_confirmed', false)->delete(); $customer = new Customer(['email' => $data['email'], 'first_name' => $data['first_name'], 'last_name' => $data['last_name'], 'password' => $data['password'], 'gender_id' => $data['gender_id']]); $customer->save(); $invoice = ['email' => $data['email'], 'first_name' => $data['first_name'], 'last_name' => $data['last_name'], 'gender_id' => $data['gender_id'], 'country_id' => config('shop.default_country_id')]; $shipping = $invoice; $invoice['address_kind_id'] = config('shop.invoice_address_kind_id'); $shipping['address_kind_id'] = config('shop.shipping_address_kind_id'); $invoice_address = new CustomerAddress($invoice); $shipping_address = new CustomerAddress($shipping); $customer->customer_addresses()->saveMany([$invoice_address, $shipping_address]); return $customer; }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $input = Request::all(); $avto = new Avto($input); $repair = new Repair($input); $customer = new Customer($input); $avto->save(); $repair->save(); $customer->save(); $order = new Order(['date' => $input['date'], 'd_avto' => $avto->id, 'd_r' => $repair->id, 'customer_id' => $customer->id]); $order->save(); // dd($avto);<--Для дебага return redirect('orders/ordersuccess'); }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { // $input = Request::all(); // dd($input); $customer = new Customer(); $customer->namacus = $input['namacus']; $customer->tlpcus = $input['tlpcus']; $customer->faxcus = $input['faxcus']; $customer->emailcus = $input['emailcus']; $customer->alamatcus = $input['alamatcus']; $customer->save(); return Redirect::to('customer'); }
public function addCustomer(Request $request) { $data = $request->only('name', 'address', 'contact_person', 'contact_number', 'credit_limit'); $rules = ['name' => 'required', 'contact_number' => 'required']; $this->validate($request, $rules); $customer = new Customer(); $customer->name = $data['name']; $customer->address = $data['address']; $customer->contact_person = $data['contact_person']; $customer->contact_number = $data['contact_number']; $customer->credit_limit = $data['credit_limit']; $customer->record_status = Customer::STATUS_ACTIVE; $customer->save(); return redirect('home')->with('msg', 'Customer Recorded'); }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['customer' => 'required|max:100|unique_with:customers, customer_code = customer_code, account = account_id', 'customer_code' => 'required|not_in:0', 'account' => 'required|not_in:0']); \DB::beginTransaction(); try { $customer = new Customer(); $customer->account_id = $request->account; $customer->customer_code = $request->customer_code; $customer->customer = $request->customer; $customer->save(); \DB::commit(); Session::flash('flash_message', 'Customer successfully added!'); return redirect()->route("customer.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Run the database seeds. * * @return void */ public function run() { $treeleaf = new Customer(); $treeleaf->name = 'Treeleaf Dev'; $treeleaf->city = 'Wien'; $treeleaf->zipCode = '1220'; $treeleaf->street = 'Doningasse 20/2/1'; $treeleaf->email = '*****@*****.**'; $treeleaf->phoneNo = '0660606060'; $treeleaf->save(); $spengergasse = new Customer(); $spengergasse->name = 'HTL Spengergasse'; $spengergasse->city = 'Wien'; $spengergasse->zipCode = '1050'; $spengergasse->street = 'Spengergassse 20'; $spengergasse->email = '*****@*****.**'; $spengergasse->phoneNo = '0660606060'; $spengergasse->save(); }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $rules = array('firstname' => 'required', 'surname' => 'required', 'customeremail' => 'required|email', 'pass' => 'required', 'phone' => 'required', 'rpass' => 'required|same:pass'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { // get the error messages from the validator $messages = $validator->messages(); // redirect our user back to the form with the errors from the validator return back()->withInput()->withErrors($messages); } else { if (User::where('email', $request->input('customeremail'))->first()) { return redirect()->action('AuthenticationController@showRegister')->withErrors(['messages' => "Sistemde mail adresi kayıtlı"]); } $user = new User(); $user->name = trim($request->input('firstname')); $user->surname = trim($request->input('surname')); $user->setAsCustomer(); $user->is_active = false; $user->email = $request->input('customeremail'); $user->password = bcrypt($request->input('pass')); $user->save(); $customer = new Customer(); $customer->phone = $request->input('phone'); $customer->id = $user->id; $customer->save(); if (Session::has('user_instagram_info')) { $instagramInfo = Session::pull('user_instagram_info'); $instagramAccount = new InstagramAccount(); $instagramAccount->instagram_id = $instagramInfo->user->id; $instagramAccount->username = $instagramInfo->user->username; $instagramAccount->access_token = $instagramInfo->access_token; $instagramAccount->full_name = $instagramInfo->user->full_name; $instagramAccount->bio = $instagramInfo->user->bio; $instagramAccount->website = $instagramInfo->user->website; $instagramAccount->profile_picture = $instagramInfo->user->profile_picture; $customer->instagramAccount()->save($instagramAccount); } Storage::makeDirectory($user->id); return redirect()->action('AuthenticationController@showRegister')->with('success', ['Successful']); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\CustomerRequest $request * @return \Illuminate\Http\Response */ public function store(CustomerRequest $request) { $input = $request->all(); $user_id = '1'; $customer = new Customer(); $customer->name = $input['name']; $customer->address1 = $input['address1']; $customer->address2 = $input['address2']; $customer->city = $input['city']; $customer->telephone = $input['telephone']; $customer->mobile = $input['mobile']; $customer->email = $input['email']; $customer->fax = $input['fax']; $customer->website = $input['website']; $customer->vat_no = $input['vat_no']; $customer->contact_person = $input['contact_person']; $customer->credit_limit = $input['credit_limit']; $customer->account_sys_id = $input['account_sys_id']; $customer->created_by = $user_id; $customer->save($request->all()); return redirect('/customers'); }
public function postRegister(RegisterRequest $request) { $customer = new Customer(); $customer->name = $request->name; $customer->address = $request->address; $customer->phone = $request->phone; $check = $customer->save(); if ($check) { $user = new User(); $user->username = $request->username; $user->password = Hash::make($request->password); $user->email = $request->email; $user->remember_token = $request->_token; $user->userable_id = $customer->id; $user->userable_type = 'customer'; $check = $user->save(); } if ($check) { $userdata = array('username' => $request->username, 'password' => $request->password); if ($this->auth->attempt($userdata)) { return redirect()->away($request->rtn_url)->with('message', 'Đăng ký thành công!')->with('alert-class', 'alert-success')->with('fa-class', 'fa-check'); } else { return redirect('auth/login')->with('message', 'Đăng nhập không thành công, vui lòng thử lại!')->with('alert-class', 'alert-danger')->with('fa-class', 'fa-ban'); } } else { return redirect('auth/register')->with('alert-class', 'alert-danger')->with('message', 'Đăng ký không thành công, vui lòng thử lại!')->with('fa-class', 'fa-ban'); } }
public function run() { $start_date = ''; $end_date = ''; $folderpath = 'database/seeds/seed_files'; $folders = File::directories($folderpath); $latest = '11232015'; foreach ($folders as $value) { $_dir = explode("/", $value); $cnt = count($_dir); $name = $_dir[$cnt - 1]; $latest_date = DateTime::createFromFormat('mdY', $latest); $now = DateTime::createFromFormat('mdY', $name); if ($now > $latest_date) { $latest = $name; } } $file_path = $folderpath . "/" . $latest . "/Store Mapping.xlsx"; echo (string) $file_path, "\n"; // dd($file_path); Model::unguard(); DB::statement('SET FOREIGN_KEY_CHECKS=0;'); DB::table('audit_templates')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->template)) { $template = AuditTemplate::where('template', $row->template)->first(); if (count($template) == 0) { $newtemplate = new AuditTemplate(); $newtemplate->template_code = $row->channel_code; $newtemplate->template = $row->template; $newtemplate->save(); } } }); }); DB::table('grade_matrixs')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->enrollment_type)) { $matrix = GradeMatrix::where('desc', $row->enrollment_type)->first(); if (count($matrix) == 0) { $newmatrix = new GradeMatrix(); $newmatrix->desc = $row->enrollment_type; $newmatrix->save(); } } }); }); DB::table('users')->truncate(); DB::table('role_user')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->fullname)) { $userlist = explode("/", $row->fullname); $emaillist = explode("/", $row->email); // dd($row); for ($i = 0; $i < count($userlist); $i++) { $user = User::where('username', $row->username)->first(); if (count($user) == 0) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $newuser = User::create(array('name' => strtoupper($userlist[$i]), 'email' => $email, 'username' => $row->username, 'password' => Hash::make('password'))); $newuser->roles()->attach(3); } else { // $user->name = strtoupper($row->fullname); // $user->username = $row->username; // $user->email = strtolower($row->email); // $user->update(); // if(!$user->hasRole('field')){ // $user->roles()->attach(3); // } // echo $user->hasRole('field'); } } } }); }); DB::table('accounts')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (count($account) == 0) { $newaccount = new Account(); $newaccount->account = $row->account; $newaccount->save(); } } }); }); DB::table('customers')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { // var_dump($row); $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (count($customer) == 0) { $newcustomer = new Customer(); $newcustomer->account_id = $account->id; $newcustomer->customer_code = $row->customer_code; $newcustomer->customer = $row->customer; $newcustomer->save(); } } } }); }); DB::table('areas')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (!empty($customer)) { $area = Area::where('customer_id', $customer->id)->where('area', $row->area)->first(); if (count($area) == 0) { $newarea = new Area(); $newarea->customer_id = $customer->id; $newarea->area = $row->area; $newarea->save(); } } } } }); }); DB::table('regions')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $region = Region::where('region_code', $row->region_code)->where('region', $row->region)->first(); if (count($region) == 0) { $newregion = new Region(); $newregion->region_code = $row->region_code; $newregion->region = $row->region; $newregion->save(); } } }); }); DB::table('distributors')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $dis = Distributor::where('distributor_code', $row->distributor_code)->where('distributor', $row->distributor)->first(); if (count($dis) == 0) { $newdis = new Distributor(); $newdis->distributor_code = $row->distributor_code; $newdis->distributor = strtoupper($row->distributor); $newdis->save(); } } }); }); DB::table('stores')->truncate(); DB::table('store_user')->truncate(); Excel::selectSheets('Sheet1')->load($file_path, function ($reader) { $records = $reader->get(); $records->each(function ($row) { if (!is_null($row->account)) { $account = Account::where('account', $row->account)->first(); if (!empty($account)) { $customer = Customer::where('account_id', $account->id)->where('customer_code', $row->customer_code)->where('customer', $row->customer)->first(); if (!empty($customer)) { $region = Region::where('region_code', $row->region_code)->first(); $dis = Distributor::where('distributor_code', $row->distributor_code)->first(); $store = Store::where('account_id', $account->id)->where('customer_id', $customer->id)->where('region_id', $region->id)->where('distributor_id', $dis->id)->where('store_code', $row->store_code)->where('store', $row->store_name)->first(); if (count($store) == 0) { $template = AuditTemplate::where('template', $row->template)->first(); $matrix = GradeMatrix::where('desc', $row->enrollment_type)->first(); $newstore = new Store(); $newstore->account_id = $account->id; $newstore->customer_id = $customer->id; $newstore->region_id = $region->id; $newstore->distributor_id = $dis->id; $newstore->store_code = $row->store_code; $newstore->store = $row->store_name; $newstore->grade_matrix_id = $matrix->id; $newstore->audit_template_id = $template->id; $newstore->save(); $emaillist = explode("/", $row->email); for ($i = 0; $i < count($emaillist); $i++) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $user = User::where('email', $email)->first(); $newstore->users()->attach($user->id); } } else { $emaillist = explode("/", $row->email); for ($i = 0; $i < count($emaillist); $i++) { if (empty($emaillist[$i])) { $email = strtolower($row->username . "@unilever.com"); } else { $email = strtolower($emaillist[$i]); } $user = User::where('email', $email)->first(); $store->users()->attach($user->id); } } } } } }); }); DB::statement('SET FOREIGN_KEY_CHECKS=1;'); Model::reguard(); }
/** * Display All Customers * * Route::get('/', function () { * return view('customers'); * }); */ Route::get('/', function () { $customers = Customer::orderBy('created_at', 'desc')->get(); return view('customers', ['customers' => $customers]); }); /** * Add A New Customer */ Route::post('/customer', function (Request $request) { $validator = Validator::make($request->all(), ['name' => 'required|max:255']); if ($validator->fails()) { return redirect('/')->withInput()->withErrors($validator); } $customer = new Customer(); $customer->customer_name = $request->name; $customer->save(); return redirect('/'); // Create The Task... }); /** * Delete An Existing Customer */ Route::delete('/customer/{id}', function ($id) { // });
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { // $rules = array('projectNum' => 'required', 'create_at' => 'required', 'pjsales' => 'required', 'pjContacter' => 'required', 'pjContacterPhone' => 'required', 'pjContacterEmail' => 'email|required', 'cmCode' => 'required', 'cmShort' => 'required', 'e_shortName' => 'required', 'customer_id' => 'required', 'c_name' => 'required', 'institute' => 'required', 'department' => 'required', 'email' => 'email|required', 'contacter' => 'required', 'contacterPhone' => 'required', 'contacterEmail' => 'email|required', 'address' => 'required', 'sales' => 'required', 'PJclass' => 'required', 'PJservice' => 'required', 'PJspecies' => 'required'); $validator = Validator::make($request->all(), $rules); if ($validator->fails()) { return back()->withErrors($validator)->withInput(); } $customer_id = $request->get('customer_id'); if ($customer_id == 0) { $customer = new Customer(array('cmCode' => $request->get('cmCode'), 'cmShort' => $request->get('cmShort'), 'c_name' => $request->get('c_name'), 'e_shortName' => $request->get('e_shortName'), 'institute' => $request->get('institute'), 'department' => $request->get('department'), 'fax' => $request->get('fax'), 'phone' => $request->get('phone'), 'email' => $request->get('email'), 'contacter' => $request->get('contacter'), 'contacterPhone' => $request->get('contacterPhone'), 'contacterEmail' => $request->get('contacterEmail'), 'address' => $request->get('address'), 'salesman' => $request->get('sales'))); $salesman = User::findOrFail($request->get('sales')); $customer->salesman()->associate($salesman); $customer->save(); } else { $customer = Customer::findOrFail($customer_id); $customer->update(['cmCode' => $request->get('cmCode'), 'cmShort' => $request->get('cmShort'), 'c_name' => $request->get('c_name'), 'e_shortName' => $request->get('e_shortName'), 'institute' => $request->get('institute'), 'department' => $request->get('department'), 'fax' => $request->get('fax'), 'phone' => $request->get('phone'), 'email' => $request->get('email'), 'contacter' => $request->get('contacter'), 'contacterPhone' => $request->get('contacterPhone'), 'contacterEmail' => $request->get('contacterEmail'), 'address' => $request->get('address')]); $salesman = User::findOrFail($request->get('sales')); $customer->salesman()->associate($salesman); $customer->save(); } $project = Project::findOrFail($id); if (empty($request->file('file'))) { $fileName = null; } else { $fileName = $project->id . '.' . $request->file('file')->getClientOriginalExtension(); $request->file('file')->move(base_path() . '/storeFiles/ngs/quotation/', $fileName); } $user = \Auth::user(); $project->user()->associate($user); $customer = Customer::findOrFail($customer_id); $project->customer()->associate($customer); $pjsalesman = User::findOrFail($request->get('pjsales')); $project->salesman = $pjsalesman->id; if ($request->get('PJservice') == 'Other') { $PJservice = $request->get('PJserviceNote'); } else { $PJservice = $request->get('PJservice'); } if (empty($fileName)) { $project->update(['projectNum' => $request->get('projectNum'), 'PJtype' => $request->get('PJtype'), 'PJclass' => $request->get('PJclass'), 'PJservice' => $PJservice, 'PJspecies' => $request->get('PJspecies'), 'note' => $request->get('note'), 'contacter' => $request->get('contacter'), 'contacterPhone' => $request->get('contacterPhone'), 'contacterEmail' => $request->get('contacterEmail')]); } else { $project->update(['projectNum' => $request->get('projectNum'), 'PJtype' => $request->get('PJtype'), 'PJclass' => $request->get('PJclass'), 'PJservice' => $PJservice, 'PJspecies' => $request->get('PJspecies'), 'note' => $request->get('note'), 'contacter' => $request->get('contacter'), 'contacterPhone' => $request->get('contacterPhone'), 'contacterEmail' => $request->get('contacterEmail'), 'fileName' => $fileName]); } return \Redirect::to('research/ngs/projects/index')->with('message', 'Your Project has been updated!'); }
public function addCustomer($name, $phone, $email, $channel, $status, $product_id, $public_id) { $merchant_id = \App\Product::find($product_id)->merchant_id; $customer = new Customer(); $customer->firstname = $name; $customer->lastname = "added to first"; $customer->gender = "unknown"; $customer->email = $email; $customer->phonenumber = $phone; $customer->password = "******"; $customer->merchant_id = $merchant_id; if ($customer->save()) { return "saved"; } else { return "could not save"; } }
public function addcustomerfirst($name, $last_name, $cin, $mail, $adress, $function, $phone, $car) { $customer = new Customer(); $customer->name = $name; $customer->last_name = $last_name; $customer->cin = $cin; $customer->mail = $mail; $customer->adress = $adress; $customer->function = $function; $customer->phone = $phone; $customer->car = $car; $customer->commercial_id = Controller::User()->id; $customer->save(); return $customer; }