Mysql tree structure queryроботи

Володимир, привіт! ми помітили, що ти опубліковав на гітхабі сорс код, що був розроблений Плейтеком. Ти не міг би його видалити? як можна з тобою звязатись і обговорити це питання? Сергій @ 0663623042

Front: Vuejs3 (routing, vuetify) Back-API: flask( SQLAlchemy, flask-restful, uwsgi), jwt, mysql Нужно реализовать SPA. Два типа пользователей (юзер, админ), доступ к SPA только после авторизации (пара логин/пароль). Для юзера: (страница №1) - реализовать поиск по базе данных, поиск по всех полях (отдельно по дате, фио, заказу), предусмотреть последующую фильтрацию результатов пользователем (фильтрация: пользователь вводит текстовую строку и если она может быть включением любой ячейки своей колонки результата поиска то отображается, остальные прячем), предусмотреть пагинацию. (страница №2) - как и страницы №1, но база другая, поля базы совпадают. Для админа: добавление новых юзеров админом, и доступ к функционалу описанному у юзера. База данных: ФИО (текстовое), ДатаРожд...

Для нашого онлайн ...найсучасніших веб-технологій для різних пристроїв (мобільних, планшетів) Профіль: • Хороші знання з програмного забезпечення (об'єктно-орієнтований дизайн, шаблони проектування, тестування) • самостійна робота та вирішення проблем • високий рівень мотивації • Досвід роботи з PHP, Symfony, Laravel або Zend, є перевагою • Вільне володіння німецькою чи англійською мовами • Дуже хороші знання PHP, MySQL та JavaScript • Добре знання HTML (5) та CSS (3)

Будь ласка, вкажіть 1-3 проекти, де Ви працювали із таксономіями (WordPress) та як Ви їх застосовували, де робили кастомну адмінку PHP+MySQL. Очікую на оцінку вартості та термінів, або уточнювальних запитань. Посилання на ТЗ:

Потрібно розгорнути на віртуальному сервері 1. веб сервер (apache/nginx/ +PHP) 2. СУБД (mysql/postgresql) 3. сам сайт

1) Є портали відкритих даних. наприклад 2) Потрібно розробити засоби завантаження відкритих наборів даних. вимоги: 1) Веб рішення (далі сервіс). на базі наприклад PostgreSQL / MySQL 2) конфігурація процесу завантаження конкретного набору даних: - даємо посилання на набір даних - Сервіс парсить структуру - на підставі парсинга конфігуруємо таблицю БД, куди будемо завантажувати дані - вказуємо періодичність завантаження даних - зберігаємо конфігурацію. 3) Сервіс повинен виконувати завантаження за розкладом. 4) Сервіс веде лог завантаження 5) Перегляд інформації повинен мати: графік та лог завантаження, таблицю з даними, конфігурацію процесу(тобто url, тип файлу)

творити графік який буде поєднувати в собі heat map та tree map з ієрархією, але не більше 3 рівнів: графік представляє собою набір прямокутників площа яких віповідає значенню показнику value_x, а колір значенню показнику value_y. Кожен такий прямокутник може містити в собі дочірні елементи які являють собою такі самі прямокутники. Дані для графіку будуть змінюватися кожні 15 секунд - графік має швидко рендериться. Графік має генерувати наступні події з передачею інформації про прямокинк взаємодія з яким відбувається: # click; # mouse enter; # mouse leave; # touch. Наведення мишки на дочірній прямокутник має змінювати оформлення батьківського елементу (hover effect). Реалізувати за допомогою оброблення mouse enter/mouse leave - це дасть змогу одночасно кастамізувати ефект. Графік ма...

Потрібно зробити легкі лабораторні роботи, терміново! Файли прикріпив, за потребою скину методичку.

Привіт chnazar, бачив твоє резюме на рахунок пошуку роботи якщо тебі цікавий довготривалий проект (PHP,JS,HTML,CSS,MySQL) можемо обговорити деталі

