Table of Contents

Appointments
Health
Goals for the day
Goals for the week

<html> <div style=“font-size:xx-large; font-weight: 900;”>20.04.2023 Donnerstag</div> </html>

Kalender, April, KW16

Appointments

None

Health

- Exercises
- - Rücken
  - - Morgens
  - - Abends
- - Augen
  - - Morgens
  - - Abends
- - Zunge
  - - Morgens
  - - Abends
- - Pr
  - - Morgens
  - - Abends

Goals for the day

- [AA] DBConv
- - fix error on saving
  - if the user changes the value of the field and do not change the focus to the next field, the click on “Save” does nothing. So it always necessary that the user changes focus to the next field before saving.

- [AA] ErtmerDataReader
- - Ask Torsten about “internal system for invoicing” (Fakturieren)
  - where?
    - Install F:\Downloads\accessruntime_4288-1001_x64_de-de.exe
    - Database under F:\Accessdatenbanken (WuGTaetigkeiten.accdb ?)
  - how?
  - when?
  - how much?
- - Use DBConv for data copying
  - In der Tabelle ROURESDET soll eine Art 'Stückliste' mit allen für die Baggeranlage lieferbaren Ersatzteilen hinterlegt werden. Fülle die Tabelle zunächst einmal so:
    - COMPANY: immer fix '01' - gilt für ALLE Tabellen
    - RESOURCE: die Baggernummer
    - ITEM: eine laufende Nr. je Bagger, bei 1 beginnend (muss man irgendwie in der Datenquelle 'erfinden')
    - RESDETTYPE: fix 20 für 'STL-Position'
    - REFRESOURCE: die Materialnummern aus der Baggerdatei (ggf. leer lassen)
    - STEXT: Kurztext…
    - LTEXT: Langtext
  - Check out DBConv project from Github: https://github.com/EffectiveCompany/dbconv
  - DBConv
    - Testdata and test project from Torsten:
      - C:\_projects\ertmer\csv\
    - Table can (should?) be used for tests:
      - efc_roures ⇒ resources
      - efc_rouresdet(?) ⇒ articles
    - Documentation: “G:\Geteilte Ablagen\WuG_Cloud\Build\Doku\DBConv.pdf”
- - Ask Klaus which table and columns should be used as target

- [AA] FertigungsmodulPerformance
- - The first 5 SELECTs which takes most long time
  - - which selects take long
    - see MdMatMrpBrrRepositoryImpl.getBoFromDb()
      - starting with comment Infotexte nachladen
        
        bo.info_roumatnum = svSysInfoText.getMatnumBoRouDoc(rdb.company, rdb.roudockey, rdb.roudocnum)
        
        bo.info_bommatnum = svSysInfoText.getMatnumBoBomDoc(rdb.company, rdb.bomdockey, rdb.bomdocnum)
      - …
      - see DaoPrddocoprschImpl.save(DBPrddocoprsch record,boolean withHistory)
        
        the code can be optimized?
        
        first try to update save
  - - how many selects is it
  - - where are these selects (in Java/Groovy code)
  - - are they really necessary?
- Test Netzplan
  - Menu:
    - Fertigung → Fertigungbelege
    - search for first (all?)
    - in the Top-menu: “Gehe zu / Netzplan”
  - Fix the problems with the URL, which doesn't work:
    - https://localhost:8443/efcserver/efc/resources/graph.html

- [AC] efc ERP HandbuchKompakt
- - 1. Einführung

- [AC] “Personal Questionnaire” from Wühler & Gebauer
- - meine Sozialversicherungsausweisnummer?
  - 24081171K032
- - meine Steuerklasse?
  - - current(5) or future?
- waiting for answer from Hans Peter Wühler

Goals for the week

Avril
- [AB] publish new app version
  - [AA] more stable MQTT connection
  - [AB] targetSdkVersion = 29
- [AC] Implement possibility to add new users for admins
Tracker For Traccar
- [AB] targetSdkVersion = 29
- [AB] Implement trips
  - [AB] List screen
  - [AB] Details screen
- [BA] при работе приложения вместе с таскером traccar.intent.action.START_SERVICE работает как надо, а STOP_SERVICE изменяет состояние, т.е. если служба была остановлена, то она запускается, и наоборот.
- [BA] поменяйте имя параметра BATTERY на batt
- [BA] добавьте параметр charging (булево), который будет означать заряжается телефон или нет.
- [BA] Check: в 9-ом Андроиде HTTP по умолчанию запрещен
- [CA] сделать возможность изменения периода отправки координат на сервер с помощью таскера (возможно и других настроек тоже).