<?php
include("common/connection.php");
//login_check();
$_REQUEST['d'];
//$Lead_Req_Id=$_REQUEST['Lid'];
$user_type_sql="select User_Type from user_master where User_Name='".$_SESSION['user']."'";
$user_type_query=mysqli_query($con,$user_type_sql);
$user_type=mysqli_fetch_array($user_type_query);

/*$lead_basic_sql="select * from lead_master where Lead_ID='".$Lead_Req_Id."'";
$lead_basic_query=mysqli_query($con,$lead_basic_sql);
$lead_details=mysqli_fetch_array($lead_basic_query);*/
?>

<!doctype html>
<html class="no-js" lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title>Add Roster Plan| Buurtzorg</title>
    <?php include("headerlink.php"); ?> 
     <link rel="stylesheet" href="css/form/all-type-forms.css">
    <!-- x-editor CSS
		============================================ -->
    <link rel="stylesheet" href="css/editor/select2.css">
    <link rel="stylesheet" href="css/editor/datetimepicker.css">
    <link rel="stylesheet" href="css/editor/bootstrap-editable.css">
    <link rel="stylesheet" href="css/editor/x-editor-style.css">

    
	<style>
	
	.table_head_class{
		background-color:#337ab7;
		height:30px;
		line-height:30px;
		text-align:center;
		color:#FFF;
		font-size:15px;
	}
	
		.table_body_class{
		background-color:#f7f7f6;
		height:auto;
		padding:5px 2%
	}
	
	
	</style>
	
	
	
	
    <script>
	function unlock_form() {
	 
	$('#edit_c_form  input'). prop("disabled", false);
	//$('#not_editable  input'). prop("disabled", true);
	$('#edit_c_form  textarea'). prop("disabled", false);
	$('#edit_c_form  select'). prop("disabled", false);
	$('#update_btn').show();
	$('#edit_btn_1').hide();
	
 
	}
	</script>
    
    <script>
	function call_status(per) {
	 
	// alert(per);
	if(per=='Call Later') {
	$('#call_later').show();
	$('#call_later_time').show();
	
	} 	
	else{
	
	  $('#call_later').hide();
	  $('#call_later_time').hide();
	}
 
	}
	
 
	</script> 
    
    <script>
function isNumberKey(evt) 
{
var charCode = (evt.which) ? evt.which : event.keyCode; 
if (charCode != 46 && charCode > 31 && (charCode < 48 || charCode > 57)) 
{
return false;
} 
else 
{
return true;
} 
} 

</script>
    
    
    
      
</head>
   <?php
								  if(isset($_REQUEST['update_status']))
								  {
								  $no_days=1;
								  $dt=date('Y-m-d',strtotime($_REQUEST['d']));
								  
								$checktna=mysqli_fetch_array(mysqli_query($con,"select * from roster_master where Treatment_Service_Date='".date('Y-m-d',strtotime("-".$no_days." days", strtotime($dt)))."' and  TNA_Name='".$_REQUEST['servicetna']."'")); 
								 
								$date_time=$checktna['Treatment_Service_Date'].' '.$checktna['Duty_Hour_From'];
								$date_time2=$checktna['To_Time_Date'].' '. $checktna['Duty_Hour_To'];
								
								 
$date = new DateTime($date_time);
$date2 = new DateTime($date_time2);

echo $diff = $date2->getTimestamp() - $date->getTimestamp();
								 
								 if($diff<86400)
								 {
							$Roster="insert into  roster_master(Treatment_Service_Date,Duty_Hour_From,Duty_Hour_To,TNA_Name,Patient_Id,To_Time_Date)values('".date('Y-m-d',strtotime($_REQUEST['d']))."','".$_REQUEST['DutyHour']."','".$_REQUEST['dutyto']."','".$_REQUEST['servicetna']."','".$_REQUEST['Patient']."','".date('Y-m-d',strtotime($_REQUEST['doc_visit_date']))."')";
								$update_lead_query=mysqli_query($con,$Roster);
								  $msg=1;

								  }
								  
								  else
								{
								?>
								<script>
								alert('TNA complete 24hours');
								</script>
                                <?php
								}
								  }
								   /*$lead_basic_sql="select * from lead_master where Lead_ID='".$Lead_Req_Id."'";
                                   $lead_basic_query=mysqli_query($con,$lead_basic_sql);
                                   $lead_details=mysqli_fetch_array($lead_basic_query);*/
								  
								 
								  ?>                                         
                                              
                                
