/** * Returns change log for currently loaded row in displayable HTML format */ public function getChangeLogForDisplay($ps_css_id = null) { $o_log = new ApplicationChangeLog(); return $o_log->getChangeLogForRowForDisplay($this, $ps_css_id); }
/** * */ public function getWatchedItems($pn_user_id, $pn_table_num = null) { require_once __CA_LIB_DIR__ . '/core/ApplicationChangeLog.php'; if (!$pn_user_id) { return null; } $t_changelog = new ApplicationChangeLog(); $o_db = $this->getDb(); $o_dm = $this->getAppDatamodel(); $sql = ""; $va_items = array(); if ($pn_table_num) { $sql = " AND table_num = {$pn_table_num}"; } $q_watched_items = $o_db->query("\n\t\t\tSELECT watch_id, row_id, table_num \n\t\t\tFROM ca_watch_list \n\t\t\tWHERE \n\t\t\t\tuser_id = ? {$sql} \n\t\t\tORDER BY watch_id DESC", $pn_user_id); if ($q_watched_items->numRows() > 0) { while ($q_watched_items->nextRow()) { $t_item_table = $o_dm->getInstanceByTableNum($q_watched_items->get("table_num"), true); if ($t_item_table->hasField('deleted') && $t_item_table->get('deleted') == 1) { continue; } $t_item_table->load($q_watched_items->get("row_id")); $va_items[] = array("watch_id" => $q_watched_items->get("watch_id"), "row_id" => $q_watched_items->get("row_id"), "table_num" => $q_watched_items->get("table_num"), "table_name" => $t_item_table->TableName(), "displayName" => $t_item_table->getLabelForDisplay(), "idno" => $t_item_table->get("idno"), "item_type" => $t_item_table->getProperty('NAME_SINGULAR'), "primary_key" => $t_item_table->getPrimaryKey(), "change_log" => $t_changelog->getChangeLogForRowForDisplay($t_item_table)); } } return $va_items; }