/** * 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>'; } } }