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

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