index_06_01 中间

本文介绍了一个用于展示乳腺健康资讯的轮播插件实现方法。该插件使用HTML、CSS和JavaScript技术,能够自动切换展示不同文章的缩略图及链接,同时提供了手动选择功能。

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<HTML xmlns="http://www.w3.org/1999/xhtml">
<HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META content=IE=EmulateIE7 http-equiv=X-UA-Compatible>
<LINK rel=stylesheet type=text/css href="css/rxwc.css">
<script type="text/javascript" src="js/jquery-1.8.3.min.js"></script>
<style >

.w510{ float:left; width:500px; background:#ffeee5; padding:5px 5px;}
.w510 a{text-decoration:none;color:#cf2d39;}
.w510 a:hover{ color:#5e5f5f;text-decoration:underline;} 

.bar { width:500px; height:280px;}
.bar dl{height:25px;background:url(../images/dtb1.jpg) repeat-y;display:block;line-height:30px;overflow:hidden; margin:0px;}
.bar dt,.bar dd{float:left;margin-right:5px;display:inline;}
.bar dt a:link,.bar dt a:visited{width:334px;color:#fff;font-size:14px;padding-left:15px;display:block;}
a.da1:link,a.da1:visited{width:21px;height:25px;display:block;font-size:13px;font-weight:700;color:#8d5d22;background:url(../images/dtb3.gif) no-repeat;line-height:25px;text-align:center;float:left;margin-left:2px;}
a.da2:link,a.da2:visited{float:left;display:block;width:21px;height:25px;margin-left:2px;font-size:13px;font-weight:700;color:#fff;background:url(../images/dtb2.gif) no-repeat;line-height:25px;text-align:center;}
a.da2:hover,a.da2:active{background:url(../images/dtb3.gif) no-repeat;text-decoration:none;color:#8d5d22;}

</style>

</HEAD>
<BODY>


<DIV class=w510>
<DIV class=bar>
<SCRIPT type=text/javascript src="js/imagesscrollnew.js"></SCRIPT>
<SCRIPT type=text/javascript>
imgLink[1]="http://ruxian.woman91.com/baojian/2011100549431.shtml";
imgAlt[1]="乳房上长了鹅卵石,怎么办?";
imgtext[1]="<a href='http://ruxian.woman91.com/baojian/2011100549431.shtml'>乳房上长了鹅卵石,怎么办?</a>";
imgUrl[1]="http://images.woman91.com/zt/ruxianweichuang/201110517636640.jpg";
imgLink[2]="http://ruxian.woman91.com/zhongliu/2011102650546.shtml";
imgAlt[2]="乳腺微创手术,切除肿瘤不留痕";
imgtext[2]="<a href='http://ruxian.woman91.com/zhongliu/2011102650546.shtml'>乳腺微创手术,切除肿瘤不留痕</a>";
imgUrl[2]="http://images.woman91.com/zt/ruxianweichuang/2011102614180765.jpg";
imgLink[3]="http://ruxian.woman91.com/xianweiliu/2011100649140.shtml";
imgAlt[3]="什么是乳腺纤维瘤?";
imgtext[3]="<a href='http://ruxian.woman91.com/xianweiliu/2011100649140.shtml'>什么是乳腺纤维瘤?</a>";
imgUrl[3]="http://images.woman91.com/zt/ruxianweichuang/20111061720678.jpg";
imgLink[4]="http://ruxian.woman91.com/baojian/2011100547670.shtml";
imgAlt[4]="你不说,没人知道你做过乳腺手术";
imgtext[4]="<a href='http://ruxian.woman91.com/baojian/2011100547670.shtml'>你不说,没人知道你做过乳腺手术</a>";
imgUrl[4]="http://images.woman91.com/zt/ruxianweichuang/2011106172652812.jpg";
var count=4;
</SCRIPT>
<A href="javascript:goUrl()" target=_self><IMG 
style="FILTER: revealTrans(duration=1,transition=5)" class=imgClass border=0 
name=imgInit src="picture/blank.gif" width=500 
height=250></A>
<DL>
  <DT id=focustext></DT>
  <DD><A id=link1 class=da2 href="javascript:changeimg(1)" target=_self>1</A> <A 
  id=link2 class=da2 href="javascript:changeimg(2)" target=_self>2</A> <A 
  id=link3 class=da2 href="javascript:changeimg(3)" target=_self>3</A> <A 
  id=link4 class=da2 href="javascript:changeimg(4)" target=_self>4</A> 
</DD></DL></DIV></DIV>
<SCRIPT type=text/javascript>
nextAd();
</SCRIPT>
</BODY>
</HTML>


/js  文件/
var imgWidth=500;              //图片宽
var imgHeight=250;             //图片高
var textFromHeight=25;         //焦点字框高度 (单位为px)
var buttonLineOn="#f60";           //button下划线on的颜色
var buttonLineOff="#000";          //button下划线off的颜色
var TimeOut=4000;              //每张图切换时间 (单位毫秒);
var imgUrl=new Array(); 
var imgLink=new Array();
var imgtext=new Array();
var imgAlt=new Array();
var adNum=0;
var overon=0; //鼠标是否移到上面

function playTran(){
if (document.all)
imgInit.filters.revealTrans.play();		
}

function changeimg(n)
{
adNum=n;
//window.clearInterval(theTimer);
clearTimeout(theTimer);
adNum=adNum-1;
nextAd();
}

function goUrl(){
window.open(imgLink[adNum],'_blank');
}

/*
function nextAd(){
if(adNum<(imgUrl.length-1))adNum++;
else adNum=1;
theTimer=setTimeout("nextAd()", TimeOut);
document.images.imgInit.src=imgUrl[adNum];
document.images.imgInit.alt=imgAlt[adNum];	
document.getElementById('focustext').innerHTML=imgtext[adNum];
document.getElementById('imgLink').href=imgLink[adNum];
}
*/

function nextAd(){
document.images.imgInit.onmouseover=function(){
	overon=1;
}
document.images.imgInit.onmouseout=function(){
	overon=0;
}
if (overon==1){
	theTimer=setTimeout("nextAd()", TimeOut);
	return;
}
if(adNum<count) adNum++ ;
else adNum=1;

if (document.all){
imgInit.filters.revealTrans.Transition=23;
imgInit.filters.revealTrans.apply();
playTran();
}
document.images.imgInit.src=imgUrl[adNum];
document.images.imgInit.alt=imgAlt[adNum];	
document.getElementById('link'+adNum).className="da1";
for (var i=1;i<=count;i++)
{
if (i!=adNum){document.getElementById('link'+i).className="da2";}
}
document.getElementById("focustext").innerHTML=imgtext[adNum];
theTimer=setTimeout("nextAd()", TimeOut);
}



-- 步骤1:创建物化视图存储中间结果 CREATE MATERIALIZED VIEW mv_operation_data BUILD IMMEDIATE REFRESH COMPLETE ON DEMAND AS SELECT ocfh.user_code, NVL(u.user_name, ocfh.user_code) AS operator_name, NVL(org.unit_name, '未知处室') AS dept_name, TRUNC(ocs.operation_date) AS operation_date, ocs.operation_code, ocbi.item_code, ocbi.sub_item FROM oa_common_flow_handle ocfh INNER JOIN oa_common_flow_step_ins ocfs ON ocfh.step_ins_oid = ocfs.step_ins_oid INNER JOIN oa_common_biz_info ocbi ON ocbi.flow_ins_oid = ocfs.flow_ins_oid INNER JOIN oa_common_step_operation ocs ON ocfh.flow_handle_oid = ocs.flow_handle_oid LEFT JOIN users u ON ocfh.user_code = u.reference_oid LEFT JOIN oa_unit_org org ON ocfh.unit_oid = org.unit_oid WHERE ocs.operation_code IN ('03','04','05','06','08') AND ocs.operation_date >= DATE '2025-01-01' AND ocs.operation_date < DATE '2026-01-01'; -- 步骤2:创建索引加速查询 CREATE INDEX idx_mv_op_date ON mv_operation_data(operation_date); CREATE INDEX idx_mv_op_code ON mv_operation_data(operation_code); -- 步骤3:查询物化视图(避免长事务) SELECT dept_name AS "处室", operator_name AS "处理人", -- 公文类型映射 CASE WHEN item_code = '01' AND sub_item = '01' THEN '普通来文' WHEN item_code = '01' AND sub_item = '02' THEN '会议件' WHEN item_code = '02' THEN '发文' WHEN item_code = '03' AND sub_item = '03' THEN '内部文' ELSE '其他文种' END AS "文类", -- 操作状态映射 CASE operation_code WHEN '03' THEN '签收' WHEN '04' THEN '办理' WHEN '05' THEN '更新' WHEN '06' THEN '签批' WHEN '08' THEN '完成' END AS "操作状态", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 1 THEN 1 END) AS "一月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 2 THEN 1 END) AS "二月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 3 THEN 1 END) AS "三月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 4 THEN 1 END) AS "四月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 5 THEN 1 END) AS "五月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 6 THEN 1 END) AS "六月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 7 THEN 1 END) AS "七月", COUNT(CASE WHEN EXTRACT(MONTH FROM operation_date) = 8 THEN 1 END) AS "八月" FROM mv_operation_data GROUP BY dept_name, operator_name, CASE WHEN item_code = '01' AND sub_item = '01' THEN '普通来文' WHEN item_code = '01' AND sub_item = '02' THEN '会议件' WHEN item_code = '02' THEN '发文' WHEN item_code = '03' AND sub_item = '03' THEN '内部文' ELSE '其他文种' END, CASE operation_code WHEN '03' THEN '签收' WHEN '04' THEN '办理' WHEN '05' THEN '更新' WHEN '06' THEN '签批' WHEN '08' THEN '完成' END; 我用的这个SQL,导出的数据,有部门件,就是部署于个人办理,而是属于部门的,但是显示的是unit_oid 怎么部门就显示部门呢
08-27
SELECt a.code AS code,a.city_name,a.patent_trademark_pledge AS a,b.patent_trademark_pledge AS b,c.patent_trademark_pledge AS c,d.patent_trademark_pledge AS d FROM (SELECT CONCAT(br.code,'00') AS code,a.city_name,patent_trademark_pledge FROM index_intellectual_property_agency_pledge_month a INNER JOIN blade_region br ON br.name = a.city_name WHERE a.data_dimension = '本期新增' AND a.data_time = (SELECT CONCAT(MAX(to_char(STR_TO_DATE(data_time,'%Y-%m'),'%Y')) - 3,'-12') FROM index_intellectual_property_agency_pledge_month) AND a.city_name NOT IN ('广东省') GROUP BY a.city_name) a, (SELECT CONCAT(br.city_code,'00') AS code,a.city_name,patent_trademark_pledge FROM index_intellectual_property_agency_pledge_month a INNER JOIN blade_region br ON br.name = a.city_name WHERE a.data_dimension = '本期新增' AND a.data_time = (SELECT CONCAT(MAX(to_char(STR_TO_DATE(data_time,'%Y-%m'),'%Y')) - 2,'-12') FROM index_intellectual_property_agency_pledge_month) AND a.city_name NOT IN ('广东省') GROUP BY a.city_name) b, (SELECT CONCAT(br.city_code,'00') AS code,a.city_name,patent_trademark_pledge FROM index_intellectual_property_agency_pledge_month a INNER JOIN blade_region br ON br.name = a.city_name WHERE a.data_dimension = '本期新增' AND a.data_time = (SELECT CONCAT(MAX(to_char(STR_TO_DATE(data_time,'%Y-%m'),'%Y')) - 1,'-12') FROM index_intellectual_property_agency_pledge_month) AND a.city_name NOT IN ('广东省') GROUP BY a.city_name) c, (SELECT CONCAT(br.city_code,'00') AS code,a.city_name,patent_trademark_pledge FROM index_intellectual_property_agency_pledge_month a INNER JOIN blade_region br ON br.name = a.city_name WHERE a.data_dimension = '本期新增' AND a.data_time = '2023-06' AND a.city_name NOT IN ('广东省') GROUP BY a.city_name) d WHERE a.code = b.code AND a.code = c.code AND a.code = d.code
03-26
use global use component_prameter use constant use time_control use LOCAL_RESM implicit none character*20 :: Para_Inlst01,Para_Inlst02,Para_Inlst03 character*20 :: Para_Inlst04,Para_Inlst05,Para_Inlst06,Para_Inlst07 real*8 :: DX_3DV_Input(100),DY_3DV_Input(100),DZ_3DV_Input(100) real*8 :: VELX_3DV_Input,VELY_3DV_Input,VELZ_3DV_Input real*8 :: ANGX_3DV_Input,ANGY_3DV_Input,ANGZ_3DV_Input integer :: CV_Structure_x,CV_Structure_y,CV_Structure_z real*8 :: Gama_CV,Gama_X,Gama_Y,Gama_z integer :: AQCVIN_x,AQCVIN_y,AQCVIN_z real*8 :: AQQ_Input,AQT_Input, AQH_Input character*20 :: INDEX_ISIDE_3DCV, INDEX_OSIDE_3DCV real*8 temp_tterm integer:: N3DV, I3DV integer:: I3DJX, I3DJY, I3DJZ integer:: NX_3DJX,NY_3DJX,NZ_3DJX integer:: NX_3DJY,NY_3DJY,NZ_3DJY integer:: NX_3DJZ,NY_3DJZ,NZ_3DJZ integer:: INCV_X,INCV_Y,INCV_Z integer:: OUTCV_X,OUTCV_Y,OUTCV_Z integer:: Nin_3Dpool,Nout_3Dpool integer:: In_3DPool_X(1000), In_3DPool_Y(1000),In_3DPool_Z(1000) integer:: Out_3DPool_X(1000), Out_3DPool_Y(1000),Out_3DPool_Z(1000) integer:: In_3DV,Out_3DV character*20 :: Connect_InName,Connect_OutName character*20 :: InName_Con(1000),OutName_Con(1000) character*20 :: Index_Oside_3DCV_INPUT(1000), Index_Iside_3DCV_INPUT(1000) integer:: IO_3DPool_X(1000), IO_3DPool_Y(1000), IO_3DPool_Z(1000) character*20 :: Index_IOside_3DCV_INPUT(1000), IOName_Con(1000) integer:: IO_3DV integer:: IO_Cv_X,IO_Cv_Y,IO_Cv_Z ,NIO_3Dpool character*20 :: Index_IOside_3DCV, Connect_IOName integer:: NX_3DV_Input,NY_3DV_Input,NZ_3DV_Input integer:: NTOTAL_3DV,NTOTAL_3DJX,NTOTAL_3DJY,NTOTAL_3DJZ integer:: IZ_3DV ,IX_3DV ,IY_3DV integer:: IZ_3DJX ,IX_3DJX ,IY_3DJX integer:: IZ_3DJY ,IX_3DJY ,IY_3DJY integer:: IZ_3DJZ ,IX_3DJZ ,IY_3DJZ integer:: IX,IY,IZ integer:: IJUNC
06-10
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值