'/index.php/Retail/SPurchaseCapital/export', ); $authArr = checkFunction($arr); $this->assign('authArr', $authArr); $this->assign('showPrice', self::$showPrice); $this->assign('identity', self::$identity); $this->assign("global_store_jurisdiction", self::$global_store_jurisdiction); $this->display(); } public function CapitalList() { $SCapitalModel = D("SPurchaseCapital"); $merchat_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $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[$SCapitalModel::ADD_TIME] = array('between', array($start_time, $end_time)); } if (!empty($purchase_order_number)) { $where[$SCapitalModel::PURCHASE_ORDER_NUMBER] = $purchase_order_number; } if (!empty($pay_type)) { $where[$SCapitalModel::PAY_TYPE] = $pay_type; } $where[$SCapitalModel::MERCHANT_ID] = $merchat_id; $where[$SCapitalModel::STORE_ID] = $store_id; $res = A("Api/Inventory")->StoreCapitalList($where, $page, $limit, "*"); $this->ajaxReturn($res); } public function export() { $SCapitalModel = D("SPurchaseCapital"); $merchat_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $data = I("get."); $add_time = $data['add_time']; $purchase_order_number = $data['purchase_order_number']; $pay_type = $data['pay_type']; if (!empty($add_time)) { $start_time = strtotime($add_time[0]); $end_time = strtotime($add_time[1]); $where[$SCapitalModel::ADD_TIME] = array('between', array($start_time, $end_time)); } if (!empty($purchase_order_number)) { $where[$SCapitalModel::PURCHASE_ORDER_NUMBER] = $purchase_order_number; } if (!empty($pay_type)) { $where[$SCapitalModel::PAY_TYPE] = $pay_type; } $where[$SCapitalModel::MERCHANT_ID] = $merchat_id; $where[$SCapitalModel::STORE_ID] = $store_id; $SCapitalList = $SCapitalModel->getSelect($where, $page = '', $limit = '', "*"); if ($SCapitalList) { foreach ($SCapitalList 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("SSupplier")->getFindField(array('id' => $val['supplier_id']), "supplier_name"); switch ($val[$SCapitalModel::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; } } } $SCapitalList = $SCapitalList ? $SCapitalList : 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, $SCapitalList, $str); } }