Manage.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255
  1. <?php
  2. namespace Bill\Lib;
  3. use Dever;
  4. class Manage
  5. {
  6. public function cashUpdate($id, $name, $data)
  7. {
  8. Dever::config('base')->hook = true;
  9. $mid = Dever::param('mid', $data);
  10. $cash = Dever::param('cash', $data);
  11. $desc = Dever::param('desc', $data);
  12. if ($mid && $cash && $desc) {
  13. $member = Dever::db('agent/member')->find($mid);
  14. if ($member && $member['status'] == 2) {
  15. Dever::load('bill/lib/cash')->up($mid, 10, $cash, $member['role'], $id, $desc, 2);
  16. $where['where_id'] = $mid;
  17. $where['cash'] = $cash;
  18. Dever::db('agent/member')->upCash($where);
  19. } else {
  20. Dever::db('bill/push_cash')->update(array('where_id' => $id, 'status' => 2));
  21. Dever::alert('代理商未审核通过,发放失败');
  22. }
  23. }
  24. }
  25. public function cashAuditUpdateStart($param, $name, $data)
  26. {
  27. $mul_type = Dever::config('base')->mul_type;
  28. if ($mul_type == 2) {
  29. $list = Dever::db('bill/cash')->select(array('status' => 1));
  30. } else {
  31. $list = explode(',', $param['where_id']);
  32. }
  33. }
  34. public function cashAuditUpdate($id, $name, $data)
  35. {
  36. Dever::config('base')->hook = true;
  37. $audit = Dever::param('audit', $data);
  38. if ($audit > 1) {
  39. $mul_type = Dever::config('base')->mul_type;
  40. if ($mul_type == 2) {
  41. $list = Dever::db('bill/cash')->select(array('status' => 1));
  42. } else {
  43. $list = explode(',', $id);
  44. }
  45. foreach ($list as $k => $v) {
  46. if (is_array($v)) {
  47. $id = $v['id'];
  48. } else {
  49. $id = $v;
  50. $info = Dever::db('bill/cash')->find(array('id' => $id, 'clear' => true));
  51. }
  52. if ($info['status'] != 1) {
  53. continue;
  54. }
  55. #已审核
  56. if ($audit == 2) {
  57. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
  58. $info = Dever::db('bill/cash')->find($id);
  59. if ($info && $info['type'] <= 10) {
  60. $where['where_id'] = $info['mid'];
  61. $where['cash'] = $info['cash'];
  62. Dever::db('agent/member')->upCash($where);
  63. }elseif ($info && $info['type'] == 11) {
  64. $tixian = Dever::db('bill/tixian')->find($info['type_id']);
  65. $where['where_id'] = $tixian['id'];
  66. $where['status'] = 1;
  67. Dever::db('bill/tixian')->update($where);
  68. }
  69. } else {
  70. #作废
  71. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
  72. $info = Dever::db('bill/cash')->find($id);
  73. if ($info && $info['type'] == 11) {
  74. $tixian = Dever::db('bill/tixian')->find($info['type_id']);
  75. $where['where_id'] = $info['mid'];
  76. $where['cash'] = -1*$tixian['ycash'];
  77. Dever::db('agent/member')->upCash($where);
  78. $update['where_id'] = $tixian['id'];
  79. $update['status'] = 3;
  80. Dever::db('bill/tixian')->update($update);
  81. }
  82. }
  83. }
  84. }
  85. }
  86. public function tixianAuditUpdate($id, $name, $data)
  87. {
  88. Dever::config('base')->hook = true;
  89. $audit = Dever::param('audit', $data);
  90. $desc = Dever::param('audit_desc', $data);
  91. if ($audit > 1) {
  92. $mul_type = Dever::config('base')->mul_type;
  93. if ($mul_type == 2) {
  94. $list = Dever::db('bill/tixian')->select(array('status' => 1));
  95. } else {
  96. $list = explode(',', $id);
  97. }
  98. foreach ($list as $k => $v) {
  99. if (is_array($v)) {
  100. $id = $v['id'];
  101. } else {
  102. $id = $v;
  103. $info = Dever::db('bill/tixian')->find(array('id' => $id, 'clear' => true));
  104. }
  105. if ($info['status'] != 1) {
  106. continue;
  107. }
  108. $info = Dever::db('bill/cash')->find(array('type' => 11, 'type_id' => $id));
  109. if (!$info) {
  110. continue;
  111. }
  112. if ($audit == 2) {
  113. Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
  114. if ($info && $info['status'] == 1) {
  115. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
  116. }
  117. # 通知短信
  118. if (Dever::project('sms')) {
  119. $member = Dever::db('agent/member')->find($info['mid']);
  120. Dever::load('sms/api')->send('daili_tixian_yes', $member['mobile'], array('name' => $member['name']));
  121. }
  122. } else {
  123. Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
  124. # 通知短信
  125. if (Dever::project('sms')) {
  126. $member = Dever::db('agent/member')->find($info['mid']);
  127. Dever::load('sms/api')->send('daili_tixian_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
  128. }
  129. }
  130. }
  131. }
  132. }
  133. public function sellUpdate($id, $name, $data)
  134. {
  135. Dever::config('base')->hook = true;
  136. $mid = Dever::param('mid', $data);
  137. $num = Dever::param('num', $data);
  138. $desc = Dever::param('desc', $data);
  139. $type = Dever::param('type', $data);
  140. if ($mid && $num && $desc) {
  141. $member = Dever::db('agent/member')->find($mid);
  142. if ($member && $member['status'] == 2) {
  143. if ($type == 1) {
  144. Dever::load('bill/lib/sell.push_one_commit', $mid, $num, $member['role'], $id, $desc);
  145. } else {
  146. Dever::load('bill/lib/sell.push_all_commit', $mid, $num, $member['role'], $id, $desc);
  147. }
  148. } else {
  149. Dever::db('bill/push_sell')->update(array('where_id' => $id, 'status' => 2));
  150. Dever::alert('代理商未审核通过,发放失败');
  151. }
  152. }
  153. }
  154. # 获取新增业绩
  155. public function getSellNewNum($num, $month, $mid)
  156. {
  157. $where = array('month' => $month, 'mid' => $mid);
  158. $search = Dever::search_button();
  159. if ($search) {
  160. $where['config']['group'] = $search[0];
  161. $where['config']['col'] = str_replace('|id', '', $search[1]);
  162. }
  163. if ($num < 0) {
  164. $num = 0;
  165. }
  166. $new_num = 0;
  167. $prev = Dever::db('bill/sell_stat')->prev($where);
  168. if ($prev && $num > 0 && $prev['num'] >= 0) {
  169. $new_num = $num - $prev['num'];
  170. }
  171. return $new_num;
  172. }
  173. #提现导出
  174. public function tixian_out_api(){
  175. $status = Dever::input('search_option_status');
  176. $start = Dever::input('search_option_start_cdate');
  177. $end = Dever::input('search_option_end_cdate');
  178. if($start){
  179. $starts=strtotime($start);
  180. }
  181. if($end){
  182. $ends=strtotime($end);
  183. }
  184. $header = array('提现单号', '姓名', '手机号', '身份证号', '会员角色', '提现金额', '到账金额', '手续费金额', '申请时间', '审核时间', '审核状态','发放状态','审核人', '来源');
  185. if($status && isset($starts) && $starts && isset($ends) && $ends){
  186. $data = Dever::db('bill/tixian')->getExcelAll(array('start'=>$starts,'end'=>$ends,'status'=>$status,'state'=>1));
  187. }elseif($status){
  188. $data = Dever::db('bill/tixian')->getExcelAll(array('status'=>$status,'state'=>1));
  189. }elseif(isset($starts) && $starts && isset($ends) && $ends){
  190. $data = Dever::db('bill/tixian')->getExcelAll(array('start'=>$starts,'end'=>$ends,'state'=>1));
  191. }else{
  192. $data = Dever::db('bill/tixian')->getExcelAll(array('state'=>1));
  193. }
  194. $body = array();
  195. foreach($data as $k => $v){
  196. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  197. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  198. if($v['audit'] == 1){
  199. $audit = '待审核';
  200. }elseif($v['audit'] == 2){
  201. $audit = '已审核';
  202. }else{
  203. $audit = '已作废';
  204. }
  205. if($v['status'] == -1){
  206. $status = '未审核待发放';
  207. }elseif($v['status'] == 1){
  208. $status = '已审核待发放';
  209. }elseif($v['status'] == 2){
  210. $status = '已发放';
  211. }else{
  212. $status = '已作废';
  213. }
  214. $cdate = date('Y-m-d H:i',$v['cdate']);
  215. $operdate = date('Y-m-d H:i',$v['operdate']);
  216. $admin = Dever::load('manage/auth.data');
  217. $d = array
  218. (
  219. $v['order_num'],
  220. $member['name'],
  221. "'".$member['mobile'],
  222. "'".$member['idcard'],
  223. $role['name'],
  224. $v['ycash'],
  225. $v['cash'],
  226. $v['ycash']-$v['cash'],
  227. $cdate,
  228. $operdate,
  229. $audit,
  230. $status,
  231. $admin['username'],
  232. '',
  233. );
  234. $body[] = $d;
  235. }
  236. $file = '每日提现';
  237. Dever::excelExport($body, $header, $file);
  238. }
  239. }