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(); }