AbstractBuildForm.php 137 KB
Newer Older
1
<?php
Carsten  Rose's avatar
Carsten Rose committed
2
3
4
5
6
7
/**
 * Created by PhpStorm.
 * User: crose
 * Date: 1/6/16
 * Time: 8:02 PM
 */
Carsten  Rose's avatar
Carsten Rose committed
8

9
10
11
namespace qfq;

use qfq;
Carsten  Rose's avatar
Carsten Rose committed
12
13
14
15

//use qfq\Store;
//use qfq\OnArray;
//use qfq\UserFormException;
16

17
18
19
20
21
22
23
24
25
26
require_once(__DIR__ . '/store/Store.php');
require_once(__DIR__ . '/Constants.php');
require_once(__DIR__ . '/exceptions/DbException.php');
require_once(__DIR__ . '/exceptions/UserFormException.php');
require_once(__DIR__ . '/database/Database.php');
require_once(__DIR__ . '/helper/HelperFormElement.php');
require_once(__DIR__ . '/helper/Support.php');
require_once(__DIR__ . '/helper/OnArray.php');
require_once(__DIR__ . '/helper/Ldap.php');
require_once(__DIR__ . '/report/Link.php');
27

28
/**
Carsten  Rose's avatar
Carsten Rose committed
29
30
 * Class AbstractBuildForm
 * @package qfq
31
 */
