- <%@ page language="java" contentType="text/html; charset=UTF-8"
- pageEncoding="UTF-8"%>
- <%@ page import="com.wap3.navigater.service.*" %>
- <%@ page import="com.wap3.navigater.dao.*" %>
- <%@ page import="com.wap3.navigater.pojo.*" %>
- <%@ page import="com.wap3.navigater.util.*" %>
- <%@ page import="java.util.*" %>
- <%@ page import="java.text.*" %>
- <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
- <script type="text/javascript" src="../js/jquery.js"></script>
- <script type="text/javascript" src="../js/ajax_edit.js"></script>
- <script type="text/javascript" src="../js/jquery.jclock.js"></script>
- <script type="text/javascript" src="../js/common.js"></script>
- <script type="text/javascript" src="../js/jquery.form.js"></script>
- <script type="text/javascript" src="../js/fileTypeJudge.js"></script>
- <script type="text/javascript" src="../js/jquery.datepick.js"></script>
- <script type="text/javascript" src="../js/jquery.datepick-zh-CN.js"></script>
- <!-- 拖拽需要导入的包 -->
- <script type="text/javascript" src="../js/jquery.ui.core.js"></script>
- <script type="text/javascript" src="../js/jquery.ui.widget.js"></script>
- <script type="text/javascript" src="../js/jquery.ui.mouse.js"></script>
- <script type="text/javascript" src="../js/jquery.ui.sortable.js"></script>
- <!-- 拖拽需要导入的包 -->
- <link media=all href="../css/common.css" type=text/css rel=stylesheet>
- <title>Insert title here</title>
- <style type="text/css">
- @import "inc/jquery.datepick.css";
- </style>
- <script type="text/javascript">
- var $imgthis;
- $(function(){
- var oldValue;
- $(".package_list .edit").bind("dblclick",function(){
- if($(this).has("input").length>0)return false;
- oldValue = $(this).text();
- $(this).ajax_edit("editaddress.jsp",oldValue);
- });
- $(".package_list .edit_img").bind("dblclick",function(){ //
- oldValue = $(this).find('img').attr("src") ;
- $imgthis = $(this);
- $(this).parents("tr.package_list").siblings(".package_list").find(":input.cancel").trigger("click");
- $(this).ajax_edit_img("editaddress.jsp",oldValue);
- });
- $(".package_list .edit :input[type!=file]:visible").live("blur",function(){
- $(this).ajax_handle("editaddress.jsp?action=edit",oldValue);
- });
- $(".afile").live("change",function(){
- $(this).fileTypeJudge("photo");
- })
- $("#editcategoryName").live("change",function(){
- $(this).ajax_handle("editaddress.jsp?action=edit",oldValue);
- });
- $("#del").click( function () {
- if($(":checkbox.urlid:checked").size()>0){
- var result = confirm("不可恢复的操作:确定要吗?"+ '\n' +"提示:如果删除大类会删除大类及下面的子类!!!");
- if (result) {
- var url = location.href;
- return ;
- $(".main_table").wrap("<form id='selectAddressForm' action='selectaddress.jsp?action=del' method='post'></form>");
- $("#selectAddressForm").submit();
- }
- }else{
- alert("请选择要删除的项目!");
- return false;
- }
- });
- $("#sortable").sortable({
- //cursorAt: 'top bottom', //只能上下移动,还有left,rigth参数
- cancel: "tr[class!=package_list],tr.package_list td:not(.edit_img)", //取消两个DOM 中间用逗号隔开
- update:function(event,ui){
- $this = $(ui.item);
- var thisid = $this.find(".urlid").val();
- var nextfilter = Number($this.next("tr.package_list").children("td.filter").text())+1;
- var $loading = $("loading……");
- $.ajax( {
- type : "POST",
- url : "editaddress.jsp?action=edit&target=filter",
- data : "filter="+nextfilter+"&urlid="+thisid,
- timeout : 50000,
- cache : false,
- beforeSend : function(XMLHttpRequest) {
- },
- success : function(data, textStatus) {
- data = data.replace(/^\s*|\s*$/, '');
- $this.children(".filter").text(data);
- },
- complete : function(XMLHttpRequest, textStatus) {
- },
- error : function() {
- $("#sortable").sortable('cancel');
- }
- });
- //alert($("#sortable tr").index($(ui.item)));
- }
- });
- $( "#sortable" ).disableSelection();
- });
- function callback(msg)
- {
- $imgthis.html("<img class='logo' src='"+msg+"' title='"+msg+"' />");
- }
- </script>
- </head>
- <body>
- <%
- String action = ParameterUtil.getStringParameter(request,"action","");
- FriendurlDao friendurlDao = new IbatisFriendurlDao();
- if("del".equals(action)){
- int[] urlids = ParameterUtil.getIntArrayParams(request,"urlid");
- for(int urlid : urlids){
- friendurlDao.deleteFriendurlByP(urlid);
- }
- }
- String navigaterPage = request.getRequestURL().toString();
- if(request.getQueryString()!= null){
- navigaterPage += "?"+request.getQueryString();
- }
- int pageSize = ParameterUtil.getIntParameter(request,"pageSize",10);
- int pageNo = ParameterUtil.getIntParameter(request,"pageNo",1);
- String orderBy = ParameterUtil.getStringParameter(request,"orderBy","filter");
- int ascOrDesc = ParameterUtil.getIntParameter(request,"ascOrDesc",2);
- Friendurl friendurl = new Friendurl();
- friendurl.addOrderBy(orderBy,ascOrDesc);
- List<Friendurl> friendurlList = friendurlDao.selectFriendurlByE(friendurl);
- //分页
- int totallpage = (int) Math.ceil(((double) friendurlList .size() * 1.0D)/ (double) pageSize);
- pageNo =pageNo <= 0 ? 1 : pageNo;
- pageNo =pageNo > totallpage ? totallpage : pageNo;
- DataPageUtil datePage = new DataPageUtil(friendurlList ,friendurlList .size(),pageSize, pageNo);
- boolean hasPrerPage = datePage.hasPrevPage();
- boolean hasNextPage= datePage.hasNextPage();
- int curpageNo = datePage.getPageNo();
- int pageCount = datePage.getPageCount();
- friendurlList = DataPageUtil.subList(friendurlList, pageSize, pageNo);
- if(friendurlList == null && friendurlList.size()<=0) {
- out.println("没有您需要的数据");
- }else{
- %>
- <%@include file="inc/header.jsp" %>
- <div id = "mainbox">
- <div class = "c1">
- <table class="main_table" width="100%" border="1" cellspacing="0" cellpadding="0">
- <tbody id="sortable">
- <tr>
- <th align="center" height="20" colspan="13" align="center" bgcolor="#006699">条目列表</th>
- </tr>
- <tr>
- <td width="10%" height="20" align="center" bgcolor="#009999">
- <input id="AllORNoall" type="checkbox"><label for="AllORNoall">全选</label>
- <input type="button" id="reserse" value="反选" />
- </td>
- <td width="7%" height="20" align="center" bgcolor="#009999">站点名称</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">站点别名</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">归类</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">公司地址</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">文字链接</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">图片链接</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">描述</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">有效开始时间</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">有效结束时间</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">电话</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">位置排序</td>
- <td width="7%" height="20" align="center" bgcolor="#009999">推荐序号</td>
- </tr>
- <%
- for(Friendurl friendurlTemp:friendurlList) {
- int urlId = friendurlTemp.getUrlid();
- String siteName = friendurlTemp.getSitename();
- int categoryId = friendurlTemp.getCategoryId();
- CategoryDao categoryDao = new IbatisCategoryDao();
- Category category = categoryDao.selectCategoryByP(categoryId);
- String categoryName = category.getCategoryName();
- String alias = friendurlTemp.getAlias();
- String address = friendurlTemp.getAddress();
- String texturl = friendurlTemp.getTexturl();
- String imageurl = friendurlTemp.getImageurl();
- String description = friendurlTemp.getDescription();
- Date validbegintime = friendurlTemp.getValidbegintime();
- Date validendtime = friendurlTemp.getValidendtime();
- String mobile = friendurlTemp.getMobile();
- int sequence = friendurlTemp.getSequence();
- int filter = friendurlTemp.getFilter();
- %>
- <tr class="package_list">
- <td width="7%" height="20" align="center" class="urlid_td"><input type="checkbox" name="urlid" class="id_select urlid" value=<%= urlId%> /></td>
- <td width="7%" height="20" align="center" class="edit sitename"><%=siteName %></td>
- <td width="7%" height="20" align="center" class="edit alias"><%=alias %></td>
- <td width="7%" height="20" align="center" class="edit categoryName"><%=categoryName%></td>
- <td width="7%" height="20" align="center" class="edit address"><%=address %></td>
- <td width="7%" height="20" align="center" class="edit texturl"><%=texturl%></td>
- <td width="7%" height="20" align="center" class="edit_img imageurl"><%if("".equals(imageurl)|| imageurl == null){ }else{%><img src='<%=imageurl%>' class='logo' title='<%=imageurl%>'/><%} %></td>
- <td width="7%" height="20" align="center" class="edit description"><%=description%></td>
- <td width="7%" height="20" align="center" class="edit validbegintime"><%=validbegintime == null || "".equals(validbegintime)? "--:--" : TimeUtil.date2Str(validbegintime)%></td>
- <td width="7%" height="20" align="center" class="edit validendtime"><%=validendtime == null || "".equals(validendtime)? "--:--" : TimeUtil.date2Str(validendtime)%></td>
- <td width="7%" height="20" align="center" class="edit mobile"><%=mobile%></td>
- <td width="7%" height="20" align="center" class="edit sequence"><%=sequence%></td>
- <td width="7%" height="20" align="center" class="edit filter"><%=filter%></td>
- </tr>
- <%
- }
- %>
- <tr>
- <td align="center"><input type="button" id="del" value="删除" /></td>
- <td align="center" colspan = "12">提示:双击选框修改属性值(<font style="color:red">拖拽LOGO调整顺序</font>)</td>
- </tr>
- </tbody>
- </table>
- </div>
- <%@ include file="inc/pagination.jsp"%>
- </div>
- <%
- }
- %>
- <iframe name='hidden_frame' id="hidden_frame" style='display:none'></iframe>
- </body>
- </html>