/**
*
* Copyright (c) 2014, the Railo Company Ltd. All rights reserved.
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License as published by the Free Software Foundation; either
* version 2.1 of the License, or (at your option) any later version.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library. If not, see <http://www.gnu.org/licenses/>.
*
**/
/**
* Implements the CFML Function querysetcell
*/
package lucee.runtime.functions.query;
import lucee.runtime.PageContext;
import lucee.runtime.exp.FunctionException;
import lucee.runtime.exp.PageException;
import lucee.runtime.ext.function.BIF;
import lucee.runtime.op.Caster;
import lucee.runtime.type.Collection;
import lucee.runtime.type.Query;
import lucee.runtime.type.QueryImpl;
import lucee.runtime.type.Struct;
import lucee.runtime.type.StructImpl;
import lucee.runtime.type.util.KeyConstants;
public final class QueryConvertForGrid extends BIF {
private static final long serialVersionUID = 871091293736619034L;
public static Struct call(PageContext pc , Query src, double dpage,double dpageSize) throws PageException {
int page=(int) dpage;
int pageSize=(int) dpageSize;
if(page<1) {
throw new FunctionException(pc,"QueryConvertForGrid",2,"page","page must be a positive number now ("+page+")");
}
int start = ((page-1)*pageSize)+1;
int end = start+pageSize;
Collection.Key[] srcColumns = src.getColumnNames();
int srcRows = src.getRowCount();
int trgRows = srcRows-start+1;
if (trgRows > pageSize) trgRows = pageSize;
if(trgRows<0)trgRows=0;
Query trg=new QueryImpl(srcColumns,trgRows,src.getName());
int trgRow=0;
for (int srcRow = start; (srcRow <= end) && (srcRow <= srcRows); srcRow++) {
trgRow++;
for (int col = 0; col < srcColumns.length; col++){
trg.setAtEL(
srcColumns[col],
trgRow,
src.getAt(srcColumns[col],srcRow, null));
}
}
Struct sct = new StructImpl();
sct.setEL(KeyConstants._QUERY, trg);
sct.setEL("TOTALROWCOUNT", new Integer(srcRows));
return sct;
}
@Override
public Object invoke(PageContext pc, Object[] args) throws PageException {
return call(pc,Caster.toQuery(args[0]),Caster.toDoubleValue(args[1]),Caster.toDoubleValue(args[2]));
}
}