Bi-Dir

QQ_musorSOROKkarb.inc

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