Ok, Here is the 5 complete files:
the first base.class.php (parent class)
Code: Select all
class base {
var $link;
function db_conn () {
$link = mysql_connect("localhost","root","") or die(mysql_error());
mysql_query("use ev2")or die(mysql_error());
return "<!--db connection opened -->";
}
function db_close () {
mysql_close($link);
}
function return_date($time){
$date = date("m/d/y h:i.s",$time);
return $date;
}
}
2nd file action.class.php
Code: Select all
require_once "base.class.php";
require_once "user.class.php";
class action extends base {
function insert_action($parent_id,$type_id,$create_by,$sent_to,$detail){
$this->db_conn();
$time = time();
mysql_query("INSERT INTO actions
(parent_id,type,create_by,sent_to,date_created,description)
VALUES
('$parent_id','$type_id','$create_by','$sent_to','$time','$detail')") or die(mysql_error());
}
function return_pending_actions($parent_id){
$user = new user();
$uid = $user->return_user();
$this->db_conn();
$result = mysql_query("select * from actions
where sent_to = '$uid'
AND date_completed = 0
AND type = '1'
AND parent_id = '$parent_id'")
or die(mysql_error());
return $result;
}
}
3rd file user.class.php
Code: Select all
require_once "base.class.php";
class user extends base {
private $user;
private $n;
private $result;
private $result_row;
private $pc;
private $fname;
private $lname;
public function auth () {
$user = $this->return_user();
if (!$user) {
die("you arent logged in --- Log in <a href=\"/\">HERE</a>");
}
}
//Return user id from stored cookie.
public function return_user() {
$user = $_COOKIE["user"];
return $user;
}
public function log_in($user){
$this->db_conn();
$result = mysql_query("select * from users where uid = '$user'");
$n = mysql_num_rows($result);
if ($n == 1) {
setcookie("user", $user, time()+3600, "/");
}
}
//returns a user pc
public function return_pc($user){
$this->db_conn();
$result = mysql_query("select pc_id from users where uid = '$user'");
$result_row = mysql_fetch_array($result);
$pc = $result_row[0];
return $pc;
}
public function return_fname($user){
$this->db_conn();
$result = mysql_query("select fname from users where uid = '$user'");
$result_row = mysql_fetch_array($result);
$fname = $result_row[0];
return $fname;
}
public function return_lname($user){
$this->db_conn();
$result = mysql_query("select lname from users where uid = '$user'");
$result_row = mysql_fetch_array($result);
$lname = $result_row[0];
return $lname;
}
public function pop_up ($user,$msg) {
$pc = $this->return_pc($user);
$fp = fsockopen("udp://$pc",12001);
fwrite($fp, "$msg");
fclose($fp);
}
public function return_users() {
$test = $this->db_conn();
$result = mysql_query("select * from users") or die(mysql_error());
return $result;
}
}
4th file ui.class.php
Code: Select all
require_once "base.class.php";
require_once "user.class.php";
require_once "action.class.php";
class ui extends base {
private $display;
function return_ui_openform($action) {
$display = "<table border=\"1\"><tr><td><form action=\"$action\">";
return $display;
}
function return_ui_closeform() {
$display = "</form></td></tr></table>";
return $display;
}
function return_ui_submit($button) {
$display = "<tr><td align=\"right\" colspan=\"2\"><input type=\"submit\" name=\"Submit\" value=\"$button\"></td></tr>";
return $display;
}
function return_ui_user_dropdown($result){
$display = "<select name=\"selected_user\">";
while($result_row = mysql_fetch_array($result, MYSQL_ASSOC)){
$fname = $result_row['fname'];
$lname = $result_row['lname'];
$uid = $result_row['uid'];
$display .= "<option value=\"$uid\">$fname $lname</option>";
}
$display .= "</select>";
return $display;
}
function return_ui_clarification_types_dropdown($result){
$display = "<tr><td>Select Clarification Type:</td><td><select name=\"type_id\">";
while($result_row = mysql_fetch_array($result, MYSQL_ASSOC)){
$type_name = $result_row['type_name'];
$typ_description = $result_row['type_description'];
$type_id = $result_row['type_id'];
$display .= "<option value=\"$type_id\">$type_name</option>";
}
$display .= "</select></td></tr>";
return $display;
}
function return_footer() {
$display = "</td></tr></table>";
return $display;
}
function return_header($title,$fname){
$display = "
<table width=\"80%\" border=\"1\" align=\"center\" cellspacing=\"1\" cellpadding=\"1\" bgcolor=\"#003e69\">
<tr><td width=\"10%\"><font color=\"white\"><center>$fname</center></font></td>
<td><font color=\"white\" size=\"+1\"><center>$title</center></font></td></tr>
<tr>
<td nowrap>" . $this->return_mainmenu() . "</td>
<td bgcolor=\"#ffffff\">";
return $display;
}
function return_mainmenu() {
$this->db_conn();
$display = "";
$result = mysql_query("select * from menu_items");
while($result_row = mysql_fetch_array($result, MYSQL_ASSOC)){
$link = $result_row['link'];
$title = $result_row['title'];
$display .= "<a href=\"$link\"><font color=\"orange\">$title</font></a><br>";
}
return $display;
}
function return_ui_formbox($title,$var) {
$display = "<tr><td>$title</td><td><input name=\"$var\"></td></tr>";
return $display;
}
function return_ui_note($title,$var){
$display = "<tr><td>$title</td><td><textarea name=\"$var\"></textarea></td></tr><br>";
return $display;
}
function return_action_list($action_result) {
$user = new user();
$display = "<table>";
while($result_row = mysql_fetch_array($action_result, MYSQL_ASSOC)){
$action_id = $result_row['action_id'];
$type = $result_row['type'];
$create_by = $result_row['create_by'];
$sent_to = $result_row['sent_to'];
$date_created = $result_row['date_created'];
$date_completed = $result_row['date_completed'];
if($date_completed == 0){ $date_completed = "Pending"; }
$created_by = $user->return_fname($create_by);
$sent_to = $user->return_fname($sent_to);
$date_created = $this->return_date($date_created);
$display .= "<tr><td>$action_id</td><td>$created_by</td>
<td>$sent_to</td><td>$date_created</td><td>$date_completed</td></tr>";
}
$display .= "</table>";
return $display;
}
function return_clarification_list($result) {
$display = "<table border=\"1\">";
while($parent_row = mysql_fetch_array($result, MYSQL_ASSOC)){
$clarification_id = $parent_row['clarification_id'];
$created_by = $parent_row['create_by'];
$date_created = $parent_row['date_created'];
$date_created = $this->return_date($date_created);
$status = $parent_row['status'];
$job_id = $parent_row['job_id'];
$clarification_type = $parent_row['clarification_type'];
$created_by = $user->return_fname($created_by);
$action = new action();
$actions = $action->return_pending_actions($clarification_id);
$display .= "<tr><td>$clarification_id</td><td>$job_id</td>
<td>$created_by</td><td>$clarification_type</td><td>$status</td></tr>";
}
$display .= "</table>";
return $display;
}
}
5th file! this is tha actuil page main.php
Code: Select all
<?
require "inc/user.class.php";
require "inc/ui.class.php";
require "inc/clarification.class.php";
require "inc/action.class.php";
$title = "Start";
$user = new user();
$user->auth();
$uid = $user->return_user();
$fname = $user->return_fname($uid);
$clarification = new clarification();
$open_clars = $clarification->return_open_clarifications();
$action = new action();
$open_actions = $action->return_pending_actions($uid);
$ui = new ui();
$header = $ui->return_header($title,$fname);
$footer = $ui->return_footer();
$action_list = $ui->return_clarification_list($open_clars);
print $header;
print $action_list;
print $footer;
?>