|
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/css/../sale_new/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!DOCTYPE html>
<html>
<head>
<?php
include('php-includes/connect.php');
include('php-includes/check-login.php');
$userid = $_SESSION['userid'];
$sch=$_REQUEST['sch'];
$session=$_REQUEST['session'];
?>
<title>
POS
</title>
<link href="css/bootstrap.css" rel="stylesheet">
<link rel="stylesheet" type="text/css" href="css/DT_bootstrap.css">
<link rel="stylesheet" href="css/font-awesome.min.css">
<style type="text/css">
.sidebar-nav {
padding: 9px 0;
}
</style>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="../style.css" media="screen" rel="stylesheet" type="text/css" />
<link href="src/facebox.css" media="screen" rel="stylesheet" type="text/css" />
<script src="js/jquery.min.js" type="text/javascript"></script>
<script src="src/facebox.js" type="text/javascript"></script>
<script language="javascript">
function Clickheretoprint()
{
var disp_setting="toolbar=yes,location=no,directories=yes,menubar=yes,";
disp_setting+="scrollbars=yes,width=900, height=400, left=100, top=10";
var content_vlue = document.getElementById("content").innerHTML;
var docprint=window.open("","",disp_setting);
docprint.document.open();
docprint.document.write('</head><body onLoad="self.print()" style="width: 800px; font-size: 10px; font-family: serif;margin-top:-210px;margin-left:0px">');
docprint.document.write('</head><table onLoad="self.print()" style="width: 800px; font-size: 9px; font-family: serif;">');
docprint.document.write(content_vlue);
docprint.document.close();
docprint.focus();
}
</script>
<?php
//$invoice=$_GET['invoice'];
//echo $amount;
?>
<script language="javascript" type="text/javascript">
/* Visit http://www.yaldex.com/ for full source code
and get more free JavaScript, CSS and DHTML scripts! */
<!-- Begin
var timerID = null;
var timerRunning = false;
function stopclock (){
if(timerRunning)
clearTimeout(timerID);
timerRunning = false;
}
function showtime () {
var now = new Date();
var hours = now.getHours();
var minutes = now.getMinutes();
var seconds = now.getSeconds()
var timeValue = "" + ((hours >12) ? hours -12 :hours)
if (timeValue == "0") timeValue = 12;
timeValue += ((minutes < 10) ? ":0" : ":") + minutes
timeValue += ((seconds < 10) ? ":0" : ":") + seconds
timeValue += (hours >= 12) ? " P.M." : " A.M."
document.clock.face.value = timeValue;
timerID = setTimeout("showtime()",1000);
timerRunning = true;
}
function startclock() {
stopclock();
showtime();
}
window.onload=startclock;
// End -->
</SCRIPT>
<body>
<link href="css/dashboard.css" rel="stylesheet" type="text/css"/>
<link href="css/dashboardmenu.css" rel="stylesheet" type="text/css"/>
<link href="css/student_details_side_menu.css" rel="stylesheet" type="text/css"/>
<link href="css/student_details.css" rel="stylesheet" type="text/css"/>
<link href="css/student_details.css" rel="stylesheet" type="text/css"/>
<div class="container-fluid">
<div class="row-fluid">
<div class="span10">
<a href="sale.php"><button class="btn btn-primary"><i class="icon-arrow-left"></i> Back to Sales</button></a>
<div class="content" id="content">
<div style="margin: 0 auto; padding: 20px; width: 900px; font-weight: normal;">
<div style="width: 100%; height: 190px;" >
<div style="width: 900px; float: left;">
<center><div style="font:bold 25px 'Aleo';"> <br> <br>
</center>
<div>
<?php
$sel2="select * from paid where sch='$sch' and session='$session' and status=''";
$res2=mysqli_query($conn,$sel2);
$sel23="select * from paid where sch='$sch' and session='$session' and status='' order by id desc";
$res23=mysqli_query($conn,$sel23);
$row23=mysqli_fetch_array($res23,MYSQLI_BOTH);
$pre=$row23['pre_dues'];
$to_paid=0;
$to_dues=0;
$to_dis=0;
$d1='';
$d2='';
$d3='';
$d4='';
$s=1;
$a23='';
$to_sale=0;
while($row2=mysqli_fetch_array($res2,MYSQLI_BOTH))
{
$to_dis=$row2['concession']+$to_dis;
$to_paid=$row2['paid']+$to_paid;
$to_sale=$row2['sale']+$to_sale;
$date=$row2['date'];
$t=date("d-m-Y", strtotime($date));
$d=$t.'='.$row2['paid'];
$a23=$a23.','.$d;
if($s==1)
{
$d1=$date;
}
if($s==2)
{
$d2=$date;
}
if($s==3)
{
$d3=$date;
}
if($s==4)
{
$d4=$date;
}
$time=$row2['time'];
$s++;
}
$to_dues=$to_sale-$to_paid-$to_dis;
$sel21="select * from registration where application='$sch' and session='$session'";
$res21=mysqli_query($conn,$sel21);
$row21=mysqli_fetch_array($res21,MYSQLI_BOTH);
?>
</div>
</div>
<div class="clearfix"></div>
</div>
<div style="width: 100%; margin-top:-20px;">
<table border="1" cellpadding="4" cellspacing="0" style="font-family:geneva; font-size: 16px; text-align:left;" width="100%">
<thead>
<tr >
<td colspan='5' > <center><b> STATIONARY CENTER <br/></b><br/><b>Student.:-</b><?php echo $row21['name'];?>  <b>Class.:-</b><?php echo $row21['subject'];?> <?php echo $row21['mediam'];?><br/><b>Father.:-</b><?php echo $row21['fname'];?>  <b>Total Sale Of Session:</b><?php echo $session;?></center></th>
</tr>
<tr>
<th width="10"> Sr </th>
<th width="80"> Item Name </th>
<th width="10"> Qty </th>
<th width="20"> Price </th>
<th width="60"> Amount </th>
</tr>
</tr>
</thead>
<tbody>
<?php
//$id=$_GET['invoice'];
$sel11="select * from sale where scholar='$sch' and status='' and session='$session' ";
$res11=mysqli_query($conn,$sel11);
$r=1;
$m=0;
$q=0;
while($row11=mysqli_fetch_array($res11,MYSQLI_BOTH))
{
$id=$row11['product_id'];
$sel="select * from product where id='$id' and status='' order by id desc";
$res=mysqli_query($conn,$sel);
$row=mysqli_fetch_array($res,MYSQLI_BOTH);
?>
<tr class="record">
<td><?php echo $r++; ?></td>
<td><?php echo $row['product_name']; ?></td>
<td><?php $q=$row11['sale_qty']+$q;echo $row11['sale_qty']; ?></td>
<td>
<?php echo $row['price']; ?>
</td>
<td>
<?php
echo $a=$row['price']*$row11['sale_qty'];
$m=$a+$m;
?>
</td>
</tr>
<?php
}
?>
<tr>
<td colspan="2" style=" text-align:right;"><strong style="font-size: 13px;font-weight:bold;color:black">Total Quantity: </strong></td>
<td colspan="" style=" text-align:left;"><strong style="font-size: 13px;font-weight:bold;color:black">
<?php
echo $q;
?>
</strong></td>
<td colspan="" style=" text-align:right;"><strong style="font-size: 12px;"> </strong></td>
<td colspan=""><strong style="font-size: 12px;">
<?php
echo $m;
?>
</strong></td>
</tr>
<tr>
<td colspan="4"style=" text-align:right;"><strong style="font-size: 16px; color: black;font-weight:bold">Total: </strong></td>
<td colspan="2"><strong style="font-size: 13px;font-weight:bold; color: black;" width="60">
<?php
echo $m;
?>
</strong></td>
</tr>
<tr>
<td colspan="4"style=" text-align:right;"><strong style="font-size: 16px; color: black;font-weight:bold">Discount: </strong></td>
<td colspan="2"><strong style="font-size: 13px;font-weight:bold; color: black;">
<?php
echo $to_dis;
?>
</strong></td>
</tr>
<tr>
<td colspan="4"style=" text-align:right;"><strong style="font-size: 16px; color: black;font-weight:bold">Paid Amount: </strong></td>
<td colspan="2"><strong style="font-size: 13px;font-weight:bold; color: black;">
<?php
echo $to_paid;
?>
</strong></td>
</tr>
<tr>
<td colspan="1"style=" text-align:right;"><strong style="font-size: 16px; color: black;font-weight:bold">Paid Date: </strong></td>
<td colspan="5"><strong style="font-size: 13px;font-weight:bold; color: black;">
<?php
echo $a23;
?>
</strong></td>
</tr>
<tr>
<td colspan="4"style=" text-align:right;"><strong style="font-size: 16px; color: black;font-weight:bold">Dues: </strong></td>
<td colspan="2"><strong style="font-size: 13px;font-weight:bold; color: black;">
<?php
echo $to_dues;
?>
</strong></td>
</tr>
<tr>
<td colspan="6"><strong style="font-size: 13px; color: #222222;">
<?php echo date("d-m-Y", strtotime($d1));?>, <?php if($d2!=''){echo date("d-m-Y", strtotime($d2));};?>,<?php if($d3!=''){echo date("d-m-Y", strtotime($d3));};?>,<?php if($d4!=''){echo date("d-m-Y", strtotime($d4));};?><span style=" margin-left:200px;font-weight:bold">Seal</span><br/><br/><br/>
</strong></td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
<div >
<center><a href="javascript:Clickheretoprint()" style="font-size:20px;"><button class="btn btn-success btn-large"><i class="icon-print"></i> Print</button></a></center>
</div>
</div>
</div>