• Php 8.2
• Laravel 10
• MySQL 8.0

CRUD [ Create Read Update Delete ]

• list_type->string[pagination,collection] default pagination
• columns->string default all columns. separated from each other by a comma(,)
  • host.com/products?columns=id,name,description,... add more with ,
• relations->string default null
  • multi relations=parent;author;... add more with ;
  • And you can multi relationship with dot notation relations=products.mainImage;author;...
• limit->integer default 30
  • working with colection
• per_page->integer default 30
  • working with pagination
• conditions->string|array default null
  • the conditions are and with each other
  • string condition=column:value;column2:value2
  • array condition[column]=value&column[column2]=value2

    https://host.com/users?conditions[first_name]=Jahongir&conditions[last_name]=Jahongir&conditions[author.middle_name]=Jahongir

    or you can use this on one variable

    https://host.com/users?condition=first_name:Jahongir;last_name:Tursunboyev;author.middle_name=doe

• not_conditions-> array default null
  • conditions and with each other. and the result will be reversed
  • not_conditions reverse conditions
• or_conditions-> array default null
  • the conditions are or with each other
  • or_conditions from request, if any of them are equal it will work
• between->array default null
  • array accessive key=column value=int or date between FROMtoTO,if only FROM is given, it is taken from FROM to the end. if only TO(toTO) is given, it takes from start to TO . if between(FROMtoTO) is given, it takes all the data inside FROMtoTO
  • {{host}}/users?between[price]=100to200&between[created_at]=2022-11-10&between[amount]=to200
• not_between->not_between reverse between
• is_active->boolean[or 0,1] default all
  • or conditions[is_active]=0 [0,1]\
• search->string default null
• searchFilds->string array default null.
  • string

  https://host.com/users?search=John&searchFilds=first_name,last_name,author.first_name

  • array

  https://host.com/users?search=John&searchFields[]=first_name&searchFields[]=last_name&searchFields[]=author.first_name

• orderBy->string default id
• sortBy-> string[asc,desc] default desc
• appends->string default null
  • working with collection
  • multi appends=full_name;appends2;... add more with ;
• pluck->string default null
  • The pluck method retrieves all of the values for a given key:
  • https://host.com/products?list_type=collection

          {
            "products": [
                    {
                        "id": 150,
                        "category_id": 5,
                        "name": "suscipit"
                    },
                    {
                        "id": 149,
                        "category_id": 11,
                        "name": "aspernatur"
                    },
                    {
                        "id": 148,
                        "category_id": 5,
                        "name": "occaecati"
                    }
            ]
          }

  • https://host.com/products?list_type=collection&pluck=name

        {
          "products": [
              "suscipit",
              "aspernatur",
              "occaecati",
              "iure"
          ]
        }

  • working with collection
  • The pluck method also supports retrieving nested values using "dot" notation
  • https://host.com/products?relations=category.author&list_type=collection&pluck=id:category.author.first_name

        {
          "products": [
              "150": "Isaias",
              "149": "Rubye",
              "148": "Rubye",
              "147": "Urban",
              "146": "Caden",
              "145": "Alexandre",
              "144": "Super",
              "143": "Emerald",
              "142": "Jamison"
          ]
        }

    • note : object keys unique
• only_deleted->boolean[0,1] default 0(false)

Sort, OrderBy

host.com/directory?orderBy=column

https://host.com/products?orderBy=name&sortBy=ASC

[
    {
        "id": 3,
        "category_id": 3,
        "name": "Apple"
    },
    {
        "id": 1,
        "name": "Grape"
    },
    {
        "id": 2,
        "name": "Kiwi"
    }
]

Sorting through relation's column only works with belongsTo relation.Does not work multi-depth dot notation.Only works with one dot(one relation)

host.com/directory?orderBy=relation.column

https://host.com/products?orderBy=category.name&sortedBy=desc

Query will have something like this

...
LEFT JOIN categories ON products.category_id = categories.id
...
ORDER BY categories.name
...

Multi orderBy

host.com/directory?orderBy=column;relation.column;relation2.column2...

https://host.com/products?orderBy=name;category.name&sortedBy=desc

Product::leftJoin("categories", "products.category_id", "categories.id")->orderBy('name','desc')->orderBy('categories.name','desc');
...
Model::leftJoin("relationTable", "selfTable.foreignKey", "relationTable.ownerKey")->orderBy('column')->orderBy('relationTable.column')...;

• Accept-Language:ru [ru,uz,en] default ru
• Accept:application/json required

{
    "code": 200,
    "message": "OK",
    "data": {
         //data
    }
}

{
    "code": 422,
    "message": "The given data was invalid.",
    "data": {
        "errors": {
             //Errors
        }
     }
}

• code->int [200,201,204,401,403,404,422,500]
• message->string default ''
  • the language of the message will be changed by the header Accept-Language
• data->array|Collection default []

- Profile RU
- User CRUD --- set role
- Category CRUD
- Role CRUD //todo
- Product CRUD //todo