Viewing file:  acc_printfd.php (9.39 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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Fixed Deposit Account</title>
</head>
<center>
<body>
<table width="100%" border="0" bgcolor="#FFFFFF">
<tr>
<td ><?php include('header.php'); ?></td>
</tr>
<tr>
<td colspan="2"><table width="100%" border="0">
<tr>
<td colspan="3" bgcolor="#CCCCCC"><?php include('menubar.php'); ?></td>
</tr>
<tr>
<td width="210" bgcolor="#6699CC">Welcome <?php echo $login_session; ?></td>
<td width="335" bgcolor="#6699CC"><a href="logout.php">Logout</a></td>
<td width="386" bgcolor="#6699CC"><?php echo "Today is " . date("d/m/y") . "<br>";?></td>
</tr>
</table></td>
</tr>
<tr>
<td colspan="2" align="left">
<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=20,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>
<form id="form1" name="form1" method="post" action="">
<?php
$scheme=$_POST[select];
$amt=$_POST[amount];
$plantime=$_POST[plantime];
$ndate=$_POST[jdate];;
$nmonth=$_POST[jmonth];
$ptime=$_POST[plantime];
$newyear=$_POST[jyear];
if($plantime>0)
{
if($plantime==12)
{
$pt='1';
}
if($plantime==24)
{
$pt='2';
}
if($plantime==36)
{
$pt='3';
}
if($plantime==48)
{
$pt='4';
}
if($plantime==60)
{
$pt='5';
}
}
$regdate=$ndate.'/'.$nmonth.'/'.$newyear;
//check rd
if($scheme=='RD')
{
{
$ndate=$_POST[jdate];
$nmonth=$_POST[jmonth];
$nyear=$_POST[jyear];
if($scheme=='RD')
{
{
if ($nmonth==12)
{
$nmonth=1;
$nyear=$nyear+1;
}
else
$nmonth=$nmonth+1;
}
$rdnextdate=$ndate.'/'.$nmonth.'/'.$nyear;
//Generate Maturity Date
$newyear=$_POST[jyear];
$gnewyear='';
if($ptime==12)
{
$gnewyear=$newyear+1;
}
if($ptime==24)
{
$gnewyear=$newyear+2;
}
if($ptime==36)
{
$gnewyear=$newyear+3;
}
if($ptime==48)
{
$gnewyear=$newyear+4;
}
if($ptime==60)
{
$gnewyear=$newyear+5;
}
$rdmdate=$_POST[jdate].'/'. $_POST[jmonth].'/'. $gnewyear;
}
}
//Generate RD Amount
$rate=1;
if($plantime>0)
{
{
if($plantime==12)
{
$rate=5;
}
else if($plantime==24)
{
$rate=10;
}
if($plantime==36)
{
$rate=15;
}
if($plantime==48)
{
$rate=22;
}
if($plantime==60)
{
$rate=30;
}
}
$maturityamount=($amt*$plantime);
$rdmaturityamount=(($rate*$maturityamount/100)+$maturityamount);
}
}
//check FD
if($scheme=='II')
{
{
$ndate=$_POST[jdate];;
$nmonth=$_POST[jmonth];
$ptime=$_POST[plantime];
$newyear=$_POST[jyear];
$gnewyear='';
if($ptime==12)
{
$gnewyear=$newyear+1;
}
if($ptime==24)
{
$gnewyear=$newyear+2;
}
if($ptime==36)
{
$gnewyear=$newyear+3;
}
if($ptime==48)
{
$gnewyear=$newyear+4;
}
if($ptime==60)
{
$gnewyear=$newyear+5;
}
$fddate=$_POST[jdate].'/'. $_POST[jmonth].'/'. $gnewyear;
}
//Generate MIS Amount
$amt=$_POST[amount];
$plantime=$_POST[plantime];
$time=$plantime/3;
$mamnt=(1+(3/100));
$fdmat=$amt;
$fdmaturityamount=$amt*(pow($mamnt,$time));
$fdmaturityamount=intval($fdmaturityamount);
}
//check MIS
if($scheme=='III')
{
{
$ndate=$_POST[jdate];;
$nmonth=$_POST[jmonth];
$ptime=$_POST[plantime];
$newyear=$_POST[jyear];
$gnewyear='';
if($ptime==12)
{
$gnewyear=$newyear+1;
}
if($ptime==24)
{
$gnewyear=$newyear+2;
}
if($ptime==36)
{
$gnewyear=$newyear+3;
}
if($ptime==48)
{
$gnewyear=$newyear+4;
}
if($ptime==60)
{
$gnewyear=$newyear+5;
}
$misdate=$_POST[jdate].'/'. $_POST[jmonth].'/'. $gnewyear;
}
//Generate MIS Amount
$amt=$_POST[amount];
$plantime=$_POST[plantime];
$time=$plantime/3;
$mismaturityamount=($amt*((1+(3/100))^$time));
}
$mainamount=$fdmaturityamount.$rdmaturityamount.$mismaturityamount;
$premiumdate=$rdnextdate;
$mdate=$rdmdate.$fddate.$misdate;
?>
<?php
$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 fd (acc_no,main,cname,fname,jdate,jmonth,jyear,address,applicationno1,email,
dob,occupation,qualification,mobile,mcode,nominee_name,nominee_age,nomineerelation,amount,
plantime,receipt,branchname,schemename)
VALUES ('$_POST[account]','MAIN', '$_POST[cname]', '$_POST[fname]' , '$_POST[jdate]', '$_POST[jmonth]', '$_POST[jyear]', ' $_POST[address]','$_POST[applicationno1]', '$_POST[email]', ' $_POST[dob]', '$_POST[occupation]', '$_POST[qualification]', '$_POST[mobile]', '$_POST[mcode]', '$_POST[nominee_name]','$_POST[nominee_age]', '$_POST[nomineerelation]', '$_POST[amount]', '$_POST[plantime]', '$_POST[receipt]', '$_POST[branchname]', '$_POST[schemename]')";
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="77" colspan="4" ><table align="center" width="100%" border="0" >
<tr>
<td height="31" align="left" valign="top"><table width="100%" border="0">
<tr>
<td width="86" bgcolor="#FFFFFF"><img src="images/anshdiamondlogo.png" width="80" height="72" /></td>
<td width="792" align="left" valign="top" ><table width="100%" border="0">
<tr >
<td height="20" align="center"><h2>ANSH DIAMOND GROUP</h2></td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center">Corporate Office : CP 4/1Vinay Khand, Gomati Nagar Station Road Lucknow (U.P.)</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center">MOBILE : 05525-2440130</td>
</tr>
<tr bgcolor="#FFFFFF">
<td height="20" align="center">EMAIL : ganeshdiamond@gmail.com</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table> <p> </p></td>
</tr>
<tr>
<td width="154" height="31" align="left" bgcolor="#EBEBEB"><strong>Account No</strong></td>
<td width="229" align="left" bgcolor="#EBEBEB"><?php echo $_POST[account] ?></td>
<td width="142" align="left" bgcolor="#EBEBEB"><strong>Deposit Date</strong></td>
<td width="369" align="left" bgcolor="#EBEBEB"><?php echo $regdate ?></td>
</tr>
<tr>
<td align="left"><strong>Branch Name</strong></td>
<td align="left"><?php echo $_POST[branchname] ?></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>
<tr>
<td align="left"><strong>Name</strong></td>
<td align="left"><?php echo $_POST[cname].$_POST[cmidname]. $_POST[csurname] ?></td>
<td align="left">Father/Husband Name</td>
<td align="left"><?php echo $_POST[fname] ?></td>
</tr>
<tr>
<td align="left" valign="top"> </td>
<td colspan="3" align="left" valign="top"> </td>
<td align="left"></td>
<td align="left"></td>
</tr>
<tr>
<td align="left" valign="top"><strong>Applicant Address</strong></td>
<td colspan="3" align="left" valign="top"><?php echo $_POST[address] ?>
<p> </p></td>
<td width="1" align="left"></td>
<td width="5" align="left"></td>
</tr>
<tr>
<td align="left"><strong>Deposit Amount</strong></td>
<td align="left"><?php echo $_POST[amount] ?></td>
<td align="left"><strong>Plan Period</strong></td>
<td align="left"><?php echo $_POST[plantime]."Years" ?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left"><strong>Application No</strong></td>
<td align="left"><?php echo $_POST[applicationno] ?></td>
<td align="left"><strong>Plan Name</strong></td>
<td align="left"><?php echo $_POST[schemename] ?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td align="left"><strong>Member Code</strong></td>
<td align="left"><?php echo $_POST[mcode] ?></td>
<td align="left"> </td>
<td align="left"> </td>
</tr>
<tr>
<td colspan="4" align="left"><strong></strong></td>
</tr>
<tr>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE">Authorised Signatory</td>
</tr>
</table>
<BR ><BR><BR >
</div>
<br/><br/>
<table width="300" border="0" cellspacing="10" cellpadding="10">
<tr>
<td><input type="button" name="printbutton" value="Prin Receipt" onclick="return print1('print2')"/> </form></td>
<td><form action=""><input type="button" value="New" onclick="window.location.href='createaccount.php';"/> </form> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"><?php include('footer.php'); ?></td>
</tr>
</table>
</body></center>
</html>
|