公保勞保聘僱資料分析:修訂版本之間的差異
出自福留子孫
(→各項 SQL 指令) |
(→各項 SQL 指令) |
||
(未顯示同用戶所作出之2次版本) | |||
第 3 行: | 第 3 行: | ||
===各項 SQL 指令=== | ===各項 SQL 指令=== | ||
− | # | + | #生成去年國小行政人力①:update classNumberE set 去年應有行政人力=((0.2385*班級數+0.518)-0.0016*班級數*班級數) where 班級數 not like '%-%' |
− | # | + | #生成去年國小行政人力②:update classNumberE set 去年應有行政人力=9.4 where 班級數 >= 74 |
− | # | + | #去年公校國小行政人力:select sum(去年應有行政人力) from classNumberE where SUBSTRING(學校代碼,3,1)!='1' |
− | # | + | #公校國小新行政人力員額數:select sum((0.2408*班級數+3)-0.003*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1' |
− | # | + | #生成去年國中行政人力:update classNumberJ set 去年應有行政人力=((0.1357*班級數+6.68)-0.0002*班級數*班級數) where 班級數 not like '%-%' |
#去年公校國中行政人力:select sum(去年應有行政人力) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1' | #去年公校國中行政人力:select sum(去年應有行政人力) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1' | ||
#公校國中新行政人力員額數:select sum((0.37*班級數+7)-0.008*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1' | #公校國中新行政人力員額數:select sum((0.37*班級數+7)-0.008*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1' |
2023年7月12日 (三) 11:26的最新修訂版本
各項 SQL 指令
- 生成去年國小行政人力①:update classNumberE set 去年應有行政人力=((0.2385*班級數+0.518)-0.0016*班級數*班級數) where 班級數 not like '%-%'
- 生成去年國小行政人力②:update classNumberE set 去年應有行政人力=9.4 where 班級數 >= 74
- 去年公校國小行政人力:select sum(去年應有行政人力) from classNumberE where SUBSTRING(學校代碼,3,1)!='1'
- 公校國小新行政人力員額數:select sum((0.2408*班級數+3)-0.003*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1'
- 生成去年國中行政人力:update classNumberJ set 去年應有行政人力=((0.1357*班級數+6.68)-0.0002*班級數*班級數) where 班級數 not like '%-%'
- 去年公校國中行政人力:select sum(去年應有行政人力) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1'
- 公校國中新行政人力員額數:select sum((0.37*班級數+7)-0.008*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!='1'
- 國小勞保9月薪級,單一薪級僱用超過50人:select salary,count(*) from postJunior1九月 group by salary having count(*)>50
- 國中勞保9月薪級,單一薪級僱用超過30人:select salary,count(*) from postJunior2 where dataDate='2022-09-30' group by salary having count(*)>30
- :
Debug data:
-
-
Start request GET /wellBeingNg/index.php?title=%E5%85%AC%E4%BF%9D%E5%8B%9E%E4%BF%9D%E8%81%98%E5%83%B1%E8%B3%87%E6%96%99%E5%88%86%E6%9E%90&diff=15260&oldid=15257
HTTP HEADERS:
ACCEPT-ENCODING: gzip, br, zstd, deflate
USER-AGENT: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
ACCEPT: */*
CONNECTION: close
HOST: well-being-ng.net
X-REAL-PORT: 40298
X-PORT: 80
X-REAL-IP: 3.145.20.193
X-FORWARDED-BY: 192.168.4.2 -
[caches] main: EmptyBagOStuff, message: SqlBagOStuff, parser: SqlBagOStuff
-
[caches] LocalisationCache: using store LCStoreDB
-
Connected to database 0 at localhost
-
Unstubbing $wgParser on call of $wgParser::setHook from require_once
-
Parser: using preprocessor: Preprocessor_DOM
-
Fully initialised
-
Title::getRestrictionTypes: applicable restrictions to [[公保勞保聘僱資料分析]] are {edit,move}
-
[ContentHandler] Created handler for wikitext: WikitextContentHandler
-
IP: 3.145.20.193
-
Article::view: showing diff page
-
DifferenceEngine old '15257' new '15260' rcid ''
-
Connected to database 0 at localhost
-
MessageCache::load: Loading zh-tw... got from global cache
-
Unstubbing $wgLang on call of $wgLang::_unstub from ParserOptions::__construct
-
WikiPage::getParserOutput: using parser cache: yes
-
Parser options key expired, touched 20230712032627, epoch 20240511084146, cached 20240511065106
-
Parser cache options found.
-
[Preprocessor] Saved preprocessor XML to memcached (key wiki-wiki_:preprocess-xml:e436af82beddd13c321f6df130427e17:0)
-
[Preprocessor] Saved preprocessor XML to memcached (key wiki-wiki_:preprocess-xml:e436af82beddd13c321f6df130427e17:0)
-
Saved in parser cache with key wiki-wiki_:pcache:idhash:165-0!*!*!*!*!*!* and timestamp 20240511084747 and revision id 15260
-
DatabaseBase::query: Writes done: REPLACE INTO `wiki_objectcache` (keyname,value,exptime) VALUES ('wiki-wiki_:pcache:idhash:165-0!*!*!*!*!*!*','O:12:\"ParserOutput\":39:{s:5:\"mText\";s:2122:\"<p><br />\n</p>\n<h3><span class=\"mw-headline\" id=\".E5.90.84.E9.A0.85_SQL_.E6.8C.87.E4.BB.A4\">各項 SQL 指令</span><mw:editsection page=\"公保勞保聘僱資料分析\" section=\"1\">各項 SQL 指令</mw:editsection></h3>\n<ol>\n<li>生成去年國小行政人力①:update classNumberE set 去年應有行政人力=((0.2385*班級數+0.518)-0.0016*班級數*班級數) where 班級數 not like \'%-%\'\n</li>\n<li>生成去年國小行政人力②:update classNumberE set 去年應有行政人力=9.4 where 班級數 >= 74\n</li>\n<li>去年公校國小行政人力:select sum(去年應有行政人力) from classNumberE where SUBSTRING(學校代碼,3,1)!=\'1\'\n</li>\n<li>公校國小新行政人力員額數:select sum((0.2408*班級數+3)-0.003*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!=\'1\'\n</li>\n<li>生成去年國中行政人力:update classNumberJ set 去年應有行政人力=((0.1357*班級數+6.68)-0.0002*班級數*班級數) where 班級數 not like \'%-%\'\n</li>\n<li>去年公校國中行政人力:select sum(去年應有行政人力) from classNumberJ where SUBSTRING(學校代碼,3,1)!=\'1\'\n</li>\n<li>公校國中新行政人力員額數:select sum((0.37*班級數+7)-0.008*班級數*班級數) from classNumberJ where SUBSTRING(學校代碼,3,1)!=\'1\'\n</li>\n<li>國小勞保9月薪級,單一薪級僱用超過50人:select salary,count(*) from postJunior1九月 group by salary having count(*)>50\n</li>\n<li>國中勞保9月薪級,單一薪級僱用超過30人:select salary,count(*) from postJunior2 where dataDate=\'2022-09-30\' group by salary having count(*)>30\n</li>\n<li>:\n</li>\n</ol>\n\n<!-- \nNewPP limit report\nCPU time usage: 0.002 seconds\nReal time usage: 0.006 seconds\nPreprocessor visited node count: 3/1000000\nPreprocessor generated node count: 8/1000000\nPost‐expand include size: 0/2097152 bytes\nTemplate argument size: 0/2097152 bytes\nHighest expansion depth: 2/40\nExpensive parser function count: 0/100\n-->\n\n<!-- Saved in parser cache with key wiki-wiki_:pcache:idhash:165-0!*!*!*!*!*!* and timestamp 20240511084747 and revision id 15260\n -->\n\";s:14:\"mLanguageLinks\";a:0:{}s:11:\"mCategories\";a:1:{s:27:\"教育經費基準委員會\";s:0:\"\";}s:10:\"mTitleText\";s:30:\"公保勞保聘僱資料分析\";s:6:\"mLinks\";a:0:{}s:10:\"mTemplates\";a:0:{}s:12:\"mTemplateIds\";a:0:{}s:7:\"mImages\";a:0:{}s:18:\"mFileSearchOptions\";a:0:{}s:14:\"mExternalLinks\";a:0:{}s:15:\"mInterwikiLinks\";a:0:{}s:11:\"mNewSection\";b:0;s:15:\"mHideNewSection\";b:0;s:10:\"mNoGallery\";b:0;s:10:\"mHeadItems\";a:0:{}s:8:\"mModules\";a:0:{}s:14:\"mModuleScripts\";a:0:{}s:13:\"mModuleStyles\";a:0:{}s:15:\"mModuleMessages\";a:0:{}s:13:\"mJsConfigVars\";a:0:{}s:12:\"mOutputHooks\";a:0:{}s:9:\"mWarnings\";a:0:{}s:9:\"mSections\";a:1:{i:0;a:8:{s:8:\"toclevel\";i:1;s:5:\"level\";s:1:\"3\";s:4:\"line\";s:17:\"各項 SQL 指令\";s:6:\"number\";s:1:\"1\";s:5:\"index\";s:1:\"1\";s:9:\"fromtitle\";s:30:\"公保勞保聘僱資料分析\";s:10:\"byteoffset\";i:19;s:6:\"anchor\";s:41:\".E5.90.84.E9.A0.85_SQL_.E6.8C.87.E4.BB.A4\";}}s:18:\"mEditSectionTokens\";b:0;s:11:\"mProperties\";a:0:{}s:8:\"mTOCHTML\";s:0:\"\";s:10:\"mTimestamp\";s:14:\"20230712032627\";s:11:\"mTOCEnabled\";b:1;s:26:\"\0ParserOutput\0mIndexPolicy\";s:0:\"\";s:30:\"\0ParserOutput\0mAccessedOptions\";a:0:{}s:28:\"\0ParserOutput\0mExtensionData\";a:0:{}s:30:\"\0ParserOutput\0mLimitReportData\";a:8:{s:19:\"limitreport-cputime\";s:5:\"0.002\";s:20:\"limitreport-walltime\";s:5:\"0.006\";s:26:\"limitreport-ppvisitednodes\";a:2:{i:0;i:3;i:1;i:1000000;}s:28:\"limitreport-ppgeneratednodes\";a:2:{i:0;i:8;i:1;i:1000000;}s:33:\"limitreport-postexpandincludesize\";a:2:{i:0;i:0;i:1;i:2097152;}s:32:\"limitreport-templateargumentsize\";a:2:{i:0;i:0;i:1;i:2097152;}s:26:\"limitreport-expansiondepth\";a:2:{i:0;i:2;i:1;i:40;}s:34:\"limitreport-expensivefunctioncount\";a:2:{i:0;i:0;i:1;i:100;}}s:34:\"\0ParserOutput\0mPreventClickjacking\";b:0;s:12:\"mUsedOptions\";N;s:8:\"mVersion\";s:5:\"1.6.4\";s:10:\"mCacheTime\";s:14:\"20240511084747\";s:12:\"mCacheExpiry\";N;s:17:\"mContainsOldMagic\";b:0;s:16:\"mCacheRevisionId\";i:15260;}','20240512084747')
-
MessageCache::load: Loading zh-hant... got from global cache
-
MessageCache::load: Loading zh-hans... got from global cache
-
MessageCache::load: Loading en... got from global cache
-
Title::getRestrictionTypes: applicable restrictions to [[公保勞保聘僱資料分析]] are {edit,move}
-
-