活动介绍

SELECT * FROM ( SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( SELECT tt.ID, tt.VIN, tt.AON, tt.MSC, tt.VEH_CLSCRQ, tt.COLOR_CODE, tt.VEH_ZCHGZBH, tt.VEH_WZHGZBH, tt.VEH_FZRQ, tt.FRIST_PRINT_DATE, tt.VEH_CLZZQYMC, tt.VEH_CLPPMC, tt.IFLOCK, tt.UP_SYNCSTATE, tt.VEH_CLXH, tt.IS_SAMPLE, ta.XNYC AS XNYC, SUBSTR( VIN, 8, 1 ) AS DLLX, T_DLLX.NAME AS DLLXNAME FROM T_VEHCERT_PRINT tt LEFT JOIN T_ALL_PARAM ta ON tt.MSC = ta.MSC LEFT JOIN T_DLLX ON SUBSTR( VIN, 8, 1 ) = T_DLLX.CODE WHERE XNYC = '否' AND IFLOCK = '0' AND UP_SYNCSTATE ='1' ORDER BY frist_print_date DESC ) TMP_PAGE WHERE ROWNUM <= '10' ) WHERE ROW_ID > '0'这段sql查询半天都查不出结果

时间: 2024-04-26 09:21:25 浏览: 154
这段 SQL 查询语句的目的是从 T_VEHCERT_PRINT 表中选择一些列,并将它们与其他表连接,然后按照 frist_print_date 字段降序排序。然后,它将结果限制为前 10 行,并为每一行分配一个 ROW_ID。最后,它选择所有 ROW_ID 大于 0 的行。 如果这段 SQL 查询半天都查不出结果,可能是因为没有符合条件的数据存在。您可以检查 WHERE 子句中的条件是否正确,并检查表中是否存在与这些条件匹配的数据。此外,您还可以查看数据库日志,以查找是否存在任何错误或异常。
相关问题

