public function StockCreationExample() { $metric = new Metric(); $metric->name = 'Unit'; $metric->symbol = 'U'; $metric->save(); //Now, create a category to store the inventory record under: $category = new Category(); $category->name = 'VoIP'; $category->save(); $item = new Inventory(); $item->metric_id = $metric->id; $item->category_id = $category->id; $item->name = 'SNOM Headset'; $item->description = 'Very nice for the ear'; $item->save(); $location = new Location(); $location->name = 'Snowball Small Stock Room'; $location->save(); $item->createStockOnLocation(2, $location); $item->createSku('PART1234'); dd($item->sku_code); //$res = Inventory::findBySku(Input::get('sku')); //$item = Inventory::find(1); //dd($item); $supplier = new Supplier(); //Mandatory fields $supplier->name = 'Miro Distribution'; //Optional fields $supplier->address = 'Montague Gardens'; $supplier->postal_code = '8000'; $supplier->zip_code = '12345'; $supplier->country = 'South Africa'; $supplier->region = 'Western Cape'; $supplier->city = 'Cape Town'; $supplier->contact_title = 'Sales Rep'; $supplier->contact_name = 'Mark Sparky'; $supplier->contact_phone = '555 555-5555'; $supplier->contact_fax = '555 555-5556'; $supplier->contact_email = '*****@*****.**'; $supplier->save(); $item = Inventory::find(1); //$supplier = Supplier::find(1); $item->addSupplier($supplier); }
public function post() { $post = Input::all(); $validator = Supplier::validate($post); $supplierId = $post['id']; if ($validator->fails()) { return Redirect::to('distribuidores/' . $supplierId)->withErrors($validator)->withInput(); } else { $supplier = self::__checkExistence($supplierId); if (!$supplierId) { $supplier = new Supplier(); } $supplier->name = $post['name']; $supplier->ruc = $post['ruc']; $supplier->address = $post['address']; $supplier->phone = $post['phone']; $supplier->email = $post['email']; $supplier->web = $post['web']; $supplier->contact = $post['contact']; $supplier->contact_phone = $post['contact_phone']; $supplier->save(); if ($post['status'] == 'inactive') { $supplier->delete(); } else { if ($supplier->trashed()) { $supplier->restore(); } } Session::flash('success', 'Distribuidor guardado correctamente.'); return Redirect::to('distribuidores'); } }
/** * Store a newly created resource in storage. * POST /supplier * * @return Response */ public function store() { $validator = Validator::make(Input::all(), Supplier::$rules); if ($validator->fails()) { return Redirect::to('supplier')->withErrors($validator)->withInput(Input::all()); } else { if (Supplier::where('id_supp', '=', Input::get('id_supp'))->exists()) { $supplier = Supplier::find(Input::get('id_supp')); $supplier->nm_supp = Input::get('nm_supp'); $supplier->alamat = Input::get('alamat'); $supplier->telp = Input::get('telp'); $supplier->fax = Input::get('fax'); $supplier->save(); Session::flash('message', 'Successfully updated supplier!'); return Redirect::to('supplier'); } else { $supplier = new Supplier(); $supplier->id_supp = Input::get('id_supp'); $supplier->nm_supp = Input::get('nm_supp'); $supplier->alamat = Input::get('alamat'); $supplier->telp = Input::get('telp'); $supplier->fax = Input::get('fax'); $supplier->save(); Session::flash('message', 'Successfully created supplier!'); return Redirect::to('supplier'); } } }
public function createSupplier() { $rule = array('first_name' => 'required', 'email' => 'email|required'); $cust = Input::all(); $valid = Validator::make($cust, $rule); if ($valid->fails()) { return Redirect::to('add-supplier'); } else { $supplier = new Supplier(); $supplier->company_name = Input::get('company_name'); $supplier->first_name = Input::get('first_name'); $supplier->last_name = Input::get('last_name'); $supplier->email = Input::get('email'); $supplier->phone_number = Input::get('phone_number'); $supplier->address_1 = Input::get('address_1'); $supplier->address_2 = Input::get('address_2'); $supplier->city = Input::get('city'); $supplier->state = Input::get('state'); $supplier->zip = Input::get('zip'); $supplier->country = Input::get('country'); $supplier->comment = Input::get('comment'); $supplier->account = Input::get('account'); $supplier->save(); return Redirect::to('all-suppliers'); } }
public static function Create($name, $person, $telephone, $email, $address, $bal) { $type = new PartyType('Supplier'); $supplier = new Supplier($type, $name, $person, $telephone, $email, $address, $bal); if ($supplier->save()) { return $supplier; } return false; }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Supplier(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Supplier'])) { $model->attributes = $_POST['Supplier']; if ($model->save()) { $this->redirect(['admin']); } } $this->render('create', ['model' => $model]); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate() { $model = new Supplier(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (isset($_POST['Supplier'])) { $model->attributes = $_POST['Supplier']; if ($model->save()) { Yii::app()->user->setFlash('info', MyFormatter::alertInfo('<strong>Selamat!</strong> Data telah berhasil disimpan.')); $this->redirect(array('view', 'id' => $model->ID_SUPPLIER)); } } $this->render('create', array('model' => $model)); }
/** * Creates a new model. * If creation is successful, the browser will be redirected to the 'view' page. */ public function actionCreate($recv_mode = 'N', $trans_mode = null) { $model = new Supplier(); // Uncomment the following line if AJAX validation is needed // $this->performAjaxValidation($model); if (Yii::app()->user->checkAccess('supplier.create')) { if (isset($_POST['Supplier'])) { $model->attributes = $_POST['Supplier']; if ($model->validate()) { $transaction = Yii::app()->db->beginTransaction(); try { if ($model->save()) { AccountSupplier::model()->saveAccount($model->id, $model->company_name); $transaction->commit(); if ($recv_mode == 'N') { Yii::app()->user->setFlash(TbHtml::ALERT_COLOR_SUCCESS, 'Supplier : <strong>' . $model->company_name . '</strong> have been saved successfully!'); $this->redirect(array('create')); } else { Yii::app()->receivingCart->setSupplier($model->id); $this->redirect(array('receivingItem/index', 'trans_mode' => $trans_mode)); } /* Yii::app()->clientScript->scriptMap['jquery.js'] = false; echo CJSON::encode(array( 'status'=>'success', 'div'=>"<div class=alert alert-info fade in>Successfully added ! </div>", )); Yii::app()->end(); * */ } } catch (CDbException $e) { $transaction->rollback(); Yii::app()->user->setFlash(TbHtml::ALERT_COLOR_WARNING, 'Oop something wrong : <strong>' . $e->getMessage()); } } } } else { throw new CHttpException(403, 'You are not authorized to perform this action'); } if (Yii::app()->request->isAjaxRequest) { Yii::app()->clientScript->scriptMap['*.js'] = false; echo CJSON::encode(array('status' => 'render', 'div' => $this->renderPartial('_form', array('model' => $model), true, false))); Yii::app()->end(); } else { $this->render('create', array('model' => $model)); } }
/** * Performs the work of inserting or updating the row in the database. * * If the object is new, it inserts it; otherwise an update is performed. * All related objects are also updated in this method. * * @param PropelPDO $con * @return int The number of rows affected by this insert/update and any referring fk objects' save() operations. * @throws PropelException * @see save() */ protected function doSave(PropelPDO $con) { $affectedRows = 0; // initialize var to track total num of affected rows if (!$this->alreadyInSave) { $this->alreadyInSave = true; // We call the save method on the following object(s) if they // were passed to this object by their corresponding set // method. This object relates to these object(s) by a // foreign key reference. if ($this->aSupplier !== null) { if ($this->aSupplier->isModified() || $this->aSupplier->isNew()) { $affectedRows += $this->aSupplier->save($con); } $this->setSupplier($this->aSupplier); } if ($this->isNew() || $this->isModified()) { // persist changes if ($this->isNew()) { $this->doInsert($con); } else { $this->doUpdate($con); } $affectedRows += 1; $this->resetModified(); } if ($this->detailBarangMasuksScheduledForDeletion !== null) { if (!$this->detailBarangMasuksScheduledForDeletion->isEmpty()) { DetailBarangMasukQuery::create()->filterByPrimaryKeys($this->detailBarangMasuksScheduledForDeletion->getPrimaryKeys(false))->delete($con); $this->detailBarangMasuksScheduledForDeletion = null; } } if ($this->collDetailBarangMasuks !== null) { foreach ($this->collDetailBarangMasuks as $referrerFK) { if (!$referrerFK->isDeleted() && ($referrerFK->isNew() || $referrerFK->isModified())) { $affectedRows += $referrerFK->save($con); } } } $this->alreadyInSave = false; } return $affectedRows; }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { // $rules = array('name' => 'required|unique:suppliers,name'); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator); } else { // store $supplier = new Supplier(); $supplier->name = Input::get('name'); $supplier->phone_no = Input::get('phone_no'); $supplier->email = Input::get('email'); $supplier->physical_address = Input::get('physical_address'); try { $supplier->save(); return Redirect::route('supplier.index')->with('message', 'Successifully added a new supplier'); } catch (QueryException $e) { Log::error($e); } } }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { $rules = array('name' => 'required|unique:suppliers,name'); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::back()->withErrors($validator)->WithInput(); } else { // store $supplier = new Supplier(); $supplier->name = Input::get('name'); $supplier->phone = Input::get('phone'); $supplier->email = Input::get('email'); $supplier->address = Input::get('address'); $supplier->user_id = Auth::user()->id; try { $supplier->save(); $url = Session::get('SOURCE_URL'); return Redirect::to($url)->with('message', trans('messages.record-successfully-saved')); } catch (QueryException $e) { Log::error($e); } } }
/** * Store a newly created resource in storage. * * @return Response */ public function store() { // $rules = array("supplierId" => "required", "supplierName" => "required", "firstAddress" => "required", "secondAddress" => "required", "area" => "required", "region" => "required", "supplierPhone" => "required|numeric", "supplierFax" => "required|numeric", "supplierEmail" => "required|email", "supplierContact" => "required", "supplierMobile" => "required|numeric"); $validator = Validator::make(Input::all(), $rules); if ($validator->fails()) { return Redirect::to('/supplier/create')->withErrors($validator); } // $supplier = new Supplier(); $supplier->supplierID = Input::get('supplierId'); $supplier->supplierName = Input::get('supplierName'); $supplier->supplierAddress1 = Input::get('firstAddress'); $supplier->supplierAddress2 = Input::get('secondAddress'); $supplier->areaID = Input::get("area"); $supplier->regionID = Input::get("region"); $supplier->supplierPhone = Input::get("supplierPhone"); $supplier->supplierFax = Input::get("supplierFax"); $supplier->supplierEmail = Input::get("supplierEmail"); $supplier->supplierContact = Input::get("supplierContact"); $supplier->supplierMobile = Input::get("supplierMobile"); $supplier->save(); return Redirect::to('/supplier'); }
/** * To get Vendor from client's Data */ function getVendor() { $this->autoRender = false; $sql = "SELECT * FROM vendors;"; $datas = $this->Cabinet->query($sql); App::uses("Supplier", "Inventory.Model"); foreach ($datas as $data) { $supplier = new Supplier(); $vendor['Supplier']['name'] = $data['vendors']['Name']; $vendor['Supplier']['address'] = $data['vendors']['AddressLine1']; $vendor['Supplier']['city'] = $data['vendors']['City']; $vendor['Supplier']['postal_code'] = $data['vendors']['Postal']; $vendor['Supplier']['province'] = $data['vendors']['Province']; $vendor['Supplier']['country'] = "Canada"; $vendor['Supplier']['phone'] = $data['vendors']['PhoneNumber']; $vendor['Supplier']['fax_number'] = $data['vendors']['FaxNumber']; $vendor['Supplier']['terms'] = $data['vendors']['Terms']; $vendor['Supplier']['notes'] = $data['vendors']['Notes']; $vendor['Supplier']['email'] = $data['vendors']['EmailAddress']; $vendor['Supplier']['qb_suplier_name'] = $data['vendors']['QBAccountName']; $vendor['Supplier']['door_supplier'] = $data['vendors']['DoorVendor']; $vendor['Supplier']['cabinet_supplier'] = $data['vendors']['BoxVendor']; $vendor['Supplier']['laminate_supplier'] = $data['vendors']['LaminateVendor']; $vendor['Supplier']['hardware_supplier'] = $data['vendors']['HardwareVendor']; $vendor['Supplier']['gst_rate'] = $data['vendors']['GST']; $vendor['Supplier']['pst_rate'] = $data['vendors']['PST']; $vendor['Supplier']['notes_on_po'] = $data['vendors']['POMemo']; if (!$supplier->save($vendor)) { pr($supplier->validationErrors); } } }
/** * 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 { // Create the user $user = Sentry::createUser(array('first_name' => $first_name, 'last_name' => $last_name, 'email' => $user_email, 'username' => $user_username, 'password' => substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 10), 'activated' => true, 'permissions' => array('admin' => 0, 'user' => 1), 'notes' => 'User importerd through license importer')); // Find the group using the group id $userGroup = Sentry::findGroupById(3); // Assign the group to the user $user->addGroup($userGroup); $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; $license_seat->assigned_to = $user->id; 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; }); }
public function actionUpload() { parent::actionUpload(); $folder = $_SERVER['DOCUMENT_ROOT'] . Yii::app()->request->baseUrl . '/upload/'; // folder for uploaded files $allowedExtensions = array("csv"); $sizeLimit = (int) Yii::app()->params['sizeLimit']; // maximum file size in bytes $uploader = new qqFileUploader($allowedExtensions, $sizeLimit); $result = $uploader->handleUpload($folder, true); $row = 0; if (($handle = fopen($folder . $uploader->file->getName(), "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { if ($row > 0) { $model = Supplier::model()->findByPk((int) $data[0]); if ($model === null) { $model = new Supplier(); } $model->addressbookid = (int) $data[0]; $model->fullname = $data[1]; $model->recordstatus = (int) $data[2]; try { if (!$model->save()) { $errormessage = $model->getErrors(); if (Yii::app()->request->isAjaxRequest) { echo CJSON::encode(array('status' => 'failure', 'div' => $errormessage)); } } } catch (Exception $e) { $errormessage = $e->getMessage(); if (Yii::app()->request->isAjaxRequest) { echo CJSON::encode(array('status' => 'failure', 'div' => $errormessage)); } } } $row++; } fclose($handle); } $result = htmlspecialchars(json_encode($result), ENT_NOQUOTES); echo $result; }
public function postUploadsuppliers() { $rules = array('event' => 'required', 'name' => 'required', 'desc' => 'required', 'categories' => 'required', 'country' => 'required', 'logo' => 'required'); $validator = Validator::make(Input::all(), $rules); if ($validator->passes()) { $s = new Supplier(); $s->name = Input::get('name'); $s->event = Input::get('event'); $s->link = Input::get('link'); $s->description = Input::get('desc'); $s->categories = Input::get('categories'); $s->country = Input::get('country'); $s->order = Input::get('order'); $image1 = Input::file('logo'); $filename = date('Y-m-d-hh-mm-ss') . '-' . $image1->getClientOriginalName(); Image::make($image1->getRealPath())->resize(100, 100)->save(getcwd() . '/images/admin/supplierlogos/' . $filename); $s->imgpath = 'images/admin/supplierlogos/' . $filename; $s->save(); $message = "Supplier Added"; return Redirect::to('admin/uploadsuppliers')->with('message', $message); } return Redirect::to('admin/uploadsuppliers')->with('message', 'Could not add. All fields required, including logo image')->withInput(); }