 |
|
Code (PHP)
<!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=iso-8859-1" />
<title>Untitled Document</title>
</head>
<body>
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#333333">
<tr>
<td height="25" align="center" bgcolor="#EEEEEE" width="5%" rowspan="2"> ที่ </td>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%" rowspan="2"> ว/ด/ป </td>
<td height="25" align="center" bgcolor="#EEEEEE" colspan="2"> หุ้นที่ชำระแล้ว </td>
<td height="25" align="center" bgcolor="#EEEEEE" colspan="2"> หุ้นที่ถอน</td>
<td height="25" align="center" bgcolor="#EEEEEE" colspan="2"> หุ้นคงเหลือ </td>
</tr>
<tr>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%">หุ้น</td>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%">บาท</td>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%">หุ้น</td>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%">บาท</td>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%">หุ้น</td>
<td height="25" align="center" bgcolor="#EEEEEE" width="10%">บาท</td>
</tr>
<?
$queryReport=$db->odb_query($sqlReport);
$getCountReport = $db->odb_get_data_field(" select count(t_print_book.Memberid) AS datas from t_print_book where trim( t_print_book.Memberid ) = '".$ls_membc."' AND isstatus = 'O' AND t_print_book.trantype IN ('REC','TRN') ","datas") ;
$countInReport =0;
$countAll =0;
while($resReport = $db->odb_fetch_array($queryReport)){
if($resReport[isstatus] != 'P'){
$countAll++;
}
if($resReport[isstatus] == 'N'){
(++$countInReport);
?>
<tr>
<td height="25" align="right" bgcolor="#FFFFFFF"> <?=$countAll?></td>
<td height="25" align="center" bgcolor="#FFFFFFF">
<?=$_arrayCryreport['trandate'][$resReport[lineid]] =(substr($resReport[trandate],0,2)."/".substr($resReport[trandate],2,2)."/".substr($resReport[trandate],4,4)) ;?> </td>
<td height="25" align="right" bgcolor="#FFFFFFF"><?=$_arrayCryreport['show_dueAmt'][$resReport[lineid]] =number_format(@($resReport[dueamt]/$lm_sharerate),0)?> </td>
<td height="25" align="right" bgcolor="#FFFFFFF"><?=$_arrayCryreport['show_allDueAmt'][$resReport[lineid]] =number_format(@($resReport[dueamt]),2)?> </td>
<td height="25" align="right" bgcolor="#FFFFFFF"><?=$_arrayCryreport['show_dueAmt'][$resReport[lineid]] =number_format(@($resReport[dueamt]/$lm_sharerate),0)?></td>
<td height="25" align="right" bgcolor="#FFFFFFF"><?=$_arrayCryreport['show_allDueAmt'][$resReport[lineid]] =number_format(@($resReport[dueamt]),2)?></td>
<td height="25" align="right" bgcolor="#FFFFFFF"><?=$_arrayCryreport['show_balanceAmt'][$resReport[lineid]] =number_format(@($resReport[balanceamt]/$lm_sharerate),0)?> </td>
<td height="25" align="right" bgcolor="#FFFFFFF"><?=$_arrayCryreport['show_allBalanceAmt'][$resReport[lineid]] =number_format(@($resReport[balanceamt]),2)?> </td>
</tr>
<?
}
}
?>
</table>
</body>
</html>
code ที่เขียนมาได้แบบรูปภาพ อยากให้ออกรายงานตามภาพข้างล่างต้องแก้ไขตรงไหนครับ
Tag : Mobile, MySQL, Mobile
|
ประวัติการแก้ไข
2019-07-01 16:25:39
|
 |
 |
 |
 |
| Date :
2019-07-01 16:11:14 |
By :
panyaadd |
View :
781 |
Reply :
1 |
|
 |
 |
 |
 |
|
|
|
|
 |
