public function loadProjectKeywords($projectId)
 {
     $sql = 'SELECT * FROM keywords WHERE u_p_c_id = ? AND type = 2';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->set($projectId);
     return $this->getList($sqlQuery);
 }

 public function buscar($nombre)
 {
     $sql = 'SELECT * FROM apuntes u WHERE titulo like ? and b_borrado=0';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setString('%' . $nombre . '%');
     return $this->getList($sqlQuery);
 }

 public function queryByConfiguracionIdMontoAsc($value)
 {
     $sql = 'SELECT * FROM reglas_cupones WHERE configuracion_id = ? order by monto ASC';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($value);
     return $this->getList($sqlQuery);
 }

 public function queryByDistribuidorId($value)
 {
     $sql = 'SELECT * FROM condicion WHERE usuario_id = ? OR usuario_id IS NULL order by condicion_categoria_id';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($value);
     return $this->getList($sqlQuery);
 }

 protected function _supplierCollection($key)
 {
     $sqlQuery = new SqlQuery();
     $sql = "SELECT id, name" . $this->table . "FROM supplier`" . $this->index . "`WHERE" . $key . "\n\n                        LEFT JOIN ( SELECT id_ingredient, id_supplier, MIN(price) FROM has_supplier\n\n                            IF (id=id_supplier){min(price)}";
     $result = $sqlQuery->execute($sql);
     return $result['supplier'];
 }

 /**
  * Get all records from table
  */
 public function getResponses($challengeId)
 {
     $sql = "SELECT response.*, user.first_name, user.last_name, user.username \r\n\t\t\t\t\tFROM challenge_responses as response JOIN user_info as user\r\n\t\t\t\t\t\tWHERE response.challenge_id = ? AND response.user_id = user.id ORDER BY response.creation_time ASC ;";
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($challengeId);
     return $this->getListReponse($sqlQuery);
 }

 public function load($indexList = null, $column = false)
 {
     $sqlQuery = new SqlQuery();
     $column = $column ? $column : $this->index;
     if (isset($indexList)) {
         $indexList = " WHERE " . $column . " IN (" . implode(',', $indexList) . ")" . implode(' AND ', $this->filters);
     } else {
         $indexList = array_reduce($this->filters, function ($prev, $next) {
             return $prev == "" ? " WHERE " . $next : $prev . " AND " . $next;
         }, "");
     }
     if ($this->order) {
         $indexList .= ' ORDER BY `' . $this->orderColumn . '` ' . $this->orderDir;
     }
     if ($this->limit > -1) {
         $indexList .= ' LIMIT ' . $this->limit;
     }
     $sql = "SELECT * FROM " . $this->table . $indexList;
     $result = $sqlQuery->execute($sql);
     if ($result['status']) {
         foreach ($result['data'] as $item) {
             $this->processItem($item);
         }
     }
 }

 public function getUserJobPreferredJobLocations($userId)
 {
     $sql = "SELECT * FROM working_locations as locations JOIN user_locations as user_location \r\n\t\t\t\t\tWHERE locations.id = user_location.location_id \r\n\t\t\t\t\t\tAND user_location.user_id = ?";
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($userId);
     return $this->getList($sqlQuery);
 }

 /**
  * Get all records from table
  */
 public function queryAllConversation($projectId)
 {
     $sql = 'SELECT * FROM project_responses WHERE project_id = ? AND status = 5';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($projectId);
     return $this->getList($sqlQuery);
 }

 public function updateStatus($id)
 {
     $sql = 'UPDATE user_access_aid SET status=1 WHERE id = ?;';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($id);
     return $this->executeUpdate($sqlQuery);
 }

 public function deleteReminder($id)
 {
     $sql = 'UPDATE reminders SET status = 2 WHERE id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($id);
     return $this->executeUpdate($sqlQuery);
 }

 function queryInFechas($inicio, $fin, $hotelId)
 {
     $sql = "SELECT DISTINCT * FROM hotel_fechas\n                WHERE hotel_id = ? AND UNIX_TIMESTAMP(fecha) BETWEEN UNIX_TIMESTAMP('{$inicio}') \n                AND UNIX_TIMESTAMP('{$fin}')";
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($hotelId);
     return $this->getList($sqlQuery);
 }

 public function deleteByFormIdUserId($userId, $formId)
 {
     $sql = 'DELETE FROM teamroom_push_forms.user_forms WHERE user_id = ? AND form_id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($userId);
     $sqlQuery->setNumber($formId);
     return $this->executeUpdate($sqlQuery);
 }

 public function baja($id)
 {
     $sql = 'UPDATE usuarios SET b_borrado = ? WHERE id_usuario = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber("1");
     $sqlQuery->setNumber($id);
     return $this->executeUpdate($sqlQuery);
 }

 public function updateLastLoginTime($userId, $timestamp)
 {
     $sql = 'UPDATE user_info SET  last_login_time = ? WHERE id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->set($timestamp);
     $sqlQuery->set($userId);
     return $this->executeUpdate($sqlQuery);
 }

 /**
  * Delete record from table
  * @param skill primary key
  */
 public function deleteUserSkill($id, $userId)
 {
     $sql = 'DELETE FROM user_skills WHERE id = ? AND user_id = ?';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($id);
     $sqlQuery->setNumber($userId);
     return $this->executeUpdate($sqlQuery);
 }

 public function getUserJobPreference($userId)
 {
     $sql = "SELECT * FROM job_preference WHERE user_id = ?  ORDER BY last_update_on DESC;";
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($userId);
     $jobPreference = $this->getList($sqlQuery);
     return $jobPreference;
 }

    public function getPushForm($userId)
    {
        $sql = 'SELECT form.* FROM  teamroom_push_forms.forms as form JOIN teamroom_push_forms.user_forms as user_push_form 
					WHERE user_push_form.user_id = ? AND form.id = user_push_form.form_id AND user_push_form.status = 0';
        $sqlQuery = new SqlQuery($sql);
        $sqlQuery->setNumber($userId);
        return $this->getRow($sqlQuery);
    }

 /**
  * Update record in table
  *
  * @param UserSocialLinksMySql userSocialLink
  */
 public function updateSocialLink($userId, $linkUrl, $type)
 {
     $sql = 'UPDATE user_social_links SET link_url = ? WHERE user_id = ? AND type = ? ';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->set($linkUrl);
     $sqlQuery->setNumber($userId);
     $sqlQuery->set($type);
     return $this->executeUpdate($sqlQuery);
 }

 public function queryByHotelIdAndFechas($idHotel, $inicio, $fin)
 {
     $sql = 'SELECT * FROM promocion WHERE hotel_id = ?';
     $sql .= ' AND ' . $inicio . ' BETWEEN UNIX_TIMESTAMP(promocion.inicio) AND UNIX_TIMESTAMP(promocion.fin)';
     $sql .= ' AND ' . $fin . ' BETWEEN UNIX_TIMESTAMP(promocion.inicio) AND UNIX_TIMESTAMP(promocion.fin)';
     $sqlQuery = new SqlQuery($sql);
     $sqlQuery->setNumber($idHotel);
     return $this->getList($sqlQuery);
 }