Bi-Dir

QJ_haviFELADASview.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:for ($i=1;$i<32;$i++) {
Line #4:if (isset($_POST["napZAR".$i]) and $_POST["napZAR".$i]<>"*" and $_SESSION[napZARind]<>$i ) {
Line #5://echo $_POST["napZAR".$i]."/",$i;
Line #6://$reln="<a target=adatframe href='QJ_napi.php?&L_nap=$wnap&L_biz=$aktbizo'>".$wnap."</a>";
Line #7:
Line #8:$_SESSION[napZARind]=$i;
Line #9:
Line #10:echo "<script>
Line #11: window.open('QJ_feladIR.php".$_POST["napZAR".$i]."', 'infoframe');
Line #12: </script>";
Line #13:exit;
Line #14:// window.open('QJ_musor.php', 'sframe');
Line #15:}}
Line #16:
Line #17:
Line #18:$sum_osft=0;
Line #19:$sum_osdb=0;
Line #20:$sum_ertdb=0;
Line #21:$sum_elodb=0;
Line #22:$sum_uresdb=0;
Line #23:$sum_csopdb=0;
Line #24:$sum_potdb=0;
Line #25:$sum_nulldb=0;
Line #26:$ir="<table border=1>";
Line #27:
Line #28:$ord=" order by helyszin,cim,datum ";
Line #29:
Line #30:
Line #31:
Line #32:if ($_SESSION[hely_nev]<>"*") $L_cim.="<br>".$_SESSION[hely_nev];
Line #33:
Line #34:$L_PHP="QJ_haviFELADAS.php";
Line #35:include("QJ_listafej.php");
Line #36:
Line #37:
Line #38:
Line #39:
Line #40:
Line #41:
Line #42:$wer=$_SESSION[HoHelyWer];
Line #43:$wer="";
Line #44://////////////////////////////////////
Line #45:$keres="SELECT distinct bizomanyos FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $wer ORDER BY logtime,bizomanyos";
Line #46:$keres="SELECT distinct bizomanyos FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $jegySEL $wer ORDER BY logtime,bizomanyos";
Line #47://?//echo($keres."<hr>");
Line #48:
Line #49:
Line #50:$Pi=0;
Line #51:
Line #52:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #53:{
Line #54:if ($egy_sor[bizomanyos]<>"") {
Line #55:++$Pi;
Line #56:$Pt[$Pi]=$egy_sor[bizomanyos];
Line #57:}}
Line #58:
Line #59:
Line #60:
Line #61:echo "
Line #62:<form name='formF' method='POST' target='infoframe' action='QJ_haviFELADAS.php'>
Line #63:<table border=1 >
Line #64:<tr bgcolor=silver>
Line #65:
Line #66:<td width=60 align=right ><b>Ft</td>
Line #67:<td width=60 align=right ><b>Db</td>
Line #68:";
Line #69:
Line #70:for ($i=1;$i<$Pi+1;$i++) {
Line #71:echo "
Line #72:<td align=right width=60 ><b>$Pt[$i]</b></td>
Line #73:";
Line #74:}
Line #75:
Line #76:for ($i=1;$i<$Pi+1;$i++) {
Line #77:echo "
Line #78:<td align=right width=60 bgcolor=Moccasin ><b>$Pt[$i]</b></td>
Line #79:";
Line #80:}
Line #81:
Line #82:
Line #83:echo "</tr>";
Line #84:
Line #85:for ($i=1;$i<$Pi+1;$i++) {
Line #86: $Posft[$i]=0;
Line #87: $Fosft[$i]=0;
Line #88:}
Line #89:
Line #90://////////////////////////////////////
Line #91:$keres="SELECT * FROM qj_musor where future <>'*' $wer ORDER BY datum_evho,helyszin,datum,cim";
Line #92://$keres=$_SESSION[HoHelyWer]." ORDER BY datum_evho,rovid_helyszin,datum,cim";;
Line #93:$keres="SELECT * FROM qj_jegy where future <>'*' $wer ORDER BY logtime ";
Line #94:
Line #95:$keres="SELECT * FROM qj_jegy where
Line #96:ar>0 and future <>'*' and $_SESSION[SQL_elad] $_SESSION[HaviJegySel] $jegySEL $wer ORDER BY logtime,bizomanyos";
Line #97:
Line #98://?//echo($keres."<hr>");
Line #99:
Line #100:
Line #101:$nur=mysql_num_rows($eredmeny);
Line #102:
Line #103:$wnap="?";
Line #104:$osft=0;
Line #105:$ertdb=0;
Line #106:$elodb=0;
Line #107:$uresdb=0;
Line #108:$csopdb=0;
Line #109:$potdb=0;
Line #110:$nulldb=0;
Line #111:$napi=1;
Line #112:
Line #113://////////////////////////////////////////////////
Line #114:while ( $musor = mysql_fetch_array( $eredmeny ))
Line #115:{
Line #116://////////////////////////////////////////////////
Line #117:
Line #118:if ($wnap<>substr($musor[logtime],0,10)) {
Line #119:
Line #120:if ($wnap<>"?") {
Line #121:
Line #122:
Line #123:$wSEL="
Line #124:
Line #125:<SELECT TITLE='$wnap'
Line #126:onchange=this.form.submit(); return true name='napZAR$napi'>";
Line #127:$wSEL.="<option value='*' >".$wnap."</option>";
Line #128:
Line #129:for ($i=1;$i<$Pi+1;$i++) {
Line #130: $par="?&L_nap=".$wnap."&L_biz=".$Pt[$i]."&feladIR=Y";
Line #131:$wSEL.="<option value='".$par."' >".$Pt[$i]."</option>";
Line #132:}
Line #133:
Line #134:if ($Pi>1)
Line #135:
Line #136:
Line #137:$wSEL.="</SELECT>";
Line #138:++$napi;
Line #139:
Line #140:echo"<tr>
Line #141:<td align=right ><b>
Line #142: $wSEL</a>
Line #143: </b>
Line #144: </td>
Line #145:<td width=60 align=right $szin ><b>".number_format($osft)."</b></td>
Line #146:<td width=60 align=right $szin ><B>".number_format($ertdb)."</B></td>
Line #147:";
Line #148:
Line #149:for ($i=1;$i<$Pi+1;$i++) {
Line #150:
Line #151:$cimletSQL="SELECT * FROM qj_cimlet where
Line #152:szoveg ='$wnap' and bizomanyos ='$Pt[$i]'";
Line #153:
Line #154://?//echo($cimletSQL."<hr>");
Line #155:
Line #156:
Line #157:$nur=mysql_num_rows($cimleteredmeny);
Line #158:if ($nur>0) {
Line #159: $cimlet = mysql_fetch_array( $cimleteredmeny );
Line #160: $Fmusft[$i]=$cimlet[KPft]+ $cimlet[Bank_Ft]+ $cimlet[UCS_Ft] + $cimlet[UT_Ft] + $cimlet[ST_Ft] ;
Line #161:
Line #162: $Fmusft[$i]=$Fmusft[$i] + $cimlet[ELONYEL_FT] ;
Line #163:
Line #164:} else $Fmusft[$i]=0;
Line #165:
Line #166:$Fosft[$i]= $Fosft[$i]+$Fmusft[$i];
Line #167:
Line #168:if ($Fmusft[$i]<>$Pmusft[$i]) $Fszin=" bgcolor=red "; else $Fszin="";
Line #169:
Line #170:echo "
Line #171:<td width=60 align=right $Fszin><b>".number_format($Pmusft[$i])."</b></td>
Line #172:";
Line #173:}
Line #174:
Line #175:for ($i=1;$i<$Pi+1;$i++) {
Line #176:if ($Fmusft[$i]<>$Pmusft[$i]) $Fszin=" bgcolor=red "; else $Fszin=" bgcolor=azure ";
Line #177:echo "
Line #178:<td width=60 align=right $Fszin><b>".number_format($Fmusft[$i])."</b></td>
Line #179:";
Line #180:}
Line #181:echo "</tr>";
Line #182:
Line #183:}
Line #184://///////
Line #185:
Line #186:for ($i=1;$i<$Pi+1;$i++) {
Line #187: $Pmusft[$i]=0;
Line #188:}
Line #189:
Line #190:$osft=0;
Line #191:$ertdb=0;
Line #192:$elodb=0;
Line #193:$uresdb=0;
Line #194:$csopdb=0;
Line #195:$potdb=0;
Line #196:$nulldb=0;
Line #197:$vevo_kod=0;
Line #198:$csoportjel="N";
Line #199:}
Line #200://///////
Line #201:
Line #202:$wnap=substr($musor[logtime],0,10);
Line #203:$statusz=substr($jegysor[statusz],0,2);
Line #204:
Line #205:$osft=$osft+$musor[ar];
Line #206:++$ertdb;
Line #207:for ($i=1;$i<$Pi+1;$i++) {
Line #208:if ($Pt[$i]==$musor[bizomanyos]) {
Line #209: $Pmusft[$i]=$Pmusft[$i]+$musor[ar];
Line #210: $Posft[$i]=$Posft[$i]+$musor[ar];
Line #211:}}
Line #212:
Line #213:if ($musor[ar]==0) ++$nulldb;
Line #214:
Line #215:++$sum_ertdb;
Line #216:$sum_osft=$sum_osft+$musor[ar];
Line #217:
Line #218:}
Line #219:
Line #220:
Line #221:echo "<tr bgcolor=silver>
Line #222:<td width=60 align=right ><b>
Line #223:
Line #224:</b></td>
Line #225:<td width=60 align=right ><b>".number_format($sum_osft)."</b></td>
Line #226:<td width=60 align=right ><b>".number_format($sum_ertdb). "</B></td>";
Line #227:
Line #228:for ($i=1;$i<$Pi+1;$i++) {
Line #229:echo "
Line #230:<td width=60 align=right ><b>".number_format($Posft[$i])."</b></td>
Line #231:";
Line #232:}
Line #233:
Line #234:$hiba=0;
Line #235:$elteres=0;
Line #236:for ($i=1;$i<$Pi+1;$i++) {
Line #237: if ($Fosft[$i]<>$Posft[$i]) ++$hiba;
Line #238: $elteres=$elteres+$Posft[$i]-$Fosft[$i];
Line #239:echo "
Line #240:<td width=60 align=right ><b>".number_format($Fosft[$i])."</b></td>
Line #241:";
Line #242:}
Line #243:
Line #244:
Line #245:echo "</tr>";
Line #246:
Line #247:if ($hiba>0) {
Line #248:$span=" colspan=".($Pi+1);
Line #249:echo "<tr bgcolor=azure >
Line #250:<td width=60 align=right ><b>
Line #251:
Line #252:</b></td>
Line #253:<td width=60 bgcolor=red align=right ><b>".number_format($elteres)."</b></td>
Line #254:<td width=60 $span align=right > </td>
Line #255:
Line #256:";
Line #257:
Line #258:
Line #259:
Line #260:for ($i=1;$i<$Pi+1;$i++) {
Line #261:if ($Posft[$i]<>$Fosft[$i])
Line #262:echo "
Line #263:<td width=60 bgcolor=red align=right ><b>".number_format($Posft[$i]-$Fosft[$i])."</b></td>
Line #264:";
Line #265:else
Line #266:echo "
Line #267:<td width=60 bgcolor=green align=right ><b>0</b> </td>
Line #268:";
Line #269:
Line #270:}
Line #271:
Line #272:
Line #273:echo "</tr>";
Line #274:
Line #275:}
Line #276:
Line #277:
Line #278:
Line #279:echo "</table></form>";
Line #280:
Line #281:?>