";print_r($_POST);die;
$locationArr=$_POST['location'];
$storeArr=$_POST['store_id'];
$sectionArr=$_POST['section_id'];
foreach ($storeArr as $storeArrs) {
if($storeArrs==260 ) {
array_push($storeArr,279);
}
if($storeArrs==279 ) {
array_push($storeArr,260);
}
if($storeArrs==194) {
array_push($storeArr,195);
}
if($storeArrs==195) {
array_push($storeArr,194);
}
if($storeArrs==270) {
array_push($storeArr,271);
}
if($storeArrs==271) {
array_push($storeArr,270);
}
if($storeArrs==245) {
array_push($storeArr,277);
}
if($storeArrs==277) {
array_push($storeArr,245);
}
}
//echo "";print_r($storeArr);die;
//array_push($a,"blue","yellow");
$store = implode(',',$storeArr);
$store= trim($store,",");
$location = implode(',',$locationArr);
$section = implode(',',$sectionArr);
$section= trim($section,",");
$custom_coupon_code= mysqli_real_escape_string($GLOBALS['conn'],$_POST['custom_coupon_code']);
$chkSrcSql=$obj->query("SELECT id,name FROM coupon_source ");
//echo "select count(coupon_code) as cnt_no from $tbl_coupon where coupon_code='$custom_coupon_code'";die;
if($_REQUEST['submitForm']=='yes'){
//echo "select count(coupon_code) as cnt_no from $tbl_coupon where coupon_code='$custom_coupon_code'";die;
$chkSql=$obj->query("select count(coupon_code) as cnt_no from $tbl_coupon where coupon_code='$custom_coupon_code' and coupon_code!=''");
$chkResult=$obj->fetchNextObject($chkSql);
//echo "";print_r($chkResult);
//die;
/*if($chkResult->cnt_no == 0) {
$_SESSION['sess_msg']='Coupon code already exist!';
header("location:coupon-addf_val.php");
exit();
}*/
if($_REQUEST['id']=='')
{
if($chkResult->cnt_no == 0)
{
if($coupon_code_type=='custom_c') {
$coupon_code=mysqli_real_escape_string($GLOBALS['conn'],$_POST['custom_coupon_code']);;
}else {
$coupon_code=generateCouponCode();
}
if($_POST['general']=='specific') {
$specific_coupon = mysqli_real_escape_string($GLOBALS['conn'],$_POST['general']);
}
$obj->query("insert into $tbl_coupon set valid_for='$valid_for',discount_type='$discount_type',valid_time='$valid_time',discount='$discount',to_email='$to_email',expire_date='$expire_date',coupon_code='$coupon_code',generate_date=now(),minimum_purchase='$minimum_purchase',status=1,store_id='$store',section='$section',location='$location',coupon_code_type ='$coupon_code_type',coupon_type='$coupon_type',
applicable_on='$applicable_for',coupon_source='$source_id'");
if(!empty($specific_coupon)) {
$notificationId = $obj->lastInsertedId();
$obj->query("update tbl_coupon set notification_id ='$notificationId' where id=$notificationId");
}
$_SESSION['sess_msg']='Coupon added sucessfully';
header("location:coupon-list.php");
exit();
}else
{
$_SESSION['sess_msg']='Coupon code already exist!';
}
}else
{
$obj->query("update $tbl_coupon set valid_for='$valid_for',discount_type='$discount_type',valid_time='$valid_time',discount='$discount',to_email='$to_email',expire_date='$expire_date',minimum_purchase='$minimum_purchase' ,store_id='$store',section='$section',location='$location',coupon_code_type ='$coupon_code_type' ,coupon_type='$coupon_type' ,applicable_on='$applicable_for'
,coupon_source='$source_id'
where id=".$_REQUEST['id']);
$_SESSION['sess_msg']='Coupon updated sucessfully';
header("location:coupon-list.php");
exit();
}
//header("location:coupon-list.php");
//exit();
}
if($_REQUEST['id']!=''){
$sql=$obj->query("select * from $tbl_coupon where id=".$_REQUEST['id']);
$result=$obj->fetchNextObject($sql);
$storeArr = explode(',',$result->store_id);
$sectionArr = explode(',',$result->section);
}
?>
<?php echo SITE_TITLE; ?>
Admin: Update Coupon