<?php


/**
 *
 */
class TylerTech_DB_Conn
{
  private static $Database = "localhost";
  private static $DBUser = "ren";
  private static $DBPassword = "nope";
  private static $DBname = "test";

  private static function get_connection()
  {
    $conn = mysqli_connect(self::$Database, self::$DBUser, self::$DBPassword, self::$DBname);

    if (mysqli_connect_errno())
    {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      return false;
    }

    mysqli_autocommit($conn, TRUE);

    return $conn;
  }

  public static function add_employee($id, $first_name, $last_name, $manager_id = false)
  {
    $conn = self::get_connection();

    $sql = "INSERT INTO Employees (id_employee, first_name, last_name)
            VALUES('$id', '$first_name', '$last_name');";
    if(!$manager_id)
    {
      $sql = "INSERT INTO Employees (id_employee, first_name, last_name, id_manager)
              VALUES('$id', '$first_name', '$last_name', '$manager_id');";
    }

    $result = true;
    if(!mysqli_query($conn, $sql))
    {
      $result = false;
      echo "error: " . mysqli_error($conn);
    }

    $conn->close();
    return $result;
  }

  public static function add_role($id_role, $id_employee)
  {
    $conn = self::get_connection();

    $sql = "INSERT INTO conn_Roles_To_Employees (id_role, id_employee)
            VALUES($id_role,$employee_id);";

    $result = false;
    if(mysqli_query($conn, $sql))
    {
      $result = true;
    }

    $conn->close();
    return $result;
  }

  public static function add_roles($employee_id, $roles_id_array)
  {
    $conn = self::get_connection();

    $success = array();
    foreach($roles_id_array as $id_role)
    {
      $sql = "INSERT INTO conn_Roles_To_Employees (id_role, id_employee)
              VALUES($employee_id, $id_role);";

      if ($conn->query($sql) === TRUE)
      {
        $result = true;
      }
    }

    $conn->close();
    return $result;
  }

  public static function get_employee($id)
  {
    if(!isset($id))
    {
      return false;
    }

    if(gettype($id) !== "integer")
    {
      return false;
    }

    $conn = self::get_connection();
    $sql = "SELECT * FROM Employees WHERE id_employee = $id";

    $result = $conn->query($sql);

    if($result->num_rows <= 0)
    {
      return false;
    }

    $employee = $result->fetch_assoc();

    $conn->close();
    return $employee;
  }

  public static function get_employees()
  {
    $conn = self::get_connection();
    $sql = "SELECT * FROM Employees";

    $result = mysqli_query($conn,$sql);

    if($result->num_rows <= 0)
    {
      return false;
    }

    $employees = array();
    while ($row = $result->fetch_assoc()) {
      $employees[] = $row;
    }

    $conn->close();
    return $employees;
  }

  public static function get_roles()
  {
    $conn = self::get_connection();
    $sql = "SELECT * FROM Roles";

    $result = mysqli_query($conn,$sql);

    if($result->num_rows <= 0)
    {
      return false;
    }

    $roles = array();
    while ($row = $result->fetch_assoc()) {
      $roles[] = $row;
    }

    $conn->close();
    return $roles;
  }
}


?>