<?php


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


$arrayName1 = array(
  'CaseId' => @$_GET['Id'],
  'PageNumber' => @$PageNumber,
  'page' => 0,
  'OrderBy' => 'CaseId',
  'OrderDirection' => 'ASC',
  'PageSize' => @$PageSize
);

$data_loadIpmodules = $ipmodule_db->IpmodulesCase($arrayName1);
$data_loadIpmodules = $data_loadIpmodules['Data'][0];

$arrayName2 = array(
  'CaseId' => @$_GET['Id'],
  'PageNumber' => @$PageNumber,
  'page' => 0,
  'OrderBy' => 'CaseId',
  'OrderDirection' => 'ASC',
  'PageSize' => @$PageSize
);

$data_loaddNamesmas= $ipmodule_db->LoadNamesmas($arrayName2);
$data_loaddNamesmas = $data_loaddNamesmas['Data'];

$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_loadNamesSearch = $names_db->LoadNamestypeSearch();
$data_loadNamesSearch = $data_loadNamesSearch['Data'];

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

 ?>


<link rel="stylesheet" href="Checkbox.css">


<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> Event
          </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">Event Name : </label>
            </div>
            <div class="col-sm-10">
              <input type="search" id="EventName" class="form-control " name="EventName" value="<?php echo @$_GET['EventName']; ?>" >
            </div>
          </div>
        </div>
      </div>
    </div>

  </div>


  <div class="form-group row mt-3">
    <div class="col-sm-12 text-right">

        <a href="../Events/" class="btn btn-secondary">
          <i class="fa fa-refresh"></i> Clear</a>
        <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 justify-content-between">
        <div class="col-sm-6 ">
          <a class="btn btn-success" href="javascript:;" data-toggle="modal" data-target="#eventsModal"><i class="fas fa-plus-square"></i> Add</a>
          <a class="btn btn-primary" href="#" data-toggle="modal" data-target="#columModal"><i class="fa fa-cog"></i> Manage Columns</a>
        </div>
        <div class="col-sm-2 text-right">
          <a class="btn btn-primary" href="javascript:;" onclick="ExportExcel()"><i class="fa fa-external-link"></i> Export File</a>

        </div>
    </div>
    <p>
    </p>
    <div id="events_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 ">
            <thead>
            </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="EventsId" />
                    <input type="hidden" class="orderDirection" value="DESC" />
                    <input type="hidden" class="params" value="EventName=<?php echo @$_GET['EventName'];?>" />
                    แสดงรายการ <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 fade-->
    <div class="modal show" id="eventsModal" 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 Event</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <form  id="role-form" method="post">
                    <div class="modal-body">
                      <div class="form-group col labelPadRight">
                        <div class="form-group row col">
                          <label class="col-md-3 col-form-label form-control-sm sbold">
                            Event Name <span style="color: red;">*</span> </label>
                            <div class="col-md-9">
                              <input type="text" class="form-control  form-control-sm" class="form-control  form-control-sm" id="eventsName" name="eventsName">
                            </div>
                        </div>
                        <div class="form-group row col">
                          <div class="col-md-3"></div>
                          <div class="col-md-9">
                            <label class="switch">
                              <input type="checkbox" id="eventsDeadline" name="eventsDeadline" >
                              <span class="slider round"></span>
                            </label>
                            <span style="color: darkgray;">no deadline</span>

                            <div class="row" style="margin-left: 24px;">
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="Trademark" name="Trademark" value="" />
                                  <label for="Trademark">
                                    <span style="background-color: rgb(0, 102, 123);border-color: rgb(0, 102, 123);"></span>
                                    Trademark
                                  </label>
                                </div>
                              </div>
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="Search" name="Search" value="" />
                                  <label for="Search">
                                    <span style="background-color: rgb(6, 50, 68); border-color: rgb(6, 50, 68); color: rgb(255, 255, 255);"></span>
                                    Search
                                  </label>
                                </div>
                              </div>
                            </div>

                            <div class="row" style="margin-left: 24px;">
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="General" name="General" value="" />
                                  <label for="General">
                                    <span style="background-color: rgb(13, 42, 59); border-color: rgb(13, 42, 59); color: rgb(255, 255, 255);"></span>
                                    General
                                  </label>
                                </div>
                              </div>
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="Patent" name="Patent" value="" />
                                  <label for="Patent">
                                    <span style="background-color: rgb(132, 65, 94); border-color: rgb(132, 65, 94); color: rgb(255, 255, 255);"></span>
                                    Patent
                                  </label>
                                </div>
                              </div>
                            </div>

                            <div class="row" style="margin-left: 24px;">
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="Design" name="Design" value="" />
                                  <label for="Design">
                                    <span style="background-color: rgb(170, 83, 108); border-color: rgb(170, 83, 108); color: rgb(255, 255, 255);"></span>
                                    Design
                                  </label>
                                </div>

                              </div>
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="Enquiry" name="Enquiry" value="" />
                                  <label for="Enquiry">
                                    <span style="background-color: rgb(232, 105, 122); border-color: rgb(232, 105, 122); color: rgb(255, 255, 255);"></span>
                                    Enquiry
                                  </label>
                                </div>
                              </div>
                            </div>

                            <div class="row" style="margin-left: 24px;">
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="UtilityModel" name="UtilityModel" value="" />
                                  <label for="UtilityModel">
                                    <span style="background-color: rgb(236, 184, 145); border-color: rgb(236, 184, 145); color: rgb(255, 255, 255);"></span>
                                    Utility Model
                                  </label>
                                </div>
                              </div>
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="CopyRight" name="CopyRight" value="" />
                                  <label for="CopyRight">
                                    <span style="background-color: rgb(117, 172, 201); border-color: rgb(117, 172, 201); color: rgb(255, 255, 255);"></span>
                                    Copy Right
                                  </label>
                                </div>
                              </div>
                            </div>

                            <div class="row" style="margin-left: 24px;">
                              <div class="col-md-6">
                                <div class="checkbox-wrapper-24">
                                  <input type="checkbox" id="Enforcement" name="Enforcement" value="" />
                                  <label for="Enforcement">
                                    <span style="background-color: rgb(117, 172, 201); border-color: rgb(117, 172, 201); color: rgb(255, 255, 255);"></span>
                                    Enforcement
                                  </label>
                                </div>
                              </div>
                            </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="event-submit" >Confirm</button>
                    </div>
                </form>

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

    <?php
    $colum = array("Event Name","Has Deadline","Status","LastUpdateBy","LastUpdateDateTime","CreateBy","CreateDateTime");
    $columID = array("EventsName","HasDeadLine","StatusActive","LastUpdateBy","LastUpdateDateTime","CreateBy","CreateDateTime");
     ?>
    <!-- Modal Customer  -->
    <div class="modal fade show" id="columModal" tabindex="-1" role="dialog" aria-labelledby="columModalLabel" aria-hidden="true">
        <div class="modal-dialog modal-xl" role="document">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="columModalLabel">Manage Columns</h5>
                    <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                        <span aria-hidden="true">&times;</span>
                    </button>
                </div>
                <div class="modal-body">

                    <div id="colum_pagination">
                      <div class="row mb-3">
                        <?php for ($i=0; $i < count($colum); $i++) { ?>
                          <div class="col-6 col-md-3">
                            <div class="form-check form-check-inline">
                              <input class="form-check-input" type="checkbox" id="<?php echo @$columID[$i]; ?>" name="<?php echo @$columID[$i]; ?>"
                              onclick="checkColAndLoad()"
                              <?php echo ($i==0 || $i==1 || $i==2 || $i==10 || $i==20 || $i==21)?"checked":""; ?>>
                              <label class="form-check-label" for="<?php echo @$columID[$i]; ?>"><?php echo @$colum[$i]; ?></label>
                            </div>
                          </div>
                        <?php } ?>
                      </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                    <!--<button type="button" class="btn btn-primary">Save changes</button>-->
                </div>
            </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 urlLoadEventsList = "LoadEventsList.php";
  var urlCreateEvents = "Create.php";
  var urlUpdateEvents = "Update.php";
  var urlDeleteEvents = "Delete.php";
  function ExportExcel() {
    var parent = $("#events_pagination");
    var tableTbody = parent.find("table>tbody");
    var page = parent.find(".page").val();
    var pageSize = parent.find(".page-size").val();
    var orderBy = parent.find('.orderBy').val();
    var orderDirection = parent.find('.orderDirection').val();
    var paramsHidden = parent.find(".params").val();
    var $loader = parent.find('.table-loader');
    var params = {
        title: exportsTable,
    };
    if (paramsHidden != "") {
        params = Object.assign({}, params, JSON.parse('{"' + decodeURI(paramsHidden).replace(/"/g, '\\"').replace(/&/g, '","').replace(/=/g, '":"') + '"}'));
    }

      $.ajax({
        url: 'ReportExcel.php',
        data: params,
        type: 'POST',
        success: function (resp) {
          console.log(resp);
          var res = JSON.parse(resp);
          console.log(res);
          if(res['mes'] == 'success'){
            window.open("report_excel/EventReport.xlsx", "new");
          }
        }
      });

  }

</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/events.js?t=<?php echo $date_ticks; ?>"></script>