当前位置: 首页>>代码示例>>PHP>>正文


PHP Query::setColumns方法代码示例

本文整理汇总了PHP中Query::setColumns方法的典型用法代码示例。如果您正苦于以下问题:PHP Query::setColumns方法的具体用法?PHP Query::setColumns怎么用?PHP Query::setColumns使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在Query的用法示例。


在下文中一共展示了Query::setColumns方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。

示例1: testGetQueryCountWithGroupNoColumns

 /**
  * @group count
  * @covers Query::getQuery
  */
 function testGetQueryCountWithGroupNoColumns()
 {
     $q = new Query('test_table');
     $q->addGroup('test_column');
     $q->setAction(Query::ACTION_COUNT);
     $count_q = $q->getQuery()->__toString();
     $q->setAction(Query::ACTION_SELECT);
     // to count the rows in an agggregate query, the inner query should
     // use the group by columns as the select columns
     $q->setColumns(array('test_column'));
     $select_q = $q->getQuery()->__toString();
     $this->assertEquals("SELECT count(0)\nFROM ({$select_q}) a", $count_q);
 }
开发者ID:abcarroll,项目名称:DABL,代码行数:17,代码来源:QueryTest.php

示例2: Argument

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;
开发者ID:umjinsun12,项目名称:dngshin,代码行数:31,代码来源:menu.updateMenuItem.1.7.8.mysql.cache.php

示例3: 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;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:module.getModuleCategories.1.8.15.mysql_innodb.cache.php

示例4: 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;
开发者ID:umjinsun12,项目名称:dngshin,代码行数:25,代码来源:module.getModuleSkinDotList.1.7.8.mysql.cache.php

示例5: Argument

${'latest_item_srl5_argument'}->checkNotNull();
if (!${'latest_item_srl5_argument'}->isValid()) {
    return ${'latest_item_srl5_argument'}->getErrorMessage();
}
if (${'latest_item_srl5_argument'} !== null) {
    ${'latest_item_srl5_argument'}->setColumnType('number');
}
${'version6_argument'} = new Argument('version', $args->{'version'});
${'version6_argument'}->checkNotNull();
if (!${'version6_argument'}->isValid()) {
    return ${'version6_argument'}->getErrorMessage();
}
if (${'version6_argument'} !== null) {
    ${'version6_argument'}->setColumnType('varchar');
}
${'package_srl7_argument'} = new ConditionArgument('package_srl', $args->package_srl, 'equal');
${'package_srl7_argument'}->checkNotNull();
${'package_srl7_argument'}->createConditionValue();
if (!${'package_srl7_argument'}->isValid()) {
    return ${'package_srl7_argument'}->getErrorMessage();
}
if (${'package_srl7_argument'} !== null) {
    ${'package_srl7_argument'}->setColumnType('number');
}
$query->setColumns(array(new UpdateExpression('`path`', ${'path1_argument'}), new UpdateExpression('`have_instance`', ${'have_instance2_argument'}), new UpdateExpression('`updatedate`', ${'updatedate3_argument'}), new UpdateExpression('`category_srl`', ${'category_srl4_argument'}), new UpdateExpression('`latest_item_srl`', ${'latest_item_srl5_argument'}), new UpdateExpression('`version`', ${'version6_argument'})));
$query->setTables(array(new Table('`xe_autoinstall_packages`', '`autoinstall_packages`')));
$query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`package_srl`', $package_srl7_argument, "equal")))));
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:autoinstall.updatePackage.1.8.15.mysql_innodb.cache.php

示例6: Argument

