Oris Technology Solution Ethiopia

\n \n Welcome back, {user.username}!\n \n\n \n \n

\n setView(\"projects\")}\n variant=\"primary\"\n fullWidth\n >\n 🏗️ View Projects\n \n setView(\"clients\")}\n variant=\"accent\"\n fullWidth\n >\n 👥 Manage Clients\n \n

\n \n\n \n \n

No recent activity

\n \n \n \n );\n case \"projects\":\n return (\n

\n \n \n Projects Management\n \n \n

\n\n \n

Manage current projects and tasks.

\n \n \n );\n case \"clients\":\n return (\n

\n \n \n Clients Management\n \n \n

\n\n \n

View and manage client information.

\n \n \n );\n case \"profile\":\n return (\n

\n \n Your Profile\n \n\n \n \n

\n \n Account Information\n \n

\n Username: {user.username}\n

\n Role: {user.role}\n

\n\n

\n \n Security\n \n \n

\n \n \n );\n default:\n return (\n

\n \n Welcome to Oris Technology Solution\n \n

Select an option from the sidebar.

\n );\n }\n } else {\n // Public website views\n switch (view) {\n case \"home\":\n return (\n

\n \n \n Empowering Businesses with Smart Technology\n \n \n At Oris Technology Solution Ethiopia, we provide innovative and practical technology services designed\n to streamline operations, improve security, and boost efficiency across various sectors.\n

\n setView(\"services\")}\n variant=\"accent\"\n >\n Explore Our Services\n \n setView(\"contact\")}\n variant=\"light\"\n >\n Contact Us\n \n

\n \n\n

\n \n Why Choose Oris Technology?\n \n \n \n \n 🔧\n

Tailored software designed specifically for your business needs with cutting-edge technology.

\n \n \n \n 👨‍💻\n \n

Experienced professionals dedicated to delivering quality solutions with passion.

\n \n \n \n 🛠️\n \n

Ongoing maintenance and 24/7 support for all our products and services.

\n \n \n \n\n

\n \n What Our Clients Say\n \n

\n {testimonials.map((testimonial, index) => (\n \n \n \"{testimonial.quote}\"\n

\n {testimonial.author}\n

{testimonial.role}

\n ))}\n \n {testimonials.map((_, index) => (\n setActiveTestimonial(index)}\n style={{\n width: \"12px\",\n height: \"12px\",\n borderRadius: \"50%\",\n border: \"none\",\n backgroundColor: index === activeTestimonial ? COLORS.primary : \"#ddd\",\n cursor: \"pointer\",\n transition: \"background-color 0.3s ease\",\n }}\n />\n ))}\n \n \n

\n \n );\n case \"services\":\n return (\n

\n \n Our Services\n \n\n

\n \n Custom System Development\n \n \n We develop tailored software solutions for various sectors to meet your specific needs with precision\n and innovation.\n

\n\n \n \n

Student management, grading, and scheduling systems to streamline educational administration.

\n setView(\"contact\")}\n variant=\"primary\"\n style={{ marginTop: \"16px\" }}\n >\n Learn More\n \n \n \n

\n Patient records, appointments, and medical inventory systems for efficient healthcare management.\n

\n setView(\"contact\")}\n variant=\"secondary\"\n style={{ marginTop: \"16px\" }}\n >\n Learn More\n \n \n \n

Product tracking, resource planning, and process automation for manufacturing efficiency.

\n setView(\"contact\")}\n variant=\"accent\"\n style={{ marginTop: \"16px\" }}\n >\n Learn More\n \n \n \n

Employee management systems for HR, payroll, and attendance tracking.

\n setView(\"contact\")}\n variant=\"primary\"\n style={{ marginTop: \"16px\" }}\n >\n Learn More\n \n \n

\n\n

\n \n Website Development\n \n \n

\n We design modern, mobile-friendly, and responsive websites to help you build a strong digital\n presence. Our websites are optimized for performance, accessibility, and user experience across\n all devices.\n

\n \n

Custom website design

E-commerce solutions

Content management systems

SEO optimization

\n \n setView(\"contact\")}\n variant=\"primary\"\n style={{ marginTop: \"16px\" }}\n >\n Get a Website Quote\n \n

\n {\n e.currentTarget.style.transform = \"scale(1.02)\";\n }}\n onMouseOut={(e) => {\n e.currentTarget.style.transform = \"scale(1)\";\n }}\n />\n

\n \n

\n\n

\n \n Networking Solutions\n \n \n

\n {\n e.currentTarget.style.transform = \"scale(1.02)\";\n }}\n onMouseOut={(e) => {\n e.currentTarget.style.transform = \"scale(1)\";\n }}\n />\n

\n From setup to maintenance, we ensure secure and reliable networking infrastructure for\n businesses and institutions. Our solutions include network design, implementation, and ongoing\n support with enterprise-grade security.\n

\n \n

Network design and implementation

Wireless networking solutions

Network security and firewalls

Ongoing maintenance and support

\n \n setView(\"contact\")}\n variant=\"primary\"\n style={{ marginTop: \"16px\" }}\n >\n Request Network Audit\n \n

\n \n

\n\n

\n \n Advanced GPS Vehicle Tracking\n \n \n \n \n \n Take full control of your vehicle or fleet with our state-of-the-art GPS technology featuring\n real-time monitoring and advanced analytics.\n

\n setView(\"contact\")}\n variant=\"accent\"\n >\n Demo GPS Tracking\n \n

\n \n \n \n \n \n \n \n

\n ✓ Real-Time Location\n

\n ✓ Theft Protection\n

\n ✓ Route History\n

\n ✓ Speed Monitoring\n

\n ✓ Fuel Efficiency\n

\n ✓ 24/7 Support\n

\n \n \n \n \n \n );\n case \"contact\":\n return (\n

\n \n Get in Touch\n \n\n {formSubmitted && (\n \n \n ✓\n

Thank you for your message! We'll get back to you soon.

\n \n )}\n\n \n

\n \n Your Name *\n \n \n

\n\n

\n \n Email Address *\n \n \n

\n\n

\n \n Phone Number\n \n \n

\n\n

\n \n Service Interested In\n \n \n \n \n \n \n \n \n \n

\n\n

\n \n Your Message *\n \n \n

\n\n \n Send Message\n \n \n

\n\n \n \n Prefer to email us directly?\n \n

\n Send your inquiries to: ezezsolomonferede@gmail.com\n

\n window.location.href = \"mailto:ezezsolomonferede@gmail.com\"}\n variant=\"secondary\"\n >\n Open Email Client\n \n \n \n );\n case \"login\":\n return (\n \n

\n \n \n 🔒\n \n

\n \n Employee Login\n \n

\n Access your Oris Technology account\n

\n \n\n {\n e.preventDefault();\n const form = e.target as HTMLFormElement;\n const username = (form.elements.namedItem(\"username\") as HTMLInputElement).value;\n const password = (form.elements.namedItem(\"password\") as HTMLInputElement).value;\n handleLogin(username, password);\n }}\n >\n

\n \n Username\n \n \n

\n\n

\n \n Password\n \n \n

\n\n \n Login\n \n\n

\n setView(\"home\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: COLORS.primary,\n cursor: \"pointer\",\n textDecoration: \"underline\",\n fontSize: \"0.9rem\",\n }}\n >\n ← Back to Home\n \n

\n \n \n );\n default:\n return (\n

\n \n Welcome to Oris Technology Solution Ethiopia\n \n

Page not found.

\n );\n }\n }\n };\n\n return (\n \n {user && (\n \n \n \n 💻\n \n \n Oris Technology\n \n \n Employee Portal\n

\n \n\n

\n setView(\"dashboard\")}\n variant={view === \"dashboard\" ? \"accent\" : \"light\"}\n fullWidth\n style={{\n marginBottom: \"12px\",\n justifyContent: \"flex-start\",\n paddingLeft: \"20px\",\n }}\n >\n 📊 Dashboard\n \n\n setView(\"projects\")}\n variant={view === \"projects\" ? \"accent\" : \"light\"}\n fullWidth\n style={{\n marginBottom: \"12px\",\n justifyContent: \"flex-start\",\n paddingLeft: \"20px\",\n }}\n >\n 🏗️ Projects\n \n\n setView(\"clients\")}\n variant={view === \"clients\" ? \"accent\" : \"light\"}\n fullWidth\n style={{\n marginBottom: \"12px\",\n justifyContent: \"flex-start\",\n paddingLeft: \"20px\",\n }}\n >\n 👥 Clients\n \n

\n\n \n setView(\"profile\")}\n variant={view === \"profile\" ? \"accent\" : \"light\"}\n fullWidth\n style={{\n justifyContent: \"flex-start\",\n paddingLeft: \"20px\",\n }}\n >\n 👤 Profile\n \n \n \n )}\n\n \n {user\n ? (\n \n \n Oris Technology Employee Portal\n \n

\n setIsDropdownOpen(!isDropdownOpen)}\n variant=\"light\"\n style={{\n display: \"flex\",\n alignItems: \"center\",\n gap: \"8px\",\n }}\n >\n \n {user.username.charAt(0).toUpperCase()}\n \n {user.username} ({user.role})\n \n {isDropdownOpen && (\n \n {\n setView(\"profile\");\n setIsDropdownOpen(false);\n }}\n style={{\n width: \"100%\",\n padding: \"12px 16px\",\n textAlign: \"left\",\n backgroundColor: \"transparent\",\n border: \"none\",\n cursor: \"pointer\",\n transition: \"background-color 0.2s\",\n \"&:hover\": {\n backgroundColor: COLORS.light,\n },\n }}\n >\n 👤 Profile\n \n \n 🚪 Logout\n \n

\n )}\n \n \n )\n : (\n \n setView(\"home\")}\n style={{\n display: \"flex\",\n alignItems: \"center\",\n cursor: \"pointer\",\n gap: \"12px\",\n }}\n >\n \n OT\n \n \n Oris Technology\n \n \n\n {/* Desktop Navigation */}\n \n setView(\"home\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: view === \"home\" ? COLORS.primary : COLORS.dark,\n cursor: \"pointer\",\n fontWeight: view === \"home\" ? 600 : 400,\n fontSize: \"1rem\",\n transition: \"color 0.2s\",\n \"&:hover\": {\n color: COLORS.primary,\n },\n }}\n >\n Home\n \n setView(\"services\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: view === \"services\" ? COLORS.primary : COLORS.dark,\n cursor: \"pointer\",\n fontWeight: view === \"services\" ? 600 : 400,\n fontSize: \"1rem\",\n transition: \"color 0.2s\",\n \"&:hover\": {\n color: COLORS.primary,\n },\n }}\n >\n Services\n \n setView(\"contact\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: view === \"contact\" ? COLORS.primary : COLORS.dark,\n cursor: \"pointer\",\n fontWeight: view === \"contact\" ? 600 : 400,\n fontSize: \"1rem\",\n transition: \"color 0.2s\",\n \"&:hover\": {\n color: COLORS.primary,\n },\n }}\n >\n Contact\n \n setView(\"login\")}\n variant=\"primary\"\n style={{ marginLeft: \"12px\" }}\n >\n Employee Login\n \n \n\n {/* Mobile Menu Button */}\n setIsMenuOpen(!isMenuOpen)}\n style={{\n display: { xs: \"block\", md: \"none\" },\n background: \"none\",\n border: \"none\",\n cursor: \"pointer\",\n padding: \"8px\",\n }}\n >\n \n \n \n \n \n )}\n\n {/* Mobile Menu */}\n {!user && isMenuOpen && (\n \n {\n setView(\"home\");\n setIsMenuOpen(false);\n }}\n style={{\n background: \"none\",\n border: \"none\",\n color: view === \"home\" ? COLORS.primary : COLORS.dark,\n cursor: \"pointer\",\n fontWeight: view === \"home\" ? 600 : 400,\n fontSize: \"1rem\",\n padding: \"12px\",\n textAlign: \"left\",\n borderRadius: \"8px\",\n transition: \"all 0.2s\",\n \"&:hover\": {\n backgroundColor: COLORS.light,\n },\n }}\n >\n Home\n \n {\n setView(\"services\");\n setIsMenuOpen(false);\n }}\n style={{\n background: \"none\",\n border: \"none\",\n color: view === \"services\" ? COLORS.primary : COLORS.dark,\n cursor: \"pointer\",\n fontWeight: view === \"services\" ? 600 : 400,\n fontSize: \"1rem\",\n padding: \"12px\",\n textAlign: \"left\",\n borderRadius: \"8px\",\n transition: \"all 0.2s\",\n \"&:hover\": {\n backgroundColor: COLORS.light,\n },\n }}\n >\n Services\n \n {\n setView(\"contact\");\n setIsMenuOpen(false);\n }}\n style={{\n background: \"none\",\n border: \"none\",\n color: view === \"contact\" ? COLORS.primary : COLORS.dark,\n cursor: \"pointer\",\n fontWeight: view === \"contact\" ? 600 : 400,\n fontSize: \"1rem\",\n padding: \"12px\",\n textAlign: \"left\",\n borderRadius: \"8px\",\n transition: \"all 0.2s\",\n \"&:hover\": {\n backgroundColor: COLORS.light,\n },\n }}\n >\n Contact\n \n {\n setView(\"login\");\n setIsMenuOpen(false);\n }}\n variant=\"primary\"\n fullWidth\n style={{ marginTop: \"8px\" }}\n >\n Employee Login\n \n \n )}\n\n \n \n {renderContent()}\n \n \n\n {!user && (\n \n \n

\n \n Oris Technology\n \n \n Empowering Businesses, Institutions & Individuals with Smart Technology Solutions.\n

\n\n

\n \n Quick Links\n \n \n

\n setView(\"home\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: \"rgba(255,255,255,0.7)\",\n cursor: \"pointer\",\n textAlign: \"left\",\n padding: 0,\n \"&:hover\": {\n color: COLORS.white,\n },\n }}\n >\n Home\n \n

\n setView(\"services\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: \"rgba(255,255,255,0.7)\",\n cursor: \"pointer\",\n textAlign: \"left\",\n padding: 0,\n \"&:hover\": {\n color: COLORS.white,\n },\n }}\n >\n Services\n \n

\n setView(\"contact\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: \"rgba(255,255,255,0.7)\",\n cursor: \"pointer\",\n textAlign: \"left\",\n padding: 0,\n \"&:hover\": {\n color: COLORS.white,\n },\n }}\n >\n Contact\n \n

\n setView(\"login\")}\n style={{\n background: \"none\",\n border: \"none\",\n color: \"rgba(255,255,255,0.7)\",\n cursor: \"pointer\",\n textAlign: \"left\",\n padding: 0,\n \"&:hover\": {\n color: COLORS.white,\n },\n }}\n >\n Employee Login\n \n

\n \n

\n\n

\n \n Contact Us\n \n \n

\n ✉️ ezezsolomonferede@gmail.com\n

\n 📍 Addis Ababa, Ethiopia\n

\n \n

\n \n\n \n © {new Date().getFullYear()} Oris Technology Solution Ethiopia. All rights reserved.\n \n \n )}\n \n \n );\n}\n\nexport default App;",[],[99,170],{"_103":179,"_95":180,"_151":181,"_153":152,"_154":137,"_155":136,"_157":158,"_105":182,"_100":183,"_161":174,"_163":184,"_164":22,"_165":-5,"_166":185,"_98":186},"2e544bb6-5e58-11f0-b371-0224a6c84d84","constants.tsx","c0dc77a8-5c94-11f0-bbe0-0224a6c84d84",["D",1752239327578],16,"// constants.ts\n\n// Modern color palette\nexport const COLORS = {\n primary: \"#4cc9f0\", // Vibrant blue\n primaryLight: \"#4895ef\", // Lighter blue\n primaryDark: \"#3a0ca3\", // Dark blue\n secondary: \"#f72585\", // Pink\n accent: \"#4cc9f0\", // Cyan\n light: \"#f8f9fa\", // Off-white\n dark: \"#212529\", // Dark gray\n white: \"#ffffff\",\n success: \"#4bb543\",\n warning: \"#f0ad4e\",\n danger: \"#d9534f\",\n};\n\n// Modern typography\nexport const FONTS = {\n heading: \"'Poppins', sans-serif\",\n body: \"'Open Sans', sans-serif\",\n};\n\n// Service images\nexport const SERVICE_IMAGES = {\n school:\n \"https://images.unsplash.com/photo-1523050854058-8df90110c9f1?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1470&q=80\",\n hospital:\n \"https://images.unsplash.com/photo-1579684385127-1ef15d508118?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1470&q=80\",\n factory:\n \"https://images.unsplash.com/photo-1504275107627-0c2ba7a43b1a?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1374&q=80\",\n organization:\n \"https://images.unsplash.com/photo-1521737711867-e3b97375f902?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1374&q=80\",\n website:\n \"https://images.unsplash.com/photo-1547658719-da2b51169166?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1528&q=80\",\n networking:\n \"https://images.unsplash.com/photo-1558494949-ef010cbdcc31?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1374&q=80\",\n gps:\n \"https://images.unsplash.com/photo-1501706362039-c06b2d715385?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1374&q=80\",\n hero:\n \"https://images.unsplash.com/photo-1451187580459-43490279c0fa?ixlib=rb-4.0.3&ixid=M3wxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8fA%3D%3D&auto=format&fit=crop&w=1472&q=80\",\n};\n\n// Dynamic base style for buttons\nexport const baseStyle = (fullWidth: boolean = false) => ({\n display: \"inline-flex\",\n alignItems: \"center\",\n justifyContent: \"center\",\n padding: \"12px 24px\",\n borderRadius: \"8px\",\n fontSize: \"1rem\",\n fontWeight: 600,\n cursor: \"pointer\",\n transition: \"all 0.3s ease\",\n border: \"none\",\n width: fullWidth ? \"100%\" : \"auto\",\n textDecoration: \"none\",\n});\n\n// Button variant styles\nexport const variantStyles = {\n primary: {\n backgroundColor: COLORS.primary,\n color: COLORS.white,\n \"&:hover\": { backgroundColor: COLORS.primaryDark },\n },\n secondary: {\n backgroundColor: COLORS.secondary,\n color: COLORS.white,\n \"&:hover\": { backgroundColor: \"#d3166e\" },\n },\n accent: {\n backgroundColor: COLORS.accent,\n color: COLORS.dark,\n \"&:hover\": { backgroundColor: \"#2fb3d8\" },\n },\n light: {\n backgroundColor: COLORS.light,\n color: COLORS.dark,\n \"&:hover\": { backgroundColor: \"#e9ecef\" },\n },\n dark: {\n backgroundColor: COLORS.dark,\n color: COLORS.white,\n \"&:hover\": { backgroundColor: \"#343a40\" },\n },\n};\n\n// Utility function for password hashing\nexport async function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password);\n const hash = await crypto.subtle.digest(\"SHA-256\", data);\n return Array.from(new Uint8Array(hash))\n .map(b => b.toString(16).padStart(2, \"0\"))\n .join(\"\");\n}\n\n// Testimonial data\nexport const testimonials = [\n {\n quote:\n \"Oris Technology transformed our school management system, saving us hours of administrative work each week.\",\n author: \"Dr. Alemayehu Kebede\",\n role: \"Principal, Addis Ababa High School\",\n },\n {\n quote: \"The GPS tracking solution has significantly improved our fleet management and reduced fuel costs by 15%.\",\n author: \"Mekdes Girma\",\n role: \"Operations Manager, Express Delivery\",\n },\n {\n quote: \"Their custom software for our hospital has streamlined patient records and improved our service delivery.\",\n author: \"Dr. Selamawit Tesfaye\",\n role: \"Medical Director, St. Paul's Hospital\",\n },\n];\n\n// Navigation items\nexport const NAV_ITEMS = [\n { label: \"Home\", path: \"home\" },\n { label: \"Services\", path: \"services\" },\n { label: \"Contact\", path: \"contact\" },\n { label: \"Employee Login\", path: \"login\", isButton: true },\n];",[],[99,180],[99],{"_103":189,"_95":190,"_151":191,"_153":-5,"_154":137,"_155":192,"_157":158,"_105":193,"_100":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_166":194,"_98":195},"bea62a66-5c89-11f0-956e-0224a6c84d84","pics","b7b77df4-5c89-11f0-8f8b-0224a6c84d84",28,["D",1752040712722],[],[190],{"_103":197,"_95":198,"_151":199,"_153":-5,"_154":137,"_155":200,"_157":158,"_105":201,"_100":160,"_161":174,"_163":72,"_164":22,"_165":-5,"_166":202,"_98":203},"b69c0484-5c94-11f0-b76e-0224a6c84d84","admin.tsx","b2750ad6-5c94-11f0-958e-0224a6c84d84",32,["D",1752045423695],[],[198],{"_103":205,"_95":206,"_151":207,"_153":-5,"_154":137,"_155":208,"_157":158,"_105":209,"_100":160,"_161":174,"_163":72,"_164":22,"_165":-5,"_166":210,"_98":211},"f7ac0bbe-5cac-11f0-b3c5-0224a6c84d84","login.tsx","f3ac1248-5cac-11f0-b3c5-0224a6c84d84",43,["D",1752055840769],[],[206],{"_103":213,"_95":214,"_151":215,"_153":-5,"_154":137,"_155":136,"_157":158,"_105":216,"_100":217,"_161":218,"_163":219,"_164":22,"_165":220,"_166":221,"_98":222},"2e5451ce-5e58-11f0-b371-0224a6c84d84","main.tsx","78e072f4-5bfb-11f0-9149-0224a6c84d84",["D",1752239327578],37,"http","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport React, { useEffect, useRef, useState } from \"https://esm.sh/react@18.2.0\";\n\nimport { COLORS, FONTS, hashPassword, SERVICE_IMAGES, testimonials } from \"./components/constants.tsx\";\n\nimport App from \"./components/app.tsx\";\n\n// Client-side rendering\nfunction client() {\n const rootElement = document.getElementById(\"root\");\n if (rootElement) {\n createRoot(rootElement).render();\n } else {\n console.error(\"Failed to find the root element\");\n }\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\n// Server-side functions\nexport default async function server(request: Request) {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"OrisTechnology\";\n\n // Create tables if they don't exist\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_employees (\n employee_id INTEGER PRIMARY KEY,\n first_name TEXT,\n last_name TEXT,\n role TEXT,\n status TEXT DEFAULT 'active',\n email TEXT UNIQUE,\n phone TEXT,\n password TEXT,\n date_hired datetime,\n created_at datetime DEFAULT CURRENT_TIMESTAMP,\n updated_at datetime DEFAULT CURRENT_TIMESTAMP,\n user_name TEXT UNIQUE,\n address TEXT,\n grade TEXT,\n sex TEXT,\n supervisor_id INTEGER,\n department TEXT,\n job_title TEXT,\n date_of_birth datetime,\n FOREIGN KEY (supervisor_id) REFERENCES ${KEY}_employees(employee_id) ON DELETE SET NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_projects (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n description TEXT,\n client_id INTEGER,\n start_date datetime,\n end_date datetime,\n status TEXT,\n created_at datetime DEFAULT CURRENT_TIMESTAMP,\n updated_at datetime DEFAULT CURRENT_TIMESTAMP,\n employee_id INTEGER,\n FOREIGN KEY (employee_id) REFERENCES ${KEY}_employees(employee_id) ON DELETE SET NULL,\n FOREIGN KEY (client_id) REFERENCES ${KEY}_clients(id) ON DELETE SET NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_clients (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n contact_person TEXT,\n email TEXT,\n phone TEXT,\n address TEXT,\n created_at datetime DEFAULT CURRENT_TIMESTAMP,\n updated_at datetime DEFAULT CURRENT_TIMESTAMP,\n employee_id INTEGER,\n FOREIGN KEY (employee_id) REFERENCES ${KEY}_employees(employee_id) ON DELETE SET NULL\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_contacts (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT,\n email TEXT,\n phone TEXT,\n message TEXT,\n service TEXT,\n created_at datetime DEFAULT CURRENT_TIMESTAMP,\n status TEXT DEFAULT 'new'\n )\n `);\n\n // Handle routes\n const url = new URL(request.url);\n const path = url.pathname;\n const method = request.method;\n\n // Login endpoint\n if (path === \"/login\" && method === \"POST\") {\n try {\n const body = await request.json();\n if (!body.username || !body.password) {\n return new Response(\n JSON.stringify({ success: false, message: \"Username and password are required\" }),\n { status: 400, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n const hashedPassword = await hashPassword(body.password);\n const result = await sqlite.execute(\n `SELECT employee_id, user_name, role FROM ${KEY}_employees \n WHERE user_name = ? AND password = ?`,\n [body.username, hashedPassword],\n );\n\n if (result.rows.length > 0) {\n return new Response(\n JSON.stringify({\n success: true,\n user: {\n id: result.rows[0].employee_id,\n username: result.rows[0].user_name,\n role: result.rows[0].role,\n },\n }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n } else {\n return new Response(\n JSON.stringify({ success: false, message: \"Invalid username or password\" }),\n { status: 401, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n } catch (error) {\n console.error(\"Login error:\", error);\n return new Response(\n JSON.stringify({ success: false, message: \"Internal server error during login\" }),\n { status: 500, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n }\n\n // Contact form submission\n if (path === \"/contact\" && method === \"POST\") {\n try {\n const body = await request.json();\n if (!body.name || !body.email || !body.message) {\n return new Response(\n JSON.stringify({ success: false, message: \"Name, email, and message are required\" }),\n { status: 400, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n\n await sqlite.execute(\n `INSERT INTO ${KEY}_contacts (name, email, phone, message, service)\n VALUES (?, ?, ?, ?, ?)`,\n [body.name, body.email, body.phone || null, body.message, body.service || null],\n );\n\n return new Response(\n JSON.stringify({ success: true, message: \"Thank you for your message!\" }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n } catch (error) {\n console.error(\"Contact form error:\", error);\n return new Response(\n JSON.stringify({ success: false, message: \"Failed to submit contact form\" }),\n { status: 500, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n }\n\n // Get all contacts for dashboard\n if (path === \"/contacts\" && method === \"GET\") {\n try {\n const result = await sqlite.execute(\n `SELECT * FROM ${KEY}_contacts ORDER BY created_at DESC`,\n );\n return new Response(\n JSON.stringify({ success: true, contacts: result.rows }),\n { headers: { \"Content-Type\": \"application/json\" } },\n );\n } catch (error) {\n console.error(\"Error fetching contacts:\", error);\n return new Response(\n JSON.stringify({ success: false, message: \"Failed to fetch contacts\" }),\n { status: 500, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n }\n\n // Root path - serve HTML\n if (path === \"/\" && method === \"GET\") {\n return new Response(\n `\n \n \n Oris Technology Solution Ethiopia\n \n \n \n \n \n \n 💻\">\n \n \n \n

\n \n \n \n `,\n { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } },\n );\n }\n\n // Fallback for unknown paths\n return new Response(\"Not Found\", { status: 404, headers: { \"Content-Type\": \"text/plain\" } });\n } catch (error) {\n console.error(\"Server error:\", error);\n return new Response(\n JSON.stringify({ success: false, message: \"Internal server error\" }),\n { status: 500, headers: { \"Content-Type\": \"application/json\" } },\n );\n }\n}","oristechnology",[],[214],{"_103":224,"_95":225,"_151":226,"_153":-5,"_154":137,"_155":227,"_157":158,"_105":228,"_100":160,"_161":174,"_163":72,"_164":22,"_165":-5,"_166":229,"_98":230},"a86278e0-5cac-11f0-91af-0224a6c84d84","renderContent.tsx","a25ba098-5cac-11f0-a99a-0224a6c84d84",41,["D",1752055707755],[],[225],"files",[149,168,178,188,196,204,212,223],"counts",{"_235":32,"_236":160,"_237":32,"_238":239},"pulls","branches","forks","envVars",{"_240":32,"_241":32},"count","emptyCount","contents",[244,247],{"_103":169,"_95":170,"_151":171,"_153":152,"_154":137,"_155":136,"_157":158,"_105":245,"_100":173,"_161":174,"_163":175,"_164":22,"_165":-5,"_98":246},["D",1752239327578],[99,170],{"_103":179,"_95":180,"_151":181,"_153":152,"_154":137,"_155":136,"_157":158,"_105":248,"_100":183,"_161":174,"_163":184,"_164":22,"_165":-5,"_98":249},["D",1752239327578],[99,180],"file",{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":156,"_157":158,"_105":252,"_100":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_98":253},["D",1752055911820],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":262,"_147":267,"_231":292,"_250":293,"_242":295,"_300":-5,"_301":-5,"_302":-5,"_303":-5,"_304":305},{"_103":104,"_95":96,"_105":263,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":264,"_131":265,"_134":266,"_146":22},["D",1751979607118],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},[268,277,280,283,286,289],{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":156,"_157":158,"_105":159,"_100":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_166":269,"_98":276},[270,273],{"_103":169,"_95":170,"_151":171,"_153":152,"_154":137,"_155":136,"_157":158,"_105":172,"_100":173,"_161":174,"_163":175,"_164":22,"_165":-5,"_166":271,"_98":272},[],[99,170],{"_103":179,"_95":180,"_151":181,"_153":152,"_154":137,"_155":136,"_157":158,"_105":182,"_100":183,"_161":174,"_163":184,"_164":22,"_165":-5,"_166":274,"_98":275},[],[99,180],[99],{"_103":189,"_95":190,"_151":191,"_153":-5,"_154":137,"_155":192,"_157":158,"_105":193,"_100":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_166":278,"_98":279},[],[190],{"_103":197,"_95":198,"_151":199,"_153":-5,"_154":137,"_155":200,"_157":158,"_105":201,"_100":160,"_161":174,"_163":72,"_164":22,"_165":-5,"_166":281,"_98":282},[],[198],{"_103":205,"_95":206,"_151":207,"_153":-5,"_154":137,"_155":208,"_157":158,"_105":209,"_100":160,"_161":174,"_163":72,"_164":22,"_165":-5,"_166":284,"_98":285},[],[206],{"_103":213,"_95":214,"_151":215,"_153":-5,"_154":137,"_155":136,"_157":158,"_105":216,"_100":217,"_161":218,"_163":219,"_164":22,"_165":220,"_166":287,"_98":288},[],[214],{"_103":224,"_95":225,"_151":226,"_153":-5,"_154":137,"_155":227,"_157":158,"_105":228,"_100":160,"_161":174,"_163":72,"_164":22,"_165":-5,"_166":290,"_98":291},[],[225],[268,270,273,277,280,283,286,289],{"_103":150,"_95":99,"_151":152,"_153":-5,"_154":137,"_155":156,"_157":158,"_105":252,"_100":160,"_161":162,"_163":-5,"_164":22,"_165":-5,"_98":294},[99],[296,298],{"_103":169,"_95":170,"_151":171,"_153":152,"_154":137,"_155":136,"_157":158,"_105":245,"_100":173,"_161":174,"_163":175,"_164":22,"_165":-5,"_98":297},[99,170],{"_103":179,"_95":180,"_151":181,"_153":152,"_154":137,"_155":136,"_157":158,"_105":248,"_100":183,"_161":174,"_163":184,"_164":22,"_165":-5,"_98":299},[99,180],"upstream","pull","ahead","behind","templates",[],"actionData","errors"]

solomonferedeezez

oris