Changeset 6198
- Timestamp:
- Mar 31, 2008, 3:30:32 PM (13 years ago)
- Location:
- OpenPNE/branches/work/asano/pne_album/webapp
- Files:
-
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/branches/work/asano/pne_album/webapp/lib/db/album.php
r6156 r6198 84 84 * @return array 85 85 */ 86 /* 86 87 function db_album_list4c_album_category_id($c_member_id, $c_album_category_id, $u = null, $page_size, $page) 87 88 { … … 124 125 return array($list, $prev, $next,$total_num); 125 126 } 126 127 */ 127 128 function db_check_c_album_image_exist($c_album_id){ 128 129 $sql = 'SELECT c_album_id FROM c_album_image WHERE c_album_id = ?'; … … 138 139 * @param int $category_name 139 140 */ 141 /* 140 142 function db_album_category_insert_category($c_member_id, $category_name) 141 143 { … … 147 149 return db_insert('c_album_category', $data); 148 150 } 149 151 */ 150 152 /** 151 153 * カテゴリを削除する … … 153 155 * @param int $c_album_category_id 154 156 */ 157 /* 155 158 function db_album_category_delete_category($c_album_category_id) 156 159 { … … 158 161 db_query($sql, array($c_album_category_id)); 159 162 } 163 */ 160 164 /** 161 165 * カテゴリと日記を関連づける … … 164 168 * @param int $c_album_category_id 165 169 */ 170 /* 166 171 function db_album_category_insert_c_album_category_album($c_album_id, $c_album_category_id) 167 172 { … … 172 177 db_insert('c_album_category_album', $data); 173 178 } 179 */ 174 180 175 181 /** 176 182 * カテゴリと日記の関連づけを削除する 177 183 */ 184 /* 178 185 function db_album_category_delete_c_album_category_album($c_album_id) 179 186 { … … 193 200 } 194 201 } 195 202 */ 196 203 /** 197 204 * db_album_public_flag_condition … … 231 238 function db_album_get_c_album4c_album_id($c_album_id) 232 239 { 233 $tmp1_sql = 'SELECT c_album_category_id FROM c_album_category_album WHERE c_album_id = ?'; 234 $sql = 'SELECT * FROM c_album WHERE c_album_id = ?'; 235 $params = array(intval($c_album_id)); 236 $category_id = db_get_one($tmp1_sql, $params); 237 $tmp2_sql = 'SELECT category_name FROM c_album_category WHERE c_album_category_id = ?'; 238 $tmp_params = array(intval($category_id)); 239 $category_name = db_get_one($tmp2_sql, $tmp_params); 240 //$tmp1_sql = 'SELECT c_album_category_id FROM c_album_category_album WHERE c_album_id = ?'; 241 //$params = array(intval($c_album_id)); 242 //$category_id = db_get_one($tmp1_sql, $params); 243 244 //$tmp2_sql = 'SELECT category_name FROM c_album_category WHERE c_album_category_id = ?'; 245 //$tmp_params = array(intval($category_id)); 246 //$category_name = db_get_one($tmp2_sql, $tmp_params); 247 248 $sql = 'SELECT * FROM c_album WHERE c_album_id = ?'; 249 $params = array(intval($c_album_id)); 250 240 251 $album = db_get_row($sql, $params); 241 $album['category'] = $category_name; 252 //$album['category'] = $category_name; 253 242 254 return $album; 243 255 } … … 267 279 { 268 280 $sql = 'SELECT a.*,b.c_album_image_id,b.image_filename'. 269 270 281 ' FROM c_album AS a,c_album_image AS b'. 282 ' WHERE a.c_album_id = '.intval($c_album_id).' AND'.' b.c_album_id = '.intval($c_album_id); 271 283 272 284 return db_get_all($sql, array()); … … 280 292 } 281 293 294 /** 295 * アルバム画像を取得 296 * @param int $c_album_image_id 297 */ 282 298 function db_album_image_get_c_album_image4id($c_album_image_id) 283 299 { 284 300 $sql = 'SELECT * FROM c_album_image WHERE c_album_image_id = ?'; 285 301 $params = array(intval($c_album_image_id)); 286 return db_get_row($sql,$params); 287 } 288 302 303 return db_get_row($sql,$params); 304 } 305 306 /** 307 * アルバムに登録されている画像リストを取得 308 * @param int $c_album_id 309 */ 289 310 function db_get_c_album_image_list4c_album_id($c_album_id) 290 311 { 291 312 $sql = 'SELECT * FROM c_album_image WHERE c_album_id = ?'; 292 313 $params = array(intval($c_album_id)); 314 293 315 return db_get_all($sql,$params); 294 316 } 295 317 318 //kazuki db_album_image_get_c_album_image4id()で代用可能 319 /* 296 320 function db_c_album_get_image_description4image_id($c_album_image_id) 297 321 { … … 301 325 return db_get_one($sql,$params); 302 326 } 303 327 */ 304 328 305 329 /** 306 330 * アルバムIDからアルバムに登録された画像を取得 307 *308 331 * @param int $c_album_id 309 332 * @return array … … 468 491 * @return 日記コメント(+ニックネーム)リスト 469 492 */ 493 /* 470 494 function db_album_get_c_album_comment_list4id_list($id_list, $page = 1, $page_size= -1, $desc = false) 471 495 { … … 516 540 return array($c_album_comment_list, $prev , $next, $total_num); 517 541 } 542 */ 518 543 519 544 /** … … 523 548 * @return int コメント数 524 549 */ 550 /* 525 551 function db_album_count_c_album_comment4c_album_id($c_album_id) 526 552 { … … 528 554 return db_get_one($sql, array(intval($c_album_id))); 529 555 } 530 556 */ 531 557 //// 532 558 … … 738 764 } 739 765 766 /* 740 767 function db_common_album_monthly_calendar($year, $month, $c_member_id, $u = null) 741 768 { … … 792 819 return $calendar; 793 820 } 794 821 */ 795 822 function count_members(){ 796 823 $sql = 'select max(c_member_id) from c_album'; … … 934 961 * @return array_of_array (c_album.*, nickname) 935 962 */ 963 /* 936 964 function p_h_home_c_album_my_comment_list4c_member_id($c_member_id, $limit) 937 965 { … … 986 1014 return $result; 987 1015 } 1016 */ 988 1017 989 1018 function p_h_album_comment_list_c_album_my_comment_list4c_member_id($c_member_id, $page, $page_size) -
OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/page/h_album_edit.php
r6192 r6198 5 5 */ 6 6 7 class pc_page_h_album_ edit extends OpenPNE_Action7 class pc_page_h_album_image_edit extends OpenPNE_Action 8 8 { 9 9 function execute($requests) … … 13 13 // --- リクエスト変数 14 14 $target_c_album_id = $requests['target_c_album_id']; 15 $ subject = $requests['subject'];16 $ description = $requests['description'];17 $public_flag = $requests['public_flag'];18 $category = $requests['category'];19 15 $target_c_album_image_id = $requests['target_c_album_image_id']; 16 $image_description = $requests['image_description']; 17 //$subject = $requests['subject']; 18 //$public_flag = $requests['public_flag']; 19 //$category = $requests['category']; 20 20 // ---------- 21 21 22 23 // target が指定されていない 24 if (!$target_c_album_image_id) { 25 openpne_redirect('pc', 'page_h_err_fh_album'); 26 } 27 28 //アルバムデータ取得 29 $c_album = db_album_get_c_album4c_album_id($target_c_album_id); 30 //--- 権限チェック 31 if ($u != $c_album['c_member_id']) { 32 handle_kengen_error(); 33 } 34 35 // アルバムの画像データ取得 36 $c_album_iamge = db_album_image_get_c_album_image4id($target_c_album_image_id); 37 38 // target の画像が存在しない 39 //if (!p_common_is_active_c_album_id($target_c_album_id) && $target_c_album_id != null) { 40 if(!$c_album_iamge){ 41 openpne_redirect('pc', 'page_h_err_fh_album'); 42 } 43 44 $this->set('inc_navi', fetch_inc_navi('h')); 45 $this->set('c_album_image', $c_album_iamge); 46 $this->set('target_c_album_image_id', $target_c_album_image_id); 47 48 return 'success'; 49 50 //登録されている写真を削除 0は削除しない 1は削除する 51 /* 52 if ($_REQUEST['del_img'] & 0x01 == 1) $c_album['image_filename_1'] = ""; 53 if ($_REQUEST['del_img'] & 0x02 == 1) $c_album['image_filename_2'] = ""; 54 if ($_REQUEST['del_img'] & 0x04 == 1) $c_album['image_filename_3'] = ""; 55 $this->set('del_img', $_REQUEST['del_img']); 56 */ 57 58 /* 22 59 $c_album = db_album_get_c_album4id($target_c_album_id); 23 60 foreach($c_album as $key => $value) 24 61 { 25 62 $c_album[$key]['image_description'] = db_c_album_get_image_description4image_id($value['c_album_image_id']); 26 63 } 27 28 64 */ 65 /* 29 66 if (!(is_null($subject) || is_null($description))) { 30 67 $c_album['subject'] = $subject; 31 68 $c_album['description'] = $description; 32 69 } 33 34 // target が指定されていない 35 // 新規作成 36 if (!$target_c_album_id) { 37 openpne_redirect('pc', 'page_h_album_add'); 38 } 39 40 // target の日記が存在しない 41 if (!p_common_is_active_c_album_id($target_c_album_id) && $target_c_album_id != null) { 42 openpne_redirect('pc', 'page_h_err_fh_album'); 43 } 44 45 //--- 権限チェック 46 //日記の作成者 47 if ($u != $c_album[0]['c_member_id']) { 48 handle_kengen_error(); 49 } 50 51 52 //登録されている写真を削除 0は削除しない 1は削除する 53 if ($_REQUEST['del_img'] & 0x01 == 1) $c_album['image_filename_1'] = ""; 54 if ($_REQUEST['del_img'] & 0x02 == 1) $c_album['image_filename_2'] = ""; 55 if ($_REQUEST['del_img'] & 0x04 == 1) $c_album['image_filename_3'] = ""; 56 $this->set('del_img', $_REQUEST['del_img']); 57 58 $this->set('inc_navi', fetch_inc_navi('h')); 70 */ 59 71 60 72 //プロフィール 73 /* 61 74 $this->set("target_member", db_member_c_member4c_member_id($u)); 62 75 $this->set("album", $c_album); 63 76 $this->set('album_cover',$c_album[0]); 64 77 */ 78 65 79 //カレンダー関係 66 80 //カレンダー開始用変数 81 /* 67 82 $time = strtotime($c_album['r_datetime']); 68 83 $year = date('Y', $time); … … 107 122 //print_r ($c_album); 108 123 //print "</pre>"; 109 return 'success';124 */ 110 125 } 111 126 } -
OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/templates/fh_album.tpl
r6191 r6198 167 167 <img src="./skin/dummy.gif" class="v_spacer_m"> 168 168 <div><img src="./skin/dummy.gif" class="v_spacer_m">({$album_item.dual.image_description})<img src="./skin/dummy.gif" class="v_spacer_m"></div> 169 <a href="({t_url m=pc a=page_h_album_image_edit})&target_c_album_id=({$album_item.dual.c_album_id})&target_c_album_image_id=({$album_item.dual.c_album_image_id})">写真を編集</a> 169 170 ({/if}) 170 171 </td> … … 184 185 <img src="./skin/dummy.gif" class="v_spacer_m"> 185 186 <div><img src="./skin/dummy.gif" class="v_spacer_m">({$album_item.singular.image_description})<img src="./skin/dummy.gif" class="v_spacer_m"></div> 187 <a href="({t_url m=pc a=page_h_album_image_edit})&target_c_album_id=({$album_item.singular.c_album_id})&target_c_album_image_id=({$album_item.singular.c_album_image_id})">写真を編集</a> 186 188 ({/if}) 187 189 </td> -
OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/templates/h_album_edit.tpl
r6192 r6198 1 2 <div id="LayoutC"> 3 <div id="Center"> 4 5 <div class="dparts formTable"><div class="parts"> 6 <div class="partsHeading"><h3>写真を編集する</h3></div> 7 ({t_form_block _enctype=file m=pc a=page_h_album_image_edit_confirm}) 8 <input type="hidden" name="target_c_album_image_id" value="({$target_c_album_image_id})" /> 9 <table> 10 <tr> 11 <th>画像</th> 12 <td> 13 <a href="({t_img_album_url filename=$c_album_image.image_filename})" target="_blank"> 14 <img src="({t_img_album_url filename=$c_album_image.image_filename w=180 h=180})"></a><br> 15 <input type="hidden" name="pre_image_filename" value="({$c_album_image.image_filename})" /> 16 <input type="file" class="input_file" name="upfile_1" size="40" /> 17 </td> 18 </tr> 19 <tr> 20 <th>写真説明</th> 21 <td> 22 <input type="text" class="input_text" name="image_description" value="({$c_album_image.image_description})" size="50" /> 23 </td> 24 </tr> 25 </table> 26 <div class="operation"> 27 <ul class="moreInfo button"> 28 <li><input type="submit" class="input_submit" value="確認画面" /></li> 29 </ul> 30 </div> 31 ({/t_form_block}) 32 </div> <!-- parts --> 33 </div> <!-- dparts formTable --> 34 35 36 37 <div class="dparts formTable"><div class="parts"> 38 <div class="partsHeading"><h3>画像を削除する</h3></div> 39 ({t_form_block m=pc a=page_h_image_delete_confirm}) 40 <input type="hidden" name="target_c_album_image_id" value="({$target_c_album_image_id})" /> 41 <div class="operation"> 42 <ul class="moreInfo button"> 43 <li><input type="submit" class="input_submit" value=" 削 除 " /></li> 44 </ul> 45 </div> 46 ({/t_form_block}) 47 </div></div> 48 49 50 </div><!-- Center --> 51 </div><!-- LayoutC --> 52 53 ({************************* 1 54 ({ext_include file="inc_header.tpl"}) 2 55 ({ext_include file="inc_layoutcolumn_top_165px.tpl"}) … … 263 316 ({ext_include file="inc_layoutcolumn_bottom_270px_165px_175px_720px.tpl"}) 264 317 ({ext_include file="inc_footer.tpl"}) 318 *************************}) -
OpenPNE/branches/work/asano/pne_album/webapp/modules/pc/validate/page/h_album_edit.ini
r6192 r6198 4 4 min = 1 5 5 6 [subject] 6 [target_c_album_image_id] 7 type = "int" 8 required = 0 9 min = 1 10 11 [image_description] 7 12 type = "string" 8 13 required = 0 9 caption = CAPTION_TITLE10 14 11 [description]12 type = "string"13 required = 014 caption = CAPTION_BODY15 15 16 [public_flag]17 type = "string"18 required = 019 caption = CAPTION_OPEN_RANGE20 21 [category]22 type = "string"23 default = ""
Note: See TracChangeset
for help on using the changeset viewer.