Пример #1
0
         //echo $query . "<BR>";
         $sql->send_query($query);
     }
     header("Location:manage_samples.php?experiment_id={$experiment_id}\n\n");
     die("");
 }
 if ($delete_experiment_jobs) {
     $query = "DELETE FROM processing_jobs WHERE experiment_id = {$experiment_id} AND sample_id=0 AND region_id = 0";
     $sql->send_query($query);
     header("Location: manage_samples.php?experiment_id={$experiment_id}\n\n");
     die("");
 }
 $experiment = new ns_experiment($experiment_id, '', $sql, false);
 #if ($hide_censored)die("HIDE");
 # else die("NO HIDE");
 $experiment->get_sample_information($sql, !$hide_censored);
 /**************************
    Sort Samples, putting censored samples at back of list.
   *************************/
 $uncensored = array();
 $censored = array();
 for ($i = 0; $i < sizeof($experiment->samples); $i++) {
     if ($experiment->samples[$i]->censored) {
         array_push($censored, $experiment->samples[$i]);
     } else {
         array_push($uncensored, $experiment->samples[$i]);
     }
 }
 for ($i = 0; $i < sizeof($uncensored); $i++) {
     $experiment->samples[$i] = $uncensored[$i];
 }
Пример #2
0
             }
         }
         $query = "UPDATE sample_region_image_info SET censored = " . ($was_censored ? "1" : "0") . ", details='" . $value['details'] . "', strain='" . $value['strain'] . "',reason_censored='{$censored_reason}', strain_condition_1=  '" . $value['condition_1'] . "', strain_condition_2='" . $value['condition_2'] . "' WHERE id=" . $key;
         //  echo $query . "<br>";
         $sql->send_query($query);
     }
     $query = "UNLOCK TABLES";
     $sql->send_query($query);
     //   $refresh_page = TRUE;
 }
 //die('');
 if ($refresh_page === TRUE) {
     header("Location: experiment_overview.php?experiment_id={$experiment_id}&start_position={$start_position}&count={$count}\n\n");
     die("");
 }
 $experiment->get_sample_information($sql);
 $regions = array();
 $sample_list = '';
 $query = "SELECT v from constants WHERE k='mask_time={$experiment_id}'";
 $sql->get_row($query, $res);
 $mask_time = 0;
 if (sizeof($res) > 0) {
     $mask_time = $res[0][0];
 }
 //die($mask_time);
 for ($i = $start_position; $i < $start_position + $count && $i < sizeof($experiment->samples); $i++) {
     $sample_list .= $experiment->samples[$i]->id() . "o";
     $query = "SELECT id,name,details,censored,reason_censored,strain,{$video_column}, time_at_which_animals_had_zero_age, time_of_last_valid_sample,strain_condition_1,strain_condition_2 FROM sample_region_image_info WHERE sample_id = " . $experiment->samples[$i]->id() . " ORDER BY name";
     $region_info_data_column_size = 11;
     $reg =& $regions[$experiment->samples[$i]->id()];
     $sql->get_row($query, $reg);