/** * 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++; } }