public function anyExportPdf(){ $id_template = 6; $arr_print = [ 'arr_list' => [ 'arr_key' => [ 'sku', 'name', 'oum_name', 'specification', 'quantity', 'sell_price', 'amount' ], 'arr_head' => [ ['text'=>'Mã','class'=>''], ['text'=>'Tên sản phẩm','class'=>''], ['text'=>'Đơn vị','class'=>'center'], ['text'=>'Quy cách','class'=>'center'], ['text'=>'Số lượng','class'=>'center'], ['text'=>'Đơn giá','class'=>'money'], ['text'=>'Thành tiền','class'=>'money'] ], 'arr_body'=>[], 'arr_sum'=>[] ], 'arr_data'=> [ 'id'=>session('current_returnsaleorder') ] ]; if (\Cache::has('list_product_rso'.\Auth::user()->id)){ $rso = ReturnSaleorder::select('return_saleorders.*','companies.name')->where('return_saleorders.id','=',session('current_returnsaleorder')) ->leftJoin('companies','companies.id','=','return_saleorders.company_id')->get()->first(); $month = intval(date('m',strtotime($rso->date))); $year = intval(date('Y',strtotime($rso->date))); $begin = date('Y-m-d H:i:s',strtotime('1'.'-'.$month.'-'.$year)); $end = $rso->date; $list_order = array(); $key_order = 1; $arr_print['arr_data']['date'] = date('d-m-Y',strtotime($rso->date)); $arr_print['arr_data']['company_name'] = $rso->name; $arr_print['arr_data']['phone'] = $rso->company_phone; $arr_print['arr_data']['address'] = ''; $arr_dress = Address::select('addresses.*','provinces.name as province_name') ->where('addresses.id','=',$rso->address_id) ->leftJoin('provinces','provinces.id','=','addresses.province_id') ->get()->first(); $arr_print['arr_data']['address'] .= $arr_dress->address?$arr_dress->address.', ':''; $arr_print['arr_data']['address'] .= $arr_dress->town_city?$arr_dress->town_city.', ':''; $arr_print['arr_data']['address'] .= $arr_dress->province_name?$arr_dress->province_name:''; $receipt_month_prev = ReceiptMonth::where('type_receipt','=','customer') ->where('company_id','=',$rso->company_id) ->where(function($query) use ($month,$year){ $query->where(function($query2) use ($month,$year){ $query2->where('month','<',$month) ->where('year','=',$year); })->orWhere(function($query2) use ($month,$year){ $query2->where('year','<',$year); }); }) ->orderBy('year','desc') ->orderBy('month','desc') ->limit(1); $receipt_month_prev = $receipt_month_prev->first(); if($receipt_month_prev){ $arr_print['arr_data']['no_cu'] = $receipt_month_prev->con_lai; }else{ $arr_print['arr_data']['no_cu'] = 0; } $list_po = Saleorder::where('date','>=',$begin) ->where('date','<',$end) ->where('status','=',1) ->where('company_id','=',$rso->company_id) ->get()->toArray(); foreach ($list_po as $key => $value) { $list_order[$key_order]['id'] = $value['id']; $list_order[$key_order]['date'] = $value['date']; $list_order[$key_order]['sum_amount'] = $value['sum_amount']; $key_order++; } $list_rso = ReturnSaleorder::where('date','>=',$begin) ->where('date','<',$end) ->where('status','=',1) ->where('company_id','=',$rso->company_id) ->get()->toArray(); foreach ($list_rso as $key => $value) { $list_order[$key_order]['id'] = $value['id']; $list_order[$key_order]['date'] = $value['date']; $list_order[$key_order]['sum_amount'] = -$value['sum_amount']; $key_order++; } $list_paid = Paid::where('date','>=',$begin) ->where('date','<',$end) ->where('company_id','=',$rso->company_id) ->where('type_paid','=','customer') ->get()->toArray(); foreach ($list_paid as $key => $value) { $list_order[$key_order]['id'] = $value['id']; $list_order[$key_order]['date'] = $value['date']; $list_order[$key_order]['sum_amount'] = -$value['sum_paid']; $key_order++; } $date = array(); foreach ($list_order as $key => $value) { $date[$key] = $value['date']; } array_multisort($date,SORT_ASC,$list_order); foreach ($list_order as $key => $value) { $arr_print['arr_data']['no_cu']+=$value['sum_amount']; } $arr_cache = \Cache::get('list_product_rso'.\Auth::user()->id); $sum_amount = 0; foreach ($arr_cache as $key => $value) { $sum_amount += $value['amount']; } if($rso->status==0){ $arr_print['arr_data']['no_cu'] = 0; } $arr_print['arr_data']['toa_moi'] = $sum_amount; $arr_print['arr_data']['tong_cong'] = $arr_print['arr_data']['no_cu'] - $arr_print['arr_data']['toa_moi']; $arr_print['arr_data']['no_cu'] = number_format($arr_print['arr_data']['no_cu']); $arr_print['arr_data']['toa_moi'] = number_format(-$arr_print['arr_data']['toa_moi']); $arr_print['arr_data']['tong_cong'] = number_format($arr_print['arr_data']['tong_cong']); $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Tổng cộng:','colspan'=>'6'], ['value'=>$sum_amount] ]; $arr_print['arr_list']['arr_body'] = $arr_cache; $link = ExportsController::getCreatePrintPdf($arr_print,$id_template,'phieu_dai_ly_tra_hang_so_'.$rso->id,'potrait'); Log::create_log(\Auth::user()->id,'App\ReturnSaleorder','In đơn hàng đại lý trả số '.session('current_returnsaleorder')); return redirect($link); } die; }
public function getListPo(Request $request) { \DB::enableQueryLog(); $list_order = array(); $id_product = session('current_product') !== null ? session('current_product') : 0; $type = $request->has('type')? $request->input('type'): 'all'; $company_id = $request->has('company_id')? $request->input('company_id'): 'all'; $month_year = $request->has('month_year')? $request->input('month_year'): 'all'; if($type=='all' || $type=='po'){ $list_po = Purchaseorder::select('purchaseorders.date','purchaseorders.id','m_products.quantity','m_products.specification','oums.name as oum_name','companies.name as company_name','m_products.id as product_id','product_stocks.in_stock') ->leftJoin('m_products',function($join){ $join->on('m_products.module_id','=','purchaseorders.id') ->where('module_type','=','App\Purchaseorder'); }) ->leftJoin('products','m_products.product_id','=','products.id') ->leftJoin('companies','m_products.company_id','=','companies.id') ->leftJoin('oums','m_products.oum_id','=','oums.id') ->leftJoin('product_stocks','product_stocks.m_product_id','=','m_products.id') ->where('products.id','=',$id_product) ->where('purchaseorders.status','=',1) ->orderBy('date','desc'); if($company_id != 'all') $list_po = $list_po->where('companies.id','=',$company_id); if($month_year != 'all'){ $month = explode('-',$month_year); $list_po = $list_po->whereRaw("MONTH(`purchaseorders`.`date`)=".$month[0]) ->whereRaw("YEAR(`purchaseorders`.`date`)=".$month[1]); } $list_po = $list_po->get()->toArray(); // $query = \DB::getQueryLog(); // print_r($query[count($query)-1]); // pr($list_po);die; foreach ($list_po as $key => $value) { $arr_tmp = array(); $arr_tmp['company_name'] = $value['company_name']; $arr_tmp['oum_name'] = $value['oum_name']; $arr_tmp['specification'] = $value['specification']; $arr_tmp['quantity'] = $value['quantity']; $arr_tmp['id'] = $value['id']; $arr_tmp['product_id'] = $value['product_id']; $arr_tmp['date'] = $value['date']; $arr_tmp['in_stock'] = $value['in_stock']; $arr_tmp['type'] = 'po'; $list_order[] = $arr_tmp; } } if($type=='all' || $type=='rpo'){ $list_rpo = ReturnSaleorder::select('return_saleorders.date','return_saleorders.id','m_products.quantity','m_products.specification','oums.name as oum_name','companies.name as company_name','m_products.id as product_id') ->leftJoin('m_products',function($join){ $join->on('m_products.module_id','=','return_saleorders.id') ->where('module_type','=','App\ReturnSaleorder'); }) ->leftJoin('products','m_products.product_id','=','products.id') ->leftJoin('companies','m_products.company_id','=','companies.id') ->leftJoin('oums','m_products.oum_id','=','oums.id') ->where('products.id','=',$id_product) ->where('return_saleorders.status','=',1) ->orderBy('date','desc'); if($company_id != 'all') $list_rpo = $list_rpo->where('companies.id','=',$company_id); if($month_year != 'all'){ $month = explode('-',$month_year); $list_rpo = $list_rpo->whereRaw("MONTH(`return_saleorders`.`date`)=".$month[0]) ->whereRaw("Year(`return_saleorders`.`date`)=".$month[1]); } $list_rpo = $list_rpo->get()->toArray(); foreach ($list_rpo as $key => $value) { $arr_tmp = array(); $arr_tmp['company_name'] = $value['company_name']; $arr_tmp['oum_name'] = $value['oum_name']; $arr_tmp['specification'] = $value['specification']; $arr_tmp['quantity'] = $value['quantity']; $arr_tmp['id'] = $value['id']; $arr_tmp['date'] = $value['date']; $arr_tmp['in_stock'] = 0; $arr_tmp['type'] = 'rpo'; $list_order[] = $arr_tmp; } } $product = Product::find($id_product)->toArray(); if(($type=='all' || $type=='in_stock') && $month_year == 'all'){ if($product['check_in_stock']){ $list_instock = MProduct::select('m_products.*','product_stocks.in_stock') ->with('company')->with('oum') ->where('m_products.product_id','=',session('current_product')) ->where('module_type','=','in_stock') ->leftJoin('product_stocks','product_stocks.m_product_id','=','m_products.id'); if($company_id != 'all'){ $list_instock = $list_instock->where('m_products.company_id','=',$company_id); } $list_instock = $list_instock->get()->toArray(); foreach ($list_instock as $key => $value) { $arr_tmp = array(); $arr_tmp['company_name'] = $value['company']['name']; $arr_tmp['oum_name'] = $value['oum']['name']; $arr_tmp['specification'] = $value['specification']; $arr_tmp['quantity'] = $value['quantity']; $arr_tmp['id'] = $value['id']; $arr_tmp['product_id'] = $value['product_id']; $arr_tmp['date'] = $value['created_at']; $arr_tmp['in_stock'] = $value['in_stock']; $arr_tmp['type'] = 'in_stock'; $list_order[] = $arr_tmp; } } } $arr_date = array(); foreach ($list_order as $key => $value) { $arr_date[] = $value['date']; } array_multisort($arr_date,SORT_DESC,$list_order); return view('product.list-po',[ 'list_order' => $list_order , 'product' => $product ]); }
public function postListRevenueCustomerYear(Request $request){ DB::enableQueryLog(); $list_order = array(); $year = $request->has('year')?$request->input('year'):0; $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; $arr_company = array(); $list_so = Saleorder::select('saleorders.*','companies.name','companies.id') ->where('date','>=',$begin) ->where('date','<',$end) ->where('status','=',1) ->leftJoin('companies','companies.id','=','saleorders.company_id') ->addSelect(DB::raw('sum(sum_amount) as sum_amount , sum(sum_invest) as sum_invest')) ->groupBy('company_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 = ReturnSaleorder::select('return_saleorders.*','companies.name','companies.id') ->where('date','>=',$begin) ->where('date','<',$end) ->where('status','=',1) ->leftJoin('companies','companies.id','=','return_saleorders.company_id') ->addSelect(DB::raw('sum(sum_amount) as sum_amount , sum(sum_invest) as sum_invest')) ->groupBy('company_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); $chi_khac = RevenueOther::where('date','>=',$begin) ->where('date','<',$end) ->sum('sum_amount'); $arr_cache = [ 'year'=>$year, 'list_order'=>$list_order, 'chi_khac'=>$chi_khac ]; \Cache::put('list_revenue_customer_year'.\Auth::user()->id, $arr_cache, 30); return view('revenue.list-revenue-customer-year',[ 'list_order' => $list_order, 'chi_khac' => $chi_khac ]); }