<?php

class SkillMapper extends Mapper
{
  private $entityClass = 'SkillEntity';

  public function getSkill($is_official=null) {
    $sqlwhere = ' 1'; #all
    if($is_official===true){ #only official
      $sqlwhere = ' is_official=1';
    }
    if($is_official===false){ #only non-official
      $sqlwhere = ' is_official=0';
    }
    $sql = "SELECT skill_id, skill_name
        from skill WHERE ".$sqlwhere;
    return $this->_findAll($sql, $this->entityClass);
  }
  public function getOfficialSkill() {
    return $this->getSkill(true);
  }
  public function getNonOfficialSkill() {
    return $this->getSkill(false);
  }

  public function getSkillById($id) {
    print_r($ary);
    $sql = "SELECT skill_id, skill_name
        from skill where skill_id = :skill_id";
    $result = $this->_getOne($sql, ["skill_id" => $id]);
    return $result===false ? null : new SkillEntity($result);
  }
  public function getSkillByName($name) {
    $name = trim($name);
    $sql = "SELECT skill_id, skill_name
        from skill where skill_name = :skill_name";
    $result = $this->_getOne($sql, ["skill_name" => $name]);
    return $result===false ? null : new SkillEntity($result);
  }
  public function save($skill_name){
    $skill_name = trim($skill_name);
    if(!$skill_name){return'';}
    $sql = "insert into skill (skill_name) values (:skill_name)";
    $stmt = $this->db->prepare($sql);
    $result = $stmt->execute([
        "skill_name" => $skill_name,
    ]);
    return $this->db->lastInsertId();
  }
}