public static function getList($parameters = array())
{
$query = new Query(static::getEntity());
if (isset($parameters['select'])) {
$query->setSelect($parameters['select']);
} else {
$query->setSelect(array('*'));
}
if (isset($parameters['filter'])) {
$query->setFilter($parameters['filter']);
}
if (isset($parameters['group'])) {
$query->setGroup($parameters['group']);
}
if (isset($parameters['order'])) {
$query->setOrder($parameters['order']);
}
if (isset($parameters['limit'])) {
$query->setLimit($parameters['limit']);
}
if (isset($parameters['offset'])) {
$query->setOffset($parameters['offset']);
}
if (isset($parameters['count_total'])) {
$query->countTotal($parameters['count_total']);
}
if (isset($parameters['options'])) {
$query->setOptions($parameters['options']);
}
if (isset($parameters['runtime'])) {
foreach ($parameters['runtime'] as $name => $fieldInfo) {
$query->registerRuntimeField($name, $fieldInfo);
}
}
if (isset($parameters['data_doubling'])) {
$parameters['data_doubling'] ? $query->enableDataDoubling() : $query->disableDataDoubling();
}
return $query->exec();
// return array?
}
}
$query = new Query();
$query->setQueryId("insertPoint");
$query->setAction("insert");
$query->setPriority("");
${'member_srl249_argument'} = new Argument('member_srl', $args->{'member_srl'});
${'member_srl249_argument'}->checkFilter('number');
${'member_srl249_argument'}->checkNotNull();
if (!${'member_srl249_argument'}->isValid()) {
return ${'member_srl249_argument'}->getErrorMessage();
}
if (${'member_srl249_argument'} !== null) {
${'member_srl249_argument'}->setColumnType('number');
}
${'point250_argument'} = new Argument('point', $args->{'point'});
${'point250_argument'}->checkFilter('number');
${'point250_argument'}->ensureDefaultValue('0');
${'point250_argument'}->checkNotNull();
if (!${'point250_argument'}->isValid()) {
return ${'point250_argument'}->getErrorMessage();
}
if (${'point250_argument'} !== null) {
${'point250_argument'}->setColumnType('number');
}
$query->setColumns(array(new InsertExpression('`member_srl`', ${'member_srl249_argument'}), new InsertExpression('`point`', ${'point250_argument'})));
$query->setTables(array(new Table('`xe_point`', '`point`')));
$query->setConditions(array());
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;
if (!defined('__XE__')) {
exit;
}
$query = new Query();
$query->setQueryId("getModuleCategories");
$query->setAction("select");
$query->setPriority("");
if (isset($args->moduleCategorySrl)) {
${'moduleCategorySrl2_argument'} = new ConditionArgument('moduleCategorySrl', $args->moduleCategorySrl, 'in');
${'moduleCategorySrl2_argument'}->createConditionValue();
if (!${'moduleCategorySrl2_argument'}->isValid()) {
return ${'moduleCategorySrl2_argument'}->getErrorMessage();
}
} else {
${'moduleCategorySrl2_argument'} = NULL;
}
if (${'moduleCategorySrl2_argument'} !== null) {
${'moduleCategorySrl2_argument'}->setColumnType('number');
}
${'sort_index3_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index3_argument'}->ensureDefaultValue('title');
if (!${'sort_index3_argument'}->isValid()) {
return ${'sort_index3_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_module_categories`', '`module_categories`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_category_srl`', $moduleCategorySrl2_argument, "in")))));
$query->setGroups(array());
$query->setOrder(array(new OrderByColumn(${'sort_index3_argument'}, "asc")));
$query->setLimit();
return $query;
$query->setAction("select");
$query->setPriority("");
if (isset($args->site_srl)) {
${'site_srl28_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
${'site_srl28_argument'}->createConditionValue();
if (!${'site_srl28_argument'}->isValid()) {
return ${'site_srl28_argument'}->getErrorMessage();
}
} else {
${'site_srl28_argument'} = NULL;
}
if (${'site_srl28_argument'} !== null) {
${'site_srl28_argument'}->setColumnType('number');
}
${'sort_index29_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index29_argument'}->ensureDefaultValue('list_order');
if (!${'sort_index29_argument'}->isValid()) {
return ${'sort_index29_argument'}->getErrorMessage();
}
${'order_type30_argument'} = new SortArgument('order_type30', $args->order_type);
${'order_type30_argument'}->ensureDefaultValue('asc');
if (!${'order_type30_argument'}->isValid()) {
return ${'order_type30_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_member_group`', '`member_group`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`site_srl`', $site_srl28_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array(new OrderByColumn(${'sort_index29_argument'}, $order_type30_argument)));
$query->setLimit();
return $query;
<?php
if (!defined('__XE__')) {
exit;
}
$query = new Query();
$query->setQueryId("getSiteAddons");
$query->setAction("select");
$query->setPriority("");
${'site_srl110_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
${'site_srl110_argument'}->checkNotNull();
${'site_srl110_argument'}->createConditionValue();
if (!${'site_srl110_argument'}->isValid()) {
return ${'site_srl110_argument'}->getErrorMessage();
}
if (${'site_srl110_argument'} !== null) {
${'site_srl110_argument'}->setColumnType('number');
}
${'list_order111_argument'} = new Argument('list_order', $args->{'list_order'});
${'list_order111_argument'}->ensureDefaultValue('addon');
if (!${'list_order111_argument'}->isValid()) {
return ${'list_order111_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_addons_site`', '`addons_site`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`site_srl`', $site_srl110_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array(new OrderByColumn(${'list_order111_argument'}, "asc")));
$query->setLimit();
return $query;
${'page56_argument'}->ensureDefaultValue('1');
if (!${'page56_argument'}->isValid()) {
return ${'page56_argument'}->getErrorMessage();
}
${'page_count57_argument'} = new Argument('page_count', $args->{'page_count'});
${'page_count57_argument'}->ensureDefaultValue('10');
if (!${'page_count57_argument'}->isValid()) {
return ${'page_count57_argument'}->getErrorMessage();
}
${'list_count58_argument'} = new Argument('list_count', $args->{'list_count'});
${'list_count58_argument'}->ensureDefaultValue('20');
if (!${'list_count58_argument'}->isValid()) {
return ${'list_count58_argument'}->getErrorMessage();
}
${'sort_index54_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index54_argument'}->ensureDefaultValue('list_order');
if (!${'sort_index54_argument'}->isValid()) {
return ${'sort_index54_argument'}->getErrorMessage();
}
${'sort_order55_argument'} = new SortArgument('sort_order55', $args->sort_order);
${'sort_order55_argument'}->ensureDefaultValue('asc');
if (!${'sort_order55_argument'}->isValid()) {
return ${'sort_order55_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_member`', '`member`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`is_admin`', $is_admin38_argument, "equal"), new ConditionWithArgument('`denied`', $is_denied39_argument, "equal", 'and'), new ConditionWithArgument('`member_srl`', $member_srls40_argument, "in", 'and'))), new ConditionGroup(array(new ConditionWithArgument('`user_id`', $s_user_id41_argument, "like"), new ConditionWithArgument('`user_name`', $s_user_name42_argument, "like", 'or'), new ConditionWithArgument('`nick_name`', $s_nick_name43_argument, "like", 'or'), new ConditionWithArgument('`nick_name`', $html_nick_name44_argument, "like", 'or'), new ConditionWithArgument('`email_address`', $s_email_address45_argument, "like", 'or'), new ConditionWithArgument('`birthday`', $s_birthday46_argument, "like", 'or'), new ConditionWithArgument('`extra_vars`', $s_extra_vars47_argument, "like", 'or'), new ConditionWithArgument('`regdate`', $s_regdate48_argument, "like_prefix", 'or'), new ConditionWithArgument('`last_login`', $s_last_login49_argument, "like_prefix", 'or'), new ConditionWithArgument('`member`.`regdate`', $s_regdate_more50_argument, "more", 'or'), new ConditionWithArgument('`member`.`regdate`', $s_regdate_less51_argument, "less", 'or'), new ConditionWithArgument('`member`.`last_login`', $s_last_login_more52_argument, "more", 'or'), new ConditionWithArgument('`member`.`last_login`', $s_last_login_less53_argument, "less", 'or')), 'and')));
$query->setGroups(array());
$query->setOrder(array(new OrderByColumn(${'sort_index54_argument'}, $sort_order55_argument)));
$query->setLimit(new Limit(${'list_count58_argument'}, ${'page56_argument'}, ${'page_count57_argument'}));
return $query;
