QJ_musorRAPORT_MK.inc

---

Line #0:<?php
Line #1:
Line #2:if (isset($_GET[nyomtat])) {
Line #3:?>
Line #4:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #5:<?PHP
Line #6:$keres=$_SESSION[musorRAPORT_SQL];
Line #7:
Line #8:} else {
Line #9:unset($_SESSION[musorRAPORT_SQL]);
Line #10:
Line #11:
Line #12:$sum_osft=0;
Line #13:$sum_osdb=0;
Line #14:$sum_ertdb=0;
Line #15:$sum_elodb=0;
Line #16:$sum_uresdb=0;
Line #17:$sum_csopdb=0;
Line #18:$sum_potdb=0;
Line #19:$sum_nulldb=0;
Line #20:$ir="<table border=1>";
Line #21:
Line #22:IF (isset($_POST[ujho])) $_SESSION[musor_ujho]=$_POST[ujho];
Line #23:IF (isset($_SESSION[musor_ujho])) $_POST[ujho]=$_SESSION[musor_ujho];
Line #24:
Line #25:IF (isset($_POST[ujevho])) $_SESSION[musor_ujevho]=$_POST[ujevho];
Line #26:IF (isset($_SESSION[musor_ujevho])) $_POST[ujevho]=$_SESSION[musor_ujevho];
Line #27:
Line #28:IF (isset($_POST[sorrend])) $_SESSION[musorrend]=$_POST[sorrend];
Line #29:IF (isset($_SESSION[musorrend])) $_POST[sorrend]=$_SESSION[musorrend];
Line #30:
Line #31:IF (isset($_POST[helyszin])) $_SESSION[hely_nev]=$_POST[helyszin];
Line #32:IF (isset($_SESSION[hely_nev])) $_POST[helyszin]=$_SESSION[hely_nev];
Line #33:
Line #34:IF (isset($_POST[Rhonap])) $_SESSION[Rhonap]=$_POST[Rhonap];
Line #35:IF (isset($_SESSION[Rhonap])) $_POST[Rhonap]=$_SESSION[Rhonap];
Line #36:
Line #37:
Line #38:$formcall="QJ_musorRAPORT.php";
Line #39:////////////////////////////////////////include("BI_musorFILTER.php");
Line #40:
Line #41:$es="";
Line #42:$ha=" where ";
Line #43:$ha="";
Line #44:$wer="";
Line #45:
Line #46:if (isset($_POST[cim]) and $_POST[cim]<>"*") {
Line #47:$wer=$ha." cim='".$_POST[cim]."'" ;
Line #48:$es=" AND ";
Line #49:$ha="";
Line #50:}
Line #51:
Line #52:if (isset($_POST[helyszin]) and $_POST[helyszin]<>"*") {
Line #53:$wer.= $ha. $es. " helyszin='".$_POST[helyszin]."'";
Line #54:$es=" AND ";
Line #55:$ha="";
Line #56:}
Line #57:
Line #58:if (isset($_POST[datum_fej]) and $_POST[datum_fej]<>"*") {
Line #59:$wer.= $ha. $es. " datum_fej='".$_POST[datum_fej]."'";
Line #60:$es=" AND ";
Line #61:$ha="";
Line #62:}
Line #63:
Line #64:if (isset($_POST[Rhonap]) and $_POST[Rhonap]<>"*") {
Line #65:$wer.= $ha. $es. " datum_evho='".$_POST[Rhonap]."'";
Line #66:$es=" AND ";
Line #67:$ha="";
Line #68:}
Line #69:
Line #70:$wer.=$es;
Line #71:
Line #72:$disQ = "SELECT distinct cim FROM qj_musor order by cim" ;
Line #73:
Line #74:
Line #75:$sel1="&nbsp;&nbsp;<SELECT TITLE='cim'
Line #76:onchange=this.form.submit(); return true name='cim'>";
Line #77:
Line #78:
Line #79:
Line #80:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #81:if ($disC[cim]==$_POST[cim]) $sel="SELECTED"; else $sel="";
Line #82:if (trim($disC[cim])<>"")
Line #83:$sel1.="<option value='".$disC[cim]."' $sel >".$disC[cim]."</option>";
Line #84:}
Line #85:
Line #86:$sel1.="</SELECT>";
Line #87:
Line #88:
Line #89:$disQ = "SELECT distinct helyszin FROM qj_musor order by helyszin" ;
Line #90:
Line #91:
Line #92:
Line #93:onchange=this.form.submit(); return true name='helyszin'>";
Line #94:
Line #95:
Line #96:
Line #97:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #98:if ($disC[helyszin]==$_POST[helyszin]) $sel="SELECTED"; else $sel="";
Line #99:if (trim($disC[helyszin])<>"")
Line #100:$sel2.="<option value='".$disC[helyszin]."' $sel >".$disC[helyszin]."</option>";
Line #101:}
Line #102:
Line #103:$sel2.="</SELECT>";
Line #104:
Line #105:$disQ = "SELECT distinct datum_fej FROM qj_musor order by datum_fej" ;
Line #106:
Line #107:
Line #108:$sel3="&nbsp;&nbsp;<SELECT TITLE='Nap'
Line #109:onchange=this.form.submit(); return true name='datum_fej'>";
Line #110:
Line #111:
Line #112:
Line #113:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #114:if ($disC[datum_fej]==$_POST[datum_fej]) $sel="SELECTED"; else $sel="";
Line #115:if (trim($disC[datum_fej])<>"")
Line #116:$sel3.="<option value='".$disC[datum_fej]."' $sel >".$disC[datum_fej]."</option>";
Line #117:}
Line #118:
Line #119:$sel3.="</SELECT>";
Line #120://///////////////////////////
Line #121:
Line #122:$disQ = "SELECT distinct datum_evho as datum FROM qj_musor order by datum_evho " ;
Line #123:
Line #124:
Line #125:
Line #126:onchange=this.form.submit(); return true name='Rhonap'>";
Line #127:
Line #128:
Line #129:
Line #130:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #131:
Line #132:$datum=$disC[datum];
Line #133:
Line #134:if ($datum==$_POST[Rhonap]) $sel="SELECTED"; else $sel="";
Line #135:if (trim($datum)<>"")
Line #136:$sel4.="<option value='".$datum."' $sel >".$datum."</option>";
Line #137:}
Line #138:
Line #139:$sel4.="</SELECT>";
Line #140:
Line #141:///////////////////////////////////
Line #142:
Line #143:$sql="SELECT * FROM qj_sql where szoveg='musor_ord' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #144:
Line #145:$psor = mysql_fetch_array( $sqlpar );
Line #146:$fid=$psor[sql_memo];
Line #147:$h=split(':',$fid);
Line #148:$nORD=count($h)-1;
Line #149:
Line #150:if (!isset($_POST[sorrend])) $_POST[sorrend]=$h[0];
Line #151:$ord=" order by ".$_POST[sorrend];
Line #152:
Line #153:$sel5="&nbsp;&nbsp;<b>Sorrend:</b><SELECT TITLE='Sorrend'
Line #154:onchange=this.form.submit(); return true name='sorrend'>";
Line #155:
Line #156:for ($i=0;$i<$nORD;$i++) {
Line #157:
Line #158:if ($h[$i]==$_POST[sorrend]) $sel="SELECTED"; else $sel="";
Line #159:$sel5.="<option value='".$h[$i]."' $sel >".$h[$i]."</option>";
Line #160:}
Line #161:
Line #162:$sel5.="</SELECT>";
Line #163:
Line #164:
Line #165:$selBI="
Line #166:
Line #167:
Line #168:
Line #169:href='QJ_sqlJEGY.php?&parancs=// Update qj_musor set archive=~*~' target=infoframe ><IMG width=20 height=20
Line #170: SRC='../_Screen/drop.png' border=0></a>
Line #171:";
Line #172:
Line #173:?>
Line #174:
Line #175:<FORM name=cimform target=sframe action='<?echo($formcall);?>' method='post'>
Line #176:
Line #177:onchange=this.form.submit(); return true name='Korr'>
Line #178:<? echo($sel4); echo($sel1); echo($sel2); ?>
Line #179:<? if ($_SESSION[login]=="BI(c)") echo($sel5.$selBI); ?>
Line #180:</form>
Line #181:
Line #182:<?
Line #183:
Line #184:
Line #185:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #186:
Line #187:$archiv=" future <>'*'";
Line #188:$login=$_SESSION[login];
Line #189:
Line #190:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB $ord ";
Line #191:
Line #192:$_SESSION[musorRAPORT_SQL]=$keres;
Line #193:}
Line #194:
Line #195:
Line #196:$L_PHP="QJ_musorRAPORT.php";
Line #197:include("QJ_listafej.php");
Line #198:
Line #199:// echo($keres."<hr>");
Line #200:
Line #201:
Line #202:$nur=mysql_num_rows($eredmeny);
Line #203:
Line #204:
Line #205:echo "<table border=1 width=100% >
Line #206:<tr bgcolor=silver>
Line #207:
Line #208:
Line #209:
Line #210:<td width=60 align=right ><b>Ft</td>
Line #211:<td width=40 align=right ><b>Db</td>
Line #212:</tr>";
Line #213:
Line #214:$i=0;
Line #215:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #216:{
Line #217:++$i;
Line #218:
Line #219:$helyszin_kod=$musor[hely_kod];
Line #220:$datum_kod=$musor[datum_kod];
Line #221:$cim_kod=$musor[cim_kod];
Line #222:$cim_url=$musor[cim_url];
Line #223:$kep_url=$musor[kep_url];
Line #224:$wjid=$musor[wid];
Line #225:if ($musor[archiv]=="*") $rejtett="<br><font color=red size=+2>Rejtett</font>"; else $rejtett="";
Line #226:
Line #227:
Line #228://$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #229://and not $_SESSION[SQL_inet] and ar>0 ORDER BY vevo_kod";
Line #230: ////////
Line #231:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and archiv='-'
Line #232:and not $_SESSION[SQL_inet] ORDER BY vevo_kod";
Line #233:
Line #234:$SQLszek = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."'
Line #235:and not $_SESSION[SQL_inet] ORDER BY vevo_kod";
Line #236:
Line #237:
Line #238:
Line #239:
Line #240:$nur=mysql_num_rows($szekek);
Line #241:$osft=0;
Line #242:$ertdb=0;
Line #243:$elodb=0;
Line #244:$uresdb=0;
Line #245:$csopdb=0;
Line #246:$potdb=0;
Line #247:$nulldb=0;
Line #248:$vevo_kod=0;
Line #249:$csoportjel="N";
Line #250:
Line #251:while ( $jegysor = mysql_fetch_array( $szekek ))
Line #252:{
Line #253:
Line #254:
Line #255:if ($vevo_kod<>$jegysor[vevo_kod]) {
Line #256: $vevo_kod=$jegysor[vevo_kod];
Line #257: $cimSQL = "SELECT * FROM qj_cimtar WHERE wid='".$vevo_kod."'";
Line #258:
Line #259:
Line #260: $cimsor = mysql_fetch_array($cimrec);
Line #261: $row =mysql_fetch_row($cimrec);
Line #262:
Line #263:
Line #264: if (substr($cimsor[csoport_kod],0,2)=="##") $csoportjel="Y"; else $csoportjel="N";
Line #265:
Line #266://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 #267:
Line #268:
Line #269:}
Line #270:
Line #271:$statusz=substr($jegysor[statusz],0,2);
Line #272:
Line #273:if ($statusz<>'' and $statusz<>'El' and $statusz<>'St' and $statusz<>'In') {
Line #274: $osft=$osft+$jegysor[ar];
Line #275: ++$ertdb;
Line #276:
Line #277: //$ir.="<tr><td>$jegysor[wid]</td><td>$jegysor[datum_kod]</td><td>$jegysor[ar]</td><td>$jegysor[statusz]</td></tr>";
Line #278:
Line #279: if ($jegysor[ar]==0) ++$nulldb;
Line #280:
Line #281:} elseif ($statusz=='El' and $csoportjel=="N") ++$elodb;
Line #282: elseif (($statusz=='El' or $statusz=='In') and $csoportjel=="Y") ++$csopdb;
Line #283: else ++$uresdb;
Line #284:}
Line #285:
Line #286:$cimkieg="";
Line #287:if($musor[cimkieg1]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg1]."</i>";
Line #288:if($musor[cimkieg2]<>" " ) $cimkieg.="<br><i>".$musor[cimkieg2]."</i>";
Line #289:
Line #290:
Line #291:IF ($nur==0) $erkezesi="<BR><b>Nincs megnyitva!</b>";
Line #292:
Line #293://if ($login=="BI(c)") $edit="<a href=BI_ediTable.php?&wjid=$wjid&sqlfile=qj_musor>"; else $edit="<a>";
Line #294:
Line #295:
Line #296: target=adatframe >";
Line #297:
Line #298:
Line #299: target=adatframe ><IMG width=20 height=20
Line #300: SRC='../_Screen/datum.gif' border=0></a>";
Line #301:
Line #302:
Line #303:<IMG width=20 height=20
Line #304:SRC='../_Screen/people.bmp' border=0></a>";
Line #305:$bref="";
Line #306:
Line #307:$cref="<a href=QJ_raportNEW.php?&musor_kod=$datum_kod title='Raport lap' target=adatframe>
Line #308:<IMG width=20 height=20
Line #309:SRC='../_Screen/transfer.gif' border=0></a>";
Line #310:
Line #311:
Line #312:<IMG width=20 height=20
Line #313:SRC='../_Screen/tsticky.gif' border=0></a>";
Line #314:
Line #315:
Line #316:
Line #317:href='QJ_vevoXLSlist.php?&musor_kod=$datum_kod' >
Line #318:
Line #319:
Line #320:
Line #321:if ($_SESSION[login]=="BI(c)")
Line #322:$copys="<a target=adatframe
Line #323:href='QJ_musorCOPY.php?&wjid=$wjid' >
Line #324:
Line #325: SRC='../_Screen/transfer.png' border=0></a>";
Line #326:else $copys="";
Line #327:
Line #328:
Line #329:$copys="<a target=adatframe
Line #330:href='QJ_musorSZIGORlista.php?&musor_kod=$datum_kod' >
Line #331:
Line #332: SRC='../_Screen/transfer.png' border=0></a>";
Line #333:
Line #334:
Line #335:
Line #336:
Line #337:else $ma="";
Line #338:
Line #339:
Line #340:if (!isset($_GET[nyomtat]))
Line #341:$medi="<a href=QJ_musorPUBLIC.php?&wjid=$wjid
Line #342: target=adatframe><b>$musor[cim]</b>
Line #343:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0>
Line #344: </a>".$ma.$cimkieg. $erkezesi; else $medi="<b>$musor[cim]</b>".$ma.$cimkieg. $erkezesi;;
Line #345:
Line #346:
Line #347:echo"<tr>
Line #348:<td align=center ><b>
Line #349: $edit$datum_kod</a>
Line #350: </b><br>
Line #351:$cref
Line #352:$aref
Line #353:$bref
Line #354:$dref
Line #355:$copys
Line #356: </td>
Line #357:<td align=right >$musor[datum]<BR>
Line #358:$musor[helyszin]
Line #359:</td>
Line #360:<td align=right >
Line #361:
Line #362:$medi
Line #363: $rejtett
Line #364:
Line #365: </td>
Line #366:<td align=right bgcolor=gold ><font color=red><b>".number_format($osft)."</b></font></td>
Line #367:<td align=right bgcolor=gold><B>".number_format($ertdb)."</B></td>
Line #368:</tr>";
Line #369:
Line #370:$sum_ertdb=$sum_ertdb +$ertdb;
Line #371:$sum_osft=$sum_osft+$osft;
Line #372:
Line #373:}
Line #374:
Line #375:
Line #376:echo "<tr bgcolor=silver>
Line #377:<td colspan=3 align=right ><b>
Line #378:
Line #379:</b></td>
Line #380:<td align=right ><b>".number_format($sum_osft)."</b></td>
Line #381:<td align=right ><b>".number_format($sum_ertdb). "</B></td></tr>";
Line #382:
Line #383:echo "</table>";
Line #384:
Line #385:if (isset($_GET[nyomtat])) {
Line #386:include("QJ_listaveg.php");
Line #387:
Line #388:echo("<body onload='printit()'></body>");
Line #389:
Line #390:?>
Line #391:<SCRIPT Language="Javascript">
Line #392:
Line #393:function printit(){
Line #394:
Line #395:
Line #396:window.print();
Line #397:///////////////////////////////////////
Line #398://window.open("QJ_felad.php", 'sframe');
Line #399:///////////////////////////////////////
Line #400://window.open("QJ_gyujto.php", 'sframe');
Line #401:
Line #402:}
Line #403:</script>
Line #404:<?PHP
Line #405:}
Line #406:
Line #407://~*~// QJ_napi.php
Line #408:?>
Line #409:
Line #410: