\n"; echo " th, td\n"; echo " { font-size: 10pt;\n"; echo " padding-right: 1em;\n"; echo " }\n"; echo "\n"; include_once '../../modules/comFunctions.php'; include_once '../../modules/config.php'; include_once '../../modules/sql.php'; function makeExpenseReport($user, $period, $detailed = false) { $str = "Expense Report for ".$user['fName']." ".$user['lName']." for ".formatDate($period['cStart'])." to ".formatDate($period['cEnd']); $eTotal = 0; echo "
$str
\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $expenseList = sqlSelect("expenses", "entDate > '".$period['cStart']."' and entDate < '".$period['cEndFlag']."' and empNo='".$user['empNo']."'", "", "eDate, tid"); while ($expense = mysql_fetch_assoc($expenseList['r'])) { $dow = getDayOfWeek($expense['eDate']); echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $lastDow = $dow['l']; $eTotal += $expense['eTotal']; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "
DateExpenseWhereDetailsTotal
"; if ($lastDow != $dow['l']) echo $dow['l']; echo ""; if ($lastDow != $dow['l']) echo $dow['f']; echo "".$expense['eCat']."".$expense['eVend']."".$expense['eDetail']."".sprintf("%01.2f", $expense['eTotal'])."
Total Period Expenses".sprintf("%01.2f", $eTotal)."
\n"; } if (empty($_REQUEST['period'])) $period = calcDates(date("Ymd")); else $period = calcDates($_REQUEST['period']); $str = "entDate > '".$period['pEnd']."' and entDate < '".$period['cEndFlag']."'"; if (!empty($_REQUEST['empNo'])) $str .= " and expenses.empNo = '".$_REQUEST['empNo']."'"; $sheetList = sqlSelect("expenses, employees", "expenses.empNo=employees.empNo and $str", "lName, fName"); if (array_key_exists("doPrint", $_REQUEST)) { $doPrint = " onLoad=\"window.print();\""; $_REQUEST['mode'] = "1"; } echo "\n"; while ($sheet = mysql_fetch_assoc($sheetList['r'])) { if ($hasRun) echo "
\n"; $user = getEmployeeData($sheet['empNo']); makeExpenseReport($user, $period, $_REQUEST['mode']); $hasRun = true; } ?>