Bi-Dir

QB_nyomtat_20161208_MC_CV.inc

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