Project

General

Profile

Download (9.45 KB)

update template TTCDT.txt

Luc Tran Van, 03/28/2023 04:50 PM

 
1 
UPDATE CM_REPORT_TEMPLATE_DETAIL SET REPORT_TEMPLATE_DETAIL_CONTENT = N'<p>
2 
    <span style="font-size: 14px;"><span style="font-family: Times New Roman;"></span></span><span style="font-size: 14px;"><span style="font-family: Times New Roman;"></span></span>
3 
    <span style="font-family: Times New Roman, Times, serif;"><img alt="" src="/assets/logo/bvb_report.png" style="height: 56px; width: 226px;" /></span>
4 
</p>
5 
<p style="text-align: center;"><span style="font-family: Times New Roman, Times, serif;"></span></p>
6 
<table align="center" border="0" cellpadding="1" cellspacing="1" style="width: 70%;">
7 
    <tbody>
8 
        <tr>
9 
            <td>
10 
                <span style="font-family: Times New Roman, Times, serif;">
11 
                    <span style="font-size: 14px;"><em>Số: {table0.reportNo}</em></span>
12 
                </span>
13 
            </td>
14 
            <td style="text-align: right;">
15 
                <span style="font-family: Times New Roman, Times, serif;">
16 
                    <span style="font-size: 14px;"><em>Tp. Hồ Ch&iacute; Minh, {table0.date}</em></span>
17 
                </span>
18 
            </td>
19 
        </tr>
20 
    </tbody>
21 
</table>
22 
<p style="text-align: center;"><span style="font-family: Times New Roman, Times, serif;"></span></p>
23 
<p style="text-align: center;">
24 
    <span style="font-family: Times New Roman, Times, serif;">
25 
        <span style="font-size: 16px;"><strong>TỜ TR&Igrave;NH</strong></span>
26 
    </span>
27 
</p>
28 
<p style="text-align: center;"><span style="font-family: Times New Roman, Times, serif;"></span></p>
29 
<table align="center" border="0" cellpadding="3" cellspacing="1" style="width: 70%;">
30 
    <tbody>
31 
        <tr>
32 
            <td style="text-align: right; width: 50%;">
33 
                <span style="font-family: Times New Roman, Times, serif;">
34 
                    <strong>
35 
                        <span style="font-size: 16px;"><u>K&iacute;nh gửi:</u>&nbsp;</span>
36 
                    </strong>
37 
                </span>
38 
            </td>
39 
            <td>
40 
                <span style="font-family: Times New Roman, Times, serif;">
41 
                    <strong><span style="font-size: 16px;">Ban Tổng Gi&aacute;m đốc</span></strong>
42 
                </span>
43 
            </td>
44 
        </tr>
45 
    </tbody>
46 
</table>
47 
<p>&nbsp;</p>
48 
<p>&nbsp;</p>
49 
<p>&nbsp;</p>
50 
<p>&nbsp;</p>
51 
<p>&nbsp;</p>
52 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
53 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
54 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
55 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
56 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
57 
<p style="text-align: center;">
58 
    <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;"></span></span>
59 
</p>
60 
<p>
61 
    <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;"></span></span>
62 
</p>
63 
<p>
64 
    <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;"></span></span>
65 
</p>
66 
<p>
67 
    <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;"></span><span style="font-size: 14px;"></span><span style="font-size: 14px;"></span></span>
68 
</p>
69 
<table align="center" border="0" cellpadding="1" cellspacing="1" style="width: 80%;">
70 
    <tbody>
71 
        <tr>
72 
            <td style="text-align: center;">
73 
                <span style="font-family: Times New Roman, Times, serif;">
74 
                    <strong><span style="font-size: 16px;">{table8.KSV_TITLE}</span></strong>
75 
                </span>
76 
            </td>
77 
            <td style="text-align: center; vertical-align: middle; width: 50%;">
78 
                <span style="font-family: Times New Roman, Times, serif;">
79 
                    <strong><span style="font-size: 16px;">{table8.GDDVMS_TITLE}</span></strong>
80 
                </span>
81 
            </td>
82 
        </tr>
83 
        <tr>
84 
            <td style="text-align: center;">
85 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table1.KSV_NAME}</span></span>
86 
            </td>
87 
            <td style="text-align: center; vertical-align: middle; width: 50%;">
88 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table1.DMMS_NAME}</span></span>
89 
            </td>
90 
        </tr>
91 
        <tr>
92 
            <td style="text-align: center;">
93 
                <span style="font-family: Times New Roman, Times, serif;">
94 
                    <em><span style="font-size: 14px;">{table2.APPROVE_DT_KSV}</span></em>
95 
                </span>
96 
            </td>
97 
            <td style="text-align: center;">
98 
                <span style="font-family: Times New Roman, Times, serif;">
99 
                    <em><span style="font-size: 14px;">{table2.APPROVE_DT_GDDV}</span></em>
100 
                </span>
101 
            </td>
102 
        </tr>
103 
    </tbody>
104 
</table>
105 
<p>&nbsp;</p>
106 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
107 
<p style="text-align: center;">
108 
    <span style="font-family: Times New Roman, Times, serif;">
109 
        <strong><span style="font-size: 16px;">{table8.APPROVE_TITLE}</span></strong>
110 
    </span>
111 
</p>
112 
<table align="center" border="0" cellpadding="1" cellspacing="1" style="width: 80%;">
113 
    <tbody>
114 
        <tr>
115 
            <td style="text-align: center; width: 26%;">
116 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table3.ROLE_GDKHT}</span></span>
117 
            </td>
118 
            <td style="text-align: center;">
119 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table3.ROLE_PTGD}</span></span>
120 
            </td>
121 
            <td style="text-align: center; width: 26%;">
122 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table3.ROLE_GDKTC}</span></span>
123 
            </td>
124 
        </tr>
125 
        <tr>
126 
            <td style="text-align: center; width: 26%;">
127 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table4.GDKHT_NAME}</span></span>
128 
            </td>
129 
            <td style="text-align: center;">
130 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table4.PTGD_NAME}</span></span>
131 
            </td>
132 
            <td style="text-align: center; width: 26%;">
133 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table4.GDKTC_NAME}</span></span>
134 
            </td>
135 
        </tr>
136 
        <tr>
137 
            <td style="text-align: center; width: 26%;">
138 
                <span style="font-family: Times New Roman, Times, serif;">
139 
                    <em><span style="font-size: 14px;">{table5.APPROVE_DT_GDKHT}</span></em>
140 
                </span>
141 
            </td>
142 
            <td style="text-align: center;">
143 
                <span style="font-family: Times New Roman, Times, serif;">
144 
                    <span style="font-size: 14px;"><em>{table5.APPROVE_DT_PTGD}</em></span>
145 
                </span>
146 
            </td>
147 
            <td style="text-align: center; width: 26%;">
148 
                <span style="font-family: Times New Roman, Times, serif;">
149 
                    <em><span style="font-size: 14px;">{table5.APPROVE_DT_GDKTC}</span></em>
150 
                </span>
151 
            </td>
152 
        </tr>
153 
    </tbody>
154 
</table>
155 
<p>&nbsp;</p>
156 
<p style="text-align: center;">&nbsp;</p>
157 
<p><span style="font-family: Times New Roman, Times, serif;"></span></p>
158 
<table align="center" border="0" cellpadding="1" cellspacing="1" style="width: 80%;">
159 
    <tbody>
160 
        <tr>
161 
            <td style="text-align: center;">
162 
                <span style="font-family: Times New Roman, Times, serif;">
163 
                    <span style="font-size: 16px;"><strong>{table8.TKTGD_TITLE}</strong></span>
164 
                </span>
165 
            </td>
166 
            <td style="text-align: center; vertical-align: middle; width: 50%;">
167 
                <span style="font-family: Times New Roman, Times, serif;">
168 
                    <span style="font-size: 16px;"><strong>{table8.TGD_TITLE}</strong></span>
169 
                </span>
170 
            </td>
171 
        </tr>
172 
        <tr>
173 
            <td style="text-align: center;">
174 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table6.TKTGD_NAME}</span></span>
175 
            </td>
176 
            <td style="text-align: center; vertical-align: middle; width: 50%;">
177 
                <span style="font-family: Times New Roman, Times, serif;"><span style="font-size: 14px;">{table6.TGD_NAME}</span></span>
178 
            </td>
179 
        </tr>
180 
        <tr>
181 
            <td style="text-align: center;">
182 
                <span style="font-family: Times New Roman, Times, serif;">
183 
                    <em><span style="font-size: 14px;">{table7.APPROVE_DT_TKTGD}</span></em>
184 
                </span>
185 
            </td>
186 
            <td style="text-align: center;">
187 
                <span style="font-family: Times New Roman, Times, serif;">
188 
                    <em><span style="font-size: 14px;">{table7.APPROVE_DT_TGD}</span></em>
189 
                </span>
190 
            </td>
191 
        </tr>
192 
    </tbody>
193 
</table>
194 
<p style="text-align: center;">&nbsp;</p>
195 
<p style="text-align: center;">&nbsp;</p>
196 
'
197 
where REPORT_TEMPLATE_ID='2D465BD7-5E8C-48E4-A15C-44B44076AAF6'