public function view_neutralExport() { $start = isset($_GET['start']) ? post_check($_GET['start']) : ''; $end = isset($_GET['end']) ? post_check($_GET['end']) : ''; $type = isset($_GET['type']) ? post_check($_GET['type']) : ''; $start = strtotime($start); $end = strtotime($end); //$start = 1356972800; //$end = 1399972800; $where = " where is_delete = 0"; if ($start != '') { $where .= " and feedbacktime >= '{$start}' "; } if ($end != '') { $where .= " and feedbacktime <= '{$end}' "; } if ($type == 'neutral') { $where .= " and (CommentType='Neutral' or status='21' or status='23')"; } else { if ($type == 'negative') { $where .= " and (CommentType='Negative' or status='31' or status='32')"; } } $condition = $where; $FBAct = new EbayFeedbackAct(); $where .= " order by account,id "; $field = " distinct(sku) "; $fbkList = $FBAct->act_getOrderList($field, $where); $menuList = $FBAct->act_getEbayReasonCategoryInfo('*', 'order by id'); $titlelist = array(); $reasonlist = array(); foreach ($menuList as $gtitle) { $titlelist[] = $gtitle['content']; } $reasonlist = $titlelist; $countReason = count($reasonlist); array_unshift($titlelist, '料号', '单价', '采购员'); $fileName = ucfirst($type); $exporter = new ExportDataExcel("browser", $fileName . '_' . date('Y-m-d') . ".xls"); $exporter->initialize(); $exporter->addRow($titlelist); $comAct = new CommonAct(); foreach ($fbkList as $v) { $sku = $v['sku']; if (!empty($sku)) { $countlist = array(); for ($kk = 0; $kk < $countReason; $kk++) { $reasonId = $reasonlist[$kk]['id']; $condition .= " and reasonId = '{$reasonId}' and sku = '{$sku}'"; $count = $FBAct->act_getOrderList('count(*)', $condition); $countlist[] = $count[0]['count(*)']; } $goodsInfo = $comAct->act_getGoodsInfo('goodsCost,purchaseId', " where sku = '{$sku}'"); $price = $goodsInfo[0]['goodsCost']; $purchaseId = $goodsInfo[0]['purchaseId']; $purchaserInfo = $comAct->act_getPurchaserInfo('global_user_name', " where global_user_id = '{$purchaseId}'"); $purchaser = $purchaserInfo[0]['global_user_name']; array_unshift($countlist, $sku, $price, $purchaser); $exporter->addRow($countlist); } } $exporter->finalize(); exit; }