getConnection(); echo "

Adding pin_mode column to device_pins...

"; // Check if column exists $check_query = "SHOW COLUMNS FROM device_pins LIKE 'pin_mode'"; $check_stmt = $db->query($check_query); if ($check_stmt->rowCount() > 0) { echo "

✓ Column 'pin_mode' already exists!

"; } else { // Add pin_mode column $alter_query = "ALTER TABLE device_pins ADD COLUMN pin_mode ENUM('OUTPUT', 'INPUT') DEFAULT 'OUTPUT' AFTER pin_type"; $db->exec($alter_query); echo "

✓ Column 'pin_mode' added successfully!

"; } // Update existing pins based on pin_type $update_query = "UPDATE device_pins SET pin_mode = CASE WHEN pin_type IN ('sensor', 'temperature', 'humidity', 'motion', 'light') THEN 'INPUT' ELSE 'OUTPUT' END"; $db->exec($update_query); echo "

✓ Updated existing pins based on type!

"; echo "

Current pins configuration:

"; $pins_query = "SELECT device_id, pin_name, pin_type, pin_mode, pin_gpio FROM device_pins ORDER BY device_id, pin_gpio"; $pins_stmt = $db->query($pins_query); $pins = $pins_stmt->fetchAll(PDO::FETCH_ASSOC); echo ""; echo ""; foreach ($pins as $pin) { $mode_color = $pin['pin_mode'] === 'OUTPUT' ? '#10b981' : '#3b82f6'; $mode_icon = $pin['pin_mode'] === 'OUTPUT' ? '🔌' : '📊'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
DevicePin NameTypeModeGPIO
{$pin['device_id']}{$pin['pin_name']}{$pin['pin_type']}$mode_icon {$pin['pin_mode']}GPIO{$pin['pin_gpio']}
"; echo "
"; echo "

📝 ملاحظة:

"; echo "

OUTPUT (مخرجات): يمكن التحكم فيها (تشغيل/إيقاف) - مثل: Relay, LED, Motor

"; echo "

INPUT (مدخلات): للقراءة فقط (عرض القيمة) - مثل: Sensor, Temperature, Motion

"; echo "
"; echo "

✅ All done!

"; echo "

← Back to Pin Management

"; } catch (Exception $e) { echo "

❌ Error: " . $e->getMessage() . "

"; } ?>