Example #1
0
 /**
  * 获取new_trans_result表里面状态为成功或者失败的记录
  * 将取出的记录原封不动的存入new_trans_history表
  * 存入成功后删除new_trans_result表里面对应的记录
  *
  */
 public function checkResultStatus()
 {
     $newTransResultModel = new NewTransResultModel();
     $newTransHistoryModel = new NewTransHistoryModel();
     $res = $newTransResultModel->getSuccAndFail();
     if ($res) {
         foreach ($res as $k => $v) {
             $newTransHistoryModel->begin();
             $v = (array) $v;
             $newTransHistoryModel->insert($v);
             $rs = $newTransHistoryModel->affectRow();
             if ($rs) {
                 $del = $newTransResultModel->delSuccAndFail($v['t_id']);
                 if ($del) {
                     $newTransHistoryModel->commit();
                     echo 't_id为' . $v['t_id'] . '的交易记录从result转存history成功' . PHP_EOL;
                 } else {
                     $newTransHistoryModel->rollback();
                     echo 't_id为' . $v['t_id'] . '的交易记录从result删除失败' . PHP_EOL;
                 }
             } else {
                 $newTransHistoryModel->rollback();
                 echo 't_id为' . $v['t_id'] . '的交易记录从result写入history失败' . PHP_EOL;
             }
         }
     }
 }