32
abstract class AbstractBuildForm {
33
34
35
36
37
    protected $formSpec = array();  // copy of the loaded form
    protected $feSpecAction = array(); // copy of all formElement.class='action' of the loaded form
    protected $feSpecNative = array(); // copy of all formElement.class='native' of the loaded form
    protected $buildElementFunctionName = array();
    protected $pattern = array();
38
    protected $wrap = array();
39
    protected $symbol = array();
40
    protected $showDebugInfoFlag = false;
41
    protected $inputCheckPattern = array();
Carsten  Rose's avatar
Carsten Rose committed
42

43
//    protected $feDivClass = array(); // Wrap FormElements in <div class="$feDivClass[type]">
44

45
46
47
48
49
50
51
52
    /**
     * @var Store
     */
    protected $store = null;
    /**
     * @var Evaluate
     */
    protected $evaluate = null;
53
54
55
    /**
     * @var string
     */
56
    private $formId = null;
57
58
59
60
61
    /**
     * @var Sip
     */
    private $sip = null;

62
63
64
65
66
67
68
    /**
     * AbstractBuildForm constructor.
     *
     * @param array $formSpec
     * @param array $feSpecAction
     * @param array $feSpecNative
     */
69
70
71
72
73
    public function __construct(array $formSpec, array $feSpecAction, array $feSpecNative) {
        $this->formSpec = $formSpec;
        $this->feSpecAction = $feSpecAction;
        $this->feSpecNative = $feSpecNative;
        $this->store = Store::getInstance();
74
        $this->db = new Database();
Carsten  Rose's avatar
Carsten Rose committed
75
        $this->evaluate = new Evaluate($this->store, $this->db);
76
        $this->showDebugInfoFlag = Support::findInSet(SYSTEM_SHOW_DEBUG_INFO_YES, $this->store->getVar(SYSTEM_SHOW_DEBUG_INFO, STORE_SYSTEM));
77

78
        $this->sip = $this->store->getSipInstance();
79

80
        // render mode specific
81
        $this->fillWrap();
82
83

        $this->buildElementFunctionName = [
84
            FE_TYPE_CHECKBOX => 'Checkbox',
85
            FE_TYPE_DATE     => 'DateTime',
86
            FE_TYPE_DATETIME => 'DateTime',
87
88
89
90
91
92
93
94
95
            'dateJQW'        => 'DateJQW',
            'datetimeJQW'    => 'DateJQW',
            'email'          => 'Input',
            'gridJQW'        => 'GridJQW',
            FE_TYPE_EXTRA    => 'Extra',
            FE_TYPE_TEXT     => 'Input',
            FE_TYPE_EDITOR   => 'Editor',
            FE_TYPE_TIME     => 'DateTime',
            FE_TYPE_NOTE     => 'Note',
96
            FE_TYPE_PASSWORD => 'Input',
97
98
            FE_TYPE_RADIO    => 'Radio',
            FE_TYPE_SELECT   => 'Select',
99
            FE_TYPE_SUBRECORD => 'Subrecord',
100
101
102
103
            FE_TYPE_UPLOAD   => 'File',
            'fieldset'       => 'Fieldset',
            'pill'           => 'Pill',
            'templateGroup'  => 'TemplateGroup',
104
105
        ];

106
        $this->buildRowName = [
107
            FE_TYPE_CHECKBOX => 'Native',
108
            FE_TYPE_DATE     => 'Native',
109
            FE_TYPE_DATETIME => 'Native',
110
111
112
113
114
115
116
117
118
            'dateJQW'        => 'Native',
            'datetimeJQW'    => 'Native',
            'email'          => 'Native',
            'gridJQW'        => 'Native',
            FE_TYPE_EXTRA    => 'Native',
            FE_TYPE_TEXT     => 'Native',
            FE_TYPE_EDITOR   => 'Native',
            FE_TYPE_TIME     => 'Native',
            FE_TYPE_NOTE     => 'Native',
119
            FE_TYPE_PASSWORD => 'Native',
120
121
            FE_TYPE_RADIO    => 'Native',
            FE_TYPE_SELECT   => 'Native',
122
            FE_TYPE_SUBRECORD => 'Subrecord',
123
124
125
126
            FE_TYPE_UPLOAD   => 'Native',
            'fieldset'       => 'Fieldset',
            'pill'           => 'Pill',
            'templateGroup'  => 'TemplateGroup',
127
128
        ];

129
        $this->symbol[SYMBOL_EDIT] = "<span class='glyphicon " . GLYPH_ICON_EDIT . "'></span>";
130
        $this->symbol[SYMBOL_SHOW] = "<span class='glyphicon " . GLYPH_ICON_SHOW . "'></span>";
131
132
        $this->symbol[SYMBOL_NEW] = "<span class='glyphicon " . GLYPH_ICON_NEW . "'></span>";
        $this->symbol[SYMBOL_DELETE] = "<span class='glyphicon " . GLYPH_ICON_DELETE . "'></span>";
133

134
        $this->inputCheckPattern = Sanitize::inputCheckPatternArray();
135
136
    }

137
138
    abstract public function fillWrap();

139
    /**
140
     * Builds complete 'form'. Depending of form specification, the layout will be 'plain' / 'table' / 'bootstrap'.
141
     *
142
     * @param string $mode FORM_LOAD | FORM_UPDATE | FORM_SAVE
143
144
145
     *
     * @return string|array   $mode=LOAD_FORM: The whole form as HTML, $mode=FORM_UPDATE: array of all
     *                        formElement.dynamicUpdate-yes  values/states
146
147
     * @throws CodeException
     * @throws DbException
148
     * @throws \qfq\UserFormException
149
     */
150
    public function process($mode, $htmlElementNameIdZero = false) {
Carsten  Rose's avatar
Carsten Rose committed
151
152
        $htmlHead = '';
        $htmlTail = '';
153
        $htmlT3vars = '';
Carsten  Rose's avatar
Carsten Rose committed
154
155
156
        $htmlSubrecords = '';
        $htmlElements = '';
        $json = array();
157
158
159
160
161
162
163
164

        $modeCollectFe = FLAG_DYNAMIC_UPDATE;
        $storeUse = STORE_USE_DEFAULT;

        if ($mode === FORM_SAVE) {
            $modeCollectFe = FLAG_ALL;
            $storeUse = STORE_RECORD . STORE_TABLE_DEFAULT;
        }
165

166
        // <form>
Carsten  Rose's avatar
Carsten Rose committed
167
168
169
        if ($mode === FORM_LOAD) {
            $htmlHead = $this->head();
        }
170

171
        $filter = $this->getProcessFilter();
172

173
        if ($this->formSpec['multiMode'] !== 'none') {
174

175
176
            $parentRecords = $this->db->sql($this->formSpec['multiSql']);
            foreach ($parentRecords as $row) {
177
                $this->store->setStore($row, STORE_PARENT_RECORD, true);
Carsten  Rose's avatar
Carsten Rose committed
178
                $jsonTmp = array();
179
                $htmlElements = $this->elements($row['_id'], $filter, 0, $jsonTmp, $modeCollectFe);
Carsten  Rose's avatar
Carsten Rose committed
180
                $json[] = $jsonTmp;
181
182
            }
        } else {
183
            $recordId = $this->store->getVar(SIP_RECORD_ID, STORE_SIP);
184
            $htmlElements = $this->elements($recordId, $filter, 0, $json, $modeCollectFe, $htmlElementNameIdZero, $storeUse, $mode);
Carsten  Rose's avatar
Carsten Rose committed
185
186

            if ($mode === FORM_SAVE && $recordId != 0) {
187
//                $json[] = [API_ELEMENT_UPDATE => [DIRTY_RECORD_HASH_MD5 => [API_ELEMENT_ATTRIBUTE => ['value' => $newMd5]]]];
Carsten  Rose's avatar
Carsten Rose committed
188
//                $json[] = [API_ELEMENT_UPDATE => [DIRTY_RECORD_HASH_MD5 =>  ['value' => $newMd5]]];
189
190
191
192
193
194
195
196

                // element-update: with 'content'
//                $inputMd5 = $this->buildInputRecordHashMd5(false);
//                $json[][API_ELEMENT_UPDATE][DIRTY_RECORD_HASH_MD5_SPAN][API_ELEMENT_CONTENT] = $inputMd5;

                // element-update: with 'value'
                $recordId = $this->store->getVar(SIP_RECORD_ID, STORE_SIP . STORE_ZERO);
                $md5 = $this->buildRecordHashMd5($this->formSpec[F_TABLE_NAME], $recordId);
197
198

                // Via 'element-update'
199
200
                $json[][API_ELEMENT_UPDATE][DIRTY_RECORD_HASH_MD5][API_ELEMENT_ATTRIBUTE]['value'] = $md5;

201
202
203
                // Via 'form-update'
//                $json[] =  [API_FORM_UPDATE_FORM_ELEMENT => DIRTY_RECORD_HASH_MD5, API_FORM_UPDATE_VALUE => $md5,
//                    API_FORM_UPDATE_DISABLED => false, API_FORM_UPDATE_REQUIRED => false ];
Carsten  Rose's avatar
Carsten Rose committed
204
            }
205
        }
206
207
208

        // <form>
        if ($mode === FORM_LOAD) {
209
            $htmlT3vars = $this->prepareT3VarsForSave();
210
211
212
            $htmlTail = $this->tail();
            $htmlSubrecords = $this->doSubrecords();
        }
213
        $htmlHidden = $this->buildAdditionalFormElements();
214

215
216
        $htmlSip = $this->buildHiddenSip($json);

217
        return ($mode === FORM_LOAD) ? $htmlHead . $htmlHidden . $htmlElements . $htmlSip . $htmlT3vars . $htmlTail . $htmlSubrecords : $json;
218
219
    }

220
    /**
221
     * Builds the head area of the form.
222
     *
223
     * @return string
224
     */
225
226
    public function head() {
        $html = '';
227

228
        $html .= '<div ' . Support::doAttribute('class', $this->formSpec[F_CLASS], true) . '>'; // main <div class=...> around everything
229

230
231
        // Logged in BE User will see a FormEdit Link
        $sipParamString = OnArray::toString($this->store->getStore(STORE_SIP), ':', ', ', "'");
232
        $formEditUrl = $this->createFormEditorUrl(FORM_NAME_FORM, $this->formSpec[F_ID]);
233

234
        $html .= "<p><a " . Support::doAttribute('href', $formEditUrl) . ">Edit</a> <small>[$sipParamString]</small></p>";
235

236
        $html .= $this->wrapItem(WRAP_SETUP_TITLE, $this->formSpec[F_TITLE], true);
237

238
239
240
        $html .= $this->getFormTag();

        return $html;
241
242
    }

243
    /**
244
245
     * If SHOW_DEBUG_INFO=yes: create a link (incl. SIP) to edit the current form. Show also the hidden content of
     * the SIP.
246
     *
247
     * @param string $form FORM_NAME_FORM | FORM_NAME_FORM_ELEMENT
Carsten  Rose's avatar
Carsten Rose committed
248
249
     * @param int    $recordId id of form or formElement
     * @param array  $param
250
251
252
     *
     * @return string String: <a href="?pageId&sip=....">Edit</a> <small>[sip:..., r:..., urlparam:...,
     *                ...]</small>
253
     * @throws CodeException
254
     */
255
    public function createFormEditorUrl($form, $recordId, array $param = array()) {
256

257
        if (!$this->showDebugInfoFlag) {
258
259
            return '';
        }
260

261
        $queryStringArray = [
262
            'id' => $this->store->getVar(SYSTEM_EDIT_FORM_PAGE, STORE_SYSTEM),
263
            'form' => $form,
264
            'r'  => $recordId,
265
        ];
266
        $queryStringArray = array_merge($queryStringArray, $param);
267

268
        $queryString = Support::arrayToQueryString($queryStringArray);
269

270
271
        $sip = $this->store->getSipInstance();
        $url = $sip->queryStringToSip($queryString);
272

273
        return $url;
274
275
276
    }

