|
CONTADOR;
}
if ($hrini == '')
$hrini = '00:00';
if ($hrfim == '')
$hrfim = '00:00';
if ($hriini == '')
$hriini = '00:00';
if ($hrifim == '')
$hrifim = '00:00';
if ($base == '')
$base = '0';
if ($fixo == '')
$fixo = '0';
if ($transp == '')
$transp = '0';
if ($status == '')
$status = '1';
$dtanasc = FormatDate($dtanasc);
$dtademi = FormatDate($dtademi);
$dtaadm = FormatDate($dtaadm);
$insalubp = str_replace(".","",$insalubp);
$insalubp = str_replace(",",".",$insalubp);
$quebrap = str_replace(".","",$quebrap);
$quebrap = str_replace(",",".",$quebrap);
$base = str_replace(".","",$base);
$base = str_replace(",",".",$base);
$fixo = str_replace(".","",$fixo);
$fixo = str_replace(",",".",$fixo);
$transp = str_replace(".","",$transp);
$transp = str_replace(",",".",$transp);
$stmt ="INSERT INTO COLABORADOR
(
CLBR_ID,
CLBR_EMP_ID,
CLBR_DESCRICAO,
CLBR_ENDERECO,
CLBR_BAIRRO,
CLBR_CEP,
CLBR_CIDADE,
CLBR_FONE, ";
if ($estciv != '' )
$stmt = $stmt . "CLBR_EST_CIVIL, ";
$stmt = $stmt .
"
CLBR_SEXO, ";
if ($grau != '' )
$stmt = $stmt . "CLBR_GRAU, ";
if ($dtanasc != '//' )
$stmt = $stmt . " CLBR_DTA_NASC, ";
$stmt = $stmt .
"
CLBR_PAI,
CLBR_MAE,
CLBR_CPF,
CLBR_RG,
CLBR_TITULO,
CLBR_CART_MOT, ";
if ($raca != '' )
$stmt = $stmt . "CLBR_RACA, ";
$stmt = $stmt .
"
CLBR_DEFIC, ";
if ($defict != '' )
$stmt = $stmt . " CLBR_DEFIC_TIPO, ";
$stmt = $stmt .
"
CLBR_SITUACAO,";
if ($dtaadm != '//' )
$stmt = $stmt . " CLBR_DTA_ADMISSAO, ";
if ($cargo != '' )
$stmt = $stmt . " CLBR_CARGO, ";
$stmt = $stmt .
"
CLBR_CBO,
CLBR_INSALUB, ";
if ($insalubp != '' )
$stmt = $stmt . "CLBR_INSALUB_PERC, ";
$stmt = $stmt .
"
CLBR_QUEBRA, ";
if ($quebrap != '' )
$stmt = $stmt . "CLBR_QUEBRA_PERC, ";
$stmt = $stmt .
"
CLBR_NUM_PIS,";
if ($dtademi != '//' )
$stmt = $stmt . " CLBR_DTA_DEMISSAO, ";
$stmt = $stmt .
"
CLBR_TIPO_DEMISSAO,
CLBR_HORA_INI,
CLBR_HORA_FIM,
CLBR_HORA_INT_INI,
CLBR_HORA_INT_FIM, ";
if ($turno != '' )
$stmt = $stmt . " CLBR_TURNO, ";
$stmt = $stmt .
"
CLBR_STATUS, ";
if ($registrado != '' )
$stmt = $stmt . " CLBR_REGISTRADO, ";
$stmt = $stmt .
"
CLBR_VLR_BASE,
CLBR_VLR_FIXO,
CLBR_VLR_TRANSP
)
VALUES
($codigo,
$empc,
UPPER('$desc'),
UPPER('$end'),
UPPER('$bairro'),
'$cep',
UPPER('$cidade'),
'$fone', ";
if ($estciv != '' )
$stmt = $stmt . " $estciv, ";
$stmt = $stmt .
"
'$sexo', ";
if ($grau != '' )
$stmt = $stmt . " $grau, ";
if ($dtanasc != '//' )
$stmt = $stmt . " '$dtanasc', ";
$stmt = $stmt .
"UPPER('$pai'),
UPPER('$mae'),
'$cpf',
'$rg',
'$titulo',
'$cnh', ";
if ($raca != '' )
$stmt = $stmt . "$raca, ";
$stmt = $stmt .
"
'$defic', ";
if ($defict != '' )
$stmt = $stmt . " $defict, ";
$stmt = $stmt .
"
'$situacao', ";
if ($dtaadm != '//' )
$stmt = $stmt . " '$dtaadm', ";
if ($cargo != '' )
$stmt = $stmt . " $cargo, ";
$stmt = $stmt .
"
'$cbo',
'$insalub', ";
if ($insalubp != '' )
$stmt = $stmt . "$insalubp, ";
$stmt = $stmt .
"
'$quebra', ";
if ($quebrap != '' )
$stmt = $stmt . "$quebrap, ";
$stmt = $stmt .
"
'$pis',";
if ($dtademi != '//' )
$stmt = $stmt . " '$dtademi', ";
$stmt = $stmt .
"'$tipodemis',
'$hrini',
'$hrfim',
'$hriini',
'$hrifim', ";
if ($turno != '' )
$stmt = $stmt . " $turno, ";
$stmt = $stmt .
"$status,";
if ($registrado != '' )
$stmt = $stmt . " '$registrado', ";
$stmt = $stmt .
"$base,
$fixo,
$transp
) ";
//echo $stmt;
$sth = ibase_query($dbh, $stmt);
echo "
|
|
|
|
|
|
|
|
|
|
";
echo "
 |
|
|
