<?php
	class etamineDocManager {
		var $ErrorInfo = "";
		var $FileExt = array(
			"doc"=>"doc.gif","mdb"=>"mdb.gif","pdf"=>"pdf.gif","ppj"=>"ppj.gif","ppt"=>"ppt.gif","psd"=>"psd.gif","pub"=>"pub.gif","txt"=>"txt.gif","vxd"=>"vxd.gif","xls"=>"xls.gif","zip"=>"zip.gif",
		);
		
		function UpdateDoc($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("tblcsirprodtimg",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("tblcsirprodtimg",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}
		
 		function UpdateEmailDoc($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("tblemailfile",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" .  $newFileName;
			
			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
		//	print_r('test');
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("tblemailfile",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateCWGDoc($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("tblcwgfile",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("tblcwgfile",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}
		
		function UpdateCommentsDoc($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
		
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("tblcommnetsfile",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" .  $newFileName;
			//print_r($newFileLocation);
			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("tblcommnetsfile",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}
		function UpdateDocProj($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("tblprojectfiles",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];
			// Encrypted File Copied to local file system Starts
			$DecptLocat = DecryptLoc;
			$encryptfile = $fieldValues['encyfilename'];
                        $source = "http://172.16.1.186:81/ResourceValues/TFGRV-Encrypted/$encryptfile";
			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;
			$DecptFileLocation = $filefolder . "/". $DecptLocat . "/" . $primaryKey . "_" .  $newFileName;
	//		print_r ($newFileLocation);
		//	if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
		//		$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
		//	}
		
               		if (!copy($source, $newFileLocation)) {
                                $this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
                        }
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				unlink($source);
				$retValue = $db->DbUpdateQuery("tblprojectfiles",array("filename"=>$newFileName,"filelocation"=>$newFileLocation,"decptloc"=>$DecptFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateDocCitizen($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("etaminev2.tblcitizenfile",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;
			
			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("etaminev2.tblcitizenfile",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//print_r($newFileLocation);
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['citizenfilename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateDocCitizen1($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("etaminev2.tblcitizenfile1",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("etaminev2.tblcitizenfile1",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename1']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateDocCitizen4($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("etaminev2.tblcitizenfile4",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("etaminev2.tblcitizenfile4",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['apidocument']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateDoctest($fieldValues, $primaryKey=0) {
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			//print_r($filefolder);
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("etaminev2.tbltest",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				//unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("etaminev2.tbltest",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				//unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateNgoAttachment($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("etaminev2.tblngoattach1",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("etaminev2.tblngoattach1",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateDocCvc($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("tblfile",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) {
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("tblfile",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['filename']);//by sithes 10.08.09-11.52pm
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}

		function UpdateDocPassport($fieldValues, $primaryKey=0) {
		
			$db = new etamineDB();
			if ($primaryKey == 0) {
				$db->AddNew();
				$fieldValues['createdon'] = TODAY;
				$fieldValues['createdby'] = $_SESSION['userid'];
			}
			$filefolder = $fieldValues['filefolder'];
			unset($fieldValues['filefolder']);
			$fieldValues['modifiedon'] = TODAY;
			$fieldValues['modifiedby'] = $_SESSION['userid'];
			
			$returnValue = $db->DbUpdateQuery("etaminev2.tblfilepassport",$fieldValues,"fileid='" . $primaryKey . "'");
			if ($primaryKey == 0) {$primaryKey = $returnValue;}
			$newFileName = $fieldValues['filename'];

			$newFileLocation = $filefolder . "/" . $primaryKey . "_" .  $newFileName;

			if (!copy(USERFILES . "tmp/" . $fieldValues['filelocation'], $newFileLocation)) { 
				$this->ErrorInfo = "Failed to copy $file - " . $fieldValues['filename'];
			}
			if (! $this->ErrorInfo) {
				unlink(USERFILES . "tmp/" . $fieldValues['filelocation']);
				$retValue = $db->DbUpdateQuery("etaminev2.tblfilepassport",array("filename"=>$newFileName,"filelocation"=>$newFileLocation),"fileid='" . $primaryKey . "'");
				//$_SESSION['filename'] = "";//by sithes 10.08.09-11.52pm
				unset($_SESSION['passportfile']);//by sithes 10.08.09-11.52pm
				unset($_SESSION['pancardfile']);
				unset($_SESSION['rationfile']);
				unset($_SESSION['voterfile']);
				unset($_SESSION['dlfile']);
				unset($_SESSION['photoidfile']);
				unset($_SESSION['nregsfile']);
				unset($_SESSION['edufile']);
				unset($_SESSION['armsfile']);
				unset($_SESSION['atmfile']);
				unset($_SESSION['creditfile']);
				unset($_SESSION['pensionfile']);
				unset($_SESSION['freedomfile']);
				unset($_SESSION['kissanfile']);
				unset($_SESSION['cghsfile']);
				unset($_SESSION['postsfile']);
				unset($_SESSION['bankfile']);
				unset($_SESSION['groupafile']);
				unset($_SESSION['pofile']);
				unset($_SESSION['electricityfile']);
				unset($_SESSION['waterbillfile']);
				unset($_SESSION['telephonefile']);
				unset($_SESSION['propertyfile']);
				unset($_SESSION['ccfile']);
				unset($_SESSION['insurancefile']);
				unset($_SESSION['banklhfile']);
				unset($_SESSION['companylhfile']);
				unset($_SESSION['edulhfile']);
				unset($_SESSION['incomefile']);
				unset($_SESSION['vehiclefile']);
				unset($_SESSION['leasefile']);
				unset($_SESSION['castefile']);
				unset($_SESSION['birthfile']);
				unset($_SESSION['sslcfile']);
				unset($_SESSION['lhfile']);
			}
			if (empty($this->ErrorInfo)) {return $returnValue;}
		}
				
		function GetExtImage($filename) {
			$extImage = "default.gif";
			$fileArray = split(".",$filename);
			$ext = strolower(trim($fileArray[count($fileArray)-1]));
			if ($FileExt['ext']) {$extImage = $FileExt['ext'];}
			return $extImage;
		}
		
		//For security reasons it is better to pass the userid
		function OpenFile($primaryKey, $userid=0) {
			$db = new etamineDB();
				
			if ($userid != 0) {$wheredata = " and userid = '$userid'";}
			$sqlQuery = "select filename, filelocation from etaminev2.tblfile where fileid='" . $primaryKey . "' " . $wheredata;
			$fileRecord = $db->DbGetRecord($sqlQuery);
			
			$filename = USERFILES . $fileRecord['FILELOCATION'];
			$handle = fopen ($filename, "rb");
			$contents = fread ($handle, filesize ($filename));
			fclose ($handle);
		
			header('Expires: 0');
			header('Content-Type: ' . $mime_type);
			header('Content-Disposition: attachment; filename="' . $fileRecord['FILENAME'] . '"');
			header('Expires: 0');
			header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
			header('Pragma: public');
			echo $contents;
			exit;
		}

		function deleteFile($fileid) {
			$db = new etamineDB();
			$filelocation = $db->DbGetField("select filelocation from  etaminev2.tblfile where fileid = '".$fileid."'");		
			unlink($filelocation);
			$qry="delete from tblfile where fileid ='".$fileid."'";
			$db->DbExecute($qry);
			header('Location:?module=dataentry');
		}

		/*function OpenFile($personalid, $clientid, $whichfile, $userid=0) {

			$db = new etamineDB();
				
			if ($userid != 0) {$wheredata = " and userid = '$userid'";}

			if($whichfile == "com"){
				$sqlQuery = "select comfilename, comfiletype, comfilesize, comfilecontent from tblfile where personalid ='" . $personalid . "' and  clientid ='" . $clientid . "'" . $wheredata;
				
				$fileRecord = $db->DbGetRecord($sqlQuery);

				header('Content-length: $fileRecord["COMFILESIZE"]');
				header('Content-type: $fileRecord["COMFILETYPE"]');
				header('Content-Disposition: attachment; filename="' . $fileRecord['COMFILENAME'] . '"');
				header('Expires: 0');
				header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
				header('Pragma: public');
				echo $fileRecord['COMFILECONTENT'];
			}
			elseif($whichfile == "sum"){
				$sqlQuery = "select sumfilename, sumfiletype, sumfilesize, sumfilecontent from tblfile where personalid ='" . $personalid . "' and  clientid ='" . $clientid . "'" . $wheredata;
				

				$fileRecord = $db->DbGetRecord($sqlQuery);

				header('Content-length: $fileRecord["SUMFILESIZE"]');
				header('Content-type: $fileRecord["SUMFILETYPE"]');
				header('Content-Disposition: attachment; filename="' . $fileRecord['SUMFILENAME'] . '"');
				header('Expires: 0');
				header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
				header('Pragma: public');
				echo $fileRecord['SUMFILECONTENT'];
			}
			elseif($whichfile == "img"){
				$sqlQuery = "select imgfilename, imgfiletype, imgfilesize, imgfilecontent from tblfile where personalid ='" . $personalid . "' and  clientid ='" . $clientid . "'" . $wheredata;

				$fileRecord = $db->DbGetRecord($sqlQuery);

				header('Content-length: '.$fileRecord['IMGFILESIZE']);
				header("Content-type: ".$fileRecord['IMGFILETYPE']);
				header('Content-Disposition: attachment; filename="' . $fileRecord['IMGFILENAME'] . '"');
				header('Expires: 0');
				header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
				header('Pragma: public');
				echo $fileRecord['IMGFILECONTENT'];
			}
			elseif($whichfile == "oth"){
				$sqlQuery = "select othfilename, othfiletype, othfilesize, othfilecontent from tblfile where personalid ='" . $personalid . "' and  clientid ='" . $clientid . "'" . $wheredata;
				$fileRecord = $db->DbGetRecord($sqlQuery);

				header('Content-length: '.$fileRecord['OTHFILESIZE']);
				header("Content-type: ".$fileRecord['OTHFILETYPE']);
				header('Content-Disposition: attachment; filename="' . $fileRecord['OTHFILENAME'] . '"');
				header('Expires: 0');
				header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
				header('Pragma: public');
				echo $fileRecord['OTHFILECONTENT'];
			}

			
			
			/*$filename = USERFILES . $fileRecord['FILELOCATION'];
			$handle = fopen ($filename, "rb");
			$contents = fread ($handle, filesize ($filename));
			fclose ($handle);*/
			

		
			/*header('Expires: 0');
			header('Content-Type: ' . $mime_type);
			header('Content-Disposition: attachment; filename="' . $fileRecord['FILENAME'] . '"');
			header('Expires: 0');
			header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
			header('Pragma: public');
			echo $contents;*/
		/*	exit;
		}*/
	}
?>
