jhhg

QQ空间装饰软件精选
最新推荐文章于 2025-09-11 15:57:37 发布
原创 最新推荐文章于 2025-09-11 15:57:37 发布 · 150 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#photoshop #ux

本文精选了五款用于装饰和编辑QQ空间的软件，包括图片处理、动态GIF制作、音频编辑等工具，并提供了下载链接及简介。
jhhg
2009年07月06日
　　> 24) & 0xff;
return this.FONTMAP.substring(2*(id-1), 2 * id);
}" color=#800080 size=4>上最新的QQ空间制作软件大全
　　
　　
　　
　　
　　
　　
　　 推荐指数：★★★★★ 软件大小：300M
　　下载地址：http://www.duote.com/soft/808.html?其它/Photoshop8.0.CS.rar （整个都是地址哦！）
　　软件介绍：这个软件可以说是制作空间的时候用得最多的软件了。主要用于图片的制作，在我说的很多教程里面都有提到。想把空间装扮的漂亮一点的朋友，都可以下载以后学学看。
　　软件名称：Ulead GIF Animator 5 （简称U5)
　　推荐指数：★★★
　　软件大小：6.59M
　　下载网站：http://www.onegreen.net/Soft_Show.asp?SoftID=94
　　下载地址：http://mmm.onegreen.net/soft/pic_uga5.zip
　　软件介绍：这个是做动态gif图片用的，在空间里主要用于制作个性签名图。当然这个软件和photoshop里面的Imageready的功能差不多，但是更容易操作一点。有的时候一些动态效果也可以用flash制作。我的教程里面也有提到过。
　　软件名称：Adobe Audition 3.0
　　推荐指数：★★
　　软件大小：41.3M
　　下载地址：thunder://QUFodHRwOi8veHgyLmdkLnhkb3ducy5jb20veC8wNzExL0F1ZGl0aW9uX0NTM19jaHMucmFyWlo（迅雷专用的下载地址）
　　软件介绍：如果你想要编辑翻唱的歌曲，或者是想编辑其他的空间音乐的话，可以用这个软件。
　　软件名称：Microsoft Office 2007
　　推荐指数：★★★
　　软件大小：57.62M
　　下载网站：http://www.onegreen.net/Soft_Show.asp?SoftID=6500
　　下载地址：http://mmm.onegreen.net/soft7/2008031419.rar
　　软件介绍：office我想大家都很清楚吧，做空间几乎用不着，不过如果你想到QQ空间官方吧做版主的话，应该很有用吧。
　　软件名称：录音软件和混响软件 www.qq0101.cn
　　推荐指数：★★★★
　　下愀?
iteye_15833
关注
javaweb学生管理系统的课程设计
.....
07-22 4万+
1.设计任务书 1.1 简单的学生管理体统 本人计划编写一个简单的学生管理系统，主要从两个身份来说——老师和学生，对于老师来说，带验证码的登录注册，对学生进行增删改查，以分页的形式展示学生的所有信息；对于学生来说，带验证码的登录注册，以及查询自己的信息，修改自己的信息，以及查询其他学生的信息除密码以外。具体要求如下： 1、实现数据库连接，数据库有两个表，一个教师表，一个学生表教师表只有简单的u
QQ空间js
热门推荐
xiaosi2019的博客
05-27 2万+
<script type="text/javascript"> (function() { var whileList = { 'qzs.qq.com': 1, 'astro.fashion.qq.com': 1, 'gameapp.qq.com': 1, ...
小翼推荐-【最新qq空间软件,软件下载】
az014az
01-16 172
小翼推荐-【最新qq空间软件,软件下载】 2009年07月28日 　　推荐指数：★★★★★ 软件大小：300M 　　下载地址：http://www.duote.com/soft/808.html?其它/Photoshop8.0.CS.rar （整个都是地址哦！） 　　软件介绍：这个软件可以说是制作空间的时候用得最多的软件了。主要用于图片的制作，在我说的很多教程里面都有提到。想把空...
jhhh
qing101hua的专栏
10-12 540
ms/channels/step/data/elemSize The class Mat represents an n-dimensional dense numerical single-channel or multi-channel array. It can be used to store (Mat类的对象用于表示一个多维度的单通道或者多通道稠密数组，它可以用来存储以下东西) re
制作非主流QQ空间图片在线编辑制作工具大全
wuhui
05-25 1477
闪字http://ghlp.igogo8.com/ghlp_more.html 图片生成：http://pic.sdodo.com/ 字符画：http://mm.tpp8.com/ascii/ 在线编辑图片： http://www.iephotoshop.com 繁体字转换：http://vip2.6to23.com/may5th/zh.html 网上现场制...
软件空降灭火员的技巧
软件质量优化
09-30 2120
  软件空降灭火员的技巧 陈能技2007-9-29 原文：Skills For Software Smokejumpers – Don Gray 你知道空降灭火员吗？他们是勇敢的、自信的救火队员，空降到很远的地方，背着80磅的装备准备消灭森林大火。如果空降比较顺利的话，他们会安全着陆。灭完火后，他们可能需要步行10英里的路程走出去。这不是一个胆小的、反应迟缓的、缺乏自信
qq空间制作常用软件
umkdy85a
01-16 434
qq空间制作常用软件 2010年03月24日 　　Macromedia Flash V8.0 简体中文版完全版 　　Flash是交互式矢量图和Web动画的标准。网页设计者使用Flash能创建漂亮的、可改变尺寸的、以及极其紧密的导航界面、技术说明以及其他奇特的效果。 　　下载地址: 　　http://www.skycn.com/soft/2491.html 　　Macrom...
JsonConvert序列化问题
weixin_30758821的博客
11-30 547
返回的Json数据如下： [[1400025600,9633460,9667535,2698.09,2734.73,2749,2698.08,25333.3057,11784.9,13548.4,69148900],[1400112000,9667536,9700700,2734.94,2771.01,2790,2731.48,24260.1011,11824.5,12435.6,67093...
" SELECT * FROM(SELECT AA08.*, BB08.STOP_ELASED_TIME08 FROM " " (SELECT AA0202.*, BB0202.STOP_ELASED_TIME0202 FROM " " (SELECT AA0201.*, BB0201.STOP_ELASED_TIME0201 FROM " " (SELECT AA12.*, BB12.STOP_ELASED_TIME12 FROM " " (SELECT AA16.*, BB16.STOP_ELASED_TIME16 FROM " " (SELECT AA07.*, BB07.STOP_ELASED_TIME07 FROM " " (SELECT AA15.*, BB15.STOP_ELASED_TIME15 FROM " " (SELECT AA04.*, BB04.STOP_ELASED_TIME04 FROM " " (SELECT AA05.*, BB05.STOP_ELASED_TIME05 FROM " " (SELECT AA06.*, BB06.STOP_ELASED_TIME06 FROM " " (SELECT AA0302.*, BB0302.STOP_ELASED_TIME0302 FROM " " (SELECT AA0301.*, BB0301.STOP_ELASED_TIME0301 FROM " " (SELECT AA0102.*, BB0102.STOP_ELASED_TIME0102 FROM " " (SELECT AA0101.*, BB0101.STOP_ELASED_TIME0101 FROM " " (SELECT AA14.*, BB14.STOP_ELASED_TIME14 FROM " " (SELECT AA.*, BB.STOP_ELASED_TIME FROM(SELECT * FROM(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, STOP_REASON, " " SUM(ROUND(CASE WHEN STOP_ELASED_TIME = ' ' THEN '0' ELSE STOP_ELASED_TIME END / 60, 1)) STOP_ELASED_TIME FROM TMMCR42A WHERE PROD_DATE " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP, STOP_REASON ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) pivot(sum(STOP_ELASED_TIME) for STOP_REASON " " in('05' JHJX, '06' JJB, '07' JHHG, '08' SY, '18' JHSJQT, '10' LSJX, '16' JHHGZG, '17' JHHZCG, '01' DL, '02' DD, '03' DMQ, '04' MK, '11' HZ, '19' WBSJQT, '12' DS, '13' DDQ, " " '14' DZQ, '15' XC)) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', STOP_REASON, SUM(ROUND(CASE WHEN STOP_ELASED_TIME = ' ' THEN '0' ELSE STOP_ELASED_TIME END / 60, 1)) STOP_ELASED_TIME FROM TMMCR42A WHERE PROD_DATE " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE, STOP_REASON ORDER BY UNIT_CODE) " " pivot(sum(STOP_ELASED_TIME) for STOP_REASON in('05' JHJX, '06' JJB, '07' JHHG, '08' SY, '18' JHSJQT, '10' LSJX, '16' JHHGZG, '17' JHHZCG, '01' DL, '02' DD, '03' DMQ, '04' MK, '11' HZ, " " '19' WBSJQT, '12' DS, '13' DDQ, '14' DZQ, '15' XC)) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', STOP_REASON, SUM(ROUND(CASE WHEN STOP_ELASED_TIME = ' ' THEN '0' ELSE STOP_ELASED_TIME END / 60, 1)) STOP_ELASED_TIME FROM TMMCR42A WHERE PROD_DATE " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, STOP_REASON ORDER BY UNIT_CODE) pivot(sum(STOP_ELASED_TIME) for STOP_REASON in('05' JHJX, '06' JJB, '07' JHHG, '08' SY, '18' JHSJQT, " " '10' LSJX, '16' JHHGZG, '17' JHHZCG, '01' DL, '02' DD, '03' DMQ, '04' MK, '11' HZ, '19' WBSJQT, '12' DS, '13' DDQ, '14' DZQ, '15' XC)) " " UNION ALL " " SELECT * FROM(SELECT A.UNIT_CODE, A.SZLJ, A.STOP_REASON, (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '3BSZLJ' SZLJ, STOP_REASON, " " SUM(ROUND(CASE WHEN STOP_ELASED_TIME = ' ' THEN '0' ELSE STOP_ELASED_TIME END / 60, 1)) STOP_ELASED_TIME FROM TMMCR42A WHERE PROD_DATE " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE, STOP_REASON ORDER BY UNIT_CODE) A " " LEFT JOIN(SELECT UNIT_CODE, 'SZLJ' SZLJ, STOP_REASON, SUM(ROUND(CASE WHEN STOP_ELASED_TIME = ' ' THEN '0' ELSE STOP_ELASED_TIME END / 60, 1)) STOP_ELASED_TIME FROM TMMCR42A WHERE PROD_DATE " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE, STOP_REASON ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) pivot(sum(STOP_ELASED_TIME) for STOP_REASON in('05' JHJX, '06' JJB, '07' JHHG, '08' SY, '18' JHSJQT, " " '10' LSJX, '16' JHHGZG, '17' JHHZCG, '01' DL, '02' DD, '03' DMQ, '04' MK, '11' HZ, '19' WBSJQT, '12' DS, '13' DDQ, '14' DZQ, '15' XC))) ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) AA " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A " " LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) BB ON AA.UNIT_CODE = BB.UNIT_CODE AND AA.PROD_SHIFT_GROUP = BB.PROD_SHIFT_GROUP) AA14 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME14 FROM TMMCR42A WHERE STOP_TYPE = '01' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '01' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '01' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '01' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '01' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB14 ON AA14.UNIT_CODE = BB14.UNIT_CODE AND AA14.PROD_SHIFT_GROUP = BB14.PROD_SHIFT_GROUP) AA0101 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME0101 FROM TMMCR42A WHERE STOP_TYPE = '16' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '16' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '16' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '16' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '16' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE)BB0101 ON AA0101.UNIT_CODE = BB0101.UNIT_CODE AND AA0101.PROD_SHIFT_GROUP = BB0101.PROD_SHIFT_GROUP) AA0102 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME0102 FROM TMMCR42A WHERE STOP_TYPE = '17' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '17' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '17' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '17' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '17' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB0102 ON AA0102.UNIT_CODE = BB0102.UNIT_CODE AND AA0102.PROD_SHIFT_GROUP = BB0102.PROD_SHIFT_GROUP) AA0301 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME0301 FROM TMMCR42A WHERE STOP_TYPE = '20' " " AND SUBSTR(STOP_START_TIME, 0, 8) BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP " " ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '20' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '20' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '20' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '20' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB0301 ON AA0301.UNIT_CODE = BB0301.UNIT_CODE AND AA0301.PROD_SHIFT_GROUP = BB0301.PROD_SHIFT_GROUP) AA0302 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME0302 FROM TMMCR42A WHERE STOP_TYPE = '21' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '21' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '21' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '21' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '21' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB0302 ON AA0302.UNIT_CODE = BB0302.UNIT_CODE AND AA0302.PROD_SHIFT_GROUP = BB0302.PROD_SHIFT_GROUP) AA06 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME06 FROM TMMCR42A WHERE STOP_TYPE = '04' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '04' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '04' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '04' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '04' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB06 ON AA06.UNIT_CODE = BB06.UNIT_CODE AND AA06.PROD_SHIFT_GROUP = BB06.PROD_SHIFT_GROUP) AA05 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME05 FROM TMMCR42A WHERE STOP_TYPE = '05' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '05' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '05' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '05' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '05' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB05 ON AA05.UNIT_CODE = BB05.UNIT_CODE AND AA05.PROD_SHIFT_GROUP = BB05.PROD_SHIFT_GROUP) AA04 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME04 FROM TMMCR42A WHERE STOP_TYPE = '06' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '06' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '06' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '06' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '06' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB04 ON AA04.UNIT_CODE = BB04.UNIT_CODE AND AA04.PROD_SHIFT_GROUP = BB04.PROD_SHIFT_GROUP) AA15 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME15 FROM TMMCR42A WHERE STOP_TYPE = '07' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '07' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '07' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '07' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '07' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB15 ON AA15.UNIT_CODE = BB15.UNIT_CODE AND AA15.PROD_SHIFT_GROUP = BB15.PROD_SHIFT_GROUP) AA07 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME07 FROM TMMCR42A WHERE STOP_TYPE = '08' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '08' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '08' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '08' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '08' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB07 ON AA07.UNIT_CODE = BB07.UNIT_CODE AND AA07.PROD_SHIFT_GROUP = BB07.PROD_SHIFT_GROUP) AA16 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME16 FROM TMMCR42A WHERE STOP_TYPE = '09' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '09' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '09' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '09' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '09' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB16 ON AA16.UNIT_CODE = BB16.UNIT_CODE AND AA16.PROD_SHIFT_GROUP = BB16.PROD_SHIFT_GROUP) AA12 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME12 FROM TMMCR42A WHERE STOP_TYPE = '10' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '10' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '10' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '10' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '10' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB12 ON AA12.UNIT_CODE = BB12.UNIT_CODE AND AA12.PROD_SHIFT_GROUP = BB12.PROD_SHIFT_GROUP) AA0201 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME0201 FROM TMMCR42A WHERE STOP_TYPE = '18' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '18' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '18' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '18' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '18' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB0201 ON AA0201.UNIT_CODE = BB0201.UNIT_CODE AND AA0201.PROD_SHIFT_GROUP = BB0201.PROD_SHIFT_GROUP) AA0202 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME0202 FROM TMMCR42A WHERE STOP_TYPE = '19' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '19' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '19' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '19' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '19' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB0202 ON AA0202.UNIT_CODE = BB0202.UNIT_CODE AND AA0202.PROD_SHIFT_GROUP = BB0202.PROD_SHIFT_GROUP) AA08 " " " " " " " " " " LEFT JOIN(SELECT * FROM(SELECT UNIT_CODE, PROD_SHIFT_GROUP, ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME08 FROM TMMCR42A WHERE STOP_TYPE = '13' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE, PROD_SHIFT_GROUP ORDER BY UNIT_CODE, PROD_SHIFT_GROUP) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '1YLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '13' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(last_day(add_months(to_date(@op_date_from, 'yyyy/mm/dd'), -1)), 'yyyymmdd') AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT * FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '13' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to GROUP BY UNIT_CODE ORDER BY UNIT_CODE) " " UNION ALL SELECT A.UNIT_CODE, '3BSZLJ', (A.STOP_ELASED_TIME - B.STOP_ELASED_TIME) STOP_ELASED_TIME FROM(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME " " FROM TMMCR42A WHERE STOP_TYPE = '13' AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN @op_date_from AND @op_date_to " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) A LEFT JOIN(SELECT UNIT_CODE, '2ZLJ', ROUND(SUM(STOP_ELASED_TIME) / 60, 1) STOP_ELASED_TIME FROM TMMCR42A WHERE STOP_TYPE = '13' " " AND SUBSTR(STOP_START_TIME, 0, 8) " " BETWEEN to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 7, 'yyyymmdd') " " AND to_char(to_date(@op_date_from, 'yyyy/mm/dd') + (2 - to_char(to_date(@op_date_from, 'yyyy/mm/dd'), 'd')) - 1, 'yyyymmdd') " " GROUP BY UNIT_CODE ORDER BY UNIT_CODE) B ON A.UNIT_CODE = B.UNIT_CODE) BB08 ON AA08.UNIT_CODE = BB08.UNIT_CODE AND AA08.PROD_SHIFT_GROUP = BB08.PROD_SHIFT_GROUP) " "WHERE UNIT_CODE IN ('L11','L41','L43','L51','L61','L62','L63','L71','L72','L81','L82','L83','L84','L85','L86','L87','L91','L93','L94','L95','L96','L97','L98','L9A','L9B','LA1','LA2','LA3','LA4','LA9','LAA') " ;帮我在不影响原逻辑的情况下优化这段SQL,反馈完整的回来
09-05
'05' JHJX, '06' JJB, '07' JHHG, '08' SY, '18' JHSJQT, '10' LSJX, '16' JHHGZG, '17' JHHZCG, '01' DL, '02' DD, '03' DMQ, '04' MK, '11' HZ, '19' WBSJQT, '12' DS, '13' DDQ, '14' DZQ, '15' XC ) ) -- ...
钓鱼网站+钓鱼工具
LiuHandsomes的博客
01-04 5988
钓鱼工具：ReelPhish ReelPhish实时双因子钓鱼工具是以命令的方式运行的，主要有两个组件，一个组件是嵌入钓鱼网站的PHP脚本（需根据确定的目标网站对脚本代码进行设置修改），用来获取钓鱼的数据（账户、密码、双因子验证等）并发送到攻击者电脑中的python脚本，另一个组件是用来监听钓鱼网站数据的ReelPhish.py，当侦听到账户密码等信息时就会启动selenium框架驱动浏览器自动...
QQ空间
ddsdsdsdl333l的专栏
06-14 763
QQ空间很有趣，而且我渐渐发现周围越来越多的朋友都开通了QQ空间。我今天开通了自己的空间，这样，以后看看朋友们都在做什么，也能让朋友们知道自己在做什么，很方便。经常来我的空间转转吧，我这里会有很多好照片！ 最近新电影不少，我最想看的一部电影是无级，如果你看过了，记得一定告诉我这部电影怎么样。除了电影，生活也是很丰富的。我最近最有成就感的一件事就是，身 提 。 我打算买索尼(SONY)，呵呵。如果我
【PS2020版】保姆级Adobe Photoshop 2020 完整安装与功能指南下载安装详细图文教程（附安装包）
YoungUpUp的博客
09-10 956
【PS2020版】保姆级Adobe Photoshop 2020 完整安装与功能指南 🎨下载安装详细图文教程（附安装包）。本文详细介绍Adobe Photoshop 2020的安装指南与功能亮点。作为专业图像处理软件，PS2020支持智能选区、无损编辑、专业调色等核心功能，适用于摄影、设计、UI等多个领域。安装包需Win10系统。文章提供详细图文安装步骤。
Photoshop - Photoshop 创建图层蒙版
weixin_52173250的博客
09-07 364
Photoshop - Photoshop 创建图层蒙版
Photoshop图层间的关系
qq_41807399的博客
09-07 457
本文介绍了Photoshop中图层的几种重要关系和使用技巧。主要包括：1）图层的上下层叠关系，上面图层会覆盖下面图层，可通过快捷键调整位置；2）图层对齐方式，包括水平/垂直对齐和分布；3）图层混合模式的6大分组及常用模式（如变暗组、变亮组、对比组）的原理和应用场景；4）图层合并（Ctrl+E）和盖印图层（Ctrl+Shift+E）的操作方法及注意事项。这些功能帮助用户高效管理图层，实现丰富的图像合成效果。
Photoshop - Photoshop 创建文档
weixin_52173250的博客
09-07 704
Photoshop - Photoshop 创建文档
Photoshop保存图层
qq_41807399的博客
09-08 185
本文介绍了Photoshop中保存图层和导出图层的多种方法。保存带图层的文件可通过"存储为"PSD格式或"存储副本"实现，后者能保留源文件。单独保存图层可通过右键菜单"导出为"或"快速导出为PNG"完成。批量导出图层可使用"文件-导出-将图层导出到文件"功能，其中PSD格式能完整保存图层信息，而JPG/PNG仅保留显示部分。文章还提示透明元素过多时可使用"图像-裁切"功能进行优化。这些方法
Axure PR 9 认识元器件
qq_46887726的博客
09-08 1115
本文详细介绍了Axure RP中的各类元器件及其应用方法。
泛函Φ(u)驻点的方程与边界条件 / 求给定泛函驻点满足的方程及边界条件
最新发布
weixin_30777913的博客
09-11 691
的驻点，需要求解其欧拉-拉格朗日方程并推导自然边界条件。未被指定，因此需要从泛函的变分中推导自然边界条件。，并利用积分 by parts，得到在。接下来处理边界条件。的驻点所满足的方程和边界条件，其中。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值