Bi-Dir

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