<?php include 'header.php'; 

if(isset($_REQUEST['submit']))
{   
    $id= $_REQUEST['id'];
    $examname= $_REQUEST['examname'];
    $typeid= $_REQUEST['typeid'];
    $typename= $_REQUEST['typename'];
    $v_genral=$_REQUEST['v_genral'];
    $v_OBC=$_REQUEST['v_OBC'];
    $v_SC=$_REQUEST['v_SC'];
    $v_ST=$_REQUEST['v_ST'];
    $EBC=$_REQUEST['EBC'];
    $WBC=$_REQUEST['WBC'];
    $total_vacancy=$_REQUEST['total_vacancy'];
    $age_limit=$_REQUEST['age_limit'];
    $Eligibility=$_REQUEST['Eligibility'];
    $status=$_REQUEST['status'];

    $updatequery="UPDATE sp_vacancy_detail SET exam_id='$examname', type_id='$typeid', type_name='$typename', gen='$v_genral', obc='$v_OBC', sc='$v_SC', st='$v_ST',ebc='$EBC', wbc='$WBC', total_vac='$total_vacancy', age_limit='$age_limit', eligibility='$Eligibility', status='$status' where id='$id'";
    $sql = $db->prepare($updatequery);
    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="assets/js/jquery-1.4.1.min.js"></script>
<script type="text/javascript" charset="utf8" src="assets/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="assets/css/jquery.dataTables.min.css">

<script>
    jQuery.noConflict();
    jQuery(function($) {
        jQuery('#vacancy_list').dataTable({
            "dom" : "Bfrtip",
            "pagingType": "full_numbers",
            "processing": true,
            "serverSide": true,
            "responsive": true,
            "ajax": "/technc/vacancy_list_data.php",
            "columns": [
                {"data": "id",
                    render: function(data, type, row, meta) {
                        return meta.row + meta.settings._iDisplayStart + 1;
                    }
                },
                {"data": "action",
                    render: function(data, type, row, meta) {
                        var ret = '';
                            ret += '<button class="btn btn-info" data-toggle="modal" data-target="boardModal" onclick="board('+row.id+')"><i class="fa fa-edit" title="Edit Exam" style="cursor:pointer;"></i></button><button class="btn btn-danger" style="cursor:pointer;" id='+row.id+' onclick="deleteVancancy(id)"><i class="fa fa-trash" aria-hidden="true" ></i> </button>';
                        return ret;
                    }
                },
                {"data": "examname"},
                {"data": "type_name"},
                {"data": "gen"},
                {"data": "obc"},
                {"data": "sc"},
                {"data": "st"},
                {"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>";
                        }
                    },
                }
            ],
            "order": [
                [5, 'desc']
            ],
            "bPaginate": true,
            "iDisplayLength": 50,
            "bProcessing" : true,
            "bServerSide" : true,
            "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">
                <h2 class="content-heading">Exam Vacancy List</h2>
                <div class="table-responsive">
                    <table id="vacancy_list" class="table table-striped table-bordered dt-responsive nowrap" style="width: 100%; cellspacing: 0;">
                        <thead>
                            <tr>
                                <th>S.no</th>
                                <th>Action</th>
                                <th>Exam name</th>
                                <th>Post Name</th>
                                <th>General</th>
                                <th>OBC</th>
                                <th>SC</th>
                                <th>ST</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                    </table>
                </div>
            </div>
        </div>
    </div>
    <!-------STATUS MODEL------------------------------->
    <div class=" modal fade" id="boardModal" 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 status ? </h4>
                </div>
                <div class="modal-body" id="modal_body">
                </div>
            </div>
        </div>
    </div>
</main>
<script>
function board(id){
   var site = "/technc/vacancy_edit.php?id="+id;
    jQuery.ajax({
        url: site,
        type:'POST',
        data:'html',
        success:function(data){
            document.getElementById("modal_body").innerHTML = data;
        }
    }); 
    jQuery("#boardModal").modal(); 
}

function deleteVancancy(id){
    var txt;
    var r = confirm("Do you want to Delete ?");
    if (r == true) {
        $.ajax('delete_exam_vacancy.php', {
            type: 'POST',  // http method
            data: { id:id },  // data to submit
            success: function (response) {
                var obj = jQuery.parseJSON(response);
                if(obj.status == '1'){
                    alert(obj.msg);
                    location.reload();
                } else {
                    alert(obj.msg);
                }
            },
            error: function (jqXhr, textStatus, errorMessage) {
            }
        });
    }
}
</script>
<?php include 'footer.php'; ?>