#!/usr/bin/php
<?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);

foreach(ContractLinkModel::search(["type" => "upgrade"]) as $link) {
    $origin_contract = $link->origin;
    $successor_contract = $link->contract;

    if($successor_contract->create < 1728216155) continue;
    if(!$origin_contract->cancel_date) continue;

    echo "Kunde: ".$successor_contract->owner->getCompanyOrName()."\n";
    echo "From Contract ".$origin_contract->id."\t(Canceldate: ".((new DateTime("@".$origin_contract->cancel_date))->setTimezone(new DateTimeZone("Europe/Vienna"))->format("Y-m-d")).") ".$origin_contract->product_name." [".$origin_contract->matchcode."]\n";
    echo "To   Contract ".$successor_contract->id."\t(Finishdate: ".((new DateTime("@".$successor_contract->finish_date))->setTimezone(new DateTimeZone("Europe/Vienna"))->format("Y-m-d")).") ".$successor_contract->product_name." [".$successor_contract->matchcode."]\n";
    echo "\n";
}