public function getObjectsList($whereList = array(), $limit = 10, $offset = 0)
{
$this->load->database();
$fields_query = $this->createFieldsListString();
$this->db->select($fields_query["fields_list"]);
if (count($fields_query["join_list"])) {
foreach ($fields_query["join_list"] as $index => $join_field) {
$condition = $join_field['table'] . "." . $join_field['field'] . " = " . $join_field['join_table'] . "." . $join_field['join_field'];
$this->db->join($join_field['join_table'], $condition, $join_field['type']);
}
}
if (count($whereList)) {
foreach ($whereList as $where_field => $where_opt) {
switch ($where_opt['data_type']) {
case SystemHelper::DATATYPE_DATE:
$where_opt['value'] = SystemHelper::convertDateFromBR($where_opt['value']);
if (isset($where_opt['or_where']) && $where_opt['or_where']) {
$this->db->or_where(array($where_field => $where_opt['value']));
} else {
$this->db->where(array($where_field => $where_opt['value']));
}
break;
case SystemHelper::DATATYPE_TEXT:
if (isset($where_opt['or_where']) && $where_opt['or_where']) {
$this->db->or_like($where_field, $where_opt['value']);
} else {
$this->db->like($where_field, $where_opt['value']);
}
break;
}
}
}
if ($this->debugMode) {
AlertMessage::display(array('type' => AlertMessage::INFO, 'icon' => 'fa fa-bug', 'message' => '<b>SQL Debug:</b> <br><br>' . $this->db->get_compiled_select($this->getTable())));
}
// $limit = -1 is infinite
if ($limit > -1) {
if ($offset > 0) {
$result = $this->db->get($this->getTable(), $limit, $offset);
} else {
$result = $this->db->get($this->getTable(), $limit);
}
} else {
$result = $this->db->get($this->getTable());
}
$this->db->close();
return $result->result_array();
}
public function beforeAdd($FORMDATA)
{
include_once "Address.php";
include_once "Contact.php";
include_once "BankAccount.php";
if (isset($FORMDATA['idiomas'])) {
$this->addToAfterData("idiomas", $FORMDATA['idiomas']);
unset($FORMDATA['idiomas']);
}
if (isset($FORMDATA['disponibilidade_horario'])) {
$FORMDATA['disponibilidade_horario'] = implode(",", $FORMDATA['disponibilidade_horario']);
} else {
$FORMDATA['disponibilidade_horario'] = null;
}
if (isset($FORMDATA['disponibilidade_veiculos'])) {
$FORMDATA['disponibilidade_veiculos'] = implode(",", $FORMDATA['disponibilidade_veiculos']);
} else {
$FORMDATA['disponibilidade_veiculos'] = null;
}
if (isset($FORMDATA['dt_nascimento']) && !empty($FORMDATA['dt_nascimento'])) {
$FORMDATA['dt_nascimento'] = SystemHelper::convertDateFromBR($FORMDATA['dt_nascimento']);
$dt1 = date_create($FORMDATA['dt_nascimento']);
$dt2 = date_create(date('Y-m-d'));
$diff = $dt1->diff($dt2);
$FORMDATA['idade'] = $diff->format("%y");
}
$this->address = new Address();
$this->contact = new Contact();
$this->bank_account = new BankAccount();
$FORMDATA = $this->address->storeToProcess($FORMDATA);
$FORMDATA = $this->contact->storeToProcess($FORMDATA);
$FORMDATA = $this->bank_account->storeToProcess($FORMDATA);
return $FORMDATA;
}
public function autoConvertDates($to_convert)
{
foreach ($to_convert as $field_name => $value) {
if (substr($field_name, 0, 3) == "dt_") {
$to_convert[$field_name] = SystemHelper::convertDateFromBR($value);
}
}
return $to_convert;
}
public function beforeAdd($FORMDATA)
{
if (!isset($FORMDATA['administrador'])) {
$FORMDATA['administrador'] = false;
}
if (!empty($FORMDATA['senha'])) {
$FORMDATA['senha'] = md5($FORMDATA['senha']);
unset($FORMDATA['senha_confirmacao']);
} else {
unset($FORMDATA['senha']);
unset($FORMDATA['senha_confirmacao']);
}
if (!empty($FORMDATA['dt_nasc'])) {
$FORMDATA['dt_nasc'] = SystemHelper::convertDateFromBR($FORMDATA['dt_nasc']);
}
return $FORMDATA;
}