<?
/**
 * Change Log:
 * 	Jul 14, 2023	Harman Singh	Migrated from PHP 5.3 to PHP 8.1
 */
#Transition: PHP 4.3 to PHP 5.16 to target PHP 5.3
#Testing environment: 	PHP 5.1.6
#Methods changed: 		Modified getAll function
#Methods Tested: 		getAll & getById(4126830)
#Testing Performed: 	Using pm3/test/TraceWithsStatsManager_test.php
#DAO called: 			TraceWithStatsDao
#DB directly called:  	NO
#Transition closed
class TraceWithStatsManager {
	function TraceWithStatsManager() {}

	/********************Modified By Lily********************************/
	//function getAll() {
	/* updated the parameters with $limit and $offset on Dec 20, 2010 */
	function getAll($offset=false,$limit=false) {
		$traceDao= new TraceWithStatsDao();
		//$result=$traceDao->searchAll();
		$result=$traceDao->searchAll($limit,$offset);
		while ($row=$pg_fetch_assoc($result)) {
			$trace=new TraceWithStats($row["id"]);
			$trace->setPCr($row["fk_pcr"]);
			$trace->setPrimer($row["fk_primer_seq"]);
			$trace->setRunsite($row["fk_site"]);
			$trace->setDirection($row["direction"]);
			$trace->setTracefile($row["trace_file"]);
			$trace->setPhredfile($row["phred_file"]);
			$trace->setTracename($row["tracename"]);
			$trace->setFormat($row["format"]);
			$trace->setSeqdate($row["seqdate"]);
			$trace->setStatus($row["status"]);
			$trace->setNotes($row["note"]);
			$trace->setUpdated($row["last_updated"]);
			$trace->setTamUri($row["tam_uri"]);
			$trace->setBases($row["bases"]);
			$trace->setMin($row["min"]);
			$trace->setMax($row["max"]);
			$trace->setMean($row["mean"]);
			$trace->setVar($row["var"]);
			$trace->setStdev($row["stdev"]);
			$trace->setSterr($row["sterr"]);
			$trace->setBin10($row["bin_10"]);
			$trace->setBin12($row["bin_12"]);
			$trace->setBin14($row["bin_14"]);
			$trace->setBin16($row["bin_16"]);
			$trace->setBin18($row["bin_18"]);
			$trace->setBin20($row["bin_20"]);
			$trace->setBin22($row["bin_22"]);
			$trace->setBin24($row["bin_24"]);
			$trace->setBin26($row["bin_26"]);
			$trace->setBin28($row["bin_28"]);
			$trace->setBin30($row["bin_30"]);
			$trace->setBin32($row["bin_32"]);
			$trace->setBin34($row["bin_34"]);
			$tracelist[]=$trace;
		}
		return $tracelist;
	}
	/*******************************************************/
	function getById($id) {

		$traceDao= new TraceWithStatsDao();
		$result=$traceDao->searchById($id);
		while ($row=$pg_fetch_assoc($result)) {
			$trace=new TraceWithStats($row["id"]);
			$trace->setPCr($row["fk_pcr"]);
			$trace->setPrimer($row["fk_primer_seq"]);
			$trace->setRunsite($row["fk_site"]);
			$trace->setDirection($row["direction"]);
			$trace->setTracefile($row["trace_file"]);
			$trace->setPhredfile($row["phred_file"]);
			$trace->setTracename($row["tracename"]);
			$trace->setFormat($row["format"]);
			$trace->setSeqdate($row["seqdate"]);
			$trace->setStatus($row["status"]);
			$trace->setNotes($row["note"]);
			$trace->setUpdated($row["last_updated"]);
			$trace->setTamUri($row["tam_uri"]);
			$trace->setBases($row["bases"]);
			$trace->setMin($row["min"]);
			$trace->setMax($row["max"]);
			$trace->setMean($row["mean"]);
			$trace->setVar($row["var"]);
			$trace->setStdev($row["stdev"]);
			$trace->setSterr($row["sterr"]);
			$trace->setBin10($row["bin_10"]);
			$trace->setBin12($row["bin_12"]);
			$trace->setBin14($row["bin_14"]);
			$trace->setBin16($row["bin_16"]);
			$trace->setBin18($row["bin_18"]);
			$trace->setBin20($row["bin_20"]);
			$trace->setBin22($row["bin_22"]);
			$trace->setBin24($row["bin_24"]);
			$trace->setBin26($row["bin_26"]);
			$trace->setBin28($row["bin_28"]);
			$trace->setBin30($row["bin_30"]);
			$trace->setBin32($row["bin_32"]);
			$trace->setBin34($row["bin_34"]);

		}
		return $trace;
	}


	function getByPcr($pcr) {
		$traceDao= new TraceWithStatsDao();
		$result=$traceDao->searchbyPcr($pcr);
		$tracelist = NULL;

		while ($row=$pg_fetch_assoc($result)) {
			$trace=new TraceWithStats($row["id"]);
			$trace->setPCr($row["fk_pcr"]);
			$trace->setPrimer($row["fk_primer_seq"]);
			$trace->setRunsite($row["fk_site"]);
			$trace->setDirection($row["direction"]);
			$trace->setTracefile($row["trace_file"]);
			$trace->setPhredfile($row["phred_file"]);
			$trace->setTracename($row["tracename"]);
			$trace->setFormat($row["format"]);
			$trace->setSeqdate($row["seqdate"]);
			$trace->setStatus($row["status"]);
			$trace->setNotes($row["note"]);
			$trace->setUpdated($row["last_updated"]);
			$trace->setTamUri($row["tam_uri"]);
			$trace->setBases($row["bases"]);
			$trace->setMin($row["min"]);
			$trace->setMax($row["max"]);
			$trace->setMean($row["mean"]);
			$trace->setVar($row["var"]);
			$trace->setStdev($row["stdev"]);
			$trace->setSterr($row["sterr"]);
			$trace->setBin10($row["bin_10"]);
			$trace->setBin12($row["bin_12"]);
			$trace->setBin14($row["bin_14"]);
			$trace->setBin16($row["bin_16"]);
			$trace->setBin18($row["bin_18"]);
			$trace->setBin20($row["bin_20"]);
			$trace->setBin22($row["bin_22"]);
			$trace->setBin24($row["bin_24"]);
			$trace->setBin26($row["bin_26"]);
			$trace->setBin28($row["bin_28"]);
			$trace->setBin30($row["bin_30"]);
			$trace->setBin32($row["bin_32"]);
			$trace->setBin34($row["bin_34"]);
			$tracelist[]=$trace;
		}
		return $tracelist;
	}

	function getByTracefile($tracefile) {
		$traceDao= new TraceWithStatsDao();
		$result=$traceDao->searchbyTraceFile($tracefile);
		if ($row=$pg_fetch_assoc($result)) {
			$trace=new TraceWithStats($row["id"]);
			$trace->setPcr($row["fk_pcr"]);
			$trace->setPrimer($row["fk_primer_seq"]);
			$trace->setRunsite($row["fk_site"]);
			$trace->setDirection($row["direction"]);
			$trace->setTracefile($row["trace_file"]);
			$trace->setPhredfile($row["phred_file"]);
			$trace->setTracename($row["tracename"]);
			$trace->setFormat($row["format"]);
			$trace->setSeqdate($row["seqdate"]);
			$trace->setStatus($row["status"]);
			$trace->setNotes($row["note"]);
			$trace->setUpdated($row["last_updated"]);
			$trace->setTamUri($row["tam_uri"]);
			$trace->setBases($row["bases"]);
			$trace->setMin($row["min"]);
			$trace->setMax($row["max"]);
			$trace->setMean($row["mean"]);
			$trace->setVar($row["var"]);
			$trace->setStdev($row["stdev"]);
			$trace->setSterr($row["sterr"]);
			$trace->setBin10($row["bin_10"]);
			$trace->setBin12($row["bin_12"]);
			$trace->setBin14($row["bin_14"]);
			$trace->setBin16($row["bin_16"]);
			$trace->setBin18($row["bin_18"]);
			$trace->setBin20($row["bin_20"]);
			$trace->setBin22($row["bin_22"]);
			$trace->setBin24($row["bin_24"]);
			$trace->setBin26($row["bin_26"]);
			$trace->setBin28($row["bin_28"]);
			$trace->setBin30($row["bin_30"]);
			$trace->setBin32($row["bin_32"]);
			$trace->setBin34($row["bin_34"]);
		}
		return $trace;
	}



}
?>