Bi-Dir

QJ_napiKONYVELafa_KB.inc

Line #0:<?php
Line #1:
Line #2://?//include("../_inc_BI/gvarlist.inc");
Line #3:
Line #4://?//$afawer=" and left(JeBe,1)='J' ";
Line #5:
Line #6:
Line #7:$wer="";
Line #8:
Line #9:IF (isset($_SESSION[bwinbizo])) {
Line #10: IF ($_SESSION[bwinbizomanyos]<>"*")
Line #11: $wer=" and bizomanyos='".$_SESSION[bwinbizomanyos]."'";
Line #12:
Line #13:}
Line #14:
Line #15:
Line #16:
Line #17:if (isset($_GET[nyomtat])) {
Line #18:?>
Line #19:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #20:<?PHP
Line #21:}
Line #22:
Line #23:////
Line #24:$login=$_SESSION['login'];
Line #25://?// if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #26://?// //$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #27://?// //if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #28:////
Line #29:
Line #30:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #31:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #32:
Line #33:
Line #34:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #35:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #36:
Line #37:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #38:$login=$_SESSION[L_bizomanyos];
Line #39:
Line #40:$wer2=" and bizomanyos='".$login."'";
Line #41:
Line #42:$wer3=" and left(bizonylatszam,3)<>'BH:' ";
Line #43://///// szinkron hiba MIATT EF11
Line #44:
Line #45:$nocheck="F";
Line #46:
Line #47:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #48:; $wer2=""; }
Line #49:
Line #50:
Line #51:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #52:
Line #53:$szin="";
Line #54:$i=0;
Line #55:$ft=0;
Line #56:$nap="?";
Line #57:$ri=0;
Line #58:$rft=0;
Line #59:$rmuv="?";
Line #60:
Line #61:$wi=0;
Line #62:$wft=0;
Line #63:$rlog="?";
Line #64:$hiba="";
Line #65:
Line #66://$parancs="SELECT * FROM qj_jegy where left(statusz,1)<>' ' and left(statusz,2)<>'El' and left(statusz,2)<>'St' $wer1 $wer2 ORDER BY logtime DESC";
Line #67:
Line #68://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #69:
Line #70:if (isset($_GET[musor_kod])) {
Line #71:
Line #72:
Line #73:$keres = "SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #74:
Line #75:
Line #76://?//echo ($keres."<hr>");
Line #77:
Line #78:$musor=mysql_fetch_array($meredmeny);
Line #79:$L_NAP=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim];
Line #80:
Line #81:if (isset($_GET[bh])) {
Line #82:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #83:} else {
Line #84:$bh="";
Line #85:}
Line #86:
Line #87:
Line #88:
Line #89:} else {
Line #90:
Line #91:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $afawer $wer1 $wer2 $wer3 ORDER BY logtime DESC";
Line #92:
Line #93://?//echo ($parancs."<hr>");
Line #94:
Line #95:
Line #96:
Line #97:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #98:$Pnap=substr($kegy_sor[logtime],0,10);
Line #99:$rmuv=$kegy_sor[statusz];
Line #100:
Line #101:$nap=substr($kegy_sor[logtime],0,10);
Line #102:$wer1=" and left(logtime,10)='".$nap."'";
Line #103:
Line #104:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #105: $_SESSION[L_nap]=$nap;
Line #106: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #107:}
Line #108:
Line #109:
Line #110:
Line #111:$_SESSION[Pnap]=$Pnap;
Line #112:$L_NAP=$_SESSION[L_nap];
Line #113:$L_user=$_SESSION[L_bizomanyos];
Line #114:
Line #115:
Line #116:}
Line #117:
Line #118:
Line #119:$L_PHP="QJ_napiKONYVELafa.php";
Line #120:include("QJ_listafej.php");
Line #121:
Line #122:$sajat="";
Line #123:
Line #124:if ($_SESSION[L_adoszam]<>"") {
Line #125:
Line #126:$keres = "SELECT * FROM qj_musor where Adoszam='".$_SESSION[L_adoszam]."'";
Line #127:
Line #128:
Line #129:$musor=mysql_fetch_array($meredmeny);
Line #130:$sajat=$musor[cimkieg3];
Line #131:
Line #132:
Line #133:}
Line #134:
Line #135:
Line #136:echo "<table witdh=100% border=1>
Line #137:<tr bgcolor=silver>
Line #138:
Line #139:
Line #140:
Line #141:<td witdh=50>Darab </td>
Line #142:
Line #143:
Line #144:
Line #145:
Line #146:</tr>";
Line #147:
Line #148:
Line #149://$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 #150:
Line #151://$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 #152:
Line #153://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #154:
Line #155:if (isset($_GET[musor_kod]))
Line #156:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $bh and datum_kod='".$_GET[musor_kod]."' $afawer $wer ORDER BY statusz,ar";
Line #157:else
Line #158:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $afawer $wer1 $wer2 $wer3 $wer ORDER BY statusz,ar,datum_kod";
Line #159://?//echo ($parancs."<hr>");
Line #160:
Line #161:
Line #162:
Line #163:$i=0;
Line #164:$szin='white';
Line #165:$bh="";
Line #166:
Line #167:$ri=0;
Line #168:$rft=0;
Line #169:$ri0=0;
Line #170:$rft0=0;
Line #171:$ri27=0;
Line #172:$rft27=0;
Line #173:
Line #174:$i=0;
Line #175:$ft=0;
Line #176:$i0=0;
Line #177:$ft0=0;
Line #178:$i27=0;
Line #179:$ft27=0;
Line #180:
Line #181:$fi=0;
Line #182:$fft=0;
Line #183:$fi0=0;
Line #184:$fft0=0;
Line #185:$fi27=0;
Line #186:$fft27=0;
Line #187:
Line #188:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #189:{
Line #190:
Line #191://echo($egy_sor[wid]."/".$egy_sor[datum_kod]."<hr>");
Line #192:
Line #193:if ($i==0) {
Line #194: $rdatum=$egy_sor[datum_kod];
Line #195: $nap=substr($egy_sor[logtime],0,10);
Line #196: $rar=$egy_sor[ar];
Line #197: $rar_nev=$egy_sor[ar_nev];
Line #198: $rmuv=$egy_sor[statusz];
Line #199: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #200:}
Line #201:
Line #202:$ref="";
Line #203:if ($rdatum<>$egy_sor[datum_kod] or
Line #204: $rar<>$egy_sor[ar] or
Line #205: $rmuv<>$egy_sor[statusz]){
Line #206:
Line #207:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #208:
Line #209:
Line #210:$musor = mysql_fetch_array( $eredmeny3 );
Line #211:
Line #212:$h=$musor[helyszin];
Line #213:$c=$egy_sor[cim];
Line #214:$d=$egy_sor[datum];
Line #215:$wjid=$egy_sor[wid];
Line #216:
Line #217://echo($wjid.$musor[helyszin]."/".$musor[cim]."/".$musor[datum]."/".$musor[cimkieg3]."<hr>".substr($_SESSION[L_adoszam],0,10)."/".substr($musor[cimkieg3],0,10));
Line #218:
Line #219:$FormaJel=$egy_sor[FormaJel];
Line #220:$JeBe=$egy_sor[JeBe];
Line #221:
Line #222:
Line #223:
Line #224:
Line #225:
Line #226:
Line #227:IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10))
Line #228:{
Line #229:$afert=intval($rft*$_SESSION[AFASZ]/100+0.5);
Line #230:$netto=$rft-$afert;
Line #231:
Line #232:echo"<tr bgcolor='#FAF8CC'>
Line #233:
Line #234:<td align=right >$musor[cim]  $musor[datum] ($rdatum)</td>
Line #235:<td align=right >$rmuv</td>
Line #236:
Line #237:<td align=right bgcolor=silver>".number_format($rar)."</td>
Line #238:<td align=right bgcolor=silver> $ri</td>
Line #239:<td align=right bgcolor=silver >".number_format($rft)."</td>
Line #240:
Line #241:<td align=right bgcolor=white >".number_format($netto,0)."</td>
Line #242:
Line #243:<td align=right bgcolor=yellow >".number_format($afert,0)."</td>
Line #244:
Line #245:<td align=right bgcolor=gold >".number_format($rft)."</td>
Line #246:
Line #247:</tr>";
Line #248: }
Line #249:$ri=0;
Line #250:$rft=0;
Line #251:$ri0=0;
Line #252:$rft0=0;
Line #253:$ri27=0;
Line #254:$rft27=0;
Line #255:
Line #256:if ($rmuv<>$egy_sor[statusz]){
Line #257:echo"<tr bgcolor=#ECD672 >
Line #258:
Line #259:
Line #260:<td align=right >$rmuv</td>
Line #261:
Line #262:<td align=right > </td>
Line #263:
Line #264:<td align=right > $fi0</td>
Line #265:<td align=right >".number_format($fft0)."</td>
Line #266:
Line #267:
Line #268:<td align=right > $fi27</td>
Line #269:<td align=right >".number_format($fft27)."</td>
Line #270:
Line #271:<td align=right > $fi</td>
Line #272:<td align=right >".number_format($fft)."</td>
Line #273:
Line #274:</tr>";
Line #275:
Line #276:$fi=0;
Line #277:$fft=0;
Line #278:$fi0=0;
Line #279:$fft0=0;
Line #280:$fi27=0;
Line #281:$fft27=0;
Line #282:}
Line #283:
Line #284:
Line #285:}
Line #286:
Line #287: $rdatum=$egy_sor[datum_kod];
Line #288: $nap=substr($egy_sor[logtime],0,10);
Line #289: $rar=$egy_sor[ar];
Line #290: $rar_nev=$egy_sor[ar_nev];
Line #291: $rmuv=$egy_sor[statusz];
Line #292: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #293:
Line #294:
Line #295:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #296:
Line #297:
Line #298:$musor = mysql_fetch_array( $eredmeny3 );
Line #299:
Line #300:
Line #301:IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10))
Line #302:{
Line #303:++$i;
Line #304:++$ri;
Line #305:++$fi;
Line #306:$rft=$rft+$egy_sor[ar];
Line #307:$fft=$fft+$egy_sor[ar];
Line #308:$ft =$ft+$egy_sor[ar];
Line #309:++$wi;
Line #310:$wft=$wft+$egy_sor[ar];
Line #311:
Line #312:IF ($musor[AFA_jel]=="MA") {
Line #313:++$ri0;
Line #314:$rft0=$rft0+$egy_sor[ar];
Line #315:++$fi0;
Line #316:$fft0=$fft0+$egy_sor[ar];
Line #317:++$i0;
Line #318:$ft0=$ft0+$egy_sor[ar];
Line #319:} else {
Line #320:++$fi27;
Line #321:$fft27=$fft27+$egy_sor[ar];
Line #322:++$i27;
Line #323:$ft27=$ft27+$egy_sor[ar];
Line #324:++$ri27;
Line #325:$rft27=$rft27+$egy_sor[ar];}
Line #326:
Line #327:
Line #328:}
Line #329:
Line #330:/*
Line #331:$dk=$egy_sor[datum_kod];
Line #332:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #333:
Line #334:
Line #335:$musor = mysql_fetch_array( $eredmeny3 );
Line #336:
Line #337:$h=$musor[helyszin];
Line #338:$c=$egy_sor[cim];
Line #339:$d=$egy_sor[datum];
Line #340:$wjid=$egy_sor[wid];
Line #341:
Line #342:$FormaJel=$egy_sor[FormaJel];
Line #343:$JeBe=$egy_sor[JeBe];
Line #344:
Line #345:echo"<tr>
Line #346:
Line #347:<td align=right >
Line #348: $i.
Line #349:</td>
Line #350:
Line #351:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #352:<td align=right >$musor[JeBe] $egy_sor[ar_nev]</td>
Line #353:<td align=right >".number_format($egy_sor[ar])."</td>
Line #354:<td >$egy_sor[statusz]</td>
Line #355:<td >$egy_sor[bizonylatszam]$ref</td>
Line #356:<td >".substr($egy_sor[logtime],-8)."</td>
Line #357:</tr>";
Line #358:*/
Line #359:
Line #360:/*
Line #361:$szin="";
Line #362://<td >".substr($egy_sor[logtime],-8)."</td>
Line #363://<td >".$egy_sor[logtime].$egy_sor[bizomanyos]."</td>
Line #364://<td >".$egy_sor[logtime].$egy_sor[bizomanyos].$ft."</td>
Line #365://}
Line #366:*/
Line #367:
Line #368:}
Line #369:
Line #370:
Line #371:if ($ft>0) {
Line #372:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #373:
Line #374:
Line #375:$musor = mysql_fetch_array( $eredmeny3 );
Line #376:
Line #377:$h=$musor[helyszin];
Line #378:$c=$egy_sor[cim];
Line #379:$d=$egy_sor[datum];
Line #380:$wjid=$egy_sor[wid];
Line #381:
Line #382:$FormaJel=$egy_sor[FormaJel];
Line #383:$JeBe=$egy_sor[JeBe];
Line #384:
Line #385://echo($wjid.$musor[helyszin]."/".$musor[cim]."/".$musor[datum]."/".$musor[cimkieg3]."<hr>");
Line #386:
Line #387:
Line #388://$rar_nev="?...?".substr($rar_nev,0,strlen($rar_nev)-6)."-..-";
Line #389:
Line #390:
Line #391:
Line #392:IF (substr($sajat,0,10)==substr($musor[cimkieg3],0,10))
Line #393:
Line #394:
Line #395:$afert=intval($rft*$_SESSION[AFASZ]/100+0.5);
Line #396:$netto=$rft-$afert;
Line #397:
Line #398:echo"<tr bgcolor='#FAF8CC'>
Line #399:
Line #400:<td align=right >$musor[cim]  $musor[datum] ($rdatum)</td>
Line #401:<td align=right >$rmuv</td>
Line #402:
Line #403:<td align=right bgcolor=silver>".number_format($rar)."</td>
Line #404:<td align=right bgcolor=silver> $ri</td>
Line #405:<td align=right bgcolor=silver >".number_format($rft)."</td>
Line #406:
Line #407:<td align=right bgcolor=white >".number_format($netto,0)."</td>
Line #408:
Line #409:<td align=right bgcolor=yellow >".number_format($afert,0)."</td>
Line #410:
Line #411:<td align=right bgcolor=gold >".number_format($rft)."</td>
Line #412:
Line #413:</tr>";
Line #414:
Line #415:
Line #416:
Line #417:$afert=intval($fft*$_SESSION[AFASZ]/100+0.5);
Line #418:$netto=$fft-$afert;
Line #419:
Line #420:
Line #421:echo"<tr bgcolor=silver>
Line #422:
Line #423:
Line #424:<td align=right >$rmuv</td>
Line #425:
Line #426:<td align=right > </td>
Line #427:
Line #428:<td align=right bgcolor=silver > $fi</td>
Line #429:<td align=right bgcolor=silver >".number_format($fft)."</td>
Line #430:
Line #431:<td align=right silver >".number_format($netto,0)."</td>
Line #432:
Line #433:<td align=right silver >".number_format($afert,0)."</td>
Line #434:<td align=right silver >".number_format($fft)."</td>
Line #435:
Line #436:</tr>";
Line #437:}
Line #438:
Line #439:$szin="silver";
Line #440:
Line #441:
Line #442:
Line #443:
Line #444:$afert=intval($ft*$_SESSION[AFASZ]/100+0.5);
Line #445:$netto=$ft-$afert;
Line #446:
Line #447:
Line #448:echo"<tr bgcolor=silver>
Line #449:
Line #450:
Line #451:</td>
Line #452:<td align=right bgcolor=silver > $i</td>
Line #453:
Line #454:<td align=right bgcolor=silver >".number_format($ft)."</td>
Line #455:
Line #456:<td align=right silver >".number_format($netto,0)."</td>
Line #457:
Line #458:<td align=right silver >".number_format($afert,0)."</td>
Line #459:<td align=right silver >".number_format($ft)."</td>
Line #460:
Line #461:</tr>";
Line #462:
Line #463:echo"</table>";
Line #464:
Line #465:
Line #466://include("QJ_varlist.php");
Line #467:
Line #468:if (isset($_GET[nyomtat])) {
Line #469:include("QJ_listaveg.php");
Line #470:
Line #471:echo("<body onload='printit()'></body>");
Line #472:
Line #473:?>
Line #474:<SCRIPT Language="Javascript">
Line #475:
Line #476:function printit(){
Line #477:
Line #478:
Line #479:window.print();
Line #480:///////////////////////////////////////
Line #481://window.open("QJ_felad.php", 'sframe');
Line #482:///////////////////////////////////////
Line #483://window.open("QJ_gyujto.php", 'sframe');
Line #484:
Line #485:}
Line #486:</script>
Line #487:<?PHP
Line #488:}
Line #489:
Line #490://~*~// QJ_napi.php
Line #491:?>
Line #492:
Line #493: