QJ_bossARossz_JA.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_unset.php','sframe');
Line #10: </script>";
Line #11:}
Line #12:$_SESSION[QJ_hiba]=0;
Line #13:
Line #14:$musor_kod=$_GET[musor_kod];
Line #15:
Line #16:if (isset($_GET[nyomtat])) {
Line #17:?>
Line #18:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #19:<?PHP
Line #20:}
Line #21:
Line #22:
Line #23:$sumosft=0;
Line #24:$sumertdb=0;
Line #25:$sumkpft=0;
Line #26:$sumkpdb=0;
Line #27:$sumbankft=0;
Line #28:$sumbankdb=0;
Line #29:$sumbhft=0;
Line #30:$sumbhdb=0;
Line #31:
Line #32:$ir="<table border=1>";
Line #33:
Line #34:
Line #35:$keres = "SELECT * FROM qj_musor where future <>'*' $bosSEL";
Line #36:
Line #37:
Line #38:
Line #39://?//echo($keres."<hr>");
Line #40:
Line #41:
Line #42:$nur=mysql_num_rows($eredmeny);
Line #43:
Line #44:if ($nur==0 )
Line #45:{
Line #46:echo("<h1>Nincs adat!</h1>");
Line #47:exit;
Line #48:}
Line #49://///////////
Line #50:$wer=$bosSEL;
Line #51://///////////
Line #52:
Line #53:if ( $adoalany<>"") {
Line #54:$wer="";
Line #55:$wer=" and future <>'*' and (";
Line #56:$or= " ";
Line #57:while ( $jegysor = mysql_fetch_array( $eredmeny )){
Line #58:$arind[$ind]=trim($jegysor[ar]);
Line #59:$wer.=$or." datum_kod='$jegysor[datum_kod]' ";
Line #60:$or= " or ";
Line #61:
Line #62:}
Line #63:
Line #64:$wer.=" )";
Line #65:
Line #66:}
Line #67:
Line #68:
Line #69:$wery = "SELECT * from qj_login where email_kod='SyS' and passw='...SyS...'";
Line #70:$disR = mysql_query($wery) ;
Line #71:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #72:$adoalanyFEJ="<br><font color=blue>".$disC[nev]."</font>";
Line #73:}
Line #74:
Line #75:
Line #76:
Line #77:$L_PHP="QJ_bossARossz.php?&musor_kod=$musor_kod";
Line #78:include("QJ_listafej.php");
Line #79:
Line #80:
Line #81:
Line #82://$SQLjegy = "SELECT distinct ar, arkategoria FROM qj_jegy WHERE statusz<>'' and
Line #83:
Line #84:$SQLjegy = "SELECT distinct ar FROM qj_jegy WHERE statusz<>'' and
Line #85: left(statusz,2)<>'El' and left(statusz,2)<>'St' and left(bizonylatszam,3)<>'BH:' and ar>0 $wer ORDER BY ar";
Line #86:
Line #87:
Line #88://?//echo($keres."<hr>");
Line #89:
Line #90:
Line #91:
Line #92://?//echo ($SQLjegy."<hr>");
Line #93:
Line #94:
Line #95:
Line #96:$arak="";
Line #97:$ind=0;
Line #98:
Line #99:
Line #100:while ( $jegysor = mysql_fetch_array( $szekek )){
Line #101:$arind[$ind]=trim($jegysor[ar]);
Line #102:$arak.="<td width=40 align=right>&nbsp;<b>".$jegysor[ar]."</b>&nbsp;Ft&nbsp;</td>";
Line #103:++$ind;
Line #104:}
Line #105:
Line #106:
Line #107:
Line #108://////////////////////////////////////////
Line #109:
Line #110://////////////////////////////////////////
Line #111:
Line #112:$Barak="~";
Line #113:
Line #114:$SQLjegy = "SELECT distinct berlet_Azonosito,datum_kod FROM qj_musor WHERE archiv<>'*' $wer ";
Line #115:
Line #116://?//echo ($SQLjegy."<hr>");
Line #117:
Line #118:while ( $jegysor = mysql_fetch_array( $szekek )){
Line #119:
Line #120:$SQLberlet = "SELECT * FROM qj_musor WHERE datum_kod='$jegysor[berlet_Azonosito]'";
Line #121:
Line #122:$musor = mysql_fetch_array( $musSor );
Line #123:
Line #124://?//echo ($SQLberlet."<hr>");
Line #125:
Line #126:$ar1=$musor[alapar1]/10;
Line #127:$pos=strpos($arak,"b>".$ar1);
Line #128: $Barak.="$jegysor[datum_kod]/1/$ar1~";
Line #129:if ($pos==0){
Line #130:$arind[$ind]=trim($ar1);
Line #131:$arak.="<td width=40 align=right>&nbsp;<b>".$ar1."</b>&nbsp;Ft&nbsp;</td>";
Line #132:++$ind;
Line #133:}
Line #134:
Line #135:$ar2=$musor[alapar2]/10;
Line #136:$pos=strpos($arak,"b>".$ar2);
Line #137://?//echo ($pos."/".$ar2."<hr>");
Line #138: $Barak.="$jegysor[datum_kod]/2/$ar2~";
Line #139://?//echo ($Barak."<hr>");
Line #140:
Line #141:if ($pos==0){
Line #142: $arind[$ind]=trim($ar2);
Line #143: $arak.="<td width=40 align=right>&nbsp;<b>".$ar2."</b>&nbsp;Ft&nbsp;</td>";
Line #144: ++$ind;
Line #145:}}
Line #146:
Line #147:
Line #148:
Line #149:
Line #150:if ($ind>0)
Line #151:
Line #152:else
Line #153:$arak="";
Line #154:
Line #155:echo "<table wdht=100% border=1>
Line #156:<tr bgcolor=silver>
Line #157:
Line #158:
Line #159:
Line #160:".$arfej."
Line #161:</tr>";
Line #162:
Line #163:
Line #164:echo "
Line #165:<tr bgcolor=silver>
Line #166:<td width=60 align=right > Ft</td>
Line #167:<td width=60 align=right > Db</td>
Line #168:".$arak."
Line #169:</tr>";
Line #170:
Line #171:
Line #172:for ($j=0;$j<$ind;$j++) {
Line #173: $sardb[$j]=0;
Line #174:// echo $arind[$i]."/".$i."<hr>";
Line #175:
Line #176:}
Line #177:$i=0;
Line #178:
Line #179:
Line #180:
Line #181:
Line #182:$keres = "SELECT * FROM qj_musor where future <>'*' $bosSEL ORDER BY cim,datum_fej";
Line #183:
Line #184://?//echo($keres."<hr>");
Line #185:
Line #186:
Line #187:
Line #188:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #189:{
Line #190:++$i;
Line #191:
Line #192:$helyszin_kod=$musor[hely_kod];
Line #193:$datum_kod=$musor[datum_kod];
Line #194:$cim_kod=$musor[cim_kod];
Line #195:$wjid=$musor[wid];
Line #196:
Line #197:$SQLjegy = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' AND
Line #198:statusz<>'' ORDER BY statusz";
Line #199:
Line #200:
Line #201:
Line #202:$nur=mysql_num_rows($szekek);
Line #203:$osft=0;
Line #204:$ertdb=0;
Line #205:
Line #206:
Line #207:$kpft=0;
Line #208:$kpdb=0;
Line #209:$bankft=0;
Line #210:$bankdb=0;
Line #211:$bhft=0;
Line #212:$bhdb=0;
Line #213:
Line #214:
Line #215:for ($j=0;$j<$ind;$j++) {
Line #216: $ardb[$j]=0;
Line #217:// echo $arind[$i]."/".$i."<hr>";
Line #218:
Line #219:}
Line #220:
Line #221:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #222:{
Line #223:
Line #224:$statusz=substr($jegysor[statusz],0,2);
Line #225:
Line #226:$ar=$jegysor[ar];
Line #227:if (substr($jegysor[bizonylatszam],0,2)=='BH'and $ar==0 and $Barak<>"~") {
Line #228:$ker=$jegysor[datum_kod]."/".$jegysor[arkategoria]."/";
Line #229:$pos=strpos($Barak,$ker);
Line #230:$L=strlen($Barak);
Line #231:$v=substr($Barak,$pos-$L+13);
Line #232:$k=strpos($v,"~");
Line #233:$bar=substr($v,0,$k);
Line #234:$ar=$bar;
Line #235://?//
Line #236://echo ($pos."/".$L."<br>".$v."<br>".$k."<br>".$Barak."<hr>".$bar."<hr>".$ker);
Line #237://$Barak="$jegysor[datum_kod]/1/$ar1~";
Line #238://$Barak="~";
Line #239:
Line #240:}
Line #241:
Line #242:
Line #243:
Line #244:
Line #245:if ($statusz<>'El' and $statusz<>'St') {
Line #246:for ($j=0;$j<$ind;$j++) {
Line #247:if ((1+$arind[$j])==(1+$ar)) {
Line #248: ++$ardb[$j];
Line #249: ++$sardb[$j];
Line #250://if ($i<3)
Line #251://echo $i."***/".$arind[$j].$statusz.$j."..../".$ardb[$j]."xxx/".$jegysor[ar]."wwwww<hr>";
Line #252:}}}
Line #253:
Line #254:
Line #255:$bhft=$bhft+$ar;
Line #256:++$bhdb;
Line #257:$sumbhft=$sumbhft+$ar;
Line #258:++$sumbhdb;
Line #259:$statusz="*";
Line #260:}
Line #261:
Line #262:
Line #263:$kpft=$kpft+$ar;
Line #264:++$kpdb;
Line #265:$sumkpft=$sumkpft+$ar;
Line #266:++$sumkpdb;
Line #267:}
Line #268:
Line #269:if ( $statusz=="Ba") {
Line #270:$bankft=$bankft+$ar;
Line #271:++$bankdb;
Line #272:$sumbankft=$sumbankft+$ar;
Line #273:++$sumbankdb;
Line #274:}
Line #275:
Line #276:if ($statusz<>'El' and $statusz<>'St') {
Line #277:
Line #278: $osft=$osft+$ar;
Line #279: ++$ertdb;
Line #280: $sumosft=$sumosft+$ar;
Line #281: ++$sumertdb;
Line #282:}
Line #283:}
Line #284:
Line #285://if ($ertdb>0) {
Line #286:
Line #287:$arir="";
Line #288:$swdb=0;
Line #289:
Line #290:for ($j=0;$j<$ind;$j++) {
Line #291:
Line #292:if (isset($_GET[nyomtat])) {
Line #293:if ($ardb[$j]>0)
Line #294:$arir.="<td width=40 align=right ><b>".$ardb[$j]." </b></td>";
Line #295:else
Line #296:$arir.="<td width=40 align=center >__</td>";
Line #297:
Line #298:}else {
Line #299:if ($ardb[$j]>0)
Line #300:$arir.="<td width=40 align=right bgcolor=azure
Line #301: title='$arind[$ind]' ><b>".$ardb[$j]."</b>&nbsp;<a title='".$arind[$j]." Ft' href=# ><b>&nbsp;db&nbsp;</b></a></td>";
Line #302:else
Line #303:$arir.="<td width=40 align=center >-</td>";
Line #304:}
Line #305:
Line #306:$swdb=$swdb+$ardb[$j];
Line #307:}
Line #308:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #309:
Line #310:echo"<tr>
Line #311:<td align=left >
Line #312:<a href=NO_helyrajz.php?&musor_kod=$musor[datum_kod] >
Line #313:
Line #314:</a>$musor[cim]
Line #315: </td>
Line #316:
Line #317:<td align=center >
Line #318: $musor[datum]
Line #319: <br>
Line #320: <i>
Line #321: $musor[helyszin]
Line #322: </i>
Line #323: </td>
Line #324:<td align=right bgcolor=gold ><b>".number_format($osft)."</b></td>
Line #325:<td align=right bgcolor=gold ><b>".number_format($ertdb)."</b></td>
Line #326:".$arir. "
Line #327:</tr>";
Line #328://}
Line #329:
Line #330:}
Line #331:
Line #332:$arir="";
Line #333:$swdb=0;
Line #334:
Line #335:for ($j=0;$j<$ind;$j++) {
Line #336:$arir.="<td width=40 bgcolor=silver align=right><b>".$sardb[$j]." </b></td>";
Line #337:$swdb=$swdb+$sardb[$j];
Line #338:}
Line #339:
Line #340:$arir.="<td width=40 bgcolor=silver align=right><b>".$swdb." </b></td>";
Line #341:
Line #342:
Line #343:echo"<tr bgcolor=silver>
Line #344:<td colspan=2 align=right >
Line #345:
Line #346: </td>
Line #347:<td align=right ><b>".number_format($sumosft)."</b></td>
Line #348:<td align=right ><b>".number_format($sumertdb)."</b></td>
Line #349:".$arir. "
Line #350:</tr>";
Line #351:
Line #352:echo "</table>";
Line #353:
Line #354:
Line #355:if (isset($_SESSION[InfoURL]) and $_SESSION[InfoURL]<>"")
Line #356:echo("
Line #357:<BR><BR>
Line #358:<IFRAME SRC='$_SESSION[InfoURL]'
Line #359:WIDTH=800 HEIGHT=240 border=0
Line #360:</IFRAME>
Line #361:");
Line #362:
Line #363:
Line #364:
Line #365:
Line #366:if (isset($_GET[nyomtat])) {
Line #367:include("QJ_listaveg.php");
Line #368:
Line #369:echo("<body onload='printit()'></body>");
Line #370:
Line #371:?>
Line #372:<SCRIPT Language="Javascript">
Line #373:
Line #374:function printit(){
Line #375:
Line #376:window.print();
Line #377:
Line #378:}
Line #379:
Line #380:</script>
Line #381:<?PHP
Line #382:}
Line #383:function mumber_format($ertek)
Line #384:{
Line #385:return $ertek;
Line #386:}
Line #387:?>