Bi-Dir

QJ_feladIR.old

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