CalcConsole.php 3.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. <?php
  2. namespace common\helpers\bonus\Calc;
  3. use common\models\CalcRecord;
  4. use common\models\Period;
  5. class CalcConsole extends BaseBusiness
  6. {
  7. const CALC_DB_NAME = 'dbCalc';
  8. public static function listenCalcPeriod()
  9. {
  10. $db = self::CALC_DB_NAME;
  11. $allPeriod = \Yii::$app->$db->createCommand("SELECT * FROM AR_PERIOD ")->queryAll();
  12. $period = [];
  13. foreach ($allPeriod as $v) {
  14. if ($v['IS_PREPARE'] > 0
  15. //&& todo 补全状态
  16. ) {
  17. $period = $v;
  18. break;
  19. }
  20. }
  21. $businessPeriod = Period::find()->where(['PERIOD_NUM' => $period['PERIOD_NUM']])
  22. ->asArray()->one();
  23. //用户选择是否自动执行
  24. $autoExec = $businessPeriod['AUTO_EXEC'] > 0;
  25. if (2 == $period['IS_PREPARE'] && 1 == $period['IS_PERFED'] && $autoExec) {
  26. //拉取期业绩
  27. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的业绩数据已生成');
  28. CalcRecord::record($period['PERIOD_NUM'], '开始获取第' . $period['PERIOD_NUM'] . '期的期业绩数据');
  29. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::IS_PROCESSING);
  30. $res = (new PullPerfDataFromCalc($period['PERIOD_NUM']))->start();
  31. if (200 == $res['code']) {
  32. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  33. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的期业绩数据已获取');
  34. } else {
  35. //结束计算状态
  36. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  37. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的期业绩数据获取失败,原因:' . $res['msg']);
  38. return $res;
  39. }
  40. //自动执行且IS_PREPARE为3 直接开始结算流程
  41. CalcRecord::record($period['PERIOD_NUM'], '开始计算第' . $period['PERIOD_NUM'] . '期的奖金');
  42. //同步周期表的值到业务系统
  43. self::pullPeriodForUpdate($period['PERIOD_NUM']);
  44. return \Yii::$app->$db->createCommand()->update('AR_PERIOD', ['IS_PREPARE' => 3], 'PERIOD_NUM=:PERIOD_NUM', ['PERIOD_NUM' => $period['PERIOD_NUM']])->execute();
  45. }
  46. if (4 == $period['IS_PREPARE'] && 1 == $period['IS_CALCULATED'] && $autoExec) {
  47. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的奖金已计算完成');
  48. CalcRecord::record($period['PERIOD_NUM'], '开始拉取第' . $period['PERIOD_NUM'] . '期的奖金数据');
  49. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::IS_PROCESSING);
  50. //自动执行且IS_CALCULATED为1 直接开始拉取结算数据
  51. $res = (new PullCalcBonusData($period['PERIOD_NUM']))->start();
  52. if (200 == $res['code']) {
  53. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的奖金数据已全部拉取');
  54. //自动执行完成 更新对应字段
  55. //计算结束
  56. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  57. //流程结束
  58. //同步周期表的值到业务系统
  59. self::pullPeriodForUpdate($period['PERIOD_NUM']);
  60. } else {
  61. //结束计算状态
  62. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  63. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的奖金数据获取失败,原因:' . $res['msg']);
  64. return $res;
  65. }
  66. return true;
  67. }
  68. return true;
  69. }
  70. }