• Home
• org.openl.rules
• org.openl.rules.tutorials
• 5.9.0
• source code
• HelloExcelCustomer.xls

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

org.openl.rules.examples.hello.rules.HelloExcelCustomer.xls Maven / Gradle / Ivy

??ࡱ?>??	
/????????.????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????	????
????\pStanislav Shor                                                                                               B?a
?
=

??
?
=X?
X/8
X@?"
?
?1???

Arial1???

Arial1???

Arial1???

Arial1??


Arial1?$?


Arial1?
??
Arial1?
	?
Arial1?	?

Arial1?Q?

Tahoma1?
Q?
Tahoma1?	?

Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)?"Yes";"Yes";"No"?"True";"True";"False"?"On";"On";"Off"]?,
[$? -2]\ #,##0.00_);[Red]\([$? -2]\ #,##0.00\)??? ? ?
?? ?? ?
?? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ??? ?? ?
 ? ?
+?? ?? ?
)?? ?? ?
,?? ?? ?
*?? ?? ????? ????? ?
	?? ?? ?
 P? ?
 @? ?
 p? ?
 x? ?
p"@ @ ) ?
p"@@ ) ?
p""@ @ , ?
p@ @ ) ?
p
@@ ) ?
p!@ @ ) ?
p
!@@ ) ?
p"!@ @ , ?
x@ @ ) ?
x
@@ ) ?
x""@ @ , ?
0@ @ ? ?
0
@@ ? ?
0"!@ @ ? ?
p"@ @ , ?
0"@ ? ?
0"@ @ ? ?
p""@ @ ) ?
p? ?
x? ?
P? ?
? ?	
x   ?
x? ?
 `"!@ @ ? ?
 `"@  ? ?
 h""@ @ , ?
(x""@ @ , ?
  "@ ? ?
  " @  ? ?
 x""@ @ , ?
0? ?
!? ?
p@ @ ) ?
p
@@ ) ?
? ?
(x"@ @, ?
 `"@ @? ?
 `"@ ? ?
 `" @  ? ?
x@ , ?
x@ , ?
x"@ @ , ?
x"@ @ , ?
p @  ? ?
p @  ? ?
x!@ , ?
x!"@ @ , ?
p! @  ? ?
 `@ @ ) ?	
!x   ?
!x   ?
x"@@  ?
x"@  ?
x " @  ?
x@ @  ?
x!@ @  ?
!x  ?
x@ @ , ?
x!@ @ , ?
x!@ @ , ?
x!!@ @ , ??????????????	??????????`
?ZDecision Tables?+%Data?t-Methods?6Environment?

?


 Gender;"Greeting;'
MaritalStatus;$
Salutation;
?
?
`i
?b?Z? 

3???
A?
@@?
???T9C1A1C2GreetingGood MorningGood AfternoonGood Evening
Good Nightint minhour <= maxint maxString greeting	Hour FromHour ToGenderMarital StatusSet GreetingSet Salutation
String gendercustomer.gender.equals(gender)%customer.maritalStatus.equals(status)
String statusString salutationMarital
StatusMaleMarriedFemaleSingle
SalutationMr.Ms.Mrs.6Rules void defineGreeting(int hour, Response response)	(response.map.put("greeting", greeting); min <= hournameagegender
maritalStatusNameAge
John Smith
Mary Smith,Method void helloCustomer(Response response)	StringString intDatatype ExcelCustomerData ExcelCustomer customersFRules void defineSalutation(ExcelCustomer customer, Response response)	+response.map.put("salutation",salutation); ?int hour = Calendar.getInstance().get(Calendar.HOUR_OF_DAY);
defineGreeting(hour, response);
ExcelCustomer customer =customers[0];
defineSalutation(customer,response);
response.map.put("name",customer.name);Environmentlanguageorg.openl.rules.javaimportorg.openl.rules.examples.hello?B?.b??@t
??
,`??b?
p



TR9C:\_ICP\IDE\eclipse\workspace\warner.openl\RateMatrix.htmRateMatrix_21517hr cc?
	????
,? 

d
????MbP?_
*+?
?%
????MHP LaserJet 6L - local
?4C?
?
od
X

X
Letter


????DINU"4_*?
?"
d


XX????
U}?}

?}?}?}?}?}??

 ?
!
 ??a
??
a
 ?

 ?Y
@
 ?h
@
 	?;
@
 
?h
@
 ?h
@

?

 ?
!
 ?H?
;
?
a
 


 
Y
@
 
h
@
 
;
@
 
h
@
 
?

M ??
NN??

?
?

?

"?
	?
)!?

 ?
!
?
"?

#?
$
?
%?
&'&@?
(?
&(@'1@?
(?	
&2@'6@?
	(?

+7@*8@?

(?
:::

?


M1??

NN??

?
?

?

<?
=?
)2
>?

 ?
!?
"?

#?
$?
%?

&
'?
(?

&?
'?
(?

&?
'?
(?
+*(?*?h
?
****$$$$?
*4**&**?????
??(
	?
????
?

??B??
?
??
X
?
P?
P?

???
o???]4
@?
,?
-??+???K??(????-?
??
?
<?
Comment:
This piece of Java code describes the semantics of the action that will be executed when a row is selected (conditions in the columns C1 and C2 are satisfied). The String variable "greeting" will contain the value of the proper cell inside this column: "Good Morning", "Good Evening", etc.  Actually this example is using the OpenL's implementation of Java as specified in first line of the tab "Environment".<:
??
?

Jacob FeldmanJ>?@





?



?7?
?????
,




anco

?
+




an#
?
+




an#
?
+




an#



?
+




an#

	????
!)?,

d
????MbP?_
*+?
?%
????M6\\VALENTINAU\HP DeskJet 720C
?XC?

?
od
,


,

Letter



DINU"4$@$??

$?$
$?$
?"
d


,
,
????
U}?}

?
}?}?}?
}U}q
}		q}





 




J
@









 


 


 



 	

 



 


 ?


R/

S?

U,?
V#?

U-?
V&?

U,?
V%?

W.?
X$?

O0?PPQ?

C#?
D&?
D%?
I$?
	
E'?
	F?
	F?
	J(?


G)?

H?

H~

K8@?

G*?
H?
H~
K3@?v?888?P?H ?

?0?(
	?
?>?@
?



?7?
?????
+




#

?
+




#



	????
?2?5

d
????MbP?_
*+?
?%
????M?\\GATEKEEPER\HP LaserJet 4050 S
????
d
X
XLetter
?.HP LaserJet 4050 Series PCL 62??x?e??.DA???>3?2?0Dq^??Y؋??? U'fC?e?,lx?^???ѧÉD-????????_?c??ّp"??X/i???@?



?7?
????gg
????D
	????

?6:

d
????MbP?_
*+?
?%
?????"




?????/U}

U}?}?}}?














 


 





	






 


 


 






 


 

 





 


 


 








 ?


T4

T?

L5?
L6?

L7?
L8?

9
?

7?

7?
	
7?


8?

5?


4?

3?

6?

4?

3?

??

@?

A?

B?0??
>?@


?




?7?
????
??

?????Oh??+'??0?	
PXd|???
???
sJacob FeldmanxStanislav ShorMicrosoft Excel@RY??
@?
+????
@?>???
??

??՜.??+,??0?	
PXlt|??
???
OpenRulesn?	Decision TablesDataMethodsEnvironmentWorksheets
	

???? !"#$%????'()*+,-????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????Root Entry
???????? ?FP?@[??
????Workbook
?????????????:SummaryInformation(

????DocumentSummaryInformation8
????????????&