$param['merchant_id'], 'p.m_pay_type' => $param['create_coupon_type'], ]; if (!empty($param['vipSearchText'])) { $param['vipSearchText'] = trim($param['vipSearchText']); $where['v.name|v.nickname|v.mobile_phone'] = ['like', "%{$param['vipSearchText']}%"]; } if ($param['create_coupon_type'] == 1) { switch ($param['create_source_type']){ case 1: $where['p.type'] = 1; break; case 2: $where['p.type'] = ['in',[2,3]]; break; } } $fields = 'p.vip_id,p.openid,p.sub_openid,v.nickname,v.name,v.mobile_phone'; $payOrderModel = new PayInfoModel(); $list = $payOrderModel->getCouponUserList($fields, $where, $page, $limit); if (!empty($list)) { $count = $payOrderModel->getCouponUserCount($where); $vipModel = new RetailVipModel(); $map['merchantid'] = $param['merchant_id']; foreach ($list as &$val) { if (empty($val['vip_id'])) { switch ($param['create_coupon_type']) { case 1: //普通模式 $map['openid'] = $val['openid']; break; case 2: //服务商 $map['openid'] = $val['sub_openid']; break; } $vip = $vipModel->getFind($map, "id,mobile_phone,name,nickname"); if (!empty($vip)) { $val['name'] = $vip['name'] ? $vip['name'] : $vip['nickname']; $val['mobile_phone'] = $vip['mobile_phone']; $val['vip_id'] = $vip['id']; } else { $val['name'] = '非会员'; } } else { $val['name'] = $val['name'] ? $val['name'] : $val['nickname']; } } } return callBack(statusCode()['success'], "查询成功", ['list' => $list, 'count' => $count]); } }