<?php
class Service_FeeCostDetail extends Common_Service
{
    /**
     * @var null
     */
    public static $_modelClass = null;

    /**
     * @return Table_FeeCostDetail|null
     */
    public static function getModelInstance()
    {
        if (is_null(self::$_modelClass)) {
            self::$_modelClass = new Table_FeeCostDetail();
        }
        return self::$_modelClass;
    }

    /**
     * @param $row
     * @return mixed
     */
    public static function add($row)
    {
        $model = self::getModelInstance();
        return $model->add($row);
    }

    /**
     * @param $rows
     * @return mixed
     */
    public static function addMultiRows($rows)
    {
        $model = self::getModelInstance();
        if(!empty($rows) && is_array($rows)){
        foreach($rows as $row){
            $_tmp = $model->add($row);
            if(!($_tmp)){
                return false;
            }
        }
        return $_tmp;
        }
    }

    /**
     * @param $row
     * @param $value
     * @param string $field
     * @return mixed
     */
    public static function update($row, $value, $field = "fc_id")
    {
        $model = self::getModelInstance();
        return $model->update($row, $value, $field);
    }

    /**
     * @param $rows
     * @return mixed
     */
    public static function updateMultiRows($rows)
    {
        $model = self::getModelInstance();
        foreach($rows as $row){
            $where = array('code_number' => $row['code_number'], 'fee_code' => $row['fee_code']);
            $_tmp = $model->update($row, $where, '');
            if(!($_tmp)){
                return false;
            }
        }
        return $_tmp;
    }

    /**
     * @param $value
     * @param string $field
     * @return mixed
     */
    public static function delete($value, $field = "fc_id")
    {
        $model = self::getModelInstance();
        return $model->delete($value, $field);
    }

    /**
     * @param $value
     * @param string $field
     * @param string $colums
     * @return mixed
     */
    public static function getByField($value, $field = 'fc_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 getCodeVal() {
    	$aKeyVal = array();
    	$list = self::getAll();
    	foreach($list as $row)
    		$aKeyVal[$row['trade_country']] = $row['country_name'];
    	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 $val
     * @return array
     */
    public static function validator($val)
    {
        $validateArr = $error = array();
        
        $validateArr[] = array("name" =>EC::Lang('countryName'), "value" =>$val["country_name"], "regex" => array("require",));
        $validateArr[] = array("name" =>EC::Lang('countryNameEn'), "value" =>$val["country_name_en"], "regex" => array("require",));
        $validateArr[] = array("name" =>EC::Lang('country_code'), "value" =>$val["country_code"], "regex" => array("require",));
        $validateArr[] = array("name" =>EC::Lang('sort'), "value" =>$val["country_sort"], "regex" => array("positive"));
        return  Common_Validator::formValidator($validateArr);
    }


    /**
     * @param array $params
     * @return array
     */
    public  function getFields()
    {
        $row = array(
              'E1'  => 'fc_id',
              'E2'  => 'code_number',
              'E3'  => 'code_type',
              'E4'  => 'customer_code',
              'E5'  => 'reference_no',
              'E6'  => 'tracking_number',
              'E7'  => 'sm_code',
              'E8'  => 'country_code',
              'E9'  => 'fee_code',
              'E10' => 'fee_name',
              'E11' => 'fee_amount_org',
              'E12' => 'fee_currency_code_org',
              'E13' => 'cost_amount_org',
              'E14' => 'cost_currency_code_org',
              'E15' => 'fee_amount_customer',
              'E16' => 'fee_currency_code_customer',
              'E17' => 'cost_amount_sp',
              'E18' => 'cost_currency_code_sp',
              'E19' => 'discount_customer',
              'E20' => 'price_batch_number',
              'E21' => 'currency_batch_number',
              'E22' => 'fee_time',
              'E23' => 'fee_time_recalculate',
              'E24' => 'ip',
              'E25' => 'ip_recalculate',
              'E26' => 'operator',
              'E27' => 'operator_recalculate',
              'E28' => 'sp_code',
        );
        return $row;
    }
	
}