Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

cycle\ORM\Exception\TransactionException Transaction can't be finished. Some relations can't be resolved: Update product - tax_rate (Cycle\ORM\Relation\BelongsTo)🐛 #348

Closed
1 task done
rossaddison opened this issue Jun 21, 2022 · 36 comments
Closed
1 task done

cycle\ORM\Exception\TransactionException Transaction can't be finished. Some relations can't be resolved: Update product - tax_rate (Cycle\ORM\Relation\BelongsTo)🐛 #348

rossaddison opened this issue Jun 21, 2022 · 36 comments
Assignees
@roxblnfk
Labels
status:to be verified Needs to be reproduced and validated. type:bug Bug

Comments

@rossaddison
Copy link

rossaddison commented Jun 21, 2022 •
edited by roxblnfk
Loading

No duplicates 🥲.

  • I have searched for a similar issue in our bug tracker and didn't find any solutions.

What happened?

Ubuntu 22.04 LTS Testing and Wampserver 3.2.9 Testing
Above error common to both Windows and Ubuntu Apache2 using fork rossaddison/yii-invoice.
Event: A new product, not used in any quote, or invoice, when tax_rate_id BelongsTo dropdown edited and saved.
Also if the product's family group BelongsTo relation changes, and is saved, same error occurs.

This error occurs when the record is edited, not created.

This error did not occur when I was using annotations instead of the current Atributes. This issue is similar to issue #329

Here is the entity that is being used:

<?php

declare(strict_types=1);

namespace App\Invoice\Entity;

use Cycle\Annotated\Annotation\Column;
use Cycle\Annotated\Annotation\Entity;
use App\Invoice\Entity\Family;
use App\Invoice\Entity\TaxRate;
use App\Invoice\Entity\Unit;
use Cycle\Annotated\Annotation\Relation\BelongsTo;

#[Entity(repository: \App\Invoice\Product\ProductRepository::class)]
class Product
{
    #[Column(type: 'primary')]
    private ?int $id = null;
        
    #[Column(type: 'text', nullable: true)]
    private ?string $product_sku = '';
    
    #[Column(type: 'text', nullable: true)]
    private ?string $product_name = '';
    
    #[Column(type: 'longText', nullable: false)]
    private ?string $product_description = '';
        
    #[Column(type: 'decimal(20,2)', nullable: true)]
    private ?float $product_price = null;
    
    #[Column(type: 'decimal(20,2)', nullable: true)]
    private ?float $purchase_price = null;
    
    #[Column(type: 'text', nullable: true)]
    private ?string $provider_name = '';
    
    #[BelongsTo(target:Family::class, nullable: false, fkAction: "NO ACTION")]
    private ?Family $family = null;        
    #[Column(type: 'integer(11)', nullable: true)]
    private ?int $family_id = null;
    
    // A product has to have a tax rate before it can be created even if it is a zero tax rate    
    #[BelongsTo(target:TaxRate::class, nullable: false, fkAction: "NO ACTION")]
    private ?TaxRate $tax_rate = null;    
    #[Column(type: 'integer(11)', nullable: false)]
    private ?int $tax_rate_id = null;
        
    #[BelongsTo(target:Unit::class, nullable: false, fkAction: "NO ACTION")]
    private ?Unit $unit = null;    
    #[Column(type: 'integer(11)', nullable: true)]
    private ?int $unit_id = null;
    
    #[Column(type: 'integer(11)', nullable: true)]
    private ?int $product_tariff = null;
    
    public function __construct(
        string $product_sku = '',
        string $product_name = '',
        string $product_description = '',
        float $product_price = null,
        float $purchase_price = null,
        string $provider_name = '',
        int $product_tariff = null,
        int $tax_rate_id = null,
        int $family_id = null,
        int $unit_id = null            
    )
    {
        $this->product_sku = $product_sku;  
        $this->product_name = $product_name;
        $this->product_description = $product_description;
        $this->product_price = $product_price;
        $this->purchase_price = $purchase_price;
        $this->provider_name = $provider_name;
        $this->product_tariff = $product_tariff;
        $this->tax_rate_id = $tax_rate_id;
        $this->family_id = $family_id;
        $this->unit_id = $unit_id;
    }
    //relation $family
    public function getFamily(): ?Family
    {
        return $this->family;
    }
    //relation $tax_rate
    public function getTaxrate(): ?TaxRate
    {
        return $this->tax_rate;
    }
    //relation $unit
    public function getUnit(): ?Unit
    {
        return $this->unit;
    }    
    
    public function getProduct_id(): ?string
    {
        return (string)$this->id;
    }
    
    public function setFamily_id(int $family_id): void
    {
        $this->family_id = $family_id;
    }
    
    public function getProduct_sku(): string
    {
        return $this->product_sku;
    }
    
    public function setProduct_sku(string $product_sku): void
    {
        $this->product_sku = $product_sku;
    }
    
    public function getProduct_name(): string
    {
        return $this->product_name;
    }
    
    public function setProduct_name(string $product_name): void
    {
        $this->product_name = $product_name;
    }
    
    public function getProduct_description(): string
    {
        return $this->product_description;
    }
    
    public function setProduct_description(string $product_description): void
    {
        $this->product_description = $product_description;
    }

    public function getProduct_price(): float
    {
        return $this->product_price;
    }
    
    public function setProduct_price(float $product_price): void
    {
        $this->product_price = $product_price;
    }
    
    public function getPurchase_price(): float
    {
        return $this->purchase_price;
    }
    
    public function setPurchase_price(float $purchase_price): void
    {
        $this->purchase_price = $purchase_price;
    }
    
    public function getProvider_name(): string
    {
        return $this->provider_name;
    }
    
    public function setProvider_name(string $provider_name): void
    {
        $this->provider_name = $provider_name;
    }

    public function setTax_rate_id(int $tax_rate_id): void
    {
        $this->tax_rate_id = $tax_rate_id;
    }

    public function getTax_rate_id(): ?int
    {
        return $this->tax_rate_id;
    }

    public function setUnit_id(int $unit_id): void
    {
        $this->unit_id = $unit_id;
    }

    public function getUnit_id(): ?int
    {
        return $this->unit_id;
    }

    public function getFamily_id(): ?int
    {
        return $this->family_id;
    }
    
    public function getProduct_tariff(): int
    {
        return $this->product_tariff;
    }

    public function setProduct_tariff(int $product_tariff): void
    {
        $this->product_tariff = $product_tariff;
    }
}

Version

ORM 2.0.0 
Ubuntu PHP 8.1.2, Wampserver PHP 8.1.7
@rossaddison rossaddison added status:to be verified Needs to be reproduced and validated. type:bug Bug labels Jun 21, 2022
@rossaddison rossaddison changed the title ycle\ORM\Exception\TransactionException Transaction can't be finished. Some relations can't be resolved: Update product - tax_rate (Cycle\ORM\Relation\BelongsTo)🐛 cycle\ORM\Exception\TransactionException Transaction can't be finished. Some relations can't be resolved: Update product - tax_rate (Cycle\ORM\Relation\BelongsTo)🐛 Jun 21, 2022
@roxblnfk
Copy link
Member

Hello.

ORM 2.0.0

Can you update the orm to v2.1.1?

@roxblnfk roxblnfk mentioned this issue Jun 21, 2022
Closed
@roxblnfk
Copy link
Member

About BelongsTo relation:
Can you check that PR is about your issue? #347

@rossaddison
Copy link
Author

rossaddison commented Jun 21, 2022 via email •
edited by roxblnfk
Loading

@rossaddison
Copy link
Author

rossaddison commented Jun 21, 2022 via email

@roxblnfk
Copy link
Member

Could you render the ORM Schema in a PHP format and show here?

@TiaNex-Com
Copy link

