Hugging Face's logo

Spaces:
Amiali6262
/
https-huggingface-co-amiali62623
Running

App Files Community
https-huggingface-co-amiali62623 / index.html
Amiali6262's picture
Amiali6262
در فرم تعریف تسهیلات بانکی گزینه افزودن اضافه شود - Follow Up Deployment
9fbe144 verified
raw
history blame contribute delete
56.4 kB
<!DOCTYPE html>
<html dir="rtl" lang="fa">
<head>
 <meta charset="UTF-8">
 <meta name="viewport" content="width=device-width, initial-scale=1.0">
 <title>سیستم مدیریت تسهیلات بانکی</title>
 <script src="https://cdn.tailwindcss.com"></script>
 <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/persian-datepicker/dist/css/persian-datepicker.min.css">
 <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
 <script src="https://cdn.jsdelivr.net/npm/persian-date@1.2.0/dist/persian-date.min.js"></script>
 <script src="https://cdn.jsdelivr.net/npm/persian-datepicker/dist/js/persian-datepicker.min.js"></script>
 <script src="https://unpkg.com/persian-number@1.1.0/dist/persian-number.min.js"></script>
 <style>
 @font-face {
 font-family: 'IRANSans';
 src: url('https://cdn.fontcdn.ir/Font/Persian/IRANSans/IRANSansWeb.eot');
 src: url('https://cdn.fontcdn.ir/Font/Persian/IRANSans/IRANSansWeb.eot?#iefix') format('embedded-opentype'),
 url('https://cdn.fontcdn.ir/Font/Persian/IRANSans/IRANSansWeb.woff2') format('woff2'),
 url('https://cdn.fontcdn.ir/Font/Persian/IRANSans/IRANSansWeb.woff') format('woff'),
 url('https://cdn.fontcdn.ir/Font/Persian/IRANSans/IRANSansWeb.ttf') format('truetype');
 font-weight: normal;
 font-style: normal;
 }
 body {
 font-family: 'IRANSans', sans-serif;
 }
 .table-container {
 overflow-x: auto;
 }
 .active-tab {
 background-color: #3b82f6;
 color: white;
 }
 .hidden {
 display: none;
 }
 </style>
</head>
<body class="bg-gray-100">
 <div class="container mx-auto px-4 py-8">
 <h1 class="text-3xl font-bold text-center mb-8 text-blue-700">سیستم مدیریت تسهیلات بانکی</h1>
<!-- Navigation Tabs -->
 <div class="flex mb-6 border-b">
 <button id="loanTabBtn" class="px-6 py-2 rounded-t-lg active-tab" onclick="showTab('loanTab')">تعریف تسهیلات</button>
 <button id="paymentTabBtn" class="px-6 py-2 rounded-t-lg bg-gray-200" onclick="showTab('paymentTab')">ثبت پرداخت</button>
 <button id="reportTabBtn" class="px-6 py-2 rounded-t-lg bg-gray-200" onclick="showTab('reportTab')">گزارش مغایرت</button>
 </div>
<!-- Loan Definition Tab -->
 <div id="loanTab" class="bg-white p-6 rounded-lg shadow-md">
 <h2 class="text-xl font-semibold mb-4 text-blue-600">فرم تعریف تسهیلات بانکی</h2>
<form id="loanForm" class="grid grid-cols-1 md:grid-cols-2 gap-6">
 <div>
 <label for="loanNumber" class="block mb-2 font-medium">شماره تسهیلات</label>
 <input type="text" id="loanNumber" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 </div>
<div>
 <label for="bankName" class="block mb-2 font-medium">نام بانک</label>
 <div class="flex">
 <select id="bankName" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 <option value="">انتخاب کنید</option>
 <option value="بانک ملی">بانک ملی</option>
 <option value="بانک صادرات">بانک صادرات</option>
 <option value="بانک ملت">بانک ملت</option>
 <option value="بانک تجارت">بانک تجارت</option>
 <option value="بانک رفاه">بانک رفاه</option>
 <option value="بانک سپه">بانک سپه</option>
 <option value="بانک کشاورزی">بانک کشاورزی</option>
 <option value="بانک پارسیان">بانک پارسیان</option>
 </select>
 <button type="button" onclick="showAddBankModal()" class="mr-2 px-3 bg-blue-100 text-blue-600 rounded hover:bg-blue-200">
 +
 </button>
 </div>
 </div>
<!-- Add Bank Modal -->
 <div id="addBankModal" class="hidden fixed inset-0 bg-black bg-opacity-50 flex items-center justify-center z-50">
 <div class="bg-white p-6 rounded-lg shadow-lg w-96">
 <h3 class="text-xl font-semibold mb-4">افزودن بانک جدید</h3>
 <input type="text" id="newBankName" class="w-full p-2 border rounded mb-4" placeholder="نام بانک">
 <div class="flex justify-end">
 <button onclick="hideAddBankModal()" class="px-4 py-2 bg-gray-200 rounded mr-2">انصراف</button>
 <button onclick="addNewBank()" class="px-4 py-2 bg-blue-600 text-white rounded">ذخیره</button>
 </div>
 </div>
 </div>
<div>
 <label for="loanType" class="block mb-2 font-medium">نوع تسهیلات</label>
 <select id="loanType" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 <option value="">انتخاب کنید</option>
 <option value="مسکن">مسکن</option>
 <option value="خودرو">خودرو</option>
 <option value="ماده‌ی ۹۱">ماده‌ی ۹۱</option>
 <option value="قرض‌الحسنه">قرض‌الحسنه</option>
 <option value="تجاری">تجاری</option>
 </select>
 </div>
