Remote-Temperator-Monitor/monitor2.php at master · ranacse05/Remote-Temperator-Monitor · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
<?php

    include 'functions.php';

   date_default_timezone_set('Asia/Dhaka');
   if(!$file = fopen("sys2.log","a+"))
   $file = fopen("sys2.log","w");


	$temp = number_format($_GET['temperature']-1.5,2);
	$minute =  intval(date('i'));
	$time = time();

  $sql = 'UPDATE minutes2 set time_stamp="'.$time.'", temp="'.$temp.'" where minutes="'.$minute.'"';

	//fwrite($file,$sql."\n");

   $ret = $db->exec($sql);
   if(!$ret) {
      //echo $db->lastErrorMsg();
      fwrite($file,$db->lastErrorMsg());
      if($db->lastErrorMsg()=='database is locked')
      $db->exec('PRAGMA journal_mode = wal;');

   } else {
      //echo ;
      fwrite($file,"Record for {$minute} updated {$temp} successfully\n");
   }


   $select = "Select * from settings";
   $results1= $db->query($select);
   $res1 = $results1->fetchArray();

   if($temp>=$res1['temp1'] && $res1['status1']==1)
   {

      if(!$file2 = fopen("sms.log","a+"))
      $file2 = fopen("sms.log","w");

      $minute_range = '';

      for($i=0;$i<5;$i++){
         if($minute_range!='')
         $minute_range.= ',';
         $mit_ran = ($minute-$i);
         if($mit_ran<0)
         $mit_ran = 60+$mit_ran;
         $minute_range .= strval($mit_ran);
      }


      $sql = "select * from minutes2 where minutes in (".$minute_range.") order by minutes";
      //echo $sql;
      $results= $db->query($sql);
      $data= array();
      $sms_text = '';

      while ($res= $results->fetchArray())
      {

         //print_r($res);
         if($sms_text==''){
            $sms_text .= 'Outdoor temp '.$res['outdoor']." Pre-paid Room\n";
         }

         $sms_text .= $res['minutes'].'-'.$res['temp']."\n";
      }
      //echo $sms_text;

      send_text( $res1['number1'],$sms_text);

         if($temp>=$res1['temp2'] && $res1['status2']==1){
            send_text( $res1['number2'],$sms_text);
         }
   }

   if($minute==59)
   {
        $avg = 0.0 ;
        $results= $db->query("select avg(temp) from minutes2");
        while ($res= $results->fetchArray())
           {
            $avg =number_format($res[0],2) ;
           }

           $outdoor_avg = 0.0 ;
           $results= $db->query("select avg(outdoor) from minutes2");
           while ($res= $results->fetchArray())
              {
               $outdoor_avg =number_format($res[0],2) ;
              }

   $sql = 'INSERT into hours2 (`date`,`hour`,`temp`,`timestamp`,`outdoor`) values ("'.date('Y-m-d',$time).'","'.date('H',$time).'",'.$avg.',"'.$time.'","'.$outdoor_avg.'")';

   $ret = $db->exec($sql);
      if(!$ret) {

         fwrite($file,$db->lastErrorMsg());
         if($db->lastErrorMsg()=='database is locked')
         $db->exec('PRAGMA journal_mode = wal;');

      } else {
         //echo ;
         //fwrite($file,"Record for ".date('Y-m-d',$time).'/'.date('H',$time)." inserted successfully\n");
      }

   }


   $db->close();
   unset($db);

   fclose($file);


?>