Viewing file:  acc_print_rd.php (15.54 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>RD Create Account</title>
</head>
<center>
<body>
<?php
$aaamount=$_POST[amount];
$upamount=$_POST[odamount]-$_POST[amount];
$result=0;
$num= $upamount;
$nwords = array( "", "one", "two", "three", "four", "five", "six",
"seven", "eight", "nine", "ten", "eleven", "twelve", "thirteen",
"fourteen", "fifteen", "sixteen", "seventeen", "eightteen",
"nineteen", "twenty", 30 => "thirty", 40 => "fourty",
50 => "fifty", 60 => "sixty", 70 => "seventy", 80 => "eigthy",
90 => "ninety" );
function number_to_words ($x)
{
global $nwords;
if(!is_numeric($x))
{
$w = '#';
}else if(fmod($x, 1) != 0)
{
$w = '#';
}else{
if($x < 0)
{
$w = 'minus ';
$x = -$x;
}else{
$w = '';
}
if($x < 21)
{
$w .= $nwords[$x];
}else if($x < 100)
{
$w .= $nwords[10 * floor($x/10)];
$r = fmod($x, 10);
if($r > 0)
{
$w .= ' '. $nwords[$r];
}
} else if($x < 1000)
{
$w .= $nwords[floor($x/100)] .' hundred';
$r = fmod($x, 100);
if($r > 0)
{
$w .= ' '. number_to_words($r);
}
} else if($x < 1000000)
{
$w .= number_to_words(floor($x/1000)) .' thousand';
$r = fmod($x, 1000);
if($r > 0)
{
$w .= ' ';
if($r < 100)
{
$w .= ' ';
}
$w .= number_to_words($r);
}
} else {
$w .= number_to_words(floor($x/1000000)) .' million';
$r = fmod($x, 1000000);
if($r > 0)
{
$w .= ' ';
if($r < 100)
{
$word .= ' ';
}
$w .= number_to_words($r);
}
}
}
return $w;
}
// demonstration
$convertvalue= strtoupper(' '.number_to_words($aaamount).' ');
?>
<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"><div id="print"></div></td>
<td> </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
$address=$_POST[village].$_POST[post].$_POST[distt].$_POST[state].$_POST[pin];
$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,cname,fname,address,email,qualification,nominee_name,nomineeralation,premiumamount,plan_time,receipt_no,
jdate,jmonth,jyear,pan_no,phone,dateofbirth,occupation,mcode,nomineeage,no_installment,plan_name,branch_name,main,plantype,rank)
VALUES ('$_POST[account]','$_POST[cname]','$_POST[fname]','$_POST[address]','$_POST[email]','$_POST[qualification]',
'$_POST[nominee_name]','$_POST[nomineerelation]','$_POST[amount]','$_POST[plantime]','$_POST[receipt]','$_POST[jdate]',
'$_POST[jmonth]','$_POST[jyear]','$_POST[panno]','$_POST[phone]','$_POST[dob]','$_POST[occupation]','$_POST[mcode]',
'$_POST[nominee_age]','$_POST[noofinstall]','$_POST[planname]','$_POST[branchname]','MAIN' ,'$_POST[plantype]','$_POST[agent_rank]')";
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" bgcolor="#FFFFFF"><table width="100%" border="0">
<tr>
<td width="940" align="center" bgcolor="#B1AEAE"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<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> <p> </p></td>
</tr>
<tr>
<td width="154" height="31" align="left" bgcolor="#EBEBEB"><strong>Receipt No</strong></td>
<td width="298" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receipt] ?></td>
<td width="183" align="left" bgcolor="#EBEBEB"><strong>Print Date</strong></td>
<td width="259" 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"><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 $_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"><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>Plan Name</strong></td>
<td align="left"><?php echo $_POST[planname] ?></td>
<td align="left"><strong>Plan Period</strong></td>
<td align="left"><?php echo $_POST[plantime]."Months" ?></td>
</tr>
<tr>
<td align="left"><strong>Installment Type</strong></td>
<td align="left"><?php echo $_POST[plantype] ?></td>
<td align="left"><strong>Deposit Date</strong></td>
<td align="left"><?php echo $regdate ?></td>
</tr>
<tr>
<td align="left"><strong>Premium Amount</strong></td>
<td align="left"><?php echo $aaamount ?></td>
<td align="left"><strong>Next Due Date</strong></td>
<td align="left"><?php echo $premiumdate ?></td>
</tr>
<tr>
<td align="left"><strong>Member Code</strong></td>
<td align="left"><?php echo $_POST[mcode] ?></td>
<td align="left"><strong>Installment No</strong></td>
<td align="left"><?php echo $_POST[noofinstall] ?></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>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"><strong></strong></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>
<tr>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="right" bgcolor="#B1AEAE"> </td>
</tr>
<tr><td>
</td></tr>
</table>
<table width="900" border="0" cellspacing="0" cellpadding="0" " >
<tr>
<td height="77" colspan="4" bgcolor="#FFFFFF"><table width="100%" border="0">
<tr>
<td width="940" align="center" bgcolor="#B1AEAE"> </td>
</tr>
<tr bgcolor="#FFFFFF">
<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>
<p> </p></td>
</tr>
<tr>
<td width="154" height="31" align="left" bgcolor="#EBEBEB"><strong>Receipt No</strong></td>
<td width="298" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receipt] ?></td>
<td width="183" align="left" bgcolor="#EBEBEB"><strong>Print Date</strong></td>
<td width="259" 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"><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 $_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"><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>Plan Name</strong></td>
<td align="left"><?php echo $_POST[planname] ?></td>
<td align="left"><strong>Plan Period</strong></td>
<td align="left"><?php echo $_POST[plantime]."Months" ?></td>
</tr>
<tr>
<td align="left"><strong>Installment Type</strong></td>
<td align="left"><?php echo $_POST[plantype] ?></td>
<td align="left"><strong>Deposit Date</strong></td>
<td align="left"><?php echo $regdate ?></td>
</tr>
<tr>
<td align="left"><strong>Premium Amount</strong></td>
<td align="left"><?php echo $aaamount ?></td>
<td align="left"><strong>Next Due Date</strong></td>
<td align="left"><?php echo $premiumdate ?></td>
</tr>
<tr>
<td align="left"><strong>Member Code</strong></td>
<td align="left"><?php echo $_POST[mcode] ?></td>
<td align="left"><strong>Installment No</strong></td>
<td align="left"><?php echo $_POST[noofinstall] ?></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>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"><strong></strong></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>
<tr>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="left" bgcolor="#B1AEAE"> </td>
<td align="right" bgcolor="#B1AEAE"> </td>
</tr>
<tr>
<td></td>
</tr>
</table>
</div>
<br/><br/>
<table width="300" border="0" cellspacing="10" cellpadding="10">
<tr>
<td><input type="button" name="printbutton" value="Prin table" onclick="return print1('print2')"/>
<input type="button" value="New" onclick="window.location.href='createaccount_rd.php';"/>
</form></td>
<td><form action=""></form> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"><?php include('footer.php'); ?></td>
</tr>
</table>
</body></center>
</html>
|