function trim_lower_accent2(&$item, $key) { $item = trim_lower_accent($item); }
/** * put your comment there... * * @param mixed $mysqli * @param mixed $query * @param mixed $imp_session * @param mixed $fields_checked - name of field to be verified * @param mixed $dt_id - mapped detail type ID * @param mixed $field_idx - index of validation field in query result (to get value) * @param mixed $recStruc - record type structure * @param mixed $message - error message * @param mixed $short_messsage */ function validateEnumerations($query, $imp_session, $fields_checked, $dt_id, $field_idx, $recStruc, $recordType, $message, $short_messsage) { global $system; $mysqli = $system->get_mysqli(); $dt_def = $recStruc[$recordType]['dtFields'][$dt_id]; $idx_fieldtype = $recStruc['dtFieldNamesToIndex']['dty_Type']; $idx_term_tree = $recStruc['dtFieldNamesToIndex']['rst_FilteredJsonTermIDTree']; $idx_term_nosel = $recStruc['dtFieldNamesToIndex']['dty_TermIDTreeNonSelectableIDs']; $dt_type = $dt_def[$idx_fieldtype]; $res = $mysqli->query($query . " LIMIT 5000"); if ($res) { $wrong_records = array(); while ($row = $res->fetch_row()) { $is_error = false; $newvalue = array(); $values = getMultiValues($row[$field_idx], $imp_session['csv_enclosure'], $imp_session['csv_mvsep']); foreach ($values as $idx => $r_value) { $r_value2 = trim_lower_accent($r_value); if ($r_value2 != "") { $is_termid = false; if (ctype_digit($r_value2)) { $is_termid = isValidTerm($dt_def[$idx_term_tree], $dt_def[$idx_term_nosel], $r_value2, $dt_id); } if ($is_termid) { $term_id = $r_value; } else { $term_id = isValidTermLabel($dt_def[$idx_term_tree], $dt_def[$idx_term_nosel], $r_value2, $dt_id); } if (!$term_id) { //not found $is_error = true; array_push($newvalue, "<font color='red'>" . $r_value . "AAAA</font>"); } else { array_push($newvalue, $r_value); } } } if ($is_error) { if ($imp_session['csv_mvsep'] == 'none') { $row[$field_idx] = count($newvalue) > 0 ? $newvalue[0] : ''; } else { $row[$field_idx] = implode($imp_session['csv_mvsep'], $newvalue); } array_push($wrong_records, $row); } } $res->close(); $cnt_error = count($wrong_records); if ($cnt_error > 0) { $error = array(); $error["count_error"] = $cnt_error; $error["recs_error"] = array_slice($wrong_records, 0, 1000); $error["field_checked"] = $fields_checked; $error["err_message"] = $message; $error["short_messsage"] = $short_messsage; $imp_session['validation']['count_error'] = $imp_session['validation']['count_error'] + $cnt_error; array_push($imp_session['validation']['error'], $error); return $imp_session; } } else { $system->addError(HEURIST_DB_ERROR, 'Cannot perform validation query: ' . $query, $mysqli->error); return false; } return null; }