earnings.inc

不错的东西

<?php
//$query = $sql->query("SELECT b.id, b.pkg_name, a.pay_period, COUNT(a.id) AS account_num FROM accounts AS a RIGHT JOIN packages AS b ON (a.package = b.id AND b.pkg_type <> 0)GROUP BY b.id");
//$query = $sql->query("SELECT b.id, b.pkg_name, a.pay_period, COUNT(a.id) AS account_num FROM accounts AS a RIGHT JOIN packages AS b ON (a.package = b.id) WHERE b.pkg_type <> 1 GROUP BY b.pkg_type") or die(mysql_error());
$query = $sql->query("SELECT b.id, b.pkg_name, a.pay_period, COUNT(a.id) AS account_num FROM accounts AS a LEFT JOIN packages AS b ON (a.package = b.id AND b.pkg_type <> 1) GROUP BY a.pay_period");
while($data = mysql_fetch_assoc($query))
{
	$packages[$data['id']]['pkg_name'] = $data['pkg_name'];
	$packages[$data['id']]['account_num'][$data['pay_period']] = $data['account_num'];

	$query2 = $sql->query("SELECT * FROM accounts AS a LEFT JOIN paypal_ipn AS b ON (a.id = b.id) LEFT JOIN authnet AS c ON (a.id = c.id) LEFT JOIN 2checkout AS d ON (a.id = d.id)") or die(mysql_error());
	while($data2 = mysql_fetch_assoc($query2))
	{
		$packages[$data['id']]['payment_gross'][$data['pay_period']] = $data2['payment_gross'];
	}
}

foreach($packages as $key => $value)
{
	?>

	<table width="45%">
	<tr style="font-weight: bold;">
		<td><?=$packages[$key]['pkg_name']?></td>
		<td>Monthly</td>
		<td>Quarterly</td>
		<td>Bi-Annually</td>
		<td>Annually</td>
		<td>Total</td>
	</tr>
	<tr>
		<td>Clients</td>
		<td><?=(isset($packages[$key]['account_num']['1'])) ? $packages[$key]['account_num']['1'] : 0 ?></td>
		<td><?=(isset($packages[$key]['account_num']['2'])) ? $packages[$key]['account_num']['2'] : 0 ?></td>
		<td><?=(isset($packages[$key]['account_num']['3'])) ? $packages[$key]['account_num']['3'] : 0 ?></td>
		<td><?=(isset($packages[$key]['account_num']['4'])) ? $packages[$key]['account_num']['4'] : 0 ?></td>
		<td><?
		/*
		*  Modified: 11/08/05
		*  0 value fix
		*/
		if(is_array($packages[$key]['account_num'])) {
			echo array_sum($packages[$key]['account_num']);
		} else {
			echo "0";
		}
		?></td>
	</tr>
	<tr>
		<td>Income</td>
		<td>$<?=(isset($packages[$key]['payment_gross']['1'])) ? number_format($packages[$key]['payment_gross']['1'], 2) : "0.00" ?></td>
		<td>$<?=(isset($packages[$key]['payment_gross']['2'])) ? number_format($packages[$key]['payment_gross']['2'], 2) : "0.00" ?></td>
		<td>$<?=(isset($packages[$key]['payment_gross']['3'])) ? number_format($packages[$key]['payment_gross']['3'], 2) : "0.00" ?></td>
		<td>$<?=(isset($packages[$key]['payment_gross']['4'])) ? number_format($packages[$key]['payment_gross']['4'], 2) : "0.00" ?></td>
		<td>$<?=(is_array($packages[$key]['payment_gross'])) ? number_format(array_sum($packages[$key]['payment_gross']), 2) : "0.00" ?></td>
	</tr>
	</table><br />
	
	<?php
}
?>