    /**
277
278
     * Wrap's $this->wrap[$item][WRAP_SETUP_START] around $value. If $flagOmitEmpty==true && $value=='': return ''.
     *
Carsten  Rose's avatar
Carsten Rose committed
279
280
     * @param string     $item
     * @param string     $value
281
     * @param bool|false $flagOmitEmpty
282
     *
283
284
285
     * @return string
     */
    public function wrapItem($item, $value, $flagOmitEmpty = false) {
286
287

        if ($flagOmitEmpty && $value === "") {
288
            return '';
289
290
        }

291
292
293
294
        return $this->wrap[$item][WRAP_SETUP_START] . $value . $this->wrap[$item][WRAP_SETUP_END];
    }

    /**
295
     * Returns '<form ...>'-tag with various attributes.
296
297
298
299
     *
     * @return string
     */
    public function getFormTag() {
Carsten  Rose's avatar
Carsten Rose committed
300
        $md5 = '';
301
302
303

        $attribute = $this->getFormTagAtrributes();

304
305
        $honeypot = $this->getHoneypotVars();

306
        $md5 = $this->buildInputRecordHashMd5();
Carsten  Rose's avatar
Carsten Rose committed
307
308
309
310
311
312

        return '<form ' . OnArray::toString($attribute, '=', ' ', "'") . '>' . $honeypot . $md5;
    }

    /**
     * Build MD5 from the current record. Return HTML Input element.
313
     *
314
     * @param bool $flagWithSpan
315
     *
316
317
318
     * @return string
     * @throws \qfq\CodeException
     * @throws \qfq\DbException
Carsten  Rose's avatar
Carsten Rose committed
319
     */
320
    public function buildInputRecordHashMd5() {
321

Carsten  Rose's avatar
Carsten Rose committed
322
        $recordId = $this->store->getVar(SIP_RECORD_ID, STORE_SIP . STORE_ZERO);
323
324
325
        $md5 = $this->buildRecordHashMd5($this->formSpec[F_TABLE_NAME], $recordId);

        $data = "<input id='" . DIRTY_RECORD_HASH_MD5 . "' name='" . DIRTY_RECORD_HASH_MD5 . "' type='hidden' value='$md5'>";
326

327
//        $data = "<input id='" . DIRTY_RECORD_HASH_MD5 . "' name='" . DIRTY_RECORD_HASH_MD5 . "' type='text' value='$md5'>";
328
329
330
331
332
333
334
335

        return $data;
    }


