#!/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);

foreach(AddressLinkModel::search(["type" => "billing"]) as $link) {
    //var_dump($link);exit;

    if($link->address_id == $link->origin_address_id) {
        echo $link->address_id." == ".$link->origin_address_id."\n";
        $link->delete();
    }

    $bill_id = $link->address_id;


    $contract = ContractModel::getFirst(["owner_id" => $bill_id]);
    if($contract) {
        //echo "$bill_id als owner in Contract ID ".$contract->id." gefunden\n";
        continue;
    }

    $contract = ContractModel::getFirst(["billingaddress_id" => $bill_id]);
    if($contract) {
        //echo "$bill_id als billing in Contract ID ".$contract->id." gefunden\n";
        continue;
    }

    $order = OrderModel::getFirst(["owner_id" => $bill_id]);
    if($order) {
        //echo "$bill_id in als owner Order ".$order->id." gefunden\n";
        continue;
    }

    $order = OrderModel::getFirst(["billingaddress_id" => $bill_id]);
    if($order) {
        //echo "$bill_id in als billing Order ".$order->id." gefunden\n";
        continue;
    }

    $bill = new Address($bill_id);
    if(!$bill || $bill->id != $bill_id) {
        echo "what !?\n";
    }

    if($bill->customer_number) {
        echo $bill_id." has customer number\n";
    }
    if($bill->fibu_account_number) {
        echo $bill_id." has fibu account number\n";
    }

    /*echo "deleting ".$bill_id."\n";
    $bill->delete();
    foreach(AddresstypeModel::search(["address_id" => $bill_id]) as $type) {
        echo "deleting AddressType bill_id $bill_id\n";
        $type->delete();
    }
    echo "deleting link ".$link->origin_address_id." -> ".$link->address_id."\n";
    $link->delete();
    */


}