prefix}btc_customers ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), phone VARCHAR(20), pickup TEXT, drop_loc TEXT, driver_id INT, fare INT DEFAULT 0, status VARCHAR(50), payment VARCHAR(50), created_at DATETIME DEFAULT CURRENT_TIMESTAMP )”); dbDelta(“CREATE TABLE {$wpdb->prefix}btc_drivers ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(100), phone VARCHAR(20), password VARCHAR(100), status VARCHAR(50) )”); } register_activation_hook(__FILE__, ‘btc_create_tables’); // AUTO DRIVER ASSIGN function btc_auto_assign_driver() { global $wpdb; $driver = $wpdb->get_row(“SELECT * FROM {$wpdb->prefix}btc_drivers WHERE status=’active’ LIMIT 1”); return $driver ? $driver->id : 0; } // FRONTEND BOOKING add_shortcode(‘btc_booking_form’, function() { ob_start(); ?> <form method="post"> <h3>🚖 Book Your Ride</h3> <input name="name" placeholder="Name" required><br> <input name="phone" placeholder="Phone" required><br> <input name="pickup" placeholder="Pickup"><br> <input name="drop" placeholder="Drop"><br> <input name="fare" placeholder="Fare"><br> <button name="book">Book Now</button> </form> <?php if (isset($_POST['book'])) { global $wpdb; $driver_id = btc_auto_assign_driver(); $wpdb->insert($wpdb->prefix.'btc_customers', [ 'name'=>sanitize_text_field($_POST['name']), 'phone'=>sanitize_text_field($_POST['phone']), 'pickup'=>sanitize_text_field($_POST['pickup']), 'drop_loc'=>sanitize_text_field($_POST['drop']), 'fare'=>intval($_POST['fare']), 'driver_id'=>$driver_id, 'status'=>'Assigned', 'payment'=>'Unpaid' ]); echo "<p>✅ Booking Confirmed</p>"; } return ob_get_clean();
});
// DRIVER PANEL add_shortcode(‘btc_driver_panel’, function() { ob_start(); ?><form method="post"> <h3>Driver Login</h3> <input name="phone" placeholder="Phone"><br> <input name="password" type="password" placeholder="Password"><br> <button name="login">Login</button> </form> <?php if (isset($_POST['login'])) { global $wpdb; $driver = $wpdb->get_row("SELECT * FROM {$wpdb->prefix}btc_drivers WHERE phone='".$_POST['phone']."'"); if ($driver && $driver->password == $_POST['password']) { echo "<h4>Welcome $driver->name</h4>"; $rides = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}btc_customers WHERE driver_id=$driver->id"); foreach ($rides as $r) { echo "<div style='border:1px solid #000;padding:10px;margin:10px;'> <b>$r->pickup → $r->drop_loc</b><br> Fare: ₹$r->fare<br> Status: $r->status </div>"; } } else { echo "Invalid Login"; } } return ob_get_clean();
});
// ADMIN DASHBOARD add_action(‘admin_menu’, function() { add_menu_page(‘Taxi App’, ‘Taxi App’, ‘manage_options’, ‘btc-final’, ‘btc_dashboard’); });
function btc_dashboard() { global $wpdb;$total = $wpdb->get_var("SELECT COUNT(*) FROM {$wpdb->prefix}btc_customers"); $earning = $wpdb->get_var("SELECT SUM(fare) FROM {$wpdb->prefix}btc_customers WHERE payment='Paid'"); echo "<h2>🚀 Dashboard</h2>"; echo "<p>Total Bookings: $total</p>"; echo "<p>Total Earnings: ₹$earning</p>"; $data = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}btc_customers ORDER BY id DESC"); echo "<table border='1'> <tr><th>Name</th><th>Route</th><th>Fare</th><th>Status</th></tr>"; foreach ($data as $row) { echo "<tr> <td>$row->name</td> <td>$row->pickup → $row->drop_loc</td> <td>₹$row->fare</td> <td>$row->status</td> </tr>"; } echo "</table>";
}
