Sunday, December 19, 2010

Project Specifications (Private)

What is should do:

Sales Management

- record sales transactions
-> customer (primary)
-> number (primary, child, a component of customer)
-> amount
-> product code (can be left blank)
-> date made (to be filled in manually, or a checkbox if same date)
-> time sale is made (may be left blank to indicate that the sales was done only on the day specified, and no specifics on time)
-> transaction details (a textbox / comment box about special cases or details about the transaction, 1 comment box per transaction)

- record payment made
-> append as part of new transaction
-> select which transaction to pay if unpaid
-> payment (should be a separate table) (indicates independent payments, underpay and overpay, that will be reflected on the Client's Credit table (db), report or list (page))
--> amount
--> date paid
--> time payment is made (may be left blank to indicate that the sales was done only on the day specified, and no specifics on time)
--> remarks (for purposes of notes, or to indicate special cases)

Client Reports (credit & sales report can be integrated)

Credit

- shows all the clients and their credit (0 (zero) for fully paid and no outstanding balance or extra credits, - (negative) for underpaid, and + (positive) for overpaid)
-> shows per client, the total credit
-> Client
-> total credit
-> Number/s
-> credit per number

Client's Credit Report (individual)

- automatically compute for the total unpaid sales per person (per customer / per every number of customer) (important)
-> add remarks (either 1 or unlimited number of comments) for unpaid transactions (may be shown as a number indicator of how many remarks there is in a transaction. the number of remarks can be reflected on the list item which changes colors depending on the gravity or number of remarks (less than 5 - green, more than 5, less than 10 - yellow, more than 10, less than 15 orange, more than 15 - red)

Sales

- automatically compute for the total sales per person (#3) - for the purpose of determining trend, minor
- also allows viewing of transactions (all transactions (paid/unpaid)-all customer [limit number of results per page, on the settings page], all transactions (paid/unpaid)-selected customer [limit number of results per page, on the settings page])

Client Information

- allows to view client profile
-> client ID
-> client name
-> client registered number/s (and date added, status (active/inactive or disabled))
-> client total sales
-> client credit
-> list of client transactions (all)
-> list of client transactions (paid)
-> list of client transactions (not paid)
-> list of payments (indicate if paid already on the transaction time, or if on a later date)
--> view remarks per transaction
-> list notifications (views all the tagged/marked/flagged "unresolved" transactions with remarks)

- allows adding/editing/disabling of new/existing cellphone numbers

Reloading System

Load/Credit Balance Reload Notification

- reminds or send an urgent message about load credits when reaching a certain point (P50 to P100) - integrates the total payments

Record Reload Transactions

- records reload transactions and details
-> amount
-> date
-> time (optional)
-> location (optional)

View Running balance

- allows instant view of available credit, may be made persistent throughout the system
- displays a list of all transactions and the resulting Running Balance (limited results per day / week / month, or whatever range specified; limited number of results per page, settings)

View Accumulated Earnings

- this will have to be manually computed, seeing how much the payments has exceeded the recorded sales)

Tuesday, December 7, 2010

I need You back in my life

This place is familiar -- it's where I was before
Everything's becoming like the way they used to be
But I am making every effort to resist from going back, and if ever I do
I stand by the hope that this is just a cycle and things will be okay

I feel like something is missing
Like I am forgetting something I had that changed me
And I am looking in all the wrong places
Because I couldn't find the right answers to my questions and confusions

I was hoping that in time I would remember
That I knew it all along but I just couldn't recall what it was
And I know that soon enough it is going to get back to me
And I knew right because it did came back to my memory

I reasoned to myself that it was just me
That I just had to be tough, to be brave through all
Maybe it's just my friends, that I had to breakthrough
In all of it, I felt so alone

It was You, all along, who changed me
I need You back in my life, to touch me again
I may have forgotten the love that we first shared
But You never did, You just waited for me to come back again

And now I feel like I'm the Prodigal Son
I knew it before, but now it's all clearer
Even though I never thought I was, that I could do it on my own
Now I know again that I couldn't live without You

Life without You is a struggle -- it feels so alone
I have no purpose, no reason to live, and to see tomorrow
My future is bleak, I have no hope
Until you touched the sky and lit the dark for me

In Your arms is where I want to stay
May in it, please, I forever remain
I have found my way back home
And may everything be alright again today

It is with you, now I've proven, that I belong
You are my lost love, and now I've found again
My inspiration for all of my days
In you I'm content, my tomorrow's secure

I wrote something different and not too artsy tonight (ehem, morning). From the usual rhyme-y poems I write, the ones that entertain me the most, I stuck to telling a story that I really wanted to share. This has been a result of my introspection and inner reflections. I felt like I was missing something in my life, like I lost a precious ring -- my secret to success before. And, there I realized I was looking in the wrong places, that it was because I lost my love to someone, my inspiration. Now, I am craving more than ever to get back to where I belong, and stay there with contentment. Things can never be like before, yes, because they just get way better.