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); }