public function updateCompany(Request $request) { $company = Company::find(Auth::user()->company_id); if ($request->has('company-name')) { $company->name = $request->input('company-name'); } if ($request->has('address')) { $company->address = $request->input('address'); } if ($request->has('city')) { $company->city = $request->input('city'); } if ($request->has('state')) { $company->state = $request->input('state'); } if ($request->has('zip')) { $company->zip = $request->input('zip'); } if ($request->has('email')) { $company->email = $request->input('email'); } if ($request->has('phone')) { $company->phone = $request->input('phone'); } $request->session()->flash('success', 'Company Updated!'); $company->save(); $team = User::where('company_id', $company->id)->where('user_type', 2)->get(); return view('manage.company', ['company' => Company::find(Auth::user()->company_id), 'team' => $team]); }
public function showSettings() { $companies = \App\Company::all()->lists('name', 'id'); $current_company = \App\Company::find(Auth::user()->current_company); // dd($current_company); return view('settings.settings', compact('companies', 'current_company')); }
/** * Update the specified resource in storage. * * @param int $id * * @return Response */ public function update(Request $request, $id) { $data = $request->except(['created_at', 'deleted_at']); $company = Company::find($id); $company->update($data); return redirect()->to('wpanel/profile'); }
/** * Update the specified resource in storage. * * @param int $id * @return Response */ public function update(Request $request, $id) { // $this->validate($request, $this->form_rules); $data = ['name' => $request->input('name'), 'website_name' => $request->input('website_name'), 'slogan' => $request->input('slogan'), 'phone_number' => $request->input('phone_number'), 'cell_phone' => $request->input('cell_phone'), 'address' => $request->input('address'), 'state' => $request->input('state'), 'city' => $request->input('city'), 'facebook' => $request->input('facebook'), 'facebook_app_id' => $request->input('facebook_app_id'), 'twitter' => $request->input('twitter'), 'zip_code' => $request->input('zip_code'), 'google_maps_key_api' => $request->input('google_maps_key_api'), 'email' => $request->input('email'), 'contact_email' => $request->input('contact_email'), 'sales_email' => $request->input('sales_email'), 'support_email' => $request->input('support_email'), 'description' => $request->input('description'), 'keywords' => $request->input('keywords'), 'about_us' => $request->input('about_us'), 'refund_policy' => $request->input('refund_policy'), 'privacy_policy' => $request->input('privacy_policy'), 'terms_of_service' => $request->input('terms_of_service')]; $company = Company::find($id); $company->update($data); return redirect()->to('wpanel/profile'); }
/** * 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::find($id); $data = $request->except(['_token', '_method']); //dd($data); $company->update($data); return redirect()->to('company'); }
public static function loadCompany($id) { $company = Company::find($id); if (!empty($company)) { if (intval(Auth::id()) !== intval($company->user_id)) { $company = null; } } return $company; }
public function edit($user_id, Request $request) { $start_time = $request->get('start') ? date("Y-m-d", strtotime($request->get('start') . " -1 day")) : date("Y-m-d", strtotime("-1 month -1 day")); $end_time = $request->get('end') ? date("Y-m-d", strtotime($request->get('end') . " +1 day")) : date("Y-m-d", strtotime("+1 day")); $company_id = Auth::user()->role == "supadmin" ? $request->get('company_id') : $this->company_id[0]; $email = User::where('id', $user_id)->select('email')->pluck('email'); $currency = Company::find($company_id)->currency->title; $data = Payment::shifts($user_id, $company_id, $start_time, $end_time); return view('payment.shifts')->with(['data' => $data, 'currency' => $currency, 'user_email' => $email, 'user_id' => $user_id, 'user_company_id' => $company_id]); }
public function getApprove($id) { if (!$this->entrust->hasRole("super_admin")) { return Redirect::back()->with("error", "You are Not authorized to perform This action"); } $company = Company::find($id); $company->status = "approved"; $company->save(); return Redirect::back()->with("success", "Company Has Been Approved successfully"); }
public function test_new_company_is_suspended() { $company = factory(Company::class)->create(); $this->seeInDatabase('companies', ['id' => $company->id, 'is_suspended' => true]); $company->is_suspended = false; $company->save(); $this->seeInDatabase('companies', ['id' => $company->id, 'is_suspended' => false]); $companyAgain = Company::find($company->id); $this->assertEquals(false, (bool) $companyAgain->is_suspended); }
public function delete(Request $request) { try { $this->validate($request, ['id' => 'required']); $company = Company::find($request->id); $company->forceDelete(); return response(1, 200); } catch (\Exception $e) { return response(0, 400); } }
public function getEdit($id) { $agreement = Agreement::find($id); $company = Company::find($agreement->company_id); $clients = $company->clients()->selectRaw('CONCAT(name, " (Cli)") name_type, id')->lists('name_type', 'id')->all(); $providers = $company->providers()->selectRaw('CONCAT(name, " (Pro)") name_type, id')->lists('name_type', 'id')->all(); $companies = $clients + $providers; $companies_selected = $agreement->companies()->getRelatedIds()->all(); $data = array('agreement' => $agreement, 'companies' => $companies, 'companies_selected' => $companies_selected); return view('admin.agreement.edit', $data); }
public function update($id) { $input = \Input::all(); $v = \Validator::make($input['company'], \App\Company::$updateRules); if ($v->fails()) { return \Redirect::route('companies.edit', ['id' => $id])->withErrors($v->errors())->withInput(); } $company = \App\Company::find($id); $company->update($input['company']); return \Redirect::route('companies.show', ['company' => $company]); }
public function destroy($id) { $company = Company::find($id); if (!$company) { return response()->json(['message' => 'Record not found'], 404); } if (\Auth::user()->id != $company->id) { return response()->json(['message' => 'You haven\'t permission to delete this entry'], 401); } return response()->json($company->delete(), 204); }
/** * Bootstrap any application services. * * @return void */ public function boot() { Blade::directive('hasrole', function ($expression) { $expression = explode(',', str_replace(['(', ')', "'"], '', $expression)); return '<?php if(' . (Auth::user() && Auth::user()->hasRole($expression) ? 1 : 0) . '): ?>'; }); Blade::directive('endhasrole', function () { return '<?php endif; ?>'; }); $table = 'company'; if (\Schema::hasTable($table)) { $main_company = Company::find(1); \View::share('main_company', $main_company); } }
/** * Bootstrap any application services. * * @return void */ public function boot() { $table = "company"; if (\Schema::hasTable($table)) { $main_company = Company::find(1)->toArray(); $categories_menu = \Cache::remember('categories_mothers', 25, function () { return Category::select('id', 'name')->childsOf('mothers')->actives()->get()->toArray(); }); $menu = []; foreach ($categories_menu as $value) { $menu[$value['id']] = $value; } \View::share('main_company', $main_company); \View::share('categories_menu', $menu); } }
public function index(Request $request) { if (Auth::user()->role == "supadmin") { $company_id = $request->get('company_id'); } elseif (Auth::user()->role == "worker") { $company_id = implode(",", $this->company_id); } else { $company_id = $this->company_id[0]; } $start_shift = $end_shift = "00:00"; if ($company_id && Auth::user()->role != "worker") { $start_shift = Company::find($company_id)->shift_day_start; $end_shift = Company::find($company_id)->shift_night_start; } $companies = Company::listAll(); $workers = Company::workers($company_id); return view('rosters.list')->with(['company_id' => $company_id, 'shift_start' => $start_shift, 'shift_end' => $end_shift, 'workers' => $workers, 'companies' => $companies]); }
public function destroy($id) { $company = Company::find($id); $campains = Campain::where('company_id', '=', $id)->get(); if (count($campains) > 0) { foreach ($campains as $campain) { $links = Link::where('campain_id', '=', $campain->id)->get(); if (count($links) > 0) { foreach ($links as $link) { $link->delete(); } } $campain->delete(); } } $company->delete(); return redirect('company/'); }
public function moveEmployee(Request $request) { if (!$request->has('team_id') || !$request->has('origin_team_id') || !$request->has('employee_id')) { return $this->returnJsonError('missing_params'); } $input = $request->only('team_id', 'origin_team_id', 'employee_id'); $company_id = (int) $input['team_id']; $employee_id = (int) $input['employee_id']; $employee = Employee::find($employee_id); $company = Company::find($company_id); if ($employee && $company) { $employee->company_id = $company_id; $employee->save(); return $this->returnJsonSuccess(); } else { if (!$employee) { return $this->returnJsonError('employee.miss'); } if (!$company) { return $this->returnJsonError('company.miss'); } } }
public function shiftsUpdate($company_id, Request $request) { $this->validate($request, ['shift_day_start' => ['regex:/[0-9]{2}:[0-9]{2}(AM|PM)/'], 'shift_night_start' => ['regex:/[0-9]{2}:[0-9]{2}(AM|PM)/']]); $shift = Company::find($company_id); $shift->shift_day_start = Common::formatTimeForSQL($request->input('shift_day_start')); $shift->shift_night_start = Common::formatTimeForSQL($request->input('shift_night_start')); $shift->save(); return redirect('/companies/' . $company_id . '/shifts#')->with(['message' => 'Shifts time is updated successfully.']); }
if (($na{1}=='0')&&($na{2}=='0')) return $res . ' ' . $this->mag[$this->magind]; $res .= $res==''? '' : ' and'; $t = (int)$na{1}; $u = (int)$na{2}; switch ($t) { case 0: $res .= ' ' . $this->units[$u]; break; case 1: $res .= ' ' . $this->teens[$u]; break; default:$res .= ' ' . $this->tens[$t] . ' ' . $this->units[$u] ; break; } $res .= ' ' . $this->mag[$this->magind]; return $res; } }*/ $company = \App\Company::find($company_id); ?> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> <title>Robert Johnson Holdings | Invoice</title> <!-- Bootstrap 3.3.5 --> <link rel="stylesheet" href="{{url()}}/bootstrap/css/bootstrap.min.css"> <!-- Font Awesome --> <!--<link rel="stylesheet" href="{{url()}}/bootstrap/font-awesome/css/font-awesome.min.css"> Ionicons <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css">-->
public function publish($company_id, $id) { $job = Job::find($id); $job->status_id = 1; // active this job $job->save(); $company = Company::find($company_id); return view('jobs.publish', compact('company', 'job')); }
//}); // Resource routes for User, Company, Creative, Job Route::resource('coupons', 'CouponController'); Route::resource('users', 'UserController'); Route::resource('companies', 'CompanyController'); Route::resource('creatives', 'CreativeController'); Route::resource('companies.jobs', 'JobController'); Route::get('companies/{company}/jobs/{job}/publish', ['uses' => 'JobController@publish']); // Company routing Route::get('companies/{id}/account-setting', function ($id) { $company = Company::find($id); //$user = $company->getUser(); return view('companies.account-setting', compact('company')); }); Route::get('companies/{id}/dashboard', function ($id) { $company = Company::find($id); return view('companies.dashboard', compact('company')); }); // Creative routing Route::get('creatives/{id}/dashboard', function ($id) { $creative = Creative::find($id); return view('creatives.dashboard', compact('creative')); }); Route::get('creatives/{id}/account-setting', function ($id) { $creative = Creative::find($id); //$user = $creative->getUser(); return view('creatives.account-setting', compact('creative')); }); /* Routing footer pages */ Route::get('pricing-plan', function () { return view('pricing-plan');
public function store(Request $request) { if (Auth::user()->role != "supadmin" && $request->input('type') == "supadmin") { abort(401); } $rules = ['email' => 'required|email|unique:users', 'type' => 'required', 'names' => 'required', 'coordinates' => 'required', 'address' => 'required', 'mobile' => 'required', 'birth_date' => 'regex:/[0-9]{2}\\/[0-9]{2}\\/[0-9]{4}/', 'avatar' => 'image|mimes:jpg,jpeg,bmp,png,gif,tiff', 'cv' => 'mimes:doc,docx,ppt,pps,pptx,ppsx,xls,xlsx']; if (Auth::user()->role == "supadmin") { $rules['company'] = 'required'; } $this->validate($request, $rules); $avatar_file_name = null; $cv_file_name = null; if ($request->file('avatar')) { $avatar_file_name = Common::randString(6) . "." . $request->file('avatar')->getClientOriginalExtension(); Storage::put('avatars/' . $avatar_file_name, file_get_contents($request->file('avatar')->getRealPath())); ImageResize::load(storage_path("app") . '/avatars/' . $avatar_file_name); ImageResize::resizeToWidth(300); ImageResize::save(); } if ($request->file('cv')) { $cv_file_name = Common::randString(6) . "." . $request->file('cv')->getClientOriginalExtension(); Storage::put('cv/' . $cv_file_name, file_get_contents($request->file('cv')->getRealPath())); } $password = Common::generateStrongPassword(); if (Auth::user()->role == "supadmin") { $company_id = $request->input('company'); } else { $company_id = $this->company_id[0]; } $rand = array('0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', 'd', 'e', 'f'); $user = new User(); $user->role = $request->input('type'); $user->password = Hash::make($password); $user->email = $request->input('email'); $user->events_color = '#' . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)] . $rand[rand(0, 15)]; $user->save(); $info = new PersonalInfo(); $info->names = $request->input('names'); $info->address = $request->input('address'); $info->coordinates = $request->input('coordinates'); $info->mobile = $request->input('mobile'); $info->gender = $request->input('gender'); $info->birth_date = $request->input('birth_date'); $info->home_phone = $request->input('home_phone'); $info->work_phone = $request->input('work_phone'); $info->fax = $request->input('fax'); $info->other = $request->input('other'); $info->avatar = $avatar_file_name; $info->cv = $cv_file_name; $user->info()->save($info); Company::find($company_id)->users()->attach($user->id); Notification::add($user->id, 'USER_ADD_BY_ADMIN', ['admin_id' => Auth::user()->id]); Mail::send('emails.newUserPassword', ['user' => $user, 'info' => $info, 'password' => $password, 'company' => Company::find($company_id)->pluck('name')], function ($m) use($user) { $m->from('*****@*****.**', 'TIMELINE'); $m->to($user->email, $user->names)->subject('You have been added to TIMELINE'); }); return redirect('/users')->with(['message' => "User added successfully. Generated password with further login information is sent to his/her email ({$request->input('email')})."]); }
public function getPrice(Request $request, $compid) { // $mcompany = Company::find($compid); $jobprices = \DB::table("prices")->where("company_id", $compid)->get(); return View("settings.price", ["companies" => Company::all(), "mcompany" => $mcompany, 'prices' => $jobprices, "companyname" => $mcompany->name, 'papers' => Paper::all(), 'jobs' => Job::all(), 'title' => 'Job Price Setting']); }
/** * Run the database seeds. * * @return void */ public function run() { $company = Company::find('1'); CompanyFeatures::create(['company_id' => $company->id, 'description' => trans('globals.freeproducts')]); }
/** * Remove the specified resource from storage. * * @param int $id * @return Response */ public function destroy($id) { // $companyId = Request::get('id'); $company = Company::find($companyId); $userId = $company->user->id; User::where('id', $userId)->delete(); return redirect("companies"); }
public function postListRevenueDistribute(Request $request){ $list_order = array(); $company_id = $request->has('company_id')?$request->input('company_id'):0; $month = $request->has('month')?$request->input('month'):0; $year = $request->has('year')?$request->input('year'):0; if($month!='all'){ $begin = date('Y-m-d H:i:s',strtotime('1'.'-'.$month.'-'.$year)); $end = date('Y-m-d H:i:s',strtotime('1'.'-'.($month+1).'-'.$year)); }else{ $begin = date('Y-m-d H:i:s',strtotime('1-1-'.$year)); $end = date('Y-m-d H:i:s',strtotime('1-1-'.($year+1))); } $key_order = 1; $list_so = Mproduct::select('m_products.*','products.name','products.id','saleorders.date') ->addSelect(DB::raw(' sum(amount) as sum_amount , sum(invest) as sum_invest')) ->leftJoin('products','products.id','=','m_products.product_id') ->leftJoin('saleorders',function($join){ $join->on('saleorders.id','=','m_products.module_id') ->where('module_type','=','App\Saleorder'); }) ->leftJoin(DB::raw('(select id,company_id from m_products where module_type="App\\\\Purchaseorder" or module_type="in_stock") as ncc'),'ncc.id','=','m_products.m_product_id') ->where('ncc.company_id','=',$company_id) ->where('saleorders.date','>=',$begin) ->where('saleorders.date','<',$end) ->where('saleorders.status','=',1) ->groupBy('product_id') ->get()->toArray(); foreach ($list_so as $key => $value) { $list_order[$key_order]['id'] = $value['id']; $list_order[$key_order]['name'] = $value['name']; $list_order[$key_order]['date'] = $value['date']; $list_order[$key_order]['sum_amount'] = $value['sum_amount']; $list_order[$key_order]['sum_invest'] = $value['sum_invest']; $list_order[$key_order]['khoang_giam'] = 0; $list_order[$key_order]['lai'] = $list_order[$key_order]['sum_amount'] - $list_order[$key_order]['sum_invest']; $list_order[$key_order]['loi_nhuan'] = $list_order[$key_order]['lai'] - $list_order[$key_order]['khoang_giam']; $list_order[$key_order]['updated_at'] = $value['updated_at']; $arr_product[$key_order] = $value['id']; $key_order++; } $list_rso = Mproduct::select('m_products.*','products.name','products.id','return_saleorders.date') ->addSelect(DB::raw(' sum(amount) as sum_amount , sum(invest) as sum_invest')) ->leftJoin('products','products.id','=','m_products.product_id') ->leftJoin('return_saleorders',function($join){ $join->on('return_saleorders.id','=','m_products.module_id') ->where('module_type','=','App\ReturnSaleorder'); }) ->leftJoin(DB::raw('(select id,company_id from m_products where module_type="App\\\\Purchaseorder" or module_type="in_stock") as ncc'),'ncc.id','=','m_products.m_product_id') ->where('ncc.company_id','=',$company_id) ->where('return_saleorders.date','>=',$begin) ->where('return_saleorders.date','<',$end) ->where('return_saleorders.status','=',1) ->groupBy('product_id') ->get()->toArray(); foreach ($list_rso as $key => $value) { $check_in_array = array_search($value['id'], $arr_product); if($check_in_array){ $list_order[$check_in_array]['sum_amount'] -= $value['sum_amount']; $list_order[$check_in_array]['sum_invest'] -= $value['sum_invest']; $list_order[$check_in_array]['khoang_giam'] -= (abs($value['sum_amount']) - abs($value['sum_invest'])); $list_order[$check_in_array]['loi_nhuan'] = $list_order[$check_in_array]['lai'] + $list_order[$check_in_array]['khoang_giam']; }else{ $list_order[$key_order]['id'] = $value['id']; $list_order[$key_order]['name'] = $value['name']; $list_order[$key_order]['date'] = $value['date']; $list_order[$key_order]['sum_amount'] = -$value['sum_amount']; $list_order[$key_order]['sum_invest'] = -$value['sum_invest']; $list_order[$key_order]['khoang_giam'] = - (abs($list_order[$key_order]['sum_amount']) - abs($list_order[$key_order]['sum_invest'])); $list_order[$key_order]['lai'] = 0; $list_order[$key_order]['loi_nhuan'] = $list_order[$key_order]['lai'] + $list_order[$key_order]['khoang_giam']; $list_order[$key_order]['updated_at'] = $value['updated_at']; $key_order++; } } $date = array(); foreach ($list_order as $key => $value) { $date[$key] = $value['date']; } array_multisort($date,SORT_ASC,$list_order); $company_name = Company::find($company_id); $company_name = $company_name->name; $arr_cache = [ 'month'=>$month, 'year'=>$year, 'company_name'=>$company_name, 'list_order'=>$list_order ]; \Cache::put('list_revenue_distribute'.\Auth::user()->id, $arr_cache, 30); return view('revenue.list-revenue-distribute',[ 'list_order' => $list_order ]); }
/** * redirect user to view the pageredirect * @param integer $id * @return Response */ public function editShowProfile($id) { //authorization if (!$this->adminAuth() && !$this->companyAuth(Auth::User()->id)) { return view('errors.404'); } $countries = Country::all(); $company = Company::find($id); return view('companies.editprofile', compact('company', 'countries')); }
public function postUpdate(Request $request) { $arr_return = array( 'status' => 'error', 'message'=>'' ); $time =date('H:i:s', time()); $id_return_purchaseorder = session('current_returnpurchaseorder') !== null ? session('current_returnpurchaseorder') : 0; if($id_return_purchaseorder){ $returnpurchaseorder = ReturnPurchaseorder::find($id_return_purchaseorder); session(['current_returnpurchaseorder' => $returnpurchaseorder['id']]); $time = date('H:i:s', strtotime($returnpurchaseorder->date)); }else{ $returnpurchaseorder = new ReturnPurchaseorder; $returnpurchaseorder->date = date("Y-m-d H:i:s"); $returnpurchaseorder->created_by = \Auth::user()->id; $returnpurchaseorder->save(); Log::create_log(\Auth::user()->id,'App\ReturnPurchaseorder','Tạo mới đơn hàng trả nhà cung cấp số '.$returnpurchaseorder->id); session(['current_returnpurchaseorder' => $returnpurchaseorder->id]); } $log = ''; $old_company_id = $returnpurchaseorder->company_id; if($returnpurchaseorder->status == 0){ $address = Address::where('module_id','=',$returnpurchaseorder->id) ->where('module_type','=','App\ReturnPurchaseorder')->first(); if(!$address){ $address = new Address; } if($request->has('company_id') && $returnpurchaseorder->company_id != $request->input('company_id')){ $old = Company::find($returnpurchaseorder->company_id); if(!$old){ $old = (object) ['name'=>'']; } $new = Company::find($request->input('company_id')); $log .= 'công ty từ "'.$old->name.'" thành "'.$new->name.'" '; } if($returnpurchaseorder->company_id == $request->input('company_id')){ if($request->has('user_id') && $returnpurchaseorder->user_id != $request->input('user_id')){ $old = User::find($returnpurchaseorder->user_id); if(!$old){ $old = (object) ['name'=>'']; } $new = User::find($request->input('user_id')); $log .= 'người liên hệ từ "'.$old->name.'" thành "'.$new->name.'" '; } $old_date=date("Y-m-d",strtotime($returnpurchaseorder->date)); $new_date = date("Y-m-d",strtotime($request->input('date'))); if($request->has('date') && $old_date != $new_date){ $log .= 'ngày từ "'.$old_date.'" thành "'.$new_date.'" '; } if($request->has('company_phone') && $returnpurchaseorder->company_phone != $request->input('company_phone')){ $log .= 'số điện thoại từ "'.$returnpurchaseorder->company_phone.'" thành "'.$request->input('company_phone').'" '; } if($request->has('company_email') && $returnpurchaseorder->company_email != $request->input('company_email')){ $log .= 'email từ "'.$returnpurchaseorder->company_email.'" thành "'.$request->input('company_email').'" '; } if($request->has('address') && $address->address != $request->input('address')){ $log .= 'địa chỉ từ "'.$address->address.'" thành "'.$request->input('address').'" '; } if($request->has('town_city') && $address->town_city != $request->input('town_city')){ $log .= 'quận huyện từ "'.$address->town_city.'" thành "'.$request->input('town_city').'" '; } if($request->has('province_id') && $address->province_id != $request->input('province_id')){ $old = Province::find($address->province_id); $new = Province::find($request->input('province_id')); if(!$old){ $old = (object) ['name'=>'']; } $log .= 'tỉnh thành từ "'.$old->name.'" thành "'.$new->name.'" '; } if($request->has('country_id') && $address->country_id != $request->input('country_id')){ $old = Country::find($address->country_id); $new = Country::find($request->input('country_id')); if(!$old){ $old = (object) ['name'=>'']; } $log .= 'quốc gia từ "'.$old->name.'" thành "'.$new->name.'" '; } } $returnpurchaseorder->company_id = $request->has('company_id') ? $request->input('company_id') : 0; $returnpurchaseorder->user_id = $request->has('user_id') ? $request->input('user_id') : 0; $returnpurchaseorder->date = $request->has('date') ? date("Y-m-d H:i:s",strtotime($request->input('date').' '.$time)) : date("Y-m-d H:i:s"); $returnpurchaseorder->company_phone = $request->has('company_phone') ? $request->input('company_phone') : ''; $returnpurchaseorder->company_email = $request->has('company_email') ? $request->input('company_email') : ''; $address_id = isset($returnpurchaseorder->address_id) ? $returnpurchaseorder->address_id : 0; $address->module_id = $returnpurchaseorder->id; $address->module_type = 'App\\ReturnPurchaseorder'; $address->address = $request->has('address') ? $request->input('address') : ''; $address->town_city = $request->has('town_city') ? $request->input('town_city') : ''; $address->zip_postcode = $request->has('zip_postcode') ? $request->input('zip_postcode') : ''; $address->country_id = $request->has('country_id') ? $request->input('country_id') : 0; $address->province_id = $request->has('province_id') ? $request->input('province_id') : 0; $address->save(); $returnpurchaseorder->address_id = $address->id; }else{ $returnpurchaseorder->sum_amount = 0; $returnpurchaseorder->sum_invest = 0; } $old_status = $returnpurchaseorder->status; $returnpurchaseorder->status = $request->has('status')?1:0; $check_save_in_stock = true; if($returnpurchaseorder->status){ $arr_mproduct = Mproduct::select('m_products.id','quantity','specification','name','m_product_id','invest') ->where('module_id', '=', $returnpurchaseorder->id) ->where('module_type', '=', 'App\ReturnPurchaseorder') ->leftJoin('products','products.id','=','m_products.product_id') ->get()->toArray(); foreach ($arr_mproduct as $key => $mproduct) { $returnpurchaseorder->sum_amount = $returnpurchaseorder->sum_amount + $mproduct['invest']; $mproduct_po = Mproduct::find($mproduct['m_product_id']); $product_stock = ProductStock::where('m_product_id','=',$mproduct_po->id)->first(); $product_stock->in_stock = $product_stock->in_stock - ($mproduct['quantity']*$mproduct['specification']); if($product_stock->in_stock < 0){ $check_save_in_stock = false; $arr_return['message'] .= 'Số lượng sản phẩm '.$mproduct['name'].' nhập vào lớn hơn số lượng đã nhập<br/><br/>'; } } }else{ if($old_status != $returnpurchaseorder->status){ $arr_mproduct = Mproduct::select('m_products.id','quantity','specification','name','m_product_id') ->where('module_id', '=', $returnpurchaseorder->id) ->where('module_type', '=', 'App\ReturnPurchaseorder') ->leftJoin('products','products.id','=','m_products.product_id') ->get()->toArray(); foreach ($arr_mproduct as $key => $mproduct) { $mproduct_po = Mproduct::find($mproduct['m_product_id']); $product_stock = ProductStock::where('m_product_id','=',$mproduct_po->id)->first(); $product_stock->in_stock = $product_stock->in_stock + ($mproduct['quantity']*$mproduct['specification']); $product_stock->save(); } } } if($check_save_in_stock){ $returnpurchaseorder->updated_by = \Auth::user()->id; if($returnpurchaseorder->save()){ Log::create_log(\Auth::user()->id,'App\ReturnPurchaseorder','Cập nhật '.$log.' đơn hàng trả nhà cung cấp số '.$returnpurchaseorder->id); if($returnpurchaseorder->status){ foreach ($arr_mproduct as $key => $mproduct) { $mproduct_po = Mproduct::find($mproduct['m_product_id']); $product_stock = ProductStock::where('m_product_id','=',$mproduct_po->id)->first(); $product_stock->in_stock = $product_stock->in_stock - ($mproduct['quantity']*$mproduct['specification']); $product_stock->save(); } } if($old_company_id != $returnpurchaseorder->company_id){ Mproduct::where('module_id', '=', $returnpurchaseorder->id) ->where('module_type', '=', 'App\ReturnPurchaseorder') ->where('company_id','=',$old_company_id) ->delete(); }else{ Mproduct::where('module_id', '=', $returnpurchaseorder->id) ->where('module_type', '=', 'App\ReturnPurchaseorder') ->update(['company_id' => $returnpurchaseorder->company_id ]); } $arr_return['status']= 'success'; }else{ $arr_return['message']= 'Saving fail !'; } } return $arr_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) { $company = Company::find($id); $friendly_url = $company->friendly_url; $company->fill($request->all()); // if has file if ($request->hasFile('image')) { $image_name = $this->uploadImage($request->file('image'), 'companies', $friendly_url); $company->image = $image_name; } $company->save(); Session::flash('message', 'Compañía actualizada Correctamente'); return Redirect::to('companies'); }