PHP Query::setQueryId Examples

Example #1

File: document.getCategoryList.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getCategoryList");
$query->setAction("select");
$query->setPriority("");
${'module_srl1_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal');
${'module_srl1_argument'}->checkFilter('number');
${'module_srl1_argument'}->checkNotNull();
${'module_srl1_argument'}->createConditionValue();
if (!${'module_srl1_argument'}->isValid()) {
    return ${'module_srl1_argument'}->getErrorMessage();
}
if (${'module_srl1_argument'} !== null) {
    ${'module_srl1_argument'}->setColumnType('number');
}
${'sort_index2_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index2_argument'}->ensureDefaultValue('list_order');
if (!${'sort_index2_argument'}->isValid()) {
    return ${'sort_index2_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_document_categories`', '`document_categories`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl1_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array(new OrderByColumn(${'sort_index2_argument'}, "asc")));
$query->setLimit();
return $query;

Example #2

File: module.getMidInfo.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getMidInfo");
$query->setAction("select");
$query->setPriority("");
if (isset($args->mid)) {
    ${'mid153_argument'} = new ConditionArgument('mid', $args->mid, 'equal');
    ${'mid153_argument'}->createConditionValue();
    if (!${'mid153_argument'}->isValid()) {
        return ${'mid153_argument'}->getErrorMessage();
    }
} else {
    ${'mid153_argument'} = NULL;
}
if (${'mid153_argument'} !== null) {
    ${'mid153_argument'}->setColumnType('varchar');
}
if (isset($args->module_srl)) {
    ${'module_srl154_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal');
    ${'module_srl154_argument'}->createConditionValue();
    if (!${'module_srl154_argument'}->isValid()) {
        return ${'module_srl154_argument'}->getErrorMessage();
    }
} else {
    ${'module_srl154_argument'} = NULL;
}
if (${'module_srl154_argument'} !== null) {

Example #3

File: module.getModuleCategories.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

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")));

Example #4

File: file.updateFileValid.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("updateFileValid");
$query->setAction("update");
$query->setPriority("");
${'isvalid246_argument'} = new Argument('isvalid', $args->{'isvalid'});
${'isvalid246_argument'}->ensureDefaultValue('Y');
${'isvalid246_argument'}->checkNotNull();
if (!${'isvalid246_argument'}->isValid()) {
    return ${'isvalid246_argument'}->getErrorMessage();
}
if (${'isvalid246_argument'} !== null) {
    ${'isvalid246_argument'}->setColumnType('char');
}
${'upload_target_srl247_argument'} = new ConditionArgument('upload_target_srl', $args->upload_target_srl, 'equal');
${'upload_target_srl247_argument'}->checkFilter('number');
${'upload_target_srl247_argument'}->checkNotNull();
${'upload_target_srl247_argument'}->createConditionValue();
if (!${'upload_target_srl247_argument'}->isValid()) {
    return ${'upload_target_srl247_argument'}->getErrorMessage();
}
if (${'upload_target_srl247_argument'} !== null) {
    ${'upload_target_srl247_argument'}->setColumnType('number');
}
$query->setColumns(array(new UpdateExpression('`isvalid`', ${'isvalid246_argument'})));
$query->setTables(array(new Table('`xe_files`', '`files`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`upload_target_srl`', $upload_target_srl247_argument, "equal")))));

Example #5

File: layout.insertLayout.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("insertLayout");
$query->setAction("insert");
$query->setPriority("");
${'layout_srl183_argument'} = new Argument('layout_srl', $args->{'layout_srl'});
${'layout_srl183_argument'}->checkFilter('number');
${'layout_srl183_argument'}->checkNotNull();
if (!${'layout_srl183_argument'}->isValid()) {
    return ${'layout_srl183_argument'}->getErrorMessage();
}
if (${'layout_srl183_argument'} !== null) {
    ${'layout_srl183_argument'}->setColumnType('number');
}
${'site_srl184_argument'} = new Argument('site_srl', $args->{'site_srl'});
${'site_srl184_argument'}->checkFilter('number');
${'site_srl184_argument'}->ensureDefaultValue('0');
${'site_srl184_argument'}->checkNotNull();
if (!${'site_srl184_argument'}->isValid()) {
    return ${'site_srl184_argument'}->getErrorMessage();
}
if (${'site_srl184_argument'} !== null) {
    ${'site_srl184_argument'}->setColumnType('number');
}
${'layout185_argument'} = new Argument('layout', $args->{'layout'});
${'layout185_argument'}->checkNotNull();
if (!${'layout185_argument'}->isValid()) {

Example #6

File: member.updateLastLogin.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("updateLastLogin");
$query->setAction("update");
$query->setPriority("");
${'member_srl96_argument'} = new Argument('member_srl', $args->{'member_srl'});
${'member_srl96_argument'}->checkFilter('number');
${'member_srl96_argument'}->checkNotNull();
if (!${'member_srl96_argument'}->isValid()) {
    return ${'member_srl96_argument'}->getErrorMessage();
}
if (${'member_srl96_argument'} !== null) {
    ${'member_srl96_argument'}->setColumnType('number');
}
${'last_login97_argument'} = new Argument('last_login', $args->{'last_login'});
${'last_login97_argument'}->ensureDefaultValue(date("YmdHis"));
${'last_login97_argument'}->checkNotNull();
if (!${'last_login97_argument'}->isValid()) {
    return ${'last_login97_argument'}->getErrorMessage();
}
if (${'last_login97_argument'} !== null) {
    ${'last_login97_argument'}->setColumnType('date');
}
${'member_srl98_argument'} = new ConditionArgument('member_srl', $args->member_srl, 'equal');
${'member_srl98_argument'}->checkFilter('number');
${'member_srl98_argument'}->checkNotNull();
${'member_srl98_argument'}->createConditionValue();

Example #7

File: member.insertDeniedID.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("insertGroup");
$query->setAction("insert");
$query->setPriority("");
${'user_id100_argument'} = new Argument('user_id', $args->{'user_id'});
${'user_id100_argument'}->checkNotNull();
if (!${'user_id100_argument'}->isValid()) {
    return ${'user_id100_argument'}->getErrorMessage();
}
if (${'user_id100_argument'} !== null) {
    ${'user_id100_argument'}->setColumnType('varchar');
}
${'regdate101_argument'} = new Argument('regdate', $args->{'regdate'});
${'regdate101_argument'}->ensureDefaultValue(date("YmdHis"));
if (!${'regdate101_argument'}->isValid()) {
    return ${'regdate101_argument'}->getErrorMessage();
}
if (${'regdate101_argument'} !== null) {
    ${'regdate101_argument'}->setColumnType('date');
}
${'description102_argument'} = new Argument('description', $args->{'description'});
${'description102_argument'}->ensureDefaultValue('');
if (!${'description102_argument'}->isValid()) {
    return ${'description102_argument'}->getErrorMessage();
}
if (${'description102_argument'} !== null) {

Example #8

File: autoinstall.getInstalledPackage.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getInstalledPackage");
$query->setAction("select");
$query->setPriority("");
${'package_srl3_argument'} = new ConditionArgument('package_srl', $args->package_srl, 'equal');
${'package_srl3_argument'}->checkFilter('number');
${'package_srl3_argument'}->checkNotNull();
${'package_srl3_argument'}->createConditionValue();
if (!${'package_srl3_argument'}->isValid()) {
    return ${'package_srl3_argument'}->getErrorMessage();
}
if (${'package_srl3_argument'} !== null) {
    ${'package_srl3_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_ai_installed_packages`', '`ai_installed_packages`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`package_srl`', $package_srl3_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #9

File: member.addScrapDocument.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("addScrapDocument");
$query->setAction("insert");
$query->setPriority("");
${'member_srl3_argument'} = new Argument('member_srl', $args->{'member_srl'});
${'member_srl3_argument'}->checkNotNull();
if (!${'member_srl3_argument'}->isValid()) {
    return ${'member_srl3_argument'}->getErrorMessage();
}
if (${'member_srl3_argument'} !== null) {
    ${'member_srl3_argument'}->setColumnType('number');
}
${'document_srl4_argument'} = new Argument('document_srl', $args->{'document_srl'});
${'document_srl4_argument'}->ensureDefaultValue('0');
if (!${'document_srl4_argument'}->isValid()) {
    return ${'document_srl4_argument'}->getErrorMessage();
}
if (${'document_srl4_argument'} !== null) {
    ${'document_srl4_argument'}->setColumnType('number');
}
if (isset($args->title)) {
    ${'title5_argument'} = new Argument('title', $args->{'title'});
    if (!${'title5_argument'}->isValid()) {
        return ${'title5_argument'}->getErrorMessage();
    }
} else {

Example #10

File: module.getModulesInfo.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getModulesInfo");
$query->setAction("select");
$query->setPriority("");
${'module_srls1_argument'} = new ConditionArgument('module_srls', $args->module_srls, 'in');
${'module_srls1_argument'}->checkNotNull();
${'module_srls1_argument'}->createConditionValue();
if (!${'module_srls1_argument'}->isValid()) {
    return ${'module_srls1_argument'}->getErrorMessage();
}
if (${'module_srls1_argument'} !== null) {
    ${'module_srls1_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_modules`', '`modules`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srls1_argument, "in")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #11

File: autoinstall.getLatestPackage.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getLatestPackage");
$query->setAction("select");
$query->setPriority("");
${'page4_argument'} = new Argument('page', $args->{'page'});
${'page4_argument'}->ensureDefaultValue('1');
if (!${'page4_argument'}->isValid()) {
    return ${'page4_argument'}->getErrorMessage();
}
${'page_count5_argument'} = new Argument('page_count', $args->{'page_count'});
${'page_count5_argument'}->ensureDefaultValue('10');
if (!${'page_count5_argument'}->isValid()) {
    return ${'page_count5_argument'}->getErrorMessage();
}
${'list_count6_argument'} = new Argument('list_count', $args->{'list_count'});
${'list_count6_argument'}->ensureDefaultValue('1');
if (!${'list_count6_argument'}->isValid()) {
    return ${'list_count6_argument'}->getErrorMessage();
}
${'sort_index3_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index3_argument'}->ensureDefaultValue('updatedate');
if (!${'sort_index3_argument'}->isValid()) {
    return ${'sort_index3_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_autoinstall_packages`', '`packages`')));

Example #12

File: tag.deleteTag.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("deleteTag");
$query->setAction("delete");
$query->setPriority("");
${'document_srl253_argument'} = new ConditionArgument('document_srl', $args->document_srl, 'equal');
${'document_srl253_argument'}->checkFilter('number');
${'document_srl253_argument'}->checkNotNull();
${'document_srl253_argument'}->createConditionValue();
if (!${'document_srl253_argument'}->isValid()) {
    return ${'document_srl253_argument'}->getErrorMessage();
}
if (${'document_srl253_argument'} !== null) {
    ${'document_srl253_argument'}->setColumnType('number');
}
$query->setTables(array(new Table('`xe_tags`', '`tags`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`document_srl`', $document_srl253_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #13

File: syndication.getExceptModule.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getExceptModule");
$query->setAction("select");
$query->setPriority("");
${'module_srl244_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal');
${'module_srl244_argument'}->checkFilter('number');
${'module_srl244_argument'}->checkNotNull();
${'module_srl244_argument'}->createConditionValue();
if (!${'module_srl244_argument'}->isValid()) {
    return ${'module_srl244_argument'}->getErrorMessage();
}
if (${'module_srl244_argument'} !== null) {
    ${'module_srl244_argument'}->setColumnType('number');
}
$query->setColumns(array(new SelectExpression('count(*)', '`count`')));
$query->setTables(array(new Table('`xe_syndication_except_modules`', '`syndication_except_modules`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl244_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #14

File: member.getGroups.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getGroups");
$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();
}

Example #15

File: module.deleteModuleConfig.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("deleteModuleConfig");
$query->setAction("delete");
$query->setPriority("");
${'module15_argument'} = new ConditionArgument('module', $args->module, 'equal');
${'module15_argument'}->checkNotNull();
${'module15_argument'}->createConditionValue();
if (!${'module15_argument'}->isValid()) {
    return ${'module15_argument'}->getErrorMessage();
}
if (${'module15_argument'} !== null) {
    ${'module15_argument'}->setColumnType('varchar');
}
${'site_srl16_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
${'site_srl16_argument'}->checkNotNull();
${'site_srl16_argument'}->createConditionValue();
if (!${'site_srl16_argument'}->isValid()) {
    return ${'site_srl16_argument'}->getErrorMessage();
}
if (${'site_srl16_argument'} !== null) {
    ${'site_srl16_argument'}->setColumnType('number');
}
$query->setTables(array(new Table('`xe_module_config`', '`module_config`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module`', $module15_argument, "equal"), new ConditionWithArgument('`site_srl`', $site_srl16_argument, "equal", 'and')))));
$query->setGroups(array());
$query->setOrder(array());

Example #16

File: module.getAdminID.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getAdminID");
$query->setAction("select");
$query->setPriority("");
${'module_srl3_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal');
${'module_srl3_argument'}->checkNotNull();
${'module_srl3_argument'}->createConditionValue();
if (!${'module_srl3_argument'}->isValid()) {
    return ${'module_srl3_argument'}->getErrorMessage();
}
if (${'module_srl3_argument'} !== null) {
    ${'module_srl3_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_module_admins`', '`module_admins`'), new Table('`xe_member`', '`member`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl3_argument, "equal"), new ConditionWithoutArgument('`member`.`member_srl`', '`module_admins`.`member_srl`', "equal", 'and')))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #17

File: module.deleteModuleExtraVars.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("deleteModuleExtraVars");
$query->setAction("delete");
$query->setPriority("");
${'module_srl178_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal');
${'module_srl178_argument'}->checkFilter('number');
${'module_srl178_argument'}->checkNotNull();
${'module_srl178_argument'}->createConditionValue();
if (!${'module_srl178_argument'}->isValid()) {
    return ${'module_srl178_argument'}->getErrorMessage();
}
if (${'module_srl178_argument'} !== null) {
    ${'module_srl178_argument'}->setColumnType('number');
}
$query->setTables(array(new Table('`xe_module_extra_vars`', '`module_extra_vars`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl178_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #18

File: member.getLoginCountHistoryByMemberSrl.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getLoginCountHistoryByMemberSrl");
$query->setAction("select");
$query->setPriority("");
if (isset($args->member_srl)) {
    ${'member_srl99_argument'} = new ConditionArgument('member_srl', $args->member_srl, 'equal');
    ${'member_srl99_argument'}->createConditionValue();
    if (!${'member_srl99_argument'}->isValid()) {
        return ${'member_srl99_argument'}->getErrorMessage();
    }
} else {
    ${'member_srl99_argument'} = NULL;
}
if (${'member_srl99_argument'} !== null) {
    ${'member_srl99_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_member_count_history`', '`member_count_history`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`member_srl`', $member_srl99_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #19

File: autoinstall.insertPackage.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("insertPackage");
$query->setAction("insert");
$query->setPriority("");
${'package_srl12_argument'} = new Argument('package_srl', $args->{'package_srl'});
${'package_srl12_argument'}->checkFilter('number');
${'package_srl12_argument'}->checkNotNull();
if (!${'package_srl12_argument'}->isValid()) {
    return ${'package_srl12_argument'}->getErrorMessage();
}
if (${'package_srl12_argument'} !== null) {
    ${'package_srl12_argument'}->setColumnType('number');
}
if (isset($args->category_srl)) {
    ${'category_srl13_argument'} = new Argument('category_srl', $args->{'category_srl'});
    ${'category_srl13_argument'}->checkFilter('number');
    if (!${'category_srl13_argument'}->isValid()) {
        return ${'category_srl13_argument'}->getErrorMessage();
    }
} else {
    ${'category_srl13_argument'} = NULL;
}
if (${'category_srl13_argument'} !== null) {
    ${'category_srl13_argument'}->setColumnType('number');
}
${'path14_argument'} = new Argument('path', $args->{'path'});

Example #20

File: module.updateMobileSkinFixModules.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("updateMobileSkinFixModules");
$query->setAction("update");
$query->setPriority("");
$query->setColumns(array(new UpdateExpressionWithoutArgument('`is_mskin_fix`', "'Y'")));
$query->setTables(array(new Table('`xe_modules`', '`modules`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithoutArgument('`mskin`', '``', "notnull"), new ConditionWithoutArgument('`mskin`', "' '", "notequal", 'or')))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #21

File: module.getModuleSkinDotList.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?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;

Example #22

File: module.updateSite.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("updateSite");
$query->setAction("update");
$query->setPriority("");
if (isset($args->index_module_srl)) {
    ${'index_module_srl285_argument'} = new Argument('index_module_srl', $args->{'index_module_srl'});
    if (!${'index_module_srl285_argument'}->isValid()) {
        return ${'index_module_srl285_argument'}->getErrorMessage();
    }
} else {
    ${'index_module_srl285_argument'} = NULL;
}
if (${'index_module_srl285_argument'} !== null) {
    ${'index_module_srl285_argument'}->setColumnType('number');
}
if (isset($args->domain)) {
    ${'domain286_argument'} = new Argument('domain', $args->{'domain'});
    if (!${'domain286_argument'}->isValid()) {
        return ${'domain286_argument'}->getErrorMessage();
    }
} else {
    ${'domain286_argument'} = NULL;
}
if (${'domain286_argument'} !== null) {
    ${'domain286_argument'}->setColumnType('varchar');
}

Example #23

File: autoinstall.updatePackage.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("updatePackage");
$query->setAction("update");
$query->setPriority("");
${'path1_argument'} = new Argument('path', $args->{'path'});
${'path1_argument'}->checkNotNull();
if (!${'path1_argument'}->isValid()) {
    return ${'path1_argument'}->getErrorMessage();
}
if (${'path1_argument'} !== null) {
    ${'path1_argument'}->setColumnType('varchar');
}
${'have_instance2_argument'} = new Argument('have_instance', $args->{'have_instance'});
${'have_instance2_argument'}->checkNotNull();
if (!${'have_instance2_argument'}->isValid()) {
    return ${'have_instance2_argument'}->getErrorMessage();
}
if (${'have_instance2_argument'} !== null) {
    ${'have_instance2_argument'}->setColumnType('char');
}
${'updatedate3_argument'} = new Argument('updatedate', $args->{'updatedate'});
${'updatedate3_argument'}->checkNotNull();
if (!${'updatedate3_argument'}->isValid()) {
    return ${'updatedate3_argument'}->getErrorMessage();
}
if (${'updatedate3_argument'} !== null) {

Example #24

File: comment.getAllComments.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getAllComments");
$query->setAction("select");
$query->setPriority("");
${'document_srl51_argument'} = new ConditionArgument('document_srl', $args->document_srl, 'in');
${'document_srl51_argument'}->checkNotNull();
${'document_srl51_argument'}->createConditionValue();
if (!${'document_srl51_argument'}->isValid()) {
    return ${'document_srl51_argument'}->getErrorMessage();
}
if (${'document_srl51_argument'} !== null) {
    ${'document_srl51_argument'}->setColumnType('number');
}
$query->setColumns(array(new SelectExpression('`comment_srl`'), new SelectExpression('`module_srl`'), new SelectExpression('`member_srl`'), new SelectExpression('`document_srl`')));
$query->setTables(array(new Table('`xe_comments`', '`comments`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`document_srl`', $document_srl51_argument, "in")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #25

File: autoinstall.getPackage.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getPackage");
$query->setAction("select");
$query->setPriority("");
${'package_srl11_argument'} = new ConditionArgument('package_srl', $args->package_srl, 'equal');
${'package_srl11_argument'}->checkFilter('number');
${'package_srl11_argument'}->checkNotNull();
${'package_srl11_argument'}->createConditionValue();
if (!${'package_srl11_argument'}->isValid()) {
    return ${'package_srl11_argument'}->getErrorMessage();
}
if (${'package_srl11_argument'} !== null) {
    ${'package_srl11_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_autoinstall_packages`', '`autoinstall_packages`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`package_srl`', $package_srl11_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #26

File: module.insertTrigger.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("insertTrigger");
$query->setAction("insert");
$query->setPriority("");
${'trigger_name22_argument'} = new Argument('trigger_name', $args->{'trigger_name'});
${'trigger_name22_argument'}->checkNotNull();
if (!${'trigger_name22_argument'}->isValid()) {
    return ${'trigger_name22_argument'}->getErrorMessage();
}
if (${'trigger_name22_argument'} !== null) {
    ${'trigger_name22_argument'}->setColumnType('varchar');
}
${'module23_argument'} = new Argument('module', $args->{'module'});
${'module23_argument'}->checkNotNull();
if (!${'module23_argument'}->isValid()) {
    return ${'module23_argument'}->getErrorMessage();
}
if (${'module23_argument'} !== null) {
    ${'module23_argument'}->setColumnType('varchar');
}
${'type24_argument'} = new Argument('type', $args->{'type'});
${'type24_argument'}->checkNotNull();
if (!${'type24_argument'}->isValid()) {
    return ${'type24_argument'}->getErrorMessage();
}
if (${'type24_argument'} !== null) {

Example #27

File: module.insertModulePartConfig.1.8.15.mysql_innodb.cache.php Project: einsss/counsel_project

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("insertModulePartConfig");
$query->setAction("insert");
$query->setPriority("");
${'module3_argument'} = new Argument('module', $args->{'module'});
${'module3_argument'}->checkNotNull();
if (!${'module3_argument'}->isValid()) {
    return ${'module3_argument'}->getErrorMessage();
}
if (${'module3_argument'} !== null) {
    ${'module3_argument'}->setColumnType('varchar');
}
${'module_srl4_argument'} = new Argument('module_srl', $args->{'module_srl'});
${'module_srl4_argument'}->checkNotNull();
if (!${'module_srl4_argument'}->isValid()) {
    return ${'module_srl4_argument'}->getErrorMessage();
}
if (${'module_srl4_argument'} !== null) {
    ${'module_srl4_argument'}->setColumnType('number');
}
if (isset($args->config)) {
    ${'config5_argument'} = new Argument('config', $args->{'config'});
    if (!${'config5_argument'}->isValid()) {
        return ${'config5_argument'}->getErrorMessage();
    }
} else {

Example #28

File: document.deleteDeclared.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("deleteDeclared");
$query->setAction("delete");
$query->setPriority("");
${'document_srl45_argument'} = new ConditionArgument('document_srl', $args->document_srl, 'equal');
${'document_srl45_argument'}->checkFilter('number');
${'document_srl45_argument'}->checkNotNull();
${'document_srl45_argument'}->createConditionValue();
if (!${'document_srl45_argument'}->isValid()) {
    return ${'document_srl45_argument'}->getErrorMessage();
}
if (${'document_srl45_argument'} !== null) {
    ${'document_srl45_argument'}->setColumnType('number');
}
$query->setTables(array(new Table('`xe_document_declared`', '`document_declared`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`document_srl`', $document_srl45_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

Example #29

File: point.insertPoint.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$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());

Example #30

File: point.getPoint.1.7.8.mysql.cache.php Project: umjinsun12/dngshin

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getPoint");
$query->setAction("select");
$query->setPriority("");
if (isset($args->member_srl)) {
    ${'member_srl248_argument'} = new ConditionArgument('member_srl', $args->member_srl, 'equal');
    ${'member_srl248_argument'}->createConditionValue();
    if (!${'member_srl248_argument'}->isValid()) {
        return ${'member_srl248_argument'}->getErrorMessage();
    }
} else {
    ${'member_srl248_argument'} = NULL;
}
if (${'member_srl248_argument'} !== null) {
    ${'member_srl248_argument'}->setColumnType('number');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_point`', '`point`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`member_srl`', $member_srl248_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;