my first if is:
if ($result=mysql_query($query)) while ( $data=mysql_fetch_array($result)) $data[]=$row[‘ndex’];
{ $trcolor=’#a90000’; }
this is my 2nd and 3rd:
elseif ($ff==1) { $trcolor=’#FFFFFF’; }
elseif ($ff==2) { $trcolor=’#e5e5e5’; $ff=0;}
here is my whole code:
DTR - Citi Hardware
<?
if (empty($begday) && empty($endday)) {$begday=1; $endday=15;}
$qemp=mysql_fetch_row(mysql_query("SELECT * FROM tblemployees WHERE ndex='$id'",$conn));
$qphot=mysql_fetch_row(mysql_query("SELECT * FROM tblpics WHERE EmpID='$qemp[1]'",$conn));
$qdeptdesc=mysql_fetch_row(mysql_query("SELECT * FROM tbldept WHERE deptID='$qemp[5]'",$conn));
$moa=gmdate('n');
$mo1a=gmdate('m')-11;
if (empty($act)) {$yr=gmdate('Y'); $mo1=gmdate('m'); $mos=gmdate('F'); }
$yr2=gmdate('Y');
for ($k=0;$k<=11;$k++)
{
$today = unixtojd(mktime(0, 0, 0,$mo1a + $k , 1, $yr2));
$mosname=(cal_from_jd($today, CAL_GREGORIAN));
if ($mosname[month] < 10 ){ $mosn='0'.$mosname[month]; } else {$mosn=$mosname[month]; }
$yrdisp= substr($mosname[year],2,2);
echo "
$mosname[monthname]- $yrdisp | ";
}
$petsa=$yr.'-'.$mo1.'-';
?>
|
ID Number: <? echo $qemp[1] ?>
Name: <? echo "$qemp[2], $qemp[3] $qemp[4]"; ?>
Department: <? echo "$qdeptdesc[1]"; ?>
Month: <? echo $mos ?>
Days: <? echo "$begday - $endday"; ?>
|
|
Day |
Date |
AM IN |
AM OUT |
PM IN |
PM OUT |
Undertime |
Overtime |
OT STATUS |
Action |
<?
#echo "$begday - $endday nn $mo1, $x, $yr) $petsa";
#echo "$endday $petsa $id ";
$num = cal_days_in_month(CAL_GREGORIAN, $mo1, $yr);
$cnt=0;
$qlogin=mysql_query("SELECT * FROM tbllogin WHERE EmpID='$id' && petsa LIKE '$petsa%' ORDER BY petsa",$conn);
$numcnt=mysql_num_rows($qlogin);
#echo "$numcnt ";
while ($dta=mysql_fetch_array($qlogin))
{
$cnt++;
$amin[$cnt]=$dta['AMin'];
$amout[$cnt]=$dta['AMout'];
$pmin[$cnt]=$dta['PMin'];
$pmout[$cnt]=$dta['PMout'];
$dt=explode('-',$dta['petsa']);
$dynum[$cnt]=$dt[2];
$app_ot[$cnt]=$dta['app_ot'];
$ot_stat[$cnt]=$dta['ot_status'];
$ndeks[$cnt]=$dta['ndex'];
$petdat[$cnt]=$dta['petsa'];
#echo "f $cnt =$amin[$cnt] == $dynum[$cnt] $petdat[$cnt] ";
}
#--------- / VARIABLES /--------
$t=1; //--- ARRAY VALUE
$nwrkd=0; //--- Number of Days Workd
$lwpay=0; //--- Leave With Pay
$tot_ut=0; //--- Total Undertime
$tot_appovt=0; //-- Total Approved Overtime
$ff=0;
for ($x=1;$x <= $endday;$x++)
{
$ovt=0;
$today = unixtojd(mktime(0, 0, 0, $mo1, $x, $yr));
$dmos=cal_from_jd($today, CAL_GREGORIAN);
#echo "$x == $dynum[$t] -- $cnt = $t<br>";
if ($x == $dynum[$t])
{
$aa=$amin[$t];
$bb=$amout[$t];
$cc=$pmin[$t];
$dd=$pmout[$t];
$ee=$app_ot[$t];
$appovt=$app_ot[$t];
$ndek=$ndeks[$t];
if ($cnt > $t) $t++;
$eaa=explode(':',$aa);
$ebb=explode(':',$bb);
$ecc=explode(':',$cc);
$edd=explode(':',$dd);
if ($x >= $begday){
$utamin=0;
if (($eaa[0] >= 9 || ($eaa[0] == 8 && $eaa[1] >= 1)) && (!empty($aa) && ($aa!='A' && $aa!='L')))
{ $colo='red';$utamin=(($eaa[0]-8) * 60) + $eaa[1];} else {$colo='';}
if ($ebb[0] < 12 && (!empty($bb) && ($bb!='A' && $bb!='L')))
{ $colob='red';$utamin=$utamin + ((11 - $ebb[0]) * 60) +(60- $ebb[1]);} else {$colob='';}
if (((($ecc[0] >= 2) || ($ecc[0] == 1 && $ecc[1] >= 1)) && $ecc[0] != 12) && (!empty($cc) && ($cc!='A' && $cc!='L')))
{ $coloc='red';$utamin=$utamin + (($ecc[0]-1) * 60) + $ecc[1];} else {$coloc='';}
if ($edd[0] < 5 && (!empty($dd) && ($dd!='A' && $dd!='L')))
{ $colod='red';$utamin=$utamin + ((5 - $edd[0]) * 60) - $edd[1]; } else {$colod='';}
#if ($edd[0] >= 5)
#{ $ovt = (($edd[0] - 5)*60)+$edd[1]; }
if (strtotime($dd) > strtotime('5:00:00 PM')) $ovt=round((strtotime($dd) - strtotime('5:00:00 PM'))/60,0);
if ($ovt==0) $ot_statmsg='No Overtime';
if (($aa!='A' && $aa!='L') && ($bb!='A' && $bb!='L'))
{ $nwrkd=$nwrkd + 0.5; } //---TOTAL NUMBER OF DAYS WORK ----
if (($cc!='A' && $cc!='L') && ($dd!='A' && $dd!='L'))
{ $nwrkd=$nwrkd +0.5; } //---TOTAL NUMBER OF DAYS WORK ----
if ($aa=='L' && $bb=='L')
{ $lwpay=$lwpay + 0.5; } //--TOTAL NUMBER OF LEAVE GRANTED
if ($cc=='L' && $dd=='L')
{ $lwpay=$lwpay + 0.5; } //--TOTAL NUMBER OF LEAVE GRANTED
$tot_ut=$tot_ut + $utamin;
$tot_appovt= $tot_appovt + $appovt;
}
}
else
{
$utamin=0;
$aa="";
$bb="";
$cc="";
$dd="";
$ee='';
$ot_statmsg='No Overtime';
$ovt=0;
}
if ($ee==0 && !empty($ovt))
{
$ovt=$ovt;
$dtext='<input type=submit name=appact value="Approved">';
$ot_statmsg='Unapproved';
}
if ($ee > 0)
{
$ovt=$ee;
$dtext='<input type=submit name=appact value="Disapproved" style="font-size:9px;">';
$ot_statmsg='Approved';
}
$ff++;
$query = "SELECT tbllogin.ndex, tbledited.myendex FROM tbledited, tbllogin WHERE tbllogin.ndex=tbledited.fldendex AND tbledited.fldempid='$qemp[1]'";
//$query = "SELECT tbledited.fldendex, tbllogin.ndex FROM tbllogin INNER JOIN tbledited ON tbllogin.ndex=tbledited.fldendex WHERE tbllogin.EmpID='$qemp[1]'";
if ($result=mysql_query($query)) while ( $data=mysql_fetch_array($result)) $data[]=$row['ndex'];
{ $trcolor='#a90000'; }
elseif ($ff==1) { $trcolor='#FFFFFF'; }
elseif ($ff==2) { $trcolor='#e5e5e5'; $ff=0;}
if ($x >= $begday){
echo "
<tr bgcolor=$trcolor>
<td width=50 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;">$x</td>
<td width=50 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;">$dmos[abbrevdayname]</td>
<td width=70 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;" color=$colo> $aa </td>
<td width=70 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;" color=$colob>$bb </td>
<td width=70 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;" color=$coloc>$cc </td>
<td width=70 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;" color=$colod>$dd </td>
<td width=50 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;">$utamin</td>
<td width=145 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;">";
#echo "$ovt $appovt";
#if (!empty($ovt) && $ovt > 30) // 30 is the minimum
if (!empty($ovt)) // 30 is the minimum
{
#if ($ee==0 && !empty($ovt))
if ($ee==0 && $ovt > 30)
{
echo " <form method=post action=empdtr.php?thisaction=confirmedot&id=$id&act=$act&mo1=$mo1&yr=$yr&mos=$mos&begday=$begday&endday=$endday&ndek=$ndek style="margin:0px;" onSubmit="window.open('overtime.php?id=$id&act=$act&mo1=$mo1&yr=$yr&mos=$mos&begday=$begday&endday=$endday&ndek=$ndek&ddt=$x&yyrt=$yr&ovt=$ovt','displayWindow_new','toolbar=no,scrollbars=no,width=250,height=400');">";
echo "
<input type=text name="overtime" value="$ovt" size=2 maxlenght=5 disabled>
$dtext
</form>
";
}
if ($ee > 0)
{
$ovt=$ovt*60;
$ovt=round($ovt,0);
echo " <form method=post action=action.php?thisaction=confirmedot&id=$id&act=$act&mo1=$mo1&yr=$yr&mos=$mos&begday=$begday&endday=$endday&ndek=$ndek&myempid=$qemp[1] style="margin:0px;">";
echo "
<input type=text name="overtime" value="$ovt" size=2 maxlenght=5 disabled>
$dtext
</form>
";
}
}
#else { echo " "; }
echo "<font style=font-size:1px;> </font></td>";
if ($x<10) { $ddx='0'.$x; } else {$ddx=$x;}
echo "
<td width=130 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;"><b>$ot_statmsg</td>
<td width=105 align=center valign=center style="border: thin groove blue"><font face=arial style="font-size:11px;">
<a href=# onclick="window.open('manualentry.php?id=$id&petsa=$yr-$mo1-$ddx&mos=$mos&ddt=$x&yyrt=$yr','displayWindow_new','toolbar=no,scrollbars=no,width=300,height=400');" class=bluelink>
Manual Entry
</a>
</td>
</tr>
";
$nnnn=0;
} // if begday
}
echo "
<tr>
<td colspan=5 align=leftt><br>
Total number of Days Work = $nwrkd <br>
Total number of Minutes Undertime = $tot_ut <br>
Total Number of Days Leave = $lwpay <br>
Total Number of Approved Overtime = $tot_appovt
<br><br>
</td>
<td colspan=5 align=right>
[<a href="empdtr.php?id=$id&act=$act&mo1=$mo1&yr=$yr&mos=$mos&begday=1&endday=15"><font color=blue></font> 1-15 </a>]
[ <a href="empdtr.php?id=$id&act=$act&mo1=$mo1&yr=$yr&mos=$mos&begday=16&endday=$num">16- $num</a>]
</td>
</tr>
";
?>
|