I need assistance with a residential building design project. The ...for a front dormer addition (19.25'x7') to my existing roof. Skills and Experience: - Proficient in latest CAD/CAM software - Solid understanding of building codes and regulations - Proven track record in residential building design including remodeling. - Deep appreciation and understanding of dormer architecture and aesthetics. Brief: - I am looking for structural detailing for the roof structure, floor and walls for a proposed gabled dormer which architectural drawings are already completed. - Attention to detail, as well as creating a design able to transfer building loads satisfactorily while achieving the much desired front-end gable. Your bid should include samples of previous work, timeline, a...

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can upgrade sales and users modules in our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.

I'm seeking an experienced Moodle plugin developer for personal use. The main requirement is to ensure that the plugin fosters good user interface with functionalities that can make it modern and clean. Here are the project's details: -The idea for the plugin is that it ...foundation with the online text replacing the pdf panel (left) and the feedback panel (right) will instead store instructor provided resources such as assignment-relevant description, links, and most importantly, the assignment rubric for easy viewing. - The plugin should have a good user interface. This will significantly improve user experience and interaction with the platform. - Only barebones structure for the plugin is required Key skills and experience needed: - Extensive experience in Moodl...

-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static method. for the other two: summary of the regression analysis for the static method. The o...

I have a web scraper script that needs fixing. It's designed to scrape various URLs from the Apollo website. Key Requirements: - Scraper debugging: The script is currently not worki...successfully pull the data from the selected URLs on Apollo website. Experience with: - Web Scraping: Previous experience in web scraping is essential, as the data needs to be pulled accurately from this specific website. - Script Debugging: Ability to identify and fix issues within an existing script. - Proficiency in Python or relevant language for web scraping. - Knowledge of Apollo website structure. Please make sure your bid includes information on how you plan to approach fixing this script. Open to suggestions on alternative approaches as well, as long as they can meet the required d...

I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to detail are paramount on this project.

Olá, tenho um sistema simples de gestão feito em PHP com BD em MySQL, gostaria de converter esse BD para trabalhar de forma Multi Tenant (varias empresas no mesmo banco de dados em uma unica instalação), e tambem criar um painel administrativo para ativar e desativar essas empresas.

I’m seeking a skilled developer to convert my existing PortVB Desktop App into an iOS/Mac Desktop App. It a small tool that runs on a Windows PC and reads some flat XML files and inserts/updates a mySQL database. We need the same program to be able run on a iOS/Mac desktop. I have all the VB Project files/ Source code. - Skills in app development for iOS/Mac, ideally with previous experience in app conversion - Knowledge of data syncing, user authentication, and offline access, in case these features need to be incorporated - Familiarity with contacts management, communication, scheduling, calendar integration, and file/document management functionalities for potential focus areas - Creative design skills to potentially revamp the user interface and overall design of t...

I'm seeking a mathematician to help me write up a theory focusing on algebra and geometry for publication. Key Requirements: - Your expertise in homomorphism, structure preservation and transition within the realms of algebra and geometry. - Ability to provide a detailed explanation of the mathematical theory, including examples to aid in understanding. - Past work with a similar focus, showcasing your capabilities in this area. In your application, please provide examples of your past work in the field of algebra and geometry, along with any relevant experience you have in publishing mathematical theories. I'm looking for a highly detailed and engaging explanation of the theory that can be shared in a publication.

I am searching for an experienced copyeditor to refine a Science Fiction/Fantasy novel of mine. The manuscript is of moderate length, ranging between 50,000 and 100,000 words. Task Details: - Proofread and correct all grammatical, spelling, and punctuation errors. Ideal Candidate: - Must be proficient in English language and grammar. - Has deep knowledge and...language and grammar. - Has deep knowledge and interest in the Science Fiction/Fantasy genre, thereby understanding its tropes and norms. - Preferable experience in copyediting novels, especially within the aforementioned genre. - Work must be done by a human Please note, this project primarily focuses on fixing errors in language mechanics and does not require extensive alterations in sentence structure or any sort of ...

I'm in need of a professional structural editor for my non-fiction manuscript which is more than 100 pages long. - This role involves potentially significant rearrangement of text for improved readability, clarity, and structure. - If you have prior experience in structural editing, specifically with non-fiction books, your expertise would be immensely valuable. - I'd additionally appreciate any constructive feedback to enhance the overall storytelling and narrative cohesion. Looking forward to finding an editor who can really delve into my manuscript's structure and help refine it into a polished final piece.

I'm in need of a professional structural editor for my non-fiction manuscript which is more than 100 pages long. - This role involves potentially significant rearrangement of text for improved readability, clarity, and structure. - If you have prior experience in structural editing, specifically with non-fiction books, your expertise would be immensely valuable. - I'd additionally appreciate any constructive feedback to enhance the overall storytelling and narrative cohesion. Looking forward to finding an editor who can really delve into my manuscript's structure and help refine it into a polished final piece.

...messaging services to handle asynchronous communications, ensuring efficient and reliable data exchange across system components. SDK Development - Develop and maintain an SDK that provides third-party developers with the tools needed to integrate their AI bots or other services with our platform, including comprehensive documentation and support. Database Management - Manage and optimize MySQL database interactions within the WordPress environment, ensuring efficient data retrieval and storage. System Integration and Testing - Oversee the integration of all system components, employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides...

I'm in need of an experienced Linux and Server Admin who can help me with the following tasks: - Linux and Server Administration: Proficient in CentOS, you'll be managing my server and ensuring its optimal performance. - Web and App Installation: You'll be responsible for installing and configuring various websites - coded in PHP, Node.js, and Rea...administration, and web/app installation. Proficiency in PHP, Flutter, and React Native is required. ------------------------------------------------------------------------------------------ Should have experience in linux VPS, setting up sites apps email dns firewall NO CPANEL. All work to be done using command line Sites are in php wordpress Node React Apps are in React Native Flutter Database: Mysql/mongo Amt pos...

As a rural property owner, I'm seeking an experienced architect with proficiency in creating a farmhouse home design. My requirement is for a detail-oriented professional who can visualize and bring to life a design for a small, classic, residential structure comprising of 1-3 rooms. Key skills and experience needed include an understanding of classic design elements, SIP building components, and modern residential construction techniques. The successful candidate should be able to showcase a portfolio comprising of similar works. Design would be giving to a SIP manufacturer. Please bid considering these aspects.

