vegoo/erp-site
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
erp-site/application/controllers/report.php
vegoo 2b4d3e9880 初始版本
2026-04-19 01:39:41 +08:00

2095 lines
101 KiB
PHP
Executable File
Raw Permalink Blame History

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');
class Report extends CI_Controller {
public function __construct(){
parent::__construct();
$this->common_model->checkpurview();
$this->jxcsys = $this->session->userdata('jxcsys');
$this->systems = $this->common_model->get_option('system');
}
public function index() {
$profit = $this->data_model->get_profit('and billDate<="'.date('Y-m-d').'"');
$inventory1 = $inventory2 = 0;
$list = $this->data_model->get_invBalance('a.isDelete=0 and a.billDate<="'.date('Y-m-d').'" '.$this->common_model->get_location_purview().' group by a.invId,a.locationId');
foreach ($list as $arr=>$row) {
$price = isset($profit['inprice'][$row['invId']][$row['locationId']]) ? $profit['inprice'][$row['invId']][$row['locationId']] : 0;
$inventory1 += $row['qty'];
$inventory2 += $row['qty'] * $price;
}
$inventory1 = round($inventory1,$this->systems['qtyPlaces']);
$inventory2 = round($inventory2,2);
$fund1 = $fund2 = 0;
$list = $this->data_model->get_account($this->common_model->get_admin_purview(1),'a.isDelete=0');
foreach ($list as $arr=>$row) {
if ($row['type']==1) {
$fund1 += $row['amount'];
} else {
$fund2 += $row['amount'];
}
}
$fund1 = round($fund1,2);
$fund2 = round($fund2,2);
$contact1 = $contact2 = 0;
$list = $this->data_model->get_contact($this->common_model->get_contact_purview(),'a.isDelete=0');
foreach ($list as $arr=>$row) {
if ($row['type']==-10) {
$contact1 += $row['amount'];
} elseif ($row['type']==10) {
$contact2 += $row['amount'];
} else {
$contact1 = 0;
$contact2 = 0;
}
}
$contact1 = round($contact1,2);
$contact2 = round($contact2,2);
$list = $this->data_model->get_invoice_infosum('a.isDelete=0 and a.billType="PUR" and billDate>="'.date('Y-m-1').'" and billDate<="'.date('Y-m-d').'" '.$this->common_model->get_location_purview().' group by a.invId,a.locationId');
$purchase1 = 0;
foreach ($list as $arr=>$row) {
$purchase1 += $row['sumamount'];
}
$purchase2 = count($list);
$purchase1 = round($purchase1,2);
$purchase2 = round($purchase2,$this->systems['qtyPlaces']);
$sales1 = $sales2 = 0;
$list = $this->data_model->get_invoice_infosum('a.isDelete=0 and billType="SALE" and billDate>="'.date('Y-m-1').'" and billDate<="'.date('Y-m-d').'" '.$this->common_model->get_location_purview().' group by a.invId,a.locationId');
foreach ($list as $arr=>$row) {
$qty = $row['sumqty']>0 ? -abs($row['sumqty']):abs($row['sumqty']);
$amount = $row['sumamount'];
$price = isset($profit['inprice'][$row['invId']][$row['locationId']]) ? $profit['inprice'][$row['invId']][$row['locationId']] : 0;
$cost = $price * $qty;
$saleProfit = $amount - $cost;
$sales1 += $amount;
$sales2 += $saleProfit;
}
$sales1 = round($sales1,2);
$sales2 = round($sales2,2);
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['items'] = array(
array('mod'=>'inventory','total1'=>$inventory1,'total2'=>$inventory2),
array('mod'=>'fund','total1'=>$fund1,'total2'=>$fund2),
array('mod'=>'contact','total1'=>$contact1,'total2'=>$contact2),
array('mod'=>'sales','total1'=>$sales1,'total2'=>$sales2),
array('mod'=>'purchase','total1'=>$purchase1,'total2'=>$purchase2)
);
$data['totalsize'] = 5;
die(json_encode($data));
}
public function pu_detail_new() {
$this->common_model->checkpurview(22);
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/pu-detail-new',$data);
}
public function puDetail_detail() {
$this->common_model->checkpurview(22);
$sum1 = $sum2 = $sum3 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="PUR"';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$where .= $this->common_model->get_location_purview();
$list = $this->data_model->get_invoice_info($where.' order by a.billDate,a.id');
foreach ($list as $arr=>$row) {
$v[$arr]['billId'] = intval($row['iid']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['buId'] = intval($row['buId']);
$v[$arr]['buName'] = $row['contactName'];
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['description'] = $row['description'];
$v[$arr]['baseQty'] = 0;
$v[$arr]['skuId'] = 0;
$v[$arr]['cost'] = 0;
$v[$arr]['unitCost'] = 0;
$v[$arr]['transType'] = $row['transTypeName'];
$sum1 += $v[$arr]['qty'] = (float)$row['qty'];
$sum2 += $v[$arr]['unitPrice'] = (float)$row['price'];
$sum3 += $v[$arr]['amount'] = (float)$row['amount'];
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['list'] = isset($v) ? $v :array();
$data['data']['total']['amount'] = '';
$data['data']['total']['baseQty'] = 'PUR';
$data['data']['total']['billId'] = '';
$data['data']['total']['billNo'] = '';
$data['data']['total']['billType'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['buNo'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['invName'] = '';
$data['data']['total']['location'] = '';
$data['data']['total']['locationNo'] = '';
$data['data']['total']['spec'] = '';
$data['data']['total']['unit'] = '';
$data['data']['total']['transType'] = '';
$data['data']['total']['skuId'] = '';
$data['data']['total']['qty'] = $sum1;
$data['data']['total']['unitPrice'] = $sum1>0 ? $sum3/$sum1 : 0;
$data['data']['total']['amount'] = $sum3;
$data['data']['total']['cost'] = '';
$data['data']['total']['unitCost'] = '';
die(json_encode($data));
}
public function puDetail_detailExporter() {
$this->common_model->checkpurview(23);
$name = 'pu_detail_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('采购明细表导出:'.$name);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="PUR"';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$where .= $this->common_model->get_location_purview();
$data['list'] = $this->data_model->get_invoice_info($where.' order by a.billDate,a.id');
$this->load->view('report/puDetail-detailExporter',$data);
}
public function pu_summary_new() {
$this->common_model->checkpurview(25);
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/pu-summary-new',$data);
}
public function puDetail_inv() {
$this->common_model->checkpurview(25);
$sum1 = $sum2 = $sum3 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="PUR"';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$list = $this->data_model->get_invoice_infosum($where.' group by a.invId, a.locationId');
foreach ($list as $arr=>$row) {
$v[$arr]['billId'] = intval($row['iid']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['buId'] = intval($row['buId']);
$v[$arr]['buName'] = $row['contactName'];
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['baseQty'] = 0;
$v[$arr]['skuId'] = 0;
$v[$arr]['cost'] = 0;
$v[$arr]['unitCost'] = 0;
$v[$arr]['transType'] = $row['transTypeName'];
$sum1 += $v[$arr]['qty'] = (float)$row['sumqty'];
$sum2 += $v[$arr]['unitPrice'] = (float)$row['sumqty']!=0 ? (float)abs($row['sumamount']/$row['sumqty']) : 0;
$sum3 += $v[$arr]['amount'] = (float)$row['sumamount'];
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['list'] = isset($v) ? $v :array();
$data['data']['total']['amount'] = '';
$data['data']['total']['baseQty'] = 'PUR';
$data['data']['total']['billId'] = '';
$data['data']['total']['billNo'] = '';
$data['data']['total']['billType'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['buNo'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['invName'] = '';
$data['data']['total']['location'] = '';
$data['data']['total']['locationNo'] = '';
$data['data']['total']['spec'] = '';
$data['data']['total']['unit'] = '';
$data['data']['total']['transType'] = '';
$data['data']['total']['skuId'] = '';
$data['data']['total']['qty'] = $sum1;
$data['data']['total']['unitPrice'] = $sum1!=0 ? abs($sum3/$sum1) : 0;
$data['data']['total']['amount'] = $sum3;
$data['data']['total']['cost'] = '';
$data['data']['total']['unitCost'] = '';
die(json_encode($data));
}
public function puDetail_invExporter() {
$this->common_model->checkpurview(26);
$name = 'pu_summary_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('采购明细表(按商品)导出:'.$name);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="PUR"';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$data['list'] = $this->data_model->get_invoice_infosum($where.' group by a.invId, a.locationId');
$this->load->view('report/puDetail-invExporter',$data);
}
public function pu_summary_supply_new() {
$this->common_model->checkpurview(28);
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/pu-summary-supply-new',$data);
}
public function puDetail_supply() {
$this->common_model->checkpurview(28);
$sum1 = $sum2 = $sum3 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="PUR"';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$list = $this->data_model->get_invoice_infosum($where.' group by a.buId,a.invId, a.locationId');
foreach ($list as $arr=>$row) {
$v[$arr]['billId'] = intval($row['iid']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['buId'] = intval($row['buId']);
$v[$arr]['buName'] = $row['contactName'];
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['baseQty'] = 0;
$v[$arr]['skuId'] = 0;
$v[$arr]['cost'] = 0;
$v[$arr]['unitCost'] = 0;
$v[$arr]['transType'] = $row['transTypeName'];
$sum1 += $v[$arr]['qty'] = (float)$row['sumqty'];
$sum2 += $v[$arr]['unitPrice'] = (float)$row['sumqty']!=0 ? (float)abs($row['sumamount']/$row['sumqty']) : 0;
$sum3 += $v[$arr]['amount'] = (float)$row['amount'];
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['list'] = isset($v) ? $v :array();
$data['data']['total']['amount'] = '';
$data['data']['total']['baseQty'] = 'PUR';
$data['data']['total']['billId'] = '';
$data['data']['total']['billNo'] = '';
$data['data']['total']['billType'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['buNo'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['invName'] = '';
$data['data']['total']['location'] = '';
$data['data']['total']['locationNo'] = '';
$data['data']['total']['spec'] = '';
$data['data']['total']['unit'] = '';
$data['data']['total']['transType'] = '';
$data['data']['total']['skuId'] = '';
$data['data']['total']['qty'] = $sum1;
$data['data']['total']['unitPrice'] = $sum1!=0 ? abs($sum3/$sum1) : 0;
$data['data']['total']['amount'] = $sum3;
$data['data']['total']['cost'] = '';
$data['data']['total']['unitCost'] = '';
die(json_encode($data));
}
public function puDetail_supplyExporter() {
$this->common_model->checkpurview(29);
$name = 'pu_supply_summary_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('采购明细表(按供应商)导出:'.$name);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="PUR"';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$data['list'] = $this->data_model->get_invoice_infosum($where.' group by a.buId,a.invId, a.locationId');
$this->load->view('report/puDetail-supplyExporter',$data);
}
public function sales_detail() {
$this->common_model->checkpurview(31);
$this->load->view('report/sales-detail');
}
public function salesDetail_detail() {
$this->common_model->checkpurview(31);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = $sum7 = 0;
$data['status'] = 200;
$data['msg'] = 'success';
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$profit = intval($this->input->get_post('profit',TRUE));
$salesId = str_enhtml($this->input->get_post('salesId',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId ? ' and e.number in('.str_quote($salesId).')' : ''; //a.salesId
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$where .= $this->common_model->get_location_purview();
$offset = $rows * ($page-1);
$data['data']['page'] = $page;
$data['data']['records'] = $this->data_model->get_invoice_info($where.' order by a.billDate,a.id',3);
$data['data']['total'] = ceil($data['data']['records']/$rows);
$list = $this->data_model->get_invoice_info($where.' order by a.billDate,a.id');
foreach ($list as $arr=>$row) {
$sum1 += $qty = $row['qty']>0 ? -abs($row['qty']) : abs($row['qty']); //销售在数据库中是负数 在统计的时候应该是正数
$sum3 += $amount = $row['amount']; //销售收入
$v[$arr]['billId'] = intval($row['iid']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['buId'] = intval($row['buId']);
$v[$arr]['buName'] = $row['contactName'];
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['description'] = $row['description'];
$v[$arr]['skuId'] = 0;
$v[$arr]['cost'] = ''; //销售成本
$v[$arr]['unitCost'] = ''; //单位成本
$v[$arr]['saleProfit'] = ''; //销售毛利
$v[$arr]['salepPofitRate']= ''; //销售毛利率
$v[$arr]['salesName'] = $row['salesName'];
$v[$arr]['transType'] = $row['transTypeName'];
$v[$arr]['unitPrice'] = round($row['price'],$this->systems['qtyPlaces']);
$v[$arr]['qty'] = round($qty,$this->systems['qtyPlaces']);
$v[$arr]['amount'] = round($row['amount'],2);
}
$data['data']['rows'] = isset($v) ? $v : array();
$data['data']['userdata']['billId'] = 0;
$data['data']['userdata']['billType'] = 'SALE';
$data['data']['userdata']['skuId'] = 0;
$data['data']['userdata']['qty'] = round($sum1,$this->systems['qtyPlaces']);
$data['data']['userdata']['unitPrice'] = $sum1>0 ? round($sum3/$sum1,$this->systems['qtyPlaces']) : 0;
$data['data']['userdata']['amount'] = round($sum3,2);
$data['data']['userdata']['cost'] = '';
$data['data']['userdata']['unitCost'] = '';
$data['data']['userdata']['saleProfit'] = '';
$data['data']['userdata']['salepPofitRate'] = '';
die(json_encode($data));
}
public function salesDetail_detailExporter() {
$this->common_model->checkpurview(32);
$name = 'sales_detail_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('销售明细表导出:'.$name);
$salesId = str_enhtml($this->input->get_post('salesId',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId ? ' and e.number in('.str_quote($salesId).')' : '';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$where .= $this->common_model->get_location_purview();
$data['list'] = $this->data_model->get_invoice_info($where.' order by a.id');
$this->load->view('report/salesDetail-detailExporter',$data);
}
public function sales_summary() {
$this->common_model->checkpurview(34);
$this->load->view('report/sales-summary');
}
public function sales_profit(){
$this->common_model->checkpurview(34);
$this->load->view('report/sales-profit');
}
public function salesDetail_inv() {
$this->common_model->checkpurview(34);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = $sum7 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$profit = intval($this->input->get_post('profit',TRUE));
$salesId = str_enhtml($this->input->get_post('salesId',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId ? ' and e.number in('.str_quote($salesId).')' : '';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$offset = $rows * ($page-1);
if ($profit==1) {
$info = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
}
$list = $this->data_model->get_invoice_infosum($where.' group by a.invId, a.locationId');
foreach ($list as $arr=>$row) {
$sum1 += $qty = $row['sumqty']>0 ? -abs($row['sumqty']):abs($row['sumqty']);
$sum3 += $amount = $row['sumamount'];
$unitPrice = $qty!=0 ? $amount/$qty : 0;
if ($profit==1) {
$sum4 += $unitcost = isset($info['inprice'][$row['invId']][$row['locationId']]) ? $info['inprice'][$row['invId']][$row['locationId']] : 0; //单位成本
$sum5 += $cost = $unitcost * $qty;
$sum6 += $saleProfit = $amount - $cost;
$sum7 += $salepPofitRate = $amount>0 ? ($saleProfit/$amount)*100 :0;
}
$v[$arr]['billId'] = intval($row['id']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['buId'] = intval($row['buId']);
$v[$arr]['buName'] = $row['contactName'];
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['locationNo'] = $row['locationNo'];
$v[$arr]['skuId'] = 0;
if ($profit==1) {
$v[$arr]['cost'] = round($cost,2);
$v[$arr]['unitCost'] = round($unitcost,2);
$v[$arr]['saleProfit'] = round($saleProfit,2);
$v[$arr]['salepPofitRate']= round($salepPofitRate,2).'%';
}
$v[$arr]['salesName'] = $row['salesName'];
$v[$arr]['transType'] = $row['transTypeName'];
$v[$arr]['qty'] = round($qty,$this->systems['qtyPlaces']);
$v[$arr]['amount'] = round($amount,2);
$v[$arr]['unitPrice'] = round($unitPrice,2);
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['page'] = $page;
$data['data']['records'] = $this->data_model->get_invoice_infosum($where.' group by a.invId, a.locationId',3);
$data['data']['total'] = ceil($data['data']['records']/$rows);
$data['data']['rows'] = isset($v) ? $v : array();
$data['data']['userdata']['billId'] = 0;
$data['data']['userdata']['billType'] = 'SALE';
$data['data']['userdata']['skuId'] = 0;
$data['data']['userdata']['qty'] = round($sum1,$this->systems['qtyPlaces']);
$data['data']['userdata']['unitPrice'] = $sum1>0 ? round($sum3/$sum1,2) : 0;
$data['data']['userdata']['amount'] = round($sum3,2);
if ($profit==1) {
$data['data']['userdata']['cost'] = round($sum5,2);
$data['data']['userdata']['unitCost'] = round($sum4,2);
$data['data']['userdata']['saleProfit'] = round($sum6,2);
$data['data']['userdata']['salepPofitRate'] = round($sum7,2).'%';
}
die(json_encode($data));
}
public function salesDetail_invExporter() {
$this->common_model->checkpurview(35);
$name = 'sales_inv_summary_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('导出销售汇总表(按商品):'.$name);
$data['profit'] = $profit = intval($this->input->get_post('profit',TRUE));
$salesId = str_enhtml($this->input->get_post('salesId',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId ? ' and e.number in('.str_quote($salesId).')' : '';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $data['beginDate'] ? ' and a.billDate>="'.$data['beginDate'].'"' : '';
$where .= $data['endDate'] ? ' and a.billDate<="'.$data['endDate'].'"' : '';
$where .= $this->common_model->get_location_purview();
if ($profit==1) {
$data['info'] = $this->data_model->get_profit('and billDate<="'.$data['endDate'].'"');
}
$data['list'] = $this->data_model->get_invoice_infosum($where.' group by invId, locationId');
$this->load->view('report/salesDetail_invExporter',$data);
}
public function salesProfit_inv() {
$this->common_model->checkpurview(34);
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$salesId = intval($this->input->get_post('salesId',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$salesNo = str_enhtml($this->input->get_post('salesNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId>0 ? ' and a.salesId='.$salesId : '';
$where .= $customerNo ? ' and b.number in('.str_quote($customerNo).')' : '';
$where .= $salesNo ? ' and c.number in('.str_quote($salesNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$list = $this->data_model->get_invoice($where.' order by a.id desc ');
$info = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = $sum7 = $sum8 = $sum9 = $sum10 = $sum11 = 0;
foreach ($list as $arr=>$row) {
$totalAmount = (float)$row['totalAmount'];
$amount = (float)$row['amount'];
$v[$arr]['salesNo'] = $row['salesNo'];
$v[$arr]['contactNo'] = $row['contactNo'];
$v[$arr]['billDate'] = $row['billDate'];//单据日期
$v[$arr]['salesName'] = $row['salesName'];//销售人员
$v[$arr]['contactName'] = $row['contactName'];//客户
$v[$arr]['billNo'] = $row['billNo'];//单据编号
$v[$arr]['transTypeName'] = $row['transTypeName'];//业务类型
$v[$arr]['totalQty'] = (float)$row['totalQty'];//数量
$v[$arr]['disAmount'] = (float)$row['disAmount'];//优惠金额
$v[$arr]['amount'] = (float)$row['amount'];//优惠后金额
$v[$arr]['totalAmount'] = (float)$row['totalAmount'];//销售收入
//$v[$arr]['totalCost'] = (float)$row['totalCost'];//销售成本
$v[$arr]['ysAmount'] = (float)$row['amount'];//应收金额
$v[$arr]['rpAmount'] = (float)$row['rpAmount'];//已收款金额
$v[$arr]['description'] = $row['description'];//整单备注
$details = $this->data_model->get_invoice_info(' a.iid ='.$row['id']);
$sum = 0;
foreach ($details as $key=>$detail) {
$qty = $detail['qty']>0 ? -abs($detail['qty']):abs($detail['qty']);
$unitcost = isset($info['inprice'][$detail['invId']][$detail['locationId']]) ? $info['inprice'][$detail['invId']][$detail['locationId']] : 0; //单位成本
$sum += $cost = $unitcost * $qty;
}
$v[$arr]['totalCost'] = round($sum,2);//销售成本
$v[$arr]['saleProfit'] = round($totalAmount - $sum,2);//销售毛利=销售收入-销售成本
$salepPofitRate = $totalAmount>0? ($v[$arr]['saleProfit']/$totalAmount)*100 :0;
$v[$arr]['salepPofitRate'] = round($salepPofitRate,2).'%';//毛利率
$v[$arr]['pureProfit'] = $v[$arr]['saleProfit'] - $v[$arr]['disAmount'];//销售净利润=销售毛利-优惠金额
$pureProfitRate = $amount>0? ($v[$arr]['pureProfit']/$amount)*100 :0;
$v[$arr]['pureProfitRate'] = round($pureProfitRate,2).'%';//净利润率
$sum1 += $v[$arr]['totalQty'];
$sum2 += $v[$arr]['disAmount'];
$sum3 += $v[$arr]['amount'];
$sum4 += $v[$arr]['totalAmount'];
$sum5 += $v[$arr]['ysAmount'];
$sum6 += $v[$arr]['rpAmount'];
$sum7 += $v[$arr]['totalCost'];
$sum8 += $v[$arr]['saleProfit'];
$sum9 += $salepPofitRate;
$sum10 += $v[$arr]['pureProfit'];
$sum11 += $pureProfitRate;
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['page'] = $page;
$data['data']['records'] = $this->data_model->get_invoice($where.' order by a.id desc ',3);
$data['data']['total'] = ceil($data['data']['records']/$rows);
$data['data']['rows'] = isset($v) ? $v : array();
$data['data']['userdata']['billId'] = 0;
$data['data']['userdata']['billType'] = 'SALE';
$data['data']['userdata']['skuId'] = 0;
$data['data']['userdata']['qty'] = round($sum1,$this->systems['qtyPlaces']);
$data['data']['userdata']['unitPrice'] = $sum1>0 ? round($sum3/$sum1,2) : 0;
$data['data']['userdata']['totalQty'] = round($sum1,2);
$data['data']['userdata']['disAmount'] = round($sum2,2);
$data['data']['userdata']['amount'] = round($sum3,2);
$data['data']['userdata']['totalAmount'] = round($sum4,2);
$data['data']['userdata']['ysAmount'] = round($sum5,2);
$data['data']['userdata']['rpAmount'] = round($sum6,2);
$data['data']['userdata']['totalCost'] = round($sum7,2);
$data['data']['userdata']['saleProfit'] = round($sum8,2);
$data['data']['userdata']['salepPofitRate'] = round($sum9,2).'%';
$data['data']['userdata']['pureProfit'] = round($sum10,2);
$data['data']['userdata']['pureProfitRate'] = round($sum11,2).'%';
die(json_encode($data));
}
public function salesProfit_invExporter() {
$this->common_model->checkpurview(35);
$name = '销售利润表_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('导出销售利润表:'.$name);
$salesId = intval($this->input->get_post('salesId',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$salesNo = str_enhtml($this->input->get_post('salesNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId>0 ? ' and a.salesId='.$salesId : '';
$where .= $customerNo ? ' and b.number in('.str_quote($customerNo).')' : '';
$where .= $salesNo ? ' and c.number in('.str_quote($salesNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$data['list'] = $this->data_model->get_invoice($where.' order by a.id desc ');
$data['info'] = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
$this->load->view('report/salesProfit_invExporter',$data);
}
public function sales_summary_customer_new() {
$this->common_model->checkpurview(37);
$this->load->view('report/sales-summary-customer-new');
}
public function salesDetail_customer() {
$this->common_model->checkpurview(37);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = $sum7 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$profit = intval($this->input->get_post('profit',TRUE));
$salesId = str_enhtml($this->input->get_post('salesId',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId ? ' and e.number in('.str_quote($salesId).')' : '';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
if ($profit==1) {
$info = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
}
$list = $this->data_model->get_invoice_infosum($where.' group by buId,invId,locationId');
foreach ($list as $arr=>$row) {
$sum1 += $qty = $row['sumqty']>0 ? -abs($row['sumqty']):abs($row['sumqty']);
$sum3 += $amount = $row['sumamount'];
$unitPrice = $qty!=0 ? $amount/$qty : 0;
if ($profit==1) {
$sum4 += $unitcost = isset($info['inprice'][$row['invId']][$row['locationId']]) ? $info['inprice'][$row['invId']][$row['locationId']] : 0; //单位成本
$sum5 += $cost = $unitcost * $qty;
$sum6 += $saleProfit = $amount - $cost;
$sum7 += $salepPofitRate = $amount>0 ? ($saleProfit/$amount)*100 :0;
}
$v[$arr]['billId'] = intval($row['iid']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['buId'] = intval($row['buId']);
$v[$arr]['buName'] = $row['contactName'];
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['locationNo'] = $row['locationNo'];
$v[$arr]['baseQty'] = 0;
$v[$arr]['skuId'] = 0;
if ($profit==1) {
$v[$arr]['cost'] = round($cost,2);
$v[$arr]['unitCost'] = round($unitcost,2);
$v[$arr]['saleProfit'] = round($saleProfit,2);
$v[$arr]['salepPofitRate']= round($salepPofitRate,2);
}
$v[$arr]['salesName'] = $row['salesName'];
$v[$arr]['transType'] = $row['transTypeName'];
$v[$arr]['qty'] = round($qty,$this->systems['qtyPlaces']);
$v[$arr]['amount'] = round($amount,2);
$v[$arr]['unitPrice'] = round($unitPrice,2);
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['list'] = isset($v) ? $v : array();
$data['data']['total']['amount'] = '';
$data['data']['total']['baseQty'] = 'SALE';
$data['data']['total']['billId'] = '';
$data['data']['total']['billNo'] = '';
$data['data']['total']['billType'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['buNo'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['invName'] = '';
$data['data']['total']['location'] = '';
$data['data']['total']['locationNo'] = '';
$data['data']['total']['spec'] = '';
$data['data']['total']['unit'] = '';
$data['data']['total']['transType'] = '';
$data['data']['total']['skuId'] = '';
$data['data']['total']['qty'] = round($sum1,$this->systems['qtyPlaces']);
$data['data']['total']['unitPrice'] = $sum1>0 ? $sum3/$sum1 : 0;
$data['data']['total']['amount'] = round($sum3,2);
if ($profit==1) {
$data['data']['total']['cost'] = round($sum5,2);
$data['data']['total']['unitCost'] = round($sum4,2);
$data['data']['total']['saleProfit'] = round($sum6,2);
$data['data']['total']['salepPofitRate'] = round($sum7,2);
}
die(json_encode($data));
}
public function salesDetail_customerExporter() {
$this->common_model->checkpurview(38);
$name = 'sales_customer_summary_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('导出销售汇总表(按客户):'.$name);
$data['profit'] = $profit = intval($this->input->get_post('profit',TRUE));
$salesId = str_enhtml($this->input->get_post('salesId',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$customerNo = str_enhtml($this->input->get_post('customerNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and a.billType="SALE"';
$where .= $salesId ? ' and e.number in('.str_quote($salesId).')' : '';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $customerNo ? ' and c.number in('.str_quote($customerNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $data['beginDate'] ? ' and a.billDate>="'.$data['beginDate'].'"' : '';
$where .= $data['endDate'] ? ' and a.billDate<="'.$data['endDate'].'"' : '';
$where .= $this->common_model->get_location_purview();
if ($profit==1) {
$data['info'] = $this->data_model->get_profit('and billDate<="'.$data['endDate'].'"');
}
$data['list'] = $this->data_model->get_invoice_infosum($where.' group by buId,invId,locationId');
$this->load->view('report/salesDetail-customerExporter',$data);
}
public function contact_debt_new() {
$this->common_model->checkpurview(49);
$this->load->view('report/contact-debt-new');
}
public function contactDebt_detail() {
$this->common_model->checkpurview(49);
$v = array();
$sum1 = $sum2 = 0;
$data['status'] = 200;
$data['msg'] = 'success';
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$matchCon = str_enhtml($this->input->get_post('matchCon',TRUE));
$supplier = str_enhtml($this->input->get_post('supplier',TRUE));
$customer = str_enhtml($this->input->get_post('customer',TRUE));
$where = 'a.isDelete=0';
if ($supplier && $customer) {
} else {
$where .= $supplier ? ' and type=10' : '';
$where .= $customer ? ' and type=-10' : '';
}
$where .= $matchCon ? ' and (name like "%'.$matchCon.'%" or number like "%'.$matchCon.'%")' : '';
$where .= $this->common_model->get_contact_purview();
$list = $this->data_model->get_contact('',$where. ' order by type desc');
foreach ($list as $arr=>$row) {
$v[$arr]['dbid'] = 0;
$v[$arr]['debt'] = 0;
$v[$arr]['displayName'] = $row['type']==10 ? '供应商' : '客户';
$v[$arr]['buId'] = intval($row['id']);
$v[$arr]['name'] = $row['name'];
$v[$arr]['number'] = $row['number'];
$sum1 += $v[$arr]['payable'] = $row['type']==10 ? $row['amount'] : 0;
$sum2 += $v[$arr]['receivable'] = $row['type']==-10 ? $row['amount'] : 0;
$v[$arr]['type'] = $row['type'];
}
$data['data']['list'] = $v;
$data['data']['total']['buid'] = 0;
$data['data']['total']['dbid'] = 0;
$data['data']['total']['debt'] = '';
$data['data']['total']['displayName'] = '';
$data['data']['total']['name'] = '';
$data['data']['total']['number'] = '';
$data['data']['total']['payable'] = $sum1;
$data['data']['total']['receivable'] = $sum2;
$data['data']['total']['type'] = '';
die(json_encode($data));
}
public function contactDebt_exporter() {
$this->common_model->checkpurview(50);
$name = 'contact_debt_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('导出往来单位欠款表:'.$name);
$matchCon = str_enhtml($this->input->get_post('matchCon',TRUE));
$supplier = str_enhtml($this->input->get_post('supplier',TRUE));
$customer = str_enhtml($this->input->get_post('customer',TRUE));
$where = 'a.isDelete=0';
if ($supplier && $customer) {
} else {
$where .= $supplier ? ' and type=10' : '';
$where .= $customer ? ' and type=-10' : '';
}
$where .= $matchCon ? ' and (name like "%'.$matchCon.'%" or number like "%'.$matchCon.'%")' : '';
$where .= $this->common_model->get_contact_purview();
$data['list'] = $this->data_model->get_contact('',$where. ' order by type desc');
$this->load->view('report/contactDebt-exporter',$data);
}
public function goods_balance() {
$this->common_model->checkpurview(40);
$this->load->view('report/goods-balance');
}
public function invBalance() {
$this->common_model->checkpurview(40);
$i = 2;
$select = '';
$qty_1 = $cost_1 = $cost1 = 0;
$stoNames = array();
$colNames = array();
$colIndex = array();
$catId = intval($this->input->get_post('catId',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0';
if ($catId > 0) {
$catId = array_column($this->mysql_model->get_results('category','(1=1) and find_in_set('.$catId.',path)'),'id');
if (count($catId)>0) {
$catId = join(',',$catId);
$where .= ' and b.categoryid in('.$catId.')';
}
}
$where .= $goodsNo ? ' and b.number="'.$goodsNo.'"' : '';
$where .= $storageNo ? ' and c.locationNo in('.str_quote($storageNo).')' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$where1 = $storageNo ? ' and locationNo in('.str_quote($storageNo).')' : '';
$where1 .= $this->common_model->get_location_purview(1);
$storage = $this->mysql_model->get_results('storage','(isDelete=0) '.$where1);
foreach($storage as $arr=>$row) {
$qty['qty'.$i] = $qty['cost'.$i] = 0;
$stoNames[] = $row['name'];
$colNames[] = '数量';
$colNames[] = '成本';
$colIndex[] = 'qty_'.$i;
$colIndex[] = 'cost_'.$i;
$select .= 'sum(case when a.locationId='.$row['id'].' then qty else 0 end ) as qty'.$i.',';
$i++;
}
array_unshift($stoNames,'所有仓库');
array_unshift($colNames,'商品编号','商品名称','规格型号','单位','数量','成本');
array_unshift($colIndex,'invNo','invName','spec','unit','qty_1','cost_1');
$profit = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
$list = $this->data_model->get_invBalance($where.' group by a.invId',$select);
foreach ($list as $arr=>$row) {
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$i = 2;
$cost1 = 0;//add my michen 20170818 for bug
foreach($storage as $arr1=>$row1) {
$price = isset($profit['inprice'][$row['invId']][$row1['id']]) ? $profit['inprice'][$row['invId']][$row1['id']] : 0; //单位成本
$v[$arr]['qty_'.$i] = round($row['qty'.$i],$this->systems['qtyPlaces']);
$v[$arr]['cost_'.$i] = round($row['qty'.$i] * $price,2);
$qty['qty'.$i] += $row['qty'.$i];
$qty['cost'.$i] += $row['qty'.$i] * $price;
$cost1 += $row['qty'.$i] * $price;
$i++;
}
$v[$arr]['qty_1'] = round($row['qty'],$this->systems['qtyPlaces']);
$v[$arr]['cost_1'] = round($cost1,2);
$qty_1 += $row['qty'];
$cost_1 += $cost1;
}
$json['status'] = 200;
$json['msg'] = 'success';
$json['data']['stoNames'] = $stoNames;
$json['data']['colNames'] = $colNames;
$json['data']['colIndex'] = $colIndex;
$json['data']['total'] = 1;
$json['data']['page'] = 1;
$json['data']['records'] = 200;
$json['data']['rows'] = isset($v) ? $v : array();
$json['data']['userdata']['invNo'] = '';
$json['data']['userdata']['invName'] = '';
$json['data']['userdata']['spec'] = '';
$json['data']['userdata']['unit'] = '';
$json['data']['userdata']['qty_1'] = round($qty_1,$this->systems['qtyPlaces']);
$json['data']['userdata']['cost_1'] = round($cost_1,2);
$i = 2;
foreach($storage as $arr1=>$row1) {
$json['data']['userdata']['qty_'.$i] = round($qty['qty'.$i],$this->systems['qtyPlaces']);
$json['data']['userdata']['cost_'.$i] = round($qty['cost'.$i],2);
$i++;
}
die(json_encode($json));
}
public function invBalance_exporter() {
$this->common_model->checkpurview(41);
sys_csv('inv_balance_'.date('YmdHis').'.xls');
$i = 2;
$select = '';
$catId = intval($this->input->get_post('catId',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0';
if ($catId > 0) {
$catId = array_column($this->mysql_model->get_results('category','(1=1) and find_in_set('.$catId.',path)'),'id');
if (count($catId)>0) {
$catId = join(',',$catId);
$where .= ' and b.categoryid in('.$catId.')';
}
}
$where .= $goodsNo ? ' and b.number="'.$goodsNo.'"' : '';
$where .= $storageNo ? ' and c.locationNo in('.str_quote($storageNo).')' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$where1 = $storageNo ? ' and locationNo in('.str_quote($storageNo).')' : '';
$where1 .= $this->common_model->get_location_purview(1);
$data['storage'] = $storage = $this->mysql_model->get_results('storage','(isDelete=0) '.$where1);
foreach($storage as $arr=>$row) {
$select .= 'sum(case when a.locationId='.$row['id'].' then qty else 0 end ) as qty'.$i.',';
$i++;
}
$data['profit'] = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
$data['list'] = $this->data_model->get_invBalance($where.' group by a.invId',$select);
$this->load->view('report/invBalance_exporter',$data);
}
public function goods_flow_detail() {
$this->common_model->checkpurview(43);
$this->load->view('report/goods-flow-detail');
}
public function deliverDetail() {
$this->common_model->checkpurview(43);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = 0;
$where = '';
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = 'a.isDelete=0';
$where1 .= $goodsNo ? ' and a.number in('.str_quote($goodsNo).')' : '';
$where2 = 'a.isDelete=0 and a.transType>0';
$where2 .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where2 .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where2 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where2 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where2 .= $this->common_model->get_location_purview();
$list1 = $this->data_model->get_goods_beginning($where1.' order by a.id',$beginDate);
$list2 = $this->data_model->get_invoice_info($where2.' order by a.billDate,a.id');
foreach ($list1 as $arr=>$row) {
$v[$arr]['date'] = '';
$v[$arr]['billNo'] = '';
$v[$arr]['billId'] = '';
$v[$arr]['billType'] = '';
$v[$arr]['buName'] = '';
$v[$arr]['transType'] = '期初数量';
$v[$arr]['transTypeId'] = '';
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = '';
$v[$arr]['unit'] = '';
$v[$arr]['entryId'] = '';
$v[$arr]['location'] = '';
$v[$arr]['locationNo'] = '';
$v[$arr]['inout'] = 0;
$v[$arr]['qty'] = '';
$v[$arr]['baseQty'] = '';
$v[$arr]['inqty'] = '';
$v[$arr]['outqty'] = '';
$v[$arr]['totalqty'] = round($row['qty'],$this->systems['qtyPlaces']);
foreach ($list2 as $arr1=>$row1) {
$arr = time() + $arr1;
if ($row['id']==$row1['invId']) {
$inqty = $row1['qty']>0 ? abs($row1['qty']) : '';
$outqty = $row1['qty']<0 ? abs($row1['qty']) : '';
$sum1 += $inqty;
$sum2 += $outqty;
$totalqtys = $row['qty'] + $sum1 - $sum2;
$v[$arr]['date'] = $row1['billDate'];
$v[$arr]['billNo'] = $row1['billNo'];
$v[$arr]['billId'] = $row1['iid'];
$v[$arr]['billType'] = $row1['billType'];
$v[$arr]['buName'] = $row1['contactName'];
$v[$arr]['transType'] = $row1['transTypeName'];
$v[$arr]['transTypeId'] = $row1['transType'];
$v[$arr]['invNo'] = $row1['invNumber'];
$v[$arr]['invName'] = $row1['invName'];
$v[$arr]['spec'] = $row1['invSpec'];
$v[$arr]['unit'] = $row1['mainUnit'];
$v[$arr]['entryId'] = '';
$v[$arr]['location'] = $row1['locationName'];
$v[$arr]['locationNo'] = $row1['locationNo'];
$v[$arr]['inout'] = 0;
$v[$arr]['qty'] = 0;
$v[$arr]['baseQty'] = 0;
$v[$arr]['unitCost'] = 0;
$v[$arr]['cost'] = 0;
$v[$arr]['inqty'] = round($inqty,$this->systems['qtyPlaces']);
$v[$arr]['outqty'] = round($outqty,$this->systems['qtyPlaces']);
$v[$arr]['totalqty'] = round($totalqtys,$this->systems['qtyPlaces']);
}
}
$sum3 += $sum1;
$sum4 += $sum2;
$sum5 += $totalqtys;
$totalqtys = $sum1 = $sum2 = 0;
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['page'] = $page;
$data['data']['records'] = 1;
$data['data']['total'] = ceil($data['data']['records']/$rows);
$data['data']['rows'] = isset($v) ? array_values($v) : array();
$data['data']['userdata']['date'] = '';
$data['data']['userdata']['billNo'] = '';
$data['data']['userdata']['billId'] = '';
$data['data']['userdata']['billType'] = '';
$data['data']['userdata']['buName'] = '';
$data['data']['userdata']['type'] = '';
$data['data']['userdata']['transTypeId']= '';
$data['data']['userdata']['invNo'] = '';
$data['data']['userdata']['invName'] = '';
$data['data']['userdata']['spec'] = '';
$data['data']['userdata']['unit'] = '';
$data['data']['userdata']['location'] = '';
$data['data']['userdata']['locationNo'] = '';
$data['data']['userdata']['inout'] = '';
$data['data']['userdata']['qty'] = 0;
$data['data']['userdata']['baseQty'] = '';
$data['data']['userdata']['unitCost'] = '';
$data['data']['userdata']['cost'] = '';
$data['data']['userdata']['cost_5'] = '';
$data['data']['userdata']['inqty'] = round($sum3,$this->systems['qtyPlaces']);
$data['data']['userdata']['outqty'] = round($sum4,$this->systems['qtyPlaces']);
$data['data']['userdata']['totalqty'] = round($sum5,$this->systems['qtyPlaces']);
die(json_encode($data));
}
public function deliverDetail_exporter() {
$this->common_model->checkpurview(44);
$name = 'deliver_Detail_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('商品收发明细表导出:'.$name);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = 'a.isDelete=0';
$where1 .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where2 = 'a.isDelete=0 and a.transType>0';
$where2 .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where2 .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where2 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where2 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where2 .= $this->common_model->get_location_purview();
$data['list1'] = $this->data_model->get_goods_beginning($where1.' order by a.id',$beginDate);
$data['list2'] = $this->data_model->get_invoice_info($where2.' order by a.billDate,a.id');
$this->load->view('report/deliverDetail-exporter',$data);
}
public function goods_flow_summary() {
$this->common_model->checkpurview(46);
$this->load->view('report/goods-flow-summary');
}
public function deliverSummary() {
$this->common_model->checkpurview(46);
for ($i=0;$i<15;$i++) {
$sum['qty'.$i] = 0;
$sum['cost'.$i] = 0;
}
$qty7 = $qty_7 = $qty13 = $qty_13 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$profit1 = $this->data_model->get_profit('and billDate<"'.$beginDate.'"');
$profit2 = $this->data_model->get_profit('and billDate<="'.$endDate.'"');
$list = $this->data_model->get_deliverSummary($where.' group by a.invId,a.locationId',$beginDate,$endDate);
foreach ($list as $arr=>$row) {
$price1 = isset($profit1['inprice'][$row['invId']][$row['locationId']]) ? $profit1['inprice'][$row['invId']][$row['locationId']] : 0;
$price2 = isset($profit2['inprice'][$row['invId']][$row['locationId']]) ? $profit2['inprice'][$row['invId']][$row['locationId']] : 0;
$qty_0 = $row['qty0'];
$qty_14 = $row['qty14'];
for ($i=1;$i<7;$i++) {
if ($i==1) {
$qty_7 += abs($row['qty1']);
} else {
$qty_7 += abs($row['qty'.$i]);
}
}
for ($i=8;$i<13;$i++) {
if ($i==10 || $i==11 || $i==12 || $i==8) {
$qty_13 += abs($row['qty'.$i]);
} else {
$qty_13 += abs($row['qty'.$i]);
}
}
$v[$arr]['invNo'] = $row['invNumber'];
$v[$arr]['invName'] = $row['invName'];
$v[$arr]['spec'] = $row['invSpec'];
$v[$arr]['unit'] = $row['mainUnit'];
$v[$arr]['location'] = $row['locationName'];
$v[$arr]['locationNo'] = $row['locationNo'];
for ($i=0; $i<15; $i++) {
if ($i==0) {
$v[$arr]['qty_0'] = round($qty_0,$this->systems['qtyPlaces']);
$v[$arr]['cost_0'] = round($qty_0 * $price1,2);
$sum['qty0'] += $qty_0;
$sum['cost0'] += $qty_0 * $price1;
} elseif($i==7) {
$v[$arr]['qty_7'] = round($qty_7,$this->systems['qtyPlaces']);
$sum['qty7'] += $qty_7;
} elseif($i==13) {
$v[$arr]['qty_13'] = round($qty_13,$this->systems['qtyPlaces']);
$sum['qty13'] += $qty_13;
} elseif($i==14) {
$v[$arr]['qty_14'] = round($qty_14,$this->systems['qtyPlaces']);
$v[$arr]['cost_14'] = round($qty_14 * $price2,2);
$sum['qty14'] += $qty_14;
$sum['cost14'] += $qty_14 * $price2;
} else {
if ($i==10 || $i==11 || $i==12 || $i==1 || $i==8) {
$v[$arr]['qty_'.$i] = round(abs($row['qty'.$i]),$this->systems['qtyPlaces']);
$sum['qty'.$i] += abs($row['qty'.$i]);
$sum['cost'.$i] += abs($row['qty'.$i]) * $price2;
} else {
$v[$arr]['qty_'.$i] = round(abs($row['qty'.$i]),$this->systems['qtyPlaces']);
$sum['qty'.$i] += abs($row['qty'.$i]);
$sum['cost'.$i] += abs($row['qty'.$i]) * $price2;
}
}
}
$qty_7 = $cost_7 = $qty_13 = $cost_13 = 0;
}
$json['status'] = 200;
$json['msg'] = 'success';
$json['data']['stoNames'] = array("期初","调拨入库","普通采购","销售退回","盘盈","其他入库","成本调整","入库合计","调拨出库","采购退回","普通销售","盘亏","其他出库","出库合计","结存");
$json['data']['colNames'] = array("商品编号","商品名称","规格型号","单位","仓库","数量","成本","数量","数量","数量","数量","数量","数量","数量","数量","数量","数量","数量","数量","数量","数量","成本");
$json['data']['colIndex'] = array("invNo","invName","spec","unit","locationNo","qty_0","cost_0","qty_1","qty_2","qty_3","qty_4","qty_5","qty_6","qty_7","qty_8","qty_9","qty_10","qty_11","qty_12","qty_13","qty_14","cost_14");
$json['data']['page'] = $page;
$json['data']['records'] = 1;
$json['data']['total'] = ceil($json['data']['records']/$rows);
$json['data']['rows'] = isset($v) ? $v : array();
$json['data']['userdata']['invNo'] = '';
$json['data']['userdata']['invName'] = '';
$json['data']['userdata']['spec'] = '';
$json['data']['userdata']['unit'] = '';
$json['data']['userdata']['location'] = '';
$json['data']['userdata']['locationNo'] = '';
for ($i=0;$i<15;$i++) {
$json['data']['userdata']['qty_'.$i] = round($sum['qty'.$i],$this->systems['qtyPlaces']);
$json['data']['userdata']['cost_'.$i] = round($sum['cost'.$i],2);
}
die(json_encode($json));
}
public function deliverSummary_exporter() {
$this->common_model->checkpurview(47);
$name = 'deliver_summary_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('商品收发汇总表导出:'.$name);
$storageNo = str_enhtml($this->input->get_post('storageNo',TRUE));
$goodsNo = str_enhtml($this->input->get_post('goodsNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0';
$where .= $storageNo ? ' and d.locationNo in('.str_quote($storageNo).')' : '';
$where .= $goodsNo ? ' and b.number in('.str_quote($goodsNo).')' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_location_purview();
$data['list'] = $this->data_model->get_deliverSummary($where.' group by a.invId,a.locationId',$beginDate,$endDate);
$this->load->view('report/deliverSummary-exporter',$data);
}
public function cash_bank_journal_new() {
$this->common_model->checkpurview(106);
$data['accountNo'] = $accountNo = intval($this->input->get_post('accountNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/cash-bank-journal-new', $data);
}
public function bankBalance_detail() {
$this->common_model->checkpurview(106);
$v = array();
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$accountNo = str_enhtml($this->input->get_post('accountNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = 'a.isDelete=0';
$where1 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where1 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where1 .= $accountNo ? ' and d.number in('.str_quote($accountNo).')' : '';
$where1 .= $this->common_model->get_admin_purview();
$where2 = 'a.isDelete=0';
$where2 .= $accountNo ? ' and a.number in('.str_quote($accountNo).')' : '';
$list1 = $this->data_model->get_account('and billDate<"'.$beginDate.'"',$where2.' order by a.id');
$list2 = $this->data_model->get_account_info($where1.' order by a.billDate');
foreach ($list1 as $arr=>$row) {
$v[$arr]['accountName'] = $row['accountName'];
$v[$arr]['accountNumber'] = $row['accountNumber'];
$v[$arr]['billType'] = '期初余额';
$v[$arr]['date'] = '';
$v[$arr]['buId'] = intval($row['id']);
$v[$arr]['buName'] = '';
$v[$arr]['billTypeNo'] = '';
$v[$arr]['balance'] = $row['amount'];
$v[$arr]['billId'] = 0;
$v[$arr]['billNo'] = '';
$v[$arr]['expenditure'] = 0;
$v[$arr]['income'] = 0;
$v[$arr]['type'] = 0;
foreach ($list2 as $arr1=>$row1) {
$arr = time() + $arr1;
if ($row['id']==$row1['accId']) {
$sum1 += $a1 = $row1['payment']>0 ? abs($row1['payment']) : 0;
$sum2 += $a2 = $row1['payment']<0 ? abs($row1['payment']) : 0;
$a3 = $row['amount'] + $sum1 - $sum2;
$v[$arr]['accountName'] = $row1['accountName'];
$v[$arr]['accountNumber'] = $row1['accountNumber'];
$v[$arr]['billType'] = $row1['transTypeName'];
$v[$arr]['date'] = $row1['billDate'];
$v[$arr]['buId'] = intval($row1['buId']);
$v[$arr]['buName'] = $row1['contactName'];
$v[$arr]['billTypeNo'] = '';
$v[$arr]['balance'] = $a3;
$v[$arr]['billId'] = 0;
$v[$arr]['billNo'] = $row1['billNo']; ;
$v[$arr]['expenditure'] = $a2;
$v[$arr]['income'] = $a1;
$v[$arr]['type'] = 0;
}
}
$sum3 += $sum1;
$sum4 += $sum2;
$sum5 += $row['amount'] + $sum1 - $sum2;
$sum1 = $sum2 = 0;
}
$json['status'] = 200;
$json['msg'] = 'success';
$json['data']['list'] = array_values($v);
$json['data']['total']['accountName'] = '';
$json['data']['total']['accountNumber'] = '';
$json['data']['total']['balance'] = $sum5;
$json['data']['total']['billNo'] = '';
$json['data']['total']['billTypeNo'] = '';
$json['data']['total']['billId'] = '';
$json['data']['total']['billType'] = '';
$json['data']['total']['buName'] = '';
$json['data']['total']['buNo'] = '';
$json['data']['total']['date'] = '';
$json['data']['total']['expenditure'] = $sum4;
$json['data']['total']['income'] = $sum3;
$json['data']['total']['type'] = '';
$json['data']['params']['startTime'] = '';
$json['data']['params']['numberFilter'] = '';
$json['data']['params']['keyword'] = '';
$json['data']['params']['dbid'] = '';
$json['data']['params']['endDate'] = $endDate;
$json['data']['params']['beginDate'] = $beginDate;
die(json_encode($json));
}
public function bankBalance_exporter() {
$this->common_model->checkpurview(107);
$name = 'BankBalanc_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('现金银行报表导出:'.$name);
$data['accountNo'] = $accountNo = str_enhtml($this->input->get_post('accountNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = 'a.isDelete=0';
$where1 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where1 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where1 .= $accountNo ? ' and d.number in('.str_quote($accountNo).')' : '';
$where1 .= $this->common_model->get_admin_purview();
$where2 = 'a.isDelete=0';
$where2 .= $accountNo ? ' and a.number in('.str_quote($accountNo).')' : '';
$data['list1'] = $this->data_model->get_account('and billDate<"'.$beginDate.'"',$where2.' order by a.id');
$data['list2'] = $this->data_model->get_account_info($where1.' order by a.accId desc');
$this->load->view('report/bankBalance-exporter', $data);
}
public function account_pay_detail_new() {
$this->common_model->checkpurview(52);
$data['accountNo'] = $accountNo = intval($this->input->get_post('accountNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/account-pay-detail-new', $data);
}
public function fundBalance_detailSupplier() {
$this->common_model->checkpurview(52);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$type = intval($this->input->get_post('type',TRUE));
$accountNo = str_enhtml($this->input->get_post('accountNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = ' and (billType="PUR" or billType="PAYMENT")';
$where2 = 'a.isDelete=0 and a.type=10';
$where2 .= $accountNo ? ' and a.number="'.$accountNo.'"' : '';
$list1 = $this->data_model->get_contact('and billDate<"'.$beginDate.'" '.$where1 ,$where2.' order by a.id');
$where3 = 'a.isDelete=0 and (a.billType="PUR" or a.billType="PAYMENT")';
$where3 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where3 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where3 .= ' and (a.billType="PUR" or a.billType="PAYMENT")';
$where3 .= $this->common_model->get_admin_purview();
$list2 = $this->data_model->get_invoice($where3.' order by a.billDate');
foreach ($list1 as $arr=>$row) {
$v[$arr]['balance'] = $row['amount'];
$v[$arr]['billId'] = 0;
$v[$arr]['billNo'] = '期初余额';
$v[$arr]['billType'] = 0;
$v[$arr]['date'] = '';
$v[$arr]['billTypeNo'] = 0;
$v[$arr]['buId'] = 0;
$v[$arr]['buName'] = $row['name'];
$v[$arr]['number'] = $row['number'];
$v[$arr]['transType'] = '';
$v[$arr]['type'] = '';
$v[$arr]['expenditure'] = '';
$v[$arr]['income'] = '';
foreach ($list2 as $arr1=>$row1) {
$arr = time() + $arr1;
if ($row['id']==$row1['buId']) {
$sum1 += $a1 = $row1['billType']=='PUR' ? $row1['arrears'] : 0;
$sum2 += $a2 = $row1['billType']=='PAYMENT' ? abs($row1['arrears']) : 0;
$a3 = $row['amount'] + $sum1 - $sum2;
$v[$arr]['balance'] = $a3;
$v[$arr]['billId'] = $row1['id'];
$v[$arr]['billNo'] = $row1['billNo'];
$v[$arr]['date'] = $row1['billDate'];
$v[$arr]['billTypeNo'] = $row1['billType'];
$v[$arr]['buId'] = $row1['buId'];
$v[$arr]['buName'] = $row1['contactName'];
$v[$arr]['number'] = $row1['contactNo'];
$v[$arr]['transType'] = $row1['transTypeName'];
$v[$arr]['type'] = -1;
$v[$arr]['expenditure'] = $a2;
$v[$arr]['income'] = $a1;
}
}
$sum3 = $row['amount'] + $sum1 - $sum2;
$arr = $arr + $row['id'];
$v[$arr]['balance'] = $sum3;
$v[$arr]['billId'] = 0;
$v[$arr]['billNo'] = '小计';
$v[$arr]['date'] = '';
$v[$arr]['billTypeNo'] = 0;
$v[$arr]['buId'] = 0;
$v[$arr]['buName'] = '';
$v[$arr]['number'] = '';
$v[$arr]['transType'] = '';
$v[$arr]['type'] = -1;
$v[$arr]['income'] = $sum1;
$v[$arr]['expenditure'] = $sum2;
$sum4 += $sum1;
$sum5 += $sum2;
$sum6 += $sum3;
}
$json['status'] = 200;
$json['msg'] = 'success';
$json['data']['total']['balance'] = $sum6;
$json['data']['total']['billId'] = '';
$json['data']['total']['billNo'] = '';
$json['data']['total']['billTypeNo'] = '';
$json['data']['total']['buId'] = '';
$json['data']['total']['buName'] = '';
$json['data']['total']['date'] = '';
$json['data']['total']['income'] = $sum4;
$json['data']['total']['expenditure'] = $sum5;
$json['data']['total']['number'] = '';
$json['data']['total']['transType'] = '';
$json['data']['total']['type'] = '';
$json['data']['list'] = isset($v) ? array_values($v) :'';
$json['data']['params']['startTime'] = '';
$json['data']['params']['numberFilter'] = '';
$json['data']['params']['categoryId'] = '';
$json['data']['params']['keyword'] = '';
$json['data']['params']['dbid'] = '';
$json['data']['params']['table'] = '';
$json['data']['params']['serviceType'] = '';
$json['data']['params']['customer'] = '';
$json['data']['params']['type'] = '';
$json['data']['params']['supplier'] = '';
$json['data']['params']['endDate'] = $endDate;
$json['data']['params']['beginDate'] = $beginDate;
die(json_encode($json));
}
public function fundBalance_exporterSupplier() {
$this->common_model->checkpurview(53);
$name = 'pay_balance_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('应付账款明细表导出:'.$name);
$accountNo = str_enhtml($this->input->get_post('accountNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = ' and (billType="PUR" or billType="PAYMENT")';
$where2 = 'a.isDelete=0 and a.type=10';
$where2 .= $accountNo ? ' and a.number="'.$accountNo.'"' : '';
$data['list1'] = $this->data_model->get_contact('and billDate<"'.$beginDate.'" '.$where1 ,$where2.' order by a.id');
$where3 = 'a.isDelete=0 and (a.billType="PUR" or a.billType="PAYMENT")';
$where3 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where3 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where3 .= ' and (a.billType="PUR" or a.billType="PAYMENT")';
$where3 .= $this->common_model->get_admin_purview();
$data['list2'] = $this->data_model->get_invoice($where3.' order by a.billDate');
$this->load->view('report/fundBalance-exporterSupplier',$data);
}
public function account_proceeds_detail_new() {
$this->common_model->checkpurview(55);
$data['accountNo'] = $accountNo = intval($this->input->get_post('accountNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/account-proceeds-detail-new',$data);
}
public function fundBalance_detail() {
$this->common_model->checkpurview(55);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = 0;
$data['status'] = 200;
$data['msg'] = 'success';
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$type = intval($this->input->get_post('type',TRUE));
$accountNo = str_enhtml($this->input->get_post('accountNo',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = 'and (billType="SALE" or billType="RECEIPT") and billDate<"'.$beginDate.'"';
$where2 = 'a.isDelete=0 and (a.type=-10)';
$where2 .= $accountNo ? ' and a.number="'.$accountNo.'"' : '';
$list1 = $this->data_model->get_contact($where1 ,$where2.' order by a.id');
$where3 = 'a.isDelete=0 and (a.billType="SALE" or a.billType="RECEIPT")';
$where3 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where3 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where3 .= $this->common_model->get_admin_purview();
$list2 = $this->data_model->get_invoice($where3.' order by a.billDate');
foreach ($list1 as $arr=>$row) {
$v[$arr]['balance'] = $row['amount'];
$v[$arr]['billId'] = 0;
$v[$arr]['billNo'] = '期初余额';
$v[$arr]['billType'] = 0;
$v[$arr]['date'] = '';
$v[$arr]['billTypeNo'] = 0;
$v[$arr]['buId'] = 0;
$v[$arr]['buName'] = $row['name'];
$v[$arr]['number'] = $row['number'];
$v[$arr]['transType'] = '';
$v[$arr]['type'] = '';
$v[$arr]['expenditure'] = '';
$v[$arr]['income'] = '';
foreach ($list2 as $arr1=>$row1) {
$arr = time() + $arr1;
if ($row['id']==$row1['buId']) {
$sum1 += $a1 = $row1['billType']=='SALE' ? $row1['arrears'] : 0;
$sum2 += $a2 = $row1['billType']=='RECEIPT' ? abs($row1['arrears']) : 0;
$a3 = $row['amount'] + $sum1 - $sum2;
$v[$arr]['balance'] = $a3;
$v[$arr]['billId'] = $row1['id'];
$v[$arr]['billNo'] = $row1['billNo'];
$v[$arr]['date'] = $row1['billDate'];
$v[$arr]['billTypeNo'] = $row1['billType'];
$v[$arr]['buId'] = $row1['buId'];
$v[$arr]['buName'] = $row1['contactName'];
$v[$arr]['number'] = $row1['contactNo'];
$v[$arr]['transType'] = $row1['transTypeName'];
$v[$arr]['type'] = -1;
$v[$arr]['expenditure'] = $a2;
$v[$arr]['income'] = $a1;
}
}
$sum3 = $row['amount'] + $sum1 - $sum2;
$arr = $arr + $row['id'];
$v[$arr]['balance'] = $sum3;
$v[$arr]['billId'] = 0;
$v[$arr]['billNo'] = '小计';
$v[$arr]['date'] = '';
$v[$arr]['billTypeNo'] = 0;
$v[$arr]['buId'] = 0;
$v[$arr]['buName'] = '';
$v[$arr]['number'] = '';
$v[$arr]['transType'] = '';
$v[$arr]['type'] = -1;
$v[$arr]['income'] = $sum1;
$v[$arr]['expenditure'] = $sum2;
$sum4 += $sum1;
$sum5 += $sum2;
$sum6 += $sum3;
}
$data['data']['total']['balance'] = $sum6;
$data['data']['total']['billId'] = '';
$data['data']['total']['billNo'] = '';
$data['data']['total']['billTypeNo'] = '';
$data['data']['total']['buId'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['income'] = $sum4;
$data['data']['total']['expenditure'] = $sum5;
$data['data']['total']['number'] = '';
$data['data']['total']['transType'] = '';
$data['data']['total']['type'] = '';
$data['data']['list'] = isset($v) ? array_values($v) :'';
$data['data']['params']['startTime'] = '';
$data['data']['params']['numberFilter'] = '';
$data['data']['params']['categoryId'] = '';
$data['data']['params']['keyword'] = '';
$data['data']['params']['dbid'] = '';
$data['data']['params']['table'] = '';
$data['data']['params']['serviceType'] = '';
$data['data']['params']['customer'] = '';
$data['data']['params']['type'] = '';
$data['data']['params']['supplier'] = '';
$data['data']['params']['endDate'] = $endDate;
$data['data']['params']['beginDate'] = $beginDate;
die(json_encode($data));
}
public function fundBalance_exporter() {
$this->common_model->checkpurview(56);
$name = 'receive_balance_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('应收账款明细表导出:'.$name);
$accountNo = str_enhtml($this->input->get_post('accountNo',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where1 = 'and (billType="SALE" or billType="RECEIPT") and billDate<"'.$beginDate.'"';
$where2 = 'a.isDelete=0 and (a.type=-10)';
$where2 .= $accountNo ? ' and a.number="'.$accountNo.'"' : '';
$data['list1'] = $this->data_model->get_contact($where1 ,$where2.' order by a.id');
$where3 = 'a.isDelete=0 and (a.billType="SALE" or a.billType="RECEIPT")';
$where3 .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where3 .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where3 .= $this->common_model->get_admin_purview();
$data['list2'] = $this->data_model->get_invoice($where3.' order by a.billDate');
$this->load->view('report/fundBalance-exporter',$data);
}
public function customers_reconciliation_new() {
$this->common_model->checkpurview(109);
$data['customerId'] = $customerId = intval($this->input->get_post('customerId',TRUE));
$data['customerName'] = str_enhtml($this->input->get_post('customerName',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/customers-reconciliation-new',$data);
}
public function customerBalance_detail() {
$this->common_model->checkpurview(109);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$showDetail = str_enhtml($this->input->get_post('showDetail',TRUE));
$customerId = intval($this->input->get_post('customerId',TRUE));
$customerName = str_enhtml($this->input->get_post('customerName',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$list1 = $this->data_model->get_contact('and billDate<"'.$beginDate.'" and buId='.$customerId,'a.isDelete=0 and a.id="'.$customerId.'"',1);
$where = 'a.isDelete=0 and (a.billType="SALE" or a.billType="RECEIPT")';
$where .= ' and a.buId='.$customerId;
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$list2 = $this->data_model->get_invoice($where.' order by a.id');
$arrears = count($list1)>0 ? $list1['amount'] : 0;
$v[0]['amount'] = 0;
$v[0]['billId'] = 0;
$v[0]['billNo'] = '期初余额';
$v[0]['billType'] = 'BAL';
$v[0]['date'] = '';
$v[0]['disAmount'] = 0;
$v[0]['entryId'] = 0;
$v[0]['inAmount'] = $arrears;
$v[0]['invName'] = '';
$v[0]['invNo'] = '';
$v[0]['price'] = '';
$v[0]['qty'] = '';
$v[0]['spec'] = '';
$v[0]['rpAmount'] = 0;
$v[0]['totalAmount'] = 0;
$v[0]['transType'] = '';
$v[0]['type'] = -1;
$v[0]['unit'] = '';
foreach ($list2 as $arr=>$row) {
$arr = $arr + 1;
$sum1 += $row['arrears'];
$sum2 += $row['amount'];
$sum3 += $row['totalAmount'];
$sum4 += $row['rpAmount'];
$sum5 += $row['disAmount'];
$v[$arr]['amount'] = (float)$row['amount'];
$v[$arr]['billId'] = intval($row['id']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['disAmount'] = $row['disAmount'];
$v[$arr]['entryId'] = 0;
$v[$arr]['inAmount'] = $sum1 + $arrears;
$v[$arr]['invName'] = '';
$v[$arr]['invNo'] = '';
$v[$arr]['price'] = '';
$v[$arr]['qty'] = '';
$v[$arr]['spec'] = '';
$v[$arr]['rpAmount'] = $row['rpAmount'];
$v[$arr]['totalAmount'] = $row['totalAmount'];
$v[$arr]['transType'] = $row['transTypeName'];
$v[$arr]['type'] = 1;
$v[$arr]['unit'] = '';
if ($showDetail == "true") {
if ($row['billType']=='SALE') {
$postData = unserialize($row['postData']);
foreach ($postData['entries'] as $arr1=>$row1) {
$arr1 = time() + $arr;
$v[$arr1]['amount'] = 0;
$v[$arr1]['billId'] = intval($row['id']);
$v[$arr1]['billNo'] = '';
$v[$arr1]['billType'] = '';
$v[$arr1]['date'] = '';
$v[$arr1]['disAmount'] = 0;
$v[$arr1]['entryId'] = 1;
$v[$arr1]['inAmount'] = $sum1 + $arrears;
$v[$arr1]['invName'] = isset($row1['invName']) ? $row1['invName'] :'';
$v[$arr1]['invNo'] = isset($row1['invNumber']) ? $row1['invNumber'] :'';
$v[$arr1]['price'] = isset($row1['price']) ? $row1['price'] :'';
$v[$arr1]['qty'] = isset($row1['qty']) ? $row1['qty'] :0;
$v[$arr1]['rpAmount'] = 0;
$v[$arr1]['spec'] = isset($row1['invSpec']) ? $row1['invSpec'] :'';
$v[$arr1]['totalAmount'] = isset($row1['amount']) ? $row1['amount'] :0;
$v[$arr1]['transType'] = '';
$v[$arr1]['type'] = '';
$v[$arr1]['unit'] = 0;
}
}
}
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['customerId'] = $customerId;
$data['data']['showDetail'] = (bool)$showDetail;
$data['data']['total']['amount'] = $sum2;
$data['data']['total']['billNo'] = '';
$data['data']['total']['billTypeNo'] = '';
$data['data']['total']['billId'] = '';
$data['data']['total']['billType'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['buNo'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['disAmount'] = $sum5;
$data['data']['total']['inAmount'] = $arrears + $sum1;
$data['data']['total']['entryId'] = '';
$data['data']['total']['invName'] = '';
$data['data']['total']['invNo'] = '';
$data['data']['total']['price'] = '';
$data['data']['total']['qty'] = '';
$data['data']['total']['rpAmount'] = $sum4;
$data['data']['total']['spec'] = '';
$data['data']['total']['totalAmount'] = $sum3;
$data['data']['total']['transType'] = '';
$data['data']['total']['type'] = '';
$data['data']['total']['unit'] = '';
$data['data']['list'] = isset($v) ? array_values($v) : array();
die(json_encode($data));
}
public function customerBalance_exporter() {
$this->common_model->checkpurview(110);
$name = 'contact_balance_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('客户对账单导出:'.$name);
$data['showDetail'] = $showDetail = str_enhtml($this->input->get_post('showDetail',TRUE));
$data['customerId'] = $customerId = intval($this->input->get_post('customerId',TRUE));
$data['customerName'] = str_enhtml($this->input->get_post('customerName',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$data['list1'] = $this->data_model->get_contact('and billDate<"'.$beginDate.'" and buId='.$customerId,'a.isDelete=0 and a.id="'.$customerId.'"',1);
$where = 'a.isDelete=0';
$where .= ' and a.buId='.$customerId;
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$data['list2'] = $this->data_model->get_invoice($where.' order by a.id');
$this->load->view('report/customerBalance-exporter',$data);
}
public function suppliers_reconciliation_new() {
$this->common_model->checkpurview(112);
$data['supplierId'] = $supplierId = intval($this->input->get_post('supplierId',TRUE));
$data['supplierName'] = str_enhtml($this->input->get_post('supplierName',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/suppliers-reconciliation-new',$data);
}
public function supplierBalance_detail() {
$this->common_model->checkpurview(112);
$sum1 = $sum2 = $sum3 = $sum4 = $sum5 = $sum6 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$showDetail = str_enhtml($this->input->get_post('showDetail',TRUE));
$supplierId = intval($this->input->get_post('supplierId',TRUE));
$supplierName = str_enhtml($this->input->get_post('supplierName',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$list1 = $this->data_model->get_contact('and billDate<"'.$beginDate.'" and buId='.$supplierId,'a.isDelete=0 and a.id="'.$supplierId.'"',1);
$where = 'isDelete=0 and (billType="PUR" or billType="PAYMENT")';
$where .= ' and buId='.$supplierId;
$where .= $beginDate ? ' and billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$list2 = $this->data_model->get_invoice($where.' order by a.id');
$arrears = count($list1)>0 ? $list1['amount'] : 0;
$v[0]['amount'] = 0;
$v[0]['billId'] = 0;
$v[0]['billNo'] = '期初余额';
$v[0]['billType'] = 'BAL';
$v[0]['date'] = '';
$v[0]['disAmount'] = 0;
$v[0]['entryId'] = 0;
$v[0]['inAmount'] = $arrears;
$v[0]['invName'] = '';
$v[0]['invNo'] = '';
$v[0]['price'] = '';
$v[0]['qty'] = '';
$v[0]['spec'] = '';
$v[0]['rpAmount'] = 0;
$v[0]['totalAmount'] = 0;
$v[0]['transType'] = '';
$v[0]['type'] = -1;
$v[0]['unit'] = '';
foreach ($list2 as $arr=>$row) {
$arr = $arr + 1;
$sum1 += $row['arrears'];
$sum2 += $row['amount'];
$sum3 += $row['totalAmount'];
$sum4 += $row['rpAmount'];
$sum5 += $row['disAmount'];
$v[$arr]['amount'] = (float)$row['amount'];
$v[$arr]['billId'] = intval($row['id']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['billType'] = $row['billType'];
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['disAmount'] = $row['disAmount'];
$v[$arr]['entryId'] = 0;
$v[$arr]['inAmount'] = $sum1 + $arrears;
$v[$arr]['invName'] = '';
$v[$arr]['invNo'] = '';
$v[$arr]['price'] = '';
$v[$arr]['qty'] = '';
$v[$arr]['spec'] = '';
$v[$arr]['rpAmount'] = $row['rpAmount'];
$v[$arr]['totalAmount'] = $row['totalAmount'];
$v[$arr]['transType'] = $row['transTypeName'];
$v[$arr]['type'] = 1;
$v[$arr]['unit'] = '';
if ($showDetail == "true") {
if ($row['billType']=='PUR') {
$postData = unserialize($row['postData']);
foreach ($postData['entries'] as $arr1=>$row1) {
$arr1 = time() + $arr;
$v[$arr1]['amount'] = 0;
$v[$arr1]['billId'] = intval($row['id']);
$v[$arr1]['billNo'] = '';
$v[$arr1]['billType'] = '';
$v[$arr1]['date'] = '';
$v[$arr1]['disAmount'] = 0;
$v[$arr1]['entryId'] = 1;
$v[$arr1]['inAmount'] = $sum1 + $arrears;
$v[$arr1]['invName'] = isset($row1['invName']) ? $row1['invName'] :'';
$v[$arr1]['invNo'] = isset($row1['invNumber']) ? $row1['invNumber'] :'';
$v[$arr1]['price'] = isset($row1['price']) ? $row1['price'] :'';
$v[$arr1]['qty'] = isset($row1['qty']) ? $row1['qty'] :0;
$v[$arr1]['rpAmount'] = 0;
$v[$arr1]['spec'] = isset($row1['invSpec']) ? $row1['invSpec'] :'';
$v[$arr1]['totalAmount'] = isset($row1['amount']) ? $row1['amount'] :0;
$v[$arr1]['transType'] = '';
$v[$arr1]['type'] = '';
$v[$arr1]['unit'] = 0;
}
}
}
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['supplierId'] = $supplierId;
$data['data']['showDetail'] = (bool)$showDetail;
$data['data']['total']['amount'] = $sum2;
$data['data']['total']['billNo'] = '';
$data['data']['total']['billTypeNo'] = '';
$data['data']['total']['billId'] = '';
$data['data']['total']['billType'] = '';
$data['data']['total']['buName'] = '';
$data['data']['total']['buNo'] = '';
$data['data']['total']['date'] = '';
$data['data']['total']['disAmount'] = $sum5;
$data['data']['total']['inAmount'] = $arrears + $sum1;
$data['data']['total']['entryId'] = '';
$data['data']['total']['invName'] = '';
$data['data']['total']['invNo'] = '';
$data['data']['total']['price'] = '';
$data['data']['total']['qty'] = '';
$data['data']['total']['rpAmount'] = $sum4;
$data['data']['total']['spec'] = '';
$data['data']['total']['totalAmount'] = $sum3;
$data['data']['total']['transType'] = '';
$data['data']['total']['type'] = '';
$data['data']['total']['unit'] = '';
$data['data']['list'] = isset($v) ? array_values($v) : array();
die(json_encode($data));
}
public function supplierBalance_exporter() {
$this->common_model->checkpurview(113);
$name = 'supplier_balance_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('供应商对账单导出:'.$name);
$data['showDetail'] = $showDetail = str_enhtml($this->input->get_post('showDetail',TRUE));
$data['supplierId'] = $supplierId = intval($this->input->get_post('supplierId',TRUE));
$data['supplierName'] = str_enhtml($this->input->get_post('supplierName',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$data['list1'] = $this->data_model->get_contact('and billDate<"'.$beginDate.'" and (billType="PUR" or billType="PAYMENT") and buId='.$supplierId,'a.isDelete=0 and a.id="'.$supplierId.'"',1);
$where = 'isDelete=0';
$where .= ' and buId='.$supplierId;
$where .= $beginDate ? ' and billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$data['list2'] = $this->data_model->get_invoice($where.' order by a.id');
$this->load->view('report/supplierBalance-exporter',$data);
}
public function other_income_expense_detail() {
$this->common_model->checkpurview(115);
$data['supplierId'] = $supplierId = intval($this->input->get_post('supplierId',TRUE));
$data['beginDate'] = $beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = $endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$this->load->view('report/other-income-expense-detail',$data);
}
public function oriDetail_detail() {
$this->common_model->checkpurview(115);
$payment1 = $payment2 = 0;
$page = max(intval($this->input->get_post('page',TRUE)),1);
$rows = max(intval($this->input->get_post('rows',TRUE)),100);
$transType = str_enhtml($this->input->get_post('transType',TRUE));
$typeName = str_enhtml($this->input->get_post('typeName',TRUE));
$beginDate = str_enhtml($this->input->get_post('beginDate',TRUE));
$endDate = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and (a.transType=153401 or a.transType=153402)';
$where .= $transType ? ' and a.transType='.$transType : '';
$where .= $typeName ? ' and c.name="'.$typeName.'"' : '';
$where .= $beginDate ? ' and a.billDate>="'.$beginDate.'"' : '';
$where .= $endDate ? ' and a.billDate<="'.$endDate.'"' : '';
$where .= $this->common_model->get_admin_purview();
$offset = $rows * ($page-1);
$list = $this->data_model->get_account_info($where.' order by a.billDate');
foreach ($list as $arr=>$row) {
$v[$arr]['date'] = $row['billDate'];
$v[$arr]['billId'] = intval($row['iid']);
$v[$arr]['billNo'] = $row['billNo'];
$v[$arr]['transType'] = $row['transType'];
$v[$arr]['transTypeName'] = $row['transTypeName'];
$v[$arr]['contactNumber'] = $row['contactNo'];
$v[$arr]['contactName'] = $row['contactName'];
$v[$arr]['desc'] = $row['remark'];
$v[$arr]['typeName'] = $row['categoryName'];
if ($row['transType']==153401) {
$payment1 += $v[$arr]['amountIn'] = $row['payment'];
} else {
$payment2 += $v[$arr]['amountOut'] = abs($row['payment']);
}
}
$data['status'] = 200;
$data['msg'] = 'success';
$data['data']['page'] = $page;
$data['data']['records'] = $this->data_model->get_account_info($where,3);
$data['data']['total'] = ceil($data['data']['records']/$rows);
$data['data']['rows'] = isset($v) ? $v : array();
$data['data']['userdata']['date'] = '';
$data['data']['userdata']['billId'] = '';
$data['data']['userdata']['billNo'] = '';
$data['data']['userdata']['transType'] = '';
$data['data']['userdata']['transTypeName'] = '';
$data['data']['userdata']['contactNumber'] = '';
$data['data']['userdata']['contactName'] = '';
$data['data']['userdata']['desc'] = '';
$data['data']['userdata']['typeName'] = '';
$data['data']['userdata']['amountIn'] = $payment1;
$data['data']['userdata']['amountOut'] = $payment2;
die(json_encode($data));
}
public function oriDetail_export() {
$this->common_model->checkpurview(116);
$name = 'ori_detail_'.date('YmdHis').'.xls';
sys_csv($name);
$this->common_model->logs('其他收支明细表导出:'.$name);
$data['transType'] = str_enhtml($this->input->get_post('transType',TRUE));
$data['typeName'] = str_enhtml($this->input->get_post('typeName',TRUE));
$data['beginDate'] = str_enhtml($this->input->get_post('beginDate',TRUE));
$data['endDate'] = str_enhtml($this->input->get_post('endDate',TRUE));
$where = 'a.isDelete=0 and (a.transType=153401 or a.transType=153402)';
$where .= $data['transType'] ? ' and a.transType='.$data['transType'] : '';
$where .= $data['typeName'] ? ' and c.name="'.$data['typeName'].'"' : '';
$where .= $data['beginDate'] ? ' and a.billDate>="'.$data['beginDate'].'"' : '';
$where .= $data['endDate'] ? ' and a.billDate<="'.$data['endDate'].'"' : '';
$where .= $this->common_model->get_admin_purview();
$data['list'] = $this->data_model->get_account_info($where.' order by a.billDate');
$this->load->view('report/oriDetail_export',$data);
}
}
/* End of file welcome.php */
/* Location: ./application/controllers/welcome.php */
Reference in New Issue View Git Blame Copy Permalink