locomotivemtl / charcoal-object

     * @param RevisionableInterface $obj The object  to load the last revision of.

     * @return ObjectRevision The last revision for the give object.

     */

    public function lastObjectRevision(RevisionableInterface $obj)

    {

        if ($this->source()->tableExists() === false) {

            $this->source()->createTable();

        }

        $rev = $this->modelFactory()->create(self::class);

        $sql = sprintf(

            'SELECT * FROM `%s` WHERE `target_type` = :target_type AND `target_id` = :target_id ORDER BY `rev_ts` DESC LIMIT 1',

            $this->source()->table()

        );

        $rev->loadFromQuery($sql, [

            'target_type' => $obj->objType(),

            'target_id'   => $obj->id(),

        ]);

        return $rev;

    }

    /**

     * Retrieve a specific object revision, by revision number.

     *

     * @param RevisionableInterface $obj    Target object.

     * @param integer               $revNum The revision number to load.

     * @return ObjectRevision

     */

    public function objectRevisionNum(RevisionableInterface $obj, $revNum)

    {

        if ($this->source()->tableExists() === false) {

     * @param integer               $revNum The revision number to load.

     * @return ObjectRevision

     */

    public function objectRevisionNum(RevisionableInterface $obj, $revNum)

    {

        if ($this->source()->tableExists() === false) {

            $this->source()->createTable();

        }

        $rev = $this->modelFactory()->create(self::class);

        $sql = sprintf(

            'SELECT * FROM `%s` WHERE `target_type` = :target_type AND `target_id` = :target_id AND `rev_num` = :rev_num LIMIT 1',

            $this->source()->table()

        );

        $rev->loadFromQuery($sql, [

            'target_type' => $obj->objType(),

            'target_id'   => $obj->id(),

            'rev_num'     => intval($revNum),

        ]);

        return $rev;

    }

}