summaryVisitPlan

<?php

namespace Sts\CmsActivity\BO;

use Sts\PleafCore\BusinessFunction;
use Sts\CmsActivity\Model\SlInvoiceVisitPlan;
use DB;
use Log;

/**
 * @author Bahar, 08/11/2019
 * @in
 *
 * @out
 */

class GetSummaryVisitPlan implements BusinessFunction
{

    public function getDescription()
    {
        return "Mendapatkan Daftar Summary Invoice Customer";
    }

    public function execute($dto)
    {
        \Log::info('GetSumarryInvoicePayment');

        $start_date = $dto["start_date"];
        $tenant_id  = $dto["tenant_id"];

        $query = " SELECT count(1) AS total_semua_toko, COUNT(1) FILTER (WHERE A.status_visit = 'Y') AS total_toko_dikunjungi,
        COUNT(1) FILTER (WHERE A.status_visit = 'N') AS total_toko_tidak_dikunjungi
        FROM sl_salesman_visit_plan A
        INNER JOIN sl_admin_process_visit_plan B ON B.employee_id = A.salesman_id AND B.start_date <= A.visit_date AND B.end_date >= A.visit_date
        WHERE B.start_date = '$start_date' AND B.tenant_id = $tenant_id
        ";

        $result = DB::select($query);

        return $result;
    }
}