    /**
     * @param $tableName
     * @param $recordId
336
     *
337
338
339
340
     * @return string
     * @throws \qfq\CodeException
     * @throws \qfq\DbException
     */
341
    public function buildRecordHashMd5($tableName, $recordId) {
342
        $record = array();
Carsten  Rose's avatar
Carsten Rose committed
343
344

        if ($recordId != 0) {
345
            $record = $this->db->sql("SELECT * FROM $tableName WHERE id=?", ROW_EXPECT_1, [$recordId], "Record to load not found.");
Carsten  Rose's avatar
Carsten Rose committed
346
347
        }

348
        return OnArray::getMd5($record);
349
350
    }

351
352
353
354
355
356
357
358
359
360
361
362
363
    /**
     * Create HTML Input vars to detect bot automatic filling of forms.
     *
     * @return string
     */
    public function getHoneypotVars() {
        $html = '';

        $vars = $this->store->getVar(SYSTEM_SECURITY_VARS_HONEYPOT, STORE_SYSTEM);

        // Iterate over all fake vars
        $arr = explode(',', $vars);
        foreach ($arr as $name) {
364
365
366
367
            $name = trim($name);
            if ($name === '') {
                continue;
            }
368
369
370
371
372
            $html .= "<input name='$name' type='hidden' value='' readonly>";
        }

        return $html;
    }
373

Carsten  Rose's avatar
Carsten Rose committed
374

375
376
377
    /**
     * Build an assoc array with standard form attributes.
     *
378
     * @return array
379
380
381
     */
    public function getFormTagAtrributes() {

382
        $attribute['id'] = $this->getFormId();
383
384
385
386
387
388
389
390
391
392
        $attribute['method'] = 'post';
        $attribute['action'] = $this->getActionUrl();
        $attribute['target'] = '_top';
        $attribute['accept-charset'] = 'UTF-8';
        $attribute['autocomplete'] = 'on';
        $attribute['enctype'] = $this->getEncType();

        return $attribute;
    }

393
    /**
Carsten  Rose's avatar
Carsten Rose committed
394
395
     * Return a uniq form id
     *
396
397
398
399
400
401
     * @return string
     */
    public function getFormId() {
        if ($this->formId === null) {
            $this->formId = uniqid('qfq-form-');
        }
402

403
404
405
        return $this->formId;
    }

406
407
408
    /**
     * Builds the HTML 'form'-tag inlcuding all attributes and target.
     *
409
410
     * Notice: the SIP will be transferred as POST Parameter.
     *
411
412
413
414
415
     * @return string
     * @throws DbException
     */
    public function getActionUrl() {

416
        return API_DIR . '/save.php';
417
418
419
420
421
422
423
424
425
426
427
428
    }

    /**
     * Determines the enctype.
     *
     * See: https://www.w3.org/wiki/HTML/Elements/form#HTML_Attributes
     *
     * @return string
     * @throws DbException
     */
    public function getEncType() {

429
        $result = $this->db->sql("SELECT id FROM FormElement AS fe WHERE fe.formId=? AND fe.type='upload' LIMIT 1", ROW_REGULAR, [$this->formSpec['id']], 'Look for Formelement.type="upload"');
430

431
432
433
        return (count($result) === 1) ? 'multipart/form-data' : 'application/x-www-form-urlencoded';

    }
434

435
    abstract public function getProcessFilter();
436
437

    /**
438
     * Process all FormElements in $this->feSpecNative: Collect and return all HTML code & JSON.
439
     *
Carsten  Rose's avatar
Carsten Rose committed
440
     * @param int    $recordId
441
     * @param string $filter FORM_ELEMENTS_NATIVE | FORM_ELEMENTS_SUBRECORD | FORM_ELEMENTS_NATIVE_SUBRECORD
Carsten  Rose's avatar
Carsten Rose committed
442
443
     * @param int    $feIdContainer
     * @param array  $json
444
     * @param string $modeCollectFe
Carsten  Rose's avatar
Carsten Rose committed
445
     * @param bool   $htmlElementNameIdZero
446
     * @param string $storeUseDefault
447
     * @param string $mode FORM_LOAD | FORM_UPDATE | FORM_SAVE
448
     *
449
     * @return string
450
451
     * @throws CodeException
     * @throws DbException
452
     * @throws \qfq\UserFormException
453
     */
454
    public function elements($recordId, $filter = FORM_ELEMENTS_NATIVE, $feIdContainer = 0, array &$json,
455
                             $modeCollectFe = FLAG_DYNAMIC_UPDATE, $htmlElementNameIdZero = false,
456
                             $storeUseDefault = STORE_USE_DEFAULT, $mode = FORM_LOAD) {
457
        $html = '';
458

Carsten  Rose's avatar
Carsten Rose committed
459
460
//        $html .= $this->buildRecordHashMd5();

461
        // The following 'FormElement.parameter' will never be used during load (fe.type='upload'). FE_PARAMETER has been already expanded.
462
        $skip = [FE_SQL_UPDATE, FE_SQL_INSERT, FE_SQL_DELETE, FE_SQL_AFTER, FE_SQL_BEFORE, FE_PARAMETER];
463

464
        // get current data record
465
        if ($recordId > 0 && $this->store->getVar('id', STORE_RECORD) === false) {
466
467
            $tableName = $this->formSpec[F_TABLE_NAME];
            $row = $this->db->sql("SELECT * FROM $tableName WHERE id = ?", ROW_EXPECT_1,
468
469
                array($recordId), "Form '" . $this->formSpec[F_NAME] . "' failed to load record '$recordId' from table '" .
                $this->formSpec[F_TABLE_NAME] . "'.");
470
            $this->store->setStore($row, STORE_RECORD);
471
        }
472

473
474
        $this->checkAutoFocus();

475
476
        $parameterLanguageFieldName = $this->store->getVar(SYSTEM_PARAMETER_LANGUAGE_FIELD_NAME, STORE_SYSTEM);

477
478
        // Iterate over all FormElements
        foreach ($this->feSpecNative as $fe) {
479
            $storeUse = $storeUseDefault;
480

481
482
            if (($filter === FORM_ELEMENTS_NATIVE && $fe[FE_TYPE] === 'subrecord')
                || ($filter === FORM_ELEMENTS_SUBRECORD && $fe[FE_TYPE] !== 'subrecord')
483
//                || ($filter === FORM_ELEMENTS_DYNAMIC_UPDATE && $fe[FE_DYNAMIC_UPDATE] === 'no')
484
485
486
487
            ) {
                continue; // skip this FE
            }

Carsten  Rose's avatar
Carsten Rose committed
488
            $flagOutput = ($fe[FE_TYPE] !== FE_TYPE_EXTRA); // type='extra' will not displayed and not transmitted to the form
489

490
491
            $debugStack = array();

492
493
            // Preparation for Log, Debug
            $this->store->setVar(SYSTEM_FORM_ELEMENT, Logger::formatFormElementName($fe), STORE_SYSTEM);
494

Carsten  Rose's avatar
Carsten Rose committed
495
496
            // Fill STORE_LDAP
            $fe = $this->prepareFillStoreFireLdap($fe);
497

498
499
            // for Upload FormElements, it's necessary to precalculate an optional given 'slaveId'.
            if ($fe[FE_TYPE] === FE_TYPE_UPLOAD) {
500
                Support::setIfNotSet($fe, FE_SLAVE_ID);
501
502
                $slaveId = Support::falseEmptyToZero($this->evaluate->parse($fe[FE_SLAVE_ID]));
                $this->store->setVar(VAR_SLAVE_ID, $slaveId, STORE_VAR);
503
504
            }

Carsten  Rose's avatar
Carsten Rose committed
505
            // ** evaluate current FormElement **
506
            $formElement = $this->evaluate->parseArray($fe, $skip, $debugStack);
507
            $formElement = HelperFormElement::setLanguage($formElement, $parameterLanguageFieldName);
508

509
            // Some Defaults
510
            $formElement = Support::setFeDefaults($formElement, $this->formSpec);
511

512
513
514
515
516
517
518
//            // Copy global readonly mode.
//            if ($this->formSpec[F_MODE] == F_MODE_READONLY) {
//                $fe[FE_MODE] = FE_MODE_READONLY;
//                $fe[FE_MODE_SQL] = '';
//            }


519
            if ($flagOutput === true) {
520
                $this->fillWrapLabelInputNote($formElement[FE_BS_LABEL_COLUMNS], $formElement[FE_BS_INPUT_COLUMNS], $formElement[FE_BS_NOTE_COLUMNS]);
521
            }
522

523
524
            //In case the current element is a 'RETYPE' element: take the element name of the source FormElement. Needed in the next row to retrieve the default value.
            $name = (isset($formElement[FE_RETYPE_SOURCE_NAME])) ? $formElement[FE_RETYPE_SOURCE_NAME] : $formElement[FE_NAME];
525

526
527
528
            $value = '';
            Support::setIfNotSet($formElement, FE_VALUE);

529
530
531
            if (is_array($formElement[FE_VALUE])) {
                $formElement[FE_VALUE] = (count($formElement[FE_VALUE])) > 0 ? current($formElement[FE_VALUE][0]) : '';
            }
532

533
            $value = $formElement[FE_VALUE];
534

535
            if ($value === '') {
536
537
538
539
                // #2064 / Only take the default, if the FE is a real tablecolumn.
                // #3426 / Dynamic Update: Inputs loose the new content and shows the old value.
                if ($storeUse == STORE_USE_DEFAULT && $this->store->getVar($formElement[FE_NAME], STORE_TABLE_COLUMN_TYPES) === false) {
                    $storeUse = str_replace(STORE_TABLE_DEFAULT, '', $storeUse); // Remove STORE_DEFAULT
540
                }
541
542
                // Retrieve value via FSRVD
                $value = $this->store->getVar($name, $storeUse, $formElement[FE_CHECK_TYPE], $foundInStore);
543
544
545
546
            }

            if ($formElement[FE_ENCODE] === FE_ENCODE_SPECIALCHAR) {
                $value = htmlspecialchars_decode($value, ENT_QUOTES);
547
            }
548

549
550
            // Typically: $htmlElementNameIdZero = true
            // After Saving a record, staying on the form, the FormElements on the Client are still known as '<feName>:0'.
551
            $htmlFormElementName = HelperFormElement::buildFormElementName($formElement, ($htmlElementNameIdZero) ? 0 : $recordId);
552
553
554
            $formElement[FE_HTML_ID] = HelperFormElement::buildFormElementId($this->formSpec[F_ID], $formElement[FE_ID],
                ($htmlElementNameIdZero) ? 0 : $recordId,
                $formElement[FE_TG_INDEX]);
555

Carsten  Rose's avatar
Carsten Rose committed
556
            // Construct Marshaller Name: buildElement
557
            $buildElementFunctionName = 'build' . $this->buildElementFunctionName[$formElement[FE_TYPE]];
558

Carsten  Rose's avatar
Carsten Rose committed
559
            $jsonElement = array();
560
            $elementExtra = '';
561
            // Render pure element
562
            $elementHtml = $this->$buildElementFunctionName($formElement, $htmlFormElementName, $value, $jsonElement, $mode);
Carsten  Rose's avatar
Carsten Rose committed
563
564

            // container elements do not have dynamicUpdate='yes'. Instead they deliver nested elements.
565
            if ($formElement[FE_CLASS] == FE_CLASS_CONTAINER) {
Carsten  Rose's avatar
Carsten Rose committed
566
567
568
569
                if (count($jsonElement) > 0) {
                    $json = array_merge($json, $jsonElement);
                }
            } else {
570
                // for non-container elements: just add the current json status
571
                if ($modeCollectFe === FLAG_ALL || ($modeCollectFe == FLAG_DYNAMIC_UPDATE && $fe[FE_DYNAMIC_UPDATE] == 'yes')) {
Carsten  Rose's avatar
Carsten Rose committed
572
573
574
575
576
577
                    if (isset($jsonElement[0]) && is_array($jsonElement[0])) {
                        // Checkboxes are delivered as array of arrays: unnest them and append them to the existing json array.
                        $json = array_merge($json, $jsonElement);
                    } else {
                        $json[] = $jsonElement;
                    }
Carsten  Rose's avatar
Carsten Rose committed
578
579
                }
            }
580

581
582
            if ($flagOutput) {
                // debugStack as Tooltip
583
                if ($this->showDebugInfoFlag) {
584
585
586
587
588
                    if (count($debugStack) > 0) {
                        $elementHtml .= Support::doTooltip($formElement[FE_HTML_ID] . HTML_ID_EXTENSION_TOOLTIP, implode("\n", $debugStack));
                    }

                    // Build 'FormElement' Edit symbol
Carsten  Rose's avatar
Carsten Rose committed
589
                    $feEditUrl = $this->createFormEditorUrl(FORM_NAME_FORM_ELEMENT, $formElement[FE_ID], ['formId' => $formElement[FE_FORM_ID]]);
590
591
                    $titleAttr = Support::doAttribute('title', $this->formSpec[FE_NAME] . ' / ' . $formElement[FE_NAME] . ' [' . $formElement[FE_ID] . ']');
                    $icon = Support::wrapTag('<span class="' . GLYPH_ICON . ' ' . GLYPH_ICON_EDIT . '">', '');
592
                    $elementHtml .= Support::wrapTag("<a class='hidden " . CLASS_FORM_ELEMENT_EDIT . "' href='$feEditUrl' $titleAttr>", $icon);
593
                }
594

595
596
                // Construct Marshaller Name: buildRow
                $buildRowName = 'buildRow' . $this->buildRowName[$formElement[FE_TYPE]];
597

598
                $html .= $formElement[FE_HTML_BEFORE] . $this->$buildRowName($formElement, $elementHtml, $htmlFormElementName) . $formElement[FE_HTML_AFTER];
599
            }
600
        }
601

602
603
604
        // Log / Debug: Last FormElement has been processed.
        $this->store->setVar(SYSTEM_FORM_ELEMENT, '', STORE_SYSTEM);

605
606
607
        return $html;
    }

608
    /**
Carsten  Rose's avatar
Carsten Rose committed
609
610
611
612
613
     * Checks if LDAP search is requested.
     * Yes: prepare configuration and fire the query.
     * No: do nothing.
     *
     * @param array $formElement
614
     *
Carsten  Rose's avatar
Carsten Rose committed
615
616
617
618
619
620
621
622
     * @return array
     * @throws CodeException
     * @throws UserFormException
     */
    private function prepareFillStoreFireLdap(array $formElement) {
        $config = array();

        if (isset($formElement[FE_FILL_STORE_LDAP]) || isset($formElement[FE_TYPEAHEAD_LDAP])) {
623
624
625
            $keyNames = [F_LDAP_SERVER, F_LDAP_BASE_DN, F_LDAP_ATTRIBUTES,
                F_LDAP_SEARCH, F_TYPEAHEAD_LDAP_SEARCH, F_TYPEAHEAD_LDAP_SEARCH_PER_TOKEN, F_TYPEAHEAD_LDAP_SEARCH_PREFETCH,
                F_TYPEAHEAD_LIMIT, F_TYPEAHEAD_MINLENGTH, F_TYPEAHEAD_LDAP_VALUE_PRINTF,
626
                F_TYPEAHEAD_LDAP_ID_PRINTF, F_LDAP_TIME_LIMIT, F_LDAP_USE_BIND_CREDENTIALS];
627
            $formElement = OnArray::copyArrayItemsIfNotAlreadyExist($this->formSpec, $formElement, $keyNames);
Carsten  Rose's avatar
Carsten Rose committed
628
629
630
631
632
633
634
        } else {
            return $formElement; // nothing to do.
        }

        if (isset($formElement[FE_FILL_STORE_LDAP])) {

            // Extract necessary elements
635
            $config = OnArray::getArrayItems($formElement, [FE_LDAP_SERVER, FE_LDAP_BASE_DN, FE_LDAP_SEARCH, FE_LDAP_ATTRIBUTES]);
Carsten  Rose's avatar
Carsten Rose committed
636
637
            $config = $this->evaluate->parseArray($config);

638
            if ($formElement[FE_LDAP_USE_BIND_CREDENTIALS] == 1) {
639
640
641
642
                $config[SYSTEM_LDAP_1_RDN] = $this->store->getVar(SYSTEM_LDAP_1_RDN, STORE_SYSTEM);
                $config[SYSTEM_LDAP_1_PASSWORD] = $this->store->getVar(SYSTEM_LDAP_1_PASSWORD, STORE_SYSTEM);
            }

Carsten  Rose's avatar
Carsten Rose committed
643
644
645
646
647
648
649
650
            $ldap = new Ldap();
            $arr = $ldap->process($config, '', MODE_LDAP_SINGLE);
            $this->store->setStore($arr, STORE_LDAP, true);
        }

        return $formElement;
    }

651
652
653
654
655
656
657
    /**
     * Check if there is an explicit 'autofocus' definition in at least one FE.
     * Found: do nothing, it will be rendered at the correct position.
     * Not found: set 'autofocus' on the first FE.
     *
     * Accepted misbehaviour on forms with pills: if there is at least one editable element on the first pill,
     *   the other pills are not checked - independent if there was a definition on the first pill or not.
658
659
     *   Reason: checks happens per pill - if there is no explizit definition on the first pill, take the first
     *   editable element of that pill.
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
     */
    private function checkAutoFocus() {
        static $found = false;
        $idx = false;

        if ($found) {
            return;
        }

        // Search if there is an explicit autofocus definition.
        for ($i = 0; $i < count($this->feSpecNative); ++$i) {
            // Only check native elements which will be shown
            if ($this->feSpecNative[$i][FE_CLASS] == FE_CLASS_NATIVE &&
                ($this->feSpecNative[$i][FE_MODE] == FE_MODE_SHOW || $this->feSpecNative[$i][FE_MODE] == FE_MODE_REQUIRED)
            ) {
                // Check if there is an explicit definition.
                if (isset($this->feSpecNative[$i][FE_AUTOFOCUS])) {
                    if ($this->feSpecNative[$i][FE_AUTOFOCUS] == '' || $this->feSpecNative[$i][FE_AUTOFOCUS] == '1') {
                        $this->feSpecNative[$i][FE_AUTOFOCUS] = '1'; // fix to '=1'
                    } else {
                        unset($this->feSpecNative[$i][FE_AUTOFOCUS]);
                    }
                    $found = true;
683

684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
                    return;
                }

                if ($idx === false) {
                    $idx = $i;
                }
            }
        }

        // No explicit definition found: take the first found editable element.
        if ($idx !== false) {
            $found = true;
            // No explicit definition found: set autofocus.
            $this->feSpecNative[$idx][FE_AUTOFOCUS] = '1';
        }
    }

Carsten  Rose's avatar
Carsten Rose committed
701
702
703
    /**
     *
     */
704
705
    abstract public function fillWrapLabelInputNote($label, $input, $note);

706
    /**
707
708
     * Copy a subset of current STORE_TYPO3 variables to SIP. Set a hidden form field to submit the assigned SIP to
     * save/update.
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
     *
     * @throws CodeException
     * @throws UserFormException
     */
    private function prepareT3VarsForSave() {

        $t3VarsSip = $this->store->copyT3VarsToSip();

        return $this->buildNativeHidden(CLIENT_TYPO3VARS, $t3VarsSip);

    }

    /**
     * Builds a real HTML hidden form element. Useful for checkboxes, Multiple-Select and Radios.
     *
Carsten  Rose's avatar
Carsten Rose committed
724
725
     * @param        $htmlFormElementName
     * @param string $value
726
     *
727
728
     * @return string
     */
729
730
    public function buildNativeHidden($htmlFormElementName, $value) {
        return '<input type="hidden" name="' . $htmlFormElementName . '" value="' . htmlentities($value) . '">';
731
732
    }

Carsten  Rose's avatar
Carsten Rose committed
733
734
735
    /**
     *
     */
736
737
    abstract public function tail();

Carsten  Rose's avatar
Carsten Rose committed
738
739
740
    /**
     *
     */
741
742
    abstract public function doSubrecords();

743
744
745
746
747
748
749
750
751
752
753
754
755
756
    /**
     * Get all elements from STORE_ADDITIONAL_FORM_ELEMENTS and return them as a string.
     *
     * @return string
     * @throws CodeException
     * @throws \qfq\UserFormException
     */
    private function buildAdditionalFormElements() {

        $data = $this->store->getStore(STORE_ADDITIONAL_FORM_ELEMENTS);

        return is_array($data) ? implode('', $data) : '';
    }

757
758
759
    /**
     * Create a hidden sip, based on latest STORE_SIP Values. Return complete HTML 'hidden' element.
     *
760
     * @param array $json
761
     *
762
763
764
765
     * @return string  <input type='hidden' name='s' value='<sip>'>
     * @throws CodeException
     * @throws \qfq\UserFormException
     */
766
    public function buildHiddenSip(array &$json) {
767

768
        $sipArray = $this->store->getStore(STORE_SIP);
769
770

        // do not include system vars
771
772
773
774
775
776
777
778
        unset($sipArray[SIP_SIP]);
        unset($sipArray[SIP_URLPARAM]);

        $queryString = Support::arrayToQueryString($sipArray);
        $sip = $this->store->getSipInstance();

        $sipValue = $sip->queryStringToSip($queryString, RETURN_SIP);

779
        $json[] = $this->getFormElementForJson(CLIENT_SIP, $sipValue, [FE_MODE => FE_MODE_SHOW]);
780
781
782
783
784

        return $this->buildNativeHidden(CLIENT_SIP, $sipValue);
    }

