1. 結論
流程圖是業務全景;本系統沒有單一「集士流程」模組,而是依 ref_menu 頂層分組拆成:
雇主管理 → 函件管理 → 外勞管理 → 入出境管理 → 報表/帳務。
核心資料鏈:
company_info → com_case → recruit_docs → labo_case_his →(labo_inout|eng_permission_lab|visa_doc|labo_health_chk|labo_residence_permit|labo_passport)→ AccountDetail/debit_record/發票
- 單一外勞總覽:
worker/laborer/manage(選單:外勞資料)
- 實際辦理入境/出境:多為
laboInout/*
- 人員多分頁:
protected/views/worker/laborer/manage/edit_worker.php
flowchart TB
subgraph lane1 [雇主泳道]
CI[CompanyInfo / cust]
CF[ComFactory / HomeCustAddr]
CCT[ComContact]
CCTR[ComContract]
CR[ComRegulations]
end
subgraph lane2 [案件泳道]
CC[ComCase]
LCH[LaboCaseHis]
end
subgraph lane3 [招募帳務橋接]
RD[RecruitDocs / RecruitPrc]
AC[account/charge]
end
subgraph lane4 [外勞合規]
LI[LaboInout]
EPL[EngPermissionLab]
VD[VisaDoc]
LB[LabBody / worker/body]
LP[LabPermit / worker/permit]
PP[LabPassport / worker/passport]
LF[worker/finger]
end
subgraph lane5 [保險薪資服務]
CHN[ComHealthNo / ComInsuranceNo]
AR[AppReport 加退保表]
LS[LaboSalary]
INV[account/invoice + FeeReport]
end
CI --> CC --> RD --> LCH
LCH --> LI
LCH --> EPL
LCH --> VD
LCH --> LB
LCH --> LP
LCH --> PP
LI --> AC
CHN --> AR
AC --> INV
3. 泳道詳表:資料表、Action、選單
3.1 雇主泳道
| 圖上概念 | 資料表 | Model | Controller / Action | 選單 → Route |
| 雇主 | company_info | CompanyInfo | CustController: admin, view, create, update | 雇主資料管理 → cust/admin |
| 工地(機構) | com_factory | ComFactory | ComFactoryController: admin(cust tab3) | (分頁內) |
| 工地(居家) | home_cust_addr | HomeCustAddr | HomeCustAddrController | (分頁內) |
| 負責人 | com_per | ComPer | comPer/admin | cust tab2 |
| 聯絡人 | com_contact | ComContact | comContact/admin | cust tab4 |
| 作業規則 | com_regulations | ComRegulations | admin, listMang | 雇主作業原則匯出 → ./ComRegulations/listMang |
| 服務合約 | com_contract | ComContract | comContract/admin | 雇主合約管理 → comContract/admin |
| 國內人才 | newsagent | — | newsagent/admin | 國內求才登記 → newsagent/admin |
| CRM 潛在客 | marketing_consult | MarketingConsult | MarketingConsultController | 行銷統計 → ./marketingConsult/exportAdmin |
| 業開 | custome_sales | CustomeSales | CustomeSalesController | 合約確認單 → /customeSales |
| 勞保投保字號 | com_insured_people_number | ComInsuredPeopleNumber | comInsuredPeopleNumber/admin | 勞保每月投保人數管理 |
| 案件 | com_case | ComCase | comCase/admin | 雇主案件管理 → comCase/admin |
FK:com_case.ci_id → company_info;cc_WorkPlace → com_factory 或 home_cust_addr(依 C/H)。
protected/models/ComCase.php (約 141–146 行)LEFT JOIN com_factory AS cf ON (ci.ci_ComCategory="C" AND cc.cc_WorkPlace=cf.cf_id)
LEFT JOIN home_cust_addr AS hca ON (ci.ci_ComCategory="H" AND cc.cc_WorkPlace=hca.hca_id)
3.2 案件 → 招募面
| 圖上概念 | 資料表 | Model | Action | 選單 → Route |
| 外勞在案 | labo_case_his | LaboCaseHis | laboCaseHis/admin;LabWorker update* | (外勞資料內) |
| 招募函 | recruit_docs | RecruitDocs | admin, create, update | 招募函管理 → recruitDocs/admin |
| 遞補函 | fill_recruit_docs 等 | FillRecruitDocs | fillRecruitDocs/admin | 遞補函管理 → fillRecruitDocs/admin |
| 文件認證 | recruit_prc | RecruitPrc | recruitPrc/admin | 文件認證管理 → recruitPrc/admin |
| 入國通報 | arrival_notice | — | arrivalNotice/admin | 入國通報管理 → arrivalNotice/admin |
| 函件統計 | — | — | docsCount/admin | 函件人數統計表 → docsCount/admin |
FK:labo_case_his.cc_id → com_case;rd_id → recruit_docs;lab_id → laborer。
「招募」在此系統指核准函/遞補函文件流,非一般徵才 ATS。
3.3 帳務面(橋接)
| 圖上概念 | 資料表 | 類別 | Action | 選單 → Route |
| 外勞應收 | AccountDetail 等 | AccCharge | account/charge/manage | 費用管理 → account/charge/manage/index |
| 收款項目 | ItemName, ItemIncome | — | account/charge/item | 收款項目設定 |
| 過帳審核 | — | AccChargeVerify | account/charge/verify | 過帳審核(雇主管理下) |
| 申辦費用 | — | — | account/charge/fee | 外勞申辦費用管理 |
| 雇主服務費 | 樣式/設定表 | AccService | account/service/set, change, style | 雇主服務費群組 |
| 入境寫應收 | — | — | LaboInoutController::actionForin | (流程內,無獨立選單) |
3.4 外勞居留、護照
| 圖上概念 | 資料表 | Model | Action | 選單 |
| 居留證 | labo_residence_permit | LabPermit | worker/permit/operation, manage | 居留證作業/列表 |
| 護照 | labo_passport | LabPassport | worker/passport/* | 護照加簽/列表 |
| 人員分頁 | 同上 | LabWorker | actionEditWorker | edit_worker #permit, #passport |
| 舊版居留 | 同上 | LaboResidencePermit | laboArc/admin | legacy |
命名陷阱:worker/permit = 居留證,不是聘僱許可(聘僱許可看 engPermissionLab)。
3.5 入出境泳道
| 圖上狀態 | 資料表 | Controller Action | 選單 → Route |
| 入境 | labo_inout | actionForin, actionForinadmin | 入境作業 → laboInout/forinadmin |
| 預備出境 | 同上 | actionPreForout, actionPreForoutadmin | 預備出境 → laboInout/preforoutadmin |
| 出境 | 同上 | actionForout*, actionForoutmang | 出境作業/待辦 |
| 釋出 | 同上 | actionRelease, actionReleaseadmin | 釋出作業 |
| 轉出/轉入 | lch_TurnOutDate, lch_TurnInDate | actionTurnout | (作業內) |
| 休假/返鄉 | 休假 + labo_inout | worker/vacation/manage | 休假辦理 |
| 指紋 | labo_finger_prn | worker/finger/operation | 指紋按印 |
| 遣返 | — | LabAlert::getBodyNeedOut | 無選單 |
edit_worker.php 分頁 (#inout, #hire, #recruit, #health, #permit, #passport)
LaboInoutController 主要 action:forin, forout, preForout, cancelForout, foroutLeavecheck, foroutVisa, foroutFillrd, foroutQuotaCancel, turnout, extension, release, admin, forinadmin, foroutadmin, releaseadmin, preForoutadmin, foroutmang, delete
3.6 健檢/聘僱許可
| 圖上概念 | 資料表 | Action | 選單 |
| 健檢 | labo_health_chk | worker/body/operation, manage | 體檢作業/列表 |
| 聘僱許可函 | eng_permission_lab | engPermissionLab: admin, receive, turnout | 聘僱許可管理 → engPermissionLab/admin |
| 聘僱到期 | — | eplmExpiry/adminExpiry | 聘僱到期處理 |
| 廢聘/轉出 | labo_quota_cancel | laboQuotaCancel/admin | 廢聘文管理 |
| 工作許可 | labo_work_permit | laboWorkPermit/admin | (另一套,依業務區分) |
3.7 簽證面
| 圖上概念 | 資料表 | Action | 選單 |
| 簽證 | visa_doc | VisaDoc: admin, send, receive, writeOff… | 入國引進許可函 → visaDoc/admin |
| 離境備查 | labo_leave_check | laboLeaveCheck/admin | 離境備查管理 |
| 人員歷史 | 同上 | LabWorker getHisVisa, getHisLeaveCheck | edit_worker #recruit |
3.8 健保/勞保區
| 圖上概念 | 資料表 | 程式位置 | 選單 |
| 健保證號 | com_health_no | ComHealthNoController | 多從 cust/設定進入 |
| 勞保證號 | com_insurance_no | ComInsuranceNoController | 同上 |
| 加保/退保/3合1 | — | AppReport: AddInsur31, CancelInsur31, AddHealthInsur… | 申請報表 → appReport/admin Tab3 |
| 勞保每月投保人數 | com_insured_people_number | comInsuredPeopleNumber/admin | 雇主管理下 |
保險 = 主檔 CRUD + AppReport 列印,無獨立線上加保 API。
3.9 薪資/獎金/代扣款
| 圖上概念 | 資料表 | Action | 選單 |
| 薪資調薪 | labo_salary | laboSalary/admin | 未在 ref_menu |
| 薪資切結/出境薪資單 | — | AppReport SalaryAffidavit, ForoutSalary | appReport/admin |
| 獎金計算 | — | — | 無;最接近授扣書 → report/award/index |
| 代扣款 | debit_record, debit_main | debitmain/admin | 銀行扣款-扣款管理 |
| 外勞帳戶 | labo_account | laboAccount;worker/upload/account | 銀行帳戶上傳 |
| 所得稅 | labo_tax | worker/upload/tax | 所得稅上傳 |
3.10 服務區(收費通知)
| 圖上概念 | 實作對應 | 選單 |
| 收費通知 | account/charge/manage、FeeReport、DebitMain、account/invoice/enable | 費用管理、移工年度費用統計、銀行扣款、開立發票 |
| 雇主服務費 | account/service/* | 雇主服務費群組 |
| 發票 | account/invoice/* | 發票作業群組 |