#!/bin/bash # ============================================================ # SaaS Accounting — Voucher Print Template (QBO style) # Features: # - Professional print layout matching provided template # - Company logo + name + address in header # - Cheque No, Cheque Date, Voucher No, Voucher Date # - Account Name & Code | Memo | Debit | Credit table # - Total row # - Amount in Words # - Dynamic signatory from Company Settings # - Print button triggers print-only view # # Run: bash deploy_voucher_print.sh # From: ~/public_html/saas-accounting/ # ============================================================ set -e cd ~/public_html/saas-accounting echo "" echo "==============================================" echo " Voucher Print Template Deploy" echo "==============================================" echo "" # ── 1. Update show() to pass settings + company ────────────────────────────── echo "Step 1: Updating show() method to pass settings..." python3 << 'PYEOF' content = open('app/Http/Controllers/Company/Accounting/AccountingVouchersController.php').read() old = """ // ── Show ────────────────────────────────────────────────────────────────── public function show(string $voucherType, Voucher $voucher) { $this->validateType($voucherType); $this->gate('vouchers', 'view'); $this->sameCompany($voucher); $voucher->load(['lines.account','lines.taxCode','approvals.user', 'currency','fiscalYear','createdBy','approvedBy','postedBy']); $companyId = auth()->user()->company_id; $approvalReq = Setting::get($companyId, 'voucher_approval_required', '1'); $label = VoucherNumberService::voucherTypes()[$voucherType]; // FIX: Safe access to extra_data $extraData = $voucher->extra_data ?? []; $isReversed = !empty($extraData['reversed_by']); $reversedById = $extraData['reversed_by'] ?? null; return view('accounting.vouchers.show', compact( 'voucher','voucherType','label','approvalReq','isReversed','reversedById' )); }""" new = """ // ── Show ────────────────────────────────────────────────────────────────── public function show(string $voucherType, Voucher $voucher) { $this->validateType($voucherType); $this->gate('vouchers', 'view'); $this->sameCompany($voucher); $voucher->load(['lines.account','lines.taxCode','approvals.user', 'currency','fiscalYear','createdBy','approvedBy','postedBy']); $companyId = auth()->user()->company_id; $approvalReq = Setting::get($companyId, 'voucher_approval_required', '1'); $label = VoucherNumberService::voucherTypes()[$voucherType]; // Safe access to extra_data $extraData = $voucher->extra_data ?? []; $isReversed = !empty($extraData['reversed_by']); $reversedById = $extraData['reversed_by'] ?? null; // Settings for print template $company = auth()->user()->company; $settings = array_merge(\\App\\Models\\Setting::defaults(), \\App\\Models\\Setting::where('company_id', $companyId) ->get()->pluck('value','key')->toArray() ); return view('accounting.vouchers.show', compact( 'voucher','voucherType','label','approvalReq', 'isReversed','reversedById','company','settings' )); }""" content = content.replace(old, new) open('app/Http/Controllers/Company/Accounting/AccountingVouchersController.php', 'w').write(content) print(" Controller updated.") PYEOF # ── 2. Write the new show.blade.php ────────────────────────────────────────── echo "Step 2: Writing new voucher show view with print template..." cat > resources/views/accounting/vouchers/show.blade.php << 'BLADEEOF' @extends('layouts.app') @section('title', $voucher->voucher_number ?? 'Voucher') @section('breadcrumb')
  • Dashboard
  • {{ $label }}
  • {{ $voucher->voucher_number }}
    • @endsection @push('styles') @endpush @section('content') @php [$sbg,$sfg] = $voucher->getStatusColor(); $user = auth()->user(); $totalDebit = $voucher->lines->where('dr_cr','dr')->sum('line_total'); $totalCredit = $voucher->lines->where('dr_cr','cr')->sum('line_total'); $isBalanced = abs($totalDebit - $totalCredit) < 0.01; $extraData = $voucher->extra_data ?? []; $chequeNo = $extraData['cheque_no'] ?? ''; $chequeDate = $extraData['cheque_date'] ?? ''; // Signatory labels from settings $sig1 = $settings['signatory_prepared_by'] ?? 'Prepared By'; $sig2 = $settings['signatory_checked_by'] ?? 'Checked By'; $sig3 = $settings['signatory_custom1'] ?? ''; $sig4 = $settings['signatory_custom2'] ?? ''; $sig5 = $settings['signatory_approved_by'] ?? 'Approved By'; // Amount in words helper function numberToWords(float $num, string $lang = 'en'): string { $ones = ['','One','Two','Three','Four','Five','Six','Seven','Eight','Nine', 'Ten','Eleven','Twelve','Thirteen','Fourteen','Fifteen','Sixteen', 'Seventeen','Eighteen','Nineteen']; $tens = ['','','Twenty','Thirty','Forty','Fifty','Sixty','Seventy','Eighty','Ninety']; $intPart = (int) $num; $decPart = (int) round(($num - $intPart) * 100); function convert(int $n, array $ones, array $tens): string { if ($n === 0) return ''; if ($n < 20) return $ones[$n]; if ($n < 100) return $tens[(int)($n/10)] . ($n%10 ? ' '.$ones[$n%10] : ''); return $ones[(int)($n/100)] . ' Hundred' . ($n%100 ? ' '.convert($n%100,$ones,$tens) : ''); } function convertLarge(int $n, array $ones, array $tens): string { $result = ''; if ($n >= 10000000) { $result .= convert((int)($n/10000000),$ones,$tens).' Crore '; $n %= 10000000; } if ($n >= 100000) { $result .= convert((int)($n/100000), $ones,$tens).' Lakh '; $n %= 100000; } if ($n >= 1000) { $result .= convert((int)($n/1000), $ones,$tens).' Thousand '; $n %= 1000; } if ($n > 0) { $result .= convert($n,$ones,$tens).' '; } return trim($result); } $words = convertLarge($intPart, $ones, $tens); $currency = $settings['currency_code'] ?? 'USD'; if ($currency === 'BDT') { $main='Taka'; $cent='Paisa'; } elseif ($currency === 'GBP') { $main='Pound'; $cent='Pence'; } elseif ($currency === 'EUR') { $main='Euro'; $cent='Cent'; } else { $main='Dollar'; $cent='Cent'; } $result = ($words ?: 'Zero') . ' ' . $main; $result .= ' and ' . ($decPart ? convertLarge($decPart,$ones,$tens) . ' ' . $cent : $cent . ' Zero'); return $result . ' only'; } $amountInWords = numberToWords((float)$voucher->grand_total); @endphp {{-- ═══════════════════════════════════════════════════════════════════════════ --}} {{-- SCREEN VIEW --}} {{-- ═══════════════════════════════════════════════════════════════════════════ --}}
    {{-- Page Header --}}

    {{ $voucher->voucher_number }}

    {{ $label }} — {{ $voucher->voucher_date->format('d M Y') }}

    {{ ucfirst($voucher->status) }} @if($isReversed) Reversed @endif
    @if($voucher->isEditable() && $user->hasPermission('vouchers','edit')) Edit @endif @if($voucher->isDraft() && $user->hasPermission('vouchers','submit'))
    @csrf
    @endif @if($voucher->isSubmitted() && $user->hasPermission('vouchers','approve')) @endif @if(($voucher->isApproved() || ($voucher->isDraft() && !$approvalReq)) && $user->hasPermission('vouchers','post'))
    @csrf
    @endif @if($voucher->isPosted() && !$isReversed && $user->hasPermission('vouchers','post')) @endif @if(!$voucher->isPosted() && !$voucher->isCancelled() && $user->hasPermission('vouchers','cancel')) @endif
    {{-- Screen summary card --}}
    Voucher Details
    Voucher No
    {{ $voucher->voucher_number }}
    Date
    {{ $voucher->voucher_date->format('d M Y') }}
    @if($chequeNo)
    Cheque No
    {{ $chequeNo }}
    @endif @if($chequeDate)
    Cheque Date
    {{ \Carbon\Carbon::parse($chequeDate)->format('d M Y') }}
    @endif @if($voucher->reference)
    Reference
    {{ $voucher->reference }}
    @endif @if($voucher->narration)
    Narration
    {{ $voucher->narration }}
    @endif
    {{-- Lines table --}}
    Journal Lines
    @foreach($voucher->lines as $i => $line) @endforeach
    # Account Description Debit Credit
    {{ $i+1 }}
    {{ $line->account->name ?? '—' }}
    @if($line->account->code ?? false)
    {{ $line->account->code }}
    @endif     		{{ $line->description ?? '' }} {{ $line->dr_cr === 'dr' ? number_format($line->line_total,2) : '' }} {{ $line->dr_cr === 'cr' ? number_format($line->line_total,2) : '' }}
    Total {{ number_format($totalDebit,2) }} {{ number_format($totalCredit,2) }}
    Amount in Words: {{ $amountInWords }}
    {{ $isBalanced ? 'Balanced' : 'Not Balanced' }}
    {{-- Side info --}}
    Workflow
    @if($voucher->createdBy) @endif @if($voucher->approvedBy) @endif @if($voucher->posted_at) @endif
    Status {{ ucfirst($voucher->status) }}
    Created By{{ $voucher->createdBy->name }}
    Approved By{{ $voucher->approvedBy->name }}
    Posted At{{ $voucher->posted_at->format('d M Y H:i') }}
    {{-- end screen-only --}} {{-- ═══════════════════════════════════════════════════════════════════════════ --}} {{-- PRINT AREA — only visible when printing --}} {{-- ═══════════════════════════════════════════════════════════════════════════ --}}
    {{-- Status stamp (cancelled/reversed) --}} @if($voucher->isCancelled())
    CANCELLED
    @elseif($isReversed)
    REVERSED
    @endif {{-- Company Header --}}
    @if($company->logo) @endif

    {{ $company->name }}

    @if($company->address)

    {{ nl2br(e($company->address)) }}

    @endif
    @if($company->phone)
    Tel: {{ $company->phone }}
    @endif @if($company->email)
    {{ $company->email }}
    @endif @if($company->website)
    {{ $company->website }}
    @endif
    {{-- Voucher Title --}}
    {{ $label }}
    {{-- Meta info grid --}}
    @if($chequeNo)
    Check No : {{ $chequeNo }}
    @endif
    Voucher No : {{ $voucher->voucher_number }}
    @if($chequeDate)
    Check Date : {{ \Carbon\Carbon::parse($chequeDate)->format('d-M-y') }}
    @endif
    Voucher Date : {{ $voucher->voucher_date->format('d-M-y') }}
    @if($voucher->reference)
    Reference : {{ $voucher->reference }}
    @endif @if($voucher->narration)
    Narration : {{ $voucher->narration }}
    @endif
    {{-- Lines Table --}} @foreach($voucher->lines as $line) @endforeach
    Account Name & Code Memo Debit Credit
    {{ $line->account->name ?? '—' }} @if($line->account->code ?? false) {{ $line->account->code }} @endif {{ $line->description ?? '' }} @if($line->dr_cr === 'dr') {{ number_format($line->line_total, 2) }} @endif @if($line->dr_cr === 'cr') {{ number_format($line->line_total, 2) }} @endif
    Total {{ number_format($totalDebit, 2) }} {{ number_format($totalCredit, 2) }}
    {{-- Amount in Words --}}
    Amount in word : {{ $amountInWords }}
    {{-- Signatories --}}
    {{ $sig1 ?: 'Prepared By' }}
    {{ $sig2 ?: 'Checked By' }}
    @if($sig3)
    {{ $sig3 }}
    @endif @if($sig4)
    {{ $sig4 }}
    @endif
    {{ $sig5 ?: 'Approved By' }}
    {{-- end print area --}} {{-- ── Modals ────────────────────────────────────────────────────────────────── --}} {{-- Approve --}} {{-- Reject --}} {{-- Reverse --}} {{-- Cancel --}} @endsection BLADEEOF echo " Done." # ── 3. Clear cache ──────────────────────────────────────────────────────────── echo "Step 3: Clearing cache..." php artisan view:clear php artisan optimize echo "" echo "==============================================" echo " DEPLOY COMPLETE!" echo "==============================================" echo "" echo " Print template features:" echo " ✅ Company logo + name + address + contact" echo " ✅ Voucher title (e.g. Bank Payment Voucher)" echo " ✅ Check No / Check Date (bank vouchers)" echo " ✅ Voucher No / Voucher Date" echo " ✅ Reference / Narration" echo " ✅ Account Name & Code | Memo | Debit | Credit" echo " ✅ Total row" echo " ✅ Amount in Words (BDT/USD/GBP/EUR)" echo " ✅ Dynamic signatories from Settings" echo " (Prepared By / Checked By / Custom 1 /" echo " Custom 2 / Approved By)" echo " ✅ CANCELLED / REVERSED stamp on print" echo " ✅ Print button on show page" echo "=============================================="