" : $req_char; if ($req_split_height){ $html_split = "" : " background='$req_split_img'>"; } else $html_split = ''; $td_width = ceil(100 / $req_pl) . '%'; if ($req_f){ $arr_ext = explode(',',$req_f); array_walk($arr_ext,'mk_ext_field'); $f_list = implode(',',$arr_ext); $arr_width = explode(',',$req_fw); } if ($req_corp_class){ $sql_count = "select count(d.cdt_id) from con_details d left join con_channels c on d.cdt_channel_id = c.ccn_id,com_detail cd left join com_calling cc on cd.cdt_calling_id = cc.ccl_id where d.cdt_corp_id = cd.cdt_login_id and (cc.ccl_id in ($req_corp_class) or cc.ccl_parent_id in ($req_corp_class)) and d.cdt_valid = 1 and (c.ccn_id = $req_class or find_in_set('$req_class',c.ccn_parent_str))"; $sql = "select cc.ccl_id,d.cdt_id,d.cdt_corp_id,d.cdt_content,d.cdt_caption,d.cdt_submit_time,d.cdt_file_name,d.cdt_sign_pic,d.cdt_submit_time"; if ($req_f) $sql .= ",$f_list"; $sql .= " from con_details d left join con_channels c on d.cdt_channel_id = c.ccn_id,com_detail cd left join com_calling cc on cd.cdt_calling_id = cc.ccl_id where d.cdt_corp_id = cd.cdt_login_id and (cc.ccl_id in ($req_corp_class) or cc.ccl_parent_id in ($req_corp_class)) and d.cdt_valid = 1 and (c.ccn_id = $req_class or find_in_set('$req_class',c.ccn_parent_str))"; } else{ $sql_count = "select count(d.cdt_id) from con_details d left join con_channels c on d.cdt_channel_id = c.ccn_id where d.cdt_valid = 1 and (c.ccn_id = $req_class or find_in_set('$req_class',c.ccn_parent_str))"; $sql = "select d.cdt_id,d.cdt_corp_id,d.cdt_caption,d.cdt_submit_time,d.cdt_file_name,d.cdt_sign_pic,d.cdt_content,d.cdt_submit_time"; if ($req_f) $sql .= ",$f_list"; $sql .= " from con_details d left join con_channels c on d.cdt_channel_id = c.ccn_id where d.cdt_valid = 1 and (c.ccn_id = $req_class or find_in_set('$req_class',c.ccn_parent_str))"; } if ($req_corp){ $sql_count .= " and d.cdt_corp_id = $req_corp"; $sql .= " and d.cdt_corp_id = $req_corp"; } if ($req_hot){ $sql_count .= " and d.cdt_sign_hot = 1"; $sql .= " and d.cdt_sign_hot = 1"; } if ($req_recommend){ $sql_count .= " and d.cdt_sign_recommend = 1"; $sql .= " and d.cdt_sign_recommend = 1"; } $s = ($req_page - 1) * $req_ps + $req_skip; $sql .= " order by d.cdt_submit_time desc limit $s,$req_ps"; $r = $db->select($sql_count); $count = $r[0][0]; $pagecount = ceil($count / $req_ps); //echo $sql; $list = $db->select($sql); $html = ""; if (!isset($req_nonav)){ $url = $req_inc ? "?" : "?class=$req_class&hot=$req_hot&ulist=$req_ulist&ps=$req_ps&len=$req_len&date=&req_date&skip=$req_skip&char=$req_char&img=$req_img&lh=$req_lh&height=$req_height&nonav=$req_nonav&pl=$req_pl&split_height=$req_split_height&split_color=$req_split_color&split_img=$req_split_img&corp=$req_corp&url=$req_url&corp_class=$req_corp_class"; $url_1 = $req_inc ? "?" : "?class=$req_class&hot=$req_hot&ulist=$req_ulist&ps=$req_ps&len=$req_len&date=&req_date&skip=$req_skip&char=$req_char&img=$req_img&lh=$req_lh&height=$req_height&nonav=$req_nonav&pl=$req_pl&split_height=$req_split_height&split_color=$req_split_color&split_img=$req_split_img&corp=$req_corp&url=$req_url&corp_class=$req_corp_class"; $totalPage = $pagecount ; //总分页数量 $currentPage = @$_GET['page']+0; //当前页码 $url = "?$url_1&page"; //分而链接 $halfPer = 10; //二分之一的每页的信息数 $imagePath ="images"; //分页图片目录 $pageHtml = page ( $totalPage , $currentPage,$url ,$halfPer,$imagePath);//调用分页函数 if (($prev = $req_page - 1) > 0){ $nav_prev = "前页"; $nav_first = "首页"; } else{ $nav_prev = "前页"; $nav_first = "首页"; } if (($next = $req_page + 1) <= $pagecount){ $nav_next = "后页"; $nav_last = "末页"; } else{ $nav_next = "后页"; $nav_last = "末页"; } //require_once('../include/page_class.php'); // $pagedemo = new pageclass; //$pagedemo->showpage($pagecount,"$url",11,$req_page); $html .= "\n"; } $html .= "

\n"; if ($req_len){ if ($req_ulist) $req_len -= 1; } $html .= "\n"; foreach($list as $key => $detail){ extract($detail); if (($f = $key % $req_pl) == 0) $html .= "\n"; $len = $cdt_sign_pic ? $o_len - 2 : $o_len; $cap = ($len > 0) ? ud_str_mk_caption($cdt_caption,$len) : $cdt_caption; $sum = strip_tags($cdt_content); //$sum = $cdt_content; $sum = ud_str_mk_caption($sum,150); $date = substr($cdt_submit_time,0,10); if ($cdt_sign_pic) $cap .= "(图)"; $link = ($req_url && $cdt_corp_id) ? "$req_url?id=$cdt_id&corp=$cdt_corp_id&class=$req_class" : $cdt_file_name; $html .= ""; if ($f == $req_pl - 1) $html .= "\n$html_split\n"; } if (($key %= $req_pl) < $req_pl - 1){ for (;$key < $req_pl - 1;$key++) $html .= "\n"; $html .= "\n$html_split\n"; } $html .= " "; $html .= "$html_cap_prev$cap"; if ($req_f){ foreach($arr_ext as $k => $ext) $html .= ""; } if($req_two){ $html .= "$sum ...$date"; $html .= ""; } $html .= " {$$ext}

".$pageHtml."

\n"; echo $html; function mk_ext_field(&$id) { $id = 'cdt_ext_' . str_pad($id,2,'0',STR_PAD_LEFT); } ?>