    /**
785
786
     * Create an array with standard elements for 'mode' (hidden, disabled, required) and add 'form-element',
     * 'value'.
787
788
     * 'Generic Element Update': add via API_ELEMENT_UPDATE 'label' and 'note'.
     * All collected data as array - will be later converted to JSON.
Carsten  Rose's avatar
Carsten Rose committed
789
     *
Carsten  Rose's avatar
Carsten Rose committed
790
     * @param string       $htmlFormElementName
791
     * @param string|array $value
Carsten  Rose's avatar
Carsten Rose committed
792
     * @param array        $formElement
793
     *
794
795
     * @return array
     */
796
    private function getFormElementForJson($htmlFormElementName, $value, array $formElement) {
797

798
        $json = $this->getJsonFeMode($formElement[FE_MODE]); // disabled, required
799

800
        $json[API_FORM_UPDATE_FORM_ELEMENT] = $htmlFormElementName;
801
802
803
804
805
806
807

        if (isset($formElement[FE_FLAG_ROW_OPEN_TAG]) && isset($formElement[FE_FLAG_ROW_CLOSE_TAG])) {
            $flagRowUpdate = ($formElement[FE_FLAG_ROW_OPEN_TAG] && $formElement[FE_FLAG_ROW_CLOSE_TAG]);
        } else {
            $flagRowUpdate = true;
        }

808
        // 'value' update via 'form-update' on the full row: only if there is no other FE in that row
809
        if ($flagRowUpdate) {
810
            $json[API_FORM_UPDATE_VALUE] = $value;
811
        }
812

813
814
        if (isset($formElement[FE_LABEL])) {
            $key = $formElement[FE_HTML_ID] . HTML_ID_EXTENSION_LABEL;
815
            $json[API_ELEMENT_UPDATE][$key][API_ELEMENT_CONTENT] = $this->buildLabel($htmlFormElementName, $formElement[FE_LABEL]);
816
817
818
819
820
        }

        if (isset($formElement[FE_NOTE])) {
            $key = $formElement[FE_HTML_ID] . HTML_ID_EXTENSION_NOTE;
            $json[API_ELEMENT_UPDATE][$key][API_ELEMENT_CONTENT] = $formElement[FE_NOTE];
821
        }
822

823
        if (isset($formElement[FE_TYPE])) {
824
            $key = $formElement[FE_HTML_ID] . HTML_ID_EXTENSION_INPUT;
825
826
827
828
829
830
831
832
833
834
835
836

            // For FE.type='note': update the column 'input'
            if ($formElement[FE_TYPE] === FE_TYPE_NOTE) {
                $json[API_ELEMENT_UPDATE][$key][API_ELEMENT_CONTENT] = $value;
            }

            // Check show/hide: only FE with FE_MODE_SQL given, might change.
            if (!empty($formElement[FE_MODE_SQL])) {
                $class = 'col-md-' . $formElement[FE_BS_INPUT_COLUMNS] . ' ';
                $class .= ($formElement[FE_MODE] == FE_MODE_HIDDEN) ? 'hidden' : '';
                $json[API_ELEMENT_UPDATE][$key][API_ELEMENT_ATTRIBUTE]['class'] = $class;
            }
837
838
839
840
841

            // #3647
            if (!$flagRowUpdate) {
                $json[API_ELEMENT_UPDATE][$formElement[FE_HTML_ID]][API_ELEMENT_ATTRIBUTE]['value'] = $value;
            }
842
843
        }

844
        // Show / Hide the complete FormElement Row.
845
846
847
        if (isset($formElement[FE_HTML_ID])) { // HIDDEN_SIP comes without a real existing FE structure.
            // Activate 'show' or 'hidden' on the current FormElement via JSON 'API_ELEMENT_UPDATE'
            $class = $this->wrap[WRAP_SETUP_ELEMENT][WRAP_SETUP_CLASS];
848
            if ($formElement[FE_MODE] == FE_MODE_HIDDEN) {
849
850
851
852
853
854
855
                $class .= ' hidden';
            }

            $key = $formElement[FE_HTML_ID] . HTML_ID_EXTENSION_ROW;
            $json[API_ELEMENT_UPDATE][$key][API_ELEMENT_ATTRIBUTE]['class'] = $class;
        }

856
857
858
        return $json;
    }

859
860
861
862
    /**
     * Set corresponding JSON attributes readonly/required/disabled, based on $formElement[FE_MODE].
     *
     * @param array $feMode
863
     *
864
865
866
867
868
     * @return array
     * @throws UserFormException
     */
    private function getJsonFeMode($feMode) {

869
        $this->getFeMode($feMode, $dummy, $disabled, $required);
870

871
        return [API_FORM_UPDATE_DISABLED => $disabled === 'yes', API_FORM_UPDATE_REQUIRED => $required === 'yes'];
872
873
874
    }

