Bi-Dir

QJ_vevoLIST.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:}
Line #8:
Line #9:
Line #10:$login=$_SESSION['login'];
Line #11:
Line #12:if (isset($_GET[musor_kod])) {
Line #13:$_SESSION[CALL_KOD]=$_GET[musor_kod];
Line #14:$datum_kod=$_GET[musor_kod];
Line #15:}
Line #16:
Line #17:if (isset($_SESSION[CALL_KOD])) $CALL_KOD=" datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #18:
Line #19:if ($_POST[bizomanyos]=="0") UNSET($_POST[bizomanyos]);
Line #20:
Line #21:
Line #22:if (isset($_POST[bizomanyos]))
Line #23:{
Line #24: $wer= " and bizomanyos='".$_POST[bizomanyos]."'";
Line #25:
Line #26:} else {
Line #27: $wer="";
Line #28:
Line #29:}
Line #30:
Line #31:
Line #32:if (isset($_SESSION[CALL_KOD])) {
Line #33:$keres = "SELECT * FROM qj_musor where datum_kod='".$_SESSION[CALL_KOD]."'";
Line #34:
Line #35:
Line #36:$nur=mysql_num_rows($meredmeny);
Line #37:$musor=mysql_fetch_array($meredmeny);
Line #38:$HEAD=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim];
Line #39:
Line #40:} else $HEAD="";
Line #41:
Line #42:
Line #43:
Line #44:$L_NAP=$HEAD;
Line #45:
Line #46:
Line #47:if (isset($_GET[Nemfizeto])) {
Line #48:
Line #49: $L_NAP=$HEAD;
Line #50: $wer="";
Line #51:
Line #52: $L_cim="";
Line #53:}
Line #54:
Line #55:
Line #56:$L_PHP="QJ_vevoLIST.php";
Line #57:include("QJ_listafej.php");
Line #58:
Line #59:echo "<table border=1 width=100%>
Line #60:<tr bgcolor=silver>
Line #61:
Line #62:
Line #63:
Line #64:<td align=right >Foglalva</td>
Line #65:<td align=right >Eladva</td>
Line #66:</tr>";
Line #67:
Line #68:
Line #69://$parancs="SELECT * FROM qj_jegy where left(statusz,2)='El' $wer $CALL_KOD ORDER BY vevo_kod,szek_kod";
Line #70:
Line #71://$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 #72:$parancs="SELECT * FROM qj_jegy where left(statusz,1)<>' ' and left(statusz,2)<>'St' and $CALL_KOD and vevo_kod>0 ORDER BY vevo_kod,szek_kod";
Line #73:
Line #74:if (isset($_GET[Nemfizeto])) {
Line #75: $parancs = "SELECT * FROM qj_jegy WHERE $_SESSION[SQL_elad] and ar=0 and left(statusz,2)='Pr' ORDER BY vevo_kod,datum_kod,szek_kod" ;
Line #76:}
Line #77:
Line #78:
Line #79:
Line #80:$aktvevo=0;
Line #81:$i=0;
Line #82:$eli=0;
Line #83:$si=0;
Line #84:$seli=0;
Line #85:
Line #86://echo($parancs."<hr>");
Line #87:
Line #88:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #89:{
Line #90:
Line #91:$datum_kod=$egy_sor[datum_kod];
Line #92:
Line #93:if ($aktvevo<>$egy_sor[vevo_kod] and ($i+$eli)>0) {
Line #94: sorIR ($aktvevo,$i,$eli,$datum_kod,$noREF);
Line #95: $si=$si+$i;
Line #96: $seli=$seli+$eli;
Line #97: $i=0;
Line #98: $eli=0;
Line #99:
Line #100:}
Line #101:
Line #102:$aktvevo=$egy_sor[vevo_kod];
Line #103:
Line #104:if (substr($egy_sor[statusz],0,2)<>'El') ++$eli; else ++$i;
Line #105:
Line #106:}
Line #107://///
Line #108: $si=$si+$i;
Line #109: $seli=$seli+$eli;
Line #110: sorIR ($aktvevo,$i,$eli,$datum_kod,$noREF);
Line #111://///
Line #112:
Line #113:echo("
Line #114:<tr bgcolor=silver>
Line #115:
Line #116: <td align=center >$si </td>
Line #117: <td align=center > $seli</td>
Line #118:</tr>");
Line #119:
Line #120:echo "
Line #121:</table>";
Line #122:
Line #123:if (isset($_GET[nyomtat])) {
Line #124:include("QJ_listaveg.php");
Line #125:
Line #126:
Line #127:echo("<body onload='printit()'></body>");
Line #128:
Line #129:?>
Line #130:<SCRIPT Language="Javascript">
Line #131:
Line #132:function printit(){
Line #133:
Line #134:window.print();
Line #135:
Line #136:}
Line #137:
Line #138:
Line #139:</script>
Line #140:<?PHP
Line #141:}
Line #142:
Line #143://////////////
Line #144:function sorIR ($aktvevo,$i,$eli,$datum_kod,$noREF) {
Line #145://////////////
Line #146:
Line #147:
Line #148:$keres = "SELECT * FROM qj_cimtar where wid=$aktvevo";
Line #149:
Line #150:$cimtar=mysql_fetch_array($meredmeny);
Line #151:
Line #152:IF ($cimtar[telszam]>"") $telefon=" ".$cimtar[telszam]; else $telefon="";
Line #153:IF ($cimtar[email_cim]>"") $email_cim=" ".$cimtar[email_cim]; else $email_cim="";
Line #154:IF ($cimtar[cim]>"") $cim=" ".$cimtar[cim]; else $cim="";
Line #155:IF ($cimtar[irsz]>"") $irsz=" ".$cimtar[irsz]; else $irsz="";
Line #156:
Line #157:IF ($cimtar[csoport_kod]>"") $csoport_kod=" ".$cimtar[csoport_kod]; else $csoport_kod="";
Line #158:
Line #159:if (isset($_GET[Nemfizeto])) $Apar="&protokoll=Y"; ELSE $Apar="&datum_kod=".$datum_kod;
Line #160:
Line #161:if ($i>0)
Line #162: $ir1="
Line #163:<A target=infoframe href=QJ_elojegyzesek.php?&vevo=$aktvevo$Apar>
Line #164:
Line #165:";
Line #166:else $ir1="";
Line #167:
Line #168:if ($eli>0)
Line #169: $ir2="
Line #170:<A target=infoframe href=QJ_eladasok.php?&vevo=$aktvevo$Apar>
Line #171:
Line #172:";
Line #173:else $ir2="";
Line #174:
Line #175:if (isset($_GET[nyomtat]) or $noREF=='Y') $ir="<td align=right>$aktvevo</a></td>"; else
Line #176: $ir="
Line #177:<td align=right>
Line #178:<A target=infoframe
Line #179:href=QJ_cimtarUP.php?&sqlfile=qj_cimtar&wjid=$aktvevo>
Line #180:$aktvevo 
Line #181:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #182:</a>
Line #183:$ir1
Line #184:$ir2
Line #185:$csoport_kod
Line #186:</td>
Line #187:";
Line #188:
Line #189:echo("
Line #190:<tr> $ir
Line #191: <td >$cimtar[nev]$telefon $email_cim</td>
Line #192: <td >$cimtar[telepules]$irsz</td>
Line #193: <td >$cim</td>
Line #194: <td align=center >$i </td>
Line #195: <td align=center >$eli</td>
Line #196:</tr>");
Line #197:
Line #198:}
Line #199:
Line #200:
Line #201://~*~// QJ_vevoLIST.php
Line #202:?>