" . htmlspecialchars($h) . "
" . htmlspecialchars((string)$val) . "

" . htmlspecialchars($h) . "

" . htmlspecialchars((string)$val) . "

query("SELECT * FROM outlets WHERE status = 'active'")->fetchAll(PDO::FETCH_ASSOC); $cur_out = $_SESSION['outlet_id'] ?? 0; $cur_name = 'All Outlets'; foreach ($outlets as $o) { if ($o['id'] == $cur_out) $cur_name = $o['name']; } ?>

0 || $data['stats']['near_expiry_items'] > 0 || $data['stats']['low_stock_items_count'] > 0 || $purchaseAlertsCount > 0): ?>

Administrative Alerts: 0): ?> items have expired. 0): ?> items are expiring soon. 0): ?> items are below minimum level. 0): ?> purchase invoices are due or overdue.

0): ?> View Purchases Expiry Report Low Stock Report

OMR

Total Items

Sales Performance

Recent Customers

View All

Name	Phone	Balance

Quick Links

Sales Tax Invoices Purchase Tax Invoices

Manage Outlets

ID	Name	Address	Phone	Status	Created At	Actions
#

Management

Export to Excel

From Date

To Date

Limit

Name	Tax ID	Email	Phone	Balance	Actions
					Edit Name Email Phone Tax ID / VAT No Balance

Stock Categories Management

Export

ID	Name (EN)	Name (AR)	Actions
			Edit Category Name (EN) Name (AR)

Stock Units Management

Export

Name (EN)	Short (EN)	Name (AR)	Short (AR)	Actions
				Edit Unit Name (EN) Short (EN) Name (AR) Short (AR)

Stock Items ()

Promo Catalog Export to Excel

Limit

Image

SKU

Name

Promotion Details

id="isPromotionToggleEdit" data-id=""> On Promotion?

Start Date

End Date

Percent (%)

Expiry Report

All Expired Near Expiry

SKU	Item Name	Category	Stock Level	Expiry Date	Status
No items found.
					Expired Near Expiry Good

Low Stock Report

SKU	Item Name	Category	Supplier	Min Level	Current Stock	Shortage
All items are above minimum levels.

Loyalty Transaction History

Date	Customer	Tier	Type	Points	Description
No transactions found.
	Current Balance: pts			0 ? '+' : '' ?>

prepare("SELECT * FROM register_sessions WHERE user_id = ? AND status = 'open'"); $stmt->execute([$_SESSION['user_id']]); $active_session = $stmt->fetch(PDO::FETCH_ASSOC); $_SESSION['register_session_id'] = $active_session['id'] ?? null; $registers = db()->query("SELECT * FROM cash_registers WHERE status = 'active'")->fetchAll(); $allow_zero_stock_sell = ($data['settings']['allow_zero_stock_sell'] ?? '1') === '1'; $sql = "SELECT * FROM stock_items ORDER BY name_en ASC"; $products_raw = db()->query($sql)->fetchAll(PDO::FETCH_ASSOC); $products = []; foreach ($products_raw as $p) { $p['original_price'] = (float)$p['sale_price']; $p['sale_price'] = getPromotionalPrice($p); $products[] = $p; } $customers = db()->query("SELECT * FROM customers ORDER BY name ASC")->fetchAll(PDO::FETCH_ASSOC); ?>

OMR OMR

left

Cart

Customer

Discount Code

Cart is empty

Subtotal (Excl. VAT) 0.000

VAT 0.000

Total 0.000

Quotations

Customer

Start Date

End Date

Clear

Limit

prepare("SELECT qi.*, i.name_en, i.name_ar, i.vat_rate FROM quotation_items qi JOIN stock_items i ON qi.item_id = i.id WHERE qi.quotation_id = ?"); $items->execute([$q['id']]); $q['items'] = $items->fetchAll(PDO::FETCH_ASSOC); ?>

Quotation #	Date	Valid Until	Customer	Status	Total	Actions
QUO-					OMR
No quotations found

Local Purchase Orders (LPO)

Supplier

Start Date

End Date

Clear

Limit

