AI has made a conversion script to create a phar file from an export of a language in Crowdin.

Feel free to use at your own convenience.

`#!/usr/bin/env php
<?php
/**

xliff2phar.php - Converteer een Crowdin XLIFF-export naar een osTicket PHAR taalbestand
*
Gebruik:
php -dphar.readonly=0 xliff2phar.php <xliff_bestand_of_map> [--lang=nl] [--osticket-path=./osTicket]
[--output=nl.phar] [--yaml-source=map_of.phar] [--po=controle.po] [--quiet]
*
Voorbeeld (Crowdin-export van project osticket-official, versie 1.18.x):
php -dphar.readonly=0 xliff2phar.php 1.18.x_nl.xliff --lang=nl --osticket-path=./osTicket
*
Wat het doet:
- LC_MESSAGES/messages.po uit de XLIFF -> LC_MESSAGES/messages.mo.php (direct in PHP, geen msgfmt)
inclusief msgctxt (context) en meervoudsvormen (x-gettext-plurals)
- Alle YAML-bestanden uit de XLIFF -> vertaalde YAML (en_US-structuur + vertaalde waarden)
- js/osticket-strings.js (alle __('...') uit de osTicket JS), js/redactor.js,
js/jquery.ui.datepicker.js (GitHub), MANIFEST.php, SHA1-handtekening
*
Vereisten:
- PHP 7.4+ met de Phar-extensie (en phar.readonly=0)
- osTicket-broncode van dezelfde versie (voor en_US YAML, Spyc.php, JS en redactor)
- Internet alleen voor de jQuery UI datepicker (anders via --yaml-source=oude.phar)
*/

// ============================================================================
// XLIFF PARSER
// ============================================================================

class XliffParser {
private $translations = array();
private $yamlUnits = array(); // relatief pad => [[pad-array, vertaling|null], ...]
private $header = '';
private $sourceLanguage = 'en';
private $targetLanguage = 'nl';
private $pluralForms = 'nplurals=2; plural=(n != 1);';

/**
 * Parse een XLIFF bestand en verzamel vertalingen
 */
public function parse($xliffFile) {
    $xml = file_get_contents($xliffFile);
    $dom = new DOMDocument();
    $dom->preserveWhiteSpace = false;
    @$dom->loadXML($xml);

    $this->parseDom($dom);
}

/**
 * Parse een DOMDocument
 */
private function parseDom(DOMDocument $dom) {
    // Bepaal de namespace (XLIFF 1.2 gebruikt urn:oasis:names:tc:xliff:document:1.2)
    $ns = null;
    $root = $dom->documentElement;
    if ($root && $root->namespaceURI) {
        $ns = $root->namespaceURI;
    }

    // XLIFF 1.2 - gebruik namespace-aware queries indien nodig
    if ($ns) {
        $files = $dom->getElementsByTagNameNS($ns, 'file');
    } else {
        $files = $dom->getElementsByTagName('file');
    }
    foreach ($files as $file) {
        $sourceLang = $file->getAttribute('source-language');
        $targetLang = $file->getAttribute('target-language');
        if ($sourceLang) $this->sourceLanguage = $sourceLang;
        if ($targetLang) {
            // Normaliseer taalcode: streepjes naar underscores
            $this->targetLanguage = self::toLocale($targetLang);
        }

        // Parse header voor metadata
        $header = $file->getElementsByTagName('header')->item(0);
        if ($header) {
            // XLIFF 2.0 notes
            $notes = $header->getElementsByTagName('note');
            foreach ($notes as $note) {
                $this->header .= $note->textContent . "\n";
            }
        }

        // Crowdin zet alle bestanden in één XLIFF: YAML-bestanden apart verzamelen
        $original = $file->getAttribute('original');
        if (preg_match('/\.ya?ml$/i', $original)) {
            $this->parseYamlFile($file, $original);
            continue;
        }

        // Parse translation units
        if ($ns) {
            $units = $file->getElementsByTagNameNS($ns, 'trans-unit');
        } else {
            $units = $file->getElementsByTagName('trans-unit');
        }
        foreach ($units as $unit) {
            // Units binnen een plural-groep worden via parsePluralGroup verwerkt
            $parent = $unit->parentNode;
            if ($parent instanceof DOMElement && $parent->localName === 'group'
                    && $parent->getAttribute('restype') === 'x-gettext-plurals') {
                continue;
            }
            $this->parseTransUnit($unit);
        }
        $groups = $ns ? $file->getElementsByTagNameNS($ns, 'group') : $file->getElementsByTagName('group');
        foreach ($groups as $group) {
            if ($group->getAttribute('restype') === 'x-gettext-plurals') {
                $this->parsePluralGroup($group);
            }
        }
    }

    // XLIFF 2.0 ondersteuning
    if ($ns) {
        $units2 = $dom->getElementsByTagNameNS($ns, 'unit');
    } else {
        $units2 = $dom->getElementsByTagName('unit');
    }
    if ($units2->length > 0 && count($this->translations) === 0) {
        foreach ($units2 as $unit) {
            $this->parseUnit2($unit);
        }
    }
}

/**
 * Zoek de gettext-context (msgctxt) van een element.
 * Ondersteunt <note from="context"> en <context context-type="context|x-gettext-msgctxt|msgctxt">.
 */
private function findContext(DOMElement $el) {
    // Crowdin: <context context-type="source">#: bestand.php:12\nmsgctxt</context>
    foreach ($el->getElementsByTagName('context') as $c) {
        if ($c->getAttribute('context-type') !== 'source') continue;
        $ctx = '';
        foreach (explode("\n", $c->textContent) as $line) {
            if (trim($line) !== '' && $line[0] !== '#') $ctx = rtrim($line, "\r");
        }
        if ($ctx !== '') return $ctx;
    }
    foreach ($el->childNodes as $c) {
        if (!($c instanceof DOMElement)) continue;
        if ($c->localName === 'note' && $c->getAttribute('from') === 'context') {
            return $c->textContent;
        }
        if ($c->localName === 'context-group') {
            foreach ($c->childNodes as $cc) {
                if ($cc instanceof DOMElement && $cc->localName === 'context'
                        && in_array($cc->getAttribute('context-type'), array('context', 'x-gettext-msgctxt', 'msgctxt'))) {
                    return $cc->textContent;
                }
            }
        }
        if ($c->localName === 'context'
                && in_array($c->getAttribute('context-type'), array('context', 'x-gettext-msgctxt', 'msgctxt'))) {
            return $c->textContent;
        }
    }
    return '';
}

private function child(DOMElement $el, $name) {
    foreach ($el->childNodes as $c) {
        if ($c instanceof DOMElement && $c->localName === $name) return $c;
    }
    return null;
}

/** Sleutel zoals osTicket die gebruikt: context . "\x04" . msgid */
private static function key($msgid, $context) {
    return $context !== '' ? $context . "\x04" . $msgid : $msgid;
}

/**
 * Crowdin geeft soms alleen de taal ("nl"); osTicket verwacht een locale ("nl_NL")
 */
public static function toLocale($code) {
    $code = str_replace('-', '_', trim($code));
    if (strpos($code, '_') !== false) return $code;
    $likely = array('nl'=>'NL','de'=>'DE','fr'=>'FR','es'=>'ES','it'=>'IT','pt'=>'PT','sv'=>'SE',
        'da'=>'DK','nb'=>'NO','fi'=>'FI','pl'=>'PL','cs'=>'CZ','ja'=>'JP','zh'=>'CN','ru'=>'RU',
        'tr'=>'TR','el'=>'GR','uk'=>'UA','ko'=>'KR','he'=>'IL','ar'=>'SA','en'=>'US','hu'=>'HU',
        'ro'=>'RO','sk'=>'SK','sl'=>'SI','hr'=>'HR','bg'=>'BG','lt'=>'LT','lv'=>'LV','et'=>'EE');
    $l = strtolower($code);
    return isset($likely[$l]) ? $l . '_' . $likely[$l] : $code;
}

/**
 * Is deze vertaling echt vertaald? Crowdin exporteert onvertaalde strings
 * als <target> zonder state-attribuut met een kopie van de brontekst.
 */
private function isTranslated(DOMElement $unit, $target, $sourceText, $targetText) {
    if (!$target || trim($targetText) === '') return false;
    $state = $target->getAttribute('state');
    if (in_array($state, array('new', 'needs-translation'))) return false;
    if ($state !== '' || $unit->getAttribute('approved') === 'yes') return true;
    return $targetText !== $sourceText;
}

/**
 * Verzamel de waarden van een Crowdin YAML-bestand.
 * Het pad staat in de context als "0 -> fields -> 0 -> label".
 */
private function parseYamlFile(DOMElement $file, $original) {
    // "/1.18.x/help/tips/x.yaml" -> "help/tips/x.yaml"
    $rel = ltrim($original, '/');
    $parts = explode('/', $rel);
    if (count($parts) > 1 && preg_match('/^\d+\.\d+/', $parts[0])) array_shift($parts);
    $rel = implode('/', $parts);

    foreach ($file->getElementsByTagName('trans-unit') as $unit) {
        $source = $this->child($unit, 'source');
        $target = $this->child($unit, 'target');
        $path = null;
        foreach ($unit->getElementsByTagName('context') as $c) {
            if ($c->getAttribute('context-type') === 'source') {
                $first = explode("\n", $c->textContent)[0];
                $path = array_values(array_filter(array_map('trim', explode('->', $first)), 'strlen'));
                break;
            }
        }
        if (!$path) {
            $path = explode('.', $unit->getAttribute('resname'));
        }
        $src = $source ? $this->getElementText($source) : '';
        $tgt = $target ? $this->getElementText($target) : '';
        $this->yamlUnits[$rel][] = array($path, $src,
            $this->isTranslated($unit, $target, $src, $tgt) ? $tgt : null);
    }
    if (!isset($this->yamlUnits[$rel])) $this->yamlUnits[$rel] = array();
}

public function getYamlUnits() {
    return $this->yamlUnits;
}

/**
 * Parse een XLIFF 1.2 trans-unit (enkelvoud)
 */
private function parseTransUnit(DOMElement $unit) {
    $source = $this->child($unit, 'source');
    $target = $this->child($unit, 'target');
    if (!$source || !$target) return;

    $sourceText = $this->getElementText($source);
    $targetText = $this->getElementText($target);
    if (!$this->isTranslated($unit, $target, $sourceText, $targetText)) return;

    $this->translations[self::key($sourceText, $this->findContext($unit))] = $targetText;
}

/**
 * Parse een Crowdin/gettext plural-groep:
 * <group restype="x-gettext-plurals"><trans-unit id="N[0]">...<trans-unit id="N[1]">...
 */
private function parsePluralGroup(DOMElement $group) {
    $forms = array();
    $context = $this->findContext($group);
    foreach ($group->childNodes as $unit) {
        if (!($unit instanceof DOMElement) || $unit->localName !== 'trans-unit') continue;
        $idx = preg_match('/\[(\d+)\]$/', $unit->getAttribute('id'), $m) ? (int)$m[1] : count($forms);
        $src = $this->child($unit, 'source');
        $tgt = $this->child($unit, 'target');
        if ($context === '') $context = $this->findContext($unit);
        $srcText = $src ? $this->getElementText($src) : '';
        $tgtText = $tgt ? $this->getElementText($tgt) : '';
        $forms[$idx] = array(
            'source' => $srcText,
            'target' => $tgtText,
            'done' => $this->isTranslated($unit, $tgt, $srcText, $tgtText),
        );
    }
    if (count($forms) < 1) return;
    ksort($forms);
    $forms = array_values($forms);

    $singular = $forms[0]['source'];
    $plural = isset($forms[1]) ? $forms[1]['source'] : $singular;
    $targets = array();
    foreach ($forms as $f) {
        if (!$f['done']) return;   // alleen volledig vertaalde meervoudsvormen
        $targets[] = $f['target'];
    }
    // Alleen opnemen als alle vormen vertaald zijn
    if (!$targets || in_array('', array_map('trim', $targets), true)) return;

    $this->translations[self::key($singular . "\x00" . $plural, $context)] = implode("\x00", $targets);
}

/**
 * Parse een XLIFF 2.0 unit
 */
private function parseUnit2(DOMElement $unit) {
    $id = $unit->getAttribute('id');
    $ns = $unit->namespaceURI;

    $segments = $ns ? $unit->getElementsByTagNameNS($ns, 'segment') : $unit->getElementsByTagName('segment');
    foreach ($segments as $segment) {
        $source = $ns ? $segment->getElementsByTagNameNS($ns, 'source')->item(0) : $segment->getElementsByTagName('source')->item(0);
        $target = $ns ? $segment->getElementsByTagNameNS($ns, 'target')->item(0) : $segment->getElementsByTagName('target')->item(0);

        if (!$source) continue;

        $sourceText = $this->getElementText($source);
        $targetText = $target ? $this->getElementText($target) : '';

        if (trim($targetText) === '') continue;

        $this->translations[$sourceText] = $targetText;
    }
}

/**
 * Krijg de tekst inhoud van een element, inclusief XML tags als tekst
 */
private function getElementText(DOMElement $element) {
    $text = '';
    foreach ($element->childNodes as $child) {
        if ($child->nodeType === XML_TEXT_NODE || $child->nodeType === XML_CDATA_SECTION_NODE) {
            $text .= $child->textContent;
        } elseif ($child->nodeType === XML_ELEMENT_NODE) {
            // Behandel geneste elementen (zoals <g>, <x>, etc.) als hun tekst
            if ($child->tagName === 'g') {
                $text .= $this->getElementText($child);
            } elseif ($child->tagName === 'x' || $child->tagName === 'bx' || $child->tagName === 'ex') {
                // Placeholder voor variabele
                $equiv = $child->getAttribute('equiv-text');
                $ctype = $child->getAttribute('ctype');
                if ($equiv) {
                    $text .= $equiv;
                } elseif ($ctype) {
                    $text .= '{' . $ctype . '}';
                }
            } else {
                $text .= $this->getElementText($child);
            }
        }
    }
    return $text;
}

/**
 * PO-header regels (gedeeld door toPO() en toHashTable())
 */
private function headerLines() {
    return array(
        'Project-Id-Version' => 'osticket-official',
        'X-Osticket-Major-Version' => '1.18',
        'Report-Msgid-Bugs-To' => 'support@osticket.com',
        'Language' => $this->targetLanguage,
        'MIME-Version' => '1.0',
        'Content-Type' => 'text/plain; charset=UTF-8',
        'Content-Transfer-Encoding' => '8bit',
        'X-Generator' => 'xliff2phar.php',
        'Plural-Forms' => $this->pluralForms,
        'PO-Revision-Date' => date('Y-m-d H:iO'),
        'Language-Team' => 'Dutch',
    );
}

/**
 * Laat msgstr wel/niet eindigen op newline, net als msgid (zoals msgfmt eist)
 */
private static function normalizeNewline($msgid, $msgstr) {
    $idNL = substr($msgid, -1) === "\n";
    $strNL = substr($msgstr, -1) === "\n";
    if ($idNL && !$strNL) return $msgstr . "\n";
    if (!$idNL && $strNL) return rtrim($msgstr, "\n");
    return $msgstr;
}

/**
 * Bouw direct de osTicket vertaaltabel (inhoud van messages.mo.php),
 * zonder PO/MO en zonder msgfmt. Formaat identiek aan
 * Translation::buildHashFile() in osTicket:
 *   ''                    => PO-header
 *   msgid                 => msgstr
 *   ctx . "\x04" . msgid  => msgstr   (context)
 *   sg . "\0" . pl        => f0 . "\0" . f1 ...   (meervoud)
 *   0                     => metadata
 */
public function toHashTable() {
    $header = '';
    foreach ($this->headerLines() as $k => $v) {
        $header .= "$k: $v\n";
    }
    $table = array('' => $header);

    // Waarden 1-op-1 overnemen, net als osTicket: geen normalisatie nodig
    foreach ($this->translations as $key => $msgstr) {
        $table[(string) $key] = $msgstr;
    }

    $total = count($table);
    $table[0] = array(
        'Revision' => 0,
        'Total-Strings' => $total,
        'Table-Size' => $total + 1,
        'Build-Timestamp' => gmdate(DATE_RFC822),
        'Format-Version' => 'A',
        'Encoding' => 'UTF-8',
    );
    return $table;
}

/**
 * Genereer een PO bestand uit de verzamelde vertalingen (optioneel, voor controle)
 */
public function toPO() {
    $po = 'msgid ""' . "\n" . 'msgstr ""' . "\n";
    foreach ($this->headerLines() as $k => $v) {
        $po .= $this->poQuote("$k: $v\n") . "\n";
    }
    $po .= "\n";

    // Vertalingen
    foreach ($this->translations as $key => $msgstr) {
        $key = (string) $key;
        $msgid = $key;
        if (strpos($key, "\x04") !== false) {
            list($ctx, $msgid) = explode("\x04", $key, 2);
            $po .= 'msgctxt ' . $this->poQuote($ctx) . "\n";
        }
        // msgfmt eist dat msgid en msgstr beide wel/niet op \n eindigen
        $first = explode("\x00", $msgid)[0];
        $msgstr = implode("\x00", array_map(function ($t) use ($first) {
            return self::normalizeNewline($first, $t);
        }, explode("\x00", $msgstr)));

        // Controleer op plural (msgid bevat \x00)
        if (strpos($msgid, "\x00") !== false) {
            $parts = explode("\x00", $msgid);
            $po .= 'msgid ' . $this->poQuote($parts[0]) . "\n";
            $po .= 'msgid_plural ' . $this->poQuote($parts[1]) . "\n";

            $translations = explode("\x00", $msgstr);
            foreach ($translations as $i => $trans) {
                $po .= 'msgstr[' . $i . '] ' . $this->poQuote($trans) . "\n";
            }
        } else {
            $po .= 'msgid ' . $this->poQuote($msgid) . "\n";
            $po .= 'msgstr ' . $this->poQuote($msgstr) . "\n";
        }
        $po .= "\n";
    }

    return $po;
}

/**
 * Quote een string voor PO formaat
 */
private function poQuote($string) {
    // Volgorde: backslash eerst, dan CRLF, dan individuele control chars
    $string = str_replace('\\', '\\\\', $string);
    $string = str_replace('"', '\\"', $string);
    $string = str_replace("\r\n", '\\n', $string); // CRLF eerst
    $string = str_replace("\r", '\\r', $string);     // Dan losse CR
    $string = str_replace("\n", '\\n', $string);     // Dan losse LF
    $string = str_replace("\t", '\\t', $string);
    return '"' . $string . '"';
}

/**
 * Krijg alle vertalingen als array
 */
public function getTranslations() {
    return $this->translations;
}

/**
 * Krijg de target language
 */
public function getTargetLanguage() {
    return $this->targetLanguage;
}

}

// ============================================================================
// YAML SCHRIJVER (veilige subset die zowel Spyc als libyaml/php-yaml leest)
// ============================================================================

class YamlWriter {
public static function dump($data) {
return "---\n" . self::node($data, 0);
}

private static function isList($a) {
    return is_array($a) && ($a === array() || array_keys($a) === range(0, count($a) - 1));
}

private static function node($data, $indent) {
    $pad = str_repeat('  ', $indent);
    $out = '';
    if (self::isList($data)) {
        foreach ($data as $v) {
            if (is_array($v) && $v) {
                // "- " gevolgd door de eerste sleutel op dezelfde regel
                $inner = self::node($v, $indent + 1);
                $out .= $pad . '- ' . ltrim($inner, ' ');
            } else {
                $out .= $pad . '- ' . self::scalar($v, $indent + 1) . "\n";
            }
        }
        return $out;
    }
    foreach ($data as $k => $v) {
        $key = self::key($k);
        if (is_array($v) && $v) {
            $out .= $pad . $key . ":\n" . self::node($v, $indent + 1);
        } else {
            $out .= $pad . $key . ': ' . self::scalar($v, $indent + 1) . "\n";
        }
    }
    return $out;
}

private static function key($k) {
    return preg_match('/^[A-Za-z0-9_][A-Za-z0-9_.\-]*$/', (string)$k) ? (string)$k : self::quote((string)$k);
}

private static function quote($s) {
    return "'" . str_replace("'", "''", $s) . "'";
}

private static function scalar($v, $indent) {
    if ($v === null) return '~';
    if ($v === true) return 'true';
    if ($v === false) return 'false';
    if (is_int($v) || is_float($v)) return (string)$v;
    if (is_array($v)) return '[]';
    $v = (string)$v;
    if (strpos($v, "\n") === false) return self::quote($v);
    // Meerregelig: letterlijk blok met juiste 'chomping'
    $trail = strlen($v) - strlen(rtrim($v, "\n"));
    $ind = $trail === 0 ? '|-' : ($trail === 1 ? '|' : '|+');
    // Blok mag niet met spatie beginnen zonder indentatie-indicator
    if ($v !== '' && ($v[0] === ' ' || $v[0] === "\n")) $ind = '|2' . substr($ind, 1);
    $pad = str_repeat('  ', $indent);
    $body = rtrim($v, "\n");
    $lines = explode("\n", $body);
    $out = $ind . "\n";
    foreach ($lines as $l) $out .= ($l === '' ? '' : $pad . $l) . "\n";
    for ($i = 1; $i < $trail; $i++) $out .= "\n";
    return rtrim($out, "\n") . ($trail > 1 ? str_repeat("\n", $trail - 1) : '');
}

}

// ============================================================================
// PHAR BOUWER
// ============================================================================

class PharBuilder {
private $lang;
private $osticketPath;
private $outputFile;
private $i18nDir;
private $verbose;
private $yamlSource;
private $yamlUnits = array();

public function setYamlUnits(array $units) {
    $this->yamlUnits = $units;
}

public function __construct($lang = 'nl', $osticketPath = null, $outputFile = null, $verbose = true, $yamlSource = null) {
    $this->lang = str_replace('-', '_', $lang);
    $this->osticketPath = $osticketPath ?: __DIR__ . '/osTicket';
    $this->outputFile = $outputFile ?: __DIR__ . '/' . $this->lang . '.phar';
    $this->i18nDir = $this->osticketPath . '/include/i18n';
    $this->verbose = $verbose;
    $this->yamlSource = $yamlSource;
}

/**
 * Bouw de PHAR vanuit de vertaaltabel (XliffParser::toHashTable())
 */
public function build(array $table) {
    $this->log("PHAR bouwen voor taal: " . $this->lang);

    // Stap 1: vertaaltabel -> messages.mo.php (pure PHP, geen msgfmt)
    $moPhp = sprintf('<?php return %s;', var_export($table, true));
    $this->log("messages.mo.php gegenereerd: " . strlen($moPhp) . " bytes");

    // Stap 2: JavaScript vertaalstrings genereren
    $jsStrings = $this->generateJsStrings($table);
    $this->log("JS vertaalstrings gegenereerd");

    // Stap 3: PHAR maken
    $this->createPhar($moPhp, $jsStrings, $table);

    $this->log("PHAR gemaakt: " . $this->outputFile);
}

/**
 * Genereer js/osticket-strings.js zoals osTicket's i18n-module dat doet:
 * alle __('...') aanroepen in de .js bestanden van de osTicket-broncode.
 */
private function generateJsStrings(array $mo) {
    $phrases = array();
    foreach ($this->getAllJsPhrases($this->osticketPath) as $f) {
        $phrases[$f] = (isset($mo[$f]) && $mo[$f] !== '') ? $mo[$f] : $f;
    }
    if (!$phrases) {
        $this->log("  WAARSCHUWING: geen JS-frasen gevonden in {$this->osticketPath}; osticket-strings.js is leeg");
    }
    return sprintf('(function($){$.oststrings=%s;})(jQuery);',
        json_encode($phrases ?: new stdClass()));
}

private function getAllJsPhrases($root) {
    $root = rtrim($root, '/') . '/';
    if (!is_dir($root)) return array();
    $it = new RecursiveIteratorIterator(new RecursiveCallbackFilterIterator(
        new RecursiveDirectoryIterator($root, FilesystemIterator::SKIP_DOTS),
        function ($f) { return !in_array($f->getFilename(), array('.git', 'node_modules', 'vendor')); }));
    $files = array();
    foreach ($it as $f) {
        if (substr($f, -3) === '.js') $files[] = (string)$f;
    }
    sort($files);
    $phrases = array();
    foreach ($files as $f) {
        $script = file_get_contents($f);
        if (strpos($script, '__(') === false) continue;
        preg_match_all('/(?<![\w.$])(?:function\s+)?__\(\s*[^\'"]*(([\'"])(?:(?<!\\\\)\2|.)+?\2)\s*[^)]*\)/',
            $script, $calls, PREG_SET_ORDER);
        foreach ($calls as $c) {
            if (strncmp($c[0], 'function', 8) === 0) continue;   // definitie van __() zelf
            foreach (token_get_all('<?php ' . $c[0]) as $tok) {
                if (is_array($tok) && $tok[0] === T_CONSTANT_ENCAPSED_STRING) {
                    $phrases[str_replace(array("\\'", '\\"'), array("'", '"'), substr($tok[1], 1, -1))] = 1;
                    break;
                }
            }
        }
    }
    return array_keys($phrases);
}

/**
 * Maak het PHAR bestand
 */
private function createPhar($moPhp, $jsStrings, array $table) {
    // Verwijder bestaande PHAR
    if (file_exists($this->outputFile)) {
        @unlink($this->outputFile);
    }

    $phar = new Phar($this->outputFile);
    $phar->startBuffering();

    // 1. messages.mo.php
    $phar->addFromString('LC_MESSAGES/messages.mo.php', $moPhp);
    $this->log("  Toegevoegd: LC_MESSAGES/messages.mo.php");

    // 2. MANIFEST.php
    $manifest = $this->buildManifest($table);
    $phar->addFromString('MANIFEST.php', $manifest);
    $this->log("  Toegevoegd: MANIFEST.php");

    // 3. JavaScript bestanden
    $phar->addFromString('js/osticket-strings.js', $jsStrings);
    $this->log("  Toegevoegd: js/osticket-strings.js");

    // Redactor language file
    $redactorJs = $this->getRedactorJs();
    if ($redactorJs) {
        $phar->addFromString('js/redactor.js', $redactorJs);
        $this->log("  Toegevoegd: js/redactor.js");
    }

    // jQuery UI Datepicker
    $datepickerJs = $this->getDatepickerJs();
    if ($datepickerJs) {
        $phar->addFromString('js/jquery.ui.datepicker.js', $datepickerJs);
        $this->log("  Toegevoegd: js/jquery.ui.datepicker.js");
    }

    // 4. YAML templates uit en_US
    $this->addYamlTemplates($phar);

    // 5. Fonts (indien geconfigureerd)
    $this->addFonts($phar);

    // PHAR stub en signatuur
    $phar->setStub('<?php __HALT_COMPILER();');
    $phar->setSignatureAlgorithm(Phar::SHA1);

    $phar->stopBuffering();
}

/**
 * Bouw het MANIFEST.php bestand
 */
private function buildManifest(array $mo) {

    // Parse PO header
    $header = isset($mo['']) ? $mo[''] : '';
    $headers = array();
    foreach (explode("\n", $header) as $line) {
        $parts = explode(': ', $line, 2);
        if (count($parts) == 2) {
            $headers[strtolower($parts[0])] = trim($parts[1]);
        }
    }

    $info = array(
        'Build-Date' => date(DATE_RFC822),
        'Phrases-Version' => isset($headers['x-osticket-major-version']) ? $headers['x-osticket-major-version'] : '1.18',
        'Build-Version' => 'xliff2phar',
        'Build-Major-Version' => isset($headers['x-osticket-major-version']) ? $headers['x-osticket-major-version'] : '1.18',
        'Language' => isset($headers['language']) ? $headers['language'] : $this->lang,
        'Id' => 'lang:' . $this->lang,
        'Last-Revision' => isset($headers['po-revision-date']) ? $headers['po-revision-date'] : date('Y-m-d H:i'),
        'Version' => (int)(strtotime(isset($headers['po-revision-date']) ? $headers['po-revision-date'] : 'now') / 10000),
    );

    return sprintf('<?php return %s;', var_export($info, true));
}

/**
 * Voeg YAML templates toe aan de PHAR
 */
private function addYamlTemplates($phar) {
    $enUsDir = $this->i18nDir . '/en_US';
    if (!is_dir($enUsDir)) {
        $this->log("  WAARSCHUWING: en_US map niet gevonden op $enUsDir");
        return;
    }

    // Vertaalde YAML's: uit een map (Crowdin-export) of een bestaande .phar
    $src = $this->yamlSource;
    $srcRoot = null;
    if ($src && is_file($src) && substr(strtolower($src), -5) === '.phar') {
        $srcRoot = 'phar://' . realpath($src);
    } elseif ($src && is_dir($src)) {
        $srcRoot = rtrim(realpath($src), '/');
    } elseif ($src) {
        $this->log("  WAARSCHUWING: --yaml-source niet gevonden: $src");
    }

    $translated = 0;
    $english = array();
    foreach ($this->globRecursive($enUsDir . '/*') as $file) {
        if (!is_file($file)) continue;
        $rel = substr($file, strlen($enUsDir) + 1);
        $content = null;
        if (isset($this->yamlUnits[$rel])) {
            $content = $this->rebuildYaml($file, $this->yamlUnits[$rel]);
            $fromXliff = isset($fromXliff) ? $fromXliff + 1 : 1;
        }
        if ($content === null && $srcRoot) {
            // Direct pad, of onder een taalmap (bv. nl/ of nl_NL/ in een Crowdin-zip)
            foreach (array($rel, $this->lang . '/' . $rel, str_replace('_', '-', $this->lang) . '/' . $rel) as $cand) {
                if (is_file("$srcRoot/$cand")) { $content = file_get_contents("$srcRoot/$cand"); break; }
            }
        }
        if ($content === null) {
            $content = file_get_contents($file);
            $english[] = $rel;
        } else {
            $translated++;
        }
        $phar->addFromString($rel, $content);
    }
    $this->log("  Toegevoegd: $translated vertaalde YAML/template bestanden"
        . (isset($fromXliff) ? " ($fromXliff opgebouwd uit de XLIFF)" : ""));
    if ($english) {
        $this->log("  WAARSCHUWING: " . count($english) . " bestanden in het Engels (geen vertaling gevonden"
            . ($srcRoot ? "" : "; gebruik --yaml-source=MAP_OF_PHAR") . ")");
    }
}

/**
 * Bouw een vertaald YAML-bestand: en_US als basis, vertaalde waarden uit de XLIFF erin
 */
private function rebuildYaml($enFile, array $units) {
    if (!class_exists('Spyc')) {
        $spyc = $this->osticketPath . '/include/Spyc.php';
        if (!is_file($spyc)) {
            throw new Exception("Spyc.php niet gevonden in {$this->osticketPath}/include (nodig om YAML te lezen)");
        }
        require_once $spyc;
    }
    $data = Spyc::YAMLLoad($enFile);
    if (!is_array($data)) $data = array();
    foreach ($units as $u) {
        list($path, $src, $tgt) = $u;
        if ($tgt === null || $tgt === $src) continue;   // niet (anders) vertaald: en_US-waarde laten staan
        $ref =& $data;
        foreach ($path as $p) {
            if (!is_array($ref)) $ref = array();
            if (ctype_digit((string)$p)) $p = (int)$p;
            if (!array_key_exists($p, $ref)) $ref[$p] = null;
            $ref =& $ref[$p];
        }
        // Getallen/booleans uit en_US niet in tekst omzetten
        if (!(is_int($ref) || is_float($ref) || is_bool($ref)) || (string)$ref !== $tgt) {
            $ref = $tgt;
        }
        unset($ref);
    }
    return YamlWriter::dump($data);
}

/**
 * Haal het Redactor JS taalbestand op
 */
private function getRedactorJs() {
    $langs = array($this->lang);
    if (strpos($this->lang, '_') !== false) {
        @list($short) = explode('_', $this->lang);
        $langs[] = $short;
    }

    foreach ($langs as $l) {
        $path = $this->i18nDir . '/vendor/redactor/' . $l . '.js';
        if (file_exists($path)) {
            return file_get_contents($path);
        }
    }
    $this->log("  WAARSCHUWING: Geen Redactor taalbestand gevonden");
    return false;
}

/**
 * Haal het jQuery UI Datepicker locale bestand op
 */
private function getDatepickerJs() {
    // Net als osTicket: jQuery UI locale van GitHub (eerst nl_NL, dan nl)
    $langs = array($this->lang);
    if (strpos($this->lang, '_') !== false) {
        @list($short) = explode('_', $this->lang);
        $langs[] = $short;
    }
    $ctx = stream_context_create(array('http' => array('timeout' => 10)));
    foreach ($langs as $l) {
        $url = 'https://raw.githubusercontent.com/jquery/jquery-ui/master/ui/i18n/datepicker-'
            . str_replace('_', '-', $l) . '.js';
        $content = @file_get_contents($url, false, $ctx);
        if ($content) return $content;
    }
    // Offline: overnemen uit --yaml-source (bestaande .phar of map), indien aanwezig
    $src = $this->yamlSource;
    if ($src && is_file($src) && substr(strtolower($src), -5) === '.phar') {
        $f = 'phar://' . realpath($src) . '/js/jquery.ui.datepicker.js';
    } elseif ($src && is_dir($src)) {
        $f = rtrim($src, '/') . '/js/jquery.ui.datepicker.js';
    }
    if (isset($f) && is_file($f)) return file_get_contents($f);

    $this->log("  WAARSCHUWING: jQuery UI Datepicker locale niet gevonden (geen internet?)");
    return false;
}

/**
 * Voeg fonts toe indien geconfigureerd in langs.php
 */
private function addFonts($phar) {
    $langsPhp = $this->i18nDir . '/langs.php';
    if (!file_exists($langsPhp)) return;

    $langs = include $langsPhp;
    $info = isset($langs[$this->lang]) ? $langs[$this->lang] : null;
    if (!$info || !isset($info['fonts'])) return;

    foreach ($info['fonts'] as $name => $types) {
        foreach ($types as $code => $fullname) {
            list($ttf, $url) = $fullname;
            if (!$url) continue;
            $content = @file_get_contents($url);
            if ($content) {
                $phar->addFromString('fonts/' . $ttf, $content);
                $this->log("  Toegevoegd: fonts/$ttf");
            }
        }
    }
}

/**
 * Recursieve glob
 */
private function globRecursive($pattern) {
    $files = glob($pattern);
    $dirs = glob(dirname($pattern) . '/*', GLOB_ONLYDIR);
    foreach ($dirs as $dir) {
        $files = array_merge($files, $this->globRecursive($dir . '/' . basename($pattern)));
    }
    return $files;
}

/**
 * Log een bericht
 */
private function log($msg) {
    if ($this->verbose) {
        fwrite(STDERR, $msg . "\n");
    }
}

}

// ============================================================================
// HOOFDPROGRAMMA
// ============================================================================

function showUsage() {
echo "xliff2phar.php - Converteer Crowdin XLIFF naar osTicket PHAR\n\n";
echo "Gebruik:\n";
echo " php -dphar.readonly=0 xliff2phar.php <xliff_bestand_of_map> [opties]\n\n";
echo "Opties:\n";
echo " --lang=nl Taalcode (standaard: nl)\n";
echo " --osticket-path=PAD Pad naar osTicket source (standaard: ./osTicket)\n";
echo " --output=bestand.phar Output bestand (standaard: <lang>.phar)\n";
echo " --yaml-source=PAD Map (Crowdin-export) of .phar met vertaalde YAML templates\n";
echo " --po=bestand.po Schrijf ook een PO bestand (optioneel, ter controle)\n";
echo " --quiet Onderdruk logberichten\n\n";
echo "Voorbeelden:\n";
echo " php -dphar.readonly=0 xliff2phar.php vertalingen.xliff\n";
echo " php -dphar.readonly=0 xliff2phar.php ./crowdin-export/ --lang=nl --osticket-path=./osTicket\n";
}

// Parse argumenten - handmatig om opties na positionele args te ondersteunen
$options = array();
$positionalArgs = array();
for ($i = 1; $i < $argc; $i++) {
$arg = $argv[$i];
if (substr($arg, 0, 2) === '--') {
$parts = explode('=', substr($arg, 2), 2);
$key = $parts[0];
$val = isset($parts[1]) ? $parts[1] : true;
$options[$key] = $val;
} elseif (substr($arg, 0, 1) === '-') {
// Korte opties - sla over voor nu
} else {
$positionalArgs[] = $arg;
}
}

$xliffInput = reset($positionalArgs);
if (!$xliffInput) {
showUsage();
exit(1);
}

$lang = isset($options['lang']) && $options['lang'] !== true ? $options['lang'] : 'nl';
$osticketPath = isset($options['osticket-path']) && $options['osticket-path'] !== true ? $options['osticket-path'] : (DIR . '/osTicket');
$outputFile = isset($options['output']) && $options['output'] !== true ? $options['output'] : null;
$verbose = !isset($options['quiet']);
$yamlSource = isset($options['yaml-source']) && $options['yaml-source'] !== true ? $options['yaml-source'] : null;
$poFile = isset($options['po']) && $options['po'] !== true ? $options['po'] : null;

// Controleer of de input een bestand of map is
$xliffFiles = array();
if (is_dir($xliffInput)) {
// Zoek alle .xliff en .xlf bestanden in de map
$iterator = new RecursiveIteratorIterator(
new RecursiveDirectoryIterator($xliffInput, RecursiveDirectoryIterator::SKIP_DOTS)
);
foreach ($iterator as $file) {
$ext = strtolower($file->getExtension());
if ($ext === 'xliff' || $ext === 'xlf') {
$xliffFiles[] = $file->getPathname();
}
}
} elseif (is_file($xliffInput)) {
$xliffFiles[] = $xliffInput;
} else {
fwrite(STDERR, "Fout: Kan input niet vinden: $xliffInput\n");
exit(1);
}

if (empty($xliffFiles)) {
fwrite(STDERR, "Fout: Geen XLIFF bestanden gevonden in: $xliffInput\n");
exit(1);
}

fwrite(STDERR, count($xliffFiles) . " XLIFF bestand(en) gevonden\n");

// Controleer de osTicket-broncode: zonder deze wordt het pakket onvolledig
// (geen YAML-sjablonen, geen redactor.js, lege JS-vertalingen)
$osticketPath = rtrim($osticketPath, '/');
$required = array(
$osticketPath . '/include/i18n/en_US/config.yaml' => 'en_US YAML-bestanden',
$osticketPath . '/include/Spyc.php' => 'YAML-lezer Spyc.php',
$osticketPath . '/include/i18n/vendor/redactor' => 'Redactor taalbestanden',
$osticketPath . '/js/osticket.js' => 'osTicket JavaScript',
);
$missing = array();
foreach ($required as $path => $what) {
if (!file_exists($path)) $missing[] = " - $what ($path)";
}
if ($missing) {
fwrite(STDERR, "FOUT: osTicket-broncode niet (volledig) gevonden op: $osticketPath\n"
. implode("\n", $missing) . "\n\n"
. "Haal de broncode op (zelfde versie als de vertalingen), bijvoorbeeld:\n"
. " git clone --depth 1 --branch v1.18.2 https://github.com/osTicket/osTicket.git\n"
. "en geef het pad mee met --osticket-path=/pad/naar/osTicket\n");
exit(1);
}
fwrite(STDERR, "osTicket-broncode: $osticketPath\n");

// Stap 1: XLIFF bestanden parsen
$xliffParser = new XliffParser();
foreach ($xliffFiles as $xliffFile) {
fwrite(STDERR, "Parsen: $xliffFile\n");
$xliffParser->parse($xliffFile);
}

$translations = $xliffParser->getTranslations();
fwrite(STDERR, count($translations) . " vertalingen gevonden\n");

if (count($translations) === 0) {
fwrite(STDERR, "Fout: Geen vertalingen gevonden in de XLIFF bestanden\n");
exit(1);
}

// Stap 2: vertaaltabel opbouwen (direct, zonder msgfmt)
$table = $xliffParser->toHashTable();
fwrite(STDERR, (count($table) - 2) . " vertalingen in de tabel\n");

// Optioneel: PO bestand wegschrijven ter controle
if ($poFile) {
file_put_contents($poFile, $xliffParser->toPO());
fwrite(STDERR, "PO bestand geschreven: $poFile\n");
}

// Stap 3: PHAR bouwen
// Standaard: als de input een map is (Crowdin-export), zoek daar ook naar vertaalde YAML's
if (!$yamlSource && is_dir($xliffInput)) $yamlSource = $xliffInput;
$builder = new PharBuilder($lang, $osticketPath, $outputFile, $verbose, $yamlSource);
$builder->setYamlUnits($xliffParser->getYamlUnits());
if ($xliffParser->getYamlUnits()) fwrite(STDERR, count($xliffParser->getYamlUnits()) . " YAML-bestanden gevonden in de XLIFF\n");
$builder->build($table);

// Controle achteraf
$check = new Phar(realpath($outputFile ?: (DIR . '/' . str_replace('-', '_', $lang) . '.phar')));
$yamlCount = 0;
foreach (new RecursiveIteratorIterator($check) as $f) {
if (substr($f->getFilename(), -5) === '.yaml') $yamlCount++;
}
$problems = array();
if ($yamlCount < 50) $problems[] = "slechts $yamlCount YAML-bestanden";
if (!isset($check['js/redactor.js'])) $problems[] = "js/redactor.js ontbreekt";
if (strlen($check['js/osticket-strings.js']->getContent()) < 100) $problems[] = "js/osticket-strings.js is leeg";
fwrite(STDERR, "\nInhoud: " . $check->count() . " bestanden, waarvan $yamlCount YAML\n");
if ($problems) {
fwrite(STDERR, "WAARSCHUWING: pakket is onvolledig: " . implode(', ', $problems) . "\n");
exit(2);
}
fwrite(STDERR, "\nKlaar! PHAR bestand aangemaakt.\n");
fwrite(STDERR, "Plaats het bestand in de include/i18n/ map van je osTicket installatie.\n");
`