static function getDirectoryByTourid($tour_id)
{
$directory = '';
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select('users.*');
$query->from('#__users AS users');
$query->leftJoin('#__bookpro_customer AS customer ON customer.user=users.id');
$query->leftJoin('#__bookpro_tour AS tour ON tour.userid=customer.id');
$query->where('tour.id=' . $db->quote($tour_id));
$sql = (string) $query;
$db->setQuery($sql);
$object = $db->loadObject();
if ($object) {
$directory = 'supplier/' . $object->username;
BookProHelper::CheckFolderImageForSupplier('supplier', $object->username);
}
//return 'banners';
return $directory;
}
