🗂️  KEELANCE SAAS - STORAGE MIGRATION
===================================

Found 46 companies in database

📁 CURRENT STORAGE STRUCTURE
===========================
⚠️  contracts: directory not found
⚠️  pdfs: directory not found
⚠️  receipts: directory not found

🔄 MIGRATION PROCESS
====================

🏢 Processing Company: Default Company (ID: 1)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Pixelvise (ID: 2)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Lit Hood (ID: 11)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Illuminati (ID: 12)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: AA (ID: 13)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Armadyne (ID: 15)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Test1 (ID: 16)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: com1 (ID: 17)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Company2 (ID: 18)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Axentra International (ID: 19)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Axentra International (ID: 20)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Axentra International (ID: 21)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: ffff@mail.com (ID: 22)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: TestA (ID: 23)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Test1 (ID: 25)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: CompanyA (ID: 26)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Company1 (ID: 27)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Company4 (ID: 28)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Company3 (ID: 29)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Company5 (ID: 30)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Illu (ID: 33)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Axentra (ID: 34)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: VOID (ID: 35)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: indiancraig (ID: 37)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: uscraig (ID: 38)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: aaaa111111 (ID: 39)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: cccom (ID: 41)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: CompanyA123 (ID: 42)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: testcom123 (ID: 43)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: qqqqqqqqq (ID: 44)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: TEstUSR1 (ID: 45)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: LOLTEST (ID: 46)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: jweiceji (ID: 47)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: LOLTEST2 (ID: 48)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: lol1 (ID: 49)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: fccaidsjsciks (ID: 50)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Arukas (ID: 51)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: dwfwfwffw (ID: 52)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: AAA (ID: 53)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: WWWWWWW (ID: 54)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: geesewgbwgwe (ID: 55)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: hmngdbfdvc (ID: 56)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Test1122 (ID: 57)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: knfkenfkj (ID: 58)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: test123456 (ID: 59)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🏢 Processing Company: Pixelvise Academy (ID: 60)
  ⚠️  contracts: source directory not found
  ⚠️  pdfs: source directory not found
  ⚠️  receipts: source directory not found

🔗 UPDATING DATABASE PATHS
==========================

📝 Updating proposals.pdf_path...
  📊 proposals: 0 records updated

📝 Updating invoices.pdf_path...
  ✅ Record 27: /storage/companies/2/invoices/invoice_27_2025-12-02_05-43-15.pdf → /storage/companies/2/pdfs/invoice_27_2025-12-02_05-43-15.pdf
  ✅ Record 28: /storage/companies/11/invoices/invoice_28_2025-12-02_05-44-01.pdf → /storage/companies/11/pdfs/invoice_28_2025-12-02_05-44-01.pdf
  ✅ Record 29: /storage/companies/2/invoices/invoice_29_2025-12-02_06-08-54.pdf → /storage/companies/2/pdfs/invoice_29_2025-12-02_06-08-54.pdf
  ✅ Record 30: /storage/companies/2/invoices/invoice_30_2025-12-02_08-01-36.pdf → /storage/companies/2/pdfs/invoice_30_2025-12-02_08-01-36.pdf
  ✅ Record 31: /storage/companies/2/invoices/invoice_31_2025-12-03_06-38-05.pdf → /storage/companies/2/pdfs/invoice_31_2025-12-03_06-38-05.pdf
  ✅ Record 33: /storage/companies/34/invoices/invoice_33_2025-12-04_10-58-39.pdf → /storage/companies/34/pdfs/invoice_33_2025-12-04_10-58-39.pdf
  ✅ Record 35: /storage/companies/34/invoices/invoice_35_2025-12-04_16-55-48.pdf → /storage/companies/34/pdfs/invoice_35_2025-12-04_16-55-48.pdf
  ✅ Record 50: /storage/companies/34/invoices/invoice_50_2025-12-05_07-17-18.pdf → /storage/companies/34/pdfs/invoice_50_2025-12-05_07-17-18.pdf
  ✅ Record 51: /storage/companies/34/invoices/invoice_51_2025-12-05_07-17-35.pdf → /storage/companies/34/pdfs/invoice_51_2025-12-05_07-17-35.pdf
  ✅ Record 52: /storage/companies/34/invoices/invoice_52_2025-12-05_07-18-02.pdf → /storage/companies/34/pdfs/invoice_52_2025-12-05_07-18-02.pdf
  ✅ Record 53: /storage/companies/34/invoices/invoice_53_2025-12-05_07-18-19.pdf → /storage/companies/34/pdfs/invoice_53_2025-12-05_07-18-19.pdf
  ✅ Record 54: /storage/companies/34/invoices/invoice_54_2025-12-08_09-16-14.pdf → /storage/companies/34/pdfs/invoice_54_2025-12-08_09-16-14.pdf
  ✅ Record 55: /storage/companies/34/invoices/invoice_55_2025-12-08_09-25-59.pdf → /storage/companies/34/pdfs/invoice_55_2025-12-08_09-25-59.pdf
  ✅ Record 56: /storage/companies/34/invoices/invoice_56_2025-12-08_09-31-35.pdf → /storage/companies/34/pdfs/invoice_56_2025-12-08_09-31-35.pdf
  ✅ Record 57: /storage/companies/34/invoices/invoice_57_2026-01-09_18-28-38.pdf → /storage/companies/34/pdfs/invoice_57_2026-01-09_18-28-38.pdf
  📊 invoices: 15 records updated

