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)' ); }
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(); } }