Step Description:
1. Get all the data of CustomerTEST.customer_code first, and name it as list of all customer.
2. input the information into interval od date & register in SalesLedgerTEST, and filter out the list of customers who have consumption.
3. Use “list of all customer” to remove the list of customers who have consumption. Then get the list of customer who have not consumption.
4. Total amount of Consumption during interval of date in other register: Use total amount of consumption in interval of date which we input minus total amount of consumption in register which we select (get the SalesLedgerTEST.LineType==”Sale” of [login to view URL] as total amount of consumption)
I am the professional PHP and MYSQL developer with lots of experiences.
Reading your job description, I felt that I am an enough qualified candidate to take this job on.
Please contact me to get the smart result you want.
Regards.
Hello There ,
I have 4.5 years of experience in PHP. I gone through the definition and the sql and doc attached here .I have done such works many times . I can share my experience in chat .I can start now and can complete this task as your requirement . Would like to do this project. Looking forward for your revert.
Thank you
Shrushti P.
Hi, I have 9 years of experience on php and MySQL. I gone through your job details and I am confident to complete your job successfully.
So, kindly initiate a chat for the further discussion. I am ready to start work immediatly.
Thanks,
Nitin M.
Hello Pal,
What I understand from you project description you want to fetch data from database with specific data range with different register type. You have three different type of register in you db table.
I can start this project right now and finish it ASAP. thanks