📝 Updating contracts.pdf_path...
  ✅ Record 12: /storage/companies/2/contracts/contract_12_v2.pdf → /storage/companies/2/contracts/contract_12_v2.pdf
  ✅ Record 13: /storage/companies/2/contracts/contract_13_v2.pdf → /storage/companies/2/contracts/contract_13_v2.pdf
  ✅ Record 15: /storage/companies/11/contracts/contract_15_v3.pdf → /storage/companies/11/contracts/contract_15_v3.pdf
  ✅ Record 19: /storage/companies/11/contracts/contract_19_v2.pdf → /storage/companies/11/contracts/contract_19_v2.pdf
  ✅ Record 20: /storage/companies/2/contracts/contract_20_v3.pdf → /storage/companies/2/contracts/contract_20_v3.pdf
  ✅ Record 21: /storage/companies/2/contracts/contract_21_v2.pdf → /storage/companies/2/contracts/contract_21_v2.pdf
  ✅ Record 22: /storage/companies/2/contracts/contract_22_v2.pdf → /storage/companies/2/contracts/contract_22_v2.pdf
  ✅ Record 23: /storage/companies/2/contracts/contract_23_v2.pdf → /storage/companies/2/contracts/contract_23_v2.pdf
  ✅ Record 24: /storage/companies/2/contracts/contract_24_v2.pdf → /storage/companies/2/contracts/contract_24_v2.pdf
  ✅ Record 25: /storage/companies/2/contracts/contract_25_v2.pdf → /storage/companies/2/contracts/contract_25_v2.pdf
  ✅ Record 26: /storage/companies/2/contracts/contract_26_v2.pdf → /storage/companies/2/contracts/contract_26_v2.pdf
  ✅ Record 27: /storage/companies/2/contracts/contract_27_v2.pdf → /storage/companies/2/contracts/contract_27_v2.pdf
  ✅ Record 28: /storage/companies/2/contracts/contract_28_v2.pdf → /storage/companies/2/contracts/contract_28_v2.pdf
  ✅ Record 29: /storage/companies/2/contracts/contract_29_v2.pdf → /storage/companies/2/contracts/contract_29_v2.pdf
  ✅ Record 31: /storage/companies/34/contracts/contract_31_v2.pdf → /storage/companies/34/contracts/contract_31_v2.pdf
  ✅ Record 32: /storage/companies/34/contracts/contract_32_v3.pdf → /storage/companies/34/contracts/contract_32_v3.pdf
  ✅ Record 33: /storage/companies/34/contracts/contract_33_v2.pdf → /storage/companies/34/contracts/contract_33_v2.pdf
  ✅ Record 34: /storage/companies/34/contracts/contract_34_v2.pdf → /storage/companies/34/contracts/contract_34_v2.pdf
  ✅ Record 35: /storage/companies/34/contracts/contract_35_v2.pdf → /storage/companies/34/contracts/contract_35_v2.pdf
  ✅ Record 36: /storage/companies/34/contracts/contract_36_v2.pdf → /storage/companies/34/contracts/contract_36_v2.pdf
  ✅ Record 37: /storage/companies/34/contracts/contract_37_v3.pdf → /storage/companies/34/contracts/contract_37_v3.pdf
  📊 contracts: 21 records updated

🧹 CLEANUP OPTIONS
==================
After verifying the migration is successful, you can:
1. Remove old storage directories: rm -rf storage/contracts storage/pdfs storage/receipts
2. Keep them as backup until you're confident everything works
3. Run this script again if you add more companies

✅ STORAGE MIGRATION COMPLETE!
==============================
✅ Company-specific directories created
✅ Files migrated to company folders
✅ Database paths updated
✅ Multi-tenant storage structure ready

🎯 NEW STORAGE STRUCTURE:
========================
storage/
├── companies/
│   ├── 1/ (Company ID 1)
│   │   ├── contracts/
│   │   ├── pdfs/
│   │   ├── receipts/
│   │   ├── proposals/
│   │   ├── invoices/
│   │   ├── logos/
│   │   ├── signatures/
│   │   └── temp/
│   ├── 2/ (Company ID 2)
│   └── ... (other companies)
└── ... (other storage directories)

🚀 NEXT STEPS:
==============
1. Test the platform to ensure all files download correctly
2. Verify PDF generation works for proposals, invoices, and contracts
3. Check that file uploads work properly
4. Remove old storage directories when confident
5. Update any remaining hardcoded paths in custom code

🎉 YOUR MULTI-TENANT STORAGE IS READY!