ID CC中文教程:初学者指南与功能详解

需积分: 10 4 下载量 2 浏览量 更新于2024-07-17 收藏 11.57MB PDF 举报
本资源是一份详细的Adobe InDesign CC 2016年6月中文用户手册,专为初学者设计,旨在帮助用户深入了解并掌握这款专业排版软件的各项功能。以下部分知识点概述: 1. **新增功能**:手册首先介绍了InDesign CC 2016的主要新增功能,让读者快速了解软件升级的重点变化。 2. **CreativeCloud**:讲解了CreativeCloud平台的概念,包括桌面应用程序的管理和同步,以及如何利用CreativeCloud Libraries管理和分享资源。 3. **GPU性能**:涉及硬件加速技巧,对于提高软件在图形处理器上的效率和性能有指导意义。 4. **创建新文档**:详细说明了如何根据需求设置文档的参数和工作流程,包括工作区的基础知识。 5. **同步与设置**:涵盖了如何通过Adobe CreativeCloud应用同步用户设置,以及个性化键盘快捷键和触控工作区的使用。 6. **工作流程调整**:从任务包到处理受管理文件,提供了一套完整的步骤来优化和调整设计工作流程。 7. **版面与设计**:涉及创建新文档、创建文本、文本框、页码、目录、书籍文件、路径文字、超链接、网格系统和文本排版等关键设计元素的操作指南。 8. **特殊功能**:如自适应版面、阿拉伯语和希伯来语支持、字形和特殊字符、拼写检查和语言词典等,满足国际化的排版需求。 9. **兼容性**:提到了与QuarkXPress和PageMaker的转换,以及针对特定语言版本(如中文、日文和韩文)的新文档创建方法。 10. **问题解决**:包括恢复和还原操作,以及如何解决可能出现的问题,如使用PageMaker菜单命令和链接内容的管理。 这份用户手册不仅适用于初次接触InDesign CC的用户,也适合希望提升技能的专业人士,全面覆盖了从基础操作到高级功能的各个层面,是学习和使用InDesign的重要参考资料。

select lot_hs.lot_id as lot_id,lot_type,lot_hs.mainpd_id, created_time,COMPLETE_TIME, value(bank.banktime,0) as banktime , round ( ( 1.00*(days(COMPLETE_TIME)-days(created_time)) + (hour(COMPLETE_TIME)-hour(created_time))*1.00/24 + (minute(COMPLETE_TIME)-minute(created_time))*1.00/24/60 + (second(COMPLETE_TIME)-second(created_time))1.00/24/60/60) - value(bank.banktime,0),3) as use_days, customer_id, coalesce(cc.cust_id_define,lot_hs.customer_id) as cust_id2, cc.cycletime_target as ct_target, date,layer, round(count() over(partition by coalesce(cc.cust_id_define,lot_hs.customer_id),cc.cycletime_target)*0.9,0) cnt, row_number() over(partition by coalesce(cc.cust_id_define,lot_hs.customer_id),cc.cycletime_target order by ( ( days(COMPLETE_TIME)-days(created_time) + (hour(COMPLETE_TIME)-hour(created_time))*1.00/24 + (minute(COMPLETE_TIME)-minute(created_time))*1.00/24/60 + (second(COMPLETE_TIME)-second(created_time))*1.00/24/60/60) - value(bank.banktime,0))/layer) id From (select date(a.claim_time) as date, a.lot_id, a.lot_type,a.mainpd_id,a.prodspec_id,a.custprod_id, case when(date(b.created_time) <= '2009-01-05') then b.created_time + 21 days else b.created_time end as created_time, CASE WHEN A.CUST_id in ('MCA','NPA','SET') THEN a.COMPLETE_TIME ELSE a.COMPLETE_TIME END COMPLETE_TIME, a.cust_id as customer_id, a.ope_category, c.layer From f3rpt.F3_TB_DAILY_FABOUT a, f3rpt.fvlot b, (select mainpd_id, sum(masks)layer from f3rpt.ASMCRPT_VW_MAINPD_MASKS_ALL group by mainpd_id) as c, (select * from (select lot_id, max(claim_time)claim_time, count(case when(ope_category='Ship')then lot_id else null end) as LS, count(case when(ope_category='Unship') then lot_id else null end) as LUS from f3rpt.F3_TB_DAILY_FABOUT where substr(lot_id,1,2) not in('CA','CW','ES','E0','EM') and lot_type = 'Production' AND LOT_ID NOT LIKE 'H%' and substr(lot_id,7,4)='.00F' and ope_category in ('Ship','Unship') and year(claim_time) = year(current date - 1 days) and month(claim_time) = month(current date - 1 days) group by lot_id) as a where LS - LUS > 0 ) as lot Where a.lot_id = b.lot_id and b.mainpd_id = c.mainpd_id and a.lot_id = lot.LOT_ID and a.claim_time = lot.claim_time and a.ope_category = 'Ship' and a.cust_id in ('SM','BOE','GSC','NPA','GTA') ) as lot_hs left outer join (select lot_id,max(bankin_time) banktime from f3rpt.asmc_dpm where bankin_time>0 group by lot_id) bank on (lot_hs.lot_id = bank.lot_id) left join f3cim.f3cim_cfg_cust_rule cc on case when lot_hs.customer_id='WXM' THEN 'WII'||SUBSTR(lot_hs.mainpd_id,6,1) else lot_hs.customer_id end = cc.cust_id and locate(cc.mainpd_id,lot_hs.mainpd_id)>0 and locate(cc.prodspec_id,lot_hs.prodspec_id)>0 and locate(cc.custprod_id_45,substr(lot_hs.custprod_id,3,3))>0 where lot_hs.ope_category = 'Ship' ;以上sql如何优化

2023-06-07 上传