public static function checkCouponcodeExists($couponcode = '', $userId = "")
{
global $tableprefix;
$currentDate = date('Y-m-d');
if (!empty($couponcode)) {
// Check email address exists in subscribers list
$query = "SELECT o.couponCode FROM " . $tableprefix . "orders o\n WHERE o.user_id = '" . mysql_real_escape_string($userId) . "' AND\n o.couponCode ='" . mysql_real_escape_string($couponcode) . "' ";
$resCat = DbHelper::execute($query);
if (mysql_num_rows($resCat) == 0) {
$query = "SELECT cc.* FROM " . $tableprefix . "couponcode cc WHERE cc.ccCode='" . mysql_real_escape_string($couponcode) . "' AND\n cc.ccStatus='Y' AND cc.subscriptionStatus='Y'\n AND cc.ccStartDate<='" . mysql_real_escape_string($currentDate) . "' AND\n cc.ccEndDate>='" . mysql_real_escape_string($currentDate) . "'";
$resCat = DbHelper::execute($query);
$data = DbHelper::fetchRow($resCat);
}
// If couopon code valid then return coupon percenatage
if ($data) {
return $data;
}
}
}
public static function getOrderTaxDetailsByOrderId($orderId = 0)
{
global $tableprefix;
$query = "SELECT ot.* FROM " . $tableprefix . "order_tax ot WHERE ot.orderid = '" . mysql_real_escape_string($orderId) . "'";
$resCat = DbHelper::execute($query);
$data = DbHelper::fetchRow($resCat);
return $data;
}
public static function getVendorFeedback($feedback_id)
{
global $tableprefix;
$sql = " SELECT f.*, a.first_name,a.last_name FROM " . $tableprefix . "artist_feedbacks f\n\t\tINNER JOIN " . $tableprefix . "artists a ON f.artist_id = a.artist_id\n WHERE f.artist_feedback_id = " . $feedback_id . "";
$result = DbHelper::execute($sql);
$feedback = DbHelper::fetchRow($result);
return $feedback;
}