{"id":97,"date":"2010-01-27T09:03:47","date_gmt":"2010-01-27T00:03:47","guid":{"rendered":"http:\/\/phpdev.comsys-blog.com\/?p=97"},"modified":"2010-01-27T09:03:47","modified_gmt":"2010-01-27T00:03:47","slug":"%e3%82%bd%e3%83%bc%e3%82%b9%e3%82%b3%e3%83%bc%e3%83%89%e8%87%aa%e5%8b%95%e4%bd%9c%e6%88%90%e3%83%84%e3%83%bc%e3%83%ab%e3%81%8c%e4%bd%9c%e3%81%a3%e3%81%9f%e3%82%bd%e3%83%bc%e3%82%b9","status":"publish","type":"post","link":"https:\/\/tamura.jp\/?p=97","title":{"rendered":"\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u81ea\u52d5\u4f5c\u6210\u30c4\u30fc\u30eb\u304c\u4f5c\u3063\u305f\u30bd\u30fc\u30b9"},"content":{"rendered":"

\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u81ea\u52d5\u4f5c\u6210\u30c4\u30fc\u30eb\u304c\u4f5c\u3063\u305f\u30bd\u30fc\u30b9\u3067\u3059\u3002<\/p>\n

\n
\n

\u00a0
\n<?php
\nrequire_once ‘html_util\/BaseSmarty.php’;
\nrequire_once ‘db_access\/db_class_\u5546\u54c1\u7d71\u5408\u7ba1\u7406.php’;
\n\/\/require_once ‘user_info_util\/session_info.php’;<\/p>\n

HTME::form_trim_all();
\n\/\/HTME::https_needs();
\n\/\/session_info::login_needs();
\nform_load();<\/p>\n

\/**
\n\u00a0* \u753b\u9762\u304b\u3089\u306e\u5165\u529b\u51e6\u7406\u3092\u884c\u3046
\n\u00a0*\/
\nfunction form_load()
\n{
\n\/\/\u00a0 $user_info = session_info::is_login();
\n\u00a0\u00a0\u00a0 $o_smarty = new BaseSmarty();
\n\u00a0\u00a0\u00a0 HTME::form_post_set($o_smarty);
\n\u00a0\u00a0\u00a0 switch($_POST[“form_name”])
\n\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case\u00a0\u00a0\u00a0 ‘\u5546\u54c1\u7d71\u5408\u7ba1\u7406_list.html’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 switch($_POST[‘action_cmd’])
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case ‘search’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $_POST[‘page_no’] = page_no(1,0);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 search_list($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case ‘next’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $_POST[‘page_no’] = page_no($_POST[‘page_no’],1);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 search_list($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case ‘jump’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $_POST[‘page_no’] = page_no($_POST[‘page_no’],0);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 search_list($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case ‘prior’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $_POST[‘page_no’] = page_no($_POST[‘page_no’],-1);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 search_list($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case ‘sort’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $_POST[‘page_no’] = page_no($_POST[‘page_no’],0);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 search_list($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 case ‘clear’:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 form_clear($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $o_smarty->display(“\u5546\u54c1\u7d71\u5408\u7ba1\u7406_list.html”);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 default:
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 HTME::form_get_set($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 form_init($o_smarty);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $o_smarty->display(“\u5546\u54c1\u7d71\u5408\u7ba1\u7406_list.html”);
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 break;
\n\u00a0\u00a0\u00a0 }
\n}<\/p>\n

\/**
\n\u00a0* \u6700\u521d\u306e\u753b\u9762\u3092\u8868\u793a\u3059\u308b
\n\u00a0* @param $o_smarty\u00a0\u00a0\u00a0\u00a0 SMARTY\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u6e21\u3059
\n\u00a0* @param $action_cmd\u00a0\u00a0 \u753b\u9762\u306e\u30a2\u30af\u30b7\u30e7\u30f3\u30b3\u30de\u30f3\u30c9
\n\u00a0* @return \u306a\u3057
\n\u00a0*\/
\nfunction form_init($o_smarty)
\n{
\n\u00a0\u00a0\u00a0 $_POST[‘sort_key’] = ‘\u5546\u54c1\u30b3\u30fc\u30c9’; \/* \u521d\u56de\u306e\u30bd\u30fc\u30c8\u30ad\u30fc\u3092\u5165\u308c\u308b*\/
\n\u00a0\u00a0\u00a0 $_POST[‘sort_order’] = ‘asc’;
\n\u00a0\u00a0\u00a0 search_list($o_smarty);
\n}<\/p>\n

\/**
\n\u00a0* \u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u30af\u30ea\u30a2\u3059\u308b
\n\u00a0* @param $o_smarty\u00a0\u00a0\u00a0\u00a0 SMARTY\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u6e21\u3059
\n\u00a0* @return \u306a\u3057
\n\u00a0*\/
\nfunction form_clear($o_smarty)
\n{
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘_\u5546\u54c1\u30b3\u30fc\u30c9’,”);
\n}<\/p>\n

\/**
\n\u00a0* \u691c\u7d22\u3059\u308b
\n\u00a0* @param $o_smarty\u00a0\u00a0\u00a0\u00a0 SMARTY\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u6e21\u3059
\n\u00a0* @param $action_cmd\u00a0\u00a0 \u753b\u9762\u306e\u30a2\u30af\u30b7\u30e7\u30f3\u30b3\u30de\u30f3\u30c9
\n\u00a0* @return \u306a\u3057
\n\u00a0*\/
\nfunction search_list($o_smarty)
\n{
\n\u00a0\u00a0\u00a0 $sort_key\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = sort_key($o_smarty);
\n\u00a0\u00a0\u00a0 $class\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = new db_class_\u5546\u54c1\u7d71\u5408\u7ba1\u7406();
\n\u00a0\u00a0\u00a0 $class->_\u5546\u54c1\u30b3\u30fc\u30c9 = $_POST[‘_\u5546\u54c1\u30b3\u30fc\u30c9’];
\n\u00a0\u00a0\u00a0 $line_len\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0 line_len($_POST[‘line_len’]);
\n\u00a0\u00a0\u00a0 $page_no\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 =\u00a0\u00a0 $_POST[‘page_no’];
\n\u00a0\u00a0\u00a0 $max_page_no\u00a0\u00a0\u00a0 =\u00a0\u00a0 0;
\n\u00a0\u00a0\u00a0 $record_count\u00a0\u00a0 =\u00a0\u00a0 0;
\n\u00a0\u00a0\u00a0 $list_data = db_class_\u5546\u54c1\u7d71\u5408\u7ba1\u7406::db_select_list($class,$line_len,$sort_key,$page_no,$max_page_no,$record_count);
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘line_len’,$line_len);
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘page_no’,$page_no);
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘max_page_no’,$max_page_no);
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘record_count’,$record_count);
\n\u00a0\u00a0\u00a0 $o_smarty->htmput(‘list_data’,$list_data);
\n}<\/p>\n

\/**
\n\u00a0* \u30bd\u30fc\u30c8\u9806\u756a\u3092\u6c42\u3081\u308b
\n\u00a0* @param $o_smarty\u00a0\u00a0\u00a0\u00a0 SMARTY\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u6e21\u3059
\n\u00a0* @return \u30bd\u30fc\u30c8\u9806\u3092\u683c\u7d0d\u3057\u305f\u914d\u5217\u3092\u8fd4\u3059
\n\u00a0*\/
\nfunction sort_key($o_smarty)
\n{
\n\u00a0\u00a0\u00a0 $sort_key = ”; \/* \u3053\u306e\u914d\u5217\u306b\u30bd\u30fc\u30c8\u30ad\u30fc\u3068\u30bd\u30fc\u30c8\u30aa\u30fc\u30c0\u30fc\u3092\u5165\u308c\u308b*\/
\n\u00a0\u00a0\u00a0 if(!$_POST[‘sort_key’] && !$_POST[‘sort_key_old’]) return null;
\n\u00a0\u00a0\u00a0 $key =\u00a0\u00a0\u00a0\u00a0\u00a0 $_POST[‘sort_key’];
\n\u00a0\u00a0\u00a0 if(!$key) $key = $_POST[‘sort_key_old’];
\n\u00a0\u00a0\u00a0 if($_POST[‘sort_key’]==$_POST[‘sort_key_old’])
\n\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if($_POST[‘sort_order’]==’desc’)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $sort_key[$key] = ‘asc’;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $sort_key[$key] = ‘desc’;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0 else
\n\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if($_POST[‘sort_key’])
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $sort_key[$key] = ‘asc’;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 if($_POST[‘sort_order’]==’asc’)
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $sort_key[$key] = ‘asc’;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 else
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 $sort_key[$key] = ‘desc’;
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0 }
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘sort_key_old’,$key);
\n\u00a0\u00a0\u00a0 $o_smarty->txtput(‘sort_order’,$sort_key[$key]);
\n\u00a0\u00a0\u00a0 return $sort_key;
\n}<\/p>\n

\/**
\n\u00a0* \u30da\u30fc\u30b8\u756a\u53f7\u3092\u52a0\u7b97\u6e1b\u7b97\u3059\u308b
\n\u00a0* @param $page_no\u00a0 \u73fe\u5728\u306e\u30da\u30fc\u30b8\u756a\u53f7
\n\u00a0* @param $add\u00a0\u00a0\u00a0\u00a0\u00a0 \u52a0\u7b97\u6e1b\u7b97\u3059\u308b\u5024
\n\u00a0* @return \u7d50\u679c\u306e\u30da\u30fc\u30b8\u3092\u8fd4\u3059
\n\u00a0*\/
\nfunction page_no($page_no,$add)
\n{
\n\u00a0\u00a0\u00a0 if(!is_numeric($page_no)) $page_no=0;
\n\u00a0\u00a0\u00a0 if(!is_numeric($add)) $add=0;
\n\u00a0\u00a0\u00a0 $page_no = intval($page_no) + intval($add);
\n\u00a0\u00a0\u00a0 if($page_no<1) $page_no=1;
\n\u00a0\u00a0\u00a0 return $page_no;
\n}<\/p>\n

\/**
\n\u00a0* \u8868\u793a\u884c\u6570\u3092\u6c42\u3081\u308b
\n\u00a0* @param $line_len \u8868\u793a\u884c\u6570
\n\u00a0* @return \u8868\u793a\u884c\u6570\u3092\u8fd4\u3059
\n\u00a0*\/
\nfunction line_len($line_len)
\n{
\n\u00a0\u00a0\u00a0 if(!is_numeric($line_len)) $line_len=10;
\n\u00a0\u00a0\u00a0 if($line_len<1) $line_len = 10;
\n\u00a0\u00a0\u00a0 $line_len = intval($line_len);
\n\u00a0\u00a0\u00a0 return $line_len;
\n}
\n?><\/p>\n<\/div>\n<\/form>\n","protected":false},"excerpt":{"rendered":"

\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u81ea\u52d5\u4f5c\u6210\u30c4\u30fc\u30eb\u304c\u4f5c\u3063\u305f\u30bd\u30fc\u30b9\u3067\u3059\u3002 \u00a0 <?php require_once ‘html_util\/BaseSmarty.php’; require_once ‘db […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[],"class_list":["post-97","post","type-post","status-publish","format-standard","hentry","category-47"],"_links":{"self":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts\/97","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=97"}],"version-history":[{"count":0,"href":"https:\/\/tamura.jp\/index.php?rest_route=\/wp\/v2\/posts\/97\/revisions"}],"wp:attachment":[{"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=97"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=97"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tamura.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=97"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}