function GetCurrentMP($mp, $date, $error = true)
{
global $_openSIS;
switch ($mp) {
case 'FY':
$table = 'school_years';
break;
case 'SEM':
$table = 'school_semesters';
break;
case 'QTR':
$table = 'school_quarters';
break;
case 'PRO':
$table = 'school_progress_periods';
break;
}
if (!$_openSIS['GetCurrentMP'][$date][$mp]) {
$_openSIS['GetCurrentMP'][$date][$mp] = DBGet(DBQuery('SELECT MARKING_PERIOD_ID FROM ' . $table . ' WHERE \'' . $date . '\' BETWEEN START_DATE AND END_DATE AND SYEAR=\'' . UserSyear() . '\' AND SCHOOL_ID=\'' . UserSchool() . '\''));
}
if ($_openSIS['GetCurrentMP'][$date][$mp][1]['MARKING_PERIOD_ID']) {
return $_openSIS['GetCurrentMP'][$date][$mp][1]['MARKING_PERIOD_ID'];
} elseif (strpos($_SERVER['PHP_SELF'], 'Side.php') === false && $error == true) {
ErrorMessage(array('' . _("You are not currently in a marking period") . ''));
}
//ShowErr("You are not currently in a marking period");
}
function MailingLabel($address_id)
{
global $THIS_RET, $_openSIS;
$student_id = $THIS_RET['STUDENT_ID'];
if ($address_id && !$_openSIS['MailingLabel'][$address_id][$student_id]) {
$p_sql = 'SELECT sa.ID AS ADDRESS_ID,p.STAFF_ID AS PERSON_ID,
coalesce((SELECT STREET_ADDRESS_1 FROM student_address WHERE STUDENT_ID=sa.STUDENT_ID AND TYPE =\'MAIL\'),sa.STREET_ADDRESS_1) AS ADDRESS,
coalesce((SELECT CITY FROM student_address WHERE STUDENT_ID=sa.STUDENT_ID AND TYPE =\'MAIL\'),sa.CITY) AS CITY,
coalesce((SELECT STATE FROM student_address WHERE STUDENT_ID=sa.STUDENT_ID AND TYPE =\'MAIL\'),sa.STATE) AS STATE,
coalesce((SELECT ZIPCODE FROM student_address WHERE STUDENT_ID=sa.STUDENT_ID AND TYPE =\'MAIL\'),sa.ZIPCODE) AS ZIPCODE,
s.PHONE,p.LAST_NAME,p.FIRST_NAME,p.MIDDLE_NAME
FROM student_address sa,people p,students s
WHERE p.STAFF_ID=sa.PEOPLE_ID AND s.STUDENT_ID=sa.STUDENT_ID AND sa.STUDENT_ID=\'' . $student_id . '\' AND p.CUSTODY=\'Y\'';
$people_RET = DBGet(DBQuery($p_sql), array(), array('LAST_NAME'));
if (count($people_RET)) {
foreach ($people_RET as $last_name => $people) {
for ($i = 1; $i < count($people); $i++) {
$return .= $people[$i]['FIRST_NAME'] . ' & ';
}
$return .= $people[$i]['FIRST_NAME'] . ' ' . $people[$i]['LAST_NAME'] . '<BR>';
}
// mab - this is a bit of a kludge but insert an html comment so people and address can be split later
$return .= '<!-- -->' . $people[$i]['ADDRESS'] . '<BR>' . $people[$i]['CITY'] . ', ' . $people[$i]['STATE'] . ' ' . $people[$i]['ZIPCODE'];
}
$_openSIS['MailingLabel'][$address_id][$student_id] = $return;
}
return $_openSIS['MailingLabel'][$address_id][$student_id];
}
function AllowUse($modname = false)
{
global $_openSIS;
if (!$modname) {
$modname = $_REQUEST['modname'];
}
if ($modname == 'Students/Student.php' && $_REQUEST['category_id']) {
$modname = $modname . '&category_id=' . $_REQUEST['category_id'];
}
if (!$_openSIS['AllowUse']) {
if (User('PROFILE_ID') != '') {
$_openSIS['AllowUse'] = DBGet(DBQuery("SELECT MODNAME FROM PROFILE_EXCEPTIONS WHERE PROFILE_ID='" . User('PROFILE_ID') . "' AND CAN_USE='Y'"), array(), array('MODNAME'));
} else {
$_openSIS['AllowUse'] = DBGet(DBQuery("SELECT MODNAME FROM STAFF_EXCEPTIONS WHERE USER_ID='" . User('STAFF_ID') . "' AND CAN_USE='Y'"), array(), array('MODNAME'));
}
}
if (!$_openSIS['AllowUse']) {
$_openSIS['AllowUse'] = array(true);
}
if (count($_openSIS['AllowUse'][$modname])) {
return true;
} else {
return false;
}
}
function GetSyear($date)
{
//$RET = DBGet(DBQuery("SELECT SYEAR FROM ATTENDANCE_CALENDAR WHERE SCHOOL_DATE = '$date' AND DEFAULT_CALENDAR='Y'"));
//$RET = DBGet(DBQuery("SELECT SYEAR FROM SCHOOL_MARKING_PERIODS WHERE MP='FY' AND '".$date."' BETWEEN START_DATE AND END_DATE"));
$RET = DBGet(DBQuery("SELECT max(SYEAR) AS SYEAR FROM SCHOOL_MARKING_PERIODS WHERE MP='FY' AND START_DATE<='" . $date . "'"));
return $RET[1]['SYEAR'];
}
function enrol_manual_enrol_users_object()
{
//first, gather the necessary variables
global $student_id, $course_period;
//then, convert variables for the Moodle object:
/*
list of (
object {
roleid int //Role to assign to the user
userid int //The user that is going to be enrolled
courseid int //The course to enrol the user role in
timestart int Optionnel //Timestamp when the enrolment start
timeend int Optionnel //Timestamp when the enrolment end
suspend int Optionnel //set to 1 to suspend the enrolment
}
)*/
//student's roleid = student = 5
$roleid = 5;
//get the Moodle user ID
$userid = DBGet(DBQuery("SELECT moodle_id FROM moodlexrosario WHERE rosario_id='" . $student_id . "' AND \"column\"='student_id'"));
if (count($userid)) {
$userid = (int) $userid[1]['MOODLE_ID'];
} else {
return null;
}
//gather the Moodle course ID
$courseid = DBGet(DBQuery("SELECT moodle_id FROM moodlexrosario WHERE rosario_id='" . $course_period['COURSE_PERIOD_ID'] . "' AND \"column\"='course_period_id'"));
if (count($courseid)) {
$courseid = (int) $courseid[1]['MOODLE_ID'];
} else {
return null;
}
$enrolments = array(array('roleid' => $roleid, 'userid' => $userid, 'courseid' => $courseid));
return array($enrolments);
}
function obtenerArancel($colegio_ID, $curso, $aran_anio)
{
DBConnect($this->dbh, BD_SIGA);
$SQL = "SELECT * FROM arancel WHERE FK_colegios_colegio_ID = '{$colegio_ID}'\r\n AND FK_curso = '{$curso}'\r\n AND aran_anio = '{$aran_anio}'";
$result = DBQuery($SQL, $this->dbh);
$row = DBFetchArray($result);
DBConnect($dbh);
//dpr($_SESSION['colegio']->colegio_ID);
if (!$row['aran_monto']) {
switch ($_SESSION['colegio']->colegio_ID) {
case "abello":
$row['aran_monto'] = ArancelColegio::ABELLO;
break;
case "edupac":
$row['aran_monto'] = ArancelColegio::EDUPAC;
break;
case "dor":
if (substr($curso, 0, -1) >= 9) {
$row['aran_monto'] = ArancelColegio::DOR_MEDIA;
} else {
$row['aran_monto'] = ArancelColegio::DOR_BASICA;
}
break;
}
//$_SESSION[''] =
}
return $row;
}
function GetStaffList(&$extra)
{
global $profiles_RET;
$functions = array('PROFILE' => 'makeProfile');
switch (User('PROFILE')) {
case 'admin':
$profiles_RET = DBGet(DBQuery("SELECT * FROM USER_PROFILES"), array(), array('ID'));
$sql = "SELECT CONCAT(\n\t\t\t\t\tCOALESCE(s.LAST_NAME,' '),', ',COALESCE(s.FIRST_NAME,' '),' ',COALESCE(s.MIDDLE_NAME,' ')) AS FULL_NAME,\n\t\t\t\t\ts.PROFILE,s.PROFILE_ID,s.STAFF_ID,s.SCHOOLS " . $extra['SELECT'] . "\n\t\t\t\tFROM\n\t\t\t\t\tSTAFF s " . $extra['FROM'] . "\n\t\t\t\tWHERE\n\t\t\t\t\ts.SYEAR='" . UserSyear() . "'";
if ($_REQUEST['_search_all_schools'] != 'Y') {
$sql .= " AND (s.SCHOOLS LIKE '%," . UserSchool() . ",%' OR s.SCHOOLS IS NULL OR s.SCHOOLS='') ";
}
if ($_REQUEST['username']) {
$sql .= "AND UPPER(s.USERNAME) LIKE '" . strtoupper($_REQUEST['username']) . "%' ";
}
if ($_REQUEST['last']) {
$sql .= "AND UPPER(s.LAST_NAME) LIKE '" . strtoupper($_REQUEST['last']) . "%' ";
}
if ($_REQUEST['first']) {
$sql .= "AND UPPER(s.FIRST_NAME) LIKE '" . strtoupper($_REQUEST['first']) . "%' ";
}
if ($_REQUEST['profile']) {
$sql .= "AND s.PROFILE='" . $_REQUEST['profile'] . "' ";
}
$sql .= $extra['WHERE'] . ' ';
$sql .= "ORDER BY FULL_NAME";
if ($extra['functions']) {
$functions += $extra['functions'];
}
return DBGet(DBQuery($sql), $functions);
break;
}
}
function obtenerDB($db_ID)
{
$SQL = "SELECT * FROM db WHERE db_ID = '{$db_ID}'";
$result = DBQuery($SQL, $this->dbh);
$row = DBFetchArray($result);
return (object) $row;
}
function MailingLabel($address_id)
{
global $THIS_RET, $_openSIS;
$student_id = $THIS_RET['STUDENT_ID'];
if ($address_id && !$_openSIS['MailingLabel'][$address_id][$student_id]) {
$people_RET = DBGet(DBQuery('SELECT a.ADDRESS_ID,p.PERSON_ID,
coalesce(a.MAIL_ADDRESS,a.ADDRESS) AS ADDRESS,coalesce(a.MAIL_CITY,a.CITY) AS CITY,coalesce(a.MAIL_STATE,a.STATE) AS STATE,coalesce(a.MAIL_ZIPCODE,a.ZIPCODE) AS ZIPCODE,a.PHONE,
p.LAST_NAME,p.FIRST_NAME,p.MIDDLE_NAME
FROM address a,people p,students_join_people sjp
WHERE a.ADDRESS_ID=\'' . $address_id . '\' AND a.ADDRESS_ID=sjp.ADDRESS_ID AND p.PERSON_ID=sjp.PERSON_ID
AND sjp.CUSTODY=\'Y\' AND sjp.STUDENT_ID=\'' . $student_id . '\''), array(), array('LAST_NAME'));
if (count($people_RET)) {
foreach ($people_RET as $last_name => $people) {
for ($i = 1; $i < count($people); $i++) {
$return .= $people[$i]['FIRST_NAME'] . ' & ';
}
$return .= $people[$i]['FIRST_NAME'] . ' ' . $people[$i]['LAST_NAME'] . '<BR>';
}
// mab - this is a bit of a kludge but insert an html comment so people and address can be split later
$return .= '<!-- -->' . $people[$i]['ADDRESS'] . '<BR>' . $people[$i]['CITY'] . ', ' . $people[$i]['STATE'] . ' ' . $people[$i]['ZIPCODE'];
} else {
$address_ret = DBGet(DBQuery('SELECT coalesce(MAIL_ADDRESS,ADDRESS) as ADDRESS,coalesce(MAIL_CITY,CITY) AS CITY,coalesce(MAIL_STATE,STATE) AS STATE,coalesce(MAIL_ZIPCODE,ZIPCODE) AS ZIPCODE FROM address WHERE ADDRESS_ID=\'' . $address_id . '\''));
$return .= '<!-- -->' . $address_ret[1]['ADDRESS'] . '<BR>' . $address_ret[1]['CITY'] . ', ' . $address_ret[1]['STATE'] . ' ' . $address_ret[1]['ZIPCODE'];
}
$_openSIS['MailingLabel'][$address_id][$student_id] = $return;
}
return $_openSIS['MailingLabel'][$address_id][$student_id];
}
function core_user_update_users_object()
{
//first, gather the necessary variables
global $_REQUEST;
//gather the Moodle user ID
if (User('PROFILE') == 'student') {
$rosario_id = UserStudentID();
$moodle_id = DBGet(DBQuery("SELECT moodle_id FROM moodlexrosario WHERE rosario_id='" . $rosario_id . "' AND \"column\"='student_id'"));
} else {
$rosario_id = User('STAFF_ID');
$moodle_id = DBGet(DBQuery("SELECT moodle_id FROM moodlexrosario WHERE rosario_id='" . $rosario_id . "' AND \"column\"='staff_id'"));
}
if (count($moodle_id)) {
$moodle_id = (double) $moodle_id[1]['MOODLE_ID'];
} else {
return '';
}
//then, convert variables for the Moodle object:
/*
list of (
object {
id double //ID of the user
password string Optional //Plain text password consisting of any characters
//note Francois: the password must respect the Moodle policy: 8 chars min., 1 number, 1 min, 1 maj and 1 non-alphanum at least.
}
)
*/
$password = $_REQUEST['values']['new'];
$users = array(array('id' => $moodle_id, 'password' => $password));
return array($users);
}
function DeCodeds($value, $column)
{
global $_openSIS;
$field = substr($column, 7);
if (!$_openSIS['DeCodeds'][$field]) {
$select_options = DBGet(DBQuery('SELECT SELECT_OPTIONS FROM custom_fields WHERE ID=\'' . $field . '\''));
$select_options = str_replace("\n", "\r", str_replace("\r\n", "\r", $select_options[1]['SELECT_OPTIONS']));
$select_options = explode("\r", $select_options);
foreach ($select_options as $option) {
$option = explode('|', $option);
if ($option[0] != '' && $option[1] != '') {
$options[$option[0]] = $option[1];
}
}
if (count($options)) {
$_openSIS['DeCodeds'][$field] = $options;
} else {
$_openSIS['DeCodeds'][$field] = true;
}
}
if ($value != '') {
if ($_openSIS['DeCodeds'][$field][$value] != '') {
return $_openSIS['DeCodeds'][$field][$value];
} else {
return "<FONT color=red>{$value}</FONT>";
}
} else {
return '';
}
}
function GetCpDet($cp_id, $key)
{
if ($key != '' && $cp_id != '') {
$get_det = DBGet(DBQuery('SELECT ' . strtoupper($key) . ' FROM course_periods WHERE COURSE_PERIOD_ID=' . $cp_id));
}
return $get_det[1][strtoupper($key)];
}
public static function searchStudents($value)
{
$query = "SELECT\r\n\t\t\t\t S.last_name,\r\n\t\t\t\t S.first_name,\r\n\t\t\t\t S.middle_name,\r\n\t\t\t\t S.student_id,\r\n\t\t\t\t GL.title\r\n\t\t\t\t FROM\r\n\t\t\t\t SCHOOL_GRADELEVELS GL,\r\n\t\t\t\t STUDENTS S,\r\n\t\t\t\t STUDENT_ENROLLMENT SE\r\n\t\t\t\t WHERE\r\n\t\t\t\t S.student_id = SE.student_id\r\n\t\t\t\t and SE.grade_id = GL.id\r\n\t\t\t\t and\r\n\t\t\t\t (\r\n\t\t\t\t lower(S.last_name) like lower('%{$value}%')\r\n\t\t\t\t or lower(S.first_name) like lower('%{$value}%')\r\n\t\t\t\t or lower(S.first_name || ' ' || S.last_name) like lower('%{$value}%')\r\n )";
if (is_numeric($value)) {
$query = $query . " or S.student_id = {$value}";
}
$result = DBQuery($query);
$json = '"users":[';
while ($row = db_fetch_row($result)) {
$lastName = $row['LAST_NAME'];
$firstName = $row['FIRST_NAME'];
$middle = $row['MIDDLE_NAME'];
$id = $row['STUDENT_ID'];
$grade = $row['TITLE'];
$json = $json . '{
"id":"' . $id . '",
"first":"' . $firstName . '",
"last":"' . $lastName . '",
"middle":"' . $middle . '",
"grade":"' . $grade . '"
},';
}
$json = rtrim($json, ",");
$json = $json . ']';
return $json;
}
function GetCurrentMP($mp, $date, $error = true)
{
global $_openSIS;
switch ($mp) {
case 'FY':
$table = 'SCHOOL_YEARS';
break;
case 'SEM':
$table = 'SCHOOL_SEMESTERS';
break;
case 'QTR':
$table = 'SCHOOL_QUARTERS';
break;
case 'PRO':
$table = 'SCHOOL_PROGRESS_PERIODS';
break;
}
if (!$_openSIS['GetCurrentMP'][$date][$mp]) {
$_openSIS['GetCurrentMP'][$date][$mp] = DBGet(DBQuery("SELECT MARKING_PERIOD_ID FROM {$table} WHERE '{$date}' BETWEEN START_DATE AND END_DATE AND SYEAR='" . UserSyear() . "' AND SCHOOL_ID='" . UserSchool() . "'"));
}
if ($_openSIS['GetCurrentMP'][$date][$mp][1]['MARKING_PERIOD_ID']) {
return $_openSIS['GetCurrentMP'][$date][$mp][1]['MARKING_PERIOD_ID'];
} elseif (strpos($_SERVER['PHP_SELF'], 'Side.php') === false && $error == true) {
ErrorMessage(array("You are not currently in a marking period"));
}
//ShowErr("You are not currently in a marking period");
}
function AllowUse($modname = false)
{
global $_openSIS;
if (!$modname) {
$modname = $_REQUEST['modname'];
}
if ($modname == 'Students/Student.php' && $_REQUEST['category_id']) {
$modname = $modname . '&category_id=' . $_REQUEST['category_id'];
}
if (!$_openSIS['AllowUse']) {
if (User('PROFILE_ID') != '') {
$_openSIS['AllowUse'] = DBGet(DBQuery('SELECT MODNAME FROM profile_exceptions WHERE PROFILE_ID=\'' . User('PROFILE_ID') . '\' AND CAN_USE=\'Y\''), array(), array('MODNAME'));
} else {
$_openSIS['AllowUse'] = DBGet(DBQuery('SELECT MODNAME FROM staff_exceptions WHERE USER_ID=\'' . User('STAFF_ID') . '\' AND CAN_USE=\'Y\''), array(), array('MODNAME'));
}
}
if (!$_openSIS['AllowUse']) {
$_openSIS['AllowUse'] = array(true);
}
if (count($_openSIS['AllowUse'][$modname])) {
return true;
} else {
return false;
}
}
function UpdateAttendanceDaily($student_id, $date = '', $comment = false)
{
$daysWeek = _('SuMoTuWeThFrSa');
/// Days of the week
if (!$date) {
$date = DBDate();
}
$sql = "SELECT\n\t\t\t\tsum(sp.LENGTH) AS TOTAL\n\t\t\tFROM SCHEDULE s,COURSE_PERIODS cp,SCHOOL_PERIODS sp,ATTENDANCE_CALENDAR ac\n\t\t\tWHERE\n\t\t\t\ts.COURSE_PERIOD_ID = cp.COURSE_PERIOD_ID AND position(',0,' IN cp.DOES_ATTENDANCE)>0\n\t\t\t\tAND ac.SCHOOL_DATE='{$date}' AND (ac.BLOCK=sp.BLOCK OR sp.BLOCK IS NULL)\n\t\t\t\tAND ac.CALENDAR_ID=cp.CALENDAR_ID AND ac.SCHOOL_ID=s.SCHOOL_ID AND ac.SYEAR=s.SYEAR\n\t\t\t\tAND s.SYEAR = cp.SYEAR AND sp.PERIOD_ID = cp.PERIOD_ID\n\t\t\t\tAND position(substring('{$daysWeek}' FROM cast(extract(DOW FROM cast('{$date}' AS DATE)) AS INT)*2+1 FOR 2) IN cp.DAYS)>0\n\t\t\t\tAND s.STUDENT_ID='{$student_id}'\n\t\t\t\tAND s.SYEAR='" . UserSyear() . "'\n\t\t\t\tAND ('{$date}' BETWEEN s.START_DATE AND s.END_DATE OR (s.END_DATE IS NULL AND '{$date}'>=s.START_DATE))\n\t\t\t\tAND s.MARKING_PERIOD_ID IN (" . GetAllMP('QTR', GetCurrentMP('QTR', $date)) . ")\n\t\t\t";
$RET = DBGet(DBQuery($sql));
$total = $RET[1]['TOTAL'];
if ($total == 0) {
return;
}
$sql = "SELECT sum(sp.LENGTH) AS TOTAL\n\t\t\tFROM ATTENDANCE_PERIOD ap,SCHOOL_PERIODS sp,ATTENDANCE_CODES ac\n\t\t\tWHERE ap.STUDENT_ID='{$student_id}' AND ap.SCHOOL_DATE='{$date}' AND ap.PERIOD_ID=sp.PERIOD_ID AND ac.ID = ap.ATTENDANCE_CODE AND ac.STATE_CODE='A'\n\t\t\tAND sp.SYEAR='" . UserSyear() . "'";
$RET = DBGet(DBQuery($sql));
$total -= $RET[1]['TOTAL'];
$sql = "SELECT sum(sp.LENGTH) AS TOTAL\n\t\t\tFROM ATTENDANCE_PERIOD ap,SCHOOL_PERIODS sp,ATTENDANCE_CODES ac\n\t\t\tWHERE ap.STUDENT_ID='{$student_id}' AND ap.SCHOOL_DATE='{$date}' AND ap.PERIOD_ID=sp.PERIOD_ID AND ac.ID = ap.ATTENDANCE_CODE AND ac.STATE_CODE='H'\n\t\t\tAND sp.SYEAR='" . UserSyear() . "'";
$RET = DBGet(DBQuery($sql));
$total -= $RET[1]['TOTAL'] * 0.5;
if ($total >= 300) {
$length = '1.0';
} elseif ($total >= 150) {
$length = '.5';
} else {
$length = '0.0';
}
$current_RET = DBGet(DBQuery("SELECT MINUTES_PRESENT,STATE_VALUE,COMMENT FROM ATTENDANCE_DAY WHERE STUDENT_ID='{$student_id}' AND SCHOOL_DATE='{$date}'"));
if (count($current_RET) && $current_RET[1]['MINUTES_PRESENT'] != $total) {
DBQuery("UPDATE ATTENDANCE_DAY SET MINUTES_PRESENT='{$total}',STATE_VALUE='{$length}'" . ($comment !== false ? ",COMMENT='" . str_replace("\\'", "''", $comment) . "'" : '') . " WHERE STUDENT_ID='{$student_id}' AND SCHOOL_DATE='{$date}'");
} elseif (count($current_RET) && $comment !== false && $current_RET[1]['COMMENT'] != $comment) {
DBQuery("UPDATE ATTENDANCE_DAY SET COMMENT='" . str_replace("\\'", "''", $comment) . "' WHERE STUDENT_ID='{$student_id}' AND SCHOOL_DATE='{$date}'");
} elseif (count($current_RET) == 0) {
DBQuery("INSERT INTO ATTENDANCE_DAY (SYEAR,STUDENT_ID,SCHOOL_DATE,MINUTES_PRESENT,STATE_VALUE,MARKING_PERIOD_ID,COMMENT) values('" . UserSyear() . "','{$student_id}','{$date}','{$total}','{$length}','" . GetCurrentMP('QTR', $date) . "','" . str_replace("\\'", "''", $comment) . "')");
}
}
function PortalPollsDisplay($value, $name)
{
global $THIS_RET;
static $js_included = false;
$poll_id = $THIS_RET['ID'];
//get poll:
$poll_RET = DBGet(DBQuery("SELECT EXCLUDED_USERS, VOTES_NUMBER, DISPLAY_VOTES FROM PORTAL_POLLS WHERE ID='" . $poll_id . "'"));
$poll_questions_RET = DBGet(DBQuery("SELECT ID, QUESTION, OPTIONS, TYPE, VOTES FROM PORTAL_POLL_QUESTIONS WHERE PORTAL_POLL_ID='" . $poll_id . "' ORDER BY ID"));
if (!$poll_RET || !$poll_questions_RET) {
return ErrorMessage(array('Poll does not exist'));
}
//should never be displayed, so do not translate
//verify if user is in excluded users list (format = '|[profile_id]:[user_id]')
$profile_id = User('PROFILE_ID');
if ($profile_id != 0) {
//modif Francois: call right Student/Staff ID
$user_id = UserStaffID();
} else {
$user_id = UserStudentID();
}
$excluded_user = '******' . $profile_id . ':' . $user_id;
if (mb_strpos($poll_RET[1]['EXCLUDED_USERS'], $excluded_user) !== false) {
return PortalPollsVotesDisplay($poll_id, $poll_RET[1]['DISPLAY_VOTES'], $poll_questions_RET, $poll_RET[1]['VOTES_NUMBER']);
}
//user already voted, display votes
$PollForm = '';
if (!$js_included) {
$PollForm .= includeOnceJquery();
$PollForm .= '<script type="text/javascript" src="assets/js/jquery.form.js"></script>';
$PollForm .= '<script type="text/javascript">
$(document).ready(function() {
$(\'.formPortalPoll\').ajaxForm({ //send the votes in AJAX
success: function(data,status,xhr,form) {
$(form).parent().html(data);
}
});
});
</script>';
$js_included = true;
}
$PollForm .= '<div id="divPortalPoll' . $poll_id . '" style="max-height:350px; overflow-y:auto;"><form method="POST" class="formPortalPoll" action="ProgramFunctions/PortalPolls.fnc.php"><input type="hidden" name="profile_id" value="' . $profile_id . '" /><input type="hidden" name="user_id" value="' . $user_id . '" /><input type="hidden" name="total_votes_string" value="' . _('Total Participants') . '" /><input type="hidden" name="poll_completed_string" value="' . _('Poll completed') . '" /><TABLE class="width-100p cellspacing-0">';
foreach ($poll_questions_RET as $question) {
$PollForm .= '<TR><TD><b>' . $question['QUESTION'] . '</b></TD><TD><TABLE class="width-100p cellspacing-0">';
$options_array = explode('<br />', nl2br($question['OPTIONS']));
$checked = true;
foreach ($options_array as $option_nb => $option_label) {
if ($question['TYPE'] == 'multiple_radio') {
$PollForm .= '<TR><TD><label><input type="radio" name="votes[' . $poll_id . '][' . $question['ID'] . ']" value="' . $option_nb . '" ' . ($checked ? 'checked' : '') . ' /> ' . $option_label . '</label></TD></TR>' . "\n";
} else {
//multiple
$PollForm .= '<TR><TD><label><input type="checkbox" name="votes[' . $poll_id . '][' . $question['ID'] . '][]" value="' . $option_nb . '" /> ' . $option_label . '</label></TD></TR>' . "\n";
}
$checked = false;
}
$PollForm .= '</TABLE></TD></TR>';
}
$PollForm .= '</TD></TR></TABLE><P><input type="submit" value="' . _('Submit') . '" /></P></form></div>';
return $PollForm;
}
function _makeCalendar($value, $column)
{
global $THIS_RET, $_CENTRE, $calendars_RET;
if (!$calendars_RET) {
$calendars_RET = DBGet(DBQuery("SELECT CALENDAR_ID,DEFAULT_CALENDAR,TITLE FROM ATTENDANCE_CALENDARS WHERE SYEAR='" . UserSyear() . "'"), array(), array('CALENDAR_ID'));
}
return $calendars_RET[$value][1]['TITLE'];
}
function _makeCalendar($value, $column)
{
global $THIS_RET, $_openSIS, $calendars_RET;
if (!$calendars_RET) {
$calendars_RET = DBGet(DBQuery('SELECT CALENDAR_ID,DEFAULT_CALENDAR,TITLE FROM school_calendars WHERE SYEAR=\'' . UserSyear() . '\''), array(), array('CALENDAR_ID'));
}
return $calendars_RET[$value][1]['TITLE'];
}
function GetTeacher($teacher_id, $title = '', $column = 'FULL_NAME', $schools = true)
{
global $_openSIS;
if (!$_openSIS['GetTeacher']) {
$QI = DBQuery('SELECT STAFF_ID,CONCAT(LAST_NAME,\', \',FIRST_NAME) AS FULL_NAME,USERNAME,PROFILE FROM staff s INNER JOIN staff_school_relationship USING(staff_id),login_authentication la WHERE s.STAFF_ID=la.USER_ID AND s.PROFILE=\'teacher\' AND syear=' . UserSyear());
$_openSIS['GetTeacher'] = DBGet($QI, array(), array('STAFF_ID'));
}
return $_openSIS['GetTeacher'][$teacher_id][1][$column];
}
function GetPeriod($period_id, $title = '')
{
global $_openSIS;
if (!$_openSIS['GetPeriod']) {
$sql = 'SELECT TITLE, PERIOD_ID FROM school_periods WHERE SYEAR=\'' . UserSyear() . '\'';
$_openSIS['GetPeriod'] = DBGet(DBQuery($sql), array(), array('PERIOD_ID'));
}
return $_openSIS['GetPeriod'][$period_id][1]['TITLE'];
}
function GetTeacher($teacher_id, $title = '', $column = 'FULL_NAME', $schools = true)
{
global $_openSIS;
if (!$_openSIS['GetTeacher']) {
$QI = DBQuery("SELECT STAFF_ID,CONCAT(LAST_NAME,', ',FIRST_NAME) AS FULL_NAME,USERNAME,PROFILE FROM STAFF WHERE SYEAR='" . UserSyear() . "'" . ($schools ? " AND SCHOOLS LIKE '%," . UserSchool() . ",%'" : ''));
$_openSIS['GetTeacher'] = DBGet($QI, array(), array('STAFF_ID'));
}
return $_openSIS['GetTeacher'][$teacher_id][1][$column];
}
function GetPeriod($period_id, $title = '')
{
global $_CENTRE;
if (!$_CENTRE['GetPeriod']) {
$sql = "SELECT TITLE, PERIOD_ID FROM SCHOOL_PERIODS WHERE SYEAR='" . UserSyear() . "'";
$_CENTRE['GetPeriod'] = DBGet(DBQuery($sql), array(), array('PERIOD_ID'));
}
return $_CENTRE['GetPeriod'][$period_id][1]['TITLE'];
}
function _students($value, $column)
{
$RET = DBGet(DBQuery("SELECT s.FIRST_NAME||' '||s.LAST_NAME AS FULL_NAME FROM STUDENTS s,FOOD_SERVICE_STUDENT_ACCOUNTS fsa WHERE s.STUDENT_ID=fsa.STUDENT_ID AND fsa.ACCOUNT_ID='" . $value . "'"));
foreach ($RET as $student) {
$ret .= $student['FULL_NAME'] . '<br>';
}
$ret = substr($ret, 0, -4);
return $ret;
}
function UpdateSchoolArray($school_id = null)
{
if (!$school_id) {
$school_id = UserSyear();
}
$_SESSION['SchoolData'] = DBGet(DBQuery("SELECT * FROM SCHOOLS WHERE ID = '" . $school_id . "' AND SYEAR = '" . UserSyear() . "'"));
$_SESSION['SchoolData'] = $_SESSION['SchoolData'][1];
$_SESSION['SchoolData'];
}
function GetTeacher($teacher_id, $title = '', $column = 'FULL_NAME', $schools = true)
{
global $_CENTRE;
if (!$_CENTRE['GetTeacher']) {
$QI = DBQuery("SELECT STAFF_ID,LAST_NAME||', '||FIRST_NAME AS FULL_NAME,USERNAME,PROFILE FROM STAFF WHERE SYEAR='" . UserSyear() . "'" . ($schools ? " AND (SCHOOLS IS NULL OR SCHOOLS LIKE '%," . UserSchool() . ",%')" : ''));
$_CENTRE['GetTeacher'] = DBGet($QI, array(), array('STAFF_ID'));
}
return $_CENTRE['GetTeacher'][$teacher_id][1][$column];
}
function getStudentName($studentID)
{
$query = "select last_name,first_name,middle_name from students where student_id = {$studentID};";
$ret = DBGet(DBQuery($query));
$name = "";
if (!empty($ret)) {
$name = $ret[1]['LAST_NAME'] . ',' . $ret[1]['FIRST_NAME'] . ' ' . $ret[1]['MIDDLE_NAME'];
}
return $name;
}
function Config($item)
{
global $_ROSARIO, $DefaultSyear;
if (empty($_ROSARIO['Config']) || !isset($_ROSARIO['Config'][$item])) {
$QI = DBQuery("SELECT TITLE, CONFIG_VALUE FROM CONFIG WHERE " . (UserSchool() < 1 ? '' : "SCHOOL_ID='" . UserSchool() . "' OR") . " SCHOOL_ID='0'");
$_ROSARIO['Config'] = DBGet($QI, array(), array('TITLE'));
$_ROSARIO['Config']['SYEAR'][1]['CONFIG_VALUE'] = $DefaultSyear;
}
return $_ROSARIO['Config'][$item][1]['CONFIG_VALUE'];
}
function calc_salida_mes($mes)
{
DBConnect($dbh);
//dpr($mes);
$totalmes = 0;
$SQL = "SELECT SUM(cantidad) AS salidas_totales FROM salidas WHERE fecha LIKE '%/{$mes}/%'";
$result = DBQuery($SQL, $dbh);
$row = DBFetchArray($result);
return $row['salidas_totales'];
}
function Config($item)
{
global $_openSIS, $openSISTitle, $DefaultSyear;
if (!$_openSIS['Config']) {
$QI = DBQuery('SELECT LOGIN,TITLE,SYEAR FROM config');
$_openSIS['Config'] = DBGet($QI);
$_openSIS['Config'][1]['TITLE'] = $openSISTitle;
$_openSIS['Config'][1]['SYEAR'] = $DefaultSyear;
}
return $_openSIS['Config'][1][$item];
}
