CS5281 AJAX Project

Computer Inventory Report System

Gilbert Ng Chi Lung

Gilbert's Network

Walkthrough

What is CIRS?
CIRS demo
Technologies Cooperated
Further improvement

What Is CIRS?

CIRS is a Computer Inventory Report System with an automatically generated database.
Front end cooperate with several AJAX feature
Back end using MySQL and PHP
Help Users to manage the computer inventory database
Help Users to locate the computers.

What Is CIRS? (Cont')

When user login to the computer, login script will generate an CSV format data
system will send the computer data to certain location
CIRS will import the computer's data automatically and input to MySQL database
Users can navigate, update, delete and input, sorting the record.
Users can locate the computer location

Go to demo >>

Technologies Cooperated

AJAX PHP Framework - XAJAX
- XAJAX is an open source PHP class library
- as a AJAX Framework and simplifying the communication between client/javascript and server
Kixtart
- a free-format scripting language
- use it on user login and administration
- it is a CareWare - is a variant on shareware and freeware. Also known as 'charityware', 'donationware'
- record the computer information on a separate CSV file
- More information on Kixtartplease go to http://www.kixtart.org

Technologies Cooperated (Cont')

MySQL
AJAX
- PHP
- JavaScript
- XHTML + CSS

Technologies Cooperated (Cont'2)

Code Snippets

AJAX call - an asynchronous HTTP request by user and call a registered xajax function

<!-- Begin ajax_block1 -->
<div id="ajax_block1"><h2>Inventory Display</h2>
<div id="aj_menu">
<b>Menu</b>
<a href="#"
onclick="xajax_displayDB('comp_others','computer_name','ASC');
document.getElementById('ajax_map').style.height='500px';
return false;">General Info</a>
</div><!-- Eng ajax_block1 -->

Technologies Cooperated (Cont'3)

Code Snippets

PHP Processing - variables passed for query and returned result will then inputed into the XAJAX for processing

function displayDB($table,$sort_key,$order)
{
//Display Database
$id_data=showDB($table,$sort_key,$order);

//Display Input filed selected by $table
$serial_number="";
$id_input=createInputField($table,$serial_number);

//Operation on ajax
$objResponse = new xajaxResponse();
$objResponse->addAssign("ajax_data","innerHTML",$id_data);
$objResponse->addAssign("ajax_input","innerHTML",$id_input);
return $objResponse->getXML();
}

Technologies Cooperated (Cont'4)

Code Snippets

Kixtart - capture computer data and generate an CSV file during user login

Function ExportInventoryToCSV()
	Dim $Item,$OpenFile,$OUTPUT,$CloseFile,$Proc,
	If Exist($CSVLog) Del $CSVLog EndIf
		$Handle = FreeFileHandle()
		$OpenFile = Open($Handle, $CSVLog,5)
		$OUTPUT='TIME,'+@Time+@CRLF +'DATE,'+@Date+@CRLF+'LOGON ID,'
		+@USERID+@CRLF +'FULL NAME,'+@FULLNAME+@CRLF……
		................................
		+@CRLF+'MANUFACTURER,'+$MyBiosInfo[4]+@CRLF
	ENDIF
	................................
$OUTPUT = WriteLine($Handle,$OUTPUT + @CRLF)
$CloseFile = Close($Handle)
EndFunction

AJAX Project Presentation

Computer Inventory Report System • 2006/04/24