/**
* Override default validation
* @see Phreezable::Validate()
*/
public function Validate()
{
// example of custom validation
// $this->ResetValidationErrors();
// $errors = $this->GetValidationErrors();
// if ($error == true) $this->AddValidationError('FieldName', 'Error Information');
// return !$this->HasValidationErrors();
return parent::Validate();
}
function tabelaPessoal($id)
{
$DAO = new ItemDAO();
$cargo = new Item();
$resultado = $DAO->Listar("SELECT A.id,\r\n\t\t\t\t\t\t\t\t\t A.id_medicao,\r\n\t\t\t\t\t\t\t\t\t A.id_pessoa,\r\n\t\t\t\t\t\t\t\t\t A.id_medicao_item,\r\n\t\t\t\t\t\t\t\t\t B.nome_completo,\r\n\t\t\t\t\t\t\t\t\t C.nome,\r\n\t\t\t\t\t\t\t\t\t A.dat_inicio,\r\n\t\t\t\t\t\t\t\t\t A.dat_fim,\r\n\t\t\t\t\t\t\t\t\t A.quantidade\r\n\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_MEDICAO_ITEM_PESSOA . " A\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_PESSOAS . " B ON A.id_pessoa = B.id\r\n\t\t\t\t\t\t\t\t\t\tINNER JOIN " . MYSQL_BASE_CONTRATO_ITEM . " C ON A.id_medicao_item = C.id\r\n\t\t\t\t\t\t\t\t\tWHERE C.tipo = 1 AND A.id_medicao =" . $id . " AND dat_excluido='0000-00-00 00:00:00'");
$confirm = "return confirm('Deseja remover esse registro?');";
$i = 0;
connectSQL();
foreach ($resultado as $item) {
$sql = mysql_query("SELECT id, nome\r\n\t\t\t\t\t\t\t\t\tFROM " . MYSQL_BASE_CONTRATO_ITEM);
echo '<input type="hidden" name="id[]" value="' . $item['id'] . '">';
echo '<tr>';
echo ' <td>' . $item['nome_completo'] . '</td>';
echo ' <td>
<select id="SelectError' . $i . '" data-rel="chosen" name="cargo[]">';
while ($row = mysql_fetch_array($sql)) {
if ($row['id'] == $item['id_medicao_item']) {
echo '<option selected value="' . $row['id'] . '">' . $row['nome'] . '</option>';
} else {
echo '<option value="' . $row['id'] . '">' . $row['nome'] . '</option>';
}
}
echo '</select>
</td>';
echo ' <td nowrap><input type="text" name="dat_inicio[]" size="5" class="input-small datepicker dat_inicio' . $item['id'] . '" value="' . dataBrasil($item['dat_inicio'], false) . '" onkeyup="up(this)" onBlur="calcula' . $item['id'] . '();" maxlength="10" onkeydown="Mascara(this,Data);" onkeypress="Mascara(this,Data);" onkeyup="Mascara(this,Data);"/> -
<input type="text" name="dat_fim[]" size="5" onchange="ReplaceDate()" class="input-small datepicker dat_fim' . $item['id'] . '" value="' . dataBrasil($item['dat_fim'], false) . '" onkeyup="up(this)" onBlur="calcula' . $item['id'] . '();" maxlength="10" onkeydown="Mascara(this,Data);" onkeypress="Mascara(this,Data);" onkeyup="Mascara(this,Data);"/></td>';
//<input type="text" class="input-small datepicker" id="date01" name="dat_inicio" value="'.dataBrasil($item['dat_fim'], false).'"></td>';
echo ' <td><center><input name="subtotal[]" type="text" class="effect valor' . $item['id'] . '" id="" value="' . $item['quantidade'] . '" size="15" maxlength="10" /></center></td>';
echo ' <td class="center">';
echo ' <a class="btn btn-danger" onclick="' . $confirm . '" href="rel_pessoal.php?id=' . $id . '&cmd=del&item=' . $item['id'] . '">';
echo ' <i class="icon-trash icon-white"></i> Deletar';
echo ' </a>';
echo ' </td>';
echo '</tr>';
echo "\r\n\t\t\t\t\t\t\t\t\t\t<script type=\"text/javascript\">\r\n\t\t\t\t\t\t\t\t\t\tfunction calcula" . $item['id'] . "(){\r\n\t\t\t\t\t\t\t\t\t\t \$('.dat_inicio" . $item['id'] . ", .dat_fim" . $item['id'] . "').each(function(i){\r\n\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tvar dat_ini = \$('.dat_inicio" . $item['id'] . "').val();\r\n\t\t\t\t\t\t\t\t\t\t\t\tvar dat_fim = \$('.dat_fim" . $item['id'] . "').val();\r\n\t\t\t\r\n\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tdat_ini = new Date(dat_ini.substr(6,4), dat_ini.substr(3,2)-1, dat_ini.substr(0,2));\r\n\t\t\t\t\t\t\t\t\t\t\t\tdat_fim = new Date(dat_fim.substr(6,4), dat_fim.substr(3,2)-1, dat_fim.substr(0,2));\r\n\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t valor = Math.ceil((dat_fim.getTime()-dat_ini.getTime())/1000/60/60/24);\r\n\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tif (valor > 0){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tvalor = valor + 1;\r\n\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tif (valor == 31 ){\r\n\t\t\t\t\t\t\t\t\t\t\t\t\tvalor = 30;\r\n\t\t\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\tvalor = valor/30\r\n\t\t\t\t\t\t\t\t\t\t\t\tvalor = valor.toFixed(3);\r\n\t\r\n\t\t\t\t\t\t\t\t\t\t\t})\r\n\t\r\n\t\t\t\t\t\t\t\t\t\t \$('.valor" . $item['id'] . "').val( valor ); //fora do loop\r\n\t\t\t\t\t\t\t\t\t\t}\r\n\t\t\t\t\t\t\t\t\t\t</script>\r\n\t\t\t\t\t\t\t\t\t\t";
$i++;
}
}
