";
$colour_control = 0;
$colour = "B9C48E";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
if ($colour_control == 0)
{
$colour = "B9C48E";
$colour_control = 1;
}
else
{
$colour = "FFFFFF";
$colour_control = 0;
}
if (is_numeric($date_before))
{
if ($row['date'] < $date_before)
{
$return_value .= "
| ".date("d/m/y",$row['date'])." |
".$row['serial']." |
".return_state_name($row['state_id'])." |
".$row['company_name']." |
".$row['contact_name']." |
".$row['contact_number']." |
Explode |
Close |
Send Reminder |
";
}
else
{
;
}
}
else
{
$return_value .= "
| ".date("d/m/y",$row['date'])." |
".$row['serial']." |
".return_state_name($row['state_id'])." |
".$row['company_name']." |
".$row['contact_name']." |
".$row['contact_number']." |
Explode |
Close |
Send Reminder |
";
}
}
$return_value .= "
";
return $return_value;
}
function return_query_name($query_id = '')
{
if ($query_id != '')
{
$dbname = "inactives";
mysql_select_db($dbname);
$sql = "SELECT * FROM query WHERE id = '".$query_id."'";
$result = mysql_query($sql)
or die ("Error in return_query_name()");
if ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
return $row['query_type_name'];
}
}
else
{
return "Error in return_query_name(), no id provided";
}
}
function search_array(&$array, $key)
{
$result = 0;
foreach ($array as $val)
{
if ($val == $key)
{
$result = 1;
break;
}
}
return $result;
}
function return_employee_dropdown($default_user='')
{
//this section finds out which department of employees to display in
//the form
$dbname = "inactives";
mysql_select_db($dbname);
$sql = "SELECT dept_id FROM control_data";
$result = mysql_query($sql);
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$dept_id = $row['dept_id'];
//this section grabs all the member_ids for given $dept_id group
$dbname = "employee_directory";
mysql_select_db($dbname);
$sql = "SELECT member_id FROM employee WHERE dept_id = '".$dept_id."' ORDER BY member_id";
$result = mysql_query($sql);
$member_id_list = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
array_push($member_id_list, $row['member_id']);
}
//this section grabs all the names associated with the member_id list.
$dbname = "emails";
mysql_select_db($dbname);
$sql = "SELECT id, name FROM members";
$result = mysql_query($sql);
$member_names = array();
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
if (search_array($member_id_list, $row['id']) == 1)
array_push($member_names, $row['name']);
}
return return_dropdown(&$member_id_list, &$member_names, 'user', $member_names[array_search($default_user, $member_id_list)]);
}
function return_status_type($val)
{
if ($val == -1)
{
return "Closed";
}
else if ($val == 0)
{
return "Open";
}
else
{
return "Undefined, ERROR";
}
}
function close_request($id)
{
$dbname = "inactives";
mysql_select_db($dbname);
$sql = "UPDATE request_data SET status = '-1' WHERE id = '".$id."'";
$result = mysql_query($sql);
//header('Location: view_requests.php');
}
?>
//close request function: i added header info, it caused trouble, commented it out, now a diff part of my app isfcked.