public function setTax_rate( $tax_rate ): void
{
$this->tax_rate = $tax_rate ;
}

do you have the code
$product->setTax_rate( $tax_rate );
or $tax_rate->addProduct($product);

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited by roxblnfk
Loading

This is the _form:

<div class="form-group">
                            <label for="family_id">
                                <?= $s->trans('family'); ?>
                            </label>
                            <select name="family_id" id="family_id" class="form-control" required>
                                <option value=""><?= $s->trans('select_family'); ?></option>
                                <?php foreach ($families as $family) { ?>
                                    <option value="<?= $family->getFamily_id(); ?>"
                                        <?php $s->check_select(Html::encode($body['family_id'] ?? ''), $family->getFamily_id()); ?>
                                    ><?= $family->getFamily_name(); ?></option>
                                <?php } ?>
                            </select>
                        </div>
                        
                         <div class="form-group">
                            <label for="unit_id">
                                <?= $s->trans('product_unit'); ?>
                            </label>
                            <select name="unit_id" id="unit_id" class="form-control" required>
                                <option value=""><?= $s->trans('select_unit'); ?></option>
                                <?php foreach ($units as $unit) { ?>
                                    <option value="<?= $unit->getUnit_id(); ?>"
                                        <?php $s->check_select(Html::encode($body['unit_id'] ?? ''), $unit->getUnit_id()); ?>
                                    ><?= $unit->getUnit_name() . '/' . $unit->getUnit_name_plrl(); ?></option>
                                <?php } ?>
                            </select>
                        </div>

                        <div class="form-group">
                            <label for="tax_rate_id" required>
                                <?= $s->trans('tax_rate'); ?>  (Tip: Create a zero tax rate <a href="<?= $urlGenerator->generate('taxrate/add');?>">here</a>)
                            </label>
                            <select name="tax_rate_id" id="tax_rate_id" class="form-control" required>
                                <option value=""> <?= $s->trans('tax_rate'); ?></option>
                                <?php foreach ($tax_rates as $tax_rate) { ?>
                                    <option value="<?= $tax_rate->getTax_rate_id(); ?>"
                                        <?php $s->check_select(Html::encode($body['tax_rate_id'] ?? ''), $tax_rate->getTax_rate_id()); ?>>
                                        <?= $tax_rate->getTax_rate_name()
                                            . ' (' . ($s->format_amount($tax_rate->getTax_rate_percent()) ?: '0.00') . '%)'; ?>
                                    </option>
                                <?php } ?>
                            </select>
                        </div>

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited
Loading

This is the controller:

public function edit(ViewRenderer $head, SessionInterface $session, Request $request, CurrentRoute $currentRoute, ValidatorInterface $validator,
                    pR $pR, sR $sR, fR $fR, uR $uR, trR $trR, 
    ): Response {
        $this->rbac();
        $parameters = [
            'title' => $sR->trans('edit'),
            'action' => ['product/edit', ['id' => $this->product($currentRoute, $pR)->getProduct_id()]],
            'errors' => [],
            'body' => $this->body($this->product($currentRoute, $pR)),
            's'=>$sR,
            'head'=>$head,
            'families'=>$fR->findAllPreloaded(),
            'units'=>$uR->findAllPreloaded(),
            'tax_rates'=>$trR->findAllPreloaded()    
        ];
        if ($request->getMethod() === Method::POST) {
            $form = new ProductForm();
            $body = $request->getParsedBody();
            if ($form->load($body) && $validator->validate($form)->isValid()) {
                $this->productService->saveProduct($this->product($currentRoute, $pR), $form);  
                $this->flash('info', $sR->trans('record_successfully_updated'));
                return $this->webService->getRedirectResponse('product/index');   
            }
            $parameters['body'] = $body;
            $parameters['errors'] = $form->getFormErrors();
        }
        // BelongsTo bug: => render a form different to _form with BelongTo fields family_id, unit_id, tax_rate_id hidden.
        // The user will have to delete the product / service. This deletion will be prevented if the product exists on 
        // a quote or invoice. 
        return $this->viewRenderer->render('_form_edit', $parameters);
    }

@rossaddison
Copy link
Author

This is the service:

public function saveProduct(Product $model, ProductForm $form): void
    {
        $model->setProduct_sku($form->getProduct_sku());
        $model->setProduct_name($form->getProduct_name());
        $model->setProduct_description($form->getProduct_description());
        $model->setProduct_price($form->getProduct_price());
        $model->setPurchase_price($form->getPurchase_price());
        $model->setProvider_name($form->getProvider_name());
        $model->setProduct_tariff($form->getProduct_tariff()); 
        $model->setTax_rate_id((int)$form->getTax_rate_id());
        $model->setUnit_id((int)$form->getUnit_id());
        $model->setFamily_id((int)$form->getFamily_id());
               
        $this->repository->save($model);
    }

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited by roxblnfk
Loading

This is the Form code:

<?php

declare(strict_types=1);

namespace App\Invoice\Product;

use Yiisoft\Form\FormModel;
use Yiisoft\Validator\Rule\Required;

final class ProductForm extends FormModel
{
    private ?string $product_sku = null;
    private ?string $product_name = null;
    private ?string $product_description = null;
    private ?float $product_price = 0.00;
    private ?float $purchase_price = 0.00;
    private ?string $provider_name = null;
    private ?string $family_id = '';
    private ?string $tax_rate_id = '';
    private ?string $unit_id = '';
    private ?int $product_tariff = null;
               
    public function getProduct_sku(): string|null
    {
        return $this->product_sku;
    }
    
    public function getProduct_name(): string|null
    {
        return $this->product_name;
    }
    
    public function getProduct_description(): string|null
    {
        return $this->product_description;
    }
    
    public function getProduct_price(): float|null
    {
        return $this->product_price;
    }
    
    public function getPurchase_price(): float|null
    {
        return $this->purchase_price;
    }
    
    public function getProvider_name(): string|null
    {
        return $this->provider_name;
    }
    
    public function getFamily_id(): string|null
    {
        return $this->family_id;
    }
    
    public function getTax_rate_id(): string|null
    {
        return $this->tax_rate_id;
    }
    
    public function getUnit_id(): string|null
    {
        return $this->unit_id;
    }  
    
    public function getProduct_tariff(): int|null
    {
        return $this->product_tariff;
    }
    
    public function getFormName(): string
    {
        return '';
    }
    
    public function getRules(): array
    {
        return [
            'family_id' => [new Required()],
            'product_name' => [new Required()],
            'tax_rate_id' => [new Required()],
        ];
    }
}

@rossaddison
Copy link
Author

How do you render the Orm schema?

@butschster
Copy link
Contributor

github.com/rossaddison/yii-invoice

You can use https://github.com/cycle/schema-renderer for schema rendering

@roxblnfk
Copy link
Member

roxblnfk commented Aug 4, 2022

How do you render the Orm schema?

https://github.com/yiisoft/yii-cycle/blob/master/docs/en/console-commands.md#common

cycle/schema/php [file] - Export current schema as PHP file

@rossaddison
Copy link
Author

This is schema:

image

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited by roxblnfk
Loading

Schema php

<?php

declare(strict_types=1);

use Cycle\ORM\Relation;
use Cycle\ORM\SchemaInterface as Schema;

