<?php 
include ("include/makeSession.php");
$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Master Setting',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
$_SESSION['page_name']="Master";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	mysqli_query($con,"delete from miscfeemaster where id='$doid'");
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=miscfeemaster.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="miscfeemaster";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from miscfeemaster where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
}else{
 	  $dovalue="miscfeemaster";
	  $doid='';  
}
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1>MISC Fee Head Master <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">MISC Fee Head Master</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-md-12">
	   <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-12">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
        <div class="box box-info">
          <div class="box-header">
            <h3 class="box-title"> MISC Fee Head Master <small></small></h3>
            <!-- tools box -->
            <div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div>
            <!-- /. tools --> 
          </div>
          <!-- /.box-header -->
          <div class="box-body pad">
            <div class="col-md-8">
              <form method="post" action="action1.php" enctype="multipart/form-data"  role="form">
                <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid" value="<?php echo $doid;?>" />
				 <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
             
                <!-- text input --> 
				  
                <div class="form-group">
                  <label>MISC Fee Head Master</label>                                    
                  <input name="feename" type="text" required class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['feemaster'];}?>" placeholder="Enter Fee Head Master">                  
                </div>
				<div class="form-group">
				<label>Course :</label>
                           <select name="course" id="coursealert" class="form-control subject" required>
                              <option value=''>-select-</option> 
                              <?php $CasteQuery=mysqli_query($con,"select * from course");
                                 while($CasteRow=mysqli_fetch_array($CasteQuery)){ 
                                              echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['course_id'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['c_name'].'</option>';
                                 } ?>                  
                           </select>
						   </div>
						   	<div class="form-group">
				<label>Transaction Type :</label>
                            <select name="incomeorexpence"  class="form-control subject">
                              <option  value="">-select-</option>
                               <option  value="Income" 
                               <?php if($upuserarr['incomeorexpence']=='Income'){ echo 'selected';}?>>Income</option>
                               <option  value="Expence" <?php if($upuserarr['incomeorexpence']=='Expence'){ echo 'selected';}?>>Expence</option>      
                           </select>
						   </div>
						   	   	<div class="form-group">
				<label> Type :</label>
                            <select name="types"  class="form-control subjecttpyes">
                              <option  value="">-select-</option>
                               <option  value="onetime" 
                               <?php if($upuserarr['types']=='onetime'){ echo 'selected';}?>>One time</option>
                               <option  value="monthly" <?php if($upuserarr['types']=='monthly'){ echo 'selected';}?>>Monthly</option>      
                           </select>
						   </div>
						    <div class="form-group startdate" style="display:none;">
                  <label>Start Date</label>                                    
                  <input name="start" type="date" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['start'];}?>" >                  
                </div> 
                 <div class="form-group enddate" style="display:none;">
                  <label>End Date</label>                                    
                  <input name="end" type="date" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['end'];}?>" >                  
                </div> 
				   <div class="form-group">
                  <label>Amount</label>                                    
                  <input name="amount" type="number" class="form-control" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['amount'];}?>" placeholder="Enter Amount">                  
                </div> 


                <div class="box-footer">
                  <input type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Save"/>
                  <input type="reset" name="ctl00$ContentPlaceHolder1$btn_reset" value="Reset" id="ContentPlaceHolder1_btn_reset" class="btn btn-primary">
                </div>
              </form>
            </div>
          </div>
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col--> 
    </div>
    <!-- ./row --> 
  </section>
  <!-- /.content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">MISC Fee Head Master Report</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
            <table id="example1" class="table table-bordered table-striped">
              <thead>
              <tr>                   
                    <th scope="col">Sr no</th>
                    <th scope="col">Fee Name</th>
					<th scope="col">Course Name</th>
                    <th scope="col">amount</th>
                    <th scope="col">Transaction Type</th>
                    <th scope="col">Type</th>
                    <th scope="col">Start</th>
                    <th scope="col">End</th>
                     <th scope="col">Created At</th>
                    <th scope="col">Active Status</th>
                    <th scope="col">Action</th>
                  </tr>                
              </thead>
              <tbody>
                <?php $Query=mysqli_query($con,"select * ,course.id as ids,miscfeemaster.id as id from miscfeemaster left JOIN course as
			  course ON miscfeemaster.course_id=course.id order by miscfeemaster.id desc limit 10 ");
			  		$i = 1;
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                <tr>
			
                  <td><?php echo $i; ?></td>
                  <td><?=$Row['feemaster'];?></td> 
				  <td><?=$Row['c_name'];?></td>
                  <td><?=$Row['amount'];?></td>
                  <td><?=$Row['incomeorexpence'];?></td>
                  <td><?=$Row['types'];?></td>
                  <td><?=$Row['start'];?></td>
                  <td><?=$Row['end'];?></td>
                  <td><?=$Row['created_at'];?></td>
                  <td><?php if($Row['status'] == 1){echo 'Active';}?></td>
                  <td><a href="?upid=<?php echo $Row["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a>&nbsp;&nbsp; <a href="?did=<?php echo $Row["id"]; ?>" onclick="return confirm_click();"><i class="fa fa-remove text-red"></i></a></td>
                </tr>
                <?php $i++;} ?>
              </tbody>
            </table>
          </div>
          <!-- /.box-body --> 
        </div>
        <!-- /.box --> 
      </div>
      <!-- /.col --> 
    </div>
    <!-- /.row --> 
  </section>
</div>
<?php include('include/footer.php');?>

<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/dataTables.buttons.min.js"  type="text/javascript"></script>
<script src="https://cdn.datatables.net/buttons/1.5.1/js/buttons.colVis.min.js"  type="text/javascript"></script>


<script  type="text/javascript">
$(document).ready(function() {
      var typess=$('.subjecttpyes').val(); 
        if(typess=='monthly'){
            $('.startdate').css('display','block');
            $('.enddate').css('display','block');
        }else{
             $('.startdate').val('');
            $('.enddate').val('');
            $('.startdate').css('display','none');
            $('.enddate').css('display','none'); 
        }
    $('#example1').DataTable( {
      
        
        
    } );
     $('.subjecttpyes').on('change',function(){
        var types=$('.subjecttpyes').val(); 
        if(types=='monthly'){
            $('.startdate').css('display','block');
            $('.enddate').css('display','block');
        }else{
             $('.startdate').val('');
            $('.enddate').val('');
            $('.startdate').css('display','none');
            $('.enddate').css('display','none');
        }
     });
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>