public function Save(WQDData $wqdData) { $fields = "wqdfileseq,wqdfolderseq,wqdfiledatadated,wqdfiledatareportno,wqdfiledatatotalchannels,wqdfiledatachecksum,"; $values = ":fileseq,:folderseq,:datadate,:reportno,:totalChannels,:datachecksum,"; $conn = self::$db->getConnection(); $WCD = WQDDataChannelDataStore::getInstance(); $wqdChannlsArr = array(); try { $wqdChannlsArr = $wqdData->getChannels(); $SQL = self::GenerateSqlToSave($wqdChannlsArr, $fields, $values); $stmt = $conn->prepare($SQL); $stmt->bindValue(':fileseq', 0); $stmt->bindValue(':folderseq', $wqdData->getFolderSeq()); $stmt->bindValue(':datadate', $wqdData->getDatadate()); $stmt->bindValue(':reportno', $wqdData->getReportNo()); $stmt->bindValue(':totalChannels', $wqdData->getTotalChannels()); $stmt->bindValue(':datachecksum', $wqdData->getChecksum()); $stmt->execute(); $error = $stmt->errorInfo(); if ($error[2] != "") { throw new RuntimeException($error[2]); } } catch (Exception $e) { $message = $e->getMessage(); if (strpos($message, "Duplicate entry") === 0) { } else { throw $e; } } }
public static function getInstance() { if (!self::$WQDDataChannelStore) { self::$WQDDataChannelStore = new WQDDataChannelDataStore(); return self::$WQDDataChannelStore; } return self::$WQDDataChannelStore; }