Create Billing Portal

- 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.