<?php

session_start();

include("../include/config.php");
include("../include/simpleimage.php");
include("../include/functions.php"); 

 validate_admin();

  $plan_name=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_name']);
  $plan_type=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_type']);
  $plan_price=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_price']);

  $plan_discount=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_discount']);

  $discount=mysqli_real_escape_string($GLOBALS['conn'],$_POST['discount']);

  $plan_short_desc=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_short_desc']);

  $plan_extra_off_percentage=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_extra_off_percentage']);

  $plan_pickup_orders_off=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_pickup_orders_off']);
  
   $plan_minimum_order_cretaria=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_minimum_order_cretaria']);
   
   $plan_free_delivery=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_free_delivery']);
   
   $plan_packaging_fee=mysqli_real_escape_string($GLOBALS['conn'],$_POST['plan_packaging_fee']);
   
   $display_order=mysqli_real_escape_string($GLOBALS['conn'],$_POST['display_order']);

   
   $subscription_type=mysqli_real_escape_string($GLOBALS['conn'],$_POST['subscription_type']);

  if($_REQUEST['submitForm']=='yes'){

  if($_REQUEST['id']==''){


	  $obj->query("insert into tbl_quicklly_pass_plan set plan_name='$plan_name',plan_type='$plan_type',plan_price='$plan_price',plan_discount='$plan_discount',plan_short_desc='$plan_short_desc',plan_extra_off_percentage='$plan_extra_off_percentage',plan_pickup_orders_off='$plan_pickup_orders_off',plan_minimum_order_cretaria='$plan_minimum_order_cretaria',plan_free_delivery='$plan_free_delivery',plan_packaging_fee='$plan_packaging_fee',display_order='$display_order',subscription_type='$subscription_type',status=1");

	  $_SESSION['sess_msg']='Plan added sucessfully';  
       $product_id=mysqli_insert_id($GLOBALS['conn']);
	    //ingredients section start
        $i = 0;
        foreach ($_REQUEST['ing_name'] as $key => $val) {
            $i++;
			$ing_name = mysqli_real_escape_string($GLOBALS['conn'],$val);
            $ing_value = $_REQUEST['ing_value'][$key];
            $exist_id =$_REQUEST['exist_id'][$key];
           
           if(!empty($ing_name) && !empty($ing_value)){
            if ($_FILES['ing_icon']['size'][$key] > 0 && $_FILES['ing_icon']['error'][$key] == '') {
               $product_pic = preg_replace('/[0-9\@\.\;\" "]+/', '', $plan_name);
               $str = strtr( $product_pic, $unwanted_array );
                $product_img_name = buildURL($str);
                $Image = new SimpleImage();
                $filename = $_FILES['ing_icon']['name'][$key];
                $ext = pathinfo($filename, PATHINFO_EXTENSION);
                $ing_icon = time() . "-" . $product_img_name . $i . "." . $ext;
				     //ftp start
	if(SITE_URL==MAINSITE_URL){
$conn_id = ftp_connect("3.133.214.148") or die("Error in FTP connection");  // the FTP server you want to connect to.
$login_status = ftp_login($conn_id, "mainuser@quicklly.com", "n3At8hv3LZKCiF6") or die("Error in FTP login");  // Login to the FTP server.

//to upload from local
//ftp_pasv($conn_id, true);
//to create dir
//ftp_mkdir($conn_id, "imageststs");
  $target_file = $filename;
  $destination_file = "upload_images/quicklly-pass/".$ing_icon;  // since you want to upload to a directory called "images".
$upload_status = ftp_put($conn_id, $destination_file, $target_file, FTP_BINARY);

if (!$upload_status)
{
   die("Something went wrong, unable to upload featured image, contact to site administrator."); // do whatever it is that you want to do when you are unable to upload the file.
}

// Close the FTP connection after you are done.
ftp_close($conn_id);
}else{
}
move_uploaded_file($_FILES['ing_icon']['tmp_name'][$key], "../upload_images/quicklly-pass/" . $ing_icon);
            }
			
            $obj->query("INSERT INTO tbl_quicklly_pass_plan_details set plan_id='$product_id',plan_features='$ing_name',plan_title='$ing_value',plain_short_icon='$ing_icon',status=1,plan_flag=2");
        }
		}// for ecah loop
	  

       }else{ 
        $product_id = $_REQUEST['id'];
	  $obj->query("update tbl_quicklly_pass_plan set plan_name='$plan_name', plan_type='$plan_type',plan_price='$plan_price',plan_discount='$plan_discount',plan_short_desc='$plan_short_desc',plan_extra_off_percentage='$plan_extra_off_percentage',plan_pickup_orders_off='$plan_pickup_orders_off',plan_minimum_order_cretaria='$plan_minimum_order_cretaria',plan_free_delivery='$plan_free_delivery',plan_packaging_fee='$plan_packaging_fee',display_order='$display_order',subscription_type='$subscription_type',status=1 where id=".$_REQUEST['id']);

	  $_SESSION['sess_msg']='Plan updated sucessfully';   
       	 // Update product options
        $i = 0;
        $exist_id_value = array();
		
        foreach ($_REQUEST['ing_name'] as $key => $val) {
            $update_icon = "";
            $i++;
		
            $ing_name = mysqli_real_escape_string($GLOBALS['conn'],$val);
		
           $ing_value = $_REQUEST['ing_value'][$key];
            $exist_id =$_REQUEST['exist_id'][$key];
            
            
            if($exist_id){
                $exist_id_value[] = $exist_id; 
                

                if ($_FILES['ing_icon']['size'][$key] > 0 && $_FILES['ing_icon']['error'][$key] == '') {
                  $product_img_name = buildURL($plan_name);
				 
                   $Image= new SimpleImage();
                    $filename = $_FILES['ing_icon']['name'][$key];
                    $ext = pathinfo($filename, PATHINFO_EXTENSION);
                   $ing_icon = time() . "-" . $product_img_name . $i . "." . $ext;
					if(SITE_URL==MAINSITE_URL){
$conn_id = ftp_connect("3.133.214.148") or die("Error in FTP connection");  // the FTP server you want to connect to.
$login_status = ftp_login($conn_id, "mainuser@quicklly.com", "n3At8hv3LZKCiF6") or die("Error in FTP login");  // Login to the FTP server.

//to upload from local
//ftp_pasv($conn_id, true);
//to create dir
//ftp_mkdir($conn_id, "imageststs");
  $target_file = $filename;
  $destination_file = "upload_images/quicklly-pass/".$ing_icon;  // since you want to upload to a directory called "images".
$upload_status = ftp_put($conn_id, $destination_file, $target_file, FTP_BINARY);

if (!$upload_status)
{
   die("Something went wrong, unable to upload featured image, contact to site administrator."); // do whatever it is that you want to do when you are unable to upload the file.
}

// Close the FTP connection after you are done.
ftp_close($conn_id);
}else{
}
                    move_uploaded_file($_FILES['ing_icon']['tmp_name'][$key], "../upload_images/quicklly-pass/" . $ing_icon);
                    $update_icon = ",plain_short_icon='$ing_icon'";
                }

                $obj->query("update tbl_quicklly_pass_plan_details 
			  set plan_id='" . $_REQUEST['id'] . "' $update_icon ,plan_features='$ing_name',plan_title='$ing_value',status=1 WHERE id = '" . $exist_id . "'");
            } else {
				 if(!empty($ing_name) && !empty($ing_value)){
					
                if ($_FILES['ing_icon']['size'][$key] > 0 && $_FILES['ing_icon']['error'][$key] == '') {
                   $product_img_name = buildURL($plan_name);
				  
                   $Image= new SimpleImage();
                   $filename = $_FILES['ing_icon']['name'][$key];
                    $ext = pathinfo($filename, PATHINFO_EXTENSION);
                   $ing_icon = time() . "-" . $product_img_name . $i . "." . $ext;
				       // Upload to main website FTP
					   	if(SITE_URL==MAINSITE_URL){
$conn_id = ftp_connect("3.133.214.148") or die("Error in FTP connection");  // the FTP server you want to connect to.
$login_status = ftp_login($conn_id, "mainuser@quicklly.com", "n3At8hv3LZKCiF6") or die("Error in FTP login");  // Login to the FTP server.

//to upload from local
//ftp_pasv($conn_id, true);
//to create dir
//ftp_mkdir($conn_id, "imageststs");
  $target_file = $filename;
  $destination_file = "upload_images/quicklly-pass/".$ing_icon;  // since you want to upload to a directory called "images".
$upload_status = ftp_put($conn_id, $destination_file, $target_file, FTP_BINARY);

if (!$upload_status)
{
   die("Something went wrong, unable to upload featured image, contact to site administrator."); // do whatever it is that you want to do when you are unable to upload the file.
}

// Close the FTP connection after you are done.
ftp_close($conn_id);
}else{
}
              
				   move_uploaded_file($_FILES['ing_icon']['tmp_name'][$key], "../upload_images/quicklly-pass/" . $ing_icon);
                    
				  
                }
				
			
                $obj->query("insert into tbl_quicklly_pass_plan_details set plan_id='" . $_REQUEST['id'] . "',plan_features='$ing_name',plan_title='$ing_value',plain_short_icon='$ing_icon',status=1,plan_flag=2 ");
                 $product_option_id =mysqli_insert_id($GLOBALS['conn']);
				
				 if($product_option_id){
                $exist_id_value[] = $product_option_id;
				 }
            }
			}
        }// for ecah loop
   
        if(count($exist_id_value) > 0){
            $exist_ids = implode(",", $exist_id_value);
			
            $obj->query("delete from tbl_quicklly_pass_plan_details where plan_id='" . $_REQUEST['id'] . "' and plan_flag=2 and id not in ($exist_ids)");
         }
        }
		
		 if($product_id != 0) {
        // Insert/Update/delete sizes options
        if($_REQUEST['hdnSizeRemoveIDs'] != ''){
						$removeid=rtrim($_REQUEST['hdnSizeRemoveIDs'], ',');
            $obj->query('DELETE FROM  tbl_quicklly_pass_plan_details WHERE id IN (' . $removeid . ')');
		}
		if($_REQUEST['hdnCouponsRemoveIDs'] != ''){
			$removeid=rtrim($_REQUEST['hdnCouponsRemoveIDs'], ',');
            $obj->query('DELETE FROM  tbl_quicklly_pass_coupon WHERE id IN (' .$removeid . ')');
		}
        if($_REQUEST['hdnSizes'] != "") {
             $sizesArr = json_decode($_REQUEST['hdnSizes'], TRUE);  
             //echo var_dump($cusArr);
 
             foreach($sizesArr as $size) {
                  

                  if($size["ID"] == '0'){
                     $obj->query("  INSERT INTO tbl_quicklly_pass_plan_details 
                                    SET  plan_id = $product_id, plan_features = '".$size["SizeName"]."', 
                                          plan_flag = 1, status = 1");
                  }
                  else {
                     $obj->query(" UPDATE tbl_quicklly_pass_plan_details 
                                    SET   plan_id = $product_id, plan_features = '".$size["SizeName"]."', plan_flag = 1, status = 1 
                                    WHERE id = " . $size["ID"]);
                  }
             }
        }
		
		if($_REQUEST['hdnCoupons'] != "") {
             $couponArr = json_decode($_REQUEST['hdnCoupons'], TRUE);  
             //echo var_dump($cusArr);
 
             foreach($couponArr as $coupon) {
                  

                  if($coupon["ID"] == '0'){
                     $obj->query("  INSERT INTO tbl_quicklly_pass_coupon 
                                    SET  plan_id = $product_id, coupon_code = '".$coupon["CouponCode"]."', coupon_title = '".$coupon["CouponTitle"]."',discount_percentage = '".$coupon["CouponDiscount"]."',min_order = '".$coupon["CouponMinOrder"]."',temp_minorder = '".$coupon["CouponMinOrder"]."',bg_color_code = '".$coupon["CouponBgColor"]."',sort_order = '".$coupon["CouponSortOrder"]."', status = 1");
                  }
                  else {
                     $obj->query(" UPDATE tbl_quicklly_pass_coupon 
                                    SET    plan_id = $product_id, coupon_code = '".$coupon["CouponCode"]."', coupon_title = '".$coupon["CouponTitle"]."',discount_percentage = '".$coupon["CouponDiscount"]."',min_order = '".$coupon["CouponMinOrder"]."',temp_minorder = '".$coupon["CouponMinOrder"]."',bg_color_code = '".$coupon["CouponBgColor"]."',sort_order = '".$coupon["CouponSortOrder"]."', status = 1 
                                    WHERE id = " . $coupon["ID"]);
                  }
             }
        }
		 }

 header("location:quicklly-pass-list.php");

exit();

  }      

	   
if($_REQUEST['id']!=''){

$sql=$obj->query("select * from tbl_quicklly_pass_plan where id=".$_REQUEST['id']);

$result=$obj->fetchNextObject($sql);

}

	
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title><?php echo SITE_TITLE; ?></title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<link href="css/admin.css" rel="stylesheet" type="text/css" />
<style>
        .clsTemplate {
            display: none;
        }

        .clsMenuBanners {
            border: 1px solid rgb(195, 195, 195);
            padding:5px;
            width: 450px;
            border-radius: 2px;
        }

            .clsMenuBanners a.clsAddBtn {
                background-color: #0971a2;
                color: #FFFFFF;
                font-family: Verdana, Arial, Helvetica, sans-serif;
                font-size: 12px;
                border-radius: 5px;
                text-decoration: none;
                outline: none;
                display: inline-block;
                padding: 3px 5px;
            }

            .clsMenuBanners a.clsRemoveBtn {
                margin-left: 5px;
                display: inline-block;
                width:18px;
                height: 18px;
                background-image: url(../images/del.png);
                background-repeat: no-repeat;
                background-size: contain;
                background-position: center center;
            }

            .clsMenuBanners .clsBanners .clsBanner {
                display: none;
                background-color: #fff;
                margin-bottom: 10px;
                border-bottom: 1px solid #ccc;
                padding-bottom: 5px;
                cursor:move;
            }
      </style>

      <style>
        .clsSizes {
            border: 1px solid rgb(195, 195, 195);
            width: 500px;
            border-radius: 2px;
            padding: 5px;
        }

        .clsSizes .clsSize {
            padding: 10px 10px 15px 10px;
            display: none;
            grid-template-columns: repeat(2, 1fr);
            grid-gap: 10px;
            border-bottom: 1px solid #ccc;
            margin-bottom: 10px;
        }

        .clsSizes .clsSize .clsLabel {
           padding: 0;
           margin: 0;
        }

        .clsSizes .clsSize .clsValue {
           width: 90%;
        }

        .clsSizes a.clsAddBtn {
            background-color: #0971a2;
            color: #FFFFFF;
            font-family: Verdana, Arial, Helvetica, sans-serif;
            font-size: 12px;
            border-radius: 5px;
            text-decoration: none;
            outline: none;
            display: inline-block;
            padding: 3px 5px;
        }

        .clsSizes a.clsRemoveBtn {
            margin-left: 5px;
            display: inline-block;
            width:18px;
            height: 18px;
            background-image: url(../images/del.png);
            background-repeat: no-repeat;
            background-size: contain;
            background-position: center center;
            margin-top: 18px;
        }

        .clsTfnCustomize {
            border: 1px solid rgb(195, 195, 195);
            padding:5px;
            width: 267px;
            border-radius: 2px;
        }

        .clsTfnCustomize a.clsAddBtn {
            background-color: #0971a2;
            color: #FFFFFF;
            font-family: Verdana, Arial, Helvetica, sans-serif;
            font-size: 12px;
            border-radius: 5px;
            text-decoration: none;
            outline: none;
            display: inline-block;
            padding: 3px 5px;
        }

        .clsTfnCustomize a.clsRemoveBtn {
            margin-left: 5px;
            display: inline-block;
            width:18px;
            height: 18px;
            background-image: url(../images/del.png);
            background-repeat: no-repeat;
            background-size: contain;
            background-position: center center;
        }

            .clsGrps .clsGrp {
                display:none;
                background-color: #eee;        
                margin-bottom: 10px;
            }

                .clsGrps .clsGrp p {
                    margin: 0;        
                    color:#000;
                }

                .clsGrps .clsGrp .clsGrp-Name {
                    padding: 10px;
                    background-color: #ddd;
                    display: flex;
                    align-items: center;
                }

                .clsGrps .clsGrp .clsGrp-Name input[type=text] {
                    flex: 1;
                    margin-left: 5px;
                }

                .clsGrps .clsContent {
                    padding: 10px;
                }

                .clsGrps .clsContent .clsItems {
                    margin:0;
                    padding: 0;
                    margin-left: 18px;
                }

                    .clsGrps .clsContent .clsItems li {
                        display:none;
                        margin-bottom: 3px;
                    }

                    .clsGrps .clsContent .clsItems li:last-child {
                        margin-bottom: 7px;
                    }

                        .clsGrps .clsContent .clsItems li div {
                            display: flex;
                            align-items: center;
                        }

                            .clsGrps .clsContent .clsItems li div input[type=text] {
                                flex: 1;           
                            }
							
      </style>
<script type="text/javascript" language="javascript">

function validate(obj)

{

if(getRadioValue('valid_for')=='Particular' && !obj.to_email.value.match(/^([A-Za-z0-9_\-\.])+\@([A-Za-z0-9_\-\.])+\.([A-Za-z]{2,4})$/) ){

alert("Please enter valid email.");

	obj.to_email.focus();

	return false;

	
}


if(obj.valid_time.value==''){

alert("Please enter Number of Uses.");

obj.valid_time.focus();

return false;	

}


if(obj.discount.value==''){

alert("Please enter discount.");

obj.discount.focus();

return false;	

}


if(obj.minimum_purchase.value==''){

alert("Please enter minimum purchase amount.");

obj.minimum_purchase.focus();

return false;	

}


if(obj.expire_date.value==''){

alert("Please select expire date.");

obj.expire_date.focus();

return false;	

}


}

function getRadioValue(groupName) {

    var _result;

    try {

        var o_radio_group = document.getElementsByName(groupName);

        for (var a = 0; a < o_radio_group.length; a++) {

            if (o_radio_group[a].checked) {

                _result = o_radio_group[a].value;

                break;

            }

        }

    } catch (e) { }

    return _result;

}

            function addSize(){
                var template = $('#tempSize').html();
                $('.clsSizes-List').append(template);

                var dvLast = $('.clsSizes-List .clsSize:last-child');

                $(dvLast).slideDown('normal', function () {
                    $(this).css('display','grid');
                    $(this).find('input[type=text]')[0].focus();
                });
            }
			function addCoupons(){
                var template = $('#tempCoupon').html();
                $('.clsCoupon-List').append(template);

                var dvLast = $('.clsCoupon-List .clsSize:last-child');

                $(dvLast).slideDown('normal', function () {
                    $(this).css('display','grid');
                    $(this).find('input[type=text]')[0].focus();
                });
				$('.clsBgColor').spectrum({
  type: "component"
});
            }
function removeCoupon(lnk){
                if(confirm('Remove Coupon?')){
                    $(lnk).closest('.clsSize').slideUp('normal', function () {
                        if($(this)[0].dataset.id != '0')
                           $('#hdnCouponsRemoveIDs')[0].value = $('#hdnCouponsRemoveIDs').val() + $(this)[0].dataset.id + ',';

                        $(this).remove();
                    });
                }
            }
            function removeSize(lnk){
                if(confirm('Remove size?')){
                    $(lnk).closest('.clsSize').slideUp('normal', function () {
                        if($(this)[0].dataset.id != '0')
                           $('#hdnSizeRemoveIDs')[0].value = $('#hdnSizeRemoveIDs').val() + $(this)[0].dataset.id + ',';

                        $(this).remove();
                    });
                }
            }
			
</script>

</head>

<body>
<div class="clsTemplate">
<div id="tempSize">
            <div class="clsSize" data-id="0">
               <div class="clsRow">
                  <p class="clsLabel">Plan Short Features</p>
                  <input class="clsValue clsSizeName" type="text" placeholder="Eg. Special coupon every month" maxlength="50" required>
               </div>
               
               <a href="javascript:void(0);" class="clsRemoveBtn" onclick="removeSize(this);"></a>
            </div>
         </div>
		 <div id="tempCoupon">
            <div class="clsSize" data-id="0">
               <div class="clsRow">
                  <p class="clsLabel">Copon Code</p>
                  <input class="clsValue clsCode" type="text" placeholder="Eg. GROCERY5" maxlength="50" required>
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Coupon Title</p>
                  <input class="clsValue clsTitle" type="text" placeholder="Eg. Grocery" maxlength="50" required="">
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Discount(%)</p>
                  <input class="clsValue clsDiscount" type="text" maxlength="10" placeholder="Eg. 5" onkeypress="return isNumeric(event, true);">
               </div>
			    <div class="clsRow">
                  <p class="clsLabel">Min Order</p>
                  <input class="clsValue clsMinorder" type="text" maxlength="10" placeholder="Eg. 5" value="" onkeypress="return isNumeric(event, true);">
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Coupon Bg Color</p>
                  <input class="clsValue clsBgColor" type="text" placeholder="Eg. #000000" required>
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Sort Order</p>
                  <input class="clsValue clsSortOrder" type="text" maxlength="10" placeholder="Eg. 1"  onkeypress="return isNumeric(event, true);" required="">
               </div>
			   
               
               <a href="javascript:void(0);" class="clsRemoveBtn" onclick="removeSize(this);"></a>
            </div>
         </div>
		 </div>
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">

<?php include("header.php") ?>

<link rel="stylesheet" href="calender/css/jquery-ui.css">


	<script src="calender/js/jquery-ui.js"></script>

	<script src="https://cdn.jsdelivr.net/npm/spectrum-colorpicker2/dist/spectrum.min.js"></script>
	<link rel="stylesheet" type="text/css" href="https://cdn.jsdelivr.net/npm/spectrum-colorpicker2/dist/spectrum.min.css">
	

	<script>

	$(function() {

		$( "#expire_date" ).datepicker({

			changeMonth: true,

			changeYear: true,

			dateFormat:"yy-mm-dd",

			yearRange:'2014:<?php echo date('Y')+5; ?>'

		});

	});

	</script>

<tr>

	<td align="right" class="paddRtLt70" valign="top">

		<table width="99%" border="0" cellspacing="0" cellpadding="0">

			<tr>

			
				<td align="right" valign="top">

					<table width="100%" border="0" cellspacing="0" cellpadding="0">

						<tr>

							<td align="left" valign="middle" class="headingbg bodr text14">

					<em><img src="images/arrow2.gif" width="21" height="21" hspace="10" align="absmiddle" /></em>Admin: Update Quicklly Pass 

					<span  style="float:right; padding-right:10px;">

					<input type="button" name="add" value="View Quicklly Pass"  class="button" onclick="location.href='quicklly-pass-list.php'" /></span></td>

						</tr>

						
						<tr>

							<td height="100" align="left" valign="top" bgcolor="#f3f4f6" class="bodr">

                            <form name="frm" method="POST" enctype="multipart/form-data" action="" onsubmit="return validate(this)">

						<input type="hidden" name="submitForm" value="yes" />

						<input type="hidden" name="id" value="<?php echo $_REQUEST['id'];?>" />
						 <input type="hidden" name="hdnSizes" id="hdnSizes" value="">
                         <input type="hidden" name="hdnSizeRemoveIDs" id="hdnSizeRemoveIDs" value="">
						 <input type="hidden" name="hdnCoupons" id="hdnCoupons" value="">
                         <input type="hidden" name="hdnCouponsRemoveIDs" id="hdnCouponsRemoveIDs" value="">

							<table width="100%" cellpadding="0" cellspacing="0">

									<tr>

										<td align="center" colspan="2" class="paddRt14 paddBot11">

										<font color="#FF0000"><strong><?php echo $_SESSION['sess_msg']; $_SESSION['sess_msg']='';?></strong></font></td>

									</tr>

									<tr>

										<td width="18%" align="right" class="paddBot11 paddRt14">&nbsp;</td>

										<td width="82%" align="left" class="paddBot11"></td>

									</tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Plan name:</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="plan_name" type="text" id="plan_name" size="36" value="<?php echo stripslashes($result->plan_name);?>" /> </td>

							        </tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Plan Type:</strong></td>

									  <td align="left" class="paddBot11">
                                      <select id="plan_type" name="plan_type">
									  <option value=''>-select plan type--</option>
									   <option value='standard' <?php if($result->plan_type=='standard'){?> selected <?php } ?>>Standard</option>
									    <option value='platinum' <?php if($result->plan_type=='platinum'){?> selected <?php } ?>>Platinum</option>
									  </select>
                                      

							        </tr>
									
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Plan price:</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="plan_price" type="numb" id="plan_price" size="36" value="<?php echo stripslashes($result->plan_price);?>" /> </td>

							        </tr>
									<tr style="display:none;">

                                      <td align="right" class="paddBot11 paddRt14"><strong>Discount:</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="plan_discount" type="numb" id="plan_discount" size="36" value="<?php echo stripslashes($result->plan_discount);?>" /> </td>

							        </tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Short Description:</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="plan_short_desc" type="text" id="plan_short_desc" size="36" value="<?php echo stripslashes($result->plan_short_desc);?>" /> </td>

							        </tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Discount(Food and Grocery):</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="plan_extra_off_percentage" type="numb" id="plan_extra_off_percentage" size="36" value="<?php echo stripslashes($result->plan_extra_off_percentage);?>" /> </td>

							        </tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Pickup Order Discount:</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="plan_pickup_orders_off" type="numb" id="plan_pickup_orders_off" size="36" value="<?php echo stripslashes($result->plan_pickup_orders_off);?>" /> </td>

							        </tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong></strong></td>

									  <td align="left" class="paddBot11">

                                       <input name="plan_minimum_order_cretaria"  type="checkbox" value="1" <?php if($result->plan_minimum_order_cretaria==1){ ?>checked<?php } ?>/> Exclude Minimum Order Charges</td> </td>

							        </tr>
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong></strong></td>

									  <td align="left" class="paddBot11">

                                       <input name="plan_free_delivery"  type="checkbox" value="1" <?php if($result->plan_free_delivery==1){ ?>checked<?php } ?>/> Exclude Delivery Charges</td> </td>

							        </tr>
									
									<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong></strong></td>

									  <td align="left" class="paddBot11">

                                       <input name="plan_packaging_fee"  type="checkbox" value="1" <?php if($result->plan_packaging_fee==1){ ?>checked<?php } ?>/> Exclude Packaging Charges</td> </td>

							        </tr>
									
									                               <tr>
                  <td align="right" class="paddBot11 paddRt14" style="vertical-align: top;"><strong>Manage Coupon:</strong></td>
                  <td align="left" class="paddBot11">
                     <div class="clsSizes">
                        <div class="clsCoupon-List">
                           <?php
                                if($_REQUEST['id']!='') {
									$id=$_REQUEST['id'];
									
                                    $Coupon = $obj->query("  SELECT *
                                                            FROM    tbl_quicklly_pass_coupon
                                                            WHERE   plan_id=$id
                                                                    AND status=1 ORDER by sort_order");

                                    while($Coupons = $obj->fetchNextObject($Coupon)) { 
                            ?>
                              <div class="clsSize" data-id="<?php echo $Coupons->id ?>">
                               
                                
               <div class="clsRow">
                  <p class="clsLabel">Copon Code</p>
                  <input class="clsValue clsCode" type="text" placeholder="Eg. GROCERY5" maxlength="50" value="<?php echo $Coupons->coupon_code ?>" required>
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Coupon Title</p>
                  <input class="clsValue clsTitle" type="text" placeholder="Eg. Grocery" maxlength="50" value="<?php echo $Coupons->coupon_title ?>" required="">
               </div>
			   
			   <div class="clsRow">
                  <p class="clsLabel">Discount(%)</p>
                  <input class="clsValue clsDiscount" type="text" maxlength="10" placeholder="Eg. 5" value="<?php echo $Coupons->discount_percentage ?>" onkeypress="return isNumeric(event, true);">
               </div>
			   
			    <div class="clsRow">
                  <p class="clsLabel">Min Order</p>
                  <input class="clsValue clsMinorder" type="text" maxlength="10" placeholder="Eg. 5" value="<?php echo $Coupons->temp_minorder ?>" onkeypress="return isNumeric(event, true);">
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Coupon Bg Color</p>
                  <input class="clsValue clsBgColor" type="text" placeholder="Eg. #000000" value="<?php echo $Coupons->bg_color_code ?>" required>
               </div>
			   <div class="clsRow">
                  <p class="clsLabel">Sort Order</p>
                  <input class="clsValue clsSortOrder" type="text" maxlength="10" placeholder="Eg. 1" value="<?php echo $Coupons->sort_order ?>" onkeypress="return isNumeric(event, true);" required="">
               </div>
			   
               
               <a href="javascript:void(0);" class="clsRemoveBtn" onclick="removeCoupon(this);"></a>
            </div>
                                
                                
                              <?php } } ?>
                        </div>

                        <a href="javascript:void(0);" class="clsAddBtn" onclick="addCoupons();">+ Add Coupon</a>
                     </div>
                  </td>
               </tr>

                                      <tr>
                  <td align="right" class="paddBot11 paddRt14" style="vertical-align: top;"><strong>Quick Features:</strong></td>
                  <td align="left" class="paddBot11">
                     <div class="clsSizes">
                        <div class="clsSizes-List">
                           <?php
                                if($_REQUEST['id']!='') {
									$id=$_REQUEST['id'];
									
                                    $Sizes = $obj->query("  SELECT *
                                                            FROM    tbl_quicklly_pass_plan_details
                                                            WHERE   plan_id=$id
                                                                    AND plan_flag=1 and status=1");

                                    while($size = $obj->fetchNextObject($Sizes)) { 
                            ?>
                              <div class="clsSize" data-id="<?php echo $size->id ?>">
                                 <div class="clsRow">
                                    <p class="clsLabel">Plan Short Features
</p>
                                    <input class="clsValue clsSizeName" type="text" placeholder="Eg. Special coupon every month" maxlength="50" value="<?php echo $size->plan_features ?>" required>
                                 </div>
                                 
                                
                                 <a href="javascript:void(0);" class="clsRemoveBtn" onclick="removeSize(this);"></a>
                              </div>
                              <?php } } ?>
                        </div>

                        <a href="javascript:void(0);" class="clsAddBtn" onclick="addSize();">+ Add Features</a>
                     </div>
                  </td>
               </tr>
						            
			  
<?php $sqloption=$obj->query("SELECT * FROM    tbl_quicklly_pass_plan_details WHERE   plan_id='".$_REQUEST['id']."' AND plan_flag=2 and status=1");
$numoption=$obj->numRows($sqloption);
if($_REQUEST['id']=='' || $numoption==0){ ?>
			   <tr>
                  <td align="right" class="paddBot11 paddRt14"><strong>Popup Features :</strong></td>
                  <td align="left" class="paddBot11">
				  <table>
				  <tr><td><strong>Icon:</strong> <input type="hidden" name="exist_icon[]" value="<?php echo $result->plain_short_icon; ?>" /><input type="hidden" name="exist_id[]" value="" />
				  <input type="file" name="ing_icon[]" width="100px" /></td>
				   <td><strong>Title:</strong> <input type="text" required name="ing_value[]" /></td>
				  <td><strong>Description:</strong> <input type="text" name="ing_name[]" /></td>
				  
                  </tr>
				  <tr><td colspan="3" id="resultField"></td></tr>
				  <tr>
									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>
									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>
									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>
									  <td align="left" class="paddBot11">
                                     <a href="javascript:void(0)" id="add"> <img src="images/add.png" title="Add More" border="0" /></a>&nbsp;
                                     <a href="javascript:void(0)" id="remove"> <img src="images/remove.png" title="Remove" border="0" /></a>
                                      </td>
							  </tr>
				  </table></td>
               </tr>
			   <?php }else{ ?>
			   <tr>
                  <td align="right" class="paddBot11 paddRt14"><strong>Popup Features :</strong></td>
                  <td align="left" class="paddBot11">
				 
				  <?php 
                                  $counter = 0;
                                  while($resultoption=$obj->fetchNextObject($sqloption)){  ?> 
                      <table class="addedfield" id="addedfield_<?php echo $counter;?>">
                                              <tr><td><strong>Icon:</strong> <input type="hidden" name="exist_icon[]" value="<?php echo $resultoption->plain_short_icon; ?>" />
                                              <input type="hidden" name="exist_id[]" value="<?php echo $resultoption->id; ?>" />
                                              <input type="file" name="ing_icon[]"  width="100px" /><img width="40" src="../upload_images/quicklly-pass/<?php echo $resultoption->plain_short_icon?>"></td> 
											   <td><strong>Tilte:</strong> <input type="text" name="ing_value[]" required value="<?php echo $resultoption->plan_title; ?>" /></td>
											  <td><strong>Description:</strong> <input type="text" name="ing_name[]" required value="<?php echo $resultoption->plan_features; ?>" /></td>

                                                  
                                            </tr>
                                        </table>
				  <?php 
                                  
                                  $counter++;
                                  } ?>
                           <table>
				  <tr><td colspan="3" id="resultField"></td></tr>
				  <tr>
									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>
									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>
									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>
									  <td align="left" class="paddBot11">
                                     <a href="javascript:void(0)" id="add"> <img src="images/add.png" title="Add More" border="0" /></a>&nbsp;
                                     <a href="javascript:void(0)" id="remove"> <img src="images/remove.png" title="Remove" border="0" /></a>
                                      </td>
							  </tr>
				  </table></td>
               </tr>
			   <?php } ?>	
		
              <tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong></strong></td>

									  <td align="left" class="paddBot11">

                                       <input name="subscription_type"  type="checkbox" value="1" <?php if($result->subscription_type==1){ ?>checked<?php } ?>/>Free Demo</td> </td>

							        </tr>	   
<tr>

                                      <td align="right" class="paddBot11 paddRt14"><strong>Display Order:</strong></td>

									  <td align="left" class="paddBot11">

                                      <input name="display_order" type="number" id="display_order" size="36" value="<?php echo stripslashes($result->display_order);?>" /> </td>

							        </tr>
									

									<tr>

									  <td align="right" class="paddRt14 paddBot11">&nbsp;</td>

									  <td align="left" class="paddBot11">&nbsp;</td>

							  </tr>

									<tr>

										<td width="18%" align="right" class="paddRt14 paddBot11">&nbsp;</td>

										<td width="82%" align="left" class="paddBot11">

											<input type="submit" name="submit" value="Submit"  class="submit" border="0" onclick="return setData();"/> 	                  		 &nbsp;&nbsp;

											<input name="Reset" type="reset" id="Reset" value="Reset" class="submit" border="0" /></td>

									</tr>

								</table></form>

							</td>

						</tr>

						
					</table>

				</td>

			</tr>

		</table>

	</td>

</tr>

<?php include('footer.php'); ?>
<script>

                var sels = $('select.clsSelVal');
                for (i = 0; i < sels.length; i++) {
                   if(sels[i].dataset.val != '') {
                     sels[i].value = sels[i].dataset.val;
                     
                   
                }
				}

               $('.clsSizes-List .clsSize').css('display','grid');
			    $('.clsCoupon-List .clsSize').css('display','grid');
               $('.clsGrps .clsGrp').show();
               $('.clsGrps .clsGrp .clsItems li').show();
			   
			   
			   function setData(){
                // Sizes
                
                var sizes = $('.clsSizes-List .clsSize');
                var lstSizes = [];
				var coupons = $('.clsCoupon-List .clsSize');
                var lstCoupons = [];

                if(sizes.length > 0) {
                    for (var i = 0; i < sizes.length; i++) {
                        var _SizeName = $(sizes[i]).find('.clsSizeName').val().trim();

                        var s = {
                           ID: $(sizes[i])[0].dataset.id,
                           SizeName: _SizeName,
                           
                        }

                        lstSizes.push(s);
                    }

                    $('#hdnSizes').val(JSON.stringify(lstSizes));

                    if($('#hdnSizeRemoveIDs').val().trim() != '')
                        $('#hdnSizeRemoveIDs').val($('#hdnSizeRemoveIDs').val().trim().substring(0, $('#hdnSizeRemoveIDs').val().trim().length - 1));
                }
                else {
                  $('#hdnSizes').val('');

                  if(!$('#chkOnlyForAddOn')[0].checked){
                     alert('Add atleast one size!');
                     return false;
                  }
                }
			
				if(coupons.length > 0) {
                    for (var i = 0; i < coupons.length; i++) {
                        var _clsCode = $(coupons[i]).find('.clsCode').val().trim();
						 var _clsTitle = $(coupons[i]).find('.clsTitle').val().trim();
						 var _clsDiscount = $(coupons[i]).find('.clsDiscount').val().trim();
						 var _clsSortOrder = $(coupons[i]).find('.clsSortOrder').val().trim();
						 var _clsBgColor = $(coupons[i]).find('.clsBgColor').val().trim();
						 var _clsMinOrder = $(coupons[i]).find('.clsMinorder').val().trim();

                        var c = {
                           ID: $(coupons[i])[0].dataset.id,
                           CouponCode: _clsCode,
						    CouponTitle: _clsTitle,
							CouponDiscount: _clsDiscount,
							CouponSortOrder: _clsSortOrder,
							CouponBgColor: _clsBgColor,
							CouponMinOrder: _clsMinOrder,
							
                           
                        }

                        lstCoupons.push(c);
                    }

                    $('#hdnCoupons').val(JSON.stringify(lstCoupons));

                    if($('#hdnCouponsRemoveIDs').val().trim() != '')
                        $('#hdnCouponsRemoveIDs').val($('#hdnCouponsRemoveIDs').val().trim().substring(0, $('#hdnCouponsRemoveIDs').val().trim().length - 1));
                }
                else {
                  $('#hdnCoupons').val('');

                  if(!$('#chkOnlyForAddOn')[0].checked){
                     alert('Add atleast one size!');
                     return false;
                  }
                }

                
            }


</script>
   <script type="text/javascript">

	var counter = $(".addedfield").length;
	 $("#add").click(function(){
		 var tblid="addedfield_"+counter;
		 $("#resultField").append('<table class="addedfield" width="100%" border="0" cellspacing="0" cellpadding="0" id="'+tblid+'" ><tr><td colspan="4" style="height:10px"></td></tr><tr><td><strong>Icon: </strong><input type="file" name="ing_icon[]" width="100px" /><input type="hidden" name="exist_icon[]" value="" /><input type="hidden" name="exist_id[]" value="" /></td><td><strong>Title:</strong> <input type="text" name="ing_value[]" required /></td><td><strong>Description:</strong> <input type="text" name="ing_name[]" /></td></tr></table>');
		 counter++;
		 })
		 $("#remove").click(function(){
		  counter=counter-1;
		  var tblid="#addedfield_"+counter;
		  $(tblid).remove();
		
		 })
$('.clsBgColor').spectrum({
  type: "component"
});
</script>
</table>

</body>

</html>