Ecshop二次开发实现多店铺功能的架构设计与实现

CREATE TABLE `ecs_shop` (
  `shop_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop_name` varchar(255) NOT NULL,
  `shop_owner` varchar(255) NOT NULL,
  `shop_status` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `ecs_shop_category` (
  `category_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `shop_id` int(10) unsigned NOT NULL,
  `category_name` varchar(255) NOT NULL,
  PRIMARY KEY (`category_id`),
  KEY `shop_id` (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

// 商品列表页筛选店铺
$shop_id = isset($_GET['shop_id']) ? intval($_GET['shop_id']) : 0;
$sql = "SELECT * FROM ecs_goods WHERE shop_id = '$shop_id'";

// 订单管理关联店铺
$order_id = isset($_GET['order_id']) ? intval($_GET['order_id']) : 0;
$sql = "SELECT o.*, s.shop_name FROM ecs_order_info o 
        LEFT JOIN ecs_shop s ON o.shop_id = s.shop_id 
        WHERE o.order_id = '$order_id'";

<!-- 店铺列表页 -->
<div class="shop-list">
    <?php foreach ($shops as $shop): ?>
        <div class="shop-item">
            <h3><?php echo $shop['shop_name']; ?></h3>
            <p>店主：<?php echo $shop['shop_owner']; ?></p>
            <a href="shop_detail.php?shop_id=<?php echo $shop['shop_id']; ?>">进入店铺</a>
        </div>
    <?php endforeach; ?>
</div>

<!-- 店铺详情页 -->
<div class="shop-detail">
    <h2><?php echo $shop['shop_name']; ?></h2>
    <p>店主：<?php echo $shop['shop_owner']; ?></p>
    <div class="shop-categories">
        <?php foreach ($categories as $category): ?>
            <a href="shop_goods.php?shop_id=<?php echo $shop['shop_id']; ?>&category_id=<?php echo $category['category_id']; ?>">
                <?php echo $category['category_name']; ?>
            </a>
        <?php endforeach; ?>
    </div>
</div>