xiang_api/application/api/controller/Present.php

<?php

namespace app\api\controller;
use app\common\library\LianLianPay;
use llianpay\accp\security\LLianPayAccpSignature;
use think\cache\driver\Redis;
use think\Db;
class Present extends Base
{

    public function send()
    {
        $send_phone = '18632645580';// 赠送人手机号
        $receipt_phone = '17666660370';// 被赠送人手机号
        $send_user = Db::name('store_member')->field('id')->where('phone',$send_phone)->where('is_deleted',0)->find();
        $receipt_user = Db::name('store_member')->field('id')->where('phone',$receipt_phone)->where('is_deleted',0)->find();
        $list = Db::name('store_order_info')
            ->where('mid',$send_user['id'])
            ->where('status','neq','2')
            ->where('is_destruction',1)
            ->where('c_id',11)
            ->where('collectors_hash','<>','')
            ->where('type','<>',3)
            ->where('resale_status',1)
            ->where('id','<', 33747)
            ->order('id asc')
            ->limit(0,780)
            ->select();
       /* $sql = "SELECT * FROM `xianglian`.`store_order_info` WHERE `mid` = '2192' AND `status` <> '2' AND `is_destruction` = '1' AND `resale_status` = '1' AND `c_id` = '21' LIMIT 0,10";
        $list = Db::query($sql);// 赠送数据*/
        $send_num = 0;
        $error_ids =[];
        var_dump(count($list));
        die();
        foreach ($list as $v) {
           $res = static::examples($send_user['id'],$v['id'],$receipt_phone);
           if ($res['status'] == 1) $send_num++;
           if ($res['status'] == 0) $error_ids[] = $v['id'];
        }
        var_dump($send_num,$error_ids);
    }
    // 转赠
    public static function examples($send_user_id,$id,$receipt_phone){
        if (!$id || !$receipt_phone ) return['status'=>0 ,'msg'=>'参数错误'];
        $info = Db::name('store_order_info')->where('id',$id)->where('mid',$send_user_id)->find();
        if (!$info)  return['status'=>0 ,'msg'=>'藏品不存在'];
        if ($info['status']==2) return['status'=>0 ,'msg'=>'藏品已转赠'];
        $member = Db::name('store_member')->where('phone',$receipt_phone)->find();
        if (!$member) return['status'=>0 ,'msg'=>'转赠用户不存在'];
        if($member['id'] == $send_user_id) return['status'=>0 ,'msg'=>'自己无法转赠给自己'];
        if (!$info['collectors_hash'] && $info['type'] != 3)  return['status'=>0 ,'msg'=>'发放中，无法转赠'];

        $pro_info = Db::name('store_collection')->where('id',$info['c_id'])->find();
        $log = Db::name('store_collect_examples_log')->where('order_info_id',$id)->find();
        if (!$log){
            if ($pro_info['one_given_day']!=0){
                $exam_time = strtotime($info['create_at'])+($pro_info['one_given_day']*60*60);
                if ($exam_time>time())return['status'=>0 ,'msg'=>'持有时间限制，无法转赠'];
            }
        }else{
            if ($pro_info['other_given_day']!=0){
                $exam_time = strtotime($log['create_at'])+($pro_info['other_given_day']*60*60);
                if ($exam_time>time()) return['status'=>0 ,'msg'=>'持有时间限制，无法转赠2'];
            }
        }
        Db::startTrans();
        try {
            Db::name('store_order_info')->where('id',$id)
                ->update(['status'=>2,'over_time'=>date('Y-m-d H:i:s'),'to_mid'=>$member['id'],'verify'=>Db::raw('verify - 1')]);
            $to_date = [
                'order_id'=>$info['order_id'],
                'order_no'=>get_order_sn(),
                'tag'=>$info['tag'],
                'mid'=>$member['id'],
                'c_id'=>$info['c_id'],
                'name'=>$pro_info['name'],
                'cover'=>$pro_info['cover'],
                'pro_info'=>$info['pro_info'],
                'status'=>3,
                'type' => $info['type'],
                'to_mid'=>$send_user_id,
                'over_time'=>date('Y-m-d H:i:s'),
                'company'=>'象链数藏',
                'company_hash'=>$info['company_hash'],
                'company_hash_time'=>$info['company_hash_time'],
                'ddcid'=>$info['ddcid'],
                'collectors_hash'=>'',
                'collectors_hash_time'=>date('Y-m-d H:i:s')
            ];
            $new_id = Db::name('store_order_info')->insertGetId($to_date);
            $log_date = [
                'order_info_id'=>$new_id,
                'mid'=>$send_user_id,
                'to_mid'=>$member['id'],
                'date'=>date('Y-m')
            ];
            Db::name('store_collect_examples_log')->insert($log_date);
            Db::commit();
            return['status'=>1 ,'msg'=>'转赠成功'];
        }catch (\Exception $e){
            Db::rollback();
            return['status'=>0 ,'msg'=>'转赠失败'];
        }
    }


}