QJ_evadKONYVEL.inc

---

Line #0:<?php
Line #1:
Line #2:
Line #3:if (isset($_GET[nyomtat])) {
Line #4:?>
Line #5:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #6:<?PHP
Line #7:} else {
Line #8:$selEV="jegy";
Line #9:include("../_inc_QJ/QQ_evSELECT.inc");
Line #10:
Line #11:}
Line #12:
Line #13:////
Line #14:$login=$_SESSION['login'];
Line #15:if (!isset($_GET[napi])) {
Line #16:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #17:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #18:if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #19:}
Line #20:
Line #21:////
Line #22:
Line #23:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #24:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #25:
Line #26:
Line #27:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #28:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #29:
Line #30:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #31:$login=$_SESSION[L_bizomanyos];
Line #32:
Line #33:$wer2=" and bizomanyos='".$login."'";
Line #34:
Line #35:$nocheck="F";
Line #36:
Line #37:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #38:; $wer2=""; }
Line #39:
Line #40:
Line #41:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #42:
Line #43:$szin="";
Line #44:$i=0;
Line #45:$ft=0;
Line #46:$nap="?";
Line #47:$ri=0;
Line #48:$rft=0;
Line #49:$rmuv="?";
Line #50:
Line #51:$wi=0;
Line #52:$wft=0;
Line #53:$rlog="?";
Line #54:$hiba="";
Line #55:
Line #56:
Line #57:$L_PHP="QJ_evadKONYVEL.php";
Line #58:
Line #59:include("QJ_listafej.php");
Line #60:
Line #61:echo "<table border=0>
Line #62:<tr bgcolor=silver>
Line #63:
Line #64:
Line #65:
Line #66:
Line #67:
Line #68:</tr>";
Line #69:
Line #70:
Line #71:
Line #72:if (isset($_SESSION[Rev]) and $_SESSION[Rev]<>"*") $wer=" and left(logtime,4)='$_SESSION[Rev]' "; else $wer="";
Line #73:
Line #74:
Line #75:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer ORDER BY ar_nev,ar,statusz";
Line #76:
Line #77://?//echo ($parancs."<hr>");
Line #78:
Line #79:
Line #80:
Line #81:$i=0;
Line #82:$szin='#E0FFFF';
Line #83:$bh="";
Line #84:
Line #85:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #86:{
Line #87:
Line #88:if ($i==0) {
Line #89: $rdatum=$egy_sor[datum_kod];
Line #90: $nap=substr($egy_sor[logtime],0,10);
Line #91: $rar=$egy_sor[ar];
Line #92: $rar_nev=trim($egy_sor[ar_nev]);
Line #93: $rmuv=$egy_sor[statusz];
Line #94: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #95:}
Line #96:
Line #97:$ref="";
Line #98://if ($rdatum<>$egy_sor[datum_kod] or
Line #99:// $rmuv<>$egy_sor[statusz]){
Line #100:
Line #101:if ( $rar<>$egy_sor[ar] or
Line #102: $rar_nev<>trim($egy_sor[ar_nev])){
Line #103:
Line #104:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #105:
Line #106:
Line #107:$musor = mysql_fetch_array( $eredmeny3 );
Line #108:
Line #109:$h=$musor[helyszin];
Line #110:$c=$egy_sor[cim];
Line #111:$d=$egy_sor[datum];
Line #112:$wjid=$egy_sor[wid];
Line #113:
Line #114:$FormaJel=$egy_sor[FormaJel];
Line #115:$JeBe=$egy_sor[JeBe];
Line #116:
Line #117:
Line #118:
Line #119:
Line #120://<td align=right bgcolor=$szin >$musor[cim]&nbsp;<BR>$musor[datum]<BR>$musor[helyszin]</td>
Line #121:
Line #122:echo"<tr bgcolor=gold>
Line #123:
Line #124:<td align=right bgcolor=$szin >&nbsp;$rar_nev</td>
Line #125:<td align=right bgcolor=$szin ><b>".number_format($rar)."</b></td>
Line #126:<td bgcolor=$szin >&nbsp;</td>
Line #127:<td align=right bgcolor=$szin ><b>".number_format($rft)."</b></td>
Line #128:<td bgcolor=$szin > Ft</td>
Line #129:<td bgcolor=$szin > $ri</td>
Line #130:<td align=left bgcolor=$szin ></b> Db</td>
Line #131:</tr>";
Line #132:
Line #133:$ri=0;
Line #134:$rft=0;
Line #135:
Line #136:
Line #137:}
Line #138:
Line #139: $rdatum=$egy_sor[datum_kod];
Line #140: $nap=substr($egy_sor[logtime],0,10);
Line #141: $rar=$egy_sor[ar];
Line #142: $rar_nev=trim($egy_sor[ar_nev]);
Line #143: $rmuv=$egy_sor[statusz];
Line #144: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #145:
Line #146:
Line #147:++$i;
Line #148:++$ri;
Line #149:$rft=$rft+$egy_sor[ar];
Line #150:$ft =$ft+$egy_sor[ar];
Line #151:++$wi;
Line #152:$wft=$wft+$egy_sor[ar];
Line #153:
Line #154:}
Line #155:
Line #156:
Line #157:if ($ft>0) {
Line #158:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #159:
Line #160:
Line #161:$musor = mysql_fetch_array( $eredmeny3 );
Line #162:
Line #163:$h=$musor[helyszin];
Line #164:$c=$egy_sor[cim];
Line #165:$d=$egy_sor[datum];
Line #166:$wjid=$egy_sor[wid];
Line #167:
Line #168:$FormaJel=$egy_sor[FormaJel];
Line #169:$JeBe=$egy_sor[JeBe];
Line #170:
Line #171:
Line #172://$rar_nev="?...?".substr($rar_nev,0,strlen($rar_nev)-6)."-..-";
Line #173:
Line #174:
Line #175:
Line #176://<td align=right bgcolor=$szin >$musor[cim]&nbsp;<BR>$musor[datum]<BR>$musor[helyszin]</td>
Line #177:
Line #178:echo"<tr bgcolor=gold>
Line #179:
Line #180:<td align=right bgcolor=$szin >&nbsp;$rar_nev</td>
Line #181:<td align=right bgcolor=$szin ><b>".number_format($rar)."</b></td>
Line #182:<td bgcolor=$szin >&nbsp;</td>
Line #183:<td align=right bgcolor=$szin ><b>".number_format($rft)."</b></td>
Line #184:<td bgcolor=$szin > Ft</td>
Line #185:<td bgcolor=$szin > $ri</td>
Line #186:<td align=left bgcolor=$szin ></b> Db</td>
Line #187:</tr>";
Line #188:}
Line #189:
Line #190:$szin="silver";
Line #191:
Line #192:echo"<tr><b>
Line #193:
Line #194:</td>
Line #195:<td colspan=2 align=right bgcolor=$szin><b>"
Line #196:.number_format($ft)."</b></td>
Line #197:<td bgcolor=$szin> Ft</td>
Line #198:<td align=right bgcolor=$szin><b>$i </b></td>
Line #199:<td align=left bgcolor=$szin></b> Db</td>
Line #200:</tr>";
Line #201:
Line #202:echo"</table>";
Line #203:
Line #204:
Line #205://include("QJ_varlist.php");
Line #206:
Line #207:if (isset($_GET[nyomtat])) {
Line #208:include("QJ_listaveg.php");
Line #209:
Line #210:echo("<body onload='printit()'></body>");
Line #211:
Line #212:?>
Line #213:<SCRIPT Language="Javascript">
Line #214:
Line #215:function printit(){
Line #216:
Line #217:
Line #218:window.print();
Line #219:///////////////////////////////////////
Line #220://window.open("QJ_felad.php", 'sframe');
Line #221:///////////////////////////////////////
Line #222://window.open("QJ_gyujto.php", 'sframe');
Line #223:
Line #224:}
Line #225:</script>
Line #226:<?PHP
Line #227:}
Line #228:
Line #229://~*~// QJ_napi.php
Line #230:?>
Line #231:
Line #232: