aDriv4 website!

Linux host.brandservicecorps.com 3.10.0-1160.59.1.el7.x86_64 #1 SMP Wed Feb 23 16:47:03 UTC 2022 x86_64
Apache
66.29.156.133

debug-output.html

<h1>Provider Assignment Investigation</h1><style>
    body { font-family: monospace; padding: 20px; background: #f5f5f5; }
    .section { background: white; padding: 15px; margin: 10px 0; border-radius: 5px; }
    .success { color: green; }
    .error { color: red; }
    .warning { color: orange; }
    .info { color: blue; }
    table { border-collapse: collapse; width: 100%; margin: 10px 0; }
    th, td { border: 1px solid #ddd; padding: 8px; text-align: left; }
    th { background: #4CAF50; color: white; }
    pre { background: #f4f4f4; padding: 10px; overflow-x: auto; }
</style><div class='section'><h2>Step 1: All Providers in System</h2><p class='success'>✓ Found 8 provider(s)</p><table><tr><th>ID</th><th>Name</th><th>Email</th><th>Status</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>visible</td></tr><tr ><td><strong>9</strong></td><td>Test Walker</td><td>walker@pawlinas.com</td><td>visible</td></tr><tr style="background: #ffffcc;"><td><strong>12</strong></td><td>Mobile Walker</td><td>mobilewalker8656@example.com</td><td>visible</td></tr><tr ><td><strong>13</strong></td><td>Simple Walker</td><td>simplewalker4@example.com</td><td>visible</td></tr><tr ><td><strong>14</strong></td><td>Test Walker2</td><td>newwalker6795@example.com</td><td>visible</td></tr><tr ><td><strong>15</strong></td><td>Test Walker2</td><td>newwalker1588@example.com</td><td>visible</td></tr><tr ><td><strong>16</strong></td><td>Test Walker2</td><td>testwalker2@example.com</td><td>visible</td></tr><tr ><td><strong>17</strong></td><td>Test Walker</td><td>testwalker@example.com</td><td>visible</td></tr></table></div><div class='section'><h2>Step 2: Services and Their Assigned Providers</h2><p class='success'>✓ Found 7 service(s)</p><h3>Service: Initial 15-minute Dog Visit (ID: 1)</h3><p>Price: $15 | Duration: 900s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table><h3>Service: Standard 30-minute visit (ID: 2)</h3><p>Price: $25 | Duration: 1800s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table><h3>Service: Extended 55-minute visit (ID: 3)</h3><p>Price: $40 | Duration: 3300s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table><h3>Service: Standard 30-minute visit, up to 3 cats (ID: 4)</h3><p>Price: $25 | Duration: 3600s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table><h3>Service: 8 Visits (Save $16) (ID: 5)</h3><p>Price: $0 | Duration: 3600s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table><h3>Service: 12 Visits (Save $36) (ID: 6)</h3><p>Price: $0 | Duration: 3600s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table><h3>Service: 16 visits (Save $64) (ID: 7)</h3><p>Price: $0 | Duration: 3600s | Status: visible</p><p class='info'>Assigned Providers:</p><table><tr><th>Provider ID</th><th>Name</th><th>Email</th></tr><tr ><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td></tr></table></div><div class='section'><h2>Step 3: Customer's Booking History with Provider Details</h2><p class='success'>✓ Customer ID: 11</p><p class='success'>✓ Found 6 booking(s)</p><table><tr>
            <th>Appt ID</th>
            <th>Service</th>
            <th>Provider ID</th>
            <th>Provider Name</th>
            <th>Provider Email</th>
            <th>Date</th>
            <th>Status</th>
            <th>Price</th>
        </tr><tr style='background: #FFB6C1;'><td>31</td><td>Initial 15-minute Dog Visit</td><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>2026-03-31 09:00:00</td><td>approved</td><td>$15</td></tr><tr style='background: #FFB6C1;'><td>30</td><td>Initial 15-minute Dog Visit</td><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>2026-03-11 11:00:00</td><td>approved</td><td>$15</td></tr><tr style='background: #FFB6C1;'><td>28</td><td>Initial 15-minute Dog Visit</td><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>2026-03-11 10:00:00</td><td>approved</td><td>$45</td></tr><tr style='background: #FFB6C1;'><td>29</td><td>Initial 15-minute Dog Visit</td><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>2026-03-11 09:30:00</td><td>approved</td><td>$45</td></tr><tr style='background: #FFB6C1;'><td>27</td><td>Initial 15-minute Dog Visit</td><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>2026-03-11 09:00:00</td><td>approved</td><td>$45</td></tr><tr style='background: #FFB6C1;'><td>25</td><td>Initial 15-minute Dog Visit</td><td><strong>1</strong></td><td>Polina Oglesby</td><td>polina@pawlinaspetservices.com</td><td>2026-03-10 16:00:00</td><td>approved</td><td>$25</td></tr></table><p class='info'>Green = Correct Walker (ID 12) | Pink = Wrong Provider</p></div><div class='section'><h2>Step 4: Check How Bookings Were Created</h2><h3>Most Recent Appointment Details:</h3><pre>stdClass Object
(
    [id] => 33
    [status] => pending
    [bookingStart] => 2026-03-10 09:00:00
    [bookingEnd] => 2026-03-10 09:15:00
    [notifyParticipants] => 1
    [createPaymentLinks] => 1
    [serviceId] => 1
    [packageId] => 
    [providerId] => 3
    [locationId] => 
    [internalNotes] => Test appointment for walker
    [googleCalendarEventId] => 
    [googleMeetUrl] => 
    [outlookCalendarEventId] => 
    [microsoftTeamsUrl] => 
    [appleCalendarEventId] => 
    [zoomMeeting] => 
    [lessonSpace] => 
    [parentId] => 
    [error] => 
)
</pre><h3>Recent Customer Bookings:</h3><pre>Array
(
    [0] => stdClass Object
        (
            [id] => 24
            [appointmentId] => 33
            [customerId] => 4
            [status] => pending
            [price] => 15
            [tax] => 
            [persons] => 1
            [couponId] => 
            [token] => 69a131d8f6
            [customFields] => 
            [info] => 
            [utcOffset] => 
            [aggregatedPrice] => 1
            [packageCustomerServiceId] => 
            [duration] => 
            [created] => 2026-03-08 21:43:45
            [actionsCompleted] => 
            [qrCodes] => 
        )

[1] => stdClass Object
        (
            [id] => 22
            [appointmentId] => 31
            [customerId] => 11
            [status] => approved
            [price] => 15
            [tax] => 
            [persons] => 1
            [couponId] => 
            [token] => 6c665e1aea
            [customFields] => 
            [info] => 
            [utcOffset] => 
            [aggregatedPrice] => 1
            [packageCustomerServiceId] => 
            [duration] => 
            [created] => 2026-03-08 20:34:39
            [actionsCompleted] => 
            [qrCodes] => 
        )

[2] => stdClass Object
        (
            [id] => 21
            [appointmentId] => 30
            [customerId] => 11
            [status] => approved
            [price] => 15
            [tax] => 
            [persons] => 1
            [couponId] => 
            [token] => 09d4d11550
            [customFields] => 
            [info] => 
            [utcOffset] => 
            [aggregatedPrice] => 1
            [packageCustomerServiceId] => 
            [duration] => 
            [created] => 2026-03-08 20:32:11
            [actionsCompleted] => 
            [qrCodes] => 
        )

[3] => stdClass Object
        (
            [id] => 20
            [appointmentId] => 29
            [customerId] => 11
            [status] => approved
            [price] => 45
            [tax] => 
            [persons] => 1
            [couponId] => 
            [token] => f347c71653
            [customFields] => 
            [info] => 
            [utcOffset] => 
            [aggregatedPrice] => 1
            [packageCustomerServiceId] => 
            [duration] => 
            [created] => 2026-03-08 20:18:54
            [actionsCompleted] => 
            [qrCodes] => 
        )

[4] => stdClass Object
        (
            [id] => 19
            [appointmentId] => 28
            [customerId] => 11
            [status] => approved
            [price] => 45
            [tax] => 
            [persons] => 1
            [couponId] => 
            [token] => 48448ad3b0
            [customFields] => 
            [info] => 
            [utcOffset] => 
            [aggregatedPrice] => 1
            [packageCustomerServiceId] => 
            [duration] => 
            [created] => 2026-03-08 20:15:21
            [actionsCompleted] => 
            [qrCodes] => 
        )

)
</pre></div><div class='section'><h2>Step 5: Test Creating Appointment with Correct Provider</h2><p class='info'>To fix this issue, we need to either:</p><ol><li><strong>Reassign existing appointments</strong> from Provider ID 1 to Provider ID 12</li><li><strong>Fix the booking flow</strong> to select the correct provider when creating appointments</li></ol><h3>Option 1: Reassign Existing Appointments</h3><p>Run this SQL to reassign all customer's appointments to the walker:</p><pre style='background: #ffe; padding: 10px; border: 1px solid #cc0;'>UPDATE wp_amelia_appointments 
SET providerId = 12 
WHERE id IN (
    SELECT appointmentId 
    FROM wp_amelia_customer_bookings 
    WHERE customerId = 11
);</pre><form method='post' style='margin: 10px 0;'><input type='hidden' name='action' value='reassign_appointments'><input type='hidden' name='customer_id' value='11'><input type='hidden' name='new_provider_id' value='12'><button type='submit' style='padding: 10px 20px; background: #4CAF50; color: white; border: none; border-radius: 5px; cursor: pointer;'>Execute Reassignment</button></form></div><div class='section'><h2>Step 6: Check Mobile App Booking Flow</h2><p class='info'>Need to investigate:</p><ul><li>How does the mobile app select a provider when booking?</li><li>Is it using the first available provider?</li><li>Is it respecting provider selection from the booking flow?</li></ul><p class='success'>✓ Booking API file found</p><h3>Provider Selection Logic Found:</h3><pre>providerId,
                a.bookingStart,
                a.bookingEnd,
                a.status,
                a.internalNotes,
                wd.walk_status,
                wd.start_time,
                wd.end_time,
                wd.pickup_location,
                wd.dropoff_location,
                wd.distance_covered,
                wd.booking_source,
                cb.id as customer_booking_id,
                cb.status as booking_status,
                cb.price as booking_price,
                u.display_name as provider_name,
                u.user_email as provider_email,
                s.name as service_name,
                s.price as service_price,
                s.duration as service_duration
             FROM {$wpdb-&gt;prefix}amelia_customer_bookings cb
             LEFT JOIN {$wpdb-&gt;prefix}amelia_appointments a ON cb.appointmentId = a.id
             LEFT JOIN {$wpdb-&gt;prefix}amelia_mobile_walk_details wd ON a.id = wd.appointment_id
             LEFT JOIN {$wpdb-&gt;prefix}amelia_users apu ON a.providerId = apu.id AND apu.type = &#039;provider&#039;
             LEFT JOIN {$wpdb-&gt;users} u ON apu.externalId = u.ID
             LEFT JOIN {$wpdb-&gt;prefix}amelia_services s ON a.serviceId = s.id
             WHERE $where_clause
             ORDER BY a.bookingStart DESC
             LIMIT %d OFFSET %d&quot;,
            array_merge($params, [$per_page, $offset])
        ));</pre></div>

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	digitalservicesc/nobody	0750	2026-04-27 04:54:15
..	dir	-	digitalservicesc/digitalservicesc	0711	2026-04-29 11:21:24
.well-known	dir	-	digitalservicesc/digitalservicesc	0755	2025-11-30 12:12:12
cgi-bin	dir	-	digitalservicesc/digitalservicesc	0755	2026-04-22 05:54:08
db-init	dir	-	digitalservicesc/digitalservicesc	0755	2026-04-22 05:54:08
pawlina	dir	-	digitalservicesc/digitalservicesc	0755	2026-04-22 05:54:08
wp-admin	dir	-	digitalservicesc/digitalservicesc	0755	2026-04-27 02:39:29
wp-content	dir	-	digitalservicesc/digitalservicesc	0755	2026-04-27 04:54:15
wp-includes	dir	-	digitalservicesc/digitalservicesc	0755	2026-04-22 05:54:08
.dockerignore	file	655 B	digitalservicesc/digitalservicesc	0644	2026-03-01 02:59:18
.ftpquota	file	16 B	digitalservicesc/digitalservicesc	0600	2026-04-26 05:27:44
.gitignore	file	1.89 KB	digitalservicesc/digitalservicesc	0644	2026-03-04 06:06:38
.htaccess	file	1.99 KB	digitalservicesc/digitalservicesc	0444	2026-04-27 02:39:29
debug-output.html	file	12.28 KB	digitalservicesc/digitalservicesc	0644	2026-03-09 03:23:32
debug-provider-assignment.php	file	10.28 KB	digitalservicesc/digitalservicesc	0644	2026-03-09 03:23:20
debug-walker-activity.php	file	11.66 KB	digitalservicesc/digitalservicesc	0644	2026-03-09 03:21:34
docker-compose.yml	file	1.29 KB	digitalservicesc/digitalservicesc	0644	2026-03-01 07:54:34
fix-reassign-appointments.php	file	2.34 KB	digitalservicesc/digitalservicesc	0644	2026-03-09 03:24:06
index.php	file	405 B	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
inputs.php	file	127 B	digitalservicesc/digitalservicesc	0644	2026-04-24 06:18:07
license.txt	file	19.44 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
pawlina.zip	file	169.12 MB	digitalservicesc/digitalservicesc	0644	2026-03-19 12:41:49
pawlina2.sql	file	32.78 MB	digitalservicesc/digitalservicesc	0644	2026-03-01 07:03:36
readme.html	file	7.25 KB	digitalservicesc/digitalservicesc	0644	2026-03-19 05:30:13
start-docker.bat	file	1.1 KB	digitalservicesc/digitalservicesc	0644	2026-03-01 02:59:40
start-docker.sh	file	1.09 KB	digitalservicesc/digitalservicesc	0644	2026-03-01 02:59:34
test-walker-activity-api.php	file	1.25 KB	digitalservicesc/digitalservicesc	0644	2026-03-09 03:25:44
txets.php	file	5.69 KB	digitalservicesc/digitalservicesc	0444	2026-04-27 02:39:29
verify-walker-appointments.php	file	1.62 KB	digitalservicesc/digitalservicesc	0644	2026-03-09 03:26:08
wp-activate.php	file	7.18 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-blog-header.php	file	3.08 KB	digitalservicesc/digitalservicesc	0644	2026-04-22 05:54:08
wp-comments-post.php	file	2.27 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-config-sample.php	file	3.26 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-config.php	file	3.97 KB	digitalservicesc/digitalservicesc	0644	2026-03-19 01:07:47
wp-cron.php	file	8.23 KB	digitalservicesc/digitalservicesc	0644	2026-04-22 05:54:08
wp-links-opml.php	file	2.43 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-load.php	file	3.84 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-login.php	file	50.23 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-mail.php	file	8.52 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-settings.php	file	30.33 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-signup.php	file	33.71 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
wp-trackback.php	file	5.09 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00
xmlrpc.php	file	3.13 KB	digitalservicesc/digitalservicesc	0644	2026-02-28 04:21:00

For more Private tool come to me!

https://t.me/aDriv4vz