medis | 💻 Medis is a beautiful , easy-to-use Mac database

/home/ardityoc/AndroidStudioProjects/HomeCare/app/src/main/java/com/humic/android/homecare/ui/user/home/HomeFragment.java:83: error: incompatible types: > cannot be converted to Callback
    ServiceApiService.getAllServicesUserRequest("Bearer " + loadToken()).enqueue(new Callback() {
                                                                                 ^

package com.humic.android.homecare.ui.user.home;

import android.content.Context;
import android.content.Intent;
import android.content.SharedPreferences;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.TextView;
import android.widget.Toast;

import androidx.annotation.NonNull;
import androidx.annotation.Nullable;
import androidx.appcompat.widget.Toolbar;
import androidx.fragment.app.Fragment;
import androidx.recyclerview.widget.LinearLayoutManager;
import androidx.recyclerview.widget.RecyclerView;

import com.google.android.material.appbar.CollapsingToolbarLayout;
import com.humic.android.homecare.R;
import com.humic.android.homecare.activity.user.MainActivity;
import com.humic.android.homecare.adapter.RecyclerViewServiceAdapter;
import com.humic.android.homecare.model.Service;
import com.humic.android.homecare.rest.ApiClient;
import com.humic.android.homecare.rest.ApiInterface;
import com.humic.android.homecare.rest.service.ServiceResponse;

import org.json.JSONException;
import org.json.JSONObject;

import java.io.IOException;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import retrofit2.Call;
import retrofit2.Callback;
import retrofit2.Response;

import static android.content.Context.MODE_PRIVATE;
import static com.humic.android.homecare.activity.LoginActivity.userToken;
import static com.humic.android.homecare.activity.user.CurrentUserActivity.userName;
import static com.humic.android.homecare.utils.SharedPreference.SHARED_PREFS_TOKEN;
import static com.humic.android.homecare.utils.SharedPreference.SHARED_PREFS_USER;

public class HomeFragment extends Fragment {

    String nameCache, tokenCache;
    TextView UserName;

    RecyclerView ServiceRecyclerView;
    RecyclerViewServiceAdapter ServiceAdapter;

    List ServiceList;

    Context ServiceContext;
    ApiInterface ServiceApiService;

    public View onCreateView(@NonNull LayoutInflater inflater,
                             ViewGroup container, Bundle savedInstanceState) {
        View root = inflater.inflate(R.layout.fragment_home, container, false);

        ServiceContext = getContext();
        ServiceApiService = ApiClient.getAPIService();

        initComponents(root);

        return root;
    }

    @Override
    public void onViewCreated(@NonNull View view, @Nullable Bundle savedInstanceState) {
        super.onViewCreated(view, savedInstanceState);

        ServiceRecyclerView = (RecyclerView) getView().findViewById(R.id.list_home_service);
        ServiceAdapter = new RecyclerViewServiceAdapter(getActivity(),ServiceList);
        ServiceRecyclerView.setLayoutManager(new LinearLayoutManager(getActivity()));
    }

    private void requestServices() {
        ServiceApiService.getAllServicesUserRequest("Bearer " + loadToken()).enqueue(new Callback() {
            @Override
            public void onResponse(Call call, Response response) {
                if (response.isSuccessful()){
                    Log.i("debug", "onResponse: Berhasil");
                    try {
                        ServiceResponse jsonResponse = response.body();
                        JSONObject jsonRESULTS = new JSONObject(jsonResponse.toString());
                        if (jsonRESULTS.getJSONObject("meta").getString("status").equals("success")){
//                            ServiceList = new ArrayList<>(jsonResponse.getServiceResponse());

                            ServiceList = jsonResponse.getServiceResponse();

                            ServiceRecyclerView.setAdapter(ServiceAdapter);
                        } else {
                            String error_message = jsonRESULTS.getString("error_msg");
                            Toast.makeText(ServiceContext, error_message, Toast.LENGTH_SHORT).show();
                        }
                    } catch (JSONException | IOException e) { //Error di sini
                        e.printStackTrace();
                    }
                } else {
                    Log.i("debug", "onResponse: Tidak Berhasil");
                }
            }

            @Override
            public void onFailure(Call call, Throwable t) {
                Log.e("debug", "onFailure: ERROR > " + t.getMessage());
                Toast.makeText(ServiceContext, "Koneksi Internet Bermasalah", Toast.LENGTH_SHORT).show();
            }
        });
    }

    private void initComponents(View root){
        getViewId(root);

        UserName.setText(loadCurrentUserName());

        Toolbar toolbar = (Toolbar) getActivity().findViewById(R.id.toolbar);
        CollapsingToolbarLayout toolBarLayout = (CollapsingToolbarLayout) getActivity().findViewById(R.id.toolbar_layout);
    }

    private void getViewId(View root){
        UserName = root.findViewById(R.id.user_name);
    }

    private String loadToken(){
        final SharedPreferences sharedPreferences = getActivity().getSharedPreferences(SHARED_PREFS_TOKEN, MODE_PRIVATE);

        tokenCache = sharedPreferences.getString(userToken, "");
        return tokenCache;
    }

    private String loadCurrentUserName(){
        final SharedPreferences sharedPreferences = getActivity().getSharedPreferences(SHARED_PREFS_USER, MODE_PRIVATE);

        nameCache = sharedPreferences.getString(userName, "");
        return nameCache;
    }

}
                                                                                     ^

{
    "meta": {
        "code": 200,
        "status": "success",
        "message": "successfully load data"
    },
    "data": [
        {
            "id": 1,
            "name": "Pemasangan infus",
            "information": "pemasangan kateter untuk kegiatan medis",
            "image": "https://via.placeholder.com/300",
            "price": 120000,
            "created_at": "2021-07-29T01:35:43.000000Z",
            "updated_at": "2021-07-29T01:35:43.000000Z"
        },
        {
            "id": 2,
            "name": "Pemasangan infus",
            "information": "pemasangan infus untuk kegiatan medis",
            "image": "https://via.placeholder.com/300",
            "price": 80000,
            "created_at": "2021-07-29T01:35:43.000000Z",
            "updated_at": "2021-07-29T01:35:43.000000Z"
        },
        {
            "id": 3,
            "name": "Perawatan luka jahitan",
            "information": "perawatan luka pasca operasi, umumnya luka jahitan",
            "image": "https://via.placeholder.com/300",
            "price": 70000,
            "created_at": "2021-07-29T01:35:43.000000Z",
            "updated_at": "2021-07-29T01:35:43.000000Z"
        },
        {
            "id": 4,
            "name": "suntik vaksin titan",
            "information": "melakukan suntik untuk mendapatkan kekuatan titan, kekuatan titan yang dihasilkan bersifat acak.",
            "image": "http://149.28.136.231/storage/services/Titan_injection_(Anime).webp",
            "price": 120000,
            "created_at": "2021-07-29T04:11:43.000000Z",
            "updated_at": "2021-07-29T10:17:05.000000Z"
        }
    ]
}

package com.humic.android.homecare.model;

import com.google.gson.annotations.Expose;
import com.google.gson.annotations.SerializedName;

public class Service {

    @SerializedName("id")
    @Expose
    private int id;
    @SerializedName("name")
    @Expose
    private String name;
    @SerializedName("information")
    @Expose
    private String information ;
    @SerializedName("image")
    @Expose
    private String image ;
    @SerializedName("price")
    @Expose
    private int price ;

    public Service() {}

    public Service(int Id, String Name, String Information, String Image, int Price) {
        this.id = Id;
        this.name = Name;
        this.information = Information;
        this.image = Image;
        this.price = Price;
    }

    public int getId() {
        return id;
    }

    public String getName() {
        return name;
    }

    public String getInformation() {
        return information;
    }

    public String getImage() {
        return image;
    }

    public int getPrice() {
        return price;
    }

    public void setId(int Id) {
        this.id = Id;
    }

    public void setName(String Name) {
        this.name = Name;
    }

    public void setInformation(String Information) {
        this.information = Information;
    }

    public void setImage(String Image) {
        this.image = Image;
    }

    public void setPrice(int Price) {
        this.price = Price;
    }

}

package com.humic.android.homecare.rest.service;

import com.google.gson.annotations.SerializedName;
import com.humic.android.homecare.model.Service;

import java.util.ArrayList;

public class ServiceResponse {

    @SerializedName("data")
    ArrayList ServiceResponse;

    public ArrayList getServiceResponse() {
        return ServiceResponse;
    }

    public void setServiceResponse(ArrayList ServiceResponse) {
        this.ServiceResponse = ServiceResponse;
    }
}

package com.humic.android.homecare.adapter;

import android.content.Context;
import android.content.Intent;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ImageView;
import android.widget.TextView;

import androidx.cardview.widget.CardView;
import androidx.recyclerview.widget.RecyclerView;

import com.humic.android.homecare.R;
import com.humic.android.homecare.activity.user.ServiceActivity;
import com.humic.android.homecare.model.Service;

import org.jetbrains.annotations.NotNull;

import java.util.List;

public class RecyclerViewServiceAdapter extends RecyclerView.Adapter {

    private Context serviceContext ;
    private List serviceData ;


    public RecyclerViewServiceAdapter(Context serviceContext, List serviceData) {
        this.serviceContext = serviceContext;
        this.serviceData = serviceData;

    }

    @NotNull
    @Override
    public ServiceViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {

        View view ;
        LayoutInflater mInflater = LayoutInflater.from(serviceContext);
        view = mInflater.inflate(R.layout.item_home_service,parent,false);
        return new ServiceViewHolder(view);

    }

    @Override
    public void onBindViewHolder(ServiceViewHolder holder, final int position) {

        holder.serviceName.setText(serviceData.get(position).getName());
//        holder.serviceThumbnail.setImageResource(serviceData.get(position).getImage());
        holder.serviceCardView.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {

                Intent intent = new Intent(serviceContext, ServiceActivity.class);

                intent.putExtra("name",serviceData.get(position).getName());
                intent.putExtra("information",serviceData.get(position).getInformation());
                intent.putExtra("price",serviceData.get(position).getPrice());
//                intent.putExtra("image",serviceData.get(position).getImage());

                serviceContext.startActivity(intent);

            }

        });

    }

    @Override
    public int getItemCount() {
        return serviceData.size();
    }

    public static class ServiceViewHolder extends RecyclerView.ViewHolder {

        TextView serviceName;
//        ImageView serviceImage;
        CardView serviceCardView ;

        public ServiceViewHolder(View itemView) {
            super(itemView);

            serviceName = (TextView) itemView.findViewById(R.id.list_home_service_title) ;
//            serviceImage = (ImageView) itemView.findViewById(R.id.list_home_service_thumbnail);
            serviceCardView = (CardView) itemView.findViewById(R.id.list_home_service_cardview);

        }

    }

}

