基礎(chǔ) sql 定義
<sql id="selectConfigDevicePartsFittings">
SELECT cd.amount
FROM config_dpf cd
left join device_parts_fitting dpf on cd.dpf_id = dpf.id
where cd.cdp_id = ${cdpId}
and dpf.type = ${type}
and cd.is_deleted = '0'
and dpf.is_deleted = '0'
</sql>
注意：這里傳值使用了${cdpId}盛嘿，使用 # 會(huì)報(bào)錯(cuò)
sql 復(fù)用
SELECT c.config_name,
-- c.project_name,
dp.type,
dp.name,
dp.description as dpDescription,
dp.volume,
dp.size,
dp.price,
dp.discount,
dp.sale_price,
dp.unit,
dp.width,
dp.deep,
dp.height,
dp.brand_id,
ifnull(total_price, 0) + ifnull(copper_price, 0) as summary,
(
<include refid="selectConfigDevicePartsFittings">
<property name="cdpId" value="t.id"/>
<property name="type" value="1"/>
</include>
) as padlock,
(
<include refid="selectConfigDevicePartsFittings">
<property name="cdpId" value="t.id"/>
<property name="type" value="2"/>
</include>
) as interlock,
(
<include refid="selectConfigDevicePartsFittings">
<property name="cdpId" value="t.id"/>
<property name="type" value="3"/>
</include>
) as shuntTrip,
t.*
FROM config_device_parts t
left join config c on t.config_id = c.id
left join device_parts dp on t.device_parts_id = dp.id
where t.config_id = #{configId} and t.is_deleted = '0'
order by t.update_time desc
