report/app/common/api/IntegralItemApi.php

<?php

namespace app\common\api;

use app\common\model\IntegralItem;

class IntegralItemApi {

    public static function getOne($id) {
        return IntegralItem::findOrEmpty($id);
    }

    public static function getList($params) {
        $order = $params["order"] ?: "desc";
        $offset = $params["offset"] ?: 0;
        $limit = $params["limit"] ?: 10;
        $where[] = ["delete", "=", 0];
        if ($params["type"]) {
            $where[] = ["type", "=", $params["type"]];
        }
        if ($params["name"]) {
            $where[] = ["name", "like", "%{$params["name"]}%"];
        }
        if ($params["projectType"]) {
            $where[] = ["projectType", "=", $params["projectType"]];
        }
        if ($params["active"]) {
            $where[] = ["active", "=", $params["active"]];
        }
        $count = IntegralItem::where($where)->count();
        $list = IntegralItem::where($where)->limit($offset, $limit)->order("updateTime desc,createTime desc")->select()->toArray();
        return ["total" => $count, "rows" => $list];
    }

    public static function getAll() {
        $where[] = ["delete", "=", 0];
        $list = IntegralItem::where($where)->order("updateTime desc,createTime desc")->select()->toArray();
        return $list;
    }

    public static function edit($params) {
        $data["type"] = $params["type"];
        $data["name"] = $params["name"];
        $data["projectType"] = $params["projectType"];
        $data["active"] = $params["active"];
        if ($params["id"]) {
            $data["id"] = $params["id"];
            $data["updateTime"] = date("Y-m-d H:i:s");
            $data["updateUser"] = session("user")["uid"];
            return IntegralItem::update($data);
        } else {
            $data["createTime"] = date("Y-m-d H:i:s");
            $data["createUser"] = session("user")["uid"];
            return IntegralItem::insert($data);
        }
    }

    public static function delete($id) {
        $data["id"] = $id;
        $data["delete"] = 1;
        $data["updateUser"] = session("user")["uid"];
        $data["updateTime"] = date("Y-m-d H:i:s");
        //同时删除子项
        $upd["delete"] = 1;
        $upd["updateTime"] = date("Y-m-d H:i:s");
        $upd["updateTime"] = session("user")["uid"];
        $where[] = ["projectId", "=", $id];
        \app\common\model\IntegralItem::where($where)->save($upd);
        return IntegralItem::update($data);
    }

    public static function chkExist($name, $type, $projectType, $id = 0) {
        $where = [];
        $where[] = ["type", "=", $params["type"]];
        $where[] = ["projectType", "=", $params["projectType"]];
        $where[] = ["name", "=", $params["name"]];
        $where[] = ["delete", "=", 0];
        if ($id) {
            $where[] = ["id", "<>", $id];
        }
        return IntegralItem::where($where)->find();
    }

}