OaGmLogModel.php 4.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117
  1. <?php
  2. /**
  3. * OaGmLogModel.php UTF-8
  4. * oa首充和扶值 记录表
  5. *
  6. * @date : 2018/07/13 22:44
  7. *
  8. * @license 这不是一个自由软件,未经授权不许任何使用和传播。
  9. * @author : guxiannong <gxn@huosdk.com>
  10. * @version : HUOSDK 8.0
  11. */
  12. namespace huo\model\oa;
  13. use huo\model\common\CommonModel;
  14. use huolib\constant\OaConst;
  15. class OaGmLogModel extends CommonModel {
  16. protected $name = 'oa_gm_log';
  17. /**
  18. * 分页查询列表
  19. *
  20. * @param array $param
  21. * @param int $offset
  22. *
  23. * @param bool $get_sum
  24. *
  25. * @return \think\Paginator
  26. */
  27. public function getPageList($param = array(), $offset = 10, $get_sum = false) {
  28. $_offset = isset($param['list_rows']) ? $param['list_rows'] : $offset;
  29. $_order = isset($param['list_order']) ? $param['list_order'] : 'id desc';
  30. $_map = array();
  31. if (isset($param['app_id']) && !empty($param['app_id'])) {
  32. $_map['game_id'] = $param['app_id'];
  33. }
  34. if (isset($param['agent_id']) && !empty($param['agent_id'])) {
  35. $_map['agent_id'] = $param['agent_id'];
  36. }
  37. if (isset($param['type_id']) && !empty($param['type_id'])) {
  38. $_map['type_id'] = $param['type_id'];
  39. }
  40. if (isset($param['mem_id']) && !empty($param['mem_id'])) {
  41. $_map['mem_id'] = $param['mem_id'];
  42. }
  43. if (isset($param['check_status']) && !empty($param['check_status'])) {
  44. $_map['check_status'] = $param['check_status'];
  45. }
  46. if (isset($param['create_time']) && !empty($param['create_time'])) {
  47. $_map['create_time'] = $param['create_time'];
  48. }
  49. if (isset($param['status']) && !empty($param['status'])) {
  50. $_map['status'] = $param['status'];
  51. }
  52. if (isset($param['oa_gm_id']) && !empty($param['oa_gm_id'])) {
  53. $_map['oa_gm_id'] = $param['oa_gm_id'];
  54. }
  55. if (isset($param['role_name']) && !empty($param['role_name'])) {
  56. $_role_name = $param['role_name'];
  57. $_map['role_name'] = array('like', "%".$_role_name."%");
  58. }
  59. if (isset($param['username']) && !empty($param['username'])) {
  60. $_username = $param['username'];
  61. $_map['username'] = array('like', "%".$_username."%");
  62. }
  63. if (isset($param['node_name']) && !empty($param['node_name'])) {
  64. $_node_name = $param['node_name'];
  65. $_map['node_name'] = array('like', "%".$_node_name."%");
  66. }
  67. $_field = 'id,oa_gm_id,node_id,node_name,agent_id,username,oa_mem_id,mem_id,plat_id,type_id,oa_app_id';
  68. $_field .= ',check_status,status,content,check_reason,fail_reason,create_time,update_time';
  69. $_list_field = isset($param['list_field']) ? $param['list_field'] : $_field;
  70. if ($get_sum) {
  71. if (!isset($_map['status'])) {
  72. $_map['status'] = OaConst::STATUS_SUC;
  73. }
  74. $_list_field = isset($param['list_field']) ? $param['list_field'] : 'sum(money) as amount';
  75. $_data = $this
  76. ->field($_list_field)
  77. ->where($_map)
  78. ->find();
  79. } else {
  80. $_data = $this
  81. ->field($_list_field)
  82. ->where($_map)
  83. ->order($_order)
  84. ->paginate($_offset);
  85. }
  86. return $_data;
  87. }
  88. /**
  89. * 更新日志
  90. * @param array $update_arr
  91. * @param array $map
  92. *
  93. * @return bool
  94. */
  95. public function doUpdateLog($update_arr = array(), $map = array()) {
  96. $_gm_update_arr = $update_arr;
  97. $_gm_update_arr['update_time'] = time();
  98. if (isset($_gm_update_arr['check_reason'])) {
  99. $_gm_update_arr['check_reason'] = substr($_gm_update_arr['check_reason'], 0, 40);
  100. }
  101. if (isset($_gm_update_arr['fail_reason'])) {
  102. $_gm_update_arr['fail_reason'] = substr($_gm_update_arr['fail_reason'], 0, 40);
  103. }
  104. $_re = self::update($_gm_update_arr, $map, true);
  105. if (false === $_re) {
  106. return false;
  107. }
  108. return true;
  109. }
  110. }