Peruttu

whmcs module to upload bank xls

---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 [url removed, login to view]

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 ([url removed, login to view]:Add_Invoice_Payment) or select to add credit to the customer ([url removed, login to view]: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 [url removed, login to view] with css table like [url removed, login to view]

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 [url removed, login to view]:Add_Invoice_Payment

option customer-- add the payment to a customer like credit ->> see [url removed, login to view]: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.

Taidot: CSS, PHP, tietojärjestelmäarkkitehtuuri, WHMCS

Näytä lisää: us bank com, us bank, paid to edit, customers bank, credit one bank, xls, option to accept, install whmcs, features of the module, bank, Bank of, whmcs addon invoice, html css module, css module, html table css fix, table css add, addon develop, edit mysql rows php, css board, invoices html, html whmcs, php mysql bank, read xls mysql, fix menu using css html, whmcs mysql export

Tietoa työnantajasta:
( 13 arvostelua ) Buenos aires, Argentina

Projektin tunnus: #4263431

1 freelanceria on tarjonnut keskimäärin 350 $ tähän työhön

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

350 $ USD 5 päivässä
(220 arvostelua)
7.7