public function selectForDetail($id)
{
$this->mapping->fields['id'] = 'typeID';
$this->mapping->fields['title'] = 'typeTitle';
$this->mapping->fields['parent'] = 'typeParentID';
$this->mapping->criterias['id'] = new stdclass();
$this->mapping->criterias['id']->field = 'typeID';
$this->mapping->criterias['id']->operator = '=';
$this->mapping->criterias['id']->value = $id;
return parent::selectSingle($id);
}
public function selectForInfo($id)
{
$this->mapping->table .= " AS mainTable";
$this->mapping->fields['infoName'] = 'CONCAT(accountFirstName,"",acountLastName)';
$this->mapping->fields['createdAt'] = 'createdAt';
$this->mapping->fields['updatedBy'] = '(SELECT userLogin FROM users WHERE userID = mainTable.updatedBy)';
$this->mapping->fields['updatedAt'] = 'updatedAt';
$this->mapping->criterias['id'] = new stdclass();
$this->mapping->criterias['id']->field = 'accountID';
$this->mapping->criterias['id']->operator = '=';
$this->mapping->criterias['id']->value = $id;
$row = parent::selectSingle($data);
$this->mapping->table = str_replace(" AS mainTable", "", $this->mapping->table);
return $row;
}
public function selectForDetail($id)
{
$this->mapping->fields['id'] = 'brandID';
$this->mapping->fields['title'] = 'brandTitle';
$this->mapping->fields['album'] = 'albumID';
$this->mapping->criterias['id'] = new stdclass();
$this->mapping->criterias['id']->field = 'brandID';
$this->mapping->criterias['id']->operator = '=';
$this->mapping->criterias['id']->value = $id;
$data = parent::selectSingle($id);
// Recupera fotos a partir do album
if ($this->photoModel && $data) {
$data->photos = $this->photoModel->selectAlbum($data->album);
}
return $data;
}
public function checkLogin($data)
{
$this->mapping->fields['id'] = 'userID';
$this->mapping->fields['name'] = 'userName';
$this->mapping->fields['blocked'] = 'userBlocked';
$this->mapping->criterias['user'] = new stdclass();
$this->mapping->criterias['user']->field = 'userLogin';
$this->mapping->criterias['user']->operator = '=';
$this->mapping->criterias['user']->value = $data->user;
$this->mapping->criterias['password'] = new stdclass();
$this->mapping->criterias['password']->field = 'userPassword';
$this->mapping->criterias['password']->operator = '=';
$this->mapping->criterias['password']->value = md5($data->password);
return parent::selectSingle($data);
}
public function checkLogin($data)
{
$this->mapping->fields['id'] = 'accountID';
$this->mapping->fields['name'] = 'accountFirstName';
$this->mapping->fields['inactive'] = 'accountInactive';
$this->mapping->criterias['user'] = new stdclass();
$this->mapping->criterias['user']->field = 'accountEmail';
$this->mapping->criterias['user']->operator = '=';
$this->mapping->criterias['user']->value = $data->user;
$this->mapping->criterias['password'] = new stdclass();
$this->mapping->criterias['password']->field = 'accountPassword';
$this->mapping->criterias['password']->operator = '=';
$this->mapping->criterias['password']->value = md5($data->password);
return parent::selectSingle($data);
}
