src-empire/Empire/Core/Stance.php line 53

Open in your IDE?
  1. <?php
  2. /**
  3.  * Created by PhpStorm.
  4.  * User: daniel
  5.  * Date: 20.03.18
  6.  * Time: 20:21
  7.  */
  9. namespace Empire\Core;
  11. use \Empire\Legacy\cgt;
  12. use \Empire\Legacy\db;
  14. class Stance extends AbstractEntity implements Named {
  15.     const PRIMARY_FIELD = 'DIST_ID';
  16.     const TABLE = 'DIPLOMATIC_STATUS';
  18.     const STATI = [
  19.         "Imperial Union",
  20.         "Ally",
  21.         "Friendly",
  22.         "Neutral",
  23.         "Enemy"
  24.     ];
  26.     const STATUS_COLORS = [
  27.         "hsl(120, 100%, 50%)",
  28.         "hsl(120, 100%, 30%)",
  29.         "hsl(210, 100%, 50%)",
  30.         "#FFFF00",
  31.         "#E41B17"
  32.     ];
  34.     protected $DIST_ID, $DIST_NAME, $DIST_STATUS, $DIST_DATE;
  35.     public $name, $status, $statusColor, $statusNumber, $date, $dateString;
  37.     public function initialize() {
  38.         $this->id = $this->DIST_ID;
  39.         $this->name = $this->DIST_NAME;
  40.         $this->status = self::STATI[$this->DIST_STATUS];
  41.         $this->statusColor = self::STATUS_COLORS[$this->DIST_STATUS];
  42.         $this->statusNumber = $this->DIST_STATUS;
  43.         $this->date = cgt::evaluateString($this->DIST_DATE);
  44.         $this->dateString = $this->DIST_DATE;
  46.     }
  48.     /**
  49.      * Load all stances ordered by name.
  50.      * @return Stance[]
  51.      * @throws \Exception
  52.      */
  53.     public static function loadAll() {
  54.         $stmt = db::prepare('SELECT * FROM DIPLOMATIC_STATUS ORDER BY DIST_NAME ASC');
  55.         return db::fetchArrayOfObjects($stmt, self::class);
  56.     }
  58.     public function getPrimaryField() {
  59.         return self::PRIMARY_FIELD;
  60.     }
  62.     public function getTable() {
  63.         return self::TABLE;
  64.     }
  66.     public function getName() {
  67.         return $this->name;
  68.     }
  70.     public function set($value) {
  71.         Event::send(Core::user()->getID(), 0, Core::user()->getName()." has changed the Empire's diplomatic stance toward '$this->name' to " . self::STATI[$value] . ".", cint_EVENTTYPE_DIPLOMACY);
  72.         $this->updateFields(['DIST_STATUS' => $value, 'DIST_DATE' => time()]);
  73.         $this->refresh();
  74.     }
  76.     public function delete() {
  77.         Event::send(Core::user()->getID(), 0, Core::user()->getName() ." has removed '$this->name' from the diplomatic database.", cint_EVENTTYPE_DIPLOMACY);
  78.         return parent::delete();
  79.     }
  81.     public static function addStance($name, $status) {
  82.         $fetch = Core::db()->prepare("SELECT * FROM DIPLOMATIC_STATUS WHERE DIST_NAME = ?");
  83.         $fetch->execute([$name]);
  85.         if($fetch->rowCount() > 0) {
  86.             return false;
  87.         }
  89.         Core::db()->insert("DIPLOMATIC_STATUS", ["DIST_NAME" => $name, "DIST_STATUS" => $status, "DIST_DATE" => time()]);
  90.         $id = Core::db()->lastInsertId();
  92.         Event::send(Core::user()->getID(), 0, Core::user()->getName()." has added '$name' to the database, with a diplomatic stance of " . self::STATI[$status] . ".", cint_EVENTTYPE_DIPLOMACY);
  93.         return self::load([$id]);
  94.     }
  95. }