PHP Query::setQueryId方法代码示例

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

<?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) {

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

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

<?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()) {

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

<?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) {

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

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

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

<?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`')));

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

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

<?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();
}

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