Changeset 7041
- Timestamp:
- May 8, 2008, 5:38:42 PM (14 years ago)
- Location:
- OpenPNE/branches/stable-2.12.x/webapp
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/branches/stable-2.12.x/webapp/lib/db/point.php
r6527 r7041 119 119 } 120 120 121 // ランクから到達ポイントを取得 122 function db_point_get_point4rank_id($c_rank_id) 123 { 124 $sql = "SELECT point FROM c_rank WHERE c_rank_id = ?"; 125 $params = array(intval($c_rank_id)); 126 return db_get_one($sql, $params); 127 } 128 129 // 指定したランクの次のランクの到達ポイントを取得 130 function db_point_get_point4pre_rank_id($c_rank_id) 131 { 132 $pre_point = db_point_get_point4rank_id($c_rank_id); 133 134 $sql = 'SELECT point FROM c_rank WHERE point > ? ORDER BY point'; 135 $params = array(intval($pre_point)); 136 137 return db_get_one($sql, $params); 138 } 139 140 // 指定したランクの情報を取得 141 function db_point_get_rank4rank_id($c_rank_id) 142 { 143 $sql = "SELECT * FROM c_rank WHERE c_rank_id = ?"; 144 $params = array(intval($c_rank_id)); 145 return db_get_row($sql, $params); 146 } 147 121 148 ?> -
OpenPNE/branches/stable-2.12.x/webapp/modules/admin/lib/db_admin.php
r6942 r7041 692 692 $params = array('PNE_POINT'); 693 693 694 // 開始ポイント695 if (!empty($cond_list['s_point'])) {694 if ($cond_list['s_rank']) { 695 $s_point = db_point_get_point4rank_id($cond_list['s_rank']); 696 696 $sql .= ' AND value >= ?'; 697 $params[] = $cond_list['s_point']; 698 } 699 700 // 終了ポイント 701 if (!empty($cond_list['e_point'])) { 702 $sql .= ' AND value < ?'; 703 $params[] = $cond_list['e_point']; 697 $params[] = (int)$s_point; 698 } 699 700 if ($cond_list['e_rank']) { 701 $e_point = db_point_get_point4pre_rank_id($cond_list['e_rank']); 702 if (!is_null($e_point)) { 703 $sql .= ' AND value < ?'; 704 $params[] = (int)$e_point; 705 } 704 706 } 705 707 … … 834 836 835 837 // ポイントで絞り込み 836 if ( isset($cond_list['s_point']) || isset($cond_list['e_point'])) {838 if ($cond_list['s_rank'] || $cond_list['e_rank']) { 837 839 $ids = db_admin_c_member_id_list4cond_pne_point($ids, $cond_list); 838 840 } … … 922 924 923 925 //ポイント 924 if (isset($requests['s_ point']) && $requests['s_point'] !== '') {925 $cond_list['s_ point'] = intval($requests['s_point']);926 } 927 if (isset($requests['e_ point']) && $requests['e_point'] !== '') {928 $cond_list['e_ point'] = intval($requests['e_point']);926 if (isset($requests['s_rank']) && $requests['s_rank'] !== '') { 927 $cond_list['s_rank'] = intval($requests['s_rank']); 928 } 929 if (isset($requests['e_rank']) && $requests['e_rank'] !== '') { 930 $cond_list['e_rank'] = intval($requests['e_rank']); 929 931 } 930 932 -
OpenPNE/branches/stable-2.12.x/webapp/modules/admin/page/send_messages_search.php
r6527 r7041 16 16 17 17 $special_keys = array('s_year', 'e_year', 18 's_ point', 'e_point',18 's_rank', 'e_rank', 19 19 'last_login', 20 20 'is_pc_address', 'is_ktai_address'); … … 40 40 $v['select_last_login'] = $select_last_login; 41 41 42 if ($cond_list['s_rank']) { 43 $v['s_rank'] = db_point_get_rank4rank_id($cond_list['s_rank']); 44 } 45 46 if ($cond_list['e_rank']) { 47 $v['e_rank'] = db_point_get_rank4rank_id($cond_list['e_rank']); 48 } 49 42 50 $this->set($v); 43 51 -
OpenPNE/branches/stable-2.12.x/webapp/modules/admin/templates/list_c_member.tpl
r6878 r7041 114 114 ({if $smarty.const.OPENPNE_USE_POINT_RANK}) 115 115 <th class="cell10" colspan="2"> 116 <select class="basic" onChange="Link('?m=({$module_name})&a=page_({$hash_tbl->hash('list_c_member')})&page=({$pager.page})&page_size=({$pager.page_size})&order=({$requests.order})({$cond})&s_ point='+this.options[this.selectedIndex].value);">116 <select class="basic" onChange="Link('?m=({$module_name})&a=page_({$hash_tbl->hash('list_c_member')})&page=({$pager.page})&page_size=({$pager.page_size})&order=({$requests.order})({$cond})&s_rank='+this.options[this.selectedIndex].value);"> 117 117 <option value="">▼選択</option> 118 118 ({foreach from=$rank_data item=item}) 119 <option({if $cond_list.s_ point == $item.point}) selected({/if}) value="({$item.point})">({$item.name})</option>119 <option({if $cond_list.s_rank == $item.c_rank_id}) selected({/if}) value="({$item.c_rank_id})">({$item.name})</option> 120 120 ({/foreach}) 121 121 </select> 122 122 ~ 123 <select class="basic" onChange="Link('?m=({$module_name})&a=page_({$hash_tbl->hash('list_c_member')})&page=({$pager.page})&page_size=({$pager.page_size})&order=({$requests.order})({$cond})&e_ point='+this.options[this.selectedIndex].value);">123 <select class="basic" onChange="Link('?m=({$module_name})&a=page_({$hash_tbl->hash('list_c_member')})&page=({$pager.page})&page_size=({$pager.page_size})&order=({$requests.order})({$cond})&e_rank='+this.options[this.selectedIndex].value);"> 124 124 <option value="">▼選択</option> 125 125 ({foreach from=$rank_data item=item}) 126 ({if $pre_name})<option({if $cond_list.e_point == $item.point}) selected({/if}) value="({$item.point})">({$pre_name})</option>({/if}) 127 ({assign var=pre_name value=$item.name|smarty:nodefaults}) 128 ({/foreach}) 129 ({if $pre_name})<option({if $cond_list.e_point === 0}) selected({/if}) value="0">({$pre_name})</option>({/if}) 126 <option({if $cond_list.e_rank == $item.c_rank_id}) selected({/if}) value="({$item.c_rank_id})">({$item.name})</option> 127 ({/foreach}) 130 128 </select> 131 129 </th> -
OpenPNE/branches/stable-2.12.x/webapp/modules/admin/templates/send_messages_search.tpl
r4417 r7041 27 27 <li>最終ログイン : ({$select_last_login[$cond_list.last_login]})</li> 28 28 ({/if}) 29 ({if $cond_list.s_ point||$cond_list.e_point})30 <li> ポイント : ({$cond_list.s_point})~({$cond_list.e_point})</li>29 ({if $cond_list.s_rank||$cond_list.e_rank}) 30 <li>ランク : ({$s_rank.name}) ~ ({$e_rank.name})</li> 31 31 ({/if}) 32 32 ({if $cond_list.is_pc_address})
Note: See TracChangeset
for help on using the changeset viewer.