HAz Procurement Management System | نظام إدارة المشتريات

📊 Dashboard

📁 Projects

📝 PR

📨 RFQ

📊 Bid Analysis

📋 PO

🏢 Vendors

📥 GRN

🧾 Invoices

📈 Reports

⚙️ Settings

Main Menu

📊 Dashboard

🏗️ Projects

📋 Purchase Requisitions

📨 RFQ Management

📊 Bid Analysis

📄 Purchase Orders

🏢 Vendor Management

📥 Goods Receipt (GRN)

🧾 Invoice Matching

📈 Reports & Analytics

⚙️ Settings

🏗️ المشاريع

جميع المشاريع (اضغط الزر الأخضر ←)

📋

New Requisition

Create purchase request

📨

Send RFQ

Request for quotation

📄

Create PO

Issue purchase order

📥

Receive Goods

Record GRN entry

📋

Pending Requisitions

✓

Approved This Month

📄

Active Purchase Orders

🏢

Registered Vendors

💰

SAR Spent This Month

📥

GRN This Month

📋 Recent Purchase Requisitions

PR Number	Project	Requested By	Amount	Priority	Status	Actions

🔗 Department Integration

🏗️

Projects

● Connected

💰

Finance

● Connected

📦

Warehouse

● Connected

✅

Quality

● Connected

⚡ Recent Activity

No recent activity

Activity will appear here

🏗️ Project Management

Project Code	Project Name	Client	Type	Location	Budget (SAR)	Start Date	End Date	Status	Actions

✓

Active Projects

💰

125M

Total Budget (SAR)

📋

Total PRs

📄

Total POs

📋 Purchase Requisitions

PR Number	Date	Project	Department	Requested By	Total Amount	Priority	Status	Actions

📨 Request for Quotation (RFQ)

RFQ Number	Reference PR	Title	Project	Sent Date	Due Date	Vendors	Responses	Status	Actions

📊 Bid Analysis & Comparison

Select RFQ for Analysis:

📊

Select an RFQ to View Bid Analysis

Choose an RFQ from the dropdown above to compare vendor quotations

📄 Purchase Orders

📋

PR Approved

📨

RFQ Complete

📊

PO Created

✅

Vendor Confirmed

📥

Goods Received

🧾

Invoice Matched

PO Number	Date	Vendor	Project	Total (SAR)	VAT (15%)	Grand Total	Delivery	Status	Actions

🏢 Vendor Management

🏢

No Vendors Yet

Add vendors to start managing your supply chain

📥 Goods Receipt Notes (GRN)

GRN Number	Date	PO Reference	Vendor	Project	Delivery Note	Items	Received By	QC Status	Actions

🧾 Invoice Matching (3-Way Match) | مطابقة الفواتير

Matched | مطابق

Partial | جزئي

Discrepancy | تناقض

Approved | معتمد

📄

Purchase Order

📥

Goods Receipt

🧾

Invoice Received

🔍

3-Way Match

✓

Approved

💳

Payment

Invoice No. \| رقم الفاتورة	Vendor \| المورد	Invoice Date \| التاريخ	PO Reference \| أمر الشراء	GRN Reference \| سند الاستلام	Invoice Amt (SAR)	PO Amt (SAR)	GRN Value (SAR)	Variance \| الفرق	Match Status \| الحالة	Actions \| الإجراءات

💰

SAR 0

Total Procurement Spend / إجمالي الإنفاق

📋

Purchase Orders / أوامر الشراء

⏱️

0 days

Avg. Cycle Time / متوسط الدورة

PR → PO

🏢

Active Vendors / الموردون النشطون

📈 Monthly Procurement Spend / الإنفاق الشهري

🏢 Top Vendors / أكبر الموردين

⏱️ Cycle Time Analysis / تحليل الدورة

💰 Budget vs Actual / الميزانية مقابل الفعلي

📊 Procurement Summary Table / جدول ملخص المشتريات

#	PO Number	Vendor	Project	Date	Amount (SAR)	Status

🔗 Department Integration

🏗️

Projects

● Connected

PRs auto-linked to project budgets and cost centers

💰

Finance

● Connected

3-way matching: PO ↔ GRN ↔ Invoice verification

📦

Warehouse

● Connected

GRN auto-updates inventory stock levels

✅

Quality

● Connected

Quality inspection linked to GRN acceptance workflow

✅ All departments are connected and syncing

Data flows automatically between Procurement, Inventory, Finance, and Project Management modules via localStorage synchronization.

⚙️ System Settings

General

Approval Workflow

Numbering

Notifications

Users & Roles

Company Name

Commercial Registration (CR)

VAT Registration Number

Default Currency

VAT Rate (%)

Fiscal Year Start

Company Address

Purchase Requisition Approval Levels

Level 1: Up to (SAR)

Level 1 Approver

Level 2: Up to (SAR)

Level 2 Approver

Level 3: Above (SAR)

Level 3 Approver

Require dual approval for amounts above SAR 100,000

Document Numbering Format

PR Number Prefix

PR Starting Number

PO Number Prefix

PO Starting Number

RFQ Number Prefix

RFQ Starting Number

GRN Number Prefix

GRN Starting Number

Include year in document numbers (e.g., PR-2026-0001)

Email Notifications

Notify when new PR is created Notify when PR is approved/rejected Notify when PO is issued Notify when goods are received (GRN) Notify when invoice is matched Notify when stock is low

Users Management

Name	Email	Role	Status	Actions
👥 No users added yet. Click "Add User" to get started.

⚠️ Data Management | إدارة البيانات

⚠️ Clearing data will permanently delete all projects, PRs, POs, GRNs, and invoices.

PR Number

Request Date

Project

Department

Priority

Required Date

Purpose / Justification

Line Items

#	Item Description	Unit	Qty	Est. Price (اختياري)	Est. Total
1

Subtotal TBD — السعر غير محدد

VAT (15%) TBD

Estimated Total TBD — يُحدد لاحقاً

PO Number

PO Date

Vendor

Reference RFQ

Reference PR

Project

Delivery Date

Payment Terms

Delivery Address

Order Items

#	Item Description	Unit	Qty	Unit Price	Total

Subtotal SAR 0.00

VAT (15%) SAR 0.00

Grand Total SAR 0.00

GRN Number

Receipt Date

Purchase Order

Vendor

Project

Vendor Delivery Note #

Receiving Warehouse

Received By

Items Received

#	Item Description	PO Qty	Prev Recv	This Recv	Balance	Condition
Select a Purchase Order to load items

Remarks / Notes

Full Name | الاسم الكامل

Email | البريد الإلكتروني

Phone | الهاتف

Role | الدور

Department | القسم

Status | الحالة

Permissions | الصلاحيات

View Projects | عرض المشاريع Create Projects | إنشاء مشاريع View PRs Create PRs Approve PRs Create RFQs | إنشاء طلبات عروض View POs Create POs Create GRNs | إنشاء سندات استلام View Invoices Approve Invoices Manage Vendors

`; const printWindow = window.open('', '_blank', 'width=850,height=700'); printWindow.document.write(printContent); printWindow.document.close(); setTimeout(() => printWindow.print(), 500); } function deleteRecord(id, type) { const confirmMsg = currentLang === 'ar' ? `هل أنت متأكد من حذف ${id}؟ لا يمكن التراجع عن هذا الإجراء.` : `Are you sure you want to delete ${id}? This action cannot be undone.`; if (!confirm(confirmMsg)) { return; } let deleted = false; if (type === 'PR') { const index = DataStore.purchaseRequisitions.findIndex(pr => pr.id === id); if (index > -1) { DataStore.purchaseRequisitions.splice(index, 1); deleted = true; renderPRTable(); } } else if (type === 'RFQ') { const index = DataStore.rfqs.findIndex(r => r.id === id); if (index > -1) { DataStore.rfqs.splice(index, 1); deleted = true; renderRFQTable(); } } else if (type === 'PO') { const index = DataStore.purchaseOrders.findIndex(r => r.id === id); if (index > -1) { DataStore.purchaseOrders.splice(index, 1); deleted = true; renderPOTable(); } } else if (type === 'GRN') { const index = DataStore.grns.findIndex(r => r.id === id); if (index > -1) { DataStore.grns.splice(index, 1); deleted = true; renderGRNTable(); } } else if (type === 'Invoice') { const index = DataStore.invoices.findIndex(r => r.id === id); if (index > -1) { DataStore.invoices.splice(index, 1); deleted = true; renderInvoiceTable(); updateInvoiceStats(); } } if (deleted) { saveAllData(); showToast(`${currentLang === 'ar' ? 'تم حذف' : 'Deleted'} ${id}`, 'success'); } else { showToast(`${currentLang === 'ar' ? 'لم يتم العثور على' : 'Not found:'} ${id}`, 'error'); } } // ========================================== // FORM SUBMISSION HANDLERS // ========================================== function submitPR(asDraft) { try { const prNumberInput = document.getElementById('prNumber'); const prProjectSelect = document.getElementById('prProject'); const prDateInput = document.getElementById('prDate'); const prDepartmentSelect = document.getElementById('prDepartment'); const prPrioritySelect = document.getElementById('prPriority'); const prPurposeTextarea = document.querySelector('#prModal textarea'); const prNumber = prNumberInput ? prNumberInput.value : ''; const project = prProjectSelect ? prProjectSelect.value : ''; const prDate = prDateInput ? prDateInput.value : ''; const department = prDepartmentSelect ? prDepartmentSelect.value : 'Civil Works'; const priority = prPrioritySelect ? prPrioritySelect.value : 'Medium'; const purpose = prPurposeTextarea ? prPurposeTextarea.value : ''; // Validation if (!asDraft) { if (!prNumber) { showToast(currentLang === 'ar' ? 'الرجاء إدخال رقم طلب الشراء' : 'Please enter PR Number', 'error'); return; } // Check for duplicate PR number if (DataStore.purchaseRequisitions.some(pr => pr.id === prNumber)) { showToast(currentLang === 'ar' ? 'رقم طلب الشراء موجود مسبقاً' : 'PR Number already exists. Please use a unique number.', 'error'); return; } if (!project) { showToast(currentLang === 'ar' ? 'الرجاء اختيار المشروع' : 'Please select a project', 'error'); return; } if (!prDate) { showToast(currentLang === 'ar' ? 'الرجاء اختيار التاريخ' : 'Please select a date', 'error'); return; } } // Calculate total amount from line items let totalAmount = 0; const lineItems = []; const lineItemsTable = document.getElementById('prLineItems'); if (lineItemsTable) { const rows = lineItemsTable.querySelectorAll('tr'); rows.forEach(row => { const descInput = row.querySelector('.line-desc'); const unitSelect = row.querySelector('.line-unit'); const qtyInput = row.querySelector('.line-qty'); const priceInput = row.querySelector('.line-price'); if (descInput && qtyInput && priceInput) { const qty = parseFloat(qtyInput.value) || 0; const price = parseFloat(priceInput.value) || 0; const lineTotal = qty * price; totalAmount += lineTotal; if (descInput.value) { lineItems.push({ desc: descInput.value, qty: qty, unit: unitSelect ? unitSelect.value : 'PC', price: price }); } } }); } // If no line items with description, warn user if (lineItems.length === 0 && !asDraft) { showToast(currentLang === 'ar' ? 'الرجاء إضافة بنود بوصف وكمية على الأقل' : 'Please add items with description and quantity', 'error'); return; } // Find the project in DataStore and increment PR count const projectData = DataStore.projects.find(p => p.name === project); if (projectData) { projectData.prs = (projectData.prs || 0) + 1; } // Get current user (simulated) const currentUser = 'Mohamed Ahmed'; const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); // Create new PR object const newPR = { id: prNumber, date: prDate, project: project, department: department, requestedBy: currentUser, priority: priority, status: asDraft ? 'draft' : 'pending', currentStage: asDraft ? 0 : 1, amount: totalAmount, items: lineItems.length > 0 ? lineItems : [{ desc: 'General Items', qty: 1, unit: 'LOT', price: totalAmount }], purpose: purpose, workflow: asDraft ? [ { stage: 'draft', date: dateStr, user: currentUser, notes: currentLang === 'ar' ? 'تم إنشاء الطلب كمسودة' : 'PR created as draft' } ] : [ { stage: 'draft', date: dateStr, user: currentUser, notes: currentLang === 'ar' ? 'تم إنشاء الطلب' : 'PR created' }, { stage: 'pending', date: dateStr, user: currentUser, notes: currentLang === 'ar' ? 'تم إرسال الطلب للموافقة' : 'Submitted for approval' } ], relatedDocs: {} }; // Add to DataStore (counter already incremented in openModal) DataStore.purchaseRequisitions.unshift(newPR); // Add to beginning of array DataStore.prCounter++; saveAllData(); // Auto-save // Close modal closeModal('prModal'); // Show success message const successMsg = asDraft ? (currentLang === 'ar' ? `تم حفظ طلب الشراء ${prNumber} كمسودة` : `Purchase Requisition ${prNumber} saved as draft`) : (currentLang === 'ar' ? `تم إرسال طلب الشراء ${prNumber} للموافقة` : `Purchase Requisition ${prNumber} submitted for approval`); showToast(successMsg, 'success'); // Refresh PR tables renderPRTable(); // Update project summary updateProjectSummary(); // Reset form fields if (prNumberInput) prNumberInput.value = ''; if (prProjectSelect) prProjectSelect.value = ''; if (prDateInput) prDateInput.value = ''; if (prDepartmentSelect) prDepartmentSelect.selectedIndex = 0; if (prPrioritySelect) prPrioritySelect.selectedIndex = 1; // Default to Medium if (prPurposeTextarea) prPurposeTextarea.value = ''; // Reset line items lineItemCounter = 1; if (lineItemsTable) { lineItemsTable.innerHTML = ` 1 `; } // Reset totals const subtotalEl = document.getElementById('prSubtotal'); const vatEl = document.getElementById('prVAT'); const totalEl = document.getElementById('prTotal'); if (subtotalEl) subtotalEl.textContent = 'SAR 0.00'; if (vatEl) vatEl.textContent = 'SAR 0.00'; if (totalEl) totalEl.textContent = 'SAR 0.00'; console.log('New PR added:', prNumber, 'Total PRs:', DataStore.purchaseRequisitions.length); } catch (error) { console.error('Error submitting PR:', error); showToast(currentLang === 'ar' ? 'حدث خطأ أثناء الإرسال' : 'An error occurred while submitting', 'error'); } } function submitRFQ(asDraft) { try { const rfqNumber = document.getElementById('rfqNumber')?.value || ''; const prReference = document.getElementById('rfqPRReference')?.value || ''; const title = document.getElementById('rfqTitle')?.value || ''; const project = document.getElementById('rfqProject')?.value || ''; const dueDate = document.getElementById('rfqDueDate')?.value || ''; const terms = document.getElementById('rfqTerms')?.value || ''; // Get selected vendors const checkedVendors = document.querySelectorAll('#rfqVendorList input[type="checkbox"]:checked'); const vendorList = Array.from(checkedVendors).map(cb => cb.value); // Validation if (!asDraft) { if (!rfqNumber) { showToast(currentLang === 'ar' ? 'الرجاء إدخال رقم طلب العرض' : 'Please enter RFQ Number', 'error'); return; } if (!prReference) { showToast(currentLang === 'ar' ? 'الرجاء اختيار طلب الشراء' : 'Please select a PR', 'error'); return; } if (!title) { showToast(currentLang === 'ar' ? 'الرجاء إدخال عنوان طلب العرض' : 'Please enter RFQ title', 'error'); return; } if (vendorList.length === 0) { showToast(currentLang === 'ar' ? 'الرجاء اختيار مورد واحد على الأقل' : 'Please select at least one vendor', 'error'); return; } } // Get PR data const pr = DataStore.purchaseRequisitions.find(p => p.id === prReference); // Create new RFQ object const today = new Date().toISOString().split('T')[0]; const newRFQ = { id: rfqNumber, prReference: prReference, title: title, project: project || (pr ? pr.project : ''), sentDate: today, dueDate: dueDate, vendorsInvited: vendorList, responses: 0, status: asDraft ? 'draft' : 'open', items: pr ? pr.items : [], terms: terms }; // Increment counter and add to DataStore DataStore.rfqCounter++; DataStore.rfqs.unshift(newRFQ); saveAllData(); // Auto-save // Update PR status if not draft if (!asDraft && pr) { pr.status = 'rfq_sent'; pr.currentStage = 3; pr.relatedDocs.rfq = rfqNumber; const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); pr.workflow.push({ stage: 'rfq_sent', date: dateStr, user: 'Mohamed Ahmed', notes: currentLang === 'ar' ? `تم إرسال ${rfqNumber} إلى ${vendorList.length} موردين` : `${rfqNumber} sent to ${vendorList.length} vendors` }); } // Close modal closeModal('rfqModal'); // Show success message const successMsg = asDraft ? (currentLang === 'ar' ? `تم حفظ طلب العرض ${rfqNumber} كمسودة` : `RFQ ${rfqNumber} saved as draft`) : (currentLang === 'ar' ? `تم إرسال طلب العرض ${rfqNumber} إلى ${vendorList.length} موردين` : `RFQ ${rfqNumber} sent to ${vendorList.length} vendors`); showToast(successMsg, 'success'); // Refresh tables renderRFQTable(); renderPRTable(); // Reset form resetRFQForm(); console.log('New RFQ added:', rfqNumber, 'Total RFQs:', DataStore.rfqs.length); } catch (error) { console.error('Error submitting RFQ:', error); showToast(currentLang === 'ar' ? 'حدث خطأ أثناء الإرسال' : 'An error occurred while submitting', 'error'); } } // Render RFQ Table function renderRFQTable() { const tbody = document.getElementById('rfqTableBody'); if (!tbody) { console.log('RFQ table body not found'); return; } console.log('Rendering RFQ table. Total RFQs:', DataStore.rfqs.length); let html = ''; if (DataStore.rfqs.length === 0) { html = ` ${currentLang === 'ar' ? 'لا توجد طلبات عروض أسعار' : 'No RFQs found'} `; } else { DataStore.rfqs.forEach(rfq => { const statusColors = { 'draft': { color: '#95a5a6', text: currentLang === 'ar' ? 'مسودة' : 'Draft' }, 'open': { color: '#f39c12', text: currentLang === 'ar' ? 'مفتوح' : 'Open' }, 'complete': { color: '#3498db', text: currentLang === 'ar' ? 'مكتمل' : 'Complete' }, 'awarded': { color: '#2bbcb3', text: currentLang === 'ar' ? 'تم الترسية' : 'Awarded' }, 'closed': { color: '#c0392b', text: currentLang === 'ar' ? 'مغلق' : 'Closed' } }; const status = statusColors[rfq.status] || statusColors['open']; const vendorCount = rfq.vendorsInvited ? rfq.vendorsInvited.length : 0; html += ` ${rfq.id} ${rfq.prReference} ${rfq.title} ${rfq.project} ${rfq.sentDate} ${rfq.dueDate} ${vendorCount} ${rfq.responses}/${vendorCount} ${status.text} ${rfq.status === 'complete' ? `` : ''} ${rfq.status === 'awarded' ? `` : ''} `; }); } tbody.innerHTML = html; } // Update available PRs for RFQ dropdown (show approved PRs that don't have RFQ yet) function updateAvailablePRsForRFQ() { const select = document.getElementById('rfqPRReference'); if (!select) return; // Get PRs that are approved or later (currentStage >= 2) and don't have an RFQ yet const availablePRs = DataStore.purchaseRequisitions.filter(pr => { // PR must be approved (stage 2) or later if (pr.currentStage < 2) return false; // PR shouldn't already have an RFQ if (pr.relatedDocs && pr.relatedDocs.rfq) return false; return true; }); const selectText = currentLang === 'ar' ? 'اختر طلب الشراء' : 'Select PR'; let options = ``; availablePRs.forEach(pr => { const itemDesc = pr.items && pr.items[0] ? pr.items[0].desc : ''; options += ``; }); // Also add PRs that already have RFQ for reference const prsWithRFQ = DataStore.purchaseRequisitions.filter(pr => pr.relatedDocs && pr.relatedDocs.rfq); if (prsWithRFQ.length > 0) { options += ``; prsWithRFQ.forEach(pr => { const itemDesc = pr.items && pr.items[0] ? pr.items[0].desc : ''; options += ``; }); options += ``; } select.innerHTML = options; } // Populate RFQ form from selected PR function populateRFQFromPR() { const prId = document.getElementById('rfqPRReference')?.value; if (!prId) { document.getElementById('rfqTitle').value = ''; document.getElementById('rfqProject').value = ''; return; } const pr = DataStore.purchaseRequisitions.find(p => p.id === prId); if (pr) { const itemDesc = pr.items && pr.items[0] ? pr.items[0].desc : ''; document.getElementById('rfqTitle').value = itemDesc || `Materials for ${pr.project}`; document.getElementById('rfqProject').value = pr.project; // Set default due date (7 days from now) const dueDate = new Date(); dueDate.setDate(dueDate.getDate() + 7); document.getElementById('rfqDueDate').value = dueDate.toISOString().split('T')[0]; } } // Reset RFQ Form function resetRFQForm() { document.getElementById('rfqNumber').value = ''; document.getElementById('rfqPRReference').value = ''; document.getElementById('rfqTitle').value = ''; document.getElementById('rfqProject').value = ''; document.getElementById('rfqDueDate').value = ''; document.getElementById('rfqTerms').value = ''; // Uncheck all vendors document.querySelectorAll('#rfqVendorList input[type="checkbox"]').forEach(cb => { cb.checked = false; }); } // View RFQ details function viewRFQ(rfqId) { viewRFQDetails(rfqId); } // Compare quotes - navigate to bid analysis with selected RFQ function compareQuotes(rfqId) { showSection('bidanalysis'); updateBidAnalysisRFQDropdown(); // Set the selected RFQ and load its bid analysis setTimeout(() => { const select = document.getElementById('bidAnalysisRFQSelect'); if (select) { select.value = rfqId; loadBidAnalysis(rfqId); } }, 100); } // Update Bid Analysis RFQ Dropdown function updateBidAnalysisRFQDropdown() { const select = document.getElementById('bidAnalysisRFQSelect'); if (!select) return; const selectText = currentLang === 'ar' ? '-- اختر طلب عرض أسعار --' : '-- Select an RFQ --'; let options = ``; // Group RFQs by status const openRFQs = DataStore.rfqs.filter(r => r.status === 'open' || r.status === 'complete'); const awardedRFQs = DataStore.rfqs.filter(r => r.status === 'awarded'); if (openRFQs.length > 0) { options += ``; openRFQs.forEach(rfq => { options += ``; }); options += ``; } if (awardedRFQs.length > 0) { options += ``; awardedRFQs.forEach(rfq => { options += ``; }); options += ``; } select.innerHTML = options; } // Load Bid Analysis for selected RFQ function loadBidAnalysis(rfqId) { const container = document.getElementById('bidAnalysisContent'); const statusBadge = document.getElementById('bidAnalysisStatus'); if (!rfqId) { container.innerHTML = `

