<?php  
//ini_set('memory_limit', '1G');
//ini_set('display_errors', 1);
//error_reporting(E_ALL);
include ("../../operainfo/getq.php");
$yesihavesomestocklinks='';
$topdesc='';
$docid=safetext2($_GET['docid']);
$d=0;
$draftchecked='';
$showdochistory=safetext2(isset($_GET['showdochistory']) ? $_GET['showdochistory'] : '');
?> 
<script src="/jquery-ui-1.10.3/jquery-1.9.1.js"></script>
<script src="/jquery-ui-1.10.3/ui/jquery-ui.js"></script>
<link rel="stylesheet" href="/jquery-ui-1.10.3/themes/base/jquery-ui.css">  
<script>
$(function() {
$( "#datepicker" ).datepicker({ dateFormat: 'dd-mm-yy' });
});
</script> 
<script>
$(function() {
$( "#alarmdatepicker" ).datepicker({ dateFormat: 'dd-mm-yy' });
});
</script> 
<script type="text/javascript">
function updaterreviewed() {
var link = "reviewedoc_inbackground.php?<?php print "$x";?>&docid=<?php print "$docid";?>";
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
		document.getElementById('reviewedbutton').innerHTML=xmlhttp.responseText;
}
}
} 
</script>
<script type="text/javascript">
function cloneprocess() {
	var fromdocid=document.getElementById('cloneprocess').value;
	if (fromdocid.trim() === "") {
alert("Please enter a valid document ID.");
return; // Stop execution if fromdocid is empty
}
var link = "cloneprocess.php?<?php print "$x";?>&todocid=<?php print "$docid";?>&fromdocid="+fromdocid;
document.getElementById('clonp').innerHTML=link;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
		document.getElementById('clonp').innerHTML=xmlhttp.responseText;
		location.reload();
}
}
} 
</script> 
<script type="text/javascript">
function clonestock() {
	var fromdocid=document.getElementById('clonestock').value;
	if (fromdocid.trim() === "") {
alert("Please enter a valid document ID.");
return; // Stop execution if fromdocid is empty
}
var link = "clonestock.php?<?php print "$x";?>&todocid=<?php print "$docid";?>&fromdocid="+fromdocid;
document.getElementById('clonestock').innerHTML=link;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
		document.getElementById('clonestock').innerHTML=xmlhttp.responseText;
		location.reload();
}
}
} 
</script> 
<script type="text/javascript">
function cloneiso() {
	var fromdocid=document.getElementById('cloneiso').value;
	if (fromdocid.trim() === "") {
alert("Please enter a valid document ID.");
return; // Stop execution if fromdocid is empty
}
var link = "cloneisolinks.php?<?php print "$x";?>&todocid=<?php print "$docid";?>&fromdocid="+fromdocid;
document.getElementById('clonp').innerHTML=link;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
		document.getElementById('cloniso').innerHTML=xmlhttp.responseText;
		location.reload();
}
}
} 
</script> 
<script type="text/javascript">
function interestedparty(intparty) {
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET","updateinterestedparty.php?<?php print "$x";?>&docid=<?php print "$docid";?>"+"&intparty="+intparty,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
}
}
} 
</script> 
<script type="text/javascript">
function removerelated(tdocid) {
document.getElementById('refdocs').innerHTML='Removing Document';
var link = "removerelateddocument.php?<?php print "$x";?>&docid=<?php print "$docid";?>"+"&related="+tdocid;
document.getElementById('refdocs').innerHTML='<a href=\"'+link+'\">tst</a>';
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('refdocs').innerHTML=xmlhttp.responseText;
}
}
} 
</script> 
<script type="text/javascript">
function updateprocref(process, tdocid) { 
var link = "updateprocref.php?<?php print "$x";?>&docid=<?php print "$docid";?>"+"&referenced="+process; 
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{ 
}
}
}
</script> 
<script type="text/javascript">
function addrelated() {
var newdocid=document.getElementById('addrelated').value;
var link = "addrelateddocument.php?<?php print "$x";?>&docid=<?php print "$docid";?>"+"&related="+newdocid;
document.getElementById('refdocs').innerHTML='<a href=\"'+link+'\">tst</a>';
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET",link,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('refdocs').innerHTML=xmlhttp.responseText;
}
}
} 
</script> 
<script type="text/javascript"> 
function linktype(typeid , docid) {
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET","linktodoctype.php<?php print "$x";?>&typeid="+typeid+"&docid="+docid,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('typeid').innerHTML=xmlhttp.responseText;
}
}
}
</script> 
<script type="text/javascript"> 
function updateer(erid , docid , familyid) {
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET","updateerdocid.php<?php print "$x";?>&erid="+erid+"&docid="+docid+"&familyid="+familyid,true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('rt').innerHTML=xmlhttp.responseText;
	location.reload();
}
}
}
</script>  
<script type="text/javascript"> 
function updateusergroup(groupid) {
document.getElementById('rt').innerHTML=groupid;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET","updategroup.php<?php print "$x";?>&groupid="+groupid+"&docid=<?php print "$docid";?>",true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('rt').innerHTML=xmlhttp.responseText;
	//location.reload();
}
}
}
</script> 
<script type="text/javascript"> 
function gethistoryofdoc() {
document.getElementById('historydoc').innerHTML='Retrieving History Files';
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET","get_dochistory.php<?php print "$x";?>&docid=<?php print "$docid";?>",true);
xmlhttp.send();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('historydoc').innerHTML=xmlhttp.responseText;
	//location.reload();
}
}
}
</script> 
<div id=rt></div>  
<?php
$nowis=date("U"); 
$withinamonth=$nowis-2629743;
 

$usestkdesc = array();
$usesupercode = array();
$sql = "SELECT stock_ref, OperaDescription, SUPERSEDED FROM stocklist_tarriffs";
$stmt = pdoquery($sql);
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usestk = $row['stock_ref'];
    $usestkdesc[$usestk] = $row['OperaDescription'];
    $usesupercode[$usestk] = $row['SUPERSEDED'];
}

$erdesc = array(); // Ensure initialised

$sql = "SELECT * FROM viamed_essential_requirements";
$stmt = pdoquery($sql);
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $erid = $row['id'];
    $erdesc[$erid] = $row['Annexipartnum'] . ' ' . $row['Annexipartnumsection'];
}

// Load counts from ISO_quality_manual_files
$sql = "SELECT COUNT(*) FROM ISO_quality_manual_files WHERE archived='' AND reviewed_date < ?";
$stmt = pdoquery($sql, array($withinamonth));
$numtocheck = $stmt->fetchColumn();

$sql = "SELECT COUNT(*) FROM ISO_quality_manual_files WHERE archived=''";
$stmt = pdoquery($sql);
$totalinsystem = $stmt->fetchColumn();

// Set default docid if empty
if ($docid == '') {
    $sql = "SELECT docid FROM ISO_quality_manual_files WHERE archived='' ORDER BY id LIMIT 1";
    $stmt = pdoquery($sql);
    if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $docid = $row['docid'];
    }
}
$intpartcheck = array();	
// Interested Parties linked to current doc
$sql = "SELECT * FROM ISO_quality_manual_interestedpartys WHERE docid = ?";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $intpartid2 = $row['interestedparty'];
    $intpartcheck[$intpartid2] = "CHECKED";
}

// Log user has read this doc
$sql = "INSERT INTO ISO_quality_manual_user_read (docid, userid, last_read) VALUES (?, ?, ?)";
pdoquery($sql, array($docid, $vui, $nowis));

// Previous doc (if any)
$sql = "SELECT docid FROM ISO_quality_manual_files WHERE archived = '' AND docid < ? ORDER BY id DESC LIMIT 1";
$stmt = pdoquery($sql, array($docid));
if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $predoc = $row['docid'];
}

// Next doc (if any)
$sql = "SELECT docid FROM ISO_quality_manual_files WHERE archived = '' AND docid > ? ORDER BY id LIMIT 1";
$stmt = pdoquery($sql, array($docid));
if ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $nextdoc = $row['docid'];
}
				 
$revdtext="";		
// Get review history for this document
$sql = "SELECT * FROM ISO_quality_manual_files_reviews WHERE docid = ? ORDER BY id DESC";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $revdate = date("d M Y", $row['reviewedon']);
    $revdtext .= "\n<br>$revdate " . getusername($row['reviewedby']);
}
					
$usesec = array();
$opttext = "";

// Load security options
$sql = "SELECT * FROM ISO_quality_manual_files_security";
$stmt = pdoquery($sql);
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $useid = $row['id'];
    $usesec[$useid] = $row['description'];
    
    $opttext .= "<option value='" . $row['id'] . "'>" . $row['description'] . "</option>";
}
	
$allmustread = "";
// Check if this doc is linked to course ID 8
$sql = "SELECT * FROM ISO_training_docs WHERE docid = ? AND courseid = '8'";
$stmt = pdoquery($sql, array($docid));
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $allmustread = "CHECKED";
}
	 
