How to insert date in database using phpJobs

...cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system can automatically award to bidded products as admin can set

I am in need of a creative professional to bring to life my vision of a futuristic, menacing, left-handed themed 'Warzone' for my upcoming hard/dark techno event. The project will encompass the following: - Creation of an appropriate, atmospheric artwork that reflects the desired theme - Designing a website that will serve as a central information hub for the event Ideally, you should have a solid background in graphic design and web development. A passion for techno music and an understanding of its culture would greatly be advantageous. Website includes: - Event Details: Date, Location, Line-up, etc. - Artist Profiles: Background information and links to music Creativity is key here, and the capacity to incite a sense of an...

Hi, We are currently looking for a talented react native developer to help us deliver our first notifications app for iphone and android. We are a web-development company that has developed a community platform that connects people and encourages them to support each other through sharing time, knowledge and support. We are looking for responses to our brief to understand the cost and time to deliver an app that will keep our community members up to date with all their community notifications. We have attached a brief and here is a link to link to an overview video: We’d love to receive responses by Wednesday the 29th May and we will aim to select a developer to work with shortly after. Best wis...

I have this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page;

...developer to join our team and help bring our exciting web project to life. As a front-end developer, you will play a crucial role in designing and implementing the user interface and user experience for our website. Key responsibilities include: 1. Translating design mockups and wireframes into high-quality code. 2. Building responsive and interactive user interfaces that engage and delight users. 3. Collaborating with back-end developers and designers to ensure seamless integration of front-end and back-end components. 4. Optimizing website performance and ensuring cross-browser compatibility. 5. Implementing best practices for accessibility and usability. 6. Testing and debugging code to identify and fix issues promptly. 7. Staying up-to-...

...looking for a skilled copyrighter to create blog articles for our website. Here I'm interested in three articles 800-1000 words each - feel free to make more engaging titles: 1. "Technologies and Frameworks Used in Online Banking Software" 2. "Benefits of building custom virtual wallet solutions into your product" - here to speak about features of virtual wallets, flexibility to convert credits in exchange for additional services, etc. 3. "Compliances and certifications that might be needed for a financial services startup" - explore main compliances for the US and European countries a fintech software startup should know about. The main goal of these articles is to educate our audience. Ther...

I'm looking for an expert in Microsoft Power Apps to develop a canvas screen for me. The screen will enable the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfort...

Payment will be paid according to each repo in MS Projects' Jira system The payment calculation will follow the actual time for each repo except the time to fix bugs.

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

Help me with existing project to optimize the performance of core functionality and add some basic new functionalities. If you're genuine bidder then please write "php&python" in starting of your bid. This is kind of urgent and need to do it in around 1-2 weeks.

Requirements: - Must be a mother tongue Dutch writer (not Flemish, for example). - Familiar with writing 'casino gambling' content is a must! - 250 words (needs to be optimized with provided keywords) - Possibility of additional tasks after completing this task - Due date: 20-5

I have a PHP site hosted, but it's unfortunately not going live as intended. I need a skilled PHP developer to troubleshoot the site, identify the issue, and implement the necessary fixes to ensure it functions correctly. Key Deliverables: - Diagnose the issue causing the site to not go live - Implement the necessary fixes to ensure the site functions as intended - Provide me with the corrected file for future installation I'm experiencing error messages when I attempt to access the site. So it's crucial to not only fix the issue but also ensure it doesn't reoccur, making the site deployment-ready. Ideal Freelancer: - Experienced PHP developer with a proven track record of troubleshooting and fixing web...

...field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date ...

I'm seeking a professional to assist me with daily tasks on my website, which integrates with my work. The ideal candidate should be able to work in the following areas: - Data Entry: This involves entering specific data into the website's database and ensuring that all entries are accurate and up to date. - Customer Support: Providing timely and helpful responses to any customer inquiries or issues that may arise on the website. - Content Creation: Generating engaging, informative content for the website to keep visitors interested and coming back for more. The purpose of the site is to assist me with my work, and I need someone who can provide this assistance on a daily basis. It's crucial that the freelancer...

