function install(array $arrPlugin, SC_Plugin_Installer $installer)
{
$plugin_dir = dirname(__FILE__) . DIRECTORY_SEPARATOR;
$upload_plugin_dir = PLUGIN_UPLOAD_REALDIR . $arrPlugin["plugin_code"] . DIRECTORY_SEPARATOR;
$backup_plugin_dir = PLUGIN_UPLOAD_REALDIR . $arrPlugin["plugin_code"] . "_" . date("Ymd") . DIRECTORY_SEPARATOR;
if (!is_dir($backup_plugin_dir)) {
SC_Utils_Ex::sfCopyDir($upload_plugin_dir, $backup_plugin_dir);
}
SC_Helper_FileManager_Ex::deleteFile($upload_plugin_dir, false);
SC_Utils_Ex::sfCopyDir($plugin_dir . "/", $upload_plugin_dir);
SC_Utils_Ex::sfCopyDir($plugin_dir . "/copy/Smarty/templates/admin/", TEMPLATE_ADMIN_REALDIR);
SC_Utils_Ex::sfCopyDir($plugin_dir . "/copy/modules/", DATA_REALDIR . "module/");
// logo コピー
$installer->copyDirectory("copy/plugin_dir/", "");
$table = "dtb_products";
$fields = array('auto_display_status' => $this->intColumn('自動公開'), 'auto_display_start_date' => $this->timestampColumn('公開開始日'), 'auto_display_end_date' => $this->timestampColumn('公開終了日'));
$type = "timestamp";
$definition = compact("type");
foreach ($fields as $name => $define) {
$this->objDb->sfColumnExists($table, $name, $define["type"], "", true);
$this->fieldComment($installer, $table, $name, $define["comment"]);
switch ($define["type"]) {
case "timestamp":
break;
default:
continue;
}
$change = array();
$change[$name] = compact('definition');
$this->objManager->alterTable($table, compact("change"), false);
}
$this->objQuery->update("dtb_products", array(), "auto_display_start_date IS NULL", array(), array("auto_display_start_date" => "create_date"));
$masterfields = array("id" => $this->intColumn("ID"), "name" => $this->textColumn("NAME"), "rank" => $this->intColumn("RANK"));
$table = "atd_mtb_auto_display_status";
if ($this->objDb->sfColumnExists($table, "id") == false) {
$this->objManager->createTable($table, $masterfields);
}
foreach ($masterfields as $name => $define) {
$this->objDb->sfColumnExists($table, $name, $define["type"], "", true);
$this->fieldComment($installer, $table, $name, $define["comment"]);
}
$this->masterdata->deleteMasterData($table);
$this->masterdata->clearCache($table);
$this->masterdata->registMasterData($table, array(), explode(",", "常時公開,時限公開"));
// $this->insertMasterData ( "PRODUCTS_RESULT_ROWSPAN", 1, '管理画面/商品管理一覧 行結合数' );
// $this->insertMasterData ( "PRODUCTS_RESULT_COLUMN", 5, '管理画面/商品管理一覧 列位置' );
// $this->insertMasterData ( "PRODUCTS_SEARCH_AUTO_DISPLAY", 1, '検索画面表示設定(1: ON/ 0:OFF)' );
// $this->insertMasterData ( "PRODUCTS_DETAIL_AUTO_DISPLAY", 1, '検索画面表示設定(1: ON/ 0:OFF)' );
}
/**
* メーカー商品数数の登録を行う.
*
* @param SC_Query $objQuery SC_Query インスタンス
* @return void
*/
function sfCountMaker($objQuery)
{
if (DB_TYPE != 'sqlsrv') {
parent::sfCountMaker($objQuery);
} else {
/* TODO SQL Azure で INSERT INTO SELECT をサポートしていないため未対応 */
}
}
/**
* Page のプロセス.
*
* @return void
*/
function process($mode)
{
$objLog = new LC_Upgrade_Helper_LOG();
$objJson = new LC_Upgrade_Helper_Json();
$objLog->start($mode);
if ($this->isValidIP() !== true) {
$objJson->setError(OSTORE_E_C_INVALID_ACCESS);
$objJson->display();
$objLog->error(OSTORE_E_C_INVALID_ACCESS);
return;
}
$objDB = new SC_Helper_DB();
$arrSystemInfo = array('eccube_version' => ECCUBE_VERSION, 'php_version' => phpversion(), 'db_version' => $objDB->sfGetDBVersion());
$objJson->setSuccess($arrSystemInfo);
$objJson->display();
$objLog->end();
}
public function testGetDetailAndProductsClass_商品規格IDの商品情報と規格情報を返す()
{
$this->setUpProductClass();
$this->setUpProducts();
$this->setUpClassCategory();
//更新日を取得
$arrRet = $this->objQuery->getCol('update_date', 'dtb_products', 'product_id = 1001');
$this->expected = array('product_id' => '1001', 'product_code_min' => 'code1001', 'product_code_max' => 'code1001', 'name' => '製品名1001', 'comment1' => 'コメント10011', 'comment2' => 'コメント10012', 'comment3' => 'コメント10013', 'main_list_comment' => 'リストコメント1001', 'main_image' => '1001.jpg', 'main_list_image' => '1001-main.jpg', 'price01_min' => '1500', 'price01_max' => '1500', 'price02_min' => '1500', 'price02_max' => '1500', 'stock_min' => '99', 'stock_max' => '99', 'stock_unlimited_min' => '0', 'stock_unlimited_max' => '0', 'deliv_date_id' => '1', 'status' => '1', 'del_flg' => '0', 'update_date' => $arrRet[0], 'price01_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price01_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'maker_id' => null, 'comment4' => null, 'comment5' => null, 'comment6' => null, 'note' => null, 'main_comment' => 'メインコメント1001', 'main_large_image' => null, 'sub_title1' => null, 'sub_comment1' => null, 'sub_image1' => null, 'sub_large_image1' => null, 'sub_title2' => null, 'sub_comment2' => null, 'sub_image2' => null, 'sub_large_image2' => null, 'sub_title3' => null, 'sub_comment3' => null, 'sub_image3' => null, 'sub_large_image3' => null, 'sub_title4' => null, 'sub_comment4' => null, 'sub_image4' => null, 'sub_large_image4' => null, 'sub_title5' => null, 'sub_comment5' => null, 'sub_image5' => null, 'sub_large_image5' => null, 'sub_title6' => null, 'sub_comment6' => null, 'sub_image6' => null, 'sub_large_image6' => null, 'creator_id' => '1', 'create_date' => $arrRet[0], 'point_rate' => '0', 'deliv_fee' => null, 'class_count' => '1', 'maker_name' => null, 'stock' => '99', 'stock_unlimited' => '0', 'sale_limit' => null, 'price01' => '1500', 'price02' => '1500', 'product_code' => 'code1001', 'product_class_id' => '1001', 'product_type_id' => '1', 'down_filename' => null, 'down_realfilename' => null, 'classcategory_name1' => 'cat1001', 'rank1' => null, 'class_name1' => '味', 'class_id1' => '1', 'classcategory_id1' => '1001', 'classcategory_id2' => '1002', 'classcategory_name2' => 'cat1002', 'rank2' => null, 'class_name2' => '味', 'class_id2' => '1');
$this->actual = $this->objProducts->getDetailAndProductsClass('1001');
$this->verify('商品詳細＋規格');
}
public function testGetListByProductIds_指定の商品IDで情報を取得する()
{
$this->setUpProductClass();
$this->setUpProducts();
$this->setUpClassCategory();
$arrProductId = array('1001');
//更新日を取得
$arrRet = $this->objQuery->getCol('update_date', 'dtb_products', 'product_id = 1001');
$this->expected = array('1001' => array('product_id' => '1001', 'product_code_min' => 'code1001', 'product_code_max' => 'code1001', 'name' => '製品名1001', 'comment1' => 'コメント10011', 'comment2' => 'コメント10012', 'comment3' => 'コメント10013', 'main_list_comment' => 'リストコメント1001', 'main_image' => '1001.jpg', 'main_list_image' => '1001-main.jpg', 'price01_min' => '1500', 'price01_max' => '1500', 'price02_min' => '1500', 'price02_max' => '1500', 'stock_min' => '99', 'stock_max' => '99', 'stock_unlimited_min' => '0', 'stock_unlimited_max' => '0', 'deliv_date_id' => '1', 'status' => '1', 'del_flg' => '0', 'update_date' => $arrRet[0], 'price01_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price01_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_min_inctax' => SC_Helper_DB::sfCalcIncTax('1500'), 'price02_max_inctax' => SC_Helper_DB::sfCalcIncTax('1500')));
$this->actual = $this->objProducts->getListByProductIds($this->objQuery, $arrProductId);
$this->verify('商品ID指定');
}
/**
* 商品情報の配列に税込金額を設定する
*
* @param array $arrProducts 商品情報の配列
* @return void
*/
static function setIncTaxToProduct(&$arrProduct)
{
$arrProduct['price01_min_inctax'] = isset($arrProduct['price01_min']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price01_min']) : null;
$arrProduct['price01_max_inctax'] = isset($arrProduct['price01_max']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price01_max']) : null;
$arrProduct['price02_min_inctax'] = isset($arrProduct['price02_min']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price02_min']) : null;
$arrProduct['price02_max_inctax'] = isset($arrProduct['price02_max']) ? SC_Helper_DB::sfCalcIncTax($arrProduct['price02_max']) : null;
}
public function __construct($array, $mode = '')
{
$pmode = $mode;
if ($mode == "delete_in_customer") {
$pmode = "customer";
}
parent::__construct($array, $pmode);
if ($mode == "delete_in_customer") {
strpos($this->where, ' del_flg = 0 ');
// 先頭の del_flg = 0 を全ての条件に変える
$this->where = preg_replace('/^ del_flg = 0 /', ' del_flg IS NOT NULL ', $this->where);
}
$objDb = new SC_Helper_DB_Ex();
// query 構築用
$objQuery = SC_Query_Ex::getSingletonInstance();
GC_Utils_Ex::gfPrintLog(print_r($this->arrSql, true), DB_LOG_REALFILE);
$having = "";
if (count($this->arrSql["search_status"]) == 1) {
switch ($this->arrSql["search_status"][0]) {
case 1:
$having = "MIN(del_flg) = 1";
break;
case 2:
$having = "MIN(del_flg) = 0";
break;
}
}
$dt = "cp_dtb_customer_docomo_mymenu";
$at = "cp_dtb_customer_transaction";
$d = $objDb->sfColumnExists($dt, "customer_id");
$a = $objDb->sfColumnExists($at, "customer_id");
$objQuery->setGroupBy("customer_id");
if ($having) {
$objQuery->setOption("HAVING {$having}");
}
$where = PHP_EOL;
$where .= "CASE " . PHP_EOL;
$where .= " WHEN 1 = 0 THEN FALSE " . PHP_EOL;
// 自動構築時に特定条件で使えなくなることを防ぐ
if ($d) {
$sub_where = " payment_type IN ( 'USER1','USER10','USER12','USER3')";
// 都度課金を除く
if ($this->strlen('search_docomo_site_id') > 0) {
$sub_where .= " AND site_id = ?";
$this->arrVal[] = $this->arrSql['search_docomo_site_id'];
}
if ($this->strlen('search_course') > 0) {
$sub_where .= " AND price = ?";
$this->arrVal[] = intval($this->arrSql['search_course']);
}
$where .= "WHEN carrier = 1 THEN " . PHP_EOL;
// docomo
$where .= sprintf(" customer_id IN (%s) " . PHP_EOL, $objQuery->getSql("customer_id", $dt, $sub_where));
}
if ($a) {
$sub_where = "continue_account_id IS NOT NULL";
if ($this->strlen('search_docomo_site_id') > 0) {
// サイト ID を指定した場合は 検索対象から除外
$sub_where .= " AND FALSE ";
}
if ($this->strlen('search_course') > 0) {
$sub_where .= " AND amount = ?";
$this->arrVal[] = intval($this->arrSql['search_course']);
}
$where .= "WHEN carrier = 2 THEN " . PHP_EOL;
// au-kddi
$where .= sprintf(" customer_id IN (%s) " . PHP_EOL, $objQuery->getSql("customer_id", $at, $sub_where));
}
$where .= "ELSE FALSE END" . PHP_EOL;
$this->setWhere($where);
unset($where);
$objQuery->setGroupBy("");
$objQuery->setOption("");
// 有効なメルマガ会員か本登録ユーザー
$where = "CASE WHEN email LIKE ? THEN TRUE ELSE mailmaga_flg <> 3 END " . PHP_EOL;
$this->arrVal[] = $this->addSearchStr("@" . $_SERVER['SERVER_NAME']);
$this->setWhere($where);
if ($this->is_array("search_customer_type")) {
switch ($this->sum("search_customer_type")) {
case "1":
$this->setWhere('mailmaga_flg = 3');
break;
case "2":
$this->setWhere('mailmaga_flg <> 3');
break;
}
}
if ($this->strlen("search_point")) {
$this->setWhere('point >= ? ' . PHP_EOL);
$this->arrVal[] = intval($this->arrSql['search_point']);
}
// carrier
if ($this->strlen("search_carrier")) {
$this->setWhere(' carrier = ? ' . PHP_EOL);
$this->arrVal[] = intval($this->arrSql['search_carrier']);
} else {
}
if ($mode == 'customer') {
// 登録日を示すカラム
$regdate_col = 'dtb_customer.update_date DESC';
$this->setOrder($regdate_col);
} elseif ($mode == 'DuplicateSiteId') {
if (SC_Helper_DB::sfColumnExists("cp_dtb_customer_docomo_mymenu", "customer_id")) {
$arrPaymentType = array("USER1", "USER10", "USER12");
$this->arrVal = array_merge($this->arrVal, $arrPaymentType);
$objSql = new SC_SelectSql();
$objSql->setWhere("del_flg = 0");
$objSql->setItemTerm($arrPaymentType, "payment_type");
$objSql->setSelect("SELECT customer_id FROM cp_dtb_customer_docomo_mymenu ");
$objSql->setGroup("customer_id HAVING count(site_id) > 1");
$inquery = $objSql->getSql(2);
$this->setWhere("customer_id IN ({$inquery})");
}
$regdate_col = 'dtb_customer.customer_id DESC';
$this->setOrder($regdate_col);
}
}
/**
* クエリを構築する.
*
* 検索条件のキーに応じた WHERE 句と, クエリパラメーターを構築する.
* クエリパラメーターは, SC_FormParam の入力値から取得する.
*
* 構築内容は, 引数の $where 及び $arrValues にそれぞれ追加される.
*
* @param string $key 検索条件のキー
* @param string $where 構築する WHERE 句
* @param array $arrValues 構築するクエリパラメーター
* @param SC_FormParam $objFormParam SC_FormParam インスタンス
* @param SC_FormParam $objDb SC_Helper_DB_Ex インスタンス
* @return void
*/
public function buildQuery($key, &$where, &$arrValues, SC_FormParam &$objFormParam, SC_Helper_DB &$objDb)
{
$objSql = new SC_SelectSql_Ex();
$objSql->setWhere($where);
$objQuery = new SC_Query_Ex("", false, true);
$data = array();
$id = "product_id";
$extends = true;
$value = $objFormParam->getValue($key);
switch ($key) {
case "search_orderby":
$column = "update_date";
switch ($value) {
default:
case "date":
$column = "auto_display_start_date";
}
if ($objDb->sfColumnExists("dtb_products", $column)) {
$this->order = $column;
}
break;
case "search_character_id":
$sub_query = $objQuery->getSql($id, "cp_dtb_product_characters", "character_id=?");
$objSql->setWhere("{$id} IN ({$sub_query})");
$arrValues[] = $value;
break;
case "search_auto_display_status":
if (is_array($value)) {
$data = $objSql->setItemTerm($value, "auto_display_status");
} elseif (is_string($value)) {
$data = $objSql->setItemTerm((array) $value, "auto_display_status");
}
break;
case "search_auto_display_start_date_start_year":
case "search_auto_display_start_date_end_year":
case "search_auto_display_end_date_start_year":
case "search_auto_display_end_date_end_year":
case "search_spass_provide_start_date_start_year":
case "search_spass_provide_start_date_end_year":
case "search_spass_provide_end_date_start_year":
case "search_spass_provide_end_date_end_year":
$y = $objFormParam->getValue($key);
$m = $objFormParam->getValue(str_replace("_year", "_month", $key));
$d = $objFormParam->getValue(str_replace("_year", "_day", $key));
switch ($key) {
case "search_auto_display_start_date_start_year":
$data = $objSql->selectTermRange($y, $m, $d, "", "", "", "auto_display_start_date");
break;
case "search_auto_display_start_date_end_year":
$data = $objSql->selectTermRange("", "", "", $y, $m, $d, "auto_display_start_date");
break;
case "search_auto_display_end_date_start_year":
$data = $objSql->selectTermRange($y, $m, $d, "", "", "", "auto_display_end_date");
break;
case "search_auto_display_end_date_end_year":
$data = $objSql->selectTermRange("", "", "", $y, $m, $d, "auto_display_end_date");
break;
case "search_spass_provide_start_date_start_year":
$data = $objSql->selectTermRange($y, $m, $d, "", "", "", "spass_provide_start_date");
break;
case "search_search_spass_provide_start_date_end_year":
$data = $objSql->selectTermRange("", "", "", $y, $m, $d, "spass_provide_start_date");
break;
case "search_search_spass_provide_end_date_start_year":
$data = $objSql->selectTermRange($y, $m, $d, "", "", "", "spass_provide_end_date");
break;
case "search_search_spass_provide_end_date_end_year":
$data = $objSql->selectTermRange("", "", "", $y, $m, $d, "spass_provide_end_date");
break;
}
break;
default:
$extends = false;
parent::buildQuery($key, $where, $arrValues, $objFormParam, $objDb);
}
if ($extends) {
foreach ($data as $d) {
$arrValues[] = $d;
}
$where = $objSql->getWhere();
}
}
/**
* 商品情報の配列に, 税込金額を設定して返す.
*
* この関数は, 主にスマートフォンで使用します.
*
* @param array $arrProducts 商品情報の配列
* @return array 税込金額を設定した商品情報の配列
*/
function setPriceTaxTo($arrProducts)
{
foreach ($arrProducts as $key => $val) {
$arrProducts[$key]['price01_min_format'] = number_format($arrProducts[$key]['price01_min']);
$arrProducts[$key]['price01_max_format'] = number_format($arrProducts[$key]['price01_max']);
$arrProducts[$key]['price02_min_format'] = number_format($arrProducts[$key]['price02_min']);
$arrProducts[$key]['price02_max_format'] = number_format($arrProducts[$key]['price02_max']);
$arrProducts[$key]['price01_min_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price01_min']);
$arrProducts[$key]['price01_max_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price01_max']);
$arrProducts[$key]['price02_min_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price02_min']);
$arrProducts[$key]['price02_max_tax'] = SC_Helper_DB::sfCalcIncTax($arrProducts[$key]['price02_max']);
$arrProducts[$key]['price01_min_tax_format'] = number_format($arrProducts[$key]['price01_min_tax']);
$arrProducts[$key]['price01_max_tax_format'] = number_format($arrProducts[$key]['price01_max_tax']);
$arrProducts[$key]['price02_min_tax_format'] = number_format($arrProducts[$key]['price02_min_tax']);
$arrProducts[$key]['price02_max_tax_format'] = number_format($arrProducts[$key]['price02_max_tax']);
}
return $arrProducts;
}
