PHP getSeminuevosByFilterJSON Examples

Example #1

File: index.php Project: hevelmo/compress

function getSeminuevosByFilter($category, $marca, $modelo)
{
    $category = $category ? $category : '';
    $marca = $marca ? $marca : '';
    $modelo = $modelo ? $modelo : '';
    $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 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_Id\r\n                WHERE 1 = 1\r\n                ";
    $params = array();
    if ($category !== '') {
        $sql .= " AND SEN_CAT_Id = :category";
        $params["category"] = $category;
    }
    if ($marca !== '') {
        $sql .= " AND SEN_MAR_Id = :marca";
        $params["marca"] = $marca;
    }
    if ($modelo !== '') {
        $sql .= " AND SEN_MDO_Id = :modelo";
        $params["modelo"] = $modelo;
    }
    $sql .= "\r\n                GROUP BY SEN_Id\r\n                ORDER BY SEN_Id DESC\r\n                ";
    getSeminuevosByFilterJSON($sql, $category, $marca, $modelo);
}

Example #2

File: index.php Project: hevelmo/suzuki-lm-seminuevos

function getSeminuevosByFilter($category, $marca, $modelo)
{
    $category = $category ? $category : '';
    $marca = $marca ? $marca : '';
    $modelo = $modelo ? $modelo : '';
    $sql = "SELECT sen.*, tel.*,\r\n                       thm.PIC_Id,\r\n                       COALESCE(thm.PIC_Nombre, 'default_camcar.jpg') PIC_Nombre,\r\n                       COALESCE(thm.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                LEFT JOIN (\r\n                    SELECT *\r\n                    FROM camPictures\r\n                    WHERE PIC_Thum = 1\r\n                ) thm\r\n                ON sen.SEN_Id = thm.PIC_SEN_Id\r\n                WHERE 1 = 1\r\n                AND AGN_Id = 7\r\n                ";
    $params = array();
    if ($category !== '') {
        $sql .= " AND SEN_CAT_Id = :category";
        $params["category"] = $category;
    }
    if ($marca !== '') {
        $sql .= " AND SEN_MAR_Id = :marca";
        $params["marca"] = $marca;
    }
    if ($modelo !== '') {
        $sql .= " AND SEN_MDO_Id = :modelo";
        $params["modelo"] = $modelo;
    }
    $sql .= "\r\n                GROUP BY SEN_Id\r\n                ORDER BY SEN_Id DESC\r\n                ";
    getSeminuevosByFilterJSON($sql, $category, $marca, $modelo);
}

Example #3

File: index.php Project: hevelmo/compress

function getSeminuevosByFilter($category, $marca, $modelo)
{
    $category = $category ? $category : '';
    $marca = $marca ? $marca : '';
    $modelo = $modelo ? $modelo : '';
    $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 (\r\n                    SELECT * \r\n                    FROM camPictures\r\n                    WHERE PIC_Thum = 1\r\n                ) thm\r\n                ON sen.SEN_Id = thm.PIC_SEN_Id\r\n                WHERE 1 = 1";
    $params = array();
    if ($category !== '') {
        $sql .= " AND SEN_CAT_Id = :category";
        $params["category"] = $category;
    }
    if ($marca !== '') {
        $sql .= " AND SEN_MAR_Id = :marca";
        $params["marca"] = $marca;
    }
    if ($modelo !== '') {
        $sql .= " AND SEN_MDO_Id = :modelo";
        $params["modelo"] = $modelo;
    }
    $sql .= "\r\n                GROUP BY SEN_Id\r\n                ORDER BY SEN_Id DESC";
    getSeminuevosByFilterJSON($sql, $category, $marca, $modelo);
}