|
1
|
INSERT INTO [CM_REPORT_TEMPLATE_DETAIL] ([REPORT_TEMPLATE_DETAIL_ID],[REPORT_TEMPLATE_DETAIL_CONTENT],[REPORT_TEMPLATE_ID],[REPORT_TEMPLATE_DETAIL_CODE],[PAGE_SIZE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[IsDefault])VALUES(N'B9D1D131-27A0-4',N'<style type="text/css">
|
|
2
|
* {
|
|
3
|
font-family: Arial, Helvetica, sans-serif;
|
|
4
|
}
|
|
5
|
|
|
6
|
@page {
|
|
7
|
size: A4;
|
|
8
|
margin: 0;
|
|
9
|
}
|
|
10
|
|
|
11
|
body {
|
|
12
|
margin: 0;
|
|
13
|
padding: 0;
|
|
14
|
}
|
|
15
|
|
|
16
|
table {
|
|
17
|
width: 100%;
|
|
18
|
border-collapse: collapse;
|
|
19
|
padding: 0;
|
|
20
|
border: unset !important;
|
|
21
|
}
|
|
22
|
|
|
23
|
tbody {
|
|
24
|
width: 100%;
|
|
25
|
height: 100%;
|
|
26
|
}
|
|
27
|
|
|
28
|
tr {
|
|
29
|
box-sizing: border-box;
|
|
30
|
display: flex;
|
|
31
|
justify-content: center;
|
|
32
|
align-items: center;
|
|
33
|
max-height: 50%;
|
|
34
|
height: 50%;
|
|
35
|
}
|
|
36
|
|
|
37
|
td {
|
|
38
|
width: 100%;
|
|
39
|
padding: 5mm;
|
|
40
|
box-sizing: border-box;
|
|
41
|
}
|
|
42
|
|
|
43
|
img {
|
|
44
|
vertical-align: middle;
|
|
45
|
border-style: none;
|
|
46
|
width: 120px;
|
|
47
|
}
|
|
48
|
|
|
49
|
html,
|
|
50
|
body {
|
|
51
|
margin: 0;
|
|
52
|
padding: 0;
|
|
53
|
}
|
|
54
|
|
|
55
|
div {
|
|
56
|
line-height: 35px;
|
|
57
|
}
|
|
58
|
tbody tr:nth-child(even){
|
|
59
|
margin-top: 10%;
|
|
60
|
}
|
|
61
|
</style>
|
|
62
|
<p> </p>
|
|
63
|
|
|
64
|
<div style="flex-wrap: wrap;">
|
|
65
|
<p>{table1.TableStart.GroupByTable[ROW]}</p>
|
|
66
|
|
|
67
|
<table>
|
|
68
|
<tbody>
|
|
69
|
<tr>
|
|
70
|
<td>
|
|
71
|
<img src="https://cafefcdn.com/203337114487263232/2023/12/1/screen-shot-2023-12-01-at-08-40-46-1701394890371130086612.png"
|
|
72
|
alt="img">
|
|
73
|
<div style="width: 100%; font-weight: bold; margin-top: 5px;"> Thông tin bưu gửi</div>
|
|
74
|
|
|
75
|
<div style="display: flex;">
|
|
76
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px;">
|
|
77
|
Mã PYC
|
|
78
|
</div>
|
|
79
|
<div style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; ">
|
|
80
|
{table1.REQ_CODE}
|
|
81
|
</div>
|
|
82
|
</div>
|
|
83
|
|
|
84
|
<div style="display: flex;">
|
|
85
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
86
|
Ngày tháng gửi
|
|
87
|
</div>
|
|
88
|
<div
|
|
89
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
90
|
{table1.FROM_DATE}
|
|
91
|
</div>
|
|
92
|
</div>
|
|
93
|
|
|
94
|
<div style="display: flex;">
|
|
95
|
<div
|
|
96
|
style="width: 100%; font-weight: bold;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
97
|
Thông tin người gửi
|
|
98
|
</div>
|
|
99
|
</div>
|
|
100
|
|
|
101
|
<div style="display: flex;">
|
|
102
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
103
|
Tên họ
|
|
104
|
</div>
|
|
105
|
<div
|
|
106
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
107
|
{table1.EMP_NAME}
|
|
108
|
</div>
|
|
109
|
</div>
|
|
110
|
<div style="display: flex;">
|
|
111
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
112
|
SĐT
|
|
113
|
</div>
|
|
114
|
<div
|
|
115
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
116
|
{table1.PHONE}
|
|
117
|
</div>
|
|
118
|
</div>
|
|
119
|
<div style="display: flex;">
|
|
120
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
121
|
Phòng ban/Bộ phận
|
|
122
|
</div>
|
|
123
|
<div
|
|
124
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
125
|
{table1.DEP_NAME}
|
|
126
|
</div>
|
|
127
|
</div>
|
|
128
|
<div style="display: flex;">
|
|
129
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
130
|
Địa chỉ
|
|
131
|
</div>
|
|
132
|
<div
|
|
133
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
134
|
{table1.SHIPADDRES}
|
|
135
|
</div>
|
|
136
|
</div>
|
|
137
|
<div style="display: flex;">
|
|
138
|
<div
|
|
139
|
style="width: 100%; font-weight: bold;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
140
|
Thông tin người nhận
|
|
141
|
</div>
|
|
142
|
</div>
|
|
143
|
<div style="display: flex;">
|
|
144
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
145
|
Tên họ
|
|
146
|
</div>
|
|
147
|
<div
|
|
148
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
149
|
{table1.EMP_REVEICE_NAME}
|
|
150
|
</div>
|
|
151
|
</div>
|
|
152
|
<div style="display: flex;">
|
|
153
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
154
|
SĐT
|
|
155
|
</div>
|
|
156
|
<div
|
|
157
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
158
|
{table1.PHONE_NHAN}
|
|
159
|
</div>
|
|
160
|
</div>
|
|
161
|
<div style="display: flex;">
|
|
162
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
163
|
Địa chỉ
|
|
164
|
</div>
|
|
165
|
<div
|
|
166
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
167
|
{table1.LOCATION}
|
|
168
|
</div>
|
|
169
|
</div>
|
|
170
|
<div style="display: flex;">
|
|
171
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
172
|
Nội dung
|
|
173
|
</div>
|
|
174
|
<div
|
|
175
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
176
|
{table1.NOTE}
|
|
177
|
</div>
|
|
178
|
</div>
|
|
179
|
<div style="display: flex;">
|
|
180
|
<div
|
|
181
|
style="width: 100%; font-weight: bold;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
182
|
Loại hình phát
|
|
183
|
</div>
|
|
184
|
</div>
|
|
185
|
<div style="display: flex;">
|
|
186
|
<div style="width: 30%;border: 1px solid #000; padding: 0 10px; border-top: unset;">
|
|
187
|
Dịch vụ cộng thêm
|
|
188
|
</div>
|
|
189
|
<div
|
|
190
|
style="width: 70%;border: 1px solid #000; border-left: unset; padding: 0 10px; border-top: unset;">
|
|
191
|
{table1.ADD_SEVICE_NAME}
|
|
192
|
</div>
|
|
193
|
</div>
|
|
194
|
</td>
|
|
195
|
</tr>
|
|
196
|
</tbody>
|
|
197
|
</table>
|
|
198
|
<p>{table1.TableEnd}</p>
|
|
199
|
</div>',N'2A8DA7F5-7E42-4E7A-96AF-2E1F93FBDFFD',N'B9D1D131-27A0-4',N'A4',N'Biểu mẫu in nhãn giao nhận thư hàng hoá',N'1',N'baotq',N'Aug 21 2024 5:26PM',N'U',NULL,NULL,1)
|
|
200
|
INSERT INTO [CM_REPORT_TEMPLATE] ([REPORT_TEMPLATE_ID],[REPORT_TEMPLATE_NAME],[REPORT_TEMPLATE_STORE],[REPORT_TEMPLATE_CODE],[NOTES],[RECORD_STATUS],[MAKER_ID],[CREATE_DT],[AUTH_STATUS],[CHECKER_ID],[APPROVE_DT],[CURRENT_STEP])VALUES(N'2A8DA7F5-7E42-4E7A-96AF-2E1F93FBDFFD',N'Biểu mẫu in nhãn Gửi Thư/Hàng hoá',N'DELI_PRINT_DELIVERY_TEMP',N'PrintCargoMail',NULL,N'1',N'baotq',N'Aug 21 2024 5:26PM',N'A',NULL,NULL,NULL)
|