src-empire/Empire/Core/Document.php line 54

Open in your IDE?
  1. <?php
  3. namespace Empire\Core;
  4. use Empire\Legacy\cgt;
  5. use Doctrine\DBAL\FetchMode;
  8. class Document extends AbstractEntity implements Named {
  9.     const TABLE = "DOCUMENT_LIBRARY";
  10.     const PRIMARY_FIELD = "DOLI_ID";
  12.     private $DOLI_ID, $DOLI_REF, $DOLI_NAME, $DOLI_RELEASE, $CLEA_ORDER, $DOLI_STATUS, $DOLI_LINK, $BRAN_ID;
  14.     public $name, $type, $date, $clearance;
  16.     function initialize() {
  17.         $this->id = $this->DOLI_ID;
  18.         $this->ref = $this->DOLI_REF;
  19.         $this->name = $this->DOLI_NAME;
  20.         $this->type = "Library Document";
  21.         $this->date = cgt::evaluateString($this->DOLI_RELEASE);
  22.         $this->clearance = Clearance::loadByOrder($this->CLEA_ORDER);
  23.         $this->status = $this->DOLI_STATUS;
  24.         $this->branch = Branch::load([$this->BRAN_ID]);
  25.         $this->link = $this->DOLI_LINK;
  26.         if($this->branch->id == cint_BRANCH_THRONE) $this->branch->name = "Empire";
  27.     }
  29.     function getPrimaryField() {
  30.         return self::PRIMARY_FIELD;
  31.     }
  33.     function getTable() {
  34.         return self::TABLE;
  35.     }
  37.     public function getName() {
  38.         return $this->name;
  39.     }
  41.     public function printDocStatus() {
  42.         if($this->status == '1'){
  43.             return "<span style='color:#0EE71A'>IN FORCE</span>";
  44.         } else {
  45.             return "<span style='color:#7e0202'>TERMINATED</span>";
  46.         }
  47.     }
  49.     /**
  50.      * @return self[]
  51.      * @throws \Exception
  52.      */
  53.     public static function loadAll() {
  54.         $stmt = Core::db()->executeQuery("SELECT * FROM DOCUMENT_LIBRARY WHERE DOLI_STATUS = 1 ORDER BY BRAN_ID DESC, DOLI_RELEASE DESC");
  55.         $stmt->setFetchMode(FetchMode::CUSTOM_OBJECT, self::class, [true]);
  56.         return $stmt->fetchAll();
  57.     }
  59.     public static function loadByRef($ref) {
  60.         $stmt = Core::db()->executeQuery("SELECT * FROM DOCUMENT_LIBRARY WHERE DOLI_REF = ?", [$ref]);
  61.         $stmt->setFetchMode(FetchMode::CUSTOM_OBJECT, self::class, [true]);
  62.         return $stmt->fetch();
  63.     }
  64. }