{"action":"created","issue":{"url":"https://api.github.com/repos/osTicket/osTicket/issues/3231","repository_url":"https://api.github.com/repos/osTicket/osTicket","labels_url":"https://api.github.com/repos/osTicket/osTicket/issues/3231/labels{/name}","comments_url":"https://api.github.com/repos/osTicket/osTicket/issues/3231/comments","events_url":"https://api.github.com/repos/osTicket/osTicket/issues/3231/events","html_url":"https://github.com/osTicket/osTicket/pull/3231","id":161999935,"number":3231,"title":"Feature / Time Tracking v1-10-x","user":{"login":"robintoy","id":8893903,"avatar_url":"https://avatars.githubusercontent.com/u/8893903?v=3","gravatar_id":"","url":"https://api.github.com/users/robintoy","html_url":"https://github.com/robintoy","followers_url":"https://api.github.com/users/robintoy/followers","following_url":"https://api.github.com/users/robintoy/following{/other_user}","gists_url":"https://api.github.com/users/robintoy/gists{/gist_id}","starred_url":"https://api.github.com/users/robintoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robintoy/subscriptions","organizations_url":"https://api.github.com/users/robintoy/orgs","repos_url":"https://api.github.com/users/robintoy/repos","events_url":"https://api.github.com/users/robintoy/events{/privacy}","received_events_url":"https://api.github.com/users/robintoy/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":34,"created_at":"2016-06-23T19:08:26Z","updated_at":"2017-02-03T10:20:28Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/osTicket/osTicket/pulls/3231","html_url":"https://github.com/osTicket/osTicket/pull/3231","diff_url":"https://github.com/osTicket/osTicket/pull/3231.diff","patch_url":"https://github.com/osTicket/osTicket/pull/3231.patch"},"body":"### Introduction\n\nTime Feature to allow users to record the amount of time taken for each thread posted which can then be pulled together in a report so you know the actual time spent on a ticket.\n\nTime can also be marked as billable along with assigning different classes / types of time like on-site or remote.\n\nAll the code to make this is done, unfortunately I do not know how to update the stream or database via your system yet. I have listed all required SQL below along with what files I have modified\n### Files modified\n\ninclude/class.config.php\ninclude/class.nav.php\ninclude/class.thread.php\ninclude/class.ticket.php\ninclude/client/view.inc.php\ninclude/i18n/en_US/help/tips/settings.tickettime.yaml\ninclude/i18n/en_US/list.yaml\ninclude/staff/org-view.inc.php\ninclude/staff/settings-tickettime.inc.php\ninclude/staff/templates/thread-entry.tmpl.php\ninclude/staff/templates/ticket-print.tmpl.php\ninclude/staff/ticket-view.inc.php\nscp/org_bill.php\nscp/settings.php\nscp/tickets_bill.php\nscp/tickets_cost.php\n### Database Modifications\n\nRun the following commands in something like PHPMyAdmin or MySQL CLI\n\n``` sql\nINSERT INTO  ost_list  ( name ,  name_plural ,  sort_mode ,  masks ,  type ,  notes ,  created ,  updated ) VALUES ('Time Type', 'Time Types', 'SortCol', '13', 'time-type', 'Time Spent plugin list, do not modify', NOW(), NOW());\n```\n\n``` sql\nINSERT INTO `ost_list_items` (`list_id`, `status`, `value`, `sort`)\nSELECT ost_list.id, 1, 'Telephone', 1\nFROM ost_list\nWHERE `name`='Time Type';\n\nINSERT INTO `ost_list_items` (`list_id`, `status`, `value`, `sort`)\nSELECT ost_list.id, 1, 'Email', 2\nFROM ost_list\nWHERE `name`='Time Type';\n\nINSERT INTO `ost_list_items` (`list_id`, `status`, `value`, `sort`)\nSELECT ost_list.id, 1, 'Remote', 3\nFROM ost_list\nWHERE `name`='Time Type';\n\nINSERT INTO `ost_list_items` (`list_id`, `status`, `value`, `sort`)\nSELECT ost_list.id, 1, 'Workshop', 4\nFROM ost_list\nWHERE `name`='Time Type';\n\nINSERT INTO `ost_list_items` (`list_id`, `status`, `value`, `sort`)\nSELECT ost_list.id, 1, 'Onsite', 5\nFROM ost_list\nWHERE `name`='Time Type';\n```\n\n``` sql\nINSERT INTO  ost_config  (`namespace`, `key`, `value`, `updated`) VALUES\n ('core', 'isclienttime', 0, now()),\n ('core', 'isthreadtime', 0, now()),\n ('core', 'isthreadtimer', 0, now()),\n ('core', 'isthreadbill', 0, now()),\n ('core', 'isthreadbilldefault', 0, now()),\n ('core', 'istickethardware', 0, now());\n```\n\n``` sql\nALTER TABLE  ost_thread_entry  ADD COLUMN  time_spent  INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER  type;\n\nALTER TABLE  ost_thread_entry  ADD COLUMN  time_type  INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER  time_spent;\n\nALTER TABLE  ost_thread_entry  ADD COLUMN  time_bill  INT( 11 ) UNSIGNED NOT NULL DEFAULT '0' AFTER  time_type;\n```\n# \n\nThis is a mod that has been worked on for a long time through the v1-8-x up until now.\n\nBeen speaking with @greezybacon on this for a while to make sure it is ready for a pull.\n\nPrevious versions and conversations can be found: -\nhttps://github.com/osTicket/osTicket/pull/1419\nAND\nhttps://github.com/StrobeTechnologiesLtd/osTicket-1.8/pull/5\n"},"comment":{"url":"https://api.github.com/repos/osTicket/osTicket/issues/comments/277213028","html_url":"https://github.com/osTicket/osTicket/pull/3231#issuecomment-277213028","issue_url":"https://api.github.com/repos/osTicket/osTicket/issues/3231","id":277213028,"user":{"login":"robintoy","id":8893903,"avatar_url":"https://avatars.githubusercontent.com/u/8893903?v=3","gravatar_id":"","url":"https://api.github.com/users/robintoy","html_url":"https://github.com/robintoy","followers_url":"https://api.github.com/users/robintoy/followers","following_url":"https://api.github.com/users/robintoy/following{/other_user}","gists_url":"https://api.github.com/users/robintoy/gists{/gist_id}","starred_url":"https://api.github.com/users/robintoy/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/robintoy/subscriptions","organizations_url":"https://api.github.com/users/robintoy/orgs","repos_url":"https://api.github.com/users/robintoy/repos","events_url":"https://api.github.com/users/robintoy/events{/privacy}","received_events_url":"https://api.github.com/users/robintoy/received_events","type":"User","site_admin":false},"created_at":"2017-02-03T10:20:28Z","updated_at":"2017-02-03T10:20:28Z","body":"The files are available from our profile is what I mean\r\n\r\n\r\nKind Regards\r\nRobin\r\n\r\n\r\nRobin Toy\r\nDirector\r\nStrobe Technologies Ltd\r\n[in]<https://www.linkedin.com/in/robin-toy-13714625>[sw]<http://community.spiceworks.com/people/robintoy>\r\n\r\nFrom: ZailCZ [mailto:notifications@github.com]\r\nSent: 03 February 2017 10:18\r\nTo: osTicket/osTicket <osTicket@noreply.github.com>\r\nCc: Robin Toy <robin@strobe-it.co.uk>; Mention <mention@noreply.github.com>\r\nSubject: Re: [osTicket/osTicket] Feature / Time Tracking v1-10-x (#3231)\r\n\r\n\r\n@robintoy<https://github.com/robintoy> \"files will have to be taken direct from source\" - how do you mean it? This mod is ready to download from somewhere and working at 1.10?\r\n\r\nThank you in advance\r\n\r\n—\r\nYou are receiving this because you were mentioned.\r\nReply to this email directly, view it on GitHub<https://github.com/osTicket/osTicket/pull/3231#issuecomment-277212477>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AIe1zylpdXXRl_tpTQwWuJ5ilVVn_n-Hks5rYv7WgaJpZM4I9I4q>.\r\n\r\n\r\n\r\nRobin Toy\r\n\r\nt: +441884 664004\r\nm: +447588 821979\r\ne: robin@strobe-it.co.uk<mailto:robin@strobe-it.co.uk>\r\n\r\nMaking IT Possible for: Business, Health & Life!\r\n\r\n[Follow Us via LinkedIn Logo]<https://www.linkedin.com/company/strobe-it/> [Follows Us via Twitter Logo] <https://twitter.com/StrobeIT/>  [Follow Us via Google+ Logo] <https://plus.google.com/b/100491222414369340300/100491222414369340300/>  [Follow Us via Spiceworks Logo] <https://community.spiceworks.com/service-providers/25927-strobe-technologies-ltd>\r\n\r\nPlease consider the environment before printing this E-mail\r\n\r\n________________________________\r\nStrobe IT is the trading name of Strobe Technologies Ltd. Company registration No. 8031223. Registered in England. 17 Courtney Road, Tiverton. Devon. EX16 6EE\r\n\r\nDisclaimer\r\nInternet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of the company.\r\n\r\nConfidentiality Notice\r\nThis message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of this message, or files associated with this message, is strictly prohibited. If you have received this message in error, please notify us immediately by replying to the message and deleting it from your computer. Messages sent to and from us may be monitored.\r\n\r\n\r\n"}}
{"actor":{"display_login":"robintoy"}}