- 개발팀 전용 폴더 dev/ 생성 (standards, guides, quickstart, changes, deploys, data, history, dev_plans 이동)
- 프론트엔드 전용 폴더 frontend/ 생성 (api/ → frontend/api-specs/)
- 기획팀 폴더 requests/ 생성
- plans/ → dev/dev_plans/ 이름 변경
- README.md 신규 (사람용 안내), INDEX.md 재작성 (Claude Code용)
- resources.md 신규 (노션 링크용, assets/brochure 이관 예정)
- CURRENT_WORKS.md 삭제, TODO.md → dev/ 이동
- 전체 참조 경로 업데이트
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
// 월별 5건씩, 총 60건
// 결제수단: transfer(70%), card(15%), cash(10%), check(5%)
$deposits=[// 1월
['date'=>'2025-01-05','client'=>'삼성전자','amount'=>55000000,'method'=>'transfer'],['date'=>'2025-01-10','client'=>'LG전자','amount'=>28000000,'method'=>'transfer'],['date'=>'2025-01-15','client'=>'현대자동차','amount'=>42000000,'method'=>'transfer'],['date'=>'2025-01-20','client'=>'네이버','amount'=>15000000,'method'=>'card'],['date'=>'2025-01-25','client'=>'카카오','amount'=>8500000,'method'=>'transfer'],// 2월
['date'=>'2025-02-05','client'=>'SK하이닉스','amount'=>68000000,'method'=>'transfer'],['date'=>'2025-02-10','client'=>'쿠팡','amount'=>22000000,'method'=>'transfer'],['date'=>'2025-02-15','client'=>'토스','amount'=>9800000,'method'=>'card'],['date'=>'2025-02-20','client'=>'삼성SDS','amount'=>35000000,'method'=>'transfer'],['date'=>'2025-02-25','client'=>'두산에너빌리티','amount'=>48000000,'method'=>'check'],// ... 3월 ~ 12월 (패턴 반복, Seeder에서 자동 생성)
];
3.7 withdrawals (출금) - 60개 예시
// 월별 5건씩, 총 60건
$withdrawals=[// 1월
['date'=>'2025-01-03','client'=>'한화솔루션','amount'=>32000000,'method'=>'transfer'],['date'=>'2025-01-08','client'=>'포스코','amount'=>45000000,'method'=>'transfer'],['date'=>'2025-01-15','client'=>'롯데케미칼','amount'=>18000000,'method'=>'transfer'],['date'=>'2025-01-22','client'=>'GS칼텍스','amount'=>12500000,'method'=>'card'],['date'=>'2025-01-28','client'=>'대한항공','amount'=>5800000,'method'=>'transfer'],// 2월
['date'=>'2025-02-05','client'=>'현대제철','amount'=>52000000,'method'=>'transfer'],['date'=>'2025-02-12','client'=>'SK이노베이션','amount'=>28000000,'method'=>'transfer'],['date'=>'2025-02-18','client'=>'CJ대한통운','amount'=>8500000,'method'=>'transfer'],['date'=>'2025-02-22','client'=>'한화솔루션','amount'=>25000000,'method'=>'check'],['date'=>'2025-02-28','client'=>'포스코','amount'=>38000000,'method'=>'transfer'],// ... 3월 ~ 12월 (패턴 반복)
];
3.8 sales (매출) - 80개 예시
// 월별 6~7건, 총 80건
// 상태: 1~10월 invoiced/confirmed, 11~12월 draft 포함
$sales=[// 1월 (6건)
['number'=>'SAL-202501-0001','date'=>'2025-01-05','client'=>'삼성전자','supply'=>50000000,'status'=>'invoiced'],['number'=>'SAL-202501-0002','date'=>'2025-01-08','client'=>'LG전자','supply'=>25454545,'status'=>'invoiced'],['number'=>'SAL-202501-0003','date'=>'2025-01-12','client'=>'현대자동차','supply'=>38181818,'status'=>'invoiced'],['number'=>'SAL-202501-0004','date'=>'2025-01-18','client'=>'네이버','supply'=>13636364,'status'=>'confirmed'],['number'=>'SAL-202501-0005','date'=>'2025-01-22','client'=>'카카오','supply'=>7727273,'status'=>'confirmed'],['number'=>'SAL-202501-0006','date'=>'2025-01-28','client'=>'삼성SDS','supply'=>31818182,'status'=>'invoiced'],// ... 2월 ~ 10월 (invoiced/confirmed)
// 11월 (8건 - draft 포함)
['number'=>'SAL-202511-0001','date'=>'2025-11-03','client'=>'삼성전자','supply'=>45000000,'status'=>'invoiced'],['number'=>'SAL-202511-0002','date'=>'2025-11-06','client'=>'SK하이닉스','supply'=>62000000,'status'=>'invoiced'],['number'=>'SAL-202511-0003','date'=>'2025-11-10','client'=>'쿠팡','supply'=>18181818,'status'=>'confirmed'],['number'=>'SAL-202511-0004','date'=>'2025-11-14','client'=>'두산에너빌리티','supply'=>55000000,'status'=>'confirmed'],['number'=>'SAL-202511-0005','date'=>'2025-11-18','client'=>'당근마켓','supply'=>8909091,'status'=>'confirmed'],['number'=>'SAL-202511-0006','date'=>'2025-11-22','client'=>'토스','supply'=>12727273,'status'=>'draft'],['number'=>'SAL-202511-0007','date'=>'2025-11-26','client'=>'배달의민족','supply'=>15454545,'status'=>'draft'],['number'=>'SAL-202511-0008','date'=>'2025-11-29','client'=>'LG전자','supply'=>28000000,'status'=>'draft'],// 12월 (7건 - draft 위주)
['number'=>'SAL-202512-0001','date'=>'2025-12-02','client'=>'삼성전자','supply'=>48000000,'status'=>'confirmed'],['number'=>'SAL-202512-0002','date'=>'2025-12-05','client'=>'현대자동차','supply'=>35000000,'status'=>'draft'],['number'=>'SAL-202512-0003','date'=>'2025-12-10','client'=>'네이버','supply'=>22727273,'status'=>'draft'],['number'=>'SAL-202512-0004','date'=>'2025-12-13','client'=>'카카오','supply'=>16363636,'status'=>'draft'],['number'=>'SAL-202512-0005','date'=>'2025-12-17','client'=>'삼성SDS','supply'=>42000000,'status'=>'draft'],['number'=>'SAL-202512-0006','date'=>'2025-12-20','client'=>'SK하이닉스','supply'=>58000000,'status'=>'draft'],['number'=>'SAL-202512-0007','date'=>'2025-12-23','client'=>'쿠팡','supply'=>20000000,'status'=>'draft'],];
3.9 purchases (매입) - 70개 예시
// 월별 5~6건, 총 70건
$purchases=[// 1월 (5건)
['number'=>'PUR-202501-0001','date'=>'2025-01-03','client'=>'한화솔루션','supply'=>29090909,'status'=>'confirmed'],['number'=>'PUR-202501-0002','date'=>'2025-01-10','client'=>'포스코','supply'=>40909091,'status'=>'confirmed'],['number'=>'PUR-202501-0003','date'=>'2025-01-15','client'=>'롯데케미칼','supply'=>16363636,'status'=>'confirmed'],['number'=>'PUR-202501-0004','date'=>'2025-01-22','client'=>'GS칼텍스','supply'=>11363636,'status'=>'confirmed'],['number'=>'PUR-202501-0005','date'=>'2025-01-28','client'=>'대한항공','supply'=>5272727,'status'=>'confirmed'],// ... 2월 ~ 10월 (confirmed)
// 11월 (7건 - draft 포함)
['number'=>'PUR-202511-0001','date'=>'2025-11-03','client'=>'현대제철','supply'=>48000000,'status'=>'confirmed'],['number'=>'PUR-202511-0002','date'=>'2025-11-08','client'=>'SK이노베이션','supply'=>32000000,'status'=>'confirmed'],['number'=>'PUR-202511-0003','date'=>'2025-11-12','client'=>'CJ대한통운','supply'=>9090909,'status'=>'confirmed'],['number'=>'PUR-202511-0004','date'=>'2025-11-18','client'=>'한화솔루션','supply'=>35000000,'status'=>'confirmed'],['number'=>'PUR-202511-0005','date'=>'2025-11-22','client'=>'포스코','supply'=>42000000,'status'=>'draft'],['number'=>'PUR-202511-0006','date'=>'2025-11-26','client'=>'롯데케미칼','supply'=>18181818,'status'=>'draft'],['number'=>'PUR-202511-0007','date'=>'2025-11-29','client'=>'두산에너빌리티','supply'=>55000000,'status'=>'draft'],// 12월 (6건 - draft 위주)
['number'=>'PUR-202512-0001','date'=>'2025-12-02','client'=>'GS칼텍스','supply'=>15454545,'status'=>'confirmed'],['number'=>'PUR-202512-0002','date'=>'2025-12-06','client'=>'대한항공','supply'=>7272727,'status'=>'draft'],['number'=>'PUR-202512-0003','date'=>'2025-12-11','client'=>'현대제철','supply'=>52000000,'status'=>'draft'],['number'=>'PUR-202512-0004','date'=>'2025-12-15','client'=>'SK이노베이션','supply'=>28000000,'status'=>'draft'],['number'=>'PUR-202512-0005','date'=>'2025-12-19','client'=>'한화솔루션','supply'=>38000000,'status'=>'draft'],['number'=>'PUR-202512-0006','date'=>'2025-12-23','client'=>'포스코','supply'=>45000000,'status'=>'draft'],];
3.10 bills (어음) - 30개 예시
// 수취 어음 15건 + 발행 어음 15건, 총 30건
// bill_type: received(수취), issued(발행)
// status (수취): stored, maturityAlert, maturityResult, paymentComplete, dishonored
// status (발행): stored, maturityAlert, collectionRequest, collectionComplete, suing, dishonored
$bills=[// 수취 어음 (received) - 15건
['bill_number'=>'202501000001','type'=>'received','client'=>'삼성전자','amount'=>50000000,'issue_date'=>'2025-01-15','maturity_date'=>'2025-04-15','status'=>'paymentComplete'],['bill_number'=>'202501000002','type'=>'received','client'=>'LG전자','amount'=>35000000,'issue_date'=>'2025-02-10','maturity_date'=>'2025-05-10','status'=>'paymentComplete'],['bill_number'=>'202502000001','type'=>'received','client'=>'SK하이닉스','amount'=>80000000,'issue_date'=>'2025-02-20','maturity_date'=>'2025-05-20','status'=>'paymentComplete'],['bill_number'=>'202503000001','type'=>'received','client'=>'현대자동차','amount'=>45000000,'issue_date'=>'2025-03-05','maturity_date'=>'2025-06-05','status'=>'maturityResult'],['bill_number'=>'202504000001','type'=>'received','client'=>'네이버','amount'=>25000000,'issue_date'=>'2025-04-12','maturity_date'=>'2025-07-12','status'=>'maturityResult'],['bill_number'=>'202505000001','type'=>'received','client'=>'카카오','amount'=>18000000,'issue_date'=>'2025-05-08','maturity_date'=>'2025-08-08','status'=>'stored'],['bill_number'=>'202506000001','type'=>'received','client'=>'쿠팡','amount'=>32000000,'issue_date'=>'2025-06-15','maturity_date'=>'2025-09-15','status'=>'stored'],['bill_number'=>'202507000001','type'=>'received','client'=>'삼성SDS','amount'=>65000000,'issue_date'=>'2025-07-20','maturity_date'=>'2025-10-20','status'=>'stored'],['bill_number'=>'202508000001','type'=>'received','client'=>'토스','amount'=>15000000,'issue_date'=>'2025-08-10','maturity_date'=>'2025-11-10','status'=>'stored'],['bill_number'=>'202509000001','type'=>'received','client'=>'두산에너빌리티','amount'=>55000000,'issue_date'=>'2025-09-05','maturity_date'=>'2025-12-05','status'=>'maturityAlert'],['bill_number'=>'202510000001','type'=>'received','client'=>'삼성전자','amount'=>42000000,'issue_date'=>'2025-10-15','maturity_date'=>'2026-01-15','status'=>'stored'],['bill_number'=>'202511000001','type'=>'received','client'=>'LG전자','amount'=>28000000,'issue_date'=>'2025-11-08','maturity_date'=>'2026-02-08','status'=>'stored'],['bill_number'=>'202511000002','type'=>'received','client'=>'네이버','amount'=>38000000,'issue_date'=>'2025-11-20','maturity_date'=>'2026-02-20','status'=>'stored'],['bill_number'=>'202512000001','type'=>'received','client'=>'현대자동차','amount'=>52000000,'issue_date'=>'2025-12-10','maturity_date'=>'2026-03-10','status'=>'stored'],['bill_number'=>'202512000002','type'=>'received','client'=>'SK하이닉스','amount'=>70000000,'issue_date'=>'2025-12-18','maturity_date'=>'2026-03-18','status'=>'stored'],// 발행 어음 (issued) - 15건
['bill_number'=>'202501100001','type'=>'issued','client'=>'한화솔루션','amount'=>40000000,'issue_date'=>'2025-01-20','maturity_date'=>'2025-04-20','status'=>'collectionComplete'],['bill_number'=>'202502100001','type'=>'issued','client'=>'포스코','amount'=>55000000,'issue_date'=>'2025-02-15','maturity_date'=>'2025-05-15','status'=>'collectionComplete'],['bill_number'=>'202503100001','type'=>'issued','client'=>'롯데케미칼','amount'=>30000000,'issue_date'=>'2025-03-10','maturity_date'=>'2025-06-10','status'=>'collectionComplete'],['bill_number'=>'202504100001','type'=>'issued','client'=>'GS칼텍스','amount'=>22000000,'issue_date'=>'2025-04-18','maturity_date'=>'2025-07-18','status'=>'collectionComplete'],['bill_number'=>'202505100001','type'=>'issued','client'=>'대한항공','amount'=>18000000,'issue_date'=>'2025-05-12','maturity_date'=>'2025-08-12','status'=>'collectionRequest'],['bill_number'=>'202506100001','type'=>'issued','client'=>'현대제철','amount'=>48000000,'issue_date'=>'2025-06-20','maturity_date'=>'2025-09-20','status'=>'collectionRequest'],['bill_number'=>'202507100001','type'=>'issued','client'=>'SK이노베이션','amount'=>35000000,'issue_date'=>'2025-07-15','maturity_date'=>'2025-10-15','status'=>'stored'],['bill_number'=>'202508100001','type'=>'issued','client'=>'CJ대한통운','amount'=>25000000,'issue_date'=>'2025-08-22','maturity_date'=>'2025-11-22','status'=>'stored'],['bill_number'=>'202509100001','type'=>'issued','client'=>'두산에너빌리티','amount'=>60000000,'issue_date'=>'2025-09-10','maturity_date'=>'2025-12-10','status'=>'maturityAlert'],['bill_number'=>'202510100001','type'=>'issued','client'=>'한화솔루션','amount'=>45000000,'issue_date'=>'2025-10-08','maturity_date'=>'2026-01-08','status'=>'stored'],['bill_number'=>'202511100001','type'=>'issued','client'=>'포스코','amount'=>58000000,'issue_date'=>'2025-11-05','maturity_date'=>'2026-02-05','status'=>'stored'],['bill_number'=>'202511100002','type'=>'issued','client'=>'롯데케미칼','amount'=>32000000,'issue_date'=>'2025-11-18','maturity_date'=>'2026-02-18','status'=>'stored'],['bill_number'=>'202512100001','type'=>'issued','client'=>'GS칼텍스','amount'=>28000000,'issue_date'=>'2025-12-05','maturity_date'=>'2026-03-05','status'=>'stored'],['bill_number'=>'202512100002','type'=>'issued','client'=>'현대제철','amount'=>42000000,'issue_date'=>'2025-12-15','maturity_date'=>'2026-03-15','status'=>'stored'],['bill_number'=>'202512100003','type'=>'issued','client'=>'SK이노베이션','amount'=>38000000,'issue_date'=>'2025-12-22','maturity_date'=>'2026-03-22','status'=>'stored'],];// 일부 어음에 차수 관리 내역 추가 (15건)
$billInstallments=[// 수취 어음 차수
['bill_number'=>'202501000001','installments'=>[['date'=>'2025-02-15','amount'=>25000000,'note'=>'1차 분할 입금'],['date'=>'2025-03-15','amount'=>25000000,'note'=>'2차 분할 입금'],]],['bill_number'=>'202502000001','installments'=>[['date'=>'2025-03-20','amount'=>40000000,'note'=>'1차 분할 입금'],['date'=>'2025-04-20','amount'=>40000000,'note'=>'2차 분할 입금'],]],['bill_number'=>'202507000001','installments'=>[['date'=>'2025-08-20','amount'=>30000000,'note'=>'1차 분할 입금'],['date'=>'2025-09-20','amount'=>35000000,'note'=>'2차 분할 입금'],]],// 발행 어음 차수
['bill_number'=>'202501100001','installments'=>[['date'=>'2025-02-20','amount'=>20000000,'note'=>'1차 분할 지급'],['date'=>'2025-03-20','amount'=>20000000,'note'=>'2차 분할 지급'],]],['bill_number'=>'202502100001','installments'=>[['date'=>'2025-03-15','amount'=>27500000,'note'=>'1차 분할 지급'],['date'=>'2025-04-15','amount'=>27500000,'note'=>'2차 분할 지급'],]],['bill_number'=>'202506100001','installments'=>[['date'=>'2025-07-20','amount'=>24000000,'note'=>'1차 분할 지급'],['date'=>'2025-08-20','amount'=>24000000,'note'=>'2차 분할 지급'],]],];
<?php// database/seeders/DummyDataSeeder.php
namespaceDatabase\Seeders;useIlluminate\Database\Seeder;classDummyDataSeederextendsSeeder{// 대상 테넌트 ID
publicconstTENANT_ID=287;// 생성자 사용자 ID
publicconstUSER_ID=1;publicfunctionrun():void{$this->command->info('🌱 더미 데이터 시딩 시작...');$this->command->info(' 대상 테넌트: ID '.self::TENANT_ID);$this->call([Dummy\DummyClientGroupSeeder::class,Dummy\DummyBankAccountSeeder::class,Dummy\DummyClientSeeder::class,Dummy\DummyDepositSeeder::class,Dummy\DummyWithdrawalSeeder::class,Dummy\DummyBillSeeder::class,Dummy\DummySaleSeeder::class,Dummy\DummyPurchaseSeeder::class,]);$this->command->info('');$this->command->info('✅ 더미 데이터 시딩 완료!');$this->command->table(['테이블','생성 수량'],[['client_groups','5'],['bank_accounts','5'],['clients','20'],['deposits','60'],['withdrawals','60'],['bills','30'],['bill_installments','15'],['sales','80'],['purchases','70'],['총계','~345'],]);}}
4.3 실행 방법
# 더미 데이터 시딩
php artisan db:seed --class=DummyDataSeeder
# 특정 Seeder만 실행
php artisan db:seed --class=Database\\Seeders\\Dummy\\DummyClientSeeder
-- 핵심 필드만 기재 (전체 스키마는 마이그레이션 참조)
CREATETABLEclients(idBIGINTUNSIGNEDAUTO_INCREMENTPRIMARYKEY,tenant_idBIGINTUNSIGNEDNOTNULL,client_group_idBIGINTUNSIGNEDNULLCOMMENT'그룹 ID (FK)',client_codeVARCHAR(20)NOTNULLCOMMENT'거래처 코드',nameVARCHAR(100)NOTNULLCOMMENT'거래처명',client_typeVARCHAR(20)NULLCOMMENT'SALES/PURCHASE/BOTH',contact_personVARCHAR(50)NULLCOMMENT'담당자명',phoneVARCHAR(20)NULL,mobileVARCHAR(20)NULL,emailVARCHAR(100)NULL,addressTEXTNULL,business_noVARCHAR(20)NULLCOMMENT'사업자번호',business_typeVARCHAR(50)NULLCOMMENT'업종',business_itemVARCHAR(100)NULLCOMMENT'업태',is_activeBOOLEANDEFAULTTRUE,created_atTIMESTAMPNULL,updated_atTIMESTAMPNULL,deleted_atTIMESTAMPNULL);
CREATETABLEsales(idBIGINTUNSIGNEDAUTO_INCREMENTPRIMARYKEY,tenant_idBIGINTUNSIGNEDNOTNULLCOMMENT'테넌트 ID',sale_numberVARCHAR(30)NOTNULLCOMMENT'매출번호',sale_dateDATENOTNULLCOMMENT'매출일자',client_idBIGINTUNSIGNEDNOTNULLCOMMENT'거래처 ID',supply_amountDECIMAL(15,2)NOTNULLCOMMENT'공급가액',tax_amountDECIMAL(15,2)NOTNULLCOMMENT'세액',total_amountDECIMAL(15,2)NOTNULLCOMMENT'합계',descriptionTEXTNULLCOMMENT'적요',statusVARCHAR(20)DEFAULT'draft'COMMENT'draft/confirmed/invoiced',tax_invoice_idBIGINTUNSIGNEDNULLCOMMENT'세금계산서 ID',deposit_idBIGINTUNSIGNEDNULLCOMMENT'입금 연결 ID',created_byBIGINTUNSIGNEDNULL,updated_byBIGINTUNSIGNEDNULL,deleted_byBIGINTUNSIGNEDNULL,created_atTIMESTAMPNULL,updated_atTIMESTAMPNULL,deleted_atTIMESTAMPNULL,UNIQUEINDEXuk_tenant_sale_number(tenant_id,sale_number));
4.4.7 purchases 테이블
CREATETABLEpurchases(idBIGINTUNSIGNEDAUTO_INCREMENTPRIMARYKEY,tenant_idBIGINTUNSIGNEDNOTNULLCOMMENT'테넌트 ID',purchase_numberVARCHAR(30)NOTNULLCOMMENT'매입번호',purchase_dateDATENOTNULLCOMMENT'매입일자',client_idBIGINTUNSIGNEDNOTNULLCOMMENT'거래처 ID',supply_amountDECIMAL(15,2)NOTNULLCOMMENT'공급가액',tax_amountDECIMAL(15,2)NOTNULLCOMMENT'세액',total_amountDECIMAL(15,2)NOTNULLCOMMENT'합계',descriptionTEXTNULLCOMMENT'적요',statusVARCHAR(20)DEFAULT'draft'COMMENT'draft/confirmed',withdrawal_idBIGINTUNSIGNEDNULLCOMMENT'출금 연결 ID',created_byBIGINTUNSIGNEDNULL,updated_byBIGINTUNSIGNEDNULL,deleted_byBIGINTUNSIGNEDNULL,created_atTIMESTAMPNULL,updated_atTIMESTAMPNULL,deleted_atTIMESTAMPNULL,UNIQUEINDEXuk_tenant_purchase_number(tenant_id,purchase_number));
<?phpnamespaceDatabase\Seeders\Dummy;useApp\Models\Orders\Client;useApp\Models\Orders\ClientGroup;useDatabase\Seeders\DummyDataSeeder;useIlluminate\Database\Seeder;classDummyClientSeederextendsSeeder{publicfunctionrun():void{$tenantId=DummyDataSeeder::TENANT_ID;$userId=DummyDataSeeder::USER_ID;// 그룹 ID 조회
$groups=ClientGroup::where('tenant_id',$tenantId)->pluck('id','group_code')->toArray();// 매출처 (SALES) - 10개
$salesClients=[['code'=>'S001','name'=>'삼성전자','business_no'=>'124-81-00998','group'=>'VIP','contact'=>'김철수','phone'=>'02-1234-5678','email'=>'kim@samsung.com'],['code'=>'S002','name'=>'LG전자','business_no'=>'107-86-14075','group'=>'VIP','contact'=>'이영희','phone'=>'02-2345-6789','email'=>'lee@lg.com'],['code'=>'S003','name'=>'SK하이닉스','business_no'=>'204-81-17169','group'=>'GOLD','contact'=>'박민수','phone'=>'031-123-4567','email'=>'park@skhynix.com'],['code'=>'S004','name'=>'현대자동차','business_no'=>'101-81-05765','group'=>'GOLD','contact'=>'정은지','phone'=>'02-3456-7890','email'=>'jung@hyundai.com'],['code'=>'S005','name'=>'네이버','business_no'=>'220-81-62517','group'=>'GOLD','contact'=>'최준호','phone'=>'031-234-5678','email'=>'choi@naver.com'],['code'=>'S006','name'=>'카카오','business_no'=>'120-87-65763','group'=>'SILVER','contact'=>'강미래','phone'=>'02-4567-8901','email'=>'kang@kakao.com'],['code'=>'S007','name'=>'쿠팡','business_no'=>'120-88-00767','group'=>'SILVER','contact'=>'임도현','phone'=>'02-5678-9012','email'=>'lim@coupang.com'],['code'=>'S008','name'=>'토스','business_no'=>'120-87-83139','group'=>'NORMAL','contact'=>'윤서연','phone'=>'02-6789-0123','email'=>'yoon@toss.im'],['code'=>'S009','name'=>'배달의민족','business_no'=>'220-87-93847','group'=>'NORMAL','contact'=>'한지민','phone'=>'02-7890-1234','email'=>'han@woowahan.com'],['code'=>'S010','name'=>'당근마켓','business_no'=>'815-87-01234','group'=>'NEW','contact'=>'오태양','phone'=>'02-8901-2345','email'=>'oh@daangn.com'],];// 매입처 (PURCHASE) - 7개
$purchaseClients=[['code'=>'P001','name'=>'한화솔루션','business_no'=>'138-81-00610','group'=>null,'contact'=>'김재원','phone'=>'02-1111-2222','email'=>'kim@hanwha.com'],['code'=>'P002','name'=>'포스코','business_no'=>'506-81-08754','group'=>null,'contact'=>'이현석','phone'=>'054-111-2222','email'=>'lee@posco.com'],['code'=>'P003','name'=>'롯데케미칼','business_no'=>'301-81-07123','group'=>null,'contact'=>'박서준','phone'=>'02-2222-3333','email'=>'park@lottechem.com'],['code'=>'P004','name'=>'GS칼텍스','business_no'=>'104-81-23858','group'=>null,'contact'=>'정해인','phone'=>'02-3333-4444','email'=>'jung@gscaltex.com'],['code'=>'P005','name'=>'대한항공','business_no'=>'110-81-14794','group'=>null,'contact'=>'송민호','phone'=>'02-4444-5555','email'=>'song@koreanair.com'],['code'=>'P006','name'=>'현대제철','business_no'=>'130-81-12345','group'=>null,'contact'=>'강동원','phone'=>'032-555-6666','email'=>'kang@hyundaisteel.com'],['code'=>'P007','name'=>'SK이노베이션','business_no'=>'110-81-67890','group'=>null,'contact'=>'유재석','phone'=>'02-6666-7777','email'=>'yoo@skinnovation.com'],];// 매출매입처 (BOTH) - 3개
$bothClients=[['code'=>'B001','name'=>'두산에너빌리티','business_no'=>'124-81-08628','group'=>'GOLD','contact'=>'조인성','phone'=>'02-7777-8888','email'=>'cho@doosan.com'],['code'=>'B002','name'=>'CJ대한통운','business_no'=>'104-81-39849','group'=>'SILVER','contact'=>'공유','phone'=>'02-8888-9999','email'=>'gong@cjlogistics.com'],['code'=>'B003','name'=>'삼성SDS','business_no'=>'124-81-34567','group'=>'VIP','contact'=>'이정재','phone'=>'02-9999-0000','email'=>'lee@samsungsds.com'],];$count=0;// 매출처 생성
foreach($salesClientsas$client){$this->createClient($client,'SALES',$tenantId,$userId,$groups);$count++;}// 매입처 생성
foreach($purchaseClientsas$client){$this->createClient($client,'PURCHASE',$tenantId,$userId,$groups);$count++;}// 매출매입처 생성
foreach($bothClientsas$client){$this->createClient($client,'BOTH',$tenantId,$userId,$groups);$count++;}$this->command->info(' ✓ clients: '.$count.'건 생성');}privatefunctioncreateClient(array$data,string$type,int$tenantId,int$userId,array$groups):void{Client::create(['tenant_id'=>$tenantId,'client_group_id'=>$data['group']?($groups[$data['group']]??null):null,'client_code'=>$data['code'],'name'=>$data['name'],'client_type'=>$type,'contact_person'=>$data['contact'],'phone'=>$data['phone'],'email'=>$data['email'],'business_no'=>$data['business_no'],'business_type'=>'제조업','business_item'=>'전자제품','is_active'=>true,]);}}
4.7.4 DummyDepositSeeder.php
<?phpnamespaceDatabase\Seeders\Dummy;useApp\Models\Orders\Client;useApp\Models\Tenants\BankAccount;useApp\Models\Tenants\Deposit;useDatabase\Seeders\DummyDataSeeder;useIlluminate\Database\Seeder;classDummyDepositSeederextendsSeeder{publicfunctionrun():void{$tenantId=DummyDataSeeder::TENANT_ID;$userId=DummyDataSeeder::USER_ID;// 거래처 매핑 (SALES, BOTH만)
$clients=Client::where('tenant_id',$tenantId)->whereIn('client_type',['SALES','BOTH'])->get()->keyBy('name');// 은행계좌 (대표계좌 우선)
$bankAccounts=BankAccount::where('tenant_id',$tenantId)->where('status','active')->orderByDesc('is_primary')->get();$primaryBankId=$bankAccounts->first()?->id;// 결제수단 분포: transfer(70%), card(15%), cash(10%), check(5%)
$methods=array_merge(array_fill(0,14,'transfer'),array_fill(0,3,'card'),array_fill(0,2,'cash'),array_fill(0,1,'check'));// 거래처 순환 목록
$clientNames=['삼성전자','LG전자','SK하이닉스','현대자동차','네이버','카카오','쿠팡','토스','배달의민족','당근마켓','두산에너빌리티','CJ대한통운','삼성SDS',];// 금액 범위
$amounts=['small'=>[1000000,5000000],// 30%
'medium'=>[5000000,30000000],// 50%
'large'=>[30000000,100000000],// 20%
];$count=0;$year=2025;// 월별 5건씩, 총 60건
for($month=1;$month<=12;$month++){$daysInMonth=cal_days_in_month(CAL_GREGORIAN,$month,$year);for($i=0;$i<5;$i++){$day=rand(1,$daysInMonth);$clientName=$clientNames[($month*5+$i)%count($clientNames)];$client=$clients->get($clientName);// 금액 결정 (분포에 따라)
$rand=rand(1,100);if($rand<=30){$amount=rand($amounts['small'][0],$amounts['small'][1]);}elseif($rand<=80){$amount=rand($amounts['medium'][0],$amounts['medium'][1]);}else{$amount=rand($amounts['large'][0],$amounts['large'][1]);}Deposit::create(['tenant_id'=>$tenantId,'deposit_date'=>sprintf('%04d-%02d-%02d',$year,$month,$day),'client_id'=>$client?->id,'client_name'=>$client?null:$clientName,'bank_account_id'=>$primaryBankId,'amount'=>$amount,'payment_method'=>$methods[array_rand($methods)],'description'=>$clientName.' 입금','created_by'=>$userId,]);$count++;}}$this->command->info(' ✓ deposits: '.$count.'건 생성');}}
4.7.5 DummyWithdrawalSeeder.php
<?phpnamespaceDatabase\Seeders\Dummy;useApp\Models\Orders\Client;useApp\Models\Tenants\BankAccount;useApp\Models\Tenants\Withdrawal;useDatabase\Seeders\DummyDataSeeder;useIlluminate\Database\Seeder;classDummyWithdrawalSeederextendsSeeder{publicfunctionrun():void{$tenantId=DummyDataSeeder::TENANT_ID;$userId=DummyDataSeeder::USER_ID;// 거래처 매핑 (PURCHASE, BOTH만)
$clients=Client::where('tenant_id',$tenantId)->whereIn('client_type',['PURCHASE','BOTH'])->get()->keyBy('name');// 은행계좌
$primaryBankId=BankAccount::where('tenant_id',$tenantId)->where('is_primary',true)->value('id');// 결제수단 분포
$methods=array_merge(array_fill(0,14,'transfer'),array_fill(0,3,'card'),array_fill(0,2,'cash'),array_fill(0,1,'check'));// 매입처 순환 목록
$clientNames=['한화솔루션','포스코','롯데케미칼','GS칼텍스','대한항공','현대제철','SK이노베이션','CJ대한통운','두산에너빌리티',];$amounts=['small'=>[1000000,5000000],'medium'=>[5000000,30000000],'large'=>[30000000,80000000],];$count=0;$year=2025;for($month=1;$month<=12;$month++){$daysInMonth=cal_days_in_month(CAL_GREGORIAN,$month,$year);for($i=0;$i<5;$i++){$day=rand(1,$daysInMonth);$clientName=$clientNames[($month*5+$i)%count($clientNames)];$client=$clients->get($clientName);$rand=rand(1,100);if($rand<=30){$amount=rand($amounts['small'][0],$amounts['small'][1]);}elseif($rand<=80){$amount=rand($amounts['medium'][0],$amounts['medium'][1]);}else{$amount=rand($amounts['large'][0],$amounts['large'][1]);}Withdrawal::create(['tenant_id'=>$tenantId,'withdrawal_date'=>sprintf('%04d-%02d-%02d',$year,$month,$day),'client_id'=>$client?->id,'client_name'=>$client?null:$clientName,'bank_account_id'=>$primaryBankId,'amount'=>$amount,'payment_method'=>$methods[array_rand($methods)],'description'=>$clientName.' 지급','created_by'=>$userId,]);$count++;}}$this->command->info(' ✓ withdrawals: '.$count.'건 생성');}}
4.7.6 DummySaleSeeder.php
<?phpnamespaceDatabase\Seeders\Dummy;useApp\Models\Orders\Client;useApp\Models\Tenants\Sale;useDatabase\Seeders\DummyDataSeeder;useIlluminate\Database\Seeder;classDummySaleSeederextendsSeeder{publicfunctionrun():void{$tenantId=DummyDataSeeder::TENANT_ID;$userId=DummyDataSeeder::USER_ID;// 거래처 매핑 (SALES, BOTH만)
$clients=Client::where('tenant_id',$tenantId)->whereIn('client_type',['SALES','BOTH'])->get()->keyBy('name');$clientNames=['삼성전자','LG전자','SK하이닉스','현대자동차','네이버','카카오','쿠팡','토스','배달의민족','당근마켓','두산에너빌리티','CJ대한통운','삼성SDS',];$amounts=['small'=>[1000000,5000000],'medium'=>[5000000,30000000],'large'=>[30000000,100000000],];// 월별 건수: 1~10월 6~7건, 11월 8건, 12월 7건 = 80건
$monthlyCount=[6,6,7,6,7,6,7,6,7,7,8,7];$count=0;$year=2025;for($month=1;$month<=12;$month++){$daysInMonth=cal_days_in_month(CAL_GREGORIAN,$month,$year);$salesCount=$monthlyCount[$month-1];for($i=0;$i<$salesCount;$i++){$day=(int)(($i+1)*$daysInMonth/($salesCount+1));$day=max(1,min($day,$daysInMonth));$clientName=$clientNames[($count)%count($clientNames)];$client=$clients->get($clientName);// 금액 결정
$rand=rand(1,100);if($rand<=30){$supply=rand($amounts['small'][0],$amounts['small'][1]);}elseif($rand<=80){$supply=rand($amounts['medium'][0],$amounts['medium'][1]);}else{$supply=rand($amounts['large'][0],$amounts['large'][1]);}// 상태 결정: 1~10월 invoiced/confirmed, 11~12월 draft 포함
if($month<=10){$status=rand(0,1)?'invoiced':'confirmed';}elseif($month==11){$status=$i<5?(rand(0,1)?'invoiced':'confirmed'):'draft';}else{$status=$i<1?'confirmed':'draft';}$tax=round($supply*0.1);$total=$supply+$tax;Sale::create(['tenant_id'=>$tenantId,'sale_number'=>sprintf('SAL-%04d%02d-%04d',$year,$month,$i+1),'sale_date'=>sprintf('%04d-%02d-%02d',$year,$month,$day),'client_id'=>$client->id,'supply_amount'=>$supply,'tax_amount'=>$tax,'total_amount'=>$total,'description'=>$clientName.' 매출','status'=>$status,'created_by'=>$userId,]);$count++;}}$this->command->info(' ✓ sales: '.$count.'건 생성');}}
4.7.7 DummyPurchaseSeeder.php
<?phpnamespaceDatabase\Seeders\Dummy;useApp\Models\Orders\Client;useApp\Models\Tenants\Purchase;useDatabase\Seeders\DummyDataSeeder;useIlluminate\Database\Seeder;classDummyPurchaseSeederextendsSeeder{publicfunctionrun():void{$tenantId=DummyDataSeeder::TENANT_ID;$userId=DummyDataSeeder::USER_ID;// 거래처 매핑 (PURCHASE, BOTH만)
$clients=Client::where('tenant_id',$tenantId)->whereIn('client_type',['PURCHASE','BOTH'])->get()->keyBy('name');$clientNames=['한화솔루션','포스코','롯데케미칼','GS칼텍스','대한항공','현대제철','SK이노베이션','CJ대한통운','두산에너빌리티',];$amounts=['small'=>[1000000,5000000],'medium'=>[5000000,30000000],'large'=>[30000000,80000000],];// 월별 건수: 1~10월 5~6건, 11월 7건, 12월 6건 = 70건
$monthlyCount=[5,5,6,5,6,6,6,6,6,6,7,6];$count=0;$year=2025;for($month=1;$month<=12;$month++){$daysInMonth=cal_days_in_month(CAL_GREGORIAN,$month,$year);$purchaseCount=$monthlyCount[$month-1];for($i=0;$i<$purchaseCount;$i++){$day=(int)(($i+1)*$daysInMonth/($purchaseCount+1));$day=max(1,min($day,$daysInMonth));$clientName=$clientNames[($count)%count($clientNames)];$client=$clients->get($clientName);$rand=rand(1,100);if($rand<=30){$supply=rand($amounts['small'][0],$amounts['small'][1]);}elseif($rand<=80){$supply=rand($amounts['medium'][0],$amounts['medium'][1]);}else{$supply=rand($amounts['large'][0],$amounts['large'][1]);}// 상태 결정
if($month<=10){$status='confirmed';}elseif($month==11){$status=$i<4?'confirmed':'draft';}else{$status=$i<1?'confirmed':'draft';}$tax=round($supply*0.1);$total=$supply+$tax;Purchase::create(['tenant_id'=>$tenantId,'purchase_number'=>sprintf('PUR-%04d%02d-%04d',$year,$month,$i+1),'purchase_date'=>sprintf('%04d-%02d-%02d',$year,$month,$day),'client_id'=>$client->id,'supply_amount'=>$supply,'tax_amount'=>$tax,'total_amount'=>$total,'description'=>$clientName.' 매입','status'=>$status,'created_by'=>$userId,]);$count++;}}$this->command->info(' ✓ purchases: '.$count.'건 생성');}}
4.7.8 DummyBillSeeder.php
<?phpnamespaceDatabase\Seeders\Dummy;useApp\Models\Orders\Client;useApp\Models\Tenants\BankAccount;useApp\Models\Tenants\Bill;useApp\Models\Tenants\BillInstallment;useDatabase\Seeders\DummyDataSeeder;useIlluminate\Database\Seeder;classDummyBillSeederextendsSeeder{publicfunctionrun():void{$tenantId=DummyDataSeeder::TENANT_ID;$userId=DummyDataSeeder::USER_ID;// 거래처 매핑
$clients=Client::where('tenant_id',$tenantId)->get()->keyBy('name');// 은행계좌 (대표계좌)
$primaryBankId=BankAccount::where('tenant_id',$tenantId)->where('is_primary',true)->value('id');// 수취 어음 데이터 (received) - 15건
$receivedBills=[['bill_number'=>'202501000001','client'=>'삼성전자','amount'=>50000000,'issue_date'=>'2025-01-15','maturity_date'=>'2025-04-15','status'=>'paymentComplete'],['bill_number'=>'202501000002','client'=>'LG전자','amount'=>35000000,'issue_date'=>'2025-02-10','maturity_date'=>'2025-05-10','status'=>'paymentComplete'],['bill_number'=>'202502000001','client'=>'SK하이닉스','amount'=>80000000,'issue_date'=>'2025-02-20','maturity_date'=>'2025-05-20','status'=>'paymentComplete'],['bill_number'=>'202503000001','client'=>'현대자동차','amount'=>45000000,'issue_date'=>'2025-03-05','maturity_date'=>'2025-06-05','status'=>'maturityResult'],['bill_number'=>'202504000001','client'=>'네이버','amount'=>25000000,'issue_date'=>'2025-04-12','maturity_date'=>'2025-07-12','status'=>'maturityResult'],['bill_number'=>'202505000001','client'=>'카카오','amount'=>18000000,'issue_date'=>'2025-05-08','maturity_date'=>'2025-08-08','status'=>'stored'],['bill_number'=>'202506000001','client'=>'쿠팡','amount'=>32000000,'issue_date'=>'2025-06-15','maturity_date'=>'2025-09-15','status'=>'stored'],['bill_number'=>'202507000001','client'=>'삼성SDS','amount'=>65000000,'issue_date'=>'2025-07-20','maturity_date'=>'2025-10-20','status'=>'stored'],['bill_number'=>'202508000001','client'=>'토스','amount'=>15000000,'issue_date'=>'2025-08-10','maturity_date'=>'2025-11-10','status'=>'stored'],['bill_number'=>'202509000001','client'=>'두산에너빌리티','amount'=>55000000,'issue_date'=>'2025-09-05','maturity_date'=>'2025-12-05','status'=>'maturityAlert'],['bill_number'=>'202510000001','client'=>'삼성전자','amount'=>42000000,'issue_date'=>'2025-10-15','maturity_date'=>'2026-01-15','status'=>'stored'],['bill_number'=>'202511000001','client'=>'LG전자','amount'=>28000000,'issue_date'=>'2025-11-08','maturity_date'=>'2026-02-08','status'=>'stored'],['bill_number'=>'202511000002','client'=>'네이버','amount'=>38000000,'issue_date'=>'2025-11-20','maturity_date'=>'2026-02-20','status'=>'stored'],['bill_number'=>'202512000001','client'=>'현대자동차','amount'=>52000000,'issue_date'=>'2025-12-10','maturity_date'=>'2026-03-10','status'=>'stored'],['bill_number'=>'202512000002','client'=>'SK하이닉스','amount'=>70000000,'issue_date'=>'2025-12-18','maturity_date'=>'2026-03-18','status'=>'stored'],];// 발행 어음 데이터 (issued) - 15건
$issuedBills=[['bill_number'=>'202501100001','client'=>'한화솔루션','amount'=>40000000,'issue_date'=>'2025-01-20','maturity_date'=>'2025-04-20','status'=>'collectionComplete'],['bill_number'=>'202502100001','client'=>'포스코','amount'=>55000000,'issue_date'=>'2025-02-15','maturity_date'=>'2025-05-15','status'=>'collectionComplete'],['bill_number'=>'202503100001','client'=>'롯데케미칼','amount'=>30000000,'issue_date'=>'2025-03-10','maturity_date'=>'2025-06-10','status'=>'collectionComplete'],['bill_number'=>'202504100001','client'=>'GS칼텍스','amount'=>22000000,'issue_date'=>'2025-04-18','maturity_date'=>'2025-07-18','status'=>'collectionComplete'],['bill_number'=>'202505100001','client'=>'대한항공','amount'=>18000000,'issue_date'=>'2025-05-12','maturity_date'=>'2025-08-12','status'=>'collectionRequest'],['bill_number'=>'202506100001','client'=>'현대제철','amount'=>48000000,'issue_date'=>'2025-06-20','maturity_date'=>'2025-09-20','status'=>'collectionRequest'],['bill_number'=>'202507100001','client'=>'SK이노베이션','amount'=>35000000,'issue_date'=>'2025-07-15','maturity_date'=>'2025-10-15','status'=>'stored'],['bill_number'=>'202508100001','client'=>'CJ대한통운','amount'=>25000000,'issue_date'=>'2025-08-22','maturity_date'=>'2025-11-22','status'=>'stored'],['bill_number'=>'202509100001','client'=>'두산에너빌리티','amount'=>60000000,'issue_date'=>'2025-09-10','maturity_date'=>'2025-12-10','status'=>'maturityAlert'],['bill_number'=>'202510100001','client'=>'한화솔루션','amount'=>45000000,'issue_date'=>'2025-10-08','maturity_date'=>'2026-01-08','status'=>'stored'],['bill_number'=>'202511100001','client'=>'포스코','amount'=>58000000,'issue_date'=>'2025-11-05','maturity_date'=>'2026-02-05','status'=>'stored'],['bill_number'=>'202511100002','client'=>'롯데케미칼','amount'=>32000000,'issue_date'=>'2025-11-18','maturity_date'=>'2026-02-18','status'=>'stored'],['bill_number'=>'202512100001','client'=>'GS칼텍스','amount'=>28000000,'issue_date'=>'2025-12-05','maturity_date'=>'2026-03-05','status'=>'stored'],['bill_number'=>'202512100002','client'=>'현대제철','amount'=>42000000,'issue_date'=>'2025-12-15','maturity_date'=>'2026-03-15','status'=>'stored'],['bill_number'=>'202512100003','client'=>'SK이노베이션','amount'=>38000000,'issue_date'=>'2025-12-22','maturity_date'=>'2026-03-22','status'=>'stored'],];// 차수 관리 데이터
$installmentsData=['202501000001'=>[['date'=>'2025-02-15','amount'=>25000000,'note'=>'1차 분할 입금'],['date'=>'2025-03-15','amount'=>25000000,'note'=>'2차 분할 입금'],],'202502000001'=>[['date'=>'2025-03-20','amount'=>40000000,'note'=>'1차 분할 입금'],['date'=>'2025-04-20','amount'=>40000000,'note'=>'2차 분할 입금'],],'202507000001'=>[['date'=>'2025-08-20','amount'=>30000000,'note'=>'1차 분할 입금'],['date'=>'2025-09-20','amount'=>35000000,'note'=>'2차 분할 입금'],],'202501100001'=>[['date'=>'2025-02-20','amount'=>20000000,'note'=>'1차 분할 지급'],['date'=>'2025-03-20','amount'=>20000000,'note'=>'2차 분할 지급'],],'202502100001'=>[['date'=>'2025-03-15','amount'=>27500000,'note'=>'1차 분할 지급'],['date'=>'2025-04-15','amount'=>27500000,'note'=>'2차 분할 지급'],],'202506100001'=>[['date'=>'2025-07-20','amount'=>24000000,'note'=>'1차 분할 지급'],['date'=>'2025-08-20','amount'=>24000000,'note'=>'2차 분할 지급'],],];$billCount=0;$installmentCount=0;// 수취 어음 생성
foreach($receivedBillsas$data){$client=$clients->get($data['client']);$bill=Bill::create(['tenant_id'=>$tenantId,'bill_number'=>$data['bill_number'],'bill_type'=>'received','client_id'=>$client?->id,'client_name'=>$client?null:$data['client'],'amount'=>$data['amount'],'issue_date'=>$data['issue_date'],'maturity_date'=>$data['maturity_date'],'status'=>$data['status'],'is_electronic'=>rand(0,1)===1,'bank_account_id'=>$primaryBankId,'installment_count'=>isset($installmentsData[$data['bill_number']])?count($installmentsData[$data['bill_number']]):0,'created_by'=>$userId,]);$billCount++;// 차수 관리 데이터 추가
if(isset($installmentsData[$data['bill_number']])){foreach($installmentsData[$data['bill_number']]as$instData){BillInstallment::create(['bill_id'=>$bill->id,'installment_date'=>$instData['date'],'amount'=>$instData['amount'],'note'=>$instData['note'],]);$installmentCount++;}}}// 발행 어음 생성
foreach($issuedBillsas$data){$client=$clients->get($data['client']);$bill=Bill::create(['tenant_id'=>$tenantId,'bill_number'=>$data['bill_number'],'bill_type'=>'issued','client_id'=>$client?->id,'client_name'=>$client?null:$data['client'],'amount'=>$data['amount'],'issue_date'=>$data['issue_date'],'maturity_date'=>$data['maturity_date'],'status'=>$data['status'],'is_electronic'=>rand(0,1)===1,'bank_account_id'=>$primaryBankId,'installment_count'=>isset($installmentsData[$data['bill_number']])?count($installmentsData[$data['bill_number']]):0,'created_by'=>$userId,]);$billCount++;// 차수 관리 데이터 추가
if(isset($installmentsData[$data['bill_number']])){foreach($installmentsData[$data['bill_number']]as$instData){BillInstallment::create(['bill_id'=>$bill->id,'installment_date'=>$instData['date'],'amount'=>$instData['amount'],'note'=>$instData['note'],]);$installmentCount++;}}}$this->command->info(' ✓ bills: '.$billCount.'건 생성');$this->command->info(' ✓ bill_installments: '.$installmentCount.'건 생성');}}
5. 데이터 검증
5.1 시딩 후 검증 쿼리
-- 테이블별 데이터 수 확인
SELECT'client_groups'astbl,COUNT(*)ascntFROMclient_groupsWHEREtenant_id=287UNIONALLSELECT'bank_accounts',COUNT(*)FROMbank_accountsWHEREtenant_id=287UNIONALLSELECT'clients',COUNT(*)FROMclientsWHEREtenant_id=287UNIONALLSELECT'deposits',COUNT(*)FROMdepositsWHEREtenant_id=287UNIONALLSELECT'withdrawals',COUNT(*)FROMwithdrawalsWHEREtenant_id=287UNIONALLSELECT'bills',COUNT(*)FROMbillsWHEREtenant_id=287UNIONALLSELECT'bill_installments',COUNT(*)FROMbill_installmentsWHEREbill_idIN(SELECTidFROMbillsWHEREtenant_id=287)UNIONALLSELECT'sales',COUNT(*)FROMsalesWHEREtenant_id=287UNIONALLSELECT'purchases',COUNT(*)FROMpurchasesWHEREtenant_id=287;-- 어음 현황 (수취/발행별)
SELECTbill_type,status,COUNT(*)ascount,SUM(amount)astotal_amountFROMbillsWHEREtenant_id=287GROUPBYbill_type,statusORDERBYbill_type,status;-- 월별 매출 현황
SELECTDATE_FORMAT(sale_date,'%Y-%m')asmonth,COUNT(*)ascount,SUM(total_amount)astotalFROMsalesWHEREtenant_id=287GROUPBYmonthORDERBYmonth;-- 거래처별 매출/매입 합계
SELECTc.name,COALESCE(SUM(s.total_amount),0)astotal_sales,COALESCE(SUM(p.total_amount),0)astotal_purchasesFROMclientscLEFTJOINsalessONc.id=s.client_idANDs.deleted_atISNULLLEFTJOINpurchasespONc.id=p.client_idANDp.deleted_atISNULLWHEREc.tenant_id=287GROUPBYc.id,c.nameORDERBYtotal_salesDESC;
5.2 예상 결과 요약
항목
예상 값
총 거래처
24개 (기존 4 + 신규 20)
총 매출건수
80건
총 매입건수
70건
총 입금건수
60건
총 출금건수
60건
총 어음건수
30건 (수취 15건 + 발행 15건)
총 차수건수
12건 (6개 어음 × 2차)
연간 매출액
약 25~30억원
연간 매입액
약 18~22억원
수취어음 총액
약 6.5억원
발행어음 총액
약 5.8억원
6. 변경 이력
날짜
내용
작성자
2025-12-23
문서 초안 작성
Claude
2025-12-23
1년치 300개 데이터로 확장
Claude
2025-12-23
DB 스키마 상세 정의 추가 (4.4)
Claude
2025-12-23
모델 경로 및 네임스페이스 추가 (4.5)
Claude
2025-12-23
필수 상수값 정의 추가 (4.6)
Claude
2025-12-23
완전한 Seeder 코드 구현 추가 (4.7)
Claude
2025-12-23
어음(bills) 더미 데이터 추가 (30건 + 차수 12건)
Claude
7. 다음 단계
Seeder 파일 구현 → 4.7 섹션에 완전한 코드 포함
Seeder 파일 생성 (코드 복사 후 파일 생성)
시딩 실행 (php artisan db:seed --class=DummyDataSeeder)
권혁성
db63fcff85