News:

SMF 2.1.2 has been released! Take it for a spin! Read more.

Main Menu

Tasks Manager

Started by Diego Andrés, February 19, 2022, 11:18:08 PM

Previous topic - Next topic

Diego Andrés

Link to the mod




Tasks Manager
Developed by Diego Andrés
Designed by Database Dreams




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
English
Russian by Bugo
Turkish by gevv


Changelog
GitHub

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

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?

You cannot view this attachment.

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

1.0.1 - 21 February 2022
- Remove auto-complete from date inputs.
- Return to filter when editing tasks.
- Improved filter language.
- Allow to use the same date for projects and tasks.

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

Thanks I'll update tomorrow.

If anybodies interested in seeing a working version check it out here
Task manager

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

Fixed

1.0.2 - 22 February 2022
- Increased width of tasks and projects name/title.
- Fixed occasional missing language string.
- 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

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav


Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.


mickjav

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


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'];





Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

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) ?






Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

1.1 - 03 March 2022
Translation Russian translation provided by Bugo
New Feature Added 'Who" action integration.
Improvement Merged delete and modify columns.
Improvement It now uses the topics table to assign tasks.
New Feature Added total tasks counter to projects.
New Feature Added total time booked from tasks to projects.
Bug Fix Fixes issues with some queries.
Improvement Code cleanup.

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

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.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Diego Andrés

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?

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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 :)

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

tmachu

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

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?

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Shades.

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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

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

SMF Tricks - Free & Premium Responsive Themes for SMF.

Diego Andrés

1.1.1 - 17 March 2022
  • Bug Fix 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.

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

Quote from: Diego Andrés on March 18, 2022, 12:03:28 AM1.1.1 - 17 March 2022
  • Bug Fix 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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Shades.

Quote from: Diego Andrés on March 18, 2022, 12:03:28 AM1.1.1 - 17 March 2022
  • Bug Fix 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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

mickjav

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"

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

mickjav

#29
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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

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

SMF Tricks - Free & Premium Responsive Themes for SMF.

mickjav

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

Home of Chart Tracker Elite, Apollo & DJ 2020, Coming soon The Librarian.

Diego Andrés

1.1.2 - 19 March 2022
  • Bug Fix Fixed projects issue.
  • Bug Fix Fixed 'who' actions bug.
  • Bug Fix Fixed issue with install file.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

#34
Try with this file in Sources/TasksManager/

You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

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

You cannot view this attachment.
Yes that worked thanks! 8)
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Shades.

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.
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

Ok both issues fixed.

Anything else mr mod tester  :laugh:
Before I upload

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

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:
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

1.1.3 - 19 March 2022
  • Bug Fix Fixed more issues with projects.
  • Bug Fix Fixed a bug in the category type selection.

SMF Tricks - Free & Premium Responsive Themes for SMF.

gevv

Hi,

Nice mod. Thanks @Diego Andrés

Turkish translation.
ElkArte is a modern, powerful community building forum software. https://www.elkarte.net/

Shades.

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."
You cannot view this attachment.

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.
You cannot view this attachment.
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

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

Thanks

SMF Tricks - Free & Premium Responsive Themes for SMF.

Diego Andrés

1.1.4 - 20 March 2022
  • Translation Turkish translation provided by @gevv
  • Bug Fix Fixed wrong links when deleting categories.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 20, 2022, 06:05:11 PM1.1.4 - 20 March 2022
  • Translation Turkish translation provided by @gevv
  • Bug Fix Fixed wrong links when deleting categories.
Superb! Great mod @Diego Andrés! 8)
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Shades.

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
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, 25
File
/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
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, 25
File
/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
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

shawnb61

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.
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Shades.

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!?
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

shawnb61

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. 
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Diego Andrés

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:

SMF Tricks - Free & Premium Responsive Themes for SMF.

shawnb61

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.)
Address the process rather than the outcome.  Then, the outcome becomes more likely.   - Fripp

Diego Andrés

#51
@Shades. test?

You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

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

You cannot view this attachment.
Uploaded and getting:

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

ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

#53
typo
You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

Quote from: Diego Andrés on March 21, 2022, 02:32:07 PMtypo
You cannot view this attachment.
:laugh: Now getting:

QuoteUnknown column 'k.task_status_id' in 'field list'
File: /home2/shades75/public_html/shadesweb/Sources/TasksManager/Tasks.php
Line: 544
ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

#55
:D

You cannot view this attachment.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Shades.

ShadesWeb.com - Custom Logos - My Themes on SMF | My Themes on ShadesWeb
https://shadesweb.com

BikerHound.com - Sniffing out the road ahead
https://bikerhound.com

Dream as if you'll live forever; Live as if you'll die today. - James Dean

Diego Andrés

Great!

1.1.5 - 21 March 2022
  • Bug Fix Fixed some more group by 'issues'.

SMF Tricks - Free & Premium Responsive Themes for SMF.

Advertisement: