agaitan026 Posts - Answer Overflow

Topics

agaitan026

Explore posts from servers

CC#FFilament TTCTheo's Typesafe Cult XXata

•Created by agaitan026 on 11/4/2024 in #❓┊help

custom fields user table

hi, what you guys recommend me for this? i have a php system without any framework i want to migrate to filament currently it have two tables one for admin login, one for client login should i have the same in filament? i mean two diff table for login? the difference is the client table have many custom fields like address, identification, passport, phone, mail, services, mobile and so on that admin table doesn't have. or should i use one table only of users and have a client_detail table for example with a foreign key that links to the user table? thank you

18 replies

•Created by agaitan026 on 11/4/2024 in #❓┊help

how render a table inside a tab?

No description

33 replies

•Created by agaitan026 on 11/3/2024 in #❓┊help

tag component with colors?

No description

11 replies

•Created by agaitan026 on 10/18/2024 in #❓┊help

approval system workflow

i can do with filament the following app with this requirements? Multi-Level Authorization: The system should have distinct roles, allowing different levels of access and permissions. Request Submission: Store managers can request up to 10 personnel for their store, using an editable table and specifying a weekly plan with start and end dates. General Manager Review: Upon receiving the request, the general manager can authorize or reject it, adding comments as needed. Rejection Notifications: If rejected, the manager receives an email detailing the rejection and comments. CEO Approval: Approved requests are forwarded to the CEO, who can also accept or reject them. CEO Rejection Notifications: If the CEO rejects a request, the general manager receives an email with rejection details. Person Bag Management: Upon approval, the request details (including the store origin) are stored in a "people bag" for each store, indicating available personnel. Weekly Planning by Store Manager: Store managers can create a weekly plan (Monday to Sunday) using the approved personnel, specifying the number needed for each day. If they attempt to schedule more personnel than available, an alert will notify them of the excess. Live Validation: The weekly planning table should validate live against the available personnel in the bag, with alerts if quantities exceed the bag limits. Email Notification: The finalized weekly plan will be sent via email after saving. Database Storage: The available personnel bag should be stored in the database, linked to approved requests for real-time validation. Monthly Request Limitation: Store managers can only create requests for the current month, preventing requests for future months like November or December. CEO Dashboard: The CEO can view all requests from all stores for oversight.

2 replies

•Created by agaitan026 on 10/12/2024 in #❓┊help

cluster issue

No description

4 replies

•Created by agaitan026 on 10/9/2024 in #❓┊help

table inside tabs its possible?

No description

35 replies

•Created by agaitan026 on 10/8/2024 in #❓┊help

cant change lang of filamentphp v3

hi i tried to change language to spanish but its not working, i changed locale in app.php, also published all filament translations even clear cache but i still see my app in english. what im missing? config/app.php 'locale' => env('APP_LOCALE', 'es'), 'fallback_locale' => env('APP_FALLBACK_LOCALE', 'es'), } 'faker_locale' => env('APP_FAKER_LOCALE', 'es_ES'),

6 replies

•Created by agaitan026 on 10/8/2024 in #❓┊help

make tab full width?

hi i have a form that have tabs, how i can make it full width all windows? thank you

Tabs::make('Tabs')
    ->tabs([
        Tabs\Tab::make('Tab 1')
            ->schema([
            TextInput::make('name')
                ->required()
                
                ->label(trans('filament-users::user.resource.name')),
            TextInput::make('cedula')
                ->required()
                ->label('cedula'),    
            TextInput::make('idcliente')
                ->required()
                ->label('idcliente'), 
Forms\Components\Select::make('roles')
                ->multiple()
                ->preload()
                ->relationship('roles', 'name')
                ->label(trans('filament-users::user.resource.roles')),
        
            ]),
        Tabs\Tab::make('Tab 2')
            ->schema([
            TextInput::make('direccion_principal')
                ->required()
                ->label('direccion_principal'), 
            TextInput::make('ruc')
                ->required()
                ->label('ruc'),     
            TextInput::make('dv')
                ->required()
                ->label('dv'),      
            TextInput::make('email')
                ->email()
                ->required()
                ->label(trans('filament-users::user.resource.email')),
            ]),
        Tabs\Tab::make('Tab 3')
            ->schema([
                // ...
            ]),
    ])
        ];

