<?php
class Service_OrderProduct extends Common_Service
{
    /**
     * @var null
     */
    public static $_modelClass = null;

    /**
     * @return Table_OrderProduct|null
     */
    public static function getModelInstance()
    {
        if (is_null(self::$_modelClass)) {
            self::$_modelClass = new Table_OrderProduct();
        }
        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 = "op_id")
    {
        $model = self::getModelInstance();
        return $model->update($row, $value, $field);
    }

    /**
     * @param $value
     * @param string $field
     * @return mixed
     */
    public static function delete($value, $field = "op_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 = 'op_id', $colums = "*")
    {
        $model = self::getModelInstance();
        return $model->getByField($value, $field, $colums);
    }

    public static function getMaxCountPorduct()
    {
        $model = self::getModelInstance();
        return $model->getMaxCountPorduct();
    }
    /**
     * @return mixed
     */
    public static function getAll()
    {
        $model = self::getModelInstance();
        return $model->getAll();
    }
    
    public static function getInvoiceSkuData($order_code) {
    	$model = self::getModelInstance();
    	return $model->getInvoiceSkuData($order_code);
    }
    
    public static function sumPurposeDeclaredValue($order_code) {
    	$model = self::getModelInstance();
    	return $model->sumPurposeDeclaredValue($order_code);
    }

    /**
     * @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 type $orderCode
     * @return type
     */
    public static function getOrderProducts($orderCode) {
        $model = self::getModelInstance();
        return $model->getOrderProducts($orderCode);
    }
    
    public static function getOutBillProducts($aOrderCode) {
    	$model = self::getModelInstance();
    	//return $model->getOutBillProducts($aOrderCode);
    	$list = $model->getOutBillProducts($aOrderCode);
    	$result = array('total'=>0);
    	foreach($list as $row) {
    		$goods_code = $row['goods_id'];
    		if(!isset($result[$goods_code])) {
    			$result[$goods_code] = array();
    			$result[$goods_code]['goods_id'] = $goods_code;
    			$result[$goods_code]['customer_id'] = $row['customer_id'];
    			$result[$goods_code]['hs_code'] = $row['hs_code'];
    			$result[$goods_code]['hs_goods_name'] = $row['hs_goods_name'];
    			$result[$goods_code]['product_id'] = $row['product_id'];
    			//$result[$goods_code]['hum_quantity_law'] = $row['hum_quantity_law'];
    			$result[$goods_code]['hum_quantity_law'] = 0;
    			$result[$goods_code]['quantity'] = 0;
    			$result[$goods_code]['pu_code'] = $row['pu_code'];
    			$result[$goods_code]['pu_code_law'] = $row['pu_code_law'];
    			$result[$goods_code]['currency_code'] = $row['currency_code'];
    			$result[$goods_code]['pu_code_second'] = $row['pu_code_second'];
    			//$result[$goods_code]['hum_quantity_second'] = $row['hum_quantity_second'];
    			$result[$goods_code]['hum_quantity_second'] = 0;
    			$result[$goods_code]['total_price'] = 0;
    		}
			/* if($row['hum_num']>0) {
				if($row['quantity']==$row['hum_num']) {
					$result[$goods_code]['hum_quantity_law'] += $row['hum_quantity_law2']*$row['hum_num'];
					Service_HsUomMap::update(array('hum_num'=>0, 'hum_num_use'=>$row['hum_num']), $row['hum_id']);
				} else if($row['quantity']>$row['hum_num']) {
					$result[$goods_code]['hum_quantity_law'] += $row['hum_quantity_law2']*$row['hum_num'];
					$quantity = $row['quantity']-$row['hum_num'];
					$result[$goods_code]['hum_quantity_law'] += $row['hum_quantity_law']*$quantity;
					Service_HsUomMap::update(array('hum_num'=>0, 'hum_num_use'=>$row['hum_num']), $row['hum_id']);
				} else if($row['quantity']<$row['hum_num']) {
					$result[$goods_code]['hum_quantity_law'] += $row['hum_quantity_law2']*$row['quantity'];
					$hum_num = $row['hum_num'] - $row['quantity'];
					Service_HsUomMap::update(array('hum_num'=>$hum_num, 'hum_num_use'=>$row['quantity']), $row['hum_id']);
				}
			} else { */
    			$result[$goods_code]['hum_quantity_law'] += $row['hum_quantity_law']*$row['quantity'];
			//}
    		$result[$goods_code]['hum_quantity_second'] += $row['hum_quantity_second']*$row['quantity'];
    		$result[$goods_code]['quantity'] += $row['quantity'];
    		//$total_price = $row['quantity']*$row['product_declared_value'];
    		$total_price = $row['declared_value'];
    		$result[$goods_code]['total_price'] += $total_price;
    		$result['total'] += $total_price;
    	}
    	return $result;
    }
    /**
     * @author william-fan
     * @todo 用于校验hs_cod个数
     */
    public static function countOrderHscodeNum($order_code) {
        $model = self::getModelInstance();
        return $model->countOrderHscodeNum($order_code);
    }

    /**
     * @param $val
     * @return array
     */
    public static function validator($val)
    {
        $validateArr = $error = array();
        
        return  Common_Validator::formValidator($validateArr);
    }

    public static function getGoodsId($order_code){
        $model = self::getModelInstance();
        return $model->getGoodsId($order_code);
    }

    public static function getJoinProductByCondition($condition){
        $model = self::getModelInstance();
        return $model->getJoinProductByCondtion($condition);
    }

    public static function calNetWeightByCondition($condition){
        $model = self::getModelInstance();
        return $model->calNetWeightByCondition($condition);
    }

    public static function checkOrder($product_id){
        $model = self::getModelInstance();
        return $model->checkOrder($product_id);
    }
    public static function changeWeightCondition($product_id){
        $model = self::getModelInstance();
        return $model->changeWeightCondition($product_id);
    }
    // 通过日期获取出货数据
    public static function getShippingCount($shippingCountDate = '0000-00') {
        $model = self::getModelInstance();
        return $model->getShippingCount($shippingCountDate);
    }

    public static function getOrderNetWeight($order_code){
        $model = self::getModelInstance();
        return $model->getOrderNetWeight($order_code);
    }

    /**
     * @param array $params
     * @return array
     */
    public  function getFields()
    {
        $row = array(
        
              'E0'=>'op_id',
              'E1'=>'order_id',
              'E2'=>'order_code',
              'E3'=>'product_id',
              'E4'=>'product_barcode',
              'E5'=>'op_quantity',
              'E6'=>'op_category',
              'E7'=>'op_ref_tnx',
              'E8'=>'op_ref_item_id',
              'E9'=>'op_ref_buyer_id',
              'E10'=>'op_ref_paydate',
              'E11'=>'op_add_time',
              'E12'=>'op_update_time',
        );
        return $row;
    }

}