public function anyEntry(Request $request,$id=null) { \DB::enableQueryLog(); if(isset($id) && $id!=null){ $id_return_saleorder = $id; $returnsaleorder = ReturnSaleorder::find($id_return_saleorder); if($returnsaleorder != null){ session(['current_returnsaleorder' => $returnsaleorder['id']]); }else{ return redirect('returnsaleorders'); } }else{ $id_return_saleorder = session('current_returnsaleorder') !== null ? session('current_returnsaleorder') : 0; if($id_return_saleorder){ $returnsaleorder = ReturnSaleorder::find($id_return_saleorder); session(['current_returnsaleorder' => $returnsaleorder['id']]); }else{ $returnsaleorder = ReturnSaleorder::get()->last(); if($returnsaleorder){ session(['current_returnsaleorder' => $returnsaleorder['id']]); }else{ $returnsaleorder = new ReturnSaleorder; $returnsaleorder->date = date("Y-m-d H:i:s"); $returnsaleorder->created_by = \Auth::user()->id; $returnsaleorder->save(); Log::create_log(\Auth::user()->id,'App\ReturnSaleorder','Tạo mới đơn hàng đại lý trả số '.$returnsaleorder->id); session(['current_returnsaleorder' => $returnsaleorder->id]); } } } $address = Address::where('module_id','=',$returnsaleorder->id) ->where('module_type','=','App\ReturnSaleorder')->first(); $address_province = isset($address->province_id)?$address->province_id:0; $country_province = Province::addSelect('provinces.name as province_name') ->where('provinces.id','=',$address_province) ->addSelect('countries.name as country_name') ->leftJoin('countries','countries.id','=','provinces.country_id') ->first(); if($country_province){ $country_province->toArray(); $purchaseorder['province_name'] = $country_province['province_name']; $purchaseorder['country_name'] = $country_province['country_name']; }else{ $purchaseorder['province_name'] = ''; $purchaseorder['country_name'] = ''; } if($address){ $address = $address->toArray(); }else{ $address = array(); } $returnsaleorder = $returnsaleorder->toArray(); $returnsaleorder['province_name'] = isset($country_province->province_name)?$country_province->province_name:''; $returnsaleorder['country_name'] = isset($country_province->country_name)?$country_province->country_name:''; //Init array $distributes = array(); $oums = array(); $users = array(); $countries = array(); $list_product = array(); //Get value array $distributes = Company::getCustomerList()->with('address')->get()->toArray(); $oums = Oum::orderBy('name')->get()->toArray(); $users = User::get(); $countries = Country::with('provinces')->get()->toArray(); $arr_product = MProduct::where('module_type','=','App\ReturnSaleorder') ->where('module_id','=',$returnsaleorder['id']) ->lists('m_product_id_so'); Session::forget('product_of_rso'.session('current_returnsaleorder')); foreach ($arr_product as $key => $value) { Session::put('product_of_rso'.session('current_returnsaleorder').".".$value , $value); } $view_list_product = self::getListProduct(); $arr_create = ReturnSaleorder::select('users.name','return_saleorders.created_at') ->leftJoin('users','users.id','=','return_saleorders.created_by') ->where('return_saleorders.id','=',$returnsaleorder['id']) ->get()->first()->toArray(); $arr_update = ReturnSaleorder::select('users.name','return_saleorders.updated_at') ->leftJoin('users','users.id','=','return_saleorders.updated_by') ->where('return_saleorders.id','=',$returnsaleorder['id']) ->get()->first()->toArray(); $this->layout->arr_create = $arr_create; $this->layout->arr_update = $arr_update; $this->layout->content=view('returnsaleorder.entry',[ 'distributes'=>$distributes, 'users'=>$users, 'countries'=>$countries, 'returnsaleorder'=>$returnsaleorder, 'address'=>$address, 'oums'=>$oums, 'view_list_product'=>$view_list_product ]); }