-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathSiFlow_process.pm
More file actions
122 lines (122 loc) · 11.5 KB
/
Copy pathSiFlow_process.pm
File metadata and controls
122 lines (122 loc) · 11.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
000006747O:8:"stdClass":26:{s:7:"process";a:33:{s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:10:"PRO_PARENT";s:32:"92573539853fdb89f541b54004988080";s:8:"PRO_TIME";d:1;s:12:"PRO_TIMEUNIT";s:4:"DAYS";s:10:"PRO_STATUS";s:6:"ACTIVE";s:12:"PRO_TYPE_DAY";s:0:"";s:8:"PRO_TYPE";s:6:"NORMAL";s:14:"PRO_ASSIGNMENT";s:5:"FALSE";s:12:"PRO_SHOW_MAP";i:0;s:16:"PRO_SHOW_MESSAGE";i:0;s:14:"PRO_SUBPROCESS";i:0;s:15:"PRO_TRI_DELETED";s:0:"";s:16:"PRO_TRI_CANCELED";s:0:"";s:14:"PRO_TRI_PAUSED";s:0:"";s:18:"PRO_TRI_REASSIGNED";s:0:"";s:17:"PRO_SHOW_DELEGATE";i:0;s:17:"PRO_SHOW_DYNAFORM";i:0;s:12:"PRO_CATEGORY";s:32:"5601928474eda4a85a364f4004151417";s:16:"PRO_SUB_CATEGORY";s:0:"";s:12:"PRO_INDUSTRY";i:0;s:15:"PRO_UPDATE_DATE";N;s:15:"PRO_CREATE_DATE";s:19:"2014-08-27 12:53:19";s:15:"PRO_CREATE_USER";s:32:"00000000000000000000000000000001";s:10:"PRO_HEIGHT";i:5000;s:9:"PRO_WIDTH";i:10000;s:11:"PRO_TITLE_X";i:0;s:11:"PRO_TITLE_Y";i:0;s:9:"PRO_DEBUG";i:0;s:13:"PRO_DYNAFORMS";a:1:{s:7:"PROCESS";s:0:"";}s:25:"PRO_DERIVATION_SCREEN_TPL";s:0:"";s:15:"PRO_DESCRIPTION";s:85:"This process shows the case variables that the zimlet SiFlow has sent to the process.";s:9:"PRO_TITLE";s:14:"SiFlow process";s:18:"PRO_CATEGORY_LABEL";s:4:"test";}s:5:"tasks";a:1:{i:0;a:53:{s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:7:"TAS_UID";s:32:"85987827853fdb8c2f38735057326579";s:8:"TAS_TYPE";s:6:"NORMAL";s:12:"TAS_DURATION";d:1;s:14:"TAS_DELAY_TYPE";s:0:"";s:14:"TAS_TEMPORIZER";d:0;s:12:"TAS_TYPE_DAY";s:1:"1";s:12:"TAS_TIMEUNIT";s:4:"DAYS";s:9:"TAS_ALERT";s:5:"FALSE";s:21:"TAS_PRIORITY_VARIABLE";s:0:"";s:15:"TAS_ASSIGN_TYPE";s:8:"BALANCED";s:19:"TAS_ASSIGN_VARIABLE";s:30:"@@SYS_NEXT_USER_TO_BE_ASSIGNED";s:18:"TAS_GROUP_VARIABLE";s:0:"";s:24:"TAS_MI_INSTANCE_VARIABLE";s:24:"@@SYS_VAR_TOTAL_INSTANCE";s:24:"TAS_MI_COMPLETE_VARIABLE";s:34:"@@SYS_VAR_TOTAL_INSTANCES_COMPLETE";s:19:"TAS_ASSIGN_LOCATION";s:5:"FALSE";s:25:"TAS_ASSIGN_LOCATION_ADHOC";s:5:"FALSE";s:16:"TAS_TRANSFER_FLY";s:5:"FALSE";s:17:"TAS_LAST_ASSIGNED";s:32:"680400202529c5e55980260097571951";s:8:"TAS_USER";s:1:"0";s:14:"TAS_CAN_UPLOAD";s:5:"FALSE";s:15:"TAS_VIEW_UPLOAD";s:5:"FALSE";s:33:"TAS_VIEW_ADDITIONAL_DOCUMENTATION";s:5:"FALSE";s:14:"TAS_CAN_CANCEL";s:5:"FALSE";s:13:"TAS_OWNER_APP";s:5:"FALSE";s:7:"STG_UID";s:0:"";s:13:"TAS_CAN_PAUSE";s:5:"FALSE";s:20:"TAS_CAN_SEND_MESSAGE";s:4:"TRUE";s:19:"TAS_CAN_DELETE_DOCS";s:5:"FALSE";s:16:"TAS_SELF_SERVICE";s:5:"FALSE";s:9:"TAS_START";s:4:"TRUE";s:16:"TAS_TO_LAST_USER";s:5:"FALSE";s:19:"TAS_SEND_LAST_EMAIL";s:5:"FALSE";s:14:"TAS_DERIVATION";s:6:"NORMAL";s:8:"TAS_POSX";i:770;s:8:"TAS_POSY";i:190;s:9:"TAS_WIDTH";i:165;s:10:"TAS_HEIGHT";i:40;s:9:"TAS_COLOR";s:0:"";s:11:"TAS_EVN_UID";s:0:"";s:12:"TAS_BOUNDARY";s:0:"";s:25:"TAS_DERIVATION_SCREEN_TPL";s:0:"";s:23:"TAS_SELFSERVICE_TIMEOUT";i:0;s:20:"TAS_SELFSERVICE_TIME";s:0:"";s:25:"TAS_SELFSERVICE_TIME_UNIT";s:0:"";s:27:"TAS_SELFSERVICE_TRIGGER_UID";s:0:"";s:9:"TAS_TITLE";s:14:"Test Variables";s:15:"TAS_DESCRIPTION";s:0:"";s:13:"TAS_DEF_TITLE";s:0:"";s:19:"TAS_DEF_DESCRIPTION";s:0:"";s:17:"TAS_DEF_PROC_CODE";s:0:"";s:15:"TAS_DEF_MESSAGE";s:0:"";s:23:"TAS_DEF_SUBJECT_MESSAGE";s:0:"";}}s:6:"routes";a:1:{i:0;a:17:{s:7:"ROU_UID";s:32:"38082087653fdb8d161e120006660468";s:10:"ROU_PARENT";s:1:"0";s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:7:"TAS_UID";s:32:"85987827853fdb8c2f38735057326579";s:13:"ROU_NEXT_TASK";s:2:"-1";s:8:"ROU_CASE";s:1:"1";s:8:"ROU_TYPE";s:10:"SEQUENTIAL";s:13:"ROU_CONDITION";s:0:"";s:16:"ROU_TO_LAST_USER";s:5:"FALSE";s:12:"ROU_OPTIONAL";s:5:"FALSE";s:14:"ROU_SEND_EMAIL";s:4:"TRUE";s:16:"ROU_SOURCEANCHOR";s:1:"1";s:16:"ROU_TARGETANCHOR";s:1:"0";s:11:"ROU_TO_PORT";s:1:"1";s:13:"ROU_FROM_PORT";s:1:"2";s:11:"ROU_EVN_UID";s:0:"";s:7:"GAT_UID";s:0:"";}}s:5:"lanes";a:0:{}s:8:"gateways";a:0:{}s:6:"inputs";a:0:{}s:7:"outputs";a:0:{}s:9:"dynaforms";a:2:{i:0;a:6:{s:7:"DYN_UID";s:32:"52327622553fdb92cdcb850033481565";s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:8:"DYN_TYPE";s:7:"xmlform";s:12:"DYN_FILENAME";s:65:"92573539853fdb89f541b54004988080/52327622553fdb92cdcb850033481565";s:9:"DYN_TITLE";s:17:"testVariablesForm";s:15:"DYN_DESCRIPTION";s:0:"";}i:1;a:6:{s:7:"DYN_UID";s:32:"70407806454045131ed6a03012273431";s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:8:"DYN_TYPE";s:4:"grid";s:12:"DYN_FILENAME";s:65:"92573539853fdb89f541b54004988080/70407806454045131ed6a03012273431";s:9:"DYN_TITLE";s:16:"DocumentListGrid";s:15:"DYN_DESCRIPTION";s:0:"";}}s:5:"steps";a:1:{i:0;a:8:{s:8:"STEP_UID";s:32:"12256573953fdb9f6924142042636551";s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:7:"TAS_UID";s:32:"85987827853fdb8c2f38735057326579";s:13:"STEP_TYPE_OBJ";s:8:"DYNAFORM";s:12:"STEP_UID_OBJ";s:32:"52327622553fdb92cdcb850033481565";s:14:"STEP_CONDITION";s:0:"";s:13:"STEP_POSITION";i:1;s:9:"STEP_MODE";s:4:"EDIT";}}s:8:"triggers";a:1:{i:0;a:7:{s:7:"TRI_UID";s:32:"68149734754044ef2069db5072670192";s:7:"PRO_UID";s:32:"92573539853fdb89f541b54004988080";s:8:"TRI_TYPE";s:6:"SCRIPT";s:10:"TRI_WEBBOT";s:794:"$caseId = @@APPLICATION;
$query = "SELECT C.CON_ID AS url, C.CON_VALUE AS filename FROM APP_DOCUMENT AD, CONTENT C
WHERE AD.APP_UID='$caseId' AND AD.APP_DOC_TYPE='INPUT' AND AD.APP_DOC_STATUS='ACTIVE'
AND AD.APP_DOC_UID=C.CON_ID AND C.CON_CATEGORY='APP_DOC_FILENAME' AND C.CON_VALUE<>''";
$result = executeQuery($query);
@@resultListInputs=$result;
@@countR=count($result);
if (is_array($result) and count($result) > 0) {
if(count($result)>1){
@@DocumentListGrid = $result;
@@urlList = json_encode($result);
}
else{ //unico link
$caseDocId = $result[1]['url'];
@@inputFUrl = 'http://' . $_SERVER['HTTP_HOST'] . '/sys' . @@SYS_SYS . '/' .
@@SYS_LANG . '/' . @@SYS_SKIN . '/cases/cases_ShowDocument?a=' . $caseDocId;
@@inputFileN = $result[1]['filename'];
}
}";s:9:"TRI_PARAM";s:0:"";s:9:"TRI_TITLE";s:24:"manageLinkToAttachedFile";s:15:"TRI_DESCRIPTION";s:0:"";}}s:9:"taskusers";a:0:{}s:8:"groupwfs";a:0:{}s:12:"steptriggers";a:1:{i:0;a:6:{s:8:"STEP_UID";s:32:"12256573953fdb9f6924142042636551";s:7:"TAS_UID";s:32:"85987827853fdb8c2f38735057326579";s:7:"TRI_UID";s:32:"68149734754044ef2069db5072670192";s:7:"ST_TYPE";s:6:"BEFORE";s:12:"ST_CONDITION";s:0:"";s:11:"ST_POSITION";s:1:"1";}}s:13:"dbconnections";a:0:{}s:12:"reportTables";a:0:{}s:16:"reportTablesVars";a:0:{}s:14:"stepSupervisor";a:0:{}s:17:"objectPermissions";a:0:{}s:10:"subProcess";a:0:{}s:11:"caseTracker";a:0:{}s:17:"caseTrackerObject";a:0:{}s:5:"stage";a:0:{}s:14:"fieldCondition";a:0:{}s:5:"event";a:0:{}s:13:"caseScheduler";a:0:{}s:15:"processCategory";a:4:{s:12:"CATEGORY_UID";s:32:"5601928474eda4a85a364f4004151417";s:15:"CATEGORY_PARENT";s:0:"";s:13:"CATEGORY_NAME";s:4:"test";s:13:"CATEGORY_ICON";s:0:"";}}00000003252327622553fdb92cdcb850033481565000003056<?xml version="1.0" encoding="UTF-8"?>
<dynaForm name="92573539853fdb89f541b54004988080/52327622553fdb92cdcb850033481565" enabletemplate="0" type="xmlform" width="500" mode="" nextstepsave="prompt" printdynaform="" adjustgridswidth="">
<testVariableTitle type="title" enablehtml="1">
<en>Test CaseVariables From Zimlet SiFlow</en>
</testVariableTitle>
<zpmIsSentEmail type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>IsSentEmail (zpmIsSentEmail)</en>
</zpmIsSentEmail>
<zpmToData type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>ToData (zpmToData)</en>
</zpmToData>
<zpmSentDateEmail type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>SentDateEmail (zpmSentDateEmail)</en>
</zpmSentDateEmail>
<zpmCcData type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>CcData (zpmCcData)</en>
</zpmCcData>
<zpmBccData type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>BccData (zpmBccData)</en>
</zpmBccData>
<zpmSubject type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>Subject (zpmSubject)</en>
</zpmSubject>
<zpmFromName type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>FromName (zpmFromName)</en>
</zpmFromName>
<zpmFromEmail type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>From Email (zpmFromEmail)</en>
</zpmFromEmail>
<zpmBody type="textarea" readonly="1" rows="2" cols="32" mode="view">
<en>Body (zpmBody)</en>
</zpmBody>
<pmServerUrl type="text" maxlength="64" validate="Any" readonly="1" size="15" mode="edit">
<en>ServerUrl (pmServerUrl)</en>
</pmServerUrl>
<linkURL type="link" link="@@inputFUrl" target_sel="_blank" target="_blank" value="link to Attached file">
<en>attachment (zpmAttachData)</en>
</linkURL>
<DocumentListGrid type="grid" xmlgrid="92573539853fdb89f541b54004988080/70407806454045131ed6a03012273431" addrow="0" deleterow="0"/>
<submit type="submit">
<en>End test</en>
</submit>
<loadsLink type="javascript" meta=""><![CDATA[var urlList= getField("urlList").value;
if(urlList!=""){
hideRow("linkURL");
var urlListDecoded = eval('(' + getField("urlList").value + ')');
for (var rowNo in urlListDecoded) {
getGridField('DocumentListGrid', rowNo, 'url').innerHTML = urlListDecoded[rowNo]['filename'];
getGridField('DocumentListGrid', rowNo, 'url').href = '../cases/cases_ShowDocument?a='+urlListDecoded[rowNo]['url'];
getGridField('DocumentListGrid', rowNo, 'url').target = '_self'; //to open in separate page
}
}
else{
getField("linkURL").href = getField("inputFUrl").value;
getField("linkURL").innerHTML = getField("inputFileN").value;
getField("linkURL").target ='_self';
hideRow("DocumentListGrid");
}]]></loadsLink>
<inputFUrl type="hidden" mode="edit"/>
<inputFileN type="hidden" mode="edit"/>
<urlList type="hidden" mode="edit"/>
</dynaForm>
00000003270407806454045131ed6a03012273431000000274<?xml version="1.0" encoding="UTF-8"?>
<dynaForm type="grid" name="92573539853fdb89f541b54004988080/70407806454045131ed6a03012273431" width="500" enabletemplate="0" mode="" nextstepsave="prompt">
<url type="link" target_sel="_self" target="_self"><en></en></url></dynaForm>
MAILTEMPL000000018alert_message.html000000682
<table style=\"background-color: white; font-family: Arial,Helvetica,sans-serif; color: black; font-size: 11px; text-align: left;\" cellpadding='10' cellspacing='0' width='100%'>
<tbody>
<tr><td style='font-size: 14px;'><b>ALERT MESSAGE</b></td></tr>
<tr><td style='vertical-align:middel;'>
<hr>
<br />
The Case <b>@#APP_NUMBER</b>, currently in the task <b>@#TAS_TITLE</b>, expired on <b>@#DEL_TASK_DUE_DATE</b>.
<br />
<br />
<hr><b>This Business Process is powered by ProcessMaker.<b><br />
<a href='http://www.processmaker.com' style='color:#c40000;'>www.processmaker.com</a>
<br />
</td></tr>
</tbody>
</table>000000022unassignedMessage.html000000829<table width="100%" cellpadding="10" cellspacing="0" style="background: #FFFFFF; font: 11px arial, verdana, helvetica, sans-serif;">
<tr>
<td style="font-size: 14px;">
<strong>UNASSIGNED CASE</strong>
<hr />
</td>
</tr>
<tr>
<td>
The case <strong>#@#APP_NUMBER</strong> is available on the unassigned list.
<br />
<br />
Note: If you want to claim the case and it is not available on the list, it might be already taken.
</td>
</tr>
<tr>
<td>
<hr />
This Business Process is powered by ProcessMaker.
<br />
<a href="http://www.processmaker.com" style="color: #C40000;">www.processmaker.com</a>
</td>
</tr>
</table>