The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
# 2013년6월 ~ 2013년12월 : 고양시 상수도 블록시스템 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, ibatis, amchart, eazy-ui # 2014년1월 ~ 2014년3월 : 고양시 상수조 블록시스템 GIS적용 - 고객사 : 고양시청 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술 : Java, Spring, Oracle, iBatis, O2Map, OpenGIS # 2014년4월 ~ 2014년11월 : 주유소 누유관리 모니터링 시스템 - 고객사 : (주)에스티모빅 - 근무사 : 프리랜서 - 사용기술 : Java, Spring, MySql, MyBatis, jqgrid, bootstrap, daum map API, plot-chart # 2014년12월 ~ 2015년2월 : 생산관리 ERP설계 - 고객사 : (주)금강이엠씨 - 근무사 : 프리랜서 - 사용기술 : mockup UI tool # 2015년3월 ~ 2014년4월 : 블루투스 BLE 비콘통신 Android 개발 - 고객사 : (주) 바이트시스템 - 근무사 : 프리랜서 - 사용기술 : Android (블루투스 BLE 비콘통신, 서버 소켓통신) # 2015년7월 ~ 2014년8월 : 임베디드 리눅스장비 웹관리 프로그램 - 고객사 : (주)제이앤씨시스템 - 근무사 : (주)제이앤씨시스템 계약직 - 사용기술...
php, mysql, word press, bootstrap, jquery , ajax, html5 (모바일웹, 앱) 기술 우대
...되어야 합니다. 주문이 없는 날은 표시가 안 되면 됩니다. 일자를 선택하면 그 날 주문한 상품의 이름,수량이 보였으면 합니다. 주문상세내용이 보였으면 합니다. 그리고, 원격 Database 접속정보와 관련된 쿼리는 아래와 같습니다. OS는 windows 2012 , 데이터베이스는 MS-sql이고, 원격주소, 계정, 암호는 실제 내용을 알려드릴 수 없는 점 양해바랍니다. 현재 디비접속은 이런 형식으로 하고 있습니다. -> ,1000 (사이트주소,포트번호) , 계정 : Testaccount , 암호 : Test 입니다. 금액 쿼리 : Select replace(convert(varchar, cast(Isnull(Sum(Ori_price*qty),0) as money),1),'.00','') as Orderamt from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 금액은 붉은 색 글씨로 표시되었으면 합니다. 주문 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 미배송 건수 : Select count(Order_id) from Orders where Convert(Varcha...
...our website, which is built using Umbraco, C# coding, and MySQL database, to a new hosting environment. **Project Details:** - **Current Setup:** - Website developed in Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with m...
...with a live preview of the customized content. - PDF Export: The system should be able to convert the final design into a PDF format for printing. - Online Payment and Shipping: The site will need to integrate with Taiwan's Green World Technology payment gateway and logistics systems from Taiwan Post, 7-Eleven, and FamilyMart. - Admin Panel: A backend admin panel is required for managing customer orders. - Google Maps Integration: The website should be linked to Google Maps. - Image Slider: The site should have a feature allowing a full site image carousel, where products can be replaced or uploaded. Further Details: - Frontend Programming: The website should include an introduction to our banner services, a process flowchart, material descriptions, a design option page, an...
I'm looking for a skilled developer to create a Flask-based website connected with mysql. This website will be primarily for my personal development. Key Features: - Email Verification otp on login A simple website for our team to use with login option and it should have following features A form to manually update my database A search page to search in my database (For example :- for a student databases a page to add all the details of a new student manully and a page to search for students based on same criteria which shows the result in a table form) My budget is around 2000- 2500 rs Ideal Skills: - Strong experience with Flask: You should have a proven track record of developing websites using Flask. - User Authentication Expertise: Understanding and i...
DATA SCRAPPING DATABASE This is an interesting overview of the steps that might be involved in completing this project: 1. Develop a web scraping script using Python (e.g., BeautifulSoup, Scrapy) to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping
...Creation**: The primary goal of this project is to create a direct integration or web service that can extract suppliers, products, and purchase orders from various data formats (CSV, XML, JSON) and seamlessly import them into Microsoft Dynamics GP 2016. This will greatly enhance the efficiency of our purchasing workflow and eliminate the need for manual data entry. Ideal Skills and Experience: - **Microsoft Dynamics GP 2016 Proficiency**: A thorough understanding of Microsoft Dynamics GP 2016 is essential for this project. Previous experience working with this ERP system is a must. - **Database Manipulation**: Given the preference for direct database manipulation, the selected freelancer should be proficient in creating secure, efficient, and reliable integrations...
Hi I will work for 6 hours and get website leads as many as possible till Tomorrow. Thanks
...creation of tailored quotes for clients, including images and detailed descriptions pulled from a database. Features to Include: • Client and Project Selection: Choose a client and specific services or products for which a quote is needed. • Item Database: A database of all products and services, including descriptions, prices, and images. • Quote Customization: Ability to add, remove, or adjust items and quantities in the quote. • PDF Generation: Convert the final quote into a PDF format for easy sharing and printing. • Email Integration: Directly email the quote to the client from the app. 3. Work Order Management This tool will help manage tasks and ensure timely completion of work orders. Features to Include: • Ta...
Gradeco has an intranet called GRADENET, and its created in php/mysql platform. Please look at uploaded file for the requirements. Feel free to ask questions.
...performance - Troubleshoot and resolve any technical issues that arise - Collaborate with our team to understand project goals and deliver results that exceed expectations - Stay updated with the latest industry trends and technologies to implement best practices Requirements: - Proven experience in WordPress and WooCommerce development - Strong understanding of PHP, HTML, CSS, JavaScript, and MySQL - Experience with theme and plugin customization - Knowledge of SEO best practices - Ability to work effectively in a team environment - Excellent communication skills and attention to detail - Ability to manage multiple projects and meet deadlines Preferred Qualifications: - Experience with RESTful APIs and third-party integrations - Familiarity with version control systems like Gi...
...website is secure and trusted by visitors. ** Database Management: - Integrate Google Sheets with the MySQL database so that the rates can be updated weekly via Google Sheets instead of directly through the cPanel, simplifying maintenance and updates. - Ensure seamless data synchronization between Google Sheets and the MySQL database to keep the quote system accurate and up-to-date. ** Deliverables: - A fully redesigned WordPress website with a modern look and maintained content. - A fully functional, tested, and bug-free instant quote form. - SEO setup and optimizations, including keyword implementation, meta tags, and link building. - SSL certificate setup and configuration on GoDaddy. - A system for syncing Google Sheets to the MySQL...
Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored in with...
I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.
I require a meticulous professional, experienced in t...coherent and functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the software has t...
I'm seeking a skilled and experienced developer to create a Solana sniper bot for trading on the Dex Screen exchange, integrated with the Dex for trading on the Solana blockchain. Key Requirements: - The bot should execute trades based on price fluctuations, implementing buy and sell orders. - It needs to have built-in automatic stop-loss and take-profit functionality to manage risk effectively. - Customizable trading parameters are essential for adapting to different market conditions and user preferences. Experience and Skills: - Proficiency in Solana blockchain and DEX trading is a must. - Demonstrable experience in developing trading bots is highly desirable. - Strong understanding of cryptocurrency markets and trading strategies. - Proven ability to create bots with adva...
... Reward points management (adjust points, manage redemption) specific to each hospital. Product management for point redemption. Transaction management for cash withdrawals. Reporting and analytics dashboard. Technical Specifications: Backend: PHP Laravel framework. Frontend: Hybrid technology (e.g., React Native, Flutter). Database: MySQL or PostgreSQL. Secure payment gateway integration for cash withdrawals. Compliance with data protection regulations. Project Timeline: Detailed project plan and timeline to be provided by the company. Expected project completion within 3months. Payment Terms: No advance payments will be made. Payment will be released only upon su...
I'm looking for a skilled developer to create an Android E-commerce app. The m...users to create accounts and sign in. - Product Catalog: A comprehensive display of various products for users to browse and choose from. - Shopping Cart: A functionality that enables users to add products to their carts as they shop. - Payment Integration: Integration with Razorpay for secure and convenient payment processing. - Order Tracking: A feature to allow users to track the status of their orders. The ideal candidate should have: - Proficiency in Android app development - Experience with E-commerce app development - Knowledge of integrating payment gateways, specifically Razorpay - Strong problem-solving skills - Ability to create a user-friendly interface - Time management and project ma...
I'm looking for an experienced developer to create an Android app and website to effectively manage orders, returns, and payments across multiple marketplaces including Amazon, Flipkart and Meesho. The project should essentially mirror the functionality of Wisdom OMS. Key Features: - Order Tracking: Real-time tracking and monitoring of all incoming and outgoing orders from the aforementioned platforms. - Inventory Management: Integrated inventory system that automatically updates stock levels in response to orders, ensuring accurate and timely management of product availability. - Payment Processing: Smooth and secure payment processing capabilities to facilitate transactions and revenue collection. - Returns Management: Effective returns management system that t...
**Title: Talented and Versatile Designer with Marketing Skills for Print-on-Demand T-Shirt Business** **Description:** We are launching a print-on-demand T-shirt business and are seeking a highly skilled and versatile freelancer to join our team. This individual will be responsible for designing T-shirt graphics, managing print orders, and handling various marketing tasks. **Objective:** The primary goal is to increase sales, so your designs should be not only visually appealing but also commercially viable. **Design Styles and Themes:** - **Styles**: We are particularly interested in pop culture references—a style that's both entertaining and statement-making. - **Themes**: While open to a range of pop culture references, specific themes include movies, TV shows, mu...
...ability to manage contacts. I should be able to add, edit, and delete contacts. These contacts should be organized into categories or groups. Additionally, I should be able to search and filter contacts based on specific criteria. - **Activity Logging**: The app should have a feature for activity logging. It should record order history, client information, and allow me to add, remove, or modify orders and client IDs. Ideal skills for this project include: - Proficiency in developing lightweight applications - Experience in CRM development - Expertise in FTP data transfer management - Ability to create a user-friendly interface for the app - Strong understanding of both Windows and Mac environments - Excellent problem-solving skills and attention to detail Please bid only if you...
I need a licensed medical doctor with a focus on ordering blood labs for our clients, assisting in identifying metabolic issues, diabetes, prediabetes, PCOS, obesity, and overweight. Key Responsibilities: - Ordering blood tests: I require someone who is capable of prescribing a comprehensive array of blood tests. - Interpre...essential. - Endocrinology Experience: A background in endocrinology or a related field would be a bonus. - Empathy and Professionalism: The ability to interact with clients in a caring and professional manner is highly valued. Please note that this role is focused on telehealth, so you will not be required to physically meet with the clients. Your primary responsibility would be to provide lab orders based on the results of our screening and assessment ...
I'm in need of a demo trading terminal specifically for the stock market. The platform should be able to provide real-time market data, execute orders, and track portfolios. Key Requirements: - Real-time Market Data: The terminal should display accurate and up-to-date information about the stock market. - Order Placement and Execution: It should allow users to place buy/sell orders and execute them seamlessly. - Portfolio Tracking: The platform should include a feature that monitors the performance of a user's portfolio. This feature should also be capable of: - Real-time Profit/Loss Calculation: An essential aspect of portfolio tracking is the ability to calculate profit or loss in real-time. - Graphical Representation of Portfolio Performance: Visual rep...
...me find buyers for my pyrolysis oil in Vietnam. The oil is top quality, with high calorific value, low sulfur content, and specially optimized for use in industrial boilers. Key Responsibilities: - Identify and approach potential industrial and commercial buyers in Vietnam. - Promote the benefits and unique selling points of my pyrolysis oil. - Negotiate deals with interested parties. - Secure orders of a minimum of over 5,000 liters per transaction. Ideal Candidate: - A sales professional with experience in the oil or related industry. - An understanding of the industrial and commercial markets in Vietnam. - Proven track record of successful negotiations and deal closures. - Ability to effectively communicate the technical specifications and benefits of the product to potentia...
I need a skilled web developer to create a responsive website for my existing restaurant business. The main focus will be on creating an intuitive and reliable food ordering process. This is what I'm looking for: * Food Ordering System: A user-friendly system that offers customizable orders, pre-set meal choices, and implements real-time order tracking. Customers should be able to view the menu, make a selection, and track the preparation and delivery of their orders. * Design Guidance: I would appreciate some guidance on the design aspect of the website. While I don't have any design guidelines or branding assets to share, I'm open to creative suggestions that align with my business. Ideal skills and experience: * Web Development: Experience in creating re...
We have an existing platform that fetches top news headlines based on interest and uses GPT in order to compile them into a headline and send via SMS. The current bot is a selenium and existing panel is a basic Django admin. These are the new revamps that I'm lo...google news with a quick glance. Also would be nice to integrate twitter news into this someway since certain news gets broken on twitter first. Admin Panel: Need admin panel designed as per psd files with basic user controls such as Dashboard (analytics - visitors, revenue, mrr, abandoned carts) Users (Name, email, password reset, payment on file, location, interests, Cancel Subscription) Orders. Processing & other: Switching processor, and adding Plaid pay subscriptions as checkout option Migrating our r...
I am looking for a professional PHP developer who can build a custom website for me, and integrate it with one APIs. - the API is already in use in other websites so ...as the one in the link above. We have already developed a basic frontend page with the form (input boxes and selectables) to collect the data that will be submitted to the API (json). Next step is store this data locally and submit it to the API. Final design we will take care later. Ideal skills and experience for this project include: - Proficiency in PHP, with a strong understanding of MySQL. - Experience working with various APIs, as you may need to integrate APIs into the site. - Strong communication and problem-solving skills, as you may need to troubleshoot any issues that arise during the integratio...
- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project
I'm looking for a skilled developer to create an Android E-commerce app. The m...users to create accounts and sign in. - Product Catalog: A comprehensive display of various products for users to browse and choose from. - Shopping Cart: A functionality that enables users to add products to their carts as they shop. - Payment Integration: Integration with Razorpay for secure and convenient payment processing. - Order Tracking: A feature to allow users to track the status of their orders. The ideal candidate should have: - Proficiency in Android app development - Experience with E-commerce app development - Knowledge of integrating payment gateways, specifically Razorpay - Strong problem-solving skills - Ability to create a user-friendly interface - Time management and project ma...
Need a college B. Tech student who is studying and want to earn something.
...- Shopping Cart & Checkout Process: An efficient, user-friendly shopping cart and checkout process is essential. The design should encourage a smooth and hassle-free purchase experience for customers. - User Profiles & Accounts: I would like the design to include a section for user profiles and accounts. This will allow our customers to create accounts, manage their information, and track their orders. Ideal Skills and Experience: - Proficient in Figma: A strong command of Figma is a must as the design will be created using this platform. - E-commerce Design Experience: Prior experience in designing e-commerce websites is highly desirable. Understanding of user behavior and conversion optimization is a plus. - Modern and Minimalist Design Aesthetic: The design should be ...
I am looking for a skilled C++ developer to create a...should focus on data retrieval and manipulation. - User authentication and authorization are required for this project, using existing APIs Database: - Although I don't have an existing database, I have specifications for it. - The API should connect to the specified MySQL database based on the provided specifications. Timeline: - The expected timeline for the project is more than 3 weeks. Skills and Experience: - Proficiency in C++ programming language and POCO framework - Strong knowledge and experience in developing REST APIs. - Familiarity with MySQL database connectivity and management. - Ability to understand and implement specifications for the database. Please provide ex...
I want expert wordpress developer and expert in JS, PHP, HTML and CSS, i want to design a custom orders page for my website. Check the attached video of the orders page i want.
...This will help users to easily find what they are looking for. - **Customer Reviews**: I'm looking for a system that allows customers to leave reviews for the products they have purchased. This will help boost credibility and trust in the brand. - **Order Management**: The website should have a seamless order management system. This feature should make it easy for me to track, manage, and fulfill orders. Ideal Skills and Experience: - Proficient in web development, with a strong portfolio of previous work showcasing e-commerce websites. - Familiarity with implementing and managing product listings, categories, and customer review systems. - Experience in creating intuitive and user-friendly interfaces. - Knowledge of order management systems and their integration into websi...
I want to create a website for my business which will serve as an e-commerce platform. I need a skilled web developer to create this website for me from scratch. The website needs to be designed with a user-friendly interface and responsive design. Key requirements: - E-commerce functionality: The website should be able to handle a large number of products and orders. - Payment gateway integration: I'll need assistance in integrating a specific gateway, and open to suggestions based on your expertise. - Security: The website must be secure with proper SSL certification and encryption. - SEO-friendly: The website should be designed with SEO in mind, to ensure it's optimized for search engines. Skills and experience needed: - Proficiency in web development, especially...
I'm looking for a custom add-on for Perfex CRM. The add...CRM. The add-on shall generate a graph that can be filtered by personnel and date. Key requirements include: - Display data: The graph should show the number of opportunities. - Chart style: The preferred style is a line chart. - Filtering: The graph should be filtered based on selected personnel and date ranges. Ideal skills for this project include familiarity with Perfex CRM, strong PHP and MySQL experience, as well as an understanding of charting libraries for graph representation. A professional who can work efficiently and deliver a user-friendly, visually appealing solution will be highly appreciated. There is a ready-made page similar to our needs in Perfex CRM. I just want it to be converted into a plugin with...
I need a Shopify expert to address a specific issue on my website as well as integrate a custom order form. - Size Issue: Customers are having trouble choosing the right size when purchasing an item. This issue needs to be resolved promptly to ensure a smooth shopping experience. - Custom Order Form: I'm looking to expand my services by allowing customers to place custom orders. This form should have the capability for customers to upload images/files and provide detailed text specifications for their order. Ideal Skills: - Proficiency in Shopify - Experience in resolving size option related issues - Ability to create a custom order form with upload functionality - Excellent understanding of e-commerce and user experience I value clear communication and efficient work, s...
Need freshers who want his first job with good visibility.
I'm looking for an experienced Python Developer to assist with web development tasks using Django and Flask frameworks. Key Responsibilities: - Implementing web development tasks using Django and Flask frameworks. - Ensuring the code is of high quality and meets our standards. - Collabora...Flask frameworks. - Ensuring the code is of high quality and meets our standards. - Collaborating with the team to deliver project requirements on time. Ideal Candidate: - Proficiency in Django and Flask is a must, with experience in building scalable web applications. - Previous experience with Python for web development is highly desired. - Knowledge of databases and data storage systems like MySQL, PostgreSQL, and MongoDB is a plus. - Strong communication skills and ability to work well...
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
Need freshers who want his first job with good visibility.
I am in need of an experienced web de...designer to create an e-commerce website. This site will be relatively simple, with less than 50 products available for sale. Key Features: - Payment Gateway Integration: A seamless payment process that allows customers to make transactions with ease. - User Account Creation and Management: A user-friendly system where customers can create accounts, manage their information, and keep track of their orders. Your role will be to design a visually appealing and user-friendly website that incorporates the above features. I'm looking for a professional who can deliver a modern, clean and responsive e-commerce site that enhances the online shopping experience for our customers. Please provide examples of your previous e-commerce website desig...
I'm currently looking for experienced Cs-cart developers to assist with the development of a new site and Mobile apps Only Apply if you have experienced in cs-cart ( ) PHP software Built using open source technologies, PHP/MySQL, Smarty, CS-Cart is flexible and highly customizable software making it easy to modify the program and extend its functionality according to your needs. Key requirements include: - Developing a brand new Cs-cart site from scratch. - Experience with online stores, especially those dealing with physical goods. - Implementing top-notch e-commerce features, including but not limited to product listings, categorization, and secure checkout. - Designing a user-friendly and visually appealing interface that aligns with our brand identity. - Ensuring ...
I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.
...shared hosting using cPanel. Here are the specific steps and requirements: - Laravel 8: The first task would be to install this version of the Laravel framework on the hosting server - Node.js: The latest stable version of Node.js should be installed to support the application - File Management: The application files will need to be uploaded via the File Manager - Database: You will need to create and configure a MySQL database - Dependencies: I need you to install Laravel and Node.js dependencies The ideal candidate should have experience with Laravel, React, Node.js, and deployment on FastComet's shared hosting. Experience with cPanel is a plus. Your understanding of e-commerce application functionalities will be highly appreciated as well. Please include...
