/**
* Function selects the list of users from whom the coupon codes to be send.
*
*
* @return string
*/
function sendCouponToSelectedUsers()
{
$coupon_code = $_POST['couponcode'];
$user_ids = $_POST['user_id'];
if (count($user_ids) > 0) {
for ($i = 0; $i < count($user_ids); $i++) {
$sql = "select user_email from users_table where user_id=" . $user_ids[$i];
$obj = new Bin_Query();
if ($obj->executeQuery($sql)) {
$mailids = $obj->records[0]['user_email'];
//echo $mailids.'-'.$user_ids[$i];
$title = 'Coupons';
$mail_content = 'Dear Customer , <br> You Have Received a Coupon. <br> Coupon code - ' . $coupon_code;
$default = new Core_CPromotionalCodes();
$default->sendingMail($mailids, $title, $mail_content);
$sql = "INSERT INTO coupon_user_relation_table(coupon_code, user_id, no_of_uses) VALUES ('" . $coupon_code . "'," . $user_ids[$i] . ",0)";
$obj = new Bin_Query();
if ($obj->updateQuery($sql)) {
}
}
}
$_SESSION['coupon_id'] = '';
return '<div class="alert alert-success">
<button data-dismiss="alert" class="close" type="button">×</button> Coupon Code Send To Selected Users Successfullly.</div>';
} else {
$_SESSION['coupon_id'] = '';
if ($_GET['page'] == '') {
return '<div class="alert alert-error">
<button data-dismiss="alert" class="close" type="button">×</button> Select Atleast One User.</div>';
}
}
}