package com.humic.android.homecare.rest;

import com.humic.android.homecare.model.Service;

import okhttp3.ResponseBody;
import retrofit2.Call;
import retrofit2.http.Field;
import retrofit2.http.FormUrlEncoded;
import retrofit2.http.GET;
import retrofit2.http.Header;
import retrofit2.http.POST;
import retrofit2.http.Path;
import retrofit2.http.Query;

public interface ApiInterface {
// Services
    @GET("services")
    Call getAllServicesUserRequest(@Header("Authorization") String token);
}

var medis = [...new Map(m.map( o => [o['drugs'][0]['ingredient'].uniqueId, o['drugs'][0]['ingredient'].uniqueId])).values()];

$mcu_hasil_lab = DB::connection($unit_url . '_api_proitweb')
->select(
    'SET ANSI_NULLS ON; SET ANSI_WARNINGS ON; EXEC splbrpt_Cetak_Hasil_MCU_new ?,?,?',
    array($nobukti, '03', '')
);

USE [PROHMS_DEV];
GO

/****** Object:  StoredProcedure [dbo].[splbrpt_Cetak_Hasil_MCU_new]    Script Date: 08/09/2020 17.56.13 ******/

SET ANSI_NULLS ON;
GO
SET QUOTED_IDENTIFIER ON;
GO
ALTER PROCEDURE [dbo].[splbrpt_Cetak_Hasil_MCU_new] @nolab   CHAR(15), 
                                                    @cetakan CHAR(2), 
                                                    @cetak   TEXT
