QJ_feladIR.inc

---

Line #0:<?php
Line #1:
Line #2:$L_PHP="QJ_feladIR.php";
Line #3:
Line #4:if (isset($_SESSION['Dump'])) echo("QJEGY`2013v3.01 QJ_feladIR.inc *** ACTION =".$L_PHP." <hr>");
Line #5:if (isset($_SESSION['Dump'])) {
Line #6:$Sfilter="ft";
Line #7:include("../_inc_QJ/QQ_varlist.php");
Line #8:}
Line #9:if (isset($_GET[nyomtat])) {
Line #10:?>
Line #11:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #12:<?PHP
Line #13:
Line #14:}
Line #15:
Line #16:if (isset($_GET[L_nap]) and isset($_GET[L_biz])) {
Line #17:
Line #18:$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_GET[L_biz]."' and szoveg='".$_GET[L_nap]."'" ;
Line #19:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #20:$nur=mysql_num_rows($sql);
Line #21:
Line #22://?//
Line #23:if (isset($_SESSION['Dump'])) echo($sel."<hr>".$nur);
Line #24:
Line #25:if ($nur>0) {
Line #26:$egy_sor = mysql_fetch_array($sql);
Line #27:$_GET[wjid]=$egy_sor[wid];
Line #28:$_SESSION[L_nap]=$_GET[L_nap];
Line #29:$_SESSION[L_bizomanyos]=$_GET[L_biz];
Line #30: echo "<script>
Line #31: window.open('QJ_napi.php?&L_nap=".$_GET[L_nap]."&L_biz=".$_GET[L_biz]."', 'sframe');
Line #32: </script>";
Line #33:
Line #34:} else {
Line #35: echo "<script>
Line #36: window.open('QJ_napi.php?&L_nap=".$_GET[L_nap]."&L_biz=".$_GET[L_biz]."', 'sframe');
Line #37: </script>";
Line #38:exit;
Line #39:}
Line #40:
Line #41:
Line #42:}
Line #43:
Line #44://?//include("QJ_varlist.php");
Line #45:$sel = "SELECT * FROM qj_cimlet where wid='".$_GET[wjid]."'";
Line #46://?//
Line #47:if (isset($_SESSION['Dump'])) echo($sel."<hr>");
Line #48:
Line #49:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #50:$egy_sor = mysql_fetch_array($sql);
Line #51:
Line #52://$sel = "SELECT * FROM qj_cimlet where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0" ;
Line #53://$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #54://echo($sel."<hr>");
Line #55:
Line #56://$nur=mysql_num_rows($sql);
Line #57:/*
Line #58:if ($nur==0)
Line #59:{
Line #60:$ins ="
Line #61:INSERT INTO `qj_cimlet`
Line #62:( `usr_kod`, `widarc`, `bizomanyos`, `status`, `szoveg`, `arforma`
Line #63:) VALUES (
Line #64:
Line #65:)";
Line #66:
Line #67://echo($ins."<hr>");
Line #68:
Line #69:mysql_query($ins) or die($ins." Hiba az insertben");
Line #70:
Line #71:}
Line #72:
Line #73:$SQLarc = "UPDATE `qj_cimlet` SET
Line #74: `osszft`='$_SESSION[OSSZft]',
Line #75: `osszdb`='$_SESSION[OSSZdb]',
Line #76: `KPft`='$_POST[KPft]',
Line #77: `UCS_Ft`='$_POST[UCS_Ft]',
Line #78: `UT_Ft`='$_POST[UT_Ft]',
Line #79: `ST_Ft`='$_POST[ST_Ft]',
Line #80: `Kedv_Ft`='$_POST[Kedv_Ft]',
Line #81: `ELONYEL_FT`='$_POST[eloelad_Ft]',
Line #82: `Online_Ft`='$_POST[Online_Ft]',
Line #83: `ELONY_FT`='$_POST[elonyom_Ft]',
Line #84: `Bank_Ft`='$_POST[Bank_Ft]'
Line #85: where bizomanyos='".$_SESSION[L_bizomanyos]."' and szoveg='".$_SESSION[L_nap]."' and widarc=0 LIMIT 1";
Line #86:
Line #87://?//
Line #88: echo($elad."<hr>");
Line #89:
Line #90:
Line #91:*/
Line #92:
Line #93:
Line #94://$L_NAP=$_SESSION[L_nap];
Line #95://$L_user=$_SESSION[L_bizomanyos];
Line #96:
Line #97:$L_NAP=$egy_sor[szoveg];
Line #98:$L_user=$egy_sor[bizomanyos];
Line #99:
Line #100:
Line #101:$L_PHP="QJ_feladIR.php?&wjid=$_GET[wjid]";
Line #102:include("QJ_listafej.php");
Line #103:
Line #104:/*$SQLarc = "UPDATE `qj_cimlet` SET
Line #105: `osszft`='$_SESSION[OSSZft]',
Line #106: `osszdb`='$_SESSION[OSSZdb]',
Line #107: `KPft`='$_POST[KPft]',
Line #108: `UCS_Ft`='$_POST[UCS_Ft]',
Line #109: `UT_Ft`='$_POST[UT_Ft]',
Line #110: `ST_Ft`='$_POST[ST_Ft]',
Line #111: `Kedv_Ft`='$_POST[Kedv_Ft]',
Line #112: `ELONYEL_FT`='$_POST[eloelad_Ft]',
Line #113: `Online_Ft`='$_POST[Online_Ft]',
Line #114: `ELONY_FT`='$_POST[elonyom_Ft]',
Line #115: `Bank_Ft`='$_POST[Bank_Ft]'
Line #116:*/
Line #117:
Line #118:$sumft=$egy_sor[KPft]+$egy_sor[UCS_Ft]+$egy_sor[Bank_Ft]+$egy_sor[UT_Ft]+$egy_sor[Kedv_Ft]+$egy_sor[ST_Ft];
Line #119:
Line #120:
Line #121:echo ("
Line #122:<table border=0 width=500 align=left >
Line #123:
Line #124:<tr>
Line #125:
Line #126:<td WIDTH=300 align=right><b><FIELDSET>Ft</FIELDSET></b></td>
Line #127:<td WIDTH=300></td>
Line #128:
Line #129:</tr><tr>
Line #130:
Line #131:
Line #132:<td align=right><b><FIELDSET>".number_format($egy_sor[KPft])."</b>&nbsp;Ft</FIELDSET></td>
Line #133:
Line #134:</tr><tr>
Line #135:
Line #136:
Line #137:<td align=right><b><FIELDSET>".number_format($egy_sor[UCS_Ft])."</b>&nbsp;Ft</FIELDSET></td>
Line #138:
Line #139:</tr><tr>
Line #140:
Line #141:
Line #142:<td align=right><b><FIELDSET>".number_format($egy_sor[UT_Ft])."</b>&nbsp;Ft</FIELDSET></td>
Line #143:
Line #144:</tr><tr>
Line #145:
Line #146:
Line #147:<td align=right><b><FIELDSET>".number_format($egy_sor[Kedv_Ft])."</b>&nbsp;Ft</FIELDSET></td>
Line #148:
Line #149:</tr><tr>
Line #150:
Line #151:
Line #152:<td align=right><b><FIELDSET>".number_format($egy_sor[Bank_Ft])."</b>&nbsp;Ft</FIELDSET></td>
Line #153:
Line #154:</tr><tr>
Line #155:
Line #156:
Line #157:<td align=right><b><FIELDSET>".number_format($egy_sor[ST_Ft])."</b>&nbsp;Ft</FIELDSET></td>
Line #158:
Line #159:</tr><tr>
Line #160:
Line #161:<td align=right><FIELDSET>Online:</FIELDSET></td>
Line #162:<td align=right><b><FIELDSET>".number_format($egy_sor[Online_Ft])."</b>&nbsp;Ft</FIELDSET></td>
Line #163:
Line #164:</tr><tr>
Line #165:
Line #166:
Line #167:<td align=right><b><FIELDSET>".number_format($egy_sor[ELONY_FT])."</b>&nbsp;Ft</FIELDSET></td>
Line #168:
Line #169:</tr><tr>
Line #170:
Line #171:
Line #172:<td align=right><b><FIELDSET>".number_format($egy_sor[ELONYEL_FT])."</b>&nbsp;Ft</FIELDSET></td>
Line #173:
Line #174:</tr><tr>
Line #175:
Line #176:
Line #177:<td align=right><b><FIELDSET>".number_format($sumft)."</b>&nbsp;Ft</FIELDSET></td>
Line #178:
Line #179:</tr><tr></table><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
Line #180:
Line #181:");
Line #182:
Line #183:
Line #184:if (isset($_GET[nyomtat])) {
Line #185:
Line #186:
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_gyujto.php", 'sframe');
Line #201:///////////////////////////////////////
Line #202:
Line #203:}
Line #204:
Line #205:
Line #206:</script>
Line #207:<?PHP
Line #208:}
Line #209:?>
Line #210: