Back to PhocacartPos class

Method getCardByVendorAndTicket

public static
getCardByVendorAndTicket
(mixed $vendorId, mixed $ticketId, mixed $unitId, mixed $sectionId, mixed $userId = 0)

Method getCardByVendorAndTicket - Source code

public static function getCardByVendorAndTicket($vendorId, $ticketId, $unitId, $sectionId, $userId = 0)
{
    if ((int) $vendorId > 0 && (int) $ticketId > 0) {
        $db = Factory::getDBO();
        $query = ' SELECT loyalty_card_number FROM #__phocacart_cart_multiple' . ' WHERE vendor_id = ' . (int) $vendorId . ' AND ticket_id = ' . (int) $ticketId . ' AND unit_id = ' . (int) $unitId . ' AND section_id = ' . (int) $sectionId . ' AND user_id = ' . (int) $userId . ' ORDER BY loyalty_card_number LIMIT 1';
        $db->setQuery($query);
        $result = $db->loadResult();
        if ($result != '') {
            return $result;
        }
        return '';
    }
    return '';
}