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); }