Changeset 6156

Timestamp:

Mar 28, 2008, 5:29:10 PM (13 years ago)

Author:

cybaron

Message:

OpenPNE版アルバム機能作成
アルバムの編集 h_delete_album,h_delete_album_confirm
残：xhtml+css化

Location:

OpenPNE/branches/work/asano/pne_album/webapp

Files:

• lib/db/album.php (modified) (2 diffs)
• modules/pc/do/fh_album_delete_c_album.php (modified) (2 diffs)
• modules/pc/page/h_delete_album.php (modified) (1 diff)
• modules/pc/templates/h_delete_album.tpl (modified) (2 diffs)

OpenPNE/branches/work/asano/pne_album/webapp/lib/db/album.php

@@ -1544 +1544 @@
 
 /**
- * 日記削除
- * コメント、画像も削除
- * 
+ * アルバムの削除
+ * 画像も削除
  * @param int $c_album_id
  */
 function db_album_delete_c_album($c_album_id)
 {
-     //function cacheの削除
-    $c_album = db_album_get_c_album4id($c_album_id);
-    pne_cache_drop('db_album_get_c_album_list4c_member_id', $c_album['c_member_id'], 5);
-
-   // 画像
-   foreach($c_album as $key=>$value){
-    image_data_delete($c_album[$key]['image_filename']);
-   }
+    //function cacheの削除
+        $c_album_image = db_album_get_c_album4id($c_album_id);
+    pne_cache_drop('db_album_get_c_album_list4c_member_id', $c_album_image['c_member_id'], 5);
+
+   // アルバムに登録された画像
+        foreach($c_album_image as $key=>$value){
+                //image_data_delete($c_album[$key]['image_filename']);
+                db_album_image_data_delete($c_album_image[$key]['image_filename']);
+        }
+
+        // アルバムの表紙
+        $c_album = db_album_get_c_album4c_album_id($c_album_id);
+        if($c_album['album_cover_image']){
+                db_album_image_data_delete($c_album['album_cover_image']);
+        }
+
     // コメント
+    /*
     $sql = 'SELECT image_filename_1, image_filename_2, image_filename_3 FROM c_album_comment WHERE c_album_id =?';
     $params = array(intval($c_album_id));
     $comment_images = db_get_all($sql, $params);
+    */
 
     //カテゴリ
+    /*
     db_album_category_delete_c_album_category_album($c_album_id);
 
@@ -1572 +1582 @@
         image_data_delete($value['image_filename_3']);
     }
-    
+    */
+    $params = array(intval($c_album_id));
+    
+    //アルバムと画像の関連
     $sql = 'DELETE FROM c_album_image WHERE c_album_id = ?';
     db_query($sql, $params);
 
+    // アルバム
+    $sql = 'DELETE FROM c_album WHERE c_album_id = ?';
+    db_query($sql, $params);
+
+        return;
+
+    /*
     $sql = 'DELETE FROM c_album_comment WHERE c_album_id = ?';
     db_query($sql, $params);
-
-    // 日記
-    $sql = 'DELETE FROM c_album WHERE c_album_id = ?';
-    db_query($sql, $params);
+    */
 }
 

OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/do/fh_album_delete_c_album.php

@@ -6 +6 @@
 
 /**
- * 日記削除
+ * アルバム削除
  */
 class pc_do_fh_album_delete_c_album extends OpenPNE_Action
@@ -19 +19 @@
 
         //--- 権限チェック
-        //日記作成者
-
         $c_album = db_album_get_c_album_row4id($target_c_album_id);
         if ($c_album['c_member_id'] != $u) {

OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/page/h_delete_album.php

@@ -15 +15 @@
         
         $this->set('inc_navi', fetch_inc_navi('h'));
-        $this->set("target_c_album", db_album_get_c_album_row4id($target_c_album_id));
+        $this->set('target_c_album_id', $target_c_album_id);
+        
+        //$this->set("target_c_album", db_album_get_c_album_row4id($target_c_album_id));
 
         return 'success';

OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/templates/h_delete_album.tpl

@@ -1 @@
-({ext_include file="inc_header.tpl"})
-({ext_include file="inc_layoutcolumn_top_720px.tpl"})
+<div id="LayoutC">
+<div id="Center">
 
+({* {{{ yesNoButtonBox *})
+<div class="dparts yesNoButtonBox"><div class="parts">
+<div class="partsHeading"><h3>本当に削除しますか？</h3></div>
+
+<div class="block">
+<ul class="moreInfo button">
+<li>
+({t_form_block m=pc a=do_fh_album_delete_c_album})
+<input type="hidden" name="target_c_album_id" value="({$target_c_album_id})" />
+<input type="submit" class="input_submit" value=" は い " />
+({/t_form_block})
+</li><li>
+({t_form_block m=pc a=page_h_album_cover_edit})
+<input type="hidden" name="target_c_album_id" value="({$target_c_album_id})" />
+<input type="submit" class="input_submit" value="いいえ" />
+({/t_form_block})
+</li>
+</ul>
+</div>
+
+</div></div>
+({* }}} *})
+
+</div><!-- Center -->
+</div><!-- LayoutC -->
+
+
+({************************
 <img src="./skin/dummy.gif" class="v_spacer_l">
 
@@ -55 +83 @@
 
 <img src="./skin/dummy.gif" class="v_spacer_l">
-
-<!-- delete by openkaku team on 080313
-({ext_include file="inc_layoutcolumn_middle_750px.tpl"})
--->
-({ext_include file="inc_layoutcolumn_bottom_270px_165px_175px_720px.tpl"})
-({ext_include file="inc_footer.tpl"})
+***********************})