Viewing file:  print_rd.php (6.12 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<script src="SpryAssets/SpryAccordion.js" type="text/javascript"></script>
<script type="text/javascript">
function print1(strid)
{
if(confirm("Do you want to print?"))
{
var values = document.getElementById(strid);
var printing =
window.open('','','left=0,top=0,width=550,height=400,toolbar=0,scrollbars=0,sta?tus=0');
printing.document.write(values.innerHTML);
printing.document.close();
printing.focus();
printing.print();
printing.close();
}
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title></title>
<style>
.button {
background-color: #4CAF50;
border: none;
color: white;
padding: 15px 32px;
text-align: center;
text-decoration: none;
display: inline-block;
font-size: 16px;
margin: 4px 2px;
cursor: pointer;
}
</style>
<link href="SpryAssets/SpryAccordion.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="print2">
<table width="800" p border="0" cellspacing="10" cellpadding="10" >
<tr>
<td>
<?php
$genreceipt=$_POST[receiptno];
$accountname=$_POST[namet];
$fname=$_POST[fname];
$account=$_POST[acname];
$noofinstall=$_POST[noofinst];
$address=$_POST[address];
$paymentmode=$_POST[mpayment];
$receiptdate=$_POST[rdate];
$branchname=$_POST[branchname];
$nextinstdate=$_POST[nextdate];
$chequeno=$_POST[chequeno];
$agentcode=$_POST[agentcode];
$instdate=$_POST[intdate];
$ndate=$_POST[jdate];
$nmonth=$_POST[jmonth];
$nyear=$_POST[jyear];
$idss=$_POST[ids];
$oldamount=$_POST[oldamount];
$todaydate=$ndate.'/'.$nmonth.'/'.$nyear;
if ($nmonth==12)
{
$nmonth=1;
$nyearr=$nyear+1;
}
else
{
$nmonthn=$nmonth+1;
$nyearr=$nyear;
}
$nextdate=$ndate.'/'.$nmonthn.'/'.$nyearr;
?>
<?php
$newtotalamount=$oldamount+$_POST[totalpaidamount];
$con=mysqli_connect("localhost","anshdiam_user","rb!ans838","anshdiam_sarkmicr_data");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "UPDATE rd SET depositamount='$newtotalamount' WHERE id='$idss' ";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php
$installments=(($_POST[totalpaidamount]+$_POST[amount])/$_POST[amount]);
$con=mysqli_connect("localhost","anshdiam_user","rb!ans838","anshdiam_sarkmicr_data");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO rd (acc_no, jdate,jmonth,jyear,branch_name,depositamount,no_installment,
receipt_no, cname,fname, address, mcode, plan_name,latefees,njdate,njmonth,njyear)
VALUES ('$_POST[account]','$_POST[jdate]','$_POST[jmonth]','$_POST[jyear]', '$_POST[branchname]', '$_POST[totalpaidamount]', '$_POST[noofinst]', '$genreceipt','$_POST[namet]','$_POST[fname]','$address','$_POST[agentcode]', '$_POST[planname]','$_POST[latefees]','$_POST[njdate]','$_POST[njmonth]','$_POST[njyear]')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<div id="print2">
<table width="900" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="97" colspan="4" align="left" valign="top">
<?php include('header.php'); ?>
</td>
</tr>
<tr>
<td width="154" align="left"><strong>Receipt No</strong></td>
<td width="230" align="left"><?php echo $genreceipt ?> </td>
<td width="168" align="left"><strong>Print Date</strong></td>
<td width="348" align="left"><?php echo $_POST[jdate].'/'.$_POST[jmonth].'/'.$_POST[jyear] ?></td>
</tr>
<tr>
<td align="left"><strong>Branch Name</strong></td>
<td align="left"><?php echo $branchname ?></td>
<td align="left"><strong>Account No</strong></td>
<td align="left"><?php echo $_POST[account] ?></td>
</tr>
<tr>
<td align="left"><strong>Name</strong></td>
<td align="left"><?php echo $accountname?></td>
<td align="left"><strong>Father/Husband name</strong></td>
<td align="left"><?php echo $fname?></td>
</tr>
<tr>
<td align="left" valign="top"><strong>Applicant Address</strong></td>
<td colspan="3" align="left" valign="top"><?php echo $address ?>
<p> </p></td>
</tr>
<tr>
<td align="left"><strong>Next Due Date</strong></td>
<td align="left"><?php echo $nextdate ?></td>
<td align="left"><strong>Deposit Date</strong></td>
<td align="left"><?php echo $todaydate ?></td>
</tr>
<tr>
</tr>
<tr>
<td align="left"><strong>Installment No</strong></td>
<td align="left"><?php echo $noofinstall ?></td>
<td align="left"><strong>Member Code</strong></td>
<td align="left"><?php echo $_POST[agentcode] ?></td>
</tr>
<tr>
<td align="left"><strong>Deposit Amount</strong></td>
<td align="left"><?php echo $_POST[totalpaidamount] ?></td>
<td align="left"><strong>Late Fine</strong></td>
<td align="left"><?php echo $_POST[latefees] ?></td>
</tr>
<tr>
<td align="left"><strong>Total Paid Amount</strong></td>
<td align="left"><?php echo $newtotalamount ?></td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="right">Authorised Signatory</td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
</table></td>
</tr>
</table>
</div>
</html>
<table width="100%" border="0" cellspacing="10" cellpadding="10" bgcolor="#009999">
<tr>
<td><form action="">
<input type="button" value="New" class="button" onclick="window.location.href='createreceipt_rd.php';"/>
</form></td>
<td><form action="">
<input type="button" name="printbutton" class="button" value="Print Receipt" onclick="return print1('print2')"/>
</form></td>
</tr>
</table>
|