-
Notifications
You must be signed in to change notification settings - Fork 4
/
class.db.Dashboard.php
79 lines (73 loc) · 1.9 KB
/
class.db.Dashboard.php
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
<?php
require_once "class.DBConn.php";
class DashboardDB extends DBConn{
/**
* 添加新board
*/
public function insertNewBoard($data){
$conn=parent::getConn();
$sql2="INSERT into dashboard (id,name) values(:id,:name) ";
try{
$st=$conn->prepare($sql2);
$st->bindValue(":id",$data["id"],PDO::PARAM_INT);
$st->bindValue(":name",$data["name"],PDO::PARAM_STR);
$st->execute();
}catch(PDOException $e){
echo "Insert new dashboard to db failure:".$e->getMessage();
return false;
}
return true;
}
public function selectMaxDshboardId(){
$conn=parent::getConn();
$id=0;
$sql1="SELECT MAX(id) as id from dashboard";
try{
$st=$conn->prepare($sql1);
$st->execute();
$r=$st->fetch();
if($r["id"])
return $r["id"];
else return 1;
}catch(PDOException $e){
echo "select max dashboard id failed:".$e->getMessage();
return false;
}
}
/**
* boardname
*/
public function selectDasbordName($id){
$conn=parent::getConn();
$sql="SELECT name from dashboard WHERE id=:id";
try{
$st=$conn->prepare($sql);
$st->bindValue(":id",$id,PDO::PARAM_INT);
$st->execute();
$row=$st->fetch();
}catch(PDOException $e){
echo "failure:".$e->getMessage();
return false;
}
return $row;
}
public function selectDashBoardChartId($id){
$conn=parent::getConn();
$sql="select id from chart where dashboard_id=:id ";
try{
$st=$conn->prepare($sql);
$st->bindValue(":id",$id,PDO::PARAM_INT);
$st->execute();
$row=$st->fetchAll();
return $row;
}catch(PDOException $e){
echo "failure:".$e->getMessage();
return false;
}
}
}
//$db=new DashboardDB();
//echo $db->insertNewBoard(array("name"=>"first","id"=>1));
//$tdb->updateDragableWidgdit(array("name"=>"任务:打死铁松","target"=>"用合理的方式发泄加班的情绪","checklist"=>"腿断;脑残"));
//$tdb->select();
?>