User:Gibcus/common.js

Note: After publishing, you may have to bypass your browser's cache to see the changes.

• Firefox / Safari: Hold Shift while clicking Reload, or press either Ctrl-F5 or Ctrl-R (⌘-R on a Mac)
• Google Chrome: Press Ctrl-Shift-R (⌘-Shift-R on a Mac)
• Edge: Hold Ctrl while clicking Refresh, or press Ctrl-F5.

#FORM 541715
#NEW PROJECT SETUP

FORMNAME:
    AA (QC)

#FORM SPECIFIC
NEW PROJECT:
    #<==test==> only one of [ILAB::QC_std_types] should be filled. else [WARN:"Mutliple services selected in Illumina QC"]
    EXCEPTION_UNIQUE:
        ILAB::QC_std_types:
            True
        #ILAB::RNA_std_types:
        #    True
        ILAB::DNA_std_types:
            True
        ALL:
            True
    ATTRIBUTES:
        DNA_Project::Date_submission:
            ILAB::TODAY_DATE
        DNA_Project::userName:
            ILAB::Kerberose
        DNA_Project::userName_CC:
            ILAB::ccEmail
        DNA_Project::iLAB_UID:
            ILAB::ILAB_UID
        DNA_Project::Service:
            BioA_AA
        DNA_Project::ReferTo:
            ILAB::referTo
        DNA_Project::EnteredBy:
            ILAB
        #DNA_Project::LastModified:
        #    ILAB::TODAY_DATE
        DNA_Project::SampleType:
            ILAB::Sample_Type:
                DNA:
                    ILAB::DNA_Assay:
                        IlluminaQC:
                            ShortReadLibrary
                        genomic (>8kb):
                            gDNA
                        DEFAULT:
                            DNA
                RNA:
                    RNA
        DNA_Project::QC_Assay:
            ILAB::Sample_Type:
                DNA:
                    ILAB::DNA_Assay
                RNA:
                    ILAB::RNA_Assay
        DNA_Project::iLABemail:
            ILAB::Kerberose
        DNA_Project::Subservice_BioA_AA:
            OPERATOR:
                ADDITION_STRING
            VALUE:
                ILAB::Sample_Type:
                    DNA:
                        ILAB::DNA_Assay:
                            IlluminaQC:
                                ILAB::QC_std_types:
                                    261739:
                                        FA+qPCR
                                    288673:
                                        SYBR+qPCR
                                    261738:
                                        qPCR only
                                    455504:
                                        qPCR preload plate
                            DEFAULT:
                                ILAB::DNA_std_types:
                                    261734:
                                        FA
                                    261735:
                                        FA preload
                                    261736:
                                        BioA_hsDNA
                                    334243:
                                        FP
                                    348097:
                                        FP preload
                    RNA:
                        ILAB::RNA_std_types:
                            261734:
                                FA nano
                            261735:
                                FA nano preload
                            261736:
                                BioA nano
                            334243:
                                FP RNA
                            348097:
                                FP RNA preload
                            551777:
                                FF Scroll for QC
                            551778:
                                FFPE Scroll for QC
                        
        DNA_Project::NoSamples:
            #<==test==> only one of [ILAB::QC_std_types] should be filled. else [WARN:"Mutliple services selected in Illumina QC"]
            #EXCEPTION_UNIQUE:
            #    ILAB::QC_std_types:
            #        True
            #    ILAB::DNA_std_types:
            #        True
            OPERATOR:
                ADDITION_INT
            VALUE:
                ILAB::Sample_Type:
                    DNA:
                        ILAB::QC_std_types: 
                            261739:
                                261739
                            288673:
                                288673
                            261738:
                                261738
                            455504:
                                455504
                        ILAB::DNA_std_types:
                            261734:
                                261734
                            261735:
                                261735
                            261736:
                                261736
                            334243:
                                334243
                            348097:
                                348097
                    RNA:
                        ILAB::RNA_std_types:
                            261734:
                                261734
                            261735:
                                261735
                            261736:
                                261736
                            334243:
                                334243
                            348097:
                                348097
                            551777:
                                551777
                            551778:
                                551778
NEW REQUIREMENT:
    EXCEPTION_NOTNULL:
        ILAB::Project_Notes
    ATTRIBUTES:
        Requirements::Project:
            TBD
        Requirements::Text:
            ILAB::Project_Notes
        Requirements::Category:
            "ilabNote"
        Requirements::Date:
            ILAB::TODAY_DATE
        Requirements::Author:
            ILAB
                

#<==test==> if numROWS in [ILAB::Sample_table] != DNA_Project::NoSample
#    [DIE:"Mismatch in number of samples and number of services"]
#foreach ROW in [ILAB::Sample_table]
NEW DNA_db:
    TABLE:
        ILAB::Sample_table
    EXCEPTION_MATCH:
        #DNA_Project::NoSample
        # Only if [FORM:Sample_Type] == DNA
        ILAB::Sample_Type:
            DNA
    ATTRIBUTES:
        #DNA_db::DNAserial:
        #    <autogenerated>
        DNA_db::projectID:
            <project ID>
        DNA_db::sampleName:
            ROW::Name
        DNA_db::sampleVol:
            ROW::Volume(ul)
        DNA_db::concUser:
            ROW::Conc (ng/ul)
        DNA_db::sampleNotes:
            ROW::SampleNotes
        DNA_db::Genome:
            ILAB::Species
        DNA_db::sampleDate:
            ILAB::TODAY_DATE
        
# Only if [FORM:Sample_Type] == RNA
NEW RNA_samples:
    TABLE:
        ILAB::Sample_table
    EXCEPTION_MATCH:
        #DNA_Project::NoSample
        # Only if [FORM:Sample_Type] == RNA
        ILAB::Sample_Type:
            RNA
    ATTRIBUTES:
        #RNA_samples::RNAserial:
        #    <autogenerated>
        RNA_samples::ProjectID:
            <project ID>
        RNA_samples::SampleName:
            ROW::Name
        RNA_samples::Volume:
            ROW::Volume(ul)
        RNA_samples::concUser:
            ROW::Conc (ng/ul)
        RNA_samples::SampleNotes:
            ROW::SampleNotes
        RNA_samples::Genome:
            ILAB::Species
        RNA_samples::sampleDate:
            ILAB::TODAY_DATE