const koa = require(‘koa‘);
const Router = require(‘koa-router‘);
let koabody = require(‘koa-body‘);

const fs = require(‘fs‘)

const app = new koa();
const router = new Router();
const session = require(‘koa-session‘);
app.keys = [‘some secret hurr‘];

const path = require(‘path‘)  
const static = require(‘koa-static‘);

//app.use(session(CONFIG, app));

const port = process.env.PORT || 5001;

router.get("/",async ctx => {
    ctx.body = {msg:‘Hello koa Interfaces‘}
})

let Article = require(‘./model/Article‘);
let Comment = require(‘./model/Comment‘);
let User = require(‘./model/User‘);

router.get("/article/list",async ctx => {

    const articles = await Article.findAll();
    let rows = []

    for(let i=0;i<articles.length;i++){
        let row = articles[i].dataValues
        console.log(row)
        /*
        let img = fs.readFileSync(row.id+‘.base64‘,‘utf-8‘)
        row.img = img
        */
        rows.push(row)
    }

    console.log(rows)
    ctx.body = rows
})

const mysqlApi = require(‘./model/mysqlApi‘)
const query = mysqlApi.query

router.post(‘/comment‘, async (ctx, next) => {
    let row =  ctx.request.body;
    console.log(row)
    let {articleid,content} = row

    let sqlStr = `select  * from comment where article_id = ${articleid} order by id asc LIMIT 1`
    console.log(sqlStr)
    let ret =   await query( sqlStr )

    console.log(ret)
    console.log(ret.length)
    let art ={}

    let comment_no = 1
    if(ret.length > 0){
        comment_no = ret[0].comment_no+1
    }
        let tt = {
            article_id:articleid,
            content:content,
            comment_no:comment_no
        }
        art = await Comment.create(tt)
    
    ctx.body = art
})

router.get("/comment",async ctx => {
    let request = ctx.request;
    let req_query = request.query;
    const id = req_query.id;
    let sqlStr = `select  * from comment where article_id = ${id} order by id asc `
    console.log(sqlStr)
    let ret =   await query( sqlStr )

 
    ctx.body = ret
})

router.get("/article",async ctx => {
    let request = ctx.request;
    let req_query = request.query;
    const id = req_query.id;
    const articles = await Article.findAll({where:{id:id}});
    for(let i=0;i<articles.length;i++){
        let row = articles[i].dataValues
        console.log(row)
        //let img = fs.readFileSync(row.id+‘.base64‘,‘utf-8‘)
        //row.img = img
        //rows.push(row)
    }
    console.log(ctx.session.username)
    console.log(id)
    console.log(articles)
    ctx.body = articles
})

let images = require("images");

router.post(‘/add‘, async (ctx, next) => {
    let row =  ctx.request.body;
    
    console.log(row.title)
    //console.log(row.img)

    let tt = {
            title:row.title,
            content:row.content,
            newsid:row.newsid
        }
    console.log(tt)
    let art = await Article.create(tt)
    let id = art.dataValues.id
    let fileType = row.filetype;
    //console.log(art.dataValues.id)
    //fs.writeFileSync(art.dataValues.id+‘.base64‘,row.img);

    var base64Data = row.img.replace(/^data:image\/\w+;base64,/, "");
    let img = new Buffer(base64Data, ‘base64‘);
    fs.writeFileSync(`${id}.${fileType}`,img);

    images("11.png")        
    //加载图像文件
    .size(180)        
    .save(`${id}_small.jpg`, {       
    quality : 50          //保存图片到文件,图片质量为50
    });

    //if(row.name == ‘admin‘ && row.password == ‘admin‘)
    ctx.response.body = {code:0};
    //ctx.response.body = ‘hah‘;
});

app.use(async (ctx, next) => {
    console.log(`Process ${ctx.request.method} ${ctx.request.url}...1`);
    console.log( ctx.session)

    if(ctx.request.method==‘post‘)
        if( undefined ==  ctx.session.sesStr ){
            ctx.response.body = {code:-1,sessionConnect:-1};
            return;
        }

    await next();
});


router.post(‘/login‘, async (ctx, next) => {
    let row =  ctx.request.body;
    console.log( ctx.request)
    console.log( row)
    console.log(row.name)
    let name = row.name
    //if(row.name == ‘admin‘ && row.password == ‘admin‘)
    const user = await User.findAll({where:{name:name}});

    if(user.length > 0)  
    {
        console.log(user)
        if(user[0].passwd == row.password){
            ctx.session.username = name;
            ctx.session.id = user.id;
            ctx.response.body = {code:0};
        }
           
        else
            ctx.response.body = {code:-1};
    }else{
        ctx.response.body = {code:-1};
    }
    
    //ctx.response.body = ‘hah‘;
});

router.get("/test",async ctx => {

    ctx.body ="1"
})

// 配置静态web服务的中间件
//app.use(static(path.join(__dirname,‘./images‘)));


app.use(static(__dirname+‘/images‘));

