#!/usr/bin/env php
<?php
include dirname(__FILE__, 5) . '/test/lib/init.php';
include dirname(__FILE__, 2) . '/lib/model.class.php';

/**

title=biModel->buildSQL();
timeout=0
cid=15151

- 测试 简单sql @SELECT `id`, `name` FROM `zt_task`

- 测试 简单别名sql @SELECT `t1`.`id`, `t1`.`name` FROM `zt_task` AS `t1`

- 测试 联表sql @SELECT `t1`.`id`, `t1`.`name`, `t2`.`name` AS `execution` FROM `zt_task` AS `t1` LEFT JOIN `zt_project` AS `t2` ON `t1`.`execution` = `t2`.`id`

- 测试 分组sql @SELECT `t1`.`type`, SUM(`t1`.`consumed`) AS `consumed` FROM `zt_task` AS `t1` GROUP BY `t1`.`type`, YEAR(`t1`.`date`)

- 测试 查询条件sql @SELECT `t1`.`id` FROM `zt_task` AS `t1` WHERE `t1`.`deleted` = '0' AND (`t1`.`status` = 'done' OR (`t1`.`status` = 'closed' AND `t1`.`closedReason` = 'done'))

*/

$bi = new biModelTest();

$simple = array
(
    'selects' => array
    (
        array('id'),
        array('name')
    ),
    'from' => array('zt_task')
);

r($bi->buildSQLTest($simple)) && p('') && e("SELECT `id`, `name` FROM `zt_task`"); // 测试 简单sql

$simple = array
(
    'selects' => array
    (
        array('t1', 'id'),
        array('t1', 'name')
    ),
    'from' => array('zt_task', null, 't1')
);

r($bi->buildSQLTest($simple)) && p('') && e("SELECT `t1`.`id`, `t1`.`name` FROM `zt_task` AS `t1`"); // 测试 简单别名sql

$withJoin = array
(
    'selects' => array
    (
        array('t1', 'id'),
        array('t1', 'name'),
        array('t2', 'name', 'execution')
    ),
    'from' => array('zt_task', null, 't1'),
    'joins' => array
    (
        array
        (
            'zt_project', 't2',
            array(array('t1', 'execution', '=', 't2', 'id'))
        )
    )
);

r($bi->buildSQLTest($withJoin)) && p('') && e("SELECT `t1`.`id`, `t1`.`name`, `t2`.`name` AS `execution` FROM `zt_task` AS `t1` LEFT JOIN `zt_project` AS `t2` ON `t1`.`execution` = `t2`.`id`"); // 测试 联表sql

$withGroup = array
(
    'selects' => array
    (
        array('t1', 'type')
    ),
    'functions' => array
    (
        array('t1', 'consumed', 'consumed', 'sum')
    ),
    'from' => array('zt_task', null, 't1'),
    'groups' => array
    (
        array('t1', 'type'),
        array('t1', 'date', null, 'year')
    )
);

r($bi->buildSQLTest($withGroup)) && p('') && e("SELECT `t1`.`type`, SUM(`t1`.`consumed`) AS `consumed` FROM `zt_task` AS `t1` GROUP BY `t1`.`type`, YEAR(`t1`.`date`)"); // 测试 分组sql

$withWhere = array
(
    'selects' => array
    (
        array('t1', 'id')
    ),
    'from' => array('zt_task', null, 't1'),
    'wheres' => array
    (
        array('t1', 'deleted', '=', null, "'0'"),
        'and',
        array
        (
            array('t1', 'status', '=' , null, "'done'"),
            'or',
            array
            (
                array('t1', 'status', '=', null, "'closed'"),
                'and',
                array('t1', 'closedReason', '=', null, "'done'")
            )
        )
    )
);

r($bi->buildSQLTest($withWhere)) && p('') && e("SELECT `t1`.`id` FROM `zt_task` AS `t1` WHERE `t1`.`deleted` = '0' AND (`t1`.`status` = 'done' OR (`t1`.`status` = 'closed' AND `t1`.`closedReason` = 'done'))"); // 测试 查询条件sql