function Gerar()
{
$this->titulo = "holerites";
$this->addBanner("imagens/nvp_top_intranet.jpg", "imagens/nvp_vert_intranet.jpg", "Intranet");
$this->addCabecalhos(array("Início período folha", "Final período folha"));
session_start();
/*
* VERIFICA PERMISSÃO DO USUÁRIO
*/
if ($_SESSION['autorizado_holerite'] !== true) {
header("Location: pmidrh_holerite_habilita.php");
}
/*
* VER NUMERO DA EMPRESA DO FUNCIONÁRIO E SALVAR NA SEÇÂO.
*/
if (!isset($_SESSION['numemp_user'])) {
$dbms = new clsBancoMS();
$numEmp = $dbms->UnicoCampo("SELECT numEmp FROM r034fun WHERE numcad='{$_SESSION['matricula_user']}'");
$_SESSION['numemp_user'] = $numEmp;
}
/*
* MOSTRA LISTAGEM DOS OLERITE DISPONÍVEIS DO USUÁRIO
*/
$dbms = new clsBancoMS();
$dbms->Consulta("\n\t\t\tSELECT\n\t\t\t\tcount(0)\n\t\t\tFROM\n\t\t\t\tr044cal e\n\t\t\tWHERE\n\t\t\t e.numemp = '{$_SESSION['numemp_user']}' and\n\t\t\t e.codcal in (\n\t\t\t \tSELECT\n\t\t\t \t\tdistinct(codcal)\n\t\t\t \tFROM\n\t\t\t \t\tr046ver\n\t\t\t \tWHERE\n\t\t\t \t\tnumcad='{$_SESSION['matricula_user']}'\n\t\t\t \t\t )\n\t\t\t \t\t and\n\t\t\t STR(DAY(e.iniCmp)) = 31\n\t\t");
if ($dbms->ProximoRegistro()) {
$total_13 = $dbms->Tupla();
$total_13 = $total_13[0];
}
$dbms->Consulta("\n\t\t\tSELECT\n\t\t\t\te.codCal, STR(DAY(e.iniCmp)), STR(MONTH(e.iniCmp)), STR(YEAR(e.iniCmp)),\n\t\t\t\tSTR(DAY(e.fimCmp)), STR(MONTH(e.fimCmp)), STR(YEAR(e.fimCmp))\n\t\t\tFROM\n\t\t\t\tr044cal e\n\t\t\tWHERE\n\t\t\t e.numemp = '{$_SESSION['numemp_user']}' and\n\t\t\t e.codcal in (\n\t\t\t \tSELECT\n\t\t\t \t\tdistinct(codcal)\n\t\t\t \tFROM\n\t\t\t \t\tr046ver\n\t\t\t \tWHERE\n\t\t\t \t\tnumcad='{$_SESSION['matricula_user']}'\n\t\t\t \t\t )\n\t\t\tORDER BY\n\t\t\t\t\te.codCal\n\t\t\t\t\t\t\t");
$num_13 = 0;
$bool_13 = false;
while ($dbms->ProximoRegistro()) {
list($cod, $data_inicial_d, $data_inicial_m, $data_inicial_a, $data_final_d, $data_final_m, $data_final_a) = $dbms->Tupla();
$data_inicial = $this->coloca0($data_inicial_d) . "/" . $this->coloca0($data_inicial_m) . "/" . $this->coloca0($data_inicial_a);
$data_final = $this->coloca0($data_final_d) . "/" . $this->coloca0($data_final_m) . "/" . $this->coloca0($data_final_a);
$data_inicial_a = str_replace(" ", "", $data_inicial_a);
if ($data_inicial_a == 1900) {
$num_13++;
$bool_13 = true;
$data_inicial = "13º Salário";
$data_final = "";
}
$hoje = mktime(0, 0, 0, date("m"), date("d"), date("Y"));
$holerite_data = mktime(0, 0, 0, $data_final_m, 27, $data_final_a);
$holerite_data_13 = mktime(0, 0, 0, 11, 27, date("Y"));
//echo $hoje."////".$holerite_data."<br>";
//
if ($hoje - $holerite_data > 0 || $_SESSION['id_pessoa'] == 2151 || $_SESSION['id_pessoa'] == 725 || $_SESSION['id_pessoa'] == 4310) {
if (!$bool_13 || $bool_13 && ($num_13 < $total_13 || $hoje - $holerite_data_13 > 0) || $_SESSION['id_pessoa'] == 2151 || $_SESSION['id_pessoa'] == 725 || $_SESSION['id_pessoa'] == 4310) {
$this->addLinhas(array("<a href='pmidrh_holerite_det.php?cod_holerite={$cod}'>{$data_inicial}</a>", "<a href='pmidrh_holerite_det.php?cod_holerite={$cod}'>{$data_final}</a>"));
}
}
$bool_13 = false;
}
//$this->acao = "go(\"secretarias_cad.php\")";
//$this->nome_acao = "Novo";
$this->largura = "100%";
}
