Gecko [ 8jobspot.com ]

Name	Size	Permission
.git	[ DIR ]	drwxr-xr-x
.well-known	[ DIR ]	drwxr-xr-x
app	[ DIR ]	drwxr-xr-x
bootstrap	[ DIR ]	drwxr-xr-x
cgi-bin	[ DIR ]	drwxr-xr-x
config	[ DIR ]	drwxr-xr-x
database	[ DIR ]	drwxr-xr-x
mobile-app	[ DIR ]	drwxr-xr-x
public	[ DIR ]	drwxr-xr-x
resources	[ DIR ]	drwxr-xr-x
routes	[ DIR ]	drwxr-xr-x
storage	[ DIR ]	drwxr-xr-x
tests	[ DIR ]	drwxr-xr-x
vendor	[ DIR ]	drwxr-xr-x
.DS_Store	8 KB	-rw-r--r--
.env	1.5 KB	-rw-r--r--
.gitattributes	66 B	-rw-r--r--
.gitignore	41 B	-rw-r--r--
.htaccess	386 B	-rw-r--r--
.mad-root	0 B	-rw-r--r--
8LEARNING_TRANSFORMATION_COMPL...	8.33 KB	-rw-r--r--
BACKEND_COMPLETION_SUMMARY.md	3.47 KB	-rw-r--r--
CHAT_REFACTORING_COMPLETION_RE...	5.99 KB	-rw-r--r--
COURSE_ADMIN_CONTROLLERS_SUMMA...	7.93 KB	-rw-r--r--
COURSE_MODULE_DUMMY_DATA_SUMMA...	6.27 KB	-rw-r--r--
EIGHT_LEARNING_API_TEST_RESULT...	6.92 KB	-rw-r--r--
ENHANCED_LEARNING_SYSTEM_PLAN....	9.62 KB	-rw-r--r--
README.md	31 B	-rw-r--r--
artisan	1.65 KB	-rw-r--r--
composer.json	2.22 KB	-rw-r--r--
composer.lock	395.26 KB	-rw-r--r--
debug_registration.php	0 B	-rw-r--r--
error_log	248 B	-rw-r--r--
generate_course_dummy_data.php	39.75 KB	-rw-r--r--
generate_course_dummy_data_bac...	39.75 KB	-rw-r--r--
generate_uganda_course_dummy_d...	15.63 KB	-rw-r--r--
hospital.sql	383.84 KB	-rw-r--r--
important-commands.txt	468 B	-rw-r--r--
loundry-app-stps.md	672 B	-rw-r--r--
package.json	473 B	-rw-r--r--
phpunit.xml	1.17 KB	-rw-r--r--
quick_auth_test.php	2 KB	-rw-r--r--
server.php	563 B	-rw-r--r--
test_all_api_endpoints.php	33.84 KB	-rw-r--r--
test_blog_api.php	4.24 KB	-rw-r--r--
test_camelcase_endpoint.php	1.08 KB	-rw-r--r--
test_chat_api.php	4.09 KB	-rw-r--r--
test_chat_system.php	3.99 KB	-rw-r--r--
test_company_update.php	1.25 KB	-rw-r--r--
test_contact_api.php	2.48 KB	-rw-r--r--
test_delete_account.php	0 B	-rw-r--r--
test_gdpr.php	2.63 KB	-rw-r--r--
test_gdpr_duplicate_request.ph...	2.58 KB	-rw-r--r--
test_learning_api.php	5.17 KB	-rw-r--r--
test_learning_api_complete.php	9.16 KB	-rw-r--r--
test_learning_endpoints.php	9.62 KB	-rw-r--r--
test_login.php	3.17 KB	-rw-r--r--
test_my_chats.php	2.04 KB	-rw-r--r--
test_registration.php	0 B	-rw-r--r--
test_send_message.php	2.57 KB	-rw-r--r--
update_uganda_courses.php	5.58 KB	-rw-r--r--
webpack.mix.js	559 B	-rw-r--r--

Code Editor : generate_uganda_course_dummy_data.php

<?phprequire_once __DIR__ . '/vendor/autoload.php';use Illuminate\Database\Capsule\Manager as Capsule;use Illuminate\Support\Str;use Illuminate\Support\Facades\DB;// Bootstrap Laravel for database access$app = require_once __DIR__ . '/bootstrap/app.php';$kernel = $app->make(Illuminate\Contracts\Console\Kernel::class);$kernel->bootstrap();echo "🚀 Starting Uganda-Focused Course Module Dummy Data Generation...\n";// Create storage directory for images$storageImagesPath = storage_path('app/public/images');if (!is_dir($storageImagesPath)) {    mkdir($storageImagesPath, 0755, true);    echo "📁 Created storage directory: $storageImagesPath\n";}// Uganda-focused Course Categories$categories = [    [        'name' => 'Agriculture & Farming',        'description' => 'Modern farming techniques, crop management, livestock, and sustainable agriculture practices for Uganda.',        'icon' => 'fas fa-seedling',        'color' => '#27ae60',        'status' => 'active',        'sort_order' => 1,    ],    [        'name' => 'Carpentry & Woodworking',        'description' => 'Learn professional carpentry skills, furniture making, and woodworking techniques using local materials.',        'icon' => 'fas fa-hammer',        'color' => '#8b4513',        'status' => 'active',        'sort_order' => 2,    ],    [        'name' => 'Tailoring & Fashion Design',        'description' => 'Master sewing, tailoring, and fashion design skills to start your own clothing business.',        'icon' => 'fas fa-cut',        'color' => '#e91e63',        'status' => 'active',        'sort_order' => 3,    ],    [        'name' => 'Small Business & Entrepreneurship',        'description' => 'Start and grow small businesses in Uganda, including market analysis and financial management.',        'icon' => 'fas fa-store',        'color' => '#ff9800',        'status' => 'active',        'sort_order' => 4,    ],    [        'name' => 'Technology & Computer Skills',        'description' => 'Basic to advanced computer skills, web development, and digital literacy for the modern workplace.',        'icon' => 'fas fa-laptop',        'color' => '#2196f3',        'status' => 'active',        'sort_order' => 5,    ],    [        'name' => 'Construction & Building',        'description' => 'Learn construction techniques, masonry, plumbing, and electrical work for the building industry.',        'icon' => 'fas fa-hard-hat',        'color' => '#ff5722',        'status' => 'active',        'sort_order' => 6,    ],    [        'name' => 'Food Processing & Catering',        'description' => 'Food preparation, preservation, catering services, and restaurant management skills.',        'icon' => 'fas fa-utensils',        'color' => '#4caf50',        'status' => 'active',        'sort_order' => 7,    ],    [        'name' => 'Motor Vehicle Mechanics',        'description' => 'Automotive repair, motorcycle maintenance, and vehicle servicing skills for the transport sector.',        'icon' => 'fas fa-wrench',        'color' => '#607d8b',        'status' => 'active',        'sort_order' => 8,    ],    [        'name' => 'Financial Literacy & Savings',        'description' => 'Personal finance, savings groups (VSLAs), microfinance, and investment strategies for Ugandans.',        'icon' => 'fas fa-piggy-bank',        'color' => '#9c27b0',        'status' => 'active',        'sort_order' => 9,    ],    [        'name' => 'Languages & Communication',        'description' => 'English proficiency, local languages, and communication skills for personal and professional growth.',        'icon' => 'fas fa-comments',        'color' => '#673ab7',        'status' => 'active',        'sort_order' => 10,    ],];// Insert categoriesecho "📚 Inserting course categories...\n";DB::table('course_categories')->truncate();foreach ($categories as $category) {    $category['created_at'] = now();    $category['updated_at'] = now();    DB::table('course_categories')->insert($category);}echo "✅ Inserted " . count($categories) . " course categories\n";// Course templates for generation$courseTemplates = [    ['Agriculture & Farming', 'Modern Maize Farming Techniques in Uganda'],    ['Agriculture & Farming', 'Coffee Growing and Processing for Export'],    ['Agriculture & Farming', 'Poultry Farming Business Setup'],    ['Agriculture & Farming', 'Organic Vegetable Farming'],    ['Agriculture & Farming', 'Pig Farming and Management'],    ['Agriculture & Farming', 'Fish Farming and Aquaculture'],    ['Agriculture & Farming', 'Banana Cultivation and Value Addition'],    ['Carpentry & Woodworking', 'Professional Furniture Making with Local Woods'],    ['Carpentry & Woodworking', 'Building Traditional Ugandan Structures'],    ['Carpentry & Woodworking', 'Cabinet Making for Modern Homes'],    ['Carpentry & Woodworking', 'Wood Carving and Artistic Woodwork'],    ['Carpentry & Woodworking', 'Tool Maintenance and Workshop Setup'],    ['Tailoring & Fashion Design', 'Professional Tailoring and Gomesi Making'],    ['Tailoring & Fashion Design', 'Modern African Fashion Design'],    ['Tailoring & Fashion Design', 'Pattern Making and Cutting'],    ['Tailoring & Fashion Design', 'Starting a Tailoring Business'],    ['Tailoring & Fashion Design', 'Kanzu and Traditional Menswear'],    ['Small Business & Entrepreneurship', 'Market Stall Business Management'],    ['Small Business & Entrepreneurship', 'Mobile Money Agent Business'],    ['Small Business & Entrepreneurship', 'Boda Boda Business and Fleet Management'],    ['Small Business & Entrepreneurship', 'Beauty Salon Business Setup'],    ['Small Business & Entrepreneurship', 'Digital Marketing for Small Businesses'],    ['Technology & Computer Skills', 'Computer Basics for Beginners'],    ['Technology & Computer Skills', 'Microsoft Office for Business'],    ['Technology & Computer Skills', 'Basic Web Design and WordPress'],    ['Technology & Computer Skills', 'Digital Literacy and Internet Safety'],    ['Technology & Computer Skills', 'Mobile App Development Basics'],    ['Construction & Building', 'House Construction Planning'],    ['Construction & Building', 'Plumbing Installation and Repair'],    ['Construction & Building', 'Electrical Wiring for Homes'],    ['Construction & Building', 'Masonry and Concrete Work'],    ['Construction & Building', 'Roofing Techniques and Materials'],    ['Food Processing & Catering', 'Food Preservation and Storage'],    ['Food Processing & Catering', 'Catering Business Management'],    ['Food Processing & Catering', 'Local Cuisine and Restaurant Skills'],    ['Food Processing & Catering', 'Bakery Business Setup'],    ['Food Processing & Catering', 'Food Safety and Hygiene'],    ['Motor Vehicle Mechanics', 'Basic Car Maintenance and Repair'],    ['Motor Vehicle Mechanics', 'Motorcycle Repair and Maintenance'],    ['Motor Vehicle Mechanics', 'Auto Electrical Systems'],    ['Motor Vehicle Mechanics', 'Starting a Garage Business'],    ['Motor Vehicle Mechanics', 'Heavy Truck and Bus Maintenance'],    ['Financial Literacy & Savings', 'Personal Budgeting and Savings'],    ['Financial Literacy & Savings', 'VSLA Groups Management'],    ['Financial Literacy & Savings', 'Microfinance and Loans'],    ['Financial Literacy & Savings', 'Investment Opportunities in Uganda'],    ['Financial Literacy & Savings', 'Banking and Financial Services'],    ['Languages & Communication', 'English Communication Skills'],    ['Languages & Communication', 'Luganda Language Basics'],    ['Languages & Communication', 'Public Speaking and Presentation'],];$categoryMap = [    'Agriculture & Farming' => 1,    'Carpentry & Woodworking' => 2,    'Tailoring & Fashion Design' => 3,    'Small Business & Entrepreneurship' => 4,    'Technology & Computer Skills' => 5,    'Construction & Building' => 6,    'Food Processing & Catering' => 7,    'Motor Vehicle Mechanics' => 8,    'Financial Literacy & Savings' => 9,    'Languages & Communication' => 10,];$ugandanInstructors = [    'Robert Mukasa', 'Sarah Namubiru', 'John Okello', 'Grace Nakato', 'David Ssemakula',    'Mary Namuli', 'Patrick Wamala', 'Alice Namatovu', 'Joseph Kiwanuka', 'Betty Nalwanga',    'Samuel Bbosa', 'Jane Kisakye', 'Moses Lubega', 'Florence Namusoke', 'Emmanuel Kaggwa'];// Generate coursesecho "🎓 Generating courses...\n";DB::table('courses')->truncate();$allCourses = [];$insertedSlugs = [];for ($i = 0; $i < 50; $i++) {    $template = $courseTemplates[$i % count($courseTemplates)];    $categoryName = $template[0];    $courseTitle = $template[1];        // Create unique slug    $baseSlug = Str::slug($courseTitle);    $slug = $baseSlug;    $counter = 1;    while (in_array($slug, $insertedSlugs)) {        $slug = $baseSlug . '-' . $counter;        $counter++;    }    $insertedSlugs[] = $slug;        $course = [        'category_id' => $categoryMap[$categoryName],        'title' => $courseTitle,        'slug' => $slug,        'description' => "Master {$courseTitle} with practical hands-on training and expert guidance from experienced Ugandan instructors.",        'detailed_description' => "Comprehensive course on {$courseTitle} designed specifically for Ugandan learners. Includes practical exercises, real-world applications, and business insights relevant to the local market.",        'instructor_name' => $ugandanInstructors[array_rand($ugandanInstructors)],        'instructor_bio' => 'Experienced professional with years of industry expertise in Uganda.',        'instructor_avatar' => 'instructors/default.jpg',        'cover_image' => str_replace([' ', '&'], ['-', 'and'], strtolower($courseTitle)) . '.jpg',        'preview_video' => 'previews/default-preview.mp4',        'price' => rand(200000, 1000000), // UGX 200,000 - 1,000,000        'currency' => 'UGX',        'duration_hours' => rand(20, 60),        'difficulty_level' => ['Beginner', 'Intermediate', 'Advanced'][rand(0, 2)],        'language' => 'English',        'requirements' => json_encode(['Basic interest in the subject', 'Commitment to learning']),        'what_you_learn' => json_encode([            'Fundamental concepts and techniques',            'Practical hands-on skills',            'Business and income opportunities',            'Industry best practices',            'Problem-solving approaches'        ]),        'tags' => json_encode([str_replace(' ', '', $categoryName), 'Uganda', 'Practical Skills']),        'status' => 'active',        'featured' => rand(0, 1) ? 'yes' : 'no',        'rating_average' => rand(40, 50) / 10,        'rating_count' => rand(100, 3000),        'enrollment_count' => rand(500, 5000),        'created_at' => now(),        'updated_at' => now(),    ];        DB::table('courses')->insert($course);    $allCourses[] = $course;}echo "✅ Inserted 50 courses\n";// Generate Course Unitsecho "📖 Generating course units...\n";DB::table('course_units')->truncate();$unitTitles = [    'Introduction and Getting Started',    'Basic Concepts and Fundamentals',    'Tools and Equipment Setup',    'Practical Hands-on Training',    'Advanced Techniques',    'Quality Control and Standards',    'Business and Marketing Aspects',    'Safety and Best Practices',    'Troubleshooting Common Issues',    'Final Project and Assessment'];$unitCount = 0;for ($courseId = 1; $courseId <= 50; $courseId++) {    $unitsPerCourse = rand(8, 15);    for ($unitOrder = 1; $unitOrder <= $unitsPerCourse; $unitOrder++) {        $unitCount++;        DB::table('course_units')->insert([            'course_id' => $courseId,            'title' => $unitTitles[array_rand($unitTitles)] . " - Part {$unitOrder}",            'description' => "Comprehensive coverage of unit {$unitOrder} with practical examples and exercises.",            'sort_order' => $unitOrder,            'duration_minutes' => rand(30, 90),            'is_preview' => $unitOrder <= 2 ? 'yes' : 'no',            'status' => 'active',            'created_at' => now(),            'updated_at' => now(),        ]);    }}echo "✅ Generated {$unitCount} course units\n";// Generate Course Materialsecho "📹 Generating course materials...\n";DB::table('course_materials')->truncate();$materialTypes = ['video', 'pdf', 'assignment', 'quiz', 'live_session'];$materialCount = 0;for ($unitId = 1; $unitId <= $unitCount; $unitId++) {    $materialsPerUnit = rand(3, 8);    for ($i = 1; $i <= $materialsPerUnit; $i++) {        $materialCount++;        $type = $materialTypes[array_rand($materialTypes)];                DB::table('course_materials')->insert([            'unit_id' => $unitId,            'title' => ucfirst($type) . " Material {$i}",            'description' => "Learning material covering important concepts and practical applications.",            'type' => $type,            'file_path' => "materials/{$type}_{$materialCount}.mp4",            'duration_minutes' => $type === 'video' ? rand(10, 45) : null,            'sort_order' => $i,            'is_downloadable' => rand(0, 1) ? 'yes' : 'no',            'status' => 'active',            'created_at' => now(),            'updated_at' => now(),        ]);    }}echo "✅ Generated {$materialCount} course materials\n";// Generate other required dataecho "🔔 Generating course notifications...\n";DB::table('course_notifications')->truncate();for ($i = 1; $i <= 50; $i++) {    DB::table('course_notifications')->insert([        'course_id' => rand(1, 50),        'title' => 'Course Update Notification',        'message' => 'New content has been added to your enrolled course.',        'type' => 'course_update',        'status' => 'active',        'created_at' => now()->subDays(rand(0, 30)),        'updated_at' => now(),    ]);}echo "✅ Generated 50 course notifications\n";echo "❓ Generating course quizzes...\n";DB::table('course_quizzes')->truncate();$quizCount = 0;for ($courseId = 1; $courseId <= 50; $courseId++) {    $quizzesPerCourse = rand(2, 5);    for ($i = 1; $i <= $quizzesPerCourse; $i++) {        $quizCount++;        DB::table('course_quizzes')->insert([            'course_id' => $courseId,            'title' => "Assessment Quiz {$i}",            'description' => "Test your understanding of the course material.",            'questions' => json_encode([                ['question' => 'What is the main concept?', 'options' => ['A', 'B', 'C', 'D'], 'correct' => 'A'],                ['question' => 'How do you apply this skill?', 'options' => ['Method 1', 'Method 2', 'Method 3'], 'correct' => 'Method 1']            ]),            'time_limit_minutes' => 30,            'passing_score' => 70,            'max_attempts' => 3,            'status' => 'active',            'created_at' => now(),            'updated_at' => now(),        ]);    }}echo "✅ Generated {$quizCount} course quizzes\n";echo "💳 Generating course subscriptions...\n";DB::table('course_subscriptions')->truncate();for ($i = 1; $i <= 100; $i++) {    DB::table('course_subscriptions')->insert([        'user_id' => rand(1, 10),        'course_id' => rand(1, 50),        'subscription_type' => 'premium',        'start_date' => now()->subDays(rand(0, 60)),        'end_date' => now()->addDays(rand(30, 365)),        'status' => 'active',        'created_at' => now()->subDays(rand(0, 30)),        'updated_at' => now(),    ]);}echo "✅ Generated course subscriptions\n";echo "\n🎉 Uganda-Focused Course Module Dummy Data Generation Complete!\n";echo "📊 Summary:\n";echo "   - 10 Uganda-Focused Course Categories\n";echo "   - 50 Practical Skills Courses (UGX 200,000 - 1,000,000)\n";echo "   - {$unitCount} Course Units\n";echo "   - {$materialCount} Course Materials\n";echo "   - {$quizCount} Course Quizzes\n";echo "   - 50 Course Notifications\n";echo "   - 100 Course Subscriptions\n\n";echo "✅ All courses focused on practical skills relevant to Uganda!\n";echo "💰 Pricing in UGX ranging from 200,000 to 1,000,000 UGX\n";echo "📚 Categories include Agriculture, Carpentry, Tailoring, Construction, etc.\n";echo "🖼️ Course images should be downloaded to storage/app/public/images/\n";

${this.title}

Code Editor : generate_uganda_course_dummy_data.php