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; }