
Kapalı
İlan edilme:
Teslimde ödenir
Цель тестового задания Реализовать Drupal-модуль, который выступает в роли моста между: внешней SQLite БД (production monitor), и базой данных Drupal. Модуль должен: читать данные об изделии из SQLite, выполнять расчёты на стороне PHP, сохранять агрегированную информацию в Drupal, выводить таблицу операций изделия. ❗ Задание является частью будущего переноса всей системы на Drupal. Важно не только «чтобы работало», но и как это реализовано. Общие условия CMS: Drupal 10 или 11 Источник данных: SQLite ([login to view URL]) Дизайн / верстка: не важны Twig: только отображение, без логики Фокус: архитектура, чистота кода, расчёты Архитектура подключения к SQLite Модуль должен получать данные из внешней SQLite БД, используя: Drupal Database API; централизованное подключение (не в контроллере). ❌ Запрещено: прямые вызовы PDO в контроллерах; sqlite_open, new PDO() в бизнес-логике; SQL в Twig. Модуль Название: factory_bridge Структура ожидаемо включает: сервис для работы с SQLite; контроллер (или блок) для вывода данных; при необходимости — entity или node. Данные, используемые в тестовом задании Используемые таблицы SQLite (обязательно): order_items assigned_tasks work_sessions ❌ Остальные таблицы, описанные в [login to view URL], в рамках тестового задания использовать не требуется. Алгоритмы расчёта (обязательные) Для выбранного изделия (order_items.internal_id): 1. Операции Операция = одна запись из assigned_tasks, связанная с изделием. 2. НЧ План Берётся напрямую из: assigned_tasks.applied_norm_hours 3. Ч Факт Сумма длительности всех рабочих сессий операции: Σ (work_sessions.end_time - work_sessions.start_time) если end_time = NULL — сессия считается активной; расчёт выполняется на стороне PHP. 4. Дельта Δ = План – Факт Вывод данных Реализовать страницу или блок, который выводит таблицу операций изделия. Минимальный набор колонок: Код / Название операции НЧ План Ч Факт Δ (дельта) Скриншот текущей реализации (не на Drupal) приложен только как пример структуры данных, визуальное совпадение не требуется. Сохранение в Drupal При импорте данных: создать или обновить сущность в Drupal: Node типа «Изделие» или Custom Entity (по выбору разработчика). Сохранить минимум: название изделия, артикул / код, статус (произвольная логика допустима). Критерии приёмки (на что смотрим) ✔ Drupal Coding Standards ✔ Использование Services и Dependency Injection ✔ Отсутствие прямых SQL-инъекций в БД Drupal ✔ Корректная работа с датами и таймзонами (ISO) ✔ Вся бизнес-логика в PHP, не в Twig ✔ Читаемость и структура кода Формат сдачи Git-репозиторий или архив с модулем factory_bridge. README приветствуется, но не обязателен.
Proje No: 40073141
30 teklifler
Uzaktan proje
Son aktiviteden bu yana geçen zaman 2 ay önce
Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
30 freelancer bu proje için ortalama $36 USD teklif veriyor

Hello Natalia, I’m excited about the opportunity to create a robust integration module connecting Drupal with the SQLite database. With extensive experience in Drupal development and data integration, I can efficiently implement the architecture needed to fetch and process data from workshop_bot.db. I’ll ensure to adhere to the guidelines you’ve set by utilizing Drupal's Database API for connecting to SQLite and implementing the necessary import logic without direct PDO calls. Expect to see a functional prototype within 5 days.
$30 USD 2 gün içinde
7,0
7,0

Hi, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP, Drupal, SQLite, Web Development, Data Integration, Database Management Lets connect in chat so that We discuss further. Regards
$10 USD 7 gün içinde
6,2
6,2

Hello Dear! I write to introduce myself. I'm Engineer Toriqul Islam. I was born and grew up in Bangladesh. I speak and write in English like native people. I am a B.S.C. Engineer of Computer Science & Engineering. I completed my graduation from Rajshahi University of Engineering & Technology ( RUET). I love to work on Web Design & Development project. Web Design & development: I am a full-stack web developer with more than 10 years of experience. My design Approach is Always Modern and simple, which attracts people towards it. I have built websites for a wide variety of industries. I have worked with a lot of companies and built astonishing websites. All Clients have good reviews about me. Client Satisfaction is my first Priority. Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. Angular JS 7. React JS 8. Node JS 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .Net 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB What you'll get? • Fully Responsive Website on All Devices • Reusable Components • Quick response • Clean, tested and documented code • Completely met deadlines and requirements • Clear communication You are cordially welcome to discuss your project. Thank You! Best Regards, Toriqul Islam
$20 USD 1 gün içinde
5,9
5,9

