Subversion Repositories SmartDukaan

Rev

Rev 27493 | Rev 27497 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
27417 tejbeer 1
package com.spice.profitmandi.web.controller;
2
 
27421 tejbeer 3
import java.io.IOException;
4
import java.time.LocalDate;
27417 tejbeer 5
import java.time.LocalDateTime;
27445 tejbeer 6
import java.time.LocalTime;
7
import java.time.temporal.ChronoUnit;
8
import java.util.ArrayList;
27421 tejbeer 9
import java.util.Base64;
10
import java.util.List;
27417 tejbeer 11
 
27421 tejbeer 12
import javax.mail.MessagingException;
27417 tejbeer 13
import javax.servlet.http.HttpServletRequest;
14
 
15
import org.apache.logging.log4j.LogManager;
16
import org.apache.logging.log4j.Logger;
27421 tejbeer 17
import org.json.JSONArray;
18
import org.json.JSONObject;
27417 tejbeer 19
import org.springframework.beans.factory.annotation.Autowired;
27493 tejbeer 20
import org.springframework.format.annotation.DateTimeFormat;
27417 tejbeer 21
import org.springframework.http.MediaType;
22
import org.springframework.http.ResponseEntity;
23
import org.springframework.stereotype.Controller;
24
import org.springframework.transaction.annotation.Transactional;
25
import org.springframework.web.bind.annotation.RequestBody;
26
import org.springframework.web.bind.annotation.RequestMapping;
27
import org.springframework.web.bind.annotation.RequestMethod;
27421 tejbeer 28
import org.springframework.web.bind.annotation.RequestParam;
27417 tejbeer 29
 
30
import com.google.gson.Gson;
27421 tejbeer 31
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
27417 tejbeer 32
import com.spice.profitmandi.common.web.util.ResponseSender;
27421 tejbeer 33
import com.spice.profitmandi.dao.entity.dtr.EmployeeAttendance;
27417 tejbeer 34
import com.spice.profitmandi.dao.entity.dtr.HyperTrackKeyModel;
35
import com.spice.profitmandi.dao.entity.dtr.HypertrackKey;
27421 tejbeer 36
import com.spice.profitmandi.dao.enumuration.dtr.PunchType;
37
import com.spice.profitmandi.dao.model.EmployeeAttendanceModel;
38
import com.spice.profitmandi.dao.repository.dtr.EmployeeAttendanceRepository;
39
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
27417 tejbeer 40
import com.spice.profitmandi.dao.repository.user.HypertrackKeyRepository;
27421 tejbeer 41
import com.spice.profitmandi.service.user.RetailerService;
27417 tejbeer 42
 
43
import io.swagger.annotations.ApiImplicitParam;
44
import io.swagger.annotations.ApiImplicitParams;
45
import io.swagger.annotations.ApiOperation;
27421 tejbeer 46
import okhttp3.OkHttpClient;
47
import okhttp3.Request;
48
import okhttp3.Response;
27417 tejbeer 49
 
50
@Controller
51
@Transactional(rollbackFor = Throwable.class)
52
public class HyperTrackController {
53
 
54
	private static final Logger LOGGER = LogManager.getLogger(HyperTrackController.class);
55
 
56
	@Autowired
57
	ResponseSender<?> responseSender;
58
 
59
	@Autowired
60
	Gson gson;
61
 
62
	@Autowired
63
	private HypertrackKeyRepository hypertrackKeyRepository;
64
 
27421 tejbeer 65
	@Autowired
66
	private EmployeeAttendanceRepository employeeAttendanceRepository;
67
 
68
	@Autowired
69
	private FofoStoreRepository fofoStoreRepository;
70
 
71
	@Autowired
72
	private RetailerService retailerService;
73
 
27417 tejbeer 74
	private static final String ACCOUNT_ID = "aZ6flHhrgPIEl18buHdPBdueEN4";
75
	private static final String SECRET_KEY = "a7rsX5B4UNNfTTx1-IJ19qdH48BT4YvBKlQJg3n3_KKNe7WWych55g";
76
 
77
	@RequestMapping(value = "/devices/hypertrackId", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
78
	@ApiImplicitParams({
79
			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
80
	@ApiOperation(value = "")
81
	public ResponseEntity<?> deviceHypertrackId(HttpServletRequest request,
82
			@RequestBody HyperTrackKeyModel hyperTrackKeyModel) {
83
		HypertrackKey hyperTrackKey = hypertrackKeyRepository.selectByUserIdAndDeviceId(hyperTrackKeyModel.getUserId(),
84
				hyperTrackKeyModel.getDeviceId());
85
		if (hyperTrackKey == null) {
86
			hyperTrackKey = new HypertrackKey();
27444 tejbeer 87
			hyperTrackKey.setUserId(hyperTrackKeyModel.getUserId());
88
			hyperTrackKey.setCreatedTimestamp(LocalDateTime.now());
27417 tejbeer 89
			hyperTrackKey.setDeviceId(hyperTrackKeyModel.getDeviceId());
90
		}
27422 tejbeer 91
 
27444 tejbeer 92
		hyperTrackKey.setHypertrackKeyId(hyperTrackKeyModel.getHyperTrackId());
93
 
27417 tejbeer 94
		hyperTrackKey.setUpdatedTimestamp(LocalDateTime.now());
95
		hypertrackKeyRepository.persist(hyperTrackKey);
96
		return responseSender.ok(true);
97
	}
98
 
27421 tejbeer 99
	@RequestMapping(value = "/devices/location", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
100
	public ResponseEntity<?> getLocationByKeyId(HttpServletRequest request, @RequestParam int userId,
27426 tejbeer 101
			@RequestParam int deviceId) throws IOException, MessagingException, ProfitMandiBusinessException {
27421 tejbeer 102
 
27426 tejbeer 103
		double lat1 = 28.516045882182738;
104
		double lng1 = 77.3771954997187;
27421 tejbeer 105
 
106
		HypertrackKey hyperTrackKey = hypertrackKeyRepository.selectByUserIdAndDeviceId(userId, deviceId);
27428 tejbeer 107
		// EmployeeAttendance employeeAttendance =
108
		// employeeAttendanceRepository.selectLatestPunchTimeStamp();
109
 
110
		List<EmployeeAttendance> employeeAttendances = employeeAttendanceRepository.selectByUserIdKey(userId, deviceId,
111
				LocalDate.now());
27432 tejbeer 112
 
113
		LOGGER.info("hyperTrackKey" + hyperTrackKey);
114
		LOGGER.info("employeeAttendance" + employeeAttendances);
27421 tejbeer 115
		OkHttpClient client = new OkHttpClient();
116
 
117
		String authString = "Basic "
118
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
119
 
120
		Request request1 = new Request.Builder()
27426 tejbeer 121
				.url("https://v3.api.hypertrack.com/devices/" + hyperTrackKey.getHypertrackKeyId()).get()
27421 tejbeer 122
				.addHeader("Authorization", authString).build();
123
 
124
		Response response = client.newCall(request1).execute();
125
		JSONObject jsonObj = new JSONObject(response.body().string());
126
		JSONObject c = jsonObj.getJSONObject("location");
127
		JSONObject d = c.getJSONObject("geometry");
128
		JSONArray coords = d.getJSONArray("coordinates");
129
		double lat2 = coords.getDouble(1);
130
		double lng2 = coords.getDouble(0);
131
		double dist = distance(lat1, lng1, lat2, lng2, "m");
132
		EmployeeAttendanceModel em = new EmployeeAttendanceModel();
133
		em.setDistance(dist);
27422 tejbeer 134
		em.setLatitude(lat2);
135
		em.setLongitude(lng2);
27432 tejbeer 136
 
27428 tejbeer 137
		if (!employeeAttendances.isEmpty()) {
138
			if (employeeAttendances.get(0).getCreateTimestamp().toLocalDate().equals(LocalDate.now())) {
139
				if (employeeAttendances.get(0).getPunch().equals("punchIn")) {
140
					em.setPunchIn(true);
141
				} else {
142
					em.setPunchIn(false);
143
				}
27421 tejbeer 144
			} else {
145
				em.setPunchIn(false);
146
			}
27496 tejbeer 147
 
148
			if (employeeAttendances.get(employeeAttendances.size() - 1).getPunch().equals("punchIn")) {
149
				LocalTime startTime = employeeAttendances.get(0).getCreateTimestamp().toLocalTime();
150
				Long secondsBetween = ChronoUnit.SECONDS.between(startTime, LocalDateTime.now().toLocalTime());
151
				long hours = secondsBetween / 3600;
152
				long minutes = (secondsBetween % 3600) / 60;
153
				long seconds = secondsBetween % 60;
154
				em.setPunchHours(hours);
155
				em.setPunchMinutes(minutes);
156
				em.setPunchSeconds(seconds);
157
			}
158
 
27421 tejbeer 159
		} else {
160
			em.setPunchIn(false);
161
		}
162
		return responseSender.ok(em);
163
	}
164
 
165
	private static double distance(double lat1, double lon1, double lat2, double lon2, String unit) {
166
		if ((lat1 == lat2) && (lon1 == lon2)) {
167
			return 0;
168
		} else {
169
			double theta = lon1 - lon2;
170
			double dist = Math.sin(Math.toRadians(lat1)) * Math.sin(Math.toRadians(lat2))
171
					+ Math.cos(Math.toRadians(lat1)) * Math.cos(Math.toRadians(lat2)) * Math.cos(Math.toRadians(theta));
172
			dist = Math.acos(dist);
173
			dist = Math.toDegrees(dist);
174
			dist = dist * 60 * 1.1515;
175
			if (unit.equals("m")) {
176
				dist = dist * 1.609344;
177
				dist = dist / 0.0010000;
178
			} else if (unit.equals("N")) {
179
				dist = dist * 0.8684;
180
			}
181
			return (dist);
182
		}
183
	}
184
 
27475 tejbeer 185
	@RequestMapping(value = "/getPunchHistory", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
186
	public ResponseEntity<?> getPunchHistory(HttpServletRequest request, @RequestParam int userId,
187
			@RequestParam int deviceId) {
188
 
189
		List<EmployeeAttendance> employeeAttendances = employeeAttendanceRepository.selectByUserIdKey(userId, deviceId,
190
				LocalDate.now());
191
 
192
		return responseSender.ok(employeeAttendances);
193
	}
194
 
27421 tejbeer 195
	@RequestMapping(value = "/employee/attendance", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
196
	@ApiImplicitParams({
197
			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
198
	@ApiOperation(value = "")
199
	public ResponseEntity<?> employeeAttendance(HttpServletRequest request, @RequestParam(name = "userId") int userId,
200
			@RequestParam(name = "deviceId") int deviceId, @RequestParam(name = "punchType") PunchType punchType,
27493 tejbeer 201
			@RequestParam(name = "punch") String punch) {
27421 tejbeer 202
 
203
		EmployeeAttendance employeeAttendance = new EmployeeAttendance();
204
		employeeAttendance.setUserId(userId);
205
		employeeAttendance.setDeviceId(deviceId);
206
		employeeAttendance.setPunch(punch);
207
		employeeAttendance.setPunchType(punchType);
208
		employeeAttendance.setCreateTimestamp(LocalDateTime.now());
209
		employeeAttendanceRepository.persist(employeeAttendance);
27445 tejbeer 210
		if (punch.equals("punchOut")) {
211
			List<EmployeeAttendance> employeeAttendances = employeeAttendanceRepository.selectByUserIdKeyASC(userId,
212
					deviceId, LocalDate.now());
213
			long hours = 0;
214
			long minutes = 0;
215
			long seconds = 0;
27446 tejbeer 216
			long totalSeconds = 0;
217
			LocalTime startTime = null;
218
			LocalTime endTime = null;
27445 tejbeer 219
 
220
			for (EmployeeAttendance em : employeeAttendances) {
221
				if (em.getPunch().equals("punchIn")) {
27446 tejbeer 222
					startTime = em.getCreateTimestamp().toLocalTime();
27445 tejbeer 223
				} else if (em.getPunch().equals("punchOut")) {
27446 tejbeer 224
					endTime = em.getCreateTimestamp().toLocalTime();
27445 tejbeer 225
				}
226
				if (startTime != null && endTime != null) {
27446 tejbeer 227
					Long secondsBetween = ChronoUnit.SECONDS.between(startTime, endTime);
228
					totalSeconds += secondsBetween;
27445 tejbeer 229
					startTime = null;
230
					endTime = null;
231
				}
232
 
233
			}
27446 tejbeer 234
			hours = totalSeconds / 3600;
235
			minutes = (totalSeconds % 3600) / 60;
236
			seconds = totalSeconds % 60;
27445 tejbeer 237
			EmployeeAttendanceModel emm = new EmployeeAttendanceModel();
238
			emm.setHours(hours);
239
			emm.setMinutes(minutes);
240
			emm.setSeconds(seconds);
241
			return responseSender.ok(emm);
242
 
243
		}
27421 tejbeer 244
		return responseSender.ok(true);
245
	}
246
 
27426 tejbeer 247
	@RequestMapping(value = "/create/geofence", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
27445 tejbeer 248
	public ResponseEntity<?> createGeofence(HttpServletRequest request)
27426 tejbeer 249
			throws IOException, ProfitMandiBusinessException {
250
 
27475 tejbeer 251
		/*
252
		 * List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores(); for
253
		 * (FofoStore fofoStore : fofoStores) { if (fofoStore.getLatitude() != null &&
254
		 * fofoStore.getLongitude() != null) { CustomRetailer customRetailer =
255
		 * retailerService.getFofoRetailer(fofoStore.getId());
256
		 */
257
		OkHttpClient client = new OkHttpClient();
27426 tejbeer 258
 
27475 tejbeer 259
		okhttp3.MediaType mediaType = okhttp3.MediaType.parse("application/json");
260
		JSONObject geofe = new JSONObject();
261
		JSONArray geofences = new JSONArray();
262
		JSONObject geometry = new JSONObject();
263
		JSONObject geo = new JSONObject();
264
		JSONArray coordinates = new JSONArray();
265
		coordinates.put(77.08596155373755);
266
		coordinates.put(28.64944201113976);
267
		geo.put("type", "Point");
268
		geo.put("coordinates", coordinates);
269
		geometry.put("geometry", geo);
270
		JSONObject metadata = new JSONObject();
271
		metadata.put("name", "Test");
272
		geometry.put("radius", 500);
273
		geofences.put(geometry);
274
		geofe.put("geofences", geofences);
275
		okhttp3.RequestBody body = okhttp3.RequestBody.create(mediaType, geofe.toString());
276
		String authString = "Basic "
277
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
27426 tejbeer 278
 
27475 tejbeer 279
		Request request1 = new Request.Builder().url("https://v3.api.hypertrack.com/geofences").post(body)
280
				.addHeader("Authorization", authString).build();
27426 tejbeer 281
 
27475 tejbeer 282
		Response response = client.newCall(request1).execute();
283
		String geofenceId = null;
284
		JSONArray ja = new JSONArray(response.body().string());
285
		for (int i = 0; i < ja.length(); i++) {
286
			JSONObject c = ja.getJSONObject(i);
287
			geofenceId = c.getString("geofence_id");
288
		}
27426 tejbeer 289
 
27475 tejbeer 290
		LOGGER.info("response" + response.body().string());
27426 tejbeer 291
 
27475 tejbeer 292
		return responseSender.ok(geofenceId);
27426 tejbeer 293
 
294
	}
295
 
27449 tejbeer 296
	@RequestMapping(value = "/getgeofence", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
297
	public ResponseEntity<?> getAllGeofences(HttpServletRequest request)
298
			throws IOException, ProfitMandiBusinessException {
299
 
300
		OkHttpClient client = new OkHttpClient();
301
 
302
		String authString = "Basic "
303
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
304
 
305
		// Get geofences created for all app users
306
		Request request1 = new Request.Builder().url("https://v3.api.hypertrack.com/geofences")
307
				.addHeader("Authorization", authString).build();
308
 
309
		Response response = client.newCall(request1).execute();
310
		return responseSender.ok(response.body().string());
311
 
312
	}
313
 
27475 tejbeer 314
	@RequestMapping(value = "/deletegeofence", method = RequestMethod.DELETE, produces = MediaType.APPLICATION_JSON_VALUE)
315
	public ResponseEntity<?> deleteGeofences(HttpServletRequest request, String geofenceId)
316
			throws IOException, ProfitMandiBusinessException {
317
		OkHttpClient client = new OkHttpClient();
318
 
319
		String authString = "Basic "
320
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
321
 
322
		Request request1 = new Request.Builder().url("https://v3.api.hypertrack.com/geofences/" + geofenceId).delete()
323
				.addHeader("Authorization", authString).build();
324
 
325
		Response response = client.newCall(request1).execute();
326
		return responseSender.ok(response.body().string());
327
 
328
	}
329
 
27417 tejbeer 330
}