QJ_felad.old
Line #0:<?php
Line #1:////////////////////
Line #2:
Line #3:////////////////////
Line #4://?// QJ_napi.php : $_SESSION[$rmuv]=$rft;
Line #5://?//include("QJ_varlist.php");
Line #6:
Line #7:$wery = "SELECT * from qj_login where email_kod='$_SESSION[L_bizomanyos]' ";
Line #8:$stid = mysql_query($wery) ;
Line #9:
Line #10:$egy_sor = mysql_fetch_array($stid);
Line #11:
Line #12:
Line #13://?//echo($wery.$Bizomanyos."<hr>");
Line #14:
Line #15://?//echo($_GET[L_nap]." GET ?<hr>");
Line #16:
Line #17:if (isset($_GET[L_nap])) {
Line #18:
Line #19:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0" ;
Line #20:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #21:
Line #22://?//echo($sel."<hr>");
Line #23://?//include("QJ_varlist.php");
Line #24:
Line #25:$nur=mysql_num_rows($sql);
Line #26:
Line #27:if ($nur==0)
Line #28:{
Line #29:$ins ="
Line #30:INSERT INTO `qj_cimlet`
Line #31:( `usr_kod`, `widarc`, `bizomanyos`, `status`, `szoveg`, `arforma`
Line #32:) VALUES (
Line #33:
Line #34:)";
Line #35:
Line #36://?//echo($ins."<hr>");
Line #37:
Line #38:mysql_query($ins) or die($ins." Hiba az insertben");
Line #39:
Line #40:}
Line #41:
Line #42:
Line #43:
Line #44:/*if ($Bizomanyos<>"") {
Line #45:$_POST[elonyom_Ft]=$_POST[KPft];
Line #46:$_POST[KPft]=0;
Line #47:} else
Line #48:$_POST[KPft]=$_POST[KPft]-$_POST[elonyom_Ft]+$_POST[eloelad_Ft]+$_POST[Kedv_Ft];
Line #49:*/
Line #50:
Line #51:
Line #52:
Line #53:
Line #54:
Line #55:$SQLarc = "UPDATE `qj_cimlet` SET
Line #56: `osszft`='$_POST[OS_ft]',
Line #57: `osszdb`='$_SESSION[OSSZdb]',
Line #58: `KPft`='$_POST[KPft]',
Line #59: `UCS_Ft`='$_POST[UCS_Ft]',
Line #60: `UT_Ft`='$_POST[UT_Ft]',
Line #61: `ST_Ft`='$_POST[ST_Ft]',
Line #62: `Kedv_Ft`='$_POST[Kedv_Ft]',
Line #63: `ELONYEL_FT`='$_POST[eloelad_Ft]',
Line #64: `eloelad_date`='$_POST[eloelad_date]',
Line #65: `ELONY_FT`='$_POST[elonyom_Ft]',
Line #66: `elonyom_date`='$_POST[elonyom_date]',
Line #67: `Bank_Ft`='$_POST[Bank_Ft]'
Line #68: where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0 LIMIT 1";
Line #69:
Line #70://?//echo($SQLarc."<hr>");
Line #71:
Line #72:
Line #73:
Line #74:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0" ;
Line #75:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #76:$egy_sor = mysql_fetch_array($sql);
Line #77:
Line #78:$nur=mysql_num_rows($sql);
Line #79:$wjid=$egy_sor[wid];
Line #80:
Line #81://?//echo($sel."+++% $nur %++++ $wjid ++++ <hr>");
Line #82:
Line #83:
Line #84:
Line #85:
Line #86:
Line #87:echo("</H3>");
Line #88:
Line #89://echo("<body onload='javascript:window.print();'></body>");
Line #90:echo "<script>
Line #91: window.print();
Line #92: window.open('QJ_feladIR.php?&wjid=".$wjid."&nyomtat=Y&','infoframe');
Line #93: </script>";
Line #94:
Line #95://exit;
Line #96:
Line #97:}
Line #98:
Line #99:
Line #100:
Line #101:
Line #102:
Line #103:
Line #104:
Line #105:
Line #106:$SQLarc = "UPDATE `qj_cimlet` SET
Line #107: `osszft`='".$OS_ft."',
Line #108: `osszdb`='".$_SESSION[OSSZdb]."',
Line #109:
Line #110:
Line #111:
Line #112:
Line #113: `Kedv_Ft`='".$_SESSION['Kedv_Ft']."',
Line #114: `ELONYEL_FT`='".$_SESSION[ELONYEL_FT]."',
Line #115: `ELONY_FT`='".$_SESSION[ELONY_FT]."',
Line #116:
Line #117: where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0 LIMIT 1";
Line #118:
Line #119://?//echo($SQLarc."<hr>");
Line #120:
Line #121:
Line #122:}
Line #123:
Line #124:
Line #125:
Line #126:
Line #127:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0" ;
Line #128:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #129:$egy_sor = mysql_fetch_array($sql);
Line #130:
Line #131:$nur=mysql_num_rows($sql);
Line #132:
Line #133:
Line #134:$wjid=$egy_sor[wid];
Line #135://?//echo($sel." ----% $nur %------- --$wjid-- -- <hr>");
Line #136:
Line #137:
Line #138:
Line #139:$elonyom_Ft=$_SESSION[ELONY_FT];
Line #140:$eloelad_Ft=$_SESSION[ELONYEL_FT];
Line #141:
Line #142:
Line #143:
Line #144://echo(" <a href=javascript:printit()><img src='print.png' border=0></a>");
Line #145:echo(" </H3>");
Line #146:
Line #147:
Line #148:
Line #149:
Line #150:
Line #151:
Line #152:
Line #153:
Line #154:
Line #155:
Line #156:
Line #157:
Line #158:
Line #159:
Line #160:
Line #161:
Line #162:
Line #163:
Line #164:
Line #165:$Kedv_Ft=$sor[Kedv_Ft]+$_SESSION['Kedv_Ft'];
Line #166:unset($_SESSION['Kedv_Ft']);
Line #167:
Line #168://$online_Ft=$sor[online_Ft]+$_SESSION['Online'];
Line #169:$Online_Ft=$_SESSION['Online'];
Line #170:$Online_Ft=0; // NINCS
Line #171:$elonyom_Ft=0;
Line #172:$eloelad_Ft=0;
Line #173:
Line #174:if ($Bizomanyos<>"" and empty($egy_sor[ELONY_FT]) and substr($egy_sor[elonyom_date],0,4)=="0000" ) {
Line #175:$elonyom_Ft=$KPft;
Line #176:$KPft=0;
Line #177:$elonyom_date=$_COOKIE[date];
Line #178:}
Line #179:
Line #180:if ($Bizomanyos<>"" and $egy_sor[ELONY_FT]>0 ) {
Line #181:$eloelad_Ft=$KPft;
Line #182:$elonyom_Ft=$egy_sor[ELONY_FT];
Line #183:$eloelad_date=$_COOKIE[date];
Line #184:$elonyom_date=$egy_sor[elonyom_date];
Line #185:}
Line #186:
Line #187:
Line #188:
Line #189:$OS_ft=$KPft+$UCS_Ft+$Bank_Ft+$UT_Ft+$Kedv_Ft+$ST_Ft;
Line #190:unset($_SESSION['Online']);
Line #191:unset($_SESSION[ELONY_FT]);
Line #192:unset($_SESSION[ELONYEL_FT]);
Line #193:
Line #194:} else {
Line #195:
Line #196:$elonyom_date=$egy_sor[elonyom_date];
Line #197:$KPft=$egy_sor[KPft];
Line #198:$UCS_Ft=$egy_sor[UCS_Ft];
Line #199:$Bank_Ft=$egy_sor[Bank_Ft];
Line #200:$UT_Ft=$egy_sor[UT_Ft];
Line #201:$Kedv_Ft=$egy_sor[Kedv_Ft];
Line #202:$ST_Ft=$egy_sor[ST_Ft];
Line #203:$elonyom_Ft=$egy_sor[ELONY_FT];
Line #204:$eloelad_Ft=$egy_sor[ELONYEL_FT];
Line #205:
Line #206:$OS_ft=$KPft+$UCS_Ft+$Bank_Ft+$UT_Ft+$Kedv_Ft+$ST_Ft;
Line #207:
Line #208:
Line #209:}
Line #210:
Line #211:
Line #212:?>
Line #213:
Line #214:<form name=FORM1
Line #215:method="POST" action="QJ_felad.php?wjid=<? print $wjid; ?>&nyomtat=Y&L_nap=<?echo($_SESSION[L_nap]);?>"
Line #216:
Line #217:>
Line #218:
Line #219:<table border=1 align=left bgcolor='gold'>
Line #220:
Line #221:<tr>
Line #222:
Line #223:<td align=right>
Line #224:<input type='TEXT' value='<? echo($KPft);?>' name='KPft'>
Line #225:<input type='hidden' value='<? echo($_SESSION[L_nap]);?>' name='L_nap' >
Line #226:<input type='hidden' value='<? echo($elonyom_date);?>' name='elonyom_date'>
Line #227:<input type='hidden' value='<? echo($eloelad_date);?>' name='eloelad_date'>
Line #228:
Line #229:</td>
Line #230:</tr>
Line #231:
Line #232:<tr>
Line #233:
Line #234:<td align=right>
Line #235:<input type='TEXT' value='<? echo($UCS_Ft);?>' name='UCS_Ft'
Line #236:>
Line #237:</td>
Line #238:</tr>
Line #239:
Line #240:<tr>
Line #241:
Line #242:<td align=right>
Line #243:<input type='TEXT' value='<? echo($UT_Ft);?>' name='UT_Ft'
Line #244:>
Line #245:</td>
Line #246:</tr>
Line #247:
Line #248:
Line #249:<tr>
Line #250:
Line #251:<td align=right>
Line #252:<input type='TEXT' value='<? echo($Bank_Ft);?>' name='Bank_Ft'
Line #253:>
Line #254:</td>
Line #255:</tr>
Line #256:
Line #257:
Line #258:
Line #259:<tr>
Line #260:
Line #261:<td align=right>
Line #262:<input type='text' value='<? echo($ST_Ft);?>' name='ST_Ft'
Line #263: >
Line #264:</td>
Line #265:</tr>
Line #266:
Line #267:
Line #268:<tr>
Line #269:
Line #270:<td align=right>
Line #271:<input type='TEXT' value='<? echo($Kedv_Ft);?>' name='Kedv_Ft'
Line #272:>
Line #273:</td>
Line #274:</tr>
Line #275:
Line #276:<tr>
Line #277:<td align=right ><b>Online:</b></td>
Line #278:<td align=right >
Line #279:<input readonly style="background-color: Silver;" type='TEXT' value='<? echo($Online_Ft);?>' name='Online_Ft'
Line #280:>
Line #281:</td>
Line #282:</tr>
Line #283:
Line #284:
Line #285:<tr>
Line #286:
Line #287:<td align=right >
Line #288:<input style="background-color: #DBE6E0;" type='TEXT' value='<? echo($elonyom_Ft);?>' name='elonyom_Ft'
Line #289:>
Line #290:</td>
Line #291:</tr>
Line #292:
Line #293:<tr>
Line #294:
Line #295:<td align=right >
Line #296:<input style="background-color: #DBE6E0;" type='TEXT' value='<? echo($eloelad_Ft);?>' name='eloelad_Ft'
Line #297:>
Line #298:</td>
Line #299:</tr>
Line #300:
Line #301:<tr>
Line #302:
Line #303:<td align=right >
Line #304:<input style="background-color: Silver; " readonly type='TEXT' value='<? echo($OS_ft);?>' name='OS_Ft'>
Line #305:</td>
Line #306:</tr>
Line #307:
Line #308:<tr>
Line #309:<td bgcolor=Silver colspan=2 align=right>
Line #310:
Line #311:
Line #312:</td>
Line #313:</tr>
Line #314:
Line #315:</table></form>
Line #316:
Line #317:
Line #318:<SCRIPT Language="Javascript">
Line #319:
Line #320:function printit(){
Line #321:
Line #322://window.open("QJ_felad.php?&L_nap='<?echo($_SESSION[L_nap]);?>'", 'sframe');
Line #323://window.print();
Line #324:///////////////////////////////////////
Line #325://window.open("QJ_gyujto.php?&lista=1", 'sframe');
Line #326:///////////////////////////////////////
Line #327://~*~// QJ_felad.php
Line #328:}
Line #329:
Line #330:</script>
Line #331: