代码拉取完成，页面将自动刷新
同步操作将从 baobeihuaidan/ecshop大商创商城 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
<?php
//源码由旺旺:ecshop2012所有 未经允许禁止倒卖 一经发现停止任何服务
function get_ajax_user_order_comment_list($user_id, $type = 0, $sign = 0, $rec_id)
{
$where = ' AND og.rec_id = ' . $rec_id . ' ';
if ($sign == 0) {
$where .= ' AND (SELECT count(*) FROM ' . $GLOBALS['ecs']->table('comment') . ' AS c WHERE c.comment_type = 0 AND c.id_value = g.goods_id AND c.rec_id = og.rec_id AND c.parent_id = 0 AND c.user_id = \'' . $user_id . '\') = 0 ';
}
else if ($sign == 1) {
$where .= ' AND (SELECT count(*) FROM ' . $GLOBALS['ecs']->table('comment') . ' AS c WHERE c.comment_type = 0 AND c.id_value = g.goods_id AND c.rec_id = og.rec_id AND c.parent_id = 0 AND c.user_id = \'' . $user_id . '\') > 0 ';
$where .= ' AND (SELECT count(*) FROM ' . $GLOBALS['ecs']->table('comment_img') . ' AS ci, ' . $GLOBALS['ecs']->table('comment') . ' AS c' . ' WHERE c.comment_type = 0 AND c.id_value = g.goods_id AND ci.rec_id = og.rec_id AND c.parent_id = 0 AND c.user_id = \'' . $user_id . '\' AND ci.comment_id = c.comment_id ) = 0 ';
}
else if ($sign == 2) {
$where .= ' AND (SELECT count(*) FROM ' . $GLOBALS['ecs']->table('comment') . ' AS c WHERE c.comment_type = 0 AND c.id_value = g.goods_id AND c.rec_id = og.rec_id AND c.parent_id = 0 AND c.user_id = \'' . $user_id . '\') > 0 ';
$where .= ' AND (SELECT count(*) FROM ' . $GLOBALS['ecs']->table('comment_img') . ' AS ci, ' . $GLOBALS['ecs']->table('comment') . ' AS c' . ' WHERE c.comment_type = 0 AND c.id_value = g.goods_id AND ci.rec_id = og.rec_id AND c.parent_id = 0 AND c.user_id = \'' . $user_id . '\' AND ci.comment_id = c.comment_id ) > 0 ';
}
$sql = 'SELECT og.rec_id, og.order_id, og.goods_id, og.goods_name, oi.add_time, g.goods_thumb, g.goods_product_tag, og.ru_id,oi.order_sn,og.goods_number,og.goods_price FROM ' . $GLOBALS['ecs']->table('order_goods') . ' AS og ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('order_info') . ' AS oi ON og.order_id = oi.order_id ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('goods') . ' AS g ON og.goods_id = g.goods_id ' . 'WHERE og.goods_id = g.goods_id AND oi.user_id = \'' . $user_id . '\' ' . $where;
$row = $GLOBALS['db']->getRow($sql);
if ($row) {
$row['add_time'] = local_date($GLOBALS['_CFG']['time_format'], $row['add_time']);
$row['goods_thumb'] = get_image_path($goods_id, $row['goods_thumb'], true);
$row['impression_list'] = !empty($row['goods_product_tag']) ? explode(',', $row['goods_product_tag']) : array();
$row['goods_url'] = build_uri('goods', array('gid' => $row['goods_id']), $row['goods_name']);
$row['goods_price'] = price_format($row['goods_price']);
$row['comment'] = get_order_goods_comment($row['goods_id'], $row['rec_id'], $user_id);
}
return $row;
}
define('IN_ECS', true);
require dirname(__FILE__) . '/includes/init.php';
require ROOT_PATH . 'includes/cls_json.php';
include_once ROOT_PATH . 'includes/lib_clips.php';
require ROOT_PATH . 'languages/' . $GLOBALS['_CFG']['lang'] . '/user.php';
$smarty->assign('lang', $_LANG);
$user_id = (isset($_SESSION['user_id']) && !empty($_SESSION['user_id']) ? $_SESSION['user_id'] : 0);
$json = new JSON();
$result = array('error' => 0, 'message' => '', 'content' => '');
$is_jsonp = (isset($_REQUEST['is_jsonp']) && !empty($_REQUEST['is_jsonp']) ? intval($_REQUEST['is_jsonp']) : 0);
if ($_REQUEST['act'] == 'comments_form') {
$sql = 'SELECT id, comment_img, img_thumb FROM ' . $ecs->table('comment_img') . ' WHERE user_id = \'' . $user_id . '\' AND comment_id = 0';
$img_list = $db->getAll($sql);
if ((intval($_CFG['captcha']) & CAPTCHA_COMMENT) && (0 < gd_version())) {
$smarty->assign('enabled_captcha', 1);
$smarty->assign('rand', mt_rand());
}
foreach ($img_list as $key => $val) {
get_oss_del_file(array($val['comment_img'], $val['img_thumb']));
@unlink(ROOT_PATH . $val['comment_img']);
@unlink(ROOT_PATH . $val['img_thumb']);
}
$sql = 'DELETE FROM ' . $ecs->table('comment_img') . ' WHERE user_id = \'' . $user_id . '\' AND comment_id = 0';
$db->query($sql);
$rec_id = (isset($_REQUEST['rec_id']) && !empty($_REQUEST['rec_id']) ? intval($_REQUEST['rec_id']) : 0);
$sign = (isset($_REQUEST['sign']) && !empty($_REQUEST['sign']) ? intval($_REQUEST['sign']) : 0);
$comment = get_ajax_user_order_comment_list($user_id, 0, $sign, $rec_id);
$smarty->assign('item', $comment);
$smarty->assign('user_id', $user_id);
$smarty->assign('sessid', SESS_ID);
$smarty->assign('sign', $sign);
$result['content'] = $smarty->fetch('library/comments_form.lbi');
}
else if ($_REQUEST['act'] == 'upload_user_picture') {
$filename = (!empty($_REQUEST['image']) ? $_REQUEST['image'] : '');
$filename_arr = array();
if ($filename && isset($_SESSION['user_id']) && (0 < $_SESSION['user_id'])) {
include_once ROOT_PATH . '/includes/cls_image.php';
$image = new cls_image($_CFG['bgcolor']);
$filename_cropper = 'data/images_user/cropper/' . $_SESSION['user_id'] . '_cropper.jpg';
$route = 'data/images_user/';
$filename_arr = explode(',', $filename);
if (!empty($filename_arr)) {
if (!is_dir('data/images_user/cropper/')) {
mkdir('data/images_user/cropper/', 511, true);
}
$somecontent1 = base64_decode($filename_arr[1]);
if ($handle = fopen($filename_cropper, 'w+')) {
if (!fwrite($handle, $somecontent1) == false) {
fclose($handle);
}
}
$filename_120 = $image->make_thumb($filename_cropper, 120, 120, $route, '', $_SESSION['user_id'] . '_120.jpg');
$filename_48 = $image->make_thumb($filename_cropper, 48, 48, $route, '', $_SESSION['user_id'] . '_48.jpg');
$filename_24 = $image->make_thumb($filename_cropper, 24, 24, $route, '', $_SESSION['user_id'] . '_24.jpg');
get_oss_add_file(array($filename_120, $filename_48, $filename_24));
$parent['user_picture'] = $filename_120;
$GLOBALS['db']->autoExecute($GLOBALS['ecs']->table('users'), $parent, 'UPDATE', 'user_id = \'' . $_SESSION['user_id'] . '\'');
$result['file'] = $filename_120;
$result['result'] = '上传成功';
$result['error'] = 'ok';
}
else {
$result['result'] = '未知错误，请重试';
}
}
else {
$result['result'] = $_LANG['overdue_login'];
}
}
else if ($_REQUEST['act'] == 'checked_report_title') {
$type_id = (!empty($_REQUEST['type_id']) ? intval($_REQUEST['type_id']) : 0);
$report_title = get_goods_report_title($type_id);
$result = '<li><a href="javascript:void(0);" data-value="">' . $_LANG['Please_select'] . '</a></li>';
if ($report_title) {
foreach ($report_title as $k => $v) {
$result .= '<li><a href="javascript:void(0);" data-value="' . $v['title_id'] . '">' . $v['title_name'] . '</a></li>';
}
}
}
else if ($_REQUEST['act'] == 'ajax_report_img') {
$goods_id = (!empty($_REQUEST['goods_id']) ? intval($_REQUEST['goods_id']) : 0);
$sessid = (isset($_GET['sessid']) ? trim($_GET['sessid']) : '');
$img_file = (isset($_FILES['file']) ? $_FILES['file'] : array());
$sql = 'SELECT count(*) FROM ' . $ecs->table('sessions') . ' WHERE userid = \'' . $user_id . '\' AND sesskey=\'' . $sessid . '\'';
if ((0 < $user_id) && (0 < $db->getOne($sql))) {
include_once ROOT_PATH . '/includes/cls_image.php';
$image = new cls_image($_CFG['bgcolor']);
$img_file = $image->upload_image($img_file, 'report_img/' . date('Ym'));
if ($img_file === false) {
$result['error'] = 1;
$result['message'] = $image->error_msg();
exit($json->encode($result));
}
get_oss_add_file(array($img_file));
$report = array('goods_id' => $goods_id, 'user_id' => $user_id, 'img_file' => $img_file);
$sql = 'SELECT count(*) FROM ' . $ecs->table('goods_report_img') . ' WHERE user_id = \'' . $user_id . '\' AND goods_id = \'' . $goods_id . '\'';
$img_count = $db->getOne($sql);
if (($img_count < 5) && $img_file) {
$db->autoExecute($ecs->table('goods_report_img'), $report, 'INSERT');
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['report_img_number'];
exit($json->encode($result));
}
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['overdue_login'];
}
$sql = 'SELECT img_id as id , goods_id, report_id,user_id,img_file as comment_img FROM ' . $ecs->table('goods_report_img') . ' WHERE user_id = \'' . $user_id . '\' AND goods_id = \'' . $goods_id . '\' AND report_id = 0 ORDER BY id DESC';
$img_list = $db->getAll($sql);
$smarty->assign('img_list', $img_list);
$smarty->assign('report', 1);
$result['content'] = $smarty->fetch('library/comment_image.lbi');
}
else if ($_REQUEST['act'] == 'del_reportpic') {
$img_id = (isset($_REQUEST['re_imgId']) ? intval($_REQUEST['re_imgId']) : 0);
$goods_id = (isset($_REQUEST['goods_id']) ? intval($_REQUEST['goods_id']) : 0);
$order_id = (isset($_REQUEST['order_id']) ? intval($_REQUEST['order_id']) : 0);
$complaint = (isset($_REQUEST['complaint']) ? intval($_REQUEST['complaint']) : 0);
$report = 0;
if ((0 < $user_id) || (0 < $img_id)) {
$img_list = array();
if (0 < $complaint) {
$report = 2;
$ty_table = 'complaint_img';
$sql = 'SELECT img_id as id , order_id, complaint_id,user_id,img_file as comment_img FROM ' . $ecs->table('complaint_img') . ' WHERE user_id = \'' . $user_id . '\' AND order_id = \'' . $order_id . '\' ORDER BY id DESC';
$img_list = $db->getAll($sql);
}
else {
$report = 1;
$ty_table = 'goods_report_img';
$sql = 'SELECT img_id as id , goods_id, report_id,user_id,img_file as comment_img FROM ' . $ecs->table('goods_report_img') . ' WHERE user_id = \'' . $user_id . '\' AND goods_id = \'' . $goods_id . '\'';
$img_list = $db->getAll($sql);
}
if (!empty($img_list)) {
foreach ($img_list as $key => $val) {
if ($img_id == $val['id']) {
$sql = 'DELETE FROM ' . $ecs->table($ty_table) . ' WHERE img_id = \'' . $img_id . '\'';
$db->query($sql);
unset($img_list[$key]);
get_oss_del_file(array($val['comment_img']));
@unlink(ROOT_PATH . $val['comment_img']);
}
}
}
$smarty->assign('img_list', $img_list);
$smarty->assign('report', $report);
$result['content'] = $smarty->fetch('library/comment_image.lbi');
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['overdue_login'];
}
}
else if ($_REQUEST['act'] == 'check_report_state') {
$report_id = (!empty($_REQUEST['report_id']) ? intval($_REQUEST['report_id']) : 0);
$state = (!empty($_REQUEST['state']) ? intval($_REQUEST['state']) : 0);
if (0 < $user_id) {
$sql = 'UPDATE' . $ecs->table('goods_report') . 'SET report_state = \'' . $state . '\' WHERE report_id = \'' . $report_id . '\'';
$db->query($sql);
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['overdue_login'];
}
}
else if ($_REQUEST['act'] == 'complaint_title_desc') {
$title_id = (!empty($_REQUEST['title_id']) ? intval($_REQUEST['title_id']) : 0);
if (0 < $user_id) {
$sql = 'SELECT title_desc FROM' . $ecs->table('complain_title') . ' WHERE title_id = \'' . $title_id . '\'';
$result['content'] = $db->getOne($sql);
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['overdue_login'];
}
}
else if ($_REQUEST['act'] == 'complaint_img') {
$order_id = (!empty($_REQUEST['order_id']) ? intval($_REQUEST['order_id']) : 0);
$sessid = (isset($_GET['sessid']) ? trim($_GET['sessid']) : '');
$img_file = (isset($_FILES['file']) ? $_FILES['file'] : array());
$sql = 'SELECT count(*) FROM ' . $ecs->table('sessions') . ' WHERE userid = \'' . $user_id . '\' AND sesskey=\'' . $sessid . '\'';
if ((0 < $user_id) && (0 < $db->getOne($sql))) {
include_once ROOT_PATH . '/includes/cls_image.php';
$image = new cls_image($_CFG['bgcolor']);
$img_file = $image->upload_image($img_file, 'complaint_img/' . date('Ym'));
if ($img_file === false) {
$result['error'] = 1;
$result['message'] = $image->error_msg();
exit($json->encode($result));
}
get_oss_add_file(array($img_file));
$report = array('order_id' => $order_id, 'user_id' => $user_id, 'img_file' => $img_file);
$sql = 'SELECT count(*) FROM ' . $ecs->table('complaint_img') . ' WHERE user_id = \'' . $user_id . '\' AND order_id = \'' . $order_id . '\'';
$img_count = $db->getOne($sql);
if (($img_count < 5) && $img_file) {
$db->autoExecute($ecs->table('complaint_img'), $report, 'INSERT');
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['report_img_number'];
exit($json->encode($result));
}
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['overdue_login'];
}
$sql = 'SELECT img_id as id , order_id, complaint_id,user_id,img_file as comment_img FROM ' . $ecs->table('complaint_img') . ' WHERE user_id = \'' . $user_id . '\' AND order_id = \'' . $order_id . '\' AND complaint_id = 0 ORDER BY id DESC';
$img_list = $db->getAll($sql);
$smarty->assign('img_list', $img_list);
$smarty->assign('report', 2);
$result['content'] = $smarty->fetch('library/comment_image.lbi');
}
else if ($_REQUEST['act'] == 'talk_release') {
$talk_id = (!empty($_REQUEST['talk_id']) ? intval($_REQUEST['talk_id']) : 0);
$complaint_id = (!empty($_REQUEST['complaint_id']) ? intval($_REQUEST['complaint_id']) : 0);
$talk_content = (!empty($_REQUEST['talk_content']) ? trim($_REQUEST['talk_content']) : '');
$type = (!empty($_REQUEST['type']) ? intval($_REQUEST['type']) : 0);
if ($type == 0) {
$complaint_talk = array('complaint_id' => $complaint_id, 'talk_member_id' => $user_id, 'talk_member_name' => $_SESSION['user_name'], 'talk_member_type' => 1, 'talk_content' => $talk_content, 'talk_time' => gmtime(), 'view_state' => 'user');
$db->autoExecute($ecs->table('complaint_talk'), $complaint_talk, 'INSERT');
}
$talk_list = checkTalkView($complaint_id, 'user');
$smarty->assign('talk_list', $talk_list);
$result['content'] = $smarty->fetch('library/talk_list.lbi');
exit($json->encode($result));
}
else if ($_REQUEST['act'] == 'del_compalint') {
$complaint_id = (!empty($_REQUEST['compalint_id']) ? intval($_REQUEST['compalint_id']) : 0);
if (0 < $user_id) {
del_complaint_img($complaint_id);
del_complaint_img($complaint_id, 'appeal_img');
del_complaint_talk($complaint_id);
$sql = 'DELETE FROM' . $ecs->table('complaint') . 'WHERE complaint_id = \'' . $complaint_id . '\'';
$db->query($sql);
}
else {
$result['error'] = 1;
$result['message'] = $_LANG['overdue_login'];
}
}
if ($is_jsonp) {
echo $_GET['jsoncallback'] . '(' . $json->encode($result) . ')';
}
else {
echo $json->encode($result);
}
?>
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手