'/index.php/Retail/RetreatCapital/export', ); $authArr = checkFunction($arr); $this->assign('authArr', $authArr); $this->display(); } public function CapitalList() { $RetreatCapitalModel = D("RetreatCapital"); $merchat_id = session("merchant_userinfo")['id']; $data = I("post."); $add_time = $data['add_time']; $retreat_order_number = $data['retreat_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[$RetreatCapitalModel::ADD_TIME] = array('between', array($start_time, $end_time)); } if (!empty($retreat_order_number)) { $where[$RetreatCapitalModel::RETREAT_ORDER_NUMBER] = $retreat_order_number; } if (!empty($pay_type)) { $where[$RetreatCapitalModel::PAY_TYPE] = $pay_type; } $where[$RetreatCapitalModel::MERCHANT_ID] = $merchat_id; $res = A("Api/Inventory")->MerRetreatCapitalList($where, $page, $limit, $fields = "*"); $this->ajaxReturn($res); } public function export() { $RetreatCapitalModel = D("RetreatCapital"); $merchat_id = session("merchant_userinfo")['id']; $data = I("get."); $add_time = $data['add_time']; $retreat_order_number = $data['retreat_order_number']; $pay_type = $data['pay_type']; if (!empty($add_time)) { if (!is_array($add_time)) { $add_time = explode(',', $add_time); } $start_time = strtotime($add_time[0]); $end_time = strtotime($add_time[1]); $where[$RetreatCapitalModel::ADD_TIME] = array('between', array($start_time, $end_time)); } if (!empty($retreat_order_number)) { $where[$RetreatCapitalModel::RETREAT_ORDER_NUMBER] = $retreat_order_number; } if (!empty($pay_type)) { $where[$RetreatCapitalModel::PAY_TYPE] = $pay_type; } $where[$RetreatCapitalModel::MERCHANT_ID] = $merchat_id; $CapitalList = $RetreatCapitalModel->getSelect($where, $page = '', $limit = '', "*"); if ($CapitalList) { foreach ($CapitalList as $key => &$val) { $val['index'] = $key + 1; $val['collect_money'] = round($val['collect_money'], 2); $val['collect_time'] = date('Y-m-d H:i:s', $val['collect_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[$RetreatCapitalModel::PAY_TYPE]) { 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("retreat_order_number", "退货单号"), array("collect_money", "金额"), array("pay_name", "支收方式"), array("bank_name", "开户银行"), array("bank_card", "银行卡号"), array("remarks", "备注"), array("collect_time", "收款时间"), array("add_time", "操作时间"), array("operator_name", "操作人"), ); $str = $fileds_name . ",导出日期为" . date("Y-m-d H:i:s", time()); getExcel($fileds_name, $arr, $CapitalList, $str); } }