44444444444

最新推荐文章于 2022-07-03 10:16:47 发布
最新推荐文章于 2022-07-03 10:16:47 发布
阅读量842 收藏 1
点赞数
文章标签： report insert c list delete exe
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/jiarch/article/details/5518035
版权

CREATE OR REPLACE PROCEDURE P_FEE_Estimate_Execute_STAT AS

  /*--------------------------------------------
  *  过程：产生动态执行情况统计数据
  *  入参；
  *  出参；

  *  说明:
  *        1.本存储为 oracle 中定时执行任务自动执行的,推荐为每日凌晨系统比较空闲时自动执行,目前定为每日
  *          凌晨1:00执行;
  *        2.当工程分段指定的日期执行概算已统计过,则不再进行统计了;
  *        3.对"未审批"的量进行统计时只统计正在审批处理中的合同或变更等单据(审批状态为 C175_1);
  *        4.本过程统计计算过程
  *        ______________________________________________________________________________________________
  *                     |              非计量类合同        |            计量类合同
  *        ______________________________________________________________________________________________
  *                     |    对应合同   |   对应合同清单   | 对应分项(建安清单) |  对应清单范本(总则清单)
  *        ______________________________________________________________________________________________
  *        合同的量     |      (1)      |      (4)         |       (7)          |         (10)
  *        变更的量     |   (不计算)    |      (5)         |       (8)          |         (11)
  *        计量/支付的量|      (3)      |      (6)         |       (9)          |         (12)
  *        ______________________________________________________________________________________________
  *        5.对于计算类型概算,将按概算中设置的公式进行计算;
  *        6.临时表字段说明;
  *    概算动态执行情况明细表主键           EST_EXE_DTL_ID                c1
  *    分段概算主键                         SEC_EST_ID                    c2
  *    概算动态执行情况主表主键             EST_EXE_Main_ID               c3
  *    预算数量(主计量单位)                 Budget_Amount_Major           c4
  *    预算数量(次计量单位)                 Budget_Amount_Minor           c5
  *    预算金额                             Budget_Currency               c6
  *    合同数量                             CNT_Amount                    c7
  *    合同金额                             CNT_Currency                  c8
  *    含补充协议金额                       CNT_Currency_Sub              c9
  *    未批合同金额                         CNT_Currency_UnSign           c10
  *    修编数量                             Emend_Amount                  c11
  *    修编金额                             Emend_Currency                c12
  *    变更数量                             Change_Amount                 c13
  *    变更金额                             Change_Currency               c14
  *    未批变更金额                         Change_Currency_Unsigned      c15
  *    变更后金额                           Change_Currency_After         c16
  *    累计完成金额                         Finished_Currency             c17
  *    累计完成比例                         Finished_Rate                 c18
  *    决算数量                             Final_Cost_Amount             c19
  *    决算金额                             Final_Cost_Currency           c20
  * --------------------------------------------*/
  v_Generate_Date      DATE := SYSDATE - 1; --概算统计日期
  v_PRJ_SEG_ID         FEE_PROJECT_SEGMENT.PRJ_SEG_ID%TYPE; --工程分段ID
  v_isBuilded          INT; --指定工程分段下指定日期的动态执行统计记录是否已产生,=1 表示已产生,=0 表示未产生
  v_newEST_EXE_Main_ID FEE_Estimate_Execute_Main.Est_Exe_Main_Id%TYPE; --动态执行情况主表ID

  CURSOR cur1 IS
    SELECT s.prj_seg_id, s.prj_seg_code, s.prj_seg_name
    FROM Fee_Project_Segment s
    ORDER BY s.project_id;