AS
     IF @cetakan = '03'
         BEGIN
             SELECT hd.noreg, 
                    reg.norm, 
                    reg.TglTrans AS tgldaftar, 
                    reg.JamTrans AS jamdaftar, 
                    reg.TglTrans AS tglselesai, 
                    reg.JamTrans AS jamselesai, 
                    reg.umurtahun, 
                    reg.umurbulan, 
                    reg.umurhari, 
                    ks.nmkduser AS pasienseks, 
                    ISNULL(pk.nmkduser, '') AS PekerjaanPasien, 
                    hd.kddokter, 
                    m.nama AS namadokter, 
                    'Pasien Medical Check Up' AS jenispasien, 
                    hd.NoBukti AS nolab, 
                    hd.NoLabLIS AS NoLabLIS, 
                    RTRIM(reg.nama) + ' ' + RTRIM(reg.marga) AS namapasien, 
                    s.kdtest AS kdtestawal, 
                    tsawal.nmtest AS nmtestawal, 
                    s.kdtestakhir AS kdtest, 
                    RTRIM(tsakhir.nmtest) AS nmtest, 
                    s.kdfraction, 
                    f.nmfraction, 
                    ISNULL(su.nmkduser, '') AS UnitMtx, 
                    ISNULL(su2.nmkduser, '') AS UnitMtxInt, 
                    mf.nnormal AS nnormalstd, 
                    mf.nnormalint AS nnormalint, 
                    h.btsmin, 
                    h.btsmax, 
                    h.nilaistd, 
                    h.NilaiStd AS NilaiStdInt, 
                    h.unit, 
                    h.updater, 
                    h.tglupdate, 
                    h.chasilLIS AS cHasil, --DIganti Untuk Baca Cetak Hasil LIS (Hendrik)
                    0 AS nHasil, 
                    0 AS nhasilint,
                    -- h.unit, h.updater, h.tglupdate, h.chasil,   
                    -- h.nhasil, (h.nhasil * mf.KonversiSatuan) as nhasilint,  
                    h.umurhr, 
                    h.umurmax, 
                    h.satumur, 
                    h.nsatumur, 
                    ISNULL(gr.nmgroup, '') AS nmgroup, 
                    ISNULL(kl.nmkel, '') AS nmkel, 
                    gr.urutan, 
                    kl.Urutan AS UrutanKel, 
                    s.nmketerangan, 
                    s.kdketerangan, 
                    dp.nama, 
                    ISNULL(kf.nmkduser, '') AS kelfraction, 
                    'MCU' AS asal, 
                    'MCU' AS poliruang, 
                    hd.CatatanLB AS catatan, 
                    'Medical Check Up' AS nmkelas, 
             (
                 SELECT nilai
                 FROM setvar
                 WHERE app = 'LB_'
                       AND kode = 'dok1'
             ) AS doklab1, 
             (
                 SELECT nilai
                 FROM setvar
                 WHERE app = 'LB_'
                       AND kode = 'dok2'
             ) AS doklab2, 
             (
                 SELECT nilai
                 FROM setvar
                 WHERE app = 'LB_'
                       AND kode = 'penanggungjawab'
             ) AS pnanggungjwb, 
                    RTRIM(reg.Jalan) + ' ' + RTRIM(reg.Gang) AS AlamatPasien, 
                    ISNULL(mf.KonversiSatuan, 0) AS KonversiSatuan,

                    -- untuk hasil laboratorium agar dapat bertingkat  
                    dbo.fGetLevelHasilLB(s.KdKeterangan) AS LevelHasil, 
                    RTRIM(LEFT(CAST(s.KdKeterangan AS VARCHAR(500)), LEN(RTRIM(CAST(s.KdKeterangan AS VARCHAR(500)))) - LEN(RTRIM(s.KdFraction)))) AS KdHeader,

             -- agar bisa sort berdasarkan nomor urut yang ada di Matrix Test - Fraction  
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 2, 'Header') AS HeaderLv02, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 3, 'Header') AS HeaderLv03, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 4, 'Header') AS HeaderLv04, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 5, 'Header') AS HeaderLv05, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 6, 'Header') AS HeaderLv06, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 7, 'Header') AS HeaderLv07, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 8, 'Header') AS HeaderLv08, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 9, 'Header') AS HeaderLv09, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 10, 'Header') AS HeaderLv10, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 2, 'Header_Name') AS HeaderNameLv02, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 3, 'Header_Name') AS HeaderNameLv03, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 4, 'Header_Name') AS HeaderNameLv04, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 5, 'Header_Name') AS HeaderNameLv05, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 6, 'Header_Name') AS HeaderNameLv06, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 7, 'Header_Name') AS HeaderNameLv07, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 8, 'Header_Name') AS HeaderNameLv08, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 9, 'Header_Name') AS HeaderNameLv09, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 10, 'Header_Name') AS HeaderNameLv10, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 2, 'NoUrut') AS NoUrutLv02, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 3, 'NoUrut') AS NoUrutLv03, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 4, 'NoUrut') AS NoUrutLv04, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 5, 'NoUrut') AS NoUrutLv05, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 6, 'NoUrut') AS NoUrutLv06, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 7, 'NoUrut') AS NoUrutLv07, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 8, 'NoUrut') AS NoUrutLv08, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 9, 'NoUrut') AS NoUrutLv09, 
                    dbo.fGetNoUrutHasilLB(s.KdKeterangan, 10, 'NoUrut') AS NoUrutLv10, 
                    h.metode
             FROM mcu_HdTransaksi hd
                  INNER JOIN mcu_reg reg ON reg.noreg = hd.noreg
                  INNER JOIN medis m ON m.kode = hd.kddokter
                  INNER JOIN
             (
                 SELECT kduser, 
                        nmkduser
                 FROM stdfielddt
                 WHERE kdfield = 'kdseks'
             ) ks ON reg.kdseks = ks.kduser
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser
                 FROM stdfielddt
                 WHERE kdfield = 'pekerjaan'
             ) pk ON pk.kduser = reg.kdpekerjaan
                  INNER JOIN lb_strukturmcu s ON s.nolab = hd.nobukti
                  INNER JOIN lb_test tsawal ON tsawal.kdtest = s.kdtest
                  INNER JOIN lb_test tsakhir ON tsakhir.kdtest = s.kdtestakhir
                  INNER JOIN lb_fraction f ON f.kdfraction = s.kdfraction
                  INNER JOIN lb_hasilmcu h ON h.nobukti = s.nolab
                                              AND h.kdfraction = s.kdfraction
                                              AND s.kdtestakhir = h.kdtest
                  LEFT JOIN lb_mtxtestfr mf ON mf.kdfraction = h.kdfraction
                                               AND mf.kdtest = s.kdtestakhir
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser
                 FROM stdfielddt
                 WHERE kdfield = 'lb_unit'
             ) su ON su.kduser = mf.unit
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser
                 FROM stdfielddt
                 WHERE kdfield = 'lb_unit'
             ) su2 ON su2.kduser = mf.unitint
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser
                 FROM stdfielddt
                 WHERE kdfield = 'lb_klfr'
             ) kf ON kf.kduser = f.deskripsi
                  LEFT JOIN lb_group gr ON gr.kdgroup = tsakhir.kdgroup
                  LEFT JOIN lb_kel kl ON kl.kdkel = tsakhir.kdkel
                                         AND tsakhir.kdgroup = kl.kdgroup
                  CROSS JOIN
             (
                 SELECT nama, 
                        nilai
                 FROM setvar
                 WHERE kode = 'dokpat'
             ) dp
             WHERE hd.ValidLB = 1
                   AND hd.nobukti = @nolab
                   AND gr.cetakan = '01'          
                   -- And @cetak like '%' + rtrim(f.kdfraction)+',%'   
                   --start-tambahan jeff: protek cetakan lama utk data lama only
                   AND hd.tglvalidasiLB >= '2012-06-01'      
             --end-tambahan jeff: 2012-12-10

             ORDER BY HeaderLv02, 
                      NoUrutLv02, 
                      HeaderLv03, 
                      NoUrutLv03, 
                      HeaderLv04, 
                      NoUrutLv04, 
                      HeaderLv05, 
                      NoUrutLv05, 
                      HeaderLv06, 
                      NoUrutLv06, 
                      HeaderLv07, 
                      NoUrutLv07, 
                      HeaderLv08, 
                      NoUrutLv08, 
                      HeaderLv09, 
                      NoUrutLv09, 
                      HeaderLv10, 
                      NoUrutLv10, 
                      s.kdfraction;
         END;
         ELSE
         BEGIN
             SELECT hd.noreg, 
                    reg.norm, 
                    reg.TglTrans AS tgldaftar, 
                    reg.JamTrans AS jamdaftar, 
                    reg.TglTrans AS tglselesai, 
                    reg.JamTrans AS jamselesai, 
                    reg.umurtahun, 
                    reg.umurbulan, 
                    reg.umurhari, 
                    ks.keterangan AS pasienseks, 
                    ISNULL(pk.nmkduser, '') AS PekerjaanPasien, 
                    hd.kddokter, 
                    m.nama AS namadokter, 
                    'Pasien Medical Check Up' AS jenispasien, 
                    hd.NoBukti AS nolab, 
                    hd.NoLabLIS AS NoLabLIS, 
                    RTRIM(reg.nama) + ' ' + RTRIM(reg.marga) AS namapasien, 
                    s.kdtest AS kdtestawal, 
                    tsawal.nmtest2 AS nmtestawal, 
                    s.kdtestakhir AS kdtest, 
                    RTRIM(tsakhir.nmtest2) AS nmtest, 
                    s.kdfraction, 
                    f.nmfraction2, 
                    ISNULL(su.nmkduser, '') AS UnitMtx, 
                    ISNULL(su2.nmkduser, '') AS UnitMtxInt, 
                    mf.nnormal AS nnormalstd, 
                    mf.nnormalint AS nnormalint, 
                    h.btsmin, 
                    h.btsmax, 
                    h.nilaistd, 
                    h.NilaiStd AS NilaiStdInt,  
                    -- h.unit, h.updater, h.tglupdate, h.chasil,   
                    -- h.nhasil, (h.nhasil * mf.KonversiSatuan) as nhasilint,  
                    h.unit, 
                    h.updater, 
                    h.tglupdate, 
                    h.chasilLIS AS cHasil, --DIganti Untuk Baca Cetak Hasil LIS (Hendrik)
                    0 AS nHasil, 
                    0 AS nhasilint, 
                    h.umurhr, 
                    h.umurmax, 
                    h.satumur, 
                    h.nsatumur, 
                    ISNULL(gr.nmgroup2, '') AS nmgroup, 
                    ISNULL(kl.nmkel, '') AS nmkel, 
                    gr.urutan, 
                    kl.Urutan AS UrutanKel, 
                    s.nmketerangan, 
                    s.kdketerangan, 
                    dp.nama, 
                    ISNULL(kf.nmkduser, '') AS kelfraction, 
                    'MCU' AS asal, 
                    'MCU' AS poliruang, 
                    hd.CatatanLB AS catatan, 
                    'Medical Check Up' AS nmkelas, 
             (
                 SELECT nilai
                 FROM setvar
                 WHERE app = 'LB_'
                       AND kode = 'dok1'
             ) AS doklab1, 
             (
                 SELECT nilai
                 FROM setvar
                 WHERE app = 'LB_'
                       AND kode = 'dok2'
             ) AS doklab2, 
             (
                 SELECT nilai
                 FROM setvar
                 WHERE app = 'LB_'
                       AND kode = 'penanggungjawab'
             ) AS pnanggungjwb, 
                    RTRIM(reg.Jalan) + ' ' + RTRIM(reg.Gang) AS AlamatPasien, 
                    ISNULL(mf.KonversiSatuan, 0) AS KonversiSatuan,

                    -- untuk hasil laboratorium agar dapat bertingkat  
                    dbo.fGetLevelHasilLB(s.KdKeterangan) AS LevelHasil, 
                    RTRIM(LEFT(CAST(s.KdKeterangan AS VARCHAR(500)), LEN(RTRIM(CAST(s.KdKeterangan AS VARCHAR(500)))) - LEN(RTRIM(s.KdFraction)))) AS KdHeader,

             -- agar bisa sort berdasarkan nomor urut yang ada di Matrix Test - Fraction  
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 2, 'Header') AS HeaderLv02, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 3, 'Header') AS HeaderLv03, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 4, 'Header') AS HeaderLv04, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 5, 'Header') AS HeaderLv05, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 6, 'Header') AS HeaderLv06, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 7, 'Header') AS HeaderLv07, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 8, 'Header') AS HeaderLv08, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 9, 'Header') AS HeaderLv09, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 10, 'Header') AS HeaderLv10, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 2, 'Header_Name') AS HeaderNameLv02, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 3, 'Header_Name') AS HeaderNameLv03, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 4, 'Header_Name') AS HeaderNameLv04, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 5, 'Header_Name') AS HeaderNameLv05, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 6, 'Header_Name') AS HeaderNameLv06, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 7, 'Header_Name') AS HeaderNameLv07, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 8, 'Header_Name') AS HeaderNameLv08, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 9, 'Header_Name') AS HeaderNameLv09, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 10, 'Header_Name') AS HeaderNameLv10, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 2, 'NoUrut') AS NoUrutLv02, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 3, 'NoUrut') AS NoUrutLv03, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 4, 'NoUrut') AS NoUrutLv04, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 5, 'NoUrut') AS NoUrutLv05, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 6, 'NoUrut') AS NoUrutLv06, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 7, 'NoUrut') AS NoUrutLv07, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 8, 'NoUrut') AS NoUrutLv08, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 9, 'NoUrut') AS NoUrutLv09, 
                    dbo.fGetNoUrutHasilLBING(s.KdKeterangan, 10, 'NoUrut') AS NoUrutLv10
             FROM mcu_HdTransaksi hd
                  INNER JOIN mcu_reg reg ON reg.noreg = hd.noreg
                  INNER JOIN medis m ON m.kode = hd.kddokter
                  INNER JOIN
             (
                 SELECT kduser, 
                        nmkduser, 
                        keterangan
                 FROM stdfielddt
                 WHERE kdfield = 'kdseks'
             ) ks ON reg.kdseks = ks.kduser
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser, 
                        keterangan
                 FROM stdfielddt
                 WHERE kdfield = 'pekerjaan'
             ) pk ON pk.kduser = reg.kdpekerjaan
                  INNER JOIN lb_strukturmcu s ON s.nolab = hd.nobukti
                  INNER JOIN lb_test tsawal ON tsawal.kdtest = s.kdtest
                  INNER JOIN lb_test tsakhir ON tsakhir.kdtest = s.kdtestakhir
                  INNER JOIN lb_fraction f ON f.kdfraction = s.kdfraction
                  INNER JOIN lb_hasilmcu h ON h.nobukti = s.nolab
                                              AND h.kdfraction = s.kdfraction
                                              AND s.kdtestakhir = h.kdtest
                  LEFT JOIN lb_mtxtestfr mf ON mf.kdfraction = h.kdfraction
                                               AND mf.kdtest = s.kdtestakhir
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser, 
                        keterangan
                 FROM stdfielddt
                 WHERE kdfield = 'lb_unit'
             ) su ON su.kduser = mf.unit
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser, 
                        keterangan
                 FROM stdfielddt
                 WHERE kdfield = 'lb_unit'
             ) su2 ON su2.kduser = mf.unitint
                  LEFT JOIN
             (
                 SELECT kduser, 
                        nmkduser, 
                        keterangan
                 FROM stdfielddt
                 WHERE kdfield = 'lb_klfr'
             ) kf ON kf.kduser = f.deskripsi
                  LEFT JOIN lb_group gr ON gr.kdgroup = tsakhir.kdgroup
                  LEFT JOIN lb_kel kl ON kl.kdkel = tsakhir.kdkel
                                         AND tsakhir.kdgroup = kl.kdgroup
                  CROSS JOIN
             (
                 SELECT nama, 
                        nilai
                 FROM setvar
                 WHERE kode = 'dokpat'
             ) dp
             WHERE hd.ValidLB = 1
                   AND hd.nobukti = @nolab
                   AND gr.cetakan = '01'          
                   -- And @cetak like '%' + rtrim(f.kdfraction)+',%'  
                   --start-tambahan jeff: protek cetakan lama utk data lama only
                   AND hd.tglvalidasiLB >= '2012-06-01'      
             --end-tambahan jeff: 2012-12-10

             ORDER BY HeaderLv02, 
                      NoUrutLv02, 
                      HeaderLv03, 
                      NoUrutLv03, 
                      HeaderLv04, 
                      NoUrutLv04, 
                      HeaderLv05, 
                      NoUrutLv05, 
                      HeaderLv06, 
                      NoUrutLv06, 
                      HeaderLv07, 
                      NoUrutLv07, 
                      HeaderLv08, 
                      NoUrutLv08, 
                      HeaderLv09, 
                      NoUrutLv09, 
                      HeaderLv10, 
                      NoUrutLv10, 
                      s.kdfraction;
         END;

