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