MapPathModel.class.php
858 Bytes
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
<?php
/**
* Created by PhpStorm.
* User: zhonglei
* Date: 18/4/25
* Time: 17:57
*/
namespace Common\Model;
class MapPathModel extends AbstractModel
{
/**
* 构造方法
*/
public function __construct()
{
parent::__construct();
}
/**
* 根据地图ID获取路径数量
* @author liyifei
* @param int $map_ids 地图ID
* @return array
*/
public function getPathCountByMapIds($map_ids)
{
$map_ids = implode("','", $map_ids);
$sql = "SELECT map_id, count(DISTINCT path_id) total FROM __TABLE__
WHERE `map_id` in ('{$map_ids}') AND `domain` = ? AND `status` < ?
GROUP BY map_id";
$params = [
QY_DOMAIN,
$this->get_st_delete(),
];
return $this->_m->fetch_array($sql, $params);
}
}