raintrooper's questions

I am trying to generate a plot with matplotlib from a dataframe. What I want to show on the graph is a correlation between the age of people and the money they earn and spend. The problem is that I can't make the graph understandable or readable.

I tried to group the information so that, for example, the ages and their respective values ​​are not repeated, but I have not succeeded.

If you could help me to correctly generate the graph please. Thank you

import matplotlib
import matplotlib.pyplot as plt
import numpy as np

import matplotlib.pyplot as plt
import pandas as pd

data = [{'Genre':1,'Age':19,'annualincome':15,'annualexpenses':39},
{'Genre':1,'Age':21,'annualincome':15,'annualexpenses':81},
{'Genre':0,'Age':20,'annualincome':16,'annualexpenses':6},
{'Genre':0,'Age':23,'annualincome':16,'annualexpenses':77},
{'Genre':0,'Age':31,'annualincome':17,'annualexpenses':40},
{'Genre':0,'Age':22,'annualincome':17,'annualexpenses':76},
{'Genre':0,'Age':35,'annualincome':18,'annualexpenses':6},
{'Genre':0,'Age':23,'annualincome':18,'annualexpenses':94},
{'Genre':1,'Age':64,'annualincome':19,'annualexpenses':3},
{'Genre':0,'Age':30,'annualincome':19,'annualexpenses':72},
{'Genre':1,'Age':67,'annualincome':19,'annualexpenses':14},
{'Genre':0,'Age':35,'annualincome':19,'annualexpenses':99},
{'Genre':0,'Age':58,'annualincome':20,'annualexpenses':15},
{'Genre':0,'Age':24,'annualincome':20,'annualexpenses':77},
{'Genre':1,'Age':37,'annualincome':20,'annualexpenses':13},
{'Genre':1,'Age':22,'annualincome':20,'annualexpenses':79},
{'Genre':0,'Age':35,'annualincome':21,'annualexpenses':35},
{'Genre':1,'Age':20,'annualincome':21,'annualexpenses':66},
{'Genre':1,'Age':52,'annualincome':23,'annualexpenses':29},
{'Genre':0,'Age':35,'annualincome':23,'annualexpenses':98},
{'Genre':1,'Age':35,'annualincome':24,'annualexpenses':35},
{'Genre':1,'Age':25,'annualincome':24,'annualexpenses':73},
{'Genre':0,'Age':46,'annualincome':25,'annualexpenses':5},
{'Genre':1,'Age':31,'annualincome':25,'annualexpenses':73},
{'Genre':0,'Age':54,'annualincome':28,'annualexpenses':14},
{'Genre':1,'Age':29,'annualincome':28,'annualexpenses':82},
{'Genre':0,'Age':45,'annualincome':28,'annualexpenses':32},
{'Genre':1,'Age':35,'annualincome':28,'annualexpenses':61},
{'Genre':0,'Age':40,'annualincome':29,'annualexpenses':31},
{'Genre':0,'Age':23,'annualincome':29,'annualexpenses':87},
{'Genre':1,'Age':60,'annualincome':30,'annualexpenses':4},
{'Genre':0,'Age':21,'annualincome':30,'annualexpenses':73},
{'Genre':1,'Age':53,'annualincome':33,'annualexpenses':4},
{'Genre':1,'Age':18,'annualincome':33,'annualexpenses':92},
{'Genre':0,'Age':49,'annualincome':33,'annualexpenses':14},
{'Genre':0,'Age':21,'annualincome':33,'annualexpenses':81},
{'Genre':0,'Age':42,'annualincome':34,'annualexpenses':17},
{'Genre':0,'Age':30,'annualincome':34,'annualexpenses':73},
{'Genre':0,'Age':36,'annualincome':37,'annualexpenses':26},
{'Genre':0,'Age':20,'annualincome':37,'annualexpenses':75},
{'Genre':0,'Age':65,'annualincome':38,'annualexpenses':35},
{'Genre':1,'Age':24,'annualincome':38,'annualexpenses':92},
{'Genre':1,'Age':48,'annualincome':39,'annualexpenses':36},
{'Genre':0,'Age':31,'annualincome':39,'annualexpenses':61},
{'Genre':0,'Age':49,'annualincome':39,'annualexpenses':28},
{'Genre':0,'Age':24,'annualincome':39,'annualexpenses':65},
{'Genre':0,'Age':50,'annualincome':40,'annualexpenses':55},
{'Genre':0,'Age':27,'annualincome':40,'annualexpenses':47},
{'Genre':0,'Age':29,'annualincome':40,'annualexpenses':42},
{'Genre':0,'Age':31,'annualincome':40,'annualexpenses':42},
{'Genre':0,'Age':49,'annualincome':42,'annualexpenses':52},
{'Genre':1,'Age':33,'annualincome':42,'annualexpenses':60},
{'Genre':0,'Age':31,'annualincome':43,'annualexpenses':54},
{'Genre':1,'Age':59,'annualincome':43,'annualexpenses':60},
{'Genre':0,'Age':50,'annualincome':43,'annualexpenses':45},
{'Genre':1,'Age':47,'annualincome':43,'annualexpenses':41},
{'Genre':0,'Age':51,'annualincome':44,'annualexpenses':50},
{'Genre':1,'Age':69,'annualincome':44,'annualexpenses':46},
{'Genre':0,'Age':27,'annualincome':46,'annualexpenses':51},
{'Genre':1,'Age':53,'annualincome':46,'annualexpenses':46},
{'Genre':1,'Age':70,'annualincome':46,'annualexpenses':56},
{'Genre':1,'Age':19,'annualincome':46,'annualexpenses':55},
{'Genre':0,'Age':67,'annualincome':47,'annualexpenses':52},
{'Genre':0,'Age':54,'annualincome':47,'annualexpenses':59},
{'Genre':1,'Age':63,'annualincome':48,'annualexpenses':51},
{'Genre':1,'Age':18,'annualincome':48,'annualexpenses':59},
{'Genre':0,'Age':43,'annualincome':48,'annualexpenses':50},
{'Genre':0,'Age':68,'annualincome':48,'annualexpenses':48},
{'Genre':1,'Age':19,'annualincome':48,'annualexpenses':59},
{'Genre':0,'Age':32,'annualincome':48,'annualexpenses':47},
{'Genre':1,'Age':70,'annualincome':49,'annualexpenses':55},
{'Genre':0,'Age':47,'annualincome':49,'annualexpenses':42},
{'Genre':0,'Age':60,'annualincome':50,'annualexpenses':49},
{'Genre':0,'Age':60,'annualincome':50,'annualexpenses':56},
{'Genre':1,'Age':59,'annualincome':54,'annualexpenses':47},
{'Genre':1,'Age':26,'annualincome':54,'annualexpenses':54},
{'Genre':0,'Age':45,'annualincome':54,'annualexpenses':53},
{'Genre':1,'Age':40,'annualincome':54,'annualexpenses':48},
{'Genre':0,'Age':23,'annualincome':54,'annualexpenses':52},
{'Genre':0,'Age':49,'annualincome':54,'annualexpenses':42},
{'Genre':1,'Age':57,'annualincome':54,'annualexpenses':51},
{'Genre':1,'Age':38,'annualincome':54,'annualexpenses':55},
{'Genre':1,'Age':67,'annualincome':54,'annualexpenses':41},
{'Genre':0,'Age':46,'annualincome':54,'annualexpenses':44},
{'Genre':0,'Age':21,'annualincome':54,'annualexpenses':57},
{'Genre':1,'Age':48,'annualincome':54,'annualexpenses':46},
{'Genre':0,'Age':55,'annualincome':57,'annualexpenses':58},
{'Genre':0,'Age':22,'annualincome':57,'annualexpenses':55},
{'Genre':0,'Age':34,'annualincome':58,'annualexpenses':60},
{'Genre':0,'Age':50,'annualincome':58,'annualexpenses':46},
{'Genre':0,'Age':68,'annualincome':59,'annualexpenses':55},
{'Genre':1,'Age':18,'annualincome':59,'annualexpenses':41},
{'Genre':1,'Age':48,'annualincome':60,'annualexpenses':49},
{'Genre':0,'Age':40,'annualincome':60,'annualexpenses':40},
{'Genre':0,'Age':32,'annualincome':60,'annualexpenses':42},
{'Genre':1,'Age':24,'annualincome':60,'annualexpenses':52},
{'Genre':0,'Age':47,'annualincome':60,'annualexpenses':47},
{'Genre':0,'Age':27,'annualincome':60,'annualexpenses':50},
{'Genre':1,'Age':48,'annualincome':61,'annualexpenses':42},
{'Genre':1,'Age':20,'annualincome':61,'annualexpenses':49},
{'Genre':0,'Age':23,'annualincome':62,'annualexpenses':41},
{'Genre':0,'Age':49,'annualincome':62,'annualexpenses':48},
{'Genre':1,'Age':67,'annualincome':62,'annualexpenses':59},
{'Genre':1,'Age':26,'annualincome':62,'annualexpenses':55},
{'Genre':1,'Age':49,'annualincome':62,'annualexpenses':56},
{'Genre':0,'Age':21,'annualincome':62,'annualexpenses':42},
{'Genre':0,'Age':66,'annualincome':63,'annualexpenses':50},
{'Genre':1,'Age':54,'annualincome':63,'annualexpenses':46},
{'Genre':1,'Age':68,'annualincome':63,'annualexpenses':43},
{'Genre':1,'Age':66,'annualincome':63,'annualexpenses':48},
{'Genre':1,'Age':65,'annualincome':63,'annualexpenses':52},
{'Genre':0,'Age':19,'annualincome':63,'annualexpenses':54},
{'Genre':0,'Age':38,'annualincome':64,'annualexpenses':42},
{'Genre':1,'Age':19,'annualincome':64,'annualexpenses':46},
{'Genre':0,'Age':18,'annualincome':65,'annualexpenses':48},
{'Genre':0,'Age':19,'annualincome':65,'annualexpenses':50},
{'Genre':0,'Age':63,'annualincome':65,'annualexpenses':43},
{'Genre':0,'Age':49,'annualincome':65,'annualexpenses':59},
{'Genre':0,'Age':51,'annualincome':67,'annualexpenses':43},
{'Genre':0,'Age':50,'annualincome':67,'annualexpenses':57},
{'Genre':1,'Age':27,'annualincome':67,'annualexpenses':56},
{'Genre':0,'Age':38,'annualincome':67,'annualexpenses':40},
{'Genre':0,'Age':40,'annualincome':69,'annualexpenses':58},
{'Genre':1,'Age':39,'annualincome':69,'annualexpenses':91},
{'Genre':0,'Age':23,'annualincome':70,'annualexpenses':29},
{'Genre':0,'Age':31,'annualincome':70,'annualexpenses':77},
{'Genre':1,'Age':43,'annualincome':71,'annualexpenses':35},
{'Genre':1,'Age':40,'annualincome':71,'annualexpenses':95},
{'Genre':1,'Age':59,'annualincome':71,'annualexpenses':11},
{'Genre':1,'Age':38,'annualincome':71,'annualexpenses':75},
{'Genre':1,'Age':47,'annualincome':71,'annualexpenses':9},
{'Genre':1,'Age':39,'annualincome':71,'annualexpenses':75},
{'Genre':0,'Age':25,'annualincome':72,'annualexpenses':34},
{'Genre':0,'Age':31,'annualincome':72,'annualexpenses':71},
{'Genre':1,'Age':20,'annualincome':73,'annualexpenses':5},
{'Genre':0,'Age':29,'annualincome':73,'annualexpenses':88},
{'Genre':0,'Age':44,'annualincome':73,'annualexpenses':7},
{'Genre':1,'Age':32,'annualincome':73,'annualexpenses':73},
{'Genre':1,'Age':19,'annualincome':74,'annualexpenses':10},
{'Genre':0,'Age':35,'annualincome':74,'annualexpenses':72},
{'Genre':0,'Age':57,'annualincome':75,'annualexpenses':5},
{'Genre':1,'Age':32,'annualincome':75,'annualexpenses':93},
{'Genre':0,'Age':28,'annualincome':76,'annualexpenses':40},
{'Genre':0,'Age':32,'annualincome':76,'annualexpenses':87},
{'Genre':1,'Age':25,'annualincome':77,'annualexpenses':12},
{'Genre':1,'Age':28,'annualincome':77,'annualexpenses':97},
{'Genre':1,'Age':48,'annualincome':77,'annualexpenses':36},
{'Genre':0,'Age':32,'annualincome':77,'annualexpenses':74},
{'Genre':0,'Age':34,'annualincome':78,'annualexpenses':22},
{'Genre':1,'Age':34,'annualincome':78,'annualexpenses':90},
{'Genre':1,'Age':43,'annualincome':78,'annualexpenses':17},
{'Genre':1,'Age':39,'annualincome':78,'annualexpenses':88},
{'Genre':0,'Age':44,'annualincome':78,'annualexpenses':20},
{'Genre':0,'Age':38,'annualincome':78,'annualexpenses':76},
{'Genre':0,'Age':47,'annualincome':78,'annualexpenses':16},
{'Genre':0,'Age':27,'annualincome':78,'annualexpenses':89},
{'Genre':1,'Age':37,'annualincome':78,'annualexpenses':1},
{'Genre':0,'Age':30,'annualincome':78,'annualexpenses':78},
{'Genre':1,'Age':34,'annualincome':78,'annualexpenses':1},
{'Genre':0,'Age':30,'annualincome':78,'annualexpenses':73},
{'Genre':0,'Age':56,'annualincome':79,'annualexpenses':35},
{'Genre':0,'Age':29,'annualincome':79,'annualexpenses':83},
{'Genre':1,'Age':19,'annualincome':81,'annualexpenses':5},
{'Genre':0,'Age':31,'annualincome':81,'annualexpenses':93},
{'Genre':1,'Age':50,'annualincome':85,'annualexpenses':26},
{'Genre':0,'Age':36,'annualincome':85,'annualexpenses':75},
{'Genre':1,'Age':42,'annualincome':86,'annualexpenses':20},
{'Genre':0,'Age':33,'annualincome':86,'annualexpenses':95},
{'Genre':0,'Age':36,'annualincome':87,'annualexpenses':27},
{'Genre':1,'Age':32,'annualincome':87,'annualexpenses':63},
{'Genre':1,'Age':40,'annualincome':87,'annualexpenses':13},
{'Genre':1,'Age':28,'annualincome':87,'annualexpenses':75},
{'Genre':1,'Age':36,'annualincome':87,'annualexpenses':10},
{'Genre':1,'Age':36,'annualincome':87,'annualexpenses':92},
{'Genre':0,'Age':52,'annualincome':88,'annualexpenses':13},
{'Genre':0,'Age':30,'annualincome':88,'annualexpenses':86},
{'Genre':1,'Age':58,'annualincome':88,'annualexpenses':15},
{'Genre':1,'Age':27,'annualincome':88,'annualexpenses':69},
{'Genre':1,'Age':59,'annualincome':93,'annualexpenses':14},
{'Genre':1,'Age':35,'annualincome':93,'annualexpenses':90},
{'Genre':0,'Age':37,'annualincome':97,'annualexpenses':32},
{'Genre':0,'Age':32,'annualincome':97,'annualexpenses':86},
{'Genre':1,'Age':46,'annualincome':98,'annualexpenses':15},
{'Genre':0,'Age':29,'annualincome':98,'annualexpenses':88},
{'Genre':0,'Age':41,'annualincome':99,'annualexpenses':39},
{'Genre':1,'Age':30,'annualincome':99,'annualexpenses':97},
{'Genre':0,'Age':54,'annualincome':101,'annualexpenses':24},
{'Genre':1,'Age':28,'annualincome':101,'annualexpenses':68},
{'Genre':0,'Age':41,'annualincome':103,'annualexpenses':17},
{'Genre':0,'Age':36,'annualincome':103,'annualexpenses':85},
{'Genre':0,'Age':34,'annualincome':103,'annualexpenses':23},
{'Genre':0,'Age':32,'annualincome':103,'annualexpenses':69},
{'Genre':1,'Age':33,'annualincome':113,'annualexpenses':8},
{'Genre':0,'Age':38,'annualincome':113,'annualexpenses':91},
{'Genre':0,'Age':47,'annualincome':120,'annualexpenses':16},
{'Genre':0,'Age':35,'annualincome':120,'annualexpenses':79},
{'Genre':0,'Age':45,'annualincome':126,'annualexpenses':28},
{'Genre':1,'Age':32,'annualincome':126,'annualexpenses':74},
{'Genre':1,'Age':32,'annualincome':137,'annualexpenses':18},
{'Genre':1,'Age':30,'annualincome':137,'annualexpenses':83}

]

