/** * 加载数据库 */ 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; }