Php sql query filter työt

Change our current user and customer portal php project to laravel framework and make sure all functions work.

Usealla isolla yrityksellä on käytössään Suomessa eräänlainen heidän alansa ERP-paketti, joka on koodattu Visual Basicillä. Tarvitsisimme VB-osaajaa ylläpitämään ohjelmistossa mahdollisesti tehtäviä muutostöitä. Tekniikka lyhyesti: • Visual Basic -koodia noin 280-290 000 riviä • Integraatio taloushallintoon ja palkan maksuun • raporttipuolella n. 50 000 riviä • Crystal Reports • Microsoftin SQL Server -kanta Työmäärät vaihtelee, mutta keskimäärin 1-2 päivää/viikko. Välillä hiljaista.

Meillä on kaksi yritystä järjestelmässä, joilla on omat varastokirjanpidot ja osto-&myyntitilauksensa. Lokaalina serverinä toimii Windows 7 ympäristössä, visma Nova pro 9 (Windows sql server). Mikäli työn suoritus vaatii jonkin tietyn ympäristön niin kysele. Haluaisimme ajoitettuina tehtävinä ajaa allamainitut skriptit jotka muodostavat CSV tiedostot jotka on tarkoitus lähettää sähköpostina eteenpäin. Skriptin asetusten muokkaus skriptin alussa. Muuttujat ja funktiot kommentoituna. Lisätyönä voi tarjota näiden tiedostojen automaattista lähettämistä (Tiedosto liitteenä + leipätekstissä luettavasti muotoltuna). --------------...

Webservicen luominen sql tietokannalle. Perus toiminnot webservicelle ja kehitys ympäristön pystytys. Tarkempi speksi on saatavilla NDA:n kirjoituksen jälkeen. Kehitys mielellään Eclipse ympäristössä.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.

Java, J2EE, JDBC, SQL, java Threading,GWT,Html,CSS

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Moi! Osaatko kuinka hyvin sql:n perusasiat? Onnistuuko asentaa tietokannan hallintajärjestelmä, luoda ja hallinnoida tietokantoja sekä käyttäjätilejä ŠŠ ,seurata ja optimoida tietokannan toimintaa. Jos perusasiat hoidossa niin ota yhteyttä :)

Moro, Mulla olisi sulle työtarjous! Jos voisit tehdä mulle simppelin tietokannan ~5 taululla, ja kerrot vähän perusjuttuja sql serverin toiminnoista jne, niin ota yhteyttä ja jutellaan tarkemmin. Arvioisin, että tässä ei montaa tuntia menisi. Riippuen toki kuinka hyvin nuo sql perusjutut osaat ;)

Private job.

Moikka, huomasin profiilisi ja ajattelin kysyä olisiko sinulla kiinnostusta tehdä etätyönä PHP/MySQL/JS koodia erilaisiin projekteihin jotka on tehty Yii Frameworkin päälle? Yst. Terv. Mika Saarinen Puh. 040 480 6791 mika@

Etsimme pitkäaikaiseen yhteistyöhön suomenkiltä osaavan koodarin. Tarvittavia taitoja on php, mysql, html ja wordpress osaaminen.

Thanks, great job!

I'm looking for a skilled app developer to create a comprehensive Grocery Delivery App for both iOS and Android, with a particular focus on user experience. Key Features: - User Registration and Login: The app should allow users to create accounts, login securely, and manage their profiles. - Search and Filter Products: Users must be able to easily search for products, filter by category or brand, and add items to their cart. - Order Tracking: It's crucial that the app includes a feature to track orders in real-time. This should provide customers with an estimated delivery time and status updates. Payment Integration: - The app must feature a secure and seamless payment gateway. This is essential for processing transactions and ensuring a smooth user experience. ...

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 ...

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.