How to calculate overlapping time in sqlงาน
1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน
ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure
รูปแบบการทำงาน : 1.เข้าเก็บข้อมูลขั้นตอนการทำงานแต่ละแผนกที่บริษัท (เก็บครบตามหัวข้อที่ได้รับไม่ต้องเข้าออฟฟิตแล้วในช่วงนั้น) 2.พิมพ์สรุปข้อมูลทั้งภาษาไทย ตาม Template ที่กำหนดและรวมเล่ม (ทางอีเมล์) 3. ปรับแก้ไขงานบางส่วนและ ปริ้นท์รูปเล่ม (ส่งงานทางอีเมล์) ระยะเวลาเริ่มงาน เดือนสิงหาคม-กลางเดือนตุลาคม สถานที่ รถไฟฟ้ากรุงธนบุรี (เริ่มงาน 9 โมงเช้า- 5 .30 โมงเย็น) สามารถคุยเรื่องเวลาที่สะดวกและงานที่สามารถรับได้โดยไม่กระทบต่อการเรียนหรือ อื่น ๆ ได้ รายได้ ตามแผนกที่ได้รับมอบหมาย จำนวนงานไม่เท่ากัน ประมาณ 10000-12000 บาท / เดือน หากใครได้ภาษาอังกฤษ มีราคาอีกเรทนึง สามารถตกลงกันได้ ติดต่อ เบอร์ 0927498979 กี้
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Server และพิมพ์ใบงานส่งให้ฝ่า...
ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]
โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน ...
การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง
...เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ
ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.
Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.
Software and Application OCR Scan or Take Photo of Document OCR TO SQL
Create a Dynamic Web pages for calculate transport charge using MySQL and PHP ต้องการโปรแกรมที่สามารถคำนวณค่าขนส่งสินค้าโดยนำข้อมูลที่มีผู้กรอกลงหน้าเวบมาคำนวณกับ Data base ค่าขนส่งสินค้าที่มี แล้วส่งให้ผู้กรอกลงหน้าเวบทางอีเมล
รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.5...
DA upto 40 DR upto 60+ TF upto 40+ CF upto 35 UR upto 70+ PA upto 35+
We're looking for a freelancer to take and upload live photos of 8 Rittenhouse / Center City bars in Philly. This is for a Philly bar iOS app, aimed at providing real-time updates to users regarding the bars' lines and interiors. Key Responsibilities: - Taking live photos of bars from 9pm-1am on Friday and Saturday night. - Uploading the photos to the app promptly. Photo Guidelines: - Photos must be taken on an iPhone and uploaded to our iOS app
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account man...
I need some extra help around the club. Key tasks involve bartending, cleaning, and event planning, for less than 10 hours a week. While physical labor and cash handling aren't a necessity, basic laptop skills and the ability to run an app are a must. This job is best suited to someone with a background in customer service. Part-timers with flexibility are encouraged to apply as hours can vary.
I'm in search of a highly educated female home caretaker (who can speak English or Hindi) to manage house activities and take care of family members. It is essential that the candidate holds a high school diploma. The ideal candidate for this role will be expected to: Organize the household schedules effectively Prepare meals for the family Assist with family activities This is a full-time position, requiring services for more than 8 hours per day. Please note that this position does not involve cleaning tasks, as we have maids for that. The primary responsibilities will be taking care of the family, managing the house, and running errands such as going to the market and buying groceries. We offer transportation (flight or train to travel ...
...looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to calculate their incentives. Key Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software developme...
I'm in need of a skilled Web Application Developer to create a sales incentives system that will handle complex calculations and generate comprehensive reports. Essential Features: - Commission Percentage Calculation: The system should be able to calculate the commission based on the sales made. - Bonus Calculation: The application needs to compute bonuses based on the sales targets achieved. - Tiered Incentives: The system should offer tiered incentives based on the sales performance. Additional Requirements: - User-Friendly Interface: The application should have a simple, intuitive interface for easy usage. - Reporting: The system should generate detailed reports on the sales incentives calculations. - Security: It's crucial that the applic...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions ...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
...freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source cod...
I am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently
...a part-time professional with a proven track record in sales, strong negotiation skills, and experience in lead generation to enhance my team's capabilities on profit sharing basis. Key Requirements: - Proven Track Record: Your past performance in the sales field should speak for itself. A strong history of meeting or surpassing targets is essential. - Strong Negotiation Skills: The ability to close deals effectively and maintain healthy relationships with clients is a must. - Experience in Lead Generation: Generating potential leads and converting them into customers is a fundamental part of this role. Your ability to identify new opportunities will be key in the growth of our customer base. My objectives for hiring...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this pro...
I need a web-based application to calculate the dues per apartment based on the expenses categorized by type. The main points are: - Expense Categorization: The app should categorize the expenses by type. For instance, maintenance, utilities, repairs, etc. - Dues Calculation: - Square Footage Basis: The apartment dues should be calculated based on the square footage of each apartment. - Platform: The application should be web-based, accessible from any browser. Ideal Freelancer: - Experience with web application development, especially in accounting or financial tracking software. - Understanding of expense categorization and calculation based on different parameters. - Familiarity with building user-friendly interfaces.
...minimum of 10+ years of experience, I am looking to enhance an existing Real Time Dashboard within PHPMaker 2023. Key Responsibilities: - Modify existing features and incorporate new functionality - Implement user authentication system to ensure data privacy - Create real-time notification system for immediate updates - Develop advanced interactivity for data manipulation and customization Desired Skills: - Proven expertise in PHP development, ideally with PHPMaker 2023 - Comprehensive experience in building Data visualization (Charts, Heat maps, Custom Dashboards) - Strong understanding of user authentication mechanisms - Ability to develop real-time features for immediate data updates - Experience in creating advanced in...
I need assistance in copying text content from my smartphone and pasting it into the appropriate place. Key Requirements: - Copying text from my smartphone- The texts are not in a document but on my phone. A good understanding of how to copy and paste from a phone is essential. - Paste into the appropriate location- The text will need to be pasted into the correct place, whether it be a website, document, or elsewhere. Time Expectation: - I am looking for someone who can assist me part-time. This means the job doesn't need to be completed all at once. A longer-term arrangement is possible if the collaboration is successful. Ideal Skills: - Understanding of basic phone functions - Strong attention to detail - Ability ...
I'm currently looking for a Vue.js developer with a solid understanding of Laravel. While I'm not certain the version of Vue.js I'm using, I know that I need to implement a real-time chat feature in my project. Ideal Skills and Experience: - Proficiency in Vue.js is a must. Experience with both Vue 2 and Vue 3 would be beneficial given my uncertainty about the version currently in use. - Strong understanding of Laravel is also required since the project involves integrating the chat feature into an existing Laravel application.
...employee time tracking system on Google Sheets. The system should automatically calculate total hours worked, allow for marking employees as present or absent, and have fields for project number and name. Key Features: - Automatic Calculation: The system should calculate the total hours worked by every employee within the specified date range. - Attendance Tracking: There should be an option to mark employees as present or absent. - Project Details: Each row should contain fields for the project number and name. - Multi-employee Handling: The system should accommodate multiple employees' data in a combined sheet. Skills and Experience: - Proficient in Google Sheets - Experienced in creating automated time tracking systems - ...
...installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm...
Looking for a web developer to assist with various technical woocommerce things with woocommerce, i rather a company than an individual this way there is more skills to different tasks and i dont want issues like disappearing freelancers. Please make sure you are serious, keep having people start the job, do a few things and then all of a sudden just stop working for no reason. Must have good communication and have experience with complex fixes, when a task is assigned it needs to be resolved and whatever else is found quickly. Bugs mean the site is down or not working and dont have time for excuses or inexperience. This is a long term position as once you get use to the sites (about 12) the issues tend to be the same. DO NOT apply just to...
...work part-time and have great communication skills. Key Tasks: - Help with administrative tasks: This includes managing my calendar, setting up meetings, and handling basic bookkeeping. - Conducting Research: I need someone who can gather information for me on topics that I provide. - Assisting with Customer Support: You will need to handle customer inquiries and provide basic support. Communication is key for this role, so I need someone who is comfortable with various communication channels. I expect you to be responsive to emails, phone calls, and instant messages. Ideal Skills and Experience: - Proven experience as a virtual assistant or in a relevant role - Excellent organizational and time management skills - Strong communication skills...
I'm in need of a skilled web developer to create a one-page website for my upcoming political campaign. The main goal of this landing page is to raise awareness about the candidate and recruit volunteers. TEMPLATE - purchased COPY - completed PICTURES - available THUMBNAILS - being completed GOAL - for the one-page site to look & function exactly like the template TIMELINE - it time line is missed, contract is cancelled HOURS - we meet multiple times a day for 5-minute sprint meetings during US hours; if you're not available during US business hours, please do not apply Key features to be included on the page: - Detailed information about my background as a candidate - Clear campaign goals and objectives for potential suppor...
I'm looking for an experienced developer to help with real-time text data scraping via API and management using BeautifulSoup. This project is primarily focused on retrieving text data and storing it in a database. Key Responsibilities: - Implement an API scraper to continuously retrieve text data in real-time - Utilize BeautifulSoup for data extraction and management - Develop a robust database to store all the scraped text data The ideal candidate should have: - Proficiency in Python programming language - Strong experience with API scraping and BeautifulSoup - Previous work involving real-time data scraping - A good understanding of database management It is important that the data scraping runs seamlessly and accu...
...analyst to help me develop and formulate financial projections for my technology startup. The ideal freelancer for this job would have a background in finance, specifically in the technology sector. Key Requirements: - Provide detailed revenue projections: I need a breakdown of how much income is expected to be generated on a yearly basis. This should include a clear analysis of potential income streams and growth rates. - Develop expense projections: It's important to outline the costs associated with running the business. The freelancer should be able to provide a thorough examination of potential expenses, including operating costs, salaries, and other expenditures. - Create profit projections: Based on the revenue and expense fo...
We are looking for a talented PHP Laravel Programmer to join our team and work on our B2B ecommerce website and app development. The ideal candidate will have a strong background in PHP and Laravel, with experience in building and maintaining ecommerce platforms. This is a remote position, offering the flexibility to work from anywhere. Key Responsibilities: Develop, test, and maintain high-quality ecommerce solutions using PHP, Laravel, MySQL, HTML, CSS, JavaScript, and related technologies. Collaborate with the design and product teams to implement new features and improvements. Optimize and enhance the performance of the website and app to ensure a seamless user experience. Troubleshoot and resolve issues as they arise, ensuring the stability ...
I'm in need of a full-time, mid-level software developer to join our e-commerce company. You should be proficient in Python, Java, and PHP. Your primary responsibilities will include: - Coding and programming: Developing robust, scalable software solutions for our e-commerce platform. - Database management: Ensuring the efficient operation of our databases and managing related processes. - Bug fixing and troubleshooting: Identifying and addressing software issues to maximize performance. Your experience should ideally span 2-5 years, giving you a good understanding of the nuances of software development. In addition to your technical prowess, you should be able to work efficiently within a team and communicate effectively. You...
...I'd like to organize my games by categories using custom taxonomies. Please read the SPECIFICATIONS BEFORE BIDDING - I need assistance with fixing the taxonomy issues and setting up the custom taxonomies to organize my games. - The main objective here is to help me effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need l...
Money and all it takes to make it in easy steps even a 14 y/o can deal with
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
