Esempio n. 1
0
 public function addNew($msg)
 {
     $message_obj = new XmlLog();
     $message_obj->comment = $msg;
     $message_obj->save();
     return $message_obj->xml_log_id;
 }
Esempio n. 2
0
 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);
 }
Esempio n. 3
0
 /**
  * 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();
     }
 }