Ditutup

Brightpearl API integration + php database - repost

We have a client who uses Brightpearl as their CRM and accounts package. ([url removed, login to view]). They use it to manage their customers, and all their invoices.

Brightpearl does not have a facility to send automatic invoices on a regular basis. Our client needs to be able to automatically send invoices to clients on a monthly, quarterly or yearly basis.

We would like to build:-

1) A web based database to log a list of automated invoices that need to be created

2) A script which will use the BrightPearl API ([url removed, login to view]) to create and send the invoices based on information in the web based database we build

So we would like to build a solution based on the following spec:-

Web based database (php / mySQL)

============================

Here is an example of the database structure:-

tblAutomatedInvoices

- nAutomatedInvoice_ID - primary key

- nClientID (the client ID in BrightPearl)

- sClientName (the name of the client - taken from Brightpearl)

- sDescription (description of the project being invoiced for)

- sFrequency (monthly, quarterly, six monthly or yearly)

- nAmount (the amount to invoice the customer)

- sCurrency (the 3 digit currency code - eg USD, GBP, EUR etc)

- nNextInvoiceDate (the date of the next invoice - date in YYYYMMDD format)

- nLastInvoiceDate (date last invoice was sent - if applicable - date in YYYYMMDD format)

- bChargeVAT (bit field - charge vat - yes/no)

- sEmail (email address for invoice to be sent to)

tblAutomatedInvoiceLog

- nAutomatedInvoiceLog_ID (primary key)

- nAutomatedInvoice_ID (foreign key)

- nDate (date in YYYYMMDD format)

- sTime (time in HH:MM:SS format)

- sFrequency (from tblAutomatedInvoices)

- nAmount (from tblAutomatedInvoices)

- sCurrency (from tblAutomatedInvoices)

- bChargeVAT (from tblAutomatedInvoices)

- sEmail (from tblAutomatedInvoices)

The web based database will allow you to:-

1) Add records to tblAutomatedInvoices (with facility to select which customer from BrightPearl using API)

2) Edit records

3) Remove records

4) View a log of invoices created (from tblAutomatedInvoiceLog)

Python or php script

==================

This script can be written in either python or php. It will be scheduled as a cron job on a daily basis.

It will:-

1) Check tblAutomatedInvoices to see if there are any invoices that need to be created today (by finding records where nNextInvoiceDate is today)

2) For each matching record that is found it will:-

a) Use the BrightPearl API to create the invoice

b) Download the invoice information and save in a PDF

c) Email the customer with the invoice

d) Insert a record in tblAutomatedInvoiceLog

e) Update nLastInvoiceDate in tblAutomatedInvoices to the current date

f) Update nNextInvoiceDate in tblAutomatedInvoices to the date when the next invoice should be sent

Kemahiran: MySQL, PHP, Kejuruteraan Perisian

Lihat lebih lanjut: brightpearl database, web developer php job description, web developer job spec, web developer hh, web crm developer, software developer spec, software developer job description, php web developer job description, php software download, php developer pdf, php developer job spec, php developer foreign, need a python code that does, mysql architecture pdf, latest need for php developer, job description need for php developer, finding job as web developer, finding a job as a web developer, e-currency script, e currency script, download mysql developer, developer in php code insert, customer database php mysql, crm developer list, crm developer job description

Tentang Majikan:
( 5 ulasan ) Beckenham, United Kingdom

ID Projek: #4068099

21 pekerja bebas membida secara purata £518 untuk pekerjaan ini

toinnisfree

pls chk pmb

£630 GBP dalam 7 hari
(534 Ulasan)
7.9
USAGraphicPR0

********************************************.. YOUR SEARCH ENDS HERE .. ********************************************** GET IT DONE RIGHT THE FIRST TIME! Hello Sir/Ma'am, I look forward to talking to you further and get Lagi

£1000 GBP dalam 8 hari
(33 Ulasan)
7.2
ithinksolutions

Thanks for inviting us to bid on this project. We have a team of highly qualified and creative professionals. Give us a chance to show our talents and we assure you quality.

£600 GBP dalam 7 hari
(72 Ulasan)
7.1
srinichal

Looking forward to discuss further details in terms of design aspects

£620 GBP dalam 18 hari
(91 Ulasan)
7.0
kernelbd

Ready to start. Highly interested. Thanks.

£600 GBP dalam 8 hari
(81 Ulasan)
6.2
ashwanii

Hi, I can provide the required solution. Regards.

£400 GBP dalam 5 hari
(18 Ulasan)
5.9
Ajcm623

hello i can help your sir let's start

£600 GBP dalam 20 hari
(43 Ulasan)
5.8
auriclesoft09

Dear Sir, Expertise in Open Source/CRM/ERP/POS/Custom Solutions/Web designing. We do customization as per your requirements. ! With a good Profile in Freelancer and experience of over seven years in the Software Aren Lagi

£510 GBP dalam 22 hari
(20 Ulasan)
5.6
ehsanx

I can do it.

£350 GBP dalam 10 hari
(43 Ulasan)
5.5
softwarevamp

Hello, i can do this in a timely, accurate and professional manner look to work with you At your disposal for any query. Regards softwarevamp

£650 GBP dalam 30 hari
(25 Ulasan)
4.8
mmadi

hey please check PMB

£400 GBP dalam 10 hari
(7 Ulasan)
4.5
TechOnWrox

hi sir, I m ready to start.

£500 GBP dalam 5 hari
(12 Ulasan)
4.1
sonikunal

HI, This is very simple task. we can deliver you the results on time.

£300 GBP dalam 2 hari
(4 Ulasan)
3.9
tradepuli

Let's get cracking on this job. Expect quality work.

£550 GBP dalam 15 hari
(14 Ulasan)
3.8
xautoit

Hello. I can start right now

£250 GBP dalam 7 hari
(6 Ulasan)
3.8
amin6106

I have read your requirement, i have over 6+ years of experience in php, mysql, css, looking forward to work with you.

£250 GBP dalam 10 hari
(5 Ulasan)
3.6
trotinarius

I can deliver the solution in php&mysql quite quickly. Kindly check private message. Thank you

£275 GBP dalam 3 hari
(4 Ulasan)
3.0
veltrod

Dear Sir, Veltrod Technologies is a global software consulting company specialized in providing Mobile applications, Social media frameworks and eCommerce solutions. Leveraging best-in-class people, processes, and t Lagi

£700 GBP dalam 25 hari
(2 Ulasan)
0.7
customvivvo

Hello, I'm interested to build it for u, it may take 7-10 days to be implemented as you specified above.

£750 GBP dalam 7 hari
(0 Ulasan)
0.0
ravishakya

Hi, I have 7+ year of working experience on Web/Database applications using variety of technologies such as PHP, MySQL, Java, SQLServer etc. I am confident I would be able to complete your task on time and meeting the Lagi

£500 GBP dalam 14 hari
(0 Ulasan)
0.0