need to know which user has changed a record

Question

need to know which user has changed a record

Stefan Frei Jun '14

Created Jun '14	Last Reply None	Replies 0	Views 572	Votes 0

Stefan Frei 1.8k

Jun '14

Hello there in my models there must be a general behavior of tracking changes of sensitive data. Therefore i overwrite the save method of Mvc/Model

        $id = $this->readAttribute('id');
        $newData = $this->toArray();
        if(!is_numeric($id))
            $id = "'".$id."'";
        $oldData = $this->findFirst("id=".$id)->toArray();
        $recordSaved = parent::save($newData, $whitelist);
        $logger = $this->getDi()->getShared('logger');
        $logger->log("hello from save", Logger::INFO);
        if($recordSaved && ($newData != $oldData)) {
            //track changes
            echo "change found";
            $log = new Logs();
            $log->item = $this->readAttribute('id');
            $log->user = "SFE";
            $log->change_time = date("Y-m-d H:i:s");
            $log->changes = "Blaa";
            $log->save();
        }
        return $recordSaved;

now i miss some information in my "custom logs":

which user identity made the change
the host ip of the user who made the change

At the moment i cannot see how i can access any session or request object from within the model.

Thanks for your help.

Stefan

Stefan Frei · Answer 1 · 2014-06-16T15:51:20-07:00

never mind a little di works wonders :)

            $log->item = $this->readAttribute('id');
            $identity = $this->getDi()->getAuth()->getIdentity();
            $log->user = $identity[0];
            $log->change_time = date("Y-m-d H:i:s");
            $log->source_ip = $this->getDi()->getRequest()->getClientAddress();
            $log->changes = "Blaa";