'',
'alt'=>$artrec['title'],
'end'=>'',
'new'=>false
);
}
else {
// リンク指定
$b=preg_match("/^\w+:|\.(pdf)$/",strtolower($artrec['url']));
$a="$a,
'alt'=>$artrec['title'],
'end'=>'',
'new'=>$b
);
}
}
$path = "";
if($artrec["siteid"] == "spinf" ){
$path = "/spinf/spinf_j";
} elseif($artrec["siteid"] == "spaf" ){
$path = "/spaf-j";
} elseif($artrec["siteid"] == "smeif" ){
$path = "/smeif-j";
}
// 記事リンク
return Array(
'start'=>'',
'alt'=>$artrec['title'],
'end'=>'',
'new'=>false
);
}
function getArticleLinkEng($artrec,$fmt)
{
//print_r($artrec);
if($artrec['url']) {
// リンク指定
if($artrec['url']=='#') {
// 自動リンク無し
return Array(
'start'=>'',
'alt'=>$artrec['title'],
'end'=>'',
'new'=>false
);
}
else {
// リンク指定
$b=preg_match("/^\w+:|\.(pdf)$/",strtolower($artrec['url']));
$a="$a,
'alt'=>$artrec['title'],
'end'=>'',
'new'=>$b
);
}
}
$path = "";
if($artrec["siteid"] == "spinf" ){
$path = "/spinf";
} elseif($artrec["siteid"] == "spaf" ){
$path = "/spaf";
} elseif($artrec["siteid"] == "smeif" ){
$path = "/smeif";
}
// 記事リンク
return Array(
'start'=>'',
'alt'=>$artrec['title'],
'end'=>'',
'new'=>false
);
}
###################################################################
#
# APIを使って記事を取得
#
###################################################################
function checkCategory($category){
//print_r($category);
return $category[0];
}
function checkCategory2($category,$pubtype){
if( $pubtype == "0" ){
if($category){
foreach( $category as $key => $val ){
if( $val == "その他"){
return true;
}
}
}
} elseif( $pubtype == "1" ){
if($category){
foreach( $category as $key => $val ){
if( $val == "講演録／議事録"){
return true;
}
}
}
} elseif( $pubtype == "2" ){
if($category){
foreach( $category as $key => $val ){
if( $val == "書籍"){
return true;
}
}
}
} elseif( $pubtype == "3" ){
if($category){
foreach( $category as $key => $val ){
if( $val == "調査報告書"){
return true;
}
}
}
} elseif( $pubtype == "4" ){
if($category){
foreach( $category as $key => $val ){
if( $val == "定期刊行物"){
return true;
}
}
}
}
}
function getUrlData( $url ){
$auth_str = (BASIC_AUTH_ID && BASIC_AUTH_PASSWORD) ? BASIC_AUTH_ID.':'.BASIC_AUTH_PASSWORD.'@' : '';
//$baseurl = 'http://'.$auth_str.SERVER_ADDR.$url;
$baseurl = 'https://www.spf.org'.$url;
//print $baseurl;
$json = file_get_contents($baseurl);
$output = json_decode($json);
//print_r($output);
return $output;
}
function getMtArticle( $blog_id , $form="" ){
$auth_str = (BASIC_AUTH_ID && BASIC_AUTH_PASSWORD) ? BASIC_AUTH_ID.':'.BASIC_AUTH_PASSWORD.'@' : '';
//$baseurl = 'http://'.$auth_str.'/cms/mt-data-api.cgi/v1/sites/'.$blog_id.'/entries?limit=999';
$baseurl = 'http://www.spf.org'.'/cms/mt-data-api.cgi/v1/sites/'.$blog_id.'/entries?limit=999';
//print $baseurl."
";
$search_first = false;
if( $form["q"] ){
//キーワード
$baseurl .= "&search=".urlencode($form["q"]);
}
//print $baseurl."
";
//exit;
$json = file_get_contents($baseurl);
$output = json_decode($json);
//print $baseurl;
//print "
";
if( $_SERVER['REMOTE_ADDR'] == "114.178.178.81" ){
//print_r($output);
}
return $output->items;
}
function getMtCategoryList( $blog_id , $form="" ){
$baseurl = 'http://'.SERVER_ADDR.'/cms/mt-data-api.cgi/v1/sites/'.$blog_id.'/categories';
$search_first = false;
if( $form["q"] ){
//キーワード
$baseurl .= "?search=".urlencode($form["q"]);
}
//print $baseurl."
";
$json = file_get_contents($baseurl);
$output = json_decode($json);
return $output->items;
}
//TOP JSON
function getMtArticleTop( ){
$baseurl = 'http://'.SERVER_ADDR.'/mtjson.dat';
$json = file_get_contents($baseurl);
$json = ereg_replace( "},]", " }]" , $json );
//$json = ereg_replace( "{ ", "" , $json );
$json = mb_convert_encoding($json,"UTF-8","auto");
$output = json_decode($json);
//print_r($output);
//exit;
return $output;
}
function getMtCategories( $blog_id , $form="" ){
$baseurl = 'http://'.SERVER_ADDR.'/cms/mt-data-api.cgi/v1/sites/'.$blog_id.'/categories';
$search_first = false;
if( $form["q"] ){
//キーワード
$baseurl .= "?search=".urlencode($form["q"]);
}
//print $baseurl."
";
$json = file_get_contents($baseurl);
$output = json_decode($json);
return $output->items;
}
//カレンダーを取得
function getCalendar(){
$baseurl = 'http://'.SERVER_ADDR.'/calendar.json';
$search_first = false;
$json = file_get_contents($baseurl);
$output = json_decode($json);
return $output;
}
function getProjyectsCategory( $data ){
global $list1;
if( $_SERVER['REMOTE_ADDR'] == "114.178.178.81"){
//print_r($data);
//print "
";
}
if( $data ){
$category1 = array();
$category2 = array();
$category3 = array();
foreach($data as $key => $val ){
//print_r( $val );
//exit;
$c1 = "";
$c2 = "";
$c3 = "";
$cate1 = "";
$cate2 = "";
$cate3 = "";
list($c1,$c2,$c3) = explode("/",$val["siteid"]);
if(!$c2){
continue;
}
//print $val["siteid"]."
";
//print $cate1."|".$cate2."|".$cate3."
";
//exit;
if($c1){
if( !$category1 ){
$category1[] = $c1;
} else {
if( !in_array($c1,$category1)){
$category1[] = $c1;
}
}
}
////print_r($val["siteid"]);
//print "
";
/*
if($cate2){
if( !$category2 ){
if($category1){
$cate2_id = "";
foreach($category1 as $key => $val){
if( $val == $cate1 ){
$cate2_id = $key;
break;
}
}
}
//exit;
$category2[$cate2_id][] = $cate2;
} else {
if($category1){
$cate2_id = "";
foreach($category1 as $key => $val){
if( $val == $cate1 ){
$cate2_id = $key;
break;
}
}
}
//print_r($cate1);
//print "
";
if( !in_array($cate2,$category2[$cate2_id])){
$category2[$cate2_id][] = $cate2;
}
}
}
if($cate3){
if( !$category3 ){
if($category2){
$cate3_id = "";
foreach($category2 as $key => $val){
foreach($val as $k => $v){
if( $v == $cate2 ){
$cate3_id = $k;
break;
}
}
}
}
$category3[$cate3_id][] = $cate3;
} else {
if($category2){
$cate3_id = "";
foreach($category2 as $key => $val){
foreach($val as $k => $v){
if( $v == $cate2 ){
$cate3_id = $k;
break;
}
}
}
}
//print $cate3_id."
";
if( !in_array($cate3,$category3[$cate3_id])){
//print_r($category3[$cate3_id]);
//print "
";
$category3[$cate3_id][] = $cate3;
}
}
}
*/
}
foreach($data as $key => $val ){
//print_r( $val );
//exit;
$c1 = "";
$c2 = "";
$c3 = "";
$cate1 = "";
$cate2 = "";
$cate3 = "";
list($c1,$c2,$c3) = explode("/",$val["siteid"]);
//print $val["siteid"]."
";
//print $cate1."|".$cate2."|".$cate3."
";
//exit;
/*
if($cate1){
if( !$category1 ){
$category1[] = $cate1;
} else {
if( !in_array($cate1,$category1)){
$category1[] = $cate1;
}
}
}
*/
if($c2){
if( !$category2 ){
if($category1){
$cate2_id = "";
foreach($category1 as $key => $val){
if( $val == $c1 ){
$cate2_id = $key;
break;
}
}
}
//exit;
$category2[$cate2_id][] = $c2;
} else {
if($category1){
$cate2_id = "";
foreach($category1 as $key => $val){
if( $val == $c1 ){
$cate2_id = $key;
break;
}
}
}
//print_r($cate1);
//print "
";
if( !in_array($c2,$category2[$cate2_id])){
$category2[$cate2_id][] = $c2;
}
}
}
//print_r($category2);
//print "
";
/*
if($cate3){
if( !$category3 ){
if($category2){
$cate3_id = "";
foreach($category2 as $key => $val){
foreach($val as $k => $v){
if( $v == $cate2 ){
$cate3_id = $k;
break;
}
}
}
}
$category3[$cate3_id][] = $cate3;
} else {
if($category2){
$cate3_id = "";
foreach($category2 as $key => $val){
foreach($val as $k => $v){
if( $v == $cate2 ){
$cate3_id = $k;
break;
}
}
}
}
//print $cate3_id."
";
if( !in_array($cate3,$category3[$cate3_id])){
//print_r($category3[$cate3_id]);
//print "
";
$category3[$cate3_id][] = $cate3;
}
}
}
*/
}
//print_r($category2);
//print "
";
foreach($data as $key => $val ){
//print_r( $val );
//exit;
$c1 = "";
$c2 = "";
$c3 = "";
$cate1 = "";
$cate2 = "";
$cate3 = "";
list($c1,$c2,$c3) = explode("/",$val["siteid"]);
//print $val["siteid"]."
";
//print $cate1."|".$cate2."|".$cate3."
";
//exit;
if($c3){
if( !$category3 ){
if($category2){
$cate3_id = "";
foreach($category2 as $kk => $vv){
foreach($vv as $k => $v){
if( $v == $c2 ){
$cate2_id = $kk;
list($cate3_id , $g) = explode( ". " , $v);
break;
}
}
}
}
//print $cate2_id."|".$cate3_id;
$category3[$cate2_id][$cate3_id][] = $c3;
} else {
if($category2){
$cate3_id = "";
foreach($category2 as $kk => $vv){
foreach($vv as $k => $v){
if( $v == $c2 ){
$cate2_id = $kk;
list($cate3_id , $g) = explode( ". " , $v);
break;
}
}
}
}
//print $cate3_id."
";
if( !in_array($c3,$category3[$cate2_id][$cate3_id])){
//print_r($category3[$cate3_id]);
//print "
";
$category3[$cate2_id][$cate3_id][] = $c3;
}
}
}
}
//print_r($category3);
/*
$category_list = array();
$category_list2 = array();
$category_list3 = array();
foreach( $data as $key => $val ){
if(!$val->parent){
$category_list[$val->id] = $val->label;
} else {
if($category_list[$val->parent]){
$category_list2[$val->parent][$val->id] = $val->label;
} else {
$category_list3[$val->parent][$val->id] = $val->label;
}
}
}
return array($category_list,$category_list2,$category_list3);
//print_r($category_list2);
*/
//print_r($category1);
return array($category1,$category2,$category3);
}
}
function getProjectsYearNew(){
$list1 = getUrlData("/projects/read_list.php");
$list2 = getUrlData("/projects/read_list2.php");
$ch = date("Y" , mktime(1,1,1,1,1,date("Y")-5));
foreach( $list1 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
//print $val->releasedttm2."
";
}
//print $val->releasedttm2."
";
}
foreach( $list2 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
}
}
arsort($y_list);
$num = count($y_list);
if( $num < 5 ){
foreach( $y_list as $key => $val ){ $year = $y_list[$key]; break; }
$n=0;
while( $n < 5 ){
$data_year = $year+$n*-1;
$y_list[$data_year] = $data_year;
$n++;
}
}
return $y_list;
}
function getProjectsYearNewEng(){
$list1 = getUrlData("/projects/read_list_eng.php");
//$list2 = getUrlData("/projects/read_list_eng2.php");
$ch = date("Y" , mktime(1,1,1,1,1,date("Y")-5));
foreach( $list1 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
//print $val->releasedttm2."
";
}
//print $val->releasedttm2."
";
}
foreach( $list2 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
}
}
arsort($y_list);
$num = count($y_list);
if( $num < 5 ){
foreach( $y_list as $key => $val ){ $year = $y_list[$key]; break; }
$n=0;
while( $n < 5 ){
$data_year = $year+$n*-1;
$y_list[$data_year] = $data_year;
$n++;
}
}
return $y_list;
}
function getProjectsYear(){
if( date("m") < 04 ){
$year1 = date("Y" , mktime(1,1,1,1,1,date("Y")-1));
$year2 = date("Y" , mktime(1,1,1,1,1,date("Y")-2));
$year3 = date("Y" , mktime(1,1,1,1,1,date("Y")-3));
$year4 = date("Y" , mktime(1,1,1,1,1,date("Y")-4));
$year5 = date("Y" , mktime(1,1,1,1,1,date("Y")-5));
$year_list = array(
$year1 => $year1,
$year2 => $year2,
$year3 => $year3,
$year4 => $year4,
$year5 => $year5,
);
} else {
$year1 = date("Y" , mktime(1,1,1,1,1,date("Y")));
$year2 = date("Y" , mktime(1,1,1,1,1,date("Y")-1));
$year3 = date("Y" , mktime(1,1,1,1,1,date("Y")-2));
$year4 = date("Y" , mktime(1,1,1,1,1,date("Y")-3));
$year5 = date("Y" , mktime(1,1,1,1,1,date("Y")-4));
$year_list = array(
$year1 => $year1,
$year2 => $year2,
$year3 => $year3,
$year4 => $year4,
$year5 => $year5,
);
}
return $year_list;
}
function checkProjyectCategory($category,$lang=""){
if( !$lang ){
if($category == "general" ){
return '
';
} elseif($category == "spf" ){
return '
';
} elseif($category == "spinf" ){
return '
';
} elseif($category == "sjcff" ){
return '
';
} elseif($category == "spaf" ){
return '
';
} elseif($category == "smeif" ){
return '
';
} elseif($category == "scef" ){
return '';
} elseif($category == "sff" ){
return '';
} elseif($category == "SPF" ){
return '';
} elseif($category == "一般事業" ){
return '';
}
} else {
if($category == "general" ){
return '
';
} elseif($category == "spf" ){
return '
';
} elseif($category == "spinf" ){
return '
';
} elseif($category == "sjcff" ){
return '
';
} elseif($category == "spaf" ){
return '
';
} elseif($category == "smeif" ){
return '
';
} elseif($category == "scef" ){
return '';
} elseif($category == "sff" ){
return '';
} elseif($category == "SPF" ){
return '';
} elseif($category == "一般事業" ){
return '';
}
}
}
###################################################################
#
# 年度の作成
#
###################################################################
function addYearly($start , $last){
$start = $start."-04-01";
$last = $last."-04-01";
return array($start,$last);
}
###################################################################
#
# SQLのWHERE作成
#
###################################################################
function getReleasedArticleSQL($now,$tbl,$siteid=false,$langid=false,$arttype=false)
{
$t=$tbl?"$tbl.":'';
$sql= "${t}DELID=0 AND ${t}CONFID IS NOT NULL".
" AND (${t}RELEASEDTTM IS NOT NULL AND ${t}RELEASEDTTM<='$now')".
" AND (${t}ENDDTTM IS NULL OR ${t}ENDDTTM>'$now')";
if($arttype) {
if(is_array($arttype)) {
// 配列表記
$a1=Array();
$a2=Array();
foreach($arttype as $k=>$v) {
if(is_array($v)) {
// 値も配列 = サブタイプ
$a2[]="(${t}ARTTYPE=$k AND ${t}ARTSUBTYPE IN (".join(',',$v)."))";
}
else {
// 値は文字列 = タイプ
$a1[]=$v;
}
}
if($a1) {
if(count($a1)==1) $a2[]="${t}ARTTYPE=$a1[0]";
else $a2[]="${t}ARTTYPE IN (".join(',',$a1).")";
}
if($a2) {
$sql.=" AND (".join(' AND ',$a2).")";
}
unset($a1,$a2,$k,$v);
}
else {
// 文字列表記
$sql.=" AND ${t}ARTTYPE IN ($arttype)";
}
}
if($siteid) {
$ss=Array();
foreach(is_array($siteid)?$siteid:Explode(',',$siteid) as $s) {
$ss[]="'".escsql($s)."'";
}
$sql.=" AND ${t}SITEID IN (".join(',',$ss).")";
}
if($langid) $sql.=" AND ${t}LANGID='".trim($langid)."'";
return $sql;
}
###################################################################
#
# カテゴリーアイコンの表示
#
###################################################################
function categoryImage($category , $lang=""){
//print $category;
if( !$lang ){
if($category == "general" ){
return '';
} elseif($category == "spf" ){
return '';
} elseif($category == "spinf" ){
return '';
} elseif($category == "sjcff" ){
return '';
} elseif($category == "spaf" ){
return '';
} elseif($category == "smeif" ){
return '';
} elseif($category == "scef" ){
return '';
} elseif($category == "sff" ){
return '';
} elseif($category == "SPF" ){
return '';
} elseif($category == "一般事業" ){
return '';
}
} elseif( $lang == "en2" ) {
if($category == "笹川平和財団" ){
return '';
} elseif($category == "一般事業" ){
return '';
} elseif($category == "sjcff" ){
return '';
} elseif($category == "general" ){
return '';
} elseif($category == "spf" ){
return '';
} elseif($category == "spinf" ){
return '';
} elseif($category == "sjcff" ){
return '';
} elseif($category == "spaf" ){
return '';
} elseif($category == "smeif" ){
return '';
} elseif($category == "scef" ){
return '';
} elseif($category == "sff" ){
return '';
} elseif($category == "SPF" ){
return '';
} elseif($category == "一般事業" ){
return '';
}
} else {
if($category == "general" ){
return '';
} elseif($category == "spf" ){
return '';
} elseif($category == "spinf" ){
return '';
} elseif($category == "sjcff" ){
return '';
} elseif($category == "spaf" ){
return '';
} elseif($category == "smeif" ){
return '';
} elseif($category == "scef" ){
return '';
} elseif($category == "sff" ){
return '';
} elseif($category == "SPF" ){
return '';
} elseif($category == "一般事業" ){
return '';
}
}
}
function categoryNo($category){
if($category == "general" ){
return 1;
} elseif($category == "spf" ){
return 5;
} elseif($category == "spinf" ){
return 2;
} elseif($category == "sjcff" or $category == "china" ){
return 3;
} elseif($category == "spaf" ){
return 4;
} elseif($category == "smeif" ){
return 6;
} elseif($category == "scef" ){
} elseif($category == "sff" ){
} elseif($category == "SPF" ){
return 5;
} elseif($category == "一般事業" ){
return 1;
} elseif($category == "projects" ){
return 1;
}
}
function categoryUrl($category,$art_id,$path){
if($category == "general" or $category == "sjcff" or $category == "spf" or $category == "SPF" or $category == "一般事業" ){
return "article_".$art_id.".html";
} elseif($category == "spinf" ){
return "/spinf_j/".$path."/article_".$art_id.".html";
} elseif($category == "spaf" ){
return "/spaf-j/".$path."/article_".$art_id.".html";
} elseif($category == "smeif" ){
return "/smeif-j/".$path."/article_".$art_id.".html";
} elseif($category == "scef" ){
return "article_".$art_id.".html";
} elseif($category == "sff" ){
return "article_".$art_id.".html";
}
}
function categoryUrlEn($category,$art_id,$path){
if($category == "general" or $category == "sjcff" or $category == "spf" or $category == "SPF" or $category == "一般事業" ){
return "article_".$art_id.".html";
} elseif($category == "spinf" ){
return "/spinf/".$path."/article_".$art_id.".html";
} elseif($category == "spaf" ){
return "/spaf/".$path."/article_".$art_id.".html";
} elseif($category == "smeif" ){
return "/smeif/".$path."/article_".$art_id.".html";
} elseif($category == "scef" ){
return '
';
} elseif($category == "sff" ){
return '';
}
}
function categoryUrlPub($category,$art_id,$path){
if($category == "general" or $category == "sjcff" or $category == "spf" or $category == "SPF" or $category == "一般事業" ){
return "detail_".$art_id.".html";
} elseif($category == "spinf" ){
return "/spinf/spinf_j/".$path."/detail_".$art_id.".html";
} elseif($category == "spaf" ){
return "/spaf-j/".$path."/detail_".$art_id.".html";
} elseif($category == "smeif" ){
return "/smeif-j/".$path."/detail_".$art_id.".html";
} elseif($category == "scef" ){
return "detail_".$art_id.".html";
} elseif($category == "sff" ){
return "detail_".$art_id.".html";
}
}
function categoryUrlPubEn($category,$art_id,$path){
if($category == "general" or $category == "sjcff" or $category == "spf" or $category == "SPF" or $category == "一般事業" ){
return "detail_".$art_id.".html";
} elseif($category == "spinf" ){
return "/spinf/".$path."/detail_".$art_id.".html";
} elseif($category == "spaf" ){
return "/spaf/".$path."/detail_".$art_id.".html";
} elseif($category == "smeif" ){
return "/smeif/".$path."/detail_".$art_id.".html";
} else {
return "detail_".$art_id.".html";
}
}
function checkPubCategoryEng($category){
if( $category == "講演録／議事録" ){
return "Regular Publicaitons";
} elseif( $category == "書籍" ){
return "Regular Overview of Conference Transcripts/Minutes";
} elseif( $category == "調査報告書" ){
return "Overview of Books";
} elseif( $category == "定期刊行物" ){
return "Overview of Survey Reports";
} elseif( $category == "その他" ){
return "Overview of Other";
}
}
function checkSiteId($sitename){
if( $sitename == "笹川平和財団"){
return "general";
} else {
return "spf";
}
}
###################################################################
#
# プロジェクト情報用SQL
#
###################################################################
//取得
function getDataProjects($langid,$con,$y,$ny="",$site_id){
$ny = $y+1;
$sql="SELECT T1.*".
" FROM TGUIDELINEMST T1".
" WHERE T1.DELID=0 AND T1.CONFID is not null AND T1.SITEID='$site_id' AND T1.LANGID='$langid' AND T1.STARTDATE <='$y-04-01' AND (T1.ENDDATE>='$ny-04-01' OR T1.ENDDATE IS NULL )".
" AND NOT EXISTS (".
" SELECT * FROM TGUIDELINEMST T2".
" WHERE T2.DELID=0 AND T2.CONFID is not null AND T2.ORGGLID=T1.GLID".
")".
" ORDER BY T1.STARTDATE DESC ".
",T1.ENDDATE DESC";
$data = $con->getAll($sql);
if( $_SERVER['REMOTE_ADDR'] == "114.178.178.81"){
//print $sql;
}
return $data ;
}
//取得
function getDataProjectsSearch($langid,$con,$y,$ny,$site_id){
$sql="SELECT T1.*".
" FROM TGUIDELINEMST T1".
" WHERE T1.DELID=0 AND T1.CONFID is not null AND T1.SITEID='$site_id' AND T1.LANGID='$langid' ".
" AND NOT EXISTS (".
" SELECT * FROM TGUIDELINEMST T2".
" WHERE T2.DELID=0 AND T2.CONFID is not null AND T2.ORGGLID=T1.GLID".
")".
" ORDER BY T1.STARTDATE DESC ".
",T1.ENDDATE DESC";
$data = $con->getAll($sql);
return $data ;
}
function getDataProjectsSub($langid,$con,$q_glid,$site_id){
if( is_numeric($q_glid)){
$sql="SELECT T1.*".
" FROM TGUIDELINENODE T1".
" WHERE GLID=$q_glid AND UPGLNID IS NULL ".
" ORDER BY T1.so ASC ".
"";
$data = $con->getAll($sql);
return $data ;
} else {
return false;
}
}
function getDataProjectsSub2($langid,$con,$glnid,$site_id){
if( is_numeric($glnid)){
// 小分類ノード取得
$sql="SELECT GLNID,NAME FROM TGUIDELINENODE".
" WHERE UPGLNID=$glnid".
" ORDER BY SO";
$data = $con->getAll($sql);
return $data ;
} else {
return false;
}
}
function getDataProjectsMain($con,$glnid,$langid,$nowyear){
if( is_numeric($glnid)){
$sql="SELECT T1.* ".
" FROM TARTICLEPROJ T1".
" WHERE T1.GLNID=$glnid AND T1.DELID=0 AND T1.CONFID IS NOT NULL AND T1.LANGID='".$langid."' AND T1.GLYEAR=$nowyear ".
" ORDER BY (".
"SELECT MAX(GLYEAR) FROM TARTICLEPROJ T5".
" WHERE T5.RELARTID=T1.RELARTID AND T5.DELID=0".
") DESC , T1.RELARTID,T1.GLYEAR DESC";
$data = $con->getAll($sql);
return $data ;
}
}
//検索時
function getDataProjectsSearchList($langid,$con,$form,$site_id){
$nowyear = date("Y");
// ガイドライン、ガイドライン項目、事業の全てが承認されているものの条件
$sqltbl="TARTICLEPROJ T1,VGUIDELINENODE T2,TGUIDELINEMST T3";
$sqlwhere="T1.DELID=0 AND T1.CONFID IS NOT NULL AND T1.LANGID='".$langid."'".
" AND T1.GLYEAR<=$nowyear".
" AND T2.GLNID=T1.GLNID AND T2.CONFID IS NOT NULL".
" AND T3.GLID=T2.GLID AND T3.CONFID IS NOT NULL";
// 年度で絞込み
if($form["fy"]==$form["ty"]) {
if(is_numeric($form["fy"])) $sqlwhere.=" AND T1.GLYEAR=".$form["fy"];
}
else {
if(is_numeric($form["fy"])) $sqlwhere.=" AND T1.GLYEAR>=".$form["fy"];
if(is_numeric($form["ty"])) $sqlwhere.=" AND T1.GLYEAR<=".$form["ty"];
}
// 助成先もしくは助成策所在地の場合は助成で絞り込み
if($form["jc"]) {
$sqlwhere.=" AND T1.JOSEIFLG";
// 助成先タイプで絞込み
if($q_jt) {
$sqlwhere.=" AND EXISTS(".
"SELECT * FROM TPROJJOSEITYPE T4".
" WHERE T4.ARTID=T1.ARTID AND T4.JOSEITYPE IN ($q_jt)".
")";
}
// 助成先所在地で絞込み
if($form["jc"]) {
$q_jc = implode(",",$form["jc"]);
$sqlwhere.=" AND EXISTS(".
"SELECT * FROM TPROJJOSEICTRY T5".
" WHERE T5.ARTID=T1.ARTID AND T5.CTRYID IN ($q_jc)".
")";
}
}
// 事業区分で絞込み
if($form["jk"]==1) {
// 自主
$sqlwhere.=" AND T1.JISYUFLG";
}
elseif($form["jk"]==2) {
// 助成
$sqlwhere.=" AND T1.JOSEIFLG";
}
if($form["yo"]) {
$tbl=Array(
SYO_1=>Array('0','5000000'),
SYO_2=>Array('5000000','10000000'),
SYO_3=>Array('10000000','15000000'),
SYO_4=>Array('15000000','20000000'),
SYO_5=>Array('20000000','0')
);
$a=implode(',',$form["yo"]);
$r=Array();
$idx=-1;
// 範囲をまとめる
foreach($tbl as $k=>$v) {
if(!in_array($k,$a)) continue;
if($idx<0) {
$idx=0;
$r[$idx]=$v;
}
else {
if($r[$idx][1]==$v[0]) {
$r[$idx][1]=$v[1];
}
else {
$idx++;
$r[$idx]=$v;
}
}
}
// SQL化
while($idx>=0) {
while($idx>=0) {
$v=$r[$idx];
if($v[0]=='0') $r[$idx]="T1.CURYOSAN<=$v[1]";
elseif($v[1]=='0') $r[$idx]="T1.CURYOSAN>=$v[0]";
else $r[$idx]="T1.CURYOSAN BETWEEN $v[0] AND $v[1]";
$idx--;
}
$sqlwhere.=" AND (".join(' OR ',$r).")";
}
unset($r,$a,$tbl);
}
// クエリ文字列で絞込み
if($form["word"]) {
@require_once 'libSearch.inc';
$sql.=compileQuery($form["word"],'T1.FINDTEXT');
if($sql) $sqlwhere.=" AND $sql";
}
// 基金・ガイドラインで絞込み
$siteids=false;
{
$wheres=Array();
$exsites=Array(); // 除外サイト
if( !$form["gl"] and $form["gl2"]){
return false;
}
// ガイドラインで絞込み
if($form["gl"]) {
if($form["s"]) {
foreach($form["gl"] as $key => $val ){
if(is_numeric($val)){
if(!$q_gl){
$q_gl = $val;
} else {
$q_gl .= ",".$val;
}
} else {
if(!$q_gl){
$q_gl = "'".$val."'";
} else {
$q_gl .= ",'".$val."'";
}
}
}
// ガイドライン指定の基金絞込みを除外する
$sql="SELECT DISTINCT SITEID FROM TGUIDELINEMST".
" WHERE GLID IN (".
"SELECT GLID FROM TGUIDELINENODE WHERE GLNID IN ($q_gl)".
")";
$exsites=$con->getAll($sql);
if($exsites){
foreach( $exsites as $key => $val ){
if( $val ){
foreach( $val as $k => $v ){
$exsites2[$k] = $v;
}
}
}
}
} else {
foreach($form["gl"] as $key => $val ){
if(is_numeric($val)){
if(!$q_gl){
$q_gl = $val;
} else {
$q_gl .= ",".$val;
}
} else {
if(!$q_gl){
$q_gl = "'".$val."'";
} else {
$q_gl .= ",'".$val."'";
}
}
}
}
if($q_gl){
$wheres[]="T2.GLNID1 IN ($q_gl)";
$wheres[]="T2.GLNID2 IN ($q_gl)";
//print_r($q_gl);
}
}
// 基金で絞込み
if(true||$site_id=='spf') {
if($form["s"]) {
$a=Array();
foreach($form["s"] as $v) {
if($v == "scef"){
if($v&&!in_array($v,$exsites)) $a[]="'".stripslashes(htmlspecialchars("spfa"))."'";
} else {
if($v&&!in_array($v,$exsites)) $a[]="'".stripslashes(htmlspecialchars($v))."'";
}
}
$siteids=join(',',$a);
if($a) $wheres[]="T1.SITEID IN ($siteids)";
unset($a);
}
}
else {
if(!in_array($site_id,$exsites)) $wheres[]="T1.SITEID='".$site_id."'";
}
if($wheres) $sqlwhere.=" AND (".join(' OR ',$wheres).")";
unset($wheres,$exsites);
}
$sql="SELECT T1.ARTID,T1.ORGARTID,T1.GLYEAR,T1.NUMYEARS,T1.CURYEAR,T1.TITLE , T1.releasedttm".
",T1.JISYUFLG,T1.ITAKUFLG,T1.JOSEIFLG,T1.OTHERFLG".
",T1.JISYUNAME,T1.ITAKUNAME,T1.JOSEINAME,T1.OTHERNAME ".
",T1.CURYOSAN,T1.CURYOSANDETAIL".
",T1.SITEID,TS.ARTNAME AS SITEARTNAME,TS.SHORTNAME AS SITESHORTNAME".
" FROM $sqltbl,TSITE TS".
" WHERE ".$sqlwhere.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.GLYEAR DESC,T1.SO ";
$res=$con->getAll($sql);
if(PEAR::isError($res)) {
return false;
}else{
return $res;
}
//print_r( $data );
}
function engType( $type ){
$type = ereg_replace( "自主" , "Self Operated" , $type);
$type = ereg_replace( "委託" , "Commissioned" , $type);
$type = ereg_replace( "助成" , "Grant" , $type);
$type = ereg_replace( "その他" , "Other" , $type);
return $type;
}
//英語版の事業名の検索
function chechEngName($name,$list){
foreach( $list as $key => $val ){
if( trim($val->ja) == trim($name) ){
//print 213;
return $val->en;
break;
}
}
}
###################################################################
#
# セミナー情報用SQL
#
###################################################################
// 日付範囲の判定
// $now 判定日(YYYY-MM-DD)
// $startdt 期間開始日(YYYY-MM-DD もしくはヌルストリングス)
// $enddt 期間終了日(YYYY-MM-DD もしくはヌルストリングス)
// $eventflg イベント用フラグ 0:期間判定を行う 1:常に'期間内' -1:常に'期間後'
// $endok 期間終了日を期間内とするなら true
// return 0:期間内 負:期間前 正;期間後
function checkArticlePeriod($now,$startdt,$enddt,$eventflg=0,$endok=false)
{
if(strlen($startdt)>10) $startdt=substr($startdt,0,10);
if(strlen($enddt)>10) $enddt=substr($enddt,0,10);
if($startdt&&$startdt>$now) return -1; // 期間前
if($enddt) {
if($endok) {
if($enddt<$now) return 1; // 期間後
}
else {
if($enddt<=$now) return 1; // 期間後
}
}
return 0; // 期間中
}
function checkSeminarData($y,$con){
$ny = $y+1;
$tbl = 'TARTICLEEVENT';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC LIMIT 1";
//print $sql;
//print $sql;
$data = $con->getRow($sql);
if($data){
return true;
} else {
return false;
}
//print_r( $data );
return $data;
}
//取得
function getDataSeminar($langid,$con,$y,$ny){
$tbl = 'TARTICLEEVENT';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
return $data;
}
function getDataSeminarTop($langid,$con,$y,$ny){
$tbl = 'TARTICLEEVENT';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC LIMIT 10";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
return $data;
}
function getDataSeminarJson($langid,$con,$y,$ny){
$tbl = 'TARTICLEEVENT';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-01-01' AND T1.ARTDATE<'$y-12-31'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
return $data;
}
###################################################################
#
# メディア用SQL
#
###################################################################
//取得
function getDataMedia($langid,$con,$y,$ny){
//記事タイプ
$arttype[2][0] = 4;
$tbl = 'TARTICLENEWS';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
return $data;
}
function getDataMediaTop($langid,$con,$y,$ny){
$y = 2008;
//記事タイプ
$arttype[2][0] = 4;
$tbl = 'TARTICLENEWS';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
return $data;
}
###################################################################
#
# 新着情報用SQL
#
###################################################################
//カウント
function getCountNews($lang,$con,$y,$ny){
$tbl='TARTICLENEWS';
$wheresql2=" T1.LANGID = '".$lang."' AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT COUNT(*) FROM $tbl T1 WHERE ".$wheresql2;
$num = $con->getOne( $sql );
return $num;
}
function checkYearNewsData($y,$list){
$ny = $y+1;
if( $list ){
foreach( $list as $key => $val ){
if($val["releasedttm"]>=$y.'-04-01' and $val["releasedttm"]<$ny.'-04-01'){
return true;
}
}
}
}
//取得
function getDataNews($langid,$con,$y,$ny){
//記事タイプ
$arttype = "";
$tbl = 'TARTICLENEWS';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
//print count($data);
return $data;
}
function getDataNewsTop($langid,$con,$y,$ny){
//記事タイプ
$arttype = "";
$tbl = 'TARTICLENEWS';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC LIMIT 10";
//print $sql;
$data = $con->getAll($sql);
//print_r( $data );
return $data;
}
###################################################################
#
# 出版物用SQL
#
###################################################################
//カウント
function getCountPublication($lang,$con,$y,$ny){
$tbl='TARTICLEBASE';
$wheresql2=" T1.LANGID = '".$lang."' AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01' ";
$sql="SELECT COUNT(*) FROM $tbl T1 WHERE ".$wheresql2;
$num = $con->getOne( $sql );
return $num;
}
function getArticleListColsSQL($tbl)
{
$t=$tbl?"$tbl.":'';
return "${t}ARTID,${t}SITEID,${t}LANGID,${t}ARTTYPE,${t}ARTSUBTYPE,${t}ARTDATE,${t}TITLE,${t}URL,${t}THUMBID";
}
//取得
function getDataPublication($lang,$con,$y,$ny,$pubtype=""){
$tbl='TARTICLEBASE';
$wheresql2=" T1.LANGID = '".$lang."' AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01' AND T1.CONFID is not NULL AND T1.DELID=0 ";
if( is_numeric($pubtype)){
$wheresql2 .=" AND T1.PUBTYPE = '".$pubtype."' ";
}
$sql="SELECT COUNT(*) FROM $tbl T1 WHERE ".$wheresql2;
$sql="SELECT ".
"T1.*".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM TARTICLEPUBLISH T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID) AND T1.siteid NOT IN ('general','spf','sjcff') AND T1.artid != 9013 ".
" ORDER BY T1.ARTDATE DESC,T1.ARTID";
$data = $con->getAll($sql);
if( $_SERVER['REMOTE_ADDR'] == "114.178.178.81"){
//print $sql;
}
/*
} else {
$tbl='TARTICLEBASE';
$wheresql2=" T1.LANGID = '".$lang."' AND T1.ARTDATE>='$y-04-01' AND T1.ARTDATE<'$ny-04-01' AND T1.siteid != 'scef' ";
if( is_numeric($pubtype)){
$wheresql2 .=" AND T1.PUBTYPE = '".$pubtype."' ";
}
$sql="SELECT COUNT(*) FROM $tbl T1 WHERE ".$wheresql2;
$sql="SELECT ".
"T1.*".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM TARTICLEPUBLISH T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID) AND T1.siteid NOT IN ('general','spf','sjcff') AND T1.artid != 9013 ".
" ORDER BY T1.ARTDATE DESC,T1.ARTID";
$data = $con->getAll($sql);
}
*/
//print $sql;
//print_r( $data );
return $data;
}
function getDataPublicationSearch($lang,$con,$form,$site_id){
$now = date("Y-m-d");
// 掲載中の出版物条件
$sqltbl="TARTICLEPUBLISH T1";
$sqlwhere=getReleasedArticleSQL($now,'T1',false,$lang);
// タイプで絞込み
$types=false;
if($form["t"]) {
$a=array();
foreach($form["t"] as $key => $v) {
if( is_numeric($v)){
$a[$key] = $v;
}
}
$types = implode(",",$a);
if($types) $sqlwhere.=" AND T1.PUBTYPE IN ($types)";
unset($a);
}
// 基金で絞込み
$siteids=false;
if($site_id=='spf') {
if($form["s"]) {
$a2=array();
foreach($form["s"] as $key => $v) {
if( $v ){
$a2[$key] = "'".$v."'";
}
}
if($a2){
$siteids=implode(',',$a2);
if($a2) $sqlwhere.=" AND T1.SITEID IN ($siteids)";
unset($a2);
} else {
$siteids='all';
}
unset($a);
}
}
else {
$sqlwhere.=" AND T1.SITEID='".$site_id."'";
}
//AND T1.siteid != 'scef'
if( is_numeric($form["fy"])){
$q_fy=$form["fy"]; // 年From
}
if( is_numeric($form["ty"])){
$q_ty=$form["ty"]; // 年To
}
// 年で絞込み
if($q_fy) $sqlwhere.=" AND T1.ARTDATE>='$q_fy-01-01'";
if($q_ty) $sqlwhere.=" AND T1.ARTDATE<'".($q_ty+1)."-01-01'";
$q_q=$form['q']; // 検索クエリ
// クエリ文字列で絞込み
if($q_q) {
include_once 'libSearch.inc';
$sql.=compileQuery($q_q,'T1.FINDTEXT');
if($sql) $sqlwhere.=" AND $sql";
}
$sql="SELECT T1.ARTID,T1.ORGARTID,T1.ARTDATE,T1.ARTDATESTR".
",T1.PUBTYPE,T1.TITLE,T1.AUTHOR,T1.PRICESTR,T1.BIKOU".
",T1.SITEID,TS.ARTNAME AS SITEARTNAME,TS.SHORTNAME AS SITESHORTNAME".
" FROM $sqltbl,TSITE TS".
" WHERE ".$sqlwhere.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID) AND T1.siteid NOT IN ('general','spf','sjcff','scef') AND T1.artid != 9013".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC";
$data=$con->getAll($sql);
//$data = $con->getAll($sql);
//print $sql;
//print_r( $data );
//exit;
return $data;
}
//英語版判定
function checkEngPubType($type){
if($type == "笹川平和財団"){
return "SPF";
} else {
return "Regular";
}
}
function imageAdd($image_id,$img_php_dir,$img_dir,$size){
global $recnum;
//print_r($recnum);
global $con;
$sql = " SELECT * FROM timageobj WHERE imgid = '".$image_id."' ";
$data = $con->getRow($sql);
//ファイル名を作成
$nm=$image_id*1;
$nm.=substr(md5("obj:$image_id"),0,6);
$nm.=".".$data["ext"];
if( file_exists(HOME_DIR.$img_dir.$nm)){
print "![](".$img_php_dir.$img_dir.$nm."&w=".$size.")
";
} else {
if( file_exists(HOME_DIR."sasakawa_admin/dbfiles/".$nm)){
@copy(HOME_DIR."sasakawa_admin/dbfiles/".$nm,HOME_DIR.$img_dir.$nm);
if( file_exists(HOME_DIR.$img_dir.$nm)){
print "";
}
}
}
}
//ページャー
function pagerList($max_page,$now_page,$url,$form=""){
//print $max_page."|".$now_page."|".$url;
global $pager;
echo $pager->doIt($max_page*10);
/*
$url = "";
$url = explode("?",$_SERVER['REQUEST_URI']);
if( $form ){
foreach( $form as $key => $val ){
if( $key != "page" ){
if( is_array($val)){
foreach($val as $k => $v ){
$ops .= "&".$key."[]=".$v;
}
} else {
$ops .= "&".$key."=".$val;
}
}
}
}
//print $ops;
echo "";
//↓表示最大数が１０未満でページ表示数が１(表示数１ならページングする必要がない）でなければ・・・
if(($max_page <= 5) && ($max_page != 1)){
for($i=1;$i<=$max_page;$i++){
if($now_page == $i){
echo '';
}else{
echo '- '.$i.$ops.'
';
}
}
//↓最大表示数が5以上で現在のページが６未満なら・・・
}elseif(($max_page > 5) && ($now_page<4)){
for($a=1;$a<=5;$a++){
if($now_page == $a){
echo '';
}else{
echo '- '.$a.'
';
}
}
if( ($now_page+5) > $max_page ){
$dot_page = $now_page+5;
} else {
$dot_page = $max_page;
}
echo '- …
';
echo '- >
';
//↓最大表示数が5以上で現在のページが１０未満なら・・・
}elseif(($max_page > 5) && ($now_page<10) && ($max_page<10)){
echo '- <
';
for($a=($now_page-2);$a<=$max_page;$a++){
if($now_page == $a){
echo '';
}else{
echo '- '.$a.'
';
}
}
//↓最大表示数が１０以上かつ、現在のページが６以上かつ最終ページより５ページ以内にいなければ・・・
}elseif(($max_page > 5) && ($now_page>=4) && (($now_page+5) < $max_page)){
echo '- <
';
$back = $now_page-5;
if( $back <= 0 ){
$back = 1;
}
echo '- …
';
for($a=1;$a<=5;$a++){
$nn = $now_page-5+$a;
}
for($a=($now_page-2);$a<=($now_page-2+4);$a++){
$nn = $a;
if($now_page == $nn){
echo '';
}else{
echo '- '.$nn.'
';
}
}
if( ($now_page+5) > $max_page ){
$dot_page = $now_page+5;
} else {
$dot_page = $max_page;
}
echo '- …
';
echo '- >
';
//↓最大表示数が１０以上かつ、現在のページも6以上かつ、
//↓現在のページが最終ページから５ページ以内にいる場合の処理
}elseif(($max_page > 10) && ($now_page>=4) && (($now_page+5) >= $max_page)){
echo '- <
';
echo '- …
';
$b = $max_page-10;
while($b <= $max_page){
if($now_page == $b){
echo '';
}else{
echo '- '.$b.'
';
}
$b++;
}
}
*/
}
function pagerList2($max_page,$now_page,$url,$form=""){
global $pager2;
echo $pager2->doIt($max_page*10);
}
$publication_category_arr = array(
"1"=>"講演録／議事録",
"2"=>"書籍",
"3"=>"調査報告書",
"4"=>"定期刊行物",
"0"=>"その他",
);
$publication_en_category_arr = array(
"1"=>"Regular Publicaitons",
"2"=>"Overview of Conference Transcripts/Minutes",
"3"=>"Overview of Books",
"4"=>"Overview of Survey Reports",
"0"=>"Overview of Other",
);
function getViewYear(){
$start = date("Y");
//$stop = 1993;
$stop = 1986;
for($i=$start;$i>=$stop;$i--){
$date[ $i ] = $i."年";
}
return $date;
}
function getViewYearEng(){
$start = date("Y");
//$stop = 1993;
$stop = 1986;
for($i=$start;$i>=$stop;$i--){
$date[ $i ] = "FY".$i;
}
return $date;
}
//サニタイズ
function Clear($request){
if(!$request) return false;
$arr = array();
foreach($request as $key => $val ){
if( is_array($val)){
foreach($val as $k => $v){
// 制御文字か否か
if (preg_match('/\A\P{Cc}{0,100}\z/u', $v) != 1) {
return false;
}
$arr[$key][$k] = stripslashes(htmlspecialchars(trim($v)));
//$arr[$key][$k] = preg_replace('/"/' , """, $arr[$key][$k]);
$arr[$key][$k] = preg_replace('/(\'|�*39;)/', ''', $arr[$key][$k]);
//$arr[$key][$k] = str_replace("'", "'", $arr[$key][$k]);
// ../を除去
$arr[$key][$k] = preg_replace('/\.\.\//' , "", $arr[$key][$k]);
// ./を除去
$arr[$key][$k] = preg_replace('/\.\//' , "", $arr[$key][$k]);
}
} else {
// 制御文字か否か
if (preg_match('/\A\P{Cc}{0,100}\z/u', $val) != 1) {
return false;
}
$arr[$key] = stripslashes(htmlspecialchars(trim($val)));
//$arr[$key] = preg_replace('/"/' , """, $arr[$key]);
$arr[$key] = preg_replace('/(\'|�*39;)/', ''', $arr[$key]);
//$arr[$key] = str_replace("'", "'", $arr[$key]);
// ../を除去
$arr[$key] = preg_replace('/\.\.\//' , "", $arr[$key]);
// ./を除去
$arr[$key] = preg_replace('/\.\//' , "", $arr[$key]);
}
}
return $arr;
}
//年度リストの表示
function viewYear($start,$lang="ja"){
$list = array();
$now = date("m");
if( $now < 4 ){
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")-1));
} else {
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")));
}
$n=0;
while( true ){
$y = $start+$n;
if( $lang == "ja" ){
$list[$y] = $y."年度";
} else {
$list[$y] = "FY".$y;
}
if( $y == $finish ){
break;
}
$n++;
}
arsort($list);
return $list;
}
function viewYearPub($start,$lang="ja"){
//print_r($recnum[0]["releasedttm"]);
//
/*if( $lang == "ja" ){
if($view == "英語サイトにのみ表示"){
return false;
}
} else {
if($view == "日本語サイトにのみ表示"){
return false;
}
}*/
global $con;
$list1 = getMtArticle(6);
$list2 = getMtArticle(8);
$recnum = getDataPublication($lang,$con,2009,date("Y"));
if( $list1 ){
foreach($list1 as $key => $val){
$releasedttm = "";
$title = "";
foreach( $val->customFields as $k => $v){
if( $lang == "ja" ){
if( $v->show_lang_entry == "英語サイトにのみ表示" ){
continue;
}
} elseif( $lang == "en" ){
if( $v->show_lang_entry == "日本語サイトにのみ表示" ){
continue;
}
}
if( $v->basename == "pub_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
if( $v->basename == "pub_title_eng"){
$title = $v->value;
}
}
if( $lang == "en" and !$title ){
continue;
}
list($y,$m,$d) = explode("-",$releasedttm);
if($m < 04){
$y = $y-1;
}
if($y>=2009){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
} else {
//print $releasedttm."|".$val->title."
";
}
}
}
//print_r($y_list);
if( $list2 ){
foreach($list2 as $key => $val){
$releasedttm = "";
foreach( $val->customFields as $k => $v){
if( $lang == "ja" ){
if( $v->show_lang_entry == "英語サイトにのみ表示" ){
continue;
}
} elseif( $lang == "en" ){
if( $v->show_lang_entry == "日本語サイトにのみ表示" ){
continue;
}
}
if( $v->basename == "pub_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
if( $v->basename == "pub_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
if( $v->basename == "pub_title_eng"){
$title = $v->value;
}
}
if( $lang == "en" and !$title ){
continue;
}
list($y,$m,$d) = explode("-",$releasedttm);
if($m < 04){
$y = $y-1;
}
if($y>=2009){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
} else {
//print $releasedttm."|".$val->title."
";
}
//print $val["releasedttm"]."|".$val["title"]."
";
}
}
foreach( $recnum as $key => $val ){
if( $val["releasedttm"] >=2009){
list($y,$m,$d) = explode( "-" , $val["releasedttm"]);
if($m < 04){
$y = $y-1;
}
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
}
//print $val->releasedttm2."
";
}
//exit;
arsort($y_list);
return $y_list;
/*
foreach( $list1 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
//print $val->releasedttm2."
";
}
//print $val->releasedttm2."
";
}
*/
$list = array();
$now = date("m");
if( $now < 4 ){
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")-1));
} else {
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")));
}
$n=0;
while( true ){
$y = $start+$n;
if( $lang == "ja" ){
$list[$y] = $y."年度";
} else {
$list[$y] = "FY".$y;
}
if( $y == $finish ){
break;
}
$n++;
}
arsort($list);
return $list;
}
function viewYearNews($start,$lang="ja"){
global $con;
$list1 = getMtArticle(3);
$list2 = getMtArticle(5);
$recnum = getDataNews($lang,$con,2006,date("Y"));
//print_r($recnum);
if( $list1 ){
foreach($list1 as $key => $val){
$releasedttm = "";
foreach( $val->customFields as $k => $v){
if( $lang == "ja" ){
if( $v->show_lang_entry == "英語サイトにのみ表示" ){
continue;
}
} elseif( $lang == "en" ){
if( $v->show_lang_entry == "日本語サイトにのみ表示" ){
continue;
}
}
if( $v->basename == "news_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
}
list($y,$m,$d) = explode("-",$releasedttm);
if($m < 04){
$y = $y-1;
}
if($y>=2006){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
} else {
//print $releasedttm."|".$val->title."
";
}
}
}
if( $list2 ){
foreach($list2 as $key => $val){
$releasedttm = "";
foreach( $val->customFields as $k => $v){
if( $lang == "ja" ){
if( $v->show_lang_entry == "英語サイトにのみ表示" ){
continue;
}
} elseif( $lang == "en" ){
if( $v->show_lang_entry == "日本語サイトにのみ表示" ){
continue;
}
}
if( $v->basename == "news_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
}
list($y,$m,$d) = explode("-",$releasedttm);
if($m < 04){
$y = $y-1;
}
if($y>=2006){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
} else {
//print $releasedttm."|".$val->title."
";
}
//print $val["releasedttm"]."|".$val["title"]."
";
}
}
foreach( $recnum as $key => $val ){
list($y,$m,$d) = explode( "-" , $val["releasedttm"]);
if($m < 04){
$y = $y-1;
}
if( $y >=2006){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
}
//print $val->releasedttm2."
";
}
arsort($y_list);
//print_r($y_list);
return $y_list;
/*
foreach( $list1 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
//print $val->releasedttm2."
";
}
//print $val->releasedttm2."
";
}
*/
$list = array();
$now = date("m");
if( $now < 4 ){
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")-1));
} else {
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")));
}
$n=0;
while( true ){
$y = $start+$n;
if( $lang == "ja" ){
$list[$y] = $y."年度";
} else {
$list[$y] = "FY".$y;
}
if( $y == $finish ){
break;
}
$n++;
}
arsort($list);
return $list;
}
function viewYearPub2($start,$lang="ja"){
//print_r($recnum[0]["releasedttm"]);
//
/*if( $lang == "ja" ){
if($view == "英語サイトにのみ表示"){
return false;
}
} else {
if($view == "日本語サイトにのみ表示"){
return false;
}
}*/
global $con;
$list1 = getMtArticle(6);
$list2 = getMtArticle(8);
$recnum = getDataPublication($lang,$con,2009,date("Y"));
if( $list1 ){
foreach($list1 as $key => $val){
$releasedttm = "";
foreach( $val->customFields as $k => $v){
if( $lang == "ja" ){
if( $v->show_lang_entry == "英語サイトにのみ表示" ){
continue;
}
} elseif( $lang == "en" ){
if( $v->show_lang_entry == "日本語サイトにのみ表示" ){
continue;
}
}
if( $v->basename == "pub_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
}
list($y,$m,$d) = explode("-",$releasedttm);
if($y>=2009){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
} else {
//print $releasedttm."|".$val->title."
";
}
}
}
if( $list2 ){
foreach($list2 as $key => $val){
$releasedttm = "";
foreach( $val->customFields as $k => $v){
if( $lang == "ja" ){
if( $v->show_lang_entry == "英語サイトにのみ表示" ){
continue;
}
} elseif( $lang == "en" ){
if( $v->show_lang_entry == "日本語サイトにのみ表示" ){
continue;
}
}
if( $v->basename == "pub_date"){
$releasedttm = date( "Y-m-d" ,strtotime( $v->value ));
}
}
list($y,$m,$d) = explode("-",$releasedttm);
if($y>=2009){
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
} else {
//print $releasedttm."|".$val->title."
";
}
//print $val["releasedttm"]."|".$val["title"]."
";
}
}
foreach( $recnum as $key => $val ){
if( $val["releasedttm"] >=2009){
list($y,$m,$d) = explode( "-" , $val["releasedttm"]);
if( $lang == "ja" ){
$y_list[$y] = $y."年度";
} else {
$y_list[$y] = "FY".$y;
}
}
//print $val->releasedttm2."
";
}
arsort($y_list);
//print_r($y_list);
return $y_list;
/*
foreach( $list1 as $key => $val ){
if( $val->releasedttm2 >= $ch ){
list($y,$m,$d) = explode( "-" , $val->releasedttm2);
$y_list[$y] = $y;
//print $val->releasedttm2."
";
}
//print $val->releasedttm2."
";
}
*/
$list = array();
$now = date("m");
if( $now < 4 ){
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")-1));
} else {
$finish = date( "Y" , mktime(0,0,0,1,1,date("Y")));
}
$n=0;
while( true ){
$y = $start+$n;
if( $lang == "ja" ){
$list[$y] = $y."年度";
} else {
$list[$y] = "FY".$y;
}
if( $y == $finish ){
break;
}
$n++;
}
arsort($list);
return $list;
}
function getViewYearPub(){
$start = date("Y");
$stop = 1993;
for($i=$start;$i>=$stop;$i--){
$date[ $i ] = $i."年";
}
return $date;
}
function getViewYearPubEng(){
$start = date("Y");
$stop = 1993;
for($i=$start;$i>=$stop;$i--){
$date[ $i ] = "FY".$i;
}
return $date;
}
//サイトに表示するかの判別
function checkSiteView($view,$lang){
if( $lang == "ja" ){
if($view == "英語サイトにのみ表示"){
return false;
}
} else {
if($view == "日本語サイトにのみ表示"){
return false;
}
}
return true;
}
function changeDate($date){
$date = ereg_replace("\.","-",$date);
$date = ereg_replace("開催","",$date);
return $date;
}
//セミナー用の年度別アーカイブ
function viewYearEvent($langid){
global $con;
$baseurl = 'http://'.SERVER_ADDR.'/event/years.php';
$l = file_get_contents($baseurl);
$l = json_decode($l);
$start = date("Y")+1;
$finish = 1990;
while(true){
$start = $start-1;
$tbl = 'TARTICLEEVENT';
$now = date("Y-m-d H:i:s");
$wheresql=getReleasedArticleSQL($now,'T1',$siteid,$langid,$arttype);
$wheresql2="$wheresql AND T1.ARTDATE>='".$start."-04-01' AND T1.ARTDATE<'".($start+1)."-04-01'";
$sql="SELECT T1.* ".
",TS.NAME AS SITENAME,TS.SHORTNAME AS SITESHORTNAME,TS.ARTNAME AS SITEARTNAME".
" FROM $tbl T1,TSITE TS".
" WHERE ".$wheresql2.
" AND (TS.SITEID=T1.SITEID AND TS.LANGID=T1.LANGID)".
" ORDER BY T1.ARTDATE DESC,T1.ARTID DESC LIMIT 1";
$data = "";
$data = $con->getRow($sql);
if( $data ){
if( $langid == "en" ){
$list[$start] = "FY".$start;
} else {
$list[$start] = $start."年";
}
}
if( $finish == $start ){
break;
}
}
foreach( $l as $key => $val ){
if( $langid == "en" ){
$list[$val] = "FY".$val;
} else {
$list[$val] = $val."年";
}
}
arsort($list);
return $list;
}
//画像を取得
function getSrc($image){
//print_r($image);
//print "
";
//print $image."234";
$pat = '/src=["\']?([^"\' ]*?\/[a-z0-9\.]+\/)([a-z0-9_]*)\.([a-z0-9]+)\"/i' ;
preg_match_all("/(.+?)<\/a>/mis",$image,$matches);
if( $matches[1][0]){
$href = preg_replace( "/\"/" , "" , $matches[1][0] );
$href = str_replace( "http://".SERVER_ADDR."/" , "" , $href );
}
//print $href."
";
/*
if( $_SERVER['REMOTE_ADDR'] == "221.113.50.86" ){
$href = preg_replace( "/\"/" , "" , $matches[1][0] );
$href = str_replace( "http://".SERVER_ADDR."/" , "" , $href );
print_r($href);
print "
";
}
*/
return $href;
}
//検索用の配列
$search_s_arr = array(
"general"=>"一般事業",
"spinf"=>"笹川太平洋島嶼国基金",
"sjcff"=>"笹川日中友好基金",
"smeif"=>"笹川中東イスラム基金",
"spaf"=>"笹川汎アジア基金",
"scef"=>"笹川中欧基金",
);
$search_jc_arr[113] = "韓国";
$search_jc_arr[125] = "台湾";
$search_jc_arr[127] = "中国";
$search_jc_arr[131] = "日本";
$search_jc_arr[148] = "モンゴル";
$search_jc_arr[151] = "ロシア";
$search_jc_arr[104] = "インドネシア";
$search_jc_arr[114] = "カンボジア";
$search_jc_arr[119] = "シンガポール";
$search_jc_arr[124] = "タイ";
$search_jc_arr[136] = "フィリピン";
$search_jc_arr[140] = "ベトナム";
$search_jc_arr[143] = "マレーシア";
$search_jc_arr[146] = "ミャンマー";
$search_jc_arr[150] = "ラオス";
$search_jc_arr[103] = "インド";
$search_jc_arr[122] = "スリランカ";
$search_jc_arr[101] = "アゼルバイジャン";
$search_jc_arr[105] = "ウズベキスタン";
$search_jc_arr[111] = "カザフスタン";
$search_jc_arr[116] = "グルジア";
$search_jc_arr[133] = "パレスチナ";
$search_jc_arr[149] = "ヨルダン";
$search_jc_arr[112] = "カナダ";
$search_jc_arr[139] = "米国";
$search_jc_arr[102] = "アルゼンチン";
$search_jc_arr[128] = "チリ";
$search_jc_arr[137] = "ブラジル";
$search_jc_arr[147] = "メキシコ";
$search_jc_arr[106] = "英国";
$search_jc_arr[108] = "エストニア";
$search_jc_arr[110] = "オランダ";
$search_jc_arr[120] = "スイス";
$search_jc_arr[121] = "スウェーデン";
$search_jc_arr[123] = "スロバキア";
$search_jc_arr[126] = "チェコ";
$search_jc_arr[129] = "デンマーク";
$search_jc_arr[130] = "ドイツ";
$search_jc_arr[134] = "ハンガリー";
$search_jc_arr[138] = "フランス";
$search_jc_arr[141] = "ベルギー";
$search_jc_arr[142] = "ポーランド";
$search_jc_arr[107] = "エジプト";
$search_jc_arr[117] = "ケニア";
$search_jc_arr[145] = "南アフリカ";
$search_jc_arr[109] = "オーストラリア";
$search_jc_arr[115] = "クック諸島";
$search_jc_arr[118] = "サモア";
$search_jc_arr[132] = "ニューカレドニア";
$search_jc_arr[135] = "フィジー";
$search_jc_arr[144] = "ミクロネシア";
$search_jk_arr = array(
"SJK_ALL"=>"全て",
"1"=>"自主",
"2"=>"助成",
);
$search_yo_arr = array(
"1"=>"〜5,000,000円",
"2"=>"5,000,000円〜10,000,000円",
"3"=>"10,000,000円〜15,000,000円",
"4"=>"15,000,000円〜20,000,000円",
"5"=>"20,000,000円〜",
);
//英語版
//検索用の配列
$search_s_eng_arr = array(
"general"=>"Regular Projects",
"spinf"=>"The Sasakawa Pacific Island Nations Fund",
"sjcff"=>"The Sasakawa Japan-China Friendship Fund",
"smeif"=>"The Sasakawa Middle East Islam Fund",
"spaf"=>"The Sasakawa Pan Asia Fund",
"scef"=>"The Sasakawa Central Europe Fund",
);
$search_jc_eng_arr[113] = "Korea";
$search_jc_eng_arr[125] = "Taiwan";
$search_jc_eng_arr[127] = "China";
$search_jc_eng_arr[131] = "Japan";
$search_jc_eng_arr[148] = "Mongolia";
$search_jc_eng_arr[151] = "Russia";
$search_jc_eng_arr[104] = "Indonesia";
$search_jc_eng_arr[114] = "Cambodia";
$search_jc_eng_arr[119] = "Singapore";
$search_jc_eng_arr[124] = "Thailand";
$search_jc_eng_arr[136] = "Philippines";
$search_jc_eng_arr[140] = "Vietnam";
$search_jc_eng_arr[143] = "Malaysia";
$search_jc_eng_arr[146] = "Myammar";
$search_jc_eng_arr[150] = "Laos";
$search_jc_eng_arr[103] = "India";
$search_jc_eng_arr[122] = "Sri Lanka";
$search_jc_eng_arr[101] = "Azerbaijan";
$search_jc_eng_arr[105] = "Uzbekistan";
$search_jc_eng_arr[111] = "Kazakhstan";
$search_jc_eng_arr[116] = "Georgia";
$search_jc_eng_arr[133] = "Palestine";
$search_jc_eng_arr[149] = "Jordan";
$search_jc_eng_arr[112] = "Canada";
$search_jc_eng_arr[139] = "USA";
$search_jc_eng_arr[102] = "Argentina";
$search_jc_eng_arr[128] = "Chile";
$search_jc_eng_arr[137] = "Brazil";
$search_jc_eng_arr[147] = "Mexico";
$search_jc_eng_arr[106] = "UK";
$search_jc_eng_arr[108] = "Estonia";
$search_jc_eng_arr[110] = "Holland";
$search_jc_eng_arr[120] = "Switzerland";
$search_jc_eng_arr[121] = "Sweden";
$search_jc_eng_arr[123] = "Slovakia";
$search_jc_eng_arr[126] = "Czech Republic";
$search_jc_eng_arr[129] = "Denmark";
$search_jc_eng_arr[130] = "Germany";
$search_jc_eng_arr[134] = "Hungary";
$search_jc_eng_arr[138] = "France";
$search_jc_eng_arr[141] = "Belgium";
$search_jc_eng_arr[142] = "Poland";
$search_jc_eng_arr[107] = "Egypt";
$search_jc_eng_arr[117] = "Kenya";
$search_jc_eng_arr[145] = "South Africa";
$search_jc_eng_arr[109] = "Australia";
$search_jc_eng_arr[115] = "Cook Islands";
$search_jc_eng_arr[118] = "Samoa";
$search_jc_eng_arr[132] = "Nouvelle-Calédonie";
$search_jc_eng_arr[135] = "Fiji";
$search_jc_eng_arr[144] = "Micronesia";
$search_jk_eng_arr = array(
"SJK_ALL"=>"All",
"1"=>"Self-Operated project",
"2"=>"Grant project",
);
$search_yo_eng_arr = array(
"1"=>"Less than 5,000,000yen",
"2"=>"Over 5,000,000yen less than 10,000,000yen",
"3"=>"Over 10,000,000yen less than 15,000,000yen",
"4"=>"Over 15,000,000yen less than 20,000,000yen",
"5"=>"Over 20,000,000yen",
);
$site_type_arr = array(
"general"=>"一般事業" ,
"spf"=>"SPF" ,
);
$view_site_arr = array(
"ja"=>"日本語サイトにのみ表示" ,
"en"=>"英語サイトにのみ表示" ,
);
function projectPlaceEng($v){
$l = array(
'アゼルバイジャン'=>'Azerbaijan'
,'アルゼンチン'=>'Argentina'
,'インドネシア'=>'Indonesia'
,'インド'=>'India'
,'ウズベキスタン'=>'Uzbekistan'
,'英国'=>'UK'
,'エジプト'=>'Egypt'
,'エストニア'=>'Estonia'
,'オーストラリア'=>'Australia'
,'オランダ'=>'Holland'
,'カザフスタン'=>'Kazakhstan'
,'カナダ'=>'Canada'
,'韓国'=>'Korea'
,'カンボジア'=>'Cambodia'
,'クック諸島'=>'Cook Islands'
,'グルジア'=>'Georgia'
,'ケニア'=>'Kenya'
,'サモア'=>'Samoa'
,'シンガポール'=>'Singapore'
,'スイス'=>'Switzerland'
,'スウェーデン'=>'Sweden'
,'スリランカ'=>'Sri Lanka'
,'スロバキア'=>'Slovakia'
,'タイ'=>'Thailand'
,'台湾'=>'Taiwan'
,'チェコ'=>'Czech Republic'
,'中国'=>'China'
,'チリ'=>'Chile'
,'デンマーク'=>'Denmark'
,'ドイツ'=>'Germany'
,'日本'=>'Japan'
,'パレスチナ'=>'Palestine'
,'ハンガリー'=>'Hungary'
,'フィジー'=>'Fiji'
,'フィリピン'=>'Philippines'
,'ブラジル'=>'Brazil'
,'フランス'=>'France'
,'米国'=>'USA'
,'ベトナム'=>'Vietnam'
,'ベルギー'=>'Belgium'
,'ポーランド'=>'Poland'
,'マレーシア'=>'Malaysia'
,'ミクロネシア'=>'Micronesia'
,'南アフリカ'=>'South Africa'
,'ミャンマー'=>'Myammar'
,'メキシコ'=>'Mexico'
,'モンゴル'=>'Mongolia'
,'ヨルダン'=>'Jordan'
,'ラオス'=>'Laos'
,'ロシア'=>'Russia'
,'ニューカレドニア'=>'New Caledonia'
);
$res = '';
$str = '';
$vl = explode(',', $v);
for($i=0; $i
Notice: Undefined index: ex in /opt/spf/htdocs/ja/projects/search.php on line 25
Fatal error: Call to undefined function getUrlData() in /opt/spf/htdocs/ja/projects/search.php on line 41