예제 #1
0
function displaySchedule()
{
    $dao = new DAO();
    $stmt = oci_parse($dao->con, "SELECT TO_CHAR(TIMESTART, 'MM-DD-YYYY HH24:MI') AS TS ,TO_CHAR(TIMEEND, 'MM-DD-YYYY HH24:MI') AS TE, ID, THEATREID, MOVIEID FROM SCREENROOM");
    OCIDefineByName($stmt, "TS", $timeS);
    OCIDefineByName($stmt, "TE", $timeE);
    OCIDefineByName($stmt, "ID", $scroomID);
    OCIDefineByName($stmt, "THEATREID", $tID);
    OCIDefineByName($stmt, "MOVIEID", $mID);
    oci_execute($stmt, OCI_DEFAULT);
    echo '<table border=1>';
    while (oci_fetch($stmt)) {
        echo '<tr>';
        // Use the uppercase column names for the associative array indices
        $bookLink = '<a href=order.php?sID=' . $scroomID . '>&nbsp book</a>';
        $detailLink = '<a href=movieDetail.php?mID=' . $mID . '>&nbsp detaile</a>';
        echo '<td> MOVIE: ' . $dao->fetchMovieName($mID) . '</td>' . ' <td>Start: ' . $timeS . ' </td><td>End: ' . $timeE . ' </td><td> theatre: ' . $dao->fetchTheatreName($tID) . '</td><td>' . $bookLink . ' </td><td>' . $detailLink . '</td>';
        echo '</tr>';
    }
    echo '</table>';
}
    echo 'Autorização para acessar esta Página é requerida.';
    exit;
} else {
    session_start();
    require_once "AW00DB.php";
    require_once "{$database}.class.php";
    require_once "AW00MD.php";
    require_once "liberacaoteclado.php";
    require_once "function_param.inc";
    require_once "limpa_sessoes.php";
    require_once "style.inc";
    $sql1 = "SELECT COUNT(*) RESULT\n               FROM FUNCIONARIO\n            WHERE\n               CDFUNCIONARIO=UPPER('{$PHP_AUTH_USER}')\n               AND\n               CDSENHA=CRIPT(UPPER('{$PHP_AUTH_PW}'),'')";
    $noun_cpl = parameter('NOUN_CPL');
    $nrunimed = parameter('NRUNIMED');
    $stmt1 = OCIParse($conn, $sql1);
    OCIDefineByName($stmt1, "RESULT", $RESULT);
    OCIExecute($stmt1);
    OCIFetch($stmt1);
    OCIResult($stmt1, 1);
    if ($RESULT == '1') {
        $sql2 = "SELECT G.CDNIVEL NIV\n                         FROM FUNCIONARIO F,\n                         GRUPO_FUNCIONARIO G\n                         WHERE F.CDFUNCIONARIO = UPPER('{$PHP_AUTH_USER}')\n                         AND F.CDGRUPO = G.CDGRUPO";
        $stmt2 = OCIParse($conn, $sql2);
        OCIdefineByName($stmt2, "niv", $niv);
        OCIexecute($stmt2);
        OCIFetch($stmt2);
        $nivel = OCIResult($stmt2, 1);
        $emissor = strtoupper($PHP_AUTH_USER);
        session_register('nivel');
        session_register('emissor');
        session_unregister('data1');
        session_unregister('data2');
예제 #3
0
 function fetchMovieDetail($mid)
 {
     $stmt = oci_parse($this->con, "select * from movie where id = {$mid} ");
     OCIDefineByName($stmt, "DIRECTOR", $DCT);
     OCIDefineByName($stmt, "STAR", $STAR);
     OCIDefineByName($stmt, "DESCRPITION", $DES);
     oci_execute($stmt, OCI_DEFAULT);
     while (oci_fetch($stmt)) {
         $str = 'DIRECTOR: &nbsp' . $DCT . '&nbsp type:' . $this->getMovieType($mid) . '&nbsp STAR:' . $STAR . '&nbsp.<br><br>DETAIL: <br><br>' . $DES;
         echo wordwrap($str, 150, "<br>\n", false);
     }
 }
예제 #4
0
}
print "\n\t\t       <STYLE type=text/css>A:hover {\n\t\t       COLOR: #000000; FONT-FAMILY: verdana, arial, sans-serif; font-size: 8pt; font-weight: bold; TEXT-DECORATION: none\n\t\t       }\n\t\t       A {\n\t\t       COLOR: #000000; FONT-FAMILY: verdana, arial, sans-serif; font-size: 8pt; TEXT-DECORATION: none\n\t\t       }\n\t\t       </STYLE>\n\n\t\t       <SCRIPT LANGUAGE=\"JavaScript\">\n\n\t\t\tfunction validate(){\n\n\t\t\tif (document.pesquisa.nome.value==\"\") {\n\t\t\talert(\"Você tem que digitar pelo menos as iniciais do usuário!\")\n\t\t\tdocument.pesquisa.nome.focus();\n\t\t\treturn false\n\t\t\t}\n\t\t\treturn true\n\t\t\t}\n\n\t\t\tfunction disableForm(theform) {\n\t\t\tfor (i = 0; i < theform.length; i++) {\n\t\t\tvar tempobj = theform.elements[i];\n\t\t\tif (tempobj.type.toLowerCase() == \"submit\" || tempobj.type.toLowerCase() == \"reset\")\n\n\t\t\ttempobj.disabled = true;\n\n\t\t\t}\n\t\t\t}\n\t\t      </script>";
print "\n<form method=\"POST\" action=\"pesqusu1.php\" name=\"pesquisa\" onSubmit=\"return validate(); return disableForm(this); window.document.pesquisa.nome.value='';\">\n<center>\n<img src=\"img/barra.jpg\" width=\"380\" height=\"2\"><br>\n<font class='nome_campo'><em><strong>Nome: </em></font>\n    <input type=\"text\" size=\"20\" name=\"nome\">\n    <input type=\"hidden\" name=\"submit\" value=\"Pesquisar\">\n    <input type=\"reset\" name=\"reset\" value=\"Limpar\" Onclick=\"window.document.pesquisa.nome.focus();\">\n    <input type=\"button\" name=\"fecha\" value=\"Fechar\" onclick=\"window.close(); return false;\"\"><br>\n<img src=\"img/barra.jpg\" width=\"380\" height=\"3\"></p>\n</center>\n</form>";
if ($nome != !1) {
    require_once "AW00DB.php";
    require_once "{$database}.class.php";
    require_once "AW00MD.php";
    if ($nivelacesso_funcionario != 'EMPRESA') {
        $sql = "SELECT\n\tus.cdareaacao ||'.'|| us.nrcontrato || '.'||lpad(us.nrfamilia,6,0) || '.'||us.tpusuario || '-'||us.nrdigitoct CODIGO,\n\tPE.NOPESSOA NOME,\n\tUS.DTEXCLUSAO\n\tFROM\n\tPESSOA PE,\n\tUSUARIO US,\n  USUARIO_IDENTIFICACAO UI\n\tWHERE\n\t PE.NOPESSOA LIKE UPPER('{$nome}%')\n  and UI.NRSEQUENCIAL_USUARIO = US.NRSEQUENCIAL_USUARIO\n  AND us.nrregistro_usuario = PE.NRREGISTRO\n  AND UI.NRDIGITOCT = US.NRDIGITOCT\n  AND UI.NRVIA_CARTAO = (SELECT MAX(NRVIA_CARTAO) NRVIA_CARTAO\n                               FROM USUARIO_IDENTIFICACAO\n                        WHERE CDUSUARIO = UI.CDUSUARIO )";
    } else {
        $sql = "SELECT\n\tus.cdareaacao ||'.'|| us.nrcontrato || '.'||lpad(us.nrfamilia,6,0) || '.'||us.tpusuario || '-'||us.nrdigitoct CODIGO,\n\tPE.NOPESSOA NOME,\n\tUS.DTEXCLUSAO\n\tFROM\n\tPESSOA PE,\n\tUSUARIO US,\n  USUARIO_IDENTIFICACAO UI,\n ( select nrregistro, nrcontrato from (\n   select pf.nrregistro, pf.nrcontrato\n        from PERMISSAO_FUNCIONARIO_CONTRATO PF\n       where PF.CDFUNCIONARIO = UPPER('{$PHP_AUTH_USER}')\n   union\n      select pg.nrregistro, pg.nrcontrato\n        from FUNCIONARIO F,\n             PERMISSAO_GRUPO_CONTRATO PG\n       where F.CDGRUPO = PG.CDGRUPO\n       and F.CDFUNCIONARIO = UPPER('{$PHP_AUTH_USER}') ) ) co\n\tWHERE\n\t UPPER(PE.NOPESSOA) LIKE UPPER('{$nome}%')\n  and co.nrregistro = us.nrregistro\n  and co.nrcontrato = us.nrcontrato\n  and UI.NRSEQUENCIAL_USUARIO = US.NRSEQUENCIAL_USUARIO\n  AND us.nrregistro_usuario = PE.NRREGISTRO\n  AND UI.NRDIGITOCT = US.NRDIGITOCT\n  AND UI.NRVIA_CARTAO = (SELECT MAX(NRVIA_CARTAO) NRVIA_CARTAO\n                               FROM USUARIO_IDENTIFICACAO\n                        WHERE CDUSUARIO = UI.CDUSUARIO)";
    }
    echo "{$sql} ";
    $cl = '';
    $stmt = OCIParse($conn, $sql);
    OCIDefineByName($stmt, "{$nome}", $nome);
    OCIExecute($stmt);
    $nrows = OCIFetchStatement($stmt, $results);
    if ($nrows > 0) {
        print "<div align=\"center\">\n\t<table border=\"0\">\n\t<tr>\n\t<td class='titulo'><p align=\"center\"><font\n\tclass='nome_campo'><strong>Código</strong></font></p>\n\t</td>\n\t<td class='titulo'><p align=\"center\"><font\n\tclass='nome_campo'><strong>Nome</strong></font></p>\n\t</td>\n\t<td class='titulo'><p align=\"center\"><font\n\tclass='nome_campo'><strong>Dt. Exclusão</strong></font></p>\n\t</td>\n\n\t</tr>";
        for ($i = 0; $i < $nrows; $i++) {
            reset($results);
            print "<TR>";
            while ($column = each($results)) {
                $data = $column['value'];
                $dat = $column['key'];
                if ($dat == "CODIGO") {
                    $cdcon = $data[$i];
                }
                print "<td {$cl}><a href=\"#\" target=\"guia\" onClick=\"window.opener.document.yourform.data1.value = '{$cdcon}'; window.opener.document.yourform.data1.focus(); window.close(); return false;\"><font color=\"#000000\" face=\"Arial\">{$data[$i]}</font></a></td>";
            }
예제 #5
0
 print "<option value=''>  </option>";
 while ($row = $db->fetch_array($result)) {
     print "<option value='{$row['CDMOTIVO_SAIDA']}'";
     if ($row[CDMOTIVO_SAIDA] == $cdtipo_saida) {
         print " selected ";
     }
     print ">{$row['CDMOTIVO_SAIDA']} - {$row['NOMOTIVO_SAIDA']}</option>";
 }
 print "\n           </select>";
 print "</td>\n              </tr>";
 if ($liberatecladousuario == 'S') {
     if ($liberamotivo == 'S') {
         $sql = "SELECT M.CDMOTIVO_AUTORIZ , M.TXMOTIVO_AUTORIZ FROM MOTIVO_AUTORIZACAO M WHERE AOUTILIZADO_TELA_AUTORIZACAO = 'S'";
         $stmt = OCIParse($conn, $sql);
         OCIDefineByName($stmt, "CDMOTIVO_AUTORIZ", $cdmotivo_autoriz);
         OCIDefineByName($stmt, "TXMOTIVO_AUTORIZ", $txmotivo_autoriz);
         OCIExecute($stmt);
         print "\n                <tr><td class=\"nome_campo\">\n                Motivo da Autorizaçao:</td>\n                <td>\n                   <select size=\"1\" name=\"motivo\" onFocus=\"nextfield ='rn'\">               ";
         while (OCIFetch($stmt)) {
             print "<option value='{$cdmotivo_autoriz}'> {$txmotivo_autoriz}</option>";
         }
         OCIFreeStatement($stmt);
         print "\n                 </select>";
     }
     print "</td>\n                    </tr>";
 }
 if ($liberaprestador == 'C') {
     echo "<input type=\"hidden\" size=\"4\" name=\"cdarea_prestador\" value='{$area_prestador}'>";
     /*
                                           if ( '$liberatecladousuario' == 'S' ){
                                   document.forms[0].data1.focus();