| | |
| | | let delivery = ref([]) |
| | | let money = ref("") |
| | | let otherMoneys = 0 |
| | | let sumMoney = 0 |
| | | let takeCare = "注意:请妥善保管好我司的玻璃架,如有丢失或损坏,按1500元只赔偿。谢谢配合!" |
| | | let remark = "备注:本批玻璃为优等合格品,请在卸货时,当面消点验收、如有质量问题在一周内与本公司联系,否则概不负责!" |
| | | |
| | |
| | | delivery.value=deepClone(res.data.delivery) |
| | | money.value=deepClone(res.data.money) |
| | | otherMoney.value=deepClone(res.data.otherMoney) |
| | | produceList.value.forEach(item => { |
| | | sumMoney+=item.DeliveryDetail.money |
| | | }) |
| | | |
| | | otherMoney1=[] |
| | | otherMoney=deepClone(res.data.otherMoney) |
| | | for(let i=0;i<otherMoney.length;i++){ |
| | |
| | | <td>{{item.DeliveryDetail.quantity}}</td> |
| | | <td>{{item.DeliveryDetail.area}}</td> |
| | | <td></td> |
| | | <td>{{item.DeliveryDetail.grossAmount}}</td> |
| | | <td>{{item.DeliveryDetail.money}}</td> |
| | | <td colspan="2"></td> |
| | | </tr> |
| | | |
| | |
| | | <td>{{delivery.quantity}}</td> |
| | | <td>{{delivery.area}}</td> |
| | | <td></td> |
| | | <td>{{parseFloat((delivery.money-otherMoneys-delivery.freight).toFixed(2))}}</td> |
| | | <td>{{sumMoney}}</td> |
| | | <td colspan="2"></td> |
| | | </tr> |
| | | <tr class="day-in"> |
| | |
| | | let otherMoney1 = [] |
| | | let money = ref("") |
| | | let otherMoneys = 0 |
| | | let sumMoney = 0 |
| | | let takeCare = "注意:请妥善保管好我司的玻璃架,如有丢失或损坏,按1500元只赔偿。谢谢配合!" |
| | | let remark = "备注:本批玻璃为优等合格品,请在卸货时,当面消点验收、如有质量问题在一周内与本公司联系,否则概不负责!" |
| | | |
| | |
| | | produceList.value = deepClone(res.data.data) |
| | | delivery.value=deepClone(res.data.delivery) |
| | | money.value=deepClone(res.data.money) |
| | | produceList.value.forEach(item => { |
| | | sumMoney+=item.DeliveryDetail.grossAmount |
| | | }) |
| | | otherMoney1=[] |
| | | otherMoney=deepClone(res.data.otherMoney) |
| | | for(let i=0;i<otherMoney.length;i++){ |
| | |
| | | <td>{{delivery.quantity}}</td> |
| | | <td>{{delivery.area}}</td> |
| | | <td></td> |
| | | <td>{{delivery.money-otherMoneys}}</td> |
| | | <td>{{sumMoney}}</td> |
| | | <td></td> |
| | | </tr> |
| | | <tr class="day-in"> |
| | |
| | | calculationAreaPrompt5:'Do you want to continue creating duplicate orders', |
| | | |
| | | pleaseCancelTheFilteringFirst:'Please cancel the selection first.', |
| | | grossAreaIsNot0:'存在实际总面积等于0', |
| | | } |
| | | |
| | | }, |
| | |
| | | printStatus:'Print times', |
| | | labelPrinting2:'Label printing 2', |
| | | addAutomatically:'Auto fill', |
| | | selectFill:'Selected fill' |
| | | selectFill:'Selected fill', |
| | | engineeringPrinting:'工程打印' |
| | | }, |
| | | reportingWorks:{ |
| | | glassNumber:'Code', |
| | |
| | | endOperationOrderNumber:'Transfer sequence number', |
| | | typeClaim:'Take out type', |
| | | |
| | | pleaseEnterTheBoxNumber:'请输入箱号', |
| | | |
| | | |
| | | }, |
| | | customer:{ |
| | |
| | | money:'Amount', |
| | | |
| | | pleaseSelectTheSameCustomerProject:'Please select the project for the same customer', |
| | | noMoney:'无金额', |
| | | freightPrice:'运费单价', |
| | | freightQuantity:'运费数量', |
| | | freight:'运费金额', |
| | | |
| | | }, |
| | | replenish:{ |
| | |
| | | sheet3:'浏览发货信息', |
| | | sheet5:'生产加工单弯钢(单片)', |
| | | oneClickStorage:'一键完工', |
| | | |
| | | quantityMount:'数量金额', |
| | | msg:{ |
| | | productCheck:'Пожалуйста, выберите продукт', |
| | | tableLengthNot:'Нет данных таблицы', |
| | |
| | | calculationAreaPrompt5:'Повторить заказ Создать', |
| | | |
| | | pleaseCancelTheFilteringFirst:'请先取消筛选', |
| | | grossAreaIsNot0:'存在实际总面积等于0', |
| | | } |
| | | |
| | | }, |
| | |
| | | printStatus:'打印次数', |
| | | labelPrinting2:'标签打印2', |
| | | addAutomatically:'自动填充', |
| | | selectFill:'自动填充' |
| | | selectFill:'自动填充', |
| | | engineeringPrinting:'工程打印' |
| | | }, |
| | | reportingWorks:{ |
| | | glassNumber:'number', |
| | |
| | | endOperationOrderNumber:'Номер заказа на завершение операции', |
| | | typeClaim:'Тип получения', |
| | | |
| | | pleaseEnterTheBoxNumber:'请输入箱号', |
| | | |
| | | |
| | | }, |
| | | customer:{ |
| | |
| | | money:'Сумма', |
| | | |
| | | pleaseSelectTheSameCustomerProject:'请选择相同客户的项目', |
| | | noMoney:'无金额', |
| | | freightPrice:'运费单价', |
| | | freightQuantity:'运费数量', |
| | | freight:'运费金额', |
| | | |
| | | }, |
| | | replenish:{ |
| | |
| | | |
| | | |
| | | <select id="getSelectCustomerDeliveryDate" > |
| | | select d.delivery_id,d.order_id,d.customer_id,d.customer_name, |
| | | select d.delivery_id,dd.order_id,d.customer_id,d.customer_name, |
| | | d.project,od.product_name,sum(dd.quantity) as quantity,sum(dd.area) as area,dd.price,sum(dd.money) as money, |
| | | date(d.create_time) as create_time |
| | | |
| | |
| | | |
| | | where date(d.create_time)>=#{startDate} and date(d.create_time) <= #{endDate} |
| | | and d.customer_id = #{orderDetail.order.customerId} |
| | | group by od.product_id |
| | | group by od.order_id,od.product_id |
| | | limit #{offset},#{pageSize}; |
| | | </select> |
| | | |
| | |
| | | where |
| | | date(d.create_time)>=#{startDate} and date(d.create_time) <= #{endDate} |
| | | and d.customer_id = #{orderDetail.order.customerId} |
| | | group by od.product_id, od.width, od.height) as zu |
| | | group by od.order_id,od.product_id) as zu |
| | | </select> |
| | | |
| | | <select id="getSelectCustomerOderDate" > |
| | |
| | | and date(o.create_time)>=#{startDate} and date(o.create_time) <= #{endDate} |
| | | and o.customer_id = #{orderDetail.order.customerId} |
| | | </where> |
| | | group by od.product_id |
| | | group by od.order_id,od.product_id |
| | | limit #{offset},#{pageSize}; |
| | | </select> |
| | | |
| | |
| | | and date(o.create_time)>=#{startDate} and date(o.create_time) <= #{endDate} |
| | | and o.customer_id = #{orderDetail.order.customerId} |
| | | </where> |
| | | group by od.product_id, od.width, od.height) as zu |
| | | group by od.order_id,od.product_id) as zu |
| | | </select> |
| | | |
| | | <select id="getCustomerList"> |
| | |
| | | |
| | | <select id="exportSelectCustomerDeliveryDate" > |
| | | select d.delivery_id, |
| | | d.order_id, |
| | | dd.order_id, |
| | | d.customer_name, |
| | | d.project, |
| | | od.product_name, |
| | |
| | | where date(d.create_time) >= #{startDate} |
| | | and date(d.create_time) <= #{endDate} |
| | | and d.customer_id = #{orderDetail.order.customerId} |
| | | group by od.product_id |
| | | group by od.order_id,od.product_id |
| | | |
| | | UNION ALL |
| | | |
| | |
| | | where date(o.create_time) >= #{startDate} |
| | | and date(o.create_time) <= #{endDate} |
| | | and o.customer_id = #{orderDetail.order.customerId} |
| | | group by od.product_id |
| | | group by od.order_id,od.product_id |
| | | |
| | | UNION ALL |
| | | |
| | |
| | | </if> |
| | | |
| | | </where> |
| | | group by dd.delivery_id,od.product_id |
| | | group by dd.delivery_id,dd.order_id,od.product_id |
| | | order by dd.delivery_id,dd.delivery_number |
| | | limit #{offset},#{pageSize}; |
| | | </select> |
| | |
| | | </if> |
| | | |
| | | </where> |
| | | group by dd.delivery_id,od.product_id) as zu |
| | | group by dd.delivery_id,dd.order_id,od.product_id) as zu |
| | | </select> |
| | | |
| | | <select id="getSelectDeliveryPrinting" resultMap="selectDeliveryDetailOrderDetail" > |
| | |
| | | left join sd.`order` o on dd.order_id=o.order_id |
| | | left join sd.customer c on d.customer_id=c.id |
| | | where date(d.create_time)>=#{dates[0]} and date(d.create_time) <= #{dates[1]} |
| | | group by dd.delivery_id,od.product_id |
| | | group by dd.delivery_id,dd.order_id,od.product_id |
| | | order by dd.delivery_id,dd.delivery_number |
| | | </select> |
| | | </mapper> |