Changeset 20198
- Timestamp:
- 2011/02/19 14:52:57 (13 years ago)
- Location:
- branches/version-2_5-dev
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/version-2_5-dev/data/Smarty/templates/admin/mail/template.tpl
r20116 r20198 45 45 <!--{section name=data loop=$list_data}--> 46 46 <tr> 47 <td><!--{$list_data[data]. disp_date|date_format:'%Y/%m/%d'|h}--></td>47 <td><!--{$list_data[data].create_date|date_format:'%Y/%m/%d'|h}--></td> 48 48 <td class="left"><!--{$list_data[data].subject|h}--></td> 49 49 <!--{assign var=type value=$list_data[data].mail_method|h}--> -
branches/version-2_5-dev/data/class/helper/SC_Helper_Mail.php
r20160 r20198 328 328 return true; 329 329 } 330 331 /** 332 * 保存されているメールテンプレートの取得 333 * @param array $arrParams 特定IDのテンプレートを取り出したい時は$arrParams['template_id']で指定 334 * @return array メールテンプレート情報を格納した配列 335 * @todo 表示順も引数で変更できるように 336 */ 337 function sfGetMailTemplate($arrParams = array()){ 338 // 初期化 339 $where = ''; 340 $arrValues = array(); 341 $objQuery =& SC_Query::getSingletonInstance(); 342 343 // 条件文 344 $where = 'del_flg = ?'; 345 $arrValues[] = 0; 346 //template_id指定時 347 if (isset($arrParams['template_id'])) { 348 $where .= 'AND template_id = ?'; 349 $arrValues[] = $arrParams['template_id']; 350 } 351 352 // 表示順 353 $objQuery->setOrder("create_date DESC"); 354 355 $arrResults = $objQuery->select('*', 'dtb_mailmaga_template', $where, $arrValues); 356 return $arrResults; 357 } 330 358 } 331 359 ?> -
branches/version-2_5-dev/data/class/pages/admin/mail/LC_Page_Admin_Mail.php
r20128 r20198 318 318 $objSiteInfo = new SC_SiteInfo(); 319 319 $objTemplate->arrInfo = $objSiteInfo->data; 320 // メール担当写真の表示321 $objUpFile = new SC_UploadFile(IMAGE_TEMP_URLPATH, IMAGE_SAVE_URLPATH);322 $objUpFile->addFile("メール担当写真", 'charge_image', array('jpg'), IMAGE_SIZE, true, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);323 $objUpFile->setDBFileList($objTemplate->list_data);324 $objTemplate->arrFile = $objUpFile->getFormFileList(IMAGE_TEMP_URLPATH, IMAGE_SAVE_URLPATH);325 320 $objMakeTemplate = new SC_AdminView(); 326 321 $objMakeTemplate->assignobj($objTemplate); -
branches/version-2_5-dev/data/class/pages/admin/mail/LC_Page_Admin_Mail_Preview.php
r20116 r20198 86 86 $this->list_data = $result[0]; 87 87 88 //メール担当写真の表示89 $objUpFile = new SC_UploadFile(IMAGE_TEMP_URLPATH, IMAGE_SAVE_URLPATH);90 $objUpFile->addFile("メール担当写真", 'charge_image', array('jpg'), IMAGE_SIZE, true, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT);91 $objUpFile->setDBFileList($this->list_data);92 // Form用配列を渡す。93 $this->arrFile = $objUpFile->getFormFileList(IMAGE_TEMP_URLPATH, IMAGE_SAVE_URLPATH);94 95 88 // メイン商品の情報取得 96 89 // FIXME SC_Product クラスを使用した実装 -
branches/version-2_5-dev/data/class/pages/admin/mail/LC_Page_Admin_Mail_Template.php
r20116 r20198 70 70 */ 71 71 function action() { 72 $obj Query = new SC_Query();72 $objMailHelper = new SC_Helper_Mail_Ex(); 73 73 $objSess = new SC_Session(); 74 74 … … 76 76 SC_Utils_Ex::sfIsSuccess($objSess); 77 77 78 if (!isset($_GET['id'])) $_GET['id'] = "";79 80 78 switch ($this->getMode()) { 81 79 case 'delete': 82 80 if ( SC_Utils_Ex::sfCheckNumLength($_GET['id'])===true ){ 83 // メール担当の画像があれば削除しておく 84 $sql = "SELECT charge_image FROM dtb_mailmaga_template WHERE template_id = ?"; 85 $result = $objQuery->getOne($sql, array($_GET["id"])); 86 if (strlen($result) > 0) { 87 @unlink(IMAGE_SAVE_REALDIR. $result); 88 } 89 90 // 登録削除 91 $sql = "UPDATE dtb_mailmaga_template SET del_flg = 1 WHERE template_id = ?"; 92 $objQuery->query($sql, array($_GET['id'])); 93 81 $this->lfDeleteMailTemplate($_GET['id']); 94 82 $this->objDisplay->reload(null, true); 95 83 } … … 98 86 break; 99 87 } 100 101 $sql = "SELECT *, create_date as disp_date FROM dtb_mailmaga_template WHERE del_flg = 0 ORDER BY create_date DESC"; 102 $this->list_data = $objQuery->getAll($sql); 88 $this->list_data = $objMailHelper->sfGetMailTemplate(); 103 89 } 104 90 … … 111 97 parent::destroy(); 112 98 } 99 100 /** 101 * メールテンプレートの削除 102 * @param integer 削除したいテンプレートのID 103 * @return void 104 */ 105 function lfDeleteMailTemplate($template_id){ 106 $objQuery =& SC_Query::getSingletonInstance(); 107 $sqlval["del_flg"] = "1"; 108 $arrValIn[] = $template_id; 109 $objQuery->update("dtb_mailmaga_template", $sqlval, "template_id = ?", $arrValIn); 110 } 111 113 112 } 114 113 ?> -
branches/version-2_5-dev/html/install/sql/column_comment.sql
r20116 r20198 100 100 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (414, 'dtb_order', 'deliv_pref', '都道府県'); 101 101 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (100, 'dtb_mailmaga_template', 'subject', '件名'); 102 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (101, 'dtb_mailmaga_template', 'charge_image', 'メール担当写真');103 102 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (102, 'dtb_mailmaga_template', 'mail_method', '1:テキストメール 2:HTMLメール 3:HTMLTEMPLATE'); 104 103 INSERT INTO dtb_table_comment (id, table_name, column_name, description) VALUES (103, 'dtb_mailmaga_template', 'header', 'ヘッダーテキスト'); -
branches/version-2_5-dev/html/install/sql/create_table_mysql.sql
r20160 r20198 239 239 template_id int NOT NULL, 240 240 subject text, 241 charge_image text,242 241 mail_method int, 243 242 header text, -
branches/version-2_5-dev/html/install/sql/create_table_pgsql.sql
r20160 r20198 239 239 template_id int NOT NULL, 240 240 subject text, 241 charge_image text,242 241 mail_method int, 243 242 header text,
Note: See TracChangeset
for help on using the changeset viewer.