return [
    'identity' => [
        Schema::ENTITY => 'App\\Auth\\Identity',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Auth\\IdentityRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'identity',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'authKey' => 'auth_key',
            'user_id' => 'user_id',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_EAGER,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'user_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'comment' => [
        Schema::ENTITY => 'App\\Blog\\Entity\\Comment',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Blog\\Comment\\CommentRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'comment',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'public' => 'public',
            'content' => 'content',
            'created_at' => 'created_at',
            'updated_at' => 'updated_at',
            'published_at' => 'published_at',
            'deleted_at' => 'deleted_at',
            'user_id' => 'user_id',
            'post_id' => 'post_id',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_EAGER,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'post' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'post',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'post_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => 'App\\Blog\\Comment\\Scope\\PublicScope',
        Schema::TYPECAST => [
            'id' => 'int',
            'public' => 'bool',
            'created_at' => 'datetime',
            'updated_at' => 'datetime',
            'published_at' => 'datetime',
            'deleted_at' => 'datetime',
            'user_id' => 'int',
            'post_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'created_at',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'updated_at',
                    'nullable' => false,
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\SoftDelete',
                [
                    'field' => 'deleted_at',
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'post' => [
        Schema::ENTITY => 'App\\Blog\\Entity\\Post',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Blog\\Post\\PostRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'post',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'slug' => 'slug',
            'title' => 'title',
            'public' => 'public',
            'content' => 'content',
            'created_at' => 'created_at',
            'updated_at' => 'updated_at',
            'published_at' => 'published_at',
            'deleted_at' => 'deleted_at',
            'user_id' => 'user_id',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'tags' => [
                Relation::TYPE => Relation::MANY_TO_MANY,
                Relation::TARGET => 'tag',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::WHERE => [],
                    Relation::ORDER_BY => [],
                    Relation::INNER_KEY => ['id'],
                    Relation::OUTER_KEY => ['id'],
                    Relation::THROUGH_ENTITY => 'postTag',
                    Relation::THROUGH_INNER_KEY => 'post_id',
                    Relation::THROUGH_OUTER_KEY => 'tag_id',
                    Relation::THROUGH_WHERE => [],
                    '4' => null,
                ],
            ],
            'comments' => [
                Relation::TYPE => Relation::HAS_MANY,
                Relation::TARGET => 'comment',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::WHERE => [],
                    Relation::ORDER_BY => [],
                    Relation::INNER_KEY => ['id'],
                    Relation::OUTER_KEY => 'post_id',
                    '4' => null,
                ],
            ],
        ],
        Schema::SCOPE => 'App\\Blog\\Post\\Scope\\PublicScope',
        Schema::TYPECAST => [
            'id' => 'int',
            'public' => 'bool',
            'created_at' => 'datetime',
            'updated_at' => 'datetime',
            'published_at' => 'datetime',
            'deleted_at' => 'datetime',
            'user_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'created_at',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'updated_at',
                    'nullable' => false,
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\SoftDelete',
                [
                    'field' => 'deleted_at',
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'postTag' => [
        Schema::ENTITY => 'App\\Blog\\Entity\\PostTag',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'Cycle\\ORM\\Select\\Repository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'post_tag',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'post_id' => 'post_id',
            'tag_id' => 'tag_id',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'post_id' => 'int',
            'tag_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'tag' => [
        Schema::ENTITY => 'App\\Blog\\Entity\\Tag',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Blog\\Tag\\TagRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'tag',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'label' => 'label',
            'created_at' => 'created_at',
        ],
        Schema::RELATIONS => [
            'posts' => [
                Relation::TYPE => Relation::MANY_TO_MANY,
                Relation::TARGET => 'post',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::WHERE => [],
                    Relation::ORDER_BY => [],
                    Relation::INNER_KEY => ['id'],
                    Relation::OUTER_KEY => ['id'],
                    Relation::THROUGH_ENTITY => 'postTag',
                    Relation::THROUGH_INNER_KEY => 'tag_id',
                    Relation::THROUGH_OUTER_KEY => 'post_id',
                    Relation::THROUGH_WHERE => [],
                    '4' => null,
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'created_at' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'created_at',
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'client' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Client',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Client\\ClientRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'client',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'client_date_created' => 'client_date_created',
            'client_date_modified' => 'client_date_modified',
            'client_name' => 'client_name',
            'client_address_1' => 'client_address_1',
            'client_address_2' => 'client_address_2',
            'client_city' => 'client_city',
            'client_state' => 'client_state',
            'client_zip' => 'client_zip',
            'client_country' => 'client_country',
            'client_phone' => 'client_phone',
            'client_fax' => 'client_fax',
            'client_mobile' => 'client_mobile',
            'client_email' => 'client_email',
            'client_web' => 'client_web',
            'client_vat_id' => 'client_vat_id',
            'client_tax_code' => 'client_tax_code',
            'client_language' => 'client_language',
            'client_active' => 'client_active',
            'client_surname' => 'client_surname',
            'client_avs' => 'client_avs',
            'client_insurednumber' => 'client_insurednumber',
            'client_veka' => 'client_veka',
            'client_birthdate' => 'client_birthdate',
            'client_gender' => 'client_gender',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'client_date_created' => 'datetime',
            'client_date_modified' => 'datetime',
            'client_active' => 'bool',
            'client_birthdate' => 'datetime',
            'client_gender' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'client_date_created',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'client_date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'clientCustom' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\ClientCustom',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\ClientCustom\\ClientCustomRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'client_custom',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'client_id' => 'client_id',
            'custom_field_id' => 'custom_field_id',
            'value' => 'value',
        ],
        Schema::RELATIONS => [
            'client' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'client',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'client_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'custom_field' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'customField',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'custom_field_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'client_id' => 'int',
            'custom_field_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'clientNote' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\ClientNote',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\ClientNote\\ClientNoteRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'client_note',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'client_id' => 'client_id',
            'date' => 'date',
            'note' => 'note',
        ],
        Schema::RELATIONS => [
            'client' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'client',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'client_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'client_id' => 'int',
            'date' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'company' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Company',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Company\\CompanyRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'company',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'current' => 'current',
            'name' => 'name',
            'address_1' => 'address_1',
            'address_2' => 'address_2',
            'city' => 'city',
            'state' => 'state',
            'zip' => 'zip',
            'country' => 'country',
            'phone' => 'phone',
            'fax' => 'fax',
            'email' => 'email',
            'web' => 'web',
            'date_created' => 'date_created',
            'date_modified' => 'date_modified',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'current' => 'int',
            'date_created' => 'datetime',
            'date_modified' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'date_created',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'companyPrivate' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\CompanyPrivate',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\CompanyPrivate\\CompanyPrivateRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'company_private',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'company_id' => 'company_id',
            'vat_id' => 'vat_id',
            'tax_code' => 'tax_code',
            'iban' => 'iban',
            'gln' => 'gln',
            'rcc' => 'rcc',
            'date_created' => 'date_created',
            'date_modified' => 'date_modified',
        ],
        Schema::RELATIONS => [
            'company' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'company',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'company_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'company_id' => 'int',
            'gln' => 'int',
            'date_created' => 'datetime',
            'date_modified' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'customField' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\CustomField',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\CustomField\\CustomFieldRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'custom_field',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'table' => 'table',
            'label' => 'label',
            'type' => 'type',
            'location' => 'location',
            'order' => 'order',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'location' => 'int',
            'order' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'customValue' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\CustomValue',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\CustomValue\\CustomValueRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'custom_value',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'custom_field_id' => 'custom_field_id',
            'value' => 'value',
        ],
        Schema::RELATIONS => [
            'custom_field' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'customField',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'custom_field_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'custom_field_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'emailTemplate' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\EmailTemplate',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\EmailTemplate\\EmailTemplateRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'email_template',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'email_template_title' => 'email_template_title',
            'email_template_type' => 'email_template_type',
            'email_template_body' => 'email_template_body',
            'email_template_subject' => 'email_template_subject',
            'email_template_from_name' => 'email_template_from_name',
            'email_template_from_email' => 'email_template_from_email',
            'email_template_cc' => 'email_template_cc',
            'email_template_bcc' => 'email_template_bcc',
            'email_template_pdf_template' => 'email_template_pdf_template',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'family' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Family',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Family\\FamilyRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'family',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'family_name' => 'family_name',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'gentor' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Gentor',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Generator\\GeneratorRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'gentor',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'route_prefix' => 'route_prefix',
            'route_suffix' => 'route_suffix',
            'camelcase_capital_name' => 'camelcase_capital_name',
            'small_singular_name' => 'small_singular_name',
            'small_plural_name' => 'small_plural_name',
            'namespace_path' => 'namespace_path',
            'controller_layout_dir' => 'controller_layout_dir',
            'controller_layout_dir_dot_path' => 'controller_layout_dir_dot_path',
            'repo_extra_camelcase_name' => 'repo_extra_camelcase_name',
            'paginator_next_page_attribute' => 'paginator_next_page_attribute',
            'constrain_index_field' => 'constrain_index_field',
            'filter_field' => 'filter_field',
            'filter_field_start_position' => 'filter_field_start_position',
            'filter_field_end_position' => 'filter_field_end_position',
            'pre_entity_table' => 'pre_entity_table',
            'modified_include' => 'modified_include',
            'created_include' => 'created_include',
            'updated_include' => 'updated_include',
            'deleted_include' => 'deleted_include',
            'keyset_paginator_include' => 'keyset_paginator_include',
            'offset_paginator_include' => 'offset_paginator_include',
            'flash_include' => 'flash_include',
            'headerline_include' => 'headerline_include',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'filter_field_start_position' => 'int',
            'filter_field_end_position' => 'int',
            'modified_include' => 'bool',
            'created_include' => 'bool',
            'updated_include' => 'bool',
            'deleted_include' => 'bool',
            'keyset_paginator_include' => 'bool',
            'offset_paginator_include' => 'bool',
            'flash_include' => 'bool',
            'headerline_include' => 'bool',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'gentorRelation' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\GentorRelation',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\GeneratorRelation\\GeneratorRelationRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'gentor_relation',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'lowercasename' => 'lowercasename',
            'camelcasename' => 'camelcasename',
            'view_field_name' => 'view_field_name',
            'gentor_id' => 'gentor_id',
        ],
        Schema::RELATIONS => [
            'gentor' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'gentor',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'gentor_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'gentor_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'group' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Group',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Group\\GroupRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'group',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'name' => 'name',
            'identifier_format' => 'identifier_format',
            'next_id' => 'next_id',
            'left_pad' => 'left_pad',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'next_id' => 'int',
            'left_pad' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'inv' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Inv',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Inv\\InvRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'client_id' => 'client_id',
            'group_id' => 'group_id',
            'user_id' => 'user_id',
            'status_id' => 'status_id',
            'is_read_only' => 'is_read_only',
            'password' => 'password',
            'time_created' => 'time_created',
            'date_due' => 'date_due',
            'number' => 'number',
            'discount_amount' => 'discount_amount',
            'discount_percent' => 'discount_percent',
            'terms' => 'terms',
            'url_key' => 'url_key',
            'payment_method' => 'payment_method',
            'creditinvoice_parent_id' => 'creditinvoice_parent_id',
            'date_created' => 'date_created',
            'date_modified' => 'date_modified',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'group' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'group',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'group_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'client' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'client',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'client_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'client_id' => 'int',
            'group_id' => 'int',
            'user_id' => 'int',
            'status_id' => 'int',
            'is_read_only' => 'bool',
            'time_created' => 'datetime',
            'date_due' => 'datetime',
            'discount_amount' => 'float',
            'discount_percent' => 'float',
            'payment_method' => 'int',
            'creditinvoice_parent_id' => 'int',
            'date_created' => 'datetime',
            'date_modified' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'date_created',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'invAmount' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\InvAmount',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\InvAmount\\InvAmountRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv_amount',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'sign' => 'sign',
            'item_subtotal' => 'item_subtotal',
            'item_tax_total' => 'item_tax_total',
            'tax_total' => 'tax_total',
            'total' => 'total',
            'paid' => 'paid',
            'balance' => 'balance',
        ],
        Schema::RELATIONS => [
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'sign' => 'int',
            'item_subtotal' => 'float',
            'item_tax_total' => 'float',
            'tax_total' => 'float',
            'total' => 'float',
            'paid' => 'float',
            'balance' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'invCustom' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\InvCustom',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\InvCustom\\InvCustomRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv_custom',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'custom_field_id' => 'custom_field_id',
            'value' => 'value',
        ],
        Schema::RELATIONS => [
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'custom_field' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'customField',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'custom_field_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'custom_field_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'invItem' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\InvItem',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\InvItem\\InvItemRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv_item',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'tax_rate_id' => 'tax_rate_id',
            'product_id' => 'product_id',
            'task_id' => 'task_id',
            'date_added' => 'date_added',
            'name' => 'name',
            'description' => 'description',
            'quantity' => 'quantity',
            'price' => 'price',
            'discount_amount' => 'discount_amount',
            'order' => 'order',
            'is_recurring' => 'is_recurring',
            'product_unit' => 'product_unit',
            'product_unit_id' => 'product_unit_id',
            'date' => 'date',
        ],
        Schema::RELATIONS => [
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'product' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'product',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'product_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'task' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'task',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'task_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'tax_rate_id' => 'int',
            'product_id' => 'int',
            'task_id' => 'int',
            'date_added' => 'datetime',
            'quantity' => 'float',
            'price' => 'float',
            'discount_amount' => 'float',
            'order' => 'int',
            'is_recurring' => 'bool',
            'product_unit_id' => 'int',
            'date' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'invItemAmount' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\InvItemAmount',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\InvItemAmount\\InvItemAmountRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv_item_amount',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_item_id' => 'inv_item_id',
            'subtotal' => 'subtotal',
            'tax_total' => 'tax_total',
            'discount' => 'discount',
            'total' => 'total',
        ],
        Schema::RELATIONS => [
            'inv_item' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'invItem',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_item_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_item_id' => 'int',
            'subtotal' => 'float',
            'tax_total' => 'float',
            'discount' => 'float',
            'total' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'invRecurring' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\InvRecurring',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\InvRecurring\\InvRecurringRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv_recurring',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'start' => 'start',
            'end' => 'end',
            'frequency' => 'frequency',
            'next' => 'next',
        ],
        Schema::RELATIONS => [
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'start' => 'datetime',
            'end' => 'datetime',
            'next' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'invTaxRate' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\InvTaxRate',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\InvTaxRate\\InvTaxRateRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'inv_tax_rate',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'tax_rate_id' => 'tax_rate_id',
            'include_item_tax' => 'include_item_tax',
            'inv_tax_rate_amount' => 'inv_tax_rate_amount',
        ],
        Schema::RELATIONS => [
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'tax_rate_id' => 'int',
            'include_item_tax' => 'int',
            'inv_tax_rate_amount' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'itemLookup' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\ItemLookup',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\ItemLookup\\ItemLookupRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'item_lookup',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'name' => 'name',
            'description' => 'description',
            'price' => 'price',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'price' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'merchant' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Merchant',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Merchant\\MerchantRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'merchant',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'successful' => 'successful',
            'date' => 'date',
            'driver' => 'driver',
            'response' => 'response',
            'reference' => 'reference',
        ],
        Schema::RELATIONS => [
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'successful' => 'bool',
            'date' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'payment' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Payment',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Payment\\PaymentRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'payment',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'payment_method_id' => 'payment_method_id',
            'payment_date' => 'payment_date',
            'amount' => 'amount',
            'note' => 'note',
            'inv_id' => 'inv_id',
        ],
        Schema::RELATIONS => [
            'inv' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'inv',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'inv_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'payment_method' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'paymentMethod',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'payment_method_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'payment_method_id' => 'int',
            'payment_date' => 'datetime',
            'amount' => 'float',
            'inv_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'paymentCustom' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\PaymentCustom',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\PaymentCustom\\PaymentCustomRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'payment_custom',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'payment_id' => 'payment_id',
            'custom_field_id' => 'custom_field_id',
            'value' => 'value',
        ],
        Schema::RELATIONS => [
            'payment' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'payment',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'payment_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'custom_field' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'customField',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'custom_field_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'payment_id' => 'int',
            'custom_field_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'paymentMethod' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\PaymentMethod',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\PaymentMethod\\PaymentMethodRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'payment_method',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'name' => 'name',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'product' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Product',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Product\\ProductRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'product',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'product_sku' => 'product_sku',
            'product_name' => 'product_name',
            'product_description' => 'product_description',
            'product_price' => 'product_price',
            'purchase_price' => 'purchase_price',
            'provider_name' => 'provider_name',
            'family_id' => 'family_id',
            'tax_rate_id' => 'tax_rate_id',
            'unit_id' => 'unit_id',
            'product_tariff' => 'product_tariff',
        ],
        Schema::RELATIONS => [
            'family' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'family',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'family_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'unit' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'unit',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'unit_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'product_price' => 'float',
            'purchase_price' => 'float',
            'family_id' => 'int',
            'tax_rate_id' => 'int',
            'unit_id' => 'int',
            'product_tariff' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'productCustom' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\ProductCustom',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\ProductCustom\\ProductCustomRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'product_custom',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'product_id' => 'product_id',
            'custom_field_id' => 'custom_field_id',
            'value' => 'value',
        ],
        Schema::RELATIONS => [
            'product' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'product',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'product_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'custom_field' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'customField',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'custom_field_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'product_id' => 'int',
            'custom_field_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'profile' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Profile',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Profile\\ProfileRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'profile',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'company_id' => 'company_id',
            'current' => 'current',
            'mobile' => 'mobile',
            'email' => 'email',
            'description' => 'description',
            'date_created' => 'date_created',
            'date_modified' => 'date_modified',
        ],
        Schema::RELATIONS => [
            'company' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'company',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'company_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'company_id' => 'int',
            'current' => 'int',
            'date_created' => 'datetime',
            'date_modified' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'project' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Project',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Project\\ProjectRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'project',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'client_id' => 'client_id',
            'name' => 'name',
        ],
        Schema::RELATIONS => [
            'client' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'client',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'client_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'client_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'quote' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Quote',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Quote\\QuoteRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'quote',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'inv_id' => 'inv_id',
            'user_id' => 'user_id',
            'client_id' => 'client_id',
            'group_id' => 'group_id',
            'status_id' => 'status_id',
            'date_created' => 'date_created',
            'date_modified' => 'date_modified',
            'date_expires' => 'date_expires',
            'number' => 'number',
            'discount_amount' => 'discount_amount',
            'discount_percent' => 'discount_percent',
            'url_key' => 'url_key',
            'password' => 'password',
            'notes' => 'notes',
        ],
        Schema::RELATIONS => [
            'client' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'client',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'client_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'group' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'group',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'group_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'inv_id' => 'int',
            'user_id' => 'int',
            'client_id' => 'int',
            'group_id' => 'int',
            'status_id' => 'int',
            'date_created' => 'datetime',
            'date_modified' => 'datetime',
            'date_expires' => 'datetime',
            'discount_amount' => 'float',
            'discount_percent' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'date_created',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'quoteAmount' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\QuoteAmount',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\QuoteAmount\\QuoteAmountRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'quote_amount',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'quote_id' => 'quote_id',
            'item_subtotal' => 'item_subtotal',
            'item_tax_total' => 'item_tax_total',
            'tax_total' => 'tax_total',
            'total' => 'total',
        ],
        Schema::RELATIONS => [
            'quote' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'quote',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'quote_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'quote_id' => 'int',
            'item_subtotal' => 'float',
            'item_tax_total' => 'float',
            'tax_total' => 'float',
            'total' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'quoteCustom' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\QuoteCustom',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\QuoteCustom\\QuoteCustomRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'quote_custom',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'quote_id' => 'quote_id',
            'custom_field_id' => 'custom_field_id',
            'value' => 'value',
        ],
        Schema::RELATIONS => [
            'custom_field' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'customField',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'custom_field_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'quote' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'quote',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'quote_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'quote_id' => 'int',
            'custom_field_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'quoteItem' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\QuoteItem',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\QuoteItem\\QuoteItemRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'quote_item',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'quote_id' => 'quote_id',
            'tax_rate_id' => 'tax_rate_id',
            'product_id' => 'product_id',
            'date_added' => 'date_added',
            'name' => 'name',
            'description' => 'description',
            'quantity' => 'quantity',
            'price' => 'price',
            'discount_amount' => 'discount_amount',
            'order' => 'order',
            'product_unit' => 'product_unit',
            'product_unit_id' => 'product_unit_id',
        ],
        Schema::RELATIONS => [
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'product' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'product',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'product_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'quote' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'quote',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'quote_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'quote_id' => 'int',
            'tax_rate_id' => 'int',
            'product_id' => 'int',
            'date_added' => 'datetime',
            'quantity' => 'float',
            'price' => 'float',
            'discount_amount' => 'float',
            'order' => 'int',
            'product_unit_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'quoteItemAmount' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\QuoteItemAmount',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\QuoteItemAmount\\QuoteItemAmountRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'quote_item_amount',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'quote_item_id' => 'quote_item_id',
            'subtotal' => 'subtotal',
            'tax_total' => 'tax_total',
            'discount' => 'discount',
            'total' => 'total',
        ],
        Schema::RELATIONS => [
            'quote_item' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'quoteItem',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'quote_item_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'quote_item_id' => 'int',
            'subtotal' => 'float',
            'tax_total' => 'float',
            'discount' => 'float',
            'total' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'quoteTaxRate' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\QuoteTaxRate',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\QuoteTaxRate\\QuoteTaxRateRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'quote_tax_rate',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'quote_id' => 'quote_id',
            'tax_rate_id' => 'tax_rate_id',
            'include_item_tax' => 'include_item_tax',
            'quote_tax_rate_amount' => 'quote_tax_rate_amount',
        ],
        Schema::RELATIONS => [
            'quote' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'quote',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'quote_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'quote_id' => 'int',
            'tax_rate_id' => 'int',
            'include_item_tax' => 'int',
            'quote_tax_rate_amount' => 'float',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'setting' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Setting',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Setting\\SettingRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'setting',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'setting_key' => 'setting_key',
            'setting_value' => 'setting_value',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'sumex' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Sumex',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Sumex\\SumexRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'sumex',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'invoice' => 'invoice',
            'reason' => 'reason',
            'diagnosis' => 'diagnosis',
            'observations' => 'observations',
            'treatmentstart' => 'treatmentstart',
            'treatmentend' => 'treatmentend',
            'casedate' => 'casedate',
            'casenumber' => 'casenumber',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'invoice' => 'int',
            'reason' => 'int',
            'treatmentstart' => 'datetime',
            'treatmentend' => 'datetime',
            'casedate' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'task' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Task',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Task\\TaskRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'task',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'project_id' => 'project_id',
            'name' => 'name',
            'description' => 'description',
            'price' => 'price',
            'finish_date' => 'finish_date',
            'status' => 'status',
            'tax_rate_id' => 'tax_rate_id',
        ],
        Schema::RELATIONS => [
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'project' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'project',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => true,
                    Relation::INNER_KEY => 'project_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'project_id' => 'int',
            'price' => 'float',
            'finish_date' => 'datetime',
            'status' => 'int',
            'tax_rate_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'taxRate' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\TaxRate',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\TaxRate\\TaxRateRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'tax_rate',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'tax_rate_name' => 'tax_rate_name',
            'tax_rate_percent' => 'tax_rate_percent',
            'tax_rate_default' => 'tax_rate_default',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'tax_rate_percent' => 'float',
            'tax_rate_default' => 'bool',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'unit' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Unit',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Unit\\UnitRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'unit',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'unit_name' => 'unit_name',
            'unit_name_plrl' => 'unit_name_plrl',
        ],
        Schema::RELATIONS => [],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'userClient' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\UserClient',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\UserClient\\UserClientRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'user_client',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'user_id' => 'user_id',
            'client_id' => 'client_id',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'client' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'client',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'client_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'user_id' => 'int',
            'client_id' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'userCustom' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\UserCustom',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\UserCustom\\UserCustomRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'user_custom',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'user_id' => 'user_id',
            'fieldid' => 'fieldid',
            'fieldvalue' => 'fieldvalue',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'user_id' => 'int',
            'fieldid' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],
    'userInv' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\UserInv',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\UserInv\\UserInvRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'user_inv',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'user_id' => 'user_id',
            'type' => 'type',
            'active' => 'active',
            'date_created' => 'date_created',
            'date_modified' => 'date_modified',
            'language' => 'language',
            'name' => 'name',
            'company' => 'company',
            'address_1' => 'address_1',
            'address_2' => 'address_2',
            'city' => 'city',
            'state' => 'state',
            'zip' => 'zip',
            'country' => 'country',
            'phone' => 'phone',
            'fax' => 'fax',
            'mobile' => 'mobile',
            'email' => 'email',
            'password' => 'password',
            'web' => 'web',
            'vat_id' => 'vat_id',
            'tax_code' => 'tax_code',
            'all_clients' => 'all_clients',
            'salt' => 'salt',
            'passwordreset_token' => 'passwordreset_token',
            'subscribernumber' => 'subscribernumber',
            'iban' => 'iban',
            'gln' => 'gln',
            'rcc' => 'rcc',
        ],
        Schema::RELATIONS => [
            'user' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'user',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'user_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'user_id' => 'int',
            'type' => 'int',
            'active' => 'bool',
            'date_created' => 'datetime',
            'date_modified' => 'datetime',
            'all_clients' => 'bool',
            'gln' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'date_created',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'date_modified',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
    'user' => [
        Schema::ENTITY => 'App\\User\\User',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\User\\UserRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'user',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'login' => 'login',
            'passwordHash' => 'password_hash',
            'created_at' => 'created_at',
            'updated_at' => 'updated_at',
        ],
        Schema::RELATIONS => [
            'identity' => [
                Relation::TYPE => Relation::HAS_ONE,
                Relation::TARGET => 'identity',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => ['id'],
                    Relation::OUTER_KEY => 'user_id',
                ],
            ],
            'posts' => [
                Relation::TYPE => Relation::HAS_MANY,
                Relation::TARGET => 'post',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::WHERE => [],
                    Relation::ORDER_BY => [],
                    Relation::INNER_KEY => ['id'],
                    Relation::OUTER_KEY => 'user_id',
                    '4' => null,
                ],
            ],
            'comments' => [
                Relation::TYPE => Relation::HAS_MANY,
                Relation::TARGET => 'comment',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::WHERE => [],
                    Relation::ORDER_BY => [],
                    Relation::INNER_KEY => ['id'],
                    Relation::OUTER_KEY => 'user_id',
                    '4' => null,
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'created_at' => 'datetime',
            'updated_at' => 'datetime',
        ],
        Schema::SCHEMA => [],
        Schema::LISTENERS => [
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\CreatedAt',
                [
                    'field' => 'created_at',
                ],
            ],
            [
                'Cycle\\ORM\\Entity\\Behavior\\Listener\\UpdatedAt',
                [
                    'field' => 'updated_at',
                    'nullable' => false,
                ],
            ],
        ],
        Schema::TYPECAST_HANDLER => null,
    ],
];

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited by roxblnfk
Loading

Specifically the product schema table:

'product' => [
        Schema::ENTITY => 'App\\Invoice\\Entity\\Product',
        Schema::MAPPER => 'Cycle\\ORM\\Mapper\\Mapper',
        Schema::SOURCE => 'Cycle\\ORM\\Select\\Source',
        Schema::REPOSITORY => 'App\\Invoice\\Product\\ProductRepository',
        Schema::DATABASE => 'default',
        Schema::TABLE => 'product',
        Schema::PRIMARY_KEY => ['id'],
        Schema::FIND_BY_KEYS => ['id'],
        Schema::COLUMNS => [
            'id' => 'id',
            'product_sku' => 'product_sku',
            'product_name' => 'product_name',
            'product_description' => 'product_description',
            'product_price' => 'product_price',
            'purchase_price' => 'purchase_price',
            'provider_name' => 'provider_name',
            'family_id' => 'family_id',
            'tax_rate_id' => 'tax_rate_id',
            'unit_id' => 'unit_id',
            'product_tariff' => 'product_tariff',
        ],
        Schema::RELATIONS => [
            'family' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'family',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'family_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'tax_rate' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'taxRate',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'tax_rate_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
            'unit' => [
                Relation::TYPE => Relation::BELONGS_TO,
                Relation::TARGET => 'unit',
                Relation::LOAD => Relation::LOAD_PROMISE,
                Relation::SCHEMA => [
                    Relation::CASCADE => true,
                    Relation::NULLABLE => false,
                    Relation::INNER_KEY => 'unit_id',
                    Relation::OUTER_KEY => ['id'],
                ],
            ],
        ],
        Schema::SCOPE => null,
        Schema::TYPECAST => [
            'id' => 'int',
            'product_price' => 'float',
            'purchase_price' => 'float',
            'family_id' => 'int',
            'tax_rate_id' => 'int',
            'unit_id' => 'int',
            'product_tariff' => 'int',
        ],
        Schema::SCHEMA => [],
        Schema::TYPECAST_HANDLER => null,
    ],

@roxblnfk
Copy link
Member

roxblnfk commented Aug 4, 2022

Schema looks OK. I was expecting a slightly different result from the inner/outer keys generator.

Can you dump the entity before edit and after edit (before save)? Needed fields: $tax_rate_id and $tax_rate

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited
Loading

This is a schema which I have pulled from rossaddison/yii-invoice which is a fork of yiisoft/demo. Specifically from

runtime/schema.php generated by the rossaddison/yii-invoice fork once it is running as a result of using config/params.php

'schema-providers' => [
            // Uncomment next line to enable a Schema caching in the common cache
            //\Yiisoft\Yii\Cycle\Schema\Provider\SimpleCacheSchemaProvider::class => ['key' => 'cycle-orm-cache-key'],

            // Store generated Schema in the file
            \Yiisoft\Yii\Cycle\Schema\Provider\PhpFileSchemaProvider::class => [
               'mode' => \Yiisoft\Yii\Cycle\Schema\Provider\PhpFileSchemaProvider::MODE_READ_AND_WRITE,
               'file' => 'runtime/schema.php',
            ],

            ////\Yiisoft\Yii\Cycle\Schema\Provider\FromConveyorSchemaProvider::class => [
            ////    'generators' => [
            ////         Cycle\Schema\Generator\SyncTables::class, // sync table changes to database
            ////    ],
            ////],
        ],

I was not sure how to initialize the schema using the https://github.com/cycle/schema-renderer, specifically the details between the square brackets.

$schema = new Schema([...]);

Yii does the schema.php at runtime so I chose the above by simply copying the file from my runtime folder but I would still like to know how to do it through Cycle.

@rossaddison
Copy link
Author

rossaddison commented Aug 4, 2022 •
edited by roxblnfk
Loading

Yes I believe the outer key should be without the square brackets ie. id and not [id]
so that when it is joined with the relation tax_rate it creates the complete key tax_rate_id
but that is just my mind and I have not walked through the code yet.

@rossaddison
Copy link
Author

How do I dump the entity?

@TiaNex-Com
Copy link

$model->setTax_rate_id((int)$form->getTax_rate_id());

i mean try to change $model->setTax_rate_id((int)$form->getTax_rate_id());

to $model->setTax_rate( Tax_rate ); to establish the relations

@roxblnfk
Copy link
Member

roxblnfk commented Aug 5, 2022 

$schema = new Schema([...]);

Yii does the schema.php at runtime so I chose the above by simply copying the file from my runtime folder but I would still like to know how to do it through Cycle.

It's OK. Yii3 uses the cycle/schema-renderer package to generate schema.php in schema-file-cache. You can use these commands to render the Cycle Schema - they also use cycle/schema-renderer

