function getTransmision() { $sql = "SELECT *, COUNT(*) AS SEN_Number\r\n FROM camSeminuevos sen\r\n GROUP BY SEN_Transmision\r\n ORDER BY SEN_Id ASC\r\n "; /*$structure = array( 'id_mdo' => 'MDO_Id', 'nombre_mdo' => 'MDO_Nombre', 'id_marc' => 'MAR_Id', 'nombre_marc' => 'MAR_Nombre', 'cantidad' => 'MAR_Number', );*/ $structure = array("modelo" => array("transmision" => "SEN_Transmision", "id_sen" => "SEN_Id", "cantidad" => "SEN_Number")); $params = array(); $orderBy = array(); $result = generalQuery(getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC); $detail = array(); $detail = multiLevelJSON($result, $structure, $orderBy); echo changeArrayIntoJSON('campa', $detail); //echo changeQueryIntoJSON('campa', $structure, getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC); }
function getLogosAgenciesNews() { $sql = "SELECT *\r\n FROM camAgenciasPrincipales agp\r\n INNER JOIN (\r\n SELECT *\r\n FROM camMarcasLogosAgencias\r\n ) mla\r\n ON agp.AGP_Id = mla.MLA_AGP_Id\r\n ORDER BY AGP_Id, MLA_Logo\r\n "; $params = array(); $structure = array('agencia_principal' => array('agpid' => 'AGP_Id', 'agpnombre' => 'AGP_Agencia', 'agpshort' => 'AGP_Short', 'logo' => 'AGP_Logo'), 'marcas' => array('mlaid' => 'MLA_Id', 'brand' => 'MLA_Logo', 'mlastatus' => 'MLA_Status')); $orderBy = array(); $result = generalQuery(getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC); $result = multiLevelJSON($result, $structure, $orderBy); $counter = 1; for ($i = 0; $i < count($result); $i++) { $tltip = $counter <= 6 ? 'top' : 'down'; $result[$i]['tltip'] = $tltip; $animate = $counter <= 6 ? 'animation-slideUp' : 'animation-slideDown'; $result[$i]['animate'] = $animate; $longmarcas = count($result[$i]['marcas']); $longcount = 0; foreach ($result[$i]['marcas'] as $marca) { if ($marca['mlastatus'] == 0) { $longcount++; } } if ($longcount == $longmarcas) { $result[$i]['marcas'] = array(); } $counter++; } echo changeArrayIntoJSON('campa', $result); }
function getLogosAgenciesTrucks() { $sql = "SELECT *\n FROM camAgenciasPrincipales agp\n INNER JOIN (\n SELECT *\n FROM camAgencias\n WHERE AGN_IsAgencieTrucks = 1\n AND AGN_Tipo = 1\n AND AGN_Status = 1\n ) agn\n ON agp.AGP_Id = agn.AGN_AGP_Id\n INNER JOIN (\n SELECT *\n FROM camMarcasLogosAgencias\n WHERE MLA_IsTrucks = 1\n ) mla\n ON agp.AGP_Id = mla.MLA_AGP_Id\n ORDER BY AGP_Index\n "; $params = array(); $structure = array('agencia_principal' => array('agnid' => 'AGN_Id', 'agpid' => 'AGP_Id', 'agpindex' => 'AGP_Index', 'agpnombre' => 'AGP_Agencia', 'agpshort' => 'AGP_Short', 'logo' => 'AGN_Logo1', 'agpagencia' => 'AGP_Agencia', 'agpshort' => 'AGP_Short', 'agnnombre' => 'AGN_Nombre', 'agnurl' => 'AGN_Url'), 'marcas' => array('mlaid' => 'MLA_Id', 'brand' => 'MLA_Logo', 'mlastatus' => 'MLA_Status')); $orderBy = array(); $result = generalQuery(getConnection(), $sql, $params, 0, PDO::FETCH_ASSOC); $result = multiLevelJSON($result, $structure, $orderBy); $counter = 1; for ($i = 0; $i < count($result); $i++) { $tltip = $counter <= 1 ? 'top' : 'none'; $result[$i]['tltip'] = $tltip; $animate = $counter <= 1 ? 'animation-slideUp' : 'animation-none'; $result[$i]['animate'] = $animate; $longmarcas = count($result[$i]['marcas']); $longcount = 0; foreach ($result[$i]['marcas'] as $marca) { if ($marca['mlastatus'] == 0) { $longcount++; } } if ($longcount == $longmarcas) { $result[$i]['marcas'] = array(); } $counter++; } echo changeArrayIntoJSON('campa', $result); }