Bi-Dir

MK_nyomtat_MH.inc

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