??? ??? ??? ??? ???? Laravel? Eloquent ORM? ?? ?????? ?? MVC(Model-View-Controller) ????? ???? ??? ????. ??? ??? ????? ???? ??? ??? SQL ?? ??, ??? ?? ??? ?? ?? ??, ??? ??? ?? ??, ?? ??? API ?? ?? ??? ?????. ??? ???? ?? MVC? ??? ???? Laravel ?? ?????? DataForge? ??? ??? ?????. DataForge? ???, ??? ? ?? ?? ???? ????? ?? ?? ?? ??? ?????.

DataForge? ???

1. ??? SQL ??? ??

Eloquent? ?????? ?? ??? ?????? ??? ?? ?? ??(?: ?? ??? ?? ? ??)? ?? ???? ??? ??? ??? ????. DataForge? ??? ??? SQL ???? ?? ? ??? ???? ?? ?? ??? ????? ??? ? ?? ??? ?? ??? ?????.

?:

$query = new Query('ProductList');
$query->select('list', 'p.id, p.name, p.price, c.name AS category'); 
$query->select('item', 'p.id, p.name, p.description, p.price, c.name AS category');
$query->select('options', 'p.id, p.name'); 
$query->select('total', 'COUNT(p.id) AS totalCount'); 
$query->filterOptional('p.category_id = {category_id}'); 
$query->filterOptional('p.name LIKE {%keyword%}'); 
$query->order('{sort}', '{order}');

?? ??? ??? ? ????.

• ?? ??: $products = Sql('Product:list', ['select' => 'list'])->fetchRowList();
• ????: $product = Sql('Product:list', ['select' => 'item', 'id' => 123])->fetchRow();
• ? ??: $count = Sql('Product:list', ['select' => 'total'])->fetchColumn();

2. ?? ??? ??

Eloquent ??? ??? ???? ???? ??? ???? ?? ??? ??? ??? ??? ????. DataForge? Entity ???? ??? ??? ???? ???? ?? ??? ???? ???? ??????.

• ?? ??: ???? ?? ??? ???? ???? ??? ???? ??? ??????. $product = DataForge::getProduct(123); echo $product->Price; (??? ???? getPrice() ??).

• ??? ? ??: ???? ??? ??? ?? ??? ?? ??? ?? ??. $product = DataForge::getProduct(123); $category = $product->Category; (?? Category ???? ?? ?????).

?: ?? ??

class Product extends Entity
{
    function init($id)
    {
        return \Sql('Product:list', ['id' => $id, 'select' => 'entity'])->fetchRow();
    }

    function getCategory()
    {
        return DataForge::getCategory($this->category_id);
    }
}

3. ??? API ?????

DataForge? 7?? ??? API ?????? ???? ??? ?? ??? ?? ????? ?? ??? ?? ??? ?????.

• /api/list: ???? ??? ??? ??
• /api/all: ???? ?? ???(??? ?? ??)
• /api/item: ?? ??? ??.
• /api/field: ?? ? ? ??.
• /api/entity: ?? ?? ? ??? ??? ???? ??? ??
• /api/Task: SQL? Entity ??? ??? ??? ????
• /api/GuestTask: ?? ????? ?? ???? ??? ??? ???.

?: ???? ??? ?? ??: /api/list/Product:list?keyword=test&pageNo=1&limit=10&sort=price&order=asc

?? ??(JSON):

$query = new Query('ProductList');
$query->select('list', 'p.id, p.name, p.price, c.name AS category'); 
$query->select('item', 'p.id, p.name, p.description, p.price, c.name AS category');
$query->select('options', 'p.id, p.name'); 
$query->select('total', 'COUNT(p.id) AS totalCount'); 
$query->filterOptional('p.category_id = {category_id}'); 
$query->filterOptional('p.name LIKE {%keyword%}'); 
$query->order('{sort}', '{order}');

? ??? ?? ??? ???? ???? ????? API ??? ??????.

4. SQL ?? ????? ??

?? ???????? ??, ?? ? ?? ??? ???? ???? ? ??? ??? ??? ??? ????. DataForge? SQL ??? ??? ?? ??? ???? ??? ???? ???? ?? ?? ?? ??? ??? ??? ??? ? ????.

DataForge? Laravel ??

DataForge? Laravel ????? ???? ??? ?????.

• ??? ??? SQL ??? ?? ?? ??? ????????.
• ?? ??? ?? ? ?? ??
• ?? ?? ?? ??? ??? ??(??, ?, ?)? ?? ??
• ?? ??? ?????? ???? API ??? ???????.
• filterOptional, filterAnyOneRequired ?? ???? ??? ??? ???????.

?? ?? ? ????

DataForge? ????? ?? ??? ??? ????? ???? ?? ??? ???? ??? ?????.

• ??: data-forge.tech
• ????: LinkedIn ???
• ???: GitHub ???

DataForge? ?? ??? ??? ?????? ?? ???? ??? ?????.

????

• ?? SQL ??, API, ??? ??? ??? ???? ????
• Eloquent? ?? ORM? ????? ?? ???? ?????

??? ??? ????? ?? ?????.

? ??? MVC? ???: DataForge? ??? ?? ???? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!