Model\Invite::getInviteArray PHP Метод

getInviteArray() публичный статический Метод

invite状态 (0-未使用, 1-已用, -1过期)
public static getInviteArray ( $status )
    public static function getInviteArray($status = -1)
    {
        $sql = "SELECT * FROM invite";
        if ($status == 0) {
            $sql .= " WHERE status = 0";
        } else {
            if ($status == -1) {
                $sql .= " WHERE status = 0 AND uid=-1";
            } else {
                if ($status == 1) {
                    $sql .= " WHERE status = 1 OR status = -1 ";
                }
            }
        }
        $statement = DB::getInstance()->prepare($sql);
        $statement->execute();
        return $statement->fetchAll(DB::FETCH_CLASS, __CLASS__);
    }

Usage Example

Пример #1
0
 public function index()
 {
     $inviteList = InviteModel::getInviteArray(-1);
     Template::setView('panel/home_invite');
     Template::putContext('inviteList', $inviteList);
 }
All Usage Examples Of Model\Invite::getInviteArray