function _makeNumeric($number, $column) { global $max_min_RET, $chart, $diff, $diff_max, $mins, $THIS_RET, $start_date, $end_date; if ($_REQUEST['timeframe'] == 'month') { $index = $THIS_RET['TIMEFRAME'] * 1 - MonthNWSwitch($_REQUEST['month_start'], 'tonum') * 1 + 1 + 12 * ($_REQUEST['year_end'] - $_REQUEST['year_start']); } elseif ($_REQUEST['timeframe'] == 'SYEAR') { $start = GetSyear($start_date); $end = GetSyear($end_date); $index = 0; for ($i = $start; $i <= $end; $i++) { $index++; if ($i == $THIS_RET['TIMEFRAME']) { break; } } } if (!$number) { $number = 0; } if ($diff == 0) { $chart['chart_data'][0][1] = $number; $chart['chart_data'][$index][1]++; } elseif ($diff < $diff_max) { //$chart['chart_data'][0][((int) $number - (int) $max_min_RET[1]['MIN']+1)] = (int) $number; $chart['chart_data'][$index][(int) $number - (int) $max_min_RET[1]['MIN'] + 1]++; } else { for ($i = 1; $i <= $diff_max; $i++) { if ($number >= $mins[$i] && $number < $mins[$i + 1] || $i == $diff_max) { $chart['chart_data'][$index][$i]++; break; } } } return $number; }
$extra['group'] = array('TITLE', 'TIMEFRAME'); Widgets('all'); $totals_RET = GetStuList($extra); // $sql = "SELECT dr.CATEGORY_".$_REQUEST['category_id']." AS TITLE,COUNT(*) AS COUNT FROM DISCIPLINE_REFERRALS dr,STUDENTS s,STUDENT_ENROLLMENT ssm WHERE ssm.STUDENT_ID=s.STUDENT_ID AND dr.ENTRY_DATE BETWEEN '$start_date' AND '$end_date' AND dr.SCHOOL_ID=ssm.SCHOOL_ID AND dr.SCHOOL_ID='".UserSchool()."' "; // $sql = appendSQL($sql); // $sql .= " GROUP BY CATEGORY_".$_REQUEST['category_id']; // $totals_RET = DBGet(DBQuery($sql),array(),array('TITLE')); $chart['chart_data'][0][0] = ''; $chart['chart_data'][0][] = _('Yes'); $chart['chart_data'][0][] = _('No'); if ($_REQUEST['timeframe'] == 'month') { $start = MonthNWSwitch($_REQUEST['month_start'], 'tonum') * 1; $end = MonthNWSwitch($_REQUEST['month_end'], 'tonum') * 1 + 12 * ($_REQUEST['year_end'] - $_REQUEST['year_start']); } elseif ($_REQUEST['timeframe'] == 'SYEAR') { $start = GetSyear($start_date); $end = GetSyear($end_date); } for ($i = $start; $i <= $end; $i++) { $index++; if ($_REQUEST['timeframe'] == 'month') { $tf = str_pad($i - $start + 1, 2, '0', STR_PAD_LEFT); $chart['chart_data'][$index][0] = ucwords(strtolower(MonthNWSwitch(str_pad($i % 12, 2, '0', STR_PAD_LEFT), 'tochar'))); } elseif ($_REQUEST['timeframe'] == 'SYEAR') { $tf = $i - $start + 1; $chart['chart_data'][$index][0] = $i; } $chart['chart_data'][$index][] = $totals_RET['Y'][$tf][1]['COUNT']; $chart['chart_data'][$index][] = $totals_RET['N'][$tf][1]['COUNT']; } } elseif ($category_RET[1]['DATA_TYPE'] == 'multiple_checkbox') { //$referrals_RET = DBGet(DBQuery("SELECT CATEGORY_".$_REQUEST['category_id']." AS TITLE FROM DISCIPLINE_REFERRALS WHERE ENTRY_DATE BETWEEN '$start_date' AND '$end_date' AND SCHOOL_ID='".UserSchool()."'"));