Good Day Natalia ✌️ I have carefully reviewed the project requirements for creating a module to integrate Drupal with an external SQLite database for the Production Monitor. I am confident in my ability to develop the module that will fetch product data, perform calculations, and store results in Drupal seamlessly. I am eager to discuss the details of this exciting project with you further in chat, Natalia R. Why Choose me? - Unlimited Revisions: Ensuring your satisfaction. - Unique Creations: Tailored solutions for your needs. - Money-Back Guarantee: Commitment to quality. - 24/7 Communication: Constant availability for updates. - Timely Delivery: Meeting project deadlines efficiently. Browse my portfolio for quality work samples: https://www.freelancer.com/u/leenadvnani6 Let's discuss your project further in the chat. Best regards, Leena Kumari :)
$30 USD 1 gün içinde
5,4
5,4

With nearly a decade of web and mobile development experience, I am well-suited for the task at hand. My understanding of CMS such as Drupal, database integration, and the usage of the Drupal Database API will ensure a seamless connection between the external SQLite DB and Drupal. Throughout my career, I have strived to create clean, efficient code, which aligns perfectly with the emphasis on clean architecture and code in this project. My familiarity with languages like PHP and database management tools is a testament to my problem-solving abilities. To enhance Drupal's functionality, I propose using **Node type "Изделие"** or **Custom Entity**. Whichever is chosen will be custom tailored to your needs. Moreover, my deep knowledge of SQLite connections will ensure we avoid any direct PDO calls in controllers or SQL within Twig files. The extensive range of functionalities that can be achieved serverside through PHP and Drupal should not be undermined by contentions like these. Finally, partnering with our company affords more than just technical acumen. We offer effective cost management, extended 3-month support for developed projects to iron out any kinks that may arise after delivery, and even inexpensive domain and hosting options. Let's work together to not just make the project functional - but exceptional!
$100 USD 7 gün içinde
5,4
5,4

Hi, I can integrate this API into your codebase today. I have experience with third-party API integrations. Ready to start immediately.
$10 USD 1 gün içinde
4,8
4,8

Hi Goodseeker! I’ve reviewed your project and specialize in Drupal module development, focusing on integration with external databases. I can create a module that bridges SQLite with Drupal, ensuring clean architecture and adherence to coding standards. Let’s set up a quick meeting to discuss this in detail. Best Regards, Amjad Iqbal
$30 USD 1 gün içinde
4,8
4,8

Hi there! I see you need a smooth bridge between Drupal and an external SQLite database, which can be tricky without proper integration. Handling product data and calculations manually can be time-consuming and error-prone. I can build a custom Drupal module `factory_bridge` that securely connects to your SQLite DB via the Drupal Database API, imports product details, performs all calculations in PHP, and displays results in a clear table. This will ensure data consistency, easy updates, and quick access from Drupal nodes. Would you like me to make the import runnable via URL or Drush command for convenience? Open chat now, and we can get this module working for you quickly.
$20 USD 7 gün içinde
4,1
4,1

Hello! I’m a full-stack PHP/Drupal developer with strong experience in clean architecture and database integrations. I can build the factory_bridge module using Drupal Services & DI, connect to external SQLite via Database API, handle all calculations in PHP, and store structured data in Drupal entities. Clean, standard-compliant, and maintainable delivery.
$20 USD 4 gün içinde
3,0
3,0

Dear Client, I am excited about the opportunity to work on creating a module for integrating Drupal with an external SQLite database for the Production Monitor project. With expertise in PHP and Drupal development, I am confident in my ability to build a robust bridge between the external database and Drupal, following the specified architecture and algorithms outlined in the project details. I propose to develop a custom module, factory_bridge, that will efficiently retrieve and process data from the SQLite database, and seamlessly save the calculated results within Drupal entities. I am committed to ensuring the logic for imports and calculations is implemented in PHP, providing a reliable and maintainable solution for your project requirements. I look forward to discussing this project further and collaborating on delivering a successful integration for your Drupal website. Best regards, Yevhenii
$30 USD 1 gün içinde
2,9
2,9

We've recently finished a project just like this where we helped someone bring their creative vision to life. I can do the same for you by shaping a design that fits your style and goals without overcomplicating the process. You won't find someone better aligned with what you're looking for. I paid close attention to your focus on a clean and professional result. I enjoy creating work that feels user friendly and polished, and I have the skills to deliver something that fits smoothly into your overall vision. I'll handle the integration of the external SQLite database via Drupal's Database API, ensuring clean architecture and a reliable import service. The module will create or update product entities and render accurate operational data with PHP-driven calculations. I'd love to chat about your project! The worst that can happen is you walk away with a free consultation. Regards, Danie.
$10 USD 7 gün içinde
2,6
2,6

Hi there, I understand that your main goal is to create a seamless integration module between Drupal and SQLite to enhance data management and accessibility. In my previous role, I successfully developed a custom module for a Drupal project that improved database performance by 25%, resulting in faster data retrieval and user satisfaction. Additionally, I implemented robust security measures that reduced vulnerabilities by 40%, ensuring a secure environment for sensitive data. To address your requirements, I will design a tailored Drupal-SQLite integration module that not only streamlines data handling but also optimizes performance with efficient queries. I will ensure the module is thoroughly tested for compatibility and security to provide a reliable solution for your needs. I would be happy to discuss your needs and get started right away. Best regards, Artem
$20 USD 7 gün içinde
2,0
2,0

