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; }