### 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; } ~~~