女性の就労・起業・心とからだの健康支援・DV相談・パソコン講座、子育て支援等の事業、施設貸出を行っている横浜市の男女共同参画センターです

addScriptPath("/home/forum/admin/app/../contents/template") ->addScriptPath("/home/forum/admin/app/views/scripts") ->addHelperPath("/home/forum/admin/app/views/helpers", "View_Helper"); ?> find(193)->current(); ?> select() ->from( array('content' => $content_t->info('name')), array( 'date' => 'DATE_FORMAT(created_at, "%Y-%m")', 'cnt' => 'COUNT(id)' ) ) ->where('publish = 1') ->where( '(availabled_at IS NULL AND expired_at IS NULL)'. ' OR '. '(availabled_at IS NULL AND NOW() <= expired_at)'. ' OR '. '(availabled_at <= NOW() AND expired_at IS NULL)'. ' OR '. '(availabled_at <= NOW() AND NOW() <= expired_at)' ) ->group('date') ->order('date DESC'); if(count($type_names) != 0) { $type_t = new Type(); $s = $type_t->select(); foreach($type_names as $name) { $s->orWhere('name = ?', $name); } $type_ids = $view->map($type_t->fetchAll($s), 'id'); $select->where('type_id IN ('.implode(',', $type_ids).')'); } if(count($category_names) != 0) { $names = array(); foreach($category_names as $name) { $names[] = "'{$name}'"; } $category_t = new Category(); foreach( $category_t->fetchAll( $category_t->select() ->where('name IN ('.implode(',', $names). ')') ) as $category ) { $category_ids[] = $category->id; } } if(count($category_ids) != 0) { $content_category_t = new Content_Category(); $select->setIntegrityCheck(false); $select->join( array('content_category' => $content_category_t->info('name')), 'content.id = content_category.content_id', array('content_id') ) ->where('value = 1') ->where( 'content_category.category_id IN ('. implode(',', $category_ids). ')' ) ->group('content_category.content_id'); /* MySQL 3.23 対応のため改修 $s = $content_category_t->select() ->from( array('content_category' => $content_category_t->info('name')), array('content_id') ) ->where('value = 1') ->where( 'content_category.category_id IN ('. implode(',', $category_ids). ')' ); #$select->where('content.id IN ('.$s->__toString().')'); */ } echo ''; ?>