Медленные запросы к базе данных (WP-Woo)

Create a dashboard for monitoring and analyzing the performance of the company's location network (branches) in Google Business Profile (GBP) through the official Google Business Profile API. Process via a script based on Google Apps Script (link to Google Sheets). Record data in Google Sheets (which serves as a database for Looker Studio). Update: Daily (with an indication of the last update date). Create a Google Cloud service account. The script runs once a day (trigger at 03:00 AM) and sends a request to the GBP API. It retrieves metrics for the previous day for each location (locationId). Records data in a flat format (row = unique combination of Date + Branch ID + Metrics). Key Performance Indicator CardsCard NameGBP MetricDynamic FormatProfile ViewsImpressions (Search + Maps)Percentage %, Sparkline (blue)CallsLocal Services Phone CallsPercentage %, Sparkline (green)Website ClicksWebsite ClicksPercentage %, Sparkline (purple)Direction RequestsDirection RequestsPercentage %, Sparkline (orange)Average RatingAverage Review RatingAbsolute change (e.g., +0.1), Sparkline (yellow)New ReviewsNew Reviews CountPercentage %, Sparkline (turquoise)

Hello everyone! I'm looking for a Backend Developer (NestJS) to work on a new project. What needs to be done Develop a REST API using NestJS. Prepare and maintain documentation through Swagger (OpenAPI), so that the frontend developer can automatically generate a client using Orval and always work with the current specification. Design a clean, scalable architecture that will be easy to maintain and develop. Requirements Strong knowledge of NestJS and TypeScript. Experience with PostgreSQL. Experience integrating with Supabase: authentication and authorization; working with the database; using the platform's built-in features. Experience integrating Stripe (through Supabase features). Understanding of API security principles, authorization, data validation, and application protection. Ability to write clean, structured, and extensible code. If you have relevant experience, please send: examples of projects or GitHub; your desired rate (for the screens I provided, so I can understand your rate, hourly is inconvenient as it's unclear what volume of work will be done, everyone has a different pace);

About the project and tasks We have a small sales department (sales department head + 2 managers) and a database of about 220 active clients. There is an urgent need to implement a simple CRM as an operational level so that managers can record calls, agreements, and statuses in the sales funnel in real-time, while management can see which clients are "stuck" at a certain stage. At the same time, we actively use AI analytics (Claude) for working with exports, reports, anomaly detection, and P&L analysis. Therefore, the CRM is needed as a clean data source from which quality exports can be generated. What needs to be done (Stage 1 — Implementation) Audit and solution selection. Finally determine the platform together with us. We are considering Ukrainian solutions (KeyCRM or SalesDrive) as integration with Ukrainian telephony and Nova Poshta is important. We are also open to considering Pipedrive. System setup. Creating a sales funnel, client cards, and configuring fields according to our specifics. Integrations. Connecting telephony, messengers, and Nova Poshta. Data import. Correct transfer of the existing client base (about 220 contacts) from current files. Training. A brief briefing for the sales department head and two managers on the rules for managing deals to ensure data cleanliness and quality in the CRM. Further tasks (Stage 2 — Support) Technical support and refinement of automations during the work process. Monitoring the correctness of data exports for further AI analytics. Who we are looking for A specialist with experience in implementing KeyCRM, SalesDrive, or Pipedrive (please include examples or cases in your response). A person who understands the principles of building sales analytics and can configure data exports without "garbage". A responsible specialist ready for long-term cooperation and project support. In your response, please indicate Your experience with KeyCRM, SalesDrive, or Pipedrive. Estimated cost and time for basic setup for our team (3 users). Whether you are ready to further administer the system and under what conditions.

About the Company Trading company. We work with a product group of more than 2000 items across different categories.Current Situation Currently, the nomenclature is maintained in Google Sheets — data is consolidated by tabs (categories). Tab Structure: Product name Price groups: cost price, wholesale, retail Characteristics: weight, quantity per package, etc. Important: the number of columns varies for different product categories, as they have different characteristics.Why the Current Solution is Inadequate Google Sheets does not allow setting access rights at the level of individual columns. We need to: Grant users rights to view certain columns (for example, only cost prices) Grant rights to edit certain columns (for example, retail prices) While restricting access to other columns in the same tabWhat Needs to Be DoneMain Requirements Flexible Rights Management System Access at the level of individual columns (read/write) Assignment of rights by roles or users Management of rights without the involvement of programmers Support for Different Data Structures Different product categories have different sets of characteristics Adding new columns/characteristics without programming Independence from Developers Administration by internal staff Adding categories, columns, users — through the interface Integration with ERP Exporting current prices to our ERP system Export or automatic integration via API Data Analysis Using AI (preferably) Ability to analyze the entire nomenclature list Enrichment, verification, recommendations — if you have ideas, please describeExpected Result A working solution in which: The nomenclature is structured by categories with different sets of characteristics Column rights are flexibly configured (view/edit) Data is exported to ERP The team can manage the system independentlyWhat We Need from You When Responding Describe in general terms how you envision the solution: What tool/platform do you propose

A deep technical verification of three PDF files for authenticity and possible signs of editing or forgery is required. Not only a visual assessment of the documents is needed. The performer must have a good understanding of the internal structure of PDF files and be able to analyze: file metadata; PDF structure and individual objects; creation history and possible editing; software used; embedded fonts, images, layers, and other elements; possible signs of re-saving, conversion, modifications, or backdating of the document; any technical discrepancies that may indicate manipulation of the files. Based on the verification results, a clear written conclusion regarding each file must be provided, indicating the identified signs, risks, and limitations of the verification. We are considering specialists who have practical experience in digital forensics, PDF document analysis, metadata, or verifying electronic files for authenticity. In your response, please briefly describe your experience, methods, and tools that you use for such verification.