Bi-Dir

QJ_napiNEWraport.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:$L_PHP="QJ_napiNEWraport.php";
Line #4:
Line #5:if (isset($_GET[musor_kod])) $_SESSION[SUBmusor_kod]=$_GET[musor_kod];
Line #6: else $_GET[musor_kod]=$_SESSION[SUBmusor_kod];
Line #7:
Line #8:$wer="";
Line #9:
Line #10:if (isset($_GET[nyomtat])) {
Line #11:?>
Line #12:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #13:<?PHP
Line #14:} else {
Line #15:
Line #16:include("../_inc_QJ/QJ_adoSELECT.inc");
Line #17:
Line #18:}
Line #19:
Line #20:
Line #21:
Line #22:////
Line #23:$login=$_SESSION['login'];
Line #24:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #25:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #26:////
Line #27:
Line #28://include("gvarlist.php");
Line #29:$wer="";
Line #30:
Line #31:IF (isset($_SESSION[bwinbizo])) {
Line #32: IF ($_SESSION[bwinbizomanyos]<>"*")
Line #33: $wer=" and bizomanyos='".$_SESSION[bwinbizomanyos]."'";
Line #34:
Line #35:}
Line #36:
Line #37:
Line #38:$szin="";
Line #39:$i=0;
Line #40:$ft=0;
Line #41:$nap="?";
Line #42:$ri=0;
Line #43:$rft=0;
Line #44:$rmuv="?";
Line #45:
Line #46:$wi=0;
Line #47:$wft=0;
Line #48:$rlog="?";
Line #49:$hiba="";
Line #50:
Line #51:$kpdb=0;
Line #52:$kpft=0;
Line #53:$badb=0;
Line #54:$baft=0;
Line #55:
Line #56:$bondb=0;
Line #57:$bonft=0;
Line #58:
Line #59:
Line #60:$keres = "SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."' ";
Line #61:
Line #62:
Line #63:$musor=mysql_fetch_array($meredmeny);
Line #64://$L_NAP=$musor[helyszin]." ".$musor[datum]." ".$musor[cim];
Line #65:if (substr($musor[datum_fej],0,1)=="B")
Line #66:$L_NAP=$musor[helyszin]." ".$musor[cim]." ".$musor[datum]."";
Line #67:else
Line #68:$L_NAP=$musor[helyszin]." ".$musor[datum]." ".$musor[cim];
Line #69://$L_NAP=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim]." ".$musor[datum];
Line #70:
Line #71:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #72:
Line #73:IF ($musor[berlet_nev]<>"") $BERLETNEV=" ".$musor[berlet_nev].""; ELSE $BERLETNEV="";
Line #74:
Line #75://$L_cim=" RAPORT LAP".$osszesen;
Line #76:$L_cim=" RAPORT LAP".$osszesen.$_SESSION[SUBlista].$BERLETNEV;
Line #77:
Line #78:include("QJ_listafej.php");
Line #79:
Line #80:echo "<table border=1>
Line #81:<tr bgcolor=silver>
Line #82:
Line #83:
Line #84:<td colspan=3 align=center >Bank</td>";
Line #85:
Line #86:
Line #87:echo "
Line #88:
Line #89:else
Line #90:echo "
Line #91:
Line #92:
Line #93:
Line #94:echo "</tr>";
Line #95:
Line #96:echo "
Line #97:<tr bgcolor=silver>
Line #98:
Line #99:<td align=center >Darab</td>
Line #100:
Line #101:
Line #102:<td align=center >Darab</td>
Line #103:
Line #104:
Line #105:<td align=center >Darab</td>
Line #106:
Line #107:
Line #108:
Line #109:echo "
Line #110:
Line #111:<td align=center >Darab</td>
Line #112:
Line #113:
Line #114:echo "</tr>";
Line #115:
Line #116:
Line #117://$parancs="SELECT * FROM qj_jegy where left(logtime,10)='$Pnap' and bizomanyos='$login' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY statusz,logtime";
Line #118:
Line #119://$parancs="SELECT * FROM qj_jegy where left(statusz,2)<>'El' and left(statusz,2)<>'St' and left(statusz,1)<>' ' $wer1 $wer2 ORDER BY statusz,logtime";
Line #120:
Line #121://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #122:
Line #123:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #124:
Line #125:$bh="";
Line #126:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $bh and datum_kod='".$_GET[musor_kod]."' $wer $_SESSION[SUBwer] ORDER BY ar,ar_nev,statusz";
Line #127:
Line #128:
Line #129:$jegySEL="";
Line #130:IF (isset($_SESSION[RendezoSZ]) and $_SESSION[RendezoSZ]=="*")
Line #131:$jegySEL= " and left(logtime,10)='".$_POST[kezdIDO]."' ";
Line #132:$jegySEL= str_replace(".","-",$jegySEL);
Line #133:
Line #134:
Line #135:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $jegySEL $_SESSION[Datum_Ado] ORDER BY ar,ar_nev,statusz";
Line #136:
Line #137://?//
Line #138:echo ($parancs."<hr>");
Line #139:
Line #140:
Line #141:
Line #142:
Line #143:$i=0;
Line #144:$szin='white';
Line #145:$bh="";
Line #146:
Line #147:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #148:{
Line #149:
Line #150:if ($i==0) {
Line #151: $rdatum=$egy_sor[datum_kod];
Line #152: $nap=substr($egy_sor[logtime],0,10);
Line #153: $rar=$egy_sor[ar];
Line #154: $rar_nev=trim($egy_sor[ar_nev]);
Line #155: $rmuv=$egy_sor[statusz];
Line #156: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #157:}
Line #158:
Line #159:$ref="";
Line #160:if ($rdatum<>$egy_sor[datum_kod] or
Line #161: $rar_nev<>trim($egy_sor[ar_nev]) or
Line #162: $rar<>$egy_sor[ar] or
Line #163: $rmuv<>$egy_sor[statusz]){
Line #164:
Line #165:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #166:
Line #167:
Line #168:$musor = mysql_fetch_array( $eredmeny3 );
Line #169:
Line #170:$h=$musor[helyszin];
Line #171:$c=$egy_sor[cim];
Line #172:$d=$egy_sor[datum];
Line #173:$wjid=$egy_sor[wid];
Line #174:
Line #175:$FormaJel=$egy_sor[FormaJel];
Line #176:$JeBe=$egy_sor[JeBe];
Line #177:
Line #178:
Line #179:
Line #180:
Line #181: $bondb=$bondb+$ri;
Line #182: $bonft=$bonft+$rft;
Line #183: $tab1="<td colspan=9>&nbsp</td>";
Line #184:
Line #185:echo"<tr>
Line #186:
Line #187:<td align=right bgcolor=$szin > $rar_nev</td>
Line #188:$tab1
Line #189:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #190:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #191:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #192:</tr>";
Line #193:
Line #194:
Line #195:} else {
Line #196:
Line #197:
Line #198: $tab1="";
Line #199: $tab2="<td colspan=3>&nbsp</td>";
Line #200: $kpdb=$kpdb+$ri;
Line #201: $kpft=$kpft+$rft;
Line #202: } else {
Line #203: $tab1="<td colspan=3>&nbsp</td>";
Line #204: $tab2="";
Line #205: $badb=$badb+$ri;
Line #206: $baft=$baft+$rft;
Line #207: }
Line #208:
Line #209:
Line #210:
Line #211:echo"<tr>
Line #212:
Line #213:<td align=right bgcolor=$szin > $rar_nev</td>
Line #214:$tab1
Line #215:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #216:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #217:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #218:$tab2
Line #219:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #220:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #221:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #222:
Line #223:</tr>";
Line #224:
Line #225:}
Line #226:
Line #227:$ri=0;
Line #228:$rft=0;
Line #229:
Line #230:
Line #231:}
Line #232:
Line #233: $rdatum=$egy_sor[datum_kod];
Line #234: $nap=substr($egy_sor[logtime],0,10);
Line #235: $rar=$egy_sor[ar];
Line #236: $rar_nev=trim($egy_sor[ar_nev]);
Line #237: $rmuv=$egy_sor[statusz];
Line #238: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #239:
Line #240:
Line #241:++$i;
Line #242:++$ri;
Line #243:$rft=$rft+$egy_sor[ar];
Line #244:$ft =$ft+$egy_sor[ar];
Line #245:++$wi;
Line #246:$wft=$wft+$egy_sor[ar];
Line #247:
Line #248:
Line #249:
Line #250:}
Line #251:
Line #252:
Line #253:
Line #254:
Line #255:
Line #256:
Line #257:
Line #258:
Line #259: $bondb=$bondb+$ri;
Line #260: $bonft=$bonft+$rft;
Line #261: $tab1="<td colspan=9>&nbsp</td>";
Line #262:
Line #263:echo"<tr>
Line #264:
Line #265:<td align=right bgcolor=$szin > $rar_nev</td>
Line #266:$tab1
Line #267:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #268:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #269:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #270:</tr>";
Line #271:
Line #272:} else {
Line #273:
Line #274:
Line #275: $tab1="";
Line #276: $tab2="<td colspan=3>&nbsp</td>";
Line #277: $kpdb=$kpdb+$ri;
Line #278: $kpft=$kpft+$rft;
Line #279: } else {
Line #280: $tab1="<td colspan=3>&nbsp</td>";
Line #281: $tab2="";
Line #282: $badb=$badb+$ri;
Line #283: $baft=$baft+$rft;
Line #284: }
Line #285:
Line #286:echo"<tr>
Line #287:
Line #288:<td align=right bgcolor=$szin > $rar_nev</td>
Line #289:$tab1
Line #290:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #291:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #292:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #293:$tab2
Line #294:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #295:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #296:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #297:</tr>";
Line #298:
Line #299:
Line #300:}
Line #301:
Line #302:
Line #303:$szin="silver";
Line #304:
Line #305:
Line #306:echo"<tr>
Line #307:
Line #308:
Line #309:<td align=right bgcolor=$szin > </td>
Line #310:<td align=right bgcolor=$szin >".number_format($kpdb)."</td>
Line #311:<td align=right bgcolor=$szin >".number_format($kpft)."</td>
Line #312:<td align=right bgcolor=$szin > </td>
Line #313:<td align=right bgcolor=$szin >".number_format($badb)."</td>
Line #314:<td align=right bgcolor=$szin >".number_format($baft)."</td>
Line #315:<td align=right bgcolor=$szin > </td>
Line #316:<td align=right bgcolor=$szin >".number_format($kpdb+$badb)."</td>
Line #317:<td align=right bgcolor=$szin >".number_format($kpft+$baft)."</td>";
Line #318:
Line #319:
Line #320:echo"
Line #321:<td align=right bgcolor=$szin > </td>
Line #322:<td align=right bgcolor=$szin >".number_format($bondb)."</td>
Line #323:<td align=right bgcolor=$szin >".number_format($bonft)."</td>";
Line #324:
Line #325:echo"</tr>";
Line #326:
Line #327:
Line #328:echo"</table>";
Line #329:
Line #330:
Line #331:if (isset($_GET[nyomtat])) {
Line #332:include("QJ_listaveg.php");
Line #333:
Line #334:echo("<body onload='printit()'></body>");
Line #335:
Line #336:?>
Line #337:<SCRIPT Language="Javascript">
Line #338:
Line #339:function printit(){
Line #340:
Line #341:window.print();
Line #342://window.open("QJ_gyujto.php", 'sframe');
Line #343:
Line #344:}
Line #345:</script>
Line #346:<?PHP
Line #347:}
Line #348:
Line #349:?>
Line #350:
Line #351: