<?php
use_helper('Javascript', 'Form')
?>
<div id="tituloTool">
  <?php include_partial('tituloHistorico') ?>
</div>
<div class="padding">

<p>Selecione o funcionário para visualizar/editar o histórico.</p>
<?php echo form_remote_tag(array(
    'update'   => 'dados',
    'url'      => 'cadastro/visualizar',
    'loading'  => "Element.show('ajaxLoader')",
    'complete' => "Element.hide('ajaxLoader')"
  ),
  array('name'=>'frmHistorico')
) ?>
  <table>
    <tr>
      <th><?php echo $form['funcionario']->renderLabel() ?></th>
      <td <?php if ($form['funcionario']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $form['funcionario']->renderError() ?>
        <?php echo $form['funcionario']->render(array('style'=>'width: 660px')) ?>
      </td>
      <td><?php echo submit_image_tag('btnIr.png', array('alt'=>'Selecionar','title'=>'Selecionar')) ?></td>
    </tr>
  </table>
</form>

<div id="ajaxLoader" style="display:none"><?php echo image_tag('ajax-loader-bar.gif', array('alt'=>'Carregando...'))?></div>

<div id="dados">
</div>

</div>

<?php
use_helper('Form', 'Javascript', 'Date')
?>
<div class="padding" style="border-top: #999999 solid 2px; margin: 4px">

<?php if (isset($erros) && count($erros) > 0): ?>
<div id="erroMsg">
  <ul>
    <?php foreach($erros as $erro): ?>
    <li><?php echo $erro ?></li>
    <?php endforeach; ?>
  </ul>
</div>
<?php endif; ?>

<?php echo form_remote_tag(array(
    'update'   => 'dados',
    'url'      => 'cadastro/atualizar',
    'loading'  => "Element.show('ajaxLoader')",
    'complete' => "Element.hide('ajaxLoader')"
  ),
  array('class'=>'withBorder')
) ?>
  <h2>Dados do Funcionário</h2>
  <?php echo $formFuncionario['pkfuncionario']->render() ?>
  <table width="100%">
    <tr class="row1">
      <th class="rightAlign"><?php echo $formFuncionario['nome']->renderLabel() ?></th>
      <td colspan="5" <?php if ($formFuncionario['nome']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formFuncionario['nome']->renderError() ?>
        <?php echo $formFuncionario['nome']->render(array('class'=>'textField', 'size'=>110)) ?>
      </td>
    </tr>
    <tr class="row0">
      <th class="rightAlign"><?php echo $formFuncionario['dtnasc']->renderLabel() ?></th>
      <td>
        <?php echo $formFuncionario['dtnasc']->renderError() ?>
        <?php echo $formFuncionario['dtnasc'] ?>
      </td>
      <th class="rightAlign"><?php echo $formFuncionario['sexo']->renderLabel() ?></th>
      <td colspan="3">
        <?php echo $formFuncionario['sexo']->renderError() ?>
        <?php echo $formFuncionario['sexo'] ?>
      </td>
    </tr>
    <tr class="row1">
      <th class="rightAlign"><?php echo $formFuncionario['rg']->renderLabel() ?></th>
      <td <?php if ($formFuncionario['rg']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formFuncionario['rg']->renderError() ?>
        <?php echo $formFuncionario['rg']->render(array('class'=>'textField')) ?>
      </td>
      <th class="rightAlign"><?php echo $formFuncionario['cpf']->renderLabel() ?></th>
      <td <?php if ($formFuncionario['cpf']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formFuncionario['cpf']->renderError() ?>
        <?php echo $formFuncionario['cpf']->render(array('class'=>'textField')) ?>
      </td>
      <th class="rightAlign"><?php echo $formFuncionario['ativo']->renderLabel() ?></th>
      <td <?php if ($formFuncionario['ativo']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formFuncionario['ativo']->renderError() ?>
        <?php echo $formFuncionario['ativo'] ?>
      </td>
    </tr>
  </table>

  <p class="formActions">
    <?php echo submit_image_tag('btnSalvar.png', array('alt'=>'Salvar', 'title'=>'Salvar')) ?>
    <?php echo link_to(image_tag('btnCancelar.png', array('alt'=>'Cancelar', 'size'=>'98x22')), 'cadastro/historico', array('title'=>'Cancelar')) ?>
  </p>
  <h2>Histórico</h2>
  <table class="dataGrid" width="99%">
    <thead class="header">
      <tr>
        <th>Seção/Unidade</th>
        <th>Setor</th>
        <th>Cargo</th>
        <th>Data Início</th>
        <th>Data Fim</th>
        <th></th>
      </tr>
    </thead>
    <tbody>
      <?php if ($historico->RecordCount() > 0): ?>
      <?php $i = 1; $historico->MoveFirst(); while ($cargo = $historico->FetchNextObject()): $class = ($i % 2) ? 'row1' : 'row0'; ?>
      <tr class="<?php echo $class ?>">
        <td><?php echo $cargo->SEC_NOME ?></td>
        <td><?php echo $cargo->SET_DESCRICAO ?></td>
        <td><?php echo $cargo->CAR_DESCRICAO ?></td>
        <td><?php echo format_date($cargo->HIFU_DT_INICIO) ?></td>
        <td><?php echo format_date($cargo->HIFU_DT_FIM) ?></td>
        <td>
        <?php
        echo ($i + 1 > $historico->RecordCount()) ? link_to_function(
          image_tag('iconeEditar', array('size'=>'15x16')),
          'selectHistorico(' . $cargo->FK_SECAO . ',' . $cargo->FK_SETOR . ',' . $cargo->FK_CARGO . ',"' . $cargo->HIFU_DT_INICIO . '", "' . $cargo->HIFU_DT_FIM . '")',
          array('title'=>'Editar', 'alt'=>'Editar')
        ) : '&nbsp;' ?>
        </td>
      </tr>
      <?php $i++; endwhile; ?>
      <?php endif; ?>
    </tbody>
  </table>
  <p class="formActions" id="adicionarCargo">
    <?php echo link_to_function(image_tag('btnAdicionar', array('alt'=>'Adicionar', 'size'=>'90x22')), "adicionarCargo()", array('title'=>'Adicionar')) ?>
  </p>
</form>

<!-- O PROBLEMA ACONTECE AO EXIBIR ESSE FORM -->

<?php echo form_remote_tag(array(
    'update'   => 'dados',
    'url'      => 'cadastro/salvarHistorico',
    'loading'  => "Element.show('ajaxLoader')",
    'complete' => "Element.hide('ajaxLoader')"
  ),
  array('class'=>'withBorder', 'id'=>'cargoForm',  'style'=>'display: none')
) ?>
  <table width="100%" style="display:block">
    <tr class="row0">
      <th class="rightAlign"><?php echo $formHistorico['secao']->renderLabel() ?></th>
      <td <?php if ($formHistorico['secao']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formHistorico['secao']->renderError() ?>
        <?php echo $formHistorico['secao']->render(array('style'=>'display: block;width: 200px')) ?>
      </td>
      <th class="rightAlign"><?php echo $formHistorico['setor']->renderLabel() ?></th>
      <td <?php if ($formHistorico['setor']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formHistorico['setor']->renderError() ?>
        <?php echo $formHistorico['setor']->render(array('style'=>'display: block;width: 200px')) ?>
      </td>
      <th class="rightAlign"><?php echo $formHistorico['cargo']->renderLabel() ?></th>
      <td <?php if ($formHistorico['cargo']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formHistorico['cargo']->renderError() ?>
        <?php echo $formHistorico['cargo']->render(array('style'=>'width: 200px')) ?>
      </td>
        
    </tr>
    <tr class="row1">
      <th class="rightAlign"><?php echo $formHistorico['dtinicio']->renderLabel() ?></th>
      <td <?php if ($formHistorico['dtinicio']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formHistorico['dtinicio']->renderError() ?>
        <?php echo $formHistorico['dtinicio'] ?>
      </td>
      <th class="rightAlign"><?php echo $formHistorico['dtfim']->renderLabel() ?></th>
      <td colspan="3" <?php if ($formHistorico['dtfim']->hasError()): ?>class="marca_erro"<?php endif; ?>>
        <?php echo $formHistorico['dtfim']->renderError() ?>
        <?php echo $formHistorico['dtfim'] ?>
      </td>
    </tr>
  </table>
  
  <p class="formActions">
    <?php echo submit_image_tag('btnSalvar.png', array('alt'=>'Salvar', 'title'=>'Salvar')) ?>
    <?php echo link_to_function(image_tag('btnCancelar.png', array('alt'=>'Cancelar', 'size'=>'98x22')), "Element.hide('cargoForm'); Element.show('adicionarCargo')", array('title'=>'Cancelar')) ?>
  </p>
</form>

</div>

function selectHistorico(pksecao, pksetor, pkcargo, dtinicio, dtfim)
{
  $('historico_acao').value = 'update';
  $('historico_secao').value = pksecao;
  $('historico_setor').value = pksetor;
  $('historico_cargo').value = pkcargo;
  
  // processa data ISO
  var aDtInicio = dtinicio.toString().split(" "); // array: [0] => YYYY-MM-DD, [1] => hh:mm:ss
  var aDtFim = dtfim.toString().split(" ");       // array: [0] => YYYY-MM-DD, [1] => hh:mm:ss
  aDtInicio = aDtInicio[0].split("-");            // array: [0] => YYYY, [1] => MM, [2] => DD
  aDtFim = aDtFim[0].split("-");                  // array: [0] => YYYY, [1] => MM, [2] => DD
  
  $('historico_dtinicio_day').value = Number(aDtInicio[2]);
  $('historico_dtinicio_month').value = Number(aDtInicio[1]);
  $('historico_dtinicio_year').value = Number(aDtInicio[0]);
  $('historico_dtfim_day').value = Number(aDtFim[2]);
  $('historico_dtfim_month').value = Number(aDtFim[1]);
  $('historico_dtfim_year').value = Number(aDtFim[0]);
  
  Element.hide('adicionarCargo');
  Element.show('cargoForm');
}

function adicionarCargo()
{
  $('historico_acao').value = 'insert';

  $('historico_secao').value = null;
  $('historico_setor').value = null;
  $('historico_cargo').value = null;
  
  $('historico_dtinicio_day').value = '';
  $('historico_dtinicio_month').value = '';
  $('historico_dtinicio_year').value = '';
  $('historico_dtfim_day').value = '';
  $('historico_dtfim_month').value = '';
  $('historico_dtfim_year').value = '';
  
  Element.hide('adicionarCargo'); 
  Element.show('cargoForm');
}

public function __toString()
{
  return $this->getNome_Atributo_que_ira_aparecer_no_lugar_do_id();
}

$c->add(AgendaAtividadePeer::ID, NULL, Criteria::ISNOTNULL);
$c->addJoin(AgendaAtividadePeer::ID, AgendaAtividadeContatoPeer::AGENDA_ATIVIDADE_ID, Criteria::LEFT_JOIN);
$c->add(AgendaAtividadePeer::OWNER_ID, $this->getUser()->getAttribute('id'));
$c1 = $c->getNewCriterion(AgendaAtividadeContatoPeer::CONTATO_ID, $this->getUser()->getAttribute('contato_id')); 
$c->addOr($c1);

propel:
  askeet_user:
    _attribute:   { phpName: User }
    id:
    nickname:     varchar(50)
    first_name:   varchar(100)
    last_name:    varchar(100)
    created_at:

  askeet_question: 
    _attributes:  { phpName: Question }
    id:
    user_id:
    title:        longvarchar
    body:         longvarchar
    created_at:
    updated_at:

  askeet_answer:
    _attribute:   { phpName: Answer }
    id:
    question_id:
    user_id:
    body:         longvarchar
    created_at:

  askeet_interest:
    _attribute:   { phpName: Interest }
    question_id:
    user_id:
    created_at:

  askeet_relevancy:
    _attributes:  { phpName: Relevancy }
    answer_id:
    user_id:
    score:        integer
    created_at: