CUCU2/src/custom/restcontroller/system/datacollect/datacollect.java

package restcontroller.system.datacollect;

import com.alibaba.fastjson.JSONObject;
import common.Controller;
import common.YosException;
import common.annotation.API;
import common.data.*;
import restcontroller.R;

public class datacollect extends Controller {
    /**
     * 构造函数
     *
     * @param content
     */
    public datacollect(JSONObject content) throws YosException {
        super(content);
    }


    @API(title = "数据收藏", apiversion = R.ID20240416133702.v1.class)
    public String isCollect() throws YosException {
        String ownertable = content.getStringValue("ownertable");
        Long ownerid = content.getLongValue("ownerid");

        QuerySQL querySQL = SQLFactory.createQuerySQL(this, "sys_datacollect");
        querySQL.setSiteid(siteid);
        querySQL.setWhere("userid", userid);
        querySQL.setWhere("ownertable", ownertable);
        querySQL.setWhere("ownerid", ownerid);
        Rows rows = querySQL.query();
        if (rows.isNotEmpty()) {
            DeleteSQL deleteSQL = SQLFactory.createDeleteSQL(this, "sys_datacollect");
            deleteSQL.setSiteid(siteid);
            deleteSQL.setUniqueid(rows.get(0).getLong("sys_datacollectid"));
            deleteSQL.delete();
        } else {
            InsertSQL insertSQL = SQLFactory.createInsertSQL(this, "sys_datacollect");
            insertSQL.setUniqueid(createTableID("sys_datacollect"));
            insertSQL.setSiteid(siteid);
            insertSQL.setValue("userid", userid);
            insertSQL.setValue("ownertable", ownertable);
            insertSQL.setValue("ownerid", ownerid);
            insertSQL.insert();
        }

        return getSucReturnObject().toString();
    }

}