Sidebar
An Excel Client EASAP stub
- Right-click USER INTERFACE→TABBED PANE LIST→tabbed_pane1
- Select Child→Add CASE VIEWER
- Right-click case_viewer1
- Select Sibling→Add LAYOUT PANEL
- Rename it layout_panel_buttons
- Set→Layout: HORIZONTAL
- Right-click layout_panel_buttons
- Select Child→Add BUTTON, four times
- Rename the first one button_new
- Set→Label: New Case
- Rename the second one button_open
- Set→Label: Modify Selected Case
- Rename the third one button_delete
- Set→Label: Delete Selected Case
- Rename the fourth one button_exit
- Set→Label: Exit
- Right-click button_new
- Select Child→Add DATABASE TO EXCEL DESKTOP
- Set → Action: New
- Right-click database_to_excel_desktop1
- Select Sibling→Add REFRESH OBJECTS
- Rename it refresh_case_viewer
- Set→Objects: case_viewer1
- Right-click button_open
- Select Child→Add DATABASE TO EXCEL DESKTOP
- Set:
- Action: Open
- Case Id: %case_viewer1%
- (case_viewer1 takes value of a User selected 'case id')
- Set: USER INTERFACE→Results Time: 1
- Set: USER INTERFACE→TABBED PANE LIST→tabbed_pane1→case_viewer1→Refresh on Save: TRUE
- Right-click button_open
- Select Sibling→Add BUTTON
- Rename it button_delete
- Set→Label: Delete Selected Loan
- Right-click button_delete
- Select Child→Add SET CASE STATUS
- For it set:
- Status: Deleted
- (this is actually mapped to the string DELETED)
- Case Id: %case_viewer1%
- Right-click tabbed_pane1→layout_panel_buttons→button_new→refresh_case_viewer1
- Select Copy
- Right-click button_delete→set_case_status1
- Select Paste (Sibling)
- (This will update case_viewer1 in the EASAP GUI just as with button_new)
- Right-click case_viewer1
- Select Child→Add FILTER
- Rename it filter_not_deleted
- Set:
- Value: DELETED
- Static Operator: NOT_EQUAL
- Case Data to Compare: status
Finally we want an exit button so a User may confidently close the EASAP.
- Right-click button_delete
- Select Sibling→Add BUTTON
- Rename it button_exit
- Set→Label: Exit
- Right-click button_exit
- Select Child→Add MENU ACTION
- Rename it menu_action_exit
- Select menu_action_exit
- Set→Action:Exit
- (Equivalent to a User clicking the grey X in an EASAP)
- Right-click USER INTERFACE
- Select Child→Add USER INTERFACE STYLE LIST
- Right-click USER INTERFACE STYLE LIST
- Select Child→Add USER INTERFACE STYLES
- Right-click USER INTERFACE STYLES
- Select Child→Add USER INTERFACE STYLE
- Rename it button_style1
- Right-click button_style1
- Select Child→Add TEXT STYLE
- Set:
- Font Size:12
- Weight: bold
- Right-click TEXT STYLE
- Select Sibling→Add MARGIN
- Set:
- Top: 5px
- Right: 5px
- Bottom: 5px
- Left: 5px
- Right-click MARGIN
- Select Sibling→Add PADDING
- Set:
- Right: 5px
- Left: 5px
- For each of the following buttons:
- button_new
- button_open
- button_delete
- button_exit
- Set→ Style: button_style1
- Right-click USER INTERFACE→USER INTERFACE STYLE LIST→USER INTERFACE STYLES→button_style1
- Select Sibling→Add USER INTERFACE STYLE
- Rename it label_style1
- Right-click label_style1
- Select Child→Add TEXT STYLE
- Set:
- Font Size:10
- Weight: bold
- Alignment: right
- Right-click TEXT STYLE
- Select Sibling→Add PADDING
- Set:
- Right: 5px
- Left: 5px
- Right-click tabbed_pane1
- Select Child→Add SUB PANE
- Rename it sub_pane_filters
- Set→Layout: HORIZONTAL
- Right-click sub_pane_filters
- Select Child→Add INPUTBOX
- Rename it Status
- Set:
- Label: Status:
- Label Style: label_style1
- Right-click Status
- Select Child→Add DATA VALIDATION
- Set:
- Allow:List
- Ignore Blank:FALSE
- Source: ,NEW, IN_PROGRESS, FINISHED
- (note the intial comma, we allow a blank option which accepts all status possibilities)
- Right-click Status
- Select Copy
- Right-click Status
- Select Paste (Sibling)
- Rename it Term
- Set→Label: Term:
- Set: Term→DATA VALIDATION→Source: ,15,20,25,30
- (note the intial comma, we allow a blank option which accepts all term possibilities)
Via a FILTER each INPUTBOX will generate a SQL query that will narrow the results set displayed in our CASE VIEWER.
- Right-click case_viewer1→filter_not_deleted
- Select Child→Add FILTER
- Rename it filter_status
- Set:
- Value:%Status%
- Static Operator: EQUAL
- Case Data to Compare: status
- Right-click filter_status
- Select Copy then Paste (Sibling)
- Rename it filter_term
- Set:
- Value: %Term%
- Excel Value To Compare: term
- Right-click sub_pane_filters
- Select Sibling→Add EVENT PROCESSING
- Rename it event_processing_filters
- Expand it with the plus box
- Right-click event1
- Select Child→Add VALUE CHANGED
- Rename it value_changed_filters
- Set→ Objects: Status, Term
- Right-click tabbed_pane1→layout_panel_buttons→database_to_excel_desktop1→refresh_case_viewer
- Select Copy
- Right-click action_group1
- Select Paste (Child)
- Set case_viewer1→Height: 200
- (in a real application this number should be slightly less than the vertical display height in pixels)
CASE VIEWER→Count: gives us the size of the results set.
Declare a new SCALAR, total_cases, in Count: then display this number in a LABEL to show the current results set length.
- Select case_viewer1
- Set→Count: total_cases
- Right-click event_processing_filters
- Select Sibling→Add LABEL
- Set:
- Label: Number of Loans: %total_cases%
- Style: label_style1
- Right-click USER INTERFACE→tabbed_pane1
- Select Child→Add DATA PROCESSING
- Expand it
- Right-click SCALAR
- Select Child→Add EXPAND
- Rename it Selected_loan
- Set:
- Value: %case_viewer1%
- Value On Error: 0
- Select USER INTERFACE→tabbed_pane1→layout_panel_buttons→button_open
- Set→ Enable If: Selected_loan>0
- Select USER INTERFACE→tabbed_pane1→layout_panel_buttons→button_delete
- Set→ Enable If: Selected_loan>0
- Click the Tree tab
- Select EASAP→PROPERTIES→APPLICATION
- Set→Selection Image: mort_calc.jpg
- Right-click EASAP→SPREADSHEET LIST
- Select Child→Add SPREADSHEET
- Set:
- File: MortgageCalculatorEDC.xls
- Desktop: TRUE