/**
* 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;
}
