<?php

class Sistema_Model_ContatosAdicionais extends Agro_Db_Table_Abstract
{
    protected $_name = 'contatos_adicionais';
    protected $_schema = 'sistema';
    protected $_primary = 'id';

    public function getData($where)
    {
        $select = $this->select();
        $select->setIntegrityCheck(false);
        $select->from(array('ca' => "{$this->_schema}.{$this->_name}"), '*');

        if (is_array($where)) {
            foreach ($where as $clause) {
                $field = $clause['field'];
                $operator = $clause['operator'];
                $value = $clause['value'];

                $select->where("$field $operator ?", $value);
            }
        } elseif ($where != '') {
            $select->where($where);
        }

        return $select;
    }

    public function save(array $data)
    {
        $row = $this->getRow($data['id']);

        $row->id_usuario = $data['id_usuario'];

        if (!empty($data['ds_nome'])) {
            $row->ds_nome = strtoupper($data['ds_nome']);
        }

        if (!empty($data['ds_email'])) {
            $row->ds_email = $data['ds_email'];
        }

        if (!empty($data['ds_telefone'])) {
            $row->ds_telefone = $data['ds_telefone'];
        }

        return $row->save();
    }
}