Tabs::make('Tabs')
    ->tabs([
        Tabs\Tab::make('Tab 1')
            ->schema([
            TextInput::make('name')
                ->required()
                
                ->label(trans('filament-users::user.resource.name')),
            TextInput::make('cedula')
                ->required()
                ->label('cedula'),    
            TextInput::make('idcliente')
                ->required()
                ->label('idcliente'), 
Forms\Components\Select::make('roles')
                ->multiple()
                ->preload()
                ->relationship('roles', 'name')
                ->label(trans('filament-users::user.resource.roles')),
        
            ]),
        Tabs\Tab::make('Tab 2')
            ->schema([
            TextInput::make('direccion_principal')
                ->required()
                ->label('direccion_principal'), 
            TextInput::make('ruc')
                ->required()
                ->label('ruc'),     
            TextInput::make('dv')
                ->required()
                ->label('dv'),      
            TextInput::make('email')
                ->email()
                ->required()
                ->label(trans('filament-users::user.resource.email')),
            ]),
        Tabs\Tab::make('Tab 3')
            ->schema([
                // ...
            ]),
    ])
        ];

8 replies

•Created by agaitan026 on 9/29/2024 in #❓┊help

any command to generate resources, pages to a specific panel?

hi theres any command to automatically generate everything in a specific panel ? thank you

4 replies

•Created by agaitan026 on 9/28/2024 in #❓┊help

two different panel with roles

Hi any option to do this? 1. i have two panel, admin and client 2. how i can set only specific role to be able to access admin panel 3. the other roles can only see client. 4. admin user of course can see both client and admin panel how i can achieve this? i already got both panels and got shield plugin. thank you

12 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

any plugin to create something like image attached?

No description

4 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

remove borders from section?

No description

4 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

wide tabs in forms

No description

5 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

tag field with color in forms?

No description

7 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

how make this query in filament php?

Hi how i can replicate this query in filament php?

  CAST(u.id AS CHAR) AS id,
  u.estado,
  u.nombre,
  u.cedula,
  GROUP_CONCAT(DISTINCT ts.ip SEPARATOR '\n ') AS ip,
  GROUP_CONCAT(DISTINCT ts.direccion SEPARATOR '\n ') AS direccion_servicio,
  SUM(
    CASE
      WHEN fa.estado = 'No pagado' THEN fa.total
      ELSE 0
    END
  ) AS deuda_total,
  COUNT(
    CASE
      WHEN fa.estado = 'No pagado' THEN 1
    END
  ) AS cantidad_facturas_no_pagadas,
  GROUP_CONCAT(DISTINCT ts.instalado SEPARATOR '\n ') AS instalado
FROM
  usuarios u
  LEFT JOIN tblservicios ts ON u.id = ts.idcliente
  LEFT JOIN facturas fa ON u.id = fa.idcliente
WHERE
  (
    {{ ! filtroNombre.value }}
    OR u.nombre LIKE {{ '%' + filtroNombre.value + '%' }}
  )
  AND (
    {{filtroEstado.value.length === 0}}
    OR u.estado IN ({{ filtroEstado.value }})
  )
  AND (
    {{ ! filtroCedula.value }}
    OR u.cedula = {{ filtroCedula.value }}
  )
GROUP BY
  u.id,
  u.nombre,
  u.cedula,
  u.direccion_principal;

  CAST(u.id AS CHAR) AS id,
  u.estado,
  u.nombre,
  u.cedula,
  GROUP_CONCAT(DISTINCT ts.ip SEPARATOR '\n ') AS ip,
  GROUP_CONCAT(DISTINCT ts.direccion SEPARATOR '\n ') AS direccion_servicio,
  SUM(
    CASE
      WHEN fa.estado = 'No pagado' THEN fa.total
      ELSE 0
    END
  ) AS deuda_total,
  COUNT(
    CASE
      WHEN fa.estado = 'No pagado' THEN 1
    END
  ) AS cantidad_facturas_no_pagadas,
  GROUP_CONCAT(DISTINCT ts.instalado SEPARATOR '\n ') AS instalado
FROM
  usuarios u
  LEFT JOIN tblservicios ts ON u.id = ts.idcliente
  LEFT JOIN facturas fa ON u.id = fa.idcliente
WHERE
  (
    {{ ! filtroNombre.value }}
    OR u.nombre LIKE {{ '%' + filtroNombre.value + '%' }}
  )
  AND (
    {{filtroEstado.value.length === 0}}
    OR u.estado IN ({{ filtroEstado.value }})
  )
  AND (
    {{ ! filtroCedula.value }}
    OR u.cedula = {{ filtroCedula.value }}
  )
GROUP BY
  u.id,
  u.nombre,
  u.cedula,
  u.direccion_principal;

and show it in a table

7 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

how to create a page with a table to list clients

Hi which tutorial i can follow to create a new page on filament named Clients, and when i click it should show a data table (i already got my db in mysql with data) how i can show exactly all records from that mysql table into a data table in filament? thank you

5 replies

•Created by agaitan026 on 9/22/2024 in #❓┊help

user management with roles

Hi im just starting with filament, how i can create a user management system with roles theres any plugin? thank you

13 replies

•Created by agaitan026 on 9/21/2024 in #❓┊help

dashboard widget looks weird

No description

18 replies

•Created by agaitan026 on 7/30/2024 in #help

how to show all results in react app?

im trying const response = await axios.post( 'https://alexis-gaitan-s-workspace-r0aiag.us-east-1.xata.sh/db/dbsnetworkdb:main/tables/usuarios/query', but its showing only max 1000 results, but i have like 10000

7 replies

•Created by agaitan026 on 6/15/2024 in #help

summarize columns linked table

"records": [
    {
      "id": "1",
      "name": "MW305R Router Inalámbrico N de 300Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "1",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:38:55.614973+00:00",
              "version": 1
            }
          },
          {
            "id": "6",
            "qty_available": 5,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:09.60911+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:28:37.242412Z",
        "version": 13
      }
    },
    {
      "id": "2",
      "name": "MS105G Switch de escritorio de 5 puertos 10/100 / 1,000 Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "2",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:04.164232+00:00",
              "version": 1
            }
          },
          {
            "id": "7",
            "qty_available": 0,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T14:18:49.988908+00:00",
              "version": 5
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:29:08.960135Z",
        "version": 11
      }
    }
  ]
}

"records": [
    {
      "id": "1",
      "name": "MW305R Router Inalámbrico N de 300Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "1",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:38:55.614973+00:00",
              "version": 1
            }
          },
          {
            "id": "6",
            "qty_available": 5,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:09.60911+00:00",
              "version": 1
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:28:37.242412Z",
        "version": 13
      }
    },
    {
      "id": "2",
      "name": "MS105G Switch de escritorio de 5 puertos 10/100 / 1,000 Mbps",
      "product_references_in_variation_location_details": {
        "records": [
          {
            "id": "2",
            "qty_available": 11,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T13:39:04.164232+00:00",
              "version": 1
            }
          },
          {
            "id": "7",
            "qty_available": 0,
            "xata": {
              "createdAt": "2024-05-24T16:27:22.855691+00:00",
              "updatedAt": "2024-06-15T14:18:49.988908+00:00",
              "version": 5
            }
          }
        ]
      },
      "xata": {
        "createdAt": "2024-05-24T16:26:48.597836Z",
        "updatedAt": "2024-06-03T16:29:08.960135Z",
        "version": 11
      }
    }
  ]
}

i got the following response i need to sum up qty_available for each product, how i can do it?

5 replies