Bi-Dir

QQ_helyszinOSZ.inc

Line #0:<?php
Line #1:
Line #2:$login=$_SESSION['login'];
Line #3:$hely_kod=$_GET[hely_kod];
Line #4:$datum_kod=$_GET[datum_kod];
Line #5:
Line #6:
Line #7:$Skeres = "SELECT * FROM qj_szinpad where hely_kod='".$hely_kod. "'";
Line #8:
Line #9:$Snur=mysql_num_rows($Seredmeny);
Line #10:$szinpad=mysql_fetch_array($Seredmeny);
Line #11:
Line #12:if ($szinpad[hely_url]=="") $align=" width=600 align=center "; else $align=$szinpad[hely_url];
Line #13:$wjid=$szinpad[wid];
Line #14:
Line #15:$keres = "SELECT * FROM qj_musor where hely_kod='$hely_kod'";
Line #16:
Line #17:
Line #18:$musor = mysql_fetch_array( $eredmeny );
Line #19:
Line #20:IF ($_SESSION[login]=="BI(c)") {
Line #21:
Line #22:href='BiViewTable.php?&tabla=qj_szek&sql=// hely_kod=~$hely_kod~ '>
Line #23:<img width=30 height=30 src='../_Screen/edit.png' border=0></a>";
Line #24:
Line #25:
Line #26:href='_QQ_szekINVERZ.php?&hely_kod=$hely_kod'>
Line #27:<img width=30 height=30 src='../_Screen/run.bmp' border=0></a>";
Line #28:
Line #29:
Line #30:href='BiCopyTable.php?tabla=qj_szek&wer=%where%hely_kod=~$hely_kod~%'>
Line #31:<img width=50 height=50 src='../_Screen/sql.png' border=0></a>";
Line #32:
Line #33:
Line #34:href='QJ_sqlJEGY.php?&parancs=// Update qj_szek set qj_katind=~1~, erkezesi=~Y~
Line #35: where hely_kod=~$hely_kod~ and left(szek_kod,3)=~$szeksor~'>
Line #36:<img width=50 height=50 src='../_Screen/alert.red.png' border=0></a>";
Line #37:
Line #38:
Line #39:href='BI_sqlRECopy.php?&wjid=$wjid&tabla=qj_szinpad'>
Line #40:<img width=50 height=50 src='../_Screen/box1.png' border=0></a>";
Line #41:}
Line #42:
Line #43:
Line #44:href='ON_helyrajz.php?&musor_kod=".$hely_kod."'>
Line #45:
Line #46:
Line #47:echo("<a href=QQ_helyszinOSZ.php?&hely_kod=$hely_kod>
Line #48:<img src='../_Screen/refresh.gif' border=0></a>
Line #49: $hely_kod: $musor[helyszin]
Line #50:
Line #51:<a target=infoframe href=QQ_helyszinOSZ.php?&hely_kod=$hely_kod>
Line #52:<img src='../_Screen/refresh.gif' border=0></a>
Line #53: $rel_hrajz    
Line #54:$plussor   $SQLexport   $align   $szekkarb");
Line #55:
Line #56:echo "<table border=1>
Line #57:<tr bgcolor=gold>
Line #58:<td align=right >Kat.</td>
Line #59:<td align=right >Sor ind</td>
Line #60:
Line #61:
Line #62:<td align=right >Hely-ig</td>
Line #63:<td align=right >Db</td>
Line #64:<td align=right >Elrejt</td>
Line #65:<td align=right >Jegy</td>
Line #66:<td align=right >SorUPD</td>
Line #67:
Line #68:<td align=right >+++</td>
Line #69:
Line #70:</tr>";
Line #71:
Line #72:
Line #73:$wkat=0;
Line #74:$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' ORDER BY sorrend,szek_kod";
Line #75://$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' and archiv='-' ORDER BY szek_kod";
Line #76://echo($parancs."<hr>");
Line #77:
Line #78:
Line #79:
Line #80:$i=0;
Line #81:$ii=0;
Line #82:$wszeksor="?";
Line #83:$azonos=true;
Line #84:$wstatus="?";
Line #85:$tol="?";
Line #86:$ig="?";
Line #87:$htol="?";
Line #88:$hig="?";
Line #89:$wid=0;
Line #90:$woldal ="?";
Line #91:$szin="";
Line #92:$Srend="";
Line #93:
Line #94:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #95:{
Line #96:
Line #97://$szek_kod = -$egy_sor[szek_kod];
Line #98:$wszeksor=substr($egy_sor[szek_kod],0,3);
Line #99:$woldal = $egy_sor[qj_sor_o];
Line #100:$sorrend=substr($szek_kod,0,4).substr($egy_sor[szek_kod],-2);
Line #101:$szek=substr($egy_sor[szek_kod],-3);
Line #102:
Line #103:if ( $i==0 )
Line #104:{
Line #105:$szeksor=$wszeksor;
Line #106:$oldal =$woldal;
Line #107:}
Line #108:
Line #109://echo($i."/".$egy_sor[szoveg]."/".$egy_sor[szek_kod]."/".$szeksor."/".$wszeksor."/".$oldal."/".$woldal."<hr>");
Line #110:////////////////////
Line #111:
Line #112:if ($wszeksor<>$szeksor or $woldal <> $oldal or strpos("?".$egy_sor[qj_sor_n],"EOF")>0) {
Line #113: helyszinOSZ();
Line #114:}
Line #115:
Line #116:if ($tol=="?") { $tol=$szek; $htol=$egy_sor[qj_sor_h]; }
Line #117:$ig=$szek; $hig=$egy_sor[qj_sor_h];
Line #118:
Line #119:$wid=$egy_sor[wid];
Line #120:
Line #121:$katind = $egy_sor[qj_katind];
Line #122:if ($katind==0) $katind=1;
Line #123:$qj_sor_n = $egy_sor[qj_sor_n];
Line #124:$qj_sor_s = $egy_sor[qj_sor_s];
Line #125:$qj_sor_o = $egy_sor[qj_sor_o];
Line #126:$qj_sor_h = $egy_sor[qj_sor_h];
Line #127:$erkezesi = $egy_sor[erkezesi];
Line #128:$Srend = $egy_sor[sorrend];
Line #129:
Line #130:if ($wstatus<>$egy_sor[statusz]) $azonos=false;
Line #131:if ($i==0) $wstatus=$egy_sor[statusz];
Line #132:
Line #133:++$i;
Line #134:++$ii;
Line #135:$szeksor=$wszeksor;
Line #136:$oldal =$woldal;
Line #137:
Line #138:if ($wkat<>$egy_sor[qj_katind]) {
Line #139:
Line #140:if ($szin=="") $szin="bgcolor=aqua"; else $szin="";
Line #141:
Line #142:}
Line #143:
Line #144:$wkat=$egy_sor[qj_katind];
Line #145:
Line #146:
Line #147:
Line #148:
Line #149:}
Line #150:
Line #151:
Line #152:helyszinOSZ();
Line #153:
Line #154:echo "<tr bgcolor=silver>
Line #155:
Line #156:</td>
Line #157:<td width=20 align=left ></td>
Line #158:<td width=20 align=right > $ii</td>
Line #159:<td> Db</td>
Line #160:</tr>";
Line #161:
Line #162:echo "
Line #163:</table>";
Line #164:
Line #165:///////////////////////////
Line #166:function helyszinOSZ() {
Line #167:///////////////////////////
Line #168:
Line #169:global $hely_kod;
Line #170:global $szeksor;
Line #171:global $katind;
Line #172:global $qj_sor_n;
Line #173:global $qj_sor_s;
Line #174:global $qj_sor_o;
Line #175:global $qj_sor_h;
Line #176:global $erkezesi;
Line #177:global $azonos;
Line #178:global $i;
Line #179:global $tol;
Line #180:global $ig;
Line #181:global $htol;
Line #182:global $hig;
Line #183:global $wid;
Line #184:global $datum_kod;
Line #185:global $oldal;
Line #186:global $szin;
Line #187:global $Srend;
Line #188:
Line #189:IF ($_SESSION[login]=="BI(c)") $rel="<a target=infoframe href='BiViewTable.php?&tabla=qj_szek&sql=// hely_kod=~$hely_kod~ and left(szek_kod,3)=~$szeksor~'>".$qj_sor_n."</a>";
Line #190:else $rel=$qj_sor_n;
Line #191:
Line #192:
Line #193:IF ($_SESSION[login]=="BI(c)") $rel_rejt="<a target=infoframe href='QJ_sqlJEGY.php?&parancs=// Update qj_jegy set archiv=~X~ where hely_kod=~$hely_kod~ and left(szek_kod,3)=~$szeksor~'>".ELREJT."</a>";
Line #194:else $rel_rejt="";
Line #195:
Line #196:IF ($_SESSION[login]=="BI(c)")
Line #197:
Line #198:else $rel_kategoria="";
Line #199:
Line #200:
Line #201:else $erkezes="";
Line #202:
Line #203:// wid widarc usr_kod szoveg archiv future sql_memo sql_parancs SQL_Title SQL_jpg logtime
Line #204:
Line #205:IF ($_SESSION[login]=="BI(c)")
Line #206:$tervezo="<a target=infoframe
Line #207:href='QJ_sqlJEGY.php?&parancs= INSERT ! INTO !`qj_temp` !(`szoveg`,`sql_memo`,`sql_parancs`,`SQL_Title`,`SQL_jpg`)!
Line #208:VALUES!
Line #209:
Line #210:else $tervezo="";
Line #211:
Line #212:IF ($_SESSION[login]=="BI(c)")
Line #213:$tervezo="<a target=infoframe
Line #214:
Line #215:else $tervezo="";
Line #216:
Line #217:
Line #218:else $tervezoView="";
Line #219:
Line #220:
Line #221:
Line #222:else $jegy_IR="";
Line #223:
Line #224:
Line #225:else $erkezes="";
Line #226:
Line #227:IF ($_SESSION[login]=="BI(c)")
Line #228:$szekview="<a target=sframe href='BiViewTable.php?&tabla=qj_szek
Line #229:
Line #230:else $szekview="";
Line #231:
Line #232:
Line #233:IF ($_SESSION[login]=="BI(c)") $szekkarb="<a target=infoframe href='BI_szekSORkarb.php?&tabla=qj_szek&wjid=$wid&hely_kod=$hely_kod&sor=$szeksor&tol=$tol&ig=$ig'>Upd:".$wid."</a>";
Line #234:else $szekkarb="";
Line #235:
Line #236:if ($azonos==true) $zar="red"; else $zar="";
Line #237:$zar="";
Line #238:
Line #239:
Line #240:IF ($_SESSION[login]=="BI(c)")
Line #241:$wstatus="<a target=infoframe
Line #242:href='QJ_sqlJEGY.php?&parancs=Update!qj_szek!set!sorrend=~%%3%%~!where!hely_kod=~$hely_kod~!and!szek_kod>=~$szeksor/$tol~!and!szek_kod<=~$szeksor/$ig~' >Sorrend</a>";
Line #243:else $wstatus="";
Line #244:
Line #245://$_SESSION[sql_PARANCS]="Update!qj_szek!set!sorrend=~$szeksor~!where!hely_kod=~$hely_kod~!and!szek_kod>~$szeksor/$tol~'!and!szek_kod<~$szeksor/$ig~'";
Line #246://IF ($_SESSION[login]=="BI(c)")
Line #247://$wstatus="<a target=infoframe href='QJ_sqlJEGY.php'> ".Sorrend."</a>";
Line #248://else $wstatus="";
Line #249:
Line #250:echo "<tr ".$szin.">
Line #251:<td align=right >".$katind.". K
Line #252:</td>
Line #253:<td width=20 align=left > $szeksor</td>
Line #254:<td align=right > $rel 
Line #255:</td>
Line #256:<td width=30 align=left >$oldal $qj_sor_s</td>
Line #257:<td width=20 align=left > $tol $htol </td>
Line #258:<td width=20 align=left > $ig $hig</td>
Line #259:
Line #260:<td width=20 align=right > $i</td>
Line #261:
Line #262:<td> $rel_rejt $rel_kategoria</td>
Line #263:<td> $jegy_IR $szekview </td>
Line #264:<td> $szekkarb</td>
Line #265:<td> $plussor $erkezes </td>
Line #266:<td bgcolor=$zar>$Srend $wstatus
Line #267:</td>
Line #268:<td bgcolor=$zar>
Line #269:$tervezo 
Line #270:$tervezoView
Line #271:</td>
Line #272:</tr>";
Line #273:
Line #274:$tol="?";
Line #275:$ig="?";
Line #276:$oldal ="?";
Line #277:$i=0;
Line #278:$azonos=true;
Line #279:
Line #280:}
Line #281:
Line #282:////////////////////
Line #283:
Line #284:
Line #285:?>
Line #286: