KOKINIO - MANAGER

Edit File: OrdenC.php

<?php

namespace Trash;

use Illuminate\Database\Eloquent\Model;

class OrdenC extends Model
{
    //
  protected $table = 'orden_ruta';

public function getCheckList(){
    $sql = "SELECT o.id, c.nombre_comercial, u.username, o.dia, o.hora
            FROM orden_ruta o
            JOIN cliente c ON c.id = o.cliente_id
            JOIN user u ON u.id = o.user_id
            Order by dia,nombre_comercial";

$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 clientes_faltantes($fecha){
       $sql = "SELECT c.nombre_comercial, u.username, o.dia, o.hora,
          CASE (dia)
            WHEN 'domingo' THEN 'Sunday'
            WHEN 'lunes' THEN 'Monday'
            WHEN 'martes' THEN 'Tuesday'
            WHEN 'miercoles' THEN 'Wednesday'
            WHEN 'jueves' THEN 'Thursday'
            WHEN 'viernes' THEN 'Friday'
            WHEN 'sabado' THEN 'Saturday' END dia_en, od.orden_no
          FROM orden_ruta o
          JOIN cliente c ON c.id = o.cliente_id
          JOIN user u ON u.id = o.user_id
          LEFT JOIN orden od ON od.cliente_id = o.cliente_id 
          -- AND od.user_id = o.user_id 
          AND date(od.fecha_inicio) = '$fecha'
          WHERE CASE (dia)
            WHEN 'domingo' THEN 'Sunday'
            WHEN 'lunes' THEN 'Monday'
            WHEN 'martes' THEN 'Tuesday'
            WHEN 'miercoles' THEN 'Wednesday'
            WHEN 'jueves' THEN 'Thursday'
            WHEN 'viernes' THEN 'Friday'
            WHEN 'sabado' THEN 'Saturday' END = DAYNAME('$fecha')
            Order by hora";

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