반응형
<!DOCTYPE html>
<html>
<head>
<title><%= title %></title>
<link rel='stylesheet' href='/stylesheets/style.css' />
<% include ./partials/head %>
</head>
<body>
<% include ./partials/nav %>
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h3 class="mt-lg-5">제휴사 컬럼 정보</h3>
<form>
<div class="form-row">
<div class="form-group col-md-4">
<label for="select_partner">제휴사</label>
<select id="select_partner" class="form-control">
<option value="-1"></option>
<%
for(var i=0; i<partner_list.length; i++) {
%><option value="<%= partner_list[i].id %>"> <%= partner_list[i].name %> </option>
<% }
%>
</select>
</div>
<div class="form-group col-md-4">
<label for="inputPassword4">중복검사 키</label>
<input type="password" class="form-control" id="dup_key_col" >
</div>
<div class="form-group col-md-4">
<label for="inputPassword4">기본 키</label>
<input type="password" class="form-control" id="default_key_col" >
</div>
</div>
<div class="form-row">
<div class="form-group col-md-6">
<label for="inputPassword4">추가 키</label>
<input type="password" class="form-control" id="addintion_key_col" >
</div>
<div class="form-group col-md-6">
<label for="inputPassword4">추가 키 이름</label>
<input type="password" class="form-control" id="addition_info_name" >
</div>
</div>
<input type="submit" class="btn btn-primary" value="ADD"/>
</form>
<div>
<table id="example" class="display" width="100%">
<thead>
<tr>
<th><input type="checkbox" id="chk_all"/></th>
<th>No.</th>
<th>제휴사</th>
<th>중복검사 키</th>
<!--
<th>기본 키</th>
<th>추가 키</th>
<th>추가 키 이름</th>
-->
</tr>
</thead>
</table>
</div>
</div>
</div>
</div>
</div>
</body>
<script>
var table;
$(document).ready(function() {
table = $('#example').DataTable( {
"data": <%- JSON.stringify(partner_col_list) %>,
"columns": [
{ data: "id" },
{ data: "partnerId" },
{ data: "duplication_col" },
],
});
});
</script>
</html>
var express = require('express');
var router = express.Router();
module.exports = app => {
var router = express.Router();
app.use('/partner_col_info', router);a
/* GET users listing. */
router.get('/', function (req, res, next) {
app.db.models.partner.findAll({
}).then((result) => {
app.db.models.partner_col_info.findAll({}).then(result1 => {
res.render('partner_col_info', {title: 'Order', partner_list: result, partner_col_list: result1});
});
});
});
}
module.exports = (sequelize, DataTypes) => {
const PartnerColInfo = sequelize.define('partner_col_info', {
id: {
type: DataTypes.INTEGER,
primaryKey: true,
},
duplication_col: {
type: DataTypes.STRING,
},
default_col: {
type: DataTypes.STRING,
},
information_col: {
type: DataTypes.STRING,
},
information_col_name: {
type: DataTypes.STRING,
},
createdAt: DataTypes.DATE,
updatedAt: DataTypes.DATE,
});
PartnerColInfo.associate = function (models) {
PartnerColInfo.belongsTo(models.partner, {as: 'partner', foreignKey: {allowNull: false}});
//PartnerOrder.hasMany(models.order, {as: 'order'});
//PartnerOrder.belongsTo(models.order, {foreignKey: 'order_number' , targetKey: 'order_id'});
}
return PartnerColInfo;
}
반응형
'엉터리 개발 이야기 > 개인프로젝트' 카테고리의 다른 글
| order.ejs 화면 정리 (0) | 2018.12.06 |
|---|---|
| Datatables row height, column width, column data ellipsis (0) | 2018.12.06 |
| [datatables] column background color (0) | 2018.12.05 |
| Datatables excel export 예제(cell style 설정) (0) | 2018.12.05 |
| Sequelize Association (0) | 2018.12.03 |