QL_cimletLIST.inc
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/QC_evhoSELECT.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 ><b>Bank</b></td>
Line #49:
Line #50:
Line #51:</tr>";
Line #52:
Line #53:
Line #54:
Line #55://and osszft<>0
Line #56:
Line #57:$meres = "SELECT * FROM qj_cimlet where future<>'*' and arforma='*' and bizomanyos<>''
Line #58:and bizomanyos<>'0' $wer1 $wer2 $_SESSION[SUBbiz] order by bizomanyos,szoveg ";
Line #59:
Line #60://?//echo($meres."<hr>".$_SESSION[SUBbiz]."<hr>*!*<hr>");
Line #61:
Line #62:
Line #63:
Line #64://$meres = "SELECT * FROM qj_cimlet where arforma='*' and bizomanyos<>'' and bizomanyos<>'0' and left(szoveg,4)='2010' $wer1 $wer2 order by bizomanyos,szoveg ";
Line #65:$meres = "SELECT * FROM qj_cimlet where future<>'*' and arforma='*' and bizomanyos<>''
Line #66:and bizomanyos<>'0' $wer1 $wer2 $_SESSION[SUBbiz] order by bizomanyos,szoveg ";
Line #67:
Line #68:
Line #69:
Line #70://?//echo($meres."<hr>");
Line #71:
Line #72:$aktbizo="?";
Line #73:$i=0;
Line #74:$ft1=0;
Line #75:$oft1=0;
Line #76:$ft2=0;
Line #77:$oft2=0;
Line #78:$ft3=0;
Line #79:$oft3=0;
Line #80:$ft4=0;
Line #81:$oft4=0;
Line #82:$ft5=0;
Line #83:$oft5=0;
Line #84:
Line #85:$ft6=0;
Line #86:$oft6=0;
Line #87:
Line #88:$oStorno=0;
Line #89:$moStorno=0;
Line #90:
Line #91:while ( $egy_sor = mysql_fetch_array( $mered))
Line #92:{
Line #93:
Line #94:if ($aktbizo<>$egy_sor[bizomanyos] and $aktbizo<>"?") {
Line #95:
Line #96:if ($oStorno>0) {
Line #97:
Line #98:$oStorno=0;
Line #99:} else $hiba="";
Line #100:
Line #101:
Line #102:echo("
Line #103:<tr bgcolor=silver>
Line #104:
Line #105: <td align=right ><b>".number_format($ft1)."</b></td>
Line #106: <td align=right ><b>".number_format($ft2)."</b></td>
Line #107: <td align=right ><b>".number_format($ft6)."</b></td>
Line #108: <td align=right ><b>".number_format($ft3)."</b></td>
Line #109: <td align=right ><b>".number_format($ft4)."</b></td>
Line #110: <td align=right ><b>".number_format($ft5)."</b></td>
Line #111: <td align=right >$hiba</td>
Line #112:</tr>");
Line #113:
Line #114:
Line #115:$ft1=0;
Line #116:$ft2=0;
Line #117:$ft3=0;
Line #118:$ft4=0;
Line #119:$ft5=0;
Line #120:$ft6=0;
Line #121:
Line #122:}
Line #123:
Line #124:++$i;
Line #125:$aktbizo=$egy_sor[bizomanyos];
Line #126:
Line #127:$wid=$egy_sor[wid];
Line #128:$hiba="";
Line #129:
Line #130:IF ($_SESSION[admin]=="ADMIN") $rel="<a target=adatframe href='BiViewTable.php?&tabla=
Line #131:qj_cimlet&sql=// wid=~$wid~ '>".$wid."</a>";
Line #132:else $rel=$i;
Line #133:
Line #134:
Line #135:
Line #136:$osszft=$egy_sor[KPft]+$egy_sor[UCS_Ft]+$egy_sor[Bank_Ft]+$egy_sor[Online_Ft]+$egy_sor[UT_Ft];
Line #137:$ft1=$ft1+$osszft;
Line #138:$oft1=$oft1+$osszft;
Line #139://$oft1=$oft1+$egy_sor[osszft];
Line #140:
Line #141:$ft2=$ft2+$egy_sor[KPft];
Line #142:$oft2=$oft2+$egy_sor[KPft];
Line #143:
Line #144:$ft3=$ft3+$egy_sor[UCS_Ft];
Line #145:$oft3=$oft3+$egy_sor[UCS_Ft];
Line #146:
Line #147:$ft6=$ft6+$egy_sor[UT_Ft];
Line #148:$oft6=$oft6+$egy_sor[UT_Ft];
Line #149:
Line #150:$ft4=$ft4+$egy_sor[Bank_Ft];
Line #151:$oft4=$oft4+$egy_sor[Bank_Ft];
Line #152:
Line #153://$ft5=$ft5+$egy_sor[Online_Ft];
Line #154://$oft5=$oft5+$egy_sor[Online_Ft];
Line #155:
Line #156:$ft5=$ft5+$egy_sor[Kedv_Ft];
Line #157:$oft5=$oft5+$egy_sor[Kedv_Ft];
Line #158:
Line #159:$wnap=$egy_sor[szoveg];
Line #160:$reln="<a target=adatframe href='QJ_napi.php?&L_nap=$wnap&L_biz=$aktbizo'>".$wnap."</a>";
Line #161:
Line #162:if (isset($_SESSION[qontroll])) {
Line #163:
Line #164://$aktbizo=$_GET[bizo];
Line #165://$wnap=$_GET[wnap];
Line #166:
Line #167:$jegy_IR="<a target=adatframe href='QJ_fulljegySEL.php?&aktbizo=".$aktbizo."&wnap=".$wnap."' >";
Line #168:
Line #169:$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 #170:
Line #171:
Line #172:
Line #173:$JFT=0;
Line #174:$JDB=0;
Line #175:while ( $Jsor = mysql_fetch_array( $Jeredmeny ))
Line #176:{
Line #177:$JFT=$JFT+$Jsor[ar];
Line #178:++$JDB;
Line #179:}
Line #180:
Line #181:if ($JFT<>$osszft) {
Line #182:$elteres=$JFT-$osszft;
Line #183:
Line #184:
Line #185:else $hiba="";
Line #186:
Line #187:}
Line #188:
Line #189:
Line #190:/*if ($egy_sor[UT_Ft]>0) {
Line #191:
Line #192: $oStorno=$oStorno+$egy_sor[UT_Ft];
Line #193: $moStorno=$moStorno+$egy_sor[UT_Ft];
Line #194:} */
Line #195:
Line #196:if ($egy_sor[ELONY_FT]>0) {
Line #197:
Line #198:}
Line #199:if ($egy_sor[ELONYEL_FT]>0) {
Line #200:
Line #201:}
Line #202:
Line #203://if ($osszft<>0)
Line #204:
Line #205:// <td align=right ><b>".number_format($egy_sor[Kedv_FtOnline_Ft])."</b></td>
Line #206:
Line #207: $rel="<a target=infoframe href='QJ_feladIR.php?&wjid=$wid'><img src='../_Screen/print.png' border=0>".$wid."</a>";
Line #208:
Line #209:echo("
Line #210:<tr>
Line #211: <td >$rel</td>
Line #212: <td >$reln</td>
Line #213: <td >$egy_sor[bizomanyos]</td>
Line #214: <td align=right ><b>".number_format($osszft)."</b></td>
Line #215: <td align=right ><b>".number_format($egy_sor[KPft])."</b></td>
Line #216: <td align=right ><b>".number_format($egy_sor[UT_Ft])."</b></td>
Line #217: <td align=right ><b>".number_format($egy_sor[UCS_Ft])."</b></td>
Line #218: <td align=right ><b>".number_format($egy_sor[Bank_Ft])."</b></td>
Line #219: <td align=right ><b>".number_format($egy_sor[Kedv_Ft])."</b></td>
Line #220: <td align=right >$hiba<b>$egy_sor[MEGJEGYZES]</b></td>
Line #221:</tr>");
Line #222:
Line #223:}
Line #224:
Line #225:
Line #226:if ($oStorno>0) {
Line #227:
Line #228:$oStorno=0;
Line #229:} else $hiba="";
Line #230:
Line #231:
Line #232:echo("
Line #233:<tr bgcolor=silver>
Line #234:
Line #235: <td align=right ><b>".number_format($ft1)."</b></td>
Line #236: <td align=right ><b>".number_format($ft2)."</b></td>
Line #237: <td align=right ><b>".number_format($ft6)."</b></td>
Line #238: <td align=right ><b>".number_format($ft3)."</b></td>
Line #239: <td align=right ><b>".number_format($ft4)."</b></td>
Line #240: <td align=right ><b>".number_format($ft5)."</b></td>
Line #241: <td align=right >$hiba</td>
Line #242:</tr>");
Line #243:
Line #244:
Line #245:if ($oft1<>$ft1) {
Line #246:
Line #247:if ($moStorno>0) {
Line #248:
Line #249:$moStorno=0;
Line #250:} else $hiba="";
Line #251:
Line #252:
Line #253:echo("
Line #254:<tr bgcolor=silver>
Line #255:
Line #256: <td align=right ><b>".number_format($oft1)."</b></td>
Line #257: <td align=right ><b>".number_format($oft2)."</b></td>
Line #258: <td align=right ><b>".number_format($oft6)."</b></td>
Line #259: <td align=right ><b>".number_format($oft3)."</b></td>
Line #260: <td align=right ><b>".number_format($oft4)."</b></td>
Line #261: <td align=right ><b>".number_format($oft5)."</b></td>
Line #262: <td align=right >$hiba</td>
Line #263:</tr>");
Line #264:}
Line #265:
Line #266:echo "
Line #267:</table>";
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:
Line #275:echo("<body onload='printit()'></body>");
Line #276:
Line #277:?>
Line #278:<SCRIPT Language="Javascript">
Line #279:
Line #280:function printit(){
Line #281:
Line #282:window.print();
Line #283:
Line #284:}
Line #285:
Line #286:// End -->
Line #287:</SCRIPT>
Line #288:<?PHP
Line #289:}
Line #290:?>
Line #291:<SCRIPT Language="Javascript">
Line #292:
Line #293://alert("e");
Line #294:
Line #295:function clock_e() {
Line #296:day_e = new Date();
Line #297:hrNow = day_e.getHours();
Line #298:mnNow = day_e.getMinutes();
Line #299:scNow = day_e.getSeconds();
Line #300:miNow = day_e.getTime();
Line #301:
Line #302:hour = hrNow;
Line #303:
Line #304:if (mnNow <= 9) {
Line #305:min = "0" + mnNow;
Line #306:}
Line #307:else (min = mnNow)
Line #308:if (scNow <= 9) {
Line #309:secs = "0" + scNow;
Line #310:} else {
Line #311:secs = scNow;
Line #312:}
Line #313:
Line #314:time = hour + ":" + min + ":" + secs;
Line #315:
Line #316:Visit_e = day_e.getTime();
Line #317://alert(Visit_s);
Line #318:parent.potframe.document.form.Bi_stop.value = time;
Line #319:}
Line #320:clock_e();
Line #321:
Line #322://~*~// QJ_cimletLIST.php
Line #323:
Line #324:</script>