function maybeGetFirstHold($bibid, $copyid)
 {
     // jalg multi 5-7-2015 ALX
     $sql = $this->mkSQL("select * from biblio_hold " . "where bibid = %N and copyid = %N " . "order by hold_begin_dt limit 1", $bibid, $copyid);
     $row = $this->select01($sql);
     if (!$row) {
         return NULL;
     }
     $hold = new BiblioHold();
     $hold->setBibid($row["bibid"]);
     $hold->setCopyid($row["copyid"]);
     $hold->setHoldid($row["holdid"]);
     $hold->setHoldBeginDt($row["hold_begin_dt"]);
     $hold->setMbrid($row["mbrid"]);
     return $hold;
 }
Esempio n. 2
0
 function getFirstHold($bibid, $copyid)
 {
     $sql = $this->mkSQL("select * from biblio_hold " . "where bibid = %N and copyid = %N " . "order by hold_begin_dt", $bibid, $copyid);
     if (!$this->_query($sql, $this->_loc->getText("biblioHoldQueryErr6"))) {
         return FALSE;
     }
     $this->_rowCount = $this->_conn->numRows();
     if ($this->_rowCount == 0) {
         return FALSE;
     }
     $array = $this->_conn->fetchRow();
     $hold = new BiblioHold();
     $hold->setBibid($array["bibid"]);
     $hold->setCopyid($array["copyid"]);
     $hold->setHoldid($array["holdid"]);
     $hold->setHoldBeginDt($array["hold_begin_dt"]);
     $hold->setMbrid($array["mbrid"]);
     return $hold;
 }