adianti-master/detail

<?php
/**
 * MovimentoForm Master/Detail
 * @author  <your name here>
 */
class MovimentoForm extends TPage
{
    protected $form; // form
    protected $formFields;
    protected $detail_list;

    /**
     * Page constructor
     */
    public function __construct()
    {
        parent::__construct();

        // creates the form
        $this->form = new TForm('form_Movimento');
        $this->form->class = 'tform'; // CSS class
        $this->form->style = 'max-width:700px'; // style
        parent::include_css('app/resources/custom-frame.css');

        $table_master = new TTable;
        $table_master->width = '100%';

        $table_master->addRowSet( new TLabel('Movimento'), '', '')->class = 'tformtitle';

        // add a table inside form
        $table_general = new TTable;
        $table_detail  = new TTable;
        $table_general-> width = '100%';
        $table_detail-> width  = '100%';

        $frame_general = new TFrame;
        $frame_general->setLegend('Movimento');
        $frame_general->style = 'background:whiteSmoke';
        $frame_general->add($table_general);

        $table_master->addRow()->addCell( $frame_general )->colspan=2;
        $row = $table_master->addRow();
        $row->addCell( $table_detail );

        $this->form->add($table_master);

        // master fields
        $id = new TEntry('id');
        $dt_movimento = new TDate('dt_movimento');
        $dt_processamento = new TDate('dt_processamento');
        $dt_saida = new TDate('dt_saida');
        $nro_pedido = new TEntry('nro_pedido');
        $nro_nota = new TEntry('nro_nota');
        $val_itens = new TEntry('val_itens');
        $val_desc_cortesia = new TEntry('val_desc_cortesia');
        $val_movimento = new TEntry('val_movimento');
        $pessoa_id = new TEntry('pessoa_id');
        $producao_id = new TEntry('producao_id');

        if (!empty($id))
        {
            $id->setEditable(FALSE);
        }

        // detail fields
        $detail_id = new THidden('detail_id');
        $detail_produto_id = new TEntry('detail_produto_id');
        $detail_unidade = new TEntry('detail_unidade');
        $detail_val_unitario = new TEntry('detail_val_unitario');
        $detail_quantidade = new TEntry('detail_quantidade');
        $detail_val_total = new TEntry('detail_val_total');

        /** samples
         $this->form->addQuickFields('Date', array($date1, new TLabel('to'), $date2)); // side by side fields
         $fieldX->addValidation( 'Field X', new TRequiredValidator ); // add validation
         $fieldX->setSize( 100, 40 ); // set size
         **/

        // master
        $table_general->addRowSet( new TLabel('Id'), $id );
        $table_general->addRowSet( new TLabel('Dt Movimento'), $dt_movimento );
        $table_general->addRowSet( new TLabel('Dt Processamento'), $dt_processamento );
        $table_general->addRowSet( new TLabel('Dt Saida'), $dt_saida );
        $table_general->addRowSet( new TLabel('Nro Pedido'), $nro_pedido );
        $table_general->addRowSet( new TLabel('Nro Nota'), $nro_nota );
        $table_general->addRowSet( new TLabel('Val Itens'), $val_itens );
        $table_general->addRowSet( new TLabel('Val Desc Cortesia'), $val_desc_cortesia );
        $table_general->addRowSet( new TLabel('Val Movimento'), $val_movimento );
        $table_general->addRowSet( new TLabel('Pessoa Id'), $pessoa_id );
        $table_general->addRowSet( new TLabel('Producao Id'), $producao_id );

         // detail
        $frame_details = new TFrame();
        $frame_details->setLegend('Item');
        $row = $table_detail->addRow();
        $row->addCell($frame_details);

        $btn_save_detail = new TButton('btn_save_detail');
        $btn_save_detail->setAction(new TAction(array($this, 'onSaveDetail')), 'Register');
        $btn_save_detail->setImage('fa:save');

        $table_details = new TTable;
        $frame_details->add($table_details);

        $table_details->addRowSet( '', $detail_id );
        $table_details->addRowSet( new TLabel('Produto Id'), $detail_produto_id );
        $table_details->addRowSet( new TLabel('Unidade'), $detail_unidade );
        $table_details->addRowSet( new TLabel('Val Unitario'), $detail_val_unitario );
        $table_details->addRowSet( new TLabel('Quantidade'), $detail_quantidade );
        $table_details->addRowSet( new TLabel('Val Total'), $detail_val_total );

        $table_details->addRowSet( $btn_save_detail );

        $this->detail_list = new TQuickGrid;
        $this->detail_list->setHeight( 175 );
        $this->detail_list->makeScrollable();
        $this->detail_list->disableDefaultClick();
        $this->detail_list->addQuickColumn('', 'edit', 'left', 50);
        $this->detail_list->addQuickColumn('', 'delete', 'left', 50);

        // items
        $this->detail_list->addQuickColumn('Produto Id', 'produto_id', 'left', 100);
        $this->detail_list->addQuickColumn('Unidade', 'unidade', 'left', 200);
        $this->detail_list->addQuickColumn('Val Unitario', 'val_unitario', 'left', 200);
        $this->detail_list->addQuickColumn('Quantidade', 'quantidade', 'left', 200);
        $this->detail_list->addQuickColumn('Val Total', 'val_total', 'left', 200);
        $this->detail_list->createModel();

        $row = $table_detail->addRow();
        $row->addCell($this->detail_list);

        // create an action button (save)
        $save_button=new TButton('save');
        $save_button->setAction(new TAction(array($this, 'onSave')), _t('Save'));
        $save_button->setImage('ico_save.png');

        // create an new button (edit with no parameters)
        $new_button=new TButton('new');
        $new_button->setAction(new TAction(array($this, 'onClear')), _t('New'));
        $new_button->setImage('ico_new.png');

        // define form fields
        $this->formFields   = array($id,$dt_movimento,$dt_processamento,$dt_saida,$nro_pedido,$nro_nota,$val_itens,$val_desc_cortesia,$val_movimento,$pessoa_id,$producao_id,$detail_produto_id,$detail_unidade,$detail_val_unitario,$detail_quantidade,$detail_val_total);
        $this->formFields[] = $btn_save_detail;
        $this->formFields[] = $save_button;
        $this->formFields[] = $new_button;
        $this->formFields[] = $detail_id;
        $this->form->setFields( $this->formFields );

        $table_master->addRowSet( array($save_button, $new_button), '', '')->class = 'tformaction'; // CSS class

        // create the page container
        $container = new TVBox;
        $container->style = 'width: 90%';
        // $container->add(new TXMLBreadCrumb('menu.xml', __CLASS__));
        $container->add($this->form);
        parent::add($container);
    }


