MarkupJobInfoDAO.inc.php

<?php
 
import('lib.pkp.classes.db.DAO');
 
class MarkupJobInfoDAO extends DAO {
   protected $_plugin = null;
   
   //
   // constructor
   //
   public function __construct($parentPlugin) {
      parent::__construct();
      $this->_plugin = $parentPlugin;
   }
   
   protected function returnMarkupJobInfoFromRow($row) {
      $this->_plugin->import('classes.MarkupJobInfo');
   
      $markupJobInfo = new MarkupJobInfo();
      $markupJobInfo->setId($row['id']);
      $markupJobInfo->setJournalId($row['journal_id']);
      $markupJobInfo->setFileId($row['file_id']);
      $markupJobInfo->setUserId($row['user_id']);
      $markupJobInfo->setXmlJobId($row['xml_job_id']);
   
      return $markupJobInfo;
   }
   
   public function getMarkupJobInfo($jobId) {
      $result = $this->retrieve(
            'SELECT * FROM markup_jobinfos WHERE id = ?', $jobId
      );
   
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->returnMarkupJobInfoFromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
   
   public function getMarkupJobInfobyFileId($fileId) {
      $result = $this->retrieve(
            'SELECT * FROM markup_jobinfos WHERE file_id = ?', $jobId
      );
   
      $returner = null;
      if ($result->RecordCount() != 0) {
         $returner = $this->returnMarkupJobInfoFromRow($result->GetRowAssoc(false));
      }
      $result->Close();
      return $returner;
   }
   
   public function insertMarkupJobInfo($markupJobInfo) {
      
      $ret = $this->update(
            'INSERT INTO markup_jobinfos
            (id,
            journal_id,
            user_id,
            file_id,
            xml_job_id,
            created_at)
         VALUES
            (?, ?, ?, ?, ?, ?)',
            array(
                  $markupJobInfo->getId(),
                  $markupJobInfo->getJournalId(),
                  $markupJobInfo->getUserId(),
                  $markupJobInfo->getFileId(),
                  $markupJobInfo->getXmlJobId(),
                  date('Y-m-d H:i:s')
            )
      );
      
      $markupJobInfo->setId($this->getInsertId());
   
      return $markupJobInfo->getId();
   }
   
   public function getInsertId() {
      return $this->_getInsertId('markup_jobinfos', 'id');
   }
   
   public function updateMarkupJobInfo($markupJobInfo) {
      $this->update(
         'UPDATE markup_jobinfos
            SET
               journal_id = ?,
               file_id = ?,
               user_id = ?,
               xml_job_id = ?,
               updated_at = ?
         WHERE id = ?',
            array(
               $markupJobInfo->getJournalId(),
               $markupJobInfo->getFileId(),
               $markupJobInfo->getUserId(),
               $markupJobInfo->getXmlJobId(),
               date('Y-m-d H:i:s'),
               $markupJobInfo->getId(),
            )
      );
   }
 
   public function deleteByFileId($fileId) {
      $this->update(
         'DELETE FROM markup_jobinfos WHERE file_id = ?',
         array((int) $fileId)
      );
   }
}