}
$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;
}
} else {
${'var_idx2_argument'} = NULL;
}
if (${'var_idx2_argument'} !== null) {
${'var_idx2_argument'}->setColumnType('number');
}
if (isset($args->eid)) {
${'eid3_argument'} = new ConditionArgument('eid', $args->eid, 'equal');
${'eid3_argument'}->createConditionValue();
if (!${'eid3_argument'}->isValid()) {
return ${'eid3_argument'}->getErrorMessage();
}
} else {
${'eid3_argument'} = NULL;
}
if (${'eid3_argument'} !== null) {
${'eid3_argument'}->setColumnType('varchar');
}
${'sort_index4_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index4_argument'}->ensureDefaultValue('var_idx');
if (!${'sort_index4_argument'}->isValid()) {
return ${'sort_index4_argument'}->getErrorMessage();
}
$query->setColumns(array(new SelectExpression('`module_srl`', '`module_srl`'), new SelectExpression('`var_idx`', '`idx`'), new SelectExpression('`eid`', '`eid`')));
$query->setTables(array(new Table('`xe_document_extra_vars`', '`document_extra_vars`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl1_argument, "equal"), new ConditionWithArgument('`var_idx`', $var_idx2_argument, "notin", 'and'), new ConditionWithArgument('`eid`', $eid3_argument, "equal", 'and')))));
$query->setGroups(array('`module_srl`', '`var_idx`', '`eid`'));
$query->setOrder(array(new OrderByColumn(${'sort_index4_argument'}, "asc")));
$query->setLimit();
return $query;
<?php
if (!defined('__XE__')) {
exit;
}
$query = new Query();
$query->setQueryId("getModuleSkinDotList");
$query->setAction("select");
$query->setPriority("");
${'skin21_argument'} = new ConditionArgument('skin', $args->skin, 'like');
${'skin21_argument'}->ensureDefaultValue('.');
${'skin21_argument'}->createConditionValue();
if (!${'skin21_argument'}->isValid()) {
return ${'skin21_argument'}->getErrorMessage();
}
if (${'skin21_argument'} !== null) {
${'skin21_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new SelectExpression('`module`'), new SelectExpression('`skin`')));
$query->setTables(array(new Table('`xe_modules`', '`modules`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`skin`', $skin21_argument, "like")))));
$query->setGroups(array('`skin`'));
$query->setOrder(array());
$query->setLimit();
return $query;
<?php
if (!defined('__XE__')) {
exit;
}
$query = new Query();
$query->setQueryId("getModuleListByInstance");
$query->setAction("select");
$query->setPriority("");
if (isset($args->site_srl)) {
${'site_srl5_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
${'site_srl5_argument'}->checkFilter('number');
${'site_srl5_argument'}->createConditionValue();
if (!${'site_srl5_argument'}->isValid()) {
return ${'site_srl5_argument'}->getErrorMessage();
}
} else {
${'site_srl5_argument'} = NULL;
}
if (${'site_srl5_argument'} !== null) {
${'site_srl5_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression(), new SelectExpression('count(`module_srl`)', '`instanceCount`')));
$query->setTables(array(new Table('`xe_modules`', '`modules`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`site_srl`', $site_srl5_argument, "equal")))));
$query->setGroups(array('`module`'));
$query->setOrder(array());
$query->setLimit();
return $query;