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; } } }