app.use(koabody({
    multipart: true,
    formidable: {
        maxFileSize: 200*1024*1024    // 设置上传文件大小最大限制，默认2M
    },
    formLimit:20*1024*1024,
}));

app.keys = [‘some secret hurr‘];
const CONFIG = {
    key: ‘koa:sess‘,   //cookie key (default is koa:sess)
    maxAge: 3600000,  // cookie的过期时间 maxAge in ms (default is 1 days)
    overwrite: true,  //是否可以overwrite    (默认default true)
    httpOnly: true, //cookie是否只有服务器端可以访问 httpOnly or not (default true)
    signed: true,   //签名默认true
    rolling: false,  //在每次请求时强行设置cookie，这将重置cookie过期时间（默认：false）
    renew: false,  //(boolean) renew session when session is nearly expired,
};

app.use(session(CONFIG, app));

//app.use(static(__dirname+‘/images‘));
app.use(router.routes()).use(router.allowedMethods);

app.listen(port,() =>{
    console.log(`server started on ${port}!`)
})

let Sequelize = require(‘sequelize‘);
let mySequelize = require(‘./configdb‘);

var Article = mySequelize.define(‘article‘, {
    id:{ //自增长id,主键,整形
        type:Sequelize.INTEGER,
        primaryKey: true,
        autoIncrement:true
    },
    title: { //名字
        type: Sequelize.STRING(100)
    },
    content: { //名字
        type: Sequelize.STRING(500)
    },
    image_url: { //名字
        type: Sequelize.STRING(100)
    },
    source: { //名字
        type: Sequelize.STRING(50)
    },
    newsid: { //类型 在tab区别
        type:  Sequelize.STRING(50)
    },
    comment_count: { //类型 在tab区别
        type: Sequelize.INTEGER
    },

},{
    timestamps: true,
    freezeTableName: true,
});
Article.sync(); //创建表

module.exports = Article

<template>

<div >
<van-nav-bar
  title="登陆"
  left-text="返回"

  left-arrow
  @click-left="onClickLeft"
  @click-right="onClickRight"
/>

    <van-cell-group class="user-group" style="margin-top:50px;margin-bottom:10px">
      <van-cell title="没有注册?先去注册" style="color: rgba(69, 90, 100, 0.6);" @click="onClickRegister" is-link />
    </van-cell-group>

<van-cell-group>
  <van-field
    v-model="username"
    required
    clearable
    label="用户名"
    right-icon="question-o"
    placeholder="请输入用户名"
    @click-right-icon="$toast(‘question‘)"
  />

  <van-field
    v-model="password"
    type="password"
    label="密码"
    placeholder="请输入密码"
    required
  />
<van-cell >
  <van-button @click="onClick" type="primary" style="margin-top:30px;width:100%;" size="normal">登录</van-button>
</van-cell>

</van-cell-group>

</div>   
</template>

<script>

import { api } from ‘../../common/api‘

export default {
  data() {
    return {
      username:‘‘,
      password:‘‘,
      ifWrite:false,
    };
  },
  mounted: function() {
  },

  methods: {
      async onClick(){
        //alert(this.username)
        const row = {name:this.username,password:this.password}
        let ret = await api.post(‘api/login?time=‘+new Date().getTime(),row,this)
        if(ret.code == 0){
          this.$store.state.logined = true;
          this.$store.state.user = this.username
         // this.$router.push({path: ‘/list‘});
        }
      },
      onClickLeft(){
        this.$router.go(-1)
      },
      onClickRegister(){
        this.$router.push({path: ‘register‘});
      }
  }
};
</script>

<template>
  <div>
<van-nav-bar
  title="用户"
  left-text="返回"

  left-arrow
  @click-left="onClickLeft"
  @click-right="onClickRight"
/>

    <van-cell-group class="user-group" style=" margin-top:10%;padding:15px;padding-left:20px;">
        
       <div style="display:flex;font-size: 12px;">
         <div style="border：1px solid">
          <svg class="icon" style="width: 2em; height: 2em;vertical-align: middle;fill: currentColor;overflow: hidden;" viewBox="0 0 1024 1024" version="1.1" xmlns="http://www.w3.org/2000/svg" p-id="564"><path d="M982.862052 804.664259c-25.592502-60.582251-62.281753-114.966318-109.068046-161.752612S772.623645 559.536073 712.041394 533.843601c-23.693059-9.997071-47.885971-18.094699-72.478766-24.392854 28.891536-12.996193 55.383774-31.290833 78.477009-54.284097 50.085327-50.085327 77.577272-116.56585 77.577272-187.445084s-27.591916-137.359758-77.577272-187.445085C667.95431 30.291126 601.373816 2.699209 530.594552 2.699209S393.234794 30.291126 343.249439 80.376452 265.572196 196.942302 265.572196 267.721566s27.591916 137.359758 77.577272 187.445084c20.194084 20.194084 42.987406 36.689251 67.680172 49.185591-32.490481 6.698038-64.181197 16.495167-94.972176 29.59133-60.582251 25.592502-114.966318 62.281753-161.752612 109.068047S70.729279 744.082007 45.136776 804.664259C18.644538 867.445865 5.148492 934.026359 5.148492 1002.706238l0.09997 21.293762H1022.850337l0.099971-21.293762c-0.099971-68.679879-13.596017-135.260373-40.088256-198.041979zM305.56048 267.721566c0-124.063653 100.970419-225.034072 225.034072-225.034072s225.034072 100.970419 225.034072 225.034072-100.970419 225.034072-225.034072 225.034072-225.034072-100.970419-225.034072-225.034072zM45.536659 984.111686C55.333789 734.184907 261.673338 533.843601 513.999414 533.843601c252.326076 0 458.665625 200.241336 468.462755 450.168114H45.536659z" fill="#727171" p-id="565"></path></svg>
         </div> 
        <span style="padding-left:20px;padding-top:7px"> admin </span>
       </div>
      
    </van-cell-group>

    <van-cell-group>
      <van-cell  title="我发表的" value="10篇文章"  is-link />
       <van-cell  title="我的手机号" value="15862365445" is-link />
    </van-cell-group>
