OF_musorKORR.of

---

Line #0:<?php
Line #1://unset($_SESSION[SQL_inet]);
Line #2:if (!isset($_SESSION[SQL_inet])) {
Line #3:
Line #4:++$_SESSION[QJ_hiba];
Line #5:
Line #6:echo "<script>
Line #7:
Line #8: window.open('QJ_musorLIST.php','sframe');
Line #9: </script>";
Line #10:}
Line #11:$_SESSION[QJ_hiba]=0;
Line #12:
Line #13:
Line #14:
Line #15:include("BI_musorFILTER.php");
Line #16:
Line #17:if (!isset($_SESSION[SQL_inet])) {
Line #18:
Line #19:++$_SESSION[QJ_hiba];
Line #20:/*
Line #21:echo "<script>
Line #22:
Line #23: window.open('QJ_musorLIST.php','sframe');
Line #24: </script>";
Line #25:*/
Line #26:}
Line #27:$_SESSION[QJ_hiba]=0;
Line #28:
Line #29:
Line #30:
Line #31:if (isset($_GET[rogz])) {
Line #32:
Line #33:$wjid=$_GET[wjid];
Line #34:
Line #35:if ($_GET[rogz]=="Y")
Line #36:$SQLarc = "UPDATE `qj_musor` SET
Line #37: `erkezesi`=''
Line #38: where wid=$wjid LIMIT 1";
Line #39:
Line #40:else
Line #41:$SQLarc = "UPDATE `qj_musor` SET
Line #42: `erkezesi`='Y'
Line #43: where wid=$wjid LIMIT 1";
Line #44:
Line #45://echo($SQLarc."<hr>");
Line #46:mysql_query($SQLarc) or die($SQLarc." SQL Hiba");
Line #47:
Line #48:echo "<script>
Line #49: window.open('QJ_exit.php', 'adatframe');
Line #50: window.open('QJ_musSEL.php', 'alfej');
Line #51: </script>";
Line #52:
Line #53:
Line #54:}
Line #55:
Line #56:
Line #57:IF ($_SESSION[admin]<>"ADMIN") $archiv=" archiv <>'*' "; else $archiv=" future <>'*'";
Line #58:
Line #59:$archiv=" future <>'*'";
Line #60:$login=$_SESSION[login];
Line #61:IF (isset($_POST[sqlord])) $ord = " DESC"; else $ord="";
Line #62:if (isset($_SESSION[CALL_mezo])) $mezo=$_SESSION[CALL_mezo]; else $mezo="datum_fej";
Line #63:if (isset($_SESSION[CALL_ord])) $ord=$_SESSION[CALL_ord]; else $ord="";
Line #64:
Line #65:$latni="";
Line #66:if ($_POST[latni]==1) $latni=" and archiv<>'*' ";
Line #67:if ($_POST[latni]==2) $latni=" and archiv='*' ";
Line #68:
Line #69:
Line #70:$JeBe="";
Line #71:if ($_POST[JeBe]==1) $JeBe=" and JeBe='Jegy' ";
Line #72:
Line #73:
Line #74:
Line #75:
Line #76:$WEB="";
Line #77:if ($_POST[WEB]==1) $WEB=" and web<>'web' ";
Line #78:if ($_POST[WEB]==2) $WEB=" and web='web' ";
Line #79:
Line #80:$OFF="";
Line #81:if ($_POST[elmaradt]==1) $OFF=" and future='OFF' ";
Line #82:if ($_POST[elmaradt]==2) $OFF=" and future<>'OFF' ";
Line #83:
Line #84:
Line #85:
Line #86:if (isset($_POST[Desc])) $desc= " DESC"; else $desc= "";
Line #87:
Line #88:$keres = "SELECT * FROM qj_musor where $wer future <>'*' $latni $JeBe $WEB $OFF ORDER BY datum_fej $desc ,datum ";
Line #89:
Line #90://echo($keres."<hr>");
Line #91:
Line #92:
Line #93:$nur=mysql_num_rows($eredmeny);
Line #94:
Line #95:
Line #96:$e="<FORM name=musel target=adatframe
Line #97: action='QJ_listaHIV.php' method='post'>
Line #98: ";
Line #99:
Line #100:
Line #101:
Line #102:
Line #103: onchange=this.form.submit(); return true name='Lista_kod'>";
Line #104:
Line #105:
Line #106:$e.="<option value='QJ_katraport.php'>Raport lap</option>";
Line #107:$e.="<option value='QJ_raportNEW.php'>NEW Raport</option>";
Line #108:$e.="<option value='QJ_raportKONTROLL.php'>Kontroll Raport</option>";
Line #109:$e.="<option value='QJ_raportKONTROLLnapi.php'>Kontroll NAPI Raport</option>";
Line #110:$e.="<option value='QJ_raportKONTROLLista.php'>Kontroll Lista</option>";
Line #111:$e.="<option value='QJ_raportNOSTORNOLista.php'>NOSTORNO Kontroll Lista</option>";
Line #112:
Line #113:
Line #114:
Line #115:
Line #116:$e.="<option value='QJ_not.php'>Megmaradt helyek</option>";
Line #117:
Line #118:
Line #119:
Line #120:$e.="</SELECT>";
Line #121:
Line #122:
Line #123:
Line #124:
Line #125:
Line #126:
Line #127:
Line #128:
Line #129://$L_PHP="QJ_musorKORR.php";
Line #130://include("QJ_listafej.php");
Line #131:
Line #132:echo "<table border=1>
Line #133:<tr bgcolor=silver>
Line #134:<td align=right >&nbsp;</td>
Line #135:<td align=right ><b>Lista</b></td>
Line #136:
Line #137:
Line #138:
Line #139:<td align=right ><b>INFO</b></td>
Line #140:<td align=right bgcolor=red ><b><font color=white>WEB</font></b></td>
Line #141:</tr>";
Line #142:
Line #143:$i=0;
Line #144:while ( $musor = mysql_fetch_array( $eredmeny ) )
Line #145:{
Line #146:++$i;
Line #147:
Line #148:$helyszin_kod=$musor[hely_kod];
Line #149:$datum_kod=$musor[datum_kod];
Line #150:$cim_kod=$musor[cim_kod];
Line #151:$cim_url=$musor[cim_url];
Line #152:$kep_url=$musor[kep_url];
Line #153:$wjid=$musor[wid];
Line #154:
Line #155:
Line #156:$disQ = "SELECT * FROM qj_ear where datum_kod='$datum_kod' order by szoveg" ;
Line #157:
Line #158://echo($disQ."<hr>");
Line #159:
Line #160:$sel3="";
Line #161:$br="";
Line #162:
Line #163:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #164:
Line #165:/*$sel3.=$br.$disC[szoveg];
Line #166:if ($disC[qj_ear1]>0) $sel3.=" 1.Kat:<b>".$disC[qj_ear1]."<b>";
Line #167:if ($disC[qj_ear2]>0) $sel3.=" 2.Kat:<b>".$disC[qj_ear2]."<b>";
Line #168:if ($disC[qj_ear3]>0) $sel3.=" 3.Kat:<b>".$disC[qj_ear3]."<b>";
Line #169:if ($disC[qj_ear4]>0) $sel3.=" 4.Kat:<b>".$disC[qj_ear4]."<b>";
Line #170:$br="<br>";*/
Line #171:
Line #172:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #173:"<td align=right >
Line #174:<a target=infoframe href=BI_sqlRECopy.php?&wjid=$disC[wid]&tabla=qj_ear>
Line #175:jav</a></td><td align=right >&nbsp;<b>".$disC[szoveg]."</b></td>";
Line #176:
Line #177:if ($disC[qj_ear1]>0) $sel3.=" <td align=right >1.Kat:<b>".$disC[qj_ear1]."</b></td>";
Line #178:if ($disC[qj_ear2]>0) $sel3.=" <td align=right >2.Kat:<b>".$disC[qj_ear2]."</b></td>";
Line #179:if ($disC[qj_ear3]>0) $sel3.=" <td align=right >3.Kat:<b>".$disC[qj_ear3]."</b></td>";
Line #180:if ($disC[qj_ear4]>0) $sel3.=" <td align=right >4.Kat:<b>".$disC[qj_ear4]."</b></td>";
Line #181:$sel3.="</tr>";
Line #182:}
Line #183:
Line #184:
Line #185:if ($_SESSION[login]=="BI(c)") {
Line #186: $ie = '<td><a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.'"><img src=edit.png border=0></a></td>';
Line #187: $datum=$musor[datum]."<br><font color=red>".$musor[datum_fej]."</font>";
Line #188:} else {
Line #189: $ie='<td>'.$i.'</td>';
Line #190: $datum=$musor[datum];
Line #191:}
Line #192:
Line #193: $ie = '<td><a target=adatframe href="QJ_musorPUBLIC.php?&wjid='.$wjid.'">
Line #194: <img width=20 height=20 src="../_Screen/edit.png" border=0></a></td>';
Line #195:
Line #196: $datum=$musor[datum_fej];
Line #197:
Line #198:
Line #199:
Line #200:
Line #201:if ($musor[archiv]<>"*")
Line #202:
Line #203:else
Line #204:
Line #205://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #206:
Line #207:
Line #208:
Line #209:
Line #210:
Line #211:
Line #212:if ($musor[archiv]<>"*")
Line #213:
Line #214:else
Line #215:$rejtett="<br>REJTETT";
Line #216://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #217:
Line #218:IF ($_SESSION[login]=="BI(c)")
Line #219:$ref4="<a target=adatframe href=QJ_helyszinOSZ.php?&hely_kod=$helyszin_kod&datum_kod=$datum_kod target=adatframe>
Line #220:$musor[helyszin]</a>"; else $ref4=$musor[helyszin];
Line #221:
Line #222:
Line #223:
Line #224:if ($musor[aroszto]>0) $refD="<br><font color=red>".(100/$musor[aroszto])." %</font>"; else $refD="";
Line #225:if ($_SESSION['login']=="BI(c)")
Line #226:$refD.="<a target=adatframe href=BI_sqlRECopy.php?&wjid=2&tabla=qj_ear&musor_kod=$datum_kod>
Line #227:
Line #228:
Line #229:
Line #230:if ($_SESSION['login']=="BI(c)")
Line #231:$refD="<a target=adatframe
Line #232:
Line #233:
Line #234:<a target=adatframe
Line #235:href=QJ_earCOPY.php?&wnew=$datum_kod,&torol=Y>
Line #236:
Line #237:";
Line #238:
Line #239:$cimkieg="";
Line #240:if ($musor[cimkieg1]<>"") $cimkieg.="<br>".$musor[cimkieg1];
Line #241:if ($musor[cimkieg2]<>"") $cimkieg.="<br>".$musor[cimkieg2];
Line #242:if ($musor[cimkieg3]<>"") $cimkieg.="<br>".$musor[cimkieg3];
Line #243:
Line #244:if ($musor[web]<>"") $szin="red"; else $szin="";
Line #245:
Line #246:echo"<tr>$ie
Line #247:<td align=right >$e <br><font color=blue>$datum </font> $xls $refD
Line #248:<input type='hidden' value='$datum_kod' name='Lid'>
Line #249:</td>
Line #250:<td align=right >$musor[cim]$cimkieg<br>$musor[datum]</td>
Line #251:<td align=right >$ref4$erkezesi</td>
Line #252:<td align=right >$musor[datum_kod]$rejtett</td>
Line #253:<td align=right >$musor[Adoszam]<br>$musor[Szjszam]
Line #254:<br>$musor[AFA_jel]</td>
Line #255:<td align=right bgcolor=$szin ><font color=white size=+3>$musor[web]</font></td>
Line #256:</tr>";
Line #257:
Line #258:echo ($sel3);
Line #259:
Line #260:echo"<tr bgcolor=yellow>
Line #261:<td align=right >&nbsp;</td>
Line #262:<td align=right >&nbsp;</td>
Line #263:<td align=right >1.Kat:<b>$musor[alapar1]</b></td>
Line #264:<td align=right >2.Kat:<b>$musor[alapar2]</b></td>
Line #265:<td align=right >3.Kat:<b>$musor[alapar3]</b></td>
Line #266:<td align=right >4.Kat:<b>$musor[alapar4]</b></td>
Line #267:</tr></form>";
Line #268:}
Line #269:
Line #270:echo "</table></form>";
Line #271:
Line #272:?>