Viewing file:  acc_print.php (19.02 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>Create Account</title>
</head>
<center>
<body>
<?php
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "UPDATE branch SET assetamount='$upamount' WHERE branchname='$_POST[branchname]'";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?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).' ');
?>
<?php
$host="localhost"; // Host name
$username="sarkmicr_user"; // Mysql username
$password="rb!sar838"; // Mysql password
$db_name="sarkmicr_data"; // Database name
$tbl_name="new_acc"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// Retrieve data from database
$sql="SELECT acc_no FROM $tbl_name order by ID";
$result=mysql_query($sql);
// Start looping rows in mysql database.
while($rows=mysql_fetch_array($result)){
$accountnew= $rows['acc_no'];
// close while loop
}
$str2 = substr($accountnew, 6);
$str2= $str2+1;
$names =$_POST[cname];
$pos1 = substr($names,0, 1);
$villages =$_POST[village];
$pos2 = substr($villages,0, 1);
$posts =$_POST[post];
$pos3 = substr($posts ,0, 1);
$string=$pos1.$pos2.$pos3;
$gencode=sprintf($string.'0000'.$str2);
$gencode=strtoupper($gencode);
mysql_close();
?>
<?php
?>"
<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
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO new_acc (acc_no, pan_no, email, qualification, nominee_name, agent_name, plan_name,plantype, cname, address, dateofbirth, jdate,jmonth,jyear, nomineeage, agentcode, agentrank, plan_time,
phone, occupation, passbookno, nomineeralation, amount, payment_mode, next_ins_date, bank_name, no_installment, cheque_no, plandiv1, mdate,mmonth,myear, fname,village,post,distt,state,pin,fd,fdtime,fdnextinst,rd,rdtime,rdnextinstall,mis,mistime,misnexttime,mep,meptime,mepnextinst,lsmbp,lsmbptime,lsmbpnextinst,receipt_no,ecode,maturityamount,applicationno,depositby,branchcode,mcode)
VALUES ('$_POST[account]','$_POST[panno]', '$_POST[email]', '$_POST[qualification]' , '$_POST[nominee_name]', '$_POST[agent_name]', '$_POST[select]', ' $_POST[select]','$_POST[cname]', '$_POST[address]', ' $_POST[dob]', '$_POST[jdate]', '$_POST[jmonth]', '$_POST[jyear]', '$_POST[nominee_age]', '$_POST[network_code]','$_POST[agent_rank]', '$_POST[plantime]', '$_POST[phone]', '$_POST[occupation]', '$_POST[passbookno]', '$_POST[nomineerelation]', '$_POST[amount]', '$_POST[paymentmode]', '$nextdate', '$_POST[bankname]', '$_POST[noofinstall]', '$_POST[chequeno]','$_POST[TB1]','$_POST[jdate]','$_POST[jmonth]', '$newyear', '$_POST[fname]','$_POST[village]','$_POST[post]','$_POST[distt]','$_POST[state]', '$_POST[pin]','$_POST[fd]', '$_POST[fdtime]', '$_POST[fdnexttime]','$_POST[rd]','$_POST[rdtime]','$_POST[rdnextinstall]','$_POST[mis]','$_POST[mistime]','$_POST[misnexttime]','$_POST[mep]','$_POST[meptime]','$_POST[mepnextinst]','$_POST[lsmbp]','$_POST[lsmbptime]','$_POST[lsmbpnextinst]','$_POST[receipt]','$_POST[eecode]','$mainamount','$_POST[applicationno]','$_POST[depositby]','$_POST[branchname]','$_POST[mcode]')";
if (!mysqli_query($con,$sql)) {
die('Error: ' . mysqli_error($con));
}
mysqli_close($con);
?>
<?php
$con=mysqli_connect("localhost","sarkmicr_user","rb!sar838","sarkmicr_data"); // Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql = "INSERT INTO create_receipt (acc_no, receive_date, branch_name,mode_payment,bank_name,amount,noofinstallment,cheque_no,
receipt2, accountholder, address, next_inst, agentcode,insdate, agentname, amountrups,maturity_date, planname, plantime, jdate,jmonth,jyear, cname,village,post,distt,state,pin,fd,njdate,njmonth,njyear,mcode,allication,maturamount,maturdate,ncode,pt,fname,rank)
VALUES ('$_POST[account]','$_POST[date]','$_POST[branchname]','$_POST[paymentmode]','$_POST[bankname]','$_POST[amount]', '$_POST[noofinstall]','$_POST[chequeno]','$_POST[receipt]','$_POST[cname]','$_POST[address]','$premiumdate','$_POST[agent_code]', '$_POST[date]','$_POST[agent_name]','$convertvalue','$_POST[maturitydate]','$_POST[select]','$_POST[plantime]','$_POST[jdate]', '$_POST[jmonth]', '$_POST[jyear]','$_POST[cname]','$_POST[village]','$_POST[post]','$_POST[distt]','$_POST[state]','$_POST[pin]','$_POST[fd]','$ndate','$nmonth','$nyear','$_POST[mcode]','$_POST[applicationno1]','$mainamount','$mdate','$_POST[mcode]','$plantime','$_POST[fname]','$_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"><h2>Uthan Micro Credit Federation </h2></td>
</tr>
<tr>
<td align="center">Chandmari Imaliya, Near DIET MAU NATH BHANJAN, MAU</td>
</tr>
<tr>
<td align="center">MOBILE :08423524678</td>
</tr>
<tr>
<td align="center">EMAIL : ramkritrajbhar@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="229" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receipt] ?></td>
<td width="142" align="left" bgcolor="#EBEBEB"><strong>Print 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"><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[village]. " ".$_POST[post]." ". $_POST[distt]. " ".$_POST[pin] ?>
<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 $aaamount ?></td>
<td align="left"><strong>Amount In Word</strong></td>
<td align="left"><?php echo $convertvalue ?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"><strong>Deposit Date</strong></td>
<td align="left"><?php echo $regdate ?></td>
</tr>
<tr>
<td align="left"><strong>Application No</strong></td>
<td align="left"><?php echo $_POST[applicationno] ?></td>
<td align="left"><strong>Next Due Date</strong></td>
<td align="left"><?php echo $premiumdate ?></td>
</tr>
<tr>
<td align="left"><strong>Account No</strong></td>
<td align="left"><?php echo $_POST[account] ?></td>
<td align="left"><strong>Plan Period</strong></td>
<td align="left"><?php echo $_POST[plantime]."Years" ?></td>
</tr>
<tr>
<td align="left"><strong>Plan Name</strong></td>
<td align="left"><?php echo $_POST[select] ?></td>
<td align="left"><strong>Installment No</strong></td>
<td align="left"><?php echo $_POST[noofinstall] ?></td>
</tr>
<tr>
<td align="left"><strong>Deposit By</strong></td>
<td align="left"><?php echo $_POST[depositby] ?></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"><strong></strong></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"> </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="left" bgcolor="#B1AEAE">Authorised Signatory</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"><h2>Uthan Micro Credit Federation </h2></td>
</tr>
<tr>
<td align="center">Chandmari Imaliya, Near DIET MAU NATH BHANJAN, MAU</td>
</tr>
<tr>
<td align="center">MOBILE :08423524678</td>
</tr>
<tr>
<td align="center">EMAIL : ramkritrajbhar@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="229" align="left" bgcolor="#EBEBEB"><?php echo $_POST[receipt] ?></td>
<td width="142" align="left" bgcolor="#EBEBEB"><strong>Print 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"><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[village]. " ".$_POST[post]." ". $_POST[distt]. " ".$_POST[pin] ?>
<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 $aaamount ?></td>
<td align="left"><strong>Amount In Word</strong></td>
<td align="left"><?php echo $convertvalue ?></td>
</tr>
<tr>
<td align="left"> </td>
<td align="left"> </td>
<td align="left"><strong>Deposit Date</strong></td>
<td align="left"><?php echo $regdate ?></td>
</tr>
<tr>
<td align="left"><strong>Application No</strong></td>
<td align="left"><?php echo $_POST[applicationno] ?></td>
<td align="left"><strong>Next Due Date</strong></td>
<td align="left"><?php echo $premiumdate ?></td>
</tr>
<tr>
<td align="left"><strong>Account No</strong></td>
<td align="left"><?php echo $_POST[account] ?></td>
<td align="left"><strong>Plan Period</strong></td>
<td align="left"><?php echo $_POST[plantime]."Years" ?></td>
</tr>
<tr>
<td align="left"><strong>Plan Name</strong></td>
<td align="left"><?php echo $_POST[select] ?></td>
<td align="left"><strong>Installment No</strong></td>
<td align="left"><?php echo $_POST[noofinstall] ?></td>
</tr>
<tr>
<td align="left"><strong>Deposit By</strong></td>
<td align="left"><?php echo $_POST[depositby] ?></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"><strong></strong></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"> </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="left" bgcolor="#B1AEAE">Authorised Signatory</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.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>
|