Ejemplo n.º 1
0
     print '</FORM>' . "\n\n" . '<SCRIPT>' . "\n" . '  if ($(\'#phenotypeCreate option\').size() == 2) { $(\'#phenotypeCreate select\')[0].selectedIndex = 1; $(\'#phenotypeCreate\').submit(); }' . "\n" . '</SCRIPT>' . "\n\n";
     $_T->printFooter();
     exit;
 }
 if (count($_POST) > 2) {
     lovd_errorClean();
     $_DATA->checkFields($_POST);
     if (!lovd_error()) {
         // Fields to be used.
         $aFields = array_merge(array('diseaseid', 'individualid', 'owned_by', 'statusid', 'created_by', 'created_date'), $_DATA->buildFields());
         // Prepare values.
         $_POST['owned_by'] = $_AUTH['level'] >= LEVEL_CURATOR ? $_POST['owned_by'] : $_AUTH['id'];
         $_POST['statusid'] = $_AUTH['level'] >= LEVEL_CURATOR ? $_POST['statusid'] : STATUS_IN_PROGRESS;
         $_POST['created_by'] = $_AUTH['id'];
         $_POST['created_date'] = date('Y-m-d H:i:s');
         $nID = $_DATA->insertEntry($_POST, $aFields);
         // Get genes which are modified only when phenotype, individual and variant are marked or public.
         if ($_POST['statusid'] >= STATUS_MARKED) {
             $aGenes = $_DB->query('SELECT DISTINCT t.geneid FROM ' . TABLE_TRANSCRIPTS . ' AS t ' . 'INNER JOIN ' . TABLE_VARIANTS_ON_TRANSCRIPTS . ' AS vot ON (vot.transcriptid = t.id) ' . 'INNER JOIN ' . TABLE_VARIANTS . ' AS vog ON (vog.id = vot.id) ' . 'INNER JOIN ' . TABLE_SCR2VAR . ' AS s2v ON (s2v.variantid = vog.id) ' . 'INNER JOIN ' . TABLE_SCREENINGS . ' AS s ON (s.id = s2v.screeningid) ' . 'INNER JOIN ' . TABLE_INDIVIDUALS . ' AS i ON (i.id = s.individualid) ' . 'INNER JOIN ' . TABLE_PHENOTYPES . ' AS p ON (p.individualid = i.id) ' . 'WHERE vog.statusid >= ? AND i.statusid >= ? AND p.id = ?', array(STATUS_MARKED, STATUS_MARKED, $nID))->fetchAllColumn();
             if ($aGenes) {
                 // Change updated date for genes.
                 lovd_setUpdatedDate($aGenes);
             }
         }
         // Write to log...
         lovd_writeLog('Event', LOG_EVENT, 'Created phenotype information entry ' . $nID . ' for individual ' . $_POST['individualid'] . ' related to disease ' . $_POST['diseaseid']);
         if ($bSubmit) {
             // Full submission, continue to rest of questions.
             if (!isset($_AUTH['saved_work']['submissions']['individual'][$_POST['individualid']]['phenotypes'])) {
                 $_AUTH['saved_work']['submissions']['individual'][$_POST['individualid']]['phenotypes'] = array();
             }