@rossaddison
Copy link
Author

Ok, ran C:\wamp64\www\yii-invoice>yii cycle/schema and got the following.

[product] :: default.product
       Entity: App\Invoice\Entity\Product
       Mapper: Cycle\ORM\Mapper\Mapper
   Repository: App\Invoice\Product\ProductRepository
  Primary key: id
       Fields:
               (property -> db.field -> typecast)
               id -> id -> int
               product_sku -> product_sku
               product_name -> product_name
               product_description -> product_description
               product_price -> product_price -> float
               purchase_price -> purchase_price -> float
               provider_name -> provider_name
               family_id -> family_id -> int
               tax_rate_id -> tax_rate_id -> int
               unit_id -> unit_id -> int
               product_tariff -> product_tariff -> int
    Relations:
     product->family belongs to family, lazy loading, cascaded
       not null product.family_id <==> family.id
     product->tax_rate belongs to taxRate, lazy loading, cascaded
       not null product.tax_rate_id <==> taxRate.id
     product->unit belongs to unit, lazy loading, cascaded
       not null product.unit_id <==> unit.id

@roxblnfk
Copy link
Member

roxblnfk commented Aug 5, 2022

Yes I believe the outer key should be without the square brackets ie. id and not [id] so that when it is joined with the relation tax_rate it creates the complete key tax_rate_id but that is just my mind and I have not walked through the code yet.

There PhpFileSchemaProvider generator configured to read (like cache) and write schema. By the reason you can modify schema.php manually to test your assumptions.

Also you should turn on the FromConveyorSchemaProvider to generate new Schema based on attributes if Schema cache is clear.

'schema-providers' => [
            // Uncomment next line to enable a Schema caching in the common cache
            //\Yiisoft\Yii\Cycle\Schema\Provider\SimpleCacheSchemaProvider::class => ['key' => 'cycle-orm-cache-key'],

            // Store generated Schema in the file
            \Yiisoft\Yii\Cycle\Schema\Provider\PhpFileSchemaProvider::class => [
               'mode' => \Yiisoft\Yii\Cycle\Schema\Provider\PhpFileSchemaProvider::MODE_READ_AND_WRITE,
               'file' => 'runtime/schema.php',
            ],

            \Yiisoft\Yii\Cycle\Schema\Provider\FromConveyorSchemaProvider::class => [
                'generators' => [
            //         Cycle\Schema\Generator\SyncTables::class, // sync table changes to database
                ],
            ],
        ],

@roxblnfk
Copy link
Member

roxblnfk commented Aug 5, 2022

Ok, ran C:\wamp64\www\yii-invoice>yii cycle/schema and got the following.

Schema looks OK. We need to dump the Entity before changing and after it (before save).

@roxblnfk
Copy link
Member

roxblnfk commented Aug 5, 2022

service

public function saveProduct(Product $model, ProductForm $form): void
    {
        dump($model);  // <<< HERE

        $model->setProduct_sku($form->getProduct_sku());
        $model->setProduct_name($form->getProduct_name());
        $model->setProduct_description($form->getProduct_description());
        $model->setProduct_price($form->getProduct_price());
        $model->setPurchase_price($form->getPurchase_price());
        $model->setProvider_name($form->getProvider_name());
        $model->setProduct_tariff($form->getProduct_tariff()); 
        $model->setTax_rate_id((int)$form->getTax_rate_id());
        $model->setUnit_id((int)$form->getUnit_id());
        $model->setFamily_id((int)$form->getFamily_id());
               
        dump($model);  // <<< AND HERE

        $this->repository->save($model);
    }

@rossaddison
Copy link
Author

rossaddison commented Aug 5, 2022 •
edited
Loading

$dump_before

object(App\Invoice\Entity\Product Cycle ORM Proxy)#2611 (14) { 
["id":"App\Invoice\Entity\Product":private]=> int(3) 
["product_sku":"App\Invoice\Entity\Product":private]=> string(12) "dfghdfghdfgh" 
["product_name":"App\Invoice\Entity\Product":private]=> string(15) "Window Cleaning" 
["product_description":"App\Invoice\Entity\Product":private]=> string(7) "fasdfaf" 
["product_price":"App\Invoice\Entity\Product":private]=> float(15) 
["purchase_price":"App\Invoice\Entity\Product":private]=> float(7) 
["provider_name":"App\Invoice\Entity\Product":private]=> string(0) "" 

["family":"App\Invoice\Entity\Product":private]=> object(App\Invoice\Entity\Family Cycle ORM Proxy)#2614 (2) {    
["id"]=> int(1)                                                               //  1

["family_name"]=> string(7) "Product" } 

["family_id":"App\Invoice\Entity\Product":private]=> int(1)     // 2

["tax_rate":"App\Invoice\Entity\Product":private]=> object(App\Invoice\Entity\TaxRate Cycle ORM Proxy)#2622 (4) { 
["id":"App\Invoice\Entity\TaxRate":private]=> int(2)                // 3

["tax_rate_name":"App\Invoice\Entity\TaxRate":private]=> string(8) "Standard" 
["tax_rate_percent":"App\Invoice\Entity\TaxRate":private]=> float(20) 
["tax_rate_default":"App\Invoice\Entity\TaxRate":private]=> bool(true) } 

["tax_rate_id":"App\Invoice\Entity\Product":private]=> int(2)        // 4

["unit":"App\Invoice\Entity\Product":private]=> object(App\Invoice\Entity\Unit Cycle ORM Proxy)#2624 (3) { 
["id"]=> int(3) ["unit_name":"App\Invoice\Entity\Unit":private]=> string(10) "Third Unit"   //  5 

["unit_name_plrl":"App\Invoice\Entity\Unit":private]=> string(11) "Third units" } 

["unit_id":"App\Invoice\Entity\Product":private]=> int(3)                   // 6

["product_tariff":"App\Invoice\Entity\Product":private]=> int(2) }

$dump_after

object(App\Invoice\Entity\Product Cycle ORM Proxy)#2611 (14) {
["id":"App\Invoice\Entity\Product":private]=> int(3) 
["product_sku":"App\Invoice\Entity\Product":private]=> string(12) "dfghdfghdfgh" 
["product_name":"App\Invoice\Entity\Product":private]=> string(15) "Window Cleaning" 
["product_description":"App\Invoice\Entity\Product":private]=> string(7) "fasdfaf" 
["product_price":"App\Invoice\Entity\Product":private]=> float(15) 
["purchase_price":"App\Invoice\Entity\Product":private]=> float(7) 
["provider_name":"App\Invoice\Entity\Product":private]=> string(0) "" 
["family":"App\Invoice\Entity\Product":private]=> object(App\Invoice\Entity\Family Cycle ORM Proxy)#2614 (2) { 

