<?php

class KnowhowMapper extends Mapper
{
  private $entityClass = 'KnowhowEntity';

  public function getKnowhow($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 knowhow_id, knowhow_name
        from knowhow WHERE ".$sqlwhere;
    return $this->_findAll($sql, $this->entityClass);
  }
  public function getOfficialKnowhow() {
    return $this->getKnowhow(true);
  }
  public function getNonOfficialKnowhow() {
    return $this->getKnowhow(false);
  }

  public function getKnowhowById($id) {
    print_r($ary);
    $sql = "SELECT knowhow_id, knowhow_name
        from knowhow where knowhow_id = :knowhow_id";
    $result = $this->_getOne($sql, ["knowhow_id" => $id]);
    return $result===false ? null : new KnowhowEntity($result);
  }
  public function getKnowhowByName($name) {
    $name = trim($name);
    $sql = "SELECT knowhow_id, knowhow_name
        from knowhow where knowhow_name = :knowhow_name";
    $result = $this->_getOne($sql, ["knowhow_name" => $name]);
    return $result===false ? null : new KnowhowEntity($result);
  }
  public function save($knowhow_name){
    $knowhow_name = trim($knowhow_name);
    if(!$knowhow_name){return'';}
    $sql = "insert into knowhow (knowhow_name) values (:knowhow_name)";
    $stmt = $this->db->prepare($sql);
    $result = $stmt->execute([
        "knowhow_name" => $knowhow_name,
    ]);
    return $this->db->lastInsertId();
  }
}