二十一、线索转换4：创建交易

最新推荐文章于 2024-10-01 18:51:18 发布

小奶糕的笔记本

最新推荐文章于 2024-10-01 18:51:18 发布

阅读量60

点赞数

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

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

版权

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

31 篇文章 0 订阅

订阅专栏

文章描述了在系统中创建交易的流程，包括通过TranMapper插入交易记录，使用TranRemarkMapper批量插入交易备注。当创建交易时，从线索信息中获取备注，并将它们转换为交易备注，然后保存到数据库。整个过程涉及对象映射、ID生成、时间戳处理等。

摘要由CSDN通过智能技术生成

功能需求

6.创建交易，交易表添加记录

7.创建交易，线索的备注-->交易备注

流程图

代码实现

1.TranMapper

    /**
     * 增加交易
     */
    int insertTran(Tran tran);

  <insert id="insertTran">
    insert into tbl_tran (id, owner, money, name,
                          expected_date, customer_id, stage,
                          type, source, activity_id,
                          contacts_id, create_by, create_time,
                          edit_by, edit_time, description,
                          contact_summary, next_contact_time)
    values (#{id,jdbcType=CHAR}, #{owner,jdbcType=CHAR}, #{money,jdbcType=VARCHAR}, #{name,jdbcType=VARCHAR},
            #{expectedDate,jdbcType=CHAR}, #{customerId,jdbcType=CHAR}, #{stage,jdbcType=VARCHAR},
            #{type,jdbcType=VARCHAR}, #{source,jdbcType=VARCHAR}, #{activityId,jdbcType=CHAR},
            #{contactsId,jdbcType=CHAR}, #{createBy,jdbcType=VARCHAR}, #{createTime,jdbcType=CHAR},
            #{editBy,jdbcType=VARCHAR}, #{editTime,jdbcType=CHAR}, #{description,jdbcType=VARCHAR},
            #{contactSummary,jdbcType=VARCHAR}, #{nextContactTime,jdbcType=CHAR})
  </insert>

2.TranRemarkMapper

    /**
     * 批量增加交易备注
     */
    int insertTranRemarkByList(List<TranRemark> tranRemarkList);

  <insert id="insertTranRemarkByList">
    insert into tbl_tran_remark (id, note_content, create_by,
                                 create_time, edit_by, edit_time,
                                 edit_flag, tran_id)
    values
    <foreach collection="list" separator="," item="obj">
      (#{obj.id,jdbcType=CHAR}, #{obj.noteContent,jdbcType=VARCHAR}, #{obj.createBy,jdbcType=VARCHAR},
      #{obj.createTime,jdbcType=CHAR}, #{obj.editBy,jdbcType=VARCHAR}, #{obj.editTime,jdbcType=CHAR},
      #{obj.editFlag,jdbcType=CHAR}, #{obj.tranId,jdbcType=CHAR})
    </foreach>
  </insert>

3.ClueService

		if ("true".equals(isCreateTran)){
			Tran tran = new Tran();
			tran.setDescription(clue.getDescription());
			tran.setContactSummary(clue.getContactSummary());
			tran.setNextContactTime(clue.getNextContactTime());
			tran.setMoney((String) map.get("money"));
			tran.setName((String) map.get("name"));
			tran.setExpectedDate((String) map.get("expectedDate"));
			tran.setStage((String) map.get("stage"));
			tran.setActivityId((String) map.get("activityId"));
			tran.setContactsId(contacts.getId());
			tran.setCustomerId(customer.getId());
			tran.setCreateBy(user.getId());
			tran.setCreateTime(DateUtils.formateDateTime(new Date()));
			tran.setId(UUIDUtils.getUUID());
			tran.setOwner(clue.getOwner());
			tranMapper.insertTran(tran);
			//.线索评论--交易评论
			if (clueRemarkList != null && clueRemarkList.size() > 0) {
				TranRemark tranRemark = null;
				List<TranRemark> tranRemarkList = new ArrayList<>();
				for (ClueRemark clueRemark:clueRemarkList) {
					tranRemark = new TranRemark();
					tranRemark.setId(UUIDUtils.getUUID());
					tranRemark.setNoteContent(clueRemark.getNoteContent());
					tranRemark.setCreateBy(clueRemark.getCreateBy());
					tranRemark.setCreateTime(clueRemark.getCreateTime());
					tranRemark.setEditBy(clueRemark.getEditBy());
					tranRemark.setEditTime(clueRemark.getEditTime());
					tranRemark.setEditFlag(clueRemark.getEditFlag());
					tranRemark.setTranId(tran.getId());
					tranRemarkList.add(tranRemark);
				}
				tranRemarkMapper.insertTranRemarkByList(tranRemarkList);

			}
		}