2

Size: px

Start display at page:

Download "2"

たつやみのしま
5 years ago
Views:

1 1

2 2

3 3

4 4

5 5

6 6

7 7

8 8

9 tbody tr div [_im_enclosure] div [_im_repeater] span [_im_enclosure] span [_im_repeater] ol li ul li select option 9

10 10

11 <table> <td <td array( name => postalcode ) table: postalcode pcode address

12 <table> <td <td array( name => postalcode ) table: postalcode pcode address

13 <table> <td </td> <td </td> Repeater Nodes <td <td table: postalcode array( name => postalcode ) pcode address

14 <table> <td </td> <td </td> <td </td> <td </td> Repeater Nodes array( name => postalcode ) table: postalcode pcode address

15 array( name=>place key=>id ), array( name=>postalcode relation=> array( foreign-key=>place_id, join-field=>id ),), table: place id city table: postalcode place_id pcode address

16 <table> <td <td> <table> <td <td </td> id table: place city table: postalcode place_id pcode address

17 <table> <td <td> <table> <td <td </td> 17

18 <table> <td </td> <td> <table> <td <td </td> id table: place city table: postalcode Repeater Nodes place_id pcode address

19 <table> <td </td> Repeater Nodes 1 <td> <table> </td> Repeater Nodes 2 <td class="im[postalcode@pcode]"></td> <td class="im[postalcode@town]"></td> table: place id city table: postalcode place_id pcode address

20 <table> <td </td> <td> <table> </td> postalcode id table: place city id=901 <td <td table: postalcode Repeater Nodes 1 Repeater Nodes 2 array( name=>postalcode relation=> array( join-field=>id, foreign-key=>place_id ),), place_id pcode address

21 <table> <td </td> <td> <table> </td> id <td </td> <td </td> table: place city table: postalcode Repeater Nodes 1 Repeater Nodes 2 <td class="im[postalcode@pcode]"></td> <td class="im[postalcode@town]"></td> place_id pcode address

22 <table> <td </td> <td> <table> <td </td> <td </td> </td> <td </td> <td </td> id table: place city table: postalcode Repeater Nodes 1 Repeater Nodes 2 place_id pcode address

23 <td </td> <td </td> </td> <td </td> <td> <table> <td </td> <td </td> </td> id table: place city table: postalcode Repeater Nodes 1 Repeater Nodes 2 array( name=>postalcode relation=> array( join-field=>id, foreign-key=>place_id ),), place_id pcode address

24 24

25 25

26 Web Page HTML Server Side INTER-Mediator JavaScript Download INTER-Mediator JavaScript Database Adapter JavaScript Database Adapter JavaScript Inherited Data Access Class Interactive Processing JavaScript Data Access Class PHP Data Converter Class PHP Alternative Data Converter Class Database Extensible Components 26

27 class DataConverter_HTMLString { function converterfromusertodb($str) { return $str; } } function converterfromdbtouser($str) { return str_replace("\n", "<br/>", str_replace("\r", "<br/>", str_replace("\r\n", "<br/>", str_replace(">", ">", str_replace("<", "<", str_replace("&", "&", $str)))))); } 27

28 include_once('../inter-mediator/db_filemaker_fx.php'); class DB_WebSite_FMSFX extends DB_FileMaker_FX { } function getfromdb( $sourcename ) { $returnvalue = parent::getfromdb( $sourcename ); if ( count( $returnvalue ) > 1 ) { // Check for the language of documents $lang = array(); foreach( $returnvalue as $record ) { $lang[$record['language']] += 1; } : return $returnvalue; } function settodb($datasourcename) { } function newtodb($datasourcename) { } function deletefromdb($datasourcename) { } 28

29 function modline(target) { var qtyid = INTERMediatorOnPage.getNodeIdFromIMDefinition("items@qty",target); var unitpriceid = INTERMediatorOnPage.getNodeIdFromIMDefinition("items@unitprice",target); var productpriceid = INTERMediatorOnPage.getNodeIdFromIMDefinition("product@unitprice",target); var amountid = INTERMediatorOnPage.getNodeIdFromIMDefinition("items@amount",target); if ( qtyid!= null && unitpriceid!= null && productpriceid!= null && amountid!= null) { var unitprice = new Number( document.getelementbyid(unitpriceid).value > 0? document.getelementbyid(unitpriceid).value : document.getelementbyid(productpriceid).innerhtml ); var amountprice = unitprice * document.getelementbyid(qtyid).value; document.getelementbyid(amountid).innerhtml = INTERMediatorLib.numberFormat(amountPrice); } } 29

30 End-user requirement To: Mr. Nii INVOICE Date: Nov 30, 2011 Core i7 $250 2 $500 4GB Memory $150 4 $600 invoice id recipient issued_date invoice_id id item id invoice_id product_id quantity id product_id product id name unit_price Amount: $ Analyze Data Model Database Schema 7. Popup menu of products shows all products Definition File array( name => products, records => 10000, key => id ) 1. Create Object Diagram item_products <<VIEW>> item.id nvoice_id product_id product_name unit_price quantity total=quantity * unit_price Object Diagram 2nd_of_34005 : Item Invoice_id: Product: 4GB Memory Unit_Price: $150 Quantity: 4 Total: $ Integrating the popup menu with the Repeater of Invoice_to_MrNii : Invoice id: To: Mr. Nii Date: Nov 30, 2011 Amount: $1100 Invoice_id = st_of_34005 : Item Invoice_id: Product: Core i7 Unit_Price: $250 Quantity: 2 Total: $ Show multiplerecords inside the table. Adding the Repeater of item_products 3. Invoice is invoice. So it can show one record of invoice array( name => invoice, records => 1, key => id ) 4. Same data on both diagrams as: Invoice.To = invoice.recipient Placing one element within Repeater of invoice <table> Page File <td class="im[invoice@recipiant]> </td> 5. Items in an Invoice is relevant to one-to-many relation of invoice - item_products. The Repeater of item_products could be set inside the Repeater invoice. <table> <td class="im[invoice.recipiant]></td> <table> <td class="im[item@product_name]></td> <td class="im[item@unit_price]></td> <td class="im[item@quantity]></td> <td class="im[item@total]></td> item_products : Page File <table> <td> <select class="im[item@product_id]> <option class="im[product@id@value product@name@innerhtml]" /> </select> </td> <td class="im[item@unit_price]></td> : Definition File array( Definition File name => item, view => item_products, records => 10000, key => id, foreign-key => invoice_id, join-field => id ) Page File 30

31 31

32 32

2

http: Develop Simply, Realize Conceived 1 2 3 4 5 6 7 8 9 10 11 12 13 14 tbody tr div [_im_enclosure] div [_im_repeater] span [_im_enclosure] span [_im_repeater] ol li ul li select option 15 1. Detecting