<?php
class Service_CurrencyLog extends Common_Service
{
    /**
     * @var null
     */
    public static $_modelClass = null;

    /**
     * @return Table_Currency|null
     */
    public static function getModelInstance()
    {
        if (is_null(self::$_modelClass)) {
            self::$_modelClass = new Table_CurrencyLog();
        }
        return self::$_modelClass;
    }

    /**
     * @param $row
     * @return mixed
     */
    public static function add($row)
    {
        $model = self::getModelInstance();
        return $model->add($row);
    }


    /**
     * @param $row
     * @param $value
     * @param string $field
     * @return mixed
     */
    public static function update($row, $value, $field = "currency_id")
    {
        $model = self::getModelInstance();
        return $model->update($row, $value, $field);
    }

    /**
     * @param $value
     * @param string $field
     * @return mixed
     */
    public static function delete($value, $field = "currency_id")
    {
        //$model = self::getModelInstance();
        //return $model->delete($value, $field);
        //基础数据已经建立，不允许删除
        return false;
    }

    /**
     * @param $value
     * @param string $field
     * @param string $colums
     * @return mixed
     */
    public static function getByField($value, $field = 'currency_id', $colums = "*")
    {
        $model = self::getModelInstance();
        return $model->getByField($value, $field, $colums);
    }

    /**
     * @return mixed
     */
    public static function getAll()
    {
        $model = self::getModelInstance();
        return $model->getAll();
    }
    
    public static function getKeyVal() {
    	$aKeyVal = array();
    	$list = self::getAll();
    	foreach($list as $row)
    		$aKeyVal[$row['currency_code']] = $row['currency_hs_code'];
    	return $aKeyVal;
    }

    /**
     * @param array $condition
     * @param string $type
     * @param int $pageSize
     * @param int $page
     * @param string $order
     * @return mixed
     */
    public static function getByCondition($condition = array(), $type = '*', $pageSize = 0, $page = 1, $order = "")
    {
        $model = self::getModelInstance();
        return $model->getByCondition($condition, $type, $pageSize, $page, $order);
    }

    /**
     * @param $currency_batch_number
     * @return array
     */
    public static function getByBatchnumber($currency_batch_number='')
    {
        $model = self::getModelInstance();
        $result = array();
        if(!empty($currency_batch_number)){
            $results = $model->getByCondition(array('currency_batch_number'=>$currency_batch_number));
            foreach ($results as $k => $v) {
                $result[$v['currency_code']] = $v;
            }
        }
        return $result;
    }

    /**
     * @param $val
     * @return array
     */
    public static function validator($val)
    {
        $validateArr = $error = array();
        
        $validateArr[] = array("name" =>EC::Lang('currencyName'), "value" =>$val["currency_name_en"], "regex" => array("require",));
        $validateArr[] = array("name" =>EC::Lang('currencyNameEn'), "value" =>$val["currency_name"], "regex" => array("require",));
        $validateArr[] = array("name" =>EC::Lang('currencyCode'), "value" =>$val["currency_code"], "regex" => array("require",));
        $validateArr[] = array("name" =>EC::Lang('currencyDecimalPlaces'), "value" =>$val["currency_decimal_places"], "regex" => array("positive"));
        $validateArr[] = array("name" =>EC::Lang('currencyRate'), "value" =>$val["currency_rate"], "regex" => array("require","positive1",));
        return  Common_Validator::formValidator($validateArr);
    }


    /**
     * @param array $params
     * @return array
     */
    public  function getFields()
    {
        $row = array(
        
              'E0'=>'currency_id',
              'E1'=>'currency_name_en',
              'E2'=>'currency_name',
              'E3'=>'currency_code',
              'E4'=>'currency_symbol_left',
              'E5'=>'currency_symbol_right',
              'E6'=>'currency_decimal_point',
              'E7'=>'currency_thousands_point',
              'E8'=>'currency_decimal_places',
              'E9'=>'currency_rate',
              'E10'=>'currency_update_time',
              'E11'=>'currency_add_time',
              'E12'=>'currency_stop_time',
        );
        return $row;
    }
    /**
     * @author william-fan
     * @param varchar $code_from
     * @param varchar $code_to
     * @param $value
     * @param $currency_batch_number_or_feeTime 指定汇率编号或者指定费用发生时间，用于重新计算或财务检验
     */
    public static function converByCode($code_from,$code_to,$value,$currency_batch_number_or_feeTime=''){
    	if($code_from == '' || $code_to == '' || $value == ''){
    		return 0;
    	}
    	if($code_from == $code_to){
    		return $value;
    	}
        if(empty($currency_batch_number_or_feeTime)){
            $row_from   = self::getByField($code_from,'currency_code');
            $row_to     = self::getByField($code_to,'currency_code');
        }
        if(!empty($currency_batch_number_or_feeTime)){
            if(preg_match("/^[0-9]{4}(\-)[0-9]{1,2}(\-)[0-9]{1,2}([0-9]{1,2}(:[0-9]{1,2}(:[0-9]{1,2})))$/",$currency_batch_number_or_feeTime)){
                //按时间查询
                $row_from   = selft::getByCondition(array('currency_code'=>$code_from, 'currency_date'=>$currency_batch_number_or_feeTime));
                $row_to     = selft::getByCondition(array('currency_code'=>$code_to, 'currency_date'=>$currency_batch_number_or_feeTime));
            } else if(preg_match("/^[0-9]{11}$/",$currency_batch_number_or_feeTime)){
                //按汇率编号查询
                $row_from   = selft::getByCondition(array('currency_code'=>$code_from, 'currency_batch_number'=>$currency_batch_number_or_feeTime));
                $row_to     = selft::getByCondition(array('currency_code'=>$code_to, 'currency_batch_number'=>$currency_batch_number_or_feeTime));
            } else {
                //参数无效，直接取当前汇率
                $row_from   = self::getByField($code_from,'currency_code');
                $row_to     = self::getByField($code_to,'currency_code');
            }
        }
        
    	if(empty($row_from) || empty($row_to)){
    		return 0;
    	}
    	$transValue = ($value*$row_from['currency_rate'])/$row_to['currency_rate'];
    	return sprintf('%.2f',$transValue);
    }

}