} } $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 ##################################################### ?>