'/index.php/Retail/SRetreatReceivables/export', 'payment'=>'/index.php/Retail/SRetreatReceivables/SupplierInfo', ); $authArr = checkFunction($arr); $this->assign('authArr',$authArr); $merchant_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $supplier = D("SSupplier")->getSelect(array('merchant_id'=>$merchant_id,'store_id'=>$store_id,'status'=>1),$page='',$limit='',"id,supplier_name"); $this->assign('supplier',json_encode($supplier)); $this->assign('showPrice',self::$showPrice); $this->assign('identity',self::$identity); $this->assign("global_store_jurisdiction",self::$global_store_jurisdiction); $this->display(); } public function RetreatList() { $SRetreatReceivablesModel = D("SRetreatReceivables"); $merchant_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $data = I("post."); $order_number = $data['order_number']; $add_time = $data['add_time']; $supplier_id = $data['supplier_id']; $pay_status = $data['pay_status']; $type = $data['type']; $page = $data['page']; $limit = $data['limit']; if(!empty($type)){ $where['type'] = $type; } if(!empty($order_number)){ $where[$SRetreatReceivablesModel::RETREAT_ORDER_NUMBER] = array('like','%'.$order_number."%"); } if(!empty($supplier_id)){ $where[$SRetreatReceivablesModel::SUPPLIER_ID] = $supplier_id; } if(!empty($pay_status)){ $where[$SRetreatReceivablesModel::PAY_STATUS] = $pay_status; } if(!empty($add_time)){ $start_time = strtotime($add_time[0]); $end_time = strtotime($add_time[1]); $where[$SRetreatReceivablesModel::RETREAT_TIME] = array('between',array($start_time,$end_time)); } $where[$SRetreatReceivablesModel::MERCHANT_ID] = $merchant_id; $where[$SRetreatReceivablesModel::STORE_ID] = $store_id; $res = A("Api/Inventory")->StoreReceivableList($where,$page,$limit,$fields="*"); $this->ajaxReturn($res); } //供货商 public function SupplierInfo() { $supplier_id = I("post.supplier_id"); $res = A("Api/Inventory")->StoreSupplierInfo($supplier_id); $this->ajaxReturn($res); } //收款操作 public function Collect() { $merchant_id = session("ls_userinfo")['merchantid']; $operator_id = session("jurisdiction_user")['id']; $store_id = session("storeid"); $data = I("post."); $res = A("Api/Inventory")->StoreCollect($data,$merchant_id,$store_id,$operator_id); if($res['status']==1){ //操作日志记录 $source = 0;//请求来源: 0pc系统 1小助手 $type = 4;//平台:1合伙人端 2代理商端 3商户端 4门店端 $request_data = json_encode($_POST);//请求参数 json数据 $desc = '采购退货进行收款操做';//操作行为描述 action_log($source,$type,$request_data,$desc); //end } $this->ajaxReturn($res); } public function export() { $SRetreatReceivablesModel = D("SRetreatReceivables"); $merchant_id = session("ls_userinfo")['merchantid']; $store_id = session("storeid"); $data = I("get."); $order_number = $data['order_number']; $add_time = $data['add_time']; $supplier_id = $data['supplier_id']; $pay_status = $data['pay_status']; $type = $data['type']; if(!empty($type)){ $where['type'] = $type; } if(!empty($order_number)){ $where[$SRetreatReceivablesModel::RETREAT_ORDER_NUMBER] = array('like','%'.$order_number."%"); } if(!empty($supplier_id)){ $where[$SRetreatReceivablesModel::SUPPLIER_ID] = $supplier_id; } if(!empty($pay_status)){ $where[$SRetreatReceivablesModel::PAY_STATUS] = $pay_status; } 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[$SRetreatReceivablesModel::RETREAT_TIME] = array('between',array($start_time,$end_time)); } $where[$SRetreatReceivablesModel::MERCHANT_ID] = $merchant_id; $where[$SRetreatReceivablesModel::STORE_ID] = $store_id; $RetreatList = $SRetreatReceivablesModel->getSelect($where,$page='',$limit='',"*"); if($RetreatList){ foreach ($RetreatList as $key=>&$val){ $val['index'] = $key + 1; $val[$SRetreatReceivablesModel::RETREAT_TIME] = date("Y-m-d H:i:s",$val[$SRetreatReceivablesModel::RETREAT_TIME]); $val[$SRetreatReceivablesModel::COLLECT_MONEY] = round($val[$SRetreatReceivablesModel::COLLECT_MONEY],2); $val[$SRetreatReceivablesModel::RECEIVED_MONEY] = round($val[$SRetreatReceivablesModel::RECEIVED_MONEY],2); $val['stay_money'] = round($val[$SRetreatReceivablesModel::COLLECT_MONEY] - $val[$SRetreatReceivablesModel::RECEIVED_MONEY],2); $val['supplier_name'] = D("SSupplier")->getFindField(array('id'=>$val[$SRetreatReceivablesModel::SUPPLIER_ID]),"supplier_name"); $val['operator'] = A('Api/Inventory')->OperatorName($val[$SRetreatReceivablesModel::OPERATOR_ID]); switch ($val[$SRetreatReceivablesModel::PAY_STATUS]){ case 1: $val['pay_name'] = "待收款"; break; case 2: $val['pay_name'] = "部分收款"; break; case 3: $val['pay_name'] = "已收款"; break; } } unset($val); } $RetreatList = $RetreatList?$RetreatList:array(); $fileds_name = "退货应收款导出"; $arr = array( array('index',"序号"), array('supplier_name',"供货商"), array("retreat_order_number","退货单"), array("operator","操作人"), array("retreat_time","退货时间"), array("collect_money","应收金额"), array("received_money","已收金额"), array("stay_money","待收金额"), array("pay_name","收款状态"), ); $str = $fileds_name.",导出日期为".date("Y-m-d H:i:s",time()); getExcel($fileds_name, $arr, $RetreatList, $str); } }