PHP Query::setTables方法代码示例

<?php

if (!defined('__XE__')) {
    exit;
}
$query = new Query();
$query->setQueryId("getAutologin");
$query->setAction("select");
$query->setPriority("");
${'autologin_key1_argument'} = new ConditionArgument('autologin_key', $args->autologin_key, 'equal');
${'autologin_key1_argument'}->checkNotNull();
${'autologin_key1_argument'}->createConditionValue();
if (!${'autologin_key1_argument'}->isValid()) {
    return ${'autologin_key1_argument'}->getErrorMessage();
}
if (${'autologin_key1_argument'} !== null) {
    ${'autologin_key1_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new SelectExpression('`member`.`email_address`', '`email_address`'), new SelectExpression('`member`.`user_id`', '`user_id`'), new SelectExpression('`member`.`password`', '`password`'), new SelectExpression('`member_autologin`.`autologin_key`', '`autologin_key`')));
$query->setTables(array(new Table('`xe_member`', '`member`'), new Table('`xe_member_autologin`', '`member_autologin`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`member_autologin`.`autologin_key`', $autologin_key1_argument, "equal"), new ConditionWithoutArgument('`member`.`member_srl`', '`member_autologin`.`member_srl`', "equal", 'and')))));
$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;

    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();
if (!${'member_srl98_argument'}->isValid()) {
    return ${'member_srl98_argument'}->getErrorMessage();
}
if (${'member_srl98_argument'} !== null) {
    ${'member_srl98_argument'}->setColumnType('number');
}
$query->setColumns(array(new UpdateExpression('`member_srl`', ${'member_srl96_argument'}), new UpdateExpression('`last_login`', ${'last_login97_argument'})));
$query->setTables(array(new Table('`xe_member`', '`member`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`member_srl`', $member_srl98_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

}
$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")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

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

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

        return ${'group_srls141_argument'}->getErrorMessage();
    }
} else {
    ${'group_srls141_argument'} = NULL;
}
if (${'group_srls141_argument'} !== null) {
    ${'group_srls141_argument'}->setColumnType('text');
}
${'listorder142_argument'} = new Argument('listorder', $args->{'listorder'});
${'listorder142_argument'}->checkNotNull();
if (!${'listorder142_argument'}->isValid()) {
    return ${'listorder142_argument'}->getErrorMessage();
}
if (${'listorder142_argument'} !== null) {
    ${'listorder142_argument'}->setColumnType('number');
}
${'regdate143_argument'} = new Argument('regdate', $args->{'regdate'});
${'regdate143_argument'}->ensureDefaultValue(date("YmdHis"));
if (!${'regdate143_argument'}->isValid()) {
    return ${'regdate143_argument'}->getErrorMessage();
}
if (${'regdate143_argument'} !== null) {
    ${'regdate143_argument'}->setColumnType('date');
}
$query->setColumns(array(new InsertExpression('`menu_item_srl`', ${'menu_item_srl129_argument'}), new InsertExpression('`parent_srl`', ${'parent_srl130_argument'}), new InsertExpression('`menu_srl`', ${'menu_srl131_argument'}), new InsertExpression('`name`', ${'name132_argument'}), new InsertExpression('`desc`', ${'desc133_argument'}), new InsertExpression('`url`', ${'url134_argument'}), new InsertExpression('`is_shortcut`', ${'is_shortcut135_argument'}), new InsertExpression('`open_window`', ${'open_window136_argument'}), new InsertExpression('`expand`', ${'expand137_argument'}), new InsertExpression('`normal_btn`', ${'normal_btn138_argument'}), new InsertExpression('`hover_btn`', ${'hover_btn139_argument'}), new InsertExpression('`active_btn`', ${'active_btn140_argument'}), new InsertExpression('`group_srls`', ${'group_srls141_argument'}), new InsertExpression('`listorder`', ${'listorder142_argument'}), new InsertExpression('`regdate`', ${'regdate143_argument'})));
$query->setTables(array(new Table('`xe_menu_item`', '`menu_item`')));
$query->setConditions(array());
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