df = pd.DataFrame.from_dict(data, orient='columns')

edades = df.Age
ingresos = df.annualincome
egresos = df.annualexpenses
x1 = np.arange(len(edades))  # the label locations
width = 0.35  # the width of the bars
fig, ax = plt.subplots()
rect1 = ax.bar(x1 - width/2, ingresos, width, label='annualincome')
rect2 = ax.bar(x1 + width/2, egresos, width, label='annualexpenses')
ax.set_ylabel('Scores')
ax.set_title('Scores by ingresos y egresos')
ax.set_xticks(x1)
ax.set_xticklabels(edades)
ax.legend()

def autolabel(rects):
    """Attach a text label above each bar in *rects*, displaying its height."""
    for rect in rects:
        height = rect.get_height()
        ax.annotate('{}'.format(height),
                    xy=(rect.get_x() + rect.get_width() / 2, height),
                    xytext=(0, 3),  # 3 points vertical offset
                    textcoords="offset points",
                    ha='center', va='bottom')


autolabel(rect1)
autolabel(rect2)

fig.tight_layout()

plt.show()

I am trying to create a view in sql server 2008 to be able to obtain the kilos of a product that several shippers deliver, grouping them by week, year and type of shipper, as well as the number of shippers that were in charge of making the transfer.

To this I must add a column whose value is obtained by dividing the kilos between the number of chargers, an assistance column, and an accumulated column of the kilos obtained.

What I need and I can't do it, is the accumulated column and improve the performance of the view, since being a view I can't use temporary tables for example.

As I currently have the query:

How the query should look like:

Example if there were more days, how the accumulated is calculated:

If you could help me please, I leave the following example:

edit: Modified the example to make it more readable

   declare @VMovimientos table(
Anio int,
TipoCargador int,
Semana int,
Kilos decimal(12,2),
Vendedor int,
FechaVenta datetime
)

insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,1,1,100,1,'01/01/2019')
insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,2,1,100,1,'01/01/2019')
insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,1,1,100,2,'03/01/2019')
insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,2,1,100,3,'04/01/2019')

insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,1,2,100,1,'05/01/2019')
insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,2,2,100,1,'07/01/2019')
insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,1,2,100,2,'05/01/2019')
insert into @VMovimientos(Anio,TipoCargador,Semana,Kilos,Vendedor,FechaVenta)values(2019,2,2,100,3,'05/01/2019')

--select * from @VMovimientos

select a.Anio,a.Semana,b.Asistencia,a.TipoCargador,a.Kilos/b.Asistencia as KHSemana,a.Kilos

from (
    select sum(Kilos) Kilos,TipoCargador,a.Semana,a.Anio
    from @VMovimientos a
    where a.Anio=2019
    group by a.Anio,a.Semana,a.TipoCargador
)a 
inner join (select sum(a.Asistencia) Asistencia,a.Anio,a.Semana,a.TipoCargador
            from (
                select count(distinct(Vendedor)) Asistencia,a.Anio,a.Semana,a.TipoCargador
                from @VMovimientos a
                where a.Anio=2019
                group by a.Anio,a.Semana,a.FechaVenta,a.TipoCargador)a
            group by a.Anio,a.Semana,a.TipoCargador)b on a.Anio=b.Anio and a.Semana=b.Semana and a.TipoCargador=b.TipoCargador
inner join (
    select sum(Kilos) Toneladas,TipoCargador,a.Semana,a.Anio
    from @VMovimientos a
    where a.Anio=2019
    group by a.Anio,a.Semana,a.TipoCargador
)d on a.Anio=d.Anio and a.Semana=d.Semana and a.TipoCargador=d.TipoCargador
order by  a.Anio,a.TipoCargador,a.Semana asc

I am trying to generate two events when clicking different cells within a GridView. The problem is that if I execute the event in the first cell, event 1 is fired, instead if I execute the event in cell 2, event 1 and event 2 are fired.

I tried to replicate the problem in the following code.

$("table[id*='GrdDatos'] a[id*=GetId]").click(function(e) {
e.preventDefault();
  if ($(e.currentTarget).is('a[id*=GetId]')) {
    alert(1);
  }
  e.stopPropagation();
  return false;
});
$("table[id*='GrdDatos'] a[id*=GetIdOtEliminar]").click(function(e) {
e.preventDefault();
  if ($(e.currentTarget).is('a[id*=GetIdOtEliminar]')) {
    alert(2);
  }
  e.stopPropagation();
  return false;
});

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<table style="width:100%" id="GrdDatos">
  <tr>
    <th>Evento 1</th>
    <th>Lastname</th>
    <th>Evento 2</th>
  </tr>
    <tr>
    <td><a id="GetId" style="cursor:pointer">Clic aquí 1</a></td>
    <td>Jackson</td>
    <td><a id="GetIdOtEliminar" style="cursor:pointer">Clic aquí 2</a></td>
  </tr>
</table>

Thank you very much for your help.

I am trying to eliminate the black background of the letters that appear in each column, in order to make the data readable, but I am not successful.

If you can help me thank you very much.

$(function () {
 Highcharts.setOptions({
 lang: {
 thousandsSep:  ','
 }
 });
 $('#grafico0').highcharts({
colors: ['#263238', '#00BCD4'],
    chart: {
       type: 'column'
    },
    title: {
       text: 'Horas'
    },
    xAxis: {
title: {   enabled: true,   text:       ''},       categories: [{ name: 'Frentes<br><br>Frentes<br><br>Frentes<br>', categories: [
'01','02','03','04','96','97',]},{ name: 'Frentes<br><br>Frentes<br>', categories: [
'06','07',]},{ name: 'Frentes<br><br>PxP<br>', categories: [
'11','17','19','41',]},{ name: 'Frentes<br><br>Frentes<br>', categories: [
'84',]},{ name: 'Frentes<br><br>Frentes<br><br><br>', categories: [
'26',]},{ name: 'Promedio<br>', categories: [
'Promedio',]},]
    },
    yAxis: {
       min: 0,
          title: {
             text: '',
          },
          stackLabels: {
             enabled: false,
             style: {
                fontWeight:  'normal',
                color: (Highcharts.theme && Highcharts.theme.textColor) || 'gray'
             }
          }
    },
    legend: {
       align: 'left',
    },
    plotOptions: {
    spline: {dataLabels:{enabled: true}},       column: {
          stacking:   'normal',
          dataLabels: {
             enabled: true,
             formatter: function() {
                if(this.y > -1)
                   return this.point.label;
             },
            style: {                   fontWeight:  'normal',                   color:      'white',                   fontSize:   '8px'          }          }
       }
    },
    series: [{
       name: 'Porcentaje1',
       data: [
{    y: 19.12,
    label: ' 19.12% ; 2,562'
},{    y: 7.13,
    label: ' 7.13% ; 857'
},{    y: 41.85,
    label: ' 41.85% ; 1,827'
},{    y: 34.94,
    label: ' 34.94% ; 5,114'
},{    y: 100.00,
    label: ' 100.00% ; 1,210'
},{    y: 95.90,
    label: ' 95.90% ; 1,211'
},{    y: 11.35,
    label: ' 11.35% ; 1,151'
},{    y: 5.99,
    label: ' 5.99% ; 538'
},{    y: 5.44,
    label: ' 5.44% ; 538'
},{    y: 0.00,
    label: ' 0.00% ; 0'
},{    y: 0.00,
    label: ' 0.00% ; 0'
},{    y: 19.55,
    label: ' 19.55% ; 608'
},{    y: 33.20,
    label: ' 33.20% ; 971'
},{    y: 46.77,
    label: ' 46.77% ; 611'
},{    y: 20.38,
    label: ' 20.38% ; 17,202'
}
       ]
       }, {       name: ' Porcentaje2',
       data: [{    y: 80.88,
    label: ' 80.88% ; 10,841'
},{    y: 92.87,
    label: ' 92.87% ; 11,170'
},{    y: 58.15,
    label: ' 58.15% ; 2,539'
},{    y: 65.06,
    label: ' 65.06% ; 9,523'
},{    y: 0.00,
    label: ' 0.00% ; 0'
},{    y: 4.10,
    label: ' 4.10% ; 51'
},{    y: 88.65,
    label: ' 88.65% ; 8,997'
},{    y: 94.01,
    label: ' 94.01% ; 8,446'
},{    y: 94.56,
    label: ' 94.56% ; 9,373'
},{    y: 100.00,
    label: ' 100.00% ; 1,023'
},{    y: 100.00,
    label: ' 100.00% ; 96'
},{    y: 80.45,
    label: ' 80.45% ; 2,502'
},{    y: 66.80,
    label: ' 66.80% ; 1,955'
},{    y: 53.23,
    label: ' 53.23% ; 695'
},{    y: 79.62,
    label: ' 79.62% ; 67,218'
}
       ]
      },{ name: 'Meta',
       type: 'spline', color: '#FF9800',
       data: [91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00,91.00],
    }]
 });
});

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.2.3/jquery.min.js"></script>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="https://blacklabel.github.io/grouped_categories/grouped-categories.js"></script>

<div id="grafico0" style="min-width: 310px; height: 400px; margin: 0 auto"></div>

What I'm looking for is to be able to remove the background of these letters:

Show those letters without the outline.

I am trying to reduce the separation between each panel, but I am not successful, I only managed to reduce the size of the panels but not the separation between them.

What I need is the best way to display all 7 panels at the same time on the screen.

If someone can help me thank you very much.

 .timeline,
 .timeline-horizontal {
   list-style: none;
   padding: 20px;
   position: relative;
 }

 .timeline:before {
   top: 40px;
   bottom: 0;
   position: absolute;
   content: " ";
   width: 3px;
   background-color: #eeeeee;
   left: 50%;
   margin-left: -1.5px;
 }

 .timeline .timeline-item {
   margin-bottom: 20px;
   position: relative;
 }

 .timeline .timeline-item:before,
 .timeline .timeline-item:after {
   content: "";
   display: table;
 }

 .timeline .timeline-item:after {
   clear: both;
 }

 .timeline .timeline-item .timeline-badge {
   color: #fff;
   width: 54px;
   height: 54px;
   line-height: 52px;
   font-size: 22px;
   text-align: center;
   position: absolute;
   top: 18px;
   left: 50%;
   margin-left: -25px;
   background-color: #7c7c7c;
   border: 3px solid #ffffff;
   z-index: 100;
   border-top-right-radius: 50%;
   border-top-left-radius: 50%;
   border-bottom-right-radius: 50%;
   border-bottom-left-radius: 50%;
 }

 .timeline .timeline-item .timeline-badge i,
 .timeline .timeline-item .timeline-badge .fa,
 .timeline .timeline-item .timeline-badge .glyphicon {
   top: 2px;
   left: 0px;
 }

 .timeline .timeline-item .timeline-badge.primary {
   background-color: #1f9eba;
 }

 .timeline .timeline-item .timeline-badge.info {
   background-color: #5bc0de;
 }

 .timeline .timeline-item .timeline-badge.success {
   background-color: #59ba1f;
 }

 .timeline .timeline-item .timeline-badge.warning {
   background-color: red;
 }

 .timeline .timeline-item .timeline-badge.danger {
   background-color: #ba1f1f;
 }

 .timeline .timeline-item .timeline-panel {
   position: relative;
   width: 46%;
   float: left;
   right: 16px;
   border: 1px solid #c0c0c0;
   background: #ffffff;
   border-radius: 2px;
   padding: 20px;
   -webkit-box-shadow: 0 1px 6px rgba(0, 0, 0, 0.175);
   box-shadow: 0 1px 6px rgba(0, 0, 0, 0.175);
 }

 .timeline .timeline-item .timeline-panel:before {
   position: absolute;
   top: 26px;
   right: -16px;
   display: inline-block;
   border-top: 16px solid transparent;
   border-left: 16px solid #c0c0c0;
   border-right: 0 solid #c0c0c0;
   border-bottom: 16px solid transparent;
   content: " ";
 }

 .timeline .timeline-item .timeline-panel .timeline-title {
   margin-top: 0;
   color: inherit;
 }

 .timeline .timeline-item .timeline-panel .timeline-body>p,
 .timeline .timeline-item .timeline-panel .timeline-body>ul {
   margin-bottom: 0;
   
 }

 .timeline .timeline-item .timeline-panel .timeline-body>p+p {
   margin-top: 5px;
   
 }

 .timeline .timeline-item:last-child:nth-child(even) {
   float: right;
 }

 .timeline .timeline-item:nth-child(even) .timeline-panel {
   float: right;
   left: 16px;
 }

 .timeline .timeline-item:nth-child(even) .timeline-panel:before {
   border-left-width: 0;
   border-right-width: 14px;
   left: -14px;
   right: auto;
 }

 .timeline-horizontal {
   list-style: none;
   position: relative;
   padding: 20px 0px 20px 0px;
   display: inline-block;
 }

 .timeline-horizontal:before {
   height: 3px;
   top: auto;
   bottom: 26px;
   left: 56px;
   right: 0;
   width: 100%;
   margin-bottom: 20px;
 }

 .timeline-horizontal .timeline-item {
   display: table-cell;
   height: 280px;
   width: 20%;
   min-width: 320px;
   float: none !important;
   padding-left: 0px;
   padding-right: 20px;
   margin: 0 auto;
   vertical-align: bottom;
 }

 .timeline-horizontal .timeline-item .timeline-panel {
   top: auto;
   bottom: 64px;
   display: inline-block;
   float: none !important;
   left: 0 !important;
   right: 0 !important;
   width: 50%;
   margin-bottom: 20px;
 }

 .timeline-horizontal .timeline-item .timeline-panel:before {
   top: auto;
   bottom: -16px;
   left: 28px !important;
   right: auto;
   border-right: 16px solid transparent !important;
   border-top: 16px solid #c0c0c0 !important;
   border-bottom: 0 solid #c0c0c0 !important;
   border-left: 16px solid transparent !important;
 }

 .timeline-horizontal .timeline-item:before,
 .timeline-horizontal .timeline-item:after {
   display: none;
 }

 .timeline-horizontal .timeline-item .timeline-badge {
   top: auto;
   bottom: 0px;
   left: 43px;
 }

<link href="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/3.3.0/js/bootstrap.min.js"></script>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
<div class="row">
  <div class="col-sm-12 col-md-12 col-lg-12">
    <div style="display: inline-block; width: 100%; overflow-y: auto;">
      <ul class="timeline timeline-horizontal">
        <li class="timeline-item">
          <div class="timeline-badge success"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title"> Vehículo</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>---</p>
            </div>
          </div>
        </li>
        <li class="timeline-item">
          <div class="timeline-badge success"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title">1</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>26039 </p>
            </div>
          </div>
        </li>
        <li class="timeline-item">
          <div class="timeline-badge success"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title"> 2</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>26037 </p>
            </div>
          </div>
        </li>
        <li class="timeline-item">
          <div class="timeline-badge success"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title">3</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>26016 </p>
            </div>
          </div>
        </li>
        <li class="timeline-item">
          <div class="timeline-badge warning"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title">4</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>---</p>
            </div>
          </div>
        </li>
        <li class="timeline-item">
          <div class="timeline-badge warning"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title">5</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>---</p>
            </div>
          </div>
        </li>
        <li class="timeline-item">
          <div class="timeline-badge warning"> <i class="glyphicon glyphicon-check"></i> </div>
          <div class="timeline-panel">
            <div class="timeline-heading">
              <h4 class="timeline-title">6</h4>
              <p>
            </div>
            <div class="timeline-body">
              <p>---</p>
            </div>
          </div>
        </li>
      </ul>
    </div>
  </div>
</div>

I'm generating a Highcharts graph, but some details I can't solve.

• The labels are confused with each other.
• The labels of the 2 red splines show them horizontally, not vertically, and only at position 0 on the left.

I should leave the graph as similar as possible to:

This is the code:

Highcharts.chart('container', {
   chart: {
     zoomType: 'x'

     // ,styledMode: true
   },
   title: {
     text: 'Indicador'
   },

   subtitle: {
     text: 'Subtitulo'
   },
   xAxis: {
     title: {
       text: 'Titulo 1'
     }
     /*,
         min: 20,
         max: 40,
         scrollbar: {
           enabled: true
         },*/

   },
   yAxis: {
     title: {
       text: 'Titulo 2'
     }
   },
   legend: {
     layout: 'vertical',
     align: 'right',
     verticalAlign: 'middle' 
   },

   plotOptions: {
     spline: {
       dataLabels: {
         enabled: true,
         formatter: function() {
           return 1;
         },
         y: -30 //separacion del indicador
       }
     },
     series: {
       label: {
         connectorAllowed: false
       },
       dataLabels: {
         enabled: true,
         formatter: function() {
           var color = '';
           var serie = this.series.name;
           if (serie == '2017-Rendimiento') {
             color = 'purple';
           } else if (serie == '2018-Rendimiento') {
             color = 'green';
           } else if (serie == '2017-RendimientoF') {
             color = 'Blue';
           } else if (serie == '2018-RendimientoF') {
             color = 'Brown';
           } else {
             if (this.x == 0) { //si posicion es 0 muestre spline con color
               color = 'red'; //color spline
             } else {
               color = 'white';
             }
           }

           return '<span style="color:' + color + '">' + this.y + '</span>';
         },
         align: 'center',
         color: 'black',
         rotation: -90
       }
       /*,
             pointStart: 2010*/

     }
   },

   series: [{
     name: '2017-Rendimiento',
     data: [275, 270, 276, 265, 271, null, 270, 271, 255, 260, 255, 262],
     color: 'purple'
   }, {
     name: '2018-Rendimiento',
     data: [260, 265, null, 270, 263, 266, 264, 264, 254, 264, 254, 264],
     color: 'green',
     lineWidth: 4
   }, {
     name: '2017-RendimientoF',
     data: [210, 222, null, 222, 220, 210, 210, 210, 223, 210, 218, 225],
     color: 'blue',
     height: 5
   }, {
     name: '2018-RendimientoF',
     data: [null, 225, 225, 225, 225, 225, 235, 245, 225, 215, 215, 229],
     color: 'brown',
     lineWidth: 4
   }, {
     type: 'spline',
     name: '2018-Meta Core',
     data: [267, 267, 267, 267, 267, 267, 267, 267, 267, 267, 267, 267],
     marker: {
       lineWidth: 2,
       lineColor: 'red',
       fillColor: 'red',
       symbol: 'circle'
     },
     color: 'red'
   }, {
     type: 'spline',
     name: '2017-Meta Core',
     data: [220, 220, 220, 220, 220, 220, 220, 220, 220, 220, 220, 220],
     marker: {
       lineWidth: 2,
       lineColor: 'red',
       fillColor: 'red',
       symbol: 'circle'
     },
     color: 'red'
   }],

   responsive: {
     rules: [{
       condition: {
         maxWidth: 500
       },
       chartOptions: {
         legend: {
           layout: 'horizontal',
           align: 'center',
           verticalAlign: 'bottom'
         }
       }
     }]
   }

 });

<script src="https://code.jquery.com/jquery-3.1.1.min.js"></script>
<script src="https://code.highcharts.com/stock/highstock.js"></script>
<script src="https://code.highcharts.com/stock/modules/exporting.js"></script>
<script src="https://code.highcharts.com/stock/modules/export-data.js"></script>
<div id="container" class="chart"></div>

I am consuming a WebService from a console application. The problem I have is when I receive the Json and try to deserialize it, it returns the error: "it is not supported for deserializing an array".

The Json structure is as follows:

[{
    "id": "19454",
    "serial1": "4634170894",
    "fecha1": "12-03-2018 00:19",
    "sis_datetime": "2018-10-26 17:17:06",
    "mileage": "None",
    "voltage": "14.804",
    "engine_operation": "1.0",
    "lat": "-90.9160305",
    "lon": "14.2409938",
    "sis_packat_zike": "820",
    "params": "{'custom1': 123.36666666661733, 'posinfo': {'c': 187, 'h': 132.46, 'lon': 14.2409938, 'sc': 10, 's': 0, 'lat': -90.9160305}, 'voltage': 14.804, 'report_type': 2, 'engine operation': 1.0, 'custom': 187.0, 'accum_9': 158, 'accum_8': 0, 'accum_3': 0, 'accum_2': 12251, 'accum_1': 4178, 'accum_0': 14804, 'accum_7': 0, 'accum_6': 0, 'accum_5': 0, 'accum_4': 0, 'event_index': 13, 'engine rpm': 1625.000000001248, 'event_code': 1, 'hdop': 1.2, 'unit_status': 0, 'host': '', 'accum_14': 0, 'seq_num': 42885, 'iridium': 0, 'rssi': -93, 'accum_15': 0, 'avl_inputs': 63, 'accum_13': 158, 'accum_12': 0, 'accum_11': 0, 'accum_10': 0}"
}]

The code is the following:

using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Web;
using System.Net;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections.Generic;
using System.Web.Script.Serialization;



namespace WsMotobombas
{
    class Program
    {
        static void Main(string[] args)
        {

            string myConnectionString = "";

            var url ="";

            using (var response = webrequest.GetResponse())
            using (var reader = new StreamReader(response.GetResponseStream()))
            {
                var result = reader.ReadToEnd();

                string jsonstring = result;

                var serializer = new JavaScriptSerializer();
                //Encabezado FldEncabezado = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<Encabezado>(jsonstring);
                Encabezado FldEncabezado = serializer.Deserialize<Encabezado>(jsonstring);
                using (SqlConnection conn = new SqlConnection(myConnectionString))
                {
                    conn.Open();

                    foreach (var Registro in FldEncabezado.Items)
                    {
                        if (InsertData(conn, Registro))
                        {
                            Console.WriteLine(Registro.serial1 + " insertado Correctamente");
                        }
                        else
                        {
                            Console.WriteLine("Error : " + Registro.serial1 + " Registr no insertado");
                        }
                    }
                }
                Console.Read();

            }
        }



        public class Registro
        {
            public int id { get; set; }
            public int serial1 { get; set; }
            public DateTime fecha1 { get; set; }
            public DateTime sis_datetime { get; set; }
            public char mileage { get; set; }
            public char voltage { get; set; }
            public char engine_operation { get; set; }
            public char lat { get; set; }
            public char lon { get; set; }
            public char sis_packat_zike { get; set; }
            public char paramsi { get; set; }
        }


        public class Encabezado
        {
            public List<Registro> Items { get; set; }

        }

