# jetformbuilder/3.6.6/modules/gateways/query-views/payment-with-record-view.php

JetFormBuilder — Dynamic Blocks Form Builder, version 3.6.6. 44 lines.

- Page: https://pluginprobe.com/plugins/jetformbuilder/3.6.6/code/modules/gateways/query-views/payment-with-record-view.php
- Raw: https://pluginprobe.com/plugins/jetformbuilder/3.6.6/raw/modules/gateways/query-views/payment-with-record-view.php
- Modified: 2023-11-20T11:46:54+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/jetformbuilder/3.6.6/code/modules/gateways/query-views/payment-with-record-view.php#L10-L20`.

```php
<?php


namespace JFB_Modules\Gateways\Query_Views;

use JFB_Modules\Form_Record\Models\Record_Model;
use Jet_Form_Builder\Db_Queries\Exceptions\Sql_Exception;
use Jet_Form_Builder\Db_Queries\Query_Builder;
use Jet_Form_Builder\Exceptions\Query_Builder_Exception;
use JFB_Modules\Gateways\Db_Models\Payment_Model;
use JFB_Modules\Gateways\Db_Models\Payment_To_Record;

// If this file is called directly, abort.
if ( ! defined( 'WPINC' ) ) {
	die;
}

class Payment_With_Record_View extends Payment_View {

	public function get_prepared_join( Query_Builder $builder ) {
		parent::get_prepared_join( $builder );

		$payments_to_records = ( new Payment_To_Record() )->create()::table();
		$payments            = Payment_Model::table();
		$records             = Record_Model::table();

		$builder->join .= "
LEFT JOIN `{$payments_to_records}` ON 1=1 
	AND `{$payments_to_records}`.`payment_id` = `{$payments}`.`id`
	
LEFT JOIN `{$records}` ON 1=1 
	AND `{$records}`.`id` = `{$payments_to_records}`.`record_id`
		";
	}

	public function select_columns(): array {
		return array_merge(
			parent::select_columns(),
			Record_Model::schema_columns( 'record' )
		);
	}

}

```