/**
* @param string $tool
* @param int $ref
* @return array|resource
*/
function api_get_track_item_property_history($tool, $ref)
{
$tbl_stats_item_property = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ITEM_PROPERTY);
$course_id = api_get_real_course_id();
//numeric
$course_code = api_get_course_id();
//alphanumeric
$item_property_id = api_get_item_property_id($course_code, $tool, $ref);
$sql = "SELECT * FROM {$tbl_stats_item_property}\n WHERE item_property_id = {$item_property_id} AND course_id = {$course_id}\n ORDER BY lastedit_date DESC";
$result = Database::query($sql);
$result = Database::store_result($result, 'ASSOC');
return $result;
}
/**
* Insert a row like history inside track_e_item_property table
* first you must set description_type, title, content, progress and
* session_id properties with the object CourseDescription
* @param int description type
* @return int affected rows
*/
public function insert_stats($description_type)
{
$tbl_stats_item_property = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ITEM_PROPERTY);
$description_id = $this->get_id_by_description_type($description_type);
$course_id = api_get_real_course_id();
$course_code = api_get_course_id();
$item_property_id = api_get_item_property_id($course_code, TOOL_COURSE_DESCRIPTION, $description_id);
$params = ['c_id' => api_get_course_int_id(), 'course_id' => $course_id, 'item_property_id' => $item_property_id, 'title' => $this->title, 'content' => $this->content, 'progress' => $this->progress, 'lastedit_date' => api_get_utc_datetime(), 'lastedit_user_id' => api_get_user_id(), 'session_id' => $this->session_id];
Database::insert($tbl_stats_item_property, $params);
return 1;
}
/**
* Insert a row like history inside track_e_item_property table
* first you must set description_type, title, content, progress and session_id properties with the object CourseDescription
* @param int description type
* @return int affected rows
*/
public function insert_stats($description_type)
{
$tbl_stats_item_property = Database::get_main_table(TABLE_STATISTIC_TRACK_E_ITEM_PROPERTY);
$description_id = $this->get_id_by_description_type($description_type);
$course_id = api_get_real_course_id();
$course_code = api_get_course_id();
$item_property_id = api_get_item_property_id($course_code, TOOL_COURSE_DESCRIPTION, $description_id);
$sql = "INSERT IGNORE INTO {$tbl_stats_item_property} SET\n\t\t\t\tc_id\t\t\t\t= " . api_get_course_int_id() . ",\n\t\t\t\tcourse_id \t\t\t= '{$course_id}',\n\t\t\t \titem_property_id \t= '{$item_property_id}',\n\t\t\t \ttitle \t\t\t\t= '" . Database::escape_string($this->title) . "',\n\t\t\t \tcontent \t\t\t= '" . Database::escape_string($this->content) . "',\n\t\t\t \tprogress \t\t\t= '" . intval($this->progress) . "',\n\t\t\t \tlastedit_date \t\t= '" . date('Y-m-d H:i:s') . "',\n\t\t\t \tlastedit_user_id \t= '" . api_get_user_id() . "',\n\t\t\t \tsession_id\t\t\t= '" . intval($this->session_id) . "'";
$result = Database::query($sql);
$affected_rows = Database::affected_rows($result);
return $affected_rows;
}