TinyMurky commented 1 week ago

Summary

規劃Beta票數 (Certificate, Voucher, AI, Report)

Tasks

[ ] 規劃Beta票數 (Certificate, Voucher, AI, Report)

Dependencies

No response

Other Dependencies

No response

Additional Notes

No response

TinyMurky commented 1 week ago

Output formatter (5pt)

搭建zod output formatter -5pt
Certificate(38pt)
Post Certificate
- repo -2pt
- formatter -2pt
- post -1pt
- test -2pt
Get Certificate (all)
- repo (須處理pagination) -3pt
- formatter -2pt
- Get api -1 pt
- test 2pt
- Delete Certificate(軟刪除，要和invoice一起刪除)
- repo -3pt
- formatter -2pt
- Get api -1 pt
- test 2pt
- Get Certificate(one, 和invoice一起抓出來)
- repo -2pt
- formatter -2pt
- Get api -1 pt
- test -2pt
Put Certificate (更換fileId 或是 invoiceId (備用))
- repo -1pt
- formatter -1pt
- Get api -1 pt
- test -1pt
Post Already read
- repo -1pt
- formatter -1pt
- Get api -1 pt
- test -1pt

Certificate With AI (17pt)

這邊不計入要架設Pusher 和 Gemini的時間
- Schema and Prompt -2pt
- 處理ISunFa傳過來的input format -1pt
- Setup post api (包含串接gemini, 存sqlite database 和發送pusher) -8pt
- Setup get result api (include format) -2pt
- setup get status api -1pt
- repo (包含post, get result, get status) -3pt

TinyMurky commented 1 week ago

Invoice (17pt)

Mock API -5pt
Post Invoice
- repo -2pt
- formatter -1pt
- Post api - 1pt
- test -2 pt
- Put Invoice
- repo -2pt
- formatter -1pt
- Post api - 1pt
- test -2 pt

TinyMurky commented 1 week ago

Faith/AICH的部份 (24pt)

假設直接先做在AICH
- 架設Pusher and 測試 -16pt
- 架設Prisma (db, migrate, injectable class...) -5pt
- 串接Gemini(gemini單獨建立一個class) -3pt

TinyMurky commented 1 week ago

Voucher 82~98

Post Voucher (困難)
- repo (複雜，要同時處理 4 種event, 並紀錄lineitems和連接certificate) -5pt
- 建立cronjob定期把upcoming 變成uploaded -5pt
- Post Voucher (複雜，需要出裡沖轉以及upcoming voucher ) -8pt ~ 16pt
- formatter - 2pt
- test -5pt
Put Voucher (困難)
- repo -5pt
- Put Voucher (複雜，需要創造沖轉分錄)-8pt ~ 16pt
- formatter - 2pt
- test -5pt
Delete Voucher (和Put相似）
- repo -3pt
- Put Voucher (複雜，需要創造沖轉分錄)-8pt
- formatter - 2pt
- test -5pt
List all uploaded voucher
- repo (須處理pagination) -3pt
- formatter -2pt
- Get api -1 pt
- test -2pt
Get One uploaded voucher
- repo -2pt
- formatter -2pt
- Get api -1 pt
- test -2pt
Post Already read
- repo -1pt
- formatter -1pt
- Get api -1 pt
- test -1pt

Voucher With AI (17pt)

這邊不計入要架設Pusher 和 Gemini的時間
- Schema and Prompt -2pt
- 處理ISunFa傳過來的input format -1pt
- Setup post api (包含串接gemini, 存sqlite database 和發送pusher) -8pt
- Setup get result api (include format) -2pt
- setup get status api -1pt
- repo (包含post, get result, get status) -3pt

TinyMurky commented 1 week ago

Report (依照能不能從原本的code成功更改而不同時間) (32pt ~ 56pt)

Get balance sheet 8~16pt
- 需要轉成object輸出
- refactor整個輸出邏輯
Get incomeStatement 8~16pt
- 需要轉成object輸出
- refactor整個輸出邏輯
Get cash flow(邏輯和前面兩個不同) 16~24
- 需要轉成object輸出
- refactor整個輸出邏輯

TinyMurky commented 1 week ago

232\~264pt 約6~7周

took 3 hours done

TinyMurky commented 1 week ago

可重複使用的API (1 API)

POST File

需要Refactor的API (3 API)

(old) Create Report (三張報表算分開) => (new) Get Report

需要重新開始寫 (16 API)

Post Certificate
Get Certificate (all)
Delete Certificate(軟刪除，要和invoice一起刪除)
Get Certificate(one, 和invoice一起抓出來)
Put Certificate (更換fileId 或是 invoiceId (備用))
Post Already read Certificate
Post Invoice
Put Invoice
Post Voucher
Put Voucher
Delete Voucher
List all uploaded voucher
Get One uploaded voucher
Post Already read voucher
ask_ai(算兩支，主動詢問 certificate和voucher
需要重新寫但是是在AICH (6 API)
Post Certificate(to get "Invoice")
Get Certificate result status
Get Certificate result
Post Voucher(to get "Invoice")
Get Voucher result status
Get Voucher result

TinyMurky commented 1 week ago

其他細項 (13pt)

搭建zod output formatter -5pt
Pusher 資訊from emily 的 github , Feature/add pusher #2746, FEATURE - Pusher 上傳 certificate 流程調整 #2736=> 需要有一個功能是陌生人Post file 但是只有特定人可以閱讀，用特殊token來做（因為手機不能做驗證，token代表認證的手機） -8pt

Certificate細項 (26~31pt)

其他 (0~5pt)
- 架設Pusher監聽Faith，有回傳值直接存在database 更新 invoice, 如果用戶已經Post 或Put了就不用update-5pt （可以先不用在Beta版本實做)
List All Certificate (9pt)
- 計算所有invoice的price - 0.5pt
- 計算unreaded數字 (all certificate under per company - 用所有該company certificateId + userId去關聯查出來的數字) - 0.5pt
- Format api output - 2pt
- List all Certificate repo - 3pt (還需要把invoice拉出來, 需要同時處理pagination的資訊和used by voucher, not used by voucher, fuzzy search, get not read count等等)
- GET API架設 -1pt
- test -2pt
Get one certificate (4pt)
- Format api output - 1pt
- Get 1 certificate repo (需要同時把invoice拉出來) - 1pt
- GET API架設 -1pt
- test -1pt
Post certificate (3pt)
- 備註：需要特別注意在Post的時候可能後端剛好先幫忙做好invoice，因此需要先檢查certificate有沒有連到invoice，如果有直接覆蓋內容。
- Format api output - 0.5pt
- Post certificate repo(單純只是把fileId建立一個certificate) -0.5pt
- POST api 架設 -1pt
- test -1pt
Put certificate (3pt) 和post類似
Delete certificate (3.5pt)
- 備註：尚未開立傳票的憑證才可刪除（才有刪除鍵）
- 檢查是否已經關聯voucher -0.5pt
- Format api output - 0.5pt
- delete repo -0.5pt
- Delete api架設 - 1pt
- test -1pt
Post Already read (3.5pt)
- 備註：在voucher使用特定的certificate的時候，要把狀態轉成unread
- Format api input/output - 0.5pt
- Post repo (新增到userCertificate) -1pt
- Post api 架設 -1pt
- test -1pt
Certificate AI (18pt)
其他 (5pt)
- 需要建立Worker (或cronjob)把AI辨識失敗的資料重新丟回去跑 -5pt
Post Certificate (7.5pt)
- Post gemini (包含要寫Prompt 和 gemini schema) - 3pt
- Save to Sqlite -repo -0.5pt
- 架設Post api -1pt
- Push to Pusher -2pt
- test 1pt
Get Certificate Result status (2.5pt)
- Find status in sqlite -0.5pt
- format return -0.5pt
- 架設api -1pt
- test 0.5pt
Get Certificate Result(3pt)
- Find status in sqlite -0.5pt
- format return - 1pt
- 架設api -1pt
- test 0.5pt

Invoice (9pt)

mock api (include input zod) -3pt
Post Invoice (3pt)
- format output -0.5pt
- repo -0.5pt
- 架設Post api - 1pt
- test -1pt
Put Invoice (3pt)
- format output -0.5pt
- repo -0.5pt
- 架設Post api - 1pt
- test -1pt

TinyMurky commented 1 week ago

AI (Faith/AICH)(18pt)

建立Pusher Class 加Pusher 測試 -8pt
將Gemini單獨拉成一個class -5pt
架設 Prisma (and schema) -5pt

Ask_AI (ISunFa Backend) (6pt)

Post Ask_AI (2pt)
- 備註：Certificate 是上傳的時候就開始分析(但是還是要前端幫忙用certificate id post)，voucher則是按下去才分析
- 架設api (2pt)
Get Ask_AI status (2pt)
- 架設api (2pt)
Get Ask_AI result (2pt)
- 架設api (2pt)

TinyMurky commented 1 week ago

Voucher (52pt)

其他 (5pt)
- 建立把voucher 從uploaded 改成upcoming 的 worker, 同時需要一起改unread state -5pt
Post Voucher(13.5pt)
- 特殊事件：
  - If 是 AP/AR沖帳事件，建立AssociateEvent並且寫進Event，但是event除了type之外不紀錄東西
  - If 是 recursive 事件，應該要是建立AssociateEvent並且寫進Event，並要紀錄時間
  - if 是 Asset 事件，要先紀錄Asset voucher 關聯表，建立AssociateEvent並且寫進Event, 然後同時生成折舊傳票
- 處理一般Post voucher (6.5pt)
  - repo 儲存 voucher data和line items -3pt
  - 架設API -2pt
  - Format api output -0.5 pt
  - test -1pt
- 特殊事件 (7pt)
  - recursive 一次生成多張傳票並連結的邏輯 -2pt
  - 關聯asset，並自動算出折舊 voucher 並建立 -3pt
  - AP/AR 沖帳邏輯 -2pt
Put Voucher (11.5pt)
- 備註：會有兩個不同邏輯：
  - 1: 只修改非lineitems的東西 => 可直接修改
  - 2: 修改lineItems的東西 => 需要建立沖帳
- 建立Partial update的檢查邏輯，區分1, 2，並撰寫partial update -3pt
- 架設Put API -2pt
- 1:
  - 儲存repo -0.5pt
  - test -1pt
- 2:
  - 建立New voucher (標記type為 edit , associate with 原始voucher, 天數壓同一天), reop + 邏輯 -4pt
  - test -1pt
Get Voucher (10pt)
- 分成三種邏輯
  - Get 一般voucher
  - Get payable/receivable
  - 從report點出來的 => 單一一個account連出來的邏輯
- 架設Get API -3pt
- Repo (須處理Pagination, 總計unread等邏輯) -3pt
- Format output (依照三個不同狀況分別) -2pt
- test -2pt
Post Already read (3.5pt)
- 備註：在voucher從upcoming變成uploaded的時候，要把狀態轉成unread
- Format api input/output - 0.5pt
- Post repo (新增到userCertificate) -1pt
- Post api 架設 -1pt
- test -1pt
Delete (8.5 pt)
- 備註：要記得先判斷是不是upcomming，upcomming 可以直接刪除，其他的需要做反轉
- Format api output -0.5pt
- 架設Delete api - 1pt
- 邏輯1:
  - repo - 0.5 pt
  - Code -0.5pt
  - test -1pt
- 邏輯2
  - repo: 1pt
  - Code: (需要直接反轉, 標記type為 edit , associate with 原始voucher, 天數壓同一天): 3pt
  - test - 1pt

Voucher AI (17.5pt)

其他 (4pt)
- 需要建立Worker (或cronjob)把AI辨識失敗的資料重新丟回去跑 -4pt
Post Voucher (7.5pt)
- Post gemini (包含要寫Prompt 和 gemini schema) - 3pt
- Save to Sqlite -repo -1pt
- 架設Post api + 邏輯 -2pt
- Push to Pusher -2pt
- test 1pt
Get Voucher Result status (2.5pt)
- Find status in sqlite -0.5pt
- format return -0.5pt
- 架設api -1pt
- test 0.5pt
Get Certificate Result(3pt)
- Find status in sqlite -0.5pt
- format return - 1pt
- 架設api -1pt
- test 0.5

TinyMurky commented 1 week ago

Report

Beta 優先執行

2776 -8pt
2777 -8pt

等Beta完成以後再做 (98pt 完成 5pt)
重新檢查account Seed 各項欄位以及Parent Code是否正確 - 16pt
2767 -8pt
2768 -8pt
2758 -5pt
Refactor 財報 (去除filter, 並重新Reshape成為 Recursive結構)
- Balance sheet
  - 2753 - 5pt
  - 2769 -8pt
  - 2770 -8pt
- Refactor income statement
  - 2771 -8pt
  - 2772 -8pt
- Refactor cash flow
  - 2773 -8pt
  - 2774 -8pt
  - 2775 -8pt

TinyMurky commented 1 week ago

164.5 (新增功能) + 50 (Report) = 214.5 約6周

took 5 hours done

CAFECA-IO / iSunFA

[DOCS] - 規劃Beta票數 (Certificate, Voucher, AI, Report) #2720

Summary

Tasks

Dependencies

Other Dependencies

Additional Notes

Output formatter (5pt)

Certificate(38pt)

Certificate With AI (17pt)

Invoice (17pt)

Faith/AICH的部份 (24pt)

Voucher 82~98

Voucher With AI (17pt)

Report (依照能不能從原本的code成功更改而不同時間) (32pt ~ 56pt)

可重複使用的API (1 API)

需要Refactor的API (3 API)

需要重新開始寫 (16 API)

需要重新寫但是是在AICH (6 API)

其他細項 (13pt)

Certificate細項 (26~31pt)

Certificate AI (18pt)

Invoice (9pt)

AI (Faith/AICH)(18pt)

Ask_AI (ISunFa Backend) (6pt)

Voucher (52pt)

Voucher AI (17.5pt)

Report

Beta 優先執行

2776 -8pt

2777 -8pt

等Beta完成以後再做 (98pt 完成 5pt)

2767 -8pt

2768 -8pt

2758 -5pt

2753 - 5pt

2769 -8pt

2770 -8pt

2771 -8pt

2772 -8pt

2773 -8pt

2774 -8pt

2775 -8pt