2020-09-07-x

2020-09-07

todo-list

• 新产品开发系统整理在使用的模块和使用状况

record-list

• 添加两个不用绑定IP的账号，一个MacI普通用户，一个没有任何权限

-- 查询权限表中最大id的下一个id
select (max(t.id) + 1) from INDIVIDUAL_AUTH t

-- 查询专案id
select t.id from PROJECT t where t.name = 'FlowTest'

-- 查询人员id
select t.id from ACCOUNT_BROKEN t where t.account_name = 'C3006113'

-- 将工号为C3006113人员添加到FlowTest专案的权限中
insert into INDIVIDUAL_AUTH t
  (t.id, t.entity_uid, t.entitycreated, t.project_id, t.accountbroken_id)
values
  (376556, sys_guid(), sysdate, '45754', '376673')

• 给C3006113开通MacI普通用户权限，这样C3006113就是FlowTest的普通用户了

• C3005882为没有任何权限的新用户

• F1639229为管理员账号

• 整理每个模块的数据表

---

专案下模块

模块	数据表	查询语句	最近数据(专案)
客户图档	FILE_MANAGE_CUSTOMFILE	select t.* from FILE_MANAGE_CUSTOMFILE t order by t.createdate desc	C98(成都) - 2020/9/5 14:11:32
会议记录	FILE_MANAGE_TOTALS(會議記錄, BOM, 客戶重要郵件)	select t.* from FILE_MANAGE_TOTALS t where t.typeno = ‘會議記錄’ order by t.createdate desc	X1780(成都) - 2020/9/7 10:25:25
partList	FILE_PARTLIST	select t.* from FILE_PARTLIST t order by t.createdate desc	X1780(成都) - 2020/9/3 13:55:17
DOEList	FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP)	select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘DOEList’ order by t.createdate desc	X2067(成都) - 2020/6/1 8:50:11

---

阶段下模块

模块	数据表	查询语句	最近数据(专案-阶段)
BOM	FILE_MANAGE_TOTALS(會議記錄, BOM, 客戶重要郵件)	select t.* from FILE_MANAGE_TOTALS t where t.typeno = ‘BOM’ order by t.createdate desc	X1984(成都) - EVT - 2020/9/5 9:29:49
MIP	FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP)	select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘MIP’ order by t.createdate desc	X1121(成都) - 2020/8/15 13:23:16
MIL	FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP)	select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘MIL’ order by t.createdate desc	X1323(成都) - Pre-EVT - 2019/3/25 10:15:50
SOP	SOPX_BASE_INFO	select * from SOPX_BASE_INFO t order by t.create_time desc	X1780(成都) - EVT - 2020/9/5 16:32:16
标准成型条件	SMC_BASE_INFO	select * from SMC_BASE_INFO t order by t.create_time desc	X1844 - MP - 2020/9/4 17:22:51
客户重要邮件	FILE_MANAGE_TOTALS(會議記錄, BOM, 客戶重要郵件)	select t.* from FILE_MANAGE_TOTALS t where t.typeno = ‘客戶重要郵件’ order by t.createdate desc	X1433(成都) - EVT - 2019/2/27 10:00:01
Deviation List	FILE_MANAGE_TOTAL(DOEList, MIL, DeviationList, MIP)	select t.* from FILE_MANAGE_TOTAL t where t.typeno = ‘DeviationList’ order by t.createdate desc	D301 - Proto - 2019/3/4 11:11:03
Flowchart	FL_PRCSVER, FL_FPROCESS, FL_PARTFPROCESS	1. select t.* from FL_PRCSVER t order by t.createdate desc 2. select t., t.rowid from FL_FPROCESS t where t.lordprcsid = ‘AB189897B8D56A6EE050F40A5BE755C5’ 3. select t., t.rowid from FL_PARTFPROCESS t where t.p_id = ‘AB12B2B9223CAF08E050F40A5BE72D22’	MH2 - DVT - 2020/7/23 9:23:04
程式设计	PROGRAM_DESIGN_FILE	select t.* from PROGRAM_DESIGN_FILE t order by t.create_date desc	X1780(成都) - 2020/9/6 9:09:04
治具图档	MD_NEW_MOULD_MAIN	select t.*, t.rowid from MD_NEW_MOULD_MAIN t order by t.create_date desc	X2067(成都) - P1 - 2020/9/7 9:38:21

---

零件下模块

模块	数据表	查询语句	最近数据(专案-阶段-零件)
产品图档	FILE_PRODUCT_DOC	select t.* from FILE_PRODUCT_DOC t where t.create_date is not null order by t.create_date desc	X2067(成都) - POC - DWG,DH ASSY,RIB,DPOC,X2067(組立件613-16657) - 2020/9/7 9:32:11
制程图档	FILE_INFORMATION, RELATION_FILEINFO, PHASE_PART_RELATION, FILE_OBJECT	1. select cast(t.entitycreated as date) create_date, t.* from FILE_INFORMATION t order by t.entitycreated desc 2. select t., t.rowid from RELATION_FILEINFO t where t.fileinfo_id = ‘375852’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘360910’ 4. select cast(t.upload as date) create_date, t.* from FILE_OBJECT t where t.fileinfromation_id = ‘375852’	X2067(成都) - P1 - FLOW WALL,TUNNEL(塑件818-14323) - 2020/9/4 13:16:19
DFM评估	DFM_FILE	select cast(t.createtime as date) create_time, t.* from DFM_FILE t order by t.createtime desc	X1780(成都) - EVT - BV,L,5SIDED,GLUE, PLASTIC(塑件818-14025) - 2020/9/5 16:59:23
FAI/CPK评估报告	INSPECT_REPORT	1. select cast(t.entitycreated as date) create_date, t.* from INSPECT_REPORT t order by t.entitycreated desc 2. select t., t.rowid from RELATION_INSPECT_REPORT_INFO t where t.inspectreport_id = ‘284845’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘278891’	X1121(成都) - MP - X1121 RC Assembly(組立件613-13536) - 2020/3/19 13:58:45
其它检验报告	INSPECT_REPORT	1. select cast(t.entitycreated as date) create_date, t.* from INSPECT_REPORT t where t.reporttype = ‘OTH’ order by t.entitycreated desc 2. select t., t.rowid from RELATION_INSPECT_REPORT_INFO t where t.inspectreport_id = ‘39028’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘38921’	MAC-MINI - POC - test1(塑件818-04166-06) - 2018/4/11 9:58:25
Issue List	ISSUE_LIST	1. select cast(t.entitycreated as date) create_date, t.* from ISSUE_LIST t order by t.entitycreated desc 2. select t., t.rowid from RELATION_ISSUE_LIST_INFO t where t.part_issue_id = ‘155551’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘137747’	X1323(成都) - Pre-EVT - DH(金屬件806-20140) - 2019/1/18 10:29:46
包装规范	PS_APPLY_MAIN	select t.* from PS_APPLY_MAIN t order by t.create_date desc	X1780(成都) - EVT1 - ENC,THICK HSG,X1780(金屬件806-28830) - 2020/9/7 14:42:22
RoHS	ROHSINSPECT_REPORT	1. select cast(t.entitycreated as date) create_date, t.* from ROHSINSPECT_REPORT t order by t.entitycreated desc 2. select t., t.rowid from RELATION_ROHS_INSPECT t where t.rohsinspect_id = ‘284686’ 3. select t., t.rowid from PHASE_PART_RELATION t where t.id = ‘278869’	X1121(成都) - MP - DWG,ASSY,REAR COVER,ABS,X1121(組立件) - 2020/3/19 13:15:07