20.04.2023 Donnerstag
[[Kalender]], [[http://vwiki.wialon-consulting.de/doku.php?id=kalender#april|April]], [[2023KW16|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] сделать возможность изменения периода отправки координат на сервер с помощью таскера (возможно и других настроек тоже).