public function import_by_sql_server($uploaded)
    {
        $start = microtime(true);
        $this->spareparts_m->import_by_sql_server('./public/uploads/excel/'.$uploaded['file_name']);
        $filterStaging = $this->spareparts_m->getStaging();

        $dataFixSparepart = [];
        $getCabangIdJ = "";
        $getCabangIdB = "";
        $getCabangIdS = "";
        $getCabangIdM = "";

        if (empty($getCabangIdJ)) {
            $getCabangIdJ = $this->spareparts_m->get_cabang_id_by_code("J");
        }

        if (empty($getCabangIdB)) {
            $getCabangIdB = $this->spareparts_m->get_cabang_id_by_code("B");

        }

        if (empty($getCabangIdS)) {
            $getCabangIdS = $this->spareparts_m->get_cabang_id_by_code("S");
        }

        if (empty($getCabangIdM)) {
            $getCabangIdM = $this->spareparts_m->get_cabang_id_by_code("M");
        }

        foreach ($filterStaging as $key => $staging) {

                //split rakJ
                $rakArrJ = [];
                foreach (explode(",", $staging['part_rak_j']) as $key => $value2) {
                    $rakArrJ[]  = array(
                                "rak_part_id"   => $staging['part_id'],
                                "rak_cabang_id" => $getCabangIdJ,
                                "rak_code"      => $value2,
                                "rak_created_at"=> date('Y-m-d H:i:s')
                    );
                }

                $this->db->insert_batch("part_rak",$rakArrJ);

                $rakArrB = [];
                foreach (explode(",", $staging['part_rak_b']) as $key => $value2) {
                    $rakArrB[]  = array(
                                "rak_part_id"   => $staging['part_id'],
                                "rak_cabang_id" => $getCabangIdB,
                                "rak_code"      => $value2,
                                "rak_created_at"=> date('Y-m-d H:i:s')
                    );
                }

                $this->db->insert_batch("part_rak",$rakArrB);


                $rakArrS = [];
                foreach (explode(",", $staging['part_rak_s']) as $key => $value2) {
                    $rakArrS[]  = array(
                                "rak_part_id"   => $staging['part_id'],
                                "rak_cabang_id" => $getCabangIdS,
                                "rak_code"      => $value2,
                                "rak_created_at"=> date('Y-m-d H:i:s')
                    );
                }

                $this->db->insert_batch("part_rak",$rakArrS);

                $rakArrM = [];
                foreach (explode(",", $staging['part_rak_m']) as $key => $value2) {
                    $rakArrM[]  = array(
                                "rak_part_id"   => $staging['part_id'],
                                "rak_cabang_id" => $getCabangIdM,
                                "rak_code"      => $value2,
                                "rak_created_at"=> date('Y-m-d H:i:s')
                    );
                }

                $this->db->insert_batch("part_rak",$rakArrM);

            $dataFixSparepart[] = array(
                "part_mesin_code"   => $staging['part_mesin_code'],
                "part_no"           => $staging['part_no'],
                "part_revised_no"   => $staging['part_revised_no'],
                "part_latest_no"    => $staging['part_latest_no'],
                "part_desc"         => $staging['part_desc'],
                "part_incoming_date"=> $staging['part_incoming_date'],
                "part_fob_japan"    => $staging['part_fob_japan'],
                "part_min_order"    => $staging['part_min_order'],
                "part_master_key1"  => $staging['part_master_key1'],
                "part_total_stock"  => $staging['part_total_stock'],
                "part_stock_j"      => str_replace(",", "", $staging['part_stock_j']),
                "part_stock_b"      => str_replace(",", "", $staging['part_stock_b']),
                "part_stock_s"      => str_replace(",", "", $staging['part_stock_s']),
                "part_stock_m"      => str_replace(",", "", $staging['part_stock_m']),
                "part_last_opname"  => $staging['part_last_opname'],
                "part_discontinued" => $staging['part_discontinued'],
                "part_srp"          => $staging['part_srp'],
                "part_srp_cod"      => $staging['part_srp_cod'],
                "part_supv_price"   => $staging['part_supv_price'],
                "part_mgr_price"    => $staging['part_mgr_price'],
                "part_dtr_price"    => $staging['part_dtr_price'],
                "part_keterangan"   => $staging['part_keterangan']
            );
        }
        $this->db->insert_batch("sparepart",$dataFixSparepart);

        $end      = microtime(true);
        $duration = $end - $start;
        $hours    = (int)($duration/60/60);
        $minutes  = (int)($duration/60)-$hours*60;
        $seconds  = (int)$duration-$hours*60*60-$minutes*60;
        return $seconds;
    }