QJ_musorLIST.inc

---

Line #0:<?php
Line #1:
Line #2://unset($_SESSION[SQL_inet]);
Line #3:if (!isset($_SESSION[SQL_inet])) {
Line #4:
Line #5:++$_SESSION[QJ_hiba];
Line #6:
Line #7:echo "<script>
Line #8:
Line #9: window.open('QJ_musorLIST.php','sframe');
Line #10: </script>";
Line #11:}
Line #12:$_SESSION[QJ_hiba]=0;
Line #13:
Line #14:
Line #15:$sum_osft=0;
Line #16:$sum_osdb=0;
Line #17:$sum_ertdb=0;
Line #18:$sum_elodb=0;
Line #19:$sum_uresdb=0;
Line #20:$sum_csopdb=0;
Line #21:$sum_potdb=0;
Line #22:$sum_nulldb=0;
Line #23:$ir="<table border=1>";
Line #24:
Line #25:
Line #26:
Line #27:
Line #28:$formcall="QJ_musorLIST.php";
Line #29:
Line #30:include("BI_musorFILTER.php");
Line #31:
Line #32:if (isset($_GET[nyomtat])) {
Line #33:?>
Line #34:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #35:<?PHP
Line #36:}
Line #37:
Line #38:
Line #39:
Line #40:$L_PHP="QJ_musorLIST.php";
Line #41:include("QJ_listafej.php");
Line #42:
Line #43:
Line #44:
Line #45:echo "<table border=1>
Line #46:<tr bgcolor=silver>
Line #47:
Line #48:
Line #49:
Line #50:
Line #51:
Line #52:
Line #53:
Line #54:
Line #55:
Line #56:</tr>";
Line #57:
Line #58:$i=0;
Line #59:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #60:{
Line #61:++$i;
Line #62:
Line #63:$helyszin_kod=$musor[hely_kod];
Line #64:$datum_kod=$musor[datum_kod];
Line #65:$cim_kod=$musor[cim_kod];
Line #66:$cim_url=$musor[cim_url];
Line #67:$kep_url=$musor[kep_url];
Line #68:$wjid=$musor[wid];
Line #69:
Line #70://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #71://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #72: ////////
Line #73:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #74:and not $_SESSION[SQL_inet] ORDER BY vevo_kod";
Line #75:
Line #76:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."'
Line #77:and not $_SESSION[SQL_inet] ORDER BY vevo_kod";
Line #78:
Line #79://$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 vevo_kod ";
Line #80:
Line #81:
Line #82://echo($SQLszek."<hr>");
Line #83:
Line #84:
Line #85:$nur=mysql_num_rows($szekek);
Line #86:$osft=0;
Line #87:$ertdb=0;
Line #88:$elodb=0;
Line #89:$uresdb=0;
Line #90:$csopdb=0;
Line #91:$potdb=0;
Line #92:$nulldb=0;
Line #93:$vevo_kod=0;
Line #94:$csoportjel="N";
Line #95:
Line #96:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #97:{
Line #98:
Line #99:if ($vevo_kod<>$jegysor[vevo_kod]) {
Line #100: $vevo_kod=$jegysor[vevo_kod];
Line #101: $cimSQL = "SELECT * FROM qj_cimtar WHERE wid='".$vevo_kod."'";
Line #102:
Line #103:
Line #104: $cimsor = mysql_fetch_array($cimrec);
Line #105: $row =mysql_fetch_row($cimrec);
Line #106:
Line #107:
Line #108: if (substr($cimsor[csoport_kod],0,2)=="##") $csoportjel="Y"; else $csoportjel="N";
Line #109:
Line #110://ECHO($csoportjel."/".$cimsor[csoport_kod].$row[0]."/".$row[1]."/".$row[2]."/".$row[3]."/".$row[4]."/".$row[5]."/".$row[6]."/".$row[7]."/".$row[8].$cimsor[nev]."<hr>");
Line #111:
Line #112:
Line #113:}
Line #114:
Line #115:$statusz=substr($jegysor[statusz],0,2);
Line #116:
Line #117:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #118: $osft=$osft+$jegysor[ar];
Line #119: ++$ertdb;
Line #120:
Line #121: //$ir.="<tr><td>$jegysor[wid]</td><td>$jegysor[datum_kod]</td><td>$jegysor[ar]</td><td>$jegysor[statusz]</td></tr>";
Line #122:
Line #123: if ($jegysor[ar]==0) ++$nulldb;
Line #124:
Line #125:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #126: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #127: else ++$uresdb;
Line #128:}
Line #129:
Line #130:$cimkieg="";
Line #131:if($musor[cimkieg1]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg1]."</i>";
Line #132:if($musor[cimkieg2]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg2]."</i>";
Line #133:
Line #134:
Line #135:
Line #136:
Line #137:
Line #138://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #139:
Line #140:
Line #141:
Line #142:$odb=$musor[sum_keszlet];
Line #143:
Line #144:$sum_osft=$sum_osft+$osft;
Line #145:$sum_osdb=$sum_osdb+$odb;
Line #146:$sum_ertdb=$sum_ertdb+$ertdb;
Line #147:$sum_elodb=$sum_elodb+$elodb;
Line #148:$sum_csopdb=$sum_csopdb+$csopdb;
Line #149:
Line #150:
Line #151:$uresdb=$odb-$ertdb-$elodb-$csopdb;
Line #152:
Line #153:$sum_uresdb=$sum_uresdb+$uresdb;
Line #154:$sum_nulldb=$sum_nulldb+$nulldb;
Line #155:
Line #156:if ($odb==0) {
Line #157: $atl_ertdb=0;
Line #158: $atl_csopdb=0;
Line #159: $atl_elodb=0;
Line #160: $atl_uresdb=0;
Line #161:} else {
Line #162: $atl_ertdb=$ertdb/$odb;
Line #163: $atl_csopdb=$csopdb/$odb;
Line #164: $atl_elodb=$elodb/$odb;
Line #165: $atl_uresdb=$uresdb/$odb;
Line #166:}
Line #167:
Line #168:
Line #169:
Line #170:
Line #171:
Line #172:
Line #173:
Line #174:
Line #175:
Line #176: else $cref="";
Line #177:
Line #178:$cref="";
Line #179:
Line #180:
Line #181:
Line #182:
Line #183:
Line #184:' SRC='..//_Screen/world1.png' border=0></a>";
Line #185:if ($ertdb+$csopdb+$elodb==0)
Line #186:{ $bref='';
Line #187: $vip='';
Line #188: $xls='';
Line #189:}
Line #190:
Line #191:
Line #192:if($osft >0 and $musor[datum_kod]<>"" and $musor[berlet_Azonosito]<>"" and $musor[datum_kod]<>$musor[berlet_Azonosito])
Line #193:
Line #194: SRC='..//_Screen/refresh.gif' border=0></a>";
Line #195:else
Line #196:$szinkron="";
Line #197:
Line #198:
Line #199://<a href=$QJ_path$cim_url target=szinapszis title='SZINAPSZIS'>$cim_url</a>
Line #200:
Line #201:
Line #202:
Line #203:echo"<tr>
Line #204:<td align=center ><b>
Line #205: $edit$datum_kod</a>
Line #206: </b><br>
Line #207: $bref
Line #208: $vip
Line #209: $cref
Line #210: $xls
Line #211: </td>
Line #212:<td align=right >$musor[datum]<BR>
Line #213:$musor[helyszin]
Line #214:$erkezesi
Line #215:</td>
Line #216:<td align=right >
Line #217:
Line #218:
Line #219:$szinkron &nbsp;
Line #220:
Line #221:</td>
Line #222:<td align=right bgcolor=gold ><font color=red><b>".number_format($osft)."</b></font></td>
Line #223:<td align=right >".number_format($ertdb).
Line #224:"<br><i>".substr(($atl_ertdb*100),0,4)."%</i></td>
Line #225:<td align=right >".number_format($csopdb).
Line #226:"<br><i>".substr(($atl_csopdb*100),0,4)."%</i></td>
Line #227:<td align=right >".number_format($elodb).
Line #228:"<br><i>".substr(($atl_elodb*100),0,4)."%</i></td>
Line #229:<td align=right bgcolor=Teal >".number_format($uresdb)."<br><i>".substr(($atl_uresdb*100),0,4)."%</i></td>
Line #230:<td align=right bgcolor=silver>".number_format($odb)."<br>$nulldb</td>
Line #231:
Line #232:</tr>";
Line #233:
Line #234:
Line #235:}
Line #236:
Line #237:$odb=$sum_ertdb+$sum_csopdb+$sum_elodb+$sum_uresdb;
Line #238:
Line #239:if ($odb==0) {
Line #240: $atl_ertdb=0;
Line #241: $atl_csopdb=0;
Line #242: $atl_elodb=0;
Line #243: $atl_uresdb=0;
Line #244:} else {
Line #245: $atl_ertdb=$sum_ertdb/$odb;
Line #246: $atl_csopdb=$sum_csopdb/$odb;
Line #247: $atl_elodb=$sum_elodb/$odb;
Line #248: $atl_uresdb=$sum_uresdb/$odb;
Line #249:}
Line #250:
Line #251:if ($odb>0) {$elo_atldb=$atl_elodb/$odb; $ures_atldb=$atl_uresdb/$odb;} else
Line #252:{$elo_atldb=0; $ures_atldb=0;}
Line #253:
Line #254:echo "<tr bgcolor=silver>
Line #255:<td colspan=3 align=right ><b>
Line #256:
Line #257:</b></td>
Line #258:<td align=right ><b>".number_format($sum_osft)."</b></td>
Line #259:<td align=right ><b>".number_format($sum_ertdb).
Line #260:"<br><i>".substr(($atl_ertdb*100),0,4)."%</i></b></td>
Line #261:<td align=right ><b>".number_format($sum_csopdb).
Line #262:"<br><i>".substr(($atl_csopdb*100),0,4)."%</i></b></td>
Line #263:<td align=right ><b>".number_format($sum_elodb).
Line #264:"<br><i>".substr(($elo_atldb*100),0,4)."%</i></b></td>
Line #265:<td align=right ><b>".number_format($sum_uresdb).
Line #266:"<br><i>".substr(($ures_atldb*100),0,4)."%</i></b></td>
Line #267:<td align=right ><b>".number_format($sum_osdb)."<br>$sum_nulldb</b></td>
Line #268:</tr>";
Line #269:
Line #270:echo "</table>";
Line #271:
Line #272:
Line #273://$ir.="</table>";
Line #274://echo $ir;
Line #275:
Line #276:
Line #277:if (isset($_GET[nyomtat])) {
Line #278:include("QJ_listaveg.php");
Line #279:
Line #280:echo("<body onload='printit()'></body>");
Line #281:
Line #282:?>
Line #283:<SCRIPT Language="Javascript">
Line #284:
Line #285:function printit(){
Line #286:
Line #287:
Line #288:window.print();
Line #289:///////////////////////////////////////
Line #290://window.open("QJ_felad.php", 'sframe');
Line #291:///////////////////////////////////////
Line #292:
Line #293:}
Line #294:</script>
Line #295:<?PHP
Line #296:}
Line #297:
Line #298:
Line #299:?>