package com.yami.trading.service.trader.impl;
|
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.yami.trading.bean.trader.domain.TraderUser;
|
import com.yami.trading.dao.trader.TraderUserMapper;
|
import com.yami.trading.service.trader.AdminTraderUserService;
|
import org.springframework.stereotype.Service;
|
|
import javax.annotation.Resource;
|
import java.util.List;
|
import java.util.Map;
|
|
@Service
|
public class AdminTraderUserServiceImpl implements AdminTraderUserService {
|
|
@Resource
|
private TraderUserMapper traderUserMapper;
|
|
@Override
|
public void save(TraderUser entity) {
|
traderUserMapper.insert(entity);
|
// ApplicationUtil.executeSaveOrUpdate(entity);
|
|
}
|
|
@Override
|
public void update(TraderUser entity) {
|
traderUserMapper.updateById(entity);
|
// ApplicationUtil.executeUpdate(entity);
|
|
}
|
|
public List<TraderUser> findByPartyId(String partyId) {
|
List<TraderUser> traderUsers = traderUserMapper.selectList(Wrappers.<TraderUser>lambdaQuery().eq(TraderUser::getPartyId, partyId));
|
return traderUsers;
|
// StringBuffer queryString = new StringBuffer(" where PARTY_ID=?");
|
// List<TraderUser> list = ApplicationUtil.executeSelect(TraderUser.class, queryString.toString(), new Object[] { partyId });
|
// if (list.size() > 0) {
|
// return list;
|
// }
|
// return null;
|
}
|
|
// public List<TraderUser> findByTraderPartyId(String trader_partyId) {
|
// StringBuffer queryString = new StringBuffer(" FROM TraderUser where PARTY_ID=?");
|
// List<TraderUser> list = ApplicationUtil.executeSelect(TraderUser.class, queryString.toString(), new Object[] { trader_partyId });
|
// if (list.size() > 0) {
|
// return list;
|
// }
|
// return null;
|
// }
|
|
public TraderUser findById(String id) {
|
TraderUser traderUser = traderUserMapper.selectById(id);
|
// return ApplicationUtil.executeGet(id, TraderUser.class);
|
return traderUser;
|
}
|
|
@Override
|
public void delete(String id) {
|
// TraderUser entity = findById(id);
|
// if (entity != null) {
|
// ApplicationUtil.executeDelete(entity);
|
// }
|
traderUserMapper.deleteById(id);
|
}
|
|
public Page pagedQuery(Page page, String name, String username) {
|
// StringBuffer queryString = new StringBuffer(" SELECT trader_user.NAME name,"
|
// + " party.USERNAME username,party.USERCODE usercode,party.ROLENAME rolename,"
|
// + " trader_user.UUID id,trader_user.PROFIT profit ,trader_user.AMOUNT_SUM amount_sum,"
|
// + " DATE_FORMAT(trader_user.CREATE_TIME, '%Y-%m-%d %H:%i:%S') create_time ");
|
// queryString.append(" FROM T_TRADER_USER trader_user ");
|
// queryString.append(" LEFT JOIN PAT_PARTY party ON party.UUID = trader_user.PARTY_ID ");
|
// queryString.append(" WHERE 1 = 1 ");
|
//
|
// Map<String, Object> parameters = new HashMap();
|
// if (StringUtils.isNotEmpty(name)) {
|
// queryString.append(" AND T_TRADER_USER.NAME =:name ");
|
// parameters.put("name", name);
|
// }
|
// if (StringUtils.isNotEmpty(username)) {
|
// queryString.append("AND (party.USERNAME like:username OR party.USERCODE like:username ) ");
|
// parameters.put("username", "%" + username + "%");
|
// }
|
//
|
// queryString.append(" order by trader_user.CREATE_TIME desc ");
|
List<Map<String, Object>> datas = traderUserMapper.listDatas((page.getCurrent() - 1) * page.getSize(), page.getSize(), name, username);
|
page.setRecords(datas);
|
return page;
|
}
|
|
}
|
