Changeset 7037
- Timestamp:
- May 8, 2008, 5:12:31 PM (14 years ago)
- Location:
- OpenPNE/branches/stable-2.10.x/webapp
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/branches/stable-2.10.x/webapp/lib/db/point.php
r4314 r7037 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.10.x/webapp/modules/admin/lib/db_admin.php
r6941 r7037 680 680 $ids = db_get_col($sql, $params); 681 681 682 // --- ポイントで絞り込み ここから 683 if ( isset($cond_list['s_point']) || isset($cond_list['e_point'])) { 684 685 $sql = 'SELECT c_member_id'. 686 ' FROM c_member_profile '. 687 ' INNER JOIN c_profile USING (c_profile_id) '. 688 ' WHERE name = ? '; 689 $params = array( 690 'PNE_POINT', 691 ); 692 //開始ポイント 693 if (!empty($cond_list['s_point'])) { 682 // --- ランクで絞り込み ここから 683 if ($cond_list['s_rank'] || $cond_list['e_rank']) { 684 $sql = 'SELECT c_member_id' 685 . ' FROM c_member_profile ' 686 . ' INNER JOIN c_profile USING (c_profile_id) ' 687 . ' WHERE name = ? '; 688 $params = array('PNE_POINT'); 689 690 if ($cond_list['s_rank']) { 691 $s_point = db_point_get_point4rank_id($cond_list['s_rank']); 694 692 $sql .= ' AND value >= ?'; 695 $params[] = $cond_list['s_point']; 696 } 697 //終了ポイント 698 if (!empty($cond_list['e_point'])) { 699 $sql .= ' AND value < ?'; 700 $params[] = $cond_list['e_point']; 693 $params[] = (int)$s_point; 694 } 695 696 if ($cond_list['e_rank']) { 697 $e_point = db_point_get_point4pre_rank_id($cond_list['e_rank']); 698 if (!is_null($e_point)) { 699 $sql .= ' AND value < ?'; 700 $params[] = (int)$e_point; 701 } 701 702 } 702 703 703 704 $point_ids = db_get_col($sql, $params); 704 705 705 // ポイントで絞り込み706 // ポイントで絞り込み 706 707 $ids = array_intersect($ids, $point_ids); 707 708 708 709 } 709 // --- ポイントで絞り込み ここまで710 // --- ランクで絞り込み ここまで 710 711 711 712 // --- メールアドレスで絞り込み ここから … … 858 859 } 859 860 860 // ポイント861 if (isset($requests['s_ point']) && $requests['s_point'] !== '') {862 $cond_list['s_ point'] = intval($requests['s_point']);863 } 864 if (isset($requests['e_ point']) && $requests['e_point'] !== '') {865 $cond_list['e_ point'] = intval($requests['e_point']);861 // ランク 862 if (isset($requests['s_rank']) && $requests['s_rank'] !== '') { 863 $cond_list['s_rank'] = intval($requests['s_rank']); 864 } 865 if (isset($requests['e_rank']) && $requests['e_rank'] !== '') { 866 $cond_list['e_rank'] = intval($requests['e_rank']); 866 867 } 867 868 -
OpenPNE/branches/stable-2.10.x/webapp/modules/admin/page/list_c_member.php
r2837 r7037 50 50 $v['select_last_login'] = $select_last_login; 51 51 52 $v['rank_data'] = db_point_get_rank_all();53 54 55 52 //開始年が終了年より大きい 56 53 if ( !empty($cond_list['s_year']) && !empty($cond_list['e_year']) && ($cond_list['s_year'] > $cond_list['e_year']) ) { -
OpenPNE/branches/stable-2.10.x/webapp/modules/admin/page/send_messages_search.php
r3281 r7037 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'); … … 39 39 ); 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.10.x/webapp/modules/admin/templates/list_c_member.tpl
r6876 r7037 99 99 ({if $smarty.const.OPENPNE_USE_POINT_RANK}) 100 100 <th class="cell10" colspan="2"> 101 <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);">101 <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);"> 102 102 <option value="">▼選択</option> 103 103 ({foreach from=$rank_data item=item}) 104 <option({if $cond_list.s_ point == $item.point}) selected({/if}) value="({$item.point})">({$item.name})</option>104 <option({if $cond_list.s_rank == $item.c_rank_id}) selected({/if}) value="({$item.c_rank_id})">({$item.name})</option> 105 105 ({/foreach}) 106 106 </select> 107 107 ~ 108 <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);">108 <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);"> 109 109 <option value="">▼選択</option> 110 110 ({foreach from=$rank_data item=item}) 111 ({if $pre_name})<option({if $cond_list.e_point == $item.point}) selected({/if}) value="({$item.point})">({$pre_name})</option>({/if}) 112 ({assign var=pre_name value=$item.name|smarty:nodefaults}) 113 ({/foreach}) 114 ({if $pre_name})<option({if $cond_list.e_point === 0}) selected({/if}) value="0">({$pre_name})</option>({/if}) 111 <option({if $cond_list.e_rank == $item.c_rank_id}) selected({/if}) value="({$item.c_rank_id})">({$item.name})</option> 112 ({/foreach}) 115 113 </select> 116 114 </th> -
OpenPNE/branches/stable-2.10.x/webapp/modules/admin/templates/send_messages_search.tpl
r4417 r7037 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.