Bi-Dir

QJ_napiADOSZAMossz.inc

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[nyomtat])) {
Line #3:?>
Line #4:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #5:<?PHP
Line #6:} else {
Line #7:
Line #8:include("../_inc_QJ/QJ_adoSELECT.inc");
Line #9:
Line #10:}
Line #11:
Line #12:////
Line #13:$login=$_SESSION['login'];
Line #14:if (!isset($_GET[napi])) {
Line #15:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #16:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #17:if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #18:}
Line #19:
Line #20:////
Line #21:
Line #22:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #23:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #24:
Line #25:
Line #26:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #27:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #28:
Line #29:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #30:$login=$_SESSION[L_bizomanyos];
Line #31:
Line #32:$wer2=" and bizomanyos='".$login."'";
Line #33:
Line #34:$nocheck="F";
Line #35:
Line #36:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #37:; $wer2=""; }
Line #38:
Line #39:
Line #40:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #41:
Line #42:$szin="";
Line #43:$i=0;
Line #44:$ft=0;
Line #45:$nap="?";
Line #46:$ri=0;
Line #47:$rft=0;
Line #48:$rmuv="?";
Line #49:
Line #50:$wi=0;
Line #51:$wft=0;
Line #52:$rlog="?";
Line #53:$hiba="";
Line #54:
Line #55://$parancs="SELECT * FROM qj_jegy where left(statusz,1)<>' ' and left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer1 $wer2 ORDER BY logtime DESC";
Line #56:
Line #57://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #58:
Line #59:if (isset($_GET[musor_kod])) {
Line #60:
Line #61:
Line #62:
Line #63:$keres = "SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #64:
Line #65:
Line #66:$musor=mysql_fetch_array($meredmeny);
Line #67:$L_NAP=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim]." ".$musor[datum];
Line #68:
Line #69:if (isset($_GET[bh])) {
Line #70:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #71:} else {
Line #72:$bh="";
Line #73:}
Line #74:
Line #75:
Line #76:$L_PHP="QJ_napiADOSZAMossz.php";
Line #77:
Line #78:} else {
Line #79:
Line #80:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 ORDER BY logtime DESC";
Line #81:
Line #82://?
Line #83://echo ($parancs."<hr>");
Line #84:
Line #85:
Line #86:
Line #87:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #88:$Pnap=substr($kegy_sor[logtime],0,10);
Line #89:$rmuv=$kegy_sor[statusz];
Line #90:
Line #91:$nap=substr($kegy_sor[logtime],0,10);
Line #92:$wer1=" and left(logtime,10)='".$nap."'";
Line #93:
Line #94:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #95: $_SESSION[L_nap]=$nap;
Line #96: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #97:}
Line #98:
Line #99:
Line #100:
Line #101:$_SESSION[Pnap]=$Pnap;
Line #102:$L_NAP=$_SESSION[L_nap];
Line #103:$L_user=$_SESSION[L_bizomanyos];
Line #104:
Line #105:
Line #106:
Line #107:$L_PHP="QJ_napiKONYVEL.php?&napi=Y";
Line #108:}
Line #109:
Line #110:
Line #111:include("QJ_listafej.php");
Line #112:
Line #113:echo "<table border=0>
Line #114:<tr bgcolor=silver>
Line #115:
Line #116:
Line #117:
Line #118:
Line #119:
Line #120:
Line #121:
Line #122:</tr>";
Line #123:
Line #124:$jegySEL="";
Line #125:IF (isset($_SESSION[RendezoSZ]) and $_SESSION[RendezoSZ]=="*")
Line #126:$jegySEL= " and left(logtime,10)='".$_POST[kezdIDO]."' ";
Line #127:
Line #128:$jegySEL= str_replace(".","-",$jegySEL);
Line #129:
Line #130:
Line #131:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $jegySEL $_SESSION[Datum_Ado] ORDER BY datum_kod,ar,statusz,ar_nev";
Line #132:
Line #133://?//
Line #134:echo ($parancs."<hr>");
Line #135:
Line #136:
Line #137:
Line #138:$i=0;
Line #139:$szin='#E0FFFF';
Line #140:$bh="";
Line #141:
Line #142:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #143:{
Line #144:
Line #145:if ($i==0) {
Line #146: $rdatum=$egy_sor[datum_kod];
Line #147: $nap=substr($egy_sor[logtime],0,10);
Line #148: $rar=$egy_sor[ar];
Line #149: $rar_nev=trim($egy_sor[ar_nev]);
Line #150: $rmuv=$egy_sor[statusz];
Line #151: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #152:}
Line #153:
Line #154:$ref="";
Line #155:if ($rdatum<>$egy_sor[datum_kod] or
Line #156: $rar<>$egy_sor[ar] or
Line #157: $rar_nev<>trim($egy_sor[ar_nev]) or
Line #158: $rmuv<>$egy_sor[statusz]){
Line #159:
Line #160:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #161:
Line #162:
Line #163:$musor = mysql_fetch_array( $eredmeny3 );
Line #164:
Line #165:$h=$musor[helyszin];
Line #166:$c=$egy_sor[cim];
Line #167:$d=$egy_sor[datum];
Line #168:$wjid=$egy_sor[wid];
Line #169:
Line #170:$FormaJel=$egy_sor[FormaJel];
Line #171:$JeBe=$egy_sor[JeBe];
Line #172:
Line #173:
Line #174:
Line #175:
Line #176:echo"<tr bgcolor=gold>
Line #177:
Line #178:<td align=right bgcolor=$szin > $rdatum </td>
Line #179:<td align=right bgcolor=$szin >$musor[cim]  $musor[datum] $musor[helyszin]</td>
Line #180:<td align=right bgcolor=$szin > $rar_nev</td>
Line #181:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #182:<td bgcolor=$szin >$rmuv</td>
Line #183:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #184:<td bgcolor=$szin > Ft</td>
Line #185:<td bgcolor=$szin > $ri</td>
Line #186:<td align=left bgcolor=$szin > Db</td>
Line #187:</tr>";
Line #188:
Line #189:$ri=0;
Line #190:$rft=0;
Line #191:
Line #192:
Line #193:}
Line #194:
Line #195: $rdatum=$egy_sor[datum_kod];
Line #196: $nap=substr($egy_sor[logtime],0,10);
Line #197: $rar=$egy_sor[ar];
Line #198: $rar_nev=trim($egy_sor[ar_nev]);
Line #199: $rmuv=$egy_sor[statusz];
Line #200: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #201:
Line #202:
Line #203:++$i;
Line #204:++$ri;
Line #205:$rft=$rft+$egy_sor[ar];
Line #206:$ft =$ft+$egy_sor[ar];
Line #207:++$wi;
Line #208:$wft=$wft+$egy_sor[ar];
Line #209:
Line #210:
Line #211:/*
Line #212:$dk=$egy_sor[datum_kod];
Line #213:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #214:
Line #215:
Line #216:$musor = mysql_fetch_array( $eredmeny3 );
Line #217:
Line #218:$h=$musor[helyszin];
Line #219:$c=$egy_sor[cim];
Line #220:$d=$egy_sor[datum];
Line #221:$wjid=$egy_sor[wid];
Line #222:
Line #223:$FormaJel=$egy_sor[FormaJel];
Line #224:$JeBe=$egy_sor[JeBe];
Line #225:
Line #226:echo"<tr>
Line #227:
Line #228:<td align=right >
Line #229: $i.
Line #230:</td>
Line #231:
Line #232:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #233:<td align=right >$musor[JeBe] $egy_sor[ar_nev]</td>
Line #234:<td align=right >".number_format($egy_sor[ar])."</td>
Line #235:<td >$egy_sor[statusz]</td>
Line #236:<td >$egy_sor[bizonylatszam]$ref</td>
Line #237:<td >".substr($egy_sor[logtime],-8)."</td>
Line #238:</tr>";
Line #239:*/
Line #240:
Line #241:/*
Line #242:$szin="";
Line #243://<td >".substr($egy_sor[logtime],-8)."</td>
Line #244://<td >".$egy_sor[logtime].$egy_sor[bizomanyos]."</td>
Line #245://<td >".$egy_sor[logtime].$egy_sor[bizomanyos].$ft."</td>
Line #246://}
Line #247:*/
Line #248:
Line #249:}
Line #250:
Line #251:
Line #252:if ($ft>0) {
Line #253:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #254:
Line #255:
Line #256:$musor = mysql_fetch_array( $eredmeny3 );
Line #257:
Line #258:$h=$musor[helyszin];
Line #259:$c=$egy_sor[cim];
Line #260:$d=$egy_sor[datum];
Line #261:$wjid=$egy_sor[wid];
Line #262:
Line #263:$FormaJel=$egy_sor[FormaJel];
Line #264:$JeBe=$egy_sor[JeBe];
Line #265:
Line #266:
Line #267://$rar_nev="?...?".substr($rar_nev,0,strlen($rar_nev)-6)."-..-";
Line #268:
Line #269:
Line #270:
Line #271:echo"<tr bgcolor=gold>
Line #272:
Line #273:<td align=right bgcolor=$szin > $rdatum </td>
Line #274:<td align=right bgcolor=$szin >$musor[cim]  $musor[datum] $musor[helyszin]</td>
Line #275:<td align=right bgcolor=$szin > $rar_nev</td>
Line #276:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #277:<td bgcolor=$szin >$rmuv</td>
Line #278:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #279:<td bgcolor=$szin > Ft</td>
Line #280:<td bgcolor=$szin > $ri</td>
Line #281:<td align=left bgcolor=$szin > Db</td>
Line #282:</tr>";
Line #283:}
Line #284:
Line #285:$szin="silver";
Line #286:
Line #287:echo"<tr>
Line #288:
Line #289:</td>
Line #290:<td colspan=2 align=right bgcolor=$szin>"
Line #291:.number_format($ft)."</td>
Line #292:<td bgcolor=$szin> Ft</td>
Line #293:<td align=right bgcolor=$szin>$i </td>
Line #294:<td align=left bgcolor=$szin> Db</td>
Line #295:</tr>";
Line #296:
Line #297:echo"</table>";
Line #298:
Line #299:
Line #300://include("QJ_varlist.php");
Line #301:
Line #302:if (isset($_GET[nyomtat])) {
Line #303:include("QJ_listaveg.php");
Line #304:
Line #305:echo("<body onload='printit()'></body>");
Line #306:
Line #307:?>
Line #308:<SCRIPT Language="Javascript">
Line #309:
Line #310:function printit(){
Line #311:
Line #312:
Line #313:window.print();
Line #314:///////////////////////////////////////
Line #315://window.open("QJ_felad.php", 'sframe');
Line #316:///////////////////////////////////////
Line #317://window.open("QJ_gyujto.php", 'sframe');
Line #318:
Line #319:}
Line #320:</script>
Line #321:<?PHP
Line #322:}
Line #323:
Line #324://~*~// QJ_napi.php
Line #325:?>
Line #326:
Line #327: