Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- protected function _initSelect()
- {
- parent::_initSelect();
- $this->getSelect()->joinLeft(
- ['cp1' => $this->getTable('2checkout_ins')],
- 'cp1.id =main_table.two_checkout_message_id OR cp1.id = NULL',
- ['main_table.increment_id','main_table.from_date','main_table.subscription_period','main_table.to_date','main_table.renew_date','main_table.status_success','main_table.customer_id','main_table.paypal_id','main_table.two_checkout_message_id','final_amount'=>'cp1.invoice_usd_amount']
- )->joinLeft(
- ['cp2' => $this->getTable('paypal_result')],
- 'main_table.paypal_id = cp2.id OR cp2.id = NULL',
- ['final_amount_paypal'=>'cp2.amount']
- );
- return $this;
- }
Add Comment
Please, Sign In to add comment