<?php
	$db = new etamineDB();
	$dropDown = new DropDownOptions();
	$db = new etamineDB('t155', 'alam@273', '180.92.168.223', 'cvcdata');
	//$db = new etamineDB('etamine', 'etamine', '192.168.1.115', 'cvcdata');
	$listBox = new ListBox();
	$showFile = "validate/isreport.html";
	$ajax = new etamineAjax();
	$ajax->showLoading();
	$ajax->setRequestType("POST");
	$ajax->process();
	
	/** Code for Search Starts here **/
	if (!empty($p_iworkcodeno)) {
		if (!empty($wheredata)) {$wheredata .= " or ";}
		$wheredata .= "(cvcdata.tbladdproject.workcodeno like '%$p_iworkcodeno%')";
	}
	if (!empty($p_inameofwork)) {
		if (!empty($wheredata)) {$wheredata .= " or ";}
		$wheredata .= "(cvcdata.tbladdproject.nameofwork like '%$p_inameofwork%')";
	}
	if (!empty($p_iorganizationname)) {
		if (!empty($wheredata)) {$wheredata .= " or ";}
		$wheredata .= "(cvcdata.tblorganization.organizationname like '%$p_iorganizationname%')";
	}
	if (!empty($wheredata)) {$wheredata .= " and ";}
	$wheredata .= "cvcdata.tbladdproject.isactive = 'Yes'";
	
	if (!empty($wheredata)) {$wheredata = " where $wheredata";}
	/**Searching ends here **/
	
	$sqlQuery="select cvcdata.tbladdproject.projectid,cvcdata.tbladdproject.workcodeno,
				cvcdata.tbladdproject.nameofwork,cvcdata.tblorganization.organizationname
				from  cvcdata.tbladdproject 
				LEFT JOIN cvcdata.tblorganization ON cvcdata.tbladdproject.organizationid=cvcdata.tblorganization.organizationid 
				$wheredata order by cvcdata.tbladdproject.projectid";
	$db->SetShowRowNo("ROWCOUNT");
	$db->SetAltValues("STRIPCOLOR", $cfg["STRIPCOLOR"]);
	$sqlQueryCount = "Select count(*) from cvcdata.tbladdproject  LEFT JOIN cvcdata.tblorganization ON 
					cvcdata.tbladdproject.organizationid=cvcdata.tblorganization.organizationid 
					$wheredata order by cvcdata.tbladdproject.projectid"; 
	include(INCLUDES . "include/common/listdetails.php");			 
	$dbValues1 = $db->DbGetMultipleRecords($sqlQuery,"");
	
	$topValues = array(
			"USERNAME"=>$_SESSION['username'],
			"GROUPID"=>$_SESSION['GROUPID'],
			"ORGANIZATIONID"=>$_SESSION['ORGANIZATIONID'],
			"PROJECTID"=>$_SESSION['PROJECTID'],
			"SKINS"=>$GLOBALS['skins'],
			"ORGANIZATION"=>$dbvalues0rg,
		);
	$topContents = $etamineParser->Parse($topFile,$topValues);	
	$middleValues[] = array(
		"AJAXCONTENT"=>$ajax->getJavaScript(false, true),
		"STARTNO"=>(($currentpage - 1) * $pagelength),
		"GROUPID"=>$_SESSION['GROUPID'],
		"FORMACTION"=>$p_action,
		"MODULE"=>$p_module,
		"PAGECONTENTS"=>$pageContents,
		"JSDIR"=>$GLOBALS['javascript'],
		"SKINS"=>$GLOBALS['skins'],
		"CHKDATA"=>$chkdata,
		"ICONTRACTORNAME"=>$p_icontractorname,
		"DEPARTMENTOPTION"=>$departmentoption,
		
	);
	
	$etamineParser->assign("dbvalues", $dbValues1);
	
	$etamineParser->assign($_SESSION['ACCESSINFO']['Front Validate']);
	$middleContents = $etamineParser->Parse(TEMPLATE . $showFile , $middleValues);
?>
