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
]);
}
