Project

General

Profile

Actions

Feature #12145

closed

Add frontend Form Json editor and disable Sync

Added by Marc Egger over 1 year ago. Updated 3 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Carsten Rose
Target version:
-
Start date:
15.03.2021
Due date:
% Done:

100%

Estimated time:
Discuss:
Prio Planung:
No

Description

Da der Sync ein komplizierter Ablauf ist, der uns momentan noch nicht viel bring, koennen wir diesen ausschalten und stattdessen einen Form Json editor im Frontend anbieten.
Damit ermöglichen wir alle Vorteile die FAF momentan bringt ohne dass wir den komplizierten Sync Prozess haben.

  • Add feature flag `FEATURE_FORM_SYNC` als constant in Constants.php and set to `false`
  • disable all form sync functionality if feature flag is `false`
  • Json im FE bearbeiten
  • Json export als download file
  • Json import als file (download ist wichtiger!)

Related issues

Related to QFQ - Feature #11890: option to disable form as file syncClosedMarc Egger22.01.2021

Actions
Related to QFQ - Support #12123: Sync nach dem Form-UpdateClosedMarc Egger10.03.2021

Actions
Related to QFQ - Bug #11287: [QFQ as File] Duplicating formsClosedMarc Egger09.10.2020

Actions
Related to QFQ - Bug #12314: Check Multi DB setupClosedCarsten Rose04.04.2021

Actions
Related to QFQ - Bug #12325: MultiDB form.dbIndex not working for report syntaxPriorizeCarsten Rose06.04.2021

Actions
Actions #1

Updated by Marc Egger over 1 year ago

  • Description updated (diff)
Actions #2

Updated by Marc Egger over 1 year ago

  • Related to Feature #11890: option to disable form as file sync added
Actions #3

Updated by Marc Egger over 1 year ago

Actions #4

Updated by Marc Egger over 1 year ago

  • Status changed from New to In Progress
Actions #5

Updated by Marc Egger over 1 year ago

  • Related to Bug #11287: [QFQ as File] Duplicating forms added
Actions #6

Updated by Marc Egger over 1 year ago

  • Status changed from In Progress to Priorize
Actions #7

Updated by Marc Egger over 1 year ago

  • Status changed from Priorize to In Progress
Actions #8

Updated by Marc Egger over 1 year ago

  • Description updated (diff)
Actions #9

Updated by Marc Egger over 1 year ago

Carsten hat gefragt, ob wir die special column _formJsonBase64 nicht mit einem SQL statement ersetzen koennen, das in Base64 codiert. Tatsächlich gibt es in MariaDb die Funktion TO_BASE64.
Allerdings müsste ich das json zuerst raus holen mit _formJson und dann dies zum SQL server senden.

Nach meiner Ansicht lohnt sich dies nicht, da wir dadurch die wahrscheinlichkeit nur erhöhen, dass das Json bei der encodierung oder beim wechsel zu Mysql unerwartet verändert wird.

Actions #10

Updated by Marc Egger over 1 year ago

PHP json_encode() dekodiert umlaute in escape sequences per default. Ich habe dies mit hilfe eines flags ausgeschaltet:

JSON_UNESCAPED_UNICODE (int)
Encode multibyte Unicode characters literally (default is to escape as \uXXXX). Available as of PHP 5.4.0.

doku: https://www.php.net/manual/en/json.constants.php

Actions #11

Updated by Marc Egger over 1 year ago

  • Related to Bug #12314: Check Multi DB setup added
Actions #12

Updated by Marc Egger over 1 year ago

Cron Job beispiel in's Manual (z.B.: http://docs.qfq.io/en/master/Installation.html - ganz am Ende) schreiben:

0 19 * * * find /var/www/html/fileadmin/protected/qfqProject/form/.backup/ -type f -mtime +31  -exec rm {} \;
Actions #13

Updated by Marc Egger over 1 year ago

  • Related to Bug #12325: MultiDB form.dbIndex not working for report syntax added
Actions #14

Updated by Marc Egger over 1 year ago

  • Status changed from In Progress to New
  • Assignee changed from Marc Egger to Carsten Rose

Merge request geöffnet und Carsten zugewiesen. https://git.math.uzh.ch/typo3/qfq/-/merge_requests/332

Actions #15

Updated by Marc Egger over 1 year ago

  • Status changed from New to Feedback
Actions #16

Updated by Carsten Rose 6 months ago

  • Status changed from Feedback to Closed
Actions #17

Updated by Carsten Rose 3 months ago

  • Target version changed from next5 to 22.8.0
Actions #18

Updated by Carsten Rose 3 months ago

  • Target version deleted (22.8.0)
  • Prio Planung set to No
Actions

Also available in: Atom PDF