prepare("SELECT li.*, i.name_en, i.name_ar, i.vat_rate FROM lpo_items li JOIN stock_items i ON li.item_id = i.id WHERE li.lpo_id = ?"); $items->execute([$q['id']]); $q['items'] = $items->fetchAll(PDO::FETCH_ASSOC); ?>

LPO #	Date	Delivery Date	Supplier	Status	Total	Actions
LPO-					OMR
No LPOs found

VAT:

Report

Date:

: | Period: to

Export to Excel

Start Date

End Date

Clear

Limit

prepare("SELECT ii.*, i.name_en, i.name_ar, i.vat_rate FROM $itemTable ii JOIN stock_items i ON ii.item_id = i.id WHERE ii.$fkCol = ?"); $items->execute([$inv['id']]); $inv['items'] = $items->fetchAll(PDO::FETCH_ASSOC); $prefix = ($page === 'purchases') ? 'PUR' : 'INV'; ?>

Invoice #	Date	Due Date		Status	Total	Paid	Balance	Actions
		---			OMR	OMR	OMR
Totals					OMR	OMR	OMR

-

|
:


		-

Prepared By

Checked By

Authorized Signature

Printed on

Please select an entity and date range to generate the statement.

Cashflow Statement

Period: to

0) $op_inflow += $amt; else $op_outflow += abs($amt); } elseif ($t['other_type'] === 'asset' && !in_array($t['other_account'], ['Accounts Receivable', 'Inventory'])) { // Fixed assets etc if ($amt > 0) $inv_inflow += $amt; else $inv_outflow += abs($amt); } elseif ($t['other_type'] === 'equity' || $t['other_type'] === 'liability') { if ($amt > 0) $fin_inflow += $amt; else $fin_outflow += abs($amt); } else { // Default to operating if unsure if ($amt > 0) $op_inflow += $amt; else $op_outflow += abs($amt); } } ?>

Description	Amount (OMR)
Opening Cash Balance
Operating Activities
Cash Received from Customers & Others
Cash Paid to Suppliers & Expenses	()
Net Cash from Operating Activities
Investing Activities
Net Cash from Investing Activities
Financing Activities
Net Cash from Financing Activities
Net Change in Cash
Closing Cash Balance

___________________
Prepared By

___________________
Approved By

Payment Methods

ID	Name (EN)	Name (AR)	Actions

Expense Categories

ID	Name (EN)	Name (AR)	Actions
			Edit Category Name (EN) Name (AR)

Accounting Module

Journal Accounts Trial Balance P&L Balance Sheet VAT Report

Date	Description	Reference	Amount	Action

Code	Name	Type	Parent	Balance

VAT Summary Report

VAT Input (Purchases)
VAT Output (Sales)
Net VAT Payable / (Refundable)

This report calculates the difference between VAT collected on sales and VAT paid on purchases for the selected period.

Code	Account Name	Debit	Credit

Total

Profit & Loss Statement

Revenue

Total Revenue
Expenses

Total Expenses
Net Profit / Loss

Balance Sheet

Assets


Total Assets

Liabilities & Equity

query("SELECT code FROM acc_accounts WHERE type='revenue' AND parent_id IS NOT NULL")->fetchAll() as $a) $rev += getAccountBalance($a['code']); $exp = 0; foreach(db()->query("SELECT code FROM acc_accounts WHERE type='expense' AND parent_id IS NOT NULL")->fetchAll() as $a) $exp += getAccountBalance($a['code']); $earnings = $rev - $exp; $total_equity += $earnings; ?>

Liabilities

Equity

Retained Earnings (Current)
Total Liab. & Equity

Account	Debit	Credit

Expenses List

Date	Reference	Category	Description	Amount	Actions
				OMR	Edit Expense Category Date Amount Reference No Description <?= htmlspecialchars($exp['description']) ?>

VAT:

Expense Report

Date:

Period: -

Expense Report

Total Expenses

OMR

For the selected period

0 ? ($row['total'] / $data['total_expenses'] * 100) : 0; ?>

Category	Total Amount	% of Total
No expenses found for this period.
	OMR	%

Prepared By

Approved By

VAT:

Sales Returns Report

Date:

Sales Returns

Export

Return #	Date	Invoice #	Customer	Total Amount	Actions
RET-		INV-		OMR
No returns found

Purchase Returns

Export

Return #	Date	Invoice #	Supplier	Total Amount	Actions
PRET-		PUR-		OMR
No returns found

HR Departments

ID	Department Name	Actions

HR Employees

Full Name

Department

Phone

Position

Basic Salary

Biometric ID

Joining Date

Status

Name	Biometric ID	Department	Position	Salary	Status	Actions
				OMR

HR Attendance

Employee	Department	Status	Clock In	Clock Out	Action
		Not Marked

HR Payroll

Employee	Basic	Bonus	Deductions	Net Salary	Status	Actions
	OMR	+ OMR	- OMR	OMR

Biometric Devices

Device Name	IP / IO Address	Port	Serial	Last Sync	Status	Actions
	IP: IO:

POS Devices

Device Name

Device Type

Connection Type

IP Address

Port

Baud Rate

Status

Device Name	Type	Connection	Details	Status	Actions
			: Baud: USB Interface

Profile Picture

Edit Profile

Username

Phone

New Password

Change Profile Picture

Company Profile

Company Name

Phone

VAT Number

Address

Allow Selling Out of Stock

Company Logo

Favicon

Manager Signature

Loyalty Configuration

Loyalty System

Points per 1 OMR

Points for 1 OMR Discount

Role Groups

Manage access levels and permissions

Group Name	Created Date	Status	Actions
		Active	Edit Permissions Edit Role Group Group Name Permissions Global Actions: View Add Edit Delete prepare("SELECT permission FROM role_permissions WHERE role_id = ?"); $stmtP->execute([$group['id']]); $perms = $stmtP->fetchAll(PDO::FETCH_COLUMN); foreach ($permission_groups as $group_name => $modules): ?> Group All $label): ?> Select All >

Customer Display Settings

Greeting Message

Title

Subtitle

Slideshow Images

Upload images for the customer display slideshow (1920x1080 recommended).

Slide 1

Slide 2

Slide 3

Backup Settings

Manual Backup

Create a database backup immediately.

Available Backups

Filename	Size	Date	Actions
No backups found.

User Management

Maintain your team accounts and security

User Info	Access Level	Contact	Status	Actions
ID: #			Active Suspended	Edit Profile Edit User Account Username Email Address Phone Number Assign Role Group Account Status New Password

Cash Registers Management

Define your shop counters and registers.

License Limit: / Registers

ID	Name	Status	Created At	Actions
#				Edit Register Register Name Status

Register Sessions ()

Manage daily opening and closing of cash registers.

prepare("SELECT s.*, r.name as register_name FROM register_sessions s JOIN cash_registers r ON s.register_id = r.id WHERE s.user_id = ? AND s.status = 'open'"); $active_session->execute([$_SESSION['user_id']]); $session = $active_session->fetch(); ?>

Current Open Register: | Opened At: | Opening Balance: OMR

Go to POS

Cashier

Date From

Date To

Clear

prepare("SELECT SUM(CASE WHEN LOWER(payment_method) = 'cash' THEN amount ELSE 0 END) as cash_total, SUM(CASE WHEN LOWER(payment_method) IN ('card', 'credit card', 'visa', 'mastercard') THEN amount ELSE 0 END) as card_total, SUM(CASE WHEN LOWER(payment_method) = 'credit' THEN amount ELSE 0 END) as credit_total, SUM(CASE WHEN LOWER(payment_method) LIKE '%transfer%' OR LOWER(payment_method) LIKE '%bank%' THEN amount ELSE 0 END) as transfer_total, SUM(amount) as total_sales FROM ( SELECT p.payment_method, p.amount FROM pos_payments p JOIN pos_transactions t ON p.transaction_id = t.id WHERE t.register_session_id = ? AND t.status = 'completed' UNION ALL SELECT p.payment_method, p.amount FROM payments p JOIN invoices i ON p.invoice_id = i.id WHERE i.register_session_id = ? AND i.status = 'paid' AND i.is_pos = 1 ) as combined_payments"); $stats_stmt->execute([$s['id'], $s['id']]); $st = $stats_stmt->fetch(); $c_total = (float)($st['cash_total'] ?? 0); $cd_total = (float)($st['card_total'] ?? 0); $cr_total = (float)($st['credit_total'] ?? 0); $tr_total = (float)($st['transfer_total'] ?? 0); $t_sales = (float)($st['total_sales'] ?? 0); $row_expected_cash = (float)$s['opening_balance'] + $c_total; ?>

