---
# System prepended metadata

title: '**Project Nok-air2.0**'
tags: [BackUp]

---

# **Project Nok-air2.0**
----

<style> 
    .markdown-body{
        max-width:1500px
    }
    .div-mermaid{
        max-width:3000px
    }
</style>
###### tags: `BackUp`

# Information Nok-air business airline.:airplane:
----
* Power-point of Nok-air business airline.

<iframe width="100%" height="500" src="https://www.docdroid.net/CNohAUk/information-of-nok-air-bussniess-airline-pdf" frameborder="0"></iframe>





---
### Team member :briefcase:
```graphviz
digraph hierarchy {
                nodesep=0.25 // increases the separation between nodes
                node [color=black,fontname=Courier,shape=box] //All nodes will this shape and colour
                edge [color=ReD, style=dashed] //All the lines look like this
                Seniorteam->{Intern1 Intern2 Intern3 }
                 // Put them on the same level
}
```
---
# Project timeline:alarm_clock: 
---
<style> 
    .markdown-body{
        max-width:1200px
    }
    .div-mermaid{
        max-width:2000px
    }
</style>
```mermaid
 gantt
    
    title    Task List  
    excludes  weekends
    todayMarker stroke: blue 
    
    section Plan 
    
    User team talk        :done,2023-06-13,1d  
    Diagram               :crit,2023-06-14, 14d
    Presentation update Work (P.ton)      :done,2023-06-15,1d
    Presentation Nok-air (Team IRR) :done,milestone,2023-06-19,1d 
    Presentation Nok-air (Team Refund) :done,2023-06-19,1d 
    Presentation Nok-air (Team IRR) :done,milestone,2023-06-23,1d
    Presentation update Work (P.ton,P.keaw)    :done,2023-06-27,1d
    Presentation Nok-air (Team IRR) :active,milestone,2023-06-30,1d
    Presentation update Work (P.ton,P.keaw)    :active,2023-07-3,1d
    Presentation Nok-air(****) :active,2023-07-06,1d
    section Application
      Excel Sheet     :active,2023-07-21,14d
    Power apps      : crit,2023-06-16,3w
    User Test       :active, 2023-07-06,2023-07-21 
      
```   
---
 
 # Objective of this project :dart:
 
---

* To support the flight irregularity system for the NCT team, you would need to develop a web application with the following features:

* When there is a Flight IRR announcement, the authorized personnel responsible for updating flight status or relevant staff can perform the following actions:
    *  1.1 Sending SMS: Implement a functionality to send SMS notifications to passengers regarding flight irregularities.

    * 1.2 Sending Email: Develop a feature to send email notifications to passengers regarding flight irregularities.

    * 1.3 Select Assistance Options for passengers based on CAAT conditions:

*    Free flight change once
* Store credit for 100% of the fare for a certain period of time (generate and send email notification with conditions)
* Change the route
* Refund

     - 1)  The system should check the payment method used by passengers: 
    1.1 Cash: Prompt the user to enter bank account details (account number, account name, bank). If the payment was made by transferring to another person, allow attaching supporting documents.
    1.2 Credit card: Handle credit card refunds.
    1.3 Purchase through a distributor: Notify the contact person through the distributor within 45 business days.
    3) Once passengers submit their details for refund, the system should process the refund request.
    

    4) The finance department should send refund requests to the bank through the designated channels.

    5) The finance department should update the refund status in the system.

    6) The system should send SMS/email notifications to passengers when the refund is processed successfully.

    7) The system should maintain a log of all actions and transactions.
     
          
          To handle the compensation options of receiving either 600 baht or 1,200 baht, you can incorporate the following steps into the system:

       *  When passengers select the compensation option, provide a choice between receiving 600 baht (900 voucher) or 1,200  baht(1500 voucher).

        * If the passenger chooses cash compensation, prompt them to enter their bank account details, including account number, account name, and bank. If the compensation needs to be transferred to another person, allow them to attach the necessary supporting documents.

        *  Once the passenger submits the required details to receive the cash compensation, the system should process the request.

        7.5 The system should maintain a record of the bank account for further processing.

        7.6 The finance department should initiate the refund transaction to transfer the compensation to the provided bank account.

        7.7 The finance department should update the refund status in the system upon successful processing.

        7.8 The system should send SMS/email notifications to passengers once the cash compensation has been successfully transferred.

        7.9 If the passenger chooses voucher compensation, the system should generate a voucher along with the terms and conditions (T&C) associated with it.The voucher should be sent to the passenger via SMS/email, along with the T&C.

