合并数组--A1,A2按照day_time合并并且无重复day_time

本文介绍了一个具体的数组合并案例,展示了如何将两个数组按day_time字段合并,并确保day_time字段不重复。通过对原始数据进行处理,实现了合并操作并给出了最终的合并结果。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

合并数组--A1,A2按照day_time合并并且无重复day_time。

合并前:
Array
(
    [0] => Array
        (
            [day_time] => 1291161600
            [sum_show_num] => 1
            [sum_click_num] => 2
            [sum_request_num] => 3
            [sum_show_income] => 4
            [sum_click_income] => 5
        )

    [1] => Array
        (
            [day_time] => 1291248000
            [sum_show_num] => 7
            [sum_click_num] => 7
            [sum_request_num] => 2
            [sum_show_income] => 7
            [sum_click_income] => 3
        )

    [2] => Array
        (
            [day_time] => 1291334400
            [sum_show_num] => 4
            [sum_click_num] => 4
            [sum_request_num] => 3
            [sum_show_income] => 3
            [sum_click_income] => 235
        )

    [3] => Array
        (
            [day_time] => 1291852800
            [sum_show_num] => 3
            [sum_click_num] => 7
            [sum_request_num] => 7
            [sum_show_income] => 3
            [sum_click_income] => 6
        )

    [4] => Array
        (
            [day_time] => 1291910401
            [sum_show_num] => 1
            [sum_click_num] => 1
            [sum_request_num] => 1
            [sum_show_income] => 1
            [sum_click_income] => 1
        )

)

