Changeset 87 for trunk/add.php

Timestamp:

Feb 24, 2019, 10:02:57 PM (6 years ago)

Author:

chronos

Message:

• Added: Allow to add multiple values in single query.

File:

• trunk/add.php (modified) (2 diffs)

trunk/add.php

@@ -8 +8 @@
 $Core->Run();
 
+$AddedValues = 0;
+
+// Try to load single value
+$Time = time();
 if(array_key_exists('MeasureId', $_GET) and array_key_exists('Value', $_GET))
 {
-  $MeasureId = addslashes($_GET['MeasureId']);
-  $Value = addslashes($_GET['Value']);
   if (array_key_exists('Time', $_GET)) $Time = $_GET['Time'] * 1;
-    else $Time = time();
+  AddValue(addslashes($_GET['MeasureId']), addslashes($_GET['Value']), $Time);
+  $AddedValues = $AddedValues + 1; 
+}
+
+// Try to load multiple values
+$Time = time();
+$I = 1;
+while (array_key_exists('MeasureId'.$I, $_GET) and array_key_exists('Value'.$I, $_GET))
+{
+  if (array_key_exists('Time'.$I, $_GET)) $Time = $_GET['Time'.$I] * 1;
+  AddValue(addslashes($_GET['MeasureId'.$I]), addslashes($_GET['Value'.$I]), $Time);
+  $AddedValues = $AddedValues + 1; 
+  $I++;
+}
+
+if ($AddedValues == 0) echo('Nebyly zadány potřebné parametry MeasureId a Value.'."\n");
+
+function AddValue($MeasureId, $Value, $Time)
+{
+  global $Core;
+
   $Measure = new Measure($Core->Database);
   $Measure->Load($MeasureId);
@@ -20 +42 @@
   {
     $Measure->AddValue($Value, $Time);
-    echo('Hodnota '.$Value.' uložena');
-  } else echo('Nemáte oprávnění k aktualizaci zadané veličiny!<br>Vaše adresa: '.$HostName.'('.$_SERVER['REMOTE_ADDR'].')');
-} else echo('Nebyly zadány potřebné parametry');
+    echo('Hodnota '.$Value.' uložena'."\n");
+  } else echo('Nemáte oprávnění k aktualizaci zadané veličiny!<br>Vaše adresa: '.$HostName.'('.$_SERVER['REMOTE_ADDR'].')'."\n");
+}