package com.yami.trading.service.finance.service.impl;
|
|
import java.util.List;
|
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
|
import com.yami.trading.service.finance.service.AdminFinanceOrderService;
|
import com.yami.trading.bean.finance.FinanceOrder;
|
import com.yami.trading.common.util.StringUtils;
|
import com.yami.trading.dao.finance.FinanceOrderMapper;
|
import com.yami.trading.service.user.UserRecomService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
@Service
|
@Transactional
|
public class AdminFinanceOrderServiceImpl extends ServiceImpl<FinanceOrderMapper, FinanceOrder> implements AdminFinanceOrderService {
|
// private PagedQueryDao pagedQueryDao;
|
@Autowired
|
private UserRecomService userRecomService;
|
|
public Page pagedQuery(int pageNo, int pageSize, String name_para, String finance_para, String status_para,
|
List<String> children, String orderNo, String rolename_para , String createTime , String closeTime) {
|
|
// Map<String, Object> parameters = new HashMap<>();
|
// StringBuffer queryString = new StringBuffer(
|
// " SELECT financeOrder.UUID id,financeOrder.ORDER_NO order_no ,financeOrder.FINANCE_ID financeId , ");
|
// queryString.append(" financeOrder.AMOUNT amount,financeOrder.CREATE_TIME create_time, ");
|
// queryString.append(" financeOrder.CLOSE_TIME close_time,financeOrder.PROFIT profit, ");
|
// queryString.append(" financeOrder.STATE state, ");
|
// queryString.append(" party.user_name username,party.user_code usercode,party.role_name rolename, ");
|
// queryString.append(" finance.NAME finance_name,finance.NAME_EN finance_name_en, ");
|
// queryString.append(" finance.NAME_KN finance_name_kn,finance.NAME_JN finance_name_jn ");
|
// queryString.append(" FROM T_FINANCE_ORDER financeOrder ");
|
// queryString.append(" LEFT JOIN party ON financeOrder.PARTY_ID = party.UUID ");
|
// queryString.append(" LEFT JOIN T_FINANCE finance ON finance.UUID = financeOrder.FINANCE_ID ");
|
//
|
// queryString.append(" WHERE 1 = 1 ");
|
// if (!StringUtils.isNullOrEmpty(partyId)) {
|
// queryString.append(" and financeOrder.PARTY_ID in (:partyId) ");
|
// parameters.put("partyId", children);
|
// }
|
//
|
// if (!StringUtils.isNullOrEmpty(finance_para)) {
|
// queryString.append(
|
// " and (finance.NAME=:finance_para or finance.NAME_EN =:finance_para or finance.NAME_CN =:finance_para) ");
|
// parameters.put("finance_para", finance_para);
|
// }
|
//
|
// if (!StringUtils.isNullOrEmpty(name_para)) {
|
// queryString.append("AND (party.user_name like:username OR party.user_code like:username ) ");
|
// parameters.put("username", "%" + name_para + "%");
|
// }
|
// if (!StringUtils.isNullOrEmpty(status_para)) {
|
// queryString.append(" and financeOrder.STATE =:status_para ");
|
// parameters.put("status_para", status_para);
|
// }
|
// if (!StringUtils.isNullOrEmpty(orderNo)) {
|
// queryString.append(" and financeOrder.ORDER_NO = :orderNo ");
|
// parameters.put("orderNo", orderNo);
|
//
|
// }
|
// if (!StringUtils.isNullOrEmpty(rolename_para)) {
|
// queryString.append(" and party.role_name =:rolename");
|
// parameters.put("rolename", rolename_para);
|
// }
|
//
|
// queryString.append(" order by financeOrder.CREATE_TIME desc ");
|
|
// Page page = null;
|
// Page page = this.pagedQueryDao.pagedQuerySQL(pageNo, pageSize, queryString.toString(), parameters);
|
// return page;
|
|
Page page=new Page(pageNo,pageSize);
|
return baseMapper.pagedQuery1(page,name_para,finance_para,status_para, children, orderNo, rolename_para , createTime , closeTime);
|
|
}
|
|
|
}
|
