You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
750 lines
28 KiB
750 lines
28 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 广告管理程序
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: liubo $
|
|
* $Id: ads.php 17217 2011-01-19 06:29:08Z liubo $
|
|
*/
|
|
|
|
define('IN_ECS', true);
|
|
|
|
require(dirname(__FILE__) . '/includes/init.php');
|
|
include_once(ROOT_PATH . 'includes/cls_image.php');
|
|
$image = new cls_image($_CFG['bgcolor']);
|
|
$exc = new exchange($ecs->table("touch_ad"), $db, 'ad_id', 'ad_name');
|
|
|
|
/* act操作项的初始化 */
|
|
if (empty($_REQUEST['act']))
|
|
{
|
|
$_REQUEST['act'] = 'list';
|
|
}
|
|
else
|
|
{
|
|
$_REQUEST['act'] = trim($_REQUEST['act']);
|
|
}
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$adminru = get_admin_ru_id();
|
|
$ruCat = '';
|
|
if($adminru['ru_id'] == 0){
|
|
$smarty->assign('priv_ru', 1);
|
|
}else{
|
|
$smarty->assign('priv_ru', 0);
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 广告列表页面
|
|
/*------------------------------------------------------ */
|
|
if ($_REQUEST['act'] == 'list')
|
|
{
|
|
$smarty->assign('ur_here', $_LANG['ad_list']);
|
|
$smarty->assign('action_link', array('text' => $_LANG['ads_add'], 'href' => 'touch_ads.php?act=add'));
|
|
|
|
$smarty->assign('full_page', 1);
|
|
|
|
$ads_list = get_adslist($adminru['ru_id']);
|
|
|
|
$smarty->assign('ads_list', $ads_list['ads']);
|
|
$smarty->assign('filter', $ads_list['filter']);
|
|
$smarty->assign('record_count', $ads_list['record_count']);
|
|
$smarty->assign('page_count', $ads_list['page_count']);
|
|
$smarty->assign('pid', $ads_list['filter']['pid']);
|
|
|
|
$store_list = get_common_store_list();
|
|
$smarty->assign('store_list', $store_list);
|
|
|
|
$sort_flag = sort_flag($ads_list['filter']);
|
|
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
|
|
|
|
assign_query_info();
|
|
$smarty->display('touch_ads_list.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 排序、分页、查询
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'query')
|
|
{
|
|
$ads_list = get_adslist($adminru['ru_id']);
|
|
|
|
$smarty->assign('ads_list', $ads_list['ads']);
|
|
$smarty->assign('filter', $ads_list['filter']);
|
|
$smarty->assign('record_count', $ads_list['record_count']);
|
|
$smarty->assign('page_count', $ads_list['page_count']);
|
|
|
|
$store_list = get_common_store_list();
|
|
$smarty->assign('store_list', $store_list);
|
|
|
|
$sort_flag = sort_flag($ads_list['filter']);
|
|
$smarty->assign($sort_flag['tag'], $sort_flag['img']);
|
|
|
|
make_json_result($smarty->fetch('ads_list.htm'), '',
|
|
array('filter' => $ads_list['filter'], 'page_count' => $ads_list['page_count']));
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 添加新广告页面
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'add')
|
|
{
|
|
admin_priv('touch_ad');
|
|
|
|
$ad_link = empty($_GET['ad_link']) ? '' : trim($_GET['ad_link']);
|
|
$ad_name = empty($_GET['ad_name']) ? '' : trim($_GET['ad_name']);
|
|
|
|
$start_time = local_date($GLOBALS['_CFG']['time_format']);
|
|
$end_time = local_date($GLOBALS['_CFG']['time_format'], gmtime() + 3600 * 24 * 30); // 默认结束时间为1个月以后
|
|
|
|
$smarty->assign('ads',
|
|
array('ad_link' => $ad_link, 'ad_name' => $ad_name, 'start_time' => $start_time,
|
|
'end_time' => $end_time, 'enabled' => 1));
|
|
|
|
$smarty->assign('ur_here', $_LANG['ads_add']);
|
|
$smarty->assign('action_link', array('href' => 'touch_ads.php?act=list', 'text' => $_LANG['ad_list']));
|
|
$smarty->assign('position_list', get_position_list());
|
|
|
|
$smarty->assign('form_act', 'insert');
|
|
$smarty->assign('action', 'add');
|
|
$smarty->assign('cfg_lang', $_CFG['lang']);
|
|
|
|
assign_query_info();
|
|
$smarty->display('touch_ads_info.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 新广告的处理
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'insert')
|
|
{
|
|
admin_priv('touch_ad');
|
|
|
|
/* 初始化变量 */
|
|
$id = !empty($_POST['id']) ? intval($_POST['id']) : 0;
|
|
$type = !empty($_POST['type']) ? intval($_POST['type']) : 0;
|
|
$ad_name = !empty($_POST['ad_name']) ? trim($_POST['ad_name']) : '';
|
|
$link_color = !empty($_POST['link_color']) ? trim($_POST['link_color']) : '';
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$is_new = !empty($_POST['is_new']) ? intval($_POST['is_new']) : 0;
|
|
$is_hot = !empty($_POST['is_hot']) ? intval($_POST['is_hot']) : 0;
|
|
$is_best = !empty($_POST['is_best']) ? intval($_POST['is_best']) : 0;
|
|
|
|
$ad_type = !empty($_POST['ad_type']) ? intval($_POST['ad_type']) : 0;
|
|
$goods_name = !empty($_POST['goods_name']) ? trim($_POST['goods_name']) : 0;
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
if ($_POST['media_type'] == '0')
|
|
{
|
|
$ad_link = !empty($_POST['ad_link']) ? trim($_POST['ad_link']) : '';
|
|
}
|
|
else
|
|
{
|
|
$ad_link = !empty($_POST['ad_link2']) ? trim($_POST['ad_link2']) : '';
|
|
}
|
|
|
|
/* 获得广告的开始时期与结束日期 */
|
|
$start_time = local_strtotime($_POST['start_time']);
|
|
$end_time = local_strtotime($_POST['end_time']);
|
|
|
|
$template = $GLOBALS['_CFG']['template'];
|
|
|
|
/* 查看广告名称是否有重复 */
|
|
$sql = "SELECT COUNT(*) FROM " .$ecs->table('touch_ad')." AS a, ".
|
|
$ecs->table('touch_ad_position') ." AS p ".
|
|
" WHERE a.ad_name = '$ad_name' AND a.position_id = p.position_id AND p.theme = '$template'";
|
|
if ($db->getOne($sql) > 0)
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['ad_name_exist'], 0, $link);
|
|
}
|
|
|
|
/* 添加图片类型的广告 */
|
|
if ($_POST['media_type'] == '0')
|
|
{
|
|
if ((isset($_FILES['ad_img']['error']) && $_FILES['ad_img']['error'] == 0) || (!isset($_FILES['ad_img']['error']) && isset($_FILES['ad_img']['tmp_name'] ) &&$_FILES['ad_img']['tmp_name'] != 'none'))
|
|
{
|
|
$ad_code = basename($image->upload_image($_FILES['ad_img'], 'afficheimg'));
|
|
}
|
|
if (!empty($_POST['img_url']))
|
|
{
|
|
$ad_code = $_POST['img_url'];
|
|
}
|
|
if (((isset($_FILES['ad_img']['error']) && $_FILES['ad_img']['error'] > 0) || (!isset($_FILES['ad_img']['error']) && isset($_FILES['ad_img']['tmp_name']) && $_FILES['ad_img']['tmp_name'] == 'none')) && empty($_POST['img_url']))
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['js_languages']['ad_photo_empty'], 0, $link);
|
|
}
|
|
}
|
|
|
|
/* 如果添加的广告是Flash广告 */
|
|
elseif ($_POST['media_type'] == '1')
|
|
{
|
|
if ((isset($_FILES['upfile_flash']['error']) && $_FILES['upfile_flash']['error'] == 0) || (!isset($_FILES['upfile_flash']['error']) && isset($_FILES['ad_img']['tmp_name']) && $_FILES['upfile_flash']['tmp_name'] != 'none'))
|
|
{
|
|
/* 检查文件类型 */
|
|
if ($_FILES['upfile_flash']['type'] != "application/x-shockwave-flash")
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['upfile_flash_type'], 0, $link);
|
|
}
|
|
|
|
/* 生成文件名 */
|
|
$urlstr = date('Ymd');
|
|
for ($i = 0; $i < 6; $i++)
|
|
{
|
|
$urlstr .= chr(mt_rand(97, 122));
|
|
}
|
|
|
|
$source_file = $_FILES['upfile_flash']['tmp_name'];
|
|
$target = ROOT_PATH . DATA_DIR . '/afficheimg/';
|
|
$file_name = $urlstr .'.swf';
|
|
|
|
if (!move_upload_file($source_file, $target.$file_name))
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['upfile_error'], 0, $link);
|
|
}
|
|
else
|
|
{
|
|
$ad_code = $file_name;
|
|
}
|
|
}
|
|
elseif (!empty($_POST['flash_url']))
|
|
{
|
|
if (substr(strtolower($_POST['flash_url']), strlen($_POST['flash_url']) - 4) != '.swf')
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['upfile_flash_type'], 0, $link);
|
|
}
|
|
$ad_code = $_POST['flash_url'];
|
|
}
|
|
|
|
if (((isset($_FILES['upfile_flash']['error']) && $_FILES['upfile_flash']['error'] > 0) || (!isset($_FILES['upfile_flash']['error']) && isset($_FILES['upfile_flash']['tmp_name']) && $_FILES['upfile_flash']['tmp_name'] == 'none')) && empty($_POST['flash_url']))
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['js_languages']['ad_flash_empty'], 0, $link);
|
|
}
|
|
}
|
|
/* 如果广告类型为代码广告 */
|
|
elseif ($_POST['media_type'] == '2')
|
|
{
|
|
if (!empty($_POST['ad_code']))
|
|
{
|
|
$ad_code = $_POST['ad_code'];
|
|
}
|
|
else
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['js_languages']['ad_code_empty'], 0, $link);
|
|
}
|
|
}
|
|
|
|
/* 广告类型为文本广告 */
|
|
elseif ($_POST['media_type'] == '3')
|
|
{
|
|
if (!empty($_POST['ad_text']))
|
|
{
|
|
$ad_code = $_POST['ad_text'];
|
|
}
|
|
else
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['js_languages']['ad_text_empty'], 0, $link);
|
|
}
|
|
}
|
|
|
|
$public_ruid = $adminru['ru_id']; //ecmoban模板堂 --zhuo
|
|
/* 插入数据 */
|
|
$sql = "INSERT INTO ".$ecs->table('touch_ad'). " (position_id,media_type,ad_name,is_new,is_hot,is_best,public_ruid,ad_link,ad_code,start_time,end_time,link_man,link_email,link_phone,click_count,enabled, link_color, ad_type, goods_name)
|
|
VALUES ('$_POST[position_id]',
|
|
'$_POST[media_type]',
|
|
'$ad_name',
|
|
'$is_new',
|
|
'$is_hot',
|
|
'$is_best',
|
|
'$public_ruid',
|
|
'$ad_link',
|
|
'$ad_code',
|
|
'$start_time',
|
|
'$end_time',
|
|
'$_POST[link_man]',
|
|
'$_POST[link_email]',
|
|
'$_POST[link_phone]',
|
|
'0',
|
|
'1',
|
|
'$link_color',
|
|
'$ad_type',
|
|
'$goods_name')";
|
|
|
|
$db->query($sql);
|
|
/* 记录管理员操作 */
|
|
admin_log($_POST['ad_name'], 'add', 'ads');
|
|
|
|
clear_cache_files(); // 清除缓存文件
|
|
|
|
/* 提示信息 */
|
|
|
|
$link[0]['text'] = $_LANG['show_ads_template'];
|
|
$link[0]['href'] = 'template.php?act=setup';
|
|
|
|
$link[1]['text'] = $_LANG['back_ads_list'];
|
|
$link[1]['href'] = 'touch_ads.php?act=list';
|
|
|
|
$link[2]['text'] = $_LANG['continue_add_ad'];
|
|
$link[2]['href'] = 'touch_ads.php?act=add';
|
|
sys_msg($_LANG['add'] . " " .$_POST['ad_name'] . " " . $_LANG['attradd_succed'],0, $link);
|
|
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 广告编辑页面
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'edit')
|
|
{
|
|
admin_priv('touch_ad');
|
|
|
|
/* 获取广告数据 */
|
|
$sql = "SELECT * FROM " .$ecs->table('touch_ad'). " WHERE ad_id='".intval($_REQUEST['id'])."'";
|
|
$ads_arr = $db->getRow($sql);
|
|
|
|
$ads_arr['ad_name'] = htmlspecialchars($ads_arr['ad_name']);
|
|
/* 格式化广告的有效日期 */
|
|
$ads_arr['start_time'] = local_date($GLOBALS['_CFG']['time_format'], $ads_arr['start_time']);
|
|
$ads_arr['end_time'] = local_date($GLOBALS['_CFG']['time_format'], $ads_arr['end_time']);
|
|
|
|
if ($ads_arr['media_type'] == '0')
|
|
{
|
|
if (strpos($ads_arr['ad_code'], 'http://') === false && strpos($ads_arr['ad_code'], 'https://') === false)
|
|
{
|
|
$src = '../' . DATA_DIR . '/afficheimg/'. $ads_arr['ad_code'];
|
|
$smarty->assign('img_src', $src);
|
|
}
|
|
else
|
|
{
|
|
$src = $ads_arr['ad_code'];
|
|
$smarty->assign('url_src', $src);
|
|
}
|
|
}
|
|
if ($ads_arr['media_type'] == '1')
|
|
{
|
|
if (strpos($ads_arr['ad_code'], 'http://') === false && strpos($ads_arr['ad_code'], 'https://') === false)
|
|
{
|
|
$src = '../' . DATA_DIR . '/afficheimg/'. $ads_arr['ad_code'];
|
|
$smarty->assign('flash_url', $src);
|
|
}
|
|
else
|
|
{
|
|
$src = $ads_arr['ad_code'];
|
|
$smarty->assign('flash_url', $src);
|
|
}
|
|
$smarty->assign('src', $src);
|
|
}
|
|
if ($ads_arr['media_type'] == 0)
|
|
{
|
|
$smarty->assign('media_type', $_LANG['ad_img']);
|
|
}
|
|
elseif ($ads_arr['media_type'] == 1)
|
|
{
|
|
$smarty->assign('media_type', $_LANG['ad_flash']);
|
|
}
|
|
elseif ($ads_arr['media_type'] == 2)
|
|
{
|
|
$smarty->assign('media_type', $_LANG['ad_html']);
|
|
}
|
|
elseif ($ads_arr['media_type'] == 3)
|
|
{
|
|
$smarty->assign('media_type', $_LANG['ad_text']);
|
|
}
|
|
|
|
$smarty->assign('ur_here', $_LANG['ads_edit']);
|
|
$smarty->assign('action_link', array('href' => 'touch_ads.php?act=list', 'text' => $_LANG['ad_list']));
|
|
$smarty->assign('form_act', 'update');
|
|
$smarty->assign('action', 'edit');
|
|
$smarty->assign('position_list', get_position_list());
|
|
$smarty->assign('ads', $ads_arr);
|
|
|
|
assign_query_info();
|
|
$smarty->display('touch_ads_info.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 广告编辑的处理
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'update')
|
|
{
|
|
admin_priv('touch_ad');
|
|
|
|
/* 初始化变量 */
|
|
$id = !empty($_POST['id']) ? intval($_POST['id']) : 0;
|
|
$type = !empty($_POST['media_type']) ? intval($_POST['media_type']) : 0;
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$is_new = !empty($_POST['is_new']) ? intval($_POST['is_new']) : 0;
|
|
$is_hot = !empty($_POST['is_hot']) ? intval($_POST['is_hot']) : 0;
|
|
$is_best = !empty($_POST['is_best']) ? intval($_POST['is_best']) : 0;
|
|
|
|
$_POST['ad_name'] = !empty($_POST['ad_name']) ? trim($_POST['ad_name']) : '';
|
|
$link_color = !empty($_POST['link_color']) ? trim($_POST['link_color']) : '';
|
|
|
|
$ad_type = !empty($_POST['ad_type']) ? intval($_POST['ad_type']) : 0;
|
|
$goods_name = !empty($_POST['goods_name']) ? trim($_POST['goods_name']) : 0;
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
if ($_POST['media_type'] == '0')
|
|
{
|
|
$ad_link = !empty($_POST['ad_link']) ? trim($_POST['ad_link']) : '';
|
|
}
|
|
else
|
|
{
|
|
$ad_link = !empty($_POST['ad_link2']) ? trim($_POST['ad_link2']) : '';
|
|
}
|
|
|
|
/* 获得广告的开始时期与结束日期 */
|
|
$start_time = local_strtotime($_POST['start_time']);
|
|
$end_time = local_strtotime($_POST['end_time']);
|
|
|
|
/* 编辑图片类型的广告 */
|
|
if ($type == 0)
|
|
{
|
|
if ((isset($_FILES['ad_img']['error']) && $_FILES['ad_img']['error'] == 0) || (!isset($_FILES['ad_img']['error']) && isset($_FILES['ad_img']['tmp_name']) && $_FILES['ad_img']['tmp_name'] != 'none'))
|
|
{
|
|
$img_up_info = basename($image->upload_image($_FILES['ad_img'], 'afficheimg'));
|
|
$ad_code = "ad_code = '".$img_up_info."'".',';
|
|
}
|
|
else
|
|
{
|
|
$ad_code = '';
|
|
}
|
|
if (!empty($_POST['img_url']))
|
|
{
|
|
$ad_code = "ad_code = '$_POST[img_url]', ";
|
|
}
|
|
}
|
|
|
|
/* 如果是编辑Flash广告 */
|
|
elseif ($type == 1)
|
|
{
|
|
if ((isset($_FILES['upfile_flash']['error']) && $_FILES['upfile_flash']['error'] == 0) || (!isset($_FILES['upfile_flash']['error']) && isset($_FILES['upfile_flash']['tmp_name']) && $_FILES['upfile_flash']['tmp_name'] != 'none'))
|
|
{
|
|
/* 检查文件类型 */
|
|
if ($_FILES['upfile_flash']['type'] != "application/x-shockwave-flash")
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['upfile_flash_type'], 0, $link);
|
|
}
|
|
/* 生成文件名 */
|
|
$urlstr = date('Ymd');
|
|
for ($i = 0; $i < 6; $i++)
|
|
{
|
|
$urlstr .= chr(mt_rand(97, 122));
|
|
}
|
|
|
|
$source_file = $_FILES['upfile_flash']['tmp_name'];
|
|
$target = ROOT_PATH . DATA_DIR . '/afficheimg/';
|
|
$file_name = $urlstr .'.swf';
|
|
|
|
if (!move_upload_file($source_file, $target.$file_name))
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['upfile_error'], 0, $link);
|
|
}
|
|
else
|
|
{
|
|
$ad_code = "ad_code = '$file_name', ";
|
|
}
|
|
}
|
|
elseif (!empty($_POST['flash_url']))
|
|
{
|
|
if (substr(strtolower($_POST['flash_url']), strlen($_POST['flash_url']) - 4) != '.swf')
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'javascript:history.back(-1)');
|
|
sys_msg($_LANG['upfile_flash_type'], 0, $link);
|
|
}
|
|
$ad_code = "ad_code = '".$_POST['flash_url']."', ";
|
|
}
|
|
else
|
|
{
|
|
$ad_code = '';
|
|
}
|
|
|
|
}
|
|
|
|
/* 编辑代码类型的广告 */
|
|
elseif ($type == 2)
|
|
{
|
|
$ad_code = "ad_code = '$_POST[ad_code]', ";
|
|
}
|
|
|
|
/* 编辑文本类型的广告 */
|
|
if ($type == 3)
|
|
{
|
|
$ad_code = "ad_code = '$_POST[ad_text]', ";
|
|
}
|
|
|
|
$template = $GLOBALS['_CFG']['template'];
|
|
|
|
/* 查看广告名称是否有重复 ecmoban模板堂 --zhuo */
|
|
$sql = "SELECT COUNT(*) FROM " .$ecs->table('touch_ad')." AS a, ".
|
|
$ecs->table('touch_ad_position') ." AS p ".
|
|
" WHERE a.ad_id <> '$id' AND a.ad_name ='$_POST[ad_name]' AND a.position_id = p.position_id AND p.theme = '$template'";
|
|
if ($db->getOne($sql) > 0)
|
|
{
|
|
$link[] = array('text' => $_LANG['go_back'], 'href' => 'touch_ads.php?act=edit&id='.$id);
|
|
sys_msg($_LANG['ad_name_exist'], 0, $link);
|
|
exit;
|
|
}
|
|
|
|
$ad_code = str_replace('../' . DATA_DIR . '/afficheimg/', '', $ad_code);
|
|
/* 更新信息 */
|
|
$sql = "UPDATE " .$ecs->table('touch_ad'). " SET ".
|
|
"position_id = '$_POST[position_id]', ".
|
|
"ad_name = '$_POST[ad_name]', ".
|
|
"ad_link = '$ad_link', ".
|
|
"link_color = '$link_color', ".
|
|
"is_new = '$is_new', ".
|
|
"is_hot = '$is_hot', ".
|
|
"is_best = '$is_best', ".
|
|
$ad_code.
|
|
"start_time = '$start_time', ".
|
|
"end_time = '$end_time', ".
|
|
"link_man = '$_POST[link_man]', ".
|
|
"link_email = '$_POST[link_email]', ".
|
|
"link_phone = '$_POST[link_phone]', ".
|
|
"enabled = '$_POST[enabled]', ".
|
|
"ad_type = '$ad_type', ".
|
|
"goods_name = '$goods_name' ".
|
|
"WHERE ad_id = '$id'";
|
|
$db->query($sql);
|
|
|
|
/* 记录管理员操作 */
|
|
admin_log($_POST['ad_name'], 'edit', 'ads');
|
|
|
|
clear_cache_files(); // 清除模版缓存
|
|
|
|
/* 提示信息 */
|
|
$href[] = array('text' => $_LANG['back_ads_list'], 'href' => 'touch_ads.php?act=list');
|
|
sys_msg($_LANG['edit'] .' '.$_POST['ad_name'].' '. $_LANG['attradd_succed'], 0, $href);
|
|
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//--生成广告的JS代码
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'add_js')
|
|
{
|
|
admin_priv('touch_ad');
|
|
|
|
/* 编码 */
|
|
$lang_list = array(
|
|
'UTF8' => $_LANG['charset']['utf8'],
|
|
'GB2312' => $_LANG['charset']['zh_cn'],
|
|
'BIG5' => $_LANG['charset']['zh_tw'],
|
|
);
|
|
|
|
$js_code = "<script type=".'"'."text/javascript".'"';
|
|
$js_code .= ' src='.'"'.$ecs->url().'affiche.php?act=js&type='.$_REQUEST['type'].'&ad_id='.intval($_REQUEST['id']).'"'.'></script>';
|
|
|
|
$site_url = $ecs->url().'affiche.php?act=js&type='.$_REQUEST['type'].'&ad_id='.intval($_REQUEST['id']);
|
|
|
|
$smarty->assign('ur_here', $_LANG['add_js_code']);
|
|
$smarty->assign('action_link', array('href' => 'touch_ads.php?act=list', 'text' => $_LANG['ad_list']));
|
|
$smarty->assign('url', $site_url);
|
|
$smarty->assign('js_code', $js_code);
|
|
$smarty->assign('lang_list', $lang_list);
|
|
|
|
assign_query_info();
|
|
$smarty->display('touch_ads_js.htm');
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 编辑广告名称
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'edit_ad_name')
|
|
{
|
|
check_authz_json('ad_manage');
|
|
|
|
$id = intval($_POST['id']);
|
|
$ad_name = json_str_iconv(trim($_POST['val']));
|
|
|
|
$template = $GLOBALS['_CFG']['template'];
|
|
|
|
/* 查看广告名称是否有重复 ecmoban模板堂 --zhuo */
|
|
$sql = "SELECT COUNT(*) FROM " .$ecs->table('touch_ad')." AS a, ".
|
|
$ecs->table('touch_ad_position') ." AS p ".
|
|
" WHERE a.ad_id <> '$id' AND a.ad_name ='$ad_name' AND a.position_id = p.position_id AND p.theme = '$template'";
|
|
if ($db->getOne($sql) > 0)
|
|
{
|
|
$res = 1;
|
|
}else{
|
|
$res = 0;
|
|
}
|
|
|
|
/* 检查广告名称是否重复 */
|
|
if ($res)
|
|
{
|
|
make_json_error(sprintf($_LANG['ad_name_exist'], $ad_name));
|
|
}
|
|
else
|
|
{
|
|
if ($exc->edit("ad_name = '$ad_name'", $id))
|
|
{
|
|
admin_log($ad_name,'edit','ads');
|
|
make_json_result(stripslashes($ad_name));
|
|
}
|
|
else
|
|
{
|
|
make_json_error($db->error());
|
|
}
|
|
}
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 删除广告位置
|
|
/*------------------------------------------------------ */
|
|
elseif ($_REQUEST['act'] == 'remove')
|
|
{
|
|
check_authz_json('ad_manage');
|
|
|
|
$id = intval($_GET['id']);
|
|
$img = $exc->get_name($id, 'ad_code');
|
|
|
|
$exc->drop($id);
|
|
|
|
if ((strpos($img, 'http://') === false) && (strpos($img, 'https://') === false))
|
|
{
|
|
$img_name = basename($img);
|
|
@unlink(ROOT_PATH. DATA_DIR . '/afficheimg/'.$img_name);
|
|
}
|
|
|
|
admin_log('', 'remove', 'ads');
|
|
|
|
$url = 'touch_ads.php?act=query&' . str_replace('act=remove', '', $_SERVER['QUERY_STRING']);
|
|
|
|
ecs_header("Location: $url\n");
|
|
exit;
|
|
}
|
|
|
|
/* 获取广告数据列表 */
|
|
function get_adslist($ru_id)
|
|
{
|
|
/* 过滤查询 */
|
|
$filter = array();
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
$filter['keyword'] = !empty($_REQUEST['keyword']) ? trim($_REQUEST['keyword']) : '';
|
|
if (isset($_REQUEST['is_ajax']) && $_REQUEST['is_ajax'] == 1)
|
|
{
|
|
$filter['keyword'] = json_str_iconv($filter['keyword']);
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
$filter['sort_by'] = empty($_REQUEST['sort_by']) ? 'ad.ad_id' : trim($_REQUEST['sort_by']);
|
|
$filter['sort_order'] = empty($_REQUEST['sort_order']) ? 'DESC' : trim($_REQUEST['sort_order']);
|
|
$filter['pid'] = empty($_REQUEST['pid']) ? 0 : intval($_REQUEST['pid']);
|
|
|
|
$where = 'WHERE 1 ';
|
|
if (!empty($filter['pid']))
|
|
{
|
|
$where .= " AND ad.position_id = '" .$filter['pid']. "' ";
|
|
}
|
|
|
|
/* 关键字 */
|
|
if (!empty($filter['keyword']))
|
|
{
|
|
$where .= " AND (p.position_name LIKE '%" . mysql_like_quote($filter['keyword']) . "%'" . ")";
|
|
}
|
|
|
|
//ecmoban模板堂 --zhuo start
|
|
if($ru_id > 0){
|
|
$where .= " and (p.user_id = '$ru_id' or (is_public = 1 and ad.public_ruid = '$ru_id')) ";
|
|
}
|
|
//ecmoban模板堂 --zhuo end
|
|
|
|
//模板类型
|
|
$where .= " AND p.theme = '" .$GLOBALS['_CFG']['template']. "'";
|
|
|
|
//管理员查询的权限 -- 店铺查询 start
|
|
$filter['store_search'] = empty($_REQUEST['store_search']) ? 0 : intval($_REQUEST['store_search']);
|
|
$filter['merchant_id'] = isset($_REQUEST['merchant_id']) ? intval($_REQUEST['merchant_id']) : 0;
|
|
$filter['store_keyword'] = isset($_REQUEST['store_keyword']) ? trim($_REQUEST['store_keyword']) : '';
|
|
|
|
$store_where = '';
|
|
$store_search_where = '';
|
|
if($filter['store_search'] !=0){
|
|
if($ru_id == 0){
|
|
|
|
if($_REQUEST['store_type']){
|
|
$store_search_where = "AND msi.shopNameSuffix = '" .$_REQUEST['store_type']. "'";
|
|
}
|
|
|
|
if($filter['store_search'] == 1){
|
|
$where .= " AND p.user_id = '" .$filter['merchant_id']. "' ";
|
|
}elseif($filter['store_search'] == 2){
|
|
$store_where .= " AND msi.rz_shopName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%'";
|
|
}elseif($filter['store_search'] == 3){
|
|
$store_where .= " AND msi.shoprz_brandName LIKE '%" . mysql_like_quote($filter['store_keyword']) . "%' " . $store_search_where;
|
|
}
|
|
|
|
if($filter['store_search'] > 1){
|
|
$where .= " AND (SELECT msi.user_id FROM " . $GLOBALS['ecs']->table('merchants_shop_information') .' as msi ' .
|
|
" WHERE msi.user_id = p.user_id $store_where) > 0 ";
|
|
}
|
|
}
|
|
}
|
|
//管理员查询的权限 -- 店铺查询 end
|
|
|
|
/* 获得总记录数据 */
|
|
$sql = 'SELECT COUNT(*) FROM ' .$GLOBALS['ecs']->table('touch_ad'). ' AS ad ' . 'LEFT JOIN ' . $GLOBALS['ecs']->table('touch_ad_position'). ' AS p ON p.position_id = ad.position_id ' . $where;
|
|
$filter['record_count'] = $GLOBALS['db']->getOne($sql);
|
|
|
|
$filter = page_and_size($filter);
|
|
|
|
/* 获得广告数据 */
|
|
$arr = array();
|
|
$sql = 'SELECT ad.*, COUNT(o.order_id) AS ad_stats, p.position_name, p.user_id '.
|
|
'FROM ' .$GLOBALS['ecs']->table('touch_ad'). 'AS ad ' .
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('touch_ad_position'). ' AS p ON p.position_id = ad.position_id '.
|
|
'LEFT JOIN ' . $GLOBALS['ecs']->table('order_info'). " AS o ON o.from_ad = ad.ad_id $where " .
|
|
'GROUP BY ad.ad_id '.
|
|
'ORDER by '.$filter['sort_by'].' '.$filter['sort_order'];
|
|
|
|
$res = $GLOBALS['db']->selectLimit($sql, $filter['page_size'], $filter['start']);
|
|
|
|
$idx = 0;
|
|
while ($rows = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
/* 广告类型的名称 */
|
|
$rows['type'] = ($rows['media_type'] == 0) ? $GLOBALS['_LANG']['ad_img'] : '';
|
|
$rows['type'] .= ($rows['media_type'] == 1) ? $GLOBALS['_LANG']['ad_flash'] : '';
|
|
$rows['type'] .= ($rows['media_type'] == 2) ? $GLOBALS['_LANG']['ad_html'] : '';
|
|
$rows['type'] .= ($rows['media_type'] == 3) ? $GLOBALS['_LANG']['ad_text'] : '';
|
|
|
|
/* 格式化日期 */
|
|
$rows['start_date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['start_time']);
|
|
$rows['end_date'] = local_date($GLOBALS['_CFG']['time_format'], $rows['end_time']);
|
|
|
|
if($rows['public_ruid'] == 0){
|
|
$user_id = $rows['user_id'];
|
|
}else{
|
|
$user_id = $rows['public_ruid'];
|
|
}
|
|
|
|
$rows['user_name'] = get_shop_name($user_id, 1); //ecmoban模板堂 --zhuo
|
|
|
|
$arr[$idx] = $rows;
|
|
|
|
$idx++;
|
|
}
|
|
|
|
return array('ads' => $arr, 'filter' => $filter, 'page_count' => $filter['page_count'], 'record_count' => $filter['record_count']);
|
|
}
|
|
|
|
?>
|