CommonMapper.java 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577
  1. package com.gree.mall.manager.commonmapper;
  2. import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
  3. import com.baomidou.mybatisplus.core.metadata.IPage;
  4. import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
  5. import com.gree.mall.manager.bean.admin.AdminCompanyPayConfigVO;
  6. import com.gree.mall.manager.bean.charging.ChargingStandardBean;
  7. import com.gree.mall.manager.bean.common.AmityUrlVO;
  8. import com.gree.mall.manager.bean.goods.*;
  9. import com.gree.mall.manager.bean.listvo.*;
  10. import com.gree.mall.manager.bean.listvo.goods.GoodsLibraryVO;
  11. import com.gree.mall.manager.bean.listvo.goods.GoodsMaterialStockAccVO;
  12. import com.gree.mall.manager.bean.listvo.order.PunishOrderVO;
  13. import com.gree.mall.manager.bean.listvo.param.ExamineZfireParamBean;
  14. import com.gree.mall.manager.bean.listvo.param.WorkOrderZfireParam;
  15. import com.gree.mall.manager.bean.listvo.workorder.*;
  16. import com.gree.mall.manager.bean.member.UserCompanyAttrBean;
  17. import com.gree.mall.manager.bean.member.UserCompanyDeliveryBean;
  18. import com.gree.mall.manager.bean.order.LeaseOrderVO;
  19. import com.gree.mall.manager.bean.order.refund.OrderOfflineRefundVO;
  20. import com.gree.mall.manager.bean.settle.SettleExpenseItemVO;
  21. import com.gree.mall.manager.bean.settle.SettleExpenseVO;
  22. import com.gree.mall.manager.bean.settle.SettleMonthWagesVO;
  23. import com.gree.mall.manager.bean.settle.SettleMonthWagesWorkerVO;
  24. import com.gree.mall.manager.bean.settle.repair.*;
  25. import com.gree.mall.manager.bean.workorder.*;
  26. import com.gree.mall.manager.enums.UserTypeEnum;
  27. import com.gree.mall.manager.plus.entity.User;
  28. import com.gree.mall.manager.zfire.bean.WorkerParamBean;
  29. import com.gree.mall.manager.zfire.bean.ZfireParamBean;
  30. import org.apache.ibatis.annotations.Mapper;
  31. import org.apache.ibatis.annotations.Param;
  32. import java.math.BigDecimal;
  33. import java.util.Date;
  34. import java.util.List;
  35. @Mapper
  36. public interface CommonMapper {
  37. /**
  38. * 分类
  39. * @param page
  40. * @param zfireParamBean
  41. * @return
  42. */
  43. public IPage<ChargingStandardTypeVO> chargingStandardTypeList(IPage page, @Param("ex")ZfireParamBean zfireParamBean);
  44. /**
  45. * 收费标准
  46. * @param page
  47. * @param zfireParamBean
  48. * @Param
  49. * @return
  50. */
  51. public IPage<ChargingStandardVO> chargingStandardList(IPage page,@Param("ex") ZfireParamBean zfireParamBean);
  52. /**
  53. * 故障排查
  54. * @param page
  55. * @param zfireParamBean
  56. * @return
  57. */
  58. public IPage<ChargingStandard2VO> chargingStandardList2(IPage page, @Param("ex") ZfireParamBean zfireParamBean);
  59. /**
  60. * 师傅列表
  61. * @param page
  62. * @param zfireParamBean
  63. * @param isOK
  64. * @return
  65. */
  66. public IPage<UserVO> userList(IPage page, @Param("ex") WorkerParamBean zfireParamBean, @Param("type") UserTypeEnum type, @Param("isOK") Boolean isOK);
  67. /**
  68. * 分销员列表
  69. * @param page
  70. * @param zfireParamBean
  71. * @return
  72. */
  73. public IPage<User2VO> userServiceList(IPage page, @Param("ex") ZfireParamBean zfireParamBean);
  74. /**
  75. * 客户列表
  76. * @param page
  77. * @param zfireParamBean
  78. * @return
  79. */
  80. public IPage<UserCustomerVO> userCustomerList(IPage page,@Param("ex") ZfireParamBean zfireParamBean);
  81. /**
  82. * 收费标准brandId,oneCategoryId,twoCategoryId,content1
  83. */
  84. @InterceptorIgnore(tenantLine = "1", blockAttack = "1", illegalSql = "1")
  85. public IPage<ChargingStandardBean> queryChargingStandrdList(IPage page,
  86. @Param("type") Integer type,
  87. @Param("status") Boolean status,
  88. @Param("brandId") String brandId,
  89. @Param("oneCategoryId") String oneCategoryId,
  90. @Param("twoCategoryId") String twoCategoryId,
  91. @Param("content1") String content1,
  92. @Param("id") String id,
  93. @Param("companyWechatId") String companyWechatId);
  94. IPage<AmityUrlVO> amityList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  95. /**
  96. * 工单类型
  97. * @param page
  98. * @param zfireParamBean
  99. * @return
  100. */
  101. @InterceptorIgnore(tenantLine = "1", blockAttack = "1", illegalSql = "1")
  102. public IPage<OrderSmallTypeVO> orderSmallTypeList(IPage page,@Param("ex") ZfireParamBean zfireParamBean);
  103. /**
  104. * 工单列表
  105. * @param page
  106. * @param zfireParamBean
  107. * @return
  108. */
  109. @InterceptorIgnore(tenantLine = "1", blockAttack = "1", illegalSql = "1")
  110. public IPage<OrderBaseVO> orderBaseList(IPage page, @Param("ex") WorkOrderZfireParam zfireParamBean,@Param("adminUserType") Integer adminUserType
  111. ,@Param("companyWechatId") String companyWechatId);
  112. /**
  113. * 考核项目配件列表
  114. * @param page
  115. * @param zfireParamBean
  116. * @return
  117. */
  118. IPage<ExamineProjectConfigVO> examineProjectConfigList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  119. /**
  120. * 考核项目列表
  121. * @param page
  122. * @param zfireParamBean
  123. * @param adminUserType
  124. * @return
  125. */
  126. IPage<ExamineProjectVO> examineProjectList(Page page, @Param("ex") ZfireParamBean zfireParamBean, @Param("adminUserType") Integer adminUserType);
  127. /**
  128. * 安装结算标准列表
  129. * @param page
  130. * @param zfireParamBean
  131. * @return
  132. */
  133. IPage<OrderBaseAppraiseVO> orderBaseAppraiseList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  134. /**
  135. * 考核项目列表
  136. */
  137. IPage<InstallSettleNormVO> installNormList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  138. /**
  139. * 维修结算标准列表
  140. * @param page
  141. * @param zfireParamBean
  142. * @return
  143. */
  144. IPage<RepairSettleNormVO> repairNormList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  145. /**
  146. * 其它结算标准列表
  147. * @param page
  148. * @param zfireParamBean
  149. * @return
  150. */
  151. IPage<OtherSettleNormVO> otherNormList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  152. /**
  153. * 结算单列表
  154. * @param page
  155. * @param zfireParamBean
  156. * @return
  157. */
  158. IPage<SettleOrderVO> settleOrderList(Page page, @Param("ex") ZfireParamBean zfireParamBean, @Param("websitIds") List<String> websitId);
  159. /**
  160. * 汇总结算单列表
  161. * @param page
  162. * @param zfireParamBean
  163. * @return
  164. */
  165. IPage<SettlePoolVO> settlePoolList(Page page, @Param("ex") ZfireParamBean zfireParamBean, @Param("websitIds") List<String> websitId);
  166. /**
  167. * 汇总结算单明细
  168. * @param id
  169. * @param workerName
  170. * @param mobile
  171. * @param idcard
  172. * @param orderBaseId
  173. * @param customerName
  174. * @param customerMobile
  175. * @param orderSmallType
  176. * @param settleOrderType
  177. * @return
  178. */
  179. List<SettlePoolWorkerVO> poolDetailList(@Param("id") String id,
  180. @Param("workerName") String workerName,
  181. @Param("mobile") String mobile,
  182. @Param("idcard") String idcard,
  183. @Param("orderBaseId") String orderBaseId,
  184. @Param("customerName") String customerName,
  185. @Param("customerMobile") String customerMobile,
  186. @Param("orderSmallType") String orderSmallType,
  187. @Param("settleOrderType") String settleOrderType);
  188. /**
  189. * 待入驻用户列表
  190. * @param page
  191. * @param zfireParamBean
  192. * @return
  193. */
  194. IPage<UserWaitVO> userWaitList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  195. /**
  196. * 订单结算管理列表
  197. * @param page
  198. * @param zfireParamBean
  199. * @return
  200. */
  201. IPage<IncreOrderVO> increOrderSettleList(Page page, @Param("ex") ZfireParamBean zfireParamBean, @Param("isSettleList") Boolean isSettleList);
  202. /**
  203. * 订单网点分账统计列表
  204. * @param page
  205. * @param zfireParamBean
  206. * @return
  207. */
  208. IPage<WebsitOrderSettleCountVO> websitOrderSettleCountList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  209. /**
  210. * 工单列表
  211. * @param page
  212. * @param zfireParamBean
  213. * @return
  214. */
  215. @InterceptorIgnore(tenantLine = "1", blockAttack = "1", illegalSql = "1")
  216. IPage<OrderBase2VO> orderBaseList2(Page page, @Param("ex") WorkOrderZfireParam zfireParamBean, @Param("adminUserType") Integer adminUserType);
  217. /**
  218. * 订单网点分账统计列表
  219. * @param page
  220. * @param zfireParamBean
  221. * @return
  222. */
  223. IPage<WorkerOrderSettleCountVO> workerOrderSettleCountList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  224. /**
  225. * 商品物料列表
  226. * @param page
  227. * @param zfireParamBean
  228. * @return
  229. */
  230. IPage<GoodsMaterialVO> goodsMaterialList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  231. /**
  232. * 商品采购入库列表
  233. * @param page
  234. * @param zfireParamBean
  235. * @return
  236. */
  237. IPage<GoodsPurchaseVO> goodsPurchaseList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  238. /**
  239. * 商品采购入库商品列表
  240. * @param page
  241. * @param zfireParamBean
  242. * @return
  243. */
  244. IPage<GoodsPurchaseItemVO> goodsPurchaseItemList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  245. /**
  246. * 商品采购入库条码列表
  247. * @param page
  248. * @param zfireParamBean
  249. * @return
  250. */
  251. IPage<GoodsPurchaseCodeVO> goodsPurchaseCodeList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  252. /**
  253. * 线下销售订单列表
  254. * @param page
  255. * @param zfireParamBean
  256. * @return
  257. */
  258. IPage<OrderInfoVO> queryOrderInfoList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  259. /**
  260. * 商品采购退货列表
  261. * @param page
  262. * @param zfireParamBean
  263. * @return
  264. */
  265. IPage<GoodsPurchaseRetVO> goodsPurchaseRetList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  266. /**
  267. * 商品采购退货商品列表
  268. * @param page
  269. * @param zfireParamBean
  270. * @return
  271. */
  272. IPage<GoodsPurchaseRetItemVO> goodsPurchaseRetItemList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  273. /**
  274. * 商品采购退货商品列表
  275. * @param page
  276. * @param zfireParamBean
  277. * @return
  278. */
  279. IPage<GoodsPurchaseRetCodeVO> goodsPurchaseRetCodeList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  280. /**
  281. * 商品物料库存三级帐列表
  282. * @param page
  283. * @param zfireParamBean
  284. * @return
  285. */
  286. IPage<GoodsMaterialStockAccVO> goodsMaterialStockAccList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  287. /**
  288. * 处罚单列表
  289. * @param page
  290. * @param zfireParamBean
  291. * @return
  292. */
  293. IPage<PunishOrderVO> punishOrderList(Page page,@Param("ex") ExamineZfireParamBean zfireParamBean);
  294. /**
  295. * 线下销售退货单
  296. */
  297. IPage<OrderOfflineRefundVO> orderOfflineRefundList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  298. /**
  299. * 师傅费用结算汇总列表
  300. * @param page
  301. * @param zfireParamBean
  302. * @return
  303. */
  304. IPage<SettleExpenseVO> workerSettleExpenseGatherList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  305. /**
  306. * 师傅费用结算列表
  307. * @param page
  308. * @param zfireParamBean
  309. * @return
  310. */
  311. IPage<SettleExpenseItemVO> workerSettleExpenseList(Page page, @Param("ex") ZfireParamBean zfireParamBean, @Param("workerId") String workerId);
  312. /**
  313. * 月度工资汇总列表
  314. * @param page
  315. * @param zfireParamBean
  316. * @return
  317. */
  318. IPage<SettleMonthWagesVO> settleMonthWagesGatherList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  319. /**
  320. * 月度工资师傅列表
  321. * @param page
  322. * @param zfireParamBean
  323. * @return
  324. */
  325. IPage<SettleMonthWagesWorkerVO> settleMonthWagesList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  326. /**
  327. * 租赁产品列表
  328. * @param objectPage
  329. * @param keyword
  330. * @param categoryIds
  331. * @param startPrice
  332. * @param endPrice
  333. * @param startDeposit
  334. * @param endDeposit
  335. * @param sortStr
  336. * @param status
  337. * @param companyWechatIds
  338. * @return
  339. */
  340. IPage<GoodsLeaseBean> goodsLeaseList(Page<Object> objectPage, @Param("keyword") String keyword,
  341. @Param("categoryIds") List<String> categoryIds,
  342. @Param("startPrice") BigDecimal startPrice,
  343. @Param("endPrice") BigDecimal endPrice,
  344. @Param("startDeposit") BigDecimal startDeposit,
  345. @Param("endDeposit") BigDecimal endDeposit,
  346. @Param("sortStr") String sortStr,
  347. @Param("status") Boolean status,
  348. @Param("companyWechatIds") List<String> companyWechatIds);
  349. /**
  350. * 租赁订单列表
  351. * @param objectPage
  352. * @param orderId
  353. * @param goodsName
  354. * @param userName
  355. * @param userMobile
  356. * @param status
  357. * @param startDate
  358. * @param endDate
  359. * @param startPayDate
  360. * @param endPayDate
  361. * @param companyWechatIds
  362. * @return
  363. */
  364. IPage<LeaseOrderVO> leaseOrderList(Page<Object> objectPage,
  365. @Param("orderId") String orderId,
  366. @Param("goodsName") String goodsName,
  367. @Param("userName") String userName,
  368. @Param("userMobile") String userMobile,
  369. @Param("status") String status,
  370. @Param("startDate") Date startDate,
  371. @Param("endDate") Date endDate,
  372. @Param("startPayDate") Date startPayDate,
  373. @Param("endPayDate") Date endPayDate,
  374. @Param("companyWechatIds") List<String> companyWechatIds);
  375. /**
  376. * 商品库列表
  377. * @param page
  378. * @param zfireParamBean
  379. * @return
  380. */
  381. IPage<GoodsLibraryVO> goodsLibraryList(Page page,@Param("ex") ZfireParamBean zfireParamBean);
  382. /**
  383. * 商户支付配置
  384. * @param page
  385. * @param zfireParamBean
  386. * @return
  387. */
  388. IPage<AdminCompanyPayConfigVO> adminCompanyPayConfigList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  389. /**
  390. * 维修日结银行账户列表
  391. * @param page
  392. * @param zfireParamBean
  393. * @return
  394. */
  395. IPage<DailyBankAccountVO> repairSettleBankAccountList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  396. /**
  397. * 维修日结算扣款配置列表
  398. * @param page
  399. * @param zfireParamBean
  400. * @return
  401. */
  402. IPage<DailyWithholdVO> repairSettleDailyWithholdList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  403. /**
  404. * 维修日结算扣款配置列表
  405. * @param page
  406. * @param zfireParamBean
  407. * @return
  408. */
  409. IPage<DailyImportSummaryVO> repairSettleDailyImportSummaryList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  410. /**
  411. * 结算数据导入明细列表
  412. * @param page
  413. * @param zfireParamBean
  414. * @return
  415. */
  416. IPage<DailyImportSummaryItemVO> repairDetailList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  417. /**
  418. * 增减费用管理列表
  419. * @param page
  420. * @param zfireParamBean
  421. * @return
  422. */
  423. IPage<DailyIncrDecrCostCountVO> reduceCountList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  424. /**
  425. * 增减费用明细列表
  426. * @param page
  427. * @param zfireParamBean
  428. * @return
  429. */
  430. IPage<DailyIncrDecrCostVO> repairSettleDailyincrDecrCostList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  431. /**
  432. * 需扣回工单费用管理列表
  433. * @param page
  434. * @param zfireParamBean
  435. * @return
  436. */
  437. IPage<DailyReduceCostGatherVO> reduceTotalList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  438. /**
  439. * 需扣回工单费用明细列表
  440. * @param page
  441. * @param zfireParamBean
  442. * @return
  443. */
  444. IPage<DailyReduceCostVO> reduceList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  445. /**
  446. * 师傅待扣费用列表
  447. * @param page
  448. * @param zfireParamBean
  449. * @return
  450. */
  451. IPage<WorkerWaitBuckleVO> buckleList(Page page, @Param("ex") ZfireParamBean zfireParamBean);
  452. /**
  453. * 银行接口返回查询列表
  454. * @param page
  455. * @param zfireParamBean
  456. * @param companyWechatIds
  457. * @return
  458. */
  459. IPage<SettleDailyBankTransferRecordVO> transferList(Page page,
  460. @Param("ex") ZfireParamBean zfireParamBean,
  461. @Param("companyWechatIds") List<String> companyWechatIds);
  462. /**
  463. * 维修工单结算清单列表
  464. * @param page
  465. * @param zfireParamBean
  466. * @param companyWechatIds
  467. * @return
  468. */
  469. IPage<AllDailyImportSummaryItemVO> repairAllList(Page page,
  470. @Param("ex") ZfireParamBean zfireParamBean,
  471. @Param("companyWechatIds") List<String> companyWechatIds);
  472. /**
  473. * 维修工单结算清单列表
  474. * @param companyWechatIds
  475. * @param adminWebsitIds
  476. * @return
  477. */
  478. Integer repairAllCount(@Param("companyWechatIds") List<String> companyWechatIds,
  479. @Param("adminWebsitIds") List<String> adminWebsitIds,
  480. @Param("status") Integer status);
  481. /**
  482. * 商户配送员
  483. * @param companyWechatId
  484. * @param nickName
  485. * @param mobile
  486. * @return
  487. */
  488. IPage<UserCompanyDeliveryBean> companyDelivery(Page<Object> page,
  489. @Param("companyWechatId") String companyWechatId,
  490. @Param("nickName") String nickName,
  491. @Param("mobile") String mobile);
  492. /**
  493. * 商户授信人员
  494. * @param objectPage
  495. * @param companyWechatId
  496. * @param nickName
  497. * @param mobile
  498. * @return
  499. */
  500. IPage<UserCompanyAttrBean> companyCredit(Page<Object> objectPage,
  501. @Param("companyWechatId") String companyWechatId,
  502. @Param("nickName") String nickName,
  503. @Param("mobile") String mobile);
  504. }