QC_cmtarSearch.inc

---

Line #0:<?
Line #1:
Line #2:
Line #3://?//BI_alert($_POST[Desc]);
Line #4:
Line #5:
Line #6:$_SESSION["scanBI"] = "a";
Line #7:
Line #8:if (!isset($_SESSION[cim_scan])) $_SESSION[cim_scan]="QJ_cimtar.php";
Line #9:
Line #10:
Line #11:
Line #12:if (!isset($_SESSION[CIM_sorrend])) $_SESSION[CIM_sorrend]="nev";
Line #13:
Line #14:if (isset($_GET[mod])) $_SESSION[CIM_sorrend]=$_GET[mod];
Line #15:$CIM_sorrend=$_SESSION[CIM_sorrend];
Line #16:
Line #17:
Line #18:if (!isset($_SESSION[CIM_goon])) $_POST[goon]=="?";
Line #19:
Line #20://if (isset($_POST[goon]) and $_POST[goon]=="goon" )
Line #21:if (isset($_POST[goon]))
Line #22:$_SESSION[CIM_goon]=$_POST[goon];
Line #23:
Line #24:
Line #25:
Line #26:
Line #27://if (isset($_POST[goon]) and $_POST[goon]<>"goon" )
Line #28://unset($_SESSION[CIM_goon]);
Line #29:
Line #30:
Line #31://?//include("QJ_varlist.php");
Line #32:
Line #33:if (!isset($_SESSION[CIM_DESC])) $_SESSION[CIM_DESC]="";
Line #34:if (isset($_POST[Desc])) {
Line #35:if ($_SESSION[CIM_DESC]=="*" )
Line #36:$_SESSION[CIM_DESC]=""; else $_SESSION[CIM_DESC]="*";
Line #37:}
Line #38:if (isset($_POST[delete])) {
Line #39:$_GET[value]="";
Line #40:$_SESSION["BI_user_ker"]="";
Line #41:$_SESSION["BI_taj_ker"]="";
Line #42:$_POST[user_ker]="";
Line #43:$_POST[taj_ker]="";
Line #44:}
Line #45:
Line #46://if (isset($_GET[value])){
Line #47:if (isset($_POST[user_ker]) or isset($_POST[submit])){
Line #48://BI_alert("*".$_GET[value]."*");
Line #49:
Line #50:
Line #51:
Line #52:$_SESSION["BI_user_ker"]=$_POST[user_ker];
Line #53:
Line #54:
Line #55:}
Line #56:
Line #57://if (isset($_GET[value])){
Line #58:
Line #59://BI_alert("*".$_GET[value]."*");
Line #60:
Line #61://else $_SESSION["BI_user_ker"]="";
Line #62:
Line #63:
Line #64:// $BI_user_ker= str_replace("~"," ",$_SESSION[BI_user_ker]);
Line #65: $BI_user_ker= $_SESSION[BI_user_ker];
Line #66:
Line #67:if (isset($_POST[Desc])) $_SESSION[CALL_ord]=$_POST[Desc];
Line #68:
Line #69:if ($_POST[Desc]=="DESC") $_SESSION[CALL_ord]="DESC"; else $_SESSION[CALL_ord]="";
Line #70:
Line #71:
Line #72:if (isset($_POST[Puser]) and $_POST[Puser]<>"*"){
Line #73:
Line #74:
Line #75:$sql="select * FROM qj_cimtar where wid='".$_POST[Puser]."'";
Line #76:
Line #77:
Line #78:$_SESSION["QJ_cimtarSQL"]=$sql;
Line #79:
Line #80://?//echo ($sql."<hr>");
Line #81:
Line #82:$sor = mysql_fetch_array($stid);
Line #83:
Line #84:$wjid = $sor[wid];
Line #85:$nev = $sor[nev];
Line #86:$telepules = $sor[telepules];
Line #87:$cim = $sor[cim];
Line #88:$telszam= $sor[telszam];
Line #89:$uzenet= $sor[uzenet];
Line #90:$item =$nev.", ".$telepules.", ".$telepules.", ".$telszam.", ".$uzenet;
Line #91:
Line #92:$BI_user_ker=$sor[$CIM_sorrend];
Line #93:
Line #94://$_SESSION["BI_user_ker"] = $nev ;
Line #95://$_SESSION["CIM_sorrend"]=="nev";
Line #96:
Line #97://$_POST[user_ker]=$_SESSION["BI_user_ker"];
Line #98:// echo "<script language = javascript>";
Line #99:
Line #100:// echo "parent.location.href='index.php'";
Line #101://echo 'window.location.href = "QJ_cimtar.php"';
Line #102:// echo "</script>";
Line #103:
Line #104://exit;
Line #105:
Line #106:}
Line #107:
Line #108:
Line #109:?>
Line #110:<? // print $_SESSION[cim_scan]; ?>
Line #111:
Line #112:<table cellspacing="0" cellpadding="0" align="center" width="100%">
Line #113:<tr ><td >
Line #114:<table width="100%">
Line #115:<tr ><td>
Line #116:
Line #117:
Line #118:<table class="contentpaneopen">
Line #119:<tr>
Line #120:<td valign="top">
Line #121:<form name="search" method="POST" action="<? print $_SESSION[cim_scan]; ?>" >
Line #122:<table bgcolor="#A7C2B3" cellpadding="2" cellspacing="2" width=100%">
Line #123:<tr>
Line #124:<td nowrap>
Line #125:
Line #126:
Line #127:<img width=20 height=20 src='../_Screen/plus.ico' border=0></a> &nbsp;&nbsp;
Line #128:<hr>
Line #129:</td>
Line #130:<td bgcolor="#DBE6E0">
Line #131:
Line #132:
Line #133:<?PHP
Line #134:
Line #135:
Line #136:
Line #137:IF ($CIM_sorrend=="nev") $sel=" SELECTED "; else $sel="";
Line #138:
Line #139:
Line #140:IF ($CIM_sorrend=="email_cim") $sel=" SELECTED "; else $sel="";
Line #141:
Line #142:
Line #143:IF ($CIM_sorrend=="telepules") $sel=" SELECTED "; else $sel="";
Line #144:
Line #145:
Line #146:IF ($CIM_sorrend=="telszam") $sel=" SELECTED "; else $sel="";
Line #147:
Line #148:
Line #149:IF ($CIM_sorrend=="uzenet") $sel=" SELECTED "; else $sel="";
Line #150:
Line #151:
Line #152:
Line #153:?>
Line #154:
Line #155:</select>
Line #156:
Line #157:
Line #158:
Line #159:" value="" name=CHAR_len >
Line #160:
Line #161:
Line #162: <INPUT TYPE='radio' NAME='goon' value='goon' <?if ($goon=="goon") echo(" CHECKED ");?>
Line #163: >Tartalom ...
Line #164:
Line #165: <INPUT TYPE='radio' NAME='goon' value='?' <?if ($goon=="?") echo(" CHECKED "); ?>
Line #166:
Line #167:
Line #168: <INPUT TYPE='CHECKBOX' NAME='Desc' value='DESC' <?if ($_SESSION[CALL_ord]=="DESC") print " checked='checked' "; ?>
Line #169: onclick=this.form.submit(); return true name='Desc'
Line #170: >
Line #171:
Line #172:
Line #173:
Line #174:
Line #175:
Line #176:<?PHP
Line #177:
Line #178:/*IF ($CIM_sorrend=="taj")
Line #179: echo "<script>alert('?taj');CheckLen(search.taj_ker,30,'taj');</script>";
Line #180:IF ($CIM_sorrend=="nev")
Line #181: echo "<script>alert('?nev');CheckLen(search.user_ker,30,'nev');</script>";
Line #182:*/
Line #183:
Line #184:?>
Line #185:
Line #186:</td></tr>
Line #187:
Line #188:<?php
Line #189:
Line #190:IF ($CIM_sorrend=="nev")
Line #191:$fullRec =" INSTR((CONCAT_WS(nev,'/', telepules,'/', cim,'/', telszam,'/',email_cim,'/', uzenet)),'".$BI_user_ker."')";
Line #192:
Line #193:IF ($CIM_sorrend=="telepules")
Line #194:$fullRec =" INSTR((CONCAT_WS(telepules,'/',nev,'/', cim,'/', telszam,'/',email_cim,'/', uzenet)),'".$BI_user_ker."')";
Line #195:
Line #196:IF ($CIM_sorrend=="email")
Line #197:$fullRec =" INSTR((CONCAT_WS(email_cim,'/',telepules,'/',nev,'/', cim,'/', telszam,'/', uzenet)),'".$BI_user_ker."')";
Line #198:
Line #199:IF ($CIM_sorrend=="telszam")
Line #200:$fullRec =" INSTR((CONCAT_WS(telszam,'/', nev,'/', telepules,'/', cim,'/',email_cim,'/', uzenet)),'".$BI_user_ker."')";
Line #201:
Line #202:IF ($CIM_sorrend=="uzenet")
Line #203:$fullRec =" INSTR((CONCAT_WS(uzenet,'/', nev,'/', telepules,'/', cim,'/',email_cim,'/', telszam)),'".$BI_user_ker."')";
Line #204:
Line #205:if ($goon=="goon")
Line #206:{
Line #207:IF (trim($fullRec)<>"" )
Line #208:$sql2="select * FROM qj_cimtar where $cimwer nev<>'' and $fullRec order by $CIM_sorrend $_SESSION[CALL_ord]";
Line #209:else
Line #210:$sql2="select * FROM qj_cimtar where $cimwer nev<>'' order by $CIM_sorrend $_SESSION[CALL_ord]";
Line #211:}
Line #212:else
Line #213:$sql2="select * FROM qj_cimtar where $cimwer nev<>'' LIKE '$BI_user_ker%' order by $CIM_sorrend $_SESSION[CALL_ord]";
Line #214:
Line #215://if ( !isset($_SESSION[CIM_sorrend]) or !isset($_SESSION[$_SESSION[BI_user_ker]]))
Line #216://$sql2="select * FROM qj_cimtar order by wid";
Line #217:
Line #218://?//echo($sql2."<hr>".$fullRec);
Line #219:
Line #220:
Line #221:
Line #222:
Line #223:$nurL=mysql_num_rows($stid2);
Line #224:
Line #225: echo "<script language = javascript>";
Line #226: echo "document.search.CHAR_len.value = ".$nurL.";";
Line #227: echo "</script>";
Line #228:
Line #229:
Line #230:
Line #231:
Line #232://SELECT LOWER(CONCAT_WS(title,description)) AS concatenated WHERE concatenated LIKE '%searchterm%'
Line #233://SELECT LOWER(CONCAT_WS(title,description)) AS concatenated WHERE concatenated LIKE LOWER('%SearchTerm%')
Line #234:
Line #235:if ($goon=="goon")
Line #236:$sql="select * FROM qj_cimtar where $cimwer nev<>'' and usr_kod<>'*DEL' and $fullRec order by $CIM_sorrend $_SESSION[CALL_ord] limit 15";
Line #237:ELSE
Line #238:$sql="select * FROM qj_cimtar where $cimwer nev<>'' and usr_kod<>'*DEL' and $CIM_sorrend LIKE '$BI_user_ker%' order by $CIM_sorrend $_SESSION[CALL_ord] limit 15";
Line #239:
Line #240://if ( !isset($_SESSION[CIM_sorrend]) or !isset($_SESSION[$_SESSION[BI_user_ker]]))
Line #241://$sql="select * FROM qj_cimtar order by wid limit 15 ";
Line #242:
Line #243:
Line #244:$_SESSION["QJ_cimtarSQL"]=$sql;
Line #245:
Line #246://?// echo($sql."<hr>");
Line #247:
Line #248:if ($BI_user_ker!="") {
Line #249:
Line #250://?//echo($sql."<hr>");
Line #251:
Line #252:
Line #253:
Line #254:if ($nurL>15) $m=15; else $m=$nurL;
Line #255:
Line #256:
Line #257:onclick=this.form.submit(); return true name="Puser">';
Line #258:
Line #259:
Line #260://echo "<script>var customarray=new Array();</script>";
Line #261:while ($sor = mysql_fetch_array($stid)) {
Line #262:$wjid = $sor[wid];
Line #263:$nev = $sor[nev];
Line #264:$telepules = $sor[telepules];
Line #265:$cim = $sor[cim];
Line #266:$telszam= $sor[telszam];
Line #267:$uzenet= $sor[uzenet];
Line #268:$item =$nev.", ".$telepules.", ".$cim.", ".$telszam.", ".$uzenet;
Line #269:
Line #270:
Line #271:IF ($CIM_sorrend=="nev")
Line #272:$item =$nev.", ".$telepules.", ".$cim.", ".$telszam.", ".$uzenet;
Line #273:IF ($CIM_sorrend=="telepules")
Line #274:$item =$telepules.", ".$cim.", ".$nev.", ".$telszam.", ".$uzenet;
Line #275:IF ($CIM_sorrend=="telszam")
Line #276:$item =$telszam.", ".$nev.", ".$telepules.", ".$cim.", ".$uzenet;
Line #277:IF ($CIM_sorrend=="uzenet")
Line #278:$item =$uzenet.", ".$telszam.", ".$nev.", ".$telepules.", ".$cim;
Line #279:
Line #280:
Line #281:$e.="<option value='$wjid'>$item</option>";
Line #282:}
Line #283:
Line #284:
Line #285:
Line #286:
Line #287:
Line #288:$e.='</select>';
Line #289:
Line #290:
Line #291:} else {
Line #292://echo "<script>var customarray=new Array();</script>";
Line #293://$e="";
Line #294:}
Line #295://onclick="return nullCheck(this)"
Line #296:
Line #297:?>
Line #298:
Line #299:<tr>
Line #300:<td nowrap rowspan=2>
Line #301:<B><? print $talalat; ?> </B>
Line #302:</td>
Line #303:<td bgcolor="#DBE6E0" >
Line #304:
Line #305:value="<?php print $BI_user_ker; ?>" maxlength="50" size="50">
Line #306:
Line #307:<input type="hidden" name="user_uid" id='uuid' value="<?php print $uid; ?>">
Line #308:&nbsp;&nbsp;&nbsp;
Line #309:
Line #310: TYPE='submit' NAME='submit'
Line #311:
Line #312:
Line #313:
Line #314:</td>
Line #315:</tr>
Line #316:<tr>
Line #317:
Line #318:<script>
Line #319:document.search.user_ker.focus();
Line #320://document.search.user_ker.focus();
Line #321:document.search.user_ker.value = "<?php print $BI_user_ker; ?>";
Line #322://var obj = actb(document.getElementById('tdu'),customarray);
Line #323:</script>
Line #324:
Line #325:
Line #326:<td bgcolor="#DBE6E0">
Line #327:
Line #328:
Line #329:</td>
Line #330:</tr>
Line #331:
Line #332:</table>
Line #333:
Line #334:</form>
Line #335:
Line #336:<SCRIPT LANGUAGE="JavaScript">
Line #337:
Line #338:
Line #339: function CheckLen(input,max,hiv){
Line #340:
Line #341:// if(input.value.length>max){
Line #342:
Line #343:// input.value = input.value.substring(0,input.value.length-1);
Line #344:// }
Line #345:
Line #346:// document.search.CHAR_len.value = input.value.length;
Line #347://alert(hiv+ " / " + input.value);
Line #348:
Line #349://window.location.href = "QJ_cimtar.php?&value=" + input.value+"&mod=" + hiv;
Line #350:
Line #351:window.location.href = "QJ_cimtar.php?&value=" + input.value;
Line #352:
Line #353://document.search.user_ker.focus();
Line #354:
Line #355: }
Line #356:
Line #357:
Line #358:function nullCheck(){
Line #359:
Line #360:
Line #361:if (document.search.szempont.value == "nev") {
Line #362:// document.search.CHAR_len.value = search.user_ker.value.length;
Line #363://CheckLen(search.user_ker,30);
Line #364:
Line #365: if (document.search.user_ker.value == "")
Line #366: {
Line #367:
Line #368: return false;
Line #369: }
Line #370:}
Line #371:else if (document.search.szempont.value == "taj") {
Line #372:// document.search.CHAR_len.value = search.taj_ker.value.length;
Line #373://CheckLen(search.taj_ker,30);
Line #374: if (document.search.taj_ker.value == "")
Line #375: {
Line #376:
Line #377: return false;
Line #378: }
Line #379: }
Line #380:}
Line #381:
Line #382:
Line #383:function modCheck (field) {
Line #384:
Line #385://if (document.search.szempont.value == "nev")
Line #386:document.search.user_ker.focus();
Line #387:
Line #388://{
Line #389://alert(document.search.szempont.value+'***NEV***');
Line #390://document.search.taj_ker.value = "alma";
Line #391://CheckLen(search.taj_ker,30);
Line #392://document.search.taj_ker.focus();
Line #393://document.search.taj_ker.value = "<?php print $char; ?>";
Line #394://var obj = actb(document.getElementById('tjk'),customarray);
Line #395:
Line #396://}
Line #397://else if (document.search.szempont.value == "taj") {
Line #398://alert(document.search.szempont.value+'***TAJ***');
Line #399://document.search.user_ker.value = "dio";
Line #400://CheckLen(search.user_ker,30);
Line #401://document.search.user_ker.focus();
Line #402:// document.search.CHAR_len.value = search.user_ker.value.length;
Line #403:
Line #404://}
Line #405:
Line #406:
Line #407://?//alert(field.value+" ---- ");
Line #408:
Line #409:if (field.value != "") {
Line #410: window.location.href = "<? print $_SESSION[cim_scan]; ?>?&mod=" + field.value;
Line #411: }
Line #412:
Line #413:}
Line #414:function firstChar(field, key) {
Line #415:
Line #416: alert(String.fromCharCode(key));
Line #417: var alphaExp = /[a-zA-Z]/;
Line #418: var numExp = /[0-9]/;
Line #419://if (String.fromCharCode(key).match(/[a-zA-Z]/)) {
Line #420: if (field.value.length <= 1 && field.value!=" ") {
Line #421: window.location.href = "QJ_cimtar.php?&char=" + field.value;
Line #422: document.search.user_ker.focus();
Line #423: } else {
Line #424: return false;
Line #425: }
Line #426:// } else {
Line #427:// return false;
Line #428:// }
Line #429:}
Line #430:function firstNum(field, key) {
Line #431:
Line #432: alert(String.fromCharCode(key));
Line #433: var alphaExp = /[a-zA-Z]/;
Line #434: var numExp = /[0-9]/;
Line #435:if (String.fromCharCode(key).match(/[0-9]/)) {
Line #436: if (field.value.length <= 1 && field.value!=" ") {
Line #437: window.location.href = "QJ_cimtar.php?&char=" + field.value;
Line #438: document.search.taj_ker.focus();
Line #439: } else {
Line #440: return false;
Line #441: }
Line #442: } else {
Line #443: return false;
Line #444: }
Line #445:}
Line #446:// -->
Line #447:</SCRIPT>
Line #448:
Line #449:
Line #450:<?php
Line #451:
Line #452:?>
Line #453: