PHP Query::setConditions方法代码示例

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getModuleInfoByMenuItemSrl");
$query->setAction("select");
$query->setPriority("");
${'menu_item_srl201_argument'} = new ConditionArgument('menu_item_srl', $args->menu_item_srl, 'equal');
${'menu_item_srl201_argument'}->checkNotNull();
${'menu_item_srl201_argument'}->createConditionValue();
if (!${'menu_item_srl201_argument'}->isValid()) {
    return ${'menu_item_srl201_argument'}->getErrorMessage();
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_modules`', '`modules`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionSubquery('`mid`', new Subquery('`getMidByMenuSrl`', array(new SelectExpression('`url`')), array(new Table('`xe_menu_item`', '`menu_item`')), array(new ConditionGroup(array(new ConditionWithArgument('`menu_item`.`menu_item_srl`', $menu_item_srl201_argument, "equal")))), array(), array(), null), "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

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

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;

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

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

if (${'domain286_argument'} !== null) {
    ${'domain286_argument'}->setColumnType('varchar');
}
if (isset($args->default_language)) {
    ${'default_language287_argument'} = new Argument('default_language', $args->{'default_language'});
    if (!${'default_language287_argument'}->isValid()) {
        return ${'default_language287_argument'}->getErrorMessage();
    }
} else {
    ${'default_language287_argument'} = NULL;
}
if (${'default_language287_argument'} !== null) {
    ${'default_language287_argument'}->setColumnType('varchar');
}
${'site_srl288_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
${'site_srl288_argument'}->checkFilter('number');
${'site_srl288_argument'}->checkNotNull();
${'site_srl288_argument'}->createConditionValue();
if (!${'site_srl288_argument'}->isValid()) {
    return ${'site_srl288_argument'}->getErrorMessage();
}
if (${'site_srl288_argument'} !== null) {
    ${'site_srl288_argument'}->setColumnType('number');
}
$query->setColumns(array(new UpdateExpression('`index_module_srl`', ${'index_module_srl285_argument'}), new UpdateExpression('`domain`', ${'domain286_argument'}), new UpdateExpression('`default_language`', ${'default_language287_argument'})));
$query->setTables(array(new Table('`xe_sites`', '`sites`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`site_srl`', $site_srl288_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

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

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getGrantedModule");
$query->setAction("select");
$query->setPriority("");
${'module_srl252_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal');
${'module_srl252_argument'}->checkFilter('number');
${'module_srl252_argument'}->checkNotNull();
${'module_srl252_argument'}->createConditionValue();
if (!${'module_srl252_argument'}->isValid()) {
    return ${'module_srl252_argument'}->getErrorMessage();
}
if (${'module_srl252_argument'} !== null) {
    ${'module_srl252_argument'}->setColumnType('number');
}
$query->setColumns(array(new SelectExpression('count(*)', '`count`')));
$query->setTables(array(new Table('`xe_module_grants`', '`module_grants`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl252_argument, "equal"), new ConditionWithoutArgument('`name`', "'access','view','list'", "in", 'and'))), new ConditionGroup(array(new ConditionWithoutArgument('`group_srl`', '1', "more"), new ConditionWithoutArgument('`group_srl`', '-1', "equal", 'or'), new ConditionWithoutArgument('`group_srl`', '-2', "equal", 'or')), 'and')));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getInstalledPackages");
$query->setAction("select");
$query->setPriority("");
${'package_list1_argument'} = new ConditionArgument('package_list', $args->package_list, 'in');
${'package_list1_argument'}->checkNotNull();
${'package_list1_argument'}->createConditionValue();
if (!${'package_list1_argument'}->isValid()) {
    return ${'package_list1_argument'}->getErrorMessage();
}
if (${'package_list1_argument'} !== null) {
    ${'package_list1_argument'}->setColumnType('number');
}
$query->setColumns(array(new SelectExpression('`installed`.*'), new SelectExpression('`path`')));
$query->setTables(array(new Table('`xe_ai_installed_packages`', '`installed`'), new Table('`xe_autoinstall_packages`', '`package`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`installed`.`package_srl`', $package_list1_argument, "in"), new ConditionWithoutArgument('`installed`.`package_srl`', '`package`.`package_srl`', "equal", 'and')))));
$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;

if (isset($args->email_address)) {
    ${'email_address61_argument'} = new ConditionArgument('email_address', $args->email_address, 'equal');
    ${'email_address61_argument'}->createConditionValue();
    if (!${'email_address61_argument'}->isValid()) {
        return ${'email_address61_argument'}->getErrorMessage();
    }
} else {
    ${'email_address61_argument'} = NULL;
}
if (${'email_address61_argument'} !== null) {
    ${'email_address61_argument'}->setColumnType('varchar');
}
if (isset($args->nick_name)) {
    ${'nick_name62_argument'} = new ConditionArgument('nick_name', $args->nick_name, 'equal');
    ${'nick_name62_argument'}->createConditionValue();
    if (!${'nick_name62_argument'}->isValid()) {
        return ${'nick_name62_argument'}->getErrorMessage();
    }
} else {
    ${'nick_name62_argument'} = NULL;
}
if (${'nick_name62_argument'} !== null) {
    ${'nick_name62_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new SelectExpression('`member_srl`')));
$query->setTables(array(new Table('`xe_member`', '`member`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`user_id`', $user_id60_argument, "equal", 'and'), new ConditionWithArgument('`email_address`', $email_address61_argument, "equal", 'and'), new ConditionWithArgument('`nick_name`', $nick_name62_argument, "equal", 'and')))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

if (${'active_btn289_argument'} !== null) {
    ${'active_btn289_argument'}->setColumnType('varchar');
}
if (isset($args->group_srls)) {
    ${'group_srls290_argument'} = new Argument('group_srls', $args->{'group_srls'});
    if (!${'group_srls290_argument'}->isValid()) {
        return ${'group_srls290_argument'}->getErrorMessage();
    }
} else {
    ${'group_srls290_argument'} = NULL;
}
if (${'group_srls290_argument'} !== null) {
    ${'group_srls290_argument'}->setColumnType('text');
}
${'menu_item_srl291_argument'} = new ConditionArgument('menu_item_srl', $args->menu_item_srl, 'equal');
${'menu_item_srl291_argument'}->checkFilter('number');
${'menu_item_srl291_argument'}->checkNotNull();
${'menu_item_srl291_argument'}->createConditionValue();
if (!${'menu_item_srl291_argument'}->isValid()) {
    return ${'menu_item_srl291_argument'}->getErrorMessage();
}
if (${'menu_item_srl291_argument'} !== null) {
    ${'menu_item_srl291_argument'}->setColumnType('number');
}
$query->setColumns(array(new UpdateExpression('`menu_srl`', ${'menu_srl280_argument'}), new UpdateExpression('`parent_srl`', ${'parent_srl281_argument'}), new UpdateExpression('`name`', ${'name282_argument'}), new UpdateExpression('`url`', ${'url283_argument'}), new UpdateExpression('`is_shortcut`', ${'is_shortcut284_argument'}), new UpdateExpression('`open_window`', ${'open_window285_argument'}), new UpdateExpression('`expand`', ${'expand286_argument'}), new UpdateExpression('`normal_btn`', ${'normal_btn287_argument'}), new UpdateExpression('`hover_btn`', ${'hover_btn288_argument'}), new UpdateExpression('`active_btn`', ${'active_btn289_argument'}), new UpdateExpression('`group_srls`', ${'group_srls290_argument'})));
$query->setTables(array(new Table('`xe_menu_item`', '`menu_item`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`menu_item_srl`', $menu_item_srl291_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

$query->setAction("select");
$query->setPriority("");
${'site_srl1_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
${'site_srl1_argument'}->checkFilter('number');
${'site_srl1_argument'}->checkNotNull();
${'site_srl1_argument'}->createConditionValue();
if (!${'site_srl1_argument'}->isValid()) {
    return ${'site_srl1_argument'}->getErrorMessage();
}
if (${'site_srl1_argument'} !== null) {
    ${'site_srl1_argument'}->setColumnType('number');
}
if (isset($args->name)) {
    ${'name2_argument'} = new ConditionArgument('name', $args->name, 'equal');
    ${'name2_argument'}->createConditionValue();
    if (!${'name2_argument'}->isValid()) {
        return ${'name2_argument'}->getErrorMessage();
    }
} else {
    ${'name2_argument'} = NULL;
}
if (${'name2_argument'} !== null) {
    ${'name2_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new StarExpression()));
$query->setTables(array(new Table('`xe_lang`', '`lang`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`site_srl`', $site_srl1_argument, "equal"), new ConditionWithArgument('`name`', $name2_argument, "equal", 'and')))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

if (!${'module_srl236_argument'}->isValid()) {
    return ${'module_srl236_argument'}->getErrorMessage();
}
if (${'module_srl236_argument'} !== null) {
    ${'module_srl236_argument'}->setColumnType('number');
}
if (isset($args->var_idx)) {
    ${'var_idx237_argument'} = new ConditionArgument('var_idx', $args->var_idx, 'equal');
    ${'var_idx237_argument'}->checkFilter('number');
    ${'var_idx237_argument'}->createConditionValue();
    if (!${'var_idx237_argument'}->isValid()) {
        return ${'var_idx237_argument'}->getErrorMessage();
    }
} else {
    ${'var_idx237_argument'} = NULL;
}
if (${'var_idx237_argument'} !== null) {
    ${'var_idx237_argument'}->setColumnType('number');
}
${'sort_index238_argument'} = new Argument('sort_index', $args->{'sort_index'});
${'sort_index238_argument'}->ensureDefaultValue('var_idx');
if (!${'sort_index238_argument'}->isValid()) {
    return ${'sort_index238_argument'}->getErrorMessage();
}
$query->setColumns(array(new SelectExpression('`module_srl`', '`module_srl`'), new SelectExpression('`var_idx`', '`idx`'), new SelectExpression('`var_name`', '`name`'), new SelectExpression('`var_type`', '`type`'), new SelectExpression('`var_is_required`', '`is_required`'), new SelectExpression('`var_search`', '`search`'), new SelectExpression('`var_default`', '`default`'), new SelectExpression('`var_desc`', '`desc`'), new SelectExpression('`eid`', '`eid`')));
$query->setTables(array(new Table('`xe_document_extra_keys`', '`document_extra_keys`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srl236_argument, "equal"), new ConditionWithArgument('`var_idx`', $var_idx237_argument, "equal", 'and')))));
$query->setGroups(array());
$query->setOrder(array(new OrderByColumn(${'sort_index238_argument'}, "asc")));
$query->setLimit();
return $query;

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