Project

General

Profile

Production Ticket(ST) #12101

GOLDCREST - help to add the customer branch code

Added by Rashdan Hussin 3 months ago. Updated 3 months ago.

Status:
Ticket Resolved
Priority:
P3 - Medium
Assignee:
Rashdan Hussin
Start date:
26/06/2024
Due date:
28/06/2024
% Done:

100%

Estimated time:
Spent time:
1.00 h
Job Remark:
Ticket Logged Date:
26/06/2024
Ticket No.:
Related Ticket ID:
Type:
Support Request
SLA Initial Response:
26/06/2024
SLA Delivery:
28/06/2024
Esclation Time:
Issue Reoccurance#:
Actual Initial Response:
26/06/2024
Resolution:

1) Review and verify all the data in the excel file provided.
2) Insert all the data into server.

Root cause: Update customer branch.

Requester ExpectedDeliveryDate:
Delay Justification:
Priority Seq:
Effort (Hour):
External Ticket #:

None

Description

hi, can help to add the customer branch code?

cd8998f9-b434-4a68-9d85-33f31f013afa.jpg (99.9 KB) cd8998f9-b434-4a68-9d85-33f31f013afa.jpg Rashdan Hussin, 26/06/2024 11:16 AM
Branch code for JNL & JNM.xlsx (106 KB) Branch code for JNL & JNM.xlsx Rashdan Hussin, 26/06/2024 11:17 AM

History

#1 Updated by Rashdan Hussin 3 months ago

  • Status changed from Assigned To to Support In Progress

select * from #TempTable --1301
select * from customer where org_id = 'GOLDCREST' order by updated_date desc --3835

select * from #TempTable where customer_code not in
(select customer_code from customer where org_id = 'GOLDCREST') --0

select b.area_code, * from customer a
inner join mst_area b on b.area_id = a.area_id and b.org_id = 'GOLDCREST'
where a.org_id = 'GOLDCREST'
and exists (select 1 from #TempTable r where r.customer_code = a.customer_code and r.area_code = b.area_code)

select * from mst_customer_branch where org_id = 'GOLDCREST'

select * from #TempTable a
inner join customer b on b.customer_code = a.customer_code and b.org_id = 'GOLDCREST'
where b.customer_id not in
(select customer_id from mst_customer_branch where org_id = 'GOLDCREST')

select a.customer_code, c.branch_code, * from customer a
inner join #TempTable b on b.customer_code = a.customer_code
inner join mst_branch c on c.branch_code = b.branch_code and c.org_id = 'GOLDCREST'
where a.org_id = 'GOLDCREST'

--select * into DMS_Ecosystem_Backup_Table.dbo._customer_20240626 from DMS_Ecosystem.dbo.customer

--update a set a.branch_id = c.branch_id, a.updated_date = getdate(), a.updated_by = 'Support'
--from customer a
--inner join #TempTable b on b.customer_code = a.customer_code
--inner join mst_branch c on c.branch_code = b.branch_code and c.org_id = 'GOLDCREST'
--where a.org_id = 'GOLDCREST'

select * from mst_customer_branch a
inner join customer b on b.customer_id = a.customer_id and b.org_id = 'GOLDCREST'
where a.org_id = 'GOLDCREST' and b.updated_date = '2024-06-26 11:04:41.033'

--select * into DMS_Ecosystem_Backup_Table.dbo._mst_customer_branch_20240626 from DMS_Ecosystem.dbo.mst_customer_branch

--update a set a.branch_id = b.branch_id, a.updated_date = getdate(), a.updated_by = 'Support'
--from mst_customer_branch a
--inner join customer b on b.customer_id = a.customer_id and b.org_id = 'GOLDCREST'
--where a.org_id = 'GOLDCREST' and b.updated_date = '2024-06-26 11:04:41.033'

#2 Updated by Rashdan Hussin 3 months ago

  • Status changed from Support In Progress to Pending Client Verification
  • % Done changed from 0 to 90
  • Actual Initial Response set to 26/06/2024
  • Resolution updated (diff)

#3 Updated by Rashdan Hussin 3 months ago

  • Status changed from Pending Client Verification to Ticket Resolved
  • % Done changed from 90 to 100

[14:11, 26/06/2024] Rashdan Hussin: Based on my developer feedback, customer branch will follow the salesman branch
[14:15, 26/06/2024] +60 12-734 5873: so next time no need update by my side right?
[14:22, 26/06/2024] Rashdan Hussin: Yes. If the customer have more than one salesman, the customer branch will take either one from the salesman branch
[14:22, 26/06/2024] +60 12-734 5873: ok thanks ya

Also available in: Atom PDF