$sql = "SELECT * FROM ISO_quality_manual_files WHERE docid = ? LIMIT 0,1";
$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $utype               = $row['type'];
    $udesc               = $row['description'];
    $uaddedby            = $row['addedby'];
    $uaddedon            = date("d M Y", $row['addedon']);
    $uaddedoncode        = $row['addedon'];
    $ufilename           = $row['filename'];
    $udocname            = "files/" . $row['docname'];
    $topdocname          = $udocname;
    $uoldid              = $row['oldid'];
    $usec                = $row['security'];
    $review_timer        = $row['review_timer'];
    $revdate             = date("d/m/y", $row['reviewed_date']);
    $expdate             = $row['exp_date'];
    $alarmexpdate        = $row['alarmdate'];
    $owncompany          = $row['hostcompany'];
    $searchextra         = $row['searchextra'];
    $downloadname        = $row['downloadname'];
    $global_company_website_files[$owncompany] = isset ( $global_company_website_files[$owncompany] ) ? $global_company_website_files[$owncompany] : '';
    $shopifyname = $global_company_website_files[$owncompany] . str_replace(" ", "_", $downloadname) . "_ID" . $row['docname'];
    $hostid				 = $owncompany;
    $documentexplain     = $row['documentexplain'];
    $draftdocument       = $row['draftdocument'];
    $primaryaudit        = $row['primaryaudit'];
    $primarycop          = $row['primarycop'];
    $md5hash             = $row['md5hash'];
    $hashlist[$md5hash]  = $md5hash;
    $pricelistlink       = $row['pricelistcode'];
    $purchaseorderid     = $row['purchaseorderid'];
    $porrefu             = $row['porref'];
    $salesorderid        = $row['salesorderid'];
    $riskassesmentfile   = $row['riskassesmentdocid'];
    $alarmexpireuser     = $row['alarmexpireuser'];
    $contactdontchase    = $row['contactdontchase'];
    $external_revision_ref = $row['external_revision_ref'];
    $downloadcount       = $row['downloadcount'];
    $ai_raw              = $row['AI_raw'];
    $ai_status           = $row['AI_status'];
    $ai_processedon      = $row['AI_reviewedon'];
    $iso_supplier_review = $row['iso_supplier_review'];
    
    $scope = str_replace("<br />", "\n", $row['scope']);

    if ($draftdocument > 0) {
        $draftchecked = 'CHECKED';
    }

    $draftupdatetodocid = $row['draftupdatetodocid'];
    $draftrevision      = $row['draftrevision'];
    $archivedstate      = $row['archived'];
    $bsendoc            = $row['isostandard'];
    $thumbdocname       = "micro_nails/" . $row['docname'] . ".jpg";

    if ($row['reviewed_date'] < 1) {
        $revdate = "<font color=red>Unconfirmed</font>";
    }

    $alarmexpire = $row['alarmexpire'];

    if ($row['exp_date'] > 10) {
        $expiredate = date("d-m-Y", $row['exp_date']);
    } else {
        $expiredate = "Not Set";
    }

    $flagexpire = $row['exp_date_ignore'];
}
	
$subproceduresanddocuments = "";

// Load documents linked by primarycop or reverse
$sql = "SELECT * FROM ISO_quality_manual_files 
        WHERE (primarycop = ? OR docid = ?) AND archived = ''";
$stmt = pdoquery($sql, array($docid, $primarycop));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // You may want to htmlspecialchars() these if outputting to HTML later
    $subproceduresanddocuments .= "<tr>
        <td>{$row['docid']}</td>
        <td>{$row['description']}</td>
        <td>
            <a href=\"removeprimarydoc.php{$x}&docid={$docid}&pdoc={$primarycop}\">
                <img src=\"../../images/small_cross.png\" border=0 title=\"Remove Link\">
            </a>
        </td>
    </tr>";
}	
$companyopts = "<option value='0'>Cross Company Document</option>";
$usecoid = 0;
$uscoidname = array(); // Make sure array is initialised
$uscoidname[$usecoid] = 'Cross Company Document';

// Load company list
$sql = "SELECT * FROM global_companys";
$stmt = pdoquery($sql);
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usecoid = $row['id'];
    $uscoidname[$usecoid] = $row['name'];
    $companyopts .= "<option value='" . $row['id'] . "'>" . $row['name'] . "</option>";
}
?>
<html>
<head><title>Admin <?php print "$docid $udesc";?> ISO Document Properties</title></head>
<body>
<?php 
print "<center><table border=0 class=n3><tr ><td align=middle valign=top colspan=2 bgcolor=\"#92adc8\">";
print ""; 
print "<h3>$udesc<br>Document Revision Code #$docid/$uaddedoncode<br>Revision Date $uaddedon</h3><br> Downloaded Count : $downloadcount</tr>";
if ($draftdocument > 0)
	{
	print "<tr><td align=middle valign=top colspan=2 bgcolor=\"$pastelyellow\">DRAFT DOCUMENT Rev . $draftrevision";
	
	if ($draftupdatetodocid>0)
		{
		print "To Replace DOCUMENT ID $draftupdatetodocid ";
		}
	print "</td></tr>";
	}

print "<td>";
print "<table class=CSSTable_n2><tr><td align=left width=50%>".linkdocid($x,$docid)."<td></td>";
?>
<a href="<?php print"$udocname";?>">View Document</a> /
<a href="download.php<?php echo $x; ?>&docid=<?php print "$docid";?>"> Download</a> 
<form method=post action="changetype.php<?php echo $x ;?>"> 
<?php 
$handle = @fopen($shopifyname, 'r');
if(!$handle){
	print "";
	} else {
print "<center><h1>This File is on the Viamed Website <br>$shopifyname<br> Inform Website Admin Prior to Updating</h1></center>";
print "<tr><td>Linked Issue(s)</tD><td>$hashissue[$md5hash]</td></tr>";
}
print "<tr><td>Scope<br>And External / Internal References <i>Notes field non Searched</i></td><td><textarea name=scope id=scope onchange=\"updatescope()\">$scope</textarea></tD></tr>";
print "<tr><td>External Revision Code<br>Note This is NOT our Revision its for Externally produced documents</td><td><input type=text name=extrev id=extrev value='$external_revision_ref' size=48></td></tr>"; 
print "<tr><td>DRAFT Document</td><td><input type=checkbox id='draft' name='draft' $draftchecked></td></tr>";
print "<tr><td>DRAFT TO replace DOCID #</td><td><input type=text id='draftreplacedocid' name='draftreplacedocid'  ></td></tr>";  
print "<tr><td>Added By </td><td>$uaddedby</td></tr>";
print "<tr><td>Added On </td><td>$uaddedon</td></tr>"; 
print "<tr><td>Expiry Date:</td><td>$expiredate</td></tr>"; 
if ($porrefu >'0' ) {
print "<tr><td>Linked to Purchase Order</td><td>".linkpurchaseorder($x,$porrefu,$float,$size)."$porrefu</td></tr>";	
}
if ($purchaseorderid >0 ) {
print "<tr><td>Linked to Purchase Orderid</td><td>$purchaseorderid</td></tr>";	
} 
if ($salesorderid >0 ) {
print "<tr><td>Linked to Sales Order</td><td>$salesorderid</td></tr>";	
} 
if ($archivedstate=='1')
{
$sql = "SELECT * FROM ISO_quality_manual_files WHERE oldid = ?";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $replacementid = $row['docid'];
}
print "<tr><td><span style=\"color : #ff0000\">Archived"; 
if ($replacementid<>'')
	{
	?>
	<a HREF="showdoc2admin.php<?php print "$x";?>&docid=<?php print "$replacementid";?>"> <?php print "DocID $replacementid</a>";?> 
	<?php
	} 
print "</span></font></td><td></td></tr>"; 
}
else
{
print "<tr><td>Upload NEW Document</td><td>";
?>
<a href="updatedoc.php<?php echo $x; ?>&docid=<?php print "$docid";?>">Upload New Revision of this Document</a>
<?php 
print "</td></tr>"; 
print "<tr><td>Open Issue to Request Update</td><Td>";
?> 
<a href="../agenda/issuesubsection.php<?php include ("../../operainfo/linkget.php"); ?>&docid=<?php print "$docid";?>&projectid=<?php print "$projectid";?>&sectionid=9&subsectionid=0&meetingid=109&agendaid=272&subject=DOCID <?php print "$docid";?> <?php print "$udesc";?>&fillbody=Controlled Document DOCID <?php print "$docid";?> <?php print "$udesc";?> Requires Updating.">Create Issue / Amending Document</a>
<?php 
print "</td></tr>";  
print "<tr><td>Remove / Archive document</td><Td>";
?> 
<a href="hideid.php<?php echo $x; ?>&docid=<?php print "$docid";?>">Delete Document</a>
<?php 
print "</td></tr>"; 
print "<tr><td>Edit Intrastats/Index Description</td><Td>";
?> 
<a href="editid.php<?php echo $x; ?>&docid=<?php print "$docid";?>" target="_blank">Update Intrastats/Index Name</a>
<?php 
print "</td></tr>";  
print "<tr><td>Last Reviewed Date<div id='reviewedbutton'> ($revdate)$revdtext </div></td><Td>"; 
?> 
<input type=button value='Confirm Current' onclick="updaterreviewed()">
<?php 
print "</td></tr>";
print "<tr><td>Document Review Report</td><Td>";
?>
<a href="document_review.php<?php echo $x; ?>&docid=<?php echo $docid; ?>&hostcompanyid=<?php echo $owncompany; ?>" target="_blank">
    <input type=button value='ISO Report'>
</a>
<?php
print "</td></tr>";
print "<tr><td>Metadata View <span class=small>(clean - for PDF)</span></td><Td>";
?>
<a href="showdocmeta.php<?php echo $x; ?>&docid=<?php echo $docid; ?>" target="_blank">View Metadata</a>
<?php
print "</td></tr>";
$prnexdate=date("d/m/y",$expdate);
$exp2=date("d-m-Y",$expdate);
print "<tr><td>Set Expiry Date"; 
print "</td><td>";
if ($expdate=='0')
	{
	$exp2="";
	$prnexdate='not set';
	}
	
	 
if ($expdate < $nowis and $expdate>0)
	{
print "<font color=red>Expired</font>";
	}
	else
	{
	
print "";	
	}
?>
<input type="text" id="datepicker" name='expdate' value='<?php print "$exp2";?>'>
<?php 
print "</td></tr>"; 
print "<tr><td>Flag if out of Expiry Date - Non Urgent Flag, Drops to Expired documentation list<br>Requires a date in Set Expiry Date</tD><Td>"; 
if ($flagexpire==0)
	{
	print "<input type=checkbox name=flagexpire checked>";
	} else{
	print "<input type=checkbox name=flagexpire >";
	}  
print "</td></tr>";  
$prnexdate=date("d/m/y",$alarmexpdate);
$exp2=date("d-m-Y",$alarmexpdate);
print "<tr><td>Set Alarm Expiry Date</td><td>";
if ($alarmexpdate=='0')
	{
	$exp2="";
	$prnexdate='not set';
	}
	
	 
if ($expdate < $nowis and $expdate>0)
	{
print "<font color=red>Expired</font>";
	}
	else
	{
	
print "";	
	}
?>
<input type="text" id="alarmdatepicker" name='alarmexpdate' value='<?php print "$exp2";?>'>
<?php 
print "</td></tr>"; 
print "<tr><td>Alarm Expiry Date - Urgent Alarm Send Daily Issue to Documentation And Records Controller<br>Requires a date in Alarm Expiry Date</tD><Td>"; 
if ($alarmexpire==1)
	{
	print "<input type=checkbox name=alarmexpire checked>";
	} else{
	print "<input type=checkbox name=alarmexpire >";
	}  
print "</td></tr>"; 
print "<tr><td>Alarm Expiry Send Issue to User <br>Requires BOTH Alarm Expiry Date and Flag Alarm Expiry Date Checked</td><td>
<select name=alarmexpireuser><option value='0'></option>";
$sql = "SELECT * FROM pw WHERE active = '1' ORDER BY username";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $id = $row['id'];
    $username = htmlspecialchars($row['username']);
    $selected = ($alarmexpireuser == $id) ? "selected" : "";
    print "<option value='$id' $selected>$username</option>";
}

print "</select></td></tr>";  
print "<tr><td>If a Contact Linked Document Chase Yearly.<br>
Only applies to<br><sub>";
$sql = "SELECT * FROM ISO_quality_manual_files_types 
        WHERE supplierreviewrequired = '1' 
        ORDER BY description";
$stmt = pdoquery($sql);

$ccc = 0;
$comma = ""; // Initialise to prevent undefined warning

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // Escape output if HTML safety is a concern
    $desc = htmlspecialchars($row['description']);
    echo $comma . $desc;

    $ccc++;
    if ($ccc == 5) {
        $comma = " <br>";
        $ccc = 0;
    } else {
        $comma = " , ";
    }
}

print "</sub></td><td>";
print "<select name='contactdontchase'>";
if ($contactdontchase==0) {
print "<option value='0' selected>Confirm Current Yearly</option>";
print "<option value='1'>No Requirement to Confirm Current</option>";		
	} else {
	print "<option value='0' >Confirm Current Yearly</option>";
print "<option value='1' selected>No Requirement to Confirm Current</option>";		
		}
	 
print "</td></tr>"; 
print "<tr><Td valign=top>Document Notes<br>Displays on main Doc View Screen AND Price View Screen<BR>DOES NOT SEARCH this box</td><td valign=top>"; 
print "<textarea name='documentexplain'>$documentexplain</textarea>"; 
print "</td></tr>"; 
print "<tr><td valign=top>Search Terms (Not Visable)</td><td>"; 
print "<textarea name='searchextra'>$searchextra</textarea>"; 
print "</td></tr>"; 
print "<tr><td>Official BS EN Document</td><Td>";  
if ($bsendoc=='1')
	{
?> 
<a href="bsendoc.php<?php echo $x; ?>&docid=<?php print "$docid";?>&ans=">Yes</a>
<?php
	}
	else
	{
?> 
<a href="bsendoc.php<?php echo $x; ?>&docid=<?php print "$docid";?>&ans=1" >No</a>
<?php	
	}
print "</td></tr>";  
$sql = "SELECT * FROM ISO_quality_manual_stock_links 
        WHERE docid = ? AND stock_ref <> ''";
$stmt = pdoquery($sql, array($docid));
$numstklink = $stmt->rowCount();

$alttext = ""; // Make sure it's initialised

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usestk = $row['stock_ref'];
    $alttext .= $usestk . " - " . $usestkdesc[$usestk] . "\n";
}
print "<tr><td>Direct Stock Links</td><td>"; 
print "Currently $numstklink Linked</td></tr>"; 
if ($numstklink > 0 )
	{
		
	if ($owncompany==0 and $usersecurity > 7) {
print "<tr><td>Produce Price Guide</td><td>REQUIRES Host Company</td></tr>";
	} else {		
		
		
	print "<tr><td>Generate Price Guide</td><td>$global_company_logo[$owncompany]";
	?>
	<a href="../pricelists/index.php<?php echo $x;?>&hostcompanyid=<?php print "$owncompany";?>&docid=<?php print "$docid";?>">PriceGuide</a>
	<?php
	print "</td></tr>";
	}
	} 
	  
print "<tr><td>Change File Type</td><td>"; 
$ftype1desc = array(); // Ensure initialised

$sql = "SELECT * FROM ISO_quality_manual_files_types ORDER BY description";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $ftype1 = $row['type'];
    $ftype1desc[$ftype1] = $row['description'];
}
$ftype1desc[$utype] = isset ( $ftype1desc[$utype] ) ? $ftype1desc[$utype] : '';
?> 

<input type=hidden name=docid value="<?php print "$docid";?>">
<select name=newtype>
<option value="<?php print "$utype";?>"><?php print "$ftype1desc[$utype]";?></option>
<?php 

$sql = "SELECT * FROM ISO_quality_manual_files_types ORDER BY description";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $type = htmlspecialchars($row['type']);
    $desc = htmlspecialchars($row['description']);
    echo "<option value=\"$type\">$desc</option>\n";
}


?> 
</select> 
<?php 
	if ($utype=='a2f894dd78aa4363c7ef061087e2f182') {
		print "<input type=button value='FAQ' onclick=\"window.location.href='/intranet/databases/intrastatstats/faq_addentry.php$x&docid=$docid'\">";
		}  
if ($utype=='Audit' and $owncompany > 0) {
	print "<a href=\"../audits/index.php$x&docid=$docid\">Generate $uscoidname[$owncompany] Audit Document</a>";
}
print "</td>";
?> 
</tr><tr><td>Security Level</td><td><select name=sec>
<option value='<?php print "$usec";?>'><?php print "$usesec[$usec]";?></option>
<?php print "$opttext";?>
</select></td></tr>
<tr><Td> 
<?php print "$global_company_logo[$owncompany]"; ?> Host Company </td><td><select name=owncompany>
<option value='<?php print "$owncompany";?>'><?php print "$uscoidname[$owncompany] ";?></option>
<?php print "$companyopts "; ?> 
</select></td></tr> 
<?php 
if ($owncompany!=0 and $utype=='PRICE') { 
print "<tr><td>Price List CODE (Link Stock Screens)</td><td>"; 
$pricelistcodedescription = array(); // Ensure initialised

$sql = "SELECT * FROM specialprices_types WHERE hostcompanyid = ?";
$stmt = pdoquery($sql, array($owncompany));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $pricelistcode = $row['code'];
    $pricelistcodedescription[$pricelistcode] = $row['description'];
}
print "<select name='pricelist'><option value='$pricelistlink'>$pricelistcodedescription[$pricelistlink]</option><option value=''></option>";
$sql = "SELECT pricelist FROM global_companys_bankaccounts 
        WHERE companyid = ? 
        GROUP BY pricelist";
$stmt = pdoquery($sql, array($owncompany));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $pricelistcode = $row['pricelist'];
    $description = isset($pricelistcodedescription[$pricelistcode]) 
        ? htmlspecialchars($pricelistcodedescription[$pricelistcode]) 
        : '(Unknown)';

    echo "<option value='" . htmlspecialchars($pricelistcode) . "'>$description</option>";
}
print "</select></td></tr>";
	
}else {
	$pricelistcode=isset ( $pricelistcode ) ? $pricelistcode : 0 ;
    $description = isset($pricelistcodedescription[$pricelistcode]) 
        ? htmlspecialchars($pricelistcodedescription[$pricelistcode]) 
        : '(Unknown)';		
		print "<tr><Td>Price List CODE (Requires Type and Host)</td><td><input type=hidden name='pricelist' value='$pricelistlink'>$description</td></tr>";
	} 
