public static function addReportSheet($config_id = 0)
{
$sheet_name = Input::get('sheet_name');
foreach ($sheet_name as $sheetKey => $sheetData) {
$config_string = array();
$data_table_columns = Input::get('data_table_columns');
$data_table = Input::get('data_table');
$config = Input::get('config');
$config = $config[$sheetKey];
$rows = Input::get('row');
$rows = $rows[$sheetKey];
$columns = Input::get('column');
$columns = $columns[$sheetKey];
// config string here
$config_string = array();
if ($config && count($config) > 0) {
for ($i = 0; $i < count($config); $i++) {
$config_string[$i]['config_name'] = $config[$i];
$config_string[$i]['column'] = $columns[$i];
$config_string[$i]['row'] = $rows[$i];
}
}
$config_string = json_encode($config_string);
$sheet = new ConfigurationSheet();
$sheet->config_id = $config_id;
$sheet->sheet_name = $sheet_name[$sheetKey];
$sheet->configuration_string = $config_string;
$sheet->data_table = $data_table[$sheetKey];
$sheet->data_table_columns = $data_table_columns[$sheetKey];
$sheet->save();
}
}
