QQ_cimtar_FED.inc

---

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