Beanco have distribution centres in Sunderland, Liverpool and Portsmouth. The company has a fleet of 60 vans that deliver products from each centre to retailers daily. The company wants to track vehicle mileages, service records, vehicle damage and repairs more effectively using a browser based system. The current tracking system uses spreadsheets and paper documents.

Using an appropriate MVC framework (as directed by the tutor) and suitable data storage engine (e.g. MySQL) you are required to build a vehicle management system for the company, which will make it easier to track mileages and service records.

All vehicles are fitted with a transmitter which broadcasts the vehicle ID and current location. Drivers start work at 8.30am and return the vehicle at the end of the day, usually around 6.30pm, signing in and returning the keys to the admin office. Staff log the van, employee ID, mileage and any additional notes.

· As a minimum, the vehicle management system functionality should include:

· Ability to view all vehicles (appropriate filtering, sorting and presentation)

· View specific vehicle location (using broadcast data)

· Ability to add new vehicles (all van details including photograph(s)

· Ability to amend vehicle information

· Ability to remove vehicle from system (mark as off-road, disposed etc.)

· Add service/repair information

· View audit/history of vehicle and record(s)

· Add appropriate notes to record

· View upcoming services – with estimated date

· Ability to search for vehicle using various search criteria

· Ability to run monthly mileage reports and vehicle inventory

· Uses the Bootstrap framework for the user interface

A ZIP file containing scanned paper documents (used by drivers and the admin team) has been made available for your perusal and should be consulted prior to the development of the computer system.

The following components should be submitted:

A user manual (including screenshots of each part of the system & URLs)

URL to your system

Full code listing with comments

Database diagram or equivalent

MVC diagrams for system

SQL export file or equivalent

ZIP file containing all of your code (including all MVC and Framework files)

URL

http://www.frankofamily.info/UniOfSunderland/Level2/Multimedia/Project4/MVC/index.php/login

Access: user: Andrew

pass: Andrew

CSS (design)

I used Bootstrap Framework for design my pages. Bootstrap.min.css file added to my all view.

and

To customize my datatables I added few lines to bootstrap.min.css file:

.wrapper { margin: 0 auto; width: 960px; }

footer { border-top: 1px solid #CCCCCC; float: right; font-size: 12px; margin: 40px 0 0; padding: 10px; width: 81%;}

/*Datatables style*/

#big_table_wrapper {background-color: #fff; }

#big_table_wrapper .dataTables_length {float:left;}

#big_table_wrapper .dataTables_filter {float:right;}

#big_Table_wrapper .ui-toolbar{padding:5px;}

#big_table{width:960px; text-align: center;}

.dataTables_paginate .ui-button { margin-right: -0.1em !important;}

.paging_full_numbers .ui-button { color: #333333 !important; cursor: pointer; margin: 0; padding: 2px 6px;}

.dataTables_info { float: left; width: 50%;}

.dataTables_info { padding-top: 3px;}

.dataTables_paginate { float: right; text-align: right;}

.dataTables_paginate { width: auto;}

.paging_full_numbers { width: 350px !important;}

#big_table_processing > img {padding-left:20px;}

.actions{ display:block; padding:3px; }

.actions a { margin-left:10px; margin-right: 10px; }

.ui-widget-header {

border: 1px solid #000000;

background: #428bc2;

color: #000000;

font-weight: bold;

}

.required

{

color: #FF0000;

font-size: 10px;

}

.error

{

color: #FF0000;

font-size: 10px;

}

Log-in

To use this system user must log-in first.

Source: http://www.iluv2code.com/login-with-codeigniter-php.html

login_view.php (View)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Login Form</title>

.colbox {

margin-left: 0px;

margin-right: 0px;

}

</style>

</head>

<body>

<h1>BEANACO LOGIN</h1>

</div>

<hr/>

<?php

$attributes = array("class" => "form-horizontal", "id" => "loginform", "name" => "loginform");

echo form_open("verifylogin", $attributes);?>

<?php echo validation_errors(); ?>

<legend>Login</legend>

<label for="username" class="control-label">Username:</label>

</div>

</div>

<label for="password" class="control-label">Password:</label>

</div>

</div>

</div>

</fieldset>

</form>

</body>

</html>

login.php (Controller)

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

class Login extends CI_Controller {

function __construct()

{

parent::__construct();

}

function index()

{

$this->load->helper('form');

$this->load->view('login_view');

}

user.php (Model)

<?php

Class User extends CI_Model

{

function login($username, $password)

{

$this -> db -> select('id, username, password');

$this -> db -> from('mvc_users');

$this -> db -> where('username = ' . "'" . $username . "'");

$this -> db -> where('password = ' . "'" . MD5($password) . "'");

$this -> db -> limit(1);

$query = $this -> db -> get();

if($query -> num_rows() == 1)

{

return $query->result();

}

else

{

return false;

}

verifylogin.php (Controller)

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

class VerifyLogin extends CI_Controller {

function __construct()

{

parent::__construct();

$this->load->model('user','',TRUE);

}

function index()

{

//This method will have the credentials validation

$this->load->library('form_validation');

$this->form_validation->set_rules('username', 'Username', 'trim|required|xss_clean');

$this->form_validation->set_rules('password', 'Password', 'trim|required|xss_clean|callback_check_database');

if($this->form_validation->run() == FALSE)

{

//Field validation failed. User redirected to login page

$this->load->view('login_view');

}

else

{

//Go to private area

redirect('home', 'refresh');

}

function check_database($password)

{

//Field validation succeeded. Validate against database

$username = $this->input->post('username');

//query the database

$result = $this->user->login($username, $password);

if($result)

{

$sess_array = array();

foreach($result as $row)

{

$sess_array = array(

'id' => $row->id,

'username' => $row->username

);

$this->session->set_userdata('logged_in', $sess_array);

}

return TRUE;

}

else

{

$this->form_validation->set_message('check_database', 'Invalid username or password');

return false;

}

Validation

All Controllers check the $session_data and in user not logged_in they will redirect to login page.

if($this->session->userdata('logged_in'))

{

$session_data = $this->session->userdata('logged_in');

$data['username'] = $session_data['username'];

………………………

}

else

{

//If no session, redirect to login page

redirect('login', 'refresh');

}

Vans

URL: http://www.frankofamily.info/UniOfSunderland/Level2/Multimedia/Project4/MVC/index.php/home

To display vans I have chosen Datatables frameworks. It is a java framework which is shows element in a table, with search, sorting and pagination functions.

User can add a new van to database or edit exist by pencil buttons.

When user click to van’s picture thumbnail a full size picture open. I have tried to add lightbox function to show large picture but the lightbox frameworks JavaScript was not compatible that JavaScript what I use for Datatable.

I also tried to use picture upload function on my project but it didn’t work on my university server account. It created the files in image folder but their size always was 0 and the owner was “120” not my user name. I spent a lot of hours to solve this problem but I couldn’t. Therefore user have to create a 600px wide jpg picture on van’s reg plate name end a 100px wide thumbnail picture on “thumb_” + reg plate name, and upload them to project assest/images folder.

Source:

http://www.ahmed-samy.com/php-codeigniter-full-featrued-jquery-datatables-part-1/

http://www.datatables.net/download/download

home_view.php (View)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Beanaco - Private Area</title>

</head>

<body>

<h1>BEANACO ADMIN</h1>

</div>

<li><a href="/drivers">Drivers</a></li>

<li><a href="/<?php echo base_url(); ?>/index.php/logs">Logs</a></li>

<li><a href="/<?php echo base_url(); ?>/index.php/services">Services</a></li>

</ul>

</div>

<h2>Welcome <?php echo $username; ?>!</h2>

<a href="/home/logout">Logout</a>

</div>

</body>

</html>

home.php (Controller)

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

session_start(); //we need to call PHP's session object to access it through CI

class Home extends CI_Controller {

function __construct()

{

parent::__construct();

$this->load->library('Datatables');

$this->load->library('table');

$this->load->database();

}

function index()

{

if($this->session->userdata('logged_in'))

{

$session_data = $this->session->userdata('logged_in');

$data['username'] = $session_data['username'];

$this->load->view('home_view', $data);

//set table id in table open tag

$tmpl = array ( 'table_open' => '<table id="big_table" border="1" cellpadding="2" cellspacing="1" class="mytable">' );

$this->table->set_template($tmpl);

$this->table->set_heading('Reg plate','Type','Model', 'Fuel','State','Latitude loc','Longtitude loc','Picture','Actions');

$this->load->view('vans_view');

}

else

{

//If no session, redirect to login page

redirect('login', 'refresh');

}

function logout()

{

$this->session->unset_userdata('logged_in');

session_destroy();

redirect('home', 'refresh');

}

vans_view.php (View)

<html>

<head>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

</ul>

</div>

<hr/>

$(document).ready(function() {

var oTable = $('#big_table').dataTable( {

"bProcessing": true,

"bServerSide": true,

"sAjaxSource": '<?php echo base_url(); ?>index.php/vans/datatable',

"bJQueryUI": true,

"sPaginationType": "full_numbers",

"iDisplayStart ":20,

"bAutoWidth": false, // Disable the auto width calculation

"oLanguage": {

"sProcessing": "<img src='<?php echo base_url(); ?>assets/images/ajax-loader_dark.gif'>"

"fnInitComplete": function() {

//oTable.fnAdjustColumnSizing();

'fnServerData': function(sSource, aoData, fnCallback)

{

$.ajax

({

'dataType': 'json',

'type' : 'POST',

'url' : sSource,

'data' : aoData,

'success' : fnCallback

});

}

} );

</script>

<?php echo $this->table->generate(); ?>

</div>

</body>

<label class="footer-label" >Created by <a href="http://www.frankotrade.info">Istvan Franko</a></label>

</footer>

</html>

vans.php (Controller)

<html>

<head>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

</ul>

</div>

<hr/>

$(document).ready(function() {

var oTable = $('#big_table').dataTable( {

"bProcessing": true,

"bServerSide": true,

"sAjaxSource": '<?php echo base_url(); ?>index.php/vans/datatable',

"bJQueryUI": true,

"sPaginationType": "full_numbers",

"iDisplayStart ":20,

"bAutoWidth": false, // Disable the auto width calculation

"oLanguage": {

"sProcessing": "<img src='<?php echo base_url(); ?>assets/images/ajax-loader_dark.gif'>"

"fnInitComplete": function() {

//oTable.fnAdjustColumnSizing();

'fnServerData': function(sSource, aoData, fnCallback)

{

$.ajax

({

'dataType': 'json',

'type' : 'POST',

'url' : sSource,

'data' : aoData,

'success' : fnCallback

});

}

} );

</script>

<?php echo $this->table->generate(); ?>

</div>

</body>

<label class="footer-label" >Created by <a href="http://www.frankotrade.info">Istvan Franko</a></label>

</footer>

</html>

datatables_help.php (Helper)

In this file have functions for buttons and get pictures.

<?php

//edit vans button function

function get_buttons($id)

{

$ci= & get_instance();

$html='<span class="actions">';

$html .='<a href="'. base_url().'index.php/editvan/updatevan/'.$id.'"><img src="'. base_url().'assets/images/edit.png"/></a>';

$html.='</span>';

return $html;

}

//get pictures function

function get_fullpic($id)

{

$ci= & get_instance();

$html='<span class="actions">';

$html .='<a href="'. base_url().'assets/images/' . $id . '.jpg"><img src="'. base_url().'assets/images/thumb_' . $id . '.jpg"/></a>';

$html.='</span>';

return $html;

}

//edit drivers button function

function get_driverbuttons($id)

{

$ci= & get_instance();

$html='<span class="actions">';

$html .='<a href="'. base_url().'index.php/editdriver/updatedriver/'.$id.'"><img src="'. base_url().'assets/images/edit.png"/></a>';

$html.='</span>';

return $html;

}

//edit logs button function

function get_logbuttons($id)

{

$ci= & get_instance();

$html='<span class="actions">';

$html .='<a href="'. base_url().'index.php/editlog/updatelog/'.$id.'"><img src="'. base_url().'assets/images/edit.png"/></a>';

$html.='</span>';

return $html;

}

//edit services button function

function get_servicebuttons($id)

{

$ci= & get_instance();

$html='<span class="actions">';

$html .='<a href="'. base_url().'index.php/editservice/updateservice/'.$id.'"><img src="'. base_url().'assets/images/edit.png"/></a>';

$html.='</span>';

return $html;

}

//callback function

function custom_notes($val)

{

$ci= & get_instance();

$str = substr($val, 0, 20);

//$str = gettype($val) . " " . strlen($val);

return $str;

}

Add van

vAddVan_view.php (View)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Beanaco - Private Area</title>

</head>

<body>

<hr/>

<?php // Change the css classes to suit your needs

$attributes = array("class" => "form-horizontal", "id" => "addvan", "name" => "Add van form");

echo form_open('addvan', $attributes); ?>

<label for="reg_plate" class="control-label">Reg plate:<span class="required">*</span></label>

<?php echo form_error('reg_plate'); ?>

</div>

</div>

<?php echo form_error('type'); ?>

</div>

</div>

<label for="model" class="control-label">Model <span class="required">*</span></label>

<?php echo form_error('model'); ?>

</div>

</div>

<?php echo form_error('fuel'); ?>

</div>

</div>

<label for="state" class="control-label">State <span class="required">*</span></label>

<?php echo form_error('state'); ?>

</div>

<?php // Change the values in this array to populate your dropdown as required ?>

<?php $options = array(

'On Road' => 'On Road',

'Off Road' => 'Off Road',

'Sold' => 'Sold'

); ?>

<?php echo form_dropdown('state', $options, set_value('state'))?>

</div>

<label for="location_lati" class="control-label">Location lati <span class="required">*</span></label>

<?php echo form_error('location_lati'); ?>

</div>

</div>

<label for="location_long" class="control-label">Location long <span class="required">*</span></label>

<?php echo form_error('location_long'); ?>

</div>

</div>

<?php //echo form_submit( 'submit', 'Submit'); ?>

</div>

</fieldset>

</form>

</body>

</html>

addvan.php (Controller)

<?php

class Addvan extends CI_Controller {

function __construct()

{

parent::__construct();

$this->load->library('form_validation');

$this->load->database();

$this->load->helper('form');

$this->load->helper('url');

$this->load->model('maddvan');

}

function index()

{

if($this->session->userdata('logged_in'))

{

$session_data = $this->session->userdata('logged_in');

$data['username'] = $session_data['username'];

$this->load->view('home_view', $data);

$this->form_validation->set_rules('reg_plate', 'Reg plate', 'required|max_length[10]');

$this->form_validation->set_rules('type', 'Type', 'required|max_length[100]');

$this->form_validation->set_rules('model', 'Model', 'required|max_length[100]');

$this->form_validation->set_rules('fuel', 'Fuel', 'required|max_length[10]');

//$this->form_validation->set_rules('mileage', 'Mileage', 'required');

$this->form_validation->set_rules('state', 'State', 'required|max_length[50]');

$this->form_validation->set_rules('location_lati', 'Location lati', 'required|max_length[50]');

$this->form_validation->set_rules('location_long', 'Location long', 'required|max_length[50]');

$this->form_validation->set_error_delimiters('<br /><span class="error">', '</span>');

if ($this->form_validation->run() == FALSE) // validation hasn't been passed

{

$this->load->view('vAddVan_view');

}

else // passed validation proceed to post success logic

{

// build array for the model

$form_data = array(

'reg_plate' => set_value('reg_plate'),

'type' => set_value('type'),

'model' => set_value('model'),

'fuel' => set_value('fuel'),

//'mileage' => set_value('mileage'),

'state' => set_value('state'),

'location_lati' => set_value('location_lati'),

'location_long' => set_value('location_long'),

);

// run insert model to write data to db

if ($this->maddvan->SaveForm($form_data) == TRUE) // the information has therefore been successfully saved in the db

{

redirect('home'); // or whatever logic needs to occur

}

else

{

echo 'An error occurred saving your information. Please try again later';

// Or whatever error handling is necessary

}

else

{

//If no session, redirect to login page

redirect('login', 'refresh');

}

function success()

{

echo 'this form has been successfully submitted with all validation being passed. All messages or logic here. Please note

sessions have not been used and would need to be added in to suit your app';

}

maddvan.php (Model)

<?php

class maddvan extends CI_Model {

function __construct()

{

parent::__construct();

}

// --------------------------------------------------------------------

/**

* function SaveForm()

* insert form data

* @param $form_data - array

* @return Bool - TRUE or FALSE

function SaveForm($form_data)

{

$this->db->insert('mvc_vans', $form_data);

if ($this->db->affected_rows() == '1')

{

return TRUE;

}

return FALSE;

}

Edit van

vEditVan_view.php (View)

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Beanaco - Private Area</title>

</head>

<body>

<h1>BEANACO ADMIN</h1>

</div>

<li class="active"><a href="/<?php echo base_url(); ?>/index.php/home">Vans</a></li>

<li><a href="/<?php echo base_url(); ?>/index.php/drivers">Drivers</a></li>

<li><a href="/<?php echo base_url(); ?>/index.php/logs">Logs</a></li>

<li><a href="/<?php echo base_url(); ?>/index.php/services">Services</a></li>

</ul>

</div>

<h2>Welcome <?php echo $username; ?>!</h2>

<a href="/home/logout">Logout</a>

</div>

<hr/>

<?php foreach($results as $row) { ?>

<?php echo form_open_multipart('editvan'); ?>

<input type="hidden" name="vanID" value="<?php echo $row->vanID; ?>">

<label for="reg_plate" class="control-label">Reg plate:<span class="required">*</span></label>

<?php echo form_error('reg_plate'); ?>

</div>

<input class="form-control" size="20" id="reg_plate" type="text" name="reg_plate" maxlength="10" value="<?php echo $row->reg_plate; ?>" />

</div>

<?php echo form_error('type'); ?>

</div>

</div>

<label for="model" class="control-label">Model <span class="required">*</span></label>

<?php echo form_error('model'); ?>

</div>

<input class="form-control" size="20" id="model" type="text" name="model" maxlength="100" value="<?php echo $row->model; ?>" />

</div>

<?php echo form_error('fuel'); ?>

</div>

</div>

<!--

<label for="mileage" class="control-label">Mileage <span class="required">*</span></label>

<?php echo form_error('mileage'); ?>

</div>

<input class="form-control" id="mileage" type="text" name="mileage" value="<?php echo $row->mileage; ?>" />

</div>

</div>-->

<label for="state" class="control-label">State <span class="required">*</span></label>

<?php echo form_error('state'); ?>

</div>

<?php // Change the values in this array to populate your dropdown as required ?>

<?php $options = array(

'On Road' => 'On Road',

'Off Road' => 'Off Road',

'Sold' => 'Sold'

);

$selected = $row ->state;

<?php echo form_dropdown('state', $options, $selected)?>

</div>

<label for="location_lati" class="control-label">Location lati <span class="required">*</span></label>

<?php echo form_error('location_lati'); ?>

</div>

<input class="form-control" id="location_lati" type="text" name="location_lati" maxlength="50" value="<?php echo $row->location_lati; ?>" />

</div>

<label for="location_long" class="control-label">Location long <span class="required">*</span></label>

<?php echo form_error('location_long'); ?>

</div>

<input class="form-control" id="location_long" type="text" name="location_long" maxlength="50" value="<?php echo $row->location_long; ?>" />

</div>

<?php //echo form_submit( 'submit', 'Submit'); ?>

</div>

</fieldset>

</form>

<?php } ?>

</body>

</html>

editvan.php (Controller)

<?php

class Editvan extends CI_Controller {

function __construct()

{

parent::__construct();

$this->load->library('form_validation');

$this->load->database();

$this->load->helper('form');

$this->load->helper('url');

$this->load->model('meditvan');