<?php
namespace App\Command;

use Cake\Console\Arguments;
use Cake\Console\Command;
use Cake\Console\ConsoleIo;
use Cake\Console\ConsoleOptionParser;


class CreditnoteCommand extends Command
{

    public function initialize()
    {
        parent::initialize();
        $this->loadModel('CreditNotes');
    }

    public function execute(Arguments $args, ConsoleIo $io)
    {


        $creditnotes = $this
                        ->CreditNotes
                            ->find()
                            ->select(['id','pacient_id','tax_entity_id','invoice_id','Invoices.invoice_number','date_transaction'])
                            ->contain(['Invoices']);

            //PARA IMPRIMIR POR CONSOLA
            foreach ( $creditnotes as $creditnote){

                $io->out(print_r($creditnote, true));
            }

    }
}