#!/usr/bin/php
<?php

//require 'vendor/autoload.php';
require("../../config/config.php");

define('FRONKDB_SQLDEBUG', false);
error_reporting(E_ALL & ~(E_NOTICE | E_STRICT | E_DEPRECATED));

require_once(LIBDIR . "/mvcfronk/mfRouter/mfRouter.php");
require_once(LIBDIR . "/mvcfronk/mfBase/mfBaseModel.php");
require_once(LIBDIR . "/mvcfronk/mfBase/mfBaseController.php");

$me = new User(1);
define("INTERNAL_USER_ID", $me->id);
define("INTERNAL_USER_USERNAME", $me->username);
define("MFBASE_BYPASS_LOGIN", true);


$oaids_jan = [
    "AT-8952-23ffab62.001",
    "AT-8952-99faa819.001",
    "AT-8952-c2a464e4.001",
    "AT-8952-a3b92ec9.001",
    "AT-8952-e1945541.001",
    "AT-8952-45285e35.001",
    "AT-8952-2de897a5.001",
    "AT-8952-98443134.001",
    "AT-8952-7aded06c.001",
    "AT-8952-5616e098.001",
    "AT-8952-2cbe64bc.001",
    "AT-8952-10ff5831.001",
    "AT-8952-9a7460b4.002",
    "AT-8952-bcad283f.001",
    "AT-8952-29f918bc.001",
    "AT-8943-d972ba1c.001",
    "AT-8952-47e52775.002",
    "AT-8952-479e52b8.001",


    "AT-8952-03e9c108.001",
    "AT-8952-0923e13a.001",
    "AT-8952-1629b7f4.001",
    "AT-8952-18354d50.001",
    "AT-8952-20559f13.001",
    "AT-8952-2ce0dc06.001",
    "AT-8952-46bb7fff.001",
    "AT-8952-49928eab.001",
    "AT-8952-4e7fa84f.001",
    "AT-8952-544d23e8.001",
    "AT-8952-5dfb7093.001",
    "AT-8952-a0784e8d.001",
    "AT-8952-a9ef64c5.001",
    "AT-8952-b92fcb7d.001",
    "AT-8952-d150720b.001",
    "AT-8952-d5efb0c5.001",
    "AT-8952-e2aac412.001",
    "AT-8952-e41153d0.001",
    "AT-8952-f15a2ca7.001",
    "AT-8952-fc73db80.001",
    "AT-8952-db66a8b5.001",
    "AT-8952-a2959a59.001",
    "AT-8952-d82544fa.001",
    "AT-8952-eb1f181f.001",
    "AT-8952-ab64ee00.001",
    "AT-8952-9298eb35.001",
    "AT-8952-907f3e5b.001",
    "AT-8952-e3ead452.001",
    "AT-8952-6825d3ae.001",
    "AT-8952-5badd1cd.001",
    "AT-8952-d63f3b4a.001",
    "AT-8952-730c7315.001",
    "AT-8943-090108fa.001",
    "AT-8952-56809ead.001",
    "AT-8952-0f09116b.001",
    "AT-8952-7a957a9e.001",
    "AT-8952-8ff3a2c9.001",
    "AT-8952-fccc732a.001",
    "AT-8952-8307773c.001",
    "AT-8952-d510b7aa.001",
    "AT-8952-39b3f98f.001",
    "AT-8952-f2a0a99d.001",
    "AT-8952-cfd374ef.001",
    "AT-8952-84e38d21.001",
    "AT-8952-a95bda77.001",
    "AT-8952-5df56224.001",
    "AT-8952-047a8d82.001",
    "AT-8952-174a11aa.001",
    "AT-8943-ac155257.001",
    "AT-8943-d906ff07.001",
    "AT-8952-be7a0660.001",
    "AT-8952-4bffce63.001",
    "AT-8952-aed7e5ed.001",
    "AT-8952-cd78c3e5.001",
    "AT-8952-af85f1e0.001",
    "AT-8952-b9749ec9.001",
    "AT-8952-f63e9d2c.001",
    "AT-8952-affe64f2.001",
    "AT-8952-f4468002.001",
    "AT-8952-e80422e6.001",
    "AT-8943-5565dba0.001",
    "AT-8952-a7c37d89.001",
    "AT-8952-a8bd4bd9.001",
    "AT-8952-d4fb7422.001",
    "AT-8952-8ea45971.001",
    "AT-8943-820efe44.001",
    "AT-8943-6e670739.001",
    "AT-8943-a1116acf.001",
    "AT-8952-5eea3a46.001",
    "AT-8952-3083a5c1.001",
    "AT-8952-64e40186.003",
    "AT-8952-c291163a.003",
    "AT-8952-47e52775.003",
    "AT-8952-64e40186.002",
    "AT-8952-64e40186.001",

    "AT-8952-39d2c630.001",

    "AT-8943-cc2e08c3.001",
    "AT-8943-d029b6d2.001",
    "AT-8943-7472b260.001",
    "AT-8943-426cda48.003",
    "AT-8943-426cda48.005",
    "AT-8943-f2c2ae10.006",
    "AT-8943-0281f0db.004",
    "AT-8943-0281f0db.001",
    "AT-8943-ff7298d6.001",
    "AT-8943-fffb3d90.005",
    "AT-8943-9389a188.003",
    "AT-8943-ad0ba787.003",
    "AT-8943-ad0ba787.002",
    "AT-8943-8fad635a.001",
    "AT-8943-9389a188.004",
    "AT-8943-8bde59fc.003",
    "AT-8943-0281f0db.002",
    "AT-8943-ef64ab98.001",
    "AT-8943-fd1e7b0c.004",
    "AT-8943-c10d87c7.003",
    "AT-8943-a5762d93.003",
    "AT-8943-a5762d93.004",
    "AT-8943-bc7bb96c.001",

    "AT-8943-2a911dab.001",
    "AT-8943-65b57745.001",
    "AT-8943-40c99c0d.002",
    "AT-8943-40c99c0d.004",
    "AT-8943-40c99c0d.001",
    "AT-8943-40c99c0d.003",
    "AT-8943-dcab7caf.001",
    "AT-8943-cf48ccef.001",
    "AT-8943-2c01ac8d.001",
    "AT-8943-3f07dd46.001",
    "AT-8943-f2c2ae10.002",
    "AT-8943-fa78f417.001",
    "AT-8943-05505f1e.001",
    "AT-8943-b8e526a2.002",
    "AT-8943-b8e526a2.001",
    "AT-8943-54e2caa3.001",
    "AT-8943-91b15e79.001",
    "AT-8943-a28e1bce.001",
    "AT-8943-e29b3cd4.001",
    "AT-8943-1277b7eb.001",
    "AT-8943-5d391327.001",
    "AT-8943-b4c1b606.001",
    "AT-8943-6e424945.001",
    "AT-8943-339cdc17.001",
    "AT-8943-a443cbe2.001",
    "AT-8943-dd7e2b71.005",
    "AT-8943-9389a188.002",
    "AT-8943-9389a188.001",
    "AT-8943-ad0ba787.001",
    "AT-8943-8bde59fc.004",
    "AT-8943-ad0ba787.004",
    "AT-8943-13e70f36.001",
    "AT-8943-426cda48.002",
    "AT-8943-0281f0db.003",
    "AT-8943-426cda48.001",
    "AT-8943-a464c429.001",
    "AT-8943-fffb3d90.006",
    "AT-8943-ad6205f0.001",
    "AT-8943-dd7e2b71.003",
    "AT-8943-fce5a31f.003",
    "AT-8943-49b0c91c.001",
    "AT-8943-fffb3d90.003",
    "AT-8943-fffb3d90.004",
    "AT-8943-c964421e.001",
    "AT-8943-77d4537b.001",
    "AT-8943-3c8f8152.003",
    "AT-8943-9c8937e8.001",
    "AT-8943-3c8f8152.002",
    "AT-8943-3c8f8152.001",
    "AT-8943-ed3620c0.001",
    "AT-8943-399bd714.001",
    "AT-8943-69ae30fb.001",
    "AT-8943-46ec6651.001",
    "AT-8943-d61452be.002",
    "AT-8943-c10d87c7.002",
    "AT-8943-fffb3d90.002",
    "AT-8943-fffb3d90.001",
    "AT-8943-fce5a31f.002",

    "AT-8943-8f89a4af.001",
    "AT-8943-3455667d.001",
    "AT-8943-ac0c2308.001",
    "AT-8943-b87f265d.001",
    "AT-8943-33925d44.001",
    "AT-8982-4f2a215b.001",
    "AT-8982-a89c4335.001",
    "AT-8982-e6265b67.001",
    "AT-8982-a415bb94.001",
    "AT-8982-6a510a7a.001",
    "AT-8982-66f307a0.001",
    "AT-8982-dbab4714.002",
    "AT-8982-2827d3aa.001",
    "AT-8982-a1ada847.001",
    "AT-8982-0208e8be.001",
    "AT-8982-580833dd.001",
    "AT-8982-614920ab.001",
    "AT-8982-af3a8d63.001",
    "AT-8982-d798cd99.001",
    "AT-8982-c6d7e4f2.001",
    "AT-8982-9641fb2e.001",
    "AT-8982-aded99c2.001",
    "AT-8982-abd61a0b.001",
    "AT-8982-451c1eb1.001",
    "AT-8982-3126a5dc.001",
    "AT-8982-06484e3f.001",
    "AT-8982-63977aa7.001",
    "AT-8982-7edf2184.001",
    "AT-8982-edc6a443.001",
    "AT-8982-bce86ac9.001",
    "AT-8982-d448ba70.001",
    "AT-8982-be11d84d.001",

    "AT-8982-92020d96.001",
    "AT-8983-e66b3f80.001",
    "AT-8983-ae426106.001",
    "AT-8983-2bf3214f.001",
];

