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(); }
$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);