<?php include "includes/functions.php";
secureSuperAdmin();
    $session_school_token="";
    $current_session="";
    $state_name="";
    $school_number="";
    $school_email="";
    $person_name="";
    $post="";
    $status="";
    $login_as="";
    $register_for="";
    $whatsapp="";
    $school_code="";
    $school_name="";
    $type_of_school="";
    $series_name_header="";
        
if (isset($_GET["getUpdateToken"]) AND !empty($_GET["getUpdateToken"])) {
    $token = base64_decode($_GET["getUpdateToken"]);
    $selectData = mysqli_query($conn,"SELECT c.start_date,e.name as series_name,b.name as state_name,a.*,c.small_session,c.session,c.end_date,a.type_of_school,a.login_as  FROM `school` a,states b,session c,series d,all_series e where a.token='$token' and a.school_state=b.id and c.token=a.lbf_session_token and d.school_token=a.session_token and d.name=e.token");
     if (howMany($selectData) > 0) {
        $getData = fetchAssoc($selectData);
        $session_school_token=$getData['session_token'];
        echo $session_school_token;
        $current_session=$getData['session'];
        $state_name=$getData["state_name"];
        $school_number=$getData['school_contact_num'];
        $school_email=$getData['school_email'];
        $person_name=$getData['person_name'];
        $post=$getData['designation'];
        $status=$getData['status'];
        $login_as=$getData['login_as'];
        $start_date=$getData['start_date'];
        $end_date = $getData['end_date'];
        $register_for=$getData['registered_for'];
        $whatsapp=$getData['whatsapp'];
        $school_code=$getData['code'];
        $school_name=$getData['name'];
        $type_of_school = $getData['type_of_school'];
        $series_name_header = $getData['series_name'];
     }
     if(strtoupper($register_for)=="TEACHER"){
        
         $selectClassStudent = mysqli_query($conn,"select a.*,b.Group_Priority from school_wise_report a,all_teacher_group b where a.school_token='$session_school_token' and a.class_sec=b.group_name and a.login_as='$login_as' and a.login_as=b.login_as order by student_id,class_sec,subject_name,sub_subject,b.Group_Priority");
     }else {
         $selectClassStudent = mysqli_query($conn,"select * from school_wise_report  where school_token='$session_school_token' and login_as='$login_as' order by user_name,class_sec,subject_name,sub_subject");
     }
   $school_token = $session_school_token;
    $class_data = mysqli_query($conn,"SELECT distinct class_sec,order_seq FROM `school_wise_report` WHERE school_token ='$school_token' ORDER by order_seq ASC");
    $class = '';
    $startDate = '';
    $endDate  = '';
    if($_GET){
        $class = array_key_exists('class',$_GET)?$_GET['class']:"";
        $startDate = str_replace('/','-',array_key_exists('startDate',$_GET)?$_GET['startDate']:"");
        $endDate  = str_replace('/','-',array_key_exists('endDate',$_GET)?$_GET['endDate']:"");
    }
}
/* Function to add duration */
function AddTime(Array $durations) 
{
    $total_time    = 0;
    foreach($durations as $duration) {  
        sscanf($duration, "%d:%d:%d", $hours, $minutes, $seconds);
        $total_time += isset($seconds) ? $hours * 3600 + $minutes * 60 + $seconds : $hours * 60 + $minutes;
    }    
    return sprintf('%02d:%02d:%02d', ($total_time/3600),($total_time/60%60), $total_time%60);
} 
?>
<!DOCTYPE html>
<html lang="en">
<head>
  <title>Report OLS</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
  <link rel="stylesheet" href="assets/css/report.css">
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datetimepicker/3.1.3/css/bootstrap-datetimepicker.min.css">
 
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/jquery.bootstrapvalidator/0.5.3/css/bootstrapValidator.min.css">

  
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-3-typeahead/4.0.2/bootstrap3-typeahead.min.js"></script>  

  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/js/bootstrap.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-multiselect/0.9.13/js/bootstrap-multiselect.js"></script>
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-multiselect/0.9.13/css/bootstrap-multiselect.css" />
  
 <style>
    	@media print {
	

		}
		@media print {
		html, body {

	font-size:11px;
		}
		th,td{font-size:11px !important;
border: 1px solid black;}
		#printbtn {
        display :  none;
    }
		}
		.student{
		    text-align:center;
		    font-weight:bold;
		}
		.btn-default {
    border:none;
    background:none;
}
.btn-default:hover {
    color: #333;
    background-color:white;
    border-color:white;
}
.btn-default.active, .btn-default:active, .open>.dropdown-toggle.btn-default {
    color: #333;
    background-color:white !important;
    border-color:white !important;
}
.caret{
    display:none !important;
}
.end{
    text-align:end;
    
}
th,td{font-size:12px;
border: 1px solid black;}
label {
    font-weight: bold;
    font-size: 13px;
}

</style>
</head>
<body>
 <div class="container">
        <br>
        
        <div class="row">
            
            <div class="col-md-12" style="text-align:end;">
                
                <button id ="printbtn" onclick="window.print()" class="btn btn-primary" style="border-radius:50px;">Save As PDF</button>
            </div>
        </div>
    </div>
<div class="jumbotron text-center" style="background:none;">
  <h1 style="font-size:36px;">LBF Publication Pvt.Ltd</h1>
  <?php if (strtoupper($login_as) == "HTT"){ ?>
        <p>Hybrid Teacher Training(<?=strtoupper($login_as)?>) Subscription Utiization Report</p>  
  <?php }else if (strtoupper($login_as) == "OTT") { ?>
    <p>Online Teacher Training(<?=strtoupper($login_as)?>) Subscription Utiization Report</p>
  <?php }else {?>
   <p>Online Learning System(<?=strtoupper($login_as)?>) Subscription Utiization Report</p>
   <?php }?>
 <div class="container-fluid">
    <div class="row">
        <div class="col-md-2"></div>
        <div class="col-md-8 col-12" >
             <label class="f-15">Based On:</label>
             &nbsp;&nbsp;<?=$series_name_header?>
   <br>
   <label class="f-15">User:</label>
   <?=strtoupper($login_as)?>&nbsp;&nbsp;<?=strtoupper($register_for)?>
   <br>
        </div>
        <div class="col-md-2"></div>
    </div>
</div>
</div>
<div class="container">
    
    <div class="row">
        
            
           
    <div class="form-group col-md-4 col-xs-12">
      <label  class="f-15">Session:</label>
       &nbsp;&nbsp;<?=$current_session?>
    </div>
    <div class="col-md-4"></div>
    
    <div class="col-md-4"></div>
    </div>
     <div class="row">
        
            
           
    <div class="form-group col-md-4 col-xs-12">
      <label  class="f-15">Valid Upto:</label>
      &nbsp;&nbsp;<?php echo date("d-m-Y", strtotime($end_date))?>
       
    </div>
    <div class="col-md-4"></div>
    
    <div class="col-md-4 end">
          <label  class="f-15">Date of Printing:
          &nbsp;&nbsp;<?=date("d-m-Y")?></label>
    </div>
   
    </div>
    <div class="row">
    <div class="form-group col-md-3 col-12 ">
      <label  class="f-15">W.e.f:</label>
      &nbsp;&nbsp; <?php echo date("d-m-Y", strtotime($start_date))?>
   
    </div>
  <div class="form-group col-md-6 col-12 ">
      <label  class="f-15"></label>

  
    </div>
    
  
 
        </div>
        <br>
       
         <div class="row">
             <div class="col-md-12">
        <form class="form-inline" action="" method="GET">
           
     
        <div class="col-md-3 form-group">
         
                <select name="class" id="class" class="form-control" style="width:100% !important;">
                  <?php  
                    echo '<option value=""'.(('' == $class)? "Selected":"").'>ALL</option>';
                  
                    while($getClassSection = fetch($class_data)){
                        echo '<option value="'.$getClassSection['class_sec'].'"'.(($getClassSection['class_sec'] == $class)? "Selected":"").'>'.$getClassSection['class_sec'].'</option>';
                    }
                  ?>
                </select>    
            
            </div>
             <div class="col-md-6 col-xs-6">
                 <div class="form-group">
        <label for="startDate">From Date:&nbsp;&nbsp;</label>
        <input class="border-date" id="startDate" name="startDate" type="date" class="form-control" value="<?php echo array_key_exists('startDate',$_GET)?$_GET['startDate']:""; ?>" />
       
       
       &nbsp;&nbsp; <label for="endDate">To Date: &nbsp;&nbsp;</label>
        
        <input  class="border-date" id="endDate" name="endDate" type="date" class="form-control" value="<?php echo array_key_exists('endDate',$_GET)?$_GET['endDate']:""; ?>"/>
        <input type="hidden" name="getUpdateToken" id="getUpdateToken" value="<?php echo $_GET['getUpdateToken'];?>"/>
       </div>
        </div>
     <div class="col-md-3 "style="text-align:center;">
        <input class="btn btn-primary" style="border-radius:50px;" type="submit">
                 
    </div>
    </div>
</form> 
     </div>   
        <div class="row">
    <div class="form-group col-md-12 col-12 ">
      <label  class="f-15">Buyer References</label>&nbsp;&nbsp;School /&nbsp;&nbsp;<?=$school_name?><br>
    (School/Institute/NGO/State Govt./Central Govt.)
    </div>
        </div>
        <div class="row">
    <div class="form-group col-md-4 col-12 mt-4">
      <label class="f-15">Destination Code:</label>
    </div>
  <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Name :</label>
    
    </div>
    
<div class="form-group col-md-4 col-12 mt-4 end">
      <label  class="f-15">Zone Code :</label>
    </div>
    <div class="form-group col-md-4 col-12 mt-4 ">
      <label  class="f-15">Name :</label>
    </div>
   <div class="form-group col-md-4 col-12 mt-4 ">
      <label  class="f-15">State Name :</label>
        &nbsp;&nbsp;<?=$state_name?>
    </div>
   <div class="form-group col-md-4 col-12 mt-4 end ">
      <label  class="f-15">State Code :</label>
    </div>
 
        </div>
         <div class="row">
    <div class="form-group col-md-4 col-12 mt-4">
      <label class="f-15">Contact Person Name1:</label>&nbsp;&nbsp;<?=$person_name?>
    </div>
  <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Post :</label>&nbsp;&nbsp;
   <?=$post?>
    </div>
    
<div class="form-group col-md-4 col-12 mt-4 end">
      <label  class="f-15">Mobile No. :</label>
      </label>&nbsp;&nbsp;<?php echo $school_number;?>
    </div>
    <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Whatsapp No. :</label>&nbsp;&nbsp;<?=$whatsapp?>
    </div>
     <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Email :</label>&nbsp;&nbsp;<?=$school_email?>
    </div>
 
        </div>
          <div class="row">
    <div class="form-group col-md-4 col-12 mt-4">
      <label class="f-15">Contact Person Name2:</label>&nbsp;&nbsp;<?=$person_name?>
    </div>
  <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Post :</label>&nbsp;&nbsp;
   <?=$post?>
    </div>
    
<div class="form-group col-md-4 col-12 mt-4 end">
      <label  class="f-15">Mobile No. :</label></label>&nbsp;&nbsp;<?php echo $school_number;?>
    </div>
    <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Whatsapp No. :</label>&nbsp;&nbsp;<?=$whatsapp?>
    </div>
     <div class="form-group col-md-4 col-12 mt-4">
      <label  class="f-15">Email :</label>&nbsp;&nbsp;<?=$school_email?>
    </div>
 
        </div>
          <div class="row">
    
  <div class="form-group col-md-4 col-12 mt-3">
      <?php
      $total_price=0;
      if(isset($_GET['class'])){
          $class_name = $_GET['class'];
          $class_datanew = mysqli_query($conn,"SELECT distinct a.class_sec,order_seq,b.Book FROM school_wise_report a,noOfBooksList b WHERE school_token ='$school_token' and a.class_sec=b.class_sec and a.class_sec='$class_name' ORDER by order_seq ASC");
      }else {
         $class_datanew = mysqli_query($conn,"SELECT distinct a.class_sec,order_seq,b.Book FROM school_wise_report a,noOfBooksList b WHERE school_token ='$school_token' and a.class_sec=b.class_sec ORDER by order_seq ASC"); 
      }
        while($fetchBook = mysqli_fetch_array($class_datanew)) {
           $total_price += $fetchBook['Book'];
        }
      ?>
      <label  class="f-15">Susbcription no. of Books :</label> <?php echo $total_price?>
      
    </div>
    
     <div class="form-group col-md-4 col-12 mt-3">
      <label  class="f-15"> No. of Books Provided:</label>&nbsp;&nbsp;
    </div>
    
    <div class="form-group col-md-4 col-12 mt-3">
        <?php
          $sql = "SELECT COUNT(id) as TotalUsers FROM `ohtt_user` WHERE school_token = '".$school_token."'";
         $result = mysqli_query($conn,$sql);
         while($fetchCount = mysqli_fetch_array($result))
           $totalUssers =$fetchCount['TotalUsers']; 
         
        ?>
      <label  class="f-15"> No. of User :</label>&nbsp;&nbsp;<?php echo $totalUssers ?>
    </div>
 
        </div>
    </div>
     
<div class="" style="padding: 15px;">
                <table class="table table-bordered">
                    <thead>
                        <tr>
                            <th rowspan="3">S.No</th>
                            <th rowspan="3">Subscription Id No.</th>
                            <th rowspan="3">User Name</th>
                            <th colspan="2"> Login Date & Time</th>
                            <th colspan="2"> Registered Mobile</th>
                            <th colspan="7">Subscription Detail</th>
                        </tr>
                        <tr>
                            <th rowspan="3">First Time</th>
                            <th rowspan="3">Last Viewing Date</th>
                            <th rowspan="3">Mobile 1</th>
                            <th rowspan="3">Mobile 2</th>
                            <th rowspan="3"> Subject</th>
                            <th rowspan="3">Total Duration</th>
                            <th colspan="4">Utilized Duration</th>
                        </tr>
                        <tr>
                            <th>Mobile 1</th>
                            <th>Mobile 2</th>
                            <th> Total</th>
                            <th>%</th>
                        </tr>
                    </thead>
                    <?php
                    $grand_total_duration='00:00:00';
                        $grand_total_duration_mob1='00:00:00';
                        $grand_total_duration_mob2='00:00:00';
                        $grand_total_duration_complete='00:00:00';
                    $sql = "SELECT DISTINCT  school_token,student_token,student_id,user_name,max(last_login_date) as last_login_date,mobile_no_1,mobile_no_2,
                    min(from_date_time) as from_date_time,class_sec FROM school_wise_report WHERE school_token ='$session_school_token' ".($class == ""?"":"and class_sec = '".$class."'")."
                    and filter_date BETWEEN '$startDate' and '$endDate' group by  school_token,student_token,student_id,user_name,mobile_no_1,mobile_no_2,class_sec order by user_name";
                    $result = $conn->query($sql);

                    if ($result->num_rows > 0) {
                        $count = 1;
                        while ($row = $result->fetch_assoc()) {
                            $orgDate = $row['from_date_time'];  
                            $newDate = date("d-m-Y H:i:s", strtotime($orgDate));  
                            
                            $orgDate_last = $row['last_login_date'];  
                            $last_login_time = date("d-m-Y H:i:s", strtotime($orgDate_last));
                            echo '<tbody>
                            <tr>
                                <td rowspan="6">' . $count . '</td>
                                <td rowspan="6">' . $row['student_id'] . '</td>
                                <td rowspan="6">' . $row['user_name'] . '</td>
                                <td rowspan="6">' . $newDate . '</td>
                                
                                <td rowspan="6">' . $last_login_time . '</td>
                                <td rowspan="6">' . $row['mobile_no_1'] . '</td>
                                <td rowspan="6">' . $row['mobile_no_2'] . '
                                </td>
                                <td>
                                <table class="table table-bordered">
                                    <tbody>';
                            $token = $row['student_token'];
                            $row_duration = array();
                            $row_array_duration=array();
                            $row_array_duration_mob1=array();
                            $row_array_duration_mob2=array();
                            if (strtoupper($register_for)=="TEACHER"){
                              $sql_duration = mysqli_query($conn,"  select sec_to_time(sum(time_to_sec(b.duration_sec))) as total_duration,a.subject_booktype_name,a.mobile_no1_duration,a.mobile_no2_duration  from school_wise_report a,lesson_master b,lesson_series_master c where a.student_token='$token' and a.class_cmn_token=c.group_cmn_tkn and a.series_cmn_token=c.series_tkn_cmn and a.subject_cmn_token = c.subject_tkn_cmn and a.sub_subject_cmn_token = c.sub_subject_tkn_cmn and c.token=b.series_mstr_token Group BY a.class_cmn_token, a.series_cmn_token, a.subject_cmn_token, a.sub_subject_cmn_token,a.subject_booktype_name,a.mobile_no1_duration,a.mobile_no2_duration");
                            }else {
                            $sql_duration = mysqli_query($conn,"select sec_to_time(sum(time_to_sec(b.duration_sec))) as total_duration,a.subject_booktype_name,a.mobile_no1_duration,a.mobile_no2_duration from school_wise_report a,lesson_master b,lesson_series_master c where a.student_token='$token' and a.class_cmn_token=c.class_tkn_cmn and a.series_cmn_token=c.series_tkn_cmn and a.subject_cmn_token = c.subject_tkn_cmn and a.sub_subject_cmn_token = c.sub_subject_tkn_cmn and c.token=b.series_mstr_token Group BY a.class_cmn_token, a.series_cmn_token, a.subject_cmn_token, a.sub_subject_cmn_token,a.subject_booktype_name,a.mobile_no1_duration,a.mobile_no2_duration");
                            }
                            while($row = mysqli_fetch_array($sql_duration)) {
                                $row_duration[] = $row;
                                 echo '<tr><td style="width:150px;">' . $row["subject_booktype_name"] . '</td></tr>';
                            }
                                                           
                            $count++;
                            $ttd = 0;
                            echo '</tbody>
                                    </table>
                                </td><td>
                                <table class="table table-bordered">
                                    <tbody>';
                                    
                                foreach ($row_duration as $row_d) {
                                    echo '<tr><td>'.$row_d["total_duration"].'</td></tr>';
                                    $row_array_duration[] = $row_d["total_duration"];
                                }
                                echo '
                                        </tbody>
                                    </table>
                                </td>
                                <td>
                                    <table class="table table-bordered">
                                        <tbody>';
                                foreach ($row_duration as $row_mob1) {
                                    echo '<tr><td>'.$row_mob1["mobile_no1_duration"].'</td></tr>';
                                    $row_array_duration_mob1[] = $row_mob1["mobile_no1_duration"];
                                }
                                echo'</tbody>
                                    </table>
                                </td>
                                <td>
                                    <table class="table table-bordered">
                                        <tbody>';
                                foreach ($row_duration as $row_mob2) {
                                    echo '<tr><td>'.$row_mob2["mobile_no2_duration"].'</td></tr>';
                                    $row_array_duration_mob2[] = $row_mob2["mobile_no2_duration"];
                                }
                                echo'
                                        </tbody>
                                    </table>
                                </td>
                                <td>
                                    <table class="table table-bordered">
                                        <tbody>';
                                foreach ($row_duration as $row_add_mob) {
                                    echo '<tr><td>'.AddTime(array($row_add_mob["mobile_no1_duration"],$row_add_mob["mobile_no2_duration"])).'</td></tr>';
                                }
                                $complete_mob_duration=array(AddTime($row_array_duration_mob1),AddTime($row_array_duration_mob2));
                                echo'</tbody>
                                    </table>
                                </td>
                                <td>
                                <table class="table table-bordered">
                                    <tbody>';
                                foreach ($row_duration as $row_mob_per) {
                                    $add_mob_duration=AddTime(array($row_mob_per["mobile_no1_duration"],$row_mob_per["mobile_no2_duration"]));
                                    $total_durat_percentage=$row_mob_per["total_duration"];
                                    echo '<tr><td>100%</td></tr>';
                                } 
                                $grand_total_duration = AddTime(array($grand_total_duration,AddTime($row_array_duration)));
                                $grand_total_duration_mob1 = AddTime(array($grand_total_duration_mob1,AddTime($row_array_duration_mob1)));
                                $grand_total_duration_mob2 = AddTime(array($grand_total_duration_mob2,AddTime($row_array_duration_mob2)));
                                $grand_total_duration_complete = AddTime(array($grand_total_duration_complete,AddTime($complete_mob_duration)));
                                        echo '</tbody>
                                    </table>
                                </td>
                            </tr>
                            <tr>
                                <td class="student">User Total</td>
                                <td>'.AddTime($row_array_duration).'</td>
                                <td>'.AddTime($row_array_duration_mob1).'</td>
                                <td>'.AddTime($row_array_duration_mob2).'</td>
                                <td>'.AddTime($complete_mob_duration).'</td>
                                <td>100%</td>                                
                            </tr>
                        </tbody>';
                        }
                    } 
                    ?>
                            <tr>
                                <td colspan=7></td>
                              <td class="student">Grand Total </td>
                              <td> <?php echo $grand_total_duration; ?></td>
                              <td> <?php echo $grand_total_duration_mob1; ?></td>
                              <td> <?php echo $grand_total_duration_mob2; ?></td>
                              <td> <?php echo $grand_total_duration_complete; ?></td>
                               <td> <?php echo "%" ?></td>
                            </tr>
                             

                </table>
            </div>


</body>
<script>
    var bindDateRangeValidation = function (f, s, e) {
    if(!(f instanceof jQuery)){
			console.log("Not passing a jQuery object");
    }
  
    var jqForm = f,
        startDateId = s,
        endDateId = e;
  
    var checkDateRange = function (startDate, endDate) {
        var isValid = (startDate != "" && endDate != "") ? startDate <= endDate : true;
        return isValid;
    }

    var bindValidator = function () {
        var bstpValidate = jqForm.data('bootstrapValidator');
        var validateFields = {
            startDate: {
                validators: {
                    notEmpty: { message: 'This field is required.' },
                    callback: {
                        message: 'Start Date must less than or equal to End Date.',
                        callback: function (startDate, validator, $field) {
                            return checkDateRange(startDate, $('#' + endDateId).val())
                        }
                    }
                }
            },
            endDate: {
                validators: {
                    notEmpty: { message: 'This field is required.' },
                    callback: {
                        message: 'End Date must greater than or equal to Start Date.',
                        callback: function (endDate, validator, $field) {
                            return checkDateRange($('#' + startDateId).val(), endDate);
                        }
                    }
                }
            },
          	customize: {
                validators: {
                    customize: { message: 'customize.' }
                }
            }
        }
        if (!bstpValidate) {
            jqForm.bootstrapValidator({
                excluded: [':disabled'], 
            })
        }
      
        jqForm.bootstrapValidator('addField', startDateId, validateFields.startDate);
        jqForm.bootstrapValidator('addField', endDateId, validateFields.endDate);
      
    };

    var hookValidatorEvt = function () {
        var dateBlur = function (e, bundleDateId, action) {
            jqForm.bootstrapValidator('revalidateField', e.target.id);
        }

        $('#' + startDateId).on("dp.change dp.update blur", function (e) {
            $('#' + endDateId).data("DateTimePicker").setMinDate(e.date);
            dateBlur(e, endDateId);
        });

        $('#' + endDateId).on("dp.change dp.update blur", function (e) {
            $('#' + startDateId).data("DateTimePicker").setMaxDate(e.date);
            dateBlur(e, startDateId);
        });
    }

    bindValidator();
    hookValidatorEvt();
};


$(function () {
    var sd = new Date(), ed = new Date();
  
    $('#startDate').datetimepicker({ 
      pickTime: false, 
      format: "YYYY/MM/DD", 
      defaultDate: sd, 
      maxDate: ed 
    });
  
    $('#endDate').datetimepicker({ 
      pickTime: false, 
      format: "DD/MM/YYYY", 
      defaultDate: ed, 
      minDate: sd 
    });

    //passing 1.jquery form object, 2.start date dom Id, 3.end date dom Id
    bindDateRangeValidation($("#form"), 'startDate', 'endDate');
});
   
</script>
</html>
