Bi-Dir

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