admin controller

admin.php

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

class Admin extends Application{
	
	private static $data = array();
	
	public function __construct(){
				
		parent::__construct();
		
		/* restrict access to all but admin */
		$this->ag_auth->restrict('admin');
		
		/* Disable Cashcing */
		$this->output->nocache();
		
		/* Load helpers */
		$this->load->helper(array('url', 'form', 'registration', 'menu', 'language' , 'notification'));
        
		/* Load libraries */
        $this->load->library('Repositories/Registration_Repository', '', 'reg');
		$this->load->library('grocery_CRUD');
		
		/* setup default view data */
		$this->data['title'] = 'Admin Dashboard';
		$this->data['MenuItems'] = get_menu_items('admin');
	}
	
	public function index(){
		
		// Main function called when this controller is loaded		
		if(logged_in()){
				
		//* load views */
		$this->load->view('templates/header', $this->data);		
		$this->load->view('templates/fancybox_dependencies');
		$this->load->view('admin/dashboard');
		$this->load->view('templates/footer');
			
		}
		else{
			$this->login();
		}
	}
			
	// grids for the dashboard
	function waitlistGrid(){
			
		$crud = new grocery_CRUD();
			
		$crud->set_table('WaitlistForm')
			->columns('FirstName', 'LastName')
			->display_as('FirstName', 'First')
			->display_as('LastName','Last')
			->unset_operations();
		
		$crud->where('IsWaitlisted', 1);	
		
    	$output = $crud->render();
		$this->load->view('templates/grid',$output);
	}

	function preEnrolledGrid(){
		
		$crud = new grocery_CRUD();
		
		$crud->set_table('WaitlistForm')
			->columns('FirstName', 'LastName')
			->display_as('FirstName', 'First')
			->display_as('LastName','Last')
			->unset_operations();
		
		$crud->where('IsPreEnrolled', 1);
		
    	$output = $crud->render();
		$this->load->view('templates/grid',$output);
	}
	
	function volunteerLogGrid(){
			
		$crud = new grocery_CRUD();
		
		$crud->set_table('VolunteerLogEntry')
			->set_relation('UserID', 'users', 'username')
			->columns('UserID', 'Hours', 'Description', 'VolunteeredDTTM', 'UDTTM')
			->display_as('UDTTM', 'Date Submitted')
			->display_as('VolunteeredDTTM', 'Activity Date')
			->display_as('UserID', 'Username')
			->unset_operations();
		
    	$output = $crud->render();
		$this->load->view('templates/grid', $output);
	}
	
	# The grocery crud for the current admin's notifications. This grid is dedicated
	# for viewing. Adds, Edits, and Deletes should not be allowed.
	function notificationGrid() {		 
		$crud = new grocery_CRUD();
		$crud->set_table('UserNotifications')
			 ->set_relation('NotificationID', 'Notifications', 'Description')
			 ->columns('UrlParam')
			 ->display_as('UrlParam', 'Description')
			 ->callback_column('UrlParam', array($this, 'get_notification_URL'))
			 ->unset_operations();
			 
		$crud->where('UserID', user_id());

        $output = $crud->render();

		$this->load->view('templates/grid', $output);
	}
	
	# Callback Column for notifications.
	# We want to construct a link so that the user can click it to resolve the notification.
	function get_notification_URL($value, $row) {
		$notification = Notifications::find_by_notificationid($row->NotificationID);
		$NotificationAttr = $notification->attributes();
		return '<a href="' . base_url($NotificationAttr['url'] . $row->UrlParam) . '" target="_blank">' . $NotificationAttr['description'] . $row->AdditionalInfo . '</a>';
	}
	
	function prospectGrid() {

		$crud = new grocery_CRUD();
		$crud->set_table('ProspectInterview')
			->columns('ParentNames', 'ChildrenNamesAges', 'PhoneNumber' ,'Email')
			->unset_operations();
			 
        $output = $crud->render();
		
		$this->load->view('templates/grid', $output);
	}
	// end grids for dashboard
	
