AAA

1. Lỗi TNS
   Cấu hình ht_dns (file and database);
2. Lỗi bấm menu (giao diện) không có sự kiện
   Cấu hình bảng Kh_nsd_tso
   ----- TRUONG HOP 8008
   UPDATE "TCDN_MOI"."HT_DNS" SET IP = '172.16.50.5', PAS = 'Vdi2024', DB = 'ORCLCDB' WHERE DBO = 'TCDN_MOI'...

-- TẠO TÀI KHOẢN NGƯỜI DÙNG

Insert into HT_LOGIN (MA,PAS,IDVUNG,QU,TGIAN,NLOI) values ('110/1',null,0,'C',to_date('16-DEC-16','DD-MON-RR'),0);
Insert into HT_LOGIN (MA,PAS,IDVUNG,QU,TGIAN,NLOI) values ('110/2',null,0,'C',to_date('16-DEC-16','DD-MON-RR'),0);...

create table bh_phh_phi_dk_bak as select * from bh_phh_phi_dk; drop table bh_phh_phi_dk; CREATE TABLE bh_phh_phi_dk (ma_dvi varchar2(10), so_id number, bt number, ma varchar2(10), tc varchar2(1), ma_ct varchar2(10), -- Ma cap tren tien number, pt number, phi number, lkeP varchar2(1), lkeB varchar2(1), ma_dk varchar2(10), ma_bs varchar2(10), lh_nv varchar2(10), t_suat number, cap number, constraint bh_phh_phi_dk_p primary key (so_id,ma)); insert into bh_phh_phi_dk(ma_dvi , so_id , bt , ma , tc , ma_ct , -- Ma cap tren tien , pt , phi , lkeP , lkeB , ma_dk , ma_bs , lh_nv , t_suat , cap ) select * from bh_phh_phi_dk_bak; drop table bh_phh_phi_dk_bak; commit;

I. Số HĐ mẫu (8008):

1. Cháy nổ bắt buộc:
   |.STT|.Loại|.1 địa điểm|.Nhiều địa điểm|
   |1|GCN|||
   |2|Hợp đồng|240703000006||
   |3|Chào phí|240703000005||

II. Số HĐ mẫu (8009):

1. Cháy nổ bắt buộc:
   |.STT|.Loại|.1 địa điểm|.Nhiều địa điểm|...

Lưu ý:
Điều khoản: có dòng tổng
Cá nhân

1. healthcare cá nhân

• tái tục theo hđ số: ô kiểu GCN

• quy tắc: theo danh mục sản phẩm

• người được bảo hiểm

• nếu không có người được bảo hiểm thì lấy luôn người mua bảo hiểm

• điều khoản:

• điều khoản chính: > ghi chú > ksbt > bổ sung...

Product Code: ljlhvcmfdewhugsaz4c9faldmv5trlexvv Serial Number: 131746 Password :xs374ca

1. File generate ra command window chạy trong plsql
   !clipboard-202408270156-xbqvd.png!

2. chạy lệnh file python để generate ra file script chứa các file .sql có dạng
   @C:\Workspace\BH\AAA\SourceCode\v2\bh-aaa-v2\WBH_MIC\SQL\Baohiem\2b\bh_2b.sql...

h1. VPN

vpn aaa:

• Server: vpndc01.aaa.com.vn
• Auth Type: Standard Password Authentication
• User: bss
• Pass: Bss)@2024
• Hub: 3RD

tar -czvf aaa_241014_v1.tar.gz tcdn_moi_adan_241014_v1.dmp

tar -xzvf aaa_241014_v1.tar.gz

h1. https://www.howtogeek.com/248780/how-to-compress-and-extract-files-using-the-tar-command-on-linux/

h1. impdp
Trường hợp dump lại toàn bộ - xóa thủ công không xóa schema (không có quyền)...

