Php sql query filter jobs

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

...looking for a skilled developer to add a small module to my existing app built with PHP. The main functionality of the module will be user registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration system...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

I'm looking for a skilled developer to create a user-friendly platform that will serve as a comprehensive search tool for ...skills for this job include: The ideal candidate should have relevant experience with frontend and backend development, a solid understanding of React.js, Java, PostgreSQL and an eye for UI/UX designing. - Proficiency in web development, particularly in creating user-friendly interfaces. - Experience with database management and system design. - Ability to integrate a search mechanism that can filter dormitories based on the desired criteria. - Knowledge of security protocols, as sensitive information will be handled. This project is crucial for the student housing sector and has the potential to greatly ease the process of finding suitable accommodation...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. ...process will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be disc...

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

Senior Developer wanted with skills in Woocommerce | Wordpress. Must have real coding knowledge not just a plugin expert. To build custom plugins and modify existing ones.

I am in need of a skilled prog...skilled programmer to create a bot, effectively able to filter out vehicle listings and send them directly to me on whatsapp , twillio etc (any) Key Responsibilities: - The bot should primarily use Craigslist, OfferUp, and Facebook Marketplace platforms for sourcing listings. - The bot should filter vehicle category listings exclusively. Vehicle Filtering Criteria: - Vehicle make and model - Year range - Price range - Distance Ideal Skills: - Experience with bot programming and development - Familiarity with Craigslist, OfferUp, and Facebook Marketplace APIs - Understanding of the automobile market, specifically characteristics and identifiers - Proven track record of creating bots that can quickly and effectively f...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

I'm looking for a skilled developer to upgrade my site from PHP 7 to PHP 8.2. The current site has: - User registration and login functionality The site is built on Custom PHP, without the use of any specific frameworks or CMS. The ideal freelancer would have: - Strong experience with PHP - Previous experience with upgrading codebases from PHP 7 to PHP 8.2 - Familiarity with Custom PHP coding Please note that the client did not specify custom plugins or modules that need updating. However, it's important to anticipate and address any issues that may arise during the upgrade process. The selected freelancer should be able to identify and resolve any potential conflicts with the existing site's functionality.

We are looking for a developer to create a Bootstrap filter table with advanced filtering functionality. The table should be responsive and able to handle multiple columns. Here are the specific requirements for the project: *** DO NOT BID ON THIS PROJECT IF YOU HAVE NO UNDERSATNDING OF BOOTSTRAP OR SOME IDEA OF THIS PROJECT. A TEMPORAY SKETCH LAYOUT WITH A SAMPLE WITH BE APPRICATED TO HELP US IN MAKING A DECISON WHO TO AWARD THE PROJECT TO. *** Functionality: - Advanced filtering: The table should allow users to filter data based on multiple columns. - Custom filtering: Users should be able to specify criteria for filtering. Responsiveness: - The Bootstrap table should be responsive, ensuring optimal user experience across different devices and screen sizes. Columns: - ...

App Requirements - **User Management:** Account creation and login via email or Google account, admin panel for managing user accounts. - **User Profile:** Profile completion with name, photo, description, and payment information. - **Geolocation and Filters:** Find nearby services using geolocation, filter services by category, distance, etc. - **Service Posting:** Service providers can publish services with details, photos, and prices, users can view service details. - **Messaging:** Integrated messaging system for users and service providers. - **Payment System:** Secure payments for services, admin management of transactions and commissions. - **Admin Panel and Statistics:** Dashboard for managing users, services, and transactions, view usage statistics and reports. - **Testing ...

I need someone who is Techy Has experience using filter option in google sheet Knows English really well and can call and talk and present the work to me in a high quality manner

Our existing ...CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

I have a document with the specifications of webservices. I need with php consume this webservices and get responses and save some information in my database

I'm looking for a skilled developer to create a modern, vibrant website using CorePHP. The design should be bold and colorful, catering to a business professional audience. Key Requirements: - Frontend: The site should offer a minimalistic yet engaging design that is appealing to the eye. - Backe...incorporate interactive product displays to make the user experience more engaging and dynamic. Ideal Skills: - Strong proficiency in CorePHP to develop and maintain a dynamic website. - Prior experience with designing websites with bold and colorful themes. - A good understanding of user experience (UX) and the ability to create interactive elements on the site. - Familiarity with product search and filter functionality is a plus. If you believe you have the skills to create th...

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

The task at hand is to upgrade the PHP version of my content management system from 7.2 to 8.1. I have been using a PHP without any frameworks, and I'd like to keep it this way. I'm seeking a skilled developer well-versed in PHP and experienced in operations without frameworks. Your responsibilities will include: - Studying the existing PHP code - Carrying out the necessary modification for smooth running on PHP 8.1 without any performance degradation. - Testing and debugging post upgrade to ensure seamless system operation Please note, I need this work completed within 7 - 15 days.

...a clean and minimalist interface, making it easy for users to navigate without any confusion. The design prioritizes simplicity, with clearly labeled buttons and intuitive menus. Smart Search Functionality: The app features a robust search function that allows users to quickly find restaurants based on various parameters such as cuisine type, location, price range, and ratings. Users can also filter their search results to narrow down their options. Visual Menus: Dine0ut provides users with visually appealing menus that showcase each restaurant's dishes with high-quality images and detailed descriptions. This helps users make informed decisions about their orders, enticing them with mouth-watering visuals. Customization Options: The app allows users to customize their ord...

...clear transcription of everything that is said in the audio file, including any noises or sounds that are part of the recording. You will need to have excellent listening skills and attention to detail to accurately transcribe this audio. Additionally, it would be helpful if you have experience in audio editing to filter out any background noises that could make the transcription process difficult. Key requirements: - Transcribe a 33:05-minute audio file accurately. - Filter audio to ensure clear transcription. - Include all sounds and noises in the transcription. - No time stamps are needed, just the audio in text form. Ideal Skills and Experience: - Proficient listening skills. - Attention to detail. - Experience in audio transcription. - Audio editing skills. Ple...

...reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex ...

...Integration: Fetch device statistics from a backend API. Modern UI: Clean, intuitive, and well-designed user interface. Key Features: Device List Display: A dashboard-like interface showing all IoT devices. Dynamic Graphs: Display statistics and data in a graphical format (around 10 different graphs). Data Tables: Tables with pagination to display detailed data. Filtering and Time Ranges: UI elements to filter data by different criteria, including time ranges. API Integration: Seamless integration with backend APIs to fetch and display data. Skills Required: Proficiency in Svelte and SvelteKit Experience with Skeleton UI or similar CSS frameworks Strong understanding of modern web development practices Experience with API integration Ability to create clean and user-friendly in...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I need a skilled professional to add (2) Adjustable analog input noise filters to an existing ( Kinco builder) program. The filter intensity needs to be adjustable In the settings screen on the HMI.(Kinco D tools)

I'm in need of a PHP developer to assist with resolving a specific issue within my code, and also adjust some functionality related to user balances and payment processing. - The issue is isolated to a certain part of the codebase. I have a video that comprehensively explains the problem, saving you time on debugging and troubleshooting. - The main issue at hand involves the necessity of adjusting user balances and funds for payments. This requires a high level of precision and understanding of PHP functionality. Ideal candidates should have: - Proficient in PHP and associated technologies. - Strong problem-solving skills to address the issue quickly. - Experience in user balance management and payment systems is highly desirable.

...Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming l...

I'm in urgent need of a PHP expert to assist in creating (or finish the unfinish project attach ) a server-side application that will use Google Drive API, Google Calendar API, and/or Google Contacts API. The main priority is to implement user sign-in functionality for the application to ensure secure access and authentication for users. Key Requirements: - Seamless integration of Google Drive API, Google Calendar API, and/or Google Contacts API into a PHP worker application. - Implementation of user sign-in features to authenticate users and provide secure access to the application. - Priority on the ability to upload files using Google Drive API. The ideal freelancer must have: - Proficiency in PHP and experience with server-side applications. - Expertise in ...

As discussed in chat and outlined in the provided document, excluding referrals, support ticket and reports

...Laravel. 7. Remove the display of the last date from the top of the contact view in Laravel. 8. Adjust calendar functionality to match design specifications in Laravel. 9. Ensure tasks are displayed on the task list page in Laravel. 10. Add task filter options by status on the task page in Laravel. 11. Change the title on the quote page from "Invoice" to "Add Quote" in Laravel. 12. Fix the functionality of discounts on the quote creation page in Laravel. 13. Resolve date picker issues on the edit job page in Laravel. 14. Remove the category type filter from the Job listing page in Laravel. 15. Ensure that all necessary information, particularly upcoming details, is displayed correctly on the single job view page in Laravel. 16. Redesign all PDFs for imp...

...donations. Individuals in need will be able to complete multi-step forms to submit all required data (images / texts / documents) for story creation. These data should be listed / displayed on a custom backend module as lists, enabling administrators to utilize them for manually creating each story's page. Admins should be also be able to view and edit stories details as well as list, sort, and filter stories by various statuses (completed, pending approval, draft etc.) Admins should then be able to use these data to manually create some custom post type stories, such as the following for example: Custom post type / custom fields should be utilized for the "stories" pages. Premade themes or plugins may be utilized for the current project;