    /**
     * Clear form
     * @param $param URL parameters
     */
    public function onClear($param)
    {
        $this->form->clear();
        TSession::setValue(__CLASS__.'_items', array());
        $this->onReload( $param );
    }

    /**
     * Save an item from form to session list
     * @param $param URL parameters
     */
    public function onSaveDetail( $param )
    {
        try
        {
            TTransaction::open('dash');
            $data = $this->form->getData();

            /** validation sample
            if (! $data->fieldX)
                throw new Exception('The field fieldX is required');
            **/

            $items = TSession::getValue(__CLASS__.'_items');
            $key = empty($data->detail_id) ? 'X'.mt_rand(1000000000, 1999999999) : $data->detail_id;

            $items[ $key ] = array();
            $items[ $key ]['id'] = $key;
            $items[ $key ]['produto_id'] = $data->detail_produto_id;
            $items[ $key ]['unidade'] = $data->detail_unidade;
            $items[ $key ]['val_unitario'] = $data->detail_val_unitario;
            $items[ $key ]['quantidade'] = $data->detail_quantidade;
            $items[ $key ]['val_total'] = $data->detail_val_total;

            TSession::setValue(__CLASS__.'_items', $items);

            // clear detail form fields
            $data->detail_id = '';
            $data->detail_produto_id = '';
            $data->detail_unidade = '';
            $data->detail_val_unitario = '';
            $data->detail_quantidade = '';
            $data->detail_val_total = '';

            TTransaction::close();
            $this->form->setData($data);

            $this->onReload( $param ); // reload the items
        }
        catch (Exception $e)
        {
            $this->form->setData( $this->form->getData());
            new TMessage('error', $e->getMessage());
        }
    }

    /**
     * Load an item from session list to detail form
     * @param $param URL parameters
     */
    public function onEditDetail( $param )
    {
        $data = $this->form->getData();

        // read session items
        $items = TSession::getValue(__CLASS__.'_items');

        // get the session item
        $item = $items[ $param['item_key'] ];

        $data->detail_id = $item['id'];
        $data->detail_produto_id = $item['produto_id'];
        $data->detail_unidade = $item['unidade'];
        $data->detail_val_unitario = $item['val_unitario'];
        $data->detail_quantidade = $item['quantidade'];
        $data->detail_val_total = $item['val_total'];

        // fill detail fields
        $this->form->setData( $data );

        $this->onReload( $param );
    }

    /**
     * Delete an item from session list
     * @param $param URL parameters
     */
    public function onDeleteDetail( $param )
    {
        $data = $this->form->getData();

        // reset items
            $data->detail_produto_id = '';
            $data->detail_unidade = '';
            $data->detail_val_unitario = '';
            $data->detail_quantidade = '';
            $data->detail_val_total = '';

        // clear form data
        $this->form->setData( $data );

        // read session items
        $items = TSession::getValue(__CLASS__.'_items');

        // delete the item from session
        unset($items[ $param['item_key'] ] );
        TSession::setValue(__CLASS__.'_items', $items);

        // reload items
        $this->onReload( $param );
    }

