Manage.php 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361
  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. $info = Dever::db('bill/cash')->find(array('id' => $id, 'clear' => true));
  49. } else {
  50. $id = $v;
  51. $info = Dever::db('bill/cash')->find(array('id' => $id, 'clear' => true));
  52. }
  53. if ($info['status'] != 1) {
  54. continue;
  55. }
  56. #已审核
  57. if ($audit == 2) {
  58. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
  59. $info = Dever::db('bill/cash')->find($id);
  60. if ($info && $info['type'] <= 10) {
  61. $where['where_id'] = $info['mid'];
  62. $where['cash'] = $info['cash'];
  63. Dever::db('agent/member')->upCash($where);
  64. }elseif ($info && $info['type'] == 11) {
  65. $tixian = Dever::db('bill/tixian')->find($info['type_id']);
  66. $where['where_id'] = $tixian['id'];
  67. $where['status'] = 1;
  68. $admin = Dever::load('manage/auth.data');
  69. $where['audit_admin'] = $admin['id'];
  70. Dever::db('bill/tixian')->update($where);
  71. }
  72. } else {
  73. #作废
  74. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 3, 'operdate' => time()));
  75. $info = Dever::db('bill/cash')->find($id);
  76. if ($info && $info['type'] == 11) {
  77. $tixian = Dever::db('bill/tixian')->find($info['type_id']);
  78. $where['where_id'] = $info['mid'];
  79. $where['cash'] = -1*$tixian['ycash'];
  80. Dever::db('agent/member')->upCash($where);
  81. $update['where_id'] = $tixian['id'];
  82. $update['status'] = 3;
  83. $admin = Dever::load('manage/auth.data');
  84. $update['audit_admin'] = $admin['id'];
  85. Dever::db('bill/tixian')->update($update);
  86. }
  87. }
  88. }
  89. }
  90. }
  91. public function tixianAuditUpdate($id, $name, $data)
  92. {
  93. Dever::config('base')->hook = true;
  94. $audit = Dever::param('audit', $data);
  95. $desc = Dever::param('audit_desc', $data);
  96. if ($audit > 1) {
  97. $mul_type = Dever::config('base')->mul_type;
  98. if ($mul_type == 2) {
  99. $list = Dever::db('bill/tixian')->select(array('status' => 1));
  100. } else {
  101. $list = explode(',', $id);
  102. }
  103. foreach ($list as $k => $v) {
  104. if (is_array($v)) {
  105. $id = $v['id'];
  106. $tixian = Dever::db('bill/tixian')->find(array('id' => $id, 'clear' => true));
  107. } else {
  108. $id = $v;
  109. $tixian = Dever::db('bill/tixian')->find(array('id' => $id, 'clear' => true));
  110. }
  111. if (!$tixian) {
  112. continue;
  113. }
  114. if ($tixian['status'] != 1) {
  115. continue;
  116. }
  117. $info = Dever::db('bill/cash')->find(array('type' => 11, 'type_id' => $id));
  118. if (!$info) {
  119. continue;
  120. }
  121. if ($audit == 2) {
  122. $admin = Dever::load('manage/auth.data');
  123. $where['audit_admin'] = $admin['id'];
  124. Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 2, 'audit_admin' => $where['audit_admin'],'operdate' => time()));
  125. if ($info && $info['status'] == 1) {
  126. Dever::db('bill/cash')->update(array('where_id' => $id, 'status' => 2, 'operdate' => time()));
  127. }
  128. # 通知短信
  129. if (Dever::project('sms')) {
  130. $member = Dever::db('agent/member')->find($info['mid']);
  131. Dever::load('sms/api')->send('daili_tixian_yes', $member['mobile'], array('name' => $member['name']));
  132. }
  133. } else {
  134. $admin = Dever::load('manage/auth.data');
  135. $where['audit_admin'] = $admin['id'];
  136. Dever::db('bill/tixian')->update(array('where_id' => $id, 'status' => 3, 'audit_admin' => $where['audit_admin'],'operdate' => time()));
  137. $w = array();
  138. $w['where_id'] = $info['mid'];
  139. $w['cash'] = -1*$tixian['ycash'];
  140. Dever::db('agent/member')->upCash($w);
  141. /*
  142. $update = array();
  143. $update['where_id'] = $info['id'];
  144. $update['status'] = 3;
  145. Dever::db('bill/cash')->update($update);
  146. */
  147. # 通知短信
  148. if (Dever::project('sms')) {
  149. $member = Dever::db('agent/member')->find($info['mid']);
  150. Dever::load('sms/api')->send('daili_tixian_no', $member['mobile'], array('name' => $member['name'], 'content' => $desc));
  151. }
  152. }
  153. }
  154. }
  155. }
  156. public function sellUpdate($id, $name, $data)
  157. {
  158. Dever::config('base')->hook = true;
  159. $mid = Dever::param('mid', $data);
  160. $num = Dever::param('num', $data);
  161. $desc = Dever::param('desc', $data);
  162. $type = Dever::param('type', $data);
  163. if ($mid && $num && $desc) {
  164. $member = Dever::db('agent/member')->find($mid);
  165. if ($member && $member['status'] == 2) {
  166. if ($type == 1) {
  167. Dever::load('bill/lib/sell.push_one_commit', $mid, $num, $member['role'], $id, $desc);
  168. } else {
  169. Dever::load('bill/lib/sell.push_all_commit', $mid, $num, $member['role'], $id, $desc);
  170. }
  171. } else {
  172. Dever::db('bill/push_sell')->update(array('where_id' => $id, 'status' => 2));
  173. Dever::alert('代理商未审核通过,发放失败');
  174. }
  175. }
  176. }
  177. # 获取新增业绩
  178. public function getSellNewNum($num, $month, $mid)
  179. {
  180. $where = array('month' => $month, 'mid' => $mid);
  181. $search = Dever::search_button();
  182. if ($search) {
  183. $where['config']['group'] = $search[0];
  184. $where['config']['col'] = str_replace('|id', '', $search[1]);
  185. }
  186. if ($num < 0) {
  187. $num = 0;
  188. }
  189. $new_num = 0;
  190. $prev = Dever::db('bill/sell_stat')->prev($where);
  191. if ($prev && $num > 0 && $prev['num'] >= 0) {
  192. $new_num = $num - $prev['num'];
  193. }
  194. return $new_num;
  195. }
  196. #提现导出
  197. public function tixian_out($data){
  198. $header = array('提现单号', '姓名', '手机号', '身份证号', '会员角色', '提现金额', '到账金额', '手续费金额', '申请时间', '审核时间', '审核状态', '发放时间','发放状态','审核人', '来源');
  199. $body = array();
  200. foreach($data as $k => $v){
  201. $member = Dever::db('agent/member')->find(array('id'=>$v['mid']));
  202. $role = Dever::db('setting/role')->find(array('id'=>$member['role']));
  203. if($v['status'] == -1){
  204. $status = '未审核待发放';
  205. $audit = '待审核';
  206. }elseif($v['status'] == 1){
  207. $status = '已审核待发放';
  208. $audit = '已审核';
  209. }elseif($v['status'] == 2){
  210. $status = '已发放';
  211. $audit = '已审核';
  212. }else{
  213. $status = '已作废';
  214. $audit = '已作废';
  215. }
  216. $cdate = date('Y-m-d H:i',$v['cdate']);
  217. $cash = Dever::db('bill/cash')->find($v['cash_id']);
  218. if ($cash['operdate']) {
  219. $adate = date('Y-m-d H:i',$cash['operdate']);
  220. } else {
  221. $adate = '-';
  222. }
  223. if ($v['operdate']) {
  224. $operdate = date('Y-m-d H:i',$v['operdate']);
  225. } else {
  226. $operdate = '-';
  227. }
  228. if($v['audit_admin']){
  229. $admin = Dever::load('manage/admin-find',$v['audit_admin']);
  230. $username = $admin['username'];
  231. }else{
  232. $username = '';
  233. }
  234. if($v['ycash'] < 0){
  235. $ycash = $v['ycash'] * (-1);
  236. }else{
  237. $ycash = $v['ycash'];
  238. }
  239. if($v['cash'] < 0){
  240. $cash = $v['cash'] * (-1);
  241. }else{
  242. $cash = $v['cash'];
  243. }
  244. $d = array
  245. (
  246. $v['order_num'],
  247. $member['name'],
  248. $member['mobile'],
  249. $member['idcard'],
  250. $role['name'],
  251. $ycash,
  252. $cash,
  253. $ycash-$cash,
  254. $cdate,
  255. $adate,
  256. $audit,
  257. $operdate,
  258. $status,
  259. $username,
  260. '',
  261. );
  262. $body[] = $d;
  263. }
  264. $file = Dever::input('excel_name');
  265. return Dever::excelExport($body, $header, $file);
  266. }
  267. #归店统计导出
  268. public function out_shop_stat($data){
  269. $header = array('月份', '门店名称','门店编号','所属代理商', '采购金额','归店业绩(除创V外)','创客数','创V数','名额外创V','名额外创V业绩');
  270. $body = array();
  271. foreach($data as $k => $v){
  272. $month = date('Y-m',$v['month'])."\t";
  273. $shop = Dever::db('shop/info')->find(array('id'=>$v['shop_id']));
  274. if($shop['mid'] && $shop['mid'] >0){
  275. $member = Dever::db('agent/member')->find($shop['mid']);
  276. if($member){
  277. $dl_mobile = $member['mobile'];
  278. }else{
  279. $dl_mobile = '-';
  280. }
  281. }else{
  282. $dl_mobile = '-';
  283. }
  284. $d = array
  285. (
  286. $month,
  287. $shop['name'],
  288. $shop['sid'],
  289. $dl_mobile,
  290. $v['c_money'],
  291. $v['dl_money'],
  292. $v['ck_num'],
  293. $v['v_num'],
  294. $v['out_num'],
  295. $v['out_money'],
  296. );
  297. $body[] = $d;
  298. }
  299. $file = Dever::input('excel_name');
  300. return Dever::excelExport($body, $header, $file);
  301. }
  302. #归店列表显示
  303. public function shop_stat_api($id){
  304. $info = Dever::db('bill/shop_stat')->find($id);
  305. $shop = Dever::db('shop/info')->find($info['shop_id']);
  306. $html = $shop['name'];
  307. $html .= '<br />' .$shop['sid'];
  308. if($shop['agent_mid'] && $shop['agent_mid']>0){
  309. $member = Dever::db('agent/member')->find($shop['agent_mid']);
  310. if($member){
  311. $html .= '<br />' .$member['name'].$member['mobile'];
  312. }
  313. }
  314. return $html;
  315. }
  316. public function guidian($mid){
  317. $member = Dever::db('agent/member')->find($mid);
  318. $area = Dever::load("area/api.string", $member['area']);
  319. $data = array();
  320. $data = $member['name'].'<br/>'.$member['mobile'].'<br/>'.$area;
  321. return $data;
  322. }
  323. public function role($mid){
  324. $member = Dever::db('agent/member')->find($mid);
  325. $role = Dever::db('setting/role')->find($member['role']);
  326. $data = array();
  327. $data = $role['name'];
  328. return $data;
  329. }
  330. public function yeji($mid){
  331. $start = Dever::input('search_option_start_dever_time');
  332. $end = Dever::input('search_option_dever_time');
  333. $where['start'] = $start;
  334. $where['end'] = $end;
  335. $where['mid'] = $mid;
  336. $where['state'] = 1;
  337. $money = Dever::db('agent/order')->getCount($where);
  338. return $money['total'];
  339. }
  340. }