Repository Api

$storageAdapterForActiveRecord = new StorageAdapterForCActiveRecord();
$storageAdapterForActiveRecord->setModel(new MsdsModel())
            ->addFilter(new CompliancePlusMsdsSearchHandler())
            ->setSorter(new CompliancePlusMsdsSorter())
            ->setPaginator(new PaginatorForCDbCriteria());

$repository = new CPRepository();
$collection = $repository->setStorageAdapter($storageAdapterForActiveRecord)
                            ->setEntityAdapter(new CPMsdsAdapter())
                            ->sort(array(
                                'sortBy'    => 6,
                                'order'     => 'ASC'
                            ))
                            ->withPagination(array(
                                'page'      => 2,
                                'pageSize'  => 1
                            ))
                            ->findAll();

var_dump($collection);

$storageAdapterForDbCommand = new StorageAdapterForCDbCommand();
$command = Yii::app()->db->createCommand()->select('*')->from('msds');
$storageAdapterForDbCommand->setCommand($command)
            ->addFilter(new MsdsIdMoreThan50000())
            ->setSorter(new OrderByLastEditedDesc())
            ->setPaginator(new PaginatorForCDbCommand());

$repository = new CPRepository();
$collection = $repository->setStorageAdapter($storageAdapterForDbCommand)
                            ->setEntityAdapter(new CPMsdsAdapter())
                            ->getFilter(0)
                            ->setParams(array(
                                'foo' => 'bar'
                            ))
                            ->withPagination(array(
                                'page'      => 3,
                                'pageSize'  => 1
                            ))
                            ->sort(array(
                                'order' => 'DESC'
                            ))
                            ->findAll();

        var_dump($collection); die;
/*
object(CPEntityCollection)[74]
  public 'entities' =>
    array (size=1)
      0 =>
        object(CPEntity)[73]
          public 'id' => string '22208' (length=5)
          public 'gsmId' => string 'GSM-022208' (length=10)
          public 'manufacturerId' => string '0' (length=1)
          public 'name' => string '' (length=0)
          public 'trackingId' => string '' (length=0)
          public 'statusId' => string '3' (length=1)
          public 'typeId' => string '0' (length=1)
          public 'startingEffectiveDate' => string '1970-01-01' (length=10)
          public 'endingEffectiveDate' => string '0000-00-00' (length=10)
          public 'submittingUserId' => string '138' (length=3)
          public 'submittingClientId' => string '0' (length=1)
          public 'assignedToUserId' => string '82' (length=2)
          public 'lastEditedDate' => string '2014-02-12 06:59:15' (length=19)
          public 'aliases' => string '' (length=0)
          public 'notes' => string '' (length=0)
          public 'submittingDate' => string '2014-02-06' (length=10)
          public 'approvedDate' => string '2014-02-12' (length=10)
          public 'isApproved' => string '1' (length=1)
          public 'shippingName' => string '' (length=0)
          public 'unNa' => string '' (length=0)
          public 'classTransportation' => string '' (length=0)
          public 'packingGroup' => string '' (length=0)
          public 'productId' => string '' (length=0)
          public 'dslList' => string '' (length=0)
          public 'ndslList' => string '' (length=0)
          public 'dslClassificationInfo' => string '' (length=0)
          public 'whmisClass' => string '' (length=0)
          public 'reviewDate' => string '1970-01-01' (length=10)
          public 'webserviceId' => string '' (length=0)
          public 'fromSdsPublisher' => string '0' (length=1)
          public 'spLocationId' => null
array (size=1)
  'foo' => string 'bar' (length=3)
object(CPEntityCollection)[85]
  public 'entities' =>
    array (size=1)
      0 =>
        object(CPEntity)[87]
          public 'id' => string '56896' (length=5)
          public 'gsmId' => string '' (length=0)
          public 'manufacturerId' => string '0' (length=1)
          public 'name' => string '32234' (length=5)
          public 'trackingId' => string '32234' (length=5)
          public 'statusId' => string '1' (length=1)
          public 'typeId' => string '84' (length=2)
          public 'startingEffectiveDate' => string '0000-00-00' (length=10)
          public 'endingEffectiveDate' => string '0000-00-00' (length=10)
          public 'submittingUserId' => string '465' (length=3)
          public 'submittingClientId' => string '47' (length=2)
          public 'assignedToUserId' => string '0' (length=1)
          public 'lastEditedDate' => string '2015-03-29 17:33:57' (length=19)
          public 'aliases' => string '' (length=0)
          public 'notes' => string 'sdfsfsdfsf' (length=10)
          public 'submittingDate' => string '2015-03-29' (length=10)
          public 'approvedDate' => null
          public 'isApproved' => null
          public 'shippingName' => null
          public 'unNa' => null
          public 'classTransportation' => null
          public 'packingGroup' => null
          public 'productId' => null
          public 'dslList' => null
          public 'ndslList' => null
          public 'dslClassificationInfo' => null
          public 'whmisClass' => null
          public 'reviewDate' => string '0000-00-00' (length=10)
          public 'webserviceId' => string '' (length=0)
          public 'fromSdsPublisher' => string '0' (length=1)
          public 'spLocationId' => null
...
*/