QJ_napiRESZLET.inc
Line #0:<?php
Line #1:
Line #2:if (!isset($_SESSION[SQL_inet])) {
Line #3:
Line #4:++$_SESSION[QJ_hiba];
Line #5:
Line #6:echo "<script>
Line #7:
Line #8: window.open('QJ_musorKORR.php','sframe');
Line #9: </script>";
Line #10:}
Line #11:$_SESSION[QJ_hiba]=0;
Line #12:
Line #13:if (isset($_GET[nyomtat])) {
Line #14:?>
Line #15:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #16:<?PHP
Line #17:}
Line #18:
Line #19:
Line #20:$login=$_SESSION[login];
Line #21:$admin=$_SESSION[admin];
Line #22:
Line #23://$wer1=" and (left(logtime,10)='".$_SESSION[L_nap]."' or left(future,10)='".$_SESSION[L_nap]."') ";
Line #24:
Line #25:IF (ISSET($_SESSION[L_nap]) and $_SESSION[L_nap]<>"*")
Line #26:$wer1=" and (left(logtime,10)='".$_SESSION[L_nap]."' or left(ReszletDate,10)='".$_SESSION[L_nap]."') ";
Line #27:else $wer1="";
Line #28:
Line #29:IF (ISSET($_SESSION[L_bizomanyos]) and $_SESSION[L_bizomanyos]<>"*")
Line #30:$login=$_SESSION[L_bizomanyos];
Line #31:
Line #32:$wer2=" and bizomanyos='".$login."'";
Line #33:
Line #34:IF ($_SESSION[L_bizomanyos]=="*" or $_SESSION[L_bizomanyos]=="0" ) $wer2="";
Line #35:
Line #36:if ($_SESSION['admin']=="ADMIN") $nev=$login; else $nev=$_SESSION['login_nev'];
Line #37:
Line #38:$szin="";
Line #39:
Line #40:$L_NAP=$_SESSION[L_nap];
Line #41:$L_user=$_SESSION[L_bizomanyos];
Line #42:
Line #43:if ($L_NAP<>"")
Line #44:
Line #45:else
Line #46:
Line #47:
Line #48:if (isset($_GET[mod]) and $_GET[mod]==0 )
Line #49:
Line #50:
Line #51:$werR="";
Line #52:if (isset($_GET[mod]) and $_GET[mod]==1 ) {
Line #53:
Line #54:$werR=" and Reszlet1>0 and Reszlet2=0 ";
Line #55:
Line #56:
Line #57:}
Line #58:
Line #59:if (isset($_GET[mod]) and $_GET[mod]==2 ) {
Line #60:
Line #61:$werR=" and Reszlet1>0 and Reszlet2>0 ";
Line #62:
Line #63:}
Line #64:
Line #65:$L_PHP="QJ_napiRESZLET.php?&mod=".$_GET[mod];
Line #66:include("QJ_listafej.php");
Line #67:
Line #68:echo "
Line #69:<table border=1 width=100%>
Line #70:<tr bgcolor=silver>
Line #71:
Line #72:
Line #73:<td align=right width=40>Db</td>
Line #74:
Line #75:
Line #76:
Line #77:
Line #78:<td align=right width=10>&nbsp;</td>
Line #79:
Line #80:
Line #81:
Line #82:</tr>";
Line #83:
Line #84:$szin="";
Line #85:$bosft=0;
Line #86:$fosft=0;
Line #87:$f2osft=0;
Line #88:$osft=0;
Line #89:$i=0;
Line #90:
Line #91:$parancs="SELECT * FROM qj_jlog where future<>'*' $wer1 $wer2 $werR ORDER BY wid ";
Line #92:
Line #93:if (isset($_GET[mod]) and $_GET[mod]==0 )
Line #94:$parancs="SELECT * FROM qj_jlog where future<>'*' $wer2 ORDER BY wid ";
Line #95:
Line #96://?// echo($parancs."<hr>");
Line #97:
Line #98:
Line #99:
Line #100:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #101:{
Line #102:
Line #103:++$i;
Line #104:
Line #105:if ($egy_sor[Reszlet1]<>"" and $egy_sor[Reszlet1]>0)
Line #106:{
Line #107:
Line #108:$vevokod=$egy_sor[vevokod];
Line #109:$info1="&nbsp;";
Line #110:$info2="&nbsp;";
Line #111:
Line #112:if ($vevokod>0) {
Line #113:$vevoker = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #114:
Line #115:$ct_sor = mysql_fetch_array($ctar);
Line #116:
Line #117:$info1="
Line #118:<A target=sframe href='QJ_cimUP.php?&wjid=".$vevokod."&CimUp=QJ_gyujto.php&sqlfile=qj_cimtar'>
Line #119:<IMG width=20 height=20 SRC='../_Screen/edit.png' border=0></a></font>&nbsp;<b>$ct_sor[nev]</b>";
Line #120:
Line #121:$info2="$ct_sor[irsz]&nbsp;<b>$ct_sor[telepules]</b><br>$ct_sor[cim]";
Line #122:}
Line #123:$memo="&nbsp;";
Line #124:$br="";
Line #125:
Line #126:if ($egy_sor[ReszletMemo]<>"") { $memo="Memo:<b>".$egy_sor[ReszletMemo]."</b>" ; $br="<br>"; }
Line #127:
Line #128:
Line #129:
Line #130:
Line #131://if ($egy_sor[Reszlet2]>0) $konyvido=substr($egy_sor[future],0,10); else $konyvido=substr($egy_sor[logtime],0,10);
Line #132:// ??? NEM IDE IR
Line #133:if ($egy_sor[Reszlet2]>0) $konyvido=substr($egy_sor[ReszletDate],0,10); else $konyvido=substr($egy_sor[logtime],0,10);
Line #134:
Line #135:if ($L_NAP=="") { $memo=$memo.$br."Nap:<b>".substr($egy_sor[logtime],0,10)."</b>" ; $szin="blue";}
Line #136:
Line #137:
Line #138:$hatralek=$egy_sor[osszft]-$egy_sor[Reszlet1]-$egy_sor[Reszlet2];
Line #139:
Line #140:$ir=true;
Line #141:
Line #142:if (isset($_GET[mod]) and $_GET[mod]==0 ) {
Line #143:
Line #144:if ($hatralek>0 ) $ir=true; else $ir=false;
Line #145:}
Line #146:
Line #147:if ($ir==true) {
Line #148:
Line #149:echo"<tr>
Line #150:<td align=right width=40><font color=$szin<b> $egy_sor[wid] </b></font></td>
Line #151:<td align=right width=80><font color=$szin><b>".$egy_sor[bizomanyos]."<br>".$konyvido."</b></font></td>
Line #152:<td align=right width=40><font color=$szin><b>".number_format($egy_sor[osszdb])."</b></font></td>
Line #153:<td align=right width=80><font color=$szin><b>".number_format($egy_sor[osszft])."</b></font></td>
Line #154:<td align=right width=80 bgcolor=gold ><font color=$szin><b>".number_format($egy_sor[Reszlet1])."</b></font></td>
Line #155:<td align=right width=80 bgcolor=gold ><font color=$szin><b>".number_format($egy_sor[Reszlet2])."</b></font></td>
Line #156:<td align=right width=80 ><font color=$szin><b>".number_format(($egy_sor[osszft]-$egy_sor[Reszlet1]-$egy_sor[Reszlet2]))."</b></font></td>
Line #157:<td align=right width=10 ><a target=sframe href=QJ_reszletFIZET.php?&wjid=$egy_sor[wid]>
Line #158:
Line #159:<td align=left width=150 ><font color=$szin><b>".$info1."</b></font></td>
Line #160:<td align=left width=150><font color=$szin><b> $info2 </b></font></td>
Line #161:<td align=left ><font color=$szin>$memo</font></td>
Line #162:</tr>";
Line #163:
Line #164:$osft=$osft+$egy_sor[osszft]-$egy_sor[Reszlet1]-$egy_sor[Reszlet2];
Line #165:$bosft=$bosft+$egy_sor[osszft];
Line #166:$fosft=$fosft+$egy_sor[Reszlet1];
Line #167:$f2osft=$f2osft+$egy_sor[Reszlet2];
Line #168:}
Line #169:
Line #170:$szin="";
Line #171:}}
Line #172:
Line #173:echo "
Line #174:
Line #175:<td><b>".number_format($bosft)."<b></td>
Line #176:<td><b>".number_format($fosft)."<b></td>
Line #177:<td><b>".number_format($f2osft)."<b></td>
Line #178:<td><b>".number_format($osft)."<b></td>
Line #179:<td align=left colspan=4>&nbsp;</td></tr>
Line #180:</table>
Line #181:
Line #182:";
Line #183:
Line #184:
Line #185:
Line #186:if (isset($_GET[nyomtat])) {
Line #187:include("QJ_listaveg.php");
Line #188:
Line #189:
Line #190:echo("<body onload='printit()'></body>");
Line #191:
Line #192:?>
Line #193:<SCRIPT Language="Javascript">
Line #194:
Line #195:function printit(){
Line #196:
Line #197:
Line #198:window.print();
Line #199:///////////////////////////////////////
Line #200://window.open('QJ_musorKORR.php','sframe');
Line #201:///////////////////////////////////////
Line #202:
Line #203:}
Line #204:
Line #205:
Line #206:</script>
Line #207:<?PHP
Line #208:}
Line #209:
Line #210:
Line #211://~*~// QJ_fulljegy.php
Line #212:
Line #213:?>