package com.smartor.service.impl; import com.smartor.mapper.UtilsMapper; import com.smartor.service.IServiceTelInfoService; import lombok.extern.slf4j.Slf4j; import org.apache.commons.lang3.ObjectUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import java.util.List; import java.util.Map; @Slf4j @Service public class ServiceTelInfoServiceImpl implements IServiceTelInfoService { @Autowired private UtilsMapper utilsMapper; /** * 设置电话状态 * * @return 结果 */ @Override public List> getList(String orgid) { String where=" where (state=0 OR DATE_ADD(editTime, INTERVAL 10 MINUTE)< NOW()) "; if(ObjectUtils.isNotEmpty(orgid)) where=where+" and orgid='"+orgid+"'"; List> lists= utilsMapper.getList("select * from service_telinfo " +where); return lists; } /** * 设置电话状态 * * @param id 主键 * @param state 0正常1占线 * @return 结果 */ @Override public int setState(Integer id, Integer state) { Integer result= utilsMapper.updateSql("update service_telinfo set state= "+state+" where id="+id+" "); return result; } }