<?php
echo "<h2>Planning Conditions</h2>";
ProjectSwitcher("project_planningcondition_list", $proj_id);
$sql_proj = "SELECT proj_id, proj_num, proj_name FROM intranet_projects WHERE proj_id = {$proj_id} LIMIT 1";
$result_proj = mysql_query($sql_proj, $conn) or die(mysql_error());
$array_proj = mysql_fetch_array($result_proj);
$proj_id = $array_proj['proj_id'];
$proj_num = $array_proj['proj_num'];
$proj_name = $array_proj['proj_name'];
if (intval($_GET[showdetail]) > 0) {
$showdetail = intval($_GET[showdetail]);
}
$sql_conditions = "SELECT * FROM intranet_projects_planning LEFT JOIN contacts_companylist ON company_id = condition_responsibility WHERE condition_project = {$proj_id} ORDER BY condition_ref, condition_number";
$result_conditions = mysql_query($sql_conditions, $conn) or die(mysql_error());
echo "<p class=\"submenu_bar\">";
if ($_GET[showdetail] == NULL && mysql_num_rows($result_conditions) > 0) {
echo "<a href=\"index2.php?page=project_planningcondition_list&proj_id={$proj_id}&showdetail=1\" class=\"submenu_bar\">Detailed List</a>";
}
echo "<a href=\"index2.php?page=project_planningcondition_edit&proj_id={$proj_id}\" class=\"submenu_bar\">Add Planning Condition <img src=\"images/button_new.png\" alt=\"Add Planning Condition\" /></a>";
echo "<a href=\"pdf_planning_conditions.php?proj_id={$proj_id}\" class=\"submenu_bar\">Printable PDF <img src=\"images/button_pdf.png\" alt=\"PDF version\" /></a>";
echo "</p>";
if (mysql_num_rows($result_conditions) > 0) {
echo "<table><tr><th colspan=\"2\">Condition Reference</th><th>Condition Number</th><th>Responsibility</th><th>Condition Type</th><th>Date of Decision</th><th>Date Submitted</th><th>Date Discharged</th></tr>";
while ($array_conditions = mysql_fetch_array($result_conditions)) {
unset($background);
if ($array_conditions['condition_type'] == "Informative Only") {
$condition_approved = "- n/a -";
} elseif ($array_conditions['condition_approved'] != "0000-00-00") {
$condition_approved = date("j M Y", AssessDays($array_conditions['condition_approved']));
$background = " style=\"background: rgba(255,0,0,0.5);\" ";
$sql_update = "UPDATE intranet_projects SET proj_riba = '{$fee_stage_current}' WHERE proj_id = '{$proj_id}' LIMIT 1";
$result_update = mysql_query($sql_update, $conn) or die(mysql_error());
}
// Item Sub Menu
echo "<p class=\"submenu_bar\">";
if ($user_usertype_current > 3 or $user_id_current == $proj_rep_black) {
echo "<a href=\"index2.php?page=project_edit&status=edit&proj_id={$proj_id}\" class=\"submenu_bar\">Edit</a>";
}
if ($user_usertype_current > 2) {
echo "<a href=\"index2.php?page=project_hourlyrates_view&proj_id={$proj_id}\" class=\"submenu_bar\">Hourly Rates</a>";
echo "<a href=\"index2.php?page=project_timesheet_view&proj_id={$proj_id}\" class=\"submenu_bar\">Expenditure</a>";
echo "<a href=\"index2.php?page=timesheet_fees_edit&proj_id={$proj_id}\" class=\"submenu_bar\">Add Fee Stage</a>";
}
echo "</p>";
echo "<h2>Fee Stages</h2>";
ProjectSwitcher("project_fees", $proj_id);
$sql = "SELECT * FROM intranet_timesheet_fees, intranet_projects WHERE ts_fee_project = '{$proj_id}' AND proj_id = ts_fee_project ORDER BY ts_fee_commence, ts_fee_text";
$result = mysql_query($sql, $conn) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
echo "<table summary=\"Lists the fees for the selected project\">";
echo "<form method=\"post\" action=\"index2.php?page=project_fees&proj_id={$proj_id}\">";
echo "<tr><th colspan=\"2\">Stage</th><th>Begin Date</th><th>End Date</th><th>Likelihood</th><th";
if ($user_usertype_current > 2) {
echo " colspan=\"3\"";
}
echo ">Fee for Stage</th></tr>";
$fee_total = 0;
$invoice_total = 0;
$counter = 0;
$prog_begin = $proj_date_commence;
$target_cost_total = 0;
$showhidden = $_GET[showhidden];
$sql_project = "SELECT proj_id, proj_num, proj_name FROM intranet_projects WHERE proj_id = {$proj_id}";
$result_project = mysql_query($sql_project, $conn) or die(mysql_error());
$array_project = mysql_fetch_array($result_project);
$proj_id = $array_project['proj_id'];
$proj_num = $array_project['proj_num'];
$proj_name = $array_project['proj_name'];
echo "<h2>Project Checklist</h2>";
echo "<p class=\"menu_bar\"><a href=\"pdf_project_checklist.php?proj_id={$proj_id}\" class=\"menu_tab\">PDF <img src=\"images/button_pdf.png\" /></a><a href=\"index2.php?page=project_checklist_edit&proj_id={$proj_id}\" class=\"menu_tab\">Edit <img src=\"images/button_edit.png\" /></a>";
if ($showhidden == "yes") {
echo "<a href=\"index2.php?page=project_checklist&showhidden=no&proj_id={$proj_id}\" class=\"menu_tab\">Hide Hidden Items</a>";
} else {
echo "<a href=\"index2.php?page=project_checklist&showhidden=yes&proj_id={$proj_id}\" class=\"menu_tab\">Show Hidden Items</a>";
}
echo "</p>";
ProjectSwitcher("project_checklist", $proj_id);
if ($_GET[display_order] == "stage") {
if ($showhidden != "yes") {
$sqlhidden = " AND checklist_required != 1 ";
} else {
unset($sqlhidden);
}
$sql_checklist = "SELECT * FROM intranet_project_checklist_items LEFT JOIN intranet_project_checklist ON checklist_item = item_id LEFT JOIN intranet_project_checklist_stages ON item_stage = stage_id AND checklist_project = {$proj_id} {$sqlhidden} ORDER BY stage_order, item_order, checklist_date";
$sql_checklist = "SELECT * FROM intranet_project_checklist_items LEFT JOIN intranet_project_checklist ON checklist_item = item_id LEFT JOIN intranet_project_checklist_stages ON item_stage = stage_id AND checklist_project = {$proj_id} {$sqlhidden} ORDER BY stage_order, item_order, checklist_date";
} else {
if ($showhidden != "yes") {
$sqlhidden = " WHERE checklist_required != 1 ";
} else {
unset($sqlhidden);
}
$sql_checklist = "SELECT * FROM intranet_project_checklist_items LEFT JOIN intranet_project_checklist ON checklist_item = item_id AND checklist_project = {$proj_id} {$sqlhidden} ORDER BY item_group, item_order, checklist_date, item_name";