<van-cell >
  <van-button @click="onClick" type="warning" style="margin-top:20px;width:100%;" size="normal">注销</van-button>
</van-cell>
    <div style="    position:fixed;bottom:0;width:100%;">
    <van-row class="user-links" >
      <van-col span="8">
        首页
      </van-col>
      <van-col span="8">
        发文
      </van-col>
      <van-col span="8">
        未登陆
      </van-col>
    </van-row>
    </div>
  </div>
</template>

<script>
import { Row, Col, Icon, Cell, CellGroup } from ‘vant‘;

export default {
  components: {
    [Row.name]: Row,
    [Col.name]: Col,
    [Icon.name]: Icon,
    [Cell.name]: Cell,
    [CellGroup.name]: CellGroup
  },
    methods: {
      onClickLeft(){
        this.$router.go(-1)
      },
      async onClick(){
        this.$store.state.logined = false;
        this.$store.state.user = null
        this.$router.push({path: ‘/login‘});
      },
  }
};
</script>

<template>

<div >
<van-nav-bar
  title="写文章"
  left-text="返回"
  right-text="按钮"
  left-arrow
  @click-right="onClickRight"
  @click-left="onClickLeft"
/>

<van-cell-group>
      <van-field
        readonly
        clickable
   
         v-model=classValue
        placeholder="选择类别"
        @click="onClickField"
      />
      <van-popup v-model="showPicker" position="bottom">
        <van-picker
          show-toolbar
          :columns=columns
           @cancel="onCancel2"
          @confirm="onConfirm2"
        />
      </van-popup>
</van-cell-group>
<van-cell-group>
  <van-field
     v-model=titleValue
    placeholder="请输入标题"
 
    bind:change="onChange"
  />
</van-cell-group>

<van-cell-group>
  <van-cell-group>
    <div style="border:1px solid #ededed;">
      <van-field style="height:250px"
        v-model=contentValue
        type="textarea"
        placeholder="请输入内容"
        autosize
      />
      <van-uploader style="margin-top:5px;margin-left:5px"
        v-model="fileList"
        multiple
        :max-count="1"
        :after-read="afterRead"
      />
    </div>
  </van-cell-group>
</van-cell-group>


    <div style="position:fixed;bottom:0;width:100%;">
      <van-cell-group>
      </van-cell-group>
      <van-row class="user-links" >
        <van-col span="8">
          首页
        </van-col>
        <van-col span="8">
          发文
        </van-col>
        <van-col span="8">
          未登陆
        </van-col>
      </van-row>
    </div>
</div>   
</template>

<script>
  import { api } from ‘../../common/api‘
    export default {

        data() {
            return {
        columns: [‘杭州‘, ‘宁波‘, ‘温州‘, ‘嘉兴‘, ‘湖州‘],
        showPicker: false,
        classValue: ‘‘,
        titleValue:‘‘,
        contentValue:‘‘,
        img:‘‘,
        fileType:‘‘,
        fileList: []
      }
    },
    methods: {
      oversize(){
        alert(‘too big‘)
      },
      async onClickRight(){
        debugger;
        console.log(this.classValue,this.titleValue,this.contentValue)

        const row = {newsid:this.classValue,
                    title:this.titleValue,
                    content:this.contentValue,
                    img:this.img,
                    filetype:this.fileType}
        let ret = await api.post(‘api/add?time=‘+new Date().getTime(),row,this)
        if(ret.code == 0){
          alert(‘上传成功‘)
        }

      },

      onClickField() {
        this.showPicker = true;
      },
      onConfirm2(value) {
        this.showPicker = false;
        this.classValue = value;
      },

      onCancel2() {
        this.showPicker = false;
      },
     afterRead(file) {
      // 此时可以自行将文件上传至服务器
      console.log(file)

      let arr = file.file.name.split(‘.‘);
      let fileType = arr[arr.length-1]
      console.log(fileType);
      //console.log(file.content);
      this.img = file.content
      this.fileType = fileType
    },
     onClickLeft(){
        this.$router.go(-1)
      }


    }
}
</script>