<?php 
    include 'header.php'; 

        if(isset($_REQUEST['update']))
{   
    $u_id = $_REQUEST['u_id'];
    $u_email_id = $_REQUEST['u_email_id'];
    $u_status = $_REQUEST['u_status'];

    $edit_subscriptionQuery = "Update sp_subscription set email_id='$u_email_id',status='$u_status' where id='$u_id'";
    $sql = $db->prepare($edit_subscriptionQuery);
    if ($sql->execute()) 
    { ?>
        <script>
            alert("Update Successfully");
        </script>
    <?php }
}
?>

<style>
    .total_ques_div {
        background-color: white;
        border-color: #C8D5E0;
        border-image: none;
        border-style: solid;
        border-width: 1px 1px 2px;
        color: #1E598E;
        font-weight: bold;
        padding: 8px 10px;
        text-decoration: none;
    }

    .form-table td {
        padding: 0px !important;
    }

    .extLink {
        text-decoration: none;
        cursor: pointer;
    }

    .fancybox-skin {
        margin-left: 400px !important;
        width: 500px !important;
    }

    .form-table td {
        padding: 5px !important;
    }
</style>

<script type="text/javascript" charset="utf8" src="https://code.jquery.com/jquery-3.3.1.js"></script>

<script>
    jQuery.noConflict();
    jQuery(function($) {
        jQuery('#subscription').dataTable({
            "processing": true,
            "serverSide": true,
            "responsive": true,
            "ajax": "subscription_list_data.php",

            "columns": [

                {"data": "id",
                    render: function(data, type, row, meta) {
                        return meta.row + meta.settings._iDisplayStart + 1;
                    }
                },
                {"data": "email_id"},
                {"data": "reg_date"},
                {"data": "reason"},
                {"data": "status",
                    render: function(data, type, row, meta) {
                        if (row.status == '1') {
                            return "<font style='color:green;'>Active</font>";
                        } else if (row.status == '0') {
                            return "<font style='color:red;'>De-active</font>";
                        }
                    },
                },
                {"data": "action",
                    render: function(data, type, row, meta) {
                        var ret = '';
                            ret += '<i class="fa fa-edit" title="Edit Email" style="cursor:pointer;" data-toggle="modal" data-target="subsModal" onclick="subs('+row.id+')"></i>';
                        return ret;
                    }

                },
            ],
            "order": [
                [0, 'desc']
            ],
            "bPaginate": true,
            "iDisplayLength": 50,
            "lengthMenu": [
                [50, 100, 200, 300, 1000],
                [50, 100, 200, 300, "All"]
            ]
        });
    });
</script>
<main id="main-container">
    <div class="content content-narrow">
        <div class="row">
            <div class="col-lg-12">
                <div class="col-lg-11">
                    <h2 class="content-heading">Subscription List</h2>
                </div>
                <div class="col-lg-1">
                    <a href="subscription_list_excel.php">
                        <i class="fa fa-file-excel-o fa-2x" aria-hidden="true"></i>
                    </a>
                </div>
                <div class="col-lg-12">
                    <div class="table-responsive">
                        <table id="subscription" class="table table-striped table-bordered dt-responsive nowrap" style="width: 100%; cellspacing: 0;">
                            <thead>
                                <tr>
                                    <th>S.no</th>
                                    <th>Email</th>
                                    <th>Reg Date</th>
                                    <th>Reason</th>
                                    <th>Status</th>
                                    <th>Edit</th>
                                </tr>
                            </thead>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class=" modal fade" id="subsModal" role="dialog">
        <div class="modal-dialog">
            <div class="modal-content">
                <div class="modal-header">
                    <button type="button" class="close" data-dismiss="modal">&times;</button>
                    <h4 class="modal-title">Do you want to change ? </h4>
                </div>
                <div class="modal-body" id="modal_body">
                </div>
            </div>
        </div>
    </div>
</main>
<script>
function subs(id){

       var site = "/technc/subscription_list_edit.php?id="+id;
        jQuery.ajax({
        url: site,
        type:'POST',
        data:'html',
        success:function(data){
          document.getElementById("modal_body").innerHTML = data;
   }
    }); 

    jQuery("#subsModal").modal(); 
}
</script>
<?php include 'footer.php'; ?>