/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['region' => 'required|max:100|unique_with:regions, region_code = region_code', 'region_code' => 'required|not_in:0']); \DB::beginTransaction(); try { $region = new Region(); $region->region_code = $request->region_code; $region->region = $request->region; $region->save(); \DB::commit(); Session::flash('flash_message', 'Region successfully added!'); return redirect()->route("region.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Store a newly created resource in storage. * * @param \Illuminate\Http\Request $request * @return \Illuminate\Http\Response */ public function store(Request $request) { $this->validate($request, ['brand' => 'required|max:100|unique_with:secondary_displays, category = category_id', 'category' => 'required|not_in:0']); \DB::beginTransaction(); try { $display = new SecondaryDisplay(); $display->category_id = $request->category; $display->brand = $request->brand; $display->save(); \DB::commit(); Session::flash('flash_message', 'Secondary Display successfully added!'); return redirect()->route("secondarydisplay.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['distributor' => 'required|max:100|unique_with:distributors, distributor_code = distributor_code', 'distributor_code' => 'required|not_in:0']); \DB::beginTransaction(); try { $distributor = new Distributor(); $distributor->distributor_code = $request->distributor_code; $distributor->distributor = $request->distributor; $distributor->save(); \DB::commit(); Session::flash('flash_message', 'Distributor successfully added!'); return redirect()->route("distributor.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['area' => 'required|max:100|unique_with:areas, customer = customer_id', 'customer' => 'required|not_in:0']); \DB::beginTransaction(); try { $area = new Area(); $area->customer_id = $request->customer; $area->area = $request->area; $area->save(); \DB::commit(); Session::flash('flash_message', 'Area successfully added!'); return redirect()->route("area.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['name' => 'required|max:100']); \DB::beginTransaction(); try { $role = new Role(); $role->name = $request->name; $role->display_name = $request->display_name; $role->description = $request->description; $role->save(); \DB::commit(); Session::flash('flash_message', 'Role successfully added!'); return redirect()->route("role.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * 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(); } }
public function restoreStockForProduct(Request $request) { $purchaseOrderId = $request->input('purchase_order_id'); $productId = $request->input('product_id'); try { \DB::beginTransaction(); // First restore the stock levels for the product deleted from the PO $this->workOrderSchedulerService->restoreStockForProducts($purchaseOrderId, $productId); // Now delete any workorders for this product generated by the PO $this->workOrderSchedulerService->deleteWorkOrdersForPo($purchaseOrderId, $productId); // Finally delete the actual purchaseOrderProduct row $this->workOrderSchedulerService->deletePurchaseOrderProduct($purchaseOrderId, $productId); \DB::commit(); } catch (\Exception $ex) { \DB::rollBack(); throw $ex; } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $user = User::findorFail($id); $this->validate($request, ['name' => 'required|max:100', 'email' => 'required|max:100|email', 'username' => 'required|max:100']); \DB::beginTransaction(); try { $user->name = strtoupper($request->name); $user->email = strtolower($request->email); $user->username = $request->username; $user->active = $request->active ? 1 : 0; $user->update(); \DB::commit(); Session::flash('flash_message', 'User successfully updated!'); return redirect()->route("user.edit", [$id]); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
public function store(Request $request) { $this->validate($request, ['app_name' => 'required|max:100']); \DB::beginTransaction(); try { $settings = Setting::find(1); if (!empty($settings)) { $settings->app_name = $request->app_name; $settings->update(); } else { $settings = new Setting(); $settings->app_name = $request->app_name; $settings->save(); } \DB::commit(); Session::flash('flash_message', 'Settings successfully updated!'); return redirect()->back(); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $group = FormGroup::findOrFail($id); $this->validate($request, ['group_desc' => 'required||max:100|unique_with:form_groups,' . $id]); \DB::beginTransaction(); try { $group->group_desc = strtoupper($request->group_desc); $group->secondary_display = $request->secondary_display ? 1 : 0; $group->osa = $request->osa ? 1 : 0; $group->sos = $request->sos ? 1 : 0; $group->custom = $request->custom ? 1 : 0; $group->perfect_store = $request->perfect_store ? 1 : 0; $group->update(); \DB::commit(); Session::flash('flash_message', 'Form Group successfully updated!'); return redirect()->route("formgroup.edit", [$id]); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
public function syncWithJira($id = NULL) { try { \DB::beginTransaction(); if ($id != NULL) { Project::findOrFail($id)->syncWithJira(); } else { foreach (Project::all() as $project) { $project->syncWithJira(); } } \DB::commit(); } catch (\Exception $e) { \DB::rollBack(); throw $e; } return 'synced succesfully'; }
public function storeform(Request $request, $id) { // dd($request->all()); $this->validate($request, ['category' => 'required', 'group' => 'required', 'prompt' => 'required', 'formtype' => 'required']); \DB::beginTransaction(); try { $template = AuditTemplate::find($id); $form_type = FormType::find($request->formtype); $prompt = $request->prompt; foreach ($request->category as $cat_id) { $category = FormCategory::find($cat_id); $cat_order = 1; $a_cat_id = 0; $clast_cnt = AuditTemplateCategory::getLastOrder($template->id); if (empty($clast_cnt)) { $a_cat = AuditTemplateCategory::create(['category_order' => $cat_order, 'audit_template_id' => $template->id, 'category_id' => $category->id]); $a_cat_id = $a_cat->id; } else { $cat = AuditTemplateCategory::categoryExist($template->id, $category->id); if (empty($cat)) { $cat_order = $clast_cnt->category_order + 1; $a_cat = AuditTemplateCategory::create(['category_order' => $cat_order, 'audit_template_id' => $template->id, 'category_id' => $category->id]); $a_cat_id = $a_cat->id; } else { $a_cat_id = $cat->id; } } foreach ($request->group as $grp_id) { $group = FormGroup::find($grp_id); $grp_order = 1; $a_grp_id = 0; $glast_cnt = AuditTemplateGroup::getLastOrder($a_cat_id); if (empty($glast_cnt)) { $a_grp = AuditTemplateGroup::create(['group_order' => $grp_order, 'audit_template_category_id' => $a_cat_id, 'form_group_id' => $group->id]); $a_grp_id = $a_grp->id; } else { $grp = AuditTemplateGroup::categoryExist($a_cat_id, $group->id); if (empty($grp)) { $grp_order = $glast_cnt->group_order + 1; $a_grp = AuditTemplateGroup::create(['group_order' => $grp_order, 'audit_template_category_id' => $a_cat_id, 'form_group_id' => $group->id]); $a_grp_id = $a_grp->id; } else { $a_grp_id = $grp->id; } } $form = Form::create(array('audit_template_id' => $template->id, 'form_type_id' => $form_type->id, 'prompt' => strtoupper($prompt), 'required' => $request->required == '1' ? 1 : 0, 'expected_answer' => $request->expected_answer == '1' ? 1 : 0, 'exempt' => $request->exempt == '1' ? 1 : 0)); if ($request->formtype == 9) { $multiData = array(); foreach ($request->multiselect as $option) { $multiData[] = array('form_id' => $form->id, 'multi_select_id' => $option); } if (count($multiData) > 0) { FormMultiSelect::insert($multiData); } } if ($request->formtype == 10) { $singleData = array(); foreach ($request->singleselect as $option) { $singleData[] = array('form_id' => $form->id, 'single_select_id' => $option); } if (count($singleData) > 0) { FormSingleSelect::insert($singleData); } } if ($request->formtype == 11) { if ($request->has('formula')) { $text = $request->formula; preg_match_all('/:(.*?):/', $text, $matches); $index = array(); foreach ($matches[1] as $value) { $split_up = explode('_', $value); $last_item = $split_up[count($split_up) - 1]; $index[] = $last_item; } $formula1 = $text; foreach ($matches[1] as $key => $a) { $formula1 = str_replace(':' . $a . ':', $index[$key], $formula1); } $formformula = new FormFormula(); $formformula->form_id = $form->id; $formformula->formula = $formula1; $formformula->formula_desc = $request->formula; $formformula->save(); } } if ($request->formtype == 12) { if ($request->has('condition')) { } } $order = 1; $a_frm_id = 0; $last_cnt = AuditTemplateForm::getLastOrder($a_grp_id); if (!empty($last_cnt)) { $order = $last_cnt->order + 1; } AuditTemplateForm::insert(array('audit_template_group_id' => $a_grp_id, 'order' => $order, 'audit_template_id' => $template->id, 'form_id' => $form->id)); } } \DB::commit(); Session::flash('flash_message', 'Template successfully added!'); return redirect()->route("audittemplate.form", $id); } catch (Exception $e) { DB::rollBack(); Session::flash('flash_message', 'An error occured in adding form!'); return redirect()->back(); } }
public function import(Request $request) { try { $file = $_FILES['file']; $regexFilename = '/pacote\\d{10}.txt/'; if (preg_match($regexFilename, $file['name'])) { $arrayObj = $this->getArrayFromFile($file['tmp_name']); return response()->json($arrayObj, 200); } else { throw new \Exception('O nome do arquivo é inválido. Ex: pacote2012207180.txt', 500); } } catch (\Exception $e) { \DB::rollBack(); return response()->json(['message' => $e->getMessage()], 500); } // $file = $request->file('file'); // $regexFilename = '/pacote\d{10}.txt/'; // // if (preg_match($regexFilename, $file->getClientOriginalName())) { // //dd('success'); // } else { // //dd("Nome do arquivo precisa obedecer ao padrão deste exemplo: 'pacote9999999999.txt'"); // } // // $lines = explode(PHP_EOL, File::get($file->getRealPath())); // // $return = []; // foreach($lines as $line) { // $fields = explode(',', $line); // $newArray['package_id'] = $fields[0]; // $newArray['source'] = $fields[1]; // $newArray['destination'] = $fields[2]; // $newArray['port'] = $fields[3]; // $newArray['protocol'] = $fields[4]; // $newArray['data'] = $fields[5]; // $return[] = $newArray; // } // // dd($return); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $lookup = SosLookup::findOrFail($id); $messages = ['unique_with' => 'This combination of selection already exists.']; $this->validate($request, ['customer_id' => 'required|unique_with:sos_lookups, regions = region_id, distributors = distributor_id, stores = store_id, templates = template_id,' . $id, 'regions' => 'required', 'distributors' => 'required', 'stores' => 'required', 'templates' => 'required'], $messages); \DB::beginTransaction(); try { $lookup->customer_id = $request->customer_id; $lookup->region_id = $request->regions; $lookup->distributor_id = $request->distributors; $lookup->store_id = $request->stores; $lookup->template_id = $request->templates; $lookup->update(); SosLookupPercentage::where('sos_lookup_id', $lookup->id)->delete(); foreach ($request->category as $category_id => $category) { $less = $category[0]; foreach ($category as $key => $value) { if ($key > 0) { if (!empty($value)) { $newlookup = new SosLookupPercentage(); $newlookup->sos_lookup_id = $lookup->id; $newlookup->category_id = $category_id; $newlookup->sos_id = $key; $newlookup->less = $less; $newlookup->value = $value; $newlookup->save(); } } } } \DB::commit(); Session::flash('flash_message', 'SOS Lookup successfully updated!'); return redirect()->route("soslookup.edit", [$id]); } catch (Exception $e) { dd($e); DB::rollBack(); return redirect()->back(); } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $lookup = OsaLookup::findOrFail($id); $messages = ['unique_with' => 'This combination of selection already exists.']; $this->validate($request, ['customer_id' => 'required|unique_with:osa_lookups, regions = region_id, distributors = distributor_id, store_id = store_id, templates = template_id,' . $id, 'regions' => 'required', 'distributors' => 'required', 'store_id' => 'required', 'templates' => 'required'], $messages); \DB::beginTransaction(); try { $lookup->customer_id = $request->customer_id; $lookup->region_id = $request->regions; $lookup->distributor_id = $request->distributors; $lookup->store_id = $request->stores; $lookup->template_id = $request->templates; $lookup->update(); OsaLookupTarget::where('osa_lookup_id', $lookup->id)->delete(); foreach ($request->target as $category_id => $value) { if ($category_id > 0) { if (!empty($value)) { $newlookup = new OsaLookupTarget(); $newlookup->osa_lookup_id = $lookup->id; $newlookup->category_id = $category_id; $newlookup->target = $value; $newlookup->total = $request->total[$category_id]; $newlookup->save(); } } } \DB::commit(); Session::flash('flash_message', 'OSA Lookup successfully updated!'); return redirect()->route("osalookup.edit", [$id]); } catch (Exception $e) { dd($e); DB::rollBack(); return redirect()->back(); } }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $matrix = GradeMatrix::findOrFail($id); $this->validate($request, ['desc' => 'required|max:100|unique_with:grade_matrixs, passing = passing,' . $id, 'passing' => 'required|not_in:0']); \DB::beginTransaction(); try { $matrix->desc = $request->desc; $matrix->passing = $request->passing; $matrix->update(); \DB::commit(); Session::flash('flash_message', 'Grade Matrix successfully updated!'); return redirect()->route("gradematrix.edit", [$id]); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { $purchaseOrder = PurchaseOrder::where('id', $id)->first(); if (isset($purchaseOrder)) { try { $workOrderScheduleService = new WorkOrderSchedulerService(); \DB::beginTransaction(); // Restore stock for any non workorder quantities $workOrderScheduleService->restoreStockForProducts($purchaseOrder->id); // Delete any work orders for this PO $workOrderScheduleService->deleteWorkOrdersForPo($purchaseOrder->id); // Now delete the PO itself $purchaseOrder->delete(); \DB::commit(); } catch (\Exception $ex) { \DB::rollBack(); throw $ex; } } }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { // dd($request->all()); $this->validate($request, ['store' => 'required|max:100|unique_with:stores, store_code = store_code,' . $id, 'store_code' => 'required', 'distributor' => 'required|not_in:0', 'template' => 'required|not_in:0', 'passing' => 'required|not_in:0']); \DB::beginTransaction(); try { $store = Store::findOrFail($id); $store->distributor_id = $request->distributor; $store->store_code = $request->store_code; $store->store = $request->store; $store->grade_matrix_id = $request->passing; $store->audit_template_id = $request->template; $store->update(); StoreSosTag::where('store_id', $store->id)->delete(); if (!empty($request->cat)) { foreach ($request->cat as $key => $value) { $data[] = ['store_id' => $store->id, 'form_category_id' => $key, 'sos_tag_id' => $value]; } StoreSosTag::insert($data); } \DB::commit(); Session::flash('flash_message', 'Store successfully updated!'); return redirect()->route("store.edit", [$id]); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { $category = FormCategory::findOrFail($id); $this->validate($request, ['category' => 'required|max:100|unique_with:form_categories,' . $id]); \DB::beginTransaction(); try { $category->category = $request->category; $category->secondary_display = $request->secondary_display ? 1 : 0; $category->osa_tagging = $request->osa_tagging ? 1 : 0; $category->sos_tagging = $request->sos_tagging ? 1 : 0; $category->custom = $request->custom ? 1 : 0; $category->perfect_store = $request->perfect_store ? 1 : 0; $category->update(); \DB::commit(); Session::flash('flash_message', 'Form Catagory successfully updated!'); return redirect()->route("formcategory.edit", [$id]); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
/** * Store a newly created resource in storage. * * @param Request $request * @return Response */ public function store(Request $request) { $this->validate($request, ['prompt' => 'required|max:100|unique_with:forms, formgroup = form_group_id, formtype = form_type_id', 'formgroup' => 'required|not_in:0', 'formtype' => 'required|not_in:0']); \DB::beginTransaction(); try { $form = new Form(); $form->form_group_id = $request->formgroup; $form->form_type_id = $request->formtype; $form->prompt = $request->prompt; $form->required = $request->required == '1' ? 1 : 0; $form->expected_answer = $request->expected_answer == '1' ? 1 : 0; $form->exempt = $request->exempt == '1' ? 1 : 0; $form->save(); if ($request->formtype == 9) { $multiData = array(); foreach ($request->multiselect as $option) { $multiData[] = array('form_id' => $form->id, 'multi_select_id' => $option); } if (count($multiData) > 0) { FormMultiSelect::insert($multiData); } } if ($request->formtype == 10) { $singleData = array(); foreach ($request->singleselect as $option) { $singleData[] = array('form_id' => $form->id, 'single_select_id' => $option); } if (count($singleData) > 0) { FormSingleSelect::insert($singleData); } } if ($request->formtype == 11) { if ($request->has('formula')) { $formformula = new FormFormula(); $formformula->form_id = $form->id; $formformula->formula = $request->formula; $formformula->save(); } } \DB::commit(); Session::flash('flash_message', 'Form successfully added!'); return redirect()->route("form.index"); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }
public function import(Request $request) { try { $file = $_FILES['file']; $regexFilename = '/pacote\\d{10}.txt/'; if (preg_match($regexFilename, $file['name'])) { $arrayObj = $this->getArrayFromFile($file['tmp_name']); $rules = Rule::orderBy('priority', 'ASC')->get()->toArray(); // é necessário que se faça uma transaçao do banco... $return = array(); foreach ($arrayObj as $obj) { $return[] = $this->validateObj($obj, $rules); } foreach ($return as $k => $v) { if (is_null($v)) { $return[$k] = 'Este pacote não se encaixou em nenhuma regra'; } } return response()->json($return, 200); } else { //dd("Nome do arquivo precisa obedecer ao padrão deste exemplo: 'pacote9999999999.txt'"); throw new \Exception('O nome do arquivo é inválido. Ex: pacote2012207180.txt', 500); } } catch (\Exception $e) { \DB::rollBack(); return response()->json(['message' => $e->getMessage()], 500); } }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $store = Store::findOrFail($id); $this->validate($request, ['store_id' => 'required', 'brands' => 'required']); \DB::beginTransaction(); try { SecondaryDisplayLookup::where('store_id', $store->id)->delete(); foreach ($request->brands as $value) { SecondaryDisplayLookup::create(['store_id' => $store->id, 'secondary_display_id' => $value]); } \DB::commit(); Session::flash('flash_message', 'Secondary Display Lookup successfully updated!'); return redirect()->route("secondarylookup.edit", [$id]); } catch (Exception $e) { DB::rollBack(); return redirect()->back(); } }