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; }