=== Orders Table Structure ===

All Columns:
  id (bigint unsigned)
  mitra_token (varchar(64))
  customer_id (bigint unsigned)
  mitra_id (bigint unsigned)
  odp (varchar(255))
  catatan_order (text)
  tipe_petugas (enum('individu','rombongan'))
  order_number (varchar(255))
  type (enum('psb','umum'))
  sub_category (enum('psb','dismantle','gangguan','relokasi','custom'))
  status (enum('draft','assigned','accepted','in_progress','completed','cancelled'))
  status_kendaraan (tinyint)
  lat_return_kendaraan (decimal(10,7))
  lon_return_kendaraan (decimal(10,7))
  keterangan (varchar(255))
  client_name (varchar(255))
  client_phone (varchar(255))
  client_email (varchar(255))
  client_address (text)
  client_lat (decimal(10,8))
  client_lng (decimal(11,8))
  lat_start (decimal(10,8))
  lon_start (decimal(11,8))
  title (varchar(255))
  description (text)
  priority (enum('low','medium','high','urgent'))
  scheduled_date (datetime)
  notes (text)
  admin_notes (text)
  assigned_teknisi_id (bigint unsigned)
  assigned_rombongan_id (bigint unsigned)
  assigned_kendaraan_id (bigint unsigned)
  assigned_at (datetime)
  response_deadline (datetime)
  created_by (bigint unsigned)
  info_foto1 (varchar(255))
  label_info_foto1 (varchar(255))
  info_foto2 (varchar(255))
  label_info_foto2 (varchar(255))
  info_file1 (varchar(255))
  label_info_file1 (varchar(255))
  info_file2 (varchar(255))
  label_info_file2 (varchar(255))
  accepted_at (datetime)
  started_at (datetime)
  check_in_date (date)
  check_in_time (time)
  foto_check_in (varchar(255))
  lat_check_in (decimal(10,8))
  lon_check_in (decimal(11,8))
  label_foto1 (varchar(255))
  foto1 (varchar(255))
  label_foto2 (varchar(255))
  foto2 (varchar(255))
  label_foto3 (varchar(255))
  foto3 (varchar(255))
  label_foto4 (varchar(255))
  foto4 (varchar(255))
  label_foto5 (varchar(255))
  foto5 (varchar(255))
  label_foto6 (varchar(255))
  foto6 (varchar(255))
  label_foto7 (varchar(255))
  foto7 (varchar(255))
  label_foto8 (varchar(255))
  foto8 (varchar(255))
  label_foto9 (varchar(255))
  foto9 (varchar(255))
  foto_ttd_customer (varchar(255))
  ttd_teknisi (varchar(255))
  ttd_customer (varchar(255))
  check_out_date (date)
  check_out_time (time)
  foto_check_out (varchar(255))
  lat_check_out (decimal(10,8))
  lon_check_out (decimal(11,8))
  completed_at (datetime)
  created_at (timestamp)
  updated_at (timestamp)


Status-related columns:
  status (enum('draft','assigned','accepted','in_progress','completed','cancelled')) - Default: draft
  status_kendaraan (tinyint) - Default: 0


Sample Orders:
  Order #2:
    status: draft
    status_kendaraan: 0

  Order #8:
    status: draft
    status_kendaraan: 0

  Order #9:
    status: completed
    status_kendaraan: 0