인생공략집

<div class="modal-header">
  <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <h4 class="modal-title">관리자 수정</h4>
</div>
<div class="modal-body">
  <form name="update_form" action="/mgmt/admin/update" method="post">
    {{ csrfField() }}
    <div class="form-group">
      <label>아이디</label>
      <input type="text" name="userid" class="form-control" readonly required pattern="[a-zA-Z0-9]+" value="{{ admin.userid }}"/>
      <input type="hidden" name="id" class="form-control" value="{{ admin.id }}" />
    </div>
    <div class="form-group">
      <label>별명 <small>(필수)</small></label>
      <input type="text" name="nick" class="form-control" required value="{{ admin.nick }}"/>
    </div>
    <div class="form-group" style="text-align: right">
      <input class="btn btn-primary" type="submit" value="관리자 수정" />
    </div>
  </form>
</div>

...
 
  // 관리자 수정 폼
  // /mgnt/admin/update_form/:id
  async update_form ({params, view}) {
    const admin = await Admin.find(params.id)
    return view.render('mgmt/admin/update_form', { admin: admin.toJSON() })
  }
 
...

  Route.get('/admin/update_form/:id', 'Mgmt/AdminController.update_form').as('mgmt_admin_update_form')

...
 
  static async update (id, nick) {
    let admin = await this.find(id)
    admin.nick = nick
    await admin.save()
  }
 
...

...
 
  // 관리자 수정
  // /mgmt/admin/update
  async update ({request, response}) {
    let id   = request.input('id')
    let nick = request.input('nick')
 
    await Admin.update(id, nick)
    return response.route('mgmt_admin')
  }
 
...

  Route.post('/admin/update', 'Mgmt/AdminController.update').as('mgmt_admin_update')

<div class="modal-header">
  <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <h4 class="modal-title">관리자 비밀번호 변경</h4>
</div>
<div class="modal-body">
  <form name="chg_passwd_form" action="/mgmt/admin/chg_passwd" method="post">
    {{ csrfField() }}
    <div class="form-group">
      <label>아이디</label>
      <input type="text" name="userid" class="form-control" readonly required value="{{ admin.userid }}"/>
      <input type="hidden" name="id" value="{{ admin.id }}" />
    </div>
    <div class="form-group">
      <label>비밀번호 <small>(필수)</small></label>
      <input type="password" name="passwd1" class="form-control" required />
    </div>
    <div class="form-group">
      <label>비밀번호 확인 <small>(필수)</small></label>
      <input type="password" name="passwd2" class="form-control" required />
    </div>
    <div class="form-group" style="text-align: right">
      <input class="btn btn-primary" type="submit" value="관리자 비밀번호 변경" />
    </div>
  </form>
</div>

...
 
  // 관리자 비밀번호변경 폼
  // /mgnt/admin/chg_passwd_form/:id
  async chg_passwd_form ({params, view}) {
    const admin = await Admin.find(params.id)
    return view.render('mgmt/admin/chg_passwd_form', { admin: admin.toJSON() })
  }
 
...

  Route.get('/admin/chg_passwd_form/:id', 'Mgmt/AdminController.chg_passwd_form').as('mgmt_admin_chg_passwd_form')

  static async change_password (id, passwd) {
    let admin = await this.find(id)
    admin.password = passwd
    await admin.save()
  }

  // 관리자 비밀번호변경
  // /mgmt/admin/chg_passwd
  async chg_passwd ({request, response}) {
    let id      = request.input('id')
    let passwd1 = request.input('passwd1')
    let passwd2 = request.input('passwd2')
 
    if (passwd1 != passwd2) {
      return response.route('mgmt_admin')
    }
    await Admin.change_password(id, passwd1)
    return response.route('mgmt_admin')
  }

  Route.post('/admin/chg_passwd', 'Mgmt/AdminController.chg_passwd').as('mgmt_admin_chg_passwd')

$ cd xyz/database
$ sqlite3 development.sqlite
sqlite> select * from admins;
1|testid1|passwd1|nick1
2|testid2|passwd2|nick2
3|testid3|passwd3|nick3
4|testid4|passwd4|nick4
5|testid5|passwd5|nick5
6|admin|newpassword|Admin
sqlite>

...
 
<div style="text-align: right; padding-bottom: 10px">
  <a href="/mgmt/admin/insert_form" class="btn btn-default" data-toggle="modal" data-target="#myModal">관리자 추가</a>
</div>
 
...
 
<div id="myModal" class="modal fade" role="dialog" tabindex="-1" aria-hidden="true">
  <div class="modal-dialog">
    <div class="modal-content">
    </div>
  </div>
