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> |