📊

${currentLang === 'ar' ? 'اختر طلب عرض أسعار لعرض التحليل' : 'Select an RFQ to View Bid Analysis'}

${currentLang === 'ar' ? 'اختر طلب عرض أسعار من القائمة أعلاه لمقارنة عروض الموردين' : 'Choose an RFQ from the dropdown above to compare vendor quotations'}

`; statusBadge.innerHTML = ''; return; } const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (!rfq) { container.innerHTML = `

RFQ not found

`; return; } // Status badge const statusColors = { 'open': { color: '#f39c12', text: currentLang === 'ar' ? 'مفتوح' : 'Open' }, 'complete': { color: '#3498db', text: currentLang === 'ar' ? 'مكتمل' : 'Complete' }, 'awarded': { color: '#2bbcb3', text: currentLang === 'ar' ? 'تم الترسية' : 'Awarded' } }; const status = statusColors[rfq.status] || statusColors['open']; statusBadge.innerHTML = `${status.text}`; // Get vendors const vendors = rfq.vendorsInvited || []; const quotations = rfq.quotations || {}; // Count submitted quotations const submittedCount = Object.keys(quotations).filter(v => quotations[v]?.submitted).length; // Build vendor bids array with actual or placeholder data const vendorBids = vendors.map((vendor, idx) => { const quote = quotations[vendor]; if (quote && quote.submitted) { // Use actual quotation data return { name: vendor, price: quote.price, delivery: quote.delivery, warranty: quote.warranty || 1, notes: quote.notes || '', submitted: true, // Calculate score based on actual data rating: 4.5 // Base rating, could be from vendor master data }; } else { // No quotation submitted yet return { name: vendor, price: null, delivery: null, warranty: null, notes: '', submitted: false, rating: null }; } }); // Calculate weighted scores for submitted quotations const submittedBids = vendorBids.filter(b => b.submitted); if (submittedBids.length > 0) { const minPrice = Math.min(...submittedBids.map(b => b.price)); const maxPrice = Math.max(...submittedBids.map(b => b.price)); const minDelivery = Math.min(...submittedBids.map(b => b.delivery)); const maxDelivery = Math.max(...submittedBids.map(b => b.delivery)); const maxWarranty = Math.max(...submittedBids.map(b => b.warranty)); submittedBids.forEach(bid => { // Price score (lower is better) - 40% weight const priceRange = maxPrice - minPrice || 1; const priceScore = ((maxPrice - bid.price) / priceRange) * 40; // Delivery score (lower is better) - 25% weight const deliveryRange = maxDelivery - minDelivery || 1; const deliveryScore = ((maxDelivery - bid.delivery) / deliveryRange) * 25; // Warranty score (higher is better) - 15% weight const warrantyScore = (bid.warranty / maxWarranty) * 15; // Vendor rating score - 20% weight const ratingScore = (bid.rating / 5) * 20; bid.score = (priceScore + deliveryScore + warrantyScore + ratingScore).toFixed(1); }); // Sort by score submittedBids.sort((a, b) => parseFloat(b.score) - parseFloat(a.score)); } const winner = submittedBids.length > 0 ? submittedBids[0] : null; // Build table headers with edit buttons let vendorHeaders = vendors.map(v => { const hasQuote = quotations[v]?.submitted; return `

${v}

`; }).join(''); // Build price row let priceRow = vendors.map(v => { const bid = vendorBids.find(b => b.name === v); if (!bid.submitted) { return ` ${currentLang === 'ar' ? 'لم يرد' : 'Not submitted'} `; } const isLowest = submittedBids.length > 0 && bid.price === Math.min(...submittedBids.map(b => b.price)); return ` SAR ${bid.price.toLocaleString()} ${isLowest ? '✓' : ''} `; }).join(''); // Build delivery row let deliveryRow = vendors.map(v => { const bid = vendorBids.find(b => b.name === v); if (!bid.submitted) { return `-`; } const isFastest = submittedBids.length > 0 && bid.delivery === Math.min(...submittedBids.map(b => b.delivery)); return ` ${bid.delivery} ${currentLang === 'ar' ? 'يوم' : 'days'} ${isFastest ? '✓' : ''} `; }).join(''); // Build warranty row let warrantyRow = vendors.map(v => { const bid = vendorBids.find(b => b.name === v); if (!bid.submitted) { return `-`; } const isBest = submittedBids.length > 0 && bid.warranty === Math.max(...submittedBids.map(b => b.warranty)); return ` ${bid.warranty} ${currentLang === 'ar' ? 'سنة' : 'year'}${bid.warranty > 1 ? 's' : ''} ${isBest ? '✓' : ''} `; }).join(''); // Build notes row let notesRow = vendors.map(v => { const bid = vendorBids.find(b => b.name === v); if (!bid.submitted || !bid.notes) { return `-`; } return `${bid.notes}`; }).join(''); // Build score row let scoreRow = vendors.map(v => { const bid = vendorBids.find(b => b.name === v); if (!bid.submitted) { return `-`; } const isWinner = winner && bid.name === winner.name; return `${bid.score} pts`; }).join(''); // Build the content container.innerHTML = `

${rfq.id}: ${rfq.title}

${currentLang === 'ar' ? 'المشروع:' : 'Project:'} ${rfq.project} | ${currentLang === 'ar' ? 'طلب الشراء:' : 'PR:'} ${rfq.prReference} | ${currentLang === 'ar' ? 'تاريخ الاستحقاق:' : 'Due:'} ${rfq.dueDate} | ${currentLang === 'ar' ? 'الردود:' : 'Responses:'} ${submittedCount}/${vendors.length}

${currentLang === 'ar' ? 'حالة استلام العروض' : 'Quotation Submission Status'} ${submittedCount}/${vendors.length}

${vendorHeaders} ${priceRow} ${deliveryRow} ${warrantyRow} ${notesRow} ${scoreRow}

${currentLang === 'ar' ? 'المعيار' : 'Criteria'}	${currentLang === 'ar' ? 'الوزن' : 'Weight'}
${currentLang === 'ar' ? 'سعر الوحدة' : 'Unit Price (SAR)'}	40%
${currentLang === 'ar' ? 'مدة التوصيل' : 'Delivery Time'}	25%
${currentLang === 'ar' ? 'الضمان' : 'Warranty'}	15%
${currentLang === 'ar' ? 'ملاحظات' : 'Notes'}	-
${currentLang === 'ar' ? 'النتيجة المرجحة' : 'Weighted Score'}	100%

