whmcs module to upload bank xls

CANCELLED
Bids
1
Avg Bid (USD)
$350
Project Budget (USD)
$30 - $250

Project Description:
---Situation:
We accept bank transfer , so we export from our bank an xls , and put manually invoices as paid detecting a bank transfer from a customer, now we need to upload the xls to the whmcs and an employee to update the xls (table) adding payment manually.

---Main description: see http://prntscr.com/thgzb
A module where an admin can upload an xls from our bank with transfer details from our customers, using this xls , and need to be showed the table with css nice inside whmcs.
After that we need to update a row (payment) to an invoice (http://docs.whmcs.com/API:Add_Invoice_Payment) or select to add credit to the customer (http://docs.whmcs.com/API:Add_Credit)

When we update the row in table, (i meant after payment is added) the table will reload , and as table only will show un-updated rows, will sho

Module should look like http://prntscr.com/thgzb with css table like http://www.ajaxdaddy.com/demo-sorted-table.html

Module should install a new table module_bankxls in whmcs, with several fields, and module should be available as module addon in menu.

----Step by step for this module
1- UPLOAD (c)
user can upload a new xls , script should take only positive numbers, i meant only credits and update tbl_bankxlsmodule adding only new rows, not duplicated, leaving empty a field in mysql that will be used to detect if a payment was updated. (C)
2- SHOW ROWS (b)
after that the table with only not updated rows should appear ,and every row should have a button to edit this row see (B)
3- UPDATE ONE ROW (a)
the selected row should appear up to let me update between two options.

option invoice -- add the payment to an invoice like ->> update see http://docs.whmcs.com/API:Add_Invoice_Payment
option customer-- add the payment to a customer like credit ->> see http://docs.whmcs.com/API:Add_Credit

After update one row should update inside module_bankxls that this row was updated, and dissapear from table list (B)

About xls i attaching an example from our bank.
About module_bankxls table it should have all xls fields plus:
date updated || invoiceid || customeridcredit || admin (who put the payment) || otherfields?

Any questions use public board, DO NOT PM me please !

------------------
Payment Terms:
0 % milestone when you start
50% milestone when you show the module working as experimental
50% milestone after you fix bugs founded and features missed.
100% release when module is finished as described.
--------------------
• Only Serious whmcs experience please
• More projects will be given if this will be successful, we have houndred of whmcs customers asking us develop
• Please write [quiero hacerlo] in your bid, so that we know you read this listing information Correctly.

Skills required:
CSS, PHP, Software Architecture, WHMCS
Additional Files: xlsfrombank.xls
Hire altomarketin
Project posted by:
altomarketin Argentina
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 350
in 5 days