* Regarding the B2C/B2B website:

    2.1 Passengers should be able to log in and access the Manage Booking section.

    2.2 Passengers should be able to select the available options based on the conditions mentioned in step 1.3.

  * For the staff:

    * Staff members should be able to generate reports to track whether passengers have selected an option for the Flight IRR or not.

     * Staff members should be able to change the selected option for passengers (backend functionality).
 

---
 # เป้าหมายในการทำโปรเจต์นี้ :dart:
---
 ==กรณี flight irregularity ทางทีม NCT อยากได้ระบบมา support==

1.เมื่อมีประกาศ Flight IRR เจ้าหน้าที่ีที่ update flight status หรือเจ้าหน้าที่ที่เกี่ยวข้องสามารถดำเนินการดังนี้

1.1 จัดส่ง SMS

1.2 จัดส่ง E-mail

1.3 เลือก Option การช่วยเหลือผู้โดยสารตามเงื่อนไข CAAT ได้แก่

 - เปลี่ยนแปลงเที่ยวบินฟรี 1  ครั้ง

 - เก็บเครดิต 100% ระยะเวลา xx เดือน > ระบบ generate และส่งอีเมลแจ้งผู้โดยสาร พร้อมเงื่อนไข

- เปลี่ยนแปลงเส้นทาง

 - คืนเงิน
 
1.ระบบตรวจสอบว่าชำระเงินรูปแบบไหน
   >  Cash ระบบให้กรอกเลขที่บัญชี ชื่อบัญชี ธนาคาร หากโอนให้บุคคลอื่น ให้แนบเอกสารได้
   >  บัตรเครดิต
   >  ซื้อผ่านตัวแทนจำหน่าย > ระบบแจ้งติดต่อผ่านตัวแทนฯ ภายใน 45 วันทำการ
2.เมื่อผู้โดยสารกรอกรายละเอียดเรียบร้อยส่งไปที่บัญชี
3.บัญชีดำเนินการคืนเงิน
4.การเงินส่งเรื่องให้ธนาคารเพื่อคืนเงินแต่ละช่องทาง
5.การเงิน update status การคืนเงิน
6.ระบบส่ง SMS/E-mail ให้ผู้โดยสารเมื่อคืนเงินเรียบร้อย
7.ระบบลงบันทึก

- ได้รับเงินชดเชย 600 บาท (900 voucher) หรือ 1,200 บาท (1500 voucher)(ระบบสามารถเลือกได้)
   > เงินสด กรอกเลขที่บัญชี ชื่อบัญชี ธนาคาร หากโอนให้บุคคลอื่น ให้แนบเอกสารได้
  > เมื่อผู้โดยสารกรอกรายละเอียดเรียบร้อยส่งไปที่บัญชี
  > บัญชีดำเนินการคืนเงิน
  > การเงินส่งเรื่องให้ธนาคารเพื่อคืนเงินแต่ละช่องทาง
  > การเงิน update status การคืนเงิน
  > ระบบส่ง SMS/E-mail ให้ผู้โดยสารเมื่อคืนเงินเรียบร้อย
  > voucher ระบบ generate voucher ส่งให้ผู้โดยสารพร้อม T&C

2.ในหน้า website B2C / B2B

2.1 ผู้โดยสาร Log in เพื่อ Manage Booking

2.2 สามารถ เลือก Option ได้ตามเงื่อนไข ข้อ 1.3

3.เจ้าหน้าที่สามารถดึง report ดูได้ว่า ผู้โดยสารในเที่ยวบิน Flight IRR มีการเลือก Option หรือยังไม่ได้เลือก

4. Staff  สามารถเปลี่ยน option ได้เมื่อเลือกไปแล้ว (หลังบ้าน)
---
##  First interview IRR team talk P.som (6/13/2023):file_folder:
---
* List all about the interview such as (Note, pain,solution)

### Cases report: Flight Delay, Flight Cancel and Flight early(>15mins call customer)
 * ASM/OP run annouch email FLight IRR
 * K.Oat update inventory in Radixx
 * ASM,SSM->Planning or OP Create
 * Nok Smart create report to Nok contact(Excel)
 * more than 24 hr ➝ Nok contact ➝ contact customers (excel)
 * less than 24 hr ➝Station ➝ handle customers
 * depend on each other situation, they can help each other
 * Station hard to handle..too much passenger
 
     *  Excel incomplete
     *  No real time inventory update..wait for the next day 2am 
        * Solution: Inside report cons incomplete information, open many files
 * Have phone number = SMS
 * No phone number= Email
 * No phone and Email = Radix booking history
 * None Find the previous booking 
 * Station handle ➝ retrieve report from Radixx&Nok smart
 * Station don't have to report..remark on Radixx
 * Station handle ➝ Refund Passenger ➝ refer to Radixx & CRM
 * Station handle ➝ Transfer Passenger➝refer to Sup
 * Station handle ➝ Credit gen vouch ได้เลอ
 * Excel= manual ref & Details
 * Redix push information to Nok smart #run once a day delay
 * Ack➝Change to DD➝Open 3 month➝Credit 100%➝Credit 120%➝Refund to other airline➝pending➝other remark
 * miss contact = manage by station
 * station try to contact passenger before they come
 * Flight Delay➝SMS
 * Flight Cancel that day➝print Radixx gold➝can talk case by case
* boarding gate➝ announce ที่ gate




 ### Offer
 * 1<t<=2 Change flights➝Separate case to supervisor nok➝try to offer keep credit or refund no transfer
 * <3 days = Voucher 1500 or cash 1200
 * >3 days = no Vouch
 * Passenger walk in➝Transfer flight/ wait for the next flight & hotel➝Fly to the close destination & pay for their transportation bus, etc.
 * Change to DD  opt. = Change fight free 1 time = in 24 hr
 * Change opt = 1 time เปลี่ยนใจ
 * Worst case : transfer to other airline
 * Other : (in case none of these options)
### Pain Point
* User can see only key contact
* No real time inventory update.
* reservation from Radixx-- No Phone number, email ➝current solution find the previous res
* Station don't have updated report..remark on Radixx
* Hard to handle a lot of people on station




### Solution/Goal
* User can see every contacts.
* monitor➝Status, number of passenger completed, what happen, how many percent complete Front-End, Option that passengers chose mostly
* Save Cost on customer's option as much as possible
* ==Smooth/Seamless process on data transfer / real time data (main target)== 
* To decrease the number of passengers on the stations.
* Report Employee Performance(additional)

### Keyword
---
        OP = ASM  FLTOPS S23/164
        SSM = Standard systems Modeling
        ASM = Advanced Systems Modeling
        ODH= Nok smart
        Ref.= Refer➝ASM FLTOPS S23/24 เกี่ยวกับ refund team
        Station = หน้างาน
        inbound = ลูกค้าโทรเข้า
        outbound = โทรหาลูกค้าเพื่อจัดการเคส
