|
Server : Apache System : Linux srv.rainic.com 4.18.0-553.47.1.el8_10.x86_64 #1 SMP Wed Apr 2 05:45:37 EDT 2025 x86_64 User : rainic ( 1014) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/akaindir/public_html/crm/modules/Rss/models/ |
Upload File : |
<?php
/*+***********************************************************************************
* The contents of this file are subject to the vtiger CRM Public License Version 1.0
* ("License"); You may not use this file except in compliance with the License
* The Original Code is: vtiger CRM Open Source
* The Initial Developer of the Original Code is vtiger.
* Portions created by vtiger are Copyright (C) vtiger.
* All Rights Reserved.
*************************************************************************************/
require_once('libraries/magpierss/rss_fetch.inc');
require_once('include/simplehtmldom/simple_html_dom.php');
// for rss caching
define('MAGPIE_CACHE_DIR', '/tmp/magpie_cache');
define('MAGPIE_CACHE_ON', 1);
define('MAGPIE_CACHE_AGE', 1800);
class Rss_Record_Model extends Vtiger_Record_Model {
/**
* Function to get the id of the Record
* @return <Number> - Report Id
*/
public function getId() {
return $this->get('rssid');
}
/**
* Function to set the id of the Record
* @param <type> $value - id value
* @return <Object> - current instance
*/
public function setId($value) {
return $this->set('rssid', $value);
}
/**
* Fuction to get the Name of the Record
* @return <String>
*/
function getName() {
return $this->get('rsstitle');
}
/**
* Function to get Rss fetched object
* @return <object> - Rss Object
*/
public function getRssObject() {
return $this->get('rss');
}
/**
* Function to set Rss Object
* @param <object> $rss - rss fetched object
*/
public function setRssObject($rss) {
return $this->set('rss',$rss->items);
}
/**
* Function to set Rss values
* @param <object> $rss - Rss fetched object
*/
public function setRssValues($rss) {
$this->set('rsstitle', $rss->channel["title"]);
$this->set('url', $rss->channel["link"]);
}
/**
* Function to save the record
* @param <string> $url
*/
public function save($url) {
$db = PearDatabase::getInstance();
$title = $this->getName();
$id = $db->getUniqueID("vtiger_rss");
if($title == "") {
$title = $url;
}
$params = array($id, $url, $title);
$sql = "INSERT INTO vtiger_rss (rssid,rssurl,rsstitle) values (?,?,?)";
$result = $db->pquery($sql, $params);
if($result) {
$this->setId($id);
return $id;
} else {
return false;
}
}
/**
* Function to delete a record
*/
public function delete() {
$db = PearDatabase::getInstance();
$recordId = $this->getId();
$sql = 'DELETE FROM vtiger_rss where rssid = ?';
$db->pquery($sql,array($recordId));
}
/**
* Function to make a record default for an rss record
*/
public function makeDefault() {
$db = PearDatabase::getInstance();
$recordId = $this->getId();
$sql = 'UPDATE vtiger_rss set starred = 0';
$db->pquery($sql,array());
$sql = 'UPDATE vtiger_rss set starred = 1 where rssid = ?';
$db->pquery($sql,array($recordId));
}
/**
* Function to get record instance by using id and moduleName
* @param <Integer> $recordId
* @param <String> $qualifiedModuleName
* @return <Rss_Record_Model> RecordModel
*/
static public function getInstanceById($recordId, $qualifiedModuleName) {
$db = PearDatabase::getInstance();
$result = $db->pquery('SELECT * FROM vtiger_rss WHERE rssid = ?', array($recordId));
if ($db->num_rows($result)) {
$rowData = $db->query_result_rowdata($result, 0);
$recordModel = new self();
$recordModel->setData($rowData);
$recordModel->setModule($qualifiedModuleName);
$rss = fetch_rss(decode_html($recordModel->get('rssurl')));
$rss->items = $recordModel->setSenderInfo($rss->items);
$recordModel->setRssValues($rss);
$recordModel->setRssObject($rss);
return $recordModel;
}
return false;
}
/**
* Function to set the sender address to the record
* @param <array> $rssItems
* @return <array> $items
*/
public function setSenderInfo($rssItems) {
$items = array();
foreach($rssItems as $item) {
$item['sender'] = $this->getName();
$items[] = $item;
}
return $items;
}
/**
* Function to get clean record instance by using moduleName
* @param <String> $qualifiedModuleName
* @return <Settings_SMSNotifier_Record_Model>
*/
static public function getCleanInstance($qualifiedModuleName) {
$recordModel = new self();
return $recordModel->setModule($qualifiedModuleName);
}
/**
* Function to validate the rss url
* @param <string> $url
* @return <boolean>
*/
public function validateRssUrl($url) {
$rss = fetch_rss($url);
if($rss) {
$this->setRssValues($rss);
return true;
} else {
return false;
}
}
/**
* Function to get the default rss
*/
public function getDefaultRss() {
$db = PearDatabase::getInstance();
$result = $db->pquery('SELECT rssid FROM vtiger_rss where starred = 1', array());
$recordId = $db->query_result($result,'0','rssid');
if($recordId) {
$this->setId($recordId);
} else {
$result = $db->pquery('SELECT rssid FROM vtiger_rss', array());
$recordId = $db->query_result($result,'0','rssid');
$this->setId($recordId);
}
}
/**
* Function to get html contents from feed
* @param <string> $url
* @return <string> html contents of url
*/
public function getHtmlFromUrl($url) {
$html = file_get_html($url);
return $html->innertext;
}
}