	// this function is for creating a new account for parents
	function addParentUserAccount(){
		$this->form_validation->set_rules('first', 'First Name', 'required|min_length[1]');
        $this->form_validation->set_rules('last', 'Last Name', 'required|min_length[1]');
        //$this->form_validation->set_rules('middle', 'Middle Name', '');
        $this->form_validation->set_rules('email', 'Email Address', 'required|min_length[3]|valid_email|callback_field_exists');

		if($this->form_validation->run() == FALSE){
			$this->load->view('templates/header', $this->data);	
			$this->load->view('admin/register/add_parent_user');
			$this->load->view('templates/footer');
		}
		else{
			$firstName = set_value('first');
            //$middleName = set_value('middle');
            $lastName = set_value('last');
			$username = $firstName . '.' . $lastName;
            
			// make usernames all lower case
			$username = strtolower($username);
			
            //check db to make sure this is a unique name
            // if not add a number and try again
            if (!$this->reg->isUsernameUnique($username)){
                $isUnique = FALSE; 
                $i = 1;
                while (!$isUnique) {         
                    $i = $i + 1;
                    $isUnique = $this->reg->isUsernameUnique($username . '.'. $i);
                }
                $username = $username . '.'. $i;
            }
            
            $plainTextPassword = generatePassword();
            
			// encrypt the password
			$password = $this->ag_auth->salt($plainTextPassword);
			$email = set_value('email');
			$email = strtolower($email);
			
			
			if($this->ag_auth->register($username, $password, $email) === TRUE){
				$this->sendEmail(sendNewUserAccountCreationEmail($firstName, $lastName, $email, $username, $plainTextPassword));
                
                $this->data['firstName'] = $firstName;
                $this->data['lastName'] = $lastName;
                $this->data['email'] = $email;
                $this->data['username'] = $username;
                $this->data['plainTextPassword'] = $plainTextPassword;
                
                $this->load->view('templates/header', $this->data);  
                $this->load->view('admin/register/success' , $this->data);
                $this->load->view('templates/footer');
				
			} 
			else{
				echo "Error";
			}
            
			$newUserAttr = User::find_by_username($username)->attributes();
            $userId = $newUserAttr['id'];
                  
            $this->createParent($userId, $firstName, $lastName, $email);
			setNotification('waitlistAChild', $userId);
             //$this->output->enable_profiler(TRUE);//Turns on CI debugging
		} 
	}

	# This is the Interview/Observation form that the administrator
	# fills out for the parent.
	function interviewObservationForm(){

		$viewData['classes'] = Classroom::find_all_by_enabled('1');

		# Set up validation for admissionsPage1.php
		$this->validateInterviewObservationForm();

		// if user is posting back answers, then save the form
		if ($this->form_validation->run() == TRUE) {
			// get answers from waitlist questionaire
			$this->storeInterviewObservationForm();

			// back to the admin dashboard
			redirect('admin');
		} else {
			// display the interview observation form
			$this->load->view('templates/header', $this->data);  
        	$this->load->view('admin/register/interview_observation', $viewData);
        	$this->load->view('templates/footer');
		}
	}

	# Saves the interview and observation form that the admin fills out.
	function storeInterviewObservationForm(){
		$ioform = new Interview_observation_form();

		$ioform->parentnames =  set_value('pNames');
		$ioform->childrennamesages = set_value('namesAndAges');
		$ioform->firstcontacteddttm = date('Y-m-d H:i:s', strtotime(set_value('contactDateTime')));
		$ioform->phonenumber = set_value('phoneNumber');
		$ioform->visitdttm = date('Y-m-d H:i:s', strtotime(set_value('visitDateTime')));
		$ioform->email = set_value('email');
		$ioform->websearchref = set_value('webSearch');
		$ioform->cmsfamilyref = set_value('cmsFamily');
		$ioform->friendsref = set_value('friends');
		$ioform->adref = set_value('adIn');
		$ioform->adrefnote = set_value('adInRefNote');
		$ioform->otherref = set_value('otherRef');
		$ioform->otherrefnote = set_value('otherRefNote');
		$ioform->levelofinterest = set_value('interestLevel');
		$ioform->levelofunderstanding = set_value('understandingLevel');
		$ioform->willingnesstolearn = set_value('willingnessLevel');
		
		// combine city and state
		$city = set_value('movingCity');
		$state = set_value('movingState');
		
		if($city != null && $state != null)
			$citystate = $city . ', ' . $state;
		else if($city != null)
			$citystate = $city;
		else if($state != null)
			$citystate = $state;
		else {
			$citystate = "";
		}
		
		$ioform->newcitystate = $citystate;
		$ioform->newschool = set_value('movingSchool');
		$ioform->islearningindependently = set_value('independent');
		$ioform->islearningatownpace = set_value('ownPace');
		$ioform->ishandsonlearner = set_value('handsOn');
		$ioform->ismixedages = set_value('mixedAges');
		$ioform->montessoriimpressions = set_value('montessoriImpressions');
		$ioform->interviewimpressions = set_value('interviewImpressions');
		$ioform->observationdttm = date('Y-m-d H:i:s', strtotime(set_value('observationDateTime')));
		$ioform->classid = set_value('classroom') == 0 ? NULL : set_value('classroom');
		$ioform->attendedobservation = set_value('attendedRadio');
		$ioform->ontimetoobservation = set_value('onTimeRadio');
		$ioform->interviewdttm = date('Y-m-d H:i:s', strtotime(set_value('interviewDateTime')));
		$ioform->appreceiveddttm = date('Y-m-d H:i:s', strtotime(set_value('appReceivedDateTime')));
		$ioform->feereceiveddttm = date('Y-m-d H:i:s', strtotime(set_value('feeReceivedDateTime')));

		$ioform->save();
	}

