BMallDao.java

package com.viontech.keliu.dao;

import com.viontech.keliu.entity.BMall;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;

import jakarta.annotation.Resource;
import java.util.List;

/**
 * Created with IntelliJ IDEA.
 */
@Repository
public class BMallDao {

    @Resource
    private JdbcTemplate jdbcTemplate;

    /**
     * 查询门店
     * @param mallId
     * @return
     */
    public BMall getMallById(Long mallId) {
        String sql = "select id,name,parent_id,unid,status,external_id,group_id from b_mall where id = ?;";
        List<BMall> list = jdbcTemplate.query(sql, new BeanPropertyRowMapper<>(BMall.class), mallId);
        if (list == null || list.size() == 0) {
            return null;
        }
        return list.get(0);
    }

    /**
     * 查询场所下的门店
     * @param locationMallId
     * @return
     */
    public List<Long> getMallByLocationMallId(Long locationMallId) {
        String sql = "select id from b_mall where parent_id = ?;";
        return jdbcTemplate.queryForList(sql, Long.class, locationMallId);
    }

    /**
     * 查询门店的出入口通道id
     * @param storeId
     * @return
     */
    public List<Long> getStoreInOutChannelIds(Long storeId) {
        String sql = "SELECT channel_id FROM r_mall_gate WHERE mall_id = ? and is_mall_gate = 1 and in_out = 1;";
        return jdbcTemplate.queryForList(sql, Long.class, storeId);
    }
}