/** * 検索条件のwhere文とかを取得 * * @return array */ public function lfGetSearchCondition(&$arrSearchData) { $searchCondition = parent::lfGetSearchCondition($arrSearchData); GC_Utils_Ex::gfPrintLog(print_r($this->arrForm, true), DEBUG_LOG_REALFILE); $objSql = new SC_SelectSql_Ex(); $objSql->setWhere($searchCondition['where']); $character_id = $this->arrForm['character_id']; if (SC_Utils_Ex::sfIsInt($character_id)) { $this->arrSearchData["character_id"] = $character_id; $objSql->setWhere("product_id IN (\n SELECT product_id\n FROM cp_dtb_product_characters\n INNER JOIN cp_dtb_character USING(character_id)\n WHERE character_id = ?\n AND cp_dtb_character.status = 1\n AND cp_dtb_character.del_flg = 0\n )"); $searchCondition['arrval'][] = intval($character_id); } $searchCondition['where'] = $objSql->getWhere(false); $searchCondition['where_for_count'] = $objSql->getWhere(false); return $searchCondition; }