I'm seeking a skilled market researcher to provide a comprehensive analysis of the potential market for a school discovery platform in the UAE. Project Title: Comprehensive Market Research for School Discovery Platform in UAE Overview: Our startup operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broad...

...of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. The candidate must have experience working on incomplete pro...

...operates a school directory platform specifically designed to assist UAE families in finding and comparing schooling options for their children. We are committed to providing innovative solutions that help parents navigate the complex educational landscape with ease. To enhance our platform's effectiveness and ensure it meets the diverse needs of all families, comprehensive market research is crucial. This research will help us gain detailed insights into our target audience, the broader industry landscape, and our competitive positioning. Scope of Work: Market Statistics: Collect up-to-date statistics on the UAE education sector, including details on student enrollments, enrollment trends, and the diversity of curricula offered (In...

We are in need of a talented designer to create a poster for an upcoming concert we are hosting in Brussels on 26/10/24. The theme of the concert revolves around bagpipes and hunting horns, and so it's crucial that the design captures the essence of these two different instruments. There will be two bands at this event: "Les Echos de Ciergnon" (Hunting Horn): "The Blue Stones Pipes and Drums"(Bagpipes): WARNING: make sure you use the right instruments in your design !!! it is a HUNTING HORN (not a French Horn) !!! The hunting horn is less sophisticated. Key Information: - The poster should include the date and time of the concert, as well as the venue location. Please review the attached document: the poster should include t...

I'm looking for a skilled and creative professional who can help me in editing my PowerPoint presentations and a video that I've compiled. The aim is to give them an up-to-date, corporate and professional look for the purpose of our website launch. Key Points: - For the PowerPoint presentations, I need someone who can help in redesigning slides. This involves the use of infographics and new age graphics to make the information visually appealing and easier to understand. There's a need to reduce text in the PPTs and replace it with infographics. Also, enhancing visuals would be a great addition. - There's also a need to edit the content for a professional tone. This means ensuring that all text is we...

I'm in need of a talented Figma designer who can craft a visually striking single page UI for my crypto project. Key Features: - Real-time market data: This is a crucial aspect of the design. It needs to be easily accessible and comprehensible to users. - Price charts and graphs: These should be clear, visually appealing, and easy to interpret. Style: - Modern: I envision the UI with a modern feel, so it appears up-to-date and in tune with current design trends. The ideal candidate for this job should have: - Proficiency in Figma: As this project involves Figma design, it's important that the designer is comfortable and skilled in working with this software. - Experience in crypto projects: Although it&...

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate u...

