Cron.php 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558
  1. <?php
  2. namespace Bill\Lib;
  3. use Dever;
  4. class Cron
  5. {
  6. # 校正金额和业绩
  7. public function jz_api()
  8. {
  9. $member = Dever::db('agent/member')->select();
  10. if ($member) {
  11. foreach ($member as $v) {
  12. $where['mid'] = $v['id'];
  13. $data = Dever::db('bill/cash')->getCash($where);
  14. if ($data && $data['total']) {
  15. Dever::db('agent/member')->update(array('where_id' => $v['id'], 'cash' => $data['total']));
  16. }
  17. }
  18. }
  19. }
  20. public function sell_api()
  21. {
  22. # 按月份统计团队业绩和直推业绩
  23. $month = Dever::input('month', date('Y-m'));
  24. $start_time = $month .'-01 00:00:00';
  25. $end_time = date('Y-m-d', strtotime($start_time. ' +1 month -1 day')).' 23:59:59';
  26. // $where['type'] = '2';
  27. $where['start'] = Dever::maketime($start_time);
  28. $where['end'] = Dever::maketime($end_time);
  29. $data = Dever::db('bill/sell')->getNumByTime($where);
  30. if ($data) {
  31. foreach ($data as $k => $v) {
  32. if ($v['num'] > 0) {
  33. $w = array();
  34. $w['mid'] = $v['mid'];
  35. $w['month'] = $where['start'];
  36. $w['clear'] = true;
  37. $info = Dever::db('bill/sell_stat')->find($w);
  38. $where['mid'] = $v['mid'];
  39. $where['type'] = $v['type'];
  40. $total = Dever::db('bill/sell')->getNumByTimeOne($where);
  41. if ($v['type'] == 1) {
  42. $w['new_ztnum'] = $v['num'];
  43. if ($total) {
  44. $w['zt_num'] = $total['num'];
  45. }
  46. } else {
  47. $w['new_num'] = $v['num'];
  48. if ($total) {
  49. $w['num'] = $total['num'];
  50. }
  51. }
  52. if ($info) {
  53. $w['where_id'] = $info['id'];
  54. Dever::db('bill/sell_stat')->update($w);
  55. } else {
  56. Dever::db('bill/sell_stat')->insert($w);
  57. }
  58. }
  59. }
  60. }
  61. return 'ok';
  62. }
  63. # 权益使用情况统计:类型、商品名、总发放数量、总使用数量
  64. public function goods_api()
  65. {
  66. $num = Dever::input('num', 5);
  67. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  68. $end = Dever::input('end', date('Y-m-d'));
  69. $start = Dever::maketime($start . ' 00:00:00');
  70. $end = Dever::maketime($end . ' 23:59:59');
  71. $day = intval(($end - $start)/86400);
  72. for($i=0; $i<=$day; $i++) {
  73. $where['start'] = $start + 86400*$i;
  74. $where['end'] = $start + 86400*$i + 86399;
  75. $goods = Dever::db('agent/member_goods')->findAll($where);
  76. if ($goods) {
  77. foreach ($goods as $k => $v) {
  78. $data = array();
  79. $data['day'] = $where['start'];
  80. $data['type'] = $v['type'];
  81. $data['type_id'] = $v['type_id'];
  82. $data['sku_id'] = $v['sku_id'];
  83. $info = Dever::db('bill/goods_stat')->find($data);
  84. $data['total_num'] = $v['total_num'];
  85. $data['sell_num'] = $v['sell_num'];
  86. $data['cash'] = $v['cash'];
  87. $data['price'] = $v['price'];
  88. $data['name'] = $v['name'];
  89. if ($info) {
  90. $data['where_id'] = $info['id'];
  91. Dever::db('bill/goods_stat')->update($data);
  92. } else {
  93. Dever::db('bill/goods_stat')->insert($data);
  94. }
  95. }
  96. }
  97. }
  98. }
  99. # 区域分润
  100. /*
  101. 区域毛利 = 区域内所有门店的采购商品的零售价总额 x 30%
  102. 城市分润 = 区域毛利 x 1%
  103. 区县分润 = 区域毛利 x 3%
  104. 街道分润 = 区域毛利 x 5%
  105. */
  106. public function area_api()
  107. {
  108. # 获取所有代理商
  109. $where['status'] = 2;
  110. $member = Dever::db('agent/member')->select($where);
  111. if ($member) {
  112. foreach ($member as $k => $v) {
  113. # 获取区域内门店的利润
  114. $role = Dever::db('setting/role')->find($v['role']);
  115. $profit = $role['profit'];
  116. if (!$profit) {
  117. continue;
  118. }
  119. $temp = explode(',', $v['area']);
  120. if ($role['type'] == 2) {
  121. $area = '';
  122. if ($role['area'] == 1 && isset($temp[1])) {
  123. # 城市
  124. $area = $temp[0] . ',' . $temp[1];
  125. } elseif ($role['area'] == 2 && isset($temp[2])) {
  126. # 区县
  127. $area = $temp[0] . ',' . $temp[1] . ',' . $temp[2];
  128. } elseif ($role['area'] == 3 && isset($temp[3])) {
  129. # 街道
  130. $area = $temp[0] . ',' . $temp[1] . ',' . $temp[2] . ',' . $temp[3];
  131. }
  132. if ($area) {
  133. }
  134. }
  135. }
  136. }
  137. }
  138. # 营业额报表:日期,订单数,确认订单数,确认订单额度,新增代理商数量
  139. public function order_api()
  140. {
  141. $num = Dever::input('num', 5);
  142. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  143. $end = Dever::input('end', date('Y-m-d'));
  144. $start = Dever::maketime($start . ' 00:00:00');
  145. $end = Dever::maketime($end . ' 23:59:59');
  146. $day = intval(($end - $start)/86400);
  147. for($i=0; $i<=$day; $i++) {
  148. $where = array();
  149. $where['fstart'] = $start + 86400*$i;
  150. $where['fend'] = $start + 86400*$i + 86399;
  151. $data = array();
  152. $data['day'] = $where['fstart'];
  153. $info = Dever::db('bill/order_stat')->find($data);
  154. $data['num'] = Dever::db('agent/order')->getNum($where);
  155. $where['status'] = 4;
  156. $data['yes_num'] = Dever::db('agent/order')->getNum($where);
  157. $cash = Dever::db('agent/order')->getCash($where);
  158. if ($cash) {
  159. $data['cash'] = $cash['total'];
  160. } else {
  161. $data['cash'] = 0;
  162. }
  163. $where['status'] = 2;
  164. $data['daili_num'] = Dever::db('agent/member')->getNum($where);
  165. $where['status'] = '-2,1,2,3,6';//驳回不加入
  166. $where['start'] = $where['fstart'];
  167. $where['end'] = $where['fend'];
  168. unset($where['fstart']);
  169. unset($where['fend']);
  170. $data['no_num'] = Dever::db('agent/order')->getNum($where);
  171. $no_cash = Dever::db('agent/order')->getCash($where);
  172. if ($no_cash) {
  173. $data['no_cash'] = $no_cash['total'];
  174. } else {
  175. $data['no_cash'] = 0;
  176. }
  177. if (!$info) {
  178. Dever::db('bill/order_stat')->insert($data);
  179. } else {
  180. $data['where_id'] = $info['id'];
  181. Dever::db('bill/order_stat')->update($data);
  182. }
  183. }
  184. }
  185. # 代理商统计:日期,新增代理商,城市代理商,区县代理商,街道代理商,创客,消客
  186. public function member_api()
  187. {
  188. $num = Dever::input('num', 5);
  189. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  190. $end = Dever::input('end', date('Y-m-d'));
  191. $start = Dever::maketime($start . ' 00:00:00');
  192. $end = Dever::maketime($end . ' 23:59:59');
  193. $day = intval(($end - $start)/86400);
  194. for($i=0; $i<=$day; $i++) {
  195. $where = array();
  196. $where['status'] = 2;
  197. $where['fstart'] = $start + 86400*$i;
  198. $where['fend'] = $start + 86400*$i + 86399;
  199. $data = array();
  200. $data['day'] = $where['fstart'];
  201. $info = Dever::db('bill/member_stat')->find($data);
  202. $data['num'] = Dever::db('agent/member')->getNum($where);
  203. $where['role'] = 2;
  204. $data['city_num'] = Dever::db('agent/member')->getNum($where);
  205. $where['role'] = 3;
  206. $data['county_num'] = Dever::db('agent/member')->getNum($where);
  207. $where['role'] = 4;
  208. $data['town_num'] = Dever::db('agent/member')->getNum($where);
  209. $where['role'] = 5;
  210. $data['cf_num'] = Dever::db('agent/member')->getNum($where);
  211. $where['role'] = 6;
  212. $data['ck_num'] = Dever::db('agent/member')->getNum($where);
  213. if (!$info) {
  214. Dever::db('bill/member_stat')->insert($data);
  215. } else {
  216. $data['where_id'] = $info['id'];
  217. Dever::db('bill/member_stat')->update($data);
  218. }
  219. }
  220. }
  221. # 资金账户统计:日期,总收入,代理费,软件服务费,赠送商品价值,直推佣金,市场培训费
  222. # 总收入金额 = 代理费金额 + 软件服务费 - 赠送商品价值 - 直推分佣 - 市场培训费 - 活动分佣 - 手动发放
  223. public function cash_in_api()
  224. {
  225. $num = Dever::input('num', 5);
  226. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  227. $end = Dever::input('end', date('Y-m-d'));
  228. $start = Dever::maketime($start . ' 00:00:00');
  229. $end = Dever::maketime($end . ' 23:59:59');
  230. $day = intval(($end - $start)/86400);
  231. for($i=0; $i<=$day; $i++) {
  232. $where = array();
  233. $where['start'] = $start + 86400*$i;
  234. $where['end'] = $start + 86400*$i + 86399;
  235. $data = array();
  236. $data['day'] = $where['start'];
  237. $info = Dever::db('bill/cash_in_stat')->find($data);
  238. $where['status'] = 4;
  239. $data['daili_cash'] = 0;
  240. $cash = Dever::db('agent/order')->getDailiCash($where);
  241. if ($cash) {
  242. $data['daili_cash'] = $cash['total'];
  243. }
  244. $data['soft_cash'] = 0;
  245. $cash = Dever::db('agent/order')->getSoftCash($where);
  246. if ($cash) {
  247. $data['soft_cash'] = $cash['total'];
  248. }
  249. $data['goods_cash'] = 0;
  250. $cash = Dever::db('agent/order')->getGoodsCash($where);
  251. if ($cash) {
  252. $data['goods_cash'] = $cash['total'];
  253. }
  254. unset($where['status']);
  255. $where['type'] = 1;
  256. $data['zt_cash'] = 0;
  257. $cash = Dever::db('bill/cash')->getCash($where);
  258. if ($cash) {
  259. $data['zt_cash'] = $cash['total'];
  260. }
  261. $where['type'] = 2;
  262. $data['sc_cash'] = 0;
  263. $cash = Dever::db('bill/cash')->getCash($where);
  264. if ($cash) {
  265. $data['sc_cash'] = $cash['total'];
  266. }
  267. $where['type'] = 4;
  268. $data['hd_cash'] = 0;
  269. $cash = Dever::db('bill/cash')->getCash($where);
  270. if ($cash) {
  271. $data['hd_cash'] = $cash['total'];
  272. }
  273. $where['type'] = 10;
  274. $data['sd_cash'] = 0;
  275. $cash = Dever::db('bill/cash')->getCash($where);
  276. if ($cash) {
  277. $data['sd_cash'] = $cash['total'];
  278. }
  279. $data['cash'] = $data['daili_cash'] + $data['soft_cash'] - $data['goods_cash'] - $data['sc_cash'] - $data['zt_cash'] - $data['hd_cash'] - $data['sd_cash'];
  280. if (!$info) {
  281. Dever::db('bill/cash_in_stat')->insert($data);
  282. } else {
  283. $data['where_id'] = $info['id'];
  284. Dever::db('bill/cash_in_stat')->update($data);
  285. }
  286. }
  287. }
  288. # 应付金额 = 现存余额 + 未审核提现 + 已审核待发放提现。
  289. /*public function cash_out_api()
  290. {
  291. $num = Dever::input('num', 1);
  292. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  293. $end = Dever::input('end', date('Y-m-d'));
  294. $start = Dever::maketime($start . ' 00:00:00');
  295. $end = Dever::maketime($end . ' 23:59:59');
  296. $day = intval(($end - $start)/86400);
  297. for($i=0; $i<=$day; $i++) {
  298. $where = array();
  299. $where['start'] = $start + 86400*$i;
  300. $where['end'] = $start + 86400*$i + 86399;
  301. $data = array();
  302. $data['day'] = $where['start'];
  303. $info = Dever::db('bill/cash_in_stat')->find($data);
  304. $where['status'] = 4;
  305. $data['daili_cash'] = 0;
  306. $cash = Dever::db('agent/order')->getDailiCash($where);
  307. if ($cash) {
  308. $data['daili_cash'] = $cash['total'];
  309. }
  310. $data['soft_cash'] = 0;
  311. $cash = Dever::db('agent/order')->getSoftCash($where);
  312. if ($cash) {
  313. $data['soft_cash'] = $cash['total'];
  314. }
  315. $data['goods_cash'] = 0;
  316. $cash = Dever::db('agent/order')->getGoodsCash($where);
  317. if ($cash) {
  318. $data['goods_cash'] = $cash['total'];
  319. }
  320. unset($where['status']);
  321. $where['type'] = 1;
  322. $data['zt_cash'] = 0;
  323. $cash = Dever::db('bill/cash')->getCash($where);
  324. if ($cash) {
  325. $data['zt_cash'] = $cash['total'];
  326. }
  327. $where['type'] = 2;
  328. $data['sc_cash'] = 0;
  329. $cash = Dever::db('bill/cash')->getCash($where);
  330. if ($cash) {
  331. $data['sc_cash'] = $cash['total'];
  332. }
  333. $data['cash'] = $data['daili_cash'] + $data['soft_cash'] - $data['goods_cash'] - $data['sc_cash'] - $data['zt_cash'];
  334. if (!$info) {
  335. Dever::db('bill/cash_in_stat')->insert($data);
  336. } else {
  337. $data['where_id'] = $info['id'];
  338. Dever::db('bill/cash_in_stat')->update($data);
  339. }
  340. }
  341. }
  342. */
  343. #财务应付报表:
  344. #应付金额 = 现存余额 + 未审核提现 + 已审核待发放提现
  345. public function cash_up_api()
  346. {
  347. $num = Dever::input('num', 5);
  348. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  349. $end = Dever::input('end', date('Y-m-d'));
  350. $start = Dever::maketime($start . ' 00:00:00');
  351. $end = Dever::maketime($end . ' 23:59:59');
  352. $day = intval(($end - $start)/86400);
  353. for($i=0; $i<=$day; $i++) {
  354. $where = array();
  355. $where['start'] = $start + 86400*$i;
  356. $where['end'] = $start + 86400*$i + 86399;
  357. $data = array();
  358. $data['day'] = $where['start'];
  359. $info = Dever::db('bill/cash_up_stat')->find($data);
  360. /*
  361. 现存余额=tixian.php下的cash
  362. 未审核提现=cash下的status=1,type=11
  363. 已审核待发放提现=tixian.php下的status=1,cash
  364. */
  365. #现存余额
  366. $data['xc_cash']=0;
  367. $where['status'] = 2;
  368. $cash=Dever::db('bill/tixian')->gettxCash($where);
  369. if($cash){
  370. $data['xc_cash']=$cash['total']*(-1);
  371. }
  372. #未审核提现
  373. $where['status']=-1;
  374. $data['ws_cash']=0;
  375. // print_R($where);die;
  376. $tixian=Dever::db('bill/tixian')->getwsCash($where);
  377. if($tixian){
  378. // $where['status']=1;
  379. // $where['type']=11;
  380. // $where['mid']=$tixian['mid'];
  381. // $cash=Dever::db('bill/cash')->getwsCash($where);
  382. $data['ws_cash']=$tixian['total']*(-1);
  383. }
  384. #已审核待发放提现
  385. $data['df_cash']=0;
  386. $where['status']=1;
  387. $cash=Dever::db('bill/tixian')->getdfCash($where);
  388. if($cash){
  389. $data['df_cash'] = $cash['total'] *(-1);
  390. }
  391. $data['cash'] = $data['xc_cash'] + $data['ws_cash'] + $data['df_cash'];
  392. if (!$info) {
  393. Dever::db('bill/cash_up_stat')->insert($data);
  394. } else {
  395. $data['where_id'] = $info['id'];
  396. Dever::db('bill/cash_up_stat')->update($data);
  397. }
  398. }
  399. }
  400. #归店统计
  401. public function shop_stat_api(){
  402. $month = Dever::input('month', date('Y-m'));
  403. $month = date('Y-m',$month);
  404. $start_time = $month .'-01 00:00:00';
  405. $end_time = date('Y-m-d', strtotime($start_time. ' +1 month -1 day')).' 23:59:59';
  406. $start = Dever::maketime($start_time);
  407. $end = Dever::maketime($end_time);
  408. $shop = Dever::db('shop/info')->getAll();
  409. foreach($shop as $k => $v){
  410. #代理商总数量
  411. $shop[$k]['num'] = Dever::db('agent/member_shop_log')->getAll(array('start'=>$start,'end'=>$end,'new_shop_id'=>$v['id'],'state'=>1));
  412. $log = Dever::db('agent/member_shop_log')->getGui(array('start'=>$start,'end'=>$end,'new_shop_id'=>$v['id'],'state'=>1));
  413. foreach($log as $k1 => $v1){
  414. if($v['id'] == $v1['new_shop_id']){
  415. #创V数量
  416. $v_num[] = Dever::db('agent/member')->getCount(array('id'=>$v1['mid'],'role'=>8,'state'=>1));
  417. #创V名额外数量
  418. $out_num[] = Dever::db('agent/member')->getCount(array('id'=>$v1['id'],'role'=>8,'prize_type'=>1,'state'=>1));
  419. #代理商业绩
  420. $shop[$k]['money'][] = Dever::db('agent/order')->getCount(array('start'=>$start,'end'=>$end,'mid'=>$v1['mid'],'state'=>1));
  421. #创V业绩
  422. $shop[$k]['v_money'][] = Dever::db('agent/order')->getVCount(array('start'=>$start,'end'=>$end,'mid'=>$v1['mid'],'role'=>8,'state'=>1));
  423. #创V名额外业绩
  424. $out[] = Dever::db('agent/member')->find(array('id'=>$v1['mid'],'role'=>8,'prize_type'=>1,'state'=>1));
  425. }
  426. }
  427. foreach($out as $a => $b){
  428. if(isset($b['id']) && $b['id']){
  429. $shop[$k]['out_money'][] = Dever::db('agent/order')->getVCount(array('start'=>$start,'end'=>$end,'mid'=>$b['id'],'role'=>8,'state'=>1));
  430. }
  431. }
  432. #创V总数量
  433. if(isset($v_num) && $v_num){
  434. $shop[$k]['v_num'] = array_sum($v_num);
  435. }else{
  436. $shop[$k]['v_num'] = 0;
  437. }
  438. #创V名额内外的数量
  439. if(isset($out_num) && $out_num){
  440. $shop[$k]['out_num'] = array_sum($out_num);
  441. $shop[$k]['nei_num'] = $shop[$k]['v_num'] - $shop[$k]['out_num'];
  442. }else{
  443. $shop[$k]['out_num'] = 0;
  444. $shop[$k]['nei_num'] = 0;
  445. }
  446. #除去创V的代理商总数量
  447. $shop[$k]['dl_num'] = $shop[$k]['num'] - $shop[$k]['v_num'];
  448. }
  449. foreach($shop as $key => $val){
  450. #代理商的总业绩
  451. if(isset($val['money']) && $val['money']){
  452. $shop[$key]['money'] = array_sum(array_map(function($val){return $val['total'];}, $val['money']));
  453. }else{
  454. $shop[$key]['money'] = 0;
  455. }
  456. #创V总业绩
  457. if(isset($val['v_money']) && $val['v_money']){
  458. $shop[$key]['v_money'] = array_sum(array_map(function($val){return $val['total'];}, $val['v_money']));
  459. }else{
  460. $shop[$key]['v_money'] = 0;
  461. }
  462. if(isset($val['out_money']) && $val['out_money']){
  463. $shop[$key]['out_money'] = array_sum(array_map(function($val){return $val['total'];}, $val['out_money']));
  464. $shop[$key]['nei_money'] = $shop[$key]['v_money'] - $shop[$key]['out_money'];
  465. }else{
  466. $shop[$key]['out_money'] = 0;
  467. $shop[$key]['nei_money'] = 0;
  468. }
  469. $shop[$key]['dl_money'] = $shop[$key]['money']-$shop[$key]['v_money'];
  470. $insert['shop_id'] = $val['id'];
  471. $insert['num'] = $val['num'];
  472. $insert['dl_num'] = $val['dl_num'];
  473. $insert['v_num'] = $val['v_num'];
  474. $insert['money'] = $shop[$key]['money'];
  475. $insert['dl_money'] = $shop[$key]['dl_money'];
  476. $insert['v_money'] = $shop[$key]['v_money'];
  477. $insert['month'] = $start;
  478. $insert['out_num'] = $val['out_num'];
  479. $insert['nei_num'] = $val['nei_num'];
  480. $insert['out_money'] = $shop[$key]['out_money'];
  481. $insert['nei_money'] = $shop[$key]['nei_money'];
  482. $res = Dever::db('bill/shop_stat')->find(array('month'=>$start));
  483. if($res){
  484. $insert['where_id'] = $res['id'];
  485. Dever::db('bill/shop_stat')->update($insert);
  486. }else{
  487. Dever::db('bill/shop_stat')->insert($insert);
  488. }
  489. }
  490. return 'ok';
  491. }
  492. }