$val){
$arg = filter_input_array(INPUT_GET,FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_BACKTICK | FILTER_FLAG_STRIP_HIGH);
}
include("../lib/common.cgi");
require_once("../lib/htmltemplate.php");
include("./common/site.php");
include("./common/cm.php");
include("/home/politician-cafe/lib/auth.php");
include("./common/navi.php");
include("./common/footer.php");
//ここまで
//公約政治家情報
$sql_s1 = "SELECT * FROM giin where
g_id = '{$arg['gid']}'
;";
//echo "{$sql_s1}
";
$result_s1 = mysqli_query($cnn,$sql_s1);
while ($data_s1 = mysqli_fetch_assoc($result_s1)){
$namae = "{$data_s1['g_name_1']}"."{$data_s1['g_name_2']}";
//選挙区文
if($data_s1['g_se_id'] != "0"){
$sql_s1s = "SELECT * FROM senkyo_kind where se_id = '{$data_s1['g_se_id']}';";
//echo "{$sql_s1s}
";
$result_s1s = mysqli_query($cnn,$sql_s1s);
while ($data_s1s = mysqli_fetch_assoc($result_s1s)){
$data_s1['se_name'] = $data_s1s['se_name'];
//何県の知事?
if(($data_s1['g_se_id'] == "14" || $data_s1['g_se_id'] == "15" || $data_s1['g_se_id'] == "16" || $data_s1['g_se_id'] == "17" || $data_s1['g_se_id'] == "1002" || $data_s1['g_se_id'] == "1003" || $data_s1['g_se_id'] == "1004" || $data_s1['g_se_id'] == "1005") && $data_s1['g_a1_id'] != "0"){
$sql_s1s2 = "SELECT * FROM area_1 where a1_id = '{$data_s1['g_a1_id']}';";
//echo "{$sql_s1s2}";
$result_s1s2 = mysqli_query($cnn,$sql_s1s2);
while ($data_s1s2 = mysqli_fetch_assoc($result_s1s2)){
$data_s1['f_name'] = $data_s1s2['a1_name'];
}
}
//市町村?
if(($data_s1['g_se_id'] == "19" || $data_s1['g_se_id'] == "20" || $data_s1['g_se_id'] == "21" || $data_s1['g_se_id'] == "22" || $data_s1['g_se_id'] == "23" || $data_s1['g_se_id'] == "24" || $data_s1['g_se_id'] == "25"|| $data_s1['g_se_id'] == "1006" || $data_s1['g_se_id'] == "1007" || $data_s1['g_se_id'] == "1008" || $data_s1['g_se_id'] == "1009" || $data_s1['g_se_id'] == "1010" || $data_s1['g_se_id'] == "1011"|| $data_s1['g_se_id'] == "26") && $data_s1['g_a2_id'] != "0"){
$sql_s1s3 = "SELECT * FROM area_2 where a2_id = '{$data_s1['g_a2_id']}';";
//echo "{$sql_s1s3}";
$result_s1s3 = mysqli_query($cnn,$sql_s1s3);
while ($data_s1s3 = mysqli_fetch_assoc($result_s1s3)){
$data_s1['f_name'] = $data_s1s3['a2_name'];
}
}
}
}
$arg['data_s1'][] = $data_s1;
}
// 現在のページを取得
// デバッグ用
//var_dump($_GET);
// 現在のページを取得
$page = isset($_GET['page']) && is_numeric($_GET['page']) && $_GET['page'] > 0 ? (int)$_GET['page'] : 1;
//var_dump($_GET['page'], $page); // ← ここで確認
//$arg['page'] = $_GET['page'];
//var_dump($arg['page']); // ← ここで確認
//print_r($arg['page']);
$limit = 20; // 1ページあたりの件数
$offset = ($page - 1) * $limit; // オフセット(ページ番号に基づいて)
// 総件数と総ページ数の計算
$sql_count = "SELECT COUNT(*) AS total FROM koudou WHERE ko_g_id = '{$arg['gid']}' AND ko_f = '1'";
$count_result = mysqli_query($cnn, $sql_count);
$total_rows = mysqli_fetch_assoc($count_result)['total'];
$total_pages = ceil($total_rows / $limit); // 総ページ数
if ($total_rows > 0) {
$arg['kodoaru'] = 1;
}
if($total_rows > 20){
if($arg['page'] == ""){
$arg['page'] = 1;
}
$arg['hukusu_p'] = 1;
}
if ($total_rows > $limit) {
$arg['tochu'] = 1;
}
// 1ページあたりの表示するリンク数(最大)
$max_links = 10;
// ページリンクの表示範囲を設定
$start_page = max(1, $page - floor($max_links / 2)); // 現在のページを中心に前後5ページ
$end_page = min($total_pages, $start_page + $max_links - 1); // 最大10個のリンクを表示
// 1ページ目かどうか、最終ページかどうかを判定
$is_first_page = ($page == 1);
$is_last_page = ($page == $total_pages);
// $arg['pages'] の設定
if ($is_first_page) {
$arg['pages'] = 1; // 最初のページ
$arg['n_pages'] = $page + 1;
} elseif ($is_last_page) {
$arg['pages'] = 9; // 最後のページ
$arg['p_pages'] = $page - 1;
} else {
$arg['pages'] = 2; // 中間のページ
$arg['p_pages'] = $page - 1;
$arg['n_pages'] = $page + 1;
}
// ページリンクを$arg['hoge']に格納
$pagination = '';
// ページタイトルの設定
if ($page > 1) {
$arg['site_master']['title'] = "{$namae}の活動・発言の{$page}ページ目|政治家情報サイト「先生の通信簿」";
} else {
$arg['site_master']['title'] = "{$namae}の活動・発言|政治家情報サイト「先生の通信簿」";
}
$pagination .= '';
$pagination .= '';
// $arg['pager']にページリンクを格納
$arg['pager'] = $pagination;
//ページ送りEND
//活動のリストを出す
$sql_k1 = "SELECT * FROM koudou,user WHERE
ko_j_id = j_id
AND ko_f = '1'
AND ko_g_id = '{$arg['gid']}'
ORDER BY ko_date DESC,ko_id DESC
LIMIT {$limit} OFFSET {$offset}";
$result_k1 = mysqli_query($cnn, $sql_k1);
$rows_k1 = mysqli_num_rows($result_k1);
if($rows_k1 > 0){
$arg['ka_aru'] = "1";
}
while ($data_k1 = mysqli_fetch_assoc($result_k1)){
//$data_k1['ko_title']
// 「【」「】」「*」を削除
$data_k1['ko_text'] = str_replace(['【', '】', '*'], '', $data_k1['ko_text']);
//コメント数を出す
$sql_k1com = "SELECT kr_id FROM koudou_re where
kr_ko_id = '{$data_k1['ko_id']}'
and kr_f = '1'
;";
//echo "{$sql_s1}
";
$result_k1com = mysqli_query($cnn,$sql_k1com);
$data_k1['rows_k1com'] = mysqli_num_rows($result_k1com);
//本文を短くするかもっす
//$data_k1['ko_text'] = mb_strimwidth("{$data_k1['ko_text']}", 0, 150, "...", 'UTF-8');
//画像の有無
$filename_1 = "/home/politician-cafe/www/action_img/{$data_k1['ko_sess']}_1.jpg";
//echo "{$filename_1}
";
if (file_exists($filename_1)) {
$data_k1['img_jpg_1'] = "1";
}else{
$data_k1['img_jpg_1'] = "0";
}
//画像の有無END
$arg['data_k1'][] = $data_k1;
}
include("/home/politician-cafe/lib/giin_pv.php");
//include("/home/politician-cafe/lib/kouyaku_pv.php");
//print_r($arg);
htmltemplate::t_include("./tmpl/politician_activity.html",$arg);