Merge branch 'developer'
# Conflicts:
# zq-erp/pom.xml
| | |
| | | String title = "订单记录"; |
| | | orderSheet.setSheetName(title); |
| | | orderSheet.setTitle(title); |
| | | String[] header = {"订单号", "客户姓名", "客户手机", "下单时间", "订单总价", "折后价", "现金付款", "卡付款", "顾问姓名", "所属门店", "订单状态"}; |
| | | String[] header = {"订单号", "客户姓名", "客户手机", "下单时间", "订单总价", "折后价", "现金付款", "卡付款", "顾问姓名", "收银员", "所属门店", "订单状态"}; |
| | | orderSheet.setHeaders(header); |
| | | //门店只能查询本店自己的订单 |
| | | List<SysOrder> dataList = orderService.findInPage(sysOrder, null); |
| | |
| | | temp.add(item.getCashPay()); |
| | | temp.add(item.getCardPay()); |
| | | temp.add(item.getStaffName()); |
| | | temp.add(item.getCashierName()); |
| | | temp.add(item.getShopName()); |
| | | temp.add(item.getStatu()); |
| | | list.add(temp); |
| | |
| | | import com.matrix.system.common.tools.DataAuthUtil; |
| | | import com.matrix.system.common.tools.ResponseHeadUtil; |
| | | import com.matrix.system.constance.Dictionary; |
| | | import com.matrix.system.hive.action.util.QueryUtil; |
| | | import com.matrix.system.hive.bean.*; |
| | | import com.matrix.system.hive.dao.*; |
| | | import com.matrix.system.hive.dto.ServiceOrderTimeDto; |
| | |
| | | if (!DataAuthUtil.hasAllShopAuth()) { |
| | | projService.setShopId(getMe().getShopId()); |
| | | } |
| | | QueryUtil.setQueryLimitCom(projService); |
| | | List<SysProjServices> dataList = projServicesSerivce.findInPage(projService, pageVo); |
| | | AjaxResult result = new AjaxResult(AjaxResult.STATUS_SUCCESS, dataList, projServicesSerivce.findTotal(projService)); |
| | | return result; |
| | |
| | | String title = "服务订单明细"; |
| | | orderSheet.setSheetName(title); |
| | | orderSheet.setTitle(title); |
| | | String[] header = {"服务单号","会员名称", "会员手机号", "消耗金额","服务状态", "下单时间","预约时间","是否超时(超时分钟)", "床位", "美疗师", "配料师", "健康顾问", "所属门店"}; |
| | | String[] header = {"服务单号","会员名称", "会员手机号", "消耗金额","服务状态", "下单时间","预约时间","状态","是否超时(超时分钟)", "床位", "美疗师", "配料师", "健康顾问", "划扣人", "所属门店"}; |
| | | orderSheet.setHeaders(header); |
| | | |
| | | List<SysProjServices> dataList = projServicesSerivce.findByModel(projServices); |
| | |
| | | temp.add(item.getBeautiName()); |
| | | temp.add(item.getPlsName()); |
| | | temp.add(item.getCreateStaffName()); |
| | | temp.add(item.getCashierName()); |
| | | temp.add(item.getShopName()); |
| | | list.add(temp); |
| | | } |
| | |
| | | package com.matrix.system.hive.bean; |
| | | |
| | | import com.matrix.core.anotations.Extend; |
| | | import com.matrix.core.tools.DateUtil; |
| | | import org.springframework.format.annotation.DateTimeFormat; |
| | | |
| | |
| | | * 员工编号(美容顾问) 下单人id |
| | | */ |
| | | private Long staffId; |
| | | |
| | | /** |
| | | * 收银员姓名 |
| | | */ |
| | | @Extend |
| | | private String cashierName; |
| | | |
| | | |
| | | /** |
| | | * 收银员 |
| | | */ |
| | | private Long cashierId; |
| | | |
| | | /** |
| | | * 商机id |
| | | */ |
| | |
| | | */ |
| | | private String vipPhone; |
| | | |
| | | |
| | | private String staffName; |
| | | |
| | | private String shopName; |
| | |
| | | */ |
| | | private Integer isHasRefund; |
| | | |
| | | public String getCashierName() { |
| | | return cashierName; |
| | | } |
| | | |
| | | public void setCashierName(String cashierName) { |
| | | this.cashierName = cashierName; |
| | | } |
| | | |
| | | public Long getCashierId() { |
| | | return cashierId; |
| | | } |
| | | |
| | | public void setCashierId(Long cashierId) { |
| | | this.cashierId = cashierId; |
| | | } |
| | | |
| | | public Integer getIsHasRefund() { |
| | | return isHasRefund; |
| | | } |
| | |
| | | private Long beauticianId; |
| | | |
| | | /** |
| | | * 员工编号(美容顾问) 下单人id |
| | | */ |
| | | private Long staffId; |
| | | /** |
| | | * 收银员姓名 |
| | | */ |
| | | @Extend |
| | | private String cashierName; |
| | | |
| | | |
| | | /** |
| | | * 收银员 |
| | | */ |
| | | private Long cashierId; |
| | | |
| | | /** |
| | | * 仪器 |
| | | */ |
| | | private Long deviceId; |
| | |
| | | @Extend |
| | | private String pageFlae; |
| | | |
| | | public Long getStaffId() { |
| | | return staffId; |
| | | } |
| | | |
| | | public void setStaffId(Long staffId) { |
| | | this.staffId = staffId; |
| | | } |
| | | |
| | | public String getCashierName() { |
| | | return cashierName; |
| | | } |
| | | |
| | | public void setCashierName(String cashierName) { |
| | | this.cashierName = cashierName; |
| | | } |
| | | |
| | | public Long getCashierId() { |
| | | return cashierId; |
| | | } |
| | | |
| | | public void setCashierId(Long cashierId) { |
| | | this.cashierId = cashierId; |
| | | } |
| | | |
| | | public Integer getOvertimeNotice() { |
| | | return overtimeNotice; |
| | |
| | | * @param pageOrder |
| | | */ |
| | | private void updateOrderInfo(SysOrder pageOrder) { |
| | | |
| | | SysUsers user = (SysUsers) WebUtil.getSession().getAttribute(MatrixConstance.LOGIN_KEY); |
| | | pageOrder.setCashierId(user.getSuId()); |
| | | |
| | | pageOrder.setPayTime(new Date()); |
| | | |
| | | pageOrder.setStatu(Dictionary.ORDER_STATU_YFK); |
| | | List<SysOrderFlow> flows = pageOrder.getFlows(); |
| | | |
| | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | @Override |
| | | public int modifyHKProjServices(SysProjServices projServices) throws GlobleException { |
| | | SysUsers sysUsers = WebUtil.getSessionAttribute(MatrixConstance.LOGIN_KEY); |
| | | projServices = sysProjServicesDao.selectById(projServices.getId()); |
| | | if (!projServices.getState().equals(Dictionary.SERVICE_STATU_FWWC)) { |
| | | throw new GlobleException("该服务单状态为" + projServices.getState() + ",不可以进行当前操作!"); |
| | |
| | | |
| | | projServices.setState(Dictionary.SERVICE_STATU_FFJS); |
| | | projServices.setConsumeTime(new Date()); |
| | | projServices.setCashierId(sysUsers.getSuId()); |
| | | int result = sysProjServicesDao.update(projServices); |
| | | achieveNewService.addAchieveByServiceOrder(projServices); |
| | | |
| | |
| | | <result property="activity" column="ACTIVITY"/> |
| | | <result property="total" column="TOTAL"/> |
| | | |
| | | |
| | | <result property="statu" column="STATU"/> |
| | | <result property="zkTotal" column="ZK_TOTAL"/> |
| | | <result property="shopId" column="SHOP_ID"/> |
| | |
| | | <result property="cardPay" column="card_Pay"/> |
| | | <result property="arrears" column="arrears"/> |
| | | <result property="payTime" column="pay_time"/> |
| | | |
| | | <result property="cashierId" column="cashier_id"/> |
| | | <result property="cashierName" column="cashierName"/> |
| | | <!-- 扩展字段 --> |
| | | <result property="shopName" column="SHOP_NAME"/> |
| | | <result property="shopShortName" column="SHOP_SHORT_NAME"/> |
| | |
| | | pay_time, |
| | | company_id, |
| | | orderType, |
| | | is_has_refund |
| | | is_has_refund, |
| | | cashier_id |
| | | ) |
| | | VALUES ( |
| | | #{id}, |
| | |
| | | #{payTime}, |
| | | #{companyId}, |
| | | #{orderType}, |
| | | #{isHasRefund} |
| | | #{isHasRefund}, |
| | | #{cashierId} |
| | | ) |
| | | </insert> |
| | | |
| | |
| | | <if test="isHasRefund != null "> |
| | | is_has_refund = #{isHasRefund}, |
| | | </if> |
| | | |
| | | <if test="cashierId != null "> |
| | | cashier_id = #{cashierId}, |
| | | </if> |
| | | </set> |
| | | WHERE id=#{id} |
| | | </update> |
| | |
| | | <!-- 分页查询 --> |
| | | <select id="selectInPage" resultMap="SysOrderMap"> |
| | | select |
| | | a.*, b.VIP_NAME, c.su_name as STAFF_NAME, |
| | | a.*, b.VIP_NAME, c.su_name as STAFF_NAME, e.su_name as cashierName, |
| | | d.SHOP_NAME, b.PHONE |
| | | from sys_order a |
| | | LEFT JOIN sys_vip_info b on b.ID=a.VIP_ID |
| | | left JOIN sys_users c on c.su_id=a.STAFF_ID |
| | | left JOIN sys_users e on e.su_id=a.cashier_id |
| | | left JOIN sys_shop_info d on d.ID=a.SHOP_ID |
| | | where 1=1 |
| | | <if test="record!=null"> |
| | |
| | | </if> |
| | | <if test="record.staffId != null and record.staffId !='' "> |
| | | and a.STAFF_ID = #{record.staffId} |
| | | </if> |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="record.isCross != null and record.isCross !='' "> |
| | | and a.IS_CROSS = #{record.isCross} |
| | |
| | | <if test="record.staffId != null and record.staffId !='' "> |
| | | and a.STAFF_ID = #{record.staffId} |
| | | </if> |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="(record.companyId!=null and record.companyId!='') "> |
| | | and a.company_id = #{record.companyId} |
| | | </if> |
| | |
| | | <select id="selectById" resultMap="SysOrderMap"> |
| | | select |
| | | a.*, |
| | | c.su_name as STAFF_NAME, |
| | | c.su_name as STAFF_NAME, e.su_name as cashierName, |
| | | d.SHOP_NAME, |
| | | d.shop_short_name, |
| | | b.PHONE, |
| | |
| | | from sys_order a |
| | | LEFT JOIN sys_vip_info b on b.ID=a.VIP_ID |
| | | left JOIN sys_users c on c.su_id=a.STAFF_ID |
| | | left JOIN sys_users e on e.su_id=a.cashier_id |
| | | left JOIN sys_shop_info d on d.ID=a.SHOP_ID |
| | | where a.id=#{id} |
| | | </select> |
| | |
| | | |
| | | <if test="record.staffId != null and record.staffId !='' "> |
| | | and a.STAFF_ID = #{record.staffId} |
| | | </if> |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="record.isCross != null and record.isCross !='' "> |
| | | and a.IS_CROSS = #{record.isCross} |
| | |
| | | <if test="record.staffId != null and record.staffId !='' "> |
| | | and a.STAFF_ID = #{record.staffId} |
| | | </if> |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="record.isCross != null and record.isCross !='' "> |
| | | and a.IS_CROSS = #{record.isCross} |
| | | </if> |
| | |
| | | <result property="comment" column="comment"/> |
| | | <result property="reply" column="reply"/> |
| | | <result property="overtimeNotice" column="overtime_notice"/> |
| | | |
| | | <result property="cashierId" column="cashier_id"/> |
| | | <result property="cashierName" column="cashierName"/> |
| | | |
| | | |
| | | <result property="beautiName" column="beautiName"/> |
| | |
| | | <result property="createStaffName" column="createStaffName"/> |
| | | <result property="bedName" column="bedName"/> |
| | | <result property="vipName" column="VIP_Name"/> |
| | | |
| | | |
| | | <association property="vipInfo" resultMap="com.matrix.system.hive.dao.SysVipInfoDao.SysVipInfoMapSimple" ></association> |
| | | |
| | |
| | | company_id, |
| | | comment, |
| | | reply, |
| | | overtime_notice |
| | | overtime_notice, |
| | | cashier_id |
| | | ) |
| | | VALUES ( |
| | | #{id}, |
| | |
| | | #{companyId}, |
| | | #{comment}, |
| | | #{reply}, |
| | | #{overtimeNotice} |
| | | #{overtimeNotice}, |
| | | #{cashierId} |
| | | ) |
| | | |
| | | </insert> |
| | |
| | | <if test="overtimeNotice != null "> |
| | | overtime_notice = #{overtimeNotice}, |
| | | </if> |
| | | <if test="cashierId != null "> |
| | | cashier_id = #{cashierId}, |
| | | </if> |
| | | </set> |
| | | WHERE id=#{id} |
| | | </update> |
| | |
| | | (select su_name from sys_users f where a.CREATE_STAFF_ID=f.su_id ) as createStaffName, |
| | | (select su_name from sys_users j where a.BEAUTICIAN_ID=j.su_id ) as beautiName, |
| | | (select su_name from sys_users k where a.devision_id=k.su_id ) as plsName, |
| | | (select su_name from sys_users l where a.cashier_id=l.su_id ) as cashierName, |
| | | (select shop_name from sys_shop_info h where a.SHOP_ID=h.ID ) as shopName, |
| | | (select bed_name from sys_bed_info i where a.BED_ID=i.ID ) as bedName |
| | | FROM sys_proj_services a |
| | |
| | | </if> |
| | | <if test="record.state != null and record.state !='' "> |
| | | and a.STATE = #{record.state} |
| | | </if> |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | AND a.SHOP_ID = #{record.shopId} |
| | |
| | | and a.STATE = #{record.state} |
| | | </if> |
| | | |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="(record.companyId!=null and record.companyId!='') "> |
| | | and a.company_id = #{record.companyId} |
| | | </if> |
| | |
| | | (select su_name from sys_users f where a.CREATE_STAFF_ID=f.su_id ) as createStaffName, |
| | | (select su_name from sys_users j where a.BEAUTICIAN_ID=j.su_id ) as beautiName, |
| | | (select su_name from sys_users k where a.devision_id=k.su_id ) as plsName, |
| | | (select su_name from sys_users l where a.cashier_id=l.su_id ) as cashierName, |
| | | (select shop_name from sys_shop_info h where a.SHOP_ID=h.ID ) as shopName, |
| | | (select bed_name from sys_bed_info i where a.BED_ID=i.ID ) as bedName |
| | | FROM sys_proj_services a |
| | |
| | | (select su_name from sys_users f where a.CREATE_STAFF_ID=f.su_id ) as createStaffName, |
| | | (select su_name from sys_users j where a.BEAUTICIAN_ID=j.su_id ) as beautiName, |
| | | (select su_name from sys_users k where a.devision_id=k.su_id ) as plsName, |
| | | (select su_name from sys_users l where a.cashier_id=l.su_id ) as cashierName, |
| | | (select shop_name from sys_shop_info h where a.SHOP_ID=h.ID ) as shopName, |
| | | (select bed_name from sys_bed_info i where a.BED_ID=i.ID ) as bedName |
| | | FROM sys_proj_services a |
| | |
| | | <if test="record.state != null and record.state !='' "> |
| | | and a.STATE = #{record.state} |
| | | </if> |
| | | <if test="record.cashierId != null and record.cashierId !='' "> |
| | | and a.cashier_id = #{record.cashierId} |
| | | </if> |
| | | <if test="record.shopId != null and record.shopId !='' "> |
| | | AND a.SHOP_ID = #{record.shopId} |
| | | </if> |
| | |
| | | <th data-field="bedName">床位</th> |
| | | <th data-field="plsName" >配料师</th> |
| | | <th data-field="createStaffName">创建人</th> |
| | | <th data-field="cashierName">划扣人</th> |
| | | <th data-field="shopName">所属门店</th> |
| | | </tr> |
| | | </thead> |
| | |
| | | <th data-field="total">订单总价</th> |
| | | <th data-field="zkTotal">折后价</th> |
| | | <th data-field="staffName">顾问姓名</th> |
| | | <th data-field="cashierName">收银员</th> |
| | | <th data-field="cashPay">现金付款</th> |
| | | <th data-field="cardPay">卡付款</th> |
| | | <th data-field="arrears">欠款</th> |
| | |
| | | <th data-field="totalTime" data-sortable="true">服务时长</th> |
| | | <th data-field="isOverTime" data-formatter="overTime">超时时间</th> |
| | | <th data-field="createStaffName">下单顾问</th> |
| | | <th data-field="cashierName">划扣人</th> |
| | | <th data-field="shopName">门店</th> |
| | | <th data-sortable="true" data-field="id" data-formatter="buidOperate">操作</th> |
| | | </tr> |
| | |
| | | <th data-field="payTime" data-formatter="MGrid.getTime" |
| | | data-sortable="true">支付时间</th> |
| | | <th data-field="staffName">下单顾问</th> |
| | | <th data-field="cashierName">收银员</th> |
| | | <th data-field="cashPay">现金支付金额</th> |
| | | <th data-field="cardPay">卡支付金额</th> |
| | | <th data-field="arrears">欠款金额</th> |
| | |
| | | <th data-field="bedName">床位</th> |
| | | <th data-field="plsName" >配料师</th> |
| | | <th data-field="createStaffName">创建人</th> |
| | | <th data-field="cashierName">划扣人</th> |
| | | <th data-field="shopName">所属门店</th> |
| | | </tr> |
| | | </thead> |