/*
 * Author       : rebek0404
 * Generated on : 23-Nov-2009 00:08:28
 * Version      : 3.0
 */
application "EBUSINESS"
{
    type = public
    date format = "dd-MMM-yyyy"
    time zone = "America/Cancun"
    section Home
    {
        form  Clientes
        {
            
            must  have  unique  RFC
            (
                type  =  text
                maxchar  =  13
            )

            NOMBRE
            (
                type  =  text
            )

            TELEFONO
            (
                type  =  text
            )

            DIRECCION
            (
                type  =  text
            )

            MAIL
            (
                type  =  text
            )

            must  have  Pa_s
            (
                displayname  =  "País"
                type  =  picklist
                values  =  Pais.Pais
            )

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

        list  Clientes_View
        {
            displayname = "Clientes View"
            show  all  rows  from  Clientes 
            (
                RFC
                NOMBRE
                TELEFONO
                DIRECCION
                MAIL
                Pa_s as "País"
            )
            filters 
            (
                Pa_s
            )
            options
            (
                display rows = 100
            )
        }

        form  Pais
        {
            
            must  have  Pais
            (
                type  =  text
            )

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

        list  Pais_View
        {
            displayname = "Pais View"
            show  all  rows  from  Pais 
            (
                Pais
            )
            options
            (
                display rows = 100
            )
        }

        form  PEDIDOS
        {
            
            must  have  CLIENTE
            (
                type  =  picklist
                values  =  Clientes.NOMBRE
            )

            must  have  RFC
            (
                type  =  text
            )

            must  have  PRODUCTO1
            (
                displayname  =  "PRODUCTO"
                type  =  picklist
                values  =  PRODUCTOS.Nombre_del_producto
            )

            must  have  CANTIDAD
            (
                type  =  text
            )

            actions
            {
                on add
                {
                    Submit
                    (
                        type  =  submit
                        displayname  =  "Submit"
                        on success
                        {
                            sendmail
                            (
                                To       :  "becky_0415@hotmail.com" 
                                From     :  zoho.adminuserid 
                                Subject  :  "confirmación de pedidos" 
                                Message  :  "" 
                            )
                        }
                    )
                    Reset
                    (
                        type  =  reset
                        displayname  =  "Reset"
                    )
                }
                on edit
                {
                    Update
                    (
                        type  =  submit
                        displayname  =  "Update"
                    )
                    Cancel
                    (
                        type  =  cancel
                        displayname  =  "Cancel"
                    )
                }
            }
        }

        list  PEDIDOS_View
        {
            displayname = "PEDIDOS View"
            show  all  rows  from  PEDIDOS 
            (
                CLIENTE
                RFC
                PRODUCTO1 as "PRODUCTO"
                CANTIDAD
            )
            filters 
            (
                CLIENTE
                PRODUCTO1
            )
            options
            (
                display rows = 100
            )
        }

        form  PRODUCTOS
        {
            
            must  have  CLAVE
            (
                type  =  text
            )

            must  have  Nombre_del_producto
            (
                displayname  =  "Nombre del producto"
                type  =  text
            )

            must  have  Descripci_n
            (
                displayname  =  "Descripción"
                type  =  textarea
            )

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

        list  PRODUCTOS_View
        {
            displayname = "PRODUCTOS View"
            show  all  rows  from  PRODUCTOS 
            (
                CLAVE
                Nombre_del_producto as "Nombre del producto"
                Descripci_n as "Descripción"
            )
            options
            (
                display rows = 100
            )
        }

    }

}