suryee-stat/application/index/controller/Company.php

<?php
namespace app\index\controller;

use daswork\Controller;
use daswork\lib\Config;
use app\index\model\MonthPicker;
use app\index\model\Commission;
use app\index\model\Company as CompanyModel;

class Company extends Controller
{
    private $model;
    protected $params;

    public function __construct()
    {
        parent::__construct();
        $this->model = new CompanyModel();
        $this->params = escapeString($_POST);
    }

    public function index()
    {
        $name = isset($_GET['company_name']) ? $_GET['company_name'] : '';
        $data = $this->model->listByName($name, "name");
        $this->assign("data", $data);
        $this->assign("company_name", $name);
        $this->fetch();
    }

    public function save()
    {
        $id = $this->params['id'];
        $name = $this->params['name'];
        $initial_balance = $this->params['initial_balance'];
        if ($id) {
            $res = $this->model->exec("UPDATE `company` SET `name`='$name', `initial_balance`='$initial_balance' WHERE `id`=$id;");
            // var_dump($res);
        } else {
            $res = $this->model->exec("INSERT INTO `company`(`name`,`initial_balance`) VALUES('" . $name . "','" . $initial_balance . "');");
        }
        if ($res===false) {
            echo json_encode(['code' => 1, "msg"=>$this->model->lastErrorMsg()]);
        } else {
            echo json_encode(['code' => 0, "msg"=>"操作成功"]);
        }
    }

    public function delete()
    {
        $res = $this->model->exec("DELETE FROM `company` WHERE `id`=$this->params['id'];");
        if ($res===false) {
            echo json_encode(['code' => 1, "msg"=>$this->model->lastErrorMsg()]);
        } else {
            echo json_encode(['code' => 0, "msg"=>"操作成功"]);
        }
    }
}