fannie/modules/plugins2.0/WfcHoursTracking/disabled/WfcHtImportUTO.php from CORE-POS/IS4C

fannie/modules/plugins2.0/WfcHoursTracking/disabled/WfcHtImportUTO.php
Summary

Maintainability

0 mins
Test Coverage

Issues
<?php
class WfcHtImportUTO {}
/**
  No longer in use; not cleaned up to be plugin-safe.
  Kept for reference.
include(dirname(__FILE__).'/../../../config.php');

require(__DIR__ . '/../../../auth/login.php');
if (!validateUserQuiet('upload_hours_data')){
    header("Location: {$FANNIE_URL}auth/ui/loginform.php?redirect={$_SERVER['PHP_SELF']}");
    return;
}

require(__DIR__ . '/../../../src/csv_parser.php');
require(__DIR__ . '/../../../src/tmp_dir.php');
require(dirname(__FILE__).'/db.php');
$db = hours_dbconnect();

$ADP_COL = 0;
$HOURS_COL = 1;

$colors = array("one","two");

echo "<html>
<head><title>Upload Data</title>
<style type=text/css>
.one {
    background: #ffffff;
}
.one td {
    text-align: right;
}
.two {
    background: #ffffcc;
}
.two td {
    text-align: right;
}
</style>
</head>
<body bgcolor=#cccccc>";

if (isset($_POST["MAX_FILE_SIZE"])){
    $filename = md5(time());
    $tmp = sys_get_temp_dir();
    move_uploaded_file($_FILES['upload']['tmp_name'],"$tmp/$filename");
    
    $pp = $_POST["ppID"];

    $fp = fopen("$tmp/$filename","r");
    $c = 1;
    echo "<form action=importUTO.php method=post>";
    echo "<input type=hidden name=pp value=\"$pp\" />";
    echo "<table cellpadding=4 cellspacing=0 border=1>";
    echo "<tr class=one><th>ADP ID</th><th>UTO Hours</th></tr>";
    $checkQ = $db->prepare("select empID from employees where adpID=?");
    while (!feof($fp)){
        $line = fgets($fp);

        $fields = csv_parser($line);
        if (count($fields) == 0) continue;

        $adpID = $fields[$ADP_COL];
        if (!is_numeric($adpID)) continue;

        $checkR = $db->execute($checkQ, array($adpID));
        if ($db->num_rows($checkR) < 1){
            echo "Notice: ADP ID #$adpID doesn't match any current employee.";
            echo "Data for this ID is being omitted.<br />";
            continue;
        }

        $hours = $fields[$HOURS_COL];
        if ($hours == "") $hours = 0;
        
        echo "<tr class=$colors[$c]>";
        echo "<td>$adpID</td><td>$hours</td>";
        echo "</tr>";

        echo "<input type=hidden name=data[] value=\"$adpID,$hours\" />";
        
        $c = ($c+1)%2;
    }
    echo "</table>";
    echo "<input type=submit value=\"Import Data\">";
    
    fclose($fp);
    unlink("$tmp/$filename");
    return; 
}
elseif (isset($_POST["data"])){
    $datalines = $_POST["data"];
    $ppID = $_POST["pp"];
    
    $eIDQ = $db->prepare("select empID from employees where adpID=?");
    $upQ = $db->prepare("update ImportedHoursData set UTOHours=? where empID=? and periodID=? LIMIT 1");
    foreach ($datalines as $line){
        $fields = explode(",",$line);
        $eIDR = $db->execute($eIDQ, array($fields[0]));
        if ($db->num_rows($eIDR) < 1) continue;
        $empID = array_pop($db->fetch_row($eIDR));

        $upR = $db->execute($upQ, array($fields[1], $empID, $ppID));
    }

    echo "UTO data import complete!<br />";
    echo "<a href=list.php>View Employees</a><br />";
    echo "<a href=pps.php>View Pay Periods</a>";
    
    return;
}

?>

<form enctype="multipart/form-data" action="importUTO.php" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="2097152" />
Pay Period: <select name=ppID>
<?php
$ppQ = "select dateStr,periodID from payperiods order by periodID desc";
$ppR = $db->query($ppQ);
while($ppW = $db->fetch_row($ppR)) echo "<option value=$ppW[1]>$ppW[0]</option>";
?>
</select><p />
Filename: <input type="file" id="file" name="upload" />
<input type="submit" value="Upload File" />
</form>

</body>
</html>
<?php
*/