### 根据客户ID查询会员级别信息 **位置：** Common\Lib\EventLib.class.php **参数：** * @param $customer_id int 客户ID **调用：** * 组件内部调用 $important = $this->getVipType($customer_id); * 组件文件外调用 $event = new EventLib(); $important = $event->getVipType($customer_id); **完整代码：** ~~~ /** * * 根据客户ID查询会员级别信息 * @param $customer_id int 客户ID * @return $important array 会员级别信息 * 异常返回 -1表示未查询到顾客信息 */ public function getVipType($customer_id) { // 查询出顾客信息 $cherit = M('mbship_customer as cus') ->field('*,cus.id as id,ber.id as ber_id') ->join('LEFT JOIN coscia_member_vip_card_info as vip_info on cus.id = vip_info.customer_id') ->join('LEFT JOIN coscia_member_putinfo as info on info.id = vip_info.putinfo_id') ->join('LEFT JOIN coscia_member_put as put on put.id = info.put_id') ->join('LEFT JOIN coscia_vip_type as ber on ber.id = put.member_id') ->where('cus.id='.$customer_id) ->select(); if (empty($cherit)) { return -1; } // 判断是否是会员 $important = array(); foreach ($cherit as $key => $value) { if (($value['identity'] == 2 || $value['identity'] == 1) && $value['selling_card'] == 0 && $value['putinfo_status'] == '已使用') { $important = $cherit[$key]; } } // 判断是否是顾客 if (empty($important)) { foreach ($cherit as $key => $value) { // 加上 4 电商会员 2018-5-25 jig update if ($value['identity'] == 0 || $value['identity'] == 4) { $important['customer_name'] = $value['customer_name']; $important['card_no'] = ''; $important['customer_phone'] = $value['customer_phone']; $important['member_name'] = null;//会员级别 $important['ber_id'] = null; $important['card_discount'] = ' '; $important['id'] = $value['id']; } } } return $important; } ~~~