        static bool InsertData(SqlConnection conn, Registro Lectura)
        {
            try
            {
                string xSql = @"INSERT INTO dbo.TblLecturas( Serial1 ,fecha1 ,sis_datetime ,mileage ,voltage ,engine_operation ,lat ,lon ,sis_packat_zike)";
                using (SqlCommand cmd = new SqlCommand(xSql, conn))
                {
                    cmd.Parameters.Add(new SqlParameter("@Serial1", Lectura.serial1));
                    //cmd.Parameters.Add(new SqlParameter("@fecha1", Lectura.fecha1));
                    //cmd.Parameters.Add(new SqlParameter("@sis_datetime", Lectura.sis_datetime));
                    //cmd.Parameters.Add(new SqlParameter("@mileage", Lectura.mileage));
                    //cmd.Parameters.Add(new SqlParameter("@voltage", Lectura.voltage));
                    //cmd.Parameters.Add(new SqlParameter("@engine_operation", Lectura.engine_operation));
                    //cmd.Parameters.Add(new SqlParameter("@lat", Lectura.lat));
                    //cmd.Parameters.Add(new SqlParameter("@lon", Lectura.lon));
                    //cmd.Parameters.Add(new SqlParameter("@sis_packat_zike", Lectura.sis_packat_zike));
                    cmd.ExecuteNonQuery();
                }
                return true;
            }
            catch (Exception e)
            {
                return false;
            }
        }
    }
}

If anyone can help me, thank you very much.

I'm trying to consume an ApiRest, but because they added token validation to it, I can't consume it. Before they added that validation, if I managed to consume it correctly.

Since the token has to be sent, I can't consume it. The error is the following:

Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'localhost:8100'; is therefore not allowed access. Le agregué los HttpHeaders –

When testing the API in postman, it works correctly.

Currently the rest.ts file is as follows:

            import { HttpClient, HttpHeaderResponse, HttpErrorResponse } from '@angular/common/http';
    import { Injectable } from '@angular/core';

    import { HttpHeaders } from '@angular/common/http';
    /*
      Generated class for the RestProvider provider.

      See https://angular.io/guide/dependency-injection for more info on providers
      and Angular DI.
    */

    @Injectable()
    export class RestProvider {
      apiUrl = 'http://localhost:49533/api/Login';

      constructor(public http: HttpClient) {
        console.log('Hello RestProvider Provider');
      }

      logIn(username: string, password: string, pasword2: string) {
        const url = 'http://localhost:49533/api/Login';
        const body = JSON.stringify({
          Codigo: username,
          Usuario: password,
          Password: pasword2
        });
        //let headers = new HttpHeaders();
        const headers = new HttpHeaders().set("X-CustomHttpHeader", "CUSTOM_VALUE")
          .set('Access-Control-Allow-Origin', '*')
          .set('Access-Control-Allow-Methods', 'POST, GET, OPTIONS, PUT')
          .set('Accept', 'application/json')
          .set('Content-Type', 'application/json; charset=utf-8');

        this.http.post(url, body, { headers: headers }).subscribe(
          (data) => {

            console.log(data);
          },
          (err: HttpErrorResponse) => {
            if (err.error instanceof Error) {
              console.log('Client-side error occured.');
            } else {
              console.log('Server-side error occured.');
            }
          }
        );
      }

      /*getUsers() {
        return new Promise(resolve => {
          this.http.get(this.apiUrl + '/api/Login/123/123/123').subscribe(data => {
            resolve(data);
            console.log(data);
          }, err => {
            console.log(err);
          });
        });
      }*/

      addUser(data) {
        return new Promise((resolve, reject) => {
          this.http.post(this.apiUrl + '/users', JSON.stringify(data))
            .subscribe(res => {
              resolve(res);
            }, (err) => {
              reject(err);
            });
        });
      }
    }

Where I call getUsers():

import { RestProvider } from '../../providers/rest/rest';
import { Component } from '@angular/core';
import { NavController } from 'ionic-angular';

@Component({
  selector: 'page-home',
  templateUrl: 'home.html'
})
export class HomePage {
  users: any;

  constructor(public navCtrl: NavController, public restProvider: RestProvider) {
    this.logIn();
    //this.getUsers();
  }
  logIn(){
    this.restProvider.logIn("1234","1234","123123")
  }

  /*getUsers() {
    this.restProvider.getUsers()
    .then(data => {
      this.users = data;
      console.log(this.users);
    });
  }*/
}

Checking out the Rest API in C#:

public class TokenValidationHandler : DelegatingHandler
    {
        private static bool TryRetrieveToken(HttpRequestMessage request, out string token)
        {
            token = null;
            IEnumerable<string> authzHeaders;
            if (!request.Headers.TryGetValues("Authorization", out authzHeaders) || authzHeaders.Count() > 1)
            {
                return false;
            }
            var bearerToken = authzHeaders.ElementAt(0);
            token = bearerToken.StartsWith("Bearer ") ? bearerToken.Substring(7) : bearerToken;
            return true;
        }
}

I checked that it carries the request.Headers.tryGetValues ​​and it carries the following:

  {Method: OPTIONS, RequestUri: 'http://localhost:49533/api/Login', Version: 1.1, Content: System.Web.Http.WebHost.HttpControllerHandler+LazyStreamContent, Headers:
    {
      Connection: keep-alive
      Accept: */*
      Accept-Encoding: gzip
      Accept-

Encoding: deflate
  Accept-Encoding: br
  Accept-Language: es-ES
  Accept-Language: es; q=0.9
  Host: localhost:49533
  User-Agent: Mozilla/5.0
  User-Agent: (Linux; Android 5.0; SM-G900P Build/LRX21T)
  User-Agent: AppleWebKit/537.36
  User-Agent: (KHTML, like Gecko)
  User-Agent: Chrome/69.0.3497.100
  User-Agent: Mobile
  User-Agent: Safari/537.36
  Access-Control-Request-Method: POST
  Origin: http://localhost:8100
  Access-Control-Request-Headers: access-control-allow-methods,access-control-allow-origin,content-type
  ApplicationInsights-RequestTrackingTelemetryModule-RootRequest-Id: 087a23b9-5473-47db-9b86-bb90f7a1cffa
}}

And from there it no longer happens in the Api rest.

The full token validation handler:

using Microsoft.IdentityModel.Tokens;
using System;
using System.Collections.Generic;
using System.IdentityModel.Tokens.Jwt;
using System.Linq;
using System.Net;
using System.Net.Http;
using System.Threading;
using System.Threading.Tasks;
using System.Web;
namespace Ws
{
    public class TokenValidationHandler : DelegatingHandler
    {
        private static bool TryRetrieveToken(HttpRequestMessage request, out string token)
        {
            token = null;
            IEnumerable<string> authzHeaders;
            if (!request.Headers.TryGetValues("Authorization", out authzHeaders) || authzHeaders.Count() > 1)
            {
                return false;
            }
            var bearerToken = authzHeaders.ElementAt(0);
            token = bearerToken.StartsWith("Bearer ") ? bearerToken.Substring(7) : bearerToken;
            return true;
        }

        protected override Task<HttpResponseMessage> SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
        {
            HttpStatusCode statusCode;
            string token;
            //determine whether a jwt exists or not
            if (!TryRetrieveToken(request, out token))
            {
                statusCode = HttpStatusCode.Unauthorized;
                //allow requests with no token - whether a action method needs an authentication can be set with the claimsauthorization attribute
                return base.SendAsync(request, cancellationToken);
            }

            try
            {
                const string sec = "401b09eab3c013d4ca54922bb802bec8fd5318192b0a75f201d8b3727429090fb337591abd3e44453b954555b7a0812e1081c39b740293f765eae731f5a65ed1";
                var now = DateTime.UtcNow;
                var securityKey = new Microsoft.IdentityModel.Tokens.SymmetricSecurityKey(System.Text.Encoding.Default.GetBytes(sec));


                SecurityToken securityToken;
                JwtSecurityTokenHandler handler = new JwtSecurityTokenHandler();
                TokenValidationParameters validationParameters = new TokenValidationParameters()
                {
                    ValidAudience = "http://localhost:49533",
                    ValidIssuer = "http://localhost:49533",
                    ValidateLifetime = true,
                    ValidateIssuerSigningKey = true,
                    LifetimeValidator = this.LifetimeValidator,
                    IssuerSigningKey = securityKey,
                    ValidateAudience = false,
                    ValidateIssuer = false

                };
                //extract and assign the user of the jwt
                Thread.CurrentPrincipal = handler.ValidateToken(token, validationParameters, out securityToken);
                HttpContext.Current.User = handler.ValidateToken(token, validationParameters, out securityToken);

                return base.SendAsync(request, cancellationToken);
            }
            catch (SecurityTokenValidationException e)
            {
                statusCode = HttpStatusCode.Unauthorized;
            }
            catch (Exception ex)
            {
                statusCode = HttpStatusCode.InternalServerError;
            }
            return Task<HttpResponseMessage>.Factory.StartNew(() => new HttpResponseMessage(statusCode) { });
        }

        public bool LifetimeValidator(DateTime? notBefore, DateTime? expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
        {
            if (expires != null)
            {
                if (DateTime.UtcNow < expires) return true;
            }
            return false;
        }
    }
}

Implementing @sioesi's help:

The ionic project runs at: http://localhost:8100/ and the rest api at http://localhost:49533/

In this case the ionic.config.json :

{
  "name": "ionic3-angular43-rest",
  "app_id": "",
  "type": "ionic-angular",
  "integrations": {},
  "proxies": [
    {
      "path": "/api", 
      "proxyUrl": "http://localhost:49533"
    }
  ]
}

and the login method:

return this.http.post('/api/api/Login', body, { headers: headers }).subscribe(
      (data) => {

        console.log(data);
      },
      (err: HttpErrorResponse) => {
        if (err.error instanceof Error) {
          console.log('Client-side error occured.');
        } else {
          console.log('Server-side error occured.');
        }
      }

With this last change, it worked correctly. Thank you very much for your help.

I am trying to make a query in SqlServer, but it does not display the desired result.

I have a table where I keep @TblLicencias licenses and another where I keep which computer I install those @TblInstalacion licenses on, increasing the correlative if that license has gone through several computers.

The problem I have is that I want to show a list of all existing licenses and next to it show the last place where it was installed, and if it was not installed, its record will appear blank, just show the license.

I've tried the following, but can't get it to work.

declare  @TblLicencias table  (
        IdLicencia int,
        Licencia varchar(10)
)

declare @TblInstalacion table (
    IdInstalacion int,
    IdLicencia int,
    Correlativo int,
    Destino varchar(10)
)

insert into @TblLicencias (IdLicencia,Licencia)values(1,'ABDCEFGHIJ') --2 instalaciones
insert into @TblLicencias (IdLicencia,Licencia)values(2,'JHSDHEGHIJ') --nunca instalada
insert into @TblLicencias (IdLicencia,Licencia)values(3,'ABDYTEGHIJ') --1 instalación

insert into @TblInstalacion (IdInstalacion,IdLicencia,Correlativo,Destino)values(1,1,1,'OFICINA 1')
insert into @TblInstalacion (IdInstalacion,IdLicencia,Correlativo,Destino)values(2,1,2,'OFICINA 2')
insert into @TblInstalacion (IdInstalacion,IdLicencia,Correlativo,Destino)values(3,3,1,'SALA 1')

--SELECT *
--FROM @TblLicencias a
--LEFT JOIN @TblInstalacion b ON a.IdLicencia = b.IdLicencia
--WHERE a.IdLicencia IN (
--      SELECT MAX(Correlativo),IdLicencia
--      FROM @TblInstalacion
--      GROUP BY IdLicencia
--      )

--SELECT *
--FROM @TblLicencias a
--LEFT JOIN @TblInstalacion b ON a.IdLicencia = b.IdLicencia
--LEFT JOIN (
--      SELECT MAX(Correlativo) as Contador
--      FROM @TblInstalacion c   
--      GROUP BY IdLicencia
--      )c on b.Correlativo=c.Contador

The correct result should be like this:

If anyone can help me. Very thankful.

I am dynamically generating a structure, which I get from a json. It has the function that clicking on the user's name will show another card in which I have 3 checkboxes.

The problem I have is that when getting the id and value of each checkbox, no matter which one I select, it only gets the value of the first generated checkbox.

If you can help me to correctly identify the id and value of each checkbox, thank you very much.

Link Jsfiddle http://jsfiddle.net/raintrooper/m8tovqbz/

var json = [{
  "Usuario": "Usuario1",
  "Instalado": false,
  "Project": false,
  "Visio": false,
  "Activo": true,
  "Ruta": "https://imgur.com/a/n2EX901",
  "Selector": "UsuarioUno"
}, {
  "Usuario": "Usuario2",
  "Instalado": false,
  "Project": false,
  "Visio": false,
  "Activo": true,
  "Ruta": "https://imgur.com/a/n2EX901",
  "Selector": "Usuario2"
}, {
  "Usuario": "Usuario3",
  "Instalado": false,
  "Project": false,
  "Visio": false,
  "Activo": true,
  "Ruta": "https://imgur.com/a/n2EX901",
  "Selector": "Usuario3"
}];




$('#btnBuscar').click(function() {
  var Usuario = '';
  var Html = '';
  $.each(json, function(i, item) {
    Html += '<div class="col s4">' +
      '<div class="card">' +
      '    <div class="card-image waves-effect waves-block waves-light">' +
      '       <img class="activator" src="' + item.Ruta + '">' +
      '    </div>' +
      '    <ul class="card-action-buttons">' +
      '        <li><a class="btn-floating waves-effect waves-light green accent-4"><i class="mdi-av-repeat">' +
      '        </i></a></li>' +
      '        <li><a class="btn-floating waves-effect waves-light red accent-2"><i class="mdi-action-favorite">' +
      '        </i></a></li>' +
      '        <li><a class="btn-floating waves-effect waves-light light-blue"><i class="mdi-action-info activator">' +
      '        </i></a></li>' +
      '    </ul>' +
      '    <div class="card-content">' +
      '        <span class="card-title activator grey-text text-darken-4">' + item.Usuario + '<i class="material-icons right">more_vert</i></span>' +
      '        <p>' +
      '            <a href="#">This is a link</a></p>' +
      '    </div>' +
      '    <div class="card-reveal">' +
      '        <span class="card-title grey-text text-darken-4">Card Title<i class="material-icons right">close</i></span>' +
      '        <p>' +
      '            Here is some more information about this product that is only revealed once clicked' +
      '            on.</p>' +

      '<p>' +
      ' <input type="checkbox" id="office-' + item.Selector + '" class="lnkOffice" />' +
      '  <label for="office-' + item.Selector + '">Office 365</label>' +
      '</p>' +
      '<p>' +
      ' <input type="checkbox" id="visio-' + item.Selector + '" class="lnkVisio" />' +
      '  <label for="visio-' + item.Selector + '">Visio</label>' +
      '</p>' +
      '<p>' +
      ' <input type="checkbox" id="project-' + item.Selector + '" class="lnkProject" />' +
      '  <label for="project-' + item.Selector + '">Project</label>' +
      '</p>' +

      '   </div>' +
      '   </div>' +
      '</div>';
  });
  $("#Estructura").append(Html);

  $('.lnkOffice').click(function() {
    //                        $('input').unbind()
    var idOffice = $("input:checkbox.lnkOffice").attr("id");
    console.log(idOffice);
    var check = $('#' + idOffice).prop('checked');
    console.log(check);
  });
  $('.lnkVisio').click(function() {
    //                        $('input').unbind()
    var idVisio = $("input:checkbox.lnkVisio").attr("id");
    console.log(idVisio);
    var check = $('#' + idVisio).prop('checked');
    console.log(check);
  });
  $('.lnkProject').click(function() {
    //                        $('input').unbind()
    var idProject = $("input:checkbox.lnkProject").attr("id");
    console.log(idProject);
    var check = $('#' + idProject).prop('checked');
    console.log(check);
  });
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
<link type="text/css" rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.6/css/materialize.min.css" media="screen,projection"></link>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/materialize/0.97.6/js/materialize.min.js"></script>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<div class="form-group">
  <a id="btnBuscar" class="btn waves-effect waves-light light-blue darken-4" type="button" value="Buscar" style="width: 100%; margin-top: 10px;" />Buscar</a>
</div>
<div class="row">
  <div id="Estructura">
  </div>
</div>

I am trying to create a structure, with 3 Json that I receive. The structure consists of Title, Subtitle and Details.

A Title can have several subtitles and a subtitle can have several details, like the following image:

Structure

For this the json bring the following data:

Json 1 Titulo:
IdPerspectiva, Perspectiva 

Json 2 Subtitulo:
IdPerspectiva, IdTipoDeIndicador,Nombre

Json 3 Detalles:
Nombre,IdTipoDeIndicador

So what I do is:

1. I generate all the Titles together with a div with the idPerspectiva

2. I generate the subtitles and with a innerHtmlreplacement the syntax of the one divgenerated in step 1, to add the subtitle, and I generate another one div, with the idTypeIndicator

3. I generate the details and innerHtmlreplace the syntax of the one divgenerated in step 2, to add the details

The problem I have is that the subtitles cannot be correctly related to the title, nor the details to the subtitle.

I don't know if using innerHtmldestroys the divone I'm adding the new syntax to.

The result is half, and in the console I can see the error:

FrmMetasDiarioEnergia.aspx:309 Uncaught TypeError: Cannot set property 'innerHTML' of null
    at Object.<anonymous> (FrmMetasDiarioEnergia.aspx:309)
    at Function.each (jquery.min.js:2)
    at Object.success (FrmMetasDiarioEnergia.aspx:294)
    at k (jquery.min.js:2)
    at Object.fireWith [as resolveWith] (jquery.min.js:2)
    at y (jquery.min.js:2)
    at XMLHttpRequest.d (jquery.min.js:2)

Structure Error

var encabezado = [{
  "IdPerspectiva": 1,
  "Nombre": "Perspectiva Financiera"
}, {
  "IdPerspectiva": 2,
  "Nombre": "Perspectiva Clientes"
}, {
  "IdPerspectiva": 3,
  "Nombre": "Perspectiva Procesos Internos"
}, {
  "IdPerspectiva": 4,
  "Nombre": "Perspectiva Aprendizaje y Crecimiento "
}];

var subtitulo = [{
  "IdTipoIndicador": 1,
  "Nombre": "Generar energía eficientemente",
  "IdPerspectiva": 1
}, {
  "IdTipoIndicador": 2,
  "Nombre": "Entregar energía a Comercialización, de buena calidad al menor costo",
  "IdPerspectiva": 1
}, {
  "IdTipoIndicador": 3,
  "Nombre": "Ejecutar los gastos alineados al presupuesto establecido",
  "IdPerspectiva": 1
}, {
  "IdTipoIndicador": 4,
  "Nombre": "Mantener un alto indicador de disponibilidad y confiabilidad en la generación de energía.",
  "IdPerspectiva": 2
}, {
  "IdTipoIndicador": 5,
  "Nombre": "Despachar según programa de venta de energía",
  "IdPerspectiva": 2
}, {
  "IdTipoIndicador": 6,
  "Nombre": "Proveer calidad de vapor a Fabrica de Azúcar para sus procesos",
  "IdPerspectiva": 2
}, {
  "IdTipoIndicador": 7,
  "Nombre": "Realizar una operación segura",
  "IdPerspectiva": 3
}, {
  "IdTipoIndicador": 8,
  "Nombre": "Mantener los equipos funcionando bajo las especificaciones técnicas",
  "IdPerspectiva": 3
}, {
  "IdTipoIndicador": 9,
  "Nombre": "Implementar una cultura de seguridad personal basada en principios y valores",
  "IdPerspectiva": 4
}, {
  "IdTipoIndicador": 10,
  "Nombre": "Registrar gestión de compras",
  "IdPerspectiva": 4
}, {
  "IdTipoIndicador": 11,
  "Nombre": "Cumplir con los requerimientos de Recurso humano para la operación",
  "IdPerspectiva": 4
}];

var detalles = [{
  "IdIndicador": 1,
  "Nombre": "Promedio Generación Bruta de KW por hora",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 2,
  "Nombre": "Promedio Generación Venta de KW por hora",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 3,
  "Nombre": "Ton de Carbón por hora",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 4,
  "Nombre": "Ton de Bagazo por hora",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 5,
  "Nombre": "KWh / Ton Carbón",
  "Calculo": "KWh Carbón / Ton Carbón",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 6,
  "Nombre": "KWh / Ton biomasa",
  "Calculo": "KWh Bagazo / Ton Bagazo",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 7,
  "Nombre": "Kw / Ton de vapor",
  "Calculo": "KWh Bruta / Ton Vapor",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 8,
  "Nombre": "Kw / Ton de agua DM ",
  "Calculo": "KWh Bruta / Ton Agua DM",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 9,
  "Nombre": "Flujo de vapor hora",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 10,
  "Nombre": "Flujo de agua de alimentación a la caldera",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 11,
  "Nombre": "BTU / Lb de carbón (Poder Calorifico)",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 12,
  "Nombre": "BTU / Lb de Biomasa (Poder Calorifico)",
  "Calculo": "",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 13,
  "Nombre": "Consumo de energía de auxiliares",
  "Calculo": "KWh Bruta - Kwh Venta",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 14,
  "Nombre": "Heat rate BTU / Kw",
  "Calculo": "[(Ton Carbón x 2204 x PoderCalorificoCarbón) + (Ton Bagazo x 2204 x PoderCalorificoBagazo)] / KWh Bruta",
  "IdTipoIndicador": 1
}, {
  "IdIndicador": 15,
  "Nombre": "Horas en línea por día",
  "Calculo": "",
  "IdTipoIndicador": 2
}, {
  "IdIndicador": 16,
  "Nombre": "Compra de energía",
  "Calculo": "",
  "IdTipoIndicador": 2
}, {
  "IdIndicador": 17,
  "Nombre": "Perdida de potencia en la línea",
  "Calculo": "(KWh Venta B4 + KWh Venta B3 - KWh Compra B4 - KWh Compra B3) - (KWh Venta PE - KWh Compra PE)",
  "IdTipoIndicador": 2
}, {
  "IdIndicador": 18,
  "Nombre": "Programa de generación Diario",
  "Calculo": "Generado / Programado * 100",
  "IdTipoIndicador": 2
}, {
  "IdIndicador": 19,
  "Nombre": "Ejecución de presupuesto Mano de Obra",
  "Calculo": "",
  "IdTipoIndicador": 3
}, {
  "IdIndicador": 20,
  "Nombre": "Ejecución de presupuesto Insumos",
  "Calculo": "",
  "IdTipoIndicador": 3
}, {
  "IdIndicador": 21,
  "Nombre": "Ejecución de presupuesto Servicios Externos",
  "Calculo": "",
  "IdTipoIndicador": 3
}, {
  "IdIndicador": 22,
  "Nombre": "Ejecución de presupuesto Servicios Internos",
  "Calculo": "",
  "IdTipoIndicador": 3
}, {
  "IdIndicador": 23,
  "Nombre": "Horas en línea por día.",
  "Calculo": "",
  "IdTipoIndicador": 4
}, {
  "IdIndicador": 24,
  "Nombre": "Programa de generación Diario.",
  "Calculo": "Generado / Programado * 100",
  "IdTipoIndicador": 5
}, {
  "IdIndicador": 25,
  "Nombre": "Flujo de vapor hora.",
  "Calculo": "",
  "IdTipoIndicador": 6
}, {
  "IdIndicador": 26,
  "Nombre": "Fatalidades",
  "Calculo": "Numero de fatalidades",
  "IdTipoIndicador": 7
}, {
  "IdIndicador": 27,
  "Nombre": "Accidentes registrados",
  "Calculo": "Numero de accidentes",
  "IdTipoIndicador": 7
}, {
  "IdIndicador": 28,
  "Nombre": "Colisiones vehiculares",
  "Calculo": "Numero de colisiones",
  "IdTipoIndicador": 7
}, {
  "IdIndicador": 29,
  "Nombre": "Suspensiones por lesiones laborales",
  "Calculo": "Suspendidos / Total de empleados * 100",
  "IdTipoIndicador": 7
}, {
  "IdIndicador": 30,
  "Nombre": "Llamadas de atención por faltas a la seguridad",
  "Calculo": "Llamadas de atención / Total de colaboradores",
  "IdTipoIndicador": 7
}, {
  "IdIndicador": 31,
  "Nombre": "Trabajos mantenimiento preventivo",
  "Calculo": "Preventivos / Total de trabajos de mantenimiento",
  "IdTipoIndicador": 8
}, {
  "IdIndicador": 32,
  "Nombre": "Trabajos mantenimiento correctivo",
  "Calculo": "Correctivos / Total de trabajos de mantenimiento",
  "IdTipoIndicador": 8
}, {
  "IdIndicador": 33,
  "Nombre": "Trabajos proyectos de mantenimiento ",
  "Calculo": "Proyectos / Total de trabajos de mantenimiento",
  "IdTipoIndicador": 8
}, {
  "IdIndicador": 34,
  "Nombre": "Llamadas de atención por faltas a la seguridad.",
  "Calculo": "Llamadas de atención / Total de colaboradores",
  "IdTipoIndicador": 9
}, {
  "IdIndicador": 35,
  "Nombre": "Horas Hombre de entrenamiento",
  "Calculo": "Horas de capacitación por colaborador / Total de colaboradores",
  "IdTipoIndicador": 9
}, {
  "IdIndicador": 36,
  "Nombre": "Ordenes de servicio realizadas",
  "Calculo": "Total de OS finalizadas",
  "IdTipoIndicador": 10
}, {
  "IdIndicador": 37,
  "Nombre": "Ordenes de compra",
  "Calculo": "Total OC Solicitadas",
  "IdTipoIndicador": 10
}, {
  "IdIndicador": 38,
  "Nombre": "Compras de emergencia .",
  "Calculo": "Total de compras por emergencia",
  "IdTipoIndicador": 10
}, {
  "IdIndicador": 39,
  "Nombre": "Horas extras por trabajos de mantenimiento",
  "Calculo": "Total de horas extras por mantenimiento",
  "IdTipoIndicador": 11
}, {
  "IdIndicador": 40,
  "Nombre": "Ausencias de personal",
  "Calculo": "Ausentes / Total de empleados en turno * 100",
  "IdTipoIndicador": 11
}, {
  "IdIndicador": 41,
  "Nombre": "Suspensiones por enfermedad",
  "Calculo": "Suspendidos / Total de empleados * 100",
  "IdTipoIndicador": 11
}, {
  "IdIndicador": 42,
  "Nombre": "Fuerza Laboral",
  "Calculo": "Cantidad de colaboradores",
  "IdTipoIndicador": 11
}];

$('#btnBuscar').click(function() {
  var html = '';
  $.each(encabezado, function(i, item) {
    html += '<div class="col-sm-6 col-md-6 col-lg-6">' +
      '<ul class="collection z-depth-2">' +
      '<li class="collection-item avatar">' +
      '<i class="material-icons circle red">play_arrow</i>' +
      '<span class="title">' + 'Perspectiva' + '</span>' +
      '<p>' +
      item.IdPerspectiva +
      '<br>' +
      'Second Line' +
      '</p>' +
      '<a href="#!" class="secondary-content"><i class="material-icons">grade</i></a>' +
      '</li>' +
      '<div id="idPerspectiva-' + item.IdPerspectiva + '" data-encabezado="' + item.IdPerspectiva + '"></div>' +
      '</ul>' +
      '</div>';
  });

  document.getElementById('Estructura').innerHTML = html;
  generarSubtitulos();
});

function generarSubtitulos() {
  $.each(subtitulo, function(i, item) {
    var htmli = '<li class="collection-item avatar"><i class="material-icons circle green">insert_chart</i>' +
      '<p>Perspectiva' +
      item.IdPerspectiva +
      '<br> Indicador ' +
      item.IdTipoIndicador +
      '</p>' +
      '<a href="#!" class="secondary-content"><i class="material-icons">play_arrow</i></a>' +
      '</li>' +
      '<div id="idTipoIndicador-' + item.IdTipoIndicador + '" data-detalles="' + item.IdTipoIndicador + '"></div>';
    var subtitulo = document.getElementById('idPerspectiva-' + item.IdPerspectiva)
    subtitulo.innerHTML = htmli;
  });
  generarDetalles();
}

function generarDetalles() {
  $.each(detalles, function(i, item) {
    var delayInMilliseconds = 1000; //1 second

    setTimeout(function() {
      //your code to be executed after 1 second
    }, delayInMilliseconds);
    var htmli2 = '<li class="collection-item avatar"><i class="material-icons circle yellow">insert_chart</i>' +
      '<p>' +
      item.Nombre +
      '<br>' +
      'Second Line' +
      '</p>' +
      '<a href="#!" class="secondary-content"><i class="material-icons">grade</i></a>' +
      '</li>';
    var detalle = document.getElementById('idTipoIndicador-' + item.IdTipoIndicador);
    detalle.innerHTML = htmli2;
  });
}

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.2.3/jquery.min.js"></script>
<link href="https://fonts.googleapis.com/icon?family=Material+Icons" rel="stylesheet">
<!-- Compiled and minified CSS -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0-rc.2/css/materialize.min.css">

<!-- Compiled and minified JavaScript -->
<script src="https://cdnjs.cloudflare.com/ajax/libs/materialize/1.0.0-rc.2/js/materialize.min.js"></script>
<div class="col-lg-3">
  <div class="form-group">
    <input id="btnBuscar" type="button" value="Buscar" style="width: 100%; margin-top:10px;" />
  </div>
</div>
<div class="col-lg-12">
  <div id="Estructura">
  </div>
</div>

I tried to fix it in several ways but I can't get it to work properly. If you could help me I would be very grateful.

As part of a Compilers job, I must program a text editor that receives the Visual Basic language as input and transforms it to another language of my choice. I am currently using Visual Basic to program the above.

The first thing I did was receive the input string and separate it into tokens, classifying them into reserved words, variables, grouping symbols, and operators.

Public Sub Procesar(Cadena As String, lstResultado As ListView, lstSimbolos As ListView)
        Try
            Dim cadenaAux As String = ""
            Dim cadenaSimbolos As String = ""
            ' Microsoft.VisualBasic.ChrW(13) se agrega este tipo de propiedad para saber cuando hay un salto de linea 
            Cadena &= Microsoft.VisualBasic.ChrW(10) & "!" 'bandera que indica si es final de texto
            Dim contador As Integer = 0

            While (Cadena.Chars(contador) <> "!")
                'verifica que exista un salto de linea para insertar token a la lista, tambien verifica que este vacio la cadena aux
                'en el textbox si funcion ay detecta la libreriade microsoft visual para el chrw13 que es la tecla intro pero en richtextbox no funciona
                'detexta al final de la cadena el chrw(13) porque se le concatena a la cadena que se evualua, de lo contrario no lo detectara. 
                If (Cadena.Chars(contador) = Microsoft.VisualBasic.ChrW(10)) AndAlso cadenaAux.Trim <> "" Then

                    Dim palabras As String() = cadenaAux.TrimStart.Split(",")
                    cadenaAux = ""
                    cadenaSimbolos = ""
                    For x As Integer = 0 To palabras.Count - 1
                        If Comparador(palabras(x), Propiedad) Then
                            cadenaAux &= " (RESERVADO) " & palabras(x)
                        ElseIf Comparador(palabras(x), Operador) Then
                            cadenaSimbolos &= " (OPERADOR) " & palabras(x)
                        ElseIf Comparador(palabras(x), Delimitador) Then
                            cadenaSimbolos &= " (DELIMITADOR) " & palabras(x)
                        ElseIf EsNumero(palabras(x)) Then
                            cadenaAux &= " (NUMERO) " & palabras(x)
                        Else
                            cadenaAux &= " (PALABRA) " & palabras(x)
                        End If
                    Next

                    Dim lst As New ListViewItem(cadenaAux)
                    lstResultado.Items.Add(lst)
                    lst = New ListViewItem(cadenaSimbolos)
                    lstSimbolos.Items.Add(lst)
                    cadenaAux = ""
                    cadenaSimbolos = ""
                End If

                'se reemplaza proceso anterior por funcion que verifica y valida el doble o triple o multiple espacios 
                cadenaAux &= GetToken(Cadena.Chars(contador))

                contador += 1
            End While
        Catch ex As Exception
            Throw
        End Try
    End Sub

Method to evaluate tokens:

'evalua la lista de token obtenidas del proceso que analiza todo el texto
    Public Sub Evalua(lstResultado As ListView, lstPropiedad As ListView, lstOperador As ListView, lstIdentificador As ListView, lstNumero As ListView, lstError As ListView)
        Try
            Dim CadenaAux As String = ""
            Dim Palabra As String = ""
            Dim contador As Integer = 0

            For x As Integer = 0 To lstResultado.Items.Count - 1

                Dim item As ListViewItem = lstResultado.Items(x)
                CadenaAux = item.SubItems(0).Text
                CadenaAux &= ",!" 'se coloca la coma antes del fin de cadena para saber que el caracter a continuacion es el fin de cadena

                'algoritmo que compara las palabras encontradas para saber en que lista insertarlas
                While CadenaAux.Chars(contador) <> "!"
                    If (CadenaAux.Chars(contador) = ",") Then
                        If Comparador(Palabra, Operador) Then
                            Dim lst As New ListViewItem(Palabra)
                            lstOperador.Items.Add(lst)
                        ElseIf Comparador(Palabra, Propiedad) Then
                            Dim lst As New ListViewItem(Palabra)
                            lstPropiedad.Items.Add(lst)
                        Else
                            'si no encuentra la palabra en las listas creadas, las evalua para saber si son identificadores o numeros. 

                            'Verifica si el primer caracter es numero con el algoritmo dado en clase si no lo manda al otro analizador de caracteres.
                            If EsNumero(Palabra.Chars(0)) Then
                                MsgBox(Palabra & "Numero ")
                                AnalizadorNumerico(Palabra, lstNumero, lstError) ' por automata
                            Else
                                MsgBox(Palabra & "Palabra ")
                                Analizador(Palabra, lstIdentificador, lstNumero, lstError)
                            End If

                        End If
                        Palabra = ""
                    Else
                        Palabra &= CadenaAux.Chars(contador)
                    End If
                    contador += 1
                End While

                'Reinicio de las variables auxiliares
                contador = 0
                Palabra = ""
                CadenaAux = ""
            Next
        Catch ex As Exception
            Throw
        End Try
    End Sub

Automata to evaluate if token is number:

Private Sub AnalizadorNumerico(Palabra As String, lstNumero As ListView, lstError As ListView)
        Dim Estado As Integer = 1
        Dim contador As Integer = 0
        Dim Analizado As Boolean = True
        Dim PalabraAux As String = Palabra & "!"

        'algoritmo de analizador lexico 
        While PalabraAux.Chars(contador) <> "!"
            Select Case Estado
                Case 1
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 2
                    Else
                        Analizado = False
                    End If
                Case 2
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 2
                    ElseIf PalabraAux.Chars(contador) = "." Then
                        Estado = 3
                    ElseIf PalabraAux.Chars(contador) = "E" Then
                        Estado = 5
                    Else
                        Analizado = False
                    End If
                Case 3
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 4
                        Analizado = True
                    Else
                        Analizado = False
                    End If
                Case 4
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 4
                        Analizado = True
                    ElseIf PalabraAux.Chars(contador) = "E" Then
                        Estado = 5
                    Else
                        Analizado = False
                    End If
                Case 5
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 7
                        Analizado = True
                    ElseIf PalabraAux.Chars(contador) = "-" Then
                        Estado = 6
                    ElseIf PalabraAux.Chars(contador) = "+" Then
                        Estado = 6
                    Else
                        Analizado = False
                    End If
                Case 6
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 7
                        Analizado = True
                    Else
                        Analizado = False
                    End If
                Case 7
                    If EsNumero(PalabraAux.Chars(contador)) Then
                        Estado = 7
                        Analizado = True
                    End If

            End Select
            contador += 1
        End While

        'evaluacion de la palabra encontrada 
        'e inserta en su lista respectiva
        'If (Estado = 4 Or Estado = 7 Or Estado = 2) And Analizado Then
        If (Estado = 4 Or Estado = 7 Or Estado = 2) And Analizado Then
            Dim lst As New ListViewItem(Palabra)
            lstNumero.Items.Add(lst)
        ElseIf Not Analizado Then
            Dim lst As New ListViewItem(Palabra)
            lstError.Items.Add(lst)
        End If
    End Sub

The tokens after being evaluated by automata I store them in ListViews, which I then show in a window.

Private Sub MnuResultado_ItemClick(sender As Object, e As DevExpress.XtraBars.ItemClickEventArgs) Handles MnuResultado.ItemClick
        Try
            Dim frm As New FrmAnalizadorLexico
            For Each item In lstReservadas.Items
                frm.lstDatos.Items.Add(item.Text)
            Next
            For Each item In lstSimbolos.Items
                frm.lstSimbolos.Items.Add(item.Text)
            Next
            frm.ShowDialog()
            frm = Nothing
        Catch ex As Exception
            cls.MensajeError(ex.Message)
        End Try
    End Sub

For this translator I don't have to do group sign validations, which check if parentheses or curly braces are missing. Only transform the obtained tokens to another language. The final language can be any.

Also it is not the whole language that I have to convert, only the structure of a For, While and If.

For example if I have:

For i = 1 To i <= 5

Next

I must convert it to:

for(int i = 1; i <= valor 5; i = i + 1)
{

}

In this case the tokens I have are: Line 1:

PalabraReservada "For" Token1
Identificador "i = 1" Token2
PalabraReservada "To" Token3
Identificador "i <= 5"  Token4

Line 2:

PalabraReservada "Next" Token5

I have tried in several ways, but I can't get the translation of the tokens to work for me.

What I need help with is if you can tell me how to make a template that receives the tokens and changes them to the new language. Please.

If anyone can help me I'd be very grateful.

I am currently starting to work with Oracle Databases and it is common to have to UPDATE from one table to another. As the databases that I have access to do not have many records, if I execute an Update with an inner join, I cannot evaluate the performance of the Update in time. But there is one Db that I understand has tables with 50,000 records or more.

So I want to be prepared so that if I have to modify the tables in question, I can execute an instruction correctly and not one that blocks the db.

The update I use regularly is like this:

UPDATE (
                SELECT Tabla1.Valor AS ValorAnterior
                    ,Tabla2.Codigo AS ValorNuevo
                FROM Tabla1
                INNER JOIN Tabla2 ON Tabla1.Valor = Tabla2.Descripcion
                WHERE Tabla1.Tipo = 1
                ) t
        SET t.ValorAnterior = t.ValorNuevo;

On the net I have seen the following instructions:

1)   UPDATE Tabla1 SET Tabla1.Valor = (SELECT Tabla2.Codigo
                                          FROM Tabla2 
                                          WHERE Tabla1.Valor = Tabla2.Descripcion)
        WHERE Tabla1.Tipo=1
        AND EXISTS (SELECT Tabla2.Codigo
                    FROM Tabla2 
                    WHERE Tabla1.Valor = Tabla2.Descripcion);

2)        MERGE INTO Tabla1 trg
        USING (
            SELECT t1.RowId AS rid
                ,t2.Codigo
            FROM Tabla1 t1
            JOIN Tabla2 t2 ON Tabla1.Valor = Tabla2.Descripcion
            WHERE Tabla1.Tipo = 1
            ) src
            ON (trg.RowId = src.rid)
        WHEN MATCHED
            THEN
                UPDATE
                SET trg.Valor = Codigo;

3)        UPDATE (
                SELECT t1.Valor
                    ,t2.Codigo
                FROM Tabla1 t1
                INNER JOIN Tabla2 t2 ON t1.Valor = t2.Descripcion
                WHERE t1.Tipo = 1
                )
        SET t1.Valor = t2.Codigo;

If someone can point me to the most efficient instruction, I am very grateful.

I am generating a TreeView with a Json, the library I am using is bootstrap-treeview.js.

The structure of the Json I receive is as follows:

 data = [{
    "Nivel": 0,
    "NombrePuesto": "Coordinador"
    }, {
    "Nivel": 1,
    "NombrePuesto": "Encargado"
    }, {
    "Nivel": 1,
    "NombrePuesto": "Jefe"
    }, {
    "Nivel": 2,
    "NombrePuesto": "Analista 1"
    }, {
    "Nivel": 2,
    "NombrePuesto": "Analista 2"
    }, {
    "Nivel": 1,
    "NombrePuesto": "Jefe de Controles"
    }, {
    "Nivel": 2,
    "NombrePuesto": "Encargado 1"
    }, {
    "Nivel": 1,
    "NombrePuesto": "Jefe de Supervision"
    }, {
    "Nivel": 2,
    "NombrePuesto": "Tecnico 1"
    }, {
    "Nivel": 3,
    "NombrePuesto": "Tecnico 2"
    }, {
    "Nivel": 4,
    "NombrePuesto": "Tecnico 3"
    }];

And I must convert the json, based on the post level to:

 var tree = [{
  text: "Coordinador",
  nodes: [{
      text: "Encargado",

    },
    {
      text: "Jefe",
      nodes: [{
          text: "Analista 1"
        },
        {
          text: "Analista 2"
        }
      ]

    },
    {
      text: "Jefe de Controles",
      nodes: [{
        text: "Encargado 1"
      }]
    },
    {
      text: "Jefe de Supervision",
      nodes: [{
          text: "Tecnico 1"
        },
        {
          text: "Tecnico 2"
        },
        {
          text: "Tecnico 3"
        }
      ]
    }
  ]
}];

I have tried to go through the Json with a $.each but I cannot generate the correct structure since I am always left with plus or minus symbols. I read that it was possible to go through the Json and push to an array depending on the type of level, but I can't do it.

The query that generates the json has the following structure:

If someone can help me thank you very much.

This is the example of what it should look like, but I filled it in by hand not with code.

data = [{
  "Nivel": 0,
  "NombrePuesto": "Coordinador"
}, {
  "Nivel": 1,
  "NombrePuesto": "Encargado"
}, {
  "Nivel": 1,
  "NombrePuesto": "Jefe"
}, {
  "Nivel": 2,
  "NombrePuesto": "Analista 1"
}, {
  "Nivel": 2,
  "NombrePuesto": "Analista 2"
}, {
  "Nivel": 1,
  "NombrePuesto": "Jefe de Controles"
}, {
  "Nivel": 2,
  "NombrePuesto": "Encargado 1"
}, {
  "Nivel": 1,
  "NombrePuesto": "Jefe de Supervision"
}, {
  "Nivel": 2,
  "NombrePuesto": "Tecnico 1"
}, {
  "Nivel": 3,
  "NombrePuesto": "Tecnico 2"
}, {
  "Nivel": 4,
  "NombrePuesto": "Tecnico 3"
}];

var tree = [{
  text: "Coordinador",
  nodes: [{
      text: "Encargado",

    },
    {
      text: "Jefe",
      nodes: [{
          text: "Analista 1"
        },
        {
          text: "Analista 2"
        }
      ]

    },
    {
      text: "Jefe de Controles",
      nodes: [{
        text: "Encargado 1"
      }]
    },
    {
      text: "Jefe de Supervision",
      nodes: [{
          text: "Tecnico 1"
        },
        {
          text: "Tecnico 2"
        },
        {
          text: "Tecnico 3"
        }
      ]
    }
  ]
}];

/*var tree = '';
$.each(data, function(i, item) {
  //console.log(item.Nivel, item.NombrePuesto);
  if (item.Nivel == 0) {
tree += '[{text: "' + item.NombrePuesto + '"';
  }
  if (item.Nivel == 1) {
tree += ', nodes: [{text: "' + item.NombrePuesto + '"}';
  }
  if (item.Nivel >= 2) {
tree += ',{text: "' + item.NombrePuesto + '"}';
  }
});

*/

function cargarTreeView() {
	$.each(data, function(i, item) {
  
  });

  var $TreeV = $('#treeview').treeview({
    data: tree
  });
}

$(document).ready(function() {
  cargarTreeView();
});

<script src="https://code.jquery.com/jquery-1.9.1.js"></script>
<script src="https://rawgit.com/jonmiles/bootstrap-treeview/master/public/js/bootstrap-treeview.js" type="text/javascript"></script>
<link rel="stylesheet" href="https://rawgit.com/jonmiles/bootstrap-treeview/master/public/css/bootstrap-treeview.css" />
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" />
<link rel="stylesheet" href="https://rawgit.com/jonmiles/bootstrap-treeview/master/public/css/bootstrap-treeview.css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js" type="text/javascript"></script>

<div class="col-sm-4">
  <div id="treeview" class="treeview">
  </div>
</div>

I am exporting a Json to csv, the problem that is happening to me is that when I run the screen in internet explorer the tab stays loading or leaves a blank screen open with the label about:blob.

The csv is downloaded correctly, except for the detail that I describe above.

I'm not sure if the error could be because I have to clean up the blob object at the end of the statement.

If anyone can help me thank you very much.

var json = [{
  "CentroDeCosto": "4604878  ",
  "NombreCentroDeCosto": "Cabezal M/kenworth ",
  "Fecha": "03/04/2018",
  "Ubicacion": "Servicio Rapido",
  "Latitud": 0,
  "Longitud": 0
}, {
  "CentroDeCosto": "4604878  ",
  "NombreCentroDeCosto": "Cabezal M/kenworth ",
  "Fecha": "03/04/2018",
  "Ubicacion": "Servicio Rapido",
  "Latitud": 0,
  "Longitud": 0
}, {
  "CentroDeCosto": "4604878  ",
  "NombreCentroDeCosto": "Cabezal M/kenworth ",
  "Fecha": "03/04/2018",
  "Ubicacion": "Servicio Rapido",
  "Latitud": 0,
  "Longitud": 0
}];

jsonExportarExcel(json, "Pruebas", true)

function jsonExportarExcel(data, tituloDelReporte, ShowLabel) {
  var arrData = typeof data != 'object' ? JSON.parse(data) : data;

  var CSV = '';

  CSV += tituloDelReporte + '\r\n\n';

  if (ShowLabel) {
    var row = "";

    //This loop will extract the label from 1st index of on array
    for (var index in arrData[0]) {

      //Now convert each value to string and comma-seprated
      row += index + ',';
    }

    row = row.slice(0, -1);
    //append Label row with line break
    CSV += row + '\r\n';
  }

  //1st loop is to extract each row
  for (var i = 0; i < arrData.length; i++) {
    var row = "";

    //2nd loop will extract each column and convert it in string comma-seprated
    for (var index in arrData[i]) {
      row += '"' + arrData[i][index] + '",';
    }

    row.slice(0, row.length - 1);
    //add a line break after each row
    CSV += row + '\r\n';
  }

  if (CSV == '') {
    alert("Invalid data");
    return;
  }

  //Generate a file name
  var fileName = "MyReport_";
  //this will remove the blank-spaces from the title and replace it with an underscore
  fileName += tituloDelReporte.replace(/ /g, "_");

  if ((navigator.userAgent.indexOf("MSIE") != -1) || (!!document.documentMode == true)) //IF IE > 10
  {
    var a = document.createElement('a'),
      file = new Blob([CSV], {
        type: 'text/csv;charset=utf-8,%EF%BB%BF'
      });

    window.navigator.msSaveBlob(file, fileName + ".csv");

    a.href = URL.createObjectURL(file), a.download = fileName + ".csv";
    document.body.appendChild(a);
    a.click();
    document.body.removeChild(a);
  } else {
    var uri = 'data:text/csv;charset=utf-8,' + escape(CSV);

    //this trick will generate a temp <a /> tag
    var link = document.createElement("a");
    link.href = uri;

    //set the visibility hidden so it will not effect on your web-layout
    link.style = "visibility:hidden";
    link.download = fileName + ".csv";

    //this part will append the anchor tag and remove it after automatic click
    document.body.appendChild(link);
    link.click();
    document.body.removeChild(link);
    //Finaliza exportar en chrome
  }
}

I am trying to add a label or legend to the chart so I can display it in the center of the chart all the way to the top.

This label must carry the value of the Legend variable.

If you can help me thank you very much.

var Cuota=2000;
var CuotaGrupo=1500; 
var San=200; 
var Tavil=700;
var Otros=100; 
var Frente='Frente';
var Leyenda = 4000;      
      var contador = 0;
	    var contador2 = 0;
	    var arreglo = [];
	    Highcharts.chart('subcontainer', {
		    chart: {
			    type: 'column'
		    },
		    title: {
			    text: 'Ingreso  ' + Frente
		    },
		    subtitle: {
			    text: 'Subtitulo'
		    },
		    xAxis: {
			    categories: [Frente,  ],
			    crosshair: true
		    },
		    yAxis: {
			    min: 0,
			    title: {
				    text: 'TN '
			    }
		    },
		    tooltip: {
			    headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
			    pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' + '<td style="padding:0"><b>{point.y:.1f} tons</b></td></tr>',
			    footerFormat: '</table>',
			    shared: true,
			    useHTML: true
		    },
		    plotOptions: {
			    column: {
				    pointPadding: 0.2,
				    borderWidth: 0,
				    dataLabels: {
					    enabled: true,
				    }
			    }
		    },
		    legend: {
 
			    layout: 'vertical',
			    align: 'right',
			    verticalAlign: 'top',
			    x: -40,
			    y: 80,
			    floating: true,
			    borderWidth: 1,
			    backgroundColor: ((Highcharts.theme && Highcharts.theme.legendBackgroundColor) || '#FFFFFF'),
			    shadow: true
		    },
		    credits: {
			    enabled: false
		    },
		    series: [{
			    name: 'Cuota',
			    data: [Cuota]
		    }, {
			    name: 'CuotaGrupo',
			    data: [CuotaGrupo]
		    }, {
			    name: 'San',
			    data: [San]
		    }
            , {
			    name: 'Tavil',
			    data: [Tavil]
		    }
            , {
			    name: 'Otros',
			    data: [Otros]
		    }]
	    });

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>

<div id="subcontainer" style="min-width: 310px; height: 400px; margin: 0 auto"></div>

I am trying to change the color of the label of the third column of each segment in the graph, the problem I have is that I cannot do it based on the value of the first column against the third.

The first segment says Front 01 and the goal column is in light blue, the hourly quota column is green, and the quota column is black.

If the goal column is 2,650 and the third one, which is the quota, is equivalent to 80% to 100% of those 2,650, the label must be blue, if the percentage is between 20% to 79% orange and 19% to 0% in red.

In the snippet in the first segment the odd has the value of 2300.96 so it should be blue, in the second the odd has a value of 112 against 2300 which should be red.

Thank you very much for your help.

Highcharts.chart('container', {
chart: {
	type: 'column'
},
title: {
	text: 'Cuota de Ingreso de Caña Por Frente'
},
subtitle: {
	text: 'Subtitulo'
},
xAxis: {
	categories: ['Frente 01', 'Frente 02', 'Frente 03', 'Frente 04', 'Frente 07', 'Frente 11', ],
	crosshair: true
},
yAxis: {
	min: 0,
	title: {
		text: 'TN DE CAÑA INGRESADA'
	}
},
tooltip: {
	headerFormat: '<span style="font-size:10px">{point.key}</span><table>',
	pointFormat: '<tr><td style="color:{series.color};padding:0">{series.name}: </td>' + '<td style="padding:0"><b>{point.y:.1f} tons</b></td></tr>',
	footerFormat: '</table>',
	shared: true,
	useHTML: true
},
plotOptions: {
	column: {
		pointPadding: 0.2,
		borderWidth: 0,
		dataLabels: {
			enabled: true,
			color: 'blue'
		}
	}
},
legend: {
	layout: 'vertical',
	align: 'right',
	verticalAlign: 'top',
	x: -40,
	y: 80,
	floating: true,
	borderWidth: 1,
	backgroundColor: ((Highcharts.theme && Highcharts.theme.legendBackgroundColor) || '#FFFFFF'),
	shadow: true
},
credits: {
	enabled: false
},
series: [{
	name: 'Meta del Día',
	data: [2650.00, 2300.00, 900.00, 1800.00, 1300.00, 1400.00]
}, {
	name: 'Cuota Por Hora',
	data: [220.83, 191.67, 75.00, 150.00, 108.33, 116.67]
}, {
	name: 'Cuota Ingresada',
	data: [2300.96, 112.94, 96.20, 0.00, 133.99, 222.11]
}]
});

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>

<div id="container" style="min-width: 310px; height: 400px; margin: 0 auto"></div>

Good morning, I am trying to show a percentage of Irrigation on a map. I have tried in several ways, for example:

-Show a 50% polygon over an original 100% polygon It didn't work because by sending only 50% of the array coordinates to display, the superimposed polygon is not symmetrical.

In this case, the green polygon is the overlay.

-Show a label on the polygon. It works but we did not like how it turned out.

-Show a graph when clicking on the polygon. They didn't use it because it was too many clicks to go from graph to graph.

-Change color or opacity of the polygon fill.

I would like to be able to return to the first option of showing an overlay polygon according to the irrigation progress.

If anyone could help me with that, I'd be very grateful.

var map;
var infoWindow;
var avanceRiego=50;

function initMap() {
  map = new google.maps.Map(document.getElementById('map'), {
    zoom: 18,
    center: {lat: 13.866291, lng: -90.204114},
    mapTypeId: 'terrain'
  });

  var coordenadas = [
      {lat: 13.866291, lng: -90.204114},
      {lat: 13.866325, lng: -90.204115},
      {lat: 13.866325, lng: -90.204115},
      {lat: 13.866365, lng: -90.20413},
      {lat: 13.86639,  lng: -90.20416},
      {lat: 13.86639,  lng: -90.20416},
      {lat: 13.866434, lng: -90.204177}, 
      {lat: 13.866457, lng: -90.204189}, 
      {lat: 13.866457, lng: -90.204189},
      {lat: 13.866494, lng: -90.204192},
      {lat: 13.866512, lng: -90.204298},
      {lat: 13.866507, lng: -90.204353},
      {lat: 13.866479, lng: -90.204402},
      {lat: 13.866479, lng: -90.204402},
      {lat: 13.86642,  lng: -90.204426},
      {lat: 13.86642,  lng: -90.204426},
      {lat: 13.86642,  lng: -90.204426},
      {lat: 13.866385, lng: -90.204396},
      {lat: 13.86636,  lng: -90.204366},
      {lat: 13.866353, lng: -90.204334},
      {lat: 13.866324, lng: -90.20429},
      {lat: 13.866303, lng: -90.204236},
      {lat: 13.866293, lng: -90.204177},
      {lat: 13.866282, lng: -90.20415},
      {lat: 13.866282, lng: -90.20415},
      {lat: 13.866291, lng: -90.204114}
  ];
  var poligono = new google.maps.Polygon({
    paths: coordenadas,
    strokeColor: '#FF0000',
    strokeOpacity: 0.8,
    strokeWeight: 3,
    fillColor: '#FF0000',
    fillOpacity: 0.35
  });
  poligono.setMap(map);
}

/* Always set the map height explicitly to define the size of the div
 * element that contains the map. */
#map {
  height: 100%;
}
/* Optional: Makes the sample page fill the window. */
html, body {
  height: 100%;
  margin: 0;
  padding: 0;
}

<div id="map"></div>
 <!-- Replace the value of the key parameter with your own API key. -->

<script src="https://maps.googleapis.com/maps/api/js?key=AIzaSyCK3ulYYM8GCwK-_HlZVNKvkgp-zvEebUM&callback=initMap" async defer></script>

I need to show markers on a map, only if they are within the radius of the circle shown on the screen. But I don't know how to validate whether or not the marker is within the radius.

var myLatLng = { lat: 14.151171, lng: -90.841083 };
var myLatLng2 = { lat: 14.15009000, lng: -90.84334708 };

function initMap() {

    var map = new google.maps.Map(document.getElementById('map'), {
      zoom: 4,
      center: myLatLng,
      mapTypeId: 'terrain',
      zoom: 18
    });
  
    var markerYesShow = new google.maps.Marker({
      position: myLatLng,
      map: map,
      title: 'Yes Show Into Radio'
    });
    
    var markerNotShow = new google.maps.Marker({
      position: myLatLng2,
      map: map,
      title: 'Not Show '
    });
  
    var alerta = new google.maps.Circle({
      strokeColor: '#FF0000',
      strokeOpacity: 0.8,
      strokeWeight: 2,
      fillColor: '#FF0000',
      fillOpacity: 0.35,
      map: map,
      center: myLatLng,
      radius: 100
    });
}

/* Always set the map height explicitly to define the size of the div
 * element that contains the map. */
#map {
  height: 100%;
}
/* Optional: Makes the sample page fill the window. */
html, body {
  height: 100%;
  margin: 0;
  padding: 0;
}

