#!/bin/bash # ============================================================ # SaaS Accounting — Settings Enhancement Deploy Script # Features: # - Inventory Tab (new) # - Accounting Tab updates # - AR & AP Tab (new) # - All guards/toggles as requested # # Run: bash deploy_settings.sh # From: ~/public_html/saas-accounting/ # ============================================================ set -e cd ~/public_html/saas-accounting echo "" echo "==============================================" echo " SaaS Accounting — Settings Enhancement" echo "==============================================" echo "" # ── 1. Update Setting Model defaults ───────────────────────────────────────── echo "Step 1: Updating Setting Model defaults..." cat > app/Models/Setting.php << 'PHPEOF' belongsTo(Company::class); } public static function get(int $companyId, string $key, $default = null) { $cacheKey = "settings_{$companyId}_{$key}"; $sentinel = '__NOT_FOUND__'; $cached = Cache::remember($cacheKey, 3600, function () use ($companyId, $key, $sentinel) { $value = static::where('company_id', $companyId)->where('key', $key)->value('value'); return $value ?? $sentinel; }); return ($cached === $sentinel) ? $default : $cached; } public static function set(int $companyId, string $key, $value): void { static::updateOrCreate( ['company_id' => $companyId, 'key' => $key], ['value' => $value] ); Cache::forget("settings_{$companyId}_{$key}"); } public static function forgetAll(int $companyId): void { foreach (array_keys(static::defaults()) as $key) { Cache::forget("settings_{$companyId}_{$key}"); } } public static function defaults(): array { return [ // General 'fiscal_year_start_month' => '1', 'timezone' => 'UTC', 'date_format' => 'DD/MM/YYYY', 'currency_code' => 'USD', 'currency_symbol' => '$', 'amount_decimals' => '2', 'qty_decimals' => '2', 'rate_decimals' => '4', 'thousand_separator' => ',', 'amount_in_words_language' => 'en', 'max_attachment_size_kb' => '10240', 'autosave_interval_seconds' => '120', // Accounting 'allow_prior_period_posting' => '0', 'prior_period_warning' => '1', 'voucher_approval_required' => '0', 'allow_negative_cash_bank' => '0', // Inventory 'allow_negative_inventory' => '0', 'use_multi_warehouse' => '0', 'use_manufacturing' => '0', 'use_serial_number' => '0', 'use_lot_number' => '0', 'use_fifo_valuation' => '0', 'stock_valuation_method' => 'weighted_average', // AR & AP 'price_level_enabled' => '0', 'customer_aging_basis' => 'invoice_date', 'vendor_aging_basis' => 'bill_date', ]; } } PHPEOF echo " Done." # ── 2. Update CompanySettingsController ─────────────────────────────────────── echo "Step 2: Updating CompanySettingsController..." cat > app/Http/Controllers/Company/Settings/CompanySettingsController.php << 'PHPEOF' user()->company_id; } private function allSettings(): array { $id = $this->companyId(); $rows = Setting::where('company_id', $id)->get()->pluck('value', 'key')->toArray(); return array_merge(Setting::defaults(), $rows); } private function saveSettings(array $data): void { $id = $this->companyId(); foreach ($data as $key => $value) { Setting::set($id, $key, $value); } } // ── General ─────────────────────────────────────────────────────────────── public function general() { $company = auth()->user()->company; $currencies = Currency::where('is_active', true)->orderBy('code')->get(); $settings = $this->allSettings(); $timezones = \DateTimeZone::listIdentifiers(\DateTimeZone::ALL); $symbolMap = $currencies->mapWithKeys(fn($c) => [$c->code => $c->symbol])->toArray(); return view('settings.general', compact('company', 'currencies', 'settings', 'timezones', 'symbolMap')); } public function updateGeneral(Request $request) { $validated = $request->validate([ 'timezone' => 'required|timezone', 'date_format' => 'required|in:DD/MM/YYYY,MM/DD/YYYY,YYYY-MM-DD,DD-MM-YYYY,DD.MM.YYYY', 'currency_code' => 'required|string|size:3', 'currency_symbol' => 'required|string|max:5', 'amount_decimals' => 'required|integer|min:0|max:4', 'qty_decimals' => 'required|integer|min:0|max:4', 'rate_decimals' => 'required|integer|min:0|max:6', 'thousand_separator' => 'required|in:comma,period,space', 'amount_in_words_language' => 'required|in:en,bn', 'company_name' => 'required|string|max:150', 'company_email' => 'nullable|email|max:150', 'company_phone' => 'nullable|string|max:30', 'company_address' => 'nullable|string|max:500', 'company_tax_id' => 'nullable|string|max:50', 'company_website' => 'nullable|url|max:200', 'logo' => 'nullable|image|mimes:png,jpg,jpeg,svg+xml|max:2048', ]); $separatorMap = ['comma' => ',', 'period' => '.', 'space' => ' ']; $validated['thousand_separator'] = $separatorMap[$validated['thousand_separator']]; $settingKeys = ['timezone','date_format','currency_code','currency_symbol', 'amount_decimals','qty_decimals','rate_decimals', 'thousand_separator','amount_in_words_language']; $this->saveSettings(array_intersect_key($validated, array_flip($settingKeys))); $company = auth()->user()->company; $old = $company->only(['name','email','phone','address','tax_id','website']); $company->update([ 'name' => $validated['company_name'], 'email' => $validated['company_email'] ?? null, 'phone' => $validated['company_phone'] ?? null, 'address' => $validated['company_address'] ?? null, 'tax_id' => $validated['company_tax_id'] ?? null, 'website' => $validated['company_website'] ?? null, ]); if ($request->hasFile('logo') && $request->file('logo')->isValid()) { $path = $request->file('logo')->store("logos/{$this->companyId()}", 'public'); $company->update(['logo' => $path]); } AuditLog::record('update', 'settings', null, $old, $company->only(['name','email','phone']), 'General settings updated'); return back()->with('success', 'General settings saved successfully.'); } // ── Accounting ──────────────────────────────────────────────────────────── public function accounting() { $settings = $this->allSettings(); return view('settings.accounting', compact('settings')); } public function updateAccounting(Request $request) { $validated = $request->validate([ 'fiscal_year_start_month' => 'required|integer|min:1|max:12', 'allow_prior_period_posting' => 'required|in:0,1', 'prior_period_warning' => 'required|in:0,1', 'voucher_approval_required' => 'in:0,1', 'allow_negative_cash_bank' => 'in:0,1', ]); // Checkboxes — absent means unchecked = 0 $validated['voucher_approval_required'] = $request->boolean('voucher_approval_required') ? '1' : '0'; $validated['allow_negative_cash_bank'] = $request->boolean('allow_negative_cash_bank') ? '1' : '0'; $this->saveSettings($validated); AuditLog::record('update', 'settings', null, null, $validated, 'Accounting settings updated'); return back()->with('success', 'Accounting settings saved.'); } // ── Inventory ───────────────────────────────────────────────────────────── public function inventory() { $settings = $this->allSettings(); return view('settings.inventory', compact('settings')); } public function updateInventory(Request $request) { $boolKeys = [ 'allow_negative_inventory', 'use_multi_warehouse', 'use_manufacturing', 'use_serial_number', 'use_lot_number', 'use_fifo_valuation', ]; $data = []; foreach ($boolKeys as $key) { $data[$key] = $request->boolean($key) ? '1' : '0'; } // Sync stock_valuation_method with use_fifo_valuation $data['stock_valuation_method'] = $data['use_fifo_valuation'] === '1' ? 'fifo' : 'weighted_average'; $this->saveSettings($data); AuditLog::record('update', 'settings', null, null, $data, 'Inventory settings updated'); return back()->with('success', 'Inventory settings saved.'); } // ── AR & AP ─────────────────────────────────────────────────────────────── public function arap() { $settings = $this->allSettings(); return view('settings.arap', compact('settings')); } public function updateArap(Request $request) { $validated = $request->validate([ 'customer_aging_basis' => 'required|in:invoice_date,due_date', 'vendor_aging_basis' => 'required|in:bill_date,due_date', ]); $validated['price_level_enabled'] = $request->boolean('price_level_enabled') ? '1' : '0'; $this->saveSettings($validated); AuditLog::record('update', 'settings', null, null, $validated, 'AR/AP settings updated'); return back()->with('success', 'AR & AP settings saved.'); } // ── System / Security ───────────────────────────────────────────────────── public function security() { $settings = $this->allSettings(); $subscription = auth()->user()->company->subscription; return view('settings.security', compact('settings', 'subscription')); } public function updateSecurity(Request $request) { $validated = $request->validate([ 'autosave_interval_seconds' => 'required|integer|min:30|max:600', 'max_attachment_size_kb' => 'required|integer|min:256|max:51200', ]); $this->saveSettings($validated); AuditLog::record('update', 'settings', null, null, $validated, 'System settings updated'); return back()->with('success', 'Settings saved successfully.'); } } PHPEOF echo " Done." # ── 3. Update Settings Tabs Partial ────────────────────────────────────────── echo "Step 3: Updating settings tabs..." cat > resources/views/settings/_tabs.blade.php << 'BLADEEOF'
BLADEEOF echo " Done." # ── 4. Rewrite Accounting Settings View ────────────────────────────────────── echo "Step 4: Rewriting Accounting settings view..." cat > resources/views/settings/accounting.blade.php << 'BLADEEOF' @extends('layouts.app') @section('title', 'Accounting Settings') @section('breadcrumb')
  • Dashboard
  • Accounting Settings
    • @endsection @section('content')

    Accounting Settings

    Configure fiscal year and accounting behaviour

    @include('settings._tabs', ['active' => 'accounting']) @if(session('success'))
    {{ session('success') }}
    @endif
    @csrf @method('PUT')
    {{-- Fiscal Year --}}
    Fiscal Year
    Uses virtual closing — no closing journal entries required.
    {{-- Accounting Guards --}}
    Accounting Guards
    {{-- Allow Negative Cash / Bank --}}
    When OFF (recommended): any transaction that would make a Cash or Bank account balance negative is blocked at save time.
    {{-- Voucher Approval --}}
    When ON: vouchers follow Draft → Submitted → Approved → Posted workflow. When OFF: vouchers can be posted directly from Draft.
    Cancel
    @endsection @push('scripts') @endpush BLADEEOF echo " Done." # ── 5. Create Inventory Settings View ──────────────────────────────────────── echo "Step 5: Creating Inventory settings view..." cat > resources/views/settings/inventory.blade.php << 'BLADEEOF' @extends('layouts.app') @section('title', 'Inventory Settings') @section('breadcrumb')
  • Dashboard
  • Inventory Settings
    • @endsection @section('content')

    Inventory Settings

    Configure inventory behaviour, tracking and modules

    @include('settings._tabs', ['active' => 'inventory']) @if(session('success'))
    {{ session('success') }}
    @endif
    @csrf @method('PUT') @php function guardCard(string $id, string $label, string $desc, string $settingKey, array $settings, string $badgeText = '', string $badgeColor = 'warning'): void { $checked = ($settings[$settingKey] ?? '0') === '1'; $border = $checked ? 'border-success-subtle' : 'border-warning-subtle'; $bg = $checked ? 'bg-success-subtle' : 'bg-warning-subtle'; echo <<
    {$desc}
    HTML; } @endphp
    {{-- Inventory Behaviour --}}
    Inventory Behaviour
    {{-- Allow Negative Inventory --}}
    When OFF (recommended): any transaction that would make an inventory item's stock balance negative is blocked. When ON: negative stock is allowed (backorder scenario).
    @if($settings['allow_negative_inventory']==='0')
    Guard is active — negative stock is blocked
    @endif
    {{-- Use FIFO Valuation --}}
    When ON: uses First In, First Out (FIFO) as the default stock valuation method. When OFF: uses Weighted Average Cost (WAC). Can be overridden per item.
    Current method: {{ $settings['use_fifo_valuation']==='1' ? 'FIFO' : 'Weighted Average' }}
    {{-- Optional Modules --}}
    Optional Modules
    {{-- Multi-Warehouse --}}
    When OFF: warehouse selection is hidden from all transaction forms and reports. Enable when you operate from multiple locations.
    {{-- Manufacturing --}}
    When OFF: the Manufacturing menu, Bill of Materials and Production Orders are hidden. Enable for production businesses.
    {{-- Serial Number --}}
    When OFF: serial number fields and reports are hidden. Enable to track individual units by serial number.
    {{-- Lot Number --}}
    When OFF: lot/batch fields and expiry date tracking are hidden. Enable for food, pharma or any batch-tracked products.
    {{-- Summary of active settings --}}
    Active Inventory Configuration
    @php $guards = [ ['allow_negative_inventory', 'Negative Inventory', 'Allowed', 'Blocked (recommended)'], ['use_multi_warehouse', 'Multi-Warehouse', 'Enabled', 'Disabled'], ['use_manufacturing', 'Manufacturing', 'Enabled', 'Disabled'], ['use_serial_number', 'Serial Tracking', 'Enabled', 'Disabled'], ['use_lot_number', 'Lot Tracking', 'Enabled', 'Disabled'], ['use_fifo_valuation', 'FIFO Valuation', 'FIFO', 'Weighted Average'], ]; @endphp @foreach($guards as [$key, $label, $on, $off])
    {{ $label }}: {{ $settings[$key]==='1' ? $on : $off }}
    @endforeach
    Cancel
    @endsection @push('scripts') @endpush BLADEEOF echo " Done." # ── 6. Create AR & AP Settings View ────────────────────────────────────────── echo "Step 6: Creating AR & AP settings view..." cat > resources/views/settings/arap.blade.php << 'BLADEEOF' @extends('layouts.app') @section('title', 'AR & AP Settings') @section('breadcrumb')
  • Dashboard
  • AR & AP Settings
    • @endsection @section('content')

    AR & AP Settings

    Configure Accounts Receivable and Accounts Payable behaviour

    @include('settings._tabs', ['active' => 'arap']) @if(session('success'))
    {{ session('success') }}
    @endif
    @csrf @method('PUT')
    {{-- Pricing --}}
    Pricing
    {{-- Price Levels --}}
    When ON: customers can be assigned different price tiers (e.g. Retail, Wholesale, VIP). Price level fields appear on customer profiles and sales documents. When OFF: all price level features and reports are hidden.
    {{-- Aging Calculation --}}
    Aging Calculation

    Choose whether customer and vendor aging is calculated from the Invoice/Bill Date or the Due Date. Aging reports use this setting. If no Due Date is set, the Invoice/Bill Date is used as a fallback.

    If no Due Date is set on a transaction, the Invoice/Bill Date is used as a fallback. This affects Customer Aging, Vendor Aging, and Overdue reports.
    Cancel
    @endsection @push('scripts') @endpush BLADEEOF echo " Done." # ── 7. Update Routes ────────────────────────────────────────────────────────── echo "Step 7: Adding new settings routes..." # Add inventory and arap routes to web.php python3 << 'PYEOF' content = open('routes/web.php').read() old = """ Route::prefix('settings')->name('settings.')->group(function () { Route::get('/general', [CompanySettingsController::class, 'general'])->name('general'); Route::put('/general', [CompanySettingsController::class, 'updateGeneral'])->name('general.update'); Route::get('/accounting', [CompanySettingsController::class, 'accounting'])->name('accounting'); Route::put('/accounting', [CompanySettingsController::class, 'updateAccounting'])->name('accounting.update'); Route::get('/security', [CompanySettingsController::class, 'security'])->name('security'); Route::put('/security', [CompanySettingsController::class, 'updateSecurity'])->name('security.update'); });""" new = """ Route::prefix('settings')->name('settings.')->group(function () { Route::get('/general', [CompanySettingsController::class, 'general'])->name('general'); Route::put('/general', [CompanySettingsController::class, 'updateGeneral'])->name('general.update'); Route::get('/accounting', [CompanySettingsController::class, 'accounting'])->name('accounting'); Route::put('/accounting', [CompanySettingsController::class, 'updateAccounting'])->name('accounting.update'); Route::get('/inventory', [CompanySettingsController::class, 'inventory'])->name('inventory'); Route::put('/inventory', [CompanySettingsController::class, 'updateInventory'])->name('inventory.update'); Route::get('/arap', [CompanySettingsController::class, 'arap'])->name('arap'); Route::put('/arap', [CompanySettingsController::class, 'updateArap'])->name('arap.update'); Route::get('/security', [CompanySettingsController::class, 'security'])->name('security'); Route::put('/security', [CompanySettingsController::class, 'updateSecurity'])->name('security.update'); });""" content = content.replace(old, new) open('routes/web.php', 'w').write(content) print(" Routes updated.") PYEOF # ── 8. Add settings link to sidebar Admin menu ──────────────────────────────── echo "Step 8: Updating sidebar settings link..." python3 << 'PYEOF' content = open('resources/views/layouts/app.blade.php').read() # Update admin active check to include new settings routes content = content.replace( "$adminActive = request()->routeIs('settings.*','admin.*');", "$adminActive = request()->routeIs('settings.*','admin.*','settings.inventory','settings.arap');" ) open('resources/views/layouts/app.blade.php','w').write(content) print(" Sidebar updated.") PYEOF # ── 9. Clear cache ──────────────────────────────────────────────────────────── echo "Step 9: Clearing and rebuilding cache..." php artisan view:clear php artisan route:clear php artisan config:clear php artisan optimize echo "" echo "==============================================" echo " DEPLOY COMPLETE!" echo "==============================================" echo "" echo " New Settings Tabs:" echo " ✅ General — unchanged" echo " ✅ Accounting — + Negative Cash/Bank guard" echo " + Voucher Approval toggle" echo " ✅ Inventory — NEW TAB with 6 guards:" echo " - Allow Negative Inventory" echo " - Use Multi-Warehouse" echo " - Use Manufacturing" echo " - Use Serial Number" echo " - Use Lot Number" echo " - Use FIFO Valuation" echo " ✅ AR & AP — NEW TAB with:" echo " - Use Price Levels" echo " - Customer Aging Basis" echo " - Vendor Aging Basis" echo " ✅ System — unchanged" echo "" echo " Visit: duiclick.com/settings/inventory" echo " duiclick.com/settings/arap" echo "=============================================="