Simple Machines Community Forum

Link to the mod (https://custom.simplemachines.org/index.php?mod=4307)


(https://img.shields.io/badge/License-MIT-248049) (https://img.shields.io/badge/Hooks%20Only-Yes-6041a3) (https://img.shields.io/badge/SMF-2.1-3f73a0)

Tasks Manager
Developed by Diego Andrés (https://smftricks.com/index.php?action=profile;u=1)
Sponsored by Database Dreams (https://www.databasedreams.co.uk/)

---

Introduction
Tasks Manager lets you configure projects along with assigning individual or multiple tasks to each project. You can create categories and statuses for both projects and categories and filter through them.

Features

• Projects
  
  • Categories
  • Statuses
  • Types
  • Set starting and ending dates
• Tasks
  
  • Categories
  • Statuses
  • Set starting and ending dates
  • Set estimates for completion
  • Booking log
• Settings
  
  • Permissions
  • Pagination settings
  • Filter settings

Localization
(https://www.simplemachines.org/site_images/lang/english.gif) English
(https://www.simplemachines.org/site_images/lang/russian.gif) Russian by Bugo (https://www.simplemachines.org/community/index.php?action=profile;u=229017)
(https://www.simplemachines.org/site_images/lang/turkish.gif) Turkish by gevv (https://www.simplemachines.org/community/index.php?action=profile;u=155076)

---

Crowdin (https://crowdin.com/project/smf-tasks-manager)
Changelog (https://github.com/SMFTricks/Tasks-Manager/blob/main/CHANGELOG.md)
GitHub (https://github.com/SMFTricks/Tasks-Manager)

Found A Couple of Things

• The End Date Does not allow for the same date as the start date, There are a number of tasks that have less then 9 hrs so these can/should be completed On same day
• Please See image would it be possible to remove the history list for the date fields?

2022-02-19.png

1.0.1 - 21 February 2022
- (https://smftricks.com/assets/changelog/tag--pencil.png) Remove auto-complete from date inputs.
- (https://smftricks.com/assets/changelog/tag--pencil.png) Return to filter when editing tasks.
- (https://smftricks.com/assets/changelog/tag--pencil.png) Improved filter language.
- (https://smftricks.com/assets/changelog/tag--pencil.png) Allow to use the same date for projects and tasks.

Thanks I'll update tomorrow.

If anybodies interested in seeing a working version check it out here
Task manager (https://www.databasedreams.co.uk/support/index.php?action=tasksmanager)

Hi The "Return to filter when editing tasks" Returns me to the home page Instead of the tasks List.

I've also updated the Test forum

all the best mick

I've also edited the database as below

description varchar(500) Found when adding some descriptions 255 was not enough
additional_details varchar(1000) When Adding Additional Resources: Links It cut them short.

regards mick

Fixed

1.0.2 - 22 February 2022
- (https://smftricks.com/assets/changelog/tag--pencil.png) Increased width of tasks and projects name/title.
- (https://smftricks.com/assets/changelog/bug--minus.png) Fixed occasional missing language string.
- (https://smftricks.com/assets/changelog/bug--minus.png) Fixed redirect link after editing a task.

I'll work on v1.1 at some point so any suggestions or feedback I'll just add it to that

Looking Good ;D

Great work @Diego Andrés.

Made A Few Edits  ;D I'm still new to PHP/MYSQL So hope what I've done Isn't too bad lol

Not sure if this is right place To post this

Task Manager (https://www.databasedreams.co.uk/support/index.php?action=tasksmanager;area=projects)


Find In Themes/default/languages/TasksManager/.english.php

$txt['TasksManager_projects_view_tasks'] = 'View tasks';
Add Below:
$txt['TasksManager_projects_Total_tasks'] = 'Tasks';
Create Link Of Project Name

Find In Sources/TasksManager/Projects.php
'function' => function($row)
{
$title = '<h6>' . $row['project_title'] . '</h6>';
Replace With
'function' => function($row) use ($txt, $scripturl)
{
$dlink ='<a href="' . $scripturl . '?action=tasksmanager;area=tasks;sa=index;project=' . $row['project_id'] . '">' . $row['project_title'] . '</a>';
$title = '<h6>' . $dlink . '</h6>';
Get count of Tasks For each project
Find Around Line 619
SELECT
p.project_id, p.project_title, p.project_picture, p.view_type,
p.category_id, p.start_date, p.end_date, p.description, p.additional_details,
p.type_id, p.status_id, c.category_name, t.type_name, s.status_name
FROM {db_prefix}taskspp_projects AS p
LEFT JOIN {db_prefix}taskspp_project_categories AS c ON (c.category_id = p.category_id)
LEFT JOIN {db_prefix}taskspp_project_types AS t ON (t.type_id = p.type_id)
LEFT JOIN {db_prefix}taskspp_project_status AS s ON (s.status_id = p.status_id) ' . (!empty($query) ?
$query : '') . '
ORDER BY {raw:sort}
LIMIT {int:start}, {int:limit}',
Replace with
SELECT
p.project_id, p.project_title, p.project_picture, p.view_type,
p.category_id, p.start_date, p.end_date, p.description, p.additional_details,
p.type_id, p.status_id, c.category_name, t.type_name, s.status_name, Count(d.task_id) As tasks
FROM {db_prefix}taskspp_projects AS p
LEFT JOIN {db_prefix}taskspp_tasks AS d ON (d.project_id = p.project_id)
LEFT JOIN {db_prefix}taskspp_project_categories AS c ON (c.category_id = p.category_id)
LEFT JOIN {db_prefix}taskspp_project_types AS t ON (t.type_id = p.type_id)
LEFT JOIN {db_prefix}taskspp_project_status AS s ON (s.status_id = p.status_id) ' . (!empty($query) ?
$query : '') . '
GROUP BY p.project_id
ORDER BY {raw:sort}
LIMIT {int:start}, {int:limit}',
Update The Status Column
Find
// Tasks Link
$status .= '<br /><a href="' . $scripturl . '?action=tasksmanager;area=tasks;sa=index;project=' . $row['project_id'] . '">' . $txt['TasksManager_projects_view_tasks'] . '</a>';
Replace With

// Count Tasks
$status .= '<br /><strong>'. $txt['TasksManager_projects_Total_tasks'] . ':</strong> '  . $row['tasks'];

Made Another Update Thanks to @Arantor for his help solving the last issue and as Always @Diego Andrés for his magic i was able to use.

As Always View The Results Here (https://www.databasedreams.co.uk/support/index.php?action=tasksmanager;area=projects)

NOTE THIS ASSUMES YOU HAVE USED MY LAST UPDATE?

Find In Themes/default/languages/TasksManager/.english.php

$txt['TasksManager_projects_Total_tasks'] = 'Tasks';
Replace with
$txt['TasksManager_projects_Total_tasks'] = 'Total Tasks';
Find In Sources/TasksManager/Projects.php

$status .= '<br /><strong>'. $txt['TasksManager_projects_Total_tasks'] . ':</strong> '  . $row['tasks'];
Add Below:
// Minutes
$minutes = (!empty($row['minutes_worked']) ? ($row['minutes_worked'] % 60) : 0);

// Actual hours
$hours = $row['hours_worked'] + floor($row['minutes_worked'] / 60);

$status .= '<br /><strong>'. $txt['TasksManager_tasks_time_booked'] . ':</strong> ' . (!empty($hours) || !empty($minutes) ? sprintf('%02d', $hours). ':' . sprintf('%02d', $minutes) : $txt['TasksManager_no_total_time']);
Find Around Line 628
SELECT
p.project_id, p.project_title, p.project_picture, p.view_type,
p.category_id, p.start_date, p.end_date, p.description, p.additional_details,
p.type_id, p.status_id, c.category_name, t.type_name, s.status_name, Count(d.task_id) As tasks
FROM {db_prefix}taskspp_projects AS p
LEFT JOIN {db_prefix}taskspp_tasks AS d ON (d.project_id = p.project_id)
LEFT JOIN {db_prefix}taskspp_project_categories AS c ON (c.category_id = p.category_id)
LEFT JOIN {db_prefix}taskspp_project_types AS t ON (t.type_id = p.type_id)
LEFT JOIN {db_prefix}taskspp_project_status AS s ON (s.status_id = p.status_id) ' . (!empty($query) ?
Replace With
SELECT
p.project_id, p.project_title, p.project_picture, p.view_type,
p.category_id, p.start_date, p.end_date, p.description, p.additional_details,
p.type_id, p.status_id, c.category_name, t.type_name, s.status_name, COUNT(DISTINCT d.task_id) As tasks,
SUM(ts.hours_worked) AS hours_worked, SUM(ts.minutes_worked) AS minutes_worked
FROM {db_prefix}taskspp_projects AS p
LEFT JOIN {db_prefix}taskspp_tasks AS d ON (d.project_id = p.project_id)
LEFT JOIN {db_prefix}taskspp_timesheet AS ts ON (ts.task_id = d.task_id)
LEFT JOIN {db_prefix}taskspp_project_categories AS c ON (c.category_id = p.category_id)
LEFT JOIN {db_prefix}taskspp_project_types AS t ON (t.type_id = p.type_id)
LEFT JOIN {db_prefix}taskspp_project_status AS s ON (s.status_id = p.status_id) ' . (!empty($query) ?

I'm not able to do it myself as looked at it and really not sure enough on what I would be doing to tackle it  ;D

I would like to Move the Modify And Delete columns into One Column this would give a little bit more real estate for Admins.

Hopefully it will make it into a edit for the next version  8)

https://www.databasedreams.co.uk/support/index.php?action=tasksmanager

mick

1.1 - 03 March 2022
(https://camo.githubusercontent.com/33b5ae016b1a4c742049dc443886d242b5129207264c7d76586052d316646876/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6c616e67756167652e706e67) Russian translation provided by Bugo
(https://camo.githubusercontent.com/dabbb7cab40c66b82cb563365d644a1f098f665bf28cef0616f69a1a0f25084e/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d706c75732e706e67) Added 'Who" action integration.
(https://camo.githubusercontent.com/2b4ab97b0305c84fe3d563f95de3f5eaa7019a88172cd590e0d0ffbb681f2cf1/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d70656e63696c2e706e67) Merged delete and modify columns.
(https://camo.githubusercontent.com/2b4ab97b0305c84fe3d563f95de3f5eaa7019a88172cd590e0d0ffbb681f2cf1/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d70656e63696c2e706e67) It now uses the topics table to assign tasks.
(https://camo.githubusercontent.com/dabbb7cab40c66b82cb563365d644a1f098f665bf28cef0616f69a1a0f25084e/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d706c75732e706e67) Added total tasks counter to projects.
(https://camo.githubusercontent.com/dabbb7cab40c66b82cb563365d644a1f098f665bf28cef0616f69a1a0f25084e/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d706c75732e706e67) Added total time booked from tasks to projects.
(https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixes issues with some queries.
(https://camo.githubusercontent.com/2b4ab97b0305c84fe3d563f95de3f5eaa7019a88172cd590e0d0ffbb681f2cf1/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d70656e63696c2e706e67) Code cleanup.

Have Updated Which looks good But have found that It seems to remove all Topic links from Tasks but have checked the table and they are still there??

All The Best mick

Chart Tracker Elite Tasks (https://www.databasedreams.co.uk/support/index.php?action=tasksmanager;area=tasks;sa=index;project=3)

Just noticed The Book Time: Tasks Lists Seems To Use "Amount of items to show in the filters" But This will cause problems, I had to adjust "Amount of items to show in the filters" So I could select what I needed??

Can you do the list like, I expect to have hundreds of tasks for different projects some of which I may have to revisit from time to time

Project 1
--Task 1
--Task 2
Project 2
-- Task 1
-- Task 2

act

mick

Quote from: mickjav on March 06, 2022, 08:05:07 AMHave Updated Which looks good But have found that It seems to remove all Topic links from Tasks but have checked the table and they are still there??

All The Best mick

It now uses the topics table to remove the extra query in the topic page.
The topic column has been removed from tasks.

Quote from: mickjav on March 06, 2022, 08:50:10 AMJust noticed The Book Time: Tasks Lists Seems To Use "Amount of items to show in the filters" But This will cause problems, I had to adjust "Amount of items to show in the filters" So I could select what I needed??

You mean you want to be displaying the whole list A-Z when adding a new entry?

If you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Sorry just trying to understand You said you Had to Run A Query I prusume to check that the topic existed?

which You changed for this LEFT JOIN {db_prefix}topics AS t ON (t.tasks_task_id = tk.task_id)


That's still going to cause the system to work hard to build that query but Less than before I.E this site has 480k topics.

Why not Update the Topic Delete function so it checks for a linked topic in the tasks table that would remove the overhead completely?

As I said just trying to understand :)

Really useful and nice mod, I will definitely use it, thanks Diego Andrés.

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Do you want to remove the limit from the booking page for both the filter and the booking action?

Quote from: Diego Andrés on March 07, 2022, 12:22:15 PM

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Do you want to remove the limit from the booking page for both the filter and the booking action?

I think it would be better for the program to sort something else out as over time that list may end up with hundreds of items.

As I pointed out something that Gallery pro uses which works well even with 600 records as below.

Project One
--Task One
--Task two
Project two
--Task one

And So One

SMF 2.1.1
Tasks Manager v1.1

@Diego Andrés I'm having a bad day I guess, sorry! O:)

Tried to install this on my theme demo site so I can keep up with all my tasks and theme edits but got this error:

QuoteKey column 'topic_id' doesn't exist in table
File: /home2/*****/public_html/*****/*****/Packages/temp/install.php
Line: 355

QuoteError
Type of error
Database
Error message
Database Error: Key column 'topic_id' doesn't exist in table
File
/home2/*****/public_html/*****/*****/Packages/temp/install.php
Line
355
URL of page causing the error
https://*****.*****.com/index.php?action=admin;area=packages;sa=install2;package=Tasks-Manager_v1.1.zip;pid=0

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/*****/Sources/DbPackages-mysql.php on line 206
#2: smf_db_create_table()
Called from /home2/*****/public_html/*****/*****/Packages/temp/install.php on line 355
#3: require()
Called from /home2/*****/public_html/*****/*****/Sources/Packages.php on line 1064
#4: PackageInstall()
Called from /home2/*****/public_html/*****/*****/Sources/Subs.php on line 6001
#5: call_helper()
Called from /home2/*****/public_html/*****/*****/Sources/Packages.php on line 91
#6: Packages()
Called from /home2/*****/public_html/*****/*****/Sources/Admin.php on line 499
#7: AdminMain()
Called from /home2/*****/public_html/*****/*****/index.php on line 187

It's a bug, sort of. I forgot to remove that index from the tasks table.
Will update it in later  :P

1.1.1 - 17 March 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed wrong index for tasks column in install file.

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Will have a look at this next week, if you have any suggestion let me know.

Quote from: Diego Andrés on March 18, 2022, 12:03:28 AM1.1.1 - 17 March 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed wrong index for tasks column in install file.

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Will have a look at this next week, if you have any suggestion let me know.

I do have a wishlist  ;D  ;D
https://www.databasedreams.co.uk/support/index.php?topic=90.0

I've also added a new ERD But need to update it for Task_ID Etc My main wish would be the time entry Comment and logging of Members_ID So we can have the option to team work.

All the best mick

Quote from: mickjav on March 07, 2022, 12:29:51 PM

Quote from: Diego Andrés on March 07, 2022, 12:22:15 PM

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Do you want to remove the limit from the booking page for both the filter and the booking action?

I think it would be better for the program to sort something else out as over time that list may end up with hundreds of items.

As I pointed out something that Gallery pro uses which works well even with 600 records as below.

Project One
--Task One
--Task two
Project two
--Task one

And So One

This is the only suggestion I can add for the Problem with the Tasks list, Unless you limit the list to items not marked as completed but then you will need a way for the user to identify what Status They use for Completed tasks??

mick

P.S. The post above has a image attached

Quote from: Diego Andrés on March 18, 2022, 12:03:28 AM1.1.1 - 17 March 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed wrong index for tasks column in install file.

Quote from: mickjav on March 06, 2022, 11:25:36 AMIf you have left the default 20 Entries And are filtering by Name Then if you have say 35 Tasks in your tasks table it may only show those tasks that start with the letters A-S and if you want to add time for a task that begins with T you can't as it wont be in the list

Will have a look at this next week, if you have any suggestion let me know.

Just an fyi on the latest download Tasks Manager v1.1.1 for SMF 2.1.1...

Error on install fresh install SMF 2.1.1

Quote'*****_demo.p.project_title' isn't in GROUP BY
File: /home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line: 555

QuoteError
Type of error
Database
Error message
Database Error: '*****_demo.p.project_title' isn't in GROUP BY
File
/home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line
555
URL of page causing the error
https://*****.com/index.php?action=tasksmanager

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 555
#2: getProjects()
Called from /home2/*****/public_html/*****/Sources/Subs-List.php on line 132
#3: createList()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 265
#4: list()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#5: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 76
#6: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#7: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#8: main()
Called from /home2/*****/public_html/*****/index.php on line 187

Tried to install Version 1.1.1 on my test Forum But have the install Index Error @Shades. has reported

I can see where in the install File the problem seems to be coming from but not sure how to correct it  :(

Also just noticed on my Support Site, This only seems to generate a error when viewing the Summery Page of a profile "See Image"

I suspect removing the below from install.php will allow it to complete

NOTE this will only work if you have installed 1.01
// Add a tasks column for the topics
$smcFunc['db_add_column']('
{db_prefix}topics',
[
'name' => 'tasks_task_id',
'type' => 'mediumint',
'size' => 8,
'unsigned' => true,
'default' => 0,
'not_null' => false,
]
);
I Think it needs a check to see if the column exists

This worked on my Test forum

That'll break adding tasks to a topic.
The issue is from something else.
I'll have a look later.

Quote from: Diego Andrés on March 19, 2022, 11:58:11 AMThat'll break adding tasks to a topic.
The issue is from something else.
I'll have a look later.

That's the code I had to REMOVE to enable It to complete the install:)

Haven't found why this is happening https://www.simplemachines.org/community/index.php?msg=4116852

1.1.2 - 19 March 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed projects issue.
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed 'who' actions bug.
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed issue with install file.

Clean SMF 2.1.1
Task Manager 1.1.2

Getting this error after install and clicking on the "Task Manager" link:

Quote'*****.p.project_picture' isn't in GROUP BY
File: /home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line: 555

QuoteError
Type of error
Database
Error message
Database Error: '*****.p.project_picture' isn't in GROUP BY
File
/home2/*****/public_html/*****/Sources/TasksManager/Projects.php
Line
555
URL of page causing the error
https://*****.com/index.php?action=tasksmanager

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 555
#2: getProjects()
Called from /home2/*****/public_html/*****/Sources/Subs-List.php on line 132
#3: createList()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 265
#4: list()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#5: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Projects.php on line 76
#6: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 5998
#7: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#8: main()
Called from /home2/*****/public_html/*****/index.php on line 187

Try with this file in Sources/TasksManager/

Projects.php

Quote from: Diego Andrés on March 19, 2022, 02:52:01 PMTry with this file in Sources/TasksManager/

Projects.php

Yes that worked thanks! 8)

Looks like Project categories and task categories are the same!?

If I add a new category to either one they both appear in Task categories but not in Project categories.

Ok both issues fixed.

Anything else mr mod tester  :laugh:
Before I upload

Quote from: Diego Andrés on March 19, 2022, 03:39:08 PMOk both issues fixed.

Anything else mr mod tester  :laugh:
Before I upload

LOL! That's all I can see right now! O:)  :laugh:

1.1.3 - 19 March 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed more issues with projects.
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed a bug in the category type selection.

Hi,

Nice mod. Thanks @Diego Andrés

Turkish translation.

SMF 2.1.1
Tasks Manager 1.1.3

Sorry @Diego Andrés! O:)

It won't let me delete Tasks categories! It pops up and asks "Are you sure you want to delete this category? This will make the relevant projects or tasks uncategorized."
tasks1.PNG

But then takes me to the edit screen and then a full circle back to the category list where the category I tried to delete is still there.
tasks2.jpeg

The url is wrong, will update package in a bit and will include Turkish translation.

Thanks

1.1.4 - 20 March 2022

• (https://camo.githubusercontent.com/33b5ae016b1a4c742049dc443886d242b5129207264c7d76586052d316646876/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6c616e67756167652e706e67) Turkish translation provided by @gevv
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed wrong links when deleting categories.

Quote from: Diego Andrés on March 20, 2022, 06:05:11 PM1.1.4 - 20 March 2022

• (https://camo.githubusercontent.com/33b5ae016b1a4c742049dc443886d242b5129207264c7d76586052d316646876/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6c616e67756167652e706e67) Turkish translation provided by @gevv
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed wrong links when deleting categories.

Superb! Great mod @Diego Andrés! 8)

Uh oh I ran into another error. O:)

When going to Booking>Time Log or Book Time I get this error:

Quote'mysite.tk.task_name' isn't in GROUP BY
File: /home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line: 544

QuoteError
Type of error
Database
Error message

Code Select Expand

Database Error: 'mysite.tk.task_name' isn't in GROUP BY



SELECT

tk.task_id, tk.task_name, tk.task_cat_id, tk.project_id,

tk.start_date, tk.end_date, tk.task_desc, tk.task_status_id, tk.estimated_hrs,

c.category_name, s.status_name, p.project_title, SUM(ts.hours_worked) AS hours_worked, SUM(ts.minutes_worked) AS minutes_worked, t.id_topic

FROM swb4_taskspp_tasks AS tk

LEFT JOIN swb4_topics AS t ON (t.tasks_task_id = tk.task_id)

LEFT JOIN swb4_taskspp_timesheet AS ts ON (ts.task_id = tk.task_id)

LEFT JOIN swb4_taskspp_projects AS p ON (p.project_id = tk.project_id)

LEFT JOIN swb4_taskspp_task_categories AS c ON (c.task_cat_id = tk.task_cat_id)

LEFT JOIN swb4_taskspp_project_status AS s ON (s.status_id = tk.task_status_id)

GROUP BY tk.task_id, c.category_name, s.status_name, p.project_title, t.id_topic

ORDER BY tk.task_id DESC

LIMIT 0, 25File
/home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line
544
URL of page causing the error
https://*****.com/index.php?action=tasksmanager;area=booking;sa=log

Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Tasks.php on line 544
#2: getTasks()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Book.php on line 59
#3: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 6057
#4: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#5: main()
Called from /home2/*****/public_html/*****/index.php on line 187

QuoteError
Type of error
Database
Error message

Code Select Expand

Database Error: 'mysite.tk.task_name' isn't in GROUP BY



SELECT

tk.task_id, tk.task_name, tk.task_cat_id, tk.project_id,

tk.start_date, tk.end_date, tk.task_desc, tk.task_status_id, tk.estimated_hrs,

c.category_name, s.status_name, p.project_title, SUM(ts.hours_worked) AS hours_worked, SUM(ts.minutes_worked) AS minutes_worked, t.id_topic

FROM swb4_taskspp_tasks AS tk

LEFT JOIN swb4_topics AS t ON (t.tasks_task_id = tk.task_id)

LEFT JOIN swb4_taskspp_timesheet AS ts ON (ts.task_id = tk.task_id)

LEFT JOIN swb4_taskspp_projects AS p ON (p.project_id = tk.project_id)

LEFT JOIN swb4_taskspp_task_categories AS c ON (c.task_cat_id = tk.task_cat_id)

LEFT JOIN swb4_taskspp_project_status AS s ON (s.status_id = tk.task_status_id)

GROUP BY tk.task_id, c.category_name, s.status_name, p.project_title, t.id_topic

ORDER BY tk.task_id DESC

LIMIT 0, 25File
/home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line
544
URL of page causing the error
https://*****.com/index.php?action=tasksmanager;area=booking;sa=booktime
Backtrace information
#0: smf_db_error()
Called from /home2/*****/public_html/*****/Sources/Subs-Db-mysql.php on line 494
#1: smf_db_query()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Tasks.php on line 544
#2: getTasks()
Called from /home2/*****/public_html/*****/Sources/TasksManager/Book.php on line 59
#3: main()
Called from /home2/*****/public_html/*****/Sources/Subs.php on line 6057
#4: call_helper()
Called from /home2/*****/public_html/*****/Sources/TasksManager/View.php on line 219
#5: main()
Called from /home2/*****/public_html/*****/index.php on line 187

Mysql version? Or is it MariaDB?

Older mysql versions (and current mariadb) want a lot of unnecessary items in the group by.

The fix is typically to add all non-aggregate items in the select clause to the group by.

Quote from: shawnb61 on March 20, 2022, 09:10:38 PMMysql version? Or is it MariaDB?

Older mysql versions (and current mariadb) want a lot of unnecessary items in the group by.

The fix is typically to add all non-aggregate items in the select clause to the group by.

MySQL 5.6 PHP 7.4

The mod works great like it is and I don't really need the Booking part myself I was just testing it out. But I guess sooner or later I'm gonna have to upgrade to another host with a bigger MySQL version!?

Yep.  Mysql 5.7 doesn't behave that way, but 5.6 does.

Since SMF supports 5.6, I suspect the query needs to change. 

I'm just gonna dump all of the columns there in all of those before I need to go look for a rope instead of a query  :laugh:

I just ran into this on some custom stuff used in my forum that I'm bringing forward into 2.1.  My host is still on 5.6...  (I may submit it as a mod - an attachment browser w/tags & filters to help peruse attachments.)

@Shades. test?

Tasks.php

Quote from: Diego Andrés on March 21, 2022, 03:16:16 AM@Shades. test?

Tasks.php

Uploaded and getting:

QuoteUnknown column 'ttk.task_id' in 'field list'
File: /home2/*****/public_html/*****/Sources/TasksManager/Tasks.php
Line: 544

typo
Tasks.php

Quote from: Diego Andrés on March 21, 2022, 02:32:07 PMtypo
Tasks.php

:laugh: Now getting:

QuoteUnknown column 'k.task_status_id' in 'field list'
File: /home2/shades75/public_html/shadesweb/Sources/TasksManager/Tasks.php
Line: 544

:D

Tasks.php

Quote from: Diego Andrés on March 21, 2022, 03:01:55 PM:D

Tasks.php

Bingo!! ;D  :laugh:

Great!

1.1.5 - 21 March 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed some more group by 'issues'.

1.1.7 - 09 October 2022

• (https://camo.githubusercontent.com/dabbb7cab40c66b82cb563365d644a1f098f665bf28cef0616f69a1a0f25084e/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d706c75732e706e67) New field to add comments in bookings.
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed tasks filter in booking action.

1.1.6 - 19 August 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed issue with who actions/hook.

Hi Getting Following Error On First view of Time Log.

2022-10-10.png

I have fixed my copy by adding the field 

Likely to happen when the table is already created.
I'll add something to address that.

Quote from: Diego Andrés on October 10, 2022, 01:42:05 AMLikely to happen when the table is already created.
I'll add something to address that.

Lol should have used alter table if it existed  ;D

Other than that works fine thanks mick

1.1.8 - 04 November 2022

• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed issue when viewing the Online list.

Feature Request: ;D

Members Projects

• Members can create projects and mark them as private or public "Depending on View Tasks Manager settings"
• the current projects screen should be retained and used to show all public Projects with the option to view only viewing members projects
• Project Entry screen updated to include members ID and a public/private option
• Add Post Count option to increment post count for new projects

This may only require 2 new fields to be added to the project table member_id & Viewing

Not sure what may be needed for other screens to check if project is private and the owner is viewing?

All the best mick

Also The task list for the book time And the projects list would need to have their SQL updated to limit my member for project also the project list by member.

Would it be possible to add a date selector to the book time screen, As on a lot of occasions I have not been able to add the time for a specific task on that day, so have had to add tasks for the incorrect day.

All the best mick

I'll check it soon, should be no problem adding that.

1.1.9 - 20 May 2023

• (https://camo.githubusercontent.com/2b4ab97b0305c84fe3d563f95de3f5eaa7019a88172cd590e0d0ffbb681f2cf1/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d70656e63696c2e706e67) (https://camo.githubusercontent.com/2b4ab97b0305c84fe3d563f95de3f5eaa7019a88172cd590e0d0ffbb681f2cf1/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f7461672d2d70656e63696c2e706e67) Added new field to setup a different date when booking.
• (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) (https://camo.githubusercontent.com/5ba14cc5b307fd7683ab0b95737b5548d492d0029f2ce6f42c7cda8cc1c90fb9/68747470733a2f2f736d66747269636b732e636f6d2f6173736574732f6368616e67656c6f672f6275672d2d6d696e75732e706e67) Fixed exceeding length issue for hours booked.

Worked a treat thanks

mick