OK Flow

PROJECT FLOW OOREDOO

10.196.208.243 – snd/snd321
10.196.208.244 – snd/snd321
port : 9082
————–
DB Connection– snd/snd321
port=1535
URL – jdbc:oracle:thin:@ohq-dms-db-scan.wataniya.com:1535/DMSDB
————–
hsrivatava
[email protected]
————–

DMS (DEALER MANAGMENT SYSTEM)

TESTING
1. Test twice with same or different data (positive and negative).
2. note down all the buttons, functionality, input fields.

1. All users menus login credentials.
ROLE CREDENTIAL
ROLE_MANAGER AREA/123456
ROLE_ADMINISTRATOR DEEPAK/123456
ROLE_FINANCE_MANAGER SGRG/123456
ROLE_SALES_MANAGER SGRG3/123456
ROLE_WAREHOUSE_MANAGER SGRG6/123456
ROLE_DISTRIBUTOR AENKC00828/123456
ROLE_FINANCE_USER SGRG8/123456
ROLE_RETAILER SGRG7/123456
ROLE_SECURITY SSEC1/123456
ROLE_AREA_SUPERVISOR SRJAREA/123456
ROLE_FOS FOS2/123456
ROLE_SURVEY SGRG5/123456
ROLE_SALES_MERCH SRJMER/123456
ROLE_SALES_DIRECTOR SGRG2/123456
ROLE_FINANCE_INV SGRG1/123456

ALL MENUS FLOW

SURVEY FLOW
1. Visit Batches – list of survey users, from to.
2. Visit Master – shows the list of Visits Desc.
3. Library Users – create list of Questions.
4. Survey – survey – create survey from to show, if any dependency YES NO.

WORKFLOW
+ Workflow Master -> Request State -> Rule Master.

PO
+ Purchase Order -> Purchase Order List.

REPORT
edit snd_report_master (shows the Report to GUI)

edit snd_report_parameter (filter the report on GUI, REQUIRED)

edit snd_form_param_query (filter dropdown select HQL query should be write)

Q. MAP, filter not working.

COMMISION

3. Log file check.

Questions OR POINTS
1. SAF no. and sim no. are same.
2. SAF – QC will receive.
3. After 6 months sim will deactivate if not activated or used.
4. get notifications to OOredoo.
5. Service application form (SAF).
6. User Creating -> User Profile(create user) -> in case of retailer only – Sales Channel(create sales Channel – User Map-same Area user)
7. Distributor -> FOS (Feed on Street) -> Retailer/Shop/subdealer.
8. LDAP is used for authentication.
9. after registeration of users the credentials will be share to them via Email and SMS.
10. MSISDN – is mobile number.
11. Serialized and non serialized. (in our project every item is serialized)
12. For SMS and Email sending to customer via API call OR schedule will run from Putty.
13. products mapping via Backend entry. Tables – dealer allocation, sales_channel.
14. Table –
Q 16. Flow Commision.
18. dbconfig.properites contains DB password and details.
+ Retention – preserve the files for how many days.
+ Purging – Free space of files.
+ DMZ – d-meteralized zone
19. FrontEnd – Security User can create users. Only in retailer case, have to create sales channel and add user.
20. AREA MANAGER will approve the retailer, using sales channel.
Role_Area_Manager = Role_Manager

21. User Login from Backend. each entry should be there.
select * from snd_user_detail WHERE USER_ID LIKE ‘%SGRG4%’
select * from snd_user_login_detail WHERE USER_ID LIKE ‘%SSEC1%’
select * from snd_user_roles WHERE USER_ID LIKE ‘%DEEPAK%’
SELECT * FROM SND_USER_ROLE_MAPPING
select * from snd_sales_channel_master
SND_ROLE_MASTER

22. Route Management screen is in under Survey.

TABLE’s Mapping

SND_INVENTORY_DETAIL – status

dealer – 4
fos – 5
retailer – 6
intransit – 15

  • snd_user_detail.user_type_id = snd_user_role_mapping.user_type.
  •  snd_sales_channel_master.channel_sub_type_id = 13 // is a retailer id.

PUTTY
U/P : snd/snd321

+ logs available – cd /pacs/logs/
+ tail -f DMS(than press TAB)

———
app1 – snd/snd321
app2 – snd/snd321

+ Ctrl+R -> SSH
ssh [email protected]
snd321

+ tobin
./startup.sh
logs

+ document path – pacs/document/
——————
+ cd /pacs/integration/

Auto shooting sms and email jar path = cd /pacs/logs/backend_process/SMS and /email/ = *.jar”

API Gateway Logg -> OSB Communication(Approved) -> Booked(status -Entered)
API Server -> OSB

API -> Soap Request -> JSON Response.

PUTTY COMMANDS

+ keys * –
+ vi /pacs/db.properties (view file)

+ pacs/logs/ApiGateway.log -> tracks all logs of API.

+ Catilina.out – contains all complete log details.
+ cd .. -> moves one step up.
+ Ctrl+C -> process stop.
+ select content -> it will auto copy.
+ on right click -> Paste.
+ Ctrl+L OR clear DY-> clear screen.
+ ls -ltr -> shows the files with filenames with in a directory.
+ rm -f *.txt -> removes all files which are txt format.
+ killtomcat
+ su – here the “su” command allows you to become another user.
+ sh su – snd
+ exit
+ sudo – command helps to run programs with security privileges of another user.
+ sudo su –
+ pwd – where you are in a directory.
+ sh /home/snd/temp.sh
+ -/.bash_profile
+ !/bin/bash
+ ./monitortomcat.sh
+ ps -ef!grep java = which processes are running, related to java.
+ service httpd stop/start/status
+ ssh [email protected]
+ vi /etc/rc.local – file used by Administrator, used for start custom services.
+ grep “database” configuration.php – command instructs grep to look for the string “database” in the configuration.php file and display the containing line. If you don’t know which file contains the text.
+ find . -name “tom*” —————-(to find the files in a dirctory).
+ ps -ef -> it will shows all the processes running.
+ ps -aux -> shows active process and all list of processes.
+ free -m -> it will shows memory spaces.
+ Ctrl+d -> logout from putty.
+ tomcat bin path -> status -> start the services
+ grep 89923243243243 catalina.out -> after running the program, logs enter in catalina and searching particular word.
+ vi catalina.out -> contains Tomcat log file.
+ telnet ip – shows the connection to ip is working or not.
+ “/searchText” -> searching a text in log.

+ cp file.txt logs/nov/ -> copy file.

————————————————–

LIST OF TABLES FROM DOCUMENTS
SND_TRANSFER_ORDER_LINE_ITEMS(contains transfer products details)
SND_TRANSFER_ORDERS – contains order_id, next_action_by, next_status, next_action.
SND_ZONE_TYPE_MASTER – ZONE entry, Contains clusterName, clusterID.
SND_ZONE_TYPE_DETAILS – zone details, zone_id, zone_code, zone_parent.
SND_CHANNEL_SUB_TYPE_MASTER – (creating Distributor, FOS, Retailer)
SND_CUSTOMER_SAF_TRANS – entry of SAF.
SND_TICKET_TRANS – contains raise and query ticket details.
SND_USER_DETAIL – USER_ID, USER_EMAIL_ID, USER_ADDRESS1, USER_STATUS, FIRST_NAME, LAST_NAME.
SND_USER_LOGIN_DETAIL – user roles, password, default password, user details added here.
SND_USER_ROLES – user details added here, USER_ID, ROLE.
SND_USER_ROLE_MAPPING – USER_TYPE, USER_ID, SND_USER_DETAIL.
SND_SALES_CHANNEL_USER_MAP – user map, user details added here, entry of sales channel users.
SND_SALES_CHANNEL_MASTER – sales channel screen master details and user_id, sales_channel_id(retailer_id, fos_id, distributor_id), dealer_id.
SND_SALES_CHANNEL_DETAIL – details tab screen details.
SND_SALES_CHANNEL_ADDRESS – address tab details.
SND_SALES_CHANNEL_ACCOUNT – account tab details.
SND_SALES_CHANNEL_EQUIPMENT – equipment tab details.
SND_SALES_CHANNEL_SIM_INFO – sim info tab details.
SND_SALES_CHANNEL_TAX_DETAIL – tax tab details.
SND_SALES_CHANNEL_DOCS – document uploading details.
SND_SALES_CHANNEL_PROFILE – profile tab details.
SND_SALES_CHANNEL_HISTORY – contains update status, change ownership status details.
SND_BANK_CREDIT_LIMITS – credit limits details.
SND_INVENTORY_DETAIL – product insert and inventory search screen details.
SND_INVENTORY_MASTER – INVENTORY_TYPE_ID, INVENTORY_TYPE_DESCRIPTION, MINIMUM_ORDER_QTY, DISCOUNT, inventory_subtype.
SND_INVENTORY_HISTORY – it contains history of products changes.
SND_INVENTORY_DISCOUNT – it contains products discounts.
SND_DEFAULT_STOCK_NORMS – contains channel sub type roles, prodcuts min. max. and from to date availablity.
SND_DWORKFLOW_MASTER – WORKFLOW_ID, WORKFLOW_DESC, ACTION_TYPE, WORKFLOW_TYPE.
SND_DWORKFLOW_REQUEST_STATE – WORKFLOW_ID, STATE_ID, ON_ROLE, REQUEST_DESC.
SND_WORKFLOW_REQUESTS –
SND_WORKFLOW_RULE_MASTER – WORKFLOW_ID, CURRENT_STATE, ON_FAILURE, ON_SUCCESS.
SND_INVENTORY_ORDERS –
SND_MENU_DETAIL – entry of menus, parent_menu_id.
SND_ROLE_MENUS – mapping of menu_id with the ROLE_USER.
SND_ROLE_MASTER – contains all the roles of SND users.
SND_PO_status_master,
snd_user_type_master(all users type),
user_type_role_map(roles for users),
snd_inventory_details(serial No),
Password – SMS_QUEUE and EMAIL_QUEUE.
CIN_T_SMS_QUEUE – After email, SMS – entry goes here.
CINM_EMAIL – entry of new email template.
SND_Etop_up_logs – mobile, transaction_id, response.
cms_m_customer – customer details.
snd_dealer_allowed_products – list of product details that distributor have.
mig_shop – userid, password, shop name, shop address.
snd_saleschannel_stock_status – sales_channel_id, current_stock, stockstatus_id, inventory_type_id.
SND_CLUSTER_GPS_MAP – entry of clustter mapping GPS data via excel.
SND_CLUSTER_CGI_MAP – entry of clustter mapping CGI entry via form.
SND_SALES_ORDER_MASTER – get POSORDERID, POS fields.
TAX_PLAN_ASSIGNMENT – get Tax details fields.
SND_VTU_Accounts – for invSubType=”L”, value greater Balance.
FDS_M_MODULE_PARAM – entry of username and password, file upload path.
SND_PARTNER_PERIODIC_QUOTA – Quota adjustment entry, status, payment method, Quota where dealer_id = 132.

# Sub/Module Port JAR/WAR path Log path
1 DMS-GUI 9082 /pacs/apache-tomcat-9.0.0.M26/webapps /pacs/apache-tomcat-9.0.0.M26/logs
2 SMS – /pacs/backend_process/sms/ /pacs/backend_process/sms/SNAPSHOT.log
3 EMAIL – /pacs/backend_process/email /pacs/backend_process/email/ SNAPSHOT.log
4 DMS-Middleware 9081 /pacs/consumer/ ws-consumer-0.0.1.jar /pacs/consumer/ nohup.out
5 PO Update 8080 /pacs/integration/ooredoo-web-services-1.10.jar /pacs/integration/nohup.out
6 Alarm – /pacs/integration/Alarm/AlarmManager-0.0.1.jar /pacs/integration/Alarm/nohup.out
7 Notification – /pacs/integration/Notification_Generator /pacs/integration/Notification_Generator/nohup.out

