<?php
include "db.class.php";
$db = new db();
$db2 = new db();
$reset_global = '0';

if($_GET['unit_id']=='1'){
    $result = $db->insert("SELECT * FROM `actions` WHERE `unit_id` = 1");
    $result_data = $result->fetch_assoc();
    $j_list = array('threshold' => $result_data['threshold'],'reset' => $result_data['reset']);
    echo json_encode($j_list);
    if(isset($_GET['pulse_count_1'])){
        $date_time = date("Y-m-d H:i",strtotime("+2 hours"));
        $insert_1 = $db->insert("INSERT INTO `water`(`date_time`,`count`,`unit_id`,`tank`) VALUES ('$date_time','{$_GET['pulse_count_1']}','{$_GET['unit_id']}','{$_GET['tank_state']}')");
        // echo "INSERT INTO `water`(`date_time`,`count`,`unit_id`,`tank`) VALUES ('$date_time','{$_GET['pulse_count_1']}','{$_GET['unit_id']}','{$_GET['tank_state']}') ";
    }
}

if($_GET['unit_id']=='2'){
    $result = $db->insert("SELECT * FROM `actions` WHERE `unit_id` = 2");
    $result_data_1 = $result->fetch_assoc();
    $reset_1 = $result_data_1['reset'];
    $result2 = $db2->insert("SELECT * FROM `actions` WHERE `unit_id` = 3");
    $result_data_2 = $result2->fetch_assoc();
    $reset_2 = $result_data_2['reset'];
    if($reset_1 == '1'|| $reset_2 == '1'){
        $reset_global = '1';
    }
    $j_list = array('threshold_1' => $result_data_1['threshold'],'threshold_2' => $result_data_2['threshold'],'reset'=> $reset_global); 
    echo json_encode($j_list);
    if(isset($_GET['pulse_count_1']) && isset($_GET['pulse_count_2']) && $_GET['unit_id']=="2"){
        $date_time = date("Y-m-d H:i",strtotime("+2 hours"));
        $insert_1 = $db->insert("INSERT INTO `water`(`date_time`,`count`,`unit_id`) VALUES ('$date_time','{$_GET['pulse_count_1']}','{$_GET['unit_id']}') ");
        $insert_2 = $db->insert("INSERT INTO `water`(`date_time`,`count`,`unit_id`) VALUES ('$date_time','{$_GET['pulse_count_2']}','3') "); 
    }
}


    $result = $db->update("actions",['reset'],['0'],"unit_id = ".$_GET['unit_id']);