Jump to content
Luis

Web Application - Intranet Office suite

Recommended Posts

Table of contents

  • Introducing the App and author
  • Needs
  • First version in PHP/MySQL without any Framework
  • Why Processwire?
  • App Version 1.0

Introducing the App and author

Hi,

my name is Luis and i´m a German based Web and Frontend Developer. 

I started 2010 with my own Internetbusiness and noticed  at the very beginning of my business that it takes to much time to handle my accounting, invoices and clients.

The main problem was that I needed for almost every task his own software solution, so the usual workflow in creating an invoice was something like open the CRM Software because the invoice software was good in creating invoices but bad in managing and searching clients, copy and paste the client into invoicing, create the invoice and handle it over to the accounting software.

Not good at all...

So I decided to create my own solution to fit my needs in the office management.

Needs

  • Invoicemanagement and creation
  • Clientmanagement, very basic CRM
  • Accounting
  • Multi-User
  • Simple financial stats about the Keyfacts of my business  
  • possibility to export the data for my tax consultant
  • PHP / MySQL to work with it on intranet

After pointing out my personal needs and writing down my usual workflow I started to develop the first version.

First version in PHP/MySQL without any Framework

In winter 2011/2012 I completed the very first version of my OMS (office management suite).

momspreview4.pngmomspreview1.png

The whole project was written in good old fashioned PHP from scratch.

I´ve used this version till November 2012.

Why Processwire?

In mid 2012 I discovered Processwire and had no idea in how many ways this tool would change my life as webworker. 

After playing around with PW and developing the first little sites I had a little talk with my tax consultant, she said that my financial reports are pretty good and help to save money. (less time, smaller invoice from her)

Why not publish the tool?

Well, at this point my app was solely written for my needs, without possibilities for an Multi-User environment or for use in an companies Intranet. 

I finally decided to port the app to PW because of it´s flexibility, scalability and built-in user-roles. 

I had to dig deeper into PW at this point to see if I really could. 

Late 2012 I started porting the app in PW and was surprised how insanely fast developing could be. 

The whole database structure was ported into PW Pages, no SQL query is done by the app itself.

It was possible to recreate the core functionality in about 2 weeks, implementing the Login and Multi-User functionality took another week.

WebApp Version 1.0

https://youtu.be/PIgUMLZEcIU

The app is now available for purchase @ www.misterui.de 

* also Processwire with an own eCommerce Script

  • Like 16

Share this post


Link to post
Share on other sites

Luis, great case study. Is the software available for purchase somewhere?

Share this post


Link to post
Share on other sites

What did you use for PDFs? That was very quick to generate and open :)

Share this post


Link to post
Share on other sites

Fascinating reading and viewing Luis. A question I have after watching your 'Simple eCommerce' video. How are you handling the file downloads after the payment has been made? I only ask because I've just built a site with PW and DigitalDeliveryApp. If I could have done it all in PW I'd have been happier. -Marty

Share this post


Link to post
Share on other sites

I handle purchases this way:

I created a custom admin page which shows actual purchases.

After purchase the system sends 2 emails. One to the customer with payment information and one to me to inform me about purchase, so far so usual. 

Besides email notification the script creates a new page with customer credentials and a checkbox if paid or not. 

The custom admin page lists those purchases and provides a button to set the purchase to paid. 

When I set the purchase as paid the script generates a new page for the customer which contains the actual file and sends a mail to the customer with the link to this site inside. 

After two weeks the generated customer page will be deleted.

Thats it. 

Share this post


Link to post
Share on other sites

Luis, this is fantastic - thanks for sharing! It's great to see another Case Study on here and one that really shows the power and flexibility of PW in the right hands.

Share this post


Link to post
Share on other sites

Greetings Luis,

Excellent work! I hope lots of people purchase it!

This is a great inspiration to anyone working on building various applications with ProcessWire.

Thanks,

Matthew

  • Like 1

Share this post


Link to post
Share on other sites

I´m sorry, no english version :)

The problem is that too many things are related to the german law. 

Share this post


Link to post
Share on other sites

If that little app impresses you so much, I can´t imagine what my next project will do with you :D  

  • Like 2

Share this post


Link to post
Share on other sites

Luis, you did it again. You're not only a skilled coder but also a source of inspiration for processwire projects.

Why is the youtube video without sound ? Makes it more difficult to follow.

Share this post


Link to post
Share on other sites

Because i'm a lazy boy :) well and i'm not such a good actor like Ryan

  • Like 1

Share this post


Link to post
Share on other sites

Because i'm a lazy boy :) well and i'm not such a good actor like Ryan

I think I should start giving lessons on how to do voice overs.

Ryan is better than most techies. but you could all learn from a few simple tricks:

WRITE A BLOODY SCRIPT AND STICK TO IT!!!!!

Oh, and do it in sections - NEVER EVER try and do it all in one go. There are plenty of free editors that are pefectly good for editing things together.

Think I will go and write a post somewhere....

Share this post


Link to post
Share on other sites

I like doing it all in one go Joss and having "umms" and "errrs" in there - pads it out a bit :)

Love the app Luis and thanks for pointing me to that PDF class. I have been using a different one that I got to work and had even checked out this one before a few years back but when I looked at it recently it mangled my HTML - turns out they all have their quirks and now I've spent today getting my templates nice in this one it means my ~450kb PDF files that take 5 seconds to generate are now ~45kb and generate almost instantly :D

  • Like 1

Share this post


Link to post
Share on other sites

Congrats Luis, would have loved to help even more with testing but the year started to busy. Wish you much success.

Share this post


Link to post
Share on other sites

OK, you've inspired me, I'm going to start trying to build our own version of this for our needs. I like the idea of having exactly what we need for our company and only that. As great as Billings is I still find myself doing most things by hand in Excel.

Also I'm sure it will be a great learning curve.

Share this post


Link to post
Share on other sites

Luis, the app looks really great! 

Is it possible to add parameters to the product which are influencing the price? This could be the size/area of some products (e.g. craftsman) or i'm specifically thinking about the german Steuerberatergebührenverordnung, which needs a difficulty level (from 1 to 20) and a value (income or profit in Euro), whereof a table is used to calculate the charge. 

If it is not yet possible, can i develop it myself? You could be using the code afterwards yourself.

Share this post


Link to post
Share on other sites

you mean something like $price * ($variable) e.g. 19,95 € * 1.1 ?

Nope, something is not implemented. 

I'm working with different prices on same products, like Coding - Hard = 500€ and Coding - Easy = 250€

Share this post


Link to post
Share on other sites

you mean something like $price * ($variable) e.g. 19,95 € * 1.1 ?

Nope, something is not implemented. 

I'm working with different prices on same products, like Coding - Hard = 500€ and Coding - Easy = 250€

yes, something like this, that the same product can have a different price depending on the specific product properties.

Do you think about implementing it or is it our of your scope?

Share this post


Link to post
Share on other sites

This sounds like a good idea. 

Will put your suggestion on my roadmap. But please don´t expect Version 1.1 soon. Never been busier before.I didn´t even find time to update my modules. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...