package JM::Database::Schema::Candidate::CV::DesiredJobs::UnionWithCV;
use base qw/DBIx::Class/;

use strict;
use warnings;
use vars qw/$VERSION/;
$VERSION = '0.01';

our %Columns = (    
    %JM::Database::Schema::Candidate::CV::Columns,
    job_title => {},
);

my $Sql = qq~(
    SELECT cv.*, dj1.job_title1 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj1 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj1.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj2.job_title2 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj2 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj2.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj3.job_title3 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj3 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj3.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj4.job_title4 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj4 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj4.cv_id) WHERE cv.completed = 'Y' UNION 
    SELECT cv.*, dj5.job_title5 AS job_title FROM `jm_candidates`.`desired_jobs` AS dj5 LEFT JOIN (`jm_candidates`.`cv`) ON (cv.id = dj5.cv_id) WHERE cv.completed = 'Y'
)~;

__PACKAGE__->load_components(qw/EncodeColumns Core/);
__PACKAGE__->table( 'dummy_desired_jobs_unionwithcv' );
__PACKAGE__->decode_columns( 'latin-1' );
__PACKAGE__->encode_columns( 'utf-8' );
__PACKAGE__->add_columns(%Columns);
__PACKAGE__->result_source_instance->name( \$Sql );
__PACKAGE__->belongs_to( candidate => 'JM::Database::Schema::Candidate', 'candidate_id' );

1;