<?php

namespace Model;

use Lib\DbPool;

/**
 * body
 * @author：dc
 * @time 2023/3/23 10:13
 * Class bodySql
 * @package Model
 */
class bodySql {

    public static $table = 'bodies';


    /**
     *
     * @param int $id
     * @return string
     * @author：dc
     * @time 2023/3/23 10:15
     */
    public static function first(int $id):string {
        return "select * from `".static::$table."` where `lists_id` = ".$id." limit 1";
    }

    /**
     * has
     * @param int $id
     * @return string
     * @author：dc
     * @time 2023/3/23 10:15
     */
    public static function has(int $id){
        return "select count(*) from `".static::$table."` where `lists_id` = ".$id." limit 1";
    }


    /**
     * 插入或者更新
     * @param DbPool $db
     * @param $data
     * @return int
     * @author：dc
     * @time 2023/4/10 17:30
     */
    public static function insertOrUpdate($data){

        if(db()->count(self::has($data['lists_id']))){
            return db()->update(bodySql::$table,$data,dbWhere(['lists_id'    =>  $data['lists_id']]),false);
        }else{
            return db()->insert(bodySql::$table,$data,false);
        }

    }


}