周报-寒假1

本周学习进度

本周对所学的html和css内容进行复习,对常见的布局和网页不同部分的实现进行了练习

练习内容

常规流练习

主要练习了div的居中以及盒模型中各个属性所代表的意义及取值

效果图
在这里插入图片描述
html部分

<article class="container">
    <header>
        <h1>这是文章的标题</h1>
        <div class="original-link">
            原文地址:<a href="">https://www.baidu.com</a>
        </div>
    </header>
    <section>
        <p>Lorem, ipsum dolor sit amet consectetur adipisicing elit. Quisquam nisi possimus, rerum nam voluptatibus aspernatur.</p>
        <p>Harum sequi quidem autem assumenda illum, cumque sed impedit eveniet, ratione exercitationem accusamus, dolorum quia.</p>
        <p>Debitis rem aliquid illo quam sunt est reiciendis ipsam quis inventore facilis error, aspernatur eos?</p>
    </section>
    <section>
        <h2>章节1</h2>
        <p>Lorem ipsum dolor sit amet consectetur adipisicing elit. Veniam qui quia dolorum velit cum magnam!</p>
        <p>Ipsa perspiciatis nam consectetur quam dignissimos illo et odio, reiciendis labore molestias asperiores illum sit.</p>
        <p>Delectus veniam atque repellat architecto mollitia porro consectetur? Repellat autem delectus voluptatum vel magnam quasi.</p>
    </section>
    <section>
        <h2>章节2</h2>
        <p>Sed quis reiciendis, pariatur magni esse labore perferendis quas unde voluptatum tenetur rerum eos distinctio.</p>
        <p>Corporis veritatis velit, animi tenetur magni iure corrupti aliquam distinctio beatae, blanditiis repellendus dicta quas?</p>
        <p>Expedita, nisi modi debitis cupiditate veniam reprehenderit optio, sunt maiores eius similique nihil minus nostrum!</p>
    </section>
    <section>
        <h2>章节3</h2>
        <p>Molestiae alias facere fuga officiis beatae qui veritatis, possimus aliquid atque autem neque pariatur accusantium?</p>
        <p>Provident est eligendi nihil doloremque aliquam maiores. Enim recusandae laboriosam fuga nam, quia ipsam nemo!</p>
        <p>Non soluta ad quas, veniam dolores at distinctio minima eius vitae expedita incidunt dolor consectetur.</p>
    </section>
    <section>
        <h2>章节4</h2>
        <p>Ex qui hic aliquam voluptas vel velit cum esse corporis voluptatibus necessitatibus, officia neque ducimus?</p>
        <p>Sunt, facilis velit expedita cum vel hic? At similique tenetur itaque ea quasi voluptates facere.</p>
        <p>Tempore, assumenda! Sint dicta rem corrupti fuga nostrum maxime fugit quia. Fugiat cumque ex consequuntur.</p>
    </section>
    <section>
        <h2>章节5</h2>
        <p>Dolorem et vero iure excepturi adipisci, minus quod. Nulla reprehenderit unde fugiat rerum iure blanditiis.</p>
        <p>Aut quis tempore atque minus consequuntur facere accusantium dolore eveniet recusandae, blanditiis quos odio dolores.</p>
        <p>Minus tenetur nostrum molestiae, unde debitis ex, nulla, atque voluptatem architecto assumenda libero optio aliquid?</p>
    </section>
</article>

css部分

body{
    background-color: #4d4a40;
    padding: 20px 0;
    line-height: 2;
    min-width: 1000px;
}

.container{
    background-color: #ffffff;
    width: 90%;
    margin: 0 auto;
    padding: 30px 0;
}

.container header{
    background-color: #267890;
    color:#ffffff;
    text-align: center;
    border: 5px solid #14414e;
    margin: 0 -34px;
}

.container header h1{
    font-size: 42px;
    font-weight: bold;
}

.container header .original-link{
    color: #dbdbdb;
    margin-bottom: 26px;
}

.container header .original-link a{
    text-decoration: underline;
}

.container header .original-link a:link{
    color: #dbdbdb;
}

.container header .original-link a:hover{
    color: #ffffff;
}

.container section{
    width: 90%;
    margin: 0 auto;
}

.container section p{
    margin: 1em 0;
}

