public static
getCardByVendorAndTicket
(mixed $vendorId, mixed $ticketId, mixed $unitId, mixed $sectionId, mixed $userId = 0)
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 '';
}