230 lines
20 KiB
HTML
230 lines
20 KiB
HTML
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
|
|
|
|
<html lang="en">
|
|
|
|
<head>
|
|
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
|
|
<title>LCOV - lcov.info - lib/utils/event_excel_parser.dart</title>
|
|
<link rel="stylesheet" type="text/css" href="../../gcov.css">
|
|
</head>
|
|
|
|
<body>
|
|
|
|
<table width="100%" border=0 cellspacing=0 cellpadding=0>
|
|
<tr><td class="title">LCOV - code coverage report</td></tr>
|
|
<tr><td class="ruler"><img src="../../glass.png" width=3 height=3 alt=""></td></tr>
|
|
|
|
<tr>
|
|
<td width="100%">
|
|
<table cellpadding=1 border=0 width="100%">
|
|
<tr>
|
|
<td width="10%" class="headerItem">Current view:</td>
|
|
<td width="10%" class="headerValue"><a href="../../index.html" title="Click to go to top-level">top level</a> - <a href="index.html" title="Click to go to directory lib/utils">lib/utils</a> - event_excel_parser.dart</td>
|
|
<td width="5%"></td>
|
|
<td width="5%"></td>
|
|
<td width="5%" class="headerCovTableHead">Coverage</td>
|
|
<td width="5%" class="headerCovTableHead" title="Covered + Uncovered code">Total</td>
|
|
<td width="5%" class="headerCovTableHead" title="Exercised code only">Hit</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="headerItem">Test:</td>
|
|
<td class="headerValue">lcov.info</td>
|
|
<td></td>
|
|
<td class="headerItem">Lines:</td>
|
|
<td class="headerCovTableEntryLo">0.0 %</td>
|
|
<td class="headerCovTableEntry">51</td>
|
|
<td class="headerCovTableEntry">0</td>
|
|
</tr>
|
|
<tr>
|
|
<td class="headerItem">Test Date:</td>
|
|
<td class="headerValue">2025-08-12 03:21:51</td>
|
|
<td></td>
|
|
<td class="headerItem">Functions:</td>
|
|
<td class="headerCovTableEntryHi">-</td>
|
|
<td class="headerCovTableEntry">0</td>
|
|
<td class="headerCovTableEntry">0</td>
|
|
</tr>
|
|
<tr><td><img src="../../glass.png" width=3 height=3 alt=""></td></tr>
|
|
</table>
|
|
</td>
|
|
</tr>
|
|
|
|
<tr><td class="ruler"><img src="../../glass.png" width=3 height=3 alt=""></td></tr>
|
|
</table>
|
|
|
|
<table cellpadding=0 cellspacing=0 border=0>
|
|
<tr>
|
|
<td><br></td>
|
|
</tr>
|
|
<tr>
|
|
<td>
|
|
<pre class="sourceHeading"> Line data Source code</pre>
|
|
<pre class="source">
|
|
<span id="L1"><span class="lineNum"> 1</span> : import 'package:excel/excel.dart';</span>
|
|
<span id="L2"><span class="lineNum"> 2</span> : </span>
|
|
<span id="L3"><span class="lineNum"> 3</span> : /// 엑셀 파일에서 이벤트 데이터를 파싱하는 유틸리티 클래스</span>
|
|
<span id="L4"><span class="lineNum"> 4</span> : class EventExcelParser {</span>
|
|
<span id="L5"><span class="lineNum"> 5</span> : /// 엑셀 파일 바이트 데이터에서 이벤트 데이터 목록을 추출합니다.</span>
|
|
<span id="L6"><span class="lineNum"> 6</span> : /// </span>
|
|
<span id="L7"><span class="lineNum"> 7</span> : /// [bytes] 엑셀 파일의 바이트 데이터</span>
|
|
<span id="L8"><span class="lineNum"> 8</span> : /// </span>
|
|
<span id="L9"><span class="lineNum"> 9</span> : /// 반환값:</span>
|
|
<span id="L10"><span class="lineNum"> 10</span> : /// - processedRows: 처리된 총 행 수</span>
|
|
<span id="L11"><span class="lineNum"> 11</span> : /// - validEvents: 유효한 이벤트 데이터 목록</span>
|
|
<span id="L12"><span class="lineNum"> 12</span> : /// - invalidRows: 유효하지 않은 행 수</span>
|
|
<span id="L13"><span class="lineNum"> 13</span> <span class="tlaUNC"> 0 : static Map<String, dynamic> parseExcelBytes(List<int> bytes) {</span></span>
|
|
<span id="L14"><span class="lineNum"> 14</span> <span class="tlaUNC"> 0 : final excel = Excel.decodeBytes(bytes);</span></span>
|
|
<span id="L15"><span class="lineNum"> 15</span> <span class="tlaUNC"> 0 : final events = <Map<String, dynamic>>[];</span></span>
|
|
<span id="L16"><span class="lineNum"> 16</span> : int invalidRows = 0;</span>
|
|
<span id="L17"><span class="lineNum"> 17</span> : int processedRows = 0;</span>
|
|
<span id="L18"><span class="lineNum"> 18</span> : </span>
|
|
<span id="L19"><span class="lineNum"> 19</span> : // 첫 번째 시트 사용</span>
|
|
<span id="L20"><span class="lineNum"> 20</span> <span class="tlaUNC"> 0 : final sheet = excel.tables.keys.first;</span></span>
|
|
<span id="L21"><span class="lineNum"> 21</span> <span class="tlaUNC"> 0 : final rows = excel.tables[sheet]?.rows;</span></span>
|
|
<span id="L22"><span class="lineNum"> 22</span> : </span>
|
|
<span id="L23"><span class="lineNum"> 23</span> <span class="tlaUNC"> 0 : if (rows == null || rows.isEmpty) {</span></span>
|
|
<span id="L24"><span class="lineNum"> 24</span> <span class="tlaUNC"> 0 : return {</span></span>
|
|
<span id="L25"><span class="lineNum"> 25</span> : 'processedRows': 0,</span>
|
|
<span id="L26"><span class="lineNum"> 26</span> <span class="tlaUNC"> 0 : 'validEvents': [],</span></span>
|
|
<span id="L27"><span class="lineNum"> 27</span> : 'invalidRows': 0,</span>
|
|
<span id="L28"><span class="lineNum"> 28</span> : 'error': '엑셀 파일에 데이터가 없습니다.'</span>
|
|
<span id="L29"><span class="lineNum"> 29</span> : };</span>
|
|
<span id="L30"><span class="lineNum"> 30</span> : }</span>
|
|
<span id="L31"><span class="lineNum"> 31</span> : </span>
|
|
<span id="L32"><span class="lineNum"> 32</span> : // 헤더 행 추출 (첫 번째 행)</span>
|
|
<span id="L33"><span class="lineNum"> 33</span> <span class="tlaUNC"> 0 : final headers = <String>[];</span></span>
|
|
<span id="L34"><span class="lineNum"> 34</span> <span class="tlaUNC"> 0 : for (final cell in rows[0]) {</span></span>
|
|
<span id="L35"><span class="lineNum"> 35</span> <span class="tlaUNC"> 0 : if (cell?.value != null) {</span></span>
|
|
<span id="L36"><span class="lineNum"> 36</span> <span class="tlaUNC"> 0 : headers.add(cell!.value.toString().trim().toLowerCase());</span></span>
|
|
<span id="L37"><span class="lineNum"> 37</span> : }</span>
|
|
<span id="L38"><span class="lineNum"> 38</span> : }</span>
|
|
<span id="L39"><span class="lineNum"> 39</span> : </span>
|
|
<span id="L40"><span class="lineNum"> 40</span> : // 필수 필드 확인</span>
|
|
<span id="L41"><span class="lineNum"> 41</span> <span class="tlaUNC"> 0 : if (!headers.contains('title') || !headers.contains('startdate')) {</span></span>
|
|
<span id="L42"><span class="lineNum"> 42</span> <span class="tlaUNC"> 0 : return {</span></span>
|
|
<span id="L43"><span class="lineNum"> 43</span> : 'processedRows': 0,</span>
|
|
<span id="L44"><span class="lineNum"> 44</span> <span class="tlaUNC"> 0 : 'validEvents': [],</span></span>
|
|
<span id="L45"><span class="lineNum"> 45</span> : 'invalidRows': 0,</span>
|
|
<span id="L46"><span class="lineNum"> 46</span> : 'error': '필수 필드(title, startDate)가 없습니다.'</span>
|
|
<span id="L47"><span class="lineNum"> 47</span> : };</span>
|
|
<span id="L48"><span class="lineNum"> 48</span> : }</span>
|
|
<span id="L49"><span class="lineNum"> 49</span> : </span>
|
|
<span id="L50"><span class="lineNum"> 50</span> : // 데이터 행 처리 (헤더 제외)</span>
|
|
<span id="L51"><span class="lineNum"> 51</span> <span class="tlaUNC"> 0 : for (var i = 1; i < rows.length; i++) {</span></span>
|
|
<span id="L52"><span class="lineNum"> 52</span> <span class="tlaUNC"> 0 : processedRows++;</span></span>
|
|
<span id="L53"><span class="lineNum"> 53</span> <span class="tlaUNC"> 0 : final row = rows[i];</span></span>
|
|
<span id="L54"><span class="lineNum"> 54</span> <span class="tlaUNC"> 0 : final event = <String, dynamic>{};</span></span>
|
|
<span id="L55"><span class="lineNum"> 55</span> : </span>
|
|
<span id="L56"><span class="lineNum"> 56</span> : // 각 셀 처리</span>
|
|
<span id="L57"><span class="lineNum"> 57</span> <span class="tlaUNC"> 0 : for (var j = 0; j < headers.length && j < row.length; j++) {</span></span>
|
|
<span id="L58"><span class="lineNum"> 58</span> <span class="tlaUNC"> 0 : final header = headers[j];</span></span>
|
|
<span id="L59"><span class="lineNum"> 59</span> <span class="tlaUNC"> 0 : final value = row[j]?.value;</span></span>
|
|
<span id="L60"><span class="lineNum"> 60</span> : </span>
|
|
<span id="L61"><span class="lineNum"> 61</span> : // 날짜 필드 특별 처리</span>
|
|
<span id="L62"><span class="lineNum"> 62</span> <span class="tlaUNC"> 0 : if (header == 'startdate' || header == 'enddate') {</span></span>
|
|
<span id="L63"><span class="lineNum"> 63</span> <span class="tlaUNC"> 0 : DateTime? date = _parseDate(value);</span></span>
|
|
<span id="L64"><span class="lineNum"> 64</span> : </span>
|
|
<span id="L65"><span class="lineNum"> 65</span> : // 날짜 값 설정</span>
|
|
<span id="L66"><span class="lineNum"> 66</span> : if (date != null) {</span>
|
|
<span id="L67"><span class="lineNum"> 67</span> : // 헤더 이름 정규화 (startdate -> startDate)</span>
|
|
<span id="L68"><span class="lineNum"> 68</span> <span class="tlaUNC"> 0 : final normalizedHeader = header == 'startdate' ? 'startDate' : 'endDate';</span></span>
|
|
<span id="L69"><span class="lineNum"> 69</span> <span class="tlaUNC"> 0 : event[normalizedHeader] = date.toIso8601String();</span></span>
|
|
<span id="L70"><span class="lineNum"> 70</span> : } else {</span>
|
|
<span id="L71"><span class="lineNum"> 71</span> : // 날짜 파싱 실패 시 startDate는 필수이므로 현재 날짜 사용</span>
|
|
<span id="L72"><span class="lineNum"> 72</span> <span class="tlaUNC"> 0 : if (header == 'startdate') {</span></span>
|
|
<span id="L73"><span class="lineNum"> 73</span> <span class="tlaUNC"> 0 : event['startDate'] = DateTime.now().toIso8601String();</span></span>
|
|
<span id="L74"><span class="lineNum"> 74</span> : } else {</span>
|
|
<span id="L75"><span class="lineNum"> 75</span> : // endDate는 선택적이므로 null 설정</span>
|
|
<span id="L76"><span class="lineNum"> 76</span> <span class="tlaUNC"> 0 : event['endDate'] = null;</span></span>
|
|
<span id="L77"><span class="lineNum"> 77</span> : }</span>
|
|
<span id="L78"><span class="lineNum"> 78</span> : }</span>
|
|
<span id="L79"><span class="lineNum"> 79</span> : } else {</span>
|
|
<span id="L80"><span class="lineNum"> 80</span> : // 문자열 필드의 경우 빈 문자열은 null로 처리</span>
|
|
<span id="L81"><span class="lineNum"> 81</span> <span class="tlaUNC"> 0 : final stringValue = value?.toString().trim() ?? '';</span></span>
|
|
<span id="L82"><span class="lineNum"> 82</span> : </span>
|
|
<span id="L83"><span class="lineNum"> 83</span> : // 헤더 이름 정규화 (특별한 경우)</span>
|
|
<span id="L84"><span class="lineNum"> 84</span> : String normalizedHeader = header;</span>
|
|
<span id="L85"><span class="lineNum"> 85</span> <span class="tlaUNC"> 0 : if (header == 'title' || header == 'description' || header == 'location' || </span></span>
|
|
<span id="L86"><span class="lineNum"> 86</span> <span class="tlaUNC"> 0 : header == 'status' || header == 'type' || header == 'maxparticipants') {</span></span>
|
|
<span id="L87"><span class="lineNum"> 87</span> : // 첫 글자를 소문자로 유지하고 나머지는 원래 형식 유지</span>
|
|
<span id="L88"><span class="lineNum"> 88</span> <span class="tlaUNC"> 0 : normalizedHeader = header == 'maxparticipants' ? 'maxParticipants' : header;</span></span>
|
|
<span id="L89"><span class="lineNum"> 89</span> : }</span>
|
|
<span id="L90"><span class="lineNum"> 90</span> : </span>
|
|
<span id="L91"><span class="lineNum"> 91</span> : // 빈 문자열은 null로 처리</span>
|
|
<span id="L92"><span class="lineNum"> 92</span> <span class="tlaUNC"> 0 : event[normalizedHeader] = stringValue.isEmpty ? null : stringValue;</span></span>
|
|
<span id="L93"><span class="lineNum"> 93</span> : }</span>
|
|
<span id="L94"><span class="lineNum"> 94</span> : }</span>
|
|
<span id="L95"><span class="lineNum"> 95</span> : </span>
|
|
<span id="L96"><span class="lineNum"> 96</span> : // 필수 필드가 있는 경우만 추가</span>
|
|
<span id="L97"><span class="lineNum"> 97</span> <span class="tlaUNC"> 0 : if (event.containsKey('title') && event.containsKey('startDate')) {</span></span>
|
|
<span id="L98"><span class="lineNum"> 98</span> <span class="tlaUNC"> 0 : events.add(event);</span></span>
|
|
<span id="L99"><span class="lineNum"> 99</span> : } else {</span>
|
|
<span id="L100"><span class="lineNum"> 100</span> <span class="tlaUNC"> 0 : invalidRows++;</span></span>
|
|
<span id="L101"><span class="lineNum"> 101</span> : }</span>
|
|
<span id="L102"><span class="lineNum"> 102</span> : }</span>
|
|
<span id="L103"><span class="lineNum"> 103</span> : </span>
|
|
<span id="L104"><span class="lineNum"> 104</span> <span class="tlaUNC"> 0 : return {</span></span>
|
|
<span id="L105"><span class="lineNum"> 105</span> : 'processedRows': processedRows,</span>
|
|
<span id="L106"><span class="lineNum"> 106</span> : 'validEvents': events,</span>
|
|
<span id="L107"><span class="lineNum"> 107</span> : 'invalidRows': invalidRows,</span>
|
|
<span id="L108"><span class="lineNum"> 108</span> <span class="tlaUNC"> 0 : 'error': events.isEmpty ? '유효한 이벤트 데이터가 없습니다.' : null</span></span>
|
|
<span id="L109"><span class="lineNum"> 109</span> : };</span>
|
|
<span id="L110"><span class="lineNum"> 110</span> : }</span>
|
|
<span id="L111"><span class="lineNum"> 111</span> : </span>
|
|
<span id="L112"><span class="lineNum"> 112</span> : /// 다양한 형식의 날짜 값을 DateTime 객체로 파싱합니다.</span>
|
|
<span id="L113"><span class="lineNum"> 113</span> <span class="tlaUNC"> 0 : static DateTime? _parseDate(dynamic value) {</span></span>
|
|
<span id="L114"><span class="lineNum"> 114</span> : DateTime? date;</span>
|
|
<span id="L115"><span class="lineNum"> 115</span> : </span>
|
|
<span id="L116"><span class="lineNum"> 116</span> : // DateTime 타입인 경우</span>
|
|
<span id="L117"><span class="lineNum"> 117</span> <span class="tlaUNC"> 0 : if (value is DateTime) {</span></span>
|
|
<span id="L118"><span class="lineNum"> 118</span> : return value;</span>
|
|
<span id="L119"><span class="lineNum"> 119</span> : } </span>
|
|
<span id="L120"><span class="lineNum"> 120</span> : </span>
|
|
<span id="L121"><span class="lineNum"> 121</span> : // 문자열인 경우</span>
|
|
<span id="L122"><span class="lineNum"> 122</span> : if (value != null) {</span>
|
|
<span id="L123"><span class="lineNum"> 123</span> <span class="tlaUNC"> 0 : final strValue = value.toString();</span></span>
|
|
<span id="L124"><span class="lineNum"> 124</span> : </span>
|
|
<span id="L125"><span class="lineNum"> 125</span> <span class="tlaUNC"> 0 : if (strValue.isNotEmpty) {</span></span>
|
|
<span id="L126"><span class="lineNum"> 126</span> : // YYYY-MM-DD 형식 시도</span>
|
|
<span id="L127"><span class="lineNum"> 127</span> : try {</span>
|
|
<span id="L128"><span class="lineNum"> 128</span> <span class="tlaUNC"> 0 : date = DateTime.parse(strValue);</span></span>
|
|
<span id="L129"><span class="lineNum"> 129</span> : } catch (_) {</span>
|
|
<span id="L130"><span class="lineNum"> 130</span> : // 실패 시 다른 형식 시도</span>
|
|
<span id="L131"><span class="lineNum"> 131</span> : }</span>
|
|
<span id="L132"><span class="lineNum"> 132</span> : </span>
|
|
<span id="L133"><span class="lineNum"> 133</span> : // YYYY/MM/DD 형식 시도</span>
|
|
<span id="L134"><span class="lineNum"> 134</span> <span class="tlaUNC"> 0 : if (date == null && strValue.contains('/')) {</span></span>
|
|
<span id="L135"><span class="lineNum"> 135</span> : try {</span>
|
|
<span id="L136"><span class="lineNum"> 136</span> <span class="tlaUNC"> 0 : final parts = strValue.split('/');</span></span>
|
|
<span id="L137"><span class="lineNum"> 137</span> <span class="tlaUNC"> 0 : if (parts.length == 3) {</span></span>
|
|
<span id="L138"><span class="lineNum"> 138</span> <span class="tlaUNC"> 0 : date = DateTime(</span></span>
|
|
<span id="L139"><span class="lineNum"> 139</span> <span class="tlaUNC"> 0 : int.parse(parts[0]),</span></span>
|
|
<span id="L140"><span class="lineNum"> 140</span> <span class="tlaUNC"> 0 : int.parse(parts[1]),</span></span>
|
|
<span id="L141"><span class="lineNum"> 141</span> <span class="tlaUNC"> 0 : int.parse(parts[2]),</span></span>
|
|
<span id="L142"><span class="lineNum"> 142</span> : );</span>
|
|
<span id="L143"><span class="lineNum"> 143</span> : }</span>
|
|
<span id="L144"><span class="lineNum"> 144</span> : } catch (_) {</span>
|
|
<span id="L145"><span class="lineNum"> 145</span> : // 실패 시 무시</span>
|
|
<span id="L146"><span class="lineNum"> 146</span> : }</span>
|
|
<span id="L147"><span class="lineNum"> 147</span> : }</span>
|
|
<span id="L148"><span class="lineNum"> 148</span> : }</span>
|
|
<span id="L149"><span class="lineNum"> 149</span> : }</span>
|
|
<span id="L150"><span class="lineNum"> 150</span> : </span>
|
|
<span id="L151"><span class="lineNum"> 151</span> : return date;</span>
|
|
<span id="L152"><span class="lineNum"> 152</span> : }</span>
|
|
<span id="L153"><span class="lineNum"> 153</span> : }</span>
|
|
</pre>
|
|
</td>
|
|
</tr>
|
|
</table>
|
|
<br>
|
|
|
|
<table width="100%" border=0 cellspacing=0 cellpadding=0>
|
|
<tr><td class="ruler"><img src="../../glass.png" width=3 height=3 alt=""></td></tr>
|
|
<tr><td class="versionInfo">Generated by: <a href="https://github.com//linux-test-project/lcov" target="_parent">LCOV version 2.3.1-1</a></td></tr>
|
|
</table>
|
|
<br>
|
|
|
|
</body>
|
|
</html>
|