game-sdk/simplewind/huo/model/log/OrderCpLogModel.php

<?php
/**
 * OrderCpLogModel.php UTF-8
 *
 *
 * @date    : 2018/4/28 2:32
 *
 * @license 这不是一个自由软件，未经授权不许任何使用和传播。
 * @author  : wuyonghong <wyh@huosdk.com>
 * @version : HUOSDK 8.0
 */

namespace huo\model\log;

use huo\model\common\CommonModel;

class OrderCpLogModel extends CommonModel {
    protected $table_prefix = 'h_log_pay_cp_';

    public function insertLog($data, $replace = false, $get_last_insert_id = true) {
        $_data['pay_id'] = get_val($data, 'pay_id', 0);
        $_data['order_id'] = get_val($data, 'order_id', '');
        $_data['cp_order_id'] = get_val($data, 'cp_order_id', 0);
        $_data['status'] = get_val($data, 'status', '');
        $_data['cp_status'] = get_val($data, 'cp_status', 0);
        $_data['cp_payback_url'] = get_val($data, 'cp_payback_url', '');
        $_data['params'] = get_val($data, 'params', '');
        $_data['ext'] = get_val($data, 'ext', '');
        $_data['notify_cnt'] = get_val($data, 'notify_cnt', '');
        $_data['create_time'] = time();
        $this->checkTable();

        return parent::insertLog($_data, $replace, $get_last_insert_id);
    }

    /**
     * 计算在哪张表
     *
     * @return \Think\Model
     */
    public function computeTable() {
        $_date = date('Ym');
        $_table = $this->table_prefix.$_date;

        return $this->table($_table);
    }

    function checkTable() {
        $_date = date('Ym');
        $this->table = $this->table_prefix.$_date;
        $_sql = "CREATE TABLE IF NOT EXISTS `$this->table` (";
        $_sql .= "    `id` bigint(20) unsigned NOT NULL  AUTO_INCREMENT COMMENT '自增ID',";
        $_sql .= "    `pay_id` int(11) unsigned NOT NULL COMMENT '对应pay表中的id',";
        $_sql .= "    `order_id` varchar(64) NOT NULL DEFAULT '' COMMENT '订单号',";
        $_sql .= "    `cp_order_id` varchar(64) NOT NULL DEFAULT '' COMMENT 'CP订单号',  ";
        $_sql .= "    `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '充值成功标志，1为待处理，2为成功，3为失败',";
        $_sql .= "    `cp_status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '充值回调标志，1为待处理，2为成功，3为失败',";
        $_sql .= "    `cp_payback_url` varchar(255) NOT NULL DEFAULT '' COMMENT 'CP回调地址',";
        $_sql .= "    `params` varchar(1023) NOT NULL DEFAULT '' COMMENT 'CP回调参数',  ";
        $_sql .= "    `ext` varchar(255) NOT NULL DEFAULT '' COMMENT 'CP附加参数',";
        $_sql .= "    `notify_cnt` int(11) NOT NULL DEFAULT '0' COMMENT '通知次数',";
        $_sql .= "    `create_time` bigint(20) NOT NULL DEFAULT '0' COMMENT '充值时间',";
        $_sql .= "    PRIMARY KEY (`id`),";
        $_sql .= "    KEY `lpc_order_unique` (`order_id`)";
        $_sql .= "  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知CP记录表';";

        return $this->execute($_sql);
    }
}