API tools faq
paste
Advertisement
Guest User

P'NOOM

a guest
Jul 3rd, 2015
190
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 17.53 KB | None | 0 0
raw download clone embed print report
  1. admin_report.php
  2. <?php
  3. session_start();
  4. if($_SESSION['user_id'] == "")
  5. {
  6. echo "<center>Please Login !";
  7. echo "  <a href='index.php'>  
  8. <input type='button'value='Back'style='background:#3B59A8;  
  9. border:1px solid #000;color:#ffffff;font-weight:bold;'/></a>  
  10. </center>";  
  11. exit();
  12. }
  13.  
  14. if($_SESSION['user_status'] != "98")
  15. {
  16. echo "<center>This page for admin only !";
  17. echo "  <a href='index.php'>  
  18. <input type='button'value='Back'style='background:#3B59A8;  
  19. border:1px solid #000;color:#ffffff;font-weight:bold;'/></a>  
  20. </center>";
  21. exit();
  22. }  
  23. mysql_connect("localhost","root","1234");
  24. mysql_select_db("car");
  25. mysql_query('SET NAMES UTF8');
  26. $strSQL = "SELECT * FROM user WHERE user_id = '".$_SESSION['user_id']."' ";
  27. $objQuery = mysql_query($strSQL);
  28. $objResult = mysql_fetch_array($objQuery);
  29. ?>
  30.  
  31. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  32. <html xmlns="http://www.w3.org/1999/xhtml">
  33. <head>
  34. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  35. <title>::   Admin Site   ::</title>
  36. <script type="text/javascript">
  37. function MM_preloadImages() { //v3.0
  38.   var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
  39.     var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
  40.     if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
  41. }
  42. function MM_swapImgRestore() { //v3.0
  43.   var i,x,a=document.MM_sr; for(i=0;a&&i<a.length&&(x=a[i])&&x.oSrc;i++) x.src=x.oSrc;
  44. }
  45. function MM_findObj(n, d) { //v4.01
  46.   var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
  47.     d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  48.   if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  49.   for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  50.   if(!x && d.getElementById) x=d.getElementById(n); return x;
  51. }
  52.  
  53. function MM_swapImage() { //v3.0
  54.   var i,j=0,x,a=MM_swapImage.arguments; document.MM_sr=new Array; for(i=0;i<(a.length-2);i+=3)
  55.    if ((x=MM_findObj(a[i]))!=null){document.MM_sr[j++]=x; if(!x.oSrc) x.oSrc=x.src; x.src=a[i+2];}
  56. }
  57. </script>
  58. <style type="text/css">
  59. body {
  60.     background-color: #999;
  61.     color: #FFF;
  62. }
  63. .style1 {font-size: 14px}
  64. </style>
  65. </head>
  66.  
  67. <body onload="MM_preloadImages('home_o.jpg','img/c_exit_o.jpg','img/c_back_o.jpg','img/c_rate_o.jpg')">
  68. <table width="835" height="960" border="0" align="center" cellpadding="0" cellspacing="0">
  69.   <tr>
  70.     <th height="320" colspan="2" valign="top" scope="row"><img src="img/R35H.jpg" width="850" height="320" /></th>
  71.   </tr>
  72.   <tr>
  73.     <th height="30" colspan="2" align="center" valign="middle" bgcolor="#CB0038" scope="row"><img src="img/line_admin.jpg" width="850" height="30" /></th>
  74.   </tr>
  75.   <tr>
  76.     <th height="19" colspan="2" align="left" bgcolor="#666666" scope="row">&nbsp; Username : <?php echo $objResult["user_name"];?> / Name : <?php echo $objResult["name"];?> &nbsp; &nbsp;[ <a href="logout.php">Logout</a> ] </th>
  77.   </tr>
  78.   <tr>
  79.     <th width="170" height="170" align="center" valign="middle" bgcolor="#CB0038" scope="row"><p><img src="myfile/<?php echo $objResult["picture"]; ?>" alt="" width="150" height="120"/></p></th>
  80.     <th width="680" height="324" rowspan="15" valign="top" bgcolor="#CCCCCC" scope="row"><table width="95%" border="0" align="center">
  81.       <tr>
  82.         <th scope="col"> <fieldset>
  83.           <table width="100%" border="0">
  84.             <tr>
  85.               <th colspan="8" bgcolor="#666666" scope="col"><table width="222" height="26" border="0" align="center">
  86.                   <tr>
  87.                     <td align="center" bgcolor="#666666">รายงานใบจองรถยนต์ </td>
  88.                   </tr>
  89.                 </table></th>
  90.             </tr>
  91.             <tr>
  92.               <th colspan="8" bgcolor="#666666" scope="col"><form id="form1" name="form1" method="post" action="?admin_report=show">
  93.                 <span class="style1"> วันที่ :</span>
  94.                 <label>
  95.                   <input name="date1" type="date" id="date1" />
  96.                   </label>
  97.                 -
  98.                 <label>
  99.                   <input name="date2" type="date" id="date2" />
  100.                   </label>
  101.                 <label>
  102.                   <input type="submit" name="Submit" value="ค้นหา" />
  103.                   </label>
  104.                 </form></th>
  105.             </tr>
  106.             <? if($_REQUEST['admin_report']=='show'){?>
  107.             <tr>
  108.               <th width="6%" bgcolor="#666666" class="style1" scope="col">ID</th>
  109.               <th width="13%" bgcolor="#666666" class="style1" scope="col">วันที่</th>
  110.               <th width="13%" bgcolor="#666666" class="style1" scope="col">สาขา</th>
  111.               <th width="15%" bgcolor="#666666" class="style1" scope="col">พนักงาน</th>
  112.               <th width="12%" bgcolor="#666666" class="style1" scope="col">รถ</th>
  113.               <th width="14%" bgcolor="#666666" class="style1" scope="col">รุ่นรถ</th>
  114.               <th width="14%" bgcolor="#666666" class="style1" scope="col">สีรถ</th>
  115.               <th width="13%" bgcolor="#666666" class="style1" scope="col">ดูข้อมูล</th>
  116.               </tr>
  117.             <? $sql = mysql_query ("select * from booking o where o.booking_id && o.booking_date between '$_REQUEST[date1]' AND '$_REQUEST[date2]'");
  118.            
  119.       $i = 1 ;
  120.       while ($show = mysql_fetch_assoc ($sql)){
  121.          
  122.       $total += $show[booking_branch];
  123.      
  124.      $cc += $show[booking_branch] == "สำนักงานใหญ่";
  125.      $mm += $show[booking_branch] == "เมืองใหม่";
  126.      $bb += $show[booking_branch] == "บางบอน";
  127.  
  128.         $objResult = mysql_fetch_array($objQuery)
  129.      
  130.       ?>
  131.             <tr>
  132.               <th bgcolor="#999999" class="style1" scope="col"><? echo $i++;?></th>
  133.               <th bgcolor="#999999" class="style1" scope="col"><? echo $show[booking_date];?></th>
  134.               <th bgcolor="#999999" class="style1" scope="col"><? echo $show[booking_branch];?></th>
  135.               <th bgcolor="#999999" class="style1" scope="col"><? echo $show[booking_person_name];?></th>
  136.               <th bgcolor="#999999" class="style1" scope="col"><? echo $show[categories];?></th>
  137.               <th bgcolor="#999999" class="style1" scope="col"><? echo $show[products];?></th>
  138.               <th bgcolor="#999999" class="style1" scope="col"><? echo $show[products_color];?></th>
  139.               <td align="center" bgcolor="#999999"><a href="admin_report_detail.php?booking_id=<?php echo $objResult["booking_id"];?>">ตรวจสอบ</a></td>
  140.               </tr>
  141.             <? }?>
  142.             <tr>
  143.               <th height="12" colspan="8" scope="col"><hr />
  144.                 <div align="right" class="style1">
  145.                   <table width="282" height="137" border="0" align="center">
  146.                     <tr>
  147.                       <td colspan="3" align="center" bgcolor="#666666">สรุปยอดการจอง</td>
  148.                     </tr>
  149.                     <tr>
  150.                       <td width="148" align="center" bgcolor="#666666">สาขาสำนักงานใหญ่</td>
  151.                       <td width="54" align="center" bgcolor="#999999"> <? echo number_format  ($cc);?></td>
  152.                       <td width="55" align="center" bgcolor="#666666">คัน</td>
  153.                     </tr>
  154.                     <tr>
  155.                       <td align="center" bgcolor="#666666">สาขาเมืองใหม่</td>
  156.                       <td align="center" bgcolor="#999999"> <? echo number_format($mm);?></td>
  157.                       <td align="center" bgcolor="#666666">คัน</td>
  158.                     </tr>
  159.                     <tr>
  160.                       <td height="26" align="center" bgcolor="#666666">สาขาบางบอน</td>
  161.                       <td align="center" bgcolor="#999999"> <? echo number_format($bb);?></td>
  162.                       <td align="center" bgcolor="#666666">คัน</td>
  163.                     </tr>
  164.                     <tr>
  165.                       <td height="24" align="center" bgcolor="#666666">รวมทั้งสิ้น</td>
  166.                       <td align="center" bgcolor="#999999"> <? echo number_format($i-1);?></td>
  167.                       <td align="center" bgcolor="#666666">คัน</td>
  168.                     </tr>
  169.                   </table>
  170.                   &nbsp;&nbsp;&nbsp;&nbsp;</div>
  171.                 <hr /></th>
  172.             </tr>
  173.             <tr>
  174.               <th height="12" colspan="8" scope="col">&nbsp;</th>
  175.             </tr>
  176.             <? }?>
  177.           </table>
  178.         </fieldset>
  179.         </th>
  180.       </tr>
  181.   </table>      <p>&nbsp;</p></th>
  182.   </tr>
  183.   <tr>
  184.     <th width="170" height="30" align="center" bgcolor="#CB0038" scope="row"><img src="img/c_rb_o.jpg" width="170" height="30" /></th>
  185.   </tr>
  186.   <tr>
  187.     <th height="30" align="center" valign="middle" bgcolor="#CB0038" scope="row"><a href="admin_report_car.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image9','','img/c_rate_o.jpg',1)"><img src="img/c_rate.jpg" alt="" width="170" height="30" id="Image9" /></a></th>
  188.   </tr>
  189.   <tr>
  190.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  191.   </tr>
  192.   <tr>
  193.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  194.   </tr>
  195.   <tr>
  196.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  197.   </tr>
  198.   <tr>
  199.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  200.   </tr>
  201.   <tr>
  202.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  203.   </tr>
  204.   <tr>
  205.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  206.   </tr>
  207.   <tr>
  208.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  209.   </tr>
  210.   <tr>
  211.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  212.   </tr>
  213.   <tr>
  214.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  215.   </tr>
  216.   <tr>
  217.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row">&nbsp;</th>
  218.   </tr>
  219.   <tr>
  220.     <th height="30" align="left" valign="top" bgcolor="#CB0038" scope="row"><a href="adminsite.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image8','','img/c_back_o.jpg',1)"><img src="img/c_back.jpg" width="170" height="30" id="Image8" /></a></th>
  221.   </tr>
  222.   <tr>
  223.     <th width="170" height="30" align="left" valign="top" bgcolor="#CB0038" scope="row"><a href="logout.php" onmouseout="MM_swapImgRestore()" onmouseover="MM_swapImage('Image7','','img/c_exit_o.jpg',1)"><img src="img/c_exit.jpg" width="170" height="30" id="Image7" /></a></th>
  224.   </tr>
  225.   <tr>
  226.     <td height="19" colspan="2" align="center" valign="middle" bgcolor="#666666" scope="row">Copyright © 2014 544234135 Pattarapon Lerdpakavanit 54/48 </td>
  227.   </tr>
  228. </table>
  229. <p>&nbsp;</p>
  230. <p>&nbsp; </p>
  231. </body>
  232. </html>
  233.  
  234. admin_report_detail.php
  235. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  236. <html xmlns="http://www.w3.org/1999/xhtml">
  237. <head>
  238. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  239. <title>Untitled Document</title>
  240. <style type="text/css">
  241. body {
  242.     background-color: #999;
  243. }
  244. body,td,th {
  245.     color: #FFF;
  246. }
  247. </style>
  248. </head>
  249.  
  250. <body>
  251. <table width="587" height="565" border="0" align="center">
  252.   <tr align="center" valign="middle">
  253.     <td align="center" valign="top"><form id="form1" name="form1" method="post" action="">
  254.       <p>
  255.         <?
  256. include("config3.php");
  257. $booking_id = $_GET['booking_id'];
  258. $sql="select * from $tb where booking_id=$booking_id";
  259.  
  260. echo $sql;
  261. $db_query = mysql_db_query($db,$sql);
  262. $result = mysql_fetch_array($db_query);
  263.  
  264. $categories = $result[categories];
  265. $products = $result[products];
  266. $products_color = $result[products_color];
  267. $booking_name = $result[booking_name];
  268. $booking_lastname = $result[booking_lastname];
  269. $booking_address = $result[booking_address];
  270. $booking_tel = $result[booking_tel];
  271. $booking_money = $result[booking_money];
  272. $booking_date = $result[booking_date];
  273. $booking_status = $result[booking_status];
  274. $booking_status = $result[booking_send];
  275. $booking_status = $result[booking_etc];
  276. ?>
  277.       </p>
  278.       <table width="587" border="1">
  279.         <tr>
  280.           <th bgcolor="#666666">รายละเอียดใบจอง</th>
  281.         </tr>
  282.       </table>
  283.       <table width="587" height="545" border="1">
  284.         <tr>
  285.           <td width="38%" align="center" valign="middle" bgcolor="#666666">รถที่จอง</td>
  286.           <td width="62%" align="left" valign="middle" bgcolor="#666666">:
  287.             <label for="textfield9"></label>
  288.             <label for="select2"></label>
  289.             <label for="select4">
  290.               <input name="categories" type="text" id="categories" value="<? echo"$categories";?>" readonly="readonly" />
  291.             </label></td>
  292.         </tr>
  293.         <tr>
  294.           <td align="center" valign="middle" bgcolor="#666666">รุ่นที่จอง</td>
  295.           <td align="left" valign="middle" bgcolor="#666666">:
  296.             <label for="select3"></label>
  297.             <label for="textfield10">
  298.               <input name="products" type="text" id="products" value="<? echo"$products";?>" readonly="readonly" />
  299.             </label></td>
  300.         </tr>
  301.         <tr>
  302.           <td align="center" valign="middle" bgcolor="#666666">สีที่จอง</td>
  303.           <td align="left" valign="middle" bgcolor="#666666">:
  304.             <label for="textfield11">
  305.               <input name="products_color" type="text" id="products_color" value="<? echo"$products_color";?>" readonly="readonly" />
  306.             </label></td>
  307.         </tr>
  308.         <tr>
  309.           <td align="center" valign="middle" bgcolor="#666666">ชื่อผู้จอง</td>
  310.           <td align="left" valign="middle" bgcolor="#666666">:
  311.             <label for="textfield12"></label>
  312.             <input name="booking_name" type="text" id="booking_name" value="<? echo"$booking_name";?>" readonly="readonly" /></td>
  313.         </tr>
  314.         <tr>
  315.           <td align="center" valign="middle" bgcolor="#666666">นามสกุลผู้จอง</td>
  316.           <td align="left" valign="middle" bgcolor="#666666">:
  317.             <label for="textfield13"></label>
  318.             <input name="booking_lastname" type="text" id="booking_lastname" value="<? echo"$booking_lastname";?>" size="20" maxlength="20" readonly="readonly" /></td>
  319.         </tr>
  320.         <tr>
  321.           <td align="center" valign="middle" bgcolor="#666666">ที่อยู่ผู้จอง</td>
  322.           <td align="left" valign="middle" bgcolor="#666666">:
  323.             <label for="textfield14"></label>
  324.             <label for="textarea"></label>
  325.             <textarea name="booking_address" cols="30" rows="3" readonly="readonly" id="booking_address"><? echo"$booking_address";?></textarea></td>
  326.         </tr>
  327.         <tr>
  328.           <td align="center" valign="middle" bgcolor="#666666">เบอร์โทรศัพท์</td>
  329.           <td align="left" valign="middle" bgcolor="#666666">:
  330.             <label for="select">
  331.               <input name="booking_tel" type="text" id="booking_tel" value="<? echo"$booking_tel";?>" size="10" maxlength="10" readonly="readonly" />
  332.             </label></td>
  333.         </tr>
  334.         <tr>
  335.           <td align="center" valign="middle" bgcolor="#666666">จำนวนเงินจอง</td>
  336.           <td align="left" valign="middle" bgcolor="#666666">:
  337.             <label for="textfield15"></label>
  338.             <input name="booking_money" type="text" id="booking_money" value="<? echo"$booking_money";?>" size="25" maxlength="25" readonly="readonly" /></td>
  339.         </tr>
  340.         <tr>
  341.           <td align="center" valign="middle" bgcolor="#666666">วันที่จอง</td>
  342.           <td valign="middle" bgcolor="#666666">:
  343.             <input name="booking_date" type="text" id="booking_date" value="<? echo"$booking_date";?>" readonly="readonly" /></td>
  344.         </tr>
  345.         <tr>
  346.           <td align="center" valign="middle" bgcolor="#666666">สถานะใบจอง</td>
  347.           <td align="left" valign="middle" bgcolor="#666666">:
  348.             <label for="select5"></label>
  349.             <font color="red">
  350.             <input name="booking_status" type="text" id="booking_status" value="<? echo"$booking_status";?>" readonly="readonly" />
  351.             </font></td>
  352.         </tr>
  353.         <tr>
  354.           <td align="center" valign="middle" bgcolor="#666666">วันส่งมอบรถ</td>
  355.           <td align="left" valign="middle" bgcolor="#666666">:
  356.             <font color="red">
  357.             <input name="booking_send" type="text" id="booking_send" value="<? echo"$booking_send";?>" readonly="readonly" />
  358.             </font></td>
  359.         </tr>
  360.         <tr>
  361.           <td align="center" valign="middle" bgcolor="#666666">อื่นๆ</td>
  362.           <td align="left" valign="middle" bgcolor="#666666">:            
  363.             <textarea name="booking_etc" cols="30" rows="3" readonly="readonly" id="booking_etc"><? echo"$booking_etc";?></textarea></td>
  364.         </tr>
  365.         <tr>
  366.           <td colspan="2" align="center" valign="middle" bgcolor="#666666"><input type="submit" name="close" id="close" value="Close" /></td>
  367.         </tr>
  368.       </table>
  369.       <p>&nbsp;</p>
  370.       <p>&nbsp;</p>
  371.     </form></td>
  372.   </tr>
  373. </table>
  374. </body>
  375. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!