public function view_serviceExport()
{
$start = isset($_GET['start']) ? post_check($_GET['start']) : '';
$end = isset($_GET['end']) ? post_check($_GET['end']) : '';
$account = isset($_GET['account']) ? post_check($_GET['account']) : '';
$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 ($account != '') {
$where .= " and account = '{$account}'";
}
$where .= " and (CommentType='Negative' or CommentType='Neutral' or status='21' or status='23' or status='31' or status='32')";
$FBAct = new EbayFeedbackAct();
$reasonList = $FBAct->act_getEbayReasonCategoryInfo('*', '');
$reasonArr = array();
foreach ($reasonList as $v) {
$reasonArr[$v['id']] = $v['content'];
}
$where .= " order by account,id ";
$field = " account,CommentingUser,sku,CommentType,feedbacktime,reasonId,`status`,orderPayTime ";
$fbkList = $FBAct->act_getOrderList($field, $where);
$exporter = new ExportDataExcel("browser", "service_" . date('Y-m-d') . ".xls");
$exporter->initialize();
$exporter->addRow(array('帐号', 'Buyer ID', 'SKU', '评价类型', '评价原因', '评价日期', '付款日期'));
foreach ($fbkList as $k => $v) {
$account = $v['account'];
$CommentingUser = $v['CommentingUser'];
$sku = $v['sku'];
$comment_type = $v['CommentType'];
$resonId = trim($v['reasonId']);
$feedback_note = $reasonArr[$resonId];
$time = date('Y-m-d', $v['feedbacktime']);
$orderPayTime = trim($v['orderPayTime']);
if (!empty($orderPayTime)) {
$orderPayTime = date('Y-m-d', $orderPayTime);
} else {
$orderPayTime = "";
}
if ($comment_type == "Neutral") {
$type = "中评";
} else {
$type = "差评";
}
if ($status == '21' || $status == '23') {
$type = "中评";
} else {
if ($status == '31' || $status == '32') {
$type = "差评";
}
}
if ($comment_type == 'Positive') {
$type = '好评';
}
$data = array($account, $CommentingUser, $sku, $type, $feedback_note, $time, $orderPayTime);
$exporter->addRow($data);
}
$exporter->finalize();
exit;
}
public function view_ebayFeedbackManage()
{
$userId = isset($_GET['userId']) ? post_check($_GET['userId']) : '';
$sku = isset($_GET['sku']) ? post_check($_GET['sku']) : '';
$latest_type = isset($_GET['latest_type']) ? post_check($_GET['latest_type']) : '';
$original_type = isset($_GET['original_type']) ? post_check($_GET['original_type']) : '';
$account = isset($_GET['account']) ? post_check($_GET['account']) : '';
$sort_type = isset($_GET['sort_type']) ? post_check($_GET['sort_type']) : '1';
$start_time = isset($_GET['start_time']) ? post_check($_GET['start_time']) : '';
$end_time = isset($_GET['end_time']) ? post_check($_GET['end_time']) : '';
$feedbackReasonId = isset($_GET['feedbackReasonId']) ? post_check($_GET['feedbackReasonId']) : '';
$this->smarty->assign('userId', $userId);
$this->smarty->assign('sku', $sku);
$this->smarty->assign('latest_type', $latest_type);
$this->smarty->assign('original_type', $original_type);
$this->smarty->assign('account', $account);
$this->smarty->assign('sort_type', $sort_type);
$this->smarty->assign('start_time', $start_time);
$this->smarty->assign('end_time', $end_time);
$this->smarty->assign('feedbackReasonId', $feedbackReasonId);
$where = 'where is_delete = 0';
if ($start_time != '') {
$where .= " and feedbacktime >= '" . strtotime($start_time . '00:00:00') . "'";
}
if ($end_time != '') {
$where .= " and feedbacktime <= '" . strtotime($end_time . '23:59:59') . "'";
}
if ($account != '') {
$where .= " and account = '{$account}'";
}
if ($sku != '') {
$where .= " and sku = '{$sku}'";
}
if ($userId != '') {
$where .= " and CommentingUser = '******'";
}
if ($feedbackReasonId != '') {
$where .= " and reasonId = '{$feedbackReasonId}'";
}
if ($original_type != '') {
if ($original_type == "Neutral") {
if ($latest_type != '') {
if ($latest_type == "Positive") {
$where .= " and status='21'";
} else {
if ($latest_type == "Negative") {
$where .= " and status='23'";
} else {
if ($latest_type == "Neutral") {
$where .= " and CommentType='Neutral' and status!='32'";
}
}
}
} else {
$where .= " and (CommentType='Neutral' and status !='32' or status='21')";
}
} else {
if ($original_type == "Negative") {
if ($latest_type != '') {
if ($latest_type == "Positive") {
$where .= " and status='31'";
} else {
if ($latest_type == "Neutral") {
$where .= " and status='32'";
} else {
if ($latest_type == "Negative") {
$where .= " and CommentType='Negative'";
}
}
}
} else {
$where .= " and (CommentType='Negative' or status='31' or status='32')";
}
}
}
}
$FBAct = new EbayFeedbackAct();
$total = $FBAct->act_getOrderNum($where);
$num = 50;
//每页显示的个数
$page = new Page($total, $num, '', 'CN');
if ($sort_type != '1') {
$where .= " order by feedbacktime asc " . $page->limit;
} else {
$where .= " order by feedbacktime desc " . $page->limit;
}
//echo $where;
$fbkList = $FBAct->act_getOrderList('*', $where);
//var_dump($fbkList[0]);
if (!empty($_GET['page'])) {
if (intval($_GET['page']) <= 1 || intval($_GET['page']) > ceil($total / $num)) {
$n = 1;
} else {
$n = (intval($_GET['page']) - 1) * $num + 1;
}
} else {
$n = 1;
}
if ($total > $num) {
//输出分页显示
$show_page = $page->fpage(array(0, 2, 3, 4, 5, 6, 7, 8, 9));
} else {
$show_page = $page->fpage(array(0, 2, 3));
}
$this->smarty->assign('show_page', $show_page);
$this->smarty->assign('fbkList', $fbkList);
$accAct = new AccountAct();
$accountList = $accAct->act_getAccountList('id,account', 'where platformId = 1 and is_delete = 0');
$this->smarty->assign('accountList', $accountList);
$reasonList = $FBAct->act_getEbayReasonCategoryInfo('*', '');
$this->smarty->assign('reasonList', $reasonList);
$this->smarty->assign('state', $state);
$this->smarty->assign('secnev', '1');
//二级导航
$this->smarty->assign('module', 'SKU等待领取');
$this->smarty->assign('username', $_SESSION['userName']);
$this->smarty->display('ebayFeedbackManage.htm');
}
