QJ_gyujtoDIRECT.inc

---

Line #0:<?php
Line #1:$_SESSION[vissza]="QJ_gyujtoDIRECT.php";
Line #2:
Line #3://$_SESSION[qontroll]="*";
Line #4:
Line #5:if (!isset($_SESSION[SQL_inet])) {
Line #6:
Line #7:++$_SESSION[QJ_hiba];
Line #8:
Line #9:echo "<script>
Line #10:
Line #11:window.open('QJ_gyujto.php','sframe');
Line #12:</script>";
Line #13:}
Line #14:
Line #15:$_SESSION[QJ_hiba]=0;
Line #16:
Line #17://BISQLcon();
Line #18:
Line #19:$login=$_SESSION[login];
Line #20:$admin=$_SESSION[admin];
Line #21:$_SESSION[CimUp]="QJ_kijelol.php";
Line #22:
Line #23:
Line #24:if ($_POST[Sbizonylat]<>"") {
Line #25:
Line #26:echo "<script>
Line #27:window.open('QJ_analitika.php?&bizonylat=".$_POST[Sbizonylat]."','sframe');
Line #28:</script>";
Line #29:}
Line #30:
Line #31:
Line #32:
Line #33:include("../_inc_QJ/QJ_gyujtoSELECT.inc");
Line #34:
Line #35:$login=$_SESSION[bizomanyos];
Line #36:
Line #37:if(!isset($_GET[lista])) {
Line #38:
Line #39:
Line #40:
Line #41:
Line #42:if(isset($_GET[clear])) {unset($_SESSION[GyujtOSft]); unset($_SESSION[GyujtOSdb]);}
Line #43:
Line #44:if(isset($_SESSION[GyujtOSft]))
Line #45:echo ("<font color=red size=3>
Line #46:
Line #47:
Line #48:
Line #49:echo "<table border=1>
Line #50:<tr bgcolor=silver>
Line #51:<td align=right ><b></b></td>
Line #52:<td align=right ><b>Db</b></td>
Line #53:<td align=right ><b>Ft</b></td>
Line #54:
Line #55:
Line #56:
Line #57:
Line #58:
Line #59:
Line #60://if ($login=="BI(c)")
Line #61:if ($admin=="ADMIN")
Line #62:
Line #63:
Line #64:
Line #65:
Line #66:$szin="red";
Line #67:
Line #68:if ( isset($_SESSION[qontroll])) {
Line #69:
Line #70:$parancs="SELECT * FROM qj_jegy where $_SESSION[SQL_elad] and not $_SESSION[SQL_inet] and bizonylatszam=0 ";
Line #71:
Line #72:
Line #73:$nur=mysql_num_rows($eredmeny);
Line #74:
Line #75:
Line #76:if ($nur>0) {
Line #77:echo"<tr>
Line #78:<td align=right >
Line #79:<A STYLE='{vlink : gold}'
Line #80:href='QJ_analitika.php?&bizonylat=0'>
Line #81:
Line #82:</td>
Line #83:
Line #84:</tr>
Line #85:";
Line #86:
Line #87:}
Line #88:}
Line #89:
Line #90:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' ORDER BY logtime DESC limit 1 ";
Line #91:
Line #92:
Line #93:
Line #94://?//echo($parancs."<hr>");
Line #95:
Line #96:$egy_sor = mysql_fetch_array( $eredmeny );
Line #97:$nap=substr($egy_sor[logtime],0,10);
Line #98:
Line #99://if($login=='BI(c)')
Line #100:
Line #101:if (!isset($_GET[gyforg])) {
Line #102:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' and left(logtime,10)='$nap' ORDER BY logtime DESC";
Line #103:} else {
Line #104:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' ORDER BY logtime DESC";
Line #105:if ($login=="BI(c)")
Line #106:$parancs="SELECT * FROM qj_jlog ORDER BY logtime DESC";
Line #107:}
Line #108:
Line #109:$parancs="SELECT * FROM qj_jlog where bizomanyos='$login' $_SESSION[SUBwer] ORDER BY logtime DESC";
Line #110://?//echo($parancs."<hr>");
Line #111:
Line #112:
Line #113:
Line #114:$i=0;
Line #115:while ( $egy_sor = mysql_fetch_array( $eredmeny ))
Line #116:{
Line #117:
Line #118:
Line #119:$wjid=$egy_sor[wid];
Line #120:$nur=0;
Line #121:if ( isset($_SESSION[qontroll])) {
Line #122:
Line #123:$sel = "SELECT * FROM qj_cimlet where widarc='".$wjid."'";
Line #124:$sql=mysql_query($sel) or die($sel." Hiba a select-ben");
Line #125:$csor = mysql_fetch_array( $sql );
Line #126:$nur=mysql_num_rows($sql);
Line #127:}
Line #128:
Line #129:if ($nur>0){
Line #130:$jelol="selected.gif";
Line #131:
Line #132:
Line #133:
Line #134:if ($csor[ELONY_FT]<>"") $konyvinfo="Elnyomtat:";
Line #135:
Line #136:$konyvel="<td ><font color=red>".$konyvinfo."<br>$csor[szoveg]</font></td>";
Line #137:} else {
Line #138:$jelol="stop.gif";
Line #139:$delma=substr($egy_sor[logtime],0,10);
Line #140:$konyvel="<td ><a target=adatframe href='QJ_napiDIRECT.php?&D_nap=$delma&D_biz=$egy_sor[bizomanyos]'>
Line #141:$egy_sor[logtime]</a></td>";
Line #142:}
Line #143:
Line #144:if ($egy_sor[vevokod]<>0)
Line #145:$Rfiz=" <a href=QJ_reszletFIZET.php?&wjid=$egy_sor[wid]>
Line #146:
Line #147:$Rfiz="";
Line #148:
Line #149:
Line #150:if ($egy_sor[Reszlet1]+$egy_sor[Reszlet1]<>0)
Line #151:
Line #152:
Line #153:else
Line #154:$RfizOK="";
Line #155:
Line #156:$Nodb="";
Line #157:if (isset($_SESSION[Nontroll])) {
Line #158:$Narancs="SELECT wid FROM qj_jegy where $_SESSION[SQL_elad] and bizonylatszam='$egy_sor[wid]' ";
Line #159:
Line #160:$Nnur=mysql_num_rows($Neredmeny);
Line #161:if ($egy_sor[osszdb]<>$Nnur) $Nodb="<font size=+2 color=RED>$Nnur<hr>";
Line #162:}
Line #163:
Line #164:
Line #165:
Line #166:
Line #167:
Line #168:echo"<tr>
Line #169:<td align=right >
Line #170:<A STYLE='{vlink : gold}'
Line #171:href='QJ_analitika.php?&bizonylat=".$egy_sor[wid]."'>
Line #172:
Line #173:</td>
Line #174:
Line #175:<td align=right ><b><font color=$szin>".$Nodb.number_format( $egy_sor[osszdb])."</font></b></td>
Line #176:<td align=right ><b><font color=$szin>".number_format( $egy_sor[osszft])."</font></b></td>
Line #177:<td align=right><font color=blue><b>$egy_sor[wid]</b></font></td>
Line #178:<td >$egy_sor[status]</td>
Line #179:<td >$egy_sor[arforma]</td>
Line #180:$konyvel
Line #181:<td ><a href=QJ_cimletez.php?&wjid=$egy_sor[wid]>
Line #182:
Line #183: $Rfiz
Line #184:";
Line #185:
Line #186:if ($admin=="ADMIN")
Line #187:echo "<td align=right ><b>$egy_sor[bizomanyos]</b></td>";
Line #188:
Line #189:
Line #190:$vevokod=$egy_sor[vevokod];
Line #191:
Line #192:
Line #193:if ($vevokod>0 and isset($_SESSION[qontroll])) {
Line #194:$vevoker = "SELECT * FROM qj_cimtar WHERE wid=".$vevokod;
Line #195:
Line #196:$ct_sor = mysql_fetch_array($ctar);
Line #197:
Line #198:if ($ct_sor[telepules].$ct_sor[cim]=="") $info1=""; else
Line #199:$info1="<br><b>$ct_sor[telepules]</b>&nbsp;$ct_sor[cim]";
Line #200:
Line #201:if ($ct_sor[telszam].$ct_sor[uzenet]=="") $info2=""; else
Line #202:$info2="<br><b>$ct_sor[telszam]</b>&nbsp;$ct_sor[uzenet]";
Line #203:
Line #204:echo "<td align=right ><font color=red>
Line #205:<A target=sframe href='QJ_cimUp.php?&wjid=".$vevokod."&CimUp=QJ_gyujto.php&sqlfile=qj_cimtar'>
Line #206:$vevokod</a></font>&nbsp;<b>$ct_sor[nev]</b>$info1 $info2</td>";
Line #207:
Line #208:}
Line #209:
Line #210:
Line #211://if ($login=="BI(c)")
Line #212:
Line #213:echo" $RfizOK </tr>";
Line #214:
Line #215:$szin="";
Line #216:
Line #217:/*
Line #218:if ($i==100 ) {
Line #219:echo('</table><table>');
Line #220:$i=0;
Line #221:}
Line #222:++$i;
Line #223:*/
Line #224:
Line #225:}
Line #226:
Line #227:echo "
Line #228:</table>";
Line #229:
Line #230:///////////
Line #231:} else {
Line #232:///////////
Line #233:
Line #234:
Line #235:if ($_SESSION[admin]<>"ADMIN") $_POST[bizomanyos]=$_SESSION[login];
Line #236:
Line #237:$_SESSION[L_bizomanyos]=$_POST[bizomanyos];
Line #238:$_SESSION[L_nap]=$_POST[nap];
Line #239:$_SESSION[L_status]=$_POST[status];
Line #240:
Line #241://$_SESSION[L_adoszam]=htmlspecialchars($_POST[adoszam]);
Line #242:$_SESSION[L_adoszam]=$_POST[adoszam];
Line #243:
Line #244:
Line #245:if ($_POST[bizomanyos]==$_SESSION[login] )
Line #246:$wer=" where bizomanyos='".$_POST[bizomanyos]."'";
Line #247:else
Line #248:$wer="";
Line #249:
Line #250:
Line #251:echo"<FORM name=orderby target=sframe
Line #252:action='QJ_gyujto.php?&lista=2' method='post'>";
Line #253:
Line #254:
Line #255:$disQ = "SELECT distinct bizomanyos FROM qj_jlog $wer order by bizomanyos" ;
Line #256:
Line #257:
Line #258://echo($disQ."<hr>");
Line #259:
Line #260:
Line #261:onchange=this.form.submit(); return true name='bizomanyos'>";
Line #262:
Line #263:
Line #264:
Line #265:
Line #266:if ($_SESSION['admin']=='ADMIN') {
Line #267:if ($_POST[bizomanyos]=='0') $sel="SELECTED"; else $sel="";
Line #268:
Line #269:}
Line #270:
Line #271:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #272:if ($disC[bizomanyos]==$_POST[bizomanyos]) $sel="SELECTED"; else $sel="";
Line #273:$sel2.="<option value='".$disC[bizomanyos]."' $sel >".$disC[bizomanyos]."</option>";
Line #274:}
Line #275:
Line #276:$sel2.="</SELECT>";
Line #277:
Line #278:////////
Line #279:
Line #280:if (isset($_POST[bizomanyos]) and $_POST[bizomanyos]<>"*" )
Line #281:$wer=" where bizomanyos='".$_POST[bizomanyos]."'";
Line #282:else
Line #283:$wer="";
Line #284:if ($_POST[bizomanyos]=="0" ) $wer="";
Line #285:
Line #286:/*
Line #287://$disQ = "SELECT left(logtime,10) as nap, distinct nap FROM qj_jlog order by logtime DESC" ;
Line #288:
Line #289:$disQ = "SELECT logtime FROM qj_jlog $wer order by logtime DESC" ;
Line #290:
Line #291:
Line #292://echo($disQ."<hr>");
Line #293:
Line #294:
Line #295:onchange=this.form.submit(); return true name='nap'>";
Line #296:
Line #297:
Line #298:$nap="?";
Line #299:
Line #300:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #301:$Wnap=substr($disC[logtime],0,10);
Line #302:
Line #303:
Line #304:// if ($nap=="?") $_SESSION[L_nap]=$Wnap;
Line #305:// if ($nap=="?") unset($_SESSION[L_nap]);
Line #306:// if ($nap<>$Wnap and $Wnap>'2010-03-31' ) {
Line #307:
Line #308:if ($nap<>$Wnap ) {
Line #309:$nap=$Wnap;
Line #310:if ($nap==$_POST[nap]) $sel="SELECTED"; else $sel="";
Line #311:$sel1.="<option value='".$nap."' $sel >". $nap."</option>";
Line #312:}
Line #313:}
Line #314:
Line #315:$sel1.="</SELECT>";
Line #316:*/
Line #317:
Line #318:
Line #319:$disQ = "SELECT distinct left(logtime,10) as datum FROM qj_jegy " .$wer. " order by left(logtime,10) DESC" ;
Line #320:
Line #321://echo($disQ."<hr>");
Line #322:
Line #323:
Line #324:
Line #325:
Line #326:
Line #327:onchange=this.form.submit(); return true name='nap'>";
Line #328:
Line #329:
Line #330:$nap="?";
Line #331:
Line #332:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #333://$Wnap=substr($disC[logtime],0,10);
Line #334:$Wnap=$disC[datum];
Line #335:
Line #336:
Line #337:// if ($nap=="?") $_SESSION[L_nap]=$Wnap;
Line #338:// if ($nap=="?") unset($_SESSION[L_nap]);
Line #339:// if ($nap<>$Wnap and $Wnap>'2010-03-31' ) {
Line #340:
Line #341:if ($nap<>$Wnap ) {
Line #342:$nap=$Wnap;
Line #343:if ($nap==$_POST[nap]) $sel="SELECTED"; else $sel="";
Line #344:$sel1.="<option value='".$nap."' $sel >". $nap."</option>";
Line #345:}
Line #346:}
Line #347:
Line #348:$sel1.="</SELECT>";
Line #349:
Line #350://///////
Line #351:
Line #352:if (isset($_POST[nap]) and $_POST[nap]<>"*") {
Line #353:if ($wer<>"") $wer.=" and "; ELSE $wer=" where";
Line #354:$wer.=" left(logtime,10)='".$_POST[nap]."'";
Line #355:}
Line #356:else $wer="";
Line #357:
Line #358:$disQ = "SELECT distinct status FROM qj_jlog $wer order by status" ;
Line #359:
Line #360://echo($disQ."<hr>");
Line #361:
Line #362:
Line #363:onchange=this.form.submit(); return true name='status'>";
Line #364:
Line #365:
Line #366:
Line #367:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #368:if ($disC[status]==$_POST[status]) $sel="SELECTED"; else $sel="";
Line #369:
Line #370:$sel3.="<option value='".$disC[status]."' $sel>".$disC[status]."</option>";
Line #371:}
Line #372:
Line #373:$sel3.="</SELECT>";
Line #374:
Line #375:////////
Line #376:
Line #377:
Line #378:if ($_POST[bizomanyos]=="*" or !isset($_POST[bizomanyos]) ) { $sel1=""; $sel3=""; }
Line #379:if ($_POST[nap]=="*" or !isset($_POST[nap])) $sel3="";
Line #380:
Line #381:
Line #382:/*if ($_SESSION[SpeciUse]=="4x")
Line #383:
Line #384:<input type='submit' value='>>>' name='submit'>";
Line #385:else $sel4="";*/
Line #386:
Line #387:
Line #388://if ($_SESSION[SpeciUse]=="4x")
Line #389:$sel4="<input type='text' value='".$_POST[Sbizonylat]."' name='Sbizonylat'
Line #390:
Line #391://else $sel4="";
Line #392:
Line #393:
Line #394:$disQ = "SELECT Distinct Adoszam,cimkieg3 FROM qj_musor where cimkieg3<>'' order by cimkieg3" ;
Line #395:
Line #396:
Line #397://echo($disQ."<hr>");
Line #398:
Line #399:
Line #400:onchange=this.form.submit(); return true name='adoszam'>";
Line #401:
Line #402:
Line #403:
Line #404:
Line #405:while ( $disC = mysql_fetch_array( $disR ) ) {
Line #406:if ($disC[Adoszam]==$_POST[adoszam]) $sel="SELECTED"; else $sel="";
Line #407:$sel5.="<option value='".$disC[Adoszam]."' $sel >".$disC[cimkieg3]."</option>";
Line #408:}
Line #409:
Line #410:$sel5.="</SELECT>";
Line #411:
Line #412:////////
Line #413:
Line #414:
Line #415:
Line #416:
Line #417:
Line #418:
Line #419:
Line #420:
Line #421:echo"</FORM>";
Line #422:
Line #423:
Line #424:}
Line #425:
Line #426:include("QJ_stop.php");
Line #427:
Line #428://~*~// QJ_gyujto.php
Line #429:
Line #430:?>
Line #431: