1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
|
/*
* Copyright (C) 2014 The Android Open Source Project
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.android.internal.telephony;
import android.content.ContentResolver;
import android.content.Context;
import android.database.Cursor;
import android.telephony.Rlog;
import com.android.internal.telephony.HbpcdLookup.ArbitraryMccSidMatch;
import com.android.internal.telephony.HbpcdLookup.MccIdd;
import com.android.internal.telephony.HbpcdLookup.MccLookup;
import com.android.internal.telephony.HbpcdLookup.MccSidConflicts;
import com.android.internal.telephony.HbpcdLookup.MccSidRange;
public final class HbpcdUtils {
private static final String LOG_TAG = "HbpcdUtils";
private static final boolean DBG = false;
private ContentResolver resolver = null;
public HbpcdUtils(Context context) {
resolver = context.getContentResolver();
}
/**
* Resolves the unknown MCC with SID and Timezone information.
*/
public int getMcc(int sid, int tz, int DSTflag, boolean isNitzTimeZone) {
int tmpMcc = 0;
// check if SID exists in arbitrary_mcc_sid_match table.
// these SIDs are assigned to more than 1 operators, but they are known to
// be used by a specific operator, other operators having the same SID are
// not using it currently, if that SID is in this table, we don't need to
// check other tables.
String projection2[] = {ArbitraryMccSidMatch.MCC};
Cursor c2 = resolver.query(ArbitraryMccSidMatch.CONTENT_URI, projection2,
ArbitraryMccSidMatch.SID + "=" + sid, null, null);
if (c2 != null) {
int c2Counter = c2.getCount();
if (DBG) {
Rlog.d(LOG_TAG, "Query unresolved arbitrary table, entries are " + c2Counter);
}
if (c2Counter == 1) {
if (DBG) {
Rlog.d(LOG_TAG, "Query Unresolved arbitrary returned the cursor " + c2);
}
c2.moveToFirst();
tmpMcc = c2.getInt(0);
if (DBG) {
Rlog.d(LOG_TAG, "MCC found in arbitrary_mcc_sid_match: " + tmpMcc);
}
c2.close();
return tmpMcc;
}
c2.close();
}
// Then check if SID exists in mcc_sid_conflict table.
// and use the timezone in mcc_lookup table to check which MCC matches.
String projection3[] = {MccSidConflicts.MCC};
Cursor c3 = resolver.query(MccSidConflicts.CONTENT_URI, projection3,
MccSidConflicts.SID_CONFLICT + "=" + sid + " and (((" +
MccLookup.GMT_OFFSET_LOW + "<=" + tz + ") and (" + tz + "<=" +
MccLookup.GMT_OFFSET_HIGH + ") and (" + "0=" + DSTflag + ")) or ((" +
MccLookup.GMT_DST_LOW + "<=" + tz + ") and (" + tz + "<=" +
MccLookup.GMT_DST_HIGH + ") and (" + "1=" + DSTflag + ")))",
null, null);
if (c3 != null) {
int c3Counter = c3.getCount();
if (c3Counter > 0) {
if (c3Counter > 1) {
Rlog.w(LOG_TAG, "something wrong, get more results for 1 conflict SID: " + c3);
}
if (DBG) Rlog.d(LOG_TAG, "Query conflict sid returned the cursor " + c3);
c3.moveToFirst();
tmpMcc = c3.getInt(0);
if (DBG) {
Rlog.d(LOG_TAG, "MCC found in mcc_lookup_table. Return tmpMcc = " + tmpMcc);
}
if (!isNitzTimeZone) {
// time zone is not accurate, it may get wrong mcc, ignore it.
if (DBG) {
Rlog.d(LOG_TAG, "time zone is not accurate, mcc may be " + tmpMcc);
}
tmpMcc = 0;
}
c3.close();
return tmpMcc;
} else {
c3.close();
}
}
// if there is no conflict, then check if SID is in mcc_sid_range.
String projection5[] = {MccSidRange.MCC};
Cursor c5 = resolver.query(MccSidRange.CONTENT_URI, projection5,
MccSidRange.RANGE_LOW + "<=" + sid + " and " +
MccSidRange.RANGE_HIGH + ">=" + sid,
null, null);
if (c5 != null) {
if (c5.getCount() > 0) {
if (DBG) Rlog.d(LOG_TAG, "Query Range returned the cursor " + c5);
c5.moveToFirst();
tmpMcc = c5.getInt(0);
if (DBG) Rlog.d(LOG_TAG, "SID found in mcc_sid_range. Return tmpMcc = " + tmpMcc);
c5.close();
return tmpMcc;
}
c5.close();
}
if (DBG) Rlog.d(LOG_TAG, "SID NOT found in mcc_sid_range.");
if (DBG) Rlog.d(LOG_TAG, "Exit getMccByOtherFactors. Return tmpMcc = " + tmpMcc);
// If unknown MCC still could not be resolved,
return tmpMcc;
}
/**
* Gets country information with given MCC.
*/
public String getIddByMcc(int mcc) {
if (DBG) Rlog.d(LOG_TAG, "Enter getHbpcdInfoByMCC.");
String idd = "";
Cursor c = null;
String projection[] = {MccIdd.IDD};
Cursor cur = resolver.query(MccIdd.CONTENT_URI, projection,
MccIdd.MCC + "=" + mcc, null, null);
if (cur != null) {
if (cur.getCount() > 0) {
if (DBG) Rlog.d(LOG_TAG, "Query Idd returned the cursor " + cur);
// TODO: for those country having more than 1 IDDs, need more information
// to decide which IDD would be used. currently just use the first 1.
cur.moveToFirst();
idd = cur.getString(0);
if (DBG) Rlog.d(LOG_TAG, "IDD = " + idd);
}
cur.close();
}
if (c != null) c.close();
if (DBG) Rlog.d(LOG_TAG, "Exit getHbpcdInfoByMCC.");
return idd;
}
}
|
