code_life leyangjun

<?php

class Mysql {
    public $table = 'DataBase';
    public function __construct() {
        $cache_time = isset(cacheConf::$scm2DB[$this->tbl]) ? cacheConf::$scm2DB[$this->tbl] : CACHE_TIME_DEFAULT;
        parent::__construct(appConf::$scm2DB, $cache_time);
    }

    public static function getPopOrderTotalByPo($po = '') {
        $pop_order_goods_data_handle = new scm2_popOrderGoodsDataHandle();
        $sql = "select count(distinct order_sn) total from pop_order_goods where po=:po and is_delete=:is_delete";
        $where_arr = array('po' => $po, 'is_delete' => 0);
        $ret = $pop_order_goods_data_handle->adminItem($sql, $where_arr, ' 通过PO获取直发订单总数');
        return isset($ret['total']) ? $ret['total'] : 0;
    }
  
    public static function getPopPassOrderTotalByPo($po = '') {
        $pop_order_goods_data_handle = new scm2_popOrderGoodsDataHandle();
        $sql = "select count(distinct order_sn) total from pop_order_goods where po=:po and is_delete=:is_delete and stat=:stat";
        $where_arr = array('po' => $po, 'is_delete' => 0, 'stat' => scmConf::$order_default_status);
        $ret = $pop_order_goods_data_handle->adminItem($sql, $where_arr, ' 通过PO获取直发已审核订单总数');
        return isset($ret['total']) ? $ret['total'] : 0;
    }

    public static function getPopShipOrderTotalByPo($po = '') {
        $pop_order_goods_data_handle = new scm2_popOrderGoodsDataHandle();
        $sql = "select count(distinct order_sn) total from pop_order_goods where po=:po and is_delete=:is_delete and stat>=" . scmConf::$order_ship_status . " and stat<>97";
        $where_arr = array('po' => $po, 'is_delete' => 0);
        $ret = $pop_order_goods_data_handle->adminItem($sql, $where_arr, ' 通过PO获取直发已发货订单总数');
        return isset($ret['total']) ? $ret['total'] : 0;
    }

    
    public static function getPopReturnAmountByOrderSnGoodSn($order_sn = '', $good_sn = '') {
        $pop_return_data_handle = new scm2_popReturnDataHandle();
        $sql = "select amount total from pop_return_goods where order_sn='$order_sn' and good_sn='$good_sn' order by create_time desc limit 1";
        $ret = $pop_return_data_handle->myItem($sql, array(), '通过订单号、商品条码获直发取退货数量');
        return isset($ret['total']) ? $ret['total'] : 0;
    }
}
?>