getDataCustomers

public function getDataCustomers($cabang, $status, $remark){
        $datacustomer='';
        $urlfile = Parameters::select('value')->where('NAME', 'url.nama.file')->first();
		$datacustomer=DB::table('Customers')->leftJoin('Lock_Excepts', 'Customers.ID', '=', 'Lock_Excepts.CUSTOMER_ID')
                ->select('Customers.ID AS idcus', 'Customers.LOCAL_CODE', 'Customers.SAP_CODE', 'Customers.NAME', 'Customers.ADDRESS', 	'Customers.CITY', 'Customers.BRANCH','Customers.LOCK_STATUS', 'Lock_Excepts.REMARK' )
                ->get();
return DataTables()->of($datacustomer)
        ->editColumn('lock_status', function($data) use($urlfile) {
            $link="";
            if ($data->lock_status ==1){
                $link .= '<span class="label label-danger">&nbsp;&nbsp;&nbsp;<b>'."TERKUNCI".'</b></span><br>';
            } else {
                $link .=  '<span class="label label-success"><b>'."TERBUKA".'</b></span><br>';
            }

            if($data->remark==3){
                $link .= '<span class="label label-warning"><b>'."Range Payment".'</b></span>';
            } else if ($data->remark==2){
                $link .= '<span class="label label-info"><b>'."Auto/Adv.Payment".'</b></span>';
            } else {
                $link .= '<span class="label label-primary"><b>'."Normal Payment".'</b></span>';
            }

            $file = Lock_logs::select('remark')
            ->where('REMARK', 'like', '%'.$data->local_code.'%')->pluck('remark');

            for ($k=0; $k<count($file); $k++){
                $link .= '<b><a href="'.$urlfile->value.$file[$k].'">Berita Acara '.($k+1).'</a></b><br>';
            }

            return $link;
        })
        ->addColumn('detail', function($data){
            $link = '<div class="btn-group"><a href="javascript:void(0);"
             id="detail-customer" data-id="'.$data->local_code.'" class="btn-sm btn-primary">
             <i class="fas fa-align-justify"></i>  Detail  </a>';
            $link .= '&nbsp</div>';
            return $link;
        })
        ->editColumn('aksi', function($data) use($cabang, $remark){
            if ($cabang=='semua'){
            return 'Pilih Cabang Agar Tombol Autocoll Enabled';
            }else{
                if ($data->remark==2){
                    return '<div style="width:100px">  <select class="custom-select col-12 sap_code_dropdown" name="lockexcept" id="lockexcept" data-id="'.$data->idcus.'" local-code="'.$data->local_code.'" required="">
                    <option value="">--- Pilih  ---</option>
                    <option value="3" local-code="'.$data->local_code.'" >Range Payment</option>
                    <option value="2" selected="">AutoColl / Adv. Payment</option>
                    <option value="1" >Normal</option>
                    </select></div>';
                } else if ($data->remark==3){
                    return '<div style="width:100px">  <select   class="custom-select col-12 sap_code_dropdown" name="lockexcept" id="lockexcept" data-id="'.$data->idcus.'"  local-code="'.$data->local_code.'"required="">
                    <option value="">--- Pilih  ---</option>
                    <option value="3" local-code="'.$data->local_code.'" selected="">Range Payment</option>
                    <option value="2">AutoColl / Adv. Payment</option>
                    <option value="1">Normal</option>
                    </select></div>';
                } else {
                    return '<div style="width:100px">  <select   class="custom-select col-12 sap_code_dropdown" name="lockexcept" id="lockexcept" data-id="'.$data->idcus.'" local-code="'.$data->local_code.'"required="">
                    <option value="">--- Pilih  ---</option>
                    <option value="3" local-code="'.$data->local_code.'">Range Payment</option>
                    <option value="2">AutoColl / Adv. Payment</option>
                    <option value="1" selected="">Normal</option>
                    </select></div>';
                }
            }
        })
        ->rawColumns(['aksi', 'detail', 'lock_status'])
        ->make(true);
    }