My US Projects

[Brandin]

Hello!

I ask for a lot of help and do my best to help out, so here is my projects built off of US:

I designed a templates page for the company I work for as we handle Customer Service inquiries via phone, chat and email. The chats and email templates were in word documents before, so I dumped them into a DB and made it into the original templates page, way back when, which had a lot of security vulnerabilities and used mySQLi integration instead of PDO. I finally converted it here about 3 weeks ago to this:
http://screencloud.net/v/qJQlf

That is the landing page which has public "headers" and private ones which are assigned by permission level.

You can get to this page by having an existing session which lasts for 7 days or you hit the landing page:
http://screencloud.net/v/bOkZC

Guest access redirects you to the index page with a ?marker=YOURNAMEHERE value, or you can register which I try to prompt users to do. The landing page uses modals for the guest, login and register forms to avoid redirects.

As always I structure my permissions by extra pages or permissions, no 2 levels have access to the same pages. Everyone has the CSR level and the remainder have permissions as required:
http://screencloud.net/v/Euuqn

I added a stats section to my admin page to keep track of common variables I store in my logs table:
http://screencloud.net/v/23wyq

And my "New Settings" section from admin_panels.php in the includes to accommodate for changes I made to the system:
http://screencloud.net/v/CPDFy

My Manager pages are done with Tiles:
http://screencloud.net/v/AGB8v

I use these sections to manage templates, requests, crons logs and user templates.

In my templates manager I integrated an inline editor include auto-open next field which is used for sort editing only:
http://screencloud.net/v/zEPJ6

My Request Manager handles templates addition, edit and removal requests:
http://screencloud.net/v/p18Pk

When you use the function button on this screen you can see the details on the request:
http://screencloud.net/v/CLgdt

We have my system logs page which can be filtered by User Modal or by Data Type Modal:
http://screencloud.net/v/pcVCE
http://screencloud.net/v/58BHC
http://screencloud.net/v/aSL0g

The Data Type only includes data that is excluded from the logs as they are in large quantities (copies, tabs, etc - these are used for reporting purposes).

We then have my recently created cron manager:
http://screencloud.net/v/bdDEz

I setup cron files and the cron.php file runs daily at 4am local time which pulls from the db to include the appropriate files. This page allows me to disable crons for manual run only, remove them, edit the information, etc. This is great so I don't have to manually edit the cron file everytime.

And last but not least, I have my user_templates manager which users can add, edit, and remove their OWN templates in their own header that only they have access to and other users cannot see. They can enable or disable this header on their templates page. This is great for the users who do extra tasks that others do not, and for those who want to modify part of the templates but is not an edit every user wants.

Then we have my reports tiles which are designed off of tables and chart.js charts:
http://screencloud.net/v/fhNEc

This gives me crazy insights on my system including hourly, daily, weekly and monthly reports, user reports and many other awesome insights that I expand daily.

I will post my other US project tomorrow when I get back to my desk since my shift is over lol!

Thanks again @mudmin / @Dan for this awesome system to work with!

[mudmin]

This is great! Thanks for sharing

[Brandin]

@Mudmin - you're most welcome! Thank you for providing such an awesome piece of software!

Here is my other US Project! This was the first system I built off of US!

This is the system I call "BOSS". This system keeps track of call center stats for our agents. Agents record calls, orders and followups in BOSS. The dashboard is controlled by agents opening and closing their shifts or "days". If you do not have a day open, you are unable to post any information. Below your stats are kept, which auto refresh every time you post a value using Javascript. There is also the alert box in the top right which actively displays in blue and if there is a pending item in the appropriate section, it turns red.
http://screencloud.net/v/C7vr1

We have our day tasks menu which opens/closes and reopens days, handles working rates, daily stats, logouts and your day tasks which allows you to review orders and mark days as completed (30 and 60 day followups).
http://screencloud.net/v/nEwqp

