Location: PHPKode > scripts > M-Ariza Maintenance Follow-up Web Application > m-ariza-maintenance-follow-up-web-application/mariza/admin/records.php
<?
session_start();
include "../inc/logincheck.php";
include "../inc/sorgu.php";
include "../inc/head.php";
?>
<script src="../inc/func.js"></script>
<body onLoad='setTimeout("fade();",2000);'>
<table border="0" align="center" cellpadding="0" cellspacing="0">
	<tr>
		<td colspan="2"><img src="../images/logo.gif" width="215" height="72"><font <?
		if($_GET['msg']=='1'){echo "color=\"#699752\" id=\"bilgi\" class=\"bilgi\"> Record Adding Success</font> <img id=\"bilgi2\" src=\"../images/v.gif\">";}
		if($_GET['msg']=='7'){echo "color=\"#699752\" id=\"bilgi\" class=\"bilgi\"> Product Adding Success</font> <img id=\"bilgi2\"    src=\"../images/v.gif\">";}
		if($_GET['msg']=='9'){echo "color=\"#E39000\" id=\"bilgi\" class=\"bilgi\"> Product Deleting Success</font> <img id=\"bilgi2\"  src=\"../images/v.gif\">";}
		if($_GET['msg']=='2'){echo "color=\"blue\" id=\"bilgi\" class=\"bilgi\"> Product Updating Success</font> <img id=\"bilgi2\"  src=\"../images/v.gif\">";}
		if($_GET['msg']=='3'){echo "color=\"#E39000\" id=\"bilgi\" class=\"bilgi\"> Record Deleting Success</font> <img id=\"bilgi2\"  src=\"../images/v.gif\">";}
		if($_GET['msg']=='4'){echo "color=\"red\" id=\"bilgi\" class=\"bilgi\"> Cannot Add Record !!!</font> <img id=\"bilgi2\" src=\"../images/x.gif\">";}
		if($_GET['msg']=='5'){echo "color=\"red\" id=\"bilgi\" class=\"bilgi\"> Cannot Update Record !!!</font> <img id=\"bilgi2\" src=\"../images/x.gif\">";}
		if($_GET['msg']=='6'){echo "color=\"red\" id=\"bilgi\" class=\"bilgi\"> Cannot Delete Record !!!</font> <img id=\"bilgi2\"  src=\"../images/x.gif\">";}
		if($_GET['msg']=='10'){echo "color=\"red\" id=\"bilgi\" class=\"bilgi\"> Ürün Silinemedi !!!</font> <img id=\"bilgi2\"  src=\"../images/x.gif\">";}
		if($_GET['msg']=='8'){echo "color=\"red\" id=\"bilgi\" class=\"bilgi\"> Cannot Delete Product!!!</font> <img id=\"bilgi2\"  src=\"../images/x.gif\">";}
		?></td>
	</tr>
	<tr><td height="10" colspan="2" bgcolor="#bbbbbb">&nbsp;</td></tr>
	<tr>
		<td width="107" height="379" align="center" valign="top" bgcolor="#DAD3FE">
			<?include"../inc/menu.php"?></td>
		<td valign="top">
			<table border="0" cellPadding="1" cellSpacing="2"  align="center" bgcolor="#ffffff" class="nice">
				<tr class="style1 nice" bgcolor="#DAD3FE">
					<td width="60" height="20" align="center"><a href="records.php?sirala=<?echo "1";?>">Fault No<img src="../images/arrow<?echo $arrows[1];?>.gif" border="0"></a></td>
					<td width="70" height="20" align="center"><a href="records.php?sirala=<?echo "2";?>">Serial No<img src="../images/arrow<?echo $arrows[2];?>.gif" border="0"></a></td>
          			<td width="60" height="20" align="center"><a href="records.php?sirala=<?echo "3";?>">Token No<img src="../images/arrow<?echo $arrows[3];?>.gif" border="0"></a></td>
					<td width="80" height="20" align="center"><a href="records.php?sirala=<?echo "4";?>">Product Name<img src="../images/arrow<?echo $arrows[4];?>.gif" border="0"></td>
          			<td width="48" height="20" align="center"><a href="records.php?sirala=<?echo "5";?>">Status<img src="../images/arrow<?echo $arrows[5];?>.gif" border="0"></a></td>
          			<td width="70" height="20" align="center"><a href="records.php?sirala=<?echo "6";?>">Arrive Date<img src="../images/arrow<?echo $arrows[6];?>.gif" border="0"></a></td>
          			<td width="75" height="20" align="center"><a href="records.php?sirala=<?echo "7";?>">Mend Date<img src="../images/arrow<?echo $arrows[7];?>.gif" border="0"></a></td>
          			<td width="69" height="20" align="center"><a href="records.php?sirala=<?echo "8";?>">Finish Date<img src="../images/arrow<?echo $arrows[8];?>.gif" border="0"></a></td>
          			<td width="200" height="20" align="center"><a href="records.php?sirala=<?echo "9";?>">Comment<img src="../images/arrow<?echo $arrows[9];?>.gif" border="0"></a></td>
		          	<td width="120" height="20" align="center"><a href="records.php?sirala=<?echo "10";?>">Company<img src="../images/arrow<?echo $arrows[10];?>.gif" border="0"></a></td>
          			<td width="80" height="20" align="center"><a href="records.php?sirala=<?echo "11";?>">Related by<img src="../images/arrow<?echo $arrows[11];?>.gif" border="0"></a></td>
          			<td width="80" height="20" align="center"><a href="records.php?sirala=<?echo "12";?>">Phone<img src="../images/arrow<?echo $arrows[12];?>.gif" border="0"></a></td>
        		</tr><?
				$bgcolor = array('Ready' => "#CEFF95", 'Repairing' => "#FFF79F",'Faulty' => "#FEDBDB");
				if($sorgu = mysql_query("SELECT * FROM arizalar WHERE teslimtarihi ='' ".$ordertag)){
					if(mysql_num_rows($sorgu) > 0){
		      			while ($sorgubox = mysql_fetch_array($sorgu)){			
		      				echo "\n\t\t\t<tr bgcolor='{$bgcolor[$sorgubox['durum']]}'>\n\t\t\t\t<td align=center height=18 class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}><font color=red><b>{$sorgubox['id']}</b></font></td>\n\t\t\t\t<td align=center class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>{$sorgubox['serino']}</td>\n\t\t\t\t<td align=center class=nice><b><a href=editrecord.php?fisno={$sorgubox['fisno']}>{$sorgubox['fisno']}</a></b></td>\n\t\t\t\t<td class=nice>&nbsp;<a href=editrecord.php?fisno={$sorgubox['fisno']}>{$sorgubox['urunadi']}</td>\n\t\t\t\t<td align=center class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>{$sorgubox['durum']}</td>\n\t\t\t\t<td align=center class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>";
						  	if (!empty($sorgubox[gelistarihi])){
						  		echo date('d.m.Y',$sorgubox[gelistarihi]);		
						  	}
							echo "</td>\n\t\t\t\t<td align=center class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>";
							if (!empty($sorgubox[tamirtarihi])){
								echo date('d.m.Y',$sorgubox[tamirtarihi]);		
							}
							echo "</td>\n\t\t\t\t<td align=center class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>";
							if (!empty($sorgubox[bitistarihi])){
								echo date('d.m.Y',$sorgubox[bitistarihi]);		
							}
							echo "</td>\n\t\t\t\t<td class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>&nbsp;{$sorgubox['aciklama']}</td>\n\t\t\t\t<td class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>&nbsp;{$sorgubox['firma']}</td>\n\t\t\t\t<td class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>&nbsp;{$sorgubox['ilgili']}</td>\n\t\t\t\t<td class=nice><a href=editrecord.php?fisno={$sorgubox['fisno']}>&nbsp;{$sorgubox['telefon']}</td>\n\t\t\t</tr>";
						}
					}
				}
				?>
				<tr>
					<td colspan="12" bgcolor="#DAD3FE" height="20"></td>
				</tr>
			</table>
		</td>
	</tr>
	<tr><td height="10" colspan="2" bgcolor="#bbbbbb">&nbsp;</td></tr>
</table>
</body>
</html>
Return current item: M-Ariza Maintenance Follow-up Web Application