<div id="map"></div>
 <!-- Replace the value of the key parameter with your own API key. -->
<script async defer
src="https://maps.googleapis.com/maps/api/js??key=AIzaSyCkUOdZ5y7hMm0yrcCQoCvLwzdM6M8s5qk&callback=initMap">
</script>

Good morning, I have the following coordinates:

-90.833910,13.994037 -90.833918,13.994095 -90.833924,13.994152 -90.833930,13.994207 -90.833936,13.994263 -90.833943,13.994322 -90.833951,13.994382 -90.833959,13.994440 -90.833965,13.994494 -90.833971,13.994548 -90.833978,13.994608 -90.833984,13.994671 -90.833993 ,13.994741 -90.834001,13.994811 -90.834010,13.994877 -90.834019,13.994940 -90.834028,13.995003 -90.834036,13.995060 -90.834044,13.995110 -90.834052,13.995162 -90.834061,13.995222 -90.834067,13.995281 -90.834074,13.995336 -90.834080,13.995390 -90.834086,13.995442 -90.834092,13.995495 -90.834100,13.995553 -90.834105,13.995610 -90.834110,13.995665 -90.834116,13.995718 -90.834122,13.995769 -90.834127,13.995820 -90.834134,13.995871 -90.834141,13.995924 -90.834146,13.995974 -90.834149,13.996008 -90.834192,13.996161 -90.834732 .13.996091 -90.835519.13.995989 -90.836038.13.995931 -90.836696.13.995846 -90.836677,13.995819 -90.836660,13.995674 -90.836610,13.995123 -90.836480,13.994146 -90.836461,13.994126 -90.836370,13.994036 -90.836287,13.994044 -90.836194,13.994035 -90.836012,13.993789 -90.836003,13.993753 -90.835995,13.993581 -90.836245,13.993529 - 90.836375,13.993521 -90.836386,13.993516 -90.836394,13.993512 -90.836394,13.993503 -90.836395,13.993404 -90.836309,13.992635 -90.836266,13.992318 -90.836207,13.991926 -90.836192,13.991927 -90.836170,13.991932 -90.836125,13.991938 -90.836074,13.991943 -90.836010, 13.991951 -90.835936,13.991961 -90.835862,13.991968 -90.835791,13.991976 -90.835722,13.991980 -90.835658,13.991985 -90.835597,13.991994 -90.835533,13.992003 -90.835471,13.992011 -90.835408,13.992018 -90.835346,13.992025 -90.835285,13.992033 -90.835228,13.992040 - 90.835173,13.992045 -90.835118,13.992051 -90.835062,13.992057 -90.835002,13.992063 -90.834936,13.992071 -90.834868,13.992078 -90.834800,13.992086 -90.834733,13.992094 -90.834663,13.992102 -90.834588,13.992111 -90.834523,13.992120 -90.834474,13.992123 -90.834421,13.992129 -90.834361,13.992133 -90.834298,13.992140 -90.834229,13.992149 - 90.834160,13.992161 -90.834092,13.992171 -90.834022,13.992180 -90.833954,13.992185 -90.833889,13.992191 -90.833824,13.992198 -90.833761,13.992205 -90.833709,13.992212 -90.833680,13.992216 -90.833683,13.992242 -90.833693,13.992300 -90.833704,13.992370 -90.833712, 13.992445 -90.833720,13.992518 -90.833727,13.992591 -90.833736,13.992661 -90.833745,13.992730 -90.833755,13.992795 -90.833764,13.992855 -90.833772,13.992913 -90.833779,13.992971 -90.833786,13.993033 -90.833792,13.993092 -90.833799,13.993149 -90.833807,13.993202 - 90.833815,13.993251 -90.833823,13.993302 -90.833830,13.993358 -90.833837,13.993410 -90.833843,13.993462 -90.833849,13.993518 -90.833857,13.993579 -90.833864,13.993641 -90.833870,13.993700 -90.833876,13.993760 -90.833881,13.993817 -90.833887,13.993871 -90.833894,13.993927 -90.833902,13.993982 -90.833910,13.994037

