‘;
?>
1 “;
$sql =
” SELECT ”
. ” ID USER_ID ”
. ” ,CONCAT(JA_NAME,'( ‘,KANA,’ )’) FULL_NAME ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_01 BELONGING_TO_01 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_02 BELONGING_TO_02 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_03 BELONGING_TO_03 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_04 BELONGING_TO_04 ”
. ” ,JA_AFFILIATED_ACADEMIC_SOCIETY_05 BELONGING_TO_05 ”
. ” FROM ”
. ” wp_users ”
. ” WHERE ”
. ” ID <> 1 “;
global $wpdb;
if (isset($_GET[“searchPre”])) {
// カナ検索の場合
$searchPre = TRIM($_GET[“searchPre”]);
$paramPre = $searchPre.’%’;
$searchWord .=”searchPre=”.$searchPre;
$sqlwhere = ” AND KANA LIKE %s “;
$stmt = $wpdb->prepare($sql.$sqlwhere.” ORDER BY KANA,ID LIMIT “.$start .”,” .$end.” “,$paramPre);
$stmtCnt = $wpdb->prepare($sqlCnt.$sqlwhere,$paramPre);
} else{
// 検索ワードありの場合
$searchName = split(” “,str_replace(” “, ” “,str_replace(“ ”, ” “,TRIM($_GET[“searchName”]))));
$searchKeyword = split(” “,str_replace(” “, ” “,str_replace(“ ”, ” “,TRIM($_GET[“searchKeyword”]))));
$searchBelong = split(” “,str_replace(” “, ” “,str_replace(“ ”, ” “,TRIM($_GET[“searchBelong”]))));
if (isset($_GET[“setsuzokushi”])) {
if($_GET[“setsuzokushi”] == 0){
$setsuzokushi = “AND”;
} else {
$setsuzokushi = “OR”;
}
}
if($searchName[0] != “” || $searchKeyword[0] != “” || $searchBelong[0] != “”){
$sqlwhere .= ” AND ( “;
}
$searchWord .=”searchName=”.TRIM($_GET[“searchName”]).”&searchKeyword=”.TRIM($_GET[“searchKeyword”]).”&searchBelong=”.TRIM($_GET[“searchBelong”]).”&setsuzokushi=”.TRIM($_GET[“setsuzokushi”]).” “;
$paramName0 = ‘%’.$searchName[0].’%’;
$paramKeyword0 = ‘%’.$searchKeyword[0].’%’;
$paramBelong0 = ‘%’.$searchBelong[0].’%’;
$paramName1 = ‘%’.$searchName[1].’%’;
$paramKeyword1 = ‘%’.$searchKeyword[1].’%’;
$paramBelong1 = ‘%’.$searchBelong[1].’%’;
$paramName2 = ‘%’.$searchName[2].’%’;
$paramKeyword2 = ‘%’.$searchKeyword[2].’%’;
$paramBelong2 = ‘%’.$searchBelong[2].’%’;
$searchArray = “”;
$searchIndex=0;
$isFirstWhere =true;
if($searchName[0] != “”){
if(!$isFirstWhere){
$sqlwhere .= ” AND ( “;
} else {
$sqlwhere .= ” ( “;
}
$sqlWhereName =” (JA_NAME LIKE %s OR KANA LIKE %s) “;
$sqlwhere .= $sqlWhereName;
for($i = 0 ; $i < 2; $i++){
$searchArray[$searchIndex] = $paramName0;
$searchIndex++;
}
if($searchName[1] != ""){
$sqlwhere .= " ".$setsuzokushi." ".$sqlWhereName;
for($i = 0 ; $i < 2; $i++){
$searchArray[$searchIndex] = $paramName1;
$searchIndex++;
}
if($searchName[2] != ""){
$sqlwhere .= " ".$setsuzokushi." ".$sqlWhereName;
for($i = 0 ; $i < 2; $i++){
$searchArray[$searchIndex] = $paramName2;
$searchIndex++;
}
}
}
$sqlwhere .= " ) ";
$isFirstWhere = false;
}
if($searchKeyword[0] != ""){
if(!$isFirstWhere){
$sqlwhere .= " AND ( ";
} else {
$sqlwhere .= " ( ";
}
$sqlWhereKeyword =
" (JA_KEYWORD_01 LIKE %s "
. " OR "
. " JA_KEYWORD_02 LIKE %s "
. " OR "
. " JA_KEYWORD_03 LIKE %s "
. " OR "
. " JA_KEYWORD_04 LIKE %s "
. " OR "
. " JA_KEYWORD_05 LIKE %s "
. " OR "
. " JA_KEYWORD_06 LIKE %s "
. " OR "
. " JA_KEYWORD_07 LIKE %s "
. " OR "
. " JA_KEYWORD_08 LIKE %s "
. " OR "
. " JA_KEYWORD_09 LIKE %s "
. " OR "
. " JA_KEYWORD_10 LIKE %s) ";
$sqlwhere .=$sqlWhereKeyword;
for($i = 0 ; $i < 10; $i++){
$searchArray[$searchIndex] = $paramKeyword0;
$searchIndex++;
}
if($searchKeyword[1] != ""){
$sqlwhere .= " ".$setsuzokushi." ".$sqlWhereKeyword;
for($i = 0 ; $i < 10; $i++){
$searchArray[$searchIndex] = $paramKeyword1;
$searchIndex++;
}
if($searchKeyword[2] != ""){
$sqlwhere .= " ".$setsuzokushi." ".$sqlWhereKeyword;
for($i = 0 ; $i < 10; $i++){
$searchArray[$searchIndex] = $paramKeyword2;
$searchIndex++;
}
}
}
$sqlwhere .= " ) ";
$isFirstWhere = false;
}
if($searchBelong[0] != ""){
if(!$isFirstWhere){
$sqlwhere .= " AND ( ";
} else {
$sqlwhere .= " ( ";
}
$sqlWhereBelong =
" ( JA_AFFILIATED_ACADEMIC_SOCIETY_01 LIKE %s "
. " OR "
. " JA_AFFILIATED_ACADEMIC_SOCIETY_02 LIKE %s "
. " OR "
. " JA_AFFILIATED_ACADEMIC_SOCIETY_03 LIKE %s "
. " OR "
. " JA_AFFILIATED_ACADEMIC_SOCIETY_04 LIKE %s "
. " OR "
. " JA_AFFILIATED_ACADEMIC_SOCIETY_05 LIKE %s) ";
$sqlwhere .=$sqlWhereBelong;
for($i = 0 ; $i < 5; $i++){
$searchArray[$searchIndex] = $paramBelong0;
$searchIndex++;
}
if($searchBelong[1] != ""){
$sqlwhere .= " ".$setsuzokushi." ".$sqlWhereBelong;
for($i = 0 ; $i < 5; $i++){
$searchArray[$searchIndex] = $paramBelong1;
$searchIndex++;
}
if($searchBelong[2] != ""){
$sqlwhere .= " ".$setsuzokushi." ".$sqlWhereBelong;
for($i = 0 ; $i < 5; $i++){
$searchArray[$searchIndex] = $paramBelong2;
$searchIndex++;
}
}
}
$sqlwhere .= " ) ";
$isFirstWhere = false;
}
if($searchName[0] != "" || $searchKeyword[0] != "" || $searchBelong[0] != ""){
$sqlwhere .= " ) ";
}
//echo "abc";
$stmt = $wpdb->prepare($sql.$sqlwhere.” ORDER BY KANA,ID LIMIT “.$start .”,” .$end.” “,$searchArray);
$stmtCnt = $wpdb->prepare($sqlCnt.$sqlwhere,$searchArray);
//echo “あべし”;
}
$rowsCnt = $wpdb->get_results($stmtCnt);
foreach ($rowsCnt as $rowCnt) {
$cnt = $rowCnt->CNT;
break;
}
if(0 < $cnt){
$startDisp = $start + 1;
} else {
$startDisp = 0;
}
$endDisp = $start + $pagingCnt;
if($cnt < $endDisp){
$endDisp = $cnt;
}
// 件数
$cntDisplay = "件数:".$startDisp."件-".$endDisp."件 / ".$cnt."件 " ;
// 前の20件 ※前の20件が存在する場合のみ
if($start != 0){
$indexPast = $index - 1;
$pastMove = '前の’.$pagingCnt.’件へ ‘;
}
// 次のx件 ※次の件数が1件以上存在する場合に、20件、または最大件数 – 現在のindex * 20 件
if($endDisp < $cnt){
if($cnt - $endDisp < $pagingCnt){
$pagingCntDisp = $cnt - $endDisp;
} else {
$pagingCntDisp = $pagingCnt;
}
$indexNext = $index + 1;
$nextMove= '次の’.$pagingCntDisp.’件へ ‘;
}
// ページングの数だけリンクを作成 ※前後に10件を最大件数とする
$pageMax = ceil($cnt / $pagingCnt);
if(1 < $pageMax){
$indexCnt = 0;
for ( $i = 0; $i < $pageMax; $i++ ) {
$dispI = $i + 1;
if($i == $index){
$dispPageIndex.= $dispI ." ";
} else {
$indexCntPrev = $index - $dispI;
$indexCntNext = $dispI - $index;
if($i == 0 || $i == $pageMax - 1){
$dispPageIndex.= '‘.$dispI .’ ‘;
} elseif($indexCntPrev <= 10 && $indexCntNext <= 10){
$dispPageIndex.= '‘.$dispI .’ ‘;
}
}
}
}
$rows = $wpdb->get_results($stmt);
$memberArray;
$rowIndex = 0;
foreach ($rows as $row) {
$memberArray[$rowIndex][0]= ‘‘.
‘
‘.$cntDisplay.’
‘; ?>
‘.$pastMove.$nextMove.’
‘; ?>
‘.$dispPageIndex.’
‘; ?>
‘;
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
$bg = ‘#fafafa’;
foreach ($memberArray as $member) {
if($bg == ‘#fafafa’) {
$bg = ‘#ffffff’;
} elseif($bg == ‘#ffffff’) {
$bg = ‘#fafafa’;
}
echo ‘
‘;
echo ‘
‘;
echo ‘
‘;
}
echo ‘
‘;
}
?>