function school_count_since_date($time)
{
$S = new Schools();
//Best way to connect to database?
$cursor = $this->dbstudent->emails->find();
$pattern = "/(.*)@(.*)/";
$schools = array();
$school_names = array();
foreach ($cursor as $doc) {
$success = preg_match($pattern, $doc["email"], $match);
if ($success && $doc["_id"]->getTimestamp() > $time) {
if (array_key_exists($match[2], $schools)) {
$schools[$match[2]] += 1;
} else {
$schools[$match[2]] = 1;
}
}
}
foreach ($schools as $key => $id) {
if ($S->hasSchoolOf($key)) {
if (array_key_exists($S->nameOf($key), $school_names)) {
$school_names[$S->nameOf($key)] += $id;
} else {
$school_names[$S->nameOf($key)] = $id;
}
} else {
if (array_key_exists($key, $school_names)) {
$school_names[$key] += $id;
} else {
$school_names[$key] = $id;
}
}
}
return $school_names;
}
function school_count_since_date($time)
{
$S = new Schools();
//Best way to connect to database?
$conn = MongoSingleton::getMongoCon();
$db = $conn->sublite;
$emails = $db->emails;
$cursor = $emails->find();
$pattern = "/(.*)@(.*)/";
$schools = array();
$school_names = array();
foreach ($cursor as $doc) {
$success = preg_match($pattern, $doc["email"], $match);
if ($success && $doc["_id"]->getTimestamp() > $time) {
$schools[$match[2]] += 1;
}
}
foreach ($schools as $key => $id) {
if ($S->hasSchoolOf($key)) {
$school_names[$S->nameOf($key)] += $id;
} else {
$school_names[$key] += $id;
}
}
return $school_names;
}
public function getSchoolSettings()
{
$school = Schools::find($this->getSchoolId());
$schedule = SchoolSchedule::where('school_id', '=', $this->getschoolId())->where('school_session_id', '=', $this->getSchoolSessionId())->get();
$sessions = SchoolSession::where('school_id', '=', $this->getschoolId())->get();
$current_session = SchoolSession::where('school_id', '=', $this->getschoolId())->where('current_session', '=', 1)->get()->first();
return View::make('admin.school-settings')->with('schedules', $schedule)->with('sessions', $sessions)->with('school', $school)->with('current_session', $current_session);
}
/**
* Контроллер для работы выбора школ при редактировании персоны
*/
public function actionSchoolr($id)
{
$result = array();
$text = "";
$model = Schools::model()->find("idSchool = {$id}");
if (!empty($model)) {
$text = $model->SchoolName;
}
$result = array("id" => $id, 'text' => $text);
echo CJSON::encode($result);
}
public static function DropDown($KOATUUCode = '0000000000', $MaskLen = 4)
{
$res = array();
//debug('$MaskLen = '.$MaskLen);
$KOATUUCode = substr($KOATUUCode, 0, $MaskLen);
//debug($KOATUUCode);
foreach (Schools::model()->findAll("KOATUUCode like :KOATUUCode ORDER BY SchoolName", array(":KOATUUCode" => $KOATUUCode . "%")) as $record) {
$res[$record->idSchool] = $record->SchoolName;
}
return $res;
}
public function postCreate()
{
$validator = Validator::make(Input::all(), array('first_name' => 'required|max:30', 'last_name' => 'required|max:30', 'city' => 'required|max:30', 'state' => 'required|max:30', 'sex' => 'required', 'school_registration_code' => 'required|max:80', 'user_registration_code' => 'required|max:80', 'email' => 'max:60|email|unique:users', 'password' => 'required|min:6', 'password_again' => 'required|same:password'));
if ($validator->fails()) {
return Redirect::route('user-account-create')->withErrors($validator)->withInput();
} else {
$school_registration_code = Input::get('school_registration_code');
$user_registration_code = Input::get('user_registration_code');
$school = Schools::where('registration_code', '=', $school_registration_code)->where('code_for_students', '=', $user_registration_code)->where('active', '=', 1)->get();
if (!$school->count()) {
return Redirect::route('admin-account-create')->with('global', 'Please input Correct School code and Admin Code.');
}
$first_name = Input::get('first_name');
$last_name = Input::get('last_name');
$email = Input::get('email');
$sex = Input::get('sex');
$city = Input::get('city');
$state = Input::get('state');
$password = Input::get('password');
// Unique Username
$username = substr(str_shuffle(str_repeat('0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', mt_rand(1, 10))), 1, 10);
//Activation Code
$code = str_random(60);
$now = date("Y-m-d H-i-s");
$groups = Groups::find(1);
$User = User::create(array('first_name' => $first_name, 'last_name' => $last_name, 'email' => $email, 'email_updated_at' => $now, 'password' => Hash::make($password), 'password_updated_at' => $now, 'username' => $username, 'sex' => $sex, 'city' => $city, 'state' => $state, 'address_updated_at' => $now, 'code' => $code, 'active' => 0, 'mobile_verified' => 0, 'permissions' => $groups->id, 'school_id' => $school->first()->id));
if ($User) {
//send email
Mail::send('emails.auth.activate.activate-user', array('link' => URL::route('user-account-activate', $code), 'username' => $username), function ($message) use($User) {
$message->to($User->email, $User->voter_id)->subject('Activate Your Account');
});
return Redirect::route('user-sign-in')->with('global', 'You have been Registered. You can activate Now.');
} else {
return Redirect::route('user-sign-in')->with('global', 'You have not Been Registered. Try Again Later Some time.');
}
}
}
/**
* Returns the data model based on the primary key given in the GET variable.
* If the data model is not found, an HTTP exception will be raised.
* @param integer the ID of the model to be loaded
*/
public function loadModel($id)
{
$model = Schools::model()->findByPk($id);
if ($model === null) {
throw new CHttpException(404, 'The requested page does not exist.');
}
return $model;
}
/**
*
*/
public function schools()
{
$schools = new Schools();
return $schools->get_by_school_approval_level($this->id);
}
/**
* Метод асинхронно повертає список НЗ, що закінчили персони
*/
public function actionSchools()
{
$models = Schools::model()->findAll('1 ORDER BY SchoolName ASC');
$result = array();
foreach ($models as $model) {
/* @var $model Schools */
$result[] = array('text' => str_replace('"', "'", $model->SchoolName), 'id' => $model->idSchool);
}
echo CJSON::encode($result);
}
public function postValidateSchool()
{
$registration_code = Input::get('registration_code');
$group_id = Input::get('group_id');
try {
// Find the group using the group id
$group = Sentry::findGroupById($group_id);
// Get the group permissions
$groupPermissions = $group->getPermissions();
} catch (Cartalyst\Sentry\Groups\GroupNotFoundException $e) {
echo 'Group does not exist.';
}
if ($group->count() > 0) {
if ($group->id == 3) {
$code_for_teachers = Input::get('code_for_teachers');
$school = Schools::where('registration_code', '=', $registration_code)->where('code_for_teachers', '=', $code_for_teachers)->get()->first();
} elseif ($group_id == 2) {
$code_for_students = Input::get('code_for_students');
$school = Schools::where('registration_code', '=', $registration_code)->where('code_for_students', '=', $code_for_students)->get()->first();
} elseif ($group_id == 1) {
$code_for_admin = Input::get('code_for_admin');
$school = Schools::where('registration_code', '=', $registration_code)->where('code_for_admin', '=', $code_for_admin)->get()->first();
}
if ($school->count() > 0) {
$user = Sentry::getUser();
$user->school_id = $school->id;
$user->save();
$users_login_info = new UsersLoginInfo();
$users_login_info->user_id = $user->id;
$users_login_info->school_id = $school->id;
$users_login_info->save();
$response = array('status' => 'success', 'result' => array('school' => $school));
return Response::json($response);
} else {
$response = array('status' => 'failed', 'result' => array('school' => null));
return Response::json($response);
}
}
}
/**
*
*/
public function schools()
{
$schools = new Schools();
return $schools->get_by_school_type($this->id);
}
