/** * 開始行番号, 行数を指定して管理者データを取得する. * * @access private * @param integer $startno 開始行番号 * @return array 管理者データの連想配列 */ function getMemberData($startno) { $objSql = new SC_SelectSql(); $objSql->setSelect("SELECT member_id,name,department,login_id,authority,rank,work FROM dtb_member"); $objSql->setOrder("rank DESC"); $objSql->setWhere("del_flg <> 1 AND member_id <> " . ADMIN_ID); $objSql->setLimitOffset(MEMBER_PMAX, $startno); $objQuery = new SC_Query(); $arrMemberData = $objQuery->getAll($objSql->getSql()); return $arrMemberData; }
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); } }