success('请求成功'); } /** * 获取客户信息 * * @ApiMethod GET * */ public function getCustom(){ if (Request::instance()->isGet() == false){ $this->error('非法请求'); } $field = 'rtrim(客户编号) as 客户编号,rtrim(客户名称) as 客户名称'; $list = Db::name('产品_基本资料')->distinct(true)->field($field)->order('客户编号 asc')->select(); $this->success('请求成功',$list); } /** * 客户资料管理 * * @ApiMethod GET * */ public function getCustomInfo(){ if (Request::instance()->isGet() == false){ $this->error('非法请求'); } $params = Request::instance()->param(); if (!isset($params['class'])){ $this->error('参数错误'); } $class = ''; if ($params['class'] == 1){ $class = '客户'; }else{ $class = '供应商'; } $limit = $params['limit']; if (empty($limit)){ $limit = 15; } $pages = $params['page']; if (empty($pages)){ $pages = 1; } $where['类型'] = $class; $field = 'rtrim(编号) as 编号,rtrim(名称) as 名称,rtrim(简称) as 简称,rtrim(地址) as 地址,rtrim(联系人) as 联系人,rtrim(电话) as 电话,业务员,rtrim(币种) as 币种,rtrim(Sys_id) as Sys_id,Sys_rq,Mod_rq,UniqId'; $list = Db::name('erp_客户供应商')->where($where)->field($field)->limit($limit)->page($pages)->select(); $total = Db::name('erp_客户供应商')->where($where)->count(); $data['data'] = $list; $data['total'] = $total; $this->success('请求成功',$data); } }