Cron.php 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430
  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. $info = Dever::db('bill/sell_stat')->find($w);
  37. $w['new_num'] = $v['num'];
  38. $where['mid'] = $v['mid'];
  39. $total = Dever::db('bill/sell')->getNumByTimeOne($where);
  40. if ($total) {
  41. $w['num'] = $total['num'];
  42. }
  43. if ($info) {
  44. $w['where_id'] = $info['id'];
  45. Dever::db('bill/sell_stat')->update($w);
  46. } else {
  47. Dever::db('bill/sell_stat')->insert($w);
  48. }
  49. }
  50. }
  51. }
  52. return 'ok';
  53. }
  54. # 权益使用情况统计:类型、商品名、总发放数量、总使用数量
  55. public function goods_api()
  56. {
  57. $num = Dever::input('num', 1);
  58. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  59. $end = Dever::input('end', date('Y-m-d'));
  60. $start = Dever::maketime($start . ' 00:00:00');
  61. $end = Dever::maketime($end . ' 23:59:59');
  62. $day = intval(($end - $start)/86400);
  63. for($i=0; $i<=$day; $i++) {
  64. $where['start'] = $start + 86400*$i;
  65. $where['end'] = $start + 86400*$i + 86399;
  66. $goods = Dever::db('agent/member_goods')->findAll($where);
  67. if ($goods) {
  68. foreach ($goods as $k => $v) {
  69. $data = array();
  70. $data['day'] = $where['start'];
  71. $data['type'] = $v['type'];
  72. $data['type_id'] = $v['type_id'];
  73. $data['sku_id'] = $v['sku_id'];
  74. $info = Dever::db('bill/goods_stat')->find($data);
  75. $data['total_num'] = $v['total_num'];
  76. $data['sell_num'] = $v['sell_num'];
  77. $data['cash'] = $v['cash'];
  78. $data['price'] = $v['price'];
  79. $data['name'] = $v['name'];
  80. if ($info) {
  81. $data['where_id'] = $info['id'];
  82. Dever::db('bill/goods_stat')->update($data);
  83. } else {
  84. Dever::db('bill/goods_stat')->insert($data);
  85. }
  86. }
  87. }
  88. }
  89. }
  90. # 区域分润
  91. /*
  92. 区域毛利 = 区域内所有门店的采购商品的零售价总额 x 30%
  93. 城市分润 = 区域毛利 x 1%
  94. 区县分润 = 区域毛利 x 3%
  95. 街道分润 = 区域毛利 x 5%
  96. */
  97. public function area_api()
  98. {
  99. # 获取所有代理商
  100. $where['status'] = 2;
  101. $member = Dever::db('agent/member')->select($where);
  102. if ($member) {
  103. foreach ($member as $k => $v) {
  104. # 获取区域内门店的利润
  105. $role = Dever::db('setting/role')->find($v['role']);
  106. $profit = $role['profit'];
  107. if (!$profit) {
  108. continue;
  109. }
  110. $temp = explode(',', $v['area']);
  111. if ($role['type'] == 2) {
  112. $area = '';
  113. if ($role['area'] == 1 && isset($temp[1])) {
  114. # 城市
  115. $area = $temp[0] . ',' . $temp[1];
  116. } elseif ($role['area'] == 2 && isset($temp[2])) {
  117. # 区县
  118. $area = $temp[0] . ',' . $temp[1] . ',' . $temp[2];
  119. } elseif ($role['area'] == 3 && isset($temp[3])) {
  120. # 街道
  121. $area = $temp[0] . ',' . $temp[1] . ',' . $temp[2] . ',' . $temp[3];
  122. }
  123. if ($area) {
  124. }
  125. }
  126. }
  127. }
  128. }
  129. # 营业额报表:日期,订单数,确认订单数,确认订单额度,新增代理商数量
  130. public function order_api()
  131. {
  132. $num = Dever::input('num', 1);
  133. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  134. $end = Dever::input('end', date('Y-m-d'));
  135. $start = Dever::maketime($start . ' 00:00:00');
  136. $end = Dever::maketime($end . ' 23:59:59');
  137. $day = intval(($end - $start)/86400);
  138. for($i=0; $i<=$day; $i++) {
  139. $where = array();
  140. $where['start'] = $start + 86400*$i;
  141. $where['end'] = $start + 86400*$i + 86399;
  142. $data = array();
  143. $data['day'] = $where['start'];
  144. $info = Dever::db('bill/order_stat')->find($data);
  145. $data['num'] = Dever::db('agent/order')->getNum($where);
  146. $where['status'] = 4;
  147. $data['yes_num'] = Dever::db('agent/order')->getNum($where);
  148. $cash = Dever::db('agent/order')->getCash($where);
  149. if ($cash) {
  150. $data['cash'] = $cash['total'];
  151. } else {
  152. $data['cash'] = 0;
  153. }
  154. $where['status'] = 2;
  155. $data['daili_num'] = Dever::db('agent/member')->getNum($where);
  156. if (!$info) {
  157. Dever::db('bill/order_stat')->insert($data);
  158. } else {
  159. $data['where_id'] = $info['id'];
  160. Dever::db('bill/order_stat')->update($data);
  161. }
  162. }
  163. }
  164. # 代理商统计:日期,新增代理商,城市代理商,区县代理商,街道代理商,创客,消客
  165. public function member_api()
  166. {
  167. $num = Dever::input('num', 1);
  168. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  169. $end = Dever::input('end', date('Y-m-d'));
  170. $start = Dever::maketime($start . ' 00:00:00');
  171. $end = Dever::maketime($end . ' 23:59:59');
  172. $day = intval(($end - $start)/86400);
  173. for($i=0; $i<=$day; $i++) {
  174. $where = array();
  175. $where['status'] = 2;
  176. $where['start'] = $start + 86400*$i;
  177. $where['end'] = $start + 86400*$i + 86399;
  178. $data = array();
  179. $data['day'] = $where['start'];
  180. $info = Dever::db('bill/member_stat')->find($data);
  181. $data['num'] = Dever::db('agent/member')->getNum($where);
  182. $where['role'] = 2;
  183. $data['city_num'] = Dever::db('agent/member')->getNum($where);
  184. $where['role'] = 3;
  185. $data['county_num'] = Dever::db('agent/member')->getNum($where);
  186. $where['role'] = 4;
  187. $data['town_num'] = Dever::db('agent/member')->getNum($where);
  188. $where['role'] = 6;
  189. $data['ck_num'] = Dever::db('agent/member')->getNum($where);
  190. $where['role'] = 7;
  191. $data['xk_num'] = Dever::db('agent/member')->getNum($where);
  192. if (!$info) {
  193. Dever::db('bill/member_stat')->insert($data);
  194. } else {
  195. $data['where_id'] = $info['id'];
  196. Dever::db('bill/member_stat')->update($data);
  197. }
  198. }
  199. }
  200. # 资金账户统计:日期,总收入,代理费,软件服务费,赠送商品价值,直推佣金,市场培训费
  201. # 总收入金额 = 代理费金额 + 软件服务费 - 赠送商品价值 - 直推分佣 - 市场培训费 - 活动分佣 - 手动发放
  202. public function cash_in_api()
  203. {
  204. $num = Dever::input('num', 1);
  205. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  206. $end = Dever::input('end', date('Y-m-d'));
  207. $start = Dever::maketime($start . ' 00:00:00');
  208. $end = Dever::maketime($end . ' 23:59:59');
  209. $day = intval(($end - $start)/86400);
  210. for($i=0; $i<=$day; $i++) {
  211. $where = array();
  212. $where['start'] = $start + 86400*$i;
  213. $where['end'] = $start + 86400*$i + 86399;
  214. $data = array();
  215. $data['day'] = $where['start'];
  216. $info = Dever::db('bill/cash_in_stat')->find($data);
  217. $where['status'] = 4;
  218. $data['daili_cash'] = 0;
  219. $cash = Dever::db('agent/order')->getDailiCash($where);
  220. if ($cash) {
  221. $data['daili_cash'] = $cash['total'];
  222. }
  223. $data['soft_cash'] = 0;
  224. $cash = Dever::db('agent/order')->getSoftCash($where);
  225. if ($cash) {
  226. $data['soft_cash'] = $cash['total'];
  227. }
  228. $data['goods_cash'] = 0;
  229. $cash = Dever::db('agent/order')->getGoodsCash($where);
  230. if ($cash) {
  231. $data['goods_cash'] = $cash['total'];
  232. }
  233. unset($where['status']);
  234. $where['type'] = 1;
  235. $data['zt_cash'] = 0;
  236. $cash = Dever::db('bill/cash')->getCash($where);
  237. if ($cash) {
  238. $data['zt_cash'] = $cash['total'];
  239. }
  240. $where['type'] = 2;
  241. $data['sc_cash'] = 0;
  242. $cash = Dever::db('bill/cash')->getCash($where);
  243. if ($cash) {
  244. $data['sc_cash'] = $cash['total'];
  245. }
  246. $where['type'] = 4;
  247. $data['hd_cash'] = 0;
  248. $cash = Dever::db('bill/cash')->getCash($where);
  249. if ($cash) {
  250. $data['hd_cash'] = $cash['total'];
  251. }
  252. $where['type'] = 10;
  253. $data['sd_cash'] = 0;
  254. $cash = Dever::db('bill/cash')->getCash($where);
  255. if ($cash) {
  256. $data['sd_cash'] = $cash['total'];
  257. }
  258. $data['cash'] = $data['daili_cash'] + $data['soft_cash'] - $data['goods_cash'] - $data['sc_cash'] - $data['zt_cash'] - $data['hd_cash'] - $data['sd_cash'];
  259. if (!$info) {
  260. Dever::db('bill/cash_in_stat')->insert($data);
  261. } else {
  262. $data['where_id'] = $info['id'];
  263. Dever::db('bill/cash_in_stat')->update($data);
  264. }
  265. }
  266. }
  267. # 应付金额 = 现存余额 + 未审核提现 + 已审核待发放提现。
  268. public function cash_out_api()
  269. {
  270. $num = Dever::input('num', 1);
  271. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  272. $end = Dever::input('end', date('Y-m-d'));
  273. $start = Dever::maketime($start . ' 00:00:00');
  274. $end = Dever::maketime($end . ' 23:59:59');
  275. $day = intval(($end - $start)/86400);
  276. for($i=0; $i<=$day; $i++) {
  277. $where = array();
  278. $where['start'] = $start + 86400*$i;
  279. $where['end'] = $start + 86400*$i + 86399;
  280. $data = array();
  281. $data['day'] = $where['start'];
  282. $info = Dever::db('bill/cash_in_stat')->find($data);
  283. $where['status'] = 4;
  284. $data['daili_cash'] = 0;
  285. $cash = Dever::db('agent/order')->getDailiCash($where);
  286. if ($cash) {
  287. $data['daili_cash'] = $cash['total'];
  288. }
  289. $data['soft_cash'] = 0;
  290. $cash = Dever::db('agent/order')->getSoftCash($where);
  291. if ($cash) {
  292. $data['soft_cash'] = $cash['total'];
  293. }
  294. $data['goods_cash'] = 0;
  295. $cash = Dever::db('agent/order')->getGoodsCash($where);
  296. if ($cash) {
  297. $data['goods_cash'] = $cash['total'];
  298. }
  299. unset($where['status']);
  300. $where['type'] = 1;
  301. $data['zt_cash'] = 0;
  302. $cash = Dever::db('bill/cash')->getCash($where);
  303. if ($cash) {
  304. $data['zt_cash'] = $cash['total'];
  305. }
  306. $where['type'] = 2;
  307. $data['sc_cash'] = 0;
  308. $cash = Dever::db('bill/cash')->getCash($where);
  309. if ($cash) {
  310. $data['sc_cash'] = $cash['total'];
  311. }
  312. $data['cash'] = $data['daili_cash'] + $data['soft_cash'] - $data['goods_cash'] - $data['sc_cash'] - $data['zt_cash'];
  313. if (!$info) {
  314. Dever::db('bill/cash_in_stat')->insert($data);
  315. } else {
  316. $data['where_id'] = $info['id'];
  317. Dever::db('bill/cash_in_stat')->update($data);
  318. }
  319. }
  320. }
  321. #财务应付报表:
  322. #应付金额 = 现存余额 + 未审核提现 + 已审核待发放提现
  323. public function cash_up_api()
  324. {
  325. $num = Dever::input('num', 1);
  326. $start = Dever::input('start', date('Y-m-d', strtotime('-'.$num.' day')));
  327. $end = Dever::input('end', date('Y-m-d'));
  328. $start = Dever::maketime($start . ' 00:00:00');
  329. $end = Dever::maketime($end . ' 23:59:59');
  330. $day = intval(($end - $start)/86400);
  331. for($i=0; $i<=$day; $i++) {
  332. $where = array();
  333. $where['start'] = $start + 86400*$i;
  334. $where['end'] = $start + 86400*$i + 86399;
  335. $data = array();
  336. $data['day'] = $where['start'];
  337. $info = Dever::db('bill/cash_up_stat')->find($data);
  338. /*
  339. 现存余额=tixian.php下的cash
  340. 未审核提现=cash下的status=1,type=11
  341. 已审核待发放提现=tixian.php下的status=1,cash
  342. */
  343. #现存余额
  344. $data['xc_cash']=0;
  345. $cash=Dever::db('bill/tixian')->gettxCash($where);
  346. if($cash){
  347. $data['xc_cash']=$cash['total'];
  348. }
  349. #未审核提现
  350. $where['bill-cash-status']=1;
  351. $data['ws_cash']=0;
  352. $tixian=Dever::db('bill/tixian')->getwsCash($where);
  353. if($tixian){
  354. $where['status']=1;
  355. $where['type']=11;
  356. $where['mid']=$tixian['mid'];
  357. $cash=Dever::db('bill/cash')->getwsCash($where);
  358. $data['ws_cash']=$cash['total'];
  359. }
  360. #已审核待发放提现
  361. $data['df_cash']=0;
  362. $where['status']=1;
  363. $cash=Dever::db('bill/tixian')->getdfCash($where);
  364. $data['cash'] = $data['xc_cash'] + $data['ws_cash'] + $data['df_cash'];
  365. if (!$info) {
  366. Dever::db('bill/cash_up_stat')->insert($data);
  367. } else {
  368. $data['where_id'] = $info['id'];
  369. Dever::db('bill/cash_up_stat')->update($data);
  370. }
  371. }
  372. }
  373. }