public function testGetStatement1()
{
$columns1 = array(0 => 'attendent.id', 1 => 'attendent.img', 2 => 'attendent.name', 3 => 'award.name', 4 => 'award.annotation', 5 => 'activity_mng.attend_date');
$this->object->select($columns1, 'attendent');
$this->object->innerJoinOn('activity_mng', 'attendent.id = activity_mng.attendent_id')->innerJoinOn('award', 'award.id = activity_mng.award_id');
$where1 = array("AND" => array("=" => array('activity_id' => 5), ">" => array('award_id' => 0)));
$this->object->where($where1);
$result = $this->object->getStatement();
$compare = "SELECT attendent.id, attendent.img, attendent.name, award.name, award.annotation, activity_mng.attend_date FROM [attendent] INNER JOIN [activity_mng] ON attendent.id = activity_mng.attendent_id INNER JOIN [award] ON award.id = activity_mng.award_id WHERE [activity_id] = '5' AND [award_id] > '0' ";
$this->assertEquals($compare, $result);
}
public function testGetStatement1()
{
$columns1 = array(0 => 'attendent.id', 1 => 'attendent.img', 2 => 'attendent.name', 3 => 'award.name', 4 => 'award.annotation', 5 => 'activity_mng.attend_date');
$joinTables1 = array(0 => 'activity_mng', 1 => 'award');
$condition1 = array("AND" => array(array("=", 'award' => 'id', 'activity_mng' => 'award_id'), array("=", 'attendent' => 'id', 'activity_mng' => 'attendent_id')));
$this->object->select($columns1, 'attendent');
$this->object->innerJoin($joinTables1);
$this->object->joinOn($condition1);
$where1 = array("AND" => array("=" => array('activity_id' => 5), ">" => array('award_id' => 0)));
$this->object->where($where1);
$result = $this->object->getDbComponent()->getStatement();
$compare = "SELECT attendent.id, attendent.img, attendent.name, award.name, award.annotation, activity_mng.attend_date FROM `attendent` INNER JOIN `activity_mng` INNER JOIN `award` ON `award`.`id` = `activity_mng`.`award_id` AND `attendent`.`id` = `activity_mng`.`attendent_id` WHERE `activity_id` = '5' AND `award_id` > '0' ";
$this->assertEquals($compare, $result);
}
