}
######################################################################################################
##### view project file
if ($viewprojectfile) {
$sql = "SELECT email_name as ename, budgetfile, phaseno, budgetstart, \n budgetend, actualstart, actualend, date \n FROM timesheet.projbudgetfile \n WHERE budgetfileid='{$budgetfileid}' and projcode_id='{$projcode_id}';";
$result = mysql_query($sql);
include "err_msg.inc";
list($ename, $budgetfile, $phaseno, $budgetstart, $budgetend, $actualstart, $actualend, $date) = mysql_fetch_array($result);
echo "<hr><h2>Budget File for Project <font color=#0000ff>" . $brcode[$projcode_id] . "</font> (Phase {$phaseno}).</h2>";
echo "<h3>This budget file was provided by <font color=#ff0000>{$ename}</font> on {$date}.</h3>";
echo "<table>";
echo "<tr><th> </th><th>Budget</th><th>Actual</th></tr>";
echo "<tr><th align=left>Start Date</th><td>{$budgetstart}</td><td>{$actualstart}</td></tr>";
echo "<tr><th align=left>End Date</th><td>{$budgetend}</td><td>{$actualend}</td></tr>";
echo "</table>";
displaybudgetdata($budgetfile, $ref);
}
if ($modifybudgetdataentry) {
echo "<hr>";
$dstr = date("Y-m-d");
if ($actualstart == $actualend) {
$sql = "UPDATE timesheet.projbudgetfile \n SET projcode_id='{$projectid}', phaseno='{$phaseno}' \n WHERE budgetfileid='{$budgetfileid}'";
} else {
$sql = "UPDATE timesheet.projbudgetfile \n SET projcode_id='{$projectid}', phaseno='{$phaseno}', actualstart='{$actualstart}', actualend='{$actualend}' \n WHERE budgetfileid='{$budgetfileid}'";
}
#echo "$sql<br>";
$result = mysql_query($sql);
include "err_msg.inc";
echo "<h2>Project Budget Data Modification Completed.</h2>";
}
######################################################################################################
$date = date("Y-m-d");
if ($actualstart == $date) {
$actualstart = $budgetstart;
}
if ($actualend == $date) {
$actualend = $budgetend;
}
$sql = "INSERT INTO timesheet.projbudgetfile \n \tSET budgetfileid='null', email_name='{$email_name}', \n projcode_id='{$projectid}', phaseno='{$phaseno}', budgetfile='{$filedata}', \n neworold='y', date='{$date}', \n budgetstart='{$budgetstart}', budgetend='{$budgetend}', \n actualstart='{$actualstart}', actualend='{$actualend}',\n dateinrow='{$daterow}';";
$result = mysql_query($sql);
include "err_msg.inc";
$autoid = mysql_insert_id();
//echo $autoid."<br>";
echo "<h2>Contents in your project budget file are as follows.</font></h2>";
$userstr = "?" . base64_encode($userinfo . "&deleteprojectfile=y&projcode_id={$projectid}&autoid={$autoid}");
$ref = "<h3><a href=\"{$PHP_SELF}{$userstr}\">Delete This Budget File.</a></h3>";
displaybudgetdata($filedata, $ref);
echo "<h3><br><font color=#0000ff>Budget file for project <font color=#ff0000>" . $brcode[$projectid] . "</font> have been successfully entered into DB.</font></h3><br>";
/*
echo "<b><br><br>\"$filename_name\" has been uploaded, and ".
" is available for <a href=\"/$copyfileto$filename_name\" target=\"_blank\">view</a>.";
echo "<br>File absolute path on $SERVER_NAME is $fldcopy$filename_name.</b>";
//*/
}
}
if ($cancel) {
echo "<h3><br><br>You can upload file later.</h3>";
exit;
}
######################################################################################################
##### List previous project data
##### for project leader
