*Images for illustration purposes only.
{source}
input;
$ProductId=$input->get('virtuemart_product_id');
if(!empty($ProductId)){
$db=JFactory::getDBO();
$X='SELECT product_sku FROM dsas_virtuemart_products WHERE virtuemart_product_id='.$ProductId;
$db->setQuery($X);
$ProductSku=$db->loadResult();
$find_underscore = preg_match('/_/', $ProductSku);
if($find_underscore){
$product_sku = explode("_",$ProductSku);
$p_sku = $product_sku[1];
}else{
$p_sku = $ProductSku;
}
echo 'Part Number: <span style="font-weight:600;color:#333;">'.$p_sku.'</span>';
}
?>{/source}
{source}
getQuery(true)
->select('*')
->from($db->quoteName('#__dobinsonscataloguevehicles_vehicles'))
->where($db->quoteName('code') . ' = ' . $db->quote($skuPart));
$db->setQuery($query);
$vehicle = $db->loadObject();
if (!$vehicle) {
echo 'No vehicle found.';
return;
}
$suspensionPageLink = $vehicle->suspension_page_link ?: $vehicle->vehicle_page_link;
$makeNames = [];
$typeNames = [];
$modelNames = [];
// Fetch makes
$makeIds = explode(",", $vehicle->make);
if (!empty($makeIds)) {
$query = $db->getQuery(true)
->select('make')
->from($db->quoteName('#__dobinsonscataloguevehicles_makes'))
->where($db->quoteName('id') . ' IN (' . implode(',', array_map([$db, 'quote'], $makeIds)) . ')');
$db->setQuery($query);
$makes = $db->loadObjectList();
foreach ($makes as $make) {
$makeNames[] = $make->make;
}
}
// Fetch types
$typeIds = explode(",", $vehicle->type);
if (!empty($typeIds)) {
$query = $db->getQuery(true)
->select('type')
->from($db->quoteName('#__dobinsonscataloguevehicles_types'))
->where($db->quoteName('id') . ' IN (' . implode(',', array_map([$db, 'quote'], $typeIds)) . ')');
$db->setQuery($query);
$types = $db->loadAssocList();
foreach ($types as $type) {
$typeNames[] = $type['type'];
}
}
// Parse vehicle models
$vehicleModels = json_decode($vehicle->model);
if (!empty($vehicleModels)) {
foreach ($vehicleModels as $model) {
$startMonth = $model->month_start ? sprintf('%02s/', $model->month_start) : '';
$startYear = $model->year_start ?: '';
$endMonth = $model->month_end ? sprintf('%02s/', $model->month_end) : '';
$endYear = $model->year_end ?: '';
$separator = ($endMonth || $endYear) ? ' to ' : ' on';
$modelNames[] = $model->model . ' (' . ($startMonth === '13/' ? 'Mid ' : $startMonth) . $startYear . $separator . ($endMonth === '13/' ? 'Mid ' : $endMonth) . $endYear . ')';
}
}
$makeNamesStr = implode(', ', $makeNames);
$typeNamesStr = implode(', ', $typeNames);
$modelNamesStr = implode(', ', $modelNames);
echo 'Vehicle Fitment: ' . htmlspecialchars($makeNamesStr . ' ' . $typeNamesStr . ' ' . $modelNamesStr, ENT_QUOTES, 'UTF-8') . '';
}
$input = JFactory::getApplication()->input;
$productId = $input->getInt('virtuemart_product_id');
if ($productId) {
$db = JFactory::getDbo();
$query = $db->getQuery(true)
->select('product_sku')
->from($db->quoteName('#__virtuemart_products'))
->where($db->quoteName('virtuemart_product_id') . ' = ' . $db->quote($productId));
$db->setQuery($query);
$productSku = $db->loadResult();
if ($productSku) {
vehicleFitment($productSku);
} else {
echo 'Product SKU not found.';
}
}
?>
{/source}
Shackle Pin
$ 49.67
 | Length: | |
 | Width: | |
 | Height: | |
 | Weight: |