具有删除客户的规则如下
角色 | 规则 |
---|---|
业务员 | 可以删除自己维护的没有订单记录的客户 |
操作员 | 可以删除自己维护的没有订单记录的客户 |
管理员 | 不能删除客户信息 |
删除成功~
SELECT customer_id,count(1) num
FROM t_order
GROUP BY customer_id
SELECT t1.customer_id
,t1.customer_name
,t1.address
,t1.c_sex
,t1.email
,t1.base_id
,t1.id_card
,t1.mobile_phone
,t1.order_id
,t1.remark
,t1.user_id
,t2.user_name
,t2.real_name
,t3.base_name
,ifnull(t4.num,0) num
from t_customer t1
left join t_user t2
on t1.user_id = t2.user_id
left join t_basicdata t3
on t1.base_id = t3.base_id
left join v_customer_order_num t4
on t1.customer_id = t4.customer_id
<shiro:hasAnyRoles name="业务员,操作员">
<c:if test="${dto.orderNum eq 0 }">
<a href="javascript:void(0)" onclick="deleteUser(${dto.customer.customerId})"
class="tablelink"> 删除</a></td>
</c:if>
</shiro:hasAnyRoles>
// .......
function deleteUser(userId){
if(window.confirm("确定要删除该用户吗?")){
location.href="/customer/delete?id="+userId;
}
}
@RequestMapping("/delete")
public String delete(Integer id) throws IOException{
customerService.deleteCustomer(id);
return "customer/query";
}
public void deleteCustomer(Integer id);
@Override
public void deleteCustomer(Integer id) {
// TODO Auto-generated method stub
customerMapper.deleteByPrimaryKey(id);
}