Notes:

Produktion:

• mengeoriginal -> ?
• mengeaussschuss -> Quantity produced but scrap
• mengeerfolgreich -> Quantitiy produced -> Used in list display
• lager_ok etc. 0 - not, 1 - ok, 2 - partial

Produktion_position:

• stuecklistestufe = 1 -> Item to be produced

• stuecklistestufe = 0 -> Item to be consumed

• menge -> quantity planned

• geliefert_menge -> quantity produced (including scrap) / consumed

Lager_bewegung:

• Log for production / consumption (used in abschluss page)

Process:

• Plan quantities (stueckliste*quantity)
• Wait for stock available
• Reserve stock
• Do production (produced quantity, scrap quantity)
  • Optionally modify consumption
  • Remove consumed items from stock (according to production quantity and consumption recipe), reduce reservations
  • Put produced items in stock (production quantity, scrap quantity)
• Close production, free remaining reservations

Status:

• angelegt
• freigegeben
• gestartet
• abgeschlossen
• storniert

Movement of parts possible through erpapi? function LieferscheinAuslagern($lieferschein,$anzeige_lagerplaetze_in_lieferschein=false, $standardlager = 0, $belegtyp = 'lieferschein', $chargenmhdnachprojekt = 0, $forceseriennummerngeliefertsetzen = false,$nurrestmenge = false, $lager_platz_vpe = 0, $lpiid = 0)

belegtyp === 'produktion' omits the first item in the itemlist (same as stuecklistestufe = 1?) nurrestmenge = true -> menge_x = menge - menge_geliefert

function LagerEinlagern($artikel,$menge,$regal,$projekt,$grund="",$importer="",$paketannahme="",$doctype = "", $doctypeid = 0, $vpeid = 0, $permanenteinventur = 0, $adresse = 0)

Check: function LagerFreieMenge($artikel, $mitautolagersperre = false, $standardlager = 0, $projektlager = 0)

Automatic order processing "module=auftrag&action=versandzentrum" does not show the list and the error "Die letzte Berechnung der Auftragsampeln wurde noch nicht ermittelt. (Information)".

flag "speziallieferschein" in table "Projekt" must be set. Option in settings is missing, restore HTML form.

www/widgets/templates/_gen/projekt.tpl

when using multidb.conf.php

Error when using cronjob # /usr/bin/php8.1 /var/www/html/openxe-v.1.6/cronjobs/starter2.php

PHP Warning: Undefined array key "cronjob" in /var/www/html/openxe-v.1.6/classes/Core/LegacyConfig/MultiDbArrayHydrator.php on line 51

Change

// Cronjobs nur aktivieren, wenn Einstellung vorhanden und gesetzt (Default `false`).
$cronjobsActive = (int)$item['cronjob'] === 1;

To:

// Cronjobs nur aktivieren, wenn Einstellung vorhanden und gesetzt (Default `false`).
if (array_key_exists('cronjob',$item)) {
    $cronjobsActive = (int)$item['cronjob'] === 1;
} else {
    $cronjobsActive = false;
}

www/lib/dokumente/class.briefpapier.php

Call of function Cell() is incorrect, suggest change function to typed paramers and correct all calls.

Actual:

$this->Cell(30,3,$this->app->erp->Beschriftung('dokument_zzglmwst').' '.$k.' %',0,'L','L'); //1

Korrekt:

$this->Cell(30,3,$this->app->erp->Beschriftung('dokument_zzglmwst').' '.$k.' %',0,0,'L'); //1

Also check which library is used and purge unused ones.

./www/lib/pdf/fpdf_3.php:871: function Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=false, $link='')

./www/lib/pdf/fpdf_org.php:576:function Cell($w, $h=0, $txt='', $border=0, $ln=0, $align='', $fill=false, $link='')

./www/lib/pdf/fpdf_2.php:807: function Cell($w,$h=0,$txt='',$border=0,$ln=0,$align='',$fill=0,$link='',$noln=false)

./www/lib/pdf/fpdf.php:721: function Cell($w,$h=0,$txt='',$border=0,$ln=0,$align='',$fill=0,$link='')

Leads to exception on MariaDB. Rewrite possible with TIMESTAMPDIFF.

many cases in erpapi

e.g. SELECT * FROM sqlcache WHERE DATE_DIFF(zeitstempel, INTERVAL 10 SECOND) < NOW()

SELECT * FROM sqlcache WHERE TIMESTAMPDIFF(SECOND,zeitstempel, NOW()) > 10

DELETE FROM sqlcache WHERE shortcode = 'artikel' AND DATE_DIFF(zeitstempel, NOW()) > INTERVAL 120 SECOND

DELETE FROM sqlcache WHERE shortcode = 'artikel' AND TIMESTAMPDIFF(SECOND,zeitstempel, NOW()) > 120

replace "www/pages/shopimporter_shopware6.php" row 3020:

return count($ordersToProcess['data']);

with

return (!empty(count($ordersToProcess['data'])?count($ordersToProcess['data']):0);

Tables

• task_timeline (missing)
• preisanfrage (missing)

Columns

• nettogewicht FROM artikel (missing)
• sprache (varchar(32)) FROM verbindlichkeit (missing)

live rewrite of ticket text needed, information is not in database, but in mail.txt.

Suggest live parsing of mail.txt or (better) extension of file data in DB (migration needed)

Formatting of Numbers in SQL use $this->app->erp->FormatMenge or $this->app->erp->FormatBetrag ONLY for display, NEVER for use in calculations.

For output formatting must be done with locale... (where? how? what?)