* junto com este programa; se nao, escreva para a Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
* 02111-1307, USA.
*
* Copia da licenca no diretorio licenca/licenca_en.txt
* licenca/licenca_pt.txt
*/
error_reporting('** FAVOR FAÇA SEU PEDIDO DE SENHA! **');
include "libs/db_conecta.php";
include "libs/db_stdlib.php";
include "libs/db_utils.php";
include "dbforms/db_funcoes.php";
include "libs/db_sql.php";
$oGet = db_utils::postmemory($_GET);
$sMatric = $oGet->nummatric;
$datanasc = formataDataNasc($oGet->z01_nasc);
$cpf = formataCpf($oGet->z01_cgccpf);
$conf = true;
if ($oGet->chave == 't') {
if (isset($oGet->sqms) && $oGet->sqms == 't') {
$sErroUsuario = "t";
// verifica numcgm
$sqlCgmUsuario = " select z01_nome,\n\t\t z01_numcgm \n\t\t from cgm \n\t\t where z01_cgccpf = '{$cpf}' ";
//die($sqlCgmUsuario);
$queryCgm = pg_query($sqlCgmUsuario);
$totalCgm = pg_num_rows($queryCgm);
if ($totalCgm > 0) {
db_fieldsmemory($queryCgm, 0);
}
//verifica se usuário já é cadastrado
$sqlUsuario = " select login \n from db_usuarios \n where nome = '{$z01_nome}' \n and login = '******' \n and usuext = '1' ";
$pdf->cell(30, 5, 'Nº do CGM:', 0, 0, "L", 1);
$pdf->cell(0, 5, $z01_numcgm, 0, 1, "L", 1);
$pdf->cell(30, 5, 'Nome:', 0, 0, "L", 0);
$pdf->cell(0, 5, $z01_nome, 0, 1, "L", 0);
$pdf->cell(30, 5, 'Matricula:', 0, 0, "L", 1);
$pdf->cell(0, 5, $rh01_regist, 0, 1, "L", 1);
$sCgCcPf = trim($z01_cgccpf);
if (strlen($sCgCcPf) <= 11) {
$sTipo = "cpf";
} else {
$sTipo = "cnpj";
}
$pdf->cell(30, 5, 'CPF:', 0, 0, "L", 0);
$pdf->cell(0, 5, formataCpf($sCgCcPf, $sTipo), 0, 1, "L", 0);
$pdf->cell(30, 5, 'Data Nascimento:', 0, 0, "L", 1);
$pdf->cell(0, 5, formataDataNasc($z01_nasc), 0, 1, "L", 1);
if ($sEmailServ == '') {
$pdf->cell(0, 5, '', 0, 1, "L", 0);
} else {
$pdf->cell(30, 5, 'E-mail Informado:', 0, 0, "L", 0);
$pdf->cell(0, 5, $sEmailServ, 0, 1, "L", 0);
}
$pdf->cell(0, 5, '', 0, 1, "L", 1);
$pdf->cell(30, 5, 'Login:', 0, 0, "L", 0);
$pdf->cell(0, 5, $z01_numcgm, 0, 1, "L", 0);
$pdf->Output();
//**************************************** FIM PDF Servidor Público ********************************************//
function formataDataNasc($sData)
{
$data = str_replace("-", "", $sData);
$datanasc_dia = substr($data, -2, 2);
