1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / mfms22 / mbcsl.mfmsbd.com /
Filename : loan_fine.php
back
<?php 

require 'functions.php';
require 'function_loans.php';
checkLogin();
$db_link = connect(); 
// getLoanID($db_link);

// $cust_id = sanitize($db_link, $_GET['cust_id']);

$timestamp = time();
$loan_id = $_SESSION['loan_id'];

// login user
$login_user = $_SESSION['log_user'];


/** CHARGE DEFAULT FINE Button **/
if(isset($_POST['fine'])){



    // Sanitize user input
    $fine_amount = sanitize($db_link, $_POST['fine_amount']);
    $fine_receipt = sanitize($db_link, $_POST['fine_receipt']);
    $fine_date = strtotime(sanitize($db_link, $_POST['fine_date']));
    $fix_ltrans_id = sanitize($db_link, $_POST['fix_ltrans_id']);

    
    if(isset($_POST['fine_sav'])) $fine_sav = sanitize($db_link, $_POST['fine_sav']);
    else $fine_sav = 0;


    // Get LTRANS_ID for chargable transaction
    $sql_ltrans = "SELECT MIN(ltrans_id) FROM ltrans WHERE ltrans.loan_id = '$_SESSION[loan_id]' AND ltrans_due < '$timestamp' AND ltrans_fined = '0' AND ltrans_date IS NULL";
    $query_ltrans = mysqli_query($db_link, $sql_ltrans);
    checkSQL($db_link, $query_ltrans);
    $ltrans = mysqli_fetch_row($query_ltrans);

    // Flag loan transaction as 'fined'
    // $sql_ltrans_fined = "UPDATE ltrans SET ltrans_fined = '1', ltrans_created = '$timestamp', user_id = '$_SESSION[log_id]' WHERE ltrans_id = '$ltrans[0]'";
    // $query_ltrans_fined = mysqli_query($db_link, $sql_ltrans_fined);
    // checkSQL($db_link, $query_ltrans_fined);


     // Flag loan transaction as 'fined'
     $sql_ltrans_fined = "UPDATE ltrans SET ltrans_fined = '1', ltrans_created = '$timestamp', user_id = '$_SESSION[log_id]' WHERE ltrans_id = '$fix_ltrans_id'";
     $query_ltrans_fined = mysqli_query($db_link, $sql_ltrans_fined);
     checkSQL($db_link, $query_ltrans_fined);

    
    // Deduct fine from savings account if applicable
    if($fine_sav == 1){
        $fine_amount_sav = $fine_amount * (-1);

        $sql_fine_sav = "INSERT INTO savings (cust_id, ltrans_id, sav_date, sav_amount, savtype_id, sav_receipt, sav_created, user_id) VALUES ('$_SESSION[cust_id]', '$fix_ltrans_id', '$fine_date', '$fine_amount_sav', 6, '$fine_receipt', $timestamp, '$_SESSION[log_id]')";
        $query_fine_sav = mysqli_query($db_link, $sql_fine_sav);
        checkSQL($db_link, $query_fine_sav);

        // Update savings account balance
        updateSavingsBalance($db_link, $_SESSION['cust_id']);

        // Get SAV_ID for the latest entry
        $sql_savid = "SELECT MAX(sav_id) FROM savings WHERE ltrans_id = '$fix_ltrans_id' AND sav_receipt = '$fine_receipt' AND sav_created = '$timestamp'";
        $query_savid = mysqli_query($db_link, $sql_savid);
        checkSQL($db_link, $query_savid);
        $sav_id = mysqli_fetch_row($query_savid);

         header('Location: loan.php?lid='.$_SESSION['loan_id']);

    }

     // Insert fine as income in INCOMES
     $sql_fine_inc = "INSERT INTO incomes (cust_id, ltrans_id, inctype_id, inc_amount, inc_date, inc_receipt, inc_created, user_id) VALUES ('$_SESSION[cust_id]', '$fix_ltrans_id', '5', '$fine_amount', '$fine_date', '$fine_receipt', $timestamp, '$_SESSION[log_id]')";
     $query_fine_inc = mysqli_query($db_link, $sql_fine_inc)or die('income add faild');
     // checkSQL($db_link, $query_fine_inc);
 
     header('Location: loan.php?lid='.$_SESSION['loan_id']);


}