QQ_cimtar_FED_JA16.inc

---

Line #0:<?php
Line #1:
Line #2:$Viewpar="";
Line #3://include("QJ_varlist.php");
Line #4:
Line #5:if (!isset($_POST[Qfut])) {
Line #6:
Line #7: $_POST[Bis]=$_SESSION[Bis];
Line #8: $_POST[goon]=$_SESSION[goon];
Line #9: $_POST[Desc]=$_SESSION[Desc];
Line #10: }
Line #11:
Line #12:
Line #13:
Line #14://include("gvarlist.php");
Line #15:
Line #16:if (isset($_POST[Quick])) {
Line #17:$ipos=strpos($_POST[Quick],"##");
Line #18:}
Line #19:
Line #20:if (!isset($_POST[kiirdb])) $_POST[kiirdb]=20;
Line #21:
Line #22:
Line #23:if (isset($_POST[Bis])) {
Line #24:// $Viewpar.="&Bis=".$_POST[Bis];
Line #25: $_GET[Bis]=$_POST[Bis];
Line #26: $_SESSION[Bis]=$_POST[Bis];
Line #27: $Limit="";
Line #28:// $_POST[goon]="Y";
Line #29:} else unset($_SESSION[Bis]);
Line #30:
Line #31:
Line #32:if (isset($_POST[goon])) {
Line #33://$Viewpar.="&goon=Y";
Line #34://$Limit="";
Line #35:$_GET[goon]=$_POST[goon];
Line #36:$_SESSION[goon]=$_POST[goon];
Line #37:} else unset($_SESSION[goon]);
Line #38:
Line #39:
Line #40:if (isset($_POST[Desc])) {
Line #41://///////// SORREND //////////
Line #42:$Viewpar.="&Desc=Y";
Line #43:$_GET[Desc]=$_POST[Desc];
Line #44:$_SESSION[Desc]=$_POST[Desc];
Line #45:} else unset($_SESSION[Desc]);
Line #46:
Line #47:
Line #48:
Line #49:if (isset($_POST[qcsoport])) $_SESSION[qcsoport]=$_POST[qcsoport];
Line #50: else $_POST[qcsoport]=$_SESSION[qcsoport];
Line #51:
Line #52://///////////// ?????????? /////////
Line #53:
Line #54:
Line #55:
Line #56: $q="<SELECT onchange=this.form.submit();
Line #57: STYLE='{color : blue; background-color:silver; font-size: 14px; font-weight: bold;'
Line #58: return true name='qcsoport'>";
Line #59:
Line #60:
Line #61:/*while ( $par_sor = mysql_fetch_array( $parQ )) {
Line #62://echo ($par_sor[sql_memo]."/".$par_sor[sql_parancs]."<hr>");
Line #63:if ($_POST[qcsoport]==$par_sor[sql_memo]) $sel=" SELECTED "; else $sel="";
Line #64:
Line #65: $q=$q."<option value='".$par_sor[sql_memo]."' $sel>".$par_sor[sql_parancs]."</option>";
Line #66:}
Line #67:
Line #68:$q=$q."</select>";*/
Line #69:
Line #70:$disQ="SELECT distinct csoport_kod FROM qj_cimtar ORDER BY csoport_kod";
Line #71:
Line #72:
Line #73:while ( $disC = mysql_fetch_array( $disR )) {
Line #74:
Line #75: $selCSOPORT=str_replace("#","",$disC[csoport_kod]);
Line #76:
Line #77:
Line #78:if ($disC[csoport_kod]==$_POST[qcsoport]) $sel="SELECTED"; else $sel="";
Line #79:$q.="<option value='$disC[csoport_kod]' $sel >$selCSOPORT</option>";
Line #80:}
Line #81://$selD.="</SELECT>";
Line #82:$q=$q."</select>";
Line #83://///////////// ?????????? /////////
Line #84:
Line #85:
Line #86:if (isset($_POST[sorrend]) and $_POST[sorrend]<>"*") {
Line #87:$_SESSION[sorrend]=$_POST[sorrend];
Line #88:} else $_POST[sorrend]="nev"; // $_SESSION[sorrend];
Line #89:
Line #90:if ($_SESSION[sorrend]=='email_cim') $sel1=" SELECTED "; else $sel1="";
Line #91:if ($_SESSION[sorrend]=='nev') $sel2=" SELECTED "; else $sel2="";
Line #92:if ($_SESSION[sorrend]=='telepules') $sel3=" SELECTED "; else $sel3="";
Line #93:if ($_SESSION[sorrend]=='cim') $sel4=" SELECTED "; else $sel4="";
Line #94:if ($_SESSION[sorrend]=='csoport_kod') $sel5=" SELECTED "; else $sel5="";
Line #95:if ($_SESSION[sorrend]=='telszam') $sel6=" SELECTED "; else $sel6="";
Line #96:if ($_SESSION[sorrend]=='logtime') $sel7=" SELECTED "; else $sel7="";
Line #97:
Line #98: $v="<SELECT onchange=this.form.submit();
Line #99: STYLE='{color : blue; background-color:silver; font-size: 14px; font-weight: bold;'
Line #100: return true name='sorrend'>";
Line #101:
Line #102:
Line #103:
Line #104:
Line #105:
Line #106: $v=$v."<option value='csoport_kod' $sel5>Csoport</option>";
Line #107: $v=$v."<option value='email_cim' $sel1>Email cim</option>";
Line #108: $v=$v."<option value='telszam' $sel6>Telefon</option>";
Line #109:
Line #110: $v=$v."</select>";
Line #111:
Line #112:
Line #113:?>
Line #114:<table width=100% border=0><tr><td align=left>
Line #115:<FORM name=cimform target=sframe action='' method='post'>
Line #116:
Line #117:<INPUT TYPE='hidden' NAME='Qfut' value="*">
Line #118:
Line #119:<?php echo($v); echo($q);?>
Line #120:
Line #121:<input type='submit'
Line #122:STYLE='{color : blue; background-color:silver; font-size: 14px; font-weight: bold;'
Line #123:
Line #124:onchange=this.form.submit(); return true name='Bis'><br>
Line #125:
Line #126:<!--------------
Line #127:
Line #128:<?php if (isset($_POST[goon])) echo(' CHECKED '); ?> onchange=this.form.submit(); return true name='goon' >
Line #129:
Line #130:
Line #131:
Line #132:
Line #133:
Line #134:
Line #135:--------->
Line #136:
Line #137:<INPUT TYPE='text' NAME='Bis' size=40
Line #138: STYLE='{color : red; background-color:gold; font-size: 14px; font-weight: bold;'
Line #139:
Line #140:value='<? if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
Line #141:>
Line #142:
Line #143:
Line #144: TYPE='text' NAME='kiirdb' size=4
Line #145: STYLE='{color : red; background-color:gold; font-size: 14px; font-weight: bold;'
Line #146:value='<? if (isset($_POST[kiirdb])) echo($_POST[kiirdb]); ?>'
Line #147:>
Line #148:
Line #149:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #150:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #151:
Line #152:
Line #153:
Line #154:
Line #155:</form>
Line #156:
Line #157:</td><tr><td>
Line #158:
Line #159:<?php
Line #160:if (isset($_POST[qscan])) {
Line #161://include("QJ_cimscan.php");
Line #162:}
Line #163:?>
Line #164:</td><tr>
Line #165:<?php
Line #166:
Line #167:
Line #168:if (!isset($_GET[goon]))
Line #169:{
Line #170: UNSET($_GET[Bis]);
Line #171:}
Line #172:
Line #173:
Line #174:if (!isset($_GET[forgalom])) $_GET[forgalom]=3;
Line #175:
Line #176:
Line #177:if (isset($_GET[Desc])) $Viewpar.="&Desc=Y";
Line #178:if (isset($_GET[Bis])) $Viewpar.="&Bis=".$_GET[Bis];
Line #179:if (isset($_GET[forgalom])) $Viewpar.="&forgalom=".$_GET[forgalom];
Line #180:
Line #181:$ParHead="<table width=100%>";
Line #182:$export=false;
Line #183://$tabla=$_GET["tabla"];
Line #184:$biord="";
Line #185:$tabla="qj_cimtar";
Line #186:
Line #187:
Line #188:/*if (isset($_POST[Desc])) {
Line #189:
Line #190:}*/
Line #191:
Line #192:
Line #193:if (isset($_POST["biord"])) {
Line #194:$biord= " order by ".$_POST["biord"];
Line #195:if (isset($_POST[Desc])) {
Line #196:
Line #197:$biord.=" DESC";
Line #198:}
Line #199:} else $biord= " order by nev";
Line #200:
Line #201://///////////// si12 /////////////
Line #202:if (isset($_SESSION[sorrend])) {
Line #203:$biord= " order by ".$_SESSION[sorrend];
Line #204:if (isset($_POST[Desc])) {
Line #205:$biord.=" DESC";
Line #206:}
Line #207:}
Line #208:
Line #209:
Line #210:ECHO('<html>
Line #211:<title>'. $tabla.' </title>
Line #212:');
Line #213:
Line #214:$eredmeny = mysql_query('show fields from '.$tabla);
Line #215:
Line #216:$fid='';
Line #217:$qee='<table width=100% BORDER=1 ><tr>';
Line #218:$fullRec="CONCAT_WS(";
Line #219:$vesszo="";
Line #220:$qee .= '<td width=50>&nbsp;</td>';
Line #221:
Line #222:$i=0;
Line #223:while ($row =mysql_fetch_row($eredmeny))
Line #224:{
Line #225:$fid.=$row[0] . ":";
Line #226:if ($i>2 and $i<8)
Line #227://$qee .= '<td width=100><b><a href="QJ_cimtar.php?&tabla='.$tabla.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
Line #228:$qee .= '<td width=100><b>'.$row[0].'</b></td>';
Line #229:++$i;
Line #230://$fullRec.=$vesszo."Upper(".$row[0].")";
Line #231:$fullRec.=$vesszo."(".$row[0].")";
Line #232:$vesszo=",'/', ";
Line #233:
Line #234:}
Line #235:
Line #236:
Line #237:
Line #238:
Line #239:$full=$fullRec.")";
Line #240:
Line #241:$fullRec.=") as full";
Line #242:$fid.="full:";
Line #243:
Line #244://echo($fullRec."<hr>");
Line #245:
Line #246:if (isset($_GET[Bis]) and $_GET[Bis]<>"") $wer=" Where usr_kod<>'*DEL' and nev<>'' and INSTR((".$full."),'".$_GET[Bis]."') "; else $wer=" Where usr_kod<>'*DEL' and nev<>'' ";
Line #247://INSTR(UPPER(".$full."),'".strtoupper($_GET[Bis])."') "; else $wer="";
Line #248:
Line #249:
Line #250:if (!isset($_POST[goon]) and isset($_POST[Bis])) {
Line #251:$bislen=strlen($_POST[Bis]);
Line #252://if ($bislen>1) $Limit="";
Line #253:$wer=" Where usr_kod<>'*DEL' and nev<>'' and left(nev,".$bislen.")='".$_POST[Bis]."'";
Line #254:$wer=" where usr_kod<>'*DEL' and nev<>'' and instr(left(nev,".$bislen."),'".$_POST[Bis]."') ";
Line #255:$wer=" where usr_kod<>'*DEL' and nev<>'' and instr(nev,'".$_POST[Bis]."') ";
Line #256:
Line #257:$widker=str_replace("~","",$_POST[Bis]);
Line #258:
Line #259:
Line #260:$wer=" where wid='".$widker."' ";
Line #261:else
Line #262:$wer=" where usr_kod<>'*DEL' and nev<>'' and instr(".$_POST[sorrend].",'".$_POST[Bis]."') ";
Line #263:
Line #264:if (trim($_POST[Bis])=="") $wer="";
Line #265:}
Line #266:
Line #267:
Line #268:$qee .= '</tr>';
Line #269://$keres = "SELECT * ,".$fullRec ." FROM " . $tabla . $wer . $biord;
Line #270:
Line #271:
Line #272:if (substr($_GET[Bis],0,2)=="//" and strlen($_GET[Bis])>4) {
Line #273:
Line #274: $sqlwer=substr($_GET[Bis],2,strlen($_GET[Bis])-2);
Line #275:// echo "<script language = javascript>";
Line #276:// echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
Line #277:// echo "</script>";
Line #278:
Line #279:$keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
Line #280:
Line #281://print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
Line #282:
Line #283:
Line #284:$nurL=mysql_num_rows($eredmeny);
Line #285:$nur=$nurL;
Line #286://$Limit="";
Line #287:$biord="";
Line #288:
Line #289:////////
Line #290:} else {
Line #291:////////
Line #292:
Line #293:
Line #294:$keres = "SELECT wid FROM " . $tabla ;
Line #295:
Line #296:$nurX=mysql_num_rows($eredmeny);
Line #297:
Line #298:$keres = "SELECT wid FROM " . $tabla . $wer . $biord;
Line #299:
Line #300:
Line #301:$nurL=mysql_num_rows($eredmeny);
Line #302:
Line #303:$limit=" Limit $_POST[kiirdb]";
Line #304:
Line #305:if (isset($_SESSION[qcsoport]) and $_SESSION[qcsoport]<>"*") {
Line #306:if ($wer<>"")
Line #307:$wer.= " and csoport_kod='".$_SESSION[qcsoport]."'";
Line #308:else $wer= " where csoport_kod='".$_SESSION[qcsoport]."'";
Line #309:}
Line #310:
Line #311:$keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
Line #312:
Line #313:
Line #314:$nur=mysql_num_rows($eredmeny);
Line #315:
Line #316:if (substr($_POST[Bis],0,1)=="*" )
Line #317:{
Line #318:$wid=substr($_POST[Bis],1,strlen($_POST[Bis])-1);
Line #319:$keres = "SELECT * FROM " . $tabla . " where wid=$wid";
Line #320:
Line #321:
Line #322:
Line #323:$nur=mysql_num_rows($eredmeny);
Line #324:
Line #325:}
Line #326:
Line #327:}
Line #328:
Line #329://-?-//echo($keres."<hr>");
Line #330:
Line #331://if ($nurL<1001) $Limit="";
Line #332:
Line #333:$Limit=" LIMIT $_POST[kiirdb]";
Line #334:
Line #335:
Line #336:
Line #337:$head=$ParHead;
Line #338:
Line #339:if ($nur==0) {
Line #340:
Line #341:
Line #342:unset($_SESSION[qcsoport]);
Line #343:unset($_POST[qcsoport]);
Line #344:
Line #345:$wer=" where usr_kod<>'*DEL' and nev<>'' and instr(".$_POST[sorrend].",'".$_POST[Bis]."') ";
Line #346:
Line #347:$keres = "SELECT * FROM " . $tabla . $wer . $Limit;
Line #348:
Line #349:
Line #350:$nur=mysql_num_rows($eredmeny);
Line #351:
Line #352:
Line #353:if ($nur==0) {
Line #354:
Line #355:$ee =$head.$ee. '</table>';
Line #356:echo($ee);
Line #357:
Line #358:
Line #359:
Line #360:
Line #361:
Line #362:if ($_SESSION[login]=="BI(c)") echo("<hr>".$keres);
Line #363:
Line #364:exit;
Line #365:}}
Line #366:
Line #367:if ($nur>$_POST[kiirdb] ) {
Line #368:
Line #369:$keres = "SELECT * FROM " . $tabla . $wer . $biord . " Limit $_POST[kiirdb] ";
Line #370:
Line #371:
Line #372:
Line #373:/*
Line #374:if ($_POST[forgalom]==3 or !isset($_POST[forgalom]))
Line #375: MI A FORGALOM????
Line #376:print "
Line #377:
Line #378:<img width=25 height=25 src='../_Screen/plus.ico' border=0></a>&nbsp;&nbsp;
Line #379:
Line #380:";
Line #381:
Line #382://$ee =$head.$ee. '</table>';
Line #383://echo($ee);
Line #384:
Line #385:*/
Line #386:
Line #387:}
Line #388:
Line #389:
Line #390://echo($nur."/".$keres."<hr>");
Line #391:
Line #392:$ossztalalat=$nur;
Line #393:
Line #394:print "
Line #395:
Line #396:<img width=25 height=25 src='../_Screen/plus.ico' border=0></a>&nbsp;&nbsp;
Line #397:
Line #398:
Line #399:
Line #400:&nbsp;&nbsp; &nbsp;&nbsp;
Line #401:
Line #402:
Line #403:
Line #404:";
Line #405:
Line #406:
Line #407:
Line #408:$nur=mysql_num_rows($eredmeny);
Line #409:
Line #410:
Line #411://echo($nur."<hr>head".$head."<hr>qee".$qee);
Line #412:
Line #413:if ($nur==0) { $head=""; $qee="";}
Line #414:
Line #415:$ii=0;
Line #416:
Line #417:$h=split(':',$fid);
Line #418:
Line #419:$e= $head.$qee;
Line #420:
Line #421:echo($e);
Line #422:
Line #423:
Line #424:$bgszin="white";
Line #425:
Line #426:for($i=0;$i<$nur;$i++) {
Line #427:
Line #428:$e="";
Line #429:
Line #430:$r=mysql_fetch_row($eredmeny);
Line #431:
Line #432:$vevo=$r[0];
Line #433:
Line #434:$keresE = "SELECT statusz from qj_jegy where vevo_kod=$vevo and ".$_SESSION[SQL_elojegy];
Line #435:
Line #436:$nurE=mysql_num_rows($eredmenyE);
Line #437:
Line #438:$keresF = "SELECT statusz from qj_jegy where vevo_kod=$vevo and ".$_SESSION[SQL_elad];
Line #439:
Line #440:$nurF=mysql_num_rows($eredmenyF);
Line #441:
Line #442:$ii++;
Line #443:$e .= '<tr width=700 >';
Line #444:$e.='<td width=80 ALIGN=center>';
Line #445:
Line #446:$e.="<b>".$r[0].'</b><hr><a target=sframe href=QJ_cimUP.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #447:
Line #448:
Line #449:$e.='&nbsp;<a target=infoframe href=QJ_potjelol.php?&berlet_kod=JA16D0001&vevo_kod='.$r[0].'>
Line #450:
Line #451:
Line #452://? 2015.08.03. 2:23:39 $e.='&nbsp;<a target=sframe href=QQ_cimUP.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #453:
Line #454:
Line #455://$e.='&nbsp;<a target=sframe href=QJ_cimtarUP.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #456:
Line #457:
Line #458:if ($nurF>0)
Line #459:$e.='<br>
Line #460:<A target=sframe STYLE="{vlink : gold}"
Line #461:href="QJ_eladasok.php?&vevo='.$r[0].'">
Line #462:
Line #463:'.$nurF.' db
Line #464:';
Line #465:
Line #466://<A target=adatframe STYLE="{vlink : gold}"
Line #467://href="QJ_cimDIRECT.php?&cimjav=Y&vevo='.$r[0].'">
Line #468:
Line #469:
Line #470://if ($_SESSION[login]=="BI(c)")
Line #471:$relbi1='<A target=adatframe STYLE="{vlink : gold}"
Line #472:href="QJ_vevoLISTegy.php?&vevo='.$r[0].'">
Line #473:
Line #474:
Line #475:$relbi2='<br>
Line #476:<A target=adatframe STYLE="{vlink : gold}"
Line #477:href="QJ_vevo.php?&vevo='.$r[0].'">
Line #478:
Line #479:
Line #480:
Line #481:if ($nurE>0)
Line #482:$e.=$relbi2.$relbi1.'<br>
Line #483:<A target=sframe STYLE="{vlink : gold}"
Line #484:href="QJ_elojegyzesek.php?&vevo='.$r[0].'">
Line #485:
Line #486:
Line #487:
Line #488:$e.='</td>';
Line #489:
Line #490:
Line #491:if ($bgszin=="white") $bgszin="silver"; else $bgszin="white";
Line #492:
Line #493:// email cim kihagyva !!!
Line #494:$adat3=str_replace(" ","&nbsp;",$r[3]);
Line #495:$adat9=str_replace(" ","&nbsp;",$r[9]);
Line #496:
Line #497:$e .= '<td width=100 bgcolor='.$bgszin.'>'.$adat3.'<br><font color=red>'.$adat9.'</font></td>';
Line #498:
Line #499:for($j=4,$k=0;$j<count($r)-3;$j++) {
Line #500:
Line #501:$adat=str_replace(" ","&nbsp;",$r[$j]);
Line #502:
Line #503://$e .= '<td width=50 bgcolor='.$bgszin.'>&nbsp;'.htmlspecialchars($r[$j]).'&nbsp;</td>';
Line #504:$e .= '<td width=100 bgcolor='.$bgszin.'>&nbsp;'.$adat.'&nbsp;</td>';
Line #505:
Line #506:}
Line #507:
Line #508:$e .= '<td width=100 bgcolor='.$bgszin.'><font color=red>'.$r[2].'</font></td>';
Line #509:
Line #510:$e .= '</tr>';
Line #511:
Line #512:
Line #513:echo($e);
Line #514:
Line #515:}
Line #516:
Line #517:$e = '</table>';
Line #518:echo($e);
Line #519:
Line #520:if ($ossztalalat==$ii) {
Line #521:
Line #522:} else {
Line #523:print "<br>
Line #524:
Line #525:
Line #526:}
Line #527:
Line #528:
Line #529:
Line #530:?>
Line #531:</tr></table>
Line #532: