二十六：交易详细信息

最新推荐文章于 2024-07-21 22:27:18 发布

小奶糕的笔记本

最新推荐文章于 2024-07-21 22:27:18 发布

阅读量361

点赞数

分类专栏：项目crm管理系统文章标签： java

本文链接：https://blog.csdn.net/jbkjhji/article/details/130713016

版权

项目crm管理系统专栏收录该内容

31 篇文章 0 订阅

订阅专栏

功能需求

用户在交易主页面，点击交易名称超级链接，跳转到交易明细页面，完成查看交易明细的功能。

*显示交易的基本信息

*显示交易的备注信息

*显示交易的历史信息

*显示交易的阶段图标信息

流程图

后端代码实现

1.tran

TranMapper

    /**
     * 根据id查询详细信息
     */
    Tran selectTranFortranId(String tranId);

    <select id="selectTranFortranId" resultMap="BaseResultMap">
        select t.id,u.name owner,t.money,t.name,t.expected_date,c.name as customer_id,dic1.value stage,dic2.value type,dic3.value source,
               a.name activity_id,co.fullname contacts_id,t.description,t.contact_summary,t.next_contact_time,
               u2.name create_by,t.create_time,u3.name edit_by,t.edit_time
        from tbl_tran t
                 join tbl_user u on t.owner = u.id
                 left join tbl_user u2 on t.create_by = u2.id
                 left join tbl_user u3 on t.edit_by = u3.id
                 left join tbl_dic_value dic1 on t.stage = dic1.id
                 left join tbl_dic_value dic2 on t.type = dic2.id
                 left join tbl_dic_value dic3 on t.source = dic3.id
                 left join tbl_activity a on t.activity_id=a.id
                 left join tbl_contacts co on t.contacts_id=co.id
                 left join tbl_customer c on t.customer_id = c.id
        where t.id=#{tranId}
    </select>

TranService

	/**
	 * 详细信息：根据id
	 */
	Tran queryTranFortranId(String tranId);

	@Override
	public Tran queryTranFortranId(String tranId) {
		return tranMapper.selectTranFortranId(tranId);
	}

2.tranRemarkList

TranRemarkMapper

    /**
     * 根据交易id查询交易评论
     */
    List<TranRemark> selectTranHistoryForTranid(String tranId);

    <!--   List<TranRemark> selectTranHistoryForTranid(String tranId);-->
    <select id="selectTranHistoryForTranid" resultMap="BaseResultMap">
        select tr.id,
               tr.note_content,
               tr.create_time,
               u1.name as create_by,
               tr.edit_time,
               u2.name as edit_by,
               tr.edit_flag
        from tbl_tran_remark tr
                 join tbl_user u1 on tr.create_by = u1.id
                 left join tbl_user u2 on tr.edit_by = u2.id
        where tr.tran_id = #{tranId}
    </select>

TranRemarkService

	/**
	 * 根据交易id查询交易评论
	 */
	List<TranRemark> queryTranHistoryForTranid(String tranId);

@Service
public class TranRemarkServiceImpl implements TranRemarkService {
	@Autowired
	private TranRemarkMapper tranRemarkMapper;
	@Override
	public List<TranRemark> queryTranHistoryForTranid(String tranId) {
		return tranRemarkMapper.selectTranHistoryForTranid(tranId);
	}
}

3.tranHistoryList

TranHistoryMapper

    /**
     * 根据交易id查询阶段历史
     */
    List<TranHistory> selectTranHistoryForTranid(String tranId);

    <select id="selectTranHistoryForTranid" resultMap="BaseResultMap">
        select th.id, dic1.value stage, th.money, th.expected_date, th.create_time, u.name create_by
        from tbl_tran_history th
                 left join tbl_user u on th.create_by = u.id
                 left join tbl_dic_value dic1 on th.stage = dic1.id
        where th.tran_id = #{tranId}
    </select>

TranHistoryService

	/**
	 * 根据交易id查询阶段历史
	 */
	List<TranHistory> queryTranHistoryForTranid(String tranId);

@Service
public class TranHistoryServiceImpl implements TranHistoryService {
	@Autowired
	private TranHistoryMapper tranHistoryMapper;
	@Override
	public List<TranHistory> queryTranHistoryForTranid(String tranId) {
		return tranHistoryMapper.selectTranHistoryForTranid(tranId);
	}
}

4.stageList

DicValueMapper

    /**
     * 根据type-code查询字典
     */
    List<DicValue> selectDicValueByTypeCode(String typeCode);

    <!--     List<DicValue> queryDicValueByTypeCode(String typeCode); -->
    <select id="selectDicValueByTypeCode" resultMap="BaseResultMap">
        select
        <include refid="Base_Column_List"></include>
        from tbl_dic_value
        where type_code=#{typeCode}
        order by order_no asc
    </select>

DicValueService

	/**
	 * 根据typecode查询字典
	 */
	List<DicValue> queryDicValueByTypeCode(String typeCode);

	@Autowired
	private DicValueMapper dicValueMapper;
	@Override
	public List<DicValue> queryDicValueByTypeCode(String typeCode) {
		return dicValueMapper.selectDicValueByTypeCode(typeCode);
	}

5.nowStageNo