SELECT t1.org_id AS sonOrgId, t1.orgName AS sonOrgName, t1.id AS routeBasesectionId, t1.`name` AS routeBasesectionName, t1.nature, zw.billCode AS diseaseTypeSn, COUNT( t3.id ) AS num, ( CASE WHEN sum( CASE WHEN zw.`status` = '2' THEN zw.workNum END ) IS NOT NULL THEN sum( CASE WHEN zw.`status` = '2' THEN zw.workNum END ) WHEN sum( CASE WHEN zw.`status` = '1' THEN zw.workNum END ) IS NOT NULL THEN sum( CASE WHEN zw.`status` = '1' THEN zw.workNum END ) ELSE sum( CASE WHEN zw.`status` = '0' THEN zw.workNum END ) END ) AS totalAmount FROM mat_zx_section t3 JOIN base_bridge bb ON bb.id = t3.qshMainId LEFT JOIN mat_zx_workload zw ON zw.mainId = t3.id LEFT JOIN base_e_route_basesection t1 ON t3.baseRoute = t1.id LEFT JOIN main_construct t4 ON t3.constructId = t4.id -- 施工申请 LEFT JOIN main_construct_check t5 ON t5.id = t3.acceptanceId -- 施工申请验收 WHERE t5.process_status = '100' GROUP BY zw.billCode, t1.id, t1.nature, t1.org_id ORDER BY t1.org_id, t1.id, zw.billCode UNION ALL SELECT son_org_id AS sonOrgId, son_org_name AS sonOrgName, route_id AS routeBasesectionId, route_name AS routeBasesectionName, route_type AS nature, disease_type_sn AS diseaseTypeSn, num AS num, total_amount AS totalAmount FROM base_history_repair_statistics；这条sql语句执行失败

深入解析startup.github.io的HTML结构与布局

对于组织账户，域名格式为"orgname.github.io"。例如，如果一个名为"examplecompany"的组织想要使用GitHub Pages来托管其网站，它应该创建一个名为"examplecompany.github.io"的仓库，并将网站源代码上传到这个仓库...

HTML技术博客解析与canyuda.github.io源码解读

用户可以通过创建一个名为username.github.io的仓库（对于个人站点）或orgname.github.io/project-name（对于组织站点）来发布网站。发布过程通常包括将HTML、CSS和JavaScript文件推送到相应的仓库中，GitHub ...

select u.org_id as orgId, u.mobile, o.org_name as orgName from djd_user u inner join sys_org o on u.org_id = o.org_id; 这条SQL能不能改成判断当o.org_name等于指定值时修改u.mobile等于'***'

SELECT o.org_id FROM sys_org o WHERE o.org_name = '指定值' ); 这个SQL语句会在sys_org表中查找org_name等于指定值的记录，并使用INNER JOIN将其与djd_user表中的记录关联。然后使用UPDATE语句将djd_user表...

select u.org_id orgId, u.user_id userId, u.show_order showOrder, u.email, u.status, u.photo, u.lsc, u.office_phone officePhone, u.logon_name logonName, u.global_status globalStatus, u.job_type jobType, u.sex, u.is_mobile_open isMobileOpen, u.job_status jobStatus, u.is_district_leader isDistrictLeader, u.is_mobile_plate_open isMobilePlateOpen, u.user_name userName, u.update_time updateTime, u.is_job_record_tj isJobRecordTj, u.user_job_id userJobId, u.job_position jobPosition, u.old_user_id oldUserId, u.is_home_phone_open isHomePhoneOpen, u.mobile, u.user_res_dep userResDep, u.flag, u.anno, u.is_del isDel, o.org_name orgName from djd_user u inner join sys_org o on u.org_id = o.org_id这样返回到MAP中显示的key都是小写的是为什么?

这是因为在 SQL 查询中使用了小写的列名，导致返回结果中的列名也是小写的。...SELECT u.org_id AS orgId, u.user_id AS userId, ... 这样返回的结果中，列名就会使用别名中指定的大小写形式。

