PopTable('header', 'Log Details');
echo '<div align=center style="padding-top:20px; font-size:12px;"><strong>Please Select Date Range</strong></div>
<TABLE border=0 width=100% align=center><tr><TD valign=top style=padding-top:14px;>';
echo '<strong>From :</strong> </TD><TD valign=middle>';
DrawHeader(PrepareDate($start_date, '_start'));
echo '</TD><TD valign=top style=padding-top:14px;><strong>To :</strong> </TD><TD valign=middle>';
DrawHeader(PrepareDate($end_date, '_end'));
echo '</TD></TR></TABLE><div style=height:10px></div>';
echo '<center><input type="submit" class=btn_medium value="Generate" name="generate"></center>';
PopTable('footer');
echo '</FORM>';
}
if ($_REQUEST['day_start'] && $_REQUEST['month_start'] && $_REQUEST['year_start']) {
$start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . substr($_REQUEST['year_start'], 2, 4);
$org_start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . $_REQUEST['year_start'];
$conv_st_date = con_date($org_start_date);
}
if ($_REQUEST['day_end'] && $_REQUEST['month_end'] && $_REQUEST['year_end']) {
$end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . substr($_REQUEST['year_end'], 2, 4);
$org_end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . $_REQUEST['year_end'];
$conv_end_date = con_date_end($org_end_date);
}
if ($_REQUEST['modfunc'] == 'generate') {
if (isset($conv_st_date) && isset($conv_end_date)) {
#$alllogs_RET = DBGet(DBQuery("SELECT DISTINCT FIRST_NAME,LAST_NAME,LOGIN_TIME,PROFILE,FAILLOG_COUNT,FAILLOG_TIME,USER_NAME,IP_ADDRESS,STATUS FROM login_records WHERE LOGIN_TIME >='".$conv_st_date."' AND LOGIN_TIME <='".$conv_end_date."' AND SCHOOL_ID=".UserSchool()." OR STATUS='Failed' ORDER BY LOGIN_TIME DESC"));
$alllogs_RET = DBGet(DBQuery('SELECT DISTINCT FIRST_NAME,LAST_NAME,LOGIN_TIME,PROFILE,FAILLOG_COUNT,FAILLOG_TIME,USER_NAME,IP_ADDRESS,STATUS FROM login_records WHERE LOGIN_TIME >=\'' . $conv_st_date . '\' AND LOGIN_TIME <=\'' . $conv_end_date . '\' AND SCHOOL_ID=' . UserSchool() . ' ORDER BY LOGIN_TIME DESC'));
if (count($alllogs_RET)) {
echo '<div>';
#ListOutput($alllogs_RET,array('LOGIN_TIME'=>'Login Time','USER_NAME'=>'User Name','FIRST_NAME'=>'First Name','LAST_NAME'=>'Last Name','FAILLOG_COUNT'=>'Failure Count','STATUS'=>'Status','IP_ADDRESS'=>'IP Address'),'login record','login records',array(),array(),array('count'=>true,'save'=>true));
ListOutput($alllogs_RET, array('LOGIN_TIME' => 'Login Time', 'USER_NAME' => 'User Name', 'FIRST_NAME' => 'First Name', 'LAST_NAME' => 'Last Name', 'PROFILE' => 'Profile', 'FAILLOG_COUNT' => 'Failure Count', 'STATUS' => 'Status', 'IP_ADDRESS' => 'IP Address'), 'login record', 'login records', array(), array(), array('count' => true, 'save' => true));
echo '</div>';
} elseif ($temp_month == 'AUG') {
$month = '-08-';
} elseif ($temp_month == 'SEP') {
$month = '-09-';
} elseif ($temp_month == 'OCT') {
$month = '-10-';
} elseif ($temp_month == 'NOV') {
$month = '-11-';
} elseif ($temp_month == 'DEC') {
$month = '-12-';
}
$day = substr($mother_date, 0, 2);
$select_date = $year . $month . $day;
return $select_date;
}
$convdate = con_date($start_date);
$course_per_id = $_SESSION['MassSchedule.php']['course_period_id'];
////Start Date Check///////////////////
$start_date_q = DBGet(DBQuery('SELECT START_DATE FROM school_years WHERE school_id=' . UserSchool() . ' AND syear=' . UserSyear() . ''));
if (strtotime($start_date_q[1]['START_DATE']) > strtotime($convdate)) {
$start_date_q_clash = 'Cannot schedule students before school start date';
} else {
if (strtotime($convdate) < strtotime($course_bg_date[1]['BEGIN_DATE']) || strtotime($convdate) > strtotime($course_bg_date[1]['END_DATE'])) {
$sche_date_err = ' students schedule date should be between course start date and end date';
} else {
unset($start_date_q_clash);
unset($sche_date_err);
foreach ($_REQUEST['student'] as $index => $value) {
$_SESSION['NOT_SCHEDULE'][$index] = $index;
$_SESSION['NOT_SCHEDULE1'][$index] = $index;
$stu_start_date_q = DBGet(DBQuery('SELECT START_DATE FROM student_enrollment WHERE STUDENT_ID=' . $index . ' AND school_id=' . UserSchool() . ' AND syear=' . UserSyear() . ''));
$dt_arr[0] = 12;
}
return implode('/', $dt_arr);
}
# --------------------------------------------- date Convertion End ------------------------------------------------- #
$final_date = con_date($temp_date);
if ($_REQUEST['dt'] == 1) {
$final_date = $_SESSION['date_attn'];
}
$_REQUEST['dt'] = 0;
if ($_REQUEST['month_date'] && $_REQUEST['day_date'] && $_REQUEST['year_date']) {
while (!VerifyDate($date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . $_REQUEST['year_date'])) {
$_REQUEST['day_date']--;
}
$posted_date = ucfirst(strtolower($_REQUEST['month_date'])) . '/' . $_REQUEST['day_date'] . '/' . $_REQUEST['year_date'];
$final_date = con_date($posted_date);
unset($_SESSION['date_attn']);
$_SESSION['date_attn'] = $final_date;
} else {
if (!$temp_date) {
$final_date = date('n/j/Y');
$_REQUEST['month_date'] = strtoupper(date('M'));
$_REQUEST['day_date'] = date('j');
$_REQUEST['year_date'] = date('y');
} else {
$temp_arr = explode('/', $temp_date);
$_REQUEST['month_date'] = $temp_arr[0];
$_REQUEST['day_date'] = $temp_arr[1];
$_REQUEST['year_date'] = $temp_arr[2];
}
}
# 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 '../../Redirect_modules.php';
if ($_REQUEST['day_start'] && $_REQUEST['month_start'] && $_REQUEST['year_start']) {
$start_date = $_REQUEST['day_start'] . '-' . $_REQUEST['month_start'] . '-' . $_REQUEST['year_start'];
$st_dt = con_date($start_date);
}
if ($_REQUEST['day_end'] && $_REQUEST['month_end'] && $_REQUEST['year_end']) {
$end_date = $_REQUEST['day_end'] . '-' . $_REQUEST['month_end'] . '-' . $_REQUEST['year_end'];
$end_dt = con_date($end_date);
}
if ($_REQUEST['chk_pro']) {
$progress = $_REQUEST['chk_pro'];
}
if ($_REQUEST['modfunc'] == 'save') {
if (count($_REQUEST['st_arr'])) {
$st_list = '\'' . implode('\',\'', $_REQUEST['st_arr']) . '\'';
$extra['WHERE'] = " AND s.STUDENT_ID IN ({$st_list})";
//$extra['functions'] = array('GRADE_ID'=>'_grade_id');
if ($_REQUEST['mailing_labels'] == 'Y') {
Widgets('mailing_labels');
}
$RET = GetStuList($extra);
if (count($RET)) {
include 'modules/Students/includes/functions.php';
$st_time = DBGet(DBQuery("SELECT START_TIME, END_TIME FROM SCHOOL_PERIODS WHERE PERIOD_ID = {$period_id} "));
}
/********* for homeroom scheduling*/
$start_time = $st_time[1]['START_TIME'];
$min_start_time = get_min($start_time);
$end_time = $st_time[1]['END_TIME'];
$min_end_time = get_min($end_time);
#$sql = "SELECT COURSE_PERIOD_ID,START_DATE FROM SCHEDULE WHERE STUDENT_ID = ".UserStudentID()." AND (END_DATE IS NULL OR END_DATE>CURRENT_DATE) AND SCHOOL_ID='".UserSchool()."' AND MARKING_PERIOD_ID='".$mp_id."'";
// edited 7.12.2009
$sql = "SELECT COURSE_PERIOD_ID,START_DATE FROM SCHEDULE WHERE STUDENT_ID = " . UserStudentID() . " AND (END_DATE IS NULL OR END_DATE>CURRENT_DATE) AND SCHOOL_ID='" . UserSchool() . "' AND COURSE_PERIOD_ID NOT IN (SELECT COURSE_PERIOD_ID FROM COURSE_PERIODS CP,SCHOOL_PERIODS SP WHERE CP.PERIOD_ID=SP.PERIOD_ID AND SP.IGNORE_SCHEDULING != '') AND MARKING_PERIOD_ID='" . $mp_id . "'";
$xyz = mysql_query($sql);
$time_clash_conflict = false;
while ($coue_p_id = mysql_fetch_array($xyz)) {
$cp_id = $coue_p_id[0];
$st_dt = $coue_p_id[1];
$convdate = con_date($st_dt);
$sel_per_id = DBGet(DBQuery("SELECT COURSE_PERIOD_ID, PERIOD_ID, DAYS, MARKING_PERIOD_ID FROM COURSE_PERIODS WHERE COURSE_PERIOD_ID = {$cp_id}"));
$sel_period_id = $sel_per_id[1]['PERIOD_ID'];
$sel_days = $sel_per_id[1]['DAYS'];
$sel_mp = $sel_per_id[1]['MARKING_PERIOD_ID'];
$sel_cp = $sel_per_id[1]['COURSE_PERIOD_ID'];
$sel_st_time = DBGet(DBQuery("SELECT START_TIME, END_TIME FROM SCHOOL_PERIODS WHERE PERIOD_ID = {$sel_period_id}"));
if ($sel_st_time) {
$sel_start_time = $sel_st_time[1]['START_TIME'];
$min_sel_start_time = get_min($sel_start_time);
$sel_end_time = $sel_st_time[1]['END_TIME'];
$min_sel_end_time = get_min($sel_end_time);
# ---------------------------- Days conflict ------------------------------------ #
$j = 0;
for ($i = 0; $i < $day_st_count; $i++) {
$clip = substr($days, $i, 1);
$day = '06';
} elseif ($temp_day == 7) {
$day = '07';
} elseif ($temp_day == 8) {
$day = '08';
} elseif ($temp_day == 9) {
$day = '09';
} else {
$day = $temp_day;
}
#$select_date = $year.$month.$day;
$select_date = $day . '-' . $month . '-' . $year;
return $select_date;
}
# --------------------------------------------- date Convertion End ------------------------------------------------- #
$final_date = con_date($temp_date);
if ($_REQUEST['dt'] == 1) {
$final_date = $_SESSION['date_attn'];
}
$_REQUEST['dt'] = 0;
if ($_REQUEST['month_date'] && $_REQUEST['day_date'] && $_REQUEST['year_date']) {
if (strlen($_REQUEST['year_date']) == 4) {
while (!VerifyDate($date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . substr($_REQUEST['year_date'], 2, 4))) {
$_REQUEST['day_date']--;
}
} else {
while (!VerifyDate($date = $_REQUEST['day_date'] . '-' . $_REQUEST['month_date'] . '-' . $_REQUEST['year_date'])) {
$_REQUEST['day_date']--;
}
}
unset($_SESSION['date_attn']);
