��������´㹡�ê����Թ���
**** �����ҹ�������ٻẺ �Դ����Դ���ԡ��WebOnline������¸�á��
����-ʡ�� : echo $memb_name ;?> echo $memb_surname ;?> �Ţ����¹ : echo $username ;?>
����鹡Ѻ�ˡó� �ӹǹ echo $sharestk_amt;?> �ҷ
��˹������Ѻ�ˡó�
include("_lib/connectdb.php");?>
/***************************** ???????? **********************************/
$sql = " SELECT
distinct lncontmaster.loancontract_no,
lncontmaster.period_payment,
lncontmaster.loanapprove_amt,
lncontmaster.loantype_code,
lncontmaster.principal_balance,
lnloantype.loantype_desc
FROM lncontmaster,
mbmembmaster,
lnloantype
WHERE ( lncontmaster.member_no = mbmembmaster.member_no ) and
lncontmaster.principal_balance >0 and lncontmaster.loantype_code = lnloantype.loantype_code and
( ( mbmembmaster.member_no ='$username' ) ) and mbmembmaster.web_code = '$id' ";
//mysql_query("set names 'tis620'");
//$dbquery48=mysql_query( $sql,$dbconnect );
//$sql_result =mysql_fetch_array($dbquery48);
//$nrow=0;
//$nrow=mysql_num_rows($dbquery48);
$cursor = oci_parse ($conn, $sql);
$result = oci_execute ($cursor);
$nrow = 0;
$sum_principle_balance=0.00;
while($sql_result = oci_fetch_array($cursor)){
$nrow++;
$sum_principle_balance+= $sql_result[4];
}
//echo $nrow;
//$nrow = $nrow - 1;
$sum_ttoperiod_payment = $sum_operiod_payment + $emi ;
$sum_ttoperiod_payment= number_format($sum_ttoperiod_payment ,2,'.',',');
$sum_principle_balance9= number_format($sum_principle_balance ,2,'.',',');
//$dbquery48=mysql_query( $sql,$dbconnect );
//$sql_result =mysql_fetch_array($dbquery48);
$cursor = oci_parse ($conn, $sql);
$result = oci_execute ($cursor);
$sum_ttoperiod_payment = $sum_operiod_payment*1000 + $emi ;
$sum_ttoperiod_payment9= number_format($sum_ttoperiod_payment ,2,'.',',');
?>
��������� echo $sum_principle_balance9;?> �ҷ
���ǧ�Թ��� 0.00 �ҷ
�觪��������͹(����) ���������͹ 0.00 �ҷ/�Ǵ �ӹǹ �Ǵ
������������Թ���
1. ��Ҫԡ���Թ��͹ 0.00 �ҷ �·�ǧ�Թ������ǵ�ͧ���Թ��͹������� 17 %
�ѧ��� ��Ҫԡ����ö��� �§��觪�������Թ 0.00 �ҷ
2.
��������������
��Ҫԡ���������Ѻ�ˡó���������� echo $sharestk_amt ;?> �ҷ
*** ��Ҫԡ�е�ͧ�դ����� 20%
��Ҫԡ����ǧ�Թ������ echo number_format(($sum_principle_balance)+(@$_POST['amount'])-($loan1+$loan2+$loan3+$loan4+$loan5),2) ; ?> �ҷ
***
�� 20%�ͧǧ�Թ��� ��Ҫԡ�е�ͧ�դ���������ӡ��� echo number_format(((($sum_principle_balance)+(@$_POST['amount'])-($loan1+$loan2+$loan3+$loan4+$loan5))*0.2),2) ; ?> �ҷ
3. ��Ҫԡ�ˡó�ϻ��ʧ���