    /**
     * Load the items list from session
     * @param $param URL parameters
     */
    public function onReload($param)
    {
        // read session items
        $items = TSession::getValue(__CLASS__.'_items');

        $this->detail_list->clear(); // clear detail list
        $data = $this->form->getData();

        if ($items)
        {
            $cont = 1;
            foreach ($items as $list_item_key => $list_item)
            {
                $item_name = 'prod_' . $cont++;
                $item = new StdClass;

                // create action buttons
                $action_del = new TAction(array($this, 'onDeleteDetail'));
                $action_del->setParameter('item_key', $list_item_key);

                $action_edi = new TAction(array($this, 'onEditDetail'));
                $action_edi->setParameter('item_key', $list_item_key);

                $button_del = new TButton('delete_detail'.$cont);
                $button_del->class = 'btn btn-default btn-sm';
                $button_del->setAction( $action_del, '' );
                $button_del->setImage('fa:trash-o red fa-lg');

                $button_edi = new TButton('edit_detail'.$cont);
                $button_edi->class = 'btn btn-default btn-sm';
                $button_edi->setAction( $action_edi, '' );
                $button_edi->setImage('fa:edit blue fa-lg');

                $item->edit   = $button_edi;
                $item->delete = $button_del;

                $this->formFields[ $item_name.'_edit' ] = $item->edit;
                $this->formFields[ $item_name.'_delete' ] = $item->delete;

                // items
                $item->id = $list_item['id'];
                $item->produto_id = $list_item['produto_id'];
                $item->unidade = $list_item['unidade'];
                $item->val_unitario = $list_item['val_unitario'];
                $item->quantidade = $list_item['quantidade'];
                $item->val_total = $list_item['val_total'];

                $row = $this->detail_list->addItem( $item );
                $row->onmouseover='';
                $row->onmouseout='';
            }

            $this->form->setFields( $this->formFields );
        }

        $this->loaded = TRUE;
    }

    /**
     * Load Master/Detail data from database to form/session
     */
    public function onEdit($param)
    {
        try
        {
            TTransaction::open('dash');

            if (isset($param['key']))
            {
                $key = $param['key'];

                $object = new Movimento($key);
                $items  = Item::where('movimento_id', '=', $key)->load();

                $session_items = array();
                foreach( $items as $item )
                {
                    $item_key = $item->id;
                    $session_items[$item_key] = $item->toArray();
                    $session_items[$item_key]['id'] = $item->id;
                    $session_items[$item_key]['produto_id'] = $item->produto_id;
                    $session_items[$item_key]['unidade'] = $item->unidade;
                    $session_items[$item_key]['val_unitario'] = $item->val_unitario;
                    $session_items[$item_key]['quantidade'] = $item->quantidade;
                    $session_items[$item_key]['val_total'] = $item->val_total;
                }
                TSession::setValue(__CLASS__.'_items', $session_items);

                $this->form->setData($object); // fill the form with the active record data
                $this->onReload( $param ); // reload items list
                TTransaction::close(); // close transaction
            }
            else
            {
                $this->form->clear();
                TSession::setValue(__CLASS__.'_items', null);
                $this->onReload( $param );
            }
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage());
            TTransaction::rollback();
        }
    }

    /**
     * Save the Master/Detail data from form/session to database
     */
    public function onSave()
    {
        try
        {
            // open a transaction with database
            TTransaction::open('dash');

            $data = $this->form->getData();
            $master = new Movimento;
            $master->fromArray( (array) $data);
            $this->form->validate(); // form validation

            $master->store(); // save master object
            // delete details
            $old_items = Item::where('movimento_id', '=', $master->id)->load();

            $keep_items = array();

            // get session items
            $items = TSession::getValue(__CLASS__.'_items');

            if( $items )
            {
                foreach( $items as $item )
                {
                    if (substr($item['id'],0,1) == 'X' ) // new record
                    {
                        $detail = new Item;
                    }
                    else
                    {
                        $detail = Item::find($item['id']);
                    }
                    $detail->produto_id  = $item['produto_id'];
                    $detail->unidade  = $item['unidade'];
                    $detail->val_unitario  = $item['val_unitario'];
                    $detail->quantidade  = $item['quantidade'];
                    $detail->val_total  = $item['val_total'];
                    $detail->movimento_id = $master->id;
                    $detail->store();

                    $keep_items[] = $detail->id;
                }
            }

            if ($old_items)
            {
                foreach ($old_items as $old_item)
                {
                    if (!in_array( $old_item->id, $keep_items))
                    {
                        $old_item->delete();
                    }
                }
            }
            TTransaction::close(); // close the transaction

            // reload form and session items
            $this->onEdit(array('key'=>$master->id));

            new TMessage('info', TAdiantiCoreTranslator::translate('Record saved'));
        }
        catch (Exception $e) // in case of exception
        {
            new TMessage('error', $e->getMessage());
            $this->form->setData( $this->form->getData() ); // keep form data
            TTransaction::rollback();
        }
    }

    /**
     * Show the page
     */
    public function show()
    {
        // check if the datagrid is already loaded
        if (!$this->loaded AND (!isset($_GET['method']) OR $_GET['method'] !== 'onReload') )
        {
            $this->onReload( func_get_arg(0) );
        }
        parent::show();
    }
}