timerpt.php

网页打卡钟系统,源码提供给大家学习一下啦!希望给大家带来帮助

$rpt_hour = gmdate('H');
$rpt_min = gmdate('i');
$rpt_sec = gmdate('s');
$rpt_month = gmdate('m');
$rpt_day = gmdate('d');
$rpt_year = gmdate('Y');
$rpt_stamp = mktime ($rpt_hour, $rpt_min, $rpt_sec, $rpt_month, $rpt_day, $rpt_year);

$rpt_stamp = $rpt_stamp + @$tzo;
$rpt_time = date($timefmt, $rpt_stamp);
$rpt_date = date($datefmt, $rpt_stamp);

$tmp_fullname = stripslashes($fullname);
if ((strtolower($user_or_display) == "display") && ($tmp_fullname != "All")) {
$tmp_fullname = stripslashes($displayname);
}
if (($office_name == "All") && ($group_name == "All") && ($tmp_fullname == 'All')) {$tmp_fullname = "Offices: All --> Groups: All --> Users: All";}
elseif ((empty($office_name)) && (empty($group_name)) && ($tmp_fullname == 'All'))  {$tmp_fullname = "All Users";}
elseif ((empty($office_name)) && (empty($group_name)) && ($tmp_fullname != 'All'))  {$tmp_fullname = $tmp_fullname;}
elseif (($office_name != "All") && ($group_name == "All") && ($tmp_fullname == 'All')) {$tmp_fullname = "Office: $office_name --> Groups: All -->
 Users: All";}
elseif (($office_name != "All") && ($group_name != "All") && ($tmp_fullname == 'All')) {$tmp_fullname = "Office: $office_name --> Group: $group_name -->
 Users: All";}
$rpt_name="$tmp_fullname";

echo "            <table width=100% align=center class=misc_items border=0 cellpadding=3 cellspacing=0>\n";
echo "              <tr><td width=80% style='font-size:9px;color:#000000;padding-left:10px;'>Run on: $rpt_time, $rpt_date</td><td nowrap
                      style='font-size:9px;color:#000000;'>$rpt_name</td></tr>\n";
echo "               <tr><td width=80%></td><td nowrap style='font-size:9px;color:#000000;'>Date Range: $from_date - $to_date</td></tr>\n";
if (!empty($tmp_csv)) {
  echo "               <tr class=notprint><td width=80%></td><td nowrap style='font-size:9px;color:#000000;'><a style='color:#27408b;font-size:9px;
                         text-decoration:underline;' 
                         href=\"get_csv.php?rpt=timerpt&display_ip=$tmp_display_ip&csv=$tmp_csv&office=$office_name&group=$group_name&fullname=$fullname&from=$from_timestamp&to=$to_timestamp&tzo=$tzo\">Download CSV File</a></td></tr>\n"; 
}
echo "            </table>\n";

$employees_cnt = 0;
$employees_empfullname = array();
$employees_displayname = array();
$row_count = 0;
$page_count = 0;

// retrieve a list of users //

$fullname = addslashes($fullname);

if (strtolower($user_or_display) == "display") {

    if (($office_name == "All") && ($group_name == "All") && ($fullname == "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees WHERE tstamp IS NOT NULL order by displayname asc";
        $result = mysql_query($query);

    } elseif ((empty($office_name)) && (empty($group_name)) && ($fullname == 'All')) {

        $query = "select empfullname, displayname from ".$db_prefix."employees WHERE tstamp IS NOT NULL order by displayname asc";
        $result = mysql_query($query);

    } elseif ((empty($office_name)) && (empty($group_name)) && ($fullname != 'All')) {

        $query = "select empfullname, displayname from ".$db_prefix."employees WHERE tstamp IS NOT NULL and empfullname = '".$fullname."' order by 
                  displayname asc";
        $result = mysql_query($query);

    } elseif (($office_name != "All") && ($group_name == "All") && ($fullname == "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees where office = '".$office_name."' and tstamp IS NOT NULL order by 
                  displayname asc";
        $result = mysql_query($query);

    } elseif (($office_name != "All") && ($group_name != "All") && ($fullname == "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees where office = '".$office_name."' and groups = '".$group_name."'  and 
                  tstamp IS NOT NULL order by displayname asc";
        $result = mysql_query($query);

    } elseif (($office_name != "All") && ($group_name != "All") && ($fullname != "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees where office = '".$office_name."' and groups = '".$group_name."' and
                  empfullname = '".$fullname."' and tstamp IS NOT NULL order by displayname asc";
        $result = mysql_query($query);
    }

} else {

    if (($office_name == "All") && ($group_name == "All") && ($fullname == "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees WHERE tstamp IS NOT NULL order by empfullname asc";
        $result = mysql_query($query);

    } elseif ((empty($office_name)) && (empty($group_name)) && ($fullname == 'All')) {

        $query = "select empfullname, displayname from ".$db_prefix."employees WHERE tstamp IS NOT NULL order by empfullname asc";
        $result = mysql_query($query);

    } elseif ((empty($office_name)) && (empty($group_name)) && ($fullname != 'All')) {

        $query = "select empfullname, displayname from ".$db_prefix."employees WHERE tstamp IS NOT NULL and empfullname = '".$fullname."' order by 
                  empfullname asc";
        $result = mysql_query($query);

    } elseif (($office_name != "All") && ($group_name == "All") && ($fullname == "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees where office = '".$office_name."' and tstamp IS NOT NULL order by 
                  empfullname asc";
        $result = mysql_query($query);

    } elseif (($office_name != "All") && ($group_name != "All") && ($fullname == "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees where office = '".$office_name."' and groups = '".$group_name."'  and 
                  tstamp IS NOT NULL order by empfullname asc";
        $result = mysql_query($query);

    } elseif (($office_name != "All") && ($group_name != "All") && ($fullname != "All")) {

        $query = "select empfullname, displayname from ".$db_prefix."employees where office = '".$office_name."' and groups = '".$group_name."' and
                  empfullname = '".$fullname."' and tstamp IS NOT NULL order by empfullname asc";
        $result = mysql_query($query);
    }
}

while ($row=mysql_fetch_array($result)) {

  $employees_empfullname[] = stripslashes("".$row['empfullname']."");
  $employees_displayname[] = stripslashes("".$row['displayname']."");
  $employees_cnt++;
}
for ($x=0;$x<$employees_cnt;$x++) {

    $fullname = stripslashes($fullname);
    if (($employees_empfullname[$x] == $fullname) || ($fullname == "All")) {

        $row_color = $color2; // Initial row color

        $employees_empfullname[$x] = addslashes($employees_empfullname[$x]);
        $employees_displayname[$x] = addslashes($employees_displayname[$x]);

        $query = "select ".$db_prefix."info.fullname, ".$db_prefix."info.`inout`, ".$db_prefix."info.timestamp, ".$db_prefix."info.notes, 
                  ".$db_prefix."info.ipaddress, ".$db_prefix."punchlist.in_or_out, ".$db_prefix."punchlist.punchitems, ".$db_prefix."punchlist.color
                  from ".$db_prefix."info, ".$db_prefix."punchlist, ".$db_prefix."employees
                  where ".$db_prefix."info.fullname like ('".$employees_empfullname[$x]."') and ".$db_prefix."info.timestamp >= '".$from_timestamp."'
                  and ".$db_prefix."info.timestamp <= '".$to_timestamp."' and ".$db_prefix."info.`inout` = ".$db_prefix."punchlist.punchitems 
                  and ".$db_prefix."employees.empfullname = '".$employees_empfullname[$x]."' and ".$db_prefix."employees.empfullname <> 'admin'
                  order by ".$db_prefix."info.timestamp asc";
        $result = mysql_query($query);

        while ($row=mysql_fetch_array($result)) {

            $display_stamp = "".$row["timestamp"]."";
            $time = date($timefmt, $display_stamp);
            $date = date($datefmt, $display_stamp);

            if ($row_count == 0) {
                if ($page_count == 0) {

                    echo "            <table class=misc_items width=100% border=0 cellpadding=2 cellspacing=0>\n";
                    echo "              <tr class=notprint>\n";
                    echo "                <td nowrap width=20% align=left style='padding-left:10px;padding-right:10px;font-size:11px;color:#27408b;
                    text-decoration:underline;'>Name</td>\n";
                    echo "                <td nowrap width=7% align=left style='padding-left:10px;font-size:11px;color:#27408b;
                    text-decoration:underline;'>In/Out</td>\n";
                    echo "                <td nowrap width=5% align=right style='padding-right:10px;font-size:11px;color:#27408b;
                    text-decoration:underline;'>Time</td>\n";
                    echo "                <td nowrap width=5% align=right style='padding-left:10px;font-size:11px;color:#27408b;
                    text-decoration:underline;'>Date</td>\n";
                    if ($tmp_display_ip == "1") {
                        echo "                <td nowrap width=15% align=left style='padding-left:10px;font-size:11px;color:#27408b;
                        text-decoration:underline;'>Originating IP</td>\n";
                    }
                    echo "                <td style='padding-left:10px;'><a style='font-size:11px;color:#27408b;text-decoration:underline;'>Notes</td>\n";

                } else {

                    // display report name and page number of printed report above the column headings of each printed page //

                    $temp_page_count = $page_count + 1;
                    echo "              <tr><td colspan=2 class=notdisplay style='font-size:9px;color:#000000;padding-left:10px;'>Run on: $rpt_time,
                      $rpt_date (page $temp_page_count)</td><td class=notdisplay nowrap style='font-size:9px;color:#000000;'
                      align=right colspan=4>$rpt_name</td></tr>\n";
                    echo "              <tr><td class=notdisplay align=right colspan=6 nowrap style='font-size:9px;color:#000000;'>
                      Date Range: $from_date - $to_date</td></tr>\n";
                }
                echo "              <tr class=notdisplay>\n";
                echo "                <td nowrap width=20% align=left style='padding-left:10px;padding-right:10px;font-size:11px;color:#27408b;
                    text-decoration:underline;'>Name</td>\n";
                echo "                <td nowrap width=7% align=left
                    style='padding-left:10px;font-size:11px;color:#27408b;text-decoration:underline;'>In/Out</td>\n";
                echo "                <td nowrap width=5% align=right
                    style='padding-right:10px;font-size:11px;color:#27408b;text-decoration:underline;'>Time</td>\n";
                echo "                <td nowrap width=5% align=right
                    style='padding-left:10px;font-size:11px;color:#27408b;text-decoration:underline;'>Date</td>\n";
                if ($tmp_display_ip == "1") {
                    echo "                <td nowrap width=15% align=left
                        style='padding-left:10px;font-size:11px;color:#27408b;text-decoration:underline;'>Originating IP</td>\n";
                }
                echo "                <td style='padding-left:10px;'><a style='font-size:11px;color:#27408b;text-decoration:underline;'>Notes</td>\n";
                echo "              </tr>\n";
            }

            // begin alternating row colors //
  
            $row_color = ($row_count % 2) ? $color1 : $color2;
  
            // display the query results //

            $display_stamp = $display_stamp + @$tzo;
            $time = date($timefmt, $display_stamp);
            $date = date($datefmt, $display_stamp);
  
            if (strtolower($user_or_display) == "display") {
                echo stripslashes("              <tr class=display_row><td nowrap width=20% bgcolor='$row_color' style='padding-left:10px;
                      padding-right:10px;'>$employees_displayname[$x]</td>\n");
            } else {
                echo stripslashes("              <tr class=display_row><td nowrap width=20% bgcolor='$row_color' style='padding-left:10px;
                      padding-right:10px;'>$employees_empfullname[$x]</td>\n");
            }
            echo "                <td nowrap align=left width=7% style='background-color:$row_color;color:".$row["color"].";
                  padding-left:10px;'>".$row["inout"]."</td>\n";
            echo "                <td nowrap align=right width=5% bgcolor='$row_color' style='padding-right:10px;'>".$time."</td>\n";
            echo "                <td nowrap align=right width=5% bgcolor='$row_color' style='padding-left:10px;'>".$date."</td>\n";
            if ($tmp_display_ip == "1") {
                echo "                <td nowrap align=left width=15% style='background-color:$row_color;color:".$row["color"].";
                      padding-left:10px;'>".$row["ipaddress"]."</td>\n";
            }
            echo stripslashes("                <td bgcolor='$row_color' style='padding-left:10px;'>".$row["notes"]."</td>\n");
            echo "              </tr>\n";

            $row_count++;

            // output 40 rows per printed page //

            if ($row_count == 40) {
                echo "              <tr style=\"page-break-before:always;\"></tr>\n";
                $row_count = 0;
                $page_count++;
            }
        }
    }
}
}
exit;
?>