Find Jobs
Hire Freelancers

Correct / Resolve SQL Lookup in PHP Web Application

$15-25 USD / hour

Cancelado
Publicado há aproximadamente 5 anos

$15-25 USD / hour

We have a small, local php web application that lookups phone numbers in our CRM and returns them to our phone system which alters the callerID to show if a client, new client, vendor, etc. is calling. The CRM recently changed the data structure which broke the SQL lookup. We need the attached SQL query and output changed to reflect these changes. The SQL statement is attached. The CRM data dictionary/reference is thorough and will be provided to whoever is awarded the project. Please ask questions prior to bidding on the project. We are budgeting a TOTAL of 6 hours for this project which should be more than enough time to reconfigure the SQL query to reflect the updated data structure.
ID do Projeto: 18759133

Sobre o projeto

35 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi! All questions would have been pertinent to the new database schema on teh CRM side, but you said that would be unavailable at this time, at least not for everybody bidding. In any event, I don't think it would require more than couple hours - to get familiar with those database functions in [login to view URL] and [login to view URL], just to make sure not to break anything, and with the new schema and what you'd be wanting pulled from there(you said teh output would change too), and to plan and do the actual modding. And then the 3rd hour is for testing and debugging/problem rectifying etc. on the modded code(because we don't have neither side of this communication and data to test locally, and it's not even worthed to set it up locally only so it can be tested anyway. Kind Regards, Dobri
$15 USD em 3 dias
4,9 (178 avaliações)
6,2
6,2
35 freelancers estão ofertando em média $20 USD/hora for esse trabalho
Avatar do Usuário
Hello, I'll need CPanel and admin access to the CRM. I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1150 projects from a period of 12 years. Thanks. I look forward to hearing from you Best Regards, Rajesh Soni.
$27 USD em 5 dias
4,9 (1068 avaliações)
8,9
8,9
Avatar do Usuário
Hello Sir/ Mam, My name is Neha from “Hire Wordpress Experts”. We are the team of 18+ employees and over past 10 years. We read through the project details extremely carefully and absolutely sure that we can do the project very well. We build your small, local php web application that lookups phone numbers in your CRM and return them to your phone system and according to your need attached SQL query to reflect the output changes. Thank you to share the txt file. We can achieve the results that you are asking for. Kindly review our profile and past work here: https://www.freelancer.com/u/OutsourceMan We would appreciate working with you. We are “waiting humbly and patiently”. Thank you Neha
$16 USD em 40 dias
4,9 (571 avaliações)
8,9
8,9
Avatar do Usuário
Hello, Full Stack Expert development team is ready to serve you. Please check my profile and message me for more details. Thanks
$35 USD em 40 dias
5,0 (205 avaliações)
8,7
8,7
Avatar do Usuário
Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you as PHP/MySQL programmer to research new CRM database structure and rewrite old code to Lookup phone properly. Yes, 6 hours is enough. 2000+ successfully completed projects speak for me. Links and reviews from my past clients available in my profile. I am an individual, I am not a company in any meaning. I need FTP access to start right now. I can communicate via Freelancer.com. -- Sergey aka Takereal
$25 USD em 6 dias
5,0 (2084 avaliações)
8,3
8,3
Avatar do Usuário
Hello there, Myself having has 10 + years experience of web site development. Expert in Custom programming in php / Mysql / Codeigniter/ Laravel/ Prestashop/ Drupal/ Jquery / Wordpress/ Joomla / OSC / Magento /OpenCart / Android / Mobile development / Responsive. Ready to start the work immediately. I am confident to handle your business projects with dedication and good quality. Thanks and regards, Harpreet Singh
$16 USD em 40 dias
4,9 (318 avaliações)
7,8
7,8
Avatar do Usuário
HI its possible it could be fixed in 6 hours or less, but where is the code hosted? is there remote access? how easy would be to test? We specialize on co-located teams in South America with constant training and we aim for indefinite long term business relationships, we work by providing full time programmers, but this is project is small enough that we can quote it. Sincerely Pablo V Atlanticsoft
$25 USD em 6 dias
4,9 (207 avaliações)
8,0
8,0
Avatar do Usuário
Hi there Here is one of CRM database management experienced developer including Query optimization If you give me this project, I will complete it in a short time Please contact me with your project access. Thanks Will look forward to hearing from you soon. Best regards.
$22 USD em 40 dias
5,0 (110 avaliações)
7,4
7,4
Avatar do Usuário
Dear, client. I am Yukai, from China, a senior web developer. I have read your project description carefully and checked attached sql. In this file, there are some including files so I need to see these files, as well. I can provide you the correct result. I want to discuss via PM. Thanks.
$16 USD em 40 dias
4,9 (43 avaliações)
6,9
6,9
Avatar do Usuário
Hi, there! I am very interested in your job. I have been working as a full stack web developer for over 5 years. I am highly skilled in PHP, Mysql so I feel confident that I can do your job without fail. I can start working right now and I will guarantee the quality of code and keep the timeline as well. If you are willing to work with me, please contact me. Regards.
$22 USD em 40 dias
4,9 (96 avaliações)
7,0
7,0
Avatar do Usuário
Hi Sir, If you are looking for a PHP expert, please consider my proposal. As an expertise in PHP with more than 15 years of experience related to databases like MYSQL / ORACLE /DB2 . Past experience related to different major technology methodologies . Focus on front-end development based on AngularJS and VueJS, using Codeigniter as back-ends. I am confident that I can fix the issue successfully within the time frame. Looking forward to discuss the further details over freelancer chat. Message me to getting touch. I will wait for a positive response. Thank You
$18 USD em 20 dias
4,9 (56 avaliações)
5,8
5,8
Avatar do Usuário
Hello there i can do the fix you want please contact me im available now
$20 USD em 6 dias
4,8 (82 avaliações)
5,5
5,5
Avatar do Usuário
Hi, I am full stack web developer working more than 2.5+ years on commercial projects. I have skills in php, mysql, postgresql, sqlite. I looked to your code, but for fixing an error it will be good to look what error your server returns in apache/nginx log files on your server that understand what exactly is wrong after CRM changes.
$25 USD em 6 dias
5,0 (8 avaliações)
5,4
5,4
Avatar do Usuário
I am interested to apply for the Remote Full Stack Web Developer position. My background as a Full Stack Web Developer, along with my engineering education degree in Information Technology has made me attain some excellent technical skills. Following are my skills in which I am expertise * PHP 7, Advanced PHP (OOPs) * Laravel 5.5 REST API * AngularJS * HTML5 * CSS3 * JavaScript/Jquery, JSON, AJAX * Payment gateways Integration In addition to my Web Development skills, I also have a great eye for design. I have 6 years of experience with these technologies. I am always happy to learn even more new concepts in these technologies to sharpen my skillets whenever I get the chance. Besides, I do have a passion for mobile technologies as well. I also worked on a few responsive websites with the usage of Bootstrap and Media Queries. You'd also be delighted to know that I have acquired the Information Technology extensive education, that's why I'm confident that I can be a great asset to your organization. I am willing to work for 40 hours per week to help you with your project.
$25 USD em 40 dias
5,0 (7 avaliações)
4,4
4,4
Avatar do Usuário
hi, I have 20+ years experience on java,web,db tech. Your specs are quite clear, and it should be quite easy. Can do it for 20$. regards, manoj
$15 USD em 40 dias
5,0 (5 avaliações)
4,1
4,1
Avatar do Usuário
Hi. I have 6 +years of experience in IT Sector working with Database especially writing Sql queries. I have seen your project requirements and I am sure I would be able to complete this project as required in the given time frame with maximum efficiency.
$16 USD em 10 dias
5,0 (6 avaliações)
3,3
3,3
Avatar do Usuário
This should be an easy task to complete. I have 12+ years experience in sql. This is my first freelancer job, so I really hope I can get this one.
$22 USD em 10 dias
0,0 (1 avaliação)
0,0
0,0
Avatar do Usuário
Buenas tardes, para este proyecto entiendo que lo que necesitan es adaptar el script de la consulta para que retorne los datos que se requieren. Puedo colaborarles con esto.
$22 USD em 6 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I do have knowledge of Front End and Back End using PHP and database SQL. I ca rewrite the query as per your requirement.
$22 USD em 40 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
UPD: today i am able to run your SQL queries $crm_customer_sql and $crm_vendor_sql on MySQL DB, with only minor modifications to the original SQL code to achive this i create Tables simulating the tables of your CRM including links between tables via ForeignKeys, for example Contacts.Company_ID is a foreign key points to Company.Company_ID. And fill each table with several rows of dummy data now i am ready to receive the Information about new CRM table(s) and fields structure ------ day before: I am looking thru your PHP code, especially SQL statements and now i have a draft of tables and table fields in your CRM database the script has been designed to work with i prefer one-time payment, not per hour
$16 USD em 6 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am a good listener, who succeeds in learning new things. A very sociable colleague who can easily help, skills acquired in volunteering. Due to the intuition and the spirit of observation, I can troubleshoot and overcome most of the problems encountered.
$16 USD em 40 dias
0,0 (1 avaliação)
0,0
0,0

Sobre o cliente

Bandeira do(a) UNITED STATES
New York, United States
5,0
11
Método de pagamento verificado
Membro desde dez. 8, 2008

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.