QJ_cimletez.inc

---

Line #0:<?php ?>
Line #1:<SCRIPT LANGUAGE="JavaScript">
Line #2:
Line #3:
Line #4: function format(input){
Line #5: var num = input.value.replace(/\,/g,'');
Line #6: if(!isNaN(num)){
Line #7: }
Line #8: else{ alert('Nem numerikus!');
Line #9: input.value = input.value.substring(0,input.value.length-1);
Line #10: }
Line #11: }
Line #12:
Line #13:function uresCheck(mezo){
Line #14: if (mezo.value != "") return true;
Line #15: else{
Line #16:
Line #17: return false;
Line #18: }
Line #19:}
Line #20:
Line #21:function teszt(adat,minta){
Line #22: for (var i=0; i<adat.length; i++)
Line #23: if (minta.indexOf(adat.charAt(i)) == -1)
Line #24: return false;
Line #25:
Line #26: return true;
Line #27:}
Line #28:
Line #29:function tartalmaz(adat,minta){
Line #30: for (var i=0; i<adat.length; i++)
Line #31: if (minta.indexOf(adat.charAt(i)) != -1)
Line #32: return true;
Line #33: return false;
Line #34:}
Line #35:
Line #36:function telefonCheck(mezo){
Line #37: if (!uresCheck(mezo)) return false;
Line #38: if (!teszt(mezo.value,"1234567890()/- ") || !tartalmaz(mezo.value,"1234567890")){
Line #39:
Line #40: return false;
Line #41: }
Line #42: else{
Line #43:
Line #44: return true;
Line #45: }
Line #46:}
Line #47:
Line #48:
Line #49:function numerikusCheck(mezo){
Line #50: if (!uresCheck(mezo)) return false;
Line #51: if (!teszt(mezo.value,"1234567890")){
Line #52:
Line #53: return false;
Line #54: }
Line #55: else{
Line #56:
Line #57: return true;
Line #58: }
Line #59:}
Line #60:
Line #61:
Line #62:
Line #63:// -->
Line #64:</SCRIPT>
Line #65:
Line #66:
Line #67:<?
Line #68:
Line #69://include('bilib.inc');
Line #70://BISQLcon();
Line #71:
Line #72://@mysql_query('SET CHARACTER SET latin2');
Line #73://@mysql_query("SET NAMES 'latin2'");
Line #74:
Line #75:
Line #76://echo($_GET[wjid]."<hr>");
Line #77:
Line #78:
Line #79:$szin="bgcolor='gold'";
Line #80:if (isset($_GET[nyomtat])) {
Line #81:$szin="";
Line #82:?>
Line #83:<LINK rel="stylesheet" href="mike.css" type=text/css>
Line #84:<?PHP
Line #85:}
Line #86:
Line #87:
Line #88:if (isset($_POST[KPft])) {
Line #89:
Line #90://?//include("QJ_varlist.php");
Line #91:
Line #92: $wjid=$_GET[wjid];
Line #93:
Line #94: if ($_POST[Ossft]<>$_POST[KPft]+$_POST[UCS_Ft]+$_POST[UT_Ft]+ $_POST[Bank_Ft]+$_POST[Kedv_Ft]) {
Line #95:
Line #96: $elter=$_POST[Ossft]-$_POST[KPft]-$_POST[UCS_Ft]-$_POST[UT_Ft]- $_POST[Bank_Ft]-$_POST[Kedv_Ft];
Line #97:
Line #98:
Line #99:$elter=abs($elter);
Line #100:
Line #101:echo "<script language = javascript>";
Line #102:
Line #103:echo "</script>";
Line #104:
Line #105: }
Line #106:
Line #107:////////////
Line #108:// } else {
Line #109:////////////
Line #110:
Line #111: $plUs="";
Line #112:
Line #113:if ($_POST[ELONYEL_FT]=="" and $_POST[ELONY_FT]>0 and substr($_POST[eloelad_date],0,1)=="") {
Line #114: $_POST[ELONYEL_FT]=$_POST[ELONY_FT];
Line #115:// $_SESSION[Pnap]=date ("y-m-d", mktime (0,0,0,substr($_POST[eloelad_date],8,2),substr($_POST[eloelad_date],5,2),substr($_POST[eloelad_date],0,4)));
Line #116: $_SESSION[Pnap]=$_POST[eloelad_date];
Line #117:}
Line #118:
Line #119: $plUs.="`ELONYEL_FT`='$_POST[ELONYEL_FT]',
Line #120: `logtime`=now(),
Line #121: `eloelad_date`='$_POST[eloelad_date]',";
Line #122:
Line #123:
Line #124:if ($_POST[ELONY_FT]=="" and substr($_POST[elonyom_date],0,1)=="") {
Line #125: $_POST[ELONY_FT]=$_POST[KPft];
Line #126:// $_SESSION[Pnap]=date ("y-m-d", mktime (0,0,0,substr($_POST[elonyom_date],8,2),substr($_POST[elonyom_date],5,2),substr($_POST[elonyom_date],0,4)));
Line #127: $_SESSION[Pnap]=$_POST[elonyom_date];
Line #128:}
Line #129:
Line #130: $plUs.="`ELONY_FT`='$_POST[ELONY_FT]',
Line #131: `logtime`=now(),
Line #132: `elonyom_date`='$_POST[elonyom_date]',";
Line #133:
Line #134:$elony=$_POST[ELONYEL_FT]+$_POST[ELONY_FT];
Line #135: /// TEMP ///
Line #136:if ($_POST[UCS_Ft]+$_POST[UT_Ft]+$_POST[Bank_Ft]+$_POST[Kedv_Ft]+$elony==0) $future="*"; else $future="";
Line #137: /// TEMP ///
Line #138:
Line #139:
Line #140:$SQLarc = "UPDATE `qj_cimlet` SET
Line #141: `KPft`='$_POST[KPft]',
Line #142: `UCS_Ft`='$_POST[UCS_Ft]',
Line #143: `UCS_memo`='$_POST[UCS_memo]',
Line #144: `UT_Ft`='$_POST[UT_Ft]',
Line #145: `UT_memo`='$_POST[UT_memo]',
Line #146: `Bank_Ft`='$_POST[Bank_Ft]',
Line #147: `Bank_memo`='$_POST[Bank_memo]',
Line #148: `Kedv_Ft`='$_POST[Kedv_Ft]',
Line #149: `Kedv_memo`='$_POST[Kedv_memo]',
Line #150: `future`='$future',
Line #151: $plUs
Line #152: `szoveg`='$_SESSION[Pnap]'
Line #153: WHERE widarc='".$wjid."' LIMIT 1";
Line #154://?//echo($SQLarc."<hr>");
Line #155:
Line #156:
Line #157://?//echo "<script>
Line #158://?// window.open('QJ_gyujto.php', 'sframe');
Line #159://?// </script>";
Line #160:}
Line #161:////
Line #162://}
Line #163:////
Line #164:
Line #165:if (isset($_GET[wjid])){
Line #166:
Line #167: $wjid=$_GET[wjid];
Line #168:
Line #169: $sel = "SELECT * FROM qj_cimlet where widarc='".$wjid."'";
Line #170: $sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #171://echo($sel."<hr>");
Line #172:
Line #173: $nur=mysql_num_rows($sql);
Line #174:
Line #175:if ($nur==0)
Line #176:{
Line #177:
Line #178: $sel = "SELECT * FROM qj_jlog where wid='".$wjid."'";
Line #179: $sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #180:
Line #181: ///echo($sel."<hr>");
Line #182:
Line #183: $sor=mysql_fetch_array($sql);
Line #184:
Line #185:IF (substr($sor[status],0,1)=="K") $KPft=$sor[osszft]; else $KPft=0;
Line #186:IF (substr($sor[status],0,1)=="B") $Bank_Ft=$sor[osszft]; else $Bank_Ft=0;
Line #187:
Line #188:IF (substr($sor[status],1,1)=="d") $UCS_Ft=$sor[osszft]; else $UCS_Ft=0;
Line #189:
Line #190:
Line #191: $_SESSION[Pnap]=date ("y-m-d", mktime (0,0,0,substr($sor[logtime],8,2),substr($sor[logtime],5,2),substr($sor[logtime],0,4)));
Line #192:
Line #193:$ins ="
Line #194:INSERT INTO `qj_cimlet`
Line #195:( `usr_kod`, `widarc`, `bizomanyos`, `osszft`,
Line #196:`osszdb`, `status`, `arforma`,`vevokod`,`szoveg`,
Line #197:`KPft`,`Bank_Ft`,`UCS_Ft`,`logtime`
Line #198:,`future`
Line #199:) VALUES (
Line #200:'$sor[usr_kod]', '$sor[wid]', '$sor[bizomanyos]', '$sor[osszft]',
Line #201:'$sor[osszdb]', '$sor[status]', '$sor[arforma]','$sor[vevokod]','$_SESSION[Pnap]','$KPft','$Bank_Ft','$UCS_Ft','$sor[logtime]'
Line #202:,'*'
Line #203:
Line #204:)";
Line #205:
Line #206://echo($ins."<hr>");
Line #207:
Line #208:mysql_query($ins) or die($ins." Hiba az insertben");
Line #209:
Line #210:}
Line #211:}
Line #212:
Line #213:
Line #214: $wjid=$_GET[wjid];
Line #215:
Line #216: $sel = "SELECT * FROM qj_cimlet where widarc='".$wjid."'";
Line #217: $sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #218: $sor=mysql_fetch_array($sql);
Line #219:
Line #220://echo($sel."<hr>");
Line #221:
Line #222:$_SESSION[Pnap]=substr($sor[logtime],0,10);
Line #223:
Line #224:
Line #225:$vevokod=$sor[vevokod];
Line #226:
Line #227:
Line #228:
Line #229:
Line #230:
Line #231:
Line #232:
Line #233:
Line #234:
Line #235:
Line #236:
Line #237:$L_PHP="QJ_cimletez.php?wjid=".$_GET[wjid];
Line #238:include("QJ_listafej.php");
Line #239:
Line #240:
Line #241:echo "<table border=1>
Line #242:<tr bgcolor=silver>
Line #243:
Line #244:
Line #245:<td align=right ><b>Ft</b></td>
Line #246:<td align=right ><b>Db</b></td>
Line #247:
Line #248:";
Line #249:
Line #250:echo "
Line #251:<tr>
Line #252:<td ><b>$sor[status]</b></td>
Line #253:<td ><b>$sor[arforma]</b></td>
Line #254:<td align=right ><b>$sor[osszft]</b></td>
Line #255:<td align=right ><b>$sor[osszdb]</b></td>
Line #256:<td >$sor[logtime]</td>
Line #257:</tr></table>";
Line #258:
Line #259:?>
Line #260:
Line #261:
Line #262:<form name=FORM1
Line #263:method="POST" action="QJ_cimletez.php?&wjid=<? echo($wjid);?>"
Line #264:
Line #265:>
Line #266:
Line #267:<table border=1 align=left $szin>
Line #268:
Line #269:<tr>
Line #270:
Line #271:<td align=right>
Line #272:<input type='TEXT' value='<? echo($sor[KPft]);?>' name='KPft'
Line #273:onkeyup="format(FORM1.KPft)"
Line #274:>
Line #275:<input type='hidden' value='<? echo($sor[osszft]);?>' name='Ossft'
Line #276:>
Line #277:
Line #278:</td>
Line #279:
Line #280:<td>
Line #281:
Line #282:</td>
Line #283:</tr>
Line #284:
Line #285:<tr>
Line #286:
Line #287:<td align=right>
Line #288:<input type='TEXT' value='<? echo($sor[UCS_Ft]);?>' name='UCS_Ft'
Line #289:onkeyup="format(FORM1.UCS_Ft)"
Line #290:>
Line #291:</td>
Line #292:<td align=LEFT>
Line #293:<input type='TEXT' size=20 value='<? echo($sor[UCS_memo]);?>' name='UCS_memo'>
Line #294:</td>
Line #295:</tr>
Line #296:
Line #297:<tr>
Line #298:
Line #299:<td align=right>
Line #300:<input type='TEXT' value=<? echo($sor[UT_Ft]);?> name='UT_Ft'
Line #301: onkeyup="format(FORM1.UT_Ft)"
Line #302:
Line #303: >
Line #304:
Line #305:</td>
Line #306:<td align=LEFT>
Line #307:<input type='TEXT' size=20 value='<? echo($sor[UT_memo]);?>' name='UT_memo'>
Line #308:</td>
Line #309:</tr>
Line #310:
Line #311:<tr>
Line #312:
Line #313:<td align=right>
Line #314:<input type='TEXT' value=<? echo($sor[Bank_Ft]);?> name='Bank_Ft'
Line #315: onkeyup="format(FORM1.Bank_Ft)"
Line #316:>
Line #317:</td>
Line #318:<td align=LEFT>
Line #319:<input type='TEXT' size=20 value='<? echo($sor[Bank_memo]);?>'
Line #320:name='Bank_memo'
Line #321:>
Line #322:</td>
Line #323:</tr>
Line #324:<tr>
Line #325:
Line #326:<td align=right>
Line #327:<input type='TEXT' value='<? echo($sor[Kedv_Ft]);?>' name='Kedv_Ft'
Line #328: onkeyup="format(FORM1.Kedv_Ft)"
Line #329:>
Line #330:</td>
Line #331:<td align=LEFT>
Line #332:<input type='TEXT' size=20 value='<? echo($sor[Kedv_memo]);?>' name='Kedv_memo'>
Line #333:</td>
Line #334:</tr>
Line #335:
Line #336:<tr>
Line #337:
Line #338:<td align=right >
Line #339:
Line #340: onkeyup="format(FORM1.ELONY_FT)"
Line #341:>
Line #342:</td>
Line #343:<td align=LEFT>
Line #344:<input type='TEXT' value='<? echo($sor[elonyom_date]);?>' name='elonyom_date'>
Line #345:</td>
Line #346:</tr>
Line #347:
Line #348:
Line #349:<tr>
Line #350:
Line #351:<td align=right>
Line #352:
Line #353: onkeyup="format(FORM1.ELONYEL_FT)"
Line #354:>
Line #355:</td>
Line #356:<td align=LEFT>
Line #357:<input type='TEXT' value='<? echo($sor[eloelad_date]);?>' name='eloelad_date'>
Line #358:</td>
Line #359:</tr>
Line #360:
Line #361:<?php
Line #362:if (!isset($_GET[nyomtat])) {
Line #363:?>
Line #364:<tr>
Line #365:<td align=right>
Line #366:
Line #367:
Line #368:</td>
Line #369:</tr>
Line #370:<?php
Line #371:}
Line #372:?>
Line #373:
Line #374:</table></form>
Line #375:
Line #376:<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
Line #377:
Line #378:<?
Line #379:
Line #380:$keres = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #381:
Line #382:$ct_sor = mysql_fetch_array($ctar);
Line #383:$e="";
Line #384:
Line #385:
Line #386:if ($ct_sor[nev]>" ") {
Line #387:
Line #388:$e.="<b>".($ct_sor[nev]."</b><br>");
Line #389:$e.=($ct_sor[irsz]."&nbsp;");
Line #390:$e.=($ct_sor[telepules]."&nbsp;");
Line #391:$e.=($ct_sor[cim]."<br>");
Line #392:$e.=($ct_sor[telszam]."&nbsp;");
Line #393:$e.=($ct_sor[uzenet]."&nbsp;");
Line #394:$e.=($ct_sor[email_cim]."<br>");
Line #395:}
Line #396:
Line #397:$_SESSION[ct_nev]=$ct_sor[nev];
Line #398:$_SESSION[ct_irsz]=$ct_sor[irsz];
Line #399:$_SESSION[ct_telepules]=$ct_sor[telepules];
Line #400:$_SESSION[ct_cim]=$ct_sor[cim];
Line #401:$_SESSION[ct_telszam]=$ct_sor[telszam];
Line #402:$_SESSION[ct_email]=$ct_sor[email_cim];
Line #403:
Line #404:echo($e);
Line #405:
Line #406:if (isset($_GET[nyomtat])) {
Line #407:
Line #408:include("QJ_listaveg.php");
Line #409:
Line #410:
Line #411:echo("<body onload='printit()'></body>");
Line #412:
Line #413:?>
Line #414:<SCRIPT Language="Javascript">
Line #415:
Line #416:function printit(){
Line #417:
Line #418:window.print();
Line #419:
Line #420://window.open("QJ_berletnyomtat.php", 'sframe');
Line #421:
Line #422:///////////////////////////////////////
Line #423://window.open("QJ_gyujto.php", 'sframe');
Line #424:///////////////////////////////////////
Line #425:
Line #426:}
Line #427:
Line #428:
Line #429:</script>
Line #430:<?PHP
Line #431:}
Line #432:
Line #433://~*~//
Line #434:
Line #435:?>
Line #436:
Line #437:
Line #438: