<?php

class JobHistoryMapper extends Mapper
{
  private $entityClass = 'JobHistoryEntity';
  const TBL = 'job_history';
  static private $DO_WHAT_MAPPING = [];

  public function __construct($db){
    parent::__construct($db);
    self::$DO_WHAT_MAPPING[ADMIN_VERIFY_JOB] = 'admin(user_id={user_id})審核通過job={job_id}';
    self::$DO_WHAT_MAPPING[ADMIN_UNVERIFY_JOB] = 'admin(user_id={user_id})審核不過job={job_id}';
    self::$DO_WHAT_MAPPING[ADMIN_VISIBLE_JOB] = 'admin(user_id={user_id})上架job={job_id}';
    self::$DO_WHAT_MAPPING[ADMIN_INVISIBLE_JOB] = 'admin(user_id={user_id})下架job={job_id}';
    self::$DO_WHAT_MAPPING[ADMIN_TRASH_JOB] = 'admin(user_id={user_id})放job={job_id}至垃圾桶';
    self::$DO_WHAT_MAPPING[OWNER_VISIBLE_JOB] = '資方(user_id={user_id})上架job={job_id}';
    self::$DO_WHAT_MAPPING[OWNER_INVISIBLE_JOB] = '資方(user_id={user_id})下架job={job_id}';
    self::$DO_WHAT_MAPPING[OWNER_TRASH_JOB] = '資方(user_id={user_id})放job={job_id}至垃圾桶';
    self::$DO_WHAT_MAPPING[SYS_INVISIBLE_JOB] = '系統下架job={job_id}';
    self::$DO_WHAT_MAPPING[SYS_SEND_VERIFY_TO_OWNER_EMAIL] = '系統寄審核通過信給資方job={job_id}'; 
    self::$DO_WHAT_MAPPING[SYS_SEND_UNVERIFY_TO_OWNER_EMAIL] = '系統寄審核未通過信給資方job={job_id}'; 
    self::$DO_WHAT_MAPPING[SYS_SEND_VISIBLE_TO_OWNER_EMAIL] = '系統寄上架信給資方job={job_id}'; 
    self::$DO_WHAT_MAPPING[SYS_SEND_INVISIBLE_TO_OWNER_EMAIL] = '系統寄下架信給資方job={job_id}'; 
    self::$DO_WHAT_MAPPING[SYS_SEND_TRASH_TO_OWNER_EMAIL] = '系統寄職缺刪除信給資方job={job_id}'; 
    self::$DO_WHAT_MAPPING[SYS_SEND_EXPIRED_TO_OWNER_EMAIL] = '系統寄職缺過期信給資方job={job_id}'; 
    self::$DO_WHAT_MAPPING[USER_APPLY_JOB] = '使用者{user_id}投了履歷給job={job_id}'; 
  }

  public function getJobHistoryById($id) {
    $sql = 'SELECT * FROM '.self::TBL.' WHERE history_id = :history_id';
    return $this->_getOne($sql, ['history_id'=>$id], $this->entityClass);
  }

  public function save($job_id, $user_id, $do_what_id, $meta=array()){
    $a = [];
    $a['job_id'] = $job_id;
    $a['user_id'] = $user_id;
    $a['do_what_id'] = $do_what_id;
    $ary_json = ['job_id'=>$job_id, 'user_id'=>$user_id]; # MUST cover/satisfy ALL of DO_WHAT_MAPPING elements
    $a['do_what'] = replace_by_dic(
                      self::$DO_WHAT_MAPPING[$do_what_id],
                      $ary_json);
    $a['do_what_json'] = serialize(array_merge($ary_json, $meta));
    $a['do_what_datetime'] = date('Y-m-d H:i:s');
    $a['ip'] = $_SERVER['REMOTE_ADDR'];
    $a['ua'] = isset($_SERVER['HTTP_USER_AGENT']) ? $_SERVER['HTTP_USER_AGENT'] : '';
    $a['referer'] = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : 'no refer';

    $sql = "INSERT INTO ".self::TBL." (job_id,user_id,do_what_id,do_what,do_what_json,do_what_datetime,ip,ua,referer) values (:job_id,:user_id,:do_what_id,:do_what,:do_what_json,:do_what_datetime,:ip,:ua,:referer)";
    $stmt = $this->db->prepare($sql);
    $result = $stmt->execute($a);
    return $this->db->lastInsertId();
  }
}