Bi-Dir

MH_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:
Line #130:$AFA_jel=$egy_sor[AFA_jel];
Line #131:
Line #132:IF (trim($egy_sor[AFA_jel])<>"") $afasz=$egy_sor[AFA_jel]; else $afasz="";
Line #133:
Line #134:
Line #135:$cimkieg1=$egy_sor[cimkieg1];
Line #136://?// IF (trim($cimkieg1)<>"") --$jegy_row;
Line #137:
Line #138:$cimkieg2=$egy_sor[cimkieg2];
Line #139:$cimkieg3=$egy_sor[cimkieg3];
Line #140:$erkezesi=$egy_sor[erkezesi];
Line #141:$Merkezesi=$egy_sor[erkezesi];
Line #142:$wjid=$egy_sor[wid];
Line #143:$belepo=$egy_sor[datum_fej];
Line #144:$FormaJel=$egy_sor[FormaJel];
Line #145:$JeBe=$egy_sor[JeBe];
Line #146:
Line #147:$wid=$egy_sor2[wid];
Line #148:$ar_nev=$egy_sor2[ar_nev];
Line #149:
Line #150:$Jnyugta_szam="Ssz:".substr('000000'.$NYlast_index,-6);
Line #151:
Line #152:/*
Line #153:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #154:WHERE datum_kod='".$dk."'";
Line #155:
Line #156:
Line #157:$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #158:WHERE JeBe='Nyugta'";
Line #159:
Line #160:*/
Line #161:
Line #162:$elad = "UPDATE `qj_jegy` SET
Line #163:`bizonylatszam`='$bizonylatszam',`FormaJel`='$FormaJel',`JeBe`='$JeBe',
Line #164:`nyugta_szam`='$Jnyugta_szam',
Line #165:`printdatum`=now()
Line #166:WHERE wid='".$wid."'";
Line #167://echo($elad."<hr>");
Line #168:
Line #169:
Line #170:
Line #171://///////////////////////////////////////////////////////////////
Line #172:$print="SELECT printdatum FROM qj_jegy WHERE wid='".$wid."'";
Line #173:
Line #174:$kegy_sor = mysql_fetch_array( $keredmeny );
Line #175:
Line #176:$today = $kegy_sor[printdatum];
Line #177:
Line #178:$szigoru=$bizonylatszam."/".$egy_sor2[datum_kod]."/".substr('0000000'.$egy_sor2[wid],-5);
Line #179:
Line #180:$SQLarc = "UPDATE `qj_archive` SET
Line #181:`bizonylatszam`='$szigoru',`FormaJel`='$FormaJel',`JeBe`='$JeBe',
Line #182:`nyugta_szam`='$Jnyugta_szam',
Line #183:`printdatum`=now()
Line #184:WHERE widarc='".$wid."' and bizonylatszam='' order by logtime DESC LIMIT 1";
Line #185://echo($elad."<hr>");
Line #186:
Line #187:
Line #188:
Line #189:
Line #190:
Line #191://<td ALIGN=left>Kelt: $today</td>
Line #192:
Line #193:if (isset($_SESSION[Jbcsoport]) )
Line #194:{
Line #195:////// if (($csear<>$egy_sor2[ar] or $arnev<>$egy_sor2[ar_nev] or $csear==0) and $csear<>-1){
Line #196:
Line #197:if (($csear<>$egy_sor2[ar] or $arnev<>$egy_sor2[ar_nev] ) and $csear<>-1){
Line #198:$arnev=$csarform;
Line #199:$ear=$csear;
Line #200:
Line #201:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #202:WHERE datum_kod='".$dk."'";
Line #203:
Line #204:
Line #205://$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #206://WHERE JeBe='Nyugta'";
Line #207:
Line #208:
Line #209:$elad = "UPDATE `qj_login` SET future='$NYlast_index'
Line #210:WHERE email_kod='LastIndex'";
Line #211:
Line #212:
Line #213:echo($newpage);
Line #214:for ($i=0;$jegy_row>$i;$i++) {echo('<br>'); }
Line #215:include("QJ_nyomtat_MHForm.php");
Line #216:$newpage="<p id='page_break'></p>";
Line #217:
Line #218://$keres3 = "SELECT * FROM qj_musor WHERE JeBe='Nyugta'";
Line #219:
Line #220://$NY_sor = mysql_fetch_array( $eredmeny );
Line #221://$NYlast_index=$NY_sor[last_index]+1;
Line #222:
Line #223:$keres3 = "SELECT future FROM qj_login WHERE email_kod='LastIndex'";
Line #224:
Line #225:$NY_sor = mysql_fetch_array( $eredmeny );
Line #226:$NYlast_index=$NY_sor[future]+1;
Line #227:
Line #228:
Line #229:
Line #230:$keres3 = "SELECT * FROM qj_musor WHERE datum_kod='$dk'";
Line #231:
Line #232:$egy_sor = mysql_fetch_array( $eredmeny );
Line #233:$last_index=$egy_sor[last_index]+1;
Line #234:
Line #235:$Jnyugta_szam="Ssz:".substr('000000'.$NYlast_index,-6);
Line #236:$db=0;
Line #237:$ft=0;
Line #238:}
Line #239:
Line #240:$ear=$egy_sor2[ar];
Line #241:$arnev=$egy_sor2[ar_nev];
Line #242:$csarform=$arnev;
Line #243:$csear=$ear;
Line #244:
Line #245:++$db;
Line #246:$ft=$ft+$ear;
Line #247:}
Line #248:
Line #249://///////
Line #250:if (!isset($_SESSION[Jbcsoport]) )
Line #251://///////
Line #252:{
Line #253:
Line #254:$ear=$egy_sor2[ar];
Line #255:$arnev=$egy_sor2[ar_nev];
Line #256:$csarform=$arnev;
Line #257:$csear=$ear;
Line #258:
Line #259:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #260:WHERE datum_kod='".$dk."'";
Line #261:
Line #262:
Line #263://$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #264://WHERE JeBe='Nyugta'";
Line #265:
Line #266:
Line #267:$elad = "UPDATE `qj_login` SET future='$NYlast_index'
Line #268:WHERE email_kod='LastIndex'";
Line #269:
Line #270:
Line #271:echo($newpage);
Line #272:for ($i=0;$jegy_row>$i;$i++) { echo('<br>');}
Line #273:
Line #274:include("QJ_nyomtat_MHForm.php");
Line #275:$newpage="<p id='page_break'></p>";
Line #276:}
Line #277:
Line #278:$elad = "UPDATE `qj_jegy` SET
Line #279:`nyugta_szam`='$Jnyugta_szam'
Line #280:WHERE wid='".$wid."'";
Line #281:
Line #282:}
Line #283:///////////////////////////////////////////
Line #284:
Line #285: unset ($_SESSION['szinfo['.$bond.']']);
Line #286: unset ($_SESSION['katind('.$bond.')']);
Line #287: unset ($_SESSION['dkod('.$bond.')']);
Line #288: unset ($_SESSION['jfej('.$bond.')']);
Line #289: unset ($_SESSION['ear('.$bond.')']);
Line #290:
Line #291:////////////////////////////////////
Line #292:
Line #293://////////////////////
Line #294: ++$si;
Line #295:
Line #296://////////////////////
Line #297:
Line #298:unset ($_SESSION['J4x']);
Line #299:unset ($_SESSION['ReszletIr']);
Line #300:
Line #301:
Line #302:if (isset($_SESSION[Jbcsoport]) )
Line #303:{
Line #304:$elad = "UPDATE `qj_musor` SET last_index='$last_index'
Line #305:WHERE datum_kod='".$dk."'";
Line #306:
Line #307:
Line #308://$elad = "UPDATE `qj_musor` SET last_index='$NYlast_index'
Line #309://WHERE JeBe='Nyugta'";
Line #310:
Line #311:
Line #312:$elad = "UPDATE `qj_login` SET future='$NYlast_index'
Line #313:WHERE future='LastIndex'";
Line #314:
Line #315:
Line #316:echo($newpage);
Line #317:for ($i=0;$jegy_row>$i;$i++) { echo('<br>'); }
Line #318:
Line #319:$arnev=$csarform;
Line #320:$ear=$csear;
Line #321:///////////////////////////////////
Line #322:include("QJ_nyomtat_MHForm.php");
Line #323:///////////////////////////////////
Line #324:
Line #325:unset($_SESSION['Jbcsoport']);
Line #326:
Line #327:}
Line #328:
Line #329:?>
Line #330:
Line #331:<SCRIPT Language="Javascript">
Line #332:
Line #333:function printit(call_cod,login){
Line #334:
Line #335:if (login=="BI(c)") {
Line #336:alert("No print"+login+call_cod);
Line #337:window.open("QJ_helyrajz.php?&musor_kod="+call_cod, 'adatframe');
Line #338:} else {
Line #339:window.print();
Line #340:window.open("QJ_helyrajz.php?&musor_kod="+call_cod, 'adatframe');
Line #341:window.open("QJ_gyujto.php", 'sframe');
Line #342:}
Line #343://~*~// QJ_nyomtat.php
Line #344:
Line #345:}
Line #346:
Line #347:</script>
Line #348:
Line #349:<body CELLSPACING='0' CELLPADDING='0' onload="printit('<? echo($_SESSION[CALL_KOD]); ?>','<? echo($_SESSION[login]); ?>')">
Line #350:</body>