public function modifyLog(Log $log, $type)
{
$sql = new Sql($this->dbAdapter);
/* Convert to readable value */
if ($log->key == Config::process_id) {
$log->old_value = $this->getProcessNameBaseOnID($log->old_id);
$log->new_value = $this->getProcessNameBaseOnID($log->new_id);
} else {
if ($log->key == Config::reporter_id || $log->key == Config::assign_id || $log->key == Config::agency_id || $log->key == Config::provider_id) {
$log->old_value = $this->getUserNameByUserID($log->old_id);
$log->new_value = $this->getUserNameByUserID($log->new_id);
} else {
if ($log->key == Config::cost_sell_id || $log->key == Config::cost_buy_id) {
$log->old_id = number_format($log->old_id);
$log->new_id = number_format($log->new_id);
}
}
}
$log->key_name = Config::convertFieldID($log->key);
/* Always insert new value json to db */
$data = array('user_id' => $log->user_id, 'task_id' => $log->task_id, 'action_id' => $log->action_id, 'value' => json_encode(array('key' => $log->key, 'key_name' => $log->key_name, 'old_value' => $log->old_value, 'old_id' => $log->old_id, 'new_value' => $log->new_value, 'new_id' => $log->new_id, 'custumer' => $log->custumer)), 'date' => date("Y-m-d H:i:s"), 'type' => $type);
$sql = new Sql($this->dbAdapter);
$insert = $sql->insert('logs');
$insert->values($data);
$selectString = $sql->getSqlStringForSqlObject($insert);
return $this->dbAdapter->query($selectString, Adapter::QUERY_MODE_EXECUTE);
}