?> 
<tr><td>Review Time</td><td><input type=text name=reviewtime value='<?php print "$review_timer";?>'>Months</td></tr>
<tr><td>Download Name</td><td><input type=text name=downloadname value='<?php print "$downloadname";?>' size=36></td></tr>
<tr><td>Primary Audit</td><td><input type=text name=primaryaudit value='<?php print "$primaryaudit";?>'></td></tr>
<tr><td>Primary Cop</td><td><select name=primarycop>
<?php
if ($primarycop > 0)
	{
	print "<option value='1'>Yes</option>";
	} else
	{
	
	}
print "<option value='0'>No</option><option value='1'>Yes</option>";
print "</select></td></tr>";
?>
<tr><td>Iso Supplier Review Document</td><td><select name=iso_supplier_review>
<?php
if ($iso_supplier_review ==1)
	{
	print "<option value='1' selected>Yes</option>";
	}
if ($iso_supplier_review==0)
	{
	print "<option value='0' selected>No</option>";
	}
print "<option value='0'>No</option><option value='1'>Yes</option>";
print "</select></td></tr>"; 
if ($riskassesmentfile > 0 ) {
	print "<tr><td>Risk Assesment File</td><td>".linkdocid($x,$riskassesmentfile)."$riskassesmentfile</td></tr>";
} 
if ($ai_processedon > 0 ) {
	$aidate=date("d M Y",$ai_processedon);
	} else {
	$aidate="Unscanned";
		}
?>
<tr><td>AI Scanned</td><td><?php echo $ai_status ;?>
<tr><td>AI Scanned On</td><td><?php echo$aidate;?>
<tr><td valign=top>AI Raw</td><td><?php  
if ( $ai_raw <>'') {
	echo "Has Decode";
	} else {
	echo "Not Decoded";	
		} 
?></td></tr> 
<tr> 
<td></td><td>
<input type=submit value='Update'></form></td></tr>
<?php  
print "</td></tr>";
}
$prnexdate=date("d/m/y",$expdate);
$exp2=date("d-m-Y",$expdate);
print "<tr><td>Search Expiry Date"; 
if ($ai_raw <>'') {
$ai_pretext="DATA : \n $ai_raw QUESTION IF theres an expiry date Answer:
Expiey Date is ..... \n
Otherwise state No Date Found "; 
prep_ask_ai_noinput($ai_pretext);
}  
print "</td><td>";
if ($expdate=='0')
	{
	$exp2="";
	$prnexdate='not set';
	}
	
	 
if ($expdate < $nowis and $expdate>0)
	{
print "<font color=red>Expired</font>";
	}
	else
	{
	
print "";	
	}
print "</td></tr>";
print "</table><hr>"; 
$historysearch = ""; // Initialise to avoid undefined var

$sql = "SELECT issueid FROM viamedagendalinkdocs WHERE md5hash = ?";
$stmt = pdoquery($sql, array($md5hash));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $historysearch .= " OR id='" . $row['issueid'] . "' ";
} 
print "<table class=n3 width=100%><tr><td><h3>History Of Document</h3>"; 
if ($showdochistory==1) { 
$running=1;
$startdocid=$uoldid;
print "<table  width=100%><td>ID/Revision</td><td>Download</td><td>Added On</td><td>Replaced On</td><td>Type</td><td>Issue if App.</td><td>Replaced due</td><td>Old Name/Verison</td></tr>";
while ($running=='1')
	{ 
$hashlist = isset($hashlist) ? $hashlist : array();
$useddoc = isset($useddoc) ? $useddoc : array();

$sql = "SELECT * FROM ISO_quality_manual_files WHERE docid = ? AND docid <> '0'";
$stmt = pdoquery($sql, array($startdocid));
$sc = $stmt->rowCount();

if ($sc > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $md5hash = $row['md5hash'];
        $hashlist[$md5hash] = $md5hash;

        echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        echo "<td>";

        $uaddedon = date("d M Y", $row['addedon']);
        $unotes = "Replaced on $uaddedon \nDocid " . $row['docid'] . " Details\n" . $row['addedby'] . "\n" . $row['filename'] . "\n" . $row['reason'];
        $tdoc = $row['docid'];

        $useddoc[$tdoc] = isset($useddoc[$tdoc]) ? $useddoc[$tdoc] + 1 : 1;

        $udocname = "files/" . $row['docname'];
        $utype = substr($udocname, -4);

        // Build historysearch
        $historysearch .= " OR subject LIKE '%DOCID " . $row['docid'] . "%' OR notes LIKE '%DOCID " . $row['docid'] . "%' ";

        echo "</td><td>";
        echo "<a href=\"download_old.php{$x}&docid={$tdoc}&replaced={$uaddedon}\">";
        echo "<img src=\"../../images/menu/download.png\" width=32 height=32></a>";
        
        $uaddedon2 = date("d/M/Y", $row['addedon']);
        echo "</td><td>$uaddedon2</td>";
        echo "<td>$uaddedon</td>";
        
        $uaddedon = date("d/M/Y", $row['addedon']); // reassign formatted date
        echo "<td>$utype</td><td>";

        if ($md5hash != "d41d8cd98f00b204e9800998ecf8427e") {
            echo isset($hashissue[$md5hash]) ? $hashissue[$md5hash] : '';
        }

        echo "</td><td>" . htmlspecialchars($row['update_reason']) . "</td>";
        echo "<td>" . htmlspecialchars($row['description']) . "</td></tr>";

        // Prepare for next loop
        $startdocid = $row['oldid'];
    }

    if ($useddoc[$tdoc] > 1) {
        $running = 2;
    }
} else {
    $running = 0;
    echo "</table>";
}
	} 
print "</td></tr></table><br>";
} else {
//print "<a href=\"showdoc2admin.php$x&docid=$docid&showdochistory=1\" >history</a>";
print "<div id='historydoc'><button onclick=\"gethistoryofdoc()\">SHOW HISTORY FILES</button></div><br>";
	
} 
$hasrelateddocuments = 0; // fixed spelling
$relateddocuments = array(); // initialise for safety

$sql = "SELECT * FROM ISO_quality_manual_files_referenced_docids 
        WHERE refdocid = ? OR docid = ?";
$stmt = pdoquery($sql, array($docid, $docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    // Find the "other" docid
    if ($row['refdocid'] == $docid) {
        $tdoc = $row['docid'];
    } else {
        $tdoc = $row['refdocid'];
    }

    $relateddocuments[$tdoc] = $tdoc;
    $hasrelateddocuments = 1;
}
	print "<br><div id='refdocs'><table class=n3 width=100%><tr><td colspan=1><h3>Related Documents</h3></td><td colspan=2><input type=text id='addrelated'><input type=button onclick=\"addrelated()\" value='Add DocID'>  </td></tr>";

if (is_array($relateddocuments)) {
    foreach ($relateddocuments as $tdocid) {
        echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        echo "<td>" . getdocumentdescription($x, $tdocid) . "</td>";
        echo "<td></td>";
        echo "<td align=\"right\">
                <img src=\"/intranet/images/small_cross.png\" width=\"12\" height=\"12\" 
                     title=\"Remove Link\" onclick=\"removerelated('$tdocid')\">
              </td>";
        echo "</tr>";
    }
} else {
    // Optionally log or handle the issue
    // echo "<!-- Warning: \$relateddocuments is not an array -->";
}
print "</table></div>";  
print "<br><table class=n3 width=100%><tr><td colspan=5><h3>Interested Parties</h3></td></tr>";

$sql = "SELECT * FROM ISO_InterestedParties ORDER BY description";
$stmt = pdoquery($sql);
$num = $stmt->rowCount();
$count = 0;

echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $intpartid2 = $row['id'];
    $checked = isset($intpartcheck[$intpartid2]) ? $intpartcheck[$intpartid2] : "";
    $desc = htmlspecialchars($row['description']);

    echo "<td><input type=\"checkbox\" onclick=\"interestedparty('$intpartid2')\" $checked> $desc</td>";

    $count++;
    if ($count > 4) {
        echo "</tr>";
        echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        $count = 0;
    }
}

print "</table><br>"; 
print "<table class=n3 width=100%><tr><td><h3>Document Belongs in Groups</h3></td><td></td></tr>";
$sql = "SELECT iso_file_groups_names.group_name AS groupname, 
               iso_file_groups_names.id AS groupid 
        FROM iso_file_groups 
        INNER JOIN iso_file_groups_names 
            ON iso_file_groups_names.id = iso_file_groups.groupid 
        WHERE iso_file_groups.docid = ?";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $groupid = $row['groupid'];
    $groupname = htmlspecialchars($row['groupname']);
    $activegroup[$groupid] = 1;

    echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
    echo "<td>$groupname</td><td>";
    ?>
    <a href="removedocfromgroup.php<?php echo $x; ?>&docid=<?php echo $docid; ?>&groupid=<?php echo $groupid; ?>">
        <img src="../../images/small_cross.png" border="0" 
             title="Remove Link To <?php 
             echo isset($row['isosection']) ? htmlspecialchars($row['isosection']) : ''; 
             echo isset($useqmidescption[$usefilter]) ? '\n' . htmlspecialchars($useqmidescption[$usefilter]) : ''; ?>">
    </a>
    <?php
    echo "</td></tr>";
}
print "</table><br>";
	
	 
if ($archivedstate<>'1')
{ 
// get iso manual headers
$useqmidescption = array(); // Initialise to avoid PHP 8 warnings

$sql = "SELECT * FROM ISO_quality_manual_filter_groups";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usefilter = $row['filter'];
    $useqmidescption[$usefilter] = $row['description'];
}
?> 
<?php
$lastsection = '';

