QB_nyomtat.inc

---

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