/**
* 加载数据库
*/
public function load_db()
{
include_once LIBS_DIR . 'pdo.class.php';
$dbh = new DB_PDO(DB_DSN, DB_USER, DB_PASSWORD);
$dbh->set_table_prefix(DB_TABLE_PREFIX);
$dbh->set_options(array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8'));
return $dbh;
}
function readFromDB($dataSourceName)
{
$result = parent::readFromDB($dataSourceName);
if ($dataSourceName === 'everymonth') {
$result = array();
$year = 2010;
for ($month = 1; $month < 13; $month++) {
$startDate = new DateTime("{$year}-{$month}-1 0:0:0");
$endDate = $startDate->modify('next month');
$result[] = array('year' => $year, 'month' => $month, 'startdt' => "{$year}-{$month}-1 0:0:0", 'enddt' => $endDate->format('Y-m-d H:i:s'));
}
} else {
if ($dataSourceName === 'summary1') {
$sum = array();
foreach ($result as $record) {
if (!isset($sum[$record['item']])) {
$sum = array_merge($sum, array($record['item'] => $record['total']));
} else {
$sum[$record['item']] += $record['total'];
}
}
arsort($sum);
$result = array();
$counter = 10;
foreach ($sum as $product => $totalprice) {
$result[] = array('itemname' => $product, 'totalprice' => $totalprice);
$counter--;
if ($counter <= 0) {
break;
}
}
} else {
if ($dataSourceName === 'summary2') {
$sum = array();
foreach ($result as $record) {
if (!isset($sum[$record['customer']])) {
$sum = array_merge($sum, array($record['customer'] => $record['total']));
} else {
$sum[$record['customer']] += $record['total'];
}
}
arsort($sum);
$result = array();
$counter = 10;
foreach ($sum as $customer => $totalprice) {
$result[] = array('customername' => $customer, 'totalprice' => $totalprice);
$counter--;
if ($counter <= 0) {
break;
}
}
}
}
}
return $result;
}
