package project.blockchain.internal;

import java.util.HashMap;
import java.util.Map;

import kernel.util.StringUtils;
import kernel.web.Page;
import kernel.web.PagedQueryDao;
import org.springframework.stereotype.Service;
import project.blockchain.AdminChannelBlockchainService;

@Service
public class AdminChannelBlockchainServiceImpl implements AdminChannelBlockchainService {
	
	private PagedQueryDao pagedQueryDao;

	public Page pagedQuery(int pageNo, int pageSize, String name_para, String coin_para) {
		StringBuffer queryString = new StringBuffer(
				" SELECT channelblockchain.UUID id,channelblockchain.BLOCKCHAIN_NAME blockchain_name,"
						+ "channelblockchain.IMG img ,channelblockchain.COIN coin,  "
						+ " channelblockchain.ADDRESS address ");

		queryString.append(" FROM T_CHANNEL_BLOCKCHAIN channelblockchain WHERE 1 = 1 ");
		Map<String, Object> parameters = new HashMap<>();
		if (!StringUtils.isNullOrEmpty(name_para)) {
			queryString.append(" and  channelblockchain.BLOCKCHAIN_NAME like :name ");
			parameters.put("name", "%" + name_para + "%");
		}
		if (!StringUtils.isNullOrEmpty(coin_para)) {
			queryString.append(" and  channelblockchain.COIN like :coin ");
			parameters.put("coin", "%" + coin_para + "%");
		}
		Page page = this.pagedQueryDao.pagedQuerySQL(pageNo, pageSize, queryString.toString(), parameters);
		return page;
	}

	public void setPagedQueryDao(PagedQueryDao pagedQueryDao) {
		this.pagedQueryDao = pagedQueryDao;
	}
}