<div>
 <label for="loanAmount" class="block mb-2 font-medium">مبلغ تسهیلات (ریال)</label>
 <input type="text" id="loanAmount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 persian-number" required>
 </div>
<div>
 <label for="installmentCount" class="block mb-2 font-medium">تعداد اقساط</label>
 <input type="number" id="installmentCount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 </div>
<div>
 <label for="loanDate" class="block mb-2 font-medium">تاریخ اخذ تسهیلات</label>
 <input type="text" id="loanDate" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 datepicker" required>
 </div>
<div>
 <label for="installmentAmount" class="block mb-2 font-medium">مبلغ هر قسط (ریال)</label>
 <input type="text" id="installmentAmount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 persian-number" required>
 </div>
<div>
 <label for="interestRate" class="block mb-2 font-medium">درصد سود (%)</label>
 <input type="number" step="0.01" id="interestRate" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 </div>
<div>
 <label for="penaltyRate" class="block mb-2 font-medium">درصد جریمه (%)</label>
 <input type="number" step="0.01" id="penaltyRate" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 </div>
<div class="md:col-span-2 flex flex-wrap gap-2">
 <button type="submit" class="w-full md:w-auto bg-blue-600 text-white px-6 py-2 rounded hover:bg-blue-700 transition">ذخیره تسهیلات</button>
 <button type="button" onclick="generateInstallments()" class="w-full md:w-auto bg-green-600 text-white px-6 py-2 rounded hover:bg-green-700 transition">تولید اقساط</button>
 <button type="button" onclick="clearLoanForm()" class="w-full md:w-auto bg-gray-600 text-white px-6 py-2 rounded hover:bg-gray-700 transition">افزودن جدید</button>
 </div>
 </form>
<div id="installmentsSection" class="mt-8 hidden">
 <h3 class="text-lg font-semibold mb-4 text-blue-600">جدول اقساط</h3>
 <div class="table-container">
 <table id="installmentsTable" class="min-w-full bg-white border">
 <thead>
 <tr class="bg-gray-200">
 <th class="py-2 px-4 border">ردیف</th>
 <th class="py-2 px-4 border">تاریخ سررسید</th>
 <th class="py-2 px-4 border">مبلغ قسط</th>
 <th class="py-2 px-4 border">سود</th>
 <th class="py-2 px-4 border">جریمه</th>
 <th class="py-2 px-4 border">اصل تسهیلات</th>
 </tr>
 </thead>
 <tbody id="installmentsBody">
 <!-- Installments will be added here -->
 </tbody>
 </table>
 </div>
 <div class="mt-4">
 <button id="saveInstallmentsBtn" class="bg-blue-600 text-white px-6 py-2 rounded hover:bg-blue-700 transition hidden">ذخیره اقساط</button>
 </div>
 </div>
<!-- Loans List Table -->
 <div class="mt-8">
 <h3 class="text-lg font-semibold mb-4 text-blue-600">لیست تسهیلات تعریف شده</h3>
 <div class="table-container">
 <table id="loansTable" class="min-w-full bg-white border">
 <thead>
 <tr class="bg-gray-200">
 <th class="py-2 px-4 border">ردیف</th>
 <th class="py-2 px-4 border">شماره تسهیلات</th>
 <th class="py-2 px-4 border">بانک</th>
 <th class="py-2 px-4 border">نوع تسهیلات</th>
 <th class="py-2 px-4 border">مبلغ</th>
 <th class="py-2 px-4 border">اقدامات</th>
 </tr>
 </thead>
 <tbody id="loansBody">
 <!-- Loans will be added here -->
 </tbody>
 </table>
 </div>
 </div>
 </div>
<!-- Payment Registration Tab -->
 <div id="paymentTab" class="hidden bg-white p-6 rounded-lg shadow-md">
 <h2 class="text-xl font-semibold mb-4 text-blue-600">فرم ثبت پرداخت</h2>
<form id="paymentForm" class="grid grid-cols-1 md:grid-cols-2 gap-6">
 <div>
 <label for="paymentLoanNumber" class="block mb-2 font-medium">شماره تسهیلات</label>
 <select id="paymentLoanNumber" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" required>
 <option value="">انتخاب کنید</option>
 <!-- Loans will be populated here -->
 </select>
 </div>
<div>
 <label for="paymentBankName" class="block mb-2 font-medium">نام بانک</label>
 <input type="text" id="paymentBankName" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500" readonly>
 </div>
<div>
 <label for="paymentDate" class="block mb-2 font-medium">تاریخ پرداخت</label>
 <input type="text" id="paymentDate" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 datepicker" required>
 </div>
<div>
 <label for="paymentAmount" class="block mb-2 font-medium">مبلغ پرداخت (ریال)</label>
 <input type="text" id="paymentAmount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 persian-number" required>
 </div>
