public function getList() { $arrCriteria = array('a.admin LIKE ?' => '%' . $this->_filters['admin'] . '%', 'a.description LIKE ?' => '%' . $this->_filters['description'] . '%'); if ($this->_filters['action'] != '0' && $this->_filters['action'] != '') { $arrCriteria['a.action = ?'] = $this->_filters['action']; } if ($this->_filters['tbl'] != '0' && $this->_filters['tbl'] != '') { $arrCriteria['a.tbl = ?'] = $this->_filters['tbl']; } //$arrCriteria['a.name IN (?)'] = array_keys($this->getDropdownName()); $select = new Select('log'); $select->addField('id_log'); $select->addField('admin'); $select->addField('tbl'); $select->addField('inc_date'); $select->addField('action'); $select->addField('description'); $select->where($arrCriteria); $select->order_by('a.inc_date DESC'); $this->_paginator = new PaginatorAdmin($this->_itens_per_page, $this->_filters['pag']); $this->setPaginationSelect($select); $result = $this->_dao->select($select); foreach ($result as $i => $row) { $result[$i]['action'] = Arrays::$logAcao[$row['action']]; $result[$i]['inc_date'] = DateFormat::filter_date($row['inc_date'], 'd/m/Y H:i:s'); $entity = $this->_entities->getEntity($row['tbl']); $result[$i]['tbl'] = $entity->getSection(); } return $result; }
public function getList() { $itens = $this->_entities->getTrashItens(); if ($this->_filters['section'] != '' && $this->_filters['section'] != '0') { $itens = array($itens[$this->_filters['section']]); } $i = 0; foreach ($itens as $item) { $table_name = $item->getTbl(); $id_field = $item->getId(); $title_field = $item->getTitle(); $section = $item->getSection(); $select1 = new Select($table_name); $select1->addField($id_field, 'id'); $select1->addField($title_field, 'title'); $select1->addField('del_date'); $select1->addSField('section', $section); $select1->addSField('entity_name', $table_name); $select1->where(array('is_del = 1' => null, $title_field . ' LIKE ?' => '%' . $this->_filters['title'] . '%')); if ($i == 0) { $select = $select1; } else { $select->union($select1); } $i++; } $select->order_by('del_date DESC'); $this->_paginator = new PaginatorAdmin($this->_itens_per_page, $this->_filters['pag']); $this->setPaginationSelect($select); $result = $this->_dao->select($select); foreach ($result as $i => $row) { $result[$i]['del_date'] = DateFormat::filter_date($row['del_date'], 'd/m/Y H:i'); } return $result; }
public function getTweets() { $tweets = $this->_model->getTweets(); foreach ($tweets as $i => $row) { $tweets[$i]['date'] = DateFormat::filter_dateTimeExtensive($row['date']); } return $tweets; }
public function insertComplete($input) { if (function_exists('curl_file_create')) { $file = curl_file_create($input['file']); } else { $file = '@' . $input['file']; } $track = array('track[title]' => $input['title'], 'track[asset_data]' => $file, 'track[downloadable]' => true, 'track[streamable]' => true, 'track[description]' => trim(strip_tags($input['description'])), 'track[tag_list]' => $input['tag_list']); if (isset($input['date']) && DateFormat::validate($input['date'])) { $d = DateFormat::filter_date($input['date'], 'd'); $m = DateFormat::filter_date($input['date'], 'm'); $y = DateFormat::filter_date($input['date'], 'Y'); $track['track[release_day]'] = $d; $track['track[release_month]'] = $m; $track['track[release_year]'] = $y; } if (isset($input['cover'])) { if (function_exists('curl_file_create')) { $cover = curl_file_create($input['cover']); } else { $cover = '@' . $input['cover']; } $track['track[artwork_data]'] = $cover; } try { $response_text = $this->_api->post('tracks', $track); } catch (\Soundcloud\Exception\InvalidHttpResponseCodeException $e) { $error = json_decode($e->getHttpBody()); $msg = $error->errors[0]->error_message; throw new \Exception($msg); } $response_json = json_decode($response_text); if (json_last_error()) { throw new Exception('Não foi possível converter pra JSON: ' . $response_text); } $f = new TableFilter($this->_table, array('track_id' => $response_json->id, 'track_permalink' => $response_json->permalink_url)); $f->newId()->filter('id_soundcloud'); $f->string()->filter('track_id'); $f->string()->filter('track_permalink'); $this->_dao->insert($this->_table); return $this->_table->id_soundcloud; }