Skip to content
Snippets Groups Projects
  1. Mar 25, 2014
  2. Feb 07, 2014
  3. Jan 17, 2014
  4. Jan 14, 2014
  5. Jan 10, 2014
  6. Dec 31, 2013
    • Jared Hancock's avatar
      perf: Use a materialized view to speed queue views · 1bc05945
      Jared Hancock authored
      This patch introduces an automatic materialized view to speed database
      performance when querying and displaying the ticket views. This can
      eventually be extended to the search and advanced search features to speed
      them as well.
      
      The data from the dynamic form entries related to ticket details is copied
      to a %ticket__cdata table. The %ticket__cdata table is then joined directly
      to the other tables in the query for the ticket view. MySQL is magically
      and dramatically faster using this method.
      
      The downside is that the disk usage for the custom data is doubled, and the
      time needed to update the dynamic data is at least doubled as the form
      entries and the materialized view must both be updated.
      
      This method should also extend well to other database platforms in the
      future. It will be likely that most other database query optimizers will
      have difficulty joining, scanning, and sorting the table models we have for
      custom data fields.
      1bc05945
  7. Dec 23, 2013
  8. Dec 17, 2013
  9. Dec 11, 2013
  10. Nov 27, 2013
  11. Nov 26, 2013
  12. Nov 25, 2013
  13. Nov 21, 2013
  14. Nov 20, 2013
  15. Nov 13, 2013
  16. Nov 08, 2013
  17. Nov 07, 2013
  18. Nov 05, 2013
  19. Nov 04, 2013
  20. Oct 29, 2013
    • Jared Hancock's avatar
      Allow both internal and required fields · 81bcb80a
      Jared Hancock authored
      Previously, clients would not be able to create tickets if an internal,
      required field existed on any of the forms presented to the user. Instead,
      they would be stuck at permanent validation failure because there was no
      data for a required field not shown.
      
      This patch adds a feature to the form and dynamicFormEntry objects'
      isValid() method to receive a callable to filter which fields' errors should
      be added to the form's errors list. This allows for more complex validation
      where in some cases, validation errors should not be considered on some
      fields.
      
      Fixes #45
      81bcb80a
  21. Oct 28, 2013
    • Jared Hancock's avatar
      Use seemingly-random form input names · 4b62e47a
      Jared Hancock authored
      Which will help fight off spammers. This should be coupled with logic that
      will add some enticing fields, like 'email' and 'name' to invite bot input.
      Then, on the form processing side, a spam submission can be detected and
      handled differently from human submissions. This should lessen reliance on
      CAPTCHA only as spam detection.
      4b62e47a
  22. Oct 22, 2013
  23. Oct 14, 2013
  24. Oct 09, 2013
    • Jared Hancock's avatar
      Rebase onto feature/html-thread · 9e4e35d7
      Jared Hancock authored
      9e4e35d7
    • Jared Hancock's avatar
      f7384359
    • Jared Hancock's avatar
      Fixup the installer · e055cc21
      Jared Hancock authored
      Fixup several minor bugs concerning initial experience
      e055cc21
    • Jared Hancock's avatar
      Completion of dynamic forms concept · 43b74f4a
      Jared Hancock authored
      Moved to an initial form which specifies the ticket's priority and issue and
      changed the rendering to render things properly. Now the user can decide
      where priority shows on the client side, and the priority privacy setting is
      placed in the dynamic form wizard.
      
      The standard form is added to every ticket without option. Extra forms can
      be defined and associated with help topics which can additionally be added
      to tickets upon creation. This allows for standardization of the dynamic
      data location for searches and filtering.
      
      Implemented advanced search for dynamic data. Along with reinstating the
      basic ticket search on keywords
      
      Implemented ticket filtering on dynamic data for both keyword searches as
      well as searches for special fields (drop-down lists, etc.)
      
      Phone number for users is now completely optional
      43b74f4a
    • Jared Hancock's avatar
      Move client information to separate formset · 53666db6
      Jared Hancock authored
      This moves client information like name and email address out of the general
      dynamic forms data for a ticket. It really paves the way for the first-class
      user of the future.
      53666db6
Loading