xyzshop/mobile/control/test.php

<?php

defined('InShopNC') or exit('Access Invalid!');

//require_once '/Users/stanley-king/work/PHPProject/shopnc/core/framework/function/http.php';
class testControl extends mobileHomeControl
{
    private static $appURL = 'http://223.4.48.187:30004/lrlzApiRest/router/rest';
    private static $appkey = '2015panda';
    private static $appPassWord = 'nEs5vu86JSjh89WPW4de2d3e87rwli3e8rw';

    public function __construct()
    {
        parent::__construct();
    }

    // 更新商品序列号
    public function updateGoodsSerialOp()
    {
        $sku_map = Model()->table('sku_map')->limit(10000)->select();

        foreach ($sku_map as $value) {

            $condition = array('goods_serial_tm' => trim($value['tmsku']));
            $updateinfo = array('goods_serial' => $value['psku']);

            $ret = Model('goods_common')->where($condition)->update($updateinfo);

        }

        joutput_data(array("ret" => 'complete'));
    }

    private function getSign($data){
        return md5(self::$appkey . self::$appPassWord . $data);
    }

    public function test_deliveryOp()
    {
//        $pay_sn = $_POST['pay_sn'];
//        $trade_no = $_POST['trade_no'];

//        $logic_delivery = Logic('delivery');
//        $ret = $logic_delivery->putOrder($pay_sn, $trade_no);

        //joutput_data($ret);
        $outdata = '{"type":"PUT_TRADE","data":[{"tid":"8000000000026501","total_fee":"360.00","discount_fee":"","post_fee":"0.00","created":"2016-01-11 14:51:39","pay_time":"2016-01-11 14:51:39","buyer_message":"","express_code":"","pay_account_type":"\u5fae\u4fe1\u652f\u4ed8","pay_account_id":"","pay_account_no":"1007070763201601112636550146","buyer_nick":"anonymous_36365","buyer_email":"","trade_memo":"","receiver_name":"\u6c5f\u6d77\u82d7","receiver_state":"\u4e0a\u6d77","receiver_city":"\u4e0a\u6d77\u5e02","receiver_district":"\u5f90\u6c47\u533a","receiver_address":"\u756a\u79ba\u8def876\u53f7","receiver_zip":"000000","receiver_mobile":"13911129867","receiver_phone":"","order_size":1,"orderList":[{"oid":"80000000000265010","tid":"8000000000026501","title":"DQ\u8482\u73c2 \u5378\u5986\u6cb9170ml 170ml","price":"360.00","num":"1","outer_sku_id":"P0300292","outer_sku_properties_name":"DQ\u8482\u73c2 \u5378\u5986\u6cb9170ml 170ml","buyer_nick":"anonymous_36365"}]}]}';

        $sign = $this->getSign($outdata);

        $headers = array('v_appkey: '.self::$appkey,'v_sign: '.$sign, 'Content-Type: application/json');
        http_request(self::$appURL,$outdata,'POST',false,$headers);
    }

    public function test_callbackOp()
    {
        $param['order_sn'] = $_POST['tid'];
        $status = $_POST['status'];
        //$param['consign_time'] = $_POST['consign_time'];
        $param['shipping_code'] = $_POST['logistics_no'];
        $param['oms_code'] = $_POST['logistics_company'];

        if(intval($status) === 1){
            $logic_delivery = Logic('delivery');
            $ret = $logic_delivery->handleCallback($param);
            joutput_data($ret);
        }else{

        }
    }

    /**
     * 首页
     */
    public function indexOp(){

        $t = time();

        $t1 = date("D F d Y",1452355200);

//        $payment = 500;
//        $payment = $payment = $this->getAndUpdateBonus(36218,$payment);
//        joutput_data(array('$payment'=>$payment));

        // 修改地址
        $order_id = "order_id in (297, 401, 923, 928,1097,1145,1150,1154,1244,1248,1281)";
        $model = Model('order_common')->where($order_id)->select();
        $model_address = Model('area');
        $recv_info_array = array();
        if ($model != null) {

            foreach ($model as $val) {
                $recv_info = unserialize($val['reciver_info']);

                $recv_info['area'] = $model_address->formatAddress($recv_info['area']);
                Model()->table('recv_info')->insert(array('order_id' => $val['order_id'], 'reciver_info' => serialize($recv_info)));

                Model('order_common')->where(array('order_id'=>$val['order_id']))->update(array('reciver_info' => serialize($recv_info)));

                array_push($recv_info_array, $recv_info);
            }
        }

        joutput_data($recv_info_array);
    }

