forked from OS4ED/openSIS-Classic
-
Notifications
You must be signed in to change notification settings - Fork 0
/
CheckDuplicateStudent.php
70 lines (69 loc) · 3.58 KB
/
CheckDuplicateStudent.php
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
<?php
#**************************************************************************
# openSIS is a free student information system for public and non-public
# schools from Open Solutions for Education, Inc. web: www.os4ed.com
#
# openSIS is web-based, open source, and comes packed with features that
# include student demographic info, scheduling, grade book, attendance,
# report cards, eligibility, transcripts, parent portal,
# student portal and more.
#
# Visit the openSIS web site at http://www.opensis.com to learn more.
# If you have question regarding this system or the license, please send
# an email to [email protected].
#
# This program is released under the terms of the GNU General Public License as
# published by the Free Software Foundation, version 2 of the License.
# See license.txt.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
#
#***************************************************************************************
include('RedirectRootInc.php');
include('Warehouse.php');
include'ConfigInc.php';
$student_fname= $_REQUEST['fn'];
$student_mname = $_REQUEST['mn'];
$student_lname = $_REQUEST['ln'];
$student_byear = $_REQUEST['byear'];
$student_bmonth = $_REQUEST['bmonth'];
$student_bday = $_REQUEST['bday'];
if($student_bmonth == 'JAN')
$student_bmonth = '01';
elseif($student_bmonth == 'FEB')
$student_bmonth = '02';
elseif($student_bmonth == 'MAR')
$student_bmonth = '03';
elseif($student_bmonth == 'APR')
$student_bmonth = '04';
elseif($student_bmonth == 'MAY')
$student_bmonth = '05';
elseif($student_bmonth == 'JUN')
$student_bmonth = '06';
elseif($student_bmonth == 'JUL')
$student_bmonth = '07';
elseif($student_bmonth == 'AUG')
$student_bmonth = '08';
elseif($student_bmonth == 'SEP')
$student_bmonth = '09';
elseif($student_bmonth == 'OCT')
$student_bmonth = '10';
elseif($student_bmonth == 'NOV')
$student_bmonth = '11';
elseif($student_bmonth == 'DEC')
$student_bmonth = '12';
$student_birthday =trim($student_byear).'-'. trim($student_bmonth).'-'. trim($student_bday);
if(trim($student_mname)=='')
$chechk_stu = 'SELECT s.student_id AS ID FROM students s,student_enrollment se WHERE s.student_id=se.student_id AND lcase(s.last_name)="'.strtolower($student_lname).'" AND lcase(s.first_name)="'.strtolower($student_fname).'" AND (lcase(s.middle_name)="" OR lcase(s.middle_name) IS NULL ) AND s.birthdate="'.$student_birthday.'" AND se.syear="'.$_SESSION['UserSyear'].'" AND se.school_id="'.$_SESSION['UserSchool'].'" ';
else
$chechk_stu = 'SELECT s.student_id AS ID FROM students s,student_enrollment se WHERE s.student_id=se.student_id AND lcase(s.last_name)="'.strtolower($student_lname).'" AND lcase(s.first_name)="'.strtolower($student_fname).'" AND lcase(s.middle_name)="'.strtolower($student_mname).'" AND s.birthdate="'.$student_birthday.'" AND se.syear="'.$_SESSION['UserSyear'].'" AND se.school_id="'.$_SESSION['UserSchool'].'" ';
$chechk_stu_result = DBGet(DBQuery($chechk_stu));
$prev_student = count($chechk_stu_result);
echo $prev_student;
?>