sql_query($sql)) { $actives = $db->sql_fetchrow($result); $active_id = $actives['id']; } } } //-get the actives of class by member if (isset($_SESSION['user_info']['member_id'])) { $memeber_id = intval($_SESSION['user_info']['member_id']); $mclass_actives = get_actives_of_class($memeber_id); } $query = array( 'SELECT' => '*', 'FROM' => array('products' => 'p'), 'WHERE' => 'p.manu_id = \''.$active_id.'\'', 'ORDER_BY' => 'p.id ASC', ); if (isset($_SESSION['user_info']['member_id'])) { if (!isset($_REQUEST['id'])) { $query['WHERE'] = 'p.cactive_id = \''.$active_id.'\''; }else if ('class' == $_REQUEST['atype']) { $query['WHERE'] = 'p.cactive_id = \''.$active_id.'\''; } } if($result = $db->sql_query($db->sql_build_query('SELECT',$query))) { $images_result = $db->sql_fetchrowset($result); }else { $images_result = false; } //get all the act by year & month $query_acts = array( 'SELECT' => '*', 'FROM' => array('manufacturers' => 'm'), 'ORDER_BY' => 'm.year_id,m.month_id ASC', ); if($result = $db->sql_query($db->sql_build_query('SELECT',$query_acts))) { $acts_result = $db->sql_fetchrowset($result); }else { $acts_result = false; } foreach ($acts_result as $act) { $act_by_date[$act['year_id']][$act['month_id']][] = array('id'=>$act['id'],'name'=> $act['name']); } //get all the act by year & month $query_active = array( 'SELECT' => '*', 'FROM' => array('manufacturers' => 'm'), 'WHERE' => 'm.id = \''.$active_id.'\'' ); if($result = $db->sql_query($db->sql_build_query('SELECT',$query_active))) { $active_result = $db->sql_fetchrow($result); }else { $active_result = false; } //-get the active year & month if ($active_result) { //-for the class active if ((isset($_REQUEST['atype'])&&'class' !=$_REQUEST['atype'])||isset($_SESSION['user_info']['member_id'])) { $active_year = '0'; $active_month = '0'; }else { //-for the school active $active_year = $active_result['year_id']; $active_month = $active_result['year_id'].'_'.$active_result['month_id']; //print_r($active_result); } } ?> 衛斯理幼稚園
 

班級活動

學校活動

$year) { if($active_year == $year_id) { $display_str = 'block'; }else { $display_str = 'none'; } ?>

$month) { $cur_month_id = $year_id.'_'.$month_id; if ($active_month == $cur_month_id) { $display_month_str = 'block'; }else { $display_month_str = 'none'; } ?>

月
[登出]