function get_data($id)
{
$q = "SELECT * FROM ssscrapecontrol.ssscrape_task WHERE id=?str?";
$db = DB::get_instance();
$data = $db->prepare_execute_fetch($q, $id);
if ($data) {
$data['periodicity'] = AnewtDateTime::time($data['periodicity']);
$data['latest_run'] = AnewtDateTime::sql($data['latest_run']);
$this->fill($data);
return true;
}
return false;
}
/**
* Format the date in SQL92 TIME format. Example: 18:30:00. This format can
* be used in SQL queries.
*
* \param $date
* A date-like object (optional).
*
* \return
* A string in hh:mm:ss format.
*
* \see AnewtDateTime::sql
* \see AnewtDateTime::sql_date
*/
static function sql_time($date)
{
if (is_null($date)) {
return null;
}
assert('$date instanceof AnewtDateTimeAtom;');
return AnewtDateTime::time($date);
}
function display_periodicity($value, $row)
{
return AnewtDateTime::time($value);
}
function make_one_cell($field, $value, &$row)
{
$classes = array();
if (method_exists($this, "check_" . $field)) {
if (!call_user_func(array($this, "check_" . $field), $value, $row)) {
$classes['error'] = 1;
}
}
if (isset($this->field_opts[$field]['truncate'])) {
$value = str_truncate($value, $this->field_opts[$field]['truncate']);
}
if (isset($this->field_opts[$field]['datetime']) and $value) {
$value = AnewtDateTime::sql($value);
}
if (isset($this->field_opts[$field]['time']) and $value) {
$value = AnewtDateTime::time($value);
}
if (isset($this->field_opts[$field]['num'])) {
$this->stat[$field]['sum'] += intval($value);
}
if (preg_match('/^[\\d\\+\\-\\.eE]+$/', $value) || isset($this->field_opts[$field]['flushright'])) {
$classes['number'] = 1;
}
$display_value = $value;
if (method_exists($this, "display_" . $field)) {
$display_value = call_user_func(array($this, "display_" . $field), $value, &$row);
}
$expand = array_get_default($this->field_opts[$field], 'expand', "0");
$dynamic = array_get_default($this->field_opts[$field], 'dynamic', FALSE);
if ($dynamic || $expand > 0 && is_string($value) && strlen($value) > 0 && strlen($value) > $expand) {
$display_value = ax_a(array(str_truncate($value, $expand, "...", true), ax_span($display_value, array('class' => 'expanded'))), array('class' => 'expand'));
}
$c =& ax_td($display_value);
foreach ($classes as $class => $val) {
$c->add_class($class);
}
return $c;
}
function get_data($id)
{
$q = "SELECT * FROM ssscrape.ssscrape_feed WHERE id=?str?";
$db = DB::get_instance();
$data = $db->prepare_execute_fetch($q, $id);
if ($data) {
$data['pub_date'] = AnewtDateTime::sql($data['pub_date']);
$data['mod_date'] = AnewtDateTime::sql($data['mod_date']);
$q = "SELECT * FROM ssscrape.ssscrape_feed_metadata WHERE feed_id=?str?";
$metadata = $db->prepare_execute_fetch($q, $id);
if ($metadata) {
foreach ($metadata as $name => $value) {
$data['m_' . $name] = $value;
}
}
$q = "SELECT * FROM ssscrapecontrol.ssscrape_task WHERE LOCATE(?str?, args) AND type in ('fetch', 'peilendfetch')";
$task_data = $db->prepare_execute_fetch($q, "'" . $data['url'] . "'");
if ($task_data) {
$task_data['periodicity'] = AnewtDateTime::time($task_data['periodicity']);
$task_data['latest_run'] = AnewtDateTime::sql($task_data['latest_run']);
foreach ($task_data as $name => $value) {
$data['t_' . $name] = $value;
}
}
$q = "SELECT * FROM ssscrapecontrol.ssscrape_task WHERE LOCATE(?str?, args) AND type='modelupdate'";
$task_data = $db->prepare_execute_fetch($q, "'" . $data['url'] . "'");
if ($task_data) {
if ($task_data['periodicity']) {
$task_data['periodicity'] = AnewtDateTime::time($task_data['periodicity']);
} else {
# In case periodicity cannot be read from the DB
$task_data['periodicity'] = "24:00:00";
}
$task_data['latest_run'] = AnewtDateTime::sql($task_data['latest_run']);
foreach ($task_data as $name => $value) {
$data['ct_' . $name] = $value;
}
}
$this->fill($data);
return true;
}
return false;
}
