function getSeminuevosById($mrc_nombre_short, $mdo_nombre_short, $senId)
{
$sql = "SELECT sen.*, tel.*, hrs.*, soc.*,\r\n pic.PIC_Id,\r\n COALESCE(pic.PIC_Nombre, 'default_camcar.jpg') PIC_Nombre,\r\n COALESCE(pic.PIC_SEN_Id, 'default') PIC_Folder\r\n FROM (\r\n SELECT *\r\n FROM v_camSeminuevos\r\n WHERE SEN_Status = 1\r\n ) sen\r\n INNER JOIN camTelefonos tel\r\n ON sen.AGN_Id = tel.TEL_AGN_Id\r\n INNER JOIN camHorarios hrs\r\n ON sen.AGN_Id = hrs.HRS_AGN_Id\r\n INNER JOIN camSociales soc\r\n ON sen.AGN_Id = soc.SOC_AGN_Id\r\n LEFT JOIN camPictures pic\r\n ON sen.SEN_Id = pic.PIC_SEN_Id\r\n WHERE MAR_NombreShort = :mrc_nombre_short\r\n AND MDO_NombreShort = :mdo_nombre_short\r\n AND SEN_Id = :senId\r\n AND AGN_Id = 7\r\n GROUP BY SEN_Id\r\n ";
getSeminuevosJSON($sql, $mrc_nombre_short, $mdo_nombre_short, $senId);
}
function getSeminuevosById($mrc_nombre_short, $mdo_nombre_short, $senId)
{
$sql = "SELECT *\r\n FROM v_camSeminuevos sen\r\n INNER JOIN camTelefonos tel\r\n ON sen.AGN_Id = tel.TEL_AGN_Id\r\n INNER JOIN camHorarios hrs\r\n ON sen.AGN_Id = hrs.HRS_AGN_Id\r\n INNER JOIN camSociales soc\r\n ON sen.AGN_Id = soc.SOC_AGN_Id\r\n INNER JOIN camPictures pic\r\n ON sen.SEN_Id = pic.PIC_SEN_Id\r\n WHERE MAR_NombreShort = :mrc_nombre_short\r\n AND MDO_NombreShort = :mdo_nombre_short\r\n AND SEN_Id = :senId\r\n GROUP BY SEN_Id";
getSeminuevosJSON($sql, $mrc_nombre_short, $mdo_nombre_short, $senId);
}
function getSeminuevosById($mrc_nombre_short, $mdo_nombre_short, $senId)
{
$sql = "SELECT *\r\n FROM camSeminuevos sen\r\n INNER JOIN camAgencias agn\r\n ON sen.SEN_AGN_Id = agn.AGN_Id\r\n INNER JOIN camAGNTelefonos agntel\r\n ON agn.AGN_Id = agntel.TEL_AGN_Id\r\n INNER JOIN camAGNHorarios agnhrs\r\n ON agn.AGN_Id = agnhrs.HRS_AGN_Id\r\n INNER JOIN camAGNSociales agnsoc\r\n ON agn.AGN_Id = agnsoc.SOC_AGN_Id\r\n INNER JOIN camCategorias cat\r\n ON sen.SEN_CAT_Id = cat.CAT_Id\r\n INNER JOIN camModelos mdo\r\n ON sen.SEN_MDO_Id = mdo.MDO_Id\r\n INNER JOIN camMarcas mrc\r\n ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n INNER JOIN camPictures pic\r\n ON sen.SEN_Id = pic.PIC_SEN_Id\r\n INNER JOIN camThumbs thm\r\n ON sen.SEN_Id = thm.THM_SEN_Id\r\n WHERE MAR_NombreShort = :mrc_nombre_short\r\n AND MDO_NombreShort = :mdo_nombre_short\r\n AND SEN_Id = :senId\r\n GROUP BY SEN_Id\r\n ";
getSeminuevosJSON($sql, $mrc_nombre_short, $mdo_nombre_short, $senId);
}
function getSeminuevosById($senId)
{
$sql = "SELECT *\r\n FROM camSeminuevos sen\r\n INNER JOIN camAgencias agn\r\n ON sen.SEN_AGN_Id = agn.AGN_Id\r\n INNER JOIN camCategorias cat\r\n ON sen.SEN_CAT_Id = cat.CAT_Id\r\n INNER JOIN camModelos mdo\r\n ON sen.SEN_MDO_Id = mdo.MDO_Id\r\n INNER JOIN camMarcas mrc\r\n ON sen.SEN_MAR_Id = mrc.MAR_Id\r\n INNER JOIN camPictures pic\r\n ON sen.SEN_PIC_Id = pic.PIC_SEN_Id\r\n WHERE SEN_Id = :senId\r\n ";
getSeminuevosJSON($sql, $senId, '');
}