We have our Order Tasks menu which handles the orders report and order review, as well as general and monthly followups. This menu also has the weekly and monthly stats, but these are disabled in the admin panel as they are actively being worked on.
http://screencloud.net/v/aGMce

We have our Database Menu which has the Database Management to manage records for your user, the legacy db tasks integrity check and logs which can be viewed by users, and then our system and database manager menus, cron manager, system manager, vendor and external management, and reports.
http://screencloud.net/v/xDkjA

My cron system looks for bad backorders, orders that have a backordered date in the database but aren't actually backordered, our unassigned followups, orders and pages, that have no user_id value in the DB, or a value of 0. This can sometimes happen if the session timed out but the Javascript still processed. We have our MUID which checks the remainder of the tables for missing or 0 values in user_id columns, the legacy RDU manager which removes items for deleted users, I was doing this because of the "undefined offset" but I since migrated to the echo user function which does not produce this error. The Upper Call Cron which changes all calls in the database to be in UPPERCASE LETTERS to ensure compatibility with internal databases. We also have our Strike Dev cron which strikes the log DB of all records for the "Dev" user ID (24 in this case) so it does not clog up my logs table.
http://screencloud.net/v/8nkdy

We have our Language Records Manager where I took all of the records from the languages file in US and put them in the DB, and use this system to add, remove and edit language files, this way I do not have to code the file every time I want to add one.
http://screencloud.net/v/lg1db

We also have our External Manager which was used for the legacy version of the Templates System and is currently used for the telephone and postal database which I designed, and the requests for those. I will be migrating those out of BOSS shortly and into their own platforms!

Then we have the Main Menu where I moved the common admin functions, user manager, user permissions, system pages and the dashboard. We also have the "Manager" sub-dropdown which is used for the Database Manager of all users, the Integrity check for all users, and the Logs for all users. And of course, the Pizza Monday Manager as every week we have pizza monday, and I control this from UserSpice!
http://screencloud.net/v/itWPA

Digging in to the Manager section, which is the same for users, except their query has the user_id = ? value, this is our general database manager screen. The Manager or User can use this to remove orders, calls, dates and followups. It shows 10 values, and if the query brings more than 10 values, shows the view more button which brings you to the pagenation page for each tab.
http://screencloud.net/v/qr6r7

We have our Integrity Check which handles Duplicate Orders (if the agent put in the same order twice), duplicate dates (opened twice by mistake - doesn't happen often but can) and blank orders or calls.
http://screencloud.net/v/DU9Ri

And then of course our system logs which can be selected by date or "Visit" (which is hidden from the general logs - tracks every page a user visits):
http://screencloud.net/v/mtlqr

We have the user account page which I changed to remove a lot of the old information that was not needed and added my system settings. Users can disable any portion of the BOSS system as they desire here, and if a system is disabled from the admin panel for the entire system (see week and month stats) it is disabled and cannot be modified. We have our call logging option too which allows you to select the type of logging you want to do!
http://screencloud.net/v/1xxz1

And the admin panel settings I added to control these functions:
http://screencloud.net/v/5OP6b

Hope you enjoyed the walkthrough!

[mudmin]

This one looks sweet too!

[Brandin]

Thank you! My Trello is filled up with future developments for them, so as I update, I will post here!!! So happy I found UserSpice many moons ago and began using it! It brings such life to projects and it is so easy to use!!!

[mudmin]

I love trello!

Yeah, there are times I don't need 1/100th of the features of userspice, but it's such a quick way to get everything setup to start a project.

[Brandin]

It's great! I love it mainly because it is easy to use, I don't have to worry about managing the platform itself, and I can get to if from anywhere, work, home, vacation, etc! It's pretty full lol:
http://screencloud.net/v/8KOi4

And I don't utilize all of the features, but definitely most of them, and the possibilities are endless with the built in functions! It makes it so easy! Can't wait to help out with the future of US!

[mudmin]

Nice!