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 Budget_total 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 >= 0 && $budget <= $budgetBalance){
echo "";
}
else{
echo "";
}
?>