["id"]=> int(1)                                                               // 7

["family_name"]=> string(7) "Product" } 

["family_id":"App\Invoice\Entity\Product":private]=> int(2)     // 8
 
["tax_rate":"App\Invoice\Entity\Product":private]=> object(App\Invoice\Entity\TaxRate Cycle ORM Proxy)#2622 (4) { 

["id":"App\Invoice\Entity\TaxRate":private]=> int(2)                // 9

["tax_rate_name":"App\Invoice\Entity\TaxRate":private]=> string(8) "Standard" 
["tax_rate_percent":"App\Invoice\Entity\TaxRate":private]=> float(20) 
["tax_rate_default":"App\Invoice\Entity\TaxRate":private]=> bool(true) } 

["tax_rate_id":"App\Invoice\Entity\Product":private]=> int(1)       // 10

["unit":"App\Invoice\Entity\Product":private]=> object(App\Invoice\Entity\Unit Cycle ORM Proxy)#2624 (3) { 

["id"]=> int(3) ["unit_name":"App\Invoice\Entity\Unit":private]=> string(10) "Third Unit"   // 11

["unit_name_plrl":"App\Invoice\Entity\Unit":private]=> string(11) "Third units" } 

["unit_id":"App\Invoice\Entity\Product":private]=> int(1)     // 12

["product_tariff":"App\Invoice\Entity\Product":private]=> int(2) }

@rossaddison
Copy link
Author

Using service:

 public function saveProduct(Product $model, ProductForm $form): string
    {
        $dump_before = var_dump($model);
        
        $model->setProduct_sku($form->getProduct_sku());
        $model->setProduct_name($form->getProduct_name());
        $model->setProduct_description($form->getProduct_description());
        $model->setProduct_price($form->getProduct_price());
        $model->setPurchase_price($form->getPurchase_price());
        $model->setProvider_name($form->getProvider_name());
        $model->setProduct_tariff($form->getProduct_tariff()); 
        $model->setTax_rate_id((int)$form->getTax_rate_id());
        $model->setUnit_id((int)$form->getUnit_id());
        $model->setFamily_id((int)$form->getFamily_id());  
        
        $dump_after = var_dump($model);
        
        $this->repository->save($model);
        
        return $dump_before.$dump_after;
    }

Controller:

 if ($form->load($body) && $validator->validate($form)->isValid()) {
                $dump = $this->productService->saveProduct($this->product($currentRoute, $pR), $form);  
                $this->flash('info', $dump);
                return $this->webService->getRedirectResponse('product/index');   
            }

@rossaddison
Copy link
Author

I only changed the relation keys ie.

dropdown for family changed from Product to Service, ie. family_id changed from 1 to 2.
dropdown for tax_rate changed from Standard to Zero, ie. tax_rate_id changed from 2 to 1.
dropdown for unit changed from unit/units to clean/cleans ie. unit_id changed from 3 to 1.

The id's for all of the above are being correctly changed by the form and service.

@roxblnfk
Copy link
Member

roxblnfk commented Aug 5, 2022 •
edited
Loading

The service changes related entities ids in the Product but previous entities already loaded.
Before save the Product entity has inconsistent state:

  • it has TaxRate parent with id=2 and tax_rate_id=1
  • Famaly with id=1 but family_id=2
  • Unit with id=3 but unit_id=1

Can you try to make it consistent before save?
I mean to unset related entities or set new related like

$product->tax_rate = $taxRate_with_id3;

@rossaddison
Copy link
Author

Please can you use the forward slashes like // with a number after it eg. // 8 that I have put in the $dump_before and $dump_after at the end of each line in your comment above to understand you correctly.

@roxblnfk
Copy link
Member

roxblnfk commented Aug 5, 2022

image

@rossaddison
Copy link
Author

Sorry for being pedantic / picky/ fussy but I think you have a typo in your comment:

it has TaxRate parent with id=1 and tax_rate_id=2

these should be <=> swopped.

@rossaddison
Copy link
Author

rossaddison commented Aug 5, 2022 •
edited
Loading

I included the following into the Service and Entitys to resolve this problem basically providing setRelation functions to balance the getRelation functions. It just means we can initialize these to null before the product is saved.

Service

 public function editProduct(Product $model, ProductForm $form): string
    {
        $dump_before = var_dump($model);
        
        
        $model->setProduct_sku($form->getProduct_sku());
        $model->setProduct_name($form->getProduct_name());
        $model->setProduct_description($form->getProduct_description());
        $model->setProduct_price($form->getProduct_price());
        $model->setPurchase_price($form->getPurchase_price());
        $model->setProvider_name($form->getProvider_name());
        $model->setProduct_tariff($form->getProduct_tariff());
        null!==$form->getTax_rate_id() ? $model->setTaxrate($model->getTaxrate()->getTax_rate_id() == $form->getTax_rate_id() ? $model->getTaxrate() : null): '';
        $model->setTax_rate_id((int)$form->getTax_rate_id());       
        null!==$form->getUnit_id() ? $model->setUnit($model->getUnit()->getUnit_id() == $form->getUnit_id() ? $model->getUnit() : null) : '';
        $model->setUnit_id((int)$form->getUnit_id());
        null!== $form->getFamily_id() ?$model->setFamily($model->getFamily()->getFamily_id() == $form->getFamily_id() ? $model->getFamily() : null) : '';
        $model->setFamily_id((int)$form->getFamily_id());
        
        $dump_after = var_dump($model);
        
        $this->repository->save($model);
        
        return $dump_before.$dump_after;
    }
    
    public function addProduct(Product $model, ProductForm $form): void
    {
        $model->setProduct_sku($form->getProduct_sku());
        $model->setProduct_name($form->getProduct_name());
        $model->setProduct_description($form->getProduct_description());
        $model->setProduct_price($form->getProduct_price());
        $model->setPurchase_price($form->getPurchase_price());
        $model->setProvider_name($form->getProvider_name());
        $model->setProduct_tariff($form->getProduct_tariff());        
        $model->setTax_rate_id((int)$form->getTax_rate_id());               
        $model->setUnit_id((int)$form->getUnit_id());
        $model->setFamily_id((int)$form->getFamily_id());
        $this->repository->save($model);
    }

Entity

  //get relation $family
    public function getFamily(): ?Family
    {
        return $this->family;
    }
    
    //set relation $family
    public function setFamily(?Family $family): void
    {
        $this->family = $family;
    }
    
    //relation $tax_rate
    public function getTaxrate(): ?TaxRate
    {
        return $this->tax_rate;
    }
    
    //set relation $taxrate
    public function setTaxrate(?TaxRate $taxrate): void
    {
        $this->tax_rate = $taxrate;
    }
    
    //relation $unit
    public function getUnit(): ?Unit
    {
        return $this->unit;
    }

    //set relation $unit
    public function setUnit(?Unit $unit): void
    {
        $this->unit = $unit;
    }

@rossaddison
Copy link
Author

rossaddison commented Aug 5, 2022 •
edited
Loading

Ok the relations are saving now but new items added are experiencing an error. This is not going to be a quick solution. I have decided to create two separate functions in the service. One for adding and one for editing. This has solved my problem.

I will leave this open for a while just in case. Nevertheless, thanks a million for your help roxblnfk. Thank you for your willingness and determination.

@rossaddison rossaddison reopened this Aug 5, 2022
@rossaddison
Copy link
Author

rossaddison commented Oct 13, 2022 •
edited
Loading

Further reading: Here

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@roxblnfk roxblnfk

Labels
status:to be verified Needs to be reproduced and validated. type:bug Bug
Projects
Cycle
Archived in project
Milestone
No milestone
Development

No branches or pull requests
4 participants
@butschster @roxblnfk @rossaddison @TiaNex-Com