ID	Register	Cashier	Opened At	Closed At	Opening Bal.	Cash Sale	Credit Card	Credit	Total Sale	Balance	Status	Report
#					OMR	OMR	OMR	OMR	OMR	0 ? 'text-info' : 'text-danger'); ?> OMR ---

Cashier

Opened At

Closed At

prepare("SELECT payment_method, SUM(amount) as total FROM ( SELECT p.payment_method, p.amount FROM pos_payments p JOIN pos_transactions t ON p.transaction_id = t.id WHERE t.register_session_id = ? AND t.status = 'completed' UNION ALL SELECT p.payment_method, p.amount FROM payments p JOIN invoices i ON p.invoice_id = i.id WHERE i.register_session_id = ? AND i.status = 'paid' AND i.is_pos = 1 ) as combined_payments GROUP BY payment_method"); $breakdown->execute([$s['id'], $s['id']]); $methods = $breakdown->fetchAll(); $cash_sales = 0; $card_sales = 0; $credit_sales = 0; $bank_transfer_sales = 0; foreach ($methods as $m) { $method = strtolower($m['payment_method']); if ($method === 'cash') $cash_sales = $m['total']; elseif ($method === 'card' || strpos($method, 'card') !== false) $card_sales = $m['total']; elseif ($method === 'credit') $credit_sales = $m['total']; elseif (strpos($method, 'transfer') !== false || strpos($method, 'bank') !== false) $bank_transfer_sales = $m['total']; else $cash_sales += $m['total']; } $total_sales = $cash_sales + $card_sales + $credit_sales + $bank_transfer_sales; $expected_cash_total = (float)$s['opening_balance'] + $cash_sales; $total_all = (float)$s['opening_balance'] + $total_sales; ?>

Sales Summary

Opening Balance: OMR

prepare("SELECT SUM(vat_amount) as total_tax, SUM(discount_amount) as total_discount, SUM(total_net) as total_net FROM ( SELECT tax_amount as vat_amount, discount_amount, net_amount as total_net FROM pos_transactions WHERE register_session_id = ? AND status = 'completed' UNION ALL SELECT vat_amount, discount_amount, total_with_vat as total_net FROM invoices WHERE register_session_id = ? AND status = 'paid' AND is_pos = 1 ) as combined_totals"); $extra_stmt->execute([$s['id'], $s['id']]); $extra = $extra_stmt->fetch(); ?>

Tax Amount: OMR

Discount: OMR

Cash Sale: OMR

Credit Card: OMR

Credit: OMR

Bank Transfer: OMR

Total Sale: OMR

Cash Reconciliation

Opening Balance: OMR

(+) Cash Sale: OMR

Expected Cash: OMR

Actual Cash: OMR

Balance: OMR

Transaction Details

prepare("SELECT i.*, c.name as customer_name, GROUP_CONCAT(p.payment_method SEPARATOR ', ') as methods FROM invoices i LEFT JOIN payments p ON i.id = p.invoice_id LEFT JOIN customers c ON i.customer_id = c.id WHERE i.register_session_id = ? AND i.status = 'paid' AND i.is_pos = 1 GROUP BY i.id ORDER BY i.created_at DESC"); $txs_stmt->execute([$s['id']]); $txs = $txs_stmt->fetchAll(); foreach ($txs as $tx): ?> prepare("SELECT t.*, c.name as customer_name, GROUP_CONCAT(p.payment_method SEPARATOR ', ') as methods FROM pos_transactions t LEFT JOIN pos_payments p ON t.id = p.transaction_id LEFT JOIN customers c ON t.customer_id = c.id WHERE t.register_session_id = ? AND t.status = 'completed' GROUP BY t.id ORDER BY t.created_at DESC"); $txs_stmt->execute([$s['id']]); $txs = $txs_stmt->fetchAll(); foreach ($txs as $tx): ?>

Time	Order #	Customer	Items	Method	Amount
			prepare("SELECT si.name_en, ii.quantity FROM invoice_items ii JOIN stock_items si ON ii.item_id = si.id WHERE ii.invoice_id = ?"); $items_stmt->execute([$tx['id']]); $items = $items_stmt->fetchAll(); foreach ($items as $item) { echo "" . htmlspecialchars($item['name_en']) . " x " . (float)$item['quantity'] . ""; } ?>
			prepare("SELECT i.name_en, ti.quantity FROM pos_items ti JOIN stock_items i ON ti.item_id = i.id WHERE ti.transaction_id = ?"); $items_stmt->execute([$tx['id']]); $items = $items_stmt->fetchAll(); foreach ($items as $item) { echo "" . htmlspecialchars($item['name_en']) . " x " . (float)$item['quantity'] . ""; } ?>
No transactions

Expected Cash: OMR

Actual Cash: OMR

Notes:

Before closing, please count all cash in your register.

prepare("SELECT payment_method, SUM(amount) as total FROM ( SELECT p.payment_method, p.amount FROM pos_payments p JOIN pos_transactions t ON p.transaction_id = t.id WHERE t.register_session_id = ? AND t.status = 'completed' UNION ALL SELECT p.payment_method, p.amount FROM payments p JOIN invoices i ON p.invoice_id = i.id WHERE i.register_session_id = ? AND i.status = 'paid' AND i.is_pos = 1 ) as combined GROUP BY payment_method"); $curBreakdown->execute([$session['id'], $session['id']]); $curMethods = $curBreakdown->fetchAll(); $cash_sales = 0; $card_sales = 0; $credit_sales = 0; $bank_transfer_sales = 0; foreach ($curMethods as $m) { $method = strtolower($m['payment_method']); if ($method === 'cash') $cash_sales = $m['total']; elseif ($method === 'card' || strpos($method, 'card') !== false) $card_sales = $m['total']; elseif ($method === 'credit') $credit_sales = $m['total']; elseif (strpos($method, 'transfer') !== false || strpos($method, 'bank') !== false) $bank_transfer_sales = $m['total']; else $cash_sales += $m['total']; } $total_sales = $cash_sales + $card_sales + $credit_sales + $bank_transfer_sales; $expected_cash = (float)$session['opening_balance'] + $cash_sales; $total_all = (float)$session['opening_balance'] + $total_sales; ?>

Session Summary

Opening Balance: OMR

Cash Sales: OMR

Credit Card Sales: OMR

Credit: OMR

Bank Transfer: OMR

Total Sales: OMR

Balance (Total): OMR

Expected Cash: OMR

Transaction Details

prepare("SELECT t.*, c.name as customer_name, GROUP_CONCAT(p.payment_method SEPARATOR ', ') as methods FROM pos_transactions t LEFT JOIN pos_payments p ON t.id = p.transaction_id LEFT JOIN customers c ON t.customer_id = c.id WHERE t.register_session_id = ? AND t.status = 'completed' GROUP BY t.id ORDER BY t.created_at DESC"); $txs_stmt->execute([$session['id']]); $txs = $txs_stmt->fetchAll(); foreach ($txs as $tx): ?>

Time	Order #	Customer	Method	Amount

No transactions

Total Cash in Hand (Actual Counted)

Closing Notes / Comments

System Logs

Monitor system activity and errors

--- " . htmlspecialchars(basename($file)) . " ---

"; $lines = shell_exec("tail -n 50 " . escapeshellarg($path)); echo "

" . htmlspecialchars((string)$lines) . "

"; } } if (!$found_logs) { echo "

No accessible log files found.

"; } ?>

Party Name

Return Date

Against Invoice

Returned Items

Item	Returned Qty	Unit Price	Total Price
Total Amount:

Notes

Select Invoice

Return Date

Item	Purchased Qty	Return Qty	Price	Total
Total Return Amount:	0.000

Select Invoice