${'notify_message237_argument'} = new Argument('notify_message', $args->{'notify_message'});
${'notify_message237_argument'}->ensureDefaultValue('N');
if (!${'notify_message237_argument'}->isValid()) {
    return ${'notify_message237_argument'}->getErrorMessage();
}
if (${'notify_message237_argument'} !== null) {
    ${'notify_message237_argument'}->setColumnType('char');
}
${'status238_argument'} = new Argument('status', $args->{'status'});
${'status238_argument'}->ensureDefaultValue('PUBLIC');
if (!${'status238_argument'}->isValid()) {
    return ${'status238_argument'}->getErrorMessage();
}
if (${'status238_argument'} !== null) {
    ${'status238_argument'}->setColumnType('varchar');
}
${'commentStatus239_argument'} = new Argument('commentStatus', $args->{'commentStatus'});
${'commentStatus239_argument'}->ensureDefaultValue('ALLOW');
if (!${'commentStatus239_argument'}->isValid()) {
    return ${'commentStatus239_argument'}->getErrorMessage();
}
if (${'commentStatus239_argument'} !== null) {
    ${'commentStatus239_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new InsertExpression('`document_srl`', ${'document_srl206_argument'}), new InsertExpression('`module_srl`', ${'module_srl207_argument'}), new InsertExpression('`category_srl`', ${'category_srl208_argument'}), new InsertExpression('`lang_code`', ${'lang_code209_argument'}), new InsertExpression('`is_notice`', ${'is_notice210_argument'}), new InsertExpression('`title`', ${'title211_argument'}), new InsertExpression('`title_bold`', ${'title_bold212_argument'}), new InsertExpression('`title_color`', ${'title_color213_argument'}), new InsertExpression('`content`', ${'content214_argument'}), new InsertExpression('`readed_count`', ${'readed_count215_argument'}), new InsertExpression('`blamed_count`', ${'blamed_count216_argument'}), new InsertExpression('`voted_count`', ${'voted_count217_argument'}), new InsertExpression('`comment_count`', ${'comment_count218_argument'}), new InsertExpression('`trackback_count`', ${'trackback_count219_argument'}), new InsertExpression('`uploaded_count`', ${'uploaded_count220_argument'}), new InsertExpression('`password`', ${'password221_argument'}), new InsertExpression('`nick_name`', ${'nick_name222_argument'}), new InsertExpression('`member_srl`', ${'member_srl223_argument'}), new InsertExpression('`user_id`', ${'user_id224_argument'}), new InsertExpression('`user_name`', ${'user_name225_argument'}), new InsertExpression('`email_address`', ${'email_address226_argument'}), new InsertExpression('`homepage`', ${'homepage227_argument'}), new InsertExpression('`tags`', ${'tags228_argument'}), new InsertExpression('`extra_vars`', ${'extra_vars229_argument'}), new InsertExpression('`regdate`', ${'regdate230_argument'}), new InsertExpression('`last_update`', ${'last_update231_argument'}), new InsertExpression('`last_updater`', ${'last_updater232_argument'}), new InsertExpression('`ipaddress`', ${'ipaddress233_argument'}), new InsertExpression('`list_order`', ${'list_order234_argument'}), new InsertExpression('`update_order`', ${'update_order235_argument'}), new InsertExpression('`allow_trackback`', ${'allow_trackback236_argument'}), new InsertExpression('`notify_message`', ${'notify_message237_argument'}), new InsertExpression('`status`', ${'status238_argument'}), new InsertExpression('`comment_status`', ${'commentStatus239_argument'})));
$query->setTables(array(new Table('`xe_documents`', '`documents`')));
$query->setConditions(array());
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

${'act116_argument'} = new Argument('act', $args->{'act'});
${'act116_argument'}->checkNotNull();
if (!${'act116_argument'}->isValid()) {
    return ${'act116_argument'}->getErrorMessage();
}
if (${'act116_argument'} !== null) {
    ${'act116_argument'}->setColumnType('varchar');
}
${'module117_argument'} = new Argument('module', $args->{'module'});
${'module117_argument'}->checkNotNull();
if (!${'module117_argument'}->isValid()) {
    return ${'module117_argument'}->getErrorMessage();
}
if (${'module117_argument'} !== null) {
    ${'module117_argument'}->setColumnType('varchar');
}
${'type118_argument'} = new Argument('type', $args->{'type'});
${'type118_argument'}->checkNotNull();
if (!${'type118_argument'}->isValid()) {
    return ${'type118_argument'}->getErrorMessage();
}
if (${'type118_argument'} !== null) {
    ${'type118_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new InsertExpression('`act`', ${'act116_argument'}), new InsertExpression('`module`', ${'module117_argument'}), new InsertExpression('`type`', ${'type118_argument'})));
$query->setTables(array(new Table('`xe_action_forward`', '`action_forward`')));
$query->setConditions(array());
$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;

    }
} 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("chkDeniedNickName");
$query->setAction("select");
$query->setPriority("");
if (isset($args->nick_name)) {
    ${'nick_name66_argument'} = new ConditionArgument('nick_name', $args->nick_name, 'equal');
    ${'nick_name66_argument'}->createConditionValue();
    if (!${'nick_name66_argument'}->isValid()) {
        return ${'nick_name66_argument'}->getErrorMessage();
    }
} else {
    ${'nick_name66_argument'} = NULL;
}
if (${'nick_name66_argument'} !== null) {
    ${'nick_name66_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new SelectExpression('count(*)', '`count`')));
$query->setTables(array(new Table('`xe_member_denied_nick_name`', '`member_denied_nick_name`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`nick_name`', $nick_name66_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

$query->setAction("select");
$query->setPriority("");
${'member_srl96_argument'} = new ConditionArgument('member_srl', $args->member_srl, 'equal');
${'member_srl96_argument'}->checkFilter('number');
${'member_srl96_argument'}->checkNotNull();
${'member_srl96_argument'}->createConditionValue();
if (!${'member_srl96_argument'}->isValid()) {
    return ${'member_srl96_argument'}->getErrorMessage();
}
if (${'member_srl96_argument'} !== null) {
    ${'member_srl96_argument'}->setColumnType('number');
}
if (isset($args->site_srl)) {
    ${'site_srl97_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal');
    ${'site_srl97_argument'}->createConditionValue();
    if (!${'site_srl97_argument'}->isValid()) {
        return ${'site_srl97_argument'}->getErrorMessage();
    }
} else {
    ${'site_srl97_argument'} = NULL;
}
if (${'site_srl97_argument'} !== null) {
    ${'site_srl97_argument'}->setColumnType('number');
}
$query->setColumns(array(new SelectExpression('`a`.`title`', '`title`'), new SelectExpression('`a`.`group_srl`', '`group_srl`')));
$query->setTables(array(new Table('`xe_member_group`', '`a`'), new Table('`xe_member_group_member`', '`b`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`b`.`member_srl`', $member_srl96_argument, "equal"), new ConditionWithoutArgument('`b`.`group_srl`', '`a`.`group_srl`', "equal", 'and'), new ConditionWithArgument('`a`.`site_srl`', $site_srl97_argument, "equal", 'and')))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;

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