<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<?php
include("includes/headcontent.php");
if ($_COOKIE['client_id'] == "") {
	header("location: client_select.php?url=ckeditor_intro");
}
include("includes/config.php");
include("includes/connect.php");
include("includes/commonfunctions.php");
include("includes/header.php");
$chk = chkauditor();
?>
<script src="/ckeditor/ckeditor.js"></script>
</head>
<?php
function update() {
	//update db
	global $_REQUEST;
	$client_id = $_COOKIE['client_id'];
	$aud_type = $_COOKIE['audit_type'];
	$overview = replace_string($_POST['overview']);
	$issues = replace_string($_POST['issues']);
	$sql = "SELECT * FROM man_report WHERE client_id = '$client_id' AND aud_type = $aud_type";
	$result = mysql_query($sql);
	$num_rows = mysql_num_rows($result);
	if ($num_rows == 0) {
		$sqli = "INSERT INTO man_report (client_id,aud_type,man_overview,issues)";
		$sqli .= " VALUES ('$client_id',$aud_type,'$overview','$issues')";
		$resulti = mysql_query($sqli);
		$return = $resulti;
	}
	else {
		$sqlu = "UPDATE man_report SET man_overview = '$overview', issues = '$issues'";
		$sqlu .= " WHERE client_id = '$client_id' AND aud_type = $aud_type";
		$resultu = mysql_query($sqlu);
		$return = $resultu;
	}
	return $return;
}
?>
<body>
 <div class="main">
        <div class="logo">
        </div>
    <div class="menubar">
<?php
	$long = "yes";
include("includes/topnav.php");
?>
	</div><!-- menubar -->
<div class="mainsection">
    <div class="mainleft">
        <div class="sidebar">
        </div>
    </div> <!-- mainleft -->
    <div class="mainright">
<div class="greyline"></div>
    <div class="mainbox">
 <?php

$submit_text = DBSelect("button_list","button","submit");

$upd = true;
if ($_POST) {
	$upd = update();
}
?>
     <form id="write_mgtsum" name="write_mgtsum" action="ckeditor_mgtsum.php" method="post">
		<table border="0" width="95%">
			<tr>
				<td colspan="3"><strong><?php echo $_COOKIE['company']." - ".$_COOKIE['aud_desc'];?></strong></td>
			</tr>
<?php
$client_id = $_COOKIE['client_id'];
$aud_type = $_COOKIE['audit_type'];
$sqlca = "SELECT * FROM client_audit WHERE client_id = '$client_id' AND aud_type = $aud_type";
$resultca = mysql_query($sqlca);
$num_rowsca = mysql_num_rows($resultca);
if ($num_rowsca == 0) {
	$client_audit_id = 0;
}
else {
	$rowca = mysql_fetch_assoc($resultca);
	$client_audit_id = $rowca['id'];
}

//if (!audcomplete() && auditorislead($client_audit_id,$_COOKIE['auditor_no'])) {
//HV 16/4 bug fix for autofill release
$sqlma = "SELECT * FROM master_auditor";
$resultma = mysql_query($sqlma);
$num_rowsma = mysql_num_rows($resultma);
if ($num_rowsma == 0){
	$ma = false;
}
else {
	$rowma = mysql_fetch_assoc($resultma);
	if ($rowma['username'] == $_COOKIE['username']){
		$ma = true;
	}
	else {
		$ma = false;
	}
}
if ((!audcomplete() && auditorislead($client_audit_id,$_COOKIE['auditor_no'])) || (audnumber()==1 && $ma)) {
$sql = "SELECT man_overview, issues FROM man_report WHERE client_id = '".$_COOKIE['client_id']."' AND aud_type = " . $_COOKIE['audit_type'];
$result = mysql_query($sql);
$num_rows = mysql_num_rows($result);
if ($num_rows != 0) {
	$row = mysql_fetch_assoc($result);
}
if (!$upd) {
?>
			<tr>
				<td colspan="3"><font class="error"><?php echo DBSelect("message_list","message","mgt_sum_failed");?></font></td>
			</tr>
<?php
}
?>
			<tr>
				<td valign="top" colspan="3"><strong>**Management Summary**</strong></td>
			</tr>
			<tr>
				<td colspan="3"><textarea name="issues" id="issues" cols="80" rows="10"><?php echo $row['issues']; ?></textarea>
				<script>CKEDITOR.replace( 'issues',	{toolbar : 'SDIAdmin'},{width: '100%',height: '80%'});</script>
                </td>
			</tr>
			<tr>
				<td>&nbsp;</td>
				<td>
                    <a href="write_mgt_summary_print.php" class="main_button" onclick="var w=window.open(this.href, 'display', 'width=680,height=450,top=200,left=290,location=0,titlebar=0,menubar=0,addressbar=0,toolbar=0,status=no,scrollbars=1,resizable=0'); w.focus(); return false;"><INPUT TYPE="image" SRC="/servicedesk-certification/images/print.png" width="56" height="28" ALT="<?php echo DBSelect("button_list","button","print");?>">
</td>
				<td><INPUT TYPE="image" SRC="/servicedesk-certification/images/submit.png" width="90" height="28" onClick="submitbutton();" ALT="<?php echo $submit_text;?>"></td>
			</tr>
<?php
	}
	else {
		if (audcomplete()){
?>
		<tr>
			<td colspan="3"><font class="error"><?php echo DBSelect("message_list","message","audcomplete");?></font></td>
		</tr>
	<?php
		}
		else {
	?>
			<tr>
				<td colspan="3"><font class="error"><?php echo DBSelect("message_list","message","notleadauditor");?></font></td>
			</tr>
	<?php
		}
	}
?>
	</table> <!-- main table -->
  </form>

	</div><!--mainbox-->
    </div> <!-- mainright -->
<?php
	include("includes/footer.php");
?>
</div> <!-- mainsection -->
 </div> <!-- main -->
</body>
</html>