SELECT s.BOOKID as bookid,s.CLASSID as classid, s.GQJ_CLASS as gqjClass,s.GQJ_CLASSIFY as gqjClassify, s.GQJ_STANDARDID as gqjStandardid, s.GQJ_STANDARD as gqjStandard,s.FACTORY_NUM as factoryNum, s.PK_USERLOCALEID as pkUserlocaleid, s.USE_ADDRESS_NAME, s.USE_ORGID as orgid, s.USE_ORG as orgname,s.NEXT_TEST_TIME as nextTestTime, s.CLASSIFYID as classifyid, s.COMMENT_STATUS as commentStatus,s.ISPLAN as isConsumables,1 AS num,1 AS collectedNum,s.I_CODE as iCode,USE_BZID as deptid, USE_BZNAME as deptname FROM gqj_gqjbook s WHERE s.ISPLAN = 0 and USE_RECORD_STATUS="2" and STATUS="0" and (COMMENT_STATUS!='0' or ISNULL(COMMENT_STATUS) or COMMENT_STATUS = '' ) and USE_BZID = '860dc38c2bed4130b3d0746cee8dbf2e' and PK_USERLOCALEID='0346c06203c84e398d3c4381d5b34b7a' and I_CODE IN ( '030080000000000000003134' ) UNION SELECT any_value(s.BOOKID) as bookid,any_value(s.CLASSID) as classid, any_value(s.GQJ_CLASS) as gqjClass, any_value(s.GQJ_CLASSIFY) as gqjClassify, any_value(s.GQJ_STANDARDID) as gqjStandardid, any_value(s.GQJ_STANDARD) as gqjStandard,any_value(s.FACTORY_NUM) as factoryNum, any_value(s.PK_USERLOCALEID) as pkUserlocaleid, any_value(s.USE_ADDRESS_NAME) as useAddressName, any_value(s.USE_ORGID) as orgid, any_value(s.USE_ORG) as orgname, any_value(s.NEXT_TEST_TIME) as nextTestTime, any_value(s.CLASSIFYID) as classifyid, any_value(s.COMMENT_STATUS) as commentStatus,any_value(s.ISPLAN) as isConsumables,COUNT( 0 ) AS num,count(0) AS collectedNum, any_value(s.I_CODE) as iCode, any_value(USE_BZID) as deptid,any_value(USE_BZNAME) as deptname FROM gqj_gqjbook s WHERE s.ISPLAN = 1 and USE_RECORD_STATUS="2" and STATUS="0" and (COMMENT_STATUS!='0' or ISNULL(COMMENT_STATUS) or COMMENT_STATUS = '' ) and USE_BZID = '860dc38c2bed4130b3d0746cee8dbf2e' and PK_USERLOCALEID='0346c06203c84e398d3c4381d5b34b7a' and I_CODE IN ( '030080000000000000003134' ) GROUP BY GQJ_STANDARDID order by any_value(commentStatus), any_value(gqjClass), any_value(gqjClassify), any_value(gqjStandard);

如果符合条件，会返回 BOOKID、CLASSID、GQJ_CLASS、GQJ_CLASSIFY、GQJ_STANDARDID、GQJ_STANDARD、FACTORY_NUM、PK_USERLOCALEID、USE_ADDRESS_NAME、USE_ORGID、USE_ORG、NEXT_TEST_TIME、CLASSIFYID、COMMENT_...

const processSaleBoundArr = async (saleBoundArr, tokenData, accountData) => { let saleOutBounds = [] if (saleBoundArr?.length > 0) { let customerIds = [], customArr = [] for (const item of saleBoundArr) { customerIds.push(item.customer_id) customerIds = Array.from(new Set(customerIds)); } for (const i of customerIds) { const customerDetailRes = await getCustomerDetail( { id: i }, { "app-token": tokenData['app-token'], "X-GW-Router-Addr": accountData?.domain } ); if (customerDetailRes.data.errcode === 0) { const customerData = customerDetailRes.data.data customArr.push(customerData) } } for (const s of saleBoundArr) { for (const c of customArr) { if (s.customer_id === c.customer_id) { s.account_open_addr = c.account_open_addr s.addr = c.addr s.bank = c.bank s.bank_account = c.bank_account s.taxpayer_no = c.taxpayer_no s.orgName = c.sale_dept_name saleOutBounds.push(s) } } } } return saleOutBounds }

这个函数的主要功能是将 saleBoundArr 数组中的元素根据 customer_id 进行分类，并获取每个 customer_id 对应的客户详细信息，然后将客户详细信息与原始的 saleBoundArr 中的元素合并成一个新的数组 ...

const processSaleBoundArr = async (saleBoundArr, tokenData, accountData) => { let saleOutBounds = [] if (saleBoundArr?.length > 0) { let customerIds = [], customArr = [] for (const item of saleBoundArr) { customerIds.push(item.customer_id) customerIds = Array.from(new Set(customerIds)); } for (const i of customerIds) { const customerDetailRes = await getCustomerDetail( { id: i }, { "app-token": tokenData['app-token'], "X-GW-Router-Addr": accountData?.domain } ); if (customerDetailRes.data.errcode === 0) { const customerData = customerDetailRes.data.data customArr.push(customerData) } } for (const s of saleBoundArr) { for (const c of customArr) { if (s.customer_id === c.customer_id) { s.account_open_addr = c.account_open_addr s.addr = c.addr s.bank = c.bank s.bank_account = c.bank_account s.taxpayer_no = c.taxpayer_no s.orgName = c.sale_dept_name saleOutBounds.push(s) } } } } return saleOutBounds } 优化代码

saleBound.orgName = customerData.sale_dept_name; } return saleBound; }); } return saleOutBounds; }; 这个优化后的代码使用了一些 JavaScript 的高级语法，如 Promise.all() 和 Array.prototype...

const processSaleBoundArr = async (saleBoundArr, tokenData, accountData) => { let saleOutBounds = []; if (saleBoundArr && saleBoundArr.length) { const customerIds = [...new Set(saleBoundArr.map(item => item.customer_id))]; const customerPromises = customerIds.map(id => { return getCustomerDetail({ id }, { "app-token": tokenData['app-token'], "X-GW-Router-Addr": accountData?.domain }); }); const customerDetails = await Promise.all(customerPromises); saleOutBounds = saleBoundArr.map(saleBound => { const customerDetail = customerDetails.find(detail => detail.data.errcode === 0 && detail.data.data.id === saleBound.customer_id); if (customerDetail) { const customerData = customerDetail.data.data; saleBound.account_open_addr = customerData.account_open_addr; saleBound.addr = customerData.addr; saleBound.bank = customerData.bank; saleBound.bank_account = customerData.bank_account; saleBound.taxpayer_no = customerData.taxpayer_no; saleBound.orgName = customerData.sale_dept_name; saleBound = Object.assign(saleBound, customerData.custom_field); } return saleBound; }); saleOutBounds.sort((a, b) => { if (a.bill_date > b.bill_date) { return -1 } else if (a.bill_date === b.bill_date) { if (a.id < b.id) { return -1 } else if (a.id === b.id) { return 0 } else { return 1 } } else { return 1 } }) } return saleOutBounds; }; 优化这段代码

