public function amount_report()
{
$start = IFilter::act(IReq::get('start'));
$end = IFilter::act(IReq::get('end'));
//获取时间段
$_date = statistics::dateParse($start, $end);
$startArray = explode('-', $_date[0]);
$endArray = explode('-', $_date[1]);
$startCondition = $startArray[0] . '-' . $startArray[1] . '-' . $startArray[2];
$endCondition = $endArray[0] . '-' . $endArray[1] . '-' . ($endArray[2] + 1);
$strTable = '<table width="500" border="1">';
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;width:120px;">日期</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">订单量</td>';
$strTable .= '<td style="text-align:center;font-size:12px;" width="*">销售额</td>';
$strTable .= '</tr>';
$db = new IQuery('collection_doc');
$db->fields = 'sum(amount) as count,count(order_id) as ordernum, `time`';
$db->where = 'pay_status = 1';
$db->group = "DATE_FORMAT(`time`,'Y-%m-%d') having `time` >= '{$startCondition}' and `time` < '{$endCondition}'";
$spandingList = $db->find();
foreach ($spandingList as $k => $val) {
$strTable .= '<tr>';
$strTable .= '<td style="text-align:center;font-size:12px;">' . $val['time'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['ordernum'] . ' </td>';
$strTable .= '<td style="text-align:left;font-size:12px;">' . $val['count'] . ' </td>';
$strTable .= '</tr>';
}
$strTable .= '</table>';
$reportObj = new report();
$reportObj->setFileName('amount');
$reportObj->toDownload($strTable);
exit;
}
