"北部", "M" => "中部", "S" => "南部", "W" => "東部", "O" => "其他" ); $limit = ''; $zv = ""; if ( isset( $_GET['filter_area'] ) && in_array( $_GET['filter_area'], array_keys( $z ) ) ) { $limit = " and afaainst_type = '" . $_GET['filter_area'] . "'"; $zv = $_GET['filter_area']; } $tv = ""; if ( isset( $_GET['filter_type'] ) && $_GET['filter_type'] != '' ) { $limit .= " and afaainstcat_serno = '" . filter_var( $_GET['filter_type'], FILTER_SANITIZE_EMAIL ) . "'"; $tv = $_GET['filter_type']; } if ( ! isset( $content ) ) { $content = new Stanoo\Sccms\ftable( 'afaainst' ); } $sqlsub = new Stanoo\Sccms\fsubcat(); $subcat = $sqlsub->cat_list( 6, 1 ); if ( ! is_array( $subcat ) ) { $subcat = array(); } $this_pos = ""; if ( isset( $_GET['l'] ) ) { $this_pos = $_GET['l']; } $content->page_limit = 200; $content->select = "*"; $content->query_where = "where enable = 'Y' and (afaainst_start is null or afaainst_start < '". date("Y-m-d H:i:s")."') and (afaainst_end is null or afaainst_end > '". date("Y-m-d H:i:s")."') $limit "; $content->query_orderby = "ORDER BY orderby, afaainst_serno desc"; $content->orderby_method = "-1"; $page = 1; if ( isset( $_GET['page'] ) && $_GET['page'] != "" ) { $page = $_GET['page']; } else if ( isset( $_POST['page'] ) && $_POST['page'] != "" ) { $page = $_POST['page']; } $data_array = $content->data( $page ); $page = $content->page; $opening = array(); foreach ( $data_array as $data ) { if ( ! isset( $opening[ $data['afaainstcat_serno'] ] ) ) { $opening[ $data['afaainstcat_serno'] ] = array(); } array_push( $opening[ $data['afaainstcat_serno'] ], $data ); } /* foreach ( $sqlsub->cat_list( 6, 1 ) as $key => $value ) { if ( ! isset( $opening[ $key ] ) ) { unset( $subcat[ $key ] ); } } */ // check if variable l is a valid subcat if ( $this_pos == "" || ! isset( $subcat[ $this_pos ] ) ) { // first element of $subcat $tmp = array_keys( $subcat ); $this_pos = array_shift( $tmp ); } $types = $content->sql_exec( "select * from afaainst where enable = 'Y' and (afaainst_start is null or afaainst_start < '". date("Y-m-d H:i:s")."') and (afaainst_end is null or afaainst_end > '". date("Y-m-d H:i:s")."')" ); $type_options = array(); foreach ( $types as $tt ) { $type_options[ $tt['afaainstcat_serno'] ] = true; } foreach ( $sqlsub->cat_list( 6, 1 ) as $key => $value ) { if ( ! isset( $type_options[ $key ] ) ) { unset( $subcat[ $key ] ); } } $location = array( "N" => "北區", "M" => "中區" , "S"=>"南區", 'O'=>"其他" ); $color_class = array( 'FDI' => 'fdi', 'GEI' => 'gei', "MAT" => 'mat', 'WT' => 'wt', "PFT" => "pft", "STEP" => 'step', "KB" => 'kb' ); function afaainstColor($name){ global $color_class; if (isset($color_class[$name])){ return $color_class[$name]; } else { return strtolower($name); } } ?>