Bi-Dir

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