/** * Get the validation rules that apply to the request. * * @return array */ public function rules() { $type = $this->input('type_request'); if ($type == 0) { return ['name' => 'required|max:255|unique:companies', 'email' => 'required|email|unique:users', 'first_name' => 'required|max:255', 'last_name' => 'required|max:255', 'password' => 'required|min:5|max:20|same:confirm_password', 'confirm_password' => 'required|min:5']; } else { $email = $this->input('email'); $name = $this->input('name'); $user_id = $this->input('user_id'); $company_id = $this->input('company_id'); $company = Company::findOrFail($company_id); $user = User::findOrFail($user_id); if ($user->email == $email) { if ($company->name == $name) { return ['first_name' => 'required|max:255', 'last_name' => 'required|max:255', 'password' => 'min:5|max:20', 'new_password' => 'min:5|same:confirm_password']; } else { return ['name' => 'required|max:255|unique:companies', 'first_name' => 'required|max:255', 'last_name' => 'required|max:255', 'password' => 'min:5|max:20', 'new_password' => 'min:5|same:confirm_password']; } } else { if ($company->name == $name) { return ['email' => 'required|email|unique:users', 'first_name' => 'required|max:255', 'last_name' => 'required|max:255', 'password' => 'min:5|max:20', 'new_password' => 'min:5|same:confirm_password']; } else { return ['name' => 'required|max:255|unique:companies', 'email' => 'required|email|unique:users', 'first_name' => 'required|max:255', 'last_name' => 'required|max:255', 'password' => 'min:5|max:20', 'new_password' => 'min:5|same:confirm_password']; } } } }
/** * Show the form for editing the specified resource. * * @param int $id * @return \Illuminate\Http\Response */ public function edit($id) { $project = \App\Project::findOrFail($id); $yearslist = \App\Year::lists('year', 'id'); $companies = \App\Company::findOrFail($project->company_id); $officers_for_dropdown = \App\Officer::lists('last_name', 'id'); return view('pages.project.edit', compact('project', 'companies', 'officers_for_dropdown', 'yearslist')); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $company = Company::findOrFail($id); $this->validate($request, ['name' => 'required|unique:companies,name,' . $id . '|max:255']); $company->name = $request->input('name'); $company->description = $request->input('description', ""); $company->save(); return redirect()->route('company.index'); }
public function destroy($id) { $company = Company::findOrFail($id); $company->delete(); session()->flash('flash_message_danger', 'Empresa borrada correctamente.'); // Si flash_message_important esta presente, el mensaje no desaparece hasta que el usuario lo cierre // session()->flash('flash_message_important', true); return redirect('empresas'); }
/** * @return company The return value is suspended Company instance. */ public function methodToInvoke($params) { // check does all parameters are sent $requiredParams = ['companyId']; $this->checkParameters($params, $requiredParams); $company = Company::findOrFail($params['companyId']); $company->suspend(); $company->save(); return $company; }
/** * Store a newly created resource in storage. * * @return Response */ public function store(Request $request) { $array_sale_order = ['name' => 'SO' . \DB::table('sale_orders')->max('id'), 'sale_order_time' => Input::get('sale_datetime'), 'subTotal' => Input::get('subtotal'), 'discount' => Input::get('discount'), 'total' => Input::get('total'), 'type' => Input::get('type'), 'partner_id' => Input::get('partner_id'), 'paymentMethod_id' => Input::get('paymentMethod_id')]; $sale_order_id = SaleOrder::create($array_sale_order); $lines = sizeof(Input::get('sale_order_line_product_id')); $products_ids = Input::get('sale_order_line_product_id'); $products_name_ids = Input::get('sale_order_line_name'); $products_qty_ids = Input::get('sale_order_line_qty'); $products_unitPrice_ids = Input::get('sale_order_line_unitPrice'); $products_subTotal_ids = Input::get('sale_order_line_subtotal'); for ($i = 0; $i < $lines; $i++) { $sale_line = ['name' => $products_name_ids[$i], 'qty' => $products_qty_ids[$i], 'unitPrice' => $products_unitPrice_ids[$i], 'subTotal' => $products_subTotal_ids[$i], 'sale_order_id' => $sale_order_id->id, 'product_id' => $products_ids[$i]]; SaleOrderLine::create($sale_line); } $saleOrder = $sale_order_id; $company = Company::findOrFail(1); if (Input::get('type') === 'saleOrder') { return view('POS.partials.ticket_report', compact('saleOrder', 'company')); } else { return view('POS.partials.invoice', compact('saleOrder', 'company')); } }
function ordered($date_from_user) { $arr = []; $date_from_user = new Carbon\Carbon($this->formated_date($date_from_user)); if (!is_null($this->orders)) { foreach ($this->orders as $order) { $from = new Carbon\Carbon($this->formated_date($order->from)); $to = new Carbon\Carbon($this->formated_date($order->to)); if ($date_from_user->between($from, $to)) { //$order = \App\Order::where('from', $from)->where('to', $to)->first(); $user = \App\User::findOrFail($order->user_id); $name = $user->name; $company = \App\Company::findOrFail($user->company_id); $updated_time = $order->updated_at; // return array('name'=>$name, 'updated_at'=>$updated_time->toDateTimeString(), 'company'=>$company->name); array_push($arr, array('name' => $name, 'updated_at' => $updated_time->toDateTimeString(), 'company' => $company->name)); } } } return $arr; //print_r($arr); //echo count($arr); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $company = Company::findOrFail($id); $company->delete(); return redirect('company'); }
public function update($id, CompanyRequest $request) { $company = Company::findOrFail($id); $company->update($request->all()); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $user = User::findOrFail($id); $date = new \DateTime(); //this returns the current date time //$dtStr = $date->format('Y-m-d-H-i-s'); //$user->email = $dtStr . '_' . $user->email; $user->status = 'INACTIVE'; $user->inactive_date = $date; $user->save(); $user_role = Auth::user()->role->id; $users = $this->getActiveCompanyUsers(null); $message = 'You have successfully disabled ' . $user->last_name . ', ' . $user->first_name; if ($user_role == 1) { $company = Company::findOrFail(Auth::user()->company_id); return view('company.show', ['company' => $company, 'users' => $users, 'message' => $message]); } else { $keyword = ''; \Session::flash('message', 'You have successfully disabled ' . $user->last_name . ', ' . $user->first_name); return Redirect::action('CompanyUserController@index'); } }
/** * Update the specified resource in storage. * * @param Request $request * @param int $id * @return Response */ public function update(Request $request, $id) { if (Auth::user()->hasRole('member')) { $id = Company::where('comUserId', '=', Auth::user()->id)->first()->comId; } $a = Company::findOrFail($id); if (!$a->validate(Input::all())) { return redirect('company/' . $id . '/edit')->withErrors($a->errors())->withInput(); } $a->fill(Input::all()); $a->save(); Flash::success('Company is updated'); return Redirect::to('company'); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { $company = Company::findOrFail($id); $company->delete(); return redirect()->route('settings.company.index'); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function delete($id) { $company = Company::findOrFail($id); //goals DB::table('goal_managements')->whereIn('user_id', function ($query) use($company) { $query->select('id')->from('users')->whereRaw('users.company_id = ?', array($company->id)); })->delete(); //points DB::table('points')->where('company_id', '=', $company->id)->delete(); //points_audit DB::table('point_audits')->where('company_id', '=', $company->id)->delete(); //sales DB::table('sales')->where('company_id', '=', $company->id)->delete(); //sales_audits DB::table('sale_audits')->where('company_id', '=', $company->id)->delete(); //user_passwords DB::table('user_passwords')->whereIn('user_id', function ($query) use($company) { $query->select('id')->from('users')->whereRaw('users.company_id = ?', array($company->id)); })->delete(); //users DB::table('users')->where('company_id', '=', $company->id)->delete(); //company DB::table('companies')->where('id', '=', $company->id)->delete(); \Session::flash('message', 'You have successfully delete ' . $company->name); $keyword = ''; $companies = Company::paginate(15); return view('company.list', compact('companies', 'keyword')); }
/** * Return the tooltips in Json. * * @return Response */ public function tooltips(Request $request) { $rp_arr = []; $user = \Auth::user(); $data = $request->json()->get('data'); if ($user->role->name == ('admin' or 'root')) { for ($i = 0; $i < count($data); $i++) { $location_id = \App\Location::where('name', $data[$i]['location'])->first()['id']; $from = Carbon::parse($data[$i]['from']); $to = Carbon::parse($data[$i]['to']); $orders = \App\Order::where('from', $from)->where('to', $to)->where('location_id', $location_id)->get(); $tooltip = ''; for ($j = 0; $j < count($orders); $j++) { $thisUser = \App\User::findOrFail($orders[$j]->user_id); $company = \App\Company::findOrFail($thisUser->company_id); if ($j != 0) { $tooltip .= "\r\n"; } $tooltip .= "Ordered by " . $thisUser->name . " from " . $company->name . " at " . $orders[$j]->created_at; } array_push($rp_arr, ['from' => \Carbon\Carbon::parse($from)->format('d-m-Y'), 'to' => \Carbon\Carbon::parse($to)->format('d-m-Y'), 'location' => $data[$i]['location'], 'tooltip' => $tooltip]); } } elseif ($user->role->name == 'staff') { for ($i = 0; $i < count($data); $i++) { $location_id = \App\Location::where('name', $data[$i]['location'])->first()['id']; $from = Carbon::parse($data[$i]['from']); $to = Carbon::parse($data[$i]['to']); $orders = \App\Order::where('from', $from)->where('to', $to)->where('location_id', $location_id)->get(); $tooltip = ''; for ($j = 0; $j < count($orders); $j++) { $thisUser = \App\User::findOrFail($orders[$j]->user_id); if ($thisUser->company_id == $user->company_id) { $company = \App\Company::findOrFail($thisUser->company_id); if ($j != 0) { $tooltip .= "\r\n"; } $tooltip .= "Ordered by " . $thisUser->name . " from " . $company->name . " at " . $orders[$j]->created_at; } } array_push($rp_arr, ['from' => \Carbon\Carbon::parse($from)->format('d-m-Y'), 'to' => \Carbon\Carbon::parse($to)->format('d-m-Y'), 'location' => $data[$i]['location'], 'tooltip' => $tooltip]); } } return response()->json(['data' => $rp_arr]); }
public function test_suspend_company_with_command_on_expiration_date() { $expirationDate = new Carbon('2017-06-30'); $company = factory(Company::class)->create(); $user = factory(User::class, 'admin')->create(); $this->actingAs($user)->visit('/company/' . $company->id . '/edit')->see($company->name)->see('name="licence_expire_at"')->type($expirationDate->toDateString(), 'licence_expire_at')->press('Save Edit')->seeInDatabase('companies', ['id' => $company->id, 'licence_expire_at' => $expirationDate->toDateString(), 'is_suspended' => false])->seeInDatabase('schedules', ['who_object' => Company::class, 'who_id' => $company->id, 'run_at' => $expirationDate->toDateString(), 'action' => ActionCommandSuspendCompanyCommand::class]); // enter to testing time - set date to be expiration date Carbon::setTestNow($expirationDate); $company = Company::findOrFail($company->id); $this->assertEquals(false, $company->is_suspended); $results = \App\Model\ActionQueue\ActionCommandScheduled::run(); $company = Company::findOrFail($company->id); $this->assertEquals(true, $company->is_suspended); // exit from testing time - reset current time Carbon::setTestNow(); }
/** * Update the specified resource in storage. * PUT /companies/{id} * * @param int $id * @return Response */ public function update($id, Request $request) { if (!$request->input('name_commercial')) { $request->merge(['name_commercial' => $request->input('name_fiscal')]); } $company = Company::findOrFail($id); $address = Address::findOrFail($company->address_id); $this->validate($request, Company::$rules); $request->merge(['alias' => $address->alias]); // Alias is mandatory! $this->validate($request, ['address' => Address::$rules]); $company->update($request->all()); $request->merge($request->input('address')); // also replace $address->update($request->except(['address'])); return redirect('companies')->with('info', l('This record has been successfully updated :: (:id) ', ['id' => $id], 'layouts') . $request->get('name_commercial')); }
function update(CreateCompanyRequest $request, $id) { $company = Company::findOrFail($id); $company->update($request->all()); return redirect('companies'); }
public function activate($id) { $company = Company::findOrFail($id); $company->status = 'ACTIVE'; $company->save(); $date = new \DateTime(); DB::table('users')->where('company_id', $id)->update(array('status' => 'ACTIVE', 'active_date' => $date)); \Session::flash('message', 'You have successfully activated ' . $company->name); $keyword = ''; $companies = Company::paginate(15); return view('company.list', compact('companies', 'keyword')); }
public function getCurrentCompanyAttribute() { $company = \App\Company::findOrFail($this->current_company_id); return $company; }
public function findCompany(Route $route) { $this->company = \App\Company::findOrFail($route->getParameter('company')); }
/** * Prepare data used to send email message */ public function prepare() { $company = Company::findOrFail($this->companyId); $this->receiverObj = new ActionCommandMailReceiver(); $this->receiverMethodParams = ['mailSubject' => 'Licence Reminder', 'mailFromEmail' => env('MAIL_FROM_ADDRESS'), 'mailFromName' => env('MAIL_FROM_NAME'), 'mailToEmail' => $company->email, 'mailToName' => $company->name, 'template' => 'emails.company-reminder', 'data' => ['company' => $company]]; }
public function destroy($id) { $company = Company::findOrFail($id); $company->delete(); return true; }
public function remove($id) { $license = License::findOrFail($id); $date = new \DateTime(); //this returns the current date time $license->user_id = 0; $license->save(); if ($license->user_id != 0) { DB::table('users')->where('id', $license->user_id)->update(array('status' => 'INACTIVE', 'inactive_date' => $date)); } \Session::flash('message', 'You have successfully remove user for this License'); $company = Company::findOrFail($license->company_id); $licenses = License::whereRaw('company_id like ? order by id', array($license->company_id))->paginate(15)->appends(Input::except('page')); return view('licenses.list', compact('company', 'licenses')); }
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function ConfirmDelete($id) { # Get the Company to be deleted $company = \App\Company::findOrFail($id); return view('pages.company.delete', compact('company')); }