| | |
|---|
| | | <select id="pageList" resultType="com.panzhihua.common.model.vos.community.warehouse.ComActWarehouseOperationVO"> |
|---|
| | | select t.*,t1.image,t1.item,t1.`name` as donateName,t2.actual_time,t2.apply_name,t2.reason,t1.is_anonymous,t2.goods_num,t2.receive_url as receiveUrl from com_act_warehouse_operation t LEFT JOIN com_act_warehouse_donates t1 on t.goods_id =t1.id LEFT JOIN com_act_warehouse_apply t2 on t.apply_id = t2.id |
|---|
| | | <where> |
|---|
| | | t.type = 2 and t.goods_id=#{commonPage.paramId} |
|---|
| | | t.type = 2 |
|---|
| | | <if test="commonPage.paramId != null"> |
|---|
| | | and t.goods_id=#{commonPage.paramId} |
|---|
| | | </if> |
|---|
| | | <if test="commonPage.keyword !=null and commonPage.keyword !=''"> |
|---|
| | | and t1.item like concat('%',#{commonPage.keyword},'%') |
|---|
| | | </if> |
|---|
| | | </where> |
|---|
| | | order by t.create_time desc |
|---|
| | | </select> |
|---|
