* * */ session_start(); if (!$_SESSION['auth']) { header("Location: index.php"); } //ini_set('display_errors','On'); require '../config.php'; require '../includes/globalinc.php'; $idc_id = $_GET['id']; $_SESSION['idc_id'] = $idc_id; $name = $_SESSION['name']; $id = $_SESSION['id']; $current_page = $_SERVER["PHP_SELF"] . '?id=' . $idc_id; $startDate = f_getStartDate(); $endDate = f_getEndDate(); $query = "SELECT * FROM tbl_idc WHERE id = '{$idc_id}'"; $results = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_assoc($results)) { $contractor = $row['contractor']; $year = $row['year']; $quarter = $row['quarter']; $idc_type = $row['idc_type']; $scope = $row['scope_of_work']; $award = $row['award_Amount']; $sum = $row['sum_all_dos']; $contract = $row['contract_balance']; $totals = get_do_totals($idc_id); $current = $award - $totals; $total_reimbursed = $totals + get_do_reimbursements($idc_id);
function get_do_totals_previous($idc) { $start_date = f_getStartDate(); $query2 = "select * from tbl_dos where idc_id={$idc} and order_date < '{$start_date}'"; $results2 = mysql_query($query2) or die(mysql_error()); $counter = 0; while ($row2 = mysql_fetch_assoc($results2)) { $counter += $row2['basic']; } return $counter; }