mas-meeting/application/admin/model/User.php

<?php
/**
 * 签到表模型
 */
namespace app\admin\model;

use daswork\Model;

class User extends Model
{
    public function __construct($tablename = '')
    {
        parent::__construct();
        // if ($tablename) {
        //     $this->tablename = $tablename;
        // } else {
        //     $this->tablename = uncamelize(basename(__CLASS__));
        // }
        $this->tablename = 'user';
    }

    public function dataList($where = '')
    {
        $sql = "select id,truename,phone,organization,member_type,fee_type,is_pay,money,receipt_number,status from $this->tablename $where;";
        // echo $sql;
        // exit;
        return $this->select($sql);
    }

    public function getOneByUsername($username, $tablename = '')
    {
        $sql = "SELECT * FROM `$this->tablename` WHERE `username`='$username';";
        $result = $this->query($sql);
        $data = $result->fetch_assoc();

        return $data;
    }

    /**
     * deleteByIds
     */
    public function deleteById($id)
    {
        if (is_array($id)) {
            $sql = "DELETE FROM `$this->tablename` WHERE `member_id` IN(";
            for ($i=0; $i < count($id); $i++) {
                $sql .= $id[$i] . ',';
            }
            $sql = rtrim($sql, ',');
            $sql .= ");";
        } else {
            $sql = "DELETE FROM `$this->tablename` WHERE `member_id`=$id;";
        }
        return $this->exec($sql);
    }
}