Пример #1
0
    // Remove dots, replace + by X
    $line[0] = str_replace(array('.', '+'), array('', 'X'), trim($line[0]));
    $cim = CCodeCIM10::get($line[0]);
    if (!$cim->exist) {
        $list_diff[] = $line;
    }
}
fclose($fp);
if (count($list_diff)) {
    CAppUI::stepAjax("Il existe " . count($list_diff) . " codes supplémentaires dans la CIM v.11", UI_MSG_WARNING);
} else {
    CAppUI::stepAjax("Il n'y a pas de code supplémentaires dans la CIM v.11", UI_MSG_OK);
}
foreach ($list_diff as $diff) {
    $abbrev = $diff[0];
    $full_code = CCodeCIM10::addPoint($abbrev);
    // Insertion des nouveaux codes
    $query = "INSERT into master (`code`, `abbrev`, `level`, `type`, `valid`, `author`) VALUES (\r\n    '" . $full_code . "','" . $abbrev . "','" . strlen($full_code) . "','S','1','atih')";
    $ds->exec($query);
    // On récupère la clé primaire du code ajouté
    $query = "SELECT * FROM master WHERE 1 ORDER BY SID DESC LIMIT 1";
    $result = $ds->exec($query);
    $row = $ds->fetchArray($result);
    $SID = $row['SID'];
    // On ajoute les niveaux supérieurs
    $prev_SID = 0;
    $offset = 0;
    for ($i = 1; $i <= 7; $i++) {
        if ($i <= 2) {
            $query = "SELECT * FROM master WHERE abbrev LIKE('%" . substr($abbrev, 0, $i) . "%') ORDER BY code ASC LIMIT 1";
        } else {