fossasia/engelsystem

<?php

/**
 * Delete an Angeltype.
 *
 * @param Angeltype $angeltype
 */
function AngelType_delete($angeltype) {
  return sql_query("
      DELETE FROM `AngelTypes`
      WHERE `id`='" . sql_escape($angeltype['id']) . "'
      LIMIT 1");
}

/**
 * Update Angeltype.
 *
 * @param int $angeltype_id
 * @param string $name
 * @param bool $restricted
 * @param string $description
 * @param bool $requires_driver_license
 */
function AngelType_update($angeltype_id, $name, $restricted, $description, $requires_driver_license) {
  return sql_query("
      UPDATE `AngelTypes` SET
      `name`='" . sql_escape($name) . "',
      `restricted`=" . sql_bool($restricted) . ",
      `description`='" . sql_escape($description) . "',
      `requires_driver_license`=" . sql_bool($requires_driver_license) . "
      WHERE `id`='" . sql_escape($angeltype_id) . "'
      LIMIT 1");
}

/**
 * Create an Angeltype.
 *
 * @param string $name
 * @param boolean $restricted
 * @param string $description
 * @return New Angeltype id
 */
function AngelType_create($name, $restricted, $description, $requires_driver_license) {
  $result = sql_query("
      INSERT INTO `AngelTypes` SET
      `name`='" . sql_escape($name) . "',
      `restricted`=" . sql_bool($restricted) . ",
      `description`='" . sql_escape($description) . "',
      `requires_driver_license`=" . sql_bool($requires_driver_license));
  if ($result === false)
    return false;
  return sql_id();
}

/**
 * Validates a name for angeltypes.
 * Returns array containing validation success and validated name.
 *
 * @param string $name
 * @param AngelType $angeltype
 */
function AngelType_validate_name($name, $angeltype) {
  $name = strip_item($name);
  if ($name == "")
    return array(
        false,
        $name
    );
  if (isset($angeltype) && isset($angeltype['id']))
    return array(
        sql_num_query("
        SELECT *
        FROM `AngelTypes`
        WHERE `name`='" . sql_escape($name) . "'
        AND NOT `id`='" . sql_escape($angeltype['id']) . "'
        LIMIT 1") == 0,
        $name
    );
  else
    return array(
        sql_num_query("
        SELECT `id`
        FROM `AngelTypes`
        WHERE `name`='" . sql_escape($name) . "'
        LIMIT 1") == 0,
        $name
    );
}

/**
 * Returns all angeltypes and subscription state to each of them for given user.
 *
 * @param User $user
 */
function AngelTypes_with_user($user) {
  return sql_select("
      SELECT `AngelTypes`.*,
      `UserAngelTypes`.`id` as `user_angeltype_id`,
      `UserAngelTypes`.`confirm_user_id`,
      `UserAngelTypes`.`coordinator`
      FROM `AngelTypes`
      LEFT JOIN `UserAngelTypes` ON `AngelTypes`.`id`=`UserAngelTypes`.`angeltype_id`
      AND `UserAngelTypes`.`user_id`=" . $user['UID'] . "
      ORDER BY `name`");
}

/**
 *
 * Returns all angeltypes.
 *
 */
function AngelTypes() {
  return sql_select("
      SELECT *
      FROM `AngelTypes`
      ORDER BY `name`");
}

/**
 *
 * Returns AngelType id array
 *
 */
function AngelType_ids() {
  $angelType_source = sql_select("SELECT `id` FROM `AngelTypes`");
  if ($angelType_source === false)
    return false;
  if (count($angelType_source) > 0)
    return $angelType_source;
  return null;
}

/**
 * Returns angelType by id.
 *
 * @param $id angelType
 *          ID
 */
function AngelType($id) {
  $angelType_source = sql_select("SELECT * FROM `AngelTypes` WHERE `id`='" . sql_escape($id) . "' LIMIT 1");
  if ($angelType_source === false)
    return false;
  if (count($angelType_source) > 0)
    return $angelType_source[0];
  return null;
}

/**
 *
 * Returns angelType id, name array.
 *
 */
function select_id_name_Angeltypes() {
  return sql_select("SELECT `id`, `name` FROM `AngelTypes` ORDER BY `name`");
}

/**
 *
 * Returns restricted angelType id, name.
 *
 */
function selects_restricted_angeltypes_by_ids() {
  return sql_select("SELECT `AngelTypes`.`id`, `AngelTypes`.`name`, (`AngelTypes`.`restricted`=0 OR (NOT `UserAngelTypes`.`confirm_user_id` IS NULL OR `UserAngelTypes`.`id` IS NULL)) as `enabled` FROM `AngelTypes` LEFT JOIN `UserAngelTypes` ON (`UserAngelTypes`.`angeltype_id`=`AngelTypes`.`id` AND `UserAngelTypes`.`user_id`='" . sql_escape($user['UID']) . "') ORDER BY `AngelTypes`.`name`");
}

/**
 *
 * Returns unrestricted angelType id, name.
 *
 */
function selects_unrestricted_angeltype() {
  sql_select("SELECT `id`, `name` FROM `AngelTypes` WHERE `restricted` = 0");
}

/**
 *
 * Returns angelType id, name array order by name.
 *
 */
function selects_angeltype_ids() {
  return sql_select("SELECT `id`, `name` FROM `AngelTypes` ORDER BY `AngelTypes`.`name`");
}

/**
 * Returns angelType by id.
 *
 * @param $type_id angelType
 *          ID
 */
function selects_angeltype_by_types($type_id) {
  return sql_select("SELECT * FROM `AngelTypes` WHERE `id`='" . sql_escape($type_id) . "' LIMIT 1");
}

/**
 * Returns AngelTypes, NeedAngelTypes
 *
 * @param $rid NeededAngelType Roomid
 *          ID
 */
function selects_needed_angeltypes_by_roomid($rid) {
  return sql_select("SELECT `AngelTypes`.*, `NeededAngelTypes`.`count` FROM `AngelTypes` LEFT JOIN `NeededAngelTypes` ON (`NeededAngelTypes`.`angel_type_id` = `AngelTypes`.`id` AND `NeededAngelTypes`.`room_id`='" . sql_escape($rid) . "') ORDER BY `AngelTypes`.`name`");
}

/**
 * Returns AngelTypes, NeedAngelTypes
 *
 * @param $sid NeededAngelType Roomid
 *          ID
 */
function selects_needed_angeltypes_by_shiftid($sid) {
  return sql_select("SELECT `AngelTypes`.*, `NeededAngelTypes`.`count` FROM `AngelTypes` LEFT JOIN `NeededAngelTypes` ON (`NeededAngelTypes`.`angel_type_id` = `AngelTypes`.`id` AND `NeededAngelTypes`.`shift_id`='" . sql_escape($sid) . "') ORDER BY `AngelTypes`.`name`");
}

/**
 *
 * Returns AngelTypes order by name
 *
 */
function selects_angeltype_by_names() {
  return sql_select("SELECT * FROM `AngelTypes` ORDER BY `name`");
}

?>