    /**
Carsten  Rose's avatar
Carsten Rose committed
875
876
     * Depending of $feMode set variables $hidden, $disabled, $required to 'yes' or 'no'.
     *
Carsten  Rose's avatar
Carsten Rose committed
877
878
879
880
     * @param string $feMode
     * @param string $hidden
     * @param string $disabled
     * @param string $required
881
     *
882
883
884
885
886
887
888
889
890
891
892
893
894
895
     * @throws \qfq\UserFormException
     */
    private function getFeMode($feMode, &$hidden, &$disabled, &$required) {
        $hidden = 'no';
        $disabled = 'no';
        $required = 'no';

        switch ($feMode) {
            case FE_MODE_SHOW:
                break;
            case FE_MODE_REQUIRED:
                $required = 'yes';
                break;
            case FE_MODE_READONLY:
896
                $disabled = 'yes';  // convert the UI status 'readonly' to the HTML/CSS status 'disabled'.
897
898
899
900
901
902
903
904
905
906
                break;
            case FE_MODE_HIDDEN:
                $hidden = 'yes';
                break;
            default:
                throw new UserFormException("Unknown mode '$feMode'", ERROR_UNKNOWN_MODE);
                break;
        }
    }

907
908
909
910
911
    /**
     * Builds a label, typically for an html-'<input>'-element.
     *
     * @param string $htmlFormElementName
     * @param string $label
912
     * @param string $addClass
913
     *
914
915
     * @return string
     */
916
    public function buildLabel($htmlFormElementName, $label, $addClass = '') {
917
        $attributes = Support::doAttribute('for', $htmlFormElementName);
918
        $attributes .= Support::doAttribute('class', ['control-label', $addClass]);
919
920
921
922
923
924

        $html = Support::wrapTag("<label $attributes>", $label);

        return $html;
    }

Carsten  Rose's avatar
Carsten Rose committed
925
926
927
928
    /**
     * Takes the current SIP ('form' and additional parameter), set SIP_RECORD_ID=0 and create a new 'NewRecordUrl'.
     *
     * @throws CodeException
929
     * @throws \qfq\UserFormException
Carsten  Rose's avatar
Carsten Rose committed
930
931
     */
    public function deriveNewRecordUrlFromExistingSip(&$toolTipNew) {
932

933
934
935
        $urlParam = $this->store->getNonSystemSipParam();
        $urlParam[SIP_RECORD_ID] = 0;
        $urlParam[SIP_FORM] = $this->formSpec[F_NAME];
936
937

        Support::appendTypo3ParameterToArray($urlParam);
Carsten  Rose's avatar
Carsten Rose committed
938
939
940
941
942

        $sip = $this->store->getSipInstance();

        $url = $sip->queryStringToSip(OnArray::toString($urlParam));

943
        if ($this->showDebugInfoFlag) {
944
            //TODO: missing decoding of SIP
945
946
            $toolTipNew .= PHP_EOL . PHP_EOL . OnArray::toString($urlParam, ' = ', PHP_EOL, "'");
        }
Carsten  Rose's avatar
Carsten Rose committed
947
948
949
950

        return $url;
    }

951
    abstract public function buildRowPill(array $formElement, $elementHtml);
952

953
    abstract public function buildRowFieldset(array $formElement, $elementHtml);
954