select
distinct
po.pid,
po.version,
po.projectname,
pb.endtime
from
( select
max(version) as version,
pid as pid,
projectname as projectname
from
project_oraginl po
group by po.pid) po
left join
(select
pb.pid as pid,
max(end_time) as endtime
from project_build pb
group by pid
) pb
on
pb.pid = po.pid;
搜索关键字
ExtJs的TreePanel的分页的思路和实现
ExtJS入门之事件(fireEvent)
Extjs中的类和继承
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title> New Document </title>
<meta name="Generator" content="EditPlus">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
</head>
<body>
选择法庭:
<select id="name">
</select>
</body>
<script>
var sortNames ="南山;宝安;福田";
var arr = new Array();
arr = sortNames.split(";");
var objectSelect = document.getElementById("name");
for(var i = 0; i < arr.length; i++) {
if(arr[i] != 0) {
var objectOption=document.createElement("option");
objectSelect.options.add(objectOption);
objectOption.innerText=arr[i];
objectOption.value=arr[i];
}
}
</script>
</html>
distinct
po.pid,
po.version,
po.projectname,
pb.endtime
from
( select
max(version) as version,
pid as pid,
projectname as projectname
from
project_oraginl po
group by po.pid) po
left join
(select
pb.pid as pid,
max(end_time) as endtime
from project_build pb
group by pid
) pb
on
pb.pid = po.pid;
搜索关键字
ExtJs的TreePanel的分页的思路和实现
ExtJS入门之事件(fireEvent)
Extjs中的类和继承
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title> New Document </title>
<meta name="Generator" content="EditPlus">
<meta name="Author" content="">
<meta name="Keywords" content="">
<meta name="Description" content="">
</head>
<body>
选择法庭:
<select id="name">
</select>
</body>
<script>
var sortNames ="南山;宝安;福田";
var arr = new Array();
arr = sortNames.split(";");
var objectSelect = document.getElementById("name");
for(var i = 0; i < arr.length; i++) {
if(arr[i] != 0) {
var objectOption=document.createElement("option");
objectSelect.options.add(objectOption);
objectOption.innerText=arr[i];
objectOption.value=arr[i];
}
}
</script>
</html>