1. Client Information:
1.1 Details Client:
-
Client ID: 9965DR67UH67
-
Company Name: Mahendra Technosoft
-
Contact Information:
-
Primary Contact:
-
Mobile Number: +91-8460602878
-
Email Address: kailashbhagchandani60@gmail.com
-
-
Billing Contact:
-
Mobile Number: +91-8460602878
-
Email Address: kailashbhagchandani60@gmail.com
-
-
Technical Contact:
-
Mobile Number: +91-8460602878
-
Email Address: kailashbhagchandani60@gmail.com
-
-
Physical Address:
-
House/Building Number: 903, F-Block
-
Street Address: Aura County, Ubale Nagar, Wagholi
-
City: Pune
-
State: Maharashtra
-
Postal Code: 412207
-
Country: India
-
-
1.2 Contact Details:
-
Contract ID : 7858586
-
Contract Start Date: 13/12/2019
-
Contract End Date: 13/12/2029
-
Contract Type: annual, monthly, project-based
-
Contract Terms : pdf.file [A brief summary of key contract terms or a link to a full contract document (PDF, online document)]
-
Contract Value :
-
Contract Value: $25,000
-
Breakdown of Contract Value:
-
Website Design: $5,000
-
Development and Coding: $12,000
-
E-commerce Integration: $5,000
-
SEO and Testing: $3,000
-
-
Payment Terms:
-
40% upfront ($10,000)
-
40% after project milestones are reached ($10,000)
-
20% upon project completion and approval ($5,000)
-
-
-
Renewal Date : 14/12/2029
1.3 Account Status (Active/Inactive):
-
Account Status: "Active," "Inactive," "Suspended," "Pending"
-
Status Change Date: 14/02/2024
-
Status Change Reason : "Contract expired," "Client request," "Non-payment"
2. Services Information:
-
Service ID : 5886594758
-
Service Name: Digital Marketing
-
Service Description: Digital Marketing is the cornerstone of business success in today’s digital-first world.
-
Service Features/Specifications
-
List Format
-
Custom Design: Fully responsive, modern, and user-friendly layouts.
-
E-commerce Integration: Shopping cart, payment gateway integration, and product catalog setup.
-
Content Management System (CMS): Easy-to-use platform for managing website content (e.g., WordPress, Joomla).
-
SEO-Friendly Architecture: Optimized structure, meta tags, and site speed for better search engine ranking.
-
Ongoing Support: Bug fixes, security updates, and minor content updates.
-
-
-
Service Start Date (for the client): 12/2/2023
-
Service End Date (for the client, Optional): 15/2/2025
-
Service Status (for the client): Active
-
Service Level Agreement (SLA) (Optional): pdf
-
Related Resources/Documentation (Optional): Documents

3. Domain Information:
-
Domain ID: 123455891
-
Domain Name: mahendratechnosoft.com
-
Registration Date:12/2/2023
-
Expiry Date:12/2/2029
-
Registrar: GoDaddy, Namecheap, Google Domains
-
Domain Status: "Active," "Pending Transfer," "Expired," "Redemption Period"
-
Name Servers: ns1.example.com, ns2.example.com
-
WHOIS Privacy: Indicates whether WHOIS privacy protection is enabled for the domain. [enabled]
-
Auto-Renewal: Indicates whether auto-renewal is enabled for the domain. [enabled]
-
Domain Email Accounts: [Domain email related data]
-
Email Account ID:info@mahendratechnosoft.com
-
Domain ID: 78DG152468
-
Email Address:info@mahendratechnosoft.com
-
Email Status: Active
-
Forwarding Addresses : hr@mahendratechnosoft.com [Emails sent to info@mahendratechnosoft.com will be forwarded to hr@mahendratechnosoft.com]
-
4. Website Hosting Information:
-
Hosting Account ID: 4587895687
-
Hosting Plan: "Shared Hosting," "VPS Hosting," "Dedicated Server," "WordPress Hosting"
-
Renewal Date: 14/11/2026
-
Storage Quota: 10GB, 50GB, 100GB [The total storage space allocated to the hosting account]
-
Storage Used: 5GB, 25GB, 70GB [The current amount of storage space being used]
-
Bandwidth Quota: 100GB, 500GB, 1TB [The monthly bandwidth allowance]
-
Bandwidth Used: 500GB [The amount of bandwidth used in the current billing cycle]
-
Server Location: "US East," "EU West," "Asia Pacific"
-
Control Panel: cPanel, Plesk, DirectAdmin
-
SSL Certificate Status: Expired
-
Backup Status: Backup frequency: Weekly
-
Uptime: 99.9% uptime guaranteed
5. Email Information:
-
Email Account ID: 45879859458.
-
Domain ID: 4587584525.
-
Email Address: info@mahendratechnosoft.com.
-
Email Platform: Google Workspace
-
Account Status: Active
-
Storage Quota: 50GB
-
Storage Used: 5GB
-
Last Login: 14/5/2024, 7:30 PM.
-
Forwarding Addresses : Baner, Pune
-
Aliases:sales@mahendratechnosoft.com
-
Email Client Configuration Details: incoming/outgoing mail servers
6. Project Information:
-
Project ID : 2565891475866
-
Client ID : 5868959222
-
Project Name: Pharmagrowth
-
Project Description: Pharmagrowth specializes in providing tailored growth solutions for businesses in the pharmaceutical and healthcare sectors.
-
Service Type: Web Development.
-
Project URL : https://www.pharmagrowthhub.com/
-
Included Project Services: many-to-many relationship as a project can have multiple services and a service can be part of multiple projects
-
ProjectServiceID : 587948578
-
Project ID :125DH26637
-
Service ID :58745895455
-
Tools and Technologies Used: WordPress
-
Project Start Date: 12/1/2024
-
Current Phase: Development
-
Estimated Completion Date: 12/2/2025
-
Actual Completion Date : 14/2/2025
-
Progress : 30%
-
Deployment Status: Pending
-
Deployment Environment: Production
-
Deployment Date: 14/2/2025
-
Deployment Notes (Optional): Production
-
Materials & Resources: This can be handled in several ways:
-
File Storage/Links: Cloud Storage
-
Embedded Documents: For smaller documents, you might store the content directly in the database (less common for large files).
-
Fields in the database could be:
-
Resource ID:124578689
-
Project ID:5689484588
-
Resource Name: Development
-
Resource Type: Document
-
Resource : https://www.mahendratechnosoft.com/
-
Project Team : Information about the team members working on the project.
-
ProjectTeamID :58976895
-
Project ID:586897896
-
User ID:5689785289
-
Role: Developer
-
Database Design: Expanded
-
Projects Table: Includes all fields mentioned above except related tables
-
ProjectServices Table: Junction table for the project-service relationship
-
ProjectResources Table: For materials and resources
-
ProjectTeam Table: For project team members
-
Client Portal Display:
-
Project Overview : Cards
-
Project Name: Development
-
Service Type: Business consulting
-
Current Phase: Initiation
-
Estimated Completion Date: 16/11/2022
-
Progress: Hold
-
Project details: It is related to content creation, website design, consulting services, or something else
-
Project Description: Do you need help drafting a project proposal, timeline, or plan
-
Project URL: https://www.interioprop.com/
-
Included Services: Business consulting
-
Tools and Technologies Used: Wix Studio
-
Project Start Date: 15/06/2021
-
Current Phase: Incomplete
-
Estimated/Actual Completion Date: 15/02/2024
-
Deployment Status : Completed
-
Materials & Resources: Document
-
Project Team: Name with Development Team
7. Assigned Manager Contact Information:
-
Manager ID : 58798965456
-
Manager Name: Punam Sharma
-
Job Title/Role: Project Manager
-
Phone Number: +91-6897895895
-
Email Address: info@mahendratechnosoft.com
-
Profile Picture/Avatar : Photos
-
Department/Team : IT Department
-
Brief Bio/Introduction : Introduction
8. Invoices/Billings Information:
-
Invoice ID: 6897568956
-
Client ID: 9685874589
-
Invoice Number: INV-2024-10-001
-
Invoice Date: 25/5/2024
-
Due Date: 16/02/2024
-
Invoice Items: Products
-
InvoiceItemID:8989654789
-
Invoice ID: 6DH568955
-
Item Description: Details
-
Quantity: 8
-
Unit Price: $56548
-
Total Item Price: $5468
-
Subtotal: 658455156
-
Tax Amount: 588795615
-
Discount Amount: 45%
-
Total Amount: 273763
-
Payment Status: Paid
-
Payments: This requires a separate table to track payments made against invoices:
-
Payment ID: 8565465
-
Invoice ID: 4584688
-
Payment Date: 25/5/2023
-
Payment Method: Credit Card
-
Payment Amount: $5564
-
Calculations: 4568655615
-
Remaining Amount: $45564
-
Total Outstanding Balance: $456
-
Total Revenue: $4556569562
9. Support tickets
-
Invoice ID: 6897568956
-
Client ID: 9685874589
-
Invoice Number: INV-2024-10-001
-
Invoice Date: 25/5/2024
-
Due Date: 16/02/2024
-
Invoice Items: Products
-
InvoiceItemID:8989654789
-
Invoice ID: 6DH568955
-
Item Description: Details
-
Quantity: 8
-
Unit Price: $56548
-
Total Item Price: $5468
-
Subtotal: 658455156
-
Tax Amount: 588795615
-
Discount Amount: 45%
-
Total Amount: 273763
-
Payment Status: Paid
-
Payments: This requires a separate table to track payments made against invoices:
-
Payment ID: 8565465
-
Invoice ID: 4584688
-
Payment Date: 25/5/2023
-
Payment Method: Credit Card
-
Payment Amount: $5564
-
Calculations: 4568655615
-
Remaining Amount: $45564
-
Total Outstanding Balance: $456
-
Total Revenue: The sum of all Total Amount values for invoices within a specific date range.