select * from ( select row_.*, rownum rownum_ from ( select * from ( select distinct OB.BUSI_ORDER_ID, 0 as HIS_ID, OB.BUSI_CODE, OB.CUST_ID, OB.CEASE_REASON, OB.ORDER_STATE, OB.CHANNEL_TYPE, ob.user_id, OB.IS_BATCH_ORDER, OB.APPLICATION_ID, OB.CREATE_DATE, OB.DONE_DATE, OB.EFF_DATE, OB.EXP_DATE, OB.OPER_ID, OB.ORG_ID, OB.REGION_ID, OB.NOTE, OB.PROCESS_STATE, nvl(oi.cust_name, ic.cust_name) cust_name, nvl(oc.icc_id, iu.icc_id) icc_id, nvl(oc.svc_num, iu.svc_num) svc_num, icp.cust_name parent_cust_name, icp.cust_id parent_cust_id, ol.order_list_id from ord_busi ob left join ord_offer oo on oo.busi_order_id = ob.busi_order_id and ob.user_id = oo.user_id left join info_user iu on oo.user_id = iu.user_id left join info_cust ic on ob.cust_id = ic.cust_id left join ord_cust oi on ob.cust_id = oi.cust_id and ob.busi_order_id = oi.busi_order_id left join info_cust icp on nvl(ic.parent_cust_id, oi.parent_cust_id) = icp.cust_id left join ( SELECT * FROM ord_user WHERE user_order_id IN ( SELECT MAX(user_order_id) user_order_id FROM ord_user GROUP BY busi_order_id,user_id ) ) oc on ob.user_id = oc.user_id and ob.busi_order_id = oc.busi_order_id left join ord_list ol on ob.busi_order_id = ol.busi_order_id WHERE 1 = 1 and OB.CUST_ID IN( SELECT DISTINCT CUST_ID FROM (SELECT CUST_ID, PARENT_CUST_ID FROM INFO_CUST UNION SELECT CUST_ID, PARENT_CUST_ID FROM ORD_CUST) TMP START WITH TMP.CUST_ID = '10001009208' CONNECT BY TMP.PARENT_CUST_ID = PRIOR TMP.CUST_ID ) union all select distinct OB.BUSI_ORDER_ID,OB.HIS_ID, OB.BUSI_CODE, OB.CUST_ID, OB.CEASE_REASON, OB.ORDER_STATE, OB.CHANNEL_TYPE, OB.USER_ID, OB.IS_BATCH_ORDER, OB.APPLICATION_ID, OB.CREATE_DATE, OB.DONE_DATE, OB.EFF_DATE, OB.EXP_DATE, OB.OPER_ID, OB.ORG_ID, OB.REGION_ID, OB.NOTE, OB.PROCESS_STATE, nvl(oi.cust_name,ic.cust_name) cust_name , nvl(oc.icc_id, iu.icc_id) icc_id, nvl(oc.svc_num,iu.svc_num) svc_num, icp.cust_name parent_cust_name, icp.cust_id parent_cust_id, ol.order_list_id from ord_busi_his ob left join ord_offer_his oo on oo.busi_order_id = ob.busi_order_id 优化一下

可以考虑以下优化方式: 1. 使用INNER JOIN代替LEFT JOIN:如果确保两个表中都含有匹配的行,则使用INNER JOIN可以提高查询效率。 2. 使用EXISTS代替IN:EXISTS执行速度比IN更快,因为它只需要找到匹配的第一个结果,而不是找到所有匹配的结果。 3. 简化子查询:在查询中可以尝试简化子查询,以减少查询的复杂度。 4. 使用索引:使用索引可以提高查询效率,可以根据查询中经常使用的列添加索引。 5. 避免使用SELECT *:只查询需要的列,避免使用SELECT *可以减少查询的复杂度,提高查询效率。

SELECT '155427848241370' || SEQ_KD_INDEX.nextval || 'GJ', a.PROBABLECAUSE, ( SELECT zhFUNc_GETNEWIDFORCIR ( id ) FROM gistar.tdn_switch ch WHERE ch.ipaddress = a.IP AND ROWNUM = 1 ), '1028200001', ( SELECT name FROM gistar.tdn_switch ch WHERE ch.ipaddress = a.IP AND ROWNUM = 1 ), ( SELECT code FROM gistar.tdn_switch ch WHERE ch.ipaddress = a.IP AND ROWNUM = 1 ), a.IP, a.ALARMTIME, a.alarmtext, SYSDATE, NULL, a.alarmid, a.createtime, a.perceivedseverity, a.moname FROM ( SELECT x.*, ( SELECT COUNT( DISTINCT re.coveraddressid ) FROM gistar.jr_customer_record @yjyx_zy re WHERE re.project_type IN ( 'FTTH宽带' ) AND re.oltip = x.IP ) AS oltcount FROM gistar.t_trouble_alarminfo x ) a WHERE a.specialty = 'PON' AND a.motype = 'OLT' AND IP IS NOT NULL AND a.PROBABLECAUSE = 'OLT网管脱网' AND ( SELECT substr( b.tt_number, 0, 2 ) FROM fwbz.t_trouble_ticket_new @GDOSSDB_SGDD b WHERE a.tt_id = b.tt_id ) = 'NM' AND ( SELECT title FROM fwbz.t_trouble_ticket_new @GDOSSDB_SGDD b WHERE a.tt_id = b.tt_id ) = 'OLT网管脱网' AND ( ( SYSDATE < '2021-05-01' AND a.oltcount >= 600 ) OR a.oltcount >= 400 ) UNION ALL SELECT '155427848241370' || SEQ_KD_INDEX.nextval || 'GJ', a.PROBABLECAUSE, ( SELECT zhFUNc_GETNEWIDFORCIR ( id ) FROM gistar.tdn_switch ch WHERE ch.ipaddress = a.IP AND ROWNUM = 1 ), '1028200001', ( SELECT name FROM gistar.tdn_switch ch WHERE ch.ipaddress = a.IP AND ROWNUM = 1 ), ( SELECT code FROM gistar.tdn_switch ch WHERE ch.ipaddress = a.IP AND ROWNUM = 1 ), a.IP, a.ALARMTIME, a.alarmtext, SYSDATE, a.cleartime, a.alarmid, a.createtime, a.perceivedseverity, a.moname FROM ( SELECT x.*, ( SELECT COUNT( DISTINCT re.coveraddressid ) FROM gistar.jr_customer_record @yjyx_zy re WHERE re.project_type IN ( 'FTTH宽带' ) AND re.oltip = x.IP ) AS oltcount FROM gistar.t_trouble_alarminfo x ) a WHERE a.specialty = 'PON' AND a.motype = 'OLT' AND IP IS NOT NULL AND a.PROBABLECAUSE = 'OLT网管脱网' AND ( SELECT substr( b.tt_number, 0, 2 ) FROM fwbz.t_trouble_ticket_new @GDOSSDB_SGDD b WHERE a.tt_id = b.tt_id ) = 'NM' AND ( SELECT title FROM fwbz.t_trouble_ticket_new @GDOSSDB_SGDD b WHERE a.tt_id = b.tt_id ) = 'OLT网管脱网' AND ( ( SYSDATE < '2021-05-01' AND a.oltcount >= 600 ) OR a.oltcount >= 400 ) AND a.cleartime IS NOT NULL AND a.alarmid IN ( SELECT alarm_id FROM olt_ALARM_BILL GROUP BY alarm_id, device_ip, alarm_time, create_time HAVING count( * ) = 1 );报错ORA-02287: sequence number not allowed here

这个 SQL 语句中使用了 SEQ_KD_INDEX.nextval,而在 SELECT 语句中不能直接使用序列的 nextval() 方法,因为 nextval() 方法不是一个常量或字面值,而是一个函数,因此不能在字符串中直接使用。要解决这个问题,可以将 nextval() 放在一个子查询中,然后在 SELECT 语句中引用该子查询的结果。例如,可以将第一个 SELECT 语句修改如下: ``` SELECT '155427848241370' || (SELECT SEQ_KD_INDEX.nextval FROM dual) || 'GJ', a.PROBABLECAUSE, ... ``` 这样就可以在字符串中引用 nextval() 方法的返回值了。注意,这里使用了 Oracle 中的 dual 表来执行子查询,因为在 Oracle 中,必须使用 FROM 子句来指定一个表,即使这个表只包含一行数据也是如此。
阅读全文

相关推荐

下面是一段完整的AE code,请协助进行优化 /*=========================================/ 任务编号: 说 明: 人员分析报表(优化版) 作 者: 日 期: 2025-07-11 /=========================================*/ /* 声明变量 */ Local JavaObject &reportDefn, &reportRow, &reportRow2; Local number &rowNum, &processInstance, &bColIndex, &count0, &avgCount; Local string &oprid, &runCntlID, &c_gp_rptID, &start, &end, &reportTitle, &FilePath; Local string &aColValue, &bColValue, &prevAColValue, &Start_Dt, &End_Dt, &aColCode, &bColCode; Local SQL &sqlACol, &sqlBCol, &sqlData; Local array of string &bColData, &bColCodes, &aColCodes, &aColValues; Local array of number &monthStartDates, &monthEndDates; /* 初始化变量 */ &processInstance = C_GPANA_AET.PROCESS_INSTANCE.Value; &oprid = C_GPANA_AET.OPRID.Value; &runCntlID = C_GPANA_AET.RUN_CNTL_ID.Value; &c_gp_rptID = C_GPANA_AET.C_GP_RPT_ID.Value; &start = C_GPANA_AET.C_CAL_PRD_ID_BGN.Value; &end = C_GPANA_AET.C_CAL_PRD_ID_END.Value; /* 检查是否有B类操作 */ SQLExec("SELECT COUNT(*) FROM PS_C_GPANA_RPT_OP OP WHERE OP.C_GP_RPT_ID = :1 AND OP.C_GPANA_OPRID = 'B'", &c_gp_rptID, &count); If &count > 0 Then /* 获取期间1-12月 开始、结束日期 */ SQLExec("SELECT A.c_yearcd FROM PS_C_FRZ_CAL_VW A WHERE A.Cal_Prd_Id=:1", &start, &c_yearcd); SQLExec(SQL.C_1_12_GPANA_SQL, &c_yearcd, &start_1, &end_1, &start_2, &end_2, &start_3, &end_3, &start_4, &end_4, &start_5, &end_5, &start_6, &end_6, &start_7, &end_7, &start_8, &end_8, &start_9, &end_9, &start_10, &end_10, &start_11, &end_11, &start_12, &end_12); &reportTitle = "人员分析报表"; &rowNum = 3; /* 数据从第3行开始 */ &prevAColValue = ""; /* 1. 创建报表对象 */ &reportDefn = CreateJavaObject("com.cust.common.poi.ReportDefinition"); &reportDefn.AddSheet(&reportTitle); /* 2. 添加复杂表头行 - 优化为循环生成 */ /* 第一行表头 */ &reportRow = CreateJavaObject("com.cust.common.poi.ReportRow"); &reportRow.addString("组织范围"); /* A1 */ &reportRow.addString("人员类别"); /* B1 */ &reportRow.addString("年度累计"); /* C1-I1 */ /* 添加7个空单元格对应C1-I1 */ For &i = 1 To 6 &reportRow.addString(""); End-For; /* 循环添加12个月的表头 */ For &month = 1 To 12 &reportRow.addString(&month | "月"); /* 月份标题 */ /* 添加6个空单元格 */ For &i = 1 To 6 &reportRow.addString(""); End-For; End-For; &reportDefn.addRow(&reportRow); /* 第二行表头 */ &reportRow2 = CreateJavaObject("com.cust.common.poi.ReportRow"); &reportRow2.addString(""); /* A2 */ &reportRow2.addString(""); /* B2 */ /* 年度累计列标题 */ &reportRow2.addString("年度平均人数"); &reportRow2.addString("期初人数"); &reportRow2.addString("累计新增:新入职人数"); &reportRow2.addString("累计新增:调入人数"); &reportRow2.addString("累计减少:离职人数"); &reportRow2.addString("累计减少:调出人数"); &reportRow2.addString("期末人数"); /* 循环添加12个月的详细列标题 */ For &month = 1 To 12 &reportRow2.addString("月度平均人数"); &reportRow2.addString("月初人数"); &reportRow2.addString("本月新增:新入职人数"); &reportRow2.addString("本月新增:调入人数"); &reportRow2.addString("本月减少:离职人数"); &reportRow2.addString("本月减少:调出人数"); &reportRow2.addString("月末人数"); End-For; &reportDefn.addRow(&reportRow2); /* 合并表头单元格 */ /* 合并A1:A2 */ &reportDefn.mergeCells(0, 1, 0, 0); /* 合并B1:B2 */ &reportDefn.mergeCells(0, 1, 1, 1); /* 合并C1:I1 */ &reportDefn.mergeCells(0, 0, 2, 8); /* 合并各月份标题 */ For &month = 0 To 11 &startCol = 9 + (&month * 7); &endCol = &startCol + 6; &reportDefn.mergeCells(0, 0, &startCol, &endCol); End-For; /* 3. 获取B列所有数据 */ &sqlBCol = CreateSQL("SELECT OP.DESCR, OP.DESCR1 FROM PS_C_GPANA_RPT_OP OP WHERE OP.C_GP_RPT_ID = :1", &c_gp_rptID); &bColData = CreateArrayRept("", 0); &bColCodes = CreateArrayRept("", 0); While &sqlBCol.Fetch(&bColValue, &bColCode) &bColData.Push(&bColValue); &bColCodes.Push(&bColCode); End-While; &sqlBCol.Close(); /* 4. 处理A列数据并填充动态数据 */ &sqlACol = CreateSQL("SELECT L1.DESCR100, L1.SEQNBR FROM PS_C_GPANA_RPT_L1 L1 WHERE L1.C_GP_RPT_ID = :1", &c_gp_rptID); &aColValues = CreateArrayRept("", 0); &aColCodes = CreateArrayRept("", 0); /* 先获取所有A列数据 */ While &sqlACol.Fetch(&aColValue, &aColCode) &aColValues.Push(&aColValue); &aColCodes.Push(&aColCode); End-While; &sqlACol.Close(); /* 处理每行数据 */ For &aIndex = 1 To &aColValues.Len &aColValue = &aColValues [&aIndex]; &aColCode = &aColCodes [&aIndex]; /* 对每个A列值,循环所有B列值 */ For &bIndex = 1 To &bColData.Len /* 创建新行 */ &reportRow = CreateJavaObject("com.cust.common.poi.ReportRow"); /* A列处理(合并效果) */ If &aColValue = &prevAColValue Then &reportRow.addString(""); /* A列留空(模拟合并效果)*/ Else &reportRow.addString(&aColValue); /* A列填入值 */ End-If; /* B列值 */ &reportRow.addString(&bColData [&bIndex]); /* 根据A列和B列值获取动态数据 */ &bColCode = &bColCodes [&bIndex]; /* 年度累计数据 &avgCount-6*/ &reportRow.addString(String(&avgCount)); /* 年度累计数据 - C2:年度平均人数 */ &reportRow.addString(String(&avgCount1)); /* 年度累计数据 - 期初人数 */ &reportRow.addString(String(&avgCount2)); /* 累计新增:新入职人数*/ &reportRow.addString(String(&avgCount3)); /* 累计新增:调入人数*/ &reportRow.addString(String(&avgCount4)); /* 累计减少:离职人数 */ &reportRow.addString(String(&avgCount5)); /* 累计减少:调出人数*/ &reportRow.addString(String(&avgCount6)); /* 期末人数*/ /* 1月数据 &janCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_1, &janCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_1, &end_1, &janCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_1, &end_1, &janCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_1, &end_1, &janCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_1, &janCount6); &janCount = Round((&janCount1 + &janCount6) / 2.0, 0); &reportRow.addString(String(&janCount)); /* 月度平均人数 */ &reportRow.addString(String(&janCount1)); /* 月初人数 */ &reportRow.addString(String(&janCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&janCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&janCount4)); /* 本月减少:离职人数 */ &janCount5 = Abs(&janCount6 - &janCount1 - &janCount2 - &janCount3 - &janCount4); &reportRow.addString(String(&janCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&janCount6)); /* 月末人数 */ /* 2月数据 &febCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_2, &febCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_2, &end_2, &febCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_2, &end_2, &febCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_2, &end_2, &febCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_2, &febCount6); &febCount = Round((&febCount1 + &febCount6) / 2.0, 0); &reportRow.addString(String(&febCount)); /* 月度平均人数 */ &reportRow.addString(String(&febCount1)); /* 月初人数 */ &reportRow.addString(String(&febCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&febCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&febCount4)); /* 本月减少:离职人数 */ &febCount5 = Abs(&febCount6 - &febCount1 - &febCount2 - &febCount3 - &febCount4); &reportRow.addString(String(&febCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&febCount6)); /* 月末人数 */ /* 3月数据 &marCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_3, &marCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_3, &end_3, &marCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_3, &end_3, &marCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_3, &end_3, &marCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_3, &marCount6); &marCount = Round((&marCount1 + &marCount6) / 2.0, 0); &reportRow.addString(String(&marCount)); /* 月度平均人数 */ &reportRow.addString(String(&marCount1)); /* 月初人数 */ &reportRow.addString(String(&marCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&marCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&marCount4)); /* 本月减少:离职人数 */ &marCount5 = Abs(&marCount6 - &marCount1 - &marCount2 - &marCount3 - &marCount4); &reportRow.addString(String(&marCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&marCount6)); /* 月末人数 */ /* 4月数据 &aprCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_4, &aprCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_4, &end_4, &aprCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_4, &end_4, &aprCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_4, &end_4, &aprCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_4, &aprCount6); &aprCount = Round((&aprCount1 + &aprCount6) / 2.0, 0); &reportRow.addString(String(&aprCount)); /* 月度平均人数 */ &reportRow.addString(String(&aprCount1)); /* 月初人数 */ &reportRow.addString(String(&aprCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&aprCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&aprCount4)); /* 本月减少:离职人数 */ &aprCount5 = Abs(&aprCount6 - &aprCount1 - &aprCount2 - &aprCount3 - &aprCount4); &reportRow.addString(String(&aprCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&aprCount6)); /* 月末人数 */ /* 5月数据 &mayCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_5, &mayCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_5, &end_5, &mayCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_5, &end_5, &mayCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_5, &end_5, &mayCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_5, &mayCount6); &mayCount = Round((&mayCount1 + &mayCount6) / 2.0, 0); &reportRow.addString(String(&mayCount)); /* 月度平均人数 */ &reportRow.addString(String(&mayCount1)); /* 月初人数 */ &reportRow.addString(String(&mayCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&mayCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&mayCount4)); /* 本月减少:离职人数 */ &mayCount5 = Abs(&mayCount6 - &mayCount1 - &mayCount2 - &mayCount3 - &mayCount4); &reportRow.addString(String(&mayCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&mayCount6)); /* 月末人数 */ /* 6月数据 &junCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_6, &junCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_6, &end_6, &junCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_6, &end_6, &junCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_6, &end_6, &junCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_6, &junCount6); &junCount = Round((&junCount1 + &junCount6) / 2.0, 0); &reportRow.addString(String(&junCount)); /* 月度平均人数 */ &reportRow.addString(String(&junCount1)); /* 月初人数 */ &reportRow.addString(String(&junCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&junCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&junCount4)); /* 本月减少:离职人数 */ &junCount5 = Abs(&junCount6 - &junCount1 - &junCount2 - &junCount3 - &junCount4); &reportRow.addString(String(&junCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&junCount6)); /* 月末人数 */ /* 7月数据 &julCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_7, &julCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_7, &end_7, &julCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_7, &end_7, &julCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_7, &end_7, &julCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_7, &julCount6); &julCount = Round((&julCount1 + &julCount6) / 2.0, 0); &reportRow.addString(String(&julCount)); /* 月度平均人数 */ &reportRow.addString(String(&julCount1)); /* 月初人数 */ &reportRow.addString(String(&julCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&julCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&julCount4)); /* 本月减少:离职人数 */ &julCount5 = Abs(&julCount6 - &julCount1 - &julCount2 - &julCount3 - &julCount4); &reportRow.addString(String(&julCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&julCount6)); /* 月末人数 */ /* 8月数据 &augCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_8, &augCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_8, &end_8, &augCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_8, &end_8, &augCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_8, &end_8, &augCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_8, &augCount6); &augCount = Round((&augCount1 + &augCount6) / 2.0, 0); &reportRow.addString(String(&augCount)); /* 月度平均人数 */ &reportRow.addString(String(&augCount1)); /* 月初人数 */ &reportRow.addString(String(&augCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&augCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&augCount4)); /* 本月减少:离职人数 */ &augCount5 = Abs(&augCount6 - &augCount1 - &augCount2 - &augCount3 - &augCount4); &reportRow.addString(String(&augCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&augCount6)); /* 月末人数 */ /* 9月数据 &sepCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_9, &sepCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_9, &end_9, &sepCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_9, &end_9, &sepCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_9, &end_9, &sepCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_9, &sepCount6); &sepCount = Round((&sepCount1 + &sepCount6) / 2.0, 0); &reportRow.addString(String(&sepCount)); /* 月度平均人数 */ &reportRow.addString(String(&sepCount1)); /* 月初人数 */ &reportRow.addString(String(&sepCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&sepCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&sepCount4)); /* 本月减少:离职人数 */ &sepCount5 = Abs(&sepCount6 - &sepCount1 - &sepCount2 - &sepCount3 - &sepCount4); &reportRow.addString(String(&sepCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&sepCount6)); /* 月末人数 */ /* 10月数据 &octCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_10, &octCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_10, &end_10, &octCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_10, &end_10, &octCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_10, &end_10, &octCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_10, &octCount6); &octCount = Round((&octCount1 + &octCount6) / 2.0, 0); &reportRow.addString(String(&octCount)); /* 月度平均人数 */ &reportRow.addString(String(&octCount1)); /* 月初人数 */ &reportRow.addString(String(&octCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&octCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&octCount4)); /* 本月减少:离职人数 */ &octCount5 = Abs(&octCount6 - &octCount1 - &octCount2 - &octCount3 - &octCount4); &reportRow.addString(String(&octCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&octCount6)); /* 月末人数 */ /* 11月数据 &novCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_11, &novCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_11, &end_11, &novCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_11, &end_11, &novCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_11, &end_11, &novCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_11, &novCount6); &novCount = Round((&novCount1 + &novCount6) / 2.0, 0); &reportRow.addString(String(&novCount)); /* 月度平均人数 */ &reportRow.addString(String(&novCount1)); /* 月初人数 */ &reportRow.addString(String(&novCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&novCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&novCount4)); /* 本月减少:离职人数 */ &novCount5 = Abs(&novCount6 - &novCount1 - &novCount2 - &novCount3 - &novCount4); &reportRow.addString(String(&novCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&novCount6)); /* 月末人数 */ /* 12月数据 &decCount-6*/ /* 月初人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_12, &decCount1); /* 本月新增:新入职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('HIR','REH') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_12, &end_12, &decCount2); /* 本月新增:调入人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION ='XFR' AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_12, &end_12, &decCount3); /* 本月减少:离职人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.ACTION IN ('TER','RET') AND J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT <=:4 AND J.EFFDT >=:3 AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &start_12, &end_12, &decCount4); /* 月末人数 */ SQLExec("SELECT COUNT(*) FROM PS_JOB J WHERE J.HR_STATUS = 'A' AND J.EMPL_RCD = '0' AND J.EFFSEQ = '0' AND J.Empl_Class IN (" | &bColCode | ") AND J.EFFDT = (SELECT MAX(J2.EFFDT) FROM PS_JOB J2 WHERE J2.EMPLID = J.EMPLID AND J2.EMPL_RCD = J.EMPL_RCD AND J2.EFFDT <=:3) AND j.deptid IN (SELECT T.tree_node_child FROM PS_C_DEPT_TREE_VWA T ,PS_C_GPANA_RPT_L2 A WHERE A.C_GP_RPT_ID = :1 AND A.SEQNBR = :2 AND T.SETID = A.BUSINESS_UNIT AND T.TREE_NODE = A.DEPTID AND T.effdt = (SELECT MAX(T1.EFFDT) FROM PS_C_DEPT_TREE_VWA T1 WHERE T1.setid = T.setid AND T1.effdt <= :3) )", &c_gp_rptID, &aColCode, &end_12, &decCount6); &decCount = Round((&decCount1 + &decCount6) / 2.0, 0); &reportRow.addString(String(&decCount)); /* 月度平均人数 */ &reportRow.addString(String(&decCount1)); /* 月初人数 */ &reportRow.addString(String(&decCount2)); /* 本月新增:新入职人数 */ &reportRow.addString(String(&decCount3)); /* 本月新增:调入人数 */ &reportRow.addString(String(&decCount4)); /* 本月减少:离职人数 */ &decCount5 = Abs(&decCount6 - &decCount1 - &decCount2 - &decCount3 - &decCount4); &reportRow.addString(String(&decCount5)); /* 本月减少:调出人数 */ &reportRow.addString(String(&decCount6)); /* 月末人数 */ &reportDefn.addRow(&reportRow); &prevAColValue = &aColValue; &rowNum = &rowNum + 1; End-For; End-For; /* 5. 生成并保存Excel文件 */ &reportDefn.prepareExcel(); &FilePath = %FilePath | &reportTitle | "_" | &processInstance | "_" | %Date | ".xlsx"; &reportDefn.buildExcel(&FilePath); End-If;

最新推荐

recommend-type

langchain4j-anthropic-spring-boot-starter-0.31.0.jar中文文档.zip

1、压缩文件中包含: 中文文档、jar包下载地址、Maven依赖、Gradle依赖、源代码下载地址。 2、使用方法: 解压最外层zip,再解压其中的zip包,双击 【index.html】 文件,即可用浏览器打开、进行查看。 3、特殊说明: (1)本文档为人性化翻译,精心制作,请放心使用; (2)只翻译了该翻译的内容,如:注释、说明、描述、用法讲解 等; (3)不该翻译的内容保持原样,如:类名、方法名、包名、类型、关键字、代码 等。 4、温馨提示: (1)为了防止解压后路径太长导致浏览器无法打开,推荐在解压时选择“解压到当前文件夹”(放心,自带文件夹,文件不会散落一地); (2)有时,一套Java组件会有多个jar,所以在下载前,请仔细阅读本篇描述,以确保这就是你需要的文件。 5、本文件关键字: jar中文文档.zip,java,jar包,Maven,第三方jar包,组件,开源组件,第三方组件,Gradle,中文API文档,手册,开发手册,使用手册,参考手册。
recommend-type

TMS320F28335电机控制程序详解:BLDC、PMSM无感有感及异步VF源代码与开发资料

TMS320F28335这款高性能数字信号处理器(DSP)在电机控制领域的应用,涵盖了BLDC(无刷直流电机)、PMSM(永磁同步电机)的无感有感控制以及异步VF(变频调速)程序。文章不仅解释了各类型的电机控制原理,还提供了完整的开发资料,包括源代码、原理图和说明文档,帮助读者深入了解其工作原理和编程技巧。 适合人群:从事电机控制系统开发的技术人员,尤其是对TMS320F28335感兴趣的工程师。 使用场景及目标:适用于需要掌握TMS320F28335在不同电机控制应用场景下具体实现方法的专业人士,旨在提高他们对该微控制器的理解和实际操作能力。 其他说明:文中提供的开发资料为读者提供了从硬件到软件的全面支持,有助于加速项目开发进程并提升系统性能。
recommend-type

Visual C++.NET编程技术实战指南

根据提供的文件信息,可以生成以下知识点: ### Visual C++.NET编程技术体验 #### 第2章 定制窗口 - **设置窗口风格**:介绍了如何通过编程自定义窗口的外观和行为。包括改变窗口的标题栏、边框样式、大小和位置等。这通常涉及到Windows API中的`SetWindowLong`和`SetClassLong`函数。 - **创建六边形窗口**:展示了如何创建一个具有特殊形状边界的窗口,这类窗口不遵循标准的矩形形状。它需要使用`SetWindowRgn`函数设置窗口的区域。 - **创建异形窗口**:扩展了定制窗口的内容,提供了创建非标准形状窗口的方法。这可能需要创建一个不规则的窗口区域,并将其应用到窗口上。 #### 第3章 菜单和控制条高级应用 - **菜单编程**:讲解了如何创建和修改菜单项,处理用户与菜单的交互事件,以及动态地添加或删除菜单项。 - **工具栏编程**:阐述了如何使用工具栏,包括如何创建工具栏按钮、分配事件处理函数,并实现工具栏按钮的响应逻辑。 - **状态栏编程**:介绍了状态栏的创建、添加不同类型的指示器(如文本、进度条等)以及状态信息的显示更新。 - **为工具栏添加皮肤**:展示了如何为工具栏提供更加丰富的视觉效果,通常涉及到第三方的控件库或是自定义的绘图代码。 #### 第5章 系统编程 - **操作注册表**:解释了Windows注册表的结构和如何通过程序对其进行读写操作,这对于配置软件和管理软件设置非常关键。 - **系统托盘编程**:讲解了如何在系统托盘区域创建图标,并实现最小化到托盘、从托盘恢复窗口的功能。 - **鼠标钩子程序**:介绍了钩子(Hook)技术,特别是鼠标钩子,如何拦截和处理系统中的鼠标事件。 - **文件分割器**:提供了如何将文件分割成多个部分,并且能够重新组合文件的技术示例。 #### 第6章 多文档/多视图编程 - **单文档多视**:展示了如何在同一个文档中创建多个视图,这在文档编辑软件中非常常见。 #### 第7章 对话框高级应用 - **实现无模式对话框**:介绍了无模式对话框的概念及其应用场景,以及如何实现和管理无模式对话框。 - **使用模式属性表及向导属性表**:讲解了属性表的创建和使用方法,以及如何通过向导性质的对话框引导用户完成多步骤的任务。 - **鼠标敏感文字**:提供了如何实现点击文字触发特定事件的功能,这在阅读器和编辑器应用中很有用。 #### 第8章 GDI+图形编程 - **图像浏览器**:通过图像浏览器示例,展示了GDI+在图像处理和展示中的应用,包括图像的加载、显示以及基本的图像操作。 #### 第9章 多线程编程 - **使用全局变量通信**:介绍了在多线程环境下使用全局变量进行线程间通信的方法和注意事项。 - **使用Windows消息通信**:讲解了通过消息队列在不同线程间传递信息的技术,包括发送消息和处理消息。 - **使用CriticalSection对象**:阐述了如何使用临界区(CriticalSection)对象防止多个线程同时访问同一资源。 - **使用Mutex对象**:介绍了互斥锁(Mutex)的使用,用以同步线程对共享资源的访问,保证资源的安全。 - **使用Semaphore对象**:解释了信号量(Semaphore)对象的使用,它允许一个资源由指定数量的线程同时访问。 #### 第10章 DLL编程 - **创建和使用Win32 DLL**:介绍了如何创建和链接Win32动态链接库(DLL),以及如何在其他程序中使用这些DLL。 - **创建和使用MFC DLL**:详细说明了如何创建和使用基于MFC的动态链接库,适用于需要使用MFC类库的场景。 #### 第11章 ATL编程 - **简单的非属性化ATL项目**:讲解了ATL(Active Template Library)的基础使用方法,创建一个不使用属性化组件的简单项目。 - **使用ATL开发COM组件**:详细阐述了使用ATL开发COM组件的步骤,包括创建接口、实现类以及注册组件。 #### 第12章 STL编程 - **list编程**:介绍了STL(标准模板库)中的list容器的使用,讲解了如何使用list实现复杂数据结构的管理。 #### 第13章 网络编程 - **网上聊天应用程序**:提供了实现基本聊天功能的示例代码,包括客户端和服务器的通信逻辑。 - **简单的网页浏览器**:演示了如何创建一个简单的Web浏览器程序,涉及到网络通信和HTML解析。 - **ISAPI服务器扩展编程**:介绍了如何开发ISAPI(Internet Server API)服务器扩展来扩展IIS(Internet Information Services)的功能。 #### 第14章 数据库编程 - **ODBC数据库编程**:解释了ODBC(开放数据库互联)的概念,并提供了使用ODBC API进行数据库访问的示例。 - **ADO编程**:介绍了ADO(ActiveX Data Objects)技术,讲解了如何使用ADO进行数据库的增删改查等操作。 #### 第15章 HTML帮助系统编程 - **创建HTML帮助文件**:讲解了如何创建HTML帮助文件(.chm),这是微软帮助系统的一种形式。 - **区分上下文帮助**:提供了在应用程序中实现上下文敏感帮助的技术示例。 #### 第16章 安装和部署项目 - **用安装程序向导创建安装项目**:介绍了如何使用Visual Studio中的安装和部署项目向导,快速创建安装程序。 - **部署应用程序**:阐述了部署应用程序到目标系统的过程,以及如何确保应用程序的正确安装和运行。 以上内容涵盖了Visual C++.NET编程技术体验一书中涉及的各个技术点,并对每个章节中的示例做了详细的说明。这些知识点对于理解和掌握Visual C++.NET编程非常重要,并能够帮助读者在实际项目开发中应用这些技术。
recommend-type

HarmonyOS内核深度探秘:优化自由行旅游系统的策略

# 1. HarmonyOS内核概述与旅游系统需求分析 ## 1.1 HarmonyOS内核概述 HarmonyOS(鸿蒙操作系统)是由华为开发的一个分布式操作系统,旨在提供跨多种设备的无缝体验。其内核设计理念强调高效、安全和模块化,以微内核架构和分布式能力
recommend-type

tkinter模块所有控件

<think>好的,我现在需要回答用户关于Tkinter模块中所有控件列表的问题。首先,我需要回忆Tkinter的基础知识,确保自己了解各个控件的名称和用途。用户希望得到所有支持的控件列表,所以必须全面覆盖,不能遗漏。 首先,我应该从Tkinter的标准控件开始。常见的控件包括Label、Button、Entry这些基础部件。然后是Frame,用于布局,还有Canvas用于绘图。接下来是Checkbutton、Radiobutton,这些属于选择类控件。Listbox和Scrollbar通常一起使用,处理滚动内容。还有Scale(滑块)、Spinbox、Menu、Menubutton这些可能
recommend-type

局域网五子棋游戏:娱乐与聊天的完美结合

标题“网络五子棋”和描述“适合于局域网之间娱乐和聊天!”以及标签“五子棋 网络”所涉及的知识点主要围绕着五子棋游戏的网络版本及其在局域网中的应用。以下是详细的知识点: 1. 五子棋游戏概述: 五子棋是一种两人对弈的纯策略型棋类游戏,又称为连珠、五子连线等。游戏的目标是在一个15x15的棋盘上,通过先后放置黑白棋子,使得任意一方先形成连续五个同色棋子的一方获胜。五子棋的规则简单,但策略丰富,适合各年龄段的玩家。 2. 网络五子棋的意义: 网络五子棋是指可以在互联网或局域网中连接进行对弈的五子棋游戏版本。通过网络版本,玩家不必在同一地点即可进行游戏,突破了空间限制,满足了现代人们快节奏生活的需求,同时也为玩家们提供了与不同对手切磋交流的机会。 3. 局域网通信原理: 局域网(Local Area Network,LAN)是一种覆盖较小范围如家庭、学校、实验室或单一建筑内的计算机网络。它通过有线或无线的方式连接网络内的设备,允许用户共享资源如打印机和文件,以及进行游戏和通信。局域网内的计算机之间可以通过网络协议进行通信。 4. 网络五子棋的工作方式: 在局域网中玩五子棋,通常需要一个客户端程序(如五子棋.exe)和一个服务器程序。客户端负责显示游戏界面、接受用户输入、发送落子请求给服务器,而服务器负责维护游戏状态、处理玩家的游戏逻辑和落子请求。当一方玩家落子时,客户端将该信息发送到服务器,服务器确认无误后将更新后的棋盘状态传回给所有客户端,更新显示。 5. 五子棋.exe程序: 五子棋.exe是一个可执行程序,它使得用户可以在个人计算机上安装并运行五子棋游戏。该程序可能包含了游戏的图形界面、人工智能算法(如果支持单机对战AI的话)、网络通信模块以及游戏规则的实现。 6. put.wav文件: put.wav是一个声音文件,很可能用于在游戏进行时提供声音反馈,比如落子声。在网络环境中,声音文件可能被用于提升玩家的游戏体验,尤其是在局域网多人游戏场景中。当玩家落子时,系统会播放.wav文件中的声音,为游戏增添互动性和趣味性。 7. 网络五子棋的技术要求: 为了确保多人在线游戏的顺利进行,网络五子棋需要具备一些基本的技术要求,包括但不限于稳定的网络连接、高效的数据传输协议(如TCP/IP)、以及安全的数据加密措施(如果需要的话)。此外,还需要有一个良好的用户界面设计来提供直观和舒适的用户体验。 8. 社交与娱乐: 网络五子棋除了是一个娱乐游戏外,它还具有社交功能。玩家可以通过游戏内的聊天系统进行交流,分享经验和策略,甚至通过网络寻找新的朋友。这使得网络五子棋不仅是一个个人娱乐工具,同时也是一种社交活动。 总结来说,网络五子棋结合了五子棋游戏的传统魅力和现代网络技术,使得不同地区的玩家能够在局域网内进行娱乐和聊天,既丰富了人们的娱乐生活,又加强了人际交流。而实现这一切的基础在于客户端程序的设计、服务器端的稳定运行、局域网的高效通信,以及音效文件增强的游戏体验。
recommend-type

自由行旅游新篇章:HarmonyOS技术融合与系统架构深度解析

# 1. HarmonyOS技术概述 ## 1.1 HarmonyOS的起源与发展 HarmonyOS(鸿蒙操作系统)由华为公司开发,旨在构建全场景分布式OS,以应对不同设备间的互联问题。自从2019年首次发布以来,HarmonyOS迅速成长,并迅速应用于智能手机、平板、智能穿戴、车载设备等多种平台。该系
recommend-type

足底支撑相到达73%是什么问题

<think>好的,我现在要处理用户的问题:“足底支撑相达到73%可能的原因及影响”。首先,需要理解用户提到的“足底支撑相73%”具体指什么。足底支撑相通常指步态周期中脚与地面接触的时间占比,正常范围大约在60%-62%左右。如果达到73%,明显超出正常范围,可能意味着步态异常。 接下来,需要确定可能的原因。可能的原因包括生物力学异常,比如足弓异常(扁平足或高弓足)、踝关节活动度受限,或者肌肉力量不足,特别是小腿和足部肌肉。另外,神经系统疾病如脑卒中或帕金森病可能影响步态控制。骨骼关节问题如关节炎、髋膝关节病变也可能导致支撑时间延长。还有代偿性步态,比如因疼痛或受伤而改变步态模式。 然后是
recommend-type

宾馆预约系统开发与优化建议

宾馆预约系统是一个典型的在线服务应用,它允许用户通过互联网平台预定宾馆房间。这种系统通常包含多个模块,比如用户界面、房态管理、预订处理、支付处理和客户评价等。从技术层面来看,构建一个宾馆预约系统涉及到众多的IT知识和技术细节,下面将详细说明。 ### 标题知识点 - 宾馆预约系统 #### 1. 系统架构设计 宾馆预约系统作为一个完整的应用,首先需要进行系统架构设计,决定其采用的软件架构模式,如B/S架构或C/S架构。此外,系统设计还需要考虑扩展性、可用性、安全性和维护性。一般会采用三层架构,包括表示层、业务逻辑层和数据访问层。 #### 2. 前端开发 前端开发主要负责用户界面的设计与实现,包括用户注册、登录、房间搜索、预订流程、支付确认、用户反馈等功能的页面展示和交互设计。常用的前端技术栈有HTML, CSS, JavaScript, 以及各种前端框架如React, Vue.js或Angular。 #### 3. 后端开发 后端开发主要负责处理业务逻辑,包括用户管理、房间状态管理、订单处理等。后端技术包括但不限于Java (使用Spring Boot框架), Python (使用Django或Flask框架), PHP (使用Laravel框架)等。 #### 4. 数据库设计 数据库设计对系统的性能和可扩展性至关重要。宾馆预约系统可能需要设计的数据库表包括用户信息表、房间信息表、预订记录表、支付信息表等。常用的数据库系统有MySQL, PostgreSQL, MongoDB等。 #### 5. 网络安全 网络安全是宾馆预约系统的重要考虑因素,包括数据加密、用户认证授权、防止SQL注入、XSS攻击、CSRF攻击等。系统需要实现安全的认证机制,比如OAuth或JWT。 #### 6. 云服务和服务器部署 现代的宾馆预约系统可能部署在云平台上,如AWS, Azure, 腾讯云或阿里云。在云平台上,系统可以按需分配资源,提高系统的稳定性和弹性。 #### 7. 付款接口集成 支付模块需要集成第三方支付接口,如支付宝、微信支付、PayPal等,需要处理支付请求、支付状态确认、退款等业务。 #### 8. 接口设计与微服务 系统可能采用RESTful API或GraphQL等接口设计方式,提供服务的微服务化,以支持不同设备和服务的接入。 ### 描述知识点 - 这是我个人自己做的 请大家帮忙修改哦 #### 个人项目经验与团队合作 描述中的这句话暗示了该宾馆预约系统可能是由一个个人开发者创建的。个人开发和团队合作在软件开发流程中有着显著的不同。个人开发者需要关注的方面包括项目管理、需求分析、代码质量保证、测试和部署等。而在团队合作中,每个成员会承担不同的职责,需要有效的沟通和协作。 #### 用户反馈与迭代 描述还暗示了该系统目前处于需要外部反馈和修改的阶段。这表明系统可能还处于开发或测试阶段,需要通过用户的实际使用反馈来不断迭代改进。 ### 标签知识点 - 200 #### 未提供信息 “200”这个标签可能指的是HTTP状态码中表示请求成功(OK)的200状态码。但是,由于没有提供更多的上下文信息,无法进一步分析其在本例中的具体含义。 ### 压缩包子文件的文件名称列表知识点 - 1111 #### 文件命名与管理 “1111”这个文件名称可能是一个版本号、日期标记或者是一个简单的标识符。文件命名应当遵循一定的规则,以确保文件的可追溯性和管理的便利性。在软件开发过程中,合理组织文件和版本控制(如使用Git)是必不可少的。 综上所述,宾馆预约系统的开发是一项复杂的工程,它涉及前后端的开发、数据库设计、系统安全、接口设计等多个方面。开发者在开发过程中需要不断学习和应用各类IT知识,以确保系统能够安全、高效、稳定地运行。而对于个人开发项目,如何合理利用有限资源、高效地管理和优化项目过程也是至关重要的。
recommend-type

HarmonyOS在旅游领域的创新:揭秘最前沿应用实践

# 1. HarmonyOS旅游应用的市场前景分析 随着数字化转型的不断深入,旅游行业正面临着前所未有的变革。在这样的背景下,HarmonyOS作为一种新兴的操作系统,带来了全新的市场前景和机遇。本章将深入分析HarmonyOS在旅游应用领域的市场潜力、用户需求、以及技术创新对旅游体验的改善。 ## 1.1 市场需求与用户画像分析 旅游市场的需求持续增