ここの情報は古いです。ご理解頂いた上でお取り扱いください。

Changeset 2000


Ignore:
Timestamp:
Mar 3, 2007, 5:38:05 AM (13 years ago)
Author:
ishida
Message:

http://trac.openpne.jp/ticket/470
管理画面からレビュー一覧・削除
実装完了

Location:
OpenPNE/branches/ishida/prj_dev28
Files:
5 added
7 edited

Legend:

Unmodified
Added
Removed
  • OpenPNE/branches/ishida/prj_dev28/public_html/modules/admin/default.css

    r1891 r2000  
    670670/** admin_page_delete_kakikomi **/
    671671#admin_page_delete_kakikomi .deleteKakikomiDiary ,
    672 #admin_page_delete_kakikomi .deleteKakikomiCommu {
     672#admin_page_delete_kakikomi .deleteKakikomiCommu ,
     673#admin_page_delete_kakikomi .deleteKakikomiCommuTopic {
    673674        border-bottom: 1px #C3C3C3 solid;
    674675        padding-bottom: 5px;
    675676}
    676 #admin_page_delete_kakikomi .deleteKakikomiCommuTopic {}
     677#admin_page_delete_kakikomi .deleteKakikomiReview {}
    677678
    678679#admin_page_delete_kakikomi p.info { padding: 0;}
  • OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/lib/db_admin.php

    r1998 r2000  
    18071807}
    18081808
     1809function monitor_review_list($keyword,$page_size,$page)
     1810{
     1811
     1812    $page = intval($page);
     1813    $page_size = intval($page_size);
     1814   
     1815    $where = " where 1 ";
     1816
     1817    if ($keyword) {
     1818        //全角空白を半角に統一
     1819        $keyword = str_replace(" ", " ", $keyword);
     1820        $keyword_list = explode(" ", $keyword);
     1821           
     1822        for($i=0;$i < count($keyword_list);$i++) {
     1823            $keyword = check_search_word( $keyword_list[$i] );
     1824               
     1825            $where .= " and c_review_comment.body like ? ";
     1826            $params[]="%$keyword%";
     1827        }
     1828    }
     1829   
     1830    $select = " select c_review_comment.*";
     1831    $from = " FROM c_review_comment";
     1832    $order = " ORDER BY r_datetime desc";
     1833   
     1834    $sql = $select . $from . $where . $order;
     1835    $list = db_get_all_limit($sql,($page-1)*$page_size,$page_size,$params);
     1836   
     1837
     1838    foreach ($list as $key => $value) {
     1839        $list[$key]['c_member'] = db_common_c_member4c_member_id_LIGHT($value['c_member_id']);
     1840        $list[$key]['c_review'] = db_review_list_product_c_review4c_review_id($value['c_review_id']);
     1841    }
     1842
     1843    $sql =
     1844        "SELECT count(*) "
     1845        . $from
     1846        . $where ;
     1847    $total_num = db_get_one($sql,$params);
     1848   
     1849    $total_page_num =  ceil($total_num / $page_size);
     1850    $next = ($page < $total_page_num);
     1851    $prev = ($page > 1);
     1852   
     1853    return array($list , $prev , $next, $total_num,$total_page_num); 
     1854}
     1855
    18091856function _db_count_c_commu_topic_comments4c_commu_topic_id($c_commu_topic_id)
    18101857{
  • OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/page/delete_kakikomi.php

    r1856 r2000  
    3737        }
    3838
     39        if ($requests['target_c_review_id']) {
     40            $v['c_review'] = db_review_list_product_c_review4c_review_id($requests['target_c_review_id']);
     41        }
     42
    3943        $this->set($v);
    4044        return 'success';
  • OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/templates/delete_kakikomi.tpl

    r1477 r2000  
    132132</div>({*/div class="deleteKakikomiCommuTopic"*})
    133133
     134({* レビュー *})
     135<div class="deleteKakikomiReview">
     136
     137<h3>【レビュー】</h3>
     138<dl class="sampleID">
     139<dt>URL例:</dt>
     140<dd>({t_url _absolute=1 m=pc a=page_h_review_list_product})&amp;c_review_id=<strong>***</strong></dd>
     141</dl>
     142<form action="./" method="get">
     143<p>
     144<input type="hidden" name="m" value="({$module_name})" />
     145<input type="hidden" name="a" value="page_({$hash_tbl->hash('delete_kakikomi')})" />
     146<strong class="item">ID</strong>: <input class="basic" type="text" name="target_c_review_id" value="({$requests.target_c_review_id})" size="6" />
     147<span class="textBtnS"><input type="submit" value="確認" /></span>
     148</p>
     149</form>
     150({if $c_review})
     151<table class="diaryDetailTable">
     152        <tr>
     153                <th>タイトル</th>
     154                <td>({$c_review.title}) (<a href="({t_url _absolute=1 m=pc a=page_h_review_list_product})&amp;c_review_id=({$c_review.c_review_id})" target="_blank">この記事を開く</a>)</td>
     155        </tr>
     156        <tr>
     157                <th>説明</th>
     158                <td>({$c_review.release_date})<br>
     159({$c_review.manufacturer})<br>
     160({$c_review.artist})({$c_review.author})<br>
     161</td>
     162        </tr>
     163</table>
     164<form action="./" method="post">
     165<input type="hidden" name="sessid" value="({$PHPSESSID})" />
     166<input type="hidden" name="m" value="({$module_name})" />
     167<input type="hidden" name="a" value="do_({$hash_tbl->hash('delete_kakikomi_c_review','do')})" />
     168<input type="hidden" name="target_c_review_id" value="({$c_review.c_review_id})" />
     169<p class="textBtn"><input type="submit" value="この記事を削除する" /></p>
     170</form>
     171({/if})
     172
     173</div>({*/div class="deleteKakikomiReview"*})
     174
    134175({$inc_footer|smarty:nodefaults})
  • OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/templates/inc_header.tpl

    r1807 r2000  
    6060<li><a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('topic_list')})">トピック・イベント管理</a></li>
    6161<li><a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('topic_comment_list')})">トピック・イベントのコメント管理</a></li>
     62<li><a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('review_list')})">レビュー管理</a></li>
    6263<li><a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('delete_kakikomi')})" title="書き込み管理: 日記、コミュニティ、コミュニティトピックの強制削除">書き込み削除</a></li>
    6364</ul>
  • OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/templates/inc_subnavi_adminImageKakikomi.tpl

    r1260 r2000  
    66<a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('topic_list')})">トピック・イベント管理</a>&nbsp;|&nbsp;
    77<a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('topic_comment_list')})">トピック・イベントのコメント管理</a>&nbsp;|&nbsp;
     8<li><a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('review_list')})">レビュー管理</a></li>&nbsp;|&nbsp;
    89<a href="?m=({$module_name})&amp;a=page_({$hash_tbl->hash('delete_kakikomi')})" title="書き込み管理: 日記、コミュニティ、コミュニティトピックの強制削除">書き込み削除</a>&nbsp;|&nbsp;
    910
  • OpenPNE/branches/ishida/prj_dev28/webapp/modules/admin/validate/page/delete_kakikomi.ini

    r783 r2000  
    1313[target_c_commu_topic_comment_id]
    1414type = "int"
     15
     16[target_c_review_id]
     17type = "int"
Note: See TracChangeset for help on using the changeset viewer.