public function Save(WQDFile $wqdFile, $filePath)
 {
     $SQL = self::$INSERT;
     $WDD = WQDDataDataStore::getInstance();
     $wqdataArr = array();
     $conn = self::$db->getConnection();
     $stmt = $conn->prepare($SQL);
     $stmt->bindValue(':date', $wqdFile->getFiledate());
     $stmt->bindValue(':name', $wqdFile->getName());
     $stmt->bindValue(':folderseq', $wqdFile->getFolderSeq());
     $stmt->bindValue(':locationseq', $wqdFile->getLocationSeq());
     try {
         $stmt->execute();
         $err = $stmt->errorInfo();
         $wqdataArr = $wqdFile->getData();
         $seq = self::$db->getLastInsertedId();
         $WDD->SaveFileData($wqdataArr, $seq);
     } catch (Exception $e) {
         return $e->getMessage();
     }
     $error = $stmt->errorInfo();
 }
Esempio n. 2
0
$wqdChannel3 = new WQDChannel();
$wqdChannel3->setChannelName("testChannelName3");
$wqdChannel3->setChannelNumber("1233");
$wqdChannel3->setChannelStatus(13);
$wqdChannel3->setChannelValue(1.23);
$wqdChannelArr1[0] = $wqdChannel2;
$wqdChannelArr1[1] = $wqdChannel3;
//<------------------------>
$wqdData = new WQDData();
$wqdDataarr = array();
$wqdData->setChannels($wqdChannelArr);
$wqdData->setChecksum("testCheckSum");
$wqdData->setDataDate($date);
$wqdData->setReportNo(1);
$wqdData->setTotalChannels(count($wqdChannelArr));
$wqdData1 = new WQDData();
$wqdData1->setChannels($wqdChannelArr1);
$wqdData1->setChecksum("testCheckSum1");
$wqdData1->setDataDate($date);
$wqdData1->setReportNo(1);
$wqdData1->setTotalChannels(count($wqdChannelArr1));
$wqdDataarr[0] = $wqdData;
$wqdDataarr[1] = $wqdData1;
$wqdFile = new WQDFile();
$wqdFile->setFileDate($date);
$wqdFile->setFolderSeq(5);
$wqdFile->setLocationSeq(4);
$wqdFile->setName("testFileName.txt");
$wqdFile->setData($wqdDataarr);
$WFDS = WQDFileDataStore::getInstance();
$WFDS->Save($wqdFile);