Return Date

Item	Sold Qty	Return Qty	Price	Total
Total Return Amount:	0.000

Entry Date

Description

Reference

Journal Details

Account	Debit	Credit



Total	0.000	0.000

Date

Due Date

Payment Type

Status

Search Items

Item Details	Qty	Unit Price	VAT	Total
Subtotal				0.000
Total VAT				0.000
Grand Total				0.000

Date

Due Date

Payment Type

Status

Search Items

Item Details	Qty	Unit Price	VAT	Total
Subtotal				0.000
Total VAT				0.000
Grand Total				0.000

Supplier

Date

Delivery Date

Terms & Conditions

Search Items

Item Details	Qty	Unit Price	VAT	Total
Subtotal				0.000
Total VAT				0.000
Grand Total				0.000

Supplier

Date

Delivery Date

Status

Terms

Search Items

Item Details	Qty	Unit Price	VAT	Total
Subtotal				0.000
Total VAT				0.000
Grand Total				0.000

Customer

Date

Valid Until

Search Items

Item Details	Qty	Unit Price	VAT	Total
Subtotal				0.000
Total VAT				0.000
Grand Total				0.000

Customer

Date

Valid Until

Status

Search Items

Item Details	Qty	Unit Price	VAT	Total
Subtotal				0.000
Total VAT				0.000
Grand Total				0.000

VAT:

Tel:

Tax Invoice / فاتورة ضريبية

Invoice No / رقم الفاتورة:

Date / التاريخ:

Status / الحالة:

Bill To / فاتورة إلى

VAT / الضريبة:

Phone / الهاتف:

Payment Details / تفاصيل الدفع

Method / الطريقة:

Currency / العملة: OMR / ريال عماني

Item Description / وصف الصنف	Qty / الكمية	Unit Price / سعر الوحدة	VAT % / الضريبة %	Total / الإجمالي

Amount in Words / المبلغ بالحروف

Terms & Conditions / الشروط والأحكام

Goods once sold will not be taken back or exchanged.
Payment is due within the agreed credit period.

Subtotal (Excl. VAT) / المجموع الفرعي (دون الضريبة)

VAT Amount / مبلغ الضريبة

Grand Total / المجموع الكلي

Payment Tracking / تتبع الدفع

Date / التاريخ	Method / الطريقة	Amount / المبلغ

Paid Amount / المبلغ المدفوع

Balance Due / الرصيد المتبقي

Customer Signature / توقيع العميل

Authorized Signatory / التوقيع المعتمد

Generated by | Visit us at

Customer Walk-in Customer

Amount Due

0.000

Remaining

0.000

Add Payment Method

Cash

Credit Card

Credit

Bank Transfer

Amount

Sales Performance

Recent Customers

Quick Links

Manage Outlets

Add Outlet

Management

Edit

Stock Categories Management

Edit Category

Stock Units Management

Edit Unit

Stock Items ()

Edit Item

Promotion Details

Expiry Report

Low Stock Report

Loyalty Transaction History

Cart

Open Cash Register

Close Cash Register

Quotations

Local Purchase Orders (LPO)

Report

-

Cashflow Statement

Cashflow Statement

Payment Methods

Add Payment Method

Expense Categories

Edit Category

Add Category

Accounting Module

VAT Summary Report

Profit & Loss Statement

Balance Sheet

Assets

Liabilities & Equity

Journal Entry Details

Expenses List

Edit Expense

Add Expense

Expense Report

Expense Report

Total Expenses

OMR

Sales Returns Report

Sales Returns

Purchase Returns

HR Departments

Edit Department

HR Employees

Edit Employee

HR Attendance

Mark Attendance -

Biometric Integration Info

HR Payroll

Generate Payroll

Biometric Devices

Edit Device

Add Biometric Device

POS Devices

Edit Device

Add POS Device

Profile Picture

Edit Profile

Company Profile

Loyalty Configuration

Role Groups

Edit Role Group

Customer Display Settings

Greeting Message

Slideshow Images

Backup Settings

Manual Backup

Available Backups

User Management

Edit User Account

Cash Registers Management

Edit Register

Add Cash Register