// Start table output
echo "<table class=\"n3\" width=\"100%\">
<tr><td align=\"left\" colspan=\"5\"><h3>ISO Manual Links</h3></td></tr>
<tr>
    <td>Clone from Docid</td>
    <td>
        <input type=\"text\" id=\"cloneiso\">
        <input type=\"button\" value=\"Clone\" onclick=\"cloneiso()\">
        <div id=\"cloniso\"></div>
    </td>
</tr>";
echo '
<tr>
    <td>Link to ISO</td>
    <td>
        <button type="button" onclick="window.open(\'walkthru_findisosection.php' . $x . '&docid=' . $docid . '\',\'popuppage\',\'width=500,height=600,top=100,left=100,scrollbars=yes\')">Link to ISO</button>
    </td>
</tr>
';

// Fetch ISO links for this document
$sql = "SELECT 
            ISO_quality_manual.iso_section_header AS isoheader,
            ISO_quality_manual.long_text AS ongtext,
            ISO_quality_manual.iso_section AS isosection,
            ISO_quality_manual.filter AS filter,
            ISO_quality_manual_filelinks.qmid AS qmid,
            ISO_quality_manual_filelinks.fileid AS docid
        FROM ISO_quality_manual_filelinks
        JOIN ISO_quality_manual ON ISO_quality_manual_filelinks.qmid = ISO_quality_manual.id
        WHERE ISO_quality_manual_filelinks.fileid = ?
          AND ISO_quality_manual_filelinks.archived != '1'
          AND (ISO_quality_manual.filter = '2016' OR ISO_quality_manual.filter = 'vst90012015')
        ORDER BY ISO_quality_manual.filter, ISO_quality_manual.ord";

$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usqmid = $row['qmid'];
    $usefilter = $row['filter'];

    if ($lastsection != $usefilter) {
        $lastsection = $usefilter;

        echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        echo "<td colspan=\"5\">&nbsp;</td></tr>";
        echo "<tr><td colspan=\"4\"><b>" . htmlspecialchars($useqmidescption[$usefilter]) . "</b></td><td></td></tr>";
    }

    echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
    echo "<td width=\"10%\">&nbsp;</td>";
    echo "<td width=\"10%\">";

    // Link to process viewer
    $isosection = htmlspecialchars($row['isosection']);
    $ongtext = htmlspecialchars($row['ongtext']);

    echo "<a href=\"linkisosectionprocess.php{$x}&qmid={$usqmid}&filter={$usefilter}&fromdoc=1\" 
             target=\"_ViewProcess\" title=\"{$ongtext}\">{$isosection}</a></td>";

    echo "<td>" . htmlspecialchars($row['isoheader']) . "</td><td>";

    // Remove link
    echo "<a href=\"removedocfromqmid.php{$x}&docid={$docid}&qmid={$usqmid}\">";
    $tooltip = "Remove Link To " . $isosection;
    if (isset($useqmidescption[$usefilter])) {
        $tooltip .= "\n" . $useqmidescption[$usefilter];
    }
    $tooltip = htmlspecialchars($tooltip);
    echo "<img src=\"../../images/small_cross.png\" border=\"0\" title=\"{$tooltip}\">";
    echo "</a></td><td></td></tr>";
}

echo "</table>";
//print "</td></tr></table>"; 
$useheaddesc = array();
$usesection = array();

$sql = "SELECT * FROM ISO_ce_headers";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usehead = $row['id'];
    $useheaddesc[$usehead] = $row['ce_header'];
    $usesection[$usehead] = $row['ce_section'];
} 

echo "<br><table width=\"100%\" class=\"n3\">
<tr>
    <td align=\"left\" colspan=\"4\">
        <h3>This Document is proof of ISO Standards (Usually only applies to Declarations of Conformities)</h3>
    </td>
    <td align=\"right\"></td>
</tr>
<tr>
    <td colspan=\"5\">
        <a href=\"linkstandards.php{$x}&docid={$docid}\">Add / Remove Standards</a>
    </td>
</tr>
<tr>
    <td>Standard</td>
    <td>Description</td>
    <td>Added by</td>
    <td>Added on</td>
    <td>Memo</td>
</tr>";

$sql = "SELECT 
            ISO_standards.mainheader,
            ISO_standards.description,
            ISO_quality_manual_files_standards.addedby,
            ISO_quality_manual_files_standards.addedon,
            ISO_quality_manual_files_standards.memo
        FROM ISO_quality_manual_files_standards
        JOIN ISO_standards ON ISO_standards.id = ISO_quality_manual_files_standards.standardid
        WHERE ISO_quality_manual_files_standards.docid = ?";

$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $mainheader = htmlspecialchars($row['mainheader']);
    $description = htmlspecialchars($row['description']);
    $memo = htmlspecialchars($row['memo']);
    $addedby = htmlspecialchars(getusername($row['addedby']));
    $prndate = date("d M Y", $row['addedon']);

    echo "<tr>
        <td>{$mainheader}</td>
        <td>{$description}</td>
        <td>{$addedby}</td>
        <td>{$prndate}</td>
        <td>{$memo}</td>
    </tr>";
}

echo "</table>";
// Calculate the familys
$usefamilydesc = array(); // Initialise to avoid PHP 8 warning

$sql = "SELECT * FROM ISO_ce_family_index";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usefamily = $row['id'];
    $usefamilydesc[$usefamily] = $row['family_description'];
}
	
$outputerlist = ""; // Initialise to build up the list

$sql = "SELECT * FROM viamed_essential_requirements_docids 
        WHERE docid = ? 
        GROUP BY familyid, erid, techid 
        ORDER BY familyid, erid";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usefamily = $row['familyid'];
    $erid = $row['erid'];

    $iseridlinked[$erid] = 1;
    $erisclicked[$erid] = "CHECKED";

    $familydesc = isset($usefamilydesc[$usefamily]) ? htmlspecialchars($usefamilydesc[$usefamily]) : "(Unknown Family)";
    $erdescText = isset($erdesc[$erid]) ? htmlspecialchars($erdesc[$erid]) : "(Unknown ER)";

    $outputerlist .= "<tr>";
    $outputerlist .= "<td>{$familydesc}</td><td>{$erdescText} {$erid}</td>";
    $outputerlist .= "</tr>";
}
	
	
	
print "<br><table width=100% class=n3><tr><td align=left colspan=4><h3>CE Technical Files</h3></td><td align=right></td></tr>";
?>  
<?php
//print "<table border=1 width=100% class=n3>"; 
$ersec = array(); // Initialise array

$sql = "SELECT * FROM viamed_essential_requirements";
$stmt = pdoquery($sql);
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $erid = $row['id'];
    $requirement = htmlspecialchars($row['requirement']);
    $annexNum = $row['Annexipartnum'];
    $annexSection = $row['Annexipartnumsection'];

    if ($annexSection != '') {
        $ersec[$erid] = "<a title=\"$requirement\">[$annexNum:$annexSection]</a>";
    } else {
        $ersec[$erid] = "<a title=\"$requirement\">[$annexNum]</a>";
    }
}



echo "<table width=\"100%\" class=\"n3\">
<tr><td colspan=\"5\"><h3>Technical File Links</h3></td></tr>";

$sql = "SELECT * FROM ISO_ce_index 
        WHERE fileid = ? AND familyid <> '-1' 
        GROUP BY familyid, headerid, fileid 
        ORDER BY familyid, headerid";
$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usehead = $row['headerid'];
    $usefamily = $row['familyid'];

    $familyDesc = isset($usefamilydesc[$usefamily]) ? htmlspecialchars($usefamilydesc[$usefamily]) : '';
    $section = isset($usesection[$usehead]) ? htmlspecialchars($usesection[$usehead]) : '';
    $headerDesc = isset($useheaddesc[$usehead]) ? htmlspecialchars($useheaddesc[$usehead]) : '';

    echo "<tr><td>";
    echo "<a href=\"../iso_ce_files/adminfamily.php{$x}&familyid={$usefamily}\">{$familyDesc}</a></td><td><sub>";
    echo "<a href=\"../iso_ce_files/adminfamily.php{$x}&familyid={$usefamily}&opensection={$usehead}#{$usehead}\">";
    echo "{$section} {$headerDesc}</a></sub></td><td valign=\"right\"></td><td>";

    // Remove link
    $tooltip = htmlspecialchars("$familyDesc $section $headerDesc");
    echo "<a href=\"removedocfromtechfile.php{$x}&docid={$docid}&techid={$usehead}&family={$usefamily}\">
            <img src=\"../../images/small_cross.png\" border=\"0\" title=\"Remove Link To {$tooltip}\">
          </a>";

    echo "</td><td></td></tr>";

    $lasttechnicallink = $usehead;
    $lasttechnicallinkheader = $headerDesc;

    echo "<tr><td>{$section} {$headerDesc}</td><td colspan=\"4\"></td></tr>";
    echo "<tr><td colspan=\"5\"><table border=\"1\"><tr>";

    // Nested query: fetch ERs for this tech ID
    $sql2 = "SELECT * FROM viamed_essential_isoreq 
             WHERE techid = ? 
             GROUP BY erid 
             ORDER BY erid";
    $stmt2 = pdoquery($sql2, array($usehead));

    $ccount = 0;

    while ($row3 = $stmt2->fetch(PDO::FETCH_ASSOC)) {
        $erid = $row3['erid'];

        if (!empty($ersec[$erid])) {
            if ($ccount > 9) {
                $ccount = 0;
                echo "</tr><tr>";
            }

            $checked = isset($erisclicked[$erid]) ? $erisclicked[$erid] : "";
            echo "<td>
                    <input type=\"checkbox\" onclick=\"updateer('{$erid}','{$docid}','{$usefamily}')\" {$checked}>
                    {$ersec[$erid]}
                  </td>";
            $ccount++;
        }
    }

    echo "</tr></table></td></tr><tr><td colspan=\"5\"><hr></td></tr>";
}