	# Sets the validation rules for the InterviewObservationForm
	function validateInterviewObservationForm(){
		$this->form_validation->set_rules('pNames', 'Parents', 'required');
		$this->form_validation->set_rules('namesAndAges', 'Children', 'required');
		$this->form_validation->set_rules('contactDateTime', 'Contact DateTime', 'valid_date');
		$this->form_validation->set_rules('phoneNumber', 'Phone number', 'min_length[12]');
		$this->form_validation->set_rules('visitDateTime', 'Visit DateTime', 'valid_date');
		$this->form_validation->set_rules('email', 'Email', 'valid_email');
		$this->form_validation->set_rules('webSearch', 'Websearch Reference', 'exact_length[1]|is_natural');
		$this->form_validation->set_rules('cmsFamily', 'CMS Family Reference', 'exact_length[1]|is_natural');
		$this->form_validation->set_rules('friends', 'Friend Reference', 'exact_length[1]|is_natural');
		$this->form_validation->set_rules('adIn', 'Ad Reference', 'exact_length[1]|is_natural');
		$this->form_validation->set_rules('adInRefNote', 'Ad Reference Description', '');
		$this->form_validation->set_rules('otherRef', 'Other Reference', 'exact_length[1]|is_natural');
		$this->form_validation->set_rules('otherRefNote', 'Other Reference Description', '');
		$this->form_validation->set_rules('interestLevel', 'Level of interest', '');
		$this->form_validation->set_rules('understandingLevel', 'Level of understanding', '');
		$this->form_validation->set_rules('willingnessLevel', 'Willingness to learn', '');
		$this->form_validation->set_rules('movingCity', 'New City', 'alpha');
		$this->form_validation->set_rules('movingState', 'New State', 'alpha');
		$this->form_validation->set_rules('movingSchool', 'New School', '');
		$this->form_validation->set_rules('independent', 'Independent learner', 'exact_length[1]');
		$this->form_validation->set_rules('ownPace', 'Learns at own pace', 'exact_length[1]');
		$this->form_validation->set_rules('handsOn', 'Hands-on learner', 'exact_length[1]');
		$this->form_validation->set_rules('mixedAges', 'Mixed ages', 'exact_length[1]');
		$this->form_validation->set_rules('montessoriImpressions', 'Montessori impressions', '');
		$this->form_validation->set_rules('interviewImpressions', 'Interview impressions', '');
		$this->form_validation->set_rules('observationDateTime', 'Observation DateTime', 'valid_date');
		$this->form_validation->set_rules('classroom', 'Classroom', 'is_natural_no_zero');
		$this->form_validation->set_rules('attendedRadio', 'Attended observation', 'exact_length[1]');
		$this->form_validation->set_rules('onTimeRadio', 'On time to observation', 'exact_length[1]');
		$this->form_validation->set_rules('interviewDateTime', 'Interview DateTime', 'valid_date');
		$this->form_validation->set_rules('appReceivedDateTime', 'Application received DateTime', 'valid_date');
		$this->form_validation->set_rules('feeReceivedDateTime', 'Application fee received DateTime', 'valid_date');
	}

    function createParent($userId, $fName, $lName, $email){
        $parent = new Parental();
        $parent->userid = $userId;
        $parent->firstname = $fName;
        //$parent->middlename = $mName;
        $parent->lastname = $lName;
        $parent->email = $email;
        $parent->uddtm = date('Y-m-d H:i:s', time());
        $parent->save();
    }
    
	/*
	 * This function takes data and takes on proper header information so emails dont come from corvall5
	 * $to - the email destination
	 * $subject - the email subject
	 * $body - the actuall body of the email
	 * if you want to change who emails are from in the system this is the function to change
	 */
	function sendEmail($data){
	
	$to = $data['to'];
	$subject = $data['subject'];
	$body = $data['body'];
		
	$headers   = array();
	$headers[] = "MIME-Version: 1.0";
	$headers[] = "Content-type: text/plain; charset=iso-8859-1";
	$headers[] = "From: From: \"XXXXXXXXX\" <XXXXX@XXXXXX.org>";
	$headers[] = "Reply-To: \"XXXXX XXXXX\" <XXXXX@XXXXXX.org>";
	$headers[] = "Subject: {$subject}";
	$headers[] = "X-Mailer: PHP/".phpversion();
	
	mail($to, $subject, $body, implode("\r\n", $headers));
			
	}

}

/* End of file: admin.php */
/* Location: application/controllers/admin/ */