Bi-Dir

QJ_cimletLIST.old

Line #0:<?php
Line #1:$L_PHP="QJ_cimletLIST.php";
Line #2:$SelFile="qj_cimlet where future<>'*' ";
Line #3:if (isset($_GET[musor_kod])) $_SESSION[SUBmusor_kod]=$_GET[musor_kod];
Line #4: else $_GET[musor_kod]=$_SESSION[SUBmusor_kod];
Line #5:
Line #6:$wer="";
Line #7:
Line #8:if (isset($_GET[nyomtat])) {
Line #9:?>
Line #10:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #11:<?PHP
Line #12:} else {
Line #13:
Line #14:include("../_inc_QJ/QJ_listaSELECT.inc");
Line #15:
Line #16:}
Line #17:
Line #18:
Line #19:
Line #20:$login=$_SESSION['login'];
Line #21:
Line #22:
Line #23:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #24:$wer1=" and left(szoveg,7)='".substr($_SESSION[L_nap],0,7)."'"; 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:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" or $_SESSION[L_bizomanyos]=="") $wer2="";
Line #32:
Line #33:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #34:
Line #35:
Line #36:///$L_PHP="QJ_cimletLIST.php";
Line #37:include("QJ_listafej.php");
Line #38:
Line #39:echo "<table border=1 width=100%>
Line #40:<tr bgcolor=silver>
Line #41:
Line #42:
Line #43:
Line #44:
Line #45:
Line #46:
Line #47:
Line #48:<td align=right width=50 >Bank</td>
Line #49:
Line #50:
Line #51:</tr>";
Line #52:
Line #53:
Line #54:
Line #55://and osszft<>0
Line #56:
Line #57:
Line #58:$meres = "SELECT * FROM qj_cimlet where future<>'*' and arforma='*' and bizomanyos<>''
Line #59:and bizomanyos<>'0' $wer1 $wer2 $_SESSION[SUBwer] order by bizomanyos,szoveg ";
Line #60:
Line #61:
Line #62:
Line #63:/*
Line #64:while ( $egy_sor = mysql_fetch_array( $mered))
Line #65:{
Line #66:
Line #67:
Line #68:
Line #69:$ft2=$egy_sor[KPft];
Line #70:$ft3=$egy_sor[UCS_Ft];
Line #71:$ft6=$egy_sor[UT_Ft];
Line #72:$ft4=$egy_sor[Bank_Ft];
Line #73:$ft5=$egy_sor[Online_Ft];
Line #74:$ft5=$egy_sor[Online_Ft];
Line #75:$ft5=$egy_sor[Online_Ft];
Line #76:
Line #77:// wid widarc LEZART KONYVELVE usr_kod szoveg archiv future
Line #78:// bizomanyos osszft osszdb Reszlet1 Reszlet1No Reszlet2
Line #79:// Reszlet2No ReszletMemo ReszletDate KPft UCS_Ft
Line #80:// UCS_memo UT_Ft UT_memo ST_Ft Bank_Ft Bank_memo
Line #81:// Kedv_Ft Kedv_memo status arforma vevokod Online_Ft
Line #82:// elonyom_date eloelad_date work
Line #83:// ELONYOMTAT ELONY_FT ELONYELAD ELONYEL_FT MEGJEGYZES logtime
Line #84:echo("
Line #85:<tr bgcolor=silver>
Line #86: <td align=right>$egy_sor[wid]</td>
Line #87: <td align=right>$egy_sor[szoveg]</td>
Line #88: <td align=right >".number_format($ft1)."</td>
Line #89: <td align=right >".number_format($ft2)."</td>
Line #90: <td align=right >".number_format($ft6)."</td>
Line #91: <td align=right >".number_format($ft3)."</td>
Line #92: <td align=right >".number_format($ft4)."</td>
Line #93: <td align=right >".number_format($ft5)."</td>
Line #94: <td align=right >".$egy_sor[ELONY_FT]."</td>
Line #95: <td align=right >".$egy_sor[ELONYEL_FT]."</td>
Line #96: <td align=right >".$egy_sor[MEGJEGYZES]."</td>
Line #97: <td align=right >$hiba</td>
Line #98:</tr>");
Line #99:
Line #100:} */
Line #101:
Line #102://$meres = "SELECT * FROM qj_cimlet where arforma='*' and bizomanyos<>'' and bizomanyos<>'0' and left(szoveg,4)='2010' $wer1 $wer2 order by bizomanyos,szoveg ";
Line #103:$meres = "SELECT * FROM qj_cimlet where future<>'*' and arforma='*' and bizomanyos<>''
Line #104:and bizomanyos<>'0' $wer1 $wer2 $_SESSION[SUBwer] order by bizomanyos,szoveg ";
Line #105:
Line #106:
Line #107:
Line #108://?//echo($meres."<hr>");
Line #109:
Line #110:$aktbizo="?";
Line #111:$i=0;
Line #112:$ft1=0;
Line #113:$oft1=0;
Line #114:$ft2=0;
Line #115:$oft2=0;
Line #116:$ft3=0;
Line #117:$oft3=0;
Line #118:$ft4=0;
Line #119:$oft4=0;
Line #120:$ft5=0;
Line #121:$oft5=0;
Line #122:
Line #123:$ft6=0;
Line #124:$oft6=0;
Line #125:
Line #126:$oStorno=0;
Line #127:$moStorno=0;
Line #128:
Line #129:while ( $egy_sor = mysql_fetch_array( $mered))
Line #130:{
Line #131:
Line #132:if ($aktbizo<>$egy_sor[bizomanyos] and $aktbizo<>"?") {
Line #133:
Line #134:if ($oStorno>0) {
Line #135:
Line #136:$oStorno=0;
Line #137:} else $hiba="";
Line #138:
Line #139:
Line #140:echo("
Line #141:<tr bgcolor=silver>
Line #142:
Line #143: <td align=right >".number_format($ft1)."</td>
Line #144: <td align=right >".number_format($ft2)."</td>
Line #145: <td align=right >".number_format($ft6)."</td>
Line #146: <td align=right >".number_format($ft3)."</td>
Line #147: <td align=right >".number_format($ft4)."</td>
Line #148: <td align=right >".number_format($ft5)."</td>
Line #149: <td align=right >$hiba</td>
Line #150:</tr>");
Line #151:
Line #152:
Line #153:$ft1=0;
Line #154:$ft2=0;
Line #155:$ft3=0;
Line #156:$ft4=0;
Line #157:$ft5=0;
Line #158:$ft6=0;
Line #159:
Line #160:}
Line #161:
Line #162:++$i;
Line #163:$aktbizo=$egy_sor[bizomanyos];
Line #164:
Line #165:$wid=$egy_sor[wid];
Line #166:$hiba="";
Line #167:
Line #168:IF ($_SESSION[admin]=="ADMIN") $rel="<a target=adatframe href='BiViewTable.php?&tabla=
Line #169:qj_cimlet&sql=// wid=~$wid~ '>".$wid."</a>";
Line #170:else $rel=$i;
Line #171:
Line #172:
Line #173:
Line #174:$osszft=$egy_sor[KPft]+$egy_sor[UCS_Ft]+$egy_sor[Bank_Ft]+$egy_sor[Online_Ft]+$egy_sor[UT_Ft];
Line #175:$ft1=$ft1+$osszft;
Line #176:$oft1=$oft1+$osszft;
Line #177://$oft1=$oft1+$egy_sor[osszft];
Line #178:
Line #179:$ft2=$ft2+$egy_sor[KPft];
Line #180:$oft2=$oft2+$egy_sor[KPft];
Line #181:
Line #182:$ft3=$ft3+$egy_sor[UCS_Ft];
Line #183:$oft3=$oft3+$egy_sor[UCS_Ft];
Line #184:
Line #185:$ft6=$ft6+$egy_sor[UT_Ft];
Line #186:$oft6=$oft6+$egy_sor[UT_Ft];
Line #187:
Line #188:$ft4=$ft4+$egy_sor[Bank_Ft];
Line #189:$oft4=$oft4+$egy_sor[Bank_Ft];
Line #190:
Line #191://$ft5=$ft5+$egy_sor[Online_Ft];
Line #192://$oft5=$oft5+$egy_sor[Online_Ft];
Line #193:
Line #194:$ft5=$ft5+$egy_sor[Kedv_Ft];
Line #195:$oft5=$oft5+$egy_sor[Kedv_Ft];
Line #196:
Line #197:$wnap=$egy_sor[szoveg];
Line #198:$reln="<a target=adatframe href='QJ_napi.php?&L_nap=$wnap&L_biz=$aktbizo'>".$wnap."</a>";
Line #199:
Line #200:if (isset($_SESSION[qontroll])) {
Line #201:
Line #202://$aktbizo=$_GET[bizo];
Line #203://$wnap=$_GET[wnap];
Line #204:
Line #205:$jegy_IR="<a target=adatframe href='QJ_fulljegySEL.php?&aktbizo=".$aktbizo."&wnap=".$wnap."' >";
Line #206:
Line #207:$JSQL="SELECT * FROM qj_jegy where bizomanyos='$aktbizo' and $_SESSION[SQL_elad] and left(logtime,10)='$wnap' and ($_SESSION[SQL_berlet] or $_SESSION[SQL_jegy]) ";
Line #208:
Line #209:
Line #210:
Line #211:$JFT=0;
Line #212:$JDB=0;
Line #213:while ( $Jsor = mysql_fetch_array( $Jeredmeny ))
Line #214:{
Line #215:$JFT=$JFT+$Jsor[ar];
Line #216:++$JDB;
Line #217:}
Line #218:
Line #219:if ($JFT<>$osszft) {
Line #220:$elteres=$JFT-$osszft;
Line #221:
Line #222:
Line #223:else $hiba="";
Line #224:
Line #225:}
Line #226:
Line #227:
Line #228:/*if ($egy_sor[UT_Ft]>0) {
Line #229:
Line #230: $oStorno=$oStorno+$egy_sor[UT_Ft];
Line #231: $moStorno=$moStorno+$egy_sor[UT_Ft];
Line #232:} */
Line #233:
Line #234:if ($egy_sor[ELONY_FT]>0) {
Line #235:
Line #236:}
Line #237:if ($egy_sor[ELONYEL_FT]>0) {
Line #238:
Line #239:}
Line #240:
Line #241://if ($osszft<>0)
Line #242:
Line #243:// <td align=right >".number_format($egy_sor[Kedv_FtOnline_Ft])."</td>
Line #244:
Line #245:echo("
Line #246:<tr>
Line #247: <td >$rel</td>
Line #248: <td >$reln</td>
Line #249: <td >$egy_sor[bizomanyos]</td>
Line #250: <td align=right >".number_format($osszft)."</td>
Line #251: <td align=right >".number_format($egy_sor[KPft])."</td>
Line #252: <td align=right >".number_format($egy_sor[UT_Ft])."</td>
Line #253: <td align=right >".number_format($egy_sor[UCS_Ft])."</td>
Line #254: <td align=right >".number_format($egy_sor[Bank_Ft])."</td>
Line #255: <td align=right >".number_format($egy_sor[Kedv_Ft])."</td>
Line #256: <td align=right >$hiba$egy_sor[MEGJEGYZES]</td>
Line #257:</tr>");
Line #258:
Line #259:}
Line #260:
Line #261:
Line #262:if ($oStorno>0) {
Line #263:
Line #264:$oStorno=0;
Line #265:} else $hiba="";
Line #266:
Line #267:
Line #268:echo("
Line #269:<tr bgcolor=silver>
Line #270:
Line #271: <td align=right >".number_format($ft1)."</td>
Line #272: <td align=right >".number_format($ft2)."</td>
Line #273: <td align=right >".number_format($ft6)."</td>
Line #274: <td align=right >".number_format($ft3)."</td>
Line #275: <td align=right >".number_format($ft4)."</td>
Line #276: <td align=right >".number_format($ft5)."</td>
Line #277: <td align=right >$hiba</td>
Line #278:</tr>");
Line #279:
Line #280:
Line #281:if ($oft1<>$ft1) {
Line #282:
Line #283:if ($moStorno>0) {
Line #284:
Line #285:$moStorno=0;
Line #286:} else $hiba="";
Line #287:
Line #288:
Line #289:echo("
Line #290:<tr bgcolor=silver>
Line #291:
Line #292: <td align=right >".number_format($oft1)."</td>
Line #293: <td align=right >".number_format($oft2)."</td>
Line #294: <td align=right >".number_format($oft6)."</td>
Line #295: <td align=right >".number_format($oft3)."</td>
Line #296: <td align=right >".number_format($oft4)."</td>
Line #297: <td align=right >".number_format($oft5)."</td>
Line #298: <td align=right >$hiba</td>
Line #299:</tr>");
Line #300:}
Line #301:
Line #302:echo "
Line #303:</table>";
Line #304:
Line #305://include("QJ_varlist.php");
Line #306:
Line #307:if (isset($_GET[nyomtat])) {
Line #308:include("QJ_listaveg.php");
Line #309:
Line #310:
Line #311:echo("<body onload='printit()'></body>");
Line #312:
Line #313:?>
Line #314:<SCRIPT Language="Javascript">
Line #315:
Line #316:function printit(){
Line #317:
Line #318:window.print();
Line #319:
Line #320:}
Line #321:
Line #322:// End -->
Line #323:</SCRIPT>
Line #324:<?PHP
Line #325:}
Line #326:?>
Line #327:<SCRIPT Language="Javascript">
Line #328:
Line #329://alert("e");
Line #330:
Line #331:function clock_e() {
Line #332:day_e = new Date();
Line #333:hrNow = day_e.getHours();
Line #334:mnNow = day_e.getMinutes();
Line #335:scNow = day_e.getSeconds();
Line #336:miNow = day_e.getTime();
Line #337:
Line #338:hour = hrNow;
Line #339:
Line #340:if (mnNow <= 9) {
Line #341:min = "0" + mnNow;
Line #342:}
Line #343:else (min = mnNow)
Line #344:if (scNow <= 9) {
Line #345:secs = "0" + scNow;
Line #346:} else {
Line #347:secs = scNow;
Line #348:}
Line #349:
Line #350:time = hour + ":" + min + ":" + secs;
Line #351:
Line #352:Visit_e = day_e.getTime();
Line #353://alert(Visit_s);
Line #354:parent.potframe.document.form.Bi_stop.value = time;
Line #355:}
Line #356:clock_e();
Line #357:
Line #358://~*~// QJ_cimletLIST.php
Line #359:
Line #360:</script>