.container section h2{
    font-size: 32px;
    font-weight: bold;
    border-top: 1px dotted;
    border-bottom: 1px dotted;
}

总结
可以通过让div上下margin设置为0,左右margin设置为auto的方法,实现div在水平方向上的居中

弹出层

主要对定位的使用进行练习

效果图
在这里插入图片描述
html部分

<div class="main">
        <img src="./桌面.png" alt="">
    </div>
    <!-- 遮罩层 -->
    <div class="modal">
        <div class="container">
            Lorem ipsum dolor, sit amet consectetur adipisicing elit. Blanditiis dolores ut, eos consequatur fuga vero explicabo dolorem illum itaque cupiditate hic officia earum quas debitis repellat voluptas expedita porro. Sit!
            <div class="close">X</div>
        </div>
    </div>

css部分

.main img{
   width: 100%;
}

.modal{
   position: fixed;
   width: 100%;
   height: 100%;
   left: 0;
   top: 0;
   background-color: rgba(0,0,0,.5)
}
.modal .container{
   width: 404px;
   height: 512px;
   background-color: white;
   position: absolute;
   left: 0;
   right: 0;
   top: 0;
   bottom: 0;
   margin: auto;
}
.modal .container .close{
   width: 30px;
   height: 30px;
   background-color: red;
   border-radius: 50%;
   color: white;
   text-align: center;
   line-height: 30px;
   position: absolute; 
   right: -15px;
   top: -15px;
   border: 2px solid #ffffff;
   cursor: pointer;
}

总结
通过绝对定位可以实现div的水平垂直居中
通过改变cursor属性来改变鼠标移动到某个元素上所显示的状态

二级菜单

效果图
在这里插入图片描述
html部分

<header class="header">
    <ul class="topnav clearfix">
        <li><a href="">Lorem.</a></li>
        <li><a href="">Modi.</a></li>
        <li><a href="">Ullam!</a></li>
        <li>
            <a href="">Aperiam.</a>
            <div class="submenu">
                Lorem ipsum dolor sit amet, consectetur adipisicing elit. Dignissimos, rem! Veritatis quasi excepturi quidem vel fugit optio suscipit maxime dignissimos rem ullam, rerum quis natus sunt ducimus commodi quos quibusdam!
            </div>
        </li>
        <li><a href="">Porro.</a></li>
    </ul>
</header>

css部分

.clearfix::after{
    content: "";
    display: block;
    clear: both;
}
.header{
    background-color: #e3e4e5;
    color: #999999;
    height: 40px;
    line-height: 40px;
}
.header .topnav{
    text-align: center;
}
a{
    text-decoration: none;
    color: inherit;
}
li{
    list-style-type: none;
}
.header .topnav>li{
    /* float: left; */
    display: inline-block;
    margin: 0 20px;
    width: 150px;
    text-align: center;
    height: 40px;
    box-sizing: border-box;
    /* background-color: #008c8c; */
    position: relative;
}
.header .topnav>li .submenu{
    text-align: left;
    line-height: 1.5;
    width: 300px;
    display: none;
    border: 2px solid #cccccc;
    box-sizing: border-box;
    position: absolute;
    right: -2px;
    background-color: white;
}

.header .topnav>li:hover{
    background-color: white;
    border: 2px solid #cccccc;
    border-bottom: none;
    line-height: 36px;
}

.header .topnav>li:hover .submenu{
    display: block;
}
.header .topnav>li:hover::after{
    content: "";
    position: absolute;
    width: 100%;
    height: 5px;
    background-color:white;
    bottom: 0mm;
    left: 0;
}

总结
通过属性选择器,对元素处于鼠标悬停时的状态设置css属性,实现鼠标悬停时出现二级菜单

三栏布局

效果图
在这里插入图片描述
html部分

