/** * @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); }
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;
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("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;
${'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;
${'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;
${'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;
${'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;
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;
<?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;
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;
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;
${'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;
} } 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 (${'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;
return ${'regdate175_argument'}->getErrorMessage(); } if (${'regdate175_argument'} !== null) { ${'regdate175_argument'}->setColumnType('date'); } if (isset($args->mlayout_srl)) { ${'mlayout_srl176_argument'} = new Argument('mlayout_srl', $args->{'mlayout_srl'}); if (!${'mlayout_srl176_argument'}->isValid()) { return ${'mlayout_srl176_argument'}->getErrorMessage(); } } else { ${'mlayout_srl176_argument'} = NULL; } if (${'mlayout_srl176_argument'} !== null) { ${'mlayout_srl176_argument'}->setColumnType('number'); } ${'use_mobile177_argument'} = new Argument('use_mobile', $args->{'use_mobile'}); ${'use_mobile177_argument'}->ensureDefaultValue('N'); if (!${'use_mobile177_argument'}->isValid()) { return ${'use_mobile177_argument'}->getErrorMessage(); } if (${'use_mobile177_argument'} !== null) { ${'use_mobile177_argument'}->setColumnType('char'); } $query->setColumns(array(new InsertExpression('`site_srl`', ${'site_srl156_argument'}), new InsertExpression('`module_srl`', ${'module_srl157_argument'}), new InsertExpression('`module_category_srl`', ${'module_category_srl158_argument'}), new InsertExpression('`mid`', ${'mid159_argument'}), new InsertExpression('`skin`', ${'skin160_argument'}), new InsertExpression('`is_skin_fix`', ${'is_skin_fix161_argument'}), new InsertExpression('`is_mskin_fix`', ${'is_mskin_fix162_argument'}), new InsertExpression('`mskin`', ${'mskin163_argument'}), new InsertExpression('`browser_title`', ${'browser_title164_argument'}), new InsertExpression('`layout_srl`', ${'layout_srl165_argument'}), new InsertExpression('`description`', ${'description166_argument'}), new InsertExpression('`content`', ${'content167_argument'}), new InsertExpression('`mcontent`', ${'mcontent168_argument'}), new InsertExpression('`module`', ${'module169_argument'}), new InsertExpression('`is_default`', ${'is_default170_argument'}), new InsertExpression('`menu_srl`', ${'menu_srl171_argument'}), new InsertExpression('`open_rss`', ${'open_rss172_argument'}), new InsertExpression('`header_text`', ${'header_text173_argument'}), new InsertExpression('`footer_text`', ${'footer_text174_argument'}), new InsertExpression('`regdate`', ${'regdate175_argument'}), new InsertExpression('`mlayout_srl`', ${'mlayout_srl176_argument'}), new InsertExpression('`use_mobile`', ${'use_mobile177_argument'}))); $query->setTables(array(new Table('`xe_modules`', '`modules`'))); $query->setConditions(array()); $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;
exit; } $query = new Query(); $query->setQueryId("getScrapDocument"); $query->setAction("select"); $query->setPriority(""); ${'member_srl1_argument'} = new ConditionArgument('member_srl', $args->member_srl, 'equal'); ${'member_srl1_argument'}->checkNotNull(); ${'member_srl1_argument'}->createConditionValue(); if (!${'member_srl1_argument'}->isValid()) { return ${'member_srl1_argument'}->getErrorMessage(); } if (${'member_srl1_argument'} !== null) { ${'member_srl1_argument'}->setColumnType('number'); } ${'document_srl2_argument'} = new ConditionArgument('document_srl', $args->document_srl, 'equal'); ${'document_srl2_argument'}->checkNotNull(); ${'document_srl2_argument'}->createConditionValue(); if (!${'document_srl2_argument'}->isValid()) { return ${'document_srl2_argument'}->getErrorMessage(); } if (${'document_srl2_argument'} !== null) { ${'document_srl2_argument'}->setColumnType('number'); } $query->setColumns(array(new SelectExpression('count(`document_srl`)', '`count`'))); $query->setTables(array(new Table('`xe_member_scrap`', '`member_scrap`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`member_srl`', $member_srl1_argument, "equal"), new ConditionWithArgument('`document_srl`', $document_srl2_argument, "equal", 'and'))))); $query->setGroups(array()); $query->setOrder(array()); $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;
<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("getNeedUpdate"); $query->setAction("select"); $query->setPriority(""); $query->setColumns(array(new SelectExpression('`i`.*'), new SelectExpression('`p`.`path`'))); $query->setTables(array(new Table('`xe_ai_installed_packages`', '`i`'), new Table('`xe_autoinstall_packages`', '`p`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithoutArgument('`i`.`package_srl`', '`p`.`package_srl`', "equal"), new ConditionWithoutArgument('`i`.`need_update`', "'Y'", "equal", 'and'))))); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
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) { ${'description102_argument'}->setColumnType('text'); } if (isset($args->list_order)) { ${'list_order103_argument'} = new Argument('list_order', $args->{'list_order'}); if (!${'list_order103_argument'}->isValid()) { return ${'list_order103_argument'}->getErrorMessage(); } } else { ${'list_order103_argument'} = NULL; } if (${'list_order103_argument'} !== null) { ${'list_order103_argument'}->setColumnType('number'); } $query->setColumns(array(new InsertExpression('`user_id`', ${'user_id100_argument'}), new InsertExpression('`regdate`', ${'regdate101_argument'}), new InsertExpression('`description`', ${'description102_argument'}), new InsertExpression('`list_order`', ${'list_order103_argument'}))); $query->setTables(array(new Table('`xe_member_denied_user_id`', '`member_denied_user_id`'))); $query->setConditions(array()); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
${'regdate34_argument'} = new Argument('regdate', $args->{'regdate'}); ${'regdate34_argument'}->ensureDefaultValue(date("YmdHis")); if (!${'regdate34_argument'}->isValid()) { return ${'regdate34_argument'}->getErrorMessage(); } if (${'regdate34_argument'} !== null) { ${'regdate34_argument'}->setColumnType('date'); } ${'description35_argument'} = new Argument('description', $args->{'description'}); ${'description35_argument'}->ensureDefaultValue(''); if (!${'description35_argument'}->isValid()) { return ${'description35_argument'}->getErrorMessage(); } if (${'description35_argument'} !== null) { ${'description35_argument'}->setColumnType('text'); } ${'image_mark36_argument'} = new Argument('image_mark', $args->{'image_mark'}); ${'image_mark36_argument'}->ensureDefaultValue(''); if (!${'image_mark36_argument'}->isValid()) { return ${'image_mark36_argument'}->getErrorMessage(); } if (${'image_mark36_argument'} !== null) { ${'image_mark36_argument'}->setColumnType('text'); } $query->setColumns(array(new InsertExpression('`site_srl`', ${'site_srl28_argument'}), new InsertExpression('`group_srl`', ${'group_srl29_argument'}), new InsertExpression('`list_order`', ${'list_order30_argument'}), new InsertExpression('`title`', ${'title31_argument'}), new InsertExpression('`is_default`', ${'is_default32_argument'}), new InsertExpression('`is_admin`', ${'is_admin33_argument'}), new InsertExpression('`regdate`', ${'regdate34_argument'}), new InsertExpression('`description`', ${'description35_argument'}), new InsertExpression('`image_mark`', ${'image_mark36_argument'}))); $query->setTables(array(new Table('`xe_member_group`', '`member_group`'))); $query->setConditions(array()); $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("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;
return ${'layout_path189_argument'}->getErrorMessage(); } } else { ${'layout_path189_argument'} = NULL; } if (${'layout_path189_argument'} !== null) { ${'layout_path189_argument'}->setColumnType('varchar'); } ${'regdate190_argument'} = new Argument('regdate', $args->{'regdate'}); ${'regdate190_argument'}->ensureDefaultValue(date("YmdHis")); if (!${'regdate190_argument'}->isValid()) { return ${'regdate190_argument'}->getErrorMessage(); } if (${'regdate190_argument'} !== null) { ${'regdate190_argument'}->setColumnType('date'); } ${'layout_type191_argument'} = new Argument('layout_type', $args->{'layout_type'}); ${'layout_type191_argument'}->ensureDefaultValue('P'); if (!${'layout_type191_argument'}->isValid()) { return ${'layout_type191_argument'}->getErrorMessage(); } if (${'layout_type191_argument'} !== null) { ${'layout_type191_argument'}->setColumnType('char'); } $query->setColumns(array(new InsertExpression('`layout_srl`', ${'layout_srl183_argument'}), new InsertExpression('`site_srl`', ${'site_srl184_argument'}), new InsertExpression('`layout`', ${'layout185_argument'}), new InsertExpression('`title`', ${'title186_argument'}), new InsertExpression('`module_srl`', ${'module_srl187_argument'}), new InsertExpression('`extra_vars`', ${'extra_vars188_argument'}), new InsertExpression('`layout_path`', ${'layout_path189_argument'}), new InsertExpression('`regdate`', ${'regdate190_argument'}), new InsertExpression('`layout_type`', ${'layout_type191_argument'}))); $query->setTables(array(new Table('`xe_layouts`', '`layouts`'))); $query->setConditions(array()); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
if (!${'target_member_srl9_argument'}->isValid()) { return ${'target_member_srl9_argument'}->getErrorMessage(); } if (${'target_member_srl9_argument'} !== null) { ${'target_member_srl9_argument'}->setColumnType('number'); } ${'regdate10_argument'} = new Argument('regdate', $args->{'regdate'}); ${'regdate10_argument'}->ensureDefaultValue(date("YmdHis")); if (!${'regdate10_argument'}->isValid()) { return ${'regdate10_argument'}->getErrorMessage(); } if (${'regdate10_argument'} !== null) { ${'regdate10_argument'}->setColumnType('date'); } ${'list_order11_argument'} = new Argument('list_order', $args->{'list_order'}); $db = DB::getInstance(); $sequence = $db->getNextSequence(); ${'list_order11_argument'}->ensureDefaultValue($sequence); if (!${'list_order11_argument'}->isValid()) { return ${'list_order11_argument'}->getErrorMessage(); } if (${'list_order11_argument'} !== null) { ${'list_order11_argument'}->setColumnType('number'); } $query->setColumns(array(new InsertExpression('`member_srl`', ${'member_srl3_argument'}), new InsertExpression('`document_srl`', ${'document_srl4_argument'}), new InsertExpression('`title`', ${'title5_argument'}), new InsertExpression('`user_id`', ${'user_id6_argument'}), new InsertExpression('`user_name`', ${'user_name7_argument'}), new InsertExpression('`nick_name`', ${'nick_name8_argument'}), new InsertExpression('`target_member_srl`', ${'target_member_srl9_argument'}), new InsertExpression('`regdate`', ${'regdate10_argument'}), new InsertExpression('`list_order`', ${'list_order11_argument'}))); $query->setTables(array(new Table('`xe_member_scrap`', '`member_scrap`'))); $query->setConditions(array()); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
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 { ${'config5_argument'} = NULL; } if (${'config5_argument'} !== null) { ${'config5_argument'}->setColumnType('text'); } ${'regdate6_argument'} = new Argument('regdate', $args->{'regdate'}); ${'regdate6_argument'}->ensureDefaultValue(date("YmdHis")); if (!${'regdate6_argument'}->isValid()) { return ${'regdate6_argument'}->getErrorMessage(); } if (${'regdate6_argument'} !== null) { ${'regdate6_argument'}->setColumnType('date'); } $query->setColumns(array(new InsertExpression('`module`', ${'module3_argument'}), new InsertExpression('`module_srl`', ${'module_srl4_argument'}), new InsertExpression('`config`', ${'config5_argument'}), new InsertExpression('`regdate`', ${'regdate6_argument'}))); $query->setTables(array(new Table('`xe_module_part_config`', '`module_part_config`'))); $query->setConditions(array()); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
<?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;
} $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()); $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;