001. <?php Include_once ("../pizzamobile/db/connectDatabase.php");
002.
003. if ($buttonss6=="ค้นหา")
004. {
005.
006.
007. }else{
008.
009.if($_POST['date1']!=""){
010.$date11=$_POST['date1'];}
011.else{ $date11=date('Y-m-d');}
012.$ye11=substr($date11, 0, 4);
013.$mo11=substr($date11, 5, 2);
014.$dd11=substr($date11, 8, 2);
015.$dateser1=$ye11."-".$mo11."-01";
016.$dateser2=$ye11."-".$mo11."-31";
017.
018. $rs="'RS'";
019. $cc="'cancle'";
020.
021. $strSQLxx99 = "SELECT booking.*, sfcar1.*, modelcar2.*, modelcar1.* FROM booking
022.
023. LEFT JOIN sfcar1 ON booking.sfcar1 = sfcar1.idsfcar1
024. LEFT JOIN modelcar2 ON sfcar1.idmodelcar2 = modelcar2.idmodelcar2
025. LEFT JOIN modelcar1 ON modelcar2.idmodelcar1 = modelcar1.idmodelcar1
026. where booking.marginkid11 between '$dateser1' and '$dateser2' and booking.statusbook =$rs order by modelcar1.idmodelcar1 asc , sfcar1.idsfcar1 asc ";
027.
028. $objQueryxx99 = mysql_query($strSQLxx99) or die ("Error Query [".$strSQLxx99."]");
029. $num_rowsxx99 = mysql_num_rows($objQueryxx99);
030. }
031.
032.
033. ?>
034. <?php while($objResultxx99 = mysql_fetch_array($objQueryxx99))
035. {
036.
037. if($objResultxx99["idmodelcar1"]=="M1001"){$camryQAAB1234++; }
038. else if($objResultxx99["idmodelcar1"]=="M1002"){$altisQAAB1234++; }
039. else if($objResultxx99["idmodelcar1"]=="M1003"){$viosQAAB1234++; }
040. else if($objResultxx99["idmodelcar1"]=="M1004"){$yarisQAAB1234++; }
041. else if($objResultxx99["idmodelcar1"]=="M1023"){$yarisaQAAB1234++; }
042. else if($objResultxx99["idmodelcar1"]=="M1021"){$sientaQAAB1234++; }
043. else if($objResultxx99["idmodelcar1"]=="M1005" or $objResultxx99["idmodelcar1"]=="M1006" or $objResultxx99["idmodelcar1"]=="M1007" or $objResultxx99["idmodelcar1"]=="M1022"){$orpcQAAB1234++; }
044. else if($objResultxx99["idmodelcar1"]=="M1008" or $objResultxx99["idmodelcar1"]=="M1009"){$bcQAAB1234++; }
045. else if($objResultxx99["idmodelcar1"]=="M1010"){$cc42QAAB1234++; }
046. else if($objResultxx99["idmodelcar1"]=="M1011"){$cc24QAAB1234++; }
047. else if($objResultxx99["idmodelcar1"]=="M1012"){$cc44QAAB1234++; }
048. else if($objResultxx99["idmodelcar1"]=="M1013"){$dc42QAAB1234++; }
049. else if($objResultxx99["idmodelcar1"]=="M1014"){$dc24QAAB1234++; }
050. else if($objResultxx99["idmodelcar1"]=="M1015"){$dc44QAAB1234++; }
051. else if($objResultxx99["idmodelcar1"]=="M1016" or $objResultxx99["idmodelcar1"]=="M1017" or $objResultxx99["idmodelcar1"]=="M1019"){$forQAAB1234++; }
052. else if($objResultxx99["idmodelcar1"]=="M1018"){$hiaceQAAB1234++; }
053.
054.
055.
056.
057.
058.
059. }
060.$kangQAA123434=$camryQAA1234+$altisQAA1234+$viosQAA1234+$yarisQAA1234+$yarisaQAA1234+$sientaQAA1234+$orpcQAA1234;
061. $kangQAAB1234=$camryQAAB1234+$altisQAAB1234+$viosQAAB1234+$yarisQAAB1234+$yarisaQAAB1234+$sientaQAAB1234+$orpcQAAB1234;
062. $kbQAA123434=$bcQAA1234+$cc42QAA1234+$cc24QAA1234+$cc44QAA1234+$dc42QAA1234+$dc24QAA1234+$dc44QAA1234+$bcQAAB1234+$cc42QAAB1234+$cc24QAAB1234+$cc44QAAB1234+$dc42QAAB1234+$dc24QAAB1234+$dc44QAAB1234;
063. $for1234=$forQAA1234+$forQAAB1234;
064. $hiace1234=$hiaceQAA123434+$hiaceQAAB1234;
065. $orther1234=$ortherQAA123434+$ortherQAAB1234;
066. $allQAA123434=$forQAA1234+$hiaceQAA123434+$ortherQAA123434+$kangQAA123434+$kbQAA123434;
067.
068. $allQAAB1234=$forQAAB1234+$hiaceQAAB1234+$ortherQAAB1234+$kangQAAB1234+$kbQAAB1234;
069. $all1234=$allQAA123434+$allQAAB1234;
070.?>
071. </b></p>
072. <table width="1000" border="1">
073. <tbody>
074. <tr>
075. <td colspan="19" bgcolor="#F4CF35">ชำระครบ/RS
076. <?php $ho2="'Deler'";
077. $strSQL1214999 = "SELECT * FROM login where cat=$ho2 ";
078. $objQuery1214999 = mysql_query($strSQL1214999) or die ("Error Query [".$strSQL1214999."]");
079. $objResultxx991214999 = mysql_fetch_array($objQuery1214999);
080. echo $objResultxx991214999['username'] ?></td>
081. </tr>
082. <tr>
083. <td rowspan="2">ชำระครบ/RS</td>
084. <td colspan="7" bgcolor="#6AF4DC">เก๋ง</td>
085. <td colspan="7" bgcolor="#F39A9B">กระบะ</td>
086. <td rowspan="2" bgcolor="#6AF4DC">Fortner</td>
087. <td rowspan="2" bgcolor="#F39A9B">Hiage</td>
088. <td rowspan="2" bgcolor="#6AF4DC">Orther</td>
089. <td rowspan="2" bgcolor="#F3AD84">TTL</td>
090. </tr>
091. <tr>
092. <td bgcolor="#6AF4DC">Camry</td>
093. <td bgcolor="#6AF4DC">Corolla</td>
094. <td bgcolor="#6AF4DC">Vios</td>
095. <td bgcolor="#6AF4DC">Yaris</td>
096. <td bgcolor="#6AF4DC">Sienta</td>
097. <td bgcolor="#6AF4DC">Yaris ATIV</td>
098. <td bgcolor="#6AF4DC">Orther-Pc</td>
099. <td bgcolor="#F39A9B">RevoB</td>
100. <td bgcolor="#F39A9B">RevoC 4x2</td>
101. <td bgcolor="#F39A9B">RevoC 2x4</td>
102. <td bgcolor="#F39A9B">RevoC 4x4</td>
103. <td bgcolor="#F39A9B">RevoD 4x2</td>
104. <td bgcolor="#F39A9B">RevoD 2x4</td>
105. <td bgcolor="#F39A9B">RevoD 4x4</td>
106. </tr>
107. <tr>
108. <td>ชำระครบ/RS</td>
109. <td bgcolor="#A6A4A4"><input name="baookrsrs1" type="text" id="baookrsrs1" size="5" value="<?php echo $camryQAAB1234; ?>" readonly></td>
110. <td bgcolor="#A6A4A4"><input name="baookrsrs2" type="text" id="baookrsrs2" size="5" value="<?php echo $altisQAAB1234; ?>" readonly></td>
111. <td bgcolor="#A6A4A4"><input name="baookrsrs3" type="text" id="baookrsrs3" size="5" value="<?php echo $viosQAAB1234; ?>" readonly></td>
112. <td bgcolor="#A6A4A4"><input name="baookrsrs4" type="text" id="baookrsrs4" size="5" value="<?php echo $yarisQAAB1234; ?>" readonly></td>
113. <td bgcolor="#A6A4A4"><input name="baookrsrs5" type="text" id="baookrsrs5" size="5" value="<?php echo $sientaQAAB1234; ?>" readonly></td>
114. <td bgcolor="#A6A4A4"><input name="baookrsrs6" type="text" id="baookrsrs6" value="<?php echo $yarisaQAAB1234; ?>" size="5" readonly></td>
115. <td bgcolor="#A6A4A4"><input name="baookrsrs7" type="text" id="baookrsrs7" size="5" value="<?php echo $orpcQAAB1234; ?>" readonly></td>
116. <td bgcolor="#A6A4A4"><input name="baookrsrs8" type="text" id="baookrsrs8" size="5" value="<?php echo $bcQAAB1234; ?>" readonly></td>
117. <td bgcolor="#A6A4A4"><input name="baookrsrs9" type="text" id="baookrsrs9" size="5" value="<?php echo $cc42QAAB1234; ?>" readonly></td>
118. <td bgcolor="#A6A4A4"><input name="baookrsrs10" type="text" id="baookrsrs10" size="5" value="<?php echo $cc24QAAB1234; ?>" readonly></td>
119. <td bgcolor="#A6A4A4"><input name="baookrsrs11" type="text" id="baookrsrs11" size="5" value="<?php echo $cc44QAAB1234; ?>" readonly></td>
120. <td bgcolor="#A6A4A4"><input name="baookrsrs12" type="text" id="baookrsrs12" size="5" value="<?php echo $dc42QAAB1234; ?>" readonly></td>
121. <td bgcolor="#A6A4A4"><input name="baookrsrs13" type="text" id="baookrsrs13" size="5" value="<?php echo $dc24QAAB1234; ?>" readonly></td>
122. <td bgcolor="#A6A4A4"><input name="baookrsrs14" type="text" id="baookrsrs14" size="5" value="<?php echo $dc44QAAB1234; ?>" readonly></td>
123. <td bgcolor="#A6A4A4"><input name="baookrsrs15" type="text" id="baookrsrs15" size="5" value="<?php echo $forQAAB1234; ?>" readonly></td>
124. <td bgcolor="#A6A4A4"><input name="baookrsrs16" type="text" id="baookrsrs16" size="5" value="<?php echo $hiaceQAAB1234; ?>" readonly></td>
125. <td bgcolor="#A6A4A4"><input name="baookrsrs17" type="text" id="baookrsrs17" size="5" value="<?php echo $ortherQAAB1234; ?>" readonly></td>
126. <td bgcolor="#F3AD84"><input name="baookrsrstt1" onFocus="sum()" onBlur="sum()" onKeyPress="return KeyNum_dot(this)" onKeyUp="sum()" type="text" id="baookrsrstt1" size="5" ></td>
127. </tr>
128. <tr>
129. <td bgcolor="#F3AD84">รวมแยกประเภท</td>
130. <td colspan="7" bgcolor="#F3AD84"><input name="baookrsrstt3" type="text" id="baookrsrstt3" size="5" ></td>
131. <td colspan="7" bgcolor="#F3AD84"><input name="baookrsrstt4" type="text" id="baookrsrstt4" size="5" ></td>
132. <td bgcolor="#F3AD84"><input name="baookrsrs18" type="text" id="baookrsrs18" size="5" value="<?php echo $forQAAB1234; ?>" ></td>
133. <td bgcolor="#F3AD84"><input name="baookrsrs19" type="text" id="baookrsrs19" size="5" value="<?php echo $hiaceQAAB1234; ?>" ></td>
134. <td bgcolor="#F3AD84"><input name="baookrsrs20" type="text" id="baookrsrs20" size="5" value="<?php echo $ortherQAAB1234; ?>" ></td>
135. <td bgcolor="#F3AD84"><input name="baookrsrstt2" type="text" id="baookrsrstt2" size="5" ></td>
136. </tr>
137. </tbody>
138. </table>
