public function addNew($msg) { $message_obj = new XmlLog(); $message_obj->comment = $msg; $message_obj->save(); return $message_obj->xml_log_id; }
public function prepareList() { $sql_where = array(); //---------------- Start date filter if ($this->date_from) { $sql_where[] = "`t1`.`created` >= '" . date('Y-m-d H:i:s', strtotime($this->date_from . ' ' . $this->time_from)) . "'"; } if ($this->date_to) { $sql_where[] = "`t1`.`created` <= '" . date('Y-m-d H:i:s', strtotime($this->date_to . ' ' . $this->time_to)) . "'"; } //---------------- End date filter $sql_where_str = $sql_where ? 'WHERE ' . implode(' AND ', $sql_where) : ''; $sql = "SELECT COUNT(*)\n FROM `" . XmlLog::model()->tableName() . "` `t1`\n " . $sql_where_str; $total = Yii::app()->db->createCommand($sql)->queryScalar(); $pages = new CPagination($total); $pages->pageSize = 50; $sql = "SELECT t1.*\n FROM `" . XmlLog::model()->tableName() . "` `t1`\n " . $sql_where_str . "\n ORDER BY t1.created DESC\n LIMIT " . $pages->currentPage * $pages->pageSize . ", " . $pages->pageSize; $res = Yii::app()->db->createCommand($sql)->queryAll(); return array('list' => $res, 'pages' => $pages); }
/** * Remove all old sensors data from actual database * @param type $timestamp */ private function removeDataBeforeDate($timestamp) { return; //TODO: because of LONG DB $this->addBackupLog("DELETE all records before " . $timestamp); It::debug("DELETE all records before " . $timestamp, 'backup_database'); // delete from `listener` $sql = "SELECT listener_id FROM `" . Listener::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->queryColumn(); It::debug("DELETE " . count($res) . " from " . Listener::model()->tableName(), 'backup_database'); $this->addBackupLog("DELETE " . count($res) . " from " . Listener::model()->tableName()); if ($res) { $sql = "DELETE FROM `" . Listener::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->query(); } // delete from `listener_log` $sql = "SELECT log_id FROM `" . ListenerLog::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "' "; $res = Yii::app()->db->createCommand($sql)->queryColumn(); It::debug("DELETE " . count($res) . " from " . ListenerLog::model()->tableName(), 'backup_database'); $this->addBackupLog("DELETE " . count($res) . " from " . ListenerLog::model()->tableName()); if ($res) { $sql = "DELETE FROM `" . ListenerLog::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->query(); } // delete from `schedule_processed` $sql = "SELECT `schedule_processed_id` FROM `" . ScheduleReportProcessed::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->queryColumn(); It::debug("DELETE " . count($res) . " from " . ScheduleReportProcessed::model()->tableName(), 'backup_database'); $this->addBackupLog("DELETE " . count($res) . " from " . ScheduleReportProcessed::model()->tableName()); if ($res) { $sql = "DELETE FROM `" . ScheduleReportProcessed::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->query(); } // delete from `xml_log` $sql = "SELECT `xml_log_id` FROM `" . XmlLog::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->queryColumn(); It::debug("DELETE " . count($res) . " from " . XmlLog::model()->tableName(), 'backup_database'); $this->addBackupLog("DELETE " . count($res) . " from " . XmlLog::model()->tableName()); if ($res) { $sql = "DELETE FROM `" . XmlLog::model()->tableName() . "` WHERE `created` <= '" . $timestamp . "'"; $res = Yii::app()->db->createCommand($sql)->query(); } }