/Prohits/analyst/index.php
PHP | 256 lines | 234 code | 5 blank | 17 comment | 22 complexity | 2537b935d872c957d79fa443058ee9f0 MD5 | raw file
- <?
- /***********************************************************************
- Copyright 2010 Gingras and Tyers labs,
- Samuel Lunenfeld Research Institute, Mount Sinai Hospital.
- Licensed under the Apache License, Version 2.0 (the "License");
- you may not use this file except in compliance with the License.
- You may obtain a copy of the License at
- http://www.apache.org/licenses/LICENSE-2.0
- Unless required by applicable law or agreed to in writing, software
- distributed under the License is distributed on an "AS IS" BASIS,
- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
- See the License for the specific language governing permissions and
- limitations under the License.
- *************************************************************************/
- $frm_Projects = '';
- $project_Name = '';
- $proj_changed = 0;
- $frm_show = '';
- require("../common/site_permission.inc.php");
- require("site_header.php");
- ?>
- <SCRIPT language=JavaScript>
- <!--
- function Is_ProjectSelected(theForm){
- selObj = theForm.frm_Projects;
- for (i=0; i < selObj.options.length; i++) {
- if (selObj.options[i].selected){
- return true;
- }
- }
- alert("Please select a project.");
- return false;
- }
- function projectSeleced(theForm){
- theForm.frm_show.value = "Y";
- theForm.submit();
- }
- -->
- </SCRIPT>
- <br>
- <?
- if(!$proj_changed){
- if($frm_Projects and !$frm_show){
- if(!isset($_SESSION["workingProjectID"]) || $_SESSION["workingProjectID"] != $frm_Projects){
- $current_Project = new Projects($frm_Projects);
- $_SESSION["workingProjectID"] = $current_Project->ID;
- $_SESSION["workingProjectName"] = $current_Project->Name;
- $_SESSION["workingProjectTaxID"] = $current_Project->TaxID;
- $_SESSION["workingFilterSetID"] = $current_Project->FilterSetID;
- $_SESSION["workingDBname"] = $HITS_DB[$current_Project->DBname];
- //$HITSDB->change_db($HITS_DB[$current_Project->DBname]);
- if($current_Project->Frequency){
- $_SESSION["workingProjectFrequency"] = $current_Project->Frequency;
- }else{
- $_SESSION["workingProjectFrequency"] = 0;
- }
- $SQL = "SELECT ID FROM User WHERE Type='MSTech' OR (Type!='user' AND LabID='".$current_Project->LabID."') ORDER BY Type";
- $UserArr = $mainDB->fetchAll($SQL);
- $superUsersArr = array();
- for($i=0; $i<count($UserArr); $i++){
- array_push($superUsersArr, $UserArr[$i]['ID']);
- }
- if(in_array($AccessUserID, $superUsersArr)){
- $_SESSION["superUsers"] = 1;
- }else{
- $_SESSION["superUsers"] = 0;
- }
- }
- echo "<script language=javascript>document.location.href='./index.php?proj_changed=1';</script>";
- exit;
- }else{
- ?>
- <table border="0" cellpadding="0" cellspacing="0" width="95%">
- <tr>
- <td align="left">
- <font color="<?=$TB_HD_COLOR;?>" face="helvetica,arial,futura" size="3"><b>Select Project
- </b>
- </font>
- </td>
- <td align="right">
-
- </td>
- </tr>
- <tr>
- <td colspan=2 height=1 bgcolor="black"><img src="./images/pixel.gif"></td>
- </tr>
- <tr>
- <td align="center" colspan=2><br>
-
- <form name="select_user" method=post action=<?=$_SERVER['PHP_SELF'];?>>
- <input type=hidden name=theaction value="selected">
- <input type=hidden name=frm_show value="">
- <table border="0" cellpadding="0" cellspacing="1" width="650">
-
- <tr bgcolor="<?=$TB_HD_COLOR;?>">
- <td colspan="2" align="center" height=25>
- <font color="white" face="helvetica,arial,futura" size="3"><b>High-throughput Projects</b></font>
- </td>
- </tr>
- <tr>
- <td bgcolor="<?=$TB_CELL_COLOR;?>" valign=top align=center width=50% nowrap> <br>
- <?
- $Projects = new Projects();
- $Projects->getAccessProjects($_SESSION["USER"]->ID);
- if($frm_show){
- $AccessProjectID = $frm_Projects;
- }
- ?>
- <select name="frm_Projects" id="mySelect" size=25 onChange="projectSeleced(this.form)">
- <?
- if($Projects->count == 1){
- echo "<option value='".$Projects->ID[0]."'";
- echo " selected";
- echo ">".$Projects->Name[0]."\n";
- }else if($Projects->count){
- for ($i= 0;$i < $Projects->count; $i++) {
- echo "<option value='".$Projects->ID[$i]."'";
- echo ($Projects->ID[$i]==$AccessProjectID)?" selected":"";
- echo ">"."(".$Projects->ID[$i].") ".$Projects->Name[$i]."\n";
- }
- }
- ?>
- </select> <br>
- <input type=hidden name="project_Name" value="">
- </td>
- <td bgcolor="<?=$TB_CELL_COLOR;?>" valign=top align=center>
- <table border="0" cellpadding="0" cellspacing="1" width=80% >
- <tr>
- <td valign=top align=center><div class=maintext><br>
- Select the project to analyze.
- </div>
- </td>
- </tr>
- <tr valign=bottom>
- <td valign=bottom><br>
- <input type="submit" value="Select" Onclick="return Is_ProjectSelected(this.form);" class=green_but>
- <input type="reset" value="Reset" class=green_but>
- <div class=maintext>
- <br><br>
- <?
- if($AccessProjectID){
- $db = new mysqlDB();
- $SQL = "select P.ID,
- P.Name,
- P.TaxID,
- P.Description,
- L.Name as LabName,
- P.Frequency,
- A.Insert,
- A.Modify,
- A.Delete
- from Projects P, Lab L, ProPermission A where P.LabID=L.ID and A.ProjectID=P.ID and A.UserID=$AccessUserID
- and P.ID='$AccessProjectID'";
- $record = $db->fetch($SQL);
- if(count($record) > 0){
- echo " Lab Name: <b>". $record['LabName']."</b><br>";
- echo " Frequency filter : <b>". $record['Frequency']."%</b><br>";
- echo " Description : <b>". $record['Description']."</b><br>";
- echo " Species: ";
- $SQL = "select Name from ProteinSpecies where TaxID='". $record['TaxID'] . "'";
- $recordTaxID = $db->fetch($SQL);
- if(count($recordTaxID) > 0){
- echo "<b>" . $recordTaxID['Name'] . "</b>";
- }
- $Space = "
- ";
-
- echo "<br> Permissions: ";
- echo "<b>Read</b><br>".$Space;
- if($record['Insert']){
- echo "<b>Insert</b><br>".$Space;
- }
- if($record['Modify']){
- echo "<b>Modify</b><br>".$Space;
- }
- if($record['Delete']){
- echo "<b>Delete</b><br>";
- }
- }
- }
- ?>
- </div>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </form>
- </td>
- </tr>
- </table>
- <?
- }
- }else{
- $_SESSION['com_BaitIDs'] = '';
- $_SESSION['com_SampleIDs'] = '';
- $_SESSION['com_ExperimentIDs'] = '';
- ?>
- <table border="0" cellpadding="0" cellspacing="0" width="95%">
- <tr>
- <td align="left">
- <font color="<?=$bg_tb_header;?>" face="helvetica,arial,futura" size="3"><b>Database Information
- <?
- if($AccessProjectName){
- echo " <font color='red' face='helvetica,arial,futura' size='3'>(Project $AccessProjectID: $AccessProjectName)</font>";
- }
- ?>
- </b>
- </font>
- </td>
- </tr>
- <tr>
- <td height=1 bgcolor="black"><img src="./images/pixel.gif"></td>
- </tr>
- <tr>
- <td align="" colspan=1 >
- <br><div class=large>
- <b>Database structure</b></div>
- <table border=0 width=450 align=center>
- <tr>
- <td>
- <IMG SRC="./images/data_structure.png" >
- </td>
- </tr>
- <tr>
- <td><div class=maintext><b>Icons</b></div></td>
- </tr>
- <tr>
- <td><div class=maintext>
- Modify -- Click <img src='./images/icon_view.gif'> to modify a record.<br>
- Delete -- Click <img src='./images/icon_purge.gif'> to delete a record. You can only delete your own records.<br>
- Next Level -- Click <img src='./images/icon_tree.gif'> to go to next level of a record.<br>
- Picture -- Click <img src='./images/icon_picture.gif'> to have a pop-up window to show up and display a gel image.<br>
- Plate -- Click <img src='./images/icon_plate.gif'> to view the current plate.<br>
- Next -- Click <img src='./images/arrow_small.gif'> to go to next step when submitting samples.<br>
- Co-IP -- Co-IP results: Yes <img src='./images/icon_coip_green.gif'>
- No<img src='./images/icon_coip_red.gif'>
- Possible<img src='./images/icon_coip_yellow.gif'>
- In Progress<img src='./images/icon_coip_blue.gif'>
- </div>
- </td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- <?
- }
- require("site_footer.php");
- ?>