Array
(
    [0] => Array
        (
            [day_time] => 1291161600
            [sum_show_num] => 1
            [sum_click_num] => 2
            [sum_request_num] => 3
            [sum_show_income] => 5
            [sum_click_income] => 6
        )

    [1] => Array
        (
            [day_time] => 1291248000
            [sum_show_num] => 4
            [sum_click_num] => 5
            [sum_request_num] => 2
            [sum_show_income] => 8
            [sum_click_income] => 5
        )

    [2] => Array
        (
            [day_time] => 1291593600
            [sum_show_num] => 46
            [sum_click_num] => 2
            [sum_request_num] => 4
            [sum_show_income] => 4
            [sum_click_income] => 8
        )

    [3] => Array
        (
            [day_time] => 1291766400
            [sum_show_num] => 3
            [sum_click_num] => 78
            [sum_request_num] => 3
            [sum_show_income] => 6
            [sum_click_income] => 3
        )

    [4] => Array
        (
            [day_time] => 1292025600
            [sum_show_num] => 8
            [sum_click_num] => 4
            [sum_request_num] => 68
            [sum_show_income] => 86
            [sum_click_income] => 8
        )

    [5] => Array
        (
            [day_time] => 1292112000
            [sum_show_num] => 65
            [sum_click_num] => 11
            [sum_request_num] => 1
            [sum_show_income] => 1
            [sum_click_income] => 1
        )

)
合并后:
Array
(
    [0] => Array
        (
            [day_time] => 1291161600
            [one_sum_click_num] => 2
            [two_sum_click_num] => 2
        )

    [1] => Array
        (
            [day_time] => 1291248000
            [one_sum_click_num] => 7
            [two_sum_click_num] => 5
        )

    [2] => Array
        (
            [day_time] => 1291334400
            [one_sum_click_num] => 4
        )

    [3] => Array
        (
            [day_time] => 1291593600
            [two_sum_click_num] => 2
        )

    [4] => Array
        (
            [day_time] => 1291766400
            [two_sum_click_num] => 78
        )

    [5] => Array
        (
            [day_time] => 1291852800
            [one_sum_click_num] => 7
        )

    [6] => Array
        (
            [day_time] => 1291910401
            [one_sum_click_num] => 1
        )

    [7] => Array
        (
            [day_time] => 1292025600
            [two_sum_click_num] => 4
        )

    [8] => Array
        (
            [day_time] => 1292112000
            [two_sum_click_num] => 11
        )

)
if (count($aOneAppData) > 0) {
 foreach ($aOneAppData as $key=>$value){
   $oneTime[] = $value['day_time'];
 }
}
if (count($aTwoAppData) > 0) {
 foreach ($aTwoAppData as $k => $v){
  if (!in_array($v['day_time'],$oneTime)) {
     $oneTime[] = $v['day_time'];
  }
 }
}
将以下SQL转换成达梦数据库可识别的SQL。SELECT abc1.a3_code, -- 工单 abc1.a2_code, -- 工作号 abc1.a2_name, -- 工作名 abc1.login_name, -- 报工人账号 abc1.a6_code, -- 序列号 abc1.ACTUALSTARTTIME,-- 开始时间 abc1.ACTUALENDTIME ,--结束时间 abc2.work_hours -- 工时 FROM ( SELECT a3.code a3_code,-- 工单 a2.code a2_code,-- 工作号 a2.Name a2_name,-- 工作名 a7.login_name, -- 报工人账号 a6.code a6_code, -- 序列号 a1.ACTUALSTARTTIME,-- 开始时间 a1.ACTUALENDTIME --结束时间 FROM F_PRODUCTIONWOMENTRESPONSE6635 a1 --生产工作实绩 LEFT JOIN F_WORKSEGMENTREQUIREMENT a2 -- 工作 ON a1.WORKSEGMENTREQUIREMENT=a2.id LEFT JOIN F_WORKREQUEST a3 --工单 ON a2.WorkRequest=a3.id LEFT JOIN F_MATERIALACTUAL a4 -- 物料实绩 ON a1.id =a4.SOURCE_ID LEFT JOIN F_MATERIALACTUALSN a5 -- 物料实绩的序列号 ON a4.id=a5.SOURCE_ID LEFT JOIN F_INDIVIDUALOBJECT a6 -- 实物对象 ON a5.related_id=a6.ID LEFT JOIN F_USER a7 --用户 ON a1.created_by_id =a7.ID WHERE a1.ACTUALSTARTTIME IS NOT NULL OR a1.ACTUALENDTIME IS NOT NULL ORDER BY a2_code DESC,a6_code ) abc1 LEFT JOIN ( SELECT a3.code AS a3_code, a2.code AS a2_code, a2.Name AS a2_name, a6.code AS a6_code, MIN(a1.ACTUALSTARTTIME) AS earliest_start_time, MAX(a1.ACTUALENDTIME) AS latest_end_time, -- 使用方法1计算 ROUND( (EXTRACT(DAY FROM (MAX(a1.ACTUALENDTIME) - MIN(a1.ACTUALSTARTTIME))) * 24 + EXTRACT(HOUR FROM (MAX(a1.ACTUALENDTIME) - MIN(a1.ACTUALSTARTTIME))) + EXTRACT(MINUTE FROM (MAX(a1.ACTUALENDTIME) - MIN(a1.ACTUALSTARTTIME))) / 60 + EXTRACT(SECOND FROM (MAX(a1.ACTUALENDTIME) - MIN(a1.ACTUALSTARTTIME))) / 3600), 3) AS work_hours FROM F_PRODUCTIONWOMENTRESPONSE6635 a1 LEFT JOIN F_WORKSEGMENTREQUIREMENT a2 ON a1.WORKSEGMENTREQUIREMENT = a2.id LEFT JOIN F_WORKREQUEST a3 ON a2.WorkRequest = a3.id LEFT JOIN F_MATERIALACTUAL a4 ON a1.id = a4.SOURCE_ID LEFT JOIN F_MATERIALACTUALSN a5 ON a4.id = a5.SOURCE_ID LEFT JOIN F_INDIVIDUALOBJECT a6 ON a5.related_id = a6.ID LEFT JOIN F_USER a7 ON a1.created_by_id = a7.ID WHERE a1.ACTUALSTARTTIME IS NOT NULL OR a1.ACTUALENDTIME IS NOT NULL GROUP BY a3.code, a2.code, a2.Name, a7.login_name, a6.code HAVING MIN(a1.ACTUALSTARTTIME) IS NOT NULL AND MAX(a1.ACTUALENDTIME) IS NOT NULL ORDER BY a2_code DESC, a6_code ) abc2 ON abc1.a3_code=abc2.a3_code AND abc1.a2_code=abc2.a2_code AND abc1.a2_name=abc2.a2_name AND abc1.a6_code=abc2.a6_code WHERE abc1.a3_code='0000593'-- 工单 AND abc1.a2_code='0000593-1098' -- 工作号 AND abc1.login_name='BSGWH024' --人员账号 AND abc1.a6_code='ZP0005369' --序列号
最新发布
03-26
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值