151 lines
3.4 KiB
PHP
151 lines
3.4 KiB
PHP
<?php
|
|
/** \file include\db_task.php
|
|
* \brief DI webinterface database task functions
|
|
* \author Rob Schalken, Core|Vision
|
|
* \version 1.0
|
|
* \date 17-10-2008
|
|
*
|
|
* This file contains the task database functions. This file is always included.
|
|
*/
|
|
|
|
/**
|
|
* Fetch tasks
|
|
*
|
|
* Inputs:
|
|
* - task_id: Task id
|
|
* - user_id: Task from user
|
|
* - description: Task description
|
|
*
|
|
* Return: Array containing task info
|
|
*/
|
|
function db_fetch_tasks($task_id = "", $user_id = "", $description = "") {
|
|
// Initial return value
|
|
$result = "";
|
|
|
|
// Fetch tasks
|
|
$query = "SELECT * FROM taskmgr";
|
|
|
|
// Specific task
|
|
if (strlen($task_id)) {
|
|
$query .= " WHERE id='" . $task_id . "'";
|
|
}
|
|
|
|
// Specific user
|
|
if (strlen($user_id)) {
|
|
if (!strlen($task_id)) {
|
|
$query .= " WHERE";
|
|
}
|
|
else {
|
|
$query .= " AND";
|
|
}
|
|
$query .= " gebruiker='" . $user_id . "'";
|
|
}
|
|
|
|
// Specific description
|
|
if (strlen($description)) {
|
|
if ((!strlen($task_id)) && (!strlen($user_id))) {
|
|
$query .= " WHERE";
|
|
}
|
|
else {
|
|
$query .= " AND";
|
|
}
|
|
$query .= " omschrijving like '%" . $description . "%'";
|
|
}
|
|
|
|
// Execute query
|
|
$tasks = db_fetch_data($query);
|
|
|
|
// Parse into result
|
|
if (!empty($tasks)) {
|
|
$result = $tasks;
|
|
}
|
|
|
|
return $result;
|
|
}
|
|
|
|
|
|
/**
|
|
* Store new task
|
|
*
|
|
* Inputs:
|
|
* - task_array: Array containing all task info
|
|
*
|
|
* Return: 1 (OK)/ 0(Error)
|
|
*/
|
|
function db_store_task($task_array) {
|
|
// Initial return value
|
|
$result = 0;
|
|
|
|
// Query storing new task
|
|
$query = "INSERT INTO taskmgr (gebruiker, omschrijving, `update`, param) VALUES (";
|
|
$query .= "'" . ($task_array['gebruiker']) . "',";
|
|
$query .= "'" . specialchars($task_array['omschrijving']) . "',";
|
|
$query .= "'" . date('Y-m-d H:i:s') . "',";
|
|
$query .= "'" . addslashes($task_array['param']) . "')";
|
|
|
|
if (db_store_data($query)) {
|
|
// Result OK
|
|
$result = 1;
|
|
}
|
|
|
|
return $result;
|
|
}
|
|
|
|
/**
|
|
* Update exisiting task
|
|
*
|
|
* Inputs:
|
|
* - task_array: Array containing all task info
|
|
*
|
|
* Return: 1 (OK)/ 0(Error)
|
|
*/
|
|
function db_update_task($task_array) {
|
|
// Initial return value
|
|
$result = 0;
|
|
|
|
// Query updating lance
|
|
$query = "UPDATE taskmgr SET ";
|
|
$query .= "gebruiker='" . ($task_array['gebruiker']) . "',";
|
|
$query .= "omschrijving='" . specialchars($task_array['omschrijving']) . "',";
|
|
$query .= "`update`='" . date('Y-m-d H:i:s') . "',";
|
|
$query .= "param='" . addslashes($task_array['param']) . "' ";
|
|
$query .= "WHERE id='" . ($task_array['id']) . "'";
|
|
|
|
if (db_store_data($query)) {
|
|
// Result OK
|
|
$result = 1;
|
|
}
|
|
|
|
return $result;
|
|
}
|
|
|
|
|
|
/**
|
|
* Delete task
|
|
*
|
|
* Inputs:
|
|
* - task_id: task database id
|
|
*
|
|
* Return: 1 (OK)/ 0(Error)
|
|
*/
|
|
function db_delete_task($task_id) {
|
|
// Initial return value
|
|
$result = 0;
|
|
|
|
// Start transaction
|
|
db_start_transaction();
|
|
|
|
// Delete zkl
|
|
$query = "DELETE FROM taskmgr WHERE ID='" . $task_id . "'";
|
|
|
|
db_store_data($query);
|
|
|
|
// Commit transaction
|
|
if (db_commit_transaction()) {
|
|
// Parse result
|
|
$result = 1;
|
|
}
|
|
|
|
return $result;
|
|
}
|
|
?>
|