S.Number Server –Type Server-IP Hostname
1 SIT Server 10.192.154.204 SBA-DMS-DEV
2 UAT Server 10.192.154.203 SBA-DMS-UAT
3 Production –App1 10.196.208.243 OHQ-DMS-APP01
4 Production –App2 10.196.208.244 OHQ-DMS-APP02
5 Production-Web1 10.196.32.51 OHQ-DMS-WEB01
6 Production-Web2 10.196.32.52 OHQ-DMS-WEB02
7 Production-POS 10.196.208.210 OHQ-DMS-POS
8 Production-Proc 10.196.208.211 OHQ-DMS-PROC
9 Production-Commision 10.196.208.212 OHQ-DMS-COMM

+ cd /pacs/config -> vi application.properties

=> /pacs/apache-tomcat-9.0.0.M26/bin/startup.sh OR shutdown.sh
=> STATUS and Tomcat services. – under tomcat/ bin folder/ status (type status only)

CRONTAB
+ Crontab works under Tomcat Bin folder.
+ under bin/ crontab -l (list the crontab)
crontab -e (edit)
+ Esc + : + q! (enter) -> exit the crontab.
+ x – to delete.
+ Esc + 😡 -> save and exit the file.
+ Esc + :w -> save the file.
+ shift + G -> highlight the edit file.

WAR DEPLOY
target folder war file, change version.
pom.xml version change.
c: folder copy to OK folder.

login to VPN.
copy the war file from your computer to vpn server folder.
than VPN to winscp 243, 244.
FOLDER -> home/snd/transfer (drag and drop)

putty cmd
+ deploy /home/snd/transfer/sndOredoo3.0.13.war.
——————-

[email protected]:/prd/nms/logs

SCOPE

Third Party System:
Via OSB(Oracle Service Bus) – ERP
Via OSB – CRM (RAS)
WS – E-Top Up
FTP – Data WareHouse
WS – Remedy
SMTP – Email Server
SMPP – SMSC

PAGE 44

SESSION
flow of project:
1. sales channel screen.
2. WorkFlow.
3. Commission.
4. does we are using web socket in our project.
5. User creation – retailer.
6. Report flow.

23Oct19

+ sonar.comviva.com:8080 – how to show in sonar project.

Sonar onboard
1. Compass id – project id from compass
2. Tags – like GitHub.
3. SCM URL – SVN URL – parent directory.
4. build report receipt – username only.
5.

crucial id will get after build onboard.

Jenkins – who have commit the code when,

* Blocker code get into in E category.

+ sonar plugins install.
+ try with resource.

CODEBETTER
start code review ->

CM team will share the points of Release notes.
Release – Major, Minor, patch.

Name – v2.2.9.183.1.1
v2.2.9(region).183(country).1.1(patch)

Compass

+ Workflow set.

+ DQA – delivery quality assurance. URL will be share.
metric.comviva.com

——————-
SND WORKFLOW

1. Vendor(Apple, Samsung, Sim) -> WareHouse(Telcom) -> Distributor -> Seller

2. Inventory -> Serialized(Y) and Non-Serialized(N).
snd_inventory_master -> Auto_Renewal_flag(Y,N)

snd_inventory_master.inventory_type_id = snd_inventory_detail.inventory_type.
snd_inventory_status_master – contains the status of SIM, where it is right now.

Inventory Sales Channel – virtual shop –
snd_user_detail
snd_user_login_detail
snd_sales_channel

* in snd_inventory_detail, retailer return to fos or distributor and after approval by upper management table fields should be null(retailer_id, fos_id, distributor_id).

* Inventory Master -> products insert

PO
distributor -> via system raise -> to Warehouse.
Distributor -> inventory allocation -> FOS/Seller/Retailer.

Status of Inventory Transfer in Zain:
Inventory Allocation
Inventory Transfer
Inventory Return
Inventory WriteOff
Inventory Reverse WriteOff

Facebooktwittergoogle_plusredditpinterestlinkedinmail
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...