QQ_szekINVERZ.inc

---

Line #0:<?php
Line #1:
Line #2:$hely_kod=$_GET[hely_kod];
Line #3:
Line #4:if (isset($_GET[sor])) $werS=" and qj_sor_s='".$_GET[sor]."' "; else $werS="";
Line #5:
Line #6:$Skeres = "SELECT * FROM qj_szinpad where hely_kod='".$hely_kod. "'";
Line #7:
Line #8:$Snur=mysql_num_rows($Seredmeny);
Line #9:$szinpad=mysql_fetch_array($Seredmeny);
Line #10:
Line #11:if ($szinpad[hely_url]=="") $align=" width=600 align=center "; else $align=$szinpad[hely_url];
Line #12:
Line #13:
Line #14://$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' and archiv='~' and left(szek_kod,3)>'012' ORDER BY szek_kod";
Line #15:$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' and archiv='~' $werS ORDER BY szek_kod";
Line #16:
Line #17:
Line #18:
Line #19:echo ($sor."/".$_GET[kozep]."/".$_GET[oldal]."/".$parancs."<hr>");
Line #20:
Line #21:while ( $disW = mysql_fetch_array( $disQ )) {
Line #22:
Line #23:$_GET[kozep]= substr($disW[szek_kod],-3);
Line #24:$sor=substr($disW[szek_kod],0,3);
Line #25:
Line #26:echo ($sor."/".$_GET[kozep]."/".$_GET[oldal]."/".$parancs."<hr>");
Line #27:
Line #28:
Line #29:if (isset($_GET[kozep])) {
Line #30: if ($_GET[oldal]=="bal") $wer=" and right(szek_kod,3)<'$_GET[kozep]' ";
Line #31:// else
Line #32:// $wer=" and right(szek_kod,3)>'$_GET[kozep]' ";
Line #33: } else $wer="";
Line #34:
Line #35:$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' and left(szek_kod,3)='$sor' and not instr(qj_sor_n,'*EOF') ORDER BY szek_kod,wid desc";
Line #36:
Line #37:
Line #38:
Line #39:echo ($_GET[hely_kod]."/".$_GET[kozep]."/".$_GET[oldal]."/".$parancs."<hr>");
Line #40:
Line #41:$sor_kod="?";
Line #42:while ( $disC = mysql_fetch_array( $disR )) {
Line #43:
Line #44:if (substr($disC[szek_kod],0,3)<>$sor_kod) {
Line #45: $sor_kod=substr($disC[szek_kod],0,3);
Line #46: $minid=1;
Line #47: if ($disC[qj_sor_h]==1) { $hely=$_GET[kozep]; $lep=-1; } else { $hely=0; $lep=+1; }
Line #48:}
Line #49:
Line #50:if (isset($_GET[szamoz])) {
Line #51: $hely=$hely+$lep;
Line #52: $sir=$sor+0;
Line #53: $szamoz=" , qj_sor_s='".$sir."' , qj_sor_h='".substr(" ".$hely,-2)."'";
Line #54: if ($hely==0 or $_GET[kozep]==substr("000".$minid,-3) ) { $lep=(-1)*$lep; $szamoz.=" , archiv='~' "; } else $szamoz.=" , archiv='-' ";
Line #55:} else $szamoz="";
Line #56:
Line #57:if (isset($_GET[oldal])) $oldal=" , qj_sor_o='$_GET[oldal]' "; else $oldal="";
Line #58:
Line #59:$ujkod=$sor_kod."/".substr("000".$minid,-3);
Line #60:++$minid;
Line #61:
Line #62:if (isset($_GET[oldal])) $oldal=" , qj_sor_o='$_GET[oldal]' "; else $oldal="";
Line #63:$wid=$disC[wid];
Line #64:
Line #65://if (isset($_GET[kozep]) and $_GET[oldal]<>"bal" and $_GET[kozep]>=substr($disC[szek_kod],-3) ) $wid=0; // ne fusson
Line #66:
Line #67:if (isset($_GET[kozep]) and $_GET[kozep]<substr("000".$minid,-3))
Line #68: $oldal=" , qj_sor_o='jobb' "; else $oldal=" , qj_sor_o='bal' ";
Line #69:
Line #70:$newrec = "UPDATE qj_szek SET szoveg='$ujkod' $szamoz $oldal WHERE wid=".$wid. " Limit 1 " ;
Line #71:mysql_query($newrec) or die($newrec." Hiba");
Line #72:
Line #73:echo ($newrec."<br>");
Line #74:
Line #75:}
Line #76:
Line #77:///
Line #78: }
Line #79:///
Line #80:
Line #81:if (isset($_GET[jegy])) {
Line #82:
Line #83:$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' $werS ORDER BY szek_kod";
Line #84:
Line #85:echo ($sor."/".$_GET[kozep]."/".$_GET[oldal]."/".$parancs."<hr>");
Line #86:
Line #87:while ( $disW = mysql_fetch_array( $disQ )) {
Line #88: $hely_kod=$disW[hely_kod];
Line #89: $archiv=$disW[archiv];
Line #90: $szek_kod=$disW[szek_kod];
Line #91: $szek_new=$disW[szoveg];
Line #92: $n=$disW[qj_sor_n];
Line #93: $s=$disW[qj_sor_s];
Line #94: $o=$disW[qj_sor_o];
Line #95: $h=$disW[qj_sor_h];
Line #96: $arkategoria=$disW[qj_katind];
Line #97: $newrec = "UPDATE qj_jegy SET szek_kod='$szek_new',arkategoria='$arkategoria',
Line #98: QJ_sor_n='$n', QJ_sor_s='$s', QJ_sor_o='$o', QJ_sor_h='$h'
Line #99: WHERE hely_kod='$hely_kod' and szek_kod='$szek_kod'" ;
Line #100:echo ($newrec."<hr>");
Line #101: mysql_query($newrec) or die($newrec." Hiba");
Line #102:}}
Line #103:
Line #104:$newrec = "UPDATE qj_szek SET szek_kod=szoveg WHERE hely_kod='$hely_kod' and szoveg<>''";
Line #105:echo ($newrec."<hr>");
Line #106:mysql_query($newrec) or die($newrec." Hiba");
Line #107:
Line #108://echo "<script>
Line #109:// window.open('ON_helyrajz.php?&musor_kod=$hely_kod', 'infoframe');
Line #110:
Line #111://</script>";
Line #112:?>