echo "</table><br>";





print "<table class=n3 width=100%><tr><Td colspan=2><h3>Linked to Essencial Requirements in Tech Files</h3></td></tr>";
print $outputerlist;
print "</table><br>";  
print "<table class=n3 width=100%><tr><td><h3>S.T.E.D. Technical File Format</h3></td><td></td></tr>";

$sql = "SELECT * FROM ISO_quality_manual_sted_headers, ISO_quality_manual_sted
        WHERE ISO_quality_manual_sted.stedid = ISO_quality_manual_sted_headers.id
          AND ISO_quality_manual_sted_headers.active = '1'
          AND ISO_quality_manual_sted.docid = ?";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

if ($num > 0) {
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $desc = htmlspecialchars($row['description']);
        $familySafe = isset($usefamilydesc[$usefamily]) ? htmlspecialchars($usefamilydesc[$usefamily]) : '';
        $sectionSafe = isset($usesection[$usehead]) ? htmlspecialchars($usesection[$usehead]) : '';
        $headerSafe = isset($useheaddesc[$usehead]) ? htmlspecialchars($useheaddesc[$usehead]) : '';

        echo "<tr><td>{$desc}</td><td>";
        echo "<a href=\"removedocfromstedtechfile.php{$x}&docid={$docid}&techid={$usehead}&family={$usefamily}\">";
        echo "<img src=\"../../images/small_cross.png\" border=\"0\" title=\"Remove Link To {$familySafe} {$sectionSafe} {$headerSafe}\"></a>";
        echo "</td></tr>";
    }
}

print "</table><br>";  
print "<table class=n3 width=100%><tr><td><h3>Contacts</h3></td><td></td><td></td><td></td><td></td></tr>";


$usename = array();
$usecname = array();
$quotefilelinks = array(); // Cache rows to avoid reusing exhausted result set

// Load quote links for this document
$sql = "SELECT * FROM viamedquotefilelinks WHERE docid = ?";
$stmt = pdoquery($sql, array($docid));
$numrows = $stmt->rowCount();

if ($numrows > 0) {
    // Cache results into array so we can loop twice
    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        $quotefilelinks[] = $row;
    }

    // Load company data
    $stmt2 = pdoquery("SELECT * FROM viamedquoteaddress");
    while ($row2 = $stmt2->fetch(PDO::FETCH_ASSOC)) {
        $useid = $row2['ID'];
        $usename[$useid] = $row2['COMPANY'];
    }

    // Load contact data
    $stmt2 = pdoquery("SELECT * FROM viamedquotecontact");
    while ($row2 = $stmt2->fetch(PDO::FETCH_ASSOC)) {
        $useid = $row2['id'];
        $usecname[$useid] = $row2['CONTACT'];
    }

    // Display table rows for each quote link
    foreach ($quotefilelinks as $row) {
        $usecompid = $row['COMPANYID'];
        $usecontid = $row['CONTACTID'];

        echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        echo "<td><a href=\"removecidlink.php{$x}&docid={$docid}&cid={$usecompid}&id={$usecontid}\">
                <input type=\"button\" value=\"Remove\">
              </a></td>";
        echo "<td>" . linkcrm($x, $usecompid, $usecontid) . htmlspecialchars(getcompanyname($usecompid)) . "</td>";
        echo "<td>" . htmlspecialchars(getcontactname($usecontid)) . "</td>";
        echo "</tr>";
    }
}	
?>
<tr><td colspan=5>Add New Contact Link - view crm screen for CID/ID numbers</td></tr>
<tr><td colspan=5>
<form method=post action="addcontactlink.php<?php echo $x ;?>">
<input type=hidden name=docid value="<?php print "$docid";?>">
Company id CID<input type=text name=cid>
Contact ID (Optional) ID<input type=text name=id>
<input type=submit value='Add'>
</form></td></tr> 
<?php
print "</table>"; 
print "<br><table class=n2 width=100% border=2><tr><td><h3>Stock Links <a href=\"maketempgroup.php".$x."&docid=$docid\"> Make Temp Stock Group</a></h3>";
print "<br>Clone From Docid<input type=text id='clonestock' ><input type=button value='Clone' onclick=\"clonestock()\"><div id='clonstock'></div><br>
<a href=\"addstockref.php$x&docid=$docid\">Add/Remove Stock</a><br>  
";
print "</h3></td></td><Td></td><td></td></tr>";  
$hasproddoc = array();
$hasqadoc = array();
$hasservdoc = array();
$hasifudocid = array();
$haspackingdocid = array();
$hastechdocid = array();

$sql = "SELECT stock_ref, productiondocid, qadocumentid, servicedocumentid,
               ifudocid, packingdocid, techdocid
        FROM stocklist_tarriffs
        WHERE hostcompany_id = ?";
$stmt = pdoquery($sql, array($owncompany));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usestk = $row['stock_ref'];

    if ($row['productiondocid'] > 0) {
        $hasproddoc[$usestk] = linkdocid($x, $row['productiondocid']) . $row['productiondocid'];
    }
    if ($row['qadocumentid'] > 0) {
        $hasqadoc[$usestk] = linkdocid($x, $row['qadocumentid']) . $row['qadocumentid'];
    }
    if ($row['servicedocumentid'] > 0) {
        $hasservdoc[$usestk] = linkdocid($x, $row['servicedocumentid']) . $row['servicedocumentid'];
    }
    if ($row['ifudocid'] > 0) {
        $hasifudocid[$usestk] = linkdocid($x, $row['ifudocid']) . $row['ifudocid'];
    }
    if ($row['packingdocid'] > 0) {
        $haspackingdocid[$usestk] = linkdocid($x, $row['packingdocid']) . $row['packingdocid'];
    }
    if ($row['techdocid'] > 0) {
        $hastechdocid[$usestk] = linkdocid($x, $row['techdocid']) . $row['techdocid'];
    }
}

$tickimg = '<img src="/intranet/images/big-tick.png" width="24" height="24">';

$sql = "SELECT stock_ref, productiondocid, qadocumentid, servicedocumentid, ifudocid, packingdocid, techdocid
        FROM stocklist_tarriffs
        WHERE productiondocid = ? 
           OR qadocumentid = ? 
           OR servicedocumentid = ? 
           OR ifudocid = ? 
           OR packingdocid = ? 
           OR techdocid = ?";

