public function get_sales_code_for_spv($dept, $level)
    {
        $q = "";
        $curdate = date('ymd');
        if($dept == 'GRH' and $level == 'supervisor_produksi'){
            $q = $this->db->query("SELECT MAX(RIGHT(sales_code,4)) AS kd_max FROM tbl_sales WHERE LENGTH(sales_code) = 14 and sales_code LIKE '$curdate%' ");
        }
        elseif ($dept == 'CG' and $level == 'supervisor_cg') {
            $q = $this->db->query("SELECT MAX(RIGHT(sales_code,4)) AS kd_max FROM tbl_sales_cg WHERE LENGTH(sales_code) = 14 and sales_code LIKE '$curdate%' ");
        }
        $kd = "";

        if ($q->num_rows() > 0) {
            foreach ($q->result() as $k) {
                $tmp = ((int) $k->kd_max) + 1;
                $kd = sprintf("%04s", $tmp);
            }
        } else {
            $kd = "0001";
        }

        date_default_timezone_set('Asia/Jakarta');
        if ($dept == 'GRH' and $level == 'supervisor_produksi') {
            return date('ymd') . '0104'  . $kd;
        } elseif ($dept == 'CG' and $level == 'supervisor_cg') {
            return date('ymd') . '0204' . $kd;
        }
    }