DataLogic.php 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
  1. <?php
  2. /**
  3. * DataLogic.php UTF-8
  4. * 数据产生逻辑处理
  5. *
  6. * @date : 2018/5/31 19:37
  7. *
  8. * @license 这不是一个自由软件,未经授权不许任何使用和传播。
  9. * @author : wuyonghong <wyh@huosdk.com>
  10. * @version : HUOSDK 8.0
  11. */
  12. namespace huo\logic\data;
  13. use huo\controller\agent\AgentCache;
  14. use huo\controller\data\Day;
  15. use huo\model\common\CommonModel;
  16. use huo\model\data\DayAgentModel;
  17. use huo\model\data\DayGameAgentModel;
  18. use huo\model\data\DayGameModel;
  19. use huo\model\data\DayModel;
  20. use huo\model\game\GameextModel;
  21. use huolib\constant\CommonConst;
  22. class DataLogic extends CommonModel {
  23. private $base_filed
  24. = [
  25. 'history_user_cnt',
  26. 'active_cnt',
  27. 'down_cnt',
  28. 'real_down_cnt',
  29. 'user_cnt',
  30. 'reg_cnt',
  31. 'reg_device_cnt',
  32. 'pay_user_cnt',
  33. 'first_pay_user_cnt',
  34. 'order_cnt',
  35. 'fail_order_cnt',
  36. 'un_order_cnt',
  37. 'reg_order_cnt',
  38. 'reg_pay_cnt',
  39. 'sum_money',
  40. 'first_pay_money',
  41. 'first_pay_sum_money',
  42. 'reg_sum_money',
  43. 'day2',
  44. 'day3',
  45. 'day4',
  46. 'day5',
  47. 'day6',
  48. 'day7',
  49. 'day8',
  50. 'day9',
  51. 'day10',
  52. 'day11',
  53. 'day12',
  54. 'day13',
  55. 'day14',
  56. 'day15',
  57. 'day21',
  58. 'day30',
  59. 'day60',
  60. 'device_day2',
  61. 'device_day3',
  62. 'device_day4',
  63. 'device_day5',
  64. 'device_day6',
  65. 'device_day7',
  66. 'device_day8',
  67. 'device_day9',
  68. 'device_day10',
  69. 'device_day11',
  70. 'device_day12',
  71. 'device_day13',
  72. 'device_day14',
  73. 'device_day15',
  74. 'device_day21',
  75. 'device_day30',
  76. 'device_day60'
  77. ];
  78. /**
  79. * 更新每日游戏渠道
  80. *
  81. * @param $data
  82. *
  83. * @return bool
  84. */
  85. public function upDayGameAgent($data) {
  86. $_map['date'] = $data['date'];
  87. $_map['app_id'] = $data['app_id'];
  88. $_map['agent_id'] = $data['agent_id'];
  89. $_model = new DayGameAgentModel();
  90. // try {
  91. $_rs = $this->updateData($_model, $_map, $data);
  92. if (false === $_rs) {
  93. // TODO: wuyonghong 2018/5/31 记录LOG
  94. return false;
  95. }
  96. $_rs = $this->upDayGame($data);
  97. if (false === $_rs) {
  98. // TODO: wuyonghong 2018/5/31 记录LOG
  99. return false;
  100. }
  101. $_rs = $this->upDayAgent($data);
  102. if (false === $_rs) {
  103. // TODO: wuyonghong 2018/5/31 记录LOG
  104. return false;
  105. }
  106. $_rs = $this->upDay($data);
  107. if (false === $_rs) {
  108. // TODO: wuyonghong 2018/5/31 记录LOG
  109. return false;
  110. }
  111. return true;
  112. // } catch (DataNotFoundException $e) {
  113. // // TODO: wuyonghong 2018/5/31 记录LOG
  114. // return false;
  115. // } catch (ModelNotFoundException $e) {
  116. // // TODO: wuyonghong 2018/5/31 记录LOG
  117. // return false;
  118. // } catch (DbException $e) {
  119. // // TODO: wuyonghong 2018/5/31 记录LOG
  120. // return false;
  121. // } catch (Exception $e) {
  122. // // TODO: wuyonghong 2018/5/31 记录LOG
  123. // return false;
  124. // }
  125. }
  126. /**
  127. * 更新每日游戏数据
  128. *
  129. * @param $data
  130. *
  131. * @return bool
  132. */
  133. public function upDayGame($data) {
  134. $_map['date'] = $data['date'];
  135. $_map['app_id'] = $data['app_id'];
  136. $_model = new DayGameModel();
  137. $_rs = $this->updateData($_model, $_map, $data);
  138. if (false === $_rs) {
  139. // TODO: wuyonghong 2018/5/31 记录LOG
  140. return false;
  141. }
  142. /* 更新游戏扩展信息 */
  143. $this->upGameExt($_map['app_id'], $data);
  144. return true;
  145. }
  146. /**
  147. * 更新每日渠道数据
  148. *
  149. * @param $data
  150. *
  151. * @return bool
  152. */
  153. public function upDayAgent($data) {
  154. $_map['date'] = $data['date'];
  155. $_map['agent_id'] = $data['agent_id'];
  156. $_model = new DayAgentModel();
  157. $_rs = $this->updateData($_model, $_map, $data, true);
  158. if (false === $_rs) {
  159. // TODO: wuyonghong 2018/5/31 记录LOG
  160. return false;
  161. }
  162. /* 更新渠道扩展信息 */
  163. $this->upAgentExt($_map['agent_id'], $data);
  164. return true;
  165. }
  166. /**
  167. * 更新每日数据
  168. *
  169. * @param $data
  170. *
  171. * @return bool
  172. */
  173. public function upDay($data) {
  174. $_map['date'] = $data['date'];
  175. $_model = new DayModel();
  176. $_rs = $this->updateData($_model, $_map, $data, true);
  177. if (false === $_rs) {
  178. // TODO: wuyonghong 2018/5/31 记录LOG
  179. return false;
  180. }
  181. return true;
  182. }
  183. /**
  184. * 更新数据
  185. *
  186. * @param $model
  187. * @param $map
  188. * @param $data
  189. * @param bool $rm_repeat
  190. *
  191. * @return mixed
  192. */
  193. public function updateData($model, $map, $data, $rm_repeat = false) {
  194. $_data = $data;
  195. $_rm_repeat = false;
  196. if (isset($_data['sum_login_cnt'])) {
  197. $_sum_login_cnt = $_data['sum_login_cnt'];
  198. if ($rm_repeat && $_sum_login_cnt > 1) {
  199. $_rm_repeat = true;
  200. }
  201. unset($_data['sum_login_cnt']);
  202. }
  203. $_map = $map;
  204. $_date = $data['date'];
  205. $_retain_day_arr = (new Day())->getRetainDayArr();
  206. foreach ($_retain_day_arr as $_v) {
  207. $_day = 'day'.$_v;
  208. $_device_day = 'device_day'.$_v;
  209. if ($_rm_repeat && $_data[$_day] > 0) {
  210. $_data[$_day] -= 1;
  211. }
  212. if ($_rm_repeat && $_data[$_device_day] > 0) {
  213. $_data[$_device_day] -= 1;
  214. }
  215. if (!empty($_data[$_day]) || !empty($_data[$_device_day])) {
  216. $_map['date'] = date('Y-m-d', strtotime($_date) - CommonConst::CONST_DAY_SECONDS * ($_v - 1));
  217. $_day_data[$_day] = $_data[$_day];
  218. $_day_data[$_device_day] = $_data[$_device_day];
  219. $this->updateOrInsert($model, $_map, $_day_data);
  220. }
  221. unset($_data[$_day]);
  222. unset($_data[$_device_day]);
  223. }
  224. if ($_rm_repeat && $_data['user_cnt'] > 0) {
  225. $_data['user_cnt'] -= 1;
  226. }
  227. return $this->updateOrInsert($model, $map, $_data);
  228. }
  229. /**
  230. * 更新或插入
  231. *
  232. * @param $model
  233. * @param $_map
  234. * @param $data
  235. *
  236. * @return mixed
  237. */
  238. public function updateOrInsert($model, $_map, $data) {
  239. $_data = $model->where($_map)->find();
  240. if (is_object($_data)) {
  241. $_data = $_data->toArray();
  242. }
  243. if (empty($_data)) {
  244. $_data = $_map;
  245. foreach ($this->base_filed as $_v) {
  246. if (isset($data[$_v])) {
  247. $_data[$_v] = $data[$_v];
  248. }
  249. }
  250. if (isset($data['reg_cnt_show'])) {
  251. $_data['reg_cnt_show'] = $data['reg_cnt_show'];
  252. }
  253. $_rs = $model->insert($_data);
  254. } else {
  255. foreach ($this->base_filed as $_v) {
  256. if (isset($data[$_v])) {
  257. $_data[$_v] += $data[$_v];
  258. }
  259. }
  260. if (isset($data['reg_cnt_show'])) {
  261. $_data['reg_cnt_show'] = $data['reg_cnt_show'];
  262. }
  263. $_rs = $model->where(['id' => $_data['id']])->update($_data);
  264. }
  265. return $_rs;
  266. }
  267. /**
  268. * 更新渠道扩展信息
  269. *
  270. * @param int $app_id
  271. * @param array $data
  272. *
  273. * @return bool
  274. */
  275. public function upGameExt($app_id, $data) {
  276. if (empty($app_id)) {
  277. /* 不需要更新 */
  278. return true;
  279. }
  280. $_gc_class = new GameextModel();
  281. $_ge_data = $_gc_class->getDetail($app_id);
  282. if (empty($_ge_data)) {
  283. /* 游戏不存在 */
  284. return true;
  285. }
  286. $_ge_data['active_cnt'] += $data['active_cnt'];
  287. $_ge_data['down_cnt'] += $data['down_cnt'];
  288. $_ge_data['real_down_cnt'] += $data['real_down_cnt'];
  289. $_ge_data['user_cnt'] += $data['user_cnt'];
  290. $_ge_data['reg_cnt'] += $data['reg_cnt'];
  291. $_ge_data['reg_device_cnt'] += $data['reg_device_cnt'];
  292. $_ge_data['pay_user_cnt'] += $data['pay_user_cnt'];
  293. $_ge_data['first_pay_user_cnt'] += $data['first_pay_user_cnt'];
  294. $_ge_data['order_cnt'] += $data['order_cnt'];
  295. $_ge_data['fail_order_cnt'] += $data['fail_order_cnt'];
  296. $_ge_data['un_order_cnt'] += $data['un_order_cnt'];
  297. $_ge_data['reg_order_cnt'] += $data['reg_order_cnt'];
  298. $_ge_data['reg_pay_cnt'] += $data['reg_pay_cnt'];
  299. $_ge_data['sum_money'] += $data['sum_money'];
  300. $_ge_data['first_pay_money'] += $data['first_pay_money'];
  301. $_ge_data['first_pay_sum_money'] += $data['first_pay_sum_money'];
  302. $_ge_data['reg_sum_money'] += $data['reg_sum_money'];
  303. return $_gc_class->updateData($_ge_data, $app_id);
  304. }
  305. /**
  306. * 更新渠道扩展信息
  307. *
  308. * @param int $agent_id
  309. * @param array $data
  310. *
  311. * @return bool
  312. */
  313. public function upAgentExt($agent_id = 0, $data) {
  314. if (empty($agent_id)) {
  315. /* 不需要更新 */
  316. return true;
  317. }
  318. $_ac_class = AgentCache::ins();
  319. $_ae_data = $_ac_class->getAgentExtByAgentId($agent_id);
  320. if (empty($_ae_data)) {
  321. /* 渠道不存在 */
  322. return true;
  323. }
  324. $_ae_data['history_user_cnt'] += $data['history_user_cnt'];
  325. $_ae_data['active_cnt'] += $data['active_cnt'];
  326. $_ae_data['down_cnt'] += $data['down_cnt'];
  327. $_ae_data['real_down_cnt'] += $data['real_down_cnt'];
  328. $_ae_data['user_cnt'] += $data['user_cnt'];
  329. $_ae_data['reg_cnt'] += $data['reg_cnt'];
  330. $_ae_data['reg_device_cnt'] += $data['reg_device_cnt'];
  331. $_ae_data['pay_user_cnt'] += $data['pay_user_cnt'];
  332. $_ae_data['first_pay_user_cnt'] += $data['first_pay_user_cnt'];
  333. $_ae_data['order_cnt'] += $data['order_cnt'];
  334. $_ae_data['fail_order_cnt'] += $data['fail_order_cnt'];
  335. $_ae_data['un_order_cnt'] += $data['un_order_cnt'];
  336. $_ae_data['reg_order_cnt'] += $data['reg_order_cnt'];
  337. $_ae_data['reg_pay_cnt'] += $data['reg_pay_cnt'];
  338. $_ae_data['sum_money'] += $data['sum_money'];
  339. $_ae_data['first_pay_money'] += $data['first_pay_money'];
  340. $_ae_data['first_pay_sum_money'] += $data['first_pay_sum_money'];
  341. $_ae_data['reg_sum_money'] += $data['reg_sum_money'];
  342. return $_ac_class->updateAgentExt($agent_id, $_ae_data);
  343. }
  344. }