1
see the return of the script, running directory in mysql, by sqlYog:
However, when I run in Visual Studio, the return is different:
Serialized result:
"TotalMesAMes": [
{
"mes": "January",
"status": "Fechado",
"valor_negocio": 1500
},
{
"mes": "February",
"status": "Fechado",
"valor_negocio": 1260
},
{
"mes": "March",
"status": "Fechado",
"valor_negocio": 500
},
{
"mes": "May",
"status": "Fechado",
"valor_negocio": 1300
},
{
"mes": "June",
"status": "Fechado",
"valor_negocio": 1500
},
{
"mes": "July",
"status": "Fechado",
"valor_negocio": 1000
},
{
"mes": "August",
"status": "Fechado",
"valor_negocio": 3800
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "September",
"status": "Contato",
"valor_negocio": 0
},
{
"mes": "October",
"status": "Em andamento",
"valor_negocio": 5500
},
{
"mes": "October",
"status": "Em andamento",
"valor_negocio": 5500
},
{
"mes": "November",
"status": "Em andamento",
"valor_negocio": 500
},
{
"mes": "November",
"status": "Em andamento",
"valor_negocio": 500
}
]
Strange, I need the return to be equal to the executed on sqlyog. for example, in the month of November, it is returning twice the same value, but the correct one is new 500 and November 400