Creating a Complex Document - Requisition

  1. Description of DataObject :

    DataObject Name : Requisitions
     
    Table Name : requisition_master
    Group Name : General
    Column Name : requisition_no - Int - Primary Key
    requisition_date - Timestamp
    department - Varchar (20)
    remarks - Varchar (40)
     
    Table Name : requisition_details
    Group Name : General
    Column Name : requisition_no - Int - Primary Key
    item_code - Varchar (20) - Primary Key
    requisition_qty - Double
    remarks - Varchar (40)
     
    Table Name : requirement_schedule
    Group Name : General
    Column Name : requisition_no - Int - Primary Key item_code - Varchar (20) - Primary Key
    required_qty - Doubel - Primary Key
    required_date - TimeStamp - Primary Key
    remarks - Varchar (40)

  2. Steps Involved:

    Step 1:

    Click new button, Enter Requisitions as DataObject Name.

    Step 2:

    Enter requisition_master as table name , set cardinality as OnetoOne Parent as none.

    Step 3:

    Enter General as Group Name

    Step 4:

    From generic tree node In objectrepository tree, drag and drop columns to dataobject tree.

    1. LInt - Enter column name as requisition_no , check the key checkbox , Open Column Property sheet and set value for property summary as yes.
    2. TimeStamp - Enter column name as requisition_date, Open Column Property sheet and set value for property summary as yes.

    Expand generic tree node In objectrepository tree, drag and drop columns to dataobject tree.

    1. varchar - Enter column name as department and width as 20. set property ( summary ) to yes.
    2. varchar - Enter column name as remarks and width as 40. Open Column Property sheet and set value for property summary as yes.

    Step 5:

    Click Add table in the floating toolbar

    Step 6:

    Enter requisition_details as table name ,set cardinality as OnetoMany and parent as requisition_master.

    Step 7:

    Enter General as Group Name

    Step 8:

    Note : Primary key columns in parent table will be copied to the child table. ( requisition_no will be added to requisition_details automatically )

    Select requisition_no , open property sheet and set value for Visible property as false.

    (Note : During Database operation the key column values will be taken from Master table. If the column property visible is true then user has to enter value to save the record. )

    Step 9:

    Select requisition_details , Open Property sheet and set value for property UI to TabbedPane.

    Step 10:

    Expand ItemMaster tree node In objectrepository tree, drag and drop columns to dataobject tree. a. item_code - don't change any data, click Ok button.

    Expand generic tree node In objectrepository tree, drag and drop columns to dataobject tree.

    1. Double - Enter column name as requisition_qty,
    2. varchar - Enter column name as remarks, enter width as 40.

    Step 11 :

    Click Add table in the floating toolbar

    Step 12:

    Enter requirement_schedule as table name , set cardinality as OnetoMany and Parent as requisition_details.

    Step 13:

    Enter General as Group Name

    Step 14:

    Note : Primary key columns in parent table will be copied to the child table. ( requisition_no and item_code will be added to requisition_schedule ). a. Select requisition_no , open property sheet and set value for Visible property as false.

    (Note : During Database operation the key column values will be taken from Master table. )

    Step 15:

    Select requirement_schedule, Open Property sheet and set value for property UI to TabbedPane.

    Step 16:

    Expand generic tree node In objectrepository tree, drag and drop columns to dataobject tree.

    1. Double - Enter column name as required_qty,
    2. TimeStamp - Enter column name as required_date.
    3. varchar - Enter column name as remarks, enter width as 40.

    Step 17:

    Click save button, check Table , Sql , checkbox along with defaults and Click Ok button.

    Step 18:

    Click Create button to create tables in Database.

    Model Created Successfully.

    Step 19:

    Click FormFactory button in the ToolBar

    Step 20:

    Increase the Internal frame height ( Requisition Master )

    Step 21:

    Click objecttree button in toolbar or statusbar.

    Step 22:

    Select requisition_details and Click ShowObject button in Objecttree toolbar to design the table.

    Step 23:

    Click Swing Preview button in the Object Tree toolbar.

    Step 24:

    Close the Swing Preview and click HTML preview in object Tree toolbar.

    Step 25:

    Click Save button in the ToolBar.

    Step 26 :

    Click Compile button to compile the created class file.

    Step 27 :

    Execute the RRequisitions.bat file in \AppleseTutor\Src folder to Run the Class file.

    Check List :

    1. Requisitions.xml - XML
    2. Requisitions.dml - DML
    3. Requisitions.dml - Summary
    4. Requisitions.sql - Sql
    5. Requisitions_index.htm - HTML
    6. Requisitions_ns.htm - HTML
    7. Requisitions_ie.htm - HTML
    8. Adjusment_masteradjustment_no.htm - HTML
    9. RequisitionsEvent.xml - Event
    10. RequisitionsSchemaEvent.xml - Event
    11. RequisitionsEvent.java - Event
    12. SchemaRequisitions.java - Src
    13. Requisitions.class - Src
    14. SchemaRequisitions.class - Src
    15. cRequisitions.bat - Src
    16. rRequisitions.bat - Src