Bi-Dir

NO_nyomtat.inc

Line #0:<html>
Line #1:<head>
Line #2:<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2">
Line #3:</head>
Line #4:
Line #5:<?
Line #6:
Line #7:$parSQL="SELECT * FROM qj_sql where szoveg='CSS' and archiv<>'*' and future<>'*' ORDER BY widarc";
Line #8:
Line #9:
Line #10:$css="";
Line #11:
Line #12:while ( $par_sor = mysql_fetch_array( $parQ )) {
Line #13:
Line #14: $css=$css.$par_sor[sql_parancs];
Line #15:}
Line #16:
Line #17:echo($css);
Line #18:
Line #19:
Line #20:$login=$_SESSION['login'];
Line #21:$newpage="";
Line #22:
Line #23:$jegy_col=$_SESSION['jegy_col'];
Line #24:$jegy_row=$_SESSION['jegy_row'];
Line #25:$printer_offset=$_SESSION['printer_offset'];
Line #26:
Line #27:$meros=$printer_offset+$_SESSION['berlet_mid']+$jegy_col;
Line #28:
Line #29:$meret="";
Line #30:if ($_SESSION['printer_offset']>0) $meret.=" width='".$_SESSION['printer_offset']."'";
Line #31:
Line #32:$Jcol="";
Line #33:if ($_SESSION['jegy_col']>0) $Jcol=" <td width='".$_SESSION['jegy_col']."' > </td>";
Line #34:
Line #35:$NyFortab="
Line #36:<td width='".$_SESSION['berlet_mid']."'> </td>";
Line #37:
Line #38:$odb=$_SESSION['sdb'];
Line #39:$oft=$_SESSION['sft'];
Line #40:$db=0;
Line #41:$ft=0;
Line #42:$csarform="*";
Line #43:$arnev="*";
Line #44:$csear=-1;
Line #45:$fm=$_SESSION['feldmod'];
Line #46:$fmn=$_SESSION['feldmod'.$fm];
Line #47:$af=$_SESSION['arforma'];
Line #48:$afn=$_SESSION['arforma'.$af];
Line #49:$cimind=$_SESSION['last_cimind'];
Line #50:
Line #51:// ideiglenes
Line #52:
Line #53://
Line #54:
Line #55:
Line #56:if ($fmn=="Protokoll") { $ft=0; $oft=0;}
Line #57:
Line #58:$elad = "INSERT INTO `qj_jlog`
Line #59:( `usr_kod`, `osszft`, `osszdb`, `bizomanyos`, `status`, `arforma`, `vevokod`
Line #60:) VALUES
Line #61:( 'MK12', '$oft', '$odb', '$_SESSION[login]',
Line #62:'$fmn', '$afn','$cimind'
Line #63:)";
Line #64:
Line #65://echo($elad."<hr>");
Line #66:
Line #67:mysql_query($elad) or die("Hiba a QJ_jegy insertben");
Line #68:
Line #69:$elad = "select * from `qj_jlog` where bizomanyos='$_SESSION[login]' order by wid DESC";
Line #70:
Line #71:$jegy_sor = mysql_fetch_array( $jegyek );
Line #72:
Line #73:$bizonylatszam=$jegy_sor[wid];
Line #74:
Line #75:
Line #76:while (list ($key, $val) = each ($_SESSION)) {
Line #77:
Line #78:$Tkey[$si]=$key;
Line #79:$Tval[$si]=$val;
Line #80:
Line #81:$kpoz=strpos($key,'[');
Line #82:$vpoz=strpos($key,']');
Line #83:
Line #84:///////////////
Line #85:if ($kpoz>0) {
Line #86://////////////
Line #87:$i++;
Line #88:
Line #89:$bind=substr($key,$kpoz+1,$vpoz-$kpoz-1-10);
Line #90:$bond=substr($key,$kpoz+1,$vpoz-$kpoz-1);
Line #91:$datum_kod=substr($key,$kpoz+1+7,10);
Line #92:
Line #93:$nyomtat = "SELECT * FROM qj_jegy WHERE datum_kod='".$datum_kod."' and szek_kod='".$bind."'";
Line #94:
Line #95:
Line #96:while ( $egy_sor2 = mysql_fetch_array( $eredmeny2 )) {
Line #97:
Line #98:$QJ_sor_o=trim($egy_sor2[QJ_sor_o]);
Line #99:$QJ_sor_h=trim($egy_sor2[QJ_sor_h]);
Line #100:$QJ_sor_s=trim($egy_sor2[QJ_sor_s]);
Line #101:$QJ_sor_n=trim($egy_sor2[QJ_sor_n]);
Line #102:$Jerkezesi=$egy_sor2[erkezesi];
Line #103:
Line #104://$keres3 = "SELECT * FROM qj_musor WHERE JeBe='Nyugta'";
Line #105:
Line #106://$NY_sor = mysql_fetch_array( $eredmeny );
Line #107://$NYlast_index=$NY_sor[last_index]+1;
Line #108:
Line #109:$keres3 = "SELECT future FROM qj_login WHERE email_kod='LastIndex'";
Line #110:
Line #111:$NY_sor = mysql_fetch_array( $eredmeny );
Line #112:$NYlast_index=$NY_sor[future]+1;
Line #113:
Line #114:
Line #115:$dk=$egy_sor2[datum_kod];
Line #116:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #117:
Line #118:$egy_sor = mysql_fetch_array( $eredmeny );
Line #119:$last_index=$egy_sor[last_index]+1;
Line #120:
Line #121:$h=$egy_sor[helyszin];
Line #122:$c=$egy_sor[cim];
Line #123:If ($egy_sor[JeBe]=="Napi") $d=$egy_sor[cimkieg3]; else $d=$egy_sor[datum];
Line #124:
Line #125:
Line #126:IF (trim($egy_sor[Szjszam])<>"") $Szjszam="SZJ: ".$egy_sor[Szjszam]; else $Szjszam=" ";
Line #127:
Line #128:
Line #129:$AFA_jel=$egy_sor[AFA_jel];
Line #130:
Line #131:IF (trim($egy_sor[AFA_jel])<>"") $afasz=$egy_sor[AFA_jel]; else $afasz="";
Line #132:
Line #133:
Line #134:$cimkieg1=$egy_sor[cimkieg1];
Line #135://?// IF (trim($cimkieg1)<>"") --$jegy_row;
Line #136:
Line #137:$cimkieg2=$egy_sor[cimkieg2];
Line #138:$cimkieg3=$egy_sor[cimkieg3];
Line #139:$erkezesi=$egy_sor[erkezesi];
Line #140:$Merkezesi=$egy_sor[erkezesi];
Line #141:$wjid=$egy_sor[wid];
Line #142:$belepo=$egy_sor[datum_fej];
Line #143:$FormaJel=$egy_sor[FormaJel];
Line #144:$JeBe=$egy_sor[JeBe];
Line #145:
Line #146:$wid=$egy_sor2[wid];
Line #147:$ar_nev=$egy_sor2[ar_nev];
Line #148:
Line #149:$Jnyugta_szam="Ssz:".substr('000000'.$NYlast_index,-6);
Line #150:
Line #151:/*
Line #152:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #153:WHERE datum_kod='".$dk."'";
Line #154:
Line #155:
Line #156:$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #157:WHERE JeBe='Nyugta'";
Line #158:
Line #159:*/
Line #160:
Line #161:$elad = "UPDATE `qj_jegy` SET
Line #162:`bizonylatszam`='$bizonylatszam',`FormaJel`='$FormaJel',`JeBe`='$JeBe',
Line #163:`nyugta_szam`='$Jnyugta_szam',
Line #164:`printdatum`=now()
Line #165:WHERE wid='".$wid."'";
Line #166://echo($elad."<hr>");
Line #167:
Line #168:
Line #169:
Line #170://///////////////////////////////////////////////////////////////
Line #171:$print="SELECT printdatum FROM qj_jegy WHERE wid='".$wid."'";
Line #172:
Line #173:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #174:
Line #175:$today = $kegy_sor[printdatum];
Line #176:
Line #177:$szigoru=$bizonylatszam."/".$egy_sor2[datum_kod]."/".substr('0000000'.$egy_sor2[wid],-5);
Line #178:
Line #179:$SQLarc = "UPDATE `qj_archive` SET
Line #180:`bizonylatszam`='$szigoru',`FormaJel`='$FormaJel',`JeBe`='$JeBe',
Line #181:`nyugta_szam`='$Jnyugta_szam',
Line #182:`printdatum`=now()
Line #183:WHERE widarc='".$wid."' and bizonylatszam='' order by logtime DESC LIMIT 1";
Line #184://echo($elad."<hr>");
Line #185:
Line #186:
Line #187:
Line #188:
Line #189:
Line #190://<td ALIGN=left>Kelt: $today</td>
Line #191:
Line #192:if (isset($_SESSION[Jbcsoport]) )
Line #193:{
Line #194:////// if (($csear<>$egy_sor2[ar] or $arnev<>$egy_sor2[ar_nev] or $csear==0) and $csear<>-1){
Line #195:
Line #196:if (($csear<>$egy_sor2[ar] or $arnev<>$egy_sor2[ar_nev] ) and $csear<>-1){
Line #197:$arnev=$csarform;
Line #198:$ear=$csear;
Line #199:
Line #200:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #201:WHERE datum_kod='".$dk."'";
Line #202:
Line #203:
Line #204://$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #205://WHERE JeBe='Nyugta'";
Line #206:
Line #207:
Line #208:$elad = "UPDATE `qj_login` SET future='$NYlast_index'
Line #209:WHERE email_kod='LastIndex'";
Line #210:
Line #211:
Line #212:echo($newpage);
Line #213:for ($i=0;$jegy_row>$i;$i++) {echo('<br>'); }
Line #214:include($nyomtat_Form);
Line #215:$newpage="<p id='page_break'></p>";
Line #216:
Line #217://$keres3 = "SELECT * FROM qj_musor WHERE JeBe='Nyugta'";
Line #218:
Line #219://$NY_sor = mysql_fetch_array( $eredmeny );
Line #220://$NYlast_index=$NY_sor[last_index]+1;
Line #221:
Line #222:$keres3 = "SELECT future FROM qj_login WHERE email_kod='LastIndex'";
Line #223:
Line #224:$NY_sor = mysql_fetch_array( $eredmeny );
Line #225:$NYlast_index=$NY_sor[future]+1;
Line #226:
Line #227:
Line #228:
Line #229:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #230:
Line #231:$egy_sor = mysql_fetch_array( $eredmeny );
Line #232:$last_index=$egy_sor[last_index]+1;
Line #233:
Line #234:$Jnyugta_szam="Ssz:".substr('000000'.$NYlast_index,-6);
Line #235:$db=0;
Line #236:$ft=0;
Line #237:}
Line #238:
Line #239:$ear=$egy_sor2[ar];
Line #240:$arnev=$egy_sor2[ar_nev];
Line #241:$csarform=$arnev;
Line #242:$csear=$ear;
Line #243:
Line #244:++$db;
Line #245:$ft=$ft+$ear;
Line #246:}
Line #247:
Line #248://///////
Line #249:if (!isset($_SESSION[Jbcsoport]) )
Line #250://///////
Line #251:{
Line #252:
Line #253:$ear=$egy_sor2[ar];
Line #254:$arnev=$egy_sor2[ar_nev];
Line #255:$csarform=$arnev;
Line #256:$csear=$ear;
Line #257:
Line #258:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #259:WHERE datum_kod='".$dk."'";
Line #260:
Line #261:
Line #262://$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #263://WHERE JeBe='Nyugta'";
Line #264:
Line #265:
Line #266:$elad = "UPDATE `qj_login` SET future='$NYlast_index'
Line #267:WHERE email_kod='LastIndex'";
Line #268:
Line #269:
Line #270:echo($newpage);
Line #271:for ($i=0;$jegy_row>$i;$i++) { echo('<br>');}
Line #272:
Line #273:include($nyomtat_Form);
Line #274:$newpage="<p id='page_break'></p>";
Line #275:}
Line #276:
Line #277:$elad = "UPDATE `qj_jegy` SET
Line #278:`nyugta_szam`='$Jnyugta_szam'
Line #279:WHERE wid='".$wid."'";
Line #280:
Line #281:}
Line #282:///////////////////////////////////////////
Line #283:
Line #284: unset ($_SESSION['szinfo['.$bond.']']);
Line #285: unset ($_SESSION['katind('.$bond.')']);
Line #286: unset ($_SESSION['dkod('.$bond.')']);
Line #287: unset ($_SESSION['jfej('.$bond.')']);
Line #288: unset ($_SESSION['ear('.$bond.')']);
Line #289:
Line #290:////////////////////////////////////
Line #291:
Line #292://////////////////////
Line #293: ++$si;
Line #294:
Line #295://////////////////////
Line #296:
Line #297:unset ($_SESSION['J4x']);
Line #298:unset ($_SESSION['ReszletIr']);
Line #299:
Line #300:
Line #301:if (isset($_SESSION[Jbcsoport]) )
Line #302:{
Line #303:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #304:WHERE datum_kod='".$dk."'";
Line #305:
Line #306:
Line #307://$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #308://WHERE JeBe='Nyugta'";
Line #309:
Line #310:
Line #311:$elad = "UPDATE `qj_login` SET future='$NYlast_index'
Line #312:WHERE future='LastIndex'";
Line #313:
Line #314:
Line #315:echo($newpage);
Line #316:for ($i=0;$jegy_row>$i;$i++) { echo('<br>'); }
Line #317:
Line #318:$arnev=$csarform;
Line #319:$ear=$csear;
Line #320:///////////////////////////////////
Line #321:include($nyomtat_Form);
Line #322:///////////////////////////////////
Line #323:
Line #324:unset($_SESSION['Jbcsoport']);
Line #325:
Line #326:}
Line #327:
Line #328:?>
Line #329:
Line #330:<SCRIPT Language="Javascript">
Line #331:
Line #332:function printit(call_cod,login){
Line #333:
Line #334://if (login=="BI(c)") {
Line #335:alert("No print"+login+call_cod);
Line #336:window.open("QJ_helyrajz.php?&musor_kod="+call_cod, 'adatframe');
Line #337://} else {
Line #338://window.print();
Line #339://window.open("QJ_helyrajz.php?&musor_kod="+call_cod, 'adatframe');
Line #340://window.open("QJ_gyujto.php", 'sframe');
Line #341://}
Line #342://~*~// QJ_nyomtat.php
Line #343:
Line #344:}
Line #345:
Line #346:</script>
Line #347:
Line #348:<body CELLSPACING='0' CELLPADDING='0' onload="printit('<? echo($_SESSION[CALL_KOD]); ?>','<? echo($_SESSION[login]); ?>')">
Line #349:</body>