SendReminders.php

#!/usr/bin/php -f
<?php
/**
 * FlexiPeeHP - Odeslat Upomínky ?
 *
 * @author     Vítězslav Dvořák <info@vitexsofware.cz>
 * @copyright  (G) 2017-2019 Vitex Software
 */

namespace Example\FlexiPeeHP;

include_once './config.php';
include_once '../vendor/autoload.php';

$invoicer = new \FlexiPeeHP\FakturaVydana();

function getOverdueInvoices($invoicer)
{


    $result                                  = null;
    $invoicer->defaultUrlParams['order']     = 'datVyst@A';
    $invoicer->defaultUrlParams['relations'] = 'adresar,kontakt';
    $invoices                                = $invoicer->getColumnsFromFlexibee([
        'id',
        'kod',
        'stavUhrK',
        'firma',
        'buc',
        'varSym',
        'specSym',
        'sumCelkem',
        'duzpPuv',
        'datVyst'],
        "(stavUhrK is null OR stavUhrK eq 'stavUhr.castUhr') AND storno eq false",
        'id');

    if ($invoicer->lastResponseCode == 200) {
        $result = $invoices;
    }
    return $result;
}
$firmer = new \FlexiPeeHP\Adresar();

foreach (getOverdueInvoices($invoicer) as $invoice) {
    $invoicer->setData($invoice, true);

    $firmer->setMyKey($invoicer->getDataValue('firma'));

    $mail = new \Ease\Mailer($firmer->getNotificationEmailAddress(),
        sprintf(_('Overdue invoice: %s'), $invoice['kod']),
        sprintf(_('Please pay %s,-'), $invoice['sumCelkem']));

    $mail->addFile($invoicer->downloadInFormat('pdf', '/tmp/'),
        \FlexiPeeHP\Formats::$formats['PDF']['content-type']);
    $mail->addFile($invoicer->downloadInFormat('isdocx', '/tmp/'),
        \FlexiPeeHP\Formats::$formats['ISDOCx']['content-type']);

    $mail->send();
}