ECSHop 商品列表中商品彻底删除

最新推荐文章于 2021-04-09 12:14:30 发布

浅夏渐至

最新推荐文章于 2021-04-09 12:14:30 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： ecshop 功能修改文章标签： ECShop 商品删除

本文链接：https://blog.youkuaiyun.com/qq_35032024/article/details/82153188

ecshop 功能修改专栏收录该内容

8 篇文章

订阅专栏

博客介绍了ECShop商品删除的代码修改方法。一是在文件名\\goods.php中查找“删除操作”并修改相关代码；二是将文件名\\admin\\templates\\goods_list.htm中的商品删除按钮进行更改。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、文件名\goods.php中查找“删除操作”，将下面的代码改为
/—————————————————— /
//– 删除操作
/—————————————————— /

elseif ( $_REQUEST[‘act’] == ‘del’) {$ goods_id = empty( $_REQUEST[‘goods_id’])? ” : trim($ _REQUEST[‘goods_id’]);
$sql = “SELECT goods_id, goods_name, is_delete, is_real, goods_thumb, ” . “goods_img, original_img ” . “FROM ” .$ ecs->table(‘goods’) .
” WHERE goods_id = ‘ $goods_id’”;$ goods = $db->getRow($ sql);

/* 删除商品图片 */
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 " . $ecs->table('goods') . " WHERE goods_id='" . $goods_id . "'";
$db->query($sql);

/* 删除商品的货品记录 */
$sql = "DELETE FROM " . $ecs->table('products') .
        " WHERE goods_id = '$goods_id'";
$db->query($sql);

/* 记录日志 */
admin_log(addslashes($goods['goods_name']), 'remove', 'goods');

/* 删除商品相册 */
$sql = "SELECT img_url, thumb_url, img_original " .
        "FROM " . $ecs->table('goods_gallery') .
        " WHERE goods_id = '$goods_id'";
$res = $db->query($sql);
while ($row = $db->fetchRow($res))
{
    if (!empty($row['img_url']))
    {
        @unlink('../' . $row['img_url']);
    }
    if (!empty($row['thumb_url']))
    {
        @unlink('../' . $row['thumb_url']);
    }
    if (!empty($row['img_original']))
    {
        @unlink('../' . $row['img_original']);
    }
}

$sql = "DELETE FROM " . $ecs->table('goods_gallery') . " WHERE goods_id = '$goods_id'";
$db->query($sql);

/* 删除相关表记录 */
$sql = "DELETE FROM " . $ecs->table('collect_goods') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('goods_article') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('goods_attr') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('goods_cat') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('member_price') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('group_goods') . " WHERE parent_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('group_goods') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('link_goods') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('link_goods') . " WHERE link_goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('tag') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('comment') . " WHERE comment_type = 0 AND id_value = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('collect_goods') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('booking_goods') . " WHERE goods_id = '$goods_id'";
$db->query($sql);
$sql = "DELETE FROM " . $ecs->table('goods_activity') . " WHERE goods_id = '$goods_id'";
$db->query($sql);

/* 如果不是实体商品，删除相应虚拟商品记录 */
if ($goods['is_real'] != 1)
{
    $sql = "DELETE FROM " . $ecs->table('virtual_card') . " WHERE goods_id = '$goods_id'";
    if (!$db->query($sql, 'SILENT') && $db->errno() != 1146)
    {
        die($db->error());
    }
}

clear_cache_files();
$link[] = array('href' => 'goods.php?act=list', 'text' =>'商品列表');
sys_msg('商品成功删除！', 0, $link);

}

2、文件名\admin\templates\goods_list.htm 中商品删除按钮改为