HTML
|
|
|
|
<?
if (( $admin_id=="" ) || ( $admin_ad=="" ) || ( $admin_sa=="" ))
{
include('hata.php');
exit;
}
?>
<html>
<head>
<title>Bimar Bilgi ��lem Hizmetleri A.�.</title>
<meta http-equiv="Content-Type" content="text/html; charset=">
<style type="text/css">
<!--
-->
</style>
</head>
<body bgcolor="#FFFFFF" background="../../images/arkasgrubback.jpg" onLoad="MM_preloadImages('../../images/mektup_kirmizi.gif')">
<span class="deneme"></span>
<table width="651" border="0" align="center">
<tr valign="top">
<td height="369" class="deneme"> <!-- #BeginLibraryItem "/Library/admin_ust.lbi" --><table width="640" border="0" cellpadding="0" cellspacing="0" align="center">
<tr valign="bottom">
<td height="44" colspan="3" rowspan="4" valign="top">
<table width="434" border="0">
<tr>
<td width="162" height="44"><img src="../../images/arkasgiris.GIF" width="159" height="48"></td>
<td width="262" height="44">
<div align="right"><font face="Times New Roman, Times, serif" size="4">Bimar
Bilgi ��lem Hizmetleri A.�.</font></div>
</td>
</tr>
</table>
</td>
<td height="44" rowspan="4" valign="top">
<table width="205" border="0" height="53">
<tr>
<td>
<div align="center"><? print"$admin_ad"; print"$admin_sa"; ?></div>
</td>
</tr>
<tr>
<td>
<div align="right"><? $bugun=date("d.m.Y"); print"$bugun";?></div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="bottom"></tr>
<tr valign="bottom"></tr>
<tr valign="bottom"> </tr>
</table>
<table width="640" border="0" align="center">
<tr valign="top">
<td>
<table width="640" border="0">
<tr bgcolor="#99CCFF">
<td height="0" width="0">
<div align="left"><a href="../index_ok.php"><img src="../../images/home_3.gif" width="46" height="20" border="0"><font color="#000000">Admin
Ana Sayfas�</font></a></div>
</td>
<td height="0" width="0">
<div align="center"><a href="../talep_kabul.php"><font color="#000000">Talep
Kabul</font></a></div>
</td>
<td height="0" width="0">
<div align="center"><a href="../personel_talep_kontrol.php"><font color="#000000">Personel
kontrol</font></a></div>
</td>
<td height="0" width="0">
<div align="center"><a href="index.php"><font color="#000000">�statistikler</font></a></div>
</td>
<td height="0" width="0">
<div align="center"><a href="../sabitler/sabit_ana.php"><font color="#000000">Sabit
Tan�mlama</font></a></div>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- #EndLibraryItem -->
<table width="644" border="0">
<tr valign="top">
<td height="21" colspan="2">
<div align="center"><font face="Times New Roman, Times, serif" size="3"><b><font face="Times New Roman, Times, serif" size="3"><a href="personel.php"><img src="../../images/grafik.gif" width="68" height="100" border="0"></a><br>
Personel �statistikleri</font></b></font></div>
</td>
</tr>
<tr valign="top">
<td height="21" colspan="2">
<table width="633" border="0" align="left">
<tr>
<td colspan="2" valign="middle">
<form name="form1" action="personel.php" method="post" >
<b> son </b>
<select name="secim">
<option value="bu">Bu Ay</option>
<option value="gecen">Ge�en Ay</option>
<option value="1">1 Ay</option>
<option value="3">3 Ay</option>
<option value="6">6 Ay</option>
<option value="9">9 Ay</option>
<option value="12">1 Y�l</option>
<option value="0">Hepsi</option>
</select>
<b>i�indekileri </b>
<input type="hidden" name="flag" value="tamam">
<input type="submit" name="Submit2" value="G�ster">
</form>
</td>
<td width="198"> </td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td height="21" colspan="2"> </td>
</tr>
<tr valign="top">
<td height="21" colspan="2">
<table width="633" border="1" cellspacing="0" cellpadding="0">
<?
if ($flag=="tamam")
{
function table_olustur($table)
{
?>
<tr>
<?
$bugun_yil=date("Y");
$bugun_ay=date("m");
$bugun_gun=date("d");
include('../../baglan.inc');
$query_count="SELECT prs_id,concat(concat(prs_ad,' '),prs_sa) as ad FROM TALEPWEB.PERSONEL ORDER BY prs_ad";
$calistir_query_count=ODBC_EXEC( $connect,$query_count );
//print"$query_count";
while (ODBC_FETCH_ROW( $calistir_query_count ))
//while basi
{
$prs_id=ODBC_RESULT( $calistir_query_count,"prs_id");
$prs_ad=ODBC_RESULT( $calistir_query_count,"ad");
$query="SELECT sum(t_sure) as toplam FROM TALEPWEB.TALEP t WHERE t_prs_id=$prs_id and t_bitti is not null ";
if($secim=="bu")
{
$bugun_query="01".'/'."$bugun_ay".'/'."$bugun_yil";
$query=$query." and t.t_bitis>='$bugun_query'";
}
if($secim=="gecen")
{
if ($bugun_ay==1)
{
$bugun_ay="12";
$bugun_yil=$bugun_yil-1;
$bugun_query="01".'/'."$bugun_ay".'/'."$bugun_yil";
}
else
{
$bugun_ay=$bugun_ay-1;
$bugun_query="01".'/'."$bugun_ay".'/'."$bugun_yil";
}
$query=$query." and t.t_bitis>='$bugun_query'";
}
if($secim==1)
{
if ($bugun_ay==1)
{
$bugun_ay="12";
$bugun_yil=$bugun_yil-1;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
else
{
$bugun_ay=$bugun_ay-1;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
$query=$query." and t.t_bitis>'$bugun_query'";
}
//3 aylik icin
if($secim==3)
{
if ($bugun_ay<=3)
{
// + 12 - 3 yerine +9 yapiliyor ve yildan 1 dusuluyor.
$bugun_ay=$bugun_ay+9;
$bugun_yil=$bugun_yil-1;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
else
{
$bugun_ay=$bugun_ay-3;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
$query=$query." and t.t_bitis>'$bugun_query'";
}
//6 ay
if($secim==6)
{
if ($bugun_ay<=6)
{
// + 12 - 6 yerine +6 yapiliyor ve yildan 1 dusuluyor.
$bugun_ay=$bugun_ay+6;
$bugun_yil=$bugun_yil-1;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
else
{
$bugun_ay=$bugun_ay-6;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
$query=$query." and t.t_bitis>'$bugun_query'";
}
//9 ay
if($secim==9)
{
if ($bugun_ay<=9)
{
// + 12 - 9 yerine +3 yapiliyor ve yildan 1 dusuluyor.
$bugun_ay=$bugun_ay+3;
$bugun_yil=$bugun_yil-1;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
else
{
$bugun_ay=$bugun_ay-9;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
}
$query=$query." and t.t_bitis>'$bugun_query'";
}
if($secim==12)
{
$bugun_yil=$bugun_yil-1;
$bugun_query="$bugun_gun".'/'."$bugun_ay".'/'."$bugun_yil";
$query=$query." and t.t_bitis>'$bugun_query'";
}
/*print"query";
print"$query";*/
$calistir_query=ODBC_EXEC( $connect,$query );
$toplam=ODBC_RESULT( $calistir_query,"toplam" );
if (empty($toplam))
{
$toplam=0;
}
if ($table=="toplam"){
?>
<td>
<div align="center"><b><? print"$toplam"; ?></b></div>
</td>
<?
}
if ($table=="resim"){
$resim_boyu=$toplam*1.5;
?>
<td valign="bottom">
<div align="center"><img src="../../images/nokta.jpg" width="15" height="<?print"$resim_boyu";?>"></div>
</td>
<?
}
if ($table=="ad"){
?>
<td valign="bottom">
<div align="center"><? print"$prs_ad"; ?></div>
</td>
<?
}
//while sonu
}
//function table_olustur sonu
}
table_olustur("toplam");
?>
</tr>
<?
table_olustur("resim");
?>
</tr>
<?
table_olustur("ad");
?>
</tr>
<?
//if sonu
}
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td height="51">
<div align="center"><!-- #BeginLibraryItem "/Library/alt.lbi" -->
<table width="640" border="0" align="center">
<tr valign="top">
<td height="36" colspan="3">
<div align="center"><font face="Times New Roman, Times, serif" size="2">Bu
Site <a href="http://www.bimar.com.tr"><font color="#000000"><b>Bimar
Bilgi ��lem Hizmetleri A.�.</b></font></a> taraf�ndan haz�rlanm��t�r<br>
©1997-2000 B�MAR<br>
<a href="mailto:webadmin@bimar.com.tr">webadmin@bimar.com.tr</a> </font></div>
</td>
</tr>
</table>
<!-- #EndLibraryItem --></div>
</td>
</tr>
</table>
</body>
</html>
|
|
|
Usage Example
|
|
|
Rate This Script
|
|
|
|
Store
Your email: