<?php

namespace Model;

/**
 * 文件夹
 * @author：dc
 * @time 2023/2/17 18:04
 * Class folderSql
 * @package Model
 */
class folderSql {

    public static $table = 'folders';

    /**
     * 所有文件夹
     * @param int $email_id
     * @return string
     * @author：dc
     * @time 2023/2/18 9:22
     */
    public static function all(int $email_id):string {
        return "select `folder`,`pid`,`origin_folder`,`last_sync_time`,`folder` from `".static::$table."` where `email_id` = {$email_id} order by `id` asc";
    }


    /**
     * 是否存在，存在则返回 id
     * @param $where
     * @return string
     * @author：dc
     * @time 2023/2/18 11:48
     */
    public static function has($where){
        return "select `id` from `".self::$table."` where ".dbWhere($where);
    }




}