public function getArrProducts()
{
$objPage = new LC_Page_Products_List_Ex();
$objPage->orderby = "date";
$objPage->init();
$objPage->arrSearchData = array();
$detect = new Mobile_Detect();
if ($detect->is("iOS")) {
$objPage->arrSearchData["category_id"] = 2;
} else {
$objPage->arrSearchData["category_id"] = 1;
}
$arrSearchCondition = $objPage->lfGetSearchCondition($objPage->arrSearchData);
$arrProducts = $objPage->lfGetProductsList($arrSearchCondition, NEW_CONTENTS_SEARCH_PMAX, 0, $this->objProduct);
unset($arrProducts["productStatus"]);
return $arrProducts;
}
/**
* 検索条件の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;
}
