Skip to content

Instantly share code, notes, and snippets.

View jocoonopa's full-sized avatar

jocoonopa jocoonopa

View GitHub Profile
@jocoonopa
jocoonopa / travis.yml
Created May 29, 2019 08:48
travis.yml
language: php
php:
- 7.2.11
addons:
mariadb: '10.0'
before_script:
- cp .env.travis .env.testing
CREATE EVENT clear_general_log
 ON SCHEDULE EVERY 12 HOUR
 DO
 CALL clear_general_log();
@jocoonopa
jocoonopa / c.sql
Last active June 12, 2019 04:25
clear_general_log
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 ;
@jocoonopa
jocoonopa / ComicBook.php
Last active April 5, 2019 14:58
Ioc-Simple-Example
<?php
class ComicBook implements Readable
{
public function read(NeedOne $n1, NeedTwo $n2, NeedThree $n3)
{
return $n3->seeWord(
$n2->seeRaw(
$n1->seePage($this)
)
@jocoonopa
jocoonopa / table.markdown
Last active February 20, 2018 03:15
加班table.markdown
加班時數 耗能 理論時數 實際時數 收穫比例
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%

訪談需求,IDEA 發想,確立基本商業模型

嘴砲做夢,畫大餅時期,令人對未來充滿希望光明的階段

  • “這太簡單了,我們以前做過 xxx,比這個複雜十倍,屁斯歐服cake”
  • “沒有技術問題,太容易了”
  • “我們要的真的很簡單,只要這樣這樣和那樣那樣就好了,很簡單拉。我知道 xxx 你一定行的,這對你來說根本沒有困難”
  • “不過就是寫個 airbnb 嘛,抄一下改一改很快拉,一個月一定沒問題的”
  • “這個只是第一步,之後還有更多錢可賺,這市場規模很大,好好做我們一定發達拉~”
@jocoonopa
jocoonopa / Wck_issue.markdown
Last active February 17, 2017 05:52
wck收尾進度

流程調整

  • sidebar and relate (4hr) v
  • 系統管理員針對加盟商增加付費紀錄 (3hr) v
  • 系統管理員針對加盟商檢視付費紀錄 (2hr) v
  • 針對姓名進行搜尋的功能 (2hr) v

系統管理者流程

  • 教師table (1hr) v
test

DB Schema

{
    "Node":  {
        "des": "欲檢查之節點",
        "schema": {
            "id": {
                "type": "INT[primaryKey]", 
                "des": "索引", 
@jocoonopa
jocoonopa / View_CTI_Member.sql
Last active January 21, 2016 03:49
偉特 CTI 會員檢視表
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