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.
624 lines
24 KiB
624 lines
24 KiB
<?php
|
|
|
|
/**
|
|
* ECSHOP 图片批量处理程序
|
|
* ============================================================================
|
|
* * 版权所有 2005-2016 上海商创网络科技有限公司，并保留所有权利。
|
|
* 网站地址: http://www.ecmoban.com；
|
|
* ----------------------------------------------------------------------------
|
|
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
|
|
* 使用；不允许对程序代码以任何形式任何目的的再发布。
|
|
* ============================================================================
|
|
* $Author: liubo $
|
|
* $Id: picture_batch.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');
|
|
include_once(ROOT_PATH . '/' . ADMIN_PATH . '/includes/lib_goods.php');
|
|
$image = new cls_image($_CFG['bgcolor']);
|
|
|
|
/* 权限检查 */
|
|
admin_priv('picture_batch');
|
|
|
|
if (empty($_GET['is_ajax']))
|
|
{
|
|
assign_query_info();
|
|
$smarty->assign('ur_here', $_LANG['12_batch_pic']);
|
|
// $smarty->assign('cat_list', cat_list(0, 0));
|
|
$smarty->assign('cat_list', cat_list_one(0)); // 获取一层分类
|
|
$smarty->assign('brand_list', get_brand_list());
|
|
$smarty->display('picture_batch.htm');
|
|
}
|
|
elseif (!empty($_GET['get_goods']))
|
|
{
|
|
include_once(ROOT_PATH . 'includes/cls_json.php');
|
|
$json = new JSON();
|
|
$brand_id = intval($_GET['brand_id']);
|
|
$cat_id = intval($_GET['cat_id']);
|
|
$goods_where = '';
|
|
|
|
if (!empty($cat_id))
|
|
{
|
|
$goods_where .= ' AND ' . get_children($cat_id);
|
|
}
|
|
if (!empty($brand_id))
|
|
{
|
|
$goods_where .= " AND g.`brand_id` = '$brand_id'";
|
|
}
|
|
|
|
$sql = 'SELECT `goods_id`, `goods_name` FROM ' . $ecs->table('goods') . ' AS g WHERE 1 ' . $goods_where . ' LIMIT 50';
|
|
|
|
die($json->encode($db->getAll($sql)));
|
|
}
|
|
else
|
|
{
|
|
include_once(ROOT_PATH . 'includes/cls_json.php');
|
|
$json = new JSON();
|
|
$proc_thumb = (isset($GLOBALS['shop_id']) && $GLOBALS['shop_id'] > 0);
|
|
$do_album = empty($_GET['do_album']) ? 0 : 1;
|
|
$do_icon = empty($_GET['do_icon']) ? 0 : 1;
|
|
$goods_id = trim($_GET['goods_id']);
|
|
$brand_id = intval($_GET['brand_id']);
|
|
$cat_id = intval($_GET['cat_id']);
|
|
$goods_where = '';
|
|
$album_where = '';
|
|
$module_no = 0;
|
|
|
|
if ($do_album == 1 AND $do_icon == 0)
|
|
{
|
|
$module_no = 1;
|
|
}
|
|
if (empty($goods_id))
|
|
{
|
|
if (!empty($cat_id))
|
|
{
|
|
$goods_where .= ' AND ' . get_children($cat_id);
|
|
}
|
|
if (!empty($brand_id))
|
|
{
|
|
$goods_where .= " AND g.`brand_id` = '$brand_id'";
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
$goods_where .= ' AND g.`goods_id` ' . db_create_in($goods_id);
|
|
}
|
|
|
|
if (!empty($goods_where))
|
|
{
|
|
$album_where = ', ' . $ecs->table('goods'). " AS g WHERE album.img_original > '' AND album.goods_id = g.goods_id " . $goods_where;
|
|
}
|
|
else
|
|
{
|
|
$album_where = " WHERE album.img_original > ''";
|
|
}
|
|
|
|
|
|
/* 设置最长执行时间为5分钟 */
|
|
@set_time_limit(300);
|
|
|
|
if (isset($_GET['start']))
|
|
{
|
|
$page_size = 50; // 默认50张/页
|
|
$thumb = empty($_GET['thumb']) ? 0 : 1;
|
|
$watermark = empty($_GET['watermark']) ? 0 : 1;
|
|
$change = empty($_GET['change']) ? 0 : 1;
|
|
$silent = empty($_GET['silent']) ? 0 : 1;
|
|
|
|
/* 检查GD */
|
|
if ($image->gd_version() < 1)
|
|
{
|
|
make_json_error($_LANG['missing_gd']);
|
|
}
|
|
|
|
/* 如果需要添加水印，检查水印文件 */
|
|
if ((!empty($_CFG['watermark'])) && ($_CFG['watermark_place'] > 0) && $watermark && (!$image->validate_image($_CFG['watermark'])))
|
|
{
|
|
make_json_error($image->error_msg());
|
|
}
|
|
$title = '';
|
|
|
|
if (isset($_GET['total_icon']))
|
|
{
|
|
$count = $db->GetOne("SELECT COUNT(*) FROM ".$ecs->table('goods'). " AS g WHERE g.original_img <> ''" . $goods_where);
|
|
$title = sprintf($_LANG['goods_format'], $count, $page_size);
|
|
}
|
|
|
|
if (isset($_GET['total_album']))
|
|
{
|
|
$count = $GLOBALS['db']->GetOne("SELECT COUNT(*) FROM ".$GLOBALS['ecs']->table('goods_gallery'). ' AS album ' . $album_where);
|
|
$title = sprintf(' ' . $_LANG['gallery_format'], $count, $page_size);
|
|
$module_no = 1;
|
|
}
|
|
$result = array('error' => 0, 'message' => '', 'content' => '', 'module_no' => $module_no, 'done' => 1, 'title' => $title, 'page_size' => $page_size,
|
|
'page' => 1, 'thumb'=> $thumb, 'watermark' => $watermark, 'total' => 1, 'change' => $change, 'silent' => $silent,
|
|
'do_album' => $do_album, 'do_icon'=> $do_icon, 'goods_id'=> $goods_id, 'brand_id'=> $brand_id, 'cat_id'=> $cat_id,
|
|
'row' => array('new_page' => sprintf($_LANG['page_format'], 1),
|
|
'new_total' => sprintf($_LANG['total_format'], ceil($count/$page_size)),
|
|
'new_time' => $_LANG['wait'],
|
|
'cur_id' => 'time_1'));
|
|
|
|
die($json->encode($result));
|
|
}
|
|
|
|
else
|
|
{
|
|
$result = array('error' => 0, 'message' => '', 'content' => '', 'done' => 2, 'do_album' => $do_album, 'do_icon'=> $do_icon, 'goods_id'=> $goods_id, 'brand_id'=> $brand_id, 'cat_id'=> $cat_id);
|
|
$result['thumb'] = empty($_GET['thumb']) ? 0 : 1;
|
|
$result['watermark'] = empty($_GET['watermark']) ? 0 : 1;
|
|
$result['change'] = empty($_GET['change']) ? 0 : 1;
|
|
$result['page_size'] = empty($_GET['page_size']) ? 100 : intval($_GET['page_size']);
|
|
$result['module_no'] = empty($_GET['module_no']) ? 0 : intval($_GET['module_no']);
|
|
$result['page'] = isset($_GET['page']) ? intval($_GET['page']) : 1;
|
|
$result['total'] = isset($_GET['total']) ? intval($_GET['total']) : 1;
|
|
$result['silent'] = empty($_GET['silent']) ? 0 : 1;
|
|
|
|
if ($result['silent'])
|
|
{
|
|
$err_msg = array();
|
|
}
|
|
|
|
/*------------------------------------------------------ */
|
|
//-- 商品图片
|
|
/*------------------------------------------------------ */
|
|
if ($result['module_no'] == 0)
|
|
{
|
|
$count = $GLOBALS['db']->GetOne("SELECT COUNT(*) FROM ".$ecs->table('goods'). " AS g WHERE g.original_img > ''" . $goods_where);
|
|
/* 页数在许可范围内 */
|
|
if ($result['page'] <= ceil($count / $result['page_size']))
|
|
{
|
|
$start_time = gmtime(); //开始执行时间
|
|
|
|
/* 开始处理 */
|
|
if ($proc_thumb)
|
|
{
|
|
process_image_ex($result['page'], $result['page_size'], $result['module_no'], $result['thumb'], $result['watermark'], $result['change'], $result['silent']);
|
|
}
|
|
else
|
|
{
|
|
process_image($result['page'], $result['page_size'], $result['module_no'], $result['thumb'], $result['watermark'], $result['change'], $result['silent']);
|
|
}
|
|
$end_time = gmtime();
|
|
$result['row']['pre_id'] = 'time_' . $result['total'];
|
|
$result['row']['pre_time'] = ($end_time > $start_time) ? $end_time - $start_time : 1;
|
|
$result['row']['pre_time'] = sprintf($_LANG['time_format'], $result['row']['pre_time']);
|
|
$result['row']['cur_id'] = 'time_' . ($result['total'] + 1);
|
|
$result['page']++; // 新行
|
|
$result['row']['new_page'] = sprintf($_LANG['page_format'], $result['page']);
|
|
$result['row']['new_total'] = sprintf($_LANG['total_format'], ceil($count/$result['page_size']));
|
|
$result['row']['new_time'] = $_LANG['wait'];
|
|
$result['total']++;
|
|
}
|
|
else
|
|
{
|
|
--$result['total'];
|
|
--$result['page'];
|
|
$result['done'] = 0;
|
|
$result['message'] = ($do_album) ? '' : $_LANG['done'];
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
die($json->encode($result));
|
|
}
|
|
}
|
|
else if ($result['module_no'] == 1 && $result['do_album'] == 1)
|
|
{
|
|
//商品相册
|
|
$count = $GLOBALS['db']->GetOne("SELECT COUNT(*) FROM ".$GLOBALS['ecs']->table('goods_gallery'). ' AS album ' . $album_where);
|
|
|
|
if ($result['page'] <= ceil($count / $result['page_size']))
|
|
{
|
|
$start_time = gmtime(); // 开始执行时间
|
|
/* 开始处理 */
|
|
if ($proc_thumb)
|
|
{
|
|
process_image_ex($result['page'], $result['page_size'], $result['module_no'], $result['thumb'], $result['watermark'], $result['change'], $result['silent']);
|
|
}
|
|
else
|
|
{
|
|
process_image($result['page'], $result['page_size'], $result['module_no'], $result['thumb'], $result['watermark'], $result['change'], $result['silent']);
|
|
}
|
|
$end_time = gmtime();
|
|
|
|
$result['row']['pre_id'] = 'time_' . $result['total'];
|
|
$result['row']['pre_time'] = ($end_time > $start_time) ? $end_time - $start_time : 1;
|
|
$result['row']['pre_time'] = sprintf($_LANG['time_format'], $result['row']['pre_time']);
|
|
$result['row']['cur_id'] = 'time_' . ($result['total'] + 1);
|
|
$result['page']++;
|
|
$result['row']['new_page'] = sprintf($_LANG['page_format'], $result['page']);
|
|
$result['row']['new_total'] = sprintf($_LANG['total_format'], ceil($count/$result['page_size']));
|
|
$result['row']['new_time'] = $_LANG['wait'];
|
|
|
|
$result['total']++;
|
|
}
|
|
else
|
|
{
|
|
$result['row']['pre_id'] = 'time_' . $result['total'];
|
|
$result['row']['cur_id'] = 'time_' . ($result['total'] + 1);
|
|
$result['row']['new_page'] = sprintf($_LANG['page_format'], $result['page']);
|
|
$result['row']['new_total'] = sprintf($_LANG['total_format'], ceil($count/$result['page_size']));
|
|
$result['row']['new_time'] = $_LANG['wait'];
|
|
|
|
/* 执行结束 */
|
|
$result['done'] = 0;
|
|
$result['message'] = $_LANG['done'];
|
|
/* 清除缓存 */
|
|
clear_cache_files();
|
|
}
|
|
}
|
|
|
|
if ($result['silent'] && $err_msg)
|
|
{
|
|
$result['content'] = implode('<br />' , $err_msg);
|
|
}
|
|
|
|
die($json->encode($result));
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 图片处理函数
|
|
*
|
|
* @access public
|
|
* @param integer $page
|
|
* @param integer $page_size
|
|
* @param integer $type
|
|
* @param boolen $thumb 是否生成缩略图
|
|
* @param boolen $watermark 是否生成水印图
|
|
* @param boolen $change true 生成新图，删除旧图 false 用新图覆盖旧图
|
|
* @param boolen $silent 是否执行能忽略错误
|
|
*
|
|
* @return void
|
|
*/
|
|
function process_image($page = 1, $page_size = 100, $type = 0, $thumb= true, $watermark = true, $change = false, $silent = true)
|
|
{
|
|
if ($type == 0)
|
|
{
|
|
$sql = "SELECT g.goods_id, g.original_img, g.goods_img, g.goods_thumb FROM ".$GLOBALS['ecs']->table('goods'). " AS g WHERE g.original_img > ''" . $GLOBALS['goods_where'];
|
|
$res = $GLOBALS['db']->SelectLimit($sql, $page_size, ($page-1)*$page_size);
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
$goods_thumb = '';
|
|
$image = '';
|
|
|
|
/* 水印 */
|
|
if ($watermark)
|
|
{
|
|
/* 获取加水印图片的目录 */
|
|
if (empty($row['goods_img']))
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['original_img']) . '/';
|
|
}
|
|
else
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['goods_img']) . '/';
|
|
}
|
|
|
|
$image = $GLOBALS['image']->make_thumb(ROOT_PATH . $row['original_img'], $GLOBALS['_CFG']['image_width'], $GLOBALS['_CFG']['image_height'], $dir); //先生成缩略图
|
|
|
|
if (!$image)
|
|
{
|
|
//出错返回
|
|
$msg = sprintf($GLOBALS['_LANG']['error_pos'], $row['goods_id']) . "\n" . $GLOBALS['image']->error_msg();
|
|
if ($silent)
|
|
{
|
|
$GLOBALS['err_msg'][] = $msg;
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
make_json_error($msg);
|
|
}
|
|
|
|
}
|
|
|
|
$image = $GLOBALS['image']->add_watermark(ROOT_PATH . $image, '', $GLOBALS['_CFG']['watermark'], $GLOBALS['_CFG']['watermark_place'], $GLOBALS['_CFG']['watermark_alpha']);
|
|
|
|
if (!$image)
|
|
{
|
|
//出错返回
|
|
$msg = sprintf($GLOBALS['_LANG']['error_pos'], $row['goods_id']) . "\n" . $GLOBALS['image']->error_msg();
|
|
if ($silent)
|
|
{
|
|
$GLOBALS['err_msg'][] = $msg;
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
make_json_error($msg);
|
|
}
|
|
}
|
|
|
|
/* 重新格式化图片名称 */
|
|
$image = reformat_image_name('goods', $row['goods_id'], $image, 'goods');
|
|
if ($change || empty($row['goods_img']))
|
|
{
|
|
/* 要生成新链接的处理过程 */
|
|
if ($image != $row['goods_img'])
|
|
{
|
|
$sql = "UPDATE " .$GLOBALS['ecs']->table('goods'). " SET goods_img = '$image' WHERE goods_id = '" . $row['goods_id'] . "'";
|
|
$GLOBALS['db']->query($sql);
|
|
/* 防止原图被删除 */
|
|
if ($row['goods_img'] != $row['original_img'])
|
|
{
|
|
@unlink(ROOT_PATH . $row['goods_img']);
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
replace_image($image, $row['goods_img'], $row['goods_id'], $silent);
|
|
}
|
|
}
|
|
|
|
/* 缩略图 */
|
|
if ($thumb)
|
|
{
|
|
if (empty($row['goods_thumb']))
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['original_img']) . '/';
|
|
}
|
|
else
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['goods_thumb']) . '/';
|
|
}
|
|
|
|
$goods_thumb = $GLOBALS['image']->make_thumb(ROOT_PATH.$row['original_img'], $GLOBALS['_CFG']['thumb_width'], $GLOBALS['_CFG']['thumb_height'], $dir);
|
|
|
|
/* 出错处理 */
|
|
if (!$goods_thumb)
|
|
{
|
|
$msg = sprintf($GLOBALS['_LANG']['error_pos'], $row['goods_id']) . "\n" . $GLOBALS['image']->error_msg();
|
|
if ($silent)
|
|
{
|
|
$GLOBALS['err_msg'][] = $msg;
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
make_json_error($msg);
|
|
}
|
|
|
|
}
|
|
/* 重新格式化图片名称 */
|
|
$goods_thumb = reformat_image_name('goods_thumb', $row['goods_id'], $goods_thumb, 'thumb');
|
|
if ($change || empty($row['goods_thumb']))
|
|
{
|
|
if ($row['goods_thumb'] != $goods_thumb)
|
|
{
|
|
$sql = "UPDATE " .$GLOBALS['ecs']->table('goods'). " SET goods_thumb = '$goods_thumb' WHERE goods_id = '" . $row['goods_id'] . "'";
|
|
$GLOBALS['db']->query($sql);
|
|
/* 防止原图被删除 */
|
|
if ($row['goods_thumb'] != $row['original_img'])
|
|
{
|
|
@unlink(ROOT_PATH . $row['goods_thumb']);
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
replace_image($goods_thumb, $row['goods_thumb'], $row['goods_id'], $silent);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
/* 遍历商品相册 */
|
|
$sql = "SELECT album.goods_id, album.img_id, album.img_url, album.thumb_url, album.img_original FROM ".$GLOBALS['ecs']->table('goods_gallery'). " AS album " . $GLOBALS['album_where'];
|
|
$res = $GLOBALS['db']->SelectLimit($sql, $page_size, ($page - 1) * $page_size);
|
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
$thumb_url = '';
|
|
$image = '';
|
|
|
|
/* 水印 */
|
|
if ($watermark && file_exists(ROOT_PATH . $row['img_original']))
|
|
{
|
|
if (empty($row['img_url']))
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['img_original']) . '/';
|
|
}
|
|
else
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['img_url']) . '/';
|
|
}
|
|
|
|
$file_name = cls_image::unique_name($dir);
|
|
$file_name .= cls_image::get_filetype(empty($row['img_url']) ? $row['img_original']: $row['img_url']);
|
|
|
|
copy(ROOT_PATH . $row['img_original'], $dir . $file_name);
|
|
$image = $GLOBALS['image']->add_watermark($dir . $file_name ,'',$GLOBALS['_CFG']['watermark'], $GLOBALS['_CFG']['watermark_place'], $GLOBALS['_CFG']['watermark_alpha']);
|
|
if (!$image)
|
|
{
|
|
@unlink($dir . $file_name);
|
|
$msg = sprintf($GLOBALS['_LANG']['error_pos'], $row['goods_id']) . "\n" . $GLOBALS['image']->error_msg();
|
|
if ($silent)
|
|
{
|
|
$GLOBALS['err_msg'][] = $msg;
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
make_json_error($msg);
|
|
}
|
|
}
|
|
/* 重新格式化图片名称 */
|
|
$image = reformat_image_name('gallery', $row['goods_id'], $image, 'goods');
|
|
if ($change || empty($row['img_url']) || $row['img_original'] == $row['img_url'])
|
|
{
|
|
if ($image != $row['img_url'])
|
|
{
|
|
$sql = "UPDATE " .$GLOBALS['ecs']->table('goods_gallery'). " SET img_url='$image' WHERE img_id='$row[img_id]'";
|
|
$GLOBALS['db']->query($sql);
|
|
if ($row['img_original'] != $row['img_url'])
|
|
{
|
|
@unlink(ROOT_PATH . $row['img_url']);
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
replace_image($image, $row['img_url'], $row['goods_id'], $silent);
|
|
}
|
|
}
|
|
|
|
/* 缩略图 */
|
|
if ($thumb)
|
|
{
|
|
if (empty($row['thumb_url']))
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['img_original']) . '/';
|
|
}
|
|
else
|
|
{
|
|
$dir = dirname(ROOT_PATH . $row['thumb_url']) . '/';
|
|
}
|
|
|
|
$thumb_url = $GLOBALS['image']->make_thumb(ROOT_PATH . $row['img_original'], $GLOBALS['_CFG']['thumb_width'], $GLOBALS['_CFG']['thumb_height'], $dir);
|
|
|
|
if (!$thumb_url)
|
|
{
|
|
$msg = sprintf($GLOBALS['_LANG']['error_pos'], $row['goods_id']) . "\n" . $GLOBALS['image']->error_msg();
|
|
if ($silent)
|
|
{
|
|
$GLOBALS['err_msg'][] = $msg;
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
make_json_error($msg);
|
|
}
|
|
}
|
|
/* 重新格式化图片名称 */
|
|
$thumb_url = reformat_image_name('gallery_thumb', $row['goods_id'], $thumb_url, 'thumb');
|
|
if ($change || empty($row['thumb_url']))
|
|
{
|
|
if ($thumb_url != $row['thumb_url'])
|
|
{
|
|
$sql = "UPDATE " .$GLOBALS['ecs']->table('goods_gallery'). " SET thumb_url='$thumb_url' WHERE img_id='$row[img_id]'";
|
|
$GLOBALS['db']->query($sql);
|
|
@unlink(ROOT_PATH . $row['thumb_url']);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
replace_image($thumb_url, $row['thumb_url'], $row['goods_id'],$silent);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 图片处理函数
|
|
*
|
|
* @access public
|
|
* @param integer $page
|
|
* @param integer $page_size
|
|
* @param integer $type
|
|
* @param boolen $thumb 是否生成缩略图
|
|
* @param boolen $watermark 是否生成水印图
|
|
* @param boolen $change true 生成新图，删除旧图 false 用新图覆盖旧图
|
|
* @param boolen $silent 是否执行能忽略错误
|
|
*
|
|
* @return void
|
|
*/
|
|
function process_image_ex($page = 1, $page_size = 100, $type = 0, $thumb= true, $watermark = true, $change = false, $silent = true)
|
|
{
|
|
if ($type == 0)
|
|
{
|
|
$sql = "SELECT g.goods_id, g.original_img, g.goods_img, g.goods_thumb FROM ".$GLOBALS['ecs']->table('goods'). " AS g WHERE g.original_img > ''" . $goods_where;
|
|
$res = $GLOBALS['db']->SelectLimit($sql, $page_size, ($page-1)*$page_size);
|
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
if ($thumb)
|
|
{
|
|
get_image_path($row['goods_id'], '', true, 'goods', true);
|
|
}
|
|
if ($watermark)
|
|
{
|
|
get_image_path($row['goods_id'], '', false, 'goods', true);
|
|
}
|
|
}
|
|
}
|
|
else
|
|
{
|
|
$sql = "SELECT album.goods_id, album.img_id, album.img_url, album.thumb_url, album.img_original FROM ".$GLOBALS['ecs']->table('goods_gallery'). " AS album " . $GLOBALS['album_where'];
|
|
$res = $GLOBALS['db']->SelectLimit($sql, $page_size, ($page - 1) * $page_size);
|
|
|
|
while ($row = $GLOBALS['db']->fetchRow($res))
|
|
{
|
|
if ($thumb)
|
|
{
|
|
get_image_path($row['goods_id'], $row['img_original'], true, 'gallery', true);
|
|
}
|
|
if ($watermark)
|
|
{
|
|
get_image_path($row['goods_id'], $row['img_original'], false, 'gallery', true);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
/**
|
|
* 用新图片替换指定图片
|
|
*
|
|
* @access public
|
|
* @param string $new_image 新图片
|
|
* @param string $old_image 旧图片
|
|
* @param string $goods_id 商品图片
|
|
* @param boolen $silent 是否使用静态函数
|
|
*
|
|
* @return void
|
|
*/
|
|
function replace_image($new_image, $old_image, $goods_id, $silent)
|
|
{
|
|
$error = false;
|
|
if (file_exists(ROOT_PATH . $old_image))
|
|
{
|
|
@rename(ROOT_PATH . $old_image, ROOT_PATH . $old_image . '.bak');
|
|
if (!@rename(ROOT_PATH . $new_image, ROOT_PATH . $old_image))
|
|
{
|
|
$error = true;
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (!@rename(ROOT_PATH . $new_image, ROOT_PATH . $old_image))
|
|
{
|
|
$error = true;
|
|
}
|
|
}
|
|
if ($error === true)
|
|
{
|
|
if (file_exists(ROOT_PATH . $old_image . '.bak'))
|
|
{
|
|
@rename(ROOT_PATH . $old_image . '.bak', ROOT_PATH . $old_image);
|
|
}
|
|
$msg = sprintf($GLOBALS['_LANG']['error_pos'], $goods_id) . "\n" . sprintf($GLOBALS['_LANG']['error_rename'], $new_image, $old_image);
|
|
if ($silent)
|
|
{
|
|
$GLOBALS['err_msg'][] = $msg;
|
|
}
|
|
else
|
|
{
|
|
make_json_error($msg);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
if (file_exists(ROOT_PATH . $old_image . '.bak'))
|
|
{
|
|
@unlink(ROOT_PATH . $old_image . '.bak');
|
|
}
|
|
return;
|
|
}
|
|
}
|
|
|
|
?>
|