BEGIN
  FOR rs1 IN cur1
  LOOP
    v_PRJ_SEG_ID := rs1.prj_seg_id;

    --看看本工程段指定日期有没有产生过
    SELECT CASE
             WHEN COUNT(*) > 0 THEN
              1
             ELSE
              0
           END
    INTO v_isBuilded
    FROM FEE_Estimate_Execute_Main t
    WHERE t.prj_seg_id = v_PRJ_SEG_ID AND
          to_char(t.generate_date, 'yyyy-mm-dd') =
          to_char(v_Generate_Date, 'yyyy-mm-dd');

    --本工程段指定日期已经产生过,则不再产生了
    IF (v_isBuilded <= 0) THEN
      v_newEST_EXE_Main_ID := sys_guid();

      --插入日动态主表记录
      INSERT INTO FEE_Estimate_Execute_Main
        (est_exe_main_id, prj_seg_id, generate_date, is_edit)
      VALUES
        (v_newEST_EXE_Main_ID, v_PRJ_SEG_ID, v_Generate_Date, 'C061_2');

      --产生明细记录
      INSERT INTO tmp_pla_report
        (c1, c2, c3, c4, c5, c6, C45, c50)
        SELECT sys_guid(), e.sec_est_id, v_newEST_EXE_Main_ID,
               e.Budget_Amount_Major, e.Budget_Amount_Minor,
               e.Budget_Currency, v_PRJ_SEG_ID, '临时结果' rsType
        FROM FEE_Section_Estimate e
        WHERE e.prj_seg_id = v_PRJ_SEG_ID;

      --1-概算与合同对应的统计
      --1-1-合同量的统计(合同金额/未批合同金额)
      INSERT INTO tmp_pla_report
        (c40, c41, c44, C45, c50)
        SELECT ec.sec_est_id,
               SUM(NVL(ec.rate, 0) * NVL(ec.currency, 0) / 100) sumC,
               1 isSigned, v_PRJ_SEG_ID, '概算对应合同-合同量' rsType
        FROM FEE_Estimate_Contract ec, CNT_Contract c,
             FEE_Section_Estimate se
        WHERE ec.cnt_id = c.cnt_id AND ec.sec_est_id = se.sec_est_id AND
              c.status = 'C175_2' /*已审批*/
              AND c.Pay_kind = 'C203_2' /*非计量支付*/
              AND se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY ec.sec_est_id
        UNION ALL
        SELECT ec.sec_est_id, SUM(NVL(ec.currency, 0)) sumC, 0 isSigned,
               v_PRJ_SEG_ID, '概算对应合同-合同量' rsType
        FROM FEE_Estimate_Contract ec, CNT_Contract c,
             FEE_Section_Estimate se
        WHERE ec.cnt_id = c.cnt_id AND ec.sec_est_id = se.sec_est_id AND
              c.status = 'C175_1' /*正在审批中...*/
              AND c.Pay_kind = 'C203_2' /*非计量支付*/
              AND se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY ec.sec_est_id;

      --更新已审批的合同金额
      UPDATE tmp_pla_report r
      SET r.c8 =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '概算对应合同-合同量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '概算对应合同-合同量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的合同金额
      UPDATE tmp_pla_report r
      SET r.c10 =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '概算对应合同-合同量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '概算对应合同-合同量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '概算对应合同-合同量' AND t.c45 = v_PRJ_SEG_ID;

      --1-2-变更量的统计
      --nothing to do !

      --1-3-计量与支付的统计(累计完成金)
      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT ec.sec_est_id, SUM(NVL(p.CUR_Currency, 0)) sumC, 1 isSigned,
               v_PRJ_SEG_ID, '概算对应合同-计量与支付' rsType
        FROM FEE_Estimate_Contract ec, CNT_Contract c, CNT_PMNT_INFRM_Main p,
             FEE_Section_Estimate se
        WHERE ec.cnt_id = c.cnt_id AND p.cnt_id = c.cnt_id AND
              ec.sec_est_id = se.sec_est_id AND c.status = 'C175_2' /*已审批*/
              AND se.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_2' /*非计量支付*/
              AND p.status = 'C175_2' /*已审批*/
        GROUP BY ec.sec_est_id;

      --更新已审批的累计完成量
      UPDATE tmp_pla_report r
      SET r.c17 =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c42 = '1' AND pr.c50 = '概算对应合同-计量与支付' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c42 = '1' AND
                   pr.c50 = '概算对应合同-计量与支付' AND pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '概算对应合同-计量与支付' AND t.c45 = v_PRJ_SEG_ID;

      --2-概算与合同清单对应的统计
      --2-1-合同量的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c42, c44, c45, c50)
        SELECT se.sec_est_id,
               SUM(NVL(ll.rate, 0) * NVL(l.cnt_amount, 0) / 100) sumM,
               SUM(NVL(ll.rate, 0) * NVL(l.cnt_currency, 0) / 100) sumC,
               1 isSigned, v_PRJ_SEG_ID, '清单对应概算-合同量' rsType
        FROM FEE_Section_Estimate se, FEE_Estimate_LOT_Listing ll,
             CNT_LOT_Listing l, CNT_Contract c
        WHERE se.sec_est_id = ll.sec_est_id AND
              ll.lot_list_id = l.lot_list_id AND l.cnt_id = c.cnt_id AND
              se.prj_seg_id = v_PRJ_SEG_ID AND c.status = 'C175_2' /*已审批*/
              AND c.Pay_kind = 'C203_2' /*非计量支付*/
        GROUP BY se.sec_est_id
        UNION ALL
        SELECT se.sec_est_id,
               SUM(NVL(ll.rate, 0) * NVL(l.cnt_amount, 0) / 100) sumM,
               SUM(NVL(ll.rate, 0) * NVL(l.cnt_currency, 0) / 100) sumC,
               0 isSigned, v_PRJ_SEG_ID, '清单对应概算-合同量' rsType
        FROM FEE_Section_Estimate se, FEE_Estimate_LOT_Listing ll,
             CNT_LOT_Listing l, CNT_Contract c
        WHERE se.sec_est_id = ll.sec_est_id AND
              ll.lot_list_id = l.lot_list_id AND l.cnt_id = c.cnt_id AND
              c.status = 'C175_1' /*正在审批中...*/
              AND se.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_2' /*非计量支付*/
        GROUP BY se.sec_est_id;

      --更新已审批的合同量
      UPDATE tmp_pla_report r
      SET (r.c7, r.c8) =
           (SELECT pr.c41, pr.c42
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '清单对应概算-合同量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '清单对应概算-合同量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的合同量
      UPDATE tmp_pla_report r
      SET r.c10 =
           (SELECT pr.c42
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '清单对应概算-合同量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '清单对应概算-合同量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '清单对应概算-合同量' AND t.c45 = v_PRJ_SEG_ID;

      --2-2-变更量的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c42, c43, c44, c45, c50)
        SELECT ls.sec_est_id,
               SUM(NVL(ls.rate, 0) * NVL(l.Change_Amount, 0) / 100)
               /*变更数量*/,
               SUM(NVL(ls.rate, 0) * NVL(l.Change_Currency, 0) / 100)
               /*变更金额*/,
               SUM(NVL(ls.rate, 0) *
                    (NVL(l.Finally_Currency, 0) + NVL(l.Change_Currency, 0)) / 100)
               /*变更后金额*/, 1 isSigned, v_PRJ_SEG_ID, '清单对应概算-变更量' rsType
        FROM FEE_Estimate_LOT_Listing ls, CNT_LOT_Listing l, cnt_contract c,
             FEE_Section_Estimate se
        WHERE ls.lot_list_id = l.lot_list_id AND l.cnt_id = c.cnt_id AND
              ls.sec_est_id = se.sec_est_id AND c.Pay_kind = 'C203_2' /*非计量支付*/
              AND se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY ls.sec_est_id; /*已审批的直接从合同清单中取变更量...*/

      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT el.sec_est_id,
               SUM(NVL(el.rate, 0) * NVL(l.sumADDC_Currency, 0) / 100),
               0 isSigned, v_PRJ_SEG_ID, '清单对应概算-变更量' rsType
        FROM FEE_Estimate_LOT_Listing el, FEE_Section_Estimate se,
             (SELECT cl.lot_list_id,
                      SUM(NVL(cl.Declare_After_Currency, 0) -
                           NVL(cl.Before_Currency, 0)) sumADDC_Currency /*未批变更金额*/
               FROM CNT_CHNG_Listing cl, CNT_CHNG cg, CNT_LOT_Listing ll,
                    cnt_contract c
               WHERE cl.chng_id = cg.chng_id AND
                     ll.lot_list_id = cl.lot_list_id AND ll.cnt_id = c.cnt_id AND
                     cg.status = 'C175_1' /*正在审批中...*/
                     AND c.Pay_kind = 'C203_2' /*非计量支付*/
               GROUP BY cl.lot_list_id) l
        WHERE el.lot_list_id = l.lot_list_id AND
              el.sec_est_id = se.sec_est_id AND
              se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY el.sec_est_id;

      --更新已审批的变更量
      UPDATE tmp_pla_report r
      SET (r.c13, r.c14, r.c16) =
           (SELECT pr.c41, pr.c42, pr.c43
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '清单对应概算-变更量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '清单对应概算-变更量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的变更量
      UPDATE tmp_pla_report r
      SET (r.c15) =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '清单对应概算-变更量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '清单对应概算-变更量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '清单对应概算-变更量' AND t.c45 = v_PRJ_SEG_ID;

      --2-3-计量与支付的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT ll.sec_est_id,
               SUM(NVL(ll.rate, 0) * NVL(f.sumFinished_Currency, 0) / 100),
               1 isSigned, v_PRJ_SEG_ID, '清单对应概算-累计计量/支付' rsType
        FROM FEE_Estimate_LOT_Listing ll, FEE_Section_Estimate se,
             (SELECT p1.lot_list_id,
                      SUM(NVL(p1.CNT_Currency_Approval1, 0) +
                           NVL(p1.Change_Currency_Approval1, 0)) sumFinished_Currency
               FROM CNT_Listing_Payment1 p1, CNT_PMNT p, cnt_contract c
               WHERE p1.pmnt_id = p.pmnt_id AND p.cnt_id = c.cnt_id AND
                     p.status = 'C175_2' /*已审批*/
                     AND c.Pay_kind = 'C203_2' /*非计量支付*/
               GROUP BY p1.lot_list_id) f
        WHERE ll.lot_list_id = f.lot_list_id AND
              ll.sec_est_id = se.sec_est_id AND
              se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY ll.sec_est_id;

      --更新已审批的累计/支付
      UPDATE tmp_pla_report r
      SET r.c17 =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                  pr.c50 = '清单对应概算-累计计量/支付' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                   pr.c50 = '清单对应概算-累计计量/支付' AND pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '清单对应概算-累计计量/支付' AND t.c45 = v_PRJ_SEG_ID;

      --3--概算与分项对应的统计
      --3-1-合同量的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c42, c44, c45, c50)
        SELECT e.sec_est_id, SUM(NVL(l.cnt_amount, 0)) /*合同数量*/,
               SUM(NVL(l.cnt_currency, 0)) sumC /*合同金额*/, 1 isSigned,
               v_PRJ_SEG_ID, '概算与分项对应-合同量' rsType
        FROM CNT_LOT_Listing l, CNT_Contract c, CNT_LOT_Sub_Projects p,
             BAS_Sub_Projects_Template t, FEE_Section_Estimate e
        WHERE e.est_tmp_id = t.est_tmp_id AND
              t.sub_prj_tmp_id = p.sub_prj_tmp_id AND p.cnt_id = c.cnt_id AND
              l.lot_sub_prj_id = p.lot_sub_prj_id AND c.status = 'C175_2' /*已审批*/
              AND e.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_1' /*计量支付*/
        GROUP BY e.sec_est_id
        UNION ALL
        SELECT e.sec_est_id, SUM(NVL(l.cnt_amount, 0)) /*合同数量*/,
               SUM(NVL(l.cnt_currency, 0)) sumC /*合同金额*/, 0 isSigned,
               v_PRJ_SEG_ID, '概算与分项对应-合同量' rsType
        FROM CNT_LOT_Listing l, CNT_Contract c, CNT_LOT_Sub_Projects p,
             BAS_Sub_Projects_Template t, FEE_Section_Estimate e
        WHERE e.est_tmp_id = t.est_tmp_id AND
              t.sub_prj_tmp_id = p.sub_prj_tmp_id AND p.cnt_id = c.cnt_id AND
              l.lot_sub_prj_id = p.lot_sub_prj_id AND c.status = 'C175_1' /*正在审批中...*/
              AND e.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_1' /*计量支付*/
        GROUP BY e.sec_est_id;

      --更新已审批的合同量
      UPDATE tmp_pla_report r
      SET (r.c7, r.c8) =
           (SELECT pr.c41, pr.c42
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '概算与分项对应-合同量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '概算与分项对应-合同量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的合同量
      UPDATE tmp_pla_report r
      SET r.c10 =
           (SELECT pr.c42
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '概算与分项对应-合同量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '概算与分项对应-合同量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '概算与分项对应-合同量' AND t.c45 = v_PRJ_SEG_ID;

      --3-2-变更量的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c42, c43, c44, c45, c50)
        SELECT e.sec_est_id, SUM(NVL(l.Change_Amount, 0)) /*变更数量*/,
               SUM(NVL(l.Change_Currency, 0)) sumC /*变更金额*/,
               SUM(NVL(l.Finally_Currency, 0) + NVL(l.Change_Currency, 0))
               /*变更后金额*/, 1 isSigned, v_PRJ_SEG_ID, '概算与分项对应-变更量' rsType
        FROM CNT_LOT_Listing l, CNT_Contract c, CNT_LOT_Sub_Projects p,
             BAS_Sub_Projects_Template t, FEE_Section_Estimate e
        WHERE e.est_tmp_id = t.est_tmp_id AND
              t.sub_prj_tmp_id = p.sub_prj_tmp_id AND p.cnt_id = c.cnt_id AND
              l.lot_sub_prj_id = p.lot_sub_prj_id AND c.status = 'C175_2' /*已审批*/
              AND e.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_1' /*计量支付*/
        GROUP BY e.sec_est_id;

      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT e.sec_est_id, SUM(NVL(l.sumADDC_Currency, 0)) /*未审批变更金额*/,
               0 isSigned, v_PRJ_SEG_ID, '概算与分项对应-变更量' rsType
        FROM (SELECT cl.lot_list_id, ll.lot_sub_prj_id,
                      SUM(NVL(Declare_After_Currency, 0) -
                           NVL(Before_Currency, 0)) sumADDC_Currency /*未批变更金额*/
               FROM CNT_CHNG_Listing cl, CNT_CHNG cg, CNT_LOT_Listing ll
               WHERE cl.chng_id = cg.chng_id AND cg.status = 'C175_1' /*正在审批中...*/
                     AND ll.lot_list_id = cl.lot_list_id
               GROUP BY cl.lot_list_id, ll.lot_sub_prj_id) l, CNT_Contract c,
             CNT_LOT_Sub_Projects p, BAS_Sub_Projects_Template t,
             FEE_Section_Estimate e
        WHERE e.est_tmp_id = t.est_tmp_id AND
              t.sub_prj_tmp_id = p.sub_prj_tmp_id AND p.cnt_id = c.cnt_id AND
              l.lot_sub_prj_id = p.lot_sub_prj_id AND c.status = 'C175_2' /*合同已审批*/
              AND e.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_1' /*计量支付*/
        GROUP BY e.sec_est_id;

      --更新已审批的变更量
      UPDATE tmp_pla_report r
      SET (r.c13, r.c14, r.c16) =
           (SELECT pr.c41, pr.c42, pr.c43
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '概算与分项对应-变更量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND pr.c50 = '概算与分项对应-变更量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的变更量
      UPDATE tmp_pla_report r
      SET (r.c15) =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '概算与分项对应-变更量' AND
                  pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND pr.c50 = '概算与分项对应-变更量' AND
                   pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '概算与分项对应-变更量' AND t.c45 = v_PRJ_SEG_ID;

      --3-3-计量与支付的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT e.sec_est_id, SUM(NVL(l.sumFinished_Currency, 0)) /*未审批变更金额*/,
               1 isSigned, v_PRJ_SEG_ID, '概算与分项对应-累计计量/支付' rsType
        FROM (SELECT l.lot_sub_prj_id,
                      SUM(NVL(p1.CNT_Currency_Approval1, 0) +
                           NVL(p1.Change_Currency_Approval1, 0)) sumFinished_Currency
               FROM CNT_Listing_Payment1 p1, CNT_PMNT p, CNT_LOT_LISTING l
               WHERE p1.pmnt_id = p.pmnt_id AND
                     p1.lot_list_id = l.lot_list_id AND p.status = 'C175_2' /*已审批*/
               GROUP BY l.lot_sub_prj_id) l, CNT_Contract c,
             CNT_LOT_Sub_Projects p, BAS_Sub_Projects_Template t,
             FEE_Section_Estimate e
        WHERE e.est_tmp_id = t.est_tmp_id AND
              t.sub_prj_tmp_id = p.sub_prj_tmp_id AND p.cnt_id = c.cnt_id AND
              l.lot_sub_prj_id = p.lot_sub_prj_id AND c.status = 'C175_2' /*合同已审批*/
              AND e.prj_seg_id = v_PRJ_SEG_ID AND c.Pay_kind = 'C203_1' /*计量支付*/
        GROUP BY e.sec_est_id;

      --更新已审批的累计/支付
      UPDATE tmp_pla_report r
      SET r.c17 =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                  pr.c50 = '概算与分项对应-累计计量/支付' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                   pr.c50 = '概算与分项对应-累计计量/支付' AND pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '概算与分项对应-累计计量/支付' AND t.c45 = v_PRJ_SEG_ID;

      --4--概算范本与清单范本的统计
      --4-1-合同量的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c42, c44, c45, c50)
        SELECT se.sec_est_id,
               SUM(NVL(elt.rate, 0) * NVL(l.cnt_amount, 0) / 100) sumM,
               SUM(NVL(elt.rate, 0) * NVL(l.cnt_currency, 0) / 100) sumC,
               1 isSigned, v_PRJ_SEG_ID, '清单范本对应概算范本-合同量' rsType
        FROM FEE_Section_Estimate se, BAS_Estimate_Template et,
             FEE_Estimate_Listing_Template elt, BAS_Listing_Template lt,
             CNT_LOT_Listing l, CNT_Contract c
        WHERE se.est_tmp_id = et.est_tmp_id AND
              et.est_tmp_id = elt.est_tmp_id AND
              elt.list_tmp_id = lt.list_tmp_id AND
              lt.list_tmp_id = l.list_tmp_id AND l.cnt_id = c.cnt_id AND
              c.status = 'C175_2' /*已审批*/
              AND c.Pay_kind = 'C203_1' /*计量支付*/
              AND se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY se.sec_est_id
        UNION ALL
        SELECT se.sec_est_id,
               SUM(NVL(elt.rate, 0) * NVL(l.cnt_amount, 0) / 100) sumM,
               SUM(NVL(elt.rate, 0) * NVL(l.cnt_currency, 0) / 100) sumC,
               0 isSigned, v_PRJ_SEG_ID, '清单范本对应概算范本-合同量' rsType
        FROM FEE_Section_Estimate se, BAS_Estimate_Template et,
             FEE_Estimate_Listing_Template elt, BAS_Listing_Template lt,
             CNT_LOT_Listing l, CNT_Contract c
        WHERE se.est_tmp_id = et.est_tmp_id AND
              et.est_tmp_id = elt.est_tmp_id AND
              elt.list_tmp_id = lt.list_tmp_id AND
              lt.list_tmp_id = l.list_tmp_id AND l.cnt_id = c.cnt_id AND
              c.status = 'C175_1' /*未审批*/
              AND c.Pay_kind = 'C203_1' /*计量支付*/
              AND se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY se.sec_est_id;

      --更新已审批的合同量
      UPDATE tmp_pla_report r
      SET (r.c7, r.c8) =
           (SELECT pr.c41, pr.c42
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                  pr.c50 = '清单范本对应概算范本-合同量' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                   pr.c50 = '清单范本对应概算范本-合同量' AND pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的合同量
      UPDATE tmp_pla_report r
      SET r.c10 =
           (SELECT pr.c42
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND
                  pr.c50 = '清单范本对应概算范本-合同量' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND
                   pr.c50 = '清单范本对应概算范本-合同量' AND pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '清单范本对应概算范本-合同量' AND t.c45 = v_PRJ_SEG_ID;

      --4-2-变更量的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c42, c43, c44, c45, c50)
        SELECT se.sec_est_id,
               SUM(NVL(elt.rate, 0) * NVL(l.Change_Amount, 0) / 100)
               /*变更数量*/,
               SUM(NVL(elt.rate, 0) * NVL(l.Change_Currency, 0) / 100)
               /*变更金额*/,
               SUM(NVL(elt.rate, 0) *
                    (NVL(l.Finally_Currency, 0) + NVL(l.Change_Currency, 0)) / 100)
               /*变更后金额*/, 1 isSigned, v_PRJ_SEG_ID, '清单范本对应概算范本-变更量' rsType
        FROM FEE_Estimate_Listing_Template elt, BAS_Estimate_Template et,
             BAS_Listing_Template lp, FEE_Section_Estimate se,
             CNT_LOT_Listing l, cnt_contract c
        WHERE elt.est_tmp_id = et.est_tmp_id AND
              elt.list_tmp_id = lp.list_tmp_id AND
              et.est_tmp_id = se.est_tmp_id AND
              lp.list_tmp_id = l.list_tmp_id AND l.cnt_id = c.cnt_id AND
              c.Pay_kind = 'C203_2' /*非计量支付*/
              AND se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY se.sec_est_id; /*已审批的直接从合同清单中取变更量...*/

      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT se.sec_est_id,
               SUM(NVL(elt.rate, 0) * NVL(l.sumADDC_Currency, 0) / 100),
               0 isSigned, v_PRJ_SEG_ID, '清单范本对应概算范本-变更量' rsType
        FROM FEE_Estimate_Listing_Template elt, BAS_Estimate_Template et,
             BAS_Listing_Template lp, FEE_Section_Estimate se,
             (SELECT cl.lot_list_id, ll.list_tmp_id,
                      SUM(NVL(cl.Declare_After_Currency, 0) -
                           NVL(cl.Before_Currency, 0)) sumADDC_Currency /*未批变更金额*/
               FROM CNT_CHNG_Listing cl, CNT_CHNG cg, CNT_LOT_Listing ll,
                    cnt_contract c
               WHERE cl.chng_id = cg.chng_id AND
                     ll.lot_list_id = cl.lot_list_id AND ll.cnt_id = c.cnt_id AND
                     cg.status = 'C175_1' /*正在审批中...*/
                     AND c.Pay_kind = 'C203_1' /*计量支付*/
               GROUP BY cl.lot_list_id, ll.list_tmp_id) l
        WHERE elt.est_tmp_id = et.est_tmp_id AND
              elt.list_tmp_id = lp.list_tmp_id AND
              et.est_tmp_id = se.est_tmp_id AND
              lp.list_tmp_id = l.list_tmp_id AND
              l.list_tmp_id = lp.list_tmp_id AND
              se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY se.sec_est_id;

      --更新已审批的变更量
      UPDATE tmp_pla_report r
      SET (r.c13, r.c14, r.c16) =
           (SELECT pr.c41, pr.c42, pr.c43
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                  pr.c50 = '清单范本对应概算范本-变更量' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                   pr.c50 = '清单范本对应概算范本-变更量' AND pr.c45 = v_PRJ_SEG_ID);

      --更新未审批的变更量
      UPDATE tmp_pla_report r
      SET (r.c15) =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND
                  pr.c50 = '清单范本对应概算范本-变更量' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '0' AND
                   pr.c50 = '清单范本对应概算范本-变更量' AND pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '清单范本对应概算范本-变更量' AND t.c45 = v_PRJ_SEG_ID;

      --4-3-计量与支付的统计
      INSERT INTO tmp_pla_report
        (c40, c41, c44, c45, c50)
        SELECT se.sec_est_id,
               SUM(NVL(elt.rate, 0) * NVL(f.sumFinished_Currency, 0) / 100),
               1 isSigned, v_PRJ_SEG_ID, '清单范本对应概算范本-累计计量/支付' rsType
        FROM FEE_Estimate_Listing_Template elt, BAS_Estimate_Template et,
             BAS_Listing_Template lp, FEE_Section_Estimate se,
             (SELECT p1.lot_list_id, l.list_tmp_id,
                      SUM(NVL(p1.CNT_Currency_Approval1, 0) +
                           NVL(p1.Change_Currency_Approval1, 0)) sumFinished_Currency
               FROM CNT_Listing_Payment1 p1, CNT_PMNT p, cnt_contract c,
                    cnt_lot_listing l
               WHERE p1.pmnt_id = p.pmnt_id AND p.cnt_id = c.cnt_id AND
                     p1.lot_list_id = l.lot_list_id AND p.status = 'C175_2' /*已审批*/
                     AND c.Pay_kind = 'C203_1' /*计量支付*/
               GROUP BY p1.lot_list_id, l.list_tmp_id) f
        WHERE elt.est_tmp_id = et.est_tmp_id AND
              elt.list_tmp_id = lp.list_tmp_id AND
              et.est_tmp_id = se.est_tmp_id AND
              lp.list_tmp_id = f.list_tmp_id AND
              f.list_tmp_id = lp.list_tmp_id AND
              se.prj_seg_id = v_PRJ_SEG_ID
        GROUP BY se.sec_est_id;

      --更新已审批的累计/支付
      UPDATE tmp_pla_report r
      SET r.c17 =
           (SELECT pr.c41
            FROM tmp_pla_report pr
            WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                  pr.c50 = '清单范本对应概算范本-累计计量/支付' AND pr.c45 = v_PRJ_SEG_ID)
      WHERE r.c50 = '临时结果' AND r.c45 = v_PRJ_SEG_ID AND EXISTS
       (SELECT 1
             FROM tmp_pla_report pr
             WHERE pr.c40 = r.c2 AND pr.c44 = '1' AND
                   pr.c50 = '清单范本对应概算范本-累计计量/支付' AND pr.c45 = v_PRJ_SEG_ID);

      DELETE FROM tmp_pla_report t
      WHERE t.c50 = '清单范本对应概算范本-累计计量/支付' AND t.c45 = v_PRJ_SEG_ID;

      --5 对于计算类型概算,将按概算中设置的公式进行计算
      P_FEE_EST_EXEC_Sub_STAT(v_PRJ_SEG_ID);

      --6 计算累计完成比例
      UPDATE tmp_pla_report r
      SET c18 = to_number(c17) / to_number(c8)
      WHERE to_number(NVL(c8, 0)) <> 0 AND c18 IS NULL AND
            r.c45 = v_PRJ_SEG_ID AND r.c50 = '临时结果';

    END IF;
  END LOOP;

  --产生统计结果明细
  INSERT INTO fee_estimate_execute_detail
    (est_exe_dtl_id, sec_est_id, est_exe_main_id, budget_amount_major,
     budget_amount_minor, budget_currency, CNT_Amount, CNT_Currency,
     CNT_Currency_Sub, CNT_Currency_UnSign, Emend_Amount, Emend_Currency,
     Change_Amount, Change_Currency, Change_Currency_Unsigned,
     Change_Currency_After, Finished_Currency, Finished_Rate,
     Final_Cost_Amount, Final_Cost_Currency)
    SELECT c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15,
           c16, c17, c18, c19, c20
    FROM tmp_pla_report e
    WHERE e.c50 = '临时结果';

  COMMIT;
EXCEPTION
  WHEN OTHERS THEN
    --事务回滚
    ROLLBACK;
    --    RAISE;

    dbms_output.put_line('error code is:' || SQLCODE ||
                         ', error message is:' || substr(SQLERRM, 1, 200));
END;

jiarch
关注
444444
m0_65129784的博客
06-25 56
以上代码使用了Java 8中的LocalDate和Period类来计算年龄。其中，LocalDate类表示日期（不包括时间和时区），Period类表示两个日期之间的时间差。
aa44444444444
qq_38053830的博客
11-03 120
1.矩阵 a=[1 2; 3 4; 5 6] a(m, n) 第m行第n列的元素 a( : , m) 第m列所有元素 a(m:n, p:q) m到n行，p到q列内的所有元素 2.syms 定义符号变量 eval(x) 计算表达式的值 3.plot(x,y) y关于x的二维图,x、y为矩阵或向量 4.ezplot 绘制表达式的图形，后面要加变量的取值范围，常用于隐函数的绘制 ezplot(x,y,[0,2*pi]) x ...
6、面向对象编程（下）
qq_44774198的博客
07-03 1311
当我们编写一个类时，其实就是在描述其对象的属性和行为，而并没有产生实质上 的对象，只有通过new关键字才会产生出对象，这时系统才会分配内存空间给对象， 其方法才可以供外部调用。我们有时候希望无论是否产生了对象或无论产生了多少 对象的情况下，某些特定的数据在内存空间里只有一份，例如所有的中国人都有个 国家名称，每一个中国人都共享这个国家名称，不必在每一个中国人的实例对象中 都单独分配一个用于代表国家名称的变量。 1.static:静态的。 2.static 可以用来修饰:属性、方法、代码块、内部类。 3.使
计算机网络课后题——第七章 互联网的应用层
y44444444444的博客
03-14 548
1.简述DNS的域名解析过程。 一台主机要将域名转换为IP地址，首先要向本地域名服务器查询，若查询不到，则本地域名服务器向一个根域名服务器查询，根域名服务器告诉本地域名服务器下一个要查询的顶级域名服务器dns.com的IP地址，本地域名服务器向顶级域名服务器查询，顶级域名服务器告诉本地域名服务器下一次应查询的权限域名服务器的IP地址，经过对几个权限域名服务器的查询后，一个权限域名服务器会给出所查询主机的IP地址。 2.简述HTTP持续连接的请求与响应过程。{269} 浏览器先与服务器上的端口80建立一个TC
ffmpeg将常见视频格式转换为mp4
y44444444444的博客
11-02 4437
1，avi、mkv、mp4等格式转为mp4 ffmpeg -i input.avi -c copy output.mp4 2，wmv、asf、rmvb等格式转为mp4 ffmpeg -i input.asf output.mp4
关于解决win10 Shift+右击无法打开命令行工具问题
qq_39492175的博客
10-13 2283
关于解决win10 Shift+右击无法打开命令行工具问题 随着win10的逐渐流行，微软尝试使用更强大的powershell取代目前的cmd，但各有优缺点，cmd占据内存更小，启动响应速度更快。这里提出一种修改方法可以提供给大家参考： 新建文本 ，输入以下代码； Windows Registry Editor Version 5.00 [HKEY_CLASSES_ROOT\Directory\Background\shell\OpenCmdHere] @="在此处打开命令行窗口" "Exten
初次安装tomcat遇到的问题
chenchenb414的博客
12-19 412
1、tomcat的安装 其实安装很简单，只需要下载安装包解压便可，在官网进行下载就行，可以根据自己的电脑配置进行安装包的下载。 官网地址： https://tomcat.apache.org  本人电脑是64位的，就下载图示中安装包，前两位不确定是不是Linux系统安装包，自己也未进行尝试，下载安装后，进行解压。在bin目录下有tomcat7w.exe 双击运行便可。
腾讯模拟面试红包问题解答
weixin_30918633的博客
03-27 86
问题描述 同学X喜欢玩微信红包，然后年后统计自己的红包收入，发现有这样一个问题： 一共收了N个红包，然后其中金额为k的红包出现次数大于N/2;让你写程序求解k值（要求程序足够优化） 问题分析： 这个题目明确告诉我们，所求为出现次数大于一半的，也就是最多的那个份额。也就是数学里众数这个概念了，且这个题目中更明确规定了，这个众数是大于总数的一半的。 在这个明确的条件之后，更是要求我们的...
44444444444.zip_Windows编程_Visual_C++_
08-11
在本项目中，我们主要探讨的是使用Visual C++在Windows平台上实现一个通讯录程序。这个程序基于C++语言，利用了线性表的数据结构来存储和管理联系人信息。线性表是一种基本的数据结构，它允许我们在数组或链表的基础...
杭电-1717-杭电-1717-小数化分数2
小熊的博客
03-13 701
小数化分数2 Time Limit: 1000/1000 MS (Java/Others)    Memory Limit: 32768/32768 K (Java/Others) Total Submission(s): 4220    Accepted Submission(s): 1702 Problem Description Ray 在数学课上听老师说，任何小数都
const addCollapsedFlag=(data, level = 1, maxLevel = 3)=>{ for (let i = 0; i < data.length; i++) { const item = data[i]; // 如果当前层级大于最大层级，给当前项添加 collapsed 标识 if (level > maxLevel) { console.log(222); item.collapsed = true; } else if (item.children) { console.log(3333); // 如果当前项有 children，继续递归遍历 children addCollapsedFlag(item.children, level + 1, maxLevel); } } } taskUnitService.statisticsSearchList(searchKeys) .then((resp) => { if (resp.length > 0) { let args = {} as any; args["name"] = item?.goodsName args["children"] = resp args["stairStatus"] = 3 addCollapsedFlag(args) console.log(args,"44444444444"); setDeviceData([args]) } else { setDeviceData(resp) } }) .finally(() => setIsLoading(false) );为什么没有打印2222 3333
最新发布
06-17
根据你提供的代码，函数 `addCollapsedFlag` 中的 `console.log(222)` 和 `console.log(3333)` 只有在特定条件下才会被执行，即当前层级大于最大层级时会打印 `222`，当前项有 children 时会打印 `3333`。...
import java.util.ArrayList; import java.util.Scanner; public class User { private String phoneNumber; private String password; private String email; ArrayList<User> users = new ArrayList<>(); Scanner scanner = new Scanner(System.in); public User() { users.add(new User("12345678910", "123456","1234567890@qq.com")); users.add(new User("10987654321", "234567","0987654321@163.com")); users.add(new User("10086100106", "345678","1241433241@126.com")); users.add(new User("44444444444", "456789","1732215351@yeah.net")); users.add(new User("55555555555", "567890","8716237861@qq.com")); } public User(String phoneNumber, String password,String email) { this.phoneNumber = phoneNumber; this.password = password; this.email=email; } public String getPhoneNumber() { return phoneNumber; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getEmail() { return email; } public void setEmail(String email) { this.email = email; }构造一个方法printf，使其可以输出当前登录账户的账户名和邮箱号
05-29
你可以在User类中添加如下方法： ``` public void printf() { System.out.println("当前登录账户： " + this.getPhoneNumber() + "， 邮箱号： " + this.getEmail()); } ``` 当用户登录成功后，调用该方法即可...
K8s 很难么？带你从头到尾捋一遍，不信你学不会
民工哥的博客
02-23 9035
点击关注公众号，回复“1024”获取2TB学习资源！为什么要学习 Kubernetes?虽然 Docker 已经很强大了，但是在实际使用上还是有诸多不便，比如集群管理、资源调度、文件管理等...
10天智能锁项目实战第1天（了解单片机STM32F401RET6和C语言基础）
北豼不太皮的博客
02-21 3583
10天智能锁项目实战第1天（了解单片机STM32F401RET6和C语言基础）一、学习目标二、了解单片机STM32F401RET6三、C语言基础 一、学习目标 二、了解单片机STM32F401RET6 4、STM32F401RE特征 三、C语言基础 1.数据类型 常用2的次方： 2^7 = 128 2^8 = 256 2^15 = 32768 2^16= 65536 51单片机常见的数据类型： char: 占内存1字节 取值范围：-128~127 -2^7 ~ 2
Android开发（1） | Fragment 的应用——新闻应用
Jormungand_V的博客
02-21 7091
文章目录 news_item.xml： <TextView xmlns:android="http://schemas.android.com/apk/res/android" android:id="@+id/news_title" android:layout_width="match_parent" android:layout_height="wrap_content" android:lines="1" android:ellipsize="
系统学习 TypeScript（四）——变量声明的初步学习
编程三昧
02-25 1734
认识了 TypeScript 中的基础类型，接下来当然是变量声明的相关学习了，我在这里记录一下我学习过程中的一些总结。
清除浮动的五种方法
weixin_52212950的博客
02-22 2704
为什么要清除浮动？因为往往浮动后的子元素因为脱离了标准流，不能自动撑起父元素的高度，所以会对后续布局产生影响，对此清除浮动不如理解为清除浮动产生的影响更为合理。 例如：我们设置了两个盒子如图所示，粉色为父盒子，只有宽度没有高度，蓝色盒子有宽有高，粉色盒子的高由蓝盒子的高度撑开。 但是给蓝色的子盒子设置了左浮动后，脱离了标准流，无法再撑开粉盒子，可以看到粉盒子高度变成了0； 清除浮动有五种方法： 直接设置父元素的高度 额外标签法 单伪元素法 双伪元素法 ove.
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值