<?php 
include ("include/makeSession.php");
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");

?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Set Monthly Fee <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Set Monthly Fee</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-md-12">
        <div class="box box-info">
          <div class="box-header">
            <h3 class="box-title">Set Monthly Fee <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-12">
                <form action='' method="get">
                      <div class="form-group col-md-6">
                  <label>Student Id *</label>                 
                  <input name="student_id" type="text"  placeholder="Student Id"  value="<?php if(isset($_GET['student_id'])){ echo $_GET['student_id'];}?>" class="form-control" required>
                </div> 
                 <div class="form-group col-md-6">
                      <input style="margin-top:23px;" type="submit" class="btn btn-primary" name="ctl00$ContentPlaceHolder1$btnsave" value="Search"/> 
                 </div>
                </form>
            <?php  if(isset($_GET['student_id'])){
                    //$alreadysetQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$_GET['student_id']."'");
            	    //$alreadysetR=mysqli_fetch_array($alreadysetQ);
            	    $admissionQ=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$_GET['student_id']."'");
                    $admissionR=mysqli_fetch_array($admissionQ);
	        ?>
	        <br>
	        <br>
	        <div class="row">
	            <div class="col-md-4">
	                <h4>Student ID: <i><b><?=$admissionR['student_id'];?></b></i></h4>
	            </div>
	            <div class="col-md-4">
	                <h4>Name: <i><b><?=$admissionR['name'];?></b></i></h4>
	            </div>
	            <div class="col-md-4">
	                <h4>Course: 
	                    <i><b>
	                <?php
    	                $course_id=$admissionR['course'];
    	                $courseQ=mysqli_query($con,"select * from course where id=".$course_id);
    	                $courseR=mysqli_fetch_array($courseQ);
    	                echo $courseR['c_name']; 
	                ?></b></i>
	                </h4>
	            </div>
	            
            </div>
	        <?php }//if student_id set end ?>
	        <br>
	        <br>
	        <br>
	        <hr>
	        <form method="post" action="akshay_action.php" name="addcategory" id="addcategory" enctype="multipart/form-data"  role="form">
                <input type="hidden" id="do"  name="do" value="setmonthlyfee" />
                <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
	        <?php 
	            if(isset($_REQUEST['student_id'])){
            ?>
                <input type="hidden" name="student_id" value="<?=$_REQUEST['student_id']?>" />
                <div class="row">
                    <?php
                        $admissionQ=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$_GET['student_id']."'");
                        $admissionR=mysqli_fetch_array($admissionQ);
                        $miscfeemasterQ=mysqli_query($con,"select * from miscfeemaster where course_id='".$admissionR['course']."' AND types='monthly'");
                        
                        
                    ?>
                    <div class="col-md-6">
                    <div class="form-group">
                        <label>Monthly Course Fee :</label> <br/>                                   
                        <?php
                        
                            while($miscfeemasterR=mysqli_fetch_array($miscfeemasterQ)){$i++;$ischecked="false";
                                $setmonthlyfeeQ=mysqli_query($con,"select * from setmonthlyfee where student_id='".$_REQUEST['student_id']."'");
                                while($setmonthlyfeeR=mysqli_fetch_array($setmonthlyfeeQ)){
                                    if($miscfeemasterR['id']==$setmonthlyfeeR['miscfeemaster_id'])
                                    {
                                        $ischecked="true";
                                    }
                                }
                        ?>
                        <input name="feecheckbox[]" type="checkbox" value="<?=$miscfeemasterR['id']; ?>" <?php if($ischecked=="true"){echo "checked";} ?> ><?=$miscfeemasterR['feemaster'];?>
                        <?php
                            }
                        ?>
                    </div>
                    </div>
                </div>
                <div class="row">                                                            
                    <div class="col-md-6">
                    <div class="form-group">
                        <input type="submit" id="submit" class="btn btn-primary" value="Save"/>
                        <input type="reset" value="Reset" class="btn btn-primary">           
                    </div>
                    </div>
                </div>
	        <?php   
	            }
	        ?>
	        </form>
            </div> <!--Col 12-->
          </div>   
        </div><!-- /.box -->
      </div><!-- /.col-->
    </div><!-- ./row -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>