QL_napifull.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/QC_listaSELECT.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:$_SESSION[Pnap]=$Pnap;
Line #51:$L_NAP=$_SESSION[L_nap];
Line #52:$L_user=$_SESSION[L_bizomanyos];
Line #53:
Line #54:
Line #55:include("QJ_listafej.php");
Line #56:
Line #57:
Line #58:
Line #59:
Line #60:echo "<table border=0>
Line #61:<tr bgcolor=silver>
Line #62:
Line #63:
Line #64:
Line #65:
Line #66:<td ><b></b></td>
Line #67:<td ><b>Darab</b></td>
Line #68:<td ><b></b></td>
Line #69:<td ><b></b></td>
Line #70:</tr>";
Line #71:
Line #72:
Line #73://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY bizomanyos,statusz,logtime";
Line #74:
Line #75://$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 #76:
Line #77:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #78:and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $wer1 $wer2 $_SESSION[SUBbiz] ORDER BY bizomanyos,statusz,logtime";
Line #79:
Line #80://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #81:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #82:
Line #83:
Line #84:
Line #85:$nur=mysql_num_rows($eredmeny);
Line #86:if ($nur==0) {
Line #87:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #88:and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $_SESSION[SUBbiz] ORDER BY bizomanyos,statusz,logtime";
Line #89:
Line #90://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #91:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #92:
Line #93:
Line #94:}
Line #95:
Line #96://?//echo($parancs."<hr>");
Line #97://?//echo($_SESSION[SUBwer]."<hr>");
Line #98:
Line #99:
Line #100:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #101:{
Line #102:
Line #103:if ($i==0) {
Line #104:
Line #105:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #106:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #107:$rmuv2=$egy_sor[bizomanyos];
Line #108:
Line #109:$keres = "SELECT * FROM qj_musor where wid=1";
Line #110:
Line #111:
Line #112:$nur=mysql_num_rows($meredmeny);
Line #113:$musor=mysql_fetch_array($meredmeny);
Line #114:
Line #115:/*
Line #116:
Line #117:echo(" <a href=javascript:printit()><img src='print.png' border=0></a></font color></H5>");
Line #118:
Line #119:</H3>");
Line #120:*/
Line #121:
Line #122:
Line #123:}
Line #124:
Line #125:if ($rmuv<>$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10)){
Line #126:
Line #127:echo"<tr>
Line #128:
Line #129:
Line #130:</td>
Line #131:
Line #132:<td width=20 align=right ><b><font color=blue>".number_format($rft)."</font></b></td>
Line #133:<td> Ft</td>
Line #134:<td width=20 align=right ><b><font color=blue>".number_format($ri)."</font></b></td>
Line #135:<td> Db</td>
Line #136:</tr>";
Line #137:
Line #138:$ri=0;
Line #139:$rft=0;
Line #140:
Line #141:
Line #142:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #143:
Line #144:}
Line #145:
Line #146:if ($rmuv1<>$egy_sor[bizomanyos].":".$egy_sor[statusz]){
Line #147:
Line #148:echo"<tr>
Line #149:
Line #150:
Line #151:</td>
Line #152:
Line #153:<td width=20 align=right ><b><font color=blue>".number_format($rft1)."</font></b></td>
Line #154:<td> Ft</td>
Line #155:<td width=20 align=right ><b><font color=blue>".number_format($ri1)."</font></b></td>
Line #156:<td> Db</td>
Line #157:</tr>";
Line #158:
Line #159:$ri1=0;
Line #160:$rft1=0;
Line #161:
Line #162:
Line #163:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #164:
Line #165:}
Line #166:
Line #167:
Line #168:if ($rmuv2<>$egy_sor[bizomanyos]){
Line #169:
Line #170:echo"<tr>
Line #171:
Line #172:
Line #173:</td>
Line #174:
Line #175:<td width=20 align=right ><b><font color=blue>".number_format($rft2)."</font></b></td>
Line #176:<td> Ft</td>
Line #177:<td width=20 align=right ><b><font color=blue>".number_format($ri2)."</font></b></td>
Line #178:<td> Db </td>
Line #179:</tr><tr><td colspan=9><hr></td></tr>";
Line #180:
Line #181:
Line #182:$ri2=0;
Line #183:$rft2=0;
Line #184:
Line #185:
Line #186:$rmuv2=$egy_sor[bizomanyos];
Line #187:
Line #188:}
Line #189:
Line #190:
Line #191:++$i;
Line #192:++$ri;
Line #193:++$ri1;
Line #194:++$ri2;
Line #195:if (substr($egy_sor[statusz],0,2)<>'El') {
Line #196: $rft=$rft+$egy_sor[ar];
Line #197: $rft1=$rft1+$egy_sor[ar];
Line #198: $rft2=$rft2+$egy_sor[ar];
Line #199: $ft =$ft+$egy_sor[ar];
Line #200:}
Line #201:
Line #202:
Line #203:if ($_SESSION['Analitika']=="Yes") {
Line #204:
Line #205:echo"<tr>
Line #206:
Line #207:<td align=right >
Line #208:$i
Line #209:</td>
Line #210:
Line #211:<td align=right ><b><font color=$szin> $egy_sor[szoveg]</font></b></td>
Line #212:<td align=right ><b><font color=$szin> $egy_sor[ar_nev]</font></b></td>
Line #213:<td align=right ><b><font color=$szin> $egy_sor[ar]</font></b></td>
Line #214:<td >$egy_sor[statusz]</td>
Line #215:<td >$egy_sor[bizonylatszam]</td>
Line #216:<td >".$egy_sor[logtime]."</td>
Line #217:<td >$egy_sor[bizomanyos]</td>
Line #218:</tr>";
Line #219:$szin="";
Line #220:}
Line #221:
Line #222:}
Line #223:
Line #224:
Line #225:echo"<tr>
Line #226:
Line #227:
Line #228:</td>
Line #229:
Line #230:<td width=20 align=right ><b><font color=blue>".number_format($rft)."</font></b></td>
Line #231:<td> Ft</td>
Line #232:<td width=20 align=right ><b><font color=blue>".number_format($ri)."</font></b></td>
Line #233:<td> Db</td>
Line #234:</tr>";
Line #235:
Line #236:echo"<tr>
Line #237:
Line #238:
Line #239:</td>
Line #240:
Line #241:<td width=20 align=right ><b><font color=blue>".number_format($rft1)."</font></b></td>
Line #242:<td> Ft</td>
Line #243:<td width=20 align=right ><b><font color=blue>".number_format($ri1)."</font></b></td>
Line #244:<td> Db</td>
Line #245:</tr>";
Line #246:
Line #247:
Line #248:
Line #249:
Line #250:echo"<tr>
Line #251:
Line #252:
Line #253:</td>
Line #254:
Line #255:<td width=20 align=right ><b><font color=blue>".number_format($rft2)."</font></b></td>
Line #256:<td> Ft</td>
Line #257:<td width=20 align=right ><b><font color=blue>".number_format($ri2)."</font></b></td>
Line #258:<td> Db</td>
Line #259:</tr><tr><td colspan=9><hr></td></tr>";
Line #260:
Line #261:if ($ft<>$rft2) {
Line #262:echo"<tr>
Line #263:
Line #264:
Line #265:</td>
Line #266:
Line #267:<td width=20 align=right ><b><font color=red>".number_format( $ft)."</font></b></td>
Line #268:<td> Ft</td>
Line #269:<td width=20 align=right ><b><font color=red>".number_format( $i)."</font></b></td>
Line #270:<td> Db</td>
Line #271:</tr>";
Line #272:}
Line #273:
Line #274:echo "
Line #275:</table>";
Line #276:
Line #277:if (isset($_GET[nyomtat])) {
Line #278:include("QJ_listaveg.php");
Line #279:
Line #280:
Line #281:echo("<body onload='printit()'></body>");
Line #282:
Line #283:?>
Line #284:<SCRIPT Language="Javascript">
Line #285:
Line #286:function printit(){
Line #287:
Line #288:
Line #289:window.print();
Line #290:///////////////////////////////////////
Line #291://window.open("QJ_gyujto.php", 'sframe');
Line #292:///////////////////////////////////////
Line #293:
Line #294:}
Line #295:
Line #296:
Line #297:</script>
Line #298:<?PHP
Line #299:}