<?php


$PageSize = 10;
$PageNumber = 1;
if(isset($_GET['PageNumber'])){$PageNumber = $_GET['PageNumber'];}


$arNamestatus = array("Start with", "End with", "Contain", "Does not contain", "Equal to", "Does not equal to");
$arNamestatus2 = array("AND", "OR", "Contain", "Does not contain");
$arNamestatus3 = array("Start with", "End with", "Contain", "Does not contain", "Equal to", "Does not equal to", "Contains (Addr.)");
$arNamestatus4 = array("Before", "After", "Between");

$data_loadRoleSearch = $users_db->LoadRoleSearch();
$data_loadRoleSearch = $data_loadRoleSearch['Data'];



/*
echo '<pre>';
print_r($data_loadClassesSearch);
echo '</pre>';
LoadEventSearch
*/

 ?>



 <form class="" action="#" method="get">
   <div class="accordion" id="accordionExample">
     <div class="card mb-3">
       <div class="card-header " id="headingOne" style="background-color: rgb(69, 68, 125); cursor: pointer;">
         <h2 class="mb-0">
           <button class="btn btn-link btn-block text-left text-light" type="button" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
             <i class="fa fa-plus-square"></i> Users
           </button>
         </h2>
       </div>
       <div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordionExample">
         <div class="card-body">
           <div class="form-group row mt-3">
             <div class="col-sm-2">
               <label for="" class="col-form-label">User : </label>
             </div>
             <div class="col-sm-4">
               <input type="search" id="User" class="form-control " name="User" value="<?php echo @$_GET['User']; ?>" >
             </div>
             <div class="col-sm-2">
               <label for="" class="col-form-label">Email : </label>
             </div>
             <div class="col-sm-4">
               <input type="search" id="Email" class="form-control " name="Email" value="<?php echo @$_GET['Email']; ?>" >
             </div>
           </div>

           <div class="form-group row mt-3">
             <div class="col-sm-2">
               <label for="" class="col-form-label">Name : </label>
             </div>
             <div class="col-sm-4">
               <input type="search" id="Name" class="form-control " name="Name" value="<?php echo @$_GET['Name']; ?>" >
             </div>
             <div class="col-sm-2">
               <label for="" class="col-form-label">Surname : </label>
             </div>
             <div class="col-sm-4">
               <input type="search" id="Surname" class="form-control " name="Surname" value="<?php echo @$_GET['Surname']; ?>" >
             </div>
           </div>

           <div class="form-group row mt-3">
             <div class="col-sm-2">
               <label for="" class="col-form-label">Role : </label>
             </div>
             <div class="col-sm-4">
               <select class="form-control" name="Role"  >
                 <option value="">Select All</option>
                 <?php foreach ($data_loadRoleSearch as $key => $value) {  ?>
                   <option value="<?php echo @$value['Id']; ?>" <?php echo (@$value['Id']==@$_GET['Role'])?"selected":""; ?>><?php echo @$value['RoleName']; ?></option>
                 <?php } ?>
               </select>

             </div>

           </div>
         </div>
       </div>
     </div>
   </div>
   <div class="form-group row mt-3">
     <div class="col-sm-12 text-right">
       <button type="submit" class="btn btn-primary">
         <i class="fa fa-search"></i> Search</button>
       </div>
     </div>

 </form>


    <div class="form-group row mt-3">
        <div class="col-sm-6 ">
          <a class="btn btn-success" href="javascript:" data-toggle="modal" data-target="#usersModal"><i class="fas fa-plus-square"></i> Add</a>
        </div>
    </div>
    <div id="users_pagination" style="position:relative;">
        <div class="table-loader text-center" style="display:none;">
            <div class="overlay">
                <i class="fas fa-3x fa-spinner fa-pulse"></i>
            </div>
        </div>
        <table class="table table-hover table-bordered table-responsive">
            <thead>
                <tr>
                    <th style="width: 100px;"></th>
                    <th><a href="javascript:;" onclick="sortTable('#users_pagination',this,'LoadUsers')" data-by="UserName"
                    data-direction="" class="order sorting">UserName</a></th>
                    <th><a href="javascript:;" onclick="sortTable('#users_pagination',this,'LoadUsers')" data-by="RoleName"
                    data-direction="" class="order sorting">Role</a></th>
                    <th><a href="javascript:;" onclick="sortTable('#users_pagination',this,'LoadUsers')" data-by="Title"
                    data-direction="" class="order sorting">Title</a></th>
                    <th><a href="javascript:;" onclick="sortTable('#users_pagination',this,'LoadUsers')" data-by="Name"
                    data-direction="" class="order sorting">Name</a></th>
                    <th>MiddleName</th>
                    <th><a href="javascript:;" onclick="sortTable('#users_pagination',this,'LoadUsers')" data-by="Surname"
                    data-direction="" class="order sorting">Surname</a></th>
                    <th><a href="javascript:;" onclick="sortTable('#users_pagination',this,'LoadUsers')" data-by="EmailAddress"
                    data-direction="" class="order sorting">EmailAddress</a></th>
                    <th>Status</th>
                    <th>CreationTime</th>
                    <th>Creator</th>
                    <th>LastUpdateBy</th>
                    <th>LastUpdateDateTime</th>
                </tr>
            </thead>
            <tbody>
            </tbody>
        </table>

        <br /><br />
        <div class="supplierPager">
            <div class="row">
                <div class="col-md-6">
                    <input type="hidden" class="page" value="<?php echo @$PageNumber; ?>" />
                    <input type="hidden" class="page-size" value="<?php echo @$PageSize; ?>" />
                    <input type="hidden" class="numrows" value="0" />
                    <input type="hidden" class="orderBy" value="UserName" />
                    <input type="hidden" class="orderDirection" value="ASC" />
                    <input type="hidden" class="params" value="User=<?php echo @$_GET['User'];?>&Email=<?php echo @$_GET['Email'];?>&Name=<?php echo @$_GET['Name'];?>&Surname=<?php echo @$_GET['Surname'];?>&Role=<?php echo @$_GET['Role'];?>" />
                    แสดงรายการ <span class="start-record"></span> ถึง <span class="end-record"></span> จากทั้งหมด <span class="total-record"></span> รายการ
                </div>
                <div class="col-md-6 text-right pagination-zone">

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

    <!-- Modal-->
    <div class="modal fade" id="usersModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Add User</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div> <!--action="Update.php"-->
                <form  id="users-form" method="post">
                    <div class="modal-body">
                      <div class="form-group col">
                        <div class="table">
                          <div class="row">
                            <div class="col-md-6">
                              <label for="" class="title control-label">User <span style="color: red;">*</span> </label>
                              <input type="text" class="form-control" name="user" value="">
                            </div>
                            <div class="col-md-6">
                              <label for="" class="title control-label">Role <span style="color: red;">*</span> </label>
                              <input class="form-control" list="datalistRole" id="dataRole" name="dataRole" placeholder="Select All">
                              <datalist id="datalistRole">
                                <?php foreach ($data_loadRoleSearch as $key => $value) {  ?>
                                  <option value="<?php echo @$value['RoleName']; ?>">
                                <?php } ?>
                              </datalist>
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Name <span style="color: red;">*</span> </label>
                              <div class="input-group">
                                <div class="input-group-prepend">
                                  <span class="input-group-text" id="title-group">Mr</span>
                                </div>
                                <input type="text" class="form-control  col-lg-4" name="name" placeholder="name">
                                <input type="text" class="form-control  col-lg-4" name="middleName" placeholder="middleName">
                                <input type="text" class="form-control  col-lg-4" name="surname" placeholder="surname">
                              </div>
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Email <span style="color: red;">*</span> </label>
                              <input type="email" class="form-control" name="email" value="">
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Password <span style="color: red;">*</span>
                                <span style="color: gray;">(combination of 8 letters and numbers)</span>
                              </label>
                              <input type="password" class="form-control" name="password" id="password" value="">
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Confirm Password <span style="color: red;">*</span> </label>
                              <input type="password" class="form-control" name="repassword" id="repassword" value="">
                            </div>
                          </div>
                        </div>
                      </div>

                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                        <button class="btn btn-primary" id="btn-users-submit" >Confirm</button>
                    </div>
                </form>

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

    <!-- Modal-->
    <div class="modal fade" id="userseditModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-lg" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title">Edit User</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div> <!--action="Update.php"-->
                <form  id="users-edit-form" method="post">
                    <div class="modal-body">
                      <div class="form-group col">
                        <div class="table">
                          <div class="row">
                            <div class="col-md-6">
                              <label for="" class="title control-label">User <span style="color: red;">*</span> </label>
                              <input type="text" class="form-control" name="data_user" id="data_user">
                              <input type="hidden" name="data_Id" id="data_Id" value="">
                            </div>
                            <div class="col-md-6">
                              <label for="" class="title control-label">Role <span style="color: red;">*</span> </label>
                              <input class="form-control" list="datalistRole" id="data_Role" name="data_Role" placeholder="Select All">
                              <datalist id="datalistRole">
                                <?php foreach ($data_loadRoleSearch as $key => $value) {  ?>
                                  <option value="<?php echo @$value['RoleName']; ?>">
                                <?php } ?>
                              </datalist>
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Name <span style="color: red;">*</span> </label>
                              <div class="input-group">
                                <div class="input-group-prepend">
                                  <span class="input-group-text" id="data_title-group">Mr</span>
                                </div>
                                <input type="text" class="form-control  col-lg-4" name="data_name" id="data_name" placeholder="name">
                                <input type="text" class="form-control  col-lg-4" name="data_middleName" id="data_middleName" placeholder="middleName">
                                <input type="text" class="form-control  col-lg-4" name="data_surname" id="data_surname" placeholder="surname">
                              </div>
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Email <span style="color: red;">*</span> </label>
                              <input type="email" class="form-control" name="data_email" id="data_email" value="">
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Password <span style="color: red;">*</span>
                                <span style="color: gray;">(combination of 8 letters and numbers)</span>
                              </label>
                              <input type="password" class="form-control" name="data_password" id="data_password" value="">
                            </div>
                          </div>
                          <div class="row">
                            <div class="col-md-12">
                              <label for="" class="title control-label">Confirm Password <span style="color: red;">*</span> </label>
                              <input type="password" class="form-control" name="data_repassword" id="data_repassword" value="">
                            </div>
                          </div>
                        </div>
                      </div>

                    </div>
                    <div class="modal-footer">
                        <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                        <button class="btn btn-primary" id="data_btn-users-submit" >Confirm</button>
                    </div>
                </form>

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




<link href="<?php echo $path; ?>Assets/Backend/vendor/bootstrap-datepicker/css/bootstrap-datepicker3.min.css" rel="stylesheet" />
<script src="<?php echo $path; ?>Assets/Backend/vendor/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
<script>
  var caseId = '<?php echo @$_GET['Id']; ?>';
  var urlLoadUsers = "LoadUsers.php";
  var urlCreateUsers = "Create.php";
  var urlUpdateUsers = "Update.php";
  var urlDeleteUsers = "Delete.php";

</script>
<link href="<?php echo $path; ?>Assets/Backend/vendor/bootstrap-datepicker/css/bootstrap-datepicker3.min.css" rel="stylesheet" />
<script src="<?php echo $path; ?>Assets/Backend/vendor/bootstrap-datepicker/js/bootstrap-datepicker.min.js"></script>
<link href="<?php echo $path; ?>Assets/Backend/vendor/jquery-ui/jquery-ui.min.css" rel="stylesheet" />
<script src="<?php echo $path; ?>Assets/Backend/vendor/jquery-ui/jquery-ui.min.js"></script>
<script src="<?php echo $path; ?>Assets/Backend/vendor/moment.js"></script>
<script src="<?php echo $path; ?>Scripts/jquery.validate.min.js"></script>
<script src="<?php echo $path; ?>Scripts/pages_v1/users.js?t=<?php echo $date_ticks; ?>"></script>