CommonMapper.java 20 KB

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