template_dir = dirname( __FILE__ ).'/templates';
$smarty->compile_dir = dirname( __FILE__ ).'/templates_c';
/**Database Object */
$db_table_device_info = new device_info($db);
/**Data create in Content table */
/** Randomly data generated for each table */
if(isset($_POST['device_info_btn'])){
$rowData = array(
"track_device_id" => $_POST['track_device_id'],
"track_device_manufacturer" => $_POST['track_device_manufacturer'],
"track_device_serial" => $_POST['track_device_serial'],
"track_device_model" => $_POST['track_device_model']
//"track_status_json" => $_POST['track_status_json']
);
//echo $rowData;
//echo json_encode($rowData,true);
//if(is_array($rowData)|| is_object($rowData))
// {
//foreach($rowData as $array)
// {
$device_info_success = $db_table_device_info->create($rowData);
$read_data_1 = $db_table_device_info->read_1($rowData);
//$smarty->assign("device_info_last", $read_data_1);
//}
//}
}
if(isset($_POST['track_info_btn'])){
$rowData1 = array(
"track_device_id" => $_POST['track_device_id'],
"track_status_json" => $_POST['track_status_json']
);
// print "";
// print_r($rowData1);
// print "";
//var_dump($rowData1);
//echo $rowData1;
//echo json_encode($rowData1,JSON_FORCE_OBJECT);
$lastData = $db_table_device_info->__jsonGetMeLast($rowData1);
//$last_data = $db_table_device_info->last($rowData1);
//echo $rowData1['track_status_json'];
if($lastData == NULL)
{
$device_info_success = $db_table_device_info->updat($rowData1);
}
else{
$date1 = date("Y-m-d H:i:s");
//$status = "Good";
$result ='{ "' . $date1 . '" : "' . $lastData .'" }';
$result = $lastData;
//{date1:status1, date2:status2}
// echo $result;
$newStatus = $rowData1["track_status_json"];
$newResult = substr($result, 0, -1);
$newResult = $newResult. ', "'. $date1. '" : "' .$newStatus. '" }';
$db_table_device_info->__jsonUpdateData($rowData1["track_device_id"], $newResult);
}
// //echo $newResult;
//$db_table_device_info->__jsonUpdateData($rowData1["track_device_id"], $newResult);
// echo $lastData;
// $device_info_success = $db_table_device_info->updat($rowData1);
}
/** */
/**Data display for content table */
$read_data = $db_table_device_info->read();
$delete_data = $db_table_device_info->delete();
//$read_data_json = $db_table_device_info->red();
//$read_data_1 = $db_table_device_info->read_1();
$smarty->assign("device_info_data_all", $read_data);
$smarty->assign("del", $delete_data);
//$smarty->assign("device_info_data_json", $read_data_json);
$smarty->assign("device_info_last", $read_data_1);
// $data = 'data';
// $status = "Good";
// $result = '{ "' . $data . '" : "' . $status .'" }';
// //{date1:status1, date2:status2}
// echo $result;
// $newStatus = "bad";
// $data2 = 'data2';
// $newResult = substr($result, 0, -1);
// $newResult = $newResult. ', "'. $data2. '" : "' .$newStatus. '" }';
// echo $newResult;
// var_dump(json_decode($newResult));
// $obj111 = json_decode($newResult);
// // Loop through the object
// echo "
";
// foreach($obj111 as $key=>$value){
// echo $key . " : " . $value . "
";
// }
/// DECODE FROM JSON
$n = $db_table_device_info->countTheValue();
for($i = 0; $i< $n ; $i++)
{
// echo $read_data[$i]["track_status_json"]."
";
if($i==0)
{
$val = json_decode($read_data[$i]["track_status_json"]);
$a = array($val);
}
else{
$val = json_decode($read_data[$i]["track_status_json"]);
array_push($a,$val);
}
}
//print_r($a);
$smarty->assign("jsonArray", $a);
$smarty->assign("jsonArrayCount", $n);
//$olaaa = '{ "2021-02-11 15:50:12" : "good" , "2021-02-11 15:52:44" : "BLAHH" , "2021-02-11 15:58:09" : "bad" }';
//$obj111 = json_decode($olaaa);
// Loop through the object
// echo "
";
// foreach($obj111 as $key=>$value){
// echo $key . " | " . $value . "
";
// }
//$smarty->assign("jsonOB",$obj111);
//$smarty->assign("success" .$lastData. " is Updated.");
/** */
/**Module Program Start */
$smarty->assign("app", APP_NAME);
$smarty->assign("db", DB_NAME);
$smarty->assign("dbtable", TABLE_NAME);
$smarty->assign("module", MODULE_NAME);
$smarty->assign("title", MODULE_HTML_TITLE);
$smarty->assign("name", MODULE_HTML_TITLE_NAME);
$smarty->display('index.tpl');
/**Module Program End */
?>