QJ_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:
Line #75:$ee=" <SELECT
Line #76:onchange=this.form.submit(); return true name='Qid[";
Line #77:$e="";
Line #78:
Line #79:$keres = "SELECT distinct szoveg,qj_ear1,qj_arnev FROM qj_ear where archiv<>'*' order by qj_arkod";
Line #80:
Line #81://$arform="?";
Line #82:
Line #83:
Line #84:
Line #85:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #86:{
Line #87:
Line #88:$e.="<option value='".$alapar[1]."/".$egy_sor[qj_arnev]."'>".$egy_sor[szoveg]."</option>";
Line #89:else
Line #90:$e.="<option value='".$egy_sor[qj_ear1]."/".$egy_sor[qj_arnev]."'>".$egy_sor[szoveg]."</option>";
Line #91://echo(htmlspecialchars($e)."<hr>");
Line #92://$arform=$egy_sor[qj_arkod];
Line #93:}
Line #94:
Line #95:$e.="</SELECT>";
Line #96:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and not ($_SESSION[SQL_elad]) order by szek_kod ";
Line #97:
Line #98://echo($SQLszek."<hr>");
Line #99:
Line #100:
Line #101:$nur=mysql_num_rows($szekek);
Line #102:
Line #103:if ($nur==0) {
Line #104:
Line #105:if (isset($_GET[napi])) $info="A mai ".$datum. " napra "; else $info="";
Line #106:
Line #107:echo "<script>
Line #108:
Line #109: window.open('QJ_exit.php', 'adatframe');
Line #110: </script>";
Line #111:exit;
Line #112:}
Line #113:
Line #114:
Line #115:<font color=red>$musor[datum]
Line #116:$musor[cim]</font><br>
Line #117:$helyszin</H3>
Line #118:
Line #119:<table border=1>
Line #120:<tr bgcolor=silver>
Line #121:<td align=right ><b>Ssz.</b></td>
Line #122:
Line #123:
Line #124:<td align=right ><b>Statusz</td>
Line #125:
Line #126:
Line #127:</tr>";
Line #128:
Line #129:
Line #130:
Line #131:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #132:{
Line #133:
Line #134:
Line #135:if (strpos($jegysor[szoveg],"EOF")==0) {
Line #136:
Line #137:++$i;
Line #138:$kati=$jegysor[arkategoria];
Line #139:
Line #140:if ($_SESSION['login']=="BI(c)")
Line #141:$ref="<a href=BI_ediTable.php?&wjid=".$jegysor[wid]."&sqlfile=qj_jegy>".$jegysor[wid]."</a><br>".$i;
Line #142://else
Line #143:$ref=$i;
Line #144:
Line #145:
Line #146:
Line #147:/*
Line #148:
Line #149:
Line #150:$h=split(':',$fid);
Line #151:$nur=count($h)-1;
Line #152:
Line #153:$arsel="<SELECT name='megye_kod'>
Line #154:
Line #155:
Line #156:for($j=0;$j<$nur;$j++)
Line #157:
Line #158:{
Line #159:// if ($h[$j]==$cimlet[arforma]) $ezaz=" selected "; else $ezaz="";
Line #160:
Line #161: $arsel .="<option value='".$h[$j]."' $ezaz >".$h[$j]."</option>";
Line #162:}
Line #163:
Line #164:$arsel .="</select>";
Line #165:*/
Line #166:
Line #167:
Line #168://$ref="<a target=sframe href=QJ_kijelolONE.php?&wjid=".$jegysor[wid].">".$jegysor[wid]."</a>";
Line #169:
Line #170:
Line #171:if ($musor[erkezesi]=="Y")
Line #172:
Line #173:else
Line #174:$Hely_ir="$jegysor[szoveg]";
Line #175:
Line #176:
Line #177:$nev="";
Line #178:$cim="";
Line #179:$telefon="";
Line #180:if ($jegysor[vevo_kod]>0) {
Line #181:$keres = "SELECT * FROM qj_cimtar where wid=".$jegysor[vevo_kod];
Line #182:$csor=mysql_query($keres) or die($keres."Hiba a select-ben");
Line #183:$cim_sor = mysql_fetch_array( $csor );
Line #184:$nev=$cim_sor[nev];
Line #185:$cim=$cim_sor[irsz]." ".$cim_sor[telepules]." ".$cim_sor[cim];
Line #186:$telefon=$cim_sor[telszam];
Line #187:if ($cim_sor[uzenet]<>"" ) $telefon.=" {".$cim_sor[uzenet]."}";
Line #188:}
Line #189:
Line #190:
Line #191:
Line #192:echo"<tr>
Line #193:<td align=right ><b>
Line #194: $ref
Line #195:</b></td>
Line #196:
Line #197:<td align=right ><b>$Hely_ir</b></td>
Line #198:<td align=right ><b>$jegysor[statusz]</b></td>
Line #199:<td align=right ><b>$nev</b></td>
Line #200:<td align=right ><b>$telefon</b></td>
Line #201:</tr>";
Line #202:
Line #203:$sumft=$sumft+$jegysor[ar];
Line #204:}
Line #205:
Line #206:
Line #207:
Line #208:
Line #209:}
Line #210:
Line #211:echo"<tr bgcolor=silver>
Line #212:
Line #213:<td align=right ><b>".number_format($i)."</b></td>
Line #214:<td colspan=5 align=left > darab</td>
Line #215:</tr>";
Line #216:echo "</table>";
Line #217:
Line #218:echo "</form>";
Line #219:
Line #220:include("QJ_stop.php");
Line #221:
Line #222:/*
Line #223:if (isset($_GET[nyomtat])) {
Line #224:include("QJ_listaveg.php");
Line #225:
Line #226:
Line #227:echo("<body onload='printit()'></body>");
Line #228:
Line #229:?>
Line #230:<SCRIPT Language="Javascript">
Line #231:
Line #232:function printit(){
Line #233:
Line #234:
Line #235:window.print();
Line #236:///////////////////////////////////////
Line #237:window.open('QJ_musorLIST.php','sframe');
Line #238:///////////////////////////////////////
Line #239:
Line #240:}
Line #241:
Line #242:
Line #243:</script>
Line #244:<?PHP
Line #245:}
Line #246:*/
Line #247:
Line #248://~*~// QJ_fulljegy.php
Line #249:
Line #250:?>