Code Coverage for /opt/homebrew/var/www/html/Linways/ams-professional-core/src/com/linways/core/ams/professional/service/examcontroller/CourseService.php

	Code Coverage
	Classes and Traits			Functions and Methods				Lines
Total	0.00% covered (danger)	0.00%	0 / 1	0.00% covered (danger)	0.00%	0 / 12	CRAP	0.00% covered (danger)	0.00%	0 / 239
CourseService	0.00% covered (danger)	0.00%	0 / 1	0.00% covered (danger)	0.00%	0 / 12	992.00	0.00% covered (danger)	0.00%	0 / 239
__construct				0.00% covered (danger)	0.00%	0 / 1	2.00	0.00% covered (danger)	0.00%	0 / 2
__clone				0.00% covered (danger)	0.00%	0 / 1	2.00	0.00% covered (danger)	0.00%	0 / 2
getInstance				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 5
getCoursePatternByCourseTypeId				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 11
getPatternDeptCoursesByCoursePatternId				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 11
getCoursePatternByPatternId				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 11
InitiateCourseRegistration				0.00% covered (danger)	0.00%	0 / 1	30.00	0.00% covered (danger)	0.00%	0 / 68
CourseRegisteredDetails				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 18
updateVisiblity				0.00% covered (danger)	0.00%	0 / 1	12.00	0.00% covered (danger)	0.00%	0 / 22
updateCourseRegistration				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 14
getCourseRegistrationByBatchId				0.00% covered (danger)	0.00%	0 / 1	6.00	0.00% covered (danger)	0.00%	0 / 27
completeCourseRegistration				0.00% covered (danger)	0.00%	0 / 1	56.00	0.00% covered (danger)	0.00%	0 / 48

