📄 lib_goods.php
字号:
<?php
/**
* ECSHOP 管理中心商品相关函数
* ============================================================================
* 版权所有 2005-2008 上海商派网络科技有限公司，并保留所有权利。
* 网站地址: http://www.ecshop.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
* $Author: zblikai $
* $Id: lib_goods.php 15595 2009-02-13 07:26:20Z zblikai $
*/
if (!defined('IN_ECS'))
{
die('Hacking attempt');
}
/**
* 取得推荐类型列表
* @return array 推荐类型列表
*/
function get_intro_list()
{
return array(
'is_best' => $GLOBALS['_LANG']['is_best'],
'is_new' => $GLOBALS['_LANG']['is_new'],
'is_hot' => $GLOBALS['_LANG']['is_hot'],
'is_promote' => $GLOBALS['_LANG']['is_promote'],
'all_type' => $GLOBALS['_LANG']['all_type'],
);
}
/**
* 取得重量单位列表
* @return array 重量单位列表
*/
function get_unit_list()
{
return array(
'1' => $GLOBALS['_LANG']['unit_kg'],
'0.001' => $GLOBALS['_LANG']['unit_g'],
);
}
/**
* 取得会员等级列表
* @return array 会员等级列表
*/
function get_user_rank_list()
{
$sql = "SELECT * FROM " . $GLOBALS['ecs']->table('user_rank') .
" ORDER BY min_points";
return $GLOBALS['db']->getAll($sql);
}
/**
* 取得某商品的会员价格列表
* @param int $goods_id 商品编号
* @return array 会员价格列表 user_rank => user_price
*/
function get_member_price_list($goods_id)
{
/* 取得会员价格 */
$price_list = array();
$sql = "SELECT user_rank, user_price FROM " .
$GLOBALS['ecs']->table('member_price') .
" WHERE goods_id = '$goods_id'";
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
$price_list[$row['user_rank']] = $row['user_price'];
}
return $price_list;
}
/**
* 插入或更新商品属性
* @param int $goods_id 商品编号
* @param array $id_list 属性编号数组
* @param array $is_spec_list 是否规格数组 'true' | 'false'
* @param array $value_price_list 属性值数组
*/
function handle_goods_attr($goods_id, $id_list, $is_spec_list, $value_price_list)
{
/* 循环处理每个属性 */
foreach ($id_list AS $key => $id)
{
$is_spec = $is_spec_list[$key];
if ($is_spec == 'false')
{
$value = $value_price_list[$key];
$price = '';
}
else
{
$value_list = array();
$price_list = array();
if ($value_price_list[$key])
{
$vp_list = explode(chr(13), $value_price_list[$key]);
foreach ($vp_list AS $v_p)
{
$arr = explode(chr(9), $v_p);
$value_list[] = $arr[0];
$price_list[] = $arr[1];
}
}
$value = join(chr(13), $value_list);
$price = join(chr(13), $price_list);
}
// 插入或更新记录
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('goods_attr') . " WHERE goods_id = '$goods_id' AND attr_id = '$id'";
if ($GLOBALS['db']->getOne($sql) > 0)
{
$sql = "UPDATE " . $GLOBALS['ecs']->table('goods_attr') . " SET " .
"attr_value = '$value', " .
"attr_price = '$price' " .
"WHERE goods_id = '$goods_id' " .
"AND attr_id = '$id' LIMIT 1";
}
else
{
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_attr') . " (goods_id, attr_id, attr_value, attr_price) " .
"VALUES ('$goods_id', '$id', '$value', '$price')";
}
$GLOBALS['db']->query($sql);
}
}
/**
* 保存某商品的会员价格
* @param int $goods_id 商品编号
* @param array $rank_list 等级列表
* @param array $price_list 价格列表
* @return void
*/
function handle_member_price($goods_id, $rank_list, $price_list)
{
/* 循环处理每个会员等级 */
foreach ($rank_list AS $key => $rank)
{
/* 会员等级对应的价格 */
$price = $price_list[$key];
// 插入或更新记录
$sql = "SELECT COUNT(*) FROM " . $GLOBALS['ecs']->table('member_price') .
" WHERE goods_id = '$goods_id' AND user_rank = '$rank'";
if ($GLOBALS['db']->getOne($sql) > 0)
{
/* 如果会员价格是小于0则删除原来价格，不是则更新为新的价格 */
if ($price < 0)
{
$sql = "DELETE FROM " . $GLOBALS['ecs']->table('member_price') .
" WHERE goods_id = '$goods_id' AND user_rank = '$rank' LIMIT 1";
}
else
{
$sql = "UPDATE " . $GLOBALS['ecs']->table('member_price') .
" SET user_price = '$price' " .
"WHERE goods_id = '$goods_id' " .
"AND user_rank = '$rank' LIMIT 1";
}
}
else
{
if ($price == -1)
{
$sql = '';
}
else
{
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('member_price') . " (goods_id, user_rank, user_price) " .
"VALUES ('$goods_id', '$rank', '$price')";
}
}
if ($sql)
{
$GLOBALS['db']->query($sql);
}
}
}
/**
* 保存某商品的扩展分类
* @param int $goods_id 商品编号
* @param array $cat_list 分类编号数组
* @return void
*/
function handle_other_cat($goods_id, $cat_list)
{
/* 查询现有的扩展分类 */
$sql = "SELECT cat_id FROM " . $GLOBALS['ecs']->table('goods_cat') .
" WHERE goods_id = '$goods_id'";
$exist_list = $GLOBALS['db']->getCol($sql);
/* 删除不再有的分类 */
$delete_list = array_diff($exist_list, $cat_list);
if ($delete_list)
{
$sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods_cat') .
" WHERE goods_id = '$goods_id' " .
"AND cat_id " . db_create_in($delete_list);
$GLOBALS['db']->query($sql);
}
/* 添加新加的分类 */
$add_list = array_diff($cat_list, $exist_list, array(0));
foreach ($add_list AS $cat_id)
{
// 插入记录
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_cat') .
" (goods_id, cat_id) " .
"VALUES ('$goods_id', '$cat_id')";
$GLOBALS['db']->query($sql);
}
}
/**
* 保存某商品的关联商品
* @param int $goods_id
* @return void
*/
function handle_link_goods($goods_id)
{
$sql = "UPDATE " . $GLOBALS['ecs']->table('link_goods') . " SET " .
" goods_id = '$goods_id' " .
" WHERE goods_id = '0'" .
" AND admin_id = '$_SESSION[admin_id]'";
$GLOBALS['db']->query($sql);
$sql = "UPDATE " . $GLOBALS['ecs']->table('link_goods') . " SET " .
" link_goods_id = '$goods_id' " .
" WHERE link_goods_id = '0'" .
" AND admin_id = '$_SESSION[admin_id]'";
$GLOBALS['db']->query($sql);
}
/**
* 保存某商品的配件
* @param int $goods_id
* @return void
*/
function handle_group_goods($goods_id)
{
$sql = "UPDATE " . $GLOBALS['ecs']->table('group_goods') . " SET " .
" parent_id = '$goods_id' " .
" WHERE parent_id = '0'" .
" AND admin_id = '$_SESSION[admin_id]'";
$GLOBALS['db']->query($sql);
}
/**
* 保存某商品的关联文章
* @param int $goods_id
* @return void
*/
function handle_goods_article($goods_id)
{
$sql = "UPDATE " . $GLOBALS['ecs']->table('goods_article') . " SET " .
" goods_id = '$goods_id' " .
" WHERE goods_id = '0'" .
" AND admin_id = '$_SESSION[admin_id]'";
$GLOBALS['db']->query($sql);
}
/**
* 保存某商品的相册图片
* @param int $goods_id
* @param array $image_files
* @param array $image_descs
* @return void
*/
function handle_gallery_image($goods_id, $image_files, $image_descs)
{
/* 是否处理缩略图 */
$proc_thumb = (isset($GLOBALS['shop_id']) && $GLOBALS['shop_id'] > 0)? false : true;
foreach ($image_descs AS $key => $img_desc)
{
/* 是否成功上传 */
$flag = false;
if (isset($image_files['error']))
{
if ($image_files['error'][$key] == 0)
{
$flag = true;
}
}
else
{
if ($image_files['tmp_name'][$key] != 'none')
{
$flag = true;
}
}
if ($flag)
{
// 生成缩略图
if ($proc_thumb)
{
$thumb_url = $GLOBALS['image']->make_thumb($image_files['tmp_name'][$key], $GLOBALS['_CFG']['thumb_width'], $GLOBALS['_CFG']['thumb_height']);
$thumb_url = is_string($thumb_url) ? $thumb_url : '';
}
$upload = array(
'name' => $image_files['name'][$key],
'type' => $image_files['type'][$key],
'tmp_name' => $image_files['tmp_name'][$key],
'size' => $image_files['size'][$key],
);
if (isset($image_files['error']))
{
$upload['error'] = $image_files['error'][$key];
}
$img_original = $GLOBALS['image']->upload_image($upload);
if ($img_original === false)
{
sys_msg($GLOBALS['image']->error_msg(), 1, array(), false);
}
$img_url = $img_original;
if (!$proc_thumb)
{
$thumb_url = $img_original;
}
// 如果服务器支持GD 则添加水印
if ($proc_thumb && gd_version() > 0)
{
$pos = strpos(basename($img_original), '.');
$newname = dirname($img_original) . '/' . $GLOBALS['image']->random_filename() . substr(basename($img_original), $pos);
copy('../' . $img_original, '../' . $newname);
$img_url = $newname;
$GLOBALS['image']->add_watermark('../'.$img_url,'',$GLOBALS['_CFG']['watermark'], $GLOBALS['_CFG']['watermark_place'], $GLOBALS['_CFG']['watermark_alpha']);
}
/* 重新格式化图片名称 */
$img_original = reformat_image_name('gallery', $goods_id, $img_original, 'source');
$img_url = reformat_image_name('gallery', $goods_id, $img_url, 'goods');
$thumb_url = reformat_image_name('gallery_thumb', $goods_id, $thumb_url, 'thumb');
$sql = "INSERT INTO " . $GLOBALS['ecs']->table('goods_gallery') . " (goods_id, img_url, img_desc, thumb_url, img_original) " .
"VALUES ('$goods_id', '$img_url', '$img_desc', '$thumb_url', '$img_original')";
$GLOBALS['db']->query($sql);
}
}
}
/**
* 修改商品某字段值
* @param string $goods_id 商品编号，可以为多个，用 ',' 隔开
* @param string $field 字段名
* @param string $value 字段值
* @return bool
*/
function update_goods($goods_id, $field, $value)
{
if ($goods_id)
{
/* 清除缓存 */
clear_cache_files();
$sql = "UPDATE " . $GLOBALS['ecs']->table('goods') .
" SET $field = '$value' , last_update = '". gmtime() ."' " .
"WHERE goods_id " . db_create_in($goods_id);
return $GLOBALS['db']->query($sql);
}
else
{
return false;
}
}
/**
* 从回收站删除多个商品
* @param mix $goods_id 商品id列表：可以逗号格开，也可以是数组
* @return void
*/
function delete_goods($goods_id)
{
if (empty($goods_id))
{
return;
}
/* 取得有效商品id */
$sql = "SELECT DISTINCT goods_id FROM " . $GLOBALS['ecs']->table('goods') .
" WHERE goods_id " . db_create_in($goods_id) . " AND is_delete = 1";
$goods_id = $GLOBALS['db']->getCol($sql);
if (empty($goods_id))
{
return;
}
/* 删除商品图片和轮播图片文件 */
$sql = "SELECT goods_thumb, goods_img, original_img " .
"FROM " . $GLOBALS['ecs']->table('goods') .
" WHERE goods_id " . db_create_in($goods_id);
$res = $GLOBALS['db']->query($sql);
while ($goods = $GLOBALS['db']->fetchRow($res))
{
if (!empty($goods['goods_thumb']))
{
@unlink('../' . $goods['goods_thumb']);
}
if (!empty($goods['goods_img']))
{
@unlink('../' . $goods['goods_img']);
}
if (!empty($goods['original_img']))
{
@unlink('../' . $goods['original_img']);
}
}
/* 删除商品 */
$sql = "DELETE FROM " . $GLOBALS['ecs']->table('goods') .
" WHERE goods_id " . db_create_in($goods_id);
$GLOBALS['db']->query($sql);
/* 删除商品相册的图片文件 */
$sql = "SELECT img_url, thumb_url, img_original " .
"FROM " . $GLOBALS['ecs']->table('goods_gallery') .
" WHERE goods_id " . db_create_in($goods_id);
$res = $GLOBALS['db']->query($sql);
while ($row = $GLOBALS['db']->fetchRow($res))
{
if (!empty($row['img_url']))
{
@unlink('../' . $row['img_url']);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -