QJ_cimtar.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[Bis])) {
Line #21:// $Viewpar.="&Bis=".$_POST[Bis];
Line #22: $_GET[Bis]=$_POST[Bis];
Line #23: $_SESSION[Bis]=$_POST[Bis];
Line #24: $Limit="";
Line #25:// $_POST[goon]="Y";
Line #26:} else unset($_SESSION[Bis]);
Line #27:
Line #28:
Line #29:if (isset($_POST[goon])) {
Line #30://$Viewpar.="&goon=Y";
Line #31://$Limit="";
Line #32:$_GET[goon]=$_POST[goon];
Line #33:$_SESSION[goon]=$_POST[goon];
Line #34:} else unset($_SESSION[goon]);
Line #35:
Line #36:
Line #37:if (isset($_POST[Desc])) {
Line #38://///////// SORREND //////////
Line #39:$Viewpar.="&Desc=Y";
Line #40:$_GET[Desc]=$_POST[Desc];
Line #41:$_SESSION[Desc]=$_POST[Desc];
Line #42:} else unset($_SESSION[Desc]);
Line #43:
Line #44:
Line #45:
Line #46:if (isset($_POST[qcsoport])) $_SESSION[qcsoport]=$_POST[qcsoport];
Line #47: else $_POST[qcsoport]=$_SESSION[qcsoport];
Line #48:
Line #49:
Line #50:
Line #51:
Line #52: $q="<SELECT onchange=this.form.submit();
Line #53: return true name='qcsoport'>";
Line #54:
Line #55:
Line #56:while ( $par_sor = mysql_fetch_array( $parQ )) {
Line #57://echo ($par_sor[sql_memo]."/".$par_sor[sql_parancs]."<hr>");
Line #58:if ($_POST[qcsoport]==$par_sor[sql_memo]) $sel=" SELECTED "; else $sel="";
Line #59:
Line #60: $q=$q."<option value='".$par_sor[sql_memo]."' $sel>".$par_sor[sql_parancs]."</option>";
Line #61:}
Line #62:
Line #63:$q=$q."</select>";
Line #64:
Line #65:if (isset($_POST[sorrend]) and $_POST[sorrend]<>"*") {
Line #66:$_SESSION[sorrend]=$_POST[sorrend];
Line #67:} else $_POST[sorrend]=$_SESSION[sorrend];
Line #68:
Line #69:if ($_SESSION[sorrend]=='email_cim') $sel1=" SELECTED "; else $sel1="";
Line #70:if ($_SESSION[sorrend]=='nev') $sel2=" SELECTED "; else $sel2="";
Line #71:if ($_SESSION[sorrend]=='telepules') $sel3=" SELECTED "; else $sel3="";
Line #72:if ($_SESSION[sorrend]=='cim') $sel4=" SELECTED "; else $sel4="";
Line #73:if ($_SESSION[sorrend]=='csoport_kod') $sel5=" SELECTED "; else $sel5="";
Line #74:if ($_SESSION[sorrend]=='telszam') $sel6=" SELECTED "; else $sel6="";
Line #75:if ($_SESSION[sorrend]=='logtime') $sel7=" SELECTED "; else $sel7="";
Line #76:
Line #77: $v="<SELECT onchange=this.form.submit();
Line #78: return true name='sorrend'>";
Line #79:
Line #80:
Line #81: $v=$v."<option value='email_cim' $sel1>Email cim</option>";
Line #82:
Line #83:
Line #84:
Line #85: $v=$v."<option value='csoport_kod' $sel5>Csoport</option>";
Line #86: $v=$v."<option value='telszam' $sel6>Telefon</option>";
Line #87:
Line #88: $v=$v."</select>";
Line #89:
Line #90:
Line #91:?>
Line #92:<table width=100% border=0><tr><td align=left>
Line #93:<FORM name=cimform target=sframe action='QJ_cimtar.php?&NewScan=Y' method='post'>
Line #94:
Line #95:<INPUT TYPE='hidden' NAME='Qfut' value="*">
Line #96:
Line #97:
Line #98:
Line #99:<img width=15 height=15 src='../_Screen/plus.ico' border=0></a> &nbsp;&nbsp;
Line #100:
Line #101:
Line #102:
Line #103:
Line #104:<INPUT TYPE='CHECKBOX' NAME='Desc' Title='' value=''
Line #105:<? if (isset($_POST[Desc])) echo(' CHECKED '); ?>
Line #106:
Line #107:
Line #108:
Line #109:
Line #110:
Line #111:
Line #112:onchange=this.form.submit(); return true name='Bis'>
Line #113:
Line #114:<br>
Line #115:
Line #116:
Line #117:
Line #118:
Line #119:
Line #120: TYPE='text' NAME='Bis' size=40
Line #121:value='<? if (isset($_POST[Bis])) echo($_POST[Bis]); ?>'
Line #122:>
Line #123:
Line #124:
Line #125: TYPE='submit' NAME='submit'
Line #126:
Line #127:
Line #128:</form>
Line #129:
Line #130:</td><tr><td>
Line #131:
Line #132:<?php
Line #133:if (isset($_POST[qscan])) {
Line #134://include("QJ_cimscan.php");
Line #135:}
Line #136:?>
Line #137:</td><tr>
Line #138:<?php
Line #139:
Line #140:
Line #141:if (!isset($_GET[goon]))
Line #142:{
Line #143: UNSET($_GET[Bis]);
Line #144:}
Line #145:
Line #146:
Line #147:if (!isset($_GET[forgalom])) $_GET[forgalom]=3;
Line #148:
Line #149:
Line #150:if (isset($_GET[Desc])) $Viewpar.="&Desc=Y";
Line #151:if (isset($_GET[Bis])) $Viewpar.="&Bis=".$_GET[Bis];
Line #152:if (isset($_GET[forgalom])) $Viewpar.="&forgalom=".$_GET[forgalom];
Line #153:
Line #154:$ParHead="<table>";
Line #155:$export=false;
Line #156://$tabla=$_GET["tabla"];
Line #157:$biord="";
Line #158:$tabla="qj_cimtar";
Line #159:
Line #160:
Line #161:/*if (isset($_POST[Desc])) {
Line #162:
Line #163:}*/
Line #164:
Line #165:
Line #166:if (isset($_POST["biord"])) {
Line #167:$biord= " order by ".$_POST["biord"];
Line #168:if (isset($_POST[Desc])) {
Line #169:
Line #170:$biord.=" DESC";
Line #171:}
Line #172:} else $biord= " order by nev";
Line #173:
Line #174://///////////// si12 /////////////
Line #175:if (isset($_SESSION[sorrend])) {
Line #176:$biord= " order by ".$_SESSION[sorrend];
Line #177:if (isset($_POST[Desc])) {
Line #178:$biord.=" DESC";
Line #179:}
Line #180:}
Line #181:
Line #182:
Line #183:ECHO('<html>
Line #184:<title>'. $tabla.' </title>
Line #185:');
Line #186:
Line #187:$eredmeny = mysql_query('show fields from '.$tabla);
Line #188:
Line #189:$fid='';
Line #190:$qee='<table width=700 BORDER=1 ><tr>';
Line #191:$fullRec="CONCAT_WS(";
Line #192:$vesszo="";
Line #193:$qee .= '<td width=50>&nbsp;</td>';
Line #194:
Line #195:$i=0;
Line #196:while ($row =mysql_fetch_row($eredmeny))
Line #197:{
Line #198:$fid.=$row[0] . ":";
Line #199:if ($i>2 and $i<8)
Line #200:$qee .= '<td width=100><b><a href="QJ_cimtar.php?&tabla='.$tabla.'&biord='.$row[0].$Viewpar.'">'.$row[0].'</a></b></td>';
Line #201:++$i;
Line #202://$fullRec.=$vesszo."Upper(".$row[0].")";
Line #203:$fullRec.=$vesszo."(".$row[0].")";
Line #204:$vesszo=",'/', ";
Line #205:
Line #206:}
Line #207:
Line #208:$full=$fullRec.")";
Line #209:
Line #210:$fullRec.=") as full";
Line #211:$fid.="full:";
Line #212:
Line #213://echo($fullRec."<hr>");
Line #214:
Line #215: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 #216://INSTR(UPPER(".$full."),'".strtoupper($_GET[Bis])."') "; else $wer="";
Line #217:
Line #218:
Line #219:if (!isset($_POST[goon]) and isset($_POST[Bis])) {
Line #220:$bislen=strlen($_POST[Bis]);
Line #221://if ($bislen>1) $Limit="";
Line #222:$wer=" Where usr_kod<>'*DEL' and nev<>'' and left(nev,".$bislen.")='".$_POST[Bis]."'";
Line #223:
Line #224:}
Line #225:
Line #226:
Line #227:$qee .= '</tr>';
Line #228://$keres = "SELECT * ,".$fullRec ." FROM " . $tabla . $wer . $biord;
Line #229:
Line #230:
Line #231:if (substr($_GET[Bis],0,2)=="//" and strlen($_GET[Bis])>4) {
Line #232:
Line #233: $sqlwer=substr($_GET[Bis],2,strlen($_GET[Bis])-2);
Line #234:// echo "<script language = javascript>";
Line #235:// echo "alert('SQL: SELECT * FROM ".$tabla." WHERE ".$sqlwer."');";
Line #236:// echo "</script>";
Line #237:
Line #238:$keres = "SELECT * FROM " . $tabla . " where ".$sqlwer;
Line #239:
Line #240://print "<font size=4 color=blue>SQL: <b>".$keres."</b></font><hr>";
Line #241:
Line #242:
Line #243:$nurL=mysql_num_rows($eredmeny);
Line #244:$nur=$nurL;
Line #245://$Limit="";
Line #246:$biord="";
Line #247:
Line #248:////////
Line #249:} else {
Line #250:////////
Line #251:
Line #252:
Line #253:$keres = "SELECT wid FROM " . $tabla ;
Line #254:
Line #255:$nurX=mysql_num_rows($eredmeny);
Line #256:
Line #257:$keres = "SELECT wid FROM " . $tabla . $wer . $biord;
Line #258:
Line #259:
Line #260:$nurL=mysql_num_rows($eredmeny);
Line #261:
Line #262:$limit=" Limit 50";
Line #263:
Line #264:if (isset($_SESSION[qcsoport]) and $_SESSION[qcsoport]<>"*") {
Line #265:if ($wer<>"")
Line #266:$wer.= " and csoport_kod='".$_SESSION[qcsoport]."'";
Line #267:else $wer= " where csoport_kod='".$_SESSION[qcsoport]."'";
Line #268:}
Line #269:
Line #270:$keres = "SELECT * FROM " . $tabla . $wer . $biord . $Limit;
Line #271:
Line #272:
Line #273:$nur=mysql_num_rows($eredmeny);
Line #274:
Line #275:if (substr($_POST[Bis],0,1)=="*" )
Line #276:{
Line #277:$wid=substr($_POST[Bis],1,strlen($_POST[Bis])-1);
Line #278:$keres = "SELECT * FROM " . $tabla . " where wid=$wid";
Line #279:
Line #280:
Line #281:
Line #282:$nur=mysql_num_rows($eredmeny);
Line #283:
Line #284:}
Line #285:
Line #286:}
Line #287:
Line #288://?//
Line #289:echo($keres."<hr>");
Line #290:
Line #291://if ($nurL<1001) $Limit="";
Line #292:
Line #293:$Limit=" LIMIT 50";
Line #294:
Line #295:
Line #296:
Line #297:$head=$ParHead;
Line #298:
Line #299:if ($nur==0) {
Line #300:
Line #301:$ee =$head.$ee. '</table>';
Line #302:echo($ee);
Line #303:
Line #304:
Line #305:
Line #306:exit;
Line #307:}
Line #308:
Line #309:if ($nur>50 ) {
Line #310:
Line #311:$keres = "SELECT * FROM " . $tabla . $wer . $biord . " Limit 50 ";
Line #312:
Line #313:
Line #314:if ($_POST[forgalom]==3 or !isset($_POST[forgalom]))
Line #315:
Line #316:
Line #317:
Line #318://$ee =$head.$ee. '</table>';
Line #319://echo($ee);
Line #320:
Line #321:}
Line #322:
Line #323://echo($nur."/".$keres."<hr>");
Line #324:
Line #325:
Line #326:$nur=mysql_num_rows($eredmeny);
Line #327:
Line #328://echo($nur."<hr>head".$head."<hr>qee".$qee);
Line #329:
Line #330:if ($nur==0) { $head=""; $qee="";}
Line #331:
Line #332:$ii=0;
Line #333:
Line #334:$h=split(':',$fid);
Line #335:
Line #336:$e= $head.$qee;
Line #337:
Line #338:echo($e);
Line #339:
Line #340:
Line #341:$bgszin="white";
Line #342:
Line #343:for($i=0;$i<$nur;$i++) {
Line #344:
Line #345:$e="";
Line #346:
Line #347:$r=mysql_fetch_row($eredmeny);
Line #348:
Line #349:$vevo=$r[0];
Line #350:
Line #351:$keresE = "SELECT statusz from qj_jegy where vevo_kod=$vevo and ".$_SESSION[SQL_elojegy];
Line #352:
Line #353:$nurE=mysql_num_rows($eredmenyE);
Line #354:
Line #355:$keresF = "SELECT statusz from qj_jegy where vevo_kod=$vevo and ".$_SESSION[SQL_elad];
Line #356:
Line #357:$nurF=mysql_num_rows($eredmenyF);
Line #358:
Line #359:$ii++;
Line #360:$e .= '<tr width=700 >';
Line #361:$e.='<td width=80 ALIGN=center>';
Line #362:
Line #363:$e.='<a target=sframe href=QJ_cimUP.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #364:
Line #365:
Line #366:$e.='&nbsp;<a target=sframe href=QJ_cimtarUP.php?&wjid='.$r[0].'&sqlfile='.$tabla.'>
Line #367:
Line #368:
Line #369:if ($nurF>0)
Line #370:$e.='<br>
Line #371:<A target=infoframe STYLE="{vlink : gold}"
Line #372:href="QJ_eladasok.php?&vevo='.$r[0].'">
Line #373:
Line #374:'.$nurF.' db
Line #375:<A target=adatframe STYLE="{vlink : gold}"
Line #376:href="QJ_cimDIRECT.php?&cimjav=Y&vevo='.$r[0].'">
Line #377:
Line #378:
Line #379:if ($nurE>0)
Line #380:$e.='<br>'.$nurE.' db
Line #381:<A target=infoframe STYLE="{vlink : gold}"
Line #382:href="QJ_elojegyzesek.php?&vevo='.$r[0].'">
Line #383:
Line #384:
Line #385:$e.='</td>';
Line #386:
Line #387:
Line #388:if ($bgszin=="white") $bgszin="silver"; else $bgszin="white";
Line #389:
Line #390:// email cim kihagyva !!!
Line #391:$e .= '<td width=100 bgcolor='.$bgszin.'>&nbsp;'.$r[3].'<br><font color=red>'.$r[9].'</font>&nbsp;</td>';
Line #392:
Line #393:for($j=4,$k=0;$j<count($r)-3;$j++) {
Line #394:
Line #395:
Line #396://$e .= '<td width=50 bgcolor='.$bgszin.'>&nbsp;'.htmlspecialchars($r[$j]).'&nbsp;</td>';
Line #397:$e .= '<td width=100 bgcolor='.$bgszin.'>&nbsp;'.$r[$j].'&nbsp;</td>';
Line #398:
Line #399:}
Line #400:$e .= '</tr>';
Line #401:
Line #402:
Line #403:echo($e);
Line #404:
Line #405:}
Line #406:
Line #407:$e = '</table>';
Line #408:echo($e);
Line #409:
Line #410:
Line #411:echo($e);
Line #412:
Line #413:?>
Line #414:</tr></table>
Line #415: