table#tab1 th {padding-top:3px;padding-bottom:3px; text-align:center;color:#000; background-color:#fff;font-size:1.1em;} //td { background-color:#FFDAB9;font-size:1.0em;} table#tab1 td { background-color:#fff;font-size:1.0em;} "; $text .= "

Show Sites with Lab status

NULL Do_Not_Submit_To_Crawler Submit_To_Crawler Submitted_To_Crawler Crawler_Failed Referred_Delayed Crawler_Completed_Safe Crawler_Completed_But_Did_Not_Find_Samples Under_Processing_By_Analyst Analyst_Completed_Safe

Show

"; return $text; } function labs_manage_set(){ global $db_conn; $text = " "; return $text; } function labs_manage($stat){ global $db_conn; if($stat !='NULL'){ $sql = "SELECT \"SiteId\",\"SiteURL\",\"LabVerdictDesc\" from \"WhiteListing\".\"Sites\" left join \"WhiteListing\".\"LabVerdicts\" on(\"LabStatus\" =\"LabVerdictId\") where \"VerdictId\" =3 and \"LabStatus\" =$stat order by \"DateAdded\""; } else{ $sql = "SELECT \"SiteId\", \"SiteURL\",\"LabVerdictDesc\" from \"WhiteListing\".\"Sites\" left join \"WhiteListing\".\"LabVerdicts\" on(\"LabStatus\" =\"LabVerdictId\") where \"VerdictId\" =3 and \"LabStatus\" isnull order by \"DateAdded\""; } $lab_res = odbc_exec($db_conn,$sql); $i = 1; $text = "

#	select	Site name	Carrent Lab State

New lab state

NULL Do_Not_Submit_To_Crawler Submit_To_Crawler Submitted_To_Crawler Crawler_Failed Referred_Delayed Crawler_Completed_Safe Crawler_Completed_But_Did_Not_Find_Samples Under_Processing_By_Analyst Analyst_Completed_Safe

change

"; if(odbc_num_rows($lab_res)>0){ while(odbc_fetch_row($lab_res)){ $text .= ""; // $text .= "

#	select	Site name	Carrent Lab State
$i		".odbc_result($lab_res,"SiteURL")."	"; if(is_null(odbc_result($lab_res,"LabVerdictDesc"))){$text .= "NULL";} else{$text .= odbc_result($lab_res,"LabVerdictDesc");} $text .= "	Change verdict

"; $text .= " "; $text .= ""; $i++; } $text .= ""; } return $text; } ?>