vdjkelly's questions

The title is a bit confusing but what I want to get to is the following with this code:

$hrs=['2021/08/11 08:00:00 AM','2021/08/11 08:00:00 PM'];
$fecha1 = DateTime::createFromFormat('Y/m/d h:i:s A', $hrs[0]);
$fecha2 = DateTime::createFromFormat('Y/m/d h:i:s A', $hrs[1]);
$interval = $fecha1->diff($fecha2);
$divideBy=20;

$minutes= "PT".($interval->h / $divideBy * 60)."M";
$period = new DatePeriod($fecha1, new DateInterval($minutes), $fecha2);
foreach ($period as $dt) {
    echo $dt->format("H:i:s \n");
}

which I get a time range

• 08:00:00

• 08:36:00

• 09:12:00

• 09:48:00

• 10:24:00

• 11:00:00

• 11:36:00

• 12:12:00

• 12:48:00

• 13:24:00

• 14:00:00

• 14:36:00

• 15:12:00

• 15:48:00

• 16:24:00

• 17:00:00

• 17:36:00

• 18:12:00

• 18:48:00

• 19:24:00

From this range, I want to exclude the break time. For example, if the break time is at 2:00 p.m. , I want to exclude 2:00 p.m. and 2:36 p.m. from that list.

As I indicate in the title I need to be able to import a cvs but there are certain parameters that are obtained from a form in which I cannot recover when said file is imported, these fields come from the aforementioned and I pass them as variables in the construct of the class from the importer I leave the code and tell me what I am doing wrong since these parameters always pass as null

controller

(new MayorImport($request->input('cliente_id'), $request->input('soft_contable')))->queue($file, 'public');

Note: The file is uploaded and runs in the background so I think the request doesn't work when starting the commandphp artisan queue:work

<?php

namespace App\Imports;

use App\CuentaContabilidad;
use App\Mayor;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Support\Facades\Session;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\WithChunkReading;
use Maatwebsite\Excel\Concerns\WithCustomCsvSettings;
use Maatwebsite\Excel\Concerns\WithHeadingRow;

class MayorImport implements ToModel, WithHeadingRow, WithCustomCsvSettings, WithChunkReading, ShouldQueue
{
    use Importable;

    protected $cliente_id;
    protected $soft_contable;

    public function __construct($cliente_id, $soft_contable)
    {
        $this->cliente_id = $cliente_id;
        $this->soft_contable = $soft_contable;
    }

    /**
     * @param array $row
     *
     * @return \Illuminate\Database\Eloquent\Model|null
     */
    public function model(array $row)
    {
        if (!CuentaContabilidad::where('codigo', $row['cuenta'])->where('cliente_id', $this->cliente_id)->exists()) {
            $centro_costo = CuentaContabilidad::create([
                'rut_cliente' => $row['rut_empresa'],
                'cliente_id' => $this->cliente_id,
                'codigo' => $row['cuenta'],
                'soft_contable' => Session::get('soft_contable'),
                'nombre' => $row['nombre'],
            ]);
            return new Mayor([
                'cliente_id' => Session::get('cliente_id'),
                'periodo' => $row['periodo'],
                'cuenta_id' => $centro_costo->id,
                'comp_nro' => $row['comprobante'],
                'comp_tipo' => $row['tipo'],
                'valor_cargo' => $row['debe'],
                'valor_abono' => $row['haber'],
                'cc_nom' => $row['centro_costo'],
                'rut' => $row['rut'],
            ]);

        }

    }

    public function chunkSize(): int
    {
        return 1000;
    }

    public function getCsvSettings(): array
    {
        return [
            'delimiter' => ";",
        ];
    }
}

When doing dd($this->cliente_id)this it returns a null in the console

[2021-09-22 01:04:09][2] Processing: Maatwebsite\Excel\Jobs\ReadChunk
null

I need help from someone who can kindly lend me a hand, since I need to optimize a Laravel query with Eloquent or QueryBuilder , for which I asked you tried so much that I no longer knew what it does and leave the code as it was. Here I show them to you. Said query causes the server to crash and take very high peaks of consumption, in advance I would appreciate your help

$query = "SELECT a.id, cc.codigo, cc.nombre, a.unidad_medida_id, um.nombre as tipo_cambio, a.descripcion,
                        (SELECT count(adx1.id)
                            FROM `amortizacion` ax1
                                inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                              and adx1.archivada = 0
                                and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                                and adx1.fecha_vencimiento > '$fecha_corte' and adx1.fecha_vencimiento <='$fecha_12_meses'
                        ) +  (SELECT count(adx1.id)
                            FROM `amortizacion` ax1
                                inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                              and adx1.pago_monto = 0
                                and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                                and adx1.fecha_vencimiento <= '$fecha_corte'
                        ) AS cuotas,
                        b.nombre as banco,
                        t.nombre as tipo,
                        (SELECT sum(adx1.capital)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                                and adx1.archivada = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.fecha_vencimiento > '$fecha_corte' and adx1.fecha_vencimiento <='$fecha_12_meses'
                        ) +  COALESCE((SELECT sum(adx1.capital)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                              and adx1.pago_monto = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                           and adx1.fecha_vencimiento <= '$fecha_corte'
                        ),0) AS capital,
                        (SELECT sum(adx1.intereses)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                               and adx1.archivada = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.fecha_vencimiento > '$fecha_corte' and adx1.fecha_vencimiento <='$fecha_12_meses'
                        ) +  COALESCE((SELECT sum(adx1.intereses)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.pago_monto = 0
                            and adx1.fecha_vencimiento <= '$fecha_corte'
                        ),0) AS intereses,
                        (SELECT sum(adx1.iva)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                              and adx1.archivada = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.fecha_vencimiento > '$fecha_corte' and adx1.fecha_vencimiento <='$fecha_12_meses'
                        ) + COALESCE((SELECT sum(adx1.iva)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                               and adx1.pago_monto = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.fecha_vencimiento <= '$fecha_corte'
                        ),0) AS iva,
                        (SELECT sum(adx1.comision)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                              and adx1.archivada = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.fecha_vencimiento > '$fecha_corte' and adx1.fecha_vencimiento <='$fecha_12_meses'
                        ) + COALESCE((SELECT sum(adx1.comision)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                              and adx1.pago_monto = 0
                           and adx1.fecha_vencimiento <= '$fecha_corte'
                        ), 0)  AS comision,
                        (SELECT  sum(adx1.valor_cuota)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                              and adx1.archivada = 0
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.fecha_vencimiento > '$fecha_corte' and adx1.fecha_vencimiento <='$fecha_12_meses'
                        ) + COALESCE((SELECT  sum(adx1.valor_cuota)
                            FROM `amortizacion` ax1
                            inner join  amortizacion_detalle adx1 on adx1.amortizacion_id = ax1.id
                            WHERE ax1.cliente_id=$cliente_id
                            and ax1.cuenta_corto_plazo=$cuenta_corto_plazo->cuenta_corto_plazo
                            and adx1.pago_monto = 0
                           and adx1.fecha_vencimiento <= '$fecha_corte'
                        ),0) AS cuota_a_pago
                    FROM `amortizacion` a
                        INNER JOIN `amortizacion_detalle` ad ON ad.amortizacion_id = a.id
                        inner join entidads b on b.id = a.entidad_id
                        inner join tipo_operacions t on t.id = a.tipo_operacion_id
                        inner join unidad_medidas um on um.id = a.unidad_medida_id
                        inner join cuentas_contabilidad cc on cc.codigo=a.cuenta_corto_plazo and cc.cliente_id = a.cliente_id
                    WHERE a.cliente_id = $cliente_id
                        AND a.cuenta_corto_plazo = $cuenta_codigo
                    group by a.id, cc.codigo, cc.nombre, a.unidad_medida_id, um.nombre, a.descripcion";
        
            $encabezado = DB::select( DB::raw($query) );

I am using vue and vuex where i get the image of a profile in this way i use quasa

I need to be able to update the image since it contains one that was previously loaded, I can't do it since the browser seems to have it loaded and caches it.

Note:

cropSuccess

It is the method in charge of uploading the image

<q-item-section avatar>
                        <q-avatar
                            size="80px"
                            color=""
                            text-color="white"
                            class="shadow-2 bg-deep-orange-2"
                        >
                            <q-img
                                ref="logos"
                                :src="logo"
                                spinner-color="white"
                                style="min-height: 80px"
                            >
                                <template v-slot:error>
                                    <div
                                        class="absolute-full flex flex-center"
                                        style="background-color: #cccc"
                                    >
                                        <q-avatar
                                            color="grey"
                                            text-color="white"
                                            icon="image"
                                        />
                                    </div>
                                </template>
                            </q-img>
                        </q-avatar>
                    </q-item-section>

export default {
   computed: {
        logo() {
            return (
                `/storage/business/${this.business.business_id}/logo_${this.business.business_id}.png`
            );
        },
   },
   methods: {
       cropSuccess(data, field, key) {
            this.$store.commit("auth/CHANGELOGO", data);
                this.$store.state.simulator.refresh++;
            
        },
   }


}

I need the total column ascending or descending that I get from the subtotalRow method where I get the total per row according to the filter

    <table class="table card-table table-vcenter text-nowrap table-hover">
    
                        <thead>
    
                        <tr>
                            <th style="background-color: white">Razón Social</th>
                            <template v-for="(row, key) in filterLista">
                                <template v-for="(meses, ano) in row">
                                    <template v-for="(total_mes, mes) in meses">
                                        <th style="background-color: white">{{ printMonth(mes) }}  {{ ano  }}</th>
                                    </template>
                                </template>
                            </template>
                            <th style="background-color: white" @click="sortedList">Totales</th>
                        </tr>
    
                        </thead>
    
                        <tbody>
                        <template v-for="(raz_soc, rut) in entidades">
                            <tr>
                                <td style="background-color: white">{{ printName(rut) }}</td>
                                <template v-for="row in sortedList">
                                    <template v-for="(meses, ano) in row">
                                        <template v-for="(total_mes, mes) in meses">
                                            <td v-if="pendientes[ano][mes]">{{  total_mes[rut] ? Intl.NumberFormat('es-ES').format(total_mes[rut]) : 0 }}</td>
                                        </template>
                                    </template>
                                </template>
                           
                                <td>{{ subtotalRow(rut) }}</td>
                            </tr>
                        </template>
    
                        </tbody>
    
                        <tfoot>
                        <tr>
                            <td style="background-color: #f5f5f5"></td>
    
    
                        </tr>
                        </tfoot>
    
                    </table>



new Vue({
    el: '#app',
    data() {
        return {
            totalMensual: {
                2017: { 8: { 99526550: 8402118 }, 12: { 99526550: 16805365 } },
        2018: {
          1: { 99526550: 3380427 },
          2: { 99526550: 3383808 },
          6: { 76467560: 1450000 },
          7: { 76675405: 1741365 },
          8: { 76675405: 11577539 },
          9: { 96777810: 2588845 },
          10: { 76898325: 3000000 },
          12: { 76035258: 14868336 }
        },
        2019: {
          2: { 76035258: 1594755 },
          3: { 76675405: 11707602 },
          5: { 79587210: 9460500 },
          9: { 10836904: 6080000 },
          10: { 76849049: 11900000 },
          11: { 76914652: 18216520 },
          12: { 76122571: 9779550 }
        },
        2020: {
          2: { 76122564: 658878, 76675405: 784312 },
          3: { 76122571: 6746300, 77418580: 37901500 },
          4: { 76860599: 12288093 },
          8: { 76122571: 3519040, 76829879: 8986547, 76985375: 7139000 },
          11: { 76833156: 0, 79587210: -342845469, 96935140: 0 },
          12: {
            76131794: 99960000,
            76833156: 43282120,
            77078359: 54621000,
            77241295: 110610500,
            77612130: 53818420,
            79587210: 534178302,
            92176000: 6156500,
            96935140: 7812350
          }
        }
            },
            filterLista: [],
        }
    },
    mounted() {
        this.filterLista = Object.entries(this.totalMensual).map(([key, value]) => ({
            [key]: value
        }))
    },
    computed: {
        sortedList() {
            return this.filterLista.sort((a, b) => Object.keys(a)[0] - Object.keys(b)[0])
        }
    },

     methods: {
            subtotalRow(index) {
                let sum = 0;
                this.sortedList.map((anio, value) => {
                    for(const meses in anio){
                        for (const mes in anio[meses]) {
                           // console.log(anio[meses][mes])
                            for (const rut in anio[meses][mes]){
                                if (rut == index){
                                    sum = sum + anio[meses][mes][rut];
                                }
                            }
                        }
                    }
                })
               return Intl.NumberFormat('es-ES').format(sum)
            },
            printName(rut){
                return this.entidades[rut]
            },
            printMonth(mesMumber){
                if (mesMumber == 1){
                    return "Enero"
                } else if (mesMumber == 2){
                    return "Febrero"
                } else if (mesMumber == 3){
                    return "Marzo"
                } else if (mesMumber == 4){
                    return "Abril"
                } else if (mesMumber == 5){
                    return "Mayo"
                } else if (mesMumber == 6){
                    return "Junio"
                } else if (mesMumber == 7){
                    return "Julio"
                } else if (mesMumber == 8){
                    return "Agosto"
                } else if (mesMumber == 9){
                    return "Septiembre"
                } else if (mesMumber == 10){
                    return "Octubre"
                } else if (mesMumber == 11){
                    return "Noviembre"
                } else if (mesMumber == 12){
                    return "Diciembre"
                }
            }
        }

})

