Bi-Dir

QJ_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:$keres = "SELECT * FROM qj_musor where hely_kod='$hely_kod'";
Line #7:
Line #8:
Line #9:$musor = mysql_fetch_array( $eredmeny );
Line #10:
Line #11:
Line #12:</H3>");
Line #13:
Line #14:echo "<table border=1>
Line #15:<tr bgcolor=gold>
Line #16:<td align=right >Kat.</td>
Line #17:<td align=right >Sor ind</td>
Line #18:
Line #19:
Line #20:<td align=right >Hely-ig</td>
Line #21:<td align=right >Db</td>
Line #22:<td align=right >Elrejt</td>
Line #23:<td align=right >Jegy</td>
Line #24:<td align=right >SorUPD</td>
Line #25:
Line #26:<td align=right >+++</td>
Line #27:
Line #28:</tr>";
Line #29:
Line #30:
Line #31:$wkat=0;
Line #32:$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' ORDER BY szek_kod";
Line #33://$parancs="SELECT * FROM qj_szek where hely_kod='$hely_kod' and archiv='-' ORDER BY szek_kod";
Line #34://echo($parancs."<hr>");
Line #35:
Line #36:
Line #37:
Line #38:$i=0;
Line #39:$ii=0;
Line #40:$wszeksor="?";
Line #41:$azonos=true;
Line #42:$wstatus="?";
Line #43:$tol="?";
Line #44:$ig="?";
Line #45:$htol="?";
Line #46:$hig="?";
Line #47:$wid=0;
Line #48:$woldal ="?";
Line #49:$szin="";
Line #50:
Line #51:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #52:{
Line #53:
Line #54://$szek_kod = -$egy_sor[szek_kod];
Line #55:$wszeksor=substr($egy_sor[szek_kod],0,3);
Line #56:$woldal = $egy_sor[qj_sor_o];
Line #57:$sorrend=substr($szek_kod,0,4).substr($egy_sor[szek_kod],-2);
Line #58:$szek=substr($egy_sor[szek_kod],-3);
Line #59:
Line #60:if ( $i==0 )
Line #61:{
Line #62:$szeksor=$wszeksor;
Line #63:$oldal =$woldal;
Line #64:}
Line #65:
Line #66://echo($i."/".$egy_sor[szoveg]."/".$egy_sor[szek_kod]."/".$szeksor."/".$wszeksor."/".$oldal."/".$woldal."<hr>");
Line #67:////////////////////
Line #68:
Line #69:if ($wszeksor<>$szeksor or $woldal <> $oldal or strpos("?".$egy_sor[qj_sor_n],"EOF")>0) {
Line #70: helyszinOSZ();
Line #71:}
Line #72:
Line #73:if ($tol=="?") { $tol=$szek; $htol=$egy_sor[qj_sor_h]; }
Line #74:$ig=$szek; $hig=$egy_sor[qj_sor_h];
Line #75:
Line #76:$wid=$egy_sor[wid];
Line #77:
Line #78:$katind = $egy_sor[qj_katind];
Line #79:if ($katind==0) $katind=1;
Line #80:$qj_sor_n = $egy_sor[qj_sor_n];
Line #81:$qj_sor_s = $egy_sor[qj_sor_s];
Line #82:$qj_sor_o = $egy_sor[qj_sor_o];
Line #83:$qj_sor_h = $egy_sor[qj_sor_h];
Line #84:$erkezesi = $egy_sor[erkezesi];
Line #85:
Line #86:if ($wstatus<>$egy_sor[statusz]) $azonos=false;
Line #87:if ($i==0) $wstatus=$egy_sor[statusz];
Line #88:
Line #89:++$i;
Line #90:++$ii;
Line #91:$szeksor=$wszeksor;
Line #92:$oldal =$woldal;
Line #93:
Line #94:if ($wkat<>$egy_sor[qj_katind]) {
Line #95:
Line #96:if ($szin=="") $szin="bgcolor=aqua"; else $szin="";
Line #97:
Line #98:}
Line #99:
Line #100:$wkat=$egy_sor[qj_katind];
Line #101:
Line #102:
Line #103:
Line #104:
Line #105:}
Line #106:
Line #107:helyszinOSZ();
Line #108:
Line #109:echo "<tr bgcolor=silver>
Line #110:
Line #111:</td>
Line #112:<td width=20 align=left ></td>
Line #113:<td width=20 align=right > $ii</td>
Line #114:<td> Db</td>
Line #115:</tr>";
Line #116:
Line #117:echo "
Line #118:</table>";
Line #119:
Line #120:///////////////////////////
Line #121:function helyszinOSZ() {
Line #122:///////////////////////////
Line #123:
Line #124:global $hely_kod;
Line #125:global $szeksor;
Line #126:global $katind;
Line #127:global $qj_sor_n;
Line #128:global $qj_sor_s;
Line #129:global $qj_sor_o;
Line #130:global $qj_sor_h;
Line #131:global $erkezesi;
Line #132:global $azonos;
Line #133:global $i;
Line #134:global $tol;
Line #135:global $ig;
Line #136:global $htol;
Line #137:global $hig;
Line #138:global $wid;
Line #139:global $datum_kod;
Line #140:global $oldal;
Line #141:global $szin;
Line #142:
Line #143: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 #144:else $rel=$qj_sor_n;
Line #145:
Line #146:
Line #147: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 #148:else $rel_rejt="";
Line #149:
Line #150:
Line #151:else $erkezes="";
Line #152:
Line #153:
Line #154:IF ($_SESSION[login]=="BI(c)") $jegy_IR="<a target=infoframe href='BiViewTable.php?&tabla=qj_jegy&sql=// hely_kod=~$hely_kod~ and left(szek_kod,3)=~$szeksor~'>".SOR_IR."</a>";
Line #155:else $jegy_IR="";
Line #156:
Line #157:
Line #158:
Line #159:else $erkezes="";
Line #160:
Line #161:IF ($_SESSION[login]=="BI(c)") $szekview="<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 #162:else $szekview="";
Line #163:
Line #164: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'>".$wid."</a>";
Line #165:else $szekkarb="";
Line #166:
Line #167:IF ($_SESSION[login]=="BI(c)")
Line #168:$katkarb="<a target=infoframe
Line #169:href='QJ_sqlJEGY.php?&parancs=// Update qj_szek set qj_katind=~$katind~ where hely_kod=~$hely_kod~ and left(szek_kod,3)=~$szeksor~'>
Line #170:<img border=0 src='../_Screen/edit.png'>".$katind."</a>";
Line #171:else $katkarb=$katind;
Line #172:
Line #173:if ($azonos==true) $zar="red"; else $zar="";
Line #174:$zar="";
Line #175:
Line #176:echo "<tr ".$szin.">
Line #177:<td align=right >".$katkarb.". K
Line #178:</td>
Line #179:<td width=20 align=left > $szeksor</td>
Line #180:<td align=right > $rel 
Line #181:</td>
Line #182:<td width=30 align=left >$oldal $qj_sor_s</td>
Line #183:<td width=20 align=left > $tol $htol </td>
Line #184:<td width=20 align=left > $ig $hig</td>
Line #185:
Line #186:<td width=20 align=right > $i</td>
Line #187:
Line #188:<td> $rel_rejt </td>
Line #189:<td> $jegy_IR $szekview </td>
Line #190:<td> $szekkarb</td>
Line #191:<td> $plussor $erkezes </td>
Line #192:<td bgcolor=$zar> $wstatus
Line #193:
Line #194:</td>
Line #195:</tr>";
Line #196:
Line #197:$tol="?";
Line #198:$ig="?";
Line #199:$oldal ="?";
Line #200:$i=0;
Line #201:$azonos=true;
Line #202:
Line #203:}
Line #204:
Line #205:////////////////////
Line #206:
Line #207:
Line #208:?>
Line #209: