QL_musorKORRear_EF.inc

---

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