CalcConsole.php 4.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  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. $businessIsCalculated = $businessPeriod['IS_CALCULATED'] > 0;
  26. if (2 == $period['IS_PREPARE'] && 1 == $period['IS_PERFED'] && $autoExec) {
  27. //拉取期业绩
  28. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的业绩数据已生成');
  29. CalcRecord::record($period['PERIOD_NUM'], '开始获取第' . $period['PERIOD_NUM'] . '期的期业绩数据');
  30. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::IS_PROCESSING);
  31. $res = (new PullPerfDataFromCalc($period['PERIOD_NUM']))->start();
  32. if (200 == $res['code']) {
  33. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  34. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的期业绩数据已获取');
  35. } else {
  36. //结束计算状态
  37. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  38. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的期业绩数据获取失败,原因:' . $res['msg']);
  39. return $res;
  40. }
  41. //自动执行且IS_PREPARE为3 直接开始结算流程
  42. CalcRecord::record($period['PERIOD_NUM'], '开始计算第' . $period['PERIOD_NUM'] . '期的奖金');
  43. //同步周期表的值到业务系统
  44. self::pullPeriodForUpdate($period['PERIOD_NUM']);
  45. return \Yii::$app->$db->createCommand()->update('AR_PERIOD', ['IS_PREPARE' => 3], 'PERIOD_NUM=:PERIOD_NUM', ['PERIOD_NUM' => $period['PERIOD_NUM']])->execute();
  46. }
  47. if (4 == $period['IS_PREPARE'] && 1 == $period['IS_CALCULATED'] && $autoExec && !$businessIsCalculated) {
  48. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的奖金已计算完成');
  49. CalcRecord::record($period['PERIOD_NUM'], '开始拉取第' . $period['PERIOD_NUM'] . '期的奖金数据');
  50. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::IS_PROCESSING);
  51. //自动执行且IS_CALCULATED为1 直接开始拉取结算数据
  52. $res = (new PullCalcBonusData($period['PERIOD_NUM']))->start();
  53. if (200 == $res['code']) {
  54. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的奖金数据已全部拉取');
  55. //待拉取完成后再将计算完成标识改为已完成
  56. \Yii::$app->$db->createCommand()->update('AR_PERIOD', ['IS_CALCULATED' => 1], 'PERIOD_NUM=' . $period['PERIOD_NUM'])->execute();
  57. //自动执行完成 更新对应字段
  58. //计算结束
  59. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  60. //流程结束
  61. //同步周期表的值到业务系统
  62. self::pullPeriodForUpdate($period['PERIOD_NUM']);
  63. } else {
  64. //结束计算状态
  65. Period::updatePeriodIsProcessing($period['PERIOD_NUM'], Period::NOT_PROCESSING);
  66. CalcRecord::record($period['PERIOD_NUM'], '第' . $period['PERIOD_NUM'] . '期的奖金数据获取失败,原因:' . $res['msg']);
  67. return $res;
  68. }
  69. return true;
  70. }
  71. return true;
  72. }
  73. }