romaninsh

<?php
class Tabs extends View_Tabs_jUItabs {

    function addTab($title,$name=null){

        $container=$this->add('View_HtmlElement',$name);

        $this->tab_template->set(array(
                    'url'=>'#'.$container->name,
                    'tab_id'=>$container->short_name,

romaninsh

<?php


        $tt->addTab('Debtor Report Level 1')->add('Grid')->setModel('Model_Report_Debtors',['contractor_id','amount','amount_sum'])->groupBy('contractor_id')
            ->owner->removeColumn('amount');//->addCondition('contractor_id','217716');
        $tt->addTab('Debtor Report Drilldown on 217717 ')->add('Grid')->setModel('Model_Report_Debtors',['contractor_id','amount'])->addCondition('contractor_id','217717');

romaninsh

<?php

class Model_File extends LF_Model {

    public $table = 'file';
    public $storage = null;

    public $local_copy = null;

    function init(){

romaninsh

<?php
// uses https://github.com/atk4/data

$c = new smbo\Model_Payment_Transfer($db);
$c->getRef('transfer_document_id')
    ->addFields(['other_side'=>'total_gross', 'other_account_currency'=>'account_currency','other_account'=>'account']);
$c->addCondition($c->expr('abs([total_gross])!=abs([other_side])'));
$c->addCondition($c->expr('[account_currency]=[other_account_currency]'));
$c->onlyFields([
    'system_id','system','id','doc_date','ref_no','account','other_account','total_gross','other_side',

romaninsh

Example - Invoice Totals

This is a full demonstration of a basic system designed with Agile Data and Audit extension. The purpose of this example implement functionality of "Invoices" and "Lines". Each Invoice contains of multiple Lines and additionally have a few auto-fields that are calculated automatically. I used implementation without SQL Expression to keep code cross-compatible with any persistence engine.

Setting up tables

There are 2 basic tables at play. Table invoice contains:

id	ref	total

romaninsh

<?php

// This file contains comments that help you understand comparison
// criteria better: for "PHP Data Library comparison"

// http://socialcompare.com/en/comparison/php-data-access-libraries-orm-activerecord-persistence

// General Premise

// Data Access frameworks hide implementation detail of a specific database engine and allow you to work

romaninsh

<?php

namespace smbo;

class Controller_UniqueFields {
    use \atk4\core\InitializerTrait {
        init as _init;
    }
    use \atk4\core\TrackableTrait;
    use \atk4\core\AppScopeTrait;

romaninsh

<?php

namespace smbo\tests;
class VATRules extends TestCase
{

    function complextest($is_invoice_basis, $is_invoice_locked, $is_purchase) {
        if($is_invoice_basis) {
            $this->app->system['is_invoice_basis'] = true;
        }

romaninsh

<?php
namespace smbo\tests;

/**
 * Tests usage of classes thorugh bridge
 */
class InvoiceTest extends TestCase
{
    function testInvoiceCreation()
    {

romaninsh

<?php
namespace smbo;
class Model_Report_Ledger2 extends UnionModel {
    use \atk4\core\AppScopeTrait;

    function init() {
        parent::init();

        $this->addInvoices();
        $this->addPayments();