* Here are the IATA codes (airport symbols) for major airports in Thailand:

   * Suvarnabhumi Airport (Bangkok): BKK
   * Don Mueang International Airport (Bangkok): DMK
   * Phuket International Airport: HKT
   * Chiang Mai International Airport: CNX
   * Hat Yai International Airport: HDY
   * Krabi International Airport: KBV
   * Samui International Airport: USM
   * Surat Thani International Airport: URT
   * U-Tapao International Airport (Pattaya): UTP
   * Mae Fah Luang - Chiang Rai International Airport: CEI
   * Hua Hin Airport: HHQ
   * Nakhon Si Thammarat Airport: NST
   * Udon Thani International Airport: UTH
   * Trang Airport: TST
   * Narathiwat Airport: NAW
   
    
*  Q&A
    - OP/Radix sent report process to Noksmart?
    - Update report sent back process to Noksmart?
    - Priority of Station to Radix/Noksmart?
    - Can NokSmart/Nok contact change the excel format? (easy to import to Application)
    - Is it correct that if a user has both phone number and email, it will be sent to SMS automatically by Radixx?
    - Where is nok contact keeping the excel report after contacting the passenger?
    - Does nok contact have to push the excel report in Nok Smart or it is used to annouch station only.
    - Following a passenger's claim, where can the station update status?
    - Do you have another way such as SMS or email for passengers to claim their flight without calling?

    
    ---


## First IRR Project Recap/Update   (6/15/2023):memo:

* Update Info
    * need in for to be read and explain clear

* Update diagram
    * need to add more the diagram with applications
     * change the diagrams in the miro such as the 0,1,2 diagrams add or change some information 
##  Second interview IRR team talk (6/19/2023):file_folder:
----
* Update Info
    * Need to form the information in application such as the overview of the diagram and the add more UI page in the application
    
* Update diagram
    * need to add more the diagram with applications
     
---
##   interview IRR team talk P.som(6/23/2023)
---
* Update Info
    * Update the Refund in power app also make the power app stable
---
##  Third interview IRR team talk P.som(6/30/2023)
---
* Update Info
    
    
---
##  First interview Refund team talk  (6/19/2023):file_folder:
---
* List all about the interview such as (Note, pain,solution)
### Cases report: Refund detail report


### Information
* Staff --> Radix --> CMR --> Excel --> Account-->finace-->bank
* Replace CMR & Excel with Application


### Pain Point
* CMR complicate
* CMR not useable to do all the list 
* Staffs spend a lot of time to find where passenger's refund processes are


### Solution/goal 
=="Nok-smart and CMR will not be use"==
* Replace CMR with APP
* 1. Staff input info to app instead of CMR 
* 2. Account have more comfortable tool 
* 3. Staff can check where their Refund process checkpoint is
* 4. Filter case to find 3.
* 5. No duplicate data.


### Q&A
* Primary key = PNR/Booking No.??



---
##  Second interview Refund team talk  (07/**/2023)
---
* Update Information
    * 
    

---

# Diagram

* Diagram 0 1 2 with out application (Flight IRR)
* Diagram 0 1 2 when have the application (Flight IRR)
* Diagram with Refund process (Refund)
    
<iframe width="768" height="432" src="https://miro.com/app/live-embed/uXjVM_GrG4o=/?moveToViewport=-4171,-1477,959,471&embedId=76446239457" frameborder="0" scrolling="no" allow="fullscreen; clipboard-read; clipboard-write" allowfullscreen></iframe>)

---

# Application plans
- [ ] Make the excel sheet that the application can be import to the application.
- [ ] Make the Refund can export to excel or PDF for Finance
- [ ] Refund App
- [ ] No duplicate item/file when insert into list/share point
- [x] Search by Booking, Flight number, Name, Drop-down for Status,Ack,etc.
- [x] Add attribute : Case number
- [ ] Adjust UI design
- [ ] Future function : Export report for Finance, Analysis graph (Power bi), Seperate Section for each team to each editing part, login for each role for permission: Contact,Refund,Account,Finance
- [ ] Email notify to Staff that in the next process
- [ ] Email notify to Passenger
- [x] Add item manually in case data != 100%
- [x] Search bar on REF page
- [ ] Date picker on Check-mark page
---
Light -- only ticket
---

