LibreHatti Models

#Models and their purposes

Catalog App Models:

Category

Products are divided into categories, each category has a parent category. A category whose parent category is null is the root category. One product can only be linked to a single category. All the ancestors of that category automatically get associated with the product.

Product

Product is any thing or service that can be sold on a shop. Each product is linked with it's category and has a fixed price. This model contain attributes that are common to all the products.

Attributes

Each product can have different attributes, Attributes model hosts all the possible attributes that any product can have. Simply put it's a unique list of attributes that any product has or can have.

PurchaseOrder

When you go to a Hatti (shop), you may buy more than a single thing at once. A combination of all those items purchased by a single customer at once is called a purchase_order. Each purchase order is linked with more than one Purchase Items.

PurchasedItem

Each PurchaseOrder can have more than one Purchased Items, model PurchasedItem stores all the items that were ever bought using libreHatti, A purchasedItem can only belong to one purchase order.

Catalog

Catalog model is heart of the LibreHatti Database. It's EAV , EAV stands for Entity Attribute and Value. It links Product (entity) with attribute and value for that attribute. Attribute is specific characteristic of product and value specifies the value of that characteristic.

Surcharge

Surcharge model contains all the fields required to define taxes. Taxes are added in the final bill which is generated. This model includes the name of taxes, their value, validity.

Suspense App Models:

• SuspenseOrder

• SuspenseClearance - Suspense Clearance contains fields which come in a Suspense Job. If a job is a Suspense Job then it lets the user to search Reference/Job No. (existing in the database) and user can fill the information asked in the form generated after search of a job. After submission of form the user has four choices to generate bill i.e. Clearance with Transport, Without Transport, Without Charges and Other Charges.

• Department

• Staff

• TaDa

Bills App Models:

• QuotedOrder It defines all the fields required to place quote order. Quote order is the one which has not been confirmed yet and the user has the option whether to confirm it or not. Each quote order is linked with more than one Quote Items.
• QuotedItem Each QuotedOrder can have more than one Quoted Items, model PurchasedItem. A quotedItem can only belong to one quote order.