taskGNU remotecontrol - Tasks: task #12522, Add GROUP field to thermostat...


You are not allowed to post comments on this tracker with your current authentification level.

task #12522: Add GROUP field to thermostat profile on index.php

Submitted by:  Stephen H. Dawson <shdawson>
Submitted on:  Sun 10 Mar 2013 12:42:39 AM UTC  
Should Start On: Sat 09 Mar 2013 05:00:00 AM UTCShould be Finished on: Sun 14 Jul 2013 04:00:00 AM UTC
Category: User InterfacePriority: 5 - Normal
Item Group: InstallationStatus: Done
Privacy: PublicAssigned to: None
Open/Closed: OpenFixed Release: 1.1
Percent Complete: 100%Planned Release: 1.1

(Jump to the original submission Jump to the original submission)

Tue 24 Sep 2013 04:45:26 PM UTC, comment #6:

I bear witness and certify I have personally tested these changes made to GNU remotecontrol. I affirm the changes made to the code:
-achieve the functionality of the stated requirements;
-succeed during operation; and
-cause no anxiety.

I approve this code.

Thank you to everyone for working on this modification.

Very Respectfully,
Stephen H. Dawson

Stephen H. Dawson <shdawson>
Project Administrator
Sat 29 Jun 2013 10:27:09 AM UTC, comment #5:

Splitting off the EXPAND/COLLAPSE functionality to task #12721. Please only add the GROUP field in this task. The remaining EXPAND/COLLAPSE functionality will need to be completed in version 1.2.

Stephen H. Dawson <shdawson>
Project Administrator
Wed 26 Jun 2013 11:20:06 AM UTC, comment #4:

We need to have the new field of GROUP in version 1.1, but we do not necessary need to have the expand/collapse functionality in version 1.1. If you are pressed for time, we can push the expand/collapse functionality to version 1.2 by making a new task and moving that part of this task over with no problem.

Stephen H. Dawson <shdawson>
Project Administrator
Mon 17 Jun 2013 03:20:25 PM UTC, comment #3:

We would most likely do best by adding functionality to the admin.php page to accomplish generating and deleting groups. That keeps the thermostat profile table on index.php from getting any wider. All we have to do is decide on how we want to add the new field, Group, to that thermostat profile table.

We can have a User section on admin.php, like we have now, and a Group section (either above or below the existing User section). We have 2 on-page hyper-links at the top of admin.php, User Group, that jumps to each respective section.

We achieve similar functionality in the Group section as we have now in the User section.

-Edit/Add/Update Cancel
-Group Name
-We would most likely do best to go with a Group Description field
-We would most likely do best to add a count of thermostats in a given Group

Now, there is not a lot of value to having a total count of thermostats in a group. This is due to the same problem that exists in the Total Thermostat count. Say user_1 has 10 thermostats, user_2 has 10 thermostats, and user_3 has 10 thermostats. There is no assurance, except by the wisdom of well-executed user choice, to enter 10 exclusive thermostats in each set of user assigned thermostats. There could be overlap that occurs by having the same physical thermostat entered 3 different times; by DNS name, by public IP address, or by private IP address.

I covered speaking to this problem at:

.....in the Domain Name/IP bullet.

Just the same, we should have that count of thermostats assigned to each Group. This is to solve the problem of if they are moving thermostats to a new group and want to delete that group. Knowing the thermostat count for that group is zero provides, in a web page and not being required to hit the database through SQL to find that answer, if there are any thermostats left in the group before deleting the said group.

The index.php page only provides the functionally to use a pull-down object to select for adding a thermostat into a group. That completely avoids any possibility of typographical errors from a user adding a thermostat and incorrectly entering the group the thermostat is a member of. The pull-down SQL is Select * from GroupName, order by GroupName.

I see a new table, as well. Probably group is a good name, with a GroupId like we have now with UserId.

Please consider and let me know your thoughts.


Stephen H. Dawson <shdawson>
Project Administrator
Mon 17 Jun 2013 01:39:16 PM UTC, comment #2:

Adding this new field, group, is simply a text field that is capable of letter, numbers, dashes, colon, whatever the end-user wants to put in there.

If we cannot simply achieve an expand and collapse functionality with PHP/JavaScript, then we need to further explore an additional check-box field (column). This would be to select a group, and that would select all check-boxes of thermostats in that group. This check-box would be only at the group level, but it does seem like a column for group and a column for thermostat would have to happen for this concept to work.

Attached is an idea I came up with. Not a mandate, simply an illustration of my thinking. If we go with an ALL row, we would not need a 2nd column of check boxes. The example to the left of the black line in the attachment is the simplest. The example to the right of the black line is more complicated.

Please review and advise on what you think is best.

Thank You,

(file #28332)

Stephen H. Dawson <shdawson>
Project Administrator
Tue 21 May 2013 10:48:23 PM UTC, comment #1:


Pacific Gas and Electric is a large provider in California.

Stephen H. Dawson <shdawson>
Project Administrator
Sun 10 Mar 2013 12:42:39 AM UTC, original submission:

No pagination, EXPAND/COLLAPSE functionality. Similar to a File Manager (Windows Explorer, Gnome Nautilus).

Having 100,000 thermostats in the GRID would be rather tough to scroll through. Need to determine how we can assign grouping to the thermostats.

Should the thermostats be a member of a single group, or multiple groups?

The goal is to select a GROUP of thermostats in a single click. This would avoid having to select all thermostats that are in a group. An example of this is a Power Grid.



The thought is to help with power outages and roaming brown outs.



Stephen H. Dawson <shdawson>
Project Administrator


Attached Files
file #28332:  GROUP - Illustration of Ideas.ods added by shdawson (17kB - application/vnd.oasis.opendocument.spreadsheet)


Depends on the following items: None found

Items that depend on this one: None found


Carbon-Copy List
  • -unavailable- added by shdawson (Submitted the item)

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.


    Please enter the title of George Orwell's famous dystopian book (it's a date):



    Follow 15 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Tue 24 Sep 2013 04:45:26 PM UTCshdawsonStatusReady For Test=>Done
      Assigned tovirgiliolino=>None
      Percent Complete0%=>100%
    Sun 21 Jul 2013 12:48:31 PM UTCshdawsonStatusNeed Info=>Ready For Test
    Sat 29 Jun 2013 11:44:39 AM UTCshdawsonShould be Finished onSun 28 Jul 2013 04:00:00 AM UTC=>Sun 14 Jul 2013 04:00:00 AM UTC
    Sat 29 Jun 2013 10:27:09 AM UTCshdawsonSummaryAdd EXPAND/COLLAPSE to thermostats in GRID=>Add GROUP field to thermostat profile on index.php
    Sat 29 Jun 2013 10:24:54 AM UTCshdawsonItem GroupNone=>Installation
    Tue 18 Jun 2013 09:36:59 PM UTCshdawsonFixed ReleaseNone=>1.1
    Mon 17 Jun 2013 01:39:16 PM UTCshdawsonAttached File-=>Added GROUP - Illustration of Ideas.ods, #28332
    Sun 16 Jun 2013 08:52:56 PM UTCshdawsonPlanned Release1.2=>1.1
    Sun 16 Jun 2013 08:37:41 PM UTCshdawsonShould be Finished onSat 28 Sep 2013 04:00:00 AM UTC=>Sun 28 Jul 2013 04:00:00 AM UTC
    Sun 16 Jun 2013 08:36:51 PM UTCshdawsonShould be Finished onSun 15 Sep 2013 04:00:00 AM UTC=>Sat 28 Sep 2013 04:00:00 AM UTC
    Sun 16 Jun 2013 08:35:55 PM UTCshdawsonAssigned toshdawson=>virgiliolino
    Sun 16 Jun 2013 08:28:49 PM UTCshdawsonShould be Finished onSat 09 Mar 2013 05:00:00 AM UTC=>Sun 15 Sep 2013 04:00:00 AM UTC
    Sun 10 Mar 2013 01:37:10 PM UTCshdawsonCategoryPHP=>User Interface

    Back to the top

    Powered by Savane 3.1-cleanup