001.<?php
002.include "connect.php";
003.?>
004.<html>
005.<head>
006.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
007.<title>usage_check</title>
008.<script type="text/javascript">
009.function MM_swapImgRestore() {
010. var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
011.}
012.function MM_preloadImages() {
013. var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
014. var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
015. if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
016.}
017.
018.function MM_findObj(n, d) {
019. var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
020. d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
021. if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
022. for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
023. if(!x && d.getElementById) x=d.getElementById(n); return x;
024.}
025.
026.function MM_swapImage() {
027. var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
028. if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
029.}
030.</script>
031.</head>
032.
033.<body onLoad="MM_preloadImages('/multifunction/indexC_03.jpg','/multifunction/indexC_04.jpg','/multifunction/indexC_05.jpg','/multifunction/indexC_06.jpg','/multifunction/indexC_07.jpg')">
034.<table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
035. <tr>
036. <td colspan="7"><img src="/multifunction/index_01.jpg" width="960" height="244" /></td>
037. </tr>
038. <tr>
039. <td><img src="/multifunction/index_02.jpg" width="176" height="49" /></td>
040. <td><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image14','','/multifunction/indexC_03.jpg',1)"><img src="/multifunction/index_03.jpg" alt="home" name="Image14" width="46" height="49" border="0" id="Image14" /></a></td>
041. <td><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image15','','/multifunction/indexC_04.jpg',1)"><img src="/multifunction/index_04.jpg" alt="servioes requesition" name="Image15" width="81" height="49" border="0" id="Image15" /></a></td>
042. <td><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image16','','/multifunction/indexC_05.jpg',1)"><img src="/multifunction/index_05.jpg" alt="e-learning" name="Image16" width="96" height="49" border="0" id="Image16" /></a></td>
043. <td><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image17','','/multifunction/indexC_06.jpg',1)"><img src="/multifunction/index_06.jpg" alt="tpie-tricks" name="Image17" width="98" height="49" border="0" id="Image17" /></a></td>
044. <td><a href="#" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image18','','/multifunction/indexC_07.jpg',1)"><img src="/multifunction/index_07.jpg" name="Image18" width="84" height="49" border="0" id="Image18" /></a></td>
045. <td><img src="/multifunction/index_08.jpg" width="379" height="49" /></td>
046. </tr>
047. <tr>
048.
049. <td> </td>
050. <td colspan="2"> </td>
051. <td> </td>
052. <td> </td>
053. <td> </td>
054. <td> </td>
055. </tr>
056. <tr>
057. <td colspan="7"><?php
058. $conn->open($sql);
059. $rs = $conn->execute("SELECT DISTINCT a.* FROM TB_ALL_Usage Chage a where (a.Center like '%". str_replace(" ","",$_POST["center_no"]) ."%') order by a.Month ");?></td>
060. </tr>
061. <tr>
062. <td colspan="7"><table width="894" border="1" align="center" cellpadding="0" cellspacing="0">
063. <tr>
064. <th width="87" scope="col"><img src="Header_Table(900)_01.jpg" width="87" height="72" /></th>
065. <th colspan="4" scope="col"><img src="Header_Table(900)_02.jpg" width="183" height="72" /></th>
066. <th colspan="4" scope="col"><img src="Header_Table(900)_03.jpg" width="186" height="72" /></th>
067. <th width="123" scope="col"><img src="Header_Table(900)_04.jpg" width="123" height="72" /></th>
068. <th colspan="4" scope="col"><img src="Header_Table(900)_05.jpg" width="190" height="72" /></th>
069. <th width="111" scope="col"><img src="Header_Table(900)_06.jpg" width="111" height="72" align="left" /></th>
070. </tr>
071. <?php while (!$rs->EOF) {
072. if($rs!=''){
073. ?>
074. <tr>
075. <td><?php echo $rs['Date'] ; ?> </td>
076. <td width="45"><?php echo number_format($rs['CopyBlackSmall'],0,"",","); $total_CopyBlackSmall+=$rs['CopyBlackSmall'];?></td>
077. <td width="44"><?php echo number_format($rs['CopyBlackLange'],0,"",","); $total_CopyBlackLange+=$rs['CopyBlackLange'];?></td>
078. <td width="45"><?php echo number_format($rs['CopyColorA3'],0,"",","); $total_CopyColorA3+=$rs['CopyColorA3'];?></td>
079. <td width="43"><?php echo number_format($rs['CopyColorA4'],0,"",","); $total_CopyColorA4+=$rs['CopyColorA4'];?></td>
080. <td width="45"><?php echo $rs['PrintBlackSmall'] ; $total_PrintBlackSmall+=$rs['PrintBlackSmall'] ; ?></td>
081. <td width="44"><?php echo $rs['PrintBlackLange'] ; $total_PrintBlackLange+=$rs['PrintBlackLange'] ; ?></td>
082. <td width="47"><?php echo $rs['PrintColorA3'] ; ?></td>
083. <td width="44"><?php echo $rs['PrintColorA4'] ; ?></td>
084. <td><?php echo $rs['TotalUsageChage'] ; ?></td>
085. <td width="45"><?php echo $rs['PrintBlackSmall']; ?></td>
086. <td width="45"><?php echo $rs['PriceBlackLange'] ; ?></td>
087. <td width="48"><?php echo $rs['PriceColorA3'] ; ?></td>
088. <td width="46"><?php echo $rs['PriceColorA4'] ; ?></td>
089. <td><?php echo $rs['TotalPrice'] ; ?></td>
090. </tr>
091. <?php }else { ?>
092.
093. <td colspan="15"> </td>
094.
095. <?php $rs->Close() ;
096. $conn->Close() ;
097. }
098. }
099. ?>
100. </table>
101. <p> </p>
102. <p> </p></td>
103. </tr>
104.
105.
106.
107. <tr>
108. <td> </td>
109. <td colspan="2"> </td>
110. <td> </td>
111. <td> </td>
112. <td> </td>
113. <td> </td>
114. </tr>
115. <tr>
116. <td> </td>
117. <td colspan="2"> </td>
118. <td> </td>
119. <td> </td>
120. <td> </td>
121. <td> </td>
122. </tr>
123. <tr>
124. <td colspan="7" bgcolor="#FFFFFF"><img src="/multifunction/index_24.jpg" width="960" height="39" /></td>
125. </tr>
126.</table>
127.</body>
128.</html>
Quote:
