ktest

File "json_conv.php"

Full path: /www/ktest/json_conv.php
File size: 3.25 KiB (3329 bytes)
MIME-type: text/html
Charset: utf-8

Download   Open   Back 

<HTML>
<HEAD>
<META Http-Equiv="Content-Type" Content="text/html;charset=UTF-8">
<TITLE>json</TITLE>
</HEAD>

<?php

$file_name = "20240404095019.json";


$data = file_get_contents($file_name);


$ddd = stripslashes($data);
$ddd = rtrim($ddd ,'}"');
$ddd = ltrim($ddd ,'"{');

$str = str_replace(": [", ",", $ddd);

$replace = array("\"","\n"," ");
$str = str_replace($replace, "", $str);

$data_ = explode('],',$str);
$count_ = count($data_);


for($i = 0;$i < $count_;$i++)
{
	$sub_data[$i] = explode(',',$data_[$i]);
}


//
$count2 = count($sub_data[0]);

//OUTPUTデータ
$output_data = "";

//■テーブル表示
/*

print "<TABLE BORDER=1>";
print "<TR>";
for($t = 0;$t < $count_;$t++)
{
	print "<TD WIDTH=120 ALIGN=center>";
	print $sub_data[$t][0];
	print "</TD>";
	
	$output_data .= $sub_data[$t][0];
	if($t != $count_-1) $output_data .= ",";
}
print "</TR>";


$output_data .= "\n";



for($ii = 1;$ii < $count2;$ii++)
{
	print "<TR>";
	for($i = 0;$i < $count_;$i++)
	{
		print "<TD WIDTH=120 ALIGN=center>";
		$sub_data[$i][$ii] = str_replace("]", "",$sub_data[$i][$ii]);
		print $sub_data[$i][$ii];
		
		$output_data .= $sub_data[$i][$ii];
		if($i != $count_-1) $output_data .= ",";
		
		print "</TD>";
	}	
		$output_data .= "\n";
	print "</TR>";

}
print "</TABLE>";
*/
//■データ出力のみ
for($t = 0;$t < $count_;$t++)
{
	$output_data .= $sub_data[$t][0];
	if($t != $count_-1) $output_data .= ",";
}

$output_data .= "\n";


for($ii = 1;$ii < $count2;$ii++)
{
	for($i = 0;$i < $count_;$i++)
	{
		$sub_data[$i][$ii] = str_replace("]", "",$sub_data[$i][$ii]);
		$output_data .= $sub_data[$i][$ii];
		if($i != $count_-1) $output_data .= ",";
	}	
	$output_data .= "\n";
}


$date_st = $sub_data[0][1];
$date_ed = $sub_data[0][$count2-1];

$date_ = explode('日',$date_st);
$da_ = str_replace("年", "-", $date_[0]); // "年"を"-"に置換する
$da_ = str_replace("月", "-", $da_); // "月"を"-"に置換する
$time_ = str_replace("時", ":", $date_[1]);
$time_ = str_replace("分", ":", $time_);
$time_ = str_replace("秒", "", $time_);

$date2_ = explode('日',$date_ed);
$da2_ = str_replace("年", "-", $date2_[0]); // "年"を"-"に置換する
$da2_ = str_replace("月", "-", $da2_); // "月"を"-"に置換する
$time2_ = str_replace("時", ":", $date2_[1]);
$time2_ = str_replace("分", ":", $time2_);
$time2_ = str_replace("秒", "", $time2_);

$date_conv_st = date("YmdHi" ,strtotime($da_ ." " .$time_));
$date_conv_ed = date("YmdHi" ,strtotime($da2_ ." " .$time2_));

print "date_conv_st=" .$date_conv_st ."<BR>";
print "date_conv_ed=" .$date_conv_ed ."<BR>";


$a = $count_ -2;
$b = $count2 -2;
$dist = explode(' km',$sub_data[$a][$b]);
print "dist=" .$sub_data[$a][$b] ."<BR>";

//ルート名
switch($dist[0]){
	case 12.577:
		$route_name = "route03";
		break;

	case 8.848:
		$route_name = "route02";
		break;

	case 5.223:
		$route_name = "route01";
		break;
}


//print $route_name ."<BR>";

$csv_data = $route_name ."_" .$date_conv_st  ."_" .$date_conv_ed .".csv";
//$csv_data = "test.csv";

print $csv_data;



//CSV 出力
$file_csv = fopen($csv_data, "w");
//出力するデータのエンコードを変更
$output_data_conv =  mb_convert_encoding($output_data  , "Shift-JIS", "UTF-8");

//csvへ出力
fwrite($file_csv, $output_data_conv ."\r\n");
fclose($file_csv);




?>

</HTML>

PHP File Manager