QJ_napifull_MH.inc
Line #0:<?php
Line #1:
Line #2:$L_PHP="QJ_napifull.php";
Line #3:$SelFile="qj_jegy where future<>'*' ";
Line #4:if (isset($_GET[musor_kod])) $_SESSION[SUBmusor_kod]=$_GET[musor_kod];
Line #5: else $_GET[musor_kod]=$_SESSION[SUBmusor_kod];
Line #6:
Line #7:$wer="";
Line #8:
Line #9:if (isset($_GET[nyomtat])) {
Line #10:?>
Line #11:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #12:<?PHP
Line #13:} else {
Line #14:
Line #15:include("../_inc_QJ/QJ_listaSELECT_ADO.inc");
Line #16:
Line #17:}
Line #18:
Line #19:
Line #20:
Line #21:$login=$_SESSION['login'];
Line #22:
Line #23:
Line #24:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #25:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #26:
Line #27:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #28:$login=$_SESSION[L_bizomanyos];
Line #29:
Line #30:$wer2=" and bizomanyos='".$login."'";
Line #31:
Line #32:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) $wer2="";
Line #33:
Line #34:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
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:$rft1=0;
Line #45:$rft2=0;
Line #46:$rmuv="?";
Line #47:$rmuv1="?";
Line #48:$rmuv2="?";
Line #49:
Line #50:
Line #51:IF (isset($_SESSION[QS_ado])) {
Line #52:
Line #53:IF (isset($_SESSION[QS_evho]) and $_SESSION[QS_evho]<>"*") $werEVHO=" and left(logtime,7)='".$_SESSION[QS_evho]."' ";
Line #54:else $werEVHO="";
Line #55://$werEVHO
Line #56:
Line #57:$disSEL = "SELECT datum_kod,Adoszam,cimkieg3 FROM qj_musor where future<>'*' and Adoszam='$_SESSION[QS_ado]' order by datum_kod " ;
Line #58:
Line #59:if (isset($_SESSION['Dump'])) echo($_SESSION[SUBwer]."~~_SESSION[SUBwer]~~ <hr>");
Line #60:
Line #61:if (isset($_SESSION['Dump'])) echo($disSEL." <hr>");
Line #62:
Line #63:
Line #64:
Line #65:// EZ LE IS FUT !!! onchange=this.form.submit(); return true name='QS_ado'>";
Line #66:
Line #67:$QS_ado=" and (INSTR('/";
Line #68:
Line #69://',datum_kod))
Line #70:
Line #71:$adofej="";
Line #72:$ai=0;
Line #73:while ( $disC = mysql_fetch_array( $disREC ) ) {
Line #74:
Line #75:
Line #76:
Line #77:
Line #78:if ($disC[Adoszam]==$_POST[QS_ado]) $sel="SELECTED"; else $sel="";
Line #79:$QS_ado.=$disC[datum_kod]."/";
Line #80:++$ai;
Line #81:}
Line #82:
Line #83:if ($ai>0) $QS_ado.="',datum_kod)) "; else $QS_ado="";
Line #84:
Line #85:
Line #86:if (isset($_SESSION['Dump'])) echo($QS_ado." <hr>");
Line #87:
Line #88:} else $QS_ado="";
Line #89:
Line #90:
Line #91:
Line #92:$_SESSION[Pnap]=$Pnap;
Line #93:$L_NAP=$_SESSION[L_nap];
Line #94:$L_user=$_SESSION[L_bizomanyos];
Line #95:
Line #96:
Line #97:include("QJ_listafej.php");
Line #98:
Line #99:
Line #100:
Line #101:
Line #102:echo "<table border=0>
Line #103:<tr bgcolor=silver>
Line #104:
Line #105:
Line #106:
Line #107:
Line #108:<td ><b></b></td>
Line #109:<td ><b>Darab</b></td>
Line #110:<td ><b></b></td>
Line #111:<td ><b></b></td>
Line #112:</tr>";
Line #113:
Line #114:
Line #115://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY bizomanyos,statusz,logtime";
Line #116:
Line #117://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer1 $wer2 ORDER BY bizomanyos,statusz,logtime";
Line #118:
Line #119:
Line #120:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad] $QS_ado
Line #121:and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $wer1 $wer2 $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #122:
Line #123://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #124:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #125:
Line #126:if (isset($_SESSION['Dump'])) echo($parancs." <hr>");
Line #127:
Line #128:
Line #129:
Line #130:$nur=mysql_num_rows($eredmeny);
Line #131:if ($nur==0) {
Line #132:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad] $QS_ado
Line #133:and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #134:
Line #135://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #136:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #137:
Line #138:if (isset($_SESSION['Dump'])) echo($parancs." <hr>");
Line #139:
Line #140:if (isset($_SESSION['Dump'])) echo( $_SESSION[SUBwer]." <hr>");
Line #141:
Line #142:
Line #143:}
Line #144:
Line #145://?//echo($parancs."<hr>");
Line #146://?//echo($_SESSION[SUBwer]."<hr>");
Line #147:
Line #148:
Line #149:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #150:{
Line #151:
Line #152:if ($i==0) {
Line #153:
Line #154:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #155:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #156:$rmuv2=$egy_sor[bizomanyos];
Line #157:
Line #158:$keres = "SELECT * FROM qj_musor where wid=1";
Line #159:
Line #160:
Line #161:$nur=mysql_num_rows($meredmeny);
Line #162:$musor=mysql_fetch_array($meredmeny);
Line #163:
Line #164:/*
Line #165:
Line #166:echo(" <a href=javascript:printit()><img src='print.png' border=0></a></font color></H5>");
Line #167:
Line #168:</H3>");
Line #169:*/
Line #170:
Line #171:
Line #172:}
Line #173:
Line #174:if ($rmuv<>$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10)){
Line #175:
Line #176:echo"<tr>
Line #177:
Line #178:
Line #179:</td>
Line #180:
Line #181:<td width=20 align=right ><b><font color=blue>".number_format($rft)."</font></b></td>
Line #182:<td> Ft</td>
Line #183:<td width=20 align=right ><b><font color=blue>".number_format($ri)."</font></b></td>
Line #184:<td> Db</td>
Line #185:</tr>";
Line #186:
Line #187:$ri=0;
Line #188:$rft=0;
Line #189:
Line #190:
Line #191:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #192:
Line #193:}
Line #194:
Line #195:if ($rmuv1<>$egy_sor[bizomanyos].":".$egy_sor[statusz]){
Line #196:
Line #197:echo"<tr>
Line #198:
Line #199:
Line #200:</td>
Line #201:
Line #202:<td width=20 align=right ><b><font color=blue>".number_format($rft1)."</font></b></td>
Line #203:<td> Ft</td>
Line #204:<td width=20 align=right ><b><font color=blue>".number_format($ri1)."</font></b></td>
Line #205:<td> Db</td>
Line #206:</tr>";
Line #207:
Line #208:$ri1=0;
Line #209:$rft1=0;
Line #210:
Line #211:
Line #212:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #213:
Line #214:}
Line #215:
Line #216:
Line #217:if ($rmuv2<>$egy_sor[bizomanyos]){
Line #218:
Line #219:echo"<tr>
Line #220:
Line #221:
Line #222:</td>
Line #223:
Line #224:<td width=20 align=right ><b><font color=blue>".number_format($rft2)."</font></b></td>
Line #225:<td> Ft</td>
Line #226:<td width=20 align=right ><b><font color=blue>".number_format($ri2)."</font></b></td>
Line #227:<td> Db </td>
Line #228:</tr><tr><td colspan=9><hr></td></tr>";
Line #229:
Line #230:
Line #231:$ri2=0;
Line #232:$rft2=0;
Line #233:
Line #234:
Line #235:$rmuv2=$egy_sor[bizomanyos];
Line #236:
Line #237:}
Line #238:
Line #239:
Line #240:++$i;
Line #241:++$ri;
Line #242:++$ri1;
Line #243:++$ri2;
Line #244:if (substr($egy_sor[statusz],0,2)<>'El') {
Line #245: $rft=$rft+$egy_sor[ar];
Line #246: $rft1=$rft1+$egy_sor[ar];
Line #247: $rft2=$rft2+$egy_sor[ar];
Line #248: $ft =$ft+$egy_sor[ar];
Line #249:}
Line #250:
Line #251:
Line #252:if ($_SESSION['Analitika']=="Yes") {
Line #253:
Line #254:echo"<tr>
Line #255:
Line #256:<td align=right >
Line #257:$i
Line #258:</td>
Line #259:
Line #260:<td align=right ><b><font color=$szin> $egy_sor[szoveg]</font></b></td>
Line #261:<td align=right ><b><font color=$szin> $egy_sor[ar_nev]</font></b></td>
Line #262:<td align=right ><b><font color=$szin> $egy_sor[ar]</font></b></td>
Line #263:<td >$egy_sor[statusz]</td>
Line #264:<td >$egy_sor[bizonylatszam]</td>
Line #265:<td >".$egy_sor[logtime]."</td>
Line #266:<td >$egy_sor[bizomanyos]</td>
Line #267:</tr>";
Line #268:$szin="";
Line #269:}
Line #270:
Line #271:}
Line #272:
Line #273:
Line #274:echo"<tr>
Line #275:
Line #276:
Line #277:</td>
Line #278:
Line #279:<td width=20 align=right ><b><font color=blue>".number_format($rft)."</font></b></td>
Line #280:<td> Ft</td>
Line #281:<td width=20 align=right ><b><font color=blue>".number_format($ri)."</font></b></td>
Line #282:<td> Db</td>
Line #283:</tr>";
Line #284:
Line #285:echo"<tr>
Line #286:
Line #287:
Line #288:</td>
Line #289:
Line #290:<td width=20 align=right ><b><font color=blue>".number_format($rft1)."</font></b></td>
Line #291:<td> Ft</td>
Line #292:<td width=20 align=right ><b><font color=blue>".number_format($ri1)."</font></b></td>
Line #293:<td> Db</td>
Line #294:</tr>";
Line #295:
Line #296:
Line #297:
Line #298:
Line #299:echo"<tr>
Line #300:
Line #301:
Line #302:</td>
Line #303:
Line #304:<td width=20 align=right ><b><font color=blue>".number_format($rft2)."</font></b></td>
Line #305:<td> Ft</td>
Line #306:<td width=20 align=right ><b><font color=blue>".number_format($ri2)."</font></b></td>
Line #307:<td> Db</td>
Line #308:</tr><tr><td colspan=9><hr></td></tr>";
Line #309:
Line #310:if ($ft<>$rft2) {
Line #311:echo"<tr>
Line #312:
Line #313:
Line #314:</td>
Line #315:
Line #316:<td width=20 align=right ><b><font color=red>".number_format( $ft)."</font></b></td>
Line #317:<td> Ft</td>
Line #318:<td width=20 align=right ><b><font color=red>".number_format( $i)."</font></b></td>
Line #319:<td> Db</td>
Line #320:</tr>";
Line #321:}
Line #322:
Line #323:echo "
Line #324:</table>";
Line #325:
Line #326:if (isset($_GET[nyomtat])) {
Line #327:include("QJ_listaveg.php");
Line #328:
Line #329:
Line #330:echo("<body onload='printit()'></body>");
Line #331:
Line #332:?>
Line #333:<SCRIPT Language="Javascript">
Line #334:
Line #335:function printit(){
Line #336:
Line #337:
Line #338:window.print();
Line #339:///////////////////////////////////////
Line #340://window.open("QJ_gyujto.php", 'sframe');
Line #341:///////////////////////////////////////
Line #342:
Line #343:}
Line #344:
Line #345:
Line #346:</script>
Line #347:<?PHP
Line #348:}