### get_customer_vip_card 通過顧客ID獲取正在使用的VIP卡號 **位置：** Wpos\Controller\IndexController.class.php **參數：** @param $customer_idt int 顧客ID **調用：** $this->get_customer_vip_card($customer_id)； **完整代碼：** ~~~ /** * 通過顧客ID獲取正在使用的VIP卡號 * Lanson 2017-09-28 * @param $customer_id int 顧客ID * @return $result string VIP卡號 */ public function get_customer_vip_card($customer_id) { $result = M('mbship_customer as cus') ->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') ->where("cus.id = '{$customer_id}' and vip_info.selling_card = '0' and info.putinfo_status = '已使用'") ->getField('vip_info.card_no'); return $result; } ~~~