Merge branch 'master' of http://bore.pub:10439/r/ERP_override
| | |
| | | height: 25px; |
| | | font-weight: bold; |
| | | font-size: 15pt; |
| | | margin-left: 40px; |
| | | } |
| | | .row1 span{ |
| | | font-size: 15pt; |
| | | } |
| | | |
| | | .row2 span{ |
| | | font-size: 15pt; |
| | | } |
| | | |
| | | .row5 span{ |
| | | font-size: 10pt; |
| | | font-size: 15pt; |
| | | } |
| | | |
| | | .row6 { |
| | |
| | | font-weight: bold; |
| | | font-size: 12pt; |
| | | } |
| | | .row1 span { |
| | | font-size: 10pt; |
| | | } |
| | | .row2 span { |
| | | font-size: 10pt; |
| | | } |
| | | .row5 span { |
| | | font-size: 10pt; |
| | | } |
| | |
| | | <span>{{item.project}}</span> |
| | | <span>{{ item.building_number }}</span> |
| | | </div> |
| | | <div class="row3" v-if="JSON.parse(item.other_columns).S02==null">{{item.width}}*{{item.height}}={{item.quantity}}</div> |
| | | <div class="row3" v-else>{{JSON.parse(item.other_columns).S02}}={{item.quantity}}</div> |
| | | <div class="row3" v-if="item.other_columns!=null&&(JSON.parse(item.other_columns).S02!=null)">{{JSON.parse(item.other_columns).S02}}={{item.quantity}}</div> |
| | | <div class="row3" v-else-if="item.bend_radius!=null">{{item.width}}*{{item.height}}=R/{{item.bend_radius}}</div> |
| | | <div class="row3" v-else>{{item.width}}*{{item.height}}={{item.quantity}}</div> |
| | | <div class="row5"> |
| | | <span>{{item.glass_child}}</span> |
| | | <span>{{item.processing_note}}</span> |
| | |
| | | font-size: 12pt; |
| | | } |
| | | .row5 span { |
| | | font-size: 10pt; |
| | | font-size: 12pt; |
| | | } |
| | | |
| | | .row6 { |
| | |
| | | <span v-else></span> |
| | | </div> |
| | | |
| | | <div class="row3" v-if="item.other_columns==null||(JSON.parse(item.other_columns).S02==null)">{{item.width}}*{{item.height}}={{item.quantity}}</div> |
| | | <div class="row3" v-else>{{JSON.parse(item.other_columns).S02}}={{item.quantity}}</div> |
| | | <div class="row3" v-if="item.other_columns!=null&&(JSON.parse(item.other_columns).S02!=null)">{{JSON.parse(item.other_columns).S02}}={{item.quantity}}</div> |
| | | <div class="row3" v-else-if="item.bend_radius!=null">{{item.width}}*{{item.height}}=R/{{item.bend_radius}}</div> |
| | | <div class="row3" v-else>{{item.width}}*{{item.height}}={{item.quantity}}</div> |
| | | <div class="row5"> |
| | | <span>{{item.project}}</span> |
| | | <span>{{ item.building_number }}</span> |
| | |
| | | .row3 { |
| | | margin-top: -5px; |
| | | height: 25px; |
| | | font-size: 12pt; |
| | | font-size: 15pt; |
| | | font-weight: bolder; |
| | | } |
| | | |
| | |
| | | |
| | | @page { |
| | | size: auto; /* auto is the initial value */ |
| | | margin: 13mm 4mm 0mm 6mm /* this affects the margin in the printer settings */ |
| | | margin: 13mm 4mm 0mm 4mm /* this affects the margin in the printer settings */ |
| | | |
| | | } |
| | | |
| | |
| | | |
| | | @page { |
| | | size: auto; /* auto is the initial value */ |
| | | margin: 13mm 4mm 0mm 6mm /* this affects the margin in the printer settings */ |
| | | margin: 13mm 4mm 0mm 4mm /* this affects the margin in the printer settings */ |
| | | |
| | | } |
| | | |
| | |
| | | o.project, |
| | | od.building_number, |
| | | od.processing_note, |
| | | od.width, |
| | | od.height, |
| | | ogd.child_width as width, |
| | | ogd.child_height as height, |
| | | ogd.glass_child, |
| | | ogd.process, |
| | | e.type_name, |
| | | opd.stock_id, |
| | | od.quantity, |
| | | od.other_columns |
| | | od.other_columns, |
| | | od.bend_radius |
| | | from pp.optimize_detail opd |
| | | left join sd.`order` o on SUBSTR(opd.process_id, 1, 10) = o.order_id |
| | | left join sd.order_detail od |
| | |
| | | select o.order_id , |
| | | o.project, |
| | | o.customer_id , |
| | | od.width, |
| | | od.height, |
| | | ogd.child_width as width, |
| | | ogd.child_height as height, |
| | | od.quantity, |
| | | od.order_number as orderNumber, |
| | | fc.technology_number as technologyNumber, |
| | |
| | | ifnull(od.processing_note,'') as processing_note, |
| | | bgt.type_name, |
| | | od.other_columns, |
| | | od.building_number |
| | | od.building_number, |
| | | od.bend_radius |
| | | from sd.order as o |
| | | left join sd.order_detail as od on o.order_id = od.order_id |
| | | left join sd.order_glass_detail as ogd on ogd.order_id=od.order_id and ogd.order_number=od.order_number |