<?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;
if (isset($args->trigger_name)) { ${'trigger_name9_argument'} = new ConditionArgument('trigger_name', $args->trigger_name, 'equal'); ${'trigger_name9_argument'}->createConditionValue(); if (!${'trigger_name9_argument'}->isValid()) { return ${'trigger_name9_argument'}->getErrorMessage(); } } else { ${'trigger_name9_argument'} = NULL; } if (${'trigger_name9_argument'} !== null) { ${'trigger_name9_argument'}->setColumnType('varchar'); } if (isset($args->called_position)) { ${'called_position10_argument'} = new ConditionArgument('called_position', $args->called_position, 'equal'); ${'called_position10_argument'}->createConditionValue(); if (!${'called_position10_argument'}->isValid()) { return ${'called_position10_argument'}->getErrorMessage(); } } else { ${'called_position10_argument'} = NULL; } if (${'called_position10_argument'} !== null) { ${'called_position10_argument'}->setColumnType('varchar'); } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_module_trigger`', '`module_trigger`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`trigger_name`', $trigger_name9_argument, "equal"), new ConditionWithArgument('`called_position`', $called_position10_argument, "equal", 'and'))))); $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;
} if (${'upload_target_srl54_argument'} !== null) { ${'upload_target_srl54_argument'}->setColumnType('number'); } if (isset($args->isvalid)) { ${'isvalid55_argument'} = new ConditionArgument('isvalid', $args->isvalid, 'equal'); ${'isvalid55_argument'}->createConditionValue(); if (!${'isvalid55_argument'}->isValid()) { return ${'isvalid55_argument'}->getErrorMessage(); } } else { ${'isvalid55_argument'} = NULL; } if (${'isvalid55_argument'} !== null) { ${'isvalid55_argument'}->setColumnType('char'); } if (isset($args->sort_index)) { ${'sort_index56_argument'} = new Argument('sort_index', $args->{'sort_index'}); if (!${'sort_index56_argument'}->isValid()) { return ${'sort_index56_argument'}->getErrorMessage(); } } else { ${'sort_index56_argument'} = NULL; } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_files`', '`files`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`upload_target_srl`', $upload_target_srl54_argument, "equal"), new ConditionWithArgument('`isvalid`', $isvalid55_argument, "equal", 'and'))))); $query->setGroups(array()); $query->setOrder(array(new OrderByColumn(${'sort_index56_argument'}, "asc"))); $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("getMenuByTitle"); $query->setAction("select"); $query->setPriority(""); ${'title150_argument'} = new ConditionArgument('title', $args->title, 'in'); ${'title150_argument'}->checkNotNull(); ${'title150_argument'}->createConditionValue(); if (!${'title150_argument'}->isValid()) { return ${'title150_argument'}->getErrorMessage(); } if (${'title150_argument'} !== null) { ${'title150_argument'}->setColumnType('varchar'); } ${'site_srl151_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal'); ${'site_srl151_argument'}->ensureDefaultValue('0'); ${'site_srl151_argument'}->createConditionValue(); if (!${'site_srl151_argument'}->isValid()) { return ${'site_srl151_argument'}->getErrorMessage(); } if (${'site_srl151_argument'} !== null) { ${'site_srl151_argument'}->setColumnType('number'); } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_menu`', '`menu`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`title`', $title150_argument, "in"), new ConditionWithArgument('`site_srl`', $site_srl151_argument, "equal", 'and'))))); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("deleteModuleConfig"); $query->setAction("delete"); $query->setPriority(""); ${'module15_argument'} = new ConditionArgument('module', $args->module, 'equal'); ${'module15_argument'}->checkNotNull(); ${'module15_argument'}->createConditionValue(); if (!${'module15_argument'}->isValid()) { return ${'module15_argument'}->getErrorMessage(); } if (${'module15_argument'} !== null) { ${'module15_argument'}->setColumnType('varchar'); } ${'site_srl16_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal'); ${'site_srl16_argument'}->checkNotNull(); ${'site_srl16_argument'}->createConditionValue(); if (!${'site_srl16_argument'}->isValid()) { return ${'site_srl16_argument'}->getErrorMessage(); } if (${'site_srl16_argument'} !== null) { ${'site_srl16_argument'}->setColumnType('number'); } $query->setTables(array(new Table('`xe_module_config`', '`module_config`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module`', $module15_argument, "equal"), new ConditionWithArgument('`site_srl`', $site_srl16_argument, "equal", 'and'))))); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("getMemberInfoByEmailAddress"); $query->setAction("select"); $query->setPriority(""); ${'email_address95_argument'} = new ConditionArgument('email_address', $args->email_address, 'equal'); ${'email_address95_argument'}->checkNotNull(); ${'email_address95_argument'}->createConditionValue(); if (!${'email_address95_argument'}->isValid()) { return ${'email_address95_argument'}->getErrorMessage(); } if (${'email_address95_argument'} !== null) { ${'email_address95_argument'}->setColumnType('varchar'); } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_member`', '`member`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`email_address`', $email_address95_argument, "equal"))))); $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;
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;
} $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("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;
if (isset($args->module_srl)) { ${'module_srl154_argument'} = new ConditionArgument('module_srl', $args->module_srl, 'equal'); ${'module_srl154_argument'}->createConditionValue(); if (!${'module_srl154_argument'}->isValid()) { return ${'module_srl154_argument'}->getErrorMessage(); } } else { ${'module_srl154_argument'} = NULL; } if (${'module_srl154_argument'} !== null) { ${'module_srl154_argument'}->setColumnType('number'); } if (isset($args->site_srl)) { ${'site_srl155_argument'} = new ConditionArgument('site_srl', $args->site_srl, 'equal'); ${'site_srl155_argument'}->createConditionValue(); if (!${'site_srl155_argument'}->isValid()) { return ${'site_srl155_argument'}->getErrorMessage(); } } else { ${'site_srl155_argument'} = NULL; } if (${'site_srl155_argument'} !== null) { ${'site_srl155_argument'}->setColumnType('number'); } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_modules`', '`modules`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`mid`', $mid153_argument, "equal"), new ConditionWithArgument('`module_srl`', $module_srl154_argument, "equal", 'and'), new ConditionWithArgument('`site_srl`', $site_srl155_argument, "equal", 'and'))))); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
<?php if (!defined('__XE__')) { exit; } $query = new Query(); $query->setQueryId("getModulesInfo"); $query->setAction("select"); $query->setPriority(""); ${'module_srls1_argument'} = new ConditionArgument('module_srls', $args->module_srls, 'in'); ${'module_srls1_argument'}->checkNotNull(); ${'module_srls1_argument'}->createConditionValue(); if (!${'module_srls1_argument'}->isValid()) { return ${'module_srls1_argument'}->getErrorMessage(); } if (${'module_srls1_argument'} !== null) { ${'module_srls1_argument'}->setColumnType('number'); } $query->setColumns(array(new StarExpression())); $query->setTables(array(new Table('`xe_modules`', '`modules`'))); $query->setConditions(array(new ConditionGroup(array(new ConditionWithArgument('`module_srl`', $module_srls1_argument, "in"))))); $query->setGroups(array()); $query->setOrder(array()); $query->setLimit(); return $query;
} $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;
<?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;