${winner ? `

🏆

${currentLang === 'ar' ? 'المورد الموصى به:' : 'Recommended Vendor:'} ${winner.name}

${currentLang === 'ar' ? 'أعلى نتيجة:' : 'Highest Score:'} ${winner.score} pts | ${currentLang === 'ar' ? 'السعر:' : 'Price:'} SAR ${winner.price.toLocaleString()} | ${currentLang === 'ar' ? 'التوصيل:' : 'Delivery:'} ${winner.delivery} ${currentLang === 'ar' ? 'يوم' : 'days'}

` : submittedCount === 0 ? `

⚠️

${currentLang === 'ar' ? 'لم يتم استلام أي عروض أسعار بعد' : 'No Quotations Received Yet'}

${currentLang === 'ar' ? 'انقر على "إدخال عرض" أعلاه لإضافة عروض أسعار الموردين' : 'Click "Enter Quote" above to add vendor quotations'}

` : `

⏳

${currentLang === 'ar' ? 'في انتظار المزيد من العروض' : 'Waiting for More Quotations'}

${submittedCount} ${currentLang === 'ar' ? 'من' : 'of'} ${vendors.length} ${currentLang === 'ar' ? 'موردين قدموا عروضهم' : 'vendors have submitted'}

${rfq.status !== 'awarded' && winner ? ` ` : rfq.status === 'awarded' ? ` ` : ''}

`; } // Request revision from vendors function requestRevision(rfqId) { showToast(currentLang === 'ar' ? 'تم إرسال طلب التعديل لجميع الموردين' : 'Revision request sent to all vendors', 'info'); } // Award bid to specific vendor function awardBidToVendor(rfqId, vendorName) { const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (rfq) { rfq.status = 'awarded'; rfq.awardedTo = vendorName; // Update related PR — mark as RFQ awarded (NOT po_issued yet) const pr = DataStore.purchaseRequisitions.find(p => p.id === rfq.prReference); if (pr) { // Add workflow note but DON'T advance to po_issued const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); pr.workflow.push({ stage: 'rfq_sent', date: dateStr, user: 'Mohamed Ahmed', notes: currentLang === 'ar' ? `تم ترسية ${rfqId} إلى ${vendorName}` : `${rfqId} awarded to ${vendorName}` }); } saveAllData(); renderRFQTable(); loadBidAnalysis(rfqId); showToast( currentLang === 'ar' ? `تم ترسية ${rfqId} إلى ${vendorName}` : `${rfqId} awarded to ${vendorName}`, 'success' ); } } // Award RFQ function awardRFQ(rfqId) { const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (rfq) { rfq.status = 'awarded'; renderRFQTable(); showToast(`${currentLang === 'ar' ? 'تم ترسية:' : 'Awarded:'} ${rfqId}`, 'success'); } } // ========================================== // QUOTATION MANAGEMENT FUNCTIONS // ========================================== // Open quotation entry/edit modal function openQuotationModal(rfqId, vendorName) { const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (!rfq) { showToast(currentLang === 'ar' ? 'طلب العرض غير موجود' : 'RFQ not found', 'error'); return; } // Store references document.getElementById('quotationRFQId').value = rfqId; document.getElementById('quotationVendorName').value = vendorName; document.getElementById('quotationRFQDisplay').textContent = rfqId; document.getElementById('quotationVendorDisplay').textContent = vendorName; // Check if quotation already exists const existingQuotation = rfq.quotations && rfq.quotations[vendorName]; if (existingQuotation) { // Edit mode - populate form with existing data document.getElementById('quotationModalTitle').textContent = currentLang === 'ar' ? '✏️ تعديل عرض السعر' : '✏️ Edit Vendor Quotation'; document.getElementById('quotationPrice').value = existingQuotation.price || ''; document.getElementById('quotationDelivery').value = existingQuotation.delivery || ''; document.getElementById('quotationWarranty').value = existingQuotation.warranty || 1; document.getElementById('quotationPaymentTerms').value = existingQuotation.paymentTerms || 'Net 30'; document.getElementById('quotationNotes').value = existingQuotation.notes || ''; document.getElementById('deleteQuotationBtn').style.display = 'inline-block'; if (existingQuotation.fileName) { document.getElementById('quotationFileInfo').textContent = `${currentLang === 'ar' ? 'ملف مرفق:' : 'Attached file:'} ${existingQuotation.fileName}`; } else { document.getElementById('quotationFileInfo').textContent = ''; } } else { // New quotation mode - reset form document.getElementById('quotationModalTitle').textContent = currentLang === 'ar' ? '📝 إدخال عرض سعر المورد' : '📝 Enter Vendor Quotation'; document.getElementById('quotationPrice').value = ''; document.getElementById('quotationDelivery').value = ''; document.getElementById('quotationWarranty').value = '1'; document.getElementById('quotationPaymentTerms').value = 'Net 30'; document.getElementById('quotationNotes').value = ''; document.getElementById('quotationFile').value = ''; document.getElementById('quotationFileInfo').textContent = ''; document.getElementById('deleteQuotationBtn').style.display = 'none'; } openModal('quotationModal'); } // Save quotation function saveQuotation() { const rfqId = document.getElementById('quotationRFQId').value; const vendorName = document.getElementById('quotationVendorName').value; const price = parseFloat(document.getElementById('quotationPrice').value); const delivery = parseInt(document.getElementById('quotationDelivery').value); const warranty = parseInt(document.getElementById('quotationWarranty').value); const paymentTerms = document.getElementById('quotationPaymentTerms').value; const notes = document.getElementById('quotationNotes').value; const fileInput = document.getElementById('quotationFile'); // Validation if (!price || price <= 0) { showToast(currentLang === 'ar' ? 'الرجاء إدخال السعر' : 'Please enter a valid price', 'error'); return; } if (!delivery || delivery < 1) { showToast(currentLang === 'ar' ? 'الرجاء إدخال مدة التوصيل' : 'Please enter delivery time', 'error'); return; } const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (!rfq) { showToast(currentLang === 'ar' ? 'طلب العرض غير موجود' : 'RFQ not found', 'error'); return; } // Initialize quotations object if needed if (!rfq.quotations) { rfq.quotations = {}; } // Save the quotation rfq.quotations[vendorName] = { price: price, delivery: delivery, warranty: warranty, paymentTerms: paymentTerms, notes: notes, submitted: true, submittedDate: new Date().toISOString().split('T')[0], fileName: fileInput.files[0] ? fileInput.files[0].name : (rfq.quotations[vendorName]?.fileName || null) }; // Update responses count rfq.responses = Object.keys(rfq.quotations).filter(v => rfq.quotations[v].submitted).length; // Auto-update status if all vendors have submitted if (rfq.responses >= rfq.vendorsInvited.length) { rfq.status = 'complete'; } closeModal('quotationModal'); showToast( currentLang === 'ar' ? `تم حفظ عرض السعر من ${vendorName}` : `Quotation from ${vendorName} saved successfully`, 'success' ); // Refresh the bid analysis view loadBidAnalysis(rfqId); renderRFQTable(); } // Delete quotation function deleteQuotation() { const rfqId = document.getElementById('quotationRFQId').value; const vendorName = document.getElementById('quotationVendorName').value; if (!confirm(currentLang === 'ar' ? `هل أنت متأكد من حذف عرض السعر من ${vendorName}؟` : `Are you sure you want to delete the quotation from ${vendorName}?`)) { return; } const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (rfq && rfq.quotations && rfq.quotations[vendorName]) { delete rfq.quotations[vendorName]; // Update responses count rfq.responses = Object.keys(rfq.quotations).filter(v => rfq.quotations[v].submitted).length; // Update status if responses dropped if (rfq.responses < rfq.vendorsInvited.length && rfq.status === 'complete') { rfq.status = 'open'; } closeModal('quotationModal'); showToast( currentLang === 'ar' ? `تم حذف عرض السعر من ${vendorName}` : `Quotation from ${vendorName} deleted`, 'success' ); loadBidAnalysis(rfqId); renderRFQTable(); } } // Create PO from RFQ function createPOFromRFQ(rfqId) { // Store the RFQ ID to populate the form window.pendingPOFromRFQ = rfqId; showSection('purchaseorders'); openModal('poModal'); } // Update PO RFQ Reference dropdown function updatePORFQDropdown() { const select = document.getElementById('poRFQReference'); if (!select) return; const selectText = currentLang === 'ar' ? 'اختر طلب العرض' : 'Select RFQ'; let options = ``; // Only show awarded RFQs that don't have a PO yet const awardedRFQs = DataStore.rfqs.filter(r => r.status === 'awarded'); awardedRFQs.forEach(rfq => { options += ``; }); select.innerHTML = options; } // Populate PO form from selected RFQ function populatePOFromRFQ(rfqId) { if (!rfqId) { document.getElementById('poPRReference').value = ''; document.getElementById('poProject').value = ''; document.getElementById('poVendor').value = ''; document.getElementById('poDeliveryAddress').value = ''; document.getElementById('poLineItems').innerHTML = ''; document.getElementById('poSubtotal').textContent = 'SAR 0.00'; document.getElementById('poVAT').textContent = 'SAR 0.00'; document.getElementById('poGrandTotal').textContent = 'SAR 0.00'; return; } const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (!rfq) return; // Set PR reference document.getElementById('poPRReference').value = rfq.prReference || ''; // Set project document.getElementById('poProject').value = rfq.project || ''; // Set vendor (if awarded) if (rfq.awardedTo) { document.getElementById('poVendor').value = rfq.awardedTo; } // Set delivery address from project const project = DataStore.projects.find(p => p.name === rfq.project); if (project) { document.getElementById('poDeliveryAddress').value = `Site: ${project.name}, ${project.siteAddress || project.location}`; } // Set delivery date (14 days from today) const deliveryDate = new Date(); deliveryDate.setDate(deliveryDate.getDate() + 14); document.getElementById('poDeliveryDate').value = deliveryDate.toISOString().split('T')[0]; // Populate line items const itemsBody = document.getElementById('poLineItems'); let itemsHtml = ''; let subtotal = 0; if (rfq.items && rfq.items.length > 0) { rfq.items.forEach((item, idx) => { const qty = item.qty || 0; const price = item.price || 0; const total = qty * price; subtotal += total; itemsHtml += ` ${idx + 1} ${total.toLocaleString()} `; }); } else { // Default empty row itemsHtml = ` 1 0 `; } itemsBody.innerHTML = itemsHtml; // Calculate totals const vat = subtotal * 0.15; const grandTotal = subtotal + vat; document.getElementById('poSubtotal').textContent = `SAR ${subtotal.toLocaleString()}`; document.getElementById('poVAT').textContent = `SAR ${vat.toLocaleString()}`; document.getElementById('poGrandTotal').textContent = `SAR ${grandTotal.toLocaleString()}`; } // Calculate PO totals function calculatePOTotals() { const rows = document.querySelectorAll('#poLineItems tr'); let subtotal = 0; rows.forEach(row => { // Use class selectors for more reliable selection let qtyInput = row.querySelector('.po-qty'); let priceInput = row.querySelector('.po-price'); // Fallback to nth-of-type if classes not found if (!qtyInput || !priceInput) { const inputs = row.querySelectorAll('input[type="number"]'); qtyInput = inputs[0]; priceInput = inputs[1]; } const totalCell = row.querySelector('.po-item-total'); if (qtyInput && priceInput && totalCell) { const qty = parseFloat(qtyInput.value) || 0; const price = parseFloat(priceInput.value) || 0; const total = qty * price; subtotal += total; totalCell.textContent = total.toLocaleString(); } }); const vat = subtotal * 0.15; const grandTotal = subtotal + vat; document.getElementById('poSubtotal').textContent = `SAR ${subtotal.toLocaleString()}`; document.getElementById('poVAT').textContent = `SAR ${vat.toLocaleString()}`; document.getElementById('poGrandTotal').textContent = `SAR ${grandTotal.toLocaleString()}`; } function submitPO(asDraft) { const vendor = document.getElementById('poVendor')?.value; const rfqRef = document.getElementById('poRFQReference')?.value; const poNumber = document.getElementById('poNumber')?.value; const poDate = document.getElementById('poDate')?.value; const prRef = document.getElementById('poPRReference')?.value; const project = document.getElementById('poProject')?.value; const deliveryDate = document.getElementById('poDeliveryDate')?.value; const paymentTerms = document.getElementById('poPaymentTerms')?.value; const deliveryAddress = document.getElementById('poDeliveryAddress')?.value; if (!asDraft && !vendor) { showToast(currentLang === 'ar' ? 'الرجاء اختيار المورد' : 'Please select a vendor', 'error'); return; } // Calculate totals from line items let subtotal = 0; const items = []; const rows = document.querySelectorAll('#poLineItems tr'); rows.forEach(row => { const inputs = row.querySelectorAll('input'); if (inputs.length < 4) return; // Skip invalid rows const descInput = inputs[0]; // First input is description const unitInput = inputs[1]; // Second input is unit // Use class selectors for qty and price let qtyInput = row.querySelector('.po-qty'); let priceInput = row.querySelector('.po-price'); // Fallback: get all number inputs if (!qtyInput || !priceInput) { const numberInputs = row.querySelectorAll('input[type="number"]'); qtyInput = numberInputs[0]; priceInput = numberInputs[1]; } if (descInput && qtyInput && priceInput) { const qty = parseFloat(qtyInput.value) || 0; const price = parseFloat(priceInput.value) || 0; const total = qty * price; subtotal += total; if (descInput.value && qty > 0) { items.push({ desc: descInput.value, qty: qty, unit: unitInput?.value || 'PC', price: price, receivedQty: 0 }); } } }); const vat = subtotal * 0.15; const grandTotal = subtotal + vat; // Validate that at least one item has values if (!asDraft && items.length === 0) { showToast(currentLang === 'ar' ? 'الرجاء إضافة عنصر واحد على الأقل بكمية وسعر' : 'Please add at least one item with quantity and price', 'error'); return; } if (!asDraft && subtotal === 0) { showToast(currentLang === 'ar' ? 'إجمالي أمر الشراء لا يمكن أن يكون صفراً' : 'Purchase Order total cannot be zero', 'error'); return; } // Create new PO object const newPO = { id: poNumber, date: poDate || new Date().toISOString().split('T')[0], vendor: vendor, project: project, prReference: prRef, rfqReference: rfqRef, total: subtotal, vat: vat, grandTotal: grandTotal, deliveryDate: deliveryDate, deliveryAddress: deliveryAddress, paymentTerms: paymentTerms, status: asDraft ? 'draft' : 'sent', items: items }; // Increment counter and add to DataStore DataStore.poCounter++; DataStore.purchaseOrders.unshift(newPO); saveAllData(); // Auto-save // Update related PR and RFQ if (rfqRef) { const rfq = DataStore.rfqs.find(r => r.id === rfqRef); if (rfq) { rfq.poNumber = poNumber; // Link RFQ to PO const pr = DataStore.purchaseRequisitions.find(p => p.id === rfq.prReference); if (pr) { pr.currentStage = 4; pr.status = 'po_issued'; pr.relatedDocs.po = poNumber; const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); pr.workflow.push({ stage: 'po_issued', date: dateStr, user: 'Mohamed Ahmed', notes: currentLang === 'ar' ? `تم إصدار ${poNumber} إلى ${vendor}` : `${poNumber} issued to ${vendor}` }); } } } closeModal('poModal'); const successMsg = asDraft ? (currentLang === 'ar' ? `تم حفظ أمر الشراء ${poNumber} كمسودة` : `Purchase Order ${poNumber} saved as draft`) : (currentLang === 'ar' ? `تم إصدار أمر الشراء ${poNumber} وإرساله إلى ${vendor}` : `Purchase Order ${poNumber} created and sent to ${vendor}`); showToast(successMsg, 'success'); // Refresh tables renderPRTable(); renderRFQTable(); renderPOTable(); // Clear pending RFQ window.pendingPOFromRFQ = null; } // ========================================== // GRN - PO LINKING FUNCTIONS // ========================================== // Update PO dropdown in GRN modal (show only POs with pending deliveries) function updateGRNPODropdown() { const select = document.getElementById('grnPOSelect'); if (!select) return; // Get POs that are not fully received (sent or partial status) const eligiblePOs = DataStore.purchaseOrders.filter(po => po.status === 'sent' || po.status === 'partial' ); let optionsHtml = ''; eligiblePOs.forEach(po => { optionsHtml += ``; }); // Also add POs that are marked as received in case user needs to add more GRNs const receivedPOs = DataStore.purchaseOrders.filter(po => po.status === 'received'); if (receivedPOs.length > 0) { optionsHtml += ''; receivedPOs.forEach(po => { optionsHtml += ``; }); optionsHtml += ''; } select.innerHTML = optionsHtml; } // Populate GRN items from selected PO function populateGRNFromPO(poId) { const vendor = document.getElementById('grnVendor'); const project = document.getElementById('grnProject'); const itemsBody = document.getElementById('grnLineItems'); if (!poId) { vendor.value = ''; project.value = ''; itemsBody.innerHTML = ` Select a Purchase Order to load items `; return; } const po = DataStore.purchaseOrders.find(p => p.id === poId); if (!po) { showToast('Purchase Order not found', 'error'); return; } // Set vendor and project vendor.value = po.vendor; project.value = po.project; // Build items table let itemsHtml = ''; if (po.items && po.items.length > 0) { po.items.forEach((item, idx) => { const poQty = item.qty || 0; const prevRecv = item.receivedQty || 0; const remainingBalance = poQty - prevRecv; const defaultThisRecv = remainingBalance > 0 ? remainingBalance : 0; itemsHtml += ` ${idx + 1} ${item.desc || ''} ${poQty} ${prevRecv} ${remainingBalance - defaultThisRecv} `; }); } else { itemsHtml = ` No items found in this Purchase Order `; } itemsBody.innerHTML = itemsHtml; } // Calculate balance when user changes received quantity function calculateGRNBalance(input, poQty, prevRecv) { const thisRecv = parseFloat(input.value) || 0; const balance = poQty - prevRecv - thisRecv; const row = input.closest('tr'); const balanceCell = row.querySelector('.grn-balance'); if (balanceCell) { balanceCell.textContent = balance; if (balance === 0) { balanceCell.style.color = 'var(--success)'; } else if (balance < 0) { balanceCell.style.color = 'var(--danger)'; } else { balanceCell.style.color = 'var(--warning)'; } } // Validate input const maxAllowed = poQty - prevRecv; if (thisRecv > maxAllowed) { input.value = maxAllowed; calculateGRNBalance(input, poQty, prevRecv); } else if (thisRecv < 0) { input.value = 0; calculateGRNBalance(input, poQty, prevRecv); } } // Open GRN modal for a specific PO function openGRNForPO(poId) { window.pendingGRNFromPO = poId; openModal('grnModal'); } // ========================================== // PURCHASE ORDER TABLE FUNCTIONS // ========================================== function renderPOTable(filteredData = null) { const poData = filteredData || DataStore.purchaseOrders; const tbody = document.getElementById('poTableBody'); if (!tbody) return; let html = ''; if (poData.length === 0) { html = ` ${currentLang === 'ar' ? 'لا توجد أوامر شراء' : 'No purchase orders found'} `; } else { poData.forEach(po => { const statusColors = { 'draft': { color: '#95a5a6', text: currentLang === 'ar' ? 'مسودة' : 'Draft' }, 'sent': { color: '#3498db', text: currentLang === 'ar' ? 'مرسل' : 'Sent' }, 'partial': { color: '#f39c12', text: currentLang === 'ar' ? 'جزئي' : 'Partial' }, 'received': { color: '#2bbcb3', text: currentLang === 'ar' ? 'مستلم' : 'Received' } }; const status = statusColors[po.status] || statusColors['draft']; // Format delivery date const deliveryDisplay = po.deliveryDate ? new Date(po.deliveryDate).toLocaleDateString('en-US', { month: 'short', day: 'numeric', year: 'numeric' }) : 'N/A'; html += ` ${po.id} ${po.date} ${po.vendor} ${po.project} ${po.total.toLocaleString()} ${po.vat.toLocaleString()} ${po.grandTotal.toLocaleString()} ${deliveryDisplay} ${status.text} ${po.rfqReference ? `` : ''} ${(po.status === 'sent' || po.status === 'partial') ? `` : ''} `; }); } tbody.innerHTML = html; } function filterPOTable() { const statusFilter = document.getElementById('filterPOStatus')?.value || ''; const vendorFilter = document.getElementById('filterPOVendor')?.value || ''; let filteredData = DataStore.purchaseOrders; if (statusFilter) { filteredData = filteredData.filter(po => po.status === statusFilter); } if (vendorFilter) { filteredData = filteredData.filter(po => po.vendor === vendorFilter); } renderPOTable(filteredData); } function viewPOBidAnalysis(poId) { const po = DataStore.purchaseOrders.find(p => p.id === poId); if (!po || !po.rfqReference) { showToast(currentLang === 'ar' ? 'لا يوجد تحليل عطاءات مرتبط' : 'No linked bid analysis found', 'warning'); return; } // Navigate to Bid Analysis and load the related RFQ showSection('bidanalysis'); const rfqSelect = document.getElementById('bidAnalysisRFQSelect'); if (rfqSelect) { rfqSelect.value = po.rfqReference; loadBidAnalysis(po.rfqReference); } showToast(currentLang === 'ar' ? `عرض تحليل العطاءات لـ ${po.rfqReference}` : `Viewing Bid Analysis for ${po.rfqReference}`, 'info'); } function viewPODetails(poId) { const po = DataStore.purchaseOrders.find(p => p.id === poId); if (!po) { showToast(currentLang === 'ar' ? 'لم يتم العثور على أمر الشراء' : 'PO not found', 'error'); return; } const statusColors = { 'draft': { color: '#95a5a6', text: currentLang === 'ar' ? 'مسودة' : 'Draft' }, 'sent': { color: '#3498db', text: currentLang === 'ar' ? 'مرسل' : 'Sent' }, 'partial': { color: '#f39c12', text: currentLang === 'ar' ? 'جزئي' : 'Partial' }, 'received': { color: '#2bbcb3', text: currentLang === 'ar' ? 'مستلم' : 'Received' } }; const status = statusColors[po.status] || statusColors['draft']; // Build items table with received quantities let itemsHtml = ''; if (po.items && po.items.length > 0) { po.items.forEach((item, idx) => { const total = (item.qty || 0) * (item.price || 0); const receivedQty = item.receivedQty || 0; const balance = (item.qty || 0) - receivedQty; const balanceColor = balance === 0 ? 'var(--success)' : balance > 0 ? 'var(--warning)' : 'var(--danger)'; itemsHtml += ` ${idx + 1} ${item.desc || 'N/A'} ${item.unit || 'PC'} ${item.qty || 0} ${receivedQty} ${balance} SAR ${(item.price || 0).toLocaleString()} SAR ${total.toLocaleString()} `; }); } // Build linked documents section let linkedDocsHtml = ''; const hasLinkedDocs = po.prReference || po.rfqReference || (po.grnReferences && po.grnReferences.length > 0); if (hasLinkedDocs) { let grnButtons = ''; if (po.grnReferences && po.grnReferences.length > 0) { po.grnReferences.forEach(grnId => { grnButtons += ` `; }); } linkedDocsHtml = `

🔗 ${currentLang === 'ar' ? 'المستندات المرتبطة' : 'Linked Documents'}

${po.prReference ? ` ` : ''} ${po.rfqReference ? ` ` : ''} ${grnButtons}

`; } const modal = document.createElement('div'); modal.id = 'poViewModal'; modal.className = 'modal-overlay active'; modal.innerHTML = `

${currentLang === 'ar' ? 'رقم أمر الشراء' : 'PO Number'}

${po.id}

${currentLang === 'ar' ? 'التاريخ' : 'Date'}

${po.date}

${currentLang === 'ar' ? 'المورد' : 'Vendor'}

${po.vendor}

${currentLang === 'ar' ? 'الحالة' : 'Status'}

${status.text}

${currentLang === 'ar' ? 'المشروع' : 'Project'}

${po.project}

${currentLang === 'ar' ? 'شروط الدفع' : 'Payment Terms'}

${po.paymentTerms || 'Net 30'}

📦 ${currentLang === 'ar' ? 'البنود' : 'Order Items'}

${itemsHtml || ``}

#	${currentLang === 'ar' ? 'الوصف' : 'Description'}	${currentLang === 'ar' ? 'الوحدة' : 'Unit'}	${currentLang === 'ar' ? 'الكمية' : 'Qty'}	${currentLang === 'ar' ? 'مستلم' : 'Received'}	${currentLang === 'ar' ? 'الرصيد' : 'Balance'}	${currentLang === 'ar' ? 'سعر الوحدة' : 'Unit Price'}	${currentLang === 'ar' ? 'الإجمالي' : 'Total'}
${currentLang === 'ar' ? 'لا توجد بنود' : 'No items'}
${currentLang === 'ar' ? 'المجموع الفرعي:' : 'Subtotal:'}							SAR ${po.total.toLocaleString()}
${currentLang === 'ar' ? 'ضريبة القيمة المضافة (15%):' : 'VAT (15%):'}							SAR ${po.vat.toLocaleString()}
${currentLang === 'ar' ? 'المجموع الكلي:' : 'Grand Total:'}							SAR ${po.grandTotal.toLocaleString()}

${linkedDocsHtml}

`; document.body.appendChild(modal); } function submitGRN(requestQC) { const grnNumber = document.getElementById('grnNumber').value; const grnDate = document.getElementById('grnDate').value; const poId = document.getElementById('grnPOSelect').value; const vendor = document.getElementById('grnVendor').value; const project = document.getElementById('grnProject').value; const deliveryNote = document.getElementById('grnDeliveryNote').value; const warehouse = document.getElementById('grnWarehouse').value; const receivedBy = document.getElementById('grnReceivedBy').value; const remarks = document.getElementById('grnRemarks').value; if (!poId) { showToast(currentLang === 'ar' ? 'الرجاء اختيار أمر الشراء' : 'Please select a Purchase Order', 'error'); return; } if (!deliveryNote) { showToast(currentLang === 'ar' ? 'الرجاء إدخال رقم إشعار التسليم' : 'Please enter Delivery Note number', 'error'); return; } // Get items from the GRN table const items = []; const rows = document.querySelectorAll('#grnLineItems tr[data-item-index]'); let totalReceived = 0; let hasItems = false; rows.forEach(row => { const desc = row.cells[1].textContent; const poQty = parseFloat(row.cells[2].textContent) || 0; const recvInput = row.querySelector('.grn-recv-qty'); const condSelect = row.querySelector('.grn-condition'); const receivedQty = parseFloat(recvInput?.value) || 0; const condition = condSelect?.value || 'Good'; if (receivedQty > 0) { hasItems = true; totalReceived += receivedQty; items.push({ desc: desc, poQty: poQty, receivedQty: receivedQty, condition: condition }); } }); if (!hasItems) { showToast(currentLang === 'ar' ? 'الرجاء إدخال كمية مستلمة واحدة على الأقل' : 'Please enter at least one received quantity', 'error'); return; } // Create new GRN object const newGRN = { id: grnNumber, date: grnDate || new Date().toISOString().split('T')[0], poReference: poId, vendor: vendor, project: project, deliveryNote: deliveryNote, warehouse: warehouse, receivedBy: receivedBy, status: requestQC ? 'pending_qc' : 'completed', qcStatus: requestQC ? 'pending' : 'passed', items: items, remarks: remarks }; // Increment counter and add to DataStore DataStore.grnCounter++; DataStore.grns.unshift(newGRN); saveAllData(); // Auto-save // Update the PO with received quantities const po = DataStore.purchaseOrders.find(p => p.id === poId); if (po) { let allFullyReceived = true; let anyReceived = false; po.items.forEach((item, idx) => { // Find matching GRN item const grnItem = items.find(gi => gi.desc === item.desc); if (grnItem) { item.receivedQty = (item.receivedQty || 0) + grnItem.receivedQty; anyReceived = true; } // Check if fully received if ((item.receivedQty || 0) < item.qty) { allFullyReceived = false; } }); // Update PO status if (allFullyReceived) { po.status = 'received'; } else if (anyReceived) { po.status = 'partial'; } // Link GRN to PO if (!po.grnReferences) po.grnReferences = []; po.grnReferences.push(grnNumber); // Update related PR workflow if exists const pr = DataStore.purchaseRequisitions.find(p => p.relatedDocs?.po === poId); if (pr && allFullyReceived) { pr.currentStage = 5; pr.status = 'delivered'; pr.relatedDocs.grn = grnNumber; const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); pr.workflow.push({ stage: 'delivered', date: dateStr, user: receivedBy, notes: currentLang === 'ar' ? `${grnNumber} - تم استلام البضائع بالكامل` : `${grnNumber} - Full delivery received` }); } } closeModal('grnModal'); // ═══ GRN → Inventory: Auto-update stock ═══ (async function syncGRNToInventory() { try { const API_URL = (typeof HAZ_CONFIG!=='undefined') ? HAZ_CONFIG.SUPABASE_URL : 'https://crjhpxgbbvmolurxpatz.supabase.co'; const API_KEY = (typeof HAZ_CONFIG!=='undefined') ? HAZ_CONFIG.SUPABASE_ANON_KEY : 'sb_publishable_Oq3gfK8qElVE4Jm1fWvkOw_022O5Rhf'; const H = { 'apikey': API_KEY, 'Authorization': 'Bearer ' + API_KEY, 'Content-Type': 'application/json', 'Prefer': 'resolution=merge-duplicates,return=minimal' }; // Resolve project UUID let projectUUID = null; if (project) { const pRes = await fetch(API_URL + '/rest/v1/projects?or=(name.eq.' + encodeURIComponent(project) + ',code.eq.' + encodeURIComponent(project) + ')&select=id&limit=1', { headers: H }); const pData = await pRes.json(); if (pData && pData[0]) projectUUID = pData[0].id; } // Resolve warehouse UUID let warehouseUUID = null; if (warehouse) { const whRes = await fetch(API_URL + '/rest/v1/warehouses?name=eq.' + encodeURIComponent(warehouse) + '&select=id&limit=1', { headers: H }); const whData = await whRes.json(); if (whData && whData[0]) warehouseUUID = whData[0].id; } if (projectUUID && newGRN.items) { for (const item of newGRN.items) { const itemCode = 'GRN-' + grnNumber + '-' + (item.desc || '').slice(0,20).replace(/\s/g,'-'); // 1. Create/update inventory_items await fetch(API_URL + '/rest/v1/inventory_items', { method: 'POST', headers: H, body: JSON.stringify({ item_code: itemCode, name: item.desc || '', unit: item.unit || 'PC', unit_price: 0 }) }); // 2. Resolve item UUID const itemRes = await fetch(API_URL + '/rest/v1/inventory_items?item_code=eq.' + encodeURIComponent(itemCode) + '&select=id&limit=1', { headers: H }); const itemData = await itemRes.json(); if (itemData && itemData[0]) { // 3. Add to inventory_stock with proper FKs await fetch(API_URL + '/rest/v1/inventory_stock', { method: 'POST', headers: H, body: JSON.stringify({ item_id: itemData[0].id, warehouse_id: warehouseUUID, project_id: projectUUID, current_qty: parseFloat(item.receivedQty) || 0, available_qty: parseFloat(item.receivedQty) || 0 }) }); } } console.log('📦 GRN items added to inventory'); } } catch(e) { console.warn('GRN→Inventory sync failed:', e); } })(); const successMsg = requestQC ? (currentLang === 'ar' ? `تم حفظ ${grnNumber} وإرساله لفحص الجودة` : `${grnNumber} saved and sent for QC inspection`) : (currentLang === 'ar' ? `تم تأكيد ${grnNumber} وتخزينه` : `${grnNumber} confirmed and stored`); showToast(successMsg, 'success'); // Refresh tables renderPRTable(); renderPOTable(); renderGRNTable(); } // ========================================== // GRN TABLE RENDERING // ========================================== function renderGRNTable() { const tbody = document.getElementById('grnTableBody'); if (!tbody) return; const statusFilter = document.getElementById('filterGRNStatus')?.value || ''; const warehouseFilter = document.getElementById('filterGRNWarehouse')?.value || ''; let filteredGRNs = DataStore.grns.filter(grn => { if (statusFilter && grn.status !== statusFilter) return false; if (warehouseFilter && grn.warehouse !== warehouseFilter) return false; return true; }); if (filteredGRNs.length === 0) { tbody.innerHTML = ` ${currentLang === 'ar' ? 'لا توجد سندات استلام' : 'No GRN records found'} `; return; } let html = ''; filteredGRNs.forEach(grn => { const qcStatusStyles = { 'pending': { class: 'pending', text: currentLang === 'ar' ? 'في انتظار الفحص' : 'Pending QC' }, 'passed': { class: 'approved', text: currentLang === 'ar' ? 'ناجح' : 'Passed' }, 'failed': { class: 'rejected', text: currentLang === 'ar' ? 'فاشل' : 'Failed' } }; const qcStatus = qcStatusStyles[grn.qcStatus] || qcStatusStyles['pending']; const itemCount = grn.items?.length || 0; html += ` ${grn.id} ${grn.date} ${grn.poReference} ${grn.vendor} ${grn.project} ${grn.deliveryNote} ${itemCount} ${currentLang === 'ar' ? 'عناصر' : 'items'} ${grn.receivedBy} ${qcStatus.text} ${grn.qcStatus === 'pending' ? `` : ''} `; }); tbody.innerHTML = html; } // View GRN details function viewGRN(grnId) { const grn = DataStore.grns.find(g => g.id === grnId); if (!grn) { showToast(currentLang === 'ar' ? 'لم يتم العثور على سند الاستلام' : 'GRN not found', 'error'); return; } const qcStatusText = grn.qcStatus === 'passed' ? (currentLang === 'ar' ? 'ناجح' : 'Passed') : grn.qcStatus === 'failed' ? (currentLang === 'ar' ? 'فاشل' : 'Failed') : (currentLang === 'ar' ? 'في انتظار الفحص' : 'Pending QC'); let itemsHtml = ''; if (grn.items && grn.items.length > 0) { grn.items.forEach((item, idx) => { itemsHtml += ` ${idx + 1} ${item.desc} ${item.poQty} ${item.receivedQty} ${item.condition} `; }); } const content = `

${grn.id}

${grn.date}

${qcStatusText}

${currentLang === 'ar' ? 'أمر الشراء' : 'Purchase Order'}

${grn.poReference}

${currentLang === 'ar' ? 'المورد' : 'Vendor'}

${grn.vendor}

${currentLang === 'ar' ? 'المشروع' : 'Project'}

${grn.project}

${currentLang === 'ar' ? 'رقم إشعار التسليم' : 'Delivery Note'}

${grn.deliveryNote}

${currentLang === 'ar' ? 'المستودع' : 'Warehouse'}

${grn.warehouse}

${currentLang === 'ar' ? 'استلم بواسطة' : 'Received By'}

${grn.receivedBy}

${currentLang === 'ar' ? 'العناصر المستلمة' : 'Received Items'}

${itemsHtml}

#	${currentLang === 'ar' ? 'الوصف' : 'Description'}	${currentLang === 'ar' ? 'كمية PO' : 'PO Qty'}	${currentLang === 'ar' ? 'الكمية المستلمة' : 'Received'}	${currentLang === 'ar' ? 'الحالة' : 'Condition'}

${grn.remarks ? `

${currentLang === 'ar' ? 'ملاحظات' : 'Remarks'}

${grn.remarks}

` : ''}

`; // Create modal for viewing GRN let modal = document.getElementById('viewGRNModal'); if (!modal) { modal = document.createElement('div'); modal.id = 'viewGRNModal'; modal.className = 'modal-overlay'; modal.innerHTML = ` `; document.body.appendChild(modal); } document.getElementById('viewGRNContent').innerHTML = content; openModal('viewGRNModal'); } // Print GRN function printGRN(grnId) { showToast(currentLang === 'ar' ? `جاري طباعة ${grnId}...` : `Printing ${grnId}...`, 'info'); window.print(); } // Approve GRN QC function approveGRNQC(grnId) { const grn = DataStore.grns.find(g => g.id === grnId); if (grn) { grn.qcStatus = 'passed'; grn.status = 'completed'; renderGRNTable(); showToast(currentLang === 'ar' ? `تم اعتماد فحص الجودة لـ ${grnId}` : `QC approved for ${grnId}`, 'success'); } } // ========================================== // INVOICE MANAGEMENT - 3-WAY MATCHING SYSTEM // ========================================== function openInvoiceModal() { // Generate next invoice number (preview only - counter increments on submit) const nextInvoiceNum = DataStore.invoiceCounter + 1; document.getElementById('invoiceNumber').value = `INV-${nextInvoiceNum}`; document.getElementById('invoiceDate').value = new Date().toISOString().split('T')[0]; // Reset form fields document.getElementById('invoiceVendor').value = ''; document.getElementById('invoiceProject').value = ''; document.getElementById('invoiceAmount').value = ''; document.getElementById('invoiceVATAmount').value = ''; document.getElementById('invoiceNotes').value = ''; document.getElementById('invoiceGRNSelect').innerHTML = ''; document.getElementById('invoiceMatchPreviewPanel').style.display = 'none'; // Populate PO dropdown with POs that have GRNs updateInvoicePODropdown(); openModal('invoiceModal'); } function updateInvoicePODropdown() { const select = document.getElementById('invoicePOSelect'); const eligiblePOs = DataStore.purchaseOrders.filter(po => po.grnReferences && po.grnReferences.length > 0 ); let html = ''; eligiblePOs.forEach(po => { html += ``; }); select.innerHTML = html; } function populateInvoiceFromPO() { const poId = document.getElementById('invoicePOSelect').value; const grnSelect = document.getElementById('invoiceGRNSelect'); if (!poId) { document.getElementById('invoiceVendor').value = ''; document.getElementById('invoiceProject').value = ''; grnSelect.innerHTML = ''; document.getElementById('invoiceMatchPreviewPanel').style.display = 'none'; return; } const po = DataStore.purchaseOrders.find(p => p.id === poId); if (!po) return; // Set vendor and project document.getElementById('invoiceVendor').value = po.vendor; document.getElementById('invoiceProject').value = po.project; // Populate GRN dropdown from this PO let grnHtml = ''; if (po.grnReferences && po.grnReferences.length > 0) { po.grnReferences.forEach(grnId => { const grn = DataStore.grns.find(g => g.id === grnId); if (grn) { // Calculate GRN value from items let grnValue = 0; if (grn.items) { grn.items.forEach(item => { // Find the matching PO item to get the price const poItem = po.items.find(pi => pi.desc === item.desc); if (poItem) { grnValue += item.receivedQty * poItem.price; } }); } const grnValueWithVAT = grnValue * 1.15; grnHtml += ``; } }); } grnSelect.innerHTML = grnHtml; // Auto-select first GRN if only one exists if (po.grnReferences && po.grnReferences.length === 1) { grnSelect.value = po.grnReferences[0]; updateInvoiceGRNValue(); } // Show match preview panel document.getElementById('invoiceMatchPreviewPanel').style.display = 'block'; document.getElementById('previewPOAmount').textContent = `SAR ${po.grandTotal.toLocaleString()}`; calculateInvoiceMatchPreview(); } function updateInvoiceGRNValue() { const grnSelect = document.getElementById('invoiceGRNSelect'); const selectedOption = grnSelect.options[grnSelect.selectedIndex]; if (!grnSelect.value || !selectedOption) { document.getElementById('previewGRNAmount').textContent = 'SAR 0.00'; return; } const grnValue = parseFloat(selectedOption.getAttribute('data-value')) || 0; document.getElementById('previewGRNAmount').textContent = `SAR ${grnValue.toLocaleString()}`; calculateInvoiceMatchPreview(); } function calculateInvoiceMatchPreview() { const poId = document.getElementById('invoicePOSelect').value; const grnSelect = document.getElementById('invoiceGRNSelect'); const invoiceAmount = parseFloat(document.getElementById('invoiceAmount').value) || 0; const invoiceVAT = parseFloat(document.getElementById('invoiceVATAmount').value) || 0; const invoiceTotal = invoiceAmount + invoiceVAT; // Update invoice preview amount document.getElementById('previewInvoiceAmount').textContent = `SAR ${invoiceTotal.toLocaleString()}`; if (!poId || !grnSelect.value || invoiceTotal === 0) { document.getElementById('matchResultPreview').innerHTML = `

⏳

Enter invoice amount to preview match | أدخل مبلغ الفاتورة للمعاينة

`; document.getElementById('matchResultPreview').style.background = 'var(--bg-secondary)'; return; } const po = DataStore.purchaseOrders.find(p => p.id === poId); const selectedOption = grnSelect.options[grnSelect.selectedIndex]; const grnValue = parseFloat(selectedOption.getAttribute('data-value')) || 0; if (!po) return; const poAmount = po.grandTotal; // Calculate variance const variance = invoiceTotal - grnValue; const variancePercent = grnValue > 0 ? (variance / grnValue * 100).toFixed(1) : 0; // Determine match status with 1% tolerance const tolerance = Math.max(grnValue * 0.01, 100); let matchStatus, icon, text, bgColor; if (Math.abs(variance) <= tolerance) { if (grnValue >= poAmount * 0.99) { matchStatus = 'matched'; icon = '✓'; text = currentLang === 'ar' ? 'مطابقة تامة | Perfect Match' : 'Perfect Match | مطابقة تامة'; bgColor = 'rgba(39, 174, 96, 0.15)'; } else { matchStatus = 'partial'; icon = '⚡'; text = currentLang === 'ar' ? 'مطابقة جزئية | Partial Match' : 'Partial Match (Partial Delivery) | مطابقة جزئية'; bgColor = 'rgba(243, 156, 18, 0.15)'; } } else { matchStatus = 'discrepancy'; icon = '⚠️'; text = `Discrepancy: ${variance > 0 ? '+' : ''}SAR ${variance.toLocaleString()} (${variancePercent}%) | تناقض`; bgColor = 'rgba(192, 57, 43, 0.15)'; } document.getElementById('matchResultPreview').style.background = bgColor; document.getElementById('matchResultPreview').innerHTML = `

${icon}

${text}

