///////INVOICES QUERY

		

		// the MySQL query that gets pulled from the database

		$queryInvoices = "SELECT       

		o70vm_invoices_contacts.name AS 'Parent_Name',

		o70vm_invoices_contacts.id AS 'Parent_ID',

		o70vm_invoices_contacts.company AS 'Children',

		 

		o70vm_invoices_invoices.id AS 'Invoice_ID',

		o70vm_invoices_invoices.user_id AS 'Parent_ID_on_Invoice',

		o70vm_invoices_invoices.invoice_num AS 'Invoice_Num',

		o70vm_invoices_invoices.invoice_date AS 'Invoice_Date',

		o70vm_invoices_invoices.invoice_duedate AS 'Invoice_Date_Due',

		 

		o70vm_invoices_items.id AS 'Item_ID',

		o70vm_invoices_items.invoice_id AS 'Invoice_ID_on_Items',

		o70vm_invoices_items.value AS 'Fee',

		o70vm_invoices_items.amount AS 'Qty',

			

		ROUND(SUM((o70vm_invoices_items.value)*(o70vm_invoices_items.amount)),2) AS 'INV-TOTAL'

				 

		FROM o70vm_invoices_invoices, o70vm_invoices_contacts, o70vm_invoices_items

		WHERE

		o70vm_invoices_contacts.id = o70vm_invoices_invoices.user_id

		AND

		o70vm_invoices_items.invoice_id = o70vm_invoices_invoices.id

		AND

		o70vm_invoices_invoices.invoice_duedate >= STR_TO_DATE('2014-01-01 00:00:00', '%Y-%m-%d %H:%i:%s')

		AND

		o70vm_invoices_invoices.invoice_duedate <= NOW()

		

		GROUP BY o70vm_invoices_contacts.id



		ORDER BY o70vm_invoices_contacts.company";				 



		// storing the result of this MySQL query

		$resultInvoicesQuery = mysql_query($queryInvoices) or die(mysql_error());



		while($rowInvoices = mysql_fetch_array($resultInvoicesQuery))

		{

		

		$InvoiceTotal = $rowInvoices['INV-TOTAL'];

		

		// testing to print results to screen

		// displays correctly 

		// unable to bring this figure to display in main customer display on front end.

		

		echo "InvoiceTotal:" .$InvoiceTotal;

		

		

		}

		

					

		////// PAYMENT QUERY

		

		// the MySQL query that gets pulled from the database

		$query = "SELECT       

		o70vm_invoices_contacts.name AS 'Parent_Name',

		o70vm_invoices_contacts.id AS 'Parent_ID',

		o70vm_invoices_contacts.company AS 'Children',

		 

		o70vm_invoices_invoices.id AS 'Invoice_ID',

		o70vm_invoices_invoices.user_id AS 'Parent_ID_on_Invoice',

		o70vm_invoices_invoices.invoice_num AS 'Invoice_Num',

		o70vm_invoices_invoices.invoice_date AS 'Invoice_Date',

		o70vm_invoices_invoices.invoice_duedate AS 'Invoice_Date_Due',

		 

		o70vm_invoices_payments.invoice_id,

		SUM(o70vm_invoices_payments.payment_amount) AS 'Paid'

						 

		FROM o70vm_invoices_invoices, o70vm_invoices_contacts, o70vm_invoices_payments

		WHERE

		o70vm_invoices_contacts.id = o70vm_invoices_invoices.user_id

		AND

		o70vm_invoices_payments.invoice_id = o70vm_invoices_invoices.id

		AND

		o70vm_invoices_payments.payment_datetime >= STR_TO_DATE('2014-01-01 00:00:00', '%Y-%m-%d %H:%i:%s')

		AND

		o70vm_invoices_payments.payment_datetime <= NOW()

		

		GROUP BY o70vm_invoices_contacts.id

		

		ORDER BY o70vm_invoices_contacts.company";

				 



		// storing the result of this MySQL query

		$result = mysql_query($query) or die(mysql_error());



		

		//declaring and initalizing row count

		$row_count = 0;

		

		

		

		// beginning the process of displaying the table

	

			

		echo "<table width='80%' border='1'>

		<tr>

		<td><strong>#</strong></td>

		<td><strong>Parent</strong></td>

		<td><strong>Children</strong></td>

		<td><strong>Total Paid</strong></td>

		<td><strong>Total Invoices</strong></td>

		<td><strong>Account Balance</strong></td>

		</tr>";

				

				

				while($row = mysql_fetch_array($result))

				{



				// counting the rows

				$row_count++;

			

				//	The item description based on the ID of the invoice

				//	Writing the values to the table

				

				echo "<tr>";

				echo "<td>".$row_count."</td>";

				echo "<td>" . $row['Parent_Name'] . "</td>";

				echo "<td>" . $row['Children'] . "</td>";

				echo "<td align='right'>$". $row['Paid'] . "</td>";

				

					$TotalParentPayments += $row['Paid'];

				

				echo "<td align='right'>$$InvoiceTotal</td>";

						

					$AccountBalance = $InvoiceTotal - $row['Paid'];

					



				echo "<td>$" .$AccountBalance. "</td>";

				echo "</tr>";

				

				

				}

				

				

				

			

		

		echo "</table>";