folderSql.php
1.2 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
<?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, $field = '`id`,`folder`,`pid`,`origin_folder`,`last_sync_time`'):string {
return "select {$field} 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):string {
return "select `id` from `".self::$table."` where ".dbWhere($where);
}
/**
* 查询一条完整的数据
* @param array|string $where
* @return string
* @author：dc
* @time 2023/3/14 11:49
*/
public static function first(array|string $where):string {
$where = is_numeric($where) ? ['id'=>$where] : $where;
return "select * from `".self::$table."` where ".dbWhere($where);
}
}