protected function getTransactionsList() {
$types = array(Pap_Common_Constants::TYPE_SALE, Pap_Common_Constants::TYPE_ACTION, Pap_Common_Constants::TYPE_LEAD, Pap_Common_Constants::TYPE_RECURRING);
$select = new Gpf_SqlBuilder_SelectBuilder();
$select->select->addAll(Pap_Db_Table_Transactions::getInstance(), 't');
$select->from->add(Pap_Db_Table_Transactions::getName(), 't');
$select->from->addInnerJoin(Pap_Db_Table_CommissionTypeAttributes::getName(), 'cta',
'cta.'.Pap_Db_Table_CommissionTypeAttributes::COMMISSION_TYPE_ID.'=t.'.Pap_Db_Table_Transactions::COMMISSIONTYPEID. '
and (cta.'.Pap_Db_Table_CommissionTypeAttributes::NAME."='".AutoApprovalCommissions_Main::AUTO_APPROVAL_COMMISSIONS_DAYS."'
and ".Pap_Db_Table_CommissionTypeAttributes::VALUE . '<>0)
and (unix_timestamp(t.dateinserted) + (cta.'.Pap_Db_Table_CommissionTypeAttributes::VALUE.' * 86400)) <= unix_timestamp()
');
$select->where->add(Pap_Db_Table_Transactions::R_TYPE, "IN", $types);
$select->where->add(Pap_Db_Table_Transactions::R_STATUS, "=", Pap_Common_Constants::STATUS_PENDING);
$transaction = new Pap_Common_Transaction();
return $transaction->loadCollectionFromRecordset($select->getAllRows());
}
