Merge branch 'master' of http://bore.pub:10439/r/ERP_override
| | |
| | | {field: 'computeArea',width:180, title: t('order.computeArea'),editRender: { name: 'input'},filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged}, |
| | | {field: 'computeGrossArea',width:200, title: t('order.computeGrossArea'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged}, |
| | | {field: 'processingNote',width:200, title: t('order.processingNote'),editRender: { name: 'input'},filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged}, |
| | | {field: 'remarks',width:140, title: t('basicData.remarks'),editRender: { name: 'input'},filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged}, |
| | | {field: 'remarks',width:140, title: t('order.floorNumber'),editRender: { name: 'input'},filters:[{ data: '' }],slots: { filter: 'num1_filter' }, sortable: true,filterMethod:filterChanged}, |
| | | {field: 'shape',width:120, |
| | | title: t('order.shape'), |
| | | editRender: { name: 'input'}, |
| | |
| | | {field: 'operationOrderNumber', width:'150', title: t('productStock.operationOrderNumber'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'orderId', width: '150',title: t('order.orderId'),showOverflow:"ellipsis" ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'operationNumber', width: '100',title: t('order.OrderNum'), showOverflow:"ellipsis" ,filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'operateType', width: '120',title:'类型',filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'operateType', width: '120',title:t('mainBasicData.type'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'quantity', width: '140',title: t('order.quantity'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'orderDetail.productId',width: '100', title: t('order.productId'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'orderDetail.productName',width: '140', title: t('order.product'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | |
| | | {field: 'operator', width: '100',title: t('productStock.creator'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'operateTime', width:'140', title: t('productStock.productionDate'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'processId', width:'140', title: t('processCard.processId'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'type', width:'140', title: t('productStock.领出类型'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'type', width:'140', title: t('productStock.typeClaim'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'reviewed', width: '100',title: t('productStock.reviewed'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'reviewedTime', width: '140',title: t('productStock.approvedDate'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | | {field: 'remarks', width: '140',title: t('productStock.remarks'),filters:[{ data: '' }],slots: { filter: 'num1_filter' }}, |
| | |
| | | left join basic_glass_type bgt on bgt.type_id = a.type_id |
| | | <where> |
| | | <if test="glassTypeId != null and glassTypeId != ''"> |
| | | and a.type_id regexp #{glassTypeId} |
| | | and a.type_id like concat('%',#{glassTypeId},'%') |
| | | </if> |
| | | <if test="product.id != null and product.id != ''"> |
| | | and a.id regexp #{product.id} |
| | | and a.id like like concat('%',#{product.id},'%') |
| | | </if> |
| | | <if test="product.productName != null and product.productName != ''"> |
| | | and a.product_name regexp #{product.productName} |
| | | and a.product_name like concat('%',#{product.productName},'%') |
| | | </if> |
| | | <if test="product.basicGlassType.typeName != null and product.basicGlassType.typeName!= ''"> |
| | | and bgt.type_name regexp #{product.basicGlassType.typeName} |
| | | and bgt.type_name like concat('%',#{product.basicGlassType.typeName},'%') |
| | | </if> |
| | | <if test="product.query != null and product.query != ''"> |
| | | and a.query regexp #{product.query} |
| | | and a.query like concat('%',#{product.query},'%') |
| | | </if> |
| | | <if test="product.creator != null and product.creator != ''"> |
| | | and a.creator regexp #{product.creator} |
| | | and a.creator like concat('%',#{product.creator},'%') |
| | | </if> |
| | | <if test="product.createTime != null and product.createTime != ''"> |
| | | and date(a.create_time) regexp #{product.createTime} |
| | | and date(a.create_time) like concat('%',#{product.createTime},'%') |
| | | </if> |
| | | </where> |
| | | |