Bi-Dir

QJ_napiKONYVEL0ft.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_napiKONYVEL0ft.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_napiKONYVEL0ft.php";
Line #105:}
Line #106:
Line #107:
Line #108:
Line #109:$L_PHP="QJ_napiKONYVEL0ft.php";
Line #110:
Line #111:include("QJ_listafej.php");
Line #112:
Line #113:echo "<table border=0 width=100%>
Line #114:<tr bgcolor=silver>
Line #115:
Line #116:
Line #117:<td width=10% align=right >Protokoll Db</td>
Line #118:
Line #119:
Line #120:</tr>";
Line #121:
Line #122:
Line #123://$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 #124:
Line #125://$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 #126:
Line #127://$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] or $_SESSION[SQL_storno]) $wer1 $wer2 ORDER BY statusz,bizonylatszam DESC";
Line #128:
Line #129:if (isset($_GET[musor_kod]))
Line #130:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $bh and datum_kod='".$_GET[musor_kod]."' ORDER BY ar,statusz,ar_nev";
Line #131:else
Line #132:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) $wer1 $wer2 ORDER BY datum_kod,ar,statusz,ar_nev";
Line #133:
Line #134:
Line #135:$parancs="SELECT * FROM qj_jegy where ($_SESSION[SQL_elad] ) and ar=0 ORDER BY datum_kod,arkategoria,ar,statusz,ar_nev";
Line #136:
Line #137:
Line #138:
Line #139://?//echo ($parancs."<hr>");
Line #140:
Line #141:
Line #142:
Line #143:$i=0;
Line #144:$szin='#E0FFFF';
Line #145:$bh="";
Line #146:
Line #147:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #148:{
Line #149:
Line #150:
Line #151:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='".$egy_sor[datum_kod]."'";
Line #152:
Line #153:
Line #154:$musor = mysql_fetch_array( $eredmeny3 );
Line #155:
Line #156:$h=$musor[helyszin];
Line #157:$c=$egy_sor[cim];
Line #158:$d=$egy_sor[datum];
Line #159:$wjid=$egy_sor[wid];
Line #160:
Line #161:
Line #162:if (trim($musor[Adoszam])=="23834936-2-05" and substr($musor[datum_evho],0,4)=="2013") {
Line #163:
Line #164:
Line #165:$FormaJel=$egy_sor[FormaJel];
Line #166:$JeBe=$egy_sor[JeBe];
Line #167:
Line #168:$kati=$egy_sor[arkategoria];
Line #169:
Line #170:$Afar=$musor["alapar".$kati];
Line #171:
Line #172:if ($ri==0) {
Line #173: $rdatum=$egy_sor[datum_kod];
Line #174: $nap=substr($egy_sor[logtime],0,10);
Line #175: $rar=$Afar;
Line #176:}
Line #177:
Line #178:$ref="";
Line #179:if ($rdatum<>$egy_sor[datum_kod] or
Line #180: $rar<>$Afar){
Line #181:
Line #182:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #183:
Line #184:
Line #185:$musor = mysql_fetch_array( $eredmeny3 );
Line #186:
Line #187:$h=$musor[helyszin];
Line #188:$c=$egy_sor[cim];
Line #189:$d=$egy_sor[datum];
Line #190:$wjid=$egy_sor[wid];
Line #191:
Line #192:$FormaJel=$egy_sor[FormaJel];
Line #193:$JeBe=$egy_sor[JeBe];
Line #194:
Line #195:
Line #196:if ($szin=='yellow') $szin=''; else $szin='yellow';
Line #197:
Line #198:$i=$i+$ri;
Line #199:$ft =$ft+$rft;
Line #200:
Line #201:echo"<tr >
Line #202:<td align=right bgcolor=$szin >$musor[cimkieg3] $musor[Adoszam] $rdatum </td>
Line #203:<td align=right bgcolor=$szin >$musor[cim]  $musor[datum] $musor[helyszin]</td>
Line #204:<td align=right bgcolor=$szin> $ri</td>
Line #205:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #206:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #207:</tr>";
Line #208:
Line #209:$rar=$Afar;
Line #210:$rdatum=$egy_sor[datum_kod];
Line #211:
Line #212:$ri=0;
Line #213:$rft=0;
Line #214:
Line #215:}
Line #216:
Line #217:++$ri;
Line #218:$rft=$rft+$Afar;
Line #219:
Line #220:///
Line #221:}}
Line #222:///
Line #223:
Line #224:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$rdatum'";
Line #225:
Line #226:
Line #227:$musor = mysql_fetch_array( $eredmeny3 );
Line #228:
Line #229:$h=$musor[helyszin];
Line #230:$c=$egy_sor[cim];
Line #231:$d=$egy_sor[datum];
Line #232:$wjid=$egy_sor[wid];
Line #233:
Line #234:$FormaJel=$egy_sor[FormaJel];
Line #235:$JeBe=$egy_sor[JeBe];
Line #236:
Line #237:
Line #238:if ($szin=='yellow') $szin=''; else $szin='yellow';
Line #239:
Line #240://if ($musor[Adoszam]=="23834936-2-05" and substr($musor[datum],0,4)=="2013") {
Line #241://if (trim($musor[Adoszam])=="23834936-2-05" ) {
Line #242:
Line #243:if (trim($musor[Adoszam])=="23834936-2-05" and substr($musor[datum_evho],0,4)=="2013") {
Line #244:$i=$i+$ri;
Line #245:$ft =$ft+$rft;
Line #246:
Line #247:echo"<tr >
Line #248:<td align=right bgcolor=$szin >$musor[cimkieg3] $musor[Adoszam] $rdatum </td>
Line #249:<td align=right bgcolor=$szin >$musor[cim]  $musor[datum] $musor[helyszin]</td>
Line #250:<td align=right bgcolor=$szin> $ri</td>
Line #251:<td align=right bgcolor=$szin >".number_format($rar)."</td>
Line #252:<td align=right bgcolor=$szin >".number_format($rft)."</td>
Line #253:</tr>";
Line #254:}
Line #255:
Line #256:$szin="silver";
Line #257:
Line #258:echo"<tr>
Line #259:
Line #260:</td>
Line #261:<td align=right bgcolor=$szin>$i </td>
Line #262:<td colspan=2 align=right bgcolor=$szin>
Line #263:".number_format($ft)."</td>
Line #264:</tr>";
Line #265:
Line #266:echo"</table>";
Line #267:
Line #268:
Line #269://include("QJ_varlist.php");
Line #270:
Line #271:if (isset($_GET[nyomtat])) {
Line #272:include("QJ_listaveg.php");
Line #273:
Line #274:echo("<body onload='printit()'></body>");
Line #275:
Line #276:?>
Line #277:<SCRIPT Language="Javascript">
Line #278:
Line #279:function printit(){
Line #280:
Line #281:
Line #282:window.print();
Line #283:///////////////////////////////////////
Line #284://window.open("QJ_felad.php", 'sframe');
Line #285:///////////////////////////////////////
Line #286://window.open("QJ_gyujto.php", 'sframe');
Line #287:
Line #288:}
Line #289:</script>
Line #290:<?PHP
Line #291:}
Line #292:
Line #293://~*~// QJ_napi.php
Line #294:?>
Line #295:
Line #296: