public function anyExportPdf(){ $id_template = 2; $arr_print = [ 'arr_list' => [ 'arr_key' => [ 'sku', 'name', 'company_name', 'oum_name', 'specification', 'ton_kho', 'origin_price', 'invest' ], 'arr_head' => [ ['text'=>'Mã','class'=>''], ['text'=>'Tên sản phẩm','class'=>''], ['text'=>'Nhà cung cấp','class'=>''], ['text'=>'Đơn vị','class'=>''], ['text'=>'Quy cách','class'=>''], ['text'=>'Tồn kho','class'=>''], ['text'=>'Giá gốc','class'=>'money'], ['text'=>'Vốn lưu','class'=>'money'] ], 'arr_body'=>[], 'arr_sum'=>[] ], 'arr_data'=> [ ] ]; if (\Cache::has('list_product'.\Auth::user()->id)){ $arr_cache = \Cache::get('list_product'.\Auth::user()->id); $sum_invest = 0; foreach ($arr_cache as $key => $value) { $sum_invest += $value['origin_price']*$value['in_stock']; $arr_cache[$key]['ton_kho'] = floor($value['in_stock'] / $value['specification']).' '.$value['oum_name']; $arr_cache[$key]['invest'] = $value['origin_price']*$value['in_stock']; if($value['in_stock']%$value['specification'] && $value['specification']!=1){ $sodu = $value['in_stock']%$value['specification']; $arr_cache[$key]['ton_kho'] .= ' + '.$sodu.' '.'cái'; } } $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Tổng vốn lưu:','colspan'=>'7'], ['value'=>$sum_invest] ]; $arr_print['arr_list']['arr_body'] = $arr_cache; $link = ExportsController::getCreatePrintPdf($arr_print,$id_template,'danh_sach_san_pham','landscape'); return redirect($link); } die; }
public function anyExportPdfDistributeYear(){ $id_template = 24; $arr_print = [ 'arr_list' => [ 'arr_key' => [ 'name', 'sum_invest', 'sum_amount', 'khoang_giam', 'lai', 'ty_le_lai', 'loi_nhuan' ], 'arr_head' => [ ['text'=>'Công ty','class'=>''], ['text'=>'Giá vốn','class'=>'money'], ['text'=>'Doanh thu','class'=>'money'], ['text'=>'Khoảng giảm','class'=>'money'], ['text'=>'Lãi','class'=>'money'], ['text'=>'Tỷ lệ lãi','class'=>'right strong'], ['text'=>'Lợi nhuận','class'=>'money'] ], 'arr_body'=>[], 'arr_sum'=>[] ], 'arr_data'=> [ ] ]; if (\Cache::has('list_revenue_distribute_year'.\Auth::user()->id)){ $arr_cache = \Cache::get('list_revenue_distribute_year'.\Auth::user()->id); $list_order = $arr_cache['list_order']; $arr_print['arr_data']['year'] = $arr_cache['year']; $total_sum_amount = 0; $total_sum_invest = 0; $total_khoang_giam = 0; $total_lai = 0; $total_loi_nhuan = 0; foreach ($list_order as $key => $value) { $list_order[$key]['date'] = date('d-m-Y',strtotime($value['date'])); $list_order[$key]['ty_le_lai'] = number_format(($value['lai']/$value['sum_invest'])*100,2).'%'; $total_sum_invest += $value['sum_invest']; $total_sum_amount += $value['sum_amount']; $total_lai += $value['lai']; $total_loi_nhuan += $value['loi_nhuan']; $total_khoang_giam += $value['khoang_giam']; } $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Tổng:','colspan'=>'1'], ['value'=>$total_sum_invest], ['value'=>$total_sum_amount], ['value'=>$total_khoang_giam], ['value'=>$total_lai], ['value'=>'','class'=>'center'], ['value'=>$total_loi_nhuan] ]; $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Chi khác:','colspan'=>'6'], ['value'=>-$arr_cache['chi_khac']] ]; $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Lãi thực:','colspan'=>'6'], ['value'=>$total_loi_nhuan - $arr_cache['chi_khac']] ]; $arr_print['arr_list']['arr_body'] = $list_order; $link = ExportsController::getCreatePrintPdf($arr_print,$id_template,'doanh_so_nha_cung_cap_nam_'.$arr_cache['year'],'potrait'); return redirect($link); } die; }
public function anyExportPdfList(){ $id_template = 10; $arr_print = [ 'arr_list' => [ 'arr_key' => [ 'id', 'company_name', 'date', 'status', 'sum_amount' ], 'arr_head' => [ ['text'=>'Mã HĐ','class'=>''], ['text'=>'Nhà cung cấp','class'=>''], ['text'=>'Ngày trả hàng','class'=>''], ['text'=>'Tình trạng','class'=>''], ['text'=>'Tổng tiền','class'=>'money'] ], 'arr_body'=>[], 'arr_sum'=>[] ], 'arr_data'=> [ ] ]; if (\Cache::has('list_returnpurchaseorder'.\Auth::user()->id)){ $arr_cache = \Cache::get('list_returnpurchaseorder'.\Auth::user()->id); $total_sum_amount = 0; foreach ($arr_cache as $key => $value) { $total_sum_amount += $value['sum_amount']; if($value['status']){ $arr_cache[$key]['status'] = 'Hoàn thành'; }else{ $arr_cache[$key]['status'] = 'Mới'; } } $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Tổng cộng:','colspan'=>'4'], ['value'=>$total_sum_amount], ]; $arr_print['arr_list']['arr_body'] = $arr_cache; $link = ExportsController::getCreatePrintPdf($arr_print,$id_template,'danh_sach_tra_hang_ncc','potrait'); return redirect($link); } die; }
public function anyExportPdfCustomerYear(){ $id_template = 14; $arr_print = [ 'arr_list' => [ 'arr_key' => [ 'company_name', 'sum_amount', 'paid', 'no_cu', 'con_lai' ], 'arr_head' => [ ['text'=>'Nhà cung cấp','class'=>''], ['text'=>'Tổng tiền toa','class'=>'money'], ['text'=>'Tiền thanh toán','class'=>'money'], ['text'=>'Nợ cũ','class'=>'money'], ['text'=>'Còn lại','class'=>'money'] ], 'arr_body'=>[], 'arr_sum'=>[] ], 'arr_data'=> [ ] ]; if (\Cache::has('list_receipt_customer_year'.\Auth::user()->id)){ $arr_cache = \Cache::get('list_receipt_customer_year'.\Auth::user()->id); $list_order = $arr_cache['list_order']; $arr_print['arr_data']['year'] = $arr_cache['year']; $total_sum_amount = 0; $total_sum_paid = 0; $total_con_lai = 0; foreach ($list_order as $key => $value) { $total_sum_amount += $value['sum_amount']; $total_sum_paid += $value['paid']; $total_con_lai += $value['con_lai']; } $arr_print['arr_list']['arr_sum'][] = [ ['value'=>'Tổng:','colspan'=>'1'], ['value'=>$total_sum_amount], ['value'=>$total_sum_paid], ['value'=>'','class'=>'center'], ['value'=>$total_con_lai] ]; $arr_print['arr_list']['arr_body'] = $list_order; $link = ExportsController::getCreatePrintPdf($arr_print,$id_template,'cong_no_khach_hang_nam_'.$arr_cache['year'],'potrait'); return redirect($link); } die; }