These coordinates come from a kml and I am interested in knowing if with them I can draw a polygon on the map maintaining the current format of the coordinates, since if not, I would have to separate thousands of coordinates to use the following format:

var triangleCoords = [
          {lat: 25.774, lng: -80.190},
          {lat: 18.466, lng: -66.118},
          {lat: 32.321, lng: -64.757}
        ];

Also, if possible, how can I get a central coordinate based on that set of coordinates?

Thank you very much for your help.

With the help of Marcos I was able to create the polygons. XD

I have the code like this:

    function errores(msg) {
        alert('Error: ' + msg.responseText);
    }

    var bmap;
    function initMaps(flag) {
        if (flag == 1) {
            var myLatLng = { lat: 13.84392970, lng: -90.25855230 };
            var bmap = new google.maps.Map(document.getElementById('bmap'), {
                zoom: 14,
                center: myLatLng,
                mapTypeId: 'satellite'
            });

            var bounds = new google.maps.LatLngBounds();

            function addMarker(feature, finca, coordenadas) {
                //inicia crear poligono
                var coords = coordenadas.split(' ') // Separamos por espacio
                        .map(function (data) {
                            var info = data.split(','), // Separamos por coma
                        coord = { // Creamos el obj de coordenada
                            lat: parseFloat(info[1]),
                            lng: parseFloat(info[0])
                        };
                            // Agregamos la coordenada al bounds
                            bounds.extend(coord);
                            return coord;
                        });

                var area = new google.maps.Polygon({
                    paths: coords,
                    strokeColor: '#FF0000',
                    strokeOpacity: 0.8,
                    strokeWeight: 3,
                    fillColor: '#BBDEFB',
                    fillOpacity: 0.35
                });

                area.setMap(bmap); // agrega el poligono al mapa
                // finaliza crear poligono

                var markers = new google.maps.Marker({
                    position: bounds.getCenter(),
                    map: bmap,
                    title: 'Finca: ' + finca
                });

                //inicia infowindow
                // Add a listener for the click event.
                area.addListener('click', showArrays);
                var infoWindow = new google.maps.InfoWindow;
                // finaliza infowindow
                //------------------------------------
                function showArrays(event) {
                    // Since this polygon has only one path, we can call getPath() to return the
                    // MVCArray of LatLngs.
                    var vertices = this.getPath();

                    var contentString = '<b>Bermuda Triangle polygon</b><br>' +
                      'Clicked location: <br>' + event.latLng.lat() + ',' + event.latLng.lng() +
                      '<br>';

                    // Iterate over the vertices.
                    for (var i = 0; i < vertices.getLength(); i++) {
                        var xy = vertices.getAt(i);
                        contentString += '<br>' + 'Coordinate ' + i + ':<br>' + xy.lat() + ',' +
                        xy.lng();
                    }

                    // Replace the info window's content and position.
                    infoWindow.setContent(contentString);
                    infoWindow.setPosition(event.latLng);

                    infoWindow.open(bmap);
                }
                //------------------------------------


                bmap.fitBounds(bounds); // ajusta el mapa a la cantidad de marcadores
                //                    //finaliza crear marcador

            } // finaliza addMarker

            var FechaInicial = $('#<%= txtFechaInicial.ClientID %>').val();
            var FechaFinal = $('#<%= txtFechaFinal.ClientID %>').val();
            var Finca = $('#<%= CboFincass.ClientID %>').val();

            $.ajax({
                type: "POST",
                url: "FrmKmlFincas.aspx\/FillMapas",
                data: '{FechaInicial: "' + FechaInicial + '", FechaFinal: "' + FechaFinal + '", Finca: "' + Finca + '"}',
                contentType: "application/json; charset=utf-8",
                dataType: "json",
                success: function (msg) {
                    var data = JSON.parse(msg.d);
                    marcadores = [];
                    finca = [];
                    coordenadas = [];
                    $.each(data, function (i, item) {
                        marcadores[i] = new google.maps.LatLng(item.Latitud, item.Longitud);
                        finca[i] = item.Finca;
                        coordenadas[i] = item.Coordenadas;
                        addMarker(marcadores[i], finca[i], coordenadas[i]); //enviar finca,descricion, etc
                    });
                },
                error: errores
            });
        } else {
            // alert("1");
            var myLatLng = { lat: 14.151171, lng: -90.841083 };
            var bmap = new google.maps.Map(document.getElementById('bmap'), {
                zoom: 14,
                center: myLatLng,
                mapTypeId: 'satellite'
            });

            var marker = new google.maps.Marker({
                position: myLatLng,
                map: bmap,
                title: 'Hello World!'
            });
        }
    }

The problem I have is that the first marker that is created is centered with respect to the polygon, but from the second it is no longer. I don't know if I should clean some variable. Thank you very much for your help.