</div>
 
...
 
<script>
// Modal Remote Reload
$(document).on('hidden.bs.modal', function (e) {
    $(e.target).removeData('bs.modal');
})
</script>
 
...

<div class="modal-header">
  <button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <h4 class="modal-title">관리자 추가</h4>
</div>
<div class="modal-body">
  <form name="insert_form" action="/mgmt/admin/insert" method="post">
    {{ csrfField() }}
    <div class="form-group">
      <label>아이디 <small>(필수)</small></label>
      <input type="text" name="userid" class="form-control" required>
    </div>
    <div class="form-group">
      <label>비밀번호 <small>(필수)</small></label>
      <input type="password" id="password" name="passwd1" class="form-control" required>
    </div>
    <div class="form-group">
      <label>비밀번호 확인 <small>(필수)</small></label>
      <input type="password" name="passwd2" class="form-control" required>
    </div>
    <div class="form-group">
      <label>별명 <small>(필수)</small></label>
      <input type="text" name="nick" class="form-control" required>
    </div>
    <div class="form-group" style="text-align: right">
      <input class="btn btn-primary" type="submit" value="관리자 추가" />
    </div>
  </form>
</div>

...
 
  // 관리자 추가 폼
  insert_form ({view}) {
    return view.render('mgmt.admin.insert_form')
  }
 
...

  Route.get('/admin/insert_form', 'Mgmt/AdminController.insert_form').as('mgmt_admin_insert_form')

...
 
  // created_at, updated_at 컬럼을 쓰지는 안는 경우에 설정
  // 이 예제에서는 created_at, updated_at 컬럼을 사용하지 않지만,
  // 실제 프로젝트에서 Admin 모델에는 사용하는 것이 더 나을것으로 보인다.
  static get createdAtColumn () { return null; }
  static get updatedAtColumn () { return null; }
 
  static async insert (userid, password, nick) {
    await this.create({
      userid: userid,
      password: password,
      nick: nick
    })
  }
 
...

...
 
  // 관리자 추가
  async insert ({request, response}) {
    let userid  = request.input('userid')
    let passwd1 = request.input('passwd1')
    let passwd2 = request.input('passwd2')
    let nick    = request.input('nick')
 
    if (passwd1 != passwd2) {
      return response.redirect('/mgmt/admin')
    }
    await Admin.insert(userid, passwd1, nick)
    // return response.redirect('/mgmt/admin')
    return response.route('mgmt_admin')
  }
 
...

  Route.post('/admin/insert', 'Mgmt/AdminController.insert').as('mgmt_admin_insert')

> cd xyz
xyz> adonis make:controller Mgmt\Admin

'use strict'
 
const Admin = use('App/Models/Admin')
 
class AdminController {
 
  // 관리자 목록
  async index ({view}) {
    const admins = await Admin.all()
    return view.render('mgmt.admin.index', { admins: admins.toJSON() })
  }
}
 
module.exports = AdminController

<html>
<head>
<meta charset="utf-8">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.3/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
<title>Adonis Tutorial</title>
</head>
<body>
@!section('content')
</body>
</html>

@layout('mgmt.base')
 
@section('content')
<div class="container">
  <div class="page-header">
    <h1>Administrator (관리자)</h1>
  </div>
 
  <table class="table table-striped table-hover table-condensed">
  <tr>
    <th style="text-align: center">아이디</th>
    <th style="text-align: center">별명</th>
    <th style="text-align: center">수정/삭제</th>
  </tr>
  @each(admin in admins)
  <tr>
    <td style="text-align: center">{{ admin.userid }}</td>
    <td style="text-align: center">{{ admin.nick }}</td>
    <td style="text-align: center">
      <a href="/mgmt/admin/chg_passwd_form/{{ admin.id }}" class="btn btn-default btn-xs" data-toggle="modal" data-target="#myModal">비밀번호변경</a>
      <a href="/mgmt/admin/update_form/{{ admin.id }}" class="btn btn-default btn-xs" data-toggle="modal" data-target="#myModal">수정</a>
      <button onclick="delete_admin('/mgmt/admin/delete/{{ admin.id }}')" class="btn btn-default btn-xs">삭제</button>
    </td>
  </tr>
  @endeach
  </table>
</div>
 
<script>
function delete_admin(url) {
    var result = confirm("관리자를 정말로 삭제하시겠습니까?");
    if( result == false ) return;
    location.href = url;
}
</script>
@endsection

Route.group('mgmt', function () {
  Route.get('/admin', 'Mgmt/AdminController.index').as('mgmt_admin')
}).prefix('/mgmt')