/**
* Returns a slice of the resultset to show in the pagination
*/
PHP_METHOD(Phalcon_Paginator_Adapter_QueryBuilder, getPaginate) {
zval *_4$$8;
zval *originalBuilder = NULL, *builder = NULL, *totalBuilder = NULL, *totalPages = NULL, *limit = NULL, *number = NULL, *query = NULL, *page = NULL, *items = NULL, *totalQuery = NULL, *result = NULL, *row = NULL, *rowcount = NULL, *next = NULL, *_0, *_1 = NULL, *groups = NULL, *_6, _7, _8, *_9, *groupColumn$$8 = NULL, *_2$$8 = NULL, *_3$$8, *_5$$8;
int ZEPHIR_LAST_CALL_STATUS, numberPage = 0, before = 0;
ZEPHIR_MM_GROW();
ZEPHIR_OBS_VAR(originalBuilder);
zephir_read_property_this(&originalBuilder, this_ptr, SL("_builder"), PH_NOISY_CC);
ZEPHIR_INIT_VAR(builder);
if (zephir_clone(builder, originalBuilder TSRMLS_CC) == FAILURE) {
RETURN_MM();
}
ZEPHIR_INIT_VAR(totalBuilder);
if (zephir_clone(totalBuilder, builder TSRMLS_CC) == FAILURE) {
RETURN_MM();
}
ZEPHIR_OBS_VAR(limit);
zephir_read_property_this(&limit, this_ptr, SL("_limitRows"), PH_NOISY_CC);
ZEPHIR_OBS_VAR(_0);
zephir_read_property_this(&_0, this_ptr, SL("_page"), PH_NOISY_CC);
numberPage = zephir_get_intval(_0);
if (!(numberPage)) {
numberPage = 1;
}
ZEPHIR_INIT_VAR(number);
ZVAL_LONG(number, (zephir_get_numberval(limit) * ((numberPage - 1))));
if (ZEPHIR_LT(number, limit)) {
ZEPHIR_CALL_METHOD(NULL, builder, "limit", NULL, 0, limit);
zephir_check_call_status();
} else {
ZEPHIR_CALL_METHOD(NULL, builder, "limit", NULL, 0, limit, number);
zephir_check_call_status();
}
ZEPHIR_CALL_METHOD(&query, builder, "getquery", NULL, 0);
zephir_check_call_status();
if (numberPage == 1) {
before = 1;
} else {
before = (numberPage - 1);
}
ZEPHIR_CALL_METHOD(&items, query, "execute", NULL, 0);
zephir_check_call_status();
ZEPHIR_INIT_VAR(_1);
ZVAL_STRING(_1, "COUNT(*) [rowcount]", ZEPHIR_TEMP_PARAM_COPY);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "columns", NULL, 0, _1);
zephir_check_temp_parameter(_1);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&groups, totalBuilder, "getgroupby", NULL, 0);
zephir_check_call_status();
if (!(ZEPHIR_IS_EMPTY(groups))) {
if (Z_TYPE_P(groups) == IS_ARRAY) {
ZEPHIR_INIT_VAR(groupColumn$$8);
zephir_fast_join_str(groupColumn$$8, SL(", "), groups TSRMLS_CC);
} else {
ZEPHIR_CPY_WRT(groupColumn$$8, groups);
}
ZEPHIR_INIT_VAR(_3$$8);
ZVAL_NULL(_3$$8);
ZEPHIR_CALL_METHOD(&_2$$8, totalBuilder, "groupby", NULL, 0, _3$$8);
zephir_check_call_status();
ZEPHIR_INIT_VAR(_4$$8);
zephir_create_array(_4$$8, 1, 0 TSRMLS_CC);
ZEPHIR_INIT_VAR(_5$$8);
ZEPHIR_CONCAT_SVS(_5$$8, "COUNT(DISTINCT ", groupColumn$$8, ") AS rowcount");
zephir_array_fast_append(_4$$8, _5$$8);
ZEPHIR_CALL_METHOD(NULL, _2$$8, "columns", NULL, 0, _4$$8);
zephir_check_call_status();
}
ZEPHIR_INIT_NVAR(_1);
ZVAL_NULL(_1);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "orderby", NULL, 0, _1);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&totalQuery, totalBuilder, "getquery", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&result, totalQuery, "execute", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&row, result, "getfirst", NULL, 0);
zephir_check_call_status();
if (zephir_is_true(row)) {
ZEPHIR_OBS_VAR(_6);
zephir_read_property(&_6, row, SL("rowcount"), PH_NOISY_CC);
ZEPHIR_INIT_VAR(rowcount);
ZVAL_LONG(rowcount, zephir_get_intval(_6));
} else {
ZEPHIR_INIT_NVAR(rowcount);
ZVAL_LONG(rowcount, 0);
}
ZEPHIR_SINIT_VAR(_7);
div_function(&_7, rowcount, limit TSRMLS_CC);
ZEPHIR_SINIT_VAR(_8);
ZVAL_DOUBLE(&_8, zephir_ceil(&_7 TSRMLS_CC));
ZEPHIR_INIT_VAR(totalPages);
ZVAL_LONG(totalPages, zephir_get_intval(&_8));
if (ZEPHIR_GT_LONG(totalPages, numberPage)) {
ZEPHIR_INIT_VAR(next);
ZVAL_LONG(next, (numberPage + 1));
} else {
ZEPHIR_CPY_WRT(next, totalPages);
}
ZEPHIR_INIT_VAR(page);
object_init(page);
zephir_update_property_zval(page, SL("items"), items TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_9);
ZVAL_LONG(_9, 1);
zephir_update_property_zval(page, SL("first"), _9 TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_9);
ZVAL_LONG(_9, before);
zephir_update_property_zval(page, SL("before"), _9 TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_9);
ZVAL_LONG(_9, numberPage);
zephir_update_property_zval(page, SL("current"), _9 TSRMLS_CC);
zephir_update_property_zval(page, SL("last"), totalPages TSRMLS_CC);
zephir_update_property_zval(page, SL("next"), next TSRMLS_CC);
zephir_update_property_zval(page, SL("total_pages"), totalPages TSRMLS_CC);
zephir_update_property_zval(page, SL("total_items"), rowcount TSRMLS_CC);
_9 = zephir_fetch_nproperty_this(this_ptr, SL("_limitRows"), PH_NOISY_CC);
zephir_update_property_zval(page, SL("limit"), _9 TSRMLS_CC);
RETURN_CCTOR(page);
}
/**
* Returns a slice of the resultset to show in the pagination
*/
PHP_METHOD(Phalcon_Paginator_Adapter_QueryBuilder, getPaginate) {
zval *_6$$14, *_8$$15;
zend_bool hasHaving = 0, hasGroup = 0, _2;
zval *originalBuilder = NULL, *builder = NULL, *totalBuilder = NULL, *totalPages = NULL, *limit = NULL, *number = NULL, *query = NULL, *page = NULL, *items = NULL, *totalQuery = NULL, *result = NULL, *row = NULL, *rowcount = NULL, *next = NULL, *sql = NULL, *columns = NULL, *db = NULL, *_0, *_1 = NULL, *groups = NULL, *_10, *_22, *_3$$10, *groupColumn$$11 = NULL, *_4$$14 = NULL, *_5$$14, *_7$$14, *_9$$15, *_11$$16 = NULL, *_12$$16 = NULL, *_13$$16, *_14$$16, *_15$$16, *_16$$16, _17$$16, _18$$16, *_19$$17, _20$$17, _21$$17;
zend_long ZEPHIR_LAST_CALL_STATUS, numberPage = 0, before = 0;
ZEPHIR_MM_GROW();
ZEPHIR_OBS_VAR(originalBuilder);
zephir_read_property_this(&originalBuilder, this_ptr, SL("_builder"), PH_NOISY_CC);
ZEPHIR_OBS_VAR(columns);
zephir_read_property_this(&columns, this_ptr, SL("_columns"), PH_NOISY_CC);
ZEPHIR_INIT_VAR(builder);
if (zephir_clone(builder, originalBuilder TSRMLS_CC) == FAILURE) {
RETURN_MM();
}
ZEPHIR_INIT_VAR(totalBuilder);
if (zephir_clone(totalBuilder, builder TSRMLS_CC) == FAILURE) {
RETURN_MM();
}
ZEPHIR_OBS_VAR(limit);
zephir_read_property_this(&limit, this_ptr, SL("_limitRows"), PH_NOISY_CC);
ZEPHIR_OBS_VAR(_0);
zephir_read_property_this(&_0, this_ptr, SL("_page"), PH_NOISY_CC);
numberPage = zephir_get_intval(_0);
if (!(numberPage)) {
numberPage = 1;
}
ZEPHIR_INIT_VAR(number);
ZVAL_LONG(number, (zephir_get_numberval(limit) * ((numberPage - 1))));
if (ZEPHIR_LT(number, limit)) {
ZEPHIR_CALL_METHOD(NULL, builder, "limit", NULL, 0, limit);
zephir_check_call_status();
} else {
ZEPHIR_CALL_METHOD(NULL, builder, "limit", NULL, 0, limit, number);
zephir_check_call_status();
}
ZEPHIR_CALL_METHOD(&query, builder, "getquery", NULL, 0);
zephir_check_call_status();
if (numberPage == 1) {
before = 1;
} else {
before = (numberPage - 1);
}
ZEPHIR_CALL_METHOD(&items, query, "execute", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&_1, totalBuilder, "gethaving", NULL, 0);
zephir_check_call_status();
hasHaving = !(ZEPHIR_IS_EMPTY(_1));
ZEPHIR_CALL_METHOD(&groups, totalBuilder, "getgroupby", NULL, 0);
zephir_check_call_status();
hasGroup = !(ZEPHIR_IS_EMPTY(groups));
_2 = hasHaving;
if (_2) {
_2 = !hasGroup;
}
if (_2) {
if (ZEPHIR_IS_EMPTY(columns)) {
ZEPHIR_THROW_EXCEPTION_DEBUG_STR(phalcon_paginator_exception_ce, "When having is set there should be columns option provided for which calculate row count", "phalcon/paginator/adapter/querybuilder.zep", 186);
return;
}
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "columns", NULL, 0, columns);
zephir_check_call_status();
} else {
ZEPHIR_INIT_VAR(_3$$10);
ZVAL_STRING(_3$$10, "COUNT(*) [rowcount]", ZEPHIR_TEMP_PARAM_COPY);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "columns", NULL, 0, _3$$10);
zephir_check_temp_parameter(_3$$10);
zephir_check_call_status();
}
if (hasGroup) {
if (Z_TYPE_P(groups) == IS_ARRAY) {
ZEPHIR_INIT_VAR(groupColumn$$11);
zephir_fast_join_str(groupColumn$$11, SL(", "), groups TSRMLS_CC);
} else {
ZEPHIR_CPY_WRT(groupColumn$$11, groups);
}
if (!(hasHaving)) {
ZEPHIR_INIT_VAR(_5$$14);
ZVAL_NULL(_5$$14);
ZEPHIR_CALL_METHOD(&_4$$14, totalBuilder, "groupby", NULL, 0, _5$$14);
zephir_check_call_status();
ZEPHIR_INIT_VAR(_6$$14);
zephir_create_array(_6$$14, 1, 0 TSRMLS_CC);
ZEPHIR_INIT_VAR(_7$$14);
ZEPHIR_CONCAT_SVS(_7$$14, "COUNT(DISTINCT ", groupColumn$$11, ") AS rowcount");
zephir_array_fast_append(_6$$14, _7$$14);
ZEPHIR_CALL_METHOD(NULL, _4$$14, "columns", NULL, 0, _6$$14);
zephir_check_call_status();
} else {
ZEPHIR_INIT_VAR(_8$$15);
zephir_create_array(_8$$15, 1, 0 TSRMLS_CC);
ZEPHIR_INIT_VAR(_9$$15);
ZEPHIR_CONCAT_SV(_9$$15, "DISTINCT ", groupColumn$$11);
zephir_array_fast_append(_8$$15, _9$$15);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "columns", NULL, 0, _8$$15);
zephir_check_call_status();
}
}
ZEPHIR_INIT_VAR(_10);
ZVAL_NULL(_10);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "orderby", NULL, 0, _10);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&totalQuery, totalBuilder, "getquery", NULL, 0);
zephir_check_call_status();
ZEPHIR_INIT_VAR(rowcount);
if (hasHaving) {
ZEPHIR_CALL_METHOD(&sql, totalQuery, "getsql", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&_11$$16, totalBuilder, "getdi", NULL, 0);
zephir_check_call_status();
ZEPHIR_INIT_VAR(_12$$16);
ZVAL_STRING(_12$$16, "db", ZEPHIR_TEMP_PARAM_COPY);
ZEPHIR_CALL_METHOD(&db, _11$$16, "get", NULL, 0, _12$$16);
zephir_check_temp_parameter(_12$$16);
zephir_check_call_status();
zephir_array_fetch_string(&_13$$16, sql, SL("sql"), PH_NOISY | PH_READONLY, "phalcon/paginator/adapter/querybuilder.zep", 228 TSRMLS_CC);
ZEPHIR_INIT_VAR(_14$$16);
ZEPHIR_CONCAT_SVS(_14$$16, "SELECT COUNT(*) as rowcount FROM (", _13$$16, ") as T1");
zephir_array_fetch_string(&_15$$16, sql, SL("bind"), PH_NOISY | PH_READONLY, "phalcon/paginator/adapter/querybuilder.zep", 228 TSRMLS_CC);
ZEPHIR_INIT_NVAR(_12$$16);
ZVAL_LONG(_12$$16, 2);
ZEPHIR_CALL_METHOD(&row, db, "fetchone", NULL, 0, _14$$16, _12$$16, _15$$16);
zephir_check_call_status();
if (zephir_is_true(row)) {
zephir_array_fetch_string(&_16$$16, row, SL("rowcount"), PH_NOISY | PH_READONLY, "phalcon/paginator/adapter/querybuilder.zep", 229 TSRMLS_CC);
ZVAL_LONG(rowcount, zephir_get_intval(_16$$16));
} else {
ZVAL_LONG(rowcount, 0);
}
ZEPHIR_SINIT_VAR(_17$$16);
div_function(&_17$$16, rowcount, limit TSRMLS_CC);
ZEPHIR_SINIT_VAR(_18$$16);
ZVAL_DOUBLE(&_18$$16, zephir_ceil(&_17$$16 TSRMLS_CC));
ZEPHIR_INIT_VAR(totalPages);
ZVAL_LONG(totalPages, zephir_get_intval(&_18$$16));
} else {
ZEPHIR_CALL_METHOD(&result, totalQuery, "execute", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&row, result, "getfirst", NULL, 0);
zephir_check_call_status();
if (zephir_is_true(row)) {
ZEPHIR_OBS_VAR(_19$$17);
zephir_read_property(&_19$$17, row, SL("rowcount"), PH_NOISY_CC);
ZEPHIR_INIT_NVAR(rowcount);
ZVAL_LONG(rowcount, zephir_get_intval(_19$$17));
} else {
ZEPHIR_INIT_NVAR(rowcount);
ZVAL_LONG(rowcount, 0);
}
ZEPHIR_SINIT_VAR(_20$$17);
div_function(&_20$$17, rowcount, limit TSRMLS_CC);
ZEPHIR_SINIT_VAR(_21$$17);
ZVAL_DOUBLE(&_21$$17, zephir_ceil(&_20$$17 TSRMLS_CC));
ZEPHIR_INIT_NVAR(totalPages);
ZVAL_LONG(totalPages, zephir_get_intval(&_21$$17));
}
if (ZEPHIR_GT_LONG(totalPages, numberPage)) {
ZEPHIR_INIT_VAR(next);
ZVAL_LONG(next, (numberPage + 1));
} else {
ZEPHIR_CPY_WRT(next, totalPages);
}
ZEPHIR_INIT_VAR(page);
object_init(page);
zephir_update_property_zval(page, SL("items"), items TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_22);
ZVAL_LONG(_22, 1);
zephir_update_property_zval(page, SL("first"), _22 TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_22);
ZVAL_LONG(_22, before);
zephir_update_property_zval(page, SL("before"), _22 TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_22);
ZVAL_LONG(_22, numberPage);
zephir_update_property_zval(page, SL("current"), _22 TSRMLS_CC);
zephir_update_property_zval(page, SL("last"), totalPages TSRMLS_CC);
zephir_update_property_zval(page, SL("next"), next TSRMLS_CC);
zephir_update_property_zval(page, SL("total_pages"), totalPages TSRMLS_CC);
zephir_update_property_zval(page, SL("total_items"), rowcount TSRMLS_CC);
_22 = zephir_fetch_nproperty_this(this_ptr, SL("_limitRows"), PH_NOISY_CC);
zephir_update_property_zval(page, SL("limit"), _22 TSRMLS_CC);
RETURN_CCTOR(page);
}
/**
* Returns a slice of the resultset to show in the pagination
*/
PHP_METHOD(Phalcon_Paginator_Adapter_QueryBuilder, getPaginate) {
int numberPage, before, ZEPHIR_LAST_CALL_STATUS;
zval *originalBuilder, *builder, *totalBuilder, *totalPages, *limit, *number, *query = NULL, *page, *items = NULL, *totalQuery = NULL, *result = NULL, *row = NULL, *rowcount, *next = NULL, *_0, *_1 = NULL, *_2, _3, _4, *_5;
ZEPHIR_MM_GROW();
ZEPHIR_OBS_VAR(originalBuilder);
zephir_read_property_this(&originalBuilder, this_ptr, SL("_builder"), PH_NOISY_CC);
ZEPHIR_INIT_VAR(builder);
if (zephir_clone(builder, originalBuilder TSRMLS_CC) == FAILURE) {
RETURN_MM();
}
ZEPHIR_INIT_VAR(totalBuilder);
if (zephir_clone(totalBuilder, builder TSRMLS_CC) == FAILURE) {
RETURN_MM();
}
ZEPHIR_OBS_VAR(limit);
zephir_read_property_this(&limit, this_ptr, SL("_limitRows"), PH_NOISY_CC);
ZEPHIR_OBS_VAR(_0);
zephir_read_property_this(&_0, this_ptr, SL("_page"), PH_NOISY_CC);
numberPage = zephir_get_intval(_0);
if (!(numberPage)) {
numberPage = 1;
}
ZEPHIR_INIT_VAR(number);
ZVAL_LONG(number, (zephir_get_numberval(limit) * ((numberPage - 1))));
if (ZEPHIR_LT(number, limit)) {
ZEPHIR_CALL_METHOD(NULL, builder, "limit", NULL, 0, limit);
zephir_check_call_status();
} else {
ZEPHIR_CALL_METHOD(NULL, builder, "limit", NULL, 0, limit, number);
zephir_check_call_status();
}
ZEPHIR_CALL_METHOD(&query, builder, "getquery", NULL, 0);
zephir_check_call_status();
if (numberPage == 1) {
before = 1;
} else {
before = (numberPage - 1);
}
ZEPHIR_CALL_METHOD(&items, query, "execute", NULL, 0);
zephir_check_call_status();
ZEPHIR_INIT_VAR(_1);
ZVAL_STRING(_1, "COUNT(*) [rowcount]", ZEPHIR_TEMP_PARAM_COPY);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "columns", NULL, 0, _1);
zephir_check_temp_parameter(_1);
zephir_check_call_status();
ZEPHIR_INIT_NVAR(_1);
ZVAL_NULL(_1);
ZEPHIR_CALL_METHOD(NULL, totalBuilder, "orderby", NULL, 0, _1);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&totalQuery, totalBuilder, "getquery", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&result, totalQuery, "execute", NULL, 0);
zephir_check_call_status();
ZEPHIR_CALL_METHOD(&row, result, "getfirst", NULL, 0);
zephir_check_call_status();
ZEPHIR_OBS_VAR(_2);
zephir_read_property(&_2, row, SL("rowcount"), PH_NOISY_CC);
ZEPHIR_INIT_VAR(rowcount);
ZVAL_LONG(rowcount, zephir_get_intval(_2));
ZEPHIR_SINIT_VAR(_3);
div_function(&_3, rowcount, limit TSRMLS_CC);
ZEPHIR_SINIT_VAR(_4);
ZVAL_DOUBLE(&_4, zephir_ceil(&_3 TSRMLS_CC));
ZEPHIR_INIT_VAR(totalPages);
ZVAL_LONG(totalPages, zephir_get_intval(&_4));
if (ZEPHIR_GT_LONG(totalPages, numberPage)) {
ZEPHIR_INIT_VAR(next);
ZVAL_LONG(next, (numberPage + 1));
} else {
ZEPHIR_CPY_WRT(next, totalPages);
}
ZEPHIR_INIT_VAR(page);
object_init(page);
zephir_update_property_zval(page, SL("items"), items TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_5);
ZVAL_LONG(_5, 1);
zephir_update_property_zval(page, SL("first"), _5 TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_5);
ZVAL_LONG(_5, before);
zephir_update_property_zval(page, SL("before"), _5 TSRMLS_CC);
ZEPHIR_INIT_ZVAL_NREF(_5);
ZVAL_LONG(_5, numberPage);
zephir_update_property_zval(page, SL("current"), _5 TSRMLS_CC);
zephir_update_property_zval(page, SL("last"), totalPages TSRMLS_CC);
zephir_update_property_zval(page, SL("next"), next TSRMLS_CC);
zephir_update_property_zval(page, SL("total_pages"), totalPages TSRMLS_CC);
zephir_update_property_zval(page, SL("total_items"), rowcount TSRMLS_CC);
_5 = zephir_fetch_nproperty_this(this_ptr, SL("_limitRows"), PH_NOISY_CC);
zephir_update_property_zval(page, SL("limit"), _5 TSRMLS_CC);
RETURN_CCTOR(page);
}