<div class="md:col-span-2">
 <h3 class="text-lg font-semibold mb-2 text-blue-600">توزیع مبلغ پرداختی</h3>
 <div class="grid grid-cols-1 md:grid-cols-3 gap-4">
 <div>
 <label for="principalAmount" class="block mb-2 font-medium">اصل تسهیلات (ریال)</label>
 <input type="text" id="principalAmount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 persian-number" required>
 </div>
 <div>
 <label for="interestAmount" class="block mb-2 font-medium">سود تسهیلات (ریال)</label>
 <input type="text" id="interestAmount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 persian-number" required>
 </div>
 <div>
 <label for="penaltyAmount" class="block mb-2 font-medium">جریمه (ریال)</label>
 <input type="text" id="penaltyAmount" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500 persian-number">
 </div>
 </div>
 </div>
<div class="md:col-span-2">
 <button type="submit" class="w-full md:w-auto bg-blue-600 text-white px-6 py-2 rounded hover:bg-blue-700 transition">ثبت پرداخت</button>
 </div>
 </form>
<div class="mt-8">
 <h3 class="text-lg font-semibold mb-4 text-blue-600">پرداخت‌های ثبت شده</h3>
 <div class="table-container">
 <table id="paymentsTable" class="min-w-full bg-white border">
 <thead>
 <tr class="bg-gray-200">
 <th class="py-2 px-4 border">ردیف</th>
 <th class="py-2 px-4 border">شماره تسهیلات</th>
 <th class="py-2 px-4 border">بانک</th>
 <th class="py-2 px-4 border">تاریخ پرداخت</th>
 <th class="py-2 px-4 border">مبلغ پرداخت</th>
 <th class="py-2 px-4 border">اصل</th>
 <th class="py-2 px-4 border">سود</th>
 <th class="py-2 px-4 border">جریمه</th>
 <th class="py-2 px-4 border">اقدامات</th>
 </tr>
 </thead>
 <tbody id="paymentsBody">
 <!-- Payments will be added here -->
 </tbody>
 </table>
 </div>
 </div>
 </div>
<!-- Discrepancy Report Tab -->
 <div id="reportTab" class="hidden bg-white p-6 rounded-lg shadow-md">
 <h2 class="text-xl font-semibold mb-4 text-blue-600">گزارش مغایرت بانکی</h2>
<form id="reportForm" class="mb-6">
 <div class="grid grid-cols-1 md:grid-cols-3 gap-6">
 <div>
 <label for="reportLoanNumber" class="block mb-2 font-medium">شماره تسهیلات</label>
 <select id="reportLoanNumber" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500">
 <option value="">همه تسهیلات</option>
 <!-- Loans will be populated here -->
 </select>
 </div>
<div>
 <label for="reportBankName" class="block mb-2 font-medium">بانک</label>
 <select id="reportBankName" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500">
 <option value="">همه بانک‌ها</option>
 <option value="بانک ملی">بانک ملی</option>
 <option value="بانک صادرات">بانک صادرات</option>
 <option value="بانک ملت">بانک ملت</option>
 <option value="بانک تجارت">بانک تجارت</option>
 <option value="بانک رفاه">بانک رفاه</option>
 <option value="بانک سپه">بانک سپه</option>
 <option value="بانک کشاورزی">بانک کشاورزی</option>
 <option value="بانک پارسیان">بانک پارسیان</option>
 </select>
 </div>
<div>
 <label for="reportMethod" class="block mb-2 font-medium">روش محاسباتی</label>
 <select id="reportMethod" class="w-full p-2 border rounded focus:ring-2 focus:ring-blue-500">
 <option value="equal">تقسیم مساوی (اصل/سود/جریمه)</option>
 <option value="interestFirst">پرداخت سود و جریمه قبل از اصل</option>
 </select>
 </div>
 </div>
<div class="mt-4">
 <button type="button" onclick="generateReport()" class="w-full md:w-auto bg-blue-600 text-white px-6 py-2 rounded hover:bg-blue-700 transition">تهیه گزارش</button>
 </div>
 </form>
<div id="reportResult" class="hidden">
 <h3 class="text-lg font-semibold mb-4 text-blue-600">نتایج گزارش مغایرت</h3>
 <div class="mb-4 p-4 bg-blue-50 rounded">
 <p id="summaryText"></p>
 </div>
<div class="table-container">
 <table id="discrepancyTable" class="min-w-full bg-white border">
 <thead>
 <tr class="bg-gray-200">
 <th class="py-2 px-4 border">ردیف</th>
 <th class="py-2 px-4 border">شماره تسهیلات</th>
 <th class="py-2 px-4 border">بانک</th>
 <th class="py-2 px-4 border">تاریخ پرداخت</th>
 <th class="py-2 px-4 border">مبلغ ثبت شده</th>
 <th class="py-2 px-4 border">مبلغ محاسبه شده</th>
 <th class="py-2 px-4 border">اختلاف</th>
 <th class="py-2 px-4 border">نوع اختلاف</th>
 </tr>
 </thead>
 <tbody id="discrepancyBody">
 <!-- Report results will be added here -->
 </tbody>
 </table>
 </div>
 </div>
 </div>
 </div>
<script>
 // Persian date picker initialization
 $(document).ready(function() {
 $(".datepicker").pDatepicker({
 observer: true,
 format: 'YYYY/MM/DD',
 initialValue: false
 });
// Format Persian numbers
 $('.persian-number').on('input', function() {
 this.value = persianJs(this.value).englishNumber().toString();
 });
 });
 // Data storage
 let loans = [];
 let payments = [];
// Switch between tabs
 function showTab(tabId) {
 document.getElementById('loanTab').classList.add('hidden');
 document.getElementById('paymentTab').classList.add('hidden');
 document.getElementById('reportTab').classList.add('hidden');
document.getElementById('loanTabBtn').classList.remove('active-tab');
 document.getElementById('paymentTabBtn').classList.remove('active-tab');
 document.getElementById('reportTabBtn').classList.remove('active-tab');
document.getElementById(tabId).classList.remove('hidden');
 document.getElementById(tabId + 'Btn').classList.add('active-tab');
if (tabId === 'paymentTab') {
 populateLoanNumbers('paymentLoanNumber');
 document.getElementById('paymentBankName').value = '';
 } else if (tabId === 'reportTab') {
 populateLoanNumbers('reportLoanNumber');
 }
 }
// Populate loan numbers in dropdowns
 function populateLoanNumbers(elementId) {
 const selectElement = document.getElementById(elementId);
// Save the current selected value
 const currentValue = selectElement.value;
// Clear existing options except the first one
 while (selectElement.options.length > 1) {
 selectElement.remove(1);
 }
// Add loan numbers from the loans array
 loans.forEach(loan => {
 const option = document.createElement('option');
 option.value = loan.loanNumber;
 option.textContent = loan.loanNumber;
 selectElement.appendChild(option);
 });
// Restore the previous selection if it still exists
 if (currentValue && Array.from(selectElement.options).some(o => o.value === currentValue)) {
 selectElement.value = currentValue;
 }
 }
// Clear loan form
 function clearLoanForm() {
 document.getElementById('loanForm').reset();
 document.getElementById('installmentsSection').classList.add('hidden');
 document.getElementById('saveInstallmentsBtn').classList.add('hidden');
 document.getElementById('installmentsBody').innerHTML = '';
 }
 // Handle loan form submission
 document.getElementById('loanForm').addEventListener('submit', function(e) {
 e.preventDefault();
const loan = {
 loanNumber: document.getElementById('loanNumber').value,
 bankName: document.getElementById('bankName').value,
 loanType: document.getElementById('loanType').value,
 loanDate: document.getElementById('loanDate').value,
 loanAmount: parseFloat(document.getElementById('loanAmount').value.replace(/,/g, '')) || 0,
 installmentCount: parseInt(document.getElementById('installmentCount').value),
 installmentAmount: parseFloat(document.getElementById('installmentAmount').value.replace(/,/g, '')),
 interestRate: parseFloat(document.getElementById('interestRate').value),
 penaltyRate: parseFloat(document.getElementById('penaltyRate').value),
 installments: [],
 createdAt: new Date().toISOString()
 };
// Validate required fields
 if (!loan.loanNumber || !loan.bankName || !loan.loanType || !loan.loanDate ||
isNaN(loan.loanAmount) || isNaN(loan.installmentCount) || isNaN(loan.installmentAmount) ||
isNaN(loan.interestRate) || isNaN(loan.penaltyRate)) {
 alert('لطفاً همه فیلدهای فرم را به درستی پر کنید.');
 return;
 }
// Check if this loan number already exists
 const existingIndex = loans.findIndex(l => l.loanNumber === loan.loanNumber);
 if (existingIndex !== -1) {
 loans[existingIndex] = loan; // Update existing loan
 alert('تسهیلات با این شماره قبلاً ثبت شده و اطلاعات آن به‌روزرسانی شد.');
 } else {
 loans.push(loan); // Add new loan
 alert('تسهیلات جدید با موفقیت ثبت شد.');
 }
refreshLoansTable();
 });
// Format loan amount input
 function formatLoanAmount(input) {
 let value = input.value.replace(/,/g, '');
 if (!value) return;
value = parseInt(value);
 if (isNaN(value)) value = 0;
input.value = value.toLocaleString('en-US');
 }
// Generate installments
 function generateInstallments() {
 const loanNumber = document.getElementById('loanNumber').value;
 const loanAmountInput = document.getElementById('loanAmount');
 const installmentCountInput = document.getElementById('installmentCount');
 const installmentAmountInput = document.getElementById('installmentAmount');
 const interestRateInput = document.getElementById('interestRate');
// Basic validation
 if (!loanNumber) {
 alert('لطفاً ابتدا تسهیلات را ذخیره کنید');
 return;
 }
// Validate required fields have values
 if (!loanNumber || !loanAmountInput.value || !installmentCountInput.value ||
!installmentAmountInput.value || !interestRateInput.value) {
 alert('لطفاً همه فیلدهای تسهیلات را تکمیل کنید.');
 return;
 }
 // Convert to numeric values
 const loanAmount = parseFloat(loanAmountInput.value.replace(/,/g, '')) || 0;
 const installmentCount = parseInt(installmentCountInput.value) || 0;
 const installmentAmount = parseFloat(installmentAmountInput.value.replace(/,/g, '')) || 0;
 const interestRate = parseFloat(interestRateInput.value) || 0;
 // Additional validation
 if (loanAmount <= 0 || installmentCount <= 0 || installmentAmount <= 0 || interestRate <= 0) {
 alert('مقادیر باید بزرگتر از صفر باشند.');
 return;
 }
const tbody = document.getElementById('installmentsBody');
 tbody.innerHTML = '';
const fixedPrincipal = loanAmount / installmentCount;
// Convert Persian numbers to English for calculations
 function toEnglishNumber(number) {
 return parseFloat(persianJs(number).englishNumber().toString().replace(/,/g, ''));
 }
for (let i = 0; i < installmentCount; i++) {
 const tr = document.createElement('tr');
 tr.className = 'hover:bg-gray-50';
// Row number
 const td1 = document.createElement('td');
 td1.className = 'py-2 px-4 border text-center';
 td1.textContent = i + 1;
// Due date (Persian date picker)
 const td2 = document.createElement('td');
 td2.className = 'py-2 px-4 border';
 const dateInput = document.createElement('input');
 dateInput.type = 'text';
 dateInput.className = 'w-full p-2 border rounded datepicker';
 dateInput.placeholder = 'انتخاب تاریخ';
 dateInput.required = true;
// Try to preserve existing date if available
 const loanNumber = document.getElementById('loanNumber').value;
 const loan = loans.find(l => l.loanNumber === loanNumber);
 if (loan && loan.installments && loan.installments[i]) {
 dateInput.value = loan.installments[i].dueDate;
 }
td2.appendChild(dateInput);
 $(dateInput).pDatepicker({
 observer: true,
 format: 'YYYY/MM/DD',
 initialValue: false
 });
// Installment amount (fixed)
 const td3 = document.createElement('td');
 td3.className = 'py-2 px-4 border text-left';
 td3.textContent = installmentAmount.toLocaleString('fa-IR');
// Interest amount
 const td4 = document.createElement('td');
 td4.className = 'py-2 px-4 border text-left';
 const remainingAmount = loanAmount - (fixedPrincipal * i);
 const interest = Math.round((remainingAmount * interestRate / 100) / 12);
 td4.textContent = interest.toLocaleString('fa-IR');
// Penalty amount
 const td5 = document.createElement('td');
 td5.className = 'py-2 px-4 border text-left';
 td5.textContent = '۰';
// Principal amount
 const td6 = document.createElement('td');
 td6.className = 'py-2 px-4 border text-left';
 td6.textContent = (installmentAmount - interest).toLocaleString('fa-IR');
tr.appendChild(td1);
 tr.appendChild(td2);
 tr.appendChild(td3);
 tr.appendChild(td4);
 tr.appendChild(td5);
 tr.appendChild(td6);
tbody.appendChild(tr);
 }
// Show save button if we have installments
 if (installmentCount > 0) {
 document.getElementById('saveInstallmentsBtn').classList.remove('hidden');
 } else {
 document.getElementById('saveInstallmentsBtn').classList.add('hidden');
 }
 }