    public function getAndUpdateBonus($user_id,$pay_amount){

        $condition['user_id'] = $user_id;
        $condition['bonus_type_id'] = 1;
        $bonus_list = Model()->table("user_bonus")->where($condition)->select();

        $ret_value = 0;
        if (!empty($bonus_list)) {

            foreach ($bonus_list as $value) {
                $bonus_value = doubleval($value['bonus_value']);

                if (($pay_amount - $bonus_value) > 0.0000001) {

                    $data['bonus_value'] = 0;
                    $ret = Model()->table('user_bonus')->where(array('bonus_id' => $value['bonus_id']))->update($data);

                    if($ret){
                        $pay_amount -= $bonus_value;
                    }
                } else {

                    $data['bonus_value'] = $bonus_value - $pay_amount;
                    $ret = Model()->table('user_bonus')->where(array('bonus_id' => $value['bonus_id']))->update($data);

                    if($ret) {
                        $pay_amount = 0;
                    }
                    break;
                }
            }
        }

        return $pay_amount;
    }

    /**
     * order_sn
     * member_id
     * 
     * 手动退款接口
     */
    public function refundOp(){
        $model_order = Model('order');
        $model_trade = Model('trade');

        $order_info = Model('order')->getOrderInfo(array('order_sn' => $_GET['order_sn']));
        if (empty($order_info)) return;

        $model_refund = Model('refund_return');        
        $order_id = intval($order_info['order_id']);
        $condition = array();
        $condition['buyer_id'] = $order_info['buyer_id'];
        $condition['order_id'] = $order_id;
        $order = $model_refund->getRightOrderList($condition);
        $order_amount = $order['order_amount'];//订单金额
        $condition = array();
        $condition['buyer_id'] = $order['buyer_id'];
        $condition['order_id'] = $order['order_id'];
        $condition['goods_id'] = '0';
        $condition['seller_state'] = array('lt','3');
        $refund_list = $model_refund->getRefundReturnList($condition);
        $refund = array();
        if (!empty($refund_list) && is_array($refund_list)) {
            $refund = $refund_list[0];
        }
        $order_paid = $model_trade->getOrderState('order_paid');//订单状态20:已付款
        $payment_code = $order['payment_code'];//支付方式
        if ($refund['refund_id'] > 0 || $order['order_state'] != $order_paid || $payment_code == 'offline') {//检查订单状态,防止页面刷新不及时造成数据错误
            joutput_error(array("result" => false));
            return false;
        }

        $refund_array = array();
        $refund_array['refund_type'] = '1';//类型:1为退款,2为退货
        $refund_array['seller_state'] = '1';//状态:1为待审核,2为同意,3为不同意
        $refund_array['order_lock'] = '2';//锁定类型:1为不用锁定,2为需要锁定
        $refund_array['goods_id'] = '0';
        $refund_array['order_goods_id'] = '0';
        $refund_array['reason_id'] = '0';
        $refund_array['reason_info'] = '取消订单，全部退款';
        $refund_array['goods_name'] = '订单商品全部退款';
        $refund_array['refund_amount'] = ncPriceFormat($order_amount);
        $refund_array['buyer_message'] = $_POST['buyer_message'];
        $refund_array['add_time'] = time();

        $pic_array = array();
        $pic_array['buyer'] = '';//$this->upload_pic();//上传凭证
        $info = serialize($pic_array);
        $refund_array['pic_info'] = $info;
        $state = $model_refund->addRefundReturn($refund_array,$order);

        if ($state) {
            $model_refund->editOrderLock($order_id);
            joutput_data(array("result" => true));
            return true;
        } else {
            joutput_error(array("result" => false));
            return false;
        }
    }
}