Bi-Dir

QJ_raportKATEGORIAK.inc

Line #0:<?php
Line #1://include("QJ_start.php"); /*Qjegy2010v02-006 */
Line #2:
Line #3://BI_alert("?KATEGORIAK");
Line #4://include("QJ_varlist.php");
Line #5:
Line #6:
Line #7:if (!isset($_SESSION[SQL_inet])) {
Line #8:
Line #9:++$_SESSION[QJ_hiba];
Line #10:
Line #11:if ($_SESSION[login]="BI(c)") include ("gvarlist.php");
Line #12:
Line #13:echo "<script>
Line #14:
Line #15: window.open('QJ_musorLIST.php','sframe');
Line #16: </script>";
Line #17:}
Line #18:$_SESSION[QJ_hiba]=0;
Line #19:
Line #20:
Line #21:if (isset($_GET[nyomtat])) {
Line #22:?>
Line #23:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #24:<?PHP
Line #25:}
Line #26:
Line #27:
Line #28:$login=$_SESSION['login'];
Line #29:
Line #30:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #31:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #32:
Line #33:if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #34:
Line #35:
Line #36:
Line #37:$szin="";
Line #38:$i=0;
Line #39:$ft=0;
Line #40:$nap="?";
Line #41:$ri=0;
Line #42:$rft=0;
Line #43:$rmuv="?";
Line #44:
Line #45:$rft1=0;
Line #46:$rmuv1="?";
Line #47:$indhead="";
Line #48:$indmax=0;
Line #49:
Line #50:$Katimax=0;
Line #51:$closedFT=0;
Line #52:$closedDB=0;
Line #53:
Line #54:if ($_POST[bizomanyos]=="0") UNSET($_POST[bizomanyos]);
Line #55:
Line #56:if (isset($_POST[bizomanyos] ))
Line #57:{
Line #58: $wer= " and bizomanyos='".$_POST[bizomanyos]."'";
Line #59:
Line #60:} else {
Line #61: $wer="";
Line #62:
Line #63:}
Line #64:
Line #65://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY statusz,bizomanyos,logtime";
Line #66://$parancs="SELECT * FROM qj_jegy where QJ_sor_n<>'*' ORDER BY arkategoria,statusz,logtime";
Line #67:
Line #68:
Line #69:
Line #70:
Line #71:$parancs="SELECT * FROM qj_musor where datum_kod='$_GET[musor_kod]' ";
Line #72:
Line #73:$musor = mysql_fetch_array( $eredmeny );
Line #74:
Line #75:$disQ = "SELECT * FROM qj_sql where szoveg='Arsav' and usr_kod='$musor[hely_kod]' order by widarc" ;
Line #76:
Line #77:
Line #78:
Line #79:while ( $disC = mysql_fetch_array( $disR )) {
Line #80: /////////
Line #81: $ARtitle[$disC[widarc]]=$disC[sql_memo];
Line #82: $ARkatind[$disC[widarc]]=$disC[archiv];
Line #83:// echo($ARtitle[$disC[widarc]].'/'.$disC[widarc]);
Line #84: ////////
Line #85:}
Line #86:
Line #87:
Line #88:
Line #89:
Line #90:$parancs="SELECT * FROM qj_jegy where archiv='-' and statusz<>'' and left(statusz,2)<>'St' and left(statusz,2)<>'El' $CALL_KOD ORDER BY arkategoria,statusz,logtime DESC";
Line #91:$parancs="SELECT * FROM qj_jegy where archiv='-' and statusz<>'' and left(statusz,2)<>'St' and left(statusz,2)<>'El' $CALL_KOD ORDER BY arkategoria DESC ";
Line #92:
Line #93:
Line #94:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #95:{
Line #96:
Line #97:
Line #98:
Line #99:$closedFT=$closedFT+$egy_sor[ar];
Line #100:++$closedDB;
Line #101:
Line #102:$si=0;
Line #103:
Line #104:
Line #105:
Line #106:
Line #107:
Line #108:
Line #109:
Line #110:
Line #111:
Line #112:$sl=strlen(trim($egy_sor[ar_nev]));
Line #113:
Line #114:
Line #115:/// mennyi ilyen van? ERROR LISTA -> SELECT SQL....
Line #116:
Line #117:
Line #118:
Line #119:else $egy_sor[arkategoria]=$ARkatind[$egy_sor[arkategoria]];
Line #120:
Line #121:
Line #122:
Line #123:if (strpos($indhead,trim($egy_sor[ar_nev]))==0 )
Line #124:{
Line #125:$indhead=$indhead."/".substr(trim($egy_sor[ar_nev])." ",0,20);
Line #126://echo ($sl."*".$indhead.'<hr>');
Line #127://if ($sl==0)
Line #128://echo ("HIBA:".$egy_sor[wid]."/".$egy_sor[statusz]."/".$egy_sor[bizomanyos]."/".$egy_sor[ar]."/".$egy_sor[logtime]."<hr>");
Line #129:
Line #130:}
Line #131://else
Line #132://echo ("HIBA:".$egy_sor[wid]."/".$egy_sor[statusz].$egy_sor[ar]."/".$egy_sor[logtime]);
Line #133:
Line #134:$apoz=strpos($indhead,$egy_sor[ar_nev]);
Line #135:
Line #136://///////// SI ///////
Line #137://if ($ARkatind[$egy_sor[arkategoria]]>0) $egy_sor[arkategoria]=$ARkatind[$egy_sor[arkategoria]]; else $egy_sor[arkategoria]=9;
Line #138:
Line #139:$ind=$egy_sor[arkategoria]+$si*10+intval($apoz/21)*100;
Line #140:
Line #141://if ($egy_sor[arkategoria]<1 or $egy_sor[arkategoria]>3)
Line #142://echo ($ind."HIBA:".$egy_sor[wid]."/".$egy_sor[statusz]."/".$egy_sor[bizomanyos]."/".$egy_sor[ar]."/".$egy_sor[logtime]."<hr>");
Line #143:
Line #144:if ($Katimax<$egy_sor[arkategoria]) $Katimax<$egy_sor[arkategoria];
Line #145:
Line #146:if (!isset($sumdb[$ind])) {
Line #147://echo ($Katimax."/".$ind.'<hr>');
Line #148: $sumft[$ind]=$egy_sor[ar];
Line #149: $sumdb[$ind]=1;
Line #150: $sumear[$ind]=$egy_sor[ar];
Line #151:} else {
Line #152: $sumft[$ind]=$sumft[$ind]+$egy_sor[ar];
Line #153: ++$sumdb[$ind];
Line #154:}
Line #155:
Line #156:
Line #157:
Line #158:if ($i==0) {
Line #159:
Line #160:$i=1;
Line #161:
Line #162:$rmuv1=$statusz;
Line #163:
Line #164:if (isset($_SESSION[CALL_KOD]) and isset($_GET[musor_kod])){
Line #165:$keres = "SELECT * FROM qj_musor where datum_kod='".$_SESSION[CALL_KOD]."'";
Line #166:
Line #167:
Line #168:$nur=mysql_num_rows($meredmeny);
Line #169:$musor=mysql_fetch_array($meredmeny);
Line #170:$HEAD=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim];
Line #171:
Line #172:} else $HEAD="";
Line #173:
Line #174:
Line #175:$L_NAP=$HEAD;
Line #176:
Line #177:$L_PHP="QJ_raportKATEGORIAK.php?&musor_kod=".$_GET[musor_kod];
Line #178:include("QJ_listafej.php");
Line #179:
Line #180:}
Line #181:}
Line #182:
Line #183:echo "<table border=1>
Line #184:<tr bgcolor=silver>
Line #185:
Line #186:
Line #187:
Line #188:
Line #189:
Line #190:
Line #191:</tr>
Line #192:<tr bgcolor=silver>
Line #193:
Line #194:<td align=right >Db</td>
Line #195:
Line #196:
Line #197:
Line #198:<td align=right >Db</td>
Line #199:
Line #200:
Line #201:
Line #202:<td align=right >Db</td>
Line #203:
Line #204:
Line #205:
Line #206:<td align=right >Db</td>
Line #207:
Line #208:
Line #209:
Line #210:<td align=right >Db</td>
Line #211:
Line #212:
Line #213:
Line #214:</tr>";
Line #215:
Line #216:
Line #217:
Line #218:$indmax=intval(strlen($indhead)/21)*100+100;
Line #219:$osdb=0;
Line #220:$osft=0;
Line #221:for ($i=0;$i<$indmax+1;$i++) {
Line #222:
Line #223:$osdb=$osdb+$sumdb[$i];
Line #224:$osft=$osft+$sumft[$i];
Line #225:$os=$sumdb[$i]*$sumear[$i];
Line #226:
Line #227:if (isset($sumdb[$i])) {
Line #228://echo "
Line #229://<tr>
Line #230://<td align=right >$i</td>
Line #231://<td align=right >$sumdb[$i]</td>
Line #232://<td align=right >$sumear[$i]</td>
Line #233://<td align=right >$sumft[$i]</td>
Line #234://</tr>
Line #235://";
Line #236:
Line #237:}
Line #238:}
Line #239:
Line #240:
Line #241:if ($osdb>0) $atlagar=intval($osft/$osdb); else $atlagar=0;
Line #242:
Line #243://echo "
Line #244://<tr>
Line #245:
Line #246://<td align=right >$osdb</td>
Line #247://<td align=right >$atlagar</td>
Line #248://<td align=right >$osft</td>
Line #249://</tr>
Line #250://";
Line #251:
Line #252://$Katimax=$indmax;
Line #253:
Line #254:$indmax=intval(strlen($indhead)/21)+1;
Line #255:
Line #256:$rosdb=0;
Line #257:$rosft=0;
Line #258:$osdb=0;
Line #259:$osft=0;
Line #260:
Line #261:$kosdb=0;
Line #262:$kosft=0;
Line #263:
Line #264:$katir="";
Line #265:
Line #266:$arosdb[0]=0;
Line #267:$arosft[0]=0;
Line #268:
Line #269:$arosdb[1]=0;
Line #270:$arosft[1]=0;
Line #271:$arosdb[2]=0;
Line #272:$arosft[2]=0;
Line #273:$arosdb[3]=0;
Line #274:$arosft[3]=0;
Line #275:
Line #276:$arosdb[4]=0;
Line #277:$arosft[4]=0;
Line #278:
Line #279:$marosdb[0]=0;
Line #280:$marosft[0]=0;
Line #281:$marosdb[1]=0;
Line #282:$marosft[1]=0;
Line #283:$marosdb[2]=0;
Line #284:$marosft[2]=0;
Line #285:$marosdb[3]=0;
Line #286:$marosft[3]=0;
Line #287:$marosdb[4]=0;
Line #288:$marosft[4]=0;
Line #289:
Line #290:
Line #291:for ($i=0;$i<$indmax;$i++) {
Line #292:
Line #293: $os=$sumdb[$i]*$sumear[$i];
Line #294: $ros=$sumdb[$i]*$sumear[$i];
Line #295: $kos=$sumdb[$i]*$sumear[$i];
Line #296:
Line #297: for ($j=0;$j<10;$j++) {
Line #298:
Line #299: for ($k=1;$k<5;$k++) {
Line #300:
Line #301: $ind=$i*100+$j*10+$k;
Line #302:
Line #303: if (isset($sumdb[$ind])) {
Line #304:
Line #305:
Line #306: $kosdb=$kosdb+$sumdb[$ind];
Line #307: $kosft=$kosft+$sumft[$ind];
Line #308:
Line #309: $arosdb[$k]=$arosdb[$k]+$sumdb[$ind];
Line #310: $arosft[$k]=$arosft[$k]+$sumft[$ind];
Line #311: $arosdb[0]=$arosdb[0]+$sumdb[$ind];
Line #312: $arosft[0]=$arosft[0]+$sumft[$ind];
Line #313:
Line #314: $marosdb[$k]=$marosdb[$k]+$sumdb[$ind];
Line #315: $marosft[$k]=$marosft[$k]+$sumft[$ind];
Line #316: $marosdb[0]=$marosdb[0]+$sumdb[$ind];
Line #317: $marosft[0]=$marosft[0]+$sumft[$ind];
Line #318:
Line #319:
Line #320: $rosdb=$rosdb+$sumdb[$ind];
Line #321: $rosft=$rosft+$sumft[$ind];
Line #322:
Line #323:
Line #324: $osdb=$osdb+$sumdb[$ind];
Line #325: $osft=$osft+$sumft[$ind];
Line #326:
Line #327: $katir.="
Line #328: <td align=right >".number_format($sumdb[$ind])."</td>
Line #329: <td align=right >".number_format($sumear[$ind])."</td>
Line #330: <td align=right >".number_format($sumft[$ind])."</td>
Line #331: ";
Line #332: } else {
Line #333: $katir.="
Line #334: <td align=right > </td>
Line #335: <td align=right > </td>
Line #336: <td align=right > </td>
Line #337: ";
Line #338:
Line #339: }
Line #340:
Line #341: }
Line #342:
Line #343: $ind=$i*10+$j;
Line #344:
Line #345: if ($kosdb>0) $atlagar=intval($kosft/$kosdb); else $atlagar=0;
Line #346:
Line #347: if ($kosft==0) {$arnev=substr($indhead,$i*21+1,20); $bcolor=" bgcolor=yellow";}
Line #348: else {$arnev=$fmod[$j]; $bcolor=""; }
Line #349:
Line #350: $katir="<tr $bcolor>
Line #351: <td align=right >$arnev:</td>
Line #352: <td align=right >".number_format($kosdb)."</td>
Line #353: <td align=right >".number_format($atlagar)."</td>
Line #354: <td align=right >".number_format($kosft)."</td>
Line #355: ".$katir."</tr>";
Line #356:
Line #357:
Line #358:
Line #359: $katir="";
Line #360: $kosdb=0;
Line #361: $kosft=0;
Line #362:
Line #363: }
Line #364:
Line #365:if($arosft[0]>0) {
Line #366:
Line #367:$arnev=substr($indhead,$i*21+1,20);
Line #368:
Line #369: echo("<tr bgcolor=yellow>
Line #370: <td align=right >$arnev:</td>
Line #371: ");
Line #372: for ($k=0;$k<5;$k++) {
Line #373:
Line #374: if ($arosdb[$k]>0) $atlagar=intval($arosft[$k]/$arosdb[$k]); else $atlagar=0;
Line #375: echo("
Line #376: <td align=right >".number_format($arosdb[$k])."</td>
Line #377: <td align=right >".number_format($atlagar)."</td>
Line #378: <td align=right >".number_format($arosft[$k])."</td>");
Line #379:
Line #380: }
Line #381:
Line #382: echo("</tr>");
Line #383:
Line #384: echo("<tr><td colspan=16> </td></tr>");
Line #385:
Line #386:}
Line #387: $arosdb[0]=0;
Line #388: $arosft[0]=0;
Line #389: $arosdb[1]=0;
Line #390: $arosft[1]=0;
Line #391:$arosdb[2]=0;
Line #392:$arosft[2]=0;
Line #393:$arosdb[3]=0;
Line #394:$arosft[3]=0;
Line #395:$arosdb[4]=0;
Line #396:$arosft[4]=0;
Line #397:
Line #398:
Line #399:}
Line #400:
Line #401:
Line #402: echo("<tr bgcolor=gold>
Line #403:
Line #404: ");
Line #405: for ($k=0;$k<5;$k++) {
Line #406:
Line #407: if ($marosdb[$k]>0) $atlagar=intval($marosft[$k]/$marosdb[$k]); else $atlagar=0;
Line #408:
Line #409: echo("
Line #410: <td align=right >".number_format($marosdb[$k])."</td>
Line #411: <td align=right >".number_format($atlagar)."</td>
Line #412: <td align=right >".number_format($marosft[$k])."</td>");
Line #413:
Line #414: }
Line #415:
Line #416: echo("</tr>");
Line #417:
Line #418:echo "
Line #419:</table>";
Line #420:
Line #421:if (isset($_SESSION[bwinclosed])) echo("<hr>SUMft:".$closedFT." / DB:".$closedDB);
Line #422:
Line #423:if (isset($_GET[nyomtat])) {
Line #424:include("QJ_listaveg.php");
Line #425:
Line #426:echo("<body onload='printit()'></body>");
Line #427:
Line #428:?>
Line #429:<SCRIPT Language="Javascript">
Line #430:
Line #431:function printit(){
Line #432:
Line #433:
Line #434:window.print();
Line #435:///////////////////////////////////////
Line #436:window.open("QJ_gyujto.php?&lista=1", 'sframe');
Line #437:///////////////////////////////////////
Line #438:
Line #439:}
Line #440:</script>
Line #441:<?PHP
Line #442:}
Line #443://~*~// QJ_katraport.php
Line #444:?>