<? 
    header( "content-type: application/x-javascript; charset=UTF-8" );
    
    require_once("../configuration.php");
    require_once("../includes/connMySQL.class.php");
    
    $budget = $_GET['budget'];
    $budgetOld = $_GET['budgetOld'];
    $projectID = $_GET['projectID'];
    
    /**  Create Database Object  */
    $conn = new DBConn;
    
        
    $sql = "SELECT * FROM project_type_tb WHERE ProjectId='$projectID'";     
    $result = $conn->execQuery($sql); 
    $data = $conn->fetchObject($result);
    $budgetPlan = $data->Budget_total;
    
    $sql = "SELECT SUM(Budget_use) AS Budget_use FROM project_tb WHERE ProjectId='$projectID'";
    $result = $conn->execQuery($sql);
    $data = $conn->fetchObject($result);
    
    $budgetUse = $data->Budget_use;

    $budgetUse = $budgetUse - $budgetOld;
    
    $budgetBalance = $budgetPlan - $budgetUse;
    
    if($budget > $budgetBalance){
        echo "&nbsp;<font size='2' color='red'><b>จำนวนเงินตามแผนคงเหลือไม่เพียงพอ<b></font>";
    }
?>