1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* Manage an Daedalus table form. This allows you to use a form for a single |
5
|
|
|
* Daedalus table, either filling in some or all of the data. |
6
|
|
|
* |
7
|
|
|
* Usage: |
8
|
|
|
* a) creating a new form of type 'abc' which will set a $form and $submitted |
9
|
|
|
* parameter for use in the template |
10
|
|
|
* |
11
|
|
|
* ``` |
12
|
|
|
* {ddsForm classType='abc'} |
13
|
|
|
* {if ($submitted)} |
14
|
|
|
* // do something |
15
|
|
|
* {else} |
16
|
|
|
* {$form->run()} |
17
|
|
|
* {/if} |
18
|
|
|
* ``` |
19
|
|
|
* You can change the form and submitted parameter names using assignForm |
20
|
|
|
* and assignSubmitted respectively. |
21
|
|
|
* |
22
|
|
|
* b) editing an existing form of type 'abc' and UUID of $uuid |
23
|
|
|
* |
24
|
|
|
* ``` |
25
|
|
|
* {ddsForm classType='abc' uuid=$uuid} |
26
|
|
|
* ``` |
27
|
|
|
* |
28
|
|
|
* c) changing the form id & the name of the assigned form and submitted parameters |
29
|
|
|
* |
30
|
|
|
* ``` |
31
|
|
|
* {ddsForm classType='abc' formId='formId' assignForm='myForm' assignSubmitted='myFormSubmitted'} |
32
|
|
|
* {if ($myFormSubmitted)} |
33
|
|
|
* // do something |
34
|
|
|
* {else} |
35
|
|
|
* {$myForm->run()} |
36
|
|
|
* {/if} |
37
|
|
|
* ``` |
38
|
|
|
* |
39
|
|
|
* d) ReadOnly: You can set whether or not the form can be edited by passing in readOnly. This |
40
|
|
|
* defaults to false. |
41
|
|
|
* ``` |
42
|
|
|
* {ddsForm classType='abc' readOnly=true} |
43
|
|
|
* ```` |
44
|
|
|
* |
45
|
|
|
* e) Selecting Fields: You can set the fields you want to show on the form and in what order by setting |
46
|
|
|
* the 'fields' parameter to either [fieldName,...] or ['fieldName'=>'label',...] (or |
47
|
|
|
* any combination) to either get a label derived from the fieldName (underscore |
48
|
|
|
* replaced by spaces and all words capitalised) or to set the label |
49
|
|
|
* ``` |
50
|
|
|
* {ddsForm classType='abc' fields=['field1', 'field2', 'field3'=>'field 3 label'...]} |
51
|
|
|
* ``` |
52
|
|
|
* |
53
|
|
|
* f) Filtering Maps: some fields get their data from other tables as a set of key=>value pairs |
54
|
|
|
* or map - for example, dynamic select lists. There are occasions when you need to filter those |
55
|
|
|
* lists say by project or client or combination of map fields. |
56
|
|
|
* |
57
|
|
|
* In these cases you can pass in a *mapFilters* to the form which will be applied to the |
58
|
|
|
* other table to return a subset of values. mapFilters are a set of srcField => [mappedField=>value,...]. |
59
|
|
|
* Each srcField is on this dds table and the mappedFields are fields on the destination map table. |
60
|
|
|
* Filters are all applied as mapField=value and are all ANDed together. |
61
|
|
|
* ``` |
62
|
|
|
* {ddsForm classType='abc' mapFilters=[ |
63
|
|
|
* 'formField1'=>[mapField1=>value1, mapField2=>value2,...], |
64
|
|
|
* ... |
65
|
|
|
* ]} |
66
|
|
|
* ``` |
67
|
|
|
* |
68
|
|
|
* g) Formatting Maps: @see f) above. Each Daedalus table has a default map field that is |
69
|
|
|
* returned for e.g. select lists. There are times when you may want to change which field or |
70
|
|
|
* fields are returned and specify a format for them. In this case you can pass in a |
71
|
|
|
* *mapFields* parameter. These are a set of formField=>[mappedField,..., 'format'=>[x]] where |
72
|
|
|
* each field required is listed in order, and the format key is used to define how you want |
73
|
|
|
* the returned values to be formatted. This can have keys of prefix, postfix and concat each |
74
|
|
|
* taking a string. e.g. myField=>[field1, field2, 'format'=>['concat'=>': ']] |
75
|
|
|
* ``` |
76
|
|
|
* {ddsForm classType='abc' mapFilters=[ |
77
|
|
|
* 'formField1'=>[mapField1=>value1, mapField2=>value2,...], |
78
|
|
|
* ... |
79
|
|
|
* ]} |
80
|
|
|
* ``` |
81
|
|
|
* |
82
|
|
|
* @param $params |
83
|
|
|
* Required parameters |
84
|
|
|
* ------------------- |
85
|
|
|
* 'classType' => the class type of the form in Phoebe |
86
|
|
|
* |
87
|
|
|
* Optional Parameters |
88
|
|
|
* ------------------- |
89
|
|
|
* 'uuid' => the form UUID if this is not a new form |
90
|
|
|
* 'id' => an HTML id for the form. If not set the UUID is used, or failing |
91
|
|
|
* that the form type. |
92
|
|
|
* 'label' => the main title of the form if not the default |
93
|
|
|
* 'cssClass' => set additional css classes for the form |
94
|
|
|
* 'fields' => the set of fields (and order) you want displaying on the form |
95
|
|
|
* or leave out to get all the available fields |
96
|
|
|
* 'mapFilters' => @see f) above - a set of ['formField' => ['tableField'=>'value',...]] |
97
|
|
|
* to filter dynamic maps extracted from other tables |
98
|
|
|
* 'mapFields' => @see g) above - a set of formField=>['tableField's] that you want |
99
|
|
|
* returned in a dynamic map if not the default mapped field. You can add a 'format' |
100
|
|
|
* key with sub array ['concat', 'prefix', 'postfix'] to format how the |
101
|
|
|
* fields will be combined into the map. |
102
|
|
|
* 'fieldDefaults' => set default values for fields as |
103
|
|
|
* ['field'=>'default'] |
104
|
|
|
* 'fieldProperties' => set provided properties for the form fields as |
105
|
|
|
* ['field'=>['property'=>'value']] |
106
|
|
|
* 'assignForm' => set this to change the name of the assigned form parameter |
107
|
|
|
* (default 'form') |
108
|
|
|
* 'assignSubmitted' => set this to use a different submitted parameter |
109
|
|
|
* (default 'submitted') |
110
|
|
|
* 'assignSaved' => set this to use a different saved parameter |
111
|
|
|
* (default 'saved') |
112
|
|
|
* 'assignErrors' => set this to use a different form errors parameter |
113
|
|
|
* (default 'errors') |
114
|
|
|
* 'submitLabel' => a submit label or 'Save' |
115
|
|
|
* 'buttons' => an array of buttons as [ |
116
|
|
|
* ['name'=>'abc', 'label'=>'Abc', 'class'=>'additional classes'],...] |
117
|
|
|
* ]. These will override the default submit button. |
118
|
|
|
* 'action' => URL to go to if you don't want to handle the form in the same page |
119
|
|
|
* 'readOnly' => set to true if you want the form to be read only |
120
|
|
|
* 'printOnly' => set to true if you want the form to be printable |
121
|
|
|
* 'dataSources' => these allow you to set particular fields on a form so that their values |
122
|
|
|
* are fixed by the system and not editable by the user. The fields do not have to |
123
|
|
|
* be displayed to the user in order for them to be set. Set these to an array of |
124
|
|
|
* 'formField'=>value pairs. |
125
|
|
|
* 'enableAjaxValidation' => boolean whether or not to use AJAX validation. If you set this |
126
|
|
|
* you need to check $errors to know if a submission was successful or not |
127
|
|
|
* 'enableAjaxSubmission' => boolean whether or not to use AJAX submission |
128
|
|
|
* 'ajaxValidationUrl' => set to the URL for AJAX validation if not the default |
129
|
|
|
* 'returnUrl' => set the URL to redirect to after saving if required |
130
|
|
|
* 'name' => the name of the form if not the default |
131
|
|
|
* 'debug' => if true output some debug information about the form behaviour |
132
|
|
|
* @param $template the smarty template |
|
|
|
|
133
|
|
|
* |
134
|
|
|
* @return the following parameters will be set on return. The |
135
|
|
|
* 'form' - the form object (this will be the value of assignForm if set) |
136
|
|
|
* 'submitted' - if the form was submitted (this will be the value of assignSubmitted if set) |
137
|
|
|
* 'errors' - whether or not there were any submission errors (this will be the value of assignErrors if set) |
138
|
|
|
* 'uuid' - the UUID of the created object if successful or null otherwise |
139
|
|
|
* 'changeLogUuid' - if the item was submitted, and the corresponding dds table has |
140
|
|
|
* a change log, then the change log entry uuid will be returned here. |
141
|
|
|
*/ |
142
|
|
|
function smarty_function_ddsForm($params, $template) |
143
|
|
|
{ |
144
|
|
|
// need to ensure we don't fetch items from the database more than necessary |
145
|
|
|
// or handle the form more than once otherwise we can create additional entries |
146
|
|
|
static $handledObjects = []; |
147
|
|
|
static $forms = []; |
148
|
|
|
|
149
|
|
|
$phoebeType = 'daedalus'; |
150
|
|
|
|
151
|
|
|
// process the parameters |
152
|
|
|
if (!isset($params['classType'])) |
153
|
|
|
throw new \RuntimeException("You must pass in the form's classType otherwise we don't which form it is. You passed in: ".print_r($params,true)); |
|
|
|
|
154
|
|
|
$classType = $params['classType']; |
155
|
|
|
$cssClass = isset($params['cssClass']) ? $params['cssClass'] : null; |
156
|
|
|
$label = isset($params['label']) ? $params['label'] : null; |
157
|
|
|
$id = !empty($params['id']) ? $params['id'] : null; |
158
|
|
|
$saveOptions = !empty($params['submitLabel']) ? ['label'=>$params['submitLabel']] : []; |
159
|
|
|
$buttons = !empty($params['buttons']) ? $params['buttons'] : null; |
160
|
|
|
$action = !empty($params['action']) ? $params['action'] : null; |
161
|
|
|
$assignForm = !empty($params['assignForm']) ? $params['assignForm'] : 'form'; |
162
|
|
|
$assignSaved = !empty($params['assignSaved']) ? $params['assignSaved'] : 'saved'; |
163
|
|
|
$assignErrors = !empty($params['assignErrors']) ? $params['assignErrors'] : 'errors'; |
164
|
|
|
$assignSubmitted = !empty($params['assignSubmitted']) ? $params['assignSubmitted'] : 'submitted'; |
165
|
|
|
$readOnly = isset($params['readOnly']) ? (bool)$params['readOnly'] : false; |
166
|
|
|
$printOnly = isset($params['printOnly']) ? (bool)$params['printOnly'] : false; |
167
|
|
|
$uuid = !empty($params['uuid']) ? $params['uuid'] : null; |
168
|
|
|
$dataSources = !empty($params['dataSources']) ? $params['dataSources'] : null; |
169
|
|
|
$enableAjaxValidation = isset($params['enableAjaxValidation']) ? (bool)$params['enableAjaxValidation'] : true; |
170
|
|
|
$enableAjaxSubmission = isset($params['enableAjaxSubmission']) ? (bool)$params['enableAjaxSubmission'] : false; |
171
|
|
|
$ajaxValidationUrl = !empty($params['ajaxValidationUrl']) ? $params['ajaxValidationUrl'] : '/phoebe/database/index/validate-form'; |
172
|
|
|
$returnUrl = !empty($params['returnUrl']) ? $params['returnUrl'] : null; |
173
|
|
|
$formName = !empty($params['name']) ? $params['name'] : null; |
174
|
|
|
$fields = !empty($params['fields']) ? $params['fields'] : []; |
175
|
|
|
$mapFilters = !empty($params['mapFilters']) ? $params['mapFilters'] : []; |
176
|
|
|
$mapFields = !empty($params['mapFields']) ? $params['mapFields'] : []; |
177
|
|
|
$fieldDefaults = !empty($params['fieldDefaults']) ? $params['fieldDefaults'] : []; |
178
|
|
|
$fieldProperties = !empty($params['fieldProperties']) ? $params['fieldProperties'] : []; |
179
|
|
|
// prefix invalid (HTML5) ids with a letter |
180
|
|
|
$id = ($id ? $id : ($uuid ? $uuid : null)); |
181
|
|
|
if ($id) { |
182
|
|
|
if (is_numeric($id[0]) || $id[0] == '-' || $id[0] == '_') |
183
|
|
|
$id = 'z' . $id; |
184
|
|
|
} |
185
|
|
|
$changeLogUuids = []; |
186
|
|
|
|
187
|
|
|
// get form definition |
188
|
|
|
$phoebe = neon('phoebe')->getIPhoebeType($phoebeType); |
189
|
|
|
$formKey = $classType.$uuid.$id; |
190
|
|
|
if (array_key_exists($formKey, $forms)) { |
191
|
|
|
$form = $forms[$formKey]; |
192
|
|
|
} else { |
193
|
|
|
// creating a form is expensive so do it only once per object |
194
|
|
|
$form = neon('phoebe')->getForm($phoebeType, $classType, [ |
195
|
|
|
'id' => $id, |
196
|
|
|
'name' => $formName, |
197
|
|
|
'label' => $label, |
198
|
|
|
'cssClass' => $cssClass, |
199
|
|
|
'save'=>$saveOptions, |
200
|
|
|
'buttons' => $buttons, |
201
|
|
|
'readOnly' => $readOnly, |
202
|
|
|
'printOnly' => $printOnly, |
203
|
|
|
'action'=>$action, |
204
|
|
|
'enableAjaxValidation' => $enableAjaxValidation, |
205
|
|
|
'enableAjaxSubmission' => $enableAjaxSubmission, |
206
|
|
|
'ajaxValidationUrl' => url([$ajaxValidationUrl, 'classType' => $classType, 'name'=>$formName]), |
207
|
|
|
'uuid' => $uuid, |
208
|
|
|
'dataSources' => $dataSources, |
209
|
|
|
'returnUrl' => $returnUrl, |
210
|
|
|
'fields' => $fields, |
211
|
|
|
'mapFilters' => $mapFilters, |
212
|
|
|
'mapFields' => $mapFields, |
213
|
|
|
'fieldDefaults' => $fieldDefaults, |
214
|
|
|
'fieldProperties' => $fieldProperties |
215
|
|
|
]); |
216
|
|
|
$forms[$formKey] = $form; |
217
|
|
|
} |
218
|
|
|
$saveFormResults = [ |
219
|
|
|
$assignSaved => false, |
220
|
|
|
$assignErrors => null, |
221
|
|
|
$assignSubmitted => false, |
222
|
|
|
'uuid' => $uuid, |
223
|
|
|
'changeLogUuids' => $changeLogUuids |
224
|
|
|
]; |
225
|
|
|
|
226
|
|
|
// is this a submitted form ready for saving and we haven't already handled it |
227
|
|
|
if (!$readOnly && $form->hasRequestData()) { |
228
|
|
|
if (!array_key_exists($uuid, $handledObjects)) { |
229
|
|
|
// pass in any metaInfo that we know about here |
230
|
|
|
$metaInfo = [ |
231
|
|
|
'uuid' => $uuid, |
232
|
|
|
'dataSources' => $dataSources, |
233
|
|
|
'returnUrl' => $returnUrl |
234
|
|
|
]; |
235
|
|
|
$result = neon('phoebe')->saveForm($phoebeType, $classType, $form, $formName, $metaInfo, $uuid, $changeLogUuids); |
236
|
|
|
if ($result === true && $uuid) { |
237
|
|
|
$object = $phoebe->getObject($uuid); |
238
|
|
|
$form->loadFromDb($object->data); |
239
|
|
|
$saveFormResults['uuid'] = $uuid; |
240
|
|
|
$saveFormResults[$assignSaved] = true; |
241
|
|
|
$saveFormResults['changeLogUuids'] = $changeLogUuids; |
242
|
|
|
} else { |
243
|
|
|
$saveFormResults[$assignErrors] = json_encode($result); |
244
|
|
|
} |
245
|
|
|
$saveFormResults[$assignSubmitted] = true; |
246
|
|
|
$handledObjects[$uuid] = $saveFormResults; |
247
|
|
|
} else { |
248
|
|
|
$saveFormResults = $handledObjects[$uuid]; |
249
|
|
|
} |
250
|
|
|
} |
251
|
|
|
|
252
|
|
|
// assign all of the save results to the template |
253
|
|
|
foreach ($saveFormResults as $k=>$v) |
254
|
|
|
$template->assign($k,$v); |
255
|
|
|
|
256
|
|
|
|
257
|
|
|
// assign the resulting form |
258
|
|
|
$template->assign($assignForm, $form); |
259
|
|
|
} |
260
|
|
|
|
The issue could also be caused by a filter entry in the build configuration. If the path has been excluded in your configuration, e.g.
excluded_paths: ["lib/*"]
, you can move it to the dependency path list as follows:For further information see https://scrutinizer-ci.com/docs/tools/php/php-scrutinizer/#list-dependency-paths