<?php

if (php_sapi_name() !== 'cli') {
    // exit();
}

$folders = explode(DIRECTORY_SEPARATOR, pathinfo(__FILE__, PATHINFO_DIRNAME));

array_pop($folders);
array_pop($folders);

include_once(implode(DIRECTORY_SEPARATOR, $folders) . '/Bin/init.php');
require_once(ROOT_FOLDER . 'Bin/Security.php');
include_once(implode(DIRECTORY_SEPARATOR, $folders) . '/Bin/constants.php');
require_once(ROOT_FOLDER . 'admin/classes/Model/MStatements.php');

$MStatements = new Model_MStatements();

$query = new Bin_Query();

$sql = /** @lang MySQL */ "SELECT 
    debtors_detail.debtor_id, 
    debtors_detail.`type` 
    FROM debtors_detail";
$query->executeQuery($sql);

$debtors = $query->records;

foreach ($debtors as $debtor) {

    $max_balance = ($debtor['type'] === TYPE_DEBTOR) ?
        $MStatements->getDebtorAIGDL($debtor['debtor_id']) :
        $MStatements->getCreditorAIGDL($debtor['debtor_id']);

    $sql = "UPDATE debtors_detail SET 
        debtors_detail.aig_dl = IF(aig_dl > " . $max_balance . ", aig_dl, " . $max_balance . ") 
        WHERE debtors_detail.debtor_id = " . (int)$debtor['debtor_id'] . " 
        AND debtors_detail.aig_dl_lock != 1";
    $query->updateQuery($sql);
}