Bi-Dir

QL_musorSTATeloelad_MK.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:$sum_osft=0;
Line #15:$sum_osdb=0;
Line #16:$sum_ertdb=0;
Line #17:$sum_elodb=0;
Line #18:$sum_uresdb=0;
Line #19:$sum_csopdb=0;
Line #20:$sum_potdb=0;
Line #21:$sum_nulldb=0;
Line #22:$ir="<table border=1>";
Line #23:
Line #24:
Line #25:
Line #26:$formcall="QJ_musorSTATeloelad_MK.php";
Line #27://include("BI_musorFILTER.php");
Line #28://include("../_inc_QJ/QC_selectMUSOR.inc");
Line #29://include("../_inc_QJ/QC_musorEVHOselect.inc");
Line #30:include("../_inc_QJ/QC_musorEVHOselect_MK.inc");
Line #31:
Line #32://?//$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB $ord ";
Line #33://?//$_SESSION[musorRAPORT_SQL]=$keres;
Line #34://?//$_SESSION[musorRAPORT_wer]= $wer;
Line #35:
Line #36:$keres = $_SESSION[musorRAPORT_SQL];
Line #37://?//echo($keres."<hr>");
Line #38:
Line #39://$nur=mysql_num_rows($eredmeny);
Line #40:
Line #41:echo "<table border=1>
Line #42:<tr bgcolor=silver>
Line #43:
Line #44:
Line #45:
Line #46:
Line #47:
Line #48:<td width=40 align=right>Csoportos Db </td>
Line #49:<td width=40 align=right>Egyedi Db </td>
Line #50:
Line #51:
Line #52:</tr>";
Line #53:
Line #54:$i=0;
Line #55:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #56:{
Line #57:++$i;
Line #58:
Line #59:$helyszin_kod=$musor[hely_kod];
Line #60:$datum_kod=$musor[datum_kod];
Line #61:$cim_kod=$musor[cim_kod];
Line #62:$cim_url=$musor[cim_url];
Line #63:$kep_url=$musor[kep_url];
Line #64:$wjid=$musor[wid];
Line #65:
Line #66://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #67://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #68: ////////
Line #69:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #70:and not $_SESSION[SQL_inet] ORDER BY vevo_kod";
Line #71:
Line #72:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."'
Line #73:and not $_SESSION[SQL_inet] ORDER BY vevo_kod";
Line #74:
Line #75://$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 #76:
Line #77:
Line #78://echo($SQLszek."<hr>");
Line #79:
Line #80:
Line #81:$nur=mysql_num_rows($szekek);
Line #82:$osft=0;
Line #83:$ertdb=0;
Line #84:$elodb=0;
Line #85:$uresdb=0;
Line #86:$csopdb=0;
Line #87:$potdb=0;
Line #88:$nulldb=0;
Line #89:$vevo_kod=0;
Line #90:$csoportjel="N";
Line #91:
Line #92:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #93:{
Line #94:
Line #95:if ($vevo_kod<>$jegysor[vevo_kod]) {
Line #96: $vevo_kod=$jegysor[vevo_kod];
Line #97: $cimSQL = "SELECT * FROM qj_cimtar WHERE wid='".$vevo_kod."'";
Line #98:
Line #99:
Line #100: $cimsor = mysql_fetch_array($cimrec);
Line #101: $row =mysql_fetch_row($cimrec);
Line #102:
Line #103:
Line #104: if (substr($cimsor[csoport_kod],0,2)=="##") $csoportjel="Y"; else $csoportjel="N";
Line #105:
Line #106://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 #107:
Line #108:
Line #109:}
Line #110:
Line #111:$statusz=substr($jegysor[statusz],0,2);
Line #112:
Line #113:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #114: $osft=$osft+$jegysor[ar];
Line #115: ++$ertdb;
Line #116:
Line #117: //$ir.="<tr><td>$jegysor[wid]</td><td>$jegysor[datum_kod]</td><td>$jegysor[ar]</td><td>$jegysor[statusz]</td></tr>";
Line #118:
Line #119: if ($jegysor[ar]==0) ++$nulldb;
Line #120:
Line #121:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #122: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #123: else ++$uresdb;
Line #124:}
Line #125:
Line #126:$cimkieg="";
Line #127:if($musor[cimkieg1]<>"" ) $cimkieg.=" ".$musor[cimkieg1]."";
Line #128:if($musor[cimkieg2]<>"" ) $cimkieg.=" ".$musor[cimkieg2]."";
Line #129:
Line #130:
Line #131:
Line #132:
Line #133:
Line #134://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #135:
Line #136:
Line #137:
Line #138:$odb=$musor[sum_keszlet];
Line #139:
Line #140:
Line #141:
Line #142:$sum_osft=$sum_osft+$osft;
Line #143:$sum_osdb=$sum_osdb+$odb;
Line #144:$sum_ertdb=$sum_ertdb+$ertdb;
Line #145:$sum_elodb=$sum_elodb+$elodb;
Line #146:$sum_csopdb=$sum_csopdb+$csopdb;
Line #147:
Line #148:
Line #149:$uresdb=$odb-$ertdb-$elodb-$csopdb;
Line #150:
Line #151:$sum_uresdb=$sum_uresdb+$uresdb;
Line #152:$sum_nulldb=$sum_nulldb+$nulldb;
Line #153:
Line #154:if ($odb==0) {
Line #155: $atl_ertdb=0;
Line #156: $atl_csopdb=0;
Line #157: $atl_elodb=0;
Line #158: $atl_uresdb=0;
Line #159:} else {
Line #160: $atl_ertdb=$ertdb/$odb;
Line #161: $atl_csopdb=$csopdb/$odb;
Line #162: $atl_elodb=$elodb/$odb;
Line #163: $atl_uresdb=$uresdb/$odb;
Line #164:}
Line #165:
Line #166:
Line #167:
Line #168:
Line #169:
Line #170:
Line #171:
Line #172:
Line #173://!// SZINAPSZIS <a href=$QJ_path$cim_url target=szinapszis title='SZINAPSZIS'>$cim_url</a>
Line #174:
Line #175:echo"<tr>
Line #176:<td align=center >
Line #177: $edit$datum_kod</a>
Line #178: 
Line #179: $aref
Line #180: $bref
Line #181: $xls
Line #182: </td>
Line #183:<td align=right >
Line #184:$musor[rovid_helyszin]
Line #185:$erkezesi
Line #186:</td>
Line #187:<td align=right >$musor[datum] 
Line #188:
Line #189:</td>
Line #190:<td align=right bgcolor=gold >".number_format($osft)."</td>
Line #191:<td align=right >".number_format($ertdb).
Line #192:" ".substr(($atl_ertdb*100),0,4)."%</td>
Line #193:<td align=right >".number_format($csopdb).
Line #194:" ".substr(($atl_csopdb*100),0,4)."%</td>
Line #195:<td align=right >".number_format($elodb).
Line #196:" ".substr(($atl_elodb*100),0,4)."%</td>
Line #197:<td align=right bgcolor=Teal >".number_format($uresdb)." ".substr(($atl_uresdb*100),0,4)."%</td>
Line #198:<td align=right bgcolor=silver>".number_format($odb)." $nulldb</td>
Line #199:</tr>";
Line #200:}
Line #201:
Line #202:$odb=$sum_ertdb+$sum_csopdb+$sum_elodb+$sum_uresdb;
Line #203:
Line #204:if ($odb==0) {
Line #205: $atl_ertdb=0;
Line #206: $atl_csopdb=0;
Line #207: $atl_elodb=0;
Line #208: $atl_uresdb=0;
Line #209:} else {
Line #210: $atl_ertdb=$sum_ertdb/$odb;
Line #211: $atl_csopdb=$sum_csopdb/$odb;
Line #212: $atl_elodb=$sum_elodb/$odb;
Line #213: $atl_uresdb=$sum_uresdb/$odb;
Line #214:}
Line #215:
Line #216:echo "<tr bgcolor=silver>
Line #217:<td colspan=3 align=right >
Line #218:
Line #219:</td>
Line #220:<td align=right >".number_format($sum_osft)."</td>
Line #221:<td align=right >".number_format($sum_ertdb).
Line #222:" ".substr(($atl_ertdb*100),0,4)."%</td>
Line #223:<td align=right >".number_format($sum_csopdb).
Line #224:" ".substr(($atl_csopdb*100),0,4)."%</td>
Line #225:<td align=right >".number_format($sum_elodb).
Line #226:" ".substr(($atl_elodb*100),0,4)."%</td>
Line #227:<td align=right >".number_format($sum_uresdb).
Line #228:" ".substr(($atl_uresdb*100),0,4)."%</td>
Line #229:<td align=right >".number_format($sum_osdb)." $sum_nulldb</td>
Line #230:</tr>";
Line #231:
Line #232:echo "</table>";
Line #233:
Line #234:
Line #235://$ir.="</table>";
Line #236://echo $ir;
Line #237:
Line #238:
Line #239:?>