Hello Natalia R., We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on PHP, Drupal, SQLite, Web Development, Data Integration, Database Management Lets connect in chat so that We discuss further. Regards
$20 USD 7 gün içinde
1,7
1,7

Только что завершил аналогичный Drupal-модуль, выступающий мостом между внешней SQLite БД и Drupal 10. Я уверен, что отлично подхожу для этого задания. Я специализируюсь на архитектурно чистых Drupal 10/11 решениях, где важны сервисы, Dependency Injection и долгосрочная поддерживаемость — особенно в проектах миграции существующих систем на Drupal. С multipe 5-star reviews on similar projects я регулярно реализую модули с централизованным подключением к внешним БД через Drupal Database API, строгим разделением слоёв и бизнес-логикой исключительно в PHP. Я внимательно изучил требования: работа с таблицами order_items, assigned_tasks, work_sessions, расчёты НЧ План / Ч Факт / Δ на стороне PHP, корректная обработка NULL end_time, отсутствие SQL в Twig и сохранение агрегированных данных в Node или Custom Entity. Результат будет соответствовать Drupal Coding Standards и готов к масштабированию. Буду рад обсудить детали. В худшем случае вы просто получите бесплатную консультацию. Chris | Lead Drupal Developer | Novatech
$20 USD 14 gün içinde
2,4
2,4

✌️Hello, Natalia✌️ I appreciate your project post. I think your goal for this task is to seamlessly integrate Drupal with an external SQLite database for a Production Monitor, allowing for efficient data management and monitoring. In a previous project, I successfully integrated a complex ERP system with an external MySQL database for a manufacturing client. This project achieved a success rate of 89.2%, showcasing my ability to handle intricate database integrations effectively. This experience directly relates to your task as it demonstrates my proficiency in managing data connections and ensuring seamless communication between systems. As a result, your Production Monitor will have real-time access to critical data, enhancing monitoring capabilities and improving decision-making processes. OK, let's discuss about your task in more detail.✌️ Best regards, Bogoljub
$20 USD 3 gün içinde
0,0
0,0

Создание надежного моста между внешней SQLite базой и Drupal требует грамотной архитектуры, чистого кода и соблюдения стандартов платформы. С 7+ лет опыта в AI-автоматизации, PHP и разработке модулей для Drupal, я специализируюсь на построении модулей с сервисами, Dependency Injection и корректной работой с внешними источниками данных. Для задачи factory_bridge я реализую централизованное подключение к SQLite через Drupal Database API, выполняю все расчёты на стороне PHP (НЧ План, Ч Факт, Δ), сохраняю агрегированные данные в Drupal сущности (Node или Custom Entity), и вывод таблицы операций изделия через Twig исключительно для отображения. Весь код будет соответствовать Drupal Coding Standards, безопасно работать с датами и таймзонами, полностью отделять логику от шаблонов и обеспечивать читаемость и масштабируемость. Я уверен, что являюсь наиболее подходящим специалистом для реализации этого модуля с профессиональным подходом и готов обсудить детали, сроки и демонстрацию работы на примере одного изделия. Пожалуйста, свяжитесь со мной для уточнения технического подхода и дальнейшего сотрудничества.
$20 USD 7 gün içinde
0,0
0,0

Hello I have 14+ years experience in PHP Development with Laravel/Symfony/Drupal. - Good experience in Git - Development with Mysql and Database design - Performance improvement - Cache implementation - API Load testing & performance testing - PHP Unit test case - Good experience to Deployment on AWS/Azure ******** Now available for full time job on high priority ***************** Thanks Mohit Gupta
$300 USD 7 gün içinde
0,0
0,0

Здравствуйте, Я профессионально занимаюсь разработкой на Drupal и интеграцией внешних баз данных. Я могу настроить безопасное и эффективное подключение Drupal к внешней SQLite базе данных для вашего Production Monitor. Моя работа включает: проверку совместимости, настройку надежного соединения, разработку модулей или скриптов для корректного обмена данными, а также тестирование и оптимизацию производительности. Я гарантирую качественную, безопасную и стабильную интеграцию, с учётом всех стандартов Drupal. Работаю аккуратно, соблюдаю сроки и обеспечиваю прозрачное общение на всех этапах проекта. Буду рад обсудить детали и начать работу. С уважением, Debasmita Adak
$20 USD 7 gün içinde
0,0
0,0

Novolukoml, Belarus
Haz 8, 2016 tarihinden bu yana üye
£2-5 GBP / saat
$30-250 USD
£20-250 GBP
$10-11 USD
$1500-3000 USD
₹12500-37500 INR
$10-30 USD
$30-250 USD
₹100-400 INR / saat
₹1500-12500 INR
₹400-750 INR / saat
₹1500-12500 INR
$750-1500 CAD
$30-250 CAD
₹12500-37500 INR
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
₹1500-12500 INR
$15-25 AUD / saat