begin_date, end_date, preparedby, uploaddate, active, */ /*table 2: bgtfiletasks. columns: taskidx, bgtfileidx, m_stasks, tasks, date_start, date_end, nomths, hours, */ /*table 3: bgtfileresource. columns: bgtrscidx, bgtfileidx, email_name, title, level, hrateus, */ /*table 4: bgtfileres_task_hr. columns: rthidx, taskidx, bgtrscidx, hours, */ //echo $sql."<br><br><br>"; $result = mysql_query($sql); include "err_msg.inc"; $oneprojbudget = 0; while (list($tskdateS, $tskdateE, $nomths, $hours) = mysql_fetch_array($result)) { //$casethismth || $caselastmth || $caseyear || $caselastyear || $caseany) $hrsinmth = $hours / $nomths; if ($casethismth || $caselastmth) { $oneprojbudget += $hrsinmth; } else { $thispod = calhours($tskdateS, $tskdateE, $hrsinmth); $oneprojbudget += $thispod; //echo "$tskdateS, $tskdateE, $nomths, $hours, $thispod<br>"; } } //echo "$oneprojbudget<br>"; //list($oneprojbudget) = mysql_fetch_array($result); if ($oneprojactual || $oneprojbudget) { $noctr++; $allstafftotalactual += $oneprojactual; $allstafftotalbudget += $oneprojbudget; $no1 = sprintf("%01.2f", $oneprojactual / 60.0); $no2 = sprintf("%01.2f", $oneprojbudget); $oneprojactual = number_format($oneprojactual / 60.0, 2); $oneprojbudget = number_format($oneprojbudget, 2); $extra = "&datefrom={$datefrom}&dateto={$dateto}&ename={$ename}&fname={$fname}&rpttitle={$title}";
$result = mysql_query($sql); include "err_msg.inc"; $noentry = 0; $hrspod = 0; $hrstotal = 0; while (list($tskdateS, $tskdateE, $nomths, $tasks, $hours) = mysql_fetch_array($result)) { if (!$noentry) { echo "<h3>{$brief_code} {$timeframe}</h3>"; fputs($csvfh, "{$brief_code}\n"); echo "<table border=1>"; echo "<tr><th>Tasks</th><th>From</th><th>To</th><th>Month</th><th>Hours for the Period</th><th>Total Hours</th></tr>"; fputs($csvfh, "Tasks,From,To,Month,Hours for the Period,Total Hours\n"); } $noentry++; $hrsinmth = $hours / $nomths; $hrs = calhours($tskdateS, $tskdateE, $hrsinmth); $podhours = number_format($hrs, 2); $hrspod += $hrs; $hrstotal += $hours; echo "<tr><td>{$tasks}</td><td>{$tskdateS}</td><td>{$tskdateE}</td><td align=middle>{$nomths}</td>\n\t\t\t\t\t<td align=middle>{$podhours}</td><td align=middle>{$hours}</td></tr>"; fputs($csvfh, "{$tasks},{$tskdateS},{$tskdateE},{$nomths},{$podhours},{$hours}\n"); } if ($noentry) { $hrspod = number_format($hrspod, 2); $hrstotal = number_format($hrstotal, 2); echo "<tr><th colspan=4>Sub Total</th>\n\t\t\t\t\t<th>{$hrspod}</th><th>{$hrstotal}</th></tr>"; fputs($csvfh, ",,,,{$hrspod},{$hrstotal}\n"); echo "</table><p>"; } } if (!$hrstotal) {