Tul xxx Tul

Viewing: messages_fetch.php

<?php
include '../components/connect.php';
header('Content-Type: application/json');

$select_messages = $conn->prepare("SELECT *, DATE_FORMAT(created_at, '%d/%m/%Y') as fecha_hora FROM `messages` ORDER BY FIELD(status, 'pendiente', 'entregado'), id DESC");
$select_messages->execute();
$pendientes = [];
$entregados = [];
$otros = [];
if($select_messages->rowCount() > 0){
   while($fetch_messages = $select_messages->fetch(PDO::FETCH_ASSOC)){
      $isPedido = false;
      $pedido = null;
      $msg = $fetch_messages['message'];
      $decoded = json_decode($msg, true);
      if (is_array($decoded) && isset($decoded['pedido']) && $fetch_messages['message_type'] === 'local_order') {
         $isPedido = true;
         $pedido = $decoded;
         if($fetch_messages['status'] === 'pendiente') {
            $pendientes[] = ['data' => $fetch_messages, 'pedido' => $pedido];
         } else {
            $entregados[] = ['data' => $fetch_messages, 'pedido' => $pedido];
         }
      } else {
         $otros[] = $fetch_messages;
      }
   }
}
echo json_encode([
  'pendientes' => $pendientes,
  'entregados' => $entregados,
  'otros' => $otros
]);

User / IP	: 216.73.216.95
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64