this.PRD_O_CODE == undefined || this.PRD_O_CODE == ''

在JavaScript中，`this.PRD_O_CODE == undefined || this.PRD_O_CODE == ''`是一个条件表达式，用于检查`PRD_O_CODE`属性是否为`undefined`或空字符串。`PRD_O_CODE`是`this`对象的一个属性。这个表达式的含义是： - 如果`this.PRD_O_CODE`的值是`undefined`（即该属性不存在或者被设置为`undefined`），或者 - 如果`this.PRD_O_CODE`的值是空字符串`''`（即没有内容的字符串）那么整个表达式的结果将会为`true`。否则，结果为`false`。这种检查通常用于在进行操作前验证某个变量是否存在或者其值是否为空，以避免运行时错误。

优化下这个代码 select sum(auth_amt) sum_auth_amt from auth_cont auth where auth_sts = '1' and exists (select 1 from RPT_DUE_LOAN_ACC_M loan where loan.cif_no = auth.cif_no AND loan.send_flag = '2' AND LOAN.PRD_USERDF_TYPE != '3017' AND LOAN.BANK_ID = 162000 and (loan.cif_no in (select cif_no from RPT_DUE_LOAN_ACC_M a where 1 = 1 AND LOAN.YEAR = '2021' AND LOAN.MONTH = '12' AND LOAN.ACCOUNT_STATUS NOT IN ('0', '2') AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) or substr(LOAN.SETTL_DATE, 0, 6) = '202112') AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = '162000' CONNECT BY PRIOR BR_NO = UP_ONE) group by cif_no and (loan.cif_no in (select cif_no from RPT_DUE_LOAN_ACC_M a where 1 = 1 AND LOAN.YEAR = '2021' AND LOAN.MONTH = '12' AND LOAN.ACCOUNT_STATUS NOT IN ('0', '2') AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) or substr(LOAN.SETTL_DATE, 0, 6) = '202112') AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = '162000' CONNECT BY PRIOR BR_NO = UP_ONE) group by cif_no AND LOAN.YEAR = '2021' AND LOAN.MONTH = '12' AND LOAN.ACCOUNT_STATUS NOT IN ('0', '2') AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) or substr(LOAN.SETTL_DATE, 0, 6) = '202112') AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = '162000' CONNECT BY PRIOR BR_NO = UP_ONE))

答案：SELECT SUM(AUTH_AMT) SUM_AUTH_AMT FROM AUTH_CONT AUTH WHERE AUTH_STS = 1 AND EXISTS(SELECT 1 FROM RPT_DUE_LOAN_ACC_M LOAN WHERE LOAN.CIF_NO = AUTH.CIF_NO AND LOAN.SEND_FLAG = 2 AND LOAN.PRD_USERDF_TYPE != 3017 AND LOAN.BANK_ID = 162000 AND LOAN.CIF_NO IN (SELECT CIF_NO FROM RPT_DUE_LOAN_ACC_M A WHERE LOAN.YEAR = 2021 AND LOAN.MONTH = 12 AND LOAN.ACCOUNT_STATUS NOT IN (0, 2) AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) OR SUBSTR(LOAN.SETTL_DATE, 0, 6) = 202112) AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = 162000 CONNECT BY PRIOR BR_NO = UP_ONE) GROUP BY CIF_NO) AND LOAN.YEAR = 2021 AND LOAN.MONTH = 12 AND LOAN.ACCOUNT_STATUS NOT IN (0, 2) AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) OR SUBSTR(LOAN.SETTL_DATE, 0, 6) = 202112) AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = 162000 CONNECT BY PRIOR BR_NO = UP_ONE));

优化下这个代码 select sum(auth_amt) sum_auth_amt from auth_cont auth left join (select * from RPT_DUE_LOAN_ACC_M loan where loan.send_flag = '2' and loan.prd_userdf_type != '3017' and loan.bank_id = 162000 and (loan.cif_no in (select cif_no from RPT_DUE_LOAN_ACC_M a where 1 = 1 AND LOAN.YEAR = '2021' AND LOAN.MONTH = '12' AND LOAN.ACCOUNT_STATUS NOT IN ('0', '2') AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) or substr(LOAN.SETTL_DATE, 0, 6) = '202112') AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = '162000' CONNECT BY PRIOR BR_NO = UP_ONE) group by cif_no and (loan.cif_no in (select cif_no from RPT_DUE_LOAN_ACC_M a where 1 = 1 AND LOAN.YEAR = '2021' AND LOAN.MONTH = '12' AND LOAN.ACCOUNT_STATUS NOT IN ('0', '2') AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) or substr(LOAN.SETTL_DATE, 0, 6) = '202112') AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = '162000' CONNECT BY PRIOR BR_NO = UP_ONE) group by cif_no group by cif_no) loan on loan.cif_no = auth.cif_no where auth_sts = '1' AND LOAN.YEAR = '2021' AND LOAN.MONTH = '12' AND LOAN.ACCOUNT_STATUS NOT IN ('0', '2') AND ((LOAN.LOAN_BAL > 0 OR LOAN.IN_INTST > 0 OR LOAN.OUT_INTST > 0 OR LOAN.CMPD_INTST > 0) or substr(LOAN.SETTL_DATE, 0, 6) = '202112') AND LOAN.MANG_BR_NO IN (SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = '162000' CONNECT BY PRIOR BR_NO = UP_ONE)

