Program to check duplicate leads in Leadsquared

Hi,

We need a program built that downloads leads form Leadsquared using their GET API.

It will store the leads in a Local Microsoft SQL Server Database. The program will need a button that we press and it will download the leads. It only needs to download 12 fields.

It will then need the ability to check the Local DB for duplicates on the following combination of fields:

1. Contact Preferred Name

2. Contact Surname

3. Contact Enquiry ID

4. Contact Community ID

5. Contact Previous Surname

6. Contact Maiden Name

7. Phone Number

8. Contact Mobile Phone Number

9. Contact Address Full

10. Contact Address 1

11. Contact Suburb

12. Contact Postcode

By default all are selected on page load. When pressing search the local of the query is as follows:

SELECT All Records

FROM LocalDB

WHERE

SELECT COUNT Contact Preferred Name Having > 1

AND

SELECT COUNT Contact Surname Having > 1

AND

SELECT COUNT Contact Enquiry ID Having > 1

AND

SELECT COUNT Contact Community ID Having > 1

AND

SELECT COUNT Contact Previous Surname Having > 1

AND

SELECT COUNT Contact Maiden Name Having > 1

AND

SELECT COUNT Phone Number Having > 1

AND

SELECT COUNT Contact Mobile Phone Number Having > 1

AND

SELECT COUNT Contact Address Full Having > 1

AND

SELECT COUNT Contact Address 1 Having > 1

AND

SELECT COUNT Contact Suburb Having > 1

AND

SELECT COUNT Contact Postcode Having > 1

It will result in a list of leads having an exact match for all 12 fields.

It also needs to allow for the fields to be unticked in any combination. For example all are unticked except for:

1. Contact Preferred Name

2. Contact Surname

The query logic will then be:

SELECT All Records

FROM LocalDB

WHERE

SELECT COUNT Contact Preferred Name Having > 1

AND

SELECT COUNT Contact Surname Having > 1

And this will result in a list of all leads with the same First and Last name.

See attached diagram.

Thank you,

Project 2:

I have a problem with the Send Leads API program because the query takes a long time.

When click on 'Send Leads' button it does this:

CURRENT -

'Send Leads' clicked
Sends leads from View query

can you update it to do the following?:

CHANGE to -

'Send Leads' clicked
Runs a stored procedure on SQL Server
Store procedure writes view query data into temp table (you will need to make the stored procedure)
Once complete it Sends leads from temp table

PHP SQL

Project ID: #10547244

About the project