Bi-Dir

QJ_evadBERLETvevok.inc

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