<body>
    <!--[if lt IE 8]>
		<p class="browserupgrade">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>
	<![endif]-->
    <!-- Start Left menu area -->
    
    
    
    <?php //include("left-menu.php"); ?>
    
    
    
    <!-- End Left menu area -->
    <!-- Start Welcome area -->
    <div class="all-content-wrapper">
        
        
       <?php //include("header-menu.php"); ?> 
        
       
                                        	
        <!-- Static Table Start -->
        <div class="static-table-area">
        
       
        
        
        
            <div class="container-fluid">
                <div class="row">
                    
                    <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12" >
                        <div class="sparkline9-list analysis-progrebar-ctn" style="background-color:#FFFFFF">
                            <div class="sparkline9-hd">
                                <div class="main-sparkline9-hd">
                                    <h1 style="margin-bottom:15px">Roster Plan</h1>
                                   
                                    
                                    
                                       <div class="row" style="padding:0; background-color:#FFFFFF; ">

                                  <form method="post" action="" id="edit_lead">
                                      <!--<input id="hidden_call_box" name="call_status" value="" style="width:100%" type="hidden">-->
                                            
                                        <div class="col-sm-12" id="call_later_div" style="padding:25px 0px;">
                                   
                                        <div class="form-group col-xs-4"><label>Duty Hour From</label>
                                            <select id="DutyHour" name="DutyHour" class="form-control" style=" width:100%;" required>
                                            
                                            <option value="">Select Duty Hour From</option>
                                            <?php
											$SqlAssLoc="select * from  roster_time_master";
											$RsAssLoc=mysqli_query($con,$SqlAssLoc);
											if(mysqli_num_rows($RsAssLoc)>0)
											{
											while($RowLoc=mysqli_fetch_array($RsAssLoc))
												{
											?>
                                            <option value="<?php echo $RowLoc['Start']; ?>"><?php echo date('h.i a',strtotime($RowLoc['Start'])); ?></option>
                                            <?php
												}
											}
											?>
                                           
                                            
                                            
                                            </select>
                                                   </div>
												   
												   
											<div class="form-group col-xs-4"><label>Duty Hour to</label>
                                            <select id="dutyto" name="dutyto" class="form-control" style=" width:100%;" required>
                                            
                                            <option value="">Select Duty Hour to</option>
                                            <?php
											$SqlAssLoc="select * from  roster_time_master";
											$RsAssLoc=mysqli_query($con,$SqlAssLoc);
											if(mysqli_num_rows($RsAssLoc)>0)
											{
											while($RowLoc=mysqli_fetch_array($RsAssLoc))
												{
											?>
                                            <option value="<?php echo $RowLoc['Start']; ?>"><?php echo date('h.i a',strtotime($RowLoc['Start'])); ?></option>
                                            <?php
												}
											}
											?>
                                           
                                            
                                            
                                            </select>
                                                   </div>	
                                                   
                                                   <div class="col-xs-4 form_maindiv"> 
    <label>To Time Date</label><span style="color:#FF0000; font-size:12px; padding-top:0px;">*</span>
     <input name="doc_visit_date" id="finish12" type="text" style="border:0px; border: 1px solid rgb(204, 204, 204); background-color:#ebe7e7; width:100%; height:40px; padding-left:10px;" placeholder="To Time Date" class="form-control txtbox_div" data-rule-required="true" data-msg-required="Please Select Visit date" onFocus="ActiveColour1('finish12')" autocomplete="off">
    </div>   
												   
                                                   
                                        <div class="form-group col-xs-5"><label>TNA NAME</label>
                                            <!--<input name="service" type="text" class="form-control" id="service" placeholder="Service Name" autocomplete="off" value="<?php echo $lead_details['Course_Name']; ?>" >-->
											
											<select name="servicetna" class="form-control" id="servicetna" required>
                                            
                                               <option value="">Select TNA</option>
                                             <?php
											   
											   $Sql_tna="select * from employee_master where Designation='TNA'";
                                               $Sql_tna_query= mysqli_query($con,$Sql_tna);
											   if(mysqli_num_rows($Sql_tna_query)>0)
											   {
                                               while($Rowtna=mysqli_fetch_array($Sql_tna_query))
											   		{
													$TnaName=$Rowtna['First_Name']." ".$Rowtna['Last_Name'];
											 ?>
                                              <option value="<?php echo $TnaName; ?>"><?php echo $TnaName; ?></option>
                                                <?php
													}
												}
												?>
                                             </select>
											
											
											
											
                                                   </div>
												   
												   
												  
												   
												  
												   
												   
												   
												   
												   
                                      
                                        
                                            
                                      
                                        
                                        <?php
                                        
										?>
                                         
												    <div class="form-group col-xs-5"><label>Patient Name</label>
                                            <!--<input name="service" type="text" class="form-control" id="service" placeholder="Service Name" autocomplete="off" value="<?php echo $lead_details['Course_Name']; ?>" >-->
											
											<select name="Patient" class="form-control" id="Patient" required>
                                            
                                               <option value="">Select Patient</option>
                                             <?php
											   
											    $edit_tna="select * from patient_master";
												$edit_tna_query=mysqli_query($con,$edit_tna);
												//$edit_tna_fetch=mysqli_fetch_array($edit_tna_query);
												//$edit_tna_fetch['Patient_Id'];
											   if(mysqli_num_rows($edit_tna_query)>0)
											   {
                                               while($Rowpatient=mysqli_fetch_array($edit_tna_query))
											   		{
													//$TnaName=$RowLoc['First_Name']." ".$RowLoc['Last_Name'];
											 ?>
                                              <option value="<?php echo $Rowpatient['Patient_Id']; ?>"><?php echo $Rowpatient['Patient_Name']; ?></option>
                                                <?php
													}
												}
												?>
                                             </select>
											
											
											
											
                                                   </div>
                                              
                                          </div>
								   <?php
											   
											 /*  $Sql_tna="select * from employee_master where Designation='TNA'";
                                               $Sql_tna_query= mysqli_query($con,$Sql_tna);
											   if(mysqli_num_rows($Sql_tna_query)>0)
											   {
                                               while($RowLoc=mysqli_fetch_array($Sql_tna_query))
											   		{
													$TnaName=$RowLoc['First_Name']." ".$RowLoc['Last_Name'];
											 ?>
                                            
                                               <!--<option value="<?php echo $TnaName; ?>"><?php echo $TnaName; ?></option>-->
                                             <?php
													}
												}*/
												?>
                                             </select></td>
								  <!-- <td class="table_body_class"><input type="submit" class="btn btn-custon-rounded-three btn-primary" name="update_" value="EDIT" style="margin-left:50px;">-->
								   
								   <input type="submit" class="btn btn-custon-rounded-three btn-primary" name="update_status" value="ADD" style="margin-left:40px;">
								   
								   
								   </td>
								   			   
								   	</tr>
								   
								   
								   
								   </table>
								   
                                        </form>
										
                                        <!--<div class="col-sm-12">
                                            <input type="submit" class="btn btn-custon-rounded-three btn-primary" name="update_" value="ADD NEW" style="float:right;margin-top:10px;">
                                    	  </div>
                                         
                                       </div>-->
                                       
                                       
                                        
                                          
                                         
                                       <?php
									   if($msg==1)
									   {
									   ?>
                                      <script>
									  alert('Plan Added Successfully');
									  //window.parent.location.href='daily-roster.php?pid=<?php echo $_REQUEST['Patient']; ?>';
									  </script>
									  <?php 
									  }
                                       ?>
                                         
                                           
                                </div>
                            </div>
                             
                         </div>
                         
                    </div> 
                     
                    	
                                         
                        </div>
                    </div>
                </div>
                
                
            </div>
        </div>
        <!-- Static Table End -->
        <!-- <div class="footer-copyright-area">
            <div class="container-fluid">
                <div class="row">
                    <div class="col-lg-12">
                        <div class="footer-copy-right">
                           <p>Copyright © 2019. All rights reserved. </p>
                           
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

     <!-- jquery
		============================================ -->
     
       <script src="js/vendor/jquery-1.12.4.min.js"></script>
    <!-- bootstrap JS
		============================================ -->
    <script src="js/bootstrap.min.js"></script>
    <!-- wow JS
		============================================ -->
    <script src="js/wow.min.js"></script>
    <!-- price-slider JS
		============================================ -->
    <script src="js/jquery-price-slider.js"></script>
    <!-- meanmenu JS
		============================================ -->
    <script src="js/jquery.meanmenu.js"></script>
    <!-- owl.carousel JS
		============================================ -->
    <script src="js/owl.carousel.min.js"></script>
    <!-- sticky JS
		============================================ -->
    <script src="js/jquery.sticky.js"></script>
    <!-- scrollUp JS
		============================================ -->
    <script src="js/jquery.scrollUp.min.js"></script>
    
    <script src="js/scrollbar/jquery.mCustomScrollbar.concat.min.js"></script>
    <script src="js/scrollbar/mCustomScrollbar-active.js"></script>

     
    
     <!--  editable JS
		============================================ -->
    <script src="js/editable/jquery.mockjax.js"></script>
    <script src="js/editable/mock-active.js"></script>
    <script src="js/editable/select2.js"></script>
    <script src="js/editable/moment.min.js"></script>
    <script src="js/editable/bootstrap-datetimepicker.js"></script>
    <script src="js/editable/bootstrap-editable.js"></script>
    <script src="js/editable/xediable-active.js"></script>
 <!-- datepicker JS
		============================================ -->
    <script src="js/datepicker/jquery-ui.min.js"></script>
    <script src="js/datepicker/datepicker-active.js"></script>
    
    <!-- mCustomScrollbar JS
		============================================ -->
    <script src="js/scrollbar/jquery.mCustomScrollbar.concat.min.js"></script>
    <script src="js/scrollbar/mCustomScrollbar-active.js"></script>
    <!-- metisMenu JS
		============================================ -->
    <script src="js/metisMenu/metisMenu.min.js"></script>
    <script src="js/metisMenu/metisMenu-active.js"></script>
    <!-- peity JS
		============================================ -->
    <script src="js/peity/jquery.peity.min.js"></script>
    <script src="js/peity/peity-active.js"></script>
    <!-- sparkline JS
		============================================ -->
    <script src="js/sparkline/jquery.sparkline.min.js"></script>
    <script src="js/sparkline/sparkline-active.js"></script>
    <!-- tab JS
		============================================ -->
    <script src="js/tab.js"></script>
    <!-- plugins JS
		============================================ -->
    <script src="js/plugins.js"></script>
    <!-- main JS
		============================================ -->
    <script src="js/main.js"></script>
    <!-- tawk chat JS
		============================================ -->
    <script src="js/tawk-chat.js"></script>
   <!-- form validate JS
		============================================ -->
    <script src="js/form-validation/jquery.form.min.js"></script>
    <script src="js/form-validation/jquery.validate.min.js"></script>
    <script src="js/form-validation/form-active.js"></script>
    
    <script>
