加班時數 | 耗能 | 理論時數 | 實際時數 | 收穫比例 |
---|---|---|---|---|
2 | 102.06% | 201 | 199 | 99.32% |
3 | 103.09% | 203 | 201 | 99.15% |
4 | 104.13% | 205 | 202 | 98.98% |
5 | 105.17% | 207 | 204 | 98.8% |
6 | 106.22% | 209 | 206 | 98.62% |
7 | 107.28% | 211 | 207 | 98.44% |
8 | 108.33% | 213 | 209 | 98.26% |
9 | 109.4% | 215 | 211 | 98.08% |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
language: php | |
php: | |
- 7.2.11 | |
addons: | |
mariadb: '10.0' | |
before_script: | |
- cp .env.travis .env.testing |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE EVENT clear_general_log | |
ON SCHEDULE EVERY 12 HOUR | |
DO | |
CALL clear_general_log(); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DELIMITER $$ | |
CREATE PROCEDURE clear_general_log() | |
BEGIN | |
SET GLOBAL general_log=0; | |
RENAME TABLE `general_log` TO `general_log_temp`; | |
DELETE FROM `general_log_temp` WHERE `event_time` < DATE(NOW() - INTERVAL 1 DAY); | |
RENAME TABLE `general_log_temp` TO `general_log`; | |
SET GLOBAL general_log=1; | |
END$$ | |
DELIMITER ; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
class ComicBook implements Readable | |
{ | |
public function read(NeedOne $n1, NeedTwo $n2, NeedThree $n3) | |
{ | |
return $n3->seeWord( | |
$n2->seeRaw( | |
$n1->seePage($this) | |
) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
test |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
WITH TMP_CCS_OrderDetails AS ( -- 訂單以及商品相關資料 | |
SELECT | |
SUM(CCS_OrderDetails.SubTotal) AS orderSubTotal, -- 訂單小計總和 | |
POS_Member.SerNo AS memberSerNo, -- 會員編號(用來Group) | |
MAX(CCS_OrderIndex.OrderDate) AS orderDate, -- 訂單時間(Group 後取最後一筆的時間) | |
MAX(PIS_Goods.Code) goodsCode, -- 商品代碼 | |
MAX(PIS_GoodsLittleCategory.Name) AS goodsCategoryName, -- 商品小分類名稱 | |
MAX(PIS_GoodsLittleCategory.Code) AS goodsCategoryCode -- 商品小分類代碼 | |
FROM | |
CCS_OrderDetails |