File: /var/www/cache/mjmotors/42d495b14181a279a19fb4afc61aeac92b9e87d7.php
Line: 3255
Undefined constant "PRICE_CHANGE_NOTIFICATION_LINK"
File: /var/www/cache/mjmotors/42d495b14181a279a19fb4afc61aeac92b9e87d7.php
Line: 3255
#0 /var/www/vendor/illuminate/view/Engines/PhpEngine.php(60): Illuminate\View\Engines\CompilerEngine->handleViewException(Object(Error), 1)
#1 /var/www/vendor/illuminate/view/Engines/CompilerEngine.php(61): Illuminate\View\Engines\PhpEngine->evaluatePath('cache/mjmotors/...', Array)
#2 /var/www/vendor/illuminate/view/View.php(139): Illuminate\View\Engines\CompilerEngine->get('/var/www/templa...', Array)
#3 /var/www/vendor/illuminate/view/View.php(122): Illuminate\View\View->getContents()
#4 /var/www/vendor/illuminate/view/View.php(91): Illuminate\View\View->renderContents()
#5 /var/www/handle-request.php(302): Illuminate\View\View->render()
#6 /var/www/handle-request.php(424): {closure:/var/www/handle-request.php:148}()
#7 {main}
select
d.display_name,
d.id,
d.use_display_name_for_consent,
d.group_id,
g.name as group_name,
d.facebook_id,
d.facebook_url,
d.youtube_id,
d.youtube_link,
d.twitter_link,
d.instagram_link,
d.linkedin_link,
d.tiktok_url,
d.is_simi,
d.use_km,
d.email_enquiries,
d.opening_hours_extra_text,
d.reservation_days,
d.reservation_option,
d.finance_default_deposit_pct,
d.use_google_reviews,
d.google_reviews_link,
d.google_reviews_avg_rating,
d.google_reviews_total,
d.finance_start_with_personal_details,
d.principal,
d.principal_title,
d.slug,
d.allow_html_description,
d.finance_default_hp_rate,
d.finance_default_pcp_rate,
d.payment_provider,
d.payment_secret_key_enc,
d.square_access_token_enc,
d.square_location_id,
da.address1,
da.address2,
da.address3,
da.address4,
da.address5,
da.postcode,
da.map_lat,
da.map_long,
da.map_zoom,
r.country_code,
r.region,
if (d.reservation_new_option = 0, null, rp.cost_to_reserve) as cost_to_reserve_new
from c_dealers d
left join c_groups g on g.id = d.group_id
left join c_dealer_addresses da on da.dealer_id = d.id
left join c_country_regions r on da.region_id = r.id
left join c_reservation_prices rp on d.reservation_new_price_id = rp.id
where d.id = 544
select
name,
phone,
email,
is_primary_contact
from c_dealer_website_contacts
where dealer_id = 544
and hide_on_website = 0
order by sort_key
select
h.dow,
h.open,
h.closed,
h.optional_text
from c_dealer_hours h
where h.dealer_id = 544
order by 1
select
a.id,
a.s3_image,
a.main_image_id,
ai.template_id,
a.reg_year,
a.price,
a.mileage,
mk.make,
md.model
from c_ads a
inner join c_makes mk on a.make_id = mk.id
inner join c_models md on a.model_id = md.id
left join c_ad_images ai on a.main_image_id = ai.id
where dealer_id = 544
and a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and is_dealer_special = 1
select
a.id,
a.s3_image,
a.is_commercial,
a.external_ad_id,
a.mileage,
a.kilometres,
a.odo_units,
a.make_id,
a.model_id,
a.make_text,
a.model_text,
a.reg_year,
a.price,
a.previous_price,
a.trade_in_price,
/* a.vrt, */
/* round(a.vrt_estimate) as vrt_estimate, */
/* round(a.omsp_for_vrt) as omsp_for_vrt, */
a.description,
a.dealer_id,
a.created_at,
date_format(a.created_at, '%Y%m%d%H%i%s') as creation_date_fmt,
date_format(a.expires_at, '%Y%m%d%H%i%s') as expiry_date_fmt,
/* using dealer updated date not ad updated date */
d.stock_updated_at as updated_at,
a.main_image_id,
ai.template_id as main_template_id,
/* ifnull(a.email_enquiries_p,0) as email_enquiries_p, */
d.email,
a.engine_cc,
a.hide_extra_info_on_dealer_website,
/* a.review_id, */
r.region,
mk.make,
mk.category_id,
md.model,
/* a.commercial_p, */
d.display_name,
d.phone,
/* d.email_enquiries_p as dealer_enquiries_p, */
d.group_id,
/* d.show_web_link_p, */
d.web,
/* d.disable_map_p, */
/* d.simi_p, */
d.opening_hours_extra_text,
da.address1,
da.address2,
da.address3,
da.address4,
da.address5,
da.postcode,
da.map_lat,
da.map_long,
/* d.youtube_id AS dealer_youtube_id, */
d.reservation_option as dealer_reservation_option,
rpd.cost_to_reserve as dealer_cost_to_reserve,
a.reservation_option as ad_reservation_option,
rpa.cost_to_reserve as ad_cost_to_reserve,
a.fuel_type_id,
fu.fuel_type,
a.colour_id,
cl.colour,
a.colour_description,
a.body_type_id,
bd.body_type,
a.variant,
a.owners,
a.transmission_type_id,
tr.transmission_type,
a.reg_number,
/* ifnull(a.contact_name_public_p,0) as contact_name_public_p, */
/* a.contact_name, */
if(a.tax_due_date > now(), a.tax_due_date, null) as tax_due_date,
if(a.test_due_date > now(), a.test_due_date, null) as test_due_date,
a.co2,
a.max_power_bhp,
a.road_tax_cost,
a.fuel_cons_combined,
a.doors,
a.seats,
a.stock_number,
d.location_name,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.accel_0_to_62,
/* a.email_public_p, */
/* a.phone_no_public_p, */
d.phone,
a.youtube_id,
a.video_type,
a.video_id,
a.finance_flat_rate_apr,
a.finance_max_term,
a.finance_max_deposit,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
aei.max_power_hp,
aei.max_power_revs,
aei.max_torque_nm,
aei.max_torque_revs,
aei.fuel_cons_urban,
aei.fuel_cons_extra_urban,
aei.max_speed_mph,
aei.ncap_overall,
aei.ncap_adult_occupant,
aei.ncap_child_occupant,
aei.ncap_adult_pct,
aei.ncap_child_pct,
aei.gross_weight_kg,
aei.unladen_weight_kg,
aei.wheelbase_mm,
fbr.balance_remaining_over,
fbr.balance_remaining_under,
fbr.over_apr,
fbr.under_apr,
a.is_dealer_special,
a.interior_360_url,
a.exterior_360_url,
w.period_months,
a.key_location,
a.grade,
a.eta
/* ad extra info in here if needed */
from
c_ads a
inner join c_models md on a.model_id = md.id
inner join c_makes mk on a.make_id = mk.id
left join c_ad_extra_info aei on a.id = aei.ad_id
left join c_ad_images ai on a.main_image_id = ai.id
left join c_dealers d on a.dealer_id = d.id
left join c_dealer_addresses da on d.id = da.dealer_id
left join c_country_regions r on d.region_id = r.id
left join c_fuel_types fu on a.fuel_type_id = fu.id
left join c_colours cl on a.colour_id = cl.id
left join c_body_types bd on a.body_type_id = bd.id
left join c_transmission_types tr on a.transmission_type_id = tr.id
left join c_ad_finance_balance_rates fbr on a.id = fbr.ad_id
left join c_reservation_prices rpd on d.reservation_price_id = rpd.id
left join c_reservation_prices rpa on a.reservation_price_id = rpa.id
left join c_ad_warranties w on a.warranty_id = w.id
where a.id = 119541
and a.deleted_at is null
and a.paused_at is null
and a.status = 'live'
and a.dealer_id = 544
limit 1select max(term) from c_ad_finance_calc_results where ad_id = 119541select f.deposit_and_trade_in from c_ad_finance_calc_results f where f.ad_id = 119541 order by f.deposit_and_trade_in asc limit 1select min(term) from c_ad_finance_calc_results where ad_id = 119541
select name, value
from c_ad_extra_properties aep
where aep.ad_id = 119541
select
d.payment_publishable_key_enc,
d.payment_secret_key_enc,
d.square_access_token_enc,
d.square_refresh_token_enc,
d.square_access_token_expire,
d.square_location_id
from c_dealers d
where d.id = 544
select
ai.id as image_id,
ai.template_id,
a.dealer_id as ad_dealer_id,
a.main_image_id
from c_ad_images ai
inner join c_ads a on a.id = ai.ad_id
where a.id = 119541
and ai.deleted_at is null
order by ai.sort_key
select
ceil(price) as price,
ceil(deposit_and_trade_in) as deposit_and_trade_in,
term,
ceil(loan_amount) as loan_amount,
apr,
irr,
ceil(monthly_payments) as monthly_payments,
ceil(total_cost_of_credit) as total_cost_of_credit,
ceil(documentation_fee) as documentation_fee,
ceil(completion_fee) as completion_fee,
reg_year
from c_ad_finance_calc_results
where ad_id = 119541
and is_default_term
order by is_dealer_default desc, deposit_and_trade_in limit 1
select
b.home_title_tag,
b.home_meta_desc,
b.other_title_tag,
b.other_meta_desc,
b.about_us_short,
b.map_key,
ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
ba.country_code,
ba.region_id,
ba.address1,
ba.address2,
ba.address3,
ba.address4,
ba.address5,
ba.postcode,
ba.map_lat,
ba.map_long,
ba.map_zoom,
ba.phone,
r.country_code,
r.region
from c_dealer_site_briefs b
inner join c_dealers d on b.dealer_id = d.id
left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
left join c_country_regions r on ba.region_id = r.id
where d.id = 544
and b.dealer_tag = 'mjmotors'
order by b.id
limit 1
select a.finance_price_per_month from c_ads a where id = 119541
SELECT
r.reviewer_name,
r.review,
date_format(ifnull(r.updated_at, r.created_at), '%d %b %Y') as date,
r.reviewer_location,
r.rating
FROM c_dealer_reviews r
WHERE status = 'live'
AND r.dealer_id = '544'
ORDER BY r.created_at DESC limit 1
SELECT
id,
COUNT(rating) total_num,
SUM(rating) total_sum
FROM c_dealer_reviews
WHERE STATUS = 'live'
AND dealer_id = 544
select
b.home_title_tag,
b.home_meta_desc,
b.other_title_tag,
b.other_meta_desc,
b.about_us_short,
b.map_key,
ifnull(ifnull(b.map_company_name, b.display_name), d.display_name) as name_for_map,
ba.country_code,
ba.region_id,
ba.address1,
ba.address2,
ba.address3,
ba.address4,
ba.address5,
ba.postcode,
ba.map_lat,
ba.map_long,
ba.map_zoom,
ba.phone,
r.country_code,
r.region
from c_dealer_site_briefs b
inner join c_dealers d on b.dealer_id = d.id
left join c_dealer_site_brief_addresses ba on b.id = ba.brief_id
left join c_country_regions r on ba.region_id = r.id
where d.id = 544
and b.dealer_tag = 'mjmotors'
order by b.id
limit 1 [CACHED]select display_name, email from c_dealers where id = 544SELECT
a.id,
a.s3_image,
a.description,
a.price,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
d.location_name,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and a.dealer_id = 544
and a.model_id = 25 and a.id not in (119541)
order by a.updated_at desc
LIMIT 8SELECT
a.id,
a.s3_image,
a.description,
a.price,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
d.location_name,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and a.dealer_id = 544
and a.make_id = 6 and a.id not in (119541,289515,149931)
order by a.updated_at desc
LIMIT 8SELECT
a.id,
a.s3_image,
a.description,
a.price,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
d.location_name,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and a.dealer_id = 544
and a.body_type_id = 1 and a.id not in (119541,289515,149931)
order by a.updated_at desc
LIMIT 8SELECT
a.id,
a.s3_image,
a.description,
a.price,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
d.location_name,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and a.dealer_id = 544
and a.reg_year = 2017 and a.id not in (119541,289515,149931,293179,283188)
order by a.updated_at desc
LIMIT 8SELECT
a.id,
a.s3_image,
a.description,
a.price,
a.previous_price,
a.reg_year,
if (ifnull(a.make_text, '') != '', a.make_text, mk.make) as make,
if (ifnull(a.model_text, '') != '', a.model_text, md.model) as model,
a.variant,
a.owners,
a.test_due_date,
a.mileage,
a.kilometres,
a.updated_at,
a.engine_cc,
a.key_location,
d.location_name,
ceil( ifnull(fin.monthly_payments, a.finance_price_per_month) ) as finance_price_per_month,
DATE_FORMAT(a.expires_at,'%r on %d/%m/%Y') AS expiry_date,
f.fuel_type,
t.transmission_type,
b.body_type,
c.rgb_hex,
c.colour,
a.main_image_id,
ai.template_id,
a.youtube_id,
ceil(a.finance_price_per_month_pcp) as finance_price_per_month_pcp,
a.dealer_id as ad_dealer_id,
if(ifnull(a.reservation_id, 0), 1, 0) as is_reserved,
exists (select 1 from c_ad_extra_properties aep where aep.ad_id = a.id) as has_extras,
(SELECT COUNT(*) FROM c_ad_images ai2 WHERE ai2.ad_id = a.id AND ai2.deleted_at IS NULL) AS image_count
FROM c_ads a
INNER JOIN c_models md ON a.model_id = md.id
INNER JOIN c_makes mk ON a.make_id = mk.id
INNER JOIN c_transmission_types t ON a.transmission_type_id = t.id
INNER JOIN c_fuel_types f ON a.fuel_type_id = f.id
INNER JOIN c_ad_images ai ON a.main_image_id = ai.id
INNER JOIN c_dealers d on a.dealer_id = d.id
left join c_ad_finance_calc_results fin on a.id = fin.ad_id and fin.is_default_term and fin.is_default
LEFT JOIN c_body_types b ON a.body_type_id = b.id
LEFT JOIN c_colours c ON a.colour_id = c.id
WHERE a.status = 'live' AND a.expires_at > now() AND a.paused_at is null AND a.deleted_at is null AND a.web_sale_id IS NULL
and a.dealer_id = 544
and a.reg_year = 2016 and a.id not in (119541,289515,149931,293179,283188)
order by a.updated_at desc
LIMIT 8
select
d.payment_publishable_key_enc,
d.payment_secret_key_enc,
d.square_access_token_enc,
d.square_refresh_token_enc,
d.square_access_token_expire,
d.square_location_id
from c_dealers d
where d.id = 544 [CACHED]
SELECT deposit_and_trade_in
FROM c_ad_finance_calc_results
WHERE ad_id = 119541
ORDER BY deposit_and_trade_in
SELECT deposit_and_trade_in
FROM c_ad_finance_calc_results
WHERE ad_id = 119541
ORDER BY deposit_and_trade_in
[CACHED]
SELECT deposit_and_trade_in
FROM c_ad_finance_calc_results
WHERE ad_id = 119541
ORDER BY deposit_and_trade_in
[CACHED]/var/www/core/www/vehicle.php/var/www/templates/BOC2/www/vehicle.php/var/www/templates/BOC2/www/vehicle.blade.php{
"id": "zB5GN"
}{
"X-Amz-Cf-Id": "vOq5BSvJjw2lrMwwtqS9lvfB0ZJLHIHb8BJe42jPMigrnhA_1bNEdA==",
"Accept-Encoding": "gzip",
"Via": "2.0 8693090c9bc8f44fd1010f18b33c0528.cloudfront.net (CloudFront)",
"User-Agent": "Amazon CloudFront",
"X-Amzn-Trace-Id": "Root=1-68f0da5c-1647074c60837758217e7fe1",
"Host": "preview2rmbi7.happydealer.ie",
"X-Forwarded-Port": "443",
"X-Forwarded-Proto": "https",
"X-Forwarded-For": "216.73.216.222, 64.252.114.67",
"X-Hd-Debug": "",
"Content-Length": "",
"Content-Type": ""
}