Start Date:     End Date:     "; if ($calculate) { $query = "SELECT COUNT(*),SUM(total),SUM(tblinvoices.credit),SUM(tax),SUM(tax2) FROM tblinvoices INNER JOIN tblclients ON tblclients.id=tblinvoices.userid WHERE datepaid>='".db_make_safe_human_date($startdate)."' AND datepaid<='".db_make_safe_human_date($enddate)." 23:59:59' AND tblinvoices.status='Paid' AND currency=".(int)$currencyid; $result = full_query($query); $data = mysql_fetch_array($result); $numinvoices = $data[0]; $total = $data[1] + $data[2]; $tax = $data[3]; $tax2 = $data[4]; if (!$total) $total="0.00"; if (!$tax) $tax="0.00"; if (!$tax2) $tax2="0.00"; $reportdata["headertext"] .= "
$numinvoices Invoices Found
Total Invoiced: ".formatCurrency($total)."   Tax Level 1 Liability: ".formatCurrency($tax)."   Tax Level 2 Liability: ".formatCurrency($tax2); } $reportdata["headertext"] .= ""; $reportdata["tableheadings"] = array("Invoice ID","Client Name","Invoice Date","Date Paid","Subtotal","Tax","Credit","Total"); $query = "SELECT tblinvoices.*,tblclients.firstname,tblclients.lastname FROM tblinvoices INNER JOIN tblclients ON tblclients.id=tblinvoices.userid WHERE datepaid>='".db_make_safe_human_date($startdate)."' AND datepaid<='".db_make_safe_human_date($enddate)." 23:59:59' AND tblinvoices.status='Paid' AND currency=".(int)$currencyid." ORDER BY date ASC"; $result = full_query($query); while ($data = mysql_fetch_array($result)) { $id = $data["id"]; $userid = $data["userid"]; $client = $data["firstname"]." ".$data["lastname"]; $date = fromMySQLDate($data["date"]); $datepaid = fromMySQLDate($data["datepaid"]); $currency = getCurrency($userid); $subtotal = $data["subtotal"]; $credit = $data["credit"]; $tax = $data["tax"]+$data["tax2"]; $total = $data["total"] + $credit; $reportdata["tablevalues"][] = array("$id","$client","$date","$datepaid","$subtotal","$tax","$credit","$total"); } $data["footertext"]=""; ?>