{"id":208,"date":"2023-01-10T18:29:33","date_gmt":"2023-01-10T18:29:33","guid":{"rendered":"https:\/\/trewest.dev\/blog\/?p=208"},"modified":"2023-12-05T09:34:35","modified_gmt":"2023-12-05T09:34:35","slug":"project-bugtrakt","status":"publish","type":"post","link":"https:\/\/trewest.dev\/blog\/index.php\/2023\/01\/10\/project-bugtrakt\/","title":{"rendered":"Project: Bugtrakt"},"content":{"rendered":"
\n\t\t\t\n\t\n\t\n\t\t

\n\t\t\tThis is post 1 of 21 in the series “Project Overviews”<\/em>\t\t<\/p>\n\t\t\t\t\t

\n\t\t\t\t

A series of posts detailing and highlighting projects that I’ve made.<\/p>\n\t\t\t<\/div>\n\t\t\t<\/label>\n\n\t\t\t

\n\t\t\t
    \n\t\t\t\t\t\t\t\t\t
  1. Project: Bugtrakt<\/span><\/li>\n\t\t\t\t\t\t\t\t\t
  2. Project: Imgalib<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  3. Project: Go Fish!<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  4. Project: trewest.dev<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  5. Arduino Light effects<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  6. Project: Mini Stacker<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  7. Project: Arduino NES Controller<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  8. Project: Metroidvania-Like<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  9. Project: Susminer<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  10. Project: Farming Demo<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  11. Project: VRC Basement<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  12. Project: Hash Clear<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  13. Project: Titan Help<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  14. Project: Computer Craft Scripts<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  15. Project: ESP8266 Plant Watering<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  16. Project: Golf Demo<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  17. Project: Ghost Holic<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  18. Project: Multi-Chat Viewer<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  19. Project: Interview Simulator<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  20. Project: Healer’s Journey<\/a><\/li>\n\t\t\t\t\t\t\t\t\t
  21. Project: Biota<\/a><\/li>\n\t\t\t\t\t\t\t<\/ol>\n\t\t<\/div>\n\t<\/div>\n\n

    Status: Complete<\/span>
    Type: Website<\/p>\n\n\n\n

    Bugtrakt was a project that I did as a capstone of my Associates in Science for Computer Programming and Analysis. The project given to me was to create bug tracking software complete with it’s own database solution. For this project I used a LAMP stack running on Ubuntu, which means the primary coding language was PHP while utilizing MySQL as the Database solution. <\/p>\n\n\n\n

    \"\"
    Front page of Bugtrakt.tk<\/figcaption><\/figure>\n\n\n\n

    The project itself has many moving parts. Firstly there’s users which have to log in to access their projects. They’ll see updates, tickets that they’ve been assigned to, and tickets they’ve made recently on their landing page. A part of me really wishes I had more ideas for styling these pages back then but the project was primarily to assess back end skill rather than front end.<\/p>\n\n\n\n

    \"\"
    What users see when they’re logged in.<\/figcaption><\/figure>\n\n\n\n

    Then there’s Projects which a user has to be part of to access tickets. Projects can be private which makes them only work when you invite users. Projects have their own pages for management reasons.<\/p>\n\n\n\n

    \n
    \n
    \n
      \n
    • \"\"<\/li>\n
    • \"\"<\/li>\n
    • \"\"<\/li>\n
    • \"\"<\/li>\n <\/ul>\n <\/div>\n \n <\/div>\n<\/div><\/div>\n\n\n\n

      Which then leads to the tickets which has a variety of states that are possible, such as Open, Active, Inactive, and closed. There’s also priorities and difficulties that can be used to filter and sort tickets, which is very important for productivity reasons! Below the tickets there’s even comments that can be replied to. Comment replies are all grouped together similar to how YouTube or Forum software handles comments as opposed to Reddit where every reply is nested in the parent comment. Deleting and Editing comments and tickets are both completely possible. Users can be assigned to tickets to handle the bug described in them as well.<\/p>\n\n\n\n

      \n
      \n
      \n
        \n
      • \"\"<\/li>\n
      • \"\"<\/li>\n
      • \"\"<\/li>\n <\/ul>\n <\/div>\n \n <\/div>\n<\/div><\/div>\n\n\n\n

        Sadly, the live version of the project doesn’t work properly anymore. It’s been years since I worked with it, and for the most part my on hand knowledge of PHP is a little rusty since I primarily use it for convenience when making primarily HTML sites, so I won’t be updating it anytime soon for demonstration purposes. The version running on my development server (WAMP64) works fine, so there’s a few possibilities as to why, but it likely comes down to differences in versions of PHP, and the use of SSL changing how some server behaviors work, but you’re welcome to still visit it. If you want to see the backbone I didn’t restrict the bug tracker exclusively to logged in users so you can view it at bugtrakt.tk\/tracker\/ and browse around. You can even comment while not logged in which is a pretty big oversight! The same goes for projects but not tickets, so you can weirdly have projects that belong to nobody. <\/p>\n\n\n\n

        \"\"
        A project created by “No one” (which I error handle my username resolver to) Spooky!<\/figcaption><\/figure>\n\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        Bugtrakt was a project that I did as a capstone of my Associates in Science for Computer Programming and Analysis. The project given to me was to create bug tracking software…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,33,8,32],"tags":[30,15,31],"post_series":[53],"class_list":["post-208","post","type-post","status-publish","format-standard","hentry","category-coding","category-php","category-project","category-website","tag-php","tag-project","tag-website","post_series-project-overviews"],"_links":{"self":[{"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/posts\/208","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=208"}],"version-history":[{"count":4,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/posts\/208\/revisions"}],"predecessor-version":[{"id":233,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/posts\/208\/revisions\/233"}],"wp:attachment":[{"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=208"},{"taxonomy":"post_series","embeddable":true,"href":"https:\/\/trewest.dev\/blog\/index.php\/wp-json\/wp\/v2\/post_series?post=208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}