Spoje-NET / php-flexibee

Examples/FindOverdueInvoices.php

#!/usr/bin/php -f
<?php
/**
 * FlexiPeeHP - Example how to find overdue invoices
 *
 * @author     Vítězslav Dvořák <info@vitexsofware.cz>
 * @copyright  (G) 2017 Vitex Software
 */

namespace Example\FlexiPeeHP;

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

/**
 * Get Number of days overdue
 *
 * @param string $dueDate FlexiBee date
 * @return int
 */
function poSplatnosti($dueDate)
{
    return intval(date_diff(\FlexiPeeHP\FlexiBeeRO::flexiDateToDateTime($dueDate),

It seems like FlexiPeeHP\FlexiBeeRO::flexiDateToDateTime($dueDate) can also be of type false; however, parameter $object of date_diff() does only seem to accept DateTime, maybe add an additional type check?

            new \DateTime())->format('%a'));
}

/**
 * Vrať faktury po splatnosti
 *
 * @param \FlexiPeeHP\FakturaVydana $invoicer
 * @return array
 */
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',
        'datSplat',
        'datVyst'],
        "(stavUhrK is null OR stavUhrK eq 'stavUhr.castUhr') AND storno eq false",

'(stavUhrK is null OR stavUhrK eq 'stavUhr.castUhr') AND storno eq false' of type string is incompatible with the type array expected by parameter $conditions of FlexiPeeHP\RO::getColumnsFromFlexiBee().

        'id');

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

foreach (getOverdueInvoices($invoicer) as $invoice) {
    $kontakt = $firmer->getColumnsFromFlexibee(['nazev', 'email'],
        ['id' => $invoice['firma']]);

    if (isset($kontakt[0]['email'])) {
        $invoicer->setMyKey($invoice['id']);

        $to      = $kontakt[0]['email'];
        $subject = sprintf(_('Overdue invoice: %s - %s days'), $invoice['kod'],
            poSplatnosti($invoice['datSplat']));
        $body    = sprintf(_('Please pay %s,-'), $invoice['sumCelkem']);

        if ($statuser->getDataValue('licenseVariant') == 'basic') {
            $mail = new \Ease\Mailer($to, $subject, $body);
            $mail->addFile($invoicer->downloadInFormat('pdf', '/tmp/'));
            $mail->addFile($invoicer->downloadInFormat('isdoc', '/tmp/'));
            $mail->send();
        } else {
            if ($invoicer->sendByMail($to, $subject, $body)) {
                $invoicer->addStatusMessage(spritnf(_('Message sent: %s to %s'),

The function spritnf was not found. Maybe you did not declare it correctly or list all dependencies?

                        $subject, $to), 'mail');
            }
        }
    }
}