/*
 * Author       : eduardolorea
 * Generated on : 23-Nov-2009 01:59:10
 * Version      : 3.0
 */
application "Zero Hora - Correction database"
{
    type = public
    date format = "dd/MM/yyyy"
    time zone = "America/Los_Angeles"
    section Form_translated_sample
    {
        displayname = "Form [translated sample]"
        form  Zero_Hora_Registro_de_corre_es
        {
            displayname  =  "Form [translated sample]"
            success message  =  "Success! Thanks."
            
            plain
            (
                type  =  plaintext
                value = "This is a sample form. You are able to fill it and to submit the information. You can see your&nbsp; submitted information by clicking in \"Records [translated sample]\". There are also two sample entries based in actual records.<br>\n"
            )

            must  have  Dataerro
            (
                displayname  =  "Error date"
                type  =  date
            )

            must  have  Pagina
            (
                displayname  =  "Error page"
                type  =  number
                width  =  20
                maxchar  =  2
            )

            must  have  Local
            (
                displayname  =  "Location"
                type  =  radiobuttons
                values  =  {"Section",   "Suplement",   "Column",   "Other sections"}
                on user input
                {
                    //You can drag and drop tasks from the immediate left pane
                    //Below is the SAMPLE script for dynamic, condition based field manipulation
                    enable Local2;
                    if (input.Local  ==  "Section")
                    {
                        Local2:ui.add("Selecione the section");
                        Local2:ui.add("Central do Interior");
                        Local2:ui.add("Economia");
                        Local2:ui.add("Esportes");
                        Local2:ui.add("Geral");
                        Local2:ui.add("Geral - Polícia");
                        Local2:ui.add("Mundo");
                        Local2:ui.add("Opinião");
                        Local2:ui.add("Política");
                        Local2:ui.add("Segundo Caderno");
                    }
                    if (input.Local  ==  "Column")
                    {
                        Local2:ui.add("Selecione the column");
                        Local2:ui.add("Brasília");
                        Local2:ui.add("Donna - Celia Ribeiro");
                        Local2:ui.add("Donna - Moacyr Scliar");
                        Local2:ui.add("Economia - ZH Digital - Tecnologia na cabeça");
                        Local2:ui.add("Economia - ZH Digital - Tecnologia da informação");
                        Local2:ui.add("Esportes - Bola Dividida");
                        Local2:ui.add("Esportes - David Coimbra");
                        Local2:ui.add("Esportes - Falcão");
                        Local2:ui.add("Esportes - Ruy Carlos Ostermann");
                        Local2:ui.add("Esportes - Wianey Carlet");
                        Local2:ui.add("Economia - Informe Econômico");
                        Local2:ui.add("Paulo Sant'Ana");
                        Local2:ui.add("Política - Página 10");
                        Local2:ui.add("Segundo Caderno - Contracapa");
                        Local2:ui.add("Segundo Caderno - RSVIP");
                    }
                    if (input.Local  ==  "Suplement")
                    {
                        Local2:ui.add("Selecione the suplement");
                        Local2:ui.add("Economia - Campo e Lavoura");
                        Local2:ui.add("Economia - Casa&Cia");
                        Local2:ui.add("Economia - Empregos");
                        Local2:ui.add("Economia - Gestão");
                        Local2:ui.add("Economia - Globaltech");
                        Local2:ui.add("Economia - Imóveis");
                        Local2:ui.add("Economia - Informática");
                        Local2:ui.add("Economia - Produtos & Serviços");
                        Local2:ui.add("Economia - Sobre Rodas");
                        Local2:ui.add("Economia - Veículos");
                        Local2:ui.add("Economia - ZH Digital");
                        Local2:ui.add("Esportes - Caderno de Esportes");
                        Local2:ui.add("Geral - Ambiente");
                        Local2:ui.add("Geral - Mascotes");
                        Local2:ui.add("Geral - Vestibular");
                        Local2:ui.add("Geral - Viagem");
                        Local2:ui.add("Geral - Vida");
                        Local2:ui.add("Geral - ZH Bela Vista");
                        Local2:ui.add("Geral - ZH Bom Fim");
                        Local2:ui.add("Geral - ZH Centro");
                        Local2:ui.add("Geral - ZH Lindóia");
                        Local2:ui.add("Geral - ZH Menino Deus");
                        Local2:ui.add("Geral - ZH Moinhos");
                        Local2:ui.add("Geral - ZH Petrópolis");
                        Local2:ui.add("Geral - ZH Zona Sul");
                        Local2:ui.add("Segundo Caderno - Cultura");
                        Local2:ui.add("Segundo Caderno - Donna");
                        Local2:ui.add("Segundo Caderno - Gastronomia");
                        Local2:ui.add("Segundo Caderno - Meu Filho");
                        Local2:ui.add(("Segundo Caderno - TV+Show"));
                    }
                    if (input.Local  ==  "Other sections")
                    {
                        Local2:ui.add("Select other sections");
                        Local2:ui.add("Almanaque Gaúcho");
                        Local2:ui.add("Arte");
                        Local2:ui.add("Atendimento ao Leitor - Debates");
                        Local2:ui.add("Atendimento ao Leitor - Palavra do Leitor");
                        Local2:ui.add("Atendimento ao Leitor - RS Quer Saber");
                        Local2:ui.add("Atendimento ao Leitor - Sobre ZH");
                        Local2:ui.add("Capa");
                        Local2:ui.add("Contracapa");
                        Local2:ui.add("Central do Interior - Pelo Rio Grande");
                        Local2:ui.add("Economia - Seção Campo & Lavoura");
                        Local2:ui.add("Geral - Obituário");
                        Local2:ui.add("Há 30 Anos em ZH");
                        Local2:ui.add("Informe Especial");
                        Local2:ui.add("Kzuka");
                        Local2:ui.add("Opinião - Opinião ZH");
                        Local2:ui.add("Opinião - Artigo");
                        Local2:ui.add("Opinião - Editorial");
                        Local2:ui.add("Opinião - Sentenças");
                        Local2:ui.add("RBS TV");
                    }
                }
            )

            must  have  Local2
            (
                displayname  =  "Location"
                type  =  picklist
                values  =  {"Select",   "Geral - ZH Moinhos",   "Geral - ZH Lindóia",   "Informe Econômico",   "Economia",   "Política",   "Brasília",   "Página 10",   "Geral",   "Segundo Caderno",   "Economia - Empregos",   "Central do Interior - Pelo Rio Grande",   "Esportes",   "Capa",   "Celia Ribeiro",   "Esportes - Caderno de Esportes",   "Economia - Campo e Lavoura",   "Donna - Celia Ribeiro",   "Economia - Informe Econômico",   "Política - Página 10",   "Geral - Vestibular",   "Almanaque Gaúcho",   "Geral - Polícia",   "Selecione a coluna",   "Economia - ZH Digital - Tecnologia da informação",   "Central do Interior"}
                defaultvalue  =  "Select"
                sortorder  =  ascending
            )

            must  have  Datacorrecao
            (
                displayname  =  "Correction date"
                type  =  date
            )

            must  have  TextoCorrecao
            (
                displayname  =  "Texto of the correction"
                type  =  textarea
            )

            must  have  Genese
            (
                displayname  =  "How did error occur? Please be specific."
                type  =  textarea
            )

            must  have  Percebido
            (
                displayname  =  "How did the error come to our attention?"
                type  =  textarea
            )

            must  have  Prevencao
            (
                displayname  =  "How could this error have been avoided?"
                type  =  textarea
            )

            Comentario
            (
                displayname  =  "Other comments"
                type  =  textarea
            )

            must  have  Nome
            (
                displayname  =  "Name of staff member filing this form"
                type  =  text
            )

            Tipo
            (
                displayname  =  "Error type"
                type  =  picklist
                values  =  {"Identification - Name - Spelling",   "Identification - Name - Other",   "Identification - Position or profession",   "Identification - Age",   "Identification - Geography",   "Identification - Political Party",   "Number - million, billion, thousand, hundred",   "Number - Monetary value",   "Number - Others",   "Information - Date",   "Informação - Grafia",   "Information - Phrase",   "Information - Geography",   "Information - Recipe",   "Information - Others",   "Service - Date",   "Service - Adress",   "Service - Guides",   "Service - Outhers",   "Photo - Credits",   "Photo - Wrong photo",   "Photo - Identification",   "Editing",   "External - Source",   "External - Outher media from RBS Group",   "External - Agencies"}
            )

            actions
            {
                on add
                {
                    on load
                    {
                        disable Local2;
                        hide Tipo;
                    }
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    on load
                    {
                        show Tipo;
                    }
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

    }

    section Records_translated_sample
    {
        displayname = "Records [translated sample]"
        list  Records_translated_sample
        {
            displayname = "Records [translated sample]"
            show  all  rows  from  Zero_Hora_Registro_de_corre_es 
            (
                Tipo as "Error type"
                Dataerro as "Error date"
                Pagina as "P."
                Datacorrecao as "Corr. Date"
                TextoCorrecao as "Text"
                Genese as "How did it ocurr"
                Percebido as "Perception"
                Prevencao as "Prevention"
                Comentario as "Comments"
                Local as "Local."
                Local2 as "Local. 2"
                Nome as "Filled by"
            )
            filters 
            (
                Datacorrecao
                Tipo
            )
            options
            (
                display rows = 100
            )
        }

    }

}
