QJ_fulljegy.inc

---

Line #0:<?php
Line #1:
Line #2:if (!isset($_SESSION[SQL_inet])) {
Line #3:
Line #4:++$_SESSION[QJ_hiba];
Line #5:
Line #6:echo "<script>
Line #7:
Line #8: window.open('QJ_musorLIST.php','sframe');
Line #9: </script>";
Line #10:}
Line #11:$_SESSION[QJ_hiba]=0;
Line #12:
Line #13:if (isset($_GET[nyomtat])) {
Line #14:?>
Line #15:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #16:<?PHP
Line #17:}
Line #18:
Line #19:
Line #20:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #21:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #22:
Line #23:if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #24:
Line #25:
Line #26:if (isset($_GET[musor_kod]))
Line #27:$keres="SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #28:else
Line #29:$keres = "SELECT * FROM qj_musor order by datum_kod";
Line #30:
Line #31:$i=0;
Line #32:
Line #33:
Line #34:
Line #35:
Line #36:$nur=mysql_num_rows($eredmeny);
Line #37:
Line #38://///////////////////////////////////////////////////////////////////////////////
Line #39:
Line #40://///////////////////////////////////////////////////////////////////////////////
Line #41:
Line #42:
Line #43:$L_PHP="QJ_fulljegy.php";
Line #44:include("QJ_listafej.php");
Line #45:
Line #46:
Line #47:
Line #48:
Line #49:echo "<table border=1>
Line #50:<tr bgcolor=silver>
Line #51:<td align=right ><b>Ssz.</b></td>
Line #52:
Line #53:<td width=40 align=right ><b>Ft</td>
Line #54:<td width=40 align=right ><b>Statusz</td>
Line #55:
Line #56:<td width=40 align=right><b>Datum kod </td>
Line #57:
Line #58:
Line #59:</tr>";
Line #60:
Line #61:$sumft=0;
Line #62:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #63:{
Line #64:
Line #65:$helyszin=$musor[helyszin];
Line #66:$helyszin_kod=$musor[hely_kod];
Line #67:$datum_kod=$musor[datum_kod];
Line #68:
Line #69:$alapar[1]=$musor[alapar1];
Line #70:$alapar[2]=$musor[alapar2];
Line #71:$alapar[3]=$musor[alapar3];
Line #72:
Line #73:$wjid=$musor[wid];
Line #74:
Line #75:if (isset($_GET[full_mod]))
Line #76:
Line #77:
Line #78://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-' and not $_SESSION[SQL_elojegy] and $_SESSION[SQL_elad] order by wid ";
Line #79:
Line #80:/*$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-' and ($_SESSION[SQL_berlet] or $_SESSION[SQL_jegy]) order by statusz,wid ";
Line #81:else
Line #82:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-' and not $_SESSION[SQL_elojegy] and $_SESSION[SQL_elad] and ($_SESSION[SQL_berlet] or $_SESSION[SQL_jegy]) order by wid ";
Line #83:*/
Line #84:
Line #85:
Line #86:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' order by szek_kod ";
Line #87:else
Line #88:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and not $_SESSION[SQL_elojegy] and $_SESSION[SQL_elad] and ($_SESSION[SQL_berlet] or $_SESSION[SQL_jegy]) order by wid ";
Line #89:
Line #90:
Line #91://IF ($_SESSION[login]<>"BI(c)")
Line #92://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' order by szek_kod ";
Line #93:
Line #94:
Line #95://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-' and $_SESSION[SQL_elad] and ar=0 ORDER BY vevo_kod";
Line #96:
Line #97://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-' and not $_SESSION[SQL_elad] and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #98:
Line #99://?// echo($SQLszek."<hr>");
Line #100:
Line #101:// datum_kod=~EF13D00079~ and archiv=~?~ order by szek_kod
Line #102:
Line #103:
Line #104:
Line #105:$nur=mysql_num_rows($szekek);
Line #106:
Line #107:
Line #108:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #109:{
Line #110:++$i;
Line #111:$kati=$jegysor[arkategoria];
Line #112:
Line #113:if ($_SESSION['login']=="BI(c)")
Line #114:$ref="<a href=BI_ediTable.php?&wjid=".$jegysor[wid]."&sqlfile=qj_jegy>".$jegysor[wid]."</a><br>".$jegysor[archiv].$i."<br>".$jegysor[future];
Line #115:else
Line #116:$ref=$i;
Line #117:
Line #118:
Line #119:echo"<tr>
Line #120:<td align=right ><b>
Line #121: $ref
Line #122:</b></td>
Line #123:<td align=right >$musor[cim]&nbsp;$musor[datum]<i><br>$helyszin $jegysor[szoveg]</i></td>
Line #124:<td align=right ><b>".number_format($jegysor[ar])."</b></td>
Line #125:<td >$jegysor[arkategoria] / $jegysor[statusz]</td>
Line #126:<td >$jegysor[ar_nev] / $jegysor[bizomanyos]</td>
Line #127:<td >$jegysor[datum_kod]</td>
Line #128:<td >$jegysor[szek_kod]</td>
Line #129:<td >".$jegysor[logtime]."</td>
Line #130:</tr>";
Line #131:
Line #132:$sumft=$sumft+$jegysor[ar];
Line #133:
Line #134:
Line #135:}}
Line #136:
Line #137:echo"<tr bgcolor=silver>
Line #138:
Line #139:<td align=right ><b>".number_format($sumft)."</b></td>
Line #140:<td align=left > Ft </td>
Line #141:<td align=right ><b>".number_format($i)."</b></td>
Line #142:<td colspan=3 align=left > darab</td>
Line #143:</tr>";
Line #144:echo "</table>";
Line #145:
Line #146:include("QJ_stop.php");
Line #147:
Line #148:if (isset($_GET[nyomtat])) {
Line #149:include("QJ_listaveg.php");
Line #150:
Line #151:
Line #152:echo("<body onload='printit()'></body>");
Line #153:
Line #154:?>
Line #155:<SCRIPT Language="Javascript">
Line #156:
Line #157:function printit(){
Line #158:
Line #159:
Line #160:window.print();
Line #161:///////////////////////////////////////
Line #162://window.open('QJ_musorLIST.php','sframe');
Line #163:///////////////////////////////////////
Line #164:
Line #165:}
Line #166:
Line #167:
Line #168:</script>
Line #169:<?PHP
Line #170:}
Line #171:
Line #172:
Line #173://~*~// QJ_fulljegy.php
Line #174:
Line #175:?>