Bi-Dir

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