Manage.php 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308
  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. $admin = Dever::load('manage/auth.data');
  68. $where['audit_admin'] = $admin['id'];
  69. Dever::db('bill/tixian')->update($where);
  70. }
  71. } else {
  72. #作废
  73. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
  74. $info = Dever::db('bill/cash')->find($id);
  75. if ($info && $info['type'] == 11) {
  76. $tixian = Dever::db('bill/tixian')->find($info['type_id']);
  77. $where['where_id'] = $info['mid'];
  78. $where['cash'] = -1*$tixian['ycash'];
  79. Dever::db('agent/member')->upCash($where);
  80. $update['where_id'] = $tixian['id'];
  81. $update['status'] = 3;
  82. $admin = Dever::load('manage/auth.data');
  83. $update['audit_admin'] = $admin['id'];
  84. Dever::db('bill/tixian')->update($update);
  85. }
  86. }
  87. }
  88. }
  89. }
  90. public function tixianAuditUpdate($id, $name, $data)
  91. {
  92. Dever::config('base')->hook = true;
  93. $audit = Dever::param('audit', $data);
  94. $desc = Dever::param('audit_desc', $data);
  95. if ($audit > 1) {
  96. $mul_type = Dever::config('base')->mul_type;
  97. if ($mul_type == 2) {
  98. $list = Dever::db('bill/tixian')->select(array('status' => 1));
  99. } else {
  100. $list = explode(',', $id);
  101. }
  102. foreach ($list as $k => $v) {
  103. if (is_array($v)) {
  104. $id = $v['id'];
  105. } else {
  106. $id = $v;
  107. $info = Dever::db('bill/tixian')->find(array('id' => $id, 'clear' => true));
  108. }
  109. if ($info['status'] != 1) {
  110. continue;
  111. }
  112. $info = Dever::db('bill/cash')->find(array('type' => 11, 'type_id' => $id));
  113. if (!$info) {
  114. continue;
  115. }
  116. if ($audit == 2) {
  117. $admin = Dever::load('manage/auth.data');
  118. $where['audit_admin'] = $admin['id'];
  119. Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 2, 'audit_admin' => $where['audit_admin'],'operdate' => time()));
  120. if ($info && $info['status'] == 1) {
  121. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
  122. }
  123. # 通知短信
  124. if (Dever::project('sms')) {
  125. $member = Dever::db('agent/member')->find($info['mid']);
  126. Dever::load('sms/api')->send('daili_tixian_yes', $member['mobile'], array('name' => $member['name']));
  127. }
  128. } else {
  129. $admin = Dever::load('manage/auth.data');
  130. $where['audit_admin'] = $admin['id'];
  131. Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 3, 'audit_admin' => $where['audit_admin'],'operdate' => time()));
  132. # 通知短信
  133. if (Dever::project('sms')) {
  134. $member = Dever::db('agent/member')->find($info['mid']);
  135. Dever::load('sms/api')->send('daili_tixian_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
  136. }
  137. }
  138. }
  139. }
  140. }
  141. public function sellUpdate($id, $name, $data)
  142. {
  143. Dever::config('base')->hook = true;
  144. $mid = Dever::param('mid', $data);
  145. $num = Dever::param('num', $data);
  146. $desc = Dever::param('desc', $data);
  147. $type = Dever::param('type', $data);
  148. if ($mid && $num && $desc) {
  149. $member = Dever::db('agent/member')->find($mid);
  150. if ($member && $member['status'] == 2) {
  151. if ($type == 1) {
  152. Dever::load('bill/lib/sell.push_one_commit', $mid, $num, $member['role'], $id, $desc);
  153. } else {
  154. Dever::load('bill/lib/sell.push_all_commit', $mid, $num, $member['role'], $id, $desc);
  155. }
  156. } else {
  157. Dever::db('bill/push_sell')->update(array('where_id' => $id, 'status' => 2));
  158. Dever::alert('代理商未审核通过,发放失败');
  159. }
  160. }
  161. }
  162. # 获取新增业绩
  163. public function getSellNewNum($num, $month, $mid)
  164. {
  165. $where = array('month' => $month, 'mid' => $mid);
  166. $search = Dever::search_button();
  167. if ($search) {
  168. $where['config']['group'] = $search[0];
  169. $where['config']['col'] = str_replace('|id', '', $search[1]);
  170. }
  171. if ($num < 0) {
  172. $num = 0;
  173. }
  174. $new_num = 0;
  175. $prev = Dever::db('bill/sell_stat')->prev($where);
  176. if ($prev && $num > 0 && $prev['num'] >= 0) {
  177. $new_num = $num - $prev['num'];
  178. }
  179. return $new_num;
  180. }
  181. #提现导出
  182. public function tixian_out_api(){
  183. $status = Dever::input('search_option_status');
  184. $start = Dever::input('search_option_start_cdate');
  185. $end = Dever::input('search_option_end_cdate');
  186. $where = array();
  187. $where['state'] = 1;
  188. if($start){
  189. $where['start']=strtotime($start);
  190. }
  191. if($end){
  192. $where['end']=strtotime($end);
  193. }
  194. $where['status'] = $status;
  195. $header = array('提现单号', '姓名', '手机号', '身份证号', '会员角色', '提现金额', '到账金额', '手续费金额', '申请时间', '审核时间', '审核状态','发放状态','审核人', '来源');
  196. $data = Dever::db('bill/tixian')->getExcelAll($where);
  197. $body = array();
  198. foreach($data as $k => $v){
  199. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  200. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  201. if($v['status'] == -1){
  202. $status = '未审核待发放';
  203. $audit = '待审核';
  204. }elseif($v['status'] == 1){
  205. $status = '已审核待发放';
  206. $audit = '已审核';
  207. }elseif($v['status'] == 2){
  208. $status = '已发放';
  209. $audit = '已审核';
  210. }else{
  211. $status = '已作废';
  212. $audit = '已作废';
  213. }
  214. $cdate = date('Y-m-d H:i',$v['cdate']);
  215. $operdate = date('Y-m-d H:i',$v['operdate']);
  216. if($v['audit_admin']){
  217. $admin = Dever::load('manage/admin-find',$v['audit_admin']);
  218. $username = $admin['username'];
  219. }else{
  220. $username = '';
  221. }
  222. if($v['ycash'] < 0){
  223. $ycash = $v['ycash'] * (-1);
  224. }else{
  225. $ycash = $v['ycash'];
  226. }
  227. if($v['cash'] < 0){
  228. $cash = $v['cash'] * (-1);
  229. }else{
  230. $cash = $v['cash'];
  231. }
  232. $d = array
  233. (
  234. $v['order_num'],
  235. $member['name'],
  236. $member['mobile'],
  237. $member['idcard'],
  238. $role['name'],
  239. $ycash,
  240. $cash,
  241. $ycash-$cash,
  242. $cdate,
  243. $operdate,
  244. $audit,
  245. $status,
  246. $username,
  247. '',
  248. );
  249. $body[] = $d;
  250. }
  251. $file = '每日提现';
  252. Dever::excelExport($body, $header, $file);
  253. }
  254. #归店统计导出
  255. public function out_shop_stat_api(){
  256. $start = Dever::input('search_option_start_month');
  257. $end = Dever::input('search_option_end_month');
  258. $where = array();
  259. $where['state'] = 1;
  260. if($start){
  261. $where['start'] = strtotime($start);
  262. }
  263. if($end){
  264. $where['end'] = strtotime($end);
  265. }
  266. $data = Dever::db('bill/shop_stat')->getExcelAll($where);
  267. $header = array('月份', '店铺名称', '代理商数量', '创V名额外数量', '创V名额内数量', '代理商业绩', '创V名额外业绩', '创V名额内业绩');
  268. $body = array();
  269. foreach($data as $k => $v){
  270. $month = date('Y-m',$v['month'])."\t";
  271. $shop = Dever::db('shop/info')->find(array('id'=>$v['shop_id']));
  272. $d = array
  273. (
  274. $month,
  275. $shop['name'],
  276. $v['dl_num'],
  277. $v['out_num'],
  278. $v['nei_num'],
  279. $v['dl_money'],
  280. $v['out_money'],
  281. $v['nei_money'],
  282. );
  283. $body[] = $d;
  284. }
  285. $file = '归店统计';
  286. Dever::excelExport($body, $header, $file);
  287. }
  288. }