/** * Get next image id * * @param PluginLsgallery_ModuleImage_EntityImage $oImage * @return int|null */ public function GetNextImageId($oImage) { $sql = "\n SELECT\n image_id\n FROM\n " . Config::Get('db.table.lsgallery.image') . "\n WHERE\n image_id > ?d\n AND\n album_id = ?d\n ORDER BY\n image_id ASC\n "; if ($aRow = $this->oDb->selectRow($sql, $oImage->getId(), $oImage->getAlbumId())) { return $aRow['image_id']; } return null; }
protected function _load($assocPkValue) { $query = "SELECT * FROM " . $this->getTableName() . " WHERE " . Lms_Item_Sql::combineToAnd($assocPkValue); $result = $this->_slaveDb->selectRow($query); if (!$result) { throw new Lms_Item_RecordNotExistsException('No such record in data base'); } return $result; }