`; } function submitInvoice() { const invoiceNumber = document.getElementById('invoiceNumber').value; const invoiceDate = document.getElementById('invoiceDate').value; const poId = document.getElementById('invoicePOSelect').value; const grnId = document.getElementById('invoiceGRNSelect').value; const vendor = document.getElementById('invoiceVendor').value; const project = document.getElementById('invoiceProject').value; const invoiceAmount = parseFloat(document.getElementById('invoiceAmount').value) || 0; const invoiceVAT = parseFloat(document.getElementById('invoiceVATAmount').value) || 0; const notes = document.getElementById('invoiceNotes').value; // Validation if (!invoiceNumber) { showToast(currentLang === 'ar' ? 'الرجاء إدخال رقم الفاتورة' : 'Please enter Invoice Number', 'error'); return; } if (!poId) { showToast(currentLang === 'ar' ? 'الرجاء اختيار أمر شراء' : 'Please select a Purchase Order', 'error'); return; } if (!grnId) { showToast(currentLang === 'ar' ? 'الرجاء اختيار سند استلام' : 'Please select a GRN', 'error'); return; } if (invoiceAmount <= 0) { showToast(currentLang === 'ar' ? 'الرجاء إدخال مبلغ الفاتورة' : 'Please enter invoice amount', 'error'); return; } // Get reference data const po = DataStore.purchaseOrders.find(p => p.id === poId); const grnSelect = document.getElementById('invoiceGRNSelect'); const selectedOption = grnSelect.options[grnSelect.selectedIndex]; const grnValue = parseFloat(selectedOption.getAttribute('data-value')) || 0; if (!po) { showToast('Error: Could not find PO reference', 'error'); return; } const invoiceTotal = invoiceAmount + invoiceVAT; const poAmount = po.grandTotal; const variance = invoiceTotal - grnValue; // Determine match status const tolerance = Math.max(grnValue * 0.01, 100); let matchStatus; if (Math.abs(variance) <= tolerance) { if (grnValue >= poAmount * 0.99) { matchStatus = 'matched'; } else { matchStatus = 'partial'; } } else { matchStatus = 'discrepancy'; } // Create invoice object const newInvoice = { id: invoiceNumber, date: invoiceDate, vendor: vendor, project: project, poReference: poId, grnReference: grnId, invoiceAmount: invoiceAmount, invoiceVAT: invoiceVAT, invoiceTotal: invoiceTotal, poAmount: poAmount, grnValue: grnValue, variance: variance, matchStatus: matchStatus, paymentStatus: 'pending', notes: notes }; // Add to DataStore DataStore.invoiceCounter++; DataStore.invoices.unshift(newInvoice); // ═══ Update PR workflow to 'invoiced' ═══ if (poId) { const po = DataStore.purchaseOrders.find(p => p.id === poId); if (po) { // Find PR linked to this PO const pr = DataStore.purchaseRequisitions.find(p => p.relatedDocs?.po === poId || p.id === po.prReference ); if (pr && pr.currentStage < 6) { pr.currentStage = 6; pr.status = 'invoiced'; pr.relatedDocs.invoice = invoiceNumber; const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); pr.workflow.push({ stage: 'invoiced', date: dateStr, user: 'Mohamed Ahmed', notes: currentLang === 'ar' ? `تم مطابقة الفاتورة ${invoiceNumber} - الحالة: ${matchStatus}` : `Invoice ${invoiceNumber} matched - Status: ${matchStatus}` }); } } } // ═══ Sync invoice to daily_costs as subcontractor cost ═══ (async function syncInvoiceToCosts() { try { const API_URL = (typeof HAZ_CONFIG!=='undefined') ? HAZ_CONFIG.SUPABASE_URL : 'https://crjhpxgbbvmolurxpatz.supabase.co'; const API_KEY = (typeof HAZ_CONFIG!=='undefined') ? HAZ_CONFIG.SUPABASE_ANON_KEY : 'sb_publishable_Oq3gfK8qElVE4Jm1fWvkOw_022O5Rhf'; const H = { 'apikey': API_KEY, 'Authorization': 'Bearer ' + API_KEY, 'Content-Type': 'application/json', 'Prefer': 'resolution=merge-duplicates,return=minimal' }; // Resolve project let projectUUID = null; const projectName = newInvoice.project; if (projectName) { const pRes = await fetch(API_URL + '/rest/v1/projects?or=(name.eq.' + encodeURIComponent(projectName) + ',code.eq.' + encodeURIComponent(projectName) + ')&select=id&limit=1', { headers: H }); const pData = await pRes.json(); if (pData && pData[0]) projectUUID = pData[0].id; } if (projectUUID) { await fetch(API_URL + '/rest/v1/daily_costs', { method: 'POST', headers: H, body: JSON.stringify({ project_id: projectUUID, cost_date: newInvoice.date || new Date().toISOString().slice(0,10), cost_type: 'subcontractor', description: 'Procurement Invoice: ' + invoiceNumber + ' - ' + vendor, quantity: 1, unit: 'lump_sum', unit_rate: newInvoice.invoiceAmount, amount: newInvoice.invoiceTotal, reference_number: 'PINV-' + invoiceNumber, notes: 'PO: ' + poId + ', GRN: ' + grnId + ', Match: ' + matchStatus }) }); console.log('💰 Invoice synced to daily_costs'); } } catch(e) { console.warn('Invoice→costs sync failed:', e); } })(); saveAllData(); // Auto-save closeModal('invoiceModal'); showToast(currentLang === 'ar' ? `تم تسجيل الفاتورة ${invoiceNumber} بنجاح` : `Invoice ${invoiceNumber} recorded successfully`, 'success'); // Refresh table and stats renderInvoiceTable(); updateInvoiceStats(); } function renderInvoiceTable() { const tbody = document.getElementById('invoiceTableBody'); if (!tbody) return; const statusFilter = document.getElementById('filterInvoiceStatus')?.value || ''; const vendorFilter = document.getElementById('filterInvoiceVendor')?.value || ''; let filteredInvoices = DataStore.invoices; if (statusFilter) { if (statusFilter === 'approved') { filteredInvoices = filteredInvoices.filter(i => i.paymentStatus === 'approved'); } else { filteredInvoices = filteredInvoices.filter(i => i.matchStatus === statusFilter && i.paymentStatus !== 'approved'); } } if (vendorFilter) { filteredInvoices = filteredInvoices.filter(i => i.vendor === vendorFilter); } if (filteredInvoices.length === 0) { tbody.innerHTML = ` ${currentLang === 'ar' ? 'لا توجد فواتير' : 'No invoices found'} `; return; } let html = ''; filteredInvoices.forEach(invoice => { // Status badge let statusBadge; if (invoice.paymentStatus === 'approved') { statusBadge = 'Approved'; } else { const statusConfig = { matched: { class: 'approved', text: 'Matched' }, partial: { class: 'partial', text: 'Partial' }, discrepancy: { class: 'rejected', text: 'Discrepancy' }, pending: { class: 'pending', text: 'Pending' } }; const status = statusConfig[invoice.matchStatus] || statusConfig.pending; statusBadge = `${status.text}`; } // Variance display let varianceHtml; if (invoice.variance === 0 || Math.abs(invoice.variance) < 1) { varianceHtml = '0.00'; } else if (invoice.variance > 0) { varianceHtml = `+${invoice.variance.toLocaleString()}`; } else { varianceHtml = `${invoice.variance.toLocaleString()}`; } // Action buttons let actionButtons = ` `; if (invoice.paymentStatus !== 'approved') { if (invoice.matchStatus === 'matched' || invoice.matchStatus === 'partial') { actionButtons += ``; } else if (invoice.matchStatus === 'discrepancy') { actionButtons += ``; } } html += ` ${invoice.id} ${invoice.vendor} ${invoice.date} ${invoice.poReference} ${invoice.grnReference || '-'} ${invoice.invoiceTotal.toLocaleString()} ${invoice.poAmount.toLocaleString()} ${invoice.grnValue ? invoice.grnValue.toLocaleString() : '-'} ${varianceHtml} ${statusBadge}

${actionButtons}

`; }); tbody.innerHTML = html; } function viewInvoiceDetails(invoiceId) { const invoice = DataStore.invoices.find(i => i.id === invoiceId); if (!invoice) { showToast(currentLang === 'ar' ? 'الفاتورة غير موجودة' : 'Invoice not found', 'error'); return; } // Store current invoice ID for approval document.getElementById('viewInvoiceModal').dataset.invoiceId = invoiceId; // Status badge config const statusConfig = { matched: { class: 'approved', text: 'Matched | مطابق', icon: '✓' }, partial: { class: 'partial', text: 'Partial Match | مطابقة جزئية', icon: '⚡' }, discrepancy: { class: 'rejected', text: 'Discrepancy | تناقض', icon: '⚠️' } }; const status = invoice.paymentStatus === 'approved' ? { class: 'approved', text: 'Approved | معتمد', icon: '✓' } : (statusConfig[invoice.matchStatus] || statusConfig.matched); // Build variance display let varianceHtml = ''; if (invoice.variance === 0 || Math.abs(invoice.variance) < 1) { varianceHtml = `SAR 0.00 ✓`; } else if (invoice.variance > 0) { varianceHtml = `+SAR ${invoice.variance.toLocaleString()} ↑`; } else { varianceHtml = `SAR ${invoice.variance.toLocaleString()} ↓`; } // Build content const content = `

${invoice.id}

${invoice.date}

${status.text}

Vendor | المورد

${invoice.vendor}

Project | المشروع

${invoice.project}

PO Reference | مرجع أمر الشراء

${invoice.poReference}

GRN Reference | مرجع سند الاستلام

${invoice.grnReference || '-'}

🔍 3-Way Match Comparison | مقارنة المطابقة الثلاثية

PO Amount | أمر الشراء

SAR ${invoice.poAmount.toLocaleString()}

GRN Value | قيمة الاستلام

SAR ${(invoice.grnValue || 0).toLocaleString()}

Invoice Total | الفاتورة

SAR ${invoice.invoiceTotal.toLocaleString()}

VARIANCE | الفرق

${varianceHtml}

MATCH RESULT | نتيجة المطابقة

${status.icon}

${status.text}

${invoice.notes ? `

Notes | ملاحظات

${invoice.notes}

` : ''} ${invoice.paymentStatus === 'approved' ? `

✓ Approved for Payment | تمت الموافقة للدفع

By: ${invoice.approvedBy || 'System'} on ${invoice.approvedDate || 'N/A'}

` : ''} `; document.getElementById('viewInvoiceContent').innerHTML = content; document.getElementById('viewInvoiceTitle').textContent = `Invoice Details: ${invoice.id} | تفاصيل الفاتورة`; // Show/hide approve button const approveBtn = document.getElementById('approveInvoiceBtn'); if (invoice.paymentStatus === 'approved') { approveBtn.style.display = 'none'; } else { approveBtn.style.display = 'inline-flex'; if (invoice.matchStatus === 'discrepancy') { approveBtn.textContent = '⚠️ Approve with Discrepancy | الموافقة مع التناقض'; approveBtn.className = 'btn btn-warning'; } else { approveBtn.textContent = '✓ Approve for Payment | الموافقة للدفع'; approveBtn.className = 'btn btn-success'; } } openModal('viewInvoiceModal'); } function approveInvoiceForPayment() { const invoiceId = document.getElementById('viewInvoiceModal').dataset.invoiceId; const invoice = DataStore.invoices.find(i => i.id === invoiceId); if (!invoice) { showToast('Invoice not found', 'error'); return; } if (invoice.matchStatus === 'discrepancy') { if (!confirm(currentLang === 'ar' ? 'هذه الفاتورة بها تناقض. هل أنت متأكد من الموافقة؟' : 'This invoice has a discrepancy. Are you sure you want to approve it for payment?')) { return; } } // Update invoice invoice.paymentStatus = 'approved'; invoice.approvedBy = 'Mohamed Ahmed'; invoice.approvedDate = new Date().toISOString().split('T')[0]; // ═══ Update PR workflow to 'completed' ═══ if (invoice.poReference) { const po = DataStore.purchaseOrders.find(p => p.id === invoice.poReference); if (po) { const pr = DataStore.purchaseRequisitions.find(p => p.relatedDocs?.po === invoice.poReference || p.id === po.prReference ); if (pr && pr.currentStage < 7) { pr.currentStage = 7; pr.status = 'completed'; const now = new Date(); const dateStr = now.toISOString().slice(0, 16).replace('T', ' '); pr.workflow.push({ stage: 'completed', date: dateStr, user: 'Mohamed Ahmed', notes: currentLang === 'ar' ? `تمت الموافقة على الدفع - الفاتورة ${invoiceId}` : `Payment approved - Invoice ${invoiceId}` }); } } } saveAllData(); // ═══ SAVE TO STORAGE + SUPABASE ═══ closeModal('viewInvoiceModal'); showToast(currentLang === 'ar' ? `تمت الموافقة على الفاتورة ${invoiceId} للدفع` : `Invoice ${invoiceId} approved for payment`, 'success'); renderInvoiceTable(); updateInvoiceStats(); } function quickApproveInvoice(invoiceId) { const invoice = DataStore.invoices.find(i => i.id === invoiceId); if (invoice) { invoice.paymentStatus = 'approved'; invoice.approvedBy = 'Mohamed Ahmed'; invoice.approvedDate = new Date().toISOString().split('T')[0]; // Update PR workflow to completed if (invoice.poReference) { const po = DataStore.purchaseOrders.find(p => p.id === invoice.poReference); if (po) { const pr = DataStore.purchaseRequisitions.find(p => p.relatedDocs?.po === invoice.poReference || p.id === po.prReference ); if (pr && pr.currentStage < 7) { pr.currentStage = 7; pr.status = 'completed'; const now = new Date(); pr.workflow.push({ stage: 'completed', date: now.toISOString().slice(0, 16).replace('T', ' '), user: 'Mohamed Ahmed', notes: currentLang === 'ar' ? `تمت الموافقة السريعة - ${invoiceId}` : `Quick approved - ${invoiceId}` }); } } } saveAllData(); // ═══ SAVE ═══ showToast(currentLang === 'ar' ? `تمت الموافقة على ${invoiceId}` : `${invoiceId} approved`, 'success'); renderInvoiceTable(); updateInvoiceStats(); renderPRTable(); // Refresh PR table to show completed status } } function updateInvoiceStats() { const invoices = DataStore.invoices; const matched = invoices.filter(i => i.matchStatus === 'matched' && i.paymentStatus !== 'approved').length; const partial = invoices.filter(i => i.matchStatus === 'partial' && i.paymentStatus !== 'approved').length; const discrepancy = invoices.filter(i => i.matchStatus === 'discrepancy' && i.paymentStatus !== 'approved').length; const approved = invoices.filter(i => i.paymentStatus === 'approved').length; const matchedEl = document.getElementById('invoiceStatMatched'); const partialEl = document.getElementById('invoiceStatPartial'); const discrepancyEl = document.getElementById('invoiceStatDiscrepancy'); const approvedEl = document.getElementById('invoiceStatApproved'); if (matchedEl) matchedEl.textContent = matched; if (partialEl) partialEl.textContent = partial; if (discrepancyEl) discrepancyEl.textContent = discrepancy; if (approvedEl) approvedEl.textContent = approved; } function updateInvoiceVendorFilter() { const select = document.getElementById('filterInvoiceVendor'); if (!select) return; const vendors = [...new Set(DataStore.invoices.map(i => i.vendor))]; let html = ''; vendors.forEach(v => { html += ``; }); select.innerHTML = html; } function clearInvoiceFilters() { const statusEl = document.getElementById('filterInvoiceStatus'); const vendorEl = document.getElementById('filterInvoiceVendor'); if (statusEl) statusEl.value = ''; if (vendorEl) vendorEl.value = ''; renderInvoiceTable(); showToast(currentLang === 'ar' ? 'تم مسح الفلاتر' : 'Filters cleared', 'info'); } function submitVendor() { const name = document.querySelector('#vendorModal input[placeholder="Enter company name"]').value; const cr = document.querySelector('#vendorModal input[placeholder="10 digit CR number"]').value; if (!name || !cr) { showToast('Please fill in all required fields', 'error'); return; } // Collect all vendor form fields const vendorData = { id: 'VND-' + Date.now(), name: name, cr: cr, code: cr, type: document.querySelector('#vendorModal select')?.value || 'supplier', phone: document.querySelector('#vendorModal input[type="tel"]')?.value || '', email: document.querySelector('#vendorModal input[type="email"]')?.value || '', address: '', status: 'active', createdAt: new Date().toISOString() }; // Check for duplicate CR if (DataStore.vendors.some(v => v.cr === cr)) { showToast(currentLang === 'ar' ? 'رقم السجل التجاري موجود مسبقاً' : 'CR number already exists', 'error'); return; } // Add to DataStore DataStore.vendors.push(vendorData); saveAllData(); closeModal('vendorModal'); showToast(`Vendor "${name}" added successfully | تمت إضافة المورد "${name}" بنجاح`, 'success'); } // ========================================== // UTILITY FUNCTIONS // ========================================== function exportData(type) { const message = currentLang === 'ar' ? `تم تصدير بيانات ${type} إلى Excel` : `${type} data exported to Excel`; showToast(message, 'success'); } function viewRecord(id, type) { if (type === 'PR') { viewPR(id); } else if (type === 'RFQ') { viewRFQDetails(id); } else { showToast(`${currentLang === 'ar' ? 'عرض' : 'Viewing'} ${type}: ${id}`, 'info'); } } function viewPR(prId) { const pr = DataStore.purchaseRequisitions.find(p => p.id === prId); if (!pr) { showToast(currentLang === 'ar' ? 'لم يتم العثور على طلب الشراء' : 'PR not found', 'error'); return; } const stageData = pr.currentStage >= 0 ? DataStore.workflowStages[pr.currentStage] : { name: 'Unknown', nameAr: 'غير معروف', color: '#95a5a6' }; const statusText = currentLang === 'ar' ? stageData.nameAr : stageData.name; // Calculate items total let itemsHtml = ''; let totalAmount = 0; if (pr.items && pr.items.length > 0) { pr.items.forEach((item, idx) => { const itemTotal = (item.qty || 0) * (item.price || 0); totalAmount += itemTotal; itemsHtml += ` ${idx + 1} ${item.desc || '-'} ${item.unit || '-'} ${item.qty || 0} SAR ${(item.price || 0).toLocaleString()} SAR ${itemTotal.toLocaleString()} `; }); } const content = `

${currentLang === 'ar' ? 'معلومات الطلب' : 'Request Information'}

