122 行
4.7 KiB
PHP
可执行文件
122 行
4.7 KiB
PHP
可执行文件
<?php
|
|
|
|
namespace Retail\Controller;
|
|
|
|
use Think\Controller;
|
|
|
|
//[1.7.90]
|
|
|
|
/**
|
|
* 商户采购资金流失
|
|
* Class PurchaseCapitalController
|
|
* @package Retail\Controller
|
|
*/
|
|
class PurchaseCapitalController extends BaseController
|
|
{
|
|
public function index()
|
|
{
|
|
$arr = array(
|
|
'exportOperation' => '/index.php/Retail/PurchaseCapital/export',
|
|
);
|
|
$authArr = checkFunction($arr);
|
|
$this->assign('authArr', $authArr);
|
|
$this->display();
|
|
}
|
|
|
|
public function CapitalList()
|
|
{
|
|
$CapitalModel = D("PurchaseCapital");
|
|
$merchat_id = session("merchant_userinfo")['id'];
|
|
$data = I("post.");
|
|
$add_time = $data['add_time'];
|
|
$purchase_order_number = $data['purchase_order_number'];
|
|
$pay_type = $data['pay_type'];
|
|
$page = $data['page'];
|
|
$limit = $data['limit'];
|
|
if (!empty($add_time)) {
|
|
$start_time = strtotime($add_time[0]);
|
|
$end_time = strtotime($add_time[1]);
|
|
$where[$CapitalModel::ADD_TIME] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($purchase_order_number)) {
|
|
$where[$CapitalModel::PURCHASE_ORDER_NUMBER] = $purchase_order_number;
|
|
}
|
|
if (!empty($pay_type)) {
|
|
$where[$CapitalModel::PAY_TYPE] = $pay_type;
|
|
}
|
|
$where[$CapitalModel::MERCHANT_ID] = $merchat_id;
|
|
$res = A("Api/Inventory")->MerCapitalList($where, $page, $limit, $fields = "*");
|
|
$this->ajaxReturn($res);
|
|
}
|
|
|
|
public function export()
|
|
{
|
|
$CapitalModel = D("PurchaseCapital");
|
|
$merchat_id = session("merchant_userinfo")['id'];
|
|
$data = I("get.");
|
|
$add_time = $data['add_time'];
|
|
$purchase_order_number = $data['purchase_order_number'];
|
|
$pay_type = $data['pay_type'];
|
|
if (!empty($add_time)) {
|
|
if(!in_array($add_time)){
|
|
$add_time = explode(',', $add_time);
|
|
}
|
|
$start_time = strtotime($add_time[0]);
|
|
$end_time = strtotime($add_time[1]);
|
|
$where[$CapitalModel::ADD_TIME] = array('between', array($start_time, $end_time));
|
|
}
|
|
if (!empty($purchase_order_number)) {
|
|
$where[$CapitalModel::PURCHASE_ORDER_NUMBER] = $purchase_order_number;
|
|
}
|
|
if (!empty($pay_type)) {
|
|
$where[$CapitalModel::PAY_TYPE] = $pay_type;
|
|
}
|
|
$where[$CapitalModel::MERCHANT_ID] = $merchat_id;
|
|
$CapitalList = $CapitalModel->getSelect($where, $page = '', $limit = '', "*");
|
|
if ($CapitalList) {
|
|
foreach ($CapitalList as $key => &$val) {
|
|
$val['index'] = $key + 1;
|
|
$val['pay_money'] = round($val['pay_money'], 2);
|
|
$val['pay_time'] = date('Y-m-d H:i:s', $val['pay_time']);
|
|
$val['add_time'] = date('Y-m-d H:i:s', $val['add_time']);
|
|
$val['operator_name'] = A('Api/Inventory')->OperatorName($val['operator_id']);
|
|
$val['supplier_name'] = D("Supplier")->getFindField(array('id' => $val['supplier_id']), "supplier_name");
|
|
switch ($val[$CapitalModel::PAY_TYPE]) {
|
|
case 1:
|
|
$val['pay_name'] = "预付款方式";
|
|
break;
|
|
case 2:
|
|
$val['pay_name'] = "微信";
|
|
break;
|
|
case 3:
|
|
$val['pay_name'] = "支付宝";
|
|
break;
|
|
case 4:
|
|
$val['pay_name'] = "线下";
|
|
break;
|
|
case 5:
|
|
$val['pay_name'] = "银行卡";
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
$CapitalList = $CapitalList ? $CapitalList : array();
|
|
$fileds_name = "采购资金流水";
|
|
$arr = array(
|
|
array('index', "序号"),
|
|
array('order_number', "付款单号"),
|
|
array("supplier_name", "客户名称"),
|
|
array("purchase_order_number", "批次号"),
|
|
array("pay_money", "金额"),
|
|
array("pay_name", "支付方式"),
|
|
array("bank_name", "开户银行"),
|
|
array("bank_card", "银行卡号"),
|
|
array("remarks", "备注"),
|
|
array("pay_time", "付款时间"),
|
|
array("add_time", "操作时间"),
|
|
array("operator_name", "操作人"),
|
|
);
|
|
$str = $fileds_name . ",导出日期为" . date("Y-m-d H:i:s", time());
|
|
getExcel($fileds_name, $arr, $CapitalList, $str);
|
|
}
|
|
} |