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

$folder = __DIR__."/source";
$filename = "$folder/invalid-emails.txt";

$db = FronkDB::singleton(ADDRESSDB_DBHOST, ADDRESSDB_DBUSER, ADDRESSDB_DBPASS, ADDRESSDB_DBNAME);
$log = mfLoghandler::singleton();

$input = fopen($filename, "r");


$csv = "kundennummer;name_oder_firma;strasse;plz;ort;email;bounced_email\n";
$i = 0;
while($line = fgets($input)) {
    $email = trim($line);
    if(!$email) continue;

    $bounce_email = $email;

    if($email == '\303\274hilipp.bendieck@web.de') $email = "ühilipp.bendieck@web.de";
    if($email == 'benjamin@frie\303\237.at') $email = "benjamin@frieß.at";
    if($email == 'daniela.l\303\266scher@gmx.net') $email = "daniela.löscher@gmx.net";
    if($email == "-@") $email = "-";
    if($email == "gudrun_theisl@oan.at") $email = "gudrun_theisl@aon.at";
    if($email == "266hrermaximilian@gmail.com") $email = "zöhrermaximilian@gmail.com";

    $search = [
            "customer_number" => true,
            "email" => $email
    ];
    if(!AddressModel::count($search)) {
        fwrite(STDERR, "=== $email not found!\n");
    }


    foreach(AddressModel::search($search) as $address) {
        if($address->email != $email) continue;

        $kunu = $address->customer_number;
        $name = str_replace(["\r\n", "\n", "\r"], " ", trim($address->getCompanyOrName()));
        $name = str_replace('"', '""', $name);
        $street = trim($address->street);
        $zip = trim($address->zip);
        $city = trim($address->city);

        $csv .= '"'.$kunu.'";';
        $csv .= '"'.$name.'";';
        $csv .= '"'.$street.'";';
        $csv .= '"'.$zip.'";';
        $csv .= '"'.$city.'";';
        $csv .= '"'.$address->email.'";';
        $csv .= '"'.$bounce_email.'"'."\n";
    }
}

echo $csv;