WarehouseDetail.php 6.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192
  1. <?php
  2. declare (strict_types = 1);
  3. namespace app\model\warehouse;
  4. use library\basic\BaseModel;
  5. use think\db\exception\DbException;
  6. use think\facade\Db;
  7. use think\Model;
  8. /**
  9. * @mixin \think\Model
  10. */
  11. class WarehouseDetail extends BaseModel
  12. {
  13. private $config = [
  14. 'refund' => array("code" => "快递退款", "content" => "订单号:{order_id},退款操作,扣除金额{money}元。"),
  15. 'income' => array('code' => "快递结算", "content" => "在{time},总订单量:{count}单,结算金额{money}元。"),
  16. 'warehouse_add' => array('code' => "后台转账", "content" => "在{time},后台向你转账{money}元,其他说明:{mono}。"),
  17. 'warehouse_jdd' => array('code' => "后台扣款", "content" => "在{time},后台向你扣款{money}元,其他说明:{mono}。"),
  18. 'tx' => array('code' => "账号提现", "content" => "在{time},你发起来提现操作!"),
  19. ];
  20. /**
  21. * 退款金额
  22. * @param $money
  23. * @param $contentId
  24. * @param $uid
  25. * @param $param
  26. */
  27. public function refund($money,$uid,$param = [],$sassid){
  28. try {
  29. self::beginTrans();
  30. $param['time'] = date('Y-m-d H:i:s');
  31. $param['money'] = $money;
  32. $content = $this->TplParam($this->config['refund']['content'], $param);
  33. $post['uid'] = $uid;
  34. $post['v'] = $money;
  35. $post['code'] = 'refund';
  36. $post['title'] = $this->config['refund']['code'];
  37. $post['content'] = $content;
  38. $post['type'] = 1;
  39. $post['sassid'] = $sassid;
  40. $post['time'] = time();
  41. $post['money'] = (new Member)->where('uid', $uid)->value('money') + $money;
  42. $this->insert($post);
  43. $bool = Db::name("member")->where('uid',$uid)->inc('money',floatval($money))->update();
  44. self::commitTrans();
  45. if($bool > 0) {
  46. return true;
  47. } else {
  48. return false;
  49. }
  50. }catch (DbException $db){
  51. self::rollbackTrans();
  52. return false;
  53. }
  54. }
  55. /**
  56. * 收入-[包含推广 | 退款]
  57. * @param $money
  58. * @param $contentId
  59. * @param $uid
  60. * @param $param
  61. */
  62. public function income($money,$warehouse_id,$param){
  63. try {
  64. self::beginTrans();
  65. //$param['time'] = date('Y-m-d H:i:s');
  66. $param['money'] = $money;
  67. $content = $this->TplParam($this->config['income']['content'], $param);
  68. $post['warehouse_id'] = $warehouse_id;
  69. $post['v'] = $money;
  70. $post['code'] = 'income';
  71. $post['title'] = $this->config['income']['code'];
  72. $post['content'] = $content;
  73. $post['type'] = 1;
  74. $post['time'] = time();
  75. $post['money'] = (new \app\model\warehouse\Warehouse)->where('id', $warehouse_id)->value('money') + $money;
  76. $this->insert($post);
  77. $bool = Db::name("warehouse")->where('id',$warehouse_id)->inc('money',floatval($money))->update();
  78. self::commitTrans();
  79. if($bool > 0) {
  80. return true;
  81. } else {
  82. return false;
  83. }
  84. }catch (DbException $db){
  85. self::rollbackTrans();
  86. return false;
  87. }
  88. }
  89. /**
  90. * 减少数据
  91. * @param $money
  92. * @param $uid
  93. * @param $type
  94. * @param $param
  95. * @param $sassid
  96. * @return bool
  97. */
  98. public function adminInc($money,$warehouse_id,$param,$type){
  99. try {
  100. self::beginTrans();
  101. $param['time'] = date('Y-m-d H:i:s');
  102. $param['money'] = $money;
  103. $content = $this->TplParam($this->config[$type == 'add' ? 'warehouse_add' : 'warehouse_jdd']['content'], $param);
  104. $post['warehouse_id'] = $warehouse_id;
  105. $post['v'] = $money;
  106. $post['code'] = 'admin_tz';
  107. $post['title'] = $this->config[ $type == 'add' ? 'warehouse_add' : 'warehouse_jdd' ]['code'];
  108. $post['content'] = $content;
  109. $post['type'] = $type == 'add' ? 1 : 2;
  110. $post['time'] = time();
  111. if($type == 'add')
  112. $post['money'] = (new \app\model\warehouse\Warehouse)->where('id', $warehouse_id)->value('money') + $money;
  113. else
  114. $post['money'] = (new \app\model\warehouse\Warehouse)->where('id', $warehouse_id)->value('money') - $money;
  115. $this->insert($post);
  116. if($type == 'add')
  117. $bool = Db::name("warehouse")->where('id',$warehouse_id)->inc('money',floatval($money))->update();
  118. else
  119. $bool = Db::name("warehouse")->where('id',$warehouse_id)->dec('money',floatval($money))->update();
  120. self::commitTrans();
  121. if($bool > 0) {
  122. return true;
  123. } else {
  124. return false;
  125. }
  126. }catch (DbException $db){
  127. self::rollbackTrans();
  128. return false;
  129. }
  130. }
  131. /**
  132. * 提现
  133. * @param $money
  134. * @param $warehouse_id
  135. * @param $param
  136. * @param $type
  137. * @return bool
  138. */
  139. public function tx($money,$warehouse_id,$param){
  140. try {
  141. self::beginTrans();
  142. $param['time'] = date('Y-m-d H:i:s');
  143. $param['money'] = $money;
  144. $content = $this->TplParam($this->config['tx']['content'], $param);
  145. $post['warehouse_id'] = $warehouse_id;
  146. $post['v'] = $money;
  147. $post['code'] = 'tx';
  148. $post['title'] = $this->config['tx']['code'];
  149. $post['content'] = $content;
  150. $post['type'] = 2;
  151. $post['time'] = time();
  152. $post['money'] = (new \app\model\warehouse\Warehouse)->where('id', $warehouse_id)->value('money') - $money;
  153. $this->insert($post);
  154. $bool = Db::name("warehouse")->where('id',$warehouse_id)->dec('money',floatval($money))->update();
  155. self::commitTrans();
  156. if($bool > 0) {
  157. return true;
  158. } else {
  159. return false;
  160. }
  161. }catch (DbException $db){
  162. self::rollbackTrans();
  163. return false;
  164. }
  165. }
  166. /**
  167. * 转义的模板信息
  168. */
  169. private function TplParam($content) {
  170. $data = func_get_args();
  171. foreach ($data[1] as $k => $v) {
  172. $content = str_replace('{' . $k . '}', $v, $content);
  173. }
  174. return $content;
  175. }
  176. }