game-sdk/simplewind/huo/model/member/MemProblemModel.php

<?php
/**
 * MemProblemModel.php UTF-8
 * 用户问题反馈
 *
 * @date    : 2018/2/1 11:29
 *
 * @license 这不是一个自由软件，未经授权不许任何使用和传播。
 * @author  : linjiebin <ljb@huosdk.com>
 * @version : HUOSDK 8.0
 */

namespace huo\model\member;

use huo\model\common\CommonModel;
use huo\model\game\GameModel;

class MemProblemModel extends CommonModel {
    protected $name = 'mem_problem';

    public function getProblem($where, $page) {
        $_map = [];
        if (isset($where['username']) && !empty($where['username'])) {
            $_username = $where['username'];
            $_mid = (new MemberModel())->where(['username' => ['like', "%$_username%"]])->value('id');
            if (!empty($_mid)) {
                $_map['mem_id'] = $_mid;
            }
        }
        $_list = $this->where($_map)->order('id desc')->paginate($page);
        $_status = [
            '1' => lang('not_repair'),
            '2' => lang('have_to_repair')
        ];
        foreach ($_list as $_k => $_v) {
            if ($_v['mem_id'] > 0) {
                $_list[$_k]['username'] = (new MemberModel())->where(['id' => $_v['mem_id']])->value('username');
            } else {
                $_list[$_k]['username'] = '--';
            }
            if (1 == $_v['flag']) {
                $_list[$_k]['type'] = lang('game problem');
            } else {
                $_list[$_k]['type'] = lang('not game problem');
            }
            if ($_v['app_id'] > 0) {
                $_list[$_k]['type'] .= '--'.(new GameModel())->where(['id' => $_v['app_id']])->value('name');
            } else {
                $_list[$_k]['type'] .= '';
            }
            $_list[$_k]['status_txt'] = $_status[$_v['status']];
        }

        return $_list;
    }

    public function editStatus($ids, $status) {
        if (empty($ids) || !in_array($status, [1, 2])) {
            return false;
        }
        $_map['id'] = ['in', $ids];
        $this->where($_map)->setField('status', $status);

        return true;
    }

    public function addFeedback($data) {
        $_data['mem_id'] = get_val($data, 'mem_id', 0);
        $_data['app_id'] = get_val($data, 'app_id', 0);
        $_data['flag'] = get_val($data, 'flag', 2);
        $_data['title'] = get_val($data, 'title', '');
        $_data['details'] = get_val($data, 'details', '');
        $_data['contact'] = get_val($data, 'contact', '');
        $_data['image'] = get_val($data, 'image', '');
        $_data['status'] = get_val($data, 'status', 1);
        if ($_obj = self::create($_data, true)) {
            return $_obj->id;
        } else {
            return false;
        }
    }
}