$oaids_feb = [
    "AT-8952-23ffab62.001",
    "AT-8952-99faa819.001",
    "AT-8952-c2a464e4.001",
    "AT-8952-a3b92ec9.001",
    "AT-8952-e1945541.001",
    "AT-8952-45285e35.001",
    "AT-8952-2de897a5.001",
    "AT-8952-98443134.001",
    "AT-8952-7aded06c.001",
    "AT-8952-5616e098.001",
    "AT-8952-2cbe64bc.001",
    "AT-8952-10ff5831.001",
    "AT-8952-9a7460b4.002",
    "AT-8952-bcad283f.001",
    "AT-8952-29f918bc.001",
    "AT-8943-d972ba1c.001",
    "AT-8952-47e52775.002",
    "AT-8952-479e52b8.001",
    "AT-8952-47e52775.001",
    "AT-8952-54a90298.001",
    "AT-8952-03e9c108.001",
    "AT-8952-0923e13a.001",
    "AT-8952-1629b7f4.001",
    "AT-8952-18354d50.001",
    "AT-8952-20559f13.001",
    "AT-8952-2ce0dc06.001",
    "AT-8952-46bb7fff.001",
    "AT-8952-49928eab.001",
    "AT-8952-4e7fa84f.001",
    "AT-8952-544d23e8.001",
    "AT-8952-5dfb7093.001",
    "AT-8952-a0784e8d.001",
    "AT-8952-a9ef64c5.001",
    "AT-8952-b92fcb7d.001",
    "AT-8952-d150720b.001",
    "AT-8952-d5efb0c5.001",
    "AT-8952-e2aac412.001",
    "AT-8952-e41153d0.001",
    "AT-8952-f15a2ca7.001",
    "AT-8952-fc73db80.001",
    "AT-8952-db66a8b5.001",
    "AT-8952-a2959a59.001",
    "AT-8952-d82544fa.001",
    "AT-8952-eb1f181f.001",
    "AT-8952-ab64ee00.001",
    "AT-8952-9298eb35.001",
    "AT-8952-907f3e5b.001",
    "AT-8952-e3ead452.001",
    "AT-8952-6825d3ae.001",
    "AT-8952-5badd1cd.001",
    "AT-8952-d63f3b4a.001",
    "AT-8952-730c7315.001",
    "AT-8943-090108fa.001",
    "AT-8952-56809ead.001",
    "AT-8952-0f09116b.001",
    "AT-8952-7a957a9e.001",
    "AT-8952-8ff3a2c9.001",
    "AT-8952-fccc732a.001",
    "AT-8952-8307773c.001",
    "AT-8952-d510b7aa.001",
    "AT-8952-39b3f98f.001",
    "AT-8952-f2a0a99d.001",
    "AT-8952-cfd374ef.001",
    "AT-8952-84e38d21.001",
    "AT-8952-a95bda77.001",
    "AT-8952-5df56224.001",
    "AT-8952-047a8d82.001",
    "AT-8952-174a11aa.001",
    "AT-8943-ac155257.001",
    "AT-8943-d906ff07.001",
    "AT-8952-be7a0660.001",
    "AT-8952-4bffce63.001",
    "AT-8952-aed7e5ed.001",
    "AT-8952-cd78c3e5.001",
    "AT-8952-af85f1e0.001",
    "AT-8952-b9749ec9.001",
    "AT-8952-f63e9d2c.001",
    "AT-8952-affe64f2.001",
    "AT-8952-f4468002.001",
    "AT-8952-e80422e6.001",
    "AT-8943-5565dba0.001",
    "AT-8952-a7c37d89.001",
    "AT-8952-a8bd4bd9.001",
    "AT-8952-d4fb7422.001",
    "AT-8952-8ea45971.001",
    "AT-8943-820efe44.001",
    "AT-8943-6e670739.001",
    "AT-8943-a1116acf.001",
    "AT-8952-5eea3a46.001",
    "AT-8952-3083a5c1.001",
    "AT-8952-64e40186.003",
    "AT-8952-c291163a.003",
    "AT-8952-47e52775.003",
    "AT-8952-64e40186.002",
    "AT-8952-64e40186.001",
    "AT-8952-ec0bd13d.001",
    "AT-8952-2c5c1a88.001",
    "AT-8952-ad79e49e.003",
    "AT-8952-ad79e49e.002",
    "AT-8952-8e408a37.002",
    "AT-8952-91880329.001",
    "AT-8952-39d2c630.001",
    "AT-8952-ee1bcdc3.001",
    "AT-8943-cc2e08c3.001",
    "AT-8943-d029b6d2.001",
    "AT-8943-7472b260.001",
    "AT-8943-426cda48.003",
    "AT-8943-426cda48.005",
    "AT-8943-f2c2ae10.006",
    "AT-8943-0281f0db.004",
    "AT-8943-0281f0db.001",
    "AT-8943-ff7298d6.001",
    "AT-8943-fffb3d90.005",
    "AT-8943-9389a188.003",
    "AT-8943-ad0ba787.003",
    "AT-8943-ad0ba787.002",
    "AT-8943-8fad635a.001",
    "AT-8943-9389a188.004",
    "AT-8943-8bde59fc.003",
    "AT-8943-0281f0db.002",
    "AT-8943-ef64ab98.001",
    "AT-8943-fd1e7b0c.004",
    "AT-8943-c10d87c7.003",
    "AT-8943-a5762d93.003",
    "AT-8943-a5762d93.004",
    "AT-8943-bc7bb96c.001",
    "AT-8943-a5762d93.002",
    "AT-8943-8392e815.001",
    "AT-8943-2a911dab.001",
    "AT-8943-65b57745.001",
    "AT-8943-40c99c0d.002",
    "AT-8943-40c99c0d.004",
    "AT-8943-40c99c0d.001",
    "AT-8943-40c99c0d.003",
    "AT-8943-dcab7caf.001",
    "AT-8943-cf48ccef.001",
    "AT-8943-2c01ac8d.001",
    "AT-8943-3f07dd46.001",
    "AT-8943-f2c2ae10.002",
    "AT-8943-fa78f417.001",
    "AT-8943-05505f1e.001",
    "AT-8943-b8e526a2.002",
    "AT-8943-b8e526a2.001",
    "AT-8943-54e2caa3.001",
    "AT-8943-91b15e79.001",
    "AT-8943-a28e1bce.001",
    "AT-8943-e29b3cd4.001",
    "AT-8943-1277b7eb.001",
    "AT-8943-5d391327.001",
    "AT-8943-b4c1b606.001",
    "AT-8943-6e424945.001",
    "AT-8943-339cdc17.001",
    "AT-8943-a443cbe2.001",
    "AT-8943-dd7e2b71.005",
    "AT-8943-9389a188.002",
    "AT-8943-9389a188.001",
    "AT-8943-ad0ba787.001",
    "AT-8943-8bde59fc.004",
    "AT-8943-ad0ba787.004",
    "AT-8943-13e70f36.001",
    "AT-8943-426cda48.002",
    "AT-8943-0281f0db.003",
    "AT-8943-426cda48.001",
    "AT-8943-a464c429.001",
    "AT-8943-fffb3d90.006",
    "AT-8943-ad6205f0.001",
    "AT-8943-dd7e2b71.003",
    "AT-8943-fce5a31f.003",
    "AT-8943-49b0c91c.001",
    "AT-8943-fffb3d90.003",
    "AT-8943-fffb3d90.004",
    "AT-8943-c964421e.001",
    "AT-8943-77d4537b.001",
    "AT-8943-3c8f8152.003",
    "AT-8943-9c8937e8.001",
    "AT-8943-3c8f8152.002",
    "AT-8943-3c8f8152.001",
    "AT-8943-ed3620c0.001",
    "AT-8943-399bd714.001",
    "AT-8943-69ae30fb.001",
    "AT-8943-46ec6651.001",
    "AT-8943-d61452be.002",
    "AT-8943-c10d87c7.002",
    "AT-8943-fffb3d90.002",
    "AT-8943-fffb3d90.001",
    "AT-8943-fce5a31f.002",
    "AT-8943-9db3a055.002",
    "AT-8943-9db3a055.001",
    "AT-8943-122f171a.001",
    "AT-8943-a72c5637.002",
    "AT-8943-bba3a3bc.001",
    "AT-8943-8f89a4af.001",
    "AT-8943-3455667d.001",
    "AT-8943-ac0c2308.001",
    "AT-8943-b87f265d.001",
    "AT-8943-33925d44.001",
    "AT-8982-4f2a215b.001",
    "AT-8982-a89c4335.001",
    "AT-8982-e6265b67.001",
    "AT-8982-a415bb94.001",
    "AT-8982-6a510a7a.001",
    "AT-8982-66f307a0.001",
    "AT-8982-dbab4714.002",
    "AT-8982-2827d3aa.001",
    "AT-8982-a1ada847.001",
    "AT-8982-0208e8be.001",
    "AT-8982-580833dd.001",
    "AT-8982-614920ab.001",
    "AT-8982-af3a8d63.001",
    "AT-8982-d798cd99.001",
    "AT-8982-c6d7e4f2.001",
    "AT-8982-9641fb2e.001",
    "AT-8982-aded99c2.001",
    "AT-8982-abd61a0b.001",
    "AT-8982-451c1eb1.001",
    "AT-8982-3126a5dc.001",
    "AT-8982-06484e3f.001",
    "AT-8982-63977aa7.001",
    "AT-8982-7edf2184.001",
    "AT-8982-edc6a443.001",
    "AT-8982-bce86ac9.001",
    "AT-8982-d448ba70.001",
    "AT-8982-be11d84d.001",
    "AT-8982-8ecff7fc.001",
    "AT-8982-f02e6c7d.002",
    "AT-8982-f02e6c7d.001",
    "AT-8982-92020d96.001",
    "AT-8983-e66b3f80.001",
    "AT-8983-ae426106.001",
    "AT-8983-2bf3214f.001",

];

$from = "2025-01-01";
$to = "2025-01-31";

foreach($oaids_jan as $oaid) {

    if(!PreorderBilling::getFirst(["product_id" => 3, "oaid" => $oaid, "start_date>=" => $from, "start_date<=" => $to])) {
        echo "OAID $oaid not found in billing\n";
    }
}

foreach(PreorderBilling::search(["product_id" => 3, "start_date>=" => $from, "start_date<=" => $to]) as $bill) {

    if(!in_array($bill->oaid, $oaids_jan)) {
        $preorder = $bill->preorder;
        if($preorder->order_date) {
            $order_date = new DateTime('@'.$preorder->order_date);
        } else {
            $order_date = new DateTime('@'.$preorder->create);
        }
        $order_date->setTime(4,0,0);
        $order_date->setTimezone(new DateTimeZone("Europe/Vienna"));

        $status_change = PreorderHistoryModel::getFirstStatusChangeToOrHigher($preorder->id, 500);
        if(!$status_change) {
            $status_change = $preorder;
        }
        $status_change_date = new DateTime("@".$status_change->create);
        echo "OAID ".$bill->oaid." not found in excel | order_date: ".$order_date->format("Y-m-d")." | status 500: ".$status_change_date->format("Y-m-d")."\n";
    }
}