Bi-Dir

QJ_napifull_MK_V2.inc

Line #0:
Line #1:$dkodok="/";
Line #2:
Line #3:$L_PHP="QJ_napifull.php";
Line #4:$SelFile="qj_jegy where future<>'*' ";
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/QS_listaSELECT.inc");
Line #17:
Line #18:}
Line #19:
Line #20:
Line #21:
Line #22:$login=$_SESSION['login'];
Line #23:
Line #24:
Line #25:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #26:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #27:
Line #28:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #29:$login=$_SESSION[L_bizomanyos];
Line #30:
Line #31:$wer2=" and bizomanyos='".$login."'";
Line #32:
Line #33:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) $wer2="";
Line #34:
Line #35:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #36:
Line #37:
Line #38:
Line #39:
Line #40:
Line #41:$keres="SELECT distinct datum_kod FROM qj_jegy where ar>0 and future <>'*' and $_SESSION[SQL_elad] $wer3 $wer1 $_SESSION[SUBwer] ORDER BY datum_kod";
Line #42:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #43:
Line #44://?//echo($keres."<hr>");
Line #45:
Line #46:
Line #47:$werdatum= " and ( ";
Line #48:$and="";
Line #49:
Line #50:$wi=0;
Line #51:
Line #52:$wera=" and (Adoszam='' or Adoszam='23834936-2-05') "; // " and Adoszam='23834936-2-05' ";
Line #53:
Line #54:while ( $egy_sor = mysql_fetch_array( $eredmeny ) )
Line #55:{
Line #56:
Line #57:$dk=$egy_sor[datum_kod];
Line #58:$Msql="SELECT * FROM qj_musor where future <>'*' $wera and datum_kod='$dk' ";
Line #59:
Line #60:if (isset($_SESSION['Dump'])) echo($keres." <hr>");
Line #61:
Line #62:
Line #63:$nurM=mysql_num_rows($Meredmeny);
Line #64:
Line #65:if ($nurM>0) {
Line #66: $werdatum.= $and. " datum_kod='$dk'";
Line #67: $and=" or ";
Line #68: ++$wi;
Line #69:}
Line #70:
Line #71:}
Line #72:
Line #73:
Line #74:$werdatum.= " )";
Line #75:
Line #76:// echo($werdatum."<hr>");
Line #77:
Line #78:if ($wi==0) $werdatum="";
Line #79:
Line #80:
Line #81:$szin="";
Line #82:$i=0;
Line #83:$ft=0;
Line #84:$nap="?";
Line #85:$ri=0;
Line #86:$rft=0;
Line #87:$rft1=0;
Line #88:$rft2=0;
Line #89:$rmuv="?";
Line #90:$rmuv1="?";
Line #91:$rmuv2="?";
Line #92:
Line #93:$_SESSION[Pnap]=$Pnap;
Line #94:$L_NAP=$_SESSION[L_nap];
Line #95:$L_user=$_SESSION[L_bizomanyos];
Line #96:
Line #97:
Line #98:include("QJ_listafej.php");
Line #99:
Line #100:
Line #101:
Line #102:
Line #103:echo "<table border=0>
Line #104:<tr bgcolor=silver>
Line #105:
Line #106:
Line #107:
Line #108:
Line #109:<td ></td>
Line #110:<td >Darab</td>
Line #111:<td ></td>
Line #112:<td ></td>
Line #113:</tr>";
Line #114:
Line #115:
Line #116://$parancs="SELECT * FROM qj_jegy where statusz<>'' and left(statusz,2)<>'El' and left(statusz,2)<>'St' ORDER BY bizomanyos,statusz,logtime";
Line #117:
Line #118://$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 #119:
Line #120:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #121:and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $wer3 $wer1 $_SESSION[SUBwer] $werdatum 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:
Line #127:
Line #128:$nur=mysql_num_rows($eredmeny);
Line #129:if ($nur==0) {
Line #130:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #131: $wer3 and ( $_SESSION[SQL_berlet] OR $_SESSION[SQL_jegy] ) $_SESSION[SUBwer]
Line #132: and datum_kod<>'MK14D00379' ORDER BY bizomanyos,statusz,logtime";
Line #133:
Line #134://$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad]
Line #135:// $_SESSION[SUBwer] ORDER BY bizomanyos,statusz,logtime";
Line #136:
Line #137:
Line #138:}
Line #139:
Line #140://?//echo($parancs."<hr>");
Line #141://?//echo($_SESSION[SUBwer]."<hr>");
Line #142:
Line #143://////////////////////!!! //////////////////////////////
Line #144:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #145:{
Line #146:
Line #147:if ($i==0) {
Line #148:
Line #149:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #150:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #151:$rmuv2=$egy_sor[bizomanyos];
Line #152:
Line #153:$keres = "SELECT * FROM qj_musor where wid=1";
Line #154:
Line #155:
Line #156:$nur=mysql_num_rows($meredmeny);
Line #157:$musor=mysql_fetch_array($meredmeny);
Line #158:
Line #159:/*
Line #160:
Line #161:echo("  <a href=javascript:printit()><img src='print.png' border=0></a></H5>");
Line #162:
Line #163:</H3>");
Line #164:*/
Line #165:
Line #166:
Line #167:}
Line #168:
Line #169:$datum_kod=$egy_sor[datum_kod];
Line #170:$Vft=$egy_sor[ar];
Line #171:$valid="fut";
Line #172://include("QQ_validPNZTAR.inc");
Line #173:/*
Line #174:if (strpos("?".$dkodok,$datum_kod)==0 and $dm<5000 ) {++$dm; $dkodok=$dkodok.$datum_kod."/";}
Line #175:
Line #176:$pos=strpos("?".$dkodok,$datum_kod);
Line #177:$di=intval($pos/11);
Line #178:$di=$pos/11;
Line #179:$dt[$di]=$datum_kod;
Line #180:++$dd[$di];
Line #181:$da[$di]=$da[$di]+$Vft;
Line #182:// echo($di." ??? ".$pos." ".$da[$di]." ".$dt[$di]." ".$dkodok." ".$Vft." ");
Line #183:*/
Line #184:
Line #185:
Line #186:if ($rmuv<>$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10)){
Line #187:
Line #188:echo"<tr>
Line #189:
Line #190:
Line #191:</td>
Line #192:
Line #193:<td width=20 align=right >".number_format($rft)."</td>
Line #194:<td> Ft</td>
Line #195:<td width=20 align=right >".number_format($ri)."</td>
Line #196:<td> Db</td>
Line #197:</tr>";
Line #198:
Line #199:$ri=0;
Line #200:$rft=0;
Line #201:
Line #202:
Line #203:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,10);
Line #204:
Line #205:}
Line #206:
Line #207:if ($rmuv1<>$egy_sor[bizomanyos].":".$egy_sor[statusz]){
Line #208:
Line #209:echo"<tr>
Line #210:
Line #211:
Line #212:</td>
Line #213:
Line #214:<td width=20 align=right >".number_format($rft1)."</td>
Line #215:<td> Ft</td>
Line #216:<td width=20 align=right >".number_format($ri1)."</td>
Line #217:<td> Db</td>
Line #218:</tr>";
Line #219:
Line #220:$ri1=0;
Line #221:$rft1=0;
Line #222:
Line #223:
Line #224:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #225:
Line #226:}
Line #227:
Line #228:
Line #229:if ($rmuv2<>$egy_sor[bizomanyos]){
Line #230:
Line #231:echo"<tr>
Line #232:
Line #233:
Line #234:</td>
Line #235:
Line #236:<td width=20 align=right >".number_format($rft2)."</td>
Line #237:<td> Ft</td>
Line #238:<td width=20 align=right >".number_format($ri2)."</td>
Line #239:<td> Db </td>
Line #240:</tr><tr><td colspan=9><hr></td></tr>";
Line #241:
Line #242:
Line #243:$ri2=0;
Line #244:$rft2=0;
Line #245:
Line #246:
Line #247:$rmuv2=$egy_sor[bizomanyos];
Line #248:
Line #249:}
Line #250:
Line #251:
Line #252:++$i;
Line #253:++$ri;
Line #254:++$ri1;
Line #255:++$ri2;
Line #256:if (substr($egy_sor[statusz],0,2)<>'El') {
Line #257: $rft=$rft+$egy_sor[ar];
Line #258: $rft1=$rft1+$egy_sor[ar];
Line #259: $rft2=$rft2+$egy_sor[ar];
Line #260: $ft =$ft+$egy_sor[ar];
Line #261:}
Line #262:
Line #263:
Line #264:if ($_SESSION['Analitika']=="Yes") {
Line #265:
Line #266:echo"<tr>
Line #267:
Line #268:<td align=right >
Line #269:$i
Line #270:</td>
Line #271:
Line #272:<td align=right > $egy_sor[szoveg]</td>
Line #273:<td align=right > $egy_sor[ar_nev]</td>
Line #274:<td align=right > $egy_sor[ar]</td>
Line #275:<td >$egy_sor[statusz]</td>
Line #276:<td >$egy_sor[bizonylatszam]</td>
Line #277:<td >".$egy_sor[logtime]."</td>
Line #278:<td >$egy_sor[bizomanyos]</td>
Line #279:</tr>";
Line #280:$szin="";
Line #281:}
Line #282:
Line #283://///////////////////////////////
Line #284://////////// 2014.04.03. 4:34:57 //////////////////
Line #285: }
Line #286://///////////////////////////////
Line #287:
Line #288:
Line #289:echo"<tr>
Line #290:
Line #291:
Line #292:</td>
Line #293:
Line #294:<td width=20 align=right >".number_format($rft)."</td>
Line #295:<td> Ft</td>
Line #296:<td width=20 align=right >".number_format($ri)."</td>
Line #297:<td> Db</td>
Line #298:</tr>";
Line #299:
Line #300:echo"<tr>
Line #301:
Line #302:
Line #303:</td>
Line #304:
Line #305:<td width=20 align=right >".number_format($rft1)."</td>
Line #306:<td> Ft</td>
Line #307:<td width=20 align=right >".number_format($ri1)."</td>
Line #308:<td> Db</td>
Line #309:</tr>";
Line #310:
Line #311:
Line #312:
Line #313:
Line #314:echo"<tr>
Line #315:
Line #316:
Line #317:</td>
Line #318:
Line #319:<td width=20 align=right >".number_format($rft2)."</td>
Line #320:<td> Ft</td>
Line #321:<td width=20 align=right >".number_format($ri2)."</td>
Line #322:<td> Db</td>
Line #323:</tr><tr><td colspan=9><hr></td></tr>";
Line #324:
Line #325:if ($ft<>$rft2) {
Line #326:echo"<tr>
Line #327:
Line #328:
Line #329:</td>
Line #330:
Line #331:<td width=20 align=right >".number_format( $ft)."</td>
Line #332:<td> Ft</td>
Line #333:<td width=20 align=right >".number_format( $i)."</td>
Line #334:<td> Db</td>
Line #335:</tr>";
Line #336:}
Line #337:
Line #338:echo "
Line #339:</table>";
Line #340:/*
Line #341:$valid="veg";
Line #342://include("QQ_validPNZTAR.inc");
Line #343:$sft=0;
Line #344:$sdb=0;
Line #345:for ($i=0;$i<$dm+1;++$i){
Line #346: echo($i." ".$dd[$i]." ".$da[$i]." ".$dt[$i]." ");
Line #347:$sft=$sft+$da[$i];
Line #348:$sdb=$sdb+$dd[$i];
Line #349:}
Line #350: echo($dm." ".$sft." ".$sdb." ");
Line #351:*/
Line #352:
Line #353:if (isset($_GET[nyomtat])) {
Line #354:include("QJ_listaveg.php");
Line #355:
Line #356:echo("<body onload='printit()'></body>");
Line #357:
Line #358:?>
Line #359:<SCRIPT Language="Javascript">
Line #360:
Line #361:function printit(){
Line #362:
Line #363:
Line #364:window.print();
Line #365:///////////////////////////////////////
Line #366://window.open("QJ_gyujto.php", 'sframe');
Line #367:///////////////////////////////////////
Line #368:
Line #369:}
Line #370:
Line #371:
Line #372:</script>
Line #373:<?PHP
Line #374:}