(document.atualiza.dt_mud_func.value == '') &&
(document.atualiza.dt_ret_trab.value == '') &&
(document.atualiza.dt_demiss.value == '') &&
(document.atualiza.dt_rel_perio.value == '') &&
(document.atualiza.dt_encaminhado.value == '')) {
alert("Antes de atualizar o cadastro do colaborador, certifique-se que ao menos uma das datas abaixo seja informada");
return false;
}
}
</script>
<body >
<hr>
<?php
$id = $_GET["id"];
include_once 'conecta/conecta.php';
$con = new conecta();
$con->inicia();
$sql = "select exa.semest_reali,exa.encaminhado,exa.periodicovenc,exa.observacao obs, exa.semevenc,exa.encaminhado,CONVERT(varchar(30), exa.dt_encaminhado, 103)dt_encaminhado,
datediff(day,getdate(),CONVERT(varchar(30), periodicovenc, 103) ) as dias_venc_peri,datediff(day,getdate(), CONVERT(varchar(30), semevenc, 103) ) as dias_venc_sems,fun.numcad matricula,fun.nomfun nome,fun.numcpf cpf,CONVERT(VARCHAR(10),fun.datadm,103)data_adminissao,sit.DesSit situacao,
car.TitCar cargo,orn.NomLoc local,fun.CodCcu centro_custo,exa.exrac1 possui_rac1,exa.exrac2 possui_rac2,exa.exrac3 possui_rac3,exa.exrac4 possui_rac4,exa.exrac5 possui_rac5,exa.exrac6 possui_rac6,exa.exrac7 possui_rac7,
exa.exrac8 possui_rac8,exa.exrac9 possui_rac9,exa.exrac10 possui_rac10,exa.exrac11 possui_rac11,CONVERT(VARCHAR(10),exa.adminreal,103) EXA_adimissional_realizado,CONVERT(VARCHAR(10),exa.periodicovenc,103)EXA_periodico_vencimento,
exa.possuisemes possui_exame_semestral,CONVERT(VARCHAR(10),exa.semevenc,103)EXA_semestral_vencimento,CONVERT(VARCHAR(10),exa.mudfuncreal,103)EXA_mudanca_funcao_realizado,CONVERT(VARCHAR(10),exa.demireal,103)EXA_demissional_realizado,
CONVERT(VARCHAR(10),exa.rettrab,103)EXA_retorno_trabalho,CONVERT(VARCHAR(10),exa.rettrab,103)EXA_retorno_trabalho from vetorh..r034fun fun inner join vetorh..r010sit sit on sit.codsit = fun.sitafa inner join vetorh..r018ccu cc on fun.codccu = cc.CodCcu
and cc.NumEmp = fun.numemp inner join vetorh..r024car car on fun.codcar = car.CodCar and car.EstCar = fun.estcar inner join vetorh..r016orn orn on orn.NumLoc = fun.numloc and orn.TabOrg = fun.taborg full join exames..EXAMES_COLABORADOR exa
on fun.numcad = exa.numcad
where fun.numemp =1
and fun.tipcol =1
and fun.sitafa <> 7
-- and fun.nomfun like '%gilberto%'
and fun.numcad = " . $id . "
order by fun.numcad";
<?php
session_start();
$email_secao = $_SESSION['email'];
include_once('../conecta/conecta.php');
$con = new conecta();
$con->inicia();
$verifi_usuario = "select * from EXAMES_ACESSO where permissao = 'administrador' and email ='$email_secao'";
$dat = $con->executa_sql($verifi_usuario);
$us = mssql_fetch_array($dat);
if((!isset ($_SESSION['email']) == true)) {
unset($_SESSION['email']);
header('location: ../index.php');
}
$logado = $_SESSION['login'];
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=latin-1">
<title></title>
<?php
include_once './conecta/conecta.php';
$con = new conecta();
$con->inicia();
$sql = "select \ndatediff(day,CONVERT(varchar(30), exa.semest_reali, 103), CONVERT(varchar(30), semevenc, 103) ) as dias_realizado_semestral,\nexa.dt_encaminhado dt_encaminhado,\nexa.encaminhado encaminhado,\nexa.perio_realizado perio_realizado,\nexa.semest_reali semest_realizado, \ndatediff(day,getdate(),CONVERT(varchar(30), afa.DatTer, 103)) as dias_venc_lic_maternidade,\ndatediff(day,getdate(),CONVERT(varchar(30), periodicovenc, 103) ) as dias_venc_peri,\ndatediff(day,getdate(), CONVERT(varchar(30), semevenc, 103) ) as dias_venc_sems,\ndatediff(day,getdate(), CONVERT(varchar(30), rettrab, 103) ) as dias_venc_rettrab,\nfun.nomfun nome,\nfun.numcad matricula,\nCONVERT(VARCHAR(10),periodicovenc,103) dt_vencimento_periodico,\nCONVERT(VARCHAR(10),afa.DatTer,103) dt_retorno_maternidade,\nCONVERT(VARCHAR(10),semevenc,103) dt_venc_semestral,\nCONVERT(VARCHAR(10),rettrab,103) dt_retorno_tranalho,\nsit.DesSit situacao,\ncc.codccu centro_custo,\ncc.nomccu desc_centro_custo\nfrom\nvetorh..r034fun fun inner join vetorh..r010sit sit on sit.codsit = fun.sitafa \ninner join vetorh..r018ccu cc on fun.codccu = cc.CodCcu and cc.NumEmp = fun.numemp \ninner join vetorh..r024car car on fun.codcar = car.CodCar and car.EstCar = fun.estcar \ninner join vetorh..r016orn orn on orn.NumLoc = fun.numloc and orn.TabOrg = fun.taborg \nfull join exames..EXAMES_COLABORADOR exa on fun.numcad = exa.numcad \nfull join vetorh..r038afa afa on fun.numcad = afa.NumCad and afa.DatAfa = fun.datafa \nand afa.NumEmp = fun.numemp and afa.TipCol = fun.tipcol and afa.HorAfa = fun.horafa and afa.SitAfa = sit.CodSit\nwhere fun.numemp =1\nand fun.tipcol =1\nand fun.sitafa <> 7\nand fun.sitafa <> 3\nand exa.encaminhado <>1\norder by fun.numcad\n";
$sql_ret = "select \nexa.dt_encaminhado dt_encaminhado,\nexa.encaminhado encaminhado,\nexa.perio_realizado perio_realizado,\nexa.semest_reali semest_realizado, \ndatediff(day,getdate(),CONVERT(varchar(30), afa.DatTer, 103)) as dias_venc_lic_maternidade,\ndatediff(day,getdate(),CONVERT(varchar(30), periodicovenc, 103) ) as dias_venc_peri,\ndatediff(day,getdate(), CONVERT(varchar(30), semevenc, 103) ) as dias_venc_sems,\ndatediff(day,getdate(), CONVERT(varchar(30), rettrab, 103) ) as dias_venc_rettrab,\ndatediff(day,getdate(), CONVERT(varchar(30), afa.prvter, 103) ) as dias_retorno_trab,\nfun.nomfun nome,\nfun.numcad matricula,\nCONVERT(VARCHAR(10),periodicovenc,103) dt_vencimento_periodico,\nCONVERT(VARCHAR(10),afa.DatTer,103) dt_retorno_maternidade,\nCONVERT(VARCHAR(10),semevenc,103) dt_venc_semestral,\nCONVERT(VARCHAR(10),rettrab,103) dt_retorno_tranalho,\nsit.DesSit situacao,\ncc.codccu centro_custo,\ncc.nomccu desc_centro_custo\nfrom\nvetorh..r034fun fun inner join vetorh..r010sit sit on sit.codsit = fun.sitafa \ninner join vetorh..r018ccu cc on fun.codccu = cc.CodCcu and cc.NumEmp = fun.numemp \ninner join vetorh..r024car car on fun.codcar = car.CodCar and car.EstCar = fun.estcar \ninner join vetorh..r016orn orn on orn.NumLoc = fun.numloc and orn.TabOrg = fun.taborg \nfull join exames..EXAMES_COLABORADOR exa on fun.numcad = exa.numcad \nfull join vetorh..r038afa afa on fun.numcad = afa.NumCad and afa.DatAfa = fun.datafa \nand afa.NumEmp = fun.numemp and afa.TipCol = fun.tipcol and afa.HorAfa = fun.horafa and afa.SitAfa = sit.CodSit\nwhere fun.numemp =1\nand fun.tipcol =1\nand fun.sitafa <> 7\nand exa.encaminhado <>1\n\norder by fun.numcad\n";
$sql_mate = "select \nexa.dt_encaminhado dt_encaminhado,\nexa.encaminhado encaminhado,\nexa.perio_realizado perio_realizado,\nexa.semest_reali semest_realizado, \ndatediff(day,getdate(),CONVERT(varchar(30), afa.DatTer, 103)) as dias_venc_lic_maternidade,\ndatediff(day,getdate(),CONVERT(varchar(30), periodicovenc, 103) ) as dias_venc_peri,\ndatediff(day,getdate(), CONVERT(varchar(30), semevenc, 103) ) as dias_venc_sems,\ndatediff(day,getdate(), CONVERT(varchar(30), rettrab, 103) ) as dias_venc_rettrab,\nfun.nomfun nome,\nfun.numcad matricula,\nCONVERT(VARCHAR(10),periodicovenc,103) dt_vencimento_periodico,\nCONVERT(VARCHAR(10),afa.DatTer,103) dt_retorno_maternidade,\nCONVERT(VARCHAR(10),semevenc,103) dt_venc_semestral,\nCONVERT(VARCHAR(10),rettrab,103) dt_retorno_tranalho,\nsit.DesSit situacao,\ncc.codccu centro_custo,\ncc.nomccu desc_centro_custo\nfrom\nvetorh..r034fun fun inner join vetorh..r010sit sit on sit.codsit = fun.sitafa \ninner join vetorh..r018ccu cc on fun.codccu = cc.CodCcu and cc.NumEmp = fun.numemp \ninner join vetorh..r024car car on fun.codcar = car.CodCar and car.EstCar = fun.estcar \ninner join vetorh..r016orn orn on orn.NumLoc = fun.numloc and orn.TabOrg = fun.taborg \nfull join exames..EXAMES_COLABORADOR exa on fun.numcad = exa.numcad \nfull join vetorh..r038afa afa on fun.numcad = afa.NumCad and afa.DatAfa = fun.datafa \nand afa.NumEmp = fun.numemp and afa.TipCol = fun.tipcol and afa.HorAfa = fun.horafa and afa.SitAfa = sit.CodSit\nwhere fun.numemp =1\nand fun.tipcol =1\nand fun.sitafa = 6\nand exa.encaminhado <>1\n\norder by fun.numcad";
$mensagem = '
<html>
<head>
<title></title>
<link rel="stylesheet" href="CSS/envia.css"/>
<style type="text/css">
th { font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px; color:#FFFFFF; font-weight:bold; background-color:#333366; padding-left:10px; text-align: center; }
td { font-family:Verdana, Arial, Helvetica, sans-serif; font-size:10px; padding-left:10px; text-align: center; }
.meio{background-color:#ffffff; height:30px;}
@charset "latin-1";
</style>
<style>img {display:block}</style>
<body>
<table>';
$ret = $con->executa_sql($sql_ret);
$mat = $con->executa_sql($sql_mate);
$res = $con->executa_sql($sql);
$mensagem = $mensagem . '<tr><th colspan="7" class="meio"></th></tr><tr><th colspan="7">Colaboradores Vencimento de Exame Periodico próximo</th></tr><tr><th>Matrícula</th><th>Nome</th><th>Data Vencimento</th><th>Dias até o Vencimento</th><th>Situação</th><th>Centro de Custo</th><th>Projeto</th></tr>';
while ($row = mssql_fetch_array($res)) {
if ($row['dias_venc_peri'] <= 45 and $row['dias_venc_peri'] > 0 && (empty($row['dt_encaminhado']) || empty($row['perio_realizado']))) {
} else {
$up = $up . "update EXAMES_COLABORADOR set exrac9 = {$rac9} WHERE numcad = {$matricula}";
}
if (empty($rac10)) {
$rac10 = 0;
} else {
$up = $up . "update EXAMES_COLABORADOR set exrac10 = {$rac10} WHERE numcad = {$matricula}";
}
if (empty($rac11)) {
$rac11 = 0;
} else {
$up = $up . "update EXAMES_COLABORADOR set exrac11 = {$rac11} WHERE numcad = {$matricula}";
}
}
include_once 'conecta/conecta.php';
$con = new conecta();
$con->inicia();
$sql = "select * from EXAMES_COLABORADOR where numcad = {$matricula}";
$res = $con->executa_sql($sql);
if (mssql_num_rows($res)) {
$con->executa_sql($up);
} else {
$sql = "insert into EXAMES_COLABORADOR VALUES ({$tp_pessoa},{$matricula},1,null,{$rac1},{$rac2},{$rac3},{$rac4},{$rac5},{$rac6},{$rac7},{$rac8},{$rac9},{$rac10},{$rac11},'{$dt_admissao}','{$nova_data_exame_periodico}',{$opcao},'{$nova_data_exame_semestral}','{$dt_mud_func}','{$dt_demiss}','{$dt_ret_trab}',' ',' ', ' ', ' ','{$observacao}')";
$con->executa_sql($sql);
$con->executa_sql("update EXAMES_COLABORADOR set adminreal = null where adminreal = '01/01/1900 00:00:00'");
}
if ($dt_rel_perio != "") {
$sql3 = "update EXAMES_COLABORADOR set semest_reali ='{$dt_rel_perio}' where numcad = {$matricula}";
$con->executa_sql($sql3);
}
if ($op_encam == 1) {
<td><input type="text" name="email" /></td>
<td><select name="dominio" >
<option value="lyonengenharia" >@lyonengenharia.com.br</option>
<option value="lyonfacilities" >@lyonfacilities.com.br</option>
<option value="admgeral" >@admgeral.com.br</option>
</select></td>
</tr>
<tr>
<td> Permissões de acesso: </td>
<td><select name="permissao" >
<option value="administrador">Administrador</option>
<option value="visualizar">Visualizar</option>
</select></td>
</tr>
</table>
<input type="submit" value="Cadastrar" />
</form>
</body>
</html>
<?php
include_once "/exames/conecta/conecta.php";
$nome = $_POST['nome'];
$email = $_POST['email'];
$permissao = $_POST['permissao'];
$dominio = $_POST['dominio'];
$email = $email . "@" . $dominio . ".com.br";
$conta = trim($email);
$con = new conecta();
$con->inicia();
$sql = "insert into EXAMES_ACESSO VALUES ('{$nome}' ,'{$conta}','{$permissao}')";
$con->executa_sql($sql);
}
if (empty($rac7)) {
$rac7 = 0;
}
if (empty($rac8)) {
$rac8 = 0;
}
if (empty($rac9)) {
$rac9 = 0;
}
if (empty($rac10)) {
$rac10 = 0;
}
if (empty($rac11)) {
$rac11 = 0;
}
include_once './conecta/conecta.php';
$con = new conecta();
$con->inicia();
$sql = "update EXAMES_COLABORADOR set adminreal= '{$dt_admissao}', periodicovenc ='{$dt_periodico}', semest_reali ='{$dt_semestral}', mudfuncreal ='{$dt_mud_func}', rettrab ='{$dt_ret_trab}', demireal ='{$dt_demiss}', encaminhado ='{$dt_encam}', \n exrac1 ={$rac1},exrac2 ={$rac2},exrac3 ={$rac3},exrac4 ={$rac4},exrac5 ={$rac5},exrac6 ={$rac6},exrac7 ={$rac7},exrac8 ={$rac8},exrac9 ={$rac9},exrac10 ={$rac10},exrac11 ={$rac11} where numcad= {$matricula}";
$con->executa_sql($sql);
if (!empty($up)) {
$con->executa_sql($up);
echo $up;
}
$limpa = "\nupdate EXAMES_COLABORADOR set adminreal = null where adminreal = '01/01/1900 00:00:00'\nupdate EXAMES_COLABORADOR set periodicovenc = null where periodicovenc = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set semevenc = null where semevenc = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set mudfuncreal = null where mudfuncreal = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set demireal = null where demireal = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set rettrab = null where rettrab = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set dt_encaminhado = null where dt_encaminhado = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set semest_reali = null where semest_reali = '01/01/1900 00:00:00' \nupdate EXAMES_COLABORADOR set perio_realizado = null where perio_realizado = '01/01/1900 00:00:00'\n";
$con->executa_sql($limpa);
if (!empty($observacao)) {
$con->executa_sql("update EXAMES_COLABORADOR set observacao = '{$observacao}' where numcad = {$matricula}");
}
$con->fecha();
