Yu1709$!%yuyu!$%wutu!5=126+

                
____  ___       .__                 
\   \/  /  _____|  |   ______  _  __
 \     /  /  ___/  |  /  _ \ \/ \/ /
 /     \  \___ \|  |_(  <_> )     / 
/___/\  \/____  >____/\____/ \/\_/  
      \_/     \/    @ligmakokz

Editing: Peso.php

<?php

namespace Trash;

use Illuminate\Database\Eloquent\Model;
use Trash\Clientes;
use DB;

class Peso extends Model
{
    //
    protected $table = 'peso_cliente';

public function peso_cliente(){
      $sql = "SELECT p.id peso_id, c.id, c.nombre_comercial, p.mes_id, p.year,
              CASE WHEN (p.mes_id) = 1 THEN 'Enero'
              WHEN (p.mes_id) = 2 THEN 'Febrero'
              WHEN (p.mes_id) = 3 THEN 'Marzo'
              WHEN (p.mes_id) = 4 THEN 'Abril'
              WHEN (p.mes_id) = 5 THEN 'Mayo'
              WHEN (p.mes_id) = 6 THEN 'Junio'
              WHEN (p.mes_id) = 7 THEN 'Julio'
              WHEN (p.mes_id) = 8 THEN 'Agosto'
              WHEN (p.mes_id) = 9 THEN 'Septiembre'
              WHEN (p.mes_id) = 10 THEN 'Octubre'
              WHEN (p.mes_id) = 11 THEN 'Noviembre'
              WHEN (p.mes_id) = 12 THEN 'Diciembre'
              ELSE 'Error' END AS mes
              , co.cuota, u.unidad, p.peso, p.id peso_id
              FROM cliente c
              JOIN peso_cliente p ON c.id = p.cliente_id
              JOIN cuota co ON co.id = c.cuota_id
              JOIN unidad u ON u.id = c.unidad_id
              WHERE p.mes_id = MONTH(CURDATE()) AND c.status_id = 1 AND year = YEAR(CURDATE())
              ORDER BY c.nombre_comercial, p.year, p.mes_id";

$data = \DB::select( \DB::raw( $sql ) );
  		if(count($data)!=null){
              return response()->json(array('status'=>true, 'data'=>$data));
          }else{
               return response()->json(array('status'=>false));
          }
    }

public function update_peso($data){
      $where_cliente = "";
      if($data['mes'] != 0){
        $where_cliente .= " mes_id = ".$data['mes']." AND ";
      }
      if($data['year'] != 0){
        $where_cliente .= " year = ".$data['year']." AND ";
      }
      if($data['cuota'] != 0){
         $clientes = $this->getClientesCuota($data);
         $where_cliente.=" cliente_id in (".$this->get_Array($clientes).")  OR ";
      }
      if($data['unidad'] != 0){
         $clientes = $this->getClientesUnidad($data);
        $where_cliente.=" cliente_id in (". $this->get_Array($clientes).")  OR ";
      }
      if($data['cliente'] != 0){
        $where_cliente.= " cliente_id = ".$data['cliente']."  OR ";
      }

$where_cliente = substr($where_cliente,0,-4);

if($data['id']== 1){
        return $this->actualiza_peso($data, $where_cliente);
      }else {
        return $this->filter_peso($where_cliente);
      }
    }

public function filter_peso($where_cliente){
      $sql="SELECT c.id, c.nombre_comercial, p.mes_id, p.year,
              CASE WHEN (p.mes_id) = 1 THEN 'Enero'
              WHEN (p.mes_id) = 2 THEN 'Febrero'
              WHEN (p.mes_id) = 3 THEN 'Marzo'
              WHEN (p.mes_id) = 4 THEN 'Abril'
              WHEN (p.mes_id) = 5 THEN 'Mayo'
              WHEN (p.mes_id) = 6 THEN 'Junio'
              WHEN (p.mes_id) = 7 THEN 'Julio'
              WHEN (p.mes_id) = 8 THEN 'Agosto'
              WHEN (p.mes_id) = 9 THEN 'Septiembre'
              WHEN (p.mes_id) = 10 THEN 'Octubre'
              WHEN (p.mes_id) = 11 THEN 'Noviembre'
              WHEN (p.mes_id) = 12 THEN 'Diciembre'
              ELSE 'Error' END AS mes
              , co.cuota, u.unidad, p.peso, p.id peso_id
              FROM cliente c
              JOIN peso_cliente p ON c.id = p.cliente_id AND c.status_id = 1 
              JOIN cuota co ON co.id = c.cuota_id
              JOIN unidad u ON u.id = c.unidad_id
              WHERE " .$where_cliente."
              Order by c.nombre_comercial, p.year, p.mes_id
              ";
      $data = \DB::select( \DB::raw( $sql ) );
      return $data;
    }

public function actualiza_peso($data, $where_cliente){
      $sql="UPDATE peso_cliente SET peso = ".$data['peso']." WHERE ".$where_cliente;
      $data = DB::update(  $sql  );

if($data!=0){
          return response()->json(array('status'=>true, 'message'=>'Pesos Actualizados Correctamente'));
      }else{
           return response()->json(array('status'=>false,'message'=>'No hubo Actualizacion de Peso'));
      }
    }

public function getClientesCuota($data){
      $clientes = Clientes::where('cuota_id','=',$data['cuota'])->get();
      return $this->get_Array($clientes);
    }

public function getClientesUnidad($data){
      return Clientes::where('unidad_id','=',$data['unidad'])->get();
    }

public function get_Array($array){
      $obj = "";
      foreach ($array as $key => $value) {
        $obj.= $value->id.',';
      }
      $obj = substr($obj,0,-1);
      return $obj;
    }

public function modifyWeigh($peso,$id){
      $sql="UPDATE peso_cliente SET peso = ".$peso." WHERE id =". $id;
      $data = DB::update(  $sql  );

public function years_months_weigth($year = null){
      $monthGroup = "";
      $monthWHere = "";
      if($year != null){
        $monthGroup = ", mes_id";
        $monthWHere = " AND year = ".$year;
      }
      $sql = "SELECT year, mes_id
              FROM peso_cliente
              WHERE year != 0 $monthWHere
              GROUP BY year $monthGroup";

$data = DB::select( DB::raw( $sql ) );

return $data;

}
    public function getPesosMonth($year_base, $month_base){
      $sql = "SELECT c.id, pc.peso
              FROM cliente c
              LEFT JOIN peso_cliente pc ON pc.cliente_id = c.id  AND year = $year_base and mes_id = $month_base
              WHERE c.status_id = 1";
      $data = DB::select( DB::raw( $sql ) );

return $data;
    }
    public function verifyPesosMonth($year_dstinity, $month_destinity, $cliente){
      $sql = "SELECT *
              FROM peso_cliente
              WHERE  year = $year_dstinity and mes_id = $month_destinity AND cliente_id = $cliente";
      $data = DB::select( DB::raw( $sql ) );

return $data;
    }
}

Name	Type	Actions
Console	Directory
Events	Directory
Exceptions	Directory
Helpers	Directory
Http	Directory
Jobs	Directory
Listeners	Directory
Providers	Directory
.DS_Store	File
Camiones.php	File
Clientes.php	File
CombustibleOrden.php	File
CostoReciclable.php	File
Cuenta.php	File
Cuotas.php	File
DatosGral.php	File
Giro.php	File
Histories.php	File
OrdenC.php	File
Ordenes.php	File
Permission.php	File
Peso.php	File
Poliza.php	File
Reciclables.php	File
ReportConfig.php	File
Reporte.php	File
Ruta.php	File
SubCuenta.php	File
Tipo.php	File
Unidades.php	File
User.php	File
UserCliente.php	File
Users.php	File
Vertedero.php	File
VertederoOrden.php	File