Bi-Dir

QJ_napiKONYVEL.inc

Line #0:<?php
Line #1:
Line #2:
Line #3:if (isset($_GET[nyomtat])) {
Line #4:?>
Line #5:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #6:<?PHP
Line #7:}
Line #8:
Line #9:////
Line #10:$login=$_SESSION['login'];
Line #11:if (!isset($_GET[napi])) {
Line #12:if (isset($_GET[musor_kod])) $_SESSION[CALL_KOD]=$_GET[musor_kod]; else
Line #13:$_GET[musor_kod]=$_SESSION[CALL_KOD];
Line #14:if (isset($_SESSION[CALL_KOD]) and $_SESSION[CALL_KOD]<>"" ) $CALL_KOD=" and datum_kod='".$_SESSION[CALL_KOD]."'"; else $CALL_KOD="";
Line #15:}
Line #16:
Line #17:////
Line #18:
Line #19:if (isset($_GET[L_nap])) $_SESSION[L_nap]=$_GET[L_nap];
Line #20:if (isset($_GET[L_biz])) $_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #21:
Line #22:
Line #23:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #24:$wer1=" and left(logtime,10)='".$_SESSION[L_nap]."'"; else $wer1="";
Line #25:
Line #26:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #27:$login=$_SESSION[L_bizomanyos];
Line #28:
Line #29:$wer2=" and bizomanyos='".$login."'";
Line #30:
Line #31:$nocheck="F";
Line #32:
Line #33:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) { $nocheck="Y"
Line #34:; $wer2=""; }
Line #35:
Line #36:
Line #37:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #38:
Line #39:$szin="";
Line #40:$i=0;
Line #41:$ft=0;
Line #42:$nap="?";
Line #43:$ri=0;
Line #44:$rft=0;
Line #45:$rmuv="?";
Line #46:
Line #47:$wi=0;
Line #48:$wft=0;
Line #49:$rlog="?";
Line #50:$hiba="";
Line #51:
Line #52://$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 #53:
Line #54://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY logtime DESC";
Line #55:
Line #56:if (isset($_GET[musor_kod])) {
Line #57:
Line #58:
Line #59:
Line #60:$keres = "SELECT * FROM qj_musor where datum_kod='".$_GET[musor_kod]."'";
Line #61:
Line #62:
Line #63:$musor=mysql_fetch_array($meredmeny);
Line #64:$L_NAP=$musor[helyszin]." ".$musor[datum_fej]." ".$musor[cim]." ".$musor[datum];
Line #65:
Line #66:if (isset($_GET[bh])) {
Line #67:$bh=" and left(bizonylatszam,2)<>'BH' ";
Line #68:} else {
Line #69:$bh="";
Line #70:}
Line #71:
Line #72:
Line #73:$L_PHP="QJ_napiKONYVEL.php";
Line #74:
Line #75:} else {
Line #76:
Line #77:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 ORDER BY logtime DESC";
Line #78:
Line #79://?
Line #80://echo ($parancs."<hr>");
Line #81:
Line #82:
Line #83:
Line #84:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #85:$Pnap=substr($kegy_sor[logtime],0,10);
Line #86:$rmuv=$kegy_sor[statusz];
Line #87:
Line #88:$nap=substr($kegy_sor[logtime],0,10);
Line #89:$wer1=" and left(logtime,10)='".$nap."'";
Line #90:
Line #91:if ($_SESSION[L_nap]==" " or !isset($_SESSION[L_nap])) {
Line #92: $_SESSION[L_nap]=$nap;
Line #93: $_SESSION[L_bizomanyos]=$kegy_sor[bizomanyos];
Line #94:}
Line #95:
Line #96:
Line #97:
Line #98:$_SESSION[Pnap]=$Pnap;
Line #99:$L_NAP=$_SESSION[L_nap];
Line #100:$L_user=$_SESSION[L_bizomanyos];
Line #101:
Line #102:
Line #103:
Line #104:$L_PHP="QJ_napiKONYVEL.php?&napi=Y";
Line #105:}
Line #106:
Line #107:
Line #108:include("QJ_listafej.php");
Line #109:
Line #110:echo "<table border=0>
Line #111:<tr bgcolor=silver>
Line #112:
Line #113:
Line #114:
Line #115:
Line #116:
Line #117:
Line #118:
Line #119:</tr>";
Line #120:
Line #121:
Line #122://$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 #123:
Line #124://$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 #125:
Line #126://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #127:
Line #128:if (isset($_GET[musor_kod]))
Line #129:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $bh and datum_kod='".$_GET[musor_kod]."' ORDER BY ar,statusz,ar_nev";
Line #130:else
Line #131:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 ORDER BY datum_kod,ar,statusz,ar_nev";
Line #132:
Line #133://?//echo ($parancs."<hr>");
Line #134:
Line #135:
Line #136:
Line #137:$i=0;
Line #138:$szin='#E0FFFF';
Line #139:$bh="";
Line #140:
Line #141:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #142:{
Line #143:
Line #144:if ($i==0) {
Line #145: $rdatum=$egy_sor[datum_kod];
Line #146: $nap=substr($egy_sor[logtime],0,10);
Line #147: $rar=$egy_sor[ar];
Line #148: $rar_nev=trim($egy_sor[ar_nev]);
Line #149: $rmuv=$egy_sor[statusz];
Line #150: $bh=substr($egy_sor[bizonylatszam],0,2);
Line #151:}
Line #152:
Line #153:$ref="";
Line #154:if ($rdatum<>$egy_sor[datum_kod] or
Line #155: $rar<>$egy_sor[ar] or
Line #156: $rar_nev<>trim($egy_sor[ar_nev]) or
Line #157: $rmuv<>$egy_sor[statusz]){
Line #158:
Line #159:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #160:
Line #161:
Line #162:$musor = mysql_fetch_array( $eredmeny3 );
Line #163:
Line #164:$h=$musor[helyszin];
Line #165:$c=$egy_sor[cim];
Line #166:$d=$egy_sor[datum];
Line #167:$wjid=$egy_sor[wid];
Line #168:
Line #169:$FormaJel=$egy_sor[FormaJel];
Line #170:$JeBe=$egy_sor[JeBe];
Line #171:
Line #172:
Line #173:
Line #174:
Line #175:echo"<tr bgcolor=gold>
Line #176:
Line #177:<td align=right bgcolor=$szin > $rdatum </td>
Line #178:<td align=right bgcolor=$szin >$musor[cim]  $musor[datum] $musor[helyszin]</td>
Line #179:<td align=right bgcolor=$szin > $rar_nev</td>
Line #180:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #181:<td bgcolor=$szin >$rmuv</td>
Line #182:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #183:<td bgcolor=$szin > Ft</td>
Line #184:<td bgcolor=$szin > $ri</td>
Line #185:<td align=left bgcolor=$szin > Db</td>
Line #186:</tr>";
Line #187:
Line #188:$ri=0;
Line #189:$rft=0;
Line #190:
Line #191:
Line #192:}
Line #193:
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=trim($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:++$i;
Line #203:++$ri;
Line #204:$rft=$rft+$egy_sor[ar];
Line #205:$ft =$ft+$egy_sor[ar];
Line #206:++$wi;
Line #207:$wft=$wft+$egy_sor[ar];
Line #208:
Line #209:
Line #210:/*
Line #211:$dk=$egy_sor[datum_kod];
Line #212:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #213:
Line #214:
Line #215:$musor = mysql_fetch_array( $eredmeny3 );
Line #216:
Line #217:$h=$musor[helyszin];
Line #218:$c=$egy_sor[cim];
Line #219:$d=$egy_sor[datum];
Line #220:$wjid=$egy_sor[wid];
Line #221:
Line #222:$FormaJel=$egy_sor[FormaJel];
Line #223:$JeBe=$egy_sor[JeBe];
Line #224:
Line #225:echo"<tr>
Line #226:
Line #227:<td align=right >
Line #228: $i.
Line #229:</td>
Line #230:
Line #231:<td align=right >$musor[cim] $musor[datum] $helyinfo</td>
Line #232:<td align=right >$musor[JeBe] $egy_sor[ar_nev]</td>
Line #233:<td align=right >".number_format($egy_sor[ar])."</td>
Line #234:<td >$egy_sor[statusz]</td>
Line #235:<td >$egy_sor[bizonylatszam]$ref</td>
Line #236:<td >".substr($egy_sor[logtime],-8)."</td>
Line #237:</tr>";
Line #238:*/
Line #239:
Line #240:/*
Line #241:$szin="";
Line #242://<td >".substr($egy_sor[logtime],-8)."</td>
Line #243://<td >".$egy_sor[logtime].$egy_sor[bizomanyos]."</td>
Line #244://<td >".$egy_sor[logtime].$egy_sor[bizomanyos].$ft."</td>
Line #245://}
Line #246:*/
Line #247:
Line #248:}
Line #249:
Line #250:
Line #251:if ($ft>0) {
Line #252:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #253:
Line #254:
Line #255:$musor = mysql_fetch_array( $eredmeny3 );
Line #256:
Line #257:$h=$musor[helyszin];
Line #258:$c=$egy_sor[cim];
Line #259:$d=$egy_sor[datum];
Line #260:$wjid=$egy_sor[wid];
Line #261:
Line #262:$FormaJel=$egy_sor[FormaJel];
Line #263:$JeBe=$egy_sor[JeBe];
Line #264:
Line #265:
Line #266://$rar_nev="?...?".substr($rar_nev,0,strlen($rar_nev)-6)."-..-";
Line #267:
Line #268:
Line #269:
Line #270:echo"<tr bgcolor=gold>
Line #271:
Line #272:<td align=right bgcolor=$szin > $rdatum </td>
Line #273:<td align=right bgcolor=$szin >$musor[cim]  $musor[datum] $musor[helyszin]</td>
Line #274:<td align=right bgcolor=$szin > $rar_nev</td>
Line #275:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #276:<td bgcolor=$szin >$rmuv</td>
Line #277:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #278:<td bgcolor=$szin > Ft</td>
Line #279:<td bgcolor=$szin > $ri</td>
Line #280:<td align=left bgcolor=$szin > Db</td>
Line #281:</tr>";
Line #282:}
Line #283:
Line #284:$szin="silver";
Line #285:
Line #286:echo"<tr>
Line #287:
Line #288:</td>
Line #289:<td colspan=2 align=right bgcolor=$szin>"
Line #290:.number_format($ft)."</td>
Line #291:<td bgcolor=$szin> Ft</td>
Line #292:<td align=right bgcolor=$szin>$i </td>
Line #293:<td align=left bgcolor=$szin> Db</td>
Line #294:</tr>";
Line #295:
Line #296:echo"</table>";
Line #297:
Line #298:
Line #299://include("QJ_varlist.php");
Line #300:
Line #301:if (isset($_GET[nyomtat])) {
Line #302:include("QJ_listaveg.php");
Line #303:
Line #304:echo("<body onload='printit()'></body>");
Line #305:
Line #306:?>
Line #307:<SCRIPT Language="Javascript">
Line #308:
Line #309:function printit(){
Line #310:
Line #311:
Line #312:window.print();
Line #313:///////////////////////////////////////
Line #314://window.open("QJ_felad.php", 'sframe');
Line #315:///////////////////////////////////////
Line #316://window.open("QJ_gyujto.php", 'sframe');
Line #317:
Line #318:}
Line #319:</script>
Line #320:<?PHP
Line #321:}
Line #322:
Line #323://~*~// QJ_napi.php
Line #324:?>
Line #325:
Line #326: