Bi-Dir

QJ_raportNEW.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:$L_PHP="QJ_raportNEW.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_listaSELECT.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://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) and $wer ORDER BY ar,statusz";
Line #129:
Line #130:
Line #131:
Line #132:$i=0;
Line #133:$szin='white';
Line #134:$bh="";
Line #135:
Line #136:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #137:{
Line #138:
Line #139:
Line #140:
Line #141:
Line #142:
Line #143:if ($i==0) {
Line #144: $rdatum=$egy_sor[datum_kod];
Line #145: $nap=substr($egy_sor[logtime],0,10);
Line #146: $rar=$egy_sor[ar];
Line #147: $rar_nev=trim($egy_sor[ar_nev]);
Line #148:
Line #149: $rmuv=$egy_sor[statusz];
Line #150: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #151:}
Line #152:
Line #153:$ref="";
Line #154:if ($rdatum<>$egy_sor[datum_kod] or
Line #155: $rar_nev<>trim($egy_sor[ar_nev]) or
Line #156: $rar<>$egy_sor[ar] or
Line #157: $rmuv<>$egy_sor[statusz]){
Line #158:
Line #159: /// Judit 2013.03.08. 14:21:54 ,
Line #160:
Line #161:
Line #162:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #163:
Line #164:
Line #165:$musor = mysql_fetch_array( $eredmeny3 );
Line #166:
Line #167:$h=$musor[helyszin];
Line #168:$c=$egy_sor[cim];
Line #169:$d=$egy_sor[datum];
Line #170:$wjid=$egy_sor[wid];
Line #171:
Line #172:$FormaJel=$egy_sor[FormaJel];
Line #173:$JeBe=$egy_sor[JeBe];
Line #174:
Line #175:
Line #176:
Line #177:
Line #178: $bondb=$bondb+$ri;
Line #179: $bonft=$bonft+$rft;
Line #180: $tab1="<td colspan=9>&nbsp</td>";
Line #181:
Line #182:echo"<tr>
Line #183:
Line #184:<td align=right bgcolor=$szin > $rar_nev</td>
Line #185:$tab1
Line #186:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #187:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #188:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #189:</tr>";
Line #190:
Line #191:
Line #192:} else {
Line #193:
Line #194:
Line #195: $tab1="";
Line #196: $tab2="<td colspan=3>&nbsp</td>";
Line #197: $kpdb=$kpdb+$ri;
Line #198: $kpft=$kpft+$rft;
Line #199: } else {
Line #200: $tab1="<td colspan=3>&nbsp</td>";
Line #201: $tab2="";
Line #202: $badb=$badb+$ri;
Line #203: $baft=$baft+$rft;
Line #204: }
Line #205:
Line #206:
Line #207:
Line #208:echo"<tr>
Line #209:
Line #210:<td align=right bgcolor=$szin > $rar_nev</td>
Line #211:$tab1
Line #212:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #213:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #214:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #215:$tab2
Line #216:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #217:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #218:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #219:
Line #220:</tr>";
Line #221:
Line #222:}
Line #223:
Line #224:$ri=0;
Line #225:$rft=0;
Line #226:
Line #227:
Line #228:}
Line #229:
Line #230: $rdatum=$egy_sor[datum_kod];
Line #231: $nap=substr($egy_sor[logtime],0,10);
Line #232: $rar=$egy_sor[ar];
Line #233: $rar_nev=trim($egy_sor[ar_nev]);
Line #234:
Line #235: $rmuv=$egy_sor[statusz];
Line #236: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #237:
Line #238:
Line #239:++$i;
Line #240:++$ri;
Line #241:$rft=$rft+$egy_sor[ar];
Line #242:$ft =$ft+$egy_sor[ar];
Line #243:++$wi;
Line #244:$wft=$wft+$egy_sor[ar];
Line #245:
Line #246:
Line #247:
Line #248:}
Line #249:
Line #250:
Line #251:
Line #252:
Line #253:
Line #254:
Line #255:
Line #256:
Line #257: $bondb=$bondb+$ri;
Line #258: $bonft=$bonft+$rft;
Line #259: $tab1="<td colspan=9>&nbsp</td>";
Line #260:
Line #261:echo"<tr>
Line #262:
Line #263:<td align=right bgcolor=$szin > $rar_nev</td>
Line #264:$tab1
Line #265:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #266:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #267:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #268:</tr>";
Line #269:
Line #270:} else {
Line #271:
Line #272:
Line #273: $tab1="";
Line #274: $tab2="<td colspan=3>&nbsp</td>";
Line #275: $kpdb=$kpdb+$ri;
Line #276: $kpft=$kpft+$rft;
Line #277: } else {
Line #278: $tab1="<td colspan=3>&nbsp</td>";
Line #279: $tab2="";
Line #280: $badb=$badb+$ri;
Line #281: $baft=$baft+$rft;
Line #282: }
Line #283:
Line #284:echo"<tr>
Line #285:
Line #286:<td align=right bgcolor=$szin > $rar_nev</td>
Line #287:$tab1
Line #288:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #289:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #290:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #291:$tab2
Line #292:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #293:<td align=right bgcolor=$szin >".number_format($ri)."</td>
Line #294:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #295:</tr>";
Line #296:
Line #297:
Line #298:}
Line #299:
Line #300:
Line #301:$szin="silver";
Line #302:
Line #303:
Line #304:echo"<tr>
Line #305:
Line #306:
Line #307:<td align=right bgcolor=$szin > </td>
Line #308:<td align=right bgcolor=$szin >".number_format($kpdb)."</td>
Line #309:<td align=right bgcolor=$szin >".number_format($kpft)."</td>
Line #310:<td align=right bgcolor=$szin > </td>
Line #311:<td align=right bgcolor=$szin >".number_format($badb)."</td>
Line #312:<td align=right bgcolor=$szin >".number_format($baft)."</td>
Line #313:<td align=right bgcolor=$szin > </td>
Line #314:<td align=right bgcolor=$szin >".number_format($kpdb+$badb)."</td>
Line #315:<td align=right bgcolor=$szin >".number_format($kpft+$baft)."</td>";
Line #316:
Line #317:
Line #318:echo"
Line #319:<td align=right bgcolor=$szin > </td>
Line #320:<td align=right bgcolor=$szin >".number_format($bondb)."</td>
Line #321:<td align=right bgcolor=$szin >".number_format($bonft)."</td>";
Line #322:
Line #323:echo"</tr>";
Line #324:
Line #325:
Line #326:echo"</table>";
Line #327:
Line #328:
Line #329:if (isset($_GET[nyomtat])) {
Line #330:include("QJ_listaveg.php");
Line #331:
Line #332:echo("<body onload='printit()'></body>");
Line #333:
Line #334:?>
Line #335:<SCRIPT Language="Javascript">
Line #336:
Line #337:function printit(){
Line #338:
Line #339:window.print();
Line #340://window.open("QJ_gyujto.php", 'sframe');
Line #341:
Line #342:}
Line #343:</script>
Line #344:<?PHP
Line #345:}
Line #346:
Line #347:?>
Line #348:
Line #349: