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; }
/* |-------------------------------------------------------------------------- | END MUNICIPALITIES ROUTING |-------------------------------------------------------------------------- | */ /* |-------------------------------------------------------------------------- | WARDS ROUTING |-------------------------------------------------------------------------- | */ Route::get('list-wards/{municipality}', ['middleware' => 'auth', function ($municipality) { $municipalityObj = Municipality::find($municipality); $districtObj = District::find($municipalityObj->district); $provinceObj = Province::find($districtObj->province); return view('wards.list', compact('districtObj', 'municipalityObj', 'provinceObj')); }]); Route::get('wards-list/{id}', ['middleware' => 'auth', 'uses' => 'WardsController@index']); Route::get('wards/{id}', ['middleware' => 'auth', 'uses' => 'WardsController@edit']); Route::post('updateWard', ['middleware' => 'auth', 'uses' => 'WardsController@update']); Route::post('addWard', ['middleware' => 'auth', 'uses' => 'WardsController@store']); /* |-------------------------------------------------------------------------- | END WARDS ROUTING |-------------------------------------------------------------------------- | */ /* |-------------------------------------------------------------------------- | CATEGORIES ROUTING
/** * Remove the specified resource from storage. * * @param int $id * @return \Illuminate\Http\Response */ public function destroy($id) { // $data = Province::find($id); Session::flash('message', 'Province name "' . $data->name . '" was successfully deleted'); $data->delete(); return redirect('/province'); }
public function getDeleteProvince($id) { $arr_return = array( "status"=>"error" ); $province = Province::find($id); if($province->delete()){ $arr_return['status'] = 'success'; }else{ $arr_return['message']= "Delete fail"; } return $arr_return; }
public function getProvinceNameAttribute() { return Province::find($this->attributes['city_id'])->getRoot()->name; }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { // Start Check Authorization $invalid_auth = 1; $authRole = Auth::user()->UserRoles->role; if ($authRole == 1 or $authRole == 3) { $invalid_auth = 0; } if ($invalid_auth == 1) { Alert::error('Anda tidak memilik akses ini')->persistent('close'); return redirect('dashboard'); } // End Check Authorization $validation = Validator::make($request->all(), Province::rules($id)); // Check if it fails // if ($validation->fails()) { return redirect()->back()->withInput()->with('errors', $validation->errors()); } // Process valid data & go to success page // $province = Province::find($id); // replace old data with new data from the submitted form // // save province data into database // $province->name = $request->input('name'); $province->save(); Alert::success($request->input('name') . ' Saved!')->persistent("Close"); return redirect('province/list')->with('message', 'You just updated an cateogry!'); }
public function getIndex() { // return City::all(); $input = Request::get('option'); $province = Province::find($input); $cities = $province->cities(); return $cities->get(['id', 'name']); }
/** * Update the specified resource in storage. * * @param \Illuminate\Http\Request $request * @param int $id * @return \Illuminate\Http\Response */ public function update(Request $request, $id) { $validation = Validator::make($request->all(), Province::rules($id)); // Check if it fails // if ($validation->fails()) { return redirect()->back()->withInput()->with('errors', $validation->errors()); } // Process valid data & go to success page // $province = Province::find($id); // replace old data with new data from the submitted form // // save province data into database // $province->name = $request->input('name'); $province->save(); Alert::success($request->input('name') . ' Saved!')->persistent("Close"); return redirect('province/list')->with('message', 'You just updated an cateogry!'); }
public function deleteItem() { $id = Input::get('id'); Province::find($id)->delete(); return Redirect::to('/admin/data/provincial-data'); }