// Bank management functions
 function showAddBankModal() {
 document.getElementById('addBankModal').classList.remove('hidden');
 }
 function hideAddBankModal() {
 document.getElementById('addBankModal').classList.add('hidden');
 document.getElementById('newBankName').value = '';
 }
 function addNewBank() {
 const bankName = document.getElementById('newBankName').value.trim();
 if (!bankName) {
 alert('لطفاً نام بانک را وارد کنید.');
 return;
 }
 const select = document.getElementById('bankName');
 const option = document.createElement('option');
 option.value = bankName;
 option.textContent = bankName;
 select.appendChild(option);
 select.value = bankName;
 hideAddBankModal();
 }
 // Load loans into the table
 function refreshLoansTable() {
 const tbody = document.getElementById('loansBody');
 tbody.innerHTML = '';
loans.forEach((loan, index) => {
 const tr = document.createElement('tr');
 tr.className = 'hover:bg-gray-50';
const td1 = document.createElement('td');
 td1.className = 'py-2 px-4 border text-center';
 td1.textContent = index + 1;
const td2 = document.createElement('td');
 td2.className = 'py-2 px-4 border text-center';
 td2.textContent = loan.loanNumber;
const td3 = document.createElement('td');
 td3.className = 'py-2 px-4 border';
 td3.textContent = loan.bankName;
const td4 = document.createElement('td');
 td4.className = 'py-2 px-4 border';
 td4.textContent = loan.loanType;
const td5 = document.createElement('td');
 td5.className = 'py-2 px-4 border text-left';
 td5.textContent = loan.loanAmount.toLocaleString('fa-IR');
const td6 = document.createElement('td');
 td6.className = 'py-2 px-4 border text-center';
const editBtn = document.createElement('button');
 editBtn.className = 'text-blue-600 hover:text-blue-800 ml-2';
 editBtn.innerHTML = 'ویرایش';
 editBtn.addEventListener('click', () => editLoan(index));
const deleteBtn = document.createElement('button');
 deleteBtn.className = 'text-red-600 hover:text-red-800';
 deleteBtn.innerHTML = 'حذف';
 deleteBtn.addEventListener('click', () => deleteLoan(index));
td6.appendChild(editBtn);
 td6.appendChild(deleteBtn);
tr.appendChild(td1);
 tr.appendChild(td2);
 tr.appendChild(td3);
 tr.appendChild(td4);
 tr.appendChild(td5);
 tr.appendChild(td6);
tbody.appendChild(tr);
 });
 }
 // Edit a loan
 function editLoan(index) {
 const loan = loans[index];
document.getElementById('loanNumber').value = loan.loanNumber;
 document.getElementById('bankName').value = loan.bankName;
 document.getElementById('loanType').value = loan.loanType;
 document.getElementById('loanAmount').value = loan.loanAmount.toLocaleString('en-US');
 document.getElementById('installmentCount').value = loan.installmentCount;
 document.getElementById('installmentAmount').value = loan.installmentAmount.toLocaleString('en-US');
 document.getElementById('loanDate').value = loan.loanDate;
 document.getElementById('interestRate').value = loan.interestRate;
 document.getElementById('penaltyRate').value = loan.penaltyRate;
// Show installments section if it has installments
 if (loan.installments && loan.installments.length > 0) {
 document.getElementById('installmentsSection').classList.remove('hidden');
 document.getElementById('saveInstallmentsBtn').classList.remove('hidden');
const tbody = document.getElementById('installmentsBody');
 tbody.innerHTML = '';
loan.installments.forEach((inst, idx) => {
 const tr = document.createElement('tr');
 tr.className = 'hover:bg-gray-50';
// Row number
 const td1 = document.createElement('td');
 td1.className = 'py-2 px-4 border text-center';
 td1.textContent = idx + 1;
// Due date
 const td2 = document.createElement('td');
 td2.className = 'py-2 px-4 border';
 const dateInput = document.createElement('input');
 dateInput.type = 'text';
 dateInput.className = 'w-full p-2 border rounded datepicker';
 dateInput.value = inst.dueDate;
 dateInput.required = true;
 td2.appendChild(dateInput);
 $(dateInput).pDatepicker({
 observer: true,
 format: 'YYYY/MM/DD',
 initialValue: false
 });
// Installment amount
 const td3 = document.createElement('td');
 td3.className = 'py-2 px-4 border text-left';
 td3.textContent = inst.amount.toLocaleString('fa-IR');
// Interest amount
 const td4 = document.createElement('td');
 td4.className = 'py-2 px-4 border text-left';
 td4.textContent = inst.interest.toLocaleString('fa-IR');
// Penalty amount
 const td5 = document.createElement('td');
 td5.className = 'py-2 px-4 border text-left';
 td5.textContent = inst.penalty.toLocaleString('fa-IR');
// Principal amount
 const td6 = document.createElement('td');
 td6.className = 'py-2 px-4 border text-left';
 td6.textContent = inst.principal.toLocaleString('fa-IR');
tr.appendChild(td1);
 tr.appendChild(td2);
 tr.appendChild(td3);
 tr.appendChild(td4);
 tr.appendChild(td5);
 tr.appendChild(td6);
tbody.appendChild(tr);
 });
 }
// Scroll to form
 document.getElementById('loanTab').scrollIntoView({behavior: 'smooth'});
 }
 // Delete a loan
 function deleteLoan(index) {
 if (confirm('آیا از حذف این تسهیلات مطمئن هستید؟')) {
 loans.splice(index, 1);
 refreshLoansTable();
// Also refresh payment and report dropdowns if open
 if (!document.getElementById('paymentTab').classList.contains('hidden')) {
 populateLoanNumbers('paymentLoanNumber');
 }
 if (!document.getElementById('reportTab').classList.contains('hidden')) {
 populateLoanNumbers('reportLoanNumber');
 }
alert('تسهیلات با موفقیت حذف شد.');
 }
 }
 // Save installments
 document.getElementById('saveInstallmentsBtn').addEventListener('click', function() {
 const loanNumber = document.getElementById('loanNumber').value;
 const loanIndex = loans.findIndex(l => l.loanNumber === loanNumber);
if (loanIndex === -1) {
 alert('تسهیلات یافت نشد.');
 return;
 }
const rows = document.getElementById('installmentsBody').rows;
 const installments = [];
for (let i = 0; i < rows.length; i++) {
 const cells = rows[i].cells;
const installment = {
 number: i + 1,
 dueDate: cells[1].querySelector('input').value,
 amount: parseFloat(document.getElementById('installmentAmount').value.replace(/,/g, '')),
 interest: parseFloat(persianJs(cells[3].textContent).englishNumber().toString().replace(/,/g, '')),
 penalty: parseFloat(persianJs(cells[4].textContent).englishNumber().toString().replace(/,/g, '')),
 principal: parseFloat(persianJs(cells[5].textContent).englishNumber().toString().replace(/,/g, ''))
 };
installments.push(installment);
 }
loans[loanIndex].installments = installments;
 alert('اقساط با موفقیت ذخیره شدند.');
 });
// Update bank name when loan number is selected in payment form
 document.getElementById('paymentLoanNumber').addEventListener('change', function() {
 const loanNumber = this.value;
 if (!loanNumber) {
 document.getElementById('paymentBankName').value = '';
 return;
 }
const loan = loans.find(l => l.loanNumber === loanNumber);
 if (loan) {
 document.getElementById('paymentBankName').value = loan.bankName;
 }
 });