${'type24_argument'} = new Argument('type', $args->{'type'});
${'type24_argument'}->checkNotNull();
if (!${'type24_argument'}->isValid()) {
    return ${'type24_argument'}->getErrorMessage();
}
if (${'type24_argument'} !== null) {
    ${'type24_argument'}->setColumnType('varchar');
}
${'called_method25_argument'} = new Argument('called_method', $args->{'called_method'});
${'called_method25_argument'}->checkNotNull();
if (!${'called_method25_argument'}->isValid()) {
    return ${'called_method25_argument'}->getErrorMessage();
}
if (${'called_method25_argument'} !== null) {
    ${'called_method25_argument'}->setColumnType('varchar');
}
${'called_position26_argument'} = new Argument('called_position', $args->{'called_position'});
${'called_position26_argument'}->checkNotNull();
if (!${'called_position26_argument'}->isValid()) {
    return ${'called_position26_argument'}->getErrorMessage();
}
if (${'called_position26_argument'} !== null) {
    ${'called_position26_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new InsertExpression('`trigger_name`', ${'trigger_name22_argument'}), new InsertExpression('`module`', ${'module23_argument'}), new InsertExpression('`type`', ${'type24_argument'}), new InsertExpression('`called_method`', ${'called_method25_argument'}), new InsertExpression('`called_position`', ${'called_position26_argument'})));
$query->setTables(array(new Table('`xe_module_trigger`', '`module_trigger`')));
$query->setConditions(array());
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;
开发者ID:umjinsun12,项目名称:dngshin,代码行数:31,代码来源:module.insertTrigger.1.7.8.mysql.cache.php

示例7: Argument

${'updatedate16_argument'} = new Argument('updatedate', $args->{'updatedate'});
${'updatedate16_argument'}->checkNotNull();
if (!${'updatedate16_argument'}->isValid()) {
    return ${'updatedate16_argument'}->getErrorMessage();
}
if (${'updatedate16_argument'} !== null) {
    ${'updatedate16_argument'}->setColumnType('date');
}
${'latest_item_srl17_argument'} = new Argument('latest_item_srl', $args->{'latest_item_srl'});
${'latest_item_srl17_argument'}->checkNotNull();
if (!${'latest_item_srl17_argument'}->isValid()) {
    return ${'latest_item_srl17_argument'}->getErrorMessage();
}
if (${'latest_item_srl17_argument'} !== null) {
    ${'latest_item_srl17_argument'}->setColumnType('number');
}
${'version18_argument'} = new Argument('version', $args->{'version'});
${'version18_argument'}->checkNotNull();
if (!${'version18_argument'}->isValid()) {
    return ${'version18_argument'}->getErrorMessage();
}
if (${'version18_argument'} !== null) {
    ${'version18_argument'}->setColumnType('varchar');
}
$query->setColumns(array(new InsertExpression('`package_srl`', ${'package_srl12_argument'}), new InsertExpression('`category_srl`', ${'category_srl13_argument'}), new InsertExpression('`path`', ${'path14_argument'}), new InsertExpression('`have_instance`', ${'have_instance15_argument'}), new InsertExpression('`updatedate`', ${'updatedate16_argument'}), new InsertExpression('`latest_item_srl`', ${'latest_item_srl17_argument'}), new InsertExpression('`version`', ${'version18_argument'})));
$query->setTables(array(new Table('`xe_autoinstall_packages`', '`autoinstall_packages`')));
$query->setConditions(array());
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:autoinstall.insertPackage.1.8.15.mysql_innodb.cache.php

示例8: Argument

${'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;
开发者ID:umjinsun12,项目名称:dngshin,代码行数:31,代码来源:document.insertDocument.1.7.8.mysql.cache.php

示例9: Argument

    return ${'is_used_m110_argument'}->getErrorMessage();
}
if (${'is_used_m110_argument'} !== null) {
    ${'is_used_m110_argument'}->setColumnType('char');
}
if (isset($args->extra_vars)) {
    ${'extra_vars111_argument'} = new Argument('extra_vars', $args->{'extra_vars'});
    if (!${'extra_vars111_argument'}->isValid()) {
        return ${'extra_vars111_argument'}->getErrorMessage();
    }
} else {
    ${'extra_vars111_argument'} = NULL;
}
if (${'extra_vars111_argument'} !== null) {
    ${'extra_vars111_argument'}->setColumnType('text');
}
${'regdate112_argument'} = new Argument('regdate', $args->{'regdate'});
${'regdate112_argument'}->ensureDefaultValue(date("YmdHis"));
if (!${'regdate112_argument'}->isValid()) {
    return ${'regdate112_argument'}->getErrorMessage();
}
if (${'regdate112_argument'} !== null) {
    ${'regdate112_argument'}->setColumnType('date');
}
$query->setColumns(array(new InsertExpression('`site_srl`', ${'site_srl107_argument'}), new InsertExpression('`addon`', ${'addon108_argument'}), new InsertExpression('`is_used`', ${'is_used109_argument'}), new InsertExpression('`is_used_m`', ${'is_used_m110_argument'}), new InsertExpression('`extra_vars`', ${'extra_vars111_argument'}), new InsertExpression('`regdate`', ${'regdate112_argument'})));
$query->setTables(array(new Table('`xe_addons_site`', '`addons_site`')));
$query->setConditions(array());
$query->setGroups(array());
$query->setOrder(array());
$query->setLimit();
return $query;
开发者ID:umjinsun12,项目名称:dngshin,代码行数:31,代码来源:addon.insertSiteAddon.1.7.8.mysql.cache.php

示例10: 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;
开发者ID:einsss,项目名称:counsel_project,代码行数:25,代码来源:autoinstall.getInstalledPackages.1.8.15.mysql_innodb.cache.php

示例11: Argument

        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;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:menu.insertMenuItem.1.8.15.mysql_innodb.cache.php

示例12: ConditionArgument

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;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:member.getMemberSrl.1.8.15.mysql_innodb.cache.php

示例13: Argument

${'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;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:module.insertActionForward.1.8.15.mysql_innodb.cache.php

示例14: ConditionArgument

    }
} 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;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:document.getGroupsExtraVars.1.8.15.mysql_innodb.cache.php

示例15: Argument

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;
开发者ID:einsss,项目名称:counsel_project,代码行数:31,代码来源:module.updateSite.1.8.15.mysql_innodb.cache.php


注:本文中的Query::setColumns方法示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。