/** * 根据用户id查询账户日志总表2个id之间的数据 * * @param $userId 用户id * @param $startId 起始id(包含) * @param $endId 结束id(包含) * @return array * @throws Exception sql或者其他错误 */ public function getDifferentBalanceLog($userId, $startId, $endId) { return Model_Log_AccountBalanceLog::data_access(date('m'))->filter_by_op('userId', '=', $userId)->filter_by_op('id', '>', $startId)->filter_by_op('id', '<=', $endId)->sort('id', 'asc')->find(); }
/** * 更新账户日志 * @param $id * @param $incrAmount * @param $note * @param $createdTimeEnd * @return mixed */ public static function updateBalanceLogById($id, $incrAmount, $note, $createdTimeEnd) { try { $obj = Model_Log_AccountBalanceLog::data_access(date('m', strtotime($createdTimeEnd)))->force_master()->filter('id', $id)->find_one(); } catch (Exception $e) { return null; } $obj->amount = $obj->amount + $incrAmount; $obj->note = $note; $obj->createTimeEnd = $createdTimeEnd; $obj->lastUpdate = date('Y-m-d H:i:s'); return $obj->save(); }