public function view_replyMessageFormAliSite()
{
$msgids = isset($_GET['msgids']) ? trim($_GET['msgids']) : '';
if ($msgids === '') {
//没指定id
$msgdata = array('data' => array('请指定要回复的message'), 'link' => 'index.php?mod=messagefilter&act=getAliSiteList');
goErrMsgPage($msgdata);
exit;
}
/*----- 获得message信息 -----*/
$idar = explode(',', $msgids);
//数组
$idar = array_map('intval', $idar);
//转换成
$msg_obj = new messageModel();
$msg_list = $msg_obj->getMessageInfoAliSite($idar);
foreach ($msg_list as &$value) {
$value['createtime'] = trunToLosangeles('Y-m-d H:i:s', $value['createtimestamp']);
//echo $value['relationId'];
$value['commnuni'] = $msg_obj->getRlatedSiteMessage($value['relationId']);
$value['orderids'] = array();
$temparr = array();
$bigestid = 0;
$idregion = array();
foreach ($value['commnuni'] as &$cval) {
$cval['createtimestamp'] = trunToLosangeles('Y:m:d H:i:s', $cval['createtimestamp']);
if (1 == $cval['role'] && !empty($cval['orderUrl']) && !empty($cval['orderId'])) {
if (!in_array($cval['orderId'], $temparr)) {
$value['orderids'][] = array('account' => $cval['receiverid'], 'orderid' => $cval['orderId']);
$temparr[] = $cval['orderId'];
}
}
if ($bigestid < $cval['message_id']) {
$bigestid = $cval['message_id'];
}
if ($cval['role'] == 1) {
$idar[] = $cval['id'];
if ($cval['hasread'] == 0) {
$idregion[] = $cval['message_id'];
}
}
$cval['content'] = str_replace("\n", '</br>', $cval['content']);
}
// print_r($idregion);
sort($idregion);
if (count($idregion) > 0) {
$refirst = $idregion[0];
$reend = $idregion[count($idregion) - 1];
$msg_obj->markAsReadByMsgId_site($idregion);
//标记为已读状态
$msg_obj->markUser_site($idregion, $_SESSION['globaluserid']);
//标记回复人id
} else {
$refirst = 0;
$reend = 0;
}
$value['idregion_h'] = $refirst;
$value['idregion_e'] = $reend;
$value['bigestid'] = $bigestid;
}
//print_r($msg_list);exit;
/*----- 获得message信息 -----*/
/*----- 获得模板信息 -----*/
$tpl_obj = new MessageTemplateModel();
$tpl_list = $tpl_obj->getTplList($_SESSION['globaluserid'], array('id', 'name', 'iscommon', 'incommonuse', 'content'), 2);
$this->smarty->assign('tpllist', $tpl_list);
/*----- 获得模板信息 -----*/
/*----- 获得文件夹分类列表 -----*/
$categorylist = new messagecategoryModel();
$cat_list = $categorylist->getAllCategoryInfoList(' and is_delete=0 ', 2);
$this->smarty->assign('catlist', $cat_list);
/*----- 获得文件夹分类列表 -----*/
// print_r($msg_list);exit;
$this->smarty->assign('msglist', $msg_list);
$this->smarty->assign('sec_menue', 4);
$this->smarty->assign('toplevel', 0);
$this->smarty->assign('toptitle', 'message回复');
$this->smarty->display('msgreplyalisite.htm');
}
public function view_messageStatisticsAli()
{
$starttime = isset($_GET['starttime']) ? trim($_GET['starttime']) : '';
$endtime = isset($_GET['endtime']) ? trim($_GET['endtime']) : '';
$type = isset($_GET['type']) ? trim($_GET['type']) : 'order';
$wheresql = '';
date_default_timezone_set('America/Los_Angeles');
//转换成洛杉矶时间
$start_stamp = strtotime($starttime);
$end_stamp = strtotime($endtime) + 84600;
date_default_timezone_set('Asia/Shanghai');
if (!empty($starttime)) {
$wheresql .= ' and createtimestamp > ' . $start_stamp;
}
if (!empty($endtime)) {
$wheresql .= ' and createtimestamp < ' . $end_stamp;
}
$localuser = new GetLoacalUserModel();
$mysql_obj = new MysqlModel();
$cat_obj = new messagecategoryModel();
$list = $cat_obj->getAllCategoryInfoList('', 2);
// print_r($list);
$userGroup = array();
foreach ($list as $lival) {
$cat_name = trim($lival['category_name']);
$nameBreak = explode("--", $cat_name);
$userName = array_pop($nameBreak);
if (array_key_exists($userName, $userGroup)) {
$userGroup[$userName][] = $lival['id'];
} else {
$userGroup[$userName] = array($lival['id']);
}
}
$userName2loginName = array('韩庆新' => '*****@*****.**', '王丽娟' => '*****@*****.**', '王玲' => '*****@*****.**', '王铭' => '*****@*****.**', '喻情' => '*****@*****.**', '黄海娣' => '*****@*****.**', '袁岸' => '*****@*****.**', '潘小红' => '*****@*****.**', '陈小燕' => '*****@*****.**', '肖奇生' => '*****@*****.**', '戴霞' => '*****@*****.**', '温健玲' => '*****@*****.**', '肖庚莲' => '*****@*****.**');
$name2id = $localuser->getUserId($userName2loginName);
//中文名称到系统用户id的映射关系
// print_r($name2id);
if ($type == 'order') {
//处理订单留言
$sql = "select fieldId , hasread,count(*) as num from msg_aliordermessage where role=1 and hasread in (0,1)\n {$wheresql} group by fieldId, hasread\n ";
// echo $sql;exit;
$resultList = $mysql_obj->getQueryResult($sql);
$statistics = array();
//统计数据
foreach ($userGroup as $username => $ids) {
if (!array_key_exists($username, $statistics)) {
$statistics[$username] = array(0 => 0, 1 => 0);
}
foreach ($resultList as $row) {
if (in_array($row['fieldId'], $ids)) {
if ($row['hasread'] == 0) {
//累加未回复留言
$statistics[$username][0] += $row['num'];
} elseif ($row['hasread'] == 1) {
//累加已读留言
$statistics[$username][1] += $row['num'];
}
}
}
}
foreach ($statistics as $key => $item) {
$total = array_sum($item);
$statistics[$key]['total'] = $total;
}
// print_r($statistics);
$replyedStatistics = array();
//已回复留言统计
$userIdSql = implode(', ', $name2id);
$sqlre = "select replyer, count(*) as num from msg_aliordermessage where role=1 and replyer in ({$userIdSql}) \n and hasread=2 {$wheresql} group by replyer";
// echo $sqlre;exit;
$replyResult = $mysql_obj->getQueryResult($sqlre);
$replyList = array();
foreach ($replyResult as $reRow) {
$replyList[$reRow['replyer']] = $reRow['num'];
}
$totalNohandle = 0;
//未处理的留言总数
$totalRead = 0;
//已读留言总数
$totalReply = 0;
//已回复留言总数
foreach ($statistics as $r) {
$totalNohandle += $r[0];
$totalRead += $r[1];
$totalReply += $r[2];
}
global $dbConn;
$accountGroup = $this->getAliAccountGroup();
$gropAmount = array();
foreach ($accountGroup as $key => $group) {
$sql_str = implode("', '", $group);
$sql = "select count(1) as num from msg_aliordermessage where receiverid in ('{$sql_str}') {$wheresql}";
$row = $dbConn->fetch_first($sql);
$gropAmount[$key] = $row['num'];
}
$filpNameId = array_flip($name2id);
foreach ($statistics as $user => $rows) {
$userId = isset($name2id[$user]) ? $name2id[$user] : -1;
if (isset($replyList[$userId])) {
$statistics[$user][2] = $replyList[$userId];
} else {
$statistics[$user][2] = 0;
}
}
$thirdmenue = 1;
} else {
//处理站内信
$sql = "select fieldId , hasread, count(*) as num from msg_alisitemessage where role=1 and hasread in (0,1)\n {$wheresql} group by fieldId, hasread\n ";
$resultList = $mysql_obj->getQueryResult($sql);
$statistics = array();
// 统计数据
foreach ($userGroup as $username => $ids) {
if (!array_key_exists($username, $statistics)) {
$statistics[$username] = array(0 => 0, 1 => 0);
}
foreach ($resultList as $row) {
if (in_array($row['fieldId'], $ids)) {
if ($row['hasread'] == 0) {
// 累加未回复留言
$statistics[$username][0] += $row['num'];
} elseif ($row['hasread'] == 1) {
// 累加已读留言
$statistics[$username][1] += $row['num'];
}
}
}
}
foreach ($statistics as $key => $item) {
$total = array_sum($item);
$statistics[$key]['total'] = $total;
}
// print_r($statistics);
$replyedStatistics = array();
// 已回复留言统计
$userIdSql = implode(', ', $name2id);
$sqlre = "select replyer, count(*) as num from msg_alisitemessage where role=1 and replyer in ({$userIdSql}) \n and hasread=2 {$wheresql} group by replyer";
// echo $sqlre;exit;
$replyResult = $mysql_obj->getQueryResult($sqlre);
$replyList = array();
foreach ($replyResult as $reRow) {
$replyList[$reRow['replyer']] = $reRow['num'];
}
$totalNohandle = 0;
// 未处理的留言总数
$totalRead = 0;
// 已读留言总数
$totalReply = 0;
// 已回复留言总数
foreach ($statistics as $r) {
$totalNohandle += $r[0];
$totalRead += $r[1];
$totalReply += $r[2];
}
global $dbConn;
$accountGroup = $this->getAliAccountGroup();
$gropAmount = array();
foreach ($accountGroup as $key => $group) {
$sql_str = implode("', '", $group);
$sql = "select count(1) as num from msg_alisitemessage where receiverid in ('{$sql_str}') {$wheresql}";
$row = $dbConn->fetch_first($sql);
$gropAmount[$key] = $row['num'];
}
// print_r($gropAmount);exit;
$filpNameId = array_flip($name2id);
// print_r($filpNameId);
foreach ($statistics as $user => $rows) {
$userId = isset($name2id[$user]) ? $name2id[$user] : -1;
if (isset($replyList[$userId])) {
$statistics[$user][2] = $replyList[$userId];
} else {
$statistics[$user][2] = 0;
}
}
// print_r($statistics);exit;
$thirdmenue = 2;
}
// exit;
// print_r($data);exit;
$this->smarty->assign('third_menue', $thirdmenue);
$this->smarty->assign('starttime', $starttime);
$this->smarty->assign('endtime', $endtime);
$this->smarty->assign('totalNhandle', $totalNohandle);
$this->smarty->assign('totalread', $totalRead);
$this->smarty->assign('totalreply', $totalReply);
$this->smarty->assign('type', $type);
$this->smarty->assign('toplevel', 3);
// $this->smarty->assign('navlist', $navlist);
$this->smarty->assign('statistics', $statistics);
$this->smarty->assign('statistics_2', $gropAmount);
$this->smarty->assign('sec_menue', 2);
$this->smarty->display('msgstatisticsAliorder.htm');
}
public function handleSubmitData($platform)
{
extract($this->generateInfo($platform));
$cids = isset($_POST['catids']) ? $_POST['catids'] : array();
$userid = isset($_POST['userid']) ? $_POST['userid'] : FALSE;
if ($userid === FALSE) {
$msgdata = array('data' => array('没指定用户!'), 'link' => $gobackurl);
goErrMsgPage($msgdata);
exit;
}
$msgcat_obj = new messagecategoryModel();
$catidlist = $msgcat_obj->getAllCategoryInfoList('', $platformid, 'id');
$original = array();
foreach ($catidlist as $value) {
$original[] = $value['id'];
}
$original[] = -1;
//增加额外文件夹 迷途文件夹 -1
$finalids = array_intersect($original, $cids);
//保证提交的分类id都是在正确范围内的
$power = array('field' => $finalids);
$power_ser = serialize($power);
$lp_obj = new LocalPowerModel();
$upresult = $lp_obj->{$updatefunc}($userid, $power_ser);
if ($upresult) {
$msgdata = array('data' => array('成功!'), 'link' => $gobackurl);
goOkMsgPage($msgdata);
exit;
} else {
$msgdata = array('data' => array('失败!'), 'link' => $gobackurl);
goErrMsgPage($msgdata);
exit;
}
}
public function view_ajaxDelCategory()
{
$cid = isset($_GET['cid']) ? $_GET['cid'] : 0;
if (!is_numeric($cid)) {
//传入数据非数字
$msgar = array('code' => 6001, 'msg' => 'id不合法');
echo json_encode($msgar);
exit;
}
if ($cid === 0) {
//没有传入分类id
$msgar = array('code' => 6004, 'msg' => '未指定分类id');
echo json_encode($msgar);
exit;
}
$msgcat_obj = new messagecategoryModel();
$result = $msgcat_obj->delCategoryById($cid);
if ($result) {
//删除成功
$msgar = array('code' => 6002, 'msg' => '删除成功!');
echo json_encode($msgar);
exit;
} else {
$msgar = array('code' => 6003, 'msg' => '删除失败!');
echo json_encode($msgar);
exit;
}
}
public function view_ajaxChangeMessagesCategory_alisite()
{
$ids = isset($_GET['msgids']) ? trim($_GET['msgids']) : '';
if (empty($ids)) {
//没指定messageid
$msgdata = array('errCode' => 10001, 'errMsg' => '请指定id');
echo json_encode($msgdata);
exit;
}
$idar = clearData($ids);
if (empty($idar)) {
$msgdata = array('errCode' => 10002, 'errMsg' => '请指定id');
echo json_encode($msgdata);
exit;
}
$catid = isset($_GET['cid']) ? trim($_GET['cid']) : 0;
if ($catid == 0) {
$msgdata = array('errCode' => 10004, 'errMsg' => '请指定分类id');
echo json_encode($msgdata);
exit;
}
if (!is_numeric($catid)) {
$msgdata = array('errCode' => 10003, 'errMsg' => '分类id不正确');
echo json_encode($msgdata);
exit;
}
$msgcat_obj = new messagecategoryModel();
$catinfo = $msgcat_obj->getCategoryInfoById($catid, ' and platform=2');
if (empty($catinfo)) {
$msgdata = array('errCode' => 10007, 'errMsg' => '分类id不正确');
echo json_encode($msgdata);
exit;
}
$msg_obj = new messageModel();
$result = $msg_obj->moveMessagesToSpecifiedCategory_alisite($idar, $catid);
if ($result) {
$msgdata = array('errCode' => 10006, 'errMsg' => '执行成功!');
echo json_encode($msgdata);
exit;
} else {
$msgdata = array('errCode' => 10005, 'errMsg' => '执行失败!');
echo json_encode($msgdata);
exit;
}
}