debug = true; $result = common_project_tasks::get_details($id); /* $get_workflow = " SELECT * FROM project_tasks WHERE id = '$id' "; $result = $database->getRow($get_workflow);*/ $description = $result['description']; $project_workflow_id = $result['project_workflow_id']; $departments = $result['departments']; $department_sql = ""; foreach($departments AS $key => $department) $department_sql .= "'".$key."',"; if(!empty($department_sql)) { $department_sql = "(".substr($department_sql,0,strlen($department_sql)-1).")"; $get_users = " SELECT user_id, CONCAT(user_tab.first_name,' ',user_tab.last_name) AS name FROM departments_users,".DB_CLIENT_ACCOUNTS."users AS user_tab WHERE departments_users.department_id IN $department_sql AND departments_users.user_id = user_tab.id AND user_tab.group_id NOT IN (31,41,40) AND user_tab.status=1 ORDER BY name ASC "; $users = $database->getAll($get_users); } $get_workflow = " SELECT * FROM project_workflow WHERE id = '$project_workflow_id' "; $result = $database->getRow($get_workflow); $workflow_id = $result['workflow_id']; $table = $result['table']; $foreign_id = $result['foreign_id']; $workflow = common_workflow::get_details($workflow_id); ?>
"Allocate" Task



For # to