2014年3月26日 星期三

generator-data hidden / refresh

Combo Box Data
content.txt
0.41,SALES_HEADER.CUSTOMER,combo,15,15,Customer,,{colSpan}3{/colSpan}{getJson} tableRead?table=CUSTOMER&fields=RECORDID,NAME&where=where status:`A` &format=S,S&callback=?{/getJson}  {refresh}currentEntity=_lookup('this.id');{/refresh}

Display ShortForm Data
0.61,MANUFACTURER.STATUS,text:GRID,18%,150,Status,,{data}D,draft,A,approved,F,Frozen{/data}



Display the Form Read the Special Record

input.jsp?mode=SINPUT&input=products.txt&config=productsConfig.txt&key=recordid&keyValue=1390296450593

Display the Form Grid List
config.txt
where=where status:`D`  or status:`A`  or status:`F` 

Get data from another form
config.txt
appendData0=input.jsp?input:dNotesPurchaseList.txt&config:dNotesPurchaseListConfig.txt&mode:CHOICE
appendData0Caption=Createor 
appendData0Source=POQTYOS
appendData0TargetKey=DNOTE_LINE.PO_RECORDID
appendData0HeaderSource=SALES_ORDER,COMPANY,DIVISION,SALES_CODE,SUPPLIER,SHIP_TO_CONTACT,COMPANY_NAME,SHIP_TO_ADDRESS,OUR_REF_NO,CONTRACT_NO
appendData0HeaderSourceFormat=S,S,S,S,S,S,S,S,S,S
appendData0HeaderTarget=DNOTE_HEADER.SALES_ORDER,DNOTE_HEADER.COMPANY,DNOTE_HEADER.DIVISION, DNOTE_HEADER.SALES_CODE,DNOTE_HEADER.SUPPLIER,DNOTE_HEADER.SHIP_TO_CONTACT,DNOTE_HEADER.COMPANY_NAME,DNOTE_HEADER.SHIP_TO_ADDRESS,DNOTE_HEADER.OUR_REF_NO,DNOTE_HEADER.YOUR_REF_NO


Hidden Data
config.txt
InvisibleRetrivalNumber=1

Refresh Data
config.txt
Refresh=s:_lookup("PRODUCT_GROUP.STATUS");s:$.trim(s);if(s!:'A'){$("#submit3").css( "display", "none" );} else {$("#submit3").css( "display", "inline" );}
Display Grid List (Dyanamice input) 
config.txt
formConstrain=and (status:`D` or status:`A`  or status:`F`) 
queryMode=or
Content.txt
#
0.34,query.productsName,text,100%:200px:400px,40,KeyWord ,,{setConstrain}_c0=_lookup('query.productsName');{/setConstrain}{colspan}2{/colspan} {labelInLineStyle}word-wrap:normal;{/labelInLineStyle}
#
0.21,query.market,check,0,0,: Market,,{default}1{/default} {setConstrain}_c1=document.getElementById("query.market").checked;if(_c1){_c01='market like `^'+_c0+'^`';} else {_c01='false';} {/setConstrain} 
0.21,query.category,check,0,0, : Category,,{default}1{/default} {setConstrain}_c2=document.getElementById("query.category").checked;if(_c2){_c02='category like `^'+_c0+'^`';} else {_c02='false';} {/setConstrain} 
0.21,query.sub_cateory,check,0,0, : Sub-Category,,{default}1{/default} {setConstrain}_c3=document.getElementById("query.sub_cateory").checked;if(_c3){_c03='sub_category like `^'+_c0+'^`';} else {_c03='false';} {/setConstrain} 
0.24,query.manufacturer,check,0,0, : Manufacturer,,{default}1{/default} {setConstrain}_c4=document.getElementById("query.manufacturer").checked;if(_c4){_c04='manufacturer like `^'+_c0+'^`';} else {_c04='false';} {/setConstrain} 
0.24,query.model,check,0,0, : Model,,{default}1{/default} {setConstrain}_c5=document.getElementById("query.model").checked;if(_c5){_c05='model like `^'+_c0+'^`';} else {_c05='false';} {/setConstrain} 

0.24,query.description,check,0,0, : Description,,{default}1{/default} {setConstrain}_c6=document.getElementById("query.description").checked;if(_c6){_c06='description like `^'+_c0+'^`';} else {_c06='false';} {/setConstrain} 


Market 
Category Sub-Category 
Manufacturer 
Model Description 

沒有留言:

張貼留言