JENIS AKTIVA: 

   + tambah


XInfrastruktur dan Alat Non Medis Ket: 

@app.route('/modi',methods=['GET','POST'])
@login_required
def IssMed():
    form = medis()
    if form.validate_on_submit():
        flash("Ok")
        redirect(url_for('ViewMedicine'))
    return render_template('issuemedicine.html',form=form)

class medis(FlaskForm):
    name = StringField("Medicine Name",validators=[Optional()])
    qty = IntegerField("Quantity",validators=[Optional()])
    submit = SubmitField('Issue')

{% extends "base.html" %}

{% block content %}



  {{form.name.label}} {{form.name()}}
  {{form.qty.label()}} {{form.qty()}}
  {{form.submit()}}


{% endblock %}

> dput(train <- data[train_ind, ])
structure(list(CATEGORY_NAME = structure(c(7L, 8L, 4L, 4L, 5L, 
6L, 7L, 13L, 10L, 8L, 5L, 2L, 6L, 14L, 4L, 4L, 6L, 5L, 13L, 7L, 
5L, 14L, 13L, 14L, 10L, 13L, 7L, 6L, 14L, 8L, 6L, 3L, 2L, 8L, 
8L, 2L, 6L, 6L, 6L, 2L, 3L, 14L, 4L, 15L, 6L, 5L, 14L, 7L, 13L, 
12L, 14L, 13L, 4L, 8L, 6L, 8L, 7L, 7L, 7L, 13L, 7L, 14L, 8L, 
14L, 3L, 3L, 4L, 6L, 6L, 4L, 2L, 14L, 14L, 13L, 4L, 5L, 3L, 14L, 
6L, 6L, 8L, 14L, 6L, 14L, 4L, 14L, 5L, 8L, 3L, 8L, 5L, 14L, 14L, 
2L, 4L, 5L, 8L, 4L, 5L, 6L, 14L, 14L, 14L, 4L, 14L, 5L, 6L, 14L, 
3L), .Label = c("AUDIT", "DEFAULT", "DOCUMENTATION - BILLING", 
"DOCUMENTATION - COLLECTIONS", "DUPLICATE CLAIM", "INCORRECT CLAIM", 
"INCORRECT PAYER", "INVALID AUTHORIZATION", "INVALID DIAGNOSIS", 
"INVALID PRESCRIBER/PROVIDER", "NULL", "PATIENT NOT COVERED", 
"SERVICE NOT COVERED - CLEARANCE", "SERVICE NOT COVERED - COLLECTIONS", 
"TIMELY FILING"), class = "factor"), THERAPY2013ROLLUP = structure(c(2L, 
1L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 1L, 4L, 1L, 4L, 1L, 1L, 1L, 3L, 
1L, 1L, 2L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 
1L, 1L, 2L, 1L, 1L, 1L, 1L, 1L, 2L, 1L, 1L, 2L, 2L, 2L, 1L, 1L, 
1L, 3L, 1L, 1L, 1L, 1L, 1L, 1L, 2L, 1L, 1L, 1L, 2L, 1L, 1L, 1L, 
1L, 1L, 1L, 2L, 2L, 1L, 2L, 1L, 2L, 1L, 1L, 2L, 1L, 2L, 2L, 1L, 
2L, 1L, 1L, 2L, 1L, 1L, 1L, 1L, 2L, 1L, 2L, 2L, 1L, 2L, 2L, 1L, 
1L, 2L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 4L, 2L, 2L), .Label = c("ADVANCED", 
"CORE", "ONCOLOGY", "RARE"), class = "factor"), PAT_PAYOR_NAME = structure(c(221L, 
63L, 227L, 8L, 8L, 63L, 67L, 280L, 375L, 64L, 8L, 447L, 187L, 
276L, 450L, 116L, 185L, 159L, 447L, 221L, 247L, 442L, 447L, 153L, 
484L, 8L, 395L, 113L, 205L, 63L, 447L, 169L, 275L, 63L, 69L, 
187L, 211L, 66L, 403L, 447L, 64L, 185L, 208L, 447L, 185L, 185L, 
205L, 63L, 280L, 447L, 185L, 63L, 64L, 63L, 113L, 468L, 66L, 
287L, 67L, 8L, 67L, 185L, 185L, 63L, 442L, 447L, 67L, 447L, 447L, 
57L, 8L, 375L, 447L, 280L, 8L, 450L, 70L, 8L, 185L, 185L, 63L, 
442L, 185L, 377L, 185L, 459L, 326L, 447L, 447L, 276L, 8L, 187L, 
288L, 86L, 185L, 252L, 468L, 447L, 210L, 277L, 219L, 185L, 113L, 
447L, 88L, 450L, 187L, 375L, 185L), .Label = c("AARP", "AARP HEALTHCARE OPTIONS", 
"ABBOTT LABORATORIES", "ACCLAIM", "ACCOUNTABLE HEALTH CARE IPA", 
"ADMINISTRATIVE CONCEPTS", "ADVOCATE HEALTH CARE", "AETNA", "AETNA - LUXTURNA ONLY", 
"AETNA - LUXTURNA ONLY\t\t", "AFFINITY MEDICAL GROUP", "AFLAC", 
"ALL SAVERS HEALTH PLAN", "ALLCARE- IPA", "ALLEGIANCE BENEFIT PLAN MANAGEMENT", 
"ALLEN COUNTY REGIONAL HOSPITAL", "ALLIANCE HEALTH AND LIFE", 
"ALLIANT HEALTH PLAN", "ALLIED BENEFIT SYSTEMS INC", "ALLSTATE INSURANCE COMPANY", 
"ALLWAYS HLTH PRTNRS-FKA NHP MASS", "ALTA BATES MEDICAL GROUP", 
"AM FIRST", "AMA INSURANCE AGENCY", "AMBETTER AZ COMPLETE HLTH-LUXTURNA", 
"AMEDISYS HOSPICE\t\t", "AMERAPLAN HRA", "AMERIBEN SOLUTIONS", 
"AMERICAN MEDICAL SECURITY", "AMERICAN NATIONAL INSURANCE COMPANY", 
"AMERICAN POSTAL WORKERS UN HLTH PLN", "AMERICAN POSTAL WORKERS UNION", 
"AMERICAN REPUBLIC INS", "APPLECARE MEDICAL GROUP DRUG ONLY", 
"APWU HEALTH PLAN", "APWU HEALTH PLAN PD NURSING ONLY", "ARISE HEALTH PLAN (FORMERLY WPS)", 
"ASHWAUBENON SCHOOL DISTRICT", "ASSOC AND SOCIETY INSURANCE", 
"ASURIS NORTHWEST HEALTH", "ATLANTIC HEALTH", "AULTCARE", "AURORA HEALTH CARE", 
"AUXIANT", "AUXIANT HEALTH", "AVMED", "BANKERS LIFE & CASUALTY", 
"BAYCARE HOMECARE / MNGD CARE OFF", "BAYLOR UNIVERSITY MEDICAL CENTER", 
"BCBS MT-HEALTH CARE SVC CORP DRUG", "BEAVER MEDICAL GROUP", 
"BORGESS MEDICAL CENTER", "BOSTON MEDICAL CENTER", "BRAZOSPORT REG HEALTHCARE SYSTEMS", 
"BRIGHAM AND WOMEN'S HOSPITAL", "BROOKDALE WESTLAKE HILLS SNF", 
"BROWN & TOLAND MEDICAL GRP", "BROWN & TOLAND PHYSICIANS EAST BAY", 
"BROWN & TOLAND PHYSICIANS WEST BAY", "BUCHANAN METAL FORMING", 
"BUTTERWORTH HOSPITAL", "CAPITAL DISTRICT PHYSICIANS HLTH PL", 
"CARECENTRIX", "CARECENTRIX DRUG ONLY", "CARECENTRIX FL BLUE DRUG ONLY", 
"CARECENTRIX FL BLUE PD PRNV", "CARECENTRIX HORIZ BCBS NJ DRUG ONLY", 
"CARECENTRIX HORIZ BCBS NJ PD PRNV", "CARECENTRIX PD/PRNV ONLY", 
"CARESOURCE", "CAROLINA HEALTH SYSTEMS", "CARPENTERS HEALTH & WELFARE", 
"CARPENTERS UNION", "CAYUGA ONONDAGA AREA SCHOOLS", "CEDARS SINAI HEALTH ASSOCIATES", 
"CEDARS SINAI MEDICAL GROUP", "CENTRAL RESERVE LIFE", "CHANGE HEALTHCARE", 
"CHILDREN'S NATIONAL MEDICAL CTR", "CHILDRENS COMMUNITY HEALTH PLAN", 
"CHILDRENS HOSPITAL", "CHILDRENS HOSPITAL OF PHILADELPHIA", "CHRISTIAN BROTHERS SERVICES", 
"CHRISTIAN CARE MINISTRY MEDI-SHARE", "CHRISTUS SPOHN HOSP SHORELINE", 
"CIGNA", "CIGNA - LUXTURNA ONLY", "CIGNA HEALTHCARE", "CIGNA MEDICAL", 
"CIGNA MEDICAL DRUGS ONLY", "CIGNA MEDICAL FEDEX", "CIGNA MEDICAL FEDEX DRUGS ONLY", 
"CIGNA MEDICAL NURSING ONLY", "CIGNA MEDICAL PER DIEMS ONLY", 
"CIGNA MEDICAL UPS", "CIGNA MEDICAL UPS DRUGS ONLY", "CINCINNATI CLAIMS FOR WORKERS COMP", 
"CITY OF LEXINGTON", "CLALIT HEALTH SERVICES", "CLARION HLTH METHODIST HOSPITAL", 
"CLARK COUNTY SCHOOL DISTRICT", "CLEVELAND CLINIC", "COASTAL COMM PHYSICIAN NETWORK IPA", 
"COFINITY", "COLONIAL MEDICAL INSURANCE CO", "COMBINED INSURANCE CO OF AMERICA", 
"COMMON GROUND HEALTHCARE", "COMMUNITY CARE", "COMMUNITY CARE HEALTH & LIFE", 
"COMMUNITY FIRST HEALTH PLANS", "COMMUNITY HEALTH CHOICE", "COMP MANAGEMENT HEALTH SYSTEMS-SXC", 
"COMPASS ROSE HEALTH PLAN", "COMPMANAGEMENT HEALTH SYSTEMS", 
"CONIFER HEALTH SOLUTIONS", "CONNECTICARE", "CONTRA COSTA HEALTH PLAN", 
"COOK AND COMPANY", "CORPORATE MGD HLTH SVCS-DIVERSIFIED", "COUNTRY LIFE", 
"COVENTRY HEALTH CARE", "COVENTRY HEALTH CARE-MERCY HEALTH", 
"CROWN CORK & SEAL COMPANY INC", "CUSHMAN AND WAKEFIELD", "CVS PHARMACY INC-ZOLGENSMA", 
"DAKOTACARE", "DEAN HEALTH PLAN INC", "DECATUR MEM HOSP-CENTRAL IL HLTH", 
"DESERET MUTUAL BENEFITS", "DEX IMAGING", "DIGNITY HEALTH MEDICAL FOUNDATION", 
"EAST BATON ROUGE SHERIFFS OFFICE", "EAST BOSTON NEIGHBORHOOD HLTH CTR", 
"EASTERN MAINE HEALTH SYSTEM", "EBIX HLTH ADMIN EXCHANGE", "EBMS-EMPLOYEE BENEFIT MGMT SVC", 
"EDUCATORS MUTUAL", "EDWARD C. LEVY", "ELLIS HOSPITAL", "EMBASSY OF SAUDI ARABIA", 
"EMBASSY OF SAUDI ARABIA AFO", "EMBASSY OF THE STATE OF KUWAIT HLTH", 
"EMBASSY OF THE STATE OF QATAR", "EMBASSY OF THE UNITED ARAB EMIRATES", 
"EMI HEALTH", "EMPIRE PHYSICIANS MEDICAL GROUP", "EQUIAN-CATAMARAN", 
"EQUITABLE", "ERIE INSURANCE", "FACILITY HOSPITAL/ PHARMACY", 
"FACILITY HOSPITAL/PHARMACY", "FALLON COMMUNITY HEALTH PLAN", 
"FAMILY CARE SPECIALIST", "FAMILY CARE SPECIALISTS", "FARMERS TELEPHONE COOPERATIVE", 
"FEDERAL REPUBLIC OF GERMANY", "FIDELIS CARE OF NEW YORK", "FIRST CARE", 
"FIRST CAROLINA CARE", "FIRST CHOICE HEALTH", "FIRST CHOICE HEALTH PLAN", 
"FIRST CHOICE MEDICAL GROUP", "FIRSTCARE HEALTH PLANS", "FISHBACK FINANCIAL CORPORATION", 
"FMH BENEFIT SERVICES", "FMH BENEFITS-CORESOURCE", "FORT SANDERS REGIONAL MEDICAL CTR", 
"GARNETT AND COWLES INSURANCE", "GEHA", "GEHA(GOVT EMP HLTH ASSOC)", 
"GEISINGER HEALTH PLAN", "GENERAL BUILDING LABORORS LOCAL 66", 
"GERBER LIFE INSURANCE", "GILBERT PUBLIC SCHOOL", "GILSBAR INC", 
"GLOBAL CARE", "GOLDEN RULE INSURANCE CO", "GOLDEN TRIANGLE SPEC NTWRK DRG ONLY", 
"GOLDEN TRIANGLE SPECIALTY NETWORK", "GREAT AMERICAN LIFE INS", 
"GREENSPRING VILLAGE", "GREENVILLE MEMORIAL MED CNTR", "GROUP & PENSION ADM", 
"GROUP HEALTH COOP SC WISCONSIN", "GROUP HEALTH INC (GHI)", "GROUP HEALTH INC (GHI)-HOME", 
"GROUP HEALTH INC (GHI)-OFFICE", "HALFF ASSOCIATES", "HARTFORD INSURANCE CO", 
"HARTFORD LIFE INSURANCE CO", "HARVARD PILGRIM HEALTH CARE INC", 
"HARVARD PILGRIM HEALTH CARE INC1133", "HEALTH ALLIANCE PLAN", 
"HEALTH ALLIANCE PLAN OF MICHIGAN", "HEALTH CARE LA IPA", "HEALTH CARE PARTNERS", 
"HEALTH CHOICE", "HEALTH CHOICE OF OK", "HEALTH CHOICE OF OKLAHOMA", 
"HEALTH DESIGN PLUS", "HEALTH EZ", "HEALTH FIRST HEALTH PLANS", 
"HEALTH FIRST HEALTH PLANS FLORIDA", "HEALTH NET OF AZ", "HEALTH NET OF CA", 
"HEALTH NET OF OR", "HEALTH NEW ENGLAND", "HEALTH PARTNERS", 
"HEALTH PARTNERS OF MN", "HEALTH PLAN OF NEVADA", "HEALTH PLAN OF UPPER OHIO VALLEY", 
"HEALTH PLANS INC", "HEALTH PLUS PHYSICIANS ORGANIZATION", "HEALTH SELECT", 
"HEALTHCARE PARTNERS", "HEALTHCARE PARTNERS OF NV- IPA", "HEALTHFIRST", 
"HEALTHGRAM", "HEALTHLINK", "HEALTHSCOPE", "HEALTHSMART", "HEALTHSOUTH REHABILITATION HOSPITAL", 
"HENDRICK MANAGEMENT", "HIGH DESERT MEDICAL GROUP", "HILL COUNTRY MEMORIAL HOSPITAL", 
"HILMAR CHEESE COMPANY", "HIP OF NY", "HIP OF NY-HOME", "HISPANIC PHYSICIANS IPA", 
"HOMETOWN HEALTH PLAN", "HOSPICE OF THE WEST", "HOSPITAL/MEDICAL CTR", 
"HUMANA", "HUMANA INC", "HYDRO-GEAR", "IBEW", "IBEW LOCAL 25 HEALTH & BENEFIT FUND", 
"IBEW LOCAL UNION 3", "ILWU-PMA COASTWISE", "IMPERIAL HEALTH HOLDINGS", 
"INDEPENDENT HEALTH ASSOCIATION", "INDIAN HEALTH SERVICES", "INNOVAGE CA PACE", 
"INSURANCE SERVICES OF LUBBOCK", "IOUE LOCAL 825", "JOHNS HOPKINS HEALTHCARE", 
"JOINT IND BRD ELECTRICAL", "JP FARLEY CORPORATION", "KAISER EDI TESTING ONLY", 
"KAISER FOUNDATION HEALTH PLAN", "KAISER FOUNDATION HEALTH PLAN INC", 
"KAISER FOUNDATION HLTPLN WA FKA GHC", "KAISER PERMANENTE", "KAISER PERMANENTE NORTHERN CA", 
"KAISER PERMANENTE OF GEORGIA", "KAISER PERMANENTE OF HAWAII", 
"KAISER PERMANENTE OF NORTHWEST", "KAISER PERMANENTE SELF FUNDED PLAN", 
"KAISER PERMANENTE SOUTHERN CA", "KEARNY MESA RHAB CTR", "KINDRED HOSPICE", 
"KINDRED HOSPITAL", "LIBERTY NATIONAL", "LOCAL 342 WELFARE FUND", 
"LSU FIRST", "M S HERSHEY MEDICAL", "MAGNACARE", "MAILHANDLERS", 
"MARIS GROVE INC", "MARSH AFFINITY GROUP SERVICES", "MASSACHUSETTS GENERAL HOSPITAL", 
"MAYO HEALTH SYSTEMS", "MCLAREN HEALTH PLAN", "MCS  LIFE INSURANCE", 
"MED PAY", "MEDICA", "MEDICA CHOICE", "MEDICAL CENTER", "MEDICAL CENTER OF GEORGIA", 
"MEDICAL MUTUAL OF OHIO", "MEDONE PHARMACY SERVICES", "MEMBERS HEALTH INSURANCE", 
"MEMORIAL HEALTH CARE IPA", "MEMORIAL HEALTHCARE SYSTEM", "MERCY CARE HEALTH PLAN", 
"MERCY PHYSICIANS MEDICAL GROUP", "MERITAGE MED NTWK FKA MARIN SONOMA", 
"MERITAIN HEALTH", "MIDWEST POULTRY SERVICES", "MISSION HOSPITAL INCORPORATED", 
"MODA HEALTH", "MOHEGAN TRIBE OF CT", "MONARCH HEALTHCARE", "MONARCH MEDICAL GROUP", 
"MONTEFIORE CMO", "MUSICIANS LOCAL 802", "MUTUAL OF OMAHA", "MVP HEALTH PLAN", 
"MVP HEALTHCARE", "NASI - NATIONAL AUTOMATIC SPRINKLER", "NATIONAL BENEFIT FUND 1199", 
"NATIONAL POSTAL MAIL HANDLERS", "NATIONWIDE INSURANCE", "NEIGHBORHOOD HEALTH PLAN MASS", 
"NETWORK HEALTH PLAN MCARE ADVANTAGE", "NEW MEXICO MEDICAL INSURANCE POOL", 
"NEW MEXICO MEDICAL INSURANCE POOL\t", "NEW MEXICO MEDICAL INSURANCE POOL\t\t", 
"NEW YORK CITY LAW DEPT", "NEW YORK HOTEL TRADE", "NEW YORK UNIVERSITY", 
"NEXCALIBER", "NIVANO PHYS DBA SIERRA NV MED ASSOC", "NJ CARPENTER HEALTH FUND", 
"NOBLE HORIZONS", "NORTH AMERICA ADMINISTRATORS", "NORTH TX SPECIALTY PHYSICIANS", 
"NORTH TX SPECIALTY PHYSICIANS\t\t", "NORTHEAST GA MEDICAL HLTH PARTNERS", 
"NORTHERN IL HEALTH PLAN", "NYSTROM & ASSOCIATES LTD", "OCONEE REGIONAL", 
"OLYMPUS MANAGED HEALTHCARE INC", "ONEIDA NATION OF WISCONSIN", 
"OPTIMA", "OPTIMA HEALTH", "OPTIMA HEALTH PLAN", "OPTUM CARE NETWORK CONNECTICUT", 
"OSI ENVIRONMENTAL", "OXFORD HEALTH PLAN", "PACE WORKERS COMP-MAGELLAN", 
"PACIFIC SOURCE HEALTH PLANS", "PALM BEACH COUNTY FIREFIGHTERS", 
"PAM SPECIALTY HOSPITAL COVINGTON", "PARAGON BENEFITS INC", "PARAMOUNT", 
"PARK CITY PRESBYTERIAN", "PEKIN LIFE INSURANCE", "PETERSON, BEYENHOF & ZAHLER LTD", 
"PHP OF MID MICHIGAN", "PHYSICIANS MED GRP SANTA CRUZ", "PHYSICIANS OF SW WASHINGTON", 
"PHYSICIANS PLUS INSURANCE CORP", "PLANNED ADMINISTRATORS INC (PAI)", 
"PLUMBERS & PIPEFITTERS", "POMCO", "POMONA VALLEY MEDICAL GROUP", 
"PREFERRED HEALTH PROFESSIONALS", "PREFERRED ONE ADMINISTRATIVE SERVIC", 
"PREFERRED ONE COMMUNITY HEALTH PLAN", "PRESBYTERIAN HEALTH PLAN", 
"PRIMECARE MED NTWK-CORONA", "PRIMECARE MED NTWK-HEMET VALLEY", 
"PRIMECARE MED NTWK-PHYSICIAN NTWK", "PRIMECARE MED NTWK-TEMECULA", 
"PRIMECARE MED NTWK - CORONA", "PRINCIPAL LIFE INSURANCE COMPANY", 
"PRIORITY HEALTH", "PRIVATE HEALTH CARE SYSTEMS", "PROSPECT MEDICAL GROUP", 
"PROVIDENCE HEALTH PLAN", "PROVIDRS CARE NETWORK FKA WPPA", "PUBLIC EMPLOYEES HEALTH PLAN", 
"QUAL CHOICE OF ARKANSAS", "QUALCARE", "QUALCHOICE OF ARKANSAS", 
"QUIKTRIP", "RATHJE ENTERPRISES INC", "REGAL MEDICAL GROUP", 
"REHABILITATION HOSPITAL OF IN", "RIVER CITY MEDICAL GROUP", 
"RUSH UNIVERSITY MEDICAL CENTER", "SALT RIVER PROJECT", "SAMBA", 
"SANFORD HEALTH PLAN", "SANTA BARBARA SELECT", "SCOTT & WHITE HEALTH PLAN", 
"SCOTTSDALE HEALTH CARE", "SEAMAN CORPORATION", "SEAVIEW MEDICAL GROUP", 
"SECURITY HEALTH PLAN", "SELECT CARE", "SELECT HEALTH FKA INTERMOUNTAIN", 
"SELECT HEALTH FORMERLY IHC", "SELMAN AND COMPANY", "SENTARA HEALTH MANAGEMENT", 
"SENTARA HEALTHCARE", "SENTRY INSURANCE WORKERS COMP", "SERVICE EMPLOYEES INTL UNION (SEIU)", 
"SHARP COMMUNITY MEDICAL GROUP", "SHARP HEALTH CARE", "SHARP HEALTH PLAN", 
"SHEPPARD PRATT HOSPITAL", "SHILAND FAMILY MEDICINE", "SIERRA HEALTH & LIFE", 
"SIERRA HEALTH AND LIFE", "SIERRA HEALTH SERVICES", "SIERRA MEDICAL GROUP", 
"SOUTHEAST GEORGIA REG MED CENTER", "SOUTHWESTERN HEALTH RESOURCES", 
"SPECTRA ENERGY", "SPRAYING SYSTEMS CO", "ST JOSEPH HERITAGE HEALTH", 
"ST JOSEPH HERITAGE HEALTHCARE", "ST JOSEPH HOSPITAL", "ST JUDE HERITAGE MEDICAL GROUP", 
"ST MARYS HOSPITAL", "ST VINCENT MEDICAL GROUP", "ST. JOHN'S HOSPITAL", 
"STATE FARM HEALTH CARE CLAIMS", "STATE OF ILLINOIS EMPLOYEES", 
"STATE OF NEVADA", "STEWART C MILLER COMPANY INC", "STEWART TILE", 
"STONERIVER PHARMACY SOLUTIONS", "SUBURBAN EMPLOYEE SERVICES", 
"SUFFOLK COUNTY RISK MANAGEMENT", "SUMMACARE", "SUTTER HEALTH", 
"SUTTER MEDICAL FOUNDATION", "SYCUAN BAND OF THE KUMEYAAY NATION", 
"SYRACUSE CITY SCHOOLS", "TAMPA GENERAL HOSPITAL", "TEAMSTERS HEALTH & WELFARE", 
"TEAMSTERS WESTERN REGION LOCAL 177", "TERREBONNE SCHOOL BOARD", 
"THE EDGEWOOD CENTRE", "THE HEALTH PLAN OF THE UPPER OH VLY", 
"TOLEDO ELECTRICAL WELFARE FUND", "TRANSAMERICA LIFE (FKA STONEBRIDGE)", 
"TRI STATE HEALTH AND WELFARE", "TUFTS HEALTH PLAN", "UC SAN DIEGO HEALTH", 
"UCLA MEDICAL GROUP DRUG ONLY", "UFCW", "UFCW-UNITE", "UFCW & EMPLOYERS AZ HEALTH TRUST", 
"UFCW & PFIE HEALTH AND WELFARE", "UHC - ALL SAVERS PLAN", "UHC PASSPORT CONNECT HARVARD PILGR.", 
"UHC WEST FKA PACIFICARE", "UMR", "UNICARE HEALTH PLAN", "UNICARE STATE INDEMNITY PLAN", 
"UNIFIED GROUP SERVICES", "UNITED FOOD & COMMRCL WORKERS 880", 
"UNITED HEALTH CARE", "UNITED HEALTH ONE", "UNITED HEALTH SHARED SERVICES", 
"UNITED HEALTHCARE", "UNITED HEALTHCARE-EMPIRE", "UNITED HEALTHCARE-EMPIRE.", 
"UNITED HEALTHCARE-SIERRA HEALTH", "UNITED HEALTHCARE - HCAP", 
"UNITED HEALTHCARE  EMPIRE PLAN", "UNITED HEALTHCARE CHOICE PLUS-ZLGN", 
"UNITED HEALTHCARE HCAP", "UNITED HEALTHCARE INTERNATIONAL", 
"UNITED HEALTHCARE STUDENT RESOURCES", "UNITY HEALTH PLAN", "UNIV HOSPTAL NORTH SHORE", 
"UNIV OF MEDICINE & DENISTRY OF NJ", "UNIVERA HEALTHCARE", "UNIVERSITY HEALTH ALLIANCE", 
"UNIVERSITY HEALTH CARE PLUS", "UNIVERSITY OF UTAH HEALTH PLAN", 
"UNIVERSITY OF UTAH NETWORK", "UPMC HEALTH PLAN", "UPMC HEALTH PLAN ESI PD PRNV", 
"US DEPT OF LABOR", "USAA LIFE INSURANCE", "UTE ENERGY", "VALLEY CARE IPA", 
"VALLEY HEALTH PLAN", "VALLEY PRESBYTERIAN HOSPITAL", "VANTAGE MEDICAL GROUP", 
"VIDANT HEALTH", "VILLIAGE OF ROSEMONT", "WA STATE FUND DEPT OF LABOR", 
"WASHINGTON STATE HEALTH INS POOL", "WASHOE COUNTY SCHOOL DISTRICT", 
"WEA TRUST", "WEB TPA", "WEBTPA", "WELLDYNERX", "WELLMED FL", 
"WELLMED TX", "WESTAR ENERGY", "WESTCHESTER COUNTY BENEFITS", 
"WESTERN HEALTH ADVANTAGE", "WESTERN SOUTHERN LIFE", "WESTWOOD CENTER", 
"WINCHESTER MEDICAL CENTER", "WORLD INSURANCE", "WTC HEALTH PROGRAM", 
"WV PEIA", "YAVAPAI REGIONAL MEDICAL CENTER", "YORK RISK SERVICES-EXPRESS SCRIPTS"
), class = "factor")), row.names = c(NA, -109L), class = c("tbl_df", 
"tbl", "data.frame"))

train_rank<-train%>%select_if(is.factor)%>%mutate_all(funs(dense_rank(desc(.))))

import React from "react";
import { StyleSheet, View, StatusBar } from "react-native";
import { createAppContainer } from "react-navigation";
import { createStackNavigator } from "react-navigation-stack";

import Avatar from "../coreComponents/Avatar";

import ScHome from "../screens/ScHome";
import ScNewMedi from "../screens/ScNewMedi";
import ScCalendar from "./ScAgenda";

const AppStack = createStackNavigator(
  {
    Home: {
      screen: ScHome,
    },
    Medis: {
      screen: ScNewMedi,
    },
    Agenda: {
      screen: ScCalendar,
    },
  },
  {
    headerMode: "screen",
    initialRouteName: "Home",
    backBehavior: "order",
  }
);

const AppContainer = createAppContainer(AppStack);

export default class ScDefault extends React.Component {
  render() {
    return (
      
        
        
        
      
    );
  }
}

const styles = StyleSheet.create({
  container: {
    flex: 1,
  },
});