$stmt = pdoquery($sql, array($docid, $docid, $docid, $docid, $docid, $docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usestk = $row['stock_ref'];

    if ($row['productiondocid'] == $docid) {
        $hasproddoc[$usestk] = $tickimg;
    }
    if ($row['qadocumentid'] == $docid) {
        $hasqadoc[$usestk] = $tickimg;
    }
    if ($row['servicedocumentid'] == $docid) {
        $hasservdoc[$usestk] = $tickimg;
    }
    if ($row['ifudocid'] == $docid) {
        $hasifudocid[$usestk] = $tickimg;
    }
    if ($row['packingdocid'] == $docid) {
        $haspackingdocid[$usestk] = $tickimg;
    }
    if ($row['techdocid'] == $docid) {
        $hastechdocid[$usestk] = $tickimg;
    }
}

// Fetch stock links
$sql = "SELECT id, stock_ref FROM ISO_quality_manual_stock_links WHERE docid = ? ORDER BY stock_ref";
$stmt = pdoquery($sql, array($docid));
$numrows = $stmt->rowCount();

echo '<tr><td>' . $hostid . ' Key:</td>
<td bgcolor="#FF0000">Superseded</td>
<td bgcolor="#dd0000">Discontinued:</td>
<td bgcolor="#dddd00">Unreleased:</td>
<td bgcolor="#ddddd0">RELEASE SCHEDULED:</td></tr>';
echo '<tr><td>&nbsp;</td></tr>';
echo '<tr>
<td>Stock Ref</td><td>Description</td><td>Status</td><td>Remove from Document</td>
<td>QA VMCOP</td><td>Production VMCOP</td><td>Service/Calibration VMCOP</td>
<td>IFU</td><td>Packaging Instruction</td><td>Tech manual</td>
</tr>';

$statuses = array(
    "9919999" => array("Discontinued:", "dd0000"),
    "9919998" => array("Unreleased:", "dddd00"),
    "9919997" => array("RELEASE SCHEDULED:", "ddddd0"),
    "9919996" => array("NON-STOCK BUT AVAILABLE:", "dddd00"),
    "9919995" => array("ONLY FOR SPECIFIC OEM CUSTOMER:", "00dd00"),
);

$ticktypes = array(
    "qa"          => "hasqadoc",
    "prod"        => "hasproddoc",
    "serv"        => "hasservdoc",
    "ifudocid"    => "hasifudocid",
    "packingdocid"=> "haspackingdocid",
    "techdocid"   => "hastechdocid",
);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $usestk = $row['stock_ref'];
    $supper = isset($usesupercode[$usestk]) ? $usesupercode[$usestk] : '';
    
    // Determine message and colour
    if ($supper !== '') {
        $repmsg = 'Superseded: ';
        $msgcolor = '00aacc';
    }
    if (isset($statuses[$supper])) {
        list($repmsg, $msgcolor) = $statuses[$supper];
    }

    echo "<tr bgcolor='#$msgcolor' onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#$msgcolor';\">";
    
    echo "<td>" . linkstkref($x, $usestk, $float, $size, $owncompany) . "$usestk</td>";
    echo "<td>" . (isset($usestkdesc[$usestk]) ? $usestkdesc[$usestk] : '') . "</td>";
    echo "<td>$repmsg $supper</td>";
    
    echo "<td align='center'>
            <a href=\"removestocklink.php$x&docid=$docid&stockid=" . $row['id'] . "\">
            <img src=\"../../images/small_cross.png\" border=0 title=\"Remove Link To $usestk " . $usestkdesc[$usestk] . "\"></a>
          </td>";

    foreach ($ticktypes as $type => $tickArrayName) {
        $tickArray = $$tickArrayName;
        if (isset($tickArray[$usestk]) && $tickArray[$usestk] !== '') {
            echo "<td>{$tickArray[$usestk]}</td>";
        } else {
            echo "<td><a href=\"updatestocklink.php$x&hostcompanyid=$owncompany&stkref=$usestk&type=$type&docid=$docid\" target=\"_Utick\">Link</a></td>";
        }
    }

    echo "</tr>";

    $usestkshown[$usestk] = 1;
    $yesihavesomestocklinks = 1;
}
	


print "</table>"; 
if ($yesihavesomestocklinks==1)
	{
	
$ingrp = array(); // init array to avoid warnings

$sql = "SELECT groupid FROM ISO_quality_manual_user_groups WHERE docid = ?";
$stmt = pdoquery($sql, array($docid));
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $groupid = $row['groupid'];
    $ingrp[$groupid] = 1;
}
	
print "<br><table class=n3 width=100%><tr><td><h3>Limit User Groups to Show on Stock Screens";
print "</h3></td><td>*Shows on All screens unless a Group is Ticked</td></tr>";	
	
$sql = "SELECT id, description FROM user_groups";
$stmt = pdoquery($sql);
$num = $stmt->rowCount();

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $groupid = $row['id'];
    $chk = (isset($ingrp[$groupid]) && $ingrp[$groupid] != '') ? 'CHECKED' : '';

    echo "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
    echo "<td><input type=checkbox onclick=\"updateusergroup('$groupid')\" $chk></td>";
    echo "<td>" . htmlspecialchars($row['description']) . "</td></tr>";
}
	
	
	
	
print "</table>";	
	} 
// NEW LINKING TO Document Types
$typelist = array(); // prevent undefined warnings before include

$sql = "SELECT * FROM ISO_quality_manual_files_types WHERE newtype='1' AND archive='0' GROUP BY type ORDER BY description";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $typeid = $row['id'];
    $typelist[$typeid] = $row['description'];
}
	
$typelinked = array(); // Avoid PHP 5.6 notices

$sql = "SELECT * FROM ISO_quality_manual_files_types_links WHERE docid = ?";
$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $typeid = $row['typeid'];
    $typelinked[$typeid] = "CHECKED";
}

print "<br>";
print "<table class=n2 width=100%><tr><td colspan=5><h3>Document is of File Type</h3></td></tr><tr><td colspan=5 valign=top><div id='typeid' valign=top> &nbsp <sub><a href=\"adminfiletypes.php$x\">Admin Types</a></sub> </div></td></tr>";
$count=0;
foreach ($typelist as $typeid => $description) {
	$typelinked[$typeid] = isset ( $typelinked[$typeid] ) ? $typelinked[$typeid] : '' ;
	print "<td><input type=checkbox id='TYPE$typeid' onclick=\"linktype('$typeid','$docid')\" $typelinked[$typeid]>$description </td>";
	$count++;
	if ($count > 4) {
		$count=0;
		print "</tr><tr>";
	}
}
while ($count <5) {
	print "<td></td>";
	$count++;
}
print "<tr><td colspan=5> &nbsp </td></tr></table>"; 
print "<br><table class=n3 width=100%><tr><td><h3>Training Course Links</h3></td><td></td></tr>";

$sql = "
    SELECT ISO_training_course.coursename AS coursename, ISO_training_course.id AS trainid 
    FROM ISO_training_docs, ISO_training_course 
    WHERE ISO_training_docs.docid = ? 
    AND ISO_training_docs.courseid = ISO_training_course.id 
    GROUP BY ISO_training_course.coursename
";
$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $coursename = htmlspecialchars($row['coursename']); // Safe output
    $trainid = $row['trainid'];

    print "<tr><td>$coursename</td><td align=right>";
    ?>
    <a href="removedocfromtraining.php<?php echo $x; ?>&docid=<?php echo $docid; ?>&trainid=<?php echo $trainid; ?>">
        <img src="../../images/small_cross.png" border=0 title="Remove Link To <?php echo $coursename; ?>">
    </a>
    </td></tr>
    <?php
}

print "</table><br>";
// next section relates to Rolling Audit Issues to this Document
include ("vopdetailsprocesses.php"); 
print "<br>"; 
print "<br><br><h3>VM3COP Procedures Linked to $topdesc</h3>";
print "<table class=n3 width=100%><tr><Td>DOCID</td><td>Title / Description</td></tr>";
print $subproceduresanddocuments ;
print "</table><br><Br><br>";  
if ($d==0)
	{
print "<br><table class=n3 width=100%><tr><td colspan=5><h3>Audits / Tasks relating to</h3></td></tr>"; 
print "<tr><td>Recurring Issue ID</td><td>Subject</td><td>Type</td><td>Assigned to</td><td>Remove</td></tr>";

$sql = "
    SELECT * FROM ISO_quality_manual_files_related_recur_issues
    JOIN viamedagendafuture ON ISO_quality_manual_files_related_recur_issues.recurissueid = viamedagendafuture.id
    WHERE ISO_quality_manual_files_related_recur_issues.docid = ?
";
$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $recurissueid = $row['recurissueid'];
    $subject = htmlspecialchars($row['subject']);
    $type = htmlspecialchars($row['type']);
    $target_user = htmlspecialchars($row['target_user']);

    print "<tr>";
    print "<td>$recurissueid</td><td>$subject</td><td>$type</td><td>$target_user</td><td>";
    ?>
    <a href="removedocfromrecurissue.php<?php echo $x; ?>&docid=<?php echo $docid; ?>&recissueid=<?php echo $recurissueid; ?>">
        <img src="../../images/small_cross.png" border=0 title="Remove Link To Recurring Issue <?php echo $recurissueid; ?>">
    </a>
    </td></tr>
    <?php
}

print "</table><br>";
	} 
// next section relates to documents that reference / relate to another DOC id 
print "<table class=n3 width=100%><tr><td colspan=4><h3>Related / Referenced Documents</h3></td></tr>"; 
print "<tr><td>Doc ID</td><td>Subject</td><td>Last Updated</td><td>Remove</td></tr>";
$sql = "
    SELECT 
        ISO_quality_manual_files.addedon AS addedon,
        ISO_quality_manual_files.docid AS docid,
        ISO_quality_manual_files.description AS description
    FROM 
        ISO_quality_manual_files_referenced_docids
    JOIN 
        ISO_quality_manual_files 
    ON 
        ISO_quality_manual_files_referenced_docids.refdocid = ISO_quality_manual_files.docid
    WHERE 
        ISO_quality_manual_files_referenced_docids.docid = ?
";

$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $linked_docid = $row['docid'];
    $description = htmlspecialchars($row['description']);
    $prndate = date("d M Y", $row['addedon']);

    print "<tr>";
    print "<td>";
    ?>
    <a href="showdoc2admin.php<?php echo $x; ?>&docid=<?php echo $linked_docid; ?>">
        <?php echo $linked_docid; ?>
    </a>
    </td>
    <td><?php echo $description; ?></td>
    <td><?php echo $prndate; ?></td>
    <td>
    <a href="removedocfromreldoc.php<?php echo $x; ?>&docid=<?php echo $docid; ?>&reldocid=<?php echo $linked_docid; ?>">
        <img src="../../images/small_cross.png" border="0" title="Remove Link To Doc <?php echo $linked_docid; ?>">
    </a>
    </td>
    </tr>
    <?php
}
print "</table>";  
// NEXT section ALL Must read settings
?>
<script type="text/javascript"> 
function domustread(docid) {
//document.getElementById("txtHint").innerHTML='happy';
	if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.open("GET","mustreaddoc.php<?php echo $x; ?>&courseid=8&docid="+docid,true);
xmlhttp.send();  
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
//document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
} 
	
	
} 
</script>  
<div id='txtHint'> </div> 
<?php
print "<br><table class=n3 width=100%><tr><td><h3>Users Read <input type=checkbox id='allmustread' $allmustread onclick=\"domustread('$docid'\"> All users MUST read - <a href=\"forceallreread.php$x&docid=$docid\"><input type=button value='Force ReRead'></a> </h3></td><td></td></tr>"; 
$haveshown = array();   // Same here

