}
}
$paidTotal = 0;
$unpaidTotal = 0;
$tableReturn = "<table class=table>";
$tableReturn .= "<tr><th class=titlecell>Name</th>\n\t\t\t\t\t\t<th class=titlecell>Service Date</th>\n\t\t\t\t\t\t<th class=titlecell>Amount</th>\n\t\t\t\t\t\t<th class=titlecell>Paid</th></tr>";
foreach ($collectionArray as $userID => $data) {
foreach ($data as $idx => $incomeData) {
if (!isset($incomeData['date'])) {
continue;
}
if ($incomeData['amount'] == 0) {
continue;
}
$tableReturn .= "<tr><td class=tablecell>" . $data['fname'] . " " . $data['lname'] . "</td>";
$tableReturn .= "<td class=tablecell>" . cleanTime($incomeData['date']) . "</td>";
$tableReturn .= "<td class=tablecell>" . number_format($incomeData['amount'] * PERCENTAGE_OUT, 2) . "</td>";
$tableReturn .= "<td class=tablecell>" . $incomeData['paid'] . "</td></tr>";
if (preg_match("/y/i", $incomeData['paid'])) {
$paidTotal += $incomeData['amount'];
}
if (preg_match("/n/i", $incomeData['paid'])) {
$unpaidTotal += $incomeData['amount'];
}
}
}
if (!preg_match("/tablecell/", $tableReturn)) {
$tableReturn .= "<tr><td class=tablecell></td><td class=tablecell>There is no unpaid invoice data at this time</td><td class=tablecell></td></tr>";
} else {
$tableReturn .= "<tr><td class=black></td>\n\t\t\t\t\t<td class=tablecell>Paid Total:</td>\n\t\t\t\t\t<td class=tablecell>" . number_format($paidTotal * PERCENTAGE_OUT, 2) . "</td></tr>";
$tableReturn .= "<tr><td class=black></td>\n\t\t\t\t\t<td class=tablecell>Total Due:</td>\n\t\t\t\t\t<td class=tablecell>" . number_format($unpaidTotal * PERCENTAGE_OUT, 2) . "</td></tr>";
}
$tableReturn = "<form method='POST' \n\t\t\t\t\t\t\taction='php/createInvoice.php'>\n\t\t\t\t\t\t\t<table class=table>";
$tableReturn .= "<tr><th class=titlecell>Name</th>\n\t\t\t\t\t\t<th class=titlecell>Street</th>\n\t\t\t\t\t\t<th class=titlecell>City</th>\n\t\t\t\t\t\t<th class=titlecell>Date</th>\n\t\t\t\t\t\t<th class=titlecell>Serviced?</th></tr>";
foreach ($collectionArray as $userID => $middleArray) {
$tableReturn .= "<tr><td class=tablecell>" . $collectionArray[$userID]['lname'] . "</td><td class=tablecell>" . $collectionArray[$userID]['street_address'] . "</td><td class=tablecell>" . $collectionArray[$userID]['city_address'] . "</td>";
foreach ($middleArray as $i => $data) {
$tr = "";
if ($i) {
$tr = "<tr><td class=black></td><td class=tablecell>---</td><td class=tablecell>---</td>";
}
if (!isset($data['serviceDate'])) {
continue;
}
$tableReturn .= $tr . "<td class=tablecell>" . cleanTime($data['serviceDate']) . "</td><td class=tablecell>";
if ($data['entered'] == "no") {
$tableReturn .= "<input type=checkbox name=chkbox" . $userID . $i . " value=" . $userID . "^" . cleanTime($data['serviceDate']) . "></td></tr>";
} else {
$tableReturn .= "Invoiced</td></tr>";
}
}
}
$tableReturn .= "<tr><td class=black></td><td class=black></td><td class=black></td><td class=black></td><td class=black><input type=submit value=submit class='small round button'></td></tr></form></table>";
}
$tableReturn = preg_replace("/[\t\n]/", "", $tableReturn);
echo json_encode(array("table" => $tableReturn));
#####################################################
# functions
#####################################################
?>
