messageApplet/serviceApi/application/index/controller/Article.php

<?php
/**
 * Created by PhpStorm.
 * User: Titan 名字就是密码
 * Date: 2019/12/11
 * Time: 12:09
 */

namespace app\index\controller;


use think\Controller;
use think\Db;
use think\Request;

class Article extends Controller
{
   
    public function uploadImg()
    {
        $filePath = $this->upload();
        $sql = "update article set imageTitle='{$filePath}' order by `no` desc limit 1";
        $result = Db::query($sql);
        if($result){
            return json(['result'=>1,'msg'=>"插入成功"]);
        }else{
            return json(['result'=>0,"msg"=>'插入失败']);
        }
    }

    public function upload()
    {
        $path = "static/wechat/upload";
        $files = $_FILES["file"]["name"];
        $suffix = substr($files,strrpos($files,'.'));
        $name = time().rand(1,1000).$suffix;
        move_uploaded_file($_FILES["file"]["tmp_name"],"$path/$name");
        $filePath = $_SERVER["REQUEST_SCHEME"].":"."//".$_SERVER['SERVER_NAME']."/".$path."/".$name;
        return $filePath;
    }
    public function message(Request $request)
    {
        $title = $request->param("title");
        $describ = $request->param("describe");
        $id = $request->param("id");
        $isheck = $request->param("ischeck");
        $date = date("Y-m-d",time());
        if($isheck == 0){
            $data = ['title'=>$title,"describ"=>$describ,'g_id'=>$id,"date"=>$date];
            $result = Db::name("article")->insert($data);
            if($result > 0){
                return json(['result'=>1,'meg'=>"文章提交成功"]);
            }else{
                return json(['result'=>0,"文章提交失败"]);
            }
        }else{

        }
    }

    public function listdata(Request $request)
    {
        $id = $request->param("id");
        $type = $request->param("type");
        $no = $request->param("no");
        if($type == 2){

           $result = Db::name("article")->delete(['id'=>$no,'g_id'=>$no]);
            if($result){
                return json(['result'=>'1','msg'=>"删除成功"]);
            }else{
                return json(['result'=>0,'msg'=>"删除失败"]);
            }
        }else{
            $data = Db::name("article")->where(['g_id'=>$id])->select();
            return json(['result'=>1,'msg'=>"获取文章信息成功","content"=>$data]);
        }

    }
}