OF_musorKORR.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($_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:
Line #173:if ($_SESSION[login]=="BI(c)")
Line #174:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #175:"<td align=right >
Line #176:<a target=adatframe href=BI_sqlRECopy.php?&wjid=$disC[wid]&tabla=qj_ear>
Line #177:jav</a></td><td align=right >&nbsp;<b>".$disC[szoveg]."</b></td>";
Line #178:else
Line #179:$sel3.="<tr bgcolor=PaleGoldenRod>".
Line #180:"<td align=right ></td><td align=right >&nbsp;<b>".$disC[szoveg]."</b></td>";
Line #181:
Line #182:if ($disC[qj_ear1]>0) $sel3.=" <td align=right >1.Kat:<b>".$disC[qj_ear1]."</b></td>";
Line #183:if ($disC[qj_ear2]>0) $sel3.=" <td align=right >2.Kat:<b>".$disC[qj_ear2]."</b></td>";
Line #184:if ($disC[qj_ear3]>0) $sel3.=" <td align=right >3.Kat:<b>".$disC[qj_ear3]."</b></td>";
Line #185:if ($disC[qj_ear4]>0) $sel3.=" <td align=right >4.Kat:<b>".$disC[qj_ear4]."</b></td>";
Line #186:$sel3.="</tr>";
Line #187:}
Line #188:
Line #189:
Line #190:if ($_SESSION[login]=="BI(c)") {
Line #191: $ie = '<td><a target=adatframe href="QJ_musorEDIT.php?&wjid='.$wjid.'"><img src=edit.png border=0></a></td>';
Line #192: $datum=$musor[datum]."<br><font color=red>".$musor[datum_fej]."</font>";
Line #193:} else {
Line #194: $ie='<td>'.$i.'</td>';
Line #195: $datum=$musor[datum];
Line #196:}
Line #197:
Line #198: $ie = '<td><a target=adatframe href="QJ_musorPUBLIC.php?&wjid='.$wjid.'">
Line #199: <img width=20 height=20 src="../_Screen/edit.png" border=0></a></td>';
Line #200:
Line #201: $datum=$musor[datum_fej];
Line #202:
Line #203:
Line #204:
Line #205:
Line #206:if ($musor[archiv]<>"*")
Line #207:
Line #208:else
Line #209:
Line #210://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #211:
Line #212:
Line #213:
Line #214:
Line #215:
Line #216:
Line #217:if ($musor[archiv]<>"*")
Line #218:
Line #219:else
Line #220:$rejtett="<br>REJTETT";
Line #221://<td align=right >".$ee.$wjid."]>".$e."</td>
Line #222:
Line #223:IF ($_SESSION[login]=="BI(c)")
Line #224:$ref4="<a target=adatframe href=QJ_helyszinOSZ.php?&hely_kod=$helyszin_kod&datum_kod=$datum_kod target=adatframe>
Line #225:$musor[helyszin]</a>"; else $ref4=$musor[helyszin];
Line #226:
Line #227:
Line #228:
Line #229:if ($musor[aroszto]>0) $refD="<br><font color=red>".(100/$musor[aroszto])." %</font>"; else $refD="";
Line #230:if ($_SESSION['login']=="BI(c)")
Line #231:$refD.="<a target=adatframe href=BI_sqlRECopy.php?&wjid=2&tabla=qj_ear&musor_kod=$datum_kod>
Line #232:
Line #233:
Line #234:
Line #235:if ($_SESSION['login']=="BI(c)")
Line #236:$refD="<a target=adatframe
Line #237:
Line #238:
Line #239:<a target=adatframe
Line #240:href=QJ_earCOPY.php?&wnew=$datum_kod,&torol=Y>
Line #241:
Line #242:";
Line #243:
Line #244:$cimkieg="";
Line #245:if ($musor[cimkieg1]<>"") $cimkieg.="<br>".$musor[cimkieg1];
Line #246:if ($musor[cimkieg2]<>"") $cimkieg.="<br>".$musor[cimkieg2];
Line #247:if ($musor[cimkieg3]<>"") $cimkieg.="<br>".$musor[cimkieg3];
Line #248:
Line #249:if ($musor[web]<>"") $szin="red"; else $szin="";
Line #250:if ($musor[szervezo]<>"") $szervezo="<br><font color=red><b>$musor[szervezo]<b></font>"; else $szervezo="";
Line #251:
Line #252:echo"<tr>$ie
Line #253:<td align=right >$e
Line #254:$szervezo
Line #255:<br><font color=blue>$datum </font> $xls $refD
Line #256:<input type='hidden' value='$datum_kod' name='Lid'>
Line #257:</td>
Line #258:<td align=right >$musor[cim]$cimkieg<br>$musor[datum]</td>
Line #259:<td align=right >$ref4$erkezesi</td>
Line #260:<td align=right >$musor[datum_kod]$rejtett</td>
Line #261:<td align=right >$musor[Adoszam]<br>$musor[Szjszam]
Line #262:<br>$musor[AFA_jel]</td>
Line #263:<td align=right bgcolor=$szin ><font color=white size=+3>$musor[web]</font></td>
Line #264:</tr>";
Line #265:
Line #266:echo ($sel3);
Line #267:
Line #268:echo"<tr bgcolor=yellow>
Line #269:<td align=right >&nbsp;</td>
Line #270:<td align=right >&nbsp;</td>
Line #271:<td align=right >1.Kat:<b>$musor[alapar1]</b></td>
Line #272:<td align=right >2.Kat:<b>$musor[alapar2]</b></td>
Line #273:<td align=right >3.Kat:<b>$musor[alapar3]</b></td>
Line #274:<td align=right >4.Kat:<b>$musor[alapar4]</b></td>
Line #275:</tr></form>";
Line #276:}
Line #277:
Line #278:echo "</table></form>";
Line #279:
Line #280:?>