public function saveSyncedData($wqdDataList, $isM2MSite = false)
{
$syncDate = "";
$folderSeq = "";
foreach ($wqdDataList as $wqdData) {
try {
$this->Save($wqdData);
$syncDate = $wqdData->getDatadate();
$folderSeq = $wqdData->getFolderSeq();
} catch (Exception $e) {
$message = $e->getMessage();
if (strpos($message, "Duplicate entry") === 0) {
} else {
throw $e;
}
}
}
if (!empty($syncDate)) {
if ($isM2MSite) {
$M2MDs = M2MSynchronizerDataStore::getInstance();
$M2MDs->updateLastSyncedOn($syncDate, $folderSeq);
} else {
$FDS = FolderDataStore::getInstance();
$FDS->updateLastSyncedOn($syncDate, $folderSeq);
}
}
}
<?php
require_once 'IConstants.inc';
require_once $ConstantsArray['dbServerUrl'] . "FormValidator//validator.php";
require $ConstantsArray['dbServerUrl'] . "DataStoreMgr//FolderDataStore.php";
require_once $ConstantsArray['dbServerUrl'] . "DataStoreMgr//M2MSynchronizerDataStore.php";
require $ConstantsArray['dbServerUrl'] . "DataStoreMgr//LocationDataStore.php";
require_once $ConstantsArray['dbServerUrl'] . "Utils/DropDownUtils.php";
$folder = new Folder();
$FDS = FolderDataStore::getInstance();
$LDS = LocationDataStore::getInstance();
$m2mDs = M2MSynchronizerDataStore::getInstance();
$locations = $LDS->FindAll();
$visible = "";
$enable = "";
$m2MSiteChecked = "";
$siteCode = "";
$siteCodeDisable = "disabled";
if ($_POST["submit"] != "") {
$folderName = $_POST["folderName"];
$details = $_POST["details"];
$isVisible = isset($_POST["isvisible"]) ? 1 : 0;
$isEnable = isset($_POST["isenable"]) ? 1 : 0;
$folderSeq = $_POST["seq"];
$editFolderName = $_POST["editFolderName"];
$locationSeq = $_POST["l_DropDown"];
$stationType = $_POST["s_DropDown"];
$isM2MSite = isset($_POST["isM2MSite"]) ? true : false;
$locationName = "";
if ($locationSeq != "" && $locationSeq != "0") {
$locationObj = $locations[$locationSeq];
public function SaveSyncedWQDStackData($jsonString, $folderSeqs, $lastSynchDates)
{
$arr = json_decode($jsonString);
$fileDataObjArr = array();
$WQDSDS = WQDStackDataStore::getInstance();
$FDS = FolderDataStore::getInstance();
$message = "";
$onlineStations = array_fill_keys(array_values($folderSeqs), 0);
foreach ($arr as $key => $value) {
$stationCode = $value->siteCode;
$folderSeq = $folderSeqs[$stationCode];
try {
$onlineStations[$folderSeq] = 1;
echo "<br/><br/>Station Code :- " . $stationCode;
var_dump($value);
$channels = $value->parameters;
$data = $value->data;
$lastSyncDb = $lastSynchDates[$folderSeq];
$count = count($data);
echo " Rows found :- " . $count;
if ($count == 1) {
$now = $this->getPast90MinTime();
$sdate = DateTime::createFromFormat('d-m-Y H:i:s', $lastSyncDb);
if ($lastSyncDb == $data[0]->Key && $sdate < $now) {
$this->updateLastSyncedOnWithAdd90Min($lastSyncDb, $folderSeq);
continue;
}
}
$chNoArr = $this->getChannelNumbers($value, $folderSeq);
$syncDate = "";
$fileDataObjArr = array();
foreach ($data as $key => $val) {
$valueArr = $val->Value;
$syncdate = $val->Key;
$fileDataObj = $this->getFileDataObj($syncdate, $folderSeq);
$chValueStatusArr = array();
$i = 0;
foreach ($channels as $ch) {
$index = $chNoArr[$ch];
$chValueStatusArr[$index] = $valueArr[$i];
$i++;
}
$fileDataObj->setChannels($chValueStatusArr);
array_push($fileDataObjArr, $fileDataObj);
}
$WQDSDS->saveSyncedData($fileDataObjArr, true);
} catch (Exception $e) {
$message .= "Error During M2MSynchronizer for SiteCode " . $stationCode . " : -" . $e->getMessage() . "<br/>";
$logger = Logger::getLogger("myDBLogger");
$logger->error($message);
$FDS->updateIsEnable($folderSeq, 0);
}
}
if (!empty($message)) {
MailerUtils::sendError($message, "Error During M2MSynchronizer");
}
$M2MDs = M2MSynchronizerDataStore::getInstance();
foreach ($onlineStations as $folderSeq => $isOnline) {
$FDS->updateIsOnline($folderSeq, $isOnline);
$lastSyncDate = $lastSynchDates[$folderSeq];
$sdate = DateTime::createFromFormat('d-m-Y H:i:s', $lastSyncDate);
$now = $this->getPast90MinTime();
if ($sdate < $now) {
$this->updateLastSyncedOnWithAdd90Min($lastSyncDate, $folderSeq);
}
}
}
public static function populateObject($row)
{
$folder = new Folder();
$folder->setSeq($row['seq']);
$name = $row['foldername'];
if ($name == "raigarh") {
$name = "North Side Plant";
}
$actualName = self::getActualName($row['foldername']);
$folder->setFolderName($name);
$folder->setActualName($actualName);
$folder->setLocation($row['locationname']);
$folder->setLocationFolder($row['locationfolder']);
$folder->setDetails($row['details']);
$folder->setLocationSeq($row['locationseq']);
$folder->setLastSynchedOn($row['lastsynchedon']);
$folder->setLastParsedOn($row['lastparsedon']);
$folder->setLastRemindedOn($row['lastremindedon']);
$folder->setStationType($row['stationtype']);
$folder->setStationName($row['stationname']);
$folder->setCategory($row['category']);
$folder->setIndustryCode($row['industrycode']);
$folder->setIndustryName($row['industryname']);
$folder->setAddress($row['address']);
$folder->setCity($row['city']);
$folder->setState($row['state']);
$folder->setZipcode($row['zipcode']);
$folder->setLatitude($row['latitude']);
$folder->setLongitude($row['longitude']);
$folder->setEmail($row['email']);
$folder->setMobile($row['mobile']);
$folder->setStationName($row['stationname']);
$folder->setDeviceId($row['deviceid']);
$folder->setVendor($row['vendor']);
$folder->setMake($row['make']);
$folder->setModel($row['model']);
$folder->setIsEnable($row['isenable']);
$folder->setIsVisible($row['isvisible']);
$folder->setCertificationsSystem($row['certificationsystem']);
$m2mDs = M2MSynchronizerDataStore::getInstance();
$m2mSite = $m2mDs->FindByFolderSeq($folder->getSeq());
if (!empty($m2mSite)) {
$folder->setM2MCode($m2mSite->getSiteCode());
}
$folder->setIsOnline($row["isonline"]);
return $folder;
}