v2 - user can find merchant and register in their user account. after admin approve, Merchant can create shop and promotion. User will get 0.1% of their total sales, check v3. - shop field (brand name, address, website, whtasapp, facebook, description, category, City, how many brands, open for agency?(radio button)) - promotion field (title, normal price, now selling price, description, expire date, point weight - V4 user can follow shop to see their promotion in feed, also can apply to be their agent. - agent can share the promotion with uniqic referral link which will earn 2% v3 - point system- user purpose any thing will get point same as the price, usd 23.12, will get 23.12 points. if point weight is 2, then he will get 46.24 point. - when us...

I'm on a tight deadline to develop a new application using Laravel. There are some minor bugs that need to be resolved before we can move forward. Ideal Skills & Experience: - Expertise in Laravel and PHP - Proficient in resolving minor bugs - Able to work efficiently under a tight deadline - Strong communication skills, as we'll need to discuss bug resolution progress and application development milestones regularly

...strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong att...

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

I am in need of a skilled frontend developer to build the interface for my customizable meal delivery website. The website is designed to cater to users who would like to customize their meal plans as they order. Key Functionalities: - Real-time order tracking: I'd like the website to have a feature that allows users to track their orders in real time. This feature is essential for providing a great user experience, ensuring customers are up to date on their orders and can anticipate delivery times. Skills and Experience: - Proficiency in frontend development: You should have prior experience in developing user-friendly and visually appealing websites. - Familiarity with real-time tracking systems: E...

...looking for a video editor to enhance 5 educational videos (around 2-4 minutes per video). You can quote me per minute of adding in the text + the cost to add in the branding on each video. The primary goal is to insert key branding elements throughout the videos. These include: - My company's logo - A watermark - A small banner featuring the company branding at the bottom throughout the videos In addition, I would like the editor to incorporate subtitles at the bottom of the videos. The subtitles should be clear, easy to read, and complement the educational content. We will have the videos transcribed, will need you to match it up to the sound. The videos are in Spanish and English. This is im...

I have a joyous announcement to make and need the creativity of an experienced graphic designer. The design must revolve around baby-themed illustrations and should encompass a pastel color scheme to add to the cheerful atmosphere. The main specifics the design should feature include: * Baby-themed illustrations that are appealing yet subtle. * A suitable and captivating arrangement of pastel colors. Moreover, this announcement must feature the due date of the arrival of my new bundle of joy. An eye for detail and a knack for creative communication are must-have skills. Experience in designing baby announcements or similar projects will be highly preferred. Bring on your creativity and make this momentous period all the more special for us.

...skilled and experienced developer to create a Management Information System (MIS) for my supply chain operations. Critical features should include: - Order Tracking: The system should provide up-to-date information on order status and delivery dates. - Supplier Management: The software should keep track of supplier-related data including payment information. For the inventory management component, the following capabilities are imperative: - Real-Time Tracking: The system should provide instantaneous updates for inventory data. - Low Stock Alerts: The ability for the system to alert when inventory runs low is crucial. - Sales Forecasting: Incorporation of a sales forecasting tool based on inventory output and sales history is an added advantage. Exper...

...platforms to compare their offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling process. Requirements: Pricing Comparison: C...

As we venture into the development of an online store for both Instagram and Facebook, we are looking to showcase our unique product - gift paper bags and gift packing wrappers. Key tasks include: 1. Developing an online shop for two social media platforms. 2. Creating engaging, sellable designs for our products. The ideal professional for this work should not only have experience in social media store development but should also be a credible product designer. They should understand up-to-date trends and be able to make design suggestions that will appeal to our consumers. Creativity, with a keen attention to details, and experience in design related to gift packaging is also a bonus.

...needs a complete makeover. I'm looking for a developer with strong PHP skills to implement the necessary changes. Specifically, I need a talented individual to customize the theme of my WordPress website, focusing on the color scheme, layout structure, and font styles. Key Responsibilities: - Customize the color scheme of the website to align with our brand identity. - Implement changes to the layout structure of the site for improved user experience. - Modify the font styles across the website to achieve a consistent aesthetic. Ideal Skills and Experience: - Strong proficiency in PHP, with experience in WordPress. - A portfolio demonstrating successful customization of WordPress themes. - A good eye for design, with ...

I'm seeking a skilled freelancer to assist in collecting email addresses for an upcoming email marketing campaign. The ideal candidate will have experience and expertise in web scraping, particularly from social media profiles, professional networking sites, and company websites. Key Responsibilities: - Collect email addresses from social media profiles, professional networking sites, and company websites. - Ensure the collection is accurate and up-to-date. - Provide the email addresses in a well-organized manner, making it easy to integrate into our marketing campaign. Target Industries: The primary focus for this collection is media, video production, photo production, TV production, film production, and music production. This mean...

...Collaborating with the website development team and internal IT and marketing teams; * Ensuring the project is completed within the agreed timeline and budget. Proposal Working remotely with on-site presence for the initial project kick-start 16th to the 27th of May 2024 and with on-site presence half way or towards the end of the project (dates to be discussed). Fee is $25,000 per month. Initial period projected to be 3 calendar months from the 16th of May 2024 to the 16th of August 2024. If my services are required after the estimated completion date of the 15th of August then the monthly remote fee is $25,000 per month. Payment schedule First payment - 17/05/24 - HKD $20,000 (USD $2,562) Second payment - 01/07/24 - HKD $20,000 (USD $2,562) Third...

I'm looking for someone experienced in cleaning out toxic backlinks from my website. The main goal is to improve the website ranking. This task is quite urgent and needs to be completed within a day. This is a 1 hour job! Full video here explaining the job This job will also lead to other jobs, such as ranking our website, high DR backlinks, blogging, creating pages to rank for easy keywords, running keyword reports, etc. I will only respond to offers that have confirmed they have watched the video. I will not answer bot responses. Key responsibilities include: - Utilizing SemRush to identify toxic backlinks - Compiling the list of toxic backlinks in a notepad for Google Disavow backlinks tool - Ensuring that the backlinks a...

...expert to design a comprehensive report template that contains all the requisite sections for a detailed report. The ideal freelancer for this project should have: - A solid understanding of Microsoft Word. - Previous experience in creating professional templates or reports. The key sections that the report template should include are: - Title page - Table of contents - Introduction - Body - Conclusion - References Each section should be clearly defined and easy to navigate. For the title page, it should encompass the following elements: - Project title - Client's name - Date - Project logo - Project description - Title block I require standard formatting and styling for the title page and the entire document. It's crucial that the template lo...

I'm 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 ess...

Project Scope * Overseeing the development of a new website for the Client; * Launching an e-commerce store within the new website; * Creating and optimizing meta descr...Collaborating with the website development team and internal IT and marketing teams; * Ensuring the project is completed within the agreed timeline and budget. Proposal Working remotely with on-site presence for the initial project kick-start 16th to the 27th of May 2024 and with on-site presence half way or towards the end of the project (dates to be discussed). Fee is $25,000 per month. Initial period projected to be 3 calendar months from the 16th of May 2024 to the 16th of August 2024. If my services are required after the estimated completion date of the 15th of August then the mo...

...for an experienced Linux professional with a knack for data analysis to assist me with my projects. Ideally, you will possess: - In-depth knowledge and understanding of Linux as you will advise me on the suitable software to install for my tasks. - Experience dealing with numerical data. - Proficiency in data sorting, statistical analysis, and data visualization techniques as these will be a fundamental part of the job. In addition, knowing how to decode SecretKeys with the bs58 library is a crucial aspect of this project. This task represents a core operation you will be required to perform with the numerical data. Your ability to execute this function deftly will significantly impact the project's success. I am lo...

...shop of fashion jewellery on Etsy and I am based in the UK. I need to boost my jewellery shop sales and I'm looking for a skilled marketing professional who can help me with this. Key Project Details: - The main goal here is to increase sales but also build brand awareness and drive traffic to my shop on Etsy -- I currently use Facebook, Instagram, and Pinterest for promotion, but I'm open to exploring other platforms if you have suggestions - My target audience is women all over the world but especially UK,USA and rest of the Europe Ideal skills and experience for this job include: - Proven experience in social media marketing, particularly in the e-commerce space - Strong understanding of the Etsy platform and its audience...

...designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking Order Payment Order Delive...

...create an advanced chatbot for my PHP-based CRM. The key aspects of this project include: - Chatbot for Customer Support: The primary function of this chatbot will be to handle customer inquiries and provide advanced problem-solving support. - Integration with PHP CRM: The chatbot needs to seamlessly integrate with my current CRM system. - GPT AI: The preferred technology for the chatbot is GPT-based AI. - Customization: I would like the chatbot to be fully customizable and easy to program for future updates and modifications. Ideal Skills: - Proficient in PHP, GPT AI, and CRM integrations - Experience in developing advanced chatbots for customer support - Ability to create customizable and easy to progr...

I'm looking for a skilled animator to create an old style pencil animation gif for my upcoming wedding event. Key Requirements: - The animation should be in an old style pencil animation format. - The animation should be long, over 20 seconds. - It should include the couple's names, the wedding date and the wedding venue. Ideal Skills and Experience: - Proven track record of creating animated gifs, especially in the pencil animation style. - Proficiency with relevant software and tools to create and edit such animations. - Attention to detail, as the animation needs to include specific information about the event.

Hey you! Do you have more than 6 years as a Laravel Developer? Can you prove it? Can you prove/provide evidence of what you have personally done as a developer? Does compliance to high security standards, encyption at rest, encryption in transit, AES 256, SHA 256 mean something to you? Are you willing to join an existing project? Are you willing to work for a flat monthly salary? Then this job may be for you. Our team is hard at work building a web application. We currently need an additional developer to assist with some key activities. You will be assigned duties by our Application Team Leader. Shoot us a quick message if interested. No agencies or middle men please.

...RFPs related to "fiber optic" or other telecom-specific keywords, which are due every May 2024 or similar queries. - This automated search needs to run every 2-3 weeks, ensuring that I stay up-to-date with new bid opportunities and future due dates. - You should have a deep understanding of web scraping and automation to accomplish this task. Additional Information: - I would like to receive notifications about new bid opportunities via email. - The project needs to be completed as soon as possible, as I'm looking to streamline this process and stay ahead of the competition. Ideal Freelancer: - Proficient in web scraping and automation, with experience in similar projects - Strong attention t...

Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1　Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB c...

I'm in need of a seasoned SEO expert to handle the SEO requirements for my 4 real estate websites in Australia. These sites are crucial for generating leads in the commercial and residential markets. Key Tasks: - Keyword Research and Optimization: I need you to conduct thorough keyword research to target the right audience and optimize the content accordingly. - On-Page Optimization: Ensure that the on-page SEO elements are in place and up to date for all the sites. - Link Building: Build a strong backlink profile for my websites to enhance their SEO performance and increase organic traffic. Ideal Freelancer: - Proven experience in SEO for real estate websites or a similar niche. - Excellent understanding o...

...explained in the “2. Technology Description” section below. *Note Do not collect information only based on the information listed in “1. Background” and “3. Reference Information” (Sections 1 and 3 are for reference only) 【1　Background】 This is about vehicle display devices. In this device, before an autonomous vehicle overtakes an obstacle, a mark indicating the overtaking direction is displayed on the front window by a device (HUD device) that projects it. This allows people in the car to know the planned action of the autonomous vehicle in advance, and can reduce anxiety caused by the autonomous vehicle taking unexpected actions. However, with this technology, although the next planned action can be con...

...graphic designer to create a compelling Instagram post promoting our upcoming Case Breaks of the 2023 Topps Chrome Platinum Anniversary. Key Details: - The graphic should prominently feature the product details, including the name and any exciting information including key rookie players such as Corbin Carroll, Adley Rutschman, and Gunnar Henderson that would attract potential buyers. - It needs to include the date and time of the Case Break, which is next Wednesday, May 22nd at 12 PM and 3 PM EST. - The graphic should be designed in a sports-themed style, capturing the essence of the product and the thrill of collecting sports cards. - I also need our company logo and the product logo to be incorporated in an aesthetically pleasing way. Ski...

I'm looking for a freelancer to create two custom monthly payslips based on an annual salary of $105,000. The payslips will be for April & May should be professional, simple and include the following details: - Employee's name and address - Employer's name and address - Date of payment - ABN (Australian Business Number) - Year-to-date (YTD) earnings The required format is a simple and professional design without any need for color or excessive creativity. Ideal Skills and Experience: - Experience in creating payslips or financial documents - Understanding of Australian payroll standards and regulations - Ability to deliver a simple, professional design