### 根據客戶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; } ~~~