呼呼哈哈自用0412

package com.xxxx.crm.query;
import com.xxxx.crm.base.BaseQuery;
/**
* 营销机会管理多条件查询条件
*/
public class SaleChanceQuery extends BaseQuery {
private String customerName; // 客户名称
private String createMan; // 创建人
private String state; // 分配状态
/* 省略 get | set 方法 */
}

<select id="selectByParams" parameterType="com.xxxx.crm.query.SaleChanceQuery"
resultType="com.xxxx.crm.vo.SaleChance">
select
<include refid="Base_Column_List" />
from
t_sale_chance s
<where>
s.is_valid = 1
<if test="customerName != null and customerName != ''">
and s.customer_name like concat('%',#{customerName},'%')
</if>
<if test="createMan != null and createMan != ''">
and s.create_man = #{createMan}
</if>
<if test="state != null and state != ''">
and s.state = #{state}
</if>
</where>
</select>

public interface SaleChanceMapper extends BaseMapper<SaleChance,Integer> {
/*
由于考虑到多个模块均涉及多条件查询
这里对于多条件分页查询方法由父接口BaseMapper定义
*/
}

@Service
public class SaleChanceService extends BaseService<SaleChance, Integer> {
@Resource
private SaleChangeMapper saleChangeMapper;
/**
* 多条件分页查询营销机会 (BaseService 中有对应的方法)
* @param query
* @return
*/
public Map<String, Object> querySaleChanceByParams (SaleChanceQuery query) {
Map<String, Object> map = new HashMap<>();
PageHelper.startPage(query.getPage(), query.getLimit());
PageInfo<SaleChance> pageInfo =
new PageInfo<>(saleChangeMapper.selectByParams(query));
map.put("code",0);
map.put("msg", "success");
map.put("count", pageInfo.getTotal());
map.put("data", pageInfo.getList());
return map;
}
}

@Controller
@RequestMapping("sale_chance")
public class SaleChanceController extends BaseController {
@Resource
private SaleChanceService saleChanceService;
/**
* 多条件分页查询营销机会
* @param query
* @return
*/
@RequestMapping("list")
@ResponseBody
public Map<String, Object> querySaleChanceByParams (SaleChanceQuery query) {
return saleChanceService.querySaleChanceByParams(query);
}
}

/**
* 营销机会数据更新
*/
@Transactional(propagation = Propagation.REQUIRED)
public void updateSaleChance (SaleChance saleChance) {
// 1.参数校验
// 通过id查询记录
SaleChance temp = saleChanceMapper.selectByPrimaryKey(saleChance.getId());
// 判断是否为空
AssertUtil.isTrue(null == temp, "待更新记录不存在！");
// 校验基础参数
checkParams(saleChance.getCustomerName(), saleChance.getLinkMan(),
saleChance.getLinkPhone());
// 2. 设置相关参数值
saleChance.setUpdateDate(new Date());
if (StringUtils.isBlank(temp.getAssignMan())
&& StringUtils.isNotBlank(saleChance.getAssignMan())) {
// 如果原始记录未分配，修改后改为已分配
saleChance.setState(StateStatus.STATED.getType());
saleChance.setAssignTime(new Date());
saleChance.setDevResult(DevResult.DEVING.getStatus());
} else if (StringUtils.isNotBlank(temp.getAssignMan())
&& StringUtils.isBlank(saleChance.getAssignMan())) {
// 如果原始记录已分配，修改后改为未分配
saleChance.setAssignMan("");
saleChance.setState(StateStatus.UNSTATE.getType());
saleChance.setAssignTime(null);
saleChance.setDevResult(DevResult.UNDEV.getStatus());
}
// 3.执行更新 判断结果
AssertUtil.isTrue(saleChanceMapper.updateByPrimaryKeySelective(saleChance) <
1, "营销机会数据更新失败！");
}