Hello guys I have a list of objects which is composed as follows:

                    new Vue({
                            el: '#app',
                            data: {
                                checkedAnio: [2017,2018,2019,2020],
                                total_mensual:  {"2017":{"8":8402118,"12":16805365},"2018":{"1":3380427,"2":3383808,"6":1450000,"7":1741365,"8":11577539,"9":2588845,"10":3000000,"12":14868336},"2019":{"2":1594755,"3":11707602,"5":9460500,"9":6080000,"10":11900000,"11":18216520,"12":9779550},"2020":{"2":1443190,"3":44647800,"4":12288093,"8":19644587,"11":-342845469,"12":910439192}},
                                filterLista: {"2017":{"8":8402118,"12":16805365},"2018":{"1":3380427,"2":3383808,"6":1450000,"7":1741365,"8":11577539,"9":2588845,"10":3000000,"12":14868336},"2019":{"2":1594755,"3":11707602,"5":9460500,"9":6080000,"10":11900000,"11":18216520,"12":9779550},"2020":{"2":1443190,"3":44647800,"4":12288093,"8":19644587,"11":-342845469,"12":910439192}},                             entidades: {"10836904":"LUIS IGNACIO SALAZAR GALLEGOS","76035258":"Bruening Industrial","76122564":"Sociedad Comercializadora de Excedentes SpA","76122571":"Lampa SpA","76131794":"Sociadad comercializadora de excedentes Ferro Velh","76467560":"Inversiones Islam Ltda","76675405":"EQUIPOS Y MAQUINARIAS PINCHEIRA SPA","76829879":"Consorcio San Alberto de las Condes","76833156":"RECICLAJES REM SPA","76849049":"Comercializadora Alejandro Contreras SpA","76860599":"ACEROS DEL SUR S.A.","76898325":"RG Chile SpA","76914652":"Logistica Global Group SpA","76985375":"NUEVA LUZ DESECHOS LIMITADA","77078359":"ACEROS AMERICA SPA","77241295":"PATRICIA CORTES GUZMAN SPA","77418580":"Mantos Copper S.A","77612130":"SOC. COM. RECMETAL CIA. LTDA.","79587210":"Minera escondida limitada","92176000":"GERDAU AZA S.A.","96777810":"Polytex S.A","96935140":"SIDERVAL SA","99526550":"Ingenieria y montaje ferrovial s.a"},
                                pendientes: {"2017":{"8":{"99526550":8402118},"12":{"99526550":16805365}},"2018":{"1":{"99526550":3380427},"2":{"99526550":3383808},"6":{"76467560":1450000},"7":{"76675405":1741365},"8":{"76675405":11577539},"9":{"96777810":2588845},"10":{"76898325":3000000},"12":{"76035258":14868336}},"2019":{"2":{"76035258":1594755},"3":{"76675405":11707602},"5":{"79587210":9460500},"9":{"10836904":6080000},"10":{"76849049":11900000},"11":{"76914652":18216520},"12":{"76122571":9779550}},"2020":{"2":{"76122564":658878,"76675405":784312},"3":{"76122571":6746300,"77418580":37901500},"4":{"76860599":12288093},"8":{"76122571":3519040,"76829879":8986547,"76985375":7139000},"11":{"76833156":0,"79587210":-342845469,"96935140":0},"12":{"76131794":99960000,"76833156":43282120,"77078359":54621000,"77241295":110610500,"77612130":53818420,"79587210":534178302,"92176000":6156500,"96935140":7812350}}}
                            },
                            computed: {
                              listaMensual(){
                                return this.filterLista
                              }
                            },
                            methods: {
                               arrayRemove(anio) {
                                  delete this.listaMensual[anio]
                               }
                            }
                    })

            

            <div v-for="(meses, ano) in total_mensual">
                                        <label class="custom-control custom-checkbox custom-control-inline">
                                            <input type="checkbox" class="custom-control-input js-periodos mr-2" checked="" :value="ano"
                                                   v-model="checkedAnio"
                                                   :id="'anio_'+ ano"
                                                   @change="arrayRemove(ano)">
                                            <span class="custom-control-label">{{ ano }}</span>
                                        </label>
                                    </div>

The checkbox is already loaded with the years, when unchecking any of them, it eliminates the index by year of the monthlylist variable, but if I check it again, I would like this list of said year that was eliminated to be added again to the total_monthly variable, for example:

{"2017":{"8":8402118,"12":16805365}}

This would be the list:

<table class="table card-table table-vcenter text-nowrap table-hover" id="t-mayor">

                    <thead>

                    <tr>
                        <th style="background-color: white">Razón Social</th>
                        <template v-for="(meses, ano) in listaMensual">
                            <template v-for="(total_mes, mes) in meses">
                                <th class="js-data-" style="background-color: white">{{ printMonth(mes) }}  {{ ano  }}</th>
                            </template>
                        </template>
                        <th style="background-color: white">Totales</th>
                    </tr>

                    </thead>

                    <tbody>
                    <template v-for="(raz_soc, rut) in entidades">
                        <tr>
                            <td style="background-color: white">@{{ printName(rut) }}</td>
                            <template v-for="(meses, ano) in listaMensual">
                                <template v-for="(total_mes, mes) in meses">
                                    <td v-if="pendientes[ano][mes]">@{{ pendientes[ano][mes][rut] ? pendientes[ano][mes][rut] : 0 }}</td>
                                </template>
                            </template>
                            <td></td>
                        </tr>
                    </template>

                    </tbody>

                    <tfoot>
                    <tr>
                        <td style="background-color: #f5f5f5"></td>


                    </tr>
                    </tfoot>

                </table>

I have looked for a way to do it but in all of them I failed, I used filter but it always returned errors. If anyone in the community can help understand how to do it I would appreciate it.

Hello, I have a somewhat complex query which I need to migrate to Eloquent with Laravel or QueryBuilder. The query is as follows:

