Bi-Dir

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