Subversion Repositories SmartDukaan

Rev

Rev 27492 | Rev 27496 | 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
			}
147
		} else {
148
			em.setPunchIn(false);
149
		}
150
		return responseSender.ok(em);
151
	}
152
 
153
	private static double distance(double lat1, double lon1, double lat2, double lon2, String unit) {
154
		if ((lat1 == lat2) && (lon1 == lon2)) {
155
			return 0;
156
		} else {
157
			double theta = lon1 - lon2;
158
			double dist = Math.sin(Math.toRadians(lat1)) * Math.sin(Math.toRadians(lat2))
159
					+ Math.cos(Math.toRadians(lat1)) * Math.cos(Math.toRadians(lat2)) * Math.cos(Math.toRadians(theta));
160
			dist = Math.acos(dist);
161
			dist = Math.toDegrees(dist);
162
			dist = dist * 60 * 1.1515;
163
			if (unit.equals("m")) {
164
				dist = dist * 1.609344;
165
				dist = dist / 0.0010000;
166
			} else if (unit.equals("N")) {
167
				dist = dist * 0.8684;
168
			}
169
			return (dist);
170
		}
171
	}
172
 
27475 tejbeer 173
	@RequestMapping(value = "/getPunchHistory", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
174
	public ResponseEntity<?> getPunchHistory(HttpServletRequest request, @RequestParam int userId,
175
			@RequestParam int deviceId) {
176
 
177
		List<EmployeeAttendance> employeeAttendances = employeeAttendanceRepository.selectByUserIdKey(userId, deviceId,
178
				LocalDate.now());
179
 
180
		return responseSender.ok(employeeAttendances);
181
	}
182
 
27421 tejbeer 183
	@RequestMapping(value = "/employee/attendance", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
184
	@ApiImplicitParams({
185
			@ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header") })
186
	@ApiOperation(value = "")
187
	public ResponseEntity<?> employeeAttendance(HttpServletRequest request, @RequestParam(name = "userId") int userId,
188
			@RequestParam(name = "deviceId") int deviceId, @RequestParam(name = "punchType") PunchType punchType,
27493 tejbeer 189
			@RequestParam(name = "punch") String punch) {
27421 tejbeer 190
 
191
		EmployeeAttendance employeeAttendance = new EmployeeAttendance();
192
		employeeAttendance.setUserId(userId);
193
		employeeAttendance.setDeviceId(deviceId);
194
		employeeAttendance.setPunch(punch);
195
		employeeAttendance.setPunchType(punchType);
196
		employeeAttendance.setCreateTimestamp(LocalDateTime.now());
197
		employeeAttendanceRepository.persist(employeeAttendance);
27445 tejbeer 198
		if (punch.equals("punchOut")) {
199
			List<EmployeeAttendance> employeeAttendances = employeeAttendanceRepository.selectByUserIdKeyASC(userId,
200
					deviceId, LocalDate.now());
201
			long hours = 0;
202
			long minutes = 0;
203
			long seconds = 0;
27446 tejbeer 204
			long totalSeconds = 0;
27490 tejbeer 205
			String punchTotalHour = null;
27446 tejbeer 206
			LocalTime startTime = null;
207
			LocalTime endTime = null;
208
			List<Long> hghg = new ArrayList<>();
27445 tejbeer 209
 
210
			for (EmployeeAttendance em : employeeAttendances) {
211
				if (em.getPunch().equals("punchIn")) {
27446 tejbeer 212
					startTime = em.getCreateTimestamp().toLocalTime();
27445 tejbeer 213
				} else if (em.getPunch().equals("punchOut")) {
27446 tejbeer 214
					endTime = em.getCreateTimestamp().toLocalTime();
27445 tejbeer 215
				}
216
				if (startTime != null && endTime != null) {
27446 tejbeer 217
					Long secondsBetween = ChronoUnit.SECONDS.between(startTime, endTime);
218
					totalSeconds += secondsBetween;
27445 tejbeer 219
 
220
					startTime = null;
221
					endTime = null;
222
				}
223
 
224
			}
27490 tejbeer 225
 
27493 tejbeer 226
			/*
227
			 * if (employeeAttendances.get(0).getPunch().equals("punchIn")) { LocalTime
228
			 * punchInTime = employeeAttendances.get(0).getCreateTimestamp().toLocalTime();
229
			 * Long totalPunchSeconds = ChronoUnit.SECONDS.between(punchInTime,
230
			 * dateTime.toLocalTime()); long punchHours = totalPunchSeconds / 3600; long
231
			 * punchMinutes = (totalPunchSeconds % 3600) / 60; long punchSeconds =
232
			 * totalPunchSeconds % 60; punchTotalHour = punchHours + ":" + punchMinutes +
233
			 * ":" + punchSeconds;
234
			 * 
235
			 * }
236
			 */
27445 tejbeer 237
			LOGGER.info("employeeAttendance" + employeeAttendances);
238
 
27446 tejbeer 239
			hours = totalSeconds / 3600;
240
			minutes = (totalSeconds % 3600) / 60;
241
			seconds = totalSeconds % 60;
27445 tejbeer 242
			EmployeeAttendanceModel emm = new EmployeeAttendanceModel();
243
			emm.setHours(hours);
244
			emm.setMinutes(minutes);
245
			emm.setSeconds(seconds);
27493 tejbeer 246
			// emm.setTotalPunchHour(punchTotalHour);
27445 tejbeer 247
			return responseSender.ok(emm);
248
 
249
		}
27421 tejbeer 250
		return responseSender.ok(true);
251
	}
252
 
27426 tejbeer 253
	@RequestMapping(value = "/create/geofence", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
27445 tejbeer 254
	public ResponseEntity<?> createGeofence(HttpServletRequest request)
27426 tejbeer 255
			throws IOException, ProfitMandiBusinessException {
256
 
27475 tejbeer 257
		/*
258
		 * List<FofoStore> fofoStores = fofoStoreRepository.selectActiveStores(); for
259
		 * (FofoStore fofoStore : fofoStores) { if (fofoStore.getLatitude() != null &&
260
		 * fofoStore.getLongitude() != null) { CustomRetailer customRetailer =
261
		 * retailerService.getFofoRetailer(fofoStore.getId());
262
		 */
263
		OkHttpClient client = new OkHttpClient();
27426 tejbeer 264
 
27475 tejbeer 265
		okhttp3.MediaType mediaType = okhttp3.MediaType.parse("application/json");
266
		JSONObject geofe = new JSONObject();
267
		JSONArray geofences = new JSONArray();
268
		JSONObject geometry = new JSONObject();
269
		JSONObject geo = new JSONObject();
270
		JSONArray coordinates = new JSONArray();
271
		coordinates.put(77.08596155373755);
272
		coordinates.put(28.64944201113976);
273
		geo.put("type", "Point");
274
		geo.put("coordinates", coordinates);
275
		geometry.put("geometry", geo);
276
		JSONObject metadata = new JSONObject();
277
		metadata.put("name", "Test");
278
		geometry.put("radius", 500);
279
		geofences.put(geometry);
280
		geofe.put("geofences", geofences);
281
		okhttp3.RequestBody body = okhttp3.RequestBody.create(mediaType, geofe.toString());
282
		String authString = "Basic "
283
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
27426 tejbeer 284
 
27475 tejbeer 285
		Request request1 = new Request.Builder().url("https://v3.api.hypertrack.com/geofences").post(body)
286
				.addHeader("Authorization", authString).build();
27426 tejbeer 287
 
27475 tejbeer 288
		Response response = client.newCall(request1).execute();
289
		String geofenceId = null;
290
		JSONArray ja = new JSONArray(response.body().string());
291
		for (int i = 0; i < ja.length(); i++) {
292
			JSONObject c = ja.getJSONObject(i);
293
			geofenceId = c.getString("geofence_id");
294
		}
27426 tejbeer 295
 
27475 tejbeer 296
		LOGGER.info("response" + response.body().string());
27426 tejbeer 297
 
27475 tejbeer 298
		return responseSender.ok(geofenceId);
27426 tejbeer 299
 
300
	}
301
 
27449 tejbeer 302
	@RequestMapping(value = "/getgeofence", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
303
	public ResponseEntity<?> getAllGeofences(HttpServletRequest request)
304
			throws IOException, ProfitMandiBusinessException {
305
 
306
		OkHttpClient client = new OkHttpClient();
307
 
308
		String authString = "Basic "
309
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
310
 
311
		// Get geofences created for all app users
312
		Request request1 = new Request.Builder().url("https://v3.api.hypertrack.com/geofences")
313
				.addHeader("Authorization", authString).build();
314
 
315
		Response response = client.newCall(request1).execute();
316
		return responseSender.ok(response.body().string());
317
 
318
	}
319
 
27475 tejbeer 320
	@RequestMapping(value = "/deletegeofence", method = RequestMethod.DELETE, produces = MediaType.APPLICATION_JSON_VALUE)
321
	public ResponseEntity<?> deleteGeofences(HttpServletRequest request, String geofenceId)
322
			throws IOException, ProfitMandiBusinessException {
323
		OkHttpClient client = new OkHttpClient();
324
 
325
		String authString = "Basic "
326
				+ Base64.getEncoder().encodeToString(String.format("%s:%s", ACCOUNT_ID, SECRET_KEY).getBytes());
327
 
328
		Request request1 = new Request.Builder().url("https://v3.api.hypertrack.com/geofences/" + geofenceId).delete()
329
				.addHeader("Authorization", authString).build();
330
 
331
		Response response = client.newCall(request1).execute();
332
		return responseSender.ok(response.body().string());
333
 
334
	}
335
 
27417 tejbeer 336
}