<div class="container clearfix">
    <aside class="left">
        Lorem ipsum dolor sit amet, consectetur adipisicing elit. Omnis quaerat magni ratione excepturi deserunt
        illo
        consequuntur optio! Expedita laudantium consectetur, deserunt iure excepturi eveniet ducimus! Illum mollitia
        exercitationem quia eaque numquam consequatur rerum animi error ab nihil iste ad, laborum possimus libero
        officia!
    </aside>
    <aside class="right">
        Lorem ipsum dolor sit, amet consectetur adipisicing elit. Blanditiis et consequuntur, soluta modi
        praesentium
        mollitia aspernatur obcaecati, natus vel voluptatibus quas ipsum! Vitae quae laborum sit nobis consectetur?
        Sunt
        saepe animi quisquam, voluptate vitae voluptatibus alias optio maxime, labore ducimus, illum et distinctio.
        Deleniti a mollitia at culpa nam quisquam molestias dolores eligendi similique nobis impedit facere officia
    </aside>
    <div class="main">
        maiores et dignissimos, saepe
        nam nihil est doloribus excepturi neque eius mollitia provident adipisci? Earum, facere et cumque, esse
        debitis mollitia fugit, voluptatibus ab quod rem dolores facilis tenetur exercitationem distinctio! Ea,
        exercitationem velit ipsum dignissimos iste quos deleniti repudiandae facere laborum tempora, ut veritatis
        dolore dolores optio dicta nam animi iure quo amet doloremque cum sequi illo? Non cumque dolorem eveniet
        similique, deserunt explicabo quae recusandae. Id beatae fuga quae corrupti quo exercitationem incidunt
        reiciendis, magni est doloremque facere tempore ea quod eligendi aspernatur sint dolor eius earum molestias,
        porro commodi? Repudiandae, quos dolorum. Sed saepe atque culpa quas eum ipsam quis, ullam non vero rem
        rerum neque. Corrupti veritatis saepe quisquam quae nemo sint, quibusdam illum ipsum cupiditate recusandae
        eveniet voluptatum distinctio ut vero beatae quaerat officia et repellat praesentium rem earum quo
        voluptate. Molestias, dolores velit! Non eaque laborum sequi sint voluptas ab nam quo inventore ullam, velit
        ipsum exercitationem voluptatem perferendis facilis quas praesentium. Excepturi quidem fugit amet dolore
        tempora pariatur voluptates corporis nihil laudantium. Nulla laboriosam, dolor maxime fuga quidem corrupti
        voluptatibus temporibus odio, vitae ullam enim, ad assumenda ea est optio inventore in sint illo
        repellendus. Ut dolorem velit vitae repellendus repudiandae! Quo omnis iusto quia blanditiis illum rem?
        Mollitia, quis! Fugit dicta aliquam, minima quis rerum est officiis voluptates architecto, omnis aliqui
    </div>
</div>
.clearfix::after {
    content: "";
    display: block;
    clear: both;
    position: relative;
    bottom: 0px;
    height: 30px;
    background-color: white;
}

.container {
    padding: 30px;
    padding-bottom: 0px;
    border: 3px solid;
    overflow: hidden;
}

.left {
    float: left;
    width: 300px;
    background-color: lightblue;
    height: 10000px;
    margin-bottom: -9990px;
}

.right {
    float: right;
    width: 300px;
    background-color: lightblue;
    height: 10000px;
    margin-bottom: -9990px
}

.main {
    overflow: hidden;
    background-color: lightpink;
}

下周计划

下周继续复习html和css,同时进行算法的学习

