.-.-.-.-.-

<?php
$title = "admin sale report";
include 'header.php';

//$useridMAINN=$_SESSION['userid'];
?>
<script src="../js/jquery-ui.js" type="text/javascript"></script>
<link rel="stylesheet" href="../css/jquery-ui.css" />
<div class="container-fluid">

<div class="row">
        <div class="col-sm-12">
            <div class="page-title-box">
                <h4 class="page-title">Franchise List</h4>
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                    <li class="breadcrumb-item"><a href="#">Inventory</a></li>
                    <li class="breadcrumb-item active">Franchise List</li>

</ol>

</div>
        </div>
    </div>

<button type="submit" class="btn btn-primary" id="submit">Search</button><br><br><br>
                    </form>

<table class="table mb-0 table-bordered table-striped" id="datatable-ajax-page">
                        <thead>
                            <tr>
                                <th>
                                    FID
                                </th>
                                <th>
                                    Name
                                </th>
                                <th>
                                    Email
                                </th>
                                <th>
                                    Password
                                </th>
                                <th>
                                    Mobile #
                                </th>
                                <th>
                                    Store name
                                </th>
                                <th>
                                    City
                                </th>
                                <th>
                                    ID date
                                </th>
                                <th>Edit</th>
                                <th>
                                    Delete
                                </th>
                            </tr>
                        </thead>
                        <tbody>

</tbody>
                    </table>
                    <?php //echo $pager->renderFullNav();        ?>  
                </div>
            </div>
        </div> 
    </div>
    
</div>
<script type="text/javascript">
    var start;
    $(document).ready(function () {
        var table = $('#datatable-ajax-page').DataTable({
            "ajax": {
                "url": "./report/franchise_list_json.php",
                "type": "POST",
                dataType: 'json',
                data: function (d) {

var formData = $("#search-form").serializeArray();
                    $.each(formData, function (i, field) {
                        d[field.name] = field.value;

});
                },
            },
            "processing": true,
            "serverSide": true,
            "pageLength": 500,
            //"lengthMenu": [[100, 500, 1000, 2000, -1], [100, 500, 1000, 2000, "All"]],
            "lengthMenu": [[100, 500, 1000, 2000, 5000], [100, 500, 1000, 2000, 5000]],
            "dom": 'B<"top">rt<"bottom"lp><"clear">',
            buttons: [
                'excel', 'csv', 'pdf', 'print'
            ],
            "columns": [
                {"data": "fid"},
//                {"title": "User", "data": "name",
//                    "render": function (data, type, full, meta) {
//                        return '<a href="edit_profile.php?uid=' + full.uid + '">' + full.login_id + '</a>';
//                    }},
                /* { "data": "parentRoleId" }, */
//                {"title": "User", "data": "name",
//                    "render": function (data, type, full, meta) {
//                        return '<a href="user_login_process.php?uid=' + full.uid + '" title="Login this user" target="_blank">' + full.name + '</a>';
//                    }},
                {"data": "name"},
                {"data": "email"},
                {"data": "password"},
                {"data": "mobile"},
                {"data": "store_name"},
                {"data": "city"},
                {"data": "id_date"},
                {"data": "pid",
                    "render": function (data, type, full, meta) {
                        return '<a href="edit_franchise.php?fid=' + full.fid + '" class="btn btn-primary">' + "edit" + '</a>';
                    }},
                  {"data": "pid",
                    "render": function (data, type, full, meta) {
                        return '<a href="delete_franchise.php?fid=' + full.fid + '" class="btn btn-primary">' + "Delete" + '</a>';
                    }},
                    
//                    render": function (data, type, full, meta) {
//                    return '<a href="product_edit.php?pid='+full.pid+'">'+'</a>';
//                }},
                
//                {"data": "pid",
//                    render": function (data, type, full, meta) {
//                    return '<a href="product_edit.php?pid='+full.pid+'">'+'</a>';
//                }},

//                {"data": "pid",
//                    "render": function (data, type, full, meta) {
//                        return '<a href="product_edit.php?pid=' + full.pid + '" class="btn btn-primary">' + "edit" + '</a>';
//                    }},
//                {"data": "pid",
//                    "render": function (data, type, full, meta) {
//                        return '<a href="delete_product.php?pid=' + full.pid + '" class="btn btn-primary">' + "delete" + '</a>';
//                    }},
            ],
        }
        );
        $("#search-form").submit(function (e) {
            table.ajax.reload();
            e.preventDefault(); // avoid to execute the actual submit of the form.
        });

table.on('xhr', function () {
            start = table.ajax.json().start;

});
    });

function processBlock(uid, login_id, status) {
        var r = confirm("Do you want Block user ID " + login_id);
        var url = status == 0 ? "process_block.php" : "process_unblock.php";

if (r) {
            $.get(url, {'uid': uid}, function (data) {
                alert(data);
                location.reload();
            });
        }
    }
    /*function processUnblock(uid, login_id) {
     var r = confirm("Do you want Unblock user ID " + login_id);
     if (r) {
     $.get("process_unblock.php", {'uid': uid}, function (data) {
     alert(data);
     location.reload();
     });
     }
     }*/

/home2/wtmwscom/public_html/admin/report/../franchise_list.php