// Fetch all users
$sql = "SELECT * FROM pw";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $userid = $row['id'];
    $usename[$userid] = ucwords($row['username']);
}

// Fetch document readers
$sql = "SELECT * FROM ISO_quality_manual_user_read WHERE docid = ? ORDER BY last_read DESC";
$stmt = pdoquery($sql, array($docid));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $userid = $row['userid'];
    $userprn = isset($usename[$userid]) ? $usename[$userid] : "Unknown";
    $usedate = date("d/m/y", $row['last_read']);

    // Count if already shown
    if (!isset($haveshown[$userid])) {
        $haveshown[$userid] = 1;
        print "<tr><td>$userprn</td><td>$usedate</td></tr>";
    }
}
#print "</table>";
	
	
	
print "</table><br>"; 
?>
<table class=n3><tr><td colspan=3><b>Link DOCUMENT to:</b></td></tr>
<form name=popupform method='POST' action='walkthru_linksections.php<?php echo $x;?>'>
<input type=hidden name=docid value='<?php print "$docid";?>'>


<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><Td>HSE</td><Td>
	<select name=hselink>
	<option value=''>Link TO HSE Manual</option>
	<?php
$sql = "SELECT * FROM ISO_quality_manual WHERE filter = ?";
$stmt = pdoquery($sql, array('hse'));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $id = $row['id'];
    $header = htmlspecialchars($row['iso_section_header']);
    print "<option value='$id'>$header</option>";
}
	?>
	</select>
	</td><td></td></tr>
<?php 
	 
?>	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><Td valign=top>
	Technical Files</td><td>
	<select name=cefamily>
	<option value=''>Technical Family</option>
	<?php
$sql = "SELECT * FROM ISO_ce_family_index WHERE active = '' ORDER BY family_description";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $id = $row['id'];
    $desc = htmlspecialchars($row['family_description']);
    print "<option value='$id'>$desc</option>";
}
?>
	
	</select><br>
	<select name=cesection>
	<option value=''>Technical File Section</option>
<?php 
if ($lasttechnicallink<>'')
	{
	print "<option value='$lasttechnicallink'>$lasttechnicallinkheader</option>";
	} 
$sql = "SELECT * FROM ISO_ce_headers WHERE ce_header NOT LIKE ? ORDER BY ord, ce_header";
$stmt = pdoquery($sql, array('%do not use%'));

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $id = $row['id'];
    $section = htmlspecialchars($row['ce_section']);
    $header = htmlspecialchars($row['ce_header']);
    print "<option value='$id'>$section $header</option>";
}
?>
	</select></td><td></td>
	</tr>
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td>
	Link to STED Header</td><td><select name=sted><option value=''></option>
	<?php
$sql = "SELECT * FROM ISO_quality_manual_sted_headers ORDER BY description";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $id = $row['id'];
    $desc = htmlspecialchars($row['description']);
    print "<option value='$id'>$desc</option>";
}
	
	?>
	</select>
	</td></tr>
	
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td>
	Link to Training Course</td><td>
	<select name=trainingcourse>
	<option value=''></option>
	<?php
$sql = "SELECT * FROM ISO_training_course ORDER BY coursename";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $id = $row['id'];
    $name = htmlspecialchars($row['coursename']);
    print "<option value='$id'>$name</option>";
}
	?>
	</select>
	
	
	
	</td></tr>
	
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td>Link / Remove Stock</td><td><input type=text name=stocksearch size=32></td><td></td></tr>
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td>Link Stock from Stock Group</td><Td>
	<select name=stockgroup><option value=''></option>
	<?php
$sql = "SELECT * FROM stockgroup GROUP BY groupcode ORDER BY owner, groupcode";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $groupcode = htmlspecialchars($row['groupcode']);
    $owner = htmlspecialchars($row['owner']);
    print "<option value='$groupcode'>$owner $groupcode</option>";
}
	
	?>
	</select>
	</td></tr> 
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td>Link Stock from MID Group</td><Td>
	<select name=midgroup><option value=''></option>
	<?php
	
$middesc = array(); // Prevent notices in PHP 5.6
$midexp = array();

$sql = "SELECT * FROM viamed_mailshot_description";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $midid = $row['id'];
    $middesc[$midid] = $row['subject'];
    $midexp[$midid] = $row['expby'];
}
	
$sql = "
    SELECT * 
    FROM viamed_mailshot_related_products 
    GROUP BY mailshotid 
    ORDER BY mailshotid DESC
";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $midid = $row['mailshotid'];

    if (!isset($midexp[$midid]) || $midexp[$midid] == '') {
        $desc = isset($middesc[$midid]) ? htmlspecialchars($middesc[$midid]) : '';
        print "<option value='$midid'>MID$midid $desc</option>";
    }
}
	
	?>
	</select>
	</td></tr>
	
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td>Add to Document Group</td>
	<td>
	<select name=documentgroup>
	<option value=''></option>
	<?php
$sql = "SELECT * FROM iso_file_groups_names ORDER BY id, group_name";
$stmt = pdoquery($sql);

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
    $groupid = $row['id'];

    if (!isset($activegroup[$groupid]) || $activegroup[$groupid] != 1) {
        $groupname = htmlspecialchars($row['group_name']);
        print "<option value='$groupid'>$groupid $groupname</option>";
    }
}
	print "</select></td></tr>";
	?>
	
	<input type=text name=documentgroup size=32>
	
	</td><td></td></tr>	
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';">
	<td>Add Linked Recuring Issue ID</td><td>
	<input type=text name=recurissue value=''></td></tr> 
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';">
	<td>Referenced / linked to another DOCID</td><td>
	<input type=text name=referenceddocid value=''></td></tr>
	
	<TR bgcolor="#92adc8" onMouseOver="this.bgColor='#d4deea';" onMouseOut="this.bgColor='#92adc8';"><td colsan=2 align=middle>
	<td colspan=2>
	<input type=submit value='Add'></form>
	</td></tr>
	
	</table>
<?php 
} 
print "</td><td valign=top>"; 
if (file_exists($thumbdocname)) {
?>
	<a href="<?php print"$topdocname";?>">
	<img src="<?php print "$thumbdocname";?>"  width=450 >
	</a>
<?php 
}  
print "</td></tr></table>"; 
$sql = "
    SELECT * FROM viamedagendahistory
    WHERE 
        subject LIKE ? OR 
        notes LIKE ? OR 
        notes LIKE ? OR
        notes LIKE ? OR
        docid = ?
    ORDER BY id DESC
";

$params = array(
    "DOCID $docid%",
    "%DOCID$docid%",
    "DOCID $docid%",
    "%Controlled Document ($docid)%",
    $docid
);

$stmt = pdoquery($sql, $params);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

if (count($rows) > 0) {
    print "<h3>Issues relating to this Document</h3><br>";
    print "<table width=75% class=n3><tr><td>Issue</td><Td>Subject</td><td>Notes</td></tr>";

    foreach ($rows as $row) {
        $id = htmlspecialchars($row['id']);
        $subject = htmlspecialchars($row['subject']);
        $notes = htmlspecialchars($row['notes']);

        print "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        print "<td valign=top><a href=\"../agenda/singleissuenew.php$x&iid=$id\" target=\"_issue\">$id</a></td>";
        print "<td valign=top>$subject</td>";
        print "<td valign=top>$notes</td></tr>";
    }

    print "</table>";
}
	  
	
	
$historysearch = "(1=2 " . $historysearch . " )";

$sql = "
    SELECT * FROM viamedagendahistory 
    WHERE $historysearch 
    ORDER BY id DESC
";

$stmt = pdoquery($sql);
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);

if (count($rows) > 0) {
    print "<h3>HISTORY of Issues relating to this Document and its Older Versions</h3><br>";
    print "<table width=75% class=n3><tr><td>Issue</td><Td>Subject</td><td>Notes</td></tr>";

    foreach ($rows as $row) {
        $id = htmlspecialchars($row['id']);
        $subject = htmlspecialchars($row['subject']);
        $notes = htmlspecialchars($row['notes']);

        print "<tr bgcolor=\"#92adc8\" onMouseOver=\"this.bgColor='#d4deea';\" onMouseOut=\"this.bgColor='#92adc8';\">";
        print "<td valign=top><a href=\"../agenda/singleissuenew.php$x&iid=$id\" target=\"_issue\">$id</a></td>";
        print "<td valign=top>$subject</td>";
        print "<td valign=top>$notes</td></tr>";
    }

    print "</table>";
}
		
		 
?> 
	</td></tr>
</table>
<br><Br><Br><br><br>
	</body>
</html>