1	<?php
2	namespace com\linways\core\ams\professional\service\examcontroller;
3
4	use com\linways\core\ams\professional\exception\ProfessionalException;
5	use com\linways\core\ams\professional\service\BaseService;
6	use com\linways\core\ams\professional\service\InternalMarkService;
7	use stdClass;
8
9	class CourseService extends BaseService
10	{
11	// /Condition 1 - Presence of a static member variable
12	private static $_instance = null;
13	private $mapper = [];
14
15	// /Condition 2 - Locked down the constructor
16	private function __construct()
17	{
18	}
19	// Prevent any oustide instantiation of this class
20
21	// /Condition 3 - Prevent any object or instance of that class to be cloned
22	private function __clone()
23	{
24	}
25	// Prevent any copy of this object
26
27	// /Condition 4 - Have a single globally accessible static method
28	public static function getInstance()
29	{
30	if (!is_object(self::$_instance)) // or if( is_null(self::$_instance) ) or if( self::$_instance == null )
31	self::$_instance = new self ();
32
33	return self::$_instance;
34	}
35
36	/**
37	* @param Integer $courseTypeId
38	* @return Object\|null
39	* @throws ProfessionalException
40	* @author Vishnu M
41	*/
42	public function getCoursePatternByCourseTypeId($courseTypeId) {
43	$courseTypeId = $this->realEscapeString($courseTypeId);
44	$sql = null;
45	$coursePattern = null;
46	try {
47	$sql = "SELECT patternID AS id, patternName AS name, patternDesc AS description, courseTypeID AS courseTypeId FROM course_pattern WHERE courseTypeID = '$courseTypeId' ";
48	$coursePattern = $this->executeQueryForList($sql);
49	} catch (\Exception $e) {
50	throw new ProfessionalException($e->getCode(), $e->getMessage());
51	}
52	return $coursePattern;
53	}
54	/**
55	* @param Integer $courseTypeId
56	* @return Object\|null
57	* @throws ProfessionalException
58	* @author Vishnu M
59	*/
60	public function getPatternDeptCoursesByCoursePatternId($coursePatternId) {
61	$coursePatternId = $this->realEscapeString($coursePatternId);
62	$sql = null;
63	$patternDeptCourses = null;
64	try {
65	$sql = "SELECT patterncourseID AS id, patterncourseName AS name, patternID AS patternId, deptID AS deptId, patterncourseCode AS code, patternAbbreviation FROM pattern_deptcourses WHERE patternID = '$coursePatternId' ";
66	$patternDeptCourses = $this->executeQueryForList($sql);
67	} catch (\Exception $e) {
68	throw new ProfessionalException($e->getCode(), $e->getMessage());
69	}
70	return $patternDeptCourses;
71	}
72
73	/**
74	* @param Integer $patternId
75	* @return Array\|null
76	* @throws ProfessionalException
77	*/
78	public function getCoursePatternByPatternId($patternId) {
79	$patternId = $this->realEscapeString($patternId);
80	$sql = null;
81	$coursePattern = null;
82	try {
83	$sql = "SELECT patternID AS id, patternName AS name, patternDesc AS description, courseTypeID AS courseTypeId FROM course_pattern WHERE patternID = '$patternId' ";
84	$coursePattern = $this->executeQueryForObject($sql);
85	} catch (\Exception $e) {
86	throw new ProfessionalException($e->getCode(), $e->getMessage());
87	}
88	return $coursePattern;
89	}
90
91	/**
92	* @param Integer $patternId
93	* @return Object\|null
94	* @throws ProfessionalException
95	*/
96	public function InitiateCourseRegistration($batchID,$semID,$fromDate,$toDate) {
97	$batchID = $this->realEscapeString($batchID);
98	$semID = $this->realEscapeString($semID);
99	$fromDate = $this->realEscapeString($fromDate);
100	$toDate = $this->realEscapeString($toDate);
101
102	$sql = null;
103
104
105	$sql = "SELECT id FROM course_registration WHERE batchID = '$batchID' AND semID = '$semID'";
106	$alreadyExists = $this->executeQueryForList($sql);
107	if(count($alreadyExists) > 0)
108	{
109	$isUpdated = $this->updateCourseRegistration($batchID,$semID,$fromDate,$toDate);
110	if($isUpdated){
111	return true;
112	}
113	else{
114	return false;
115	}
116	}
117	try {
118	$students = [];
119	$sql = "SELECT studentID FROM studentaccount WHERE batchID = ".$batchID;
120	$studentsArr = InternalMarkService::getInstance()->getStudentByBatchSem($batchID);
121	// $studentsArr = $this->executeQueryForList($sql);
122	foreach($studentsArr as $st)
123	{
124	$stud = new stdClass();
125	$stud->id = $st->studentID;
126	$stud->attended = false;
127	$stud->dateAndTime = "";
128	$students[] = $stud;
129	}
130	$studentCount = count($students);
131	$studentAttended = 0;
132	$recordToSave = new stdClass();
133	$recordToSave->students = $students;
134	$recordToSave->studentCount = $studentCount;
135	$recordToSave->studentAttended = $studentAttended;
136	$recordToSave->dateAndTime = date("Y-m-d H:i:s");
137	$recordToSave = json_encode($recordToSave);
138	$sql = "INSERT
139	INTO
140	course_registration (semID,
141	batchID,
142	isActive,
143	fromDate,
144	toDate,
145	studentsConfirmed,
146	isConfirmed,
147	created_by,
148	created_date,
149	updated_by,
150	updated_date)";
151	$sql .=" VALUES('$semID',
152	'$batchID',
153	'1',
154	'$fromDate',
155	'$toDate',
156	'$recordToSave',
157	'0',".
158	$_SESSION['adminID'].",
159	'NOW()',
160	".$_SESSION['adminID'].",
161	'NOW()')";
162	$this->executeQuery($sql);
163	$courseDetails = $this->CourseRegisteredDetails($batchID,$semID);
164	} catch (\Exception $e) {
165	throw new ProfessionalException($e->getCode(), $e->getMessage());
166	}
167	return $courseDetails;
168	}
169
170	public function CourseRegisteredDetails($batchID,$semID)
171	{
172	$batchID = $this->realEscapeString($batchID);
173	$semID = $this->realEscapeString($semID);
174	$sql = null;
175	$courseDetails = null;
176	try {
177	$sql = "SELECT id,
178	fromDate,
179	toDate,
180	studentsConfirmed,
181	isActive
182	FROM course_registration WHERE batchID = '$batchID' AND semID = '$semID'";
183	$courseDetails = $this->executeQueryForObject($sql);
184	} catch (\Exception $e) {
185	throw new ProfessionalException($e->getCode(), $e->getMessage());
186	}
187	return $courseDetails;
188
189	}
190	public function updateVisiblity($batchID,$semID)
191	{
192	$batchID = $this->realEscapeString($batchID);
193	$sql = null;
194	try {
195	$sql = "SELECT isActive FROM course_registration WHERE batchID = '$batchID' AND semID = '$semID' ";
196	$status = $this->executeQueryForObject($sql);
197	if($status->isActive == '1')
198	{
199	$sql = "UPDATE course_registration SET isActive = '0' WHERE batchID = '$batchID' AND semID = '$semID' ";
200	$this->executeQuery($sql);
201	}
202	else
203	{
204	$sql = "UPDATE course_registration SET isActive = '1' WHERE batchID = '$batchID' AND semID = '$semID' ";
205	$this->executeQuery($sql);
206	}
207	$courseDetails = $this->CourseRegisteredDetails($batchID,$semID);
208	} catch (\Exception $e) {
209	throw new ProfessionalException($e->getCode(), $e->getMessage());
210	}
211	return $courseDetails;
212
213	}
214
215
216	public function updateCourseRegistration($batchID,$semID,$fromDate,$toDate)
217	{
218	$batchID = $this->realEscapeString($batchID);
219	$semID = $this->realEscapeString($semID);
220	$fromDate = $this->realEscapeString($fromDate);
221	$toDate = $this->realEscapeString($toDate);
222
223	$sql = null;
224	try {
225	$sql = "UPDATE course_registration SET fromDate = '$fromDate',toDate = '$toDate' WHERE batchID = '$batchID' and semID = '$semID'";
226	$this->executeQuery($sql);
227	} catch (\Exception $e) {
228	throw new ProfessionalException($e->getCode(), $e->getMessage());
229	}
230	return true;
231
232	}
233
234
235	public function getCourseRegistrationByBatchId($batchID,$semID)
236	{
237	$batchID = $this->realEscapeString($batchID);
238	$semID = $this->realEscapeString($semID);
239	$currentDate = date('Y-m-d')." 00:00:00";
240	try {
241	$sql = "SELECT semID,
242	batchID,
243	isActive,
244	fromDate,
245	toDate,
246	studentsConfirmed,
247	isConfirmed,
248	created_by,
249	created_date,
250	updated_by,
251	updated_date
252	FROM course_registration
253	WHERE batchID = '$batchID' AND
254	semID = '$semID' AND
255	isActive ='1' AND
256	'$currentDate' BETWEEN fromDate AND toDate";
257	$batchData = $this->executeQueryForObject($sql);
258	} catch (\Exception $e) {
259	throw new ProfessionalException($e->getCode(), $e->getMessage());
260	}
261
262	return$batchData;
263
264	}
265	public function completeCourseRegistration($studentID)
266	{
267	try
268	{
269	$studentID = $this->realEscapeString($studentID);
270	$sql = "SELECT ba.batchID,s.semID from studentaccount sa INNER JOIN batches ba on ba.batchID = sa.batchID INNER JOIN semesters s on ba.semID = s.semID WHERE studentID = '$studentID'";
271	$res = $this->executeQueryForObject($sql);
272	$batchID = $res->batchID;
273	$semID = $res->semID;
274	$data = $this->getCourseRegistrationByBatchId($batchID,$semID);
275	if($data)
276	{
277	$studentsData = json_decode($data->studentsConfirmed);
278	$students = $studentsData->students;
279	$studentAttended = (int)$studentsData->studentAttended;
280	$studentCount = $studentsData->studentCount;
281	if(count($students)>0)
282	{
283	foreach($students as $student)
284	{
285	if($student->id == $studentID)
286	{
287	if($student->attended)
288	{
289	$student->attended = true;
290	$student->dateAndTime = date("Y-m-d H:i:s");
291
292	}
293	else{
294	$student->attended = true;
295	$studentAttended++;
296	$student->dateAndTime = date("Y-m-d H:i:s");
297
298	}
299	}
300	}
301	$studentsConfirmed = new stdClass();
302	$studentsConfirmed->students = $students;
303	$studentsConfirmed->studentAttended = $studentAttended;
304	$studentsConfirmed->studentCount = $studentCount;
305	$recordToUpdate = json_encode($studentsConfirmed);
306	$sql = "UPDATE course_registration SET studentsConfirmed = '$recordToUpdate' WHERE batchID = '$batchID' and semID = '$semID'";
307	$this->executeQuery($sql);
308	}
309	}
310
311	} catch (\Exception $e) {
312	throw new ProfessionalException($e->getCode(), $e->getMessage());
313	return false;
314	}
315	return true;
316	}
317
318	}