// Handle payment form submission
 document.getElementById('paymentForm').addEventListener('submit', function(e) {
 e.preventDefault();
const payment = {
 loanNumber: document.getElementById('paymentLoanNumber').value,
 bankName: document.getElementById('paymentBankName').value,
 paymentDate: document.getElementById('paymentDate').value,
 paymentAmount: parseFloat(document.getElementById('paymentAmount').value.replace(/,/g, '')),
 principalAmount: parseFloat(document.getElementById('principalAmount').value.replace(/,/g, '')),
 interestAmount: parseFloat(document.getElementById('interestAmount').value.replace(/,/g, '')),
 penaltyAmount: parseFloat((document.getElementById('penaltyAmount').value || '').replace(/,/g, '')) || 0,
 createdAt: new Date().toISOString()
 };
// Make generateInstallments button work
 document.querySelector('button[onclick="generateInstallments()"]').addEventListener('click', function(e) {
 e.preventDefault();
 generateInstallments();
 document.getElementById('installmentsSection').classList.remove('hidden');
 });
 // Validate payment
 const calculatedTotal = payment.principalAmount + payment.interestAmount + payment.penaltyAmount;
 if (Math.abs(calculatedTotal - payment.paymentAmount) > 1) {
 alert(`جمع مبالغ جزء (${calculatedTotal.toLocaleString('fa-IR')}) با مبلغ کل پرداختی (${payment.paymentAmount.toLocaleString('fa-IR')}) مغایرت دارد.`);
 return;
 }
payments.push(payment);
 addPaymentToTable(payment);
// Clear the form (except for loan number)
 document.getElementById('paymentDate').value = '';
 document.getElementById('paymentAmount').value = '';
 document.getElementById('principalAmount').value = '';
 document.getElementById('interestAmount').value = '';
 document.getElementById('penaltyAmount').value = '';
alert('پرداخت با موفقیت ثبت شد.');
 });
// Add payment to payments table
 function addPaymentToTable(payment) {
 const tbody = document.getElementById('paymentsBody');
 const tr = document.createElement('tr');
 tr.className = 'hover:bg-gray-50';
 tr.dataset.paymentId = payments.length - 1;
const td1 = document.createElement('td');
 td1.className = 'py-2 px-4 border text-center';
 td1.textContent = payments.length;
const td2 = document.createElement('td');
 td2.className = 'py-2 px-4 border text-center';
 td2.textContent = payment.loanNumber;
const td3 = document.createElement('td');
 td3.className = 'py-2 px-4 border';
 td3.textContent = payment.bankName;
const td4 = document.createElement('td');
 td4.className = 'py-2 px-4 border text-center';
 td4.textContent = payment.paymentDate;
const td5 = document.createElement('td');
 td5.className = 'py-2 px-4 border text-left';
 td5.textContent = payment.paymentAmount.toLocaleString('fa-IR');
const td6 = document.createElement('td');
 td6.className = 'py-2 px-4 border text-left';
 td6.textContent = payment.principalAmount.toLocaleString('fa-IR');
const td7 = document.createElement('td');
 td7.className = 'py-2 px-4 border text-left';
 td7.textContent = payment.interestAmount.toLocaleString('fa-IR');
const td8 = document.createElement('td');
 td8.className = 'py-2 px-4 border text-left';
 td8.textContent = payment.penaltyAmount.toLocaleString('fa-IR');
const td9 = document.createElement('td');
 td9.className = 'py-2 px-4 border text-center';
 const deleteBtn = document.createElement('button');
 deleteBtn.className = 'text-red-600 hover:text-red-800';
 deleteBtn.innerHTML = 'حذف';
 deleteBtn.addEventListener('click', function() {
 deletePayment(this.closest('tr').dataset.paymentId);
 });
 td9.appendChild(deleteBtn);
tr.appendChild(td1);
 tr.appendChild(td2);
 tr.appendChild(td3);
 tr.appendChild(td4);
 tr.appendChild(td5);
 tr.appendChild(td6);
 tr.appendChild(td7);
 tr.appendChild(td8);
 tr.appendChild(td9);
tbody.appendChild(tr);
 }
// Delete a payment
 function deletePayment(paymentId) {
 if (confirm('آیا از حذف این پرداخت مطمئن هستید؟')) {
 payments.splice(paymentId, 1);
 refreshPaymentsTable();
// Reindex payments
 payments = payments.map((payment, index) => {
 return {...payment, id: index};
 });
 }
 }
// Refresh payments table
 function refreshPaymentsTable() {
 const tbody = document.getElementById('paymentsBody');
 tbody.innerHTML = '';
payments.forEach((payment, index) => {
 payment.id = index; // Update payment ID
 addPaymentToTable(payment);
 });
 }
