Sql stored procedure view pid jobs
...registration with email activation using PHP Mailer - User login - 'Forgot Password' functionality - Bootstrap 5.3 for responsive design - Server-based validation - User-friendly notifications via session on every action Security is paramount in this project. The application must be robust against various types of attacks, specifically Cross-Site Scripting (XSS), Cross-Site Request Forgery (CSRF), and SQL Injection. Additionally, a configuration file should be created with BASE_PATH and BASE_URL for easy management. Forms must be secure, implemented with CSRF and XSS protection as well as using prepared queries for database interactions. Ideal candidates for this project should have: - Extensive experience with PHP and the MVC framework - Proficiency in implementi...
I'm seeking a talented writer experienced in crafting Wikipedia articles to create a biographical piece about a public figure. Key Requirements: - Proven experience in writing for Wikipedia - Exceptional research and writing skills - Ability to adhere to Wikipedia's standards and guidelines - Capable of creating a compelling and neutral biograp...Wikipedia's standards and guidelines - Capable of creating a compelling and neutral biography I can provide a wealth of resources including: - News articles - The official website of the subject - Interviews Your task will be to sift through these materials, extract the most relevant information, and present it in a manner that's suitable for Wikipedia. Please ensure to maintain a neutral point of view and adhere to W...
I need a Windows-compatible desktop software designed for managing customer data and assessing customer risk. The software should include: - Data Entry and...customer data and assessing customer risk. The software should include: - Data Entry and Storage: The software should allow for easy input and organization of customer data. - Customer Risk Assessment: The software must have a functionality to evaluate and rate customer risk. - Reporting and Analytics: The software should be capable of generating reports and providing analytics based on the stored customer data and risk assessments. Ideal skills and experience for this job would include software development for Windows desktop applications, experience in creating data management software, and knowledge in risk assessment a...
...such as maintenance and purchase requests. The system should include role-based access control, approval workflows, and basic analytics. Key Functionalities: User Management & Authentication: Users can register and log in with roles: Requester (can submit requests) Department Manager (can approve/reject requests) Engineering Manager (final approval and assignment) Passwords should be securely stored (hashed). Session-based authentication to restrict access. Request Submission: Dynamic form with the following fields: Auto-filled: Requester Name, Department, Date & Time, Sequential Request Number (per department). User Inputs: Area (dropdown, multi-selection) Line (dropdown, multi-selection, filtered by Area) Room (dropdown, multi-selection, filtered by Line) Equipment (...
...understanding of cloud deployments and microservices approach to build the application. - Proficient in planning, designing and implementing SPAs using Angular and developing REST APIs using Node JS. - Created Typescript reusable components and services to consume REST APIs using Component-based architecture. TECHNOLOGIES: Node.js | Angular | React.js | | Java script | TypeScript DATABASE SQL | PL/SQL| MySQL | PostgreSQL | MongoDB | Amazon DynamoDB PM TOOLS: GIT | SVN | JIRA Monthly Remuneration: INR 75-80K Duration : 3 Months with very high possibility for extension. You should be open for an interview with a highly technical CTO. Please apply with your complete profile & examples of your best work. This position is ONLY for Full-time freelancers based in Indi...
...cloud data storage or remote monitoring capabilities. Skills and Experience Required: Proficiency in electronics and hardware setup (experience with sensors like moisture sensors, load cells, and color sensors). Expertise in microcontrollers, particularly Raspberry Pi or Arduino. Strong experience with Python programming, including sensor integration and data handling. Familiarity with databases (SQL) and building basic dashboards/GUI (if required). Ability to troubleshoot hardware and software issues effectively. Previous experience with similar projects (portfolio or examples of past work is a plus). Timeline: Basic Setup (Hardware + Software): ~7–10 days Optional Features (Dashboard, IoT, Database): Additional 5–7 days Budget: Please provide an estimate based on yo...
...design. - Create a design that aligns with a modern and sleek aesthetic. - Deliver a high-quality, web-optimized logo. The ideal candidate should have: - A strong portfolio of modern logo designs. - Excellent understanding of color theory and digital design. - Ability to take specific color instructions and create a cohesive logo. New Logo: Spanish ABBI = Asociacion de Blockchain & Bancos Internacional English IBBA = International Blockchain & Banking Association ABBI where the I ends add BBA goin down and close in a Block style logo As we are going international I would like to merge above letters into logo: Spanish- Asociación de Blockchain & Bancos Internacional
Sensor data from Arduino to SQL database locally.
I have a project which involves processing a spreadsheet of 4100 EANs. The primary task will be identifying the SKU and size from the data. The EANs are currently stored in an Excel (.xlsx) spreadsheet. - Skills Requirement: Proficiency in Excel and data mining is essential. Experience with SKU and size identification will be a significant advantage. - Task: Extract SKU and size information from the provided EANs data. Please note, the specific SKU and size information that needs to be extracted has not yet been defined. A flexible approach and readiness to adapt to evolving project requirements will be key.
I'm looking for a comprehensive web-based platform that can analyze and rank YouTube videos based on various metrics. I want the platform to focus on: - Analyzing and ranking videos based on metrics - Utilizing key metrics such as view count, engagement rate (likes, comments, shares), and watch time for the ranking process - Allowing me to select specific channels or videos that will be included in the ranking This project requires an experienced web developer with skills in data analytics and familiarity with YouTube's API. The ideal candidate will have a proven track record of creating similar platforms.
...retrieval: - In group chats, if ris is not directly mentioned, ris reads the previous 10 messages at once - In group chats, if ris is directly mentioned, ris reads all the previous messages sent after the last message ris read - When a message is read, ris extracts user profile information and stores it as a core memory - During recall, ris uses information stored in its core memory instead of reading the entire conversation history Information stored under each profile in core memory: - Phone number - First name - Last name - Food preferences - Activity preferences - Other things that might be important Things needed to plan the event: - Availability - Food preferences - Activity preferences - Other things that might be important...
...more waiting—just hit record and start working on your content right away." One-Click Recording Start/Stop: "With just one click, you can start or stop recording. It’s that simple!" Built-in Recording Management: "Screen Recorder Pro comes with an intuitive recording management system, so you can easily organize, edit, and keep track of your recordings." Local Storage: "All your recordings are stored locally on your device—no server uploads and no internet required. Your data stays safe and under your control." [Section 2: Perfect for Different Use Cases - 1:00] Background music picks up the pace. [Visuals: A montage of various use cases such as tutorials, presentations, gaming, and virtual meetings.] Narrator: "Whe...
I have stock market candle data stored in a MySQL database, including open, high, low, close, volume, and time. I need a PHP script that generates order blocks after breakouts and breakdowns, and stores this data in the database. Key Requirements: - The script needs to identify whether the stock is reaching an order block after a breakout or breakdown, with volume is shrinking or not. - The analysis should be based on technical analysis principles. - Data should be updated in the database automatically, in real-time. - I will run this script after every candle close to analyze. Ideal Skills and Experience: - Proficiency in PHP and MySQL. - Strong understanding of technical analysis and stock market dynamics. - Experience with real-time data processing.
...Responsibilities 1. Ticket Price Data Collection Research ticket price ranges for each of the 45 theatres (list provided below) using publicly available ticketing platforms (e.g., ATG Tickets, London Theatre Direct, Ticketmaster). Document ticket prices for different seating categories: Premium (e.g., stalls, front rows). Mid-tier (e.g., circle, middle rows). Budget (e.g., back rows, restricted view). Provide the highest, lowest, and most common price points for each theatre. 2. Seating Category Proportions Estimate the proportion of seats in each price category (if seating plans are available). Indicate where assumptions are made due to unavailable data. 3. Dynamic Pricing Analysis Day-of-Week Variations: Capture pricing differences for: Weekday matinees. Weekday evenings. Week...
...Options to recover passwords. 5. **Shopping Cart**: - Display of selected products. - Options to modify quantities or remove products. - Automatic calculation of the total cost (including taxes and shipping). 6. **Order Process**: - Selection of shipping address. - Choice of payment method (credit cards, PayPal, bank transfer). - Order confirmation. 7. **User Dashboard**: - View order history. - Options to edit personal information. - Track shipments. 8. **Contact Page**: - Inquiry form. - Direct contact information (email, phone, social media). 9. **Administration Page (Backend)**: - Management panel for: - Adding, editing, or deleting products. - Managing users. - Reviewing orders and updating shipping status. - Viewi...
I need professional and clean App Store preview screenshots for my iOS app. The app is a productivity one that allows users to view and search PDFs on their Apple Watch. Key Responsibilities: - Create visually appealing and informative screenshots that highlight the main features of the app - Ensure the design aligns with a professional and clean aesthetic Ideal Skills and Experience: - Proven experience in designing AppStore screenshots - Strong understanding of the Productivity & PDF app category - Exceptional graphic design skills with a focus on a professional and clean style
...Develop custom ranking algorithms (similar to PageRank or keyword relevance). 3. Admin Panel: • Purpose: Build an Admin Panel to allow easy management of the crawler and indexed data. • Features: • Crawler Settings: Control crawl frequency, depth, and site list. • Index Management: View, edit, and delete indexed data. • Crawl Logs: Display logs of all crawling activity, errors, and successful crawls. • Re-indexing Options: Manually trigger re-indexing when data changes or needs to be refreshed. • System Monitoring: View real-time stats about the crawling process and indexed data performance. 4. Search Engine Development: • Purpose: Develop the frontend and backend of the search engine for users to search results from the indexed dat...
...and customer contact, via WhatsApp. The admin dashboard should allow us to manage all operations efficiently. It should include order management features to view, edit, and update customer orders, assign orders to delivery agents, and manage products by adding, removing, or editing listings. There should also be tools for delivery management, such as notifying agents of assigned orders and allowing them to update the status of deliveries. Reports and analytics should be available for sales data, with an option to download reports in CSV format. Additionally, a mobile-friendly delivery agent portal should be created to let agents view their assigned orders and mark them as delivered. For the technical specifications, I prefer using PHP for the backend, with Laravel or Cod...
I'm in need of a seasoned content marketer with a specialty in video production and promotion. The primary focus of this project is to create and disseminate engaging video content for an upcoming NFT game. Key Responsibilities: - Develop a content marketing strategy focused on video content to promote the NFT game - Create engaging and high-quality video content - Leverage ap...Leverage appropriate platforms to maximize reach and engagement Ideal Skills and Experience: - Proven experience in content marketing, particularly through video - Familiarity with NFT games and the target audience - Strong video production and editing skills - Excellent understanding of social media platforms for content promotion
...roles (e.g., manager, normal user) and viewing statistics. File Upload & Approval Process: Users can upload Word files through the frontend and submit them for manager approval. An email notification will be sent to the manager for approval or rejection. Upon approval or rejection, the user will receive a notification email. PDF Download & Storage: Approved files will be converted to PDF and stored in the user's profile. Users can download and share the final PDF files. Backend Requirements: Document Processing: Once a Word file is uploaded, the system will wait for manager approval. If approved, the system will: Add a header and footer (based on office location). Include a QR code, a unique serial number, and the date of issue. Append an additional pag...
I'm a recent high school graduate seeking assistance with data entry into my SQL-based database. Ideal Skills: - Proficient in manual data entry - Experienced with SQL databases (e.g., MySQL, PostgreSQL) - Strong attention to detail and accuracy - Good communication skills - Problem-solving abilities
Hi, I need to make a video to promote some courses and products that my client sell. We have some videos and, from these videos, I need to make one, maximum 50 seconds, with good intro (will be always the same for all videos made), course or product presentation with a perfect background sound, and the close (will be always the same in all videos...made), course or product presentation with a perfect background sound, and the close (will be always the same in all videos made). I need someone that work in post production to generate emotions in the viewer. My client has a training center for law enforcement and private security. We have to make more than one videos and if a fund the perfect partner there will be a continuos job I would like to view some references work done Thank y...
I'm experiencing issues with the ADX formulas in MySQL. The results I'm getting from the built-in SQL functions are incorrect. Specifically, I'm trying to calculate the directional movement, but the output doesn't align with my expectations. Skills and experience that would be ideal for this job include: - Extensive knowledge of MySQL - Proficiency with SQL's built-in functions - Experience troubleshooting formula-related issues - Understanding of directional movement calculations
...proportional. - Text on banners should be large enough to read clearly from a slight distance. - **Brand Consistency:** - Orange is the primary brand color (as in “Aur Kab Tak?”). - Keep contact details near the bottom if you include them: `` and ``. ### **5. Deliverables & Format** - **High-Resolution Mockups**: - At least 1–2 perspective angles (e.g., front-facing and a slightly angled side view) to show the entire booth environment. - **File Format**: - JPEG or PNG for quick reference. - (Optional) Source file from 3D software or layered PSD if possible. ### **6. Additional Notes/Instructions** - The look should closely mimic a real event photo—avoid overly “cartoonish” or obviously computer-generated styles. - If refere...
More details: What kind of data are you working with? Mixed data What kind of tampering or modifications are you concerned about? Alteration of data values Where is the data stored? Local storage
I'm in need of a skilled WordPress developer who can create a plugin for my wedding photography business. The plugin should facilitate an efficient booking system, align resources for each event, and manage payments. Additionally, a calendar view to keep track of bookings is essential. Key Features: - A client booking form integrated within the plugin - An intelligent system to align resources for each event - Payment management capability The candidate should have: - Extensive experience with WordPress plugin development - Prior work with booking systems - An understanding of resource management for events - Knowledge of secure and reliable payment management systems Please note that I have not specified the payment methods yet. However, the plugin should have a flexible ...
We look for a professional web developer with SQL, PHP, Zend / Laminas / Wordpress and coding knowledge that can reprogram / uplift a existing and working quotes & jokes website (Mobile compatible) from Zend 1.12.2 to Laminas and from php 7.4 to php 8.3 where all current functionalities are covered (front & backend). We are also open to lift the whole project into wordpress, hence it would help to administrate the site, but this is only a option if all existing functions can be covered. The site has a database with keywords, authors, topics and pictured as well as a ranking system of the quotes. Also a improvement on current site loading speed fot most ranked quotes should be improved. SEO is also covered well now but some improvemtns might help too. We need a clear proper c...
...define their number range. Immediate Data Availability: Fix the issue where new entries (clients, merchants, etc.) require a page reload to appear. Employee Signatures: Allow employees to upload their signatures in settings, displayed on generated guarantees. Customs Documents: Replace "NMH" with "Hess" in the customs document management section for existing references. Telephone Numbers: Ensure stored phone numbers are displayed in generated documents. Freight Details: Add fields for the year of manufacture and vehicle condition (new/used) in freight details. Invoice PDFs: Fix PDF display issues and ensure downloaded files are named with their respective invoice numbers. Merchant Management: Ensure all merchants are visible in the transport order section, and...
...graphic and layout optimization. My ongoing project features an organization chart that currently doesn't fit on a single page and click event to view the number of person on the Job Category showing in the chart. Microsoft Visual Studio Project & SQL Database backup attached, attached the Organization Chart Generated by this application. Key Tasks: - Adjust the layout of the chart to a vertical orientation. - Ensure the chart fits within a single page. -Click Event on Each Job Category Ideal Skills: - Proficiency in ASP.NET and Microsoft .NET Framework. - Expertise in graphical layouts and responsive designs, including jQuery. - Experience with SQL database integration for handling chart data. - Ability to deliver a quick and efficient solution. Most ...
...stream - add stream, support multi source setup, select gpu , select profile for transcode, select output http stream/rtmp stream output *( rtmp,rtsp,rtp,rtmpe, udp,http,mpegts,ts,hls,dash all protocols) - profiles for transcoding (attach to gpus) (all settings for best quality streaming (all codecs) - multi gpu support - create/userpass for watch http stream/rtmp streams /lock to ip not able to view from other ips. - show current connected connections by username/connected channels/country flag - show users/ online/offline / disable users/ kick connection user (disconnect all connections)/ban user - create stream bouqets /categorys, add streams to categories, user limit access to wach selected stream categories. - advanced export playlists mutli option ( rtmp,rtsp,rtp,rtmpe, udp...
...Develop custom ranking algorithms (similar to PageRank or keyword relevance). 3. Admin Panel: • Purpose: Build an Admin Panel to allow easy management of the crawler and indexed data. • Features: • Crawler Settings: Control crawl frequency, depth, and site list. • Index Management: View, edit, and delete indexed data. • Crawl Logs: Display logs of all crawling activity, errors, and successful crawls. • Re-indexing Options: Manually trigger re-indexing when data changes or needs to be refreshed. • System Monitoring: View real-time stats about the crawling process and indexed data performance. 4. Search Engine Development: • Purpose: Develop the frontend and backend of the search engine for users to search results from the indexed dat...
...the past, name and description are not empty). Constraints: The verification will be completed within 2 seconds. The system will not allow creating a task with missing or incorrect data. Saving the task to the database: The system will add the new task to the project and update the management system. Constraints: The system should be able to handle up to 10,000 tasks concurrently. Tasks will be stored in an organized manner for easy retrieval. 4. Use Case: Receive Notification of New Task User Actions: Receiving a notification: The user will receive a notification about a new task that was added. Constraints: The user can receive the notification via email or through an in-system notification. Notification time should not exceed 30 seconds after the task creation. System Actions...
I've created a homepage using Lovable AI, but my subscription has ended and I need help completing my website. I have the files stored on GitHub and I want a skilled developer to finish the project. Key requirements: - Total of 10 to 15 pages - Replicate the current design using HTML/CSS - Experience with GitHub Ideal experience: - Web development - HTML/CSS - GitHub Please note, I haven't outlined the specific content for each of the additional pages, nor do I have design files beyond the homepage. I am looking for a professional who can not only complete the website but can also design the remaining pages in line with the existing aesthetic.
I'm looking for an experienced web developer to create a finance news portal for me. This web application should be capable of automatically posting news sourced from Financial news websites, Stock market reports, and Co...login system where users can create accounts and log in. - Search Functionality: Users should be able to search for specific news or topics. Design: - News Display: The news content should be displayed in a user-friendly grid view. - you can see for reference. Ideal Skills: - Proficiency in web development languages (HTML, CSS, JavaScript, etc.) - Experience with creating news portals or similar applications. - Knowledge of implementing user login systems and search functionalities. - Ability to design a clean, easy-to-navigate grid view layout.
You MUST do the work FIRST, consider this a "CONTEST". 1. You create the WORDPRESS SITE on YOUR SERVER (or on my server if trust me), show me, and BID. 2. I AWARD, PAY Milestone, and then you send Wordpress Template/Theme and SQL database/data. 3. I IMPORT your SQL into my Wordpress mysql and install your Template and TEST. Then I release 2nd Milestone and give you a PERFECT rating if all works well. I'm looking for a skilled WordPress developer who can create a WordPress template that closely replicates the design of my current website. Key Requirements: - Proficiency in WordPress development - Strong understanding of web design principles - Ability to replicate design elements accurately - Creative thinking for potential design improvements Please no...
I am looking for a skilled web developer or a team to build an MVP for a financial advisory platform. The application will allow users to register, complete a static financial profiling questionnaire, connect multiple broker accounts, and view actionable insights about their investments. The platform will also include an AI-powered chatbot for financial queries and document analysis. The core requirements for the MVP include: Key Features: 1. User Management: - User registration, login, and profile management. - Secure sessions with automatic logout after inactivity. 2. Static Questionnaire: - A predefined set of financial profiling questions. - Logic to categorize users into predefined investment groups (e.g., Conservative, Moderate, Aggressive). - Display recomme...
...logins and profile setups. Personalized Offers: Employ machine learning (e.g., ) to analyze customer behavior and suggest tailored offers. 3.2 Sub-Contractor Data Collection Performance Metrics: Provide a dashboard built with or D3.js for subcontractors to track their performance. 3.3 Transactional Data End-to-End Transaction Tracking: Securely store transaction data using SQL or NoSQL databases. 3.4 Real-Time Monitoring Operational Dashboards: Build dashboards with real-time updates using React or Angular connected via WebSocket. 4. Admin Features (Backend/Management) 4.1 Sub-Contractor Management Profile Approval: Admins can manage subcontractor profiles through an Admin Panel built with React and Redux. 4.2 Customer Support & Dispute Resolution In-App Support Chat:
I'm looking for a skilled Laravel developer to help me build a book library. This library should have public access with limited features, allowing users to search for books and view their details. Key Requirements: - Development of a book search function - Creation of a system to view book details I have already began, just need someone to help me finish Ideal Skills and Experience: - Proficient in Laravel - Prior experience in developing similar public access systems - Strong understanding of search and information display systems
I am seeking an experienced Microsoft SQL Server developer to create stored procedures that will handle input data validation for my database. The validation needs to cover: - Format validation: Ensuring data is in the correct format before entry. - Range validation: Verifying that data falls within acceptable limits. - Uniqueness validation: Checking that input data is unique where required. Ideal candidates for this project should have a strong background in SQL Server and data validation processes. Previous experience with writing stored procedures is a must. Please provide examples of similar projects you have completed in the past.
...and Permissions: o Different levels of access for admins, sub-admins, and support staff. 2. Analytics Dashboard: o Admins can view statistics like the number of applications submitted, popular programs, and payment details. 3. Language Support: o Multilingual support (e.g., English, Farsi, Arabic, Swedish). Based on the student location, the corresponding language section should be opened for the student or if the language of the country is not specifically defined in the system English should be used for that area. 4. Responsive Design: o Fully functional across desktop, tablet, and mobile devices. 5. Secure Data Storage: o All user data and documents must be stored securely with encryption standards. 6. Automated Email Notifications: o Students and admins will receive a...
I'm seeking a talented mobile app developer to create a crypto wallet management application. Key Features: - Send/receive cryptocurrencies - View transaction history - Multi-currency support - dApp with an existing coin smart contract Security Measures: - Two-factor authentication - Biometric login - Encryption for stored data Ideal freelancers for this project should have a deep understanding of cryptocurrency, mobile app development, and top-notch security protocols. Experience with smart contracts and dApps is a big plus.
We operate a job portal, , built on PHP and SQL. Our goal is to extend our reach by linking job posts with prominent job websites like Indeed and LinkedIn, and possibly others like , Monster Jobs, TimesJobs, etc. Key Requirements: - Real-time synchronization of job postings across platforms - Integration of an Application Tracking System (ATS) We already have accounts set up on both Indeed and LinkedIn. The ideal candidate for this project would be someone with substantial experience in job portal integration, preferably with knowledge of implementing an ATS. Please provide your most competitive quote.
I’m working on an Angular/.NET application with a functional small attachment tab UI and several working APIs. However, I’m facing issues with two APIs: 1. Insert API: Data is not being inserted into the database. 2. Fetch API: Unable to retrieve data properly. Technologies used: - Frontend: Angular - Backend: .NET Core, .net framework - Database: [SQL Server/MySQL, MongoDB.] Deliverables: - Fix the insert and fetch API issues. - Ensure proper testing for functionality.
...Twilio's Phone Number API to display available numbers dynamically on the website. Enable users to purchase numbers directly from the website. Configure Twilio's SMS API for OTP delivery. WooCommerce Setup: Implement WooCommerce for e-commerce functionality. Configure payment gateways (Stripe/PayPal) for seamless transactions. User Features: User registration/login system. Dashboard for users to view purchased numbers and OTP history (if needed). Secure, responsive design optimized for desktop and mobile. Admin Features: Admin panel to manage virtual numbers, pricing, and user data. Reporting and analytics dashboard for sales and SMS usage. Testing and Deployment: Ensure the website is fully functional with no bugs. Test SMS/OTP functionality for multiple scenarios....
I'm looking for a LookML professional who can assist me with creating models and explores within Looker. Key Responsibilities: - Develop and implement LookML models specifically focused on Dimensions and Measures. - Help me in joining multiple tables within derived tables. Ideal Skills: - Proficient in LookML and Looker. - Extensive experience working with SQL databases, BigQuery, or Redshift. Please provide examples of your previous work with LookML models.
I’m looking for a 3D asset based on the image posted, a piggy ba...jumping, coin insertion). • Optimized for animation purposes (for use in web and mobile applications). 3. Style Consistency: • Future scalability to different animals (e.g., cat, dog, etc.) with the same style guidelines. • Provide style guidelines such as colors, shapes, and key features. 4. Rendering Needs: • Transparent background renders from multiple angles (e.g., front, side, top, and 3/4 view). • High-resolution versions for branding materials. 5. Ability to change the colors. 6. Usage Flexibility: • The model should be lightweight and optimized for web and mobile without compromising quality. • Scalable without loss of detail. 7. Source files of the 3D model. Rende...
I'm seeking a professional who can use AI tools to generate code, review, correct it and make a control system based on EKF/PID. We will go by milestones - start from Simulation to final firmware
