Ticket kimberley - 22020222

base.php

function update_data($data) {
    global $g;
//update history table with record before updated in contracts by using OLD as value for ACTION field in HISTORY TABLE
    $str3 = "INSERT INTO history
             SELECT NULL, NOW(), 'old', '" . $_SESSION['username'] . "',
                                               d.* FROM contracts AS d
             WHERE d.contract_Id ={$data["contract_Id"]}";
    // mysql_query($str3);
    $g->execute_query($str3);


//field formating
    $data["params"]["contract_Worth"] = preg_replace("/[\$ ,]/", "", $data["params"]["contract_Worth"]);
    $data["params"]["contract_CurrentFYAmount"] = preg_replace("/[\$ ,]/", "", $data["params"]["contract_CurrentFYAmount"]);
    $data["params"]["contract_AmtExpendedToDate"] = preg_replace("/[\$ ,]/", "", $data["params"]["contract_AmtExpendedToDate"]);
    $data["params"]["contract_EntryBy"] = $_SESSION['username'];


//check duplicate encumbrances number
    $enum = "{$data["params"]["contract_EncumbranceNumber"]}";
    $check_sql = "SELECT COUNT(*) as c FROM contracts WHERE contract_EncumbranceNumber = '{$data["params"]["contract_EncumbranceNumber"]}' AND (`contract_EncumbranceNumber`) != '' AND contract_Id != {$data["contract_Id"]}";
    // $result = mysql_fetch_assoc(mysql_query($check_sql));
    $result = $g->get_one($check_sql);
    
    if ($result["c"] > 0) {
        phpgrid_error("Encumbrance#: " . $enum . " is currently being used!  <br>Please enter a <u>unique</u> Encumbrance#.");
    }
}