📚 ERP Documentation Viewer

Beautiful, colorful documentation for your ERP system

Bill Settings Controller Documentation

File: /controllers/billsettingsController.php

Purpose: Manages bill templates, bill names, and bill configuration settings

Last Updated: December 19, 2024

Total Functions: 11

Lines of Code: ~621

---

📋 Overview

The Bill Settings Controller is the core component for managing bill templates and configurations in the ERP system. It handles:

Primary Functions

Related Controllers

---

🗄️ Database Tables

Primary Tables (Direct Operations)

Table NamePurposeKey Columns
**billname**Bill templates/typesbillnameid, name, billtype, billtype2, ordertype, saveeffect, storeeffect, conditions
**billsettings**Bill configurationsbillsettingsid, billnameid, billpropertyid, billsettingsvalue
**billproperty**Property definitionsbillpropertyid, billpropertyname, propertytype, conditions
### Bill Configuration Fields

Field CategoryPurposeKey Fields
**Basic Settings**Template infoname, billtype, billtype2, ordertype
**Effects**System impactsaveeffect, storeeffect
**POS Integration**Point of saleposFlag, posCode, posType, posWeightPrice
**Payment Methods**FinancialdefVisaAccount, isBankAccountTransfer
**Tax Settings**CalculationstaxOfDiscountVal, taxOfDiscountPrint, taxname
**Discounts**PricingextraDiscountPlace, extraDiscountFixed, extraDiscountPer
**Security**ApprovalgoodsReceiptApproval, checkDigit
**Barcode**Product lookupparcodeType
### Reference Tables

Table NamePurposeRelationship
**bankaccount**Bank accountsbillname.defVisaAccount → bankaccount.accountid
**relusergroupproperties**User permissionsControls bill property access
---

🔧 Key Functions

1. add() - Create New Bill Template

Location: Line 224

Purpose: Create a new bill template with complete property configuration

Function Signature: 

function add()

Parameters (via $_POST):

Process Flow:

┌─────────────────┐ ┌──────────────────┐ ┌─────────────────┐
Validate Input
└─────────────────┘ └──────────────────┘ └─────────────────┘
▼
┌─────────────────┐ ┌──────────────────┐ │
Success Response│◀───│ Save Properties
└─────────────────┘ └──────────────────┘
▼
┌──────────────────┐
Loop Through
Properties (1-N)
└──────────────────┘

2. show() - Display All Bill Templates

Location: Line 316

Purpose: Retrieve and display all bill templates for management

3. edit() - Load Template for Editing

Location: Line 329

Purpose: Load bill template data and associated properties

Parameters:

Returns: Array containing:

4. update() - Update Bill Template

Location: Line 348

Purpose: Update existing bill template and all property settings

Key Features:

5. copyBillSetting() - Duplicate Bill Template

Location: Line 595

Purpose: Create a complete copy of existing bill template

Parameters:

Process Flow:

┌─────────────────┐ ┌──────────────────┐ ┌─────────────────┐
Load Source
Bill & Settings
└─────────────────┘ └──────────────────┘ └─────────────────┘
│
┌─────────▼───────┐ ┌──────────▼──────┐ ┌──────────▼──────┐
Reset Bill ID
to NULL
└─────────────────┘ └─────────────────┘ └─────────────────┘

6. delete() - Soft Delete Template

Location: Line 452

Purpose: Temporarily disable bill template (conditions = 1)

7. ruturndelete() - Restore Template

Location: Line 492

Purpose: Restore soft-deleted bill template

8. execute() - Bulk Operations

Location: Line 524

Purpose: Perform bulk operations on multiple bill templates

Operations:

9. getallBillproperty() - Load Properties

Location: Line 585

Purpose: Retrieve all available bill properties for configuration

---

🔄 Business Logic Flow

Bill Template Creation Workflow

┌─────────────────┐
Bill Type
Selection
└─────────┬───────┘
▼
┌─────────▼───────┐ ┌──────────────────┐
Basic Settings
(Name, Order)
└─────────────────┘ └──────────────────┘
┌─────────▼───────┐ ┌──────────▼──────┐
Payment Methods
(Bank Accounts)
└─────────────────┘ └─────────────────┘
┌─────────▼───────┐ │
Property
Configuration
└─────────────────┘

Property Configuration System

┌─────────────────┐
Bill Properties
(Master List)
└─────────┬───────┘
▼
┌───────────────────────┼───────────────────────┐
│
┌─────▼─────┐ ┌─────────▼────────┐ ┌─────▼─────┐
Display
Settings
└───────────┘ └──────────────────┘ └───────────┘

Bill Type Matrix

Bill TypePurposeStore EffectSave Effect
1Sales BillsDecrease (-)Increase (+)
2Purchase BillsIncrease (+)Decrease (-)
3Return SalesIncrease (+)Decrease (-)
4Return PurchaseDecrease (-)Increase (+)
5Store MovementTransferNo Effect
6QuotationsNo EffectNo Effect
---

⚠️ Common Issues

Property Synchronization

Issue: New properties don't appear in existing bill templates 

// ✅ SOLUTION: Line 342 - queryAllbillsettingsNotDeleted_f()
// Automatically includes new properties with default values

Bank Account Integration

Issue: Payment method configuration requires valid bank accounts 

// ✅ VALIDATION: Lines 101, 157 - Load available bank accounts
$bankAccounts = $bankAccountEX->queryWithOrder2ForVisaPayment();

POS Integration Settings

Issue: Barcode and weight configurations must be consistent

---

🔗 Dependencies

Required DAOs

Required Files

Bill Property Categories

1. Display Properties - UI behavior, field visibility

2. Calculation Properties - Tax, discount, pricing rules

3. Workflow Properties - Approval, validation rules

4. Integration Properties - POS, payment, external systems

5. Security Properties - Access control, audit trails

---

🚀 Performance Notes

The Bill Settings Controller serves as the foundation for all bill processing in the ERP system, providing flexible template-based configuration for diverse business scenarios.

↑