- Add Login Process
- Use theme here : [login to view URL]
- Database structure attached (PDF)
- You get access to a full development area
Section 1 (table client, ddi_assignement, product_assignement, status)
Client
- Create Client (two buttons «save» + «save & add product»)
Add Product function :
- Select Products (unlimited).
- Enter planed date for activation (no function)
- Add phone numbers and save after add to database ddi_assignement
- Add OTO ID Text
SAVE -> go to pending order for this product -> show a button „pdf details“ to download a pdf with all details of this order (client details, product details, …) with our template.
List Clients
- Modify Client
- Add Product
- List Client Invoices with edit for all lines
- List Client Products with modification for all fields possibility
################################
Section 2 (table product)
Products
- Create Product
- Modify Product
################################
Section 3
Order handling
- List pending products (with client details) -> show a button „pdf details“ to download a pdf with all details of this order (client details, product details, …) with our template.
- Click on edit product -> modify all details -> button «save» + «cancel order» + «save & active» -> ACTIVE Status for product
- List active products (with client details)
- List suspended products (with client details)
- List terminated products (with client details)
################################
Section 4
Billing
- Start billing to date 01/01/1900 selector -> generate invoice for all products add setup invoices and calculate the callingfees with table tblcdr_billing for each client. Each client gets 1 invoice including all setup fees, monthly fees and calling fees.
Calling fees generation : tblcdr_billing -> calculate for all not billed lines the price and add in this table the invoice number, the billing date and the status billing_ok « OK ».
Example :
If product 1 is pa_activation_date and monthly billing 01.10.2015 -> create invoice line 1 for period 01.10.2015-31.10.2015, add for product 2 (setup) a line 2 with the setup fee, calculate the callingfees and add this to line 3.
################################
Section 5
PDF Batch
Download all (invoice + reminder 1, 2, 3) from date to date -> download all invoices
Invoice -> Enter Date from to -> Download all invoices
Reminder 1 -> Enter Date from to -> Download all invoices
Reminder 2 -> Enter Date from to -> Download all invoices
Reminder 3 -> Enter Date from to -> Download all invoices
################################
Section 6
CDR Handling
- Import CDR to database with validator no double entries in the database add importdate to db
- Button Progress import to fill tblcdr_billing with the factor from tblcdrmargin with the data of tblcdr. Validator for no double entries in the import progress.
Hello,
I am a Developer with good knowledge in WordPress, PHP, Software Architecture JavaScript, jQuery, HTML5, CSS3 and Responsive.
I have gone through the project description and would like to talk to you once to understand more.
There would be no problem with my tempting for this project as I have a great deal of proficiency in this aspect of the program. It is also possible for me to translate designs and I have a good understanding of usability and appreciation for a good user experience.
Please check my profile review for your ready reference: https://www.freelancer.com/u/akash9958.html
Looking forward to hearing from you.
Thanks
Akash Singh
Hi,
Php/mysql expert here with 3 years of experience in web development. I have vast experience in development. I have seen the requirement and confident enough to achieve this very easily.
Please Let me know if you are interested
Thanks,
HIgh Experience in website development, Team of five members are involving to share all our knowledges and efforts to deliver the project on time and in expected quality.