authebudget.php

<?php
session_name("Project");
session_start();
require_once('dbconn.php');
if(!checkUserSession($_SESSION["user"]))
{
	header("Location:login.php");
}
if(checkProjectPermission("APPROVE") == false)
{

        header("Location:error.php");
}

$budid=$_GET["bud_id"];

$coned=getConnection();
$sqled="
select a.id bud_id,ohrm_customer_id customer_id, b.id project_id,a.excess_budget,reason,a.docurl,a.status status,category,crvalue
from project_excess_budget a
inner join project_details b on a.project_id = b.id
where a.id = ".$budid ;
$resulted = mysqli_query($coned,$sqled) or debug($sqled."   failed  <br/><br/>".mysql_error());
$rowed = mysqli_fetch_array($resulted);

if($rowed[status] != "INITIATED")
        header("Location:error1.php");


?>
<html>
<head>

<script>

function formSubmit()
{
	var projType = 	document.forms["projectForm"]["projtype"];
	projType.style.background="white";

	var rptType = document.forms["projectForm"]["rpttype"];
        rptType.style.background="white";

	
	var cust = document.forms["projectForm"]["cust"];
	if(cust)
		cust.style.background="white";

	
	var project = document.forms["projectForm"]["proj"];
	if(project)
		project.style.background="white";

	var pm = document.forms["projectForm"]["pm"];
	pm.style.background="white";
	var pd = document.forms["projectForm"]["pd"];
	pd.style.background="white";
	
	var statusT = document.forms["projectForm"]["status"];
	statusT.style.background="white";
	var tlr = document.forms["projectForm"]["tlr"];
	tlr.style.background="white";
	
	var psdt = document.forms["projectForm"]["PlannedStartDate"];
	psdt.style.background="white";
	
	var pedt = document.forms["projectForm"]["PlannedEndDate"];
	pedt.style.background="white";
	var asdt = document.forms["projectForm"]["ActualStartDate"];
	asdt.style.background="white";
	
	var ardt = document.forms["projectForm"]["ActualEndDate"];
	ardt.style.background="white";
	
	var cval = document.forms["projectForm"]["ContractVal"];
	cval.style.background="white";
	var lval = document.forms["projectForm"]["LicenseVal"];
	lval.style.background="white";
	var bval = document.forms["projectForm"]["BudgetVal"];
	bval.style.background="white";
	var ebval = document.forms["projectForm"]["ExcessBudgetVal"];
	ebval.style.background="white";

	
	var obj = document.forms["projectForm"]["Objectives"];
	obj.style.background="white";
	var scope = document.forms["projectForm"]["Scope"];
	scope.style.background="white";
	var suc = document.forms["projectForm"]["Success"];
	suc.style.background="white";


	var ua = window.navigator.userAgent;
	var msie = ua.indexOf ( "MSIE " );
	if(msie > 0)
	{
		alert("Not Supported in IE. Please use chrome");
		return false;
	}
	
	var chk = projType;
	if(chk.value=="Choose..")
	{
		alert('Project Type not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}

        var chk = rptType;
        if(chk.value=="Choose..")
        {
                alert('Report Type not selected');
                chk.style.background="pink";
                chk.focus();
                return false;
        }


	var chk = cust;
	if(chk.value=="Choose..")
	{
		alert('Customer not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}

	var chk = project;
	if(chk.value=="Choose..")
	{
		alert('Project not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}
	
	var chk = pm;
	if(chk.value=="Choose..")
	{
		alert('Project Manager not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = pd;
	if(chk.value=="Choose..")
	{
		alert('Project Director not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}

	var chk = statusT;
	if(chk.value=="Choose..")
	{
		alert('Status not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = tlr;
	if(chk.value=="Choose..")
	{
		alert('Traffic Light not selected');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = psdt;
	if(chk.value=="")
	{
		alert('Planned Start Date not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = pedt;
	if(chk.value=="")
	{
		alert('Planned End Date not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}

	var chk = asdt;
	if(chk.value=="")
	{
		alert('Actual Start End Date not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = ardt;
	if(chk.value=="")
	{
		alert('Actual End Date not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}

	
	var chk = cval;
	if(chk.value=="" || isNaN(parseInt(chk.value)) )
	{
		alert('Contract Value not correctly entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = lval;
	if(chk.value=="" || isNaN(parseInt(chk.value)) )
	{
		alert('License Value not correctly entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = bval;
	if(chk.value=="" || isNaN(parseInt(chk.value)) || chk.value == 0)
	{
		alert('Budget not correctly entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}

	
	var chk = ebval;
	if(isNaN(parseInt(chk.value)) )
	{
		alert('Budget not correctly entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = obj;
	if(chk.value=="")
	{
		alert('Project Objectives not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = scope;
	if(chk.value=="")
	{
		alert('Project Scope not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}


	var chk = suc;
	if(chk.value=="")
	{
		alert('Success factor not entered');
		chk.style.background="pink";
		chk.focus();
                return false;
	}
	return true;
	
}

function showBudget(str)
{
//Not requrired for define. Required for others
if(str=='Choose..')
        return;
        document.getElementById('txtBudget').removeChild(document.getElementById('finance'));

if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
        document.getElementById('txtBudget').removeChild(document.getElementById('ajaxloader'));
        document.getElementById("txtBudget").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getbudget.php?q="+str,true);

function BeginLoading(){
    var eLoader = document.createElement("img");

    eLoader.src = "images/loader.gif";
    eLoader.alt = "";
    eLoader.id = "ajaxloader";

    document.getElementById('txtBudget').appendChild(eLoader);


    xmlhttp.send();
}

BeginLoading();

}


function showProjectType()
{
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtType").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getprojtype.php",true);
xmlhttp.send();
}

function showPM()
{
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtProjMan").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getemp.php?emptype=empPM",true);
xmlhttp.send();
}

function showPD()
{
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtProjDir").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getemp.php?emptype=empPD",true);
xmlhttp.send();
}

function showProject(str)
{
if(str=='Choose..')
	return;
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtProj").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getprojectnewinvoice.php?q="+str,true);
xmlhttp.send();

}

function showCR(cat)
{
	var block1 = document.getElementById("crdetail1");
	var block2 = document.getElementById("crdetail2");
	if(cat!="CHANGE REQUEST")
	{

	        block1.style.display = 'none';
	        block2.style.display = 'none';
	
	}
	else
	{
	        block1.style.display = 'inline';
	        block2.style.display = 'inline';
	}
		
}

function showCustomer()
{
if (window.XMLHttpRequest)
  {// code for IE7+, Firefox, Chrome, Opera, Safari
  xmlhttp=new XMLHttpRequest();
  }
else
  {// code for IE6, IE5
  xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
  }
xmlhttp.onreadystatechange=function()
  {
  if (xmlhttp.readyState==4 && xmlhttp.status==200)
    {
    document.getElementById("txtCust").innerHTML=xmlhttp.responseText;
    }
  }
xmlhttp.open("GET","getcustomer.php",true);
xmlhttp.send();
}
</script>
</head>
<body onload="showProjectType();">
<?php include 'header.php'; 
$budid=$_GET["bud_id"];

$coned=getConnection();
$sqled="
select a.id bud_id,ohrm_customer_id customer_id, b.id project_id,a.excess_budget,reason,a.docurl,category,crvalue,budget_name
from project_excess_budget a
inner join project_details b on a.project_id = b.id
where a.id = ".$budid ;
$resulted = mysqli_query($coned,$sqled) or debug($sqled."   failed  <br/><br/>".mysql_error());
$rowed = mysqli_fetch_array($resulted);


?>


<h3>Authorise Excess Budget</h3>

<form name="projectForm" action="updateebudgetstatus.php" method="post" onsubmit="return formSubmit();" >
<?php
$_GET['projid']=$rowed[project_id];
include 'operproj.php';
?>
<table>
        <tr>
                <td>Customer : </td>
                <td>

<?php
include 'getcustomer.php';
echo "<script>document.getElementById('cust').value = '$rowed[customer_id]';</script>";
echo "<script>document.getElementById('cust').disabled=true;</script>";
?>

</td>

                <td>Project : </td>
<td>
<?php
$_GET['q'] = $rowed[customer_id];
include 'getprojectnewinvoice.php';
echo "<script>document.getElementById('proj').value = '$rowed[project_id]';</script>";
echo "<script>document.getElementById('proj').disabled=true;</script>"; 
?>
</td>
        </tr>

<tr>

<td> Type : </td>
<td>
<select id='category' name='category' onchange=showCR(this.value)>
<option>CHANGE REQUEST</option>
<option>OVERRUN</option>
<option>MILESTONE</option>
</select>
</td>
<td id='crdetail1'>CR Value</td>
<td id='crdetail2'><input type='number' id='crvalue' name='crvalue' value=0></td>
</tr>

<?php
echo "<script>document.getElementById('category').value = '$rowed[category]';</script>";
echo "<script>document.getElementById('crvalue').value = '$rowed[crvalue]';</script>";

?>
 </td>
</tr>


<tr>
<td> Budget Name: </td>
<td><input type="text" cols='30' id="budgetname" name="budgetname" value='<?php echo $rowed[budget_name]?>'></td>

<td>Budget : </td>
<td>
<input type="text" id="excess" name="excess">
<input type="hidden" id="excessPost" name="excessPost">
<td>
</tr>
<tr>
<td>Reason for Budget : </td>
<?php echo "<td>  <textarea rows=5 cols=40 name='Reason' id='Reason'>".$rowed[reason]."</textarea>";?>
 </td>
</tr>
<tr>
<td>
<?php echo "<td><a href='$rowed[docurl]'>Links to Documentation and Estimation</a></td>";?>

 </td>
</tr>

<?php 
echo "<script>document.getElementById('excess').value = '$rowed[excess_budget]';</script>";
echo "<script>document.getElementById('excessPost').value = '$rowed[excess_budget]';</script>";
echo "<script>document.getElementById('excess').disabled=true;</script>";
echo "<script>document.getElementById('Reason').value = '$rowed[reason]';</script>";
echo "<script>document.getElementById('Reason').disabled=true;</script>";

echo "<script>document.getElementById('docurl').value = '$rowed[docurl]';</script>";
echo "<script>document.getElementById('docurl').disabled=true;</script>";
echo "<script>document.getElementById('category').value = '$rowed[category]';</script>";
echo "<script>document.getElementById('category').disabled=true;</script>";
echo "<script>document.getElementById('crvalue').value = '$rowed[crvalue]';</script>";
echo "<script>document.getElementById('crvalue').disabled=true;</script>";

?>

</table>
<tr>
<td>			<div id="txtBudget"><table id="finance"></table></div> </td>
</tr>

<td> 
<input type="submit"  value="Authorise Budget"> 
<?php
echo "<b><input name='bud_id' id='bud_id' type='hidden' value='$budid'></b>";
echo "<b><input name='bud_cat' id='bud_cat' type='hidden' value='$rowed[category]'></b>";
echo "<b><input name='byFld' id='byFld'  type='hidden' value='authorised_by'></b>";
echo "<b><input name='statuschg' id='statuschg'  type='hidden' value='AUTHORISED'></b>";
echo "<b><input name='onFld' id='onFld'  type='hidden' value='authorised_on'></b>";
?>
</td>
</form>
</body>
</html>