ALTER TABLE bh_phh_dk RENAME TO bh_phh_dk_old;
CREATE TABLE bh_phh_dk (
ma_dvi varchar2(10),
so_id number,
so_id_dt number,
bt number,
ma varchar2(10),
ten nvarchar2(500),
tc varchar2(1),
ma_ct varchar2(10), -- Ma cap tren...

create or replace procedure PBH_XEH_TESTr(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_idG number,
    dt_ct in out clob,dt_ds in out clob,
    b_so_hdL out varchar2,
    ds_so_id out pht_type.a_num,ds_kieu_gcn out pht_type.a_var,ds_gcn out pht_type.a_var,ds_gcnG out pht_type.a_var,
...

create or replace procedure PBH_HD_DU_GOC(
    b_ma_dviN varchar2,b_nsdN varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(2000); b_i1 number;
...

create or replace procedure PBH_SK_BENH_CAY(b_ma varchar2, b_tim nvarchar2)
AS
    b_maN varchar2(50);
begin
-- viet anh - Liet ke theo cay -- dang lam
insert into kh_cay select ma,ten,tc,to_char(muc) from bh_sk_benh where ma_ct=b_ma 
...

create or replace procedure PBH_HIEU_HANG_HOI_LIST(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob, b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_gtri nvarchar2(500);
...

create or replace procedure PBH_MA_TPA_NGSK_LISTt(b_nv varchar2,b_nhom varchar2,b_lay_all varchar2)
AS
    b_ngay number:=PKH_NG_CSO(sysdate);
begin
  -- viet anh
insert into temp_1(c1,c2,c3)
...

create or replace procedure PBH_XE_BPHId_THEM(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(1000); b_lenh varchar2(1000); b_so_id number; b_i1 number; b_i2 number;
...

create or replace procedure PBH_2BG_CT(
    b_ma_dviN varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_i1 number;
    b_ma_dvi varchar2(10); b_so_id number; b_so_idD number; b_so_idP number;
...

create or replace procedure PTBH_NHA_BH_CN_XOA_XOA(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_id number,b_loi out varchar2)
AS
    b_l_ct varchar2(1); b_ngay_ht number; b_nha_bh varchar2(20);
    b_ma_nt varchar2(5); b_tien number; b_tien_qd number; b_nsd_c varchar2(10); b_so_id_kt number;
...

create or replace procedure PBH_BT_DU_LKE(
    b_ma_dviN varchar2,b_nsdN varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(1000); b_lenh varchar2(2000); b_i1 number;
    b_nv varchar2(10); b_ma_dvi varchar2(10); b_phong varchar2(10); b_ttrang varchar2(1); b_loc varchar2(10);
...

create or replace procedure PTBH_XOL_LKE_ID(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_so_hd varchar2(20);
...

create or replace procedure PBH_BT_GD_TTRANG_HS_MAU
    (b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000);
    b_i1 number; b_tt varchar2(1); b_ngay_qd number;
...

create or replace function FBH_SK_GOI_TENl(b_ma varchar2) return nvarchar2
AS
    b_kq nvarchar2(500);
begin
-- viet anh
select min(ma||'|'||ten) into b_kq from bh_sk_goi where ma=b_ma;
return b_kq;
...

drop table ht_tso_hd;
create table ht_tso_hd
    (ma varchar2(10),
    ten nvarchar2(500),
    tgian number);
/
create or replace procedure FHT_TSO_HD_TG_NH
    (b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob)
...

create or replace procedure PBH_DTAC_MA_NHnf(
    b_oraIn clob,b_ma in out varchar2,b_ps out varchar2,b_loi out varchar2,b_ma_dviN varchar2:='',b_nsdN varchar2:='')
AS
    b_lenh varchar2(1000); b_i1 number; b_tenH varchar2(500); b_tenL varchar2(100):=' ';
...

drop table bh_ktra_ddai;
create table bh_ktra_ddai(
    email varchar2(100),
    ten_en nvarchar2(500),
    dchi_en nvarchar2(500),
    fax varchar2(20),
...

drop table tbh_tmb_phi;
create table tbh_tmb_phi(
    so_id number,
    nbh varchar2(20),
    nbhC varchar2(20),
    ma_ta varchar2(20),
    pt number,
...

delete hd_ma_nhom;
delete hd_ma_hd;
delete hd_sc;
delete hd_1;
delete hd_2;
delete hd_3;
delete hd_sc_bc_so;
delete from hd_ma_hd;
commit;

h1. CREATE USER LOCAL
alter session set container=ORCLPDB1;
alter session set "_ORACLE_SCRIPT"=true;
alter session set container = cdb$root;
CREATE USER TCDN_MOI_ADAN_GOC IDENTIFIED BY Vdi2024 CONTAINER=ALL;
grant all privileges to TCDN_MOI_ADAN_GOC;...

redmine¶

/opt/redmine/config/configuration.yml

!clipboard-202405170831-u90hs.png!

BEGIN

EXCEPTION
    WHEN OTHERS THEN
        DBMS_OUTPUT.PUT_LINE('Error: ' || SQLERRM);
        b_txt := 'Error occurred';
END;

I. Số GCN/HĐ mẫu (8008):

1. Cá nhân:

• 240613000019 (Full)

2. Gia đình:

• 240626000072 (Full HD bản đẹp)
• 240614000014 (1 người - Full)
• 240614000009 (1 người - Có ĐKBS, ĐKLT)
• 240617000004 (3 người - test gộp nhóm 1 gói, mức trách nhiệm, quyền lợi khác nhau)...

-- pull orgin
git push origin --delete adan
git remote prune origin
git fetch --all

-- lỗi ssl
git config --global http.sslVerify false

--RUN
python .\convert_json.py

/** INSERT - THAM SO TRUYEN VAO**/
-- 1 gen len insert. Su dung danh sach bien cho ham cha goi
DECLARE
v_sql VARCHAR2(4000); -- export query
v_columns VARCHAR2(4000); -- columns name
v_values VARCHAR2(4000); -- values name
v_table_name VARCHAR2(100):= 'BH_HH';...

create table ht_ma_dvi_tmp as select * from ht_ma_dvi
/
drop table HT_MA_DVI;
/
CREATE TABLE HT_MA_DVI
(
  MA                              VARCHAR2(20 BYTE),
...

create or replace procedure PBH_XEH_TESTr(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_idG number,
    dt_ct in out clob,dt_ds in out clob,
    b_so_hdL out varchar2,
    ds_so_id out pht_type.a_num,ds_kieu_gcn out pht_type.a_var,ds_gcn out pht_type.a_var,ds_gcnG out pht_type.a_var,
...

create or replace procedure PBH_HD_DU_GOC(
    b_ma_dviN varchar2,b_nsdN varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(2000); b_i1 number;
    b_ma_dvi varchar2(10); b_so_id number; b_nv varchar2(10); b_nvG varchar2(10);
...

create or replace noneditionable procedure PBH_BT_GD_TTRANG_HS_1
    (b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000);
...

create or replace procedure PBH_MA_NGDD_HOI_LIST(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob, b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_gtri nvarchar2(500);
...

create or replace procedure PBH_2B_VACH(b_nv varchar2,b_gcn out varchar2,b_loi out varchar2)
AS
    b_i1 number;
begin
-- Dan - Tra so trong chuoi dang ky
b_loi:='loi:Loi xin so GCN:loi';
...

create or replace procedure PBH_PKT_MA_NCT_LKE(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_tu number; b_den number; b_tim nvarchar2(100);
...

create or replace procedure PBH_NGDLT_TESTr(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_idG number,
    nh_so_idC pht_type.a_num,nh_nhomC pht_type.a_var,
    dt_ct clob,dt_giam clob,dt_nh clob,dt_ds in out clob,

create or replace procedure PBH_NGDLG_TESTr(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_idG number,
    dt_ct clob,dt_dk clob,dt_dkbs clob,dt_ds in out clob,

    b_loai out varchar2,b_kvuc out varchar2,b_ma_sp out varchar2,b_cdich out varchar2,b_goi out varchar2,
...

create or replace procedure PBH_SKT_TESTr(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_idG number,
    nh_so_idC pht_type.a_num,nh_nhomC pht_type.a_var,
    dt_ct in out clob,dt_giam clob,dt_nh clob,dt_ds in out clob,dt_dvi in out clob,

create or replace procedure BC_HD_MAT
    (b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_ngayd number,b_ngayc number,
    b_kieu varchar2,b_loai_bp varchar2,b_ma_bp varchar2,b_ma varchar2,b_nhom varchar2,b_ten out nvarchar2,cs_kq out pht_type.cs_type)
...

create or replace procedure PBH_SKT_NH(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob,b_comm varchar2:='C')
AS
    b_loi varchar2(3000); b_lenh varchar2(2000); b_i1 number;
...

---- loi dklt nhieu so_id #3108
CREATE OR REPLACE procedure PBH_TAU_BPHId_THEM(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(1000); b_lenh varchar2(1000); b_nv varchar2(10); b_so_idS varchar2(500); b_pphiS varchar2(500);
...

create or replace procedure PTBH_TM_NH_TEST(
    b_so_id number,dt_ct clob,dt_hd clob,dt_bh clob,dt_phi clob,
    b_nv out varchar2,b_ngay_ht out number,b_so_ct out varchar2,b_kieu out varchar2,b_so_ctG out varchar2,
...

create or replace procedure PBH_HD_TT_NH_VAT_DO(
    b_ma_dvi varchar2,b_nsd varchar2,b_so_id_tt number,b_ngay_ht number,b_phong varchar2,b_nha_bh varchar2,
    b_ma_nt varchar2,b_so_don varchar2,b_ngay_bc number,b_loi out varchar2)
...

create or replace function FTBH_MGIU_GLAI(
    b_ma_dvi varchar2,b_so_id number,b_lh_nv varchar2,b_ma_dt varchar2,
    b_nt_ta varchar2,b_do_tl number,b_ve_tl number,b_ngay number) return number
AS
    b_i1 number; b_ma_nt varchar2(5); b_kieu varchar2(3):='C';
...

create or replace procedure PBH_PHHH_TESTd(
    dt_ctH clob,dt_ct in out clob,dt_dk clob,dt_dkbs clob,dt_pvi clob,
    b_ma_dvi varchar2,b_nsd varchar2,b_ttrang varchar2,b_kieu_hd varchar2,b_ma_sp varchar2,b_cdich varchar2,b_goi varchar2,
...

delete from bh_cp_pt ;
delete from bh_hd_do_ps where loai IN('C','T');
commit;

CREATE OR REPLACE procedure PTBH_HD_DI_NH(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(2000); b_i1 number; b_i2 number; b_pt number:=0;
...

drop function FHT_MA_NSD_TENl
/
CREATE OR REPLACE function FHT_MA_NSD_TENl(b_ma_dvi varchar2,b_nsd varchar2) return nvarchar2
AS
    b_kq nvarchar2(500):='';
begin
-- Dan - Tra ten NSD
...

create or replace procedure PBH_PHHH_TESTd(

    dt_ctH clob,dt_ct in out clob,dt_dk clob,dt_dkbs clob,dt_pvi clob,

    b_ma_dvi varchar2,b_nsd varchar2,b_ttrang varchar2,b_kieu_hd varchar2,b_ma_sp varchar2,b_cdich varchar2,b_goi varchar2,

create or replace procedure PBH_THL_PHI_NBH(
    b_ma_dvi varchar2,b_so_id number,b_loi out varchar2)
As
    b_ma_nt varchar2(5); b_ngay_ht number; b_tp number; b_tien number;
begin
-- Dan - Tong hop lai phi nha lead, nhan tai tam thoi
...

CREATE OR REPLACE procedure PBH_HD_UP_XOA(
    b_ma_dvi varchar2,b_so_id number,b_dvi_ksoatN varchar2,b_ksoatN varchar2,b_loi out varchar2,b_du varchar2:='K')
AS
    b_lenh varchar2(1000); b_i1 number; b_i2 number; b_so_hd varchar2(20);
...

CREATE OR REPLACE procedure PBH_HD_UP_XOA(
    b_ma_dvi varchar2,b_so_id number,b_dvi_ksoatN varchar2,b_ksoatN varchar2,b_loi out varchar2,b_du varchar2:='K')
AS
    b_lenh varchar2(1000); b_i1 number; b_i2 number; b_so_hd varchar2(20);
...

create or replace procedure PBH_TAUG_NH(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob,b_comm varchar2:='C')
AS
    b_loi varchar2(3000); b_lenh varchar2(2000); b_i1 number;
...

CREATE OR REPLACE procedure PBH_HD_DO_TT_HD(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(2000); b_nha_bh varchar2(20); cs_ton clob:='';
...

create or replace procedure PBH_HD_HH_NH_NH
    (b_ma_dvi varchar2,b_nsd varchar2,dt_ct clob,
    b_so_id_hh number,b_ngay_ht number,b_ma_dl varchar2,b_pt_tra varchar2,b_ttoan_qd number,b_thue_qd number,b_phong varchar2,
...

CREATE OR REPLACE procedure PBH_PHH_LKE(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_phong varchar2(10);
    b_ngay_ht number; b_nv varchar2(1); b_klk varchar2(1); b_tu number; b_den number;
...

create or replace procedure PBH_PTN_HD_DU(
    b_ma_dvi varchar2,b_so_id number,b_ma_dvi_ks varchar2,b_nsd_ks varchar2,
    b_ttrang varchar2,b_so_hd out varchar2,b_loi out varchar2)
AS
    b_i1 number; b_nv varchar2(10); b_txt clob;
...

create or replace procedure PHT_MA_NSDJ_LKE(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(1000); b_tu number; b_den number; b_md varchar2(10):='BH'; b_dvi varchar2(500); b_tim varchar2(500);
...

create or replace procedure PBH_BT_GD_HS_LKE(
    b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_lenh varchar2(2000);
    b_so_hs_bt varchar2(20); b_ngay_ht number; b_klk varchar2(1); b_tu number; b_den number; b_phong varchar2(10);
...

create or replace function FBH_BAO_BGHD_PTN(b_ma_dvi varchar2,b_so_id number) return varchar2
AS
    b_kq varchar2(2):=' '; b_i1 number;
begin
-- Nam - Tra da chuyen HD
select count(*) into b_i1 from bh_ptncc where ma_dvi=b_ma_dvi and so_id=b_so_id;
...

create or replace procedure PHD_HOI_TON
    (b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,
    loai_n varchar2,ma_n varchar2,b_ma_hdac varchar2,cs_lke out pht_type.cs_type)
AS
    b_loi varchar2(100);
...

create or replace procedure PBH_HANG_MA_CANG_CT
    (b_ma_dvi varchar2,b_nsd varchar2,b_pas varchar2,b_oraIn clob,b_oraOut out clob)
AS
    b_loi varchar2(100); b_kq clob; b_ma varchar2(10):=FKH_JS_GTRIs(b_oraIn,'ma');
...

CREATE TABLE bh_tau_ppcap
    (ma_dvi varchar2(10),
    nhom varchar2(10),
    loai varchar2(10),
    nv_bh varchar2(1),             -- V-Vat chat, T-trach nhiem, N-nguoi, M-Bo sung
...

create table bh_tau_ID(
    tau_id number,
    ten nvarchar2(500),
    cmt varchar2(20),
    mobi varchar2(20),
    email varchar2(100),
    dchi nvarchar2(500),
...

create or replace procedure PTBH_BAO_NV_PKT(
    b_so_idT number,b_ma_dvi varchar2,b_so_id number,b_so_id_dtB number,
    a_ma_dvi pht_type.a_var,a_so_id pht_type.a_num,a_so_id_dt pht_type.a_num,
    b_ma_dt out varchar2,b_loi out varchar2)
...