orgName: customerData.sale_dept_name, ...customerData.custom_field }); } }); saleOutBounds.sort((a, b) => { if (a.bill_date > b.bill_date) { return -1; } else if (a.bill_date === b.bill_date...

SELECT a.username, a.userid, a.orgname, a.orgnamehr orgnameHr, a.company company, a.idcard, sum(CASE a.hour_type WHEN 'A' THEN a.allot_hour ELSE 0 END ) aHour, sum(CASE a.hour_type WHEN 'B' THEN a.allot_hour ELSE 0 END ) bHour, sum(CASE a.hour_type WHEN 'C' THEN a.allot_hour ELSE 0 END ) cHour, sum(CASE a.hour_type WHEN 'D' THEN a.allot_hour ELSE 0 END ) dHour, sum(CASE a.hour_type WHEN 'E' THEN a.allot_hour ELSE 0 END ) eHour, sum(CASE a.hour_type WHEN 'F' THEN a.allot_hour ELSE 0 END ) fHour, sum(CASE WHEN a.hour_type IN ('A','B','C','D','E','F') THEN a.allot_hour ELSE 0 END ) countHour, CASE yearMonth WHEN CONVERT(varchar(10), d.break_sure_date, 23) >= CONVERT(varchar(10),'2023-06-06', 23) and CONVERT(varchar(10), d.break_sure_date, 23) < CONVERT(varchar(10),'2023-07-06', 23) THEN '1' ELSE '2' END FROM ems_hour_allot a

查询结果将包括以下列：username、userid、orgname、orgnameHr、company、idcard、aHour、bHour、cHour、dHour、eHour、fHour、countHour和yearMonth。该查询使用了多个聚合函数和...

const processSaleBoundArr = async (saleBoundArr, { "app-token": appToken }, { domain } = {}) => { const saleOutBounds = []; if (saleBoundArr?.length) { const customerIds = [...new Set(saleBoundArr.map(({ customer_id }) => customer_id))]; const customerPromises = customerIds.map(id => getCustomerDetail({ id }, { "app-token": appToken, "X-GW-Router-Addr": domain })); const customerDetails = await Promise.allSettled(customerPromises); saleBoundArr.forEach((saleBound, index) => { const customerDetail = customerDetails[index].status === 'fulfilled' && customerDetails[index].value.data.errcode === 0 && customerDetails[index].value.data.data.id === saleBound.customer_id; if (customerDetail) { const { data: customerData } = customerDetails[index].value; saleOutBounds.push({ ...saleBound, account_open_addr: customerData.account_open_addr, addr: customerData.addr, bank: customerData.bank, bank_account: customerData.bank_account, taxpayer_no: customerData.taxpayer_no, orgName: customerData.sale_dept_name, ...customerData.custom_field }); } }); saleOutBounds.sort((a, b) => { if (a.bill_date > b.bill_date) { return -1; } else if (a.bill_date === b.bill_date) { return a.id - b.id; } return 1; }); } return saleOutBounds; }; 捕获异常

orgName: customerData.sale_dept_name, ...customerData.custom_field }); } } catch (error) { console.error(Error processing saleBound ${index}:, error); } }); saleOutBounds.sort((a, b) => { ...

SELECT CASE WHEN b.nature = '还贷性路段' THEN b.orgName ELSE b.NAME END AS NAME, b.nature, b.orgName, SUM(d.authBuildMoney) authBuildMoney, SUM(d.designMoney) designMoney, SUM(d.authSupervisorMoney) authSupervisorMoney FROM base_e_route_basesection b LEFT JOIN system_organization o ON b.org_id = o.organizationId LEFT JOIN mat_plan_planfreeway_detail d on d.sonOrgId = o.organizationId WHERE b.isUse = '1' AND b.orgName IS NOT NULL AND d.parentName = '路面工程' AND d.planType = '养护工程' GROUP BY CASE WHEN b.nature = '还贷性路段' THEN b.orgName ELSE b.NAME END ORDER BY b.nature DESC, o.CODE ASC 这条sql统计有误，如何修改

无法准确判断统计有误的原因，但是可以提供一些可能的修改建议： ...4. 检查 SELECT 和 GROUP BY 是否一致，确保 SELECT 中的字段都在 GROUP BY 中出现过； 5. 检查 ORDER BY 是否正确，确保排序的字段存在且符合预期。

select a.orgId,a.orgName,a.Message,a.time,b.label,b.phone,b.contact from sms_log a where a.userName = '报警短信' and a.orgId = 6406 left join sms_log_ship b on a.id = b.log_id > 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'left join sms_log_ship b on a.id = b.log_id' at line 1

SELECT a.orgId, a.orgName, a.Message, a.time, b.label, b.phone, b.contact FROM sms_log a LEFT JOIN sms_log_ship b ON a.id = b.log_id WHERE a.userName = '报警短信' AND a.orgId = 6406; 在这个查询...

SELECT p.id AS id, p.fullName AS fullName, p.gender AS gender, p.organizationID AS organizationID, o.ORGNAME AS organizationName, p.mobile AS mobile, WM_CONCAT( j.sworkPlaceName ) AS sworkplaceName FROM base_personfile_person p LEFT JOIN sys_org o ON o.ORGID = p.organizationID LEFT JOIN base_personfile_person_sjob pj ON pj.personId = p.id LEFT JOIN base_personfile_sjob j ON j.ID = pj.sjobId WHERE 1=1 GROUP BY p.id 报不是GROUP BY 表达式

SELECT p.id AS id, p.fullName AS fullName, p.gender AS gender, p.organizationID AS organizationID, o.ORGNAME AS organizationName, p.mobile AS mobile, WM_CONCAT(j.sworkPlaceName) AS sworkplaceName ...

select t.* ,lead(期初库存,1,null) over(partition by 仓库, 库存组织id, 物料编码 order by 日期) as 期末库存 from ( select dt 日期 ,fstockid 仓库id ,fstockname 仓库名称 ,fstockorgid 库存组织id ,fstock_orgname 库存组织名称 ,fmaterialid 物料id ,fmaterial_number 物料编码 ,fmaterial_category_1 物料分类 ,fproduct_short 物料名称 from dwd.dwd_erp_stk_inventory_ss_v )t where 1=1 order by t.物料编码 asc, t.仓库id asc, t.日期 asc

1. 首先从 DWD 数据库中的 dwd_erp_stk_inventory_ss_v 视图中选择以下字段：日期(dt)、仓库id(fstockid)、仓库名称(fstockname)、库存组织id(fstockorgid)、库存组织名称(fstock_orgname)、物料id(fmaterialid)、...

select b.name,b.nature,b.orgName from base_e_route_basesection b 改写SQL如果b.nature等于还贷性路段，则不查询b.name，以b.orgName分组，否则以b.name分组查询

CASE WHEN b.nature = '还贷性路段' THEN NULL ELSE b.name END AS name, b.nature, b.orgName FROM base_e_route_basesection b GROUP BY CASE WHEN b.nature = '还贷性路段' THEN b.orgName ELSE b.name END,...

select DISTINCT h.ONLYID, h.CMSNO, h.USERNAME, h.ORGNAME, h.ORGID, h.PURDATE, h.DEVICENAME, h.STATE, h.BELONGS, (select ORGNAME from SYS_ORG where ORGID = (select ORGSUPID from SYS_ORG where ORGID = h.ORGID)) DANWEI from CMS_HISTORICALDATA h LEFT JOIN SYS_ORG o ON h.ORGID = o.ORGID where h.devicename = '计算机' and h.DEL = '0' and h.CHANGENO = '1' and USERNAME = '孙雪' order by DANWEI, ORGNAME 以上sql语句为什么还是有重复的onlyid，没有完全去重

(select ORGNAME from SYS_ORG where ORGID = (select ORGSUPID from SYS_ORG where ORGID = h.ORGID)) DANWEI from CMS_HISTORICALDATA h LEFT JOIN SYS_ORG o ON h.ORGID = o.ORGID where h.devicename = '...

SELECT mo.ORGNAME as departmentName, mp.* FROM mxk_posts mp LEFT JOIN mxk_organizations mo on mp.DEPARTMENTID = mo.id where mp.instid = #{instId} and mo.instid = #{instId} and mp.id not in (SELECT POSTID FROM mxk_userinfo_posts where userId = #{userId}) and mp.id != (SELECT JOBTITLE FROM mxk_userinfo where id = #{userId}) 优化下这个sql

mo.ORGNAME AS departmentName, mp.* FROM mxk_posts mp LEFT JOIN mxk_organizations mo ON mp.DEPARTMENTID = mo.id WHERE mp.instid = #{instId} AND mo.instid = #{instId} AND NOT EXISTS (SELECT 1 ...

创建一个Java 实体，字段如下：id excelDate isv_no isv_name order_date mch_no mch_name mch_create_date qrc_id mch_type cur_agent_name cur_agent_no last_agent_name last_agent_no org_name org_no pay_type product_name product_no order_count order_amt order_fee_amt need_fee_amt cur_base_percent cur_base_amt cur_porfit next_base_percent next_base_amt next_profit cur_final_profit remark1 remark2 remark3 remark4 remark5

private Long id; private Date excelDate; private String isvNo; private String isvName; private Date orderDate; private String mchNo; private String mchName; private Date mchCreateDate; ...

select id AS id , opertime AS opertime , module AS module , orgname AS orgname , operuser AS operuser , opertype AS opertype , create_time AS create_time , send_time AS send_time from dljz_approvalrecords

这是一条 SQL 查询语句，它的作用是从表 dljz_approvalrecords 中查询出 id、opertime、module、orgname、operuser、opertype、create_time 和 send_time 这些字段的值。具体含义如下： - id：记录的唯一标识符； -...

相关推荐

深入解析startup.github.io的HTML结构与布局

HTML技术博客解析与canyuda.github.io源码解读

select u.org_id as orgId, u.mobile, o.org_name as orgName from djd_user u inner join sys_org o on u.org_id = o.org_id; 这条SQL能不能改成判断当o.org_name等于指定值时修改u.mobile等于'***'

select b.name,b.nature,b.orgName from base_e_route_basesection b 改写SQL如果b.nature等于 还贷性路段 ，则不查询b.name，以b.orgName分组，否则以b.name分组查询

select id AS id , opertime AS opertime , module AS module , orgname AS orgname , operuser AS operuser , opertype AS opertype , create_time AS create_time , send_time AS send_time from dljz_approvalrecords

最新推荐

51jobduoyehtml爬虫程序代码QZQ2.txt

RStudio中集成Connections包以优化数据库连接管理

管理建模和仿真的文件

Keil uVision5全面精通指南

flink提交给yarn19个全量同步MYsqlCDC的作业，flink的配置参数怎样设置

PHP博客旅游的探索之旅

"互动学习：行动中的多样性与论文攻读经历"

【单片机编程实战】：掌握流水灯与音乐盒同步控制的高级技巧

java 号码后四位用‘xxxx’脱敏

Arachne:实现UDP RIPv2协议的Java路由库

select b.name,b.nature,b.orgName from base_e_route_basesection b 改写SQL如果b.nature等于还贷性路段，则不查询b.name，以b.orgName分组，否则以b.name分组查询