// Generate discrepancy report
 function generateReport() {
 const loanNumberFilter = document.getElementById('reportLoanNumber').value;
 const bankNameFilter = document.getElementById('reportBankName').value;
 const method = document.getElementById('reportMethod').value;
// Filter payments
 let filteredPayments = [...payments];
if (loanNumberFilter) {
 filteredPayments = filteredPayments.filter(p => p.loanNumber === loanNumberFilter);
 }
if (bankNameFilter) {
 filteredPayments = filteredPayments.filter(p => p.bankName === bankNameFilter);
 }
if (filteredPayments.length === 0) {
 alert('با فیلترهای انتخاب شده پرداختی یافت نشد.');
 return;
 }
// Process each payment based on the selected method
 const discrepancies = [];
filteredPayments.forEach(payment => {
 const loan = loans.find(l => l.loanNumber === payment.loanNumber);
 if (!loan) return;
if (method === 'equal') {
 // Equal distribution method
 const calculatedPrincipal = Math.round(payment.paymentAmount / 3);
 const calculatedInterest = Math.round(payment.paymentAmount / 3);
 const calculatedPenalty = Math.round(payment.paymentAmount / 3);
// Calculate differences
 const principalDiff = payment.principalAmount - calculatedPrincipal;
 const interestDiff = payment.interestAmount - calculatedInterest;
 const penaltyDiff = payment.penaltyAmount - calculatedPenalty;
if (principalDiff !== 0 || interestDiff !== 0 || penaltyDiff !== 0) {
 discrepancies.push({
 loanNumber: payment.loanNumber,
 bankName: payment.bankName,
 paymentDate: payment.paymentDate,
 recordedAmount: `${payment.principalAmount.toLocaleString('fa-IR')} + ${payment.interestAmount.toLocaleString('fa-IR')} + ${payment.penaltyAmount.toLocaleString('fa-IR')}`,
 calculatedAmount: `${calculatedPrincipal.toLocaleString('fa-IR')} + ${calculatedInterest.toLocaleString('fa-IR')} + ${calculatedPenalty.toLocaleString('fa-IR')}`,
 difference: (principalDiff + interestDiff + penaltyDiff).toLocaleString('fa-IR'),
 type: 'تقسیم مساوی'
 });
 }
 } else if (method === 'interestFirst') {
 // Interest and penalty first method
// 1. Apply to penalty
 const remainingAfterPenalty = Math.max(0, payment.paymentAmount - payment.penaltyAmount);
// 2. Apply to interest
 const remainingAfterInterest = Math.max(0, remainingAfterPenalty - payment.interestAmount);
// 3. Remainder goes to principal
 const calculatedPrincipal = remainingAfterInterest;
 const calculatedInterest = payment.interestAmount;
 const calculatedPenalty = payment.penaltyAmount;
// Calculate differences
 const principalDiff = payment.principalAmount - calculatedPrincipal;
 const interestDiff = 0; // No difference in interest as we use the exact amount
 const penaltyDiff = 0; // No difference in penalty as we use the exact amount
if (principalDiff !== 0 || interestDiff !== 0 || penaltyDiff !== 0) {
 discrepancies.push({
 loanNumber: payment.loanNumber,
 bankName: payment.bankName,
 paymentDate: payment.paymentDate,
 recordedAmount: `${payment.principalAmount.toLocaleString('fa-IR')} + ${payment.interestAmount.toLocaleString('fa-IR')} + ${payment.penaltyAmount.toLocaleString('fa-IR')}`,
 calculatedAmount: `${calculatedPrincipal.toLocaleString('fa-IR')} + ${calculatedInterest.toLocaleString('fa-IR')} + ${calculatedPenalty.toLocaleString('fa-IR')}`,
 difference: (principalDiff + interestDiff + penaltyDiff).toLocaleString('fa-IR'),
 type: 'سود و جریمه قبل از اصل'
 });
 }
 }
 });
// Display results
 if (discrepancies.length === 0) {
 document.getElementById('summaryText').textContent = `هیچ مغایرتی با روش "${method === 'equal' ? 'تقسیم مساوی' : 'سود و جریمه قبل از اصل'}" یافت نشد.`;
 document.getElementById('discrepancyBody').innerHTML = '';
 } else {
 document.getElementById('summaryText').textContent = `${discrepancies.length} مغایرت با روش "${method === 'equal' ? 'تقسیم مساوی' : 'سود و جریمه قبل از اصل'}" یافت شد.`;
const tbody = document.getElementById('discrepancyBody');
 tbody.innerHTML = '';
discrepancies.forEach((item, index) => {
 const tr = document.createElement('tr');
 tr.className = 'hover:bg-gray-50';
const td1 = document.createElement('td');
 td1.className = 'py-2 px-4 border text-center';
 td1.textContent = index + 1;
const td2 = document.createElement('td');
 td2.className = 'py-2 px-4 border text-center';
 td2.textContent = item.loanNumber;
const td3 = document.createElement('td');
 td3.className = 'py-2 px-4 border';
 td3.textContent = item.bankName;
const td4 = document.createElement('td');
 td4.className = 'py-2 px-4 border text-center';
 td4.textContent = item.paymentDate;
const td5 = document.createElement('td');
 td5.className = 'py-2 px-4 border text-left';
 td5.textContent = item.recordedAmount;
const td6 = document.createElement('td');
 td6.className = 'py-2 px-4 border text-left';
 td6.textContent = item.calculatedAmount;
const td7 = document.createElement('td');
 td7.className = 'py-2 px-4 border text-left';
 td7.textContent = item.difference;
const td8 = document.createElement('td');
 td8.className = 'py-2 px-4 border';
 td8.textContent = item.type;
tr.appendChild(td1);
 tr.appendChild(td2);
 tr.appendChild(td3);
 tr.appendChild(td4);
 tr.appendChild(td5);
 tr.appendChild(td6);
 tr.appendChild(td7);
 tr.appendChild(td8);
tbody.appendChild(tr);
 });
 }
document.getElementById('reportResult').classList.remove('hidden');
 }
 </script>
<p style="border-radius: 8px; text-align: center; font-size: 12px; color: #fff; margin-top: 16px;position: fixed; left: 8px; bottom: 8px; z-index: 10; background: rgba(0, 0, 0, 0.8); padding: 4px 8px;">Made with <img src="https://enzostvs-deepsite.hf.space/logo.svg" alt="DeepSite Logo" style="width: 16px; height: 16px; vertical-align: middle;display:inline-block;margin-right:3px;filter:brightness(0) invert(1);"><a href="https://enzostvs-deepsite.hf.space" style="color: #fff;text-decoration: underline;" target="_blank" >DeepSite</a> - 🧬 <a href="https://enzostvs-deepsite.hf.space?remix=Amiali6262/https-huggingface-co-amiali62623" style="color: #fff;text-decoration: underline;" target="_blank" >Remix</a></p></body>
</html>