Bi-Dir

QJ_gyujtoKONTROLLflow.inc

Line #0:<?php
Line #1:
Line #2:if (isset($_POST[archiv]))
Line #3:{ $fajl="qj_archive"; $sel2=" CHECKED"; }
Line #4:else
Line #5:{ $fajl="qj_jegy where archiv='-' "; $sel2=""; }
Line #6:
Line #7:
Line #8:if (!isset($_GET[gyujto]))
Line #9:$parancs="SELECT * FROM $fajl ORDER BY left(logtime,13) DESC limit 1";
Line #10:else
Line #11:{
Line #12: $fajl="qj_archive"; $sel2=" CHECKED";
Line #13:$GL=strlen($_GET[gyujto])+1;
Line #14:$werGL=" and left(bizonylatszam,$GL)='".$_GET[gyujto]."/'";
Line #15:$parancs="SELECT * FROM $fajl where statusz<>'' and statusz<>'El' $werGL ORDER BY left(logtime,13) DESC limit 1";
Line #16:}
Line #17:
Line #18:
Line #19:
Line #20:if (isset($_SESSION['Dump'])) echo($parancs." <hr>");
Line #21:
Line #22:
Line #23:$egy_sor = mysql_fetch_array( $eredmeny );
Line #24:
Line #25:$nur=mysql_num_rows($eredmeny);
Line #26:if ($nur==0) { // Ha nincs /perjel
Line #27:$GL=strlen($_GET[gyujto]);
Line #28:$werGL=" and left(bizonylatszam,$GL)='".$_GET[gyujto]."'";
Line #29:$parancs="SELECT * FROM $fajl where statusz<>'' and statusz<>'El' $werGL ORDER BY left(logtime,13) DESC limit 1";
Line #30:
Line #31:$egy_sor = mysql_fetch_array( $eredmeny );
Line #32:}
Line #33:
Line #34:
Line #35:$mai=substr($egy_sor[logtime],0,10);
Line #36:
Line #37:if (isset($_POST[Analitika]) or isset($_GET[Analitika]))
Line #38:{ $_GET[Analitika]="Yes"; $sel1=" CHECKED"; }
Line #39:else
Line #40:{ $sel1=""; unset($_GET[Analitika]); }
Line #41:
Line #42:if (isset($_POST[mai])) $mai=str_replace(".","-",$_POST[mai]);
Line #43:
Line #44:if (isset($_GET[nyomtat])) {
Line #45:?>
Line #46:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #47:<?PHP
Line #48:} else {
Line #49:
Line #50:if (!isset($_GET[gyujto])){
Line #51:
Line #52:
Line #53:
Line #54:?>
Line #55:<SCRIPT LANGUAGE="JavaScript" SRC="calendar.js"></SCRIPT>
Line #56:
Line #57: <FORM name=myForm action='QJ_napiWORKflow.php' method='post'>
Line #58:
Line #59:
Line #60:
Line #61:  
Line #62:
Line #63:<a target=infoframe href="../_Screen/BIcDir.php" >
Line #64:
Line #65:  
Line #66:
Line #67:
Line #68:<a target=infoframe href="QJ_napiWORKflow.php" >
Line #69:
Line #70:  
Line #71:
Line #72:
Line #73:
Line #74:
Line #76: <INPUT TYPE='CHECKBOX' NAME='Analitika' <? print $sel1; ?>
Line #77: onclick=this.form.submit(); return true name='Analitika'
Line #78: >Analitika
Line #79:
Line #80: <INPUT TYPE='CHECKBOX' NAME='archiv' <? print $sel2; ?>
Line #81: onclick=this.form.submit(); return true name='Analitika'
Line #82: >Archiv
Line #83:
Line #84:
Line #85:
Line #86:<a href="javascript:doNothing()"
Line #87:onclick="setDateField(document.myForm.mai);
Line #88:top.newWin=window.open('calendar.html','cal','dependent=yes,width=210,height=230,screenX=200,screenY=300,titlebar=yes');
Line #89:this.form.submit();" >
Line #90:
Line #91:
Line #92: </FORM>
Line #93:<?PHP
Line #94:}
Line #95:}
Line #96:
Line #97:if (isset($_POST[archiv]))
Line #98:{ $wer=" where left(logtime,10)='".$mai."'"; $L_cim="Napi ARCHIV WorkFlow";
Line #99:}
Line #100:else
Line #101:{ $wer=" and left(logtime,10)='".$mai."'"; $L_cim="Napi JEGY WorkFlow";
Line #102:}
Line #103:
Line #104:
Line #105:$szin="";
Line #106:$i=0;
Line #107:$ft=0;
Line #108:$nap="?";
Line #109:$ri=0;
Line #110:$rft=0;
Line #111:$rft1=0;
Line #112:$rft2=0;
Line #113:$rmuv="?";
Line #114:$rmuv1="?";
Line #115:$rmuv2="?";
Line #116:
Line #117:
Line #118:if (!isset($_GET[gyujto]))
Line #119:$parancs="SELECT * FROM $fajl $wer and statusz<>'' ORDER BY left(logtime,13) DESC,bizomanyos,statusz";
Line #120:else
Line #121:{
Line #122:$fajl="qj_archive"; $sel2=" CHECKED";
Line #123:$GL=strlen($_GET[gyujto]);
Line #124:
Line #125:$_GET[Analitika]="Yes";
Line #126:$mai="";
Line #127:$parancs="SELECT * FROM $fajl where statusz<>'' and statusz<>'El' $werGL ORDER BY left(logtime,13) DESC,bizomanyos,statusz";
Line #128:}
Line #129:
Line #130://$_SESSION['Dump']="?";
Line #131:
Line #132:if (isset($_SESSION['Dump'])) echo($parancs." <hr>");
Line #133:
Line #134:
Line #135:
Line #136:$nur=mysql_num_rows($eredmeny);
Line #137:
Line #138:$_GET[Analitika]="Yes";
Line #139:
Line #140:////////////////////////////////////////////////////
Line #141:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #142:////////////////////////////////////////////////////
Line #143:{
Line #144:
Line #145:if ($i==0) {
Line #146:
Line #147:$rmuv=$egy_sor[bizomanyos].":".$egy_sor[statusz].":".substr($egy_sor[logtime],0,13);
Line #148:$rmuv=substr($egy_sor[logtime],0,13).":".$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #149:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #150:$rmuv1=substr($egy_sor[logtime],0,13).":".$egy_sor[bizomanyos];
Line #151:$rmuv2=$egy_sor[bizomanyos];
Line #152:$rmuv2=substr($egy_sor[logtime],0,13);
Line #153:
Line #154:
Line #155:$L_NAP=$mai;
Line #156:$L_PHP="QJ_gyujtoKONTROLLflow.php?&gyujto=".$_GET[gyujto];
Line #157:include("QJ_listafej.php");
Line #158:
Line #159:if ($_GET[Analitika]=="Yes") $hr="<tr><td colspan=9><hr></td></tr>"; else $hr="";
Line #160:
Line #161:$hr="<td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td>";
Line #162:
Line #163:echo "<table border=0 width=100%>
Line #164:<tr bgcolor=silver>
Line #165:$hr
Line #166:</tr>";
Line #167:}
Line #168:
Line #169:if ($rmuv<>substr($egy_sor[logtime],0,13).":".$egy_sor[bizomanyos].":".$egy_sor[statusz]){
Line #170:if ($_GET[Analitika]=="Yes") $hr="<tr><td colspan=9><hr></td></tr>"; else $hr="";
Line #171:
Line #172:$irmuv="".substr($rmuv,-2)."  ".substr($rmuv,0,10);
Line #173:
Line #174:/*
Line #175:echo"<tr>
Line #176:
Line #177:
Line #178:</td>
Line #179:
Line #180:<td width=20 align=right >".number_format($rft)."</td>
Line #181:<td> Ft</td>
Line #182:<td width=20 align=right >".number_format($ri)."</td>
Line #183:<td> Db</td>
Line #184:</tr>$hr";
Line #185:*/
Line #186:
Line #187:$ri=0;
Line #188:$rft=0;
Line #189:
Line #190:$rmuv=substr($egy_sor[logtime],0,13).":".$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #191:}
Line #192:
Line #193:if ($rmuv1<>substr($egy_sor[logtime],0,13).":".$egy_sor[bizomanyos]){
Line #194:
Line #195:if ($_GET[Analitika]=="Yes") $hr="<tr><td colspan=9><hr></td></tr>"; else $hr="";
Line #196:$irmuv1="".substr($rmuv1,-2)."  ".substr($rmuv1,0,10);
Line #197:
Line #198:/*
Line #199:echo"<tr>
Line #200:
Line #201:
Line #202:</td>
Line #203:
Line #204:<td width=20 align=right >".number_format($rft1)."</td>
Line #205:<td> Ft</td>
Line #206:<td width=20 align=right >".number_format($ri1)."</td>
Line #207:<td> Db</td>
Line #208:</tr>$hr";
Line #209:*/
Line #210:
Line #211:$ri1=0;
Line #212:$rft1=0;
Line #213:
Line #214:
Line #215:$rmuv1=$egy_sor[bizomanyos].":".$egy_sor[statusz];
Line #216:$rmuv1=substr($egy_sor[logtime],0,13).":".$egy_sor[bizomanyos];
Line #217:
Line #218:}
Line #219:
Line #220:
Line #221:if ($rmuv2<>substr($egy_sor[logtime],0,13)){
Line #222:
Line #223:
Line #224:/*
Line #225:
Line #226:echo"<tr>
Line #227:
Line #228:
Line #229:</td>
Line #230:
Line #231:<td width=20 align=right >".number_format($rft2)."</td>
Line #232:<td> Ft</td>
Line #233:<td width=20 align=right >".number_format($ri2)."</td>
Line #234:<td> Db </td>
Line #235:</tr><tr><td colspan=9><hr></td></tr>";
Line #236:*/
Line #237:
Line #238:$ri2=0;
Line #239:$rft2=0;
Line #240:
Line #241:$rmuv2=$egy_sor[bizomanyos];
Line #242:$rmuv2=substr($egy_sor[logtime],0,13);
Line #243:}
Line #244:
Line #245:
Line #246:++$i;
Line #247:++$ri;
Line #248:++$ri1;
Line #249:++$ri2;
Line #250:if (substr($egy_sor[statusz],0,2)<>'El') {
Line #251: $rft=$rft+$egy_sor[ar];
Line #252: $rft1=$rft1+$egy_sor[ar];
Line #253: $rft2=$rft2+$egy_sor[ar];
Line #254: $ft =$ft+$egy_sor[ar];
Line #255:}
Line #256:
Line #257:
Line #258:if ($_GET[Analitika]=="Yes") {
Line #259:
Line #260:
Line #261:$sql_musor = "SELECT * FROM qj_musor WHERE datum_kod='$egy_sor[datum_kod]'";
Line #262:
Line #263:
Line #264:$musor = mysql_fetch_array( $sor_musor );
Line #265:if ($musor[erkezesi]=="Y") $hely=""; else $hely=" ".$egy_sor[szoveg];
Line #266:
Line #267:if ($_SESSION['login']=="BI(c)")
Line #268:$refA="<a target=infoframe href=BI_ediTable.php?&wjid=".$egy_sor[widarc]."&sqlfile=qj_jegy>".
Line #269:$egy_sor[wid]."</a>"; else $refA=$egy_sor[wid];
Line #270:
Line #271:IF ($_SESSION['login']=="BI(c)")
Line #272:$relW="<a target=infoframe href=QJ_analitika.php?&bizonylat=".$egy_sor[bizonylatszam].">".$egy_sor[bizonylatszam]."</a>";
Line #273:else $relW=$egy_sor[bizonylatszam];
Line #274:
Line #275:
Line #276:IF ($_SESSION['login']=="BI(c)")
Line #277:$rel=" <a target=infoframe href='BiViewTable.php?&tabla=$fajl&sql=//widarc=~".$egy_sor[widarc]."~'>".$egy_sor[bizonylatszam]."</a>";
Line #278:else
Line #279:$rel=$egy_sor[bizonylatszam];
Line #280:
Line #281:
Line #282:$jegywid=$egy_sor[widarc];
Line #283:$sql_jegy = "SELECT * FROM qj_jegy WHERE wid='$jegywid'";
Line #284:
Line #285:
Line #286:$jsor= mysql_fetch_array( $sor_jegy );
Line #287:
Line #288:
Line #289:if ($musor[rovid_helyszin]=="") $helyszin=$musor[helyszin]; else $helyszin=$musor[rovid_helyszin];
Line #290:
Line #291:if ($jsor[nyugta_szam]==$egy_sor[nyugta_szam] and $egy_sor[logtime]==$jsor[printdatum] and $egy_sor[logtime]<>$jsor[logtime])
Line #292:$ok="**OK**"; else $ok="**HIBA**";
Line #293:
Line #294:echo"<tr>
Line #295:<td align=right >$refA</td>
Line #296:<td align=right > $helyszin $hely </td>
Line #297:<td align=right > $musor[cim] $musor[datum]</td>
Line #298:<td align=right >$egy_sor[nyugta_szam] $jsor[nyugta_szam]</td>
Line #299:<td align=right > $egy_sor[ar_nev] $jsor[ar_nev]</td>
Line #300:<td align=right > $egy_sor[ar] $jsor[ar]</td>
Line #301:<td align=right > $rel Gy:$jsor[bizonylatszam]</td>
Line #302:<td >$egy_sor[statusz] $jsor[statusz]</td>
Line #303:<td >".$egy_sor[logtime]." $jsor[logtime]</td>
Line #304:<td >$egy_sor[bizomanyos] $ok</td>
Line #305:</tr>";
Line #306:$szin="";
Line #307:}
Line #308:}
Line #309:
Line #310:/*
Line #311:
Line #312:$irmuv="".substr($rmuv,-2)."  ".substr($rmuv,0,10);
Line #313:
Line #314:echo"<tr>
Line #315:
Line #316:
Line #317:</td>
Line #318:
Line #319:<td width=20 align=right >".number_format($rft)."</td>
Line #320:<td> Ft</td>
Line #321:<td width=20 align=right >".number_format($ri)."</td>
Line #322:<td> Db</td>
Line #323:</tr>";
Line #324:
Line #325:
Line #326:
Line #327:$irmuv1="".substr($rmuv1,-2)."  ".substr($rmuv1,0,10);
Line #328:
Line #329:echo"<tr>
Line #330:
Line #331:
Line #332:</td>
Line #333:
Line #334:<td width=20 align=right >".number_format($rft1)."</td>
Line #335:<td> Ft</td>
Line #336:<td width=20 align=right >".number_format($ri1)."</td>
Line #337:<td> Db</td>
Line #338:</tr>";
Line #339:
Line #340:
Line #341:
Line #342:
Line #343:echo"<tr>
Line #344:
Line #345:
Line #346:</td>
Line #347:
Line #348:<td width=20 align=right >".number_format($rft2)."</td>
Line #349:<td> Ft</td>
Line #350:<td width=20 align=right >".number_format($ri2)."</td>
Line #351:<td> Db</td>
Line #352:</tr><tr><td colspan=9><hr></td></tr>";
Line #353:if ($ft<>$rft2) {
Line #354:echo"<tr>
Line #355:
Line #356:
Line #357:</td>
Line #358:
Line #359:<td width=20 align=right >".number_format( $ft)."</td>
Line #360:<td> Ft</td>
Line #361:<td width=20 align=right >".number_format( $i)."</td>
Line #362:<td> Db</td>
Line #363:</tr>";
Line #364:
Line #365:}
Line #366:*/
Line #367:
Line #368:echo"<tr bgcolor=silver>
Line #369:
Line #370:
Line #371:</td>
Line #372:
Line #373:<td width=20 align=right >".number_format( $ft)."</td>
Line #374:<td> Ft</td>
Line #375:<td width=20 align=right >".number_format( $i)."</td>
Line #376:<td> Db</td>
Line #377:<td colspan=3>  </td>
Line #378:</tr>";
Line #379:
Line #380:echo "
Line #381:</table>";
Line #382:
Line #383:if (isset($_GET[nyomtat])) {
Line #384:include("QJ_listaveg.php");
Line #385:
Line #386:echo("<body onload='printit()'></body>");
Line #387:
Line #388:?>
Line #389:<SCRIPT Language="Javascript">
Line #390:
Line #391:function printit(){
Line #392:
Line #393:window.print();
Line #394:
Line #395:}
Line #396:
Line #397:
Line #398:</script>
Line #399:<?PHP
Line #400:}