* @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>
Esempio n. 2
0
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];
        }
    }
Esempio n. 3
0
<?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'));
Esempio n. 4
0
}
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();
Esempio n. 5
0
<?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);
Esempio n. 6
0
                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'] . '&nbsp;' . $group_query->fields['group_percentage'] . '%';
        }
    } else {
        $groupPricing[] = 'None';