答：SELECT SUM（AUTH_AMT）SUM_AUTH_AMT FROM AUTH_CONT AUTH LEFT JOIN（SELECT * FROM RPT_DUE_LOAN_ACC_M LOAN WHERE LOAN.SEND_FLAG = 2 AND LOAN.PRD_USERDF_TYPE ！= 3017 AND LOAN.BANK_ID = 162000 AND（LOAN.CIF_NO IN（SELECT CIF_NO FROM RPT_DUE_LOAN_ACC_M A WHERE LOAN.YEAR = 2021 AND LOAN.MONTH = 12 AND LOAN.ACCOUNT_STATUS NOT IN（0,2）AND（（LOAN.LOAN_BAL>0 OR LOAN.IN_INTST>0 OR LOAN.OUT_INTST>0 OR LOAN.CMPD_INTST>0）OR SUBSTR（LOAN.SETTL_DATE，0,6）= 202112）AND LOAN.MANG_BR_NO IN（SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = 162000 CONNECT BY PRIOR BR_NO = UP_ONE）GROUP BY CIF_NO）ON LOAN.CIF_NO = AUTH.CIF_NO WHERE AUTH_STS = 1 AND LOAN.YEAR = 2021 AND LOAN.MONTH = 12 AND LOAN.ACCOUNT_STATUS NOT IN（0,2）AND（（LOAN.LOAN_BAL>0 OR LOAN.IN_INTST>0 OR LOAN.OUT_INTST>0 OR LOAN.CMPD_INTST>0）OR SUBSTR（LOAN.SETTL_DATE，0,6）= 202112）AND LOAN.MANG_BR_NO IN（SELECT BR_NO FROM TBL_ORG_DEPARTMENTS START WITH BR_NO = 162000 CONNECT BY PRIOR BR_NO = UP_ONE）GROUP BY CIF_NO）LOAN ON LOAN.CIF_NO = AUTH.CIF_NO WHERE AUTH_STS = 1。

阅读全文

this.PRD_O_CODE == undefined || this.PRD_O_CODE == ''

相关推荐

CCS周期性模块函数使用实例：TMS320F2812 PRD

5509A_DSP通用定时器使用详解

下载产品需求文档（PRD）模板，助力项目开发与学习

11.8.50.3425_SLM_H_D0_PRD_EXTR.bin

prd.rar_CCS_PRD ccs_TMS320F2812 PRD

prd.rar_PRD

HRX_prd-2.apkattname=

idr_prd.rar_delphi_delphi IDR_reconstructor

MDC.zip_MDC-PRD matlab_mdc_mdc matlab

begin for t in(select a.fid,a.F_CNJ_PUBLISHMODEL from t_prd_mo a inner join t_prd_moentry b on a.fid=b.fid where b.fsaleorderno='CRM-202208240012') loop update t_prd_mo set F_CNJ_PUBLISHMODEL='NJA1042PDF33A' where fid=t.fid; end loop; commit; end;

优化脚本 begin for t in(select a.fid,a.F_CNJ_PUBLISHMODEL from t_prd_mo a inner join t_prd_moentry b on a.fid=b.fid where b.fsaleorderno='CRM-202208240012') loop update t_prd_mo set F_CNJ_PUBLISHMODEL='NJA1042PDF33A' where fid=t.fid; end loop; commit; end;

SELECT top 0 id FROM PRD_RYK b where 1 = 1 and rybh != 'admin' and isnull(qqh,'') = '' and isnull(lord_user,'') = '' and b.zt in ( 1 , 2 , 3 , 4 , 5 ) ORDER BY id DESC 替换为mysql语句如何替换

nt main(void) { JL_TIMER0->CNT = 0; SFR(JL_IMP-> FI_GP_ICH3,0,8,PA3_IN); SFR(JL_TIMER->CON, 0, 0, 2); SFR(JL_TIMER->CON, 2, 2, 0); while (1) { if (PA3_IN & 1) { JL_TIMERS-> PRD == JL_TIMER0 ->CNT; break; } }

最新推荐

产品需求说明书（PRD）模板.docx

模板 某大厂PRD产品需求文档.docx

经典的产品需求文档-PRD-模板.doc

精细金属掩模板(FMM)行业研究报告 显示技术核心部件FMM材料产业分析与市场应用

【创新未发表】斑马算法ZOA-Kmean-Transformer-LSTM负荷预测Matlab源码 9515期.zip

WordPress作为新闻管理面板的实现指南

管理建模和仿真的文件

函数与模块化编程宝典：J750编程高效之路

用C语言求有4个圆塔，圆心分别为（2，2)，(2，-2)，(-2，2)，(-2，-2)圆半径为1， 这4个塔的高度为10m 塔以外无建筑物接输入任意点的坐标 求该点的建筑高度（塔外的高度为零)的程序

NPC_Generator：使用Ruby打造的游戏角色生成器

模板某大厂PRD产品需求文档.docx

精细金属掩模板(FMM)行业研究报告显示技术核心部件FMM材料产业分析与市场应用

用C语言求有4个圆塔，圆心分别为（2，2)，(2，-2)，(-2，2)，(-2，-2)圆半径为1，这4个塔的高度为10m 塔以外无建筑物接输入任意点的坐标求该点的建筑高度（塔外的高度为零)的程序