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