I need a Python program to parse a JSON file and format it correctly to be JSON compliant. Key Requirements: - Input Data: The input data is in JSON format. - Output Data: The JSON output should be properly formatted and adhere to a specific schema or structure. Skills and Experience Required: - Proficiency in Python programming. - Strong understanding of JSON parsing and formatting. - Experience in adhering to specific JSON schemas or structures. Please let me know your experience in similar projects and any relevant information that would make you a strong candidate for this job. You will pass the name of the input file as an argument and the output file should be the same file name with the .output extension. The input file is attached. Pay attention to the backslashes (&...

...complex systems with multiple user roles The successful candidate should be able to deliver a high quality, user-friendly system within a reasonable timeframe. 1. Quiz manager: Implement a quiz online app You, as a user, you can login(or register) and make quizzes from a variety of domains. You can choose the domain for the questions. After the quiz is finished the user will receive a score. Structure (minimum requirements): Register page: a form with the necessary data Login page: a form with login details Quiz page: the quiz area (you can use cards) contact form On all pages: the user can change the theme: dark vs light the user can change the language: en or ro it will be responsive at least on mobile. Recommendation: Data should come via an api call Nice to have: ...

I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.

...fully functional with the capacity to capture all the necessary details. Implement an online CV The site will consists of 2 parts: user area As a user I can view the CV and also be able to download it. admin area This page is protected by a login From here I can add multiple languages and add translation for each language From here I can also change the text that is displayed on the page Structure for page (minimum requirements): Page: header biography portfolio contact form footer At least 3 different animations are used The user can change the theme: dark vs light The user can change the language: at least en and ro It will be responsive at least on mobile. Recommendation: Text that will be translated based on language should come via an api call Nice to have: Use ...

I'm seeking knowledgeable professionals to provide accurate structural calculations and plans for a vast commercial warehouse exceeding 10,000 square feet. The project demands vast knowledge and experience in large-scale commercial building design conforming to local building codes and standards. You should have: - Proven expertise in commercial building design, particularly warehouses a...have: - Proven expertise in commercial building design, particularly warehouses and racking system - Strong understanding of building codes and standards. - Ability to communicate effectively and provide clear, comprehensive plans. Your responsibility will be: - Developing structural calculations that adhere to safety and local building codes. - Creating detailed plans for the entire warehouse ...

Hello, I'm looking for a web developer to review and correct the structure of my project. The container, where all the site's content will be, should be 1100px and centered. The font hierarchy should also be corrected and the site should be responsive. In the files, you can see the reference of the main pages for desktop and mobile. It should also be applied to the pages of the three projects.

...exhaustive du TAGE MAGE. Ce test est un examen standardisé, composé de divers sous-tests, utilisé pour l'évaluation des compétences managériales et de logique. Objectifs et Fonctionnalités Principales : Développement d'une Landing Page intégrant vidéo introductive, options d'inscription et de connexion. Intégration de paiement sécurisée avec STRIPE, nécessitant la création de comptes utilisateurs. Structure modulaire du site pour les cours, entraînements et tests blancs, avec redirection vers un sous-domaine post-authentification. Système de cours proposant des vidéos et fiches PDF, organisés par sous-tests. Modules d’entra&ici...

I have less than 1...medical notes that I need transcribed into a custom template. This project is urgent, and I require the completed transcription in less than a week. Please read this entire ad before replying. NOT FOR AUTOMATED - hand transcribing job. Key Requirements: - Transcription of less than 100 pages of handwritten medical notes and computer printouts. - Custom template formatting (specific layout or structure) - Urgent turnaround time of less than a week Ideal Skills and Experience: - Experience in medical transcription to ensure accuracy and understanding of terminology - Proficiency in creating and working with custom templates - Ability to work under pressure and meet tight deadlines So that I know you are a real person and read this, please start with your favo...

I need an expert to transfer my TeamUp calendar to while maintaining the current color coding and sub-calendar structures. Key Requirements: - Migrate TeamUp Calendar to - Preserve existing color coding - Maintain sub-calendar structure - Ensure event descriptions are carried over accurately Ideal Skills: - Proficiency with TeamUp and - Experience in calendar migration - Understanding of color coding and sub-calendar maintenance - Attention to detail in data transfer Please let me know your experience with similar projects and provide a proposal for the migration process.

...article, readers will need to register an account. Service is free of charge. a demo website will be available soon for more calrity. Key Components: - Market Analysis and Strategy: The plan should include an in-depth market analysis and outline our strategic approach to reaching and engaging our target audience. - Operational Plan and Technology Requirements: You'll need to detail the operational structure, technology stack, and any other technical prerequisites. - Financial Projections and Funding Needs: I’m looking for a detailed financial analysis and projections, as well as an outline of our funding needs and potential sources. - Human and Non-Human Resources: The plan should cover the staffing requirements, including translators, editors, and project managers, a...

...create sample data for demonstration purposes. Responsibilities: Collaborate with our CRM team to understand our current processes and requirements. Conduct thorough research and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the content logically for efficient reference. Maintain consistency in writing style, tone, and formatting across all documentation. Study the agency website () to understand the services and sub-services provided. Set up a full database of minimum 30 to 40 demo clients or sample clients in the GrowCRM system, covering all stages from leads to task completion, payment, and ticket

I am looking for a freelancer who can help me with simple copy-paste tasks for my website. Key Responsibilities: - Copying text content from various sources and pasting them onto the website - Ensuring correct placement of the text within the website's structure Ideal Skills and Experience: - Proficiency in basic web browsing and text editing - Attention to detail for precise copying and pasting - Prior experience with content management systems (CMS) is a plus, but not required This is a straightforward job that doesn't require any formatting skills, just the ability to accurately copy and paste. The selected freelancer can expect ongoing work based on performance. Here is walkthrough of task. We expect 2-3 Lessons per hour on average for fulltime work.

hello , i currently have my app in playstore up and running. but, i have created this app in drag and drop builder ( Kodular ). which have so much limitations as well, i am unable to push notifications for the new content. I am looking for someone who can convert or build same app with same interface and structure . What you have to do ? - Convert whole app from kodular to android studio. ( don't want any trace of the app ) - optimize app and UI for higher fill rate of ads. ( i am using FB ads to earn revenue ) - I will share API key once project done. - Allow me to easily update news or content from my PC ( Easy Backend ). - Add one more page to upload my youtube videos into app or into content like blogpost.

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I need an expert to transfer my TeamUp calendar to while maintaining the current color coding and sub-calendar structures. Key Requirements: - Migrate TeamUp Calendar to - Preserve existing color coding - Maintain sub-calendar structure - Ensure event descriptions are carried over accurately Ideal Skills: - Proficiency with TeamUp and - Experience in calendar migration - Understanding of color coding and sub-calendar maintenance - Attention to detail in data transfer Please let me know your experience with similar projects and provide a proposal for the migration process.

I'm seeking an expert to analyze a key aspect of my HR paper from journal with title Building organisational resilience capability in small and medium-sized enterprises: The role of high-performance work systems. The intent of the analysis is to analyse paper Key Requirements: he main structure of the analysis contains the following : Introduction Research context Methodology with results Discussion Overview Critique and significance of the paper the outcome is report and power point slides the due date is 22-5-2024

I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.

... My property is an 1890s house in Michigan requiring structure optimization for joist, rafter, and beam/collar tie to better withstand our moderate winters. Unknown to me is whether or not the house currently has issues. However, when I opened up to see the framing, I discovered both damaged or rotted wood, and what appears to be inadequate support or bracing. The ideal freelancer for this job should: - Be highly knowledgeable about structural engineering, especially for older constructions. - Have extensive experience with the assessment and treatment of damaged/rotten wood. - Be capable of designing and implementing robust structural supports. Being familiar with Michigan's weather conditions and how they impact a home's structure will be a plus. Your recom...

See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.

I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-pa...API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST API -> MySQL...

...user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be developed for Android. The general structure of the application and a sample of the answer sheet are attached. Requirements: - Strong knowledge and experience in OpenCV and image processing - Proficiency in Android development - Familiarity with mobile optical reader applications - Creative and innovative thinking for suggesting image filtering effects Preferred Skills: - Experience in developing Android applications with...

...going basis. Key Requirements: - The primary focus is to layout new developments for convenience stores with fuel pumps on various parcels of land. We will provide surveys, google map locations, etc. to assist along with any setback requirements. - The design should be in line with the provided CAD files for similar developed sites. - The primary focus is on space requirements for the new structure and feasibility of using the land for the intended use. - Turn around time is important. Prefer turn around time of 24 hours or less. Ideal Skills: - Proficiency in civil engineering and land development. - Prior experience with site plan layouts and CAD software. - Strong attention to detail and ability to incorporate specific design requirements. - Good communication skill...

I have a zoning meeting in a week and need photoshop help in placing a garage in 4 pictures to show the zoning board generally how it would look. While I would like the measurements to be correct, I am not looking for perfection at all here. I am opposing my neighbors proposed garage addition.

I need a clean, professional Wordpress website created f...There will be no ecommerce functionality - it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B websites - Design ability: keeping it simple, yet professional - Knowledge of SEO best practices to implement on the website. Please provide examples of your previous work, especially if you have experience with c...

...applications using React.js and Typescript - Proven work experience in integrating APIs into the React code - Strong proficiency in JavaScript, including DOM manipulation and the JavaScript object model - Thorough understanding of React.js and its core principles - Experience with popular React.js workflows (such as Redux) - Familiarity with newer specifications of EcmaScript - Experience with data structure libraries (e.g., ) - Knowledge of modern authorization mechanisms, such as JSON Web Token - Familiarity with modern front-end build pipelines and tools - A knack for benchmarking and optimization - Familiarity with code versioning tools, such as Git - Familiarity with basic CSS, and Figma designing. **Preferred Qualifications** - Proficient understanding of TypeScript with ...

I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.