"; if ($_SESSION['user']['access'] & 0x0080) echo "
"; echo "Expenses for "; if ($_SESSION['user']['access'] & 0x0080) selectTech($tsEmpNo, "tsEmpNo", "", " onChange=\"this.form.saveButton.disabled=false;\""); else echo getEmployeeName($tsEmpNo, "full"); echo " in the period of "; if ($_SESSION['user']['access'] & 0x0080) { echo "\n"; echo "\n"; echo "
"; } else echo formatDate($period['cStart'])." - ".formatDate($period['cEnd']); echo "
\n"; if ($_REQUEST['process'] == "expense" and !empty($_REQUEST['eDate']) and !empty($_REQUEST['vend']) and !empty($_REQUEST['eCat']) and !empty($_REQUEST['expense'])) { $q = "empNo = '$tsEmpNo', entDate = '".$_REQUEST['entDate']."', eDate = '".$_REQUEST['eDate']."', eVend = '".$_REQUEST['vend']."', eCat = '".$_REQUEST['eCat']."', eDetail = '".$_REQUEST['detail']."', eTotal = '".$_REQUEST['expense']."', dpaid = ''"; sqlRecycle("expenses", $q, "eDate = ''"); unset($_REQUEST['process']); // unset($_REQUEST['eDate']); // unset($_REQUEST['entDate']); unset($_REQUEST['vend']); unset($_REQUEST['eCat']); unset($_REQUEST['detail']); unset($_REQUEST['expense']); } else if ($_REQUEST['process'] == "edit" and !empty($_REQUEST['tidref'])) { $r = sqlSelect("expenses", "tid='".$_REQUEST['tidref']."'"); if ($l = mysql_fetch_assoc($r['r'])) { $_REQUEST['tsEmpNo'] = $l['empNo']; $_REQUEST['eDate'] = $l['eDate']; $_REQUEST['entDate'] = $l['entDate']; $_REQUEST['vend'] = $l['eVend']; $_REQUEST['eCat'] = $l['eCat']; $_REQUEST['detail'] = $l['eDetail']; $_REQUEST['expense'] = $l['eTotal']; $q = "empNo = '0', eDate = '', eVend = '', eCat = '', eDetail = '', eTotal = '0.00'"; sqlUpdate("expenses", $q, "tid='".$_REQUEST['tidref']."'"); } } echo "
\n"; // supercontainer for timesheet and popCalendar echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n\n\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; echo " \n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo " \n"; echo "\n"; echo "\n\n"; // $period = calcdates(); $period = calcDates($_REQUEST['eDate']); $rowcount = 0; $exps = sqlSelect("expenses","empNo='$tsEmpNo' and entDate > '".$period['pEnd']."' and entDate < '".$period['cEndFlag']."'", "", "eDate desc"); echo ""; while ($exp = mysql_fetch_assoc($exps['r'])) { $texp += $exp['eTotal']; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; $rowcount += 1; } while ($rowcount < 9) { // this loop prevents the entries from being spaced out equally over the tbody element echo "\n"; $rowcount += 1; } echo "\n
DateVendor/StoreCategoryDetailsAmountPaid
Total Expense:
"; if ($_SESSION['user']['access'] & 0x0080) echo ""; else echo ""; echo "Categories:"; $catList = sqlSelect("expenses", "", "eCat", "eCat"); echo " \n"; echo "  
".formatDate($exp['eDate'])."".$exp['eVend']."".$exp['eCat']."".$exp['eDetail']."".sprintf("%01.2f",$exp['eTotal'])."".formatDate($exp['dpaid'])."
 
\n\n"; echo "
\n"; echo "\n"; echo "
\n"; echo "\n"; ?>