<?php 
include ("include/makeSession.php");
include("checksmsbalance.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('Manage Consultant',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	
	$check=mysqli_query($con,"delete from installment_consultants_payments where id='$doid'");
	if($check){
	$_SESSION['msg']='Record Deleted Successfully';
	}
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=consultant_installment_pay.php">';
	exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="ConsultantPayForm";
	  $doid=$_REQUEST['upid'];
	  if($_REQUEST['editdata']==1){
		   $upuserresult=mysqli_query($con,"select * from installment_consultants_payments where id='".$_REQUEST['upid']."'");
	       $upuserarr=mysqli_fetch_array($upuserresult); 
	  }else{
	  $upuserresult=mysqli_query($con,"select * from consultants_payments where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
	  }
}else{
 	  $dovalue="ConsultantPayForm";
	  $doid='';
} 
?>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Cunsultant Payment  Form <small></small> </h1>
    <ol class="breadcrumb">
    <li><a href="Dashboard.php"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Cunsultant Payment Form</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"> Cunsultant Payment Form <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">
		 
			 <form method="post" action="action1.php" name="addcategory" id="addcategory" 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="editid" value="<?php if(isset($_REQUEST['upid']))
				  { echo '0';}else{ echo '1';}?>" />
			    <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
                <div class="form-group col-md-3">
				 <input name="consultant_id" type="hidden"   placeholder="Pay "
				  id="ContentPlaceHolder1_txtMobile" value="<?php if(isset($_REQUEST['upid']))
				  { echo $upuserarr['consultants_id'];}?>" class="form-control" required> 
			  
                  <label>Student Id</label>                  
                  <input name="student_id" type="text" readonly placeholder=" Name" id="ContentPlaceHolder1_txtStudentName" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['student_id'];}?>" class="form-control" required>
                </div>
                 
				  <?php if($_REQUEST['editdata']==1){ ?>
				    <?php }else{ ?>
                <div class="form-group col-md-3">
                  <label>Total Amount</label>
                  <input name="totalamount" type="number" readonly  placeholder="Total Amount " id="ContentPlaceHolder" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['totalamount'];}?>" class="form-control" required>                  
                </div>
				 <?php } ?>
				 
				 				  <?php if($_REQUEST['editdata']==1){ ?>
				    <?php }else{ ?>
                <div class="form-group col-md-3">
                  <label>Due Amount</label>
                  <input name="due" type="number" readonly  placeholder="Total Amount " id="ContentPlaceHolder1_txtMobile" value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['due'];}?>" class="form-control" required>                  
                </div>
				 <?php } ?>
				  <?php
       $upuserresultgs=mysqli_query($con,"select * from totalcash where id='1'");

	  $upuserresultgsf=mysqli_fetch_array($upuserresultgs);
     ?>
            
			 
          
              <input type="hidden" name="totalcash" value="<?php echo $upuserresultgsf['cash']; ?>" id="totalcashs" />
               <input type="hidden" name="totalbank"  id="totalbank" />
               
                
                                  <div class="col-md-3">                <div class="form-group"> 
				<label>Payment Mode :</label>    			
				<select name="payment_mode" 	required  class="form-control" id="bankpa" >		
				<option value="">-Select-</option>		
				<option value="Cash"  <?php if($upuserarr['paymentmode']=='Cash'){ echo 'selected';} ?>>Cash</option>
				<option value="Cheque" <?php if($upuserarr['paymentmode']=='Cheque'){ echo 'selected';} ?>>Cheque</option>
	          <!--  <option value="Demand Draft" <?php //if($upuserarr['paymentmode']=='Demand Draft'){ echo 'selected';} ?>>Demand Draft</option>
                <option value="POS" <?php //if($upuserarr['paymentmode']=='POS'){ echo 'selected';} ?>>POS</option>	 -->			
				</select>		                      </div>                  
				</div>	
                          <div class="col-md-3" id="bankhide" style="display:none;">        
             
               <div class="form-group">
                 <label>Bank Name  </label>
              
               <select name="bank" class="form-control subject" id='subj'>
                              <option  value="NA" class='asde'>-select-</option>
                              <?php $CasteQuery=mysqli_query($con,"select * from bankdetails");
                                 while($CasteRow=mysqli_fetch_array($CasteQuery)){ 
                                              echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['bank'] == $CasteRow['id'] ? 'selected="selected"' : '' ).'  >'.$CasteRow['bankname'].'</option>';
                                 } ?>                  
                           </select>
              </div>
                </div>
              <div class="col-md-3" id="checkhide" style="display:none;">    
			              <div class="form-group">
                 <label>Check No  </label>
				  <input type='text' name='checkno' class="form-control" 
				 value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['checkno'];}?>" id="ContentPlaceHolder1_txtBillamount" />
              </div>		  

                 </div>                 
               
                
                           <br>           
                            <div class="form-group col-md-3">
                  <label>Pay Amount</label>
				  <?php if($_REQUEST['editdata']==1){ ?>
				  <input type="hidden" name="editdata" value='1'/>
                  <input name="pay" type="number"   placeholder="Pay "
				  id="ContentPlaceHolder1_txtMobile" value="<?php if(isset($_REQUEST['upid']))
				  { echo $upuserarr['submitamount'];}?>" class="form-control" required>  
				  <?php }else{ ?>
				                    <input name="pay" type="number" id='payment'   placeholder="Pay "
				  id="ContentPlaceHolder1_txtMobile" value="<?php if(isset($_REQUEST['upid']))
				  { echo $upuserarr['payamount'];}?>" class="form-control" required>  
				  <?php } ?>				  
                </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-->
   <!-- ./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">REPORT</h3>
          </div>
          <!-- /.box-header -->
          <div class="box-body">
		  <form name="datesearch" method="get" action="" class="pull-right">
		
Form: <input id="demo1" name="datefrom" placeholder="yyyy-mm-dd" type="text" value="<?php if(!empty($_GET['datefrom'])){ echo $_GET['datefrom'];}else{ } ?>">


To: <input id="demo1" name="dateto" placeholder="yyyy-mm-dd" type="text" value="<?php if(!empty($_GET['dateto'])){ echo $_GET['dateto'];}else{ } ?>" size="25">

<input type="submit" value="Search" class='btn btn-primary' >
</form>
            <table id="example1" class="table table-bordered table-striped">
              <thead>
                <tr>                 
                    <th scope="col">No</th>
                    <th scope="col">Student Id</th>
					  <th scope="col">Student Name</th>
                    <th scope="col">Consultant Name</th>
                    <th scope="col"> Consultant Number</th>
					 <th scope="col"> Consultant Amount</th>
					 <th scope="col"> Consultant Due</th>
                    <th scope="col">Submit Amount</th>
					  <th scope="col">Payment Mode</th>
                    <th scope="col">Created Date</th>
					<?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
                    <th scope="col">Action</th>
					<?php } ?>
                </tr>
              </thead>
              <tbody>
			  
			  
                <?php 
			
				if(!empty($_GET['datefrom']) && !empty($_GET['dateto'])){
				$start =$_GET["datefrom"];
                $end =$_GET["dateto"]; 
				
					$Query=mysqli_query($con,"select *,installment_consultants_payments.id as sid, 
					installment_consultants_payments.paymentmode as paymentmodes,
					consultants.name as con_name,installment_consultants_payments.created_at as createdd,
				consultants.email as con_email,consultants.phone as con_phone, admin.username as
				uname,admission_enquiry_form.name as stu_name from installment_consultants_payments left
				JOIN consultants ON installment_consultants_payments.consultants_id=consultants.id left 
				JOIN admission_enquiry_form ON installment_consultants_payments.student_id=admission_enquiry_form.student_id
				left JOIN admin ON installment_consultants_payments.user_id=admin.id 
				left JOIN consultants_payments ON installment_consultants_payments.con_payments=consultants_payments.id 
				WHERE installment_consultants_payments.created_at between '".$start."' and '".$end."'
				
				"
				
				);
				
				
				
				}else{
				$Query=mysqli_query($con,"select *,installment_consultants_payments.id as sid,
installment_consultants_payments.paymentmode as paymentmodes, 
				consultants.name as con_name,
				consultants.email as con_email,consultants.phone as con_phone, admin.username as uname,admission_enquiry_form.name
				as stu_name,installment_consultants_payments.created_at as createdd
				from installment_consultants_payments left JOIN consultants ON 
				installment_consultants_payments.consultants_id=consultants.id left JOIN admission_enquiry_form
				ON installment_consultants_payments.student_id=admission_enquiry_form.student_id 
				left JOIN admin ON installment_consultants_payments.user_id=admin.id 
				left JOIN consultants_payments ON installment_consultants_payments.con_payments=consultants_payments.id
				where installment_consultants_payments.con_payments='".$_REQUEST['upid']."'
			  ");
			  
				}
			  		$i = 1;
					$k=1;
					
					
	  				  while($Row=mysqli_fetch_array($Query)){


	if($k==$i){
					  ?>
                <tr>
				
                  <td><?php echo $i; ?></td>
                  <td><?=$Row['student_id'];?></td>
				   <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row['stu_name'];?></span></td>
				     <td><?=$Row['con_name'];?></td>
                   <td><?=$Row['con_phone'];?></td>
				  <td><?=$Row['consultants_amount'];?></td>
                 <td><?=$Row['due'];?></td>
	
                  <td>
				<?php $Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid 
				from installment_consultants_payments where student_id='".$Row['student_id']."'
				
			  "); 
			    while($Row2=mysqli_fetch_array($Query1)){
			  ?>
				  <?=$Row2['submitamount'];?><br>
				<?php } ?>
				  </td>
				       <td>
					   <?php 
$Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid 
				from installment_consultants_payments where student_id='".$Row['student_id']."'
				
			  "); 
					   while($Row2=mysqli_fetch_array($Query1)){
			  ?>
					   <?=$Row2['paymentmode'];?><br>
					   <?php } ?><br/>
					   </td>
				
                  <td>
				   <?php  
				   $Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid 
				from installment_consultants_payments where student_id='".$Row['student_id']."'
				
			  "); 
				   while($Row2=mysqli_fetch_array($Query1)){
			  ?>
				  <?php echo $Row2['created_at']; ?><br/>
				   <?php } ?>
				  </td>
				  
				  	  <?php if(!empty($_SESSION["ecomid"]) && $_SESSION["ecomid"]==1 ){ ?>
                  <td>
				   <?php  
				   $Query1=mysqli_query($con,"select *,installment_consultants_payments.id as sid 
				from installment_consultants_payments where student_id='".$Row['student_id']."'
				
			  "); 
				   while($Row2=mysqli_fetch_array($Query1)){
			  ?>
			  <?php if($Row['due']==0){ ?>
			  
			<?php   }else{ ?>
			 
				  <a href="?upid=<?php echo $Row["sid"]; ?>&editdata=1"><i class="fa fa-pencil text-yellow"></i></a>
				  &nbsp;&nbsp; <a href="?did=<?php echo $Row["sid"]; ?>"><i class="fa fa-remove text-red"></i></a><br/>
			  <?php } ?>	
			    <a href='./payconsultrecipts.php?upid=<?php echo $Row2["sid"]; ?>'><i class='fa fa-eye'></i></a><br/>
				  <?php  } ?>
				 
				  </td>
					  <?php } ?>
                </tr>
				<?php  $k=1; }else{ $k++; }?>
					  <?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  type="text/javascript">
	$(function () {
	$("#example1").DataTable();
	$('#example2').DataTable({
		"paging": true,
		"lengthChange": false,
		"searching": false,
		"ordering": true,
		"info": true,
		"autoWidth": false
	});
	});
	$(document).ready(function(){
	    
	$('#payment').blur( function ()  { 
	    var due="<?php echo $upuserarr['due'];?>";
	   
	   // alert(due);
	    var pay= $('#payment').val();
	    //alert('pay'+pay);
	     //alert('due'+due);
	    var totalamounts= $('#ContentPlaceHolder').val();
	    if(due==0){
	    // alert(totalamounts);
	       if(parseInt(pay)<=parseInt(totalamounts)){
	           
	       }else{
	           $('#payment').val('');
	        alert('plaese payemnt Below '+totalamounts);
	       }
	      
	        
	    }else if(due>0  ){
	        if(parseInt(pay)<=parseInt(due)){
	            
	        }else{
	         $('#payment').val('');
	        alert('plaese payemnt Below '+due);
	        }
	    }
	    
	});
	
	
	});
</script>
<script>
    
		$('#payment').on('blur',function(){
		    var inputbalance=$('#payment').val();
		    var billamount=$('#dueamount').val();
		  var 	totalcashs=$('#totalcashs').val();
	        var 	totalbank=$('#totalbank').val();
	       // alert(totalbank);
	       	var course=$('#bankpa :selected').val();
	       	
	     if(parseInt(billamount)+1<=parseInt(inputbalance)){
	        alert('Please Enter Amount Less Then '+billamount);
	         $('#payment').val('');  
	     } else if(parseInt(totalcashs)+1<=parseInt(inputbalance) && course=='Cash'){
	          alert('Please Enter Amount Less Then '+totalcashs);
	            $('#payment').val('');  
	     } else if(parseInt(totalbank)+1<=parseInt(inputbalance) && course=='Cheque'){
	          alert('Please Enter Amount Less Then '+totalbank);
	            $('#payment').val('');  
	     }else{
	        
	     }

	});
	
	$('#subj').on('change',function(){
		
	 var htmls='';
	 $('#PartyName').html('');
  $('#payment').val('');  
	var course=$('#subj :selected').val();	
//	alert(course);
	 $.ajax({  
            type: "POST",  
            url: "bankaccountbalance.php",  
            data: {'id': course}, 
            dataType: "json",			
            success: function(dataString) {   
          $('#totalbank').val(parseInt(dataString.amount));
	
				
            }  
        });  
	});
	
	$('#bankpa').on('change',function(){
	    if($('#bankpa').val()=='Cash'){
	 
	   $('#bankhide').css('display','none');
	   $('#checkhide').css('display','none');
	    }else{
	   $('#bankhide').css('display','block');
	   $('#checkhide').css('display','block');
	    }
	});
	
</script>