WITH alldata AS( SELECT JOB_NAME ,JOB_ID ,FAB_ID ,AREA_ID ,REAL_POINT_COUNT ,ppk_value ,report_date ,CASE WHEN area_id='C-测试' THEN '测试厂' WHEN job_name LIKE '%3.1%' OR job_name LIKE '%3.2%' THEN '制造三厂' WHEN job_name LIKE '%2.1%' OR job_name LIKE '%2.2%' THEN '制造二厂' ELSE '制造一厂' END AS factory ,CASE WHEN JOB_NAME LIKE '%AE%' THEN '车规' ELSE '非车规' END AS CAR_SPEC --,TO_CHAR(report_date , 'IW') AS iso_week_number ,TO_CHAR(report_date , 'YYYYMM') AS iso_month_number FROM REP_CPK_DETAIL_NONRT where REPORT_NAME IN ('成都封测质量关注周报-测试-周二','成都封测质量关注周报-测试-周六','成都封测质量关注周报-测试-周日','成都封测质量关注周报-测试-周三' ,'成都封测质量关注周报-测试-周四','成都封测质量关注周报-测试-周五','成都封测质量关注周报-测试-周一','成都封测质量关注周报-成型-周二' ,'成都封测质量关注周报-成型-周六','成都封测质量关注周报-成型-周日','成都封测质量关注周报-成型-周三','成都封测质量关注周报-成型-周四' ,'成都封测质量关注周报-成型-周五','成都封测质量关注周报-成型-周一','成都封测质量关注周报-电镀-周二','成都封测质量关注周报-电镀-周六' ,'成都封测质量关注周报-电镀-周日','成都封测质量关注周报-电镀-周三','成都封测质量关注周报-电镀-周四','成都封测质量关注周报-电镀-周五' ,'成都封测质量关注周报-电镀-周一','成都封测质量关注周报-划片-周二','成都封测质量关注周报-划片-周六','成都封测质量关注周报-划片-周日' ,'成都封测质量关注周报-划片-周三','成都封测质量关注周报-划片-周四','成都封测质量关注周报-划片-周五','成都封测质量关注周报-划片-周一' ,'成都封测质量关注周报-键合1-周二','成都封测质量关注周报-键合1-周六','成都封测质量关注周报-键合1-周日','成都封测质量关注周报-键合1-周三' ,'成都封测质量关注周报-键合1-周四','成都封测质量关注周报-键合1-周五','成都封测质量关注周报-键合1-周一','成都封测质量关注周报-键合2-周二' ,'成都封测质量关注周报-键合2-周六','成都封测质量关注周报-键合2-周日','成都封测质量关注周报-键合2-周三','成都封测质量关注周报-键合2-周四' ,'成都封测质量关注周报-键合2-周五','成都封测质量关注周报-键合2-周一','成都封测质量关注周报-键合3-周二','成都封测质量关注周报-键合3-周六' ,'成都封测质量关注周报-键合3-周日','成都封测质量关注周报-键合3-周三','成都封测质量关注周报-键合3-周四','成都封测质量关注周报-键合3-周五' ,'成都封测质量关注周报-键合3-周一','成都封测质量关注周报-键合4-周二','成都封测质量关注周报-键合4-周六','成都封测质量关注周报-键合4-周日' ,'成都封测质量关注周报-键合4-周三','成都封测质量关注周报-键合4-周四','成都封测质量关注周报-键合4-周五','成都封测质量关注周报-键合4-周一' ,'成都封测质量关注周报-键合5-周二','成都封测质量关注周报-键合5-周六','成都封测质量关注周报-键合5-周日','成都封测质量关注周报-键合5-周三' ,'成都封测质量关注周报-键合5-周四','成都封测质量关注周报-键合5-周五','成都封测质量关注周报-键合5-周一','成都封测质量关注周报-键合6-周二' ,'成都封测质量关注周报-键合6-周六','成都封测质量关注周报-键合6-周日','成都封测质量关注周报-键合6-周三','成都封测质量关注周报-键合6-周四' ,'成都封测质量关注周报-键合6-周五','成都封测质量关注周报-键合6-周一','成都封测质量关注周报-键合7-周二','成都封测质量关注周报-键合7-周六' ,'成都封测质量关注周报-键合7-周日','成都封测质量关注周报-键合7-周三','成都封测质量关注周报-键合7-周四','成都封测质量关注周报-键合7-周五' ,'成都封测质量关注周报-键合7-周一','成都封测质量关注周报-键合8-周二','成都封测质量关注周报-键合8-周六','成都封测质量关注周报-键合8-周日' ,'成都封测质量关注周报-键合8-周三','成都封测质量关注周报-键合8-周四','成都封测质量关注周报-键合8-周五','成都封测质量关注周报-键合8-周一' ,'成都封测质量关注周报-塑封-周二','成都封测质量关注周报-塑封-周六','成都封测质量关注周报-塑封-周日','成都封测质量关注周报-塑封-周三' ,'成都封测质量关注周报-塑封-周四','成都封测质量关注周报-塑封-周五','成都封测质量关注周报-塑封-周一','成都封测质量关注周报-装片1-周二' ,'成都封测质量关注周报-装片1-周六','成都封测质量关注周报-装片1-周日','成都封测质量关注周报-装片1-周三','成都封测质量关注周报-装片1-周四' ,'成都封测质量关注周报-装片1-周五','成都封测质量关注周报-装片1-周一','成都封测质量关注周报-装片2-周二','成都封测质量关注周报-装片2-周六' ,'成都封测质量关注周报-装片2-周日','成都封测质量关注周报-装片2-周三','成都封测质量关注周报-装片2-周四','成都封测质量关注周报-装片2-周五' ,'成都封测质量关注周报-装片2-周一','成都封测质量关注周报-装片3-周二','成都封测质量关注周报-装片3-周六','成都封测质量关注周报-装片3-周日' ,'成都封测质量关注周报-装片3-周三','成都封测质量关注周报-装片3-周四','成都封测质量关注周报-装片3-周五','成都封测质量关注周报-装片3-周一' ,'成都封测质量关注周报-装片4-周二','成都封测质量关注周报-装片4-周六','成都封测质量关注周报-装片4-周日','成都封测质量关注周报-装片4-周三' ,'成都封测质量关注周报-装片4-周四','成都封测质量关注周报-装片4-周五','成都封测质量关注周报-装片4-周一') AND JOB_ID NOT IN ('72054' ,'72055' ,'72065' ,'73425' ,'73426' ,'73427' ,'73428' ,'73522' ,'73953' ,'73954' ,'74134' ,'74135' ,'74538' ,'74539' ,'74544' ,'74545' ,'74546' ,'74547' ,'74576' ,'74577' ,'74578' ,'74579' ,'74653' ,'74654' ,'74788' ,'74789' ,'74818' ,'74929' ,'74940' ,'40057' ,'40061' ,'44993' ,'51741' ,'64872' ,'69099' ,'69102' ,'69105' ,'70360' ,'70364' ,'70368' ,'71543' ,'71814' ,'71819' ,'72010' ,'72656' ,'72657' ,'72658' ,'72662' ,'72663' ,'72668' ,'72672' ,'72677' ,'73237' ,'73272' ,'73277' ,'74099' ,'74104' ,'74107' ,'74108' ,'74112' ,'74508' ,'74588' ,'74684' ,'74734' ,'74752' ,'74756' ,'74917' ,'75185' ,'75204' ,'75206' ,'75596' ,'75772' ,'75773' ,'75774' ,'40054' ,'40058' ,'40059' ,'44990' ,'44991' ,'51739' ,'57129' ,'64869' ,'64870' ,'69096' ,'69097' ,'69100' ,'69103' ,'70358' ,'70361' ,'70362' ,'70365' ,'71541' ,'71811' ,'71812' ,'71816' ,'71817' ,'72654' ,'72655' ,'72660' ,'72661' ,'72665' ,'72666' ,'72669' ,'72670' ,'72673' ,'72674' ,'73234' ,'73270' ,'73271' ,'73274' ,'73275' ,'74101' ,'74102' ,'74105' ,'74109' ,'74110' ,'74518' ,'74519' ,'74585' ,'74681' ,'74682' ,'74731' ,'74732' ,'74749' ,'74750' ,'74753' ,'74754' ,'75182' ,'75183' ,'75202' ,'75203' ,'75593' ,'75770' ,'75771' ,'40056' ,'40060' ,'44992' ,'45806' ,'51740' ,'57130' ,'64871' ,'69098' ,'69101' ,'69104' ,'70359' ,'70363' ,'70366' ,'71542' ,'71815' ,'71818' ,'71848' ,'71872' ,'71892' ,'72305' ,'72308' ,'72659' ,'72664' ,'72667' ,'72671' ,'72676' ,'73235' ,'73273' ,'73276' ,'74103' ,'74106' ,'74111' ,'74124' ,'74507' ,'74586' ,'74683' ,'74733' ,'74751' ,'74755' ,'75184' ,'75207' ,'75594' ,'75686' ,'75793' ,'49336' ,'49337' ,'49338' ,'70369' ,'71556' ,'71849' ,'71870' ,'71871' ,'71893' ,'71899' ,'72304' ,'72307' ,'72314' ,'72315' ,'73238' ,'74100' ,'74589' ,'75597' ,'75684' ,'75685' ,'26121' ,'26122' ,'26123' ,'26131' ,'26134' ,'38885' ,'38891' ,'43117' ,'45979' ,'48317' ,'49736' ,'49740' ,'56456' ,'56457' ,'58088' ,'58224' ,'58231' ,'58234' ,'62430' ,'62433' ,'62436' ,'62443' ,'63944' ,'63951' ,'63955' ,'63957' ,'64664' ,'65653' ,'65801' ,'65804' ,'65807' ,'65816' ,'65819' ,'67182' ,'67185' ,'67354' ,'67361' ,'67707' ,'68703' ,'69054' ,'69057' ,'69060' ,'69392' ,'71809' ,'71827' ,'71830' ,'71833' ,'71836' ,'71839' ,'71865' ,'72271' ,'72279' ,'72287' ,'72296' ,'72299' ,'72302' ,'72313' ,'72316' ,'72317' ,'72362' ,'72384' ,'72855' ,'72924' ,'74449' ,'74452' ,'74455' ,'74861' ,'74970' ,'74973' ,'74976' ,'75431' ,'75432' ,'75879' ,'75888' ,'75895' ,'75932' ,'75935' ,'75938' ,'61122' ,'61123' ,'61124' ,'61125' ,'61195' ,'61196' ,'61197' ,'61198' ,'61199' ,'61200' ,'61201' ,'61202' ,'61203' ,'61204' ,'61205' ,'61206' ,'61207' ,'61208' ,'61209' ,'61210' ,'61211' ,'61212' ,'61213' ,'61214' ,'61215' ,'61216' ,'61217' ,'61218' ,'61219' ,'61249' ,'61250' ,'61251' ,'61252' ,'72971' ,'72972' ,'72973' ,'73612' ,'73630' ,'73631' ,'73691' ,'73692' ,'73693' ,'73694' ,'73695' ,'73696' ,'73904' ,'73905' ,'73986' ,'73987' ,'74015' ,'74016' ,'74017' ,'74018' ,'74019' ,'74775' ,'75008' ,'75009' ,'75645' ,'75357' ,'75358' ,'75602' ,'75603' ,'75604' ,'75605' ,'75650' ,'75651' ,'75652' ,'75653' ,'75654' ,'76205' ,'76206' ,'76207' ,'76208' ,'76209' ,'73298' ,'73299' ,'73300' ,'74712' ,'73357' ,'73358' ,'73359' ,'73360' ,'73361' ,'73362' ,'73699' ,'73700' ,'73701' ,'73702' ,'73703' ,'73704' ,'73717' ,'73718' ,'73719' ,'73720' ,'73721' ,'73722' ,'73960' ,'73961' ,'73962' ,'73963' ,'73964' ,'73965' ,'73988' ,'73989' ,'73990' ,'73991' ,'73992' ,'73993' ,'74232' ,'74233' ,'74234' ,'74231' ,'74235' ,'74236' ,'74237' ,'74238' ,'74239' ,'74240' ,'74241' ,'74242' ,'74243' ,'74244' ,'74245' ,'74246' ,'74249' ,'74248' ,'74250' ,'74251' ,'74252' ,'74253' ,'74254' ,'74255' ,'74256' ,'74257' ,'74258' ,'74259' ,'74260' ,'74261' ,'75266' ,'75267' ,'75268' ,'75269' ,'75270' ,'75271' ,'75272' ,'75273' ,'75339' ,'75340' ,'75341' ,'75342' ,'75343' ,'75344' ,'75345' ,'75346' ,'75347' ,'75348' ,'75349' ,'75350' ,'75351' ,'75352' ,'75353' ,'75354' ,'75355' ,'75356' ,'72645' ,'72646' ,'72647' ,'72648' ,'73239' ,'73249' ,'73403' ,'73409' ,'73408' ,'73414' ,'73307' ,'73308' ,'72649' ,'72650' ,'72651' ,'72652' ,'73243' ,'73244' ,'73404' ,'73410' ,'73305' ,'73306' ,'73407' ,'73413' ,'72684' ,'72685' ,'72984' ,'72985' ,'72986' ,'72987' ,'72988' ,'72989' ,'72990' ,'72991' ,'73245' ,'73246' ,'73405' ,'73411' ,'73406' ,'73412' ,'73301' ,'73302' ,'72992' ,'72993' ,'72994' ,'72995' ,'72996' ,'72997' ,'72998' ,'72999' ,'73000' ,'73001' ,'73002' ,'73003' ,'73247' ,'73248' ,'73296' ,'73297' ,'75447' ,'75448' ,'75449' ,'75450' ,'73367' ,'73368' ,'73369' ,'73697' ,'73698' ,'73705' ,'73706' ,'73373' ,'73370' ,'73372' ,'73375' ,'61121' ,'61193' ,'61194' ,'72140' ,'72183' ,'72430' ,'73754' ,'76731' ,'72021' ,'72039' ,'72041' ,'72043' ,'72045' ,'72056' ,'72058' ,'72062' ,'72064' ,'72206' ,'73521' ,'73523' ,'73948' ,'74321' ,'74322' ,'74323' ,'74324' ,'74446' ,'74492' ,'74536' ,'74541' ,'74616' ,'74646' ,'74648' ,'74650' ,'74652' ,'74656' ,'74658' ,'74660' ,'74708' ,'74710' ,'74735' ,'74744' ,'74746' ,'74748' ,'74817' ,'74819' ,'74839' ,'74886' ,'74903' ,'74927' ,'74942' ,'74951' ,'75161' ,'75166' ,'75628' ,'75674' ,'75678' ,'75929' ,'75958' ,'75982' ,'76226' ,'76228' ,'76230' ,'76235' ,'76237' ,'76705' ,'76724' ,'76737' ,'76820' ,'76846' ,'76860' ,'77062' ,'72020' ,'72026' ,'72040' ,'72042' ,'72044' ,'72057' ,'72061' ,'72063' ,'72067' ,'72205' ,'73520' ,'73946' ,'74317' ,'74318' ,'74319' ,'74320' ,'74445' ,'74491' ,'74535' ,'74540' ,'74615' ,'74645' ,'74647' ,'74649' ,'74651' ,'74655' ,'74657' ,'74659' ,'74709' ,'74711' ,'74736' ,'74743' ,'74745' ,'74747' ,'74816' ,'74838' ,'74885' ,'74904' ,'74926' ,'74928' ,'74939' ,'74941' ,'74952' ,'75165' ,'75629' ,'75673' ,'75677' ,'75928' ,'75957' ,'75981' ,'76225' ,'76227' ,'76229' ,'76236' ,'76238' ,'76704' ,'76723' ,'76736' ,'76821' ,'76845' ,'76859' ,'77061' ) AND REPORT_DATE <TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM-DD') , 'YYYY-MM-DD') AND REPORT_DATE >= TO_DATE(TO_CHAR(SYSDATE, 'YYYY') || '-01-01', 'YYYY-MM-DD') ) ,enddata AS ( SELECT a.* ,CASE WHEN CAR_SPEC = '车规' THEN CASE WHEN ppk_value > 1.67 THEN 'CPK>1.67' ELSE 'CPK<1.67' END ELSE CASE WHEN ppk_value > 1.33 THEN 'CPK>1.33' ELSE 'CPK<1.33' END END AS is_ok FROM alldata a -- ${if(len(factory) > 0,"WHERE factory ='"+factory+"'","")} ) --月常规 ,month_data as( SELECT factory,area_id,car_spec ,is_ok,iso_month_number, count(*) AS countd FROM enddata GROUP BY factory,area_id,car_spec,is_ok ,iso_month_number ) --月汇总all ,month_data_count as( SELECT factory,area_id,'汇总' AS car_spec ,'CPK统计总数' AS is_ok ,'月' AS flagcol, sum(countd) AS countd,iso_month_number FROM month_data GROUP BY factory,area_id,iso_month_number UNION SELECT factory,area_id,'汇总' AS car_spec ,'CPK不达标个数' AS is_ok ,'月' AS flagcol, sum(countd) AS countd,iso_month_number FROM month_data WHERE is_ok = 'CPK<1.67' OR is_ok='CPK<1.33' GROUP BY factory,area_id,iso_month_number ) SELECT factory,area_id ,car_spec,is_ok,countd ,iso_month_number FROM month_data_count UNION SELECT factory,area_id ,car_spec,is_ok,countd ,iso_month_number FROM month_data 优化SQL
09-20
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值