SELECT tipo, id_banco, nro_operacion, anno,  
sum(CASE  WHEN mes = 1 THEN cuota ELSE 0 END) AS Enero,
sum(CASE  WHEN mes = 2 THEN cuota ELSE 0 END) AS Febrero,
sum(CASE  WHEN mes = 3 THEN cuota ELSE 0 END) AS Marzo,
sum(CASE  WHEN mes = 4 THEN cuota ELSE 0 END) AS Abril,
sum(CASE  WHEN mes = 5 THEN cuota ELSE 0 END) AS Mayo,
sum(CASE  WHEN mes = 6 THEN cuota ELSE 0 END) AS Junio,
sum(CASE  WHEN mes = 7 THEN cuota ELSE 0 END) AS Julio,
sum(CASE  WHEN mes = 8 THEN cuota ELSE 0 END) AS Agosto,
sum(CASE  WHEN mes = 9 THEN cuota ELSE 0 END) AS Septiembre,
sum(CASE  WHEN mes = 10 THEN cuota ELSE 0 END) AS Octubre,
sum(CASE  WHEN mes = 11 THEN cuota ELSE 0 END) AS Noviembre,
sum(CASE  WHEN mes = 12 THEN cuota ELSE 0 END) AS Diciembre
from (
SELECT amortizacion.tipo, b.id as id_banco, amortizacion.nro_operacion,
MONTH(amortizacion_detalle.fecha_vencimiento) AS `mes`,
YEAR(amortizacion_detalle.fecha_vencimiento) AS `anno`,
Sum(amortizacion_detalle.valor_cuota) AS cuota
FROM
amortizacion_detalle
LEFT JOIN amortizacion ON amortizacion_detalle.amortizacion_id = amortizacion.id
LEFT JOIN banco AS b ON amortizacion.banco_id = b.id
WHERE
amortizacion.cliente_id = 10
GROUP BY
amortizacion_detalle.fecha_vencimiento
ORDER BY anno) as resultados
GROUP BY tipo, id_banco, nro_operacion, anno

This would be the result

But what is needed is to be able to do it in Laravel by bringing or improving the result of said query.

$facs = DB::table('amortizacion_detalle')
    ->select(DB::raw('tipo, id_banco, nro_operacion, anno,  
    sum(CASE  WHEN mes = 1 THEN cuota ELSE 0 END) AS Enero,
    sum(CASE  WHEN mes = 2 THEN cuota ELSE 0 END) AS Febrero,
    sum(CASE  WHEN mes = 3 THEN cuota ELSE 0 END) AS Marzo,
    sum(CASE  WHEN mes = 4 THEN cuota ELSE 0 END) AS Abril,
    sum(CASE  WHEN mes = 5 THEN cuota ELSE 0 END) AS Mayo,
    sum(CASE  WHEN mes = 6 THEN cuota ELSE 0 END) AS Junio,
    sum(CASE  WHEN mes = 7 THEN cuota ELSE 0 END) AS Julio,
    sum(CASE  WHEN mes = 8 THEN cuota ELSE 0 END) AS Agosto,
    sum(CASE  WHEN mes = 9 THEN cuota ELSE 0 END) AS Septiembre,
    sum(CASE  WHEN mes = 10 THEN cuota ELSE 0 END) AS Octubre,
    sum(CASE  WHEN mes = 11 THEN cuota ELSE 0 END) AS Noviembre,
    sum(CASE  WHEN mes = 12 THEN cuota ELSE 0 END) AS Diciembre'))
    ->where('amortizacion.cliente_id', '=', $request->input('cliente_id'))
    ->get();

Hi, does anyone have an idea how to do this? I have an application it turns out that I could not make the url clean

For example:

midominio.com/propiedad/1/esto-es-una-url/categoria/madre-en-apuro

but currently it is like this:

midominio.com/#/propiedad/1/esto-es-una-url/categoria/madre-en-apuro

In my app.routing.module.ts I have the following:

import { NgModule } from '@angular/core';
import { CommonModule } from '@angular/common';
import { RouterModule, Routes } from '@angular/router';
import { AuthGuard } from './auth.guard';

import { HomeComponent } from './pages/home/home.component';
import { PropDetailPageComponent } from './pages/prop/prop-detail-page/prop-detail-page.component';
import { PrivacidadPageComponent } from './pages/privacidad-page/privacidad-page.component';
import { TermsyCondPageComponent } from './pages/termsy-cond-page/termsy-cond-page.component';
import { NotFoundComponent } from './pages/not-found/not-found.component';
import { NuevaPropComponent } from './pages/prop/nueva-prop/nueva-prop.component';
import { SignInComponent } from './pages/sign-in/sign-in.component';
import { NuevaPropOkComponent } from './pages/prop/nueva-prop-ok/nueva-prop-ok.component';
import { MiCuentaComponent } from './pages/mi-cuenta/mi-cuenta.component';
import { SearchComponent } from './pages/search/search.component';
import { PublicProfileComponent } from './pages/public-profile/public-profile.component';
import { SelectPrecioComponent } from './pages/select-precio/select-precio.component';
import { SelectPlanComponent } from './pages/select-plan/select-plan.component';
import { EditarPropComponent } from './pages/prop/editar-prop/editar-prop.component';

import { MercadoPagoOkComponent } from './pages/MP/mercado-pago-ok/mercado-pago-ok.component';
import { MercadoPagoFailComponent } from './pages/MP/mercado-pago-fail/mercado-pago-fail.component';
import { MercadoPagoPendComponent } from './pages/MP/mercado-pago-pend/mercado-pago-pend.component';
import { VerificationComponent } from './pages/verification/verification.component';

const routes: Routes = [
  { path: '', component: HomeComponent },
  { path: 'home/:id', component: HomeComponent },
  { path: 'propiedad/:tipo_prop_nombre/:nombre_operacion/:provincia/:ciudad/:id/:titulo', component: PropDetailPageComponent },
  { path: 'propiedad/edit/:id', component: EditarPropComponent, canActivate: [AuthGuard] },
  { path: 'privacidad', component: PrivacidadPageComponent },
  { path: 'terminos', component: TermsyCondPageComponent },
  { path: "404", component: NotFoundComponent },
  { path: "signin", component: SignInComponent },
  { path: "new-prop", component: NuevaPropComponent, canActivate: [AuthGuard] },
  { path: "new-prop-ok", component: NuevaPropOkComponent, canActivate: [AuthGuard] },
  { path: "mi-cuenta", component: MiCuentaComponent, canActivate: [AuthGuard] },
  { path: "search", component: SearchComponent },
  { path: 'perfil/:id', component: PublicProfileComponent },
  { path: 'select-plan', component: SelectPrecioComponent },
  { path: 'update-plan', component: SelectPrecioComponent },
  { path: 'compraOk', component: MercadoPagoOkComponent },
  { path: 'compraFail', component: MercadoPagoFailComponent },
  { path: 'compraPending', component: MercadoPagoPendComponent },
  { path: 'verify/:id', component: VerificationComponent },
  { path: "**", redirectTo: "/404" },

];

@NgModule({
  imports: [RouterModule.forRoot(routes, { useHash: true })],
  exports: [RouterModule]
})

export class AppRoutingModule { }

Hello, I have the following code in php which performs the registration of a sale, what I want is to perform the following action. Return the id of the record saved in the DB

$query = "CALL sp_insert_venta(:tipo_pago, :tipo_comprobante,
                :sumas, :iva, :exento, :retenido, :descuento, :total, :sonletras, :pago_efectivo, :pago_tarjeta, :numero_tarjeta,
                :tarjeta_habiente, :cambio, :estado, :idcliente, :idusuario, :nro_cuotas, :intereses_cuotas)";

                $stmt = $dbconec->prepare($query);
                $stmt->bindParam(":tipo_pago",$tipo_pago);
                $stmt->bindParam(":tipo_comprobante",$tipo_comprobante);
                $stmt->bindParam(":sumas",$sumas);
                $stmt->bindParam(":iva",$iva);
                $stmt->bindParam(":exento",$exento);
                $stmt->bindParam(":retenido",$retenido);
                $stmt->bindParam(":descuento",$descuento);
                $stmt->bindParam(":total",$total);
                $stmt->bindParam(":sonletras",$sonletras);
                $stmt->bindParam(":pago_efectivo",$pago_efectivo);
                $stmt->bindParam(":pago_tarjeta",$pago_tarjeta);
                $stmt->bindParam(":numero_tarjeta",$numero_tarjeta);
                $stmt->bindParam(":tarjeta_habiente",$tarjeta_habiente);
                $stmt->bindParam(":cambio",$cambio);
                $stmt->bindParam(":estado",$estado);
                $stmt->bindParam(":idcliente",$idcliente);
                $stmt->bindParam(":idusuario",$idusuario);
                $stmt->bindParam(":nro_cuotas",$numero_cuotas);
                $stmt->bindParam(":intereses_cuotas",$intereses_cuota);

                if($stmt->execute())
                {
                    $count = $stmt->rowCount();
                    if($count == 0){
                        $data = "Duplicado";
                        echo json_encode($data);
                    } else {
                        foreach($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) {
                            echo json_encode(['message' => 'Validado', 'venta' => $row]);
                        }
                    }
                } else {

                    $data = "Error";
                    echo json_encode($data);
                }
                $dbconec = null;
            } catch (Exception $e) {
                $data = "Error";
                echo json_encode($e);
                //echo $e;

            }

My stored procedure: Note I was doing it this way but it returns an error

errorInfo: ["HY000"] 0: "HY000"

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_insert_venta`(IN `p_tipo_pago` VARCHAR(75), IN `p_tipo_comprobante` TINYINT(1), IN `p_sumas` DECIMAL(10,2), IN `p_iva` DECIMAL(10,2), IN `p_exento` DECIMAL(10,2), IN `p_retenido` DECIMAL(10,2), IN `p_descuento` DECIMAL(10,2), IN `p_total` DECIMAL(10,2), IN `p_sonletras` VARCHAR(150), IN `p_pago_efectivo` DECIMAL(10,2), IN `p_pago_tarjeta` DECIMAL(10,2), IN `p_numero_tarjeta` VARCHAR(16), IN `p_tarjeta_habiente` VARCHAR(90), IN `p_cambio` DECIMAL(10,2), IN `p_estado` TINYINT(1), IN `p_idcliente` INT(11), IN `p_idusuario` INT(11), IN `p_nro_cuotas` INT(11), IN `p_intereses_cuotas` DECIMAL(10,2))
BEGIN

    DECLARE p_numero_comprobante INT;
    DECLARE p_efectivo_caja DECIMAL(10,2);
    DECLARE p_abono_credito DECIMAL(10,2);

    SET p_numero_comprobante = (SELECT usados + 1 FROM view_comprobantes WHERE idcomprobante = p_tipo_comprobante);



          IF NOT EXISTS (SELECT * FROM venta WHERE `numero_comprobante` = p_numero_comprobante
          AND `tipo_comprobante` = p_tipo_comprobante AND `fecha_venta` = NOW()) THEN

              IF p_estado = '1' THEN

              IF p_idcliente = '0' THEN

                IF p_numero_comprobante = '0' THEN

                    INSERT INTO `venta`(`fecha_venta`, `tipo_pago`,
                    `numero_comprobante`, `tipo_comprobante`, `sumas`, `iva`,
                    `exento`, `retenido`, `descuento`, `total`,
                    `sonletras`, `pago_efectivo`, `pago_tarjeta`, `numero_tarjeta`,
                    `tarjeta_habiente`, `cambio`, `estado`, `idcliente`, `idusuario`)
                    VALUES (NOW(), p_tipo_pago,
                    1, p_tipo_comprobante, p_sumas, p_iva,
                    p_exento, p_retenido, p_descuento, p_total,
                    p_sonletras, p_pago_efectivo, p_pago_tarjeta, p_numero_tarjeta,
                    p_tarjeta_habiente, p_cambio, p_estado, NULL, p_idusuario);

                    SELECT LAST_INSERT_ID() as registerID;
                    UPDATE `tiraje_comprobante` SET
                    `disponibles` = `disponibles` - 1
                    WHERE idcomprobante = p_tipo_comprobante;


                    IF (p_tipo_pago = 'EFECTIVO') THEN
                        CALL sp_insert_caja_venta(p_total);
                    ELSEIF (p_tipo_pago = 'EFECTIVO Y TARJETA') THEN
                        CALL sp_insert_caja_venta(p_pago_efectivo);
                    END IF;


                ELSE

                    INSERT INTO `venta`(`fecha_venta`, `tipo_pago`,
                    `numero_comprobante`, `tipo_comprobante`, `sumas`, `iva`,
                    `exento`, `retenido`, `descuento`, `total`,
                    `sonletras`, `pago_efectivo`, `pago_tarjeta`, `numero_tarjeta`,
                    `tarjeta_habiente`, `cambio`, `estado`, `idcliente`, `idusuario`)
                    VALUES (NOW(), p_tipo_pago,
                    p_numero_comprobante, p_tipo_comprobante, p_sumas, p_iva,
                    p_exento, p_retenido, p_descuento, p_total,
                    p_sonletras, p_pago_efectivo, p_pago_tarjeta, p_numero_tarjeta,
                    p_tarjeta_habiente, p_cambio, p_estado, NULL, p_idusuario);


                    SELECT LAST_INSERT_ID() as registerID;
                    UPDATE `tiraje_comprobante` SET
                    `disponibles` = `disponibles` - 1
                    WHERE idcomprobante = p_tipo_comprobante;


                    /*IF (p_tipo_pago = 'EFECTIVO') THEN
                        CALL sp_insert_caja_venta(p_total);
                    ELSEIF (p_tipo_pago = 'EFECTIVO Y TARJETA') THEN
                        CALL sp_insert_caja_venta(p_pago_efectivo);
                    END IF;*/

                END IF;

               ELSE

                IF p_numero_comprobante = '0' THEN

                    INSERT INTO `venta`(`fecha_venta`, `tipo_pago`,
                    `numero_comprobante`, `tipo_comprobante`, `sumas`, `iva`,
                    `exento`, `retenido`, `descuento`, `total`,
                    `sonletras`, `pago_efectivo`, `pago_tarjeta`, `numero_tarjeta`,
                    `tarjeta_habiente`, `cambio`, `estado`, `idcliente`, `idusuario`)
                    VALUES (NOW(), p_tipo_pago,
                    1, p_tipo_comprobante, p_sumas, p_iva,
                    p_exento, p_retenido, p_descuento, p_total,
                    p_sonletras, p_pago_efectivo, p_pago_tarjeta, p_numero_tarjeta,
                    p_tarjeta_habiente, p_cambio, p_estado, p_idcliente, p_idusuario);
                    SELECT LAST_INSERT_ID() as registerID;

                    UPDATE `tiraje_comprobante` SET
                    `disponibles` = `disponibles` - 1
                    WHERE idcomprobante = p_tipo_comprobante;


                    /*IF (p_tipo_pago = 'EFECTIVO') THEN
                        CALL sp_insert_caja_venta(p_total);
                    ELSEIF (p_tipo_pago = 'EFECTIVO Y TARJETA') THEN
                        CALL sp_insert_caja_venta(p_pago_efectivo);
                    END IF;*/


                ELSE

                    INSERT INTO `venta`(`fecha_venta`, `tipo_pago`,
                    `numero_comprobante`, `tipo_comprobante`, `sumas`, `iva`,
                    `exento`, `retenido`, `descuento`, `total`,
                    `sonletras`, `pago_efectivo`, `pago_tarjeta`, `numero_tarjeta`,
                    `tarjeta_habiente`, `cambio`, `estado`, `idcliente`, `idusuario`)
                    VALUES (NOW(), p_tipo_pago,
                    p_numero_comprobante, p_tipo_comprobante, p_sumas, p_iva,
                    p_exento, p_retenido, p_descuento, p_total,
                    p_sonletras, p_pago_efectivo, p_pago_tarjeta, p_numero_tarjeta,
                    p_tarjeta_habiente, p_cambio, p_estado, p_idcliente, p_idusuario);

                    UPDATE `tiraje_comprobante` SET
                    `disponibles` = `disponibles` - 1
                    WHERE idcomprobante = p_tipo_comprobante;


                    IF (p_tipo_pago = 'EFECTIVO') THEN
                        CALL sp_insert_caja_venta(p_total);
                    ELSEIF (p_tipo_pago = 'EFECTIVO Y TARJETA') THEN
                        CALL sp_insert_caja_venta(p_pago_efectivo);
                    END IF;


                END IF;


              END IF;


            ELSEIF p_estado = '2' THEN

            IF p_numero_comprobante = '0' THEN

                INSERT INTO `venta`(`fecha_venta`, `tipo_pago`,
                `numero_comprobante`, `tipo_comprobante`, `sumas`, `iva`,
                `exento`, `retenido`, `descuento`, `total`,
                `sonletras`, `pago_efectivo`, `pago_tarjeta`, `numero_tarjeta`,
                `tarjeta_habiente`, `cambio`, `estado`, `idcliente`, `idusuario`)
                VALUES (NOW(), p_tipo_pago,
                1, p_tipo_comprobante, p_sumas, p_iva,
                p_exento, p_retenido, p_descuento, p_total,
                p_sonletras, 0.00, 0.00, NULL, 0.00, 0.00, p_estado, p_idcliente, p_idusuario);

                UPDATE `tiraje_comprobante` SET
                `disponibles` = `disponibles` - 1
                WHERE idcomprobante = p_tipo_comprobante;

                CALL sp_insert_credito_venta(p_total, p_idcliente, p_nro_cuotas, p_intereses_cuotas);

                ELSE

                INSERT INTO `venta`(`fecha_venta`, `tipo_pago`,
                `numero_comprobante`, `tipo_comprobante`, `sumas`, `iva`,
                `exento`, `retenido`, `descuento`, `total`,
                `sonletras`, `pago_efectivo`, `pago_tarjeta`, `numero_tarjeta`,
                `tarjeta_habiente`, `cambio`, `estado`, `idcliente`, `idusuario`)
                VALUES (NOW(), p_tipo_pago,
                p_numero_comprobante, p_tipo_comprobante, p_sumas, p_iva,
                p_exento, p_retenido, p_descuento, p_total,
                p_sonletras, 0.00, 0.00, NULL, 0.00, 0.00, p_estado, p_idcliente, p_idusuario);

                UPDATE `tiraje_comprobante` SET
                `disponibles` = `disponibles` - 1
                WHERE idcomprobante = p_tipo_comprobante;

                CALL sp_insert_credito_venta(p_total, p_idcliente, p_nro_cuotas, p_intereses_cuotas);

            END IF;

            END IF;

        END IF;
END

Hello, I would like to reflect the number of days of an absent worker from his date of absence, either using Carbon or something native in php, I use Laravel, the example is this:

In the DB I consult the absenteeism that said worker has

$ausentismo_anual_dias = $empresa->ausentismo()
->whereYear('fecha_ausente', Carbon::now()->format('Y'))
->get();

In a foreach loop I want to print from its absence date example

foreach($ausentismo_anual_dias as $row){
           //Aqui quiero calcular los dias de ausencias 

        }

Note the days of absence must be calculated per month example This worker is absent from the given date 2018-10-06(Month October) to the end date of the month October 2018-10-31 has 25 days absent, so we go to November 2018- 11-01 to the current date 2018-11-05 has 5 days elapsed in that month All that must be traversed from the cycle

showing it like this:

October: 25 days absent

November: 5 days absent

December should not show since we are not in that month so it should be in 0 days

I hope you can help me with this request.

How to consume a call center webservice they gave me a url to be consumed by laravel I have the form done and everything else that sends me the parameters by jQuery

class CallController extends Controller
{
    public function showCall(Request $request)
    {


        $client = new \GuzzleHttp\Client();
        $res = $client->request('GET', 'http://mi_ip:8080/IntegrationWs/resources/callback/'. $request->input('telefono'));
        return response()->json([
            'status' => TRUE,
            'data' => $res->getBody()
        ]);
    }
}

it returns an errorcURL error 7: Failed to connect to 10.1.3.185 port 8080

I want to implement a logic in my laravel backend using the date of a post.

The example is as follows:

A user creates an article, it contains title, content, image, its user owner and its publication date. It turns out that the user published this article but had one or more spelling errors and wants to edit it, but he realized hours later, he would like to avoid this. , I would like to compare the date in minutes with Laravel using Carbon or some native php function, making it, through an if statement, tell me that it compares if the date of the article has been greater than 30 minutes, said article cannot be edited, something like this:

if($article->create_at > 30min){
  return abort(403, 'No tienes permisos para editar ya este artículo');
}

I don't know if I make myself understand with this but I'm trying to ensure that the last thing written in a textarea or input field is the one executed to be translated in the azure translator api. I do this with ajax and laravel, I leave the code hanging and can you help me.

With the jquey code, when I write in the textarea field, the each event is executed at the same time, I check if the textarea is not empty due to spaces, this in turn performs the ajax but if it has a delay in the first letter written and the last one is execute quickly example: h the first one executed hello the last one written the first one had a delay and the last one was executed quickly but the first one that was the h was executed later and instead of translating hello it translates the h for me.

Is there no way for the last written to be executed?

<textarea id="translate_q" name="q" maxlength="5000" rows="9" cols="100" placeholder="comienza a escribir" style="height: 159px">{{ $text  or ''}}</textarea>

e there where the jquery code is executed

$('#translate_q').each(function(){
        var keyed = $('#translate_q').val().replace(/[\n]/g,'<br />');
        if(keyed){
            var langfrom = document.getElementById("translate_source").value;
            var langto = document.getElementById("translate_target").value;
            var textfrom = document.getElementById("translate_q").value;
            $.ajax({
                type: "GET",
                contentType: "application/x-www-form-urlencoded;charset=ISO-8899-1",
                url: "/translator",
                data: {
                    langfrom: langfrom,
                    langto: langto,
                    textfrom: keyed
                },
            }).done(function(data) {
                // body...
                document.getElementById("translate_result").value = data;
                $("#action_copy").removeClass("off")
                $("#action_link").removeClass("off")
                $("#action_email").removeClass("off")
                $("#action_listen").removeClass("off")
            });
        }
    }); 

What I want is that when I click on the button it sends me the comment and loads it in its respective id something like in Jquery that loads said elements by means of an ID$("#commentload" + id).append(template);

I leave my AngularJS code (Angular 1) since I have tried to do it in several ways and I have not yet been successful in what I want

this.sendComments = (stream_id) => {
    let data = {
        stream_id: stream_id,
        body: this.commentBody
    }
    this.CommentService.getComments(data).then((response) => {
        this.comments.push(response.data);
        angular.element('').find(...)
    }).catch(this.failedComment.bind(this));

    this.commentBody = "";
}


<div flex-gt-sm="100" flex>
    <md-divider ></md-divider>
    <md-list flex ng-repeat="cmt in streams['comments']">
        <md-list-item class="md-3-line" ng-repeat="comentarios in cmt">
            <img ng-src="{{comentarios['users']['data']['user_avatar_mini']}}" class="md-avatar" alt="{{comentarios['users']['data']['user_name']}}" />
             <div class="md-list-item-text" layout="column">
               <h3>{{comentarios['users']['data']['user_name']}} - {{comentarios['comment_created_at']}}</h3>
                 <p>{{comentarios['comment_body']}}</p>
             </div>
        <md-divider></md-divider>
        </md-list-item>
     </md-list>



    <md-list flex>
    <!--Aqui cargo los comentarios enviados desde el input-->
        <md-list-item id="stream-{{streams.stream_id}}" class="md-3-line" ng-repeat="comments in stream['comments']">
            <img ng-src="{{comments[0]['users']['data']['user_avatar_mini']}}" class="md-avatar" alt="{{comments[0]['data']['users']['data']['user_name']}}" />
            <div class="md-list-item-text" layout="column">
              <h3>{{comments[0]['users']['data']['user_name']}} - {{comments[0]['comment_created_at']}}</h3>
              <p>{{comments[0]['comment_body']}}</p>
            </div>
            <md-divider></md-divider>
        </md-list-item>
      </md-list>
</div>

<md-card-actions layout="row" layout-align="end center">
    <md-input-container md-no-float class="md-block" flex>
        <label>Comenta!</label>
        <input type="text" data-ng-model="stream.commentBody">
        <md-icon md-font-set="md" style="display:inline-block;" ng-click="stream.sendComments(streams.stream_id)">send</md-icon><!--Cuando haga click cargue el comentario en el id especifico del stream-->
    </md-input-container>
</md-card-actions>

This id="stream-{{streams.stream_id}}"is where I want to load the comment sent according to the loader streams in a list, if there are 30 with different IDs and different comments, load the comment to its corresponding id

I need to send the value of a hidden field with ng-value I put the code of which I am sending a text content type

<form>
    <div class="comment_it commentupdate">
        <div class="up_img">
            <img src="" width="35" height="35" />
        </div>
        <div class="comments-text-post-area">
            <input type="hidden" ng-model="c.cid" ng-value="'{{p.id}}'">
            <textarea class="add-y-comment" ng-model="c.comment" placeholder="Comentar"></textarea>
        </div>

        <div class="comment-post-wall">
            <div class="cancel-comment">
                <button type="button" name="button" id="">CANCELAR</button>
            </div>
            <div class="send-comment">
                <button type="submit" name="button" ng-click="c.addComment()">ENVIAR</button>
            </div>
        </div>
    </div>
</form>

In the Chrome console I only capture the text typed in the textarea. p.id is the value of the post to comment

angular .module('apiFromApp')

.controller('CommentController', CommentController);

CommentController.$inject = ['$http'];

/* @ngInject */
function CommentController($http) {
    var self = this;

    //sendComment();

    self.addComment = function() {
      console.log(self);
    }
}

I have a problem when implementing the angularJs ngInfiniteScroll library with Laravel, the truth is that I have not encountered this error here in my Angular Services

function PostServices($http, $q, CONFIG) {
  return {
        getPots: getPots,
      //  postCheck: postCheck,
        postSave: postSave
    };

    this.recipes = [];
    this.loading = false;
    this.page = 1;


   function getPots() {

     var url = CONFIG.APIURL + 'post/ajaxviewpublish?page=' + this.page;
     if (this.loading) return;
     this.loading = true;
     $http.get(url)
     .success(function (data) {
       console.log(data.message.data);
       for (var i = 0; i < data.message.data.length; i++) {
           this.recipes.push(data.message.data[i]);
       }
       this.page++;
       this.loading = false;
       recipes.loading = true; // This should prevent more code from being loaded.
   }.bind(this));


   }
   return getPots;

I have a Controller in angular which is responsible for textarealoading a content urlif it is, if it is not a url it does not load any data, the problem is that when I want to write only text it sends me undefined data.

function PostCtrl($scope,$http, $compile, $rootScope, PostServices, CONFIG) {
  $scope.renderHTML = function(html_code)         {
            console.log(html_code);
            return $sce.trustAsHtml(html_code);
        };

  $scope.patternUrl = (function() {
      var regexp = /(https?:\/\/[^\s]+)/gi;
      return {
        test: function(value) {
          //return regexp.test(value);
          if (regexp.test(value)) {

            $scope.form = {
                    name: name,
                }


              return  $scope.$watch('form', function(newVal, oldVal){
                  $http({
                     url: CONFIG.APIURL + 'post/ajaxcheck',
                     method: "POST",
                     data: {'query':newVal}
                   }).success(function (data, status, headers, config) {
                       var publisher = $('.timeline');
                       $scope.postsDetails=data.data;

                     }).error(function (data, status, headers, config) {
                        //ERROR


                   });
          }, true);
          }
        }
      };
    })();

    $scope.send = function () {

      var link = $scope.postsDetails;

    console.log($scope.form.name); //Aqui deberia de imprimir solo el texto si no hay contenido cargado
        $http.post(CONFIG.APIURL + 'post/ajaxpublish', JSON.stringify({
            name: $scope.postsDetails,
            message:   $scope.form.name,
        })).success(function(data, status) {
            $scope.postsList=data.data;
        })


    }


}

HTML

<div class="mdl-card__title loader">
              <div class="post-text-area f-right">
                <textarea class="post-textarea mdl-textfield__input js_publisher_timeline" ng-model="form.name" ng-pattern="patternUrl" name="Url"></textarea>
              </div>
              <div class="f-left mdl-card__menu">
                <img class="_bth img" src="" height="40" width="40">
              </div>

            </div>
            <div class="publisher-timeline" id="pub">
              <ng-responsive-posts data="postsDetails"></ng-responsive-posts>
            </div>

I edit my question and give solution to my problem:

    function PostCtrl($scope,$http, $compile, $rootScope, PostServices, CONFIG) {     

      //Valido si es una url
      function validateUrl(formText) {
        var regexp = /(https?:\/\/[^\s]+)/gi;
        return regexp.test(formText) ? true : false
      }

      $scope.$watch('post.formText', function(newValue, oldValue) {
        $scope.reqs = [];
        //Si da true paso por aqui
        if (validateUrl(newValue)) {
          $http({
             url: CONFIG.APIURL + 'post/ajaxcheck',
             method: "POST",
             data: {'query':newValue}
           }).success(function (data, status, headers, config) {
                $scope.postsAttach = data.data;
                $scope.post.formText = data.data.title;
             }).error(function (data, status, headers, config) {
                //ERROR


           });
        }else {
//Si doy false paso solo a enviar texto
          $scope.Text = newValue;
        }
      }, true);

//Una vez cargado el contenido texto o url lo envio para ser guardado en el //backend con L5
      $scope.send = function () {

        $http({
           url: CONFIG.APIURL + 'post/ajaxpublish',
           method: "POST",
           dataType: 'json',
           data: JSON.stringify({'name': $scope.postsAttach,'message': $scope.Text})
         }).success(function (data, status, headers, config) {
            $scope.postsAttach = "";
            $scope.Text = "";
            $scope.post.formText ="";
           }).error(function (data, status, headers, config) {
              //ERROR


         });


      }

    }

I have a buttonto upload images in my web project; in Chrome and Microsoft Edge it works, but in Firefox it doesn't. Clicking it should open the window to search for the image to upload as it does in other browsers.

My HTML code:

<button data-upgraded=",MaterialButton" class="mdl-button mdl-js-button mdl-button--icon mdl-button--colored f-left">
<i class="material-icons ">cloud_upload</i>
    <form method="POST" action="http://timeline.dev/post/ajaxupload" accept-charset="UTF-8" class="x-uploader" enctype="multipart/form-data">
      <input name="_token" value="3kpNrTDVx59bdv1KqB8x4HNbftxdDC1TpIjpNgeX" type="hidden">
      <input name="file" type="file">
    </form>
</button>

That code should work the same as it does in Chrome and Explorer:

this is my file i have in Laravel 5

Options -MultiViews

#redirect www to website root
RewriteEngine On
RewriteBase /
RewriteCond %{HTTP_HOST} ^www\.(.*)$ [NC]
RewriteRule ^(.*)$ http://%1/$1 [R=301,L]

#force https 
RewriteEngine On
RewriteCond %{SERVER_PORT} 80
RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301]

when entering my domain.com it should redirect me to https://domain.com it does but it gives me an error ERR_TOO_MANY_REDIRECTS

I am trying to access the id of this element sent by json in handlebars.js

{
    "status":"success",
    "message": {
        "message":"sdasdasasd",
        "type":"photo",
        "post_id":55,
        "title":"",
        "description":"",
        "url":"",
        "image":"",
        "code":"",
        "provider":"",
        "photo": {
           "http:\/\/timeline.dev\/storage\/app\/public\/vdjkelly\/timeline_SzfkoDzMWc.jpg":"http:\/\/timeline.dev\/storage\/app\/public\/vdjkelly\/timeline_SzfkoDzMWc.jpg",
           "http:\/\/timeline.dev\/storage\/app\/public\/vdjkelly\/timeline_qm7sq7RY1K.jpg":"http:\/\/timeline.dev\/storage\/app\/public\/vdjkelly\/timeline_qm7sq7RY1K.jpg"
        }
    }
}

The code I have like this

@{{#each photo}}

  <li class="grid">
    <div class="posted-photo">
      <div class="photo">
        <div class="fphoto-item">
          <a class="ShowStatus" data-id="@{{post_id}}" href="#" data-lightbox="lightbox@{{post_id}}">
            <img src="@{{this}}" class="imgpreview" id="@{{post_id}}" rel="@{{post_id}}">
          </a>
        </div>
      </div>
  </li>
@{{/each}}

and still does not access mepost_id

My js code is as follows:

var template = render_template('#send-photo', {
    'message': response.message.message, 
    'type': response.message.type, 
    'photo': response.message.photo, 
    'post_id': response.message.post_id
});