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