/*
 * Author       : ekehadiran
 * Generated on : 23-Nov-2009 01:44:59
 * Version      : 3.0
 */
application "e-Kehadiran Sekolah"
{
    type = public
    date format = "dd-MMM-yyyy"
    time zone = "America/Los_Angeles"
    section Home
    {
        form  e_Kehadiran
        {
            displayname  =  "e-Kehadiran"
            
            column
            {
                plain
                (
                    type  =  plaintext
                    value = "Assalamu a'laikum wrth. &amp; Salam Mahabbah.<br /><br />TUAN PENGETUA ATAU GURU BESAR<br />SEKOLAH-SEKOLAH DAERAH MERSING<br /><br />Sila lengkapkan borang ini dan klik butang <span style=\"font-weight: bold;\">HANTAR</span> seperti berikut :<br /><span style=\"font-weight: bold;\">Sesi Pagi : Sebelum jam 10.00 pagi</span><br style=\"font-weight: bold;\" /><span style=\"font-weight: bold;\">Sesi Petang : Sebelum jam 3.00 petang</span><br /><br />Kerjasama tuan/puan amat dihargai. Terima kasih.\n"
                )

                Tarikh
                (
                    type  =  datetime
                )

                Nama_Sekolah
                (
                    displayname  =  "Nama Sekolah"
                    type  =  picklist
                    values  =  {"SK BANDAR MERSING",   "SK LKTP NITAR 1",   "SK (FELDA) TENGGAROH 2",   "SK SERI PANTAI",   "SK SAWAH DATO'",   "SK TENGLU",   "SK AIR PAPAN",   "SK TERIANG",   "SK LEMBAGA ENDAU",   "SK TANJUNG RESANG",   "SK BANDAR ENDAU",   "SK (FELDA) TENGGAROH 4",   "SK (FELDA) TENGGAROH 6",   "SK PUSAT AIR TAWAR",   "SK TELOK LIPAT",   "SK PULAU AUR",   "SK PULAU PEMANGGIL",   "SK PULAU SIBU",   "SK PULAU TINGGI",   "SK (FELDA) TENGGAROH 1",   "SK PENYABONG",   "SK (LKTP) NITAR 2",   "SK (FELDA) TENGGAROH 5",   "SK (FELDA) TENGGAROH 3",   "SK MERSING KANAN",   "SK (FELDA) TENGGAROH 7",   "SK TANAH ABANG",   "SK PETA",   "SK LABUNG",   "SK KEM ISKANDAR",   "SK SRI MERSING",   "SJK(C) CHIAO CHING",   "SJK(C) KG HUBONG",   "SJK(C) JEMALUANG",   "SJK(C) PAI CHEE",   "SJK(T) MERSING",   "SMK (FELDA) TENGGAROH",   "SMK MERSING",   "SMK NITAR",   "SMK TAN SRI ABDUL KADIR",   "SMK ANJUNG BATU",   "SMK SRI MERSING",   "SMK PAI CHEE (CF)",   "SMK UNGKU HUSIN",   "SM SAINS SULTAN ISKANDAR"}
                )

                Sesi
                (
                    type  =  picklist
                    values  =  {"Pagi",   "Petang"}
                )

                Nama_Pelapor
                (
                    displayname  =  "Nama Pelapor"
                    type  =  text
                )

                Jawatan
                (
                    type  =  text
                )

                BIL_KES_GURU
                (
                    displayname  =  "Bil.Kes.Guru"
                    type  =  number
                    width  =  20
                )

                Bil_Guru_TH
                (
                    displayname  =  "Bil.Guru TH"
                    type  =  number
                    width  =  20
                )

                Nama_Guru_TH_Kenyataan
                (
                    displayname  =  "Nama Guru TH & Kenyataan"
                    type  =  textarea
                )

            }
            column
            {
                Bil_Kes_K_Tangan_Sokongan
                (
                    displayname  =  "Bil.Kes.K/Tangan Sokongan"
                    type  =  number
                    width  =  20
                )

                Bil_K_tgn_TH
                (
                    displayname  =  "Bil.K/Tgn TH"
                    type  =  number
                    width  =  20
                )

                Bil_K_Tgn_TH1
                (
                    displayname  =  "Bil.K/Tgn TH"
                    type  =  number
                    width  =  20
                )

                Nama_K_Tgn_TH_Kenyataan
                (
                    displayname  =  "Nama K/Tgn TH & Kenyataan"
                    type  =  textarea
                )

                Bil_Kes_Murid_Lelaki
                (
                    displayname  =  "Bil.Kes.Murid Lelaki"
                    type  =  number
                    width  =  20
                )

                Bil_Murid_Lelaki_TH
                (
                    displayname  =  "Bil.Murid Lelaki TH"
                    type  =  number
                    width  =  20
                )

                Bil_Kes_Murid_Perempuan
                (
                    displayname  =  "Bil.Kes.Murid Perempuan"
                    type  =  number
                    width  =  20
                )

                Bil_Murid_Perempuan_TH
                (
                    displayname  =  "Bil.Murid Perempuan TH"
                    type  =  number
                    width  =  20
                )

                Kenyataan_TH
                (
                    displayname  =  "Kenyataan TH"
                    type  =  textarea
                )

                Aduan
                (
                    type  =  textarea
                )

                Muat_Naik_Lampiran
                (
                    displayname  =  "Muat Naik Lampiran"
                    type = upload file
                )

            }
            actions
            {
                on add
                {
                    submit
                    (
                        type  =  submit
                        displayname  =  "HANTAR"
                    )
                    reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  e_Kehadiran_View
        {
            displayname = "e-Kehadiran View"
            show  all  rows  from  e_Kehadiran 
            (
                Tarikh
                Nama_Sekolah as "Nama Sekolah"
                Sesi
                Nama_Pelapor as "Nama Pelapor"
                Jawatan
                BIL_KES_GURU as "BIL.KES.GURU"
                Bil_Guru_TH as "Bil.Guru TH"
                Nama_Guru_TH_Kenyataan as "Nama Guru TH & Kenyataan"
                Bil_Kes_K_Tangan_Sokongan as "Bil.Kes.K/Tangan Sokongan"
                Bil_K_tgn_TH as "Bil.K/tgn TH"
                Bil_K_Tgn_TH1 as "Bil.K/Tgn TH"
                Nama_K_Tgn_TH_Kenyataan as "Nama K/Tgn TH & Kenyataan"
                Bil_Kes_Murid_Lelaki as "Bil.Kes.Murid Lelaki"
                Bil_Murid_Lelaki_TH as "Bil.Murid Lelaki TH"
                Bil_Kes_Murid_Perempuan as "Bil.Kes.Murid Perempuan"
                Bil_Murid_Perempuan_TH as "Bil.Murid Perempuan TH"
                Kenyataan_TH as "Kenyataan TH"
                Aduan
                Muat_Naik_Lampiran as "Muat Naik Lampiran"
            )
            filters 
            (
                Nama_Sekolah
                Sesi
            )
            options
            (
                display rows = 100
            )
        }

    }

    customize
    {
        layout = "tab"
        base theme = "gradient"
        color = "blue"
    }
}