<?php
ini_set('display_errors', 1);
error_reporting(E_ALL);


session_start();

include("../include/config.php");
include("../include/simpleimage.php");
include("../include/functions.php");
require_once __DIR__ . '/../include/S3Helper.php';

validate_admin();
$s3Helper = new S3Helper(); // instantiate once
$s3Folder = "upload_images/quicklly-pass"; // S3 folder path

$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;
                    $tmp_path        = $_FILES['ing_icon']['tmp_name'][$key];

                    $s3Helper->upload($tmp_path, $s3Folder, $ing_icon);
                    //ftp start
                }

                $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;
                     $tmp_path         = $_FILES['ing_icon']['tmp_name'][$key];

                    $s3Helper->upload($tmp_path, $s3Folder, $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;
                         $tmp_path         = $_FILES['ing_icon']['tmp_name'][$key];

                        $s3Helper->upload($tmp_path, $s3Folder, $ing_icon);
                        // Upload to main website FTP
                        
                    }


                    $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="<?php echo SITE_URL_CDN  ?>/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>