${currentLang === 'ar' ? 'رقم الطلب:' : 'PR Number:'} ${pr.id}

${currentLang === 'ar' ? 'التاريخ:' : 'Date:'} ${pr.date}

${currentLang === 'ar' ? 'المشروع:' : 'Project:'} ${pr.project}

${currentLang === 'ar' ? 'القسم:' : 'Department:'} ${pr.department}

${currentLang === 'ar' ? 'تفاصيل إضافية' : 'Additional Details'}

${currentLang === 'ar' ? 'طلب بواسطة:' : 'Requested By:'} ${pr.requestedBy}

${currentLang === 'ar' ? 'الأولوية:' : 'Priority:'} ${pr.priority}

${currentLang === 'ar' ? 'الحالة:' : 'Status:'} ${statusText}

${currentLang === 'ar' ? 'المبلغ الإجمالي:' : 'Total Amount:'} SAR ${pr.amount.toLocaleString()}

📦 ${currentLang === 'ar' ? 'بنود الطلب' : 'Line Items'}

${itemsHtml || ``}

#	${currentLang === 'ar' ? 'الوصف' : 'Description'}	${currentLang === 'ar' ? 'الوحدة' : 'Unit'}	${currentLang === 'ar' ? 'الكمية' : 'Qty'}	${currentLang === 'ar' ? 'السعر' : 'Price'}	${currentLang === 'ar' ? 'المجموع' : 'Total'}
${currentLang === 'ar' ? 'لا توجد بنود' : 'No items'}
${currentLang === 'ar' ? 'الإجمالي:' : 'Total:'}					SAR ${totalAmount.toLocaleString()}

${pr.relatedDocs && Object.keys(pr.relatedDocs).length > 0 ? `

📎 ${currentLang === 'ar' ? 'المستندات المرتبطة' : 'Related Documents'}

${pr.relatedDocs.rfq ? `📨 ${pr.relatedDocs.rfq}` : ''} ${pr.relatedDocs.po ? `📄 ${pr.relatedDocs.po}` : ''} ${pr.relatedDocs.grn ? `📥 ${pr.relatedDocs.grn}` : ''} ${pr.relatedDocs.invoice ? `🧾 ${pr.relatedDocs.invoice}` : ''}

` : ''} `; document.getElementById('viewPRContent').innerHTML = content; openModal('viewPRModal'); } function viewRFQDetails(rfqId) { const rfq = DataStore.rfqs.find(r => r.id === rfqId); if (!rfq) { showToast(currentLang === 'ar' ? 'لم يتم العثور على طلب العرض' : 'RFQ not found', 'error'); return; } const statusColors = { 'draft': { color: '#95a5a6', text: currentLang === 'ar' ? 'مسودة' : 'Draft' }, 'open': { color: '#f39c12', text: currentLang === 'ar' ? 'مفتوح' : 'Open' }, 'complete': { color: '#3498db', text: currentLang === 'ar' ? 'مكتمل' : 'Complete' }, 'awarded': { color: '#2bbcb3', text: currentLang === 'ar' ? 'تم الترسية' : 'Awarded' }, 'closed': { color: '#c0392b', text: currentLang === 'ar' ? 'مغلق' : 'Closed' } }; const status = statusColors[rfq.status] || statusColors['open']; // Items table let itemsHtml = ''; if (rfq.items && rfq.items.length > 0) { rfq.items.forEach((item, idx) => { itemsHtml += ` ${idx + 1} ${item.desc || '-'} ${item.unit || '-'} ${item.qty || 0} `; }); } // Vendors list let vendorsHtml = ''; if (rfq.vendorsInvited && rfq.vendorsInvited.length > 0) { rfq.vendorsInvited.forEach(vendor => { vendorsHtml += `

🏢 ${vendor}

`; }); } const content = `

${currentLang === 'ar' ? 'معلومات طلب العرض' : 'RFQ Information'}

${currentLang === 'ar' ? 'رقم الطلب:' : 'RFQ Number:'} ${rfq.id}

${currentLang === 'ar' ? 'طلب الشراء المرجعي:' : 'Reference PR:'} ${rfq.prReference}

${currentLang === 'ar' ? 'العنوان:' : 'Title:'} ${rfq.title}

${currentLang === 'ar' ? 'المشروع:' : 'Project:'} ${rfq.project}

${currentLang === 'ar' ? 'التواريخ والحالة' : 'Dates & Status'}

${currentLang === 'ar' ? 'تاريخ الإرسال:' : 'Sent Date:'} ${rfq.sentDate}

${currentLang === 'ar' ? 'تاريخ الاستحقاق:' : 'Due Date:'} ${rfq.dueDate}

${currentLang === 'ar' ? 'الردود:' : 'Responses:'} ${rfq.responses}/${rfq.vendorsInvited ? rfq.vendorsInvited.length : 0}

${currentLang === 'ar' ? 'الحالة:' : 'Status:'} ${status.text}

📦 ${currentLang === 'ar' ? 'البنود المطلوبة' : 'Required Items'}

${itemsHtml || ``}

#	${currentLang === 'ar' ? 'الوصف' : 'Description'}	${currentLang === 'ar' ? 'الوحدة' : 'Unit'}	${currentLang === 'ar' ? 'الكمية' : 'Qty'}
${currentLang === 'ar' ? 'لا توجد بنود' : 'No items'}

🏢 ${currentLang === 'ar' ? 'الموردون المدعوون' : 'Invited Vendors'}

${vendorsHtml || `

${currentLang === 'ar' ? 'لا يوجد موردون' : 'No vendors'}

`; document.getElementById('viewRFQContent').innerHTML = content; openModal('viewRFQModal'); } function printViewedPR() { window.print(); } function printViewedRFQ() { window.print(); } function awardBid(vendor) { showToast(`Bid awarded to ${vendor}`, 'success'); setTimeout(() => { showSection('purchaseorders'); openModal('poModal'); }, 1500); } // ========================================== // USER MANAGEMENT // ========================================== let usersData = JSON.parse(localStorage.getItem('HAz_Users') || '[]'); let editingUserId = null; function renderUsersTable() { const tbody = document.getElementById('usersTableBody'); if (!tbody) return; if (usersData.length === 0) { tbody.innerHTML = `

👥

No users added yet. Click "Add User" to get started. `; return; } tbody.innerHTML = usersData.map((user, index) => `

${user.name.split(' ').map(n => n[0]).join('').toUpperCase().slice(0, 2)}

${user.name}

${user.department || '-'}

${user.email} ${user.role} ${user.status === 'Active' ? '● Active' : '○ Inactive'}

