<?php 
	require_once('pdoconfig.php');
	if(isset($_SESSION['poster_id'])){
		$act=$_REQUEST['act'];
						$catid=$_REQUEST['booking_id'];
						
						if(isset($_REQUEST['booking_id']))
						{
							$catid=$_REQUEST['booking_id'];						
							
							$sqlu="select *, aa_booking_course.crs_id bcrsid from aa_booking_course,aa_course_master,aa_user_master where 1=1
                                  
                                    and aa_booking_course.crs_id=aa_course_master.crs_id
                                    and aa_booking_course.user_id=aa_user_master.usr_id
                                    and aa_booking_course.booking_id=$catid";
                            //echo $sqlu;
							$res= $action->select($sqlu);

							foreach ($res as $id=>$row){
														
							
							$crs_name=htmlspecialchars($row['crs_name']);
							$remarks=htmlspecialchars($row['remarks']);
							$user=htmlspecialchars($row['name']);
							$user_id=htmlspecialchars($row['user_id']);
						    $time_1=$row['time'];
						    
						    $pawan=$row['fees'];
						   
							$crs_id=htmlspecialchars($row['bcrsid']);
							$active=htmlspecialchars($row['active']);
							}
						  
						}
}
if($act=='add' || $act=='edit' || $act=='del'){?>

<div class="col-md-8" id="login" style="margin:auto;float:none;">
<form method="post" action="https://www.tarangglobal.com/wp/join_save.php" style="width:100%;float:left;background: #efe6cc;">
<input name="catid" type="hidden" value="<?=$catid?>"/>
<input name="act" type="hidden" value="<?=$act?>"/>


<div class="form-group" style="margin-bottom:5px;">
<label>Course Name</label>
<select  onchange="crs_val(this.value)" id="crsname" name="crsname" class="form-control">
    <option value="0">-- Select Course --</option>
    <?php 
    $sql1="select * from aa_course_master";
    $res= $action->select($sql1);
    foreach ($res as $id=>$row){
    
    ?>
    <option value="<?=$row['crs_id'];?>" <?php if($row['crs_id']==$crs_id){ echo Selected;}?> ><?=$row['crs_name'];?></option>
    
    <?php } ?>
    
    </select></div>

<div class="form-group" style="margin-bottom:5px;">
<label>Timings</label>
<select  name="time" onchange=" " id="time" class="form-control">
	<option value="0">-- Select Timing --</option>
</select></div>

<div class="form-group" style="margin-bottom:5px;">
<label>Fee</label>
<select name="fee" id="fee" class="form-control">
    <option value="0">-- Select Fee --</option>
</select>
</div>


<div class="form-group" style="margin-bottom:10px;">
<label>Remarks</label>
<Textarea class="form-control" type="text" name="remarks" ><?=$remarks;?></Textarea></div>

<div class="col-md-12" style="text-align:center;margin-top:20px;">
	 <?php if($act=='add'){?>
		<button class="btn btn-primary mr5 waves-effect" type="submit" value="add" id="btn-add">Save</button>
	 <?php } 
	 else if($act=='edit')
	 { ?>
		<button class="btn btn-primary mr5 waves-effect" type="submit" value="edit" id="btn-add">Save</button>
	 <a href="booking_save.php?catid=<?=$catid;?>&amp;act=del" class="btn btn-primary mr5 waves-effect">Delete</a>
	 <?php } ?>
</div>

</form>
</div>
<?php } ?>

<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js" type="text/javascript"></script>

<script>
	$(document).ready(function(){
	  var crs='<?=$crs_id?>';
	 
	    if(crs!='')
	    {
	        // alert(crs);
	        crs_val(crs); 
	    }
	  
	});
	
 function choice1()
    {
    var x = document.getElementById("fee");
    var x2=x.options[x.selectedIndex].value;
    var xsplit=x2.split("|");
    $("#feers").val(xsplit[1]);
    }
	</script>
<script>
function crs_val()
{
var cid=$("#crsname").val();
 $.getJSON("https://tarangglobal.com/wp/join_detail.php?callback=?","cid="+cid, function(data){
 var tab='<option value="">Select Timing</option>';
  var tab1='<option value="">Select Fee</option>';
    $.each(data,function(i,element)
    {
        var t=element.timings;
        var t1=t.split(",");
        var f=element.fee;
        var f1=f.split(",");
   
        t1.forEach(function(e) {
            e=e.trim();
     tab+='<option value="'+e+'" >'+e+'</option>';
        });
        f1.forEach(function(g) {
             g=g.trim();
     tab1+='<option value="'+g+'">'+g+'</option>';
        });
        $("#time").html(tab);
  
    $("#fee").html(tab1);
    }); 
    
    
    
     var time1="<?=$time_1;?>";
      
     var fees1="<?=$pawan;?>";
     
    
  
   if(time1!='' )
    $("#time").val(time1);
    
     if(fees1!='' )
    $("#fee").val(fees1);
   
 });

}


</script>