１.テーブル新規
CREATE TABLE product_art_extra (
products_id int(11) NOT NULL default ’0′,
size varchar(32) default NULL,
frame_h int(11) default NULL,
frame_w int(11) default NULL,
frame_d int(11) default NULL,
window_h int(11) default NULL,
window_w int(11) default NULL,
window_d int(11) default NULL,
accessories varchar(96) default NULL,
PRIMARY KEY (products_id)
) TYPE=MyISAM;
2.追加SQL
INSERT INTO product_type_layout
(configuration_title, configuration_key, configuration_value,
configuration_description, product_type_id, sort_order,
set_function, date_added)
VALUES (‘附帯品表示’, ‘SHOW_PRODUCT_ART_INFO_ACCESSORIES’, ’1′,
‘附帯品を表示する 0=表示しない 1=表示する’, ’6′, ’3′,
‘zen_cfg_select_drop_down(array(array(¥’id¥’=>¥’1¥’, ¥’text¥’=>¥’True¥’), array(¥’id¥’=>¥’0¥’, ¥’text¥’=>¥’False¥’)), ‘, now());
3. admin/includes/extra_datafiles/art_type_database_names.phpを新規追加。
define(‘TABLE_PRODUCT_ART_EXTRA’, DB_PREFIX . ‘product_art_extra’);
4.includes/extra_datafiles/art_type_database_names.phpを新規追加。
define(‘TABLE_PRODUCT_ART_EXTRA’, DB_PREFIX . ‘product_art_extra’);
5.admin/includes/modules/product_artのcollect_info.php
データ取得
$art = $db->Execute(“select size, frame_h, frame_w, frame_d, window_h, window_w, window_d, accessories
from ” . TABLE_PRODUCT_ART_EXTRA .
” where products_id = ‘” . (int)$_GET['pID']. “‘”);
と、表示部分
以下省略
6.admin/includes/modules/update_product.phpをコピー。
admin/includes/modules/product_art/update_product.phpとする。
update_product.phpのこんな風に書いてある箇所に、
///////////////////////////////////////////////////////
//// INSERT PRODUCT-TYPE-SPECIFIC *INSERTS* HERE //////
//// *END OF PRODUCT-TYPE-SPECIFIC INSERTS* ////////
///////////////////////////////////////////////////////
$sql_data_array = array(‘products_id’ => $products_id,
‘accessories’ => zen_db_prepare_input($_POST['accessories']),
‘size’ => zen_db_prepare_input($_POST['size']) );
zen_db_perform(TABLE_PRODUCT_ART_EXTRA, $sql_data_array);
を入れる。
次に、
///////////////////////////////////////////////////////
//// INSERT PRODUCT-TYPE-SPECIFIC *UPDATES* HERE //////
//// *END OF PRODUCT-TYPE-SPECIFIC UPDATES* ////////
///////////////////////////////////////////////////////
の間に、
$sql_data_array = array(‘accessories’ => zen_db_prepare_input($_POST['accessories']),
‘size’ => zen_db_prepare_input($_POST['size']));
zen_db_perform(TABLE_PRODUCT_BOOK_EXTRA,
$sql_data_array,
‘update’,
“products_id = ‘” . (int)$products_id . “‘”);
を入れる。
7.admin/includes/modules/product_art/delete_product_confirm.php を
/public_html/admin/includes/modules/product_art配下にコピー。
PRODUCT_TYPE_SPECIFIC_INSTRUCTIONS_GO__BELOW_HEREの部分に以下を追加。
$db->Execute(“delete from ” . TABLE_PRODUCT_ART_EXTRA . “
where products_id = ‘” . (int)$product_id . “‘”);
8./public_html/admin/includes/modules/copy_to_confirm.phpを
/public_html/admin/includes/modules/product_art配下にコピー。
$dup_products_id = $db->Insert_ID();の下に
$book_extra = $db->Execute(“select authers, size, publish_date from ” .
TABLE_PRODUCT_BOOK_EXTRA .
” where products_id = ‘” .
(int)$products_id . “‘”);
$db->Execute(“insert into ” . TABLE_PRODUCT_BOOK_EXTRA . “
(products_id, authers, size, publish_date)
values (
‘” . (int)$dup_products_id . “‘,
‘” . zen_db_input($book_extra->fields['authers']) . “‘,
‘” . zen_db_input($book_extra->fields['size']) . “‘,
‘” . zen_db_input($book_extra->fields['publish_date']) . “‘)”);
と追加。
9.admin/product_art.phpに追加
10. includes/modules/pages/product_art_info/main_template_vars.phpに
$sql = “select * from ” . TABLE_PRODUCT_ART_EXTRA . “
where products_id = ‘” . (int)$_GET['products_id'] . “‘”;
$art_extras = $db->Execute($sql);
$art_accessories = $art_extras->fields['accessories'];
$art_size = $art_extras->fields['size'];
$art_frame_h = $art_extras->fields['frame_h'];
$art_frame_w = $art_extras->fields['frame_w'];
$art_frame_d = $art_extras->fields['frame_d'];
$art_window_h = $art_extras->fields['window_h'];
$art_window_w = $art_extras->fields['window_w'];
$art_window_d = $art_extras->fields['window_d'];
を追加。
$flag_show_art_product_info_accessories =
zen_get_show_product_switch($_GET['products_id'], ‘accessories’);
$flag_show_art_product_info_size =
zen_get_show_product_switch($_GET['products_id'], ‘size’);
$flag_show_art_product_info_frame_h =
zen_get_show_product_switch($_GET['products_id'], ‘frame_h’);
$flag_show_art_product_info_frame_w =
zen_get_show_product_switch($_GET['products_id'], ‘frame_w’);
$flag_show_art_product_info_frame_d =
zen_get_show_product_switch($_GET['products_id'], ‘frame_d’);
$flag_show_art_product_info_window_h =
zen_get_show_product_switch($_GET['products_id'], ‘window_h’);
$flag_show_art_product_info_window_w =
zen_get_show_product_switch($_GET['products_id'], ‘window_w’);
$flag_show_art_product_info_window_d =
zen_get_show_product_switch($_GET['products_id'], ‘window_d’);
を追加。
12.includes/languages/japanese/product_art_info.php
に追加。
define(‘TEXT_PRODUCT_ACCESSORIES’, ‘附帯品: ‘);
define(‘TEXT_PRODUCT_SIZE’, ‘サイズ: ‘);
define(‘TEXT_PRODUCT_FRAME’, ‘額寸（縦×横×厚み）: ‘);
define(‘TEXT_PRODUCT_WINDOW’, ‘窓寸（縦×横）: ‘);
13./public_html/includes/templates/template/templates/tpl_product_art_info_display.phpに追加。
‘ . TEXT_PRODUCT_SIZE . $art_size . ‘
‘ : ”) . “¥n”; ?>
‘ . TEXT_PRODUCT_FRAME . $art_frame_h . ‘×’. $art_frame_w . ‘×’. $art_frame_d .’cm
‘ : ”) . “¥n”; ?>
‘ . TEXT_PRODUCT_WINDOW . $art_window_h . ‘×’. $art_window_w .’cm
‘ : ”) . “¥n”; ?>
odel == 1 and $products_model !='') ? '
‘ : ”) . “¥n”; ?>
‘ . TEXT_PRODUCT_ACCESSORIES . $art_accessories . ‘
‘ : ”) . “¥n”; ?>
ほわわ。。。大変。
