function ordersPerMonth()
{
$db = Database::getDatabase();
$orders = $db->getRows("SELECT DATE_FORMAT(dt, '%Y-%m') as dtstr, COUNT(*) FROM shine_orders WHERE type = 'PayPal' AND app_id = '{$this->id}' GROUP BY CONCAT(YEAR(dt), '-', MONTH(dt)) ORDER BY YEAR(dt) ASC, MONTH(dt) ASC");
$keys = gimme($orders, 'dtstr');
$values = gimme($orders, 'COUNT(*)');
$orders = array();
for ($i = 0; $i < count($keys); $i++) {
$orders[$keys[$i]] = $values[$i];
}
$first_order_date = $db->getValue("SELECT dt FROM shine_orders ORDER BY dt ASC LIMIT 1");
list($year, $month) = explode('-', dater($first_order_date, 'Y-n'));
do {
$month = str_pad($month, 2, '0', STR_PAD_LEFT);
if (!isset($orders["{$year}-{$month}"])) {
$orders["{$year}-{$month}"] = 0;
}
$month = intval($month) + 1;
if ($month == 13) {
$month = 1;
$year++;
}
} while ($year != date('Y') && $month != date('m'));
ksort($orders);
return $orders;
}
<?php
//Bootstrap SPF
require 'includes/master.inc.php';
//This loads up $user - $isadmin - $js
require 'includes/user.inc.php';
printr(gimme(Options::groups(), 'group'));
?>
<form method="post">
<select name='option' title='Options'>
<?php
echo get_options('options', 'key', 'key', @$_POST['option']);
?>
</select>
<select name='group' title='Groups of options'>
<?php
echo get_options('options_groups', 'group', 'group', @$_POST['group']);
?>
</select>
<select name='type' title='Type of variable'>
<?php
echo array2options(Options::types(), @$_POST['type']);
?>
</select>
<input type='hidden' name='action' value='update' />
<input type='submit' class='input-large' value='Update' />
</form>
<?php
function testGimme()
{
$arr = array(array(1, 3, 5, 7, 9), array(2, 4, 5, 6, 1), array(3, 1, 4, 4, 5));
$this->true(array(1, 2, 3) === gimme($arr));
$this->true(array(3, 4, 1) === gimme($arr, 1));
$this->true(array(9, 1, 5) === gimme($arr, 4));
}
<a href="<?php
echo $opw_fb->draw(false);
?>
" class="fb"><?php
$opw->draw();
?>
</a>
</div>
</div>
<?php
$db = Database::getDatabase();
// Downloads
$sel = "TO_DAYS(dt)";
$order_totals = $db->getRows("SELECT {$sel} as dtstr, COUNT(*) FROM downloads WHERE DATE_ADD(dt, INTERVAL 30 DAY) > NOW() GROUP BY {$sel} ORDER BY {$sel} ASC");
$opw = new googleChart(implode(',', gimme($order_totals, 'COUNT(*)')), 'bary');
$opw->showGrid = 1;
$opw->dimensions = '280x100';
$opw->setLabelsMinMax(4, 'left');
$opw_fb = clone $opw;
$opw_fb->dimensions = '640x400';
?>
<div class="block">
<div class="hd">
<h2>Downloads 30 Days</h2>
</div>
<div class="bd">
<a href="<?php
echo $opw_fb->draw(false);
?>
function testGimme()
{
$arr = array(array(1, 3, 5, 7, 9), array(2, 4, 5, 6, 1), array(3, 1, 4, 4, 5));
$this->assertEquals(array(1, 2, 3), gimme($arr));
$this->assertEquals(array(3, 4, 1), gimme($arr, 1));
$this->assertEquals(array(9, 1, 5), gimme($arr, 4));
}
