* @version $Header$ * * Product class for handling all production manipulation * * @package bitcommerce * @author spider <*****@*****.**> */ define('HEADING_TITLE', 'Order' . (!empty($_REQUEST['oID']) ? ' #' . $_REQUEST['oID'] : 's')); require 'includes/application_top.php'; global $gBitThemes; $gBitThemes->loadJavascript(UTIL_PKG_URL . 'javascript/libs/dynarch/jscalendar/calendar.js'); $gBitThemes->loadJavascript(UTIL_PKG_URL . 'javascript/libs/dynarch/jscalendar/lang/calendar-en.js'); $gBitThemes->loadJavascript(UTIL_PKG_URL . 'javascript/libs/dynarch/jscalendar/calendar-setup.js'); $gBitThemes->loadCss(UTIL_PKG_URL . 'javascript/libs/dynarch/jscalendar/calendar-win2k-cold-1.css'); require_once BITCOMMERCE_PKG_PATH . 'classes/CommerceStatistics.php'; $stats = new CommerceStatistics(); $gBitSmarty->assign('statsByType', $stats->getRevenueByType($_REQUEST)); $statsByOption = $stats->getRevenueByOption($_REQUEST); $gBitSmarty->assign_by_ref('statsByOption', $statsByOption); $statsByOptionTotalUnits = array(); foreach ($statsByOption as $stat) { @($statsByOptionTotalUnits[$stat['products_options_id']] += $stat['total_units']); } $gBitSmarty->assign_by_ref('statsByOptionTotalUnits', $statsByOptionTotalUnits); print $gBitSmarty->fetch('bitpackage:bitcommerce/admin_stats_products_types.tpl'); require DIR_FS_ADMIN_INCLUDES . 'footer.php'; ?> <!-- footer_eof //--> <br /> </body>
require 'includes/application_top.php'; require_once BITCOMMERCE_PKG_PATH . 'classes/CommerceStatistics.php'; // $gBitSmarty->assign( 'loadAjax', 'mochikit' ); // $gBitSmarty->assign( 'mochikitLibs', array( 'DOM.js', 'Iter.js', 'Style.js', 'Signal.js', 'Color.js', 'Position.js', 'Visual.js', 'DragAndDrop.js', 'Sortable.js' ) ); if (count($_POST) > 2) { $gBitUser->verifyTicket(); } $_REQUEST['max_records'] = -1; if (!empty($_REQUEST['period'])) { $listHash['period'] = $_REQUEST['period']; } if (isset($_REQUEST['compare']) && is_array($_REQUEST['compare'])) { // flip array for easy lookup $_REQUEST['compare'] = array_flip($_REQUEST['compare']); } $stats = new CommerceStatistics(); if (!empty($_REQUEST['interests_id'])) { $interests = $gBitCustomer->getInterests(); $gBitSmarty->assign_by_ref('interestsList', $interests); $gBitSmarty->assign('interestsName', $interests[$_REQUEST['interests_id']]); $_REQUEST['orders_products'] = TRUE; $_REQUEST['orders_status_comparison'] = '>'; $_REQUEST['orders_status_id'] = 0; $gBitSmarty->assign('listOrders', order::getList($_REQUEST)); $gBitSystem->display('bitpackage:bitcommerce/admin_revenue_interest.tpl', tra('Revenue By Interest') . ' ' . $interests[$_REQUEST['interests_id']] . ' : ' . $_REQUEST['timeframe'], array('display_mode' => 'admin')); } elseif (!empty($_REQUEST['referer'])) { foreach (array('period', 'timeframe', 'referer', 'exclude', 'include', 'new_reg') as $param) { if (!empty($_REQUEST[$param])) { $_REQUEST['listInfo']['parameters'][$param] = $_REQUEST[$param]; } }
<?php // +----------------------------------------------------------------------+ // | bitcommerce | // +----------------------------------------------------------------------+ // | Copyright (c) 2010 bitcommerce.org | // | | // | http://www.bitcommerce.org | // +----------------------------------------------------------------------+ // | This source file is subject to version 2.0 of the GPL license | // +----------------------------------------------------------------------+ require 'includes/application_top.php'; require_once BITCOMMERCE_PKG_PATH . 'classes/CommerceStatistics.php'; if (count($_POST) > 2) { $gBitUser->verifyTicket(); } $_REQUEST['max_records'] = -1; if (!empty($_REQUEST['period'])) { $listHash['period'] = $_REQUEST['period']; } $stats = new CommerceStatistics(); $retainedCustomers = $stats->getRetainedCustomers($_REQUEST); $gBitSmarty->assign_by_ref('retainedCustomers', $retainedCustomers); $abandonedCustomers = $stats->getAbandonedCustomers($_REQUEST); $gBitSmarty->assign_by_ref('abandonedCustomers', $abandonedCustomers); $averageRetention = 100 * $retainedCustomers['totals']['customers'] / ($retainedCustomers['totals']['customers'] + $abandonedCustomers['totals']['customers']); $gBitSmarty->assign('averageRetention', $averageRetention); $gBitSystem->display('bitpackage:bitcommerce/admin_stats_customers.tpl', 'Customer Statistics', array('display_mode' => 'admin'));
} function commerce_statistics_referer_sort_orders_asc($a, $b) { return commerce_statistics_referer_sort($a, $b, 'orders', 1); } function commerce_statistics_referer_sort_units_desc($a, $b) { return commerce_statistics_referer_sort($a, $b, 'units'); } function commerce_statistics_referer_sort_units_asc($a, $b) { return commerce_statistics_referer_sort($a, $b, 'units', 1); } function commerce_statistics_referer_sort_customers_desc($a, $b) { return commerce_statistics_referer_sort($a, $b, 'customers'); } function commerce_statistics_referer_sort_customers_asc($a, $b) { return commerce_statistics_referer_sort($a, $b, 'customers', 1); } function commerce_statistics_referer_sort($a, $b, $pSort = 'revenue', $pDirection = '-1') { if ($a[$pSort] == $b[$pSort]) { return 0; } return $a[$pSort] < $b[$pSort] ? $pDirection * -1 : $pDirection * 1; } // }}} CommerceStatistics::loadSingleton();
<?php require_once BITCOMMERCE_PKG_PATH . 'classes/CommerceStatistics.php'; $stats = new CommerceStatistics(); $listHash = array('period' => 'Y-m-d', 'max_records' => 8); $statData = $stats->getAggregateRevenue($listHash); $gBitSmarty->assign_by_ref('stats', $statData); $gBitSmarty->assign('revenueTitle', 'Daily'); $gBitSmarty->assign('statPeriod', 'Y-m-d'); print '<div class="col-md-12 col-sm-6"><div class="well nopadding">' . $gBitSmarty->fetch('bitpackage:bitcommerce/admin_revenue_inc.tpl') . '</div></div>'; $listHash = array('period' => 'Y-\\WeekW', 'max_records' => 13); $statData = $stats->getAggregateRevenue($listHash); $gBitSmarty->assign_by_ref('stats', $statData); $gBitSmarty->assign('revenueTitle', 'Weekly'); $gBitSmarty->assign('statPeriod', 'Y-\\WeekW'); print '<div class="col-md-12 col-sm-6"><div class="well nopadding">' . $gBitSmarty->fetch('bitpackage:bitcommerce/admin_revenue_inc.tpl') . '</div></div>'; $listHash = array('period' => 'Y-m', 'max_records' => 13); $statData = $stats->getAggregateRevenue($listHash); $gBitSmarty->assign_by_ref('stats', $statData); $gBitSmarty->assign('revenueTitle', 'Monthly'); $gBitSmarty->assign('statPeriod', 'Y-m'); print '<div class="col-md-12 col-sm-6"><div class="well nopadding">' . $gBitSmarty->fetch('bitpackage:bitcommerce/admin_revenue_inc.tpl') . '</div></div>'; $listHash = array('period' => 'Y-\\QQ', 'max_records' => 5); $statData = $stats->getAggregateRevenue($listHash); $gBitSmarty->assign_by_ref('stats', $statData); $gBitSmarty->assign('revenueTitle', 'Quarterly'); $gBitSmarty->assign('statPeriod', 'Y-\\QQ'); print '<div class="col-md-12 col-sm-6"><div class="well nopadding">' . $gBitSmarty->fetch('bitpackage:bitcommerce/admin_revenue_inc.tpl') . '</div></div>'; $listHash = array('period' => 'Y-', 'max_records' => 10); $statData = $stats->getAggregateRevenue($listHash); $gBitSmarty->assign_by_ref('stats', $statData);
zen_redirect(zen_href_link_admin(FILENAME_CUSTOMERS, zen_get_all_get_params(array('user_id', 'action')) . 'user_id=' . $customers_id, 'NONSSL')); } else { if ($error == true) { $cInfo = new objectInfo($_POST); $processed = true; } } break; default: $customers = $gBitDb->Execute("select c.`customers_id`, c.`customers_gender`, c.`customers_firstname`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_lastname`, c.`customers_dob`, c.`customers_email_address`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ta.`entry_company`, a.`entry_street_address`, a.`entry_suburb`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ta.`entry_postcode`, a.`entry_city`, a.`entry_state`, a.`entry_zone_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ta.`entry_country_id`, c.`customers_telephone`, c.`customers_fax`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_newsletter`, c.`customers_default_address_id`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_email_format`, c.`customers_group_pricing`,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tc.`customers_authorization`, c.`customers_referral`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tfrom " . TABLE_CUSTOMERS . " c left join " . TABLE_ADDRESS_BOOK . " a\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ton c.`customers_default_address_id` = a.`address_book_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tand a.`customers_id` = c.`customers_id`\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE c.`customers_id` = '" . (int) $_GET['user_id'] . "'"); $cust = $customers->FetchRow(); $cInfo = new objectInfo($cust); $gBitSmarty->assign('cInfo', $cInfo); } } else { $stats = new CommerceStatistics(); if (empty($_REQUEST['interval'])) { $_REQUEST['interval'] = '3 years'; } $gBitSmarty->assign('customers', $stats->getCustomerActivity($_REQUEST)); } if (!empty($cInfo)) { $mid = 'bitpackage:bitcommerce/admin_customer_edit.tpl'; $title = tra('Edit Customer'); if ($processed == true) { if ($cInfo->customers_group_pricing) { $group_query = $gBitDb->Execute("select `group_name`, `group_percentage` from " . TABLE_GROUP_PRICING . " where `group_id` = '" . $cInfo->customers_group_pricing . "'"); echo $group_query->fields['group_name'] . ' ' . $group_query->fields['group_percentage'] . '%'; } } else { $groupPricing[] = 'None';