public function getData($days)
{
$key_column = array('type' => 'string', 'title' => ct("Currency"));
$columns = array();
$columns[] = array('type' => 'string', 'title' => ct("Currency"), 'heading' => true);
$columns[] = array('type' => 'string', 'title' => ct("Total"));
// a table of each currency
// get all balances
$balances = get_all_summary_instances($this->getUser());
$summaries = get_all_summary_currencies($this->getUser());
$currencies = get_all_currencies();
$last_updated = find_latest_created_at($balances, "total");
// create data
$data = array();
foreach ($currencies as $c) {
if (isset($summaries[$c])) {
$balance = isset($balances['total' . $c]) ? $balances['total' . $c]['balance'] : 0;
$data[] = array("<span title=\"" . htmlspecialchars(get_currency_name($c)) . "\">" . get_currency_abbr($c) . "</span>", currency_format($c, demo_scale($balance), 4));
}
}
return array('key' => $key_column, 'columns' => $columns, 'data' => $data, 'last_updated' => $last_updated, 'add_more_currencies' => true, 'no_header' => true);
}
function getCompositionSources($days, $extra_days)
{
$sources = array();
$summary_currencies = get_all_summary_currencies($this->getUser());
foreach (get_all_currencies() as $cur) {
if (isset($summary_currencies[$cur])) {
if ($cur == 'btc') {
// we can't LIMIT by days here, because we may have many accounts for one exchange
// first get summarised data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM graph_data_summary WHERE user_id=:user_id AND summary_type='totalbtc'\n AND data_date > DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY data_date DESC", 'key' => 'data_date', 'balance_key' => 'balance_closing');
// and then get more recent data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM summary_instances WHERE is_daily_data=1 AND summary_type='totalbtc'\n AND user_id=:user_id AND created_at >= DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY created_at DESC", 'key' => 'created_at', 'balance_key' => 'balance');
} else {
// we can't LIMIT by days here, because we may have many accounts for one exchange
// first get summarised data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM graph_data_summary WHERE user_id=:user_id AND summary_type='equivalent_btc_{$cur}'\n AND data_date > DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY data_date DESC", 'key' => 'data_date', 'balance_key' => 'balance_closing');
// and then get more recent data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM summary_instances WHERE is_daily_data=1 AND summary_type='equivalent_btc_{$cur}'\n AND user_id=:user_id AND created_at >= DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY created_at DESC", 'key' => 'created_at', 'balance_key' => 'balance');
}
}
}
return $sources;
}
/**
* This page is the second page in a series of wizards to configure a user account.
* A user may revisit this page at any time to reconfigure their account.
* This page allows the user to select which kind of accounts to add.
*/
require_login();
require __DIR__ . "/../layout/templates.php";
page_header(t("Add Accounts and Addresses"), "page_wizard_accounts", array('js' => 'wizard', 'class' => 'page_accounts'));
$user = get_user(user_id());
require_user($user);
$messages = array();
// get all of our accounts
$accounts = user_limits_summary(user_id());
// get our offset values
require __DIR__ . "/../graphs/util.php";
$summaries = get_all_summary_currencies();
$currencies = get_all_currencies();
require_template("wizard_accounts");
?>
<div class="wizard">
<ul class="account-type">
<li><a href="<?php
echo htmlspecialchars(url_for('wizard_accounts_addresses'));
?>
"><?php
echo t("Address");
?>
<?php
/**
* Like {@link #get_all_summary_currencies()}, but returns
* a list of currencies rather than summary keys.
*/
function get_all_user_currencies($user_id = false)
{
return array_keys(get_all_summary_currencies($user_id));
}
/**
* Get all of the defined graph types. Used for display and validation.
*/
function graph_types()
{
$total_fiat_currencies = array();
foreach (get_total_conversion_summary_types() as $c) {
$total_fiat_currencies[] = $c['title'];
}
$total_fiat_currencies = implode_english($total_fiat_currencies);
$data = array('category_general' => array('title' => t('General'), 'category' => true), 'subcategory_general' => array('title' => t('General graphs'), 'subcategory' => true), 'btc_equivalent' => array('title' => t('Equivalent BTC balances (pie)'), 'heading' => t('Equivalent BTC'), 'description' => t('A pie chart representing the overall proportional value of all currencies if they were all converted into BTC.') . '<p>' . t('Exchanges used:') . ' ' . get_default_exchange_text(array_diff(get_all_currencies(), array('btc'))) . '.', 'default_width' => get_site_config('default_user_graph_height'), 'uses_summaries' => true), 'btc_equivalent_graph' => array('title' => t('Equivalent BTC balances (graph)'), 'heading' => t('Equivalent BTC'), 'description' => t('A line graph displaying the historical value of all currencies if they were all converted into BTC.') . '<p>' . t('Exchanges used:') . ' ' . get_default_exchange_text(array_diff(get_all_currencies(), array('btc'))) . '.', 'days' => true, 'uses_summaries' => true), 'btc_equivalent_stacked' => array('title' => t('Equivalent BTC balances (stacked)'), 'heading' => t('Equivalent BTC'), 'description' => t('A stacked area graph displaying the historical value of all currencies if they were all converted into BTC.') . '<p>' . t('Exchanges used:') . ' ' . get_default_exchange_text(array_diff(get_all_currencies(), array('btc'))) . '.', 'days' => true, 'uses_summaries' => true), 'btc_equivalent_proportional' => array('title' => t('Equivalent BTC balances (proportional)'), 'heading' => t('Equivalent BTC'), 'description' => t('A stacked area graph displaying the proportional historical value of all currencies if they were all converted into BTC.') . '<p>' . t('Exchanges used:') . ' ' . get_default_exchange_text(array_diff(get_all_currencies(), array('btc'))) . '.', 'days' => true, 'uses_summaries' => true), 'ticker_matrix' => array('title' => t('All currencies exchange rates (matrix)'), 'heading' => t('All exchanges'), 'description' => t('A matrix displaying the current bid/ask of all of the currencies and exchanges :interested_in.', array(':interested_in' => link_to(url_for('wizard_currencies'), t('you are interested in'))))), 'balances_table' => array('title' => t('Total balances (table)'), 'heading' => t('Total balances'), 'description' => t('A table displaying the current sum of all your currencies (before any conversions).'), 'default_width' => get_site_config('default_user_graph_height'), 'uses_summaries' => true), 'total_converted_table' => array('title' => t('Total converted fiat balances (table)'), 'heading' => t('Converted fiat'), 'description' => t('A table displaying the equivalent value of all cryptocurrencies and fiat currencies if they were immediately converted into fiat currencies. Cryptocurrencies are converted via BTC.') . '<p>' . t('Supports :currencies.', array(':currencies' => $total_fiat_currencies)) . '<p>' . t('Exchanges used:') . ' ' . get_default_exchange_text(array_diff(get_all_currencies(), array('btc'))) . '.', 'default_width' => get_site_config('default_user_graph_height'), 'uses_summaries' => true), 'crypto_converted_table' => array('title' => t('Total converted crypto balances (table)'), 'heading' => t('Converted crypto'), 'description' => t('A table displaying the equivalent value of all cryptocurrencies - but not fiat currencies - if they were immediately converted into other cryptocurrencies.') . '<p>' . t('Exchanges used:') . ' ' . get_default_exchange_text(array_diff(get_all_cryptocurrencies(), array('btc'))) . '.', 'default_width' => get_site_config('default_user_graph_height'), 'uses_summaries' => true), 'balances_offset_table' => array('title' => t('Total balances with offsets (table)'), 'heading' => t('Total balances'), 'description' => t('A table displaying the current sum of all currencies (before any conversions), along with the current total offset values of each currency.'), 'uses_summaries' => true));
$summaries = array();
$conversions = array();
if (user_logged_in()) {
$summaries = get_all_summary_currencies();
$conversions = get_all_conversion_currencies();
}
$data['category_summaries'] = array('title' => t('Your summaries'), 'category' => true);
$data['subcategory_summaries_total'] = array('title' => t('Historical currency value'), 'subcategory' => true);
// we can generate a list of summary daily graphs from all the currencies that we support
foreach (get_summary_types() as $key => $summary) {
$cur = $summary['currency'];
$data["total_" . $cur . "_daily"] = array('title' => t("Total :currency historical (graph)", array(':currency' => get_currency_name($cur))), 'heading' => t("Total :currency", array(':currency' => get_currency_abbr($cur))), 'description' => t("A line graph displaying the historical sum of your :currency (before any conversions).", array(':currency' => get_currency_name($cur))), 'hide' => !isset($summaries[$cur]), 'days' => true, 'delta' => true, 'technical' => true, 'uses_summaries' => true);
}
$data['subcategory_summaries_crypto2'] = array('title' => t('Historical converted value'), 'subcategory' => true);
foreach (get_crypto_conversion_summary_types() as $key => $summary) {
$cur = $summary['currency'];
$data["crypto2" . $key . "_daily"] = array('title' => t("Converted :title historical (graph)", array(':title' => $summary['title'])), 'heading' => t("Converted :title", array(':title' => $summary['short_title'])), 'description' => t("A line graph displaying the historical equivalent value of all cryptocurrencies - and not other fiat currencies - if they were immediately converted to :title.", array(':title' => $summary['title'])), 'hide' => !isset($conversions['summary_' . $key]), 'days' => true, 'delta' => true, 'technical' => true, 'uses_summaries' => true);
}
/*
* Issue #112 reported that 'all2CUR' was not correctly converting fiat currencies other than CUR.
* Rather than renaming 'all2CUR' as 'all cryptocurrencies and CUR', which doesn't seem to be particularly useful
* - and it will mean we'll have to track two new summaries for every currency -
* as of 0.19 this will now correctly be calculated as 'all cryptocurrencies and fiat currencies'. This means that there
* will be a jump in the value of data when deployed.
*/
foreach (get_total_conversion_summary_types() as $key => $summary) {
$cur = $summary['currency'];
$data["all2" . $key . "_daily"] = array('title' => t("Converted :title historical (graph)", array(':title' => $summary['title'])), 'heading' => t("Converted :title", array(':title' => $summary['short_title'])), 'description' => t("A line graph displaying the historical equivalent value of all cryptocurrencies and fiat currencies if they were immediately converted to :title (where possible).", array(':title' => $summary['title'])), 'hide' => !isset($conversions['summary_' . $key]), 'days' => true, 'delta' => true, 'technical' => true, 'uses_summaries' => true);
}
$data['subcategory_summaries_composition'] = array('title' => t('Total balance composition'), 'subcategory' => true);
// we can generate a list of composition graphs from all of the currencies that we support
foreach (get_all_currencies() as $currency) {
$data["composition_" . $currency . "_pie"] = array('title' => t("Total :currency balance composition (pie)", array(':currency' => get_currency_name($currency))), 'heading' => t("Total :currency", array(':currency' => get_currency_abbr($currency))), 'description' => t("A pie chart representing all of the sources of your total :currency balance (before any conversions).", array(':currency' => get_currency_name($currency))), 'hide' => !isset($summaries[$currency]), 'default_width' => get_site_config('default_user_graph_height'), 'uses_summaries' => true);
}
$data['subcategory_summaries_graph'] = array('title' => t('All balances (graph)'), 'subcategory' => true);
foreach (get_all_currencies() as $currency) {
$data["composition_" . $currency . "_daily"] = array('title' => t("All :currency balances (graph)", array(':currency' => get_currency_name($currency))), 'heading' => t("All :currency balances", array(':currency' => get_currency_abbr($currency))), 'description' => t("A line graph representing all of the sources of your total :currency balance (before any conversions).", array(':currency' => get_currency_name($currency))), 'days' => true, 'hide' => !isset($summaries[$currency]), 'uses_summaries' => true);
}
$data['subcategory_summaries_table'] = array('title' => t('All balances (table)'), 'subcategory' => true);
foreach (get_all_currencies() as $currency) {
$data["composition_" . $currency . "_table"] = array('title' => t("Your :currency balances (table)", array(':currency' => get_currency_name($currency))), 'heading' => t("Your :currency balances", array(':currency' => get_currency_abbr($currency))), 'description' => t("A table displaying all of your :currency balances and the total balance (before any conversions).", array(':currency' => get_currency_name($currency))), 'hide' => !isset($summaries[$currency]), 'uses_summaries' => true);
}
$data['subcategory_summaries_stacked'] = array('title' => t('All balances (stacked)'), 'subcategory' => true);
foreach (get_all_currencies() as $currency) {
$data["composition_" . $currency . "_stacked"] = array('title' => t("All :currency balances (stacked)", array(':currency' => get_currency_name($currency))), 'heading' => t("All :currency balances", array(':currency' => get_currency_abbr($currency))), 'description' => t("A stacked area graph displaying the historical value of your total :currency balance (before any conversions).", array(':currency' => get_currency_name($currency))), 'days' => true, 'hide' => !isset($summaries[$currency]), 'uses_summaries' => true);
}
$data['subcategory_summaries_proportional'] = array('title' => t('All balances (proportional)'), 'subcategory' => true);
foreach (get_all_currencies() as $currency) {
$data["composition_" . $currency . "_proportional"] = array('title' => t("All :currency balances (proportional)", array(':currency' => get_currency_name($currency))), 'heading' => t("All :currency balances", array(':currency' => get_currency_abbr($currency))), 'description' => t("A stacked area graph displaying the proportional historical value of your total :currency balance (before any conversions).", array(':currency' => get_currency_name($currency))), 'days' => true, 'hide' => !isset($summaries[$currency]), 'uses_summaries' => true);
}
$data['category_hashrate'] = array('title' => t('Your mining'), 'category' => true);
$data['category_hashrate_hashrate'] = array('title' => t('Historical hashrates'), 'subcategory' => true);
// and for each cryptocurrency that can be hashed
foreach (get_all_hashrate_currencies() as $cur) {
$data["hashrate_" . $cur . "_daily"] = array('title' => t(":currency historical MHash/s (graph)", array(':currency' => get_currency_name($cur))), 'heading' => t(":currency MHash/s", array(':currency' => get_currency_abbr($cur))), 'description' => t("A line graph displaying the historical hashrate sum of all workers mining :currency across all mining pools (in MHash/s).", array(':currency' => get_currency_name($cur))), 'hide' => !isset($summaries[$cur]), 'days' => true, 'delta' => true, 'technical' => true, 'uses_summaries' => true);
}
// merge in graph_types_public() here
foreach (graph_types_public($summaries) as $key => $public_data) {
// but add 'hide' parameter to hide irrelevant currencies
if (isset($public_data['pairs'])) {
$pairs = $public_data['pairs'];
$public_data['hide'] = !(isset($summaries[$pairs[0]]) && isset($summaries[$pairs[1]]));
}
$data[$key] = $public_data;
}
$data['subcategory_layout'] = array('title' => t('Layout tools'), 'subcategory' => true);
$data['linebreak'] = array('title' => t('Line break'), 'description' => t('Forces a line break at a particular location. Select \'Enable layout editing\' to move it.'), 'heading' => t('Line break'));
$data['heading'] = array('title' => t('Heading'), 'description' => t("Displays a line of text as a heading at a particular location. Also functions as a line break. Select 'Enable layout editing' to move it.'"), 'string0' => t("Example heading"), 'heading' => t('Heading'));
// add sample images
$images = array('btc_equivalent' => 'btc_equivalent.png', 'composition_btc_pie' => 'composition_btc_pie.png', 'composition_ltc_pie' => 'composition_ltc_pie.png', 'composition_nmc_pie' => 'composition_nmc_pie.png', 'btce_btcnmc_daily' => 'btce_btcnmc_daily.png', 'btce_btcftc_daily' => 'btce_btcftc_daily.png', 'btce_btcltc_daily' => 'btce_btcltc_daily.png', 'bitstamp_usdbtc_daily' => 'bitstamp_usdbtc_daily.png', 'bitnz_nzdbtc_daily' => 'bitnz_nzdbtc_daily.png', 'btcchina_cnybtc_daily' => 'btcchina_cnybtc_daily.png', 'cexio_btcghs_daily' => 'cexio_btcghs_daily.png', 'vircurex_btcltc_daily' => 'vircurex_btcltc_daily.png', 'vircurex_btcdog_daily' => 'vircurex_btcdog_daily.png', 'themoneyconverter_usdeur_daily' => 'themoneyconverter_usdeur_daily.png', 'themoneyconverter_usdaud_daily' => 'themoneyconverter_usdaud_daily.png', 'themoneyconverter_usdcad_daily' => 'themoneyconverter_usdcad_daily.png', 'themoneyconverter_usdnzd_daily' => 'themoneyconverter_usdnzd_daily.png', 'crypto2btc_daily' => 'crypto2btc_daily.png', 'crypto2ltc_daily' => 'crypto2ltc_daily.png', 'crypto2nmc_daily' => 'crypto2nmc_daily.png', 'crypto2dog_daily' => 'crypto2dog_daily.png', 'all2nzd_bitnz_daily' => 'all2nzd_bitnz_daily.png', 'all2cad_virtex_daily' => 'all2cad_virtex_daily.png', 'all2usd_bitstamp_daily' => 'all2usd_bitstamp_daily.png', 'all2usd_btce_daily' => 'all2usd_btce_daily.png', 'btc_equivalent_graph' => 'btc_equivalent_graph.png', 'btc_equivalent_proportional' => 'btc_equivalent_proportional.png', 'btc_equivalent_stacked' => 'btc_equivalent_stacked.png', 'total_btc_daily' => 'total_btc_daily.png', 'total_ltc_daily' => 'total_ltc_daily.png', 'total_nmc_daily' => 'total_nmc_daily.png', 'total_ghs_daily' => 'total_ghs_daily.png', 'hashrate_ltc_daily' => 'hashrate_ltc_daily.png', 'balances_table' => 'balances_table.png', 'balances_offset_table' => 'balances_offset_table.png', 'crypto_converted_table' => 'crypto_converted_table.png', 'total_converted_table' => 'total_converted_table.png', 'composition_btc_daily' => 'composition_btc_daily.png', 'composition_ltc_daily' => 'composition_ltc_daily.png', 'composition_nmc_daily' => 'composition_ltc_daily.png', 'composition_ftc_daily' => 'composition_ltc_daily.png', 'composition_ppc_daily' => 'composition_ltc_daily.png', 'composition_nvc_daily' => 'composition_ltc_daily.png', 'composition_dog_daily' => 'composition_dog_daily.png', 'composition_btc_table' => 'composition_btc_table.png', 'composition_ltc_table' => 'composition_ltc_table.png', 'composition_nmc_table' => 'composition_nmc_table.png', 'composition_ftc_table' => 'composition_ltc_table.png', 'composition_ppc_table' => 'composition_ltc_table.png', 'composition_nvc_table' => 'composition_ltc_table.png', 'composition_dog_table' => 'composition_dog_table.png', 'composition_btc_proportional' => 'composition_btc_proportional.png', 'composition_ltc_proportional' => 'composition_ltc_proportional.png', 'composition_nmc_proportional' => 'composition_nmc_proportional.png', 'composition_ftc_proportional' => 'composition_ltc_proportional.png', 'composition_ppc_proportional' => 'composition_ltc_proportional.png', 'composition_nvc_proportional' => 'composition_ltc_proportional.png', 'composition_btc_stacked' => 'composition_btc_stacked.png', 'composition_ltc_stacked' => 'composition_ltc_stacked.png', 'composition_nmc_stacked' => 'composition_ltc_stacked.png', 'composition_ftc_stacked' => 'composition_ltc_stacked.png', 'composition_ppc_stacked' => 'composition_ltc_stacked.png', 'composition_nvc_stacked' => 'composition_ltc_stacked.png', 'composition_ghs_stacked' => 'composition_ghs_stacked.png', 'average_usdbtc_daily' => 'average_usdbtc_daily.png', 'average_usdbtc_markets' => 'average_usdbtc_markets.png', 'average_cadbtc_daily' => 'average_cadbtc_daily.png', 'average_cadbtc_markets' => 'average_cadbtc_markets.png', 'average_audbtc_daily' => 'average_audbtc_daily.png', 'average_audbtc_markets' => 'average_audbtc_markets.png', 'average_nzdbtc_daily' => 'average_nzdbtc_daily.png', 'average_nzdbtc_markets' => 'average_nzdbtc_markets.png', 'average_btcdog_daily' => 'average_btcdog_daily.png', 'average_btcdog_markets' => 'average_btcdog_markets.png', 'average_btcltc_daily' => 'average_btcltc_daily.png', 'average_btcltc_markets' => 'average_btcltc_markets.png', 'ticker_matrix' => 'ticker_matrix.png', 'calculator' => 'calculator.png');
$data = add_example_images($data, $images);
return $data;
}
* type of balance.
*/
require_login();
require __DIR__ . "/../layout/templates.php";
$user = get_user(user_id());
require __DIR__ . "/_profile_common.php";
page_header(t("Your Currencies"), "page_your_currencies", array('js' => array('accounts'), 'class' => 'report_page'));
// get all pages
$q = db()->prepare("SELECT * FROM graph_pages WHERE user_id=? AND is_removed=0 ORDER BY page_order ASC, id ASC");
$q->execute(array(user_id()));
$pages = $q->fetchAll();
// get all of our latest balances, ignoring currencies we're not interested in
$balances = array();
$last_updated = array();
require __DIR__ . "/../graphs/util.php";
foreach (get_all_summary_currencies() as $cur => $summary) {
$balances[$cur] = array();
}
$q = db()->prepare("SELECT * FROM balances WHERE user_id=? AND is_recent=1");
$q->execute(array(user_id()));
while ($balance = $q->fetch()) {
if (isset($balances[$balance['currency']])) {
if (!isset($balances[$balance['currency']][$balance['exchange']])) {
$balances[$balance['currency']][$balance['exchange']] = 0;
}
$balances[$balance['currency']][$balance['exchange']] += demo_scale($balance['balance']);
$last_updated[$balance['exchange']] = $balance['created_at'];
}
}
// need to also get address balances
$summary_balances = get_all_summary_instances();
/**
* Calculate all of the different types of managed graphs that
* may be provided to a given user, in each category of managed
* graphs (see get_managed_graph_categories()).
*/
function calculate_all_managed_graphs($user)
{
$result = array();
$summaries = get_all_summary_currencies();
$all_summaries = get_all_summaries();
$currencies = get_all_currencies();
$accounts = account_data_grouped();
$wallets = get_supported_wallets();
$order_currency = array();
foreach (get_all_currencies() as $c) {
$order_currency[$c] = count($order_currency);
}
$order_exchange = array();
foreach (get_all_exchanges() as $key => $label) {
$order_exchange[$key] = count($order_exchange) * 10;
}
$default_order = array('btc_equivalent' => -1000, 'composition_pie' => 0, 'balances_table' => 1000, 'exchange_daily' => 2000, 'total_daily' => 3000, 'all_daily' => 4000, 'composition_daily' => 5000, 'hashrate_daily' => 6000);
$result['summary'] = array();
$result['all_summary'] = array();
$result['summary']['balances_table'] = array('order' => $default_order['balances_table'], 'width' => get_site_config('default_user_graph_height'), 'free' => true, 'priority' => 1);
if (count($summaries) >= 2 && isset($summaries['btc'])) {
$result['summary']['btc_equivalent'] = array('order' => $default_order['btc_equivalent'], 'width' => get_site_config('default_user_graph_height'), 'free' => true, 'priority' => 2);
}
foreach (get_all_cryptocurrencies() as $cur) {
if (isset($summaries[$cur])) {
$result['summary']["composition_" . $cur . "_pie"] = array('order' => $default_order['composition_pie'] + $order_currency[$cur], 'width' => get_site_config('default_user_graph_height'), 'free' => $cur == $user['preferred_crypto'], 'priority' => $cur == $user['preferred_crypto'] ? 100 : 300 + $order_currency[$cur]);
$result['summary']["composition_" . $cur . "_daily"] = array('order' => $default_order['composition_daily'] + $order_currency[$cur], 'free' => $cur == $user['preferred_crypto'], 'priority' => $cur == $user['preferred_crypto'] ? 105 : 200 + $order_currency[$cur]);
$result['summary']['total_' . $cur . '_daily'] = array('order' => $default_order['total_daily'] + $order_currency[$cur], 'source' => $cur, 'free' => $cur == $user['preferred_crypto'], 'priority' => 100 + $order_currency[$cur]);
}
}
foreach (get_all_commodity_currencies() as $cur) {
if (isset($summaries[$cur])) {
$result['summary']['total_' . $cur . '_daily'] = array('order' => $default_order['total_daily'] + $order_currency[$cur], 'source' => $cur, 'free' => $cur == $user['preferred_crypto'], 'priority' => 100 + $order_currency[$cur]);
}
}
$result['currency'] = array();
$result['all_currency'] = array();
foreach (get_exchange_pairs() as $exchange => $pairs) {
foreach ($pairs as $pair) {
// we are interested in both of these currencies
if (isset($summaries[$pair[0]]) && isset($summaries[$pair[1]])) {
// and one of these currencies are a preferred currency
if ($pair[0] == $user['preferred_crypto'] || $pair[0] == $user['preferred_fiat'] || $pair[1] == $user['preferred_crypto'] || $pair[1] == $user['preferred_fiat']) {
// and we have a summary instance for this pair somewhere
$possible_summaries = array('summary_' . $pair[0] . '_' . $exchange, 'summary_' . $pair[1] . '_' . $exchange);
if (in_array($pair[0], get_all_cryptocurrencies())) {
$possible_summaries[] = "summary_" . $pair[0];
}
if (in_array($pair[1], get_all_cryptocurrencies())) {
$possible_summaries[] = "summary_" . $pair[1];
}
foreach ($possible_summaries as $p) {
if (isset($all_summaries[$p])) {
$is_default = is_fiat_currency($pair[0]) && get_default_currency_exchange($pair[0]) == $exchange || is_fiat_currency($pair[1]) && get_default_currency_exchange($pair[1]) == $exchange;
$result['all_currency'][$exchange . "_" . $pair[0] . $pair[1] . "_daily"] = array('order' => $default_order['exchange_daily'] + $order_exchange[$exchange] + $order_currency[$pair[0]], 'source' => $p, 'priority' => 150 + $order_currency[$pair[0]]);
if ($is_default) {
$result['currency'][$exchange . "_" . $pair[0] . $pair[1] . "_daily"] = array('order' => $default_order['exchange_daily'] + $order_exchange[$exchange] + $order_currency[$pair[0]], 'source' => $p, 'free' => true, 'priority' => 150 + $order_currency[$pair[0]]);
}
// don't display all2btc etc
if (!in_array(substr($p, strlen("summary_")), get_all_cryptocurrencies())) {
$result['all_summary']['all2' . substr($p, strlen("summary_")) . '_daily'] = array('order' => $default_order['all_daily'] + $order_exchange[$exchange] + $order_currency[$pair[0]], 'source' => $p, 'priority' => 50 + $order_currency[$pair[0]]);
if ($is_default) {
$result['summary']['all2' . substr($p, strlen("summary_")) . '_daily'] = array('order' => $default_order['all_daily'] + $order_exchange[$exchange] + $order_currency[$pair[0]], 'source' => $p, 'free' => $pair[0] == $user['preferred_crypto'] || $pair[0] == $user['preferred_fiat'], 'priority' => 5 + $order_currency[$pair[0]]);
}
}
break;
}
}
}
}
}
}
$result['securities'] = array();
// no graphs to put in here yet...
// TODO in the future: securities composition graphs? e.g. composition_litecoinglobal_daily
$result['mining'] = array();
foreach (get_all_hashrate_currencies() as $cur) {
if (isset($summaries[$cur])) {
// we need to have at least one pool that supports reporting hashrate
$has_hashing_account = false;
foreach ($accounts['Mining pools'] as $key => $account) {
if (!isset($wallets[$key])) {
continue;
}
$instances = get_all_user_account_instances($key);
if ($instances) {
if (in_array('hash', $wallets[$key])) {
$has_hashing_account = $key;
}
}
}
if (!$has_hashing_account) {
continue;
}
$result['mining']["hashrate_" . $cur . "_daily"] = array('order' => $default_order['hashrate_daily'] + $order_currency[$cur], 'source' => $has_hashing_account, 'free' => $cur == $user['preferred_crypto'], 'priority' => 150 + $order_currency[$cur]);
}
}
// all 'summary' are also 'all_summary' etc
foreach ($result['summary'] as $key => $value) {
$result['all_summary'][$key] = $value;
}
foreach ($result['currency'] as $key => $value) {
$result['all_currency'][$key] = $value;
}
// go through each category and sort by order
foreach ($result as $key => $value) {
uasort($result[$key], '_sort_by_order_key');
}
return $result;
}
public function getData($days)
{
$key_column = array('type' => 'string', 'title' => ct("Currency"));
$columns = array();
$last_updated = false;
$columns[] = array('type' => 'string', 'title' => "", 'heading' => true);
// a matrix table of each currency vs. each currency, and their current
// last_trade and volume on each exchange the user is interested in
$currencies = get_all_currencies();
$summaries = get_all_summary_currencies($this->getUser());
$conversion = get_all_conversion_currencies($this->getUser());
$graph["last_updated"] = 0;
$interested = array();
foreach ($currencies as $c) {
if (isset($summaries[$c])) {
$interested[] = $c;
$columns[] = array('type' => 'string', 'title' => get_currency_abbr($c));
}
}
foreach ($interested as $c1) {
$row = array(get_currency_abbr($c1));
foreach ($interested as $c2) {
// go through each exchange pair
$cell = "";
foreach (get_exchange_pairs() as $exchange => $pairs) {
foreach ($pairs as $pair) {
if ($c1 == $pair[0] && $c2 == $pair[1]) {
$q = db()->prepare("SELECT * FROM ticker_recent WHERE exchange=? AND currency1=? AND currency2=? LIMIT 1");
$q->execute(array($exchange, $c1, $c2));
if ($ticker = $q->fetch()) {
// TODO currency_format should be a graph option
$exchange_short = strlen($exchange) > 8 ? substr($exchange, 0, 7) . "..." : $exchange;
$cell .= "<li><span class=\"rate\">" . number_format_html($ticker['last_trade'], 4) . "</span> " . ($ticker['volume'] == 0 ? "" : "<span class=\"volume\">(" . number_format_html($ticker['volume'], 4) . ")</span>");
$cell .= " <span class=\"exchange\" title=\"" . htmlspecialchars(get_exchange_name($exchange)) . "\">[" . htmlspecialchars($exchange_short) . "]</span>";
$cell .= "</li>\n";
$last_updated = max($last_updated, strtotime($ticker['created_at']));
} else {
$cell .= "<li class=\"warning\">" . t("Could not find rate for :exchange: :pair", array(':exchange' => $exchange, ':pair' => $c1 . "/" . $c2)) . "</li>\n";
}
}
}
}
if ($cell) {
$cell = "<ul class=\"rate_matrix\">" . $cell . "</ul>";
}
$row[] = $cell;
}
$data[] = $row;
}
// now delete any empty rows or columns
// columns
$deleteRows = array();
$deleteColumns = array();
for ($i = 0; $i < count($data) - 1; $i++) {
$empty = true;
for ($j = 1; $j < count($data[$i]); $j++) {
if ($data[$i][$j]) {
$empty = false;
break;
}
}
if ($empty) {
$deleteRows[] = $i;
}
}
for ($i = 1; $i < count($data); $i++) {
$empty = true;
for ($j = 0; $j < count($data[$i]) - 1; $j++) {
if ($data[$j][$i]) {
$empty = false;
break;
}
}
if ($empty) {
$deleteColumns[] = $i;
}
}
$new_data = array();
foreach ($data as $i => $row) {
if (in_array($i, $deleteRows)) {
continue;
}
$x = array();
foreach ($data[$i] as $j => $cell) {
if (in_array($j, $deleteColumns)) {
continue;
}
$x[] = $cell;
}
$new_data[] = $x;
}
foreach ($deleteColumns as $i) {
unset($columns[$i]);
}
$columns = array_values($columns);
return array('key' => $key_column, 'columns' => $columns, 'data' => $new_data, 'last_updated' => $last_updated, 'add_more_currencies' => true);
}
function render_balances_btc_equivalent_graph($graph, $user_id, $stacked = false, $proportional = false)
{
$days = get_graph_days($graph);
$extra_days = extra_days_necessary($graph);
$sources = array();
$summary_currencies = get_all_summary_currencies();
foreach (get_all_currencies() as $cur) {
if (isset($summary_currencies[$cur])) {
if ($cur == 'btc') {
// we can't LIMIT by days here, because we may have many accounts for one exchange
// first get summarised data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM graph_data_summary WHERE user_id=:user_id AND summary_type='totalbtc'\n AND data_date > DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY data_date DESC", 'key' => 'data_date', 'balance_key' => 'balance_closing');
// and then get more recent data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM summary_instances WHERE is_daily_data=1 AND summary_type='totalbtc'\n AND user_id=:user_id AND created_at >= DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY created_at DESC", 'key' => 'created_at', 'balance_key' => 'balance');
} else {
// we can't LIMIT by days here, because we may have many accounts for one exchange
// first get summarised data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM graph_data_summary WHERE user_id=:user_id AND summary_type='equivalent_btc_{$cur}'\n AND data_date > DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY data_date DESC", 'key' => 'data_date', 'balance_key' => 'balance_closing');
// and then get more recent data
$sources[] = array('query' => "SELECT *, '{$cur}' AS exchange FROM summary_instances WHERE is_daily_data=1 AND summary_type='equivalent_btc_{$cur}'\n AND user_id=:user_id AND created_at >= DATE_SUB(NOW(), INTERVAL " . ($days + $extra_days) . " DAY) ORDER BY created_at DESC", 'key' => 'created_at', 'balance_key' => 'balance');
}
}
}
render_sources_graph($graph, $sources, array(), $user_id, 'render_graph_return_exchange_currency', 'last_total', $stacked, $proportional);
}
