<style>
#lc_table
{font-size:12px;color:#333333;width:100%;border-width: 1px;border-color: #729ea5;border-collapse: collapse;}
#lc_table th {border-color: #729ea5;font-size:12px;background-color:#acc8cc;border-width: 1px;padding:1px;border-style: solid;text-align:left;width}
#lc_table tr {background-color:white; border-color: #729ea5}
#lc_table td {font-size:12px;border-width: 1px;border-style: solid;border-color: #729ea5;}
#lc_table tfoot tr td {padding:5px 5px 5px 5px;background-color:#acc8cc }
</style>
<script type="text/javascript">
$(document).ready(function(){
$('tr').click(function(){
$('myModal').modal('show')
});
}); prepare($query); $result->execute(array($vw_interest)); $row = $result -> fetch(PDO::FETCH_NUM); $lc_no = $row[0]; ?> Interest List
<div style="width:auto;height:300x;border-bottom:1px solid #B2DFEE;overflow-y:scroll;">
<form id="myform2" name="myform2" action="interest_view.php" method="get">
<table id="lc_table" style="border:1px solid;">
# Interest Amount (USD) Conversion Rate Interest Amount (Php) 2% EWT Opening Charges 2% EWT Bank Guarantee 2% EWT Other Bank Charges 2% EWT Notary Fee 2307 Control No Doc Stamps Fee OR No Cable Fee Internal No ADV Back Amount Final TND
</tr>
<?php
$ctr = 0;
$query2 = "select interest_no, date_format(date_paid, '%m/%d/%Y'), status_id, principal_no, format(dollar_interest_amount,2), conversion_rate, format(interest_amount,2), interest_ewt,
opening_charges, opening_charges_ewt, bank_guaranty, bank_guaranty_ewt, other_bc, bc_ewt, notary_fee, controlno, doc_stamps_fee, or_no, cable_fee, internal_no, adv, back_amount, final_tnd,
start_date, end_date
from lc_interest WHERE principal_no = ?";
$result2=$db->prepare($query2);
$result2->execute(array($vw_interest));
$count=$result2->rowCount();
while ($row2=$result2->fetch(PDO::FETCH_NUM))
{
//onClick="DoNav('interest_view.php?interest_id=<?php echo $row2[0];,target='_blank'
//window.open('interest_view.php?interest_id=<?php echo $row2[0];&vw_interest=<?php echo $row2[0];,target='_self')
//onclick="DoNav('interest_view.php?interest_id=<?php echo $row2[0];,target='_blank'"
$ctr = $ctr + 1;
?>
<tr class="easyui-tooltip" id="<?php echo $row2[0];?>" title="Click to edit interest" >
<td style="width:2%; text-align:center;"><?php echo $ctr; ?></td>
<td style="width:7%; text-align:right;"><?php echo $row2[4]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[5];?></td>
<td style="width:7%; text-align:right;"><?php echo $row2[6]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[7]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[8]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[9]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[10]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[11]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[12]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[13]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[14]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[15]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[16]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[17]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[18]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[19]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[20]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[21]; ?></td>
<td style="width:5%; text-align:center;"><?php echo $row2[22]; ?></td>
</tr>
<?}?>
</table>
</div>
</form>
</div>
$interest_id = $_GET['interest_id']; if ($interest_id){ $int = "modal:true,closed:false"; } else { $int = "modal:true,closed:true"; } $sql = "SELECT interest_no, interestusd, conversionrate, interestphp, interestphp_ewt, openingcharges, openingcharges_ewt, bankguarantee, bankguarantee_ewt, otherbankcharges, otherbankcharges_ewt, notaryfee, ctrlno2307, docstamps, orno, cablefee, internalno, adv, backamount, finaltnd FROM lc_interest WHERE interest_no = ?"; $result = $db -> prepare($sql); $result -> execute(array($interest_id)); $row = $result -> fetch(PDO::FETCH_NUM); for ($i = 0; $i < 20; $i++){ $object[$i] = $row[$i]; }
?> INTEREST DETAILS "> Interest Amount (USD) : "> Conversion Rate : "> Interest Amount (Php) : "> 2% EWT : "> Opening Charges : "> 2% EWT : "> Bank Guarantee : "> 2% EWT : "> Other Bank Charges : "> 2% EWT : "> Notary Fee : "> 2307 Control No : "> Doc Stamps Fee : "> OR No : "> Cable Fee : "> Internal No : "> ADV : "> Back Amount : "> Final TND : "> Reset
Aucun commentaire:
Enregistrer un commentaire