QB_napijegy.inc
Line #0:<?php
Line #1:
Line #2:$_SESSION[QJ_nyomtatEXIT]="QJ_napijegy.php";
Line #3:
Line #4:if (!isset($_SESSION[SQL_inet])) {
Line #5:
Line #6:++$_SESSION[QJ_hiba];
Line #7:
Line #8:echo "<script>
Line #9:
Line #10: window.open('QJ_musorLIST.php','sframe');
Line #11: </script>";
Line #12:}
Line #13:$_SESSION[QJ_hiba]=0;
Line #14:/*
Line #15:if (isset($_GET[nyomtat])) {
Line #16:?>
Line #17:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #18:<?PHP
Line #19:}
Line #20:*/
Line #21:
Line #22:
Line #23://INCLUDE("QJ_varlist.php");
Line #24:
Line #25:echo "
Line #26:<form name='formS' method='POST' target=sframe action='QJ_kijelolNAPI.php?bimod=napi'>";
Line #27:
Line #28:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #29:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #30:
Line #31:if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #32:/*if (isset($_GET[musor_kod]))
Line #33:$keres="SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #34:else*/
Line #35:$datum=date("Y.m.d");
Line #36:
Line #37:$keres = "SELECT * FROM qj_musor where datum_fej='".$datum."' order by datum_kod DESC limit 1";
Line #38:
Line #39:if (isset($_GET[musor_kod]))
Line #40:$keres="SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #41:
Line #42:if (isset($_GET[napi]))
Line #43:$keres = "SELECT * FROM qj_musor where datum_fej='".$datum."' and future<>'*' order by datum_fej limit 1";
Line #44:
Line #45://echo($keres."<hr>");
Line #46:$i=0;
Line #47:
Line #48:
Line #49:$nur=mysql_num_rows($eredmeny);
Line #50:
Line #51:
Line #52://///////////////////////////////////////////////////////////////////////////////
Line #53:
Line #54://///////////////////////////////////////////////////////////////////////////////
Line #55:
Line #56:
Line #57:$L_PHP="QJ_napijegy.php";
Line #58:include("QJ_listafej.php");
Line #59:*/
Line #60:
Line #61:$sumft=0;
Line #62:$musor = mysql_fetch_array( $eredmeny );
Line #63:
Line #64:$helyszin=$musor[helyszin];
Line #65:$helyszin_kod=$musor[hely_kod];
Line #66:$datum_kod=$musor[datum_kod];
Line #67:
Line #68:$alapar[1]=$musor[alapar1];
Line #69:$alapar[2]=$musor[alapar2];
Line #70:$alapar[3]=$musor[alapar3];
Line #71:
Line #72:$wjid=$musor[wid];
Line #73:
Line #74:$keres = "SELECT distinct szoveg,qj_ear1,qj_arnev FROM qj_ear where archiv<>'*' and datum_kod='".$datum_kod."' order by szoveg";
Line #75:
Line #76://$arform="?";
Line #77:
Line #78:$ee=" <SELECT
Line #79:onchange=this.form.submit(); return true name='Qid[";
Line #80:$e="";
Line #81:
Line #82:$ek=$e;
Line #83:
Line #84:$ia=0;
Line #85:
Line #86:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #87:{
Line #88:
Line #89:
Line #90:$e.="<option value='".$alapar[1]."/".$egy_sor[qj_arnev]."'>".$egy_sor[szoveg]."</option>";
Line #91:else
Line #92:$e.="<option value='".$egy_sor[qj_ear1]."/".$egy_sor[qj_arnev]."'>".$egy_sor[szoveg]."</option>";
Line #93:
Line #94:if ($egy_sor[szoveg]=="-") $e=$ek;
Line #95:
Line #96:++$ia;
Line #97://echo(htmlspecialchars($e)."<hr>");
Line #98://$arform=$egy_sor[qj_arkod];
Line #99:}
Line #100:
Line #101:
Line #102:if ($ia==0)
Line #103:
Line #104:
Line #105:$e.="</SELECT>";
Line #106:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and not ($_SESSION[SQL_elad]) order by szek_kod ";
Line #107:
Line #108://echo($SQLszek."<hr>");
Line #109:
Line #110:
Line #111:$nur=mysql_num_rows($szekek);
Line #112:
Line #113:if ($nur==0) {
Line #114:
Line #115:if (isset($_GET[napi])) $info="A mai ".$datum. " napra "; else $info="";
Line #116:
Line #117:echo "<script>
Line #118:
Line #119: window.open('QJ_exit.php', 'adatframe');
Line #120: </script>";
Line #121:exit;
Line #122:}
Line #123:
Line #124:
Line #125:<font color=red>$musor[datum]
Line #126:$musor[cim]</font><br>
Line #127:$helyszin</H3>
Line #128:
Line #129:<table border=1>
Line #130:<tr bgcolor=silver>
Line #131:<td align=right ><b>Ssz.</b></td>
Line #132:
Line #133:
Line #134:<td align=right ><b>Statusz</td>
Line #135:
Line #136:
Line #137:</tr>";
Line #138:
Line #139:
Line #140:
Line #141:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #142:{
Line #143:
Line #144:
Line #145:if (strpos($jegysor[szoveg],"EOF")==0) {
Line #146:
Line #147:++$i;
Line #148:$kati=$jegysor[arkategoria];
Line #149:
Line #150:if ($_SESSION['login']=="BI(c)")
Line #151:$ref="<a href=BI_ediTable.php?&wjid=".$jegysor[wid]."&sqlfile=qj_jegy>".$jegysor[wid]."</a><br>".$i;
Line #152://else
Line #153:$ref=$i;
Line #154:
Line #155:
Line #156:
Line #157:/*
Line #158:
Line #159:
Line #160:$h=split(':',$fid);
Line #161:$nur=count($h)-1;
Line #162:
Line #163:$arsel="<SELECT name='megye_kod'>
Line #164:
Line #165:
Line #166:for($j=0;$j<$nur;$j++)
Line #167:
Line #168:{
Line #169:// if ($h[$j]==$cimlet[arforma]) $ezaz=" selected "; else $ezaz="";
Line #170:
Line #171: $arsel .="<option value='".$h[$j]."' $ezaz >".$h[$j]."</option>";
Line #172:}
Line #173:
Line #174:$arsel .="</select>";
Line #175:*/
Line #176:
Line #177:
Line #178://$ref="<a target=sframe href=QJ_kijelolONE.php?&wjid=".$jegysor[wid].">".$jegysor[wid]."</a>";
Line #179:
Line #180:
Line #181:if ($musor[erkezesi]=="Y")
Line #182:
Line #183:else
Line #184:$Hely_ir="$jegysor[szoveg]";
Line #185:
Line #186:
Line #187:$nev="";
Line #188:$cim="";
Line #189:$telefon="";
Line #190:if ($jegysor[vevo_kod]>0) {
Line #191:$keres = "SELECT * FROM qj_cimtar where wid=".$jegysor[vevo_kod];
Line #192:$csor=mysql_query($keres) or die($keres."Hiba a select-ben");
Line #193:$cim_sor = mysql_fetch_array( $csor );
Line #194:$nev=$cim_sor[nev];
Line #195:$cim=$cim_sor[irsz]." ".$cim_sor[telepules]." ".$cim_sor[cim];
Line #196:$telefon=$cim_sor[telszam];
Line #197:if ($cim_sor[uzenet]<>"" ) $telefon.=" {".$cim_sor[uzenet]."}";
Line #198:}
Line #199:
Line #200:
Line #201:
Line #202:echo"<tr>
Line #203:<td align=right ><b>
Line #204: $ref
Line #205:</b></td>
Line #206:
Line #207:<td align=right ><b>$Hely_ir</b></td>
Line #208:<td align=right ><b>$jegysor[statusz]</b></td>
Line #209:<td align=right ><b>$nev</b></td>
Line #210:<td align=right ><b>$telefon</b></td>
Line #211:</tr>";
Line #212:
Line #213:$sumft=$sumft+$jegysor[ar];
Line #214:}
Line #215:
Line #216:
Line #217:
Line #218:
Line #219:}
Line #220:
Line #221:echo"<tr bgcolor=silver>
Line #222:
Line #223:<td align=right ><b>".number_format($i)."</b></td>
Line #224:<td colspan=5 align=left > darab</td>
Line #225:</tr>";
Line #226:echo "</table>";
Line #227:
Line #228:echo "</form>";
Line #229:
Line #230:include("QJ_stop.php");
Line #231:
Line #232:/*
Line #233:if (isset($_GET[nyomtat])) {
Line #234:include("QJ_listaveg.php");
Line #235:
Line #236:
Line #237:echo("<body onload='printit()'></body>");
Line #238:
Line #239:?>
Line #240:<SCRIPT Language="Javascript">
Line #241:
Line #242:function printit(){
Line #243:
Line #244:
Line #245:window.print();
Line #246:///////////////////////////////////////
Line #247:window.open('QJ_musorLIST.php','sframe');
Line #248:///////////////////////////////////////
Line #249:
Line #250:}
Line #251:
Line #252:
Line #253:</script>
Line #254:<?PHP
Line #255:}
Line #256:*/
Line #257:
Line #258://~*~// QJ_fulljegy.php
Line #259:
Line #260:?>