';
$earned_total = '';
$spent_total = '';
if ($first_month == 12) {
$next_month = '01';
$next_year = $first_year + 1;
} else {
$next_month = $first_month + 1;
if (strlen($next_month) == 1) {
$next_month = '0' . $next_month;
}
$next_year = $first_year;
}
$sql = '
SELECT *
FROM oam_listings
WHERE listings_date_bought > "' . $first_year . '-' . $first_month . '-00 00:00:00" and
listings_date_bought <= "' . $next_year . '-' . $next_month . '-00 00:00:00"';
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$spent_total = $spent_total + $row['listings_bought_price'] + $row['listings_listing_fee'] + $row['listings_sale_fee'] + $row['listings_shipping_fee'];
}
$result = mysql_query('
SELECT *
FROM oam_listings
WHERE listings_sold_date > "' . $first_year . '-' . $first_month . '-00 00:00:00" and
listings_sold_date <= "' . $next_year . '-' . $next_month . '-00 00:00:00"');
while ($row = mysql_fetch_array($result)) {
$earned_total = $earned_total + $row['listings_sold_price'] + $row['listings_shipping_charge'];
}
$row_style = ternary($row_style,'main-row-1','main-row-2');
$profit = $earned_total - $spent_total;
$profit = number_format($profit,2);
if ($profit < 0) {
$profit = '$' . $profit . '
';
} else {
$profit = '$' . $profit . '
';
}
$first_year = $next_year;
$first_month = $next_month;
$expense_table = '
| ' . date('M',strtotime($first_year . '-' . $first_month . '-00 00:00:00')) . ' |
' . date('Y',strtotime($first_year . '-' . $first_month . '-00 00:00:00')) . ' |
$' . number_format($spent_total,2) . ' |
$' .number_format($earned_total,2) . ' |
' . $profit . ' |
' . $expense_table;
}
?>
Earnings Statistics
Add New Listings | Manage Listings | Earnings Statistics | Log Out | Instructions
| Month |
Year |
Expense |
Income |
Profit |
Auction Business Manager Developed by www.Small-Business-Ideas.net