`).join(''); } function saveUser() { const name = document.getElementById('userName').value.trim(); const email = document.getElementById('userEmail').value.trim(); const phone = document.getElementById('userPhone').value.trim(); const role = document.getElementById('userRole').value; const department = document.getElementById('userDepartment').value; const status = document.getElementById('userStatus').value; // Validation if (!name || !email || !role) { showToast('Please fill in required fields | يرجى ملء الحقول المطلوبة', 'error'); return; } // Email validation if (!email.includes('@')) { showToast('Please enter a valid email | يرجى إدخال بريد إلكتروني صحيح', 'error'); return; } // Get permissions const permissions = { viewProjects: document.getElementById('permViewProjects').checked, createProjects: document.getElementById('permCreateProjects').checked, viewPR: document.getElementById('permViewPR').checked, createPR: document.getElementById('permCreatePR').checked, approvePR: document.getElementById('permApprovePR').checked, createRFQ: document.getElementById('permCreateRFQ').checked, viewPO: document.getElementById('permViewPO').checked, createPO: document.getElementById('permCreatePO').checked, createGRN: document.getElementById('permCreateGRN').checked, viewInvoice: document.getElementById('permViewInvoice').checked, approveInvoice: document.getElementById('permApproveInvoice').checked, manageVendors: document.getElementById('permManageVendors').checked }; const userData = { id: editingUserId !== null ? usersData[editingUserId].id : Date.now(), name, email, phone, role, department, status, permissions, createdAt: editingUserId !== null ? usersData[editingUserId].createdAt : new Date().toISOString() }; if (editingUserId !== null) { usersData[editingUserId] = userData; showToast('User updated successfully | تم تحديث المستخدم بنجاح', 'success'); } else { // Check for duplicate email if (usersData.some(u => u.email.toLowerCase() === email.toLowerCase())) { showToast('Email already exists | البريد الإلكتروني موجود مسبقاً', 'error'); return; } usersData.push(userData); showToast('User added successfully | تم إضافة المستخدم بنجاح', 'success'); } // Save to localStorage localStorage.setItem('HAz_Users', JSON.stringify(usersData)); // Refresh table and close modal renderUsersTable(); closeModal('userModal'); resetUserForm(); } function editUser(index) { const user = usersData[index]; editingUserId = index; document.getElementById('userModalTitle').textContent = 'Edit User | تعديل المستخدم'; document.getElementById('userName').value = user.name; document.getElementById('userEmail').value = user.email; document.getElementById('userPhone').value = user.phone || ''; document.getElementById('userRole').value = user.role; document.getElementById('userDepartment').value = user.department || ''; document.getElementById('userStatus').value = user.status; // Set permissions if (user.permissions) { document.getElementById('permViewProjects').checked = user.permissions.viewProjects !== false; document.getElementById('permCreateProjects').checked = user.permissions.createProjects || false; document.getElementById('permViewPR').checked = user.permissions.viewPR; document.getElementById('permCreatePR').checked = user.permissions.createPR; document.getElementById('permApprovePR').checked = user.permissions.approvePR; document.getElementById('permCreateRFQ').checked = user.permissions.createRFQ || false; document.getElementById('permViewPO').checked = user.permissions.viewPO; document.getElementById('permCreatePO').checked = user.permissions.createPO; document.getElementById('permCreateGRN').checked = user.permissions.createGRN || false; document.getElementById('permViewInvoice').checked = user.permissions.viewInvoice; document.getElementById('permApproveInvoice').checked = user.permissions.approveInvoice; document.getElementById('permManageVendors').checked = user.permissions.manageVendors; } openModal('userModal'); } function deleteUser(index) { if (confirm('Are you sure you want to delete this user? | هل أنت متأكد من حذف هذا المستخدم؟')) { usersData.splice(index, 1); localStorage.setItem('HAz_Users', JSON.stringify(usersData)); renderUsersTable(); showToast('User deleted successfully | تم حذف المستخدم بنجاح', 'success'); } } function resetUserForm() { editingUserId = null; document.getElementById('userModalTitle').textContent = 'Add New User | إضافة مستخدم جديد'; document.getElementById('userName').value = ''; document.getElementById('userEmail').value = ''; document.getElementById('userPhone').value = ''; document.getElementById('userRole').value = ''; document.getElementById('userDepartment').value = ''; document.getElementById('userStatus').value = 'Active'; // Reset permissions document.getElementById('permViewProjects').checked = true; document.getElementById('permCreateProjects').checked = false; document.getElementById('permViewPR').checked = true; document.getElementById('permCreatePR').checked = false; document.getElementById('permApprovePR').checked = false; document.getElementById('permCreateRFQ').checked = false; document.getElementById('permViewPO').checked = true; document.getElementById('permCreatePO').checked = false; document.getElementById('permCreateGRN').checked = false; document.getElementById('permViewInvoice').checked = true; document.getElementById('permApproveInvoice').checked = false; document.getElementById('permManageVendors').checked = false; } function saveSettings() { // Get all settings values const settings = { companyName: document.getElementById('settingCompanyName')?.value || '', cr: document.getElementById('settingCR')?.value || '', vat: document.getElementById('settingVAT')?.value || '', currency: document.getElementById('settingCurrency')?.value || 'SAR', vatRate: document.getElementById('settingVATRate')?.value || '15', fiscalYear: document.getElementById('settingFiscalYear')?.value || 'January', address: document.getElementById('settingAddress')?.value || '', // Approval levels approvalLevel1: document.getElementById('approvalLevel1')?.value || '10000', approvalLevel2: document.getElementById('approvalLevel2')?.value || '50000', approver1: document.getElementById('approver1')?.value || 'Department Head', approver2: document.getElementById('approver2')?.value || 'Finance Manager', approver3: document.getElementById('approver3')?.value || 'CEO', // Numbering prPrefix: document.getElementById('prPrefix')?.value || 'PR', poPrefix: document.getElementById('poPrefix')?.value || 'PO', rfqPrefix: document.getElementById('rfqPrefix')?.value || 'RFQ', grnPrefix: document.getElementById('grnPrefix')?.value || 'GRN', includeYear: document.getElementById('includeYear')?.checked || true }; // Save to localStorage localStorage.setItem('HAz_ProcurementSettings', JSON.stringify(settings)); showToast('Settings saved successfully | تم حفظ الإعدادات بنجاح', 'success'); console.log('Settings saved:', settings); } // Load saved settings on page load function loadSettings() { const saved = localStorage.getItem('HAz_ProcurementSettings'); if (saved) { const settings = JSON.parse(saved); // General if (document.getElementById('settingCompanyName')) document.getElementById('settingCompanyName').value = settings.companyName || ''; if (document.getElementById('settingCR')) document.getElementById('settingCR').value = settings.cr || ''; if (document.getElementById('settingVAT')) document.getElementById('settingVAT').value = settings.vat || ''; if (document.getElementById('settingCurrency')) document.getElementById('settingCurrency').value = settings.currency || 'SAR'; if (document.getElementById('settingVATRate')) document.getElementById('settingVATRate').value = settings.vatRate || '15'; if (document.getElementById('settingFiscalYear')) document.getElementById('settingFiscalYear').value = settings.fiscalYear || 'January'; if (document.getElementById('settingAddress')) document.getElementById('settingAddress').value = settings.address || ''; // Approval workflow if (document.getElementById('approvalLevel1')) document.getElementById('approvalLevel1').value = settings.approvalLevel1 || '10000'; if (document.getElementById('approvalLevel2')) document.getElementById('approvalLevel2').value = settings.approvalLevel2 || '50000'; if (document.getElementById('approver1')) document.getElementById('approver1').value = settings.approver1 || 'Department Head'; if (document.getElementById('approver2')) document.getElementById('approver2').value = settings.approver2 || 'Finance Manager'; if (document.getElementById('approver3')) document.getElementById('approver3').value = settings.approver3 || 'CEO'; // Numbering if (document.getElementById('prPrefix')) document.getElementById('prPrefix').value = settings.prPrefix || 'PR'; if (document.getElementById('poPrefix')) document.getElementById('poPrefix').value = settings.poPrefix || 'PO'; if (document.getElementById('rfqPrefix')) document.getElementById('rfqPrefix').value = settings.rfqPrefix || 'RFQ'; if (document.getElementById('grnPrefix')) document.getElementById('grnPrefix').value = settings.grnPrefix || 'GRN'; if (document.getElementById('includeYear')) document.getElementById('includeYear').checked = settings.includeYear !== false; console.log('Settings loaded:', settings); } } // ========================================== // SETTINGS TAB SWITCHING // ========================================== function initSettingsTabs() { const settingsTabs = document.getElementById('settingsTabs'); if (!settingsTabs) return; settingsTabs.querySelectorAll('.tab').forEach(tab => { tab.addEventListener('click', function() { const tabId = this.getAttribute('data-tab'); // Remove active from all tabs settingsTabs.querySelectorAll('.tab').forEach(t => t.classList.remove('active')); this.classList.add('active'); // Hide all tab contents document.querySelectorAll('.settings-tab-content').forEach(content => { content.style.display = 'none'; }); // Show selected tab content const targetContent = document.getElementById('tab-' + tabId); if (targetContent) { targetContent.style.display = 'block'; } }); }); } // ========================================== // TAB SWITCHING (General) document.querySelectorAll('.tab').forEach(tab => { tab.addEventListener('click', function() { this.parentElement.querySelectorAll('.tab').forEach(t => t.classList.remove('active')); this.classList.add('active'); }); }); // ========================================== // STAT CARD NAVIGATION // ========================================== document.querySelectorAll('.stat-card').forEach(card => { card.addEventListener('click', function() { const classes = this.classList; if (classes.contains('pending') || classes.contains('approved')) { showSection('requisitions'); } else if (classes.contains('orders')) { showSection('purchaseorders'); } else if (classes.contains('vendors')) { showSection('vendors'); } else if (classes.contains('budget')) { showSection('reports'); } else if (classes.contains('grn')) { showSection('grn'); } }); }); // ========================================== // INTEGRATION CARD NAVIGATION // ========================================== document.querySelectorAll('.integration-card').forEach(card => { card.addEventListener('click', function() { showSection('integration'); }); }); // ========================================== // VENDOR CARD CLICKS // ========================================== document.querySelectorAll('.vendor-card').forEach(card => { card.addEventListener('click', function() { const vendorName = this.querySelector('h3').textContent; showToast(`Viewing vendor: ${vendorName}`, 'info'); }); }); // ========================================== // CHART CLICK HANDLER // ========================================== document.querySelectorAll('.chart-placeholder').forEach(chart => { chart.addEventListener('click', function() { if (!this.querySelector('canvas') || typeof Chart === 'undefined') { showToast(currentLang === 'ar' ? 'جاري تحميل الرسوم البيانية...' : 'Loading charts...', 'info'); } }); }); // ========================================== // KEYBOARD SHORTCUTS // ========================================== document.addEventListener('keydown', function(e) { if (e.key === 'Escape') { document.querySelectorAll('.modal-overlay.active').forEach(modal => { modal.classList.remove('active'); }); document.body.style.overflow = ''; } if ((e.ctrlKey || e.metaKey) && e.key === 'n') { e.preventDefault(); openModal('prModal'); } }); // ========================================== // SEARCH FUNCTIONALITY // ========================================== document.querySelector('.search-input').addEventListener('keyup', function(e) { if (e.key === 'Enter') { const query = this.value.toLowerCase(); if (query.includes('pr')) showSection('requisitions'); else if (query.includes('po')) showSection('purchaseorders'); else if (query.includes('vendor')) showSection('vendors'); else if (query.includes('grn')) showSection('grn'); else if (query.includes('rfq')) showSection('rfq'); showToast(`Searching for: ${this.value}`, 'info'); } }); // ========================================== // MOBILE SIDEBAR - Already defined above // ========================================== // Add mobile menu button if not exists document.addEventListener('DOMContentLoaded', async function() { // Load saved data from localStorage loadAllData(); // ═══════════════════════════════════════════════════════════════ // SUPABASE: Load projects as PRIMARY source (AWAIT before render) // ═══════════════════════════════════════════════════════════════ try { const API_URL = (typeof HAZ_CONFIG!=='undefined') ? HAZ_CONFIG.SUPABASE_URL : 'https://crjhpxgbbvmolurxpatz.supabase.co'; const API_KEY = (typeof HAZ_CONFIG!=='undefined') ? HAZ_CONFIG.SUPABASE_ANON_KEY : 'sb_publishable_Oq3gfK8qElVE4Jm1fWvkOw_022O5Rhf'; const res = await fetch(API_URL + '/rest/v1/projects?select=*&order=code', { headers: { 'apikey': API_KEY, 'Authorization': 'Bearer ' + API_KEY } }); const supaProjects = await res.json(); if (supaProjects && supaProjects.length > 0 && !supaProjects.error) { supaProjects.forEach(sp => { // Normalize status: map Supabase statuses to Procurement statuses const statusMap = {'planning':'active', 'in_progress':'active', 'on_hold':'on-hold', 'completed':'completed', 'cancelled':'cancelled'}; const normalizedStatus = statusMap[sp.status] || sp.status || 'active'; const existing = DataStore.projects.find(p => p.code === sp.code || p.name === sp.name); if (existing) { // UPDATE existing project with Supabase data (Supabase is source of truth) existing.id = sp.id; existing.code = sp.code; existing.name = sp.name; existing.nameAr = sp.name_ar || existing.nameAr; existing.client = sp.client || existing.client; existing.status = normalizedStatus; existing.budget = sp.budget || sp.contract_value || existing.budget; } else { DataStore.projects.push({ id: sp.id, code: sp.code, name: sp.name, nameAr: sp.name_ar, client: sp.client || '', clientAr: sp.client_ar || '', location: sp.location || '', type: sp.type || 'Infrastructure', status: normalizedStatus, budget: sp.budget || sp.contract_value || 0, startDate: sp.start_date, endDate: sp.end_date, progress: sp.progress || 0 }); } }); console.log('🛒 Procurement: Loaded', supaProjects.length, 'projects from Supabase (awaited)'); // Also load vendors from Supabase try { const vRes = await fetch(API_URL + '/rest/v1/vendors?select=*&order=name', { headers: { 'apikey': API_KEY, 'Authorization': 'Bearer ' + API_KEY } }); const supaVendors = await vRes.json(); if (supaVendors && supaVendors.length > 0 && !supaVendors.error) { supaVendors.forEach(sv => { if (!DataStore.vendors.find(v => v.name === sv.name)) { DataStore.vendors.push({ id: sv.id, name: sv.name, nameAr: sv.name_ar || '', contact: sv.contact_person || '', phone: sv.phone || '', email: sv.email || '', category: sv.category || '', rating: sv.rating || 0, status: sv.status || 'active' }); } }); console.log('🛒 Procurement: Loaded', supaVendors.length, 'vendors from Supabase'); } } catch(e) { console.warn('Vendor fetch failed:', e); } } } catch(e) { console.warn('Procurement Supabase fetch failed:', e); } // Render project table renderProjectTable(); // Render PR tables with workflow tracking renderPRTable(); // Render RFQ table renderRFQTable(); // Render PO table with Bid Analysis links renderPOTable(); // Render GRN table renderGRNTable(); // Render Invoice table and stats renderInvoiceTable(); updateInvoiceStats(); updateInvoiceVendorFilter(); // Update all project dropdowns updateAllProjectDropdowns(); // Update dashboard stats updateDashboardStats(); // ========================================== // PR LINE ITEMS EVENT DELEGATION // This ensures totals calculate for dynamically added rows // ========================================== const prLineItemsTable = document.getElementById('prLineItems'); if (prLineItemsTable) { prLineItemsTable.addEventListener('input', function(e) { const target = e.target; if (target.classList.contains('line-qty') || target.classList.contains('line-price')) { calculateLineItem(target); } }); // Also handle change events for number inputs prLineItemsTable.addEventListener('change', function(e) { const target = e.target; if (target.classList.contains('line-qty') || target.classList.contains('line-price')) { calculateLineItem(target); } }); } // ========================================== // PO LINE ITEMS EVENT DELEGATION // This ensures totals calculate for dynamically added rows // ========================================== const poLineItemsTable = document.getElementById('poLineItems'); if (poLineItemsTable) { poLineItemsTable.addEventListener('input', function(e) { const target = e.target; if (target.classList.contains('po-qty') || target.classList.contains('po-price') || target.type === 'number') { calculatePOTotals(); } }); // Also handle change events for number inputs poLineItemsTable.addEventListener('change', function(e) { const target = e.target; if (target.classList.contains('po-qty') || target.classList.contains('po-price') || target.type === 'number') { calculatePOTotals(); } }); } // Initialize totals when PR modal opens const prModal = document.getElementById('prModal'); if (prModal) { const observer = new MutationObserver(function(mutations) { mutations.forEach(function(mutation) { if (mutation.attributeName === 'class' && prModal.classList.contains('active')) { // Recalculate totals when modal opens setTimeout(recalculatePRTotals, 100); } }); }); observer.observe(prModal, { attributes: true }); } // Apply initial translations (default is English) // applyTranslations(); // Uncomment if you want to verify translations work on load // Add click handlers to all table action buttons document.querySelectorAll('table button').forEach(btn => { btn.addEventListener('click', function(e) { e.stopPropagation(); const row = this.closest('tr'); const id = row?.querySelector('td:first-child strong')?.textContent || 'Record'; const title = this.getAttribute('title') || ''; if (title.includes('View')) viewRecord(id, 'Record'); else if (title.includes('Edit')) editRecord(id, 'PR'); else if (title.includes('Print')) printRecord(id); else if (title.includes('Create PO')) { showSection('purchaseorders'); openModal('poModal'); } else if (title.includes('Receive') || title === '📥') openModal('grnModal'); else if (title.includes('Compare')) showSection('bidanalysis'); else { // Generic action showToast(`Action performed on ${id}`, 'info'); } }); }); // Notification button document.querySelector('.header-btn')?.addEventListener('click', function() { showToast('You have 3 new notifications', 'info'); }); // Add animation keyframes const style = document.createElement('style'); style.textContent = ` @keyframes toastSlide { from { opacity: 0; transform: translateX(100px); } to { opacity: 1; transform: translateX(0); } } `; document.head.appendChild(style); // Initialize settings tabs initSettingsTabs(); renderUsersTable(); loadSettings(); // Auto-save before leaving page window.addEventListener('beforeunload', function() { saveAllData(); console.log('💾 Auto-saved before page unload'); }); console.log('Procurement Management System initialized successfully'); // Initialize project sidebar setTimeout(() => { if (window.HAzProjectSidebar) { HAzProjectSidebar.init({ onChange: function(selectedIds) { // Update count display const countEl = document.getElementById('procurementSelectedCount'); if (countEl) { countEl.innerHTML = selectedIds.length === 0 ? 'جميع المشاريع (اضغط الزر الأخضر ←)' : `${selectedIds.length} مشاريع مختارة (اضغط الزر الأخضر ←)`; } // Refresh views if (typeof renderDashboard === 'function') renderDashboard(); if (typeof renderPRTable === 'function') renderPRTable(); if (typeof renderPOTable === 'function') renderPOTable(); if (typeof filterPRTable === 'function') filterPRTable(); } }); } }, 300); }); // Listen for project changes // ═══ Project Filter Integration ═══ // _hazFilteredProjectNames declared earlier in DASHBOARD STATS section window.addEventListener('haz-projects-changed', function(e) { const countEl = document.getElementById('procurementSelectedCount'); const projects = e.detail.projects || []; // Store selected project names/codes for filtering _hazFilteredProjectNames = projects.map(p => p.name || p.code || String(p.id)); // Also store codes separately const selectedCodes = projects.map(p => p.code || ''); if (countEl) { const count = projects.length; countEl.innerHTML = count === 0 ? 'جميع المشاريع (اضغط الزر الأخضر ←)' : `${count} مشاريع مختارة (اضغط الزر الأخضر ←)`; } // Set DataStore.activeProjectId for single project if (projects.length === 1 && typeof DataStore !== 'undefined') { const match = DataStore.projects.find(p => p.code === projects[0].code || p.name === projects[0].name || String(p.id) === String(projects[0].id) ); if (match) DataStore.activeProjectId = match.id || match.code; } // Sync filter dropdowns in PR section const filterReqProject = document.getElementById('filterReqProject'); if (filterReqProject && projects.length === 1) { const opts = Array.from(filterReqProject.options); const match = opts.find(o => selectedCodes.includes(o.value) || _hazFilteredProjectNames.includes(o.value) ); if (match) filterReqProject.value = match.value; } else if (filterReqProject && projects.length !== 1) { filterReqProject.value = ''; } if (typeof renderDashboard === 'function') renderDashboard(); if (typeof renderPRTable === 'function') renderPRTable(); if (typeof filterPRTable === 'function') filterPRTable(); if (typeof renderProjectTable === 'function') renderProjectTable(); }); // Listen for project selection from parent filter (iframe) window.addEventListener('message', function(e) { if (e.data && e.data.type === 'haz-project-selected') { const projects = e.data.projects || []; if (projects.length > 0 && typeof DataStore !== 'undefined') { DataStore.activeProjectId = projects[0].id; if (typeof renderDashboard === 'function') renderDashboard(); if (typeof renderPRTable === 'function') renderPRTable(); } } });

New Requisition

Send RFQ

Create PO

Receive Goods

Select an RFQ to View Bid Analysis

No Vendors Yet

Purchase Requisition Approval Levels

Document Numbering Format

Email Notifications

Users Management

⚠️ Data Management | إدارة البيانات

New Purchase Requisition

Line Items

Create Request for Quotation

Create Purchase Order

Order Items

Record Goods Receipt Note

Items Received

📊 Workflow Tracking

Add New Vendor

Add New Project

📋 Purchase Requisition Details

📨 RFQ Details

📝 Enter Vendor Quotation

🧾 Record Vendor Invoice | تسجيل فاتورة المورد

🔍 3-Way Match Preview | معاينة المطابقة الثلاثية

Invoice Details | تفاصيل الفاتورة

Add New User | إضافة مستخدم جديد

Permissions | الصلاحيات

${currentLang === 'ar' ? 'اختر طلب عرض أسعار لعرض التحليل' : 'Select an RFQ to View Bid Analysis'}

${rfq.id}: ${rfq.title}

🔗 ${currentLang === 'ar' ? 'المستندات المرتبطة' : 'Linked Documents'}

📄 ${currentLang === 'ar' ? 'تفاصيل أمر الشراء' : 'Purchase Order Details'}

📦 ${currentLang === 'ar' ? 'البنود' : 'Order Items'}

${grn.id}

${currentLang === 'ar' ? 'العناصر المستلمة' : 'Received Items'}

${currentLang === 'ar' ? 'تفاصيل سند الاستلام' : 'GRN Details'}

${invoice.id}

🔍 3-Way Match Comparison | مقارنة المطابقة الثلاثية

${currentLang === 'ar' ? 'معلومات الطلب' : 'Request Information'}

${currentLang === 'ar' ? 'تفاصيل إضافية' : 'Additional Details'}

📦 ${currentLang === 'ar' ? 'بنود الطلب' : 'Line Items'}

📎 ${currentLang === 'ar' ? 'المستندات المرتبطة' : 'Related Documents'}

${currentLang === 'ar' ? 'معلومات طلب العرض' : 'RFQ Information'}

${currentLang === 'ar' ? 'التواريخ والحالة' : 'Dates & Status'}

📦 ${currentLang === 'ar' ? 'البنود المطلوبة' : 'Required Items'}

🏢 ${currentLang === 'ar' ? 'الموردون المدعوون' : 'Invited Vendors'}