// print_r($ln_fields_data);
// print_r($rel_fields_data);
// exit;
$result = $db->query($query);
$data = array();
while ($row = $db->fetchByAssoc($result)) {
$data[$row['id']] = $row;
}
$data_fields = $sql_fields;
$sheetData['data'] = array();
$color_Arr = array('FF8888', '88FF88', 'FF88FF', 'FFFF88');
foreach ($data as $r_id => $item) {
$fields = array();
$col_index = 0;
foreach ($data_fields as $field_name) {
$field = XlsExUtils::getStandartField($focus, $field_name, $item[$field_name]);
$fields[] = array($field, 'FFFFFF');
}
if (count($ln_fields) > 0) {
foreach (array_keys($ln_fields) as $sub_module_name) {
$color = $color_Arr[$col_index];
foreach ($ln_fields_data[$r_id][$sub_module_name] as $field) {
$fields[] = array($field, $color);
// array_merge($fields,$field);
}
$col_index++;
if ($col_index > 3) {
$col_index = 0;
}
}
}