$(document).ready(function() {
   $("body").tooltip({ 
   	selector: '[data-toggle=tooltip]' 
	 });
});
 
</script> 
  
               
                                               <script>
 
$('button.call_btn_1').click(function() {
    //var text = $(this).text();
	var text = $(this).data('value_santanu');
	//alert(text)
	$('#hidden_call_box').val(text);
	$('#response').val(text);
    // do something with the text
});
												</script> 
                                                
                                                
                                                
                                                
       <!-- bootstrap-clockpicker -->
      <link rel="stylesheet" type="text/css" href="css/bootstrap-clockpicker.min.css">
    <script type="text/javascript" src="js/bootstrap-clockpicker.min.js"></script>


 <script type="text/javascript">
$('.clockpicker').clockpicker()
	.find('input').change(function(){
		console.log(this.value);
	});
var input = $('#single-input').clockpicker({
	placement: 'bottom',
	align: 'left',
	autoclose: true,
	'default': 'now'
});

$('.clockpicker-with-callbacks').clockpicker({
		donetext: 'Done',
		init: function() { 
			console.log("colorpicker initiated");

		},
		beforeShow: function() {
			console.log("before show");
		},
		afterShow: function() {
			console.log("after show");
		},
		beforeHide: function() {
			console.log("before hide");
		},
		afterHide: function() {
			console.log("after hide");
		},
		beforeHourSelect: function() {
			console.log("before hour selected");
		},
		afterHourSelect: function() {
			console.log("after hour selected");
		},
		beforeDone: function() {
			console.log("before done");
		},
		afterDone: function() {
			console.log("after done");
		}
	})
	.find('input').change(function(){
		console.log(this.value);
	});

// Manually toggle to the minutes view
$('#check-minutes').click(function(e){
	// Have to stop propagation here
	e.stopPropagation();
	input.clockpicker('show')
			.clockpicker('toggleView', 'minutes');
});
if (/mobile/i.test(navigator.userAgent)) {
	$('input').prop('readOnly', true);
}
</script>                                          
                                                
                                                
 <script type="text/javascript">
$("#edit_lead").validate({
          
      showErrors: function(errorMap, errorList) {
          // Clean up any tooltips for valid elements
          $.each(this.validElements(), function (index, element) {
              var $element = $(element);
              $element.data("title", "") // Clear the title - there is no error associated anymore
                  .removeClass("error")
                  .tooltip("destroy");
          });
          // Create new tooltips for invalid elements
          $.each(errorList, function (index, error) {
              var $element = $(error.element);

              $element.tooltip("destroy") // Destroy any pre-existing tooltip so we can repopulate with new tooltip content
                  .data("title", error.message)
                  .addClass("error")
                  .tooltip(); // Create a new tooltip based on the error messsage we just set in the title
          });
      },

     
	  
});
</script>                                               
                                                
    
</body>

</html>