'/index.php/Retail/SRetreatCapital/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() { $SRetreatCapitalModel = D("SRetreatCapital"); $merchat_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $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]." 00:00:00"); $end_time = strtotime($add_time[1]." 23:59:59"); $where[$SRetreatCapitalModel::ADD_TIME] = array('between',array($start_time,$end_time)); } if(!empty($retreat_order_number)){ $where[$SRetreatCapitalModel::RETREAT_ORDER_NUMBER] = $retreat_order_number; } if(!empty($pay_type)){ $where[$SRetreatCapitalModel::PAY_TYPE] = $pay_type; } $where[$SRetreatCapitalModel::MERCHANT_ID] = $merchat_id; $where[$SRetreatCapitalModel::STORE_ID] = $store_id; $res = A("Api/Inventory")->StoreRetreatCapitalList($where,$page,$limit,$fields="*"); $this->ajaxReturn($res); } public function export() { $SRetreatCapitalModel = D("SRetreatCapital"); $merchat_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $data = I("get."); $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)){ $add_time = explode(',',$add_time); $start_time = strtotime($add_time[0]." 00:00:00"); $end_time = strtotime($add_time[1]." 23:59:59"); $where[$SRetreatCapitalModel::ADD_TIME] = array('between',array($start_time,$end_time)); } if(!empty($retreat_order_number)){ $where[$SRetreatCapitalModel::RETREAT_ORDER_NUMBER] = $retreat_order_number; } if(!empty($pay_type)){ $where[$SRetreatCapitalModel::PAY_TYPE] = $pay_type; } $where[$SRetreatCapitalModel::MERCHANT_ID] = $merchat_id; $where[$SRetreatCapitalModel::STORE_ID] = $store_id; $CapitalList = $SRetreatCapitalModel->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("SSupplier")->getFindField(array('id'=>$val['supplier_id']),"supplier_name"); switch ($val[$SRetreatCapitalModel::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); } }