/** * Store a newly created resource in storage. * * @return Response */ public function store() { if (Session::get('level') == '1' || Session::get('level') == '2' && Session::get('fingerprint') == md5($_SERVER['HTTP_USER_AGENT'] . $_SERVER['REMOTE_ADDR'])) { $postData = Input::All(); $messages = ['sp_code.required' => 'กรุณากรอก', 'sp_name.required' => 'กรุณากรอก', 'id_unit.required' => 'กรุณากรอก', 'type_code.required' => 'กรุณากรอก']; $rules = ['sp_code' => 'required', 'sp_name' => 'required', 'id_unit' => 'required', 'type_code' => 'required']; $validator = Validator::make($postData, $rules, $messages); if ($validator->fails()) { return Redirect::route('supplier.create')->withInput()->withErrors($validator); } else { $data = Request::all(); $Supplier = new Supplier(); $Supplier->sp_code = $data['sp_code']; $Supplier->sp_name = $data['sp_name']; $Supplier->id_unit = $data['id_unit']; $Supplier->type_code = $data['type_code']; DB::transaction(function () use($Supplier) { $Supplier->save(); }); Session::flash('savedata', save_data); return Redirect::to('supplier'); } } else { return Redirect::to('/'); } }
public function store(SupplierRequest $request) { try { DB::transaction(function () use($request) { $supplier = new Supplier(); $supplier->suppliers_type = $request->input('suppliers_type'); $supplier->company_name = $request->input('company_name'); $supplier->company_address = $request->input('company_address'); $supplier->company_office_phone = $request->input('company_office_phone'); $supplier->company_office_fax = $request->input('company_office_fax'); $supplier->contact_person = $request->input('contact_person'); $supplier->contact_person_phone = $request->input('contact_person_phone'); $supplier->supplier_description = $request->input('supplier_description'); $supplier->status = $request->input('status'); $supplier->created_at = time(); $supplier->created_by = Auth::user()->id; $supplier->save(); //Personal Account Creation $personal = new PersonalAccount(); $personal->person_type = Config::get('common.person_type_supplier'); if (!empty($request->input('balance'))) { $personal->balance = $request->input('balance'); } if (!empty($request->input('due'))) { $personal->due = $request->input('due'); } $personal->person_id = $supplier->id; $personal->created_by = Auth::user()->id; $personal->created_at = time(); $personal->save(); $year = CommonHelper::get_current_financial_year(); $user = Auth::user(); $time = time(); if (!empty($request->input('balance'))) { // Update Workspace Ledger $workspaceLedger = WorkspaceLedger::where(['workspace_id' => $user->workspace_id, 'account_code' => 41000, 'balance_type' => Config::get('common.balance_type_intermediate'), 'year' => $year])->first(); $workspaceLedger->balance += $request->input('balance'); $workspaceLedger->updated_by = $user->id; $workspaceLedger->updated_by = $time; $workspaceLedger->save(); } if (!empty($request->input('due'))) { // Update Workspace Ledger $workspaceLedger = WorkspaceLedger::where(['workspace_id' => $user->workspace_id, 'account_code' => 12000, 'balance_type' => Config::get('common.balance_type_intermediate'), 'year' => $year])->first(); $workspaceLedger->balance += $request->input('due'); $workspaceLedger->updated_by = $user->id; $workspaceLedger->updated_by = $time; $workspaceLedger->save(); } }); } catch (\Exception $e) { Session()->flash('error_message', 'Data cannot Save. Please Try Again'); return redirect('suppliers'); } Session()->flash('flash_message', 'Data has been Saved'); return redirect('suppliers'); }
/** * Creates a new Supplier model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Supplier(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'id' => $model->id_supplier]); } else { return $this->render('create', ['model' => $model]); } }
/** * Creates a new Supplier model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Supplier(); if ($model->load(Yii::$app->request->post()) && $model->save()) { return $this->redirect(['view', 'supplier_id' => $model->supplier_id, 'province_id' => $model->province_id, 'country_id' => $model->country_id]); } else { return $this->render('create', ['model' => $model]); } }
/** * Creates a new Supplier model. * If creation is successful, the browser will be redirected to the 'view' page. * @return mixed */ public function actionCreate() { $model = new Supplier(); if ($model->load(Yii::$app->request->post()) && $model->save()) { $product = Yii::$app->session->get(Product::className()); if ($product) { return $this->redirect(['product/create']); } return $this->redirect(['view', 'id' => $model->id]); } else { return $this->render('create', ['model' => $model]); } }
/** * Store a newly created resource in storage. * * @return Response */ public function store(SupplierRequest $request) { // store $supplier = new Supplier(); $supplier->name = $request->name; $supplier->phone = $request->phone; $supplier->email = $request->email; $supplier->address = $request->address; $supplier->user_id = Auth::user()->id; try { $supplier->save(); $url = session('SOURCE_URL'); return redirect()->to($url)->with('message', trans('messages.record-successfully-saved')); } catch (QueryException $e) { \Log::error($e); } }
public function register(Request $request) { $s = new Supplier(); $s->id = $request->input('id'); $s->code = $request->input('code'); $s->openbalance = $request->input('openbalance'); $s->name = $request->input('name'); $s->preaddress = $request->input('preaddress'); $s->peraddress = $request->input('peraddress'); $s->phone = $request->input('phone'); $s->email = $request->input('email'); $s->fax = $request->input('fax'); $s->url = $request->input('url'); $s->userid = $request->input('userid'); $s->save(); return redirect('suppliers'); }
public function store(Request $request) { $supplier = new Supplier(); $supplier->name = e($request->input('name')); $supplier->user_id = Auth::user()->id; if ($supplier->save()) { return JsonResponse::create($supplier); } return JsonResponse::create(["error" => "Failed validation: " . print_r($supplier->getErrors(), true)], 500); return JsonResponse::create(["error" => "Couldn't save Supplier"]); }
/** * Execute the console command. * * @return mixed */ public function fire() { $filename = $this->argument('filename'); if (!$this->option('testrun') == 'true') { $this->comment('======= Importing Licenses from ' . $filename . ' ========='); } else { $this->comment('====== TEST ONLY License Import for ' . $filename . ' ===='); $this->comment('============== NO DATA WILL BE WRITTEN =============='); } if (!ini_get("auto_detect_line_endings")) { ini_set("auto_detect_line_endings", '1'); } $csv = Reader::createFromPath($this->argument('filename')); $csv->setNewline("\r\n"); $csv->setOffset(1); $duplicates = ''; // Loop through the records $nbInsert = $csv->each(function ($row) use($duplicates) { $status_id = 1; // Let's just map some of these entries to more user friendly words if (array_key_exists('0', $row)) { $user_name = trim($row[0]); } else { $user_name = ''; } if (array_key_exists('1', $row)) { $user_email = trim($row[1]); } else { $user_email = ''; } if (array_key_exists('2', $row)) { $user_username = trim($row[2]); } else { $user_username = ''; } if (array_key_exists('3', $row)) { $user_license_name = trim($row[3]); } else { $user_license_name = ''; } if (array_key_exists('4', $row)) { $user_license_serial = trim($row[4]); } else { $user_license_serial = ''; } if (array_key_exists('5', $row)) { $user_licensed_to_name = trim($row[5]); } else { $user_licensed_to_name = ''; } if (array_key_exists('6', $row)) { $user_licensed_to_email = trim($row[6]); } else { $user_licensed_to_email = ''; } if (array_key_exists('7', $row)) { $user_license_seats = trim($row[7]); } else { $user_license_seats = ''; } if (array_key_exists('8', $row)) { $user_license_reassignable = trim($row[8]); if ($user_license_reassignable != '') { if (strtolower($user_license_reassignable) == 'yes' || strtolower($user_license_reassignable) == 'true' || $user_license_reassignable == '1') { $user_license_reassignable = 1; } } else { $user_license_reassignable = 0; } } else { $user_license_reassignable = 0; } if (array_key_exists('9', $row)) { $user_license_supplier = trim($row[9]); } else { $user_license_supplier = ''; } if (array_key_exists('10', $row)) { $user_license_maintained = trim($row[10]); if ($user_license_maintained != '') { if (strtolower($user_license_maintained) == 'yes' || strtolower($user_license_maintained) == 'true' || $user_license_maintained == '1') { $user_license_maintained = 1; } } else { $user_license_maintained = 0; } } else { $user_license_maintained = ''; } if (array_key_exists('11', $row)) { $user_license_notes = trim($row[11]); } else { $user_license_notes = ''; } if (array_key_exists('12', $row)) { if ($row[12] != '') { $user_license_purchase_date = date("Y-m-d 00:00:01", strtotime($row[12])); } else { $user_license_purchase_date = ''; } } else { $user_license_purchase_date = 0; } // A number was given instead of a name if (is_numeric($user_name)) { $this->comment('User ' . $user_name . ' is not a name - assume this user already exists'); $user_username = ''; // No name was given } elseif ($user_name == '') { $this->comment('No user data provided - skipping user creation, just adding license'); $first_name = ''; $last_name = ''; $user_username = ''; } else { $name = explode(" ", $user_name); $first_name = $name[0]; $email_last_name = ''; $email_prefix = $first_name; if (!array_key_exists(1, $name)) { $last_name = ''; $email_last_name = $last_name; $email_prefix = $first_name; } else { $last_name = str_replace($first_name, '', $user_name); if ($this->option('email_format') == 'filastname') { $email_last_name .= str_replace(' ', '', $last_name); $email_prefix = $first_name[0] . $email_last_name; } elseif ($this->option('email_format') == 'firstname.lastname') { $email_last_name .= str_replace(' ', '', $last_name); $email_prefix = $first_name . '.' . $email_last_name; } elseif ($this->option('email_format') == 'firstname') { $email_last_name .= str_replace(' ', '', $last_name); $email_prefix = $first_name; } } $user_username = $email_prefix; // Generate an email based on their name if no email address is given if ($user_email == '') { if ($first_name == 'Unknown') { $status_id = 7; } $email = strtolower($email_prefix) . '@' . $this->option('domain'); $user_email = str_replace("'", '', $email); } } $this->comment('Full Name: ' . $user_name); $this->comment('First Name: ' . $first_name); $this->comment('Last Name: ' . $last_name); $this->comment('Username: '******'Email: ' . $user_email); $this->comment('License Name: ' . $user_license_name); $this->comment('Serial No: ' . $user_license_serial); $this->comment('Licensed To Name: ' . $user_licensed_to_name); $this->comment('Licensed To Email: ' . $user_licensed_to_email); $this->comment('Seats: ' . $user_license_seats); $this->comment('Reassignable: ' . $user_license_reassignable); $this->comment('Supplier: ' . $user_license_supplier); $this->comment('Maintained: ' . $user_license_maintained); $this->comment('Notes: ' . $user_license_notes); $this->comment('Purchase Date: ' . $user_license_purchase_date); $this->comment('------------- Action Summary ----------------'); if ($user_username != '') { if ($user = User::where('username', $user_username)->whereNotNull('username')->first()) { $this->comment('User ' . $user_username . ' already exists'); } else { $user = new \App\Models\User(); $password = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 20); $user->first_name = $first_name; $user->last_name = $last_name; $user->username = $user_username; $user->email = $user_email; $user->permissions = '{user":1}'; $user->password = bcrypt($password); $user->activated = 1; if ($user->save()) { $this->comment('User ' . $first_name . ' created'); } else { $this->error('ERROR CREATING User ' . $first_name . ' ' . $last_name); $this->error($user->getErrors()); } $this->comment('User ' . $first_name . ' created'); } } else { $user = new User(); $user->user_id = null; } // Check for the supplier match and create it if it doesn't exist if ($supplier = Supplier::where('name', $user_license_supplier)->first()) { $this->comment('Supplier ' . $user_license_supplier . ' already exists'); } else { $supplier = new Supplier(); $supplier->name = e($user_license_supplier); $supplier->user_id = 1; if ($supplier->save()) { $this->comment('Supplier ' . $user_license_supplier . ' was created'); } else { $this->comment('Something went wrong! Supplier ' . $user_license_supplier . ' was NOT created'); } } // Add the license $license = new License(); $license->name = e($user_license_name); if ($user_license_purchase_date != '') { $license->purchase_date = $user_license_purchase_date; } else { $license->purchase_date = null; } $license->serial = e($user_license_serial); $license->seats = e($user_license_seats); $license->supplier_id = $supplier->id; $license->user_id = 1; if ($user_license_purchase_date != '') { $license->purchase_date = $user_license_purchase_date; } else { $license->purchase_date = null; } $license->license_name = $user_licensed_to_name; $license->license_email = $user_licensed_to_email; $license->notes = e($user_license_notes); if ($license->save()) { $this->comment('License ' . $user_license_name . ' with serial number ' . $user_license_serial . ' was created'); $license_seat_created = 0; for ($x = 0; $x < $user_license_seats; $x++) { // Create the license seat entries $license_seat = new LicenseSeat(); $license_seat->license_id = $license->id; // Only assign the first seat to the user if ($x == 0) { $license_seat->assigned_to = $user->id; } else { $license_seat->assigned_to = null; } if ($license_seat->save()) { $license_seat_created++; } } if ($license_seat_created > 0) { $this->comment($license_seat_created . ' seats were created'); } else { $this->comment('Something went wrong! NO seats for ' . $user_license_name . ' were created'); } } else { $this->comment('Something went wrong! License ' . $user_license_name . ' was NOT created'); } $this->comment('====================================='); return true; }); }
/** * Fetch an existing supplier or create new if it doesn't exist * * @author Daniel Melzter * @since 3.0 * @param $row array * @return Supplier */ public function createOrFetchSupplier(array $row) { $supplier_name = $this->array_smart_fetch($row, "supplier"); if (empty($supplier_name)) { $supplier_name = 'Unknown'; } foreach ($this->suppliers as $tempsupplier) { if (strcasecmp($tempsupplier->name, $supplier_name) == 0) { $this->log('A matching Company ' . $supplier_name . ' already exists'); return $tempsupplier; } } $supplier = new Supplier(); $supplier->name = $supplier_name; $supplier->user_id = $this->option('user_id'); if (!$this->option('testrun')) { if ($supplier->save()) { $this->suppliers->add($supplier); $this->log('Supplier ' . $supplier_name . ' was created'); return $supplier; } else { $this->log('Supplier', $supplier->getErrors()); return $supplier; } } else { $this->suppliers->add($supplier); return $supplier; } }
public function supplier_register(Request $request) { if ($request->ajax() && $request->method() == 'POST') { $supplier_code = $request->input('supplier_code'); $supplier_name = $request->input('supplier_name'); $preaddress = $request->input('preaddress'); // save data $supplier = new Supplier(); $supplier->code = $supplier_code; $supplier->name = $supplier_name; $supplier->preaddress = $preaddress; $supplier->save(); Session::flash('new_supplier_id', $supplier->id); return response()->json(1); } }