<?php
class Xno extends CI_Controller
{
  function index() {
     echo "API";
  }
  function show($noreg) {
     $this->db_onedev = $this->load->database("onedev", true);
     //000 00014 DA
     $flag_convert = false;
     $get_digit = $noreg;
     if ( strlen($noreg) == 10 ) {
         $get_digit = substr($noreg,3,5);
         $pre = substr($noreg,0,3);
         $post = substr($noreg,-2);
         $flag_convert = true ;
     }
     if ( strlen($noreg) == 7 ) {
         $get_digit = substr($noreg,0,5);
         $post = substr($noreg,-2);
         $pre = "";
         $flag_convert = true ;
     }
     if (is_numeric($get_digit)) return $noreg;

     $sql = "select numberMapOrigin from number_map where numberMapTarget = ?";
     $qry = $this->db_onedev->query($sql, array($get_digit));
     if ($qry) {
        $rows = $qry->result_array();
        if (count($rows) > 0 ) {
           $new_digit = $rows[0]["numberMapOrigin"];
           echo $pre . $new_digit . $post; 
           exit;
        }
     }
     echo $noreg;
  }
}