... -> ,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(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' and TransYN='N' 주문상세 : Select productid, P_name, ori_price, Qty from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' O...
I'm in need of a well-rounded property manager. The exact nature of the properties being managed hasn't been stated, as well as tenant management responsibilities. Ideal Skills and Experience: • Property Management (Residential/Commercial) • Tenant Management Please Note: The amount of properties to be managed will be clarified later, but your experience managing different scales from s...been stated, as well as tenant management responsibilities. Ideal Skills and Experience: • Property Management (Residential/Commercial) • Tenant Management Please Note: The amount of properties to be managed will be clarified later, but your experience managing different scales from small to large will be of interest. Submit your bid indicating your experience level and...
Hi Nida, I have another small job that I would love your help with. It is just a matter of adding and styling a small table in the word template that you previously created for me. I will send you an example of the styling we want and the table content.
We are currently advancing two web-based projects, each with potential for future expansion depending on client satisfaction and ongoing evaluations. Project 1: Integration and API Development This project involves creating a synchronized customer table accessible via both web and mobile applications, and developing and integrating APIs. We also need to enable the functionality to preview and download existing quotes via the web and mobile applications. Additionally, assisting the client in installing the latest version on their local host to facilitate their participation in the testing process. Project 2: Software Enhancement and Bug Resolution Our second project is a comprehensive web-based software developed using HTML, Bootstrap, PHP, Laravel, and MySQL. We are not aiming to ...
...efficiently and meets agreed on deadlines Completes most development activities independently Requirements Core Requirements: Strong background in data warehousing concepts, ETL development, data modeling, metadata management and data quality Strong knowledge of SQL running on SQL Server, MySQL, and Snowflake including but not limited to: extensive experience working with complex stored procedures, table definitions, and a proven track-record of performance optimizations and troubleshooting of SQL logic. Proficient at C# running on .NET Core and/or other similar .NET frameworks including but not limited to: writing Unit Tests and implementing algorithms and data structures Strong hands on experience in Microservices, RESTful webservices development in Java (Spring Boot or equiv...
...contractor and a W-9 IRS form will be filled out. • Potential for ongoing projects and long-term collaboration as new products are continuously introduced. About Me: I am experienced in photography, highly creative, and well-versed in digital editing tools. Known for my fun and quirky approach, I value originality and am eager to work alongside someone who can bring fresh ideas to the table. START DATE: ASAP How to Apply: If you're interested in this exciting opportunity, please contact me....
I need a freelancer to convert a PDF file into a Word document while preserving its basic text formatting. Additionally, I would like the freelancer to create a table of contents in the Word document. The ideal candidate should be proficient in: - PDF to Word conversion - Basic text formatting in Word - Creating tables of contents in Word It is important that the freelancer maintains the integrity of the document's formatting during the conversion process.
...Description: We are in need of an expert developer to create a dynamic ecommerce platform focusing on digital goods and services. The project entails building three main sectors: Front-end Development: Implement user authentication, service listing, and seamless communication with the backend via API. Supplier Backend: Develop functionalities for suppliers to manage products, process orders, and handle cancellations efficiently. Admin Backend: Construct a robust admin panel to oversee order processing, site settings, and overall platform management. System Overview: Showcase popular services through a slider on the front end, adjustable by the admin. Customize service display based on date, name, or cost, with admin control. Implement a commission ...
I am in need of an automated solution for a task I currently undertake on a daily basis. The task involves merging sales data from two spreadsheets to create one consolidated spreadsheet. This...I currently undertake on a daily basis. The task involves merging sales data from two spreadsheets to create one consolidated spreadsheet. This crucial operation currently takes me about an hour every day, and I am seeking assistance to build an efficient process, ideally through a script, that can handle this for me. The end result will be a daily spreadsheet detailing which locations are owed orders. Ideal Skills and Experience: - Proficiency in Excel and creating Excel scripts - Knowledge of sales data and data merging - Ability to automate manual tasks - Attention to detail with data...
...looking for a capable .NET developer to create a WebAPI using the Visual Studio template "WebApi Net core (Minimal api)". It needs to have Authentication and Authorization in place, using the X-API-Key. Key Requirements: - Authentication and Authorization: You need to enable X-API-Key based authentication and authorization for this WebAPI. - Data Model: The WebAPI will manage a simple 'City' table, performing basic CRUD operations. Expectations: - The X-API-Key should be hardcoded in the application. - The WebAPI should be developed using .NET 8.0 and the Visual Studio template "WebApi Net core (Minimal api)". - Data access should be implemented using EFCore. - Authorization should be handled through middleware. Ideal Skills and Experience: - ...
I am seeking an experienced .NET developer to build a highly dynamic REST API using the .NET 8 framework. The API will be designed to manage interactions with a database using a single, generic controller capable of handling all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic cont...
...Description: We are in need of an expert developer to create a dynamic ecommerce platform focusing on digital goods and services. The project entails building three main sectors: Front-end Development: Implement user authentication, service listing, and seamless communication with the backend via API. Supplier Backend: Develop functionalities for suppliers to manage products, process orders, and handle cancellations efficiently. Admin Backend: Construct a robust admin panel to oversee order processing, site settings, and overall platform management. System Overview: Showcase popular services through a slider on the front end, adjustable by the admin. Customize service display based on date, name, or cost, with admin control. Implement a commission ...
...menu navigation to be more intuitive and interactive for users. - Restaurant Listing: Improving the restaurant listing functionality for better accessibility and user experience. - Live order tracking: Implementing or refining the live order tracking feature for users to easily track their orders. - Push Notifications: Ensuring that push notifications are working effectively and engaging users timely. - Order Placement: Enhancing the order placement process for users to smoothly and seamlessly place their orders. I will provide the design assets for the user interface enhancements, so you will be responsible for translating these into the iOS version. Ideal skills and experience for this project: - Proficient in Flutter and Dart programming - Extensive experience with i...
...feature that tracks partner activities, sales, and commissions. - Communication & Marketing Tools: The system should include tools for email marketing, social media sharing and posting, and SMS marketing capabilities. Mobile App Features: - User Registration and Login: Seamless sign-up and login process for users. - Product Catalog and Ordering: A digital catalog of products and the ability to place orders directly from the app. - Sales Tracking and Reporting: Users should be able to view their sales data and commissions. - Access to Training Resources: The app should provide access to training materials and resources. - Push Notifications: Feature for sending important notifications and updates to users. Ideal Skills and Experience: - Strong background in developing networ...
I'm looking for an experienced developer to integrate WHMCS API with the AutoVM Product module. The main aim of the project is to enable our clients to manage their services efficiently. Key Requirements: - The ability for clients to create orders. - The ability for clients to view services. - The ability for clients to start/stop/reboot services. - Limited integration with the AutoVM Product module for specific functionalities. Ideal Skills: - Proficient in WHMCS API and AutoVM Product module. - Excellent understanding of creating order functionalities. - Strong experience in service management. - Proven track record of integrating systems. - Familiarity with resource monitoring and email notifications in a hosting environment would be a plus. Please only apply if you ha...
Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression of external...Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation material (PP...
Detailed overall drawings will be provided ① Production of frame model - Basement of the first basement floor and first floor above ground, designated expression - Expression of floor level difference between the 2nd and 6th floors above ground - Expression...Production of detailed reinforcement model - Column, girder, beam (at least 1, reinforcement spacing doubled) - Foundation, slab (only partial representation) ③ RC beam bending, shear analysis and design ④ Preparation of detailed labor distribution model (planned) schedule ⑤ Detailed reinforcement model (planned) construction cost estimation - Quantity calculation basis, work type statement, tally table, bar chart - Scheduled for final presentation - actual comparison ⑥ Preparation of final presentation material (PP...
...Location: Remote Job Description: We are seeking a detail-oriented and organized individual to join our team as a Data Entry Specialist, specializing in QuickBooks. The ideal candidate will be responsible for accurately entering data from purchase orders into QuickBooks, ensuring that all information is correctly documented and categorized. This role requires strong attention to detail, proficiency in QuickBooks software, and the ability to work efficiently to meet deadlines. Key Responsibilities: Accurately input data from purchase orders into QuickBooks, including but not limited to vendor information, item details, quantities, and prices. Verify the accuracy of all entered data to ensure consistency and completeness. Categorize transactions appropriately based on co...
Dear Freelancer, I have a little task for a video editing professional that is done very fast. Right now I have 37 short clips that need to be converted from 16:9 format to YouTube shorts format (9:16, 1920x1080px) In these videos you can see interview clips of two people sitting at a table. There are a total of three camera perspectives: - Presenter - Interview guest - Both at one table This task is about adapting the scenes by recutting the image in which both people can be seen at the table so that - the person speaking is always shown and - the reaction of the interviewee is briefly shown in the case of special reactions The overall result is that these interview sequences should be prepared for YouTube Shorts/TikTok in a high quality, in which the co...
I'm on the lookout for a skilled Shopify developer to construct a custom template for my upcoming e-commerce store. Key requirements for the project are as follows: - The template should accommodate between 5 and 10 pages. - It will be for a store featuring physical goods. - I would like a landing page similar to t...Customer review features - Size/color selection options - Product videos - Selection based on product type (e.g. red, black, blue) The ideal candidate for this project has a solid experience in Shopify development and a keen eye for detail. A strong understanding of the platform and its functions is a must, as are good design skills and the ability to bring creative solutions to the table. Please provide examples of similar projects you've co...
We need a salesforce commerce expert who can perform the work listed below. Of course, this is ...“Send offer” a price must be entered, some checkboxes and a text field) - The request is then moved to the “Processed requests” tab - Tab “Processed requests” - Here you have the option to click on “Receive order”. The request is then moved to the “Orders” tab - Orders” tab -Here you will find orders that have been won “Admin area” - All requests can be viewed here - The requests are distributed to various partner workshops. - We can see if a lead has been marked as “Order received” or “Order placed” by the workshop or the customer (table with different colu...
I need a skilled freelancer who can efficiently convert a Google Doc into a Word document. -Significant to the project is maintaining all existing styles and formats on the Google Doc in the converted Word document. -A table of contents is required to be added to the Word file. -A sound understanding of Google Docs and Microsoft Word is ideal, with emphasis on expertise in style preservation during conversion.
...The selected freelancer will be responsible for establishing a robust connection between the algorithm and the trading platform's API, ensuring timely and accurate execution of orders. Key tasks include: 1) API Integration: Configure and establish a secure connection between the algorithm and the trading platform's API, allowing for seamless communication and trade execution. 2) Signal Translation: Develop a mechanism to interpret buy and sell signals generated by the algorithm and translate them into executable orders on the trading platform. 3) Order Placement: Implement functionality to automatically place orders based on predefined criteria, including quantity, price, and order type. 4) Testing and Optimization: Conduct thorough testing to validate t...
I am seeking an individual proficient in converting PDF files into editable Word documents with a specific focus on maintaining table formats. Key Tasks: 1. Convert multiple PDF files to Word documents. 2. Accurately transfer tables from PDFs to Word, ensuring the original formatting is maintained. Ideal Candidate: - Experienced in PDF to Word conversion - Detail oriented with strong formatting skills - Previous work successfully converting tables from PDFs to Word.
The objective is to design an height adjustable study table with a 3D Model and a 2D (including BOM / Cost for the same) The weight needs to be checked and the manufacturing cost for the same.
...in combining multiple Excel slicers into one for our data analysis needs. The requirement is, I want to use same Slicer for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation process and enhance the overa...
I'm looking for an expert Flutter developer to build a fleet management app that focuses primarily on vehicle tracking. This should include: - Real-time tracking: I want to be able to view on a map where each vehicle is at any given moment. You should have experience in implementing GPS or similar tracking systems. - Dispatching orders: The application needs to feature automated assignment of orders to optimize the utilization of our fleet, without the need for human interaction. Having experience in building algorithms for efficient order dispatching would be ideal. - Extensive fleet management experience: As this is quite specific, I would prefer someone with prior experience in developing fleet management apps or someone who can demonstrate a strong understanding o...
I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in wordpress e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70
I am seeking a digital marketing professional who can help me enhance my brand visibility, ramp up web traffic, and generate leads via Facebook and Instagram. I need someone who has a knack for curating targeted content for a diverse audience, particularly those aged 18-55. - Key Responsibilities: * Develop and execute a results-oriented social media strategy. * Create engaging, relevan... * Extensive experience in social media management, specifically with Facebook and Instagram. * Proficiency in performance marketing and lead generation. * Demonstrated experience managing campaigns targeting the 18-44 age demographic. Your expertise in these areas will be crucial to achieving our marketing objectives. I can't wait to see the innovative strategies you'll bring ...
I am in need of an experienced digital marketing specialist to assist with managing my social media and content marketing activities. This job will also involve aspects of performance marketing. - Responsibilities: -- Managing our social media profiles, primarily on Facebook and Instagram -- Crafting engaging content for our target audience -- Running performance marketing campaigns...marketing campaigns - The ideal candidate should have: -- Proven experience in social media management and content marketing -- A solid understanding of performance marketing -- Ability to implement strategies to increase brand awareness and generate leads I anticipate working with someone who not only executes these tasks effectively but also brings fresh insights and a proactive approach to the ...
...should be able to create accounts and sign in to access their personal information and history. - E-commerce Capabilities: The platform will host between 50 to 200 products. Each product will need to have its own page with detailed descriptions, pricing, and an option to add to cart. - Content Management System: I will need to be able to easily update product listings, add new items, and manage orders. The ideal candidate for this project should have: - Previous experience with fullstack web development, especially on e-commerce platforms. - Proficiency in modern web technologies and frameworks. - A strong understanding of security and best practices in online retail. - Excellent communication skills and a proactive approach to problem-solving. Please provide examples of your ...
I need customer order web application. (No customer access, no payment processing). MUST be responsive design between computer/ tablet /phone. It must be able to print from iPad , iPhone etc. ( PDF print) It needs to have clean design UI. Preferred hosting on Linux web server (hosting provider) Application would be used to enter customer orders that are taken over the phone or in person. (Employee will enter customers info and order) (NO PAYMENT processing or customer access) Employee and admin level (Employee cannot delete order, only void) Customer (First Name, Last Name, Phone Number, Note ) (Option to import/export customers would be great) (from Excel file) Item/Product: (Product Category, Product name, SKU, Price) (Option to import/export Products from Excel file) woul...
As a design student, I have sketched a table design, and now need assistance to bring it to life through Fusion360. Key tasks for you will include: - 3D Modeling: I'll need you to take my sketches, which are partially available from different perspectives, and use them to create a 3D model with a medium level of detail. - Rendering: After the 3D model is completed, I'll require rendering services to provide a realistic visualization of the table design. - Assembly: The last phase of the project will be the assembly, where you will put together the individual components of the table in Fusion360. Ideally, you should have extensive experience with Fusion360, particularly in 3D modeling, rendering, and assembly. Being able to work from partial sketches a...
I'm in need of a WordPress expert to assist with a complete overhaul and custom design of my theme. I...complete overhaul and custom design - Experience with e-commerce integration and management - Implementation of membership registration and management functionalities Your role in this project will be crucial to the success of my website, so I’m looking for an experienced professional who can not only deliver on the technical side of things, but also bring creative ideas and suggestions to the table. Please note that your familiarity with best practices in user experience (UX) and search engine optimization (SEO) will be highly valued. If you have prior experience with similar projects, please provide relevant examples in your application. I'm looking forward to...
I'm in need of an animator who can bring life to 20 cartoon illustrations. The style I'm looking for is motion graphics, rather than traditional 2D or 3D animation. The animations will serve an educational purpose, so it's crucial that the freelancer can maintain a balance between engaging visuals and...for an animator with: - Strong experience in motion graphics animation - A portfolio that demonstrates their skills in creating educational content - An understanding of how to engage an adult audience through animation - Excellent communication skills to understand the specific educational content and intent behind each illustration. The freelancer should be able to bring creative ideas to the table and work collaboratively to ensure the animations meet the project&...
I need a proficient excel expert to help me with a data entry project. The data involves simply names, emails, and phone numbers. It will be a table with 100-500 entries, so proficiency in data entry and Excel is crucial. Key Requirements: - Accurate Data Entry: The job is primarily about accurately transferring names, emails, and phone numbers from a document to an Excel sheet. - Excel Proficiency: Knowledge of Excel functions is a plus, though not specifically required. You should be comfortable working with a table of this size.
I have worked with a designer and now have the step and stl files for an item I would like to move into the mfg stage. Format is 18*24" rougly and 3d print was welded together. Would like to prototype and mfg a few at first then possibly move to large orders. Think of a doggie door basically,
I'm seeking a talented digital illustrator to create a custom piece of artwork in celebration of our 59th anniversary. Key Responsibilities: - Create a unique, high-quality digital illustration suitable for printing - Incorporate the essence of long-lasting relationships, love, and celebrations int...experience in digital illustration - Strong understanding of design principles and techniques - Ability to create original, captivating concepts - Experience in creating artwork for special occasions or anniversaries is a plus. Please note that while I have not specified a particular style, I am open to suggestions and looking for a professional who can bring their creativity and expertise to the table. Looking forward to seeing your proposals and finding the perfect artist fo...
I need a trading bot designed to work with the Ethereum cryptocurrency on Base network on the Uniswap V2 platform. This bot should be set to automatically buy and sell ETH at specific intervals without human intervention. Key Features: - Automatic Buying/Selling: The bot should automatically execute buy and sell orders based on the parameters set - Time Interval Trigger: Trading actions should be triggered based on specific time intervals, and not based on price or trend. Ideal Skills and Experience: - Proficiency in Ethereum and Uniswap V2 - Experience in designing and implementing trading bots - Understanding of automated trading strategies - Proven track record of bot development in the crypto space - Ability to deliver a reliable and secure trading solution. Th...
I need a skilled freelancer to develop a web-based application for my restaurant staff. Main Functionality - Taking orders - Updating menus Key Qualifications: - Proven experience designing and developing web-based applications - Understanding of restaurant operations and workflows would be a plus - An ability to make the interface minimalistic, easy-to-use, and clear-cut Please note, the app doesn't require integration with any existing restaurant management systems but should be meticulously implemented to handle essential ones. A successful build will streamline my restaurant operations effectively.
I'm in need of a Python developer with a focus on machine learning and AI. Your primary task will be to design and implement machine learning algorithms for our project. I'm looking for someone who can bring both technical skill and creative problem-solving to the table. Ideal Skills and Experience: - Strong Python programming skills - Proven experience in machine learning and AI - Previous project experience in this area I'm open to discussing the project, solving problems, and communicating progress. Looking forward to working with you.
...business professionals. Understanding the demographics and behaviors of this group will be crucial in crafting effective content and engagement strategies for the campaign. - While I do have specific goals in mind, I'm also open to hearing your suggestions and ideas on how to make this campaign more effective. I'm looking for a proactive and creative individual who can bring fresh perspectives to the table. Ideal Background: - Proven experience in social media marketing, particularly with a focus on Facebook, Instagram, and Twitter. - Demonstrable success in increasing brand visibility, driving web traffic, and generating leads/sales. - Experience in targeting and engaging with business professionals on social media platforms. - Excellent communication and collaborati...
I'm looking for an ex...experienced app developer who can create a dual-platform e-commerce application. The application should be designed for both iOS and Android. Key Features: - Shopping Cart: The app should allow users to add items to their cart, make changes and proceed to checkout seamlessly. - User Profiles: Users should be able to create and manage their profiles, helping them to save their preferences, track their orders, and get personalized recommendations. - Payment Gateway Integration: The app should have a secure and seamless payment system for various online payment methods. The developer should have prior experience in e-commerce app development, with a deep understanding of the user experience and design principles. Experience with both iOS and Android platf...
I'm in need of a Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as follows: - Develop a Python solution in form of a Jupyter Notebook - Preferable use of the libraries PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlu...Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysis. Whoever can most efficiently extract (using Python) the contents table from p.2 of the attached PDF (an Annual Report), with page numbers and corresponding section titles, wi...
Our manufacturing company is seeking a proficient app developer who can take our existing work orders onto a tablet platform. The application will function as a means for our employees to access, update and input additional information into work orders. A direct connection to our SQL server is essential. The app should have the following key features: - Access and view work orders: Our employees should be able to easily browse and access the work orders. - Update work orders: A functionality to update the status of work orders is pivotal. - Add additional information: The app must also enable employees to input further necessary information into the work orders. Minimum qualifications include: - Proficient in app development. - Famil...
I'm seeking a talented graphic designer who can create harmonious and compelling designs for various print materials - namely a table top display, table cover, brochure, flyer, and business card. Table Top Display: - Execute a design incorporating my company's logo and name, along with details about the products or services we offer. Please also include clear reference to our contact information. - The table cover should be sized for a 8-foot table. 2 Flyers: - These should be in line aesthetically with the design elements used in the table top display and table cover. The exact content details will be provided once you're selected for the project. Skills & Experience: - Proven experience in graphic design, partic...
I am looking for a developer with a focus on backend operations and experience with C#, MSSQL, and WordPress eCommerce integrations. The primary task is deduct stock in azure ms sql stock table when order placed in e commerce create comand for performa invoice when order placed in e commerce Key Skills Required: - Strong experience with MSSQL and WordPress - Expertise in inventory management system integrations - Understands the intricacies of WordPress eCommerce platforms budget $70
...developer who can create a fully functional Android app similar to Blinkit. While I will be providing the design assets, the selected freelancer will be responsible for translating these into a comprehensive and intuitive user interface. Key Features: - Ordering groceries: The app should allow users to browse a selection of products and place orders seamlessly. - Order tracking: An essential feature that enables users to monitor the status of their orders in real-time. - Product browsing: A smooth and visually appealing interface that facilitates easy product discovery and selection. Ideal Skills & Experience: - Proven experience in Android app development, preferably with e-commerce or grocery delivery app projects. - Strong UI/UX design background to effectively tr...
