<?php
/**
 * 账号列表
 * 
 * @author Daniel Chen
 */

class Table_Account {
  const ACCOUNT_FETCH_ALL = 0;
  const ACCOUNT_FETCH_ROW = 1;
  const ACCOUNT_FETCH_ONE = 2;

  protected $_table = NULL;

  public function __construct() {
    $this->_table = new DbTable_Account();
  }

  /**
   * 账号列表数据插入
   * 
   * @param array $data 字段 => 值
   * @return mixed 所插入行的主键值
   */
  public function insert($data) {
    return $this->_table->insert($data);
  }

  /**
   * 账号列表数据更新
   * 
   * @param array $data 字段 => 值
   * @param mixed $value 需要检索的字段值
   * @param string $key 需要检索的字段，默认为主键
   * @return integer 所更新的行数
   */
  public function update($data, $value, $key = 'account_id') {
    $where = $this->_table->getAdapter()->quoteInto("{$key}=?", $value);

    return $this->_table->update($data, $where);
  }

  public function getByField($value, $field = 'account_id', $colums = "*"){
      $select = $this->_table->getAdapter()->select();
      $table = $this->_table->info('name');
      $select->from($table, $colums);
      $select->where("{$field} = ?", $value);
      return $this->_table->getAdapter()->fetchRow($select);
  }

  /**
   * 账号列表据删除
   * 
   * @param mixed $value 需要检索的字段值
   * @param string $key 需要检索的字段，默认为主键
   * @return integer 所删除的行数
   */
  public function delete($value, $key = 'account_id') {
    $where = $this->_table->getAdapter()->quoteInto("{$key}=?", $value);

    return $this->_table->delete($where);
  }

  /**
   * 根据指定条件获取相关数据
   * 
   * @param array $condition 需要检索的条件
   * @param boolean $count 只获取统计数量，默认为FALSE
   * @return mixed
   */
  public function getByCondition($condition, $count = FALSE) {
    $type = self::ACCOUNT_FETCH_ALL;
    $select = $this->_table->getAdapter()->select();
    $table = $this->_table->info('name');

    if ($count) {
      $select->from($table, 'count(*)');
      $type = self::ACCOUNT_FETCH_ONE;
    }
    elseif (isset($condition['field']) && is_array($condition['field']) && !empty($condition['field'])) {
      $select->from($table, join($condition['field'], ','));
    }
    elseif (isset($condition['field']) && is_string($condition['field']) && !empty($condition['field'])) {
      $select->from($table, $condition['field']);
    }
    else {
      $select->from($table, '*');
    }

    if (isset($condition['account_id']) && is_numeric($condition['account_id'])) {
      $select->where('account_id=?', (int) $condition['account_id']);
      $count ? NULL : $type = self::ACCOUNT_FETCH_ROW;
    }

    if (isset($condition['account_code']) && !empty($condition['account_code'])) {
      $select->where('account_code=?', $condition['account_code']);
      $count ? NULL : $type = self::ACCOUNT_FETCH_ROW;
    }

    if (isset($condition['account_email']) && !empty($condition['account_email'])) {
      $select->where('account_email=?', $condition['account_email']);
      $count ? NULL : $type = self::ACCOUNT_FETCH_ROW;
    }

    if (isset($condition['customer_id']) && is_numeric($condition['customer_id'])) {
      $select->where('customer_id=?', (int) $condition['customer_id']);
    }

    if (isset($condition['customer_code']) && !empty($condition['customer_code'])) {
      $select->where('customer_code=?', $condition['customer_code']);
    }

    if (isset($condition['account_status']) && !empty($condition['account_status'])) {
      $select->where('account_status=?', $condition['account_status']);
    }

    if (isset($condition['account_name']) && !empty($condition['account_name'])) {
      $select->where('account_name=?', $condition['account_name']);
    }

    if (isset($condition['account_password']) && !empty($condition['account_password'])) {
      $select->where('account_password=?', $condition['account_password']);
    }

    if (isset($condition['forgotten_auth_key']) && !empty($condition['forgotten_auth_key'])) {
      $select->where('forgotten_auth_key=?', $condition['forgotten_auth_key']);
    }

    if (isset($condition['page']) && is_numeric($condition['page'])
      && isset($condition['size']) && is_numeric($condition['size'])) {
      $page = (int) $condition['page'];
      $size = (int) $condition['size'];

      if ($page > 0 && $size > 0) {
        $select->limit($size, ($page - 1) * $size);
      }
    }

    switch ($type) {
      case self::ACCOUNT_FETCH_ALL:
        return $this->_table->getAdapter()->fetchAll($select);
        break;

      case self::ACCOUNT_FETCH_ROW:
        return $this->_table->getAdapter()->fetchRow($select);
        break;

      case self::ACCOUNT_FETCH_ONE:
        return $this->_table->getAdapter()->fetchOne($select);
        break;

      default:
        return NULL;
        break;
    }
  }

  /**
   * 判断用户名是否唯一（客户子账号）
   * 
   * @param string $name 用户名
   * @param integer|string $customer 客户ID或代码
   * @return boolean
   */
  public function isUniqueName($name, $customer) {
    $condition['account_name'] = $name;

    if (is_numeric($customer)) {
      $condition['customer_id'] = (int) $customer;
    }
    else {
      $condition['customer_code'] = $customer;
    }

    if ($this->getByCondition($condition, TRUE)) {
      return FALSE;
    }

    return TRUE;
  }

  /**
   * 判断邮箱是否唯一（全局）
   * 
   * @param string $email 邮箱
   * @return boolean
   */
  public function isUniqueEmail($email) {
    if (Service_Customer::getByField($email, 'customer_email')) {
      return FALSE;
    }
    elseif ($this->getByCondition(array('account_email' => $email), TRUE)) {
      return FALSE;
    }

    return TRUE;
  }
}