More details: Which version of Excel are you using? Excel 2016 What type of data processing do you need? Data sorting, Data filtering What specific criteria will you use for sorting the data? Numerical order It is required to set up a script that will process an Excel file every day, filter the file according to an algorithm and leave the necessary data in the file.

Website Designer , Php , E Commerce having knowledge of MySQL

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm looking to improve the user experience on the blog section of my website. Specifically, I'd like to enhance the navigation and search functionality. Key Requirements: - The search functionality should allow users to filter by category or tag. This would greatly assist visitors in finding content that interests them quickly and efficiently. - I also want to introduce a comment section for readers to engage with the blog posts. This would encourage interaction and enhance the community around my content. Ideal Skills: - Proficiency in web development and design. - Experience with blog development and enhancements. - Strong understanding of user experience and SEO principles. - Ability to implement intuitive search and navigation features. - Prior experience in adding ...

I need a Zoho expert to help me set up a system where emails that match certain keywords in the subject are copied to a specific WorkDrive folder. Ideal Skills and Experience: - Proficiency in Zoho Mail - Experience in email filtering - Knowledge of WorkDrive system Please note that I want the emails to be copied, not moved, to the WorkDrive folder. I need both incoming and outgoing emails to follow the same method. I work in an office with 15 others and we get new cases meaning new filters frequently, so I'd like a method to be able to update their filters without needing them to redownload anything, sort of like a central hub from my computer. If there is any way for that to be done, I'd like to know the method.

I need a skilled developer to create a graph logic application in either Core PHP, JavaScript, or JQuery. The application will focus on visualizing user engagement data, specifically the bounce rate. Key Requirements: - Develop a graph logic application that utilizes Core PHP, JavaScript, or JQuery. - The system should effectively visualize user engagement data. - The application should specifically focus on visualizing the bounce rate metric. Ideal Skills: - Proficiency in Core PHP, JavaScript, or JQuery. - Experience in developing graph logic applications. - Understanding of user engagement metrics.

Website PHP version updation..............

...efficient and scalable messaging system that can handle high-volume message processing and filtering. Project Overview: The developer will be responsible for setting up Apache Kafka on a Windows environment and developing a master script and worker scripts to facilitate distributed messaging. The key requirement is to implement a mechanism for bulk-reviewing messages in the queues every 10 minutes to filter out unnecessary messages and optimize system performance. Responsibilities: Apache Kafka Setup: Install and configure Apache Kafka on a Windows machine. Set up the necessary Kafka topics, partitions, and brokers to support distributed messaging. Ensure proper security configurations and access controls are in place. Master Script Development: Develop a master script that a...

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

I need someone to display my YouTube comments based on newest first. I use PHBB forum so I would like it shown on top. It can accept html and php I believe. It should only show 5 latest. So if you can create this on your site I can upload it to mine and so we can see this on a blank page. Then I need code to insert into my Phbb forum

I need an expert in Shopify to sort out my Collection Page. The main issues are a lack of clarity in product display, filter malfunction, and pagination problems. Key tasks: - Ensure products are correctly displayed - Fix filter functionality - Get pagination working properly Your expertise in Shopify and its Collection Page is crucial to make shopping on my website a seamless experience. Please highlight your experience with similar projects when bidding.

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your app...

...retreats, sessions, and activities. Each Event needs to show: a. The title of the event with a short description b. The location c. The date & time d. Link/Button to the practitioner’s booking website. e. The price f. An option for longer pop-up bio/description of the event, studio and practitioner running the event (see example in the link below). 2. Filtering Options: Users should be able to filter events based on date, type, location, practitioner/studio, popularity, tags and price. 3. Unique Booking Links: Each event listing should include a distinct booking button that redirects to the practitioner’s booking page. 4. User Registration and Profile Management: Allow practitioners to register, create profiles, and manage their listings. 5. Admin Management: Pr...

...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...

I’m currently seeking an experienced developer for the creation of a CRM Application based on WordPress and PHP. This comprehensive CRM system will focus mainly on the following aspects: - Contact Management: Easy setup for adding new contacts, updating existing contacts, and generally ensuring robust record-keeping for clients. - Sales Pipeline Tracking: This feature will aid in tracking the progress of deals, identifying slow points, and pushing for efficient sales funnel management. - Customer Support Ticketing: A well-organized dashboard for support tickets, helping